names

10 rows where place_id = 692734

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4096335 2059021 2059021 defendant Dannott William husbandman 692734 692734 Dannott, William, of Barkinge, husbandman 0
4096338 2059022 2059022 defendant Everyche Thomas husbandman 692734 692734 Everyche, Thomas, of Barkinge, husbandman 1
4242192 2110381 2110381 defendant Sackvyle Edward gent 692734 692734 Sackvyle, Edward, of Barkinge, gent 1
4279841 2122865 2122865 defendant Blanchard William yeoman 692734 692734 Blanchard, William, of Barkinge, yeoman 2
4279842 2122865 2122865 defendant Lewinge John yeoman 692734 692734 Lewinge, John, of Barkinge, yeoman 3
4280060 2122936 2122936 defendant Lowinge John yeoman 692734 692734 Lowinge, John, of Barkinge, yeoman 2
4323497 2138279 2138279 defendant Burr John Essex, gent 692734 692734 Burr John, of Barkinge, Essex, gent 1
4332400 2141127 2141127 defendant Smythe Robert yeoman 692734 692734 Smythe, Robert, of Barkinge, yeoman 1
4358399 2150171 2150171 defendant Powncett Henry gent 692734 692734 Powncett, Henry, of Barkinge, gent 0
4358400 2150171 2150171 defendant Allen Henry husbandman 692734 692734 Allen, Henry, of Barkinge, 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);