names

18 rows where place_id = 662027

✎ 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
3963518 2011848 2011848 plaintiff Yerbry Humphrey clothier 662027 662027 Yerbry, Humphrey, of Bekynton, clothier 0
4501952 2201207 2201207 defendant Atkyns Joh   662027 662027 Atkyns, Joh, of Bekynton 9
4673654 2257391 2257391 defendant Dawe John weaver 662027 662027 Dawe, John, of Bekynton, weaver 1
4683821 2260550 2260550 defendant Capud alias Seler John weaver 662027 662027 Capud alias Seler, John, of Bekynton, weaver 0
4683822 2260550 2260550 defendant Roper John weaver 662027 662027 Roper, John, of Bekynton, weaver 1
4686703 2261454 2261454 defendant Patryk Richard husbandman 662027 662027 Patryk, Richard, of Bekynton, husbandman 0
4701421 2265848 2265848 defendant Prynce Richard   662027 662027 Prynce, Richard, of Bekynton, w_ or weaver 0
4710306 2268578 2268578 defendant Prynce Richard weaver 662027 662027 Prynce, Richard, of Bekynton, weaver 0
4785859 2291609 2291609 defendant Asshewell John weaver 662027 662027 Asshewell, John, of Bekynton, weaver 0
4803908 2297402 2297402 defendant Dosse John husbandman 662027 662027 Dosse, John, of Bekynton, husbandman 0
4820571 2302505 2302505 defendant Bosse John   662027 662027 Bosse, John, of Bekynton, mason 0
5102068 2387028 2387028 defendant Lane John weaver 662027 662027 Lane, John, of Bekynton, weaver 8
5102069 2387028 2387028 defendant Purveyour John weaver 662027 662027 Purveyour, John, of Bekynton, weaver 9
5117326 2391502 2391502 defendant Broun Thomas yeoman 662027 662027 Broun, Thomas, of Bekynton, yeoman 0
5117329 2391502 2391502 defendant Plesaunce William weaver 662027 662027 Plesaunce, William, of Bekynton, weaver 3
5117333 2391502 2391502 defendant Lane John weaver 662027 662027 Lane, John, of Bekynton, weaver 7
5117334 2391502 2391502 defendant Purveyour John weaver 662027 662027 Purveyour, John, of Bekynton, weaver 8
5119803 2392230 2392230 defendant Merbury Thomas tailor 662027 662027 Merbury, Thomas, of Bekynton, tailor 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);