names

22 rows where place_id = 639667

✎ 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
3850297 1973680 1973680 defendant Oldham John husbandman 639667 639667 Oldham, John, of Shirland, husbandman 0
4443870 2183053 2183053 defendant Deye Roger   639667 639667 Deye, Roger, of Shirland 3
4613956 2235378 2235378 defendant Misterton William   639667 639667 Misterton, William, of Shirland 0
4634967 2241783 2241783 defendant Bonere John   639667 639667 Bonere, John, of Shirland, parson 0
4650781 2246248 2246248 defendant Bover John   639667 639667 Bover, John, of Shirland, parson 3
4768543 2286138 2286138 defendant Boner John   639667 639667 Boner, John, of Shirland, parson 0
4843244 2309404 2309404 defendant Barker William yeoman 639667 639667 Barker, William, of Shirland, yeoman 0
4844160 2309682 2309682 defendant Parker William yeoman 639667 639667 Parker, William, of Shirland, yeoman 4
4844168 2309683 2309683 defendant Parker William yeoman 639667 639667 Parker, William, of Shirland, yeoman 4
5006728 2358861 2358861 defendant Parker William yeoman 639667 639667 Parker, William, of Shirland, yeoman 1
5017271 2361935 2361935 defendant West John husbandman 639667 639667 West, John, of Shirland, husbandman 0
5249893 2430080 2430080 defendant Parsons Robert husbandman 639667 639667 Parsons, Robert, of Shirland, husbandman 0
5358081 2462596 2462596 defendant Revell Hugh yeoman 639667 639667 Revell, Hugh, of Shirland, yeoman 2
5358082 2462596 2462596 defendant Bolyngton Thomas yeoman 639667 639667 Bolyngton, Thomas, of Shirland, yeoman 3
5468309 2495463 2495463 defendant Stanesby John yeoman 639667 639667 Stanesby, John, of Shirland, yeoman 6
5468310 2495463 2495463 defendant Dene James laborer 639667 639667 Dene, James, of Shirland, laborer 7
5468311 2495463 2495463 defendant Clare George weaver 639667 639667 Clare, George, of Shirland, weaver 8
5514484 2509379 2509379 plaintiff Renell or Revell Hugh   639667 639667 Renell or Revell, Hugh, of Shirland 0
5528984 2513586 2513586 defendant Langton Cuthburt gent 639667 639667 Langton, Cuthburt, of Shirland, gent 0
5544256 2518307 2518307 plaintiff Revell or Renell Hugh   639667 639667 Revell or Renell, Hugh, of Shirland 0
5582454 2529584 2529584 defendant Revell Roland gent 639667 639667 Revell, Roland, of Shirland, gent 1
5604401 2536241 2536241 plaintiff Renell or Revell John   639667 639667 Renell or Revell, John, of Shirland 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);