names

8 rows where place_id = 644876

✎ 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
3882440 1984392 1984392 defendant Lee Hugh yeoman 644876 644876 Lee, Hugh, of Drayton Bassett, yeoman 0
3882441 1984392 1984392 defendant Wylcok John husbandman 644876 644876 Wylcok, John, of Drayton Bassett, husbandman 1
3908548 1993157 1993157 defendant Athorpe John husbandman 644876 644876 Athorpe, John, of Drayton Bassett, husbandman 0
4171102 2085366 2085366 defendant Robynson John gent 644876 644876 Robynson, John, of Drayton Bassett, gent 23
4365345 2152669 2152669 defendant Nield James yeoman 644876 644876 Nield, James, of Drayton Bassett, yeoman 2
5429504 2483757 2483757 defendant Denham William laborer 644876 644876 Denham, William, of Drayton Bassett, laborer 0
5429506 2483758 2483758 defendant Donham William laborer 644876 644876 Donham, William, of Drayton Bassett, laborer 0
5429508 2483759 2483759 defendant Donham William laborer 644876 644876 Donham, William, of Drayton Bassett, 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);