names

12 rows where place_id = 781953

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4675167 2257846 2257846 defendant Wilson John yeoman 781953 781953 Wilson, John, of Wederell, yeoman 1
4675168 2257846 2257846 defendant Nobyll John yeoman 781953 781953 Nobyll, John, of Wederell, yeoman 2
4675171 2257846 2257846 defendant Huet Robert yeoman 781953 781953 Huet, Robert, of Wederell, yeoman 5
4852310 2312146 2312146 defendant Sharparowe Thomas yeoman 781953 781953 Sharparowe, Thomas, of Wederell, yeoman 0
4852312 2312146 2312146 defendant Pavy William yeoman 781953 781953 Pavy, William, of Wederell, yeoman 2
4852313 2312146 2312146 defendant Maghan John yeoman 781953 781953 Maghan, John, of Wederell, yeoman 3
4983040 2351831 2351831 defendant Hobson William yeoman 781953 781953 Hobson, William, of Wederell, yeoman 6
4983043 2351831 2351831 defendant Darman Robert yeoman 781953 781953 Darman, Robert, of Wederell, yeoman 9
4983044 2351831 2351831 defendant Stevenson Gilbert yeoman 781953 781953 Stevenson, Gilbert, of Wederell, yeoman 10
4983045 2351831 2351831 defendant Bonthom or Bouthom Robert yeoman 781953 781953 Bonthom or Bouthom, Robert, of Wederell, yeoman 11
4983046 2351831 2351831 defendant Gervaux John yeoman 781953 781953 Gervaux, John, of Wederell, yeoman 12
4983047 2351831 2351831 defendant Patanson John yeoman 781953 781953 Patanson, John, of Wederell, yeoman 13

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