names

46 rows where place_id = 610621

✎ 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
3684420 1921259 1921259 defendant Marsshall Robert yeoman 610621 610621 Marsshall, Robert, of Cryche, yeoman 0
3685276 1921550 1921550 defendant Worth Richard yeoman 610621 610621 Worth, Richard, of Cryche, yeoman 0
3685277 1921550 1921550 defendant Woode Thomas laborer 610621 610621 Woode, Thomas, of Cryche, laborer 1
3685278 1921550 1921550 defendant Woode William laborer 610621 610621 Woode, William, of Cryche, laborer 2
3771115 1948656 1948656 defendant Gale John husbandman 610621 610621 Gale, John, of Cryche, husbandman 0
3827213 1966376 1966376 defendant Symonds Richard husbandman 610621 610621 Symonds, Richard, of Cryche, husbandman 0
4002177 2025565 2025565 plaintiff Haylay Christopher yeoman 610621 610621 Haylay, Christopher, of Cryche, yeoman 0
4044203 2040379 2040379 defendant Yardley Thomas yeoman 610621 610621 Yardley, Thomas, of Cryche, yeoman 0
4064387 2047540 2047540 defendant Phillippe John husbandman 610621 610621 Phillippe, John, of Cryche, husbandman 1
4069576 2049400 2049400 defendant Nurton John husbandman 610621 610621 Nurton, John, of Cryche, or of Hame, husbandman 1
4149243 2077861 2077861 defendant Ludlam Roger   610621 610621 Ludlam, Roger, of Cryche 3
4158010 2080873 2080873 defendant Kirklande John husbandman 610621 610621 Kirklande, John, of Cryche, husbandman 0
4164695 2083161 2083161 defendant Wolland Thomas smelter 610621 610621 Wolland, Thomas, of Cryche, smelter 0
4205400 2097441 2097441 defendant Kyrkeland John husbandman 610621 610621 Kyrkeland, John, of Cryche, husbandman 0
4231976 2106684 2106684 defendant Hellowe or Heylowe Christopher yeoman 610621 610621 Hellowe or Heylowe, Christopher, of Cryche, yeoman 0
4292111 2127251 2127251 defendant Bowman Robert laborer 610621 610621 Bowman, Robert, of Cryche, laborer 0
4292115 2127252 2127252 defendant Hopkyn Thomas laborer 610621 610621 Hopkyn, Thomas, of Cryche, laborer 0
4309473 2133475 2133475 defendant Bridge William husbandman 610621 610621 Bridge, William, of Cryche, husbandman 1
4310243 2133737 2133737 defendant Deane John yeoman 610621 610621 Deane, John, of Cryche, yeoman 1
4311597 2134198 2134198 defendant Radforthe George   610621 610621 Radforthe, George, of Cryche, yeoman, son of Thurstan Radforthe, of Frytheley 0
4412334 2168713 2168713 defendant Fowler Robert chapman 610621 610621 Fowler, Robert, of Cryche, chapman 2
4472367 2192027 2192027 defendant Dyer William   610621 610621 Dyer, William, of Cryche 0
4481950 2195061 2195061 defendant Northmore William   610621 610621 Northmore, William, of Cryche 3
4556985 2218115 2218115 defendant Strete John   610621 610621 Strete, John, of Cryche 0
4612360 2234936 2234936 defendant Selcombe John   610621 610621 Selcombe, John, of Cryche 1
4671505 2256733 2256733 defendant Smyth John farmer 610621 610621 Smyth, John, of Cryche, farmer 0
4748425 2280044 2280044 defendant Smyth John smith 610621 610621 Smyth, John, of Cryche, smith 3
4820893 2302623 2302623 defendant Stonehewer William laborer 610621 610621 Stonehewer, William, of Cryche, laborer 0
4822610 2303148 2303148 defendant Cary John husbandman 610621 610621 Cary, John, of Cryche, husbandman 0
4853806 2312602 2312602 defendant Broke John husbandman 610621 610621 Broke, John, of Cryche, husbandman 0
4853808 2312602 2312602 defendant Bocher John husbandman 610621 610621 Bocher, John, of Cryche, husbandman 2
4861113 2314835 2314835 plaintiff Cook William   610621 610621 Cook, William, of Cryche 0
4879433 2320498 2320498 defendant Thakker Robert husbandman 610621 610621 Thakker, Robert, of Cryche, husbandman 1
5002425 2357619 2357619 defendant Blount John laborer 610621 610621 Blount, John, of Cryche, laborer 0
5002427 2357620 2357620 defendant Dyche John laborer 610621 610621 Dyche, John, of Cryche, laborer 0
5216447 2420540 2420540 defendant Turney John yeoman 610621 610621 Turney, John, of Cryche, yeoman 0
5236901 2426374 2426374 defendant Thakker John yeoman 610621 610621 Thakker, John, of Cryche, yeoman 0
5236903 2426374 2426374 defendant Strete John husbandman 610621 610621 Strete, John, of Cryche, husbandman 2
5236904 2426374 2426374 defendant Sanon Thomas husbandman 610621 610621 Sanon, Thomas, of Cryche, husbandman 3
5333524 2455099 2455099 defendant Couper Thomas chaplain 610621 610621 Couper, Thomas, of Cryche, chaplain 0
5355747 2461875 2461875 defendant Staley Roger husbandman 610621 610621 Staley, Roger, of Cryche, husbandman 3
5409577 2477830 2477830 defendant Pole Ralph gent 610621 610621 (Pole, Ralph, of Cryche, gent 1
5409578 2477830 2477830 defendant Pole Margaret widow 610621 610621 together with Pole, Margaret, of Cryche, widow 2
5423137 2481880 2481880 defendant Pole Thomas (legal representative) 610621 610621 Pole, Thomas, of Cryche, executors of 0
5481534 2499405 2499405 defendant Vernay John esq 610621 610621 Vernay, John, of Cryche, esq 0
5543137 2517971 2517971 defendant Spencer William laborer 610621 610621 Spencer, William, of Cryche, laborer 6

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