names

62 rows where place_id = 590257

✎ 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
3600408 1867772 1867772 defendant Sporle Geoffrey husbandman 590257 590257 Sporle, Geoffrey, of Hemmysby, husbandman 0
3600409 1867772 1867772 defendant Hey William husbandman 590257 590257 Hey, William, of Hemmysby, husbandman 1
3608084 1870180 1870180 defendant Botolff John husbandman 590257 590257 Botolff, John, of Hemmysby, husbandman 0
3627790 1903550 1903550 defendant Roper Henry laborer 590257 590257 Roper, Henry, of Hemmysby, laborer 1
3628692 1903848 1903848 defendant Broun John husbandman 590257 590257 Broun, John, of Hemmysby, husbandman 1
3657914 1912726 1912726 plaintiff Doke John   590257 590257 Doke, John, of Hemmysby 0
3672834 1917515 1917515 plaintiff Doke John   590257 590257 Doke, John, of Hemmysby 0
3672837 1917516 1917516 plaintiff Doke John   590257 590257 Doke, John, of Hemmysby 0
3764501 1946559 1946559 defendant Botolf John (legal representative) 590257 590257 Botolf, John, of Hemmysby, yeoman, executrix of 0
3778952 1951137 1951137 plaintiff Doke John   590257 590257 Doke, John, of Hemmysby 0
3809653 1960908 1960908 defendant Broun Hugh carpenter 590257 590257 Broun, Hugh, of Hemmysby, carpenter 1
3809655 1960908 1960908 defendant Shelton John laborer 590257 590257 Shelton, John, of Hemmysby, laborer 3
3815257 1962687 1962687 defendant Doke John yeoman 590257 590257 Doke, John, of Hemmysby, yeoman 3
3820368 1964248 1964248 defendant Sewell Robert yeoman 590257 590257 Sewell, Robert, of Hemmysby, yeoman 4
3836379 1969286 1969286 defendant Hay John husbandman 590257 590257 Hay, John, of Hemmysby, husbandman 1
3836380 1969286 1969286 defendant Lynlay Richard husbandman 590257 590257 Lynlay, Richard, of Hemmysby, husbandman 2
3836381 1969286 1969286 defendant Sharpe John husbandman 590257 590257 Sharpe, John, of Hemmysby, husbandman 3
3836385 1969287 1969287 defendant Hay John husbandman 590257 590257 Hay, John, of Hemmysby, husbandman 1
3836386 1969287 1969287 defendant Lynlay Richard husbandman 590257 590257 Lynlay, Richard, of Hemmysby, husbandman 2
3836387 1969287 1969287 defendant Sharpe John husbandman 590257 590257 Sharpe, John, of Hemmysby, husbandman 3
3839539 1970292 1970292 defendant Butt William butcher 590257 590257 Butt, William, of Hemmysby, butcher 0
3862801 1977750 1977750 defendant Imay Richard tailor 590257 590257 Imay, Richard, of Hemmysby, tailor 3
3872586 1981051 1981051 defendant Broun John husbandman 590257 590257 Broun, John, of Hemmysby, husbandman 1
3873756 1981443 1981443 defendant Haye John yeoman 590257 590257 Haye, John, of Hemmysby, yeoman 0
3874198 1981594 1981594 plaintiff Coppyng Roger   590257 590257 Coppyng, Roger, of Hemmysby 0
3879973 1983560 1983560 defendant Ducke John gent 590257 590257 Ducke, John, of Hemmysby, gent 0
3904498 1991752 1991752 plaintiff Heye John   590257 590257 Heye, John, of Hemmysby 0
4778670 2289312 2289312 defendant Murray John shipman 590257 590257 Murray, John, of Hemmysby, shipman 2
4826322 2304269 2304269 defendant atte Hill Richard yeoman 590257 590257 atte Hill, Richard, of Hemmysby, yeoman 0
5048336 2371136 2371136 defendant Bedyn William yeoman 590257 590257 Bedyn, William, of Hemmysby, yeoman 1
5069327 2377315 2377315 defendant Bery John husbandman 590257 590257 Bery, John, of Hemmysby, husbandman 2
5080673 2380708 2380708 defendant Murray Richard shipman 590257 590257 Murray, Richard, of Hemmysby, shipman 0
5085456 2382138 2382138 defendant Aleyn Nicholas yeoman 590257 590257 (Aleyn, Nicholas, of Hemmysby, yeoman 1
5093050 2384356 2384356 defendant Savy John yeoman 590257 590257 Savy, John, of Hemmysby, yeoman 2
5093051 2384356 2384356 defendant Stywardesson William yeoman 590257 590257 Stywardesson, William, of Hemmysby, yeoman 3
5135743 2396966 2396966 defendant Alayn Nicholas husbandman 590257 590257 Alayn, Nicholas, of Hemmysby, husbandman 0
5236953 2426392 2426392 defendant Hill John husbandman 590257 590257 (Hill, John, of Hemmysby, husbandman 2
5267382 2435564 2435564 defendant Bounde Richard husbndman 590257 590257 Bounde, Richard, of Hemmysby, husbndman 2
5271951 2436878 2436878 defendant Aleyn Ralph husbandman 590257 590257 Aleyn, Ralph, of Hemmysby, husbandman 2
5302034 2445564 2445564 defendant Thurston Thomas clerk 590257 590257 Thurston, Thomas, of Hemmysby, clerk 1
5302037 2445564 2445564 defendant Grey John yeoman 590257 590257 Grey, John, of Hemmysby, yeoman 4
5341819 2457634 2457634 defendant Kydman William husbandman 590257 590257 Kydman, William, of Hemmysby, husbandman 4
5352709 2460937 2460937 defendant Baldwyn John husbandman 590257 590257 Baldwyn, John, of Hemmysby, husbandman 1
5371639 2466717 2466717 defendant Sporle William husbandman 590257 590257 Sporle, William, of Hemmysby, husbandman 0
5383614 2470396 2470396 defendant Eldfeld Robert yeoman 590257 590257 Eldfeld, Robert, of Hemmysby, yeoman 1
5395439 2473770 2473770 defendant Blofeld Rboert yeoman 590257 590257 Blofeld, Rboert, of Hemmysby, yeoman 1
5407594 2477242 2477242 defendant Hay William yeoman 590257 590257 Hay, William, of Hemmysby, yeoman 2
5408758 2477577 2477577 defendant Blofeld Robert yeoman 590257 590257 Blofeld, Robert, of Hemmysby, yeoman 1
5417421 2480130 2480130 defendant Blofeld Robert husbandman 590257 590257 Blofeld, Robert, of Hemmysby, husbandman 8
5420816 2481152 2481152 defendant Blofeld Robert yeoman 590257 590257 Blofeld, Robert, of Hemmysby, yeoman 0
5420817 2481152 2481152 defendant Blofeld (illegible) yeoman 590257 590257 Blofeld, _, of Hemmysby, yeoman 1
5420818 2481152 2481152 defendant Hay William husbandman 590257 590257 Hay, William, of Hemmysby, husbandman 2
5423725 2482060 2482060 defendant Blofeld Robert husbandman 590257 590257 Blofeld, Robert, of Hemmysby, husbandman 0
5434628 2485294 2485294 defendant Blofeld Robert husbandman 590257 590257 Blofeld, Robert, of Hemmysby, husbandman 0
5434780 2485340 2485340 defendant Blofeld Robert husbandman 590257 590257 Blofeld, Robert, of Hemmysby, husbandman 7
5439833 2486853 2486853 defendant Blofeld Robert yeoman 590257 590257 Blofeld, Robert, of Hemmysby, yeoman 1
5439834 2486853 2486853 defendant Hay William yeoman 590257 590257 Hay, William, of Hemmysby, yeoman 2
5439841 2486855 2486855 defendant Blofeld Robert yeoman 590257 590257 Blofeld, Robert, of Hemmysby, yeoman 1
5450081 2489911 2489911 defendant Bolfeld Robert husbandman 590257 590257 Bolfeld, Robert, of Hemmysby, husbandman 6
5456606 2491899 2491899 defendant Steyngate Geoffrey husbandman 590257 590257 Steyngate, Geoffrey, of Hemmysby, husbandman 0
5462119 2493563 2493563 defendant Blofeld Robert husbandman 590257 590257 Blofeld, Robert, of Hemmysby, husbandman 0
5485104 2500467 2500467 defendant Blofeld Richard husbandman 590257 590257 Blofeld, Richard, of Hemmysby, husbandman 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);