names

13 rows where place_id = 667651

✎ 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
3985941 2019738 2019738 defendant Lluwellen David John yeoman 667651 667651 Lluwellen, David John, of Bryngwyn, yeoman 0
3997189 2023765 2023765 plaintiff Duberley Thomas   667651 667651 Duberley, Thomas, of Bryngwyn 0
4005655 2026796 2026796 defendant William Philip John yeoman 667651 667651 William, Philip John, of Bryngwyn, yeoman 0
4005656 2026796 2026796 defendant William Thomas David yeoman 667651 667651 William, Thomas David, of Bryngwyn, yeoman 1
4037313 2038007 2038007 defendant Dubberlowe Thomas yeoman 667651 667651 Dubberlowe, Thomas, of Bryngwyn, yeoman 7
4049596 2042295 2042295 plaintiff Vaughan Thomas   667651 667651 Vaughan, Thomas, of Bryngwyn 0
4049598 2042296 2042296 plaintiff Vaughan Thomas   667651 667651 Vaughan, Thomas, of Bryngwyn 0
4080022 2053159 2053159 defendant vergh Thomas Jane widow 667651 667651 vergh Thomas, Jane, of Bryngwyn, widow 0
4107920 2063107 2063107 defendant ap Jevan Thomas yeoman 667651 667651 ap Jevan, Thomas, of Bryngwyn, yeoman 1
4149073 2077797 2077797 defendant Griggith Richard Payres ap John gent 667651 667651 Griggith, Richard Payres ap John, of Bryngwyn, gent 2
4281187 2123327 2123327 defendant ap Jenkyn James yeoman 667651 667651 ap Jenkyn, James, of Bryngwyn, yeoman 1
4370286 2154431 2154431 defendant Jenkyn Thomas yeoman 667651 667651 Jenkyn, Thomas, of Bryngwyn, yeoman 1
4371541 2154874 2154874 defendant Prosser Howell Thomas husbandman 667651 667651 Prosser, Howell Thomas, of Bryngwyn, 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);