names

139 rows where place_id = 609752

✎ 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
3680124 1919852 1919852 defendant Harneys or Herveys William husbandman 609752 609752 Harneys or Herveys, William, of Beeston, husbandman 2
3816410 1963041 1963041 defendant Kynsell Thomas yeoman 609752 609752 Kynsell, Thomas, of Beeston, yeoman 0
3844312 1971771 1971771 defendant Carre John husbandman 609752 609752 Carre, John, of Beeston, husbandman 3
3865677 1978741 1978741 plaintiff Nobys Margaret widow 609752 609752 Nobys, Margaret, of Beeston, widow 0
3876165 1982275 1982275 defendant Nete John glover 609752 609752 Nete, John, of Beeston, glover 2
3877246 1982633 1982633 plaintiff Hoddeson Richard clerk 609752 609752 Hoddeson, Richard, of Beeston, clerk 0
3881833 1984177 1984177 defendant Meere John tooper 609752 609752 Meere, John, of Beeston, tooper 1
3885571 1985427 1985427 defendant Denny Edward clerk 609752 609752 Denny, Edward, of Beeston, clerk 2
3925803 1998947 1998947 defendant Chambers Thomas smith 609752 609752 Chambers, Thomas, of Beeston, smith 0
3981449 2018132 2018132 defendant Deyne Robert yeoman 609752 609752 Deyne, Robert, of Beeston, yeoman 0
3996003 2023325 2023325 defendant Wynsdon Thomas gent 609752 609752 Wynsdon, Thomas, of Beeston, gent 0
3996152 2023378 2023378 defendant Wynsdon Thomas gent 609752 609752 Wynsdon, Thomas, of Beeston, gent 0
3999482 2024579 2024579 defendant Abbes Simon yeoman 609752 609752 Abbes, Simon, of Beeston, yeoman 2
4060445 2046137 2046137 defendant Tompson Henry   609752 609752 Tompson, Henry, of Beeston, "sayer" or sawyer 2
4070944 2049907 2049907 defendant Collyns Andrew tanner 609752 609752 Collyns, Andrew, of Beeston, tanner 0
4070956 2049912 2049912 defendant Collyns Andrew tanner 609752 609752 Collyns, Andrew, of Beeston, tanner 0
4077199 2052131 2052131 defendant Heathe Michael gent 609752 609752 Heathe, Michael, of Beeston, gent 0
4110928 2064159 2064159 defendant Baspole John gent 609752 609752 (Baspole John, of Beeston, gent 1
4133902 2072461 2072461 defendant Spryngold William shipmaster 609752 609752 Spryngold, William, of Beeston, shipmaster 1
4140700 2074913 2074913 defendant Springold William shipmaster 609752 609752 Springold, William, of Beeston, shipmaster 0
4154218 2079571 2079571 defendant Buckshawe John   609752 609752 Buckshawe, John, of Beeston Regis, sailor 0
4154220 2079572 2079572 defendant Buckshewe John   609752 609752 Buckshewe, John, of Beeston Regis, sailor 0
4156178 2080235 2080235 defendant Springold William shipmaster 609752 609752 Springold, William, of Beeston, shipmaster 0
4156179 2080235 2080235 defendant Springold Robert   609752 609752 Springold, Robert, of Beeston, sailor 1
4157834 2080816 2080816 defendant Browne George mariner 609752 609752 Browne, George, of Beeston, mariner 2
4158875 2081173 2081173 defendant Leman Walter yeoman 609752 609752 Leman, Walter, of Beeston, yeoman 0
4169551 2084855 2084855 defendant Waterworthe John yeoman 609752 609752 Waterworthe, John, of Beeston, yeoman 0
4179888 2088442 2088442 defendant Asshell William carpenter 609752 609752 Asshell, William, of Beeston, carpenter 1
4182128 2089226 2089226 defendant Brown George   609752 609752 Brown, George, of Beeston, ship master 3
4188544 2091468 2091468 defendant Pytman Peter   609752 609752 Pytman, Peter, of Beeston, wheelwright 0
4192963 2093104 2093104 defendant Waterworth John yeoman 609752 609752 Waterworth, John, of Beeston, yeoman 0
4196125 2094192 2094192 defendant Threlkeld John clerk 609752 609752 Threlkeld, John, of Beeston, clerk 1
4203311 2096705 2096705 defendant Spryngold William   609752 609752 Spryngold, William, of Beeston, ship master 0
4208983 2098692 2098692 defendant Lawson John clerk 609752 609752 Lawson, John, of Beeston, clerk 3
4214446 2100561 2100561 defendant Gryme William laborer 609752 609752 Gryme, William, of Beeston, laborer 0
4214447 2100561 2100561 defendant Large Erasmus butcher 609752 609752 Large, Erasmus, of Beeston, butcher 1
4217703 2101682 2101682 defendant Beckham Thomas gent 609752 609752 Beckham, Thomas, of Beeston, gent 0
4243926 2110949 2110949 defendant Beckham Thomas gent 609752 609752 Beckham, Thomas, of Beeston, gent 0
4257136 2115364 2115364 defendant Feaser Robert yeoman 609752 609752 Feaser, Robert, of Beeston, yeoman 2
4257137 2115364 2115364 defendant Andrewes Thomas husbandman 609752 609752 Andrewes, Thomas, of Beeston, husbandman 3
4341014 2144132 2144132 defendant Balye Hillary yeoman 609752 609752 Balye, Hillary, of Beeston, yeoman 3
4348958 2146899 2146899 defendant Marshall John husbandman 609752 609752 Marshall, John, of Beeston, husbandman 1
4356608 2149544 2149544 defendant Platten Nicholas husbandman 609752 609752 Platten, Nicholas, of Beeston, husbandman 2
4393615 2162468 2162468 defendant Warren Thomas yeoman 609752 609752 Warren, Thomas, of Beeston, yeoman 1
4395919 2163213 2163213 defendant Drurye Edmund clerk 609752 609752 Drurye, Edmund, of Beeston, clerk 3
4398649 2164128 2164128 defendant Lacy Andrew husbandman 609752 609752 Lacy, Andrew, of Beeston, husbandman 0
4398650 2164128 2164128 defendant Boothe John yeoman 609752 609752 Boothe, John, of Beeston, yeoman 1
4398651 2164128 2164128 defendant Tofte John husbandman 609752 609752 Tofte, John, of Beeston, husbandman 2
4399133 2164294 2164294 defendant Waterworth John yeoman 609752 609752 Waterworth, John, of Beeston, yeoman 0
4400182 2164652 2164652 defendant Waterworth John husbandman 609752 609752 Waterworth, John, of Beeston, husbandman 0
4410278 2168035 2168035 defendant White William husbandman 609752 609752 White, William, of Beeston, husbandman 3
4499789 2200566 2200566 plaintiff Hert Emma   609752 609752 Hert, Emma, of Beeston 0
4499790 2200566 2200566 defendant Taillour John   609752 609752 Taillour, John, of Beeston 0
4602278 2231928 2231928 plaintiff Wayte William   609752 609752 Wayte, William, of Beeston 0
4604363 2232535 2232535 defendant Saundre John   609752 609752 Saundre, John, of Beeston 1
4635104 2241824 2241824 defendant Mawfras John skinner 609752 609752 Mawfras, John, of Beeston, skinner 0
4635105 2241824 2241824 defendant Saundre John   609752 609752 Saundre, John, of Beeston 1
4635738 2242021 2242021 defendant Buk John   609752 609752 Buk, John, of Beeston 1
4645630 2244788 2244788 defendant Caudeler John   609752 609752 Caudeler, John, of Beeston 16
4661031 2249275 2249275 defendant Lalle Edmund husbandman 609752 609752 Lalle, Edmund, of Beeston, husbandman 0
4661033 2249275 2249275 defendant Bruntyng John husbandman 609752 609752 Bruntyng, John, of Beeston, husbandman 2
4767256 2285746 2285746 defendant Bate Ralph husbandman 609752 609752 Bate, Ralph, of Beeston, husbandman 0
4771801 2287157 2287157 defendant Clerk Henry husbandman 609752 609752 Clerk, Henry, of Beeston, husbandman 0
4772336 2287313 2287313 defendant Carter John, sen husbandman 609752 609752 Carter, John, sen, of Beeston, husbandman 0
4791682 2293497 2293497 defendant Bate Ralph husbandman 609752 609752 Bate, Ralph, of Beeston, husbandman 0
4797492 2295387 2295387 defendant Cartere John, senior husbandman 609752 609752 Cartere, John, senior, of Beeston, husbandman 0
4798693 2295769 2295769 plaintiff Symond John   609752 609752 Symond, John, of Beeston 0
4805335 2297874 2297874 plaintiff Broun Richard   609752 609752 Broun, Richard, of Beeston, on his own account 0
4821847 2302907 2302907 defendant Sudbery John   609752 609752 Sudbery, John, of Beeston, son of Robert Sudbery, somour 1
4881519 2321123 2321123 defendant Aleyn Edmund (legal representative) 609752 609752 Aleyn, Edmund, of Beeston, executors of 0
4889868 2323620 2323620 defendant de Bampton Gervase gent 609752 609752 de Bampton, Gervase, of Beeston, gent 0
4920508 2332928 2332928 defendant Lyon Henry husbandman 609752 609752 Lyon, Henry, of Beeston, husbandman 3
4966272 2346845 2346845 defendant Sudbury John smith 609752 609752 Sudbury, John, of Beeston, smith 0
5095961 2385248 2385248 defendant Thornkyn Edmund yeoman 609752 609752 Thornkyn, Edmund, of Beeston, yeoman 2
5124660 2393686 2393686 defendant Nordon William gent 609752 609752 Nordon, William, of Beeston, gent 0
5149531 2400992 2400992 defendant Adam Robert husbandman 609752 609752 Adam, Robert, of Beeston, husbandman 1
5157385 2403295 2403295 plaintiff Norwyche Robert gent 609752 609752 Norwyche, Robert, of Beeston, gent 1
5206164 2417533 2417533 defendant Adam Robert husbandman 609752 609752 Adam, Robert, of Beeston, husbandman 1
5269891 2436302 2436302 defendant Turnlay John smith man 609752 609752 Turnlay, John, of Beeston, smith man 0
5296000 2443819 2443819 defendant Cokefeld John clerk 609752 609752 Cokefeld, John, of Beeston, clerk 0
5318755 2450700 2450700 defendant Page Thomas yeoman 609752 609752 Page, Thomas, of Beeston, yeoman 0
5341351 2457485 2457485 defendant Page Thomas husbandman 609752 609752 Page, Thomas, of Beeston, husbandman 0
5350625 2460308 2460308 defendant Turnlay John smith man 609752 609752 Turnlay, John, of Beeston, smith man 0
5350627 2460309 2460309 defendant Turnlay John smithman 609752 609752 Turnlay, John, of Beeston, smithman 0
5351968 2460719 2460719 defendant Garbot William husbandman 609752 609752 Garbot, William, of Beeston, husbandman 2
5434272 2485185 2485185 defendant Compelyn Thomas husbandman 609752 609752 Compelyn, Thomas, of Beeston, husbandman 1
5434273 2485185 2485185 defendant Maddy William husbandman 609752 609752 Maddy, William, of Beeston, husbandman 2
5434274 2485185 2485185 defendant Maddy Robert husbandman 609752 609752 Maddy, Robert, of Beeston, husbandman 3
5473359 2496993 2496993 defendant Maddy Robert husbandman 609752 609752 Maddy, Robert, of Beeston, husbandman 3
5490350 2502006 2502006 defendant Compelyn Thomas husbandman 609752 609752 Compelyn, Thomas, of Beeston, husbandman 0
5492839 2502772 2502772 defendant Denton William weaver 609752 609752 Denton, William, of Beeston, weaver 11
5492840 2502772 2502772 defendant Hynderson John weaver 609752 609752 Hynderson, John, of Beeston, weaver 12
5492841 2502772 2502772 defendant Felde Robert laborer 609752 609752 Felde, Robert, of Beeston, laborer 13
5492842 2502772 2502772 defendant Hall Robert laborer 609752 609752 Hall, Robert, of Beeston, laborer 14
5492843 2502772 2502772 defendant Casson William   609752 609752 Casson, William, of Beeston, wheelwright 15
5492844 2502772 2502772 defendant bryan Robert tailor 609752 609752 bryan, Robert, of Beeston, tailor 16
5492845 2502772 2502772 defendant Casson Robert tailor 609752 609752 Casson, Robert, of Beeston, tailor 17
5492846 2502772 2502772 defendant Casson Richard tailor 609752 609752 Casson, Richard, of Beeston, tailor 18
5492847 2502772 2502772 defendant Ball Lawrence miller 609752 609752 Ball, Lawrence, of Beeston, miller 19
5492848 2502772 2502772 defendant Casson Richard collier 609752 609752 Casson, Richard, of Beeston, collier 20

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