names

195 rows where place_id = 588326

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594111 1865801 1865801 defendant Gunton John husbandman 588326 588326 Gunton, John, of Belton, husbandman 0
3613751 1871952 1871952 defendant Kechyn John husbandman 588326 588326 Kechyn, John, of Belton, husbandman 0
3613753 1871953 1871953 defendant Kechyn John husbandman 588326 588326 Kechyn, John, of Belton, husbandman 0
3628276 1903705 1903705 defendant Rangill Henry husbandman 588326 588326 Rangill, Henry, of Belton, husbandman 1
3668408 1916070 1916070 defendant Broughton John laborer 588326 588326 Broughton, John, of Belton, laborer 1
3668409 1916070 1916070 defendant Broughton Henry laborer 588326 588326 Broughton, Henry, of Belton, laborer 2
3668935 1916215 1916215 defendant Wryght William husbandman 588326 588326 Wryght, William, of Belton, husbandman 0
3670567 1916757 1916757 defendant Pylfote William yeoman 588326 588326 Pylfote, William, of Belton, yeoman 1
3686794 1922026 1922026 defendant Carsshawe John husbandman 588326 588326 Carsshawe, John, of Belton, husbandman 1
3691259 1923424 1923424 defendant Drake Thomas yeoman 588326 588326 Drake, Thomas, of belton, yeoman 0
3699566 1926096 1926096 defendant Tollys William husbandman 588326 588326 Tollys, William, of Belton, husbandman 0
3704821 1927800 1927800 defendant Dolyn Nicholas husbandman 588326 588326 Dolyn, Nicholas, of Belton, husbandman 0
3705696 1928063 1928063 defendant Drake Thomas yeoman 588326 588326 Drake, Thomas, of Belton, yeoman 0
3707048 1928491 1928491 defendant Parker George yeoman 588326 588326 Parker, George, of Belton, yeoman 1
3707049 1928491 1928491 defendant Parker Robert yeoman 588326 588326 Parker, Robert, of Belton, yeoman 2
3719715 1932434 1932434 defendant Drake Thomas yeoman 588326 588326 Drake, Thomas, of Belton, yeoman 0
3721207 1932934 1932934 defendant Parker George yeoman 588326 588326 Parker, George, of Belton, yeoman 1
3721208 1932934 1932934 defendant Parker Robert yeoman 588326 588326 Parker, Robert, of Belton, yeoman 2
3732487 1936391 1936391 defendant Jeffrey Robert husbandman 588326 588326 Jeffrey, Robert, of Belton, husbandman 1
3732488 1936391 1936391 defendant Newman Robwert husbandman 588326 588326 Newman, Robwert, of Belton, husbandman 2
3752567 1942730 1942730 defendant Glowe John husbandman 588326 588326 Glowe, John, of Belton, husbandman 0
3752568 1942730 1942730 defendant Redpich George tailor 588326 588326 Redpich, George, of Belton, tailor 1
3758004 1944486 1944486 defendant Cathrall Richard clerk 588326 588326 Cathrall, Richard, of Belton, clerk 0
3758005 1944486 1944486 defendant Baker Richard husbandman 588326 588326 Baker, Richard, of Belton, husbandman 1
3775994 1950235 1950235 defendant Rysyng William husbandman 588326 588326 Rysyng, William, of Belton, husbandman 1
3787161 1953775 1953775 defendant Elowe John husbandman 588326 588326 Elowe, John, of Belton, husbandman 0
3803651 1959057 1959057 defendant Cowper John husbandman 588326 588326 Cowper, John, of Belton, husbandman 0
3810861 1961299 1961299 defendant Nedeham Lawrence yeoman 588326 588326 Nedeham, Lawrence, of Belton, yeoman 0
3835392 1969007 1969007 defendant Rysyng William husbandman 588326 588326 Rysyng, William, of Belton, husbandman 0
3836458 1969310 1969310 defendant Glewe Richard husbandman 588326 588326 Glewe, Richard, of Belton, husbandman 0
3877232 1982627 1982627 defendant Pope Alexander husbandman 588326 588326 Pope, Alexander, of Belton, husbandman 0
3888494 1986412 1986412 defendant Rampyne William gent 588326 588326 Rampyne, William, of Belton, gent 1
3888495 1986412 1986412 defendant Rolston William yeoman 588326 588326 Rolston, William, of Belton, yeoman 2
3906860 1992584 1992584 defendant Pepar John, junior husbandman 588326 588326 Pepar, John, junior, of Belton, husbandman 0
3906861 1992584 1992584 defendant Pepar John, senior husbandman 588326 588326 Pepar, John, senior, of Belton, husbandman 1
3906862 1992584 1992584 defendant Rysyng William husbandman 588326 588326 Rysyng, William, of Belton, husbandman 2
3915244 1995461 1995461 defendant Lambert Margaret widow 588326 588326 Lambert, Margaret, of Belton, widow 1
3920580 1997231 1997231 defendant Pepar John, junior husbandman 588326 588326 Pepar, John, junior, of Belton, husbandman 0
3920581 1997231 1997231 defendant Pepar John, senior husbandman 588326 588326 Pepar, John, senior, of Belton, husbandman 1
3920582 1997231 1997231 defendant Rysyng William husbandman 588326 588326 Rysyng, William, of Belton, husbandman 2
3933650 2001544 2001544 plaintiff Jernegan John gent 588326 588326 Jernegan, John, of Belton, gent 1
3942947 2004646 2004646 defendant Towne James husbandman 588326 588326 Towne, James, of Belton, husbandman 0
4014831 2030019 2030019 defendant Poplewell Francis yeoman 588326 588326 Poplewell, Francis, of Belton, yeoman 0
4014832 2030019 2030019 defendant Broughton William yeoman 588326 588326 Broughton, William, of Belton, yeoman 1
4014833 2030019 2030019 defendant Medley Thomas yeoman 588326 588326 Medley, Thomas, of Belton, yeoman 2
4014834 2030019 2030019 defendant Kester Richard yeoman 588326 588326 Kester, Richard, of Belton, yeoman 3
4019814 2031815 2031815 defendant Kester Robert yeoman 588326 588326 Kester, Robert, of Belton, yeoman 0
4019826 2031821 2031821 defendant Kester Richard yeoman 588326 588326 Kester, Richard, of Belton, yeoman 0
4021344 2032357 2032357 defendant Aslacke Augustine husbandman 588326 588326 Aslacke, Augustine, of Belton, husbandman 0
4033277 2036556 2036556 defendant Carter Richard yeoman 588326 588326 Carter, Richard, of Belton, yeoman 0
4050872 2042753 2042753 defendant Slefurthe Thomas yeoman 588326 588326 Slefurthe, Thomas, of Belton, yeoman 0
4050878 2042755 2042755 defendant Kester Richard yeoman 588326 588326 Kester, Richard, of Belton, yeoman 0
4052597 2043353 2043353 defendant Popplewell Francis yeoman 588326 588326 Popplewell, Francis, of Belton, yeoman 0
4052598 2043353 2043353 defendant Broughton William yeoman 588326 588326 Broughton, William, of Belton, yeoman 1
4052599 2043353 2043353 defendant Medley Thomas yeoman 588326 588326 Medley, Thomas, of Belton, yeoman 2
4052600 2043353 2043353 defendant Lester Richard yeoman 588326 588326 Lester, Richard, of Belton, yeoman 3
4103185 2061424 2061424 defendant Broughton William yeoman 588326 588326 Broughton, William, of Belton, yeoman 0
4103189 2061425 2061425 defendant Broughton William yeoman 588326 588326 Broughton, William, of Belton, yeoman 0
4119145 2067136 2067136 defendant Ludman William gent 588326 588326 Ludman, William, of Belton, gent 0
4191784 2092682 2092682 defendant Awdae John butcher 588326 588326 Awdae, John, of Belton, butcher 0
4213473 2100230 2100230 defendant Ludman William gent 588326 588326 Ludman, William, of Belton, gent 0
4219509 2102323 2102323 defendant Ridlington John husbandman 588326 588326 Ridlington, John, of Belton, husbandman 0
4221452 2102994 2102994 defendant Ridlington John yeoman 588326 588326 Ridlington, John, of Belton, yeoman 0
4221483 2103006 2103006 defendant Ridlington John yeoman or husbandman 588326 588326 Ridlington, John, of Belton, yeoman or husbandman 0
4223672 2103765 2103765 defendant Ridlington John yeoman 588326 588326 Ridlington, John, of Belton, yeoman 0
4241419 2110115 2110115 defendant Pope John, senior husbandman 588326 588326 Pope, John, senior, of Belton, husbandman 1
4247343 2112088 2112088 defendant Turner William yeoman 588326 588326 Turner, William, of Belton, yeoman 2
4280232 2122991 2122991 defendant Bonner William gent 588326 588326 Bonner, William, of Belton, gent 1
4280946 2123240 2123240 defendant Musgrave Richard husbandman 588326 588326 Musgrave, Richard, of Belton, husbandman 0
4283608 2124175 2124175 defendant Boyse Henry yeoman 588326 588326 Boyse, Henry, of Belton, yeoman 0
4301226 2130549 2130549 defendant Bonner William gent 588326 588326 Bonner, William, of Belton, gent 0
4353391 2148413 2148413 defendant Davie Thomas yeoman 588326 588326 Davie, Thomas, of Belton, or of Sanctofte, Isle of Axholme, yeoman 0
4360955 2151091 2151091 defendant Stubley Walter yeoman 588326 588326 Stubley, Walter, of Belton, yeoman 0
4364050 2152196 2152196 defendant Sampson Richard yeoman 588326 588326 Sampson, Richard, of Belton, yeoman 0
4370108 2154370 2154370 defendant Brigges William yeoman 588326 588326 Brigges, William, of Belton, yeoman 0
4370109 2154370 2154370 defendant Tomson Robert yeoman 588326 588326 Tomson, Robert, of Belton, yeoman 1
4370110 2154370 2154370 defendant Sneth Robert laborer 588326 588326 Sneth, Robert, of Belton, laborer 2
4370111 2154370 2154370 defendant Badyer Siraac laborer 588326 588326 Badyer, Siraac, of Belton, laborer 3
4372118 2155094 2155094 defendant Awdus John yeoman 588326 588326 Awdus, John, of Belton, yeoman 0
4376833 2156785 2156785 defendant Wrente Lancelot yeoman 588326 588326 Wrente, Lancelot, of Belton, yeoman 2
4377969 2157193 2157193 defendant Dale William yeoman 588326 588326 Dale, William, of Belton, yeoman 1
4414297 2169383 2169383 plaintiff Crake Robert   588326 588326 Crake, Robert, of Belton 0
4421596 2171646 2171646 plaintiff Crake Robert   588326 588326 Crake, Robert, of Belton 0
4421599 2171647 2171647 plaintiff Crake Robert   588326 588326 Crake, Robert, of Belton 0
4430063 2174186 2174186 defendant Rylyng John   588326 588326 Rylyng, John, of Belton, vicar 1
4462453 2188949 2188949 defendant Hagun Thomas   588326 588326 Hagun, Thomas, of Belton 1
4462454 2188949 2188949 defendant Ferour Richard   588326 588326 Ferour, Richard, of Belton 2
4473275 2192300 2192300 defendant Spoo Thomas   588326 588326 Spoo, Thomas, of Belton 11
4477633 2193672 2193672 defendant Nene Stephen   588326 588326 Nene, Stephen, of Belton 0
4484861 2195967 2195967 defendant Chaumpeyn Richard   588326 588326 Chaumpeyn, Richard, of Belton 0
4488527 2197133 2197133 defendant Pacy Robert   588326 588326 Pacy, Robert, of Belton 0
4492995 2198508 2198508 defendant Webster Peter   588326 588326 Webster, Peter, of Belton 2
4493869 2198775 2198775 defendant Hoberd Gilbert   588326 588326 Hoberd, Gilbert, of Belton 0
4494432 2198956 2198956 defendant Ougham Robert   588326 588326 Ougham, Robert, of Belton 1
4494433 2198956 2198956 defendant Pasy Robert   588326 588326 Pasy, Robert, of Belton 2
4495738 2199350 2199350 defendant Lambart John   588326 588326 Lambart, John, of Belton 2
4495739 2199350 2199350 defendant Lambard Robert   588326 588326 Lambard, Robert, of Belton 3
4524108 2207871 2207871 defendant Clerk John   588326 588326 Clerk, John, of Belton 0
4537218 2211913 2211913 plaintiff Aleyn Ralph chaplain 588326 588326 Aleyn, Ralph, of Belton, chaplain 1
4544999 2214356 2214356 defendant Graunt Thomas   588326 588326 Graunt, Thomas, of Belton 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);