names

115 rows where place_id = 588481

✎ 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
3594644 1865954 1865954 defendant Senwell John   588481 588481 Senwell, John, of Appulby, mason 1
3594646 1865954 1865954 defendant Robynson Richard butcher 588481 588481 Robynson, Richard, of Appulby, butcher 3
3594647 1865954 1865954 defendant Holgyt John laborer 588481 588481 Holgyt, John, of Appulby, laborer 4
3617511 1873097 1873097 defendant Whittyngham William yeoman 588481 588481 Whittyngham, William, of Appulby, yeoman 3
3617513 1873097 1873097 defendant Blenkynsop George gent 588481 588481 Blenkynsop, George, of Appulby, gent 5
3630599 1904399 1904399 defendant Acryt Gilbert shoemaker 588481 588481 Acryt, Gilbert, of Appulby, shoemaker 1
3678399 1919298 1919298 defendant Akered Gilbert cordwainer 588481 588481 Akered, Gilbert, of Appulby, cordwainer 2
3699404 1926036 1926036 defendant Jakson John yeoman 588481 588481 Jakson, John, of Appulby, yeoman 0
3750587 1942102 1942102 defendant Hertley John clerk 588481 588481 Hertley, John, of Appulby, clerk 0
3753908 1943169 1943169 defendant Harryson Thomas yeoman 588481 588481 Harryson, Thomas, of Appulby, yeoman 3
3788443 1954186 1954186 defendant Smythe Richard barker 588481 588481 Smythe, Richard, of Appulby, barker 0
4023181 2033000 2033000 defendant More William husbandman 588481 588481 More, William, of Appulby, or of Roxby, husbandman 0
4023455 2033097 2033097 defendant Darnell Adam esq 588481 588481 Darnell, Adam, of Appulby, esq 0
4457274 2187288 2187288 defendant Barowe Thomas de   588481 588481 Barowe, Thomas de, of Appulby, mason 0
4460367 2188304 2188304 plaintiff Shiller Robert   588481 588481 Shiller, Robert, of Appulby 0
4509781 2203544 2203544 plaintiff Ayre Thomas chaplain 588481 588481 Ayre, Thomas, of Appulby, chaplain 0
4514603 2204984 2204984 defendant Fissher John   588481 588481 Fissher, John, of Appulby 7
4546914 2214968 2214968 defendant Hode John   588481 588481 Hode, John, of Appulby 0
4546916 2214968 2214968 defendant Webster William   588481 588481 Webster, William, of Appulby 2
4546919 2214969 2214969 defendant Hode John   588481 588481 Hode, John, of Appulby 0
4546921 2214969 2214969 defendant Webster William   588481 588481 Webster, William, of Appulby 2
4552078 2216602 2216602 defendant Herryson William   588481 588481 Herryson, William, of Appulby 0
4552079 2216602 2216602 defendant Baget John   588481 588481 Baget, John, of Appulby 1
4552080 2216602 2216602 defendant Coteler John   588481 588481 Coteler, John, of Appulby 2
4552082 2216602 2216602 defendant Catwyk William   588481 588481 Catwyk, William, of Appulby 4
4552083 2216602 2216602 defendant Philipson John   588481 588481 Philipson, John, of Appulby 5
4552084 2216602 2216602 defendant Chesterfeld Robert   588481 588481 Chesterfeld, Robert, of Appulby 6
4552085 2216602 2216602 defendant atte Welle John   588481 588481 atte Welle, John, of Appulby 7
4552087 2216603 2216603 defendant Herryson William   588481 588481 Herryson, William, of Appulby 0
4552088 2216603 2216603 defendant Baget John   588481 588481 Baget, John, of Appulby 1
4552089 2216603 2216603 defendant Coteler John   588481 588481 Coteler, John, of Appulby 2
4552091 2216603 2216603 defendant Catwyk William   588481 588481 Catwyk, William, of Appulby 4
4552092 2216603 2216603 defendant Philipson John   588481 588481 Philipson, John, of Appulby 5
4552093 2216603 2216603 defendant Chesterfeld Robert   588481 588481 Chesterfeld, Robert, of Appulby 6
4552094 2216603 2216603 defendant atte Welle John   588481 588481 atte Welle, John, of Appulby 7
4557477 2218274 2218274 defendant Dankyn John   588481 588481 Dankyn, John, of Appulby 1
4581371 2225639 2225639 defendant Herryson William   588481 588481 Herryson, William, of Appulby 0
4600251 2231304 2231304 defendant Baghet John   588481 588481 Baghet, John, of Appulby 0
4600252 2231304 2231304 defendant Snell John   588481 588481 Snell, John, of Appulby 1
4606820 2233241 2233241 defendant Forster John   588481 588481 Forster, John, of Appulby 1
4617610 2236515 2236515 defendant Catwyk William   588481 588481 Catwyk, William, of Appulby 2
4731909 2275161 2275161 defendant Maryng John husbandman 588481 588481 Maryng, John, of Appulby, husbandman 0
4761632 2283983 2283983 defendant Appulby John gent 588481 588481 Appulby, John, of Appulby, gent 0
4767218 2285732 2285732 defendant Thorp John chapman 588481 588481 Thorp, John, of Appulby, chapman 0
4770807 2286848 2286848 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 0
4777111 2288821 2288821 defendant Malton John   588481 588481 Malton, John, of Appulby husbandman 0
4777112 2288821 2288821 defendant Henrison William   588481 588481 Henrison, William, of Appulby husbandman 1
4777113 2288821 2288821 defendant Gengiltman Richard   588481 588481 Gengiltman, Richard, of Appulby husbandman 2
4777114 2288821 2288821 defendant Hoton John   588481 588481 Hoton, John, of Appulby husbandman 3
4812770 2300109 2300109 defendant Bortesforth John weaver 588481 588481 Bortesforth, John, of Appulby, weaver 0
4825630 2304055 2304055 defendant Apulby Thomas esq 588481 588481 Apulby, Thomas, of Appulby, esq 3
4848149 2310894 2310894 defendant Hurton Robert husbandman 588481 588481 Hurton, Robert, of Appulby, husbandman 0
4862755 2315338 2315338 defendant Duffeld William husbandman 588481 588481 Duffeld, William, of Appulby, husbandman 0
4870833 2317856 2317856 defendant Maryng John husbandman 588481 588481 Maryng, John, of Appulby, husbandman 4
4903895 2327834 2327834 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 0
4903896 2327834 2327834 defendant Henrison William husbandman 588481 588481 Henrison, William, of Appulby, husbandman 1
4903897 2327834 2327834 defendant Gentilman Richard husbandman 588481 588481 Gentilman, Richard, of Appulby, husbandman 2
4903898 2327834 2327834 defendant Hoton John husbandman 588481 588481 Hoton, John, of Appulby, husbandman 3
4908536 2329227 2329227 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 0
4908537 2329227 2329227 defendant Haryson William husbandman 588481 588481 Haryson, William, of Appulby, husbandman 1
4908538 2329227 2329227 defendant Gentylman Richard husbandman 588481 588481 Gentylman, Richard, of Appulby, husbandman 2
4908539 2329227 2329227 defendant Hoton John husbandman 588481 588481 Hoton, John, of Appulby, husbandman 3
4909888 2329615 2329615 defendant Storrour John merchant 588481 588481 Storrour, John, of Appulby, merchant 1
4912315 2330352 2330352 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 0
4912317 2330353 2330353 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 0
4926074 2334584 2334584 defendant Andrewe William laborer 588481 588481 Andrewe, William, of Appulby, laborer 0
4940518 2339059 2339059 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 0
4948710 2341579 2341579 defendant Lande or Laude William husbandman 588481 588481 Lande or Laude, William, of Appulby, husbandman 1
4956694 2343959 2343959 defendant Appulby John gent 588481 588481 Appulby, John, of Appulby, gent 0
4956695 2343959 2343959 defendant Appulby Edmund gent 588481 588481 Appulby, Edmund, of Appulby, gent 1
4956696 2343959 2343959 defendant Molde John husbandman 588481 588481 Molde, John, of Appulby, husbandman 2
4956697 2343959 2343959 defendant Molde William husbandman 588481 588481 Molde, William, of Appulby, husbandman 3
4956698 2343959 2343959 defendant Derby John laborer 588481 588481 Derby, John, of Appulby, laborer 4
4956699 2343959 2343959 defendant Derby John, junior laborer 588481 588481 Derby, John, junior, of Appulby, laborer 5
4956700 2343959 2343959 defendant Derby Richard laborer 588481 588481 Derby, Richard, of Appulby, laborer 6
4956701 2343959 2343959 defendant Taillour Robert tailor 588481 588481 Taillour, Robert, of Appulby, tailor 7
4956702 2343959 2343959 defendant Taillour John yeoman 588481 588481 Taillour, John, of Appulby, yeoman 8
4956703 2343959 2343959 defendant Dymmok John yeoman 588481 588481 Dymmok, John, of Appulby, yeoman 9
4956704 2343959 2343959 defendant Smyth John smith 588481 588481 Smyth, John, of Appulby, smith 10
4956705 2343959 2343959 defendant Machon William husbandman 588481 588481 Machon, William, of Appulby, husbandman 11
4956706 2343959 2343959 defendant Scotte John husbandman 588481 588481 Scotte, John, of Appulby, husbandman 12
4966795 2346994 2346994 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 7
4971478 2348397 2348397 defendant Gosse William husbandman 588481 588481 Gosse, William, of Appulby, husbandman 0
4976286 2349861 2349861 defendant Mold Robert husbandman 588481 588481 Mold, Robert, of Appulby, husbandman 0
4977251 2350149 2350149 defendant Taillour Robert husbandman 588481 588481 Taillour, Robert, of Appulby, husbandman 0
4977252 2350149 2350149 defendant Smyth John smith 588481 588481 Smyth, John, of Appulby, smith 1
4982148 2351578 2351578 defendant Gosse William husbandman 588481 588481 Gosse, William, of Appulby, husbandman 0
4982150 2351579 2351579 defendant Herryson William husbandman 588481 588481 Herryson, William, of Appulby, husbandman 0
4982151 2351579 2351579 defendant Curson Lambert husbandman 588481 588481 together with Curson, Lambert, of Appulby, husbandman 1
4983239 2351890 2351890 defendant Herryson William husbandman 588481 588481 Herryson, William, of Appulby, husbandman 0
4985963 2352717 2352717 defendant Belle Robert butcher 588481 588481 Belle, Robert, of Appulby, butcher 3
4997665 2356158 2356158 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 0
4997666 2356158 2356158 defendant Lange John husbandman 588481 588481 Lange, John, of Appulby, husbandman 1
5008876 2359489 2359489 defendant Malton John husbandman 588481 588481 Malton, John, of Appulby, husbandman 0
5055581 2373245 2373245 defendant Sutton John husbandman 588481 588481 Sutton, John, of Appulby, husbandman 1
5058634 2374143 2374143 defendant Waterhous John yeoman 588481 588481 Waterhous, John, of Appulby, yeoman 0
5081981 2381106 2381106 defendant Waterhous John yeoman 588481 588481 Waterhous, John, of Appulby, yeoman 0
5107311 2388567 2388567 defendant Lenche John clerk 588481 588481 Lenche, John, of Appulby, clerk 0
5107312 2388567 2388567 defendant Haket Henry weaver 588481 588481 Haket, Henry, of Appulby, weaver 1
5107313 2388567 2388567 defendant Haket John weaver 588481 588481 Haket, John, of Appulby, weaver 2

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