names

23 rows where place_id = 771609

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4580074 2225256 2225256 defendant Caly John   771609 771609 Caly, John, of Wode Rysyng 0
4580118 2225270 2225270 defendant Caly John   771609 771609 Caly, John, of Wode Rysyng 5
4595997 2229997 2229997 defendant Caly John   771609 771609 Caly, John, of Wode Rysyng 0
4600547 2231393 2231393 defendant Caley John   771609 771609 Caley, John, of Wode Rysyng 0
4635032 2241805 2241805 defendant Inges William   771609 771609 Inges, William, of Wode Rysyng 1
4645193 2244662 2244662 defendant Intes William   771609 771609 Intes, William, of Wode Rysyng 0
4699422 2265278 2265278 defendant Smyth Clement yeoman 771609 771609 Smyth, Clement, of Wode Rysyng, yeoman 2
4733152 2275546 2275546 defendant Burdeley William husbandman 771609 771609 Burdeley, William, of Wode Rysyng, husbandman 0
4816679 2301312 2301312 defendant Picher Robert yeoman 771609 771609 Picher, Robert, of Wode Rysyng, yeoman 0
4821900 2302924 2302924 defendant Whyppe Thomas husbandman 771609 771609 Whyppe, Thomas, of Wode Rysyng, husbandman 3
4821906 2302925 2302925 defendant Whyppe Thomas husbandman 771609 771609 Whyppe, Thomas, of Wode Rysyng, husbandman 3
4844152 2309681 2309681 defendant Buges Richard yeoman 771609 771609 Buges, Richard, of Wode Rysyng, yeoman 1
4924506 2334104 2334104 defendant Wychyngham Edmund gent 771609 771609 Wychyngham, Edmund, of Wode Rysyng, gent 0
4932908 2336682 2336682 defendant Edmunde-servant-Wichyngham Alice   771609 771609 Edmunde-servant-Wichyngham, Alice, of Wode Rysyng, servant 1
4940032 2338908 2338908 defendant Wychyngham Edmund esq 771609 771609 Wychyngham, Edmund, of Wode Rysyng, esq 0
4984854 2352399 2352399 plaintiff Wychyngham Edmund gent 771609 771609 Wychyngham, Edmund, of Wode Rysyng, gent 0
4992481 2354636 2354636 defendant Wychyngham Edmund esq 771609 771609 Wychyngham, Edmund, of Wode Rysyng, esq 0
5055033 2373070 2373070 defendant Whetele Robert husbandman 771609 771609 Whetele, Robert, of Wode Rysyng, husbandman 2
5081077 2380843 2380843 defendant Ingys Richard yeoman 771609 771609 Ingys, Richard, of Wode Rysyng, yeoman 0
5081079 2380844 2380844 defendant Ingys Richard yeoman 771609 771609 Ingys, Richard, of Wode Rysyng, yeoman 0
5095970 2385248 2385248 defendant Inges Richard husbandman 771609 771609 Inges, Richard, of Wode Rysyng, husbandman 11
5117216 2391465 2391465 defendant Wychyngham Edmund gent 771609 771609 Wychyngham, Edmund, of Wode Rysyng, gent 2
5137332 2397432 2397432 defendant Wychyngham Edmund esq 771609 771609 Wychyngham, Edmund, of Wode Rysyng, esq 0

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