names

106 rows where place_id = 591820

✎ 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
3605690 1869444 1869444 defendant Whethall alias Ambrose Peter butcher 591820 591820 Whethall alias Ambrose, Peter, of Harlowe, butcher 0
3608498 1870318 1870318 defendant Hoberd John   591820 591820 Hoberd, John, of Harlowe, tile maker 2
3624457 1875184 1875184 defendant Goos William husbandman 591820 591820 Goos, William, of Harlowe, husbandman 4
3688048 1922426 1922426 defendant Bouthe Lawrence husbandman 591820 591820 Bouthe, Lawrence, of Harlowe, husbandman 0
3694956 1924633 1924633 defendant Moyne Richard butcher 591820 591820 Moyne, Richard, of Harlowe, butcher 1
3704859 1927813 1927813 defendant Haver Lawrence husbandman 591820 591820 Haver, Lawrence, of Harlowe, husbandman 3
3708742 1929030 1929030 defendant Bugges Edward gent 591820 591820 Bugges, Edward, of Harlowe, gent 0
3715798 1931228 1931228 defendant Sewerer Thomas glover 591820 591820 Sewerer, Thomas, of Harlowe, glover 1
3715799 1931228 1931228 defendant Shakyll Thomas tiler 591820 591820 Shakyll, Thomas, of Harlowe, tiler 2
3715800 1931228 1931228 defendant Holgay John   591820 591820 Holgay, John, of Harlowe, wheelwright 3
3722055 1933162 1933162 defendant Inglond Thomas carpenter 591820 591820 Inglond, Thomas, of Harlowe, carpenter 0
3769478 1948114 1948114 defendant Raynold John husbandman 591820 591820 Raynold, John, of Harlowe, husbandman 1
3794223 1956065 1956065 defendant Ingold Thomas carpenter 591820 591820 Ingold, Thomas, of Harlowe, carpenter 3
3800721 1958138 1958138 defendant Buggys Margery widow 591820 591820 Buggys, Margery, of Harlowe, widow 0
3807737 1960308 1960308 defendant Bardall Thomas potter 591820 591820 Bardall, Thomas, of Harlowe, potter 1
3873386 1981314 1981314 defendant Thurgood Robert potter 591820 591820 Thurgood, Robert, of Harlowe, potter 0
3898145 1989588 1989588 defendant Fuller Roger brewer 591820 591820 Fuller, Roger, of Harlowe, brewer 0
3903987 1991573 1991573 defendant Campyon Edward gent 591820 591820 Campyon, Edward, of Harlowe, gent 0
3904989 1991933 1991933 defendant Brigman William shoemaker 591820 591820 Brigman, William, of Harlowe, shoemaker 0
3912071 1994360 1994360 defendant Westwood William husbandman 591820 591820 Westwood, William, of Harlowe, husbandman 0
3917613 1996249 1996249 defendant Campyon Edward gent 591820 591820 Campyon, Edward, of Harlowe, gent 0
3920475 1997195 1997195 defendant Campyon Edward gent 591820 591820 Campyon, Edward, of Harlowe, gent 2
3962493 2011476 2011476 defendant Kendall Michael maltman 591820 591820 Kendall, Michael, of Harlowe, maltman 0
4021754 2032506 2032506 defendant Bugges Anthony gent 591820 591820 Bugges, Anthony, of Harlowe, gent 0
4080388 2053296 2053296 defendant Jaxson Barnabe husbandman 591820 591820 Jaxson, Barnabe, of Harlowe, husbandman 13
4135958 2073195 2073195 defendant Bugg John gent 591820 591820 Bugg, John, of Harlowe, gent 0
4206567 2097839 2097839 defendant Claye John husbandman 591820 591820 Claye, John, of Harlowe, husbandman 13
4206568 2097839 2097839 defendant Catroll Thomas laborer 591820 591820 Catroll, Thomas, of Harlowe, laborer 14
4206584 2097840 2097840 defendant Cleye John husbandman 591820 591820 Cleye, John, of Harlowe, husbandman 13
4206585 2097840 2097840 defendant Catroll Thomas laborer 591820 591820 Catroll, Thomas, of Harlowe, laborer 14
4394279 2162685 2162685 defendant Read John fletcher 591820 591820 Read, John, of Harlowe, fletcher 0
4435847 2175960 2175960 plaintiff Prest John le   591820 591820 Prest, John le, of Harlowe 0
4507604 2202839 2202839 defendant atte Felde William   591820 591820 atte Felde, William, of Harlowe 2
4547545 2215164 2215164 defendant Kyng John   591820 591820 Kyng, John, of Harlowe 2
4727547 2273855 2273855 defendant Briggeman John wellegger 591820 591820 Briggeman, John, of Harlowe, wellegger 0
4790251 2293034 2293034 defendant Serle Richard   591820 591820 Serle, Richard, of Harlowe, bailiff 2
4847091 2310592 2310592 defendant Dobbes John yeoman 591820 591820 Dobbes, John, of Harlowe, yeoman 0
4848899 2311121 2311121 defendant Wasper Richard husbandman 591820 591820 Wasper, Richard, of Harlowe, husbandman 0
5029949 2365632 2365632 defendant Gladwyn John butcher 591820 591820 Gladwyn, John, of Harlowe, butcher 1
5029950 2365632 2365632 defendant Crowe John husbandman 591820 591820 Crowe, John, of Harlowe, husbandman 2
5073695 2378618 2378618 defendant Sewale Joan widow 591820 591820 Sewale, Joan, of Harlowe, widow 0
5078851 2380163 2380163 defendant Swerder Elias yeoman 591820 591820 Swerder, Elias, of Harlowe, yeoman 0
5078852 2380163 2380163 defendant Swerder Thomas husbandman 591820 591820 Swerder, Thomas, of Harlowe, husbandman 1
5102708 2387205 2387205 defendant Bugge Stephen esq 591820 591820 Bugge, Stephen, of Harlowe, esq 0
5143117 2399121 2399121 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 1
5145640 2399866 2399866 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 1
5149954 2401119 2401119 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 1
5150907 2401405 2401405 defendant Tylour John tiler 591820 591820 Tylour, John, of Harlowe, tiler 0
5161282 2404394 2404394 defendant Parker John chapman 591820 591820 Parker, John, of Harlowe, chapman 0
5166001 2405798 2405798 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 0
5169229 2406739 2406739 defendant Tylour John tiler 591820 591820 Tylour, John, of Harlowe, tiler 0
5169759 2406899 2406899 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 0
5180756 2410110 2410110 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 0
5180759 2410111 2410111 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 0
5180762 2410112 2410112 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 0
5185851 2411608 2411608 defendant Tyler John tiler 591820 591820 Tyler, John, of Harlowe, tiler 0
5185853 2411609 2411609 defendant Tyler John tiler 591820 591820 Tyler, John, of Harlowe, tiler 0
5186846 2411898 2411898 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 0
5186850 2411899 2411899 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 0
5186854 2411900 2411900 defendant Bardolf Thomas husbandman 591820 591820 Bardolf, Thomas, of Harlowe, husbandman 0
5207170 2417837 2417837 defendant Purfote John yeoman 591820 591820 Purfote, John, of Harlowe, yeoman 1
5214294 2419913 2419913 defendant Potter John husbandman 591820 591820 Potter, John, of Harlowe, husbandman 3
5214295 2419913 2419913 defendant Rampton Richard husbandman 591820 591820 Rampton, Richard, of Harlowe, husbandman 4
5253107 2431076 2431076 defendant Parker John mercer 591820 591820 Parker, John, of Harlowe, mercer 1
5297187 2444174 2444174 defendant Elyson Mary single woman 591820 591820 Elyson, Mary, of Harlowe, single woman 0
5320589 2451248 2451248 defendant Depeham Henry (legal representative) 591820 591820 Depeham, Henry, of Harlowe, miller, executors of 0
5321606 2451550 2451550 defendant Chyrcheman William yeoman 591820 591820 Chyrcheman, William, of Harlowe, yeoman 0
5324442 2452394 2452394 defendant Elys alias Recher Roger husbandman 591820 591820 Elys alias Recher, Roger, of Harlowe, husbandman 0
5332387 2454752 2454752 defendant Swyrder William yeoman 591820 591820 Swyrder, William, of Harlowe, yeoman 1
5342160 2457741 2457741 defendant Soles John butcher 591820 591820 Soles, John, of Harlowe, butcher 0
5345007 2458599 2458599 defendant Swerder William yeoman 591820 591820 Swerder, William, of Harlowe, yeoman 0
5346331 2458996 2458996 defendant Kentyssh John laborer 591820 591820 Kentyssh, John, of Harlowe, laborer 0
5346491 2459050 2459050 defendant Campyon John yeoman 591820 591820 Campyon, John, of Harlowe, yeoman 0
5348384 2459638 2459638 defendant Coke John butcher 591820 591820 Coke, John, of Harlowe, butcher 0
5353057 2461041 2461041 defendant Campyon John, senior husbandman 591820 591820 Campyon, John, senior, of Harlowe, husbandman 0
5353719 2461228 2461228 defendant Fordell John whitawer 591820 591820 Fordell, John, of Harlowe, whitawer 0
5353720 2461228 2461228 defendant Dawe John husbandman 591820 591820 Dawe, John, of Harlowe, husbandman 1
5353722 2461229 2461229 defendant Thurkyll John butcher 591820 591820 Thurkyll, John, of Harlowe, butcher 0
5371292 2466603 2466603 defendant Herd John husbandman 591820 591820 Herd, John, of Harlowe, husbandman 3
5371301 2466604 2466604 defendant Herd John husbandman 591820 591820 Herd, John, of Harlowe, husbandman 3
5377742 2468622 2468622 plaintiff Swerder William   591820 591820 Swerder, William, of Harlowe 1
5378132 2468738 2468738 defendant Moyne John potter 591820 591820 Moyne, John, of Harlowe, potter 0
5381460 2469760 2469760 defendant Herd John husbandman 591820 591820 Herd, John, of Harlowe, husbandman 2
5382756 2470132 2470132 defendant Swerder William yeoman 591820 591820 Swerder, William, of Harlowe, yeoman 0
5388918 2471893 2471893 defendant Herd John husbandman 591820 591820 Herd, John, of Harlowe, husbandman 2
5393141 2473109 2473109 defendant Swerder William yeoman 591820 591820 Swerder, William, of Harlowe, yeoman 0
5397785 2474435 2474435 defendant Symond John gent 591820 591820 Symond, John, of Harlowe, gent 0
5401636 2475534 2475534 defendant Herde John husbandman 591820 591820 Herde, John, of Harlowe, husbandman 2
5407331 2477159 2477159 defendant Swerder William yeoman 591820 591820 Swerder, William, of Harlowe, yeoman 0
5407333 2477160 2477160 defendant Swerder William yeoman 591820 591820 Swerder, William, of Harlowe, yeoman 0
5419434 2480730 2480730 defendant Swerder (illegible) yeoman 591820 591820 Swerder, _, of Harlowe, yeoman 0
5425108 2482473 2482473 defendant Symond John gent 591820 591820 Symond, John, of Harlowe, gent 0
5464491 2494301 2494301 defendant Hubberd John husbandman 591820 591820 Hubberd, John, of Harlowe, husbandman 0
5465264 2494516 2494516 defendant Robard John   591820 591820 Robard, John, of Harlowe, yeoman, servant of Roger Kenerston or Kynaston 1
5483083 2499881 2499881 defendant Simond John gent 591820 591820 Simond, John, of Harlowe, gent 0
5485252 2500507 2500507 defendant Weylot John yeoman 591820 591820 Weylot, John, of Harlowe, yeoman 0
5494914 2503375 2503375 defendant Sampson Thomas mercer 591820 591820 Sampson, Thomas, of Harlowe, mercer 0
5495766 2503627 2503627 defendant Priklove John butcher 591820 591820 Priklove, John, of Harlowe, butcher 1
5503658 2506058 2506058 defendant Priklove Robert   591820 591820 Priklove, Robert, of Harlowe, tallow chandler 0
5508459 2507515 2507515 defendant Bardolf John husbandman 591820 591820 Bardolf, John, of Harlowe, 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);