names

12 rows where place_id = 621390

✎ 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
3741123 1939086 1939086 defendant Bott Thomas husbandman 621390 621390 Bott, Thomas, of Hondesworth, husbandman 0
3868175 1979593 1979593 defendant Osborne Richard yeoman 621390 621390 Osborne, Richard, of Hondesworth, yeoman 0
3882030 1984248 1984248 defendant Osborne Richard yeoman 621390 621390 Osborne, Richard, of Hondesworth, yeoman 0
3901310 1990662 1990662 defendant Cokys Thomas (legal representative) 621390 621390 Cokys, Thomas, of Hondesworth, husbandman, executrix of 1
3940361 2003796 2003796 defendant Smalwood William husbandman 621390 621390 Smalwood, William, of Hondesworth, husbandman 0
4220282 2102599 2102599 defendant Grove Thomas yeoman 621390 621390 Grove, Thomas, of Hondesworth, yeoman 0
4289775 2126404 2126404 defendant Grove Thomas yeoman 621390 621390 Grove, Thomas, of Hondesworth, yeoman 0
5299963 2444953 2444953 defendant Loveldey John clerk 621390 621390 Loveldey, John, of Hondesworth, clerk 0
5483799 2500099 2500099 defendant Aston John clerk 621390 621390 Aston, John, of Hondesworth, clerk 0
5519962 2511081 2511081 defendant Smalwod William husbandman 621390 621390 Smalwod, William, of Hondesworth, husbandman 1
5519963 2511081 2511081 defendant Redhill Roger husbandman 621390 621390 Redhill, Roger, of Hondesworth, husbandman 2
5531687 2514446 2514446 defendant Coke William husbandman 621390 621390 Coke, William, of Hondesworth, 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);