names

77 rows where place_id = 586287

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588362 1864010 1864010 defendant Harryngton Richard husbandman 586287 586287 Harryngton, Richard, of Horsyngton, husbandman 1
3635648 1905951 1905951 defendant Dey Thomas yeoman 586287 586287 Dey, Thomas, of Horsyngton, yeoman 0
3636920 1906341 1906341 defendant Cobbe John clerk 586287 586287 Cobbe, John, of Horsyngton, clerk 0
3670570 1916758 1916758 defendant Benyngworth William husbandman 586287 586287 Benyngworth, William, of Horsyngton, husbandman 1
3670576 1916759 1916759 defendant Benyngworth William husbandman 586287 586287 Benyngworth, William, of Horsyngton, husbandman 1
3682583 1920658 1920658 defendant Cayll John clerk 586287 586287 Cayll, John, of Horsyngton, clerk 0
3682584 1920658 1920658 defendant Teryngton William husbandman 586287 586287 Teryngton, William, of Horsyngton, husbandman 1
3682585 1920658 1920658 defendant Butler John husbandman 586287 586287 Butler, John, of Horsyngton, husbandman 2
3682586 1920658 1920658 defendant Madyson William husbandman 586287 586287 Madyson, William, of Horsyngton, husbandman 3
3682587 1920658 1920658 defendant Waynman John husbandman 586287 586287 Waynman, John, of Horsyngton, husbandman 4
3682588 1920658 1920658 defendant Broune Richard husbandman 586287 586287 Broune, Richard, of Horsyngton, husbandman 5
3682589 1920658 1920658 defendant Yenson Robert husbandman 586287 586287 Yenson, Robert, of Horsyngton, husbandman 6
3682590 1920658 1920658 defendant Pate Thomas husbandman 586287 586287 Pate, Thomas, of Horsyngton, husbandman 7
3682591 1920658 1920658 defendant Pecoke Robert husbandman 586287 586287 Pecoke, Robert, of Horsyngton, husbandman 8
3696720 1925201 1925201 defendant Bygge Gilbert husbandman 586287 586287 Bygge, Gilbert, of Horsyngton, husbandman 0
3718371 1932030 1932030 defendant Anturn William smith 586287 586287 Anturn, William, of Horsyngton, smith 0
3842441 1971172 1971172 defendant Clerkson Arthur husbandman 586287 586287 Clerkson, Arthur, of Horsyngton, husbandman 0
3872228 1980939 1980939 defendant Hubbethorn John husbandman 586287 586287 Hubbethorn, John, of Horsyngton, husbandman 2
3876771 1982473 1982473 defendant Wykeham John gent 586287 586287 Wykeham, John, of Horsyngton, gent 0
3884208 1984985 1984985 defendant Colyn Edmund husbandman 586287 586287 (Colyn, Edmund, of Horsyngton, husbandman 1
4046120 2041050 2041050 defendant Weight Richard husbandman 586287 586287 Weight, Richard, of Horsyngton, husbandman 0
4462980 2189122 2189122 defendant Edmund Robert   586287 586287 Edmund, Robert, of Horsyngton 0
4476664 2193362 2193362 defendant Dagon John   586287 586287 Dagon, John, of Horsyngton 0
4477388 2193593 2193593 defendant Wynter Simon   586287 586287 Wynter, Simon, of Horsyngton 1
4565735 2220843 2220843 defendant Claworth Thomas   586287 586287 Claworth, Thomas, of Horsyngton 2
4694527 2263783 2263783 defendant Wynter Robert merchant 586287 586287 Wynter, Robert, of Horsyngton, merchant 0
4879842 2320612 2320612 defendant Kitson William husbandman 586287 586287 Kitson, William, of Horsyngton, husbandman 0
4898992 2326330 2326330 defendant Archer Thomas, junior husbandman 586287 586287 Archer, Thomas, junior, of Horsyngton, husbandman 0
4899093 2326358 2326358 defendant Retford William husbandman 586287 586287 Retford, William, of Horsyngton, husbandman 0
4933738 2336930 2336930 defendant Clerk John husbandman 586287 586287 Clerk, John, of Horsyngton, husbandman 0
5016481 2361713 2361713 defendant Hyker John husbandman 586287 586287 Hyker, John, of Horsyngton, husbandman 9
5097503 2385699 2385699 defendant Walton Richard husbandman 586287 586287 Walton, Richard, of Horsyngton, husbandman 0
5097504 2385699 2385699 defendant Asby John husandman 586287 586287 Asby, John, of Horsyngton, husandman 1
5097505 2385699 2385699 defendant Walton Robert laborer 586287 586287 Walton, Robert, of Horsyngton, laborer 2
5109906 2389324 2389324 defendant Hanam William husbandman 586287 586287 Hanam, William, of Horsyngton, husbandman 0
5116170 2391155 2391155 defendant Olyver alias Corser Thomas courser 586287 586287 Olyver alias Corser, Thomas, of Horsyngton, courser 2
5119694 2392196 2392196 defendant Lovell John weaver 586287 586287 Lovell, John, of Horsyngton, weaver 1
5129411 2395089 2395089 defendant Archer John husbandman 586287 586287 Archer, John, of Horsyngton, husbandman 5
5131475 2395691 2395691 defendant Pronte or Proute John butcher 586287 586287 Pronte or Proute, John, of Horsyngton, butcher 3
5139429 2398019 2398019 defendant Hert William husbandman 586287 586287 Hert, William, of Horsyngton, husbandman 2
5141470 2398622 2398622 defendant Doughty William   586287 586287 Doughty, William, of Horsyngton, parson 0
5148705 2400745 2400745 defendant Archer John husbandman 586287 586287 Archer, John, of Horsyngton, husbandman 5
5160413 2404137 2404137 defendant Hert William husbandman 586287 586287 Hert, William, of Horsyngton, husbandman 2
5162587 2404778 2404778 defendant Doughty William   586287 586287 Doughty, William, of Horsyngton, parson 0
5162589 2404779 2404779 defendant Doughty William   586287 586287 Doughty, William, of Horsyngton, parson 0
5167913 2406327 2406327 defendant Archer John husbandman 586287 586287 Archer, John, of Horsyngton, husbandman 5
5175220 2408445 2408445 defendant Hert William husbandman 586287 586287 Hert, William, of Horsyngton, husbandman 2
5182690 2410694 2410694 defendant Yunge John husbandman 586287 586287 Yunge, John, of Horsyngton, husbandman 0
5183612 2410942 2410942 defendant Archer John husbandman 586287 586287 Archer, John, of Horsyngton, husbandman 4
5195789 2414516 2414516 defendant Blakemore John husbandman 586287 586287 Blakemore, John, of Horsyngton, husbandman 1
5196277 2414661 2414661 defendant Hert William husbandman 586287 586287 Hert, William, of Horsyngton, husbandman 2
5197698 2415069 2415069 defendant Brice William husbandman 586287 586287 Brice, William, of Horsyngton, husbandman 0
5203929 2416900 2416900 defendant Archer John husbandman 586287 586287 Archer, John, of Horsyngton, husbandman 4
5213426 2419658 2419658 defendant Ledale Edward yeoman 586287 586287 Ledale, Edward, of Horsyngton, yeoman 0
5283917 2440329 2440329 defendant Shefeld John yeoman 586287 586287 together with Shefeld, John, of Horsyngton, yeoman 1
5283926 2440329 2440329 defendant Shefeld John yeoman 586287 586287 Shefeld, John, of Horsyngton, yeoman 10
5309231 2447797 2447797 defendant Gorges Richard esq 586287 586287 Gorges, Richard, of Horsyngton, esq 0
5323624 2452151 2452151 defendant Kydeford William husbandman 586287 586287 Kydeford, William, of Horsyngton, husbandman 3
5374709 2467686 2467686 defendant Cutteford William husbandman 586287 586287 Cutteford, William, of Horsyngton, husbandman 1
5393888 2473313 2473313 defendant Sheffeld Robert yeoman 586287 586287 Sheffeld, Robert, of Horsyngton, yeoman 1
5412541 2478695 2478695 defendant Shefeld Robert yeoman 586287 586287 Shefeld, Robert, of Horsyngton, yeoman 4
5427368 2483128 2483128 defendant Sheffeld Robert yeoman 586287 586287 Sheffeld, Robert, of Horsyngton, yeoman 2
5445165 2488442 2488442 defendant Sheffeld Robert yeoman 586287 586287 Sheffeld, Robert, of Horsyngton, yeoman 2
5449061 2489612 2489612 defendant Skylton John yeoman 586287 586287 Skylton, John, of Horsyngton, yeoman 3
5450910 2490160 2490160 defendant Lyteford William yeoman 586287 586287 Lyteford, William, of Horsyngton, yeoman 0
5457831 2492238 2492238 defendant Sheffeld Robert yeoman 586287 586287 Sheffeld, Robert, of Horsyngton, yeoman 2
5461253 2493309 2493309 defendant Skylton John yeoman 586287 586287 Skylton, John, of Horsyngton, yeoman 3
5472754 2496818 2496818 defendant Sheffeld Robert yeoman 586287 586287 Sheffeld, Robert, of Horsyngton, yeoman 2
5472764 2496821 2496821 defendant Sheffeld Robert yeoman 586287 586287 Sheffeld, Robert, of Horsyngton, yeoman 2
5472770 2496822 2496822 defendant Sheffeld Robert yeoman 586287 586287 Sheffeld, Robert, of Horsyngton, yeoman 2
5472829 2496832 2496832 defendant Skylton John yeoman 586287 586287 Skylton, John, of Horsyngton, yeoman 3
5480980 2499265 2499265 defendant Lek John clerk 586287 586287 Lek, John, of Horsyngton, clerk 2
5480981 2499265 2499265 defendant Skelton John yeoman 586287 586287 Skelton, John, of Horsyngton, yeoman 3
5484358 2500242 2500242 defendant Sheffeld Robert yeoman 586287 586287 Sheffeld, Robert, of Horsyngton, yeoman 2
5522007 2511701 2511701 defendant Clough Henry husbandman 586287 586287 Clough, Henry, of Horsyngton, husbandman 3
5522008 2511701 2511701 defendant Wolles Robert husbandman 586287 586287 Wolles, Robert, of Horsyngton, husbandman 4
5576779 2527781 2527781 defendant Charnokke Richard chaplain 586287 586287 Charnokke, Richard, of Horsyngton, chaplain 0

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