names

18 rows where place_id = 615290

✎ 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
3708083 1928829 1928829 defendant Lye Humphrey yeoman 615290 615290 Lye, Humphrey, of Abynger, yeoman 0
3708084 1928829 1928829 defendant Constable William husbandman 615290 615290 Constable, William, of Abynger, husbandman 1
3717595 1931797 1931797 defendant Longeherst John husbandman 615290 615290 Longeherst, John, of Abynger, husbandman 0
3792394 1955482 1955482 defendant Dalton Richard husbandman 615290 615290 Dalton, Richard, of Abynger, husbandman 1
3792395 1955482 1955482 defendant At Lee Humphrey husbandman 615290 615290 At Lee, Humphrey, of Abynger, husbandman 2
4006011 2026924 2026924 defendant Rogers John yeoman 615290 615290 Rogers, John, of Abynger, yeoman 0
4006016 2026926 2026926 defendant Rogers John yeoman 615290 615290 Rogers, John, of Abynger, yeoman 0
4224595 2104079 2104079 defendant Rownde William yeoman 615290 615290 Rownde, William, of Abynger, or of Abingeworth, yeoman 0
4241407 2110111 2110111 defendant Rownde William gent 615290 615290 Rownde, William, of Abynger, yeoman, or of Abyngeworth, gent 0
4275451 2121351 2121351 defendant Astone John yeoman 615290 615290 Astone, John, of Abynger, or of Coxe, yeoman 1
4311277 2134091 2134091 defendant Bromley Ralph yeoman 615290 615290 Bromley, Ralph, of Abynger, yeoman 0
4364146 2152232 2152232 defendant Longhurst Walter husbandman 615290 615290 Longhurst, Walter, of Abynger, husbandman 0
4364148 2152232 2152232 defendant Lylly Richard husbandman 615290 615290 Lylly, Richard, of Abynger, husbandman 2
4377545 2157046 2157046 defendant A Stone John, senior yeoman 615290 615290 A Stone, John, senior, of Abynger, yeoman 0
4377546 2157046 2157046 defendant A Stone John, junior yeoman 615290 615290 A Stone, John, junior, of Abynger, yeoman 1
4377547 2157046 2157046 defendant A Stone Thomas yeoman 615290 615290 A Stone, Thomas, of Abynger, yeoman 2
4388429 2160767 2160767 defendant Attlee Lawrence yeoman 615290 615290 Attlee, Lawrence, of Abynger, yeoman 0
4391619 2161812 2161812 defendant Shoe William husbandman 615290 615290 Shoe, William, of Abynger, husbandman 2

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);