names

7 rows where place_id = 729324

✎ 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
4281966 2123593 2123593 defendant Pertre John yeoman 729324 729324 Pertre, John, of Alington, yeoman 0
4281967 2123593 2123593 defendant Harper Edward yeoman 729324 729324 Harper, Edward, of Alington, yeoman 1
4336562 2142518 2142518 defendant Rous Thomas, junior gent 729324 729324 Rous, Thomas, junior, of Alington, gent 20
4337664 2142921 2142921 defendant Peartre John husbandman 729324 729324 Peartre, John, of Alington, husbandman 0
4353810 2148554 2148554 defendant Peartree John yeoman 729324 729324 Peartree, John, of Alington, yeoman 0
4353811 2148554 2148554 defendant Harper Edward yeoman 729324 729324 Harper, Edward, of Alington, yeoman 1
4463449 2189263 2189263 defendant Doken Simon   729324 729324 Doken, Simon, of Alington 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);