names

13 rows where case_id = 2262606

✎ 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
4690571 2262606 2262606 plaintiff Whyte Robert     Whyte, Robert, on his own account 0
4690572 2262606 2262606 defendant Haukyns John yeoman 785140 785140 Haukyns, John, of Great Hobbesse, yeoman 0
4690573 2262606 2262606 defendant Umfrey William husbandman 603315 603315 Umfrey, William, of Great Melton, husbandman 1
4690574 2262606 2262606 defendant Umfrey Sarah     Sarah, his wife 2
4690575 2262606 2262606 defendant Heuke Richard miller 785141 785141 Heuke, Richard, of Wymodnham, miller 3
4690576 2262606 2262606 defendant Wryght John laborer 603722 603722 Wryght, John, of Wramplyngham, laborer 4
4690577 2262606 2262606 defendant Dolman Andrew husbandman 785142 785142 Dolman, Andrew, of Crouchestoke, husbandman 5
4690578 2262606 2262606 defendant Moore Robert laborer 785142 785142 Moore, Robert, of Crouchestoke, laborer 6
4690579 2262606 2262606 defendant Deye John plumber 590966 590966 Deye, John, of Byntre, plumber 7
4690580 2262606 2262606 defendant Colkirke John chapman 585933 585933 Colkirke, John, of Great Yarmouth, chapman 8
4690581 2262606 2262606 defendant Burgh James husandman 586572 586572 Burgh, James, of Berford, husandman 9
4690582 2262606 2262606 defendant Skeppere Edmund husbandman 586572 586572 Skeppere, Edmund, of Berford, husbandman 10
4690583 2262606 2262606 defendant Ted Thomas husbandman 586572 586572 Ted, Thomas, of Berford, husbandman 11

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