names

146 rows where place_id = 586162

✎ 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
3588060 1863916 1863916 defendant Taillour Henry chapman 586162 586162 Taillour, Henry, of Evesham, Worcs, chapman 1
3595276 1866156 1866156 defendant Rooke Thomas stainer 586162 586162 Rooke, Thomas, of Evesham, Worcs, stainer 2
3601524 1868134 1868134 defendant Darston Thomas chapman 586162 586162 Darston, Thomas, of Evesham, Worcs, chapman 1
3601529 1868135 1868135 defendant Darston Thomas chapman 586162 586162 Darston, Thomas, of Evesham, Worcs, chapman 1
3636327 1906153 1906153 defendant Waren Nicholas chapman 586162 586162 Waren, Nicholas, of Evesham, Worcs, chapman 1
3655812 1912075 1912075 defendant Browne John merchant 586162 586162 Browne, John, of Evesham, Worcs, merchant 1
3668480 1916095 1916095 plaintiff Aunton Richard yeoman 586162 586162 Aunton, Richard, of Evesham, Worcs, yeoman 0
3804728 1959425 1959425 defendant Daly William mercer 586162 586162 Daly, William, of Evesham, Worcs, mercer 0
3809133 1960740 1960740 defendant Awoode Thomas capper 586162 586162 Awoode, Thomas, of Evesham, Worcs, capper 2
3829309 1967050 1967050 defendant Clerke William chapman 586162 586162 Clerke, William, of Evesham, Worcs, chapman 1
3849415 1973415 1973415 defendant Clerke William chapman 586162 586162 Clerke, William, of Evesham, Worcs, chapman 0
3849883 1973549 1973549 defendant Bove or Bowes Robert yeoman 586162 586162 Bove or Bowes, Robert, of Evesham, Worcs, yeoman 2
3849887 1973550 1973550 defendant Bove or Bowes Robert yeoman 586162 586162 Bove or Bowes, Robert, of Evesham, Worcs, yeoman 2
3849890 1973551 1973551 defendant Clerke William mercer 586162 586162 Clerke, William, of Evesham, Worcs, mercer 1
3860271 1976933 1976933 defendant Clarke William chapman 586162 586162 Clarke, William, of Evesham, Worcs, chapman 0
3864674 1978383 1978383 plaintiff Love Thomas merchant of the staple 586162 586162 Love, Thomas, of Evesham, Worcs, merchant of the staple 0
3864677 1978384 1978384 plaintiff Love Thomas merchant of the staple 586162 586162 Love, Thomas, of Evesham, Worcs, merchant of the staple 0
3864681 1978385 1978385 plaintiff Love Thomas merchant of the staple 586162 586162 Love, Thomas, of Evesham, Worcs, merchant of the staple 0
3864835 1978437 1978437 defendant Bove Robert yeoman 586162 586162 Bove, Robert, of Evesham, Worcs, yeoman 0
3864837 1978438 1978438 defendant Bove Tobert yeoman 586162 586162 Bove, Tobert, of Evesham, Worcs, yeoman 0
3864839 1978439 1978439 defendant Dove Robert yeoman 586162 586162 Dove, Robert, of Evesham, Worcs, yeoman 0
3864841 1978440 1978440 defendant Dove Robert yeoman 586162 586162 Dove, Robert, of Evesham, Worcs, yeoman 0
3927107 1999403 1999403 defendant Elyott John mercer 586162 586162 Elyott, John, of Evesham, Worcs, mercer 1
3928524 1999879 1999879 defendant Elyottes John mercer 586162 586162 Elyottes, John, of Evesham, Worcs, mercer 0
3930045 2000393 2000393 defendant Williams Robert   586162 586162 Williams, Robert, of Evesham, Worcs, inn holder 5
3931968 2000992 2000992 defendant Clerke William mercer 586162 586162 Clerke, William, of Evesham, Worcs, mercer 0
3934413 2001803 2001803 defendant Assheton Robert gent 586162 586162 Assheton, Robert, of Evesham, Worcs, gent 0
3935495 2002180 2002180 defendant Clerke William chapman 586162 586162 Clerke, William, of Evesham, Worcs, chapman 1
3938339 2003159 2003159 defendant Mun Richard tanner 586162 586162 Mun, Richard, of Evesham, Worcs, tanner 1
3943380 2004800 2004800 defendant Wheler John chapman 586162 586162 Wheler, John, of Evesham, Worcs, chapman 2
3953010 2008121 2008121 defendant Toolye William chapman 586162 586162 Toolye, William, of Evesham, Worcs, chapman 0
3978365 2017018 2017018 plaintiff Meadwell Richard yeoman 586162 586162 Meadwell, Richard, of Evesham, Worcs, yeoman 0
4001954 2025477 2025477 defendant Mound Edward tanner 586162 586162 Mound, Edward, of Evesham, Worcs, tanner 0
4002808 2025772 2025772 plaintiff Hobby Richard gent 586162 586162 Hobby, Richard, of Evesham, Worcs, gent 0
4002813 2025773 2025773 defendant Tolley Philip (legal representative) 586162 586162 Tolley, Philip, of Evesham, Worcs, yeoman, executors of 0
4010574 2028558 2028558 defendant Harryngton Richard yeoman 586162 586162 Harryngton, Richard, of Evesham, Worcs, yeoman 0
4015947 2030392 2030392 defendant Bradshoe Alice daughter of Richard Savage, yeoman 586162 586162 Alice his wife, daughter of Richard Savage, of Evesham, Worcs, yeoman 1
4015951 2030393 2030393 defendant Savage Richard (legal representative) 586162 586162 Savage, Richard, of Evesham, Worcs, yeoman, executors of 0
4017716 2031043 2031043 plaintiff Tollye Philip (legal representative) 586162 586162 Tollye, Philip, of Evesham, Worcs, gent, executors of 0
4039769 2038837 2038837 defendant Hunt Edward yeoman 586162 586162 Hunt, Edward, of Evesham, Worcs, yeoman 0
4039772 2038838 2038838 defendant Hunt Edward yeoman 586162 586162 Hunt, Edward, of Evesham, Worcs, yeoman 0
4039787 2038845 2038845 defendant Hunte Edward yeoman 586162 586162 Hunte, Edward, of Evesham, Worcs, yeoman 0
4060934 2046319 2046319 defendant Phillippe William chapman 586162 586162 Phillippe, William, of Evesham, Worcs, chapman 0
4084642 2054781 2054781 defendant Haye Philip chapman 586162 586162 Haye, Philip, of Evesham, Worcs, chapman 0
4086167 2055325 2055325 defendant Dutton Humphrey chapman 586162 586162 Dutton, Humphrey, of Evesham, Worcs, chapman 1
4105999 2062436 2062436 defendant Byddell William clothier 586162 586162 Byddell, William, of Evesham, Worcs, clothier 0
4135554 2073039 2073039 defendant Tickeridge Thomas yeoman 586162 586162 Tickeridge, Thomas, of Evesham, Worcs, yeoman 0
4143539 2075898 2075898 defendant Mathewe William chapman 586162 586162 Mathewe, William, of Evesham, Worcs, chapman 0
4168404 2084435 2084435 defendant Mathewes William yeoman 586162 586162 Mathewes, William, of Evesham, Worcs, yeoman 0
4170033 2085012 2085012 defendant Haddocke William draper 586162 586162 Haddocke, William, of Evesham, Worcs, draper 0
4179912 2088452 2088452 defendant Payne Baldwin mercer 586162 586162 Payne, Baldwin, of Evesham, Worcs, mercer 1
4199517 2095382 2095382 defendant Heynes Robert glover 586162 586162 Heynes, Robert, of Evesham, Worcs, glover 0
4223646 2103758 2103758 defendant Tolley William chapman 586162 586162 Tolley, William, of Evesham, Worcs, chapman 0
4256891 2115276 2115276 defendant Tolley William chapman 586162 586162 Tolley, William, of Evesham, Worcs, chapman 0
4261716 2116873 2116873 defendant Harewell Giles innholder 586162 586162 Harewell, Giles, of Evesham, Worcs, innholder 0
4263574 2117482 2117482 defendant Tolley William chapman 586162 586162 Tolley, William, of Evesham, Worcs, chapman 0
4293152 2127613 2127613 defendant More Philip gent 586162 586162 More, Philip, of Evesham, Worcs, gent 0
4324340 2138538 2138538 defendant Brantley William chapman 586162 586162 Brantley, William, of Evesham, Worcs, chapman 0
4344761 2145447 2145447 defendant Tekeridge Thomas gent 586162 586162 Tekeridge, Thomas, of Evesham, Worcs, gent 0
4383975 2159345 2159345 defendant Taylor John yeoman 586162 586162 Taylor, John, of Evesham, Worcs, yeoman 3
4687549 2261693 2261693 defendant Hayles John chapman 586162 586162 Hayles, John, of Evesham, Worcs, chapman 4
4687571 2261697 2261697 defendant Hayles John chapman 586162 586162 Hayles, John, of Evesham, Worcs, chapman 4
4700525 2265578 2265578 defendant Jamys Robert chapman 586162 586162 Jamys, Robert, of Evesham, Worcs, chapman 0
4700534 2265579 2265579 defendant Jamys Robert chapman 586162 586162 Jamys, Robert, of Evesham, Worcs, chapman 0
4744284 2278851 2278851 defendant Duyr John clerk 586162 586162 Duyr, John, of Evesham, Worcs, clerk 0
4745325 2279143 2279143 defendant Porche Thomas yeoman 586162 586162 Porche, Thomas, of Evesham, Worcs, yeoman 4
4769391 2286400 2286400 defendant Welleford John   586162 586162 Welleford, John, of Evesham, Worcs 0
4792859 2293856 2293856 defendant Seward John   586162 586162 Seward, John, of Evesham, Worcs, mason 2
4809583 2299163 2299163 defendant Welford John chapman 586162 586162 Welford, John, of Evesham, Worcs, chapman 0
4809673 2299189 2299189 defendant Hayll John chapman 586162 586162 Hayll, John, of Evesham, Worcs, chapman 2
4814832 2300750 2300750 defendant Shyn William tailor 586162 586162 Shyn, William, of Evesham, Worcs, tailor 5
4848312 2310942 2310942 defendant Noble William vintner 586162 586162 Noble, William, of Evesham, Worcs, vintner 1
4851576 2311927 2311927 defendant Stanley Richard husbandman 586162 586162 Stanley, Richard, of Evesham, Worcs, husbandman 3
4851582 2311928 2311928 defendant Stanley Richard husbandman 586162 586162 Stanley, Richard, of Evesham, Worcs, husbandman 3
4881255 2321040 2321040 defendant Ingram Thomas chapman 586162 586162 Ingram, Thomas, of Evesham, Worcs, chapman 3
4910279 2329730 2329730 defendant Hayle John spicer 586162 586162 Hayle, John, of Evesham, Worcs, spicer 1
4917812 2332083 2332083 defendant Hertishede John drover 586162 586162 Hertishede, John, of Evesham, Worcs, drover 4
4945553 2340587 2340587 defendant Parker Lewis yeoman 586162 586162 Parker, Lewis, of Evesham, Worcs, yeoman 2
4947529 2341221 2341221 defendant Sklatter John slater 586162 586162 Sklatter, John, of Evesham, Worcs, slater 0
4947532 2341222 2341222 defendant Sklatter John slater 586162 586162 Sklatter, John, of Evesham, Worcs, slater 0
4964709 2346353 2346353 defendant Goldsmyth Thomas goldsmith 586162 586162 Goldsmyth, Thomas, of Evesham, Worcs, goldsmith 0
4989511 2353797 2353797 defendant Ingram Thomas chapman 586162 586162 Ingram, Thomas, of Evesham, Worcs, chapman 1
5001461 2357317 2357317 defendant Ingram Thomas, sen mercer 586162 586162 Ingram, Thomas, sen, of Evesham, Worcs, mercer 0
5005523 2358515 2358515 defendant Wall John weaver 586162 586162 Wall, John, of Evesham, Worcs, weaver 0
5136761 2397271 2397271 defendant Mylner Robert yeoman 586162 586162 Mylner, Robert, of Evesham, Worcs, yeoman 1
5157018 2403194 2403194 defendant Walter John chapman 586162 586162 Walter, John, of Evesham, Worcs, chapman 2
5159423 2403873 2403873 defendant Clement John tailor 586162 586162 Clement, John, of Evesham, Worcs, tailor 4
5173077 2407836 2407836 defendant Walter John chapman 586162 586162 Walter, John, of Evesham, Worcs, chapman 1
5192884 2413642 2413642 defendant Walter John chapman 586162 586162 Walter, John, of Evesham, Worcs, chapman 1
5208055 2418088 2418088 defendant Shayle Thomas   586162 586162 (Shayle, Thomas, of Evesham, Worcs 1
5216114 2420443 2420443 defendant Valens Roger butcher 586162 586162 Valens, Roger, of Evesham, Worcs, butcher 1
5219388 2421396 2421396 defendant Grene Henry barker 586162 586162 Grene, Henry, of Evesham, Worcs, barker 0
5226864 2423521 2423521 defendant Goldsmyth John goldsmith 586162 586162 Goldsmyth, John, of Evesham, Worcs, goldsmith 0
5246347 2429090 2429090 defendant Shayle John yeoman 586162 586162 Shayle, John, of Evesham, Worcs, yeoman 0
5266992 2435433 2435433 defendant Fulford Thomas tanner 586162 586162 Fulford, Thomas, of Evesham, Worcs, tanner 0
5266996 2435434 2435434 defendant Fulford Thomas tanner 586162 586162 together with Fulford, Thomas, of Evesham, Worcs, tanner 1
5268205 2435824 2435824 defendant Pantre Henry clerk 586162 586162 Pantre, Henry, of Evesham, Worcs, clerk 0
5286257 2440990 2440990 defendant Haleyn William chapman 586162 586162 Haleyn, William, of Evesham, Worcs, chapman 4
5286261 2440991 2440991 defendant Haleyn William chapman 586162 586162 Haleyn, William, of Evesham, Worcs, chapman 2
5289783 2442019 2442019 defendant Cornyssh John yeoman 586162 586162 Cornyssh, John, of Evesham, Worcs, 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);