names

55 rows where place_id = 591078

✎ 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
3603266 1868693 1868693 plaintiff Dade Thomas yeoman 591078 591078 Dade, Thomas, of Weybrede, yeoman 0
3603268 1868694 1868694 plaintiff Dade Thomas yeoman 591078 591078 Dade, Thomas, of Weybrede, yeoman 0
3603270 1868695 1868695 plaintiff Dade Thomas yeoman 591078 591078 Dade, Thomas, of Weybrede, yeoman 0
3697877 1925557 1925557 defendant Calle John gent 591078 591078 Calle, John, of Weybrede, gent 0
3783909 1952742 1952742 plaintiff Mene Thomas   591078 591078 Mene, Thomas, of Weybrede 2
3801137 1958276 1958276 plaintiff Mene William (legal representative) 591078 591078 Mene, William, of Weybrede, draper, executors of 0
3801138 1958276 1958276 plaintiff Mene Thomas   591078 591078 (Mene, Thomas, of Weybrede 1
3818644 1963735 1963735 plaintiff Mene William (legal representative) 591078 591078 Mene, William, of Weybrede, draper, executors of 0
3818645 1963735 1963735 plaintiff Mene Thomas   591078 591078 (Mene, Thomas, of Weybrede 1
3850208 1973658 1973658 defendant Butt John butcher 591078 591078 Butt, John, of Weybrede, butcher 0
3885842 1985520 1985520 defendant Meane Thomas husbandman 591078 591078 Meane, Thomas, of Weybrede, husbandman 0
3913284 1994774 1994774 defendant Hood Thomas potter 591078 591078 Hood, Thomas, of Weybrede, potter 0
3913285 1994774 1994774 defendant Hood John husbandman 591078 591078 Hood, John, of Weybrede, husbandman 1
4123972 2068871 2068871 defendant Meene Thomas yeoman 591078 591078 Meene, Thomas, of Weybrede, yeoman 0
4284115 2124363 2124363 defendant Meane Thomas yeoman 591078 591078 Meane, Thomas, of Weybrede, yeoman 0
4327451 2139503 2139503 defendant Legate Lawrence yeoman 591078 591078 Legate, Lawrence, of Weybrede, yeoman 1
4327452 2139503 2139503 defendant Meane Robert yeoman 591078 591078 Meane, Robert, of Weybrede, yeoman 2
4378072 2157224 2157224 defendant Goodram Thomas tanner 591078 591078 Goodram, Thomas, of Weybrede, tanner 0
4444694 2183319 2183319 defendant Osgot Henry   591078 591078 Osgot, Henry, of Weybrede 0
4556856 2218079 2218079 defendant Leman William   591078 591078 Leman, William, of Weybrede 0
4556858 2218080 2218080 defendant Leman William   591078 591078 Leman, William, of Weybrede 0
4598956 2230896 2230896 defendant Cobald Peter   591078 591078 Cobald, Peter, of Weybrede 0
4598957 2230896 2230896 defendant Rouk William   591078 591078 Rouk, William, of Weybrede 1
4630963 2240576 2240576 defendant Harre Alice   591078 591078 Harre, Alice, of Weybrede 0
4676878 2258387 2258387 defendant Leman Robert   591078 591078 Leman, Robert, of Weybrede, husbandman, son & heir of William 1
4676879 2258387 2258387 defendant Eppe Roger weaver 591078 591078 Eppe, Roger, of Weybrede, weaver 2
4680259 2259439 2259439 plaintiff Leman William (legal representative) 591078 591078 Leman, William, of Weybrede, executors of 0
4680260 2259439 2259439 plaintiff Popilton William   591078 591078 (Popilton, William, of Weybrede, vicar 1
4693021 2263327 2263327 plaintiff Ballard Walter   591078 591078 Ballard, Walter, of Weybrede 0
4725171 2273168 2273168 defendant Fuller Robert fuller 591078 591078 Fuller, Robert, of Weybrede, fuller 0
4826241 2304242 2304242 defendant Folkere Reginald   591078 591078 Folkere, Reginald, of Weybrede, y eoman 1
4827355 2304602 2304602 defendant Folkerede Reginald husbandman 591078 591078 Folkerede, Reginald, of Weybrede, husbandman 2
4827358 2304603 2304603 defendant Folkrede Reginald husbandman 591078 591078 (Folkrede, Reginald, of Weybrede, husbandman 1
4886173 2322536 2322536 defendant Eggefeld John miller 591078 591078 Eggefeld, John, of Weybrede, miller 0
4923543 2333797 2333797 defendant Launce William husbandman 591078 591078 Launce, William, of Weybrede, husbandman 1
4923546 2333797 2333797 defendant Folkrede Reginald yeoman 591078 591078 Folkrede, Reginald, of Weybrede, yeoman 4
4973872 2349145 2349145 defendant Mene Thomas husbandman 591078 591078 Mene, Thomas, of Weybrede, husbandman 0
4979923 2350952 2350952 defendant Mors John   591078 591078 Mors, John, of Weybrede, tile maker 1
5010375 2359902 2359902 defendant Godfrey John yeoman 591078 591078 Godfrey, John, of Weybrede, yeoman 2
5010376 2359902 2359902 defendant Heymer John miller 591078 591078 Heymer, John, of Weybrede, miller 3
5019536 2362599 2362599 defendant Godfrey John yeoman 591078 591078 Godfrey, John, of Weybrede, yeoman 0
5085527 2382157 2382157 defendant Folkrede John husbandman 591078 591078 Folkrede, John, of Weybrede, husbandman 2
5131633 2395733 2395733 defendant Harryes Robert husbandman 591078 591078 Harryes, Robert, of Weybrede, husbandman 0
5131634 2395733 2395733 defendant Ballard Robert husbandman 591078 591078 Ballard, Robert, of Weybrede, husbandman 1
5142517 2398939 2398939 defendant Grocok Paul yeoman 591078 591078 Grocok, Paul, of Weybrede, yeoman 0
5163875 2405169 2405169 defendant Grocok Paul yeoman 591078 591078 Grocok, Paul, of Weybrede, yeoman 0
5211461 2419086 2419086 defendant Grocok Paul yeoman 591078 591078 Grocok, Paul, of Weybrede, yeoman 0
5228008 2423803 2423803 defendant Drue Walter chaplain 591078 591078 Drue, Walter, of Weybrede, chaplain 0
5237836 2426650 2426650 defendant Scerfe Simon potter 591078 591078 Scerfe, Simon, of Weybrede, potter 1
5249632 2430011 2430011 defendant Dr- Walter chaplain 591078 591078 Dr-, Walter, of Weybrede, chaplain 0
5349173 2459868 2459868 defendant Chambre John yeoman 591078 591078 Chambre, John, of Weybrede, yeoman 4
5480363 2499108 2499108 plaintiff Dade Thomas   591078 591078 Dade, Thomas, of Weybrede 2
5517551 2510330 2510330 defendant Ballard Robert husbandman 591078 591078 Ballard, Robert, of Weybrede, husbandman 0
5553436 2521043 2521043 defendant Dade Thomas (legal representative) 591078 591078 Dade, Thomas, of Weybrede, yeoman, executor of 2
5608080 2537434 2537434 defendant Dade Nicholas clerk 591078 591078 Dade, Nicholas, of Weybrede, clerk 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);