names

106 rows where place_id = 599088

✎ 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
3635149 1905792 1905792 defendant Hodson William husbandman 599088 599088 Hodson, William, of Thornage, husbandman 1
3678160 1919219 1919219 defendant Harman Richard stainer 599088 599088 Harman, Richard, of Thornage, stainer 0
3685298 1921554 1921554 plaintiff Bacon Thomas yeoman 599088 599088 Bacon, Thomas, of Thornage, yeoman 0
3702059 1926899 1926899 defendant Pecok James husbandman 599088 599088 Pecok, James, of Thornage, husbandman 0
3748975 1941611 1941611 defendant Femlyne Robert miller 599088 599088 Femlyne, Robert, of Thornage, miller 3
3755376 1943633 1943633 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3758869 1944764 1944764 defendant Bacon Agnes widow 599088 599088 Bacon, Agnes, of Thornage, widow 0
3758871 1944765 1944765 defendant Bacon Agnes widow 599088 599088 Bacon, Agnes, of Thornage, widow 0
3781902 1952087 1952087 defendant Hemlyng Robert miller 599088 599088 Hemlyng, Robert, of Thornage, miller 1
3825614 1965863 1965863 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3834021 1968581 1968581 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 1
3843140 1971380 1971380 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3843408 1971473 1971473 defendant Bakon Henry clerk 599088 599088 Bakon, Henry, of Thornage, clerk 0
3847332 1972725 1972725 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3859182 1976563 1976563 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3861206 1977224 1977224 defendant Bakon Henry clerk 599088 599088 Bakon, Henry, of Thornage, clerk 0
3862545 1977667 1977667 defendant Bacon Henry clerk 599088 599088 Bacon, Henry, of Thornage, clerk 0
3862922 1977795 1977795 defendant Bakon Henry yeoman 599088 599088 Bakon, Henry, of Thornage, yeoman 0
3870117 1980250 1980250 defendant (not given) Henry rector of Bacon 599088 599088 Bacon, Henry, of Thornage, rector of Eggefeld 0
3874907 1981832 1981832 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3880635 1983787 1983787 defendant Bacon Henry clerk 599088 599088 Bacon, Henry, of Thornage, clerk 0
3880795 1983844 1983844 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3887917 1986208 1986208 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3889494 1986717 1986717 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3889495 1986717 1986717 defendant Bacon Henry clerk 599088 599088 Bacon, Henry, of Thornage, clerk 1
3893608 1988088 1988088 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3895108 1988574 1988574 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3896510 1989040 1989040 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3897516 1989383 1989383 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3898514 1989716 1989716 defendant Bacon Henry clerk 599088 599088 Bacon, Henry, of Thornage, clerk 0
3906098 1992331 1992331 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3908945 1993285 1993285 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 3
3909359 1993428 1993428 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3909360 1993428 1993428 defendant Skye Thomas yeoman 599088 599088 Skye, Thomas,of Thornage, yeoman 1
3909393 1993441 1993441 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3912789 1994608 1994608 defendant Skye Thomas yeoman 599088 599088 Skye, Thomas, of Thornage, yeoman 0
3916644 1995939 1995939 defendant Femlyn William   599088 599088 Femlyn, William, of Thornage, knight 2
3917245 1996127 1996127 defendant Bakon Henry clerk 599088 599088 Bakon, Henry, of Thornage, clerk 1
3920595 1997236 1997236 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3920598 1997237 1997237 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3920601 1997238 1997238 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3923188 1998064 1998064 defendant Skye Thomas yeoman 599088 599088 Skye, Thomas, of Thornage, yeoman 0
3923190 1998065 1998065 defendant Skye Thomas yeoman 599088 599088 Skye, Thomas, of Thornage, yeoman 0
3948776 2006641 2006641 defendant Bacon William, senior gent 599088 599088 Bacon, William, senior, of Thornage, gent 0
3948784 2006642 2006642 defendant Massynger Beavice yeoman 599088 599088 Massynger, Beavice, of Thornage, yeoman 6
3951996 2007761 2007761 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3960304 2010697 2010697 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3961624 2011166 2011166 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 0
3964558 2012206 2012206 defendant Bacon William, senior yeoman 599088 599088 Bacon, William, senior, of Thornage, yeoman 0
3980007 2017613 2017613 defendant Bakon William yeoman 599088 599088 Bakon, William, of Thornage, yeoman 0
3984251 2019133 2019133 defendant Harward Thomas husbandman 599088 599088 Harward, Thomas, of Thornage, husbandman 1
3990451 2021336 2021336 defendant Bacon William gent 599088 599088 Bacon, William, of Thornage, gent 0
3998307 2024138 2024138 defendant Bacon William gent 599088 599088 Bacon, William, of Thornage, gent 0
4001056 2025153 2025153 plaintiff Gynne Hugh yeoman 599088 599088 Gynne, Hugh, of Thornage, yeoman 0
4014983 2030071 2030071 defendant Bacon William gent 599088 599088 Bacon, William, of Thornage, gent 9
4016162 2030477 2030477 defendant Bakon William gent 599088 599088 Bakon, William, of Thornage, gent 0
4016916 2030751 2030751 defendant Bacon William gent 599088 599088 Bacon, William, of Thornage, gent 0
4024720 2033523 2033523 defendant Borne James gent 599088 599088 Borne, James, of Thornage, or of Felddallyng, gent 0
4027338 2034425 2034425 defendant Bacon William, junior yeoman 599088 599088 Bacon, William, junior, of Thornage, yeoman 3
4052116 2043180 2043180 defendant Hagon John yeoman 599088 599088 Hagon, John, of Thornage, yeoman 1
4052128 2043181 2043181 defendant Hagon John yeoman 599088 599088 Hagon, John, of Thornage, yeoman 1
4076182 2051769 2051769 defendant Shelton Ralph   599088 599088 Shelton, Ralph, of Thornage, or of Carrowe, Norf, esq, son of John Shellton, of Shelton, Norf, knight 0
4076639 2051942 2051942 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 2
4108777 2063391 2063391 defendant Ludson Philip yeoman 599088 599088 Ludson, Philip, of Thornage, yeoman 1
4108782 2063393 2063393 defendant Ludston Philip yeoman 599088 599088 Ludston, Philip, of Thornage, yeoman 1
4138151 2074011 2074011 defendant Bakon William gent 599088 599088 Bakon, William, of Thornage, gent 0
4149364 2077902 2077902 defendant Bacon William yeoman 599088 599088 Bacon, William, of Thornage, yeoman 2
4198498 2095026 2095026 defendant Bacon William gent 599088 599088 Bacon, William, of Thornage, gent 0
4248790 2112583 2112583 defendant Stemes or Steines Robert yeoman 599088 599088 Stemes or Steines, Robert, of Thornage, yeoman 1
4257134 2115364 2115364 defendant Femlyn Robert husbandman 599088 599088 Femlyn, Robert, of Thornage, husbandman 0
4257135 2115364 2115364 defendant Maxell William husbandman 599088 599088 Maxell, William, of Thornage, husbandman 1
4394479 2162749 2162749 defendant Maxell Robert husbandman 599088 599088 Maxell, Robert, of Thornage, husbandman 2
4867051 2316659 2316659 defendant Pelton Stephen husbandman 599088 599088 Pelton, Stephen, of Thornage, husbandman 0
4881653 2321160 2321160 defendant Loys Richard shoemaker 599088 599088 Loys, Richard, of Thornage, shoemaker 6
4886214 2322550 2322550 defendant Coldyk Richard butcher 599088 599088 (Coldyk, Richard, of Thornage, butcher 1
4900126 2326667 2326667 defendant Coldyk Robert butcher 599088 599088 Coldyk, Robert, of Thornage, butcher 3
4922816 2333549 2333549 defendant Coldyk Robert husbandman 599088 599088 Coldyk, Robert, of Thornage, husbandman 0
4952582 2342732 2342732 plaintiff Hoppe Robert   599088 599088 Hoppe, Robert, of Thornage 1
4962130 2345577 2345577 defendant Coldyk Robert butcher 599088 599088 Coldyk, Robert, of Thornage, butcher 8
4990713 2354133 2354133 defendant Petyt John yeoman 599088 599088 Petyt, John, of Thornage, yeoman 0
4990714 2354133 2354133 defendant Fuller George yeoman 599088 599088 Fuller, George, of Thornage, yeoman 1
4990715 2354133 2354133 defendant Broun William yeoman 599088 599088 Broun, William, of Thornage, yeoman 2
5057150 2373719 2373719 defendant Wylles William yeoman 599088 599088 Wylles, William, of Thornage, yeoman 0
5071206 2377885 2377885 defendant Wyllys William yeoman 599088 599088 Wyllys, William, of Thornage, yeoman 2
5071876 2378083 2378083 defendant Hoppe Robert yeoman 599088 599088 Hoppe, Robert, of Thornage, yeoman 1
5096725 2385479 2385479 defendant Hoppe Robert yeoman 599088 599088 Hoppe, Robert, of Thornage, yeoman 0
5099881 2386401 2386401 defendant Hoppys Robert yeoman 599088 599088 Hoppys, Robert, of Thornage, yeoman 0
5103448 2387434 2387434 defendant Wyllys William yeoman 599088 599088 Wyllys, William, of Thornage, yeoman 0
5112056 2389912 2389912 defendant Wyllys William yeoman 599088 599088 Wyllys, William, of Thornage, yeoman 0
5123723 2393398 2393398 defendant Hoppys Robert yeoman 599088 599088 Hoppys, Robert, of Thornage, yeoman 0
5211945 2419232 2419232 defendant Syre Robert clerk 599088 599088 Syre, Robert, of Thornage, clerk 0
5221989 2422134 2422134 defendant Hoppe Robert yeoman 599088 599088 Hoppe, Robert, of Thornage, yeoman 1
5223732 2422625 2422625 defendant Hoppe William husbandman 599088 599088 Hoppe, William, of Thornage, husbandman 0
5223738 2422626 2422626 defendant Hoppe William husbandman 599088 599088 Hoppe, William, of Thornage, husbandman 0
5268474 2435900 2435900 defendant Hoppes William yeoman 599088 599088 Hoppes, William, of thornage, yeoman 1
5286398 2441023 2441023 defendant Hoppe William yeoman 599088 599088 Hoppe, William, of Thornage, yeoman 0
5348254 2459597 2459597 defendant Byrlyngham Robert husbandman 599088 599088 Byrlyngham, Robert, of Thornage, husbandman 5
5348263 2459598 2459598 defendant Hoppys Robert husbandman 599088 599088 Hoppys, Robert, of Thornage, husbandman 3
5351212 2460472 2460472 defendant Byrlyngham Robert husbandman 599088 599088 Byrlyngham, Robert, of Thornage, husbandman 7
5426496 2482870 2482870 defendant Wythams James clerk 599088 599088 Wythams, James, of Thornage, clerk 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);