names

14 rows where place_id = 772137

✎ 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
4585735 2226962 2226962 defendant Smyth Thomas   772137 772137 Smyth, Thomas, of Great Bowedon 0
4606528 2233154 2233154 plaintiff atte Graunge Richard   772137 772137 atte Graunge, Richard, of Great Bowedon 1
4671917 2256863 2256863 defendant Basset John   772137 772137 Basset, John, of Great Bowedon 0
4724570 2272982 2272982 defendant Gardevyle William   772137 772137 Gardevyle, William, of Great Bowedon 1
4724571 2272982 2272982 defendant Shyrewode John husbandman 772137 772137 Shyrewode, John, of Great Bowedon, husbandman 2
4724572 2272982 2272982 defendant Ingolde John husbandman 772137 772137 Ingolde, John, of Great Bowedon, husbandman 3
4819398 2302141 2302141 defendant Emson Thomas husbandman 772137 772137 Emson, Thomas, of Great Bowedon, husbandman 1
4837325 2307616 2307616 plaintiff Forster John   772137 772137 Forster, John, of Great Bowedon, parson 0
5002140 2357531 2357531 defendant Gerveys William husbandman 772137 772137 Gerveys, William, of Great Bowedon, husbandman 0
5002141 2357531 2357531 defendant Basset John husbandman 772137 772137 Basset, John, of Great Bowedon, husbandman 1
5002142 2357531 2357531 defendant Neubery William husbandman 772137 772137 Neubery, William, of Great Bowedon, husbandman 2
5049171 2371389 2371389 defendant Eston John shoemaker 772137 772137 Eston, John, of Great Bowedon, shoemaker 0
5049172 2371389 2371389 defendant Gardevyle William smith 772137 772137 Gardevyle, William, of Great Bowedon, smith 1
5402180 2475692 2475692 defendant Kyng Thomas husbandman 772137 772137 Kyng, Thomas, of Great Bowedon, husbandman 4

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