names

55 rows where place_id = 604239

✎ 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
3657323 1912551 1912551 defendant Damot Thomas hsubandman 604239 604239 Damot, Thomas, of Nedeham Markett, hsubandman 0
3657329 1912552 1912552 defendant Damot Thomas husbandman 604239 604239 Damot, Thomas, of Nedeham Markett, husbandman 0
3748292 1941394 1941394 defendant Branston alias Leyham Robert husbandman 604239 604239 Branston alias Leyham, Robert, of Nedeham Markett, husbandman 1
3748294 1941394 1941394 defendant Page John tailor 604239 604239 Page, John, of Nedeham Markett, tailor 3
3748295 1941394 1941394 defendant Bettys Stephen weaver 604239 604239 Bettys, Stephen, of Nedeham Markett, weaver 4
3768552 1947810 1947810 defendant Jacobe Thomas mercer 604239 604239 Jacobe, Thomas, of Nedeham Markett, mercer 0
3787932 1954019 1954019 defendant Jacob Thomas mercer 604239 604239 Jacob, Thomas, of Nedeham Markett, mercer 0
3801668 1958417 1958417 defendant Gardener William husbandman 604239 604239 Gardener, William, of Nedeham Markett, husbandman 0
3817315 1963326 1963326 defendant Jacobe Thomas husbandman 604239 604239 Jacobe, Thomas, of Nedeham Markett, husbandman 0
3817316 1963326 1963326 defendant Sparowe John husbandman 604239 604239 Sparowe, John, of Nedeham Markett, husbandman 1
3817317 1963326 1963326 defendant Bettys Thomas husbandman 604239 604239 Bettys, Thomas, of Nedeham Markett, husbandman 2
3817318 1963326 1963326 defendant Havell Thomas husbandman 604239 604239 Havell, Thomas, of Nedeham Markett, husbandman 3
3822262 1964866 1964866 defendant Bronwyn John clothmaker 604239 604239 Bronwyn, John, of Nedeham Markett, clothmaker 0
3851765 1974141 1974141 defendant Checheley William sherman 604239 604239 Checheley, William, of Nedeham Markett, sherman 0
3866280 1978951 1978951 defendant Checheley William sherman 604239 604239 Checheley, William, of Nedeham Markett, sherman 0
3880297 1983663 1983663 defendant Barbour John smith 604239 604239 Barbour, John, of Nedeham Markett, smith 0
3889705 1986792 1986792 defendant Salman Richard yeoman 604239 604239 Salman, Richard, of Nedeham Markett, yeoman 0
3889706 1986792 1986792 defendant Salman Robert clothier 604239 604239 Salman, Robert, of Nedeham Markett, clothier 1
3910298 1993761 1993761 defendant Sawseman Richard clothmaker 604239 604239 Sawseman, Richard, of Nedeham Markett, clothmaker 0
3958913 2010201 2010201 plaintiff Salmon Robert clothier 604239 604239 Salmon, Robert, of Nedeham Markett, clothier 0
3962994 2011654 2011654 defendant Uttyng Edward yeoman 604239 604239 Uttyng, Edward, of Nedeham Markett, yeoman 0
3964809 2012301 2012301 defendant Colchester Robert (legal representative) 604239 604239 Colchester, Robert, of Nedeham Markett, husbandman, administratrix of 0
3964810 2012301 2012301 defendant Colchester Alice widow 604239 604239 Colchester, Alice, of Nedeham Markett, widow 1
3967376 2013217 2013217 defendant Vaynge Thomas, junior yeoman 604239 604239 Vaynge, Thomas, junior, of Nedeham Markett, yeoman 2
4026536 2034142 2034142 defendant Coothes or Cotes Thomas clothier 604239 604239 Coothes or Cotes, Thomas, of Nedeham Markett, clothier 0
4026538 2034143 2034143 defendant Coothes or Cotes Thomas clothier 604239 604239 Coothes or Cotes, Thomas, of Nedeham Markett, clothier 0
4028481 2034838 2034838 defendant Asshyll John yeoman 604239 604239 Asshyll, John, of Nedeham Markett, yeoman 0
4028486 2034839 2034839 defendant Asshyll John yeoman 604239 604239 Asshyll, John, of Nedeham Markett, yeoman 0
4037711 2038140 2038140 defendant Cotes Thomas clothier 604239 604239 Cotes, Thomas, of Nedeham Markett, clothier 0
4045669 2040904 2040904 defendant Asshyll John scrivener 604239 604239 Asshyll, John, of Nedeham Markett, scrivener 2
4045684 2040907 2040907 defendant Asshell John scrivener 604239 604239 Asshell, John, of Nedeham Markett, scrivener 2
4096337 2059022 2059022 defendant Knap Edmund tanner 604239 604239 Knap, Edmund, of Nedeham Markett, tanner 0
4096339 2059022 2059022 defendant Candler William shoemaker 604239 604239 Candler, William, of Nedeham Markett, shoemaker 2
4109253 2063570 2063570 defendant Revell Roger mercer 604239 604239 Revell, Roger, of Nedeham Markett, mercer 0
4216173 2101147 2101147 defendant Deynes Robert butcher 604239 604239 Deynes, Robert, of Nedeham Markett, butcher 0
4236247 2108246 2108246 defendant Cotes Thomas clothier 604239 604239 Cotes, Thomas, of Nedeham Markett, clothier 1
4241566 2110164 2110164 defendant Hunt John tailor 604239 604239 Hunt, John, of Nedeham Markett, tailor 0
4248784 2112581 2112581 defendant Cotes Thomas clothier 604239 604239 Cotes, Thomas, of Nedeham Markett, clothier 2
4301564 2130665 2130665 defendant Bayman William yeoman 604239 604239 Bayman, William, of Nedeham Markett, yeoman 1
4301565 2130665 2130665 defendant Webbe William yeoman 604239 604239 Webbe, William, of Nedeham Markett, yeoman 2
4306238 2132318 2132318 defendant Aldus Robert, junior clothier 604239 604239 Aldus, Robert, junior, of Nedeham Markett, clothier 1
4306239 2132318 2132318 defendant Gosnold Edmund clothier 604239 604239 Gosnold, Edmund, of Nedeham Markett, clothier 2
4307510 2132764 2132764 defendant Revell Roger mercer 604239 604239 Revell, Roger, of Nedeham Markett, mercer 1
4340624 2143989 2143989 defendant Woode John clothier 604239 604239 Woode, John, of Nedeham Markett, clothier 2
4369172 2154039 2154039 defendant Aldis or Aldust Edward (legal representative) 604239 604239 Aldis or Aldust, Edward, of Nedeham Markett, clothier, executors of 0
4369173 2154039 2154039 defendant Colchester Thomas clothier 604239 604239 (Colchester, Thomas, of Nedeham Markett, clothier 1
4383308 2159131 2159131 defendant Dyckes Richard clothier 604239 604239 Dyckes, Richard, of Nedeham Markett, clothier 1
4394092 2162626 2162626 defendant Hunte Roger tailor 604239 604239 Hunte, Roger, of Nedeham Markett, tailor 0
4399408 2164391 2164391 defendant Jesoppe Anthony sherman 604239 604239 Jesoppe, Anthony, of Nedeham Markett, sherman 0
4405596 2166443 2166443 defendant Daynes Thomas clothier 604239 604239 Daynes, Thomas, of Nedeham Markett, clothier 0
4405597 2166443 2166443 defendant Stevens Ralph shoemaker 604239 604239 Stevens, Ralph, of Nedeham Markett, shoemaker 1
4405599 2166443 2166443 defendant Tarver George shoemaker 604239 604239 Tarver, George, of Nedeham Markett, shoemaker 3
4407435 2167048 2167048 defendant Dames or Daines Robert butcher 604239 604239 Dames or Daines, Robert, of Nedeham Markett, butcher 1
4407436 2167048 2167048 defendant Haberden Richard weaver 604239 604239 Haberden, Richard, of Nedeham Markett, weaver 2
4408140 2167292 2167292 defendant Lucas William clothier 604239 604239 Lucas, William, of Nedeham Markett, clothier 0

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