names

238 rows where place_id = 589395

✎ 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
3597490 1866835 1866835 defendant Palmer Thomas husbandman 589395 589395 Palmer, Thomas, of Stortford, husbandman 1
3597987 1866995 1866995 defendant Honte or Houte Thomas husbandman 589395 589395 Honte or Houte, Thomas, of Stortford, husbandman 0
3602290 1868382 1868382 defendant Sybthorp Richard butcher 589395 589395 Sybthorp, Richard, of Stortford, butcher 0
3602291 1868382 1868382 defendant Strode Thomas weaver 589395 589395 Strode, Thomas, of Stortford, weaver 1
3623734 1874957 1874957 defendant Clerke John maltman 589395 589395 Clerke, John, of Stortford, maltman 0
3626809 1903235 1903235 plaintiff Barnes John gent 589395 589395 Barnes, John, of Stortford, gent 0
3627005 1903305 1903305 defendant Langham William gent 589395 589395 Langham, William, of Stortford, gent 2
3639415 1907136 1907136 defendant Thomas Ralph shoemaker 589395 589395 Thomas, Ralph, of Stortford, shoemaker 1
3639416 1907136 1907136 defendant Rutter John butcher 589395 589395 Rutter, John, of Stortford, butcher 2
3643394 1908359 1908359 defendant Jardfeld Richard tanner 589395 589395 Jardfeld, Richard, of Stortford, tanner 0
3650319 1910474 1910474 defendant Bardeney Simon husbandman 589395 589395 Bardeney, Simon, of Stortford, husbandman 0
3650320 1910474 1910474 defendant Bardeney Thomas husbandman 589395 589395 Bardeney, Thomas, of Stortford, husbandman 1
3657816 1912695 1912695 defendant Tusteney William   589395 589395 Tusteney, William, of Stortford, shoe maker 3
3657817 1912695 1912695 defendant Davy Richard   589395 589395 Davy, Richard, of Stortford, shoe maker 4
3659504 1913231 1913231 defendant Davy Richard   589395 589395 Davy, Richard, of Stortford, shoe maker 0
3676462 1918683 1918683 defendant Jardefeld Richard tanner 589395 589395 Jardefeld, Richard, of Stortford, tanner 1
3678381 1919293 1919293 defendant Selle John husbandman 589395 589395 Selle, John, of Stortford, husbandman 4
3691473 1923488 1923488 defendant Colt Thomas husbandman 589395 589395 Colt, Thomas, of Stortford, husbandman 0
3700046 1926247 1926247 defendant Bradeley John courser or maltman 589395 589395 Bradeley, John,of Stortford, courser or maltman 0
3705056 1927871 1927871 defendant Bradley John courser 589395 589395 Bradley, John, of Stortford, courser 0
3716877 1931566 1931566 defendant Smyth Robert carpenter 589395 589395 Smyth, Robert, of Stortford, carpenter 0
3716881 1931567 1931567 defendant Smyth Robert carpenter 589395 589395 Smyth, Robert, of Stortford, carpenter 0
3716885 1931568 1931568 defendant Smyth Robert carpenter 589395 589395 Smyth, Robert, of Stortford, carpenter 0
3719566 1932384 1932384 defendant Water Robert yeoman 589395 589395 (Water, Robert, of Stortford, yeoman 1
3733536 1936734 1936734 defendant Smyth Robert carpenter 589395 589395 Smyth, Robert, of Stortford, carpenter 1
3738828 1938350 1938350 defendant Fytchet John gent 589395 589395 Fytchet, John, of Stortford, gent 0
3738879 1938364 1938364 defendant Thomas Ralph yeoman 589395 589395 Thomas, Ralph, of Stortford, yeoman 0
3738880 1938364 1938364 defendant Tebbolde Richard tailor 589395 589395 Tebbolde, Richard, of Stortford, tailor 1
3739532 1938575 1938575 defendant Kyng Thomas clerk 589395 589395 Kyng, Thomas, of Stortford, clerk 0
3739533 1938575 1938575 defendant Sturdy Margaret widow 589395 589395 Sturdy, Margaret, of Stortford, widow 1
3740610 1938923 1938923 defendant Wodehale John husbandman 589395 589395 Wodehale, John, of Stortford, husbandman 0
3752970 1942861 1942861 defendant Wodale John husbandman 589395 589395 Wodale, John, of Stortford, husbandman 0
3769922 1948251 1948251 plaintiff Sale Robert (legal representative) 589395 589395 Sale, Robert, of Stortford, chaplain, executor of 0
3775952 1950226 1950226 defendant Fletcher Robert fletcher 589395 589395 Fletcher, Robert, of Stortford, fletcher 0
3778237 1950902 1950902 defendant Page John butcher 589395 589395 Page, John, of Stortford, butcher 0
3778238 1950902 1950902 defendant Ford Reginald barber 589395 589395 Ford, Reginald, of Stortford, barber 1
3789939 1954679 1954679 defendant Ford Reginald barber 589395 589395 Ford, Reginald, of Stortford, barber 1
3790994 1955019 1955019 defendant Cosyn John husbandman 589395 589395 Cosyn, John, of Stortford, husbandman 4
3807268 1960170 1960170 defendant Cosyn John husbandman 589395 589395 Cosyn, John, of Stortford, husbandman 4
3817707 1963442 1963442 defendant Neweman John yeoman 589395 589395 Neweman, John, of Stortford, yeoman 0
3820134 1964175 1964175 defendant Sturdy Margaret widow 589395 589395 Sturdy, Margaret, of Stortford, widow 0
3820135 1964175 1964175 defendant Kyng Thomas chaplain 589395 589395 Kyng, Thomas, of Stortford, chaplain 1
3843468 1971494 1971494 defendant Swetyng William butcher 589395 589395 Swetyng, William, of Stortford, butcher 1
3851714 1974125 1974125 defendant Sturdy Margaret widow 589395 589395 Sturdy, Margaret, of Stortford, widow 0
3853370 1974677 1974677 defendant Bedwell Richard husbandman 589395 589395 Bedwell, Richard, of Stortford, husbandman 0
3853371 1974677 1974677 defendant Wylley John grocer 589395 589395 Wylley, John, of Stortford, grocer 1
3853372 1974677 1974677 defendant Chamberleyn Thomas maltman 589395 589395 Chamberleyn, Thomas, of Stortford, maltman 2
3859653 1976725 1976725 defendant Swetyng William butcher 589395 589395 Swetyng, William, of Stortford, butcher 0
3874367 1981652 1981652 plaintiff Crathorne John mercer 589395 589395 Crathorne, John, of Stortford, mercer 0
3874368 1981652 1981652 defendant Smyth John mercer 589395 589395 Smyth, John, of Stortford, mercer 0
3874369 1981652 1981652 defendant Wylson Edmund tailor 589395 589395 Wylson, Edmund, of Stortford, tailor 1
3883736 1984831 1984831 defendant Felsted Thomas husbandman 589395 589395 Felsted, Thomas, of Stortford, husbandman 1
3887191 1985981 1985981 defendant Alberd Thomas yeoman 589395 589395 Alberd, Thomas, of Stortford, yeoman 0
3895573 1988725 1988725 defendant Payne John husbandman 589395 589395 Payne, John, of Stortford, husbandman 0
3900527 1990406 1990406 defendant Coker Edmund currier 589395 589395 Coker, Edmund, of Stortford, currier 0
3900528 1990406 1990406 defendant Hogekyn Richard currier 589395 589395 Hogekyn, Richard, of Stortford, currier 1
3900529 1990406 1990406 defendant Woode Henry shoemaker 589395 589395 Woode, Henry, of Stortford, shoemaker 2
3909761 1993572 1993572 defendant Grene John husbandman 589395 589395 Grene, John, of Stortford, husbandman 0
3910437 1993808 1993808 defendant Dawes Peter carpenter 589395 589395 Dawes, Peter, of Stortford, carpenter 0
3913310 1994785 1994785 plaintiff Bayforde John   589395 589395 Bayforde, John, of Stortford 0
3927073 1999394 1999394 defendant Abbott John   589395 589395 Abbott, John, of Stortford, fish monger 0
3927074 1999394 1999394 defendant Golborne Thomas yeoman 589395 589395 Golborne, Thomas, of Stortford, yeoman 1
3927077 1999394 1999394 defendant Castle Ralph cowper 589395 589395 Castle, Ralph, of Stortford, cowper 4
3933101 2001364 2001364 defendant Hyllys Thomas chapman 589395 589395 Hyllys, Thomas, of Stortford, chapman 0
3937847 2002990 2002990 defendant Abbatt John   589395 589395 Abbatt, John, of Stortford, fish monger 0
3937848 2002990 2002990 defendant Golborn Thomas   589395 589395 Golborn, Thomas, of Stortford 1
3937849 2002990 2002990 defendant Smyth John husbandman 589395 589395 Smyth, John, of Stortford, husbandman 2
3937850 2002990 2002990 defendant Jacobe George   589395 589395 Jacobe, George, of Stortford, linen draper 3
3937851 2002990 2002990 defendant Robtes Richard tailor 589395 589395 Robtes, Richard, of Stortford, tailor 4
3945647 2005552 2005552 defendant Johnson John yeoman 589395 589395 Johnson, John, of Stortford, yeoman 0
4000662 2025010 2025010 defendant Momford Robert yeoman 589395 589395 Momford, Robert, of Stortford, yeoman 0
4026851 2034253 2034253 defendant Pylston William gent 589395 589395 Pylston, William, of Stortford, gent 0
4114333 2065410 2065410 defendant Plomer John glover 589395 589395 Plomer, John, of Stortford, glover 0
4182336 2089298 2089298 plaintiff Parsons Thomas esq 589395 589395 Parsons, Thomas, of Stortford, esq 0
4187821 2091242 2091242 defendant Colte Richard maltster 589395 589395 Colte, Richard, of Stortford, maltster 1
4255451 2114816 2114816 defendant Grave Richard husbandman 589395 589395 Grave, Richard, of Stortford, husbandman 2
4267881 2118892 2118892 defendant Grave Richard husbandman 589395 589395 Grave, Richard, of Stortford, husbandman 2
4277912 2122205 2122205 defendant Grave Richard   589395 589395 Grave, Richard, of Stortford, malt carrier 2
4354762 2148886 2148886 defendant Snowe William chapman 589395 589395 Snowe, William, of Stortford, chapman 1
4354763 2148886 2148886 defendant Eaton Edward chapman 589395 589395 Eaton, Edward ,of Stortford, chapman 2
4362561 2151663 2151663 defendant Barnard Nicholas yeoman 589395 589395 Barnard, Nicholas, of Stortford, yeoman 0
4362562 2151663 2151663 defendant Allin Edward tailor 589395 589395 Allin, Edward, of Stortford, yeoman, tailor 1
4369025 2153985 2153985 defendant Abell Francis yeoman 589395 589395 Abell, Francis, of Stortford, yeoman 1
4372496 2155231 2155231 defendant Santon alias Mathewe Francis bricklayer 589395 589395 Santon alias Mathewe, Francis, of Stortford, bricklayer 1
4379107 2157608 2157608 defendant Skyngle Elizabeth widow 589395 589395 Skyngle, Elizabeth, of Stortford, widow 3
4386022 2160012 2160012 defendant Clarke Thomas butcher 589395 589395 Clarke, Thomas, of Stortford, butcher 0
4386025 2160012 2160012 defendant Skyngle John junior (legal representative) 589395 589395 Skyngle John, junior, of Stortford, husbandman, administratrix of 3
4386026 2160012 2160012 defendant Skyngle Elizabeth widow 589395 589395 Skyngle, Elizabeth, of Stortford, widow 4
4388579 2160821 2160821 defendant Barnard Nicholas yeoman 589395 589395 Barnard, Nicholas, of Stortford, yeoman 0
4388580 2160821 2160821 defendant Allyn Edward tailor 589395 589395 Allyn, Edward, of Stortford, yeoman, tailor 1
4391788 2161874 2161874 defendant Barnard Nicholas yeoman 589395 589395 Barnard, Nicholas, of Stortford, yeoman 0
4591651 2228747 2228747 defendant Rose William   589395 589395 Rose, William, of Stortford 0
4591652 2228747 2228747 defendant Rose Nicholas   589395 589395 Rose, Nicholas, of Stortford, servant of William Rose 1
4591653 2228747 2228747 defendant Page John   589395 589395 Page, John, of Stortford 2
4591658 2228747 2228747 defendant Palmer John   589395 589395 Palmer, John, of Stortford 7
4591659 2228747 2228747 defendant Blethewyne Richard   589395 589395 Blethewyne, Richard, of Stortford 8
4595327 2229790 2229790 defendant Bocher Stephen   589395 589395 Bocher, Stephen, of Stortford 3
4607925 2233599 2233599 defendant Goos John   589395 589395 Goos, John, of Stortford 0
4607928 2233600 2233600 defendant Goos John   589395 589395 Goos, John, of Stortford 0
4613114 2235159 2235159 defendant Dyster Henry   589395 589395 Dyster, Henry, of Stortford 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);