names

36 rows where place_id = 586457

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588770 1864130 1864130 defendant Oxwyk William husbandman 586457 586457 Oxwyk, William, of Wyssyngset, husbandman 0
3591852 1865073 1865073 defendant Gryggys John smith 586457 586457 Gryggys, John, of Wyssyngset, smith 1
3597356 1866793 1866793 defendant Oxwyk William husbandman 586457 586457 Oxwyk, William, of Wyssyngset, husbandman 0
3661681 1913930 1913930 defendant Whitacre William laborer 586457 586457 Whitacre, William, of Wyssyngset, laborer 0
3661682 1913930 1913930 defendant Whitacre Thomas husbandman 586457 586457 Whitacre, Thomas, of Wyssyngset, husbandman 1
3661683 1913930 1913930 defendant Potter John laborer 586457 586457 Potter, John, of Wyssyngset, laborer 2
3661684 1913930 1913930 defendant Potter John yeoman 586457 586457 Potter, John, of Wyssyngset, yeoman 3
3665119 1915039 1915039 defendant Moundy Peter husbandman 586457 586457 Moundy, Peter, of Wyssyngset, husbandman 0
3674691 1918131 1918131 defendant Bradnam Robert chapman 586457 586457 Bradnam, Robert, of Wyssyngset, chapman 4
3677307 1918951 1918951 defendant Wytakyr William laborer 586457 586457 Wytakyr, William, of Wyssyngset, laborer 4
3681251 1920222 1920222 defendant Whamer John laborer 586457 586457 Whamer, John, of Wyssyngset, laborer 0
3681253 1920222 1920222 defendant Whytakyr William husbandman 586457 586457 Whytakyr, William, of Wyssyngset, husbandman 2
3705975 1928158 1928158 defendant Gegge Richard tailor 586457 586457 Gegge, Richard, of Wyssyngset, tailor 0
3827247 1966389 1966389 plaintiff Bosome John esq 586457 586457 Bosome, John, of Wyssyngset, esq 0
3827460 1966456 1966456 plaintiff Braunche John gent 586457 586457 Braunche, John, of Wyssyngset, gent 0
5003066 2357800 2357800 defendant Cheteryng William   586457 586457 Cheteryng, William, of Wyssyngset, shoe maker 1
5012850 2360590 2360590 defendant Clerk Robert husbandman 586457 586457 Clerk, Robert, of Wyssyngset, husbandman 2
5181492 2410327 2410327 defendant Bosun William esq 586457 586457 Bosun, William, of Wyssyngset, esq 2
5270551 2436483 2436483 defendant Cheteryng Richard husbandman 586457 586457 Cheteryng, Richard, of Wyssyngset, husbandman 0
5301121 2445291 2445291 defendant Bylmyn Thomas yeoman 586457 586457 Bylmyn, Thomas, of Wyssyngset, yeoman 3
5347826 2459471 2459471 defendant Fay William smith 586457 586457 Fay, William, of Wyssyngset, smith 4
5347838 2459473 2459473 defendant Bilmyn William smith 586457 586457 Bilmyn, William, of Wyssyngset, smith 4
5360285 2463254 2463254 defendant Bylmyn Thomas husbandman 586457 586457 Bylmyn, Thomas, of Wyssyngset, husbandman 0
5399999 2475081 2475081 defendant Bylmyn William smith 586457 586457 Bylmyn, William, of Wyssyngset, smith 3
5406213 2476852 2476852 defendant Feyher William smith 586457 586457 Feyher, William, of Wyssyngset, smith 3
5408363 2477473 2477473 defendant Fyssher William   586457 586457 Fyssher, William, of Wyssyngset 3
5412992 2478824 2478824 defendant Gylmyn William smith 586457 586457 Gylmyn, William, of Wyssyngset, smith 0
5428038 2483338 2483338 defendant Blymyn William smith 586457 586457 Blymyn, William, of Wyssyngset, smith 0
5486883 2500974 2500974 defendant Feyher William smith 586457 586457 Feyher, William, of Wyssyngset, smith 4
5507899 2507369 2507369 defendant Grene alias Lord John husbandman 586457 586457 Grene alias Lord, John, of Wyssyngset, husbandman 3
5511609 2508479 2508479 defendant Godynowe Henry (legal representative) 586457 586457 Godynowe, Henry, of Wyssyngset, husbandman, executor of 1
5511610 2508479 2508479 defendant Godynowe Roger clerk 586457 586457 Godynowe, Roger, of Wyssyngset, clerk 2
5514831 2509484 2509484 plaintiff Rukwode Alice widow 586457 586457 Rukwode, Alice, of Wyssyngset, widow 0
5514833 2509485 2509485 plaintiff Rukwode Alice widow 586457 586457 Rukwode, Alice, of Wyssyngset, widow 0
5539559 2516849 2516849 defendant Fayre William smith 586457 586457 Fayre, William, of Wyssyngset, smith 1
5580084 2528852 2528852 defendant Pawment Thomas husbandman 586457 586457 Pawment, Thomas, of Wyssyngset, husbandman 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);