names

11 rows where place_id = 593355

✎ 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
3611471 1871261 1871261 defendant Sapurton John gent 593355 593355 Sapurton, John, of Sapurton, gent 0
3650403 1910496 1910496 defendant Longford George   593355 593355 Longford, George, of Sapurton, Derbs gent 0
3713224 1930441 1930441 defendant Gybbys John husbandman 593355 593355 Gybbys, John, of Sapurton, husbandman 0
3713226 1930442 1930442 defendant Gybbys John husbandman 593355 593355 Gybbys, John, of Sapurton, husbandman 0
3713228 1930443 1930443 defendant Gybbys John husbandman 593355 593355 Gybbys, John, of Sapurton, husbandman 0
4588789 2227868 2227868 defendant Sapurton John, sen   593355 593355 Sapurton, John, sen, of Sapurton 2
4588798 2227869 2227869 defendant Sapurton John, sen   593355 593355 Sapurton, John, sen, of Sapurton 2
4684382 2260721 2260721 defendant Sapurton Thomas husbandman 593355 593355 Sapurton, Thomas, of Sapurton, husbandman 1
4798145 2295614 2295614 defendant Maserd William, junior husbandman 593355 593355 Maserd, William, junior, of Sapurton, husbandman 0
4991032 2354206 2354206 defendant Quyncy Thomas husbandman 593355 593355 Quyncy, Thomas, of Sapurton, husbandman 0
5298815 2444631 2444631 defendant Sapurton Thomas gent 593355 593355 Sapurton, Thomas, of Sapurton, gent 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);