names

40 rows where place_id = 595698

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621509 1874268 1874268 defendant Rose Roger draper 595698 595698 Rose, Roger, of Magna Chesterford, draper 0
3629621 1904117 1904117 defendant Lorkyn Thomas yeoman 595698 595698 Lorkyn, Thomas, of Magna Chesterford, yeoman 0
3629622 1904117 1904117 defendant Williamson Leonard yeoman 595698 595698 Williamson, Leonard, of Magna Chesterford, yeoman 1
3629625 1904118 1904118 defendant Lorkyn Thomas yeoman 595698 595698 Lorkyn, Thomas, of Magna Chesterford, yeoman 0
3629626 1904118 1904118 defendant Williamson Leonard yeoman 595698 595698 Williamson, Leonard, of Magna Chesterford, yeoman 1
3643111 1908287 1908287 defendant Michellfelde Reginald butcher 595698 595698 Michellfelde, Reginald, of Magna Chesterford, butcher 0
3678836 1919448 1919448 defendant Shether John gent 595698 595698 Shether, John, of Magna Chesterford, gent 2
3678837 1919448 1919448 defendant Lamberd Thomas yeoman 595698 595698 Lamberd, Thomas, of Magna Chesterford, yeoman 3
3694971 1924638 1924638 defendant Newman Thomas butcher 595698 595698 Newman, Thomas, of Magna Chesterford, butcher 1
3732852 1936503 1936503 defendant Wynterflode John husbandman 595698 595698 Wynterflode, John, of Magna Chesterford, husbandman 0
3752653 1942760 1942760 plaintiff Reynold John husbandman 595698 595698 Reynold, John, of Magna Chesterford, husbandman 1
3756740 1944081 1944081 defendant Wyngterflod John husbandman 595698 595698 Wyngterflod, John, of Magna Chesterford, husbandman 0
3757774 1944412 1944412 defendant Shether John yeoman 595698 595698 Shether, John, of Magna Chesterford, yeoman 1
3818821 1963794 1963794 defendant Newman Thomas butcher 595698 595698 Newman, Thomas, of Magna Chesterford, butcher 0
3830191 1967337 1967337 defendant Joyce Thomas yeoman 595698 595698 Joyce, Thomas, of Magna Chesterford, yeoman 1
3832603 1968120 1968120 defendant Thurmond Thomas butcher 595698 595698 Thurmond, Thomas, of Magna Chesterford, butcher 0
3861182 1977217 1977217 defendant Thurmond Thomas butcher 595698 595698 Thurmond, Thomas, of Magna Chesterford, butcher 0
3901586 1990756 1990756 defendant Baker John gent 595698 595698 Baker, John, of Magna Chesterford, gent 1
4010626 2028572 2028572 defendant Porter William husbandman 595698 595698 Porter, William, of Magna Chesterford, husbandman 1
4158236 2080952 2080952 defendant Baker Edmund gent 595698 595698 Baker, Edmund, of Magna Chesterford, gent 2
4888216 2323122 2323122 defendant Taillour John husbandman 595698 595698 Taillour, John, of Magna Chesterford, husbandman 0
5026251 2364569 2364569 defendant Asshedon John husbandman 595698 595698 Asshedon, John, of Magna Chesterford, husbandman 0
5106798 2388416 2388416 defendant Joys Thomas husbandman 595698 595698 Joys, Thomas, of Magna Chesterford, husbandman 3
5122648 2393056 2393056 defendant Burgh Richard smith 595698 595698 Burgh, Richard, of Magna Chesterford, smith 0
5250034 2430120 2430120 defendant Joce Thomas   595698 595698 Joce, Thomas, of Magna Chesterford, administrators of 1
5250035 2430120 2430120 defendant Joce Margaret widow 595698 595698 (Joce, Margaret, of Magna Chesterford, widow 2
5250036 2430120 2430120 defendant Rouneham William husbandman 595698 595698 Rouneham, William, of Magna Chesterford, husbandman 3
5252611 2430932 2430932 defendant Derby William tailor 595698 595698 Derby, William, of Magna Chesterford, tailor 0
5290324 2442177 2442177 defendant Mariot John husbandman 595698 595698 Mariot, John, of Magna Chesterford, husbandman 2
5344650 2458500 2458500 defendant Pecok George skinner 595698 595698 Pecok, George, of Magna Chesterford, skinner 0
5478665 2498646 2498646 defendant Bawede John yeoman 595698 595698 Bawede, John, of Magna Chesterford, yeoman 0
5478666 2498646 2498646 defendant Smyth Stephen   595698 595698 Smyth, Stephen, of Magna Chesterford 1
5478667 2498646 2498646 defendant Harrys John laborer 595698 595698 Harrys, John, of Magna Chesterford, laborer 2
5521246 2511463 2511463 defendant Foster John carpenter 595698 595698 Foster, John, of Magna Chesterford, carpenter 1
5541848 2517564 2517564 defendant Bawde alias Wright Robert carpenter 595698 595698 Bawde alias Wright, Robert, of Magna Chesterford, carpenter 0
5543830 2518179 2518179 defendant Ramson William yeoman 595698 595698 Ramson, William, of Magna Chesterford, yeoman 0
5567841 2525174 2525174 defendant Sell George husbandman 595698 595698 Sell, George, of Magna Chesterford, husbandman 0
5567842 2525174 2525174 defendant Kyrby John   595698 595698 Kyrby, John, of Magna Chesterford, shepherd 1
5567843 2525174 2525174 defendant Hawe Robert   595698 595698 Hawe, Robert, of Magna Chesterford, shepherd 2
5567844 2525174 2525174 defendant Skyngham Thomas husbandman 595698 595698 Skyngham, Thomas, of Magna Chesterford, husbandman 3

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);