names

103 rows where place_id = 603174

✎ 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
3653712 1911424 1911424 plaintiff Wyly John   603174 603174 Wyly, John, of Uppyngham 0
3666956 1915608 1915608 defendant Button Henry yeoman 603174 603174 Button, Henry, of Uppyngham, yeoman 0
3673067 1917585 1917585 defendant Lokwod Henry yeoman 603174 603174 Lokwod, Henry, of Uppyngham, yeoman 0
3673074 1917586 1917586 defendant Underwode John   603174 603174 Underwode, John, of Uppyngham 2
3683020 1920801 1920801 defendant Wellys William yeoman 603174 603174 Wellys, William, of Uppyngham, yeoman 0
3684707 1921349 1921349 defendant Presgrave Richard mercer 603174 603174 Presgrave, Richard, of Uppyngham, mercer 0
3697503 1925440 1925440 defendant Chetwod Richard yeoman 603174 603174 Chetwod, Richard, of Uppyngham, yeoman 1
3697504 1925440 1925440 defendant Chetwod Thomas yeoman 603174 603174 Chetwod, Thomas, of Uppyngham, yeoman 2
3698686 1925805 1925805 defendant Oxen William yeoman 603174 603174 Oxen, William, of Uppyngham, yeoman 0
3698847 1925857 1925857 defendant Button Henry yeoman 603174 603174 Button, Henry, of Uppyngham, yeoman 0
3749805 1941850 1941850 defendant Wellis William mercer 603174 603174 Wellis, William, of Uppyngham, mercer 0
3750828 1942180 1942180 defendant Bell Thomas yeoman 603174 603174 Bell, Thomas, of Uppyngham, yeoman 0
3766700 1947245 1947245 defendant Bell Thomas yeoman 603174 603174 Bell, Thomas, of Uppyngham, yeoman 0
3772543 1949102 1949102 defendant Grene Ambrose butcher 603174 603174 Grene, Ambrose, of Uppyngham, butcher 0
3790430 1954828 1954828 defendant Sutton Thomas   603174 603174 Sutton, Thomas, of Uppyngham 0
3796284 1956704 1956704 defendant Halcok John husbandman 603174 603174 Halcok, John, of Uppyngham, husbandman 0
3819254 1963911 1963911 defendant Tomkyns William butcher 603174 603174 Tomkyns, William, of Uppyngham, butcher 0
3851695 1974117 1974117 defendant Thomkynson William butcher 603174 603174 Thomkynson, William, of Uppyngham, butcher 2
3854150 1974936 1974936 defendant Grene Ambrose butcher 603174 603174 Grene, Ambrose, of Uppyngham, butcher 0
3920344 1997145 1997145 defendant Underwood Thomas butcher 603174 603174 Underwood, Thomas, of Uppyngham, butcher 1
3931724 2000912 2000912 defendant Gybson Richard dyer 603174 603174 Gybson, Richard, of Uppyngham, dyer 0
3935002 2002012 2002012 plaintiff Ibson Richard   603174 603174 Ibson, Richard, of Uppyngham 0
3935005 2002013 2002013 plaintiff Ilson Richard   603174 603174 Ilson, Richard, of Uppyngham 0
4413133 2168977 2168977 plaintiff atte Grene John   603174 603174 atte Grene, John, of Uppyngham 0
4491007 2197882 2197882 plaintiff Verder John   603174 603174 Verder, John, of Uppyngham 1
4505253 2202173 2202173 defendant Shepeherd John   603174 603174 Shepeherd, John, of Uppyngham 0
4505254 2202173 2202173 defendant Cobard John   603174 603174 Cobard, John, of Uppyngham 1
4508745 2203210 2203210 defendant Sherman John   603174 603174 Sherman, John, of Uppyngham 0
4514765 2205034 2205034 defendant Sherman John   603174 603174 Sherman, John, of Uppyngham 0
4526229 2208492 2208492 defendant Sherman John   603174 603174 Sherman, John, of Uppyngham 4
4573834 2223334 2223334 defendant Poke John   603174 603174 Poke, John, of Uppyngham 0
4586271 2227124 2227124 plaintiff Hereford John master & parson 603174 603174 Hereford, John, of Uppyngham, master & parson 0
4586272 2227124 2227124 defendant Bond Walter chaplain 603174 603174 Bond, Walter, of Uppyngham, chaplain 0
4617023 2236333 2236333 defendant Pardoner Thomas   603174 603174 Pardoner, Thomas, of Uppyngham 0
4647349 2245280 2245280 plaintiff Scarle Robert   603174 603174 Scarle, Robert, of Uppyngham 0
4647722 2245392 2245392 defendant Bolyvere Robert   603174 603174 Bolyvere, Robert, of Uppyngham 0
4660503 2249110 2249110 defendant Draper Thomas husbandman 603174 603174 Draper, Thomas, of Uppyngham, husbandman 0
4660504 2249110 2249110 defendant Sherman Walter yeoman 603174 603174 Sherman, Walter, of Uppyngham, yeoman 1
4660505 2249110 2249110 defendant Murdok John husbandman 603174 603174 Murdok, John, of Uppyngham, husbandman 2
4662187 2249648 2249648 defendant Wynmere Thomas butcher 603174 603174 Wynmere, Thomas, of Uppyngham, butcher 0
4662189 2249649 2249649 defendant Wynmere Thomas butcher 603174 603174 Wynmere, Thomas, of Uppyngham, butcher 0
4670294 2256415 2256415 defendant Parysprest John chaplain 603174 603174 Parysprest, John, of Uppyngham, chaplain 0
4685861 2261169 2261169 plaintiff Scarle Robert   603174 603174 Scarle, Robert, of Uppyngham, 0
4752483 2281188 2281188 defendant Tayllour Thomas tailor 603174 603174 Tayllour, Thomas, of Uppyngham, tailor 0
4771703 2287127 2287127 defendant Aleyn Roger husbandman 603174 603174 Aleyn, Roger, of Uppyngham, husbandman 0
4789274 2292706 2292706 defendant Willemer Thomas husbandman 603174 603174 Willemer, Thomas, of Uppyngham, husbandman 0
4789275 2292706 2292706 defendant Broun Roger husbandman 603174 603174 Broun, Roger, of Uppyngham, husbandman 1
4886851 2322742 2322742 defendant Kebyll William spicer 603174 603174 Kebyll, William, of Uppyngham, spicer 3
4922142 2333337 2333337 defendant Brown John husbandman 603174 603174 Brown, John, of Uppyngham, husbandman 1
4924800 2334189 2334189 defendant Couper John cooper 603174 603174 Couper, John, of Uppyngham, cooper 1
4929344 2335598 2335598 plaintiff Stooke or Stocke William   603174 603174 Stooke or Stocke, William, of Uppyngham 0
4929348 2335599 2335599 plaintiff Stooke William   603174 603174 Stooke, William, of Uppyngham 0
4933210 2336777 2336777 defendant Wyldam John chapman 603174 603174 Wyldam, John, of Uppyngham, chapman 0
4933211 2336777 2336777 defendant Paret William botcher 603174 603174 Paret, William, of Uppyngham, botcher 1
4933212 2336777 2336777 defendant Mosendewe William chapman 603174 603174 Mosendewe, William, of Uppyngham, chapman 2
4938633 2338466 2338466 defendant Rowell John   603174 603174 Rowell, John, of Uppyngham, wright 0
4946821 2341011 2341011 defendant Rowen John carpenter 603174 603174 Rowen, John, of Uppyngham, carpenter 0
4948216 2341416 2341416 defendant Mesenden William chapman 603174 603174 Mesenden, William, of Uppyngham, chapman 1
4950471 2342114 2342114 defendant Seward William spicer 603174 603174 Seward, William, of Uppyngham, spicer 2
4950532 2342126 2342126 defendant Welford William yeoman 603174 603174 Welford, William, of Uppyngham, yeoman 4
4951068 2342298 2342298 defendant Tebot Thomas   603174 603174 Tebot, Thomas, of Uppyngham, "hyernemonger" 1
4953468 2343006 2343006 defendant Kebill William chapman 603174 603174 Kebill, William, of Uppyngham, chapman 1
4953531 2343028 2343028 defendant Kebyll William chapman 603174 603174 Kebyll, William, of Uppyngham, chapman 1
4967855 2347330 2347330 defendant Smyth John smith 603174 603174 Smyth, John, of Uppyngham, smith 1
5003379 2357886 2357886 defendant Wylliam John chapman 603174 603174 Wylliam, John, of Uppyngham, chapman 1
5007057 2358959 2358959 defendant Seward William spicer 603174 603174 Seward, William, of Uppyngham, spicer 0
5007058 2358959 2358959 defendant Couper John husbandman 603174 603174 Couper, John, of Uppyngham, husbandman 1
5007059 2358959 2358959 defendant Burgeys Thomas husbandman 603174 603174 Burgeys, Thomas, of Uppyngham, husbandman 2
5007060 2358959 2358959 defendant Smyth William cooper 603174 603174 Smyth, William, of Uppyngham, cooper 3
5025687 2364417 2364417 defendant Theband Thomas yeoman 603174 603174 Theband, Thomas, of Uppyngham, yeoman 0
5047381 2370835 2370835 defendant Seward William chapman 603174 603174 Seward, William, of Uppyngham, chapman 0
5047382 2370835 2370835 defendant Couper William cooper 603174 603174 Couper, William, of Uppyngham, cooper 1
5052087 2372237 2372237 defendant Couper William cooper 603174 603174 Couper, William, of Uppyngham, cooper 2
5059987 2374550 2374550 defendant Crosse John tailor 603174 603174 Crosse, John, of Uppyngham, tailor 0
5059988 2374550 2374550 defendant Syward John barker 603174 603174 Syward, John, of Uppyngham, barker 1
5064734 2375992 2375992 plaintiff Leke William gent 603174 603174 Leke, William, of Uppyngham, or of West Halghton, Lancs, gent 0
5064738 2375993 2375993 plaintiff Leke William gent 603174 603174 Leke, William, of Uppyngham, or of West Halghton, Lancs, gent 0
5067756 2376855 2376855 defendant Syward William mercer 603174 603174 Syward, William, of Uppyngham, mercer 0
5082775 2381353 2381353 defendant Chesylden John esq 603174 603174 Chesylden, John, of Uppyngham, esq 0
5082776 2381353 2381353 defendant Leek William esq 603174 603174 Leek, William, of Uppyngham, esq 1
5233896 2425500 2425500 defendant Tebotte Thomas chapman 603174 603174 Tebotte, Thomas, of Uppyngham, chapman 0
5260452 2433402 2433402 defendant George Richard   603174 603174 George, Richard, of Uppyngham, wool buyer 1
5271522 2436766 2436766 defendant Akent John yeoman 603174 603174 Akent, John, of Uppyngham, yeoman 0
5271523 2436766 2436766 defendant George Richard chapman 603174 603174 George, Richard, of Uppyngham, chapman 1
5373415 2467280 2467280 defendant Parker Richard (legal representative) 603174 603174 Parker, Richard, of Uppyngham, executor of 0
5397999 2474495 2474495 defendant Mathen John yeoman 603174 603174 Mathen, John, of Uppyngham, yeoman 0
5431396 2484340 2484340 defendant Hermytage Thomas tailor 603174 603174 Hermytage, Thomas, of Uppyngham, tailor 0
5490704 2502111 2502111 defendant Chesylden John (legal representative) 603174 603174 Chesylden, John, of Uppyngham, esq, executors of 4
5498102 2504376 2504376 defendant Sketh William laborer 603174 603174 Sketh, William, of Uppyngham, laborer 0
5498103 2504376 2504376 defendant Drake William   603174 603174 Drake, William, of Uppyngham, mason 1
5498105 2504377 2504377 defendant Sleth William laborer 603174 603174 Sleth, William, of Uppyngham, laborer 0
5498106 2504377 2504377 defendant Drake William   603174 603174 Drake, William, of Uppyngham, mason 1
5505548 2506655 2506655 defendant Chesylden John (legal representative) 603174 603174 Chesylden, John, of Uppyngham, esq, executors of 0
5505551 2506656 2506656 defendant Chesylden John (legal representative) 603174 603174 Chesylden, John, of Uppyngham, esq, executors of 0
5620537 2550282 2550282 plaintiff Scarle Walter   603174 603174 Scarle, Walter, of Uppyngham, on his own account 0
5627820 2552671 2552671 defendant Draper Thomas husbandman 603174 603174 Draper, Thomas, of Uppyngham, husbandman 0
5627821 2552671 2552671 defendant Sherman Walter yeoman 603174 603174 Sherman, Walter, of Uppyngham, yeoman 1
5627822 2552671 2552671 defendant Murdok John husbandman 603174 603174 Murdok, John, of Uppyngham, husbandman 2
5630660 2553594 2553594 plaintiff Scarle Robert   603174 603174 Scarle, Robert, of Uppyngham 0
5632197 2554095 2554095 plaintiff Staple Robert   603174 603174 Staple, Robert, of Uppyngham 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);