names

22 rows where place_id = 618208

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3723382 1933582 1933582 defendant Davy John husbandman 618208 618208 Davy, John, of Elstowe, Beds, husbandman 0
3733876 1936843 1936843 defendant Snowe William yeoman 618208 618208 Snowe, William, of Elstowe, Beds, yeoman 1
3784205 1952846 1952846 defendant Jurden William gent 618208 618208 Jurden, William, of Elstowe, Beds, gent 0
3784207 1952847 1952847 defendant Jurden William gent 618208 618208 Jurden, William, of Elstowe, Beds, gent 0
3935890 2002317 2002317 defendant Hayes William yeoman 618208 618208 Hayes, William, of Elstowe, Beds, yeoman 0
3954771 2008736 2008736 defendant Ratclyff Humphrey   618208 618208 Ratclyff, Humphrey, of Elstowe, Beds, knight 0
3958517 2010047 2010047 defendant Radcltffe Humphrey   618208 618208 Radcltffe, Humphrey, of Elstowe, Beds, knight 0
4095577 2058746 2058746 defendant Clarke John gent 618208 618208 Clarke, John, of Elstowe, Beds, gent 0
4123240 2068614 2068614 defendant Radcliff Isabel widow 618208 618208 Radcliff, Isabel, of Elstowe, Beds, widow 0
4172922 2085983 2085983 defendant Graye Edward gent 618208 618208 Graye, Edward, of Elstowe, Beds, gent 0
4183895 2089861 2089861 defendant Butler William gent 618208 618208 Butler, William, of Elstowe, Beds, gent 0
4194672 2093695 2093695 defendant Radclyff Thomas esq 618208 618208 Radclyff, Thomas, of Elstowe, Beds, esq 0
4208596 2098556 2098556 defendant Clerke John gent 618208 618208 Clerke, John, of Elstowe, Beds, gent 0
4268313 2119007 2119007 defendant Ratclyffe Isabel widow 618208 618208 Ratclyffe, Isabel, of Elstowe, Beds, widow 0
4714102 2269740 2269740 defendant Moreton Thomas gent 618208 618208 Moreton, Thomas, of Elstowe, Beds, gent 0
4849018 2311161 2311161 defendant Sperman Ralph chapman 618208 618208 Sperman, Ralph, of Elstowe, Beds, chapman 1
4849031 2311167 2311167 defendant Sperman Ralph chapman 618208 618208 Sperman, Ralph, of Elstowe, Beds, chapman 1
5004460 2358202 2358202 defendant Colet John draper 618208 618208 Colet, John, of Elstowe, Beds, draper 0
5014106 2360977 2360977 defendant Sperman Ralph chapman 618208 618208 Sperman, Ralph, of Elstowe, Beds, chapman 0
5567487 2525059 2525059 defendant Roweley James gent 618208 618208 Roweley, James, of Elstowe, Beds, gent 0
5567489 2525060 2525060 defendant Roweley James gent 618208 618208 Roweley, James, of Elstowe, Beds, gent 0
5567510 2525069 2525069 defendant Roweley James gent 618208 618208 Roweley, James, of Elstowe, Beds, gent 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);