names

59 rows where place_id = 626498

✎ 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
3770456 1948440 1948440 plaintiff Skupholme William gent 626498 626498 Skupholme, William, of South Somercotes, gent 2
3837306 1969577 1969577 defendant Tathwell Simon gent 626498 626498 Tathwell, Simon, of South Somercotes, gent 0
3849102 1973316 1973316 defendant Somercotes William gent 626498 626498 Somercotes, William, of South Somercotes, gent 0
3965917 2012698 2012698 plaintiff Betneff or Betneve William yeoman 626498 626498 Betneff or Betneve, William, of South Somercotes, yeoman 0
4201280 2096002 2096002 defendant Sparke John clerk 626498 626498 Sparke, John, of South Somercotes, clerk 0
4276935 2121864 2121864 defendant Tathwell Nicholas husbandman 626498 626498 together with Tathwell, Nicholas, of South Somercotes, husbandman 1
4277866 2122187 2122187 defendant Tathwell Nicholas husbandman 626498 626498 together with Tathwell, Nicholas, of South Somercotes, husbandman 1
4277867 2122187 2122187 defendant Cocker Thomas husbandman 626498 626498 Cocker, Thomas, of South Somercotes, husbandman 2
4279244 2122671 2122671 defendant Sparke John clerk 626498 626498 Sparke, John, of South Somercotes, clerk 1
4279249 2122672 2122672 defendant Sparke John clerk 626498 626498 Sparke, John, of South Somercotes, clerk 1
4348136 2146595 2146595 defendant Crespe John husbandman 626498 626498 Crespe, John, of South Somercotes, husbandman 0
4348137 2146595 2146595 defendant Hawes or Hall John weaver 626498 626498 Hawes or Hall, John, of South Somercotes, weaver 1
4363377 2151974 2151974 defendant Cockerell Ralph husbandman 626498 626498 Cockerell, Ralph, of South Somercotes, husbandman 0
4363382 2151976 2151976 defendant Cockerell Ralph husbandman 626498 626498 Cockerell, Ralph, of South Somercotes, husbandman 0
4372795 2155347 2155347 defendant Vinter George yeoman 626498 626498 Vinter, George, of South Somercotes, yeoman 0
4372796 2155347 2155347 defendant Hall Thomas yeoman 626498 626498 Hall, Thomas, of South Somercotes, yeoman 1
4372797 2155347 2155347 defendant Manners Edmund husbandman 626498 626498 Manners, Edmund, of South Somercotes, husbandman 2
4372798 2155347 2155347 defendant Tathwell Nicholas husbandman 626498 626498 Tathwell, Nicholas, of South Somercotes, husbandman 3
4438133 2181226 2181226 defendant Jonessone William   626498 626498 Jonessone, William, of South Somercotes 0
4505261 2202176 2202176 defendant Braytoft Robert   626498 626498 Braytoft, Robert, of South Somercotes 1
4535567 2211399 2211399 defendant Braytoft Robert   626498 626498 Braytoft, Robert, of South Somercotes 0
4631302 2240683 2240683 defendant Tomson William   626498 626498 Tomson, William, of South Somercotes 0
4660234 2249035 2249035 defendant Thomson William husbandman 626498 626498 Thomson, William, of South Somercotes, husbandman 1
4660235 2249035 2249035 defendant Thomson Alan workman 626498 626498 Thomson, Alan, of South Somercotes, workman 2
4734980 2276089 2276089 defendant Elys Elizabeth   626498 626498 Elys, Elizabeth, of South Somercotes, servant 0
4835278 2307032 2307032 defendant spencer Thomas gent 626498 626498 spencer, Thomas, of South Somercotes, gent 2
4835883 2307205 2307205 defendant S_ Thomas gent 626498 626498 S_, Thomas, of South Somercotes, gent 2
4861892 2315096 2315096 defendant Soupholme Ivo gent 626498 626498 Soupholme, Ivo, of South Somercotes, gent 0
4862647 2315302 2315302 defendant Spencer Thomas gent 626498 626498 Spencer, Thomas, of South Somercotes, gent 2
4863275 2315480 2315480 defendant Spencer Thomas gent 626498 626498 Spencer, Thomas, of South Somercotes, gent 3
4864529 2315878 2315878 defendant Braytoft William yeoman 626498 626498 Braytoft, William, of South Somercotes, yeoman 0
4869509 2317430 2317430 defendant Braytoft William yeoman 626498 626498 Braytoft, William, of South Somercotes, yeoman 0
4881995 2321268 2321268 defendant Braytoft William husbandman 626498 626498 Braytoft, William, of South Somercotes, husbandman 0
4904928 2328144 2328144 defendant Thomson Alan husbandman 626498 626498 Thomson, Alan, of South Somercotes, husbandman 0
4904950 2328151 2328151 defendant Thomson William husbandman 626498 626498 Thomson, William, of South Somercotes, husbandman 1
4918059 2332163 2332163 plaintiff Grayffe Robert tanner 626498 626498 Grayffe, Robert, of South Somercotes, tanner 0
5009529 2359668 2359668 defendant Grave Robert husbandman 626498 626498 Grave, Robert, of South Somercotes, husbandman 0
5075816 2379260 2379260 defendant Almotson John Thomson husbandman 626498 626498 Almotson, John Thomson, of South Somercotes, husbandman 0
5084494 2381876 2381876 defendant Thomas John husbandman 626498 626498 Thomas, John, of South Somercotes, husbandman 3
5088087 2382893 2382893 defendant Richardson Thomas husbandman 626498 626498 Richardson, Thomas, of South Somercotes, husbandman 0
5109424 2389187 2389187 defendant Thomson John weaver 626498 626498 Thomson, John, of South Somercotes, weaver 1
5153268 2402107 2402107 defendant Basyll John husbandman 626498 626498 Basyll, John, of South Somercotes, husbandman 0
5170671 2407141 2407141 defendant Basyll John husbandman 626498 626498 Basyll, John, of South Somercotes, husbandman 0
5188468 2412344 2412344 defendant Basell john husbandman 626498 626498 Basell, john, of South Somercotes, husbandman 0
5261909 2433832 2433832 defendant Ludforth John husbandman 626498 626498 Ludforth, John, of South Somercotes, or of Skydbroke, husbandman 0
5276182 2438108 2438108 defendant Tuppleyn William husbandman 626498 626498 Tuppleyn, William, of South Somercotes, husbandman 0
5319266 2450856 2450856 defendant Thomson Robert husbandman 626498 626498 Thomson, Robert, of South Somercotes, husbandman 0
5327758 2453369 2453369 defendant Wharff William clerk 626498 626498 Wharff, William, of South Somercotes, clerk 2
5333972 2455232 2455232 defendant Spenser Thomas yeoman 626498 626498 Spenser, Thomas, of South Somercotes, yeoman 0
5333976 2455233 2455233 defendant Spynser Beatrice widow 626498 626498 Spynser, Beatrice, of South Somercotes, widow 1
5349054 2459831 2459831 defendant Spenser Thomas yeoman 626498 626498 Spenser, Thomas, of South Somercotes, yeoman 3
5377832 2468649 2468649 defendant Basyll John husbandman 626498 626498 Basyll, John, of South Somercotes, husbandman 2
5377847 2468650 2468650 defendant Basyll John husbandman 626498 626498 Basyll, John, of South Somercotes, husbandman 2
5406690 2476980 2476980 defendant Basyll John husbandman 626498 626498 Basyll, John, of South Somercotes, husbandman 4
5419861 2480854 2480854 defendant Basyll John husbandman 626498 626498 Basyll, John, of South Somercotes, husbandman 4
5438377 2486411 2486411 defendant Basyll John husbandman 626498 626498 Basyll, John, of South Somercotes, husbandman 4
5487954 2501285 2501285 defendant Taillour William chaplain 626498 626498 Taillour, William, of South Somercotes, chaplain 1
5635982 2555206 2555206 plaintiff Strubby William chaplain 626498 626498 Strubby, William, of South Somercotes, chaplain 2
5635983 2555206 2555206 defendant Thomson William husbandman 626498 626498 Thomson, William, of South Somercotes, husbandman 0

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