names

14 rows where case_id = 1999901

✎ 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
3928583 1999901 1999901 plaintiff Bond William     Bond, William 0
3928584 1999901 1999901 defendant Syston Thomas tanner 587719 587719 Syston, Thomas, of St Ives, Hunts, tanner 0
3928585 1999901 1999901 defendant Boydon Richard yeoman 591692 591692 Boydon, Richard, of Over, yeoman 1
3928586 1999901 1999901 defendant Loder Robert yeoman 591692 591692 Loder, Robert, of Over, yeoman 2
3928587 1999901 1999901 defendant Spryng John butcher 591692 591692 Spryng, John, of Over, butcher 3
3928588 1999901 1999901 defendant Byrchener John   591692 591692 Byrchener, John, of Over 4
3928589 1999901 1999901 defendant Tock or Cock William husbandman 591692 591692 Tock or Cock, William, of Over, husbandman 5
3928590 1999901 1999901 defendant Ile William husbandman 591692 591692 Ile, William, of Over, husbandman 6
3928591 1999901 1999901 defendant Coper Robert husbandman 591692 591692 Coper, Robert, of Over, husbandman 7
3928592 1999901 1999901 defendant Leke Thomas husbandman 591692 591692 Leke, Thomas, of Over, husbandman 8
3928593 1999901 1999901 defendant Cotton Thomas husbandman 591692 591692 Cotton, Thomas, of Over, husbandman 9
3928594 1999901 1999901 defendant Cotton Richard husbandman 591692 591692 Cotton, Richard, of Over, husbandman 10
3928595 1999901 1999901 defendant Symes William smith 591692 591692 Symes, William, of Over, smith 11
3928596 1999901 1999901 defendant Howlyng Edmund   585869 585869 Howlyng, Edmund, of London 12

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