names

49 rows where place_id = 600537

✎ 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
3641433 1907777 1907777 plaintiff Bollys John gent 600537 600537 Bollys, John, of Wallyngton, gent 0
3658407 1912880 1912880 defendant Davy Thomas husbandman 600537 600537 Davy, Thomas, of Wallyngton, husbandman 0
3723314 1933563 1933563 defendant Hiche Thomas laborer 600537 600537 Hiche, Thomas, of Wallyngton, laborer 0
3724925 1934085 1934085 defendant Pers John   600537 600537 Pers, John, of Wallyngton 0
3728898 1935286 1935286 defendant Yong John dyer 600537 600537 Yong, John, of Wallyngton, dyer 2
3761531 1945618 1945618 plaintiff Fenwyke Ralph   600537 600537 Fenwyke, Ralph, of Wallyngton, knight 0
3779695 1951383 1951383 plaintiff Fenwyke John esq 600537 600537 Fenwyke, John, of Wallyngton, esq 0
3836800 1969410 1969410 defendant Aleyn John laborer 600537 600537 Aleyn, John, of Wallyngton, laborer 1
3885971 1985560 1985560 defendant Rumbold Thomas laborer 600537 600537 Rumbold, Thomas, of Wallyngton, laborer 1
3885972 1985560 1985560 defendant Tytmarshe Robert laborer 600537 600537 Tytmarshe, Robert, of Wallyngton, laborer 2
3906964 1992617 1992617 defendant Dore Juliana widow 600537 600537 Dore, Juliana, of Wallyngton, widow 0
3938564 2003241 2003241 plaintiff Racland Thomas esq 600537 600537 Racland, Thomas, of Wallyngton, esq 0
3938573 2003244 2003244 defendant Wesenham Henry husbandman 600537 600537 Wesenham, Henry, of Wallyngton, husbandman 1
3946354 2005797 2005797 defendant Wesenham Henry husbandman 600537 600537 Wesenham, Henry, of Wallyngton, husbandman 0
3950530 2007266 2007266 defendant Bedell Andrew husbandman 600537 600537 Bedell, Andrew, of Wallyngton, husbandman 0
3959334 2010346 2010346 defendant Bonne Henry husbandman 600537 600537 Bonne, Henry, of Wallyngton, husbandman 0
3959335 2010346 2010346 defendant Grave Leonard husbandman 600537 600537 Grave, Leonard, of Wallyngton, husbandman 1
3960223 2010675 2010675 defendant Atkynson Richard yeoman 600537 600537 (Atkynson, Richard, of Wallyngton, yeoman 1
3969943 2014087 2014087 defendant Gawly Francis esq 600537 600537 Gawly, Francis, of Wallyngton, esq 0
3969946 2014087 2014087 defendant Clerke Anne daughter of Christopher Conyngesby 600537 600537 Anne his wife, daughter of Christopher Conyngesby, of Wallyngton 3
3970235 2014188 2014188 defendant Gawdy Francis esq 600537 600537 Gawdy, Francis, of Wallyngton, esq 0
3970239 2014189 2014189 defendant Gawdye Francis esq 600537 600537 Gawdye, Francis, of Wallyngton, esq 2
4221151 2102894 2102894 defendant Beadell John husbandman 600537 600537 Beadell, John, of Wallyngton, husbandman 0
4221155 2102896 2102896 defendant Beadell John husbandman 600537 600537 Beadell, John, of Wallyngton, husbandman 0
4466438 2190171 2190171 defendant Midilton John de   600537 600537 Midilton, John de, of Wallyngton 0
4481849 2195028 2195028 defendant Sutton William   600537 600537 Sutton, William, of Wallyngton 0
4639268 2243002 2243002 defendant Webster William   600537 600537 Webster, William, of Wallyngton 0
4649012 2245757 2245757 defendant Kelsay William   600537 600537 Kelsay, William, of Wallyngton 4
4926871 2334834 2334834 defendant Maltster John husbandman 600537 600537 Maltster, John, of Wallyngton, husbandman 2
4956332 2343857 2343857 plaintiff Tyler Simon   600537 600537 Tyler, Simon, of Wallyngton 0
4962008 2345549 2345549 defendant Barnysdale Geoffrey yeoman 600537 600537 Barnysdale, Geoffrey, of Wallyngton, yeoman 3
5053353 2372605 2372605 defendant Slaughter John laborer 600537 600537 Slaughter, John, of Wallyngton, laborer 6
5063578 2375638 2375638 defendant Slaghter Ralph woolman 600537 600537 Slaghter, Ralph, of Wallyngton, woolman 0
5063580 2375639 2375639 defendant Slaghter Ralph woolman 600537 600537 Slaghter, Ralph, of Wallyngton, woolman 0
5150935 2401411 2401411 plaintiff Geyhoo John   600537 600537 Geyhoo, John, of Wallyngton 1
5243131 2428191 2428191 defendant Kykell William yeoman 600537 600537 Kykell, William, of Wallyngton, yeoman 1
5310783 2448262 2448262 defendant Kekyll William yeoman 600537 600537 Kekyll, William, of Wallyngton, yeoman 0
5320721 2451290 2451290 defendant Kyckell William yeoman 600537 600537 Kyckell, William, of Wallyngton, yeoman 2
5330530 2454218 2454218 defendant Kekyll William husbandman 600537 600537 Kekyll, William, of Wallyngton, husbandman 0
5353443 2461153 2461153 defendant Kekell William gent 600537 600537 Kekell, William, of Wallyngton, gent 0
5353978 2461307 2461307 defendant Kekell William gent 600537 600537 Kekell, William, of Wallyngton, gent 0
5353980 2461307 2461307 defendant Reynham William husbandman 600537 600537 Reynham, William, of Wallyngton, husbandman 2
5365817 2464962 2464962 defendant Kekyll William husbandman 600537 600537 Kekyll, William, of Wallyngton, husbandman 1
5437241 2486077 2486077 defendant Colyour Robert chaplain 600537 600537 Colyour, Robert, of Wallyngton, chaplain 1
5496010 2503702 2503702 defendant Kekyll William gent 600537 600537 Kekyll, William, of Wallyngton, gent 0
5515825 2509796 2509796 plaintiff Sounton John (legal representative) 600537 600537 Sounton, John, of Wallyngton, gent, executors of 0
5544571 2518413 2518413 defendant Davy Thomas husbandman 600537 600537 Davy, Thomas, of Wallyngton, husbandman 2
5554583 2521375 2521375 defendant Phypers John thatcher 600537 600537 Phypers, John, of Wallyngton, thatcher 0
5610748 2547081 2547081 defendant Pilche John   600537 600537 Pilche, John, of Wallyngton 2

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