names

57 rows where place_id = 650938

✎ 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
3914797 1995296 1995296 defendant Clarke Humphrey   650938 650938 Clarke, Humphrey, of Wetheresfeld, hair weaver 0
3914800 1995296 1995296 defendant Clevelond Lawrence butcher 650938 650938 Clevelond, Lawrence, of Wetheresfeld, butcher 3
3914801 1995296 1995296 defendant Burgeyn Richard husbandman 650938 650938 Burgeyn, Richard, of Wetheresfeld, husbandman 4
4426454 2173085 2173085 defendant Parker William   650938 650938 Parker, William, of Wetheresfeld 0
4441569 2182295 2182295 defendant Smyth Geoffrey   650938 650938 Smyth, Geoffrey, of Wetheresfeld 0
4474498 2192683 2192683 defendant Wassh Geoffrey   650938 650938 Wassh, Geoffrey, of Wetheresfeld 2
4529211 2209415 2209415 defendant Welle John   650938 650938 Welle, John, of Wetheresfeld 0
4529212 2209415 2209415 defendant Priour Walter   650938 650938 Priour, Walter, of Wetheresfeld 1
4534333 2211003 2211003 defendant Bocher John   650938 650938 Bocher, John, of Wetheresfeld 2
4565190 2220686 2220686 defendant Barstaple Thomas   650938 650938 Barstaple, Thomas, of Wetheresfeld 1
4565769 2220849 2220849 defendant Beneyt John   650938 650938 Beneyt, John, of Wetheresfeld 0
4569346 2222002 2222002 defendant Bakere John   650938 650938 Bakere, John, of Wetheresfeld 1
4571424 2222649 2222649 defendant Richard John   650938 650938 Richard, John, of Wetheresfeld 1
4633183 2241247 2241247 defendant Maykyn John   650938 650938 Maykyn, John, of Wetheresfeld 2
4665240 2250617 2250617 defendant Parker John, junior potter 650938 650938 Parker, John, junior, of Wetheresfeld, potter 3
4665298 2250636 2250636 defendant Hierde John yeoman 650938 650938 Hierde, John, of Wetheresfeld, yeoman 0
4677841 2258685 2258685 defendant Howe John tilemaker 650938 650938 Howe, John, of Wetheresfeld, tilemaker 1
4677842 2258685 2258685 defendant Pottere John   650938 650938 Pottere, John, of Wetheresfeld, nail maker 2
4717795 2270906 2270906 defendant Joye William yeoman 650938 650938 Joye, William, of Wetheresfeld, yeoman 0
4725886 2273385 2273385 defendant Cook Roger husbandman 650938 650938 Cook, Roger, of Wetheresfeld, husbandman 0
4734093 2275846 2275846 defendant Fletther John husbandman 650938 650938 Fletther, John, of Wetheresfeld, husbandman 0
4737514 2276846 2276846 defendant Howe John husbandman 650938 650938 Howe, John, of Wetheresfeld, husbandman 1
4738578 2277155 2277155 defendant Cook William butcher 650938 650938 Cook, William, of Wetheresfeld, butcher 1
4748055 2279943 2279943 defendant Warde John yeoman 650938 650938 Warde, John, of Wetheresfeld, yeoman 1
4757156 2282607 2282607 plaintiff Bontemps William   650938 650938 Bontemps, William, of Wetheresfeld, parson 0
4757159 2282607 2282607 defendant Bocher William butcher 650938 650938 Bocher, William, of Wetheresfeld, butcher 2
4758016 2282881 2282881 defendant Shelford John yeoman 650938 650938 Shelford, John, of Wetheresfeld, yeoman 2
4767149 2285711 2285711 defendant Warde John husbandman 650938 650938 Warde, John, of Wetheresfeld, husbandman 0
4779326 2289516 2289516 defendant Warde John husbandman 650938 650938 Warde, John, of Wetheresfeld, husbandman 1
4788632 2292500 2292500 defendant Aleyn John   650938 650938 Aleyn, John, of Wetheresfeld, wheelwright 2
4792393 2293708 2293708 defendant Warde John yeoman 650938 650938 Warde, John, of Wetheresfeld, yeoman 0
4801576 2296676 2296676 plaintiff Wright John   650938 650938 Wright, John, of Wetheresfeld 0
4801577 2296676 2296676 defendant Prill Reginald potter 650938 650938 Prill, Reginald, of Wetheresfeld, potter 0
4832466 2306187 2306187 defendant Parker William potter 650938 650938 Parker, William, of Wetheresfeld, potter 0
4832467 2306187 2306187 defendant Stamer John   650938 650938 Stamer, John, of Wetheresfeld, "harman" or hairman 1
4907755 2328987 2328987 defendant Bocher William butcher 650938 650938 Bocher, William, of Wetheresfeld, butcher 2
4913164 2330614 2330614 defendant Shelford John, senior yeoman 650938 650938 Shelford, John, senior, of Wetheresfeld, yeoman 0
4913165 2330614 2330614 defendant Shelford John, junior milner 650938 650938 Shelford, John, junior, of Wetheresfeld, milner 1
4955534 2343615 2343615 defendant Garnon Thomas husbandman 650938 650938 Garnon, Thomas, of Wetheresfeld, husbandman 1
4987354 2353167 2353167 defendant Wotton John butcher 650938 650938 Wotton, John, of Wetheresfeld, butcher 1
5106199 2388250 2388250 defendant Levermer Thomas potter 650938 650938 Levermer, Thomas, of Wetheresfeld, potter 0
5106201 2388251 2388251 defendant Lovelond Thomas carpenter 650938 650938 Lovelond, Thomas, of Wetheresfeld, carpenter 0
5106202 2388251 2388251 defendant Curteys John husbandman 650938 650938 Curteys, John, of Wetheresfeld, husbandman 1
5151245 2401510 2401510 defendant atte Well John husbandman 650938 650938 atte Well, John, of Wetheresfeld, husbandman 0
5151249 2401511 2401511 defendant Hayll John husbandman 650938 650938 Hayll, John, of Wetheresfeld, husbandman 1
5186234 2411724 2411724 defendant atte Well John husbandman 650938 650938 atte Well, John, of Wetheresfeld, husbandman 0
5186238 2411725 2411725 defendant Haill John husbandman 650938 650938 Haill, John, of Wetheresfeld, husbandman 1
5215976 2420400 2420400 defendant Cosyn Robert yeoman 650938 650938 Cosyn, Robert, of Wetheresfeld, yeoman 0
5234583 2425700 2425700 defendant Walaker John potter 650938 650938 Walaker, John, of Wetheresfeld, potter 0
5427161 2483064 2483064 defendant Sa_ John yeoman 650938 650938 Sa_, John, of Wetheresfeld, yeoman 0
5445008 2488393 2488393 defendant Saman John   650938 650938 Saman, John, of Wetheresfeld 0
5480791 2499213 2499213 defendant Saman John yeoman 650938 650938 Saman, John, of Wetheresfeld, yeoman 0
5480792 2499213 2499213 defendant Walakere John yeoman 650938 650938 Walakere, John, of Wetheresfeld, yeoman 1
5489814 2501835 2501835 defendant Passefeld John husbandman 650938 650938 Passefeld, John, of Wetheresfeld, husbandman 2
5513504 2509070 2509070 defendant Skot Thomas carpenter 650938 650938 Skot, Thomas, of Wetheresfeld, carpenter 0
5624566 2551624 2551624 defendant Spays Ralph chapman 650938 650938 Spays, Ralph, of Wetheresfeld, chapman 0
5624571 2551624 2551624 defendant W- John yeoman 650938 650938 W-, John, of Wetheresfeld, yeoman 5

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