names

16 rows where place_id = 610364

✎ 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
3683171 1920854 1920854 defendant Bromley William gent 610364 610364 Bromley, William, of Hodnet, gent 0
3686845 1922046 1922046 defendant Dermond George yeoman 610364 610364 Dermond, George, of Hodnet, yeoman 0
3776127 1950277 1950277 defendant Hill William clerk 610364 610364 Hill, William, of Hodnet, clerk 0
3806105 1959837 1959837 defendant Bromley George esq 610364 610364 Bromley, George, of Hodnet, esq 0
3823496 1965250 1965250 defendant Newton Randolph husbandman 610364 610364 Newton, Randolph, of Hodnet, husbandman 0
3823497 1965250 1965250 defendant Alegh John weaver 610364 610364 Alegh, John, of Hodnet, weaver 1
3823774 1965333 1965333 defendant Bromley George esq 610364 610364 Bromley, George, of Hodnet, esq 0
5041069 2368955 2368955 defendant Watson Robert yeoman 610364 610364 Watson, Robert, of Hodnet, yeoman 0
5106009 2388196 2388196 defendant Cartwryght William, senior yeoman 610364 610364 Cartwryght, William, senior, of Hodnet, yeoman 4
5106021 2388198 2388198 defendant Cartwryght William, senior yeoman 610364 610364 Cartwryght, William, senior, of Hodnet, yeoman 4
5418447 2480443 2480443 defendant Sheldon John yeoman 610364 610364 Sheldon, John, of Hodnet, yeoman 4
5436379 2485815 2485815 defendant Sheldon John yeoman 610364 610364 Sheldon, John, of Hodnet, yeoman 4
5554952 2521451 2521451 defendant Hyll Thomas gent 610364 610364 Hyll, Thomas, of Hodnet, gent 0
5554954 2521451 2521451 defendant Haughton William husbandman 610364 610364 Haughton, William, of Hodnet, husbandman 2
5554955 2521451 2521451 defendant Dormyar Richard clerk 610364 610364 Dormyar, Richard, of Hodnet, clerk 3
5566843 2524897 2524897 defendant Yomans William husbandman 610364 610364 Yomans, William, of Hodnet, husbandman 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);