names

14 rows where place_id = 650889

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3914504 1995192 1995192 defendant Carter Thomas chapman 650889 650889 Carter, Thomas, of Arrundell, Sussex, chapman 0
3964646 2012241 2012241 defendant Foster Thomas yeoman 650889 650889 Foster, Thomas, of Arrundell, Sussex, yeoman 2
4097737 2059522 2059522 defendant Booth Thomas yeoman 650889 650889 Booth, Thomas, of Arrundell, Sussex, yeoman 0
4110065 2063864 2063864 defendant Strudwick Henry yeoman 650889 650889 Strudwick, Henry, of Arrundell, Sussex, yeoman 0
4114846 2065597 2065597 defendant Allen John innholder 650889 650889 Allen, John, of Arrundell, Sussex, innholder 2
4141279 2075110 2075110 defendant Holland Richard chapman 650889 650889 Holland, Richard, of Arrundell, Sussex, chapman 0
4249231 2112727 2112727 defendant Holland James draper 650889 650889 Holland, James, of Arrundell, Sussex, draper 1
4257374 2115442 2115442 defendant Bowyer Thomas chapman 650889 650889 Bowyer, Thomas, of Arrundell, Sussex, chapman 1
4257379 2115443 2115443 defendant Bowyer Thomas chapman 650889 650889 Bowyer, Thomas, of Arrundell, Sussex, chapman 1
4263728 2117526 2117526 defendant Holland James draper 650889 650889 Holland, James, of Arrundell, Sussex, draper 1
4267029 2118614 2118614 defendant Lusher William gent 650889 650889 Lusher, William, of Arrundell, Sussex, gent 2
4267034 2118615 2118615 defendant Lusher William gent 650889 650889 Lusher, William, of Arrundell, Sussex, gent 2
4304381 2131669 2131669 defendant Wagland Richard beer brewer 650889 650889 Wagland, Richard, of Arrundell, Sussex, beer brewer 1
4324812 2138686 2138686 defendant Marlat James gent 650889 650889 Marlat, James, of Arrundell, Sussex, gent 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);