names

98 rows where place_id = 597000

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626864 1903252 1903252 defendant Burgon John yeoman 597000 597000 Burgon, John, of Claworth, yeoman 1
3683719 1921041 1921041 defendant Boyth James husbandman 597000 597000 Boyth, James, of Claworth, husbandman 3
3736797 1937759 1937759 defendant Burgon John yeoman 597000 597000 Burgon, John, of Claworth, yeoman 0
3742295 1939460 1939460 defendant Both Hugh husbandman 597000 597000 Both, Hugh, of Claworth, husbandman 2
3755185 1943573 1943573 defendant Burgon John husbandman 597000 597000 Burgon, John, of Claworth, husbandman 1
3755186 1943573 1943573 defendant Williamson Robert husbandman 597000 597000 Williamson, Robert, of Claworth, husbandman 2
3772772 1949177 1949177 defendant Burgon John husbandman 597000 597000 Burgon, John, of Claworth, husbandman 1
3772773 1949177 1949177 defendant Williamson Robert husbandman 597000 597000 Williamson, Robert, of Claworth, husbandman 2
3787316 1953824 1953824 defendant Burgon John yeoman 597000 597000 Burgon, John, of Claworth, yeoman 0
3790411 1954820 1954820 defendant Burgon John husbandman 597000 597000 Burgon, John, of Claworth, husbandman 0
3801170 1958287 1958287 defendant Burgon John yeoman 597000 597000 Burgon, John, of Claworth, yeoman 0
3801171 1958287 1958287 defendant Burgon William, junior husbandman 597000 597000 Burgon, William, junior, of Claworth, husbandman 1
3806671 1959984 1959984 defendant Burgon John yeoman 597000 597000 Burgon, John, of Claworth, yeoman 0
3806672 1959984 1959984 defendant Thomson William husbandman 597000 597000 Thomson, William, of Claworth, husbandman 1
3818663 1963741 1963741 defendant Burgon John yeoman 597000 597000 Burgon, John, of Claworth, yeoman 0
3818664 1963741 1963741 defendant Burgon William yeoman 597000 597000 Burgon, William, of Claworth, yeoman 1
3845268 1972082 1972082 defendant Hopkynson John laborer 597000 597000 Hopkynson, John, of Claworth, laborer 0
3845269 1972082 1972082 defendant Westeley Richard laborer 597000 597000 Westeley, Richard, of Claworth, laborer 1
3861303 1977252 1977252 plaintiff Fitzwilliam Humphrey gent 597000 597000 Fitzwilliam, Humphrey, of Claworth, gent 0
3861304 1977252 1977252 defendant Wilson Thomas turner 597000 597000 Wilson, Thomas, of Claworth, turner 0
3861305 1977252 1977252 defendant Donell Robert husbandman 597000 597000 Donell, Robert, of Claworth, husbandman 1
3864304 1978256 1978256 defendant Burgon John yeoman 597000 597000 Burgon, John, of Claworth, yeoman 0
3864305 1978256 1978256 defendant Thompson Hugh husbandman 597000 597000 Thompson, Hugh, of Claworth, husbandman 1
3864308 1978256 1978256 defendant Burgon William husbandman 597000 597000 Burgon, William, of Claworth, husbandman 4
3887097 1985947 1985947 defendant Fitzwylliam Humphrey gent 597000 597000 Fitzwylliam, Humphrey, of Claworth, gent 1
3919436 1996832 1996832 defendant Donell Robert husbandman 597000 597000 Donell, Robert, of Claworth, husbandman 1
3931884 2000963 2000963 defendant Bland Henry butcher 597000 597000 Bland, Henry, of Claworth, butcher 1
3962271 2011384 2011384 plaintiff Wawen Charles esq 597000 597000 Wawen, Charles, of Claworth, esq 0
4019422 2031679 2031679 plaintiff Wawyn Charles esq 597000 597000 Wawyn, Charles, of Claworth, esq 0
4219834 2102441 2102441 defendant Stringer Martin gent 597000 597000 Stringer, Martin, of Claworth, gent 1
4228802 2105556 2105556 defendant Stringer Martin gent 597000 597000 Stringer, Martin, of Claworth, gent 1
4421844 2171709 2171709 plaintiff Daubeney William   597000 597000 Daubeney, William, of Claworth 0
4426228 2173009 2173009 plaintiff Norays John   597000 597000 Norays, John, of Claworth, son of Robert 0
4426231 2173010 2173010 defendant More Ivan of the   597000 597000 More, Ivan of the, of Claworth 0
4499601 2200517 2200517 defendant Carter Walter   597000 597000 Carter, Walter, of Claworth 2
4586029 2227054 2227054 defendant Kirketon Edmund de   597000 597000 Kirketon, Edmund de, of Claworth, formerly parson 0
4642456 2243917 2243917 defendant Kee Robert   597000 597000 Kee, Robert, of Claworth 1
4656136 2247801 2247801 defendant Dey Robert husbandman 597000 597000 Dey, Robert, of Claworth, husbandman 0
4677566 2258596 2258596 plaintiff Hasard William   597000 597000 Hasard, William, of Claworth, parson, on his own account 0
4707827 2267817 2267817 defendant Jonson Henry husbandman 597000 597000 Jonson, Henry, of Claworth, husbandman 1
4728303 2274097 2274097 defendant Jonson Henry laborer 597000 597000 Jonson, Henry, of Claworth, laborer 0
4728304 2274097 2274097 defendant Taillour John laborer 597000 597000 Taillour, John, of Claworth, laborer 1
4783395 2290822 2290822 defendant Armeston Nicholas husbandman 597000 597000 Armeston, Nicholas, of Claworth, husbandman 2
4986321 2352833 2352833 defendant Bristall Roger yeoman 597000 597000 Bristall, Roger, of Claworth, yeoman 2
4990548 2354080 2354080 defendant Birstall Roger husbandman 597000 597000 Birstall, Roger, of Claworth, husbandman 0
4990549 2354080 2354080 defendant Hogeson Richard husbandman 597000 597000 Hogeson, Richard, of Claworth, husbandman 1
4993600 2354960 2354960 defendant Birstall Roger husbandman 597000 597000 Birstall, Roger, of Claworth, husbandman 3
4993601 2354960 2354960 defendant Bradley John   597000 597000 Bradley, John, of Claworth, wright 4
5071230 2377893 2377893 defendant Burstall John husbandman 597000 597000 Burstall, John, of Claworth, husbandman 0
5095268 2385034 2385034 defendant Norreys Robert husbandman 597000 597000 Norreys, Robert, of Claworth, husbandman 1
5128126 2394700 2394700 defendant Elynson John   597000 597000 Elynson, John, of Claworth 0
5144764 2399623 2399623 defendant Reynshawe Henry husbandman 597000 597000 Reynshawe, Henry, of Claworth, husbandman 0
5237388 2426519 2426519 defendant Hertishill John gent 597000 597000 Hertishill, John, of Claworth, gent 0
5238514 2426854 2426854 defendant Norres Robert   597000 597000 Norres, Robert, of Claworth, franklin 1
5239093 2427026 2427026 defendant Jakson John husbandman 597000 597000 Jakson, John, of Claworth, husbandman 2
5259926 2433227 2433227 defendant Wright Richard husbandman 597000 597000 Wright, Richard, of Claworth, husbandman 1
5326564 2453027 2453027 defendant Hertyshyll John gent 597000 597000 Hertyshyll, John, of Claworth, gent 0
5326565 2453027 2453027 defendant Ekkyls John yeoman 597000 597000 Ekkyls, John, of Claworth, yeoman 1
5326566 2453027 2453027 defendant Williamson William, senior husbandman 597000 597000 Williamson, William, senior, of Claworth, husbandman 2
5326567 2453027 2453027 defendant Burgon Thomas husbandman 597000 597000 Burgon, Thomas, of Claworth, husbandman 3
5326568 2453027 2453027 defendant Burgon John husbandman 597000 597000 Burgon, John, of Claworth, husbandman 4
5326569 2453027 2453027 defendant Bradley John, senior husbandman 597000 597000 Bradley, John, senior, of Claworth, husbandman 5
5326570 2453027 2453027 defendant Calton Robert husbandman 597000 597000 Calton, Robert, of Claworth, husbandman 6
5326571 2453027 2453027 defendant Bette John, junior husbandman 597000 597000 Bette, John, junior, of Claworth, husbandman 7
5326572 2453027 2453027 defendant Pollard Nicholas husbandman 597000 597000 Pollard, Nicholas, of Claworth, husbandman 8
5326575 2453027 2453027 defendant Dutton Robert laborer 597000 597000 Dutton, Robert, of Claworth, laborer 11
5326576 2453027 2453027 defendant Bette William husbandman 597000 597000 Bette, William, of Claworth, husbandman 12
5326577 2453027 2453027 defendant Herryson William husbandman 597000 597000 Herryson, William, of Claworth, husbandman 13
5326578 2453027 2453027 defendant Wrygh Richard husbandman 597000 597000 Wrygh, Richard, of Claworth, husbandman 14
5326579 2453027 2453027 defendant Brystowe John husbandman 597000 597000 Brystowe, John, of Claworth, husbandman 15
5326580 2453027 2453027 defendant Clynson William husbandman 597000 597000 Clynson, William, of Claworth, husbandman 16
5326581 2453027 2453027 defendant Forton Richard husbandman 597000 597000 Forton, Richard, of Claworth, husbandman 17
5326582 2453027 2453027 defendant Cressy John husbandman 597000 597000 Cressy, John, of Claworth, husbandman 18
5326583 2453027 2453027 defendant Bolton Robert husbandman 597000 597000 Bolton, Robert, of Claworth, husbandman 19
5326584 2453027 2453027 defendant Whitehorn John husbandman 597000 597000 Whitehorn, John, of Claworth, husbandman 20
5326585 2453027 2453027 defendant Stele Robert husbandman 597000 597000 Stele, Robert, of Claworth, husbandman 21
5326586 2453027 2453027 defendant Broune Thomas husbandman 597000 597000 Broune, Thomas, of Claworth, husbandman 22
5326587 2453027 2453027 defendant Roger Thomas husbandman 597000 597000 Roger, Thomas, of Claworth, husbandman 23
5326588 2453027 2453027 defendant Tomson William husbandman 597000 597000 Tomson, William, of Claworth, husbandman 24
5326589 2453027 2453027 defendant Holme Robert husbandman 597000 597000 Holme, Robert, of Claworth, husbandman 25
5326590 2453027 2453027 defendant Johnson Robert husbandman 597000 597000 Johnson, Robert, of Claworth, husbandman 26
5326591 2453027 2453027 defendant Frebur Thomas husbandman 597000 597000 Frebur, Thomas, of Claworth, husbandman 27
5326592 2453027 2453027 defendant Robynson John husbandman 597000 597000 Robynson, John, of Claworth, husbandman 28
5326593 2453027 2453027 defendant Johnson Thomas husbandman 597000 597000 Johnson,Thomas, of Claworth, husbandman 29
5326594 2453027 2453027 defendant Wryght Thomas husbandman 597000 597000 Wryght, Thomas, of Claworth, husbandman 30
5326595 2453027 2453027 defendant Wod William husbandman 597000 597000 Wod, William, of Claworth, husbandman 31
5326596 2453027 2453027 defendant Clerkson William husbandman 597000 597000 Clerkson, William, of Claworth, husbandman 32
5326597 2453027 2453027 defendant Clerkson Christopher laborer 597000 597000 Clerkson, Christopher, of Claworth, laborer 33
5326598 2453027 2453027 defendant Willyamson William, junior husbandman 597000 597000 Willyamson, William, junior, of Claworth, husbandman 34
5326599 2453027 2453027 defendant Baker John husbandman 597000 597000 Baker, John, of Claworth, husbandman 35
5326600 2453027 2453027 defendant Claworth John laborer 597000 597000 Claworth, John, of Claworth, laborer 36
5497879 2504308 2504308 defendant Bullok Nicholas smith 597000 597000 Bullok, Nicholas, of Claworth, smith 0
5497880 2504308 2504308 defendant Whitehed William husbandman 597000 597000 Whitehed, William, of Claworth, husbandman 1
5536962 2516046 2516046 defendant Hertyshyll William gent 597000 597000 Hertyshyll, William, of Claworth, gent 2
5586722 2530887 2530887 defendant Burgon John   597000 597000 Burgon, John, of Claworth, husbandman, son of Burgon, Thomas, of Claworth 0
5586724 2530887 2530887 defendant Bote Agnes widow 597000 597000 Bote, Agnes, of Claworth, widow 2
5625892 2552048 2552048 defendant Mawe John yeoman 597000 597000 Mawe, John, of Claworth, yeoman 0
5625894 2552048 2552048 defendant Wystowe John husbandman 597000 597000 Wystowe, John, of Claworth, husbandman 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);