names

31 rows where place_id = 603871

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3656041 1912142 1912142 plaintiff Buttre Thomas   603871 603871 Buttre, Thomas, of Mersshe 0
3656042 1912142 1912142 defendant (not given) John rector of Hawkesford 603871 603871 Hawkesford, John, of Mersshe, clerk & rector of Lawnton by Dorchester, Oxon 0
3713561 1930551 1930551 defendant Freman William husbandman 603871 603871 Freman, William, of Mersshe, husbandman 2
4544796 2214290 2214290 defendant Leighton Joan   603871 603871 Leighton, Joan, of Mersshe, formerly wife of John 0
4544797 2214290 2214290 defendant Routon John   603871 603871 Routon, John, of Mersshe 1
4544798 2214290 2214290 defendant Longeley Richard   603871 603871 Longeley, Richard, of Mersshe 2
4544799 2214290 2214290 defendant Lancastreshire Roger   603871 603871 Lancastreshire, Roger, of Mersshe 3
4544800 2214290 2214290 defendant Jannes Richard   603871 603871 Jannes, Richard, of Mersshe 4
4545576 2214538 2214538 defendant Leyghton Joan   603871 603871 Leyghton, Joan, of Mersshe, formerly wife of John 0
4545577 2214538 2214538 defendant Routon John   603871 603871 Routon, John, of Mersshe 1
4545578 2214538 2214538 defendant Longeley Richard   603871 603871 Longeley, Richard, of Mersshe 2
4545579 2214538 2214538 defendant Lancashire Roger   603871 603871 Lancashire, Roger, of Mersshe 3
4545580 2214538 2214538 defendant Jannes Richard   603871 603871 Jannes, Richard, of Mersshe 4
4734745 2276021 2276021 defendant Gourney Simon husbandman 603871 603871 Gourney, Simon, of Mersshe, husbandman 0
4807937 2298666 2298666 defendant Munselowe John husbandman 603871 603871 Munselowe, John, of Mersshe, husbandman 1
4896429 2325550 2325550 defendant Cok William husbandman 603871 603871 Cok, William, of Mersshe, husbandman 0
5005054 2358379 2358379 defendant Pencrych Richard husbandman 603871 603871 Pencrych, Richard, of Mersshe, husbandman 1
5005056 2358379 2358379 defendant Hervyn Thomas husbandman 603871 603871 Hervyn, Thomas, of Mersshe, husbandman 3
5026768 2364700 2364700 plaintiff Leyghton Edward   603871 603871 Leyghton, Edward, of Mersshe 3
5149532 2400992 2400992 defendant Pynche Richard husbandman 603871 603871 Pynche, Richard, of Mersshe, husbandman 2
5153511 2402182 2402182 defendant Brounyng John husbandman 603871 603871 Brounyng, John, of Mersshe, husbandman 1
5343483 2458152 2458152 defendant Lombe Bartholomew husbandman 603871 603871 Lombe, Bartholomew, of Mersshe, husbandman 0
5443506 2487968 2487968 defendant Cole Ralph weaver 603871 603871 Cole, Ralph, of Mersshe, weaver 1
5453586 2490965 2490965 defendant Faunteleroy John esq 603871 603871 Faunteleroy, John, of Mersshe, esq 0
5456235 2491779 2491779 defendant Cole Ralph weaver 603871 603871 Cole, Ralph, of Mersshe, weaver 1
5468046 2495383 2495383 defendant Cole Ralph weaver 603871 603871 Cole, Ralph, of Mersshe, weaver 1
5498751 2504569 2504569 defendant Tommes John husbandman 603871 603871 Tommes, John, of Mersshe, husbandman 1
5569371 2525601 2525601 defendant Hawkysford Thomas husbandman 603871 603871 Hawkysford, Thomas, of Mersshe, husbandman 0
5569372 2525601 2525601 defendant Hakys Edmund laborer 603871 603871 Hakys, Edmund, of Mersshe, laborer 1
5580401 2528954 2528954 defendant Triplard Richard husbandman 603871 603871 Triplard, Richard, of Mersshe, husbandman 0
5582340 2529553 2529553 defendant Triplade Richard husbandman 603871 603871 Triplade, Richard, of Mersshe, husbandman 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);