names

13 rows where place_id = 685251

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4061661 2046569 2046569 plaintiff Edmond Ambrose gent 685251 685251 Edmond, Ambrose, of Staunton St John, Oxon, gent 0
4741027 2277887 2277887 defendant Makeney Lambert esq 685251 685251 Makeney, Lambert, of Staunton St John, Oxon, esq 1
4741031 2277888 2277888 defendant Makeney Lambert esq 685251 685251 Makeney, Lambert, of Staunton St John, Oxon, esq 1
4741805 2278095 2278095 defendant Makney Lambert esq 685251 685251 Makney, Lambert, of Staunton St John, Oxon, esq 0
4741807 2278096 2278096 defendant Malney Lambert esq 685251 685251 Malney, Lambert, of Staunton St John, Oxon, esq 0
4760762 2283706 2283706 defendant Makeney Lambert esq 685251 685251 Makeney, Lambert, of Staunton St John, Oxon, esq 0
5243669 2428342 2428342 defendant Heynes William husbandman 685251 685251 Heynes, William, of Staunton St John, Oxon, husbandman 2
5273928 2437454 2437454 defendant Nycholas Thomas gent 685251 685251 Nycholas, Thomas, of Staunton St John, Oxon, gent 0
5273931 2437455 2437455 defendant Nycholas Thomas gent 685251 685251 Nycholas, Thomas, of Staunton St John, Oxon, gent 0
5290554 2442239 2442239 defendant Nycholas Thomas gent 685251 685251 Nycholas, Thomas, of Staunton St John, Oxon, gent 0
5290556 2442240 2442240 defendant Nycholas Thomas gent 685251 685251 Nycholas, Thomas, of Staunton St John, Oxon, gent 0
5368192 2465676 2465676 defendant Fysshe Alan husbandman 685251 685251 Fysshe, Alan, of Staunton St John, Oxon, husbandman 1
5368196 2465677 2465677 defendant Fysshe Alan husbandman 685251 685251 Fysshe, Alan, of Staunton St John, Oxon, 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);