names

12 rows where place_id = 637224

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3835171 1968940 1968940 defendant Brampton William gent 637224 637224 Brampton, William, of Attilborough, gent 0
3835175 1968941 1968941 defendant Brampton William gent 637224 637224 Brampton, William, of Attilborough, gent 0
3835178 1968942 1968942 defendant Brampton William gent 637224 637224 Brampton, William, of Attilborough, gent 0
4355219 2149047 2149047 defendant Lyncoln Thomas sawyer 637224 637224 Lyncoln, Thomas, of Attilborough, sawyer 0
4355220 2149047 2149047 defendant Cooper Ralph husbandman 637224 637224 Cooper, Ralph, of Attilborough, husbandman 1
4355221 2149047 2149047 defendant Symson Andrew husbandman 637224 637224 Symson, Andrew, of Attilborough, husbandman 2
4355222 2149047 2149047 defendant Ayres John husbandman 637224 637224 Ayres, John, of Attilborough, husbandman 3
4383521 2159197 2159197 defendant Standley William (legal representative) 637224 637224 Standley, William, of Attilborough, husbandman, administratrix of 0
4410751 2168186 2168186 defendant Parson Robert husbandman 637224 637224 Parson, Robert, of Attilborough, husbandman 1
5357170 2462304 2462304 defendant George Richard husbandman 637224 637224 George, Richard, of Attilborough, husbandman 0
5357171 2462304 2462304 defendant Orchard Richard husbandman 637224 637224 Orchard, Richard, of Attilborough, husbandman 1
5357172 2462304 2462304 defendant Sutton Richard husbandman 637224 637224 Sutton, Richard, of Attilborough, husbandman 2

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