names

20 rows where case_id = 2051942

✎ 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
4076636 2051942 2051942 plaintiff Skynner Richard gent, attorney of the bench   Skynner, Richard, gent, attorney of the bench 0
4076637 2051942 2051942 defendant Crede James   664136 664136 Crede, James, of Ittryngham husbandman 0
4076638 2051942 2051942 defendant Tuddenham John husbandman 585915 585915 Tuddenham, John, of Shypdam, husbandman 1
4076639 2051942 2051942 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 2
4076640 2051942 2051942 defendant Bright Richard mariner 585933 585933 Bright, Richard, of Great Yarmouth, mariner 3
4076641 2051942 2051942 defendant Browne William   618355 618355 Browne, William, of Glamford husbandman 4
4076642 2051942 2051942 defendant Cantrell Henry gent 594982 594982 Cantrell, Henry, of Byrcham, gent 5
4076643 2051942 2051942 defendant Mundforth John husbandman 607573 607573 Mundforth, John, of Rolsby, husbandman 6
4076644 2051942 2051942 defendant Newebye John husbandman 612114 612114 Newebye, John, of Bunwell, husbandman 7
4076645 2051942 2051942 defendant Wakefyld George husbandman 674657 674657 Wakefyld, George, of Strumpshawe, husbandman 8
4076646 2051942 2051942 defendant Braunch John husbandman 591453 591453 Braunch, John, of North Tuddenham, husbandman 9
4076647 2051942 2051942 defendant Carsye William husbandman 688617 688617 Carsye, William, of Dyckleborough, husbandman 10
4076648 2051942 2051942 defendant Stacey John husbandman 591106 591106 Stacey, John, of Depeham, husbandman 11
4076649 2051942 2051942 defendant Gooche Richard husbandman 597661 597661 Gooche, Richard, of Swanyngton, husbandman 12
4076650 2051942 2051942 defendant Whyte Edward gent 585915 585915 Whyte, Edward, of Shypdam, gent 13
4076651 2051942 2051942 defendant Kett Adam butcher 586365 586365 Kett, Adam, of Wymondham, butcher 14
4076652 2051942 2051942 defendant Legett Arthur gent 635992 635992 Legett, Arthur, of Barforth, gent 15
4076653 2051942 2051942 defendant Walter John husbandman 586386 586386 Walter, John, of Weston, husbandman 16
4076654 2051942 2051942 defendant Heth John miller 674660 674660 Heth, John, of Laryngsett, miller 17
4076655 2051942 2051942 defendant Yong William husbandman 621099 621099 Yong, William, of Hevyngham, husbandman 18

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