names

12 rows where place_id = 871073

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5304925 2446477 2446477 defendant Edward William husbandman 871073 871073 Edward, William, of Northoresby, husbandman 5
5304929 2446477 2446477 defendant Lyson John husbandman 871073 871073 Lyson, John, of Northoresby, husbandman 9
5304930 2446477 2446477 defendant Thorald Thomas husbandman 871073 871073 Thorald, Thomas, of Northoresby, husbandman 10
5380548 2469487 2469487 defendant Tharold John, senior husbandman 871073 871073 Tharold, John, senior, of Northoresby, husbandman 5
5385292 2470870 2470870 defendant Thorold John, senior husbandman 871073 871073 Thorold, John, senior, of Northoresby, husbandman 1
5385293 2470870 2470870 defendant Thorold John, junior yeoman 871073 871073 Thorold, John, junior, of Northoresby, yeoman 2
5386612 2471234 2471234 defendant Tharold John, junior yeoman 871073 871073 Tharold, John, junior, of Northoresby, yeoman 1
5387258 2471431 2471431 defendant Clayton Simon husbandman 871073 871073 Clayton, Simon, of Northoresby, husbandman 1
5398918 2474760 2474760 defendant Throld John, junior yeoman 871073 871073 Throld, John, junior, of Northoresby, yeoman 1
5441343 2487328 2487328 defendant _old jun yeoman 871073 871073 _old, jun, of Northoresby, yeoman 1
5459949 2492905 2492905 defendant Edward William husbandman 871073 871073 Edward, William, of Northoresby, husbandman 1
5459950 2492905 2492905 defendant Route William husbandman 871073 871073 Route, William, of Northoresby, husbandman 2

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