names

86 rows where place_id = 592530

✎ 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
3607982 1870148 1870148 defendant Kymbyll Robert husbandman 592530 592530 Kymbyll, Robert, of Thurleston, husbandman 1
3632350 1904940 1904940 defendant Ball Adam husbandman 592530 592530 Ball, Adam, of Thurleston, husbandman 1
3648307 1909871 1909871 defendant Marler Robert husbandman 592530 592530 Marler, Robert, of Thurleston, husbandman 0
3650124 1910408 1910408 defendant Foxon Robert husbandman 592530 592530 Foxon, Robert, of Thurleston, husbandman 1
3729767 1935565 1935565 defendant Melcham James husbandman 592530 592530 Melcham, James, of Thurleston, husbandman 1
3735783 1937430 1937430 defendant Hygson William yeoman 592530 592530 Hygson, William, of Thurleston, yeoman 2
3762758 1945991 1945991 defendant Swetale John husbandman 592530 592530 Swetale, John, of Thurleston, husbandman 1
3795600 1956508 1956508 defendant Hatch Nicholas husbandman 592530 592530 Hatch, Nicholas, of Thurleston, husbandman 1
3854881 1975171 1975171 defendant Grosse John husbandman 592530 592530 Grosse, John, of Thurleston, husbandman 0
3854882 1975171 1975171 defendant Walwyn William husbandman 592530 592530 Walwyn, William, of Thurleston, husbandman 1
3987708 2020353 2020353 defendant Burghan William yeoman 592530 592530 Burghan, William, of Thurleston, yeoman 0
4031664 2035989 2035989 defendant Clerke Peter husbandman 592530 592530 Clerke, Peter, of Thurleston, husbandman 0
4061123 2046387 2046387 defendant Drewe John husbandman 592530 592530 Drewe, John, of Thurleston, husbandman 1
4214088 2100445 2100445 defendant Haigh alias Marsden John yeoman 592530 592530 Haigh alias Marsden, John, of Thurleston, yeoman 2
4214089 2100445 2100445 defendant Haigh alias Marsden Ralph yeoman 592530 592530 Haigh alias Marsden, Ralph, of Thurleston, yeoman 3
4215353 2100867 2100867 defendant Hage Ralph husbandman 592530 592530 Hage, Ralph, of Thurleston, husbandman 2
4263686 2117515 2117515 defendant Haigh alias Marsden John yeoman 592530 592530 Haigh alias Marsden, John, of Thurleston, yeoman 2
4263687 2117515 2117515 defendant Haigh alias Marsden Ralph yeoman 592530 592530 Haigh alias Marsden, Ralph, of Thurleston, yeoman 3
4264976 2117921 2117921 defendant Hage Ralph husbandman 592530 592530 Hage, Ralph, of Thurleston, husbandman 2
4323813 2138376 2138376 defendant Grove Benedict gent 592530 592530 Grove, Benedict, of Thurleston, gent 0
4326594 2139254 2139254 defendant Grove Benedict gent 592530 592530 Grove, Benedict, of Thurleston, gent 0
4429640 2174064 2174064 plaintiff Waryn John   592530 592530 Waryn, John, of thurleston 0
4443681 2182991 2182991 defendant Whitelegh John   592530 592530 Whitelegh, John, of Thurleston, parson 2
4499162 2200383 2200383 defendant Spicer Robert   592530 592530 Spicer, Robert, of Thurleston 0
4504737 2202022 2202022 defendant Huchecokeson John   592530 592530 Huchecokeson, John, of Thurleston 0
4532623 2210470 2210470 defendant Frenshe John   592530 592530 Frenshe, John, of Thurleston 0
4587289 2227432 2227432 defendant Scot John   592530 592530 Scot, John, of Thurleston 0
4615870 2235956 2235956 defendant Roberd Richard   592530 592530 Roberd, Richard, of Thurleston 0
4673917 2257459 2257459 defendant Weylond Robert husbandman 592530 592530 Weylond, Robert, of Thurleston, husbandman 1
4683026 2260304 2260304 defendant Scot John yeoman 592530 592530 Scot, John, of Thurleston, yeoman 3
4712914 2269351 2269351 plaintiff Spycer Robert   592530 592530 Spycer, Robert, of Thurleston 0
4721342 2272006 2272006 defendant Somayster William   592530 592530 Somayster, William, of Thurleston, parson & clerk 0
4737412 2276816 2276816 defendant Prideaux William farmer 592530 592530 Prideaux, William, of Thurleston, farmer 3
4764220 2284802 2284802 defendant Derset William gent 592530 592530 Derset, William, of Thurleston, gent 2
4793621 2294116 2294116 defendant del Rodes John husbandman 592530 592530 del Rodes, John, of Thurleston, husbandman 2
4825633 2304055 2304055 defendant Bugge Baldewyne esq 592530 592530 with Bugge, Baldewyne, of Thurleston, esq 6
4832029 2306050 2306050 defendant Hillyng Robert husbandman 592530 592530 Hillyng, Robert, of Thurleston, husbandman 0
4832030 2306050 2306050 defendant atte wode John husbandman 592530 592530 atte wode, John, of Thurleston, husbandman 1
4832031 2306050 2306050 defendant Sture Walter husbandman 592530 592530 Sture, Walter, of Thurleston, husbandman 2
4832033 2306050 2306050 defendant Thordene Mathew yeoman 592530 592530 Thordene, Mathew, of Thurleston, yeoman 4
4840877 2308683 2308683 defendant Jankynson Thomas husbandman 592530 592530 Jankynson, Thomas, of Thurleston, husbandman 0
4843227 2309402 2309402 defendant Hunt Henry   592530 592530 Hunt, Henry, of Thurleston, bailiff 3
4848010 2310852 2310852 defendant Walton William butcher 592530 592530 Walton, William, of Thurleston, butcher 1
4848011 2310852 2310852 defendant Walton John tailor 592530 592530 Walton, John, of Thurleston, tailor 2
4848012 2310852 2310852 defendant Morehous William   592530 592530 Morehous, William, of Thurleston 3
4848025 2310852 2310852 defendant Riche John   592530 592530 Riche, John, of Thurleston 16
4870763 2317835 2317835 plaintiff Marchant William   592530 592530 Marchant, William, of Thurleston 0
4874655 2319016 2319016 defendant Parkynson John husbandman 592530 592530 Parkynson, John, of Thurleston, husbandman 1
4881992 2321267 2321267 defendant Assheman Robert husbandman 592530 592530 Assheman, Robert, of Thurleston, husbandman 0
4885971 2322477 2322477 defendant Ryche William, senior husbandman 592530 592530 Ryche, William, senior, of Thurleston, husbandman 0
4930791 2336035 2336035 defendant Wordelworth John husbandman 592530 592530 Wordelworth, John, of Thurleston, husbandman 6
4930792 2336035 2336035 defendant Ryche William, senior   592530 592530 Ryche, William, senior, of Thurleston 7
4930793 2336035 2336035 defendant Riche William, junior   592530 592530 Riche, William, junior, of Thurleston 8
4930794 2336035 2336035 defendant Rycher John, junior laborer 592530 592530 Rycher, John, junior, of Thurleston, laborer 9
4963019 2345848 2345848 defendant Dekyn John husbandman 592530 592530 Dekyn, John, of Thurleston, husbandman 1
4993430 2354903 2354903 defendant Dekyn John husbandman 592530 592530 Dekyn, John, of Thurleston, husbandman 2
4997396 2356071 2356071 defendant Weylond Robert carter 592530 592530 Weylond, Robert, of Thurleston, carter 1
5001155 2357216 2357216 defendant Morys John skinner 592530 592530 Morys, John, of Thurleston, skinner 0
5043493 2369675 2369675 defendant Franke John chaplain 592530 592530 Franke, John, of Thurleston, chaplain 4
5054099 2372820 2372820 defendant Trewe Mathew laborer 592530 592530 Trewe, Mathew, of Thurleston, laborer 2
5174707 2408303 2408303 defendant Burlegh John (legal representative) 592530 592530 Burlegh, John, of Thurleston, executrix of 0
5247135 2429318 2429318 defendant Corbrand John husbandman 592530 592530 Corbrand, John, of Thurleston, husbandman 0
5247140 2429320 2429320 defendant Corbrond John husbandman 592530 592530 Corbrond, John, of Thurleston, husbandman 0
5253920 2431341 2431341 plaintiff Roberdes Thomas   592530 592530 Roberdes, Thomas, of Thurleston 1
5275423 2437880 2437880 defendant Burnard Richard husbandman 592530 592530 Burnard, Richard, of Thurleston, husbandman 0
5275424 2437880 2437880 defendant Bendon Peter tailor 592530 592530 Bendon, Peter, of Thurleston, tailor 1
5288575 2441678 2441678 defendant Stafford Richard yeoman 592530 592530 Stafford, Richard, of Thurleston, yeoman 0
5307580 2447281 2447281 defendant Dundervyle John yeoman 592530 592530 Dundervyle, John, of Thurleston, yeoman 2
5307582 2447281 2447281 defendant Brendon Peter yeoman 592530 592530 Brendon, Peter, of Thurleston, yeoman 4
5333064 2454959 2454959 defendant Burlegh John gent 592530 592530 Burlegh, John, of Thurleston, gent 0
5487348 2501113 2501113 defendant Turton George yeoman 592530 592530 Turton, George, of Thurleston, yeoman 2
5501190 2505311 2505311 defendant Whale Thomas husbandman 592530 592530 Whale, Thomas, of Thurleston, husbandman 0
5538396 2516492 2516492 defendant Clement John husbandman 592530 592530 Clement, John, of Thurleston, husbandman 0
5538398 2516492 2516492 defendant Priour Roger husbandman 592530 592530 Priour, Roger, of Thurleston, husbandman 2
5538399 2516492 2516492 defendant Lyston Ralph husbandman 592530 592530 Lyston, Ralph, of Thurleston, husbandman 3
5538400 2516492 2516492 defendant Lyston John husbandman 592530 592530 Lyston, John, of Thurleston, husbandman 4
5538401 2516492 2516492 defendant Pyldyssh John husbandman 592530 592530 Pyldyssh, John, of Thurleston, husbandman 5
5538402 2516492 2516492 defendant Falaues Humphrey husbandman 592530 592530 Falaues, Humphrey, of Thurleston, husbandman 6
5538403 2516492 2516492 defendant Wodemeston Richard husbandman 592530 592530 Wodemeston, Richard, of Thurleston, husbandman 7
5586695 2530877 2530877 defendant Barnacle Thomas husbandman 592530 592530 Barnacle, Thomas, of Thurleston, husbandman 1
5600612 2535083 2535083 defendant Mokson Margaret widow 592530 592530 Mokson, Margaret, of Thurleston, widow 0
5600613 2535083 2535083 defendant Mokson Lawrence husbandman 592530 592530 Mokson, Lawrence, of Thurleston, husbandman 1
5625722 2551988 2551988 defendant Wynyeve William husbandman 592530 592530 Wynyeve, William, of Thurleston, husbandman 0
5627065 2552433 2552433 defendant Lete John smith 592530 592530 Lete, John, of Thurleston, smith 2
5629184 2553104 2553104 plaintiff Pynton Martin   592530 592530 Pynton, Martin, of Thurleston 0
5634053 2554633 2554633 defendant Prydeaux William gent 592530 592530 Prydeaux, William, of Thurleston, gent 0

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