names

44 rows where place_id = 767285

✎ 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
4537647 2212046 2212046 defendant Page Richard   767285 767285 Page, Richard, of Bekkele 1
4599740 2231139 2231139 plaintiff Symond John chaplain 767285 767285 Symond, John, of Bekkele, chaplain 0
4599743 2231139 2231139 defendant Wodeland John   767285 767285 Wodeland, John, of Bekkele 2
4607201 2233367 2233367 defendant Ludeleghe John   767285 767285 Ludeleghe, John, of Bekkele 0
4619079 2236962 2236962 plaintiff Hert Thomas   767285 767285 Hert, Thomas, of Bekkele 0
4625154 2238832 2238832 defendant Bysshop Simon   767285 767285 Bysshop, Simon, of Bekkele 4
4628116 2239722 2239722 defendant Huchon Richard   767285 767285 Huchon, Richard, of Bekkele 1
4636704 2242300 2242300 defendant Erl William   767285 767285 Erl, William, of Bekkele 2
4642859 2244021 2244021 defendant Bixle Ralph   767285 767285 Bixle, Ralph, of Bekkele, administrators of 0
4642860 2244021 2244021 defendant Bixle Joan   767285 767285 Bixle, Joan, of Bekkele, formerly wife of Ralph 1
4644629 2244518 2244518 defendant Huchon Richard   767285 767285 Huchon, Richard, of Bekkele 3
4645792 2244836 2244836 defendant Clerk William   767285 767285 Clerk, William, of Bekkele 0
4647198 2245234 2245234 defendant Bysshop Simon   767285 767285 Bysshop, Simon, of Bekkele 2
4666353 2250951 2250951 defendant Howchon Richard draper 767285 767285 Howchon, Richard, of Bekkele, draper 1
4669990 2256313 2256313 defendant Brodeney Stephen laborer 767285 767285 Brodeney, Stephen, of Bekkele, laborer 0
4682998 2260297 2260297 defendant Knell John laborer 767285 767285 Knell, John, of Bekkele, laborer 0
4682999 2260297 2260297 defendant Filip Thomas yeoman 767285 767285 Filip, Thomas, of Bekkele, yeoman 1
4683000 2260297 2260297 defendant Derham John laborer 767285 767285 Derham, John, of Bekkele, laborer 2
4683001 2260297 2260297 defendant Body Edmund laborer 767285 767285 Body, Edmund, of Bekkele, laborer 3
4683002 2260298 2260298 plaintiff Oxenbregge Thomas (legal representative) 767285 767285 Oxenbregge, Thomas, of Bekkele, administrator of 0
4690083 2262451 2262451 defendant Watte Stephen husbandman 767285 767285 Watte, Stephen, of Bekkele, husbandman 0
4697618 2264743 2264743 defendant Watte Stephen laborer 767285 767285 Watte, Stephen, of Bekkele, laborer 0
4706913 2267542 2267542 defendant Belsherst Richard husbandman 767285 767285 Belsherst, Richard, of Bekkele, husbandman 0
4708859 2268140 2268140 plaintiff Oxenbregge Thomas   767285 767285 Oxenbregge, Thomas, of Bekkele, adminisrator of 0
4730527 2274747 2274747 defendant atte Gate Simon husbandman 767285 767285 atte Gate, Simon, of Bekkele, husbandman 0
4732270 2275272 2275272 defendant Gogelere Isolda   767285 767285 Gogelere, Isolda, of Bekkele, servant 0
4769061 2286303 2286303 defendant Watte Simon laborer 767285 767285 Watte, Simon, of Bekkele, laborer 0
4774844 2288125 2288125 defendant Watte Simon husbandman 767285 767285 Watte, Simon, of Bekkele, husbandman 0
4781545 2290238 2290238 defendant Ludlegh John husbandman 767285 767285 Ludlegh, John, of Bekkele, husbandman 0
4793609 2294113 2294113 defendant Watte Simon laborer 767285 767285 Watte, Simon, of Bekkele, laborer 0
4800624 2296374 2296374 defendant Watte Simon husbandman 767285 767285 Watte, Simon, of Bekkele, husbandman 0
4869070 2317298 2317298 defendant Creche alias Brice Richard husbandman 767285 767285 Creche alias Brice, Richard, of Bekkele, husbandman 0
4941139 2339251 2339251 defendant Brednex John yeoman 767285 767285 Brednex, John, of Bekkele, yeoman 0
5103108 2387332 2387332 defendant Selawe John husbandman 767285 767285 Selawe, John, of Bekkele, husbandman 4
5229498 2424242 2424242 defendant Boteler Robert husbandman 767285 767285 Boteler, Robert, of Bekkele, husbandman 0
5625662 2551969 2551969 defendant atte Gate Simon husbandman 767285 767285 atte Gate, Simon, of Bekkele, husbandman 0
5625666 2551970 2551970 defendant atte Gate Simon husbandman 767285 767285 atte Gate, Simon, of Bekkele, husbandman 0
5627582 2552598 2552598 defendant Cheseman Petronilla widow 767285 767285 (Cheseman, Petronilla, of Bekkele, widow 1
5627583 2552598 2552598 defendant Cheseman Alice widow 767285 767285 Cheseman, Alice, of Bekkele, widow 2
5627587 2552600 2552600 defendant Brodenex Stephen   767285 767285 Brodenex, Stephen, of Bekkele 0
5628021 2552734 2552734 defendant Chesman Robert husbandman 767285 767285 Chesman, Robert, of Bekkele, husbandman 1
5630400 2553518 2553518 defendant Wyndere William laborer 767285 767285 Wyndere, William, of Bekkele, laborer 0
5631416 2553829 2553829 plaintiff Smyth John   767285 767285 Smyth, John, of Bekkele 0
5631417 2553829 2553829 defendant Luddelegh John   767285 767285 Luddelegh, John, of Bekkele 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);