names

17 rows where place_id = 655833

✎ 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
3937752 2002959 2002959 plaintiff Parker Thomas gent 655833 655833 Parker, Thomas, of North Leach, gent 0
3937755 2002959 2002959 defendant Emson Humphrey glover 655833 655833 Emson, Humphrey, of North Leach, glover 2
4449346 2184743 2184743 defendant Boreford Thomas   655833 655833 Boreford, Thomas, of North Leach 1
4638047 2242661 2242661 defendant Leget John   655833 655833 Leget, John, of North Leach 0
4704555 2266801 2266801 defendant Venynton Richard weaver 655833 655833 Venynton, Richard, of North Leach, weaver 0
4728124 2274044 2274044 defendant Hoper Thomas hoper 655833 655833 Hoper, Thomas, of North Leach, hoper 0
4768187 2286021 2286021 defendant Leget John husbandman 655833 655833 Leget, John, of North Leach, husbandman 1
4846481 2310407 2310407 defendant Yateman William butcher 655833 655833 Yateman, William, of North Leach, butcher 0
4846569 2310436 2310436 defendant (illegible) William butcher 655833 655833 _, William, of North Leach, butcher 1
4925992 2334559 2334559 defendant Solers John butcher 655833 655833 Solers, John, of North Leach, butcher 1
4999410 2356694 2356694 defendant White Geoffrey   655833 655833 White, Geoffrey, of North Leach, shoe maker 0
5305123 2446536 2446536 plaintiff Kynge William   655833 655833 Kynge, William, of North Leach 0
5387320 2471446 2471446 defendant Pyers John chapman 655833 655833 Pyers, John, of North Leach, chapman 2
5409896 2477929 2477929 defendant Baker Geoffrey innholder 655833 655833 Baker, Geoffrey, of North Leach, innholder 1
5409897 2477929 2477929 defendant Parker Thomas chapman 655833 655833 Parker, Thomas, of North Leach, chapman 2
5476380 2497939 2497939 defendant Peiers John chapman 655833 655833 Peiers, John, of North Leach, chapman 4
5613188 2547908 2547908 defendant Sprot John   655833 655833 Sprot, John, of North Leach 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);