names

121 rows where place_id = 586589

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589112 1864241 1864241 defendant Clerk John husbandman 586589 586589 Clerk, John, of Gyslyngham, husbandman 3
3600602 1867835 1867835 defendant Whight henry butcher 586589 586589 Whight, henry, of Gyslyngham, butcher 1
3603551 1868781 1868781 defendant Bolle Thomas   586589 586589 Bolle, Thomas, of Gyslyngham, wheel wright 0
3603552 1868781 1868781 defendant Wylchyn William yeoman 586589 586589 Wylchyn, William, of Gyslyngham, yeoman 1
3606114 1869579 1869579 defendant Brakstrete John husbandman 586589 586589 Brakstrete, John, of Gyslyngham, husbandman 4
3613816 1871978 1871978 defendant Porter William husbandman 586589 586589 Porter, William, of Gyslyngham, husbandman 1
3617647 1873143 1873143 plaintiff Fuller Thomas   586589 586589 Fuller, Thomas, of Gyslyngham 0
3617650 1873144 1873144 plaintiff Fuller Thomas   586589 586589 Fuller, Thomas, of Gyslyngham 0
3620739 1874062 1874062 defendant Dryver Simon Clerk 586589 586589 Dryver, Simon, of Gyslyngham, Clerk 0
3654679 1911722 1911722 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 0
3659328 1913179 1913179 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 0
3662753 1914272 1914272 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 0
3668451 1916084 1916084 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 1
3672664 1917453 1917453 defendant Lytyll Simon smith 586589 586589 Lytyll, Simon, of Gyslyngham, smith 0
3674584 1918102 1918102 defendant Garnon Nicholas yeoman 586589 586589 Garnon, Nicholas, of Gyslyngham, yeoman 0
3674585 1918102 1918102 defendant Garnon Joan widow 586589 586589 Garnon, Joan, of Gyslyngham, widow 1
3674587 1918103 1918103 defendant Garnon Nicholas yeoman 586589 586589 Garnon, Nicholas, of Gyslyngham, yeoman 0
3674588 1918103 1918103 defendant Garnon Joan widow 586589 586589 Garnon, Joan, of Gyslyngham, widow 1
3683788 1921065 1921065 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 0
3684300 1921224 1921224 defendant Grene John yeoman 586589 586589 Grene, John, of Gyslyngham, yeoman 0
3690386 1923156 1923156 defendant Garmon Simon yeoman 586589 586589 Garmon, Simon, of Gyslyngham, yeoman 0
3693038 1924027 1924027 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 0
3695834 1924931 1924931 defendant Garnon Simon husbandman 586589 586589 Garnon, Simon, of Gyslyngham, husbandman 2
3697291 1925374 1925374 defendant Grome Richard brickmaker 586589 586589 Grome, Richard, of Gyslyngham, brickmaker 3
3702244 1926958 1926958 defendant Garrard John husbandman 586589 586589 Garrard, John, of Gyslyngham, husbandman 0
3703485 1927362 1927362 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 0
3716705 1931519 1931519 defendant Tyrell Thomas clerk 586589 586589 Tyrell, Thomas, of Gyslyngham, clerk 0
3716706 1931519 1931519 defendant Geffereyson William chaplain 586589 586589 Geffereyson, William, of Gyslyngham, chaplain 1
3716707 1931519 1931519 defendant Godard William husbandman 586589 586589 Godard, William, of Gyslyngham, husbandman 2
3716708 1931519 1931519 defendant Cowper Thomas yeoman 586589 586589 Cowper, Thomas, of Gyslyngham, yeoman 3
3716709 1931519 1931519 defendant Dey William yeoman 586589 586589 Dey, William, of Gyslyngham, yeoman 4
3717309 1931696 1931696 defendant Garnom Simon husbandman 586589 586589 Garnom, Simon, of Gyslyngham, husbandman 2
3718832 1932170 1932170 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 0
3718835 1932171 1932171 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 0
3723930 1933764 1933764 defendant Garnon Simon yeoman 586589 586589 Garnon, Simon, of Gyslyngham, yeoman 1
3726689 1934609 1934609 defendant Garnoun Simon husbandman 586589 586589 Garnoun, Simon, of Gyslyngham, husbandman 4
3726939 1934692 1934692 defendant Offwood Walter husbandman 586589 586589 Offwood, Walter, of Gyslyngham, husbandman 1
3727745 1934948 1934948 defendant Symond John husbandman 586589 586589 Symond, John, of Gyslyngham, husbandman 0
3727747 1934948 1934948 defendant Forthe William yeoman 586589 586589 Forthe, William, of Gyslyngham, yeoman 2
3727910 1934998 1934998 defendant Tyrell Thomas clerk 586589 586589 Tyrell, Thomas, of Gyslyngham, clerk 0
3727911 1934998 1934998 defendant Geffreson William clerk 586589 586589 Geffreson, William, of Gyslyngham, clerk 1
3727912 1934998 1934998 defendant Garrard John butcher 586589 586589 Garrard, John, of Gyslyngham, butcher 2
3727913 1934998 1934998 defendant Garrard Robert laborer 586589 586589 Garrard, Robert, of Gyslyngham, laborer 3
3727914 1934998 1934998 defendant Steynor Thomas stainer 586589 586589 Steynor, Thomas, of Gyslyngham, stainer 4
3727915 1934998 1934998 defendant Smyth Richard tiler 586589 586589 Smyth, Richard, of Gyslyngham, tiler 5
3727916 1934998 1934998 defendant Dey William laborer 586589 586589 Dey, William, of Gyslyngham, laborer 6
3727917 1934998 1934998 defendant Robynson William tailor 586589 586589 Robynson, William, of Gyslyngham, tailor 7
3727918 1934998 1934998 defendant Gryffyth Robert laborer 586589 586589 Gryffyth, Robert, of Gyslyngham, laborer 8
3727919 1934998 1934998 defendant Brett William smith 586589 586589 Brett, William, of Gyslyngham, smith 9
3728656 1935200 1935200 defendant Tyrell Thomas clerk 586589 586589 Tyrell, Thomas, of Gyslyngham, clerk 0
3728657 1935200 1935200 defendant Godard William husbandman 586589 586589 Godard, William, of Gyslyngham, husbandman 1
3728658 1935200 1935200 defendant Dey William yeoman 586589 586589 Dey, William, of Gyslyngham, yeoman 2
3742570 1939547 1939547 defendant Offwood Walter husbandman 586589 586589 Offwood, Walter, of Gyslyngham, husbandman 1
3743859 1939965 1939965 defendant Tyrell Thomas clerk 586589 586589 Tyrell, Thomas, of Gyslyngham, clerk 0
3743860 1939965 1939965 defendant Godard William husbandman 586589 586589 Godard, William, of Gyslyngham, husbandman 1
3743861 1939965 1939965 defendant Dey William yeoman 586589 586589 Dey, William, of Gyslyngham, yeoman 2
3755873 1943789 1943789 defendant Braxstrete John (legal representative) 586589 586589 Braxstrete, John, of Gyslyngham, yeoman, administrator of 0
3775899 1950213 1950213 defendant Grome Richard husbandman 586589 586589 Grome, Richard, of Gyslyngham, husbandman 0
3775904 1950214 1950214 defendant Dryver Thomas husbandman 586589 586589 Dryver, Thomas, of Gyslyngham, husbandman 3
3824038 1965394 1965394 defendant Saunder Edward husbandman 586589 586589 Saunder, Edward, of Gyslyngham, husbandman 0
3844528 1971828 1971828 defendant Foster Robert tailor 586589 586589 Foster, Robert, of Gyslyngham, tailor 0
3848933 1973260 1973260 defendant Cowper Thomas yeoman 586589 586589 Cowper, Thomas, of Gyslyngham, yeoman 0
3856794 1975748 1975748 defendant Braxstrete Simon yeoman 586589 586589 Braxstrete, Simon, of Gyslyngham, yeoman 0
3866517 1979030 1979030 defendant Margery John butcher 586589 586589 Margery, John, of Gyslyngham, butcher 3
3915234 1995457 1995457 defendant Cowper Thomas, junior laborer 586589 586589 Cowper, Thomas, junior, of Gyslyngham, laborer 0
3956605 2009374 2009374 defendant Bradstreate Joan widow 586589 586589 Bradstreate, Joan, of Gyslyngham, widow 0
3967161 2013138 2013138 defendant Presson William yeoman 586589 586589 Presson, William, of Gyslyngham, yeoman 3
3970041 2014117 2014117 defendant Garlond Thomas, junior husbandman 586589 586589 Garlond, Thomas, junior, of Gyslyngham, husbandman, son of Garlond, Thomas, senior, of Gyslyngham, husbandman 0
4054121 2043860 2043860 defendant Preston William yeoman 586589 586589 Preston, William, of Gyslyngham, yeoman 0
4076397 2051856 2051856 defendant Man Thomas husbandman 586589 586589 Man, Thomas, of Gyslyngham, husbandman 0
4216974 2101431 2101431 defendant Foster Robert yeoman 586589 586589 Foster, Robert, of Gyslyngham, yeoman 0
4426276 2173026 2173026 plaintiff Northhawe William de   586589 586589 Northhawe, William de, of Gyslyngham 0
4504106 2201832 2201832 defendant Coupere Robert   586589 586589 Coupere, Robert, of Gyslyngham 0
4504108 2201833 2201833 defendant Coupere Robert   586589 586589 Coupere, Robert, of Gyslyngham 0
4528805 2209293 2209293 defendant Gardyner William   586589 586589 Gardyner, William, of Gyslyngham 0
4572452 2222923 2222923 plaintiff atte Chirche Richard   586589 586589 atte Chirche, Richard, of Gyslyngham 0
4635992 2242089 2242089 plaintiff atte Chirche Richard   586589 586589 atte Chirche, Richard, of Gyslyngham 0
4689548 2262288 2262288 defendant Godard William   586589 586589 Godard, William, of Gyslyngham, wheel wright 0
4721849 2272166 2272166 plaintiff Chirche Richard esq 586589 586589 Chirche, Richard, of Gyslyngham, esq 0
4755239 2282027 2282027 plaintiff atte Chirche Richard   586589 586589 atte Chirche, Richard, of Gyslyngham 0
4760281 2283568 2283568 defendant Couper Thomas   586589 586589 Couper, Thomas, of Gyslyngham, shoe maker 2
4805935 2298065 2298065 defendant virtus John chaplain 586589 586589 virtus, John, of Gyslyngham, chaplain 2
4831206 2305792 2305792 defendant Felice Roger gent 586589 586589 Felice, Roger, of Gyslyngham, gent 0
4838603 2307998 2307998 defendant Virtus John clerk 586589 586589 Virtus, John, of Gyslyngham, clerk 0
4875139 2319179 2319179 defendant Assheman Thomas esq 586589 586589 Assheman, Thomas, of Gyslyngham, esq 0
5050376 2371736 2371736 defendant Toppesfeld William gent 586589 586589 Toppesfeld, William, of Gyslyngham, gent 0
5050377 2371736 2371736 defendant Wode Nicholas husbandman 586589 586589 Wode, Nicholas, of Gyslyngham, husbandman 1
5050378 2371736 2371736 defendant Wylchyn William   586589 586589 Wylchyn, William, of Gyslyngham, servant 2
5050379 2371736 2371736 defendant Mareys Roger husbandman 586589 586589 Mareys, Roger, of Gyslyngham, husbandman 3
5050380 2371736 2371736 defendant Drory John laborer 586589 586589 Drory, John, of Gyslyngham, laborer 4
5050382 2371737 2371737 defendant Toppesfeld William gent 586589 586589 Toppesfeld, William, of Gyslyngham, gent 0
5050383 2371737 2371737 defendant Wode Nicholas husbandman 586589 586589 Wode, Nicholas, of Gyslyngham, husbandman 1
5050384 2371737 2371737 defendant Wylchyn William   586589 586589 Wylchyn, William, of Gyslyngham, servant 2
5050385 2371737 2371737 defendant Mareys Roger husbandman 586589 586589 Mareys, Roger, of Gyslyngham, husbandman 3
5050386 2371737 2371737 defendant Drory John laborer 586589 586589 Drory, John, of Gyslyngham, laborer 4
5099387 2386250 2386250 defendant Wysman Robert chaplain 586589 586589 Wysman, Robert, of Gyslyngham, chaplain 0
5147389 2400382 2400382 plaintiff Clerk John   586589 586589 Clerk, John, of Gyslyngham 0
5167119 2406116 2406116 plaintiff Clerk John   586589 586589 Clerk, John, of Gyslyngham 0
5214048 2419840 2419840 plaintiff Brond Robert   586589 586589 Brond, Robert, of Gyslyngham 0
5217718 2420911 2420911 defendant Sekford George esq 586589 586589 Sekford, George, of Gyslyngham, esq 0

Next page

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