names

17 rows where case_id = 1920123

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3680948 1920123 1920123 plaintiff Sayntur Edmund     Sayntur, Edmund 0
3680949 1920123 1920123 plaintiff York Thomas     York, Thomas 1
3680950 1920123 1920123 defendant Markeham William husbandman 599394 599394 Markeham, William, of Newland, husbandman 0
3680951 1920123 1920123 defendant Rissholm Richard husbandman 599394 599394 Rissholm, Richard, of Newland, husbandman 1
3680952 1920123 1920123 defendant Taillour Robert husbandman 599394 599394 Taillour, Robert, of Newland, husbandman 2
3680953 1920123 1920123 defendant Cherihom George     Cherihom, George 3
3680954 1920123 1920123 defendant Clayton John     Clayton, John 4
3680955 1920123 1920123 defendant Taillour George plowwright   Taillour, George, plowwright 5
3680956 1920123 1920123 defendant Turnour John fisher   Turnour, John, fisher 6
3680957 1920123 1920123 defendant Dyssheworth Thomas laborer   Dyssheworth, Thomas, laborer 7
3680958 1920123 1920123 defendant Turnour William     Turnour, William 8
3680959 1920123 1920123 defendant Clayton Thomas     Clayton, Thomas 9
3680960 1920123 1920123 defendant Clayton Richard     Clayton, Richard 10
3680961 1920123 1920123 defendant Clayton William     Clayton, William 11
3680962 1920123 1920123 defendant Fulbrigge William     Fulbrigge, William 12
3680963 1920123 1920123 defendant Priourman John husbandman   Priourman, John, husbandman 13
3680964 1920123 1920123 defendant Moreley John     Moreley, John 14

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