names

73 rows where place_id = 586055

✎ 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
3587818 1863835 1863835 defendant Obynson or Ovynson William yeoman 586055 586055 Obynson or Ovynson, William, of Westerkele, yeoman 0
3609160 1870523 1870523 defendant Fenne Robert yeoman 586055 586055 Fenne, Robert, of Westerkele, yeoman 3
3612468 1871531 1871531 defendant Haldon John husbandman 586055 586055 Haldon, John, of Westerkele, husbandman 0
3624768 1875282 1875282 defendant Fen Robert yeoman 586055 586055 Fen, Robert, of Westerkele, yeoman 0
3624769 1875282 1875282 defendant Bennet Thomas husbandman 586055 586055 Bennet, Thomas, of Westerkele, husbandman 1
3624770 1875282 1875282 defendant Glegge Robert yeoman 586055 586055 Glegge, Robert, of Westerkele, yeoman 2
3626347 1903098 1903098 defendant Schawe Gilbert yeoman 586055 586055 Schawe, Gilbert, of Westerkele, yeoman 1
3691836 1923606 1923606 defendant Broddyng John husbandman 586055 586055 Broddyng, John, of Westerkele, husbandman 0
3753256 1942958 1942958 defendant Grene Thomas husbandman 586055 586055 Grene, Thomas, of Westerkele, husbandman 1
3837134 1969515 1969515 defendant Haggas William husbandman 586055 586055 Haggas, William, of Westerkele, husbandman 0
3881568 1984097 1984097 defendant Lyncoln Thomas husbandman 586055 586055 Lyncoln, Thomas, of Westerkele, husbandman 0
3954459 2008629 2008629 defendant Todde Richard butcher 586055 586055 Todde, Richard, of Westerkele, butcher 0
3954460 2008629 2008629 defendant Bell William butcher 586055 586055 Bell, William, of Westerkele, butcher 1
3956691 2009408 2009408 plaintiff Ordyng William (legal representative) 586055 586055 Ordyng, William, of Westerkele, yeoman, executors of 0
3956695 2009408 2009408 defendant Est or East John husbandman 586055 586055 Est or East, John, of Westerkele, husbandman 0
3956726 2009421 2009421 defendant Lyme Thomas yeoman 586055 586055 Lyme, Thomas, of Westerkele, yeoman 0
3957267 2009605 2009605 defendant Todde John butcher 586055 586055 Todde, John, of Westerkele, butcher 0
3960205 2010669 2010669 defendant Lyme Thomas yeoman 586055 586055 Lyme, Thomas, of Westerkele, yeoman 0
3987525 2020289 2020289 defendant Lime or Lune Thomas yeoman 586055 586055 Lime or Lune, Thomas, of Westerkele, yeoman 0
3987527 2020290 2020290 defendant Massy Peter husbandman 586055 586055 Massy, Peter, of Westerkele, husbandman 0
3990243 2021265 2021265 defendant Grene Roger husbandman 586055 586055 Grene, Roger, of Westerkele, husbandman 1
3993560 2022441 2022441 defendant Eldred Robert gent 586055 586055 Eldred, Robert, of Westerkele, gent 0
4064579 2047613 2047613 defendant Keylbek or Kelbeck Christopher gent 586055 586055 Keylbek or Kelbeck, Christopher, of Westerkele, gent 1
4064720 2047671 2047671 defendant Grave John yeoman 586055 586055 Grave, John, of Westerkele, yeoman 1
4085689 2055152 2055152 defendant Rychardson John husbandman 586055 586055 Rychardson, John, of Westerkele, husbandman 0
4085690 2055152 2055152 defendant Rychardson Gilbert husbandman 586055 586055 Rychardson, Gilbert, of Westerkele, husbandman 1
4096381 2059037 2059037 defendant Kilbeck Christopher gent 586055 586055 Kilbeck, Christopher, of Westerkele, gent 0
4101784 2060947 2060947 defendant Kirkeman Avea widow 586055 586055 Kirkeman, Avea, of Westerkele, widow 0
4145271 2076504 2076504 defendant Acklam Anthony gent 586055 586055 Acklam, Anthony, of Westerkele, gent 0
4152592 2079020 2079020 defendant Boole Peter yeoman 586055 586055 Boole, Peter, of Westerkele, yeoman 0
4506818 2202601 2202601 plaintiff Turnour John   586055 586055 Turnour, John, of Westerkele 0
4530581 2209861 2209861 defendant Freman John   586055 586055 Freman, John, of Westerkele 0
4537593 2212031 2212031 plaintiff Taillour John   586055 586055 Taillour, John, of Westerkele 0
4537594 2212031 2212031 defendant Child John   586055 586055 Child, John, of Westerkele 0
4540831 2213037 2213037 defendant Philipson Robert   586055 586055 Philipson, Robert, of Westerkele 2
4549980 2215927 2215927 defendant Doo Andrew   586055 586055 Doo, Andrew, of Westerkele 0
4549986 2215930 2215930 defendant Daweby Nicholas   586055 586055 Daweby, Nicholas, of Westerkele 0
4555939 2217795 2217795 defendant Bacon John   586055 586055 Bacon, John, of Westerkele 0
4560523 2219230 2219230 plaintiff Nickere William   586055 586055 Nickere, William, of Westerkele 0
4579782 2225163 2225163 defendant Danby Nicholas   586055 586055 Danby, Nicholas, of Westerkele 0
4651251 2246398 2246398 defendant Brone John husbandman 586055 586055 Brone, John, of Westerkele, husbandman 1
4657593 2248264 2248264 plaintiff Coke John   586055 586055 Coke, John, of Westerkele 0
4735177 2276149 2276149 plaintiff Smyth William chaplain 586055 586055 Smyth, William, of Westerkele, chaplain 0
4735178 2276149 2276149 plaintiff Lamson William   586055 586055 Lamson, William, of Westerkele 1
4815108 2300835 2300835 defendant Daweson John husbandman 586055 586055 Daweson, John, of WesterKele, husbandman 2
4816392 2301220 2301220 defendant Werke John goldsmith 586055 586055 Werke, John, of Westerkele, goldsmith 0
4817823 2301657 2301657 defendant Couper John cooper 586055 586055 Couper, John, of Westerkele, cooper 0
4839300 2308218 2308218 defendant Walker John   586055 586055 Walker, John, of Westerkele, shepherd 0
4858407 2314003 2314003 defendant Garnon William falconer 586055 586055 Garnon, William, of Westerkele, falconer 0
4858519 2314039 2314039 defendant Matte Simon husbandman 586055 586055 Matte, Simon, of Westerkele, husbandman 1
4863811 2315654 2315654 defendant Broune Robert clerk 586055 586055 Broune, Robert, of Westerkele, clerk 0
4882781 2321536 2321536 defendant Clerk John husbandman 586055 586055 Clerk, John, of Westerkele, husbandman 0
4891687 2324142 2324142 defendant Sutton Robert glover 586055 586055 Sutton, Robert, of Westerkele, glover 0
4899069 2326351 2326351 defendant Clerk John husbandman 586055 586055 Clerk, John, of Westerkele, husbandman 0
4941472 2339352 2339352 plaintiff Erthe John clerk 586055 586055 Erthe, John, of Westerkele, clerk 0
4976038 2349797 2349797 defendant Werk John husbandman 586055 586055 Werk, John, of Westerkele, husbandman 12
4982784 2351764 2351764 defendant Warke John husbandman 586055 586055 Warke, John, of Westerkele, husbandman 0
4998847 2356539 2356539 defendant Warke John goldsmith 586055 586055 Warke, John, of Westerkele, goldsmith 1
4999262 2356651 2356651 defendant Whitemouth John butcher 586055 586055 Whitemouth, John, of Westerkele, butcher 1
5037986 2367994 2367994 defendant Haghwes John husbandman 586055 586055 Haghwes, John, of Westerkele, husbandman 0
5179267 2409675 2409675 defendant Chapman John husbandman 586055 586055 Chapman, John, of Westerkele, husbandman 1
5180408 2410011 2410011 defendant Chapman John husbandman 586055 586055 Chapman, John, of Westerkele, husbandman 1
5192126 2413426 2413426 defendant Betonson Browne John husbandman 586055 586055 Betonson Browne, John, of Westerkele, husbandman 0
5252148 2430784 2430784 defendant Nicholasson Robert husbandman 586055 586055 together with Nicholasson, Robert, of Westerkele, husbandman 1
5264835 2434762 2434762 defendant Jakson William laborer 586055 586055 Jakson, William, of Westerkele, laborer 2
5364767 2464645 2464645 defendant Ryther Robert clerk 586055 586055 Ryther, Robert, of Westerkele, clerk 0
5393255 2473123 2473123 defendant Humfrey John tailor 586055 586055 Humfrey, John, of Westerkele, tailor 0
5406393 2476901 2476901 defendant Humfrey John tailor 586055 586055 Humfrey, John, of Westerkele, tailor 0
5431363 2484334 2484334 defendant Roper William thatcher 586055 586055 Roper, William, of Westerkele, thatcher 0
5448218 2489360 2489360 defendant Roper William   586055 586055 Roper, William, of Westerkele 0
5460579 2493107 2493107 defendant Roper William thatcher 586055 586055 Roper, William, of Westerkele, thatcher 0
5547517 2519290 2519290 defendant Fenne Robert yeoman 586055 586055 Fenne, Robert, of Westerkele, yeoman 0
5606820 2537020 2537020 defendant Burwell Robert husbandman 586055 586055 Burwell, Robert, of Westerkele, husbandman 2

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