names

16 rows where place_id = 587035

✎ 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
3590307 1864612 1864612 defendant Broke John gent 587035 587035 Broke, John, of Estbury, gent 0
3590308 1864612 1864612 defendant Adyngton Richard yeoman 587035 587035 Adyngton, Richard, of Estbury, yeoman 1
3590309 1864612 1864612 defendant Sibthorp Thomas butcher 587035 587035 Sibthorp, Thomas, of Estbury, butcher 2
3802858 1958790 1958790 defendant Walrond John yeoman 587035 587035 Walrond, John, of Estbury, yeoman 0
4024760 2033539 2033539 plaintiff Bothe Mathew tailor 587035 587035 Bothe, Mathew, of Estbury, tailor 0
4443285 2182861 2182861 plaintiff Carpenter William   587035 587035 Carpenter, William, of Estbury 0
4512887 2204462 2204462 plaintiff Braundys John fishmonger 587035 587035 Braundys, John, of Estbury, fishmonger 0
4512895 2204465 2204465 plaintiff Braundyssh John fishmonger 587035 587035 Braundyssh, John, of Estbury, fishmonger 0
4512897 2204466 2204466 plaintiff Braundyssh John fishmonger 587035 587035 Braundyssh, John, of Estbury, fishmonger 0
4653747 2247093 2247093 defendant Touke John husbandman 587035 587035 Touke, John, of Estbury, husbandman 9
4653760 2247095 2247095 defendant Blakgrove William husbandman 587035 587035 Blakgrove, William, of Estbury, husbandman 2
4653761 2247095 2247095 defendant Touke or Tonke John husbandman 587035 587035 Touke or Tonke, John, of Estbury, husbandman 3
4653779 2247096 2247096 defendant Blakgrove William husbandman 587035 587035 Blakgrove, William, of Estbury, husbandman 15
4653780 2247096 2247096 defendant Touke John husbandman 587035 587035 Touke, John, of Estbury, husbandman 16
4723655 2272704 2272704 plaintiff Dolman Robert   587035 587035 Dolman, Robert, of Estbury 0
5313626 2449103 2449103 defendant Gifford John, senior husbandman 587035 587035 Gifford, John, senior, of Estbury, husbandman 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);