names

40 rows where place_id = 588631

✎ 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
3595105 1866099 1866099 defendant Palmer Richard yeoman 588631 588631 Palmer, Richard, of Kentysbeare, yeoman 3
3646565 1909326 1909326 defendant Broke John, junior husbandman 588631 588631 Broke, John, junior, of Kentysbeare, husbandman 2
3683941 1921111 1921111 defendant Newton Henry dyer 588631 588631 Newton, Henry, of Kentysbeare, dyer 2
3699122 1925935 1925935 plaintiff Whytyng William merchant 588631 588631 Whytyng, William, of Kentysbeare, merchant 0
3712686 1930284 1930284 plaintiff Whytyng William merchant 588631 588631 Whytyng, William, of Kentysbeare, merchant 0
3731075 1935945 1935945 defendant Slade Margaret widow 588631 588631 Slade, Margaret, of Kentysbeare, widow 2
3745655 1940548 1940548 defendant Slade Margaret widow 588631 588631 Slade, Margaret, of Kentysbeare, widow 2
3755122 1943550 1943550 defendant Hert John husbandman 588631 588631 Hert, John, of Kentysbeare, husbandman 0
3758563 1944675 1944675 defendant Slade Margaret widow 588631 588631 Slade, Margaret, of Kentysbeare, widow 2
3766349 1947130 1947130 defendant Tyllard John husbandman 588631 588631 Tyllard, John, of Kentysbeare, husbandman 0
3776954 1950536 1950536 defendant Alway Thomas husbandman 588631 588631 Alway, Thomas, of Kentysbeare, husbandman 0
3794319 1956099 1956099 defendant Alway Thomas husbandman 588631 588631 Alway, Thomas, of Kentysbeare, husbandman 0
3803802 1959104 1959104 defendant Grene John butcher 588631 588631 Grene, John, of Kentysbeare, butcher 0
3807220 1960155 1960155 plaintiff Whytyng William   588631 588631 Whytyng, William, of Kentysbeare 0
3807223 1960156 1960156 plaintiff Whytyng William   588631 588631 Whytyng, William, of Kentysbeare 0
3824782 1965626 1965626 plaintiff Whytyng William merchant 588631 588631 Whytyng, William, of Kentysbeare, merchant 0
3824784 1965627 1965627 plaintiff Whytyng William merchant 588631 588631 Whytyng, William, of Kentysbeare, merchant 0
3856098 1975530 1975530 defendant Grene John husbandman 588631 588631 Grene, John, of Kentysbeare, husbandman 0
3856099 1975530 1975530 defendant Hacke Thomas husbandman 588631 588631 Hacke, Thomas, of Kentysbeare, husbandman 1
3856100 1975530 1975530 defendant Grene Thomas yeoman 588631 588631 Grene, Thomas, of Kentysbeare, yeoman 2
3856101 1975530 1975530 defendant Stapull John yeoman 588631 588631 Stapull, John, of Kentysbeare, yeoman 3
3870069 1980231 1980231 plaintiff Whytyng William merchant 588631 588631 Whytyng, William, of Kentysbeare, merchant 0
3873246 1981268 1981268 defendant Alway Thomas husbandman 588631 588631 Alway, Thomas, of Kentysbeare, husbandman 0
3889660 1986775 1986775 defendant Tyllard Humphrey yeoman 588631 588631 Tyllard, Humphrey, of Kentysbeare, yeoman 0
3931597 2000863 2000863 defendant Passemore John husbandman 588631 588631 Passemore, John, of Kentysbeare, husbandman 0
3995747 2023225 2023225 defendant Tyllard Anthony husbandman 588631 588631 Tyllard, Anthony, of Kentysbeare, husbandman 0
4017400 2030928 2030928 defendant Tyllard Anthony butcher 588631 588631 Tyllard, Anthony, of Kentysbeare, butcher 0
4144159 2076120 2076120 defendant Lane Walter husbandman 588631 588631 Lane, Walter, of Kentysbeare, husbandman 0
4144160 2076120 2076120 defendant Odes John husbandman 588631 588631 Odes, John, of Kentysbeare, husbandman 1
4900398 2326765 2326765 defendant Wylsshe John gent 588631 588631 Wylsshe, John, of Kentysbeare, gent 0
4946593 2340930 2340930 defendant Rowe John tucker 588631 588631 Rowe, John, of Kentysbeare, tucker 4
4992230 2354568 2354568 defendant Broke Ralph yeoman 588631 588631 Broke, Ralph, of Kentysbeare, yeoman 0
5037391 2367805 2367805 defendant Broke Ralph yeoman 588631 588631 Broke, Ralph, of Kentysbeare, yeoman 1
5061023 2374871 2374871 defendant Wotton William husbandman 588631 588631 Wotton, William, of Kentysbeare, husbandman 4
5224720 2422900 2422900 defendant Meryfeld John gent 588631 588631 Meryfeld, John, of Kentysbeare, gent 0
5228785 2424030 2424030 defendant Hake Thomas husbandman 588631 588631 Hake, Thomas, of Kentysbeare, husbandman 0
5264098 2434529 2434529 defendant Touker Richard tucker 588631 588631 Touker, Richard, of Kentysbeare, tucker 0
5310244 2448098 2448098 defendant Style John husbandman 588631 588631 Style, John, of Kentysbeare, husbandman 0
5409400 2477778 2477778 defendant Bowdeney Nicholas husbandman 588631 588631 Bowdeney, Nicholas, of Kentysbeare, husbandman 1
5483421 2499989 2499989 defendant Palmer John husbandman 588631 588631 Palmer, John, of Kentysbeare, husbandman 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);