names

30 rows where place_id = 588231

✎ 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
3593799 1865699 1865699 defendant Atkyns John yeoman 588231 588231 Atkyns, John, of Ilfercombe, yeoman 0
3694794 1924578 1924578 defendant Flemyng Walter husbandman 588231 588231 Flemyng, Walter, of Ilfercombe, husbandman 4
3724146 1933836 1933836 defendant Markshowe William husbandman 588231 588231 Markshowe, William, of Ilfercombe, husbandman 0
3724147 1933836 1933836 defendant Nycoll Thomas   588231 588231 Nycoll, Thomas, of Ilfercombe, parish clerk 1
3733377 1936673 1936673 defendant Snoo John husbandman 588231 588231 Snoo, John, of Ilfercombe, husbandman 0
3733378 1936673 1936673 defendant Whythere Robert husbandman 588231 588231 Whythere, Robert, of Ilfercombe, husbandman 1
3742005 1939368 1939368 defendant Atkey Mathew husbandman 588231 588231 Atkey, Mathew, of Ilfercombe, husbandman 1
3746101 1940688 1940688 defendant Wolffe Thomas gent 588231 588231 Wolffe, Thomas, of Ilfercombe, gent 0
3746614 1940857 1940857 defendant Cotes John husbandman 588231 588231 Cotes, John, of Ilfercombe, husbandman 0
3746615 1940857 1940857 defendant Cotes Salome widow 588231 588231 Cotes, Salome, of Ilfercombe, widow 1
3759240 1944879 1944879 defendant Wolffe Thomas gent 588231 588231 Wolffe, Thomas, of Ilfercombe, gent 0
3770704 1948519 1948519 defendant Hockyng John husbandman 588231 588231 Hockyng, John, of Ilfercombe, husbandman 1
3791622 1955220 1955220 defendant Thorne John carpenter 588231 588231 Thorne, John, of Ilfercombe, carpenter 2
3815600 1962794 1962794 defendant Denys William husbandman 588231 588231 Denys, William, of Ilfercombe, husbandman 0
3838758 1970050 1970050 defendant Cornysshe John merchant 588231 588231 Cornysshe, John, of Ilfercombe, merchant 1
3854260 1974969 1974969 defendant Cole Roger husbandman 588231 588231 Cole, Roger, of Ilfercombe, husbandman 0
3854261 1974969 1974969 defendant Burges Ralph husbandman 588231 588231 Burges, Ralph, of Ilfercombe, husbandman 1
3856225 1975567 1975567 defendant Bere Thomas husbandman 588231 588231 Bere, Thomas, of Ilfercombe, husbandman 0
3860320 1976953 1976953 defendant Hertnall Robert husbandman 588231 588231 Hertnall, Robert, of Ilfercombe, husbandman 0
3883794 1984847 1984847 defendant Kayle John, junior yeoman 588231 588231 Kayle, John, junior, of Ilfercombe, yeoman 0
3939458 2003502 2003502 defendant Cornysshe William tailor 588231 588231 Cornysshe, William, of Ilfercombe, tailor 0
4468936 2190962 2190962 plaintiff Berton Thomas   588231 588231 Berton, Thomas, of Ilfercombe, parson 0
4790770 2293199 2293199 defendant Waye Thomas mariner 588231 588231 Waye, Thomas, of Ilfercombe, mariner 5
4790771 2293199 2293199 defendant Hoper John mariner 588231 588231 Hoper, John, of Ilfercombe, mariner 6
4812710 2300088 2300088 defendant Strete John yeoman 588231 588231 Strete, John, of Ilfercombe, yeoman 4
4822623 2303152 2303152 defendant Aunsell John fisher 588231 588231 Aunsell, John, of Ilfercombe, fisher 0
5092901 2384307 2384307 defendant Wyntell Henry mariner 588231 588231 Wyntell, Henry, of Ilfercombe, mariner 1
5092904 2384308 2384308 defendant Wyntell Henry mariner 588231 588231 Wyntell, Henry, of Ilfercombe, mariner 1
5134602 2396611 2396611 defendant Carpenter Richard merchant 588231 588231 Carpenter, Richard, of Ilfercombe, merchant 0
5285893 2440889 2440889 defendant Garlond John gent 588231 588231 Garlond, John, of Ilfercombe, gent 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);