names

13 rows where place_id = 633961

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3815889 1962874 1962874 defendant Buttry John husbandman 633961 633961 Buttry, John, of Rollyngton, husbandman 0
3816939 1963206 1963206 defendant Buttry John yeoman 633961 633961 Buttry, John, of Rollyngton, yeoman 0
3816940 1963206 1963206 defendant Atterton William yeoman 633961 633961 Atterton, William, of Rollyngton, yeoman 1
3816941 1963206 1963206 defendant Royke James yeoman 633961 633961 Royke, James, of Rollyngton, yeoman 2
3816942 1963206 1963206 defendant Marcche Thomas yeoman 633961 633961 Marcche, Thomas, of Rollyngton, yeoman 3
3816943 1963206 1963206 defendant Johnson Thomas husbandman 633961 633961 Johnson, Thomas, of Rollyngton, husbandman 4
3816944 1963206 1963206 defendant Heyton Thomas laborer 633961 633961 Heyton, Thomas, of Rollyngton, laborer 5
3816945 1963206 1963206 defendant Ruyston Thomas laborer 633961 633961 Ruyston, Thomas, of Rollyngton, laborer 6
3816946 1963206 1963206 defendant Norham John laborer 633961 633961 Norham, John, of Rollyngton, laborer 7
3816947 1963206 1963206 defendant Colthouse Robert husbandman 633961 633961 Colthouse, Robert, of Rollyngton, husbandman 8
3816948 1963206 1963206 defendant Harret James laborer 633961 633961 Harret, James, of Rollyngton, laborer 9
3816949 1963206 1963206 defendant Wythes Andrew gent 633961 633961 Wythes, Andrew, of Rollyngton, gent 10
3816950 1963206 1963206 defendant Colthouse Edmund laborer 633961 633961 Colthouse, Edmund, of Rollyngton, 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);