names

181 rows where place_id = 604022

✎ 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
3656595 1912317 1912317 defendant Tasbors Robert merchant 604022 604022 Tasbors, Robert, of Great Yarmouth, Norf, merchant 0
3661569 1913893 1913893 defendant bysshope Richard merchant 604022 604022 bysshope, Richard, of Great Yarmouth, Norf, merchant 1
3662189 1914090 1914090 defendant Panworth John glasier 604022 604022 Panworth, John, of Great Yarmouth, Norf, glasier 1
3664295 1914784 1914784 plaintiff Overey William tanner 604022 604022 Overey, William, of Great Yarmouth, Norf, tanner 1
3665264 1915088 1915088 defendant James Elizabeth widow 604022 604022 James, Elizabeth, of Great Yarmouth, Norf, widow 2
3665268 1915089 1915089 defendant Palmer Richard merchant 604022 604022 Palmer, Richard, of Great Yarmouth, Norf, merchant 0
3666400 1915442 1915442 defendant Palmer Richard merchant 604022 604022 Palmer, Richard, of Great Yarmouth, Norf, merchant 1
3715517 1931142 1931142 defendant Saunders Robert merchant 604022 604022 (Saunders, Robert, of Great Yarmouth, Norf, merchant 1
3898768 1989790 1989790 defendant Grys Gilbert gent 604022 604022 Grys, Gilbert, of Great Yarmouth, Norf, gent 3
3931536 2000846 2000846 defendant Gryce Gilbert gent 604022 604022 Gryce, Gilbert, of Great Yarmouth, Norf, gent 2
3932451 2001142 2001142 plaintiff Foster Richard mariner 604022 604022 Foster, Richard, of Great Yarmouth, Norf, mariner 0
3932747 2001254 2001254 defendant Hunt Thomas merchant 604022 604022 Hunt, Thomas, of Great Yarmouth, Norf, merchant 0
3932956 2001313 2001313 defendant Huntte Thomas merchant 604022 604022 Huntte, Thomas, of Great Yarmouth, Norf, merchant 0
4125563 2069425 2069425 defendant Page Robert yeoman 604022 604022 Page, Robert, of Great Yarmouth, Norf, yeoman 0
4391686 2161838 2161838 defendant Pawlinge Roger mariner 604022 604022 Pawlinge, Roger, of Great Yarmouth, Norf, merchant, mariner 0
4627264 2239474 2239474 defendant Selby Nicholas merchant 604022 604022 Selby, Nicholas, of Great Yarmouth, Norf, merchant 0
4667412 2255529 2255529 defendant Gase Walter   604022 604022 Gase, Walter, of Great Yarmouth, Norf, mason 1
4672239 2256965 2256965 defendant Cleye Richard   604022 604022 Cleye, Richard, of Great Yarmouth, Norf, burgess 0
4672242 2256966 2256966 defendant Cleye Richard   604022 604022 Cleye, Richard, of Great Yarmouth, Norf, burgess 0
4672401 2257020 2257020 defendant Calle Nicholas wooolman 604022 604022 Calle, Nicholas, of Great Yarmouth, Norf, wooolman 1
4672505 2257050 2257050 defendant Steyard William gent 604022 604022 Steyard, William, of Great Yarmouth, Norf, gent 0
4682204 2260056 2260056 defendant Spythlyng Henry chapman 604022 604022 Spythlyng, Henry, of Great Yarmouth, Norf, chapman 0
4682850 2260251 2260251 defendant Steyard William merchant 604022 604022 Steyard, William, of Great Yarmouth, Norf, merchant 0
4683598 2260472 2260472 defendant Stayerd William   604022 604022 Stayerd, William, of Great Yarmouth, Norf 0
4683627 2260481 2260481 defendant Stapyl John spicer 604022 604022 Stapyl, John, of Great Yarmouth, Norf, spicer 0
4686548 2261400 2261400 defendant Steyard William gent 604022 604022 Steyard, William, of Great Yarmouth, Norf, gent 0
4687876 2261773 2261773 defendant Belle Thomas   604022 604022 Belle, Thomas, of Great Yarmouth, Norf, hurdle maker 0
4690257 2262508 2262508 defendant Beclys John chapman 604022 604022 Beclys, John, of Great Yarmouth, Norf, chapman 0
4695933 2264214 2264214 defendant Cleye Richard husbandman 604022 604022 Cleye, Richard, of Great Yarmouth, Norf, husbandman 0
4696274 2264318 2264318 defendant Cley Richard merchant 604022 604022 Cley, Richard, of Great Yarmouth, Norf, merchant 1
4696303 2264326 2264326 defendant Busch William yeoman 604022 604022 Busch, William, of Great Yarmouth, Norf, yeoman 1
4697139 2264583 2264583 defendant Whytewell alias Bekeles John merchant 604022 604022 Whytewell alias Bekeles, John, of Great Yarmouth, Norf, merchant 4
4731206 2274959 2274959 defendant Spitlyng Henry merchant 604022 604022 Spitlyng, Henry, of Great Yarmouth, Norf, merchant 0
4741756 2278083 2278083 defendant Seyne Margaret widow & formerly wife of Thomas Seyne 604022 604022 Seyne, Margaret, of Great Yarmouth, Norf, widow & formerly wife of Thomas Seyne 2
4742959 2278454 2278454 defendant Osbarn Robert husbandman 604022 604022 (Osbarn, Robert, of Great Yarmouth, Norf, husbandman 1
4742964 2278455 2278455 defendant Osbarn Robert husbandman 604022 604022 (Osbarn, Robert, of Great Yarmouth, Norf, husbandman 1
4744357 2278873 2278873 defendant Osbern Robert chapman 604022 604022 Osbern, Robert, of Great Yarmouth, Norf, chapman 0
4749368 2280295 2280295 defendant atte Gappe Alexander   604022 604022 atte Gappe, Alexander, of Great Yarmouth, Norf, burgess 2
4752155 2281110 2281110 defendant Elys Richard merchant 604022 604022 Elys, Richard, of Great Yarmouth, Norf, merchant 0
4752172 2281112 2281112 defendant Pampyng Geoffrey merchant 604022 604022 Pampyng, Geoffrey, of Great Yarmouth, Norf, merchant 0
4752181 2281113 2281113 defendant Pynne John merchant 604022 604022 Pynne, John, of Great Yarmouth, Norf, merchant 0
4753398 2281437 2281437 defendant Moor John butcher 604022 604022 Moor, John, of Great Yarmouth, Norf, butcher 0
4754597 2281821 2281821 defendant Berdewell Robert fuller 604022 604022 Berdewell, Robert, of Great Yarmouth, Norf, fuller 1
4755357 2282064 2282064 defendant Spytlyng John husbandman 604022 604022 Spytlyng, John, of Great Yarmouth, Norf, husbandman 0
4755372 2282066 2282066 defendant Reman Robert chapman 604022 604022 Reman, Robert, of Great Yarmouth, Norf, chapman 0
4756775 2282483 2282483 defendant atte Stone Thomas chapman 604022 604022 atte Stone, Thomas, of Great Yarmouth, Norf, chapman 1
4762179 2284150 2284150 defendant atte Be William yeoman 604022 604022 atte Be, William, of Great Yarmouth, Norf, yeoman 0
4762796 2284344 2284344 defendant Berdewell Robert yeoman 604022 604022 Berdewell, Robert, of Great Yarmouth, Norf, yeoman 3
4762965 2284400 2284400 defendant Crabbe John yeoman 604022 604022 together with Crabbe, John, of Great Yarmouth, Norf, yeoman 2
4762969 2284401 2284401 defendant Crabbe John yeoman 604022 604022 together with Crabbe, John, of Great Yarmouth, Norf, yeoman 2
4763839 2284683 2284683 defendant Taillour Morris tailor 604022 604022 Taillour, Morris, of Great Yarmouth, Norf, tailor 2
4773052 2287542 2287542 defendant Savage Peter merchant 604022 604022 Savage, Peter, of Great Yarmouth, Norf, merchant 2
4773115 2287561 2287561 defendant Pampyng Geoffrey merchant 604022 604022 Pampyng, Geoffrey, of Great Yarmouth, Norf, merchant 1
4775810 2288433 2288433 defendant Person Robert merchant 604022 604022 Person, Robert, of Great Yarmouth, Norf, merchant 0
4807348 2298495 2298495 plaintiff Cobald John   604022 604022 Cobald, John, of Great Yarmouth, Norf 0
4807350 2298496 2298496 plaintiff Cobald John   604022 604022 Cobald, John, of Great Yarmouth, Norf, on his own account 0
4807642 2298581 2298581 defendant Dorell Nicholas shipman 604022 604022 Dorell, Nicholas, of Great Yarmouth, Norf, shipman 0
4809200 2299053 2299053 defendant Mast John yeoman 604022 604022 Mast, John, of Great Yarmouth, Norf, yeoman 2
4816549 2301269 2301269 defendant Steyard William yeoman 604022 604022 Steyard, William, of Great Yarmouth, Norf, yeoman 0
4818831 2301972 2301972 defendant Lynke William husbandman 604022 604022 Lynke, William, of Great Yarmouth, Norf, husbandman 0
4832766 2306272 2306272 defendant Oxeney John merchant 604022 604022 Oxeney, John, of Great Yarmouth, Norf, merchant 1
4836896 2307498 2307498 defendant Baltser William husbandman 604022 604022 Baltser, William, of Great Yarmouth, Norf, husbandman 1
4845280 2310034 2310034 defendant Reyner John husbandman 604022 604022 Reyner, John, of Great Yarmouth, Norf, husbandman 2
4845380 2310067 2310067 defendant Oxeney Bartholomew merchant 604022 604022 Oxeney, Bartholomew, of Great Yarmouth, Norf, merchant 0
4846694 2310474 2310474 defendant Boure John husbandman 604022 604022 Boure, John, of Great Yarmouth, Norf, husbandman 2
4847651 2310756 2310756 defendant Frebarn William mariner 604022 604022 Frebarn, William, of Great Yarmouth, Norf, mariner 0
4849876 2311432 2311432 defendant Mast John yeoman 604022 604022 Mast, John, of Great Yarmouth, Norf, yeoman 4
4853622 2312549 2312549 defendant Fyllysson Robert yeoman 604022 604022 (Fyllysson, Robert, of Great Yarmouth, Norf, yeoman 1
4909304 2329453 2329453 defendant Martyn Thomas draper 604022 604022 Martyn, Thomas, of Great Yarmouth, Norf, draper 0
4912177 2330308 2330308 defendant Symson Thomas yoeman 604022 604022 Symson, Thomas, of Great Yarmouth, Norf,yoeman 0
4926732 2334782 2334782 defendant Cobold John gent 604022 604022 Cobold, John, of Great Yarmouth, Norf, gent 2
4929821 2335740 2335740 defendant Brounyng John merchant & burgess 604022 604022 Brounyng, John, of Great Yarmouth, Norf, merchant & burgess 0
4929960 2335778 2335778 defendant Davy John tanner 604022 604022 Davy, John, of Great Yarmouth, Norf, tanner 5
4992420 2354619 2354619 defendant Pynne John merchant 604022 604022 Pynne, John, of Great Yarmouth, Norf, merchant 0
4996794 2355899 2355899 defendant Oxnay Robert husbandman 604022 604022 Oxnay, Robert, of Great Yarmouth, Norf, husbandman 0
4996810 2355902 2355902 defendant Oxnay Robert husbandman 604022 604022 Oxnay, Robert, of Great Yarmouth, Norf, husbandman 0
4996812 2355902 2355902 defendant Skottow Robert chapman 604022 604022 Skottow, Robert, of Great Yarmouth, Norf, chapman 2
5000762 2357100 2357100 defendant Calbras Thomas gent 604022 604022 Calbras, Thomas, of Great Yarmouth, Norf, gent 0
5000765 2357101 2357101 defendant Calbras Thomas gent 604022 604022 Calbras, Thomas, of Great Yarmouth, Norf, gent 0
5000768 2357102 2357102 defendant Calbras Thomas gent 604022 604022 Calbras, Thomas, of Great Yarmouth, Norf, gent 0
5001339 2357274 2357274 defendant Calbras Thomas gent 604022 604022 Calbras, Thomas, of Great Yarmouth, Norf, gent 0
5003805 2358003 2358003 defendant Calbras Thomas gent 604022 604022 Calbras, Thomas, of Great Yarmouth, Norf, gent 1
5005104 2358393 2358393 defendant Cobold John gent 604022 604022 Cobold, John, of Great Yarmouth, Norf, gent 0
5006855 2358905 2358905 defendant Chapman John chapman 604022 604022 Chapman, John, of Great Yarmouth, Norf, chapman 0
5007835 2359184 2359184 defendant Crosson Henry merchant 604022 604022 Crosson, Henry, of Great Yarmouth, Norf, merchant 0
5039547 2368476 2368476 defendant Godale Thomas merchant 604022 604022 Godale, Thomas, of Great Yarmouth, Norf, merchant 3
5039555 2368478 2368478 defendant Godale Thomas   604022 604022 Godale, Thomas, of Great Yarmouth, Norf, merchanat 3
5039749 2368530 2368530 defendant Fysshelak Thomas yeoman 604022 604022 Fysshelak, Thomas, of Great Yarmouth, Norf, yeoman 0
5039770 2368538 2368538 defendant Depeham Thomas clerk 604022 604022 Depeham, Thomas, of Great Yarmouth, Norf, clerk 0
5041571 2369082 2369082 defendant Lampet Ralph esq 604022 604022 Lampet, Ralph, of Great Yarmouth, Norf, esq 3
5043468 2369669 2369669 defendant Lampet Ralph esq 604022 604022 Lampet, Ralph, of Great Yarmouth, Norf, esq 3
5044412 2369959 2369959 defendant Stapilton Miles   604022 604022 Stapilton, Miles, of Great Yarmouth, Norf, knight 0
5044441 2369966 2369966 defendant Stapilton Miles   604022 604022 Stapilton, Miles, of Great Yarmouth, Norf, knight 0
5046183 2370488 2370488 defendant Calbras Thomas gent 604022 604022 Calbras, Thomas, of Great Yarmouth, Norf, gent 0
5049056 2371353 2371353 defendant Hemmyng Geoffrey yeoman 604022 604022 Hemmyng, Geoffrey, of Great Yarmouth, Norf, yeoman 0
5050637 2371818 2371818 defendant Bunne John merchant 604022 604022 Bunne, John, of Great Yarmouth, Norf, merchant 1
5051814 2372156 2372156 defendant Bunch Cecily widow 604022 604022 Bunch, Cecily, of Great Yarmouth, Norf, widow 1
5125424 2393920 2393920 defendant Lampet Ralph esq 604022 604022 Lampet, Ralph, of Great Yarmouth, Norf, esq 0
5125427 2393920 2393920 defendant Norman Thomas merchant 604022 604022 Norman, Thomas, of Great Yarmouth, Norf, merchant 3
5136383 2397160 2397160 defendant Lyghton John butcher 604022 604022 Lyghton, John, of Great Yarmouth, Norf, butcher 0

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