names

1,405 rows where place_id = 585951

✎ 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
3587558 1863756 1863756 defendant Gruge Richard butcher 585951 585951 Gruge, Richard, of Winchester, butcher 0
3587605 1863770 1863770 defendant Alynson John weaver 585951 585951 Alynson, John, of Winchester, weaver 2
3588466 1864039 1864039 defendant Ayleward Henry yeoman 585951 585951 Ayleward, Henry, of Winchester, yeoman 0
3588480 1864042 1864042 defendant Wedoweston William yeoman 585951 585951 Wedoweston, William, of Winchester, yeoman 0
3588481 1864042 1864042 defendant Puttenham John gent 585951 585951 Puttenham, John, of Winchester, gent 1
3588920 1864185 1864185 plaintiff Bramden Stephen   585951 585951 Bramden, Stephen, of Winchester 0
3588922 1864186 1864186 plaintiff Bramden Stephen esq 585951 585951 Bramden, Stephen, of Winchester, esq 0
3588924 1864187 1864187 plaintiff Bramden Stephen esq 585951 585951 Bramden, Stephen, of Winchester, esq 0
3588926 1864188 1864188 plaintiff Bramden Stephen esq 585951 585951 Bramden, Stephen, of Winchester, esq 0
3588928 1864189 1864189 plaintiff Bramden Stephen merchant 585951 585951 Bramden, Stephen, of Winchester, esq, merchant 0
3588931 1864190 1864190 plaintiff Bramden Stephen merchant 585951 585951 Bramden, Stephen, of Winchester, esq, merchant 0
3589368 1864315 1864315 defendant Wellys John gent 585951 585951 Wellys, John, of Winchester, gent 0
3589664 1864409 1864409 defendant Boklond John mercer 585951 585951 Boklond, John, of Winchester, mercer 0
3589687 1864413 1864413 defendant Boklond John mercer 585951 585951 Boklond, John, of Winchester, mercer 1
3591874 1865076 1865076 defendant Barton William gent 585951 585951 Barton, William, of Winchester, gent 9
3594208 1865830 1865830 defendant Russhelton Richard gent 585951 585951 Russhelton, Richard, of Winchester, gent 1
3596839 1866647 1866647 defendant Squyer Edward smith 585951 585951 Squyer, Edward, of Winchester, smith 0
3597505 1866841 1866841 defendant Sankey or Saukey Thomas gent 585951 585951 Sankey or Saukey, Thomas, of Winchester, gent 0
3598639 1867197 1867197 defendant Buklond Thomas mercer 585951 585951 Buklond, Thomas, of Winchester, mercer 4
3601827 1868229 1868229 defendant Fesaunt Richard clerk 585951 585951 Fesaunt, Richard, of Winchester, clerk 0
3603473 1868753 1868753 defendant Parker Geoffrey (legal representative) 585951 585951 Parker, Geoffrey, of Winchester, executors of 0
3603474 1868753 1868753 defendant Gylys John innholder 585951 585951 (Gylys, John, of Winchester, innholder 1
3604598 1869102 1869102 defendant Faireford John chaplain 585951 585951 Faireford, John, of Winchester, chaplain 0
3604743 1869148 1869148 defendant Vyncent Thomas yeoman 585951 585951 Vyncent, Thomas, of Winchester, yeoman 0
3608255 1870236 1870236 plaintiff Stratford John gent 585951 585951 Stratford, John, of Winchester, gent 0
3608257 1870237 1870237 plaintiff Stratford John gent 585951 585951 Stratford, John, of Winchester, gent 0
3608381 1870280 1870280 defendant Palser Thomas scrivener 585951 585951 Palser, Thomas, of Winchester, scrivener 0
3608705 1870383 1870383 defendant Bokelond John chapman 585951 585951 Bokelond, John, of Winchester, chapman 2
3610190 1870850 1870850 defendant Osmonderlowe Peter tailor 585951 585951 Osmonderlowe, Peter, of Winchester, tailor 1
3610193 1870851 1870851 defendant Osmonderlowe Peter tailor 585951 585951 Osmonderlowe, Peter, of Winchester, tailor 1
3612972 1871705 1871705 defendant Sabyn John butcher 585951 585951 Sabyn, John, of Winchester, butcher 1
3613977 1872030 1872030 defendant Knollys William grocer 585951 585951 Knollys, William, of Winchester, grocer 0
3613979 1872031 1872031 defendant Knollys William grocer 585951 585951 Knollys, William, of Winchester, grocer 0
3615628 1872530 1872530 plaintiff Colnet Richard (legal representative) 585951 585951 Colnet, Richard, of Winchester, executors of 0
3617705 1873161 1873161 defendant Lancaster Hugh chapman 585951 585951 Lancaster, Hugh, of Winchester, chapman 0
3618561 1873430 1873430 defendant Knollys William mercer 585951 585951 Knollys, William, of Winchester, mercer 0
3618579 1873435 1873435 defendant Lancastre Hugh upholsterer 585951 585951 Lancastre, Hugh, of Winchester, upholsterer 0
3619692 1873729 1873729 defendant Fynche Simon clothmaker 585951 585951 Fynche, Simon, of Winchester, clothmaker 0
3619699 1873731 1873731 defendant Fynche Simon clothmaker 585951 585951 Fynche, Simon, of Winchester, clothmaker 1
3619949 1873814 1873814 defendant Colnett Richard (legal representative) 585951 585951 Colnett, Richard, of Winchester, executors of 0
3620032 1873839 1873839 plaintiff Knolles William grocer 585951 585951 Knolles, William, of Winchester, grocer 0
3620297 1873927 1873927 defendant Dyker Nicholas gent 585951 585951 Dyker, Nicholas, of Winchester, gent 0
3622331 1874521 1874521 defendant Cowedrey Edward gent 585951 585951 Cowedrey, Edward, of Winchester, gent 1
3625143 1875398 1875398 defendant Buklond John mercer 585951 585951 Buklond, John, of Winchester, mercer 0
3629928 1904216 1904216 defendant Mone Edward yeoman 585951 585951 Mone, Edward, of Winchester, yeoman 0
3632215 1904891 1904891 defendant Wattys Adam fishmonger 585951 585951 Wattys, Adam, of Winchester, fishmonger 0
3641313 1907734 1907734 defendant Halles William gent 585951 585951 Halles, William, of Winchester, gent 0
3648656 1909966 1909966 defendant Jamys John yeoman 585951 585951 Jamys, John, of Winchester, yeoman 0
3648657 1909966 1909966 defendant Crofter Roger butcher 585951 585951 Crofter, Roger, of Winchester, butcher 1
3652476 1911106 1911106 plaintiff Vyncent Thomas   585951 585951 Vyncent, Thomas, of Winchester 0
3658134 1912801 1912801 defendant Dale John, senior gent 585951 585951 Dale, John, senior, of Winchester, gent 0
3659722 1913292 1913292 defendant Jonys Thomas mercer 585951 585951 Jonys, Thomas, of Winchester, mercer 0
3661975 1914037 1914037 defendant Bedham Stephen fuller 585951 585951 Bedham, Stephen, of Winchester, fuller 1
3662908 1914313 1914313 plaintiff Newport Richard (legal representative) 585951 585951 Newport, Richard, of Winchester, clerk & provost of the College Chapel of St Elizabeth, executor of 0
3664385 1914812 1914812 defendant Hyll John draper 585951 585951 Hyll, John, of Winchester, draper 0
3666918 1915597 1915597 defendant Owen Jasper gent 585951 585951 Owen, Jasper, of Winchester, gent 0
3668423 1916075 1916075 defendant Blache Mathew fuller 585951 585951 Blache, Mathew, of Winchester, fuller 0
3668424 1916075 1916075 defendant Wyngham Ralph laborer 585951 585951 Wyngham, Ralph, of Winchester, laborer 1
3669528 1916407 1916407 defendant Halles William gent 585951 585951 Halles, William, of Winchester, gent 0
3670834 1916844 1916844 defendant Pudsey Richard gent 585951 585951 Pudsey, Richard, of Winchester, gent 0
3673006 1917565 1917565 defendant Geffrey Richard chapman 585951 585951 Geffrey, Richard, of Winchester, chapman 4
3673059 1917583 1917583 defendant Bedham Stephen clothman 585951 585951 Bedham, Stephen, of Winchester, clothman 0
3675170 1918266 1918266 defendant Spencer Richard clothmaker 585951 585951 Spencer, Richard, of Winchester, clothmaker 1
3675173 1918267 1918267 defendant Spencer Richard clothmaker 585951 585951 Spencer, Richard, of Winchester, clothmaker 0
3680407 1919956 1919956 defendant Whale Robert tiler 585951 585951 Whale, Robert, of Winchester, tiler 0
3680408 1919956 1919956 defendant Stopam James   585951 585951 Stopam, James, of Winchester, parchment maker 1
3680409 1919956 1919956 defendant Wodeson Walter barber 585951 585951 Wodeson, Walter, of Winchester, barber 2
3680410 1919956 1919956 defendant Bilbery Thomas   585951 585951 Bilbery, Thomas, of Winchester, parchment maker 3
3687694 1922320 1922320 defendant Vaghan Philip butcher 585951 585951 Vaghan, Philip, of Winchester, butcher 0
3687695 1922320 1922320 defendant Wheler Richard   585951 585951 Wheler, Richard, of Winchester, tallow chandler 1
3687696 1922320 1922320 defendant Baynam George weaver 585951 585951 Baynam, George, of Winchester, weaver 2
3687698 1922321 1922321 defendant Vaghan Philip butcher 585951 585951 Vaghan, Philip, of Winchester, butcher 0
3687699 1922321 1922321 defendant Wheler Richard   585951 585951 Wheler, Richard, of Winchester, tallow chandler 1
3687700 1922321 1922321 defendant Baynam George weaver 585951 585951 Baynam, George, of Winchester, weaver 2
3692403 1923801 1923801 defendant Pett Thomas clothier 585951 585951 Pett, Thomas, of Winchester, clothier 0
3693622 1924199 1924199 defendant Wright Thomas yeoman 585951 585951 Wright, Thomas, of Winchester, yeoman 1
3702742 1927129 1927129 defendant Baker Thomas clothier 585951 585951 Baker, Thomas, of Winchester, clothier 1
3702746 1927130 1927130 defendant Baker Thomas clothier 585951 585951 Baker, Thomas, of Winchester, clothier 1
3720526 1932701 1932701 defendant Dedham Stephen innholder 585951 585951 Dedham, Stephen, of Winchester, innholder 2
3723766 1933709 1933709 defendant Newbury Robert mercer 585951 585951 Newbury, Robert, of Winchester, mercer 0
3730966 1935917 1935917 defendant (not given) Ralph vicar of Barnake 585951 585951 Barnake, Ralph, of Winchester, vicar of Abberbury, Oxon 0
3731411 1936047 1936047 plaintiff Cartred Philip tailor 585951 585951 Cartred, Philip, of Winchester, tailor 0
3731412 1936047 1936047 plaintiff Power Edmund plumber 585951 585951 Power, Edmund, of Winchester, plumber 1
3739206 1938480 1938480 defendant Bedham Stephen clothman 585951 585951 Bedham, Stephen, of Winchester, clothman 0
3741556 1939228 1939228 defendant Skynner John clothman 585951 585951 Skynner, John, of Winchester, clothman 0
3742649 1939569 1939569 defendant Reynold Richard clothier 585951 585951 Reynold, Richard, of Winchester, clothier 4
3742650 1939569 1939569 defendant Jonys Thomas chapman 585951 585951 Jonys, Thomas, of Winchester, chapman 5
3742882 1939629 1939629 defendant Laurence Gilbert butcher 585951 585951 Laurence, Gilbert, of Winchester, butcher 0
3746071 1940677 1940677 plaintiff Chaundeler Walter merchant 585951 585951 Chaundeler, Walter, of Winchester, merchant 0
3747236 1941055 1941055 defendant Howleys William gent 585951 585951 Howleys, William, of Winchester, gent 0
3754462 1943353 1943353 defendant Charde John   585951 585951 Charde, John, of Winchester 1
3766457 1947166 1947166 defendant Newbery Robert chapman 585951 585951 Newbery, Robert, of Winchester, chapman 1
3769756 1948195 1948195 defendant Kyngesmyll Edward yeoman 585951 585951 Kyngesmyll, Edward, of Winchester, yeoman 0
3771328 1948723 1948723 defendant Sandys Thomas esq 585951 585951 Sandys, Thomas, of Winchester, esq 0
3771330 1948724 1948724 defendant Sandys Thomas esq 585951 585951 Sandys, Thomas, of Winchester, esq 0
3771783 1948875 1948875 defendant Sherde Hugh husbandman 585951 585951 (Sherde, Hugh, of Winchester, husbandman 1
3772508 1949094 1949094 defendant Geffrey Richard   585951 585951 Geffrey, Richard, of Winchester, apothecary 1
3772778 1949179 1949179 defendant Boterell Robert yeoman 585951 585951 Boterell, Robert, of Winchester, yeoman 0
3787361 1953840 1953840 defendant Ingram John tailor 585951 585951 Ingram, John, of Winchester, tailor 0
3790169 1954744 1954744 defendant Coke John gent 585951 585951 Coke, John, of Winchester, gent 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);