names

67 rows where place_id = 594933

✎ 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
3618180 1873309 1873309 defendant Marshall William gent 594933 594933 Marshall, William, of Thresk, gent 0
3618181 1873309 1873309 defendant Honden or Houden Thomas yeoman 594933 594933 Honden or Houden, Thomas, of Thresk, yeoman 1
3845781 1972229 1972229 defendant Harryson Alexander   594933 594933 Harryson, Alexander, of Thresk, minstrel 0
3845782 1972229 1972229 defendant Harryson Alan   594933 594933 Harryson, Alan, of Thresk, minstrel 1
3856167 1975552 1975552 defendant Pert Robert yeoman 594933 594933 Pert, Robert, of Thresk, yeoman 0
3856168 1975552 1975552 defendant Fox John yeoman 594933 594933 Fox, John, of Thresk, yeoman 1
3856169 1975552 1975552 defendant Sparlyng Ralph yeoman 594933 594933 Sparlyng, Ralph, of Thresk, yeoman 2
3863902 1978101 1978101 defendant Bowman John miller 594933 594933 Bowman, John, of Thresk, miller 0
4385078 2159698 2159698 defendant Garbutt William yeoman 594933 594933 Garbutt, William, of Thresk, yeoman 0
4385079 2159698 2159698 defendant Pylus Anthony tanner 594933 594933 Pylus, Anthony, of Thresk, tanner 1
4385080 2159698 2159698 defendant Harrison John tanner 594933 594933 Harrison, John, of Thresk, tanner 2
4385107 2159706 2159706 defendant Carter William roper 594933 594933 Carter, William, of Thresk, roper 2
4385108 2159706 2159706 defendant Harryson Robert piper 594933 594933 Harryson, Robert, of Thresk, piper 3
4443653 2182979 2182979 defendant Heryngton John de   594933 594933 Heryngton, John de, of Thresk 0
4511252 2203966 2203966 defendant Chace John   594933 594933 Chace, John, of Thresk 2
4520855 2206866 2206866 plaintiff Frank Morris   594933 594933 Frank, Morris, of Thresk 0
4526201 2208485 2208485 plaintiff Knayton John   594933 594933 Knayton, John, of Thresk 0
4526782 2208654 2208654 defendant Badby William   594933 594933 Badby, William, of Thresk 1
4526783 2208654 2208654 defendant Smelt John   594933 594933 Smelt, John, of Thresk 2
4556001 2217819 2217819 plaintiff Mareschall John   594933 594933 Mareschall, John, of Thresk 1
4570344 2222298 2222298 plaintiff Worcestre John de sadler 594933 594933 Worcestre, John de, of Thresk, sadler 0
4585344 2226839 2226839 defendant Nevyll Robert   594933 594933 Nevyll, Robert, of Thresk 0
4604659 2232619 2232619 defendant Bateman Thomas   594933 594933 Bateman, Thomas, of Thresk 3
4616829 2236264 2236264 defendant Aclyff John mercer 594933 594933 Aclyff, John, of Thresk, mercer 2
4620245 2237315 2237315 plaintiff Hynde William   594933 594933 Hynde, William, of Thresk 0
4620948 2237535 2237535 plaintiff Kepwyk William tanner 594933 594933 Kepwyk, William, of Thresk, tanner 0
4631846 2240842 2240842 defendant Broun John   594933 594933 Broun, John, of Thresk 1
4646379 2245005 2245005 defendant Bell John   594933 594933 Bell, John, of Thresk 5
4650598 2246195 2246195 defendant Kilborne John dyer 594933 594933 Kilborne, John, of Thresk, dyer 2
4655927 2247733 2247733 defendant Hunt John husbandman 594933 594933 Hunt, John, of Thresk, husbandman 0
4782177 2290425 2290425 plaintiff Coke John   594933 594933 Coke, John, of Thresk 0
4793714 2294151 2294151 plaintiff Palyser John   594933 594933 Palyser, John, of Thresk 0
4794717 2294486 2294486 defendant Anderby Thomas barker 594933 594933 Anderby, Thomas, of Thresk, barker 0
4807878 2298650 2298650 plaintiff Cook John   594933 594933 Cook, John, of Thresk 0
4811800 2299802 2299802 defendant Coke John tanner 594933 594933 Coke, John, of Thresk, tanner 0
4814879 2300763 2300763 plaintiff Coke John   594933 594933 (Coke, John, of Thresk 1
4814976 2300793 2300793 defendant Lonesdale John yeoman 594933 594933 Lonesdale, John, of Thresk, yeoman 2
4815224 2300873 2300873 defendant Bourdall Richard fisher 594933 594933 Bourdall, Richard, of Thresk, fisher 4
4864972 2316020 2316020 defendant Grenewode John gent 594933 594933 Grenewode, John, of Thresk, gent 0
4865985 2316333 2316333 plaintiff Grenewode John gent 594933 594933 Grenewode, John, of Thresk, gent 0
4869615 2317458 2317458 defendant Dalton Thomas flesshewer or butcher 594933 594933 Dalton, Thomas, of Thresk, flesshewer or butcher 0
4875166 2319185 2319185 defendant Sadeler John saddler 594933 594933 Sadeler, John, of Thresk, saddler 3
4883954 2321889 2321889 defendant Palicer John yeoman 594933 594933 Palicer, John, of Thresk, yeoman 1
4895904 2325384 2325384 plaintiff Banne John   594933 594933 Banne, John, of Thresk 0
4904403 2327992 2327992 plaintiff Benne John   594933 594933 Benne, John, of Thresk 0
4947331 2341159 2341159 defendant Grenefeld John gent 594933 594933 Grenefeld, John, of Thresk, gent 0
4967317 2347168 2347168 defendant Berker alias Mareshall William tanner 594933 594933 Berker alias Mareshall, William, of Thresk, tanner 0
4972535 2348716 2348716 defendant Barbour alias Burghbrige John barber 594933 594933 Barbour alias Burghbrige, John, of Thresk, barber 4
4973242 2348932 2348932 defendant Grenefeld John gent 594933 594933 Grenefeld, John, of Thresk, gent 0
4973244 2348933 2348933 defendant Grenewode John   594933 594933 Grenewode, John, of Thresk, franklin 0
4979154 2350722 2350722 defendant Parcour Richard, junior weaver 594933 594933 Parcour, Richard, junior, of Thresk, weaver 0
4979155 2350722 2350722 defendant Seell Alice   594933 594933 together with Seell, Alice, of Thresk, widow of Seell, William 1
4979157 2350723 2350723 defendant Seell Alice   594933 594933 Seell, Alice, of Thresk, widow of Seell, William 0
5006457 2358788 2358788 defendant Watson John weaver 594933 594933 Watson, John, of Thresk, weaver 0
5049890 2371593 2371593 defendant Smolt Christopher yeoman 594933 594933 Smolt, Christopher, of Thresk, yeoman 3
5051886 2372177 2372177 defendant Mareschall William (legal representative) 594933 594933 Mareschall, William, of Thresk, esq, administrator of 0
5074841 2378979 2378979 defendant Multon William gent 594933 594933 Multon, William, of Thresk, gent 0
5093361 2384457 2384457 defendant Ploket John yeoman 594933 594933 Ploket, John, of Thresk, yeoman 2
5098436 2385970 2385970 defendant Doweson Robert butcher 594933 594933 Doweson, Robert, of Thresk, butcher 0
5098437 2385970 2385970 defendant Gobernthorn Thomas yeoman 594933 594933 Gobernthorn, Thomas, of Thresk, yeoman 1
5099491 2386290 2386290 defendant Whyppe Thomas   594933 594933 Whyppe, Thomas, of Thresk, mason 0
5107414 2388600 2388600 defendant Grenewode John gent 594933 594933 Grenewode, John, of Thresk, gent 0
5107415 2388600 2388600 defendant Grenewode William gent 594933 594933 Grenewode, William, of Thresk, gent 1
5548874 2519715 2519715 defendant Pekok Leonard barker 594933 594933 Pekok, Leonard, of Thresk, barker 0
5548875 2519715 2519715 defendant Pekok Edmund laborer 594933 594933 Pekok, Edmund, of Thresk, laborer 1
5623699 2551349 2551349 plaintiff Kepwyk William   594933 594933 Kepwyk, William, of Thresk 0
5628886 2553005 2553005 plaintiff Kepwyk William   594933 594933 Kepwyk, William, of Thresk 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);