names

124 rows where place_id = 592545

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608027 1870162 1870162 defendant Genyn alias Denyce or Devyce Edward mercer 592545 592545 Genyn alias Denyce or Devyce, Edward, of Basyngstoke, Hants, mercer 0
3614974 1872328 1872328 defendant Hechecok Henry chapman 592545 592545 Hechecok, Henry, of Basyngstoke, Hants, chapman 1
3621628 1874303 1874303 defendant Cordall William yeoman 592545 592545 Cordall, William, of Basyngstoke, Hants, yeoman 3
3621634 1874304 1874304 defendant Cordall William yeoman 592545 592545 Cordall, William, of Basyngstoke, Hants, yeoman 4
3629886 1904201 1904201 defendant Bowyer John mercer 592545 592545 Bowyer, John, of Basyngstoke, Hants, mercer 0
3641689 1907857 1907857 defendant Wyg John clothier 592545 592545 Wyg, John, of Basyngstoke, Hants, clothier 3
3642758 1908183 1908183 defendant Lytherlond John yeoman 592545 592545 Lytherlond, John, of Basyngstoke, Hants, yeoman 1
3650944 1910666 1910666 defendant Genyn alias Denyce Edward mercer 592545 592545 Genyn alias Denyce, Edward, of Basyngstoke, Hants, mercer 0
3655910 1912102 1912102 defendant Hoskyns John draper 592545 592545 (Hoskyns, John, of Basyngstoke, Hants, draper 1
3655918 1912103 1912103 defendant Hoskyns John draper 592545 592545 (Hoskyns, John, of Basyngstoke, Hants, draper 1
3656089 1912156 1912156 defendant West John butcher 592545 592545 West, John, of Basyngstoke, Hants, butcher 1
3663283 1914442 1914442 defendant Sheppard Henry alias Harry dyer 592545 592545 Sheppard, Henry alias Harry, of Basyngstoke, Hants, dyer 0
3663411 1914481 1914481 defendant Sheppard Henry dyer 592545 592545 Sheppard, Henry, of Basyngstoke, Hants, dyer 1
3663428 1914488 1914488 defendant Sheppard Henry dyer 592545 592545 Sheppard, Henry, of Basyngstoke, Hants, dyer 2
3679134 1919541 1919541 defendant Toley Robert smith 592545 592545 Toley, Robert, of Basyngstoke, Hants, smith 3
3701123 1926598 1926598 defendant Kent Elizabeth widow 592545 592545 Kent, Elizabeth, of Basyngstoke, Hants, widow 3
3717923 1931907 1931907 defendant Walter alias Maynard John yeoman 592545 592545 Walter alias Maynard, John, of Basyngstoke, Hants, yeoman 0
3723358 1933574 1933574 defendant Palmer John clothier 592545 592545 Palmer, John, of Basyngstoke, Hants, clothier 0
3734875 1937148 1937148 defendant Sawyer Thomas smith 592545 592545 Sawyer, Thomas, of Basyngstoke, Hants, smith 0
3751787 1942479 1942479 defendant Parman John clothmaker 592545 592545 Parman, John, of Basyngstoke, Hants, clothmaker 3
3760645 1945330 1945330 defendant Ronynger or Rovynger John mercer 592545 592545 Ronynger or Rovynger, John, of Basyngstoke, Hants, mercer 1
3778363 1950946 1950946 defendant Patyn Richard mercer 592545 592545 Patyn, Richard, of Basyngstoke, Hants, mercer 0
3781507 1951955 1951955 defendant Brocas John gent 592545 592545 Brocas, John, of Basyngstoke, Hants, gent 1
3781528 1951960 1951960 defendant Brocas John gent 592545 592545 Brocas, John, of Basyngstoke, Hants, gent 1
3782982 1952425 1952425 defendant Towe John   592545 592545 Towe, John, of Basyngstoke, Hants, shipwright or gunner 1
3790485 1954847 1954847 defendant Walter alias Maynard John innholder 592545 592545 Walter alias Maynard, John, of Basyngstoke, Hants, innholder 0
3798693 1957503 1957503 defendant South Richard tailor 592545 592545 South, Richard, of Basyngstoke, Hants, tailor 0
3802359 1958637 1958637 defendant Hall Richard clothmaker 592545 592545 Hall, Richard, of Basyngstoke, Hants, clothmaker 2
3804960 1959495 1959495 defendant Reycher alias Richer John clothman 592545 592545 Reycher alias Richer, John, of Basyngstoke, Hants, clothman 1
3804967 1959497 1959497 defendant Hanyngton Richard chapman 592545 592545 Hanyngton, Richard, of Basyngstoke, Hants, chapman 1
3820277 1964215 1964215 defendant Alye Henry clothier 592545 592545 Alye, Henry, of Basyngstoke, Hants, clothier 0
3820279 1964216 1964216 defendant Alye Henry clothier 592545 592545 Alye, Henry, of Basyngstoke, Hants, clothier 0
3838546 1969980 1969980 defendant Hannyngton Richard clothmaker 592545 592545 Hannyngton, Richard, of Basyngstoke, Hants, clothmaker 0
3838549 1969981 1969981 defendant Hannyngton Richard clothmaker 592545 592545 Hannyngton, Richard, of Basyngstoke, Hants, clothmaker 0
3846623 1972499 1972499 defendant Harvyngton Richard clothman 592545 592545 Harvyngton, Richard, of Basyngstoke, Hants, clothman 1
3846649 1972506 1972506 defendant Harvyngton Richard clothman 592545 592545 Harvyngton, Richard, of Basyngstoke, Hants, clothman 1
3872663 1981073 1981073 defendant Payne Thomas blacksmith 592545 592545 Payne, Thomas, of Basyngstoke, Hants, blacksmith 2
3873266 1981275 1981275 defendant Stocker Richard yeoman 592545 592545 Stocker, Richard, of Basyngstoke, Hants, yeoman 0
3873382 1981313 1981313 defendant Vunnaden Richard merchant 592545 592545 Vunnaden, Richard, of Basyngstoke, Hants, merchant 2
3882054 1984257 1984257 defendant Bee John clothier 592545 592545 Bee, John, of Basyngstoke, Hants, clothier 0
3882058 1984259 1984259 defendant Bee John clothier 592545 592545 Bee, John, of Basyngstoke, Hants, clothier 0
3882060 1984260 1984260 defendant Dee John clothier 592545 592545 Dee, John, of Basyngstoke, Hants, clothier 0
3887992 1986235 1986235 defendant Kyntt Richard innholder 592545 592545 Kyntt, Richard, of Basyngstoke, Hants, innholder 0
3894836 1988478 1988478 defendant Bye John clothier 592545 592545 Bye, John, of Basyngstoke, Hants, clothier 0
3899759 1990135 1990135 defendant Dyer William clothier 592545 592545 Dyer, William, of Basyngstoke, Hants, clothier 0
3909975 1993643 1993643 defendant Bye John clothier 592545 592545 Bye, John, of Basyngstoke, Hants, clothier 0
3920750 1997287 1997287 defendant Deane James (legal representative) 592545 592545 Deane, James, of Basyngstoke, Hants, clothier, administratrix of 2
3930893 2000672 2000672 defendant Kyng Robert alias Richard (legal representative) 592545 592545 Kyng, Robert alias Richard, of Basyngstoke, Hants, mercer, executors of 0
3943151 2004725 2004725 defendant Slyng Richard dyer 592545 592545 Slyng, Richard, of Basyngstoke, Hants, dyer 0
3956001 2009169 2009169 defendant Ley Thomas mercer 592545 592545 Ley, Thomas, of Basyngstoke, Hants, mercer 1
3956079 2009195 2009195 defendant Gawen John mercer 592545 592545 Gawen, John, of Basyngstoke, Hants, mercer 2
3974737 2015730 2015730 defendant Renygare John chapman 592545 592545 Renygare, John, of Basyngstoke, Hants, chapman 0
3997992 2024040 2024040 defendant Wheatestrawe Richard smith 592545 592545 Wheatestrawe, Richard, of Basyngstoke, Hants, smith 2
4135030 2072852 2072852 defendant Lee John, senior shoemaker 592545 592545 Lee, John, senior, of Basyngstoke, Hants, shoemaker 0
4135033 2072853 2072853 defendant Lee William baker 592545 592545 Lee, William, of Basyngstoke, Hants, baker 0
4156397 2080312 2080312 defendant Kerrye Thomas esq 592545 592545 Kerrye, Thomas, of Basyngstoke, Hants, esq 0
4233086 2107079 2107079 defendant Yeat George glover 592545 592545 Yeat, George, of Basyngstoke, Hants, glover 0
4496457 2199568 2199568 defendant Parker John   592545 592545 Parker, John, of Basyngstoke, Hants 2
4666437 2250980 2250980 defendant Vyns William esq 592545 592545 Vyns, William, of Basyngstoke, Hants, esq 1
4675753 2258023 2258023 defendant Fenyngle Richard gent 592545 592545 (Fenyngle, Richard, of Basyngstoke, Hants, gent 1
4685664 2261108 2261108 defendant Tank or Tauk William gent 592545 592545 Tank or Tauk, William, of Basyngstoke, Hants, gent 0
4688790 2262050 2262050 defendant Fyge John ostler 592545 592545 Fyge, John, of Basyngstoke, Hants, ostler 1
4694075 2263648 2263648 defendant Fynlegh Richard gent 592545 592545 Fynlegh, Richard, of Basyngstoke, Hants, gent 0
4803100 2297157 2297157 defendant Austyn William carpenter 592545 592545 Austyn, William, of Basyngstoke, Hants, carpenter 0
4803102 2297158 2297158 defendant Austyn William carpenter 592545 592545 Austyn, William, of Basyngstoke, Hants, carpenter 0
4812366 2299979 2299979 defendant Grete John butcher 592545 592545 Grete, John, of Basyngstoke, Hants, butcher 3
4860844 2314751 2314751 defendant Bettys John gent 592545 592545 (Bettys, John, of Basyngstoke, Hants, gent 5
4876262 2319536 2319536 defendant Kylhogge John ostler 592545 592545 Kylhogge, John, of Basyngstoke, Hants, ostler 1
4898324 2326133 2326133 defendant Cosyn William husbandman 592545 592545 Cosyn, William, of Basyngstoke, Hants, husbandman 2
4901541 2327085 2327085 defendant William Thomas carpenter 592545 592545 William, Thomas, of Basyngstoke, Hants, carpenter 1
4931836 2336344 2336344 defendant Whyte John ostler 592545 592545 Whyte, John, of Basyngstoke, Hants, ostler 0
4939043 2338599 2338599 defendant Fyns Katherine widow 592545 592545 (Fyns, Katherine, of Basyngstoke, Hants, widow 5
4959102 2344690 2344690 defendant Byle William gent 592545 592545 Byle, William, of Basyngstoke, Hants, or of London, gent 3
4959107 2344691 2344691 defendant Byle William gent 592545 592545 Byle, William, of Basyngstoke, Hants, or of London, gent 3
4959965 2344942 2344942 defendant Forster John clerk 592545 592545 Forster, John, of Basyngstoke, Hants, clerk 2
5021486 2363190 2363190 defendant Barnet William husbandman 592545 592545 Barnet, William, of Basyngstoke, Hants, husbandman 0
5084536 2381887 2381887 defendant Bramley Edmund brasier 592545 592545 Bramley, Edmund, of Basyngstoke, Hants, brasier 0
5098741 2386060 2386060 defendant Foweler John   592545 592545 Foweler, John, of Basyngstoke, Hants, bailiff 2
5133185 2396184 2396184 defendant Dyker Robert gent 592545 592545 Dyker, Robert, of Basyngstoke, Hants, gent 0
5152981 2402010 2402010 defendant Dyker Robert gent 592545 592545 Dyker, Robert, of Basyngstoke, Hants, gent 0
5220035 2421569 2421569 defendant Spyrke John yeoman 592545 592545 Spyrke, John, of Basyngstoke, Hants, yeoman 0
5225033 2422992 2422992 defendant Cordale Thomas brasier 592545 592545 Cordale, Thomas, of Basyngstoke, Hants, brasier 3
5330571 2454232 2454232 defendant Grenewey Thomas yeoman 592545 592545 Grenewey, Thomas, of Basyngstoke, Hants, yeoman 3
5361550 2463635 2463635 defendant Bowyer alias Chaundeler John chapman 592545 592545 Bowyer alias Chaundeler, John, of Basyngstoke, Hants, chapman 3
5361555 2463636 2463636 defendant Chaundeler John chapman or husbandman 592545 592545 Chaundeler, John, of Basyngstoke, Hants, chapman or husbandman 3
5361557 2463637 2463637 defendant Bowyer alias Chaundeler John chapman or husbandman 592545 592545 Bowyer alias Chaundeler, John, of Basyngstoke, Hants, chapman or husbandman 0
5365381 2464846 2464846 defendant Potton Robert mercer 592545 592545 Potton, Robert, of Basyngstoke, Hants, mercer 0
5371978 2466827 2466827 defendant Byle Peter clerk 592545 592545 Byle, Peter, of Basyngstoke, Hants, clerk 0
5391502 2472642 2472642 defendant Stevens William innholder 592545 592545 Stevens, William, of Basyngstoke, Hants, innholder 0
5398457 2474617 2474617 defendant Potyn Robert mercer 592545 592545 Potyn, Robert, of Basyngstoke, Hants, mercer 3
5411596 2478423 2478423 defendant Potyn Robert mercer 592545 592545 Potyn, Robert, of Basyngstoke, Hants, mercer 4
5420749 2481131 2481131 defendant Bayly Richard gent 592545 592545 Bayly, Richard, of Basyngstoke, Hants, gent 0
5425897 2482705 2482705 defendant Potyn Robert mercer 592545 592545 Potyn, Robert, of Basyngstoke, Hants, mercer 4
5425900 2482706 2482706 defendant Potyn Robert mercer 592545 592545 Potyn, Robert, of Basyngstoke, Hants, mercer 0
5431242 2484288 2484288 defendant Byle Peter clerk 592545 592545 Byle, Peter, of Basyngstoke, Hants, clerk 0
5435335 2485505 2485505 defendant Stevens William innholder 592545 592545 Stevens, William, of Basyngstoke, Hants, innholder 0
5439638 2486797 2486797 defendant Baily Richard gent 592545 592545 Baily, Richard, of Basyngstoke, Hants, gent 0
5447718 2489193 2489193 defendant Byle Peter clerk 592545 592545 Byle, Peter, of Basyngstoke, Hants, clerk 0
5460141 2492966 2492966 defendant Byle Peter clerk 592545 592545 Byle, Peter, of Basyngstoke, Hants, clerk 0
5460143 2492967 2492967 defendant Byle Peter clerk 592545 592545 Byle, Peter, of Basyngstoke, Hants, clerk 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);