names

13 rows where case_id = 2390722

✎ 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
5114727 2390722 2390722 plaintiff Mareys William esq   Mareys, William, esq 0
5114728 2390722 2390722 defendant Overay Richard husbandman 833255 833255 Overay, Richard, of Longevile, husbandman 0
5114729 2390722 2390722 defendant atte Wode Robert husbandman 848048 848048 atte Wode, Robert, of Asshe juxta Frankham, husbandman 1
5114730 2390722 2390722 defendant Maior John husbandman 848049 848049 Maior, John, of Fotiscray, husbandman 2
5114731 2390722 2390722 defendant Walssh Richard husbandman 609845 609845 Walssh, Richard, of Cray St Mary, husbandman 3
5114732 2390722 2390722 defendant Levendale Stephen husbandman 848050 848050 Levendale, Stephen, of Modyngham, Chesylherst, husbandman 4
5114733 2390722 2390722 defendant Draper John yeoman 848051 848051 Draper, John, of Lesyngheth, Erythe, yeoman 5
5114734 2390722 2390722 defendant Cavell Bernard husbandman 598066 598066 Cavell, Bernard, of Chesylherst, husbandman 6
5114735 2390722 2390722 defendant Broun William husbandman 591655 591655 Broun, William, of Shorham, husbandman 7
5114736 2390722 2390722 defendant Jetour John husbandman 602539 602539 Jetour, John, of Chellysfeld, husbandman 8
5114737 2390722 2390722 defendant Walet Richard butcher 600283 600283 Walet, Richard, of North Cray, butcher 9
5114738 2390722 2390722 defendant Stable Thomas husbandman 609845 609845 Stable, Thomas, of Cray St Mary, husbandman 10
5114739 2390722 2390722 defendant Rumney Henry smith 595016 595016 Rumney, Henry, of Codeham, smith 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);