names

177 rows where place_id = 595423

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620439 1873972 1873972 defendant Proudefelowe Richard yeoman 595423 595423 Proudefelowe, Richard, of Skelton, yeoman 7
3633596 1905320 1905320 defendant Taylloure Hugh smith 595423 595423 Taylloure, Hugh, of Skelton, smith 1
3633597 1905320 1905320 defendant Gyll John husbandman 595423 595423 Gyll, John, of Skelton, husbandman 2
3761181 1945500 1945500 defendant Milner Richard husbandman 595423 595423 Milner, Richard, of Skelton, husbandman 0
3761183 1945501 1945501 defendant Lamson Thomas husbandman 595423 595423 Lamson, Thomas, of Skelton, husbandman 0
3809050 1960712 1960712 defendant Harryson William gent 595423 595423 Harryson, William, of Skelton, gent 0
3826247 1966056 1966056 defendant Williamson Peter husbandman 595423 595423 Williamson, Peter, of Skelton, husbandman 2
3833813 1968507 1968507 defendant Levell Philip gent 595423 595423 Levell, Philip, of Skelton, gent 0
3848032 1972958 1972958 defendant Sothake Lancelot clerk 595423 595423 Sothake, Lancelot, of Skelton, clerk 0
3848034 1972958 1972958 defendant Tailer George husbandman 595423 595423 Tailer, George, of Skelton, husbandman 2
3856028 1975510 1975510 defendant Pole Robert husbandman 595423 595423 Pole, Robert, of Skelton, husbandman 0
3908900 1993269 1993269 defendant Lambart William yeoman 595423 595423 Lambart, William, of Skelton, yeoman 7
3937022 2002714 2002714 defendant Smyth Thomas (legal representative) 595423 595423 Smyth, Thomas, of Skelton, yeoman, administrator of 0
4100953 2060657 2060657 defendant Whelehouse Thomas husbandman 595423 595423 Whelehouse, Thomas, of Skelton, husbandman 1
4112157 2064606 2064606 defendant Skelton Peter gent 595423 595423 Skelton, Peter, of Skelton, gent 1
4113661 2065169 2065169 defendant Harryson Cuthbert gent 595423 595423 Harryson, Cuthbert, of Skelton, Cumber, gent 0
4221190 2102911 2102911 defendant Logan Thomas yeoman 595423 595423 Logan, Thomas, of Skelton, yeoman 0
4224490 2104047 2104047 defendant Beasley Edward gent 595423 595423 Beasley, Edward, of Skelton, gent 0
4225509 2104386 2104386 defendant Camisse Lawrence laborer 595423 595423 Camisse, Lawrence, of Skelton, laborer 0
4225510 2104386 2104386 defendant Rodes alias Bernerde Thomas laborer 595423 595423 Rodes alias Bernerde, Thomas, of Skelton, laborer 1
4242274 2110410 2110410 defendant Leighe or Lee Gilbert gent 595423 595423 Leighe or Lee, Gilbert, of Skelton, gent 1
4262877 2117252 2117252 defendant Buckton John yeoman 595423 595423 Buckton, John, of Skelton, yeoman 1
4262879 2117252 2117252 defendant Buckton George yeoman 595423 595423 Buckton, George, of Skelton, yeoman 3
4310087 2133686 2133686 defendant Willson Ralph smith 595423 595423 Willson, Ralph, of Skelton, smith 0
4310088 2133686 2133686 defendant Stony or Stong John husbandman 595423 595423 Stony or Stong, John, of Skelton, husbandman 1
4310090 2133686 2133686 defendant Willson Rowland husbandman 595423 595423 Willson, Rowland, of Skelton, husbandman 3
4315252 2135452 2135452 defendant Buckton Cuthbert yeoman 595423 595423 Buckton, Cuthbert, of Skelton, yeoman 0
4379268 2157665 2157665 defendant Key John yeoman 595423 595423 Key, John, of Skelton, yeoman 1
4379269 2157665 2157665 defendant Lowther Richard yeoman 595423 595423 Lowther, Richard, of Skelton, yeoman 2
4396844 2163514 2163514 defendant Simsone Reginald yeoman 595423 595423 Simsone, Reginald, of Skelton, yeoman 0
4403118 2165619 2165619 defendant Langley William clerk 595423 595423 Langley, William, of Skelton, clerk 3
4441704 2182343 2182343 defendant Feslok Henry   595423 595423 Feslok, Henry, of Skelton 9
4445946 2183677 2183677 plaintiff Lascy Thomas   595423 595423 Lascy, Thomas, of Skelton 2
4448426 2184439 2184439 plaintiff Fox John   595423 595423 Fox, John, of Skelton, parson 0
4452260 2185692 2185692 defendant Hudeson Anabel   595423 595423 Hudeson, Anabel, of Skelton, formerly wife of Thomas 0
4452261 2185692 2185692 defendant Hudeson John   595423 595423 Hudeson, John, of Skelton, son of Thomas Hudeson 1
4460817 2188445 2188445 defendant Broke Roger   595423 595423 Broke, Roger, of Skelton 0
4469230 2191045 2191045 defendant Thomson Robert   595423 595423 Thomson, Robert, of Skelton 0
4469795 2191226 2191226 defendant Faconberge Constance   595423 595423 Faconberge, Constance, of Skelton 3
4479147 2194137 2194137 defendant French John   595423 595423 French, John, of Skelton 1
4479168 2194139 2194139 defendant Nye Thomas   595423 595423 Nye, Thomas, of Skelton 8
4489360 2197391 2197391 defendant Wackynson John   595423 595423 Wackynson, John, of Skelton 0
4491258 2197954 2197954 defendant Fauncomberge Thomas   595423 595423 Fauncomberge, Thomas, of Skelton 0
4498805 2200261 2200261 plaintiff Gefson John   595423 595423 Gefson, John, of Skelton 0
4506407 2202502 2202502 defendant Richardson Thomas   595423 595423 Richardson, Thomas, of Skelton 1
4507756 2202882 2202882 defendant Lasty William   595423 595423 Lasty, William, of Skelton 6
4510253 2203693 2203693 defendant Medelham Robert de   595423 595423 Medelham, Robert de, of Skelton 0
4510254 2203693 2203693 defendant Lun Thomas de   595423 595423 Lun, Thomas de, of Skelton 1
4510255 2203693 2203693 defendant Gibson Thomas   595423 595423 Gibson, Thomas, of Skelton 2
4510256 2203693 2203693 defendant Branke John   595423 595423 Branke, John, of Skelton 3
4511646 2204091 2204091 defendant Johanson Comlynson William   595423 595423 Johanson Comlynson, William, of Skelton 1
4517916 2205982 2205982 defendant Hoke Thomas   595423 595423 Hoke, Thomas, of Skelton 1
4542360 2213500 2213500 defendant Wilys John chaplain 595423 595423 Wilys, John, of Skelton, chaplain 1
4542866 2213659 2213659 defendant Skelton William de clerk 595423 595423 Skelton, William de, of Skelton, clerk 0
4558405 2218575 2218575 plaintiff Lovell Emma   595423 595423 Lovell, Emma, of Skelton, formerly wife of Thomas 0
4563407 2220127 2220127 plaintiff Richemond John de   595423 595423 Richemond, John de, of Skelton 0
4563409 2220128 2220128 plaintiff Richemond John de   595423 595423 Richemond, John de, of Skelton 0
4572406 2222909 2222909 plaintiff Atkynson John   595423 595423 Atkynson, John, of Skelton 0
4573292 2223180 2223180 defendant Whitlok John   595423 595423 Whitlok, John, of Skelton 2
4575181 2223757 2223757 defendant Maistirson John   595423 595423 Maistirson, John, of Skelton, son of Thomas 2
4578568 2224787 2224787 defendant Jestewere William   595423 595423 Jestewere, William, of Skelton 0
4580292 2225317 2225317 defendant Mundevyll Thomas   595423 595423 Mundevyll, Thomas, of Skelton 0
4580293 2225317 2225317 defendant Osmundthorp John   595423 595423 Osmundthorp, John, of Skelton 1
4582094 2225837 2225837 defendant Jonson William   595423 595423 Jonson, William, of Skelton 2
4597622 2230507 2230507 defendant Personman John   595423 595423 Personman, John, of Skelton, son of Thomas 1
4602695 2232054 2232054 defendant Darby Robert   595423 595423 Darby, Robert, of Skelton 0
4602696 2232054 2232054 defendant Person John   595423 595423 Person, John, of Skelton 1
4602697 2232054 2232054 defendant Mulloke John   595423 595423 Mulloke, John, of Skelton 2
4602698 2232054 2232054 defendant Pykkewhele Hugh   595423 595423 Pykkewhele, Hugh, of Skelton 3
4602705 2232056 2232056 defendant Pierson John   595423 595423 Pierson, John, of Skelton 0
4602706 2232056 2232056 defendant Mullok John   595423 595423 Mullok, John, of Skelton 1
4606682 2233201 2233201 defendant Whitlok John   595423 595423 Whitlok, John, of Skelton 3
4609614 2234104 2234104 defendant Brigg Henry   595423 595423 Brigg, Henry, of Skelton 1
4619226 2237010 2237010 defendant Robynson Lewis   595423 595423 Robynson, Lewis, of Skelton 0
4619227 2237010 2237010 defendant Symson Robert   595423 595423 Symson, Robert, of Skelton 1
4619228 2237010 2237010 defendant Thomson William   595423 595423 Thomson, William, of Skelton 2
4619229 2237010 2237010 defendant Benson William   595423 595423 Benson, William, of Skelton 3
4627305 2239484 2239484 defendant Mauby John   595423 595423 Mauby John, of Skelton 0
4636224 2242163 2242163 defendant Daweson William   595423 595423 Daweson, William, of Skelton 0
4636662 2242293 2242293 defendant Richardson Richard   595423 595423 Richardson, Richard, of Skelton 4
4639101 2242956 2242956 defendant Man William   595423 595423 Man, William, of Skelton 0
4639102 2242956 2242956 defendant Bakere Thomas   595423 595423 Bakere, Thomas, of Skelton 1
4639103 2242956 2242956 defendant Webster John   595423 595423 Webster, John, of Skelton 2
4639104 2242956 2242956 defendant Synge William   595423 595423 Synge, William, of Skelton 3
4639106 2242956 2242956 defendant Mason William   595423 595423 Mason, William, of Skelton 5
4639107 2242956 2242956 defendant Gibson Roger   595423 595423 Gibson, Roger, of Skelton 6
4639108 2242956 2242956 defendant Derby Richard   595423 595423 Derby, Richard, of Skelton 7
4639109 2242956 2242956 defendant Broughton William   595423 595423 Broughton, William, of Skelton 8
4640785 2243406 2243406 defendant Henryson Robert   595423 595423 Henryson, Robert, of Skelton 2
4648449 2245593 2245593 defendant Huton William de   595423 595423 Huton, William de, of Skelton 2
4648451 2245593 2245593 defendant Ledale William de   595423 595423 Ledale, William de, of Skelton 4
4648452 2245593 2245593 defendant Jonson William   595423 595423 Jonson, William, of Skelton 5
4651463 2246461 2246461 defendant Smythson William yeoman 595423 595423 Smythson, William, of Skelton, yeoman 3
4659520 2248830 2248830 defendant Milner John yeoman 595423 595423 Milner, John, of Skelton, yeoman 6
4659834 2248927 2248927 defendant de Alanby Robert husbandman 595423 595423 de Alanby, Robert, of Skelton, husbandman 0
4659836 2248927 2248927 defendant Olyvaunt Christian widow 595423 595423 Olyvaunt, Christian, of Skelton, widow 2
4665008 2250536 2250536 defendant Gefson Thomas yeoman 595423 595423 Gefson, Thomas, of Skelton, yeoman 2
4666827 2255350 2255350 defendant Loweson John, junior yeoman 595423 595423 Loweson, John, junior, of Skelton, yeoman 2
4666829 2255350 2255350 defendant Tomson John yeoman 595423 595423 Tomson, John, of Skelton, yeoman 4
4679043 2259054 2259054 defendant Arlossh Thomas de yeoman 595423 595423 Arlossh, Thomas de, of Skelton, yeoman 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);