names

18 rows where place_id = 596641

✎ 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
3625610 1875542 1875542 defendant Wellys Thomas husbandman 596641 596641 Wellys, Thomas, of Badsey, husbandman 2
3646210 1909208 1909208 defendant Bayly Roger husbandman 596641 596641 Bayly, Roger, of Badsey, husbandman 0
3650160 1910419 1910419 defendant Russe- Thomas husbandman 596641 596641 Russe-, Thomas, of Badsey, husbandman 4
3699284 1925991 1925991 defendant Kynges William husbandman 596641 596641 Kynges, William, of Badsey, husbandman 3
3770273 1948373 1948373 defendant Pygyn John husbandman 596641 596641 Pygyn, John, of Badsey, husbandman 1
3829023 1966959 1966959 defendant Lane Richard husbandman 596641 596641 Lane, Richard, of Badsey, husbandman 5
3904534 1991764 1991764 defendant Tomson Robert husbandman 596641 596641 Tomson, Robert, of Badsey, husbandman 3
4245377 2111429 2111429 defendant Pygeon Thomas yeoman 596641 596641 Pygeon, Thomas, of Badsey, yeoman 0
4277588 2122084 2122084 defendant Howell John husbandman 596641 596641 Howell, John, of Badsey, husbandman 1
4277589 2122084 2122084 defendant Williams John clerk 596641 596641 Williams, John, of Badsey, clerk 2
4292718 2127457 2127457 defendant Pryce Thomas yeoman 596641 596641 (Pryce, Thomas, of Badsey, yeoman 1
4298847 2129684 2129684 defendant Badsey Robert miller 596641 596641 Badsey, Robert, of Badsey, yeoman, miller 0
4330231 2140414 2140414 defendant Crompe John yeoman 596641 596641 Crompe, John, of Badsey, yeoman 0
4386104 2160034 2160034 defendant Pygeon Thomas yeoman 596641 596641 Pygeon, Thomas, of Badsey, yeoman 0
4404160 2165961 2165961 defendant Harwarde William gent 596641 596641 Harwarde, William, of Badsey, gent 0
4404161 2165961 2165961 defendant Pygan Edward, senior yeoman 596641 596641 Pygan, Edward, senior, of Badsey, yeoman 1
5329612 2453926 2453926 defendant Hygons John husbandman 596641 596641 Hygons, John, of Badsey, husbandman 0
5584588 2530250 2530250 defendant Lane Richard husbandman 596641 596641 Lane, Richard, of Badsey, husbandman 2

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