names

92 rows where place_id = 587464

✎ 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
3591488 1864965 1864965 defendant Furmage Stephen yeoman 587464 587464 Furmage, Stephen, of Bakton, yeoman 0
3600585 1867830 1867830 defendant Reyberd Nicholas yeoman 587464 587464 Reyberd, Nicholas, of Bakton, yeoman 2
3604164 1868968 1868968 defendant Rampole John husbandman 587464 587464 Rampole, John, of Bakton, husbandman 2
3606959 1869839 1869839 defendant Bakton John gent 587464 587464 Bakton, John, of Bakton, gent 1
3630071 1904253 1904253 defendant Smyth John husbandman 587464 587464 Smyth, John, of Bakton, husbandman 0
3630072 1904253 1904253 defendant Mayewe John husbandman 587464 587464 Mayewe, John, of Bakton, husbandman 1
3639849 1907277 1907277 defendant Hall John husbandman 587464 587464 Hall, John, of Bakton, husbandman 1
3648513 1909934 1909934 defendant Goche John husbandman 587464 587464 Goche, John, of Bakton, husbandman 4
3648949 1910059 1910059 defendant Wynke William carpenter 587464 587464 Wynke, William, of Bakton, carpenter 4
3649923 1910341 1910341 defendant Pratyman William butcher 587464 587464 Pratyman, William, of Bakton, butcher 0
3649925 1910342 1910342 defendant Pratyman William butcher 587464 587464 Pratyman, William, of Bakton, butcher 0
3651021 1910686 1910686 plaintiff Soper William   587464 587464 Soper, William, of Bakton, clerk, master of St Giles Hospital, Norwich 0
3662072 1914065 1914065 defendant Rose William tanner 587464 587464 Rose, William, of Bakton, tanner 14
3662092 1914066 1914066 defendant Rose William tanner 587464 587464 Rose, William, of Bakton, tanner 15
3676511 1918697 1918697 defendant Hobart Walter esq 587464 587464 Hobart, Walter, of Bakton, esq 0
3678551 1919350 1919350 defendant Pratyman Thomas yeoman 587464 587464 Pratyman, Thomas, of Bakton, yeoman 0
3679821 1919753 1919753 plaintiff Pratyman William yeoman 587464 587464 Pratyman, William, of Bakton, yeoman 0
3693451 1924165 1924165 defendant Garnon Simon husbandman 587464 587464 Garnon, Simon, of Bakton, husbandman 7
3693452 1924165 1924165 defendant Reynberd John husbandman 587464 587464 Reynberd, John, of Bakton, husbandman 8
3694534 1924494 1924494 defendant Hobart Walter esq 587464 587464 Hobart, Walter, of Bakton, esq 0
3711976 1930063 1930063 defendant Garnon Simon yeoman 587464 587464 Garnon, Simon, of Bakton, yeoman 0
3715117 1931025 1931025 defendant Brown William husbandman 587464 587464 Brown, William, of Bakton, husbandman 1
3742391 1939491 1939491 defendant Bukman John husbandman 587464 587464 Bukman, John, of Bakton, husbandman 3
3764146 1946436 1946436 defendant Pratyman John butcher 587464 587464 Pratyman, John, of Bakton, butcher 0
3764147 1946436 1946436 defendant Pratyman Peter butcher 587464 587464 Pratyman, Peter, of Bakton, butcher 1
3764182 1946449 1946449 defendant Koo Thomas carpenter 587464 587464 Koo, Thomas, of Bakton, carpenter 0
3764183 1946449 1946449 defendant Clerke Henry carpenter 587464 587464 Clerke, Henry, of Bakton, carpenter 1
3768881 1947916 1947916 defendant Bardwell Edmund husbandman 587464 587464 Bardwell, Edmund, of Bakton, husbandman 0
3802897 1958803 1958803 defendant Calle Margaret widow 587464 587464 Calle, Margaret, of Bakton, widow 0
3829393 1967082 1967082 defendant Cubyte Robert husbandman 587464 587464 Cubyte, Robert, of Bakton, husbandman 0
3829394 1967082 1967082 defendant Draper John husbandman 587464 587464 Draper, John, of Bakton, husbandman 1
3838833 1970071 1970071 defendant Clarke Thomas sawyer 587464 587464 Clarke, Thomas, of Bakton, sawyer 1
3852019 1974223 1974223 plaintiff Pratyman William, senior yeoman 587464 587464 Pratyman, William, senior, of Bakton, yeoman 0
3868394 1979667 1979667 defendant Ederyche Nicholas husbandman 587464 587464 Ederyche, Nicholas, of Bakton, husbandman 2
3868395 1979667 1979667 defendant Taylour William husbandman 587464 587464 Taylour, William, of Bakton, husbandman 3
3872145 1980915 1980915 plaintiff Stayns Richard   587464 587464 Stayns, Richard, of Bakton 2
3886641 1985785 1985785 defendant Symond John butcher 587464 587464 Symond, John, of Bakton, butcher 0
3896237 1988950 1988950 defendant Cubytt Robert husbandman 587464 587464 Cubytt, Robert, of Bakton, husbandman 1
3904547 1991769 1991769 defendant Dobbys William yeoman 587464 587464 Dobbys, William, of Bakton, yeoman 1
3909092 1993340 1993340 defendant Dobbys William husbandman 587464 587464 Dobbys, William, of Bakton, husbandman 0
3910295 1993760 1993760 defendant Rose Thomas husbandman 587464 587464 Rose, Thomas, of Bakton, husbandman 1
3921730 1997611 1997611 plaintiff Pratyman William, junior yeoman 587464 587464 Pratyman, William, junior, of Bakton, yeoman 0
3939952 2003662 2003662 defendant Rosse Thomas husbandman 587464 587464 Rosse, Thomas, of Bakton, husbandman 2
4428272 2173673 2173673 defendant atte Wode John, senior   587464 587464 atte Wode, John, senior, of Bakton 0
4538429 2212305 2212305 defendant Kyrre Thomas tanner 587464 587464 Kyrre, Thomas, of Bakton, tanner 0
4538632 2212359 2212359 defendant Kyrre Thomas tanner 587464 587464 Kyrre, Thomas, of Bakton, tanner 0
4574802 2223645 2223645 defendant Hornyngeserth John   587464 587464 Hornyngeserth, John, of Bakton 0
4604707 2232637 2232637 defendant Grey John   587464 587464 Grey, John, of Bakton 0
4604708 2232637 2232637 defendant Bouse Robert   587464 587464 Bouse, Robert, of Bakton 1
4604709 2232637 2232637 defendant Spark Robert   587464 587464 Spark, Robert, of Bakton 2
4604710 2232637 2232637 defendant Merable John   587464 587464 Merable, John, of Bakton 3
4875689 2319354 2319354 defendant Pope John yeoman 587464 587464 Pope, John, of Bakton, yeoman 0
4902300 2327329 2327329 defendant Merable John husbandman 587464 587464 Merable, John, of Bakton, husbandman 0
4902301 2327329 2327329 defendant Olyve John husbandman 587464 587464 Olyve, John, of Bakton, husbandman 1
4902302 2327329 2327329 defendant Kyrre John husbandman 587464 587464 Kyrre, John, of Bakton, husbandman 2
4975829 2349736 2349736 defendant Burgh William (legal representative) 587464 587464 Burgh, William, of Bakton, executors of 4
5107263 2388551 2388551 defendant Smyth John husbandman 587464 587464 Smyth, John, of Bakton, husbandman 2
5120109 2392320 2392320 defendant Byntre John smith 587464 587464 Byntre, John, of Bakton, smith 0
5130621 2395445 2395445 defendant Dryver William yeoman 587464 587464 Dryver, William, of Bakton, yeoman 1
5181117 2410221 2410221 defendant Renet Robert yeoman 587464 587464 Renet, Robert, of Bakton, yeoman 0
5202737 2416566 2416566 defendant Revet or Renet Robert yeoman 587464 587464 Revet or Renet, Robert, of Bakton, yeoman 0
5243980 2428428 2428428 defendant Herman Clement husbandman 587464 587464 Herman, Clement, of Bakton, husbandman 2
5269578 2436208 2436208 defendant Bakton John gent 587464 587464 Bakton, John, of Bakton, gent 1
5290936 2442352 2442352 defendant Curteys John husbandman 587464 587464 Curteys, John, of Bakton, husbandman 2
5316986 2450160 2450160 defendant Bakton John gent 587464 587464 Bakton, John, of Bakton, gent 0
5317008 2450163 2450163 defendant Bakton John gent 587464 587464 Bakton, John, of Bakton, gent 2
5319747 2451000 2451000 defendant Bakton John gent 587464 587464 Bakton, John, of Bakton, gent 5
5333384 2455057 2455057 defendant Seyne or Seyve John clerk 587464 587464 Seyne or Seyve, John, of Bakton, clerk 6
5343131 2458042 2458042 defendant Bakton John gent 587464 587464 Bakton, John, of Bakton, gent 0
5346934 2459200 2459200 plaintiff Baketon John   587464 587464 Baketon, John, of Bakton 0
5346944 2459202 2459202 defendant Boole John yeoman 587464 587464 Boole, John, of Bakton, yeoman 0
5347591 2459402 2459402 defendant Barker William yeoman 587464 587464 Barker, William, of Bakton, yeoman 0
5347592 2459402 2459402 defendant Bowele John yeoman 587464 587464 Bowele, John, of Bakton, yeoman 1
5369972 2466198 2466198 defendant Dryver Thomas merchant 587464 587464 Dryver, Thomas, of Bakton, merchant 2
5369976 2466199 2466199 defendant Goodman Robert husbandman 587464 587464 Goodman, Robert, of Bakton, husbandman 0
5369978 2466200 2466200 defendant Goodman Robert husbandman 587464 587464 Goodman, Robert, of Bakton, husbandman 0
5397495 2474358 2474358 defendant Dryver John yeoman 587464 587464 Dryver, John, of Bakton, yeoman 14
5424668 2482337 2482337 defendant Dryver John yeoman 587464 587464 Dryver, John, of Bakton, yeoman 14
5440084 2486938 2486938 plaintiff Dryberd John   587464 587464 Dryberd, John, of Bakton 1
5468875 2495620 2495620 defendant Raweland Richard yeoman 587464 587464 Raweland, Richard, of Bakton, yeoman 6
5478936 2498720 2498720 defendant Revet or Renet Robert yeoman 587464 587464 Revet or Renet, Robert, of Bakton, yeoman 2
5478937 2498720 2498720 defendant Goche Robert chaplain 587464 587464 Goche, Robert, of Bakton, chaplain 3
5482791 2499800 2499800 defendant Bakton John gent 587464 587464 Bakton, John, of Bakton, gent 0
5509797 2507899 2507899 plaintiff Goche Robert (legal representative) 587464 587464 Goche, Robert, of Bakton, executor of 0
5514635 2509424 2509424 defendant Dryver Thomas husbandman 587464 587464 Dryver, Thomas, of Bakton, husbandman 0
5532573 2514731 2514731 defendant Cake William scrivener 587464 587464 Cake, William, of Bakton, scrivener 0
5555437 2521594 2521594 defendant Gale Richard husbandman 587464 587464 Gale, Richard, of Bakton, husbandman 1
5555438 2521594 2521594 defendant Hamond David tailor 587464 587464 Hamond, David, of Bakton, tailor 2
5569549 2525658 2525658 defendant Garnam William butcher 587464 587464 Garnam, William, of Bakton, butcher 0
5584168 2530119 2530119 defendant Pratyman Thomas butcher 587464 587464 Pratyman, Thomas, of Bakton, butcher 0
5584953 2530369 2530369 defendant Reynberd Nicholas yeoman 587464 587464 Reynberd, Nicholas, of Bakton, yeoman 0
5584955 2530370 2530370 defendant Reynberd Nicholas yeoman 587464 587464 Reynberd, Nicholas, of Bakton, yeoman 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);