names

231 rows where place_id = 587022

✎ 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
3590268 1864602 1864602 defendant Glascok John butcher 587022 587022 Glascok, John, of West Ham, butcher 0
3590274 1864603 1864603 defendant Glascok John butcher 587022 587022 Glascok, John, of West Ham, butcher 0
3593103 1865470 1865470 defendant Bullok Thomas laborer 587022 587022 Bullok, Thomas, of West Ham, laborer 3
3599578 1867505 1867505 defendant Lynnette Robert tanner 587022 587022 Lynnette, Robert, of West Ham, tanner 1
3627749 1903540 1903540 defendant Grynsted Julia widow 587022 587022 Grynsted, Julia, of West Ham, widow 0
3631611 1904701 1904701 defendant Broke William husbandman 587022 587022 Broke, William, of West Ham, husbandman 0
3637249 1906452 1906452 defendant Osborne John tanner 587022 587022 Osborne, John, of West Ham, tanner 0
3667781 1915865 1915865 plaintiff Huddilston Nicholas   587022 587022 Huddilston, Nicholas, of West Ham 1
3686923 1922075 1922075 defendant Nundy Stephen   587022 587022 Nundy, Stephen, of West Ham, wheelwright 0
3706383 1928285 1928285 defendant Osburne John tanner 587022 587022 Osburne, John, of West Ham, tanner 0
3712338 1930177 1930177 defendant Colford Richard baker 587022 587022 Colford, Richard, of West Ham, baker 0
3736222 1937574 1937574 defendant Hust Agnes widow 587022 587022 Hust, Agnes, of West Ham, widow 0
3736223 1937574 1937574 defendant Baldwyn Robert husbandman 587022 587022 Baldwyn, Robert, of West Ham, husbandman 1
3736224 1937574 1937574 defendant Burne Hugh husbandman 587022 587022 Burne, Hugh, of West Ham, husbandman 2
3741559 1939229 1939229 defendant Baldwyn William husbandman 587022 587022 Baldwyn, William, of West Ham, husbandman 0
3955753 2009086 2009086 defendant Mewtas Henry esq 587022 587022 Mewtas, Henry, of West Ham, esq 0
3955755 2009087 2009087 defendant Mewtas Henry esq 587022 587022 Mewtas, Henry, of West Ham, esq 0
3971043 2014427 2014427 defendant Bowyer Anthony butcher 587022 587022 Bowyer, Anthony, of West Ham, butcher 0
3971044 2014427 2014427 defendant Freman John gent 587022 587022 Freman, John, of West Ham, gent 1
3983782 2018977 2018977 plaintiff Staunton Robert gent 587022 587022 Staunton, Robert, of West Ham, gent 0
4028218 2034741 2034741 defendant Meantis or Meautis Henry gent 587022 587022 Meantis or Meautis, Henry, of West Ham, gent 0
4043358 2040090 2040090 defendant Beche Walter yeoman 587022 587022 Beche, Walter, of West Ham, yeoman 3
4054123 2043861 2043861 defendant Wylmore George yeoman 587022 587022 Wylmore, George, of West Ham, yeoman 0
4054126 2043862 2043862 defendant Wylmore George yeoman 587022 587022 Wylmore, George, of West Ham, yeoman 0
4072996 2050640 2050640 defendant Bridges Anthony gent 587022 587022 Bridges, Anthony, of West Ham, gent 0
4109284 2063582 2063582 defendant Wolmer George yeoman 587022 587022 Wolmer, George, of West Ham, yeoman 0
4109286 2063583 2063583 defendant Wolmer George yeoman 587022 587022 Wolmer, George, of West Ham, yeoman 0
4142879 2075683 2075683 defendant Hunte Thomas carpenter 587022 587022 Hunte, Thomas, of West Ham, carpenter 1
4161563 2082112 2082112 defendant Barton William yeoman 587022 587022 Barton, William, of West Ham, yeoman 0
4237425 2108682 2108682 defendant Midleton John yeoman 587022 587022 Midleton, John, of West Ham, yeoman 0
4237426 2108682 2108682 defendant Bradshawe William yeoman 587022 587022 Bradshawe, William, of West Ham, yeoman 1
4237427 2108682 2108682 defendant Pomfrett Richard yeoman 587022 587022 Pomfrett, Richard, of West Ham, yeoman 2
4237428 2108682 2108682 defendant Moyle Richard yeoman 587022 587022 Moyle, Richard, of West Ham, yeoman 3
4238365 2109031 2109031 defendant Wylson Daniel poulter 587022 587022 Wylson, Daniel, of West Ham, poulter 0
4258843 2115926 2115926 defendant Dixson William yeoman 587022 587022 Dixson, William, of West Ham, yeoman 0
4261032 2116654 2116654 defendant Rawson Dorothy spinster 587022 587022 Rawson, Dorothy, of West Ham, spinster 1
4272240 2120284 2120284 defendant Rawson or Rawston Dorothy spinster 587022 587022 Rawson or Rawston, Dorothy, of West Ham, spinster 1
4388499 2160793 2160793 defendant Brock William brewer 587022 587022 Brock, William, of West Ham, yeoman, or of Colchester, brewer 0
4389148 2161001 2161001 defendant Keelinge Richard yeoman 587022 587022 Keelinge, Richard, of West Ham, yeoman 2
4417580 2170388 2170388 plaintiff Sperlyng Nicholas clerk 587022 587022 Sperlyng, Nicholas, of West Ham, clerk 0
4417582 2170389 2170389 plaintiff Sperlyng Nicholas clerk 587022 587022 Sperlyng, Nicholas, of West Ham, clerk 0
4487887 2196928 2196928 defendant Heyward John   587022 587022 Heyward, John, of West Ham 0
4550950 2216232 2216232 defendant Danyell Thomas   587022 587022 Danyell, Thomas, of West Ham 0
4550952 2216232 2216232 defendant Waiour William   587022 587022 Waiour, William, of West Ham 2
4648992 2245754 2245754 defendant Joce Thomas   587022 587022 Joce, Thomas, of West Ham 0
4669520 2256172 2256172 defendant Whitby John husbandman 587022 587022 Whitby, John, of West Ham, husbandman 2
4770182 2286645 2286645 defendant Sewale John husbandman 587022 587022 Sewale, John, of West Ham, husbandman 0
4770183 2286645 2286645 defendant Rook Richard husbandman 587022 587022 Rook, Richard, of West Ham, husbandman 1
4804571 2297622 2297622 defendant Lytelberk John husbandman 587022 587022 Lytelberk, John, of West Ham, husbandman 0
4830724 2305636 2305636 defendant Reyhold Peter carpenter 587022 587022 Reyhold, Peter, of West Ham, carpenter 0
4861718 2315035 2315035 defendant Coke William husbandman 587022 587022 Coke, William, of West Ham, husbandman 0
4953100 2342892 2342892 defendant Redehede John fisher 587022 587022 Redehede, John, of West Ham, fisher 0
4953101 2342892 2342892 defendant Algore William fisher 587022 587022 Algore, William, of West Ham, fisher 1
4959254 2344737 2344737 defendant Halman John husbandman 587022 587022 Halman, John, of West Ham, husbandman 0
4962945 2345835 2345835 defendant Broun John husbandman 587022 587022 Broun, John, of West Ham, husbandman 0
4964986 2346444 2346444 defendant Danyell Richard fisher 587022 587022 Danyell, Richard, of West Ham, fisher 0
4979151 2350721 2350721 defendant atee Hill Thomas fisher 587022 587022 atee Hill, Thomas, of West Ham, fisher 1
4979336 2350781 2350781 defendant Wheler William tanner 587022 587022 Wheler, William, of West Ham, tanner 0
4979338 2350781 2350781 defendant Selby John chaplain 587022 587022 Selby, John, of West Ham, chaplain 2
5004241 2358131 2358131 defendant Fletcher Nicholas yeoman 587022 587022 Fletcher, Nicholas, of West Ham, yeoman 1
5016446 2361702 2361702 defendant Warde John husbandman 587022 587022 Warde, John, of West Ham, husbandman 0
5019517 2362591 2362591 defendant Clerk John, junior fisher 587022 587022 Clerk, John, junior, of West Ham, fisher 0
5034696 2367003 2367003 defendant Hoggeman Thomas husbandman 587022 587022 Hoggeman, Thomas, of West Ham, husbandman 0
5034697 2367003 2367003 defendant Hoggeman John husbandman 587022 587022 Hoggeman, John, of West Ham, husbandman 1
5037698 2367898 2367898 defendant Brome John husbandman 587022 587022 Brome, John, of West Ham, husbandman 0
5039285 2368393 2368393 defendant Lucas John yeoman 587022 587022 Lucas, John, of West Ham, yeoman 1
5039662 2368507 2368507 defendant Lucas John yeoman 587022 587022 Lucas, John, of West Ham, yeoman 1
5048061 2371043 2371043 defendant Gobeon Richard gent 587022 587022 Gobeon, Richard, of West Ham, gent 0
5056705 2373577 2373577 defendant Benyngton Maud widow 587022 587022 Benyngton, Maud, of West ham, widow 1
5063683 2375669 2375669 defendant Benyngton Henry yeoman 587022 587022 Benyngton, Henry, of West Ham, yeoman 0
5063686 2375670 2375670 defendant Norman James miller 587022 587022 Norman, James, of West Ham, miller 1
5066567 2376525 2376525 defendant Broun Thomas husbandman 587022 587022 Broun, Thomas, of West Ham, husbandman 0
5074950 2379015 2379015 defendant Clerk Richard husbandman 587022 587022 Clerk, Richard, of West Ham, husbandman 0
5075312 2379113 2379113 defendant Danyell John fisher 587022 587022 Danyell, John, of West Ham, fisher 3
5075313 2379113 2379113 defendant Redehede John fisher 587022 587022 Redehede, John, of West Ham, fisher 4
5075314 2379113 2379113 defendant Clerk Thomas fisher 587022 587022 Clerk, Thomas, of West Ham, fisher 5
5075315 2379113 2379113 defendant Clerk John fisher 587022 587022 Clerk, John, of West Ham, fisher 6
5077293 2379710 2379710 defendant Catasby alias Heggeman John husbandman 587022 587022 Catasby alias Heggeman, John, of West Ham, husbandman 1
5077301 2379712 2379712 defendant Gatasby alias Hoggeman John husbandman 587022 587022 Gatasby alias Hoggeman, John, of West Ham, husbandman 1
5079014 2380207 2380207 defendant Kyte William laborer 587022 587022 Kyte, William, of West Ham, laborer 1
5079015 2380207 2380207 defendant Fote John cordwainer 587022 587022 Fote, John, of West Ham, cordwainer 2
5086207 2382363 2382363 defendant Benet John carpenter 587022 587022 Benet, John, of West Ham, carpenter 1
5086209 2382364 2382364 defendant Benet John carpenter 587022 587022 Benet, John, of West Ham, carpenter 0
5086211 2382364 2382364 defendant Lucas John yeoman 587022 587022 Lucas, John, of West Ham, yeoman 2
5086343 2382400 2382400 plaintiff Redyng William   587022 587022 Redyng, William, of West Ham 2
5086344 2382400 2382400 defendant Shipman Lawrence herder 587022 587022 Shipman, Lawrence, of West Ham, herder 0
5088168 2382914 2382914 defendant Redehede John fisher 587022 587022 Redehede, John, of West Ham, fisher 1
5088169 2382914 2382914 defendant Clerk Thomas fisher 587022 587022 Clerk, Thomas, of West Ham, fisher 2
5088170 2382914 2382914 defendant Clerk John fisher 587022 587022 Clerk, John, of West Ham, fisher 3
5088171 2382914 2382914 defendant Algore John fisher 587022 587022 Algore, John, of West Ham, fisher 4
5099912 2386411 2386411 defendant Birde Henry laborer 587022 587022 Birde, Henry, of West Ham, laborer 0
5099914 2386412 2386412 defendant Danyelle William husbandman 587022 587022 Danyelle, William, of West Ham, husbandman 0
5100741 2386641 2386641 defendant Neuton John yeoman 587022 587022 Neuton, John, of West Ham, yeoman 0
5100742 2386641 2386641 defendant Clerk John, junior laborer 587022 587022 Clerk, John, junior, of West Ham, laborer 1
5100744 2386642 2386642 defendant Neuton John yeoman 587022 587022 Neuton, John, of West Ham, yeoman 0
5100745 2386642 2386642 defendant Clerk John, junior laborer 587022 587022 Clerk, John, junior, of West Ham, laborer 1
5106220 2388258 2388258 defendant Neuton John yeoman 587022 587022 Neuton, John, of West Ham, yeoman 0
5106225 2388259 2388259 defendant Neuton John yeoman 587022 587022 Neuton, John, of West Ham, yeoman 0
5111992 2389894 2389894 defendant Hegeman Thomas carpenter 587022 587022 Hegeman, Thomas, of West Ham, carpenter 0
5117212 2391464 2391464 defendant Gardener John laborer 587022 587022 Gardener, John, of West Ham, laborer 0

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