names

174 rows where place_id = 593772

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613257 1871799 1871799 defendant Gibons William husbandman 593772 593772 Gibons, William, of Kyngton, husbandman 1
3680702 1920045 1920045 defendant Lyghtfote John husbandman 593772 593772 Lyghtfote, John, of Kyngton, husbandman 0
3706344 1928272 1928272 defendant Blewe Henry laborer 593772 593772 Blewe, Henry, of Kyngton, laborer 0
3706345 1928272 1928272 defendant Bate Thomas laborer 593772 593772 Bate, Thomas, of Kyngton, laborer 1
3739266 1938500 1938500 defendant Gough Griffith yeoman 593772 593772 Gough, Griffith, of Kyngton, yeoman 7
3749366 1941722 1941722 defendant Hunte John husbandman 593772 593772 Hunte, John, of Kyngton, husbandman 0
3780722 1951703 1951703 defendant Caws Richard yeoman 593772 593772 Caws, Richard, of Kyngton, yeoman 0
3788370 1954162 1954162 plaintiff Snell alias Shenell Richard yeoman of the crown 593772 593772 Snell alias Shenell, Richard, of Kyngton, yeoman of the crown 0
3788375 1954163 1954163 plaintiff Snell Richard yeoman of the crown 593772 593772 Snell, Richard, of Kyngton, yeoman of the crown 0
3788378 1954164 1954164 plaintiff Snell Richard yeoman of the crown 593772 593772 Snell, Richard, of Kyngton, yeoman of the crown 0
3805870 1959776 1959776 defendant Grene Simon husbandman 593772 593772 Grene, Simon, of Kyngton, husbandman 0
3822096 1964805 1964805 plaintiff Snell Richard yeoman of the king 593772 593772 Snell, Richard, of Kyngton, yeoman of the king 0
3822100 1964806 1964806 plaintiff Snell Richard yeoman of the king 593772 593772 Snell, Richard, of Kyngton, yeoman of the king 0
3837430 1969615 1969615 plaintiff Snell Richard   593772 593772 Snell, Richard, of Kyngton 0
3847963 1972938 1972938 defendant Savage Leonard yeoman 593772 593772 Savage, Leonard, of Kyngton, yeoman 1
3885380 1985365 1985365 defendant Vaughan Alice widow 593772 593772 Vaughan, Alice, of Kyngton, widow 0
3885381 1985365 1985365 defendant Bulcott John butcher 593772 593772 Bulcott, John, of Kyngton, butcher 1
3886653 1985789 1985789 defendant Bultys Anthony husbandman 593772 593772 Bultys, Anthony, of Kyngton, husbandman 0
3886656 1985790 1985790 defendant Clough John husbandman 593772 593772 Clough, John, of Kyngton, husbandman 0
3887974 1986229 1986229 plaintiff Davys John clerk 593772 593772 Davys, John, of Kyngton, clerk 0
3890026 1986900 1986900 defendant ap Rees Lewis husbandman 593772 593772 ap Rees, Lewis, of Kyngton, husbandman 3
3895380 1988665 1988665 plaintiff Snell Richard esq 593772 593772 Snell, Richard, of Kyngton, esq 0
3896575 1989061 1989061 defendant Baker Maurice weaver 593772 593772 Baker, Maurice, of Kyngton, weaver 0
3897088 1989246 1989246 defendant Basenett Philip yeoman 593772 593772 Basenett, Philip, of Kyngton, yeoman 2
3897416 1989349 1989349 defendant Davys John chaplain 593772 593772 Davys, John, of Kyngton, chaplain 4
3899154 1989923 1989923 defendant Hall Thomas, senior yeoman 593772 593772 Hall, Thomas, senior, of Kyngton, yeoman 0
3899155 1989923 1989923 defendant Hall Thomas, junior husbandman 593772 593772 Hall, Thomas, junior, of Kyngton, husbandman 1
3899156 1989923 1989923 defendant Bulcote William husbandman 593772 593772 Bulcote, William, of Kyngton, husbandman 2
3910944 1993984 1993984 defendant Baker John weaver 593772 593772 Baker, John, of Kyngton, weaver 0
3910946 1993985 1993985 defendant Clement John glover 593772 593772 Clement, John, of Kyngton, glover 0
3925212 1998743 1998743 defendant Vaughan Richard gent 593772 593772 Vaughan, Richard, of Kyngton, gent 0
3951010 2007419 2007419 defendant Llewellyn John husbandman 593772 593772 Llewellyn, John, of Kyngton, husbandman 0
3973436 2015281 2015281 defendant Ayleworthe Francis gent 593772 593772 Ayleworthe, Francis, of Kyngton, gent 0
3974182 2015539 2015539 defendant Ewyn William mercer 593772 593772 Ewyn, William, of Kyngton, mercer 0
3974756 2015737 2015737 defendant Knyght John husbandman 593772 593772 Knyght, John, of Kyngton, husbandman 4
4000193 2024836 2024836 defendant Walker Oliver yeoman 593772 593772 Walker, Oliver, of Kyngton, yeoman 0
4008508 2027811 2027811 defendant Scaundrett Oliver yeoman 593772 593772 Scaundrett, Oliver, of Kyngton, yeoman 3
4008513 2027812 2027812 defendant ap Lewys Rice yeoman 593772 593772 ap Lewys, Rice, of Kyngton, yeoman 3
4013047 2029397 2029397 defendant Vaughan Richard gent 593772 593772 Vaughan, Richard, of Kyngton, gent 2
4014226 2029816 2029816 defendant ap John John yeoman 593772 593772 ap John, John, of Kyngton, yeoman 0
4014228 2029817 2029817 defendant Clement William yeoman 593772 593772 Clement, William, of Kyngton, yeoman 0
4018148 2031213 2031213 plaintiff Turner John   593772 593772 Turner, John, of Kyngton 0
4018940 2031509 2031509 defendant Harper Oliver gent 593772 593772 Harper, Oliver, of Kyngton, gent 1
4022966 2032934 2032934 defendant Bassett William yeoman 593772 593772 Bassett, William, of Kyngton, yeoman 1
4025948 2033929 2033929 defendant Harper Oliver yeoman 593772 593772 Harper, Oliver, of Kyngton, yeoman 0
4032387 2036245 2036245 defendant Scaunbrett Oliver yeoman 593772 593772 Scaunbrett, Oliver, of Kyngton, yeoman 16
4032449 2036253 2036253 defendant Rychard John yeoman 593772 593772 Rychard, John, of Kyngton, yeoman 7
4041817 2039555 2039555 defendant Farmer Lewis husbandman 593772 593772 Farmer, Lewis, of Kyngton, husbandman 0
4042017 2039633 2039633 defendant Farmer Lewis husbandman 593772 593772 Farmer, Lewis, of Kyngton, husbandman 0
4042911 2039940 2039940 defendant Hall Thomas husbandman 593772 593772 Hall, Thomas, of Kyngton, husbandman 0
4042912 2039940 2039940 defendant Hall Oliver husbandman 593772 593772 Hall, Oliver, of Kyngton, husbandman 1
4042914 2039941 2039941 defendant Hall Thomas husbandman 593772 593772 Hall, Thomas, of Kyngton, husbandman 0
4042915 2039941 2039941 defendant Hall Oliver husbandman 593772 593772 Hall, Oliver, of Kyngton, husbandman 1
4052872 2043462 2043462 defendant Tryamore alias Enarde John tailor 593772 593772 Tryamore alias Enarde, John, of Kyngton, tailor 2
4053699 2043701 2043701 defendant Scandrett Edward yeoman 593772 593772 Scandrett, Edward, of Kyngton, yeoman 0
4053700 2043701 2043701 defendant ap Lewes Rice gent 593772 593772 ap Lewes, Rice, of Kyngton, gent 1
4056776 2044806 2044806 defendant Maholam William yeoman 593772 593772 Maholam, William, of Kyngton, yeoman 0
4066934 2048470 2048470 defendant Clement William glover 593772 593772 Clement, William, of Kyngton, glover 2
4068112 2048901 2048901 defendant Moholom or Mohollone John, junior weaver 593772 593772 Moholom or Mohollone, John, junior, of Kyngton, weaver 2
4069857 2049504 2049504 defendant Apwell John yeoman 593772 593772 Apwell, John, of Kyngton, yeoman 0
4069917 2049522 2049522 defendant Rychard John yeoman 593772 593772 Rychard, John, of Kyngton, yeoman 1
4076847 2052004 2052004 defendant Sayer James yeoman 593772 593772 Sayer, James, of Kyngton, yeoman 0
4076927 2052035 2052035 defendant Lylwall George smith 593772 593772 Lylwall, George, of Kyngton, smith 0
4079383 2052930 2052930 defendant Baker John butcher 593772 593772 Baker, John, of Kyngton, butcher 0
4079384 2052930 2052930 defendant Gryffyth Edmund husbandman 593772 593772 Gryffyth, Edmund, of Kyngton, husbandman 1
4093251 2057905 2057905 defendant Rychard John yeoman 593772 593772 Rychard, John, of Kyngton, yeoman 1
4097059 2059271 2059271 defendant Harper Oliver yeoman 593772 593772 Harper, Oliver, of Kyngton, yeoman 0
4102298 2061112 2061112 defendant Moholan John yeoman 593772 593772 Moholan, John, of Kyngton, yeoman 1
4110535 2064030 2064030 defendant Spencer Thomas shoemaker 593772 593772 Spencer, Thomas, of Kyngton, shoemaker 0
4110536 2064030 2064030 defendant Scaundrett Richard, junior husbandman 593772 593772 Scaundrett, Richard, junior, of Kyngton, husbandman 1
4110540 2064031 2064031 defendant Taylor Thomas cordwainer 593772 593772 Taylor, Thomas, of Kyngton, cordwainer 0
4110541 2064031 2064031 defendant ap Thomas Jevan cordwainer 593772 593772 ap Thomas, Jevan, of Kyngton, cordwainer 1
4112521 2064734 2064734 defendant Jeffrey Jevan weaver 593772 593772 Jeffrey, Jevan, of Kyngton, weaver 0
4112522 2064734 2064734 defendant Sayer James yeoman 593772 593772 Sayer, James, of Kyngton, yeoman 1
4117186 2066453 2066453 defendant Powell Walter mercer 593772 593772 Powell, Walter, of Kyngton, mercer 1
4117190 2066454 2066454 defendant Powell Walter mercer 593772 593772 Powell, Walter, of Kyngton, mercer 1
4118431 2066884 2066884 defendant Vaughan John   593772 593772 Vaughan, John, of Kyngton, Herefs gent 0
4139734 2074573 2074573 defendant Scaundrett Rice dyer 593772 593772 Scaundrett, Rice, of Kyngton, dyer 0
4139735 2074573 2074573 defendant Taylor Thomas husbandman 593772 593772 Taylor, Thomas, of Kyngton, husbandman 1
4139736 2074573 2074573 defendant Powell John yeoman 593772 593772 Powell, John, of Kyngton, yeoman 2
4139740 2074573 2074573 defendant Wyllyms Thomas shoemaker 593772 593772 Wyllyms, Thomas, of Kyngton, shoemaker 6
4139741 2074573 2074573 defendant Turner John yeoman 593772 593772 Turner, John, of Kyngton, yeoman 7
4143657 2075938 2075938 defendant Harper Thomas husbandman 593772 593772 Harper, Thomas, of Kyngton, husbandman 0
4143658 2075938 2075938 defendant Harper Meredith husbandman 593772 593772 Harper, Meredith, of Kyngton, husbandman 1
4143659 2075938 2075938 defendant Rogers William husbandman 593772 593772 Rogers, William, of Kyngton, husbandman 2
4151335 2078589 2078589 defendant Howell John cooper 593772 593772 Howell, John, of Kyngton, cooper 1
4151703 2078709 2078709 defendant Evans Owen shoemaker 593772 593772 Evans, Owen, of Kyngton, shoemaker 0
4152395 2078947 2078947 defendant Scaundrett George yeoman 593772 593772 Scaundrett, George, of Kyngton, yeoman 2
4156612 2080390 2080390 defendant Feylde Henry yeoman 593772 593772 Feylde, Henry, of Kyngton, yeoman 0
4159427 2081364 2081364 defendant Goughe Edward drover 593772 593772 Goughe, Edward, of Kyngton, drover 0
4159428 2081364 2081364 defendant Maylard Thomas capper 593772 593772 Maylard, Thomas, of Kyngton, capper 1
4159544 2081406 2081406 defendant Maylard Thomas yeoman 593772 593772 Maylard, Thomas, of Kyngton, yeoman 1
4164538 2083109 2083109 defendant Staundrett or Scaundrett Rice dyer 593772 593772 together with Staundrett or Scaundrett, Rice, of Kyngton, dyer 6
4164543 2083109 2083109 defendant Lewes Thomas husbandman 593772 593772 Lewes, Thomas, of Kyngton, husbandman 11
4164544 2083109 2083109 defendant Williams Thomas shoemaker 593772 593772 Williams, Thomas, of Kyngton, shoemaker 12
4170292 2085102 2085102 defendant Rychard Roger yeoman 593772 593772 Rychard, Roger, of Kyngton, yeoman 0
4171903 2085635 2085635 defendant Fyelde Henry yeoman 593772 593772 Fyelde, Henry, of Kyngton, yeoman 1
4177116 2087470 2087470 defendant Amore William yeoman 593772 593772 Amore, William, of Kyngton, yeoman 0
4177358 2087553 2087553 defendant Fyld Henry yeoman 593772 593772 Fyld, Henry, of Kyngton, yeoman 0
4177955 2087763 2087763 defendant Feyld Henry yeoman 593772 593772 Feyld, Henry, of Kyngton, yeoman 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);