names

6,382 rows where place_id = 586117

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587974 1863892 1863892 defendant Coket Joan widow 586117 586117 Coket, Joan, of Coventry, widow 0
3588037 1863912 1863912 plaintiff Banwell William mercer 586117 586117 Banwell, William, of Coventry, mercer 0
3588040 1863912 1863912 defendant Fleccher William   586117 586117 Fleccher, William, of Coventry, vestment maker 2
3588042 1863912 1863912 defendant Hunt William weaver 586117 586117 Hunt, William, of Coventry, weaver 4
3588052 1863915 1863915 defendant Juster Thomas cordwainer 586117 586117 Juster, Thomas, of Coventry, cordwainer 0
3588053 1863915 1863915 defendant Hikman William carrier 586117 586117 Hikman, William, of Coventry, carrier 1
3588709 1864112 1864112 defendant Grene John yeoman 586117 586117 Grene, John, of Coventry, yeoman 0
3588710 1864112 1864112 defendant White John barber 586117 586117 White, John, of Coventry, barber 1
3589172 1864257 1864257 defendant Kyrfote or Kyrsote Robert yeoman 586117 586117 Kyrfote or Kyrsote, Robert, of Coventry, yeoman 2
3589186 1864262 1864262 plaintiff Broun John   586117 586117 Broun, John, of Coventry 0
3589188 1864263 1864263 plaintiff Broun John   586117 586117 Broun, John, of Coventry 0
3589190 1864264 1864264 plaintiff Broun John   586117 586117 Broun, John, of Coventry 0
3589209 1864268 1864268 plaintiff Broun Nicholas merchant of the staple 586117 586117 Broun, Nicholas, of Coventry, merchant of the staple 0
3589233 1864276 1864276 defendant Amynchon Thomas sherman 586117 586117 Amynchon, Thomas, of Coventry, sherman 0
3590005 1864514 1864514 defendant Scott Simon hosier 586117 586117 Scott, Simon, of Coventry, hosier 0
3590006 1864514 1864514 defendant Marchall William barker 586117 586117 Marchall, William, of Coventry, barker 1
3590088 1864541 1864541 plaintiff Clyffe John mercer 586117 586117 Clyffe, John, of Coventry, mercer 0
3590094 1864542 1864542 plaintiff Clyffe John mercer 586117 586117 Clyffe, John, of Coventry, mercer 0
3590144 1864555 1864555 defendant Broun William barber 586117 586117 Broun, William, of Coventry, barber 0
3590146 1864556 1864556 defendant Broun William barber 586117 586117 Broun, William, of Coventry, barber 0
3590151 1864559 1864559 plaintiff Coke Richard mercer 586117 586117 Coke, Richard, of Coventry, mercer 0
3590155 1864560 1864560 plaintiff Coke Richard mercer 586117 586117 Coke, Richard, of Coventry, mercer 0
3590205 1864578 1864578 defendant Done or Dove John dyer 586117 586117 Done or Dove, John, of Coventry, dyer 0
3591361 1864923 1864923 defendant Kery William yeoman 586117 586117 Kery, William, of Coventry, yeoman 0
3591362 1864923 1864923 defendant Sele John draper 586117 586117 Sele, John, of Coventry, draper 1
3591363 1864923 1864923 defendant Brekwod John sherman 586117 586117 Brekwod, John, of Coventry, sherman 2
3591625 1865000 1865000 defendant Norhampton William (legal representative) 586117 586117 Norhampton, William, of Coventry, butcher, executrix of 1
3591626 1865000 1865000 defendant Norhampton Margaret widow 586117 586117 Norhampton, Margaret, of Coventry, widow 2
3592010 1865115 1865115 plaintiff Folshull John baker 586117 586117 Folshull, John, of Coventry, baker 0
3592052 1865131 1865131 plaintiff Forthe William merchant 586117 586117 Forthe, William, of Coventry, merchant 0
3592055 1865131 1865131 defendant Aleyn Richard draper 586117 586117 Aleyn, Richard, of Coventry, draper 2
3592058 1865132 1865132 plaintiff Forthe William merchant 586117 586117 Forthe, William, of Coventry, merchant 0
3592059 1865132 1865132 defendant Reynold Richard draper 586117 586117 Reynold, Richard, of Coventry, draper 0
3592060 1865132 1865132 defendant Bette Thomas innholder 586117 586117 Bette, Thomas, of Coventry, innholder 1
3592061 1865132 1865132 defendant Ednam Alice widow 586117 586117 Ednam, Alice, of Coventry, widow 2
3592062 1865132 1865132 defendant Brase Richard yeoman 586117 586117 Brase, Richard, of Coventry, yeoman 3
3592303 1865207 1865207 plaintiff Fyssher John sherman 586117 586117 Fyssher, John, of Coventry, sherman 0
3592388 1865235 1865235 plaintiff Gauge or Gange John draper 586117 586117 Gauge or Gange, John, of Coventry, draper 0
3592627 1865307 1865307 defendant Hekforthe William (legal representative) 586117 586117 Hekforthe, William, of Coventry, vintner, administrator of 3
3592628 1865307 1865307 defendant Broun John vintner 586117 586117 Broun, John, of Coventry, vintner 4
3592751 1865345 1865345 plaintiff Grene Thomas innholder 586117 586117 Grene, Thomas, of Coventry, innholder 0
3592752 1865345 1865345 defendant Fareman James husbandman 586117 586117 Fareman, James, of Coventry, baker, Nelder, Robert, of Barston, Warks, husbandman 0
3592754 1865346 1865346 plaintiff Grene Thomas innholder 586117 586117 Grene, Thomas, of Coventry, innholder 0
3592755 1865346 1865346 defendant Fareman James baker 586117 586117 Fareman, James, of Coventry, baker 0
3592804 1865361 1865361 defendant Chapman Richard weaver 586117 586117 Chapman, Richard, of Coventry, weaver 4
3593251 1865522 1865522 defendant Heband Edward esq 586117 586117 Heband, Edward, of Coventry, esq 0
3593299 1865535 1865535 defendant Fundeby alias Fowelnabe Henry mercer 586117 586117 Fundeby alias Fowelnabe, Henry, of Coventry, mercer 0
3593451 1865585 1865585 defendant Assheby Richard gent 586117 586117 Assheby, Richard, of Coventry, gent 2
3593452 1865585 1865585 defendant Wever Randolph weaver 586117 586117 Wever, Randolph, of Coventry, weaver 3
3593532 1865610 1865610 defendant Clyffe John chapman 586117 586117 Clyffe, John, of Coventry, chapman 0
3594323 1865856 1865856 defendant Marchall William (legal representative) 586117 586117 Marchall, William, of Coventry, fishmonger, executrix of 0
3594324 1865856 1865856 defendant Marchall Elizabeth widow 586117 586117 Marchall, Elizabeth, of Coventry, widow 1
3594326 1865857 1865857 defendant Marchall William (legal representative) 586117 586117 Marchall, William, of Coventry, fishmonger, executrix of 0
3594327 1865857 1865857 defendant Marchall Elizabeth widow 586117 586117 Marchall, Elizabeth, of Coventry, widow 1
3595273 1866156 1866156 plaintiff Marler Henry grocer 586117 586117 Marler, Henry, of Coventry, grocer 0
3595372 1866185 1866185 defendant Assheby Richard yeoman 586117 586117 Assheby, Richard, of Coventry, yeoman 0
3595373 1866185 1866185 defendant Paget John gent 586117 586117 Paget, John, of Coventry, gent 1
3595374 1866185 1866185 defendant Squier Richard chapman 586117 586117 Squier, Richard, of Coventry, chapman 2
3595375 1866185 1866185 defendant Whithed John hosier 586117 586117 Whithed, John, of Coventry, hosier 3
3595376 1866185 1866185 defendant Clerk Richard baker 586117 586117 Clerk, Richard, of Coventry, baker 4
3596043 1866390 1866390 defendant Burton Thomas baker 586117 586117 Burton, Thomas, of Coventry, baker 0
3596044 1866390 1866390 defendant Astell Thomas   586117 586117 Astell, Thomas, of Coventry, card maker 1
3596537 1866551 1866551 defendant Barlowe Robert dyer 586117 586117 Barlowe, Robert, of Coventry, dyer 0
3596743 1866616 1866616 defendant Burbage William mercer 586117 586117 Burbage, William, of Coventry, mercer 0
3596751 1866617 1866617 defendant Burbage William mercer 586117 586117 Burbage, William, of Coventry, mercer 0
3596939 1866675 1866675 defendant Clerk John grocer 586117 586117 Clerk, John, of Coventry, grocer 0
3596941 1866676 1866676 defendant Clerk John grocer 586117 586117 Clerk, John, of Coventry, grocer 0
3597072 1866706 1866706 defendant Sutton Roger dyer 586117 586117 Sutton, Roger, of Coventry, dyer 0
3597073 1866706 1866706 defendant Chapman Richard weaver 586117 586117 Chapman, Richard, of Coventry, weaver 1
3597516 1866845 1866845 defendant Curson Thomas haberdasher 586117 586117 Curson, Thomas, of Coventry, haberdasher 0
3597524 1866847 1866847 defendant Brassewell Richard goldsmith 586117 586117 Brassewell, Richard, of Coventry, goldsmith 0
3598226 1867076 1867076 defendant Huet Thomas yeoman 586117 586117 Huet, Thomas, of Coventry, yeoman 3
3598371 1867120 1867120 defendant Charyte John (legal representative) 586117 586117 Charyte, John, of Coventry, executrix of 4
3598372 1867120 1867120 defendant Marchall Elizabeth widow 586117 586117 Marchall, Elizabeth, of Coventry, widow 5
3599067 1867345 1867345 defendant Clerk Thomas draper 586117 586117 Clerk, Thomas, of Coventry, draper 0
3599068 1867345 1867345 defendant Pope John dyer 586117 586117 Pope, John, of Coventry, dyer 1
3599280 1867418 1867418 defendant More Thomas (legal representative) 586117 586117 More, Thomas, of Coventry, butcher, executors of 0
3599281 1867418 1867418 defendant More Isabel widow 586117 586117 (More, Isabel, of Coventry, widow 1
3599282 1867418 1867418 defendant More Robert tailor 586117 586117 More, Robert, of Coventry, tailor 2
3599284 1867419 1867419 defendant White John butcher 586117 586117 White, John, of Coventry, butcher 0
3599850 1867602 1867602 defendant Tounesend Henry barber 586117 586117 Tounesend, Henry, of Coventry, barber 0
3599852 1867603 1867603 defendant Touneshend Henry barber 586117 586117 Touneshend, Henry, of Coventry, barber 0
3599892 1867618 1867618 defendant Bamborowe William cooper 586117 586117 Bamborowe, William, of Coventry, cooper 0
3599976 1867648 1867648 defendant Castell Thomas chapman 586117 586117 Castell, Thomas, of Coventry, chapman 0
3600091 1867679 1867679 defendant Ednam Alice widow 586117 586117 Ednam, Alice, of Coventry, widow 0
3600151 1867698 1867698 defendant Assheby Richard yeoman 586117 586117 Assheby, Richard, of Coventry, yeoman 0
3600224 1867717 1867717 defendant Ruyton Richard draper 586117 586117 Ruyton, Richard, of Coventry, draper 0
3600225 1867717 1867717 defendant Ruyton George mercer 586117 586117 Ruyton, George, of Coventry, mercer 1
3600231 1867720 1867720 defendant Randull Thomas chapman 586117 586117 Randull, Thomas, of Coventry, chapman 0
3600234 1867720 1867720 defendant Jakson William chapman 586117 586117 Jakson, William, of Coventry, chapman 3
3600649 1867849 1867849 defendant Thorp William dyer 586117 586117 Thorp, William, of Coventry, dyer 2
3601074 1868003 1868003 defendant Hepper Thomas yeoman 586117 586117 Hepper, Thomas, of Coventry, yeoman 1
3601090 1868007 1868007 defendant Bayly Thomas grocer 586117 586117 Bayly, Thomas, of Coventry, grocer 1
3601091 1868007 1868007 defendant Barbour Edmund capper 586117 586117 Barbour, Edmund, of Coventry, capper 2
3601092 1868007 1868007 defendant A Wode John grocer 586117 586117 A Wode, John, of Coventry, grocer 3
3601093 1868007 1868007 defendant Clyffe John chapman 586117 586117 Clyffe, John, of Coventry, chapman 4
3601099 1868008 1868008 defendant Forde Thomas chapman 586117 586117 Forde, Thomas, of Coventry, chapman 2
3601100 1868008 1868008 defendant Clerke John chapman 586117 586117 Clerke, John, of Coventry, chapman 3
3601101 1868008 1868008 defendant Haywarde Edmund chapman 586117 586117 Haywarde, Edmund, of Coventry, chapman 4
3601539 1868138 1868138 plaintiff Barbour Edmund   586117 586117 Barbour, Edmund, of Coventry 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);