names

50 rows where place_id = 623366

✎ 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
3752074 1942571 1942571 defendant Abraham John smith 623366 623366 Abraham, John, of Shafton, smith 1
3788669 1954256 1954256 defendant Holme Richard yeoman 623366 623366 Holme, Richard, of Shafton, yeoman 0
4056144 2044586 2044586 defendant Man Richard laborer 623366 623366 Man, Richard, of Shafton, laborer 0
4189194 2091713 2091713 defendant Spiller John gent 623366 623366 Spiller, John, of Shafton , gent 0
4346103 2145891 2145891 defendant Rayner Thomas yeoman 623366 623366 Rayner, Thomas, of Shafton, yeoman 0
4400345 2164710 2164710 defendant Reynold Thomas yeoman 623366 623366 Reynold, Thomas, of Shafton, yeoman 0
4440754 2182025 2182025 plaintiff Beste William   623366 623366 Beste, William, of Shafton 0
4448015 2184301 2184301 defendant Wodell John   623366 623366 Wodell, John, of Shafton 1
4487039 2196668 2196668 defendant Compton Robert   623366 623366 Compton, Robert, of Shafton 0
4487046 2196671 2196671 defendant Welmanger John   623366 623366 Welmanger, John, of Shafton 0
4538575 2212343 2212343 defendant Serlee Philip   623366 623366 Serlee, Philip, of Shafton wool monger 0
4541288 2213172 2213172 plaintiff Wolmongere Philip   623366 623366 Wolmongere, Philip, of Shafton 0
4547768 2215243 2215243 plaintiff Carpenter Philip   623366 623366 Carpenter, Philip, of Shafton 0
4556709 2218032 2218032 defendant Hykkes John   623366 623366 Hykkes, John, of Shafton 3
4561971 2219676 2219676 defendant Stephenes William   623366 623366 Stephenes, William, of Shafton 1
4583317 2226203 2226203 plaintiff Fovent Cecilia   623366 623366 Fovent, Cecilia, of Shafton, abbess 0
4589700 2228145 2228145 defendant Bullok Thomas   623366 623366 (Bullok, Thomas, of Shafton 4
4589701 2228145 2228145 defendant Mason William   623366 623366 Mason, William, of Shafton 5
4656399 2247892 2247892 defendant Marshall Robert yeoman 623366 623366 Marshall, Robert, of Shafton, yeoman 5
4692782 2263255 2263255 defendant Brasyer Peter   623366 623366 Brasyer, Peter, of Shafton, bell founder 1
4699179 2265207 2265207 defendant Hatte Thomas   623366 623366 Hatte, Thomas, of Shafton 0
4703724 2266543 2266543 defendant Baudewyn John   623366 623366 Baudewyn, John, of Shafton, shoe maker 0
4712919 2269352 2269352 defendant Bartlot John smith 623366 623366 Bartlot, John, of Shafton, smith 0
4718765 2271211 2271211 defendant Bryne John butcher 623366 623366 Bryne, John, of Shafton, butcher 0
4723698 2272716 2272716 defendant Draper John sheerman 623366 623366 Draper, John, of Shafton, sheerman 3
4733539 2275666 2275666 defendant Deyer alias Bertelmewe John merchant 623366 623366 Deyer alias Bertelmewe, John, of Shafton, merchant 0
4738028 2276995 2276995 defendant Brerelay William de husbandman 623366 623366 Brerelay, William de, of Shafton, husbandman 0
4738039 2276999 2276999 defendant Barbour John barber 623366 623366 Barbour, John, of Shafton, barber 0
4738040 2276999 2276999 defendant Body John baker 623366 623366 Body, John, of Shafton, baker 1
4738041 2276999 2276999 defendant Gybon John tailor 623366 623366 Gybon, John, of Shafton, tailor 2
4745837 2279286 2279286 defendant Holgate William laborer 623366 623366 Holgate, William, of Shafton, laborer 0
4748765 2280124 2280124 plaintiff Milner John   623366 623366 Milner, John, of Shafton 0
4753207 2281387 2281387 plaintiff Voke Richard   623366 623366 Voke, Richard, of Shafton, on his own account 0
4753208 2281387 2281387 defendant York Peter   623366 623366 York, Peter, of Shafton, braseyete or brass founder 0
4762511 2284257 2284257 plaintiff Fovent Robert esq 623366 623366 Fovent, Robert, of Shafton, esq 0
4763373 2284532 2284532 defendant Gore Walter yeoman 623366 623366 Gore, Walter, of Shafton, yeoman 0
4827793 2304737 2304737 defendant Marsshall John husbandman 623366 623366 Marsshall, John, of Shafton, husbandman 0
4830367 2305531 2305531 plaintiff Bien John (legal representative) 623366 623366 Bien, John, of Shafton, executors of 0
4851157 2311814 2311814 plaintiff Tretfford John   623366 623366 Tretfford, John, of Shafton 0
4851158 2311814 2311814 defendant Fore John mercer 623366 623366 Fore, John, of Shafton, mercer 0
4853069 2312378 2312378 defendant Goldsmyth Thomas goldsmith 623366 623366 Goldsmyth, Thomas, of Shafton, goldsmith 4
4985921 2352705 2352705 defendant Wedmore William   623366 623366 Wedmore, William, of Shafton, cook 0
4986889 2353021 2353021 plaintiff Bartelmew Thomas   623366 623366 Bartelmew, Thomas, of Shafton, formerly servant of William Morton 0
4986890 2353021 2353021 defendant Muryfeld Richard mercer 623366 623366 Muryfeld, Richard, of Shafton, mercer 0
4995618 2355528 2355528 defendant Bryd John mercer 623366 623366 Bryd, John, of Shafton, mercer 1
4995619 2355528 2355528 defendant Plummer Edward plumber 623366 623366 Plummer, Edward, of Shafton, plumber 2
5241521 2427721 2427721 defendant Fysshe alias Porter John brewer 623366 623366 Fysshe alias Porter, John, of Shafton, brewer 1
5244850 2428667 2428667 defendant Wodehele John   623366 623366 Wodehele, John, of Shafton, court holder 0
5275616 2437935 2437935 defendant Warde Thomas yeoman 623366 623366 Warde, Thomas, of Shafton, yeoman 1
5303616 2446078 2446078 plaintiff St John Margaret   623366 623366 (St John, Margaret, of Shafton, abbess 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);