names

20 rows where place_id = 615966

✎ 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
3711734 1929983 1929983 defendant Wey Matilda widow 615966 615966 Wey, Matilda, of Sampford Courteney, widow 3
3736825 1937770 1937770 defendant Somer William husbandman 615966 615966 Somer, William, of Sampford Courteney, husbandman 0
3811398 1961460 1961460 defendant Fouler Robert merchant 615966 615966 Fouler, Robert, of Sampford Courteney, merchant 0
3838249 1969882 1969882 defendant Tayler Thomas husbandman 615966 615966 Tayler, Thomas, of Sampford Courteney, husbandman 0
3872635 1981063 1981063 defendant Herneman Thomas husbandman 615966 615966 Herneman, Thomas, of Sampford Courteney, husbandman 0
3873115 1981223 1981223 defendant Whitebred John husbandman 615966 615966 Whitebred, John, of Sampford Courteney, husbandman 2
3873119 1981224 1981224 defendant Whytebrede John husbandman 615966 615966 Whytebrede, John, of Sampford Courteney, husbandman 2
3894600 1988403 1988403 defendant Herneman John husbandman 615966 615966 Herneman, John, of Sampford Courteney, husbandman 0
3909435 1993455 1993455 defendant Whitbrede John husbandman 615966 615966 Whitbrede, John, of Sampford Courteney, husbandman 1
4796313 2294995 2294995 defendant Stoyle John, senior smith 615966 615966 Stoyle, John, senior, of Sampford Courteney, smith 0
5215555 2420272 2420272 defendant Strepe John husbandman 615966 615966 Strepe, John, of Sampford Courteney, husbandman 0
5215556 2420272 2420272 defendant Strepe Richard   615966 615966 Strepe, Richard, of Sampford Courteney, groom 1
5220318 2421639 2421639 defendant Foleford Ivo husbandman 615966 615966 Foleford, Ivo, of Sampford Courteney, husbandman 0
5288384 2441623 2441623 defendant Skynner Joan widow 615966 615966 Skynner, Joan, of Sampford Courteney, widow 1
5288953 2441774 2441774 defendant Skynner Joan widow 615966 615966 Skynner, Joan, of Sampford Courteney, widow 1
5297280 2444196 2444196 defendant Wyke John   615966 615966 Wyke, John, of Sampford Courteney, groom 0
5355218 2461704 2461704 defendant Strepe John yeoman 615966 615966 Strepe, John, of Sampford Courteney, yeoman 0
5355219 2461704 2461704 defendant Strepe James laborer 615966 615966 Strepe, James, of Sampford Courteney, laborer 1
5483585 2500041 2500041 defendant Parys William butcher 615966 615966 Parys, William, of Sampford Courteney, butcher 0
5589453 2531703 2531703 defendant Grenecombe John husbandman 615966 615966 Grenecombe, John, of Sampford Courteney, 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);