names

57 rows where place_id = 586132

✎ 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
3588004 1863901 1863901 defendant Porter Thomas laborer 586132 586132 Porter, Thomas, of Thurton, laborer 1
3588005 1863901 1863901 defendant Porter John tailor 586132 586132 Porter, John, of Thurton, tailor 2
3682257 1920548 1920548 defendant Wolff Ralph husbandman 586132 586132 Wolff, Ralph, of Thurton, husbandman 1
3773335 1949373 1949373 defendant Somer John husbandman 586132 586132 Somer, John, of Thurton, husbandman 0
3773336 1949373 1949373 defendant Mores John husbandman 586132 586132 Mores, John, of Thurton, husbandman 1
3788477 1954199 1954199 defendant Somherd John   586132 586132 Somherd, John, of Thurton, minstrel 0
3796323 1956715 1956715 defendant Somersale John smith 586132 586132 Somersale, John, of Thurton, smith 0
3796717 1956860 1956860 defendant Somersale John smith 586132 586132 Somersale, John, of Thurton, smith 1
3811901 1961627 1961627 defendant Sponer Robert husbandman 586132 586132 Sponer, Robert, of Thurton, husbandman 0
3811904 1961627 1961627 defendant Barn Richard laborer 586132 586132 Barn, Richard, of Thurton, laborer 3
3961957 2011279 2011279 defendant Denny John husbandman 586132 586132 Denny, John, of Thurton, husbandman 0
3961959 2011280 2011280 defendant Denny John husbandman 586132 586132 Denny, John, of Thurton, husbandman 0
3979733 2017505 2017505 defendant Harwar John blacksmith 586132 586132 Harwar, John, of Thurton, blacksmith 0
4012546 2029212 2029212 plaintiff Randoll Nicholas   586132 586132 Randoll, Nicholas, of Thurton 0
4094110 2058223 2058223 defendant Goldsworth alias Porter Thomas husbandman 586132 586132 Goldsworth alias Porter, Thomas, of Thurton, husbandman 0
4214403 2100543 2100543 defendant Barker Henry husbandman 586132 586132 Barker, Henry, of Thurton, husbandman 3
4259601 2116188 2116188 defendant Spaule Robert yeoman 586132 586132 Spaule, Robert, of Thurton, yeoman 0
4395814 2163182 2163182 defendant Johnson Henry tailor 586132 586132 Johnson, Henry, of Thurton, tailor 0
4399736 2164499 2164499 defendant Nuddes George yeoman 586132 586132 Nuddes, George, of Thurton, yeoman 3
4486127 2196361 2196361 defendant Manghteld William   586132 586132 Manghteld, William, of Thurton 1
4595186 2229748 2229748 defendant Kyng William   586132 586132 Kyng, William, of Thurton 5
4595199 2229749 2229749 defendant Kyng William   586132 586132 Kyng, William, of Thurton 5
4631645 2240784 2240784 defendant Deynys William   586132 586132 Deynys, William, of Thurton 3
4656449 2247913 2247913 defendant Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 0
4679903 2259322 2259322 defendant Gildenwater Roger smith 586132 586132 Gildenwater, Roger, of Thurton, smith 4
4726291 2273507 2273507 defendant Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 0
4729612 2274474 2274474 defendant Turnour William yeoman 586132 586132 Turnour, William, of Thurton, yeoman 0
4735951 2276392 2276392 defendant Thurton William yeoman 586132 586132 Thurton, William, of Thurton, yeoman 3
4739341 2277392 2277392 defendant Parmonter Robert yeoman 586132 586132 Parmonter, Robert, of Thurton, yeoman 0
4739355 2277395 2277395 defendant Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 0
4741547 2278023 2278023 defendant Turnour Henry husbandman 586132 586132 Turnour, Henry, of Thurton, husbandman 1
4754413 2281760 2281760 defendant Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 1
4754417 2281761 2281761 defendant Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 1
4769002 2286282 2286282 defendant Turnour Henry husbandman 586132 586132 Turnour, Henry, of Thurton, husbandman 0
4792064 2293620 2293620 defendant Turnour Henry husbandman 586132 586132 Turnour, Henry, of Thurton, husbandman 0
4865324 2316126 2316126 defendant Feraunt Lawrence yeoman 586132 586132 Feraunt, Lawrence, of Thurton, yeoman 0
4930339 2335889 2335889 plaintiff Thurton William   586132 586132 Thurton, William, of Thurton 0
4955358 2343558 2343558 defendant Hyckys Henry yeoman 586132 586132 Hyckys, Henry, of Thurton, yeoman 1
4957010 2344055 2344055 defendant Thurton John   586132 586132 Thurton, John, of Thurton, gent, son of William 0
4957011 2344055 2344055 defendant Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 1
4982235 2351605 2351605 plaintiff Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 0
4982237 2351606 2351606 plaintiff Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 0
4982241 2351607 2351607 plaintiff Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 0
5012271 2360441 2360441 defendant Deynes Roger yeoman 586132 586132 Deynes, Roger, of Thurton, yeoman 0
5040027 2368614 2368614 defendant Thurton alias Cardon William gent 586132 586132 Thurton alias Cardon, William, of Thurton, gent 0
5055040 2373073 2373073 defendant Thurton alias Cardon William gent 586132 586132 Thurton alias Cardon, William, of Thurton, gent 0
5087612 2382760 2382760 defendant Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 0
5180695 2410094 2410094 defendant Thurton Henry gent 586132 586132 Thurton, Henry, of Thurton, gent 0
5232225 2425003 2425003 defendant Hempste John laborer 586132 586132 Hempste, John, of Thurton, laborer 4
5232226 2425003 2425003 defendant Elys Robert laborer 586132 586132 Elys, Robert, of Thurton, laborer 5
5258215 2432690 2432690 defendant Rychemonde William yeoman 586132 586132 Rychemonde, William, of Thurton, yeoman 2
5273117 2437208 2437208 defendant Rychemond William husbandman 586132 586132 Rychemond, William, of Thurton, husbandman 2
5335548 2455704 2455704 defendant Howes John yeoman 586132 586132 Howes, John, of Thurton, yeoman 2
5349918 2460105 2460105 defendant Howes John yeoman 586132 586132 Howes, John, of Thurton, yeoman 0
5560463 2523019 2523019 defendant Coket Robert yeoman 586132 586132 Coket, Robert, of Thurton, yeoman 0
5594543 2533270 2533270 defendant Poster John husbandman 586132 586132 Poster, John, of Thurton, husbandman 9
5627304 2552508 2552508 defendant Thurton William gent 586132 586132 Thurton, William, of Thurton, gent 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);