names

15 rows where case_id = 2396430

✎ 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
5133953 2396430 2396430 plaintiff Knyvet William esq   Knyvet, William, esq 0
5133954 2396430 2396430 defendant Curteys Robert husbandman 593687 593687 Curteys, Robert, of Methewold, husbandman 0
5133955 2396430 2396430 defendant Stede John husbandman 593687 593687 Stede, John, of Methewold, husbandman 1
5133956 2396430 2396430 defendant Nettelysworth Thomas husbandman 593687 593687 Nettelysworth, Thomas, of Methewold, husbandman 2
5133957 2396430 2396430 defendant Wryght John husbandman 850884 850884 Wryght, John, of Methwold heath, husbandman 3
5133958 2396430 2396430 defendant Dunham Edmund mercer 591456 591456 Dunham, Edmund, of Feltwell, mercer 4
5133959 2396430 2396430 defendant Toneld John   591456 591456 Toneld, John, of Feltwell 5
5133960 2396430 2396430 defendant Wright John husbandman 591456 591456 Wright, John, of Feltwell, husbandman 6
5133961 2396430 2396430 defendant Neel William husbandman   with Neel, William, husbandman 7
5133962 2396430 2396430 defendant Brachet John husbandman   Brachet, John, husbandman 8
5133963 2396430 2396430 defendant Bame Thomas husbandman   Bame, Thomas, husbandman 9
5133964 2396430 2396430 defendant Thornton Thomas husbandman   Thornton, Thomas, husbandman 10
5133965 2396430 2396430 defendant Potter Simon husbandman   Potter, Simon, husbandman 11
5133966 2396430 2396430 defendant Constable Thomas laborer   Constable, Thomas, laborer 12
5133967 2396430 2396430 defendant Bokyng John husbandman   Bokyng, John, 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);