names

31 rows where place_id = 670405

✎ 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
3655901 1912099 1912099 defendant Kelke Thomas yeoman 670405 670405 Kelke, Thomas, of Burton, Lincs, yeoman 0
3769866 1948228 1948228 defendant Waitman John yeoman 670405 670405 Waitman, John, of Burton Stater, Lincs, yeoman 2
3787297 1953819 1953819 defendant Waitman John yeoman 670405 670405 Waitman, John, of Burton Scater, Lincs, yeoman 2
3803608 1959041 1959041 defendant Waitman John yeoman 670405 670405 Waitman, John, of Burton Stater, Lincs, yeoman 2
3943795 2004939 2004939 defendant Hamerton Hugh yeoman 670405 670405 Hamerton, Hugh, of Burton, Lincs, yeoman 1
3996909 2023660 2023660 defendant Parratt Andrea widow 670405 670405 Parratt, Andrea, of Burton Stather, Lincs, widow 1
4012856 2029322 2029322 defendant Dawson Mathew husbandman 670405 670405 Dawson, Mathew, of Burton, Lincs, husbandman 1
4017486 2030958 2030958 plaintiff Thorpe Francis (legal representative) 670405 670405 Thorpe, Francis, of Burton Stather, Lincs, merchant or yeoman or gent, administrator of 0
4017492 2030959 2030959 plaintiff Thorpe Francis (legal representative) 670405 670405 Thorpe, Francis, of Burton Stather, Lincs, merchant or yeoman or gent, administrator of 0
4064784 2047689 2047689 defendant Jackson Ralph ferryman 670405 670405 Jackson, Ralph, of Burton Stater, Lincs, ferryman 0
4146485 2076922 2076922 defendant Ellistons Thomas yeoman 670405 670405 Ellistons, Thomas, of Burton, Lincs, yeoman 0
4243428 2110793 2110793 defendant Bartholomewe Joan widow 670405 670405 Bartholomewe, Joan, of Burton Stather, Lincs, widow 1
4266852 2118555 2118555 defendant Bartholomew Joan widow 670405 670405 Bartholomew, Joan, of Burton Stather, Lincs, widow 1
4758569 2283058 2283058 defendant Feryby Thomas husbandman 670405 670405 Feryby, Thomas, of Burton, Lincs, husbandman 0
4774456 2287995 2287995 defendant Feryby Thomas husbandman 670405 670405 Feryby, Thomas, of Burton, Lincs, husbandman 0
4963481 2345989 2345989 defendant Fereby William clerk 670405 670405 Fereby, William, of Burton Stather, Lincs, clerk 3
4971189 2348320 2348320 defendant Bury Henry chapman 670405 670405 Bury, Henry, of Burton Stather, Lincs, chapman 0
4988106 2353418 2353418 defendant Mason Roger fishmonger 670405 670405 Mason, Roger, of Burton Stather, Lincs, fishmonger 0
4989895 2353890 2353890 defendant Fereby William clerk 670405 670405 Fereby, William, of Burton Stather, Lincs, clerk 1
5014393 2361071 2361071 defendant atte Halle John yeoman 670405 670405 atte Halle, John, of Burton Stather, Lincs, yeoman 0
5014397 2361072 2361072 defendant atte Halle John yeoman 670405 670405 atte Halle, John, of Burton Stather, Lincs, yeoman 1
5134217 2396502 2396502 defendant Rolgarth John husbandman 670405 670405 (Rolgarth, John, of Burton, Lincs, husbandman 1
5145793 2399905 2399905 defendant Hall John yeoman 670405 670405 Hall, John, of Burton Stather, Lincs, yeoman 9
5166136 2405828 2405828 defendant Hall John yeoman 670405 670405 Hall, John, of Burton Stather, Lincs, yeoman 10
5258956 2432916 2432916 defendant Sutton Hamon (legal representative) 670405 670405 Sutton, Hamon, of Burton, Lincs, esq, executor of Sutton, Hamon, of Lincoln, merchant, executrix of 0
5490108 2501923 2501923 defendant Smyth William yeoman 670405 670405 Smyth, William, of Burton Stater, Lincs, yeoman 0
5490111 2501924 2501924 defendant Smyth William husbandman 670405 670405 Smyth, William, of Burton Stater, Lincs, husbandman 0
5531824 2514497 2514497 defendant Portyngton Otwell merchant 670405 670405 Portyngton, Otwell, of Burton Stather, Lincs, merchant 0
5544869 2518501 2518501 defendant Haweden Robert mercer 670405 670405 Haweden, Robert, of Burton Stather, Lincs, mercer 2
5549039 2519757 2519757 defendant Smyth William yeoman 670405 670405 Smyth, William, of Burton Stater, Lincs, yeoman 3
5581735 2529366 2529366 defendant Tod Nicholas yeoman 670405 670405 Tod, Nicholas, of Burton, Lincs, yeoman 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);