names

522 rows where place_id = 589943

✎ 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
3599323 1867432 1867432 defendant Smedley John yeoman 589943 589943 Smedley, John, of Rochester, yeoman 2
3601917 1868255 1868255 defendant Heufter or Heuster Richard clerk 589943 589943 Heufter or Heuster, Richard, of Rochester, clerk 0
3603224 1868677 1868677 defendant Harle Richard baker 589943 589943 Harle, Richard, of Rochester, baker 0
3603225 1868677 1868677 defendant Gardon John husbandman 589943 589943 Gardon, John, of Rochester, husbandman 1
3605776 1869472 1869472 defendant Shemyng Thomas draper 589943 589943 Shemyng, Thomas, of Rochester, draper 0
3605778 1869473 1869473 defendant Shemyng Thomas draper 589943 589943 Shemyng, Thomas, of Rochester, draper 0
3608423 1870294 1870294 defendant Coke William butcher 589943 589943 Coke, William, of Rochester, butcher 1
3608427 1870295 1870295 defendant Coke William   589943 589943 Coke, William, of Rochester 1
3609087 1870499 1870499 defendant Bruyn William gent 589943 589943 Bruyn, William, of Rochester, gent 0
3614044 1872053 1872053 defendant Gentill Alexander fuller 589943 589943 Gentill, Alexander, of Rochester, fuller 1
3623027 1874729 1874729 defendant Kotyng or Ketyng William   589943 589943 Kotyng or Ketyng, William, of Rochester, tallow chandler 1
3624332 1875144 1875144 defendant Hamys John butcher 589943 589943 Hamys, John, of Rochester, butcher 0
3635087 1905772 1905772 defendant A Dene Thomas   589943 589943 A Dene, Thomas, of Rochester 0
3635088 1905772 1905772 defendant Ryvet John hackneyman 589943 589943 Ryvet, John, of Rochester, hackneyman 1
3638767 1906944 1906944 defendant Ady William yeoman 589943 589943 Ady, William, of Rochester, yeoman 0
3643859 1908509 1908509 defendant Pauston Henry yeoman 589943 589943 Pauston, Henry, of Rochester, yeoman 1
3650869 1910638 1910638 plaintiff Smetheley Robert   589943 589943 Smetheley, Robert, of Rochester 0
3650871 1910639 1910639 plaintiff Smetheley Robert   589943 589943 Smetheley, Robert, of Rochester 0
3656360 1912235 1912235 defendant Warner John yeoman 589943 589943 Warner, John, of Rochester, yeoman 0
3656361 1912235 1912235 defendant May Richard yeoman 589943 589943 May, Richard, of Rochester, yeoman 1
3658912 1913048 1913048 plaintiff (not given) William prior of Fressell 589943 589943 Fressell, William, of Rochester, prior of the monastery of St Andrew the apostle 0
3658914 1913049 1913049 plaintiff (not given) William prior of Fressell 589943 589943 Fressell, William, of Rochester, prior of the monastery of St Andrew the apostle 0
3658917 1913050 1913050 plaintiff (not given) William prior of Fressell 589943 589943 Fressell, William, of Rochester, prior of the monastery of St Andrew the apostle 0
3665986 1915295 1915295 defendant Browne William   589943 589943 Browne, William, of Rochester, wax chandler 0
3671077 1916922 1916922 defendant Warner John yeoman 589943 589943 Warner, John, of Rochester, yeoman 0
3671078 1916922 1916922 defendant May Richard yeoman 589943 589943 May, Richard, of Rochester, yeoman 1
3671154 1916947 1916947 defendant Fawkener Christopher clerk 589943 589943 Fawkener, Christopher, of Rochester, clerk 1
3673614 1917778 1917778 defendant Ade William innholder 589943 589943 Ade, William,of Rochester, innholder 0
3673634 1917785 1917785 defendant Cooke John   589943 589943 Cooke, John, of Rochester, hackney man 0
3677240 1918927 1918927 defendant Warener John innholder 589943 589943 Warener, John, of Rochester, innholder 0
3677290 1918948 1918948 defendant Warner John innholder 589943 589943 Warner, John, of Rochester, innholder 0
3679500 1919658 1919658 defendant Ade William yeoman 589943 589943 Ade, William, of Rochester, yeoman 0
3681547 1920318 1920318 defendant Warner John yeoman 589943 589943 Warner, John, of Rochester, yeoman 0
3681548 1920318 1920318 defendant Shemyng Thomas yeoman 589943 589943 Shemyng, Thomas, of Rochester, yeoman 1
3682207 1920539 1920539 defendant Norres Henry weaver 589943 589943 Norres, Henry, of Rochester, weaver 1
3685145 1921503 1921503 defendant Sporyer Edward beer brewer 589943 589943 Sporyer, Edward, of Rochester, beer brewer 0
3688984 1922713 1922713 defendant Holt Thomas shoemaker 589943 589943 Holt, Thomas, of Rochester, shoemaker 4
3689431 1922853 1922853 plaintiff Mepeham Bartholomew   589943 589943 Mepeham, Bartholomew, of Rochester 3
3689436 1922854 1922854 plaintiff Mepeham Bartholomew   589943 589943 Mepeham, Bartholomew, of Rochester 3
3693677 1924215 1924215 defendant Smyth Lawrence yeoman 589943 589943 Smyth, Lawrence, of Rochester, yeoman 1
3699463 1926060 1926060 defendant Warner John innholder 589943 589943 Warner, John, of Rochester, innholder 0
3708236 1928871 1928871 plaintiff Myll William saddler 589943 589943 Myll, William, of Rochester, saddler 0
3715981 1931285 1931285 defendant Crosseby Thomas smith 589943 589943 Crosseby, Thomas, of Rochester, smith 3
3715982 1931285 1931285 defendant Crosseby John smith 589943 589943 Crosseby, John, of Rochester, smith 4
3716793 1931542 1931542 defendant White Edward gent 589943 589943 White, Edward, of Rochester, gent 0
3716795 1931543 1931543 defendant Whyte Edward gent 589943 589943 Whyte, Edward, of Rochester, gent 0
3719337 1932336 1932336 defendant Curle John chapman 589943 589943 Curle, John, of Rochester, chapman 0
3722541 1933310 1933310 plaintiff Miller John   589943 589943 Miller, John, of Rochester 0
3722675 1933356 1933356 defendant Maye Richard   589943 589943 Maye, Richard, of Rochester, tallow chandler 0
3723698 1933688 1933688 defendant Adam Thomas yeoman 589943 589943 Adam, Thomas, of Rochester, yeoman 0
3723702 1933688 1933688 defendant Coke John hakneyman 589943 589943 Coke, John, of Rochester, hakneyman 4
3723810 1933724 1933724 plaintiff Plumsted Richard yeoman 589943 589943 Plumsted, Richard, of Rochester, yeoman 0
3723813 1933724 1933724 defendant Maye James mercer 589943 589943 Maye, James, of Rochester, mercer 2
3733759 1936811 1936811 defendant Warner John yeoman 589943 589943 Warner, John, of Rochester, yeoman 0
3736991 1937815 1937815 defendant Levegrene John shoemaker 589943 589943 Levegrene, John, of Rochester, shoemaker 2
3738266 1938183 1938183 plaintiff Miller John   589943 589943 Miller, John, of Rochester 0
3747605 1941168 1941168 defendant Abraham Thomas shoemaker 589943 589943 Abraham, Thomas, of Rochester, shoemaker 0
3747606 1941168 1941168 defendant Bettis John painter 589943 589943 Bettis, John, of Rochester, painter 1
3749715 1941822 1941822 defendant Vancurle John chapman 589943 589943 Vancurle, John, of Rochester, chapman 0
3755999 1943830 1943830 defendant Atterbury Thomas butcher 589943 589943 Atterbury, Thomas, of Rochester, butcher 2
3761342 1945555 1945555 defendant Anderson William hackneyman 589943 589943 Anderson, William, of Rochester, hackneyman 0
3761542 1945621 1945621 defendant Warner John yeoman 589943 589943 Warner, John, of Rochester, yeoman 0
3762177 1945813 1945813 defendant Mansell Andrew yeoman 589943 589943 Mansell, Andrew, of Rochester, yeoman 0
3764799 1946656 1946656 defendant Vancurle John chapman 589943 589943 Vancurle, John, of Rochester, chapman 0
3768729 1947866 1947866 defendant Curle John chapman 589943 589943 Curle, John, of Rochester, chapman 0
3768731 1947867 1947867 defendant Curle John chapman 589943 589943 Curle, John, of Rochester, chapman 0
3779735 1951395 1951395 defendant Warner John yeoman 589943 589943 Warner, John, of Rochester, yeoman 0
3786490 1953566 1953566 plaintiff Plumpsted Richard yeoman 589943 589943 Plumpsted, Richard, of Rochester, yeoman 0
3790384 1954810 1954810 plaintiff Warner John   589943 589943 Warner, John, of Rochester 0
3796674 1956841 1956841 defendant Warner John yeoman 589943 589943 Warner, John, of Rochester, yeoman 0
3799393 1957730 1957730 defendant Vancurle John chapman 589943 589943 Vancurle, John, of Rochester, chapman 0
3800036 1957936 1957936 defendant Torner Thomas mercer 589943 589943 Torner, Thomas, of Rochester, mercer 2
3801675 1958419 1958419 defendant Deye Robert tailor 589943 589943 Deye, Robert, of Rochester, tailor 0
3801676 1958419 1958419 defendant Thorneton John yeoman 589943 589943 Thorneton, John, of Rochester, yeoman 1
3801677 1958419 1958419 defendant Yonge Robert husbandman 589943 589943 Yonge, Robert, of Rochester, husbandman 2
3805304 1959604 1959604 defendant Warener William, senior yeoman 589943 589943 Warener, William, senior, of Rochester, yeoman 0
3805305 1959604 1959604 defendant Warener William, junior yeoman 589943 589943 Warener, William, junior, of Rochester, yeoman 1
3806801 1960031 1960031 plaintiff Wellys Alan (legal representative) 589943 589943 Wellys, Alan, of Rochester, executors of 0
3810044 1961030 1961030 defendant Horney John painter 589943 589943 Horney, John, of Rochester, painter 1
3813844 1962241 1962241 defendant Warnar John yeoman 589943 589943 Warnar, John, of Rochester, yeoman 0
3818741 1963765 1963765 plaintiff Miller John (legal representative) 589943 589943 Miller, John, of Rochester, executrix of 0
3826973 1966287 1966287 plaintiff Bere John   589943 589943 Bere, John, of Rochester, notary, rectory of Denton 0
3834175 1968630 1968630 defendant Lee John chapman 589943 589943 Lee, John, of Rochester, chapman 2
3839955 1970427 1970427 defendant Warner John merchant 589943 589943 Warner, John, of Rochester, merchant 0
3839958 1970427 1970427 defendant Hopper John laborer 589943 589943 Hopper, John, of Rochester, laborer 3
3839959 1970427 1970427 defendant Hopper Thomas laborer 589943 589943 Hopper, Thomas, of Rochester, laborer 4
3839960 1970427 1970427 defendant Lockyngton John laborer 589943 589943 Lockyngton, John, of Rochester, laborer 5
3839961 1970427 1970427 defendant Thorpe William laborer 589943 589943 Thorpe, William, of Rochester, laborer 6
3856747 1975736 1975736 defendant Warner John merchant 589943 589943 Warner, John, of Rochester, merchant 0
3856750 1975736 1975736 defendant Hopper John laborer 589943 589943 Hopper, John, of Rochester, laborer 3
3856751 1975736 1975736 defendant Hopper Thomas laborer 589943 589943 Hopper, Thomas, of Rochester, laborer 4
3856752 1975736 1975736 defendant Lokyngton John laborer 589943 589943 Lokyngton, John, of Rochester, laborer 5
3856753 1975736 1975736 defendant Thorp William laborer 589943 589943 Thorp, William, of Rochester, laborer 6
3860600 1977038 1977038 plaintiff Dene Thomas   589943 589943 Dene, Thomas, of Rochester 0
3874860 1981812 1981812 plaintiff Dene Thomas innholder 589943 589943 Dene, Thomas, of Rochester, innholder 0
3883035 1984592 1984592 defendant Watson Robert innholder 589943 589943 Watson, Robert, of Rochester, innholder 0
3896116 1988905 1988905 defendant Deye Robert husbandman 589943 589943 Deye, Robert, of Rochester, husbandman 0
3897029 1989224 1989224 defendant Watson Robert innholder 589943 589943 Watson, Robert, of Rochester, innholder 1
3905527 1992116 1992116 defendant Gebon Thomas yeoman 589943 589943 (Gebon, Thomas, of Rochester, yeoman 3
3917774 1996303 1996303 defendant Dover Mathew joiner 589943 589943 Dover, Mathew, of Rochester, joiner 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);