names

31 rows where place_id = 759672

✎ 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
4463323 2189220 2189220 defendant Wystowe William de   759672 759672 Wystowe, William de, of Shirburn in Elmet 2
4669713 2256229 2256229 defendant Studard Thomas yeoman 759672 759672 Studard, Thomas, of Shirburn in Elmet, yeoman 0
4670775 2256538 2256538 defendant Marsshall William mercer 759672 759672 Marsshall, William, of Shirburn in Elmet, mercer 1
4784044 2291018 2291018 defendant Smyth John yeoman 759672 759672 Smyth, John, of Shirburn in Elmet, yeoman 1
4784046 2291019 2291019 defendant Byngham Thomas husbandman 759672 759672 Byngham, Thomas, of Shirburn in Elmet, husbandman 0
4787503 2292163 2292163 defendant Stodhird Thomas yeoman 759672 759672 Stodhird, Thomas, of Shirburn in Elmet, yeoman 2
4817266 2301493 2301493 defendant Bulmer Thomas laborer 759672 759672 Bulmer, Thomas, of Shirburn in Elmet, laborer 0
4860432 2314628 2314628 defendant Studehird Thomas husbandman 759672 759672 Studehird, Thomas, of Shirburn in Elmet, husbandman 0
4885694 2322401 2322401 defendant Knyghton John butcher 759672 759672 Knyghton, John, of Shirburn in Elmet, butcher 0
4886042 2322494 2322494 defendant Wode Thomas yeoman 759672 759672 Wode, Thomas, of Shirburn in Elmet, yeoman 0
4886043 2322494 2322494 defendant Dene Thomas   759672 759672 Dene, Thomas, of Shirburn in Elmet, mason 1
4892603 2324414 2324414 defendant del Deen Thomas   759672 759672 del Deen, Thomas, of Shirburn in Elmet, mason 0
4980631 2351145 2351145 defendant Studerd Richard husbandman 759672 759672 Studerd, Richard, of Shirburn in Elmet, husbandman 0
4980633 2351145 2351145 defendant Reme or Reine John husbandman 759672 759672 Reme or Reine, John, of Shirburn in Elmet, husbandman 2
5032189 2366293 2366293 defendant Lamson John ostler 759672 759672 Lamson, John, of Shirburn in Elmet, ostler 0
5094711 2384866 2384866 defendant Guy Thomas yeoman 759672 759672 Guy, Thomas, of Shirburn in Elmet, yeoman 8
5094712 2384866 2384866 defendant Squier Henry husbandman 759672 759672 Squier, Henry, of Shirburn in Elmet, husbandman 9
5094713 2384866 2384866 defendant Tatham Giles laborer 759672 759672 Tatham, Giles, of Shirburn in Elmet, laborer 10
5094722 2384867 2384867 defendant Guy Thomas yeoman 759672 759672 Guy, Thomas, of Shirburn in Elmet, yeoman 7
5094723 2384867 2384867 defendant Squyer Henry husbandman 759672 759672 Squyer, Henry, of Shirburn in Elmet, husbandman 8
5094724 2384867 2384867 defendant Taatham Giles laborer 759672 759672 Taatham, Giles, of Shirburn in Elmet, laborer 9
5108444 2388905 2388905 defendant Lambson John yeoman 759672 759672 Lambson, John, of Shirburn in Elmet, yeoman 0
5113534 2390348 2390348 plaintiff Lambson John   759672 759672 Lambson, John, of Shirburn in Elmet 0
5114757 2390730 2390730 defendant Thomson John   759672 759672 Thomson, John, of Shirburn in Elmet, parish clerk 0
5217564 2420876 2420876 defendant Lamson John yeoman 759672 759672 Lamson, John, of Shirburn in Elmet, yeoman 0
5221183 2421897 2421897 plaintiff Lambson John yeoman 759672 759672 Lambson, John, of Shirburn in Elmet, yeoman 0
5236773 2426339 2426339 defendant Stedeman Thomas smith 759672 759672 Stedeman, Thomas, of Shirburn in Elmet, smith 4
5375704 2467991 2467991 defendant Pannall Richard yeoman 759672 759672 Pannall, Richard, of Shirburn in Elmet, yeoman 1
5375732 2468001 2468001 defendant Pannall Richard yeoman 759672 759672 Pannall, Richard, of Shirburn in Elmet, yeoman 1
5378807 2468957 2468957 defendant Mene Thomas butcher 759672 759672 Mene, Thomas, of Shirburn in Elmet, butcher 1
5619710 2550023 2550023 defendant Bernby John de   759672 759672 Bernby, John de, of Shirburn in Elmet 1

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