names

20 rows where place_id = 647088

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3894371 1988335 1988335 defendant Maysterson William yeoman 647088 647088 Maysterson, William, of Nantwich, Cheshire, yeoman 0
3943344 2004790 2004790 defendant Crokett Roger   647088 647088 Crokett, Roger, of Nantwich, Cheshire, gent, son of Crokett, Robert 0
3952017 2007770 2007770 defendant Stanley Ralph mercer 647088 647088 Stanley, Ralph, of Nantwich, Cheshire, mercer 0
3957854 2009808 2009808 defendant Crockett Roger gent 647088 647088 Crockett, Roger, of Nantwich, Cheshire, gent, son of Crockett, Roger, of Nantwich, gent 1
3962777 2011569 2011569 defendant Crockett Roger gent 647088 647088 Crockett, Roger, of Nantwich, Cheshire, gent, son of Crockett, Roger, of Nantwich, gent 0
4073850 2050939 2050939 plaintiff Prattchett Richard butcher 647088 647088 Prattchett, Richard, of Nantwich, Cheshire, butcher 0
4088921 2056342 2056342 defendant Brett John goldsmith 647088 647088 Brett, John, of Nantwich, Cheshire, goldsmith 0
4096085 2058928 2058928 defendant Turvyle Brigit widow 647088 647088 Brigit his wife, alias Brigit Crockett, of Nantwich, Cheshire, widow 1
4201797 2096171 2096171 defendant Wrighte Lawrence gent 647088 647088 Wrighte, Lawrence, of Nantwich, Cheshire, gent 14
4235127 2107844 2107844 defendant Barker William dyer 647088 647088 Barker, William, of Nantwich, Cheshire, dyer 1
4235134 2107846 2107846 defendant Seckertson Randolph cutler 647088 647088 Seckertson, Randolph, of Nantwich, Cheshire, cutler 2
4238003 2108896 2108896 defendant Myles Thomas capper 647088 647088 Myles, Thomas, of Nantwich, Cheshire, capper 0
4258088 2115676 2115676 defendant Norton Dudley gent 647088 647088 Norton, Dudley, of Nantwich, Cheshire, gent 0
4267093 2118632 2118632 defendant Barker William dyer 647088 647088 Barker, William, of Nantwich, Cheshire, dyer 1
4267114 2118640 2118640 defendant Seckerston Randolph cutler 647088 647088 Seckerston, Randolph, of Nantwich, Cheshire, cutler 2
4275346 2121312 2121312 defendant Robinson Thomas yeoman 647088 647088 Robinson, Thomas, of Nantwich, Cheshire, yeoman 0
4314599 2135221 2135221 defendant Sneyde Ralph yeoman 647088 647088 Sneyde, Ralph, of Nantwich, Cheshire, yeoman 0
4327990 2139682 2139682 defendant Sneyde or Sneade Ralph yeoman 647088 647088 Sneyde or Sneade, Ralph, of Nantwich, Cheshire, yeoman 0
4353268 2148371 2148371 defendant Venables Ralph chapman 647088 647088 Venables, Ralph, of Nantwich, Cheshire, chapman 0
4700526 2265578 2265578 defendant spicer John yeoman 647088 647088 spicer, John, of Nantwich, Cheshire, yeoman 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);