names

16 rows where place_id = 590837

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602468 1868432 1868432 plaintiff Byllesby John   590837 590837 Byllesby, John, of Byllesby 0
3644749 1908762 1908762 defendant Byllesby Andrew   590837 590837 Byllesby, Andrew, of Byllesby, knight 0
3665439 1915139 1915139 defendant Lynley John tailor 590837 590837 Lynley, John, of Byllesby, tailor 0
3665440 1915139 1915139 defendant Lyley Thomas laborer 590837 590837 Lyley, Thomas, of Byllesby, laborer 1
3759137 1944845 1944845 defendant Barge Thomas yeoman 590837 590837 Barge, Thomas, of Byllesby, yeoman 1
3878855 1983180 1983180 defendant Grundon John husbandman 590837 590837 Grundon, John, of Byllesby, husbandman 0
3878856 1983180 1983180 defendant Cowlson Robert husbandman 590837 590837 Cowlson, Robert, of Byllesby, husbandman 1
3980020 2017617 2017617 defendant Fox Edward weaver 590837 590837 Fox Edward, of Byllesby, weaver 1
3980023 2017618 2017618 defendant Fox Edward weaver 590837 590837 Fox, Edward, of Byllesby, weaver 1
4189202 2091717 2091717 defendant Davyson John yeoman 590837 590837 Davyson, John, of Byllesby, yeoman 0
4799405 2295993 2295993 defendant Saleby Andrew   590837 590837 Saleby, Andrew, of Byllesby, wright 1
5061957 2375178 2375178 defendant Pepyr Thomas husbandman 590837 590837 Pepyr, Thomas, of Byllesby, husbandman 0
5061958 2375178 2375178 defendant Cracroft Thomas husbandman 590837 590837 Cracroft, Thomas, of Byllesby, husbandman 1
5108648 2388964 2388964 defendant Lourdewyn Joan widow 590837 590837 Lourdewyn, Joan, of Byllesby, widow 0
5569738 2525721 2525721 defendant Byllysby John (legal representative) 590837 590837 Byllysby, John, of Byllesby, gent, executors of 0
5569740 2525721 2525721 defendant Byllesby Andrew gent 590837 590837 Byllesby, Andrew, of Byllesby, gent 2

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