names

15 rows where case_id = 2318345

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4872438 2318345 2318345 plaintiff Norwich William     Norwich, William 0
4872439 2318345 2318345 defendant Wode John husbandman 585998 585998 Wode, John, of Keteryngham, husbandman 0
4872440 2318345 2318345 defendant Garbald Robert husbandman 590879 590879 Garbald, Robert, of Skulthorp, husbandman 1
4872441 2318345 2318345 defendant Millere Richard husbandman 590486 590486 Millere, Richard, of Stoke Holy Cross, husbandman 2
4872442 2318345 2318345 defendant Elgar Richard husbandman 632735 632735 Elgar, Richard, of Crowemer, husbandman 3
4872443 2318345 2318345 defendant Maret John husbandman 594961 594961 together with Maret, John, of Tunstale, husbandman 4
4872444 2318345 2318345 defendant Dowe John husbandman 771530 771530 Dowe, John, of Wykylwode, husbandman 5
4872445 2318345 2318345 defendant Trewe William shipman 632735 632735 Trewe, William, of Crowemer, shipman 6
4872446 2318345 2318345 defendant Bynham Thomas smith 598083 598083 together with Bynham, Thomas, of Ketylston, smith 7
4872447 2318345 2318345 defendant Secler Thomas yeoman 587414 587414 Secler, Thomas, of Thetford, yeoman 8
4872448 2318345 2318345 defendant Fystolf John yeoman 590486 590486 Fystolf, John, of Stoke Holy Cross, yeoman 9
4872449 2318345 2318345 defendant Pyttes John yeoman 589534 589534 together with Pyttes, John, of Depham, yeoman 10
4872450 2318345 2318345 defendant Mumpyng Ralph butcher 612237 612237 Mumpyng, Ralph, of Aykesham, butcher 11
4872451 2318345 2318345 defendant Sheryngham John yeoman 586471 586471 Sheryngham, John, of Aylesham, yeoman 12
4872452 2318345 2318345 defendant Fenne Adam yeoman 592153 592153 Fenne, Adam, of Wroxham, yeoman 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);