names

19 rows where place_id = 610470

✎ 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
3683693 1921032 1921032 defendant Dawson Richard yeoman 610470 610470 Dawson, Richard, of Kepax, yeoman 0
3683694 1921032 1921032 defendant Scalys Roger husbandman 610470 610470 Scalys, Roger, of Kepax, husbandman 1
3690250 1923110 1923110 defendant Danson Richard yeoman 610470 610470 Danson, Richard, of Kepax, yeoman 0
4319866 2137054 2137054 defendant Prince William yeoman 610470 610470 Prince, William, of Kepax, yeoman 2
4482500 2195228 2195228 defendant Dodyngton Simon   610470 610470 Dodyngton, Simon, of Kepax, parson 1
4877146 2319814 2319814 defendant Lowe Robert husbandman 610470 610470 Lowe, Robert, of Kepax, husbandman 4
4877167 2319820 2319820 defendant Hunt John husbandman 610470 610470 Hunt, John, of Kepax, husbandman 0
4877168 2319820 2319820 defendant Hillom Henry husbandman 610470 610470 Hillom, Henry, of Kepax, husbandman 1
4877169 2319820 2319820 defendant Proctour John husbandman 610470 610470 Proctour, John, of Kepax, husbandman 2
4877170 2319820 2319820 defendant Beverage John husbandman 610470 610470 Beverage, John, of Kepax, husbandman 3
4877171 2319820 2319820 defendant Grymston William husbandman 610470 610470 Grymston, William, of Kepax, husbandman 4
5308806 2447673 2447673 defendant Jakson Richard   610470 610470 Jakson, Richard, of Kepax, holy water clerk 0
5308826 2447680 2447680 defendant Jakson Richard   610470 610470 Jakson, Richard, of Kepax, holy water clerk 0
5308828 2447681 2447681 defendant Jakson Richard   610470 610470 Jakson, Richard, of Kepax, holy water clerk 0
5348814 2459756 2459756 defendant Smyth John yeoman 610470 610470 Smyth, John, of Kepax, yeoman 0
5348815 2459756 2459756 defendant Speynce Thomas yeoman 610470 610470 Speynce, Thomas, of Kepax, yeoman 1
5348817 2459757 2459757 defendant Smyth John, senior yeoman 610470 610470 Smyth, John, senior, of Kepax, yeoman 0
5565308 2524440 2524440 defendant Gascoign John gent 610470 610470 Gascoign, John, of Kepax, gent 0
5565310 2524441 2524441 defendant Dawson Richard yeoman 610470 610470 Dawson, Richard, of Kepax, 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);