names

94 rows where place_id = 592546

✎ 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
3608029 1870162 1870162 defendant Coxall William clothier 592546 592546 Coxall, William, of Abendon, Berks, clothier 2
3618703 1873472 1873472 defendant Shakburn John yeoman 592546 592546 Shakburn, John, of Abendon, Berks, yeoman 2
3650328 1910477 1910477 defendant Est William   592546 592546 Est, William, of Abendon, Berks, freemason 0
3659897 1913353 1913353 defendant Haryson William tailor 592546 592546 Haryson, William, of Abendon, Berks, tailor 0
3689755 1922953 1922953 defendant Skarlett Augustine dyer 592546 592546 Skarlett, Augustine, of Abendon, Berks, dyer 0
3696958 1925272 1925272 defendant Audelett John yeoman 592546 592546 Audelett, John, of Abendon, Berks, yeoman 0
3700270 1926320 1926320 defendant Assheton Christopher draper 592546 592546 Assheton, Christopher, of Abendon, Berks, draper 0
3707045 1928490 1928490 defendant Stallok Robert laborer 592546 592546 Stallok, Robert, of Abendon, Berks, laborer 1
3771507 1948782 1948782 plaintiff Syngylton William pewterer 592546 592546 Syngylton, William, of Abendon, Berks, pewterer 0
3805113 1959541 1959541 plaintiff Stone Thomas gent 592546 592546 Stone, Thomas, of Abendon, Berks, gent 0
3810660 1961233 1961233 plaintiff Assheton Christopher draper 592546 592546 Assheton, Christopher, of Abendon, Berks, draper 1
3828931 1966931 1966931 defendant Pynfold William butcher 592546 592546 Pynfold, William, of Abendon, Berks, butcher 0
3828934 1966932 1966932 defendant Pynfold William butcher 592546 592546 Pynfold, William, of Abendon, Berks, butcher 0
3857444 1975963 1975963 plaintiff Asshton Christopher draper 592546 592546 Asshton, Christopher, of Abendon, Berks, draper 0
3857446 1975964 1975964 plaintiff Asshton Christopher draper 592546 592546 Asshton, Christopher, of Abendon, Berks, draper 0
3894175 1988268 1988268 plaintiff Rede Thomas   592546 592546 Rede, Thomas, of Abendon, Berks 0
3927732 1999613 1999613 defendant Smyth William   592546 592546 Smyth, William, of Abendon, Berks, inn holder 0
4004020 2026212 2026212 plaintiff Hyde Oliver (legal representative) 592546 592546 Hyde, Oliver, of Abendon, Berks, gent, administrator of 0
4577788 2224562 2224562 plaintiff Chambre William   592546 592546 Chambre, William, of Abendon, Berks 0
4683393 2260408 2260408 defendant Fyssher William fisher 592546 592546 Fyssher, William, of Abendon, Berks, fisher 2
4784258 2291075 2291075 defendant Plymmeswode Thomas dyer 592546 592546 Plymmeswode, Thomas, of Abendon, Berks, dyer 0
4808872 2298942 2298942 defendant Perneys or Perveys Robert husbandman 592546 592546 Perneys or Perveys, Robert, of Abendon, Berks, husbandman 0
4808876 2298943 2298943 defendant Perveys Robert husbandman 592546 592546 Perveys, Robert, of Abendon, Berks, husbandman 0
4855516 2313087 2313087 defendant Seman John glover 592546 592546 Seman, John, of Abendon, Berks, glover 0
4855518 2313088 2313088 defendant Seman John glover 592546 592546 Seman, John, of Abendon, Berks, glover 0
4880185 2320714 2320714 defendant Cheveyn Robert merchant 592546 592546 Cheveyn, Robert, of Abendon, Berks, merchant 0
4908440 2329195 2329195 defendant Dyer John dyer 592546 592546 Dyer, John, of Abendon, Bersk, dyer 1
4910300 2329738 2329738 defendant Middelton John whittauwyer or sadler 592546 592546 Middelton, John, of Abendon, Berks, whittauwyer or sadler 0
4914378 2331012 2331012 defendant Prent John copeler or maker of fasteners 592546 592546 Prent, John, of Abendon, Berks, copeler or maker of fasteners 1
4916372 2331622 2331622 defendant Gybbys Edward ironmonger 592546 592546 Gybbys, Edward, of Abendon, Berks, ironmonger 0
4917337 2331933 2331933 defendant Crompe Ralph chapman 592546 592546 Crompe, Ralph, of Abendon, Berks, chapman 0
4918324 2332249 2332249 defendant Lynke John yeoman 592546 592546 Lynke, John, of Abendon, Berks, yeoman 0
4923466 2333770 2333770 defendant Wolmonger Stephen husbandman 592546 592546 Wolmonger, Stephen, of Abendon, Berks, husbandman 0
4929929 2335772 2335772 defendant Howell Mathew   592546 592546 Howell, Mathew, of Abendon, Berks, coryour or leather worker 0
4950353 2342076 2342076 plaintiff Palet John yeoman 592546 592546 Palet, John, of Abendon, Berks, yeoman 0
4957371 2344168 2344168 defendant Webbe Reginald weaver 592546 592546 Webbe, Reginald, of Abendon, Berks, weaver 0
5013479 2360779 2360779 defendant Mereweder John gent 592546 592546 Mereweder, John, of Abendon, Berks, gent 2
5030651 2365834 2365834 defendant Wyllys John fuller 592546 592546 Wyllys, John, of Abendon, Berks, fuller 0
5038971 2368301 2368301 defendant Bray Thomas chapman 592546 592546 Bray, Thomas, of Abendon, Berks, chapman 0
5047250 2370800 2370800 defendant Brydde Robert weaver 592546 592546 Brydde, Robert, of Abendon, Berks, weaver 0
5054175 2372841 2372841 defendant Willys John fuller 592546 592546 Willys, John, of Abendon, Berks, fuller 0
5066334 2376460 2376460 plaintiff Momford John skinner 592546 592546 Momford, John, of Abendon, Berks, skinner 0
5069631 2377413 2377413 defendant Hales William merchant 592546 592546 Hales, William, of Abendon, Berks, merchant 0
5071151 2377864 2377864 defendant Bagge John chapman 592546 592546 Bagge, John, of Abendon, Berks, chapman 0
5083947 2381701 2381701 defendant Bagge John chapman 592546 592546 Bagge, John, of Abendon, Berks, chapman 0
5090427 2383579 2383579 defendant Barbury Robert gent 592546 592546 Barbury, Robert, of Abendon,Berks, gent 2
5101218 2386767 2386767 defendant Suthwyk Thomas esq 592546 592546 Suthwyk,Thomas, of Abendon, Berks, esq 0
5103960 2387583 2387583 defendant Raa William gent 592546 592546 Raa, William, of Abendon, Berks, gent 2
5122739 2393084 2393084 defendant Hervy Lawrence fuller 592546 592546 Hervy, Lawrence, of Abendon, Berks, fuller 1
5139402 2398011 2398011 defendant Sextan Matilda widow 592546 592546 Sextan, Matilda, of Abendon, Berks, widow 1
5180532 2410052 2410052 defendant Devyle Hugh yeoman 592546 592546 Devyle, Hugh, of Abendon, Berks, yeoman 0
5205936 2417472 2417472 defendant Wodestoke John chapman 592546 592546 Wodestoke, John, of Abendon, Berks, chapman 0
5225798 2423217 2423217 defendant Sexteyn Maud widow 592546 592546 Sexteyn, Maud, of Abendon, Berks, widow 3
5229454 2424225 2424225 defendant Gaunte Nicholas chandler 592546 592546 Gaunte, Nicholas, of Abendon, Berks, chandler 0
5238974 2426990 2426990 defendant Bray William chapman 592546 592546 Bray, William, of Abendon, Berks, chapman 0
5240153 2427324 2427324 defendant Bray William chapman 592546 592546 Bray, William, of Abendon, Berks, chapman 0
5244600 2428604 2428604 plaintiff Plesaunce Thomas   592546 592546 Plesaunce, Thomas, of Abendon, Berks 0
5250008 2430114 2430114 defendant Ford Roger chapman 592546 592546 Ford, Roger, of Abendon, Berks, chapman 1
5266617 2435311 2435311 defendant Bagge John chapman 592546 592546 Bagge, John, of Abendon, Berks, chapman 0
5292355 2442765 2442765 defendant Joonson Nicholas dyer 592546 592546 Joonson, Nicholas, of Abendon, Berks, dyer 0
5292359 2442766 2442766 defendant Joonson Nicholas dyer 592546 592546 Joonson, Nicholas, of Abendon, Berks, dyer 0
5296366 2443928 2443928 defendant Walclyffe John yeoman 592546 592546 Walclyffe, John, of Abendon, Berks, yeoman 2
5326019 2452875 2452875 defendant Lorde John yeoman 592546 592546 Lorde, John, of Abendon, Berks, yeoman 1
5331182 2454401 2454401 defendant Pytwyn Robert husbandman 592546 592546 Pytwyn, Robert, of Abendon, Berks, husbandman 2
5337657 2456333 2456333 defendant Pomeray William gent 592546 592546 Pomeray, William, of Abendon, Berks, gent 0
5364336 2464505 2464505 defendant Pape Nicholas mercer 592546 592546 Pape, Nicholas, of Abendon, Berks, mercer 0
5365150 2464772 2464772 defendant Ayleton Thomas gent 592546 592546 Ayleton, Thomas, of Abendon, Berks, gent 1
5367024 2465333 2465333 defendant Dyer Thomas dyer 592546 592546 Dyer, Thomas, of Abendon, Berks, dyer 1
5383786 2470446 2470446 plaintiff Ayketon Thomas gent 592546 592546 Ayketon, Thomas, of Abendon, Berks, gent 0
5389384 2472009 2472009 defendant Wynchester Henry draper 592546 592546 Wynchester, Henry, of Abendon, Berks, draper 0
5393358 2473156 2473156 defendant Love or Lone Thomas (legal representative) 592546 592546 Love or Lone, Thomas, of Abendon, Berks, clothier, executrix of 1
5395616 2473827 2473827 plaintiff Ayleton Thomas gent 592546 592546 Ayleton, Thomas, of Abendon, Berks, gent 0
5402063 2475651 2475651 defendant Wynchester Henry draper 592546 592546 Wynchester, Henry, of Abendon, Berks, draper 0
5406550 2476942 2476942 defendant Love Thomas (legal representative) 592546 592546 Love, Thomas, of Abendon, Berks, yeoman, executrix of 1
5406551 2476942 2476942 defendant Love Alice widow 592546 592546 Love, Alice, of Abendon, Berks, widow 2
5410514 2478089 2478089 defendant Aylton Thomas gent 592546 592546 Aylton, Thomas, of Abendon, Berks, gent 0
5412576 2478706 2478706 defendant Mayne John draper 592546 592546 Mayne, John, of Abendon, Berks, draper 0
5414983 2479413 2479413 defendant Wynchester Henry draper 592546 592546 Wynchester, Henry, of Abendon, Berks, draper 0
5418608 2480490 2480490 defendant Mayne John draper 592546 592546 Mayne, John, of Abendon, Berks, draper 0
5436563 2485868 2485868 defendant Mayne John draper & merchant 592546 592546 Mayne, John, of Abendon, Berks, draper & merchant 0
5436567 2485869 2485869 defendant Meyne John draper 592546 592546 Meyne, John, of Abendon, Berks, draper 0
5436570 2485870 2485870 defendant Meyne John draper & merchant 592546 592546 Meyne, John, of Abendon, Berks, draper & merchant 0
5438535 2486461 2486461 defendant Mayne John Draper 592546 592546 Mayne, John, of Abendon, Berks, Draper 3
5465210 2494497 2494497 defendant Hurst Thomas fuller 592546 592546 Hurst, Thomas, of Abendon, Berks, fuller 0
5482352 2499664 2499664 plaintiff Harryes Thomas gent 592546 592546 Harryes, Thomas, of Abendon, Berks, or of of Northlache, gent 0
5493590 2502996 2502996 defendant Hille John gent 592546 592546 Hille, John, of Abendon, Berks, gent 0
5494541 2503253 2503253 defendant Mayne John draper 592546 592546 Mayne, John, of Abendon, Berks, draper 0
5539736 2516908 2516908 defendant Comber Richard fishmonger 592546 592546 Comber, Richard, of Abendon, Berks, fishmonger 0
5572630 2526539 2526539 defendant Harryson William tailor 592546 592546 Harryson, William, of Abendon, Berks, tailor 3
5572636 2526540 2526540 defendant Harryson William tailor 592546 592546 Harryson, William, of Abendon, Berks, tailor 3
5590766 2532084 2532084 defendant Hill John (legal representative) 592546 592546 Hill, John, of Abendon, Berks, gent, executor of 0
5608331 2537512 2537512 defendant Ayleton Thomas gent 592546 592546 Ayleton, Thomas, of Abendon, Berks, gent 1
5633732 2554549 2554549 defendant Croweley John chapman 592546 592546 Croweley, John, of Abendon, Berks, chapman 1
5633735 2554550 2554550 defendant Croweley John chapman 592546 592546 Croweley, John, of Abendon, Berks, chapman 1

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