names

13 rows where case_id = 1908245

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642939 1908245 1908245 plaintiff Colepeper Alexander     Colepeper, Alexander 0
3642940 1908245 1908245 defendant Maplisden Thomas butcher 585864 585864 Maplisden, Thomas, of Cranebroke, butcher 0
3642941 1908245 1908245 defendant Garrard William fuller 585864 585864 Garrard, William, of Cranebroke, fuller 1
3642942 1908245 1908245 defendant Okeherst Simon weaver 585864 585864 Okeherst, Simon, of Cranebroke, weaver 2
3642943 1908245 1908245 defendant Symons Robert smith 585864 585864 Symons, Robert, of Cranebroke, smith 3
3642944 1908245 1908245 defendant Browne Richard laborer 585864 585864 Browne, Richard, of Cranebroke, laborer 4
3642945 1908245 1908245 defendant Fyssynden Simon laborer 585864 585864 Fyssynden, Simon, of Cranebroke, laborer 5
3642946 1908245 1908245 defendant Holewey John brewer 585864 585864 Holewey, John, of Cranebroke, brewer 6
3642947 1908245 1908245 defendant Grenestrete Thomas weaver 585864 585864 Grenestrete, Thomas, of Cranebroke, weaver 7
3642948 1908245 1908245 defendant Horsle John sherman 585864 585864 Horsle, John, of Cranebroke, sherman 8
3642949 1908245 1908245 defendant Gouter Edmund fuller 585864 585864 Gouter, Edmund, of Cranebroke, fuller 9
3642950 1908245 1908245 defendant Fletcher John fletcher 585864 585864 Fletcher, John, of Cranebroke, fletcher 10
3642951 1908245 1908245 defendant Brykynden William fuller 585864 585864 Brykynden, William, of Cranebroke, fuller 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);