names

19 rows where place_id = 617185

✎ 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
3718259 1931996 1931996 defendant Pixe Nicholas yeoman 617185 617185 Pixe, Nicholas, of Yaldynge, yeoman 0
4008105 2027663 2027663 defendant Birchet John yeoman 617185 617185 Birchet, John, of Yaldynge, yeoman 0
4153601 2079351 2079351 defendant Tyffyn Robert tailor 617185 617185 Tyffyn, Robert, of Yaldynge, tailor 1
4171710 2085572 2085572 defendant Knates Paul yeoman 617185 617185 Knates, Paul, of Yaldynge, yeoman 0
4178350 2087900 2087900 defendant Fleete Jeremiah or Jerome clothier 617185 617185 Fleete, Jeremiah or Jerome, of Yaldynge, clothier 0
4193646 2093345 2093345 defendant Knatt Paul tailor 617185 617185 Knatt, Paul, of Yaldynge, tailor 1
4203607 2096818 2096818 defendant Maye Arthur husbandman 617185 617185 Maye, Arthur, of Yaldynge, husbandman 0
4315561 2135552 2135552 defendant Lambert Robert clothier 617185 617185 Lambert, Robert, of Yaldynge, clothier 0
4319330 2136871 2136871 defendant Skelton Stephen tailor 617185 617185 Skelton, Stephen, of Yaldynge, tailor 0
4319333 2136872 2136872 defendant Sponge William yeoman 617185 617185 Sponge, William, of Yaldynge, yeoman 0
4322851 2138060 2138060 defendant Davye John weaver 617185 617185 Davye, John, of Yaldynge, weaver 2
4325225 2138815 2138815 defendant Ferrall Stephen clothier 617185 617185 Ferrall, Stephen, of Yaldynge, clothier 0
4325227 2138816 2138816 defendant Ferrall Stephen clothier 617185 617185 Ferrall, Stephen, of Yaldynge, clothier 0
4329670 2140219 2140219 defendant Skylton Stephen tailor 617185 617185 Skylton, Stephen, of Yaldynge, tailor 0
4329671 2140219 2140219 defendant Rowland John clothier 617185 617185 Rowland, John, of Yaldynge, clothier 1
4365358 2152674 2152674 defendant Fleete Jeremiah clothier 617185 617185 Fleete, Jeremiah, of Yaldynge, clothier 0
4365359 2152674 2152674 defendant Fleete Ezechial clothier 617185 617185 Fleete, Ezechial, of Yaldynge, clothier 1
4400519 2164766 2164766 defendant Sponge William carpenter 617185 617185 Sponge, William, of Yaldynge, carpenter 0
4402481 2165414 2165414 defendant Browker Daniel bricklayer 617185 617185 Browker, Daniel, of Yaldynge, bricklayer 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);