names

15 rows where case_id = 2118230

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4265882 2118230 2118230 plaintiff Culwick Thomas gent, attorney   Culwick, Thomas, gent, attorney 0
4265883 2118230 2118230 defendant Haynes William yeoman 668545 668545 Haynes, William, of Haddam, Herts, yeoman 0
4265884 2118230 2118230 defendant Chambers Mathew yeoman 585869 585869 Chambers, Mathew, of London, yeoman 1
4265885 2118230 2118230 defendant Revell Roger merchant 585869 585869 Revell, Roger, of London, merchant 2
4265886 2118230 2118230 defendant Stringer Stephen gent 585869 585869 Stringer, Stephen, of London, gent 3
4265887 2118230 2118230 defendant Garnons Walter yeoman 585869 585869 Garnons, Walter, of London, yeoman 4
4265888 2118230 2118230 defendant Conwaye John skinner 585869 585869 Conwaye, John, of London, skinner 5
4265889 2118230 2118230 defendant Goughe Thomas yeoman 585869 585869 Goughe, Thomas, of London, yeoman 6
4265890 2118230 2118230 defendant Graves John merchant 585869 585869 Graves, John, of London, merchant 7
4265891 2118230 2118230 defendant Yarrington John merchant 585869 585869 Yarrington, John, of London, merchant 8
4265892 2118230 2118230 defendant Fell John yeoman 585869 585869 Fell, John, of London, yeoman 9
4265893 2118230 2118230 defendant Paty John fishmonger 585869 585869 Paty, John, of London, fishmonger 10
4265894 2118230 2118230 defendant Zinzamm alias Alexander William gent 585869 585869 Zinzamm alias Alexander, William, of London, gent 11
4265895 2118230 2118230 defendant Blackwell William gent 585869 585869 Blackwell, William, of London, gent 12
4265896 2118230 2118230 defendant Brayton Robert merchant 585869 585869 Brayton, Robert, of London, merchant 13

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