names

969 rows where place_id = 587172

✎ 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
3590654 1864719 1864719 defendant Thrower William husbandman 587172 587172 Thrower, William, of Est Derham, husbandman 0
3590775 1864753 1864753 defendant Ederyche Robert barker 587172 587172 Ederyche, Robert, of Est Derham, barker 3
3591908 1865082 1865082 defendant Boleyn or Bobeyn Robert husbandman 587172 587172 Boleyn or Bobeyn, Robert, of Est Derham, husbandman 0
3592930 1865408 1865408 defendant Bryghtmer Robert yeoman 587172 587172 Bryghtmer, Robert, of Est Derham, yeoman 0
3598362 1867119 1867119 defendant Sadeler Thomas yeoman 587172 587172 Sadeler, Thomas, of Est Derham, yeoman 1
3602703 1868508 1868508 defendant Rous William husbandman 587172 587172 Rous, William, of Est Derham, husbandman 2
3604163 1868968 1868968 defendant Langtoft Nicholas draper 587172 587172 Langtoft, Nicholas, of Est Derham, draper 1
3616017 1872644 1872644 defendant Pope John, junior husbandman 587172 587172 Pope, John, junior, of Est Derham, husbandman 0
3616018 1872644 1872644 defendant Sonde William husbandman 587172 587172 Sonde, William, of Est Derham, husbandman 1
3616032 1872648 1872648 defendant Ederyche Robert barker 587172 587172 Ederyche, Robert, of Est Derham, barker 3
3616711 1872856 1872856 defendant Deye Richard yeoman 587172 587172 Deye, Richard, of Est Derham, yeoman 1
3619960 1873817 1873817 defendant Dey William, junior yeoman 587172 587172 Dey, William, junior, of Est Derham, yeoman 0
3619961 1873817 1873817 defendant Kyrby Richard draper 587172 587172 Kyrby, Richard, of Est Derham, draper 1
3619965 1873818 1873818 defendant Kyrby Richard draper 587172 587172 Kyrby, Richard, of Est Derham, draper 0
3619967 1873818 1873818 defendant Dey William, junior yeoman 587172 587172 Dey, William, junior, of Est Derham, yeoman 2
3619970 1873819 1873819 defendant Kyrby Richard draper 587172 587172 Kyrby, Richard, of Est Derham, draper 0
3619972 1873819 1873819 defendant Dey William, junior yeoman 587172 587172 Dey, William, junior, of Est Derham, yeoman 2
3626893 1903263 1903263 plaintiff Bawdeswell Richard   587172 587172 Bawdeswell, Richard, of Est Derham, son of Bawdeswell, Geoffrey, of Est Derham 0
3628347 1903729 1903729 defendant Palmer Henry yeoman 587172 587172 Palmer, Henry, of Est Derham, yeoman 0
3628348 1903729 1903729 defendant Montyng Thomas yeoman 587172 587172 Montyng, Thomas, of Est Derham, yeoman 1
3628350 1903730 1903730 defendant Palmer Henry yeoman 587172 587172 Palmer, Henry, of Est Derham, yeoman 0
3628351 1903730 1903730 defendant Montyng William yeoman 587172 587172 Montyng, William, of Est Derham, yeoman 1
3628353 1903731 1903731 defendant Palmer Henry yeoman 587172 587172 Palmer, Henry, of Est Derham, yeoman 0
3628354 1903731 1903731 defendant Montyng William yeoman 587172 587172 Montyng, William, of Est Derham, yeoman 1
3628859 1903901 1903901 plaintiff Coddyng Thomas, junior   587172 587172 Coddyng, Thomas, junior, of Est Derham 0
3631490 1904662 1904662 defendant Mortofte William mercer 587172 587172 Mortofte, William, of Est Derham, mercer 0
3634534 1905604 1905604 defendant Wyllys John, senior weaver 587172 587172 Wyllys, John, senior, of Est Derham, weaver 0
3634536 1905605 1905605 defendant Mowtyng William   587172 587172 Mowtyng, William, of Est Derham, plough wright 0
3634711 1905650 1905650 plaintiff Mortoft William mercer 587172 587172 Mortoft, William, of Est Derham, mercer 0
3635366 1905857 1905857 defendant Peers Richard husbandman 587172 587172 Peers, Richard, of Est Derham, husbandman 0
3638973 1907011 1907011 defendant Tayllour John capper 587172 587172 Tayllour, John, of Est Derham, capper 0
3640450 1907445 1907445 defendant Foster William husbandman 587172 587172 Foster, William, of Est Derham, husbandman 1
3642286 1908036 1908036 defendant Palmer Henry gent 587172 587172 Palmer, Henry, of Est Derham, gent 0
3642287 1908036 1908036 defendant Mowtyng Thomas yeoman 587172 587172 Mowtyng, Thomas, of Est Derham, yeoman 1
3642746 1908178 1908178 defendant Johnson Robert husbandman 587172 587172 Johnson, Robert, of Est Derham, husbandman 2
3648853 1910030 1910030 defendant Browster Robert   587172 587172 Browster, Robert, of Est Derham, mason 0
3650953 1910668 1910668 defendant Large William husbandman 587172 587172 Large, William, of Est Derham, husbandman 0
3650964 1910672 1910672 defendant Athurton Arthur yeoman 587172 587172 Athurton, Arthur, of Est Derham, yeoman 2
3650965 1910672 1910672 defendant Marche Giles yeoman 587172 587172 Marche, Giles, of Est Derham, yeoman 3
3650966 1910672 1910672 defendant Tenaunt John husbandman 587172 587172 Tenaunt, John, of Est Derham, husbandman 4
3650970 1910673 1910673 defendant Athurton Arthur yeoman 587172 587172 Athurton, Arthur, of Est Derham, yeoman 2
3650971 1910673 1910673 defendant Marche Giles yeoman 587172 587172 Marche, Giles, of Est Derham, yeoman 3
3651025 1910686 1910686 defendant Snellyng John butcher 587172 587172 Snellyng, John, of Est Derham, butcher 3
3651501 1910830 1910830 defendant Barton William tanner 587172 587172 Barton, William, of Est Derham, tanner 0
3651502 1910830 1910830 defendant Constable Robert miller 587172 587172 Constable, Robert, of Est Derham, miller 1
3654419 1911643 1911643 defendant Vale Robert   587172 587172 Vale, Robert, of East Derham, tallow chandler 0
3655584 1912009 1912009 defendant Barton Robert yeoman 587172 587172 Barton, Robert, of East Derham, yeoman 0
3656777 1912374 1912374 defendant Wycham Thomas butcher 587172 587172 Wycham, Thomas, of East Derham, butcher 0
3660152 1913435 1913435 defendant Michell Thomas scrivener 587172 587172 Michell, Thomas, of East Derham, scrivener 0
3660955 1913698 1913698 defendant Peers Richard husbandman 587172 587172 Peers, Richard, of Est Derham, husbandman 1
3667681 1915838 1915838 plaintiff Fissher John (legal representative) 587172 587172 Fissher, John, of East Derham, executor of 1
3668891 1916202 1916202 defendant Pynnes Thomas yeoman 587172 587172 Pynnes, Thomas, of Est Derham, yeoman 0
3672363 1917359 1917359 defendant Pakman Thomas yeoman 587172 587172 Pakman, Thomas, of Est Derham, yeoman 0
3673594 1917770 1917770 defendant Vyncent Godfrey plumber 587172 587172 Vyncent, Godfrey, of Est Derham, plumber 2
3676048 1918543 1918543 defendant Perymond alias Pye Geoffrey husbandman 587172 587172 Perymond alias Pye, Geoffrey, of Est Derham, husbandman 2
3676049 1918543 1918543 defendant Large William husbandman 587172 587172 Large, William, of Est Derham, husbandman 3
3678045 1919177 1919177 defendant Snellyng John butcher 587172 587172 Snellyng, John, of Est Derham, butcher 0
3678547 1919348 1919348 defendant Glaven Adam   587172 587172 Glaven, Adam, of Est Derham, worsted weaver 0
3680022 1919815 1919815 defendant Mason Thomas husbandman 587172 587172 Mason, Thomas, of Est Derham, husbandman 0
3684304 1921226 1921226 defendant Pye Geoffrey husbandman 587172 587172 Pye, Geoffrey, of Est Derham, husbandman 0
3684305 1921226 1921226 defendant Bayfeld Richard husbandman 587172 587172 Bayfeld, Richard, of Est Derham, husbandman 1
3684306 1921226 1921226 defendant Wellys Thomas glover 587172 587172 Wellys, Thomas, of Est Derham, glover 2
3685550 1921630 1921630 defendant Crosse Thomas butcher 587172 587172 Crosse, Thomas, of Est Derham, butcher 0
3688746 1922641 1922641 defendant Large William husbandman 587172 587172 Large, William, of Est Derham, husbandman 2
3689564 1922892 1922892 defendant Pakeman Thomas gent 587172 587172 Pakeman, Thomas, of Est Derham, gent 0
3691170 1923401 1923401 defendant Harmer Nicholas   587172 587172 Harmer, Nicholas, of Est Derham, freemason 0
3691171 1923401 1923401 defendant Snellyng John yeoman 587172 587172 Snellyng, John, of Est Derham, yeoman 1
3692019 1923671 1923671 defendant Bafeld Richard husbandman 587172 587172 Bafeld, Richard, of Est Derham, husbandman 0
3692941 1923990 1923990 defendant Fyske Nicholas yeoman 587172 587172 Fyske, Nicholas, of Est Derham, yeoman 0
3692942 1923990 1923990 defendant Perymount alias Pye John husbandman 587172 587172 Perymount alias Pye, John, of Est Derham, husbandman 1
3693660 1924210 1924210 defendant Fyske John chapman 587172 587172 Fyske, John, of Est Derham, chapman 4
3694874 1924605 1924605 defendant Soham John yeoman 587172 587172 Soham, John, of Est Derham, yeoman 1
3695308 1924757 1924757 plaintiff Pope John   587172 587172 Pope, John, of Est Derham 0
3695310 1924757 1924757 defendant Bayfeld Richard husbandman 587172 587172 Bayfeld, Richard, of Est Derham, husbandman 0
3698623 1925782 1925782 defendant Perymone Geoffrey husbandman 587172 587172 Perymone, Geoffrey, of Est Derham, husbandman 0
3698624 1925782 1925782 defendant Perymone John husbandman 587172 587172 Perymone, John, of Est Derham, husbandman 1
3698625 1925782 1925782 defendant Cote Henry husbandman 587172 587172 Cote, Henry, of Est Derham, husbandman 2
3699724 1926141 1926141 defendant Pratt Thomas smith 587172 587172 Pratt, Thomas, of Est Derham, smith 0
3699727 1926142 1926142 defendant Pratt Thomas smith 587172 587172 Pratt, Thomas, of Est Derham, smith 0
3702867 1927170 1927170 defendant Snellyng John butcher 587172 587172 Snellyng, John, of Est Derham, butcher 0
3703542 1927385 1927385 defendant Large William husbandman 587172 587172 Large, William, of Est Derham, husbandman 0
3703543 1927385 1927385 defendant Large Richard husbandman 587172 587172 Large, Richard, of Est Derham, husbandman 1
3703550 1927386 1927386 defendant Perymond alias Pye John husbandman 587172 587172 Perymond alias Pye, John, of Est Derham, husbandman 0
3703553 1927386 1927386 defendant Pynnes Thomas yeoman 587172 587172 Pynnes, Thomas, of Est Derham, yeoman 3
3704466 1927693 1927693 plaintiff Fresar alias Hynde John yeoman 587172 587172 Fresar alias Hynde, John, of Est Derham, yeoman 0
3704587 1927724 1927724 plaintiff Fyske Nicholas raffman 587172 587172 Fyske, Nicholas, of Est Derham, raffman 0
3708672 1929012 1929012 defendant Mason Thomas husbandman 587172 587172 Mason, Thomas, of Est Derham, husbandman 0
3710115 1929475 1929475 defendant Gobyland John husbandman 587172 587172 Gobyland, John, of Est Derham, husbandman 0
3710117 1929476 1929476 defendant Perymont John husbandman 587172 587172 Perymont, John, of Est Derham, husbandman 0
3710810 1929697 1929697 defendant Codlyng Thomas yeoman 587172 587172 Codlyng, Thomas, of Est Derham, yeoman 0
3718596 1932093 1932093 plaintiff Fyske Nicholas   587172 587172 Fyske, Nicholas, of Est Derham 0
3718597 1932093 1932093 defendant Crosse Thomas butcher 587172 587172 Crosse, Thomas, of Est Derham, butcher 0
3718598 1932093 1932093 defendant Perymount Geoffrey husbandman 587172 587172 Perymount, Geoffrey, of Est Derham, husbandman 1
3723742 1933702 1933702 defendant Drake Robert thatcher 587172 587172 Drake, Robert, of Est Derham, thatcher 0
3723743 1933702 1933702 defendant Fayrbank William tailor 587172 587172 Fayrbank, William, of Est Derham, tailor 1
3723744 1933702 1933702 defendant Byrcham Thomas shoemaker 587172 587172 Byrcham, Thomas, of Est Derham, shoemaker 2
3723857 1933741 1933741 defendant Large William husbandman 587172 587172 Large, William, of Est Derham, husbandman 0
3723858 1933741 1933741 defendant Large Richard husbandman 587172 587172 Large, Richard, of Est Derham, husbandman 1
3725129 1934150 1934150 defendant Soham John husbandman 587172 587172 Soham, John, of Est Derham, husbandman 0
3725130 1934150 1934150 defendant Soham Hugh husbandman 587172 587172 Soham, Hugh, of Est Derham, husbandman 1

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);