names

139 rows where place_id = 585976

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587612 1863771 1863771 defendant Tylley Walter innholder 585976 585976 Tylley, Walter, of Cirencester, Glos, innholder 3
3589205 1864267 1864267 defendant Cantwell Robert innholder 585976 585976 Cantwell, Robert, of Cirencester, Glos, innholder 0
3589791 1864447 1864447 defendant Seend Robert yeoman 585976 585976 Seend, Robert, of Cirencester, Glos, yeoman 0
3590802 1864762 1864762 defendant Tryllyng alias Tylly Walter yeoman 585976 585976 Tryllyng alias Tylly, Walter, of Cirencester, Glos, yeoman 1
3590805 1864763 1864763 defendant Tyllyng Walter yeoman 585976 585976 Tyllyng, Walter, of Cirencester, Glos, yeoman 1
3597653 1866890 1866890 defendant Twynyng alias Spycer John fishmonger 585976 585976 Twynyng alias Spycer, John, of Cirencester, Glos, fishmonger 2
3598701 1867219 1867219 defendant Lynnessey Thomas yeoman 585976 585976 Lynnessey, Thomas, of Cirencester, Glos, yeoman 0
3614773 1872270 1872270 defendant Drake William yeoman 585976 585976 Drake, William, of Cirencester, Glos, yeoman 0
3616611 1872826 1872826 defendant Ricardis Robert yeoman 585976 585976 Ricardis, Robert, of Cirencester, Glos, yeoman 2
3681279 1920231 1920231 defendant West Thomas smith 585976 585976 West, Thomas, of Cirencester, Glos, smith 2
3703671 1927429 1927429 defendant Vyner Richard chapman 585976 585976 Vyner, Richard, of Cirencester, Glos, chapman 0
3755578 1943700 1943700 defendant Bysse William yeoman 585976 585976 Bysse, William, of Cirencester, Glos, yeoman 0
3768328 1947735 1947735 plaintiff Pateshale Richard gent 585976 585976 Pateshale, Richard, of Cirencester, Glos, gent 0
3786069 1953434 1953434 plaintiff Pateshale Richard gent 585976 585976 Pateshale, Richard, of Cirencester, Glos, gent 0
3802430 1958656 1958656 defendant Hogeskyn Henry yeoman 585976 585976 Hogeskyn, Henry, of Cirencester, Glos, yeoman 2
3802434 1958657 1958657 defendant Hogeskyn Henry yeoman 585976 585976 Hogeskyn, Henry, of Cirencester, Glos, yeoman 2
3802438 1958658 1958658 defendant Hogeskyn Henry yeoman 585976 585976 Hogeskyn, Henry, of Cirencester, Glos, yeoman 2
3802439 1958659 1958659 plaintiff Pateshale Richard gent 585976 585976 Pateshale, Richard, of Cirencester, Glos, gent 0
3802441 1958660 1958660 plaintiff Pateshale Richard gent 585976 585976 Pateshale, Richard, of Cirencester, Glos, gent 0
3914018 1995032 1995032 defendant Swyfte Henry mercer 585976 585976 Swyfte, Henry, of Cirencester, Glos, mercer 0
3924132 1998382 1998382 defendant Straunge Robert clothier 585976 585976 Straunge, Robert, of Cirencester, Glos, clothier 0
3924573 1998533 1998533 defendant Swyft Henry chapman 585976 585976 Swyft, Henry, of Cirencester, Glos, chapman 0
3924577 1998534 1998534 defendant Swyft Henry chapman 585976 585976 Swyft, Henry, of Cirencester, Glos, chapman 0
3966728 2012997 2012997 defendant Adams John clerk 585976 585976 Adams, John, of Cirencester, Glos, clerk 1
3968650 2013674 2013674 defendant Hore John clothworker 585976 585976 Hore, John, of Cirencester, Glos, yeoman, clothworker 0
3970335 2014222 2014222 plaintiff Davies Rice weaver 585976 585976 Davies, Rice, of Cirencester, Glos, weaver 0
3970902 2014387 2014387 defendant Mayles John chapman 585976 585976 Mayles, John, of Cirencester, Glos, chapman 3
3984457 2019199 2019199 plaintiff Tapper Henry (legal representative) 585976 585976 Tapper, Henry, of Cirencester, Glos, mercer, administrator of 0
3986641 2019961 2019961 defendant Mounde Robert fuller 585976 585976 Mounde, Robert, of Cirencester, Glos, fuller 0
3990368 2021310 2021310 defendant Ryther John clothier 585976 585976 Ryther, John, of Cirencester, Glos, clothier 2
3990373 2021311 2021311 defendant Ryther John clothier 585976 585976 Ryther, John, of Cirencester, Glos, clothier 2
3990784 2021462 2021462 defendant James Baldwin chapman 585976 585976 James, Baldwin, of Cirencester, Glos, chapman 0
3994499 2022781 2022781 defendant James Philip chapman 585976 585976 James, Philip, of Cirencester, Glos, chapman 0
3997608 2023895 2023895 plaintiff Edmond Thomas gent 585976 585976 Edmond, Thomas, of Cirencester, Glos, gent 0
3997610 2023896 2023896 plaintiff Edmond Thomas gent 585976 585976 Edmond, Thomas, of Cirencester, Glos, gent 0
4001433 2025289 2025289 defendant Webbe Thomas innholder 585976 585976 Webbe, Thomas, of Cirencester, Glos, innholder 0
4002701 2025731 2025731 defendant Selwen Giles innholder 585976 585976 Selwen, Giles, of Cirencester, Glos, innholder 0
4018159 2031218 2031218 defendant Phillippe Richard chapman 585976 585976 Phillippe, Richard, of Cirencester, Glos, chapman 0
4056703 2044785 2044785 defendant Rastell Thomas (legal representative) 585976 585976 Rastell, Thomas, of Cirencester, Glos, gent, executrix of 0
4056990 2044883 2044883 defendant Hall Robert weaver 585976 585976 Hall, Robert, of Cirencester, Glos, weaver 0
4064115 2047443 2047443 defendant Woodlande Thomas clerk 585976 585976 Woodlande, Thomas, of Cirencester, Glos, clerk 0
4073831 2050932 2050932 defendant Ryther alias Pytt John yeoman 585976 585976 Ryther alias Pytt, John, of Cirencester, Glos, yeoman 0
4075535 2051550 2051550 defendant Symon Henry weaver 585976 585976 Symon, Henry, of Cirencester, Glos, weaver 1
4081612 2053727 2053727 defendant Chevar Philip chapman 585976 585976 Chevar, Philip, of Cirencester, Glos, chapman 1
4084656 2054785 2054785 defendant Dunne Roger clothier 585976 585976 Dunne, Roger, of Cirencester, Glos, clothier 3
4084659 2054786 2054786 defendant Selwyn Giles chapman 585976 585976 Selwyn, Giles, of Cirencester, Glos, chapman 0
4117105 2066423 2066423 defendant Elrington Henry gent 585976 585976 Elrington, Henry, of Cirencester, Glos, gent 0
4118749 2066990 2066990 defendant Hamlett William cordwainer 585976 585976 Hamlett, William, of Cirencester, Glos, cordwainer 2
4131745 2071670 2071670 defendant James Philip clothier 585976 585976 James, Philip, of Cirencester, Glos, clothier 0
4155201 2079912 2079912 defendant Fereby Thomas chapman 585976 585976 Fereby, Thomas, of Cirencester, Glos, chapman 3
4182322 2089293 2089293 defendant Lewes Thomas tanner 585976 585976 Lewes, Thomas, of Cirencester, Glos, tanner 0
4182330 2089296 2089296 defendant Lewes Thomas tanner 585976 585976 Lewes, Thomas, of Cirencester, Glos, tanner 0
4184969 2090249 2090249 defendant Foxall Hugh clothier 585976 585976 Foxall, Hugh, of Cirencester, Glos, clothier 0
4188213 2091381 2091381 defendant Hewes Richard clothman 585976 585976 Hewes, Richard, of Cirencester, Glos, clothman 0
4197828 2094795 2094795 defendant Dunynge James mercer 585976 585976 Dunynge, James, of Cirencester, Glos, mercer 0
4201915 2096215 2096215 defendant Armond James merchant 585976 585976 Armond, James, of Cirencester, Glos, merchant 0
4202212 2096317 2096317 defendant Selwyn Giles innholder 585976 585976 Selwyn, Giles, of Cirencester, Glos, innholder 0
4208911 2098665 2098665 defendant Foxall Hugh clothier 585976 585976 Foxall, Hugh, of Cirencester, Glos, clothier 0
4209585 2098903 2098903 defendant Dunynge James mercer 585976 585976 Dunynge, James, of Cirencester, Glos, mercer 0
4214979 2100740 2100740 defendant Sadler alias Newporte John clothier 585976 585976 Sadler alias Newporte, John, of Cirencester, Glos, clothier 0
4229030 2105636 2105636 defendant Blysse Thomas gent 585976 585976 Blysse, Thomas, of Cirencester, Glos, gent 0
4250623 2113191 2113191 defendant Sadler alias Newport John clothier 585976 585976 Sadler alias Newport, John, of Cirencester, Glos, clothier 0
4259300 2116087 2116087 defendant Armond James innholder 585976 585976 Armond, James, of Cirencester, Glos, innholder 1
4279321 2122695 2122695 defendant Strange Michael gent 585976 585976 Strange, Michael, of Cirencester, Glos, gent 0
4296997 2129023 2129023 defendant Sadler John chapman 585976 585976 Sadler, John, of Cirencester, Glos, chapman 1
4300719 2130354 2130354 defendant Thorne Walter   585976 585976 Thorne, Walter, of Cirencester, Glos, surgeon 2
4304846 2131830 2131830 defendant Willis John embroiderer 585976 585976 Willis, John, of Cirencester, Glos, embroiderer 0
4311998 2134331 2134331 defendant Deane William shoemaker 585976 585976 Deane, William, of Cirencester, Glos, shoemaker 2
4316844 2136009 2136009 defendant Gawlton Paul yeoman 585976 585976 Gawlton, Paul, of Cirencester, Glos, yeoman 0
4339319 2143518 2143518 defendant Bestley John chapman 585976 585976 Bestley, John, of Cirencester, Glos, chapman 0
4349319 2147024 2147024 defendant Hall or Hale John butcher 585976 585976 Hall or Hale, John, of Cirencester, Glos, butcher 0
4350371 2147392 2147392 defendant Onyon William yeoman 585976 585976 Onyon, William, of Cirencester, Glos, yeoman 2
4352117 2147974 2147974 defendant Hayes John brasier 585976 585976 Hayes, John, of Cirencester, Glos, brasier 0
4367609 2153468 2153468 defendant Newporte Thomas saddler 585976 585976 Newporte, Thomas, of Cirencester, Glos, saddler 1
4388723 2160861 2160861 defendant Bestley John chapman 585976 585976 Bestley, John, of Cirencester, Glos, chapman 0
4400865 2164881 2164881 defendant Bysshopp Thomas chapman 585976 585976 Bysshopp, Thomas, of Cirencester, Glos, chapman 2
4653014 2246873 2246873 defendant Lovekyn John tanner 585976 585976 Lovekyn, John, of Cirencester, Glos, tanner 1
4653017 2246874 2246874 defendant Lovekyn John tanner 585976 585976 Lovekyn, John, of Cirencester, Glos, tanner 1
4654194 2247193 2247193 defendant Phelpes Thomas yeoman 585976 585976 Phelpes, Thomas, of Cirencester, Glos, yeoman 2
4655521 2247621 2247621 defendant Hoper John fisher 585976 585976 Hoper, John, of Cirencester, Glos, fisher 0
4658590 2248562 2248562 defendant Welyfed John chapman 585976 585976 Welyfed, John, of Cirencester, Glos, chapman 1
4658593 2248563 2248563 defendant Welyford John chapman 585976 585976 Welyford, John, of Cirencester, Glos, chapman 1
4659076 2248708 2248708 defendant Derlyng Richard merchant 585976 585976 Derlyng, Richard, of Cirencester, Glos, merchant 0
4664070 2250251 2250251 defendant Phelpis Thomas yeoman 585976 585976 Phelpis, Thomas, of Cirencester, Glos, yeoman 0
4664905 2250504 2250504 defendant Darlyng Richard chapman 585976 585976 Darlyng, Richard, of Cirencester, Glos, chapman 1
4666089 2250860 2250860 defendant atte Welle Thomas butcher 585976 585976 atte Welle, Thomas, of Cirencester, Glos, butcher 0
4781130 2290106 2290106 defendant Brown Thomas weaver 585976 585976 Brown, Thomas, of Cirencester, Glos, weaver 0
4785554 2291505 2291505 defendant Doughton John husbandman 585976 585976 Doughton, John, of Cirencester, Glos, husbandman 0
4785560 2291507 2291507 defendant Doughton John husbandman 585976 585976 Doughton, John, of Cirencester, Glos, husbandman 0
4786630 2291870 2291870 defendant Drapur William merchant 585976 585976 Drapur, William, of Cirencester, Glos, merchant 0
4793319 2294008 2294008 defendant Broun Thomas chaplain 585976 585976 Broun, Thomas, of Cirencester, Glos, chaplain 0
4799004 2295861 2295861 defendant Rye William   585976 585976 Rye, William, of Cirencester, Glos, servant in household of Henry V 3
4799009 2295862 2295862 defendant Rye William   585976 585976 Rye, William, of Cirencester, Glos, servant in the bakery of King Henry 3
4857082 2313595 2313595 defendant Duke John fisher 585976 585976 Duke, John, of Cirencester, Glos, fisher 3
4894724 2325022 2325022 defendant Lynche Henry dyer 585976 585976 Lynche, Henry, of Cirencester, Glos, dyer 0
4897280 2325807 2325807 defendant Gawent John fisher 585976 585976 Gawent, John, of Cirencester, Glos, fisher 3
4961232 2345326 2345326 defendant Arnold Thomas gent 585976 585976 (Arnold, Thomas, of Cirencester, Glos, gent 1
4985085 2352466 2352466 defendant Prelat William gent 585976 585976 Prelat, William, of Cirencester, Glos, gent 2
5024483 2364072 2364072 defendant Hornby William husbandman 585976 585976 Hornby, William, of Cirencester, Glos, husbandman 4
5052807 2372433 2372433 defendant Swyfte Richard skinner 585976 585976 Swyfte, Richard, of Cirencester, Glos, skinner 3

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