names

13 rows where case_id = 2316306

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4865893 2316306 2316306 plaintiff Grene John     Grene, John 0
4865894 2316306 2316306 defendant Wath Richard husbandman 763758 763758 Wath, Richard, of Astynby, husbandman 0
4865895 2316306 2316306 defendant Benwer Robert laborer 763758 763758 Benwer, Robert, of Astynby, laborer 1
4865896 2316306 2316306 defendant Barrette William laborer 763758 763758 Barrette, William, of Astynby, laborer 2
4865897 2316306 2316306 defendant John son of Hikson John husbandman 763758 763758 John son of Hikson, John, of Astynby, husbandman 3
4865898 2316306 2316306 defendant Raa Robert laborer 763758 763758 Raa, Robert, of Astynby, laborer 4
4865899 2316306 2316306 defendant Mayneld Thomas husbandman 763758 763758 Mayneld, Thomas, of Astynby, husbandman 5
4865900 2316306 2316306 defendant de Scornton John husbandman 763758 763758 de Scornton, John, of Astynby, husbandman 6
4865901 2316306 2316306 defendant Smyth Thomas husbandman 763758 763758 Smyth, Thomas, of Astynby, husbandman 7
4865902 2316306 2316306 defendant Baron Thomas husbandman 763758 763758 Baron, Thomas, of Astynby, husbandman 8
4865903 2316306 2316306 defendant Noresson John husbandman 763758 763758 Noresson, John, of Astynby, husbandman 9
4865904 2316306 2316306 defendant Showers Roger husbandman 763758 763758 Showers, Roger, of Astynby, husbandman 10
4865905 2316306 2316306 defendant Galghay William husbandman 763758 763758 Galghay, William, of Astynby, husbandman 11

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