names

184 rows where place_id = 587935

✎ 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
3592876 1865389 1865389 defendant Mundes Robert butcher 587935 587935 Mundes, Robert, of Colby, butcher 1
3656598 1912317 1912317 defendant Morret William husbandman 587935 587935 Morret, William, of Colby, husbandman 3
3674706 1918137 1918137 defendant Tomson Miles husbandman 587935 587935 Tomson, Miles, of Colby, husbandman 0
3705405 1927976 1927976 defendant Thomlynson John   587935 587935 Thomlynson, John, of Colby, clerk, administrators of 0
3705406 1927976 1927976 defendant Myddylton Thomas husbandman 587935 587935 (Myddylton, Thomas, of Colby, husbandman 1
3705407 1927976 1927976 defendant Handeby John husbandman 587935 587935 Handeby, John, of Colby, husbandman 2
3748710 1941525 1941525 defendant Wenchelawe John gent 587935 587935 Wenchelawe, John, of Colby, gent 1
3755466 1943661 1943661 defendant Aleyns William husbandman 587935 587935 Aleyns, William, of Colby, husbandman 4
3779922 1951449 1951449 defendant Walshe William gent 587935 587935 Walshe, William, of Colby, gent 0
3796856 1956896 1956896 defendant Walshe William gent 587935 587935 Walshe, William, of Colby, gent 0
3807428 1960227 1960227 defendant Aleyn William   587935 587935 Aleyn, William, of Colby, worsted weaver 1
3810646 1961228 1961228 defendant Kechyn William husbandman 587935 587935 Kechyn, William, of Colby, husbandman 0
3838244 1969880 1969880 defendant Dean John chaplain 587935 587935 Dean, John, of Colby, chaplain 0
3842757 1971267 1971267 defendant Coddyngton William husbandman 587935 587935 Coddyngton, William, of Colby, husbandman 0
3852328 1974330 1974330 defendant Rede Robert butcher 587935 587935 Rede, Robert, of Colby, butcher 0
3852329 1974330 1974330 defendant Nytynghalle William chaplain 587935 587935 Nytynghalle, William, of Colby, chaplain 1
3856451 1975642 1975642 plaintiff Wulcy John   587935 587935 Wulcy, John, of Colby 0
3869223 1979951 1979951 plaintiff Ussher Richard chaplain 587935 587935 Ussher, Richard, of Colby, chaplain 0
3870321 1980325 1980325 plaintiff Wulcy John   587935 587935 Wulcy, John, of Colby 0
3879510 1983401 1983401 plaintiff Myller Henry   587935 587935 Myller, Henry, of Colby 0
3879511 1983401 1983401 plaintiff Myller Simon   587935 587935 Myller, Simon, of Colby 1
3910586 1993854 1993854 defendant Sheffeld Robert (legal representative) 587935 587935 Sheffeld, Robert, of Colby, gent, executors of 0
3910587 1993854 1993854 defendant Fowler William husbandman 587935 587935 (Fowler, William, of Colby, husbandman 1
3910589 1993855 1993855 defendant Sheffeld Robert (legal representative) 587935 587935 Sheffeld, Robert, of Colby, gent, executors of 0
3910590 1993855 1993855 defendant Fowler William yeoman 587935 587935 (Fowler, William, of Colby, yeoman 1
3940276 2003767 2003767 defendant Codyngton William husbandman 587935 587935 Codyngton, William, of Colby, husbandman 0
3947526 2006206 2006206 defendant Gyll James husbandman 587935 587935 Gyll, James, of Colby, or of Attylbrygge, husbandman 0
3960738 2010856 2010856 defendant Tompson Robert yeoman 587935 587935 Tompson, Robert, of Colby, yeoman 0
3970136 2014154 2014154 defendant Walshe William gent 587935 587935 Walshe, William, of Colby, gent 4
3992492 2022075 2022075 defendant Dykam or Dackam William gent 587935 587935 Dykam or Dackam, William, of Colby, gent 0
4026141 2033995 2033995 plaintiff Burre John knacher 587935 587935 Burre, John, of Colby, knacher 0
4120868 2067751 2067751 defendant Backham or Dackham William gent 587935 587935 Backham or Dackham, William, of Colby, gent 0
4120870 2067752 2067752 defendant Backham William gent 587935 587935 Backham, William, of Colby, gent 0
4164152 2082989 2082989 defendant Thorpe William husbandman 587935 587935 Thorpe, William, of Colby, husbandman 0
4170546 2085194 2085194 defendant Arnolde John gent 587935 587935 Arnolde, John, of Colby, gent 0
4170547 2085194 2085194 defendant Robinson John husbandman 587935 587935 Robinson, John, of Colby, husbandman 1
4175471 2086893 2086893 defendant Goddyns James glover 587935 587935 Goddyns, James, of Colby, glover 0
4211255 2099487 2099487 defendant Thorpe William husbandman 587935 587935 Thorpe, William, of Colby, husbandman 0
4288949 2126103 2126103 defendant Bate Christopher gent 587935 587935 Bate, Christopher, of Colby, gent 1
4309547 2133499 2133499 defendant Allen John tanner 587935 587935 Allen, John, of Colby, tanner 0
4325035 2138757 2138757 defendant Allen John tanner 587935 587935 Allen, John, of Colby, tanner 0
4351454 2147760 2147760 defendant Allyn John tanner 587935 587935 Allyn, John, of Colby, tanner 0
4365892 2152838 2152838 defendant Johnson Peter gent 587935 587935 Johnson, Peter, of Colby, gent 0
4438087 2181212 2181212 plaintiff Amwyk Thomas   587935 587935 Amwyk, Thomas, of Colby 0
4448849 2184580 2184580 defendant Brade William   587935 587935 Brade, William, of Colby 0
4455593 2186758 2186758 defendant Webstere John   587935 587935 Webstere, John, of Colby, son of Roger Webstere 0
4455891 2186859 2186859 defendant Brid William   587935 587935 Brid, William, of Colby 0
4456001 2186897 2186897 defendant Brid William   587935 587935 Brid, William, of Colby 0
4456003 2186898 2186898 defendant Brid William   587935 587935 Brid, William, of Colby 0
4456005 2186899 2186899 defendant Brid William   587935 587935 Brid, William, of Colby 0
4456007 2186900 2186900 defendant Bud William   587935 587935 Bud, William, of Colby 0
4456297 2186992 2186992 defendant Leek John de   587935 587935 Leek, John de, of Colby 1
4459885 2188146 2188146 defendant Magges Robert   587935 587935 Magges, Robert, of Colby 0
4464944 2189708 2189708 defendant Fuller John   587935 587935 Fuller, John, of Colby 11
4505134 2202138 2202138 plaintiff Skyn James   587935 587935 Skyn, James, of Colby 0
4523797 2207771 2207771 defendant Bettys Richard   587935 587935 Bettys, Richard, of Colby 0
4540996 2213091 2213091 plaintiff Williamson John   587935 587935 Williamson, John, of Colby 0
4544899 2214323 2214323 plaintiff Jonson William   587935 587935 (Jonson, William, of Colby 1
4547284 2215085 2215085 defendant Tulle William   587935 587935 Tulle, William, of Colby 1
4555878 2217778 2217778 defendant Skyn James   587935 587935 Skyn, James, of Colby 4
4576428 2224140 2224140 defendant Stikenay Luke de   587935 587935 Stikenay, Luke de, of Colby 0
4581708 2225727 2225727 defendant Bryd William   587935 587935 Bryd, William, of Colby 3
4582738 2226040 2226040 plaintiff Tucke Robert   587935 587935 Tucke, Robert, of Colby 1
4582742 2226041 2226041 plaintiff Tuske Robert   587935 587935 Tuske, Robert, of Colby 1
4589139 2227981 2227981 defendant Draper William   587935 587935 Draper, William, of Colby 0
4589140 2227981 2227981 defendant Leygreffe Robert   587935 587935 Leygreffe, Robert, of Colby 1
4592943 2229120 2229120 defendant Draper William   587935 587935 Draper, William, of Colby 1
4595721 2229916 2229916 defendant Till Willam   587935 587935 Till, Willam, of Colby 5
4613235 2235179 2235179 defendant Mason Richard   587935 587935 Mason, Richard, of Colby 2
4613237 2235179 2235179 defendant Plughwright John   587935 587935 Plughwright, John, of Colby 4
4613242 2235179 2235179 defendant Matheuson Richard   587935 587935 Matheuson, Richard, of Colby 9
4613942 2235372 2235372 defendant Bryd William   587935 587935 Bryd, William, of Colby 0
4623680 2238382 2238382 defendant Molys Thomas   587935 587935 Molys, Thomas, of Colby 1
4625089 2238815 2238815 defendant Draper William   587935 587935 Draper, William, of Colby 0
4625090 2238815 2238815 defendant Burton Simon   587935 587935 Burton, Simon, of Colby 1
4627118 2239432 2239432 defendant Tylle William   587935 587935 Tylle, William, of Colby 0
4627129 2239434 2239434 defendant Tylle William   587935 587935 Tylle, William, of Colby 1
4629459 2240142 2240142 defendant Tille William   587935 587935 Tille, William, of Colby 0
4629464 2240143 2240143 defendant Tylle William   587935 587935 Tylle, William, of Colby 0
4637849 2242609 2242609 plaintiff Brydd William   587935 587935 Brydd, William, of Colby 0
4637857 2242610 2242610 plaintiff Brydd William   587935 587935 Brydd, William, of Colby 0
4646730 2245109 2245109 defendant Tylle William   587935 587935 Tylle, William, of Colby 1
4646733 2245110 2245110 defendant Tylle William   587935 587935 Tylle, William, of Colby 0
4647855 2245438 2245438 defendant Tylle William   587935 587935 Tylle, William, of Colby 0
4648434 2245588 2245588 defendant Bembylby John   587935 587935 Bembylby, John, of Colby 0
4648435 2245588 2245588 defendant Kateryngson John   587935 587935 Kateryngson, John, of Colby 1
4659310 2248778 2248778 defendant Wynter John Richardson husbandman 587935 587935 Wynter, John Richardson, of Colby, husbandman 0
4659311 2248778 2248778 defendant Mason Richard husbandman 587935 587935 Mason, Richard, of Colby, husbandman 1
4659312 2248778 2248778 defendant Robynson John husbandman 587935 587935 Robynson, John, of Colby, husbandman 2
4659313 2248778 2248778 defendant Robynson William husbandman 587935 587935 Robynson, William, of Colby, husbandman 3
4659314 2248778 2248778 defendant del Hall Thomas husbandman 587935 587935 del Hall, Thomas, of Colby, husbandman 4
4659315 2248778 2248778 defendant Godeale Thomas husbandman 587935 587935 Godeale, Thomas, of Colby, husbandman 5
4659528 2248832 2248832 defendant Tyll William gent 587935 587935 Tyll, William, of Colby, gent 1
4660023 2248983 2248983 defendant Tille William husbandman 587935 587935 Tille, William, of Colby, husbandman 0
4682538 2260161 2260161 defendant Andrewe Martin husbandman 587935 587935 Andrewe, Martin, of Colby, husbandman 2
4694898 2263893 2263893 defendant Clyff Robert husbandman 587935 587935 Clyff, Robert, of Colby, husbandman 1
4706533 2267423 2267423 defendant Brid William yeoman 587935 587935 Brid, William, of Colby, yeoman 1
4717988 2270965 2270965 defendant Metton John baker 587935 587935 Metton, John, of Colby, baker 4
4735350 2276200 2276200 defendant Plughwright John husbandman 587935 587935 Plughwright, John, of Colby, husbandman 5
4755189 2282010 2282010 defendant Weste John husbandman 587935 587935 Weste, John, of Colby, husbandman 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);