names

23 rows where place_id = 648543

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3902120 1990943 1990943 defendant Wylsse Thomas husbandman 648543 648543 Wylsse, Thomas, of Dymock, husbandman 1
3902121 1990943 1990943 defendant Smyth John laborer 648543 648543 Smyth, John, of Dymock, laborer 2
3912697 1994581 1994581 defendant Wylce Thomas yeoman 648543 648543 Wylce, Thomas, of Dymock, yeoman 0
3980700 2017859 2017859 defendant Forster Richard gent 648543 648543 Forster, Richard, of Dymock, gent 1
3980701 2017859 2017859 defendant Bastan Florence gent 648543 648543 Bastan, Florence, of Dymock, gent 2
3980702 2017859 2017859 defendant Cowper William yeoman 648543 648543 Cowper, William, of Dymock, yeoman 3
3988470 2020620 2020620 defendant Whooper John husbandman 648543 648543 Whooper, John, of Dymock, husbandman 0
4021424 2032388 2032388 defendant Wylse Thomas butcher 648543 648543 Wylse, Thomas, of Dymock, butcher 2
4063124 2047110 2047110 defendant Sowle George weaver 648543 648543 Sowle, George, of Dymock, weaver 0
4086453 2055438 2055438 defendant Hale Richard husbandman 648543 648543 Hale, Richard, of Dymock, husbandman 0
4086454 2055438 2055438 defendant Siblis John husbandman 648543 648543 Siblis, John, of Dymock, husbandman 1
4118054 2066742 2066742 defendant Hill William yeoman 648543 648543 Hill, William, of Dymock, yeoman 2
4210631 2099274 2099274 defendant Bradford Thomas yeoman 648543 648543 Bradford, Thomas, of Dymock, yeoman 0
4210635 2099276 2099276 defendant Syblys John yeoman 648543 648543 Syblys, John, of Dymock, yeoman 0
4242377 2110450 2110450 defendant Weale Thomas yeoman 648543 648543 Weale, Thomas, of Dymock, yeoman 1
4284267 2124425 2124425 defendant Pewtres John yeoman 648543 648543 Pewtres, John, of Dymock, yeoman 0
4294781 2128219 2128219 defendant Gundy William   648543 648543 Gundy, William, of Dymock, husbandman, his son 1
4308964 2133289 2133289 defendant William Thomas Morgan yeoman 648543 648543 William, Thomas Morgan, of Dymock, yeoman 2
4308965 2133289 2133289 defendant William David Morgan yeoman 648543 648543 William, David Morgan, of Dymock, yeoman 3
4323017 2138112 2138112 defendant Mayowe Thomas husbandman 648543 648543 Mayowe, Thomas, of Dymock, husbandman 0
4325008 2138749 2138749 defendant Hill William, senior yeoman 648543 648543 Hill, William, senior, of Dymock, yeoman 0
4396311 2163341 2163341 defendant Wilse Thomas butcher 648543 648543 Wilse, Thomas, of Dymock, yeoman, butcher 0
4406503 2166738 2166738 defendant Gundy William   648543 648543 Gundy, William, of Dymock, yeoman, his son 1

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