names

253 rows where place_id = 591949

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606091 1869572 1869572 defendant Fyssher William yeoman 591949 591949 Fyssher, William, of Thorp, yeoman 0
3607399 1869975 1869975 defendant Bernard Stephen husbandman 591949 591949 Bernard, Stephen, of Thorp, husbandman 2
3607404 1869976 1869976 defendant Bernard Stephen husbandman 591949 591949 Bernard, Stephen, of Thorp, husbandman 1
3628725 1903860 1903860 defendant Harvy Thomas husbandman 591949 591949 Harvy, Thomas, of Thorp, husbandman 0
3628774 1903876 1903876 defendant Hobson Hugh husbandman 591949 591949 Hobson, Hugh, of Thorp, husbandman 0
3632035 1904836 1904836 defendant Adam William yeoman 591949 591949 Adam, William, of Thorp, yeoman 0
3635789 1905994 1905994 defendant Bere John husbandman 591949 591949 Bere, John, of Thorp, husbandman 1
3638436 1906843 1906843 defendant Thorp Thomas husbandman 591949 591949 Thorp, Thomas, of Thorp, husbandman 0
3638437 1906843 1906843 defendant Cleybrok William husbandman 591949 591949 Cleybrok, William, of Thorp, husbandman 1
3674936 1918191 1918191 plaintiff Gybthorp William (legal representative) 591949 591949 Gybthorp, William, of Thorp, executors of 0
3677156 1918895 1918895 defendant Thumkyn William laborer 591949 591949 Thumkyn, William, of Thorp, laborer 9
3678556 1919350 1919350 defendant Warde Alexander yeoman 591949 591949 Warde, Alexander, of Thorp, yeoman 5
3709263 1929195 1929195 defendant Thorp Bartholomew yeoman 591949 591949 Thorp, Bartholomew, of Thorp, yeoman 0
3710687 1929663 1929663 defendant Stewarde Nicholas mercer 591949 591949 Stewarde, Nicholas, of Thorp, mercer 2
3715579 1931159 1931159 defendant Cowper William husbandman 591949 591949 Cowper, William, of Thorp, husbandman 3
3715583 1931160 1931160 defendant Cowper William husbandman 591949 591949 Cowper, William, of Thorp, husbandman 2
3720493 1932693 1932693 defendant Spycer William gent 591949 591949 Spycer, William, of Thorp Hawker, gent 0
3720837 1932809 1932809 defendant Fryer Richard fisher 591949 591949 Fryer, Richard, of Thorp, fisher 3
3724945 1934089 1934089 defendant Damport Nicholas yeoman 591949 591949 Damport, Nicholas, of Thorp Edmer, yeoman 0
3742697 1939588 1939588 defendant Nicolson Thomas husbandman 591949 591949 Nicolson, Thomas, of Thorp Edmer, husbandman 0
3744501 1940182 1940182 defendant Wolay Richard laborer 591949 591949 Wolay, Richard, of Thorp, laborer 0
3744502 1940182 1940182 defendant Wolay Humphrey laborer 591949 591949 Wolay, Humphrey, of Thorp, laborer 1
3744503 1940182 1940182 defendant Baynbryg John laborer 591949 591949 Baynbryg, John, of Thorp, laborer 2
3744504 1940182 1940182 defendant Baynbryg Robert husbandman 591949 591949 Baynbryg, Robert, of Thorp, husbandman 3
3757303 1944264 1944264 defendant Rolandson Thomas yeoman 591949 591949 Rolandson, Thomas, of Thorp, yeoman 1
3761028 1945452 1945452 defendant Sadler Henry laborer 591949 591949 Sadler, Henry, of Thorp, laborer 1
3791586 1955207 1955207 defendant Oreffe Nicholas butcher 591949 591949 Oreffe, Nicholas, of Thorp, butcher 1
3799082 1957622 1957622 defendant Harwood William husbandman 591949 591949 Harwood, William, of Thorp, husbandman 0
3838040 1969809 1969809 defendant Kent John smith 591949 591949 Kent, John, of Thorp, smith 0
3848286 1973034 1973034 defendant Vere Nicholas husbandman 591949 591949 Vere, Nicholas, of Thorp, husbandman 0
3856292 1975585 1975585 defendant Caunterell Ralph gent 591949 591949 Caunterell, Ralph, of Thorp, gent 4
3862344 1977594 1977594 defendant Thecher Robert bargeman 591949 591949 (Thecher, Robert, of Thorp, bargeman 1
3864933 1978475 1978475 defendant Sparhawke William   591949 591949 Sparhawke, William, of Thorp, shipwright 0
3864934 1978475 1978475 defendant Barbour Edward tailor 591949 591949 Barbour, Edward, of Thorp, tailor 1
3866347 1978980 1978980 defendant Baresford Thomas yeoman 591949 591949 Baresford, Thomas, of Thorp, yeoman 0
3881717 1984135 1984135 defendant Vere Nicholas husbandman 591949 591949 Vere, Nicholas, of Thorp, husbandman 1
3882352 1984357 1984357 defendant Sheffeld Michael gent 591949 591949 Sheffeld, Michael, of Thorp by Water, gent 0
3883970 1984908 1984908 defendant Johnson William husbandman 591949 591949 Johnson, William, of Thorp, husbandman 1
3883974 1984909 1984909 defendant Johnson William husbandman 591949 591949 Johnson, William, of Thorp, husbandman 1
3891451 1987408 1987408 defendant Clypwell John laborer 591949 591949 Clypwell, John, of Thorp, laborer 2
3891456 1987409 1987409 defendant Clypwell John laborer 591949 591949 Clypwell, John, of Thorp, laborer 2
3910205 1993727 1993727 defendant Sheffyld Michael gent 591949 591949 Sheffyld, Michael, of Thorp, gent 2
3912124 1994379 1994379 defendant Percy Henry gent 591949 591949 Percy, Henry, of Thorp, gent 0
3915171 1995432 1995432 defendant Forde Elizabeth widow 591949 591949 Forde, Elizabeth, of Thorp, widow 1
3922992 1997996 1997996 defendant Wood Edmund laborer 591949 591949 Wood, Edmund, of Thorp, laborer 3
3927214 1999439 1999439 plaintiff Aleyn Geoffrey (legal representative) 591949 591949 Aleyn, Geoffrey, of Thorp, gent, executor of 0
3974281 2015572 2015572 defendant Rayneham Roger husbandman 591949 591949 Rayneham, Roger, of Thorp, husbandman 0
4132145 2071811 2071811 defendant Langwood Robert yeoman 591949 591949 Langwood, Robert, of Thorp, yeoman 0
4152019 2078817 2078817 defendant Kyplinge William yeoman 591949 591949 Kyplinge, William, of Thorp, yeoman 0
4363548 2152035 2152035 defendant Byxsby Thomas husbandman 591949 591949 Byxsby, Thomas, of Thorp, husbandman 3
4387787 2160553 2160553 defendant Goslynge William glover 591949 591949 Goslynge, William, of Thorp, glover 1
4410193 2168011 2168011 defendant Jenkyns Robert laborer 591949 591949 Jenkyns, Robert, of Thorp, laborer 1
4417897 2170474 2170474 plaintiff Taillour William le   591949 591949 Taillour, William le, of Thorp 0
4420501 2171318 2171318 defendant Stanton John de   591949 591949 Stanton, John de, of Thorp, son of Giles 4
4420506 2171318 2171318 defendant Bateman John   591949 591949 Bateman, John, of Thorp 9
4420514 2171319 2171319 defendant Stanton John de   591949 591949 Stanton, John de, of Thorp, son of Giles 4
4420519 2171319 2171319 defendant Bateman John   591949 591949 Bateman, John, of Thorp 9
4430178 2174215 2174215 plaintiff Wryght John   591949 591949 Wryght, John, of Thorp 0
4434485 2175543 2175543 defendant Skargille William de   591949 591949 Skargille, William de, of Thorp, knight, vouched by Bakworth, William de 0
4442690 2182663 2182663 defendant Tolby William   591949 591949 Tolby, William, of Thorp, parson 0
4454356 2186380 2186380 defendant atte Hill Adam   591949 591949 atte Hill, Adam, of Thorp 15
4459274 2187947 2187947 plaintiff Wukeham Nicholas de   591949 591949 Wukeham, Nicholas de, of Thorp, prebendary of the prebend 1
4459891 2188147 2188147 defendant Turnour William   591949 591949 Turnour, William, of Thorp 2
4460917 2188482 2188482 defendant Mandrel John   591949 591949 Mandrel, John, of Thorp 1
4462818 2189068 2189068 defendant Satlworthman Nicholas de hawker 591949 591949 Satlworthman, Nicholas de, of Thorp, hawker 2
4468042 2190675 2190675 defendant Norton John de   591949 591949 Norton, John de, of Thorp 0
4469313 2191075 2191075 plaintiff Bocher William   591949 591949 Bocher, William, of Thorp 0
4472557 2192085 2192085 defendant Assheman John   591949 591949 Assheman, John, of Thorp 0
4474473 2192676 2192676 defendant Dalby Thomas   591949 591949 Dalby, Thomas, of Thorp 0
4478421 2193924 2193924 defendant Cook John   591949 591949 Cook, John, of Thorp 0
4486177 2196378 2196378 defendant Aston William   591949 591949 Aston, William, of Thorp 0
4486179 2196379 2196379 defendant Aston William   591949 591949 Aston, William, of Thorp 0
4487425 2196777 2196777 defendant Cook John   591949 591949 Cook, John, of Thorp 3
4494954 2199108 2199108 defendant Swyllyngton William de   591949 591949 Swyllyngton, William de, of Thorp 0
4504140 2201846 2201846 defendant Baillif Lawrence   591949 591949 Baillif, Lawrence, of Thorp 0
4515329 2205208 2205208 defendant Gull Richard   591949 591949 Gull, Richard, of Thorp 0
4515330 2205208 2205208 defendant Wolfeld Peter   591949 591949 Wolfeld, Peter, of Thorp 1
4516337 2205518 2205518 defendant Symond John   591949 591949 Symond, John, of Thorp 0
4519133 2206336 2206336 defendant Thorp William de, sen   591949 591949 Thorp, William de, sen, of Thorp 0
4519134 2206336 2206336 defendant Alman Henry   591949 591949 Alman, Henry, of Thorp 1
4529686 2209566 2209566 defendant Jordon William   591949 591949 Jordon, William, of Thorp 0
4534748 2211148 2211148 defendant Watte William   591949 591949 Watte, William, of Thorp 2
4537818 2212108 2212108 defendant Colstane William   591949 591949 Colstane, William, of Thorp 3
4545951 2214669 2214669 defendant Hamond John   591949 591949 Hamond, John, of Thorp 2
4548845 2215574 2215574 defendant Eyton William de   591949 591949 Eyton, William de, of Thorp, parson 4
4552801 2216823 2216823 defendant Robynson Thomas   591949 591949 Robynson, Thomas, of Thorp 0
4554497 2217340 2217340 defendant Gersyngton William de smith 591949 591949 Gersyngton, William de, of Thorp, smith 0
4566714 2221163 2221163 defendant Cane or Cave John   591949 591949 Cane or Cave, John, of Thorp 7
4566723 2221164 2221164 defendant Cane or Cave John   591949 591949 Cane or Cave, John, of Thorp 7
4567073 2221258 2221258 plaintiff Symond John   591949 591949 Symond, John, of Thorp 0
4577069 2224338 2224338 defendant Aleyn Richard   591949 591949 Aleyn, Richard, of Thorp 2
4583040 2226120 2226120 defendant Elysson John   591949 591949 Elysson, John, of Thorp 0
4583041 2226120 2226120 defendant Colyer Ellis   591949 591949 Colyer, Ellis, of Thorp 1
4583042 2226120 2226120 defendant Chaterton John de   591949 591949 Chaterton, John de, of Thorp 2
4583044 2226120 2226120 defendant Horneby John   591949 591949 Horneby, John, of Thorp 4
4583045 2226120 2226120 defendant Cartwryght Richard   591949 591949 Cartwryght, Richard, of Thorp 5
4586199 2227107 2227107 defendant Wylcok Walter   591949 591949 Wylcok, Walter, of Thorp 0
4586201 2227108 2227108 defendant Wylcok Walter   591949 591949 Wylcok, Walter, of Thorp 0
4595138 2229732 2229732 defendant Never Walter pipemaker 591949 591949 Never, Walter, of Thorp, pipemaker 0
4600171 2231279 2231279 defendant Blakeman Henry   591949 591949 Blakeman, Henry, of Thorp 0

Next page

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);