names

21 rows where place_id = 609332

✎ 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
3677987 1919159 1919159 defendant Glossop Thomas   609332 609332 Glossop, Thomas, of Callowe, yeoman, administrators of 2
3677988 1919159 1919159 defendant Damport Bartholomew husbandman 609332 609332 (Damport, Bartholomew, of Callowe, husbandman 3
3677989 1919159 1919159 defendant Damport Matilda William, yeoman 609332 609332 Matilda his wife): Eyre, William, of Callowe, yeoman 4
3939796 2003610 2003610 defendant Watson Ralph husbandman 609332 609332 Watson, Ralph, of Callowe, husbandman 3
3939797 2003610 2003610 defendant Verney Thomas laborer 609332 609332 Verney, Thomas, of Callowe, laborer 4
4116446 2066171 2066171 defendant Hyll William cordwainer 609332 609332 Hyll, William, of Callowe, cordwainer 0
4158671 2081105 2081105 defendant Hyll William cordwainer 609332 609332 Hyll, William, of Callowe, cordwainer 1
4182480 2089350 2089350 defendant Pullen Thomas yeoman 609332 609332 Pullen, Thomas, of Callowe, yeoman 0
4298857 2129687 2129687 defendant Watson Richard husbandman 609332 609332 Watson, Richard, of Callowe, husbandman 1
4998773 2356521 2356521 defendant Robynson John husbandman 609332 609332 Robynson, John, of Callowe, husbandman 1
5523905 2512300 2512300 defendant Forde Thomas yeoman 609332 609332 Forde, Thomas, of Callowe, yeoman 1
5534580 2515356 2515356 defendant Glossop Thomas yeoman 609332 609332 Glossop, Thomas, of Callowe, yeoman 4
5534744 2515408 2515408 defendant Glossop Thomas yeoman 609332 609332 Glossop, Thomas, of Callowe, yeoman 0
5535095 2515506 2515506 defendant Glossop Thomas yeoman 609332 609332 Glossop, Thomas, of Callowe, yeoman 0
5535096 2515506 2515506 defendant Eyre William yeoman 609332 609332 Eyre, William, of Callowe, yeoman 1
5535247 2515553 2515553 defendant Eyre William yeoman 609332 609332 Eyre, William, of Callowe, yeoman 0
5535251 2515554 2515554 defendant Eyre William yeoman 609332 609332 Eyre, William, of Callowe, yeoman 0
5574505 2527108 2527108 defendant Forthe Thomas husbandman 609332 609332 Forthe, Thomas, of Callowe, husbandman 4
5593032 2532808 2532808 defendant Eyre William yeoman 609332 609332 Eyre, William, of Callowe, yeoman 2
5594787 2533342 2533342 defendant Eyre William yeoman 609332 609332 Eyre, William, of Callowe, yeoman 1
5599133 2534613 2534613 defendant Eyre William yeoman 609332 609332 Eyre, William, of Callowe, 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);