names

42 rows where place_id = 587111

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590497 1864673 1864673 defendant Kymplond John yeoman 587111 587111 Kymplond, John, of Hemyok, yeoman 0
3672095 1917274 1917274 defendant Walland Walter husbandman 587111 587111 Walland, Walter, of Hemyok, husbandman 0
3672096 1917274 1917274 defendant Thornbury John husbandman 587111 587111 Thornbury, John, of Hemyok, husbandman 1
3821691 1964672 1964672 defendant Benet James husbandman 587111 587111 Benet, James, of Hemyok, husbandman 0
3823330 1965210 1965210 defendant Moynes William clerk 587111 587111 Moynes, William, of Hemyok, clerk 0
4522357 2207337 2207337 defendant Houper john, sen   587111 587111 Houper, john, sen, of Hemyok 0
4637560 2242534 2242534 defendant Rothewell William master & parson 587111 587111 Rothewell, William, of Hemyok, master & parson 1
4674563 2257649 2257649 defendant Gleve or Gleve Henry yeoman 587111 587111 Gleve or Gleve, Henry, of Hemyok, yeoman 1
4674564 2257649 2257649 defendant the parson-servant Godwin laborer 587111 587111 the parson-servant, Godwin, of Hemyok, laborer 2
4699050 2265172 2265172 defendant Rowe John   587111 587111 Rowe, John, of Hemyok, bailiff 0
4778558 2289276 2289276 defendant Howynham John butcher 587111 587111 Howynham, John, of Hemyok, butcher 0
4801044 2296516 2296516 defendant Penyman William husbandman 587111 587111 Penyman, William, of Hemyok, husbandman 0
4801045 2296516 2296516 defendant Halsangre John clerk 587111 587111 Halsangre, John, of Hemyok, clerk 1
4813499 2300331 2300331 defendant Machyng John   587111 587111 Machyng, John, of Hemyok, bailiff 2
4842139 2309077 2309077 defendant Clode Ralph husbandman 587111 587111 Clode, Ralph, of Hemyok, husbandman 0
4919813 2332703 2332703 defendant Pressford John husbandman 587111 587111 Pressford, John, of Hemyok, husbandman 2
4937119 2337982 2337982 defendant Broughton Nicholas esq 587111 587111 Broughton, Nicholas, of Hemyok, esq 0
4960010 2344958 2344958 defendant Prassheford John husbandman 587111 587111 Prassheford, John, of Hemyok, husbandman 1
4962510 2345690 2345690 defendant Broughton Nicholas esq 587111 587111 Broughton, Nicholas, of Hemyok, esq 0
4984600 2352328 2352328 defendant Dyer Nicholas yeoman 587111 587111 Dyer, Nicholas, of Hemyok, yeoman 0
4984601 2352328 2352328 defendant Lokyer William turner 587111 587111 Lokyer, William, of Hemyok, turner 1
4984602 2352328 2352328 defendant Borneman John, senior yeoman 587111 587111 Borneman, John, senior, of Hemyok, yeoman 2
4984603 2352328 2352328 defendant Borneman John, junior yeoman 587111 587111 Borneman, John, junior, of Hemyok, yeoman 3
4984604 2352328 2352328 defendant White Walter husbandman 587111 587111 White, Walter, of Hemyok, husbandman 4
5016057 2361578 2361578 defendant Penyman John   587111 587111 Penyman, John, of Hemyok, bailiff 3
5021524 2363196 2363196 defendant Penyman John   587111 587111 Penyman, John, of Hemyok, bailiff 1
5040301 2368697 2368697 defendant Broughton Nicholas esq 587111 587111 Broughton, Nicholas, of Hemyok, esq 0
5055347 2373184 2373184 defendant Broughton Nicholas esq 587111 587111 Broughton, Nicholas, of Hemyok, esq 0
5085702 2382215 2382215 defendant Turnour William turner 587111 587111 Turnour, William, of Hemyok, turner 3
5134762 2396667 2396667 defendant Mewecombe John husbandman 587111 587111 (Mewecombe, John, of Hemyok, husbandman 1
5135725 2396958 2396958 defendant Chave Richard clerk 587111 587111 Chave, Richard, of Hemyok, clerk 1
5155990 2402906 2402906 defendant Chave Richard clerk 587111 587111 Chave, Richard, of Hemyok, clerk 1
5155993 2402907 2402907 defendant Chave Richard clerk 587111 587111 Chave, Richard, of Hemyok, clerk 1
5163593 2405086 2405086 defendant Shakyll John husbandman 587111 587111 Shakyll, John, of Hemyok, husbandman 0
5191751 2413323 2413323 defendant Chave Richard clerk 587111 587111 Chave, Richard, of Hemyok, clerk 0
5199988 2415751 2415751 defendant Shakyll John husbandman 587111 587111 Shakyll, John, of Hemyok, husbandman 0
5207461 2417922 2417922 defendant Chave Richard clerk 587111 587111 Chave, Richard, of Hemyok, clerk 0
5220137 2421596 2421596 defendant Carnavell or Carvanell Michael clerk 587111 587111 Carnavell or Carvanell, Michael, of Hemyok, clerk 0
5343192 2458063 2458063 defendant Carnavell or Carvanell Michael clerk 587111 587111 Carnavell or Carvanell, Michael, of Hemyok, clerk 0
5375770 2468016 2468016 defendant Glade William husbandman 587111 587111 Glade, William, of Hemyok, husbandman 2
5533075 2514886 2514886 defendant Tytewey Nicholas husbandman 587111 587111 Tytewey, Nicholas, of Hemyok, husbandman 0
5606301 2536865 2536865 defendant Mawedite William husbandman 587111 587111 Mawedite, William, of Hemyok, husbandman 2

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