names

20 rows where place_id = 642095

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3688372 1922519 1922519 defendant Andrewe John (legal representative) 642095 642095 Andrewe, John, of Tottenes, merchant, executrix of 0
3865767 1978777 1978777 defendant Mason Humphrey miller 642095 642095 Mason, Humphrey, of Tottenes, miller 0
3915899 1995699 1995699 defendant Gelys William merchant 642095 642095 Gelys, William, of Tottenes, merchant 0
3915900 1995699 1995699 defendant Gelys Mathew merchant 642095 642095 Gelys, Mathew, of Tottenes, merchant 1
3915901 1995699 1995699 defendant Stone Robert laborer 642095 642095 Stone, Robert, of Tottenes, laborer 2
3965989 2012726 2012726 plaintiff Blackealler John merchant 642095 642095 Blackealler, John, of Tottenes, merchant 0
3982464 2018504 2018504 plaintiff Saverye Alan merchant 642095 642095 Saverye, Alan, of Tottenes, merchant 0
3982688 2018578 2018578 plaintiff Serett Luke merchant 642095 642095 Serett, Luke, of Tottenes, merchant 0
3982690 2018578 2018578 defendant Laugher James merchant 642095 642095 Laugher, James, of Tottenes, merchant 1
4007605 2027506 2027506 plaintiff Martyn Richard   642095 642095 Martyn, Richard, of Tottenes 0
4253741 2114244 2114244 defendant Haughton James (legal representative) 642095 642095 Haughton, James, of Tottenes, gent, executrix of 0
4682328 2260098 2260098 defendant Wastell Robert barber 642095 642095 Wastell, Robert, of Tottenes, barber 0
4782714 2290608 2290608 defendant Chesewey Henry husbandman 642095 642095 Chesewey, Henry, of Tottenes, husbandman 0
4813950 2300475 2300475 plaintiff Hornesey Hugh   642095 642095 Hornesey, Hugh, of Tottenes 0
4872227 2318275 2318275 defendant Hornse Hugh husbandman 642095 642095 Hornse, Hugh, of Tottenes, husbandman 0
4958136 2344402 2344402 defendant Belle Stephen husbandman 642095 642095 Belle, Stephen, of Tottenes, husbandman 0
5065818 2376297 2376297 defendant Northwiche Richard dyer 642095 642095 Northwiche, Richard, of Tottenes, dyer 1
5123547 2393341 2393341 plaintiff Willyam Robert   642095 642095 Willyam, Robert, of Tottenes 0
5163674 2405112 2405112 plaintiff William alias Helyyr Robert   642095 642095 William alias Helyyr, Robert, of Tottenes 0
5484415 2500255 2500255 defendant Hakwell Geoffrey pewterer 642095 642095 Hakwell, Geoffrey, of Tottenes, pewterer 3

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