names

133 rows where place_id = 615541

✎ 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
3709408 1929242 1929242 defendant Cade Thomas husbandman 615541 615541 Cade, Thomas, of Geyton, husbandman 1
3712870 1930344 1930344 plaintiff Worme John clerk 615541 615541 Worme, John, of Geyton, clerk 0
3754453 1943351 1943351 plaintiff Thursby Thomas esq 615541 615541 Thursby, Thomas, of Geyton, esq 0
3813125 1962017 1962017 defendant Palmer John husbandman 615541 615541 Palmer, John, of Geyton, husbandman 0
3838738 1970044 1970044 defendant Badeley Thomas yeoman 615541 615541 Badeley, Thomas, of Geyton, yeoman 2
3840696 1970655 1970655 defendant Badeley Thomas yeoman 615541 615541 Badeley, Thomas, of geyton, yeoman 0
3988517 2020637 2020637 defendant Clytheroo Thomas yeoman 615541 615541 Clytheroo, Thomas, of Geyton, yeoman 0
3998949 2024383 2024383 plaintiff Fourde Thomas   615541 615541 Fourde, Thomas, of Geyton 0
4011382 2028846 2028846 defendant Constable Luke yeoman 615541 615541 (Constable, Luke, of Geyton, yeoman 1
4058759 2045525 2045525 defendant Leke John carpenter 615541 615541 Leke, John, of Geyton, carpenter 2
4081359 2053639 2053639 defendant Kempe Thomas husbandman 615541 615541 Kempe, Thomas, of Geyton, husbandman 2
4149093 2077806 2077806 defendant Kay Roger yeoman 615541 615541 Kay, Roger, of Geyton, yeoman 0
4171766 2085584 2085584 defendant Melton Richard husbandman 615541 615541 Melton, Richard, of Geyton, husbandman 0
4171767 2085584 2085584 defendant Berige Thomas husbandman 615541 615541 Berige, Thomas, of Geyton, husbandman 1
4194868 2093768 2093768 defendant Melton Richard husbandman 615541 615541 Melton, Richard, of Geyton, husbandman 0
4194869 2093768 2093768 defendant Berige Thomas husbandman 615541 615541 Berige, Thomas, of Geyton, husbandman 1
4226705 2104812 2104812 defendant Starre John husbandman 615541 615541 Starre, John, of Geyton, husbandman 0
4234958 2107778 2107778 defendant Goodwyn Ralph yeoman 615541 615541 Goodwyn, Ralph, of Geyton, yeoman 0
4257878 2115608 2115608 defendant Grey Rowland husbandman 615541 615541 Grey, Rowland, of Geyton, husbandman 0
4257879 2115608 2115608 defendant Teatt Robert husbandman 615541 615541 Teatt, Robert, of Geyton, husbandman 1
4257880 2115608 2115608 defendant Armyshead Roger husbandman 615541 615541 Armyshead, Roger, of Geyton, husbandman 2
4278581 2122443 2122443 defendant Watson John husbandman 615541 615541 Watson, John, of Geyton, husbandman 3
4285311 2124797 2124797 defendant Chapmam William husbandman 615541 615541 Chapmam William, of Geyton, husbandman 0
4285312 2124797 2124797 defendant Sewell Richard husbandman 615541 615541 Sewell, Richard, of Geyton, husbandman 1
4285313 2124797 2124797 defendant Melton Richard husbandman 615541 615541 together with Melton, Richard, of Geyton, husbandman 2
4286453 2125195 2125195 defendant Justyn Thomas husbandman 615541 615541 Justyn, Thomas, of Geyton, husbandman 0
4316665 2135946 2135946 defendant Melton Richard yeoman 615541 615541 Melton, Richard, of Geyton, yeoman 0
4333386 2141449 2141449 defendant Decon William husbandman 615541 615541 Decon, William, of Geyton, husbandman 0
4333388 2141449 2141449 defendant Geyton Thomas laborer 615541 615541 Geyton, Thomas, of Geyton, laborer 2
4344208 2145253 2145253 defendant Teate Robert husbandman 615541 615541 Teate, Robert, of Geyton, husbandman 1
4348566 2146750 2146750 defendant Dallyson Richard yeoman 615541 615541 Dallyson, Richard, of Geyton, yeoman 3
4369577 2154177 2154177 defendant Starre John husbandman 615541 615541 Starre, John, of Geyton, husbandman 0
4387808 2160559 2160559 defendant Galte Stephen laborer 615541 615541 Galte, Stephen, of Geyton, laborer 0
4387809 2160559 2160559 defendant Dallyson Richard   615541 615541 Dallyson, Richard, of Geyton, shepherd 1
4387810 2160559 2160559 defendant Crosse Henry   615541 615541 Crosse, Henry, of Geyton, shepherd 2
4388350 2160736 2160736 defendant Grey Rowland yeoman 615541 615541 Grey, Rowland, of Geyton, yeoman 0
4388351 2160736 2160736 defendant Tompson Thomas yeoman 615541 615541 Tompson, Thomas, of Geyton, yeoman 1
4388898 2160917 2160917 defendant Melton Richard husbandman 615541 615541 Melton, Richard, of Geyton, husbandman 0
4389904 2161248 2161248 defendant Asburye William yeoman 615541 615541 Asburye, William, of Geyton, yeoman 0
4389906 2161249 2161249 defendant Cowdale Thomas, junior yeoman 615541 615541 Cowdale, Thomas, junior, of Geyton, yeoman 0
4395980 2163232 2163232 defendant Moore Hugh husbandman 615541 615541 Moore, Hugh, of Geyton, husbandman 0
4406518 2166744 2166744 defendant Wallington Sampson husbandman 615541 615541 Wallington, Sampson, of Geyton, husbandman 1
4406519 2166744 2166744 defendant Heringe Thomas husbandman 615541 615541 Heringe, Thomas, of Geyton, husbandman 2
4410272 2168034 2168034 defendant Chapman Edward yeoman 615541 615541 Chapman, Edward, of Geyton, yeoman 1
4452614 2185820 2185820 defendant Lonedons Robert (legal representative) 615541 615541 Lonedons, Robert, of Geyton, executors of 0
4452616 2185820 2185820 defendant Lonedones John chaplain 615541 615541 Lonedones, John, of Geyton, chaplain 2
4476520 2193321 2193321 defendant Bloumvylle John   615541 615541 Bloumvylle, John, of Geyton 0
4490550 2197739 2197739 defendant Hyve Ralph   615541 615541 Hyve, Ralph, of Geyton 0
4519397 2206425 2206425 defendant Baid John   615541 615541 Baid, John, of Geyton, parson 0
4519398 2206425 2206425 defendant North John   615541 615541 North, John, of Geyton 1
4520386 2206720 2206720 plaintiff Fisshere William   615541 615541 Fisshere, William, of Geyton 0
4521293 2207004 2207004 plaintiff Fysshere William   615541 615541 Fysshere, William, of Geyton 0
4543520 2213862 2213862 defendant Nottyng William   615541 615541 Nottyng, William, of Geyton 0
4560755 2219316 2219316 defendant atte Mersshe Peter   615541 615541 atte Mersshe, Peter, of Geyton 0
4623094 2238200 2238200 defendant Beteryng William   615541 615541 Beteryng, William, of Geyton 2
4644266 2244415 2244415 defendant Merssh John   615541 615541 Merssh, John, of Geyton 0
4644272 2244415 2244415 defendant Spyndelere Thomas   615541 615541 Spyndelere, Thomas, of Geyton 6
4645318 2244702 2244702 defendant Holt John   615541 615541 Holt, John, of Geyton 0
4677016 2258430 2258430 defendant Mersshe John husbandman 615541 615541 Mersshe, John, of Geyton, husbandman 3
4678066 2258749 2258749 defendant Mottynges William, senior husbandman 615541 615541 Mottynges, William, senior, of Geyton, husbandman 3
4753331 2281419 2281419 defendant atte Merssh John husbandman 615541 615541 atte Merssh, John, of Geyton, husbandman 0
4753332 2281419 2281419 defendant atte Merssh Peter husbandman 615541 615541 atte Merssh, Peter, of Geyton, husbandman 1
4753333 2281419 2281419 defendant atte Merssh Adam husbandman 615541 615541 atte Merssh, Adam, of Geyton, husbandman 2
4753334 2281419 2281419 defendant Seper William husbandman 615541 615541 Seper, William, of Geyton, husbandman 3
4753335 2281419 2281419 defendant Tabbard William smith 615541 615541 Tabbard, William, of Geyton, smith 4
4753336 2281419 2281419 defendant Lynne John smith 615541 615541 Lynne, John, of Geyton, smith 5
4774597 2288041 2288041 defendant Idone William husbandman 615541 615541 Idone, William, of Geyton, husbandman 2
4802351 2296927 2296927 defendant Clerk Thomas husbandman 615541 615541 Clerk, Thomas, of Geyton, husbandman 2
4802352 2296927 2296927 defendant Perot William husbandman 615541 615541 Perot, William, of Geyton, husbandman 3
4817154 2301457 2301457 defendant Pyrt Ralph clerk 615541 615541 Pyrt, Ralph, of Geyton, clerk 0
4850513 2311621 2311621 defendant Webster William husbandman 615541 615541 Webster, William, of Geyton, husbandman 0
4911165 2330002 2330002 defendant Scot Robert (legal representative) 615541 615541 Scot, Robert, of Geyton, executrix of 0
4928219 2335254 2335254 defendant Knyght Robert   615541 615541 Knyght, Robert, of Geyton, shepherd 3
4933781 2336944 2336944 defendant Dunnesby Robert husbandman 615541 615541 Dunnesby, Robert, of Geyton, husbandman 1
4938815 2338531 2338531 defendant Lynne John husbandman 615541 615541 Lynne, John, of Geyton, husbandman 0
4959787 2344891 2344891 defendant Hypgame Thomas husbandman 615541 615541 Hypgame, Thomas, of Geyton, husbandman 0
4989758 2353854 2353854 plaintiff Sampson Thomas   615541 615541 Sampson, Thomas, of Geyton 1
5003478 2357914 2357914 defendant Gay William husbandman 615541 615541 Gay, William, of Geyton, husbandman 0
5011051 2360087 2360087 defendant Dolman John husbandman 615541 615541 Dolman, John, of Geyton, husbandman 3
5038826 2368256 2368256 defendant Hypgame Thomas husbandman 615541 615541 Hypgame, Thomas, of Geyton, husbandman 0
5052379 2372309 2372309 defendant atte Merssh Thomas husbandman 615541 615541 atte Merssh, Thomas, of Geyton, husbandman 1
5052988 2372489 2372489 defendant Hipgame Thomas husbandman 615541 615541 Hipgame, Thomas, of Geyton, husbandman 0
5102004 2387009 2387009 defendant More John yeoman 615541 615541 More, John, of Geyton, yeoman 2
5102005 2387009 2387009 defendant Knowete Thomas yeoman 615541 615541 Knowete, Thomas, of Geyton, yeoman 3
5125814 2394035 2394035 defendant Patemen John yeoman 615541 615541 Patemen, John, of Geyton, yeoman 2
5125815 2394035 2394035 defendant Tyll John weaver 615541 615541 Tyll, John, of Geyton, weaver 3
5146152 2399999 2399999 defendant Tyll John weaver 615541 615541 Tyll, John, of Geyton, weaver 4
5152896 2401988 2401988 plaintiff Hood John husbandman 615541 615541 Hood, John, of Geyton, husbandman 0
5153676 2402232 2402232 defendant Welle Richard husbandman 615541 615541 Welle, Richard, of Geyton, husbandman 0
5157851 2403422 2403422 defendant Welle Richard husbandman 615541 615541 Welle, Richard, of Geyton, husbandman 1
5160738 2404239 2404239 defendant Knowte Peter clerk & vicar 615541 615541 Knowte, Peter, of Geyton, clerk & vicar 0
5160740 2404239 2404239 defendant Nottyng Robert husbandman 615541 615541 Nottyng, Robert, of Geyton, husbandman 2
5162876 2404862 2404862 defendant Welle Richard husbandman 615541 615541 Welle, Richard, of Geyton, husbandman 0
5162877 2404862 2404862 defendant Hood John husbandman 615541 615541 Hood, John, of Geyton, husbandman 1
5168727 2406578 2406578 defendant Maudelyn Thomas yeoman 615541 615541 Maudelyn, Thomas, of Geyton, yeoman 0
5173604 2407981 2407981 defendant Welle Richard husbandman 615541 615541 Welle, Richard, of Geyton, husbandman 1
5176761 2408888 2408888 defendant Welle Richard husbandman 615541 615541 Welle, Richard, of Geyton, husbandman 0
5176762 2408888 2408888 defendant Hood Robert husbandman 615541 615541 Hood, Robert, of Geyton, husbandman 1
5193675 2413879 2413879 defendant Welle Richard husbandman 615541 615541 Welle, Richard, of Geyton, husbandman 1
5203685 2416829 2416829 defendant Clerk Edmund husbandman 615541 615541 Clerk, Edmund, of Geyton, husbandman 3

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