names

10 rows where place_id = 614642

✎ 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
3704733 1927769 1927769 defendant Mathew Richard husbandman 614642 614642 Mathew, Richard, of Langley Burell, husbandman 0
3895702 1988768 1988768 defendant Wastefeld Richard husbandman 614642 614642 Wastefeld, Richard, of Langley Burell, husbandman 0
4130107 2071074 2071074 defendant Reade Humphrey gent 614642 614642 Reade, Humphrey, of Langley Burell, gent 0
4153533 2079329 2079329 defendant Reade Humphrey gent 614642 614642 Reade, Humphrey, of Langley Burell, gent 0
5053681 2372701 2372701 defendant Brewer John husbandman 614642 614642 Brewer, John, of Langley Burell, husbandman 12
5053682 2372701 2372701 defendant Brewer Thomas husbandman 614642 614642 Brewer, Thomas, of Langley Burell, husbandman 13
5223293 2422505 2422505 defendant Wodelond Richard tailor 614642 614642 Wodelond, Richard, of Langley Burell, tailor 7
5325905 2452833 2452833 defendant Brewer John husbandman 614642 614642 Brewer, John, of Langley Burell, husbandman 2
5325909 2452834 2452834 defendant Brewer John husbandman 614642 614642 Brewer, John, of Langley Burell, husbandman 2
5349079 2459840 2459840 defendant Poterne Robert husbandman 614642 614642 Poterne, Robert, of Langley Burell, husbandman 2

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