names

138 rows where place_id = 587091

✎ 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
3590438 1864653 1864653 defendant Middelton Richard butcher 587091 587091 Middelton, Richard, of Braunston, butcher 1
3591981 1865105 1865105 defendant Mylner William laborer 587091 587091 Mylner, William, of Braunston, laborer 1
3638981 1907015 1907015 defendant Wade Thomas husbandman 587091 587091 Wade, Thomas, of Braunston, husbandman 0
3694199 1924390 1924390 defendant Pope John bucther 587091 587091 Pope, John, of Braunston, bucther 1
3713400 1930506 1930506 defendant Mare Robert husbandman 587091 587091 Mare, Robert, of Braunston, husbandman 2
3728494 1935159 1935159 defendant Whitney William weaver 587091 587091 Whitney, William, of Braunston, weaver 0
3746566 1940840 1940840 defendant Dux Robert husbandman 587091 587091 Dux, Robert, of Braunston, husbandman 0
3773699 1949492 1949492 defendant Longe John laborer 587091 587091 Longe, John, of Braunston, laborer 0
4214179 2100477 2100477 defendant Swaffeyld Augustine gent 587091 587091 Swaffeyld, Augustine, of Braunston, gent 0
4218072 2101818 2101818 defendant Swaffeld Augustine gent 587091 587091 Swaffeld, Augustine, of Braunston, gent 0
4219357 2102267 2102267 defendant Gibson William yeoman 587091 587091 Gibson, William, of Braunston, yeoman 0
4234260 2107518 2107518 defendant Brand Robert gent 587091 587091 Brand, Robert, of Braunston, gent 1
4234764 2107708 2107708 defendant Dyghton Robert gent 587091 587091 Dyghton, Robert, of Braunston, or of Sturton, gent 0
4235845 2108110 2108110 defendant Dighton Robert gent 587091 587091 Dighton, Robert, of Braunston, or of Welton in the Marsh, gent 1
4236267 2108252 2108252 defendant Mowbrey Richard waterman 587091 587091 Mowbrey, Richard, of Braunston, waterman 2
4243361 2110771 2110771 defendant Dyghton Robert gent 587091 587091 Dyghton, Robert, of Braunston, or of Surton, gent 0
4275782 2121479 2121479 defendant Dighton Robert gent 587091 587091 Dighton, Robert, of Braunston, gent 2
4295286 2128399 2128399 defendant Dighton Robert gent 587091 587091 Dighton, Robert, of Braunston, gent 1
4359691 2150627 2150627 defendant Dighton Robert gent 587091 587091 Dighton, Robert, of Braunston, gent 1
4367691 2153497 2153497 defendant Dighton Robert gent 587091 587091 Dighton, Robert, of Braunston, gent 0
4389048 2160967 2160967 defendant Swafeild Augustine gent 587091 587091 Swafeild, Augustine, of Braunston, gent 0
4394369 2162716 2162716 defendant Swafeild Augustine gent 587091 587091 Swafeild, Augustine, of Braunston, gent 0
4453510 2186106 2186106 defendant Taillour William   587091 587091 Taillour, William, of Braunston 0
4476856 2193424 2193424 defendant Godson Anne   587091 587091 Godson, Anne, of Braunston, formerly wife of Robert 0
4476857 2193424 2193424 defendant Godson Henry   587091 587091 Godson, Henry, of Braunston, son of Robert 1
4525934 2208410 2208410 defendant Curly Roger   587091 587091 Curly, Roger, of Braunston 0
4550091 2215968 2215968 defendant Dalby John   587091 587091 Dalby, John, of Braunston 0
4565025 2220632 2220632 plaintiff Shoter Thomas   587091 587091 Shoter, Thomas, of Braunston 0
4574658 2223600 2223600 defendant Hyllyng William   587091 587091 Hyllyng, William, of Braunston 0
4578243 2224694 2224694 defendant Boteler John   587091 587091 Boteler, John, of Braunston 0
4594920 2229666 2229666 defendant Clerk John   587091 587091 Clerk, John, of Braunston 0
4597464 2230451 2230451 defendant Philipot Thomas   587091 587091 Philipot, Thomas, of Braunston 0
4602277 2231927 2231927 defendant Littebury William   587091 587091 Littebury, William, of Braunston 0
4664843 2250482 2250482 defendant William David laborer 587091 587091 William, David, of Braunston, laborer 0
4664845 2250483 2250483 defendant Williams David laborer 587091 587091 Williams, David, of Braunston, laborer 0
4682739 2260219 2260219 plaintiff Nyrtyngale John   587091 587091 Nyrtyngale, John, of Braunston 0
4683422 2260416 2260416 plaintiff Payn Thomas, junior   587091 587091 Payn, Thomas, junior, of Braunston 0
4683423 2260416 2260416 defendant Croke John, junior husbandman 587091 587091 Croke, John, junior, of Braunston, husbandman 0
4692050 2263046 2263046 defendant Payn Thomas yeoman 587091 587091 Payn, Thomas, of Braunston, yeoman 0
4693183 2263370 2263370 defendant Hikelyng Robert husbandman 587091 587091 Hikelyng, Robert, of Braunston, husbandman 0
4696762 2264465 2264465 defendant Turnur John turner 587091 587091 Turnur, John, of Braunston, turner 4
4717028 2270655 2270655 defendant Flekeney Richard husbandman 587091 587091 Flekeney, Richard, of Braunston, husbandman 0
4717029 2270655 2270655 defendant Norland Roger husbandman 587091 587091 Norland, Roger, of Braunston, husbandman 1
4717030 2270655 2270655 defendant Norland John husbandman 587091 587091 Norland, John, of Braunston, husbandman 2
4717031 2270655 2270655 defendant George John husbandman 587091 587091 George, John, of Braunston, husbandman 3
4717227 2270717 2270717 defendant Mercer Roger husbandman 587091 587091 Mercer, Roger, of Braunston, husbandman 0
4728642 2274197 2274197 defendant Couper Roger spicer 587091 587091 Couper, Roger, of Braunston, spicer 0
4752308 2281136 2281136 defendant Kardemaker Nicholas husbandman 587091 587091 Kardemaker, Nicholas, of Braunston, husbandman 0
4757869 2282840 2282840 plaintiff Bond John   587091 587091 Bond, John, of Braunston 1
4757871 2282840 2282840 plaintiff Borell John   587091 587091 Borell, John, of Braunston 3
4769688 2286495 2286495 defendant Couper Agnes   587091 587091 Couper, Agnes, of Braunston, widow, formerly wife of Roger 0
4771967 2287205 2287205 defendant Boteler Robert husbandman 587091 587091 Boteler, Robert, of Braunston, husbandman 0
4772946 2287510 2287510 defendant Chapman John yeoman 587091 587091 Chapman, John, of Braunston, yeoman 0
4777313 2288895 2288895 defendant atte Wode Margery   587091 587091 atte Wode, Margery, of Braunston, widow of atte Wode, Adam 0
4777315 2288896 2288896 defendant atte Wode Margery   587091 587091 atte Wode, Margery, of Braunston, widow of atte Wode, Adam 0
4777317 2288897 2288897 defendant atte Wode Margery   587091 587091 atte Wode, Margery, of Braunston, widow of atte Wode, Adam 0
4793596 2294108 2294108 defendant Bugeden Robert husbandman 587091 587091 Bugeden, Robert, of Braunston, husbandman 0
4814692 2300709 2300709 plaintiff Joye Thomas   587091 587091 Joye, Thomas, of Braunston 0
4823988 2303577 2303577 defendant Exhale John husbandman 587091 587091 Exhale, John, of Braunston, husbandman 0
4823989 2303577 2303577 defendant Gode Auntres John husbandman 587091 587091 Gode Auntres, John, of Braunston, husbandman 1
4836210 2307306 2307306 defendant Westmore John clerk 587091 587091 Westmore, John, of Braunston, clerk 0
4838448 2307941 2307941 plaintiff Godson John husbandman 587091 587091 Godson, John, of Braunston, husbandman 0
4838449 2307941 2307941 plaintiff Smyth Henry smith 587091 587091 Smyth, Henry, of Braunston, smith 1
4838450 2307941 2307941 plaintiff Chambre John husbandman 587091 587091 Chambre, John, of Braunston, husbandman 2
4846643 2310459 2310459 defendant Flaxman John husbandman 587091 587091 Flaxman, John, of Braunston, husbandman 4
4860051 2314514 2314514 defendant Smyth John husbandman 587091 587091 Smyth, John, of Braunston, husbandman 0
4867883 2316926 2316926 defendant Morton John husbandman 587091 587091 Morton, John, of Braunston, husbandman 0
4869063 2317296 2317296 defendant Boteler Robert butcher 587091 587091 Boteler, Robert, of Braunston, butcher 0
4875668 2319345 2319345 defendant Welyngton John husbandman 587091 587091 Welyngton, John, of Braunston, husbandman 0
4886848 2322742 2322742 defendant Botiller Robert butcher 587091 587091 Botiller, Robert, of Braunston, butcher 0
4889968 2323647 2323647 defendant Joly John husbandman 587091 587091 Joly, John, of Braunston, husbandman 2
4889969 2323647 2323647 defendant Tyler Henry husbandman 587091 587091 Tyler, Henry, of Braunston, husbandman 3
4897732 2325958 2325958 defendant Bertelot John husbandman 587091 587091 Bertelot, John, of Braunston, husbandman 1
4902642 2327446 2327446 defendant Persons Richard husbandman 587091 587091 Persons, Richard, of Braunston juxta Leicester, husbandman 0
4903053 2327570 2327570 defendant Smyth John husbandman 587091 587091 Smyth, John, of Braunston, husbandman 0
4905517 2328325 2328325 defendant Margery John husbandman 587091 587091 Margery, John, of Braunston, husbandman 0
4914125 2330929 2330929 defendant atte Symmys William husbandman 587091 587091 atte Symmys, William, of Braunston, husbandman 0
4947688 2341263 2341263 defendant Humberston John husbandman 587091 587091 Humberston, John, of Braunston, husbandman 0
4953127 2342900 2342900 defendant Lord William chaplain 587091 587091 Lord, William, of Braunston, chaplain 0
4953128 2342900 2342900 defendant Spethyn John clerk 587091 587091 Spethyn, John, of Braunston, clerk 1
4953129 2342900 2342900 defendant Osbarn Robert husbandman 587091 587091 Osbarn, Robert, of Braunston, husbandman 2
4953130 2342900 2342900 defendant Mable William husbandman 587091 587091 Mable, William, of Braunston, husbandman 3
4953131 2342900 2342900 defendant Moreby John husbandman 587091 587091 Moreby, John, of Braunston, husbandman 4
4953132 2342900 2342900 defendant Lord Thomas chaplain 587091 587091 Lord, Thomas, of Braunston, chaplain 5
4953827 2343106 2343106 defendant Morton John husbandman 587091 587091 Morton, John, of Braunston, husbandman 0
4963530 2346007 2346007 defendant Harryes John husbandman 587091 587091 Harryes, John, of Braunston, husbandman 0
4964444 2346276 2346276 defendant Cundale John yeoman 587091 587091 Cundale, John, of Braunston, yeoman 0
4981491 2351374 2351374 defendant Mylner Robert husbandman 587091 587091 Mylner, Robert, of Braunston, husbandman 0
4990740 2354138 2354138 defendant Broun William   587091 587091 Broun, William, of Braunston, bailiff 3
4990748 2354139 2354139 defendant Broun William   587091 587091 Broun, William, of Braunston, bailiff 3
4993656 2354976 2354976 defendant Archer Thomas husbandman 587091 587091 Archer, Thomas, of Braunston, husbandman 2
4993657 2354976 2354976 defendant Wodam William husbandman 587091 587091 Wodam, William, of Braunston, husbandman 3
5007126 2358973 2358973 defendant Sofeld William gent 587091 587091 Sofeld, William, of Braunston, gent 0
5007127 2358973 2358973 defendant Burton Thomas husbandman 587091 587091 Burton, Thomas, of Braunston, husbandman 1
5012994 2360634 2360634 defendant Smyth Henry smith 587091 587091 Smyth, Henry, of Braunston, smith 0
5017482 2361999 2361999 defendant Sofeld William gent 587091 587091 Sofeld, William, of Braunston, gent 0
5024362 2364040 2364040 defendant Wode Thomas yeoman 587091 587091 Wode, Thomas, of Braunston, yeoman 2
5024374 2364040 2364040 defendant Wade Joan widow 587091 587091 (Wade, Joan, of Braunston, widow 14
5024375 2364040 2364040 defendant Wade John laborer 587091 587091 Wade, John, of Braunston, laborer 15
5026705 2364680 2364680 defendant Symme William husbandman 587091 587091 Symme, William, of Braunston, husbandman 3

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