names

25 rows where place_id = 597389

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628380 1903742 1903742 defendant Pynke Thomas butcher 597389 597389 Pynke, Thomas, of Watton at Stone, butcher 1
3645642 1909036 1909036 defendant Auncell William maltman 597389 597389 Auncell, William, of Watton at Stone, maltman 1
3671414 1917038 1917038 defendant Duke William maltman 597389 597389 Duke, William, of Watton at Stone, maltman 0
3686714 1921998 1921998 defendant Baker William miller 597389 597389 Baker, William, of Watton at Stone, miller 0
3686715 1921998 1921998 defendant Bydys Thomas maltman 597389 597389 Bydys, Thomas, of Watton at Stone, maltman 1
3697663 1925493 1925493 defendant Huffa John yeoman 597389 597389 Huffa, John, of Watton at Stone, yeoman 0
3697664 1925493 1925493 defendant Dardys Lawrence yeoman 597389 597389 Dardys, Lawrence, of Watton at Stone, yeoman 1
3697666 1925493 1925493 defendant Haggare Simon yeoman 597389 597389 Haggare, Simon, of Watton at Stone, yeoman 3
3699553 1926092 1926092 defendant Auncell William laborer 597389 597389 Auncell, William, of Watton at Stone, laborer 0
3699554 1926092 1926092 defendant Ramston Richard teoman 597389 597389 Ramston, Richard, of Watton at Stone, teoman 1
3699557 1926093 1926093 defendant Auncell William laborer 597389 597389 Auncell, William, of Watton at Stone, laborer 0
3699558 1926093 1926093 defendant Ramston Richard teoman 597389 597389 Ramston, Richard, of Watton at Stone, teoman 1
3810952 1961326 1961326 plaintiff Butler Philip esq 597389 597389 Butler, Philip, of Watton at Stone, esq 0
3822504 1964937 1964937 defendant Shakerley John husbandman 597389 597389 Shakerley, John, of Watton at Stone, husbandman 0
3822505 1964937 1964937 defendant Hadden John laborer 597389 597389 Hadden, John, of Watton at Stone, laborer 1
3828030 1966633 1966633 plaintiff Butler Philip   597389 597389 Butler, Philip, of Watton at Stone, knight 0
3933796 2001598 2001598 defendant Coper Robert butcher 597389 597389 Coper, Robert, of Watton at Stone, butcher 1
4148483 2077598 2077598 defendant Davye John yeoman 597389 597389 Davye, John, of Watton at Stone, yeoman 0
4909965 2329643 2329643 defendant Abell John carpenter 597389 597389 Abell, John, of Watton at Stone, carpenter 0
4997041 2355968 2355968 plaintiff Hegge Thomas   597389 597389 Hegge, Thomas, of Watton at Stone, son of the same William 2
4997042 2355968 2355968 defendant Bardes Nicholas husbandman 597389 597389 Bardes, Nicholas, of Watton at Stone, husbandman 0
4997043 2355968 2355968 defendant Dardes John husbandman 597389 597389 Dardes, John, of Watton at Stone, husbandman 1
5537637 2516261 2516261 defendant Akaster Thomas husbandman or yeoman 597389 597389 Akaster, Thomas, of Watton at Stone, husbandman or yeoman 3
5544966 2518532 2518532 defendant Nasshe John maltman 597389 597389 Nasshe, John, of Watton at Stone, maltman 2
5579913 2528798 2528798 defendant Uffa John yeoman 597389 597389 Uffa, John, of Watton at Stone, yeoman 3

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);