names

115 rows where place_id = 600924

✎ 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
3643158 1908299 1908299 defendant Hart John innholder 600924 600924 Hart, John, of Walsyngham Parva, innholder 1
3677879 1919134 1919134 defendant Baker William innholder 600924 600924 Baker, William, of Walsyngham Parva, innholder 2
3695574 1924844 1924844 defendant Harte John innholder 600924 600924 Harte, John, of Walsyngham Parva, innholder 0
3695961 1924976 1924976 defendant Mathew John engraver 600924 600924 Mathew, John, of Walsyngham Parva, engraver 0
3695963 1924977 1924977 defendant Oldman John baker 600924 600924 Oldman, John, of Walsyngham Parva, baker 0
3698419 1925726 1925726 plaintiff Walpole Thomas   600924 600924 Walpole, Thomas, of Walsyngham Parva 0
3701680 1926768 1926768 defendant Harte John innholder 600924 600924 Harte, John, of Walsyngham Parva, innholder 0
3702163 1926934 1926934 defendant Hokar Roger butcher 600924 600924 Hokar, Roger, of Walsyngham Parva, butcher 0
3704132 1927585 1927585 defendant Eldman or Oldman John baker 600924 600924 Eldman or Oldman, John, of Walsyngham Parva, baker 0
3705186 1927908 1927908 plaintiff Gurney Thomas   600924 600924 Gurney, Thomas, of Walsyngham Parva 0
3705188 1927908 1927908 defendant Maltby William draper 600924 600924 Maltby, William, of Walsyngham Parva, draper 1
3706837 1928424 1928424 defendant Shyrwyn Alan   600924 600924 Shyrwyn, Alan, of Walsyngham Parva, minstrel 0
3712130 1930111 1930111 plaintiff Warde Richard clerk 600924 600924 Warde, Richard, of Walsyngham Parva, clerk 0
3722289 1933231 1933231 defendant Lyon John (legal representative) 600924 600924 Lyon, John, of Walsyngham Parva, baker, executor of 0
3724150 1933837 1933837 defendant Samecroft Alan saddler 600924 600924 Samecroft, Alan, of Walsyngham Parva, saddler 1
3727255 1934798 1934798 defendant Seffoule Elizabeth widow 600924 600924 Seffoule, Elizabeth, of Walsyngham Parva, widow 1
3727260 1934800 1934800 defendant Mathewe John graver 600924 600924 Mathewe, John, of Walsyngham Parva, graver 0
3753520 1943038 1943038 defendant Oldman John baker 600924 600924 Oldman, John, of Walsyngham Parva, baker 0
3771455 1948764 1948764 defendant Wroote Thomas innholder 600924 600924 Wroote, Thomas, of Walsyngham Parva, innholder 1
3773283 1949353 1949353 defendant Oldman John baker 600924 600924 Oldman, John, of Walsyngham Parva, baker 0
3774390 1949713 1949713 plaintiff at Howgh Christopher   600924 600924 at Howgh, Christopher, of Walsyngham Parva 0
3774392 1949714 1949714 plaintiff at Howgh Christopher   600924 600924 at Howgh, Christopher, of Walsyngham Parva 0
3779760 1951403 1951403 defendant Hoke Roger butcher 600924 600924 Hoke, Roger, of Walsyngham Parva, butcher 1
3780934 1951770 1951770 defendant Marlowe alias Marler George merchant 600924 600924 Marlowe alias Marler, George, of Walsyngham Parva, merchant 2
3780936 1951771 1951771 defendant Marlowe alias Marler George merchant 600924 600924 Marlowe alias Marler, George, of Walsyngham Parva, merchant 0
3783222 1952505 1952505 plaintiff Keswyk William   600924 600924 Keswyk, William, of Walsyngham Parva 0
3787924 1954015 1954015 defendant Oldeman John baker 600924 600924 Oldeman, John, of Walsyngham Parva, baker 0
3788421 1954178 1954178 defendant Oldman John baker 600924 600924 Oldman, John, of Walsyngham Parva, baker 0
3789139 1954413 1954413 defendant Wrote Thomas innholder 600924 600924 Wrote, Thomas, of Walsyngham Parva, innholder 1
3790260 1954769 1954769 defendant Borell William glover 600924 600924 Borell, William, of Walsyngham Parva, glover 1
3794807 1956249 1956249 plaintiff Clyfton John yeoman 600924 600924 Clyfton, John, of Walsyngham Parva, yeoman 0
3797079 1956967 1956967 plaintiff Froste Giles innholder 600924 600924 Froste, Giles, of Walsyngham Parva, innholder 0
3797670 1957167 1957167 defendant Oldman John baker 600924 600924 Oldman, John, of Walsyngham Parva, baker 0
3797671 1957168 1957168 plaintiff Grene Richard butcher 600924 600924 Grene, Richard, of Walsyngham Parva, butcher 0
3797672 1957168 1957168 defendant Oldman John baker 600924 600924 Oldman, John, of Walsyngham Parva, baker 0
3798885 1957567 1957567 defendant Oldman John baker 600924 600924 Oldman, John, of Walsyngham Parva, baker 0
3802130 1958561 1958561 plaintiff Oldeman John   600924 600924 Oldeman, John, of Walsyngham Parva 0
3802133 1958562 1958562 defendant Grene Richard butcher 600924 600924 Grene, Richard, of Walsyngham Parva, butcher 0
3803249 1958920 1958920 plaintiff Ramage Thomas yeoman 600924 600924 Ramage, Thomas, of Walsyngham Parva, yeoman 0
3803251 1958921 1958921 plaintiff Ramage Thomas yeoman 600924 600924 Ramage, Thomas, of Walsyngham Parva, yeoman 0
3830760 1967504 1967504 plaintiff Fysshe Thomas   600924 600924 Fysshe, Thomas, of Walsyngham Parva 0
3835279 1968974 1968974 defendant Grene Richard butcher 600924 600924 Grene, Richard, of Walsyngham Parva, butcher 0
3843317 1971441 1971441 plaintiff Chapman William   600924 600924 Chapman, William, of Walsyngham Parva 0
3845411 1972127 1972127 defendant Curtels alias Clyston Helen widow 600924 600924 Curtels alias Clyston, Helen, of Walsyngham Parva, widow 0
3846120 1972345 1972345 defendant Walpull John yeoman 600924 600924 Walpull, John, of Walsyngham Parva, yeoman 0
3854816 1975151 1975151 plaintiff Turner Thomas mercer 600924 600924 Turner, Thomas, of Walsyngham Parva, mercer 0
3860077 1976868 1976868 defendant Goore Agnes widow 600924 600924 Goore, Agnes, of Walsyngham Parva, widow 0
3865614 1978717 1978717 defendant Ramage Thomas baker 600924 600924 Ramage, Thomas, of Walsyngham Parva, baker 0
3881549 1984090 1984090 defendant Gore Agnes widow 600924 600924 Gore, Agnes, of Walsyngham Parva, widow 0
3882187 1984300 1984300 defendant Candeler William yeoman 600924 600924 Candeler, William, of Walsyngham Parva, yeoman 0
3883238 1984656 1984656 defendant Walpole John yeoman 600924 600924 Walpole, John, of Walsyngham Parva, yeoman 1
3884808 1985194 1985194 defendant Reynold William tailor 600924 600924 Reynold, William, of Walsyngham Parva, tailor 1
3891136 1987303 1987303 plaintiff Keswyke William   600924 600924 Keswyke, William, of Walsyngham Parva 0
3893747 1988128 1988128 defendant Grene Richard butcher 600924 600924 Grene, Richard, of Walsyngham Parva, butcher 0
3893748 1988128 1988128 defendant Gonner Roger yeoman 600924 600924 Gonner, Roger, of Walsyngham Parva, yeoman 1
3895979 1988859 1988859 defendant Ramage alias Wheteley Thomas baker 600924 600924 Ramage alias Wheteley, Thomas, of Walsyngham Parva, baker 0
3896661 1989093 1989093 defendant Grene Richard butcher 600924 600924 Grene, Richard, of Walsyngham Parva, butcher 0
3896775 1989133 1989133 plaintiff Walpole Edward yeoman 600924 600924 Walpole, Edward, of Walsyngham Parva, yeoman 0
3896778 1989134 1989134 defendant Butterell John pewterer 600924 600924 Butterell, John, of Walsyngham Parva, pewterer 0
3919195 1996747 1996747 plaintiff Keswyk William   600924 600924 Keswyk, William, of Walsyngham Parva, yeoman, administrators of 0
3919198 1996748 1996748 plaintiff Keswyke William   600924 600924 Keswyke, William, of Walsyngham Parva, administrators of 0
3920156 1997077 1997077 defendant Walpole John yeoman 600924 600924 Walpole, John, of Walsyngham Parva, yeoman 0
3922645 1997890 1997890 plaintiff Salman Thomas   600924 600924 Salman, Thomas, of Walsyngham Parva, single man 0
3943364 2004797 2004797 defendant Gresham Paul gent 600924 600924 Gresham, Paul, of Walsyngham Parva, gent 0
3965495 2012543 2012543 defendant Davye Henry mercer 600924 600924 Davye, Henry, of Walsyngham Parva, mercer 0
3976148 2016225 2016225 plaintiff Johnson John (legal representative) 600924 600924 Johnson, John, of Walsyngham Parva, mercer, executors of 0
3977885 2016838 2016838 defendant Marshall Thomas yeoman 600924 600924 Marshall, Thomas, of Walsyngham Parva, yeoman 0
3989013 2020811 2020811 defendant Pope Thomas tailor 600924 600924 Pope, Thomas, of Walsyngham Parva, tailor 0
4002907 2025809 2025809 plaintiff Hodgeson Thomas haberdasher 600924 600924 Hodgeson, Thomas, of Walsyngham Parva, haberdasher 0
4011093 2028740 2028740 defendant Ayde Nicholas draper 600924 600924 Ayde, Nicholas, of Walsyngham Parva, draper 3
4015317 2030173 2030173 plaintiff Smyth John   600924 600924 Smyth, John, of Walsyngham Parva, woollen draper 0
4016904 2030746 2030746 plaintiff Sydney Thomas gent 600924 600924 Sydney, Thomas, of Walsyngham Parva, gent 0
4021367 2032367 2032367 plaintiff Wyllyams Peter   600924 600924 Wyllyams, Peter, of Walsyngham Parva 0
4021508 2032420 2032420 defendant Wylsheir William merchant 600924 600924 Wylsheir, William, of Walsyngham Parva, merchant 0
4025965 2033936 2033936 defendant Daye Robert innholder 600924 600924 Daye, Robert, of Walsyngham Parva, innholder 0
4031378 2035892 2035892 defendant Mynne Nicholas esq 600924 600924 Mynne, Nicholas, of Walsyngham Parva, esq 0
4032760 2036370 2036370 defendant Wall Fulk draper 600924 600924 Wall, Fulk, of Walsyngham Parva, draper 0
4032761 2036370 2036370 defendant Peyrson Richard draper 600924 600924 Peyrson, Richard, of Walsyngham Parva, draper 1
4032764 2036371 2036371 defendant Dey Robert innholder 600924 600924 Dey, Robert, of Walsyngham Parva, innholder 1
4046737 2041287 2041287 plaintiff Smythe John   600924 600924 Smythe, John, of Walsyngham Parva, woollen draper 0
4046739 2041288 2041288 plaintiff Smythe John   600924 600924 Smythe, John, of Walsyngham Parva, woollen draper 0
4046742 2041289 2041289 plaintiff Smythe John   600924 600924 Smythe, John, of Walsyngham Parva, woollen draper 0
4049056 2042107 2042107 defendant Tybbett John yeoman 600924 600924 Tybbett, John, of Walsyngham Parva, yeoman 0
4049058 2042108 2042108 defendant Tyllett John yeoman 600924 600924 Tyllett, John, of Walsyngham Parva, yeoman 0
4051481 2042948 2042948 plaintiff Williams Peter maltster 600924 600924 Williams, Peter, of Walsyngham Parva, maltster 0
4057254 2044981 2044981 defendant Kitteridge William fletcher 600924 600924 Kitteridge, William, of Walsyngham Parva, fletcher 1
4058415 2045395 2045395 defendant Ayde Nicholas yeoman 600924 600924 Ayde, Nicholas, of Walsyngham Parva, yeoman 0
4059689 2045859 2045859 plaintiff Corker Henry yeoman 600924 600924 Corker, Henry, of Walsyngham Parva, yeoman 0
4060855 2046288 2046288 defendant Chapman William grocer 600924 600924 Chapman, William, of Walsyngham Parva, grocer 0
4060877 2046296 2046296 defendant Chapman William grocer 600924 600924 Chapman, William, of Walsyngham Parva, grocer 0
4060879 2046297 2046297 defendant Chapman William grocer 600924 600924 Chapman, William, of Walsyngham Parva, grocer 0
4067511 2048695 2048695 plaintiff Jarey Robert merchant 600924 600924 Jarey, Robert, of Walsyngham Parva, merchant 0
4067513 2048696 2048696 plaintiff Jarey Robert merchant 600924 600924 Jarey, Robert, of Walsyngham Parva, merchant 0
4067515 2048697 2048697 plaintiff Jarey Robert yeoman 600924 600924 Jarey, Robert, of Walsyngham Parva, yeoman 0
4067517 2048698 2048698 plaintiff Jarey Robert yeoman 600924 600924 Jarey, Robert, of Walsyngham Parva, yeoman 0
4068270 2048953 2048953 defendant Suger William husbandman 600924 600924 Suger, William, of Walsyngham Parva, husbandman 0
4075438 2051517 2051517 plaintiff Russell Henry gent 600924 600924 Russell, Henry, of Walsyngham Parva, gent 0
4082401 2054014 2054014 defendant Ayde Nicholas   600924 600924 Ayde, Nicholas, of Walsyngham Parva, Norf yeoman 0
4118307 2066836 2066836 defendant Ayde Nicholas yeoman 600924 600924 Ayde, Nicholas, of Walsyngham Parva, yeoman 1
4118357 2066855 2066855 defendant Ayde Nicholas yeoman 600924 600924 Ayde, Nicholas, of Walsyngham Parva, yeoman 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);