names

146 rows where place_id = 586299

✎ 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
3588382 1864017 1864017 defendant Mylys Thomas laborer 586299 586299 Mylys, Thomas, of Barowe, laborer 0
3600511 1867808 1867808 defendant Norwold William carpenter 586299 586299 Norwold, William, of Barowe, carpenter 0
3605287 1869319 1869319 defendant Robartys Richard yeoman 586299 586299 Robartys, Richard, of Barowe, yeoman 0
3618155 1873303 1873303 defendant Skyppar Thomas smith 586299 586299 Skyppar, Thomas, of Barowe, smith 1
3622405 1874543 1874543 plaintiff Prior John   586299 586299 Prior, John, of Barowe 0
3658478 1912903 1912903 defendant Barnard William husbandman 586299 586299 Barnard, William, of Barowe, husbandman 2
3682565 1920652 1920652 defendant Taillour Robert husbandman 586299 586299 Taillour, Robert, of Barowe, husbandman 2
3701993 1926877 1926877 defendant Sharpe Edmund husbandman 586299 586299 Sharpe, Edmund, of Barowe, husbandman 0
3704787 1927787 1927787 defendant Barowe William husbandman 586299 586299 Barowe, William, of Barowe, husbandman 0
3704788 1927787 1927787 defendant Barnard Richard husbandman 586299 586299 Barnard, Richard, of Barowe, husbandman 1
3719376 1932343 1932343 defendant Casselyn Nicholas yeoman 586299 586299 Casselyn, Nicholas, of Barowe, yeoman 1
3719377 1932343 1932343 defendant Crystyan William yeoman 586299 586299 Crystyan, William, of Barowe, yeoman 2
3719378 1932343 1932343 defendant Stevyns Roger yeoman 586299 586299 Stevyns, Roger, of Barowe, yeoman 3
3719379 1932343 1932343 defendant Dunnowe Robert yeoman 586299 586299 Dunnowe, Robert, of Barowe, yeoman 4
3719380 1932343 1932343 defendant Raffe Robert yeoman 586299 586299 Raffe, Robert, of Barowe, yeoman 5
3719381 1932343 1932343 defendant Nycolles John yeoman 586299 586299 Nycolles, John, of Barowe, yeoman 6
3732884 1936513 1936513 defendant Henshawe Robert husbandman 586299 586299 Henshawe, Robert, of Barowe, husbandman 0
3757509 1944321 1944321 defendant Spenluff Roger husbandman 586299 586299 Spenluff, Roger, of Barowe, husbandman 4
3757924 1944463 1944463 defendant Norman William laborer 586299 586299 Norman, William, of Barowe, laborer 0
3788470 1954197 1954197 defendant Norman John husbandman 586299 586299 Norman, John, of Barowe, husbandman 0
3802772 1958763 1958763 plaintiff Plesaunce William   586299 586299 Plesaunce, William, of Barowe 0
3821931 1964752 1964752 defendant Judson Robert husbandman 586299 586299 Judson, Robert, of Barowe, husbandman 2
3822021 1964780 1964780 defendant Tenby Benedict husbandman 586299 586299 Tenby, Benedict, of Barowe, husbandman 0
3825675 1965883 1965883 defendant Debnam John husbandman 586299 586299 Debnam, John, of Barowe, husbandman 3
3844218 1971741 1971741 defendant Norman John husbandman 586299 586299 Norman, John, of Barowe, husbandman 0
3852436 1974368 1974368 defendant Norman John husbandman 586299 586299 Norman, John, of Barowe, husbandman 1
3865382 1978636 1978636 defendant Cockes John husbandman 586299 586299 Cockes, John, of Barowe, husbandman 2
3870081 1980235 1980235 defendant Barnard William husbandman 586299 586299 Barnard, William, of Barowe, husbandman 0
3870082 1980235 1980235 defendant Gladwyn John, junior husbandman 586299 586299 Gladwyn, John, junior, of Barowe, husbandman 1
3889856 1986846 1986846 defendant Swyne William husbandman 586299 586299 Swyne, William, of Barowe, husbandman 0
3904225 1991658 1991658 defendant Jekman John butcher 586299 586299 Jekman, John, of Barowe, butcher 1
3915765 1995650 1995650 defendant Mannyng Thomas husbandman 586299 586299 Mannyng, Thomas, of Barowe, husbandman 1
3937747 2002957 2002957 defendant Bowdewyn William yeoman 586299 586299 Bowdewyn, William, of Barowe, yeoman 2
3974278 2015571 2015571 defendant Peerson Daniel   586299 586299 Peerson, Daniel, of Barowe, rough mason 1
3980646 2017844 2017844 defendant Plesaunce Thomas yeoman 586299 586299 Plesaunce, Thomas, of Barowe, yeoman 0
4320215 2137171 2137171 defendant Braie Robert yeoman 586299 586299 (Braie, Robert, of Barowe, yeoman 1
4372692 2155311 2155311 defendant Bray Robert yeoman 586299 586299 Bray, Robert, of Barowe, yeoman 0
4433640 2175288 2175288 plaintiff Grymesbey Edmund de   586299 586299 Grymesbey, Edmund de, of Barowe, parson 0
4433641 2175288 2175288 defendant Warde Walter   586299 586299 Warde, Walter, of Barowe 0
4433644 2175290 2175290 plaintiff Grymesby Edmund de   586299 586299 Grymesby, Edmund de, of Barowe, parson 0
4433646 2175291 2175291 plaintiff Grymesby Edmund de   586299 586299 Grymesby, Edmund de, of Barowe, parson 0
4433648 2175291 2175291 defendant Gantron John   586299 586299 Gantron, John, of Barowe 1
4436169 2176052 2176052 defendant Mellere Nicholas le   586299 586299 Mellere, Nicholas le, of Barowe 0
4439803 2181726 2181726 defendant Midly William   586299 586299 Midly, William, of Barowe 0
4476303 2193251 2193251 plaintiff Freman Richard   586299 586299 Freman, Richard, of Barowe, on his own account 0
4476305 2193251 2193251 defendant Thorp Thomas   586299 586299 Thorp, Thomas, of Barowe, son of John Thorp 1
4483135 2195421 2195421 defendant West Richard carter 586299 586299 West, Richard, of Barowe, carter 0
4528420 2209166 2209166 defendant Ryse Roger   586299 586299 Ryse, Roger, of Barowe 0
4538118 2212207 2212207 plaintiff Thorp Thomas   586299 586299 Thorp, Thomas, of Barowe 0
4544631 2214232 2214232 defendant Lonyn John   586299 586299 Lonyn, John, of Barowe 2
4545484 2214511 2214511 defendant Wale John   586299 586299 Wale, John, of Barowe 1
4552636 2216777 2216777 defendant Taillour John   586299 586299 Taillour, John, of Barowe 2
4554972 2217482 2217482 defendant Bacon Thomas   586299 586299 Bacon, Thomas, of Barowe 1
4567400 2221365 2221365 plaintiff Tendeby Nicholas   586299 586299 Tendeby, Nicholas, of Barowe 0
4571047 2222514 2222514 defendant Taillour John   586299 586299 Taillour, John, of Barowe 0
4605995 2232990 2232990 defendant Freman William   586299 586299 Freman, William, of Barowe 0
4606793 2233239 2233239 defendant Wightefeld John   586299 586299 Wightefeld, John, of Barowe 0
4606794 2233239 2233239 defendant Gaby Nicholas de   586299 586299 together with Gaby, Nicholas de, of Barowe 1
4606797 2233239 2233239 defendant Coke William   586299 586299 Coke, William, of Barowe 4
4606800 2233239 2233239 defendant Jankynson Alanson Robert   586299 586299 Jankynson Alanson, Robert, of Barowe 7
4606804 2233239 2233239 defendant Teleby John   586299 586299 Teleby, John,of Barowe 11
4606806 2233240 2233240 defendant Wightifeld John   586299 586299 Wightifeld, John, of Barowe 0
4606807 2233240 2233240 defendant Gaby Nicholas de   586299 586299 together with Gaby, Nicholas de, of Barowe 1
4606810 2233240 2233240 defendant Coke William   586299 586299 Coke, William, of Barowe 4
4606813 2233240 2233240 defendant Jonkynson Alanson Robert   586299 586299 Jonkynson Alanson, Robert, of Barowe 7
4606817 2233240 2233240 defendant Teleby John   586299 586299 Teleby, John, of Barowe 11
4611127 2234544 2234544 defendant Spenser John   586299 586299 Spenser, John, of Barowe 3
4614426 2235520 2235520 defendant Wightfeld John   586299 586299 Wightfeld, John, of Barowe 5
4614441 2235524 2235524 defendant Dobson William   586299 586299 Dobson, William, of Barowe 0
4626239 2239165 2239165 plaintiff Poteger John   586299 586299 Poteger, John, of Barowe 0
4626241 2239165 2239165 defendant Taillour Richard   586299 586299 Taillour, Richard, of Barowe 1
4636366 2242210 2242210 defendant Wyghtefeld John   586299 586299 Wyghtefeld, John, of Barowe on Humber 0
4640926 2243444 2243444 defendant Shepey Thomas   586299 586299 Shepey, Thomas, of Barowe 1
4652380 2246693 2246693 defendant Wightefeld John yeoman 586299 586299 Wightefeld, John, of Barowe, yeoman 1
4660010 2248978 2248978 plaintiff de Redenes Agnes   586299 586299 de Redenes, Agnes, of Barowe 0
4661089 2249292 2249292 defendant Alwedir William husbandman 586299 586299 Alwedir, William, of Barowe, husbandman 1
4688553 2261986 2261986 defendant Laurence William husbandman 586299 586299 Laurence, William, of Barowe, husbandman 0
4688557 2261986 2261986 defendant Tincher John husbandman 586299 586299 Tincher, John, of Barowe, husbandman 4
4701626 2265901 2265901 plaintiff Gladewyn John husbandman 586299 586299 Gladewyn, John, of Barowe, husbandman 0
4716224 2270382 2270382 defendant Warner Robert husbandman 586299 586299 Warner, Robert, of Barowe, husbandman 0
4717606 2270843 2270843 defendant Ile Richard of the draper 586299 586299 Ile, Richard of the, of Barowe, draper 0
4719744 2271523 2271523 defendant Wysowe John yeoman 586299 586299 Wysowe, John, of Barowe, yeoman 0
4739869 2277544 2277544 defendant Teneby John husbandman 586299 586299 Teneby, John, of Barowe, husbandman 0
4739871 2277545 2277545 defendant Teneby John, senior husbandman 586299 586299 Teneby, John, senior, of Barowe, husbandman 0
4740341 2277685 2277685 plaintiff Bailly William   586299 586299 Bailly, William, of Barowe 0
4740342 2277685 2277685 defendant Wesyll John husbandman 586299 586299 Wesyll, John, of Barowe, husbandman 0
4741496 2278007 2278007 defendant Wysowe John yeoman 586299 586299 Wysowe, John, of Barowe, yeoman 0
4749025 2280199 2280199 defendant Wranby Alan husbandman 586299 586299 Wranby, Alan, of Barowe, husbandman 0
4758759 2283095 2283095 defendant Nuttyng John miller 586299 586299 Nuttyng, John, of Barowe, miller 0
4783284 2290791 2290791 defendant Charles Henry husbandman 586299 586299 Charles, Henry, of Barowe, husbandman 0
4843224 2309402 2309402 defendant Charles Henry husbandman 586299 586299 Charles, Henry, of Barowe, husbandman 0
4843225 2309402 2309402 defendant Turnour Richard husbandman 586299 586299 Turnour, Richard, of Barowe, husbandman 1
4850617 2311652 2311652 defendant Hauke John husbandman 586299 586299 Hauke, John, of Barowe, husbandman 0
4863217 2315471 2315471 defendant Wryght John   586299 586299 Wryght, John, of Barowe, wright 7
4891412 2324044 2324044 defendant Holume Richard husbandman 586299 586299 Holume, Richard, of Barowe, husbandman 0
4916827 2331767 2331767 defendant Wryght John   586299 586299 Wryght, John, of Barowe, wright 2
4942324 2339586 2339586 defendant Wryght John   586299 586299 Wryght, John, of Barowe, wright 5
4948733 2341588 2341588 defendant Warner Thomas (legal representative) 586299 586299 Warner, Thomas, of Barowe, executor of 0
4948734 2341588 2341588 defendant Warner John husbandman 586299 586299 Warner, John, of Barowe, husbandman 1
4980555 2351124 2351124 defendant Grave John husbandman 586299 586299 Grave, John, of Barowe, husbandman 2

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