names

15 rows where place_id = 617967

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3722131 1933184 1933184 defendant Mason William butcher 617967 617967 Mason, William, of Mydherst, butcher 2
3759600 1944992 1944992 defendant Colbroke Thomas yeoman 617967 617967 Colbroke, Thomas, of Mydherst, yeoman 0
3779135 1951197 1951197 defendant Hamlyn Thomas clothmaker 617967 617967 Hamlyn, Thomas, of Mydherst, clothmaker 1
3779136 1951197 1951197 defendant Colbroke John clothmaker 617967 617967 Colbroke, John, of Mydherst, clothmaker 2
3785778 1953341 1953341 defendant Forster John yeoman 617967 617967 Forster, John, of Mydherst, yeoman 0
3785781 1953342 1953342 defendant Gobyll Henry butcher 617967 617967 Gobyll, Henry, of Mydherst, butcher 0
3785782 1953342 1953342 defendant Flecchyng William barber 617967 617967 Flecchyng, William, of Mydherst, barber 1
3785783 1953342 1953342 defendant Kempe Thomas tailor 617967 617967 Kempe, Thomas, of Mydherst, tailor 2
3785784 1953342 1953342 defendant Ball John fuller 617967 617967 Ball, John, of Mydherst, fuller 3
3785785 1953342 1953342 defendant Bakemley Thomas husbandman 617967 617967 Bakemley, Thomas, of Mydherst, husbandman 4
3899519 1990054 1990054 plaintiff Blake Richard clothier 617967 617967 Blake, Richard, of Mydherst, clothier 0
4053349 2043574 2043574 defendant Cole Richard yeoman 617967 617967 Cole, Richard, of Mydherst, or of Ryve Parke, yeoman 0
4150204 2078205 2078205 defendant Byllyngherst Richard husbandman 617967 617967 Byllyngherst, Richard, of Mydherst, husbandman 0
5034684 2367000 2367000 defendant Janyver John smith 617967 617967 Janyver, John, of Mydherst, smith 0
5034689 2367001 2367001 defendant Janyver John smith 617967 617967 Janyver, John, of Mydherst, smith 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);