names

182 rows where place_id = 590605

✎ 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
3601764 1868210 1868210 defendant Sharpe John tanner 590605 590605 Sharpe, John, of Burton on Trent, Staffs, tanner 0
3603363 1868724 1868724 defendant Bredon William husbandman 590605 590605 Bredon, William, of Burton on Trent, Staffs, husbandman 0
3605674 1869439 1869439 defendant Gilbert William   590605 590605 Gilbert, William, of Burton on Trent, Staffs, cartwright 0
3618140 1873298 1873298 defendant Hyde William, senior yeoman 590605 590605 Hyde, William, senior, of Burton on Trent, Staffs, yeoman 0
3623554 1874896 1874896 defendant Barbour Thomas chapman 590605 590605 Barbour, Thomas, of Burton on Trent, Staffs, chapman 1
3651715 1910892 1910892 defendant Bradburn William chapman 590605 590605 Bradburn, William, of Burton on Trent, Staffs, chapman 2
3651720 1910893 1910893 defendant Bradburn William chapman 590605 590605 Bradburn, William, of Burton on Trent, Staffs, chapman 3
3652588 1911144 1911144 defendant Marler Roger   590605 590605 Marler, Roger, of Burton on Trent, Staffs, notary public 0
3672723 1917474 1917474 defendant Dylke Thomas yeoman 590605 590605 Dylke, Thomas, of Burton on Trent, Staffs, yeoman 1
3690179 1923085 1923085 defendant Purdon Edward gent 590605 590605 Purdon, Edward, of Burton on Trent, Staffs, gent 1
3691758 1923583 1923583 defendant Crumwell Thomas chapman 590605 590605 Crumwell, Thomas, of Burton on Trent, Staffs, chapman 0
3708288 1928887 1928887 defendant Shyngull James draper 590605 590605 Shyngull, James, of Burton on Trent, Staffs, draper 1
3717355 1931710 1931710 defendant Pemmerton John, senior saddler 590605 590605 Pemmerton, John, senior, of Burton on Trent, Staffs, saddler 0
3719740 1932439 1932439 defendant Goodale John baker 590605 590605 Goodale, John, of Burton on Trent, Staffs, baker 1
3723875 1933746 1933746 defendant Knyghtsall William butcher 590605 590605 Knyghtsall, William, of Burton on Trent, Staffs, butcher 0
3727664 1934925 1934925 defendant Blount Walter gent 590605 590605 Blount, Walter, of Burton on Trent, Staffs, gent 4
3735469 1937330 1937330 defendant Goodcole John baker 590605 590605 Goodcole, John, of Burton on Trent, Staffs, baker 0
3754474 1943356 1943356 defendant Cromwell Thomas mercer 590605 590605 Cromwell, Thomas, of Burton on Trent, Staffs, mercer 0
3800450 1958064 1958064 defendant Roundell John dyer 590605 590605 Roundell, John, of Burton on Trent, Staffs, dyer 1
3806935 1960078 1960078 defendant Blounte Walter gent 590605 590605 Blounte, Walter, of Burton on Trent, Staffs, gent 1
3817525 1963386 1963386 defendant Attoone Robert miller 590605 590605 Attoone, Robert, of Burton on Trent, Staffs, miller 1
3851771 1974143 1974143 defendant Bradsshaue John yeoman 590605 590605 Bradsshaue, John, of Burton on Trent, Staffs, yeoman 2
3855171 1975251 1975251 defendant Saunders William mercer 590605 590605 Saunders, William, of Burton on Trent, Staffs, mercer 0
3855176 1975252 1975252 defendant Saunders William mercer 590605 590605 Saunders, William, of Burton on Trent, Staffs, mercer 0
3856042 1975515 1975515 defendant Parker Richard   590605 590605 (Parker, Richard, of Burton on Trent, Staffs, "alloblaster" 1
3856051 1975518 1975518 defendant Parker Richard   590605 590605 (Parker, Richard, of Burton on Trent, Staffs, "alloblaster" 1
3884450 1985071 1985071 defendant Goodcole John yeoman 590605 590605 Goodcole, John, of Burton on Trent, Staffs, yeoman 0
3892896 1987870 1987870 defendant Goodcall John gent 590605 590605 Goodcall, John, of Burton on Trent, Staffs, gent 4
3902186 1990966 1990966 defendant Goodcole John yeoman 590605 590605 Goodcole, John, of Burton on Trent, Staffs, yeoman 0
3905833 1992234 1992234 defendant Broke Robert yeoman 590605 590605 Broke, Robert, of Burton on Trent, Staffs, yeoman 0
3915508 1995555 1995555 defendant Hylls William innholder 590605 590605 Hylls, William, of Burton on Trent, Staffs, innholder 0
3921054 1997392 1997392 defendant Cauldewell William draper 590605 590605 Cauldewell, William, of Burton on Trent, Staffs, draper 0
3952983 2008111 2008111 defendant Smyth Mathew chapman 590605 590605 Smyth, Mathew, of Burton on Trent, Staffs, chapman 0
3959048 2010246 2010246 defendant Lynde John draper 590605 590605 Lynde, John, of Burton on Trent, Staffs, or of London, draper 0
3962754 2011559 2011559 defendant Berdmore Richard glover 590605 590605 Berdmore, Richard, of Burton on Trent, Staffs, glover 2
3969608 2013979 2013979 defendant Smyth Mathew chapman 590605 590605 Smyth, Mathew, of Burton on Trent, Staffs, chapman 1
3972184 2014832 2014832 defendant Edyall Henry   590605 590605 Edyall, Henry, of Burton on Trent, Staffs, yeoman, son of James Edyall, of Banbury, Oxon 0
4071892 2050247 2050247 defendant Blunte Edward gent 590605 590605 Blunte, Edward, of Burton on Trent, Staffs, gent 2
4085573 2055113 2055113 defendant Blunye Edward gent 590605 590605 Blunye, Edward, of Burton on trent, Staffs, gent 0
4087808 2055933 2055933 defendant Blunt or Blount Edward gent 590605 590605 Blunt or Blount, Edward, of Burton on Trent, Staffs, gent 0
4093672 2058060 2058060 defendant Dethick William gent 590605 590605 Dethick, William, of Burton on Trent, Staffs, gent 0
4093676 2058062 2058062 defendant Dethycke William gent 590605 590605 Dethycke, William, of Burton on Trent, Staffs, gent 0
4115575 2065857 2065857 defendant Fichett Thomas mercer 590605 590605 Fichett, Thomas, of Burton on Trent, Staffs, mercer 0
4144156 2076119 2076119 defendant Blunte Edward gent 590605 590605 Blunte, Edward, of Burton on Trent, Staffs, gent 0
4165353 2083390 2083390 defendant Hawk William chapman 590605 590605 Hawk, William, of Burton on Trent, Staffs, chapman 0
4181434 2088984 2088984 defendant Darke Richard tailor 590605 590605 Darke, Richard, of Burton on Trent, Staffs, tailor 1
4243924 2110948 2110948 defendant Cotton William gent 590605 590605 Cotton, William, of Burton on Trent, Staffs, or of Maunsfeild in Sherwood, Notts, gent 0
4254461 2114482 2114482 defendant Fynince John chapman 590605 590605 Fynince, John, of Burton on Trent, Staffs, chapman 1
4267170 2118658 2118658 defendant Fynnee John chapman 590605 590605 Fynnee, John, of Burton on Trent, Staffs, chapman 2
4325766 2138994 2138994 defendant Clarke Richard chapman 590605 590605 Clarke, Richard, of Burton on Trent, Staffs, chapman 0
4357839 2149982 2149982 defendant Badworth Edward yeoman 590605 590605 Badworth, Edward, of Burton on Trent, Staffs, yeoman 2
4388487 2160788 2160788 defendant Clarke Henry clothier 590605 590605 Clarke, Henry, of Burton on Trent, Staffs, clothier 0
4558618 2218649 2218649 plaintiff Lynge Henry   590605 590605 Lynge, Henry, of Burton on Trent, Staffs 0
4663007 2249894 2249894 defendant Surburgh John   590605 590605 Surburgh, John, of Burton on Trent, Staffs, fair carter 1
4664909 2250504 2250504 defendant Straunge John chapman 590605 590605 Straunge, John, of Burton on Trent, Staffs, chapman 5
4678573 2258906 2258906 defendant Pype Robert yeoman 590605 590605 Pype, Robert, of Burton on Trent, Staffs, yeoman 0
4687710 2261730 2261730 defendant Ruble William butcher 590605 590605 Ruble, William, of Burton on Trent, Staffs, butcher 0
4689314 2262218 2262218 defendant Snawe William yeoman 590605 590605 Snawe, William, of Burton on Trent, Staffs, yeoman 1
4691619 2262909 2262909 defendant Wodward Walter draper 590605 590605 Wodward, Walter, of Burton on Trent, Staffs, draper 0
4697607 2264739 2264739 defendant Hanse John taverner 590605 590605 Hanse, John, of Burton on Trent, Staffs, taverner 0
4697610 2264740 2264740 defendant Hause John taverner 590605 590605 Hause, John, of Burton on Trent, Staffs, taverner 0
4715013 2270026 2270026 defendant Snawe William yeoman 590605 590605 Snawe, William, of Burton on Trent, Staffs, yeoman 2
4715016 2270026 2270026 defendant Cook John butcher 590605 590605 Cook, John, of Burton on Trent, Staffs, butcher 5
4731473 2275043 2275043 defendant Lyngge John merchant 590605 590605 Lyngge, John, of Burton on Trent, Staffs, merchant 0
4731834 2275144 2275144 defendant Snawe William yeoman 590605 590605 Snawe, William, of Burton on Trent, Staffs, yeoman 1
4761049 2283805 2283805 defendant Lombe Thomas laborer 590605 590605 Lombe, Thomas, of Burton on Trent, Staffs, laborer 1
4784363 2291110 2291110 defendant Lombe Thomas laborer 590605 590605 Lombe, Thomas, of Burton on Trent, Staffs, laborer 1
4790738 2293189 2293189 defendant Lanton or Lauton William tailor 590605 590605 Lanton or Lauton, William, of Burton on Trent, Staffs, tailor 0
4816751 2301336 2301336 defendant Bragge William   590605 590605 Bragge, William, of Burton on Trent, Staffs, sow gelder 0
4855057 2312933 2312933 defendant Whyte Lawrence   590605 590605 Whyte, Lawrence, of Burton on Trent, Staffs, wright 2
4862670 2315308 2315308 defendant Shene Joan   590605 590605 Shene, Joan, of Burton on Trent, Staffs, servant 3
4870066 2317603 2317603 defendant Sapurton Thomas chaplain 590605 590605 Sapurton, Thomas, of Burton on Trent, Staffs, chaplain 3
4882239 2321353 2321353 defendant Koe Roger barber 590605 590605 Koe, Roger, of Burton on Trent, Staffs, barber 1
4901281 2327009 2327009 defendant Baxter Thomas yeoman 590605 590605 Baxter, Thomas, of Burton on Trent, Staffs, yeoman 1
4901285 2327011 2327011 defendant Lynham John yeoman 590605 590605 Lynham, John, of Burton on Trent, Staffs, yeoman 0
4916036 2331517 2331517 defendant Olyver Robert husbandman 590605 590605 Olyver, Robert, of Burton on Trent, Staffs, husbandman 0
4927522 2335044 2335044 defendant Blagge John   590605 590605 Blagge, John, of Burton on Trent, Staffs, wright 0
4935583 2337521 2337521 defendant Peyntour William chapman 590605 590605 Peyntour, William, of Burton on Trent, Staffs, chapman 0
4952778 2342788 2342788 defendant Blage John carpenter 590605 590605 Blage, John, of Burton on Trent, Staffs, carpenter 2
4998775 2356521 2356521 defendant Sadeler Henry chaplain 590605 590605 Sadeler, Henry, of Burton on Trent, Staffs, chaplain 3
5017852 2362104 2362104 defendant Prudhom Richard merchant 590605 590605 Prudhom, Richard, of Burton on Trent, Staffs, merchant 0
5017854 2362105 2362105 defendant Prudhom William merchant 590605 590605 Prudhom, William, of Burton on Trent, Staffs, merchant 0
5021002 2363041 2363041 defendant Ryder Thomas draper 590605 590605 Ryder, Thomas, of Burton on Trent, Staffs, draper 0
5034057 2366825 2366825 defendant Draper Thomas   590605 590605 Draper, Thomas, of Burton on Trent, Staffs, "bedemaker" 3
5036814 2367644 2367644 defendant Brid John ostler 590605 590605 Brid, John, of Burton on Trent, Staffs, ostler 1
5055174 2373125 2373125 defendant Grene John dyer 590605 590605 Grene, John, of Burton on Trent, Staffs, dyer 0
5060573 2374742 2374742 defendant Whitfeld Robert chapman 590605 590605 Whitfeld, Robert, of Burton on Trent, Staffs, chapman 3
5060578 2374743 2374743 defendant Whitfeld Robert chapman 590605 590605 Whitfeld, Robert, of Burton on Trent, Staffs, chapman 2
5061972 2375182 2375182 defendant Whitfelde Robert chapman 590605 590605 Whitfelde, Robert, of Burton on Trent, Staffs, chapman 0
5064286 2375864 2375864 defendant Rukley Robert heuster or dyer 590605 590605 Rukley, Robert, of Burton on Trent, Staffs, heuster or dyer 0
5071898 2378089 2378089 defendant Purdon Richard merchant 590605 590605 Purdon, Richard, of Burton on Trent, Staffs, merchant 0
5080146 2380548 2380548 defendant Whittefeld Robert merchant 590605 590605 Whittefeld, Robert, of Burton on Trent, Staffs, merchant 1
5101279 2386783 2386783 defendant Whitfeld Robert mercer 590605 590605 Whitfeld, Robert, of Burton on Trent, Staffs, mercer 0
5111953 2389885 2389885 defendant Couper Roger painter 590605 590605 Couper, Roger, of Burton on Trent, Staffs, painter 1
5111961 2389886 2389886 defendant Couper Roger painter 590605 590605 Couper, Roger, of Burton on Trent, Staffs, painter 1
5126643 2394267 2394267 plaintiff Brandum John   590605 590605 Brandum, John, of Burton on Trent, Staffs 0
5132487 2395994 2395994 defendant Swayne William dyer 590605 590605 Swayne, William, of Burton on Trent, Staffs, dyer 0
5132490 2395995 2395995 defendant Swayne William dyer 590605 590605 Swayne, William, of Burton on Trent, Staffs, dyer 0
5147324 2400361 2400361 defendant Lyngge John yeoman 590605 590605 Lyngge, John, of Burton on Trent, Staffs, yeoman 0
5147327 2400362 2400362 defendant Lyngge John yeoman 590605 590605 Lyngge, John, of Burton on Trent, Staffs, yeoman 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);