names

290 rows where place_id = 587913

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592811 1865364 1865364 defendant Fraunceys Thomas yeoman 587913 587913 Fraunceys, Thomas, of Pulham, yeoman 0
3592813 1865365 1865365 defendant Fraunceys Thomas yeoman 587913 587913 Fraunceys, Thomas, of Pulham, yeoman 0
3593505 1865601 1865601 defendant Caryell John husbandman 587913 587913 Caryell, John, of Pulham, husbandman 3
3598423 1867135 1867135 defendant Hanworth John yeoman 587913 587913 Hanworth, John, of Pulham, yeoman 0
3604039 1868930 1868930 defendant Gosse John, senior husbandman 587913 587913 Gosse, John, senior, of Pulham, husbandman 0
3604041 1868931 1868931 defendant Gosse John, senior husbandman 587913 587913 Gosse, John, senior, of Pulham, husbandman 0
3613107 1871753 1871753 plaintiff Asshby Robert   587913 587913 Asshby, Robert, of Pulham 0
3613110 1871754 1871754 plaintiff Asshby Robert   587913 587913 Asshby, Robert, of Pulham 0
3616200 1872707 1872707 plaintiff Davy William   587913 587913 Davy, William, of Pulham 0
3617776 1873183 1873183 defendant Dix Robert husbandman 587913 587913 Dix, Robert, of Pulham, husbandman 3
3622786 1874657 1874657 plaintiff Reynbald John   587913 587913 Reynbald, John, of Pulham 0
3628742 1903868 1903868 defendant Wolnawe Robert yeoman 587913 587913 Wolnawe, Robert, of Pulham, yeoman 0
3630136 1904273 1904273 defendant Aslak Richard yeoman 587913 587913 Aslak, Richard, of Pulham, yeoman 2
3635494 1905898 1905898 defendant Revet William husbandman 587913 587913 Revet, William, of Pulham, husbandman 1
3642769 1908188 1908188 defendant Neve John, senior smith 587913 587913 Neve, John, senior, of Pulham, smith 0
3647389 1909571 1909571 defendant Wylkynson John butcher 587913 587913 Wylkynson, John, of Pulham, butcher 2
3649825 1910309 1910309 defendant Bruen Richard smith 587913 587913 Bruen, Richard, of Pulham, smith 0
3649827 1910309 1910309 defendant Revet John husbandman 587913 587913 Revet, John, of Pulham, husbandman 2
3649829 1910310 1910310 defendant Neve John smith 587913 587913 Neve, John, of Pulham, smith 0
3659475 1913221 1913221 defendant Revet John, senior yeoman 587913 587913 Revet, John, senior, of Pulham, yeoman 1
3664106 1914725 1914725 defendant Revet John husbandman 587913 587913 Revet, John, of Pulham, husbandman 2
3674647 1918121 1918121 defendant Sancroft Edward yeoman 587913 587913 Sancroft, Edward, of Pulham, yeoman 0
3674650 1918122 1918122 defendant Sancrofte Edward yeoman 587913 587913 Sancrofte, Edward, of Pulham, yeoman 0
3685617 1921655 1921655 defendant Ryche John husbandman 587913 587913 Ryche, John, of Pulham, husbandman 0
3685618 1921655 1921655 defendant Ryvet William husbandman 587913 587913 Ryvet, William, of Pulham, husbandman 1
3690201 1923093 1923093 defendant Wylkynson John butcher 587913 587913 Wylkynson, John, of Pulham, butcher 1
3698325 1925695 1925695 defendant Feld Thomas husbandman 587913 587913 Feld, Thomas, of Pulham, husbandman 2
3704161 1927599 1927599 defendant Howard Thomas husbandman 587913 587913 Howard, Thomas, of Pulham, husbandman 0
3704445 1927685 1927685 defendant Everard Robert husbandman 587913 587913 Everard, Robert, of Pulham, husbandman 0
3704638 1927736 1927736 defendant Wilkynson John butcher 587913 587913 Wilkynson, John, of Pulham, butcher 1
3708908 1929077 1929077 defendant Feld Thomas husbandman 587913 587913 Feld, Thomas, of Pulham, husbandman 2
3710170 1929495 1929495 defendant Howard Thomas husbandman 587913 587913 Howard, Thomas, of Pulham, husbandman 0
3711971 1930061 1930061 defendant Feld Thomas husbandman 587913 587913 Feld, Thomas, of Pulham, husbandman 0
3714342 1930784 1930784 defendant Grene John husbandman 587913 587913 Grene, John, of Pulham, husbandman 0
3714661 1930882 1930882 defendant Revett John husbandman 587913 587913 Revett, John, of Pulham, husbandman 0
3714745 1930913 1930913 defendant Hake alias Robertys William husbandman 587913 587913 Hake alias Robertys, William, of Pulham, husbandman 0
3715771 1931221 1931221 defendant Hynton alias Phylyppys Richard husbandman 587913 587913 Hynton alias Phylyppys, Richard, of Pulham, husbandman 0
3732374 1936362 1936362 defendant Ruddyng John   587913 587913 Ruddyng, John, of Pulham, wheelwright 3
3736802 1937761 1937761 plaintiff Kersey John   587913 587913 Kersey, John, of Pulham 0
3748571 1941484 1941484 defendant Aleyn William yeoman 587913 587913 Aleyn, William, of Pulham, yeoman 1
3771606 1948819 1948819 defendant Ryche John husbandman 587913 587913 Ryche, John, of Pulham, husbandman 1
3780781 1951724 1951724 defendant Priour Robert carpenter 587913 587913 Priour, Robert, of Pulham, carpenter 2
3783299 1952527 1952527 defendant Everard Robert butcher 587913 587913 Everard, Robert, of Pulham, butcher 4
3790097 1954720 1954720 defendant Feld Thomas husbandman 587913 587913 Feld, Thomas, of Pulham, husbandman 1
3797569 1957135 1957135 defendant Priour Robert carpenter 587913 587913 Priour, Robert, of Pulham, carpenter 1
3806346 1959899 1959899 defendant Wulnalle William yeoman 587913 587913 Wulnalle, William, of Pulham, yeoman 3
3825045 1965707 1965707 defendant Cobbe Robert husbandman 587913 587913 Cobbe, Robert, of Pulham, husbandman 1
3839552 1970294 1970294 defendant Chamond John husbandman 587913 587913 Chamond, John, of Pulham, husbandman 0
3842455 1971178 1971178 plaintiff Brown John   587913 587913 Brown, John, of Pulham 0
3854323 1974991 1974991 defendant Cobbe John husbandman 587913 587913 Cobbe, John, of Pulham, husbandman 1
3864881 1978455 1978455 defendant Ryche John husbandman 587913 587913 Ryche, John, of Pulham, husbandman 0
3877403 1982688 1982688 plaintiff Hoper Lawrence grasier 587913 587913 Hoper, Lawrence, of Pulham, grasier 0
3891463 1987413 1987413 plaintiff Lawter Godfrey (legal representative) 587913 587913 Lawter, Godfrey, of Pulham, clerk, executor of 0
3894555 1988390 1988390 defendant Wyett Richard laborer 587913 587913 Wyett, Richard, of Pulham, laborer 0
3898226 1989614 1989614 defendant Hambeleyn William thatcher 587913 587913 Hambeleyn, William, of Pulham, thatcher 2
3923065 1998017 1998017 defendant Egglyn Edmund fishmonger 587913 587913 Egglyn, Edmund, of Pulham, fishmonger 1
3923144 1998047 1998047 defendant Sherman Richard husbandman 587913 587913 Sherman, Richard, of Pulham, husbandman 0
3923145 1998048 1998048 plaintiff Sherman Richard   587913 587913 Sherman, Richard, of Pulham, wheel wright 0
3932933 2001304 2001304 defendant Josse John   587913 587913 Josse, John, of Pulham, "sponer" 1
3944859 2005297 2005297 defendant Gobbett Robert yeoman 587913 587913 Gobbett, Robert, of Pulham, yeoman 2
3956804 2009450 2009450 defendant Thurketill Robert yeoman 587913 587913 Thurketill, Robert, of Pulham, yeoman 0
3971680 2014657 2014657 defendant Marlyn Robert husbandman 587913 587913 Marlyn, Robert, of Pulham, husbandman 4
3980492 2017791 2017791 defendant Machett Francis joiner 587913 587913 Machett, Francis, of Pulham, joiner 3
3990957 2021528 2021528 defendant Leman Paul tailor 587913 587913 Leman, Paul, of Pulham, or of Ketheryngham, tailor 0
4024726 2033525 2033525 defendant Leman Paul tailor 587913 587913 Leman, Paul, of Pulham, or of Ketheryngham, tailor 0
4029658 2035245 2035245 defendant Dawes William carpenter 587913 587913 Dawes, William, of Pulham, carpenter 0
4029660 2035246 2035246 defendant Dawes William carpenter 587913 587913 Dawes, William, of Pulham, carpenter 0
4045626 2040888 2040888 plaintiff Sayer Richard   587913 587913 Sayer, Richard, of Pulham 0
4045628 2040889 2040889 plaintiff Sayer Richard   587913 587913 Sayer, Richard, of Pulham 0
4054746 2044085 2044085 defendant Bysshoppe William husbandman 587913 587913 Bysshoppe, William, of Pulham, husbandman 0
4055426 2044335 2044335 defendant Port Nicholas shoemaker 587913 587913 Port, Nicholas, of Pulham, shoemaker 1
4070929 2049901 2049901 plaintiff Michell Richard, junior yeoman 587913 587913 Michell, Richard, junior, of Pulham, yeoman 0
4078904 2052751 2052751 defendant Allen alias Fuller William yeoman 587913 587913 Allen alias Fuller, William, of Pulham, yeoman 3
4082370 2054002 2054002 defendant Gillingham William butcher 587913 587913 Gillingham, William, of Pulham, butcher 0
4098638 2059844 2059844 defendant Gedge Roger tailor 587913 587913 Gedge, Roger, of Pulham, tailor 1
4107696 2063029 2063029 defendant Inglysshe Peter clerk 587913 587913 Inglysshe, Peter, of Pulham, clerk 8
4107705 2063030 2063030 defendant Michell John husbandman 587913 587913 Michell, John, of Pulham, husbandman 2
4126969 2069937 2069937 defendant Mychell Henry yeoman 587913 587913 Mychell, Henry, of Pulham, or of Westhall, yeoman 0
4149438 2077929 2077929 defendant Dasshe Joan widow 587913 587913 Dasshe, Joan, of Pulham, widow 2
4151920 2078782 2078782 defendant Combe Robert yeoman 587913 587913 Combe, Robert, of Pulham, yeoman 0
4156803 2080458 2080458 defendant Camden Richard gent 587913 587913 Camden, Richard, of Pulham, gent 1
4158954 2081197 2081197 defendant Edward Henry yeoman 587913 587913 Edward, Henry, of Pulham, yeoman 2
4194612 2093672 2093672 defendant Hurdinge William yeoman 587913 587913 Hurdinge, William, of Pulham, yeoman 3
4202479 2096408 2096408 defendant Bruett John smith 587913 587913 Bruett, John, of Pulham, smith 0
4209382 2098835 2098835 defendant Godfrey Robert yeoman 587913 587913 Godfrey, Robert, of Pulham, yeoman 0
4212251 2099832 2099832 defendant Keate Henry yeoman 587913 587913 Keate, Henry, of Pulham, yeoman 0
4212519 2099922 2099922 defendant Michell Richard yeoman 587913 587913 Michell, Richard, of Pulham, yeoman 0
4216804 2101374 2101374 defendant Froste William yeoman 587913 587913 Froste, William, of Pulham, yeoman 0
4216805 2101374 2101374 defendant Pottell Felix husbandman 587913 587913 Pottell, Felix, of Pulham, husbandman 1
4216806 2101374 2101374 defendant Gourney Robert husbandman 587913 587913 Gourney, Robert, of Pulham, husbandman 2
4230232 2106061 2106061 defendant Neale Robert yeoman 587913 587913 Neale, Robert, of Pulham, yeoman 0
4246738 2111888 2111888 defendant Barrett Owen yeoman 587913 587913 Barrett, Owen, of Pulham, yeoman 0
4246743 2111889 2111889 defendant Barrett Owen yeoman 587913 587913 Barrett, Owen, of Pulham, yeoman 0
4251687 2113551 2113551 defendant Bysshoppe William husbandman 587913 587913 Bysshoppe, William, of Pulham, husbandman 0
4256470 2115132 2115132 defendant Bright Richard husbandman 587913 587913 Bright, Richard, of Pulham, husbandman 0
4256471 2115132 2115132 defendant Brytinge Richard husbandman 587913 587913 Brytinge, Richard, of Pulham, husbandman 1
4278499 2122415 2122415 defendant Brytiff Richard tailor 587913 587913 Brytiff, Richard, of Pulham, tailor 1
4283776 2124237 2124237 defendant Leman Robert   587913 587913 Leman, Robert, of Pulham, worsted weaver 0
4288180 2125821 2125821 defendant Dyamount or Dyament Walter yeoman 587913 587913 Dyamount or Dyament, Walter, of Pulham, yeoman 1
4289149 2126175 2126175 defendant Bullytoute John carpenter 587913 587913 Bullytoute, John, of Pulham, carpenter 2

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