names

8 rows where place_id = 746644

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4373537 2155604 2155604 defendant Nelson John husbandman 746644 746644 Nelson, John, of Kilpyn, husbandman 0
4374028 2155782 2155782 defendant Nelson John husbandman 746644 746644 Nelson, John, of Kilpyn, husbandman 0
4441705 2182343 2182343 defendant Holme John de   746644 746644 Holme, John de, of Kilpyn 10
4441707 2182343 2182343 defendant Serjiant John   746644 746644 Serjiant, John, of Kilpyn 12
4511645 2204091 2204091 defendant Arteleux John   746644 746644 Arteleux, John, of Kilpyn 0
4572130 2222834 2222834 defendant Taillour John   746644 746644 Taillour, John, of Kilpyn 1
4572131 2222834 2222834 defendant Taillour Richard   746644 746644 Taillour, Richard, of Kilpyn 2
5099475 2386284 2386284 defendant Maweson John husbandman 746644 746644 Maweson, John, of Kilpyn, husbandman 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);