names

38 rows where place_id = 597057

✎ 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
3627135 1903344 1903344 defendant Coke Thomas husbandman 597057 597057 Coke, Thomas, of Acton Trussell, husbandman 0
3637463 1906525 1906525 defendant Cooke Thomas husbandman 597057 597057 Cooke, Thomas, of Acton Trussell, husbandman 2
3739873 1938687 1938687 defendant Empson Thomas husbandman 597057 597057 Empson, Thomas, of Acton Trussell, husbandman 0
3875254 1981963 1981963 plaintiff Emson Thomas husbandman 597057 597057 Emson, Thomas, of Acton Trussell, husbandman 0
3971156 2014467 2014467 defendant Dyckynson Richard husbandman 597057 597057 Dyckynson, Richard, of Acton Trussell, husbandman 0
4028032 2034678 2034678 defendant Webbe Henry yeoman 597057 597057 Webbe, Henry, of Acton Trussell, yeoman 0
4028034 2034678 2034678 defendant Dickynson Lewis husbandman 597057 597057 Dickynson, Lewis, of Acton Trussell, husbandman 2
4164172 2082997 2082997 defendant Kynge John carpenter 597057 597057 Kynge, John, of Acton Trussell, carpenter 1
4218166 2101855 2101855 defendant Hart John husbandman 597057 597057 Hart John, of Acton Trussell, husbandman 0
4218168 2101855 2101855 defendant Hyckam Robert butcher 597057 597057 Hyckam, Robert, of Acton Trussell, butcher 2
4319576 2136958 2136958 defendant Nicklen Richard yeoman 597057 597057 Nicklen, Richard, of Acton Trussell, yeoman 0
4326083 2139093 2139093 defendant Sotherne John yeoman 597057 597057 Sotherne, John, of Acton Trussell, yeoman 2
4327214 2139428 2139428 defendant Kynge John laborer 597057 597057 Kynge, John, of Acton Trussell, laborer 3
4340084 2143798 2143798 defendant Hewes Thomas husbandman 597057 597057 Hewes, Thomas, of Acton Trussell, husbandman 1
4341379 2144262 2144262 defendant Hewes Thomas husbandman 597057 597057 Hewes, Thomas, of Acton Trussell, husbandman 0
4396052 2163257 2163257 defendant Glover Agnes widow 597057 597057 Glover, Agnes, of Acton Trussell, widow 0
5035897 2367354 2367354 defendant Coweley Thomas chaplain 597057 597057 Coweley, Thomas, of Acton Trussell, chaplain 0
5035898 2367354 2367354 defendant Charman Joan widow 597057 597057 Charman, Joan, of Acton Trussell, widow 1
5038087 2368023 2368023 defendant Cook John yeoman 597057 597057 Cook, John, of Acton Trussell, yeoman 0
5054689 2372980 2372980 defendant Clyf Thomas yeoman 597057 597057 Clyf, Thomas, of Acton Trussell, yeoman 0
5071664 2378017 2378017 defendant Trussell William   597057 597057 Trussell, William, of Acton Trussell, knight 0
5152907 2401991 2401991 defendant Tylle Thomas yeoman 597057 597057 Tylle, Thomas, of Acton Trussell, yeoman 1
5152912 2401992 2401992 defendant Tylle Thomas yeoman 597057 597057 Tylle, Thomas, of Acton Trussell, yeoman 1
5170489 2407096 2407096 defendant Tille Thomas yeoman 597057 597057 Tille, Thomas, of Acton Trussell, yeoman 1
5196949 2414856 2414856 defendant Brook William yeoman 597057 597057 Brook, William, of Acton Trussell, yeoman 3
5239422 2427112 2427112 defendant Tyll Thomas yeoman 597057 597057 Tyll, Thomas, of Acton Trussell, yeoman 0
5239423 2427112 2427112 defendant Webbe John husbandman 597057 597057 Webbe, John, of Acton Trussell, husbandman 1
5239427 2427112 2427112 defendant Wolfe Robert yeoman 597057 597057 Wolfe, Robert, of Acton Trussell, yeoman 5
5249778 2430055 2430055 defendant Barker John yeoman 597057 597057 Barker, John, of Acton Trussell, yeoman 0
5250833 2430372 2430372 defendant Coke John yeoman 597057 597057 Coke, John, of Acton Trussell, yeoman 0
5290579 2442247 2442247 defendant Kent Mayhewe yeoman 597057 597057 Kent, Mayhewe, of Acton Trussell, bailiff of Eton, Berks, yeoman 1
5290582 2442248 2442248 defendant Kent Mayhewe yeoman 597057 597057 Kent, Mayhewe, of Acton Trussell, bailiff of Eton, Berks, yeoman 1
5354828 2461589 2461589 plaintiff Holy Richard   597057 597057 (Holy, Richard, of Acton Trussell 1
5396980 2474218 2474218 defendant Notthall John husbandman 597057 597057 Notthall, John, of Acton Trussell, husbandman 0
5533268 2514955 2514955 defendant Sellam William husbandman 597057 597057 Sellam, William, of Acton Trussell, husbandman 0
5533269 2514955 2514955 defendant Sellam Roger husbandman 597057 597057 Sellam, Roger, of Acton Trussell, husbandman 1
5533270 2514955 2514955 defendant Sellam Henry husbandman 597057 597057 Sellam, Henry, of Acton Trussell, husbandman 2
5533271 2514955 2514955 defendant Sellam John husbandman 597057 597057 Sellam, John, of Acton Trussell, husbandman 3

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);