names

388 rows where place_id = 587836

✎ 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
3592562 1865290 1865290 defendant Plombe Thomas (legal representative) 587836 587836 Plombe, Thomas, of Folsham, executrix of 1
3592563 1865290 1865290 defendant Plombe Isabel widow 587836 587836 Plombe, Isabel, of Folsham, widow 2
3592566 1865291 1865291 defendant Plombe Thomas (legal representative) 587836 587836 Plombe, Thomas, of Folsham, executrix of 1
3592567 1865291 1865291 defendant Plombe Isabel widow 587836 587836 Plombe, Isabel, of Folsham, widow 2
3595680 1866276 1866276 defendant Cokald John husbandman 587836 587836 Cokald, John, of Folsham, husbandman 1
3595681 1866276 1866276 defendant Cokald Robert butcher 587836 587836 Cokald, Robert, of Folsham, butcher 2
3596586 1866566 1866566 defendant Bolle William barker 587836 587836 Bolle, William, of Folsham, barker 0
3596587 1866566 1866566 defendant Husbond Edward husbandman 587836 587836 Husbond, Edward, of Folsham, husbandman 1
3596588 1866566 1866566 defendant Bolle Robert baker 587836 587836 Bolle, Robert, of Folsham, baker 2
3597886 1866960 1866960 defendant Chenery or Chevery John husbandman 587836 587836 Chenery or Chevery, John, of Folsham, husbandman 4
3597892 1866961 1866961 defendant Barsham William husbandman 587836 587836 Barsham, William, of Folsham, husbandman 3
3604470 1869066 1869066 defendant Brese Robert yeoman 587836 587836 Brese, Robert, of Folsham, yeoman 4
3607739 1870071 1870071 defendant Barsham William husbandman 587836 587836 Barsham, William, of Folsham, husbandman 3
3616696 1872852 1872852 defendant Brese Robert yeoman 587836 587836 Brese, Robert, of Folsham, yeoman 0
3618211 1873319 1873319 defendant Cley John smith 587836 587836 Cley, John, of Folsham, smith 2
3624365 1875155 1875155 defendant Barsham Thomas, senior (legal representative) 587836 587836 Barsham, Thomas, senior, of Folsham, husbandman, executor of 0
3624366 1875155 1875155 defendant Barsham Thomas, junior husbandman 587836 587836 Barsham, Thomas, junior, of Folsham, husbandman 1
3688535 1922573 1922573 defendant Lylly Robert weaver 587836 587836 Lylly, Robert, of Folsham, weaver 3
3703166 1927262 1927262 defendant Holbek William chaplain 587836 587836 Holbek, William, of Folsham, chaplain 0
3706257 1928244 1928244 defendant Leene Edmund tanner 587836 587836 Leene, Edmund, of Folsham, tanner 1
3711591 1929934 1929934 defendant Clement Edmund (legal representative) 587836 587836 Clement, Edmund, of Folsham, husbandman, executor of 0
3711592 1929934 1929934 defendant Clement Roger husbandman 587836 587836 Clement, Roger, of Folsham, husbandman 1
3737271 1937893 1937893 plaintiff Leene or Leeve Edmund   587836 587836 Leene or Leeve, Edmund, of Folsham 0
3737273 1937894 1937894 plaintiff Leene or Leeve Edmund   587836 587836 Leene or Leeve, Edmund, of Folsham 0
3830119 1967320 1967320 defendant Symondys Thomas husbandman 587836 587836 Symondys, Thomas, of Folsham, husbandman 0
3831447 1967720 1967720 defendant Heward Thomas butcher 587836 587836 Heward, Thomas, of Folsham, butcher 0
3832902 1968216 1968216 plaintiff Kay Richard   587836 587836 Kay, Richard,of Folsham 0
3833421 1968380 1968380 plaintiff Leke Ralph (legal representative) 587836 587836 Leke, Ralph, of Folsham, executors of 0
3833424 1968380 1968380 defendant Grene John tanner 587836 587836 Grene, John, of Folsham, tanner 0
3833425 1968381 1968381 plaintiff Leke Ralph (legal representative) 587836 587836 Leke, Ralph, of Folsham, executors of 0
3833428 1968381 1968381 defendant Framyngham Thomas   587836 587836 Framyngham, Thomas, of Folsham, ploughwright 0
3841154 1970811 1970811 plaintiff Barssham Robert yeoman 587836 587836 Barssham, Robert, of Folsham, yeoman 0
3841156 1970812 1970812 plaintiff Barssham Robert yeoman 587836 587836 Barssham, Robert, of Folsham, yeoman 0
3852623 1974427 1974427 defendant Chapman Robert laborer 587836 587836 Chapman, Robert, of Folsham, laborer 1
3856280 1975583 1975583 defendant Kaye Richard smith 587836 587836 Kaye, Richard, of Folsham, smith 2
3861060 1977181 1977181 defendant Beern Andrew tailor 587836 587836 Beern, Andrew, of Folsham, tailor 4
3861109 1977195 1977195 defendant Symond Thomas husbandman 587836 587836 Symond, Thomas, of Folsham, husbandman 0
3869224 1979951 1979951 defendant Kay Richard smith 587836 587836 Kay, Richard, of Folsham, smith 0
3870186 1980274 1980274 defendant Kay Richard smith 587836 587836 Kay, Richard, of Folsham, smith 3
3885414 1985376 1985376 defendant Grene John (legal representative) 587836 587836 Grene, John, of Folsham, tanner, administrator of 0
3887405 1986051 1986051 defendant Themylthorpe Edward husbandman 587836 587836 Themylthorpe, Edward, of Folsham, husbandman 0
3887406 1986051 1986051 defendant Barsham Robert butcher 587836 587836 Barsham, Robert, of Folsham, butcher 1
3888107 1986279 1986279 defendant Heyward Thomas butcher 587836 587836 Heyward, Thomas, of Folsham, butcher 0
3896511 1989040 1989040 defendant Lynne Edward husbandman 587836 587836 Lynne, Edward, of Folsham, husbandman 1
3899178 1989930 1989930 defendant Grene John (legal representative) 587836 587836 Grene, John, of Folsham, tanner, administrator of 0
3907976 1992958 1992958 defendant Symondys Thomas husbandman 587836 587836 Symondys, Thomas, of Folsham, husbandman 2
3913613 1994891 1994891 defendant Chapman Simon husbandman 587836 587836 Chapman, Simon, of Folsham, husbandman 1
3918623 1996555 1996555 defendant Broun Bartholomew butcher 587836 587836 Broun, Bartholomew, of Folsham, butcher 0
3918624 1996555 1996555 defendant Lussher William tanner 587836 587836 Lussher, William, of Folsham, tanner 1
3918625 1996555 1996555 defendant Wylde Edmund yeoman 587836 587836 Wylde, Edmund, of Folsham, yeoman 2
3918631 1996556 1996556 defendant Holley Andrew yeoman 587836 587836 Holley, Andrew, of Folsham, yeoman 0
3952451 2007926 2007926 defendant Nycholas Thomas yeoman 587836 587836 Nycholas, Thomas, of Folsham, yeoman 1
3960077 2010623 2010623 defendant Gunner Roger gent 587836 587836 Gunner, Roger, of Folsham, gent 0
3960079 2010624 2010624 defendant Hopkyn Edmund mercer 587836 587836 Hopkyn, Edmund, of Folsham, mercer 0
3964560 2012207 2012207 defendant Nycholas Thomas yeoman 587836 587836 Nycholas, Thomas, of Folsham, yeoman 0
3979596 2017462 2017462 defendant Spratte Robert husbandman 587836 587836 Spratte, Robert, of Folsham, husbandman 0
3980438 2017772 2017772 defendant Hayward William butcher 587836 587836 Hayward, William, of Folsham, butcher 0
4002548 2025679 2025679 defendant Johnson George gent 587836 587836 Johnson, George, of Folsham, gent 0
4002647 2025717 2025717 defendant Wakefeld Thomas yeoman 587836 587836 Wakefeld, Thomas, of Folsham, yeoman 1
4010088 2028374 2028374 defendant Payne John laborer 587836 587836 Payne, John, of Folsham, laborer 0
4010089 2028374 2028374 defendant Harryson Richard husbandman 587836 587836 Harryson, Richard, of Folsham, husbandman 1
4015444 2030220 2030220 defendant Wylde Thomas gent 587836 587836 Wylde, Thomas, of Folsham, gent 0
4022834 2032889 2032889 defendant Themylthorpe George gent 587836 587836 Themylthorpe, George, of Folsham, gent 0
4022836 2032890 2032890 defendant Wakfyld Thomas yeoman 587836 587836 Wakfyld, Thomas, of Folsham, yeoman 0
4023440 2033091 2033091 plaintiff Barsham John   587836 587836 Barsham, John, of Folsham 0
4023441 2033091 2033091 defendant Themylthorp George gent 587836 587836 Themylthorp, George, of Folsham, gent 0
4027207 2034378 2034378 defendant Hayward Robert butcher 587836 587836 Hayward, Robert, of Folsham, butcher 0
4035725 2037452 2037452 defendant Olyver William husbandman 587836 587836 Olyver, William, of Folsham, husbandman 2
4039208 2038649 2038649 defendant Feake Edmund tanner 587836 587836 Feake, Edmund, of Folsham, tanner 0
4049282 2042190 2042190 defendant Watson Nicholas tailor or "vestiar" 587836 587836 Watson, Nicholas, of Folsham, tailor or "vestiar" 1
4052125 2043180 2043180 defendant Monye Robert husbandman 587836 587836 Monye, Robert, of Folsham, husbandman 10
4052133 2043181 2043181 defendant Olyver William laborer 587836 587836 Olyver, William, of Folsham, laborer 6
4063018 2047076 2047076 defendant Browne Edmund butcher 587836 587836 Browne, Edmund, of Folsham, butcher 0
4075479 2051531 2051531 defendant Hempested William (legal representative) 587836 587836 Hempested, William, of Folsham, yeoman, executors of 0
4075480 2051531 2051531 defendant London Thomas yeoman 587836 587836 (London, Thomas, of Folsham, yeoman 1
4078940 2052766 2052766 defendant Nicholas Thomas yeoman 587836 587836 Nicholas, Thomas, of Folsham, yeoman 0
4080501 2053339 2053339 defendant London Thomas yeoman 587836 587836 London, Thomas, of Folsham, yeoman 0
4098168 2059672 2059672 defendant Hopkyns Edmund gent 587836 587836 Hopkyns, Edmund, of Folsham, gent 1
4104693 2061959 2061959 defendant Themylthorpe George gent 587836 587836 Themylthorpe, George, of Folsham, gent 0
4104694 2061959 2061959 defendant Themylthorpe Robert gent 587836 587836 Themylthorpe, Robert, of Folsham, gent 1
4104695 2061959 2061959 defendant Themylthorpe Christopher gent 587836 587836 Themylthorpe, Christopher, of Folsham, gent 2
4108006 2063136 2063136 defendant Kent William husbandman 587836 587836 Kent, William, of Folsham, husbandman 2
4131516 2071590 2071590 defendant Framyngham Christopher tanner 587836 587836 Framyngham, Christopher, of Folsham, tanner 0
4142450 2075531 2075531 defendant Lavyle John gent 587836 587836 Lavyle, John, of Folsham, gent 0
4147677 2077330 2077330 defendant Watson Nicholas tailor 587836 587836 Watson, Nicholas, of Folsham, tailor 0
4151053 2078497 2078497 defendant Lavyle John gent 587836 587836 Lavyle, John, of Folsham, gent 0
4157868 2080828 2080828 defendant Pynchback Richard gent 587836 587836 Pynchback, Richard, of Folsham, gent 0
4163003 2082597 2082597 defendant Russon Richard grocer 587836 587836 Russon, Richard, of Folsham, or of Lyng, grocer 0
4173478 2086179 2086179 defendant Austen John husbandman 587836 587836 Austen, John, of Folsham, husbandman 3
4173483 2086180 2086180 defendant Austen John husbandman 587836 587836 Austen, John, of Folsham, husbandman 3
4175259 2086812 2086812 defendant Farror Nicholas yeoman 587836 587836 Farror, Nicholas, of Folsham, yeoman 0
4175260 2086812 2086812 defendant Pynchebecke Richard gent 587836 587836 Pynchebecke, Richard, of Folsham, gent 1
4175623 2086944 2086944 defendant Kent William yeoman 587836 587836 Kent, William, of Folsham, yeoman 2
4188141 2091353 2091353 defendant Lavyle John gent 587836 587836 Lavyle, John, of Folsham, gent 0
4188142 2091353 2091353 defendant Kent William yeoman 587836 587836 Kent, William, of Folsham, yeoman 1
4188143 2091353 2091353 defendant Doughty Peter yeoman 587836 587836 Doughty, Peter, of Folsham, yeoman 2
4194866 2093767 2093767 defendant Hayward Robert butcher 587836 587836 Hayward, Robert, of Folsham, butcher 0
4195886 2094116 2094116 defendant Watson Nicholas tailor 587836 587836 Watson, Nicholas, of Folsham, tailor 0
4202205 2096315 2096315 defendant Browne Edmund butcher 587836 587836 Browne, Edmund, of Folsham, butcher 0
4202307 2096348 2096348 defendant Kent William husbandman 587836 587836 (Kent, William, of Folsham, 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);