names

122 rows where place_id = 612532

✎ 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
3688289 1922483 1922483 defendant Smyth Richard (legal representative) 612532 612532 Smyth, Richard, of Beston, butcher, executors of 0
3693766 1924246 1924246 defendant Large Thomas butcher 612532 612532 Large, Thomas, of Beston, butcher 1
3700744 1926485 1926485 defendant Collett Thomas husbandman 612532 612532 Collett, Thomas, of Beston, husbandman 0
3719172 1932281 1932281 defendant Pape John draper 612532 612532 Pape, John, of Beston, draper 1
3771051 1948633 1948633 defendant Yelverton Nicholas gent 612532 612532 Yelverton, Nicholas, of Beston, gent 1
3788337 1954152 1954152 defendant Harnes William husbandman 612532 612532 Harnes, William,of Beston, husbandman 0
3798489 1957429 1957429 defendant Bampton John yeoman 612532 612532 Bampton, John, of Beston, yeoman 0
3837373 1969600 1969600 defendant Mere John roper 612532 612532 Mere, John, of Beston, roper 1
3842116 1971085 1971085 defendant Beston Ralph gent 612532 612532 Beston, Ralph, of Beston, gent 0
3842117 1971085 1971085 defendant Bowland Brian husbandman 612532 612532 Bowland, Brian, of Beston, husbandman 1
3842118 1971085 1971085 defendant Braton John chaplain 612532 612532 Braton, John, of Beston, chaplain 2
3842119 1971085 1971085 defendant Coke Ralph husbandman 612532 612532 Coke, Ralph, of Beston, husbandman 3
3842120 1971085 1971085 defendant Coke Robert husbandman 612532 612532 Coke, Robert, of Beston, husbandman 4
3876164 1982275 1982275 defendant Dewe Richard glover 612532 612532 Dewe, Richard, of Beston, glover 1
3879032 1983239 1983239 defendant Denny Edmund clerk 612532 612532 Denny, Edmund, of Beston, clerk 0
3893757 1988131 1988131 plaintiff Potter John   612532 612532 Potter, John, of Beston 0
3957314 2009620 2009620 defendant Crowe Thomas yeoman 612532 612532 Crowe, Thomas, of Beston, yeoman 1
3971583 2014621 2014621 plaintiff Evererd Henry gent 612532 612532 Evererd, Henry, of Beston, gent 0
3994047 2022620 2022620 plaintiff Clarke William   612532 612532 Clarke, William, of Beston 0
4003501 2026014 2026014 plaintiff Howard Thomas mariner 612532 612532 Howard, Thomas, of Beston, mariner 0
4013655 2029620 2029620 defendant Nune James gent 612532 612532 Nune, James, of Beston, gent 0
4058387 2045385 2045385 defendant Johnson Thomas carpenter 612532 612532 Johnson, Thomas, of Beston, carpenter 0
4076829 2051999 2051999 defendant Mott William   612532 612532 Mott, William, of Beston Regis, sailor 2
4093216 2057890 2057890 defendant Brown George mariner 612532 612532 Brown, George, of Beston, mariner 1
4110923 2064158 2064158 defendant Baspole John gent 612532 612532 (Baspole, John, of Beston, gent 1
4116532 2066201 2066201 defendant Garfurthe Edward yeoman 612532 612532 Garfurthe, Edward, of Beston, yeoman 1
4116577 2066217 2066217 defendant Johnson Walter   612532 612532 Johnson, Walter, of Beston, sailor 0
4119268 2067185 2067185 defendant Ashill William carpenter 612532 612532 Ashill, William, of Beston, carpenter 1
4119269 2067185 2067185 defendant Allen Roger, senior husbandman 612532 612532 Allen, Roger, senior, of Beston, husbandman 2
4119272 2067186 2067186 defendant Ashill William carpenter 612532 612532 Ashill, William, of Beston, carpenter 1
4119273 2067186 2067186 defendant Allen Roger, senior husbandman 612532 612532 Allen, Roger, senior, of Beston, husbandman 2
4128359 2070430 2070430 defendant Randen William yeoman 612532 612532 Randen, William, of Beston, yeoman 0
4129129 2070723 2070723 defendant Leman Walter grocer 612532 612532 Leman, Walter, of Beston, grocer 0
4129130 2070723 2070723 defendant Ashill William carpenter 612532 612532 Ashill, William, of Beston, carpenter 1
4133673 2072377 2072377 defendant Petman Peter   612532 612532 Petman, Peter, of Beston, wheelwright 1
4179823 2088419 2088419 defendant Spryngold William shipmaster 612532 612532 Spryngold, William, of Beston, shipmaster 0
4226013 2104568 2104568 defendant Harryson Nicholas yeoman 612532 612532 Harryson, Nicholas, of Beston, yeoman 0
4226016 2104568 2104568 defendant Harryson Nicholas, senior yeoman 612532 612532 Harryson, Nicholas, senior, of Beston, yeoman 3
4262640 2117174 2117174 defendant Allen Roger husbandman 612532 612532 Allen, Roger, of Beston, husbandman 1
4291622 2127081 2127081 defendant Newman Henry yeoman 612532 612532 Newman, Henry, of Beston, yeoman 2
4291623 2127081 2127081 defendant Denney George yeoman 612532 612532 Denney, George, of Beston, yeoman 3
4316671 2135948 2135948 defendant Bridgley Edward yeoman 612532 612532 Bridgley, Edward, of Beston, yeoman 2
4316672 2135948 2135948 defendant Styfflyn Edward yeoman 612532 612532 Styfflyn, Edward, of Beston, yeoman 3
4326480 2139218 2139218 defendant Crowe Adam yeoman 612532 612532 Crowe, Adam, of Beston, yeoman 1
4343885 2145141 2145141 defendant Todde Robert yeoman 612532 612532 Todde, Robert, of Beston, yeoman 0
4348327 2146668 2146668 defendant Denney George butcher 612532 612532 Denney, George, of Beston, butcher 0
4351860 2147892 2147892 defendant Waterworth John yeoman 612532 612532 Waterworth, John, of Beston, yeoman 0
4418854 2170763 2170763 plaintiff Andreu Celia   612532 612532 Andreu, Celia, of Beston 0
4418855 2170763 2170763 defendant Abbis James   612532 612532 Abbis, James, of Beston 0
4418967 2170795 2170795 defendant Fayrman William   612532 612532 Fayrman, William, of Beston 1
4423244 2172126 2172126 defendant Baillot Henry   612532 612532 Baillot, Henry, of Beston 0
4430164 2174210 2174210 plaintiff Wrighte Benedict le   612532 612532 Wrighte, Benedict le, of Beston 0
4431518 2174626 2174626 defendant atte Grene John chaplain 612532 612532 atte Grene, John, of Beston, chaplain 0
4436050 2176009 2176009 defendant Mellere John le   612532 612532 Mellere, John le, of Beston 1
4438961 2181477 2181477 defendant Buk Bartholomew   612532 612532 Buk, Bartholomew, of Beston 0
4439406 2181592 2181592 defendant Cone or Cove Henry de   612532 612532 Cone or Cove, Henry de, of Beston 0
4459096 2187889 2187889 plaintiff Ronton Roger   612532 612532 Ronton, Roger, of Beston, parson, on his own account 0
4459271 2187946 2187946 plaintiff Routon Roger de   612532 612532 Routon, Roger de, of Beston, parson, on his own account 0
4464585 2189593 2189593 defendant Fayrman Henry (legal representative) 612532 612532 Fayrman, Henry, of Beston, executrix of 1
4495038 2199140 2199140 plaintiff Buk Richard   612532 612532 Buk, Richard, of Beston 0
4511728 2204116 2204116 defendant Baxtere Ralph   612532 612532 Baxtere, Ralph, of Beston 2
4516643 2205618 2205618 defendant Buk Richard   612532 612532 Buk, Richard, of Beston 0
4516644 2205618 2205618 defendant Buk John   612532 612532 Buk, John, of Beston, son of Richard 1
4546026 2214699 2214699 defendant Wilymond Robert   612532 612532 Wilymond, Robert, of Beston 0
4571961 2222806 2222806 defendant Harwod Thomas   612532 612532 Harwod, Thomas, of Beston 0
4577674 2224522 2224522 defendant Malteby Richard   612532 612532 Malteby, Richard, of Beston 0
4604362 2232535 2232535 defendant Mawefras John skinner 612532 612532 Mawefras, John, of Beston, skinner 0
4608609 2233798 2233798 defendant Bucke John   612532 612532 Bucke, John, of Beston 0
4613076 2235148 2235148 defendant Buke John   612532 612532 Buke, John, of Beston 0
4645411 2244726 2244726 defendant Smyth Henry   612532 612532 Smyth, Henry, of Beston 4
4661042 2249277 2249277 defendant Bukke John yeoman 612532 612532 Bukke, John, of Beston, yeoman 5
4668535 2255867 2255867 defendant Maddy Robert husbandman 612532 612532 Maddy, Robert, of Beston, husbandman 0
4682636 2260186 2260186 defendant Poyt Henry clerk 612532 612532 Poyt, Henry, of Beston, clerk 0
4707207 2267634 2267634 defendant Waleys Henry   612532 612532 Waleys, Henry, of Beston, wright 1
4707669 2267762 2267762 defendant Bateman Richard husbandman 612532 612532 Bateman, Richard, of Beston, husbandman 1
4708505 2268027 2268027 defendant Poyt Henry clerk 612532 612532 Poyt, Henry, of Beston, clerk 0
4724682 2273017 2273017 plaintiff Willyngham Robert   612532 612532 Willyngham, Robert, of Beston 3
4749274 2280269 2280269 plaintiff Norwych Robert   612532 612532 Norwych, Robert, of Beston, on his own account 0
4750744 2280700 2280700 defendant bucke John husbandman 612532 612532 bucke, John, of Beston, husbandman 1
4754863 2281899 2281899 defendant Buk John husbandman 612532 612532 Buk, John, of Beston, husbandman 3
4761854 2284051 2284051 defendant Norwych Robert Norf, gent 612532 612532 Norwych Robert, of Beston, Norf, gent 0
4764000 2284728 2284728 defendant Bukk John yeoman 612532 612532 Bukk, John, of Beston, yeoman 7
4776082 2288516 2288516 defendant Thornekyn John   612532 612532 Thornekyn, John, of Beston 0
4802386 2296939 2296939 defendant Buk John yeoman 612532 612532 Buk, John, of Beston, yeoman 2
4828590 2304983 2304983 plaintiff Man Adam shipman 612532 612532 Man, Adam, of Beston, shipman 1
4870151 2317633 2317633 defendant Brounsale John husbandman 612532 612532 Brounsale, John, of Beston, husbandman 0
4871242 2317980 2317980 defendant Bampton Gervase gent 612532 612532 Bampton, Gervase, of Beston, gent 0
4888438 2323183 2323183 defendant Bukke John yeoman 612532 612532 Bukke, John, of Beston, yeoman 0
4924507 2334105 2334105 plaintiff Norwich Robert, senior   612532 612532 Norwich, Robert, senior, of Beston 0
4939446 2338719 2338719 plaintiff Corpsty Thomas   612532 612532 Corpsty, Thomas, of Beston 0
4939447 2338719 2338719 plaintiff Page Robert   612532 612532 Page, Robert, of Beston 1
5042956 2369509 2369509 defendant Eland Robert esq 612532 612532 Eland, Robert, of Beston, esq 1
5057799 2373901 2373901 defendant Page Robert yeoman 612532 612532 Page, Robert, of Beston, yeoman 0
5068602 2377101 2377101 plaintiff Norwich Robert   612532 612532 Norwich, Robert, of Beston 1
5083609 2381602 2381602 defendant Godlefe John husbandman 612532 612532 Godlefe, John, of Beston, husbandman 0
5096950 2385539 2385539 defendant Wygat Richard merchant 612532 612532 Wygat, Richard, of Beston, merchant 0
5105413 2388025 2388025 plaintiff Coche Roger   612532 612532 Coche, Roger, of Beston 0
5111209 2389666 2389666 defendant Arnold John husbandman 612532 612532 Arnold, John, of Beston, husbandman 1
5131518 2395700 2395700 defendant Hochonson Thomas mercer 612532 612532 Hochonson, Thomas, of Beston, mercer 0
5132363 2395962 2395962 defendant Harple John yeoman 612532 612532 Harple, John, of Beston, yeoman 1

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