names

23 rows where place_id = 593404

✎ 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
3611675 1871317 1871317 defendant Combe Robert husbandman 593404 593404 Combe, Robert, of Bradston, husbandman 1
3611676 1871317 1871317 defendant Dobyll William husbandman 593404 593404 Dobyll, William, of Bradston, husbandman 2
3611681 1871317 1871317 defendant Turnour Gregory husbandman 593404 593404 Turnour, Gregory, of Bradston, husbandman 7
3611685 1871318 1871318 defendant Combe Robert husbandman 593404 593404 Combe, Robert, of Bradston, husbandman 1
3611686 1871318 1871318 defendant Dovyll or Dobyll William, senior husbandman 593404 593404 Dovyll or Dobyll, William, senior, of Bradston, husbandman 2
3611687 1871318 1871318 defendant White Thomas husbandman 593404 593404 White, Thomas, of Bradston, husbandman 3
3611691 1871318 1871318 defendant Turnour Gregory husbandman 593404 593404 Turnour, Gregory, of Bradston, husbandman 7
3850096 1973625 1973625 defendant Browne Richard   593404 593404 Browne, Richard, of Bradston, mason 2
3901143 1990607 1990607 defendant Acombe John laborer 593404 593404 Acombe, John, of Bradston, laborer 2
4058841 2045557 2045557 plaintiff Clowbery Oliver gent 593404 593404 Clowbery, Oliver, of Bradston, gent 0
4306544 2132426 2132426 defendant Dower John yeoman 593404 593404 Dower, John, of Bradston, yeoman 4
4684499 2260755 2260755 defendant Wylman John fisher 593404 593404 Wylman, John, of Bradston, fisher 0
4759550 2283327 2283327 defendant Boxwell John husbandman 593404 593404 Boxwell, John, of Bradston, husbandman 0
4787183 2292058 2292058 defendant Smyth Richard husbandman 593404 593404 Smyth, Richard, of Bradston, husbandman 0
4787184 2292058 2292058 defendant Smyth Robert laborer 593404 593404 Smyth, Robert, of Bradston, laborer 1
4787185 2292058 2292058 defendant Smyth John, junior ploughman 593404 593404 Smyth, John, junior, of Bradston, ploughman 2
4811926 2299843 2299843 defendant Hervy John husbandman 593404 593404 Hervy, John, of Bradston, husbandman 5
5002648 2357688 2357688 defendant Milleward William   593404 593404 Milleward, William, of Bradston, mill ward 3
5027764 2364995 2364995 defendant Dobell Margaret widow 593404 593404 Dobell, Margaret, of Bradston, ,widow 10
5253387 2431162 2431162 defendant White Thomas husbandman 593404 593404 White, Thomas, of Bradston, husbandman 1
5253388 2431162 2431162 defendant White William   593404 593404 White, William, of Bradston, groom 2
5253389 2431162 2431162 defendant Hamond Henry   593404 593404 Hamond, Henry, of Bradston, groom 3
5313179 2448974 2448974 defendant Hervy John yeoman 593404 593404 Hervy, John, of Bradston, 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);