names

73 rows where place_id = 590340

✎ 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
3600709 1867875 1867875 defendant Clerk Thomas husbandman 590340 590340 Clerk, Thomas, of Wetherden, husbandman 0
3610411 1870915 1870915 defendant Crouche William gent 590340 590340 Crouche, William, of Wetherden, gent 0
3629723 1904148 1904148 defendant Westbrome Geoffrey husbandman 590340 590340 Westbrome, Geoffrey, of Wetherden, husbandman 0
3703566 1927391 1927391 defendant Awston John glover 590340 590340 Awston, John, of Wetherden, glover 0
3724615 1933981 1933981 defendant Fuller Simon husbandman 590340 590340 Fuller, Simon, of Wetherden, husbandman 0
3738426 1938226 1938226 plaintiff More John husbandman 590340 590340 More, John, of Wetherden, or of Harleston, husbandman 0
3814360 1962404 1962404 defendant Wyndowe Thomas chaplain 590340 590340 Wyndowe, Thomas, of Wetherden, chaplain 0
3815110 1962645 1962645 defendant Punder John laborer 590340 590340 Punder, John, of Wetherden, laborer 1
3838922 1970099 1970099 defendant Sulyard Andrew esq 590340 590340 Sulyard, Andrew, of Wetherden, esq 0
3841468 1970911 1970911 plaintiff Berte Thomas tanner 590340 590340 Berte, Thomas, of Wetherden, tanner 0
3908014 1992973 1992973 defendant Hamon John tanner 590340 590340 Hamon, John, of Wetherden, tanner 0
3947089 2006047 2006047 defendant Rosyer Robert tanner 590340 590340 Rosyer, Robert, of Wetherden, tanner 0
3947090 2006047 2006047 defendant Unger Thomas clothier 590340 590340 Unger, Thomas, of Wetherden, clothier 1
3960502 2010773 2010773 plaintiff Sulyard John   590340 590340 Sulyard, John, of Wetherden, knight 0
3967723 2013345 2013345 defendant Marshall Cuthbert yeoman 590340 590340 Marshall, Cuthbert, of Wetherden, yeoman 1
3969041 2013788 2013788 defendant Marchaunt Cuthbert husbandman 590340 590340 Marchaunt, Cuthbert, of Wetherden, husbandman 2
3983578 2018895 2018895 defendant Mark Robert yeoman 590340 590340 Mark, Robert, of Wetherden, yeoman 0
3996250 2023408 2023408 defendant Bumsted Isaac laborer 590340 590340 Bumsted, Isaac, of Wetherden, laborer 0
3996251 2023408 2023408 defendant Wood John laborer 590340 590340 Wood, John, of Wetherden, laborer 1
3996253 2023409 2023409 defendant Sulyard John   590340 590340 Sulyard, John, of Wetherden, knight 0
3996254 2023409 2023409 defendant Sulyard Edward esq 590340 590340 Sulyard, Edward, of Wetherden, esq 1
3996255 2023409 2023409 defendant Hill John yeoman 590340 590340 Hill, John, of Wetherden, yeoman 2
4015414 2030207 2030207 defendant Harvy Robert butcher 590340 590340 Harvy, Robert, of Wetherden, butcher 0
4029492 2035183 2035183 defendant Bumsted Isaac laborer 590340 590340 Bumsted, Isaac, of Wetherden, laborer 0
4029493 2035183 2035183 defendant Wood John laborer 590340 590340 Wood, John, of Wetherden, laborer 1
4052356 2043263 2043263 defendant Harvy Robert yeoman 590340 590340 Harvy, Robert, of Wetherden, yeoman 1
4052359 2043264 2043264 defendant Harvye Robert yeoman 590340 590340 Harvye, Robert, of Wetherden, yeoman 1
4063565 2047257 2047257 defendant Muskett Henry gent 590340 590340 Muskett, Henry, of Wetherden, gent 0
4078668 2052666 2052666 defendant Westley Robert clerk 590340 590340 Westley, Robert, of Wetherden, clerk 3
4087402 2055786 2055786 defendant Hatche William weaver 590340 590340 Hatche, William, of Wetherden, weaver 2
4102801 2061302 2061302 defendant Haywarde Roger husbandman 590340 590340 Haywarde, Roger, of Wetherden, husbandman 0
4138207 2074034 2074034 defendant Rosier Nicholas tanner 590340 590340 Rosier, Nicholas, of Wetherden, tanner 0
4168179 2084355 2084355 defendant Harvy Robert yeoman 590340 590340 Harvy, Robert, of Wetherden, yeoman 1
4176828 2087365 2087365 defendant Stokes Roger yeoman 590340 590340 Stokes Roger, of Wetherden, yeoman, executors of 0
4221146 2102893 2102893 defendant Bulwer John gent 590340 590340 Bulwer, John, of Wetherden, gent 0
4233703 2107311 2107311 defendant Maye Robert tanner 590340 590340 Maye, Robert, of Wetherden, tanner 0
4242215 2110390 2110390 defendant Elye William tanner 590340 590340 Elye, William, of Wetherden, tanner 0
4244799 2111249 2111249 defendant Bulwar John gent 590340 590340 Bulwar, John, of Wetherden, gent 0
4247560 2112171 2112171 defendant Glanfeld Marcel laborer 590340 590340 Glanfeld, Marcel, of Wetherden, laborer 2
4247564 2112171 2112171 defendant Pesye William laborer 590340 590340 Pesye, William, of Wetherden, laborer 6
4247565 2112171 2112171 defendant Pesye George laborer 590340 590340 Pesye, George, of Wetherden, laborer 7
4248411 2112458 2112458 defendant Frank William husbandman 590340 590340 Frank, William, of Wetherden, husbandman 0
4248595 2112517 2112517 defendant Markes James yeoman 590340 590340 Markes, James, of Wetherden, yeoman 2
4278982 2122581 2122581 defendant Rosyer Nicholas tanner 590340 590340 Rosyer, Nicholas, of Wetherden, tanner 1
4280103 2122951 2122951 defendant Gibbons Humphrey gent 590340 590340 Gibbons, Humphrey, of Wetherden, gent 0
4307633 2132809 2132809 defendant Bulwer John gent 590340 590340 Bulwer, John, of Wetherden, gent 0
4327723 2139596 2139596 defendant Westley Robert clerk 590340 590340 Westley, Robert, of Wetherden, clerk 0
4328343 2139796 2139796 defendant Pyssye William husbandman 590340 590340 Pyssye, William, of Wetherden, husbandman 0
4339615 2143624 2143624 defendant Hatche William   590340 590340 Hatche, William, of Wetherden, yeoman, woollen weaver 1
4344087 2145211 2145211 defendant Westley Robert clerk 590340 590340 Westley, Robert, of Wetherden, clerk 0
4369213 2154053 2154053 defendant Gaines or Games Adlord yeoman 590340 590340 Gaines or Games, Adlord, of Wetherden, or of Buxall, Suff, yeoman 1
4386716 2160233 2160233 defendant Bulwer John gent 590340 590340 Bulwer, John, of Wetherden, gent 0
4387199 2160371 2160371 defendant Fuller Robert laborer 590340 590340 Fuller, Robert, of Wetherden, laborer 0
4387200 2160371 2160371 defendant Deynes Lawrence yeoman 590340 590340 Deynes, Lawrence, of Wetherden, yeoman 1
4413261 2169021 2169021 defendant Machoun William   590340 590340 Machoun, William, of Wetherden 0
4431591 2174650 2174650 defendant Hocot Nicholas la   590340 590340 Hocot, Nicholas la, of Wetherden 1
4435787 2175936 2175936 defendant Thede John   590340 590340 Thede, John, of Wetherden 2
4492341 2198281 2198281 defendant Wessebroom John   590340 590340 Wessebroom, John, of Wetherden 0
4492345 2198282 2198282 defendant Wessebroom John, junior   590340 590340 Wessebroom, John, junior, of Wetherden 0
4560823 2219342 2219342 defendant Westbrom John   590340 590340 Westbrom, John, of Wetherden 3
4613979 2235386 2235386 defendant Westbrom John   590340 590340 Westbrom, John, of Wetherden 1
4817731 2301631 2301631 defendant Dextere John yeoman 590340 590340 Dextere, John, of Wetherden, yeoman 4
5077232 2379693 2379693 defendant Kelyngworth Joseph gent 590340 590340 Kelyngworth, Joseph, of Wetherden, gent 0
5077233 2379693 2379693 defendant Dextre John yeoman 590340 590340 Dextre, John, of Wetherden, yeoman 1
5299998 2444963 2444963 defendant Yngham John husbandman 590340 590340 Yngham, John, of Wetherden, husbandman 0
5345362 2458724 2458724 defendant Godeman Robert husbandman 590340 590340 Godeman, Robert, of Wetherden, husbandman 0
5521815 2511635 2511635 defendant Clerk Thomas husbandman 590340 590340 Clerk, Thomas, of Wetherden, husbandman 3
5532627 2514750 2514750 defendant Bende Thomas chaplain 590340 590340 Bende, Thomas, of Wetherden, chaplain 2
5534958 2515468 2515468 plaintiff Beket John   590340 590340 Beket, John, of Wetherden 0
5546695 2519033 2519033 defendant Bende John chaplain 590340 590340 Bende, John, of Wetherden, chaplain 1
5564758 2524279 2524279 plaintiff Bourchier Anne widow 590340 590340 Bourchier, Anne, of Wetherden, widow 0
5588045 2531271 2531271 plaintiff Otley Ralph tanner 590340 590340 Otley, Ralph, of Wetherden, tanner 0
5594390 2533221 2533221 defendant Westbrome Geoffrey husbandman 590340 590340 Westbrome, Geoffrey, of Wetherden, husbandman 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);