names

104 rows where place_id = 605070

✎ 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
3660273 1913474 1913474 plaintiff Helys Thomas tailor 605070 605070 Helys, Thomas, of Shipdham, tailor 0
3660274 1913474 1913474 defendant Newton James turner 605070 605070 Newton, James, of Shipdham, turner 0
3660275 1913474 1913474 defendant Burne William smith 605070 605070 Burne, William, of Shipdham, smith 1
3660276 1913475 1913475 plaintiff Helys Thomas tailor 605070 605070 Helys, Thomas, of Shipdham, tailor 0
3711992 1930068 1930068 defendant Pynnes John yeoman 605070 605070 Pynnes, John, of Shipdham, yeoman 2
3711997 1930069 1930069 defendant Pynnes John yeoman 605070 605070 Pynnes, John, of Shipdham, yeoman 3
3732103 1936274 1936274 defendant Platfote Walter (legal representative) 605070 605070 Platfote, Walter, of Shipdham, husbandman, administrator of 0
3967914 2013405 2013405 defendant Busgate Thomas yeoman 605070 605070 Busgate, Thomas, of Shipdham, yeoman 2
3971483 2014585 2014585 defendant Chafye William gent 605070 605070 Chafye, William, of Shipdham, gent 0
3973017 2015134 2015134 defendant Chancy William gent 605070 605070 Chancy, William, of Shipdham, gent 0
3976501 2016357 2016357 defendant Tuddenham Thomas butcher 605070 605070 Tuddenham, Thomas, of Shipdham, butcher 1
3977721 2016777 2016777 defendant Wardoper Simon tailor 605070 605070 Wardoper, Simon, of Shipdham, tailor 0
3980704 2017860 2017860 defendant Tuddenham John butcher 605070 605070 Tuddenham, John, of Shipdham, butcher 0
3984161 2019100 2019100 defendant Leveryngton William jusbandman 605070 605070 Leveryngton, William, of Shipdham, jusbandman 3
4018987 2031526 2031526 defendant Egmer John laborer 605070 605070 Egmer, John, of Shipdham, laborer 3
4025981 2033942 2033942 defendant Mordewe Simon butcher 605070 605070 Mordewe, Simon, of Shipdham, butcher 0
4025984 2033942 2033942 defendant Smyth John laborer 605070 605070 Smyth, John, of Shipdham, laborer 3
4045634 2040892 2040892 plaintiff Scalye or Stalye Richard (legal representative) 605070 605070 Scalye or Stalye, Richard, of Shipdham, executrix of 0
4057244 2044979 2044979 plaintiff Bullock Walter yeoman 605070 605070 Bullock, Walter, of Shipdham, yeoman 1
4057248 2044980 2044980 plaintiff Bullocke Simon yeoman 605070 605070 Bullocke, Simon, of Shipdham, yeoman 0
4057249 2044980 2044980 plaintiff Bullock Walter yeoman 605070 605070 Bullock, Walter, of Shipdham, yeoman 1
4057965 2045228 2045228 defendant Vynes David carpenter 605070 605070 Vynes, David, of Shipdham, carpenter 0
4060417 2046126 2046126 defendant Bullock Michael husbandman 605070 605070 Bullock, Michael, of Shipdham, husbandman 0
4060536 2046169 2046169 defendant Walsyngham Thomas   605070 605070 Walsyngham, Thomas, of Shipdham, hoop maker 1
4061017 2046348 2046348 defendant Hydeman John miller 605070 605070 Hydeman, John, of Shipdham, miller 2
4061018 2046348 2046348 defendant Gardener John butcher 605070 605070 Gardener, John, of Shipdham, butcher 3
4072561 2050492 2050492 defendant Wilkins Andrew husbandman 605070 605070 Wilkins, Andrew, of Shipdham, husbandman 0
4075930 2051694 2051694 defendant Raynold Richard husbandman 605070 605070 Raynold, Richard, of Shipdham, husbandman 0
4085672 2055148 2055148 defendant Crytoft Robert gent 605070 605070 Crytoft, Robert, of Shipdham, gent 0
4085673 2055148 2055148 defendant Hanchett Bridget   605070 605070 Hanchett, Bridget, of Shipdham widow 1
4085674 2055148 2055148 defendant Ranewe Elizabeth widow 605070 605070 Ranewe, Elizabeth, of Shipdham, widow 2
4085675 2055148 2055148 defendant Ranewe Francis yeoman 605070 605070 Ranewe, Francis, of Shipdham, yeoman 3
4085676 2055148 2055148 defendant More Richard sawyer 605070 605070 More, Richard, of Shipdham, sawyer 4
4090365 2056838 2056838 defendant Stapleton Thomas sawyer 605070 605070 Stapleton, Thomas, of Shipdham, sawyer 0
4093981 2058174 2058174 defendant Mordell William husbandman 605070 605070 Mordell, William, of Shipdham, husbandman 0
4117729 2066634 2066634 defendant Knight Thomas tailor 605070 605070 Knight, Thomas, of Shipdham, tailor 2
4145658 2076633 2076633 defendant Tompson Simon miller 605070 605070 Tompson, Simon, of Shipdham, miller 2
4163688 2082821 2082821 defendant Smythe Thomas miller 605070 605070 Smythe, Thomas, of Shipdham, miller 0
4192446 2092915 2092915 defendant Blacke George husbandman 605070 605070 Blacke, George, of Shipdham, husbandman 2
4219089 2102173 2102173 defendant Busshe Richard butcher 605070 605070 Busshe, Richard, of Shipdham, butcher 1
4219622 2102368 2102368 defendant Bushe Richard butcher 605070 605070 Bushe, Richard, of Shipdham, butcher 1
4245117 2111353 2111353 defendant Bushe Richard butcher 605070 605070 Bushe, Richard, of Shipdham, butcher 1
4251756 2113578 2113578 defendant Muriel Stephen yeoman 605070 605070 Muriel, Stephen, of Shipdham, yeoman 1
4263458 2117441 2117441 defendant Lumbard Stephen husbandman 605070 605070 Lumbard, Stephen, of Shipdham, husbandman 3
4282785 2123883 2123883 defendant Platefoote Ralph yeoman 605070 605070 Platefoote, Ralph, of Shipdham, yeoman 0
4284419 2124478 2124478 defendant Ball Robert husbandman 605070 605070 Ball, Robert, of Shipdham, husbandman 0
4284420 2124478 2124478 defendant Wickham Thomas   605070 605070 Wickham, Thomas, of Shipdham husbandman 1
4284421 2124478 2124478 defendant Peters George yeoman 605070 605070 Peters, George, of Shipdham, yeoman 2
4284833 2124620 2124620 defendant Upcrofte John tanner 605070 605070 Upcrofte, John, of Shipdham, tanner 2
4290950 2126825 2126825 defendant Gooche Robert husbandman 605070 605070 Gooche, Robert, of Shipdham, husbandman 2
4309928 2133630 2133630 defendant Lumbert Stephen yeoman 605070 605070 Lumbert, Stephen, of Shipdham, yeoman 0
4325199 2138807 2138807 defendant Brackett Henry yeoman 605070 605070 Brackett, Henry, of Shipdham, yeoman 1
4325200 2138807 2138807 defendant Platfoote Ralph yeoman 605070 605070 Platfoote, Ralph, of Shipdham, yeoman 2
4325201 2138807 2138807 defendant Lumbard Stephen yeoman 605070 605070 Lumbard, Stephen, of Shipdham, yeoman 3
4325203 2138808 2138808 defendant Platfoote Ralph yeoman 605070 605070 Platfoote, Ralph, of Shipdham, yeoman 0
4325204 2138808 2138808 defendant Lumbard Stephen yeoman 605070 605070 Lumbard, Stephen, of Shipdham, yeoman 1
4325205 2138808 2138808 defendant Blade William   605070 605070 Blade, William, of Shipdham, husbandman, plough wheel maker 2
4327895 2139654 2139654 defendant Leverington William, junior yeoman 605070 605070 Leverington, William, junior, of Shipdham, yeoman 0
4327896 2139654 2139654 defendant Lane Michael husbandman 605070 605070 Lane, Michael, of Shipdham, husbandman 1
4329690 2140225 2140225 defendant Lumbard Stephen husbandman 605070 605070 Lumbard, Stephen, of Shipdham, husbandman 1
4333022 2141329 2141329 defendant Ellingham William husbandman 605070 605070 Ellingham, William, of Shipdham, husbandman 2
4357931 2150015 2150015 defendant Platfoote Robert husbandman 605070 605070 Platfoote, Robert, of Shipdham, husbandman 0
4384730 2159579 2159579 defendant Platfoote Ralph yeoman 605070 605070 Platfoote, Ralph, of Shipdham, yeoman 0
4385197 2159738 2159738 defendant Tryndell William yeoman 605070 605070 Tryndell, William, of Shipdham, yeoman 1
4385199 2159738 2159738 defendant Bett John cordwainer 605070 605070 Bett, John, of Shipdham, cordwainer 3
4385203 2159739 2159739 defendant Tryndell William yeoman 605070 605070 Tryndell, William, of Shipdham, yeoman 2
4388708 2160858 2160858 defendant Platfoote Ralph yeoman 605070 605070 Platfoote, Ralph, of Shipdham, yeoman 0
4391553 2161787 2161787 defendant Bushe Richard grocer 605070 605070 Bushe, Richard, of Shipdham, grocer 0
4401051 2164943 2164943 defendant Leverngton William, junior yeoman 605070 605070 Leverngton, William, junior, of Shipdham, yeoman 0
4403382 2165698 2165698 defendant Calye Stephen husbandman 605070 605070 Calye, Stephen, of Shipdham, husbandman 2
4403383 2165698 2165698 defendant Feate Peter husbandman 605070 605070 Feate, Peter, of Shipdham, husbandman 3
4409076 2167640 2167640 defendant Barnes Simon husbandman 605070 605070 Barnes, Simon, of Shipdham, husbandman 3
4474963 2192837 2192837 defendant Borell John   605070 605070 Borell, John, of Shipdham 0
4544196 2214101 2214101 defendant Deye John   605070 605070 Deye, John, of Shipdham 0
4646914 2245160 2245160 defendant Rothermere Thomas miller 605070 605070 Rothermere, Thomas, of Shipdham, miller 0
4778255 2289181 2289181 defendant Collesson John yeoman 605070 605070 Collesson, John, of Shipdham, yeoman 4
5104045 2387607 2387607 defendant Tabbe John husbandman 605070 605070 Tabbe, John, of Shipdham, husbandman 0
5341589 2457561 2457561 defendant Bagge Edmund husbandman 605070 605070 Bagge, Edmund, of Shipdham, husbandman 0
5341590 2457561 2457561 defendant Turnour Gilbert husbandman 605070 605070 Turnour, Gilbert, of Shipdham, husbandman 1
5341591 2457561 2457561 defendant Potkyn John husbandman 605070 605070 Potkyn, John, of Shipdham, husbandman 2
5380869 2469584 2469584 defendant Platfote Walter husbandman 605070 605070 Platfote, Walter, of Shipdham, husbandman 1
5384773 2470725 2470725 defendant Platfote Walter husbandman 605070 605070 Platfote, Walter, of Shipdham, husbandman 18
5386718 2471268 2471268 defendant Turnour John husbandman 605070 605070 Turnour, John, of Shipdham, husbandman 0
5386719 2471268 2471268 defendant Platfote Walter husbandman 605070 605070 Platfote, Walter, of Shipdham, husbandman 1
5396790 2474170 2474170 defendant Platfote Walter   605070 605070 Platfote, Walter, of Shipdham 18
5399038 2474797 2474797 defendant Turnour John husbandman 605070 605070 Turnour, John, of Shipdham, husbandman 0
5423561 2482010 2482010 defendant Colyns Thomas clerk 605070 605070 Colyns, Thomas, of Shipdham, clerk 0
5477904 2498415 2498415 defendant Maryot Thomas husbandman 605070 605070 Maryot, Thomas, of Shipdham, husbandman 0
5504715 2506393 2506393 defendant Mynne Henry husbandman 605070 605070 Mynne, Henry, of Shipdham, husbandman 1
5504718 2506393 2506393 defendant Frende Thomas   605070 605070 Frende, Thomas, of Shipdham, carpenter, administrators of 4
5507714 2507314 2507314 defendant Hastyngys Robert esq 605070 605070 Hastyngys, Robert, of Shipdham, esq 2
5507720 2507315 2507315 defendant Hastyngys Robert esq 605070 605070 Hastyngys, Robert, of Shipdham, esq 2
5532576 2514733 2514733 plaintiff Tulby Richard (legal representative) 605070 605070 Tulby, Richard, of Shipdham, executors of 0
5532579 2514733 2514733 plaintiff Canard John   605070 605070 Canard, John, of Shipdham 3
5532580 2514733 2514733 defendant Barfote John husbandman 605070 605070 Barfote, John, of Shipdham, husbandman 0
5532581 2514733 2514733 defendant Gynne James husbandman 605070 605070 Gynne, James, of Shipdham, husbandman 1
5551207 2520382 2520382 defendant Platfote Walter (legal representative) 605070 605070 Platfote, Walter, of Shipdham, husbandman, administrator of 4
5551208 2520382 2520382 defendant Platfote Thomas husbandman 605070 605070 Platfote, Thomas, of Shipdham, husbandman 5
5566350 2524749 2524749 defendant Borough John (legal representative) 605070 605070 Borough, John, of Shipdham, executors of 8
5567407 2525049 2525049 plaintiff Deynes Thomas (legal representative) 605070 605070 Deynes, Thomas, of Shipdham, husbandman, executors of 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);