names

76 rows where place_id = 597587

✎ 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
3629130 1903983 1903983 defendant Prouz John, senior gent 597587 597587 Prouz, John, senior, of Chagford, gent 0
3629131 1903983 1903983 defendant Ford Richard husbandman 597587 597587 Ford, Richard, of Chagford, husbandman 1
3662444 1914166 1914166 defendant Hall Geoffrey husbandman 597587 597587 Hall, Geoffrey, of Chagford, husbandman 1
3662446 1914166 1914166 defendant Hall Peter   597587 597587 Hall, Peter, of Chagford, groom 3
3683795 1921067 1921067 defendant Yoldon Elizabeth widow 597587 597587 Yoldon, Elizabeth, of Chagford, widow 1
3683796 1921067 1921067 defendant Ford Richard yeoman 597587 597587 Ford, Richard, of Chagford, yeoman 2
3683799 1921068 1921068 defendant Ford Richard yeoman 597587 597587 Ford, Richard, of Chagford, yeoman 1
3683800 1921068 1921068 defendant Yoldon Elizabeth widow 597587 597587 Yoldon, Elizabeth, of Chagford, widow 2
3683803 1921069 1921069 defendant Lymscote Richard tinner 597587 597587 Lymscote, Richard, of Chagford, tinner 1
3769754 1948194 1948194 defendant Newcombe John husbandman 597587 597587 Newcombe, John, of Chagford, husbandman 0
3819352 1963938 1963938 plaintiff Newcomb John, senior   597587 597587 Newcomb, John, senior, of Chagford 0
3819354 1963939 1963939 plaintiff Newcombe John, senior   597587 597587 Newcombe, John, senior, of Chagford 0
3819356 1963940 1963940 plaintiff Newcombe John, senior   597587 597587 Newcombe, John, senior, of Chagford 0
3824886 1965666 1965666 defendant Man John husbandman 597587 597587 Man, John, of Chagford, husbandman 0
3824887 1965666 1965666 defendant Cremer John husbandman 597587 597587 Cremer, John, of Chagford, husbandman 1
3824888 1965666 1965666 defendant Potter William husbandman 597587 597587 Potter, William, of Chagford, husbandman 2
3824889 1965666 1965666 defendant Serle William husbandman 597587 597587 Serle, William, of Chagford, husbandman 3
3824890 1965666 1965666 defendant Lightfott William, senior husbandman 597587 597587 Lightfott, William, senior, of Chagford, husbandman 4
3824891 1965666 1965666 defendant Lightfott William, junior husbandman 597587 597587 Lightfott, William, junior, of Chagford, husbandman 5
3829898 1967242 1967242 defendant Throwston Henry tinner 597587 597587 Throwston, Henry, of Chagford, tinner 0
3834580 1968749 1968749 plaintiff Newcombe John, senior   597587 597587 Newcombe, John, senior, of Chagford 0
3850497 1973743 1973743 defendant Hoper Thomas husbandman 597587 597587 Hoper, Thomas, of Chagford, husbandman 0
3855886 1975465 1975465 defendant Hurston Simon, junior husbandman 597587 597587 Hurston, Simon, junior, of Chagford, husbandman 0
3942731 2004573 2004573 defendant Prowse John   597587 597587 Prowse, John, of Chagford 0
3942732 2004573 2004573 defendant Loskey Gregory husbandman 597587 597587 Loskey, Gregory, of Chagford, husbandman 1
3942733 2004573 2004573 defendant Noseworthy Augustus husbandman 597587 597587 Noseworthy, Augustus, of Chagford, husbandman 2
3942734 2004573 2004573 defendant Trende Henry husbandman 597587 597587 Trende, Henry, of Chagford, husbandman 3
3942735 2004573 2004573 defendant Glanfyld Richard husbandman 597587 597587 Glanfyld, Richard, of Chagford, husbandman 4
3946981 2006008 2006008 defendant Loskey Richard tinner 597587 597587 Loskey, Richard, of Chagford, tinner 0
3957704 2009753 2009753 defendant Caselegh William   597587 597587 Caselegh, William, of Chagford, groom 0
3957705 2009753 2009753 defendant Hole John tailor 597587 597587 Hole, John, of Chagford, tailor 1
3957706 2009753 2009753 defendant Serell John husbandman 597587 597587 Serell, John, of Chagford, husbandman 2
3974476 2015649 2015649 defendant Norssworthy Augustine or Austin yeoman 597587 597587 Norssworthy, Augustine or Austin, of Chagford, yeoman 0
4000822 2025063 2025063 defendant Noseworthye Ahustine (legal representative) 597587 597587 Noseworthye, Ahustine, of Chagford, yeoman, executrix of 0
4000823 2025063 2025063 defendant Noseworthye Jocota widow 597587 597587 Noseworthye, Jocota, of Chagford, widow 1
4034867 2037147 2037147 defendant Wyll John husbandman 597587 597587 Wyll, John, of Chagford, husbandman 0
4034869 2037148 2037148 defendant Wyll John husbandman 597587 597587 Wyll, John, of Chagford, husbandman 0
4043829 2040242 2040242 plaintiff Prowse John esq 597587 597587 Prowse, John, of Chagford, esq 0
4103842 2061648 2061648 defendant Loskey Elizabeth widow 597587 597587 Loskey, Elizabeth, of Chagford, widow 1
4196953 2094485 2094485 defendant Cliff Thomas merchant 597587 597587 Cliff, Thomas, of Chagford, merchant 1
4197074 2094528 2094528 defendant Collyns John husbandman 597587 597587 Collyns, John, of Chagford, husbandman 1
4200997 2095906 2095906 defendant Tyncombe William husbandman 597587 597587 Tyncombe, William, of Chagford, husbandman 2
4202089 2096275 2096275 defendant Tyngcombe William yeoman 597587 597587 Tyngcombe, William, of Chagford, yeoman 0
4202090 2096275 2096275 defendant Clyffe Thomas yeoman 597587 597587 Clyffe, Thomas, of Chagford, yeoman 1
4210083 2099088 2099088 defendant Bonnyme or Bonymaye John, junior weaver 597587 597587 Bonnyme or Bonymaye, John, junior, of Chagford, weaver 3
4245065 2111334 2111334 defendant Howe Hugh husbandman 597587 597587 Howe, Hugh, of Chagford, husbandman 2
4245069 2111335 2111335 defendant Howe Hugh husbandman 597587 597587 Howe, Hugh, of Chagford, husbandman 2
4305296 2131994 2131994 defendant Trend Robert husbandman 597587 597587 Trend, Robert, of Chagford, husbandman 0
4354469 2148796 2148796 defendant Tyngcombe William yeoman 597587 597587 Tyngcombe, William, of Chagford, yeoman 0
4363231 2151915 2151915 defendant Northcott William yeoman 597587 597587 Northcott, William, of Chagford, yeoman 0
4379133 2157618 2157618 defendant Northcott John yeoman 597587 597587 Northcott, John, of Chagford, yeoman 0
4385337 2159786 2159786 defendant Howe Hugh tinner 597587 597587 Howe, Hugh, of Chagford, tinner 2
4409106 2167650 2167650 defendant Roo John, senior husbandman 597587 597587 Roo, John, senior, of Chagford, husbandman 0
4625167 2238836 2238836 defendant Kyng John   597587 597587 Kyng, John, of Chagford 3
4805197 2297825 2297825 defendant Michell John husbandman 597587 597587 Michell, John, of Chagford, husbandman 3
5072460 2378250 2378250 defendant Prous Richard gent 597587 597587 Prous, Richard, of Chagford, gent 0
5128160 2394710 2394710 defendant Taslegh Simon husbandman 597587 597587 Taslegh, Simon, of Chagford, husbandman 0
5147237 2400334 2400334 defendant Caslegh (illegible) husbandman 597587 597587 Caslegh, _, of Chagford, husbandman 0
5167018 2406088 2406088 defendant Caslegh Simon husbandman 597587 597587 Caslegh, Simon, of Chagford, husbandman 0
5182243 2410560 2410560 defendant Caslegh Simon husbandman 597587 597587 Caslegh, Simon, of Chagford, husbandman 0
5203292 2416725 2416725 defendant Caslegh Simon husbandman 597587 597587 Caslegh, Simon, of Chagford, husbandman 0
5234541 2425689 2425689 defendant Fanell Thomas tailor 597587 597587 Fanell, Thomas, of Chagford, tailor 4
5296852 2444068 2444068 plaintiff Wyke John   597587 597587 Wyke, John, of Chagford 0
5315593 2449729 2449729 defendant Wyke John husbandman 597587 597587 Wyke, John, of Chagford, husbandman 0
5338410 2456588 2456588 defendant Throweston Thomas husbandman 597587 597587 Throweston, Thomas, of Chagford, husbandman 0
5338411 2456588 2456588 defendant Thewell William husbandman 597587 597587 Thewell, William, of Chagford, husbandman 1
5507449 2507224 2507224 defendant Wescote John husbandman 597587 597587 Wescote, John, of Chagford, husbandman 4
5521796 2511633 2511633 defendant Wyke John, senior husbandman 597587 597587 Wyke, John, senior, of Chagford, husbandman 0
5521797 2511633 2511633 defendant Wyke John, junior   597587 597587 Wyke, John, junior, of Chagford, groom 1
5521798 2511633 2511633 defendant Bette John smith 597587 597587 Bette, John, of Chagford, smith 2
5521799 2511633 2511633 defendant Adescote Richard mercer 597587 597587 Adescote, Richard, of Chagford, mercer 3
5521800 2511633 2511633 defendant Avery John   597587 597587 Avery, John, of Chagford, groom 4
5521801 2511633 2511633 defendant Ebbysworthy John, junior husbandman 597587 597587 Ebbysworthy, John, junior, of Chagford, husbandman 5
5521802 2511633 2511633 defendant Asshe Simon husbandman 597587 597587 Asshe, Simon, of Chagford, husbandman 6
5555943 2521732 2521732 defendant Hempston John husbandman 597587 597587 Hempston, John, of Chagford, husbandman 0
5565616 2524535 2524535 defendant Wylle John husbandman 597587 597587 Wylle, John, of Chagford, husbandman 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);