names

24 rows where place_id = 612200

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692082 1923692 1923692 defendant Tayler Elizabeth spinster 612200 612200 Tayler, Elizabeth, of Long Hope, spinster 3
3897139 1989260 1989260 defendant Dobbys Thomas husbandman 612200 612200 Dobbys, Thomas, of Long Hope, husbandman, son of Dobbys, Richard, husbandman 0
3897142 1989261 1989261 defendant Gorgh Robert smith 612200 612200 Gorgh, Robert, of Long Hope, smith 0
3897151 1989264 1989264 defendant Wyncell Thomas yeoman 612200 612200 Wyncell, Thomas, of Long Hope, yeoman 0
3964226 2012095 2012095 defendant Hooper William husbandman 612200 612200 Hooper, William, of Long Hope, husbandman 0
3964227 2012095 2012095 defendant Hooper Thomas husbandman 612200 612200 Hooper, Thomas, of Long Hope, husbandman 1
3964228 2012095 2012095 defendant Hooper James laborer 612200 612200 Hooper, James, of Long Hope, laborer 2
3981822 2018256 2018256 defendant Dobbes Clement husbandman 612200 612200 Dobbes, Clement, of Long Hope, husbandman 0
3989019 2020814 2020814 defendant Nycoll William smith 612200 612200 Nycoll, William, of Long Hope, smith 0
3989021 2020815 2020815 defendant Reynold William yeoman 612200 612200 Reynold, William, of Long Hope, yeoman 0
4067848 2048811 2048811 defendant Davys George yeoman 612200 612200 Davys, George, of Long Hope, yeoman 1
4133735 2072397 2072397 defendant Steavens John husbandman 612200 612200 Steavens, John, of Long Hope, husbandman 0
4157919 2080841 2080841 defendant Nurse Thomas yeoman 612200 612200 Nurse, Thomas, of Long Hope, yeoman 0
4218026 2101801 2101801 defendant Dawe Maurice (legal representative) 612200 612200 Dawe, Maurice, of Long Hope, yeoman, executrix of 1
4218027 2101801 2101801 defendant Dawe Eleanor widow 612200 612200 Dawe, Eleanor, of Long Hope, widow 2
4231925 2106665 2106665 defendant Dawe Richard yeoman 612200 612200 Dawe, Richard, of Long Hope, yeoman 0
4231926 2106665 2106665 defendant Dawe Thomas yeoman 612200 612200 Dawe, Thomas, of Long Hope, yeoman 1
4304726 2131786 2131786 defendant Hodges Margaret widow 612200 612200 Hodges, Margaret, of Long Hope, widow 0
4317515 2136241 2136241 defendant Bullocke John husbandman 612200 612200 Bullocke, John, of Long Hope, husbandman 1
4321468 2137598 2137598 defendant Drewe James yeoman 612200 612200 Drewe, James, of Long Hope, yeoman 4
4323880 2138399 2138399 defendant Reade Thomas yeoman 612200 612200 Reade, Thomas, of Long Hope, yeoman 0
4323881 2138399 2138399 defendant Gwent John yeoman 612200 612200 Gwent, John, of Long Hope, yeoman 1
4362681 2151712 2151712 defendant Abevan David yeoman 612200 612200 Abevan, David, of Long Hope, yeoman 0
4404846 2166189 2166189 defendant Robyns Richard husbandman 612200 612200 Robyns, Richard, of Long Hope, husbandman 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);