names

29 rows where place_id = 586222

✎ 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
3588200 1863965 1863965 defendant Cook Richard husbandman 586222 586222 Cook, Richard, of Barre, husbandman 1
3588201 1863965 1863965 defendant Elys Thomas yeoman 586222 586222 Elys, Thomas, of Barre, yeoman 2
3588203 1863965 1863965 defendant Smyth William husbandman 586222 586222 Smyth, William, of Barre, husbandman 4
3600833 1867925 1867925 defendant Bowedok William husbandman 586222 586222 Bowedok, William, of Barre, husbandman 0
3773125 1949298 1949298 defendant Robyns George chaplain 586222 586222 Robyns, George, of Barre, chaplain 0
3836733 1969389 1969389 defendant Scott William yeoman 586222 586222 Scott, William, of Barre, yeoman 0
3853336 1974665 1974665 defendant Sylfeld William chaplain 586222 586222 Sylfeld, William, of Barre, chaplain 0
3854898 1975176 1975176 defendant Cokkes Edward husbandman 586222 586222 Cokkes, Edward, of Barre, husbandman 0
3897953 1989522 1989522 defendant Burguland Thomas yeoman 586222 586222 Burguland, Thomas,of Barre, yeoman 0
3906452 1992452 1992452 defendant Cockys John   586222 586222 Cockys, John, of Barre, "sporyer" 0
3906453 1992452 1992452 defendant Starke Henry tailor 586222 586222 Starke, Henry, of Barre, tailor 1
3906454 1992452 1992452 defendant Bracebrigge John gent 586222 586222 Bracebrigge, John, of Barre, gent 2
3906455 1992452 1992452 defendant Shelfeld Richard butcher 586222 586222 Shelfeld, Richard, of Barre, butcher 3
3915319 1995490 1995490 defendant Clylterne Thomas yeoman 586222 586222 Clylterne, Thomas, of Barre, yeoman 0
3920715 1997276 1997276 defendant Sheffeld Richard butcher 586222 586222 Sheffeld, Richard, of Barre, butcher 2
3966917 2013062 2013062 plaintiff Scott William yeoman 586222 586222 Scott, William, of Barre, yeoman 1
3966920 2013063 2013063 plaintiff Scott William yeoman 586222 586222 Scott, William, of Barre, yeoman 1
4418817 2170752 2170752 defendant Fremon John le   586222 586222 Fremon, John le, of Barre 1
4422999 2172051 2172051 plaintiff Fremon John le   586222 586222 Fremon, John le, of Barre 0
4423001 2172052 2172052 plaintiff Fremon John le   586222 586222 Fremon, John le, of Barre 0
4439398 2181588 2181588 defendant Newemon John   586222 586222 Newemon, John, of Barre 0
4449942 2184936 2184936 defendant Braddeley Robert   586222 586222 Braddeley, Robert, of Barre 3
4449943 2184936 2184936 defendant Warde Thomas   586222 586222 Warde, Thomas, of Barre 4
4449944 2184936 2184936 defendant Webbe William   586222 586222 Webbe, William, of Barre 5
4449945 2184936 2184936 defendant Thomas John   586222 586222 Thomas, John, of Barre 6
4633313 2241281 2241281 defendant Couper William   586222 586222 Couper, William, of Barre 0
4683289 2260378 2260378 defendant Bromwych Thomas husbandman 586222 586222 Bromwych, Thomas, of Barre, husbandman 0
5128269 2394744 2394744 defendant Smyth William smith 586222 586222 Smyth, William, of Barre, smith 0
5495003 2503399 2503399 defendant Wryght Thomas tailor 586222 586222 Wryght, Thomas, of Barre, tailor 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);