names

35 rows where place_id = 586388

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588600 1864079 1864079 defendant Broccas George gent 586388 586388 Broccas, George, of Stoke Hamond, gent 0
3671674 1917127 1917127 defendant James John yeoman 586388 586388 James, John, of Stoke Hamond, yeoman 0
3684269 1921214 1921214 defendant James John yeoman 586388 586388 James, John, of Stoke Hamond, yeoman 0
3684270 1921214 1921214 defendant Hawkyns Thomas husbandman 586388 586388 Hawkyns, Thomas, of Stoke Hamond, husbandman 1
3684271 1921214 1921214 defendant Crosseley Robert laborer 586388 586388 Crosseley, Robert, of Stoke Hamond, laborer 2
3684272 1921214 1921214 defendant Hawkyns William laborer 586388 586388 Hawkyns, William, of Stoke Hamond, laborer 3
3764791 1946653 1946653 defendant Cowper Ralph clerk 586388 586388 Cowper, Ralph, of Stoke Hamond, clerk 1
3764792 1946653 1946653 defendant Merydale Hugh husbandman 586388 586388 Merydale, Hugh, of Stoke Hamond, husbandman 2
3764793 1946653 1946653 defendant Frankeleyn Thomas husbandman 586388 586388 Frankeleyn, Thomas, of Stoke Hamond, husbandman 3
3803560 1959021 1959021 defendant Cowper Ralph clerk 586388 586388 Cowper, Ralph, of Stoke Hamond, clerk 0
3820729 1964373 1964373 defendant Couper Ralph clerk 586388 586388 Couper, Ralph, of Stoke Hamond, clerk 0
3820730 1964373 1964373 defendant Grene Thomas laborer 586388 586388 Grene, Thomas, of Stoke Hamond, laborer 1
3854560 1975070 1975070 defendant Colsyll Thomas yeoman 586388 586388 Colsyll, Thomas, of Stoke Hamond, yeoman 0
3917866 1996336 1996336 defendant James John yeoman 586388 586388 James, John, of Stoke Hamond, yeoman 0
3917867 1996336 1996336 defendant James Humphrey yeoman 586388 586388 James, Humphrey, of Stoke Hamond, yeoman 1
4018183 2031226 2031226 defendant Kyrke Edward yeoman 586388 586388 Kyrke, Edward, of Stoke Hamond, yeoman 0
4510787 2203832 2203832 defendant Hap_ Alice   586388 586388 Hap_, Alice, of Stoke Hamond 0
4554222 2217247 2217247 defendant Mulward Henry   586388 586388 Mulward, Henry, of Stoke Hamond 1
4567621 2221440 2221440 defendant Bowear John   586388 586388 Bowear, John, of Stoke Hamond, parson 0
4567631 2221441 2221441 defendant Bowear John   586388 586388 Bowear, John, of Stoke Hamond, parson 0
4614485 2235537 2235537 defendant Dytton John   586388 586388 Dytton, John, of Stoke Hamond 0
4713899 2269672 2269672 defendant Fraunkeleyn Henry husbandman 586388 586388 Fraunkeleyn, Henry, of Stoke Hamond, husbandman 0
4732813 2275440 2275440 defendant Watkyns William (legal representative) 586388 586388 Watkyns, William, of Stoke Hamond, executors of 0
4966982 2347054 2347054 defendant Frankeleyn Henry yeoman 586388 586388 Frankeleyn, Henry, of Stoke Hamond, yeoman 0
4974401 2349306 2349306 defendant Watkyns John gent 586388 586388 Watkyns, John, of Stoke Hamond, gent 0
5023930 2363910 2363910 defendant Lord John husbandman 586388 586388 Lord, John, of Stoke Hamond, husbandman 1
5082810 2381365 2381365 defendant Frankeleyn Henry husbandman 586388 586388 Frankeleyn, Henry, of Stoke Hamond, husbandman 0
5118371 2391809 2391809 defendant Tommys Richard husbandman 586388 586388 Tommys, Richard, of Stoke Hamond, husbandman 1
5118372 2391809 2391809 defendant Frankeleyn Henry husbandman 586388 586388 Frankeleyn, Henry, of Stoke Hamond, husbandman 2
5294243 2443286 2443286 defendant Frankleyn William husbandman 586388 586388 Frankleyn, William, of Stoke Hamond, husbandman 1
5351335 2460515 2460515 defendant Daunger Henry carpenter 586388 586388 Daunger, Henry, of Stoke Hamond, carpenter 0
5493495 2502967 2502967 defendant Colman Henry husbandman 586388 586388 Colman, Henry, of Stoke Hamond, husbandman 0
5507123 2507136 2507136 defendant Ryot Andrew clerk 586388 586388 Ryot, Andrew, of Stoke Hamond, clerk 2
5507128 2507137 2507137 defendant Riot Andrew clerk 586388 586388 Riot, Andrew, of Stoke Hamond, clerk 2
5559339 2522697 2522697 defendant Parnam William husbandman 586388 586388 Parnam, William, of Stoke Hamond, husbandman 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);