names

47 rows where place_id = 603450

✎ 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
3654583 1911696 1911696 defendant Clare William husbandman 603450 603450 Clare, William, of Evedon, husbandman 1
3682491 1920627 1920627 defendant Harvy William gent 603450 603450 Harvy, William, of Evedon, gent 0
3766778 1947272 1947272 defendant Whyttyll Richard husbandman 603450 603450 Whyttyll, Richard, of Evedon, husbandman 0
3786186 1953472 1953472 defendant Pomfret William husbandman 603450 603450 Pomfret, William, of Evedon, husbandman 1
3786187 1953472 1953472 defendant Ingoldesby Bartholomew clerk 603450 603450 Ingoldesby, Bartholomew, of Evedon, clerk 2
3890888 1987218 1987218 plaintiff Jaye Henry (legal representative) 603450 603450 Jaye, Henry, of Evedon, executrix of 0
3890892 1987219 1987219 plaintiff Jaye Henry (legal representative) 603450 603450 Jaye, Henry, of Evedon, executrix of 0
4226969 2104906 2104906 defendant Gleane William clerk 603450 603450 Gleane, William, of Evedon, clerk 0
4254668 2114550 2114550 defendant Glen William clerk 603450 603450 Glen, William, of Evedon, clerk 0
4254669 2114550 2114550 defendant Mackender James laborer 603450 603450 Mackender, James, of Evedon, laborer 1
4254791 2114596 2114596 defendant Gleane or Gleave William clerk 603450 603450 Gleane or Gleave, William, of Evedon, clerk 0
4577075 2224340 2224340 defendant Evedon John de   603450 603450 Evedon, John de, of Evedon 1
4666678 2255298 2255298 defendant Lyncoln Richard de   603450 603450 Lyncoln, Richard de, of Evedon, parson 0
4705188 2266992 2266992 defendant Gelle Richard husbandman 603450 603450 Gelle, Richard, of Evedon, husbandman 0
4705302 2267031 2267031 plaintiff Evedon John   603450 603450 Evedon, John, of Evedon 2
4710130 2268521 2268521 plaintiff Evedon John   603450 603450 Evedon, John, of Evedon 2
4712460 2269212 2269212 defendant Profyt John husbandman 603450 603450 Profyt, John, of Evedon, husbandman 0
4712464 2269214 2269214 defendant Gell Richard husbandman 603450 603450 Gell, Richard, of Evedon, husbandman 0
4712583 2269254 2269254 defendant Danet Walter husbandman 603450 603450 Danet, Walter, of Evedon, husbandman 0
4712584 2269254 2269254 defendant Prophet John husbandman 603450 603450 Prophet, John, of Evedon, husbandman 1
4717154 2270693 2270693 defendant Profyt John husbandman 603450 603450 Profyt, John, of Evedon, husbandman 0
4727715 2273911 2273911 defendant Prophet John husbandman 603450 603450 Prophet, John, of Evedon, husbandman 0
4732993 2275498 2275498 defendant Profet John husbandman 603450 603450 Profet, John, of Evedon, husbandman 0
4747039 2279638 2279638 defendant Storour John clerk & parson 603450 603450 Storour, John, of Evedon, clerk & parson 0
4806465 2298233 2298233 defendant Gelle Richard husbandman 603450 603450 Gelle, Richard, of Evedon, husbandman 0
4808622 2298861 2298861 plaintiff Cusson John   603450 603450 Cusson, John, of Evedon 0
4808623 2298861 2298861 defendant Smyth Robert   603450 603450 Smyth, Robert, of Evedon, "olyer" 0
4808624 2298861 2298861 defendant Gandowe Richard husbandman 603450 603450 Gandowe, Richard, of Evedon, husbandman 1
4808625 2298861 2298861 defendant Smyth Thomas   603450 603450 Smyth, Thomas, of Evedon, "olyer" 2
4813457 2300322 2300322 defendant Danet Walter yeoman 603450 603450 Danet, Walter, of Evedon, yeoman 0
4813459 2300322 2300322 defendant Yerburgh John milner 603450 603450 Yerburgh, John, of Evedon, milner 2
4816864 2301378 2301378 defendant Gelle Richard husbandman 603450 603450 Gelle, Richard, of Evedon, husbandman 0
4819436 2302155 2302155 defendant Danet Walter husbandman 603450 603450 Danet, Walter, of Evedon, husbandman 0
4822481 2303104 2303104 defendant Gelle Richard husbandman 603450 603450 Gelle, Richard, of Evedon, husbandman 0
4832723 2306256 2306256 defendant Golle Richard husbandman 603450 603450 Golle, Richard, of Evedon, husbandman 0
4832724 2306256 2306256 defendant Potter John husbandman 603450 603450 Potter, John, of Evedon, husbandman 1
4837638 2307703 2307703 defendant Barker Henry husbandman 603450 603450 Barker, Henry, of Evedon, husbandman 1
4863519 2315559 2315559 defendant Pottere John yeoman 603450 603450 Pottere, John, of Evedon, yeoman 0
4863833 2315661 2315661 defendant Potter John husbandman 603450 603450 Potter, John, of Evedon, husbandman 0
4917202 2331886 2331886 defendant Belle Richard husbandman 603450 603450 Belle, Richard, of Evedon, husbandman 0
4917203 2331886 2331886 defendant Gelle Thomas yeoman 603450 603450 Gelle, Thomas, of Evedon, yeoman 1
4923506 2333785 2333785 defendant Potter John husbandman 603450 603450 Potter, John, of Evedon, husbandman 0
4994570 2355238 2355238 defendant Gelle Richard husbandman 603450 603450 Gelle, Richard, of Evedon, husbandman 3
5045617 2370322 2370322 defendant Gelle Richard husbandman 603450 603450 Gelle, Richard, of Evedon, husbandman 0
5053172 2372546 2372546 plaintiff Bailly alias Adams Richard husbandman 603450 603450 Bailly alias Adams, Richard, of Evedon, husbandman 0
5592373 2532602 2532602 plaintiff Wasse Robert (legal representative) 603450 603450 Wasse, Robert, of Evedon, husbandman, executors of 0
5631717 2553934 2553934 defendant Talyour Simon husbandman 603450 603450 Talyour, Simon, of Evedon, 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);