names

32 rows where place_id = 703392

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4147456 2077250 2077250 defendant Payne Simon tucker 703392 703392 Payne, Simon, of Pilton, tucker 3
4223631 2103753 2103753 defendant Cooke alias Best John fuller 703392 703392 Cooke alias Best, John, of Pilton, fuller 2
4228267 2105369 2105369 defendant Downe Katherine widow 703392 703392 Downe, Katherine, of Pilton, widow 0
4290702 2126734 2126734 defendant Vernehame William husbandman 703392 703392 Vernehame, William, of Pilton, husbandman 0
4302493 2130991 2130991 defendant Chaldon William miller 703392 703392 Chaldon, William, of Pilton, miller 1
4333089 2141353 2141353 defendant Hill John miller 703392 703392 Hill, John, of Pilton, miller 1
4334353 2141766 2141766 defendant Horwoode John husbandman 703392 703392 Horwoode, John, of Pilton, husbandman 1
4341894 2144441 2144441 defendant Vellacotte Anthony (legal representative) 703392 703392 Vellacotte, Anthony, of Pilton, Devon, sailor, executors of 0
4347575 2146398 2146398 defendant Cobcraft Miles   703392 703392 Cobcraft, Miles, of Pilton, card maker 0
4381760 2158579 2158579 defendant Brooke John husbandman 703392 703392 Brooke, John, of Pilton, husbandman 0
4382318 2158786 2158786 defendant Reves James butcher 703392 703392 Reves, James, of Pilton, butcher 0
4529868 2209628 2209628 defendant Hayne William   703392 703392 Hayne, William, of Pilton 0
4584235 2226482 2226482 defendant Reynold Athelman   703392 703392 Reynold, Athelman, of Pilton 3
4597159 2230352 2230352 plaintiff Sely William   703392 703392 Sely, William, of Pilton 0
4681774 2259912 2259912 defendant Hamond Simon smith 703392 703392 Hamond, Simon, of Pilton, smith 0
4696796 2264476 2264476 defendant Hoper John husbandman 703392 703392 Hoper, John, of Pilton, husbandman 0
4710895 2268764 2268764 defendant Stevenes John husbandman 703392 703392 Stevenes, John, of Pilton, husbandman 0
4792200 2293649 2293649 defendant Cornysshe John husbandman 703392 703392 Cornysshe, John, of Pilton, husbandman 0
4796498 2295062 2295062 defendant Campion John clater 703392 703392 Campion, John, of Pilton, clater 1
4857391 2313700 2313700 defendant Stone William husbandman 703392 703392 Stone, William, of Pilton, husbandman 1
4874408 2318938 2318938 defendant Styuecle Robert drover 703392 703392 Styuecle, Robert, of Pilton, drover 0
4917439 2331968 2331968 defendant Caddebury Walter husbandman 703392 703392 Caddebury, Walter, of Pilton, husbandman 2
4934440 2337164 2337164 defendant Hamond Thomas carrier 703392 703392 Hamond, Thomas, of Pilton, carrier 1
5014928 2361243 2361243 defendant Pilton Henry husbandman 703392 703392 Pilton, Henry, of Pilton, husbandman 1
5023078 2363657 2363657 defendant White Ralph smith 703392 703392 White, Ralph, of Pilton, smith 1
5023079 2363657 2363657 defendant Shipman William tucker 703392 703392 Shipman, William, of Pilton, tucker 2
5023080 2363657 2363657 defendant Horigge Thomas smith 703392 703392 Horigge, Thomas, of Pilton, smith 3
5068439 2377060 2377060 defendant Webber John chaplain 703392 703392 Webber, John, of Pilton, chaplain 1
5092899 2384307 2384307 plaintiff Phylypp John   703392 703392 Phylypp, John, of Pilton 0
5092902 2384308 2384308 plaintiff Phylypp John   703392 703392 Phylypp, John, of Pilton 0
5338230 2456524 2456524 defendant Piers John miller 703392 703392 Piers, John, of Pilton, miller 0
5610627 2547050 2547050 defendant Taillour Walter   703392 703392 Taillour, Walter, of Pilton 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);