names

29 rows where place_id = 590407

✎ 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
3601120 1868013 1868013 defendant Hervee Henry cutler 590407 590407 Hervee, Henry, of Cold Aston, cutler 0
3744051 1940033 1940033 defendant Harvard Gilbert husbandman 590407 590407 Harvard, Gilbert, of Cold Aston, husbandman 2
3799744 1957841 1957841 defendant Todde Richard husbandman 590407 590407 Todde, Richard, of Cold Aston, husbandman 1
3799745 1957841 1957841 defendant Forde Philip husbandman 590407 590407 Forde, Philip, of Cold Aston, husbandman 2
3867500 1979364 1979364 defendant Harwood Arthur clerk 590407 590407 Harwood, Arthur, of Cold Aston, clerk 0
3885878 1985534 1985534 defendant Phyllypot Henry husbandman 590407 590407 Phyllypot, Henry, of Cold Aston, husbandman 0
4089878 2056667 2056667 defendant Bower Edward husbandman 590407 590407 Bower, Edward, of Cold Aston, husbandman 1
4097714 2059513 2059513 defendant Bower Richard husbandman 590407 590407 Bower, Richard, of Cold Aston, or of Dranfeyld, Derbs, husbandman 0
4148457 2077590 2077590 defendant Abney William yeoman 590407 590407 Abney, William, of Cold Aston, yeoman 0
4151207 2078545 2078545 defendant Cartlage Thomas yeoman 590407 590407 Cartlage, Thomas, of Cold Aston, yeoman 1
4164156 2082990 2082990 defendant Abney William, junior husbandman 590407 590407 Abney, William, junior, of Cold Aston, husbandman 2
4165113 2083305 2083305 defendant Cartledge Thomas yeoman 590407 590407 Cartledge, Thomas, of Cold Aston, yeoman 0
4165115 2083306 2083306 defendant Cartledge Thomas yeoman 590407 590407 Cartledge, Thomas, of Cold Aston, yeoman 0
4165117 2083307 2083307 defendant Cartledge Thomas yeoman 590407 590407 Cartledge, Thomas, of Cold Aston, yeoman 0
4215945 2101071 2101071 defendant Carteledge Thomas (legal representative) 590407 590407 Carteledge, Thomas, of Cold Aston, yeoman, administratrix of 2
4215946 2101071 2101071 defendant Carteledge Alice widow 590407 590407 Carteledge, Alice, of Cold Aston, widow 3
4217386 2101577 2101577 defendant Cartledge Thomas (legal representative) 590407 590407 Cartledge, Thomas, of Cold Aston, yeoman, administratrix of 0
4217387 2101577 2101577 defendant Cartledge Alice widow 590407 590407 Cartledge, Alice, of Cold Aston, widow 1
4293482 2127731 2127731 defendant Barlowe William yeoman 590407 590407 Barlowe, William, of Cold Aston, yeoman 2
4310024 2133663 2133663 defendant Wheler John husbandman 590407 590407 Wheler, John, of Cold Aston, husbandman 1
4404897 2166206 2166206 defendant Barlowe William husbandman 590407 590407 Barlowe, William, of Cold Aston, husbandman 2
4447287 2184056 2184056 defendant Dawe Thomas   590407 590407 Dawe, Thomas, of Cold Aston 2
4447288 2184056 2184056 defendant Shepherd Henry   590407 590407 Shepherd, Henry, of Cold Aston 3
4698988 2265158 2265158 defendant Brounyng Richard gent 590407 590407 Brounyng, Richard, of Cold Aston, gent 1
4819796 2302263 2302263 defendant Iddelwold Walter husbandman 590407 590407 Iddelwold, Walter, of Cold Aston, husbandman 0
5091580 2383926 2383926 defendant Wode William husbandman 590407 590407 Wode, William, of Cold Aston, husbandman 0
5369362 2466017 2466017 defendant Wodehouse Robert husbandman 590407 590407 Wodehouse, Robert, of Cold Aston, husbandman 9
5501167 2505302 2505302 defendant Fox John yeoman 590407 590407 Fox, John, of Cold Aston, yeoman 0
5534218 2515234 2515234 defendant Blikley Thomas husbandman 590407 590407 Blikley, Thomas, of Cold Aston, husbandman 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);