names

160 rows where place_id = 586785

✎ 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
3589614 1864393 1864393 plaintiff Cakermoll John   586785 586785 Cakermoll, John, of Blyburgh 0
3597035 1866696 1866696 defendant Wolcy John husbandman 586785 586785 Wolcy, John, of Blyburgh, husbandman 2
3606942 1869835 1869835 defendant Tropnell Robert tailor 586785 586785 Tropnell, Robert, of Blyburgh, tailor 2
3619081 1873569 1873569 defendant Tropynell Robert husbandman 586785 586785 Tropynell, Robert, of Blyburgh, husbandman 4
3656425 1912253 1912253 defendant Mortymer John laborer 586785 586785 Mortymer, John, of Blyburgh, laborer 3
3693375 1924142 1924142 defendant Abre Thomas yeoman 586785 586785 Abre, Thomas, of Blyburgh, yeoman 0
3698394 1925718 1925718 defendant Colett Thomas mercer 586785 586785 Colett, Thomas, of Blyburgh, mercer 4
3719083 1932248 1932248 defendant Bayle Christopher husbandman 586785 586785 Bayle, Christopher, of Blyburgh, husbandman 0
3723197 1933525 1933525 defendant Gylberd Thomas baker 586785 586785 Gylberd, Thomas, of Blyburgh, baker 2
3734924 1937162 1937162 defendant Hopton John painter 586785 586785 Hopton, John, of Blyburgh, painter 0
3773608 1949459 1949459 defendant Johnson William chaplain 586785 586785 Johnson, William, of Blyburgh, chaplain 0
3801682 1958421 1958421 defendant Hubbard John butcher 586785 586785 Hubbard, John, of Blyburgh, butcher 0
3812019 1961667 1961667 defendant Pares William husbandman 586785 586785 Pares, William, of Blyburgh, husbandman 0
3822178 1964834 1964834 defendant Nanbull or Naubull Edmund husbandman 586785 586785 Nanbull or Naubull, Edmund, of Blyburgh, husbandman 0
3846895 1972566 1972566 defendant Smyth John yeoman 586785 586785 Smyth, John, of Blyburgh, yeoman 2
3846899 1972567 1972567 defendant Smyth John yeoman 586785 586785 Smyth, John, of Blyburgh, yeoman 2
3848484 1973106 1973106 defendant Bettys Thomas glover 586785 586785 Bettys, Thomas, of Blyburgh, glover 1
3863732 1978050 1978050 defendant Bettys Thomas glover 586785 586785 Bettys, Thomas, of Blyburgh, glover 1
3885859 1985527 1985527 defendant Cappe Robert butcher 586785 586785 Cappe, Robert, of Blyburgh, butcher 0
3902754 1991151 1991151 defendant Marten Thomas butcher 586785 586785 Marten, Thomas, of Blyburgh, butcher 0
3925701 1998909 1998909 defendant Ayscue Walter gent 586785 586785 Ayscue, Walter, of Blyburgh, gent 0
3994437 2022764 2022764 defendant Puncher George husbandman 586785 586785 Puncher, George, of Blyburgh, husbandman 1
4029163 2035074 2035074 defendant Lyngwood Anthony yeoman 586785 586785 Lyngwood, Anthony, of Blyburgh, yeoman 0
4029166 2035075 2035075 defendant Lyngwood Anthony yeoman 586785 586785 Lyngwood, Anthony, of Blyburgh, yeoman 0
4142982 2075716 2075716 defendant Wylson William husbandman 586785 586785 Wylson, William, of Blyburgh, husbandman 0
4287692 2125651 2125651 defendant Ayscoughe Henry esq 586785 586785 Ayscoughe, Henry, of Blyburgh, esq 0
4328062 2139703 2139703 defendant Butcher John yeoman 586785 586785 Butcher, John, of Blyburgh, yeoman 0
4333942 2141636 2141636 defendant Aldred John tailor 586785 586785 Aldred, John, of Blyburgh, tailor 2
4410411 2168083 2168083 defendant Whynery Robert innholder 586785 586785 Whynery, Robert, of Blyburgh, innholder 0
4443037 2182785 2182785 plaintiff Canor Thomas   586785 586785 Canor, Thomas, of Blyburgh 0
4456922 2187177 2187177 defendant Gyles Henry   586785 586785 Gyles, Henry, of Blyburgh 1
4513534 2204656 2204656 defendant Wyot Robert   586785 586785 Wyot, Robert, of Blyburgh 0
4548222 2215386 2215386 defendant Wyot Robert   586785 586785 Wyot, Robert, of Blyburgh 0
4551048 2216271 2216271 plaintiff Donyland John (legal representative) 586785 586785 Donyland, John, of Blyburgh, executor of 0
4567577 2221422 2221422 defendant York John de   586785 586785 York, John de, of Blyburgh 1
4574314 2223496 2223496 defendant Misterton Thomas   586785 586785 Misterton, Thomas, of blyburgh 0
4591560 2228721 2228721 defendant Spicer Richard   586785 586785 Spicer, Richard, of Blyburgh 2
4597694 2230528 2230528 defendant Coteler John   586785 586785 Coteler, John, of Blyburgh 2
4600551 2231395 2231395 plaintiff Tolte John   586785 586785 Tolte, John, of Blyburgh 0
4623852 2238436 2238436 defendant Godale John   586785 586785 Godale, John, of Blyburgh 0
4666146 2250880 2250880 defendant Baker Henry yeoman 586785 586785 Baker, Henry, of Blyburgh, yeoman 0
4666147 2250880 2250880 defendant Sou- William yeoman 586785 586785 Sou-, William, of Blyburgh, yeoman 1
4672433 2257031 2257031 defendant Skory Robert chapman 586785 586785 Skory, Robert, of Blyburgh, chapman 1
4673258 2257277 2257277 defendant Aleyn John spicer 586785 586785 Aleyn, John, of Blyburgh, spicer 0
4673740 2257410 2257410 defendant Danyele Richard clerk 586785 586785 Danyele, Richard, of Blyburgh, clerk 4
4674349 2257585 2257585 plaintiff Dubletmakere Thomas   586785 586785 Dubletmakere, Thomas, of Blyburgh 0
4674351 2257585 2257585 defendant Kyng Adam cooper 586785 586785 Kyng, Adam, of Blyburgh, cooper 1
4676479 2258257 2258257 plaintiff Glovere John   586785 586785 Glovere, John, of Blyburgh 0
4677798 2258675 2258675 defendant Dubbletmakere Thomas tailor 586785 586785 Dubbletmakere, Thomas, of Blyburgh, tailor 2
4677799 2258675 2258675 defendant Godale John glover 586785 586785 Godale, John, of Blyburgh, glover 3
4689299 2262214 2262214 defendant Formaston Hugh (legal representative) 586785 586785 Formaston, Hugh, of Blyburgh, executors of 0
4689300 2262214 2262214 defendant Scaley Robert husbandman 586785 586785 (Scaley, Robert, of Blyburgh, husbandman 1
4700584 2265593 2265593 defendant Heygham William draper 586785 586785 Heygham, William, of Blyburgh, draper 0
4721293 2271989 2271989 defendant Dubletmaker Thomas husbandman 586785 586785 Dubletmaker, Thomas, of Blyburgh, husbandman 1
4721996 2272209 2272209 defendant Trusse Geoffrey yeoman 586785 586785 Trusse, Geoffrey, of Blyburgh, yeoman 0
4733670 2275709 2275709 plaintiff Bailly John   586785 586785 Bailly, John, of Blyburgh 1
4736651 2276592 2276592 plaintiff Thornton John gent 586785 586785 Thornton, John, of Blyburgh, gent 0
4738242 2277054 2277054 plaintiff Shaweley John   586785 586785 Shaweley, John, of Blyburgh 2
4738244 2277054 2277054 plaintiff Bailly John   586785 586785 Bailly, John, of Blyburgh 4
4738246 2277054 2277054 defendant atte Halle William yeoman 586785 586785 atte Halle, William, of Blyburgh, yeoman 1
4750721 2280696 2280696 defendant Penne William husbandman 586785 586785 Penne, William, of Blyburgh, husbandman 1
4750723 2280696 2280696 defendant Waarde John husbandman 586785 586785 Waarde, John, of Blyburgh, husbandman 3
4766715 2285578 2285578 defendant Taillour John chaplain 586785 586785 Taillour, John, of Blyburgh, chaplain 0
4770557 2286773 2286773 defendant Swyllyngton Roger (legal representative) 586785 586785 Swyllyngton, Roger, of Blyburgh, knight, executors of 0
4775000 2288177 2288177 defendant Felawe Reginald yeoman 586785 586785 Felawe, Reginald, of Blyburgh, yeoman 0
4781756 2290308 2290308 defendant Turry Robert butcher 586785 586785 Turry, Robert, of Blyburgh, butcher 3
4781757 2290308 2290308 defendant Turry William ploughman 586785 586785 Turry, William, of Blyburgh, ploughman 4
4782226 2290441 2290441 defendant Lounde Henry chaplain 586785 586785 Lounde, Henry, of Blyburgh, chaplain 1
4782533 2290547 2290547 defendant Thresshere John thresher 586785 586785 Thresshere, John, of Blyburgh, thresher 0
4801481 2296644 2296644 defendant Lystere William weaver 586785 586785 Lystere, William, of Blyburgh, weaver 1
4810807 2299504 2299504 defendant Neweman William yeoman 586785 586785 Neweman, William, of Blyburgh, yeoman 0
4811319 2299650 2299650 defendant Turry Robert butcher 586785 586785 Turry, Robert, of Blyburgh, butcher 1
4811857 2299822 2299822 plaintiff Glover John   586785 586785 Glover, John, of Blyburgh 0
4812082 2299889 2299889 defendant Whewall William yeoman 586785 586785 Whewall, William, of Blyburgh, yeoman 0
4820356 2302435 2302435 defendant Bakere Robert baker 586785 586785 Bakere, Robert, of Blyburgh, baker 2
4824907 2303827 2303827 defendant Anktell or Auktell William   586785 586785 Anktell or Auktell, William, of Blyburgh, wright 0
4824909 2303828 2303828 defendant Auktell William   586785 586785 Auktell, William, of Blyburgh, wright 0
4834082 2306666 2306666 defendant Taillour William husbandman 586785 586785 Taillour, William, of Blyburgh, husbandman 3
4834802 2306887 2306887 defendant Grene William husbandman 586785 586785 Grene, William, of Blyburgh, husbandman 1
4836436 2307372 2307372 defendant Duffeld John   586785 586785 Duffeld, John, of Blyburgh, bailiff 0
4836451 2307378 2307378 defendant Duffeld John   586785 586785 Duffeld, John, of Blyburgh, bailiff 0
4849877 2311432 2311432 defendant Chambre John (legal representative) 586785 586785 Chambre, John, of Blyburgh, administrator of 5
4850033 2311476 2311476 defendant Duffeld John husbandman 586785 586785 Duffeld, John, of Blyburgh, husbandman 1
4861041 2314812 2314812 defendant Spynk Walter husbandman 586785 586785 Spynk, Walter, of Blyburgh, husbandman 2
4861043 2314812 2314812 defendant Grene William husbandman 586785 586785 Grene, William, of Blyburgh, husbandman 4
4870482 2317740 2317740 plaintiff Lyster Robert   586785 586785 Lyster, Robert, of Blyburgh 1
4886630 2322682 2322682 defendant Neweman William glover 586785 586785 Neweman, William, of Blyburgh, glover 3
4899508 2326485 2326485 defendant Seman Philip butcher 586785 586785 Seman, Philip, of Blyburgh, butcher 1
4899509 2326485 2326485 defendant Busshop John butcher 586785 586785 Busshop, John, of Blyburgh, butcher 2
4900592 2326827 2326827 defendant Bailly Thomas husbandman 586785 586785 Bailly, Thomas, of Blyburgh, husbandman 0
4906950 2328752 2328752 defendant Smyth Robert chaplain 586785 586785 Smyth, Robert, of Blyburgh, chaplain 4
4910655 2329843 2329843 plaintiff Borhed Roger   586785 586785 Borhed, Roger, of Blyburgh 0
4912064 2330274 2330274 defendant Spynk Walter husbandman 586785 586785 Spynk, Walter, of Blyburgh, husbandman 0
4926302 2334653 2334653 plaintiff Pykot William   586785 586785 Pykot, William, of Blyburgh 0
4926304 2334653 2334653 defendant Pyper Simon turner 586785 586785 Pyper, Simon, of Blyburgh, turner 1
4936207 2337727 2337727 plaintiff Borhed Roger   586785 586785 Borhed, Roger, of Blyburgh 0
4939974 2338890 2338890 defendant Neweman William glover 586785 586785 Neweman, William, of Blyburgh, glover 2
4940552 2339070 2339070 defendant Watforthe William tailor 586785 586785 Watforthe, William, of Blyburgh, tailor 3
4961370 2345368 2345368 defendant Palmer John husbandman 586785 586785 Palmer, John, of Blyburgh, husbandman 0
4965757 2346685 2346685 defendant Neweman William glover 586785 586785 Neweman, William, of Blyburgh, glover 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);