names

25 rows where place_id = 665791

✎ 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
3978416 2017036 2017036 defendant Jenkynson Thomas husbandman 665791 665791 Jenkynson, Thomas, of Heckington, husbandman 2
4121126 2067848 2067848 defendant Grantham Thomas gent 665791 665791 Grantham, Thomas, of Heckington, gent 0
4127761 2070220 2070220 defendant Garland John husbandman 665791 665791 Garland, John, of Heckington, husbandman 0
4132498 2071939 2071939 defendant Pope John husbandman 665791 665791 Pope, John, of Heckington, husbandman 1
4136796 2073510 2073510 defendant Hale Robert laborer 665791 665791 Hale, Robert, of Heckington, laborer 0
4136859 2073532 2073532 defendant Doughty Richard carpenter 665791 665791 Doughty, Richard, of Heckington, carpenter 0
4136860 2073532 2073532 defendant Hedley William carpenter 665791 665791 Hedley, William, of Heckington, carpenter 1
4148425 2077580 2077580 defendant Foster William yeoman 665791 665791 Foster, William, of Heckington, yeoman 0
4175220 2086795 2086795 defendant Cawtheren George yeoman 665791 665791 Cawtheren, George, of Heckington, yeoman 0
4175222 2086796 2086796 defendant Foster Daniel yeoman 665791 665791 Foster, Daniel, of Heckington, yeoman 0
4177320 2087540 2087540 defendant Fyske Robert yeoman 665791 665791 Fyske, Robert, of Heckington, yeoman 1
4183074 2089563 2089563 defendant Cawdron Anthony esq 665791 665791 Cawdron, Anthony, of Heckington, esq 0
4234210 2107500 2107500 defendant Sawle William yeoman 665791 665791 Sawle, William, of Heckington, yeoman 1
4242806 2110585 2110585 defendant Sawle William yeoman 665791 665791 Sawle, William, of Heckington, yeoman 1
4256736 2115226 2115226 defendant Everytt Miles yeoman 665791 665791 Everytt, Miles, of Heckington, yeoman 0
4274975 2121200 2121200 defendant Foster William yeoman 665791 665791 Foster, William, of Heckington, yeoman 0
4277436 2122029 2122029 defendant Grantham Thomas gent 665791 665791 Grantham, Thomas, of Heckington, gent 0
4278653 2122467 2122467 defendant Pett Robert yeoman 665791 665791 Pett, Robert, of Heckington, yeoman 0
4278655 2122468 2122468 defendant Sawle William yeoman 665791 665791 Sawle, William, of Heckington, yeoman 0
4279058 2122605 2122605 defendant Pell Robert husbandman 665791 665791 Pell, Robert, of Heckington, husbandman 1
4314149 2135055 2135055 defendant Grantham Thomas gent 665791 665791 Grantham, Thomas, of Heckington, gent 0
4320187 2137162 2137162 defendant Grantham Thomas gent 665791 665791 Grantham, Thomas, of Heckington, gent 0
4353917 2148597 2148597 defendant Sturton Henry laborer 665791 665791 Sturton, Henry, of Heckington, laborer 0
4360669 2150987 2150987 defendant Democke Thomas gent 665791 665791 Democke, Thomas, of Heckington, gent 1
4366454 2153047 2153047 defendant Greswell Geoffrey laborer 665791 665791 Greswell, Geoffrey, of Heckington, laborer 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);