names

37 rows where place_id = 590930

✎ 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
3602752 1868527 1868527 defendant Wheytyng Thomas husbandman 590930 590930 Wheytyng, Thomas, of Magna Shelford, husbandman 0
3636643 1906253 1906253 defendant Mannyng William husbandman 590930 590930 Mannyng, William, of Magna Shelford, husbandman 0
3636649 1906254 1906254 defendant Mannyng William husbandman 590930 590930 Mannyng, William, of Magna Shelford, husbandman 0
3846236 1972379 1972379 defendant Ellys John husbandman 590930 590930 Ellys, John, of Magna Shelford, husbandman 1
3846237 1972379 1972379 defendant Blakeborn John husbandman 590930 590930 Blakeborn, John, of Magna Shelford, husbandman 2
4780450 2289884 2289884 defendant Collard John   590930 590930 Collard, John, of Magna Shelford, franklin 0
4783680 2290916 2290916 defendant Hubberd Geoffrey tailor 590930 590930 Hubberd, Geoffrey, of Magna Shelford, tailor 0
4788181 2292375 2292375 defendant Davy John laborer 590930 590930 Davy, John, of Magna Shelford, laborer 0
4788182 2292375 2292375 defendant Rust John husbandman 590930 590930 Rust, John, of Magna Shelford, husbandman 1
4788183 2292375 2292375 defendant Bernes John husbandman 590930 590930 Bernes, John, of Magna Shelford, husbandman 2
4788184 2292375 2292375 defendant Oldeman Simon chaplain 590930 590930 Oldeman, Simon, of Magna Shelford, chaplain 3
4859837 2314447 2314447 defendant Cole William laborer 590930 590930 Cole, William, of Magna Shelford, laborer 1
4859859 2314454 2314454 defendant Spede John husbandman 590930 590930 Spede, John, of Magna Shelford, husbandman 0
4864857 2315983 2315983 defendant Godeman alias Thatcher Peter husbandman 590930 590930 Godeman alias Thatcher, Peter, of Magna Shelford, husbandman 1
5071246 2377898 2377898 defendant Woderose John husbandman 590930 590930 Woderose, John, of Magna Shelford, husbandman 0
5073662 2378607 2378607 defendant Vykery Robert husbandman 590930 590930 Vykery, Robert, of Magna Shelford, husbandman 0
5098895 2386108 2386108 defendant Sulman John husbandman 590930 590930 Sulman, John, of Magna Shelford, husbandman 4
5106719 2388392 2388392 defendant Harrys Walter husbandman 590930 590930 Harrys, Walter, of Magna Shelford, husbandman 0
5108355 2388879 2388879 defendant Spede John husbandman 590930 590930 Spede, John, of Magna Shelford, husbandman 0
5115427 2390939 2390939 defendant Wilson John yeoman 590930 590930 Wilson, John, of Magna Shelford, yeoman 0
5115428 2390939 2390939 defendant Wilson Thomas yeoman 590930 590930 Wilson, Thomas, of Magna Shelford, yeoman 1
5122410 2392983 2392983 defendant Fallan or Phallan William clerk 590930 590930 Fallan or Phallan, William, of Magna Shelford, clerk 0
5122411 2392983 2392983 defendant Janyn Thomas carpenter 590930 590930 Janyn, Thomas, of Magna Shelford, carpenter 1
5265731 2435033 2435033 defendant Fykere Robert fuller 590930 590930 Fykere, Robert, of Magna Shelford, fuller 1
5579768 2528751 2528751 defendant Drayton William   590930 590930 Drayton, William, of Magna Shelford 0
5581462 2529271 2529271 defendant Hunte John   590930 590930 Hunte, John, of Magna Shelford, millwright 0
5583399 2529881 2529881 defendant Drayton William thatcher 590930 590930 Drayton, William, of Magna Shelford, thatcher 0
5583400 2529881 2529881 defendant Davy Thomas husbandman 590930 590930 Davy, Thomas, of Magna Shelford,husbandman 1
5583401 2529881 2529881 defendant Scott Thomas husbandman 590930 590930 Scott, Thomas, of Magna Shelford,husbandman 2
5583402 2529881 2529881 defendant Plowright Richard thatcher 590930 590930 Plowright, Richard, of Magna Shelford, thatcher 3
5583403 2529881 2529881 defendant Tysley Ralph chaplain 590930 590930 Tysley, Ralph, of Magna Shelford, chaplain 4
5583405 2529882 2529882 defendant Drayton William thatcher 590930 590930 Drayton, William, of Magna Shelford, thatcher 0
5583406 2529882 2529882 defendant Davy Thomas husbandman 590930 590930 Davy, Thomas, of Magna Shelford, husbandman 1
5583407 2529882 2529882 defendant Scot Thomas husbandman 590930 590930 Scot, Thomas, of Magna Shelford, husbandman 2
5583408 2529882 2529882 defendant Plowright Richard thatcher 590930 590930 Plowright, Richard, of Magna Shelford, thatcher 3
5583409 2529882 2529882 defendant Rysley Randolph chaplain 590930 590930 Rysley, Randolph, of Magna Shelford, chaplain 4
5627935 2552707 2552707 plaintiff Pattesle Thomas   590930 590930 Pattesle, Thomas, of Magna Shelford 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);