names

146 rows where place_id = 639423

✎ 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
3848751 1973194 1973194 defendant Trevanyon John, junior gent 639423 639423 Trevanyon, John, junior, of Dertemouth, gent 1
3852858 1974503 1974503 defendant Semer Thomas merchant 639423 639423 Semer, Thomas, of Dertemouth, merchant 0
4450285 2185048 2185048 plaintiff Hanlegh John   639423 639423 Hanlegh, John, of Dertemouth 0
4453237 2186020 2186020 defendant Phelip Robert   639423 639423 Phelip, Robert, of Dertemouth 0
4455550 2186740 2186740 defendant Wille William   639423 639423 Wille, William, of Dertemouth 0
4456387 2187026 2187026 plaintiff Knolle William   639423 639423 (Knolle, William, of Dertemouth 1
4456392 2187026 2187026 defendant Worthy Walter   639423 639423 Worthy, Walter, of Dertemouth 0
4457390 2187324 2187324 defendant Bast William   639423 639423 Bast, William, of Dertemouth 0
4469570 2191144 2191144 defendant Pparys John   639423 639423 Pparys, John, of Dertemouth 0
4477911 2193759 2193759 plaintiff Hanley John   639423 639423 Hanley, John, of Dertemouth 0
4477913 2193760 2193760 plaintiff Hanley John   639423 639423 Hanley, John, of Dertemouth 0
4477916 2193761 2193761 plaintiff Hanley John   639423 639423 Hanley, John, of Dertemouth, 0
4477932 2193766 2193766 defendant Fere Richard   639423 639423 Fere, Richard, of Dertemouth 0
4480195 2194465 2194465 defendant Lenna Thomas   639423 639423 Lenna, Thomas, of Dertemouth 0
4482879 2195348 2195348 plaintiff Mountford John   639423 639423 Mountford, John, of Dertemouth 0
4499357 2200449 2200449 plaintiff Hanley or Hauley John   639423 639423 Hanley or Hauley, John, of Dertemouth 0
4547851 2215265 2215265 defendant Baker John   639423 639423 Baker, John, of Dertemouth 0
4581069 2225560 2225560 defendant Mountford John   639423 639423 Mountford, John, of Dertemouth 0
4604552 2232590 2232590 defendant Foxley John   639423 639423 Foxley, John, of Dertemouth 0
4611751 2234738 2234738 defendant Worthy Richard butcher 639423 639423 Worthy, Richard, of Dertemouth, butcher 4
4620490 2237389 2237389 defendant Hayward William   639423 639423 Hayward, William, of Dertemouth 0
4620496 2237390 2237390 defendant Hayward William   639423 639423 Hayward, William, of Dertemouth 0
4651548 2246487 2246487 defendant Webber John   639423 639423 Webber, John, of Dertemouth, bailiff 6
4656424 2247902 2247902 defendant Hille Thomas mariner 639423 639423 Hille, Thomas, of Dertemouth, mariner 0
4656426 2247903 2247903 defendant Tyler Robert shipman 639423 639423 Tyler, Robert, of Dertemouth, shipman 0
4661925 2249576 2249576 defendant Arnold Edmund merchant 639423 639423 Arnold, Edmund, of Dertemouth, merchant 0
4662457 2249731 2249731 defendant Moulysshe John merchant 639423 639423 Moulysshe, John, of Dertemouth, merchant 0
4662458 2249731 2249731 defendant Benemore Thomas shoemaker 639423 639423 Benemore, Thomas, of Dertemouth, shoemaker 1
4662459 2249731 2249731 defendant Hoker John hooker 639423 639423 Hoker, John, of Dertemouth, hooker 2
4662460 2249731 2249731 defendant Andrewe Simon hooper 639423 639423 Andrewe, Simon, of Dertemouth, hooper 3
4662461 2249731 2249731 defendant Horetop Richard helyer or roofer 639423 639423 Horetop, Richard, of Dertemouth, helyer or roofer 4
4662462 2249731 2249731 defendant Shether William smith 639423 639423 Shether, William, of Dertemouth, smith 5
4662465 2249733 2249733 plaintiff Foxley John   639423 639423 Foxley, John, of Dertemouth 0
4662466 2249733 2249733 defendant London Richard merchant 639423 639423 London, Richard, of Dertemouth, merchant 0
4664367 2250336 2250336 defendant Tyler Robert shipman 639423 639423 Tyler, Robert, of Dertemouth, shipman 0
4664368 2250337 2250337 plaintiff Hanley or Hauley John   639423 639423 Hanley or Hauley, John, of Dertemouth 0
4673099 2257229 2257229 defendant Foxlegh John merchant 639423 639423 Foxlegh, John, of Dertemouth, merchant 0
4674198 2257538 2257538 defendant Barbour William barber 639423 639423 Barbour, William, of Dertemouth, barber 0
4674199 2257538 2257538 defendant Wynard Richard husbandman 639423 639423 Wynard, Richard, of Dertemouth, husbandman 1
4675516 2257954 2257954 defendant Barbour William barber 639423 639423 Barbour, William, of Dertemouth, barber 0
4675685 2258006 2258006 plaintiff Foxley John   639423 639423 Foxley, John, of Dertemouth 0
4675687 2258006 2258006 defendant Andrewe John husbandman 639423 639423 Andrewe, John, of Dertemouth, husbandman 0
4676264 2258188 2258188 defendant Piper David shipman 639423 639423 Piper, David, of Dertemouth, shipman 0
4677348 2258535 2258535 defendant Cokke John skinner 639423 639423 Cokke, John, of Dertemouth, skinner 1
4677349 2258535 2258535 defendant cokke Mathew skinner 639423 639423 cokke, Mathew, of Dertemouth, skinner 2
4679135 2259084 2259084 plaintiff Jakeman Gervase merchant 639423 639423 Jakeman, Gervase, of Dertemouth, merchant 0
4679137 2259084 2259084 defendant Hoker John homer 639423 639423 Hoker, John, of Dertemouth, homer 1
4680555 2259531 2259531 plaintiff London Richard   639423 639423 London, Richard, of Dertemouth, on his own account 0
4680556 2259531 2259531 defendant Foxley John merchant 639423 639423 Foxley, John, of Dertemouth, merchant 0
4682190 2260052 2260052 defendant Corp John (legal representative) 639423 639423 Corp, John, of Dertemouth, executor of 0
4682191 2260052 2260052 defendant Cotemore Thomas merchant 639423 639423 Cotemore, Thomas, of Dertemouth, merchant 1
4684620 2260788 2260788 defendant Bolt Robert husbandman 639423 639423 Bolt, Robert, of Dertemouth, husbandman 1
4690265 2262510 2262510 defendant Codmore Thomas merchant 639423 639423 Codmore, Thomas, of Dertemouth, merchant 1
4690633 2262626 2262626 defendant Foxley John merchant 639423 639423 Foxley, John, of Dertemouth, merchant 0
4690634 2262626 2262626 defendant Lancastre Joan widow & formerly wife of John Lancastre 639423 639423 Lancastre, Joan, of Dertemouth, widow & formerly wife of John Lancastre 1
4741424 2277986 2277986 defendant Toteygh John mariner 639423 639423 Toteygh, John, of Dertemouth, mariner 0
4743446 2278613 2278613 defendant Clerk William gent 639423 639423 Clerk, William, of Dertemouth, gent 0
4743447 2278613 2278613 defendant Staunford Robert merchant 639423 639423 Staunford, Robert, of Dertemouth, merchant 1
4745109 2279076 2279076 defendant Martyn Peter mariner 639423 639423 Martyn, Peter, of Dertemouth, mariner 1
4753855 2281584 2281584 defendant Hylle Thomas   639423 639423 Hylle, Thomas, of Dertemouth 0
4780271 2289831 2289831 defendant Colman John mariner 639423 639423 Colman, John, of Dertemouth, mariner 0
4780272 2289831 2289831 defendant Warrok William shipman 639423 639423 Warrok, William, of Dertemouth, shipman 1
4780273 2289831 2289831 defendant Hille Thomas husbandman 639423 639423 Hille, Thomas, of Dertemouth, husbandman 2
4781107 2290099 2290099 defendant Byteley Elias tailor 639423 639423 Byteley, Elias, of Dertemouth, tailor 0
4785607 2291524 2291524 plaintiff Fego Robert   639423 639423 Fego, Robert, of Dertemouth 0
4785958 2291646 2291646 defendant Melhewysshe Richard gent 639423 639423 Melhewysshe, Richard, of Dertemouth, gent 0
4786143 2291705 2291705 defendant Goldsmyth Henry goldsmith 639423 639423 Goldsmyth, Henry, of Dertemouth, goldsmith 0
4786144 2291705 2291705 defendant Wodman John merchant 639423 639423 Wodman, John, of Dertemouth, merchant 1
4786145 2291705 2291705 defendant Hunte William tailor 639423 639423 Hunte, William, of Dertemouth, tailor 2
4788882 2292575 2292575 defendant Paldirsak Robert sherman 639423 639423 Paldirsak, Robert, of Dertemouth, sherman 0
4792511 2293746 2293746 defendant Codmour Eleanor widow 639423 639423 Codmour, Eleanor, of Dertemouth, widow 1
4792651 2293791 2293791 defendant Vele John chaplain 639423 639423 Vele, John, of Dertemouth, chaplain 1
4797115 2295266 2295266 defendant Langmede John butcher 639423 639423 Langmede, John, of Dertemouth, butcher 0
4800794 2296437 2296437 defendant Straunge William gent 639423 639423 Straunge, William, of Dertemouth, gent 0
4800967 2296492 2296492 defendant Redeclyf John clerk 639423 639423 Redeclyf, John, of Dertemouth, clerk 4
4804632 2297642 2297642 defendant Leyne Richard tailor 639423 639423 Leyne, Richard, of Dertemouth, tailor 1
4822548 2303126 2303126 defendant Haweley John esq 639423 639423 Haweley, John, of Dertemouth, esq 0
4823079 2303302 2303302 defendant Clerke William gent 639423 639423 Clerke, William, of Dertemouth, gent 0
4825690 2304077 2304077 defendant Hawley John esq 639423 639423 Hawley, John, of Dertemouth, esq 0
4855902 2313219 2313219 defendant Yon Hugh gent 639423 639423 Yon, Hugh, of Dertemouth, gent 0
4856315 2313349 2313349 defendant Porte John merchant 639423 639423 Porte, John, of Dertemouth, merchant 0
4871346 2318006 2318006 defendant Daberney John husbandman 639423 639423 Daberney, John, of Dertemouth, husbandman 0
4872693 2318411 2318411 defendant Botrygan John merchant 639423 639423 Botrygan, John, of Dertemouth, merchant 0
4873829 2318754 2318754 defendant Hawley John esq 639423 639423 Hawley, John, of Dertemouth, esq 0
4873830 2318754 2318754 defendant Warrok William shipman 639423 639423 Warrok, William, of Dertemouth, shipman 1
4880403 2320778 2320778 defendant Baynecote John merchant 639423 639423 Baynecote, John, of Dertemouth, merchant 0
4880405 2320779 2320779 defendant Gayncote John merchant 639423 639423 Gayncote, John, of Dertemouth, merchant 0
4880407 2320780 2320780 defendant Gaynecote John merchant 639423 639423 Gaynecote, John, of Dertemouth, merchant 0
4881407 2321084 2321084 defendant Gaynecote John merchant 639423 639423 Gaynecote, John, of Dertemouth, merchant 0
4882897 2321568 2321568 defendant Yon or You Hugh merchant 639423 639423 Yon or You, Hugh, of Dertemouth, merchant 0
4887507 2322931 2322931 defendant Colman John mariner 639423 639423 Colman, John, of Dertemouth, mariner 0
4887544 2322942 2322942 defendant Yon Hugh gent 639423 639423 Yon, Hugh, of Dertemouth, gent 0
4888008 2323056 2323056 defendant Coleton John   639423 639423 Coleton, John, of Dertemouth 2
4897702 2325948 2325948 defendant Langmede John butcher 639423 639423 Langmede, John, of Dertemouth, butcher 0
4897754 2325965 2325965 defendant Baron William merchant 639423 639423 Baron, William, of Dertemouth, merchant 0
4898254 2326115 2326115 defendant Warrok William mariner 639423 639423 Warrok, William, of Dertemouth, mariner 1
4900903 2326911 2326911 defendant Gayncote John merchant 639423 639423 Gayncote, John, of Dertemouth, merchant 0
4902020 2327237 2327237 defendant Gayncote John merchant 639423 639423 Gayncote, John, of Dertemouth, merchant 0
4911550 2330115 2330115 plaintiff Broun Thomas   639423 639423 Broun, Thomas, of Dertemouth 0
4914057 2330907 2330907 plaintiff Yon Hugh merchant 639423 639423 Yon, Hugh, of Dertemouth, merchant 1

Next page

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