names

19 rows where case_id = 2350478

✎ 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
4978355 2350478 2350478 plaintiff Rither William esq   Rither, William, esq 0
4978356 2350478 2350478 defendant Banaster John   829833 829833 Banaster, John, of Tadcastre, marshall 0
4978357 2350478 2350478 defendant Walton Robert fisher 586788 586788 Walton, Robert, of Tadcastre, fisher 1
4978358 2350478 2350478 defendant Walton Robert yeoman 671961 671961 Walton, Robert, of Smawes, yeoman 2
4978359 2350478 2350478 defendant Milner John miller 829834 829834 Milner, John, of Grymeston, Kirkeby on Wharff, miller 3
4978360 2350478 2350478 defendant Blakburn John butcher 586788 586788 Blakburn, John, of Tadcastre, butcher 4
4978361 2350478 2350478 defendant Marshall William smith 586788 586788 Marshall, William, of Tadcastre, smith 5
4978362 2350478 2350478 defendant Kilburn William weaver 586788 586788 Kilburn, William, of Tadcastre, weaver 6
4978363 2350478 2350478 defendant Cherybought Thomas butcher 586788 586788 Cherybought, Thomas, of Tadcastre, butcher 7
4978364 2350478 2350478 defendant Saddeler Thomas saddler 586788 586788 Saddeler, Thomas, of Tadcastre, saddler 8
4978365 2350478 2350478 defendant Sowter Christopher shoemaker 586788 586788 Sowter, Christopher, of Tadcastre, shoemaker 9
4978366 2350478 2350478 defendant Oxton William weaver 586788 586788 Oxton, William, of Tadcastre, weaver 10
4978367 2350478 2350478 defendant Skelton William, junior laborer 586788 586788 Skelton, William, junior, of Tadcastre, laborer 11
4978368 2350478 2350478 defendant Harryson Richard draper 829835 829835 Harryson, Richard, of Tadcastre, Tailloour, Nicholas, of Tadcastre, draper 12
4978369 2350478 2350478 defendant Webster WIlliam weaver 586788 586788 Webster, WIlliam, of Tadcastre, weaver 13
4978370 2350478 2350478 defendant Soureby John weaver 586788 586788 Soureby, John, of Tadcastre, weaver 14
4978371 2350478 2350478 defendant Selby John walker 586788 586788 Selby, John, of Tadcastre, walker 15
4978372 2350478 2350478 defendant Walker John walker 586788 586788 Walker, John, of Tadcastre, walker 16
4978373 2350478 2350478 defendant Cartwryght John   586788 586788 Cartwryght, John, of Tadcastre, cartwright 17

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