names

87 rows where place_id = 588118

✎ 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
3593434 1865580 1865580 defendant Cokke Richard butcher 588118 588118 Cokke, Richard, of Framlyngham, butcher 0
3605205 1869294 1869294 defendant Fulmerston John gent 588118 588118 Fulmerston, John, of Framlyngham, gent 0
3615049 1872351 1872351 defendant Wryght Reginald yeoman 588118 588118 Wryght, Reginald, of Framlyngham, yeoman 1
3695455 1924802 1924802 defendant Say John butcher 588118 588118 Say, John, of Framlyngham, butcher 0
3695458 1924802 1924802 defendant Savage William dyer 588118 588118 Savage, William, of Framlyngham, dyer 3
3696596 1925169 1925169 defendant Pulham John yeoman 588118 588118 Pulham, John, of Framlyngham, yeoman 0
3721221 1932939 1932939 defendant Calle Nicholas yeoman 588118 588118 Calle, Nicholas, of Framlyngham, yeoman 0
3748856 1941579 1941579 defendant Pulham John, junior yeoman 588118 588118 Pulham, John, junior, of Framlyngham, yeoman 0
3763455 1946202 1946202 defendant Pulham John, junior yeoman 588118 588118 Pulham, John, junior, of Framlyngham, yeoman 0
3763458 1946203 1946203 defendant Pulham John, junior yeoman 588118 588118 Pulham, John, junior, of Framlyngham, yeoman 0
3789172 1954426 1954426 defendant Bayman Baldwyn butcher 588118 588118 Bayman, Baldwyn, of Framlyngham, butcher 0
3811048 1961349 1961349 defendant Goslyn Roger yeoman 588118 588118 Goslyn, Roger, of Framlyngham, yeoman 0
3812554 1961814 1961814 defendant Rooke George mercer 588118 588118 Rooke, George, of Framlyngham, mercer 0
3814983 1962607 1962607 defendant Sharpe Henry husbandman 588118 588118 Sharpe, Henry, of Framlyngham, husbandman 2
3852041 1974229 1974229 defendant Cokkys Thomas clerk 588118 588118 Cokkys, Thomas, of framlyngham, clerk 0
3969653 2013990 2013990 defendant Well Edmund husbandman 588118 588118 Well, Edmund, of Framlyngham, husbandman 1
3974805 2015752 2015752 defendant Pope John yeoman 588118 588118 Pope, John, of Framlyngham, yeoman 0
3985828 2019695 2019695 plaintiff Warner Francis gent 588118 588118 Warner, Francis, of Framlyngham, gent 0
3985831 2019696 2019696 plaintiff Warner Francis gent 588118 588118 Warner, Francis, of Framlyngham, gent 0
4043924 2040277 2040277 plaintiff Pulham Robert yeoman 588118 588118 Pulham, Robert, of Framlyngham, yeoman 0
4043925 2040277 2040277 plaintiff Pulham Simon yeoman 588118 588118 Pulham, Simon, of Framlyngham, yeoman 1
4071298 2050038 2050038 defendant Irelonde John yeoman 588118 588118 Irelonde, John, of Framlyngham, yeoman 0
4111048 2064201 2064201 defendant Smyth Roger husbandman 588118 588118 Smyth, Roger, of Framlyngham, husbandman 0
4137222 2073660 2073660 defendant Hayll Francis husbandman 588118 588118 Hayll, Francis, of Framlyngham, husbandman 0
4137224 2073660 2073660 defendant Whithedde John cooper 588118 588118 Whithedde, John, of Framlyngham, cooper 2
4172496 2085844 2085844 defendant Warner Francis gent 588118 588118 Warner, Francis, of Framlyngham, gent 0
4184770 2090182 2090182 defendant Helwys John husbandman 588118 588118 Helwys, John, of Framlyngham, husbandman 0
4184771 2090182 2090182 defendant Helwys Robert yeoman 588118 588118 together with Helwys, Robert, of Framlyngham, yeoman 1
4263858 2117571 2117571 defendant Sheparde John yeoman 588118 588118 Sheparde, John, of Framlyngham, yeoman 1
4274321 2120964 2120964 defendant Danforde Thomas draper 588118 588118 Danforde, Thomas, of Framlyngham, draper 0
4322836 2138055 2138055 defendant Helwys John yeoman 588118 588118 Helwys, John, of Framlyngham, yeoman 1
4550034 2215946 2215946 defendant Coteler Nicholas   588118 588118 Coteler, Nicholas, of Framlyngham 0
4554100 2217207 2217207 defendant Messenger Richard   588118 588118 Messenger, Richard, of Framlyngham 0
4574989 2223698 2223698 plaintiff Bocher John   588118 588118 Bocher, John, of Framlyngham 0
4574991 2223699 2223699 plaintiff Bocher John   588118 588118 Bocher, John, of Framlyngham 0
4577399 2224447 2224447 defendant Henne John   588118 588118 Henne, John, of Framlyngham 0
4600301 2231323 2231323 defendant Russell John   588118 588118 Russell, John, of Framlyngham 0
4600303 2231324 2231324 defendant Russell John   588118 588118 Russell, John, of Framlyngham 0
4613614 2235272 2235272 defendant Barbour John   588118 588118 Barbour, John, of Framlyngham 0
4613793 2235332 2235332 plaintiff Derhagh John   588118 588118 Derhagh, John, of Framlyngham 0
4613794 2235332 2235332 defendant Thacchere Thomas shoemaker 588118 588118 Thacchere, Thomas, of Framlyngham, shoemaker 0
4669458 2256152 2256152 defendant Bailly Nicholas yeoman 588118 588118 Bailly, Nicholas, of Framlyngham, yeoman 0
4670882 2256570 2256570 defendant Derbach John husbandman 588118 588118 Derbach, John, of Framlyngham, husbandman 2
4671398 2256702 2256702 defendant White John husbandman 588118 588118 White, John, of Framlyngham, husbandman 3
4673913 2257458 2257458 defendant Lopham John tanner 588118 588118 Lopham, John, of Framlyngham, tanner 3
4683085 2260325 2260325 defendant Pelham John yeoman 588118 588118 Pelham, John, of Framlyngham, yeoman 0
4683090 2260326 2260326 defendant White John husbandman 588118 588118 White, John, of Framlyngham, husbandman 0
4742231 2278216 2278216 defendant Derhagh John (legal representative) 588118 588118 Derhagh, John, of Framlyngham, executors of 4
4742232 2278216 2278216 defendant Derhagh Robert clerk 588118 588118 (Derhagh, Robert, of Framlyngham, clerk 5
4742233 2278216 2278216 defendant Derhagh Beatrice widow 588118 588118 Derhagh, Beatrice, of Framlyngham, widow 6
4746376 2279438 2279438 plaintiff Banham Reginald   588118 588118 Banham, Reginald, of Framlyngham, parson 2
4751244 2280840 2280840 defendant Smert John yeoman 588118 588118 Smert, John, of Framlyngham, yeoman 0
4754083 2281656 2281656 defendant Bailly Nicholas yeoman 588118 588118 Bailly, Nicholas, of Framlyngham, yeoman 0
4764364 2284849 2284849 plaintiff Banham Reginald   588118 588118 Banham, Reginald, of Framlyngham, parson 2
4877940 2320055 2320055 defendant Bokenham John gent 588118 588118 Bokenham, John, of Framlyngham, gent 0
4932384 2336523 2336523 defendant Hert John husbandman 588118 588118 Hert, John, of Framlyngham, husbandman 0
4932385 2336523 2336523 defendant Storm William husbandman 588118 588118 Storm, William, of Framlyngham, husbandman 1
4934021 2337019 2337019 defendant Chambre Thomas yeoman 588118 588118 Chambre, Thomas, of Framlyngham, yeoman 0
4974753 2349418 2349418 defendant Peyntour Robert butcher 588118 588118 Peyntour, Robert, of Framlyngham, butcher 0
4985893 2352696 2352696 defendant Cavndyssh Thomas esq 588118 588118 Cavndyssh, Thomas, of Framlyngham, esq 0
4993544 2354942 2354942 defendant Burnynghill John esq 588118 588118 Burnynghill, John, of Framlyngham, esq 0
5021326 2363144 2363144 plaintiff FitzWilliam Edmund esq 588118 588118 FitzWilliam, Edmund, of Framlyngham, esq 0
5251704 2430638 2430638 defendant Wodburne Richard gent 588118 588118 Wodburne, Richard, of Framlyngham, gent 1
5251715 2430640 2430640 defendant Sothwell John esq 588118 588118 together with Sothwell, John, of Framlyngham, esq 1
5339066 2456792 2456792 defendant Short John, senior chandler 588118 588118 Short, John, senior, of Framlyngham, chandler 1
5349177 2459868 2459868 defendant Hert Geoffrey chaplain 588118 588118 Hert, Geoffrey, of Framlyngham, chaplain 8
5355481 2461788 2461788 defendant Gebon John carpenter 588118 588118 Gebon, John, of Framlyngham, carpenter 3
5355729 2461869 2461869 defendant Webbe William husbandman 588118 588118 Webbe, William, of Framlyngham, husbandman 0
5361675 2463676 2463676 defendant Smethes Thomas yeoman 588118 588118 Smethes, Thomas, of Framlyngham, yeoman 0
5396334 2474043 2474043 defendant Trusse John yeoman 588118 588118 Trusse, John, of Framlyngham, yeoman 0
5396335 2474043 2474043 defendant Salowe William yeoman 588118 588118 Salowe, William, of Framlyngham, yeoman 1
5457231 2492061 2492061 defendant Goodekyn Reginald yeoman 588118 588118 Goodekyn, Reginald, of Framlyngham, yeoman 1
5457232 2492061 2492061 defendant Stonlee John yeoman 588118 588118 Stonlee, John, of Framlyngham, yeoman 2
5469082 2495680 2495680 defendant Godwyn Reginald yeoman 588118 588118 Godwyn, Reginald, of Framlyngham, yeoman 1
5469083 2495680 2495680 defendant Stoules John yeoman 588118 588118 Stoules, John, of Framlyngham, yeoman 2
5480253 2499074 2499074 defendant Goodwyn alias Wryght Reginald yeoman 588118 588118 Goodwyn alias Wryght, Reginald, of Framlyngham, yeoman 1
5481158 2499319 2499319 defendant Godard John husbandman 588118 588118 Godard, John, of Framlyngham, husbandman 1
5491413 2502319 2502319 defendant Torold Seman chaplain 588118 588118 Torold, Seman, of Framlyngham, chaplain 2
5507289 2507176 2507176 defendant Wright William husbandman 588118 588118 Wright, William, of Framlyngham, husbandman 2
5507321 2507186 2507186 defendant Fulmerston John yeoman 588118 588118 Fulmerston, John, of Framlyngham, yeoman 0
5508653 2507570 2507570 defendant Godard John husbandman 588118 588118 Godard, John, of Framlyngham, husbandman 4
5516641 2510033 2510033 defendant Wryght William yeoman 588118 588118 Wryght, William, of Framlyngham, yeoman 1
5555248 2521539 2521539 defendant Spynke William husbandman 588118 588118 Spynke, William, of Framlyngham, husbandman 1
5569130 2525522 2525522 defendant Freman Thomas yeoman 588118 588118 Freman, Thomas, of Framlyngham, yeoman 0
5569136 2525524 2525524 defendant Freman Thomas yeoman 588118 588118 Freman, Thomas, of Framlyngham, yeoman 0
5590220 2531912 2531912 defendant Pulham John yeoman 588118 588118 Pulham, John, of Framlyngham, yeoman 0
5634461 2554776 2554776 defendant Pulham John yeoman 588118 588118 Pulham, John, of Framlyngham, yeoman 1

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