names

12 rows where place_id = 671162

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4000393 2024908 2024908 defendant Leke John yeoman 671162 671162 Leke, John, of Dallington, yeoman 2
4034931 2037169 2037169 defendant Clawell John fuller 671162 671162 Clawell, John, of Dallington, fuller 1
4035249 2037285 2037285 defendant Clawell John fuller 671162 671162 Clawell, John, of Dallington, fuller 1
4128969 2070660 2070660 defendant Rabbett James husbandman 671162 671162 Rabbett, James, of Dallington, husbandman 0
4128971 2070661 2070661 defendant Rabbett James husbandman 671162 671162 Rabbett, James, of Dallington, husbandman 0
4175359 2086850 2086850 defendant Herne William yeoman 671162 671162 Herne, William, of Dallington, yeoman 0
4243107 2110685 2110685 defendant Tuttye William yeoman 671162 671162 Tuttye, William, of Dallington, yeoman 2
4266871 2118562 2118562 defendant Add alias Bunton John collier 671162 671162 Add alias Bunton, John, of Dallington, collier 1
4271987 2120199 2120199 defendant Kyngeswell Richard tailor 671162 671162 Kyngeswell, Richard, of Dallington, tailor 0
4366717 2153144 2153144 defendant Feild or Affeild James yeoman 671162 671162 Feild or Affeild, James, of Dallington, yeoman 0
4378495 2157380 2157380 defendant James Robert tailor 671162 671162 James, Robert, of Dallington, tailor 0
4389786 2161207 2161207 defendant Glidd Henry yeoman 671162 671162 Glidd, Henry, of Dallington, yeoman 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);