names

49 rows where place_id = 595730

✎ 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
3621679 1874319 1874319 defendant Halse John clothier 595730 595730 Halse, John, of Coscombe, clothier 0
3621680 1874319 1874319 defendant Braunch or Braunth Thomas dyer 595730 595730 Braunch or Braunth, Thomas, of Coscombe, dyer 1
3662760 1914275 1914275 plaintiff Muwdeley John   595730 595730 Muwdeley, John, of Coscombe, cloth maker 0
3671083 1916924 1916924 defendant Sadeler John pardoner 595730 595730 Sadeler, John, of Coscombe, pardoner 1
3691297 1923437 1923437 defendant Dounton Richard husbandman 595730 595730 Dounton, Richard, of Coscombe, husbandman 0
3758890 1944771 1944771 defendant Donne or Doune Thomas husbandman 595730 595730 Donne or Doune, Thomas, of Coscombe, husbandman 0
3763308 1946157 1946157 defendant Stevyns John saddler 595730 595730 Stevyns, John, of Coscombe, saddler 0
3776960 1950538 1950538 defendant Porter John clothier 595730 595730 Porter, John, of Coscombe, clothier 0
3922374 1997800 1997800 defendant Bysse John clothier 595730 595730 Bysse, John, of Coscombe, clothier 0
3972085 2014796 2014796 defendant Bysse Richard clothier 595730 595730 Bysse, Richard, of Coscombe, clothier 1
4005067 2026599 2026599 defendant Guppye William husbandman 595730 595730 Guppye, William, of Coscombe, husbandman 1
4005068 2026599 2026599 defendant Guppye Richard husbandman 595730 595730 Guppye, Richard, of Coscombe, husbandman 2
4063098 2047101 2047101 defendant Fome Jasper husbandman 595730 595730 Fome, Jasper, of Coscombe, husbandman 0
4186680 2090829 2090829 defendant Barrett Robert tailor 595730 595730 Barrett, Robert, of Coscombe, tailor 0
4313053 2134686 2134686 defendant Morse Edmund yeoman 595730 595730 Morse, Edmund, of Coscombe, yeoman 0
4316132 2135753 2135753 defendant Morce Edward clothier 595730 595730 Morce, Edward, of Coscombe, clothier 0
4354870 2148923 2148923 defendant Whyte Agnes widow 595730 595730 Whyte, Agnes, of Coscombe, widow 1
4443000 2182772 2182772 defendant Cary Richard   595730 595730 Cary, Richard, of Coscombe 2
4478028 2193798 2193798 plaintiff Harper John   595730 595730 Harper, John, of Coscombe 0
4540845 2213041 2213041 defendant Kerdy John   595730 595730 Kerdy, John, of Coscombe 0
4634739 2241718 2241718 defendant Pyrye Walter   595730 595730 Pyrye, Walter, of Coscombe 0
4639381 2243031 2243031 defendant Whyte Thomas dyer 595730 595730 Whyte, Thomas, of Coscombe, dyer 1
4674050 2257495 2257495 defendant Hunte William yeoman 595730 595730 Hunte, William, of Coscombe, butcherl Hoper, William, of Bruton, yeoman 0
4716715 2270547 2270547 defendant Gome John fuller 595730 595730 Gome, John, of Coscombe, fuller 1
4811597 2299735 2299735 defendant Atkyn Richard clerk 595730 595730 Atkyn, Richard, of Coscombe, clerk 3
4812049 2299882 2299882 defendant Harper William weaver 595730 595730 Harper, William, of Coscombe, weaver 1
4813166 2300234 2300234 defendant Priour William husbandman 595730 595730 Priour, William, of Coscombe, husbandman 0
4827928 2304790 2304790 defendant Atkyns Agnes   595730 595730 Atkyns, Agnes, of Coscombe 0
4837914 2307783 2307783 defendant Shipton Thomas fuller 595730 595730 Shipton, Thomas, of Coscombe, fuller 0
4859243 2314266 2314266 defendant Shipton Thomas tucker 595730 595730 Shipton, Thomas, of Coscombe, tucker 0
4862205 2315193 2315193 defendant Sencler Thomas husbandman 595730 595730 Sencler, Thomas, of Coscombe, husbandman 4
4865205 2316092 2316092 defendant Atkyns Richard clerk 595730 595730 Atkyns, Richard, of Coscombe, clerk 0
4865215 2316093 2316093 defendant Atkyns Richard clerk 595730 595730 together with Atkyns, Richard, of Coscombe, clerk 4
5008314 2359320 2359320 defendant Rygges Rygges clothmaker 595730 595730 Rygges, Rygges, of Coscombe, clothmaker 1
5034830 2367042 2367042 defendant Crowdon William clothmaker 595730 595730 Crowdon, William, of Coscombe, clothmaker 0
5120790 2392511 2392511 defendant Voler John husbandman 595730 595730 Voler, John, of Coscombe, husbandman 2
5269554 2436199 2436199 defendant Dyer Thomas husbandman 595730 595730 Dyer, Thomas, of Coscombe, husbandman 0
5289374 2441895 2441895 defendant Donne or Doune Richard husbandman 595730 595730 Donne or Doune, Richard, of Coscombe, husbandman 0
5307316 2447193 2447193 defendant Strete Robert   595730 595730 Strete, Robert, of Coscombe, parson of the parish church 0
5313958 2449197 2449197 defendant Reve John laborer 595730 595730 Reve, John, of Coscombe, laborer 2
5325379 2452677 2452677 defendant Plenteythe John clothier 595730 595730 Plenteythe, John, of Coscombe, clothier 0
5337030 2456149 2456149 defendant Donne or Doune Richard husbandman 595730 595730 Donne or Doune, Richard, of Coscombe, husbandman 0
5391301 2472591 2472591 defendant Tafffe John weaver 595730 595730 Tafffe, John, of Coscombe, weaver 0
5404023 2476227 2476227 defendant Inge John dyer 595730 595730 Inge, John, of Coscombe, dyer 0
5449302 2489681 2489681 plaintiff More John (legal representative) 595730 595730 More, John, of Coscombe, clothier, executrix of 0
5490526 2502058 2502058 defendant Bondyche William husbandman 595730 595730 Bondyche, William, of Coscombe, husbandman 0
5533454 2515015 2515015 defendant Phelyppys John baker 595730 595730 Phelyppys, John, of Coscombe, baker 0
5595378 2533501 2533501 plaintiff Brasyer Richard weaver 595730 595730 Brasyer, Richard, of Coscombe, weaver 0
5626694 2552321 2552321 defendant Baker John merchant 595730 595730 Baker, John, of Coscombe, merchant 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);