names

18 rows where place_id = 617958

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664691 1914908 1914908 defendant Marshall Nicholas   617958 617958 (Marshall, Nicholas, of Glensford, cloth maker 1
3722095 1933173 1933173 plaintiff Manwode Richard   617958 617958 Manwode, Richard, of Glensford 0
3722100 1933175 1933175 defendant Rote Robert weaver 617958 617958 Rote, Robert, of Glensford, weaver 0
3722632 1933338 1933338 defendant Marchall Nicholas sherman 617958 617958 Marchall, Nicholas, of Glensford, sherman 1
3724508 1933951 1933951 defendant Holden Thomas clothmaker 617958 617958 Holden, Thomas, of Glensford, clothmaker 0
3761484 1945603 1945603 defendant Rote Robert clothmaker 617958 617958 Rote, Robert, of Glensford, clothmaker 2
3762035 1945770 1945770 defendant Mashall Thomas clothmaker 617958 617958 Mashall, Thomas, of Glensford, clothmaker 7
3765697 1946937 1946937 defendant Leche William husbandman 617958 617958 Leche, William, of Glensford, husbandman 0
3780705 1951698 1951698 defendant Downys Thomas smith 617958 617958 Downys, Thomas, of Glensford, smith 2
3809054 1960714 1960714 defendant Everard John fuller 617958 617958 Everard, John, of Glensford, fuller 0
3963761 2011928 2011928 plaintiff Alen John clothier 617958 617958 Alen, John, of Glensford, clothier 0
4064689 2047659 2047659 defendant Everytt John clothier 617958 617958 Everytt, John, of Glensford, clothier 1
4146793 2077031 2077031 defendant More alias Barryll Richard husbandman 617958 617958 More alias Barryll, Richard, of Glensford, or of Candishe, Suff, husbandman 0
4160905 2081886 2081886 defendant Howe John clothier 617958 617958 Howe, John, of Glensford, clothier 1
4160906 2081886 2081886 defendant Harward Thomas clothier 617958 617958 Harward, Thomas, of Glensford, clothier 2
4244207 2111048 2111048 defendant Catton George clothier 617958 617958 Catton, George, of Glensford, clothier 1
4255348 2114784 2114784 defendant Catton George chapman 617958 617958 Catton, George, of Glensford, clothier, chapman 1
4402570 2165445 2165445 defendant Parker Thomas clothier 617958 617958 Parker, Thomas, of Glensford, clothier 3

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