names

253 rows where place_id = 587028

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590287 1864607 1864607 plaintiff Conyers Thomas gent 587028 587028 Conyers, Thomas, of Whitby, gent 0
3590288 1864607 1864607 defendant Laweson William laborer 587028 587028 Laweson, William, of Whitby, laborer 0
3608512 1870322 1870322 defendant Wilson John shoemaker 587028 587028 Wilson, John, of Whitby, shoemaker 1
3674294 1918005 1918005 defendant Syngilton Thomas merchant 587028 587028 Syngilton, Thomas, of Whitby, merchant 0
3691331 1923448 1923448 defendant Lussher William gent 587028 587028 Lussher, William, of Whitby, gent 0
3691333 1923449 1923449 defendant Lussher William gent 587028 587028 Lussher, William, of Whitby, gent 0
3726375 1934518 1934518 defendant Middilwode Roger gent 587028 587028 Middilwode, Roger, of Whitby, gent 3
3726381 1934519 1934519 defendant Mudilwode Roger gent 587028 587028 Mudilwode, Roger, of Whitby, gent 2
3753002 1942872 1942872 defendant Conyers George gent 587028 587028 Conyers, George, of Whitby, gent 0
3873211 1981256 1981256 plaintiff Busshell George merchant 587028 587028 Busshell, George, of Whitby, merchant 0
3932210 2001078 2001078 defendant Wylson Matthew merchant 587028 587028 Wylson, Matthew, of Whitby, merchant 1
4148473 2077594 2077594 defendant Annyngson Gregory merchant 587028 587028 Annyngson, Gregory, of Whitby, merchant 0
4264370 2117727 2117727 defendant Aslabye Francis gent 587028 587028 Aslabye, Francis, of Whitby, gent 1
4369508 2154155 2154155 defendant Cholmeley Henry esq 587028 587028 Cholmeley, Henry, of Whitby, esq 1
4374465 2155937 2155937 defendant Bolmer or Bowmer Rowland yeoman 587028 587028 Bolmer or Bowmer, Rowland, of Whitby, yeoman 0
4400683 2164817 2164817 defendant Cholmeley Henry esq 587028 587028 Cholmeley, Henry, of Whitby, esq 0
4400684 2164817 2164817 defendant Boyes George yeoman 587028 587028 Boyes, George, of Whitby, yeoman 1
4449411 2184761 2184761 defendant Payne Lictus   587028 587028 Payne, Lictus, of Whitby 0
4460807 2188441 2188441 plaintiff Smyth John   587028 587028 Smyth, John, of Whitby 0
4460809 2188442 2188442 plaintiff Smyth John   587028 587028 Smyth, John, of Whitby 0
4460811 2188443 2188443 plaintiff Smyth John   587028 587028 Smyth, John, of Whitby 0
4460814 2188444 2188444 plaintiff Smyth John   587028 587028 Smyth, John, of Whitby 0
4479371 2194199 2194199 defendant Swanne Richard shoemaker 587028 587028 Swanne, Richard, of Whitby, shoemaker 0
4487477 2196799 2196799 plaintiff Smyth John   587028 587028 Smyth, John, of Whitby 0
4487479 2196800 2196800 plaintiff Smyth John   587028 587028 Smyth, John, of Whitby, junior 0
4499170 2200386 2200386 defendant Hersand William   587028 587028 Hersand, William, of Whitby 0
4507580 2202832 2202832 defendant Ake William   587028 587028 Ake, William, of Whitby 0
4507581 2202832 2202832 defendant Ake John   587028 587028 Ake, John, of Whitby 1
4507587 2202833 2202833 defendant Loksmyth Robert   587028 587028 Loksmyth, Robert, of Whitby 4
4507598 2202837 2202837 defendant Scot Adam   587028 587028 Scot, Adam, of Whitby 0
4513214 2204557 2204557 defendant Taillour William   587028 587028 Taillour, William, of Whitby 0
4514023 2204808 2204808 defendant Cragger Robert   587028 587028 Cragger, Robert, of Whitby 0
4520286 2206688 2206688 plaintiff Ferrour Henry   587028 587028 Ferrour, Henry, of Whitby 0
4520798 2206845 2206845 defendant Cragger Robert   587028 587028 Cragger, Robert, of Whitby 1
4527361 2208837 2208837 defendant Bolton Thomas de   587028 587028 Bolton, Thomas de, of Whitby, abbot 0
4528202 2209095 2209095 plaintiff Malthouse John   587028 587028 Malthouse, John, of whitby 0
4528203 2209095 2209095 defendant Hesilden William de   587028 587028 Hesilden, William de, of Whitby 0
4528204 2209095 2209095 defendant Stathe Richard of the   587028 587028 Stathe, Richard of the, of Whitby 1
4528208 2209096 2209096 plaintiff Malthouse John   587028 587028 Malthouse, John, of Whitby 0
4528209 2209096 2209096 defendant Wilton William de   587028 587028 Wilton, William de, of Whitby 0
4528224 2209101 2209101 defendant Crosser Robert   587028 587028 Crosser, Robert, of Whitby 1
4537848 2212119 2212119 defendant Sagher John   587028 587028 Sagher, John, of Whitby 1
4574713 2223617 2223617 defendant Cragger Robert   587028 587028 Cragger, Robert, of Whitby 9
4584778 2226666 2226666 plaintiff Gower John   587028 587028 Gower, John, of Whitby 0
4602841 2232103 2232103 defendant Thomson John   587028 587028 Thomson, John, of Whitby 1
4612038 2234830 2234830 defendant Payn Richard   587028 587028 Payn, Richard, of Whitby 0
4615085 2235729 2235729 defendant Standych Thomas   587028 587028 Standych, Thomas, of Whitby 2
4621380 2237680 2237680 defendant Algere John butcher 587028 587028 Algere, John, of Whitby, butcher 3
4627921 2239661 2239661 defendant Kylwardby William   587028 587028 Kylwardby, William, of Whitby 0
4633942 2241468 2241468 defendant Ayger John butcher 587028 587028 Ayger, John, of Whitby, butcher 1
4645455 2244739 2244739 plaintiff Neusome William esq 587028 587028 Neusome, William, of Whitby, seneschal of the abbot, esq 0
4663067 2249912 2249912 defendant Blankepayne Alan Yorks, draper 587028 587028 Blankepayne Alan, of Whitby, Yorks, draper 0
4681515 2259831 2259831 defendant Walssh Robert fisher 587028 587028 Walssh, Robert, of Whitby, fisher 1
4683525 2260450 2260450 defendant Kilwardby William merchant 587028 587028 Kilwardby, William, of Whitby, merchant 0
4685723 2261124 2261124 defendant Kilwardby William   587028 587028 Kilwardby, William, of Whitby, burgess & merchant 0
4685728 2261125 2261125 defendant Kilwardby William merchant 587028 587028 Kilwardby, William, of Whitby, merchant 0
4695298 2264010 2264010 defendant Forster Robert husbandman 587028 587028 Forster, Robert, of Whitby, husbandman 1
4695299 2264010 2264010 defendant Forster John gent 587028 587028 Forster, John, of Whitby, gent 2
4701934 2266011 2266011 defendant Anger or Auger John butcher 587028 587028 Anger or Auger, John, of Whitby, butcher 0
4701935 2266011 2266011 defendant Grene Robert husbandman 587028 587028 Grene, Robert, of Whitby, husbandman 1
4711504 2268927 2268927 defendant Mayre_ William husbandman 587028 587028 Mayre_, William, of Whitby, husbandman 3
4711655 2268970 2268970 defendant Kilwardby William   587028 587028 Kilwardby, William, of Whitby, burgess & merchant 0
4717469 2270800 2270800 defendant Anger John husbandman 587028 587028 Anger, John, of Whitby, husbandman 2
4719993 2271598 2271598 defendant Alger John butcher 587028 587028 Alger, John, of Whitby, butcher 1
4720909 2271872 2271872 defendant Benyt Richard shipman 587028 587028 Benyt, Richard, of Whitby, shipman 2
4725422 2273246 2273246 defendant Warde William shipman 587028 587028 Warde, William, of Whitby, shipman 0
4731519 2275054 2275054 defendant Nedyrtoune John carver 587028 587028 Nedyrtoune, John, of Whitby, carver 0
4737427 2276820 2276820 defendant Alger John butcher 587028 587028 Alger, John, of Whitby, butcher 0
4739775 2277517 2277517 defendant Benete Richard chapman 587028 587028 Benete, Richard, of Whitby, chapman 0
4739776 2277517 2277517 defendant Awegers John chapman 587028 587028 Awegers, John, of Whitby, chapman 1
4748083 2279950 2279950 defendant Litester Adam dyer 587028 587028 Litester, Adam, of Whitby, dyer 3
4748084 2279950 2279950 defendant Greyn Walter husbandman 587028 587028 Greyn, Walter, of Whitby, husbandman 4
4748085 2279950 2279950 defendant Cornabal Robert husbandman 587028 587028 Cornabal, Robert, of Whitby, husbandman 5
4751839 2281031 2281031 plaintiff Staynton William   587028 587028 Staynton, William, of Whitby 0
4756580 2282421 2282421 defendant Maltby John shipman 587028 587028 Maltby, John, of Whitby, shipman 3
4760387 2283603 2283603 defendant At Hall John yeoman 587028 587028 At Hall, John, of Whitby, yeoman 0
4762340 2284203 2284203 defendant Lyn John de butcher 587028 587028 Lyn, John de, of whitby, butcher 1
4763429 2284549 2284549 defendant Harsande William   587028 587028 Harsande, William, of Whitby, burgess & husbandman 0
4781168 2290120 2290120 defendant Bystowe Richard dyer 587028 587028 Bystowe, Richard, of Whitby, dyer 0
4785884 2291618 2291618 defendant de Lyn John butcher 587028 587028 de Lyn, John, of Whitby, butcher 0
4786802 2291927 2291927 defendant Mareschall Thomas yeoman 587028 587028 Mareschall, Thomas, of Whitby, yeoman 0
4787128 2292039 2292039 defendant Harsande William husbandman 587028 587028 Harsande, William, of Whitby, husbandman 0
4788902 2292582 2292582 defendant Gower William husbandman 587028 587028 Gower, William, of Whitby, husbandman 1
4789964 2292936 2292936 defendant Conyers Thomas gent 587028 587028 Conyers, Thomas, of Whitby, gent 0
4809013 2298995 2298995 defendant Skelton John de   587028 587028 Skelton, John de, of Whitby, abbot of Sts Peter & Hilda abbey 0
4809318 2299088 2299088 defendant Chapman William   587028 587028 Chapman, William, of Whitby, burgess & merchant 1
4812927 2300155 2300155 defendant Anger John yeoman 587028 587028 Anger, John, of Whitby, yeoman 3
4813549 2300347 2300347 defendant Gower William gent 587028 587028 Gower, William, of Whitby, gent 0
4815985 2301092 2301092 defendant Pawe Richard butcher 587028 587028 Pawe, Richard, of Whitby, butcher 1
4815987 2301092 2301092 defendant Aldeyer John butcher 587028 587028 Aldeyer, John, of Whitby, butcher 3
4818794 2301963 2301963 defendant --man William shipman 587028 587028 --man, William, of Whitby, shipman 1
4834424 2306774 2306774 plaintiff Cowper William   587028 587028 Cowper, William, of Whitby, burgess 0
4838236 2307879 2307879 defendant Mersthall John merchant 587028 587028 Mersthall, John, of Whitby, merchant 0
4838237 2307879 2307879 defendant Wolton Thomas merchant 587028 587028 Wolton, Thomas, of Whitby, merchant 1
4838600 2307997 2307997 defendant Jakes Henry merchant 587028 587028 Jakes, Henry, of Whitby, merchant 0
4840978 2308711 2308711 defendant Lepyngton John water loader 587028 587028 Lepyngton, John, of Whitby, water loader 0
4840980 2308712 2308712 defendant Lepyngton John water carrier 587028 587028 Lepyngton, John, of Whitby, water carrier 0
4844611 2309836 2309836 defendant Husy John gent 587028 587028 Husy, John, of Whitby, gent 0
4844623 2309838 2309838 defendant Husy John gent 587028 587028 Husy, John, of Whitby, gent 0
4869678 2317482 2317482 defendant Barton Thomas yeoman 587028 587028 Barton, Thomas, of Whitby, yeoman 0

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