names

974 rows where place_id = 587374

✎ 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
3591237 1864885 1864885 plaintiff Doppe William   587374 587374 Doppe, William, of Lewes 0
3597272 1866766 1866766 defendant Doppe William husbandman 587374 587374 Doppe, William, of Lewes, husbandman 1
3597273 1866766 1866766 defendant Lankton John yeoman 587374 587374 Lankton, John, of Lewes, yeoman 2
3598047 1867014 1867014 plaintiff Sherman Thomas   587374 587374 Sherman, Thomas, of Lewes, senior 0
3600737 1867887 1867887 defendant Broker Henry gent 587374 587374 Broker, Henry, of Lewes, gent 0
3600802 1867912 1867912 defendant Chamber John gent 587374 587374 Chamber, John, of Lewes, gent 0
3600804 1867913 1867913 defendant Chamber John gent 587374 587374 Chamber, John, of Lewes, gent 0
3602686 1868503 1868503 defendant Edward Thomas gent 587374 587374 Edward, Thomas, of Lewes, gent 0
3602687 1868503 1868503 defendant Ovyot Thomas butcher 587374 587374 Ovyot, Thomas, of Lewes, butcher 1
3602688 1868503 1868503 defendant Fuller John butcher 587374 587374 Fuller, John, of Lewes, butcher 2
3604184 1868974 1868974 defendant Arnoldson Falk (legal representative) 587374 587374 Arnoldson, Falk, of Lewes, hardwareman, administrator of Falk, John, of Lewes, hardwareman, executrix of 0
3604647 1869116 1869116 plaintiff Halle John   587374 587374 Halle, John, of Lewes 0
3604649 1869117 1869117 plaintiff Halle John   587374 587374 Halle, John, of Lewes 0
3604651 1869118 1869118 plaintiff Halle John   587374 587374 Halle, John, of Lewes 0
3607226 1869925 1869925 defendant Brette John husbandman 587374 587374 Brette, John, of Lewes, husbandman 1
3607459 1869991 1869991 defendant Edward Thomas yeoman 587374 587374 Edward, Thomas, of Lewes, yeoman 0
3608914 1870446 1870446 defendant Watyr Thomas (legal representative) 587374 587374 Watyr, Thomas, of Lewes, executor of 0
3608915 1870446 1870446 defendant Maynard John carpenter 587374 587374 Maynard, John, of Lewes, carpenter 1
3610462 1870932 1870932 defendant Wynbery Thomas yeoman 587374 587374 Wynbery, Thomas, of Lewes, yeoman 0
3637920 1906676 1906676 defendant Osmond Clement draper 587374 587374 Osmond, Clement, of Lewes, draper 2
3640720 1907541 1907541 defendant Bryan Thomas yeoman 587374 587374 Bryan, Thomas, of Lewes, yeoman 0
3645663 1909045 1909045 plaintiff Halle John   587374 587374 Halle, John, of Lewes 0
3648846 1910027 1910027 defendant Turke Gilbert yeoman 587374 587374 Turke, Gilbert, of Lewes, yeoman 0
3648847 1910027 1910027 defendant Taillour Patrick yeoman 587374 587374 Taillour, Patrick, of Lewes, yeoman 1
3654308 1911608 1911608 plaintiff (not given) John prior of Ashdown 587374 587374 Ashdown, John, of Lewes, prior of the monastery of St Pancras 0
3654310 1911609 1911609 plaintiff (not given) John prior of Ashdown 587374 587374 Ashdown, John, of Lewes, prior of the monastery of St Pancras 0
3654314 1911610 1911610 plaintiff (not given) John prior of Ashdowne or Asthdon 587374 587374 Ashdowne or Asthdon, John, of Lewes, prior of the Monastery of St Pancras 0
3654318 1911610 1911610 defendant Water Gerard beer brewer 587374 587374 Water, Gerard, of Lewes, beer brewer 3
3654320 1911611 1911611 plaintiff (not given) John prior of Ashdowne or Asthdon 587374 587374 Ashdowne or Asthdon, John, of Lewes, prior of the Monastery of St Pancras 0
3654323 1911612 1911612 plaintiff (not given) John prior of Ashdowne or Asthdon 587374 587374 Ashdowne or Asthdon, John, of Lewes, prior of the Monastery of St Pancras 0
3662041 1914063 1914063 plaintiff Marett Daniel mercer 587374 587374 Marett, Daniel, of Lewes, mercer 0
3664556 1914868 1914868 defendant Cabate Charles yeoman 587374 587374 Cabate, Charles, of Lewes, yeoman 0
3667891 1915898 1915898 defendant A Barowe Thomas smith 587374 587374 A Barowe, Thomas, of Lewes, smith 0
3680844 1920090 1920090 defendant Underhill Richard butcher 587374 587374 Underhill, Richard, of Lewes, butcher 0
3680846 1920091 1920091 defendant Underhill Richard butcher 587374 587374 Underhill, Richard, of Lewes, butcher 0
3684588 1921311 1921311 defendant Kayme John yeoman 587374 587374 Kayme, John, of Lewes, yeoman 12
3685060 1921470 1921470 defendant Smyth Humphrey clerk 587374 587374 Smyth, Humphrey, of Lewes, clerk 0
3686355 1921890 1921890 defendant Holestok Henry weaver 587374 587374 Holestok, Henry, of Lewes, weaver 0
3691434 1923479 1923479 defendant Slutter Thomas yeoman 587374 587374 Slutter, Thomas, of Lewes, yeoman 1
3693734 1924235 1924235 defendant Offyngton Thomas   587374 587374 Offyngton, Thomas, of Lewes, "barsyer" 0
3696008 1924991 1924991 defendant Baile William sherman 587374 587374 Baile, William, of Lewes, sherman 0
3698399 1925720 1925720 defendant Serell Robert husbandman 587374 587374 Serell, Robert, of Lewes, husbandman 0
3705766 1928084 1928084 defendant Slutter Thomas yeoman 587374 587374 Slutter, Thomas, of Lewes, yeoman 0
3706031 1928177 1928177 defendant Holstok Henry weaver 587374 587374 Holstok, Henry, of Lewes, weaver 2
3706032 1928177 1928177 defendant Holstok Thomas tailor 587374 587374 Holstok, Thomas, of Lewes, tailor 3
3706602 1928349 1928349 defendant Calot Charles capper 587374 587374 Calot, Charles, of Lewes, capper 3
3709857 1929398 1929398 defendant Brian Thomas yeoman 587374 587374 Brian, Thomas, of Lewes, yeoman 0
3713702 1930582 1930582 defendant Marbyll John clerk 587374 587374 Marbyll, John, of Lewes, clerk 0
3716703 1931518 1931518 defendant Bryan Thomas yeoman 587374 587374 Bryan, Thomas, of Lewes, yeoman 0
3718309 1932011 1932011 defendant May John yeoman 587374 587374 May, John, of Lewes, yeoman 0
3722116 1933180 1933180 defendant Capden John hosier 587374 587374 Capden, John, of Lewes, hosier 0
3722443 1933279 1933279 defendant Welles John fuller 587374 587374 Welles, John, of Lewes, fuller 0
3731559 1936096 1936096 defendant Offyngton Robert brasier 587374 587374 Offyngton, Robert, of Lewes, brasier 0
3733631 1936759 1936759 defendant Taillour William tailor 587374 587374 Taillour, William, of Lewes, tailor 4
3734170 1936928 1936928 defendant Tyseherst John fletcher 587374 587374 Tyseherst, John, of Lewes, fletcher 0
3734171 1936928 1936928 defendant Offyngton Robert pewterer 587374 587374 Offyngton, Robert, of Lewes, pewterer 1
3738610 1938284 1938284 defendant Weston John   587374 587374 Weston, John, of Lewes, tallow chandler 0
3740303 1938832 1938832 defendant Walsted John yeoman 587374 587374 Walsted, John, of Lewes, yeoman 0
3743076 1939686 1939686 plaintiff Wasshere William   587374 587374 Wasshere, William, of Lewes 0
3746358 1940778 1940778 defendant Mason John husbandman 587374 587374 Mason, John, of Lewes, husbandman 0
3761738 1945682 1945682 defendant Braybroke William capper 587374 587374 Braybroke, William, of Lewes, capper 0
3761739 1945682 1945682 defendant Stevyn Roger fuller 587374 587374 Stevyn, Roger, of Lewes, fuller 1
3762055 1945775 1945775 defendant Colden Edward tailor 587374 587374 Colden, Edward, of Lewes, tailor 0
3766419 1947154 1947154 plaintiff Marrett Daniel mercer 587374 587374 Marrett, Daniel, of Lewes, mercer 0
3766560 1947201 1947201 defendant Braybroke William capper 587374 587374 Braybroke, William, of Lewes, capper 0
3773955 1949570 1949570 defendant Hyll Robert pardoner 587374 587374 Hyll, Robert, of Lewes, pardoner 1
3776184 1950296 1950296 defendant Wolkynsted John brewer 587374 587374 Wolkynsted, John, of Lewes, brewer 0
3776185 1950296 1950296 defendant Lucas John yeoman 587374 587374 Lucas, John, of Lewes, yeoman 1
3777487 1950709 1950709 defendant Mason John husbandman 587374 587374 Mason, John, of Lewes, husbandman 0
3778178 1950882 1950882 defendant Mason John turner 587374 587374 Mason, John, of Lewes, turner 0
3780152 1951514 1951514 defendant Lee Robert clerk 587374 587374 Lee, Robert, of Lewes, clerk 0
3789381 1954501 1954501 defendant Capre Florence widow 587374 587374 Capre, Florence, of Lewes, widow 0
3789398 1954508 1954508 defendant Nevyll John yeoman 587374 587374 Nevyll, John, of Lewes, yeoman 0
3789399 1954508 1954508 defendant Atwoode John innholder 587374 587374 Atwoode, John, of Lewes, innholder 1
3792778 1955593 1955593 defendant Mason John husbandman 587374 587374 Mason, John, of Lewes, husbandman 0
3793893 1955959 1955959 defendant Tyseherst John fletcher 587374 587374 Tyseherst, John, of Lewes, fletcher 0
3795332 1956408 1956408 defendant Mason John turner 587374 587374 Mason, John, of Lewes, turner 0
3805522 1959667 1959667 defendant Boycott John carpenter 587374 587374 Boycott, John, of Lewes, carpenter 0
3808057 1960410 1960410 defendant Underdown Thomas draper 587374 587374 Underdown, Thomas, of Lewes, draper 0
3808832 1960642 1960642 defendant Batenore John mercer 587374 587374 Batenore, John, of Lewes, mercer 0
3809428 1960829 1960829 defendant Mason John husbandman 587374 587374 Mason, John, of Lewes, husbandman 0
3810775 1961272 1961272 defendant Slutter Thomas yeoman 587374 587374 Slutter, Thomas, of Lewes, yeoman 0
3810782 1961275 1961275 defendant Barnet John clothmaker 587374 587374 Barnet, John, of Lewes, clothmaker 1
3811972 1961652 1961652 defendant Martyn John butcher 587374 587374 Martyn, John, of Lewes, butcher 0
3814113 1962317 1962317 defendant Speke John innholder 587374 587374 Speke, John, of Lewes, innholder 0
3814210 1962349 1962349 defendant Shosmyth John yeoman 587374 587374 Shosmyth, John, of Lewes, yeoman 0
3816825 1963169 1963169 defendant Speke John yeoman 587374 587374 Speke, John, of Lewes, yeoman 0
3817668 1963428 1963428 defendant Tysurst John yeoman 587374 587374 Tysurst, John, of Lewes, yeoman 2
3818191 1963603 1963603 defendant A Wood Richard smith 587374 587374 A Wood, Richard, of Lewes, smith 0
3818192 1963603 1963603 defendant Scras Thomas yeoman 587374 587374 Scras, Thomas, of Lewes, yeoman 1
3818193 1963603 1963603 defendant Slutter Thomas yeoman 587374 587374 Slutter, Thomas, of Lewes, yeoman 2
3818195 1963604 1963604 defendant Slutter Thomas yeoman 587374 587374 Slutter, Thomas, of Lewes, yeoman 0
3818196 1963604 1963604 defendant Awood Richard smith 587374 587374 Awood, Richard, of Lewes, smith 1
3818197 1963604 1963604 defendant Stras Thomas yeoman 587374 587374 Stras, Thomas, of Lewes, yeoman 2
3818476 1963677 1963677 defendant Spek John innholder 587374 587374 Spek, John, of Lewes, innholder 1
3819186 1963888 1963888 defendant Speke John yeoman 587374 587374 Speke, John, of Lewes, yeoman 1
3820711 1964366 1964366 defendant Awdeley John   587374 587374 Awdeley, John, of Lewes, tallow chandler 2
3823051 1965118 1965118 defendant Capre Florence widow 587374 587374 Capre, Florence, of Lewes, widow 0
3824401 1965502 1965502 defendant Dogget Thomas yeoman 587374 587374 Dogget, Thomas, of Lewes, yeoman 0
3828311 1966731 1966731 plaintiff Cayme John mercer 587374 587374 Cayme, John, of Lewes, mercer 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);