names

15 rows where place_id = 627208

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3774805 1949847 1949847 defendant Michell Edward husbandman 627208 627208 Michell, Edward, of Aston, Herts, husbandman 3
3774809 1949849 1949849 defendant Michell Edward husbandman 627208 627208 Michell, Edward, of Aston, Herts, husbandman 0
3813706 1962198 1962198 defendant Agaster Luke maltman 627208 627208 Agaster, Luke, of Aston, Herts, maltman 3
4256577 2115170 2115170 defendant Watkins William yeoman 627208 627208 Watkins, William, of Aston, Herts, yeoman 2
4268757 2119142 2119142 defendant Hawkyns William yeoman 627208 627208 Hawkyns, William, of Aston, Herts, yeoman 3
4284426 2124479 2124479 defendant North Alice yeoman 627208 627208 North, Alice, of Aston, Herts, yeoman 2
4291311 2126965 2126965 defendant Kent Thomas gent 627208 627208 Kent, Thomas, of Aston, Herts, gent 0
4342430 2144624 2144624 defendant Kente Thomas gent 627208 627208 Kente, Thomas, of Aston, Herts, gent 1
4819280 2302110 2302110 defendant Burton Thomas   627208 627208 Burton, Thomas, of Aston, Herts, parson 0
4819298 2302113 2302113 defendant Burton Thomas   627208 627208 Burton, Thomas, of Aston, Herts, parson 0
4988477 2353515 2353515 plaintiff Bradford William   627208 627208 Bradford, William, of Aston, Herts, parson 0
4988479 2353515 2353515 defendant Breet John husbandman 627208 627208 Breet, John, of Aston, Herts, husbandman 1
5248977 2429824 2429824 defendant Kent William husbandman 627208 627208 Kent, William, of Aston, Herts, husbandman 1
5265775 2435048 2435048 defendant Halle William clerk 627208 627208 Halle, William, of Aston, Herts, or of Sotherey, Norf, clerk 0
5456663 2491917 2491917 defendant Michell John husbandman 627208 627208 (Michell, John, of Aston, Herts, 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);