names

165 rows where place_id = 589302

✎ 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
3597151 1866732 1866732 defendant Clement John husbandman 589302 589302 Clement, John, of Abyndon, Berks, husbandman 0
3634830 1905694 1905694 defendant Bocher Richard butcher 589302 589302 Bocher, Richard, of Abyndon, Berks, butcher 0
3639732 1907235 1907235 defendant Wodeward Lionel innholder 589302 589302 Wodeward, Lionel, of Abyndon, Berks, innholder 0
3695722 1924892 1924892 defendant Skarlet Augustine dyer 589302 589302 Skarlet, Augustine, of Abyndon, Berks, dyer 0
3695726 1924893 1924893 defendant Skarlett Augustine dyer 589302 589302 Skarlett, Augustine, of Abyndon, Berks, dyer 0
3728990 1935313 1935313 defendant Flynt John draper 589302 589302 Flynt, John, of Abyndon, Berks, draper 0
3807504 1960252 1960252 defendant Graunge Christopher yeoman 589302 589302 Graunge, Christopher, of Abyndon, Berks, yeoman 1
3835966 1969161 1969161 defendant Webbe Thomas mercer 589302 589302 Webbe, Thomas, of Abyndon, Berks, mercer 2
3856009 1975504 1975504 defendant Sympson John chapman 589302 589302 Sympson, John, of Abyndon, Berks, chapman 2
3868890 1979837 1979837 defendant More Humphrey dyer 589302 589302 More, Humphrey, of Abyndon, Berks, dyer 0
3885209 1985304 1985304 defendant Jonys William chapman 589302 589302 Jonys, William, of Abyndon, Berks, chapman 0
3912830 1994623 1994623 plaintiff Audelett Katherine (legal representative) 589302 589302 Audelett, Katherine, of Abyndon, Berks, widow, executors of 0
4434721 2175623 2175623 defendant Neuman William   589302 589302 Neuman, William, of Abyndon, Berks 0
4434724 2175624 2175624 defendant Neuman William   589302 589302 Neuman, William, of Abyndon, Berks 0
4484060 2195708 2195708 plaintiff Parkhall Thomas dyer 589302 589302 Parkhall, Thomas, of Abyndon, Berks, dyer, on his own account 0
4496463 2199569 2199569 defendant Hull Thomas   589302 589302 Hull, Thomas, of Abyndon, Berks 3
4501019 2200921 2200921 plaintiff Lady Richard   589302 589302 Lady, Richard, of Abyndon, Berks, on his own account 0
4501021 2200922 2200922 plaintiff Lady Richard   589302 589302 Lady, Richard, of Abyndon, Berks, on his own account 0
4577786 2224561 2224561 plaintiff Chambre John   589302 589302 Chambre, John, of Abyndon, Berks 0
4605714 2232905 2232905 defendant Chaumbre John   589302 589302 Chaumbre, John, of Abyndon, Berks, son of William 0
4605719 2232906 2232906 defendant Chaumbre John   589302 589302 Chaumbre, John, of Abyndon, Berks, son of William 0
4652382 2246694 2246694 defendant Leche William   589302 589302 Leche, William, of Abyndon, Berks, leach 0
4652793 2246807 2246807 plaintiff Barbour Geoffrey merchant 589302 589302 Barbour, Geoffrey, of Abyndon, Berks, merchant 0
4671782 2256821 2256821 plaintiff Chaumbre William   589302 589302 Chaumbre, William, of Abyndon, Berks 0
4674321 2257576 2257576 defendant Elkyn John loader 589302 589302 Elkyn, John, of Abyndon, Berks, loader 1
4676024 2258112 2258112 defendant Spencer John hosteller 589302 589302 Spencer, John, of Abyndon, Berks, hosteller 0
4680791 2259611 2259611 defendant Westcote John yeoman 589302 589302 Westcote, John, of Abyndon, Bersk, yeoman 0
4682916 2260272 2260272 defendant Roose John fletcher 589302 589302 Roose, John, of Abyndon, Berks, fletcher 0
4686974 2261534 2261534 defendant Escote John yeoman 589302 589302 Escote, John, of Abyndon, Berks, yeoman 0
4697063 2264561 2264561 defendant Cardmaker Peter cardmaker 589302 589302 Cardmaker, Peter, of Abyndon, Berks, cardmaker 2
4707575 2267732 2267732 defendant Markyate Thomas smith 589302 589302 Markyate, Thomas, of Abyndon, Berks, smith 0
4717379 2270773 2270773 defendant Wolman Thomas husbandman 589302 589302 Wolman, Thomas, of Abyndon, Berks, husbandman 0
4717381 2270774 2270774 defendant Wolman Thomas husbandman 589302 589302 Wolman, Thomas, of Abyndon, Berks, husbandman 0
4722550 2272367 2272367 defendant Copelond William husbandman 589302 589302 Copelond, William, of Abyndon, Berks, husbandman 0
4723352 2272613 2272613 defendant More John cutler 589302 589302 More, John, of Abyndon, Berks, cutler 0
4742870 2278424 2278424 defendant Cardemaker Peter cardemaker 589302 589302 Cardemaker, Peter, of Abyndon, Berks, cardemaker 0
4747788 2279859 2279859 defendant Chambre Henry   589302 589302 Chambre, Henry, of Abyndon, Berks, gent, & son of William Chambre, deceased 0
4747796 2279861 2279861 defendant Draper John chapman 589302 589302 Draper, John, of Abyndon, Berks, chapman 0
4747798 2279862 2279862 defendant Draper John chapman 589302 589302 Draper, John, of Abyndon, Berks, chapman 0
4763789 2284664 2284664 defendant Chapman Richard chapman 589302 589302 Chapman, Richard, of Abyndon, Berks, chapman 0
4790440 2293097 2293097 defendant Bele Richard clerk 589302 589302 Bele, Richard, of Abyndon, Berks, clerk 2
4811144 2299594 2299594 defendant Stodame William spicer 589302 589302 Stodame, William, of Abyndon, Berks, spicer 0
4811924 2299843 2299843 defendant Holle Thomas chapman 589302 589302 Holle, Thomas, of Abyndon, Berks, chapman 3
4822137 2303000 2303000 defendant Yonge John spicer 589302 589302 Yonge, John, of Abyndon, Berks, spicer 0
4858917 2314167 2314167 defendant Holdeston Richard weaver 589302 589302 Holdeston, Richard, of Abyndon, Berks, weaver 0
4869250 2317349 2317349 plaintiff Kyng John fellmonger 589302 589302 Kyng, John, of Abyndon, Berks, fellmonger 0
4877451 2319902 2319902 defendant Grondy William husbandman 589302 589302 Grondy, William, of Abyndon, Berks, husbandman 0
4889088 2323378 2323378 defendant Oxped John chapman 589302 589302 Oxped, John, of Abyndon, Berks, chapman 1
4891212 2323985 2323985 plaintiff Cokkes Thomas   589302 589302 Cokkes, Thomas, of Abyndon, Berks 1
4894455 2324940 2324940 defendant Aperley William weaver 589302 589302 Aperley, William, of Abyndon, Berks, weaver 4
4896539 2325588 2325588 defendant Maynne Hugh yeoman 589302 589302 Maynne, Hugh, of Abyndon, Berks, yeoman 2
4910997 2329951 2329951 defendant Neubury Alan skinner 589302 589302 Neubury, Alan, of Abyndon, Berks, skinner 3
4912309 2330350 2330350 defendant Crumpe Ralph ostler 589302 589302 Crumpe, Ralph, of Abyndon, Bersk, ostler 2
4919380 2332572 2332572 defendant Chevyn Robert yeoman 589302 589302 Chevyn, Robert, of Abyndon, Berks, yeoman 0
4921242 2333158 2333158 defendant Wolmonger Thomas chapman 589302 589302 Wolmonger, Thomas, of Abyndon, Berks, chapman 4
4923483 2333777 2333777 defendant Knollys John (legal representative) 589302 589302 Knollys, John, of Abyndon, Berks, mercer, administratrix of 0
4923484 2333777 2333777 defendant Knollys Christine   589302 589302 Knollys, Christine, of Abyndon, Berks, widow, formerly wife of John Knollys 1
4941655 2339411 2339411 defendant Smart Richard chapman 589302 589302 Smart, Richard, of Abyndon, Berks, chapman 0
4943564 2339957 2339957 defendant Orped John butcher 589302 589302 Orped, John, of Abyndon, Berks, butcher 2
4954744 2343373 2343373 defendant atte Well John baker 589302 589302 atte Well, John, of Abyndon, Berks, baker 0
4956433 2343883 2343883 defendant Appurley William woolmonger 589302 589302 Appurley, William, of Abyndon, Berks, woolmonger 0
4957932 2344343 2344343 defendant Deryng John weaver 589302 589302 Deryng, John, of Abyndon, Berks, weaver 3
4960591 2345134 2345134 defendant Deryng John weaver 589302 589302 Deryng, John, of Abyndon, Berks, weaver 2
4964805 2346386 2346386 defendant Lilbone Walter ostler 589302 589302 Lilbone, Walter, of Abyndon, Berks, ostler 0
4965188 2346515 2346515 defendant Lynke John yeoman 589302 589302 Lynke, John, of Abyndon, Berks, yeoman 0
4975410 2349606 2349606 defendant Freman Robert yeoman 589302 589302 Freman, Robert, of Abyndon, Berks, yeoman 0
4980479 2351099 2351099 defendant Wodelef William hosyer 589302 589302 (Wodelef, William, of Abyndon, Berks, hosyer 1
4985747 2352654 2352654 defendant Bray Robert merchant 589302 589302 Bray, Robert, of Abyndon, Berks, merchant 0
4988606 2353549 2353549 defendant Bray Thomas ironmonger 589302 589302 Bray, Thomas, of Abyndon, Berks, ironmonger 0
4990413 2354045 2354045 defendant Wodestoke Thomas mercer 589302 589302 Wodestoke, Thomas, of Abyndon, Berks, mercer 1
4991216 2354257 2354257 defendant Wodestoke Thomas mercer 589302 589302 Wodestoke, Thomas, of Abyndon, Berks, mercer 1
5000333 2356968 2356968 defendant Sygore Henry mercer 589302 589302 Sygore, Henry, of Abyndon, Berks, mercer 4
5000359 2356971 2356971 defendant Sygore Henry mercer 589302 589302 Sygore, Henry, of Abyndon, Berks, mercer 4
5008685 2359434 2359434 defendant Freman Robert chapman 589302 589302 Freman, Robert, of Abyndon, Berks, chapman 0
5017258 2361931 2361931 defendant Frenssheman William   589302 589302 Frenssheman, William, of Abyndon, Berks, "velpoller" 0
5020078 2362759 2362759 defendant Mayne Hugh yeoman 589302 589302 Mayne, Hugh, of Abyndon, Berks, yeoman 0
5020080 2362760 2362760 defendant Mayne Hugh yeoman 589302 589302 Mayne, Hugh, of Abyndon, Berks, yeoman 0
5027150 2364809 2364809 defendant Wodelef William draper 589302 589302 Wodelef, William, of Abyndon, Berks, draper 0
5030111 2365678 2365678 defendant Dyer Nicholas dyer 589302 589302 Dyer, Nicholas, of Abyndon, Berks, dyer 1
5036034 2367395 2367395 defendant Walclyf John husbandman 589302 589302 (Walclyf, John, of Abyndon, Berks, husbandman 1
5039594 2368491 2368491 defendant Pert Thomas ostler 589302 589302 Pert, Thomas, of Abyndon, Berks, ostler 0
5042332 2369312 2369312 defendant Bray Edward merchant 589302 589302 Bray, Edward, of Abyndon, Berks, merchant 1
5048596 2371222 2371222 defendant Esterfeld William chapman 589302 589302 Esterfeld, William, of Abyndon, Berks, chapman 0
5060427 2374698 2374698 defendant Frensshe alias Stafford William chapman 589302 589302 Frensshe alias Stafford, William, of Abyndon, Berks, chapman 0
5067501 2376778 2376778 defendant Wodestoke John   589302 589302 Wodestoke, John, of Abyndon, Berks, kersey maker 0
5083067 2381445 2381445 defendant Hewe Patrick whitawer 589302 589302 Hewe, Patrick, of Abyndon, Berks, whitawer 1
5091783 2383980 2383980 defendant Penylot John draper 589302 589302 Penylot, John, of Abyndon, Berks, draper 3
5091792 2383981 2383981 defendant Penylot John draper 589302 589302 Penylot, John, of Abyndon, Berks, draper 3
5095779 2385189 2385189 defendant Bray Edward yeoman 589302 589302 Bray, Edward, of Abyndon, Berks, yeoman 1
5095783 2385190 2385190 defendant Bray Edward yeoman 589302 589302 Bray, Edward, of Abyndon, Berks, yeoman 1
5101626 2386899 2386899 defendant Courtenay Peter clerk 589302 589302 Courtenay, Peter, of Abyndon, Berks, clerk 0
5103965 2387584 2387584 defendant Salford John barber 589302 589302 Salford, John, of Abyndon, Berks, barber 3
5105147 2387944 2387944 defendant Smart Richard woolpacker 589302 589302 Smart, Richard, of Abyndon, Berks, woolpacker 0
5107648 2388667 2388667 defendant Somurset William yeoman 589302 589302 Somurset, William, of Abyndon, Berks, yeoman 0
5108892 2389020 2389020 defendant Bray William chapman 589302 589302 Bray, William, of Abyndon, Berks, chapman 0
5110880 2389579 2389579 defendant Bray Edward yeoman 589302 589302 Bray, Edward, of Abyndon, Berks, yeoman 0
5112459 2390030 2390030 defendant Okebourne William weaver 589302 589302 Okebourne, William, of Abyndon, Berks, weaver 0
5121324 2392671 2392671 defendant Jonysson alias Dyer Nicholas dyer 589302 589302 Jonysson alias Dyer, Nicholas, of Abyndon, Berks, dyer 2
5121328 2392672 2392672 defendant Jonysson alias Dyer Nicholas dyer 589302 589302 Jonysson alias Dyer, Nicholas, of Abyndon, Berks, dyer 2
5126086 2394112 2394112 defendant Aleyns Henry chapman 589302 589302 Aleyns, Henry, of Abyndon, Berks, chapman 3

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