names

7 rows where case_id = 2379593

✎ 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
5076922 2379593 2379593 plaintiff Bele Thomas     Bele, Thomas 0
5076923 2379593 2379593 defendant Boner or Bouer John shoemaker 700599 700599 Boner or Bouer, John, of Est Rasen, shoemaker 0
5076924 2379593 2379593 defendant Bardell Richard miller 700599 700599 Bardell, Richard, of Est Rasen, miller 1
5076925 2379593 2379593 defendant Hoby John   700599 700599 Hoby, John, of Est Rasen, wright 2
5076926 2379593 2379593 defendant Everyngham Thomas glover 700599 700599 Everyngham, Thomas, of Est Rasen, glover 3
5076927 2379593 2379593 defendant Morwyk John shipman 843627 843627 Morwyk, John, of Walcrich, shipman 4
5076928 2379593 2379593 defendant Genyson John shipman 843627 843627 Genyson, John, of Walcrich, shipman 5

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