names

17 rows where place_id = 636419

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3830662 1967474 1967474 plaintiff French Thomas   636419 636419 French, Thomas, of Chytynglegh 0
4809932 2299267 2299267 plaintiff Elphegh Henry   636419 636419 Elphegh, Henry, of Chytynglegh 1
4850291 2311548 2311548 defendant Rolf John   636419 636419 Rolf, John, of Chytynglegh, shoe maker 0
4850293 2311548 2311548 defendant Cook John   636419 636419 Cook, John, of Chytynglegh, park man 2
4894460 2324941 2324941 defendant atte Hese John laborer 636419 636419 atte Hese, John, of Chytynglegh, laborer 3
4933541 2336871 2336871 defendant atte Stokke Richard husbandman 636419 636419 atte Stokke, Richard, of Chytynglegh, husbandman 1
4933546 2336872 2336872 defendant atte Stokke Richard husbandman 636419 636419 atte Stokke, Richard, of Chytynglegh, husbandman 1
4984385 2352260 2352260 defendant atte Welle Richard husbandman 636419 636419 atte Welle, Richard, of Chytynglegh, husbandman 2
5012790 2360572 2360572 defendant Berd Ralph husbandman 636419 636419 Berd, Ralph, of Chytynglegh, husbandman 0
5049053 2371352 2371352 defendant Meleward Richard husbandman 636419 636419 Meleward, Richard, of Chytynglegh, husbandman 0
5059465 2374399 2374399 defendant Kele Robert husbandman 636419 636419 Kele, Robert, of Chytynglegh, husbandman 0
5077465 2379759 2379759 plaintiff Bochell John   636419 636419 Bochell, John, of Chytynglegh 0
5113215 2390258 2390258 defendant Cooke John draper 636419 636419 Cooke, John, of Chytynglegh, draper 14
5132314 2395948 2395948 defendant atte Lye William butcher 636419 636419 atte Lye, William, of Chytynglegh, butcher 3
5152056 2401738 2401738 defendant atte Lye William butcher 636419 636419 atte Lye, William, of Chytynglegh, butcher 3
5636084 2555244 2555244 plaintiff Wodefeld William   636419 636419 Wodefeld, William, of Chytynglegh 0
5636090 2555245 2555245 plaintiff Wodefold William   636419 636419 Wodefold, William, of Chytynglegh 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);