names

14 rows where place_id = 597515

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628886 1903910 1903910 defendant Lee Richard esq 597515 597515 Lee, Richard, of Maideston, Kent, esq 0
3628888 1903911 1903911 defendant Lee Richard esq 597515 597515 Lee, Richard, of Maideston, Kent, esq 0
3628892 1903913 1903913 defendant Lee Richard esq 597515 597515 Lee, Richard, of Maideston, Kent, esq 0
3866994 1979199 1979199 defendant Fyssher John gent 597515 597515 Fyssher, John, of Maideston, Kent, gent 2
3866999 1979200 1979200 defendant Fyssher John gent 597515 597515 Fyssher, John, of Maideston, Kent, gent 2
4338632 2143267 2143267 defendant Ball John dyer 597515 597515 Ball, John, of Maideston, Kent, dyer 0
4751404 2280892 2280892 defendant Costewell John   597515 597515 Costewell, John, of Maideston, Kent, mason 0
4786383 2291784 2291784 defendant Whitclerk John chapman 597515 597515 Whitclerk, John, of Maideston, Kent, chapman 2
4865644 2316219 2316219 defendant Brokle Robert dyer 597515 597515 Brokle, Robert, of Maideston, Kent, dyer 0
4873556 2318677 2318677 defendant Propchaunt Richard chapman 597515 597515 Propchaunt, Richard, of Maideston, Kent, chapman 0
5083125 2381462 2381462 defendant Blake John cordwainer 597515 597515 Blake, John, of Maideston, Kent, cordwainer 0
5083152 2381463 2381463 defendant Smyth William   597515 597515 Smyth, William, of Maideston, Kent, mason 9
5083159 2381464 2381464 defendant Maynard Richard cordwainer 597515 597515 Maynard, Richard, of Maideston, Kent, cordwainer 1
5530171 2513942 2513942 defendant Dunmowe Stephen chapman 597515 597515 Dunmowe, Stephen, of Maideston, Kent, chapman 0

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