names

69 rows where place_id = 590008

✎ 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
3599573 1867503 1867503 defendant Hydon John husbandman 590008 590008 Hydon, John, of Rumford, husbandman 0
3634738 1905660 1905660 defendant Note John gent 590008 590008 Note, John, of Rumford, gent 0
3638380 1906823 1906823 defendant Owteryd John (legal representative) 590008 590008 Owteryd, John, of Rumford, tanner, executor of 0
3648807 1910015 1910015 defendant Ballard Richard innholder 590008 590008 Ballard, Richard, of Rumford, innholder 3
3653630 1911397 1911397 defendant Outred Richard yeoman 590008 590008 Outred, Richard, of Rumford, yeoman 1
3653631 1911397 1911397 defendant Leget Thomas yeoman 590008 590008 Leget, Thomas, of Rumford, yeoman 2
3813842 1962240 1962240 defendant Brewer William tanner 590008 590008 Brewer, William, of Rumford, tanner 0
3823258 1965191 1965191 defendant Staunton John gent 590008 590008 Staunton, John, of Rumford, gent 1
3837992 1969793 1969793 defendant Carowe John yeoman 590008 590008 Carowe, John, of Rumford, yeoman 1
3837995 1969794 1969794 defendant Carowe John yeoman 590008 590008 Carowe, John, of Rumford, yeoman 1
3880280 1983658 1983658 defendant Putman Severum beer brewer 590008 590008 Putman, Severum, of Rumford, beer brewer 0
4252473 2113818 2113818 defendant Wells John yeoman 590008 590008 Wells, John, of Rumford, yeoman 1
4263556 2117475 2117475 defendant Copland William yeoman 590008 590008 Copland, William, of Rumford, or of Havering, yeoman 1
4433687 2175302 2175302 plaintiff Gynnour John   590008 590008 Gynnour, John, of Rumford 0
4444887 2183375 2183375 defendant Saman Richard   590008 590008 Saman, Richard, of Rumford 1
4501830 2201172 2201172 defendant Geron Richard   590008 590008 Geron, Richard, of Rumford 0
4528520 2209196 2209196 defendant Hethe John   590008 590008 Hethe, John, of Rumford 0
4577727 2224539 2224539 defendant Wheler Thomas   590008 590008 Wheler, Thomas, of Rumford 3
4656960 2248068 2248068 defendant Cok Martin drover 590008 590008 Cok, Martin, of Rumford, drover 0
4735391 2276213 2276213 defendant atte Hethe Walter husbandman 590008 590008 atte Hethe, Walter, of Rumford, husbandman 0
4757362 2282674 2282674 defendant Wroo Thomas husbandman 590008 590008 Wroo, Thomas, of Rumford, husbandman 1
4765283 2285124 2285124 defendant Norfolk Thomas   590008 590008 Norfolk, Thomas, of Rumford, bailiff 0
4786353 2291776 2291776 defendant Marshall Henry tanner 590008 590008 Marshall, Henry, of Rumford, tanner 0
4826358 2304283 2304283 defendant Cokermouth William husbandman 590008 590008 Cokermouth, William, of Rumford, husbandman 0
4885559 2322363 2322363 defendant Quylter Reginald pulter 590008 590008 Quylter, Reginald, of Rumford, pulter 2
4899701 2326539 2326539 defendant Cleche William clerk 590008 590008 Cleche, William, of Rumford, clerk 0
4899702 2326539 2326539 defendant Holywell John husbandman 590008 590008 Holywell, John, of Rumford, husbandman 1
4928682 2335396 2335396 defendant Boll John barber 590008 590008 Boll, John, of Rumford, barber 2
4954802 2343394 2343394 defendant Horn Thomas sawyer 590008 590008 Horn, Thomas, of Rumford, sawyer 0
4955957 2343748 2343748 defendant Brokeman John husbandman 590008 590008 Brokeman, John, of Rumford, husbandman 0
4981013 2351254 2351254 defendant Strete John husbandman 590008 590008 Strete, John, of Rumford, husbandman 0
4981015 2351255 2351255 defendant Strete John husbandman 590008 590008 Strete, John, of Rumford, husbandman 0
5003595 2357942 2357942 defendant Cappes Thomas husbandman 590008 590008 Cappes, Thomas, of Rumford, husbandman 1
5003626 2357951 2357951 defendant Cappes Thomas husbandman 590008 590008 Cappes, Thomas, of Rumford, husbandman 1
5015918 2361545 2361545 defendant Marchall John clothier 590008 590008 Marchall, John, of Rumford, clothier 0
5015920 2361546 2361546 defendant Marchall John glover 590008 590008 Marchall, John, of Rumford, glover 0
5036404 2367504 2367504 defendant Marchall John husbandman 590008 590008 Marchall, John, of Rumford, husbandman 0
5045519 2370288 2370288 defendant Stokker Peter maltman 590008 590008 Stokker, Peter, of Rumford, maltman 1
5049005 2371338 2371338 defendant Taper Edmund butcher 590008 590008 Taper, Edmund, of Rumford, butcher 2
5049006 2371338 2371338 defendant Marchall John yeoman 590008 590008 Marchall, John, of Rumford, yeoman 3
5049012 2371339 2371339 defendant Marchall John yeoman 590008 590008 Marchall, John, of Rumford, yeoman 3
5056601 2373546 2373546 defendant Marchall John husbandman 590008 590008 Marchall, John, of Rumford, husbandman 2
5058207 2374009 2374009 defendant Marsshall John husbandman 590008 590008 Marsshall, John, of Rumford, husbandman 3
5063624 2375653 2375653 defendant Boole John butcher 590008 590008 Boole, John, of Rumford, butcher 1
5076985 2379614 2379614 defendant Elyot William collier 590008 590008 Elyot, William, of Rumford, collier 0
5078393 2380034 2380034 defendant de Kent John butcher 590008 590008 de Kent, John, of Rumford, butcher 1
5083994 2381714 2381714 defendant Wellys George barber 590008 590008 Wellys, George, of Rumford, barber 0
5085866 2382261 2382261 defendant Cole John yeoman 590008 590008 Cole, John, of Rumford, yeoman 3
5086059 2382314 2382314 defendant Rose William yeoman 590008 590008 Rose, William, of Rumford, yeoman 3
5088257 2382940 2382940 defendant Joy John yeoman 590008 590008 Joy, John, of Rumford, yeoman 0
5088258 2382940 2382940 defendant Herd William yeoman 590008 590008 Herd, William, of Rumford, yeoman 1
5100731 2386639 2386639 defendant Wyot John yeoman 590008 590008 Wyot, John, of Rumford, yeoman 1
5100736 2386640 2386640 defendant Wyot John yeoman 590008 590008 Wyot, John, of Rumford, yeoman 1
5103284 2387391 2387391 defendant John Peter draper 590008 590008 John, Peter, of Rumford, draper 3
5103285 2387391 2387391 defendant Wyot John yeoman 590008 590008 Wyot, John, of Rumford, yeoman 4
5133334 2396239 2396239 defendant Bole Joan widow 590008 590008 Bole, Joan, of Rumford, widow 0
5133335 2396239 2396239 defendant Kent (illegible) butcher 590008 590008 Kent, ---, of Rumford, butcher 1
5147825 2400506 2400506 defendant Burton William husbandman 590008 590008 Burton, William, of Rumford, husbandman 4
5210743 2418874 2418874 defendant Spencer Robert (legal representative) 590008 590008 Spencer, Robert, of Rumford, yeoman, executors of 0
5240252 2427356 2427356 defendant Scot Thomas yeoman 590008 590008 Scot, Thomas, of Rumford, yeoman 0
5266146 2435161 2435161 defendant Scotte Thomas husbandman 590008 590008 Scotte, Thomas, of Rumford, husbandman 4
5362188 2463839 2463839 defendant Mounteney John ostler 590008 590008 Mounteney, John, of Rumford, ostler 0
5369447 2466035 2466035 defendant Hewe John   590008 590008 Hewe, John, of Rumford 2
5397945 2474487 2474487 defendant Bryce Ellis laborer 590008 590008 Bryce, Ellis, of Rumford, laborer 1
5399522 2474943 2474943 defendant Here Thomas husbandman 590008 590008 Here, Thomas, of Rumford, husbandman 1
5427352 2483125 2483125 defendant Herd Thomas husbandman 590008 590008 Herd, Thomas, of Rumford, husbandman 1
5444281 2488194 2488194 defendant Elmer Thomas yeoman 590008 590008 Elmer, Thomas, of Rumford, yeoman 0
5548524 2519607 2519607 defendant Golde John husbandman 590008 590008 Golde, John, of Rumford, husbandman 0
5599429 2534707 2534707 defendant Ruk William husbandman 590008 590008 Ruk, William, of Rumford, husbandman 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);