names

26 rows where place_id = 605862

✎ 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
3663192 1914406 1914406 defendant Stele Peter clerk 605862 605862 Stele, Peter, of Holwell, clerk 0
3663196 1914408 1914408 defendant Brett Peter clerk 605862 605862 Brett, Peter, of Holwell, clerk 0
3770326 1948391 1948391 defendant Olyver Richard husbandman 605862 605862 Olyver, Richard, of Holwell, husbandman 0
3817040 1963241 1963241 defendant Wyke Thomas husbandman 605862 605862 Wyke, Thomas, of Holwell, husbandman 1
3893538 1988065 1988065 defendant Fage Constance singlewoman 605862 605862 Fage, Constance, of Holwell, singlewoman 0
3893539 1988065 1988065 defendant Fage John clerk 605862 605862 Fage, John, of Holwell, clerk 1
3961503 2011121 2011121 defendant Harrold Robert yeoman 605862 605862 (Harrold, Robert, of Holwell, yeoman 1
4130944 2071379 2071379 defendant Ellys Richard yeoman 605862 605862 Ellys, Richard, of Holwell, yeoman 2
4381424 2158464 2158464 defendant Chaffy John yeoman 605862 605862 Chaffy, John, of Holwell, yeoman 1
4667766 2255627 2255627 defendant Cok John husbandman 605862 605862 Cok, John, of Holwell, husbandman 1
4667767 2255627 2255627 defendant Ryvel William husbandman 605862 605862 Ryvel, William, of Holwell, husbandman 2
4667768 2255627 2255627 defendant Burbage John husbandman 605862 605862 Burbage, John, of Holwell, husbandman 3
4667769 2255627 2255627 defendant Burbage Thomas husbandman 605862 605862 Burbage, Thomas, of Holwell, husbandman 4
4744557 2278931 2278931 defendant Coke John husbandman 605862 605862 Coke, John, of Holwell, husbandman 3
4952057 2342585 2342585 defendant Mower William husbandman 605862 605862 Mower, William, of Holwell, husbandman 3
4952061 2342585 2342585 defendant Deye Thomas husbandman 605862 605862 Deye, Thomas, of Holwell, husbandman 7
4977465 2350226 2350226 defendant Marschall John, junior husbandman 605862 605862 Marschall, John, junior, of Holwell, husbandman 0
5020487 2362881 2362881 defendant Smyth William husbandman 605862 605862 Smyth, William, of Holwell, husbandman 1
5044785 2370076 2370076 defendant Hoghkynson Thomas yeoman 605862 605862 Hoghkynson, Thomas, of Holwell, yeoman 2
5250515 2430267 2430267 defendant Mower Robert husbandman 605862 605862 Mower, Robert, of Holwell, husbandman 0
5257646 2432512 2432512 defendant Holwell Alice widow 605862 605862 Holwell, Alice, of Holwell, widow 4
5315303 2449633 2449633 plaintiff Lucas Richard   605862 605862 Lucas, Richard, of Holwell 1
5315520 2449710 2449710 plaintiff Cook Robert   605862 605862 Cook, Robert, of Holwell 0
5315521 2449710 2449710 plaintiff Lucas Richard   605862 605862 Lucas, Richard, of Holwell 1
5565157 2524397 2524397 defendant Pole William husbandman 605862 605862 Pole, William, of Holwell, husbandman 0
5587513 2531109 2531109 defendant Hurst John husbandman 605862 605862 Hurst, John, of Holwell, 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);