names

18 rows where place_id = 588226

✎ 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
3593783 1865692 1865692 defendant Harry Michael husbandman 588226 588226 Harry, Michael, of Kenerton, husbandman 0
3610136 1870834 1870834 defendant Davy John yeoman 588226 588226 Davy, John, of Kenerton, yeoman 0
3610140 1870835 1870835 defendant Davy John yeoman 588226 588226 Davy, John, of Kenerton, yeoman 1
3745172 1940395 1940395 defendant Hollokys John yeoman 588226 588226 Hollokys, John, of Kenerton, yeoman 0
4078329 2052549 2052549 defendant Pyper Edward husbandman 588226 588226 Pyper, Edward, of Kenerton, husbandman 1
5013305 2360730 2360730 plaintiff atte Regge Thomas   588226 588226 atte Regge, Thomas, of Kenerton 0
5245885 2428958 2428958 defendant Gerveys John weaver 588226 588226 Gerveys, John, of Kenerton, weaver 3
5302691 2445784 2445784 defendant Godard Thomas butcher 588226 588226 Godard, Thomas, of Kenerton, butcher 1
5354944 2461617 2461617 defendant Parrok Roger husbandman 588226 588226 Parrok, Roger, of Kenerton, husbandman 1
5354947 2461618 2461618 defendant White Alan husbandman 588226 588226 White, Alan, of Kenerton, husbandman 1
5391703 2472701 2472701 defendant Elys Stephen fuller 588226 588226 Elys, Stephen, of Kenerton, fuller 0
5393715 2473263 2473263 defendant Strogyll Thomas tailor 588226 588226 Strogyll, Thomas, of Kenerton, tailor 3
5417861 2480270 2480270 defendant Elys Stephen   588226 588226 Elys, Stephen, of Kenerton 0
5430791 2484147 2484147 defendant Davy John yeoman 588226 588226 Davy, John, of Kenerton, yeoman 0
5447398 2489111 2489111 defendant Davy Henry yeoman 588226 588226 Davy, Henry, of Kenerton, yeoman 0
5451301 2490263 2490263 defendant Barrey Richard glover 588226 588226 Barrey, Richard, of Kenerton, glover 0
5459851 2492875 2492875 defendant Davy John yeoman 588226 588226 Davy, John, of Kenerton, yeoman 0
5471520 2496431 2496431 defendant Davy John yeoman 588226 588226 Davy, John, of Kenerton, yeoman 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);