names

10 rows where place_id = 717048

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4165533 2083446 2083446 defendant Smyth George (legal representative) 717048 717048 Smyth, George, of Chilwell, gent, executrix of 0
4217670 2101674 2101674 defendant Bugge John yeoman 717048 717048 Bugge, John, of Chilwell, yeoman 1
4425874 2172895 2172895 defendant Martel Hugh   717048 717048 (Martel, Hugh, of Chilwell 1
4477458 2193613 2193613 defendant Jakson Thomas   717048 717048 Jakson, Thomas, of Chilwell 1
4739211 2277356 2277356 defendant Hopwell John husbandman 717048 717048 Hopwell, John, of Chilwell, husbandman 3
5011689 2360268 2360268 defendant Tarason John   717048 717048 Tarason, John, of Chilwell, mason 1
5037220 2367755 2367755 defendant Shireson John husbandman 717048 717048 Shireson, John, of Chilwell, husbandman 0
5098974 2386129 2386129 defendant Rekes Henry husbandman 717048 717048 Rekes, Henry, of Chilwell, husbandman 0
5350113 2460158 2460158 defendant Ranson or Rauson Robert laborer 717048 717048 Ranson or Rauson, Robert, of Chilwell, laborer 10
5350114 2460158 2460158 defendant Kaderey William laborer 717048 717048 Kaderey, William, of Chilwell, laborer 11

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);