names

29 rows where place_id = 595705

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621530 1874276 1874276 defendant Crosse Thomas yeoman 595705 595705 Crosse, Thomas, of Cressyngham, yeoman 3
3716939 1931585 1931585 defendant Crowe John husbandman 595705 595705 Crowe, John, of Cressyngham, husbandman 0
3750018 1941922 1941922 defendant Crane William husbanman 595705 595705 Crane, William, of Cressyngham, husbanman 1
3768284 1947722 1947722 defendant Yenney Christopher gent 595705 595705 Yenney, Christopher, of Cressyngham, gent 0
3830202 1967340 1967340 defendant Parker William   595705 595705 Parker, William, of Cressyngham, shepherd 0
3831193 1967645 1967645 defendant Edows Thomas yeoman 595705 595705 Edows, Thomas, of Cressyngham, yeoman 0
3831199 1967646 1967646 defendant Edowes Thomas yeoman 595705 595705 Edowes, Thomas, of Cressyngham, yeoman 0
3841395 1970890 1970890 plaintiff Benet William   595705 595705 Benet, William, of Cressyngham 0
3842619 1971220 1971220 plaintiff Bucler William   595705 595705 Bucler, William, of Cressyngham 0
3907736 1992874 1992874 defendant Jennay Christopher gent 595705 595705 Jennay, Christopher, of Cressyngham, gent 2
3907737 1992874 1992874 defendant Jennay George gent 595705 595705 Jennay, George, of Cressyngham, gent 3
3907743 1992875 1992875 defendant Jenney Christopher gent 595705 595705 Jenney, Christopher, of Cressyngham, gent 2
3907744 1992875 1992875 defendant Jenney George gent 595705 595705 Jenney, George, of Cressyngham, gent 3
3984241 2019131 2019131 defendant Jenney Dorothy spinster 595705 595705 Jenney, Dorothy, of Cressyngham, spinster 4
4013279 2029483 2029483 plaintiff Robynson William yeoman 595705 595705 Robynson, William, of Cressyngham, yeoman 0
4044809 2040596 2040596 plaintiff Robynson William   595705 595705 Robynson, William, of Cressyngham 0
4065090 2047801 2047801 defendant Myndes or Mynnes Thomas husbandman 595705 595705 Myndes or Mynnes, Thomas, of Cressyngham, husbandman 2
4441158 2182162 2182162 defendant Howard John   595705 595705 Howard, John, of Cressyngham, junior, son of John 1
4520385 2206719 2206719 defendant Frost John   595705 595705 Frost, John, of Cressyngham 4
4736118 2276431 2276431 defendant Wygenhale John chaplain 595705 595705 Wygenhale, John, of Cressyngham, chaplain 3
4739327 2277386 2277386 defendant Andrewes John yeoman 595705 595705 Andrewes, John, of Cressyngham, yeoman 0
4939321 2338679 2338679 defendant Baxter Margaret widow 595705 595705 Baxter, Margaret, of Cressyngham, widow 0
4939322 2338679 2338679 defendant Baxter Walter husbandman 595705 595705 Baxter, Walter, of Cressyngham, husbandman 1
5142556 2398951 2398951 plaintiff Wright William   595705 595705 Wright, William, of Cressyngham, parson 0
5145926 2399934 2399934 defendant Sorell John husbandman 595705 595705 Sorell, John, of Cressyngham, husbandman 1
5347837 2459473 2459473 defendant Risley Richard gent 595705 595705 Risley, Richard, of Cressyngham, gent 3
5523420 2512154 2512154 defendant Garell William laborer 595705 595705 Garell, William, of Cressyngham, laborer 0
5555338 2521564 2521564 defendant Hovell Adam husbandman 595705 595705 Hovell, Adam, of Cressyngham, husbandman 2
5558597 2522467 2522467 defendant Crosse Thomas husbandman 595705 595705 Crosse, Thomas, of Cressyngham, husbandman 3

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