names

31 rows where place_id = 602467

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650292 1910468 1910468 defendant Vycary Robert husbandman 602467 602467 Vycary, Robert, of Tymbercombe, husbandman 0
3720642 1932743 1932743 defendant Codyng John smith 602467 602467 Codyng, John, of Tymbercombe, smith 0
3747976 1941285 1941285 defendant Franke Walter yeoman 602467 602467 Franke, Walter, of Tymbercombe, yeoman 0
3750252 1941996 1941996 defendant Hyll Richard husbandman 602467 602467 Hyll, Richard, of Tymbercombe, husbandman 1
3750253 1941996 1941996 defendant Grabbam Nicholas husbandman 602467 602467 Grabbam, Nicholas, of Tymbercombe, husbandman 2
3761951 1945745 1945745 defendant Franke Walter yeoman 602467 602467 Franke, Walter, of Tymbercombe, yeoman 0
3769912 1948247 1948247 defendant Elysworthy John yeoman 602467 602467 Elysworthy, John, of Tymbercombe, yeoman 0
3769913 1948247 1948247 defendant Elysworthy Richard husbandman 602467 602467 Elysworthy, Richard, of Tymbercombe, husbandman 1
4705372 2267052 2267052 defendant Cloutasham William gent 602467 602467 Cloutasham, William, of Tymbercombe, gent 1
4748130 2279965 2279965 defendant Cloutesham William gent 602467 602467 Cloutesham, William, of Tymbercombe, gent 0
4774747 2288093 2288093 defendant Cloutesham William gent 602467 602467 Cloutesham, William, of Tymbercombe, gent 1
4800501 2296338 2296338 defendant Cloutesham William gent 602467 602467 Cloutesham, William, of Tymbercombe, gent 1
4826185 2304224 2304224 defendant Clontesham William gent 602467 602467 Clontesham, William, of Tymbercombe, gent 1
4852367 2312161 2312161 defendant Cloutesham William gent 602467 602467 Cloutesham, William, of Tymbercombe, gent 1
4880191 2320716 2320716 defendant Cloutesham William gent 602467 602467 Cloutesham, William, of Tymbercombe, gent 1
4888029 2323060 2323060 defendant atte Yaa John clerk 602467 602467 atte Yaa, John, of Tymbercombe, clerk 0
5062664 2375391 2375391 defendant Cloutesham William gent 602467 602467 Cloutesham, William, of Tymbercombe, gent 1
5066620 2376542 2376542 defendant Cloutesham William gent 602467 602467 Cloutesham, William, of Tymbercombe, gent 1
5088911 2383133 2383133 defendant Smyth William smith 602467 602467 Smyth, William, of Tymbercombe, smith 0
5415524 2479583 2479583 defendant Holl William husbandman 602467 602467 Holl, William, of Tymbercombe, husbandman 1
5431864 2484497 2484497 defendant Aldercote Robert husbandman 602467 602467 Aldercote, Robert, of Tymbercombe, husbandman 0
5431865 2484497 2484497 defendant Holl William husbandman 602467 602467 Holl, William, of Tymbercombe, husbandman 1
5431867 2484498 2484498 defendant Aldercote Robert husbandman 602467 602467 Aldercote, Robert, of Tymbercombe, husbandman 0
5431868 2484498 2484498 defendant Holl William husbandman 602467 602467 Holl, William, of Tymbercombe, husbandman 1
5431870 2484499 2484499 defendant Aldercote Robert husbandman 602467 602467 Aldercote, Robert, of Tymbercombe, husbandman 0
5431871 2484499 2484499 defendant Holt William husbandman 602467 602467 Holt, William, of Tymbercombe, husbandman 1
5481396 2499373 2499373 defendant Lyddon John sherman 602467 602467 Lyddon, John, of Tymbercombe, sherman 0
5527466 2513172 2513172 defendant Blowedon John husbandman 602467 602467 Blowedon, John, of Tymbercombe, husbandman 2
5544375 2518349 2518349 defendant Stowey Thomas husbandman 602467 602467 Stowey, Thomas, of Tymbercombe, husbandman 0
5562828 2523717 2523717 defendant Jacob John gent 602467 602467 Jacob, John, of Tymbercombe, gent 0
5591820 2532425 2532425 defendant Hoper John husbandman 602467 602467 Hoper, John, of Tymbercombe, husbandman 3

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