names

20 rows where place_id = 616076

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3712391 1930193 1930193 defendant Mayhoo William clothman 616076 616076 Mayhoo, William, of New Alresford, Hants, clothman 0
3712395 1930194 1930194 defendant Mayhoo William clothman 616076 616076 Mayhoo, William, of New Alresford, Hants, clothman 0
3779115 1951191 1951191 defendant Kyng Richard clothier 616076 616076 Kyng, Richard, of New Alresford, Hants, clothier 3
3860728 1977080 1977080 defendant Pestod William clothier 616076 616076 Pestod, William, of New Alresford, Hants, clothier 0
4122607 2068381 2068381 defendant Horne William clothier 616076 616076 Horne, William, of New Alresford, Hants, clothier 0
4195996 2094153 2094153 defendant Hamlyn Richard yeoman 616076 616076 Hamlyn, Richard, of New Alresford, Hants, yeoman 0
4267897 2118897 2118897 defendant Gase or Gast Arthur dyer 616076 616076 Gase or Gast, Arthur, of New Alresford, Hants, dyer 0
4274725 2121105 2121105 defendant Hollise Godfrey tanner 616076 616076 Hollise, Godfrey, of New Alresford, Hants, tanner 0
4366642 2153116 2153116 defendant Cole Henry yeoman 616076 616076 Cole, Henry, of New Alresford, Hants, yeoman 0
4684255 2260680 2260680 defendant Iremonger Simon fuller 616076 616076 Iremonger, Simon, of New Alresford, Hants, fuller 0
4684259 2260681 2260681 defendant Kent John de husbandman 616076 616076 Kent, John de, of New Alresford, Hants, husbandman 0
5168396 2406474 2406474 defendant Grygge alias Cokke John chandler 616076 616076 Grygge alias Cokke, John, of New Alresford, Hants, chandler 2
5193992 2413977 2413977 defendant Bornevyle William gent 616076 616076 (Bornevyle, William, of New Alresford, Hants, gent 1
5208486 2418213 2418213 defendant Bernevyle William gent 616076 616076 (Bernevyle, William, of New Alresford, Hants, gent 1
5218281 2421079 2421079 defendant Tapanere John tapener or weaver 616076 616076 Tapanere, John, of New Alresford, Hants, tapener or weaver 0
5244811 2428653 2428653 defendant Bernevile William gent 616076 616076 Bernevile, William, of New Alresford, Hants, gent 0
5469852 2495909 2495909 defendant Frampton John merchant 616076 616076 Frampton, John, of New Alresford, Hants, merchant 8
5537833 2516321 2516321 defendant Balle John dyer 616076 616076 Balle, John, of New Alresford, Hants, dyer 1
5590282 2531932 2531932 defendant Bygon John yeoman 616076 616076 Bygon, John, of New Alresford, Hants, yeoman 0
5590367 2531958 2531958 defendant Baker Ingelram yeoman 616076 616076 (Baker, Ingelram, of New Alresford, Hants, yeoman 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);