names

30 rows where place_id = 619175

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3728555 1935181 1935181 defendant Becka Elias yeoman 619175 619175 Becka, Elias, of Congleton, Cheshire, yeoman 0
3730249 1935689 1935689 defendant Becka Elias yeoman 619175 619175 Becka, Elias, of Congleton, Cheshire, yeoman 0
3873579 1981385 1981385 defendant Wagge Humphrey caryer 619175 619175 Wagge, Humphrey, of Congleton, Cheshire, caryer 0
3873582 1981386 1981386 defendant Wagge Humphrey caryer 619175 619175 Wagge, Humphrey, of Congleton, Cheshire, caryer 0
3886500 1985739 1985739 defendant Foxsallis Simon chapman 619175 619175 Foxsallis, Simon, of Congleton, Cheshire, chapman 1
3945367 2005464 2005464 defendant Wagge John glover 619175 619175 Wagge, John, of Congleton, Cheshire, glover 0
3955795 2009102 2009102 defendant Maddock William   619175 619175 Maddock, William, of Congleton, Cheshire 0
3974012 2015480 2015480 plaintiff Hardinge John husbandman 619175 619175 Hardinge, John, of Congleton, Cheshire, husbandman 0
3992715 2022145 2022145 defendant Spencer Richard gent 619175 619175 Spencer, Richard, of Congleton, Cheshire, gent 0
4024759 2033538 2033538 defendant Walmesley Roger   619175 619175 Walmesley, Roger, of Congleton, Cheshire, surgeon 0
4024761 2033539 2033539 defendant Walmesley Roger   619175 619175 Walmesley, Roger, of Congleton, Cheshire, surgeon 0
4028330 2034784 2034784 defendant Plante James mercer 619175 619175 Plante, James, of Congleton, Cheshire, mercer 0
4029193 2035086 2035086 plaintiff Cumberbache Thomas tanner 619175 619175 Cumberbache, Thomas, of Congleton, Cheshire, tanner 0
4029197 2035087 2035087 defendant Clutton Thomas husbandman 619175 619175 Clutton, Thomas, of Congleton, Cheshire, husbandman 0
4077660 2052298 2052298 defendant Barrett Richard clerk 619175 619175 Barrett, Richard, of Congleton, Cheshire, clerk 0
4077669 2052302 2052302 plaintiff Stevynson William   619175 619175 Stevynson, William, of Congleton, Cheshire, linenn draper 0
4091480 2057244 2057244 defendant Smythe John yeoman 619175 619175 Smythe, John, of Congleton, Cheshire, yeoman 1
4112934 2064894 2064894 plaintiff Stevenson William   619175 619175 Stevenson, William, of Congleton, Cheshire, linen draper 0
4208090 2098388 2098388 defendant Spencer Richard gent 619175 619175 Spencer, Richard, of Congleton, Cheshire, gent 3
4212800 2100013 2100013 defendant Reade James yeoman 619175 619175 Reade, James, of Congleton, Cheshire, yeoman 1
4216392 2101227 2101227 defendant Haworth Henry yeoman 619175 619175 Haworth, Henry, of Congleton, Cheshire, yeoman 0
4231108 2106382 2106382 defendant Phithyon or Fythyon John mercer 619175 619175 Phithyon or Fythyon, John, of Congleton, Cheshire, mercer 0
4231113 2106384 2106384 defendant Greene Richard chapman 619175 619175 Greene, Richard, of Congleton, Cheshire, chapman 1
4239843 2109571 2109571 defendant Paynton John husbandman 619175 619175 Paynton, John, of Congleton, Cheshire, husbandman 1
4273362 2120653 2120653 defendant Phithyon John mercer 619175 619175 Phithyon, John, of Congleton, Cheshire, mercer 0
4273367 2120655 2120655 defendant Greene Richard chapman 619175 619175 Greene, Richard, of Congleton, Cheshire, chapman 1
4342376 2144606 2144606 defendant Spencer Robert mercer 619175 619175 Spencer, Robert, of Congleton, Cheshire, mercer 1
4360584 2150954 2150954 defendant Phethyan John chapman 619175 619175 Phethyan, John, of Congleton, Cheshire, chapman 0
4366254 2152971 2152971 defendant Spencer Robert mercer 619175 619175 Spencer, Robert, of Congleton, Cheshire, mercer 2
5550471 2520160 2520160 defendant Rathbon John yeoman 619175 619175 (Rathbon, John, of Congleton, Cheshire, yeoman 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);