names

25 rows where place_id = 593628

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612624 1871585 1871585 defendant Dey John, senior husbandman 593628 593628 Dey, John, senior, of Westonyng, husbandman 0
3612625 1871585 1871585 defendant Dey William, junior husbandman 593628 593628 Dey, William, junior, of Westonyng, husbandman 1
3612626 1871585 1871585 defendant Gobyon Richard husbandman 593628 593628 Gobyon, Richard, of Westonyng, husbandman 2
3612627 1871585 1871585 defendant Gyles Henry husbandman 593628 593628 Gyles, Henry, of Westonyng, husbandman 3
3657860 1912707 1912707 defendant Turpyn John husbandman 593628 593628 Turpyn, John, of Westonyng, husbandman 1
3766377 1947138 1947138 defendant Dey William yeoman 593628 593628 Dey, William, of Westonyng, yeoman 4
3803052 1958857 1958857 defendant Dey William yeoman 593628 593628 Dey, William, of Westonyng, yeoman 0
3821864 1964726 1964726 defendant Butte William gent 593628 593628 Butte, William, of Westonyng, gent 0
3828246 1966704 1966704 defendant Butte William gent 593628 593628 Butte, William, of Westonyng, gent 0
3877138 1982595 1982595 defendant Clerke John yeoman 593628 593628 (Clerke, John, of Westonyng, yeoman 1
3898138 1989585 1989585 defendant Pecokke Thomas yeoman 593628 593628 Pecokke, Thomas, of Westonyng, yeoman 1
3984053 2019065 2019065 defendant Parsons alias Bradewaye Henry husbandman 593628 593628 Parsons alias Bradewaye, Henry, of Westonyng, husbandman 0
4388436 2160770 2160770 defendant Punter William yeoman 593628 593628 Punter, William, of Westonyng, yeoman 0
4827177 2304546 2304546 defendant Worthyng John maltman 593628 593628 Worthyng, John, of Westonyng, maltman 0
5303812 2446138 2446138 defendant Gylys Henry husbandman 593628 593628 Gylys, Henry, of Westonyng, husbandman 0
5314095 2449230 2449230 defendant Hocclyf John laborer 593628 593628 Hocclyf, John, of Westonyng, laborer 4
5336760 2456062 2456062 defendant Bakewell John yeoman 593628 593628 Bakewell, John, of Westonyng, yeoman 0
5336761 2456062 2456062 defendant Badman John laborer 593628 593628 Badman, John, of Westonyng, laborer 1
5336762 2456062 2456062 defendant Dyer John laborer 593628 593628 Dyer, John, of Westonyng, laborer 2
5336763 2456062 2456062 defendant Dey John laborer 593628 593628 Dey, John, of Westonyng, laborer 3
5397433 2474352 2474352 defendant Samson John husbandman 593628 593628 Samson, John, of Westonyng, husbandman 0
5397434 2474352 2474352 defendant Dey John husbandman 593628 593628 Dey, John, of Westonyng, husbandman 1
5401538 2475510 2475510 plaintiff Henyngton Thomas, senior   593628 593628 Henyngton, Thomas, senior, of Westonyng 1
5401540 2475510 2475510 defendant Gosse Henry husbandman 593628 593628 Gosse, Henry, of Westonyng, husbandman 1
5406432 2476912 2476912 defendant Stratton alias Styrton Thomas husbandman 593628 593628 Stratton alias Styrton, Thomas, of Westonyng, 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);