names

93 rows where place_id = 587782

✎ 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
3592412 1865242 1865242 defendant Prey Thomas husbandman 587782 587782 Prey, Thomas, of Hokeryng, husbandman 0
3606078 1869568 1869568 defendant Smalpece Humphrey yeoman 587782 587782 Smalpece, Humphrey, of Hokeryng, yeoman 0
3649831 1910310 1910310 defendant Warner John smith 587782 587782 Warner, John, of Hokeryng, smith 2
3699899 1926197 1926197 plaintiff Alby William   587782 587782 Alby, William, of Hokeryng 0
3769112 1947994 1947994 defendant Salton John husbandman 587782 587782 Salton, John, of Hokeryng, husbandman 0
3781041 1951805 1951805 defendant Palmer Robert clerk 587782 587782 Palmer, Robert, of Hokeryng, clerk 0
3835024 1968894 1968894 defendant Smalpece Humphrey yeoman 587782 587782 Smalpece, Humphrey, of Hokeryng, yeoman 0
3924986 1998673 1998673 plaintiff Warner Richard tailor 587782 587782 Warner, Richard, of Hokeryng, tailor 0
4560862 2219354 2219354 defendant Geboun John, sen   587782 587782 Geboun, John, sen, of Hokeryng 0
4654913 2247418 2247418 defendant Gebon John husbandman 587782 587782 Gebon, John, of Hokeryng, husbandman 0
4674295 2257569 2257569 defendant atte Hirne William   587782 587782 atte Hirne, William, of Hokeryng, parson 0
4683334 2260391 2260391 defendant Herne William   587782 587782 Herne, William, of Hokeryng, parson 2
4695503 2264074 2264074 defendant Warner Henry laborer 587782 587782 Warner, Henry, of Hokeryng, laborer 0
4700369 2265531 2265531 defendant Broun Nicholas hosebondeman or husbandman 587782 587782 Broun, Nicholas, of Hokeryng, hosebondeman or husbandman 0
4700371 2265531 2265531 defendant atte Hill John husbandman 587782 587782 atte Hill, John, of Hokeryng, husbandman 2
4700372 2265531 2265531 defendant Gebon John husbandman 587782 587782 Gebon, John, of Hokeryng, husbandman 3
4700594 2265595 2265595 defendant atte Felde Hugh yeoman 587782 587782 atte Felde, Hugh, of Hokeryng, yeoman 1
4705997 2267250 2267250 defendant atte Hirne William   587782 587782 atte Hirne, William, of Hokeryng, parson 1
4705998 2267250 2267250 defendant atte Hill John husbandman 587782 587782 atte Hill, John, of Hokeryng, husbandman 2
4705999 2267250 2267250 defendant Gebon John husbandman 587782 587782 Gebon, John, of Hokeryng, husbandman 3
4709381 2268286 2268286 defendant Gebon John   587782 587782 Gebon, John, of Hokeryng, single man 1
4729658 2274486 2274486 defendant Wayte John yeoman 587782 587782 Wayte, John, of Hokeryng, yeoman 4
4730146 2274629 2274629 defendant atte Hyrne William clerk 587782 587782 atte Hyrne, William, of Hokeryng, clerk 3
4730435 2274714 2274714 defendant atte Hyrne William   587782 587782 atte Hyrne, William, of Hokeryng, parson 1
4732608 2275375 2275375 defendant Broun Nicholas yeoman 587782 587782 Broun, Nicholas, of Hokeryng, yeoman 0
4732610 2275375 2275375 defendant Sesyle John yeoman 587782 587782 Sesyle, John, of Hokeryng, yeoman 2
4736011 2276404 2276404 defendant Hirne William clerk 587782 587782 Hirne, William, of Hokeryng, clerk 0
4737504 2276843 2276843 defendant Shode Henry butcher 587782 587782 Shode, Henry, of Hokeryng, butcher 1
4749391 2280301 2280301 defendant Gybbon John husbandman 587782 587782 Gybbon, John, of Hokeryng, husbandman 0
4762551 2284268 2284268 defendant atte Hyrne William   587782 587782 atte Hyrne, William, of Hokeryng, parson 1
4793258 2293988 2293988 defendant Gebon John yeoman 587782 587782 Gebon, John, of Hokeryng, yeoman 0
4793259 2293988 2293988 defendant atte Hill John yeoman 587782 587782 atte Hill, John, of Hokeryng, yeoman 1
4804503 2297595 2297595 defendant atte Hirne William   587782 587782 atte Hirne, William, of Hokeryng, parson 0
4804505 2297596 2297596 defendant atte Hirne William   587782 587782 atte Hirne, William, of Hokeryng, parson 0
4812596 2300056 2300056 defendant atte Hyrne William clerk 587782 587782 atte Hyrne, William, of Hokeryng, clerk 0
4823785 2303524 2303524 defendant atte Hill John yeoman 587782 587782 atte Hill, John, of Hokeryng, yeoman 3
4823786 2303524 2303524 defendant Gebon William yeoman 587782 587782 Gebon, William, of Hokeryng, yeoman 4
4835739 2307176 2307176 defendant Shode Henry butcher 587782 587782 Shode, Henry, of Hokeryng, butcher 0
4835740 2307176 2307176 defendant Gobon John laborer 587782 587782 Gobon, John, of Hokeryng, laborer 1
4845757 2310184 2310184 defendant Gebon John husbandman 587782 587782 Gebon, John, of Hokeryng, husbandman 0
4869892 2317553 2317553 defendant Baxstere John yeoman 587782 587782 Baxstere, John, of Hokeryng, yeoman 3
4874275 2318899 2318899 defendant Broun Nicholas butcher 587782 587782 Broun, Nicholas, of Hokeryng, butcher 2
4913293 2330658 2330658 defendant Skot John yeoman 587782 587782 Skot, John, of Hokeryng, yeoman 0
4937065 2337964 2337964 defendant Wade John husbandman 587782 587782 together with Wade, John, of Hokeryng, husbandman 7
4962522 2345694 2345694 defendant Gryme Thomas, senior tailor 587782 587782 Gryme, Thomas, senior, of Hokeryng, tailor 1
4962523 2345694 2345694 defendant Baxter John baker 587782 587782 Baxter, John, of Hokeryng, baker 2
5042871 2369476 2369476 defendant Wade John laborer 587782 587782 Wade, John, of Hokeryng, laborer 0
5046716 2370640 2370640 defendant Skot William husbandman 587782 587782 Skot, William, of Hokeryng, husbandman 2
5086071 2382317 2382317 defendant Wade John yeoman 587782 587782 Wade, John, of Hokeryng, yeoman 0
5095470 2385094 2385094 defendant Broun Nicholas yeoman 587782 587782 Broun, Nicholas, of Hokeryng, yeoman 0
5095968 2385248 2385248 defendant Skot William yeoman 587782 587782 Skot, William, of Hokeryng, yeoman 9
5105420 2388026 2388026 defendant Warker William, junior yeoman 587782 587782 Warker, William, junior, of Hokeryng, yeoman 0
5142376 2398892 2398892 defendant Gebon John husbandman 587782 587782 Gebon, John, of Hokeryng, husbandman 0
5142377 2398892 2398892 defendant Warner William, junior tanner 587782 587782 Warner, William, junior, of Hokeryng, tanner 1
5217104 2420742 2420742 defendant Wade John husbandman 587782 587782 Wade, John, of Hokeryng, husbandman 2
5217106 2420742 2420742 defendant Sygge John husbandman 587782 587782 Sygge, John, of Hokeryng, husbandman 4
5274558 2437640 2437640 plaintiff Qwythede Robert   587782 587782 Qwythede, Robert, of Hokeryng, rector 0
5274559 2437640 2437640 defendant Pekeryng William   587782 587782 Pekeryng, William, of Hokeryng, Rector 0
5279376 2439055 2439055 defendant Mounteney William husbandman 587782 587782 Mounteney, William, of Hokeryng, husbandman 2
5279385 2439056 2439056 defendant Whythede Robert clerk 587782 587782 Whythede, Robert, of Hokeryng, clerk 2
5288794 2441735 2441735 defendant Kechyn Alan   587782 587782 Kechyn, Alan, of Hokeryng, husbandma 3
5300312 2445051 2445051 defendant Mounteney William husbandman 587782 587782 Mounteney, William, of Hokeryng, husbandman 1
5301893 2445519 2445519 defendant Randesson William laborer 587782 587782 Randesson, William, of Hokeryng, laborer 3
5319767 2451004 2451004 defendant Hydson John clerk 587782 587782 Hydson, John, of Hokeryng, clerk 5
5321487 2451518 2451518 defendant Charles Henry husbandman 587782 587782 Charles, Henry, of Hokeryng, husbandman 2
5322723 2451872 2451872 defendant Broun Roger husbandman 587782 587782 Broun, Roger, of Hokeryng, husbandman 3
5349696 2460040 2460040 defendant Grene Robert yeoman 587782 587782 Grene, Robert, of Hokeryng, yeoman 0
5351119 2460455 2460455 defendant Charles Henry husbandman 587782 587782 Charles, Henry, of Hokeryng, husbandman 0
5351120 2460455 2460455 defendant Mounteney William husbandman 587782 587782 Mounteney, William, of Hokeryng, husbandman 1
5351537 2460577 2460577 defendant Mounteney William husbandman 587782 587782 Mounteney, William, of Hokeryng, husbandman 8
5356571 2462124 2462124 defendant Hydson John clerk 587782 587782 Hydson, John, of Hokeryng, clerk 0
5360136 2463211 2463211 defendant Mownteney William husbandman 587782 587782 Mownteney, William, of Hokeryng, husbandman 1
5376308 2468185 2468185 defendant Hydson John clerk & Rector 587782 587782 Hydson, John, of Hokeryng, clerk & Rector 0
5380000 2469331 2469331 defendant Mounteney William husbandman 587782 587782 Mounteney, William, of Hokeryng, husbandman 0
5381410 2469743 2469743 defendant Aldby Thomas husbandman 587782 587782 Aldby, Thomas, of Hokeryng, husbandman 2
5388716 2471827 2471827 defendant Aldby Thomas husbandman 587782 587782 Aldby, Thomas, of Hokeryng, husbandman 2
5390033 2472211 2472211 defendant Shreve or Shrene Thomas husbandman 587782 587782 Shreve or Shrene, Thomas, of Hokeryng, husbandman 1
5408805 2477595 2477595 defendant Mounteney William husbandman 587782 587782 Mounteney, William, of Hokeryng, husbandman 0
5421207 2481274 2481274 defendant Gebon John husbandman 587782 587782 Gebon, John, of Hokeryng, husbandman 0
5441847 2487491 2487491 defendant Alby William (legal representative) 587782 587782 Alby, William, of Hokeryng, executors of 2
5441848 2487491 2487491 defendant Note John laborer 587782 587782 (Note, John, of Hokeryng, laborer 3
5454681 2491322 2491322 defendant Alby William (legal representative) 587782 587782 Alby, William, of Hokeryng, executors of 1
5454682 2491322 2491322 defendant Note John laborer 587782 587782 (Note, John, of Hokeryng, laborer 2
5466479 2494911 2494911 defendant Monteney William husbandman 587782 587782 Monteney, William, of Hokeryng, husbandman 0
5477821 2498385 2498385 defendant Mounteney William husbandman 587782 587782 Mounteney, William, of Hokeryng, husbandman 0
5481361 2499363 2499363 defendant Alby Geoffrey yeoman 587782 587782 Alby, Geoffrey, of Hokeryng, yeoman 0
5498839 2504592 2504592 defendant Brampton Robert clerk 587782 587782 Brampton, Robert, of Hokeryng, clerk 2
5552015 2520631 2520631 defendant Broun John laborer 587782 587782 Broun, John, of Hokeryng, laborer 1
5552016 2520631 2520631 defendant Towneshend Richard husbandman 587782 587782 Towneshend, Richard, of Hokeryng, husbandman 2
5552852 2520885 2520885 defendant Mayur Richard yeoman 587782 587782 Mayur, Richard, of Hokeryng, yeoman 0
5552853 2520885 2520885 defendant Albye John husbandman 587782 587782 Albye, John, of Hokeryng, husbandman 1
5565111 2524382 2524382 defendant Elsyng Thomas husbandman 587782 587782 Elsyng, Thomas, of Hokeryng, husbandman 1
5595648 2533562 2533562 defendant Elsyng Thomas yeoman 587782 587782 Elsyng, Thomas, of Hokeryng, 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);