names

107 rows where place_id = 588748

✎ 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
3595447 1866209 1866209 defendant Gybbune James carpenter 588748 588748 Gybbune, James, of Hunton, carpenter 2
3611869 1871374 1871374 defendant Stephyns John miller 588748 588748 Stephyns, John, of Hunton, miller 0
3611870 1871374 1871374 defendant Hopkyn Geoffrey husbandman 588748 588748 Hopkyn, Geoffrey, of Hunton, husbandman 1
3611871 1871374 1871374 defendant Cykton Richard husbandman 588748 588748 Cykton, Richard, of Hunton, husbandman 2
3611872 1871374 1871374 defendant Hawekyn Richard husbandman 588748 588748 Hawekyn, Richard, of Hunton, husbandman 3
3620920 1874105 1874105 defendant Clerk Nicholas sawyer 588748 588748 Clerk, Nicholas, of Hunton, sawyer 1
3641424 1907773 1907773 defendant Greneway Thomas esq 588748 588748 Greneway, Thomas, of Hunton, esq 0
3649374 1910193 1910193 defendant Nayler Hugh gent 588748 588748 Nayler, Hugh, of Hunton, gent 0
3706565 1928338 1928338 defendant Esshe Lancelot esq 588748 588748 Esshe, Lancelot, of Hunton, esq 0
3741954 1939350 1939350 defendant White John husbandman 588748 588748 White, John, of Hunton, husbandman 2
3748324 1941405 1941405 defendant Nayler Hugh gent 588748 588748 Nayler, Hugh, of Hunton, gent 0
3810009 1961018 1961018 defendant Wytteney Richard husbandman 588748 588748 Wytteney, Richard, of Hunton, husbandman 0
3827078 1966327 1966327 defendant Cobdocke John tanner 588748 588748 Cobdocke, John, of Hunton, tanner 0
3827079 1966327 1966327 defendant Carter John tanner 588748 588748 Carter, John, of Hunton, tanner 1
3894988 1988532 1988532 plaintiff Sharpe Robert (legal representative) 588748 588748 Sharpe, Robert, of Hunton, executor of 0
3919190 1996744 1996744 defendant Wyke Anthony husbandman 588748 588748 Wyke, Anthony, of Hunton, husbandman 4
3919855 1996975 1996975 defendant Kelborne William husbandman 588748 588748 Kelborne, William, of Hunton, husbandman 0
3919856 1996975 1996975 defendant Barker Robert husbandman 588748 588748 Barker, Robert, of Hunton, husbandman 1
3919857 1996975 1996975 defendant Ingram John husbandman 588748 588748 Ingram, John, of Hunton, husbandman 2
3919858 1996975 1996975 defendant Kelborne James husbandman 588748 588748 Kelborne, James, of Hunton, husbandman 3
3919859 1996975 1996975 defendant Brokewell Richard husbandman 588748 588748 Brokewell, Richard, of Hunton, husbandman 4
3968647 2013673 2013673 defendant Mercer William (legal representative) 588748 588748 Mercer, William, of Hunton, clothier, administratrix of 0
3968648 2013673 2013673 defendant Mercer Margaret widow 588748 588748 Mercer, Margaret, of Hunton, widow 1
3997868 2023997 2023997 defendant Mayson William gent 588748 588748 Mayson, William, of Hunton or of Huntton Hall, gent 0
4001048 2025149 2025149 defendant Kylborne James husbandman 588748 588748 Kylborne, James, of Hunton, husbandman 0
4008104 2027663 2027663 plaintiff Maynerde Michael yeoman 588748 588748 Maynerde, Michael, of Hunton, yeoman 0
4029582 2035217 2035217 defendant Balston John butcher 588748 588748 Balston, John, of Hunton, butcher 0
4062900 2047031 2047031 defendant Sharpe Robert butcher 588748 588748 Sharpe, Robert, of Hunton, butcher 1
4134637 2072718 2072718 defendant Shawe Lancelot yeoman 588748 588748 Shawe, Lancelot, of Hunton, yeoman 0
4206096 2097681 2097681 defendant Shawe Lancelot yeoman 588748 588748 Shawe, Lancelot, of Hunton, yeoman 0
4217109 2101477 2101477 defendant Ritch William yeoman 588748 588748 Ritch, William, of Hunton, yeoman 0
4227740 2105187 2105187 defendant Hadlowe Geoffrey shoemaker 588748 588748 Hadlowe, Geoffrey, of Hunton, shoemaker 0
4230726 2106244 2106244 defendant Hill John husbandman 588748 588748 Hill, John, of Hunton, husbandman 1
4255111 2114703 2114703 defendant Wibarne Benjamin yeoman 588748 588748 Wibarne, Benjamin, of Hunton, yeoman 0
4258507 2115810 2115810 defendant Wybarne Benjamin yeoman 588748 588748 Wybarne, Benjamin, of Hunton, yeoman 0
4282324 2123717 2123717 defendant Haven Henry husbandman 588748 588748 Haven, Henry, of Hunton, husbandman 3
4318644 2136631 2136631 defendant Place Walter yeoman 588748 588748 Place, Walter, of Hunton, yeoman 0
4322849 2138060 2138060 defendant Rytche William yeoman 588748 588748 Rytche, William, of Hunton, yeoman 0
4362105 2151491 2151491 defendant Collymer Henry gent 588748 588748 Collymer, Henry, of Hunton, gent 0
4377569 2157054 2157054 defendant Denney Robert husbandman 588748 588748 Denney, Robert, of Hunton, husbandman 0
4388016 2160621 2160621 defendant Collymer Henry gent 588748 588748 Collymer, Henry, of Hunton, gent 0
4459326 2187967 2187967 defendant atte Wyke Richard   588748 588748 atte Wyke, Richard, of Hunton 2
4459327 2187967 2187967 defendant Ippyngbery Valentine   588748 588748 Ippyngbery, Valentine, of Hunton 3
4533216 2210648 2210648 defendant Cartere Henry   588748 588748 Cartere, Henry, of Hunton 0
4579041 2224924 2224924 defendant Festynden Richard   588748 588748 Festynden, Richard, of Hunton 0
4658439 2248519 2248519 defendant Coveney Thomas laborer 588748 588748 Coveney, Thomas, of Hunton, laborer 1
4674372 2257593 2257593 defendant Shypman Warin thatcher 588748 588748 Shypman, Warin, of Hunton, thatcher 0
4692447 2263155 2263155 defendant Reynold John   588748 588748 Reynold, John, of Hunton, wool man 0
4705349 2267045 2267045 defendant Bronman John laborer 588748 588748 Bronman, John, of Hunton, laborer 3
4711601 2268955 2268955 defendant Witton William   588748 588748 Witton, William, of Hunton, shoe maker 0
4722666 2272405 2272405 defendant Arnald John husbandman 588748 588748 Arnald, John, of Hunton, husbandman 1
4759797 2283398 2283398 defendant Barcar Thomas husbandman 588748 588748 Barcar, Thomas, of Hunton, husbandman 0
4759798 2283398 2283398 defendant Barcar Simon husbandman 588748 588748 Barcar, Simon, of Hunton, husbandman 1
4805183 2297821 2297821 defendant Hopkyns Thomas husbandman 588748 588748 Hopkyns, Thomas, of Hunton, husbandman 0
4810651 2299468 2299468 defendant Tomson John husbandman 588748 588748 Tomson, John, of Hunton, husbandman 1
4810705 2299472 2299472 defendant Tomson John husbandman 588748 588748 Tomson, John, of Hunton, husbandman 1
4877230 2319834 2319834 defendant Waryner William husbandman 588748 588748 Waryner, William, of Hunton, husbandman 0
4912419 2330387 2330387 defendant Brikelyng Walter yeoman 588748 588748 Brikelyng, Walter, of Hunton, yeoman 0
4924413 2334074 2334074 defendant Briklyng Walter gent 588748 588748 Briklyng, Walter, of Hunton, gent 0
4926247 2334633 2334633 defendant Blyklyng Walter yeoman 588748 588748 Blyklyng, Walter, of Hunton, yeoman 0
4929305 2335583 2335583 defendant Blyklyng Walter husbandman 588748 588748 Blyklyng, Walter, of Hunton, husbandman 0
4936436 2337786 2337786 defendant Bryklyng Walter usbandman 588748 588748 Bryklyng, Walter, of Hunton, usbandman 0
4938564 2338444 2338444 defendant Brikelyng Walter yeoman 588748 588748 Brikelyng, Walter, of Hunton, yeoman 0
4945519 2340576 2340576 defendant Brokle Robert laborer 588748 588748 Brokle, Robert, of Hunton, laborer 5
4954724 2343367 2343367 defendant Bliklyng Walter husbandman 588748 588748 Bliklyng, Walter, of Hunton, husbandman 0
5004203 2358120 2358120 defendant Terry Robert laborer 588748 588748 Terry, Robert, of Hunton, laborer 0
5018373 2362260 2362260 defendant Barker Simon husbandman 588748 588748 Barker, Simon, of Hunton, husbandman 0
5018375 2362261 2362261 defendant Barker Simon husbandman 588748 588748 Barker, Simon, of Hunton, husbandman 0
5024099 2363955 2363955 defendant Carpenter William carpenter 588748 588748 Carpenter, William, of Hunton, carpenter 0
5094157 2384695 2384695 defendant Payn John gent 588748 588748 Payn, John, of Hunton, gent 0
5128595 2394844 2394844 defendant Baldewyn John yeoman 588748 588748 Baldewyn, John, of Hunton, yeoman 0
5181811 2410424 2410424 defendant Wyke John husbandman 588748 588748 Wyke, John, of Hunton, husbandman 1
5223011 2422448 2422448 defendant Lewlyn John husbandman 588748 588748 Lewlyn, John, of Hunton, husbandman 1
5223012 2422448 2422448 defendant Webster William weaver 588748 588748 Webster, William, of Hunton, weaver 2
5223015 2422449 2422449 defendant Lewlyn John husbandman 588748 588748 Lewlyn, John, of Hunton, husbandman 1
5223016 2422449 2422449 defendant Webster William weaver 588748 588748 Webster, William, of Hunton, weaver 2
5230332 2424487 2424487 defendant Fawnte John yeoman 588748 588748 Fawnte, John, of Hunton, yeoman 0
5230333 2424487 2424487 defendant Tery Robert husbandman 588748 588748 Tery, Robert, of Hunton, husbandman 1
5231521 2424803 2424803 defendant Chapell Peter husbandman 588748 588748 Chapell, Peter, of Hunton, husbandman 1
5274316 2437569 2437569 defendant Ryche William yeoman 588748 588748 Ryche, William, of Hunton, yeoman 2
5288185 2441561 2441561 defendant Hakforth Thomas husbandman 588748 588748 Hakforth, Thomas, of Hunton, husbandman 0
5288186 2441561 2441561 defendant Taillour Roland husbandman 588748 588748 Taillour, Roland, of Hunton, husbandman 1
5288187 2441561 2441561 defendant Hauley or Hanley Thomas husbandman 588748 588748 Hauley or Hanley, Thomas, of Hunton, husbandman 2
5288188 2441561 2441561 defendant Smyth Chistopher husbandman 588748 588748 Smyth, Chistopher, of Hunton, husbandman 3
5288189 2441561 2441561 defendant Barker John husbandman 588748 588748 Barker, John, of Hunton, husbandman 4
5289835 2442033 2442033 defendant Brampden Thomas yeoman 588748 588748 Brampden, Thomas, of Hunton, yeoman 3
5290218 2442143 2442143 defendant Webster William weaver 588748 588748 Webster, William, of Hunton, weaver 0
5291385 2442482 2442482 defendant Ryche William yeoman 588748 588748 Ryche, William, of Hunton, yeoman 0
5322186 2451707 2451707 defendant Rythe William husbandman 588748 588748 Rythe, William, of Hunton, husbandman 3
5344044 2458315 2458315 defendant Buntfloure William husbandman 588748 588748 Buntfloure, William, of Hunton, husbandman 0
5357160 2462302 2462302 defendant Ryche William, senior husbandman 588748 588748 Ryche, William, senior, of Hunton, husbandman 0
5357161 2462302 2462302 defendant Ryche William husbandman 588748 588748 Ryche, William, of Hunton, husbandman 1
5358220 2462627 2462627 defendant Ryche William, junior husbandman 588748 588748 Ryche, William, junior, of Hunton, husbandman 3
5413975 2479112 2479112 defendant Payn John gent 588748 588748 Payn, John, of Hunton, gent 0
5413976 2479112 2479112 defendant Colyns Richard yeoman 588748 588748 Colyns, Richard, of Hunton, yeoman 1
5429501 2483756 2483756 defendant Colyns Richard yeoman 588748 588748 Colyns, Richard, of Hunton, yeoman 0
5429510 2483760 2483760 defendant Payn John gent 588748 588748 Payn, John, of Hunton, gent 0
5429511 2483760 2483760 defendant Colyns Richard yeoman 588748 588748 Colyns, Richard, of Hunton, yeoman 1
5429519 2483764 2483764 defendant Colyns Richard yeoman 588748 588748 Colyns, Richard, of Hunton, yeoman 0
5429520 2483764 2483764 defendant Payn John gent 588748 588748 together with Payn, John, of Hunton, gent 1

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