names

41 rows where place_id = 596276

✎ 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
3623971 1875028 1875028 defendant Edwardis Edward husbandman 596276 596276 Edwardis, Edward, of Haydon, husbandman 0
3638773 1906947 1906947 defendant Tayllour George butcher 596276 596276 Tayllour, George, of Haydon, butcher 0
3726680 1934607 1934607 defendant Smythe Thomas husbandman 596276 596276 Smythe, Thomas, of Haydon, husbandman 0
3726681 1934607 1934607 defendant Helbran John husbandman 596276 596276 Helbran, John, of Haydon, husbandman 1
3841801 1971018 1971018 defendant Whelperdalle Robert husbandman 596276 596276 Whelperdalle, Robert, of Haydon, husbandman 3
3991470 2021702 2021702 plaintiff Brese Gregory singleman 596276 596276 Brese, Gregory, of Haydon, singleman 0
4015311 2030171 2030171 defendant Bett John gent 596276 596276 Bett, John, of Haydon, gent 0
4033340 2036577 2036577 defendant Hixe Alice widow 596276 596276 Hixe, Alice, of Haydon, widow 0
4052123 2043180 2043180 defendant Garrett John husbandman 596276 596276 Garrett, John, of Haydon, husbandman 8
4052136 2043181 2043181 defendant Garrett John husbandman 596276 596276 Garrett, John, of Haydon, husbandman 9
4149635 2077997 2077997 defendant Baly Robert laborer 596276 596276 Baly, Robert, of Haydon, laborer 0
4199346 2095324 2095324 defendant Horder John clerk 596276 596276 Horder, John, of Haydon, clerk 3
4201415 2096042 2096042 defendant Amys Robert blacksmith 596276 596276 Amys, Robert, of Haydon, blacksmith 2
4226186 2104631 2104631 defendant Harrys Alice widow 596276 596276 Harrys, Alice, of Haydon, or of Boddington, widow 1
4261314 2116750 2116750 defendant Dynne William gent 596276 596276 Dynne, William, of Haydon, gent 2
4359902 2150706 2150706 defendant Barker Uriah (legal representative) 596276 596276 Barker, Uriah, of Haydon, gent, executor of 0
4382269 2158768 2158768 defendant Holwaye or Hollawaye Thomas yeoman 596276 596276 Holwaye or Hollawaye, Thomas, of Haydon, husbandman, or of Sherborne, yeoman 0
4383229 2159108 2159108 defendant Holwaye Thomas husbandman 596276 596276 Holwaye, Thomas, of Haydon, husbandman 4
4396755 2163483 2163483 defendant Graye James   596276 596276 Graye, James, of Haydon, wool comber 0
4449308 2184732 2184732 defendant Boteler John   596276 596276 together with Boteler, John, of Haydon 1
4485945 2196309 2196309 defendant Botellere John   596276 596276 Botellere, John, of Haydon 0
4494419 2198952 2198952 plaintiff Boteler John   596276 596276 Boteler, John, of Haydon, on his own account 0
4511790 2204133 2204133 defendant Benet John (legal representative) 596276 596276 Benet, John, of Haydon, parson, executor of 0
4534353 2211011 2211011 defendant Botyller John   596276 596276 Botyller, John, of Haydon 0
4813192 2300240 2300240 defendant Coke Richard haulier 596276 596276 Coke, Richard, of Haydon, haulier 0
4861472 2314958 2314958 defendant Acurman Robert ploughman 596276 596276 Acurman, Robert, of Haydon, ploughman 3
4934661 2337232 2337232 defendant Spaynell Walter wheeler 596276 596276 Spaynell, Walter, of Haydon, wheeler 0
4994250 2355155 2355155 defendant Burford Thomas husbandman 596276 596276 Burford, Thomas, of Haydon, husbandman 2
4995610 2355525 2355525 defendant Eyre John husbandman 596276 596276 Eyre, John, of Haydon, husbandman 1
5022398 2363450 2363450 defendant Hichman John, junior clerk 596276 596276 Hichman, John, junior, of Haydon, clerk 0
5022399 2363450 2363450 defendant Hichman John, senior husbandman 596276 596276 Hichman, John, senior, of Haydon, husbandman 1
5058977 2374247 2374247 defendant Horner Thomas gent 596276 596276 Horner, Thomas, of Haydon, gent 4
5133994 2396439 2396439 plaintiff Kymbell Thomas husbandman 596276 596276 Kymbell, Thomas, of Haydon, husbandman 0
5134801 2396680 2396680 defendant Tynker Agnes   596276 596276 Tynker, Agnes, of Haydon, 3
5171177 2407292 2407292 plaintiff Kymbell Thomas husbandman 596276 596276 Kymbell, Thomas, of Haydon, husbandman 0
5171180 2407293 2407293 plaintiff Kymbell Thomas husbandman 596276 596276 Kymbell, Thomas, of Haydon, husbandman 0
5213123 2419571 2419571 defendant Chever Roger barker 596276 596276 Chever, Roger, of Haydon, barker 0
5278879 2438933 2438933 defendant Aubryght Robert yeoman 596276 596276 Aubryght, Robert, of Haydon, yeoman 0
5314495 2449365 2449365 plaintiff Bynne John   596276 596276 Bynne, John, of Haydon 0
5388175 2471671 2471671 defendant Knyller Robert husbandman 596276 596276 Knyller, Robert, of Haydon, husbandman 0
5531840 2514503 2514503 defendant Edwardes Edward husbandman 596276 596276 Edwardes, Edward, of Haydon, 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);