names

16 rows where place_id = 597203

✎ 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
3627670 1903514 1903514 defendant Goodale Adam husbandman 597203 597203 Goodale, Adam, of Mildyng, husbandman 4
4627953 2239669 2239669 defendant Jamys William   597203 597203 Jamys, William, of Mildyng 4
4627959 2239670 2239670 defendant Jamys William   597203 597203 Jamys, William, of Mildyng 4
5123133 2393200 2393200 plaintiff Wellys Edward   597203 597203 Wellys, Edward, of Mildyng, administrators of 0
5134199 2396497 2396497 defendant Welles Evorard (legal representative) 597203 597203 Welles, Evorard, of Mildyng, gent, executrix of 2
5142030 2398792 2398792 plaintiff Wellys Edward   597203 597203 Wellys, Edward, of Mildyng, administrators of 0
5154110 2402359 2402359 defendant Welles Alice widow 597203 597203 Welles, Alice, of Mildyng, widow 5
5154112 2402360 2402360 defendant Wellys Eboradus (legal representative) 597203 597203 Wellys, Eboradus, of Mildyng, gent, deceased, executrix of 0
5154113 2402360 2402360 defendant Wellys Alice widow 597203 597203 Wellys, Alice, of Mildyng, widow 1
5163170 2404960 2404960 plaintiff Wellys Edward (legal representative) 597203 597203 Wellys, Edward, of Mildyng, administrator of 0
5171303 2407330 2407330 defendant Wellys Everard (legal representative) 597203 597203 Wellys, Everard, of Mildyng, gent, executrix of 0
5171304 2407330 2407330 defendant Wellis Alice widow 597203 597203 Wellis, Alice, of Mildyng, widow 1
5176944 2408950 2408950 plaintiff Wellys Edward   597203 597203 Wellys, Edward, of Mildyng, administrators of 0
5189641 2412716 2412716 defendant Wellys Everardus (legal representative) 597203 597203 Wellys, Everardus, of Mildyng, gent, executrix of 0
5189642 2412716 2412716 defendant Wellys Alice widow 597203 597203 Wellys, Alice, of Mildyng, widow 1
5371989 2466831 2466831 defendant Lyon John husbandman 597203 597203 Lyon, John, of Mildyng, husbandman 1

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