names

45 rows where place_id = 598896

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634470 1905581 1905581 defendant Holley Thomas husbandman 598896 598896 Holley, Thomas, of Caunton, husbandman 0
3637442 1906518 1906518 defendant Howeley or Holveley Thomas husbandman 598896 598896 Howeley or Holveley, Thomas, of Caunton, husbandman 0
3637444 1906518 1906518 defendant Kyngeston Thomas husbandman 598896 598896 Kyngeston, Thomas, of Caunton, husbandman 2
3711079 1929776 1929776 defendant Bartram Richard husbandman 598896 598896 Bartram, Richard, of Caunton, husbandman 1
3712165 1930122 1930122 defendant Abbott Richard clerk 598896 598896 Abbott, Richard, of Caunton, clerk 0
4066368 2048265 2048265 defendant Tayler Robert husbandman 598896 598896 Tayler, Robert, of Caunton, husbandman 0
4362295 2151566 2151566 defendant Seyton William blacksmith 598896 598896 Seyton, William, of Caunton, blacksmith 0
4377081 2156877 2156877 defendant Chauntry Thomas yeoman 598896 598896 Chauntry, Thomas, of Caunton, yeoman 0
4647752 2245403 2245403 plaintiff Smyth Richard   598896 598896 Smyth, Richard, of Caunton 0
4648424 2245586 2245586 defendant Waron William   598896 598896 Waron, William, of Caunton 0
4671298 2256674 2256674 defendant Dyke William   598896 598896 Dyke, William, of Caunton, wright 0
4772162 2287263 2287263 defendant Smyth Richard   598896 598896 Smyth, Richard, of Caunton 0
4875890 2319418 2319418 defendant Bettes John miller 598896 598896 Bettes, John, of Caunton, miller 2
4894147 2324865 2324865 defendant Blyton Robert gent 598896 598896 Blyton, Robert, of Caunton, gent 0
4943954 2340074 2340074 plaintiff Waryn William   598896 598896 Waryn, William, of Caunton 1
4957111 2344083 2344083 defendant Caldwell Thomas   598896 598896 Caldwell, Thomas, of Caunton, servant 0
4957113 2344084 2344084 defendant Caldwell Thomas   598896 598896 Caldwell, Thomas, of Caunton, servant 0
5013547 2360803 2360803 defendant Waryn William gent 598896 598896 Waryn, William, of Caunton, gent 1
5017405 2361979 2361979 defendant Waryn William gent 598896 598896 Waryn, William, of Caunton, gent 1
5027957 2365055 2365055 defendant Grayve Robert husbandman 598896 598896 Grayve, Robert, of Caunton, husbandman 0
5027958 2365055 2365055 defendant Dycons John husbandman 598896 598896 Dycons, John, of Caunton, husbandman 1
5079953 2380481 2380481 defendant Blyton Willim gent 598896 598896 Blyton, Willim, of Caunton, gent 2
5250140 2430155 2430155 plaintiff Waryn John   598896 598896 Waryn, John, of Caunton 0
5250143 2430156 2430156 plaintiff Waryn John   598896 598896 Waryn, John, of Caunton 0
5300529 2445123 2445123 defendant Legerd William husbandman 598896 598896 Legerd, William, of Caunton, husbandman 0
5323863 2452219 2452219 defendant Waren William gent 598896 598896 Waren, William, of Caunton, gent 0
5332456 2454773 2454773 defendant Couper Robert laborer 598896 598896 Couper, Robert, of Caunton, laborer 0
5363091 2464109 2464109 defendant Smyth John husbandman 598896 598896 Smyth, John, of Caunton, husbandman 0
5363092 2464109 2464109 defendant Reyner Robert laborer 598896 598896 Reyner, Robert, of Caunton, laborer 1
5363096 2464110 2464110 defendant Smyth alias Fery John husbandman 598896 598896 Smyth alias Fery, John, of Caunton, husbandman 0
5363097 2464110 2464110 defendant Unwyn Robert husbandman 598896 598896 Unwyn, Robert, of Caunton, husbandman 1
5381700 2469821 2469821 defendant Waren Agnes widow 598896 598896 Waren, Agnes, of Caunton, widow 0
5479463 2498873 2498873 defendant Kyngeston John husbandman 598896 598896 Kyngeston, John, of Caunton, husbandman 2
5479465 2498873 2498873 defendant Grave Philip husbandman 598896 598896 Grave, Philip, of Caunton, husbandman 4
5545966 2518811 2518811 defendant Waren William gent 598896 598896 Waren, William, of Caunton, gent 0
5549349 2519859 2519859 defendant Hygdon Ralph pewterer 598896 598896 Hygdon, Ralph, of Caunton, pewterer 0
5580202 2528893 2528893 defendant Hygden Ralph pewterer 598896 598896 Hygden, Ralph, of Caunton, pewterer 0
5580203 2528893 2528893 defendant Dycon John yeoman 598896 598896 Dycon, John, of Caunton, yeoman 1
5580204 2528893 2528893 defendant Hygden Thomas husbandman 598896 598896 Hygden, Thomas, of Caunton, husbandman 2
5580389 2528950 2528950 defendant Hygden Ralph pewterer 598896 598896 Hygden, Ralph, of Caunton, pewterer 0
5580390 2528950 2528950 defendant Dycon John yeoman 598896 598896 Dycon, John, of Caunton, yeoman 1
5580391 2528950 2528950 defendant Hygden Thomas husbandman 598896 598896 Hygden, Thomas, of Caunton, husbandman 2
5584416 2530189 2530189 defendant Marston William husbandman 598896 598896 Marston, William, of Caunton, husbandman 0
5598761 2534489 2534489 defendant Walker Robert husbandman 598896 598896 Walker, Robert, of Caunton, husbandman 2
5601039 2535211 2535211 defendant Smyth Henry husbandman 598896 598896 Smyth, Henry, of Caunton, husbandman 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);