names

238 rows where place_id = 586608

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589207 1864267 1864267 defendant Bellenger Thomas yeoman 586608 586608 Bellenger, Thomas, of Newerk, Notts, yeoman 2
3598115 1867039 1867039 defendant Tayllour Edmund chapman 586608 586608 Tayllour, Edmund, of Newerk, Notts, chapman 2
3598805 1867253 1867253 defendant Shyre Thomas yeoman 586608 586608 Shyre, Thomas, of Newerk, Notts, yeoman 3
3598822 1867256 1867256 defendant Shyre Thomas yeoman 586608 586608 Shyre, Thomas, of Newerk, Notts, yeoman 3
3599250 1867409 1867409 defendant Wolghowse John dyer 586608 586608 Wolghowse, John, of Newerk, Notts, dyer 1
3608368 1870275 1870275 defendant Taillour Edmund mercer 586608 586608 Taillour, Edmund, of Newerk, Notts, mercer 1
3624226 1875109 1875109 defendant Smyth John clerk 586608 586608 Smyth, John, of Newerk, Notts, clerk 0
3626326 1903092 1903092 defendant Hall John chapman 586608 586608 Hall, John, of Newerk, Notts, chapman 1
3626782 1903223 1903223 defendant Halle John mercer 586608 586608 Halle, John, of Newerk, Notts, mercer 2
3631373 1904623 1904623 defendant Stabuls Christopher dyer 586608 586608 Stabuls, Christopher, of Newerk, Notts, dyer 0
3632700 1905045 1905045 defendant Halle John chapman 586608 586608 Halle, John, of Newerk, Notts, chapman 0
3650172 1910423 1910423 defendant Hall John mercer 586608 586608 Hall, John, of Newerk, Notts, mercer 0
3660557 1913563 1913563 plaintiff Holme John draper 586608 586608 Holme, John, of Newerk, Notts, draper 0
3691911 1923632 1923632 defendant Clerk Thomas mercer 586608 586608 Clerk, Thomas, of Newerk, Notts, mercer 0
3705352 1927963 1927963 defendant Jakson Robert draper 586608 586608 (Jakson, Robert, of Newerk, Notts, draper 2
3719440 1932353 1932353 defendant Symson John clerk 586608 586608 (Symson, John, of Newerk, Notts, clerk 4
3789562 1954563 1954563 defendant Lucas Richard gent 586608 586608 Lucas, Richard, of Newerk, Notts, gent 0
4491431 2198011 2198011 defendant Bildesthorp John   586608 586608 Bildesthorp, John, of Newerk, Notts 0
4657321 2248180 2248180 defendant Sele Thomas baker 586608 586608 Sele, Thomas, of Newerk, Notts, baker 0
4665335 2250648 2250648 defendant Kellum Robert   586608 586608 Kellum, Robert, of Newerk, Notts, "courteman" 0
4668660 2255911 2255911 defendant Betery Richard husbandman 586608 586608 Betery, Richard, of Newerk, Notts, husbandman 0
4675481 2257941 2257941 defendant Hulme Robert merchant 586608 586608 Hulme, Robert, of Newerk, Notts, merchant 0
4677376 2258541 2258541 defendant Danet John, junior husbandman 586608 586608 Danet, John, junior, of Newerk, Notts, husbandman 0
4677907 2258706 2258706 defendant Holm Robert merchant 586608 586608 Holm, Robert, of Newerk, Notts, merchant 0
4681084 2259712 2259712 defendant Kelom Robert gent 586608 586608 Kelom, Robert, of Newerk, Notts, gent 0
4681168 2259737 2259737 defendant Warde Nicholas mercer 586608 586608 Warde, Nicholas, of Newerk, Notts, mercer 0
4681548 2259840 2259840 defendant Warde Nicholas mercer 586608 586608 Warde, Nicholas, of Newerk, Notts, mercer 0
4681549 2259840 2259840 defendant Threstull Robert mercer 586608 586608 Threstull, Robert, of Newerk, Notts, mercer 1
4681818 2259924 2259924 defendant Holme Robert merchant 586608 586608 Holme, Robert, of Newerk, Notts, merchant 0
4689727 2262349 2262349 defendant Arnold William shipman 586608 586608 Arnold, William, of Newerk, Notts, shipman 1
4703781 2266561 2266561 defendant Baunebury John clerk 586608 586608 Baunebury, John, of Newerk, Notts, clerk 4
4705148 2266981 2266981 defendant Lytster Richard yeoman 586608 586608 Lytster, Richard, of Newerk, Notts, yeoman 0
4707237 2267643 2267643 defendant Holme Robert merchant 586608 586608 Holme, Robert, of Newerk, Notts, merchant 0
4714200 2269768 2269768 defendant Holme Robert merchant 586608 586608 Holme, Robert, of Newerk, Notts, merchant 0
4714482 2269859 2269859 defendant Beby John spicer 586608 586608 Beby, John, of Newerk, Notts, spicer 0
4716592 2270508 2270508 defendant Kellum Robert   586608 586608 Kellum, Robert, of Newerk, Notts, gent, alias of Cambridgeshire 0
4716594 2270509 2270509 defendant Kellom Robert   586608 586608 Kellom, Robert, of Newerk, Notts, gent, alias of Cambridgeshire 0
4720617 2271781 2271781 defendant Bonour Robert yeoman 586608 586608 Bonour, Robert, of Newerk, Notts, yeoman 0
4721145 2271948 2271948 defendant Myrfyn Thomas mercer 586608 586608 Myrfyn, Thomas, of Newerk, Notts, mercer 0
4721146 2271948 2271948 defendant Bonour Robert mercer 586608 586608 Bonour, Robert, of Newerk, Notts, mercer 1
4727212 2273771 2273771 defendant Horspole Margaret widow 586608 586608 Horspole, Margaret, of Newerk, Notts, widow 0
4728997 2274306 2274306 defendant Padlay Robert butcher 586608 586608 Padlay, Robert, of Newerk, Notts, butcher 0
4733340 2275603 2275603 defendant Brumme William mercer 586608 586608 Brumme, William, of Newerk, Notts, mercer 0
4738003 2276990 2276990 defendant Stokker Henry yeoman 586608 586608 Stokker, Henry, of Newerk, Notts, yeoman 0
4741794 2278091 2278091 defendant Seme William merchant 586608 586608 Seme, William, of Newerk, Notts, merchant 0
4746792 2279562 2279562 defendant Brume William mercer 586608 586608 Brume, William, of Newerk, Notts, mercer 0
4751378 2280880 2280880 defendant Hokurton John   586608 586608 Hokurton, John, of Newerk, Notts 4
4752001 2281081 2281081 defendant Warde Nicholas chapman 586608 586608 Warde, Nicholas, of Newerk, Notts, chapman 1
4752006 2281082 2281082 defendant Warde Nicholas chapman 586608 586608 Warde, Nicholas, of Newerk, Notts, chapman 1
4754602 2281823 2281823 defendant Howe John de dyer 586608 586608 Howe, John de, of Newerk, Notts, dyer 1
4758066 2282895 2282895 defendant Seme William merchant 586608 586608 Seme, William, of Newerk, Notts, merchant 0
4758514 2283043 2283043 defendant Mirfyn Thomas mercer 586608 586608 Mirfyn, Thomas, of Newerk, Notts, mercer 0
4759183 2283215 2283215 defendant Lake Margaret widow 586608 586608 Lake, Margaret, of Newerk, Notts, widow 0
4760986 2283781 2283781 defendant Fyssher John butcher 586608 586608 Fyssher, John, of Newerk, Notts, butcher 0
4764373 2284851 2284851 defendant Howe John dyer 586608 586608 Howe, John, of Newerk, Notts, dyer 1
4765782 2285296 2285296 defendant Taverner Thomas   586608 586608 Taverner, Thomas, of Newerk, Notts, shoe maker 1
4765789 2285299 2285299 defendant Padlay John butcher 586608 586608 Padlay, John, of Newerk, Notts, butcher 0
4772996 2287527 2287527 defendant Warde Nicholas chapman 586608 586608 Warde, Nicholas, of Newerk, Notts, chapman 1
4772999 2287527 2287527 defendant Holm Robert   586608 586608 Holm, Robert, of Newerk, Notts, wool man 4
4773173 2287578 2287578 defendant Killom John gent 586608 586608 Killom, John, of Newerk, Notts, gent 0
4773214 2287590 2287590 defendant Randolf Thomas fishmonger 586608 586608 Randolf, Thomas, of Newerk, Notts, fishmonger 1
4776576 2288667 2288667 defendant Thoresby John hosteler 586608 586608 Thoresby, John, of Newerk, Notts, hosteler 0
4781280 2290158 2290158 defendant Lake Margaret widow 586608 586608 Lake, Margaret, of Newerk, Notts, widow 0
4786902 2291965 2291965 defendant Porker Emma   586608 586608 Porker, Emma, of Newerk, Notts, widow of Porker, Richard 2
4788353 2292427 2292427 defendant Byby John spicer 586608 586608 Byby, John, of Newerk, Notts, spicer 2
4790268 2293040 2293040 defendant Litster Richard dyer 586608 586608 Litster, Richard, of Newerk, Notts, dyer 0
4790481 2293113 2293113 defendant Padlay John butcher 586608 586608 Padlay, John, of Newerk, Notts, butcher 0
4791873 2293561 2293561 defendant Belton William slater 586608 586608 Belton, William, of Newerk, Notts, slater 0
4797508 2295391 2295391 defendant Bolton John yeoman 586608 586608 Bolton, John, of Newerk, Notts, yeoman 2
4803187 2297189 2297189 defendant topclyfe Walter chapman 586608 586608 topclyfe, Walter, of Newerk, Notts, chapman 0
4803946 2297415 2297415 defendant Bolton William ostler 586608 586608 Bolton, William, of Newerk, Notts, ostler 0
4804825 2297710 2297710 defendant Moreby William husbandman 586608 586608 Moreby, William, of Newerk, Notts, husbandman 1
4807229 2298461 2298461 defendant Wakefeld Richard gent 586608 586608 Wakefeld, Richard, of Newerk, Notts, gent 0
4807231 2298462 2298462 defendant Wakeffeld Richard gent 586608 586608 Wakeffeld, Richard, of Newerk, Notts, gent 0
4807253 2298469 2298469 defendant Ponay John butcher 586608 586608 Ponay, John, of Newerk, Notts, butcher 1
4807600 2298568 2298568 defendant Padlee John chapman 586608 586608 Padlee, John, of Newerk, Notts, chapman 1
4807611 2298571 2298571 defendant Padlee John chapman 586608 586608 Padlee, John, of Newerk, Notts, chapman 1
4812090 2299892 2299892 defendant Topclyff Walter merchant 586608 586608 Topclyff, Walter, of Newerk, Notts, merchant 0
4815391 2300920 2300920 defendant Ponay John butcher 586608 586608 Ponay, John, of Newerk, Notts, butcher 1
4815633 2300996 2300996 defendant Grey Stephen yeoman 586608 586608 Grey, Stephen, of Newerk, Notts, yeoman 2
4820057 2302350 2302350 defendant Prentys Robert merchant 586608 586608 Prentys, Robert, of Newerk, Notts, merchant 1
4821363 2302765 2302765 defendant Wrygte William dyer 586608 586608 Wrygte, William, of Newerk, Notts, dyer 0
4822479 2303103 2303103 defendant Couper William butcher 586608 586608 Couper, William, of Newerk, Notts, butcher 0
4825901 2304133 2304133 defendant Scharchelok Robert shipman 586608 586608 Scharchelok, Robert, of Newerk, Notts, shipman 1
4827010 2304490 2304490 defendant thoresby John hosteler 586608 586608 thoresby, John, of Newerk, Notts, hosteler 1
4827285 2304582 2304582 defendant Wykham Robert spicer 586608 586608 Wykham, Robert, of Newerk, Notts, spicer 3
4829309 2305206 2305206 defendant Topclyffe Walter merchant 586608 586608 Topclyffe, Walter, of Newerk, Notts, merchant 0
4832060 2306056 2306056 defendant Mendyng John cooper 586608 586608 Mendyng, John, of Newerk, Notts, cooper 6
4832063 2306057 2306057 defendant Mendyng John cooper 586608 586608 Mendyng, John, of Newerk, Notts, cooper 1
4838640 2308011 2308011 defendant Mendyng John cooper 586608 586608 Mendyng, John, of Newerk, Notts, cooper 5
4839657 2308321 2308321 defendant Fyssher John fisher 586608 586608 Fyssher, John, of Newerk, Notts, fisher 0
4842709 2309257 2309257 defendant Moreby William butcher 586608 586608 Moreby, William, of Newerk, Notts, butcher 3
4848937 2311133 2311133 defendant Mendyng John cooper 586608 586608 together with Mendyng, John, of Newerk, Notts, cooper 5
4849202 2311224 2311224 plaintiff Spondon John   586608 586608 Spondon, John, of Newerk, Notts 0
4864008 2315719 2315719 defendant Kayser John gent 586608 586608 Kayser, John, of Newerk, Notts, gent 2
4864017 2315721 2315721 defendant Kayser William gent 586608 586608 Kayser, William, of Newerk, Notts, gent 2
4874257 2318894 2318894 defendant Blawnkeney Thomas gent 586608 586608 Blawnkeney, Thomas, of Newerk, Notts, gent 0
4883560 2321776 2321776 defendant Carlhill Richard chapman 586608 586608 Carlhill, Richard, of Newerk, Notts, chapman 0
4895334 2325199 2325199 defendant Bene William chapman 586608 586608 Bene, William, of Newerk, Notts, chapman 1
4900727 2326866 2326866 defendant Clerk John glover 586608 586608 Clerk, John, of Newerk, Notts, glover 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);