names

8 rows where place_id = 619672

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3731254 1935999 1935999 defendant Cavendyssh George gent 619672 619672 Cavendyssh, George, of Houghton Regis, Beds, gent 0
3888942 1986545 1986545 plaintiff Fossey William husbandman 619672 619672 Fossey, William, of Houghton Regis, Beds, husbandman 0
4170556 2085198 2085198 defendant Caryngton Henry yeoman 619672 619672 Caryngton, Henry, of Houghton Regis, Beds, yeoman 0
5270434 2436453 2436453 defendant Devny William husbandman 619672 619672 Devny, William, of Houghton Regis, Beds, husbandman 0
5282804 2440032 2440032 defendant Davy William husbandman 619672 619672 Davy, William, of Houghton Regis, Beds, husbandman 0
5307686 2447313 2447313 defendant Clerk Richard husbandman 619672 619672 Clerk, Richard, of Houghton Regis, Beds, husbandman 0
5310216 2448089 2448089 defendant Craweley William husbandman 619672 619672 Craweley, William, of Houghton Regis, Beds, husbandman 0
5348615 2459698 2459698 defendant Davy William husbandman 619672 619672 Davy, William, of Houghton Regis, Beds, husbandman 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);