names

58 rows where place_id = 586580

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589090 1864235 1864235 defendant Frankeleyn Humphrey husbandman 586580 586580 Frankeleyn, Humphrey, of Mylverton, husbandman 1
3705742 1928077 1928077 defendant Sanforde John, senior gent 586580 586580 Sanforde, John, senior, of Mylverton, gent 0
3709546 1929293 1929293 defendant Byrde John, senior husbandman 586580 586580 Byrde, John, senior, of Mylverton, husbandman 0
3716727 1931523 1931523 defendant Perott William tanner 586580 586580 Perott, William, of Mylverton, tanner 0
3755908 1943802 1943802 defendant Ryche John husbandman 586580 586580 Ryche, John, of Mylverton, husbandman 0
3763433 1946195 1946195 defendant Benett Richard husbandman 586580 586580 Benett, Richard, of Mylverton, husbandman 0
3773904 1949551 1949551 defendant Ryche John husbandman 586580 586580 Ryche, John, of Mylverton, husbandman 0
3805901 1959786 1959786 defendant Rychardys James gent 586580 586580 Rychardys, James, of Mylverton, gent 0
3873292 1981284 1981284 defendant Walpon John husbandman 586580 586580 Walpon, John, of Mylverton, husbandman 2
3892872 1987864 1987864 defendant Chapleyne William husbandman 586580 586580 Chapleyne, William, of Mylverton, husbandman 0
3900667 1990453 1990453 defendant Salter Elize clerk 586580 586580 Salter, Elize, of Mylverton, clerk 0
3910758 1993918 1993918 defendant Olyver William miller 586580 586580 Olyver, William, of Mylverton, miller 0
3910760 1993919 1993919 defendant Olyver William miller 586580 586580 Olyver, William, of Mylverton, miller 0
3942746 2004577 2004577 defendant Rowsewell William husbandman 586580 586580 Rowsewell, William, of Mylverton, husbandman 0
3998959 2024386 2024386 defendant Ayshecombe William husbandman 586580 586580 Ayshecombe, William, of Mylverton, husbandman 0
4009747 2028254 2028254 defendant Colton Edmund gent 586580 586580 Colton, Edmund, of Mylverton, gent 0
4009748 2028254 2028254 defendant Pryde- James husbandman 586580 586580 Pryde-, James, of Mylverton, husbandman 1
4009824 2028290 2028290 defendant Ayshecombe William husbandman 586580 586580 Ayshecombe, William, of Mylverton, husbandman 0
4100141 2060383 2060383 defendant Colman James weaver 586580 586580 Colman, James, of Mylverton, husbandman, weaver 0
4122223 2068253 2068253 defendant Potter John carpenter 586580 586580 Potter, John, of Mylverton, carpenter 0
4122225 2068253 2068253 defendant Foweraker William butcher 586580 586580 Foweraker, William, of Mylverton, butcher 2
4125379 2069360 2069360 defendant Dennynge Thomas husbandman 586580 586580 Dennynge, Thomas, of Mylverton, husbandman 1
4127363 2070077 2070077 defendant Bewfooe John gent 586580 586580 Bewfooe, John, of Mylverton, gent 0
4145412 2076552 2076552 defendant Ingrame John husbandman 586580 586580 Ingrame, John, of Mylverton, husbandman 2
4213956 2100402 2100402 defendant Monday William yeoman 586580 586580 Monday, William, of Mylverton, yeoman 0
4213958 2100403 2100403 defendant Spreate John husbandman 586580 586580 Spreate, John, of Mylverton, husbandman 0
4217048 2101457 2101457 defendant Bewfoe John gent 586580 586580 Bewfoe, John, of Mylverton, gent 1
4226767 2104836 2104836 defendant Bewfoe John gent 586580 586580 Bewfoe, John, of Mylverton, gent 0
4300547 2130290 2130290 defendant Rysdon Edward   586580 586580 Rysdon, Edward, of Mylverton, mason 0
4319824 2137042 2137042 defendant Heathe Thomas husbandman 586580 586580 Heathe, Thomas, of Mylverton, husbandman 2
4321776 2137705 2137705 defendant Dyshe Arthur yeoman 586580 586580 Dyshe, Arthur, of Mylverton, yeoman 1
4657674 2248288 2248288 defendant Waryng Alice widow of Edward 586580 586580 Waryng, Alice, of Mylverton, spinner, widow of Edward 2
4833110 2306373 2306373 defendant Saunford Maud widow 586580 586580 Saunford, Maud, of Mylverton, widow 7
4867926 2316938 2316938 defendant Verse Thomas dyer 586580 586580 Verse, Thomas, of Mylverton, dyer 2
4978293 2350456 2350456 defendant Broghton William husbandman 586580 586580 Broghton, William, of Mylverton, husbandman 0
4978294 2350456 2350456 defendant Canon Henry husbandman 586580 586580 Canon, Henry, of Mylverton, husbandman 1
4978296 2350456 2350456 defendant Hert Richard husbandman 586580 586580 Hert, Richard, of Mylverton, husbandman 3
4978297 2350456 2350456 defendant at Bere John husbandman 586580 586580 at Bere, John, of Mylverton, husbandman 4
5100876 2386672 2386672 defendant Hardyng John shoemaker 586580 586580 Hardyng, John, of Mylverton,shoemaker 0
5100877 2386672 2386672 defendant Brewe John shoemaker 586580 586580 Brewe, John, of Mylverton, shoemaker 1
5100878 2386672 2386672 defendant Beste Richard baker 586580 586580 Beste, Richard, of Mylverton, baker 2
5116176 2391157 2391157 defendant Mere or at the Mere Richard   586580 586580 Mere or at the Mere, Richard, of Mylverton, yeoman, bailiff 0
5138261 2397699 2397699 defendant Taillour William tailor 586580 586580 Taillour, William, of Mylverton, tailor 3
5159058 2403764 2403764 defendant Taillour Walter tailor 586580 586580 Taillour, Walter, of Mylverton, tailor 3
5171485 2407381 2407381 defendant Charley John husbandman 586580 586580 Charley, John, of Mylverton, husbandman 1
5194927 2414265 2414265 defendant Tayllour William tailor 586580 586580 Tayllour, William, of Mylverton, tailor 3
5269726 2436257 2436257 defendant Tor--- William tailor 586580 586580 Tor---, William, of Mylverton, tailor 2
5269727 2436257 2436257 defendant Brener Nicholas   586580 586580 Brener, Nicholas, of Mylverton 3
5311948 2448600 2448600 defendant Duchey John husbandman 586580 586580 (Duchey, John, of Mylverton, husbandman 4
5383851 2470467 2470467 defendant Clode William mercer 586580 586580 Clode, William, of Mylverton, mercer 1
5435928 2485687 2485687 defendant Vyncent John miller 586580 586580 Vyncent, John, of Mylverton, miller 0
5437013 2486007 2486007 defendant Hoper John yeoman 586580 586580 Hoper, John, of Mylverton, yeoman 1
5476214 2497890 2497890 defendant Clode William mercer 586580 586580 Clode, William, of Mylverton, mercer 0
5498325 2504459 2504459 defendant Bradnyn or Bradvyn alias Wevyll John husbandman 586580 586580 Bradnyn or Bradvyn alias Wevyll, John, of Mylverton, husbandman 0
5556609 2521885 2521885 defendant Hoper John, senior fisher 586580 586580 Hoper, John, senior, of Mylverton, fisher 0
5556612 2521885 2521885 defendant Justyn Richard fisher 586580 586580 (Justyn, Richard, of Mylverton, fisher 3
5569800 2525742 2525742 defendant Hoper William husbandman 586580 586580 Hoper, William, of Mylverton, husbandman 0
5569801 2525742 2525742 defendant Vyssher or Uyssher Alice widow 586580 586580 Vyssher or Uyssher, Alice, of Mylverton, widow 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);