names

43 rows where place_id = 599868

✎ 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
3638601 1906887 1906887 defendant Eye William yeoman 599868 599868 Eye, William, of Barstable, Devon, yeoman 0
3687760 1922338 1922338 defendant Pensale John chapman 599868 599868 Pensale, John, of Barstable, Devon, chapman 0
3687764 1922339 1922339 defendant Mannyng John chapman 599868 599868 Mannyng, John, of Barstable, Devon, chapman 2
3687785 1922344 1922344 defendant Mannyng John chapman 599868 599868 Mannyng, John, of Barstable, Devon, chapman 3
3724607 1933978 1933978 defendant Manfeld John, senior yeoman 599868 599868 Manfeld, John, senior, of Barstable, Devon, yeoman 0
3727366 1934833 1934833 defendant Champneys Peter mercer 599868 599868 Champneys, Peter, of Barstable, Devon, mercer 0
3729630 1935516 1935516 defendant Thomas Robert tanner 599868 599868 Thomas, Robert, of Barstable, Devon, tanner 0
3730343 1935722 1935722 defendant Brytt Alexander gent 599868 599868 Brytt, Alexander, of Barstable, Devon, gent 0
3730368 1935732 1935732 defendant Brytt Alexander gent 599868 599868 Brytt, Alexander, of Barstable, Devon, gent 0
3738701 1938312 1938312 defendant Brytte Alexander gent 599868 599868 Brytte, Alexander, of Barstable, Devon, gent 0
3740519 1938894 1938894 defendant Manfyld John, senior yeoman 599868 599868 Manfyld, John, senior, of Barstable, Devon, yeoman 0
3743006 1939661 1939661 defendant Champneys Peter mercer 599868 599868 Champneys, Peter, of Barstable, Devon, mercer 0
3786231 1953490 1953490 defendant Heydon Richard gent 599868 599868 Heydon, Richard, of Barstable, Devon, gent 0
3806490 1959944 1959944 defendant Champneys Peter mercer 599868 599868 Champneys, Peter, of Barstable, Devon, mercer 0
3834455 1968724 1968724 defendant Brett Alexander gent 599868 599868 Brett, Alexander, of Barstable, Devon, gent 0
3860717 1977076 1977076 defendant Downe Elias yeoman 599868 599868 Downe, Elias, of Barstable, Devon, yeoman 1
3860720 1977077 1977077 defendant Downe Elias yeoman 599868 599868 Downe, Elias, of Barstable, Devon, yeoman 1
3880998 1983914 1983914 defendant Bury John merchant 599868 599868 Bury, John, of Barstable, Devon, merchant 3
3970871 2014385 2014385 defendant Bryght Henry merchant 599868 599868 Bryght, Henry, of Barstable, Devon, merchant 1
3972146 2014819 2014819 defendant Bright William chapman 599868 599868 Bright, William, of Barstable, Devon, chapman 0
4077229 2052141 2052141 defendant Askott Richard   599868 599868 Askott, Richard, of Barstable, Devon 0
4085824 2055205 2055205 defendant Meriwether James   599868 599868 Meriwether, James, of Barstable, Devon, hat maker 0
4091852 2057379 2057379 defendant Ascott William chapman 599868 599868 Ascott, William, of Barstable, Devon, chapman 1
4091854 2057380 2057380 defendant Ascott William chapman 599868 599868 Ascott, William, of Barstable, Devon, chapman 0
4099143 2060020 2060020 defendant Ascott William chapman 599868 599868 Ascott, William, of Barstable, Devon, chapman 0
4099146 2060021 2060021 defendant Ascotte William chapman 599868 599868 Ascotte, William, of Barstable, Devon, chapman 0
4108673 2063357 2063357 defendant Askott William mercer 599868 599868 Askott, William, of Barstable, Devon, mercer 1
4116992 2066378 2066378 defendant Hayne Thomas goldsmith 599868 599868 Hayne, Thomas, of Barstable, Devon, goldsmith 0
4130304 2071152 2071152 defendant Brasyer John merchant 599868 599868 Brasyer, John, of Barstable, Devon, merchant 0
4130322 2071156 2071156 defendant Rashley Peter clothier 599868 599868 Rashley, Peter, of Barstable, Devon, clothier 3
4193443 2093272 2093272 defendant Welshe Richard chapman 599868 599868 Welshe, Richard, of Barstable, Devon, chapman 0
4196685 2094387 2094387 defendant Peryse or Peyse William retailer 599868 599868 Peryse or Peyse, William, of Barstable, Devon, merchant, retailer 0
4201470 2096060 2096060 defendant Brasyer Richard merchant 599868 599868 Brasyer, Richard, of Barstable, Devon, merchant 0
4201472 2096061 2096061 defendant Rashley Peter clothier 599868 599868 Rashley, Peter, of Barstable, Devon, clothier 0
4233760 2107332 2107332 defendant Collener Peter mariner 599868 599868 Collener, Peter, of Barstable, Devon, mariner 1
4263196 2117356 2117356 defendant Sparrowe James chapman 599868 599868 Sparrowe, James, of Barstable, Devon, chapman 0
4290416 2126630 2126630 defendant Norris John merchant 599868 599868 Norris, John, of Barstable, Devon, merchant 0
4348019 2146560 2146560 defendant Downe Fulk chapman 599868 599868 Downe, Fulk, of Barstable, Devon, chapman 0
4366404 2153026 2153026 defendant Norris John merchant 599868 599868 Norris, John, of Barstable, Devon, merchant 0
4371903 2155012 2155012 defendant Downe Fulk chapman 599868 599868 Downe, Fulk, of Barstable, Devon, chapman 0
4378013 2157208 2157208 defendant Martham alias Morecombe William gent 599868 599868 Martham alias Morecombe, William, of Barstable, Devon, gent 0
4389267 2161037 2161037 defendant Deyman John chapman 599868 599868 Deyman, John, of Barstable, Devon, chapman 0
5374719 2467690 2467690 defendant Rogers William merchant 599868 599868 Rogers, William, of Barstable, Devon, merchant 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);