names

7 rows where place_id = 669560

✎ 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
3993671 2022480 2022480 defendant Savage Thomas yeoman 669560 669560 Savage, Thomas, of Inkepen, Berks, yeoman 0
3993674 2022481 2022481 defendant Savage Thomas yeoman 669560 669560 Savage, Thomas, of Inkepen, Berks, yeoman 0
4653751 2247093 2247093 defendant Helle William husbandman 669560 669560 Helle, William, of Inkepen, Berks, Berks, husbandman 13
5149967 2401123 2401123 defendant Sedemont John clerk 669560 669560 Sedemont, John, of Inkepen, Berks, clerk 0
5149969 2401124 2401124 defendant Sedemont John clerk 669560 669560 Sedemont, John, of Inkepen, Berks, clerk 0
5168683 2406566 2406566 defendant Sedemont John clerk 669560 669560 Sedemont, John, of Inkepen, Berks, clerk 0
5204472 2417058 2417058 defendant Sedemont John clerk 669560 669560 Sedemont, John, of Inkepen, Berks, clerk 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);