names

28 rows where place_id = 639783

✎ 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
3850882 1973870 1973870 defendant Harys John husbandman 639783 639783 Harys, John, of Geldeston, husbandman 0
3855055 1975208 1975208 defendant Barker Richard husbandman 639783 639783 Barker, Richard, of Geldeston, husbandman 1
3856266 1975578 1975578 defendant Dey Thomas husbandman 639783 639783 Dey, Thomas, of Geldeston, husbandman 0
3857968 1976138 1976138 defendant Edmondys William   639783 639783 Edmondys, William, of Geldeston, rough mason 0
3858627 1976369 1976369 defendant Fuller Thomas (legal representative) 639783 639783 Fuller, Thomas, of Geldeston, executors of 0
3858629 1976369 1976369 defendant Fuller William butcher 639783 639783 Fuller, William, of Geldeston, butcher 2
3866640 1979074 1979074 defendant Aldred Edward husbandman 639783 639783 Aldred, Edward, of Geldeston, husbandman 0
3866641 1979074 1979074 defendant Harres John husbandman 639783 639783 Harres, John, of Geldeston, husbandman 1
3872316 1980966 1980966 defendant Dey Thomas husbandman 639783 639783 Dey, Thomas, of Geldeston, husbandman 0
4015858 2030358 2030358 defendant Sparhauke John, junior husbandman 639783 639783 Sparhauke, John, junior, of Geldeston, husbandman 0
4032015 2036119 2036119 defendant Strowger Robert sherman 639783 639783 Strowger, Robert, of Geldeston, sherman 0
4092173 2057499 2057499 defendant Spore Robert husbandman 639783 639783 Spore, Robert, of Geldeston, husbandman 0
4176147 2087131 2087131 defendant Strowger Robert sherman 639783 639783 Strowger, Robert, of Geldeston, sherman 1
4399733 2164499 2164499 defendant Ladyman Henry yeoman 639783 639783 Ladyman, Henry, of Geldeston, yeoman 0
4467993 2190663 2190663 plaintiff Barel John   639783 639783 Barel, John, of Geldeston, parson 0
4495280 2199200 2199200 defendant Cook Stephen   639783 639783 Cook, Stephen, of Geldeston 0
4495282 2199201 2199201 defendant Grym Adam   639783 639783 Grym, Adam, of Geldeston 0
5124227 2393540 2393540 defendant Warde Richard clerk 639783 639783 Warde, Richard, of Geldeston, clerk 10
5285098 2440667 2440667 defendant Guges Robert yeoman 639783 639783 Guges, Robert, of Geldeston, yeoman 2
5285099 2440667 2440667 defendant Freman Robert husbandman 639783 639783 Freman, Robert, of Geldeston, husbandman 3
5390921 2472469 2472469 plaintiff Neweman Thomas   639783 639783 Neweman, Thomas, of Geldeston 10
5390922 2472469 2472469 plaintiff Neweman William   639783 639783 Neweman, William, of Geldeston 11
5390923 2472469 2472469 plaintiff Neweman Margaret   639783 639783 Neweman, Margaret, of Geldeston 12
5403871 2476178 2476178 plaintiff Neweman Thomas   639783 639783 Neweman, Thomas, of Geldeston 10
5403872 2476178 2476178 plaintiff Neweman William   639783 639783 Neweman, William, of Geldeston 11
5403873 2476178 2476178 plaintiff Neweman Margaret   639783 639783 Neweman, Margaret, of Geldeston 12
5416982 2479991 2479991 plaintiff Neweman Thomas   639783 639783 Neweman, Thomas, of Geldeston 8
5416983 2479991 2479991 plaintiff Neweman William   639783 639783 Neweman, William, of Geldeston 9

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