names

15 rows where place_id = 707159

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4166551 2083796 2083796 defendant Salter John husbandman 707159 707159 Salter, John, of Attlebrigge, husbandman 1
4175740 2086987 2086987 defendant Morse Richard carpenter 707159 707159 Morse, Richard, of Attlebrigge, carpenter 3
4211019 2099411 2099411 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 0
4242863 2110604 2110604 defendant Waffe George yeoman 707159 707159 Waffe, George, of Attlebrigge, yeoman 0
4243609 2110848 2110848 defendant Waffe George yeoman 707159 707159 Waffe, George, of Attlebrigge, yeoman 0
4266251 2118350 2118350 defendant Peters Simon yeoman 707159 707159 Peters, Simon, of Attlebrigge, yeoman 0
4280657 2123138 2123138 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 1
4289720 2126386 2126386 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 1
4342661 2144704 2144704 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 0
4344551 2145371 2145371 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 0
4346403 2145998 2145998 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 0
4352592 2148142 2148142 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 0
4353934 2148603 2148603 defendant Basye Edmund husbandman 707159 707159 Basye, Edmund, of Attlebrigge, husbandman 0
4373583 2155620 2155620 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 0
4406715 2166814 2166814 defendant Peter Simon yeoman 707159 707159 Peter, Simon, of Attlebrigge, yeoman 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);