names

13 rows where place_id = 600100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639675 1907217 1907217 defendant Jakeson William yeoman Isabel his wife 600100 600100 Jakeson, William, of Beilby, yeoman Isabel his wife 0
4214628 2100622 2100622 defendant Hessey Richard husbandman 600100 600100 Hessey, Richard, of Beilby, husbandman 0
4214630 2100622 2100622 defendant Hessey Thomas yeoman 600100 600100 Hessey, Thomas, of Beilby, yeoman 2
4264294 2117704 2117704 defendant Hessey Richard (legal representative) 600100 600100 Hessey, Richard, of Beilby, husbandman, administratrix of 0
4264295 2117704 2117704 defendant Hessey Maud widow 600100 600100 Hessey, Maud, of Beilby, widow 1
4264296 2117704 2117704 defendant Hessey Thomas yeoman 600100 600100 Hessey, Thomas, of Beilby, yeoman 2
4337712 2142936 2142936 defendant Palmer John husbandman 600100 600100 Palmer John, of Beilby, husbandman 1
4337713 2142936 2142936 defendant Hall Robert weaver 600100 600100 Hall, Robert, of Beilby, weaver 2
4337715 2142937 2142937 defendant Hall Robert weaver 600100 600100 Hall, Robert, of Beilby, weaver 0
4337716 2142937 2142937 defendant Kempe William tailor 600100 600100 Kempe, William, of Beilby, tailor 1
4358027 2150050 2150050 defendant Chapman Edward husbandman 600100 600100 Chapman, Edward, of Beilby, husbandman 0
4386590 2160190 2160190 defendant Haselwood Ducon or Duke husbandman 600100 600100 Haselwood, Ducon or Duke, of Beilby, husbandman 0
5492362 2502633 2502633 defendant Barton Adam husbandman 600100 600100 Barton, Adam, of Beilby, husbandman 0

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