names

57 rows where place_id = 588808

✎ 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
3595666 1866271 1866271 defendant Soper William husbandman 588808 588808 Soper, William, of Brodeclyst, husbandman 0
3595667 1866271 1866271 defendant Payne John husbandman 588808 588808 Payne, John, of Brodeclyst, husbandman 1
3607770 1870080 1870080 defendant Elyot John husbandman 588808 588808 Elyot, John, of Brodeclyst, husbandman 0
3657219 1912522 1912522 defendant Chudlegh Joan widow 588808 588808 Chudlegh, Joan, of Brodeclyst, widow 0
3672071 1917267 1917267 defendant Skete John yeoman 588808 588808 Skete, John, of Brodeclyst, yeoman 1
3688276 1922479 1922479 defendant Crokhey John husbandman 588808 588808 Crokhey, John, of Brodeclyst, husbandman 0
3699790 1926159 1926159 defendant Crokhey John husbandman 588808 588808 Crokhey, John, of Brodeclyst, husbandman 0
3703027 1927220 1927220 defendant Skete John yeoman 588808 588808 Skete, John, of Brodeclyst, yeoman 1
3703128 1927252 1927252 defendant Crokhey John husbandman 588808 588808 Crokhey, John, of Brodeclyst, husbandman 0
3714044 1930692 1930692 defendant Carsley Richard husbandman 588808 588808 Carsley, Richard, of Brodeclyst, husbandman 0
3716946 1931587 1931587 defendant Crokhey John husbandman 588808 588808 Crokhey, John, of Brodeclyst, husbandman 0
3815404 1962734 1962734 defendant Pyne Stephen hysbandman 588808 588808 Pyne, Stephen, of Brodeclyst, hysbandman 2
3815405 1962734 1962734 defendant Mounstephyn William hysbandman 588808 588808 Mounstephyn, William, of Brodeclyst, hysbandman 3
3883490 1984748 1984748 defendant Toker Richard husbandman 588808 588808 Toker, Richard, of Brodeclyst, husbandman 0
3891964 1987564 1987564 defendant Payne Elias husbandman 588808 588808 Payne, Elias, of Brodeclyst, husbandman 0
3920092 1997054 1997054 plaintiff Mannyng John   588808 588808 Mannyng, John, of Brodeclyst 0
3920093 1997054 1997054 defendant Ford Robert gent 588808 588808 Ford, Robert, of Brodeclyst, gent 0
3949636 2006948 2006948 plaintiff Eveleighe John, junior   588808 588808 Eveleighe, John, junior, of Brodeclyst 0
3965741 2012635 2012635 defendant Taylor John husbandman 588808 588808 Taylor, John, of Brodeclyst, husbandman 0
3990438 2021335 2021335 defendant Vylbayne Thomas   588808 588808 Vylbayne, Thomas, of Brodeclyst, Devon gent 1
4026597 2034162 2034162 defendant West Richard husbandman 588808 588808 West, Richard, of Brodeclyst, husbandman 0
4099129 2060015 2060015 defendant Aldred Robert weaver 588808 588808 Aldred, Robert, of Brodeclyst, weaver 0
4463599 2189311 2189311 defendant atte More William   588808 588808 atte More, William, of Brodeclyst 0
4651553 2246487 2246487 defendant Vernecombe John   588808 588808 Vernecombe, John, of Brodeclyst, bailiff 11
4756214 2282318 2282318 defendant atte Lake William husbandman 588808 588808 atte Lake, William, of Brodeclyst, husbandman 4
4798341 2295668 2295668 defendant Toker Roger   588808 588808 Toker, Roger, of Brodeclyst, clerk, officioal of archdeacon of Exeter 0
4908292 2329146 2329146 defendant Eme William laborer 588808 588808 Eme, William, of Brodeclyst, laborer 1
4913272 2330650 2330650 defendant Evele John husbandman 588808 588808 Evele, John, of Brodeclyst, husbandman 0
4945471 2340561 2340561 defendant Dollyng Benedict butcher 588808 588808 Dollyng, Benedict, of Brodeclyst, butcher 2
4984979 2352441 2352441 defendant More Henry husbandman 588808 588808 More, Henry, of Brodeclyst, husbandman 0
5069293 2377303 2377303 defendant atte Combe Thomas husbandman 588808 588808 atte Combe, Thomas, of Brodeclyst, husbandman 0
5069294 2377303 2377303 defendant atte Clyf Richard husbandman 588808 588808 atte Clyf, Richard, of Brodeclyst, husbandman 1
5069296 2377303 2377303 defendant Bugge John husbandman 588808 588808 (Bugge, John, of Brodeclyst, husbandman 3
5217806 2420937 2420937 defendant Clere John clerk 588808 588808 Clere, John, of Brodeclyst, clerk 0
5217807 2420937 2420937 defendant Credy John laborer 588808 588808 together with Credy, John, of Brodeclyst, laborer 1
5217808 2420937 2420937 defendant Enlegh or Gulegh Thomas laborer 588808 588808 Enlegh or Gulegh, Thomas, of Brodeclyst, laborer 2
5217810 2420938 2420938 defendant Credy John laborer 588808 588808 Credy, John, of Brodeclyst, laborer 0
5217811 2420938 2420938 defendant Enlegh or Gulegh Thomas laborer 588808 588808 Enlegh or Gulegh, Thomas, of Brodeclyst, laborer 1
5224229 2422757 2422757 defendant Trowe William husbandman 588808 588808 Trowe, William, of Brodeclyst, husbandman 1
5261152 2433598 2433598 defendant Southewode John husbandman 588808 588808 Southewode, John, of Brodeclyst, husbandman 3
5280480 2439365 2439365 defendant Forde William husbandman 588808 588808 Forde, William, of Brodeclyst, husbandman 0
5296755 2444040 2444040 defendant Forde William husbandman 588808 588808 Forde, William, of Brodeclyst, husbandman 4
5328745 2453675 2453675 defendant Forde William husbandman 588808 588808 Forde, William, of Brodeclyst, husbandman 0
5374575 2467655 2467655 defendant Pyle Richard husbandman 588808 588808 Pyle, Richard, of Brodeclyst, husbandman 0
5479603 2498910 2498910 defendant Fulford John tailor 588808 588808 Fulford, John, of Brodeclyst, tailor 3
5483443 2499995 2499995 defendant Soper John laborer 588808 588808 Soper, John, of Brodeclyst, laborer 2
5486005 2500703 2500703 defendant Water William husbandman 588808 588808 Water, William, of Brodeclyst, husbandman 0
5486006 2500703 2500703 defendant Water William, junior   588808 588808 Water, William, junior, of Brodeclyst, groom 1
5486009 2500703 2500703 defendant Hoke William baker 588808 588808 Hoke, William, of Brodeclyst, baker 4
5496799 2503968 2503968 defendant Mounseys alias Monceux John husbandman 588808 588808 Mounseys alias Monceux, John, of Brodeclyst, husbandman 1
5510966 2508270 2508270 defendant Lake John husbandman 588808 588808 Lake, John, of Brodeclyst, husbandman 0
5530043 2513905 2513905 defendant Davy William yeoman 588808 588808 Davy, William, of Brodeclyst, yeoman 1
5536169 2515806 2515806 defendant Caslegh Ralph husbandman 588808 588808 Caslegh, Ralph, of Brodeclyst, husbandman 0
5536170 2515806 2515806 defendant Pyle Richard husbandman 588808 588808 Pyle, Richard, of Brodeclyst, husbandman 1
5540508 2517164 2517164 defendant Thurscomb Nicholas husbandman 588808 588808 Thurscomb, Nicholas, of Brodeclyst, husbandman 1
5540782 2517246 2517246 defendant Hayman John husbandman 588808 588808 Hayman, John, of Brodeclyst, husbandman 0
5573602 2526845 2526845 defendant Pyne Richard husbandman 588808 588808 Pyne, Richard, of Brodeclyst, husbandman 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);