names

26 rows where case_id = 2080585

✎ 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
4157171 2080585 2080585 plaintiff Morton Anthony esq   Morton, Anthony, esq 0
4157172 2080585 2080585 defendant Bruester William innholder 635077 635077 Bruester, William, of Scroby, innholder 0
4157173 2080585 2080585 defendant Metcalfe Philip miller 677924 677924 Metcalfe, Philip, of Scrobye, miller 1
4157174 2080585 2080585 defendant Hanson George husbandman 677924 677924 Hanson, George, of Scrobye, husbandman 2
4157175 2080585 2080585 defendant Hanley Thomas husbandman 677924 677924 Hanley, Thomas, of Scrobye, husbandman 3
4157176 2080585 2080585 defendant Johnson Roland husbandman 677924 677924 Johnson, Roland, of Scrobye, husbandman 4
4157177 2080585 2080585 defendant Hanley Mathew husbandman 677924 677924 Hanley, Mathew, of Scrobye, husbandman 5
4157178 2080585 2080585 defendant Hanley John badger 677924 677924 Hanley, John, of Scrobye, badger 6
4157179 2080585 2080585 defendant Harrison Thomas miller 677924 677924 Harrison, Thomas, of Scrobye, miller 7
4157180 2080585 2080585 defendant Stubbinge Thomas laborer 677924 677924 Stubbinge, Thomas, of Scrobye, laborer 8
4157181 2080585 2080585 defendant Hareson William laborer 677924 677924 Hareson, William, of Scrobye, laborer 9
4157182 2080585 2080585 defendant Justys Thomas laborer 677924 677924 Justys, Thomas, of Scrobye, laborer 10
4157183 2080585 2080585 defendant Burgon William carpenter 677924 677924 Burgon, William, of Scrobye, carpenter 11
4157184 2080585 2080585 defendant Taylor Anthony shoemaker 677924 677924 Taylor, Anthony, of Scrobye, shoemaker 12
4157185 2080585 2080585 defendant Scarbroughe William shoemaker 677924 677924 Scarbroughe, William, of Scrobye, shoemaker 13
4157186 2080585 2080585 defendant Chauntrye Thomas laborer 677924 677924 Chauntrye, Thomas, of Scrobye, laborer 14
4157187 2080585 2080585 defendant Denton William, junior weaver 677924 677924 Denton, William, junior, of Scrobye, weaver 15
4157188 2080585 2080585 defendant Denton Ralph weaver 677924 677924 Denton, Ralph, of Scrobye, weaver 16
4157189 2080585 2080585 defendant Bolton Michael laborer 677924 677924 Bolton, Michael, of Scrobye, laborer 17
4157190 2080585 2080585 defendant Darwyn Edward husbandman 677924 677924 Darwyn, Edward, of Scrobye, husbandman 18
4157191 2080585 2080585 defendant Brashawe John weaver 677924 677924 Brashawe, John, of Scrobye, weaver 19
4157192 2080585 2080585 defendant Ingle Richard miller 677924 677924 Ingle, Richard, of Scrobye, miller 20
4157193 2080585 2080585 defendant Pettener Robert husbandman 705383 705383 Pettener, Robert, of Ranskyll, husbandman 21
4157194 2080585 2080585 defendant Gabbitus Richard husbandman 705384 705384 Gabbitus, Richard, of Ranskill, husbandman 22
4157195 2080585 2080585 defendant Maydin or Maydam Robert husbandman 705384 705384 Maydin or Maydam, Robert, of Ranskill, husbandman 23
4157196 2080585 2080585 defendant Barker Thomas husbandman 705384 705384 Barker, Thomas, of Ranskill, husbandman 24

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