names

10 rows where case_id = 1947294

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3766836 1947294 1947294 plaintiff Meyny John gent 625872 625872 Meyny, John, of Beynden, gent 0
3766837 1947294 1947294 defendant Kenwode John butcher 587667 587667 Kenwode, John, of Est Pekham, butcher 0
3766838 1947294 1947294 defendant Master Peter (legal representative)   Master, Peter, executors of 1
3766839 1947294 1947294 defendant Chosse Philip gent 617080 617080 (Chosse, Philip, of Wynchelsee, Sussex, gent 2
3766840 1947294 1947294 defendant Ensyng or Gusyng Thomas yeoman 605638 605638 Ensyng or Gusyng, Thomas, of Wynchelsee, yeoman 3
3766841 1947294 1947294 defendant Philip John (legal representative) 589001 589001 Philip, John, of Maydeston, tailor, executors of 4
3766842 1947294 1947294 defendant Philip Nicholas capper 585869 585869 (Philip, Nicholas, of London, capper 5
3766843 1947294 1947294 defendant Awdeley John yeoman 591921 591921 Awdeley, John, of Maydestone, yeoman 6
3766844 1947294 1947294 defendant Toppynden Simon (legal representative)   Toppynden, Simon, executrix of 7
3766845 1947294 1947294 defendant Toppynden Margaret widow 616908 616908 Toppynden, Margaret, of Kennerton, widow 8

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