names

25 rows where place_id = 593040

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610176 1870846 1870846 defendant Stansshawe Richard gent 593040 593040 Stansshawe, Richard, of Sodbury, gent 0
3746845 1940934 1940934 defendant Bailly Robert weaver 593040 593040 Bailly, Robert, of Sodbury, weaver 2
3798164 1957321 1957321 defendant Parsonage Philip yeoman 593040 593040 Parsonage, Philip, of Sodbury, yeoman 0
3808368 1960490 1960490 defendant Francombe Thomas shoemaker 593040 593040 Francombe, Thomas, of Sodbury, shoemaker 3
3808544 1960549 1960549 defendant Johnson James yeoman 593040 593040 Johnson, James, of Sodbury, yeoman 0
3808846 1960646 1960646 defendant Browne Christopher gent 593040 593040 Browne, Christopher, of Sodbury, gent 2
3809122 1960736 1960736 defendant Johnson James yeoman 593040 593040 Johnson, James, of Sodbury, yeoman 2
3815541 1962775 1962775 defendant Parsonage Nicholas yeoman 593040 593040 Parsonage, Nicholas, of Sodbury, yeoman 0
3839493 1970276 1970276 defendant Johnson James yeoman 593040 593040 Johnson, James, of Sodbury, gent, yeoman 0
3839688 1970340 1970340 defendant Bayly William tucker 593040 593040 Bayly, William, of Sodbury, tucker 0
3938344 2003161 2003161 defendant Colymore John clothman 593040 593040 Colymore, John, of Sodbury, clothman 0
3938345 2003161 2003161 defendant Smyth Thomas smith 593040 593040 Smyth, Thomas, of Sodbury, smith 1
3938347 2003162 2003162 defendant Colymore John clothman 593040 593040 Colymore, John, of Sodbury, clothman 0
3938348 2003162 2003162 defendant Smyth Thomas smith 593040 593040 Smyth, Thomas, of Sodbury, smith 1
4233211 2107125 2107125 defendant Flewellyn John clothier 593040 593040 Flewellyn, John, of Sodbury, clothier 1
4400370 2164718 2164718 defendant Batten George husbandman 593040 593040 Batten, George, of Sodbury, husbandman 0
4431531 2174630 2174630 defendant Hamond John   593040 593040 Hamond, John, of Sodbury, son of Hugh 0
4765021 2285035 2285035 defendant Lye Walter drover 593040 593040 Lye, Walter, of Sodbury, drover 2
5044273 2369919 2369919 plaintiff Hamsted Robert   593040 593040 Hamsted, Robert, of Sodbury 0
5057197 2373729 2373729 defendant Gough John yeoman 593040 593040 Gough, John, of Sodbury, yeoman 3
5079905 2380469 2380469 plaintiff Chaundeler Richard weaver 593040 593040 Chaundeler, Richard, of Sodbury, weaver 0
5219902 2421533 2421533 defendant Cowly Richard husbandman 593040 593040 Cowly, Richard, of Sodbury, husbandman 1
5232719 2425150 2425150 plaintiff Burnell Margery widow 593040 593040 Burnell, Margery, of Sodbury, widow 0
5565237 2524418 2524418 defendant Harold John yeoman 593040 593040 Harold, John, of Sodbury, yeoman 0
5576273 2527636 2527636 plaintiff Tayllour Robert clothier 593040 593040 Tayllour, Robert, of Sodbury, clothier 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);