names

15 rows where case_id = 2407282

✎ 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
5171139 2407282 2407282 plaintiff Knyvet William esq   Knyvet, William, esq 0
5171140 2407282 2407282 defendant Curteys Robert husbandman 593687 593687 Curteys, Robert, of Methewold, husbandman 0
5171141 2407282 2407282 defendant Stede John husbandman 593687 593687 Stede, John, of Methewold, husbandman 1
5171142 2407282 2407282 defendant Dunham Edmund mercer 591456 591456 Dunham, Edmund, of Feltwell, mercer 2
5171143 2407282 2407282 defendant Neell William husbandman 593687 593687 together with Neell, William, of Methewold, husbandman 3
5171144 2407282 2407282 defendant Brachet John husbandman 593687 593687 Brachet, John, of Methewold, husbandman 4
5171145 2407282 2407282 defendant Game Thomas husbandman 593687 593687 Game, Thomas, of Methewold, husbandman 5
5171146 2407282 2407282 defendant Thornton Thomas husbandman 593687 593687 Thornton, Thomas, of Methewold, husbandman 6
5171147 2407282 2407282 defendant Potter Simon husbandman 593687 593687 Potter, Simon, of Methewold, husbandman 7
5171148 2407282 2407282 defendant Constable Thomas laborer 593687 593687 Constable, Thomas, of Methewold, laborer 8
5171149 2407282 2407282 defendant Nettellysworth Thomas husbandman 593687 593687 Nettellysworth, Thomas, of Methewold, husbandman 9
5171150 2407282 2407282 defendant Wright John husbandman 855785 855785 Wright, John, of Methewold Hithe, husbandman 10
5171151 2407282 2407282 defendant Toneld John weaver 591456 591456 Toneld, John, of Feltwell, weaver 11
5171152 2407282 2407282 defendant Bolymer of Feltwell husbandman   Bolymer, of Feltwell, husbandman 12
5171153 2407282 2407282 defendant Wright John husbandman 591456 591456 Wright, John, of Feltwell, 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);