names

48 rows where place_id = 599297

✎ 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
3636152 1906098 1906098 defendant Prase William husbandman 599297 599297 Prase, William, of Slapton, husbandman 0
3859787 1976773 1976773 defendant Harry Elias husbandman 599297 599297 Harry, Elias, of Slapton, husbandman 0
3883401 1984716 1984716 defendant Lock Nicholas butcher 599297 599297 Lock, Nicholas, of Slapton, butcher 0
3972241 2014852 2014852 plaintiff Frenche William yeoman 599297 599297 Frenche, William, of Slapton, yeoman 0
3972243 2014853 2014853 plaintiff Frenche William yeoman 599297 599297 Frenche, William, of Slapton, yeoman 0
3986667 2019972 2019972 defendant Manne Michael husbandman 599297 599297 Manne, Michael, of Slapton, husbandman 0
4126720 2069843 2069843 defendant Malboroughe Peter husbandman 599297 599297 Malboroughe, Peter, of Slapton, husbandman 0
4221774 2103112 2103112 defendant Godfrey William   599297 599297 Godfrey, William, of Slapton, Bucks yeoman 0
4242814 2110588 2110588 defendant Hyne or Hyve Andrew husbandman 599297 599297 Hyne or Hyve, Andrew, of Slapton, husbandman 0
4304035 2131545 2131545 defendant Ameredyth Lewis gent 599297 599297 Ameredyth, Lewis, of Slapton, gent 0
4327163 2139412 2139412 defendant Collins John husbandman 599297 599297 Collins, John, of Slapton, husbandman 3
4332788 2141248 2141248 defendant Fletcher Henry (legal representative) 599297 599297 Fletcher, Henry, of Slapton, yeoman, executor of 0
4332789 2141248 2141248 defendant Fletcher William yeoman 599297 599297 Fletcher, William, of Slapton, yeoman 1
4338095 2143064 2143064 defendant Cooke Nicholas clerk 599297 599297 Cooke, Nicholas, of Slapton, clerk 1
4351881 2147897 2147897 defendant Mobbes John smith 599297 599297 Mobbes, John, of Slapton, smith 0
4365157 2152595 2152595 defendant Mabbes John blacksmith 599297 599297 Mabbes, John, of Slapton, blacksmith 0
4367625 2153474 2153474 defendant Mabbs John, junior yeoman 599297 599297 Mabbs, John, junior, of Slapton, yeoman 0
4411416 2168408 2168408 defendant Phillippe John husbandman 599297 599297 Phillippe, John, of Slapton, husbandman 0
4411417 2168408 2168408 defendant Tucker Henry husbandman 599297 599297 Tucker, Henry, of Slapton, husbandman 1
4661006 2249267 2249267 defendant Brampton Ralph tailor 599297 599297 Brampton, Ralph, of Slapton, tailor 0
4666974 2255401 2255401 defendant Thornton John husbandman 599297 599297 Thornton, John, of Slapton, husbandman 0
4670122 2256357 2256357 defendant Aby Robert clerk 599297 599297 Aby, Robert, of Slapton, clerk 0
4670124 2256358 2256358 defendant Aby Robert clerk 599297 599297 Aby, Robert, of Slapton, clerk 0
4681546 2259839 2259839 defendant Thornton John gent 599297 599297 Thornton, John, of Slapton, gent 0
4694454 2263759 2263759 defendant Thornton John gent 599297 599297 Thornton, John, of Slapton, gent 0
4703498 2266477 2266477 defendant Thornton John gent 599297 599297 Thornton, John, of Slapton, gent 3
4703503 2266478 2266478 defendant Thornton John gent 599297 599297 Thornton, John, of Slapton, gent 3
4756869 2282515 2282515 defendant Thornton John gent 599297 599297 Thornton, John, of Slapton, gent 1
4757385 2282681 2282681 plaintiff Bouryng John   599297 599297 Bouryng, John, of Slapton, warden of the chapel or College of St Mary 0
4758876 2283126 2283126 plaintiff Castell Nicholas merchant 599297 599297 Castell, Nicholas, of Slapton, merchant 0
4793799 2294179 2294179 defendant Bouryn William clerk 599297 599297 Bouryn, William, of Slapton, clerk 0
4804986 2297765 2297765 defendant Whitwylcok John fisher 599297 599297 Whitwylcok, John, of Slapton, fisher 0
4902104 2327267 2327267 defendant Wilcok William fishmonger 599297 599297 Wilcok, William, of Slapton, fishmonger 1
4920027 2332775 2332775 plaintiff Howes Richard   599297 599297 Howes, Richard, of Slapton 0
4920028 2332775 2332775 defendant Howes Richard   599297 599297 Howes, Richard, of Slapton 0
4983739 2352062 2352062 defendant Tymmys John husbandman 599297 599297 Tymmys, John, of Slapton, husbandman 0
5018552 2362308 2362308 defendant Perys William husbandman 599297 599297 Perys, William, of Slapton, husbandman 1
5054498 2372923 2372923 defendant Basset Henry husbandman 599297 599297 Basset, Henry, of Slapton, husbandman 0
5054506 2372923 2372923 defendant Pyke John husbandman 599297 599297 Pyke, John, of Slapton, husbandman 8
5054507 2372923 2372923 defendant Osbarn John huabandman 599297 599297 Osbarn, John, of Slapton, huabandman 9
5054512 2372924 2372924 defendant Pyke John husbandman 599297 599297 Pyke, John, of Slapton, husbandman 2
5054513 2372924 2372924 defendant Osbarn John husbandman 599297 599297 Osbarn, John, of Slapton, husbandman 3
5054515 2372924 2372924 defendant Basset Henry husbandman 599297 599297 together with Basset, Henry, of Slapton, husbandman 5
5359846 2463119 2463119 defendant Tymmys Thomas yeoman 599297 599297 Tymmys, Thomas, of Slapton, yeoman 0
5546345 2518934 2518934 defendant Walle Richard clerk 599297 599297 Walle, Richard, of Slapton, clerk 0
5553632 2521099 2521099 defendant Peke John husbandman 599297 599297 Peke, John, of Slapton, husbandman 0
5553633 2521099 2521099 defendant Odson Richard husbandman 599297 599297 Odson, Richard, of Slapton, husbandman 1
5628462 2552871 2552871 defendant Stokishill Richard husbandman 599297 599297 Stokishill, Richard, of Slapton, 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);