names

22 rows where place_id = 668414

✎ 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
3989025 2020817 2020817 defendant Chapman Thomas butcher 668414 668414 Chapman, Thomas, of Hadleighe, butcher 0
3994926 2022936 2022936 defendant Markam George carrier 668414 668414 Markam, George, of Hadleighe, carrier 1
3999322 2024517 2024517 defendant Scrivener Mathew ashburner 668414 668414 Scrivener, Mathew, of Hadleighe, ashburner 0
4001884 2025448 2025448 defendant Scryvener Robert husbandman 668414 668414 Scryvener, Robert, of Hadleighe, husbandman 0
4007261 2027376 2027376 defendant Swynborne Henry yeoman 668414 668414 Swynborne, Henry, of Hadleighe, yeoman 0
4015449 2030222 2030222 defendant Hillary Robert gent 668414 668414 Hillary, Robert, of Hadleighe, gent 0
4015792 2030332 2030332 defendant Cooke Robert (legal representative) 668414 668414 Cooke, Robert, of Hadleighe, yeoman, executors of 0
4114969 2065643 2065643 defendant Smyth John clothier 668414 668414 Smyth, John, of Hadleighe, clothier 1
4114970 2065643 2065643 defendant Weste William clothier 668414 668414 Weste, William, of Hadleighe, clothier 2
4144453 2076222 2076222 defendant Gosse Edward   668414 668414 Gosse, Edward, of Hadleighe, "purrell" drawer 1
4166817 2083890 2083890 defendant Gale William clothier 668414 668414 Gale, William, of Hadleighe, clothier 0
4175009 2086726 2086726 defendant Byrde William sherman 668414 668414 Byrde, William, of Hadleighe, sherman 0
4235142 2107849 2107849 defendant Grene Henry carrier 668414 668414 Grene, Henry, of Hadleighe, carrier 2
4241183 2110039 2110039 defendant Hatch John butcher 668414 668414 Hatch, John, of Hadleighe, butcher 0
4241966 2110303 2110303 defendant Wilson Daniel   668414 668414 Wilson, Daniel, of Hadleighe weaver 3
4281364 2123389 2123389 defendant Woodward Thomas   668414 668414 Woodward, Thomas, of Hadleighe 0
4292224 2127287 2127287 defendant Andrewe Robert draper 668414 668414 Andrewe, Robert, of Hadleighe, draper 0
4292228 2127288 2127288 defendant Gale William clothier 668414 668414 Gale, William, of Hadleighe, clothier 0
4294193 2127999 2127999 defendant Goldinge Alexander, junior cutler 668414 668414 Goldinge, Alexander, junior, of Hadleighe, cutler 3
4323083 2138133 2138133 defendant Andrewe Robert draper 668414 668414 Andrewe, Robert, of Hadleighe, draper 0
4332670 2141212 2141212 defendant Micklefeild John barber 668414 668414 Micklefeild, John, of Hadleighe, barber 0
4339560 2143605 2143605 defendant Thurston Robert yeoman 668414 668414 Thurston, Robert, of Hadleighe, yeoman 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);