names

15 rows where place_id = 685626

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4063369 2047188 2047188 plaintiff Geare Robert   685626 685626 Geare, Robert, of Huggett 0
4063370 2047188 2047188 defendant Jackson Roger (legal representative) 685626 685626 Jackson, Roger, of Huggett, husbandman, administrator of 0
4066996 2048492 2048492 defendant Wilkyngson Thomas cordwainer 685626 685626 Wilkyngson, Thomas, of Huggett, cordwainer 0
4066998 2048493 2048493 defendant Wylkenson Thomas cordwainer 685626 685626 Wylkenson, Thomas, of Huggett, cordwainer 0
4086868 2055596 2055596 defendant Kyrkbye Hugh (legal representative) 685626 685626 Kyrkbye, Hugh, of Huggett, husbandman, executors of 0
4086870 2055596 2055596 defendant Kyrkbye William laborer 685626 685626 Kyrkbye, William, of Huggett, laborer 2
4086871 2055596 2055596 defendant Kyrkbye Edmund laborer 685626 685626 Kyrkbye, Edmund, of Huggett, laborer 3
4086872 2055596 2055596 defendant Kyrkbye Thomas laborer 685626 685626 Kyrkbye, Thomas, of Huggett, laborer 4
4086873 2055596 2055596 defendant Kyrckbye Susan spinster 685626 685626 Kyrckbye, Susan, of Huggett, spinster 5
4153526 2079326 2079326 defendant Shillito William yeoman 685626 685626 Shillito, William, of Huggett, yeoman 0
4157144 2080576 2080576 defendant Shelleto William, senior yeoman 685626 685626 Shelleto, William, senior, of Huggett, yeoman 0
4157145 2080576 2080576 defendant Wylkynson Thomas yeoman 685626 685626 Wylkynson, Thomas, of Huggett, yeoman 1
4166666 2083839 2083839 defendant Shillito William, senior yeoman 685626 685626 Shillito, William, senior, of Huggett, yeoman 0
4166667 2083839 2083839 defendant Shillito William, junior yeoman 685626 685626 Shillito, William, junior, of Huggett, yeoman 1
4204614 2097159 2097159 defendant Shellito William, senior yeoman 685626 685626 Shellito, William, senior, of Huggett, 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);