names

12 rows where place_id = 600085

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment

id ▼ case_id role surname forename occupation place_id raw_segment seq
3639616 1907199 1907199 defendant Holme William yeoman 600085 600085 Holme, William, of Haukesdale, yeoman 5
3639617 1907199 1907199 defendant Doughty John yeoman 600085 600085 Doughty, John, of Haukesdale, yeoman 6
3639618 1907199 1907199 defendant Gamlynge John yeoman 600085 600085 Gamlynge, John, of Haukesdale, yeoman 7
3639619 1907199 1907199 defendant Blamyre Thomas yeoman 600085 600085 Blamyre, Thomas, of Haukesdale, yeoman 8
4653391 2246994 2246994 defendant Jakson John tailor 600085 600085 Jakson, John, of Haukesdale, tailor 1
4871591 2318085 2318085 defendant Raynaldson Thomas yeoman 600085 600085 Raynaldson, Thomas, of Haukesdale, yeoman 2
4871592 2318085 2318085 defendant Husley Alan yeoman 600085 600085 Husley, Alan, of Haukesdale, yeoman 3
4871593 2318085 2318085 defendant Blamyre William yeoman 600085 600085 Blamyre, William, of Haukesdale, yeoman 4
4899623 2326514 2326514 defendant Raynaldson Thomas yeoman 600085 600085 Raynaldson, Thomas, of Haukesdale, yeoman 23
5292648 2442845 2442845 defendant Tomlynson William yeoman 600085 600085 Tomlynson, William, of Haukesdale, yeoman 13
5292649 2442845 2442845 defendant Hall Richard yeoman 600085 600085 Hall, Richard, of Haukesdale, yeoman 14
5292650 2442845 2442845 defendant Doughty Thomas yeoman 600085 600085 Doughty, Thomas, of Haukesdale, yeoman 15

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