names

13 rows where place_id = 603061

✎ 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
3652926 1911241 1911241 defendant Barne John mercer 603061 603061 Barne, John, of Plymton, mercer 2
3667031 1915630 1915630 defendant Trewers John chapman 603061 603061 Trewers, John, of Plymton, chapman 3
3691461 1923485 1923485 defendant Trevase John mercer 603061 603061 Trevase, John, of Plymton, mercer 2
3691466 1923486 1923486 defendant Trevase John mercer 603061 603061 Trevase, John, of Plymton, mercer 2
3939244 2003429 2003429 defendant Coffyn Richard husbandman 603061 603061 Coffyn, Richard, of Plymton, husbandman 0
3983587 2018900 2018900 plaintiff Sperke Thomas merchant 603061 603061 Sperke, Thomas, of Plymton, merchant 0
4007540 2027481 2027481 plaintiff Marten Christopher gent 603061 603061 Marten, Christopher, of Plymton, gent 0
4012317 2029127 2029127 plaintiff Pyke Nicholas merchant 603061 603061 Pyke, Nicholas, of Plymton, or of Blaxston, Devon, merchant 0
4569370 2222010 2222010 defendant Sylvirlot John   603061 603061 Sylvirlot, John, of Plymton 0
4569371 2222010 2222010 defendant Trok John   603061 603061 Trok, John, of Plymton 1
4669873 2256274 2256274 plaintiff Braklee John gent 603061 603061 Braklee, John, of Plymton, gent, on his own account 0
5155582 2402786 2402786 defendant Navecote Thomas carpenter 603061 603061 Navecote, Thomas, of Plymton, carpenter 1
5155585 2402787 2402787 defendant Navecote Thomas carpenter 603061 603061 Navecote, Thomas, of Plymton, carpenter 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);