names

63 rows where place_id = 600854

✎ 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
3642843 1908211 1908211 plaintiff Clyderhowe Hugh clerk 600854 600854 Clyderhowe, Hugh, of Brantyngham, clerk 0
3642848 1908212 1908212 plaintiff Clyderhowe Hugh clerk 600854 600854 Clyderhowe, Hugh, of Brantyngham, clerk 0
3696999 1925288 1925288 defendant Yong John husbandman 600854 600854 Yong, John, of Brantyngham, husbandman 0
3697000 1925288 1925288 defendant Wodeley Robert husbandman 600854 600854 Wodeley, Robert, of Brantyngham, husbandman 1
3697001 1925288 1925288 defendant Wodmancy William husbandman 600854 600854 Wodmancy, William, of Brantyngham, husbandman 2
3697002 1925288 1925288 defendant Yong Peter husbandman 600854 600854 Yong, Peter, of Brantyngham, husbandman 3
3697003 1925288 1925288 defendant Wodmancy Thomas husbandman 600854 600854 Wodmancy, Thomas, of Brantyngham, husbandman 4
3731788 1936173 1936173 plaintiff Clederhowe Hugh clerk 600854 600854 Clederhowe, Hugh, of Brantyngham, clerk 0
3731867 1936198 1936198 plaintiff Cliderhowe Hugh clerk 600854 600854 Cliderhowe, Hugh, of Brantyngham, clerk 0
3753443 1943016 1943016 defendant Skelton Robert yeoman 600854 600854 Skelton, Robert, of Brantyngham, yeoman 0
3753444 1943016 1943016 defendant Yong John, senior husbandman 600854 600854 Yong, John, senior, of Brantyngham, husbandman 1
3753446 1943017 1943017 defendant Holand William laborer 600854 600854 Holand, William, of Brantyngham, laborer 0
3753447 1943017 1943017 defendant Cok Brian laborer 600854 600854 Cok, Brian, of Brantyngham, laborer 1
3753448 1943017 1943017 defendant Rypplyngham Thomas husbandman 600854 600854 Rypplyngham, Thomas, of Brantyngham, husbandman 2
3753449 1943017 1943017 defendant Yong John husbandman 600854 600854 Yong, John, of Brantyngham, husbandman 3
3755474 1943664 1943664 defendant Wodmancy Joan widow 600854 600854 Wodmancy, Joan, of Brantyngham, widow 0
3770477 1948448 1948448 defendant Yong John, senior husbandman 600854 600854 Yong, John, senior, of Brantyngham, husbandman 0
3770478 1948448 1948448 defendant Skelton Robert yeoman 600854 600854 Skelton, Robert, of Brantyngham, yeoman 1
3773297 1949357 1949357 defendant Wodmancye Joan widow 600854 600854 Wodmancye, Joan, of Brantyngham, widow 0
3794782 1956244 1956244 plaintiff Cliderowe Hugh (legal representative) 600854 600854 Cliderowe, Hugh, of Brantyngham, clerk, executors of 0
3794789 1956245 1956245 plaintiff Cliderowe Hugh (legal representative) 600854 600854 Cliderowe, Hugh, of Brantyngham, clerk, executors of 0
3805514 1959664 1959664 defendant Jenyson Thomas clerk 600854 600854 Jenyson, Thomas, of Brantyngham, clerk 0
3882626 1984453 1984453 defendant Clidero Hugh gent 600854 600854 Clidero, Hugh, of Brantyngham, gent 0
4030301 2035491 2035491 defendant Sylversyd Ralph yeoman 600854 600854 Sylversyd, Ralph, of Brantyngham, yeoman 1
4109058 2063494 2063494 defendant Dane Robert clerk 600854 600854 Dane, Robert, of Brantyngham, clerk 0
4191200 2092488 2092488 defendant Jobson Walter gent 600854 600854 Jobson, Walter, of Brantyngham, gent 0
4429128 2173920 2173920 plaintiff Turvill Ralph (legal representative) 600854 600854 Turvill, Ralph, of Brantyngham, parson, executors of 0
4443295 2182865 2182865 plaintiff Cart William   600854 600854 Cart, William, of Brantyngham, son of John 0
4457484 2187354 2187354 plaintiff Personesman John   600854 600854 Personesman, John, of Brantyngham 0
4461966 2188802 2188802 plaintiff Strode William   600854 600854 Strode, William, of Brantyngham, parson 0
4461968 2188803 2188803 plaintiff Strode William   600854 600854 Strode, William, of Brantyngham, parson 0
4461970 2188804 2188804 plaintiff Strode William   600854 600854 Strode, William, of Brantyngham, parson 0
4461972 2188805 2188805 plaintiff Strode William   600854 600854 Strode, William, of Brantyngham, parson 0
4487259 2196732 2196732 plaintiff Sigestone John   600854 600854 Sigestone, John, of Brantyngham, parson 0
4592892 2229104 2229104 defendant Williamson John   600854 600854 Williamson, John, of Brantyngham 0
4648470 2245601 2245601 plaintiff Sutton Thomas clerk & parson 600854 600854 Sutton, Thomas, of Brantyngham, clerk & parson 0
4648472 2245602 2245602 plaintiff Sutton Thomas clerk & parson of the church 600854 600854 Sutton, Thomas, of Brantyngham, clerk & parson of the church 0
4648474 2245603 2245603 plaintiff Sutton Thomas   600854 600854 Sutton, Thomas, of Brantyngham, parson 0
4648476 2245604 2245604 plaintiff Sutton Thomas   600854 600854 Sutton, Thomas, of Brantyngham, parson of the parish church 0
4648480 2245605 2245605 plaintiff Sutton Thomas   600854 600854 Sutton, Thomas, of Brantyngham, parson of the parish church 0
4687958 2261802 2261802 plaintiff Sutton Thomas   600854 600854 Sutton, Thomas, of Brantyngham, parson 0
4713597 2269575 2269575 plaintiff Sutton Thomas   600854 600854 Sutton, Thomas, of Brantyngham, parson of the church 0
4752272 2281130 2281130 plaintiff (not given) Thomas prior of Sutton 600854 600854 Sutton, Thomas, of Brantyngham, parson & prior of Durham, executors of 0
4752283 2281131 2281131 plaintiff Sutton Thomas (legal representative) 600854 600854 Sutton, Thomas, of Brantyngham, parson, executors of 0
4862624 2315297 2315297 defendant Ashton William husbandman 600854 600854 Ashton, William, of Brantyngham, husbandman 0
4868389 2317084 2317084 defendant Yonge Richard chaplain 600854 600854 Yonge, Richard, of Brantyngham, chaplain 0
4882063 2321286 2321286 defendant Barbour John laborer 600854 600854 Barbour, John, of Brantyngham, laborer 0
4882064 2321286 2321286 defendant Aston William husbandman 600854 600854 Aston, William, of Brantyngham, husbandman 1
4926588 2334733 2334733 defendant Barbour John husbandman 600854 600854 Barbour, John, of Brantyngham, husbandman 0
5018895 2362414 2362414 defendant Welles William husbandman 600854 600854 Welles, William, of Brantyngham, husbandman 0
5105289 2387990 2387990 defendant Cosyn George yeoman 600854 600854 Cosyn, George, of Brantyngham, yeoman 0
5200929 2416038 2416038 defendant Sclater Thomas husbandman 600854 600854 Sclater, Thomas, of Brantyngham, husbandman 2
5200930 2416038 2416038 defendant Clerk John husbandman 600854 600854 Clerk, John, of Brantyngham, husbandman 3
5233770 2425464 2425464 defendant Cosyn George husbandman 600854 600854 Cosyn, George, of Brantyngham, husbandman 0
5289039 2441804 2441804 defendant Cliderowe Hugh gent 600854 600854 Cliderowe, Hugh, of Brantyngham, gent 1
5289040 2441804 2441804 defendant Wodmanse Henry husbandman 600854 600854 Wodmanse, Henry, of Brantyngham, husbandman 2
5292279 2442745 2442745 defendant Riplyngham Richard yeoman 600854 600854 Riplyngham, Richard, of Brantyngham, yeoman 0
5296174 2443872 2443872 defendant Clidrowe Hugh merchant 600854 600854 Clidrowe, Hugh, of Brantyngham, merchant 0
5301808 2445497 2445497 defendant Ripplyngham Robert husbandman 600854 600854 Ripplyngham, Robert, of Brantyngham, husbandman 1
5357498 2462411 2462411 defendant Clyderhowe Hugh gent, son of Clyderhowe Hugh, of Kyngeston on Hull, merchant 600854 600854 Clyderhowe Hugh, of Brantyngham, gent, son of Clyderhowe Hugh, of Kyngeston on Hull, merchant 0
5357500 2462412 2462412 defendant Clyderhowe Hugh merchant 600854 600854 Clyderhowe, Hugh, of Brantyngham, gent, son of Clyderhowe, Hugh, of Kyngeston on Hull, merchant 0
5608187 2537463 2537463 defendant Yong John, senior husbandman 600854 600854 Yong, John, senior, of Brantyngham, husbandman 0
5608188 2537463 2537463 defendant Yong John, junior laborer 600854 600854 Yong, John, junior, of Brantyngham, laborer 1

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