names

141 rows where place_id = 590525

✎ 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
3601488 1868120 1868120 defendant Dey Henry husbandman 590525 590525 (Dey, Henry, of North Pederton, husbandman 3
3603598 1868794 1868794 plaintiff Dybyll or Dyvyll John   590525 590525 Dybyll or Dyvyll, John, of North Pederton 0
3614061 1872060 1872060 defendant Muddislay Richard merchant 590525 590525 Muddislay, Richard, of North Pederton, merchant 0
3642720 1908168 1908168 defendant Haywod William yeoman 590525 590525 Haywod, William, of North Pederton, yeoman 0
3652967 1911259 1911259 defendant Cokkes Henry husbandman 590525 590525 Cokkes, Henry, of North Pederton, husbandman 1
3670723 1916803 1916803 defendant Cokkes Henry yeoman 590525 590525 Cokkes, Henry, of North Pederton, yeoman 0
3710647 1929651 1929651 defendant Colfox John butcher 590525 590525 Colfox, John, of North Pederton, butcher 1
3716655 1931506 1931506 defendant Byggegode Robert husbandman 590525 590525 Byggegode, Robert, of North Pederton, husbandman 0
3772795 1949186 1949186 defendant Spyler John haberdasher 590525 590525 Spyler, John, of North Pederton, haberdasher 0
3795823 1956562 1956562 defendant Asshe William husbandman 590525 590525 Asshe, William, of North Pederton, husbandman 0
3795824 1956562 1956562 defendant Asshe Robert laborer 590525 590525 Asshe, Robert, of North Pederton, laborer 1
3795825 1956562 1956562 defendant Swever John weaver 590525 590525 Swever, John, of North Pederton, weaver 2
4452861 2185907 2185907 defendant Bouth Ralph   590525 590525 Bouth, Ralph, of North Pederton 0
4467159 2190398 2190398 defendant Ive Walter   590525 590525 Ive, Walter, of North Pederton 0
4472239 2191986 2191986 defendant Jonesson Payn William   590525 590525 Jonesson Payn, William, of North Pederton 0
4480606 2194603 2194603 defendant Gale John   590525 590525 Gale, John, of North Pederton 1
4516304 2205510 2205510 defendant Colyford John   590525 590525 Colyford, John, of North Pederton, vicar 0
4516443 2205551 2205551 plaintiff Coliford John   590525 590525 Coliford, John, of North Pederton, vicar 0
4526599 2208597 2208597 plaintiff Lane John (legal representative) 590525 590525 Lane, John, of North Pederton, executors of 0
4528068 2209062 2209062 defendant Dyght Simon   590525 590525 Dyght, Simon, of North Pederton 0
4542652 2213589 2213589 defendant Colyford John   590525 590525 Colyford, John, of North Pederton 0
4544155 2214086 2214086 defendant Selewod John   590525 590525 Selewod, John, of North Pederton 0
4544156 2214086 2214086 defendant Lye John   590525 590525 Lye, John, of North Pederton 1
4551939 2216559 2216559 defendant Leygh Robert   590525 590525 Leygh, Robert, of North Pederton 0
4561493 2219528 2219528 plaintiff Payn John (legal representative) 590525 590525 Payn, John, of North Pederton, executor of 0
4573994 2223386 2223386 defendant Fysshere John   590525 590525 Fysshere, John, of North Pederton 3
4593502 2229254 2229254 plaintiff Payn William   590525 590525 Payn, William, of North Pederton 0
4604540 2232586 2232586 plaintiff Yonge John   590525 590525 Yonge, John, of North Pederton 0
4604541 2232586 2232586 defendant Batte Thomas   590525 590525 Batte, Thomas, of North Pederton 0
4612016 2234821 2234821 defendant Neweman John   590525 590525 Neweman, John, of North Pederton 1
4623082 2238197 2238197 defendant Clavell Richard   590525 590525 Clavell, Richard, of North Pederton 0
4623083 2238197 2238197 defendant Deye Henry   590525 590525 Deye, Henry, of North Pederton 1
4631480 2240736 2240736 defendant Mauncell Richard   590525 590525 Mauncell, Richard, of North Pederton 0
4637298 2242461 2242461 defendant Leget William   590525 590525 Leget, William, of North Pederton 0
4643385 2244171 2244171 defendant Morys John   590525 590525 Morys, John, of North Pederton 2
4657463 2248226 2248226 defendant Say William laborer 590525 590525 Say, William, of North Pederton, laborer 0
4667391 2255522 2255522 defendant Baker Richard tailor 590525 590525 Baker, Richard, of North Pederton, tailor 0
4668545 2255869 2255869 defendant Mauncell Richard   590525 590525 Mauncell, Richard, of North Pederton, franklin 1
4680230 2259426 2259426 defendant Ive Walter laborer 590525 590525 Ive, Walter, of North Pederton, laborer 0
4680231 2259426 2259426 defendant Ive John laborer 590525 590525 Ive, John, of North Pederton, laborer 1
4680232 2259426 2259426 defendant Ive Robert husbandman 590525 590525 Ive, Robert, of North Pederton, husbandman 2
4688798 2262051 2262051 defendant Mauncell Richard   590525 590525 Mauncell, Richard, of North Pederton, franklin 1
4696828 2264484 2264484 defendant Pyket John yeoman 590525 590525 Pyket, John, of North Pederton, yeoman 1
4696832 2264486 2264486 defendant Dollyng Robert laborer 590525 590525 Dollyng, Robert, of North Pederton, laborer 0
4709202 2268245 2268245 plaintiff Payn John   590525 590525 Payn, John, of North Pederton 0
4721678 2272115 2272115 defendant Pylet John yeoman 590525 590525 Pylet, John, of North Pederton, yeoman 0
4721679 2272115 2272115 defendant Claveleshey Gilbert yeoman 590525 590525 Claveleshey, Gilbert, of North Pederton, yeoman 1
4725593 2273291 2273291 defendant Potern Nicholas laborer 590525 590525 Potern, Nicholas, of North Pederton, laborer 1
4741803 2278094 2278094 defendant Lye Robert gent 590525 590525 Lye, Robert, of North Pederton, gent 1
4743801 2278716 2278716 defendant Parker Robert husbandman 590525 590525 Parker, Robert, of North Pederton, husbandman 2
4761377 2283901 2283901 defendant Glice John   590525 590525 Glice, John, of North Pederton, groom 2
4770030 2286599 2286599 defendant Keby John husbandman 590525 590525 Keby, John, of North Pederton, husbandman 0
4770035 2286600 2286600 defendant Deyman Robert husbandman 590525 590525 Deyman, Robert, of North Pederton, husbandman 1
4770036 2286600 2286600 defendant Englysshe John husbandman 590525 590525 Englysshe, John, of North Pederton, husbandman 2
4770037 2286600 2286600 defendant Gedy William husbandman 590525 590525 Gedy, William, of North Pederton, husbandman 3
4770038 2286600 2286600 defendant Michell (illegible) husbandman 590525 590525 Michell, _, of North Pederton, husbandman 4
4778420 2289230 2289230 defendant Mauncell John gent 590525 590525 Mauncell, John, of North Pederton, gent 0
4781408 2290193 2290193 defendant Batte Richard husbandman 590525 590525 Batte, Richard, of North Pederton, husbandman 2
4781409 2290193 2290193 defendant Batte John husbandman 590525 590525 Batte, John, of North Pederton, husbandman 3
4781410 2290193 2290193 defendant Raaff William   590525 590525 Raaff, William, of North Pederton, groom 4
4781411 2290193 2290193 defendant Smyth John laborer 590525 590525 Smyth, John, of North Pederton, laborer 5
4794674 2294472 2294472 defendant Deyman Robert husbandman 590525 590525 Deyman, Robert, of North Pederton, husbandman 1
4794675 2294472 2294472 defendant Englysshe John husbandman 590525 590525 Englysshe, John, of North Pederton, husbandman 2
4803738 2297351 2297351 defendant Scathelok Hugh husbandman 590525 590525 Scathelok, Hugh, of North Pederton, husbandman 0
4806382 2298208 2298208 defendant Templer William laborer 590525 590525 Templer, William, of North Pederton, laborer 0
4808201 2298743 2298743 defendant Assheton John yeoman 590525 590525 Assheton, John, of North Pederton, yeoman 0
4808202 2298743 2298743 defendant Devenyssh Thomas laborer 590525 590525 Devenyssh, Thomas, of North Pederton, laborer 1
4833120 2306374 2306374 defendant Habervyle John butcher 590525 590525 (Habervyle, John, of North Pederton, butcher 3
4833121 2306374 2306374 defendant Selewode John husbandman 590525 590525 Selewode, John, of North Pederton, husbandman 4
4848738 2311071 2311071 defendant Temesford John tailor 590525 590525 Temesford, John, of North Pederton, tailor 1
4848739 2311071 2311071 defendant Honegrove John laborer 590525 590525 Honegrove, John, of North Pederton, laborer 2
4849749 2311392 2311392 defendant Temesford John   590525 590525 Temesford, John, of North Pederton, holy water clerk 4
4849751 2311393 2311393 defendant Magot William yeoman 590525 590525 Magot, William, of North Pederton, yeoman 0
4861249 2314884 2314884 defendant Lobbe John husbandman 590525 590525 Lobbe, John, of North Pederton, husbandman 3
4864493 2315867 2315867 defendant Dayfote John clerk 590525 590525 Dayfote, John, of North Pederton, clerk 0
4876359 2319567 2319567 defendant Clavessey Gilbert husbandman 590525 590525 Clavessey, Gilbert, of North Pederton, husbandman 1
4876360 2319567 2319567 defendant Temesford John tailor 590525 590525 Temesford, John, of North Pederton, tailor 2
4876361 2319567 2319567 defendant Honegrove John laborer 590525 590525 Honegrove, John, of North Pederton, laborer 3
4880866 2320922 2320922 defendant Godehyve or Godehyne Margaret widow 590525 590525 (Godehyve or Godehyne, Margaret, of North Pederton, widow 1
4880867 2320922 2320922 defendant Keby John, junior husbandman 590525 590525 Keby, John, junior, of North Pederton, husbandman 2
4925872 2334525 2334525 defendant Squyer John husbandman 590525 590525 Squyer, John, of North Pederton, husbandman 0
4925873 2334525 2334525 defendant Badycok John husbandman 590525 590525 Badycok, John, of North Pederton, husbandman 1
4925874 2334525 2334525 defendant Cryche William husbandman 590525 590525 Cryche, William, of North Pederton, husbandman 2
4926338 2334662 2334662 defendant Wheler William carpenter 590525 590525 Wheler, William, of North Pederton, carpenter 1
4931056 2336107 2336107 defendant Gabell William husbandman 590525 590525 Gabell, William, of North Pederton, husbandman 2
4982910 2351799 2351799 defendant Cabbell William husbandman 590525 590525 Cabbell, William, of North Pederton, husbandman 2
4995124 2355395 2355395 defendant Magot William yeoman 590525 590525 Magot, William, of North Pederton, yeoman 2
5001081 2357193 2357193 defendant Andrewe John yeoman 590525 590525 Andrewe, John, of North Pederton, yeoman 3
5027700 2364976 2364976 defendant Andrewe John yeoman 590525 590525 Andrewe, John, of North Pederton, yeoman 3
5027703 2364977 2364977 plaintiff Mauncell John gent 590525 590525 Mauncell, John, of North Pederton, gent 0
5054470 2372912 2372912 defendant William David yeoman 590525 590525 William, David, of North Pederton, yeoman 0
5054472 2372913 2372913 defendant William David yeoman 590525 590525 William, David, of North Pederton, yeoman 0
5055209 2373137 2373137 defendant Haryngton Roberta widow 590525 590525 Haryngton, Roberta, of North Pederton, widow 1
5058545 2374111 2374111 defendant Dey Robert butcher 590525 590525 Dey, Robert, of North Pederton, butcher 2
5067992 2376928 2376928 defendant Glede John husbandman 590525 590525 Glede, John, of North Pederton, husbandman 1
5074934 2379010 2379010 defendant Bukwyll Robert husbandman 590525 590525 Bukwyll, Robert, of North Pederton, husbandman 0
5074935 2379010 2379010 defendant Payn William barber 590525 590525 Payn, William, of North Pederton, barber 1
5074938 2379010 2379010 defendant Burgeys William husbandman 590525 590525 Burgeys, William, of North Pederton, husbandman 4
5078331 2380011 2380011 defendant Haryngton Roberte widow 590525 590525 Haryngton, Roberte, of North Pederton, widow 0
5085661 2382205 2382205 defendant Marler William husbandman 590525 590525 Marler, William, of North Pederton, husbandman 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);