names

21 rows where place_id = 602385

✎ 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
3649890 1910329 1910329 defendant Baldyng William husbandman 602385 602385 Baldyng, William, of Teryngton St John, husbandman 0
3946585 2005870 2005870 defendant Walbott John, senior yeoman 602385 602385 Walbott, John, senior, of Teryngton St John, yeoman 0
3946587 2005871 2005871 defendant Walbott John, senior yeoman 602385 602385 Walbott, John, senior, of Teryngton St John, yeoman 0
3954047 2008486 2008486 defendant Cowper Richard, junior husbandman 602385 602385 Cowper, Richard, junior, of Teryngton St John, husbandman 0
3970530 2014293 2014293 defendant Walbott John, senior yeoman 602385 602385 Walbott, John, senior, of Teryngton St John, yeoman 0
4000884 2025088 2025088 defendant Cannon Robert husbandman 602385 602385 Cannon, Robert, of Teryngton St John, husbandman 0
4000907 2025095 2025095 defendant Morrys Thomas yeoman 602385 602385 Morrys, Thomas, of Teryngton St John, yeoman 0
4000908 2025095 2025095 defendant Suddeby Henry husbandman 602385 602385 Suddeby, Henry, of Teryngton St John, husbandman 1
4000909 2025095 2025095 defendant Cannon Robert husbandman 602385 602385 Cannon, Robert, of Teryngton St John, husbandman 2
4033766 2036727 2036727 defendant Morrys Thomas husbandman 602385 602385 Morrys, Thomas, of Teryngton St John, husbandman 0
4033794 2036736 2036736 defendant Sudebye Henry husbandman 602385 602385 Sudebye, Henry, of Teryngton St John, husbandman 0
4033795 2036736 2036736 defendant Cannon Robert husbandman 602385 602385 Cannon, Robert, of Teryngton St John, husbandman 1
4033797 2036737 2036737 defendant Sutebye Henry husbandman 602385 602385 Sutebye, Henry, of Teryngton St John, husbandman 0
4033798 2036737 2036737 defendant Cannon Robert husbandman 602385 602385 Cannon, Robert, of Teryngton St John, husbandman 1
4033800 2036738 2036738 defendant Thacker William husbandman 602385 602385 Thacker, William, of Teryngton St John, husbandman 0
4033801 2036738 2036738 defendant Sudeley Henry   602385 602385 Sudeley, Henry, of Teryngton St John 1
4033803 2036739 2036739 defendant Thacker William husbandman 602385 602385 Thacker, William, of Teryngton St John, husbandman 0
4033804 2036739 2036739 defendant Sutebye Henry husbandman 602385 602385 Sutebye, Henry, of Teryngton St John, husbandman 1
4036180 2037623 2037623 defendant Whyncke John husbandman 602385 602385 Whyncke, John, of Teryngton St John, husbandman 1
4036193 2037626 2037626 defendant Wynke John husbandman 602385 602385 Wynke, John, of Teryngton St John, husbandman 1
4045980 2041009 2041009 defendant Cocker John bricklayer 602385 602385 Cocker, John, of Teryngton St John, bricklayer 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);