names

58 rows where place_id = 596199

✎ 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
3623638 1874925 1874925 defendant Coke Thomas husbandman 596199 596199 Coke, Thomas, of Est Bylney, husbandman 0
3623639 1874925 1874925 defendant Braddenham Thomas husbandman 596199 596199 Braddenham, Thomas, of Est Bylney, husbandman 1
3628439 1903762 1903762 defendant Cabache John yeoman 596199 596199 Cabache, John, of Est Bylney, yeoman 4
3715694 1931200 1931200 plaintiff Cabache John (legal representative) 596199 596199 Cabache, John, of Est Bylney, executors of 0
3811120 1961374 1961374 plaintiff Caboche John (legal representative) 596199 596199 Caboche, John, of Est Bylney, executor of 0
3829745 1967195 1967195 defendant Marche alias Marshall Nicholas clerk 596199 596199 Marche alias Marshall, Nicholas, of Est Bylney, clerk 0
3874457 1981685 1981685 defendant Marshall William husbandman 596199 596199 Marshall, William, of Est Bylney, husbandman 0
3878986 1983221 1983221 defendant Crowe Richard yeoman 596199 596199 Crowe, Richard, of Est Bylney, yeoman 0
3888774 1986496 1986496 defendant Aleyn William (legal representative) 596199 596199 Aleyn, William, of Est Bylney, executors of 2
3922788 1997929 1997929 defendant Spavy or Spany Thomas husbandman 596199 596199 Spavy or Spany, Thomas, of Est Bylney, husbandman 5
4057031 2044898 2044898 defendant Wood William husbandman 596199 596199 Wood, William, of Est Bylney, husbandman 0
4059718 2045870 2045870 defendant Pope Robert cooper 596199 596199 Pope, Robert, of Est Bylney, cooper 0
4059720 2045871 2045871 defendant Pope Robert cooper 596199 596199 Pope, Robert, of Est Bylney, cooper 0
4091306 2057181 2057181 defendant Sturgyon Roger husbandman 596199 596199 Sturgyon, Roger, of Est Bylney, or of South Pickenham, Norf, husbandman 3
4258395 2115775 2115775 defendant Cutler Richard baker 596199 596199 Cutler, Richard, of East Bylney, baker 0
4753252 2281401 2281401 defendant Payn John   596199 596199 Payn, John, of East Bylney, parson 3
4753295 2281411 2281411 defendant Payn John   596199 596199 Payn, John, of East Bylney, parson 1
4768797 2286218 2286218 defendant Wystard William yeoman 596199 596199 Wystard, William, of East Bylney, yeoman 0
5050431 2371754 2371754 defendant Goodson Richard baker 596199 596199 Goodson, Richard, of East Bylney, baker 0
5051332 2372010 2372010 defendant Langdon Thomas yeoman 596199 596199 Langdon, Thomas, of East Bylney, yeoman 0
5061861 2375144 2375144 defendant Brome John laborer 596199 596199 Brome, John, of Est Bylney, laborer 2
5061862 2375144 2375144 defendant Gogeney William barker 596199 596199 Gogeney, William, of Est Bylney, barker 3
5066759 2376587 2376587 defendant Langedon Thomas yeoman 596199 596199 Langedon, Thomas, of Est Bylney, yeoman 0
5116231 2391177 2391177 plaintiff of Some Edmund husbandman 596199 596199 of Some, Edmund, of Est Bylney, husbandman 0
5160803 2404256 2404256 defendant Meketon John   596199 596199 Meketon, John, of East Bylney, notary 0
5219647 2421480 2421480 defendant Davy William husbandman 596199 596199 Davy, William, of Est Bylney, husbandman 4
5268178 2435819 2435819 plaintiff Barker Henry   596199 596199 Barker, Henry, of East Bylney 0
5271271 2436691 2436691 defendant Webster William weaver 596199 596199 Webster, William, of East Bylney, weaver 3
5275493 2437901 2437901 defendant Caudeler Thomas husbandman 596199 596199 Caudeler, Thomas, of East Bylney, husbandman 5
5307533 2447265 2447265 defendant Trendyll Henry husbandman 596199 596199 (Trendyll, Henry, of East Bylney, husbandman 1
5330974 2454329 2454329 defendant Barker Robert yeoman 596199 596199 Barker, Robert, of Est Bylney, yeoman 0
5335812 2455776 2455776 defendant Rowenyng Robert clerk 596199 596199 Rowenyng, Robert, of Est Bylney, clerk 0
5341031 2457395 2457395 defendant Flowredewe John husbandman 596199 596199 Flowredewe, John, of Est Bylney, husbandman 0
5348280 2459601 2459601 defendant Trendyll Thomas husbandman 596199 596199 Trendyll, Thomas, of Est Bylney, husbandman 6
5349397 2459944 2459944 defendant Taillour alias Bocher Stephen carpenter 596199 596199 Taillour alias Bocher, Stephen, of Est Bylney, carpenter 0
5352300 2460820 2460820 defendant Kyng Stephen husbandman 596199 596199 Kyng, Stephen, of Est Bylney, husbandman 0
5352304 2460821 2460821 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of Est Bylney, husbandman 1
5357470 2462404 2462404 defendant Kyng Stephen carpenter 596199 596199 Kyng, Stephen, of Est Bylney, carpenter 1
5376958 2468389 2468389 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 0
5391019 2472499 2472499 defendant Barker Robert yeoman 596199 596199 Barker, Robert, of East Bylney, yeoman 0
5392906 2473042 2473042 defendant Barker Robert tanner 596199 596199 Barker, Robert, of East Bylney, tanner 0
5393007 2473071 2473071 defendant Kyng Stephen carpenter 596199 596199 Kyng, Stephen, of East Bylney, carpenter 0
5393010 2473072 2473072 defendant Barker Robert tanner 596199 596199 Barker, Robert, of East Bylney, husbandman, tanner 0
5393018 2473074 2473074 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 1
5405594 2476677 2476677 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 2
5406150 2476837 2476837 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 2
5419218 2480676 2480676 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 1
5421115 2481243 2481243 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 4
5440332 2487006 2487006 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 3
5440344 2487007 2487007 defendant Barker Robert husbandman 596199 596199 Barker, Robert, of East Bylney, husbandman 3
5512483 2508765 2508765 defendant Barker alias Feltewell Robert barker 596199 596199 Barker alias Feltewell, Robert, of Est Bylney, barker 0
5549661 2519948 2519948 defendant Rawlyn Thomas husbandman 596199 596199 Rawlyn, Thomas, of Est Bylney, husbandman 0
5549662 2519948 2519948 defendant Barker Richard husbandman 596199 596199 Barker, Richard, of Est Bylney, husbandman 1
5568995 2525483 2525483 defendant Feltwell John barker 596199 596199 Feltwell, John, of Est Bylney, barker 2
5569003 2525484 2525484 defendant Feltwell John   596199 596199 Feltwell, John, of Est Bylney, 2
5608239 2537477 2537477 defendant (illegible) (illegible) yeoman 596199 596199 ---, ---, of East Bylney, yeoman 0
5608729 2537631 2537631 defendant Barker alias Feltwell Robert yeoman 596199 596199 Barker alias Feltwell, Robert, of East Bylney, yeoman 0
5608730 2537631 2537631 defendant Caboche Thomas yeoman 596199 596199 Caboche, Thomas, of East Bylney, yeoman 1

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