names

68 rows where place_id = 593974

✎ 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
3614019 1872043 1872043 defendant Phelippes John draper 593974 593974 Phelippes, John, of Dadyngton, Oxon, draper 1
3670752 1916813 1916813 plaintiff Byllyng alias Byllyngton William gent 593974 593974 Byllyng alias Byllyngton, William, of Dadyngton, Oxon, gent 0
3715630 1931177 1931177 plaintiff Byllyng William merchant of the staple 593974 593974 Byllyng, William, of Dadyngton, Oxon, merchant of the staple 0
3715632 1931178 1931178 plaintiff Byllyng William merchant of the staple 593974 593974 Byllyng, William, of Dadyngton, Oxon, merchant of the staple 0
3715636 1931179 1931179 plaintiff Byllyng William merchant of the staple 593974 593974 Byllyng, William, of Dadyngton, Oxon, merchant of the staple 0
3743393 1939807 1939807 defendant Vyrley John clerk 593974 593974 Vyrley, John, of Dadyngton, Oxon, clerk 0
3776671 1950450 1950450 plaintiff Byllyng William gent 593974 593974 Byllyng, William, of Dadyngton, Oxon, gent 0
3792995 1955668 1955668 plaintiff Billyng William merchant of the staple 593974 593974 Billyng, William, of Dadyngton, Oxon, gent, merchant of the staple 0
3794125 1956032 1956032 plaintiff Byllyng William gent 593974 593974 Byllyng, William, of Dadyngton, Oxon, gent 0
3794129 1956033 1956033 plaintiff Byllyng William gent 593974 593974 Byllyng, William, of Dadyngton, Oxon, gent 0
3794133 1956034 1956034 plaintiff Byllyng William gent 593974 593974 Byllyng, William, of Dadyngton, Oxon, gent 0
3794136 1956035 1956035 plaintiff Byllyng William merchant of the staple 593974 593974 Byllyng, William, of Dadyngton, Oxon, gent, merchant of the staple 0
3809779 1960946 1960946 plaintiff Billyng William gent 593974 593974 Billyng, William, of Dadyngton, Oxon, gent 0
3811042 1961348 1961348 plaintiff Byllyng William gent 593974 593974 Byllyng, William, of Dadyngton, Oxon, gent 0
3828661 1966843 1966843 plaintiff Cleyford Robert yeoman 593974 593974 Cleyford, Robert, of Dadyngton, Oxon, yeoman 0
4558975 2218768 2218768 defendant Seywell John   593974 593974 Seywell, John, of Dadyngton, Oxon 3
4558980 2218769 2218769 defendant Seywell John   593974 593974 Seywell, John, of Dadyngton, Oxon 3
4592818 2229087 2229087 defendant Melcheborn John (legal representative) 593974 593974 Melcheborn, John, of Dadyngton, Oxon, merchant, administratrix of 0
4694651 2263825 2263825 defendant Belyeter Oliver (legal representative) 593974 593974 Belyeter, Oliver, of Dadyngton, Oxon, executors of 0
4694652 2263825 2263825 defendant Wyrthhull William gent 593974 593974 (Wyrthhull, William, of Dadyngton, Oxon, gent 1
4722101 2272242 2272242 defendant Horncastell William chapman 593974 593974 Horncastell, William, of Dadyngton, Oxon, chapman 1
4724357 2272915 2272915 defendant Croft John chapman 593974 593974 Croft, John, of Dadyngton, Oxon, chapman 2
4832052 2306055 2306055 defendant Sir Thomas fishmonger 593974 593974 Sir, Thomas, of Dadyngton, Oxon, fishmonger 3
4857080 2313595 2313595 defendant Maynard William husbandman 593974 593974 Maynard, William, of Dadyngton, Oxon, husbandman 1
4897175 2325772 2325772 defendant Maynard William husbandman 593974 593974 Maynard, William, of Dadyngton, Oxon, husbandman 2
4908441 2329195 2329195 defendant Colles John chapman 593974 593974 Colles, John, of Dadyngton, Oxon, chapman 2
4910353 2329755 2329755 defendant Burst Thomas husbandman 593974 593974 Burst, Thomas, of Dadyngton, Oxon, husbandman 0
4912934 2330542 2330542 defendant Blount John esq 593974 593974 Blount, John, of Dadyngton, Oxon, esq 0
4916266 2331593 2331593 defendant Horncastell John chapman 593974 593974 Horncastell, John, of Dadyngton, Oxon, chapman 0
4916268 2331594 2331594 defendant Horncastell John chapman 593974 593974 Horncastell, John, of Dadyngton, Oxon, chapman 0
4918389 2332268 2332268 defendant Sirre Thomas husbandman 593974 593974 Sirre, Thomas, of Dadyngton, Oxon, husbandman 0
4928124 2335226 2335226 defendant (illegible) Richard husbandman 593974 593974 ---, Richard, of Dadyngton, Oxon, husbandman 0
4932993 2336709 2336709 defendant Somerton John gent 593974 593974 Somerton, John, of Dadyngton, Oxon, gent 0
4961503 2345403 2345403 defendant Halewelle John mercer 593974 593974 Halewelle, John, of Dadyngton, Oxon, mercer 0
4961508 2345405 2345405 defendant Halewelle John mercer 593974 593974 Halewelle, John, of Dadyngton, Oxon, mercer 0
4980532 2351117 2351117 defendant Collys John merchant 593974 593974 Collys, John, of Dadyngton, Oxon, merchant 0
5006123 2358679 2358679 defendant Rede Clement draper 593974 593974 Rede, Clement, of Dadyngton, Oxon, draper 1
5011338 2360179 2360179 defendant Teynton Richard carrier 593974 593974 Teynton, Richard, of Dadyngton, Oxon, carrier 1
5012010 2360363 2360363 defendant Yernan John esq 593974 593974 Yernan, John, of Dadyngton, Oxon, esq 0
5022873 2363601 2363601 defendant Powes John clerk 593974 593974 Powes, John, of Dadyngton, Oxon, clerk 1
5033295 2366617 2366617 defendant Byngham John butcher 593974 593974 Byngham, John, of Dadyngton, Oxon, butcher 0
5080147 2380548 2380548 defendant Halywell John chapman 593974 593974 Halywell, John, of Dadyngton, Oxon, chapman 2
5103356 2387410 2387410 defendant Burbage Robert mercer 593974 593974 Burbage, Robert, of Dadyngton, Oxon, mercer 3
5112256 2389966 2389966 defendant Beauchamp alias Blount Alice widow 593974 593974 Beauchamp alias Blount, Alice, of Dadyngton, Oxon, widow 2
5118911 2391962 2391962 defendant Fyly William husbandman 593974 593974 Fyly, William, of Dadyngton, Oxon, husbandman 0
5176270 2408748 2408748 defendant Cowle Thomas butcher 593974 593974 Cowle, Thomas, of Dadyngton, Oxon, butcher 0
5180530 2410051 2410051 defendant Hardwyke Thomas yeoman 593974 593974 Hardwyke, Thomas, of Dadyngton, Oxon, yeoman 1
5202473 2416485 2416485 defendant Hardwyke Thomas yeoman 593974 593974 Hardwyke, Thomas, of Dadyngton, Oxon, yeoman 1
5227723 2423725 2423725 defendant Clere Richard husbandman 593974 593974 Clere, Richard, of Dadyngton, Oxon, husbandman 2
5249241 2429897 2429897 defendant Cowle Thomas butcher 593974 593974 Cowle, Thomas, of Dadyngton, Oxon, butcher 1
5268721 2435969 2435969 defendant Senyer or Sevyer John chapman 593974 593974 Senyer or Sevyer, John, of Dadyngton, Oxon, chapman 0
5279177 2439009 2439009 defendant Senyer John chapman 593974 593974 Senyer, John, of Dadyngton, Oxon, chapman 0
5382934 2470187 2470187 defendant Jakman William husbandman 593974 593974 Jakman, William, of Dadyngton, Oxon, husbandman 0
5382936 2470188 2470188 defendant Pape Nicholas chapman 593974 593974 Pape, Nicholas, of Dadyngton, Oxon, chapman 0
5393792 2473283 2473283 defendant Maynard Nicholas fisher 593974 593974 Maynard, Nicholas, of Dadyngton, Oxon, fisher 0
5406987 2477060 2477060 defendant Maynard Nicholas fisher 593974 593974 Maynard, Nicholas, of Dadyngton, Oxon, fisher 0
5420177 2480953 2480953 defendant Mayne_ Nicholas fisher 593974 593974 Mayne_, Nicholas, of Dadyngton, Oxon, fisher 0
5420273 2480988 2480988 defendant Jakman William husbandman 593974 593974 Jakman, William, of Dadyngton, Oxon, husbandman 0
5420277 2480990 2480990 defendant Pape Nicholas chapman 593974 593974 Pape, Nicholas, of Dadyngton, Oxon, chapman 0
5434175 2485177 2485177 defendant Symons John chapman 593974 593974 Symons, John, of Dadyngton, Oxon, chapman 0
5449639 2489786 2489786 defendant Symon John chapman 593974 593974 Symon, John, of Dadyngton, Oxon, chapman 0
5449643 2489787 2489787 defendant Symons John chapman 593974 593974 Symons, John, of Dadyngton, Oxon, chapman 0
5496281 2503788 2503788 defendant Underwode Robert mercer 593974 593974 Underwode, Robert, of Dadyngton, Oxon, mercer 2
5519793 2511027 2511027 defendant Phelippes John draper 593974 593974 Phelippes, John, of Dadyngton, Oxon, draper 0
5528413 2513421 2513421 defendant Philipp John yeoman 593974 593974 Philipp, John, of Dadyngton, Oxon, yeoman 12
5559474 2522734 2522734 defendant Rateler Richard husbandman 593974 593974 Rateler, Richard, of Dadyngton, Oxon, husbandman 0
5624926 2551731 2551731 defendant Aleyn John draper 593974 593974 (Aleyn, John, of Dadyngton, Oxon, draper 1
5625773 2552003 2552003 defendant Milcheborne William fisher 593974 593974 Milcheborne, William, of Dadyngton, Oxon, fisher 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);