names

48 rows where place_id = 595376

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620236 1873906 1873906 defendant Person William husbandman 595376 595376 Person, William, of Aghton, husbandman 3
3779856 1951432 1951432 defendant West John gent 595376 595376 West, John, of Aghton, gent 1
3898293 1989637 1989637 defendant Kyrkeby Thomas chaplain 595376 595376 Kyrkeby, Thomas, of Aghton, chaplain 3
3909605 1993518 1993518 defendant Carr Robert cutler 595376 595376 Carr, Robert, of Aghton, cutler 2
4076526 2051901 2051901 defendant Lambert Benjamin gent 595376 595376 Lambert, Benjamin, of Aghton, gent 1
4140571 2074871 2074871 defendant Cutbert Richard husbandman 595376 595376 Cutbert, Richard, of Aghton, husbandman 0
4140572 2074871 2074871 defendant Garneshawe or Earneshawe James   595376 595376 Garneshawe or Earneshawe, James, of Aghton, wheelwright 1
4140573 2074871 2074871 defendant Carre Robert husbandman 595376 595376 Carre, Robert, of Aghton, husbandman 2
4140574 2074871 2074871 defendant Water Thomas husbandman 595376 595376 Water, Thomas, of Aghton, husbandman 3
4140576 2074872 2074872 defendant Symonette John husbandman 595376 595376 Symonette, John, of Aghton, husbandman 0
4140577 2074872 2074872 defendant Wright John husbandman 595376 595376 Wright, John, of Aghton, husbandman 1
4140578 2074872 2074872 defendant Hill John husbandman 595376 595376 Hill, John, of Aghton, husbandman 2
4140579 2074872 2074872 defendant Harpam John laborer 595376 595376 Harpam, John, of Aghton, laborer 3
4140581 2074873 2074873 defendant Woode John husbandman 595376 595376 Woode, John, of Aghton, husbandman 0
4140582 2074873 2074873 defendant Watcher Richard weaver 595376 595376 Watcher, Richard, of Aghton, weaver 1
4140583 2074873 2074873 defendant Partricke William laborer 595376 595376 Partricke, William, of Aghton, laborer 2
4140586 2074874 2074874 defendant Bray Nicholas husbandman 595376 595376 Bray, Nicholas, of Aghton, husbandman 0
4140587 2074874 2074874 defendant Scolay Richard husbandman 595376 595376 Scolay, Richard, of Aghton, husbandman 1
4140588 2074874 2074874 defendant Norbearne William   595376 595376 Norbearne, William, of Aghton, wheelwright 2
4140589 2074874 2074874 defendant Wright Henry weaver 595376 595376 Wright, Henry, of Aghton, weaver 3
4459663 2188078 2188078 defendant Haliday Adam   595376 595376 Haliday, Adam, of Aghton 0
4461294 2188617 2188617 defendant Haliday Adam   595376 595376 Haliday, Adam, of Aghton 0
4499553 2200509 2200509 defendant Herlethorp Richard de   595376 595376 Herlethorp, Richard de, of Aghton 0
4499554 2200509 2200509 defendant Claybroke William de   595376 595376 Claybroke, William de, of Aghton 1
4609262 2234001 2234001 defendant Couper John   595376 595376 Couper, John, of Aghton 0
4609987 2234212 2234212 defendant Couper John   595376 595376 Couper, John, of Aghton 0
4609990 2234213 2234213 defendant Couper John, sen   595376 595376 Couper, John, sen, of Aghton 0
4609993 2234214 2234214 defendant Couper John   595376 595376 Couper, John, of Aghton 0
4661492 2249423 2249423 defendant Richardson John husbandman 595376 595376 Richardson, John, of Aghton, husbandman 0
4661493 2249423 2249423 defendant Faukenore William husbandman 595376 595376 Faukenore, William, of Aghton, husbandman 1
4704414 2266755 2266755 defendant Milner Richard milner 595376 595376 Milner, Richard, of Aghton, milner 0
4704415 2266755 2266755 defendant Daweson Richard husbandman 595376 595376 Daweson, Richard, of Aghton, husbandman 1
4704416 2266755 2266755 defendant Garner Roger husbandman 595376 595376 Garner, Roger, of Aghton, husbandman 2
4704417 2266755 2266755 defendant (illegible) John husbandman 595376 595376 _, John, of Aghton, husbandman 3
4704418 2266755 2266755 defendant Barleburgh John de husbandman 595376 595376 Barleburgh, John de, of Aghton, husbandman 4
4898861 2326286 2326286 defendant West Thomas yeoman 595376 595376 West, Thomas, of Aghton, yeoman 3
4923538 2333795 2333795 defendant West Thomas yeoman 595376 595376 West, Thomas, of Aghton, yeoman 0
5016156 2361609 2361609 defendant Aske Richard esq 595376 595376 Aske, Richard, of Aghton, esq 0
5145771 2399903 2399903 defendant Dene John laborer 595376 595376 Dene, John, of Aghton, laborer 6
5145776 2399904 2399904 defendant Lyndale John gent 595376 595376 Lyndale, John, of Aghton, gent 1
5145777 2399904 2399904 defendant Hautwessyll William gent 595376 595376 Hautwessyll, William, of Aghton, gent 2
5166112 2405826 2405826 defendant Dene John laborer 595376 595376 Dene, John, of Aghton, laborer 7
5166118 2405827 2405827 defendant Lyndale John gent 595376 595376 Lyndale, John, of Aghton, gent 1
5166119 2405827 2405827 defendant Hautwessyl William gent 595376 595376 Hautwessyl, William, of Aghton, gent 2
5327452 2453282 2453282 defendant Bower Richard weaver 595376 595376 Bower, Richard, of Aghton, weaver 1
5426838 2482969 2482969 defendant Shepert Richard yeoman 595376 595376 Shepert, Richard, of Aghton, yeoman 2
5457509 2492143 2492143 defendant Shepert Richard yeoman 595376 595376 Shepert, Richard, of Aghton, yeoman 2
5635574 2555087 2555087 defendant Fauconer William husbandman 595376 595376 Fauconer, William, of Aghton, 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);