names

18 rows where place_id = 627020

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3773710 1949494 1949494 defendant Rychardys John husbandman 627020 627020 Rychardys, John, of Clanfeld, Oxon, husbandman 1
3807879 1960349 1960349 defendant Rychardys John husbandman 627020 627020 Rychardys, John, of Clanfeld, Oxon, husbandman 1
4003857 2026145 2026145 defendant Savage Walter gent 627020 627020 Savage, Walter, of Clanfeld, Oxon, gent 1
4024032 2033298 2033298 defendant Hooper William yeoman 627020 627020 Hooper, William, of Clanfeld, Oxon, yeoman 1
4024036 2033299 2033299 defendant Hooper William yeoman 627020 627020 Hooper, William, of Clanfeld, Oxon, yeoman 1
4035892 2037510 2037510 defendant Hoper William yeoman 627020 627020 Hoper, William, of Clanfeld, Oxon, yeoman 0
4035894 2037511 2037511 defendant Tompkens John yeoman 627020 627020 Tompkens, John, of Clanfeld, Oxon, yeoman 0
4045213 2040744 2040744 defendant Dawes Robert gent 627020 627020 Dawes, Robert, of Clanfeld, Oxon, gent 0
4045215 2040745 2040745 defendant Sperwynke John husbandman 627020 627020 Sperwynke, John, of Clanfeld, Oxon, husbandman 0
4045220 2040747 2040747 defendant Hoper William yeoman 627020 627020 Hoper, William, of Clanfeld, Oxon, yeoman 0
4931653 2336289 2336289 defendant Abram Thomas laborer 627020 627020 Abram, Thomas, of Clanfeld, Oxon, laborer 0
4967143 2347105 2347105 defendant Wyther Thomas husbandman 627020 627020 Wyther, Thomas, of Clanfeld, Oxon, husbandman 0
5069766 2377449 2377449 defendant Notte William husbandman 627020 627020 Notte, William, of Clanfeld, Oxon, husbandman 3
5245865 2428954 2428954 defendant Tyndale Thomas clerk 627020 627020 Tyndale, Thomas, of Clanfeld, Oxon, clerk 0
5326492 2453008 2453008 plaintiff Stokys alias Abraham Thomas (legal representative) 627020 627020 Stokys alias Abraham, Thomas, of Clanfeld, Oxon, executor of 0
5508947 2507653 2507653 defendant Janyver Henry husbandman 627020 627020 Janyver, Henry, of Clanfeld, Oxon, husbandman 1
5588011 2531261 2531261 plaintiff Osmond John   627020 627020 Osmond, John, of Clanfeld, Oxon 0
5588013 2531262 2531262 plaintiff Osmond Thomas husbandman 627020 627020 Osmond, Thomas, of Clanfeld, Oxon, 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);