names

14 rows where place_id = 774211

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4609354 2234026 2234026 defendant Cornwaille Hugh   774211 774211 Cornwaille, Hugh, of Acclom 0
4670621 2256492 2256492 defendant Bridsall John   774211 774211 Bridsall, John, of Acclom, vicar & clerk 0
4670623 2256493 2256493 defendant Bridsell John   774211 774211 Bridsell, John, of Acclom, vicar & clerk 0
4670987 2256595 2256595 defendant Clerk William husbandman 774211 774211 Clerk, William, of Acclom, husbandman 0
4670989 2256596 2256596 defendant Clerk William husbandman 774211 774211 Clerk, William, of Acclom, husbandman 0
4711328 2268875 2268875 defendant Clerk William   774211 774211 Clerk, William, of Acclom, wool man 0
4754511 2281791 2281791 defendant Birdsall John   774211 774211 Birdsall, John, of Acclom, vicar 0
4780233 2289816 2289816 defendant Reed John husbandman 774211 774211 Reed, John, of Acclom, husbandman 0
4831265 2305809 2305809 defendant Richemond John husbandman 774211 774211 Richemond, John, of Acclom, husbandman 2
4846043 2310267 2310267 defendant Trusbot John   774211 774211 Trusbot, John, of Acclom, franklin 1
4853236 2312430 2312430 defendant Trussebote John husbandman 774211 774211 Trussebote, John, of Acclom, husbandman 0
4858224 2313943 2313943 defendant Richemond John husbandman 774211 774211 Richemond, John, of Acclom, husbandman 1
4988414 2353501 2353501 defendant Lynehous Peter husbandman 774211 774211 Lynehous, Peter, of Acclom, husbandman 1
5038768 2368239 2368239 defendant Trusbutte John husbandman 774211 774211 Trusbutte, John, of Acclom, husbandman 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);