names

15 rows where case_id = 2383871

✎ 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
5091356 2383871 2383871 plaintiff Neel Thomas     Neel, Thomas 0
5091357 2383871 2383871 defendant Blak Ralph husbandman 627571 627571 Blak, Ralph, of Gaddesby, husbandman 0
5091358 2383871 2383871 defendant Monk William husbandman 627571 627571 Monk, William, of Gaddesby, husbandman 1
5091359 2383871 2383871 defendant Buk William husbandman 627571 627571 Buk, William, of Gaddesby, husbandman 2
5091360 2383871 2383871 defendant Humberston William husbandman 627571 627571 Humberston, William, of Gaddesby, husbandman 3
5091361 2383871 2383871 defendant Sande John yeoman 627571 627571 Sande, John, of Gaddesby, yeoman 4
5091362 2383871 2383871 defendant Kempe William laborer 627571 627571 Kempe, William, of Gaddesby, laborer 5
5091363 2383871 2383871 defendant Blak William husbandman 627571 627571 Blak, William, of Gaddesby, husbandman 6
5091364 2383871 2383871 defendant Baylly John yeoman 818233 818233 Baylly, John, of Frysby on Wrethek, yeoman 7
5091365 2383871 2383871 defendant Charles John yeoman 818233 818233 Charles, John, of Frysby on Wrethek, yeoman 8
5091366 2383871 2383871 defendant Webbe Thomas laborer 818233 818233 Webbe, Thomas, of Frysby on Wrethek, laborer 9
5091367 2383871 2383871 defendant Webbe Peter laborer 818233 818233 Webbe, Peter, of Frysby on Wrethek, laborer 10
5091368 2383871 2383871 defendant Baylly Richard husbandman 818233 818233 Baylly, Richard, of Frysby on Wrethek, husbandman 11
5091369 2383871 2383871 defendant Prykyngham Thomas husbandman 818233 818233 Prykyngham, Thomas, of Frysby on Wrethek, husbandman 12
5091370 2383871 2383871 defendant Polle John husbandman 845317 845317 Polle, John, of Thorp Sechevyle, husbandman 13

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