names

38 rows where place_id = 594326

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615589 1872515 1872515 plaintiff Cole John   594326 594326 Cole, John, of Hyll 0
3619482 1873657 1873657 defendant Coke William husbandman 594326 594326 Coke, William, of Hyll, husbandman 1
3651184 1910737 1910737 defendant Holand William husbandman 594326 594326 Holand, William, of Hyll, husbandman 0
3651185 1910737 1910737 defendant Barrowe William husbandman 594326 594326 Barrowe, William, of Hyll, husbandman 1
3651186 1910737 1910737 defendant Hykkys John husbandman 594326 594326 Hykkys, John, of Hyll, husbandman 2
3651187 1910737 1910737 defendant Lacy John husbandman 594326 594326 Lacy, John, of Hyll, husbandman 3
3674118 1917945 1917945 defendant Shreve Roland husbandman 594326 594326 Shreve, Roland, of Hyll, husbandman 0
3676258 1918621 1918621 defendant Fletcher Thomas husbandman 594326 594326 Fletcher, Thomas, of Hyll, husbandman 1
3732004 1936240 1936240 defendant Bareleggys John husbandman 594326 594326 Bareleggys, John, of Hyll, husbandman 0
3738721 1938316 1938316 defendant Robynson William husbandman 594326 594326 Robynson, William, of Hyll, husbandman 3
3767544 1947486 1947486 defendant Torre Joan widow 594326 594326 Torre, Joan, of Hyll, widow 0
3767545 1947486 1947486 defendant Torre Nicholas husbandman 594326 594326 Torre, Nicholas, of Hyll, husbandman 1
3767546 1947486 1947486 defendant Hyll Nicholas husbandman 594326 594326 Hyll, Nicholas, of Hyll, husbandman 2
3813703 1962198 1962198 defendant Chylde John husbandman 594326 594326 Chylde, John, of Hyll, husbandman 0
3820941 1964443 1964443 defendant Forest Robert husbandman 594326 594326 Forest, Robert, of Hyll, husbandman 4
3839328 1970227 1970227 defendant Hyll John gent 594326 594326 Hyll, John, of Hyll, gent 1
3875021 1981873 1981873 plaintiff Drake John, senior   594326 594326 Drake, John, senior, of Hyll 0
3886708 1985810 1985810 defendant Hyll John husbandman 594326 594326 Hyll, John, of Hyll, husbandman 1
3895485 1988698 1988698 defendant Bokey John husbandman 594326 594326 (Bokey, John, of Hyll, husbandman 4
3897770 1989460 1989460 defendant Butler alias Dryver William yeoman 594326 594326 Butler alias Dryver, William, of Hyll, yeoman 1
3914253 1995111 1995111 defendant Higgyns Ambrose weaver 594326 594326 Higgyns, Ambrose, of Hyll, weaver 2
3932724 2001244 2001244 plaintiff Galampton John   594326 594326 Galampton, John, of Hyll 0
3976726 2016425 2016425 defendant Colcome Thomas husbandman 594326 594326 Colcome, Thomas, of Hyll, husbandman 0
3997177 2023760 2023760 defendant James William yeoman 594326 594326 James, William, of Hyll, yeoman 1
3997179 2023761 2023761 defendant James William yeoman 594326 594326 James, William, of Hyll, yeoman 0
3997183 2023762 2023762 defendant James William yeoman 594326 594326 James, William, of Hyll, yeoman 1
3997185 2023763 2023763 defendant James William yeoman 594326 594326 James, William, of Hyll, yeoman 0
4068966 2049189 2049189 defendant Over John, senior yeoman 594326 594326 Over, John, senior, of Hyll, yeoman 0
4068968 2049189 2049189 defendant Over John yeoman or husbandman 594326 594326 Over, John, of Hyll, yeoman or husbandman 2
4078442 2052587 2052587 defendant Tetnall Thomas gent 594326 594326 Tetnall, Thomas, of Hyll, or of Inner Temple, gent 0
4116756 2066291 2066291 defendant Over John, senior yeoman 594326 594326 Over, John, senior, of Hyll, yeoman 0
4193950 2093444 2093444 defendant Asburner Thomas husbandman 594326 594326 Asburner, Thomas, of Hyll, Cumber, husbandman 1
4293384 2127698 2127698 defendant Goodwyn Arthur miner 594326 594326 Goodwyn, Arthur, of Hyll, or of Tyddeswall, miner 0
4536610 2211730 2211730 plaintiff Russell Richard   594326 594326 Russell, Richard, of Hyll 2
4914800 2331144 2331144 plaintiff Gelhampton John   594326 594326 (Gelhampton, John, of Hyll 1
5361072 2463489 2463489 defendant Mason William husbandman 594326 594326 Mason, William, of Hyll, husbandman 1
5502578 2505726 2505726 defendant Gelhampton John husbandman 594326 594326 Gelhampton, John, of Hyll, husbandman 0
5502580 2505727 2505727 defendant Gelhampton John, junior husbandman 594326 594326 Gelhampton, John, junior, of Hyll, 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);