names

9 rows where place_id = 614289

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3702924 1927182 1927182 defendant Cooke John husbandman 614289 614289 Cooke, John, of Quinton, husbandman 15
4367205 2153330 2153330 defendant Lodebroke John, junior yeoman 614289 614289 Lodebroke, John, junior, of Quinton, yeoman 1
4756557 2282413 2282413 plaintiff Berde John   614289 614289 Berde, John, of Quinton 0
4778501 2289254 2289254 plaintiff Berde John   614289 614289 Berde, John, of Quinton 0
4993584 2354955 2354955 defendant Laurence John husbandman 614289 614289 Laurence, John, of Quinton, husbandman 0
5086485 2382437 2382437 defendant Travell John, senior husbandman 614289 614289 Travell, John, senior, of Quinton, husbandman 0
5086486 2382437 2382437 defendant Travell Nicholas husbandman 614289 614289 Travell, Nicholas, of Quinton, husbandman 1
5086488 2382437 2382437 defendant Travell John, junior husbandman 614289 614289 Travell, John, junior, of Quinton, husbandman 3
5621557 2550642 2550642 defendant Burgh John   614289 614289 Burgh, John, of Quinton 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);