names

65 rows where place_id = 587688

✎ 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
3592150 1865164 1865164 defendant Freke Geoffrey (legal representative) 587688 587688 Freke, Geoffrey, of Magna Dunmowe, executors of 1
3592151 1865164 1865164 defendant Hutte John smith 587688 587688 (Hutte, John, of Magna Dunmowe, smith 2
3605307 1869324 1869324 defendant Freke John yeoman 587688 587688 Freke, John, of Magna Dunmowe, yeoman 1
3612784 1871649 1871649 defendant Freke John yeoman 587688 587688 Freke, John, of Magna Dunmowe, yeoman 0
3622494 1874573 1874573 defendant Hynden William yeoman 587688 587688 Hynden, William, of Magna Dunmowe, yeoman 1
3629668 1904133 1904133 plaintiff Davy Robert (legal representative) 587688 587688 Davy, Robert, of Magna Dunmowe, executor of 0
3629671 1904133 1904133 defendant Dykby alias Dogdyche John yeoman 587688 587688 Dykby alias Dogdyche, John, of Magna Dunmowe, yeoman 1
3668372 1916055 1916055 defendant Storeton William husbandman 587688 587688 Storeton, William, of Magna Dunmowe, husbandman 0
3694955 1924633 1924633 defendant Barrell John butcher 587688 587688 Barrell, John, of Magna Dunmowe, butcher 0
3739678 1938623 1938623 defendant Pomfrett Miles butcher 587688 587688 Pomfrett, Miles, of Magna Dunmowe, butcher 0
3745241 1940419 1940419 defendant Theyer John husbandman 587688 587688 Theyer, John, of Magna Dunmowe, husbandman 2
3765351 1946825 1946825 defendant Thake Thomas yeoman 587688 587688 Thake, Thomas, of Magna Dunmowe, yeoman 0
3772517 1949096 1949096 defendant Kymes Henry sherman 587688 587688 Kymes, Henry, of Magna Dunmowe, sherman 0
3874991 1981860 1981860 defendant Kynwolmarsshe John gent 587688 587688 Kynwolmarsshe, John, of Magna Dunmowe, gent 0
3894023 1988218 1988218 defendant Turner John husbandman 587688 587688 Turner, John, of Magna Dunmowe, husbandman 0
3894024 1988218 1988218 defendant Draper Robert husbandman 587688 587688 Draper, Robert, of Magna Dunmowe, husbandman 1
3895340 1988647 1988647 defendant Cok Nicholas whitawer 587688 587688 Cok, Nicholas, of Magna Dunmowe, whitawer 0
3895342 1988648 1988648 defendant Moyne Thomas fuller 587688 587688 Moyne, Thomas, of Magna Dunmowe, fuller 0
3895344 1988649 1988649 defendant Parker Henry husbandman 587688 587688 Parker, Henry, of Magna Dunmowe, husbandman 0
4662856 2249844 2249844 plaintiff Fysshere Richard   587688 587688 Fysshere, Richard, of Magna Dunmowe 0
4662858 2249844 2249844 defendant Barbour Thomas barber 587688 587688 Barbour, Thomas, of Magna Dunmowe, barber 1
4789454 2292768 2292768 defendant Manwode Geoffrey husbandman 587688 587688 Manwode, Geoffrey, of Magna Dunmowe, husbandman 1
4801455 2296636 2296636 defendant Middelton John   587688 587688 Middelton, John, of Magna Dunmowe, church clerk 3
4801456 2296636 2296636 defendant Arnold John fisher 587688 587688 Arnold, John, of Magna Dunmowe, fisher 4
4870042 2317596 2317596 defendant Whelere Henry wheeler 587688 587688 Whelere, Henry, of Magna Dunmowe, wheeler 1
4878007 2320076 2320076 defendant Ponde William butcher 587688 587688 Ponde, William, of Magna Dunmowe, butcher 1
4892341 2324340 2324340 defendant Phelypp John laborer 587688 587688 Phelypp, John, of Magna Dunmowe, laborer 2
4904273 2327951 2327951 defendant London William carpenter 587688 587688 London, William, of Magna Dunmowe, carpenter 0
4950081 2341994 2341994 defendant Hamper William tailor 587688 587688 Hamper, William, of Magna Dunmowe, tailor 0
4972098 2348593 2348593 defendant Parker Nicholas husbandman 587688 587688 Parker, Nicholas, of Magna Dunmowe, husbandman 0
4972106 2348595 2348595 defendant Parker Nicholas husbandman 587688 587688 Parker, Nicholas, of Magna Dunmowe, husbandman 0
5077941 2379885 2379885 plaintiff Botiller John yeoman 587688 587688 Botiller, John, of Magna Dunmowe, yeoman 0
5081876 2381076 2381076 defendant Curteys John laborer 587688 587688 Curteys, John, of Magna Dunmowe, laborer 0
5081877 2381076 2381076 defendant Clerk Robert   587688 587688 Clerk, Robert, of Magna Dunmowe, servant 1
5081878 2381076 2381076 defendant Omond Thomas laborer 587688 587688 Omond, Thomas, of Magna Dunmowe, laborer 2
5081879 2381076 2381076 defendant Parker John   587688 587688 Parker, John, of Magna Dunmowe, servant 3
5086372 2382409 2382409 defendant Olyvere Richard yeoman 587688 587688 Olyvere, Richard, of Magna Dunmowe, yeoman 1
5108594 2388951 2388951 defendant Freman Thomas yeoman 587688 587688 Freman, Thomas, of Magna Dunmowe, yeoman 0
5108596 2388951 2388951 defendant Hamper John tailor 587688 587688 Hamper, John, of Magna Dunmowe, tailor 2
5108599 2388951 2388951 defendant Lewys John fuller 587688 587688 Lewys, John, of Magna Dunmowe, fuller 5
5108600 2388951 2388951 defendant Barell John yeoman 587688 587688 Barell, John, of Magna Dunmowe, yeoman 6
5108601 2388951 2388951 defendant Lane John laborer 587688 587688 Lane, John, of Magna Dunmowe, laborer 7
5108602 2388951 2388951 defendant Michell Thomas shoemaker 587688 587688 Michell, Thomas, of Magna Dunmowe, shoemaker 8
5108603 2388951 2388951 defendant Vytener or Vyntener John fuller 587688 587688 Vytener or Vyntener, John, of Magna Dunmowe, fuller 9
5108604 2388951 2388951 defendant Coke Nicholas laborer 587688 587688 Coke, Nicholas, of Magna Dunmowe, laborer 10
5225570 2423152 2423152 defendant Stoor John sawyer 587688 587688 Stoor, John, of Magna Dunmowe, sawyer 1
5233642 2425428 2425428 defendant Fuller John, senior yeoman 587688 587688 Fuller, John, senior, of Magna Dunmowe, yeoman 3
5257666 2432519 2432519 defendant Glascok William butcher 587688 587688 Glascok, William, of Magna Dunmowe, butcher 1
5262392 2433982 2433982 defendant Fuller John tailor 587688 587688 Fuller, John, of Magna Dunmowe, tailor 3
5314259 2449282 2449282 defendant Glascok William butcher 587688 587688 Glascok, William, of Magna Dunmowe, butcher 0
5315083 2449565 2449565 defendant Ponde John husbandman 587688 587688 Ponde, John, of Magna Dunmowe, husbandman 0
5315084 2449565 2449565 defendant Morse Richard husbandman 587688 587688 Morse, Richard, of Magna Dunmowe, husbandman 1
5315092 2449569 2449569 defendant Midlyng John gent 587688 587688 Midlyng, John, of Magna Dunmowe, gent 0
5318962 2450764 2450764 defendant Mors Richard husbandman 587688 587688 Mors, Richard, of Magna Dunmowe, husbandman 0
5324130 2452302 2452302 defendant Glaskoke William butcher 587688 587688 Glaskoke, William, of Magna Dunmowe, butcher 0
5329481 2453882 2453882 defendant Coll alias Bocher Thomas husbandman 587688 587688 Coll alias Bocher, Thomas, of Magna Dunmowe, husbandman 3
5334814 2455480 2455480 defendant Fuller Thomas draper 587688 587688 Fuller, Thomas, of Magna Dunmowe, merchant, son of Fuller, John, of Magna Dunmowe, draper 0
5349956 2460116 2460116 plaintiff Clere Richard yeoman 587688 587688 Clere, Richard, of Magna Dunmowe, yeoman 0
5351411 2460541 2460541 defendant Joyner Thomas chapman 587688 587688 Joyner, Thomas, of Magna Dunmowe, chapman 0
5353006 2461029 2461029 plaintiff Fuller John, junior   587688 587688 Fuller, John, junior, of Magna Dunmowe 0
5353021 2461033 2461033 defendant Ponde John butcher 587688 587688 Ponde, John, of Magna Dunmowe, butcher 0
5362712 2463986 2463986 defendant Neell John yeoman 587688 587688 Neell, John, of Magna Dunmowe, yeoman 0
5478504 2498599 2498599 defendant Kyng John (legal representative) 587688 587688 Kyng, John, of Magna Dunmowe, yeoman, servant of Wrytyll, John, esq, executors of 0
5544004 2518233 2518233 defendant Hokeley William butcher 587688 587688 Hokeley, William, of Magna Dunmowe, butcher 4
5601796 2535464 2535464 defendant Long John husbandman 587688 587688 Long, John, of Magna Dunmowe, husbandman 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);