names

74 rows where place_id = 592989

✎ 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
3609839 1870747 1870747 defendant Speckot John gent 592989 592989 Speckot, John, of Thornebury, gent 0
3610655 1871001 1871001 defendant Alfowe John husbandman 592989 592989 Alfowe, John, of Thornebury, husbandman 0
3682570 1920653 1920653 defendant Parker Henry weaver 592989 592989 Parker, Henry, of Thornebury, weaver 1
3683230 1920874 1920874 defendant Tayler Richard husbandman 592989 592989 Tayler, Richard, of Thornebury, husbandman 1
3692504 1923839 1923839 defendant Jakson John husbandman 592989 592989 Jakson, John, of Thornebury, husbandman 0
3692505 1923839 1923839 defendant Brugges John husbandman 592989 592989 Brugges, John, of Thornebury, husbandman 1
3698090 1925628 1925628 defendant Wynter John yeoman 592989 592989 Wynter, John, of Thornebury, yeoman 3
3717279 1931689 1931689 defendant Orchard Thomas tailor 592989 592989 Orchard, Thomas, of Thornebury, tailor 1
3722643 1933342 1933342 defendant Jonys Richard shoemaker 592989 592989 Jonys, Richard, of Thornebury, shoemaker 0
3810677 1961237 1961237 defendant Morgan Matilda widow 592989 592989 Morgan, Matilda, of Thornebury, widow 1
3822204 1964846 1964846 defendant Broun John husbandman 592989 592989 Broun, John, of Thornebury, husbandman 0
3839301 1970219 1970219 defendant Joldwyn John husbandman 592989 592989 Joldwyn, John, of Thornebury, husbandman 3
3886502 1985740 1985740 defendant Specott Edward gent 592989 592989 Specott, Edward, of Thornebury, gent 0
3908139 1993019 1993019 defendant Ackeborne Thomas   592989 592989 Ackeborne, Thomas, of Thornebury, Glos. Yeoman 1
3917840 1996326 1996326 defendant More John clothier 592989 592989 More, John, of Thornebury, clothier 0
3945656 2005556 2005556 defendant Eyton Ralph gent 592989 592989 Eyton, Ralph, of Thornebury, gent 0
3951275 2007512 2007512 defendant Jonys John clothier 592989 592989 Jonys, John, of Thornebury, clothier 1
3951276 2007512 2007512 defendant Hylpe John   592989 592989 Hylpe, John, of Thornebury, woollen draper 2
3977103 2016562 2016562 defendant Baynam John shoemaker 592989 592989 Baynam, John, of Thornebury, shoemaker 0
3997176 2023760 2023760 defendant Curteys John gent 592989 592989 Curteys, John, of Thornebury, or of Oldbery on Severn, gent 0
3997182 2023762 2023762 defendant Curteye John gent 592989 592989 Curteye, John, of Thornebury, or of Eldbery on Severne, gent 0
4036617 2037779 2037779 defendant Jeynes or Jones Richard yeoman 592989 592989 Jeynes or Jones, Richard, of Thornebury, yeoman 0
4036618 2037779 2037779 defendant Adye Richard weaver 592989 592989 Adye, Richard, of Thornebury, weaver 1
4036619 2037779 2037779 defendant Hall William husbandman 592989 592989 Hall, William, of Thornebury, husbandman 2
4036621 2037780 2037780 defendant Jeynes Richard yeoman 592989 592989 Jeynes, Richard, of Thornebury, yeoman 0
4036622 2037780 2037780 defendant Adye Richard weaver 592989 592989 Adye, Richard, of Thornebury, weaver 1
4036623 2037780 2037780 defendant Hall or Hawle William husbandman 592989 592989 Hall or Hawle, William, of Thornebury, husbandman 2
4036680 2037803 2037803 plaintiff Jones John yeoman 592989 592989 Jones, John, of Thornebury, yeoman 1
4140896 2074981 2074981 defendant Fowke or Foulkes Thomas gent 592989 592989 Fowke or Foulkes, Thomas, of Thornebury, gent 0
4140897 2074981 2074981 defendant Poyntz Francis esq 592989 592989 Poyntz, Francis, of Thornebury, esq 1
4165668 2083490 2083490 defendant Fowke Thomas gent 592989 592989 Fowke, Thomas, of Thornebury, gent 0
4165669 2083490 2083490 defendant Poynt Francis esq 592989 592989 Poynt, Francis, of Thornebury, esq 1
4178619 2087998 2087998 defendant Lewys John joiner 592989 592989 Lewys, John, of Thornebury, joiner 0
4372090 2155083 2155083 defendant Hellman Thomas yeoman 592989 592989 Hellman, Thomas, of Thornebury, yeoman 1
4401225 2165005 2165005 defendant Wisse Nicholas gent 592989 592989 Wisse, Nicholas, of Thornebury, gent 1
4476170 2193210 2193210 defendant Fyle John   592989 592989 Fyle, John, of Thornebury 0
4493984 2198811 2198811 defendant Dyghere William   592989 592989 Dyghere, William, of Thornebury 3
4493985 2198811 2198811 defendant Baker Radulfus   592989 592989 Baker, Radulfus, of Thornebury 4
4513545 2204660 2204660 plaintiff Broun _sils clerk 592989 592989 Broun, _sils, of Thornebury, clerk 0
4545094 2214384 2214384 defendant Perkyn Richard   592989 592989 Perkyn, Richard, of Thornebury 2
4587048 2227357 2227357 defendant Axebrigge John   592989 592989 Axebrigge, John, of Thornebury 0
4667084 2255438 2255438 defendant Brayne Robert mercer 592989 592989 Brayne, Robert, of Thornebury, mercer 0
4670108 2256352 2256352 defendant Blythe John draper 592989 592989 Blythe, John, of Thornebury, draper 0
4677381 2258543 2258543 defendant Stanburn John ploughman 592989 592989 Stanburn, John, of Thornebury, ploughman 0
4717336 2270755 2270755 defendant Champeney John yeoman 592989 592989 Champeney, John, of Thornebury, yeoman 0
4718948 2271271 2271271 defendant Champeney John yeoman 592989 592989 Champeney, John, of Thornebury, yeoman 0
4718950 2271272 2271272 defendant Champeney John yeoman 592989 592989 Champeney, John, of Thornebury, yeoman 0
4718952 2271273 2271273 defendant Champeney John yeoman 592989 592989 Champeney, John, of Thornebury, yeoman 0
4782677 2290597 2290597 defendant London John chapman 592989 592989 London, John, of Thornebury, chapman 0
4791904 2293570 2293570 defendant Hawekyn Robert husbandman 592989 592989 Hawekyn, Robert, of Thornebury, husbandman 0
4855070 2312936 2312936 plaintiff Algard Walter   592989 592989 Algard, Walter, of Thornebury 1
4857003 2313571 2313571 defendant Whyte William husbandman 592989 592989 Whyte, William, of Thornebury, husbandman 4
4886963 2322772 2322772 defendant Hawkyns Robert butcher 592989 592989 Hawkyns, Robert, of Thornebury, butcher 0
4895018 2325108 2325108 defendant Gwynney Isabel widow 592989 592989 Gwynney, Isabel, of Thornebury, widow 1
4935709 2337558 2337558 defendant Thomelyn Thomas shoemaker 592989 592989 Thomelyn, Thomas, of Thornebury, shoemaker 2
5097207 2385616 2385616 defendant Wall Simon yeoman 592989 592989 Wall, Simon, of Thornebury, yeoman 6
5167124 2406118 2406118 defendant Corun Nicholas esq 592989 592989 Corun, Nicholas, of Thornebury, esq 0
5172692 2407742 2407742 defendant Corun Nicholas gent 592989 592989 Corun, Nicholas, of Thornebury, gent 0
5203368 2416746 2416746 defendant Corun Nicholas esq 592989 592989 Corun, Nicholas, of Thornebury, esq 0
5218023 2421006 2421006 defendant Burnell Thomas yeoman 592989 592989 Burnell, Thomas, of Thornebury, yeoman 0
5230804 2424615 2424615 defendant Tommys John yeoman 592989 592989 Tommys, John, of Thornebury, yeoman 9
5237397 2426522 2426522 defendant Burnell Thomas yeoman 592989 592989 Burnell, Thomas, of Thornebury, yeoman 0
5350339 2460228 2460228 defendant Bereman Baldwin clerk 592989 592989 Bereman, Baldwin, of Thornebury, clerk 0
5385335 2470881 2470881 defendant Pyccher Thomas husbandman 592989 592989 Pyccher, Thomas, of Thornebury, husbandman 2
5385336 2470881 2470881 defendant Fedeler Richard husbandman 592989 592989 Fedeler, Richard, of Thornebury, husbandman 3
5385337 2470881 2470881 defendant Godeman Morgan husbandman 592989 592989 Godeman, Morgan, of Thornebury, husbandman 4
5454391 2491222 2491222 defendant Draper Richard husbandman 592989 592989 Draper, Richard, of Thornebury, husbandman 0
5489057 2501603 2501603 defendant Knyght John husbandman 592989 592989 Knyght, John, of Thornebury, husbandman 1
5490419 2502029 2502029 defendant Frenshe Thomas carpenter 592989 592989 Frenshe, Thomas, of Thornebury, carpenter 0
5496849 2503985 2503985 defendant Baggebeare Richard yeoman 592989 592989 Baggebeare, Richard, of Thornebury, yeoman 1
5496850 2503985 2503985 defendant Baggebeare William yeoman 592989 592989 Baggebeare, William, of Thornebury, yeoman 2
5510894 2508247 2508247 defendant Knyght John husbandman 592989 592989 Knyght, John, of Thornebury, husbandman 1
5528013 2513325 2513325 defendant Atkyns Thomas cordwainer 592989 592989 Atkyns, Thomas, of Thornebury, cordwainer 0
5576110 2527590 2527590 defendant Frensshe Robert clerk 592989 592989 Frensshe, Robert, of Thornebury, clerk 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);