names

18 rows where place_id = 603449

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654582 1911696 1911696 defendant Goodgame Richard husbandman 603449 603449 Goodgame, Richard, of Ewerby, husbandman 0
3656345 1912229 1912229 defendant Marshall William yeoman 603449 603449 Marshall, William, of Ewerby, yeoman 2
3656349 1912230 1912230 defendant Marshall William yeoman 603449 603449 Marshall, William, of Ewerby, yeoman 2
3706525 1928326 1928326 defendant Glover William husbandman 603449 603449 Glover, William, of Ewerby, husbandman 0
3706526 1928326 1928326 defendant Pestred John husbandman 603449 603449 Pestred, John, of Ewerby, husbandman 1
3766779 1947272 1947272 defendant Pestrell John husbandman 603449 603449 Pestrell, John, of Ewerby, husbandman 1
3795989 1956608 1956608 defendant Dewe Robert husbandman 603449 603449 Dewe, Robert, of Ewerby, husbandman 0
4091208 2057145 2057145 defendant Salmon John clerk 603449 603449 Salmon, John, of Ewerby, clerk 0
4119916 2067412 2067412 defendant Dubler Robert   603449 603449 Dubler, Robert, of Ewerby, or of Hornecastell 0
4178474 2087946 2087946 defendant Dubler Robert yeoman 603449 603449 Dubler, Robert, of Ewerby, or of Horncastell, yeoman 0
4199955 2095534 2095534 defendant Dubler Robert husbandman 603449 603449 Dubler, Robert, of Ewerby, husbandman 0
4236407 2108304 2108304 defendant Keighley Lawrence husbandman 603449 603449 Keighley, Lawrence, of Ewerby, husbandman 1
4236498 2108338 2108338 defendant Letters John husbandman 603449 603449 Letters, John, of Ewerby, husbandman 0
4936126 2337698 2337698 defendant Cook John panyerman 603449 603449 Cook, John, of Ewerby, panyerman 2
5191123 2413143 2413143 defendant Smyth Richard husbandman 603449 603449 Smyth, Richard, of Ewerby, husbandman 0
5207222 2417853 2417853 defendant Smyth Richard husbandman 603449 603449 Smyth, Richard, of Ewerby, husbandman 0
5441461 2487368 2487368 defendant Endgame William yeoman 603449 603449 Endgame, William, of Ewerby, yeoman 0
5441462 2487368 2487368 defendant Endgame John husbandman 603449 603449 Endgame, John, of Ewerby, husbandman 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);