names

52 rows where place_id = 587040

✎ 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
3590322 1864616 1864616 defendant Mountford Simon yeoman 587040 587040 Mountford, Simon, of Witney, yeoman 0
3590325 1864616 1864616 defendant Brache John husbandman 587040 587040 Brache, John, of Witney, husbandman 3
3639447 1907145 1907145 plaintiff Wenman Richard gent 587040 587040 Wenman, Richard, of Witney, gent 0
3805315 1959609 1959609 defendant Jiggys John yeoman 587040 587040 Jiggys, John, of Witney, yeoman 0
4115770 2065922 2065922 defendant Yate leonard clothier 587040 587040 Yate, leonard, of Witney, clothier 0
4399653 2164475 2164475 defendant Bishopp alias Marten John yeoman 587040 587040 Bishopp alias Marten, John, of Witney, yeoman 2
4412755 2168860 2168860 defendant Bucknoll Edward clothier 587040 587040 Bucknoll, Edward, of Witney, clothier 1
4520311 2206697 2206697 defendant Webbe Peter   587040 587040 Webbe, Peter, of Witney 0
4523378 2207632 2207632 defendant Ravenser William   587040 587040 Ravenser, William, of Witney 0
4691807 2262970 2262970 defendant Bailly Sibyl widow 587040 587040 Bailly, Sibyl, of Witney, widow 1
4707453 2267708 2267708 defendant White Robert   587040 587040 White, Robert, of Witney, knight 0
4758178 2282931 2282931 defendant Cordewaner Geoffrey   587040 587040 Cordewaner, Geoffrey, of Witney, shoe maker 0
4760058 2283484 2283484 defendant Buntyng Thomas   587040 587040 Buntyng, Thomas, of Witney, wool man 0
4767380 2285784 2285784 defendant Radeford John tanner 587040 587040 Radeford, John, of Witney, tanner 0
4767792 2285899 2285899 defendant Underwall Richard husbandman 587040 587040 Underwall, Richard, of Witney, husbandman 1
4768619 2286164 2286164 defendant Buntyng Thomas   587040 587040 Buntyng, Thomas, of Witney, wool man 0
4770179 2286644 2286644 defendant Shyfforde William butcher 587040 587040 Shyfforde, William, of Witney, butcher 0
4830105 2305458 2305458 defendant Pynchpole Thomas yeoman 587040 587040 Pynchpole, Thomas, of Witney, yeoman 1
4834849 2306903 2306903 defendant Glasyngby John chaplain 587040 587040 Glasyngby, John, of Witney, chaplain 0
4834850 2306904 2306904 plaintiff Cusson Thomas   587040 587040 Cusson, Thomas, of Witney, vicar 0
4834851 2306904 2306904 defendant Catryk Robert   587040 587040 Catryk, Robert, of Witney, parson 0
4837827 2307763 2307763 defendant Temple John yeoman 587040 587040 Temple, John, of Witney, yeoman 0
4837828 2307763 2307763 defendant Hikkes John dyer 587040 587040 Hikkes, John, of Witney, dyer 1
4839361 2308233 2308233 defendant Catryk Robert clerk 587040 587040 Catryk, Robert, of Witney, clerk 0
4839362 2308233 2308233 defendant Gayte William   587040 587040 Gayte, William, of Witney, wool man 1
4841054 2308738 2308738 defendant Martyn John husbandman 587040 587040 Martyn, John, of Witney, husbandman 0
4923246 2333692 2333692 defendant Maddeley William yeoman 587040 587040 Maddeley, William, of Witney, yeoman 0
4960590 2345134 2345134 defendant Warner Edmund tailor 587040 587040 Warner, Edmund, of Witney, tailor 1
5008435 2359357 2359357 defendant Radford Henry tanner 587040 587040 Radford, Henry, of Witney, tanner 0
5243842 2428392 2428392 defendant Wilston John chapman 587040 587040 Wilston, John, of Witney, chapman 0
5243843 2428392 2428392 defendant Box Robert fuller 587040 587040 Box, Robert, of Witney, fuller 1
5337197 2456196 2456196 defendant Tryst John tanner 587040 587040 Tryst, John, of Witney, tanner 1
5367023 2465333 2465333 defendant Dyer Thomas dyer 587040 587040 Dyer, Thomas, of Witney, dyer 0
5372910 2467121 2467121 defendant Spereman John weaver 587040 587040 Spereman, John, of Witney, weaver 0
5372911 2467121 2467121 defendant Alesop Richard baker 587040 587040 Alesop, Richard, of Witney, baker 1
5372912 2467121 2467121 defendant Bycher Robert yeoman 587040 587040 Bycher, Robert, of Witney, yeoman 2
5372914 2467121 2467121 defendant Fuste Thomas yeoman 587040 587040 Fuste, Thomas, of Witney, yeoman 4
5372915 2467121 2467121 defendant Sanaye or Savaye John sklatter or slater 587040 587040 Sanaye or Savaye, John, of Witney, sklatter or slater 5
5372916 2467121 2467121 defendant Peynter William barber 587040 587040 Peynter, William, of Witney, barber 6
5372917 2467121 2467121 defendant Tailor Henry yeoman 587040 587040 Tailor, Henry, of Witney, yeoman 7
5372918 2467121 2467121 defendant Chyne John weaver 587040 587040 Chyne, John, of Witney, weaver 8
5372926 2467122 2467122 defendant Ruste Thomas yeoman 587040 587040 Ruste, Thomas, of Witney, yeoman 6
5401168 2475396 2475396 defendant Gilson Henry   587040 587040 Gilson, Henry, of Witney 2
5407517 2477221 2477221 defendant Baumyng Robert yeoman 587040 587040 Baumyng, Robert, of Witney, yeoman 1
5412930 2478813 2478813 defendant Fourde Richard chapman 587040 587040 Fourde, Richard, of Witney, chapman 1
5412931 2478813 2478813 defendant Hosyer Edward chapman 587040 587040 Hosyer, Edward, of Witney, chapman 2
5424455 2482285 2482285 defendant Cokkes John dyer 587040 587040 Cokkes, John, of Witney, dyer 0
5429989 2483909 2483909 plaintiff Gyllon Thomas   587040 587040 Gyllon, Thomas, of Witney, bailiff 1
5429990 2483909 2483909 defendant Hosiar Edward chapman 587040 587040 Hosiar, Edward, of Witney, chapman 0
5429991 2483909 2483909 defendant Derby John yeoman 587040 587040 Derby, John, of Witney, yeoman 1
5493204 2502876 2502876 defendant Cokkes John dyer 587040 587040 Cokkes, John, of Witney, dyer 5
5493211 2502877 2502877 defendant Cokkes John dyer 587040 587040 Cokkes, John, of Witney, dyer 5

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