names

15 rows where case_id = 2383872

✎ 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
5091371 2383872 2383872 plaintiff Neel Thomas     Neel, Thomas 0
5091372 2383872 2383872 defendant Blak Raph husbandman 627571 627571 Blak, Raph, of Gaddesby, husbandman 0
5091373 2383872 2383872 defendant Monk William husbandman 627571 627571 Monk, William,of Gaddesby, husbandman 1
5091374 2383872 2383872 defendant Buk William husbandman 627571 627571 Buk, William, of Gaddesby, husbandman 2
5091375 2383872 2383872 defendant Humberston William husbandman 627571 627571 Humberston, William, of Gaddesby, husbandman 3
5091376 2383872 2383872 defendant Sande John yeoman 627571 627571 Sande, John, of Gaddesby, yeoman 4
5091377 2383872 2383872 defendant Kemp William laborer 627571 627571 Kemp, William, of Gaddesby, laborer 5
5091378 2383872 2383872 defendant Blak William husbandman 627571 627571 Blak, William, of Gaddesby, husbandman 6
5091379 2383872 2383872 defendant Baylly John yeoman 818233 818233 Baylly, John, of Frysby on Wrethek, yeoman 7
5091380 2383872 2383872 defendant Clarley John yeoman 818233 818233 Clarley, John, of Frysby on Wrethek, yeoman 8
5091381 2383872 2383872 defendant Webbe Thomas laborer 818233 818233 Webbe, Thomas, of Frysby on Wrethek, laborer 9
5091382 2383872 2383872 defendant SWebbe Peter laborer 818233 818233 SWebbe, Peter, of Frysby on Wrethek, laborer 10
5091383 2383872 2383872 defendant Bailly Richard husbandman 818233 818233 Bailly, Richard, of Frysby on Wrethek, husbandman 11
5091384 2383872 2383872 defendant Prykyngham Thomas husbandman 818233 818233 Prykyngham, Thomas, of Frysby on Wrethek, husbandman 12
5091385 2383872 2383872 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);