names

11 rows where place_id = 698724

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4125515 2069408 2069408 defendant Makernes William yeoman 698724 698724 Makernes, William, of Bolby, yeoman 0
4483280 2195469 2195469 defendant Forster John   698724 698724 Forster, John, of Bolby 1
4581389 2225646 2225646 defendant Forster Robert   698724 698724 Forster, Robert, of Bolby 0
4581390 2225646 2225646 defendant Forster Walter   698724 698724 Forster, Walter, of Bolby 1
4600276 2231314 2231314 defendant Drapere John   698724 698724 Drapere, John, of Bolby 0
4600277 2231314 2231314 defendant Blissott Joan   698724 698724 Blissott, Joan, of Bolby, formerly wife of John 1
4625988 2239084 2239084 defendant Ellerby William   698724 698724 Ellerby, William, of Bolby 0
4646244 2244972 2244972 defendant Ellerby Wialim   698724 698724 Ellerby, Wialim, of Bolby 0
4646246 2244973 2244973 defendant Ellerby William   698724 698724 Ellerby, William, of Bolby 0
5127434 2394500 2394500 defendant Clerk Thomas husbandman 698724 698724 Clerk, Thomas, of Bolby, husbandman 23
5166500 2405922 2405922 defendant Clerk Thomas husbandman 698724 698724 Clerk, Thomas, of Bolby, husbandman 21

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