names

51 rows where place_id = 599252

✎ 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
3635948 1906037 1906037 defendant Haddon Richard husbandman 599252 599252 Haddon, Richard, of Myddelton, husbandman 2
3711088 1929779 1929779 defendant Buttys Elizabeth gent 599252 599252 Buttys, Elizabeth, of Myddelton, widow of Buttys, John, of Myddelton, gent 0
3712471 1930218 1930218 defendant Nelson Richard husbandman 599252 599252 Nelson, Richard, of Myddelton, husbandman 0
3755502 1943676 1943676 plaintiff Woodward Thomas   599252 599252 Woodward, Thomas, of Myddelton 0
3760153 1945172 1945172 defendant Becke Robert clerk 599252 599252 Becke, Robert, of Myddelton, clerk 1
3824449 1965517 1965517 defendant Appowell Robert tailor 599252 599252 Appowell, Robert, of Myddelton, tailor 2
3831229 1967654 1967654 defendant Benet Thomas miner 599252 599252 Benet, Thomas, of Myddelton, miner 5
3843308 1971439 1971439 defendant Bruer John husbandman 599252 599252 Bruer, John, of Myddelton, husbandman 1
3843310 1971439 1971439 defendant Dalby Stephen husbandman 599252 599252 Dalby, Stephen, of Myddelton, husbandman 3
3901129 1990602 1990602 defendant Assheton Richard   599252 599252 Assheton, Richard, of Myddelton, knight 0
3907883 1992925 1992925 defendant Cawse Richard husbandman 599252 599252 Cawse, Richard, of Myddelton, husbandman 1
3909127 1993351 1993351 defendant Chapman Oliver smith 599252 599252 Chapman, Oliver, of Myddelton, smith 0
3919899 1996988 1996988 defendant Lynley John husbandman 599252 599252 Lynley, John, of Myddelton, husbandman 0
3928030 1999711 1999711 plaintiff Basterd Francis gent 599252 599252 Basterd, Francis, of Myddelton, gent 0
3935125 2002058 2002058 defendant Tyler Richard husbandman 599252 599252 Tyler, Richard, of Myddelton, husbandman 0
3942991 2004663 2004663 defendant Hunt John husbandman 599252 599252 Hunt, John, of Myddelton, husbandman 0
3942992 2004663 2004663 defendant Woode Richard husbandman 599252 599252 Woode, Richard, of Myddelton, husbandman 1
3943555 2004863 2004863 defendant Charnell Agnes widow 599252 599252 Charnell, Agnes, of Myddelton, widow 3
3947995 2006363 2006363 plaintiff Cottyngham John (legal representative) 599252 599252 Cottyngham, John, of Myddelton, yeoman, executors of 0
3965311 2012484 2012484 plaintiff Bartlett Hugh yeoman 599252 599252 Bartlett, Hugh, of Myddelton, yeoman 0
3965391 2012510 2012510 defendant Tompson Richard husbandman 599252 599252 Tompson, Richard, of Myddelton, husbandman 4
3971937 2014743 2014743 defendant Wryght alias Malster Edward yeoman 599252 599252 Wryght alias Malster, Edward, of Myddelton, yeoman 0
3989735 2021073 2021073 defendant Coke John yeoman 599252 599252 Coke, John, of Myddelton, yeoman 2
3997860 2023993 2023993 defendant Sootson William husbandman 599252 599252 Sootson, William, of Myddelton, husbandman 0
3998952 2024383 2024383 defendant Norres Robert husbandman 599252 599252 Norres, Robert, of Myddelton, husbandman 2
4007343 2027408 2027408 defendant Turner Richard yeoman 599252 599252 Turner, Richard, of Myddelton, yeoman 1
4028386 2034805 2034805 plaintiff Coocke John yeoman 599252 599252 Coocke, John, of Myddelton, yeoman 0
4033685 2036696 2036696 defendant Turnor Richard yeoman 599252 599252 Turnor, Richard, of Myddelton, yeoman 2
4036827 2037854 2037854 defendant Leigh Dorothy widow 599252 599252 Leigh, Dorothy, of Myddelton, widow 7
4039521 2038755 2038755 defendant Fyrmage John yeoman 599252 599252 Fyrmage, John, of Myddelton, yeoman 0
4044574 2040511 2040511 defendant Wright William thatcher 599252 599252 Wright, William, of Myddelton, thatcher 0
4084830 2054849 2054849 defendant Gryffyn John husbandman 599252 599252 Gryffyn, John, of Myddelton, husbandman 1
4219318 2102252 2102252 defendant Purefaye Arthur gent 599252 599252 Purefaye, Arthur, of Myddelton, gent 1
4566465 2221080 2221080 defendant Wille Roger   599252 599252 Wille, Roger, of Myddelton, Exeter diocese, vicar 0
4594054 2229401 2229401 defendant Willyot John   599252 599252 Willyot, John, of Myddelton 7
4657283 2248170 2248170 plaintiff Clerk William   599252 599252 Clerk, William, of Myddelton 0
4686764 2261472 2261472 defendant Rolegh William skinner 599252 599252 Rolegh, William, of Myddelton, skinner 0
4769384 2286397 2286397 defendant Kyrk John husbandman 599252 599252 Kyrk, John, of Myddelton, husbandman 0
4788767 2292544 2292544 defendant Gold John gent 599252 599252 Gold, John, of Myddelton, gent 0
4964215 2346199 2346199 defendant Sawyer John laborer 599252 599252 Sawyer, John, of Myddelton, laborer 0
4985680 2352630 2352630 defendant Hervy John laborer 599252 599252 Hervy, John, of Myddelton, laborer 4
5021902 2363299 2363299 defendant Byll John shipman 599252 599252 Byll, John, of Myddelton, shipman 0
5034498 2366950 2366950 defendant Herward John husbandman 599252 599252 Herward, John, of Myddelton, husbandman 0
5139517 2398044 2398044 defendant Castell John laborer 599252 599252 Castell, John, of Myddelton, junior, laborer 1
5231985 2424924 2424924 defendant Carpenter John skinner 599252 599252 Carpenter, John, of Myddelton, skinner 1
5240876 2427537 2427537 defendant Bryght William fuller 599252 599252 Bryght, William, of Myddelton, fuller 0
5240877 2427537 2427537 defendant Ball William weaver 599252 599252 Ball, William, of Myddelton, weaver 1
5240878 2427537 2427537 defendant Croyse Robert husbandman 599252 599252 Croyse, Robert, of Myddelton, husbandman 2
5354719 2461556 2461556 defendant Chapman Agnes widow 599252 599252 Chapman, Agnes, of Myddelton, widow 0
5354720 2461556 2461556 defendant Chapman William gent 599252 599252 Chapman, William, of Myddelton, gent 1
5568569 2525359 2525359 defendant Pope John mercer 599252 599252 Pope, John, of Myddelton, mercer 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);