names

134 rows where place_id = 591530

✎ 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
3604681 1869126 1869126 defendant Marshall Thomas yeoman 591530 591530 Marshall, Thomas, of New Wyndesore, Berks, yeoman 1
3607872 1870111 1870111 defendant Cotyngham Robert yeoman 591530 591530 Cotyngham, Robert, of New Wyndesore, Berks, yeoman 1
3615740 1872564 1872564 defendant Bowelond Thomas innholder 591530 591530 Bowelond, Thomas, of New Wyndesore, Berks, innholder 0
3615765 1872572 1872572 defendant Cony John gent 591530 591530 Cony, John, of New Wyndesore, Berks, gent 1
3622650 1874614 1874614 defendant Gent Edmund gent 591530 591530 Gent, Edmund, of New Wyndesore, Berks, gent 0
3627674 1903516 1903516 defendant Billesdon William   591530 591530 Billesdon, William, of New Wyndesore, Berks, mason 0
3654448 1911652 1911652 defendant Byston Thomas yeoman 591530 591530 Byston, Thomas, of New Wyndesore, Berks, yeoman 0
3671052 1916913 1916913 defendant Beston Thomas gent 591530 591530 Beston, Thomas, of New Wyndesore, Berks, gent 0
3671054 1916914 1916914 defendant Beston Thomas gent 591530 591530 Beston, Thomas, of New Wyndesore, Berks, gent 0
3706273 1928249 1928249 defendant Aspley Richard goldsmith 591530 591530 Aspley, Richard, of New Wyndesore, Berks, goldsmith 0
3730320 1935714 1935714 defendant Gwyn Mathew baker 591530 591530 Gwyn, Mathew, of New Wyndesore, Berks, baker 1
3733542 1936735 1936735 defendant Jakson Thomas gent 591530 591530 (Jakson, Thomas, of New Wyndesore, Berks, gent 1
3738324 1938203 1938203 defendant Staper Christopher yeoman 591530 591530 Staper, Christopher, of New Wyndesore, Berks, yeoman 0
3747420 1941107 1941107 defendant Jakson Thomas gent 591530 591530 (Jakson, Thomas, of New Wyndesore, Berks, gent 1
3750372 1942036 1942036 defendant Stapull Christopher chapman 591530 591530 Stapull, Christopher, of New Wyndesore, Berks, chapman 2
3752333 1942654 1942654 plaintiff Pury William gent 591530 591530 Pury, William, of New Wyndesore, Berks, gent 0
3757143 1944215 1944215 defendant Horsted Thomas bargeman 591530 591530 Horsted, Thomas, of New Wyndesore, Berks, bargeman 0
3761203 1945508 1945508 defendant Jakson Thomas gent 591530 591530 (Jakson, Thomas, of New Wyndesore, Berks, gent 1
3761949 1945744 1945744 defendant Lyngen Roger clerk 591530 591530 Lyngen, Roger, of New Wyndesore, Berks, clerk 0
3762159 1945808 1945808 defendant Symond William gent 591530 591530 Symond, William, of New Wyndesore, Berks, gent 3
3762164 1945809 1945809 defendant Symond William gent 591530 591530 Symond, William, of New Wyndesore, Berks, gent 3
3807503 1960252 1960252 defendant Rawson Richard   591530 591530 Rawson, Richard, of New Wyndesore, Berks, clek 0
3833663 1968460 1968460 defendant Chambre Edward gent 591530 591530 Chambre, Edward, of New Wyndesore, Berks, gent 0
3842403 1971158 1971158 defendant Benett Robert gent 591530 591530 Benett, Robert, of New Wyndesore, Berks, gent 0
3842407 1971159 1971159 defendant Benett Robert gent 591530 591530 Benett, Robert, of New Wyndesore, Berks, gent 0
3842460 1971179 1971179 defendant Benett Robert gent 591530 591530 Benett, Robert, of New Wyndesore, Berks, gent 0
3842464 1971180 1971180 defendant Benett Robert yeoman 591530 591530 Benett, Robert, of New Wyndesore, Berks, yeoman 0
3849635 1973473 1973473 defendant Chambre Edward   591530 591530 Chambre, Edward, of New Wyndesore, Berks, gent, of the Exchecquer 0
3851333 1974015 1974015 defendant Benett Robert gent 591530 591530 Benett, Robert, of New Wyndesore, Berks, gent 0
3851748 1974135 1974135 defendant Benett Robert gent 591530 591530 Benett, Robert, of New Wyndesore, Berks, gent 1
3853294 1974650 1974650 defendant Perry John mercer 591530 591530 (Perry, John, of New Wyndesore, Berks, mercer 1
3866287 1978955 1978955 defendant Benett Robert gent 591530 591530 Benett, Robert, of New Wyndesore, Berks, gent 0
3872944 1981164 1981164 defendant Benett Robert gent 591530 591530 Benett, Robert, of New Wyndesore, Berks, gent 0
3878229 1982966 1982966 defendant Cowper Nicholas yeoman 591530 591530 Cowper, Nicholas, of New Wyndesore, Berks, yeoman 0
3884816 1985196 1985196 defendant Willen Miles clerk 591530 591530 Willen, Miles, of New Wyndesore, Berks, clerk 0
3888113 1986282 1986282 defendant Symondys William gent 591530 591530 Symondys, William, of New Wyndesore, Berks, gent 0
3895313 1988639 1988639 defendant Lynghard Richard yeoman 591530 591530 Lynghard, Richard, of New Wyndesore, Berks, yeoman 0
3902297 1991001 1991001 defendant Brydgewater Robert basketmaker 591530 591530 Brydgewater, Robert, of New Wyndesore, Berks, basketmaker 4
3941936 2004313 2004313 defendant Harryson Eleanor   591530 591530 Harryson, Eleanor, of New Wyndesore, Berks, wdiow 2
3950451 2007234 2007234 defendant Redford Thomas shoemaker 591530 591530 Redford, Thomas, of New Wyndesore, Berks, shoemaker 3
4787166 2292053 2292053 defendant Agland John yeoman 591530 591530 Agland, John, of New Wyndesore, Berks, yeoman 1
4787176 2292055 2292055 defendant Agland John yeoman 591530 591530 Agland, John, of New Wyndesore, Berks, yeoman 0
4870304 2317686 2317686 defendant Trebell John   591530 591530 Trebell, John, of New Wyndesore, Berks, knight 0
4903518 2327710 2327710 defendant Pitte Robert glover 591530 591530 Pitte, Robert, of New Wyndesore, Berks, glover 0
4962285 2345621 2345621 defendant Depden John clerk 591530 591530 Depden, John, of New Wyndesore, Berks, clerk 1
4962288 2345622 2345622 defendant Depden John clerk 591530 591530 Depden, John, of New Wyndesore, Berks, clerk 1
4971508 2348407 2348407 defendant Lynde William gent 591530 591530 Lynde, William, of New Wyndesore, Berks, gent 0
4971510 2348408 2348408 defendant Lynde William gent 591530 591530 Lynde, William, of New Wyndesore, Berks, gent 0
4971567 2348426 2348426 defendant Otewey John brewer 591530 591530 Otewey, John, of New Wyndesore, Berks, brewer 2
4973260 2348938 2348938 defendant Sherman Roger husbandman 591530 591530 Sherman, Roger, of New Wyndesore, Berks, husbandman 0
4998928 2356562 2356562 defendant Bailly John yeoman 591530 591530 Bailly, John, of New Wyndesore, Berks, yeoman 2
5030052 2365658 2365658 plaintiff Pasty Geoffrey   591530 591530 Pasty, Geoffrey, of New Wyndesore, Berks 0
5040798 2368863 2368863 defendant Midilton William gent 591530 591530 Midilton, William, of New Wyndesore, Berks, & of Northumberland, gent 1
5047554 2370888 2370888 defendant Debden John clerk 591530 591530 Debden, John, of New Wyndesore, Berks, clerk 0
5056916 2373644 2373644 defendant Houghton Richard gent 591530 591530 Houghton, Richard, of New Wyndesore, Berks, gent 2
5056923 2373646 2373646 defendant Houghton Richard gent 591530 591530 Houghton, Richard, of New Wyndesore, Berks, gent 3
5056928 2373647 2373647 defendant Houghton Richard gent 591530 591530 Houghton, Richard, of New Wyndesore, Berks, gent 3
5067971 2376920 2376920 defendant Sherman Roger husbandman 591530 591530 Sherman, Roger, of New Wyndesore, Berks, husbandman 0
5067973 2376921 2376921 defendant Sherman Roger husbandman 591530 591530 Sherman, Roger, of New Wyndesore, Berks, husbandman 0
5070890 2377788 2377788 defendant Yetter William taverner 591530 591530 Yetter, William, of New Wyndesore, Berks, taverner 0
5072385 2378228 2378228 defendant Pasty Geoffrey yeoman 591530 591530 Pasty, Geoffrey, of New Wyndesore, Berks, yeoman 1
5076046 2379333 2379333 defendant Bythewode John husbandman 591530 591530 Bythewode, John, of New Wyndesore, Berks, husbandman 0
5078347 2380017 2380017 defendant Sherman Roger yeoman 591530 591530 Sherman, Roger, of New Wyndesore, Berks, yeoman 0
5096821 2385502 2385502 defendant Bryan William yeoman 591530 591530 Bryan, William, of New Wyndesore, Berks, yeoman 0
5096854 2385510 2385510 defendant Barwe William esq 591530 591530 Barwe, William, of New Wyndesore, Berks, esq 2
5120688 2392481 2392481 defendant Sherman Roger sherman 591530 591530 Sherman, Roger, of New Wyndesore, Berks, sherman 2
5120694 2392482 2392482 defendant Sherman Roger sherman 591530 591530 Sherman, Roger, of New Wyndesore, Berks, sherman 2
5120922 2392550 2392550 defendant Waleys Richard yeoman 591530 591530 Waleys, Richard, of New Wyndesore, Berks, yeoman 0
5124841 2393738 2393738 defendant Salveyne Margaret widow 591530 591530 Salveyne, Margaret, of New Wyndesore, Berks, widow 4
5131682 2395750 2395750 defendant Welbek John esq 591530 591530 Welbek, John, of New Wyndesore, Berks, esq 0
5131684 2395751 2395751 defendant Welbek John esq 591530 591530 Welbek, John, of New Wyndesore, Berks, esq 0
5141313 2398584 2398584 defendant Batayll John gent 591530 591530 Batayll, John, of New Wyndesore, Berks, gent 1
5154722 2402534 2402534 defendant Oldewode John barber 591530 591530 Oldewode, John, of New Wyndesore, Berks, barber 2
5162486 2404756 2404756 defendant Batayll John gent 591530 591530 Batayll, John, of New Wyndesore, Berks, gent 1
5171667 2407432 2407432 defendant Oldewode John barber 591530 591530 Oldewode, John, of New Wyndesore, Berks, barber 2
5190332 2412914 2412914 defendant Oldewode John barber 591530 591530 Oldewode, John, of New Wyndesore, Berks, barber 2
5190336 2412915 2412915 defendant Oldewode John barber 591530 591530 Oldewode, John, of New Wyndesore, Berks, barber 2
5219541 2421445 2421445 defendant Boston John yeoman 591530 591530 Boston, John, of New Wyndesore, Berks, yeoman 1
5222192 2422197 2422197 defendant Thorp John butcher 591530 591530 Thorp, John, of New Wyndesore, Berks, butcher 2
5225709 2423190 2423190 defendant Capron Thomas tanner 591530 591530 Capron, Thomas, of New Wyndesore, Berks, tanner 0
5225961 2423261 2423261 defendant Burghill Paganus or Pagan clerk 591530 591530 Burghill, Paganus or Pagan, of New Wyndesore, Berks, clerk 2
5236424 2426247 2426247 defendant Capron Thomas tanner 591530 591530 Capron, Thomas, of New Wyndesore, Berks, tanner 1
5245404 2428811 2428811 defendant Quynchant William chapman 591530 591530 Quynchant, William, of New Wyndesore, Berks, chapman 0
5259632 2433134 2433134 defendant Fraunces William yeoman 591530 591530 Fraunces, William, of New Wyndesore, Berks, yeoman 0
5261490 2433706 2433706 defendant Rayneford Lawrence   591530 591530 Rayneford, Lawrence, of New Wyndesore, Berks, knight 0
5269118 2436072 2436072 defendant Greneway Richard chapman 591530 591530 Greneway, Richard, of New Wyndesore, Berks, chapman 0
5270664 2436521 2436521 defendant Fraunseys William yeoman 591530 591530 Fraunseys, William, of New Wyndesore, Berks, yeoman 0
5270668 2436523 2436523 defendant Fraunceys William yeoman 591530 591530 Fraunceys, William, of New Wyndesore, Berks, yeoman 0
5283410 2440203 2440203 defendant Salveyn Margaret widow 591530 591530 Salveyn, Margaret, of New Wyndesore, Berks, widow 0
5283446 2440212 2440212 defendant Fraunces William yeoman 591530 591530 Fraunces, William, of New Wyndesore, Berks, yeoman 1
5287032 2441216 2441216 defendant Grenewey Richard yeoman 591530 591530 Grenewey, Richard, of New Wyndesore, Berks, yeoman 2
5289051 2441808 2441808 defendant Baker Thomas taverner 591530 591530 Baker, Thomas, of New Wyndesore, Berks, taverner 1
5295070 2443546 2443546 defendant Blanford William   591530 591530 Blanford, William, of New Wyndesore, Berks, ironmonge 1
5295074 2443547 2443547 defendant Blanford William ironmonger 591530 591530 Blanford, William, of New Wyndesore, Berks, ironmonger 1
5329255 2453829 2453829 defendant Druffeld Thomas (legal representative) 591530 591530 Druffeld, Thomas, of New Wyndesore, Berks, yeoman, executors of 0
5334137 2455274 2455274 defendant Pery Edmund yeoman 591530 591530 Pery, Edmund, of New Wyndesore, Berks, yeoman 4
5342966 2457991 2457991 defendant Dykson Thomas chaplain 591530 591530 Dykson, Thomas, of New Wyndesore, Berks, chaplain 0
5354491 2461478 2461478 defendant Westmynster Edward gent 591530 591530 Westmynster, Edward, of New Wyndesore, Berks, gent 0
5354495 2461479 2461479 defendant Westmynster Edward gent 591530 591530 Westmynster, Edward, of New Wyndesore, Berks, gent 0
5357834 2462521 2462521 defendant Hethe Thomas clerk 591530 591530 Hethe, Thomas, of New Wyndesore, Berks, clerk 2

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