names

15 rows where place_id = 762571

✎ 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
4489134 2197317 2197317 defendant Henryson John   762571 762571 Henryson, John, of Cateryk 2
4500231 2200698 2200698 defendant Wryghtson John   762571 762571 Wryghtson, John, of Cateryk 2
4501171 2200970 2200970 defendant Henryson John   762571 762571 Henryson, John, of Cateryk 0
4556797 2218061 2218061 plaintiff Isleby Thomas   762571 762571 Isleby, Thomas, of Cateryk 0
4665914 2250816 2250816 defendant Smyth William smith 762571 762571 Smyth, William, of Cateryk, smith 0
4671541 2256745 2256745 defendant Hewyk William chaplain 762571 762571 Hewyk, William, of Cateryk, chaplain 0
4930967 2336081 2336081 defendant Thomson Thomas husbandman 762571 762571 Thomson, Thomas, of Cateryk, husbandman 1
4984387 2352261 2352261 defendant Dayvell Thomas chaplain 762571 762571 Dayvell, Thomas, of Cateryk, chaplain 0
4988406 2353499 2353499 defendant Swaldale Richard   762571 762571 Swaldale, Richard, of Cateryk, husb 15
4988425 2353501 2353501 defendant Swaldale Richard husbandman 762571 762571 Swaldale, Richard, of Cateryk, husbandman 12
5232670 2425136 2425136 defendant Sutton Richard husbandman 762571 762571 Sutton, Richard, of Cateryk, husbandman 1
5232671 2425136 2425136 defendant Sherewynd Henry husbandman 762571 762571 Sherewynd, Henry, of Cateryk, husbandman 2
5232672 2425136 2425136 defendant Walker Richard husbandman 762571 762571 Walker, Richard, of Cateryk, husbandman 3
5287358 2441326 2441326 defendant Glover Joh chaplain 762571 762571 Glover, Joh, of Cateryk, chaplain 1
5511899 2508578 2508578 defendant Hall John yeoman 762571 762571 Hall, John, of Cateryk, 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);