names

10 rows where place_id = 763187

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4494995 2199123 2199123 defendant Wharrome William   763187 763187 Wharrome, William, of Skydby 0
4500761 2200851 2200851 defendant Wharrome William   763187 763187 Wharrome, William, of Skydby 0
4795623 2294781 2294781 defendant Olyver William husbandman 763187 763187 Olyver, William, of Skydby, husbandman 2
4832790 2306275 2306275 defendant Olyver William husbandman 763187 763187 Olyver William, of Skydby, husbandman 13
4847581 2310740 2310740 defendant Barnes John husbandman 763187 763187 Barnes, John, of Skydby, husbandman 1
4847588 2310741 2310741 defendant Smyth John, sen husbandman 763187 763187 Smyth, John, sen, of Skydby, husbandman 1
4878920 2320342 2320342 plaintiff Tomson William, junior   763187 763187 Tomson, William, junior, of Skydby 0
5594030 2533119 2533119 defendant Sernton Richard husbandman 763187 763187 Sernton, Richard, of Skydby, husbandman 12
5594050 2533120 2533120 defendant Darnton Richard husbandman 763187 763187 Darnton, Richard, of Skydby, husbandman 14
5619249 2549868 2549868 defendant Teller William   763187 763187 Teller, William, of Skydby 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);