names

47 rows where place_id = 638880

✎ 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
3845442 1972133 1972133 defendant Longmede Nicholas merchant 638880 638880 Longmede, Nicholas, of Dertemouth, Devon, merchant 0
3848750 1973194 1973194 defendant Trevanyon John, senior gent 638880 638880 Trevanyon, John, senior, of Dertemouth, Devon, gent 0
4660300 2249052 2249052 defendant Hauley John esq 638880 638880 Hauley, John, of Dertemouth, Devon, esq 0
4667215 2255479 2255479 defendant Hauley John   638880 638880 Hauley, John, of Dertemouth, Devon 0
4671239 2256659 2256659 defendant Beare John chapman 638880 638880 Beare, John, of Dertemouth, Devon, chapman 0
4672633 2257082 2257082 defendant Parys John merchant 638880 638880 Parys, John, of Dertemouth, Devon, merchant 2
4682818 2260243 2260243 defendant Haule John esq 638880 638880 Haule, John, of Dertemouth, Devon, esq 3
4682823 2260244 2260244 defendant Hauls John esq 638880 638880 Hauls, John, of Dertemouth, Devon, esq 3
4688946 2262097 2262097 defendant atte Wode John merchant 638880 638880 atte Wode, John, of Dertemouth, Devon, merchant 0
4688948 2262098 2262098 defendant atte Wode John merchant 638880 638880 atte Wode, John, of Dertemouth, Devon, merchant 0
4739979 2277583 2277583 defendant Hauley John esq 638880 638880 Hauley, John, of Dertemouth, Devon, esq 0
4749518 2280338 2280338 defendant Hawley John, junior esq 638880 638880 Hawley, John, junior, of Dertemouth, Devon, esq 0
4776947 2288776 2288776 defendant Hanley or Hauley John esq 638880 638880 Hanley or Hauley, John, of Dertemouth, Devon, esq 0
4783124 2290737 2290737 defendant Aumery Gervase hooker 638880 638880 Aumery, Gervase, of Dertemouth, Devon, hooker 2
4785778 2291589 2291589 defendant Goman John   638880 638880 Goman, John, of Dertemouth, Devon, fish hook maker 0
4788880 2292574 2292574 defendant William Thomas chaplain 638880 638880 William, Thomas, of Dertemouth, Devon, chaplain 0
4788884 2292576 2292576 defendant William Thomas chaplain 638880 638880 William, Thomas, of Dertemouth, Devon, chaplain 0
4792434 2293718 2293718 defendant Straunge John merchant 638880 638880 Straunge, John, of Dertemouth, Devon, merchant 1
4819834 2302276 2302276 defendant Asshendene Thomas merchant & gent 638880 638880 Asshendene, Thomas, of Dertemouth, Devon, merchant & gent 2
4819837 2302277 2302277 defendant Asshenden Thomas merchant 638880 638880 Asshenden, Thomas, of Dertemouth, Devon, merchant 1
4825053 2303877 2303877 defendant Gerard Andrew shipman 638880 638880 Gerard, Andrew, of Dertemouth, Devon, shipman 0
4857783 2313810 2313810 defendant Hanley or Hauley John esq 638880 638880 Hanley or Hauley, John, of Dertemouth, Devon, esq 0
4859585 2314368 2314368 defendant Yon Hugh merchant 638880 638880 Yon, Hugh, of Dertemouth, Devon, merchant 0
4859587 2314369 2314369 defendant Yon Hugh merchant 638880 638880 Yon, Hugh, of Dertemouth, Devon, merchant 0
4879586 2320542 2320542 defendant Colton John merchant 638880 638880 Colton, John, of Dertemouth, Devon, merchant 0
4879591 2320543 2320543 defendant Colton John merchant 638880 638880 Colton, John, of Dertemouth, Devon, merchant 0
4890126 2323689 2323689 defendant Hanley Nicholas gent 638880 638880 Hanley, Nicholas, of Dertemouth, Devon, gent 0
4891033 2323936 2323936 defendant Hawley John esq 638880 638880 Hawley, John, of Dertemouth, Devon, esq 0
4898253 2326115 2326115 defendant Colman John mariner 638880 638880 Colman, John, of Dertemouth, Devon, mariner 0
4901641 2327116 2327116 defendant Staunford Robert merchant 638880 638880 Staunford, Robert, of Dertemouth, Devon, merchant 2
4910209 2329712 2329712 defendant Ralf John skinner 638880 638880 Ralf, John, of Dertemouth, Devon, skinner 2
4937915 2338238 2338238 defendant Walsshe Philip merchant 638880 638880 Walsshe, Philip, of Dertemouth, Devon, merchant 0
4958347 2344463 2344463 defendant Chedder John gent 638880 638880 Chedder, John, of Dertemouth, Devon, gent 0
5006671 2358848 2358848 defendant Gaynecote John merchant 638880 638880 Gaynecote, John, of Dertemouth, Devon, merchant 0
5020061 2362753 2362753 defendant Bordys Mathew merchant 638880 638880 Bordys, Mathew, of Dertemouth, Devon, merchant 0
5020065 2362755 2362755 defendant Bucke William merchant 638880 638880 Bucke, William, of Dertemouth, Devon, merchant 0
5032179 2366290 2366290 defendant Walsshe John (legal representative) 638880 638880 Walsshe, John, of Dertemouth, Devon, merchant, executors of 0
5032183 2366291 2366291 defendant Yon Hugh gent 638880 638880 Yon, Hugh, of Dertemouth, Devon, gent 0
5058694 2374163 2374163 defendant Stephen Robert merchant 638880 638880 Stephen, Robert, of Dertemouth, Devon, merchant 0
5066118 2376389 2376389 defendant Hawselyn Richard gent 638880 638880 Hawselyn, Richard, of Dertemouth, Devon, gent 0
5100674 2386621 2386621 defendant Wrangbrok Thomas merchant 638880 638880 Wrangbrok, Thomas, of Dertemouth, Devon, merchant 3
5119195 2392042 2392042 defendant Bowyer Robert merchant 638880 638880 Bowyer, Robert, of Dertemouth, Devon, merchant 1
5138628 2397793 2397793 defendant Brussheford William gent 638880 638880 Brussheford, William, of Dertemouth, Devon, gent 0
5251381 2430530 2430530 defendant Gale Thomas gent 638880 638880 Gale, Thomas, of Dertemouth, Devon, gent 0
5255564 2431858 2431858 defendant Gale Thomas gent 638880 638880 Gale, Thomas, of Dertemouth, Devon, gent 0
5268167 2435814 2435814 defendant Gale Thomas merchant 638880 638880 Gale, Thomas, of Dertemouth, Devon, merchant 0
5332792 2454876 2454876 defendant Gale Thomas gent 638880 638880 Gale, Thomas, of Dertemouth, Devon, gent 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);