names

11 rows where place_id = 629535

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3788800 1954299 1954299 defendant Pyper John husbandman 629535 629535 Pyper, John, of Tybthorp, husbandman 4
4462475 2188957 2188957 plaintiff Taillour Thomas   629535 629535 Taillour, Thomas, of Tybthorp 0
4720491 2271746 2271746 defendant Symmson Richard husbandman 629535 629535 Symmson, Richard, of Tybthorp, husbandman 1
4964385 2346263 2346263 defendant Smyth Richard husbandman 629535 629535 Smyth, Richard, of Tybthorp, husbandman 3
4965803 2346703 2346703 defendant Wryght Henry yeoman 629535 629535 Wryght, Henry, of Tybthorp, yeoman 0
4965804 2346703 2346703 defendant Whythows Robert husbandman 629535 629535 Whythows, Robert, of Tybthorp, husbandman 1
4965805 2346703 2346703 defendant Symson Richard husbandman 629535 629535 Symson, Richard, of Tybthorp, husbandman 2
5044229 2369903 2369903 defendant Wryght Henry yeoman 629535 629535 Wryght, Henry, of Tybthorp, yeoman 0
5044231 2369904 2369904 defendant Wryght Henry yeoman 629535 629535 Wryght, Henry, of Tybthorp, yeoman 0
5322742 2451878 2451878 defendant Boynton Peter husbandman 629535 629535 Boynton, Peter, of Tybthorp, husbandman 0
5322744 2451879 2451879 defendant Boynton Peter husbandman 629535 629535 Boynton, Peter, of Tybthorp, 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);