names

122 rows where place_id = 591453

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604467 1869066 1869066 defendant Smyth Thomas raffman 591453 591453 Smyth, Thomas, of North Tuddenham, raffman 1
3605140 1869272 1869272 defendant Farewell William husbandman 591453 591453 Farewell, William, of North Tuddenham, husbandman 0
3605142 1869272 1869272 defendant Smyth Thomas husbandman 591453 591453 Smyth, Thomas, of North Tuddenham, husbandman 2
3605143 1869272 1869272 defendant Smyth alias Newgate Edmund husbandman 591453 591453 Smyth alias Newgate, Edmund, of North Tuddenham, husbandman 3
3688708 1922629 1922629 plaintiff Denys William, senior   591453 591453 Denys, William, senior, of North Tuddenham 0
3811722 1961563 1961563 defendant Elvered John weaver 591453 591453 Elvered, John, of North Tuddenham, weaver 1
3838647 1970012 1970012 defendant Yorke Thomas   591453 591453 Yorke, Thomas, of North Tuddenham, worsted weaver 2
3838651 1970013 1970013 defendant Yorke Thomas   591453 591453 Yorke, Thomas, of North Tuddenham, worsted weaver 2
3844306 1971770 1971770 defendant Bugge alias Yorke Thomas husbandman 591453 591453 Bugge alias Yorke, Thomas, of North Tuddenham, husbandman 0
3844307 1971770 1971770 defendant Shetyll Thomas husbandman 591453 591453 Shetyll, Thomas, of North Tuddenham, husbandman 1
3844781 1971911 1971911 defendant Whyte John yeoman 591453 591453 Whyte, John, of North Tuddenham, yeoman 2
3844786 1971913 1971913 defendant Whyte John yeoman 591453 591453 Whyte, John, of North Tuddenham, yeoman 1
3868508 1979707 1979707 defendant Yorke Thomas yeoman 591453 591453 Yorke, Thomas, of North Tuddenham, yeoman 0
3868509 1979707 1979707 defendant Kent John yeoman 591453 591453 Kent, John, of North Tuddenham, yeoman 1
3872587 1981051 1981051 defendant Yorke Thomas yeoman 591453 591453 Yorke, Thomas, of North Tuddenham, yeoman 2
3874885 1981822 1981822 plaintiff Denys William   591453 591453 Denys, William, of North Tuddenham 0
3882389 1984374 1984374 defendant Yorke Thomas yeoman 591453 591453 Yorke, Thomas, of North Tuddenham, yeoman 0
3888232 1986321 1986321 defendant Coke James husbandman 591453 591453 Coke, James, of North Tuddenham, husbandman 0
3890112 1986926 1986926 defendant Cooke James husbandman 591453 591453 Cooke, James, of North Tuddenham, husbandman 0
3895206 1988604 1988604 defendant Shetyll Thomas husbandman 591453 591453 Shetyll, Thomas, of North Tuddenham, husbandman 0
3895351 1988653 1988653 plaintiff Smyth Thomas husbandman 591453 591453 Smyth, Thomas, of North Tuddenham, husbandman 0
3895352 1988653 1988653 defendant Coke James husbandman 591453 591453 Coke, James, of North Tuddenham, husbandman 0
3903317 1991333 1991333 defendant Cooke James husbandman 591453 591453 Cooke, James, of North Tuddenham, husbandman 1
3923120 1998037 1998037 defendant Yorke Thomas husbandman 591453 591453 Yorke, Thomas, of North Tuddenham, husbandman 0
3935805 2002282 2002282 defendant Bulwer Henry husbandman 591453 591453 Bulwer, Henry, of North Tuddenham, husbandman 2
3965341 2012495 2012495 defendant Wotton Henry gent 591453 591453 Wotton, Henry, of North Tuddenham, gent 1
3984254 2019133 2019133 defendant Hartley Nicholas yeoman 591453 591453 Hartley, Nicholas, of North Tuddenham, yeoman 4
3995035 2022971 2022971 defendant Myddlebroke Richard husbandman 591453 591453 Myddlebroke, Richard, of North Tuddenham, husbandman 1
3997708 2023938 2023938 plaintiff Edwardes William   591453 591453 Edwardes, William, of North Tuddenham 0
3997712 2023939 2023939 plaintiff Edwardes William husbandman 591453 591453 Edwardes, William, of North Tuddenham, husbandman 0
4000397 2024910 2024910 plaintiff Graunge George   591453 591453 Graunge, George, of North Tuddenham 0
4000399 2024911 2024911 plaintiff Graunge George   591453 591453 Graunge, George, of North Tuddenham 0
4005255 2026660 2026660 defendant Hartley John yeoman 591453 591453 Hartley, John, of North Tuddenham, yeoman 0
4005257 2026661 2026661 defendant Myddlebroke Richard husbandman 591453 591453 Myddlebroke, Richard, of North Tuddenham, husbandman 0
4015052 2030076 2030076 defendant Tryndell Richard yeoman 591453 591453 Tryndell, Richard, of North Tuddenham, yeoman 3
4018329 2031282 2031282 defendant Myddlebrooke Richard yeoman 591453 591453 Myddlebrooke, Richard, of North Tuddenham, yeoman 2
4018330 2031282 2031282 defendant Hartley John yeoman 591453 591453 Hartley, John, of North Tuddenham, yeoman 3
4020831 2032178 2032178 defendant Thorrysby Francis esq 591453 591453 Thorrysby, Francis, of North Tuddenham, esq 0
4020833 2032179 2032179 defendant Thorrysby Francis esq 591453 591453 Thorrysby, Francis, of North Tuddenham, esq 0
4028097 2034699 2034699 defendant Myddelbrocke Richard husbandman 591453 591453 Myddelbrocke, Richard, of North Tuddenham, husbandman 1
4028098 2034699 2034699 defendant Longthorne John husbandman 591453 591453 Longthorne, John, of North Tuddenham, husbandman 2
4038084 2038263 2038263 defendant Hartley John yeoman 591453 591453 Hartley, John, of North Tuddenham, yeoman 0
4038085 2038263 2038263 defendant Greynes George yeoman 591453 591453 Greynes, George, of North Tuddenham, yeoman 1
4038086 2038263 2038263 defendant Eyre John   591453 591453 Eyre, John, of North Tuddenham, "beller" 2
4059234 2045699 2045699 defendant Grange George yeoman 591453 591453 Grange, George, of North Tuddenham, yeoman 0
4076646 2051942 2051942 defendant Braunch John husbandman 591453 591453 Braunch, John, of North Tuddenham, husbandman 9
4080490 2053335 2053335 defendant Jernege Robert husbandman 591453 591453 Jernege, Robert, of North Tuddenham, or of Casson, husbandman 1
4084227 2054632 2054632 defendant Haste Alice widow 591453 591453 Alice his wife, alias Alice Cockerell, of North Tuddenham, widow 1
4097505 2059434 2059434 defendant Wynsdom Walter gent 591453 591453 Wynsdom, Walter, of North Tuddenham, gent 0
4108521 2063303 2063303 defendant Waller Robert clerk 591453 591453 Waller, Robert, of North Tuddenham, clerk 1
4123495 2068706 2068706 defendant Walpoole William esq 591453 591453 Walpoole, William, of North Tuddenham, esq 0
4123496 2068706 2068706 defendant Parham Edward yeoman 591453 591453 together with Parham, Edward, of North Tuddenham, yeoman 1
4123650 2068762 2068762 defendant Barbor Richard yeoman 591453 591453 Barbor, Richard, of North Tuddenham, yeoman 0
4127756 2070218 2070218 defendant Walpole William esq 591453 591453 Walpole, William, of North Tuddenham, esq 0
4129228 2070757 2070757 defendant Waller Robert clerk 591453 591453 Waller, Robert, of North Tuddenham, clerk 1
4129927 2071015 2071015 defendant Walpole William esq 591453 591453 Walpole, William, of North Tuddenham, esq 0
4129928 2071015 2071015 defendant Longthorne John yeoman 591453 591453 together with Longthorne, John, of North Tuddenham, yeoman 1
4129929 2071015 2071015 defendant Bett William yeoman 591453 591453 Bett, William, of North Tuddenham, yeoman 2
4129930 2071015 2071015 defendant Parham Edward yeoman 591453 591453 Parham, Edward, of North Tuddenham, yeoman 3
4129932 2071016 2071016 defendant Walpole William esq 591453 591453 Walpole, William, of North Tuddenham, esq 0
4129933 2071016 2071016 defendant Longthorne John yeoman 591453 591453 together with Longthorne, John, of North Tuddenham, yeoman 1
4129934 2071016 2071016 defendant Parham Edward yeoman 591453 591453 Parham, Edward, of North Tuddenham, yeoman 2
4129935 2071016 2071016 defendant Melton Martin yeoman 591453 591453 Melton, Martin, of North Tuddenham, yeoman 3
4138742 2074225 2074225 defendant Entissell Lawrence yeoman 591453 591453 Entissell, Lawrence, of North Tuddenham, yeoman 0
4138743 2074225 2074225 defendant Coquerell Francis yeoman 591453 591453 Coquerell, Francis, of North Tuddenham, yeoman 1
4139869 2074625 2074625 defendant Vyncent Godfrey husbandman 591453 591453 Vyncent, Godfrey, of North Tuddenham, husbandman 0
4144026 2076074 2076074 defendant Vyncent Godfrey husbandman 591453 591453 Vyncent, Godfrey, of North Tuddenham, husbandman 1
4146230 2076832 2076832 defendant Langthorne John husbandman 591453 591453 Langthorne, John, of North Tuddenham, husbandman 0
4146735 2077011 2077011 defendant Parham Edward yeoman 591453 591453 Parham, Edward, of North Tuddenham, yeoman 0
4146736 2077011 2077011 defendant Melton Martin yeoman 591453 591453 Melton, Martin, of North Tuddenham, yeoman 1
4146737 2077011 2077011 defendant Walpole William esq 591453 591453 together with Walpole, William, of North Tuddenham, esq 2
4151158 2078530 2078530 defendant Walpoole William esq 591453 591453 Walpoole, William, of North Tuddenham, esq 0
4153377 2079280 2079280 defendant Longthorne John yeoman 591453 591453 Longthorne, John, of North Tuddenham, yeoman 0
4153378 2079280 2079280 defendant Bett William yeoman 591453 591453 Bett, William, of North Tuddenham, yeoman 1
4153379 2079280 2079280 defendant Parham Edward yeoman 591453 591453 Parham, Edward, of North Tuddenham, yeoman 2
4153380 2079280 2079280 defendant Walpole William esq 591453 591453 together with Walpole, William, of North Tuddenham, esq 3
4153382 2079281 2079281 defendant Walpoole William esq 591453 591453 Walpoole, William, of North Tuddenham, esq 0
4153384 2079282 2079282 defendant Longthorne John yeoman 591453 591453 Longthorne, John, of North Tuddenham, yeoman 0
4153385 2079282 2079282 defendant Parham Edward yeoman 591453 591453 Parham, Edward, of North Tuddenham, yeoman 1
4153386 2079282 2079282 defendant Melton Martin husbandman 591453 591453 Melton, Martin, of North Tuddenham, husbandman 2
4153387 2079282 2079282 defendant Walpole William esq 591453 591453 together with Walpole, William, of North Tuddenham, esq 3
4154660 2079724 2079724 defendant Barbor Richard yeoman 591453 591453 Barbor, Richard, of North Tuddenham, yeoman 0
4154662 2079724 2079724 defendant Waller Robert clerk 591453 591453 Waller, Robert, of North Tuddenham, clerk 2
4154663 2079724 2079724 defendant Cockerell Francis yeoman 591453 591453 Cockerell, Francis, of North Tuddenham, yeoman 3
4154969 2079833 2079833 defendant Walpoole William esq 591453 591453 Walpoole, William, of North Tuddenham, esq 0
4157462 2080683 2080683 defendant Walpoole William esq 591453 591453 Walpoole, William, of North Tuddenham, esq 0
4157500 2080697 2080697 defendant Branche John yeoman 591453 591453 Branche, John, of North Tuddenham, yeoman 1
4162320 2082381 2082381 defendant Waller Robert clerk 591453 591453 Waller, Robert, of North Tuddenham, clerk 0
4162321 2082381 2082381 defendant Vyncent Godfrey yeoman 591453 591453 Vyncent, Godfrey, of North Tuddenham, yeoman 1
4164811 2083206 2083206 defendant Vyncent Godfrey husbandman 591453 591453 Vyncent, Godfrey, of North Tuddenham, husbandman 0
4164812 2083206 2083206 defendant Gose George yeoman 591453 591453 Gose, George, of North Tuddenham, yeoman 1
4168553 2084485 2084485 defendant Waller Robert clerk 591453 591453 Waller, Robert, of North Tuddenham, clerk 1
4190576 2092263 2092263 defendant Peke or Pecke Robert yeoman 591453 591453 Peke or Pecke, Robert, of North Tuddenham, yeoman 0
4190577 2092263 2092263 defendant Nicholson Thomas yeoman 591453 591453 Nicholson, Thomas, of North Tuddenham, yeoman 1
4193620 2093336 2093336 defendant Walker Robert clerk 591453 591453 Walker, Robert, of North Tuddenham, clerk 0
4195455 2093955 2093955 defendant Waller Robert clerk 591453 591453 Waller, Robert, of North Tuddenham, clerk 1
4204500 2097122 2097122 defendant Vincent Godfrey yeoman 591453 591453 Vincent, Godfrey, of North Tuddenham, yeoman 0
4207138 2098040 2098040 defendant Waller Robert clerk 591453 591453 Waller, Robert, of North Tuddenham, clerk 0
4214306 2100520 2100520 defendant Kepas John husbandman 591453 591453 Kepas, John, of North Tuddenham, husbandman 3
4214352 2100527 2100527 defendant Smyth Thomas cordwainer 591453 591453 Smyth, Thomas, of North Tuddenham, cordwainer 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);