names

13 rows where place_id = 608734

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3675131 1918250 1918250 defendant Starke Robert husbandman 608734 608734 Starke, Robert, of Apton, husbandman 0
3741427 1939184 1939184 defendant Dyamonte John husbandman 608734 608734 Dyamonte, John, of Apton, husbandman 5
3891663 1987466 1987466 defendant Thakker Stephen, junior husbandman 608734 608734 Thakker, Stephen, junior, of Apton, husbandman 0
3955988 2009165 2009165 defendant Thacker William thatcher 608734 608734 Thacker, William, of Apton, thatcher 0
3955990 2009165 2009165 defendant Seman Richard husbandman 608734 608734 Seman, Richard, of Apton, husbandman 2
4006552 2027123 2027123 defendant Dennys John yeoman 608734 608734 Dennys, John, of Apton, yeoman 1
4129265 2070764 2070764 defendant Flowerdewe John laborer 608734 608734 Flowerdewe, John, of Apton , laborer 3
4141546 2075207 2075207 defendant Leman Robert tailor 608734 608734 Leman, Robert, of Apton, tailor 2
4440697 2182002 2182002 defendant Smyth Roger   608734 608734 Smyth, Roger, of Apton 2
4612285 2234907 2234907 defendant Bergh Geoffrey   608734 608734 Bergh, Geoffrey, of Apton 1
4686902 2261511 2261511 defendant Dlisdon Robert butcher 608734 608734 Dlisdon, Robert, of Apton, butcher 0
4888406 2323174 2323174 defendant Pye William husbandman 608734 608734 Pye, William, of Apton, husbandman 0
5000520 2357022 2357022 defendant Whyte John husbandman 608734 608734 Whyte, John, of Apton, husbandman 5

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