names

17 rows where place_id = 662519

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3965251 2012460 2012460 plaintiff Barnebye John yeoman 662519 662519 Barnebye, John, of Waltham, Essex, yeoman 0
4035316 2037304 2037304 defendant Tanner alias Adams John yeoman 662519 662519 Tanner alias Adams, John, of Waltham, Essex, yeoman 0
4385591 2159865 2159865 defendant Longworth George chapman 662519 662519 Longworth, George, of Waltham, Essex, chapman 0
4397203 2163639 2163639 defendant Throwgood John gent 662519 662519 Throwgood, John, of Waltham, Essex, gent 0
4398943 2164229 2164229 defendant Garton John yeoman 662519 662519 Garton, John, of Waltham, Essex, yeoman 0
4511333 2203990 2203990 defendant Fuller John   662519 662519 Fuller, John, of Waltham, Essex, tailor, son of John 0
4828991 2305110 2305110 defendant Hebbage William   662519 662519 Hebbage, William, of Waltham, Essex, parson 0
4845962 2310243 2310243 defendant Bataille William tiler 662519 662519 Bataille, William, of Waltham, Essex, tiler 3
4870124 2317622 2317622 defendant Plummer William plumber 662519 662519 Plummer, William, of Waltham, Essex, plumber 1
4984391 2352262 2352262 defendant Barbour alias Okeel Richard brewer 662519 662519 Barbour alias Okeel, Richard, of Waltham, Essex, brewer 1
5136505 2397192 2397192 defendant Kerb John hostiller 662519 662519 Kerb, John, of Waltham, Essex, hostiller 0
5251412 2430540 2430540 defendant Hogge Thomas butcher or collier 662519 662519 Hogge, Thomas, of Waltham, Essex, butcher or collier 0
5279887 2439195 2439195 defendant Bryggys Richard husbandman 662519 662519 Bryggys, Richard, of Waltham, Essex, husbandman 3
5279893 2439196 2439196 defendant Bryggys Richard husbadman 662519 662519 Bryggys, Richard, of Waltham, Essex, husbadman 3
5282868 2440049 2440049 defendant Warner John esq 662519 662519 Warner, John, of Waltham, Essex, esq 0
5504375 2506284 2506284 defendant Arnewey Thomas yeoman 662519 662519 Arnewey, Thomas, of Waltham, Essex, yeoman 1
5529656 2513775 2513775 defendant Forthe Nicholas hosier 662519 662519 Forthe, Nicholas, of Waltham, Essex, hosier 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);