names

58 rows where place_id = 588354

✎ 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
3594203 1865828 1865828 defendant Bracy Martin husbandman 588354 588354 Bracy, Martin, of Ledbury, Herefs, husbandman 2
3619760 1873754 1873754 defendant Bradford William husbandman 588354 588354 Bradford, William, of Ledbury, Herefs, husbandman 2
3710583 1929633 1929633 defendant Amonyngton Richard gent 588354 588354 Amonyngton, Richard, of Ledbury, Herefs, gent 0
3945795 2005604 2005604 defendant Bracy Edmund yeoman 588354 588354 Bracy, Edmund, of Ledbury, Herefs, yeoman 0
3985764 2019670 2019670 defendant Vuett or Unett John gent 588354 588354 Vuett or Unett, John, of Ledbury, Herefs, gent 0
3991734 2021801 2021801 defendant Picher Augustine or Austen yeoman 588354 588354 Picher, Augustine or Austen, of Ledbury, Herefs, yeoman 0
4000841 2025070 2025070 defendant Chamber John glover 588354 588354 Chamber, John, of Ledbury, Herefs, glover 2
4000845 2025071 2025071 defendant Chambers John glover 588354 588354 Chambers, John, of Ledbury, Herefs, glover 2
4007227 2027364 2027364 plaintiff Maddock alias Buckmill Richard tanner 588354 588354 Maddock alias Buckmill, Richard, of Ledbury, Herefs, tanner 0
4007229 2027365 2027365 plaintiff Maddock alias Bucknill Richard tanner 588354 588354 Maddock alias Bucknill, Richard, of Ledbury, Herefs, tanner 0
4010043 2028357 2028357 plaintiff Okye or Wockye Walter butcher 588354 588354 Okye or Wockye, Walter, of Ledbury, Herefs, butcher 0
4015728 2030319 2030319 defendant Buknell John mercer 588354 588354 Buknell, John, of Ledbury, Herefs, mercer 0
4021425 2032388 2032388 defendant Okye John butcher 588354 588354 Okye, John, of Ledbury, Herefs, butcher 3
4040210 2039002 2039002 plaintiff Meake John yeoman 588354 588354 Meake, John, of Ledbury, Herefs, yeoman 0
4040212 2039003 2039003 plaintiff Meake John yeoman 588354 588354 Meake, John, of Ledbury, Herefs, yeoman 0
4040214 2039004 2039004 plaintiff Meake John yeoman 588354 588354 Meake, John, of Ledbury, Herefs, yeoman 0
4041312 2039380 2039380 defendant Dicke John chapman 588354 588354 Dicke, John, of Ledbury, Herefs, chapman 0
4069079 2049232 2049232 defendant Parry James gent 588354 588354 Parry, James, of Ledbury, Herefs, gent 0
4098415 2059761 2059761 defendant Bynnys or Benys William gent 588354 588354 Bynnys or Benys, William, of Ledbury, Herefs, gent 0
4118270 2066821 2066821 defendant Parry Simon gent 588354 588354 Parry, Simon, of Ledbury, Herefs, gent 0
4144647 2076286 2076286 defendant Brooke Richard yeoman 588354 588354 Brooke, Richard, of Ledbury, Herefs, yeoman 1
4156691 2080418 2080418 defendant Elton Anthony gent 588354 588354 Elton, Anthony, of Ledbury, Herefs, gent 0
4170943 2085319 2085319 defendant Haukyns Fulk yeoman 588354 588354 Haukyns, Fulk, of Ledbury, Herefs, yeoman 1
4175528 2086912 2086912 defendant Parry James gent 588354 588354 Parry, James, of Ledbury, Herefs, gent 2
4183155 2089590 2089590 defendant Bracy Martin   588354 588354 Bracy, Martin, of Ledbury, Herefs, yeoman, bachelor 1
4218532 2101980 2101980 defendant Watters Thomas husbandman 588354 588354 Watters, Thomas, of Ledbury, Herefs, husbandman 0
4219865 2102448 2102448 defendant Chambers John glover 588354 588354 Chambers, John, of Ledbury, Herefs, glover 0
4230553 2106180 2106180 defendant Nurthen Richard tanner 588354 588354 Nurthen, Richard, of Ledbury, Herefs, tanner 1
4237279 2108627 2108627 defendant Chambers John glover 588354 588354 Chambers, John, of Ledbury, Herefs, glover 0
4300720 2130354 2130354 defendant Bennett William gent 588354 588354 Bennett, William, of Ledbury, Herefs, gent 3
4304074 2131558 2131558 defendant Nurthen John yeoman 588354 588354 Nurthen, John, of Ledbury, Herefs, yeoman 0
4304905 2131854 2131854 defendant Cam William yeoman 588354 588354 Cam, William, of Ledbury, Herefs, yeoman 1
4343771 2145099 2145099 defendant Stone Simon husbandman 588354 588354 Stone, Simon, of Ledbury, Herefs, husbandman 3
4361984 2151446 2151446 defendant Winbery John chapman 588354 588354 Winbery, John, of Ledbury, Herefs, chapman 0
4361992 2151448 2151448 defendant Hunte George mercer 588354 588354 Hunte, George, of Ledbury, Herefs, mercer 1
4370154 2154386 2154386 defendant Stone Roger yeoman 588354 588354 Stone, Roger, of Ledbury, Herefs, yeoman 2
4385934 2159987 2159987 defendant Meeke William yeoman 588354 588354 Meeke, William, of Ledbury, Herefs, yeoman 0
4396301 2163338 2163338 defendant Wilse Humphrey butcher 588354 588354 Wilse, Humphrey, of Ledbury, Herefs, yeoman, son of Thomas, of Ledbury, butcher 0
4396312 2163341 2163341 defendant Wilse Humphrey   588354 588354 Wilse, Humphrey, of Ledbury, Herefs, yeoman, hos son 1
4410380 2168070 2168070 defendant Skynner Edward clothier 588354 588354 Skynner, Edward, of Ledbury, Herefs, clothier 0
4411502 2168438 2168438 defendant Stone Simon yeoman 588354 588354 Stone, Simon, of Ledbury, Herefs, yeoman 2
4665524 2250689 2250689 defendant Walwayn Thomas esq 588354 588354 Walwayn, Thomas, of Ledbury, Herefs, esq 2
4668463 2255847 2255847 defendant Bannebury Richard yeoman 588354 588354 Bannebury, Richard, of Ledbury, Herefs, yeoman 1
4668484 2255850 2255850 defendant Bannebury Richard yeoman 588354 588354 Bannebury, Richard, of Ledbury, Herefs, yeoman 1
4683378 2260402 2260402 defendant Braban Thomas yeoman 588354 588354 Braban, Thomas, of Ledbury, Herefs, yeoman 0
4685565 2261079 2261079 defendant Parker Richard husbandman 588354 588354 Parker, Richard, of Ledbury, Herefs, husbandman 2
4760880 2283743 2283743 defendant Chamberleyn Agnes single woman 588354 588354 Chamberleyn, Agnes, of Ledbury, Herefs, single woman 1
4949717 2341905 2341905 defendant Vuet or Unet John gent 588354 588354 Vuet or Unet, John, of Ledbury, Herefs, gent 1
4949778 2341921 2341921 defendant Unet or Vuet John gent 588354 588354 Unet or Vuet, John, of Ledbury, Herefs, gent 1
4953097 2342891 2342891 defendant Chaloner John chaloner 588354 588354 Chaloner, John, of Ledbury, Herefs, chaloner 1
4953595 2343047 2343047 defendant Vuet or Unet John gent 588354 588354 Vuet or Unet, John, of Ledbury, Herefs, gent 0
4953615 2343049 2343049 defendant Vuet or Unet John gent 588354 588354 Vuet or Unet, John, of Ledbury, Herefs, gent 0
4971284 2348347 2348347 defendant Walcroft John husbandman 588354 588354 (Walcroft, John, of Ledbury, Herefs, husbandman 1
4971289 2348348 2348348 defendant Sharp William (legal representative) 588354 588354 Sharp, William, of Ledbury, Herefs, skinner, executors of 0
5000460 2357004 2357004 defendant Walker Richard husbandman 588354 588354 Walker, Richard, of Ledbury, Herefs, husbandman 0
5053734 2372718 2372718 defendant Walcote Walter yeoman 588354 588354 Walcote, Walter, of Ledbury, Herefs, yeoman 0
5344413 2458432 2458432 defendant Vagham John clerk 588354 588354 Vagham, John, of Ledbury, Herefs, clerk 1
5522571 2511883 2511883 defendant Wyseham John, senior gent 588354 588354 Wyseham, John, senior, of Ledbury, Herefs, gent 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);