names

38 rows where place_id = 602061

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648258 1909853 1909853 defendant Leyghton William gent 602061 602061 Leyghton, William, of Leyghton, gent 1
3787992 1954034 1954034 defendant Baldwyn Reginald smith 602061 602061 Baldwyn, Reginald, of Leyghton, smith 0
3791550 1955196 1955196 defendant Wyllyngys Thomas husbandman 602061 602061 Wyllyngys, Thomas, of Leyghton, husbandman 0
3808617 1960574 1960574 defendant Wyllyng Thomas husbandman 602061 602061 Wyllyng, Thomas, of Leyghton, husbandman 3
4010596 2028564 2028564 defendant Gryffyth William tailor 602061 602061 Gryffyth, William, of Leyghton, tailor 9
4390076 2161301 2161301 defendant Leighton John gent 602061 602061 Leighton, John, of Leyghton, gent 0
4471696 2191814 2191814 defendant Bocher John   602061 602061 Bocher, John, of Leyghton 0
4501794 2201156 2201156 defendant Colle John   602061 602061 Colle, John, of Leyghton 0
4568958 2221877 2221877 defendant Martyn John   602061 602061 (Martyn, John, of Leyghton 1
4586125 2227084 2227084 defendant Terry Thomas   602061 602061 Terry, Thomas, of Leyghton 1
4586696 2227246 2227246 defendant Warde William   602061 602061 Warde, William, of Leyghton 1
4601918 2231826 2231826 plaintiff Ward William   602061 602061 Ward, William, of Leyghton 0
4601919 2231826 2231826 defendant Myrrell Robert   602061 602061 Myrrell, Robert, of Leyghton 0
4601921 2231826 2231826 defendant Dixy John   602061 602061 Dixy, John, of Leyghton 2
4645560 2244770 2244770 plaintiff North John   602061 602061 North, John, of Leyghton 0
4727297 2273792 2273792 defendant Spencer Hugh husbandman 602061 602061 Spencer, Hugh, of Leyghton, husbandman 0
4727298 2273792 2273792 defendant Godale John butcher 602061 602061 Godale, John, of Leyghton, butcher 1
4758149 2282922 2282922 defendant Carter William laborer 602061 602061 Carter, William, of Leyghton, laborer 0
4778732 2289323 2289323 defendant Smyth Alan husbandman 602061 602061 Smyth, Alan, of Leyghton, husbandman 2
4835534 2307104 2307104 plaintiff Gerbray William   602061 602061 Gerbray, William, of Leyghton 1
4858389 2313996 2313996 defendant Coteler John butcher 602061 602061 Coteler, John, of Leyghton, butcher 0
4866041 2316348 2316348 defendant Dagenhale William husbandman 602061 602061 Dagenhale, William, of Leyghton, husbandman 0
4876779 2319711 2319711 defendant Shirlok John husbandman 602061 602061 Shirlok, John, of Leyghton, husbandman 2
4884350 2322011 2322011 defendant Martyn Thomas husbandman 602061 602061 Martyn, Thomas, of Leyghton, husbandman 0
4893746 2324738 2324738 defendant Martyn Thomas husbandman 602061 602061 Martyn, Thomas, of Leyghton, husbandman 0
4905988 2328473 2328473 defendant Gyddyng Thomas husbandman 602061 602061 Gyddyng, Thomas, of Leyghton, husbandman 0
4905989 2328473 2328473 defendant Box Walter husbandman 602061 602061 Box, Walter, of Leyghton, husbandman 1
4925803 2334502 2334502 defendant Frere John husbandman 602061 602061 Frere, John, of Leyghton, husbandman 2
4925804 2334502 2334502 defendant Decon Richard husbandman 602061 602061 Decon, Richard, of Leyghton, husbandman 3
5105001 2387903 2387903 defendant Lord John   602061 602061 Lord, John, of Leyghton 0
5105023 2387905 2387905 defendant Lord John   602061 602061 Lord, John, of Leyghton 1
5142887 2399048 2399048 plaintiff Wyrall John   602061 602061 Wyrall, John, of Leyghton 0
5145864 2399921 2399921 defendant Lorde John   602061 602061 Lorde, John, of Leyghton 1
5306927 2447071 2447071 defendant Horsman Thomas husbandman 602061 602061 Horsman, Thomas, of Leyghton, husbandman 3
5324254 2452343 2452343 defendant Cullan Eleanor widow 602061 602061 Cullan, Eleanor, of Leyghton, widow 2
5509738 2507876 2507876 defendant Godeynche Richard husbandman 602061 602061 Godeynche, Richard, of Leyghton, husbandman 1
5555364 2521573 2521573 defendant Bentley Richard yeoman 602061 602061 Bentley, Richard, of Leyghton, yeoman 0
5624670 2551653 2551653 defendant Neleson Roger yeoman 602061 602061 Neleson, Roger, of Leyghton, yeoman 0

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);