names

96 rows where place_id = 586224

✎ 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
3588206 1863966 1863966 defendant Walbonke John yeoman 586224 586224 Walbonke, John, of Grendon, yeoman 0
3607485 1870001 1870001 defendant Willoughby John   586224 586224 Willoughby, John, of Grendon 0
3607486 1870001 1870001 defendant Johnston Edward husbandman 586224 586224 Johnston, Edward, of Grendon, husbandman 1
3607487 1870001 1870001 defendant Porter Robert husbandman 586224 586224 Porter, Robert, of Grendon, husbandman 2
3735793 1937432 1937432 defendant Lewes Roger husbandman 586224 586224 Lewes, Roger, of Grendon, husbandman 1
3827088 1966330 1966330 defendant Carter John husbandman 586224 586224 Carter, John, of Grendon, husbandman 0
3839729 1970352 1970352 defendant Chadwyke William husbandman 586224 586224 Chadwyke, William, of Grendon, husbandman 0
3841620 1970963 1970963 plaintiff Blount John esq 586224 586224 Blount, John, of Grendon, esq 0
3851111 1973936 1973936 defendant Steyn Robert collier 586224 586224 Steyn, Robert, of Grendon, collier 1
3851118 1973936 1973936 defendant Stokklyng Edmund husbandman 586224 586224 Stokklyng, Edmund, of Grendon, husbandman 8
3858243 1976234 1976234 plaintiff Blounte John esq 586224 586224 Blounte, John, of Grendon, esq 0
3884000 1984918 1984918 defendant Stokton Edmund husbandman 586224 586224 Stokton, Edmund, of Grendon, husbandman 1
3885769 1985494 1985494 plaintiff Blount John esq 586224 586224 Blount, John, of Grendon, esq 0
3885773 1985495 1985495 plaintiff Blounte John esq 586224 586224 Blounte, John, of Grendon, esq 0
3885781 1985498 1985498 plaintiff Blunt John esq 586224 586224 Blunt, John, of Grendon, esq 0
3912212 1994412 1994412 defendant Tomson Robert husbandman 586224 586224 Tomson, Robert, of Grendon, husbandman 1
3912213 1994412 1994412 defendant Stockton Edward husbandman 586224 586224 Stockton, Edward, of Grendon, husbandman 2
3931644 2000879 2000879 defendant Buckeley Geoffrey husbandman 586224 586224 Buckeley, Geoffrey, of Grendon, husbandman 1
3931647 2000880 2000880 defendant Buckeley Geoffrey husbandman 586224 586224 Buckeley, Geoffrey, of Grendon, husbandman 1
3948257 2006449 2006449 defendant Kendall alias Wever Thomas whitawer 586224 586224 Kendall alias Wever, Thomas, of Grendon, whitawer 0
4043280 2040066 2040066 plaintiff Pigott Thomas   586224 586224 Pigott, Thomas, of Grendon, esq, sheriff 0
4043285 2040067 2040067 plaintiff Pigott Thomas   586224 586224 Pigott, Thomas, of Grendon, esq, sheriff 0
4044018 2040312 2040312 plaintiff Pygott Thomas   586224 586224 Pygott, Thomas, of Grendon, esq, sheriff 0
4137741 2073854 2073854 defendant Manyfolde Robert husbandman 586224 586224 Manyfolde, Robert, of Grendon, clerk, or of Forde, husbandman 0
4329502 2140173 2140173 defendant Charnock Thomas gent 586224 586224 Charnock, Thomas, of Grendon, gent 0
4361194 2151166 2151166 defendant Dygbey John husbandman 586224 586224 Dygbey, John, of Grendon, husbandman 0
4366270 2152977 2152977 defendant Hudson Thomas husbandman 586224 586224 Hudson, Thomas, of Grendon, husbandman 1
4396480 2163397 2163397 defendant Grafton John husbandman 586224 586224 Grafton, John, of Grendon, husbandman 0
4415087 2169619 2169619 defendant Webstere John de butcher 586224 586224 Webstere, John de, of Grendon, butcher 0
4437607 2176517 2176517 defendant atte Yate Richard   586224 586224 atte Yate, Richard, of Grendon 1
4455643 2186775 2186775 plaintiff More Robert atte   586224 586224 More, Robert atte, of Grendon, parson of the church 0
4458426 2187678 2187678 plaintiff Ram John, junior   586224 586224 Ram, John, junior, of Grendon, on his own account 0
4464374 2189527 2189527 defendant Assheby Hugh de   586224 586224 Assheby, Hugh de, of Grendon 0
4488138 2197008 2197008 defendant Wodegrym Edmund   586224 586224 Wodegrym, Edmund, of Grendon 0
4488139 2197008 2197008 defendant Gydymon William   586224 586224 Gydymon, William, of Grendon 1
4518523 2206167 2206167 defendant Gretton Richard   586224 586224 Gretton, Richard, of Grendon 0
4574906 2223678 2223678 defendant Bradhed Thomas   586224 586224 Bradhed, Thomas, of Grendon 0
4574908 2223678 2223678 defendant Nykson Henry   586224 586224 Nykson, Henry, of Grendon 2
4579326 2225017 2225017 defendant Barbour William   586224 586224 Barbour, William, of Grendon 3
4585835 2226991 2226991 defendant Hanton or Hauton John   586224 586224 Hanton or Hauton, John, of Grendon 0
4590257 2228324 2228324 defendant Barbour William   586224 586224 Barbour, William, of Grendon 1
4600986 2231537 2231537 defendant Bradhede Thomas   586224 586224 Bradhede, Thomas, of Grendon, parson 0
4608652 2233811 2233811 plaintiff Bradhede Thomas   586224 586224 Bradhede, Thomas, of Grendon, parson 0
4622538 2238026 2238026 plaintiff Lylye William   586224 586224 Lylye, William, of Grendon 1
4633437 2241313 2241313 defendant del Hull William   586224 586224 del Hull, William, of Grendon 0
4637490 2242516 2242516 plaintiff Bradhede Thomas   586224 586224 Bradhede, Thomas, of Grendon 0
4643637 2244240 2244240 plaintiff Knyppyng Gerard   586224 586224 Knyppyng, Gerard, of Grendon 0
4643639 2244240 2244240 defendant Knyppyng William   586224 586224 Knyppyng, William, of Grendon 0
4677461 2258563 2258563 defendant Mortymer John, senior esq 586224 586224 Mortymer, John, senior, of Grendon, esq 0
4677473 2258566 2258566 defendant Mortymer John, senior esq 586224 586224 Mortymer, John, senior, of Grendon, esq 0
4693532 2263478 2263478 defendant Mortymer John esq 586224 586224 Mortymer, John, of Grendon, esq 0
4693537 2263479 2263479 defendant Mortymer John esq 586224 586224 Mortymer, John, of Grendon, esq 0
4730917 2274866 2274866 defendant Wodgryme John husbandman 586224 586224 Wodgryme, John, of Grendon, husbandman 3
4732226 2275259 2275259 plaintiff Outhehill William, sen   586224 586224 Outhehill, William, sen, of Grendon 0
4735501 2276250 2276250 defendant Nicson Thomas husbandman 586224 586224 Nicson, Thomas, of Grendon, husbandman 0
4735507 2276251 2276251 defendant Nicson Thomas husbandman 586224 586224 Nicson, Thomas, of Grendon, husbandman 0
4787251 2292082 2292082 defendant Hille John laborer 586224 586224 Hille, John, of Grendon, laborer 1
4813121 2300222 2300222 defendant Broghton John hosier 586224 586224 Broghton, John, of Grendon, hosier 0
4832695 2306244 2306244 defendant Wotton Roger butcher 586224 586224 Wotton, Roger, of Grendon, butcher 0
4832696 2306244 2306244 defendant Kepe Richard husbandman 586224 586224 Kepe, Richard, of Grendon, husbandman 1
4832697 2306244 2306244 defendant Slyknawe John   586224 586224 Slyknawe, John, of Grendon, sow gelder 2
4836617 2307424 2307424 defendant Wotton Roger butcher 586224 586224 Wotton, Roger, of Grendon, butcher 0
4859483 2314339 2314339 defendant Wotton Roger butcher 586224 586224 Wotton, Roger, of Grendon, butcher 0
4928992 2335494 2335494 defendant Lewes John husbandman 586224 586224 Lewes, John, of Grendon, husbandman 2
4963675 2346046 2346046 defendant Kepe Thomas husbandman 586224 586224 Kepe, Thomas, of Grendon, husbandman 1
4963680 2346047 2346047 defendant Kepe Thomas husbandman 586224 586224 Kepe, Thomas, of Grendon, husbandman 1
5001271 2357250 2357250 plaintiff Melburne Simon   586224 586224 Melburne, Simon, of Grendon, parson 0
5022484 2363476 2363476 defendant Rufford William clerk 586224 586224 Rufford, William, of Grendon, clerk 0
5022486 2363476 2363476 defendant Walbonk William laborer 586224 586224 Walbonk, William, of Grendon, laborer 2
5034024 2366819 2366819 defendant Goold William yeoman 586224 586224 Goold, William, of Grendon, yeoman 8
5039102 2368344 2368344 defendant Rufford William clerk 586224 586224 Rufford, William, of Grendon, clerk 0
5039117 2368346 2368346 defendant Rufford William clerk 586224 586224 Rufford, William, of Grendon, clerk 5
5043927 2369812 2369812 defendant Rufford William clerk 586224 586224 with Rufford, William, of Grendon, clerk 1
5043928 2369812 2369812 defendant Walbonk William laborer 586224 586224 Walbonk, William, of Grendon, laborer 2
5043933 2369813 2369813 defendant Rufford William clerk 586224 586224 Rufford, William, of Grendon, clerk 0
5051034 2371918 2371918 defendant Rufford William clerk 586224 586224 with Rufford, William, of Grendon, clerk 2
5071629 2378009 2378009 defendant Desyll John husbandman 586224 586224 (Desyll, John, of Grendon, husbandman 1
5071633 2378010 2378010 defendant Desyll John husbandman 586224 586224 (Desyll, John, of Grendon, husbandman 1
5083597 2381597 2381597 defendant Bowen Hugh yeoman 586224 586224 Bowen, Hugh, of Grendon, yeoman 3
5084076 2381740 2381740 defendant Dysell William husbandman 586224 586224 Dysell, William, of Grendon, husbandman 2
5099451 2386274 2386274 defendant Harryes John husbandman 586224 586224 Harryes, John, of Grendon, husbandman 0
5172230 2407604 2407604 defendant Croxston Richard smith 586224 586224 Croxston, Richard, of Grendon, smith 1
5191183 2413163 2413163 defendant Croxton Richard smith 586224 586224 Croxton, Richard, of Grendon, smith 1
5207241 2417858 2417858 defendant Croxston Richard smith 586224 586224 Croxston, Richard, of Grendon, smith 1
5346863 2459177 2459177 defendant Walbouke John yeoman 586224 586224 Walbouke, John, of Grendon, yeoman 1
5346866 2459178 2459178 defendant Walbonde John yeoman 586224 586224 Walbonde, John, of Grendon, yeoman 1
5391036 2472506 2472506 defendant Loveden William gent 586224 586224 Loveden, William, of Grendon, gent 0
5486219 2500766 2500766 defendant Boteler John husbandman 586224 586224 Boteler, John, of Grendon, husbandman 0
5491356 2502303 2502303 defendant Lumney William husbandman 586224 586224 Lumney, William, of Grendon, husbandman 0
5534891 2515456 2515456 defendant Clerke John yeoman 586224 586224 Clerke, John, of Grendon, yeoman 1
5549060 2519765 2519765 defendant Boteler John yeoman 586224 586224 Boteler, John, of Grendon, yeoman 0
5554853 2521419 2521419 defendant Lurkyn Richard husbandman 586224 586224 Lurkyn, Richard, of Grendon, husbandman 0
5583231 2529832 2529832 defendant Boteler John yeoman 586224 586224 Boteler, John, of Grendon, yeoman 0
5611643 2547377 2547377 plaintiff Draycote William   586224 586224 (Draycote, William, of Grendon, parson 1
5611650 2547378 2547378 plaintiff Draycote William   586224 586224 (Draycote, William, of Grendon, parson 1
5623118 2551170 2551170 defendant Boldyng John de chaplain 586224 586224 Boldyng, John de, of Grendon, chaplain 0

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