names

13 rows where case_id = 1873560

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3619022 1873560 1873560 plaintiff Hilton Christopher, senior esq   Hilton, Christopher, senior, esq 0
3619023 1873560 1873560 defendant Rudde John yeoman 595128 595128 Rudde, John, of Sanford, yeoman 0
3619024 1873560 1873560 defendant Rudde Richard yeoman 595128 595128 Rudde, Richard, of Sanford, yeoman 1
3619025 1873560 1873560 defendant Stykman John yeoman 595128 595128 Stykman, John, of Sanford, yeoman 2
3619026 1873560 1873560 defendant Lambe Richard yeoman 595128 595128 Lambe, Richard, of Sanford, yeoman 3
3619027 1873560 1873560 defendant Robynson John yeoman 595128 595128 Robynson, John, of Sanford, yeoman 4
3619028 1873560 1873560 defendant Feynt William yeoman 595128 595128 Feynt, William, of Sanford, yeoman 5
3619029 1873560 1873560 defendant Bank Robert yeoman 595128 595128 Bank, Robert, of Sanford, yeoman 6
3619030 1873560 1873560 defendant Rudde Thomas yeoman 595128 595128 Rudde, Thomas, of Sanford, yeoman 7
3619031 1873560 1873560 defendant Rudde William yeoman 595129 595129 Rudde, William, of Fotegap, yeoman 8
3619032 1873560 1873560 defendant Rudde Henry yeoman 595128 595128 Rudde, Henry, of Sanford, yeoman 9
3619033 1873560 1873560 defendant Bacon Christopher yeoman 595128 595128 Bacon, Christopher, of Sanford, yeoman 10
3619034 1873560 1873560 defendant Baxter John yeoman 595128 595128 Baxter, John, of Sanford, yeoman 11

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