names

133 rows where place_id = 603464

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654625 1911708 1911708 defendant Hough John butcher 603464 603464 Hough, John, of Bedford, Beds, butcher 4
3927120 1999408 1999408 defendant Pyke Edmund yeoman 603464 603464 Pyke, Edmund, of Bedford, Beds, yeoman 0
3929336 2000155 2000155 defendant Capn William chapman 603464 603464 Capn, William, of Bedford, Beds, chapman 1
3938397 2003184 2003184 defendant Capon William chapman 603464 603464 Capon, William, of Bedford, Beds, chapman 1
4681694 2259883 2259883 defendant Hermer John chapman 603464 603464 Hermer, John, of Bedford, Beds, chapman 3
4698682 2265069 2265069 defendant Newell John husbandman 603464 603464 Newell, John, of Bedford, Beds, husbandman 0
4698755 2265092 2265092 defendant Dove William husbandman 603464 603464 Dove, William, of Bedford, Beds, husbandman 0
4707544 2267728 2267728 defendant Hermer John   603464 603464 Hermer, John, of Bedford, Beds, sergeaunt 2
4707567 2267731 2267731 defendant Hermere John   603464 603464 Hermere, John, of Bedford, Beds, sergeant 2
4708546 2268042 2268042 defendant Welborne William   603464 603464 Welborne, William, of Bedford, Beds, notary 0
4723019 2272508 2272508 defendant Sundon William dyer 603464 603464 Sundon, William, of Bedford, Beds, dyer 1
4731238 2274969 2274969 defendant Welburn William clerk & notary 603464 603464 Welburn, William, of Bedford, Beds, clerk & notary 0
4733300 2275591 2275591 defendant Everdon William husbandman 603464 603464 Everdon, William, of Bedford, Beds, husbandman 0
4736903 2276669 2276669 defendant Wryghte John carpenter 603464 603464 Wryghte, John, of Bedford, Beds, carpenter 2
4741882 2278123 2278123 defendant Gose William shoemaker 603464 603464 Gose, William, of Bedford, Beds, shoemaker 1
4741885 2278124 2278124 defendant Gose William shoemaker 603464 603464 Gose, William, of Bedford, Beds, shoemaker 1
4752694 2281247 2281247 defendant Newell John yeoman 603464 603464 Newell, John, of Bedford, Beds, yeoman 0
4752770 2281265 2281265 defendant Bole Thomas husbandman 603464 603464 Bole, Thomas, of Bedford, Beds, husbandman 3
4753834 2281576 2281576 defendant Bull Thomas husbandman 603464 603464 Bull, Thomas, of Bedford, Beds, husbandman 0
4754177 2281685 2281685 defendant Everdon William butcher 603464 603464 Everdon, William, of Bedford, Beds, butcher 0
4764068 2284749 2284749 defendant Checheley John spicer 603464 603464 Checheley, John, of Bedford, Beds, spicer 0
4766909 2285641 2285641 defendant Chechele John   603464 603464 Chechele, John, of Bedford, Beds, spice man 0
4769935 2286569 2286569 defendant Chicheley John   603464 603464 Chicheley, John, of Bedford, Beds, spice seller 0
4802436 2296954 2296954 defendant Baker Walter husbandman 603464 603464 Baker, Walter, of Bedford, Beds, husbandman 2
4816356 2301204 2301204 defendant Pasmer Thomas   603464 603464 Pasmer, Thomas, of Bedford, Beds, bow maker 0
4816358 2301205 2301205 defendant Bachelder John   603464 603464 Bachelder, John, of Bedford, Beds, bow maker 0
4822913 2303248 2303248 defendant Clerk Richard butcher 603464 603464 Clerk, Richard, of Bedford, Beds, butcher 1
4826408 2304296 2304296 defendant Tounesende Thomas dyer 603464 603464 Tounesende, Thomas, of Bedford, Beds, dyer 0
4827237 2304570 2304570 defendant Foullere John husbandman 603464 603464 Foullere, John, of Bedford, Beds, husbandman 1
4827248 2304573 2304573 defendant Fuller John husbandman 603464 603464 Fuller, John, of Bedford, Beds, husbandman 1
4828729 2305027 2305027 defendant Lyttylbury John   603464 603464 Lyttylbury, John, of Bedford, Beds, wool man 1
4836289 2307326 2307326 defendant May Richard yeoman 603464 603464 May, Richard, of Bedford, Beds, yeoman 1
4836542 2307400 2307400 defendant Bette William   603464 603464 Bette, William, of Bedford, Beds, wool man 0
4836545 2307401 2307401 defendant Bette William   603464 603464 Bette, William, of Bedford, Beds, wool man 0
4837022 2307537 2307537 defendant Halle Richard yeoman 603464 603464 Halle, Richard, of Bedford, Beds, yeoman 1
4840644 2308612 2308612 defendant Spark Henry yeoman 603464 603464 Spark, Henry, of Bedford, Beds, yeoman 3
4843965 2309628 2309628 defendant Hermer John ostler 603464 603464 Hermer, John, of Bedford, Beds, ostler 2
4853042 2312369 2312369 defendant Bull Thomas husbandman 603464 603464 Bull, Thomas, of Bedford, Beds, husbandman 4
4853048 2312371 2312371 defendant Bull Thomas husbandman 603464 603464 Bull, Thomas, of Bedford, Beds, husbandman 2
4907822 2329008 2329008 defendant Litelbury John husbandman 603464 603464 Litelbury, John, of Bedford, Beds, husbandman 0
4908586 2329241 2329241 defendant Spycer William chapman 603464 603464 Spycer, William, of Bedford, Beds, chapman 2
4908591 2329242 2329242 defendant Spycer William chapman 603464 603464 Spycer, William, of Bedford, Beds, chapman 1
4912378 2330373 2330373 defendant Bledworth Robert goldsmith 603464 603464 Bledworth, Robert, of Bedford, Beds, goldsmith 0
4915775 2331433 2331433 defendant Crosse John tailor 603464 603464 Crosse, John, of Bedford, Beds, tailor 0
4916256 2331589 2331589 defendant Gardener Willam yeoman 603464 603464 Gardener, Willam, of Bedford, Beds, yeoman 1
4916262 2331591 2331591 defendant Gardener William yeoman 603464 603464 Gardener, William, of Bedford, Beds, yeoman 2
4916844 2331770 2331770 defendant White Richard tailor 603464 603464 White, Richard, of Bedford, Beds, tailor 3
4919084 2332481 2332481 defendant Ade William yeoman 603464 603464 Ade, William, of Bedford, Beds, yeoman 0
4920240 2332842 2332842 defendant Bole Ralph yeoman 603464 603464 Bole, Ralph, of Bedford, Beds, yeoman 0
4925105 2334283 2334283 defendant Chapman John tanner 603464 603464 Chapman, John, of Bedford, Beds, tanner 5
4926026 2334570 2334570 defendant Hunt William draper 603464 603464 Hunt, William, of Bedford, Beds, draper 0
4926037 2334572 2334572 defendant Hunt William draper 603464 603464 Hunt, William, of Bedford, Beds, draper 0
4927734 2335111 2335111 defendant Hunte William husbandman 603464 603464 Hunte, William, of Bedford, Beds, husbandman 0
4929004 2335498 2335498 defendant Molond John husbandman 603464 603464 Molond, John, of Bedford, Beds, husbandman 0
4990434 2354051 2354051 defendant Rychard John chapman 603464 603464 Rychard, John, of Bedford, Beds, chapman 1
4990438 2354052 2354052 defendant Bette William   603464 603464 Bette, William, of Bedford, Beds, wool man 0
4990449 2354056 2354056 defendant Rychard John chapman 603464 603464 Rychard, John, of Bedford, Beds, chapman 1
4995791 2355585 2355585 defendant Brynkell John master of the hospital of St John Baptist 603464 603464 Brynkell, John, of Bedford, Beds, master of the hospital of St John Baptist 0
4995793 2355586 2355586 defendant Brynkell John master of the hospital of St John Baptist 603464 603464 Brynkell, John, of Bedford, Beds, master of the hospital of St John Baptist 0
5011321 2360172 2360172 defendant Spicer William yeoman 603464 603464 Spicer, William, of Bedford, Beds, yeoman 0
5012236 2360429 2360429 defendant Richard Richard chapman 603464 603464 Richard, Richard, of Bedford, Beds, chapman 0
5012238 2360429 2360429 defendant Lomney Thomas   603464 603464 Lomney, Thomas, of Bedford, Beds, sergeant 2
5045508 2370285 2370285 defendant Furbour Richard   603464 603464 Furbour, Richard, of Bedford, Beds, furbour 0
5051483 2372056 2372056 defendant Forstall John yeoman 603464 603464 Forstall, John, of Bedford, Beds, yeoman 1
5130650 2395455 2395455 defendant Danyell William chapman 603464 603464 Danyell, William, of Bedford, Beds, chapman 0
5138782 2397842 2397842 defendant Wattys Thomas husbandman 603464 603464 Wattys, Thomas, of Bedford, Beds, husbandman 1
5138917 2397881 2397881 defendant Hunt William husbandman 603464 603464 Hunt, William, of Bedford, Beds, husbandman 1
5151006 2401433 2401433 defendant Stowe Thomas yeoman 603464 603464 Stowe, Thomas, of Bedford, Beds, yeoman 2
5151852 2401692 2401692 defendant Heyward John yeoman 603464 603464 Heyward, John, of Bedford, Beds, yeoman 0
5151854 2401692 2401692 defendant Moreys Ralph husbandman 603464 603464 Moreys, Ralph, of Bedford, Beds, husbandman 2
5151910 2401698 2401698 defendant Heyward John yeoman 603464 603464 Heyward, John, of Bedford, Beds, yeoman 0
5151912 2401698 2401698 defendant Moreys Ralph husbandman 603464 603464 Moreys, Ralph, of Bedford, Beds, husbandman 2
5155143 2402653 2402653 defendant Litulbury John glasier 603464 603464 Litulbury, John, of Bedford, Beds, glasier 1
5159812 2403970 2403970 defendant Hunt William husbandman 603464 603464 Hunt, William, of Bedford, Beds, husbandman 1
5169847 2406923 2406923 defendant Heyward John yeoman 603464 603464 Heyward, John, of Bedford, Beds, yeoman 0
5169849 2406923 2406923 defendant Moreys Ralph husbandman 603464 603464 Moreys, Ralph, of Bedford, Beds, husbandman 2
5174775 2408323 2408323 defendant Hunt William husbandman 603464 603464 Hunt, William, of Bedford, Beds, husbandman 0
5187043 2411945 2411945 defendant Heyward John yeoman 603464 603464 Heyward, John, of Bedford, Beds, yeoman 0
5192420 2413519 2413519 defendant Cumnore William husbandman 603464 603464 Cumnore, William, of Bedford, Beds, husbandman 0
5193503 2413825 2413825 defendant Goldyng Ralph baker 603464 603464 Goldyng, Ralph, of Bedford, Beds, baker 3
5193518 2413827 2413827 defendant Digill Denise widow 603464 603464 Digill, Denise, of Bedford, Beds, widow 5
5195607 2414465 2414465 defendant Hunt William husbandman 603464 603464 Hunt, William, of Bedford, Beds, husbandman 0
5199012 2415462 2415462 defendant Messenger William yeoman 603464 603464 Messenger, William, of Bedford, Beds, yeoman 4
5199018 2415463 2415463 defendant Messenger William yeoman 603464 603464 Messenger, William, of Bedford, Beds, yeoman 4
5199201 2415518 2415518 defendant John Hugh yeoman 603464 603464 John, Hugh, of Bedford, Beds, yeoman 0
5199203 2415519 2415519 defendant John Hugh yeoman 603464 603464 John, Hugh, of Bedford, Beds, yeoman 0
5201127 2416091 2416091 defendant Terry John yeoman 603464 603464 Terry, John, of Bedford, Beds, yeoman 2
5207158 2417835 2417835 defendant Wellys William carpenter 603464 603464 Wellys, William, of Bedford, Beds, carpenter 1
5210881 2418914 2418914 defendant Messanger William yeoman 603464 603464 Messanger, William, of Bedford, Beds, yeoman 1
5211000 2418951 2418951 defendant John Hugh yeoman 603464 603464 John, Hugh, of Bedford, Beds, yeoman 0
5269217 2436102 2436102 defendant Terre John yeoman 603464 603464 Terre, John, of Bedford, Beds, yeoman 0
5269221 2436103 2436103 defendant Terre John yeoman 603464 603464 Terre, John, of Bedford, Beds, yeoman 0
5271857 2436860 2436860 defendant Passhe Thomas yeoman 603464 603464 Passhe, Thomas, of Bedford, Beds, yeoman 13
5273135 2437214 2437214 defendant Terre Seth gent 603464 603464 (Terre, Seth, of Bedford, Beds, gent 1
5273666 2437376 2437376 defendant Stodeley John mercer 603464 603464 Stodeley, John, of Bedford, Beds, mercer 0
5274686 2437674 2437674 defendant Terry Seth gent 603464 603464 Terry, Seth, of Bedford, Beds, gent 0
5303700 2446100 2446100 defendant Doweson John yeoman 603464 603464 Doweson, John, of Bedford, Beds, yeoman 0
5307986 2447406 2447406 defendant Iffold Richard chapman 603464 603464 Iffold, Richard, of Bedford, Beds, chapman 0
5365342 2464833 2464833 defendant Lawe Richard yeoman 603464 603464 Lawe, Richard, of Bedford, Beds, yeoman 2
5369267 2465988 2465988 defendant Plukrose John yeoman 603464 603464 Plukrose, John, of Bedford, Beds, yeoman 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);