names

16 rows where place_id = 619102

✎ 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
3728151 1935065 1935065 defendant Tely Thomas clerk 619102 619102 Tely, Thomas, of Mynyngesby, clerk 0
4469644 2191172 2191172 plaintiff Boston John de   619102 619102 Boston, John de, of Mynyngesby 0
4469645 2191172 2191172 defendant atte Grygg Robert   619102 619102 atte Grygg, Robert, of Mynyngesby 0
4506678 2202566 2202566 defendant Hawe Thomas ropemaker 619102 619102 Hawe, Thomas, of Mynyngesby, ropemaker 0
4506819 2202601 2202601 defendant Hawe Thomas   619102 619102 Hawe, Thomas, of Mynyngesby, rope maker 0
4552006 2216577 2216577 plaintiff Est Walter   619102 619102 Est, Walter, of Mynyngesby 0
4750708 2280693 2280693 defendant Boston Richard   619102 619102 Boston, Richard, of Mynyngesby, bailiff 1
4765650 2285248 2285248 defendant Terres William husbandman 619102 619102 Terres, William, of Mynyngesby, husbandman 0
4772334 2287312 2287312 defendant Symkynson John weaver 619102 619102 Symkynson, John, of Mynyngesby, weaver 0
4773422 2287661 2287661 defendant Boston Richard   619102 619102 Boston, Richard, of Mynyngesby, bailiff 1
4796563 2295077 2295077 defendant Wilkynson Thomas husbandman 619102 619102 Wilkynson, Thomas, of Mynyngesby, husbandman 0
4797488 2295385 2295385 defendant Boston Richard   619102 619102 Boston, Richard, of Mynyngesby, bailiff 0
4824229 2303646 2303646 defendant Boston Richard   619102 619102 Boston, Richard, of Mynyngesby, bailiff 0
4916292 2331600 2331600 defendant Parke Thomas husbandman 619102 619102 Parke, Thomas, of Mynyngesby, husbandman 8
4961276 2345340 2345340 defendant Baron John clerk 619102 619102 Baron, John, of Mynyngesby, clerk 3
5322179 2451705 2451705 defendant Parke Thomas yeoman 619102 619102 Parke, Thomas, of Mynyngesby, yeoman 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);