names

8 rows where place_id = 809450

✎ 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
4456663 2187109 2187109 defendant Moureland Henry   809450 809450 Moureland, Henry, of Isale, servant of Thomas Milner 4
4815677 2301008 2301008 plaintiff Bunthe Thomas   809450 809450 Bunthe, Thomas, of Isale, vicar 2
4831923 2306012 2306012 defendant Symson John yeoman 809450 809450 Symson, John, of Isale, yeoman 1
4831924 2306012 2306012 defendant Colt Thomas yeoman 809450 809450 Colt, Thomas, of Isale, yeoman 2
4848707 2311063 2311063 defendant Bouche Thomas clerk 809450 809450 Bouche, Thomas, of Isale, clerk 2
4848708 2311063 2311063 defendant Stanewykys Thomas gent 809450 809450 Stanewykys, Thomas, of Isale, gent 3
5535613 2515665 2515665 defendant Lee John gent 809450 809450 Lee, John, of Isale, Cumber, gent 14
5535633 2515666 2515666 defendant Lee John gent 809450 809450 Lee, John, of Isale, Cumber, gent 14

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