names

80 rows where place_id = 596876

✎ 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
3626484 1903139 1903139 defendant Cradeley John yeoman 596876 596876 Cradeley, John, of Wednesbury, yeoman 1
3626490 1903139 1903139 defendant Hardman William laborer 596876 596876 Hardman, William, of Wednesbury, laborer 7
3626496 1903139 1903139 defendant Mercer John laborer 596876 596876 Mercer, John, of Wednesbury, laborer 13
3626512 1903143 1903143 defendant Whyte Nicholas yeoman 596876 596876 Whyte, Nicholas, of Wednesbury, yeoman 1
3629500 1904082 1904082 defendant Cradeley John yeoman 596876 596876 Cradeley, John, of Wednesbury, yeoman 1
3629504 1904084 1904084 defendant Beamount John (legal representative) 596876 596876 Beamount, John, of Wednesbury, esq, executor of 0
3629505 1904084 1904084 defendant Beamount James gent 596876 596876 Beamount, James, of Wednesbury, gent 1
3630153 1904278 1904278 defendant Cradeley John yeoman 596876 596876 Cradeley, John, of Wednesbury, yeoman 0
3688385 1922524 1922524 defendant Beamont James gent 596876 596876 Beamont, James, of Wednesbury, gent 1
3737332 1937912 1937912 defendant Hunt John laborer 596876 596876 Hunt, John, of Wednesbury, laborer 3
3738695 1938310 1938310 defendant Broke Robert fisher 596876 596876 Broke, Robert, of Wednesbury, fisher 1
3812743 1961879 1961879 defendant Jenyns George yeoman 596876 596876 Jenyns, George, of Wednesbury, yeoman 0
3812744 1961879 1961879 defendant Hopkyns George yeoman 596876 596876 Hopkyns, George, of Wednesbury, yeoman 1
3920713 1997276 1997276 defendant Jenyns Thomas chapman 596876 596876 Jenyns, Thomas, of Wednesbury, chapman 0
3920714 1997276 1997276 defendant Broke John blacksmith 596876 596876 Broke, John, of Wednesbury, blacksmith 1
3923545 1998183 1998183 defendant Jenyns Thomas yeoman 596876 596876 Jenyns, Thomas, of Wednesbury, yeoman 0
3952227 2007853 2007853 defendant Heley Andrew   596876 596876 Heley, Andrew, of Wednesbury, iron bloomer 1
3966918 2013062 2013062 defendant Coke Roger yeoman 596876 596876 Coke, Roger, of Wednesbury, yeoman 0
3975122 2015862 2015862 plaintiff Hopkyns Richard   596876 596876 Hopkyns, Richard, of Wednesbury 0
4004602 2026420 2026420 plaintiff Jenyns Richard   596876 596876 Jenyns, Richard, of Wednesbury 0
4011094 2028741 2028741 plaintiff Perk or Parkes Thomas nailer 596876 596876 Perk or Parkes, Thomas, of Wednesbury, nailer 0
4020879 2032196 2032196 defendant Syddowne Richard, junior laborer 596876 596876 Syddowne, Richard, junior, of Wednesbury, laborer 1
4020881 2032196 2032196 defendant Syddowne Richard, senior blacksmith 596876 596876 Syddowne, Richard, senior, of Wednesbury, blacksmith 3
4020884 2032197 2032197 defendant Syddowne Richard, senior blacksmith 596876 596876 Syddowne, Richard, senior, of Wednesbury, blacksmith 1
4020886 2032197 2032197 defendant Syddowne Richard, junior laborer 596876 596876 Syddowne, Richard, junior, of Wednesbury, laborer 3
4020941 2032218 2032218 defendant Meryhurst Thomas cordwainer 596876 596876 Meryhurst, Thomas, of Wednesbury, cordwainer 0
4035797 2037476 2037476 defendant Westbroke Nicholas laborer 596876 596876 Westbroke, Nicholas, of Wednesbury, laborer 0
4038278 2038326 2038326 defendant Astley Humphrey blacksmith 596876 596876 Astley, Humphrey, of Wednesbury, blacksmith 0
4045958 2041001 2041001 plaintiff Sheldon Richard   596876 596876 Sheldon, Richard, of Wednesbury 0
4062113 2046735 2046735 defendant Jennyns John butcher 596876 596876 Jennyns, John, of Wednesbury, or of Byrmyngham, Warks, butcher 0
4069818 2049489 2049489 defendant Asteley Humphrey yeoman 596876 596876 Asteley, Humphrey, of Wednesbury, yeoman 1
4069819 2049489 2049489 defendant Mather Elizabeth widow 596876 596876 Mather, Elizabeth, of Wednesbury, widow 2
4098962 2059953 2059953 defendant Worthyngton John carrier 596876 596876 Worthyngton, John, of Wednesbury, carrier 0
4107209 2062875 2062875 defendant Hopkys or Hopkins Edward collier 596876 596876 Hopkys or Hopkins, Edward, of Wednesbury, collier 0
4107213 2062876 2062876 defendant Hopkys or Hopkyns Edward collier 596876 596876 Hopkys or Hopkyns, Edward, of Wednesbury, collier 0
4111018 2064190 2064190 defendant Parkes Thomas clerk 596876 596876 Parkes, Thomas, of Wednesbury, clerk 0
4111019 2064190 2064190 defendant Taylor Thomas laborer 596876 596876 Taylor, Thomas, of Wednesbury, laborer 1
4111020 2064190 2064190 defendant Moore Richard blacksmith 596876 596876 Moore, Richard, of Wednesbury, blacksmith 2
4137208 2073654 2073654 defendant Aston John lorimer 596876 596876 Aston, John, of Wednesbury, lorimer 2
4137209 2073654 2073654 defendant Yate John blacksmith 596876 596876 Yate, John, of Wednesbury, blacksmith 3
4142325 2075491 2075491 defendant Cockyn William gent 596876 596876 Cockyn, William, of Wednesbury, gent 2
4155570 2080031 2080031 defendant Eaton William yeoman 596876 596876 Eaton, William, of Wednesbury, yeoman 1
4285443 2124840 2124840 defendant Sheldon Henry yeoman 596876 596876 Sheldon, Henry, of Wednesbury, yeoman 0
4343918 2145154 2145154 defendant Downynge   widow 596876 596876 Downynge, , of Wednesbury, widow 3
4350954 2147589 2147589 defendant Meryhurst John   596876 596876 Meryhurst, John, of Wednesbury, yeoman, his son 1
4356554 2149523 2149523 defendant Gesson George potter 596876 596876 Gesson, George, of Wednesbury, potter 2
4392165 2162003 2162003 defendant Merihurst John yeoman 596876 596876 Merihurst, John, of Wednesbury, yeoman 1
4403742 2165824 2165824 defendant Meryhurst Thomas yeoman 596876 596876 Meryhurst, Thomas, of Wednesbury, yeoman 0
4403743 2165824 2165824 defendant Meryhurst John   596876 596876 Meryhurst, John, of Wednesbury, yeoman, his son 1
4411520 2168443 2168443 defendant Lee William yeoman 596876 596876 Lee, William, of Wednesbury, yeoman 3
4441593 2182305 2182305 defendant Smyth Nicholas   596876 596876 Smyth, Nicholas, of Wednesbury, servant of Adam Smyth 2
4560997 2219392 2219392 plaintiff Othe Grene William   596876 596876 Othe Grene, William, of Wednesbury 0
4670149 2256369 2256369 defendant Watson Nicholas glover 596876 596876 Watson, Nicholas, of Wednesbury, glover 0
4670150 2256369 2256369 defendant Watson Thomas glover 596876 596876 Watson, Thomas, of Wednesbury, glover 1
4694599 2263807 2263807 defendant Chilterne Thomas gent 596876 596876 (Chilterne, Thomas, of Wednesbury, gent 1
4722027 2272218 2272218 plaintiff Clerk Henry   596876 596876 Clerk, Henry, of Wednesbury 0
4729634 2274480 2274480 defendant Gargowe Robert smith 596876 596876 Gargowe, Robert, of Wednesbury, smith 2
4729635 2274480 2274480 defendant Rout John   596876 596876 Rout, John, of Wednesbury, nail maker 3
4851867 2312018 2312018 defendant Brereley Thomas potter 596876 596876 Brereley, Thomas, of Wednesbury, potter 1
4869879 2317549 2317549 defendant Leventhorp William   596876 596876 Leventhorp, William, of Wednesbury 0
4914462 2331041 2331041 defendant Nyghtyngale Richard carpenter 596876 596876 Nyghtyngale, Richard, of Wednesbury, carpenter 0
4932344 2336513 2336513 defendant Martyn Richard yeoman 596876 596876 Martyn, Richard, of Wednesbury, yeoman 0
5037744 2367912 2367912 defendant Bellamounte Elizabeth widow 596876 596876 Bellamounte, Elizabeth, of Wednesbury, widow 1
5037746 2367913 2367913 defendant Bellemounte or Beaumont Henry (legal representative) 596876 596876 Bellemounte or Beaumont, Henry, of Wednesbury, or of Thorpe, Yorks, knight, executrix of 0
5084057 2381734 2381734 defendant Twycros John yeoman 596876 596876 Twycros, John, of Wednesbury, yeoman 0
5088886 2383126 2383126 defendant Broke John smith 596876 596876 Broke, John, of Wednesbury, smith 2
5156969 2403179 2403179 defendant Whyng Thomas butcher 596876 596876 Whyng, Thomas, of Wednesbury, butcher 0
5173028 2407823 2407823 defendant Whyng Thomas butcher 596876 596876 Whyng, Thomas, of Wednesbury, butcher 0
5230777 2424611 2424611 defendant Broke John (legal representative) 596876 596876 Broke, John, of Wednesbury, executors of 0
5230778 2424611 2424611 defendant Broke John ironmonger 596876 596876 (Broke, John, of Wednesbury, ironmonger 1
5230779 2424611 2424611 defendant Broke Alice widow 596876 596876 Broke, Alice, of Wednesbury, widow 2
5232159 2424981 2424981 plaintiff Broke Richard, junior   596876 596876 Broke, Richard, junior, of Wednesbury 0
5259405 2433064 2433064 defendant Farre Nicholas smith 596876 596876 Farre, Nicholas, of Wednesbury, smith 1
5259406 2433064 2433064 defendant Nyghtyngale Robert husbandman 596876 596876 Nyghtyngale, Robert, of Wednesbury, husbandman 2
5271087 2436637 2436637 defendant Watson John yeoman 596876 596876 Watson, John, of Wednesbury, yeoman 2
5271088 2436637 2436637 defendant Plummer John yeoman 596876 596876 Plummer, John, of Wednesbury, yeoman 3
5271089 2436637 2436637 defendant Hopkyns Thomas yeoman 596876 596876 Hopkyns, Thomas, of Wednesbury, yeoman 4
5393251 2473121 2473121 defendant Curtes William butcher 596876 596876 Curtes, William, of Wednesbury, butcher 0
5406387 2476898 2476898 defendant Curtes William butcher 596876 596876 Curtes, William, of Wednesbury, butcher 0
5419479 2480745 2480745 defendant Curtes William butcher 596876 596876 Curtes, William, of Wednesbury, butcher 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);