names

15 rows where place_id = 692323

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4008917 2027951 2027951 defendant Eyr Robert esq 692323 692323 Eyr, Robert, of Boughton under Bleane, Kent, esq 4
4010356 2028470 2028470 defendant Eyre Robert esq 692323 692323 Eyre, Robert, of Boughton under Blene, Kent, esq 0
4064658 2047644 2047644 defendant Wood Walter   692323 692323 Wood, Walter, of Boughton under Bleane, Kent 0
4064660 2047645 2047645 defendant Wood Walter   692323 692323 Wood, Walter, of Boughton under Bleane, Kent 0
4094317 2058305 2058305 defendant Stace Jasper gent 692323 692323 Stace, Jasper, of Boughton, Kent, gent 0
4240072 2109652 2109652 defendant Throwley Thomas yeoman 692323 692323 Throwley, Thomas, of Boughton under Bleane, Kent, yeoman 0
4458753 2187785 2187785 plaintiff Repyndon William   692323 692323 Repyndon, William, of Boughton under Blean, Kent, on his own account 0
4801115 2296538 2296538 defendant Trevet or Trenet Elizabeth gentlewoman 692323 692323 Trevet or Trenet, Elizabeth, of Boughton, Kent, gentlewoman 0
4801156 2296546 2296546 defendant Trenet or Trevet Elizabeth gentlewoman 692323 692323 Trenet or Trevet, Elizabeth, of Boughton, Kent, gentlewoman 0
4846068 2310274 2310274 defendant Norman Henry skinner 692323 692323 Norman, Henry, of Boughton under Blean, Kent, skinner 1
4900149 2326672 2326672 defendant Joce John husbandman 692323 692323 Joce, John, of Boughton, Kent, husbandman 2
5088861 2383118 2383118 defendant May Richard gent 692323 692323 May, Richard, of Boughton, Kent, gent 0
5088863 2383119 2383119 defendant May Richard gent 692323 692323 May, Richard, of Boughton, Kent, gent 0
5088865 2383120 2383120 defendant May Richard gent 692323 692323 May, Richard, of Boughton, Kent, gent 0
5184064 2411074 2411074 defendant Jarman Thomas husbandman 692323 692323 Jarman, Thomas, of Boughton under Blean, Kent, husbandman 2

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