names

107 rows where place_id = 588200

✎ 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
3593722 1865676 1865676 defendant Turve John baker 588200 588200 Turve, John, of Higham Ferrers, baker 1
3593723 1865676 1865676 defendant Wyngrave Thomas laborer 588200 588200 Wyngrave, Thomas, of Higham Ferrers, laborer 2
3655751 1912058 1912058 plaintiff Broun George   588200 588200 Broun, George, of Higham Ferrers 0
3656409 1912250 1912250 defendant Pytman John butcher 588200 588200 Pytman, John, of Higham Ferrers, butcher 0
3935439 2002165 2002165 plaintiff Kyddall Thomas gent 588200 588200 Kyddall, Thomas, of Higham Ferrers, gent 0
3945377 2005469 2005469 plaintiff Bottom or Botton John baker 588200 588200 Bottom or Botton, John, of Higham Ferrers, baker 0
3945378 2005469 2005469 defendant Yarner Thomas baker 588200 588200 Yarner, Thomas, of Higham Ferrers, baker 0
4063508 2047236 2047236 defendant Saunderson George yeoman 588200 588200 Saunderson, George, of Higham Ferrers, yeoman 0
4064588 2047616 2047616 defendant Saunderson George yeoman 588200 588200 Saunderson, George, of Higham ferrers, yeoman 0
4173736 2086270 2086270 defendant Hayes Robert yeoman 588200 588200 Hayes, Robert, of Higham Ferrers, yeoman 3
4257063 2115335 2115335 defendant Rapitt William yeoman 588200 588200 Rapitt, William, of Higham Ferrers, yeoman 3
4269323 2119330 2119330 defendant Rapitt William yeoman 588200 588200 Rapitt, William, of Higham Ferrers, yeoman 3
4323453 2138262 2138262 defendant Barnard William yeoman 588200 588200 Barnard, William, of Higham Ferrers, yeoman 1
4584582 2226594 2226594 defendant Golde Roger   588200 588200 Golde, Roger, of Higham Ferrers 0
4584584 2226595 2226595 defendant Golde Roger   588200 588200 Golde, Roger, of Higham Ferrers 0
4621898 2237830 2237830 defendant Marschall Stephen   588200 588200 Marschall, Stephen, of Higham Ferrers 1
4669202 2256072 2256072 defendant Bocher Simon butcher 588200 588200 Bocher, Simon, of Higham Ferrers, butcher 0
4685331 2261009 2261009 defendant Milner Robert chaplain 588200 588200 Milner, Robert, of Higham Ferrers, chaplain 0
4685332 2261009 2261009 defendant Sherman John sheerman 588200 588200 Sherman, John, of Higham Ferrers, sheerman 1
4685333 2261009 2261009 defendant Rose John laborer 588200 588200 Rose, John, of Higham Ferrers, laborer 2
4762938 2284392 2284392 defendant Marchall Stephen husbandman 588200 588200 Marchall, Stephen, of Higham Ferrers, husbandman 0
4762939 2284392 2284392 defendant Marchall William husbandman 588200 588200 Marchall, William, of Higham Ferrers, husbandman 1
4769281 2286371 2286371 defendant Marchell Stephen husbandman 588200 588200 Marchell, Stephen, of Higham Ferrers, husbandman 0
4769283 2286371 2286371 defendant Babworth John husbandman 588200 588200 Babworth, John, of Higham Ferrers, husbandman 2
4770008 2286591 2286591 defendant Broun William   588200 588200 Broun, William, of Higham Ferrers, horse dealer 0
4798197 2295630 2295630 defendant Sadeler William husbandman 588200 588200 Sadeler, William, of Higham Ferrers, husbandman 1
4798198 2295630 2295630 defendant Chapman Nicholas husbandman 588200 588200 Chapman, Nicholas, of Higham Ferrers, husbandman 2
4928632 2335384 2335384 defendant Walker William drover 588200 588200 Walker, William, of Higham Ferrers, drover 1
4931657 2336290 2336290 defendant Bryan John shoemaker 588200 588200 Bryan, John, of Higham Ferrers, shoemaker 1
4935928 2337629 2337629 defendant Barbour John barber 588200 588200 Barbour, John, of Higham Ferrers, barber 1
4947817 2341298 2341298 defendant Chauntery John gent 588200 588200 Chauntery, John, of Higham Ferrers, gent 0
4948728 2341586 2341586 defendant Barbour John barber 588200 588200 Barbour, John, of Higham Ferrers, barber 0
4948729 2341586 2341586 defendant Couper William butcher 588200 588200 Couper, William, of Higham Ferrers, butcher 1
4964668 2346339 2346339 defendant Bocher William butcher 588200 588200 Bocher, William, of Higham Ferrers, butcher 2
5014589 2361133 2361133 defendant Irlond Robert yeoman 588200 588200 Irlond, Robert, of Higham Ferrers, yeoman 0
5024244 2364005 2364005 defendant Draper John yeoman 588200 588200 Draper, John, of Higham Ferrers, yeoman 0
5044899 2370110 2370110 defendant Wodcok John butcher 588200 588200 Wodcok, John, of Higham Ferrers, butcher 0
5050686 2371831 2371831 defendant Drewell John barber 588200 588200 Drewell, John, of Higham Ferrers, barber 1
5051022 2371915 2371915 defendant Martyn Thomas mercer 588200 588200 Martyn, Thomas, of Higham Ferrers, mercer 2
5051023 2371915 2371915 defendant White Richard clerk 588200 588200 White, Richard, of Higham Ferrers, clerk 3
5065855 2376309 2376309 defendant Wryght Nicholas chapman 588200 588200 Wryght, Nicholas, of Higham Ferrers, chapman 0
5067893 2376896 2376896 defendant Parker William husbandman 588200 588200 Parker, William, of Higham Ferrers, husbandman 1
5067894 2376896 2376896 defendant Lyd Richard husbandman 588200 588200 Lyd, Richard, of Higham Ferrers, husbandman 2
5069794 2377459 2377459 defendant Whyte Richard clerk 588200 588200 Whyte, Richard, of Higham Ferrers, clerk 0
5074313 2378813 2378813 defendant Chaundelrye John gent 588200 588200 Chaundelrye, John, of Higham Ferrers, gent 0
5074314 2378813 2378813 defendant Chaundelrye Richard gent 588200 588200 Chaundelrye, Richard, of Higham Ferrers, gent 1
5108439 2388903 2388903 defendant Parys Richard grasier 588200 588200 Parys, Richard, of Higham Ferrers, grasier 1
5108442 2388904 2388904 defendant Parys Richard grasier 588200 588200 Parys, Richard, of Higham Ferrers, grasier 1
5108728 2388989 2388989 defendant Welles John yeoman 588200 588200 Welles, John, of Higham Ferrers, yeoman 1
5109694 2389262 2389262 defendant Blokke John dyer 588200 588200 Blokke, John, of Higham Ferrers, dyer 0
5111810 2389846 2389846 defendant Somner Edmund butcher 588200 588200 Somner, Edmund, of Higham Ferrers, butcher 0
5111811 2389846 2389846 defendant Bere William baker 588200 588200 Bere, William, of Higham Ferrers, baker 1
5114783 2390736 2390736 defendant Pekerell Henry chandler 588200 588200 Pekerell, Henry, of Higham Ferrers, chandler 0
5114784 2390736 2390736 defendant Hampton John yeoman 588200 588200 Hampton, John, of Higham Ferrers, yeoman 1
5114788 2390736 2390736 defendant Broun William butcher 588200 588200 Broun, William, of Higham Ferrers, butcher 5
5118403 2391819 2391819 defendant Somnour Edmund courser 588200 588200 Somnour, Edmund, of Higham Ferrers, courser 0
5118404 2391819 2391819 defendant Smyth Richard smith 588200 588200 Smyth, Richard, of Higham Ferrers, smith 1
5138337 2397723 2397723 defendant Druell John husbandman 588200 588200 Druell, John, of Higham Ferrers, husbandman 2
5138339 2397723 2397723 defendant Felyon William husbandman 588200 588200 Felyon, William, of Higham Ferrers, husbandman 4
5155489 2402765 2402765 defendant Draper Henry laborer 588200 588200 Draper, Henry, of Higham Ferrers, laborer 0
5155490 2402765 2402765 defendant Broun William butcher 588200 588200 Broun, William, of Higham Ferrers, butcher 1
5155492 2402765 2402765 defendant Barowe Ralph   588200 588200 Barowe, Ralph, of Higham Ferrers, paten maker 3
5155493 2402765 2402765 defendant Pykerell Henry chandler 588200 588200 Pykerell, Henry, of Higham Ferrers, chandler 4
5163044 2404918 2404918 defendant Bette John husbandman 588200 588200 Bette, John, of Higham Ferrers, husbandman 0
5163550 2405072 2405072 defendant Blok William dyer 588200 588200 Blok, William, of Higham Ferrers, dyer 0
5163552 2405073 2405073 defendant Blok William dyer 588200 588200 Blok, William, of Higham Ferrers, dyer 0
5170472 2407092 2407092 defendant Peeke Thomas husbandman 588200 588200 Peeke, Thomas, of Higham Ferrers, husbandman 0
5170474 2407092 2407092 defendant Jafers Thomas husbandman 588200 588200 Jafers, Thomas, of Higham Ferrers, husbandman 2
5176868 2408924 2408924 defendant Bocher William butcher 588200 588200 Bocher, William, of Higham Ferrers, butcher 2
5177155 2409012 2409012 defendant Blok William dyer 588200 588200 Blok, William, of Higham Ferrers, dyer 0
5188228 2412270 2412270 defendant Peke Thomas husbandman 588200 588200 Peke, Thomas, of Higham Ferrers, husbandman 0
5188230 2412270 2412270 defendant Jafers Thomas husbandman 588200 588200 Jafers, Thomas, of Higham Ferrers, husbandman 2
5210214 2418713 2418713 defendant Smyth Agnes   588200 588200 Smyth, Agnes, of Higham Ferrers, widow, formerly wife of John Smyth 0
5214022 2419832 2419832 defendant Broun William butcher 588200 588200 Broun, William, of Higham Ferrers, butcher 1
5218198 2421051 2421051 defendant Blokke William dyer 588200 588200 Blokke, William, of Higham Ferrers, dyer 2
5219987 2421556 2421556 defendant Garnon Thomas chaplain 588200 588200 Garnon, Thomas, of Higham Ferrers, chaplain 0
5238441 2426832 2426832 defendant Sculle William husbandman 588200 588200 Sculle, William, of Higham Ferrers, husbandman 2
5239528 2427143 2427143 defendant Wyngrave John tailor 588200 588200 Wyngrave, John, of Higham Ferrers, tailor 4
5250059 2430126 2430126 defendant Burgh Peter clerk 588200 588200 Burgh, Peter, of Higham Ferrers, clerk 0
5250163 2430163 2430163 defendant Sawyer Thomas sawyer 588200 588200 Sawyer, Thomas, of Higham Ferrers, sawyer 0
5252900 2431020 2431020 defendant Chauntre William clerk 588200 588200 Chauntre, William, of Higham Ferrers, clerk 0
5261347 2433658 2433658 defendant Loy John tailor 588200 588200 Loy, John, of Higham Ferrers, tailor 0
5270424 2436449 2436449 defendant Gilford John husbandman 588200 588200 Gilford, John, of Higham Ferrers, husbandman 2
5270425 2436449 2436449 defendant Napton William husbandman 588200 588200 Napton, William, of Higham Ferrers, husbandman 3
5276574 2438224 2438224 defendant Bryam William clerk 588200 588200 Bryam, William, of Higham Ferrers, clerk 2
5276578 2438225 2438225 defendant Bryan William clerk 588200 588200 Bryan, William, of Higham Ferrers, clerk 2
5310541 2448189 2448189 defendant Maxe Roger tailor 588200 588200 Maxe, Roger, of Higham Ferrers, tailor 1
5310543 2448189 2448189 defendant Sergeaunt John smith 588200 588200 Sergeaunt, John, of Higham Ferrers, smith 3
5327796 2453385 2453385 plaintiff Walter William (legal representative) 588200 588200 Walter, William, of Higham Ferrers, executors of 0
5358326 2462658 2462658 defendant Launcelyn William glover 588200 588200 Launcelyn, William, of Higham Ferrers, glover 0
5358327 2462658 2462658 defendant Cours John tanner 588200 588200 Cours, John, of Higham Ferrers, tanner 1
5358329 2462658 2462658 defendant Langeley Alexander laborer 588200 588200 Langeley, Alexander, of Higham Ferrers, laborer 3
5362266 2463858 2463858 defendant Grey Thomas laborer 588200 588200 Grey, Thomas, of Higham Ferrers, laborer 5
5363053 2464094 2464094 defendant Alen William hosier 588200 588200 Alen, William, of Higham Ferrers, hosier 0
5363054 2464094 2464094 defendant Bere William baker 588200 588200 Bere, William, of Higham Ferrers, baker 1
5363055 2464094 2464094 defendant Launselyn William glover 588200 588200 Launselyn, William, of Higham Ferrers, glover 2
5363056 2464094 2464094 defendant Bere John, senior husbandman 588200 588200 Bere, John, senior, of Higham Ferrers, husbandman 3
5389820 2472151 2472151 defendant Wodehous Thomas hardwareman 588200 588200 Wodehous, Thomas, of Higham Ferrers, hardwareman 2
5402626 2475825 2475825 defendant Wodehous Thomas   588200 588200 Wodehous, Thomas, of Higham Ferrers, hardware man 2
5415547 2479591 2479591 defendant Wodehous Thomas   588200 588200 Wodehous, Thomas, of Higham Ferrers, hardware man 1

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