names

21 rows where place_id = 595453

✎ 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
3620535 1873998 1873998 defendant Hobley John barker 595453 595453 Hobley, John, of Stoneley, barker 0
3681318 1920246 1920246 defendant Hudson John yeoman 595453 595453 Hudson, John, of Stoneley, yeoman 0
3778054 1950850 1950850 defendant Stokton Robert husbandman 595453 595453 Stokton, Robert, of Stoneley, husbandman 2
3778055 1950850 1950850 defendant Hudson John husbandman 595453 595453 Hudson, John, of Stoneley, husbandman 3
3792802 1955599 1955599 defendant Dowland Margery widow 595453 595453 Dowland, Margery, of Stoneley, widow 0
3844075 1971693 1971693 defendant Garlyk Henry husbandman 595453 595453 Garlyk, Henry, of Stoneley, husbandman 1
3844078 1971694 1971694 defendant Garlyk Henry husbandman 595453 595453 Garlyk, Henry, of Stoneley, husbandman 1
3874820 1981797 1981797 defendant Nelson Thomas yeoman 595453 595453 Nelson, Thomas, of Stoneley, yeoman 0
3896741 1989121 1989121 defendant Slough William yeoman 595453 595453 Slough, William, of Stoneley, yeoman 0
4185969 2090581 2090581 defendant Spencer James glover 595453 595453 Spencer, James, of Stoneley, glover 0
4214132 2100460 2100460 defendant Bott John yeoman 595453 595453 Bott, John, of Stoneley, yeoman 0
4223806 2103813 2103813 defendant Bott John yeoman 595453 595453 Bott, John, of Stoneley, yeoman 0
4603154 2232193 2232193 defendant Shukkeburgh John   595453 595453 Shukkeburgh, John, of Stoneley 1
4604019 2232427 2232427 defendant Shuckeburgh John   595453 595453 Shuckeburgh, John, of Stoneley 1
4770794 2286844 2286844 defendant Gyddyng William butcher 595453 595453 Gyddyng, William, of Stoneley, butcher 0
5003143 2357823 2357823 defendant Hayel John husbandman 595453 595453 Hayel, John, of Stoneley, husbandman 2
5042968 2369513 2369513 plaintiff Everdon Henry   595453 595453 Everdon, Henry, of Stoneley, abbot of the monastery of the BM 0
5078575 2380086 2380086 defendant Huby William   595453 595453 Huby, William, of Stoneley 0
5222997 2422444 2422444 defendant Crak Thomas yeoman 595453 595453 Crak, Thomas, of Stoneley, yeoman 0
5240620 2427468 2427468 defendant Cauk Thomas clerk 595453 595453 Cauk, Thomas, of Stoneley, clerk 0
5581141 2529170 2529170 defendant Parteryche Thomas laborer 595453 595453 Parteryche, Thomas, of Stoneley, laborer 1

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