names

31 rows where place_id = 605232

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3660832 1913654 1913654 defendant Hayne Edward merchant 605232 605232 Hayne, Edward, of Bridgwater, Soms, merchant 0
3945640 2005549 2005549 defendant Watkyns John, senior mercer 605232 605232 Watkyns, John, senior, of Bridgwater, Soms, mercer 0
4001299 2025243 2025243 defendant Watkyns John chapman 605232 605232 Watkyns, John, of Bridgwater, Soms, chapman 0
4117233 2066469 2066469 defendant Fowler Derbeus or Derby chapman 605232 605232 Fowler, Derbeus or Derby, of Bridgwater, Soms, chapman 2
4148138 2077481 2077481 defendant Porter John merchant 605232 605232 Porter, John, of Bridgwater, Soms, merchant 0
4161790 2082192 2082192 defendant Bowringe Robert   605232 605232 Bowringe, Robert, of Bridgwater, Soms, linen draper 0
4162153 2082319 2082319 defendant Morley Humphrey chapman 605232 605232 Morley, Humphrey, of Bridgwater, Soms, chapman 0
4162159 2082320 2082320 defendant Morley Humphrey chapman 605232 605232 Morley, Humphrey, of Bridgwater, Soms, chapman 0
4208023 2098366 2098366 defendant Chappell John merchant 605232 605232 Chappell, John, of Bridgwater, Soms, merchant 2
4212990 2100068 2100068 defendant Castellman Jasper merchant 605232 605232 Castellman, Jasper, of Bridgwater, Soms, merchant 0
4268216 2118985 2118985 defendant Thomas William merchant 605232 605232 Thomas, William, of Bridgwater, Soms, merchant 0
4285378 2124818 2124818 defendant C astellman James mercer 605232 605232 C astellman, James, of Bridgwater, Soms, mercer 2
4317295 2136163 2136163 defendant Castellman Jasper chapman 605232 605232 Castellman, Jasper, of Bridgwater, Soms, chapman 0
4328113 2139718 2139718 defendant Neyle Richard husbandman 605232 605232 Neyle, Richard, of Bridgwater, Soms, husbandman 0
4353871 2148577 2148577 defendant Thomas William chapman 605232 605232 Thomas, William, of Bridgwater, Soms, chapman 0
4353873 2148578 2148578 defendant Thomas John chapman 605232 605232 Thomas, John, of Bridgwater, Soms, chapman 0
4356248 2149409 2149409 defendant Jenkyns Thomas gent 605232 605232 Jenkyns, Thomas, of Bridgwater, Soms, gent 0
4357053 2149697 2149697 defendant Baker Thomas chapman 605232 605232 Baker, Thomas, of Bridgwater, Soms, chapman 0
4357057 2149698 2149698 defendant Baker Thomas chapman 605232 605232 Baker, Thomas, of Bridgwater, Soms, chapman 0
4369010 2153979 2153979 defendant Jenkins Thomas gent 605232 605232 Jenkins, Thomas, of Bridgwater, Soms, gent 2
4369546 2154167 2154167 defendant Bennett Thomas clothier 605232 605232 Bennett, Thomas, of Bridgwater, Soms, clothier 1
4378624 2157425 2157425 defendant Popham George merchant 605232 605232 Popham, George, of Bridgwater, Soms, merchant 3
4390115 2161314 2161314 defendant Buckynge Robert merchant 605232 605232 Buckynge, Robert, of Bridgwater, Soms, merchant 0
4400482 2164755 2164755 defendant Leman Thomas yeoman 605232 605232 Leman, Thomas, of Bridgwater, Soms, yeoman 2
4408183 2167308 2167308 defendant Neeld Richard husbandman 605232 605232 Neeld, Richard, of Bridgwater, Soms, husbandman 0
4694971 2263919 2263919 defendant Gascoigne William gent 605232 605232 (Gascoigne, William, of Bridgwater, Soms, gent 3
4710579 2268666 2268666 defendant Bakere Walter chapman 605232 605232 Bakere, Walter, of Bridgwater, Soms, chapman 3
5162848 2404854 2404854 plaintiff Walsshe John dyer 605232 605232 Walsshe, John, of Bridgwater, Soms, dyer 0
5176742 2408882 2408882 plaintiff Walsshe John dyer 605232 605232 Walsshe, John, of Bridgwater, Soms, dyer 0
5303621 2446078 2446078 defendant Michell William mercer 605232 605232 Michell, William, of Bridgwater, Soms, mercer 2
5431047 2484224 2484224 defendant Grygge John husbandman 605232 605232 Grygge, John, of Bridgwater, Soms, husbandman 2

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