names

19 rows where place_id = 592716

✎ 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
3608620 1870358 1870358 defendant Carpenter John butcher 592716 592716 Carpenter, John, of Asshetysford, butcher 0
3643976 1908548 1908548 defendant Dower John tailor 592716 592716 Dower, John, of Asshetysford, tailor 0
3700945 1926543 1926543 plaintiff Bereworth Richard   592716 592716 Bereworth, Richard, of Asshetysford 0
3717768 1931858 1931858 defendant Woodward Edward gent 592716 592716 Woodward, Edward, of Asshetysford, gent 0
3724343 1933901 1933901 defendant Broun John yeoman 592716 592716 Broun, John, of Asshetysford, yeoman 0
3730677 1935830 1935830 defendant Wodeward Edward yeoman 592716 592716 Wodeward, Edward, of Asshetysford, yeoman 0
3730766 1935847 1935847 defendant Wodeward Edward yeoman 592716 592716 Wodeward, Edward, of Asshetysford, yeoman 1
3747835 1941246 1941246 defendant Wodeward Edward gent 592716 592716 Wodeward, Edward, of Asshetysford, gent 0
3787996 1954036 1954036 defendant Netter John husbandman 592716 592716 Netter, John, of Asshetysford, husbandman 0
3804199 1959246 1959246 defendant Netter John husbandman 592716 592716 Netter, John, of Asshetysford, husbandman 0
3861542 1977323 1977323 defendant Butter Richard husbandman 592716 592716 Butter, Richard, of Asshetysford, husbandman 1
3861552 1977325 1977325 defendant Butter Richard husbandman 592716 592716 Butter, Richard, of Asshetysford, husbandman 1
3871232 1980632 1980632 defendant Hamond Martin butcher 592716 592716 Hamond, Martin, of Asshetysford, butcher 0
4162654 2082497 2082497 defendant Topley Edward tailor 592716 592716 Topley, Edward, of Asshetysford, tailor 3
5131661 2395742 2395742 defendant Ynge John laborer 592716 592716 Ynge, John, of Asshetysford, laborer 0
5555140 2521510 2521510 defendant Griffyn Maragret widow 592716 592716 Griffyn, Maragret, of Asshetysford, widow 0
5555141 2521510 2521510 defendant Assherst Thomas tailor 592716 592716 Assherst, Thomas, of Asshetysford, tailor 1
5591308 2532250 2532250 defendant Fogge John esq 592716 592716 Fogge, John, of Asshetysford, esq 0
5625950 2552073 2552073 defendant Roger Hugh laborer 592716 592716 Roger, Hugh, of Asshetysford, laborer 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);