names

57 rows where place_id = 589257

✎ 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
3597037 1866697 1866697 defendant Coker John yeoman 589257 589257 Coker, John, of Bukfastlegh, yeoman 0
3635569 1905928 1905928 defendant Symson John yeoman 589257 589257 Symson, John, of Bukfastlegh, yeoman 0
3679856 1919764 1919764 defendant Wydecombe Thomas   589257 589257 Wydecombe, Thomas, of Bukfastlegh, groom 0
3723952 1933772 1933772 defendant Mace Henry chaplain 589257 589257 Mace, Henry, of Bukfastlegh, chaplain 1
3767944 1947610 1947610 defendant Rowe Walter husbandman 589257 589257 Rowe, Walter, of Bukfastlegh, husbandman 0
4511412 2204010 2204010 defendant Wode John   589257 589257 Wode, John, of Bukfastlegh 1
4512114 2204233 2204233 defendant Touker John   589257 589257 Touker, John, of Bukfastlegh 0
4512115 2204233 2204233 defendant Berde John, sen   589257 589257 Berde, John, sen, of Bukfastlegh 1
4512116 2204233 2204233 defendant Lakeman Nicholas   589257 589257 Lakeman, Nicholas, of Bukfastlegh 2
4665882 2250804 2250804 defendant Frensshe John smith 589257 589257 Frensshe, John, of Bukfastlegh, smith 1
4676658 2258317 2258317 plaintiff (not given) Roger vicar of Goslegh 589257 589257 Goslegh, Roger, of Bukfastlegh, vicar of the church of Holy Trinity, executors of 0
4676661 2258317 2258317 defendant Hughe David (legal representative) 589257 589257 Hughe, David, of Bukfastlegh, former vicar, executor of 0
4686603 2261419 2261419 defendant Berde John yeoman 589257 589257 Berde, John, of Bukfastlegh, yeoman 1
4686604 2261419 2261419 defendant Bere Stephen shoemaker 589257 589257 Bere, Stephen, of Bukfastlegh, shoemaker 2
4703758 2266556 2266556 defendant Smarte Geoffrey baker 589257 589257 Smarte, Geoffrey, of Bukfastlegh, baker 0
4757436 2282700 2282700 defendant Knyght Thomas husbandman 589257 589257 Knyght, Thomas, of Bukfastlegh, husbandman 2
4778084 2289133 2289133 defendant Hogeman Robert husbandman 589257 589257 Hogeman, Robert, of Bukfastlegh, husbandman 0
4779524 2289576 2289576 defendant Knyght Thomas husbandman 589257 589257 Knyght, Thomas, of Bukfastlegh, husbandman 2
4788844 2292566 2292566 defendant Baudyn Henry clerk 589257 589257 Baudyn, Henry, of Bukfastlegh, clerk 2
4807104 2298420 2298420 defendant Stone John husbandman 589257 589257 Stone, John, of Bukfastlegh, husbandman 2
4851464 2311903 2311903 defendant Stone John butcher 589257 589257 Stone, John, of Bukfastlegh, butcher 0
4888009 2323056 2323056 defendant Schyplegh John   589257 589257 Schyplegh, John, of Bukfastlegh, merchant, part owner of a barge called the Katherine of Dertemouth 3
4890172 2323696 2323696 defendant Gode Roger husbandman 589257 589257 Gode, Roger, of Bukfastlegh, husbandman 2
4900777 2326878 2326878 defendant Harry Richard tucker 589257 589257 Harry, Richard, of Bukfastlegh, tucker 1
4902896 2327521 2327521 defendant Harry Richard tucker 589257 589257 Harry, Richard, of Bukfastlegh, tucker 0
4902898 2327521 2327521 defendant Turgys John husbandman 589257 589257 Turgys, John, of Bukfastlegh, husbandman 2
4929773 2335725 2335725 defendant Stone John   589257 589257 Stone, John, of Bukfastlegh, fish jowter 3
4960429 2345083 2345083 defendant Olyver John fishmonger 589257 589257 Olyver, John, of Bukfastlegh, fishmonger 2
4964746 2346366 2346366 defendant William Mathew laborer 589257 589257 William, Mathew, of Bukfastlegh, laborer 0
4977230 2350146 2350146 defendant Budde William helier or roofer 589257 589257 Budde, William, of Bukfastlegh, helier or roofer 4
4977231 2350146 2350146 defendant Choldewelle Walter carpenter 589257 589257 Choldewelle, Walter, of Bukfastlegh, carpenter 5
4977232 2350146 2350146 defendant Dounyng John carpenter 589257 589257 Dounyng, John, of Bukfastlegh, carpenter 6
4977233 2350146 2350146 defendant Tokere John carpenter 589257 589257 Tokere, John, of Bukfastlegh, carpenter 7
4977234 2350146 2350146 defendant Cole John carpenter 589257 589257 Cole, John, of Bukfastlegh, carpenter 8
4977235 2350146 2350146 defendant Lakeman John   589257 589257 Lakeman, John, of Bukfastlegh, mason 9
4977236 2350146 2350146 defendant Whyte Adam husbandman 589257 589257 Whyte, Adam, of Bukfastlegh, husbandman 10
4977237 2350146 2350146 defendant Simon John glover 589257 589257 Simon, John, of Bukfastlegh, glover 11
4977238 2350146 2350146 defendant Simon Thomas glover 589257 589257 Simon, Thomas, of Bukfastlegh, glover 12
4977239 2350146 2350146 defendant Lovetorre William glover 589257 589257 Lovetorre, William, of Bukfastlegh, glover 13
4977240 2350146 2350146 defendant Lovetorre John glover 589257 589257 Lovetorre, John, of Bukfastlegh, glover 14
4977241 2350146 2350146 defendant Wode Robert cordwainer 589257 589257 Wode, Robert, of Bukfastlegh, cordwainer 15
4977242 2350146 2350146 defendant Freynsshe William smith 589257 589257 Freynsshe, William, of Bukfastlegh, smith 16
4977243 2350146 2350146 defendant Rogger Richard carpenter 589257 589257 Rogger, Richard, of Bukfastlegh, carpenter 17
4977246 2350147 2350147 defendant Budde William helyer or roofer 589257 589257 Budde, William, of Bukfastlegh, helyer or roofer 1
5040516 2368774 2368774 defendant Bodde William, senior helier 589257 589257 Bodde, William, senior, of Bukfastlegh, helier 0
5040517 2368774 2368774 defendant Bodde William, junior husbandman 589257 589257 Bodde, William, junior, of Bukfastlegh, husbandman 1
5045863 2370397 2370397 defendant Cooke alias Strete William husbandman 589257 589257 Cooke alias Strete, William, of Bukfastlegh, husbandman 2
5109015 2389055 2389055 defendant Dyer John yeoman 589257 589257 Dyer, John, of Bukfastlegh, yeoman 0
5152359 2401823 2401823 defendant Gibbe John husbandman 589257 589257 Gibbe, John, of Bukfastlegh, husbandman 0
5158284 2403547 2403547 defendant Harry Richard fuller 589257 589257 Harry, Richard, of Bukfastlegh, fuller 0
5185309 2411446 2411446 defendant Elyot Richard gent 589257 589257 Elyot, Richard, of Bukfastlegh, gent 0
5287576 2441392 2441392 defendant Smyth Walter weaver 589257 589257 Smyth, Walter, of Bukfastlegh, weaver 0
5325463 2452698 2452698 defendant Roger Margaret widow 589257 589257 Roger, Margaret, of Bukfastlegh, widow 0
5335611 2455723 2455723 defendant Clerke Thomas gent 589257 589257 Clerke, Thomas, of Bukfastlegh, gent 0
5535407 2515600 2515600 defendant Bony or Bovy John husbandman 589257 589257 Bony or Bovy, John, of Bukfastlegh, husbandman 0
5538200 2516433 2516433 defendant Denell or Devell William husbandman 589257 589257 Denell or Devell, William, of Bukfastlegh, husbandman 0
5544133 2518280 2518280 defendant Foterell John yeoman 589257 589257 Foterell, John, of Bukfastlegh, yeoman 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);