names

16 rows where place_id = 620810

✎ 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
3737772 1938035 1938035 defendant Burton John gent 620810 620810 (Burton, John, of Ryppon, Yorks, gent 1
3781120 1951831 1951831 defendant Hardweyk Ralph draper 620810 620810 Hardweyk, Ralph, of Ryppon, Yorks, draper 2
3956627 2009383 2009383 defendant Jepson William carrier 620810 620810 Jepson, William, of Ryppon, Yorks, carrier 0
3960034 2010607 2010607 defendant Wharton William gent 620810 620810 Wharton, William, of Ryppon, Yorks, gent 3
4015788 2030331 2030331 defendant Myddelton Marmaduke gent 620810 620810 Myddelton, Marmaduke, of Ryppon, Yorks, gent 0
4055711 2044429 2044429 defendant Harland Thomas chapman 620810 620810 Harland, Thomas, of Ryppon, Yorks, chapman 0
4131332 2071526 2071526 defendant Harlande Thomas merchant 620810 620810 Harlande, Thomas, of Ryppon, Yorks, merchant 0
4189866 2091954 2091954 defendant Samond John gent 620810 620810 Samond, John, of Ryppon, Yorks, gent 0
4193246 2093208 2093208 defendant Locker Henry chapman 620810 620810 Locker, Henry, of Ryppon, Yorks, chapman 1
4299909 2130060 2130060 defendant Cooke Richard yeoman 620810 620810 Cooke, Richard, of Ryppon, Yorks, yeoman 0
4382756 2158937 2158937 defendant Johnson John esq 620810 620810 Johnson, John, of Ryppon, Yorks, esq 0
4817466 2301551 2301551 defendant Wederby John de mercer 620810 620810 Wederby, John de, of Ryppon, Yorks, mercer 0
5318628 2450665 2450665 defendant Symson Richard tailor 620810 620810 Symson, Richard, of Ryppon, Yorks, tailor 0
5451865 2490436 2490436 defendant Wardroper Lawrence dyer 620810 620810 Wardroper, Lawrence, of Ryppon, Yorks, dyer 0
5486937 2500989 2500989 defendant Wardroper Lawrence dyer 620810 620810 Wardroper, Lawrence, of Ryppon, Yorks, dyer 0
5602595 2535705 2535705 defendant Malory John esq 620810 620810 Malory, John, of Ryppon, Yorks, esq 7

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