names

106 rows where place_id = 586817

✎ 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
3589725 1864426 1864426 defendant Ince Alice widow 586817 586817 Ince, Alice, of Lowystoft, widow 0
3593977 1865755 1865755 defendant Kyng Thomas butcher 586817 586817 Kyng, Thomas, of Lowystoft, butcher 3
3601146 1868022 1868022 plaintiff Aleyn Simon baker 586817 586817 Aleyn, Simon, of Lowystoft, baker 0
3601154 1868025 1868025 plaintiff Aleyne Simon baker 586817 586817 Aleyne, Simon, of Lowystoft, baker 0
3627286 1903381 1903381 defendant Hygham John yeoman 586817 586817 Hygham, John, of Lowystoft, yeoman 0
3730548 1935790 1935790 defendant Den Ralph draper 586817 586817 Den, Ralph, of Lowystoft, draper 0
3738626 1938290 1938290 defendant Lobbys Geoffrey yeoman 586817 586817 Lobbys, Geoffrey, of Lowystoft, yeoman 1
3749831 1941859 1941859 defendant Lobbys Geoffrey yeoman 586817 586817 Lobbys, Geoffrey, of Lowystoft, yeoman 0
3753473 1943024 1943024 defendant Hoddys Robert, senior merchant 586817 586817 Hoddys, Robert, senior, of Lowystoft, merchant 1
3766822 1947289 1947289 defendant Dene Ralph draper 586817 586817 Dene, Ralph, of Lowystoft, draper 0
3766823 1947289 1947289 defendant Bank Thomas baker 586817 586817 Bank, Thomas, of Lowystoft, baker 1
4444317 2183210 2183210 defendant Lanrele John   586817 586817 Lanrele, John, of Lowystoft 0
4455800 2186828 2186828 defendant Gerveys John   586817 586817 Gerveys, John, of Lowystoft 0
4459406 2187993 2187993 plaintiff Rycher Geoffrey   586817 586817 Rycher, Geoffrey, of Lowystoft 0
4521888 2207186 2207186 defendant Garveys John   586817 586817 Garveys, John, of Lowystoft 0
4523747 2207755 2207755 defendant Goffe John   586817 586817 Goffe, John, of Lowystoft 0
4575297 2223787 2223787 defendant Steyngate Richard   586817 586817 Steyngate, Richard, of Lowystoft 0
4587605 2227528 2227528 defendant Hode William   586817 586817 Hode, William, of Lowystoft 0
4639219 2242990 2242990 defendant Bemound John   586817 586817 Bemound, John, of Lowystoft 1
4687799 2261756 2261756 defendant Skenkyll John husbandman 586817 586817 Skenkyll, John, of Lowystoft, husbandman 1
4757183 2282615 2282615 defendant Langeley Thomas yeoman 586817 586817 Langeley, Thomas, of Lowystoft, yeoman 0
4783671 2290912 2290912 defendant Mendham William esq 586817 586817 Mendham, William, of Lowystoft, esq 0
4783672 2290912 2290912 defendant Candeler John pedder 586817 586817 Candeler, John, of Lowystoft, pedder 1
4802309 2296911 2296911 defendant Parker William   586817 586817 Parker, William, of Lowystoft, surgeon 0
4805716 2297998 2297998 plaintiff Burghard James husbandman 586817 586817 Burghard, James, of Lowystoft, husbandman 0
4807149 2298436 2298436 defendant Bocher Simon butcher 586817 586817 Bocher, Simon, of Lowystoft, butcher 1
4809199 2299053 2299053 defendant Coupe or Hunteman Stephen yeoman 586817 586817 Coupe or Hunteman, Stephen, of Lowystoft, yeoman 1
4816685 2301314 2301314 defendant Cove John butcher 586817 586817 Cove, John, of Lowystoft, butcher 0
4827214 2304562 2304562 plaintiff Wryghte Edmund merchant 586817 586817 Wryghte, Edmund, of Lowystoft, merchant 0
4827415 2304623 2304623 defendant Barbour surgeon William yeoman 586817 586817 Barbour surgeon, William, of Lowystoft, yeoman 0
4853620 2312549 2312549 plaintiff Wryght John   586817 586817 Wryght, John, of Lowystoft 0
4862814 2315354 2315354 defendant Frank Paul beer brewer 586817 586817 Frank, Paul, of Lowystoft, beer brewer 0
4870714 2317818 2317818 plaintiff March Robert   586817 586817 March, Robert, of Lowystoft 0
4870715 2317818 2317818 defendant Trop Simon butcher 586817 586817 Trop, Simon, of Lowystoft, butcher 0
4884045 2321921 2321921 defendant Smyth William butcher 586817 586817 Smyth, William, of Lowystoft, butcher 0
4886606 2322675 2322675 defendant Glover John skinner 586817 586817 Glover, John, of Lowystoft, skinner 0
4891868 2324191 2324191 defendant Glover John skinner 586817 586817 Glover, John, of Lowystoft, skinner 0
4896868 2325676 2325676 defendant Parker William merchant 586817 586817 Parker, William, of Lowystoft, or of Great Yarmouth, merchant 0
4913063 2330583 2330583 defendant Yemmnys John shoemaker 586817 586817 Yemmnys, John, of Lowystoft, shoemaker 0
4913064 2330583 2330583 defendant Aleys Geoffrey shoemaker 586817 586817 Aleys, Geoffrey, of Lowystoft, shoemaker 1
4923842 2333900 2333900 defendant Bocher Simon butcher 586817 586817 Bocher, Simon, of Lowystoft, butcher 0
4934672 2337235 2337235 defendant Berebrewer Timund beer brewer 586817 586817 Berebrewer, Timund, of Lowystoft, beer brewer 0
4935414 2337472 2337472 defendant Berbruere Timund beer brewer 586817 586817 Berbruere, Timund, of Lowystoft, beer brewer 0
4936119 2337696 2337696 plaintiff Bolt Roger   586817 586817 Bolt, Roger, of Lowystoft 0
4938865 2338546 2338546 defendant March William merchant 586817 586817 March, William, of Lowystoft, merchant 1
4940343 2339003 2339003 defendant Childerhous John carpenter 586817 586817 Childerhous, John, of Lowystoft, carpenter 1
4940344 2339003 2339003 defendant Mundys Henry yeoman 586817 586817 Mundys, Henry, of Lowystoft, yeoman 2
4953689 2343066 2343066 defendant Baret James baker 586817 586817 Baret, James, of Lowystoft, baker 0
4954579 2343327 2343327 defendant Hygham John merchant 586817 586817 Hygham, John, of Lowystoft, merchant 0
4954962 2343443 2343443 plaintiff Stubbere Simon   586817 586817 Stubbere, Simon, of Lowystoft 0
4955248 2343529 2343529 defendant Elwyn John butcher 586817 586817 Elwyn, John, of Lowystoft, butcher 0
4955249 2343529 2343529 defendant Brome John butcher 586817 586817 Brome, John, of Lowystoft, butcher 1
4955251 2343529 2343529 defendant Bocher Simon butcher 586817 586817 Bocher, Simon, of Lowystoft, butcher 3
4956452 2343887 2343887 plaintiff Tyte William   586817 586817 Tyte, William, of Lowystoft 0
4958257 2344438 2344438 plaintiff Wryghte Edmund merchant 586817 586817 Wryghte, Edmund, of Lowystoft, merchant 0
4958259 2344439 2344439 plaintiff Wryghte Edmund merchant 586817 586817 Wryghte, Edmund, of Lowystoft, merchant 0
4958385 2344475 2344475 defendant Huntman Stephen cooper 586817 586817 Huntman, Stephen, of Lowystoft, cooper 0
4961047 2345265 2345265 plaintiff Wryght Edmund   586817 586817 Wryght, Edmund, of Lowystoft 1
4961048 2345265 2345265 defendant Alman John merchant 586817 586817 Alman, John, of Lowystoft, merchant 0
4963360 2345948 2345948 defendant Berd William butcher 586817 586817 Berd, William, of Lowystoft, butcher 0
4963985 2346138 2346138 defendant Wryght Edmund yeoman 586817 586817 Wryght, Edmund, of Lowystoft, yeoman 0
4970595 2348146 2348146 defendant Vanleyn or Vauleyn John husbandman 586817 586817 Vanleyn or Vauleyn, John, of Lowystoft, husbandman 0
4970596 2348146 2348146 defendant Elwyn John butcher 586817 586817 Elwyn, John, of Lowystoft, butcher 1
4970821 2348216 2348216 plaintiff Heygham John merchant 586817 586817 Heygham, John, of Lowystoft, merchant 0
4971324 2348358 2348358 defendant Pulleyn John yeoman 586817 586817 Pulleyn, John, of Lowystoft, yeoman 0
4976866 2350031 2350031 plaintiff Perkyn John   586817 586817 Perkyn, John, of Lowystoft 0
4979619 2350862 2350862 plaintiff Shoboot Andrew   586817 586817 Shoboot, Andrew, of Lowystoft 0
4982287 2351618 2351618 defendant Jeppes William butcher 586817 586817 Jeppes, William, of Lowystoft, butcher 1
4997376 2356066 2356066 plaintiff Higham John merchant 586817 586817 Higham, John, of Lowystoft, merchant 0
5003792 2357999 2357999 plaintiff Perkyn John weaver 586817 586817 Perkyn, John, of Lowystoft, weaver 0
5021142 2363081 2363081 defendant Heyghham John merchant 586817 586817 Heyghham, John, of Lowystoft, merchant 0
5028011 2365072 2365072 defendant Childerhous John merchant or carpenter 586817 586817 Childerhous, John, of Lowystoft, merchant or carpenter 0
5029931 2365626 2365626 defendant Shoule John husbandman 586817 586817 Shoule, John, of Lowystoft, husbandman 0
5034102 2366840 2366840 plaintiff Stangate John merchant 586817 586817 Stangate, John, of Lowystoft, merchant 0
5049776 2371562 2371562 plaintiff Steyngate John merchant 586817 586817 Steyngate, John, of Lowystoft, merchant 0
5052480 2372335 2372335 defendant Welle John husbandman 586817 586817 Welle, John, of Lowystoft, husbandman 0
5069781 2377454 2377454 defendant Tesard John yeoman 586817 586817 Tesard, John,of Lowystoft, yeoman 0
5094864 2384914 2384914 defendant Anty or Auty William tailor 586817 586817 Anty or Auty, William, of Lowystoft, tailor 0
5109363 2389167 2389167 defendant Hill Nicholas husbandman 586817 586817 Hill, Nicholas, of Lowystoft, husbandman 1
5112219 2389955 2389955 defendant Donwolde Roger smith 586817 586817 Donwolde, Roger, of Lowystoft, smith 0
5115528 2390968 2390968 defendant Burghmouth John fuller 586817 586817 Burghmouth, John, of Lowystoft, fuller 0
5123830 2393426 2393426 plaintiff Wryght Edmund merchant 586817 586817 Wryght, Edmund, of Lowystoft, merchant 0
5124095 2393503 2393503 defendant Broome John butcher 586817 586817 Broome, John, of Lowystoft, butcher 0
5127168 2394423 2394423 defendant Joye John husbandman 586817 586817 Joye, John, of Lowystoft, husbandman 0
5140593 2398358 2398358 defendant Tesard John yeoman 586817 586817 Tesard, John, of Lowystoft, yeoman 2
5148104 2400591 2400591 defendant Boof John (legal representative) 586817 586817 Boof, John, of Lowystoft, esq, executor of 0
5148105 2400591 2400591 defendant Boof John merchant 586817 586817 Boof, John, of Lowystoft, merchant 1
5161699 2404526 2404526 defendant Tesard John yeoman 586817 586817 Tesard, John, of Lowystoft, yeoman 1
5164206 2405270 2405270 defendant Gemyngham Thomas husbandman 586817 586817 Gemyngham, Thomas, of Lowystoft, husbandman 0
5184829 2411312 2411312 defendant Gybson William merchant 586817 586817 Gybson, William, of Lowystoft, merchant 0
5197812 2415098 2415098 defendant Steyngate Henry (legal representative) 586817 586817 Steyngate, Henry, of Lowystoft, administrator of 2
5210290 2418736 2418736 defendant Tesard John yeoman 586817 586817 Tesard, John, of Lowystoft, yeoman 1
5210296 2418737 2418737 defendant Steyngate Henry (legal representative) 586817 586817 Steyngate, Henry, of Lowystoft, administrator of 2
5218863 2421241 2421241 plaintiff Gybson William merchant 586817 586817 Gybson, William, of Lowystoft, merchant 0
5218869 2421242 2421242 plaintiff Gybson William merchant 586817 586817 Gybson, William, of Lowystoft, merchant 0
5229124 2424125 2424125 defendant Hatter John merchant 586817 586817 Hatter, John, of Lowystoft, merchant 0
5229125 2424125 2424125 defendant Catur William   586817 586817 Catur, William, of Lowystoft, servant 1
5260486 2433412 2433412 defendant Saxmondham William merchant 586817 586817 Saxmondham, William, of Lowystoft, merchant 0
5283340 2440185 2440185 defendant Mundes Margaret widow 586817 586817 Mundes, Margaret, of Lowystoft, widow 3
5353362 2461129 2461129 defendant Higham John (legal representative) 586817 586817 Higham, John, of Lowystoft, merchant, administrator of 3

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