names

161 rows where place_id = 595778

✎ 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
3621313 1874208 1874208 defendant Haukyn Thomas yeoman 595778 595778 Haukyn, Thomas, of Boughton under Blean, yeoman 0
3621850 1874374 1874374 defendant Patnam Thomas husbandman 595778 595778 Patnam, Thomas, of Boughton, husbandman 0
3621852 1874375 1874375 defendant Patnam Thomas husbandman 595778 595778 Patnam, Thomas, of Boughton, husbandman 0
3622762 1874649 1874649 defendant Ward John husbandman 595778 595778 Ward, John, of Boughton, husbandman 0
3625816 1875610 1875610 plaintiff Yonge William baker 595778 595778 Yonge, William, of Boughton under Blene, baker 0
3625817 1875610 1875610 defendant Walshe William (legal representative) 595778 595778 Walshe, William, of Boughton under Blene, husbandman, executors of 0
3625819 1875610 1875610 defendant Gilys John husbandman 595778 595778 Gilys, John, of Boughton under Blene, husbandman 2
3625820 1875611 1875611 plaintiff Yonge William baker 595778 595778 Yonge, William, of Boughton under Blene, baker 0
3625821 1875611 1875611 defendant Walshe William (legal representative) 595778 595778 Walshe, William, of Boughton under Blene, husbandman, executors of 0
3625823 1875611 1875611 defendant Gilys John husbandman 595778 595778 Gilys, John, of Boughton under Blene, husbandman 2
3625824 1875612 1875612 plaintiff Yonge William baker 595778 595778 Yonge, William, of Boughton under Blene, baker 0
3625825 1875612 1875612 defendant Walsshe William (legal representative) 595778 595778 Walsshe, William, of Boughton under Blene, husbandman, executors of 0
3625826 1875612 1875612 defendant Gilys John husbandman 595778 595778 (Gilys, John, of Boughton under Blene, husbandman 1
3626550 1903155 1903155 defendant Harry Stephen husbandman 595778 595778 Harry, Stephen, of Boughton under Blean, husbandman 1
3673420 1917707 1917707 defendant Courthop Thomas laborer 595778 595778 Courthop, Thomas, of Boughton under Blean, laborer 0
3673421 1917707 1917707 defendant Danyell Thomas laborer 595778 595778 Danyell, Thomas, of Boughton under Blean, laborer 1
3673772 1917825 1917825 defendant Bennys William painter 595778 595778 Bennys, William, of Boughton under Blean, painter 0
3673773 1917825 1917825 defendant Chillyngden Richard laborer 595778 595778 Chillyngden, Richard, of Boughton under Blean, laborer 1
3686444 1921914 1921914 defendant Giles John, senior yeoman 595778 595778 Giles, John, senior, of Boughton under Blean, yeoman 0
3693213 1924089 1924089 defendant Aylmer Thomas yeoman 595778 595778 Aylmer, Thomas, of Boughton, yeoman 0
3704405 1927676 1927676 defendant Kempe Simon tailor 595778 595778 Kempe, Simon, of Boughton under Blean, tailor 1
3713025 1930398 1930398 defendant Bayly John husbandman 595778 595778 Bayly, John, of Boughton, husbandman 0
3718921 1932197 1932197 defendant Aylemer Thomas yeoman 595778 595778 Aylemer, Thomas, of Boughton, yeoman 1
3718924 1932198 1932198 defendant Aylemer Thomas yeoman 595778 595778 Aylemer, Thomas, of Boughton, yeoman 1
3736711 1937735 1937735 defendant Hawkyn Mathew husbandman 595778 595778 Hawkyn, Mathew, of Boughton under Blean, husbandman 0
3743696 1939910 1939910 defendant Dorley William yeoman 595778 595778 Dorley, William, of Boughton, yeoman 3
3751471 1942377 1942377 defendant Bourn John yeoman 595778 595778 Bourn, John, of Boughton, yeoman 1
3755611 1943713 1943713 defendant Dorley William yeoman 595778 595778 Dorley, William, of Boughton, yeoman 0
3756196 1943896 1943896 defendant Hawkyn Mathew yeoman 595778 595778 Hawkyn, Mathew, of Boughton under Blene, yeoman 4
3762778 1945996 1945996 defendant Hawkyn Mathew husbandman 595778 595778 Hawkyn, Mathew, of Boughton under Blene, husbandman 0
3770089 1948308 1948308 defendant Elmers or Elynayr Thomas yeoman 595778 595778 (Elmers or Elynayr, Thomas, of Boughton, yeoman 1
3772976 1949250 1949250 defendant Gyldyng Richard husbandman 595778 595778 Gyldyng, Richard, of Boughton, husbandman 0
3773233 1949336 1949336 defendant Baley William yeoman 595778 595778 Baley, William, of Boughton, yeoman 1
3773235 1949336 1949336 defendant Baley John husbandman 595778 595778 Baley, John, of Boughton, husbandman 3
3773584 1949450 1949450 defendant Dorley William yeoman 595778 595778 Dorley, William, of Boughton, yeoman 0
3780752 1951717 1951717 defendant Barbyte Stephen husbandman 595778 595778 Barbyte, Stephen, of Boughton under Bleane, husbandman 0
3801183 1958291 1958291 defendant Sponer Edward clerk 595778 595778 Sponer, Edward, of Boughton, clerk 0
3802552 1958694 1958694 defendant Tarre John roper 595778 595778 Tarre, John, of Boughton under Blene, roper 2
3809570 1960879 1960879 defendant Herst William husbandman 595778 595778 Herst, William, of Boughton, husbandman 0
3853808 1974823 1974823 defendant Cley Richard husbandman 595778 595778 Cley, Richard, of Boughton, husbandman 1
3900559 1990417 1990417 defendant Tarton Robert clerk 595778 595778 Tarton, Robert, of Boughton, clerk 0
3900560 1990417 1990417 defendant Oley Richard husbandman 595778 595778 Oley, Richard, of Boughton, husbandman 1
3944367 2005126 2005126 defendant Inglebute Edward husbandman 595778 595778 Inglebute, Edward, of Boughton, husbandman 1
3944368 2005126 2005126 defendant Wryght William husbandman 595778 595778 Wryght, William, of Boughton, husbandman 2
4023388 2033075 2033075 defendant Brampton Francis gent 595778 595778 Brampton, Francis, of Boughton, gent 2
4029584 2035218 2035218 defendant Brodstreete Edward yeoman 595778 595778 Brodstreete, Edward, of Boughton under Blene, yeoman 0
4046235 2041094 2041094 defendant Dunkyn Edward laborer 595778 595778 Dunkyn, Edward, of Boughton under Bleane,, laborer 1
4046236 2041094 2041094 defendant Watt John grocer 595778 595778 Watt, John, of Boughton under Bleane, grocer 2
4046586 2041231 2041231 defendant Ostler Edward laborer 595778 595778 Ostler, Edward, of Boughton, laborer 3
4091692 2057319 2057319 defendant Gower Jasper gent 595778 595778 Gower, Jasper, of Boughton, gent 0
4099307 2060078 2060078 defendant Curlyngton John yeoman 595778 595778 Curlyngton, John, of Boughton, yeoman 1
4106565 2062637 2062637 defendant Norton John gent 595778 595778 Norton, John, of Boughton, gent 0
4109424 2063632 2063632 defendant Harvye Martin tailor 595778 595778 Harvye, Martin, of Boughton, tailor 1
4109425 2063632 2063632 defendant Robertson Thomas husbandman 595778 595778 Robertson, Thomas, of Boughton, husbandman 2
4109426 2063632 2063632 defendant Wylkynson Thomas husbandman 595778 595778 Wylkynson, Thomas, of Boughton, husbandman 3
4171714 2085573 2085573 defendant Berrye John husbandman 595778 595778 Berrye, John, of Boughton under Bleane, husbandman 2
4223421 2103682 2103682 defendant Waterman Walter husbandman 595778 595778 Waterman, Walter, of Boughton under Bleane, husbandman 1
4223537 2103723 2103723 defendant Ovenden Mark carpenter 595778 595778 Ovenden, Mark, of Boughton under Bleane, carpenter 0
4234237 2107512 2107512 defendant Robynson alias Randall Nicholas husbandman 595778 595778 Robynson alias Randall, Nicholas, of Boughton, husbandman 0
4234238 2107512 2107512 defendant Smale Anthony gent 595778 595778 Smale, Anthony, of Boughton, gent 1
4234354 2107552 2107552 defendant Seede John gent 595778 595778 Seede, John, of Boughton, Gent, gent 1
4257046 2115331 2115331 defendant Reignold Henry yeoman 595778 595778 Reignold, Henry, of Boughton under Bleane, yeoman 0
4285491 2124859 2124859 defendant Gunceley Thomas   595778 595778 Gunceley,Thomas, of Boughton, mason 0
4290070 2126514 2126514 defendant Dunkyne Edward yeoman 595778 595778 Dunkyne, Edward, of Boughton under Bleane, yeoman 0
4316026 2135718 2135718 defendant Chillenden William tailor 595778 595778 Chillenden, William, of Boughton under Bleane, tailor 1
4324672 2138644 2138644 defendant Raynes Simon yeoman 595778 595778 Raynes, Simon, of Boughton, yeoman 1
4337114 2142705 2142705 defendant Raynes Simon yeoman 595778 595778 Raynes, Simon, of Boughton, yeoman 1
4376190 2156548 2156548 defendant Pettyt Henry gent 595778 595778 Pettyt, Henry, of Boughton under Blean, gent 1
4404524 2166081 2166081 defendant Comeleche Elias clerk 595778 595778 Comeleche, Elias, of Boughton, clerk 0
4410964 2168258 2168258 defendant Bushe William husbandman 595778 595778 Bushe, William, of Boughton, husbandman 0
4413784 2169207 2169207 defendant Bildeswath John de   595778 595778 Bildeswath, John de, of Boughton 0
4457472 2187351 2187351 plaintiff Person Henry   595778 595778 Person, Henry, of Boughton under Blean 0
4457473 2187351 2187351 defendant Sparowe John   595778 595778 Sparowe, John, of Boughton under Blean 0
4457474 2187352 2187352 plaintiff Person Henry   595778 595778 Person, Henry, of Boughton under Blee, on his own account 0
4463200 2189186 2189186 defendant Person Henry   595778 595778 Person, Henry, of Boughton under Blean 0
4468922 2190957 2190957 defendant Colhode Thomas   595778 595778 Colhode, Thomas, of Boughton under Blean 0
4468923 2190957 2190957 defendant Tabbard Thomas   595778 595778 Tabbard, Thomas, of Boughton under Blean 1
4534869 2211188 2211188 plaintiff Seymour Isabel   595778 595778 Seymour, Isabel, of Boughton, formerly wife of Nicholas 0
4534871 2211189 2211189 plaintiff Seymour Isabel   595778 595778 Seymour, Isabel, of Boughton, formerly wife of Nicholas 0
4543191 2213755 2213755 defendant Mathewe William   595778 595778 Mathewe, William, of Boughton 2
4569558 2222063 2222063 defendant Taillour John   595778 595778 Taillour, John, of Boughton 4
4635850 2242053 2242053 defendant Ricard John   595778 595778 Ricard, John, of Boughton under Blean 1
4635851 2242053 2242053 defendant atte Thorne Philip   595778 595778 atte Thorne, Philip, of Boughton under Blean 2
4701068 2265740 2265740 defendant Swayn John husbandman 595778 595778 Swayn, John, of Boughton, husbandman 0
4711858 2269039 2269039 defendant Charlys Robert   595778 595778 Charlys, Robert, of Boughton under Blean 2
4711859 2269039 2269039 defendant Grubbe William yeoman 595778 595778 Grubbe, William, of Boughton under Blean, yeoman 3
4728868 2274266 2274266 defendant Dane Simon yeoman 595778 595778 Dane, Simon, of Boughton, yeoman 0
4729469 2274428 2274428 defendant Sharp John husbandman 595778 595778 Sharp, John, of Boughton under Blean, husbandman 2
4736683 2276601 2276601 defendant Taillour Robert husbandman 595778 595778 Taillour, Robert, of Boughton, husbandman 5
4765898 2285330 2285330 defendant Walssh John farmer 595778 595778 Walssh, John, of Boughton, farmer 1
4765899 2285330 2285330 defendant Rolf Stephen laborer 595778 595778 Rolf, Stephen, of Boughton, laborer 2
4822194 2303021 2303021 defendant Gregge Richard husbandman 595778 595778 Gregge, Richard, of Boughton, husbandman 1
4836342 2307342 2307342 defendant Talke Richard yeoman 595778 595778 Talke, Richard, of Boughton, yeoman 0
4856464 2313403 2313403 defendant Tusteyn Robert husbandman 595778 595778 Tusteyn, Robert, of Boughton, husbandman 0
4908653 2329262 2329262 defendant Bole Robert laborer 595778 595778 Bole, Robert, of Boughton under Blean, laborer 0
4911880 2330219 2330219 defendant Ouen John laborer 595778 595778 Ouen, John, of Boughton under Blean, laborer 0
4915703 2331410 2331410 defendant Sare Robert husbandman 595778 595778 Sare, Robert, of Boughton under Blean, husbandman 1
4925689 2334468 2334468 defendant Childrons Stephen husbandman 595778 595778 Childrons, Stephen, of Boughton, husbandman 0
4933323 2336813 2336813 defendant atte Welle Thomas, junior laborer 595778 595778 atte Welle, Thomas, junior, of Boughton under Blean, laborer 0
4950815 2342229 2342229 defendant Masselend Richard husbandman 595778 595778 Masselend, Richard, of Boughton, 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);