names

28 rows where place_id = 589152

✎ 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
3596700 1866603 1866603 defendant Jakson William husbandman 589152 589152 Jakson, William, of Strensall, husbandman 0
4050058 2042448 2042448 defendant Percey Richard merchant 589152 589152 Percey, Richard, of Strensall, or of South Creke, Norf, ,merchant 1
4315970 2135699 2135699 defendant Jackson Robert tailor 589152 589152 Jackson, Robert, of Strensall, tailor 0
4559986 2219072 2219072 defendant Henryson John   589152 589152 Henryson, John, of Strensall 0
4637863 2242611 2242611 plaintiff Brygge John   589152 589152 Brygge, John, of Strensall 0
4714151 2269757 2269757 defendant Westowe John smith 589152 589152 Westowe, John, of Strensall, smith 0
4783816 2290956 2290956 defendant de Grene Peter chaplain 589152 589152 de Grene, Peter, of Strensall, chaplain 0
4817538 2301576 2301576 defendant Mounceux Thomas yeoman 589152 589152 Mounceux, Thomas, of Strensall, yeoman 0
5098431 2385970 2385970 plaintiff Vicars Thomas (legal representative) 589152 589152 Vicars, Thomas, of Strensall, executors of 0
5122503 2393012 2393012 plaintiff Vycars Thomas (legal representative) 589152 589152 Vycars, Thomas, of Strensall, executors of 0
5136697 2397256 2397256 defendant Vycars Robert yeoman 589152 589152 Vycars, Robert, of Strensall, yeoman 0
5136698 2397256 2397256 defendant Goweter David   589152 589152 Goweter, David, of Strensall, servant 1
5136699 2397257 2397257 plaintiff Pakenham John   589152 589152 Pakenham, John, of Strensall, priest & clerk 0
5136700 2397257 2397257 defendant Ball Thomas laborer 589152 589152 Ball, Thomas, of Strensall, laborer 0
5136701 2397258 2397258 plaintiff Pakenham John   589152 589152 Pakenham, John, of Strensall, priest & clerk 0
5136702 2397258 2397258 defendant Vycars Robert yeoman 589152 589152 Vycars, Robert, of Strensall, yeoman 0
5136703 2397258 2397258 defendant Watson Robert husbandman 589152 589152 Watson, Robert, of Strensall, husbandman 1
5136704 2397258 2397258 defendant Rayle William husbandman 589152 589152 Rayle, William, of Strensall, husbandman 2
5136705 2397258 2397258 defendant Flaxton William husbandman 589152 589152 Flaxton, William, of strensall, husbandman 3
5141562 2398644 2398644 plaintiff Vicars Thomas (legal representative) 589152 589152 Vicars, Thomas, of Strensall, executors of 0
5141563 2398644 2398644 plaintiff Vycars Robert   589152 589152 (Vycars, Robert, of Strensall 1
5145784 2399905 2399905 defendant Wardrop Robert yeoman 589152 589152 Wardrop, Robert, of Strensall, yeoman 0
5145785 2399905 2399905 defendant Wardrop William yeoman 589152 589152 Wardrop, William, of Strensall, yeoman 1
5166126 2405828 2405828 defendant Wardrop Robert yeoman 589152 589152 Wardrop, Robert, of Strensall, yeoman 0
5166127 2405828 2405828 defendant Wardrop William yeoman 589152 589152 Wardrop, William, of Strensall, yeoman 1
5325669 2452757 2452757 defendant Raylyf or Raylys William husbanman 589152 589152 Raylyf or Raylys, William, of Strensall, husbanman 0
5487498 2501155 2501155 defendant Flaxton William husbandman 589152 589152 Flaxton, William, of Strensall, husbandman 0
5608023 2537416 2537416 defendant Fournes Thomas clerk 589152 589152 Fournes, Thomas, of Strensall, clerk 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);