names

70 rows where place_id = 591928

✎ 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
3606014 1869545 1869545 defendant Hunte Thomas merchant 591928 591928 Hunte, Thomas, of South Molton, Devon, merchant 0
3666632 1915508 1915508 defendant Comer William merchant 591928 591928 Comer, William, of South Molton, Devon, merchant 0
3668156 1915986 1915986 defendant Hunt John merchant 591928 591928 Hunt, John, of South Molton, Devon, merchant 1
3759765 1945047 1945047 defendant Gren Robert chapman 591928 591928 Gren, Robert, of South Molton, Devon, chapman 0
3777622 1950751 1950751 defendant Gren Robert chapman 591928 591928 Gren, Robert, of South Molton, Devon, chapman 0
3815328 1962710 1962710 defendant Gylbert James capper 591928 591928 Gylbert, James, of South Molton, Devon, capper 1
3815332 1962711 1962711 defendant Gylbert James draper 591928 591928 Gylbert, James, of South Molton, Devon, draper 1
3979081 2017270 2017270 defendant Sundercombe John weaver 591928 591928 Sundercombe, John, of South Molton, Devon, weaver 0
3984454 2019197 2019197 defendant Clotworthye Thomas gent 591928 591928 Clotworthye, Thomas, of South Molton, Devon, gent 0
3985203 2019464 2019464 defendant Chappell Anthony clothier 591928 591928 Chappell, Anthony, of South Molton, Devon, clothier 0
3988953 2020789 2020789 defendant Whytehere William weaver 591928 591928 Whytehere, William, of South Molton, Devon, weaver 1
3995324 2023068 2023068 defendant Clotworthye Thomas, junior gent 591928 591928 Clotworthye, Thomas, junior, of South Molton, Devon, gent 0
4002356 2025617 2025617 defendant More Thomas yeoman 591928 591928 More, Thomas, of South Molton, Devon, yeoman 0
4024305 2033386 2033386 defendant Awtrey John yeoman 591928 591928 Awtrey, John, of South Molton, Devon, yeoman 9
4029523 2035195 2035195 defendant More Thomas yeoman 591928 591928 More, Thomas, of South Molton, Devon, yeoman 0
4042842 2039915 2039915 defendant Clotworthie Anthony yeoman 591928 591928 Clotworthie, Anthony, of South Molton, Devon, yeoman 0
4060988 2046338 2046338 plaintiff Dodridge Richard merchant 591928 591928 Dodridge, Richard, of South Molton, Devon, merchant 0
4060990 2046339 2046339 plaintiff Dodridge Richard merchant 591928 591928 Dodridge, Richard, of South Molton, Devon, merchant 0
4081159 2053572 2053572 defendant Clotworthye Thomas gent 591928 591928 Clotworthye, Thomas, of South Molton, Devon, gent 0
4084475 2054724 2054724 defendant Whytheare William, senior husbandman 591928 591928 Whytheare, William, senior, of South Molton, Devon, husbandman 0
4107626 2063009 2063009 defendant Mogridge Henry smith 591928 591928 Mogridge, Henry, of South Molton, Devon, smith 0
4123045 2068538 2068538 defendant Sutton Robert weaver 591928 591928 Sutton, Robert, of South Molton, Devon, weaver 2
4127299 2070058 2070058 defendant Hony or Hovy Griffin shoemaker 591928 591928 Hony or Hovy, Griffin, of South Molton, Devon, shoemaker 1
4131368 2071539 2071539 defendant Cudmore Edward yeoman 591928 591928 Cudmore, Edward, of South Molton, Devon, yeoman 0
4140066 2074691 2074691 defendant Hatche Thomas esq 591928 591928 Hatche, Thomas, of South Molton, Devon, esq 0
4140424 2074818 2074818 defendant Vycary William husbandman 591928 591928 Vycary, William, of South Molton, Devon, husbandman 0
4143668 2075940 2075940 defendant Knollynge John yeoman 591928 591928 Knollynge, John, of South Molton, Devon, yeoman 3
4152802 2079087 2079087 defendant Wall George yeoman 591928 591928 Wall, George, of South Molton, Devon, yeoman 0
4159943 2081545 2081545 defendant Raisheleighe Peter clothier 591928 591928 Raisheleighe, Peter, of South Molton, Devon, clothier 0
4185542 2090449 2090449 defendant Sutton Robert weaver 591928 591928 Sutton, Robert, of South Molton, Devon, weaver 0
4187069 2090968 2090968 defendant Sherland Oliver clothier 591928 591928 Sherland, Oliver, of South Molton, Devon, clothier 1
4188987 2091632 2091632 defendant Hobbes Thomas yeoman 591928 591928 Hobbes, Thomas, of South Molton, Devon, yeoman 0
4193673 2093355 2093355 defendant Shereland Oliver clothier 591928 591928 Shereland, Oliver, of South Molton, Devon, clothier 0
4200037 2095564 2095564 defendant Hatche Cecily widow 591928 591928 Hatche, Cecily, of South Molton, Devon, widow 1
4223898 2103844 2103844 defendant Clatworthye Thomas gent 591928 591928 Clatworthye, Thomas, of South Molton, Devon, gent 1
4224144 2103931 2103931 defendant Stevens Philip yeoman 591928 591928 Stevens, Philip, of South Molton, Devon, yeoman 0
4224907 2104179 2104179 defendant Harewoode Henry esq 591928 591928 Harewoode, Henry, of South Molton, Devon, esq 0
4224909 2104180 2104180 defendant Stephens Philip gent 591928 591928 Stephens, Philip, of South Molton, Devon, gent 0
4228161 2105330 2105330 defendant Smythe William blacksmith 591928 591928 Smythe, William, of South Molton, Devon, blacksmith 3
4232246 2106781 2106781 defendant Stevens Philip yeoman 591928 591928 Stevens, Philip, of South Molton, Devon, yeoman 0
4232253 2106784 2106784 defendant Chaldon George miller 591928 591928 Chaldon, George, of South Molton, Devon, miller 0
4235892 2108126 2108126 defendant Smythe William blacksmith 591928 591928 Smythe, William, of South Molton, Devon, blacksmith 3
4302492 2130991 2130991 defendant Chaldon George miller 591928 591928 Chaldon, George, of South Molton, Devon, miller 0
4303647 2131401 2131401 defendant Cruse alias Allen John yeoman 591928 591928 Cruse alias Allen, John, of South Molton, Devon, yeoman 0
4326473 2139216 2139216 defendant Pollarde Hugh gent 591928 591928 Pollarde, Hugh, of South Molton, Devon, gent 1
4329957 2140319 2140319 defendant Chappington Samuel vintner 591928 591928 Chappington, Samuel, of South Molton, Devon, vintner 0
4363585 2152049 2152049 defendant Clotworthie Hugh gent 591928 591928 Clotworthie, Hugh, of South Molton, Devon, gent 0
4380756 2158230 2158230 defendant Evans John shoemaker 591928 591928 Evans, John, of South Molton, Devon, shoemaker 0
4665322 2250643 2250643 defendant Pytteney Richard   591928 591928 Pytteney, Richard, of South Molton, Devon, mason 0
4804409 2297562 2297562 defendant Bonde Thomas husbandman 591928 591928 Bonde, Thomas, of South Molton, Devon, husbandman 0
4804412 2297562 2297562 defendant Begaunt Agnes widow 591928 591928 Begaunt, Agnes, of South Molton, Devon, widow 3
4841213 2308791 2308791 defendant Forde Joceus tailor 591928 591928 Forde, Joceus, of South Molton, Devon, tailor 0
4868479 2317113 2317113 defendant Forde Joce tailor 591928 591928 Forde, Joce, of South Molton, Devon, tailor 0
4888032 2323060 2323060 defendant Redeweyne David tanner 591928 591928 Redeweyne, David, of South Molton, Devon, tanner 3
4987216 2353124 2353124 defendant Soper John   591928 591928 Soper, John, of South Molton, Devon, franklin 3
5090382 2383567 2383567 defendant Webber Richard chapman 591928 591928 Webber, Richard, of South Molton, Devon, chapman 0
5102152 2387056 2387056 defendant Soper John yeoman 591928 591928 Soper, John, of South Molton, Devon, yeoman 0
5255784 2431930 2431930 defendant Serteyn William   591928 591928 Serteyn, William, of South Molton, Devon, franklin 1
5301227 2445326 2445326 defendant Harewode John husbandman 591928 591928 Harewode, John, of South Molton, Devon, husbandman 0
5342172 2457745 2457745 defendant Thorndon John tucker 591928 591928 Thorndon, John, of South Molton, Devon, tucker 0
5378597 2468890 2468890 defendant Ulburgh John chaplain 591928 591928 Ulburgh, John, of South Molton, Devon, chaplain 0
5395348 2473742 2473742 defendant Cloteworthy John chapman 591928 591928 Cloteworthy, John, of South Molton, Devon, chapman 0
5408612 2477540 2477540 defendant Cloteworth John chapman 591928 591928 Cloteworth, John, of South Molton, Devon, chapman 0
5408614 2477541 2477541 defendant Cloteworthy John chapman 591928 591928 Cloteworthy, John, of South Molton, Devon, chapman 0
5555077 2521491 2521491 defendant Smyth Richard clothier 591928 591928 Smyth, Richard, of South Molton, Devon, clothier 0
5559363 2522705 2522705 defendant Smyth Richard clothier 591928 591928 Smyth, Richard, of South Molton, Devon, clothier 0
5573465 2526797 2526797 defendant Smyth Richard merchant 591928 591928 Smyth, Richard, of South Molton, Devon, merchant 0
5573467 2526798 2526798 defendant Smyth Richard merchant 591928 591928 Smyth, Richard, of South Molton, Devon, merchant 0
5605511 2536605 2536605 defendant Culme Hugh gent 591928 591928 Culme, Hugh, of South Molton, Devon, gent 0
5636463 2555357 2555357 defendant Bromwiche John   591928 591928 Bromwiche, John, of South Molton, Devon, merhant 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);