names

15 rows where place_id = 630990

✎ 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
3687515 1922275 1922275 defendant Shelton John   630990 630990 Shelton, John, of Shelton, Norf, knight 1
3732881 1936512 1936512 defendant Shelton John   630990 630990 Shelton, John, of Shelton, Norf, esq, son of Shelton, John, knight 0
3778694 1951051 1951051 defendant Boleyn Edward   630990 630990 Boleyn, Edward, of Shelton, Norf, knight 0
3797805 1957211 1957211 defendant Knevett Edmund esq 630990 630990 Knevett, Edmund, of Shelton, Norf, esq 1
3841631 1970967 1970967 defendant Knyvett Edmund esq 630990 630990 Knyvett, Edmund, of Shelton, Norf, esq 0
3841999 1971054 1971054 defendant Shelton John esq 630990 630990 Shelton, John, of Shelton, Norf, esq 1
3848520 1973118 1973118 defendant Hasyll Robert husbandman 630990 630990 Hasyll, Robert, of Shelton, Norf, husbandman 0
3876100 1982257 1982257 defendant Skelton John clerk 630990 630990 Skelton, John, of Shelton, Norf, clerk 0
3896669 1989096 1989096 defendant Shelton Ralph, junior gent 630990 630990 Shelton, Ralph, junior, of Shelton, Norf, gent 0
3909335 1993418 1993418 defendant Shelton John esq 630990 630990 Shelton, John, of Shelton, Norf, esq 1
4167656 2084184 2084184 defendant Shelton Thomas esq 630990 630990 Shelton, Thomas, of Shelton, Norf, esq 1
4182755 2089446 2089446 defendant Shelton Thomas esq 630990 630990 Shelton, Thomas, of Shelton, Norf, esq 0
4363157 2151888 2151888 defendant Lord Robert bowyer 630990 630990 Lord, Robert, of Shelton, Norf, bowyer 2
4893213 2324592 2324592 defendant Cobalde Roger butcher 630990 630990 Cobalde, Roger, of Shelton, Norf, butcher 0
5239391 2427105 2427105 defendant Bek William clerk 630990 630990 Bek, William, of Shelton, Norf, clerk 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);