names

65 rows where place_id = 592443

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589899 1864481 1864481 defendant Roket Thomas   592443 592443 Roket, Thomas, of Surlyngham, husbandman, executyors of 2
3607709 1870065 1870065 defendant Tayllour John yeoman 592443 592443 Tayllour, John, of Surlyngham, yeoman 0
3676515 1918698 1918698 defendant Logan Stephen clerk 592443 592443 Logan, Stephen, of Surlyngham, clerk 1
3676519 1918699 1918699 defendant Logon Stephen clerk 592443 592443 Logon, Stephen, of Surlyngham, clerk 1
3719050 1932234 1932234 defendant Kempe Robert husbandman 592443 592443 Kempe, Robert, of Surlyngham, husbandman 3
3779202 1951215 1951215 defendant Lesyngham German husbandman 592443 592443 Lesyngham, German, of Surlyngham, husbandman 3
3876138 1982267 1982267 defendant Chavite Ralph husbandman 592443 592443 Chavite, Ralph, of Surlyngham, husbandman 2
3966129 2012779 2012779 defendant Budde John carpenter 592443 592443 Budde, John, of Surlyngham, carpenter 0
3972497 2014958 2014958 defendant Salaman Richard husbandman 592443 592443 Salaman, Richard, of Surlyngham, husbandman 0
3984639 2019264 2019264 defendant Salaman Richard husbandman 592443 592443 Salaman, Richard, of Surlyngham, husbandman 1
3986617 2019953 2019953 plaintiff Whode Reginald husbandman 592443 592443 Whode, Reginald, of Surlyngham, husbandman 0
3992036 2021917 2021917 defendant Sporle John husbandman 592443 592443 Sporle, John, of Surlyngham, husbandman 0
3992037 2021917 2021917 defendant Mosse Simon   592443 592443 Mosse, Simon, of Surlyngham, husbandman, administrators of 1
3992039 2021917 2021917 defendant Tylney Richard husbandman 592443 592443 Tylney, Richard, of Surlyngham, husbandman 3
3996019 2023331 2023331 defendant Calver John, senior husbandman 592443 592443 Calver, John, senior, of Surlyngham, husbandman 1
3996041 2023336 2023336 defendant Calver John, senior husbandman 592443 592443 Calver, John, senior, of Surlyngham, husbandman 1
4041261 2039363 2039363 defendant Stacye Roger yeoman 592443 592443 Stacye, Roger, of Surlyngham, yeoman 0
4089979 2056699 2056699 defendant Umfrey Robert clerk 592443 592443 Umfrey, Robert, of Surlyngham, clerk 0
4112516 2064732 2064732 defendant Weston John husbandman 592443 592443 Weston, John, of Surlyngham, husbandman 2
4137425 2073735 2073735 defendant Bawedry Richard husbandman 592443 592443 Bawedry, Richard, of Surlyngham, husbandman 0
4433790 2175332 2175332 defendant Cartere John le   592443 592443 Cartere, John le, of Surlyngham 4
4451742 2185518 2185518 defendant Bonde Walter   592443 592443 Bonde, Walter, of Surlyngham 0
4542676 2213596 2213596 defendant Pawele John   592443 592443 Pawele, John, of Surlyngham 2
4556065 2217838 2217838 defendant Stoke Thomas   592443 592443 Stoke, Thomas, of Surlyngham 0
4666865 2255365 2255365 defendant Matte Thomas yeoman 592443 592443 Matte, Thomas, of Surlyngham, yeoman 0
4695738 2264150 2264150 plaintiff Bunche Roger   592443 592443 Bunche, Roger, of Surlyngham 0
4695739 2264150 2264150 defendant Stote John yeoman 592443 592443 Stote, John, of Surlyngham, yeoman 0
4722438 2272337 2272337 defendant Warmale Agnes spinster 592443 592443 Warmale, Agnes, of Surlyngham, spinster 1
4736881 2276663 2276663 defendant Couk John yeoman 592443 592443 Couk, John, of Surlyngham, yeoman 0
4741242 2277938 2277938 plaintiff Halles Nicholas clerk 592443 592443 Halles, Nicholas, of Surlyngham, clerk 2
4795216 2294652 2294652 defendant Cok John yeoman 592443 592443 Cok, John, of Surlyngham, yeoman 3
4844885 2309921 2309921 defendant Spalle Richard husbandman 592443 592443 Spalle, Richard, of Surlyngham, husbandman 0
4924534 2334112 2334112 defendant Fyssher Richard husbandman 592443 592443 Fyssher, Richard, of Surlyngham, husbandman 2
4932281 2336499 2336499 defendant Godwyn William   592443 592443 Godwyn, William, of Surlyngham 2
4932282 2336499 2336499 defendant Stote William yeoman 592443 592443 Stote, William, of Surlyngham, yeoman 3
4932295 2336501 2336501 defendant Aylemer Thomas husbandman 592443 592443 Aylemer, Thomas, of Surlyngham, husbandman 4
4936764 2337875 2337875 defendant Cotwode Geoffrey yeoman 592443 592443 Cotwode, Geoffrey, of Surlyngham, yeoman 5
5000518 2357022 2357022 defendant Pertryk Thomas husbandman 592443 592443 Pertryk, Thomas, of Surlyngham, husbandman 3
5000519 2357022 2357022 defendant Roket Thomas husbandman 592443 592443 Roket, Thomas, of Surlyngham, husbandman 4
5008658 2359426 2359426 defendant Warmale Geoffrey husbandman 592443 592443 Warmale, Geoffrey, of Surlyngham, husbandman 0
5047196 2370782 2370782 defendant Coyne John husbandman 592443 592443 Coyne, John, of Surlyngham, husbandman 1
5075191 2379074 2379074 defendant Lesyngham Thomas   592443 592443 Lesyngham, Thomas, of Surlyngham, bailiff 9
5075203 2379075 2379075 defendant Lesyngham Thomas   592443 592443 Lesyngham, Thomas, of Surlyngham, bailiff 10
5081286 2380913 2380913 defendant Goldsmyth William yeoman 592443 592443 Goldsmyth, William, of Surlyngham, yeoman 3
5116089 2391133 2391133 defendant Lesyngham Thomas, junior yeoman 592443 592443 Lesyngham, Thomas, junior, of Surlyngham, yeoman 4
5126952 2394362 2394362 defendant Roket Thomas husbandman 592443 592443 Roket, Thomas, of Surlyngham, husbandman 1
5148386 2400664 2400664 defendant Potter Richard yeoman 592443 592443 Potter, Richard, of Surlyngham, yeoman 4
5167674 2406269 2406269 defendant Potter Richard yeoman 592443 592443 Potter, Richard, of Surlyngham, yeoman 4
5296974 2444110 2444110 defendant Lyston John husbandman 592443 592443 Lyston, John, of Surlyngham, husbandman 0
5296975 2444110 2444110 defendant Roket Thomas husbandman 592443 592443 Roket, Thomas, of Surlyngham, husbandman 1
5296976 2444110 2444110 defendant Roket William husbandman 592443 592443 Roket, William, of Surlyngham, husbandman 2
5304315 2446293 2446293 defendant Wyllyamson Robert yeoman 592443 592443 Wyllyamson, Robert, of Surlyngham, yeoman 4
5332323 2454733 2454733 defendant Rohet Thomas (legal representative) 592443 592443 Rohet, Thomas, of Surlyngham, administratrix of 0
5482904 2499830 2499830 defendant Roket John husbandman 592443 592443 Roket, John, of Surlyngham, husbandman 1
5482905 2499830 2499830 defendant Roket John yeoman 592443 592443 Roket, John, of Surlyngham, yeoman 2
5515453 2509678 2509678 defendant Warmall John yeoman 592443 592443 Warmall, John, of Surlyngham,yeoman 1
5578694 2528399 2528399 plaintiff Grene John   592443 592443 Grene, John, of Surlyngham 2
5578698 2528400 2528400 plaintiff Grene John   592443 592443 Grene, John, of Surlyngham 2
5578703 2528401 2528401 plaintiff Grene John   592443 592443 Grene, John, of Surlyngham 2
5580730 2529053 2529053 defendant Greve Andrew husbandman 592443 592443 (Greve, Andrew, of Surlyngham, husbandman 1
5580731 2529053 2529053 defendant Holme Robert husbandman 592443 592443 Holme, Robert, of Surlyngham, husbandman 2
5581942 2529434 2529434 defendant Sandwyche William yeoman 592443 592443 Sandwyche, William, of Surlyngham, yeoman 1
5581943 2529434 2529434 defendant Sandwyche Richard yeoman 592443 592443 Sandwyche, Richard, of Surlyngham, yeoman 2
5594066 2533124 2533124 plaintiff Grene John   592443 592443 Grene, John, of Surlyngham 2
5597270 2534055 2534055 defendant Greve Andrew husbandman 592443 592443 Greve, Andrew, of Surlyngham, husbandman 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);