names

78 rows where place_id = 596932

✎ 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
3626678 1903190 1903190 plaintiff Barbour Henry chaplain 596932 596932 Barbour, Henry, of Magna Walsyngham, chaplain 0
3626679 1903190 1903190 defendant Smyth William, senior husbandman 596932 596932 Smyth, William, senior, of Magna Walsyngham, husbandman 0
3645494 1908992 1908992 defendant Brygge Thomas husbandman 596932 596932 Brygge, Thomas, of Magna Walsyngham, husbandman 0
3674605 1918109 1918109 defendant Coo William husbandman 596932 596932 Coo, William, of Magna Walsyngham, husbandman 0
3704934 1927835 1927835 defendant Coo William husbandman 596932 596932 Coo, William, of Magna Walsyngham, husbandman 0
3719027 1932226 1932226 defendant Coo William yeoman 596932 596932 Coo, William, of Magna Walsyngham, yeoman 0
3724663 1933996 1933996 defendant Coo William husbandman 596932 596932 Coo, William, of Magna Walsyngham, husbandman 0
3727131 1934757 1934757 defendant Bullok John husbandman 596932 596932 Bullok, John, of Magna Walsyngham, husbandman 0
3753265 1942961 1942961 defendant Taylour George tailor 596932 596932 Taylour, George, of Magna Walsyngham, tailor 1
3758501 1944655 1944655 defendant Danell Robert   596932 596932 Danell, Robert, of Magna Walsyngham, rough mason 1
3758502 1944655 1944655 defendant Blogge Robert husbandman 596932 596932 Blogge, Robert, of Magna Walsyngham, husbandman 2
3762763 1945992 1945992 defendant Coo William husbandman 596932 596932 Coo, William, of Magna Walsyngham, husbandman 0
3764819 1946664 1946664 defendant Spanny Robert dyer 596932 596932 Spanny, Robert, of Magna Walsyngham, dyer 0
3765428 1946850 1946850 defendant Coo William husbandman 596932 596932 Coo, William, of Magna Walsyngham, husbandman 1
3822817 1965043 1965043 defendant Ryngsted William husbandman 596932 596932 Ryngsted, William, of Magna Walsyngham, husbandman 0
3873400 1981317 1981317 defendant Johnson John   596932 596932 Johnson, John, of Magna Walsyngham, shepherd 0
3918444 1996497 1996497 defendant Grene John husbandman 596932 596932 Grene, John, of Magna Walsyngham, husbandman 0
3963067 2011681 2011681 defendant Crome Robert yeoman 596932 596932 Crome, Robert, of Magna Walsyngham, yeoman 0
3964548 2012201 2012201 defendant Bucke Denis yeoman 596932 596932 Bucke, Denis, of Magna Walsyngham, yeoman 0
3964550 2012202 2012202 defendant Dragley John yeoman 596932 596932 Dragley, John, of Magna Walsyngham, yeoman 0
3968750 2013699 2013699 defendant Newman Thomas yeoman 596932 596932 Newman, Thomas, of Magna Walsyngham, yeoman 2
3974495 2015657 2015657 defendant Mason Thomas yeoman 596932 596932 Mason, Thomas, of Magna Walsyngham, yeoman 0
3974496 2015657 2015657 defendant Newman Thomas yeoman 596932 596932 Newman, Thomas, of Magna Walsyngham, yeoman 1
3989011 2020810 2020810 defendant Bucke Denis yeoman 596932 596932 Bucke, Denis, of Magna Walsyngham, yeoman 0
4052124 2043180 2043180 defendant Pope Thomas tailor 596932 596932 Pope, Thomas, of Magna Walsyngham, tailor 9
4052137 2043181 2043181 defendant Pope Thomas tailor 596932 596932 Pope, Thomas, of Magna Walsyngham, tailor 10
4203937 2096928 2096928 defendant Warren Robert   596932 596932 Warren, Robert, of Magna Walsyngham, yeoman, surgeon 1
4286957 2125388 2125388 defendant Blogg John tanner 596932 596932 Blogg, John, of Magna Walsyngham, tanner 1
4657540 2248249 2248249 defendant Lavender Thomas yeoman 596932 596932 Lavender, Thomas, of Magna Walsyngham, yeoman 1
4665254 2250620 2250620 defendant Frost Nicholas yeoman 596932 596932 Frost, Nicholas, of Magna Walsyngham, yeoman 0
4666357 2250953 2250953 defendant Wryght Richard butcher 596932 596932 Wryght, Richard, of Magna Walsyngham, butcher 0
4666360 2250953 2250953 defendant Ke- John butcher 596932 596932 Ke-, John, of Magna Walsyngham, butcher 3
4880345 2320759 2320759 defendant Palmer Thomas husbandman 596932 596932 Palmer, Thomas, of Magna Walsyngham, husbandman 0
4880349 2320760 2320760 defendant Palmer Thomas husbandman 596932 596932 Palmer, Thomas, of Magna Walsyngham, husbandman 0
4881649 2321160 2321160 defendant Hille Roger chaplain 596932 596932 Hille, Roger, of Magna Walsyngham, chaplain 2
4892242 2324315 2324315 defendant Shepherd William   596932 596932 Shepherd, William, of Magna Walsyngham, wright 0
4956659 2343949 2343949 defendant Takun Adam butcher 596932 596932 Takun, Adam, of Magna Walsyngham, butcher 0
5223074 2422460 2422460 defendant Davy Thomas husbandman 596932 596932 Davy, Thomas, of Magna Walsyngham, husbandman 9
5223085 2422461 2422461 defendant Davy Thomas husbandman 596932 596932 Davy, Thomas, of Magna Walsyngham, husbandman 8
5263602 2434365 2434365 defendant Peret Robert yeoman 596932 596932 Peret, Robert, of Magna Walsyngham, yeoman 0
5264053 2434516 2434516 defendant Bylton Thomas yeoman 596932 596932 Bylton, Thomas, of Magna Walsyngham, yeoman 0
5280048 2439238 2439238 defendant Perot Robert husbandman 596932 596932 Perot, Robert, of Magna Walsyngham, husbandman 1
5285463 2440768 2440768 defendant Buk Denis husbandman 596932 596932 Buk, Denis, of Magna Walsyngham, husbandman 4
5286709 2441121 2441121 defendant Skeythe Geoffre husbandman 596932 596932 Skeythe, Geoffre, of Magna Walsyngham, husbandman 3
5292316 2442753 2442753 defendant Perott Robert yeoman 596932 596932 Perott, Robert, of Magna Walsyngham, yeoman 0
5296770 2444044 2444044 defendant Perot Robert yeoman 596932 596932 Perot, Robert, of Magna Walsyngham, yeoman 0
5296848 2444067 2444067 defendant Deen Robert   596932 596932 Deen, Robert, of Magna Walsyngham, gent, bachelor of Civil Law 1
5339029 2456779 2456779 defendant Whitelak Thomas husbandman 596932 596932 Whitelak, Thomas, of Magna Walsyngham, husbandman 0
5348244 2459596 2459596 defendant Taverham Thomas gent 596932 596932 Taverham, Thomas, of Magna Walsyngham, gent 4
5350307 2460216 2460216 defendant Taverham Thomas esq 596932 596932 Taverham, Thomas, of Magna Walsyngham, esq 0
5351106 2460452 2460452 defendant Sulby Richard merchant 596932 596932 Sulby, Richard, of Magna Walsyngham, merchant 1
5351215 2460472 2460472 defendant Whocclerk Thomas smith 596932 596932 Whocclerk, Thomas, of Magna Walsyngham, smith 10
5352362 2460837 2460837 defendant Large Thomas weaver 596932 596932 Large, Thomas, of Magna Walsyngham, weaver 1
5352371 2460839 2460839 defendant Large Thomas weaver 596932 596932 Large, Thomas, of Magna Walsyngham, weaver 1
5353012 2461031 2461031 defendant Barbour Henry chaplain 596932 596932 Barbour, Henry, of Magna Walsyngham, chaplain 0
5353013 2461031 2461031 defendant Sulby Richard chapman 596932 596932 Sulby, Richard, of Magna Walsyngham, chapman 1
5353446 2461154 2461154 defendant Jankenys John husbandman 596932 596932 Jankenys, John, of Magna Walsyngham, husbandman 1
5353957 2461300 2461300 defendant Soulby Richard yeoman 596932 596932 Soulby, Richard, of Magna Walsyngham, yeoman 2
5354935 2461615 2461615 defendant Sulby Richard yeoman 596932 596932 Sulby, Richard, of Magna Walsyngham, yeoman 6
5362379 2463890 2463890 defendant Taverham Thomas gent 596932 596932 Taverham, Thomas, of Magna Walsyngham, gent 2
5492189 2502574 2502574 defendant Sever or Sener John baker 596932 596932 Sever or Sener, John, of Magna Walsyngham, baker 0
5495118 2503437 2503437 defendant Pestell Roland husbandman 596932 596932 Pestell, Roland, of Magna Walsyngham, husbandman 2
5498947 2504620 2504620 defendant Deen Robert   596932 596932 Deen, Robert, of Magna Walsyngham, notary 0
5499786 2504882 2504882 defendant Dene Robert   596932 596932 Dene, Robert, of Magna Walsyngham, notary 0
5504027 2506176 2506176 plaintiff Ycole Agnes (legal representative) 596932 596932 Ycole, Agnes, of Magna Walsyngham, widow of Ycole, Richard, of Magna Walsyngham, executors of 0
5504029 2506176 2506176 plaintiff Heryng Richard   596932 596932 Heryng, Richard, of Magna Walsyngham 2
5506125 2506834 2506834 defendant Pestell Roland husbandman 596932 596932 Pestell, Roland, of Magna Walsyngham, husbandman 0
5506127 2506835 2506835 defendant Somptour Edmund laborer 596932 596932 Somptour, Edmund, of Magna Walsyngham, laborer 0
5546448 2518961 2518961 defendant Bury Thomas husbandman 596932 596932 Bury, Thomas, of Magna Walsyngham, husbandman 0
5546451 2518961 2518961 defendant Bury William husbandman 596932 596932 Bury, William, of Magna Walsyngham, husbandman 3
5587818 2531207 2531207 defendant Smyth William husbandman 596932 596932 Smyth, William, of Magna Walsyngham, husbandman 1
5594165 2533152 2533152 defendant Smyth William, senior husbandman 596932 596932 Smyth, William, senior, of Magna Walsyngham, husbandman 1
5597884 2534238 2534238 defendant Mayston William (legal representative) 596932 596932 Mayston, William, of Magna Walsyngham, executor of 0
5625349 2551866 2551866 plaintiff Lynge John   596932 596932 Lynge, John, of Magna Walsyngham 0
5625353 2551866 2551866 defendant Millere Reginald   596932 596932 Millere, Reginald, of Magna Walsyngham 3
5629995 2553382 2553382 defendant Kempe John butcher 596932 596932 Kempe, John, of Magna Walsyngham, butcher 0
5634621 2554827 2554827 defendant Frost Nicholas   596932 596932 Frost, Nicholas, of Magna Walsyngham, bailiff 3
5636925 2555492 2555492 defendant de Hale Adam butcher 596932 596932 de Hale, Adam, of Magna Walsyngham, butcher 4

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