names

122 rows where place_id = 587031

✎ 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
3590298 1864610 1864610 defendant Adyngton Richard yeoman 587031 587031 Adyngton, Richard, of Grafton, yeoman 0
3624163 1875088 1875088 defendant Wyget Richard husbandman 587031 587031 Wyget, Richard, of Grafton, husbandman 1
3658334 1912859 1912859 defendant Putter Philip yeoman 587031 587031 Putter, Philip, of Grafton, yeoman 2
3658335 1912859 1912859 defendant Cowsfold John yeoman 587031 587031 Cowsfold, John, of Grafton, yeoman 3
3659958 1913373 1913373 defendant Byllyngton George   587031 587031 Byllyngton, George, of Grafton, Worcs, rector 0
3698621 1925781 1925781 defendant Henman Thomas grasier 587031 587031 Henman, Thomas, of Grafton, grasier 0
3710749 1929682 1929682 defendant Randell Thomas husbandman 587031 587031 Randell, Thomas, of Grafton, husbandman 4
3727904 1934997 1934997 defendant Draper Richard yeoman 587031 587031 Draper, Richard, of Grafton, yeoman 0
3727905 1934997 1934997 defendant Polle Thomas husbandman 587031 587031 Polle, Thomas, of Grafton, husbandman 1
3743282 1939767 1939767 defendant Draper Richard yeoman 587031 587031 Draper, Richard, of Grafton, yeoman 0
3820745 1964377 1964377 defendant ap Gryffith Meredith husbandman 587031 587031 ap Gryffith, Meredith, of Grafton, husbandman 0
3926007 1999017 1999017 defendant Talbott Lady Margaret widow 587031 587031 Talbott, Lady Margaret, of Grafton, widow 5
3972547 2014975 2014975 defendant Grene Henry capper 587031 587031 Grene, Henry, of Grafton, or of Hereford, capper 0
4075195 2051434 2051434 defendant Whalley William clerk 587031 587031 Whalley, William, of Grafton, clerk 0
4105751 2062346 2062346 defendant Grene Roger yeoman 587031 587031 Grene, Roger, of Grafton, yeoman 1
4127893 2070266 2070266 defendant Hill alias Donbridge William, junior cordwainer 587031 587031 Hill alias Donbridge, William, junior, of Grafton, cordwainer 0
4146616 2076970 2076970 defendant Vause or Vanse John gent 587031 587031 Vause or Vanse, John, of Grafton, gent 1
4160543 2081763 2081763 defendant Grenacres Ralph yeoman 587031 587031 Grenacres, Ralph, of Grafton, yeoman 0
4195146 2093863 2093863 defendant Blacknall John gent 587031 587031 Blacknall, John, of Grafton, gent 1
4222175 2103246 2103246 defendant Bassett Agnes widow 587031 587031 Bassett, Agnes, of Grafton, widow 1
4227496 2105098 2105098 defendant James Thomas gent 587031 587031 James, Thomas, of Grafton, gent 0
4235909 2108133 2108133 defendant Pyper John yeoman 587031 587031 Pyper, John, of Grafton, yeoman 1
4288498 2125935 2125935 defendant Basset Nicholas gent 587031 587031 Basset, Nicholas, of Grafton, gent 0
4321700 2137681 2137681 defendant Dobbyns Barnard husbandman 587031 587031 Dobbyns, Barnard, of Grafton, husbandman 0
4321701 2137681 2137681 defendant Dobbyns Richard husbandman 587031 587031 Dobbyns, Richard, of Grafton, husbandman 1
4321705 2137682 2137682 defendant Wyrley William husbandman 587031 587031 Wyrley, William, of Grafton, husbandman 2
4358894 2150347 2150347 defendant Hawkyns James gent 587031 587031 Hawkyns, James, of Grafton, or of Washeborne, Worcs, gent 0
4375233 2156195 2156195 defendant Deves John   587031 587031 Deves, John, of Grafton yeoman 0
4415011 2169592 2169592 defendant Aleyn John   587031 587031 Aleyn, John, of Grafton 0
4419722 2171065 2171065 defendant Bailyf Walter le   587031 587031 Bailyf, Walter le, of Grafton, son of John the bailiff 0
4457222 2187268 2187268 plaintiff Patel John   587031 587031 Patel, John, of Grafton 0
4472091 2191936 2191936 plaintiff Clerk John   587031 587031 Clerk, John, of Grafton 0
4475307 2192960 2192960 defendant Ekton William   587031 587031 Ekton, William, of Grafton 0
4515705 2205335 2205335 defendant Acke John   587031 587031 Acke, John, of Grafton 0
4520396 2206722 2206722 defendant Budell Philip   587031 587031 Budell, Philip, of Grafton 2
4520400 2206723 2206723 defendant Budell Philip   587031 587031 Budell, Philip, of Grafton 2
4528941 2209330 2209330 plaintiff Merssh John   587031 587031 Merssh, John, of Grafton 0
4535589 2211408 2211408 plaintiff Smyth John   587031 587031 Smyth, John, of Grafton 0
4542624 2213577 2213577 defendant Pacy William   587031 587031 Pacy, William, of Grafton 0
4547946 2215292 2215292 defendant Fayrebarn William   587031 587031 Fayrebarn, William, of Grafton 3
4558562 2218632 2218632 plaintiff Lyndale John   587031 587031 Lyndale, John, of Grafton, parson 0
4558564 2218633 2218633 plaintiff Lyndale John   587031 587031 Lyndale, John, of Grafton, parson 0
4558565 2218633 2218633 defendant Kyppyng William   587031 587031 Kyppyng, William, of Grafton 0
4570602 2222382 2222382 plaintiff Wydevyll Thomas   587031 587031 Wydevyll, Thomas, of Grafton 0
4582961 2226096 2226096 defendant Budell Philip   587031 587031 Budell, Philip, of Grafton 1
4599880 2231192 2231192 defendant Smyth Robert   587031 587031 Smyth, Robert, of Grafton 0
4612234 2234889 2234889 defendant Marchall William   587031 587031 Marchall, William, of Grafton 0
4612235 2234889 2234889 defendant Marchall John   587031 587031 Marchall, John, of Grafton 1
4621050 2237569 2237569 defendant del Mount Thomas   587031 587031 del Mount, Thomas, of Grafton 0
4664668 2250427 2250427 defendant Ricardes John husbandman 587031 587031 Ricardes, John, of Grafton, husbandman 1
4681424 2259811 2259811 defendant Pertenhale William   587031 587031 Pertenhale, William, of Grafton, bailiff 0
4711830 2269028 2269028 defendant Wydevyll Thomas esq 587031 587031 Wydevyll, Thomas, of Grafton, esq 0
4738092 2277017 2277017 defendant Clerk John   587031 587031 Clerk, John, of Grafton, vicar 0
4760889 2283746 2283746 defendant Walkyngton John   587031 587031 Walkyngton, John, of Grafton, arrow maker 1
4761001 2283786 2283786 defendant Pacy William husbandman 587031 587031 Pacy, William, of Grafton, husbandman 0
4781557 2290243 2290243 defendant Wytton John clerk 587031 587031 Wytton, John, of Grafton, clerk 0
4803156 2297181 2297181 defendant Swyft John yeoman 587031 587031 Swyft, John, of Grafton, yeoman 0
4809966 2299277 2299277 defendant Grafton William yeoman 587031 587031 Grafton, William, of Grafton, yeoman 3
4810906 2299528 2299528 defendant Taillour William husbandman 587031 587031 Taillour, William, of Grafton, husbandman 0
4837001 2307531 2307531 plaintiff Fermour Thomas   587031 587031 Fermour, Thomas, of Grafton 0
4844411 2309764 2309764 defendant Fermour John husbandman 587031 587031 Fermour, John, of Grafton, husbandman 1
4853698 2312573 2312573 plaintiff Wydevyll Thomas esq 587031 587031 Wydevyll, Thomas, of Grafton, esq 0
4856922 2313543 2313543 defendant Grafton William Warks, husbandman 587031 587031 Grafton William, of Grafton, Warks, husbandman 1
4872951 2318496 2318496 defendant Randolf John husbandman 587031 587031 Randolf, John, of Grafton, husbandman 0
4928989 2335494 2335494 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
4928993 2335495 2335495 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
4928995 2335496 2335496 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
4928999 2335497 2335497 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
4929002 2335498 2335498 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
4938601 2338458 2338458 defendant Pertenale John yeoman 587031 587031 Pertenale, John, of Grafton, yeoman 1
4946278 2340823 2340823 plaintiff Jowekys John (legal representative) 587031 587031 Jowekys, John, of Grafton, chapman, executors of 0
4980715 2351170 2351170 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
4980717 2351171 2351171 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
4984872 2352404 2352404 defendant Percevale John yeoman 587031 587031 Percevale, John, of Grafton, yeoman 0
4984874 2352405 2352405 defendant Pertenale John yeoman 587031 587031 Pertenale, John, of Grafton, yeoman 0
4984875 2352405 2352405 defendant Barbour Thomas yeoman 587031 587031 Barbour, Thomas, of Grafton, yeoman 1
4989568 2353813 2353813 defendant Wydevyll Richard miller 587031 587031 Wydevyll, Richard, of Grafton, miller 0
5002766 2357715 2357715 defendant Jones John yeoman 587031 587031 Jones, John, of Grafton, yeoman 0
5006102 2358674 2358674 defendant Sandbache John yeoman 587031 587031 Sandbache, John, of Grafton, yeoman 0
5007497 2359089 2359089 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
5007503 2359090 2359090 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight, formerly sheriff of Warwick 0
5022604 2363518 2363518 plaintiff Grene Henry esq 587031 587031 Grene, Henry, of Grafton, esq 0
5024738 2364156 2364156 defendant Yonge Thomas gent 587031 587031 Yonge, Thomas, of Grafton, gent 1
5027683 2364971 2364971 defendant Lofthous John husbandman 587031 587031 Lofthous, John, of Grafton, husbandman 12
5045346 2370235 2370235 defendant Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton, knight 0
5045348 2370235 2370235 defendant Stafford Humphrey esq 587031 587031 Stafford, Humphrey, of Grafton, esq 2
5045349 2370235 2370235 defendant Becham Richard gent 587031 587031 Becham, Richard, of Grafton, gent 3
5074823 2378973 2378973 defendant Stowe Richard husbandman 587031 587031 Stowe, Richard, of Grafton, husbandman 5
5074826 2378974 2378974 defendant George Peter husbandman 587031 587031 George, Peter, of Grafton, husbandman 0
5089691 2383358 2383358 defendant Tommys William   587031 587031 Tommys, William, of Grafton, franklin 2
5097823 2385791 2385791 defendant Yagowe Thomas laborer 587031 587031 Yagowe, Thomas, of Grafton, laborer 0
5097824 2385791 2385791 defendant Stretford Walter laborer 587031 587031 Stretford, Walter, of Grafton, laborer 1
5098502 2385992 2385992 defendant Partenhale John yeoman 587031 587031 Partenhale, John, of Grafton, yeoman 1
5104082 2387616 2387616 defendant Bertram William esq 587031 587031 Bertram, William, of Grafton, esq 1
5104688 2387807 2387807 defendant Pertenale John husbandman 587031 587031 Pertenale, John, of Grafton, husbandman 0
5127762 2394599 2394599 defendant Pertevale John husbandman 587031 587031 Pertevale, John, of Grafton, husbandman 1
5146793 2400206 2400206 defendant Pertenale John husbandman 587031 587031 Pertenale, John, of Grafton, husbandman 1
5150687 2401350 2401350 defendant Tommes William   587031 587031 Tommes, William, of Grafton, franklin 0
5160969 2404312 2404312 plaintiff Stafford Humphrey   587031 587031 Stafford, Humphrey, of Grafton esq 0
5169108 2406703 2406703 defendant Toumes William   587031 587031 Toumes, William, of Grafton, franklin 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);