names

20 rows where place_id = 606437

✎ 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
3665198 1915069 1915069 defendant Spryngold Roger husbandman 606437 606437 Spryngold, Roger, of Whatley, husbandman 0
3796113 1956650 1956650 defendant Baker Thomas husbandman 606437 606437 Baker, Thomas, of Whatley, husbandman 0
3864260 1978240 1978240 defendant Padnall John husbandman 606437 606437 Padnall, John, of Whatley, husbandman 0
3864261 1978240 1978240 defendant Wyllyams John husbandman 606437 606437 Wyllyams, John, of Whatley, husbandman 1
4118907 2067043 2067043 defendant Sharpe Humphrey glover 606437 606437 Sharpe, Humphrey, of Whatley, glover 1
4118908 2067043 2067043 defendant Deye James yeoman 606437 606437 Deye, James, of Whatley, yeoman 2
4130268 2071139 2071139 defendant Wimpewe John husbandman 606437 606437 Wimpewe, John, of Whatley, husbandman 0
4189301 2091753 2091753 defendant Parsonnes Richard thatcher 606437 606437 Parsonnes, Richard, of Whatley, husbandman, thatcher 0
4201502 2096072 2096072 defendant Wimpewe John husbandman or yeoman 606437 606437 Wimpewe, John, of Whatley, husbandman or yeoman 0
4243972 2110964 2110964 defendant Keyver Thomas yeoman 606437 606437 Keyver, Thomas, of Whatley, yeoman 2
4243986 2110968 2110968 defendant Wympewe John, junior yeoman 606437 606437 Wympewe, John, junior, of Whatley, yeoman 0
4243987 2110968 2110968 defendant Kinxman or Kinman John husbandman 606437 606437 Kinxman or Kinman, John, of Whatley, husbandman 1
4243988 2110968 2110968 defendant Boothe Richard yeoman 606437 606437 Boothe, Richard, of Whatley, yeoman 2
4674221 2257546 2257546 defendant Hay John husbandman 606437 606437 Hay, John, of Whatley, husbandman 1
5067545 2376790 2376790 defendant Stafford Henry yeoman 606437 606437 Stafford, Henry, of Whatley, yeoman 2
5230856 2424632 2424632 defendant Mylys Willim chaplain 606437 606437 Mylys, Willim, of Whatley, chaplain 0
5331099 2454372 2454372 defendant Ravyn Robert husbandman 606437 606437 Ravyn, Robert, of Whatley, husbandman 0
5331100 2454372 2454372 defendant Frankeleyn Thomas yeoman 606437 606437 Frankeleyn, Thomas, of Whatley, yeoman 1
5552893 2520898 2520898 defendant Bassemore Geoffrey tailor 606437 606437 Bassemore, Geoffrey, of Whatley, tailor 3
5584016 2530071 2530071 defendant Mawncell John butcher 606437 606437 Mawncell, John, of Whatley, butcher 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);