names

13 rows where case_id = 2337529

✎ 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
4935605 2337529 2337529 plaintiff Berkeley Maurice knight   Berkeley, Maurice, knight 0
4935606 2337529 2337529 defendant Clerk Elias parson of Northfeld   Clerk, Elias, parson of Northfeld 0
4935607 2337529 2337529 defendant Clerk William smith 757365 757365 Clerk, William, of Dudeley, smith 1
4935608 2337529 2337529 defendant Fraunces Richard yeoman 757365 757365 Fraunces, Richard, of Dudeley, yeoman 2
4935609 2337529 2337529 defendant Maddok Nicholas yeoman 757365 757365 Maddok, Nicholas, of Dudeley, yeoman 3
4935610 2337529 2337529 defendant Fyssher William fisher 757365 757365 Fyssher, William, of Dudeley, fisher 4
4935611 2337529 2337529 defendant Patyncham Elias smith 757365 757365 together with Patyncham, Elias, of Dudeley, smith 5
4935612 2337529 2337529 defendant Jones John yeoman 757365 757365 Jones, John, of Dudeley, yeoman 6
4935613 2337529 2337529 defendant Merihurst William cordwainer 757365 757365 Merihurst, William, of Dudeley, cordwainer 7
4935614 2337529 2337529 defendant Birchore William husbandman 757365 757365 Birchore, William, of Dudeley, husbandman 8
4935615 2337529 2337529 defendant Meweford William husbandman 757365 757365 Meweford, William, of Dudeley, husbandman 9
4935616 2337529 2337529 defendant Mokkelowe Thomas smith 757365 757365 Mokkelowe, Thomas, of Dudeley, smith 10
4935617 2337529 2337529 defendant Brooke Roger husbandman 757365 757365 Brooke, Roger, of Dudeley, husbandman 11

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