names

134 rows where place_id = 589531

✎ 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
3597882 1866960 1866960 defendant Cokeman William butcher 589531 589531 Cokeman, William, of Eggefeld, butcher 0
3600375 1867763 1867763 defendant Palmer Thomas husbandman 589531 589531 Palmer, Thomas, of Eggefeld, husbandman 0
3688849 1922673 1922673 defendant Bacon Henry clerk 589531 589531 Bacon, Henry, of Eggefeld, clerk 0
3716166 1931347 1931347 defendant Bakon Henry clerk 589531 589531 Bakon, Henry, of Eggefeld, clerk 0
3748971 1941611 1941611 plaintiff Hartstonge William yeoman 589531 589531 Hartstonge, William, of Eggefeld, yeoman 0
3756725 1944074 1944074 defendant Pykerell Henry laborer 589531 589531 Pykerell, Henry, of Eggefeld, laborer 0
3763519 1946226 1946226 plaintiff Hartstonge William yeoman 589531 589531 Hartstonge, William, of Eggefeld, yeoman 0
3766597 1947217 1947217 defendant Herston Thomas   589531 589531 Herston, Thomas, of Eggefeld, hair weaver 1
3766598 1947217 1947217 defendant Willson Anthony tailor 589531 589531 Willson, Anthony, of Eggefeld, tailor 2
3766599 1947217 1947217 defendant Grene Edmund tanner 589531 589531 Grene, Edmund, of Eggefeld, tanner 3
3766613 1947219 1947219 defendant Grene Edmund tanner 589531 589531 Grene, Edmund, of Eggefeld, tanner 4
3766614 1947219 1947219 defendant Marshall Thomas laborer 589531 589531 Marshall, Thomas, of Eggefeld, laborer 5
3773848 1949532 1949532 defendant Bakon Henry clerk 589531 589531 Bakon, Henry, of Eggefeld, clerk 0
3777311 1950647 1950647 defendant Saunders John husbandman 589531 589531 Saunders, John, of Eggefeld, husbandman 2
3813797 1962228 1962228 defendant Mathewe Peter husbandman 589531 589531 Mathewe, Peter, of Eggefeld, husbandman 0
3815673 1962819 1962819 plaintiff Hartstong William   589531 589531 Hartstong, William, of Eggefeld 0
3815675 1962820 1962820 plaintiff Hartstong William   589531 589531 Hartstong, William, of Eggefeld 0
3815677 1962821 1962821 plaintiff Hartstong William yeoman 589531 589531 Hartstong, William, of Eggefeld, yeoman 0
3815679 1962822 1962822 plaintiff Hartstong William yeoman 589531 589531 Hartstong, William, of Eggefeld, yeoman 0
3815681 1962823 1962823 plaintiff Hartstong William yeoman 589531 589531 Hartstong, William, of Eggefeld, yeoman 0
3815682 1962823 1962823 defendant Mathen or Matheu Peter husbandman 589531 589531 Mathen or Matheu, Peter, of Eggefeld, husbandman 0
3828522 1966795 1966795 defendant Bakon Henry clerk 589531 589531 Bakon, Henry, of Eggefeld, clerk 0
3831859 1967860 1967860 plaintiff Hartstong William (legal representative) 589531 589531 Hartstong, William, of Eggefeld, executors of 0
3831863 1967861 1967861 plaintiff Hartstong William (legal representative) 589531 589531 Hartstong, William, of Eggefeld, executors of 0
3831870 1967862 1967862 defendant Bacon Henry clerk 589531 589531 Bacon, Henry, of Eggefeld, clerk 0
3840924 1970728 1970728 defendant Feke William husbandman 589531 589531 Feke, William, of Eggefeld, husbandman 0
3843778 1971588 1971588 defendant Laws Thomas husbandman 589531 589531 Laws, Thomas, of Eggefeld, husbandman 0
3847321 1972723 1972723 plaintiff Hartisteng William (legal representative) 589531 589531 Hartisteng, William, of Eggefeld, yeoman, executors of 0
3847325 1972724 1972724 plaintiff Hartstong William (legal representative) 589531 589531 Hartstong, William, of Eggefeld, yeoman, executors of 0
3847328 1972724 1972724 defendant Bacon Henry clerk 589531 589531 Bacon, Henry, of Eggefeld, clerk 0
3847329 1972725 1972725 plaintiff Hartstong William (legal representative) 589531 589531 Hartstong, William, of Eggefeld, yeoman, executors of 0
3847603 1972820 1972820 plaintiff Hertystonge Anne widow 589531 589531 Hertystonge, Anne, of Eggefeld, widow 1
3847604 1972820 1972820 defendant Mathewe Peter husbandman 589531 589531 Mathewe, Peter, of Eggefeld, husbandman 0
3847605 1972820 1972820 defendant Mathewe Robert clerk 589531 589531 Mathewe, Robert, of Eggefeld, clerk 1
3847606 1972820 1972820 defendant Wylson Anthony tailor 589531 589531 Wylson, Anthony, of Eggefeld, tailor 2
3847934 1972931 1972931 defendant Feke William husbandman 589531 589531 Feke, William, of Eggefeld, husbandman 0
3847936 1972932 1972932 defendant Hamond William husbandman 589531 589531 Hamond, William, of Eggefeld, husbandman 0
3847938 1972933 1972933 defendant Hartstong William   589531 589531 Hartstong, William, of Eggefeld, yeoman, executors, of 0
3847939 1972933 1972933 defendant Feke William husbandman 589531 589531 (Feke, William, of Eggefeld, husbandman 1
3847940 1972933 1972933 defendant Hamond William husbandman 589531 589531 Hamond, William, of Eggefeld, husbandman 2
3850065 1973611 1973611 defendant Bakon Henry clerk 589531 589531 Bakon, Henry, of Eggefeld, clerk 0
3850930 1973883 1973883 defendant Feke William husbandman 589531 589531 Feke, William, of Eggefeld, husbandman 0
3858034 1976162 1976162 defendant Ryngsted John tanner 589531 589531 Ryngsted, John, of Eggefeld, tanner 1
3859533 1976678 1976678 defendant Mathewe Robert clerk 589531 589531 Mathewe, Robert, of Eggefeld, clerk 1
3862476 1977645 1977645 defendant Ryngsted John tanner 589531 589531 Ryngsted, John, of Eggefeld, tanner 0
3862478 1977646 1977646 defendant Ryngsted John tanner 589531 589531 Ryngsted, John, of Eggefeld, tanner 0
3862640 1977700 1977700 plaintiff Hartstong William (legal representative) 589531 589531 Hartstong, William, of Eggefeld, yeoman, executors of 0
3862643 1977700 1977700 defendant Bacon Henry clerk 589531 589531 Bacon, Henry, of Eggefeld, clerk 0
3862968 1977811 1977811 plaintiff Hartystonge Anne   589531 589531 Hartystonge, Anne, of Eggefeld 1
3864607 1978358 1978358 defendant Bacon Henry clerk 589531 589531 Bacon, Henry, of Eggefeld, clerk 0
3867009 1979204 1979204 defendant Bakon Henry chaplain 589531 589531 Bakon, Henry, of Eggefeld, chaplain 0
3868519 1979712 1979712 defendant Bacon Henry clerk 589531 589531 Bacon, Henry, of Eggefeld, clerk 0
3871302 1980653 1980653 defendant Hoberd Robert thatcher 589531 589531 Hoberd, Robert, of Eggefeld, thatcher 0
3871303 1980653 1980653 defendant Mathewe Peter husbandman 589531 589531 Mathewe, Peter, of Eggefeld, husbandman 1
3871304 1980653 1980653 defendant Mathewe William husbandman 589531 589531 Mathewe, William, of Eggefeld, husbandman 2
3871306 1980654 1980654 defendant Hoberd Robert thatcher 589531 589531 Hoberd, Robert, of Eggefeld, thatcher 0
3872157 1980919 1980919 defendant Ryngsted John tanner 589531 589531 Ryngsted, John, of Eggefeld, tanner 0
3873807 1981460 1981460 defendant Wilson Anthony tailor 589531 589531 Wilson, Anthony, of Eggefeld, tailor 0
3874910 1981833 1981833 defendant Bacon William yeoman 589531 589531 Bacon, William, of Eggefeld, yeoman 1
3878389 1983021 1983021 plaintiff Lawes John   589531 589531 Lawes, John, of Eggefeld 0
3878390 1983021 1983021 defendant Edmondys Simon draper 589531 589531 Edmondys, Simon, of Eggefeld, draper 0
3878391 1983021 1983021 defendant Hartystonge Nicholas husbandman 589531 589531 Hartystonge, Nicholas, of Eggefeld, husbandman 1
3878392 1983021 1983021 defendant Whyght Thomas husbandman 589531 589531 Whyght, Thomas, of Eggefeld, husbandman 2
3883951 1984904 1984904 defendant Edmonde Simon draper 589531 589531 Edmonde, Simon, of Eggefeld, draper 0
3889885 1986855 1986855 defendant Mathewe Peter (legal representative) 589531 589531 Mathewe, Peter, of Eggefeld, husbandman, executor of 0
3889886 1986855 1986855 defendant Feke William husbandman 589531 589531 Feke, William, of Eggefeld, husbandman 1
3889887 1986855 1986855 defendant Mathewe William husbandman 589531 589531 Mathewe, William, of Eggefeld, husbandman 2
3919423 1996827 1996827 defendant Feke William yeoman 589531 589531 Feke, William, of Eggefeld, yeoman 0
3921403 1997500 1997500 defendant Edmondys Simon draper 589531 589531 Edmondys, Simon, of Eggefeld, draper 0
3921916 1997675 1997675 defendant Gylberd James husbandman 589531 589531 Gylberd, James, of Eggefeld, husbandman 3
3945305 2005439 2005439 defendant Edmond Thomas husbandman 589531 589531 Edmond, Thomas, of Eggefeld, husbandman 1
3951997 2007761 2007761 defendant Bolton Richard laborer 589531 589531 Bolton, Richard, of Eggefeld, laborer 1
3951999 2007762 2007762 defendant Bolton Richard laborer 589531 589531 Bolton, Richard, of Eggefeld, laborer 0
4465760 2189961 2189961 defendant Piers John   589531 589531 Piers, John, of Eggefeld 0
4465762 2189962 2189962 defendant Piers John   589531 589531 Piers, John, of Eggefeld 0
4585077 2226754 2226754 defendant Botyld William   589531 589531 Botyld, William, of Eggefeld 1
4585078 2226754 2226754 defendant Dykkys John   589531 589531 Dykkys, John, of Eggefeld 2
4665283 2250630 2250630 defendant Dykk John   589531 589531 Dykk, John, of Eggefeld 1
4665285 2250630 2250630 defendant Sevepens Simpn   589531 589531 Sevepens, Simpn, of Eggefeld 3
4666362 2250954 2250954 defendant Sevenepens Simon butcher 589531 589531 Sevenepens, Simon, of Eggefeld, butcher 0
4690684 2262635 2262635 defendant Lawes John laborer 589531 589531 Lawes, John, of Eggefeld, laborer 0
4690702 2262639 2262639 defendant Lawes John laborer 589531 589531 Lawes, John, of Eggefeld, laborer 0
4881781 2321199 2321199 defendant Curteys Andrew husbandman 589531 589531 Curteys, Andrew, of Eggefeld, husbandman 0
4911194 2330009 2330009 defendant Gauns John smith 589531 589531 (Gauns, John, of Eggefeld, smith 1
4951418 2342405 2342405 defendant Lawes Nicholas yeoman 589531 589531 Lawes, Nicholas, of Eggefeld, yeoman 1
4958532 2344520 2344520 defendant Vaus or Vans Nicholas   589531 589531 Vaus or Vans, Nicholas, of Eggefeld, shepherd 1
4987780 2353309 2353309 defendant Curteys Andrew yeoman 589531 589531 Curteys, Andrew, of Eggefeld, yeoman 0
5043365 2369638 2369638 defendant Sampson Thomas yeoman 589531 589531 Sampson, Thomas, of Eggefeld, yeoman 0
5045672 2370340 2370340 defendant Dalynson Thomas (legal representative) 589531 589531 Dalynson, Thomas, of Eggefeld, executors of 0
5068609 2377104 2377104 defendant Sevynpens Thomas peddler 589531 589531 Sevynpens, Thomas, of Eggefeld, peddler 0
5079410 2380337 2380337 defendant Sevenpens Thomas pedder 589531 589531 Sevenpens, Thomas, of Eggefeld, pedder 4
5080675 2380709 2380709 defendant Sevenpens Thomas husbandman 589531 589531 Sevenpens, Thomas, of Eggefeld, husbandman 0
5095877 2385221 2385221 defendant Sevepens or Sevenpens Thomas pedder 589531 589531 Sevepens or Sevenpens, Thomas, of Eggefeld, pedder 0
5171461 2407376 2407376 defendant Stevens Thomas   589531 589531 Stevens, Thomas, of Eggefeld, pedlar 2
5190365 2412924 2412924 defendant Sepens Thomas   589531 589531 Sepens, Thomas, of Eggefeld, pedlar 2
5218500 2421143 2421143 defendant Mathewe Thomas husbandman 589531 589531 Mathewe, Thomas, of Eggefeld, husbandman 3
5218501 2421143 2421143 defendant Otewey Robert husbandman 589531 589531 Otewey, Robert, of Eggefeld, husbandman 4
5218506 2421144 2421144 defendant Mathewe Thomas husbandman 589531 589531 Mathewe, Thomas, of Eggefeld, husbandman 3
5218507 2421144 2421144 defendant Otewey Robert husbandman 589531 589531 Otewey, Robert, of Eggefeld, husbandman 4
5232341 2425035 2425035 defendant at Okys Giles smith 589531 589531 at Okys, Giles, of Eggefeld, smith 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);