names

15 rows where place_id = 586379

✎ 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
3588559 1864065 1864065 plaintiff Bevyn or Benyn Thomas   586379 586379 Bevyn or Benyn, Thomas, of Brigewater 0
3627101 1903338 1903338 defendant Red John dyer 586379 586379 Red, John, of Brigewater, dyer 0
3628870 1903905 1903905 defendant Davy John merchant 586379 586379 Davy, John, of Brigewater, merchant 0
3684036 1921141 1921141 defendant Morell Hugh merchant 586379 586379 Morell, Hugh, of Brigewater, merchant 0
3690501 1923196 1923196 defendant Morell Hugh merchant 586379 586379 Morell, Hugh, of Brigewater, merchant 0
3712448 1930209 1930209 defendant Terell Richard merchant 586379 586379 Terell, Richard, of Brigewater, merchant 1
3784489 1952934 1952934 defendant Oder Robert merchant 586379 586379 Oder, Robert, of Brigewater, merchant 1
3784490 1952934 1952934 defendant Hokyns Thomas chapman 586379 586379 Hokyns, Thomas, of Brigewater, chapman 2
3805817 1959759 1959759 defendant Wattys John mercer 586379 586379 Wattys, John, of Brigewater, mercer 0
3828847 1966902 1966902 defendant Skelton Alexander merchant 586379 586379 Skelton, Alexander, of Brigewater, merchant 1
3860701 1977072 1977072 defendant Crane Thomas chaplain 586379 586379 Crane, Thomas, of Brigewater, chaplain 0
3966067 2012753 2012753 plaintiff Blake Robert merchant 586379 586379 Blake, Robert, of Brigewater, merchant 0
4530645 2209879 2209879 defendant Matheu John   586379 586379 Matheu, John, of Brigewater 0
5272020 2436897 2436897 defendant Kendale John merchant 586379 586379 Kendale, John, of Brigewater, merchant 4
5515885 2509818 2509818 defendant Horsey William tanner 586379 586379 Horsey, William, of Brigewater, tanner 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);