names

25 rows where place_id = 615766

✎ 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
3710649 1929651 1929651 defendant Franklyn John butcher 615766 615766 Franklyn, John, of North Curry, butcher 3
3740454 1938871 1938871 defendant Clowter Walter husbandman 615766 615766 (Clowter, Walter, of North Curry, husbandman 3
3775945 1950225 1950225 defendant Sheparde Robert husbandman 615766 615766 Sheparde, Robert, of North Curry, husbandman 0
3775946 1950225 1950225 defendant Sheparde John husbandman 615766 615766 Sheparde, John, of North Curry, husbandman 1
3775947 1950225 1950225 defendant Bathyn Nicholas husbandman 615766 615766 Bathyn, Nicholas, of North Curry, husbandman 2
3775948 1950225 1950225 defendant Norton Walter husbandman 615766 615766 Norton, Walter, of North Curry, husbandman 3
3775949 1950225 1950225 defendant Arnam William husbandman 615766 615766 Arnam, William, of North Curry, husbandman 4
3775950 1950225 1950225 defendant Arnam John husbandman 615766 615766 Arnam, John, of North Curry, husbandman 5
3785639 1953297 1953297 defendant Gade Nicholas husbandman 615766 615766 Gade, Nicholas, of North Curry, husbandman 0
3802096 1958551 1958551 defendant Gade Nicholas husbandman 615766 615766 Gade, Nicholas, of North Curry, husbandman 0
3855478 1975358 1975358 defendant Curry William husbandman 615766 615766 Curry, William, of North Curry, husbandman 0
3855479 1975358 1975358 defendant Marshall John husbandman 615766 615766 Marshall, John, of North Curry, husbandman 1
3855481 1975359 1975359 defendant Farmer William husbandman 615766 615766 Farmer, William, of North Curry, husbandman 0
3855482 1975359 1975359 defendant Curry Robert husbandman 615766 615766 Curry, Robert, of North Curry, husbandman 1
3855483 1975359 1975359 defendant Hayne John husbandman 615766 615766 Hayne, John, of North Curry, husbandman 2
3855484 1975359 1975359 defendant Galy or Ealy John, junior husbandman 615766 615766 Galy or Ealy, John, junior, of North Curry, husbandman 3
3999583 2024617 2024617 defendant Morse John gent 615766 615766 Morse, John, of North Curry, gent 1
4093382 2057951 2057951 defendant Stacye William yeoman 615766 615766 Stacye, William, of North Curry, yeoman 0
4096989 2059250 2059250 defendant Ayssheford Nicholas gent 615766 615766 Ayssheford, Nicholas, of North Curry, gent 3
4131844 2071702 2071702 defendant Besley George husbandman 615766 615766 Besley, George, of North Curry, husbandman 1
4131846 2071702 2071702 defendant Lyder Simon husbandman 615766 615766 Lyder, Simon, of North Curry, husbandman 3
4145733 2076660 2076660 defendant Sheldon William husbandman 615766 615766 Sheldon, William, of North Curry, husbandman 0
4208572 2098548 2098548 defendant Selye John husbandman 615766 615766 Selye, John, of North Curry, husbandman 0
4301691 2130710 2130710 defendant Henborowe John husbandman 615766 615766 Henborowe, John, of North Curry, husbandman 3
4302714 2131066 2131066 defendant Collyer Richard yeoman 615766 615766 Collyer, Richard, of North Curry, yeoman 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);