names

40 rows where place_id = 594686

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617171 1872995 1872995 defendant Bisshop James chaplain 594686 594686 Bisshop, James, of Frethorp, chaplain 2
3649872 1910323 1910323 defendant Ferman Robert yeoman 594686 594686 Ferman, Robert, of Frethorp, yeoman 0
3702479 1927039 1927039 defendant Perry John miller 594686 594686 Perry, John, of Frethorp, miller 0
3739358 1938516 1938516 defendant Kyppyng Robert husbandman 594686 594686 Kyppyng, Robert, of Frethorp, husbandman 0
3914439 1995174 1995174 defendant Armyder Thomas husbandman 594686 594686 Armyder, Thomas, of Frethorp, husbandman 0
4122152 2068227 2068227 defendant Kyppyn John, senior husbandman 594686 594686 Kyppyn, John, senior, of Frethorp, husbandman 0
4122154 2068228 2068228 defendant Richeman Francis clerk 594686 594686 Richeman, Francis, of Frethorp, clerk 0
4158559 2081065 2081065 defendant Bull Christopher yeoman 594686 594686 Bull, Christopher, of Frethorp, yeoman 1
4258085 2115675 2115675 defendant Sayer Thomas yeoman 594686 594686 Sayer, Thomas, of Frethorp, yeoman 0
4471042 2191600 2191600 defendant Moom John   594686 594686 Moom, John, of Frethorp 0
4541972 2213381 2213381 defendant Hale Warren   594686 594686 Hale, Warren, of Frethorp 0
4618313 2236737 2236737 defendant atte Welle John   594686 594686 atte Welle, John, of Frethorp, son of William 3
4669608 2256205 2256205 defendant Moine Edmund   594686 594686 Moine, Edmund, of Frethorp, vicar 0
4748196 2279981 2279981 defendant Smyth William   594686 594686 Smyth, William, of Frethorp, vicar 4
4753294 2281411 2281411 defendant Smyth Thomas   594686 594686 Smyth, Thomas, of Frethorp, vicar 0
4760964 2283772 2283772 defendant Dennys John (legal representative) 594686 594686 Dennys, John, of Frethorp, vicar, administrator of 0
4783154 2290746 2290746 defendant Smyth William clerk 594686 594686 Smyth, William, of Frethorp, clerk 1
4800771 2296428 2296428 defendant Couper William husbandman 594686 594686 Couper, William, of Frethorp, husbandman 1
4882323 2321381 2321381 defendant Pye Edmund smith 594686 594686 Pye, Edmund, of Frethorp, smith 1
4900083 2326657 2326657 defendant Lyghtfote William husbandman 594686 594686 Lyghtfote, William, of Frethorp, husbandman 0
4928971 2335487 2335487 defendant Pratte Henry husbandman 594686 594686 Pratte, Henry, of Frethorp, husbandman 1
4939276 2338668 2338668 defendant Berton Thomas husbandman 594686 594686 Berton, Thomas, of Frethorp, husbandman 0
4952795 2342792 2342792 defendant Berton Thomas yeoman 594686 594686 Berton, Thomas, of Frethorp, yeoman 3
4987109 2353091 2353091 defendant atte Welle William husbandman 594686 594686 atte Welle, William, of Frethorp, husbandman 2
5030379 2365757 2365757 defendant Stevenes Stephen husbandman 594686 594686 Stevenes, Stephen, of Frethorp, husbandman 3
5035802 2367327 2367327 defendant Berton Thomas butcher 594686 594686 Berton, Thomas, of Frethorp, butcher 4
5046530 2370602 2370602 defendant Pye Edmund smith 594686 594686 Pye, Edmund, of Frethorp, smith 0
5046531 2370602 2370602 defendant Hampton John husbandman 594686 594686 Hampton, John, of Frethorp, husbandman 1
5072550 2378277 2378277 defendant Prat Henry husbandman 594686 594686 Prat, Henry, of Frethorp, husbandman 0
5072552 2378277 2378277 defendant Pye John laborer 594686 594686 Pye, John, of Frethorp, laborer 2
5099185 2386186 2386186 plaintiff Wellys William   594686 594686 Wellys, William, of Frethorp 0
5230302 2424481 2424481 defendant Pratte Henry yeoman 594686 594686 Pratte, Henry, of Frethorp, yeoman 1
5233683 2425438 2425438 defendant Pratte Henry husbandman 594686 594686 Pratte, Henry, of Frethorp, husbandman 2
5240009 2427278 2427278 defendant Pratte Henry yeoman 594686 594686 Pratte, Henry, of Frethorp, yeoman 0
5303230 2445959 2445959 defendant Pratte Henry husbandman 594686 594686 (Pratte, Henry, of Frethorp, husbandman 3
5329542 2453901 2453901 defendant Davy John husbandman 594686 594686 Davy, John, of Frethorp, husbandman 0
5331825 2454598 2454598 defendant Pratte Henry yeoman 594686 594686 Pratte, Henry, of Frethorp, yeoman 0
5460464 2493072 2493072 defendant Wyborn John chapman 594686 594686 Wyborn, John, of Frethorp, chapman 0
5465937 2494739 2494739 defendant Wyborn John chapman 594686 594686 Wyborn, John, of Frethorp, chapman 0
5559807 2522826 2522826 defendant Hampton Henry husbandman 594686 594686 Hampton, Henry, of Frethorp, 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);