names

11 rows where place_id = 600104

✎ 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
3639688 1907221 1907221 defendant Albon Robert yeoman 600104 600104 Albon, Robert, of Paston, Norf, yeoman 0
3639971 1907315 1907315 defendant Albon Robert yeoman 600104 600104 Albon, Robert, of Paston, Norf, yeoman 0
3699169 1925952 1925952 defendant Sylvern John husbandman 600104 600104 Sylvern, John, of Paston, Norf, husbandman 0
4024522 2033446 2033446 defendant Sore or Shore John yeoman 600104 600104 Sore or Shore, John, of Paston, Norf, yeoman 0
4892544 2324398 2324398 defendant Horntofte John butcher 600104 600104 Horntofte, John, of Paston, Norf, butcher 4
5123202 2393225 2393225 defendant Paston John esq 600104 600104 Paston, John, of Paston, Norf, esq 1
5249730 2430040 2430040 defendant Paston John, junior gent 600104 600104 Paston, John, junior, of Paston, Norf, gent 13
5491290 2502283 2502283 defendant Fraunces Clement husbandman 600104 600104 Fraunces, Clement, of Paston, Norf, husbandman 1
5567090 2524955 2524955 defendant Albon Adam butcher 600104 600104 Albon, Adam, of Paston, Norf, butcher 0
5582054 2529453 2529453 defendant Albon Adam butcher 600104 600104 Albon, Adam, of Paston, Norf, butcher 0
5601155 2535252 2535252 defendant Albon Adam butcher 600104 600104 Albon, Adam, of Paston, Norf, butcher 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);