names

50 rows where place_id = 593953

✎ 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
3613924 1872009 1872009 defendant Shepard Arthur yeoman 593953 593953 Shepard, Arthur, of Tutbury, yeoman 1
3637769 1906628 1906628 defendant Vayne Richard miller 593953 593953 Vayne, Richard, of Tutbury, miller 0
3666944 1915607 1915607 plaintiff Wellys John receiver of the King's Honour of Tutbury 593953 593953 Wellys, John, of Tutbury, receiver of the King's Honour of Tutbury 0
3669450 1916383 1916383 defendant Shepperd Agnes spinster 593953 593953 Shepperd, Agnes, of Tutbury, spinster 2
3688167 1922450 1922450 defendant Brenner Hugh yeoman 593953 593953 Brenner, Hugh, of Tutbury, yeoman 0
3712413 1930200 1930200 defendant Mason John yeoman 593953 593953 Mason, John, of Tutbury, yeoman 1
3712414 1930200 1930200 defendant Clekeley John yeoman 593953 593953 Clekeley, John, of Tutbury, yeoman 2
3742082 1939392 1939392 defendant Chaplyn Bartholomew husbandman 593953 593953 Chaplyn, Bartholomew, of Tutbury, husbandman 0
3742083 1939392 1939392 defendant Chaplyn William husbandman 593953 593953 Chaplyn, William, of Tutbury, husbandman 1
3742084 1939392 1939392 defendant Wylkynson Robert husbandman 593953 593953 Wylkynson, Robert, of Tutbury, husbandman 2
3742085 1939392 1939392 defendant Mere William husbandman 593953 593953 Mere, William, of Tutbury, husbandman 3
3745005 1940344 1940344 plaintiff Wellys John   593953 593953 Wellys, John, of Tutbury 1
3745007 1940344 1940344 defendant Hethe Randolph gent 593953 593953 Hethe, Randolph, of Tutbury, gent 1
3748079 1941321 1941321 defendant Hethe Roland gent 593953 593953 Hethe, Roland, of Tutbury, gent 0
3748080 1941321 1941321 defendant Curson Marmaduke gent 593953 593953 Curson, Marmaduke, of Tutbury, gent 1
3753752 1943115 1943115 defendant Carte Richard miller 593953 593953 Carte, Richard, of Tutbury, miller 0
3767202 1947383 1947383 defendant Walton Edmund yeoman 593953 593953 Walton, Edmund, of Tutbury, yeoman 1
3774053 1949600 1949600 defendant Mason alias Chekley Thomas yeoman 593953 593953 Mason alias Chekley, Thomas, of Tutbury, yeoman 1
3779848 1951429 1951429 defendant Hopkyns Thomas laborer 593953 593953 Hopkyns, Thomas, of Tutbury, laborer 4
3830375 1967392 1967392 defendant Chekeley John yeoman 593953 593953 Chekeley, John, of Tutbury, yeoman 1
3855132 1975239 1975239 defendant Mason alias Checley William husbandman 593953 593953 Mason alias Checley, William, of Tutbury, husbandman 0
3855133 1975239 1975239 defendant Chapleyn William, junior husbandman 593953 593953 Chapleyn, William, junior, of Tutbury, husbandman 1
3869326 1979983 1979983 defendant Mylner Joan widow 593953 593953 Mylner, Joan, of Tutbury, widow 0
4063618 2047276 2047276 defendant Checkeley John yeoman 593953 593953 Checkeley, John, of Tutbury, yeoman 1
4356552 2149523 2149523 defendant Hawkesford William miller 593953 593953 Hawkesford, William, of Tutbury, miller 0
4537915 2212142 2212142 defendant Ledebetere Richard   593953 593953 Ledebetere, Richard, of Tutbury 2
4543341 2213804 2213804 defendant Ryder John   593953 593953 Ryder, John, of Tutbury 0
4608655 2233811 2233811 defendant Wethurlay John   593953 593953 Wethurlay, John, of Tutbury 2
4897330 2325824 2325824 defendant Shirley William yeoman 593953 593953 Shirley, William, of Tutbury, yeoman 1
4920456 2332913 2332913 defendant (not given) Thomas prior of Geddeney 593953 593953 Geddeney, Thomas, of Tutbury, prior of the House & church of the BM 0
4928019 2335197 2335197 defendant Gedney Thomas   593953 593953 Gedney, Thomas, of Tutbury, Staffs, prior 1
4931124 2336120 2336120 defendant Busby John   593953 593953 Busby, John, of Tutbury, mason 1
4963185 2345896 2345896 defendant Gardener Robert carpenter 593953 593953 Gardener, Robert, of Tutbury, carpenter 0
4968620 2347581 2347581 defendant Pant or Paut John yeoman 593953 593953 Pant or Paut, John, of Tutbury, yeoman 0
4968891 2347658 2347658 defendant Pant or Paut John yeoman 593953 593953 Pant or Paut, John, of Tutbury, yeoman 0
5067779 2376863 2376863 defendant Chekley alias Mason Richard husbandman 593953 593953 Chekley alias Mason, Richard, of Tutbury, husbandman 0
5080544 2380671 2380671 defendant Shepard Richard   593953 593953 Shepard, Richard, of Tutbury 4
5080548 2380671 2380671 defendant Balgy William   593953 593953 Balgy, William, of Tutbury 8
5253950 2431352 2431352 defendant Horsley John yeoman 593953 593953 Horsley, John, of Tutbury, yeoman 0
5268175 2435817 2435817 defendant White William husbandman 593953 593953 White, William, of Tutbury, husbandman 1
5312694 2448833 2448833 defendant Sheppard Thomas yeoman 593953 593953 Sheppard, Thomas, of Tutbury, yeoman 1
5336971 2456129 2456129 defendant Bussheby Thomas yeoman 593953 593953 Bussheby, Thomas, of Tutbury, yeoman 1
5355246 2461714 2461714 defendant Lees John laborer 593953 593953 Lees, John, of Tutbury, laborer 1
5455532 2491565 2491565 defendant Sheperd William yeoman 593953 593953 Sheperd, William, of Tutbury, yeoman 0
5533171 2514922 2514922 defendant Walker Thomas sherman 593953 593953 Walker, Thomas, of Tutbury, sherman 0
5577571 2528051 2528051 defendant Quarnby Thomas yeoman 593953 593953 Quarnby, Thomas, of Tutbury, yeoman 2
5602425 2535652 2535652 defendant Hyll John tailor 593953 593953 Hyll, John, of Tutbury, tailor 1
5604841 2536381 2536381 defendant Sheperd Arthur yeoman 593953 593953 Sheperd, Arthur, of Tutbury, yeoman 0
5607505 2537241 2537241 defendant Shepard Arthur yeoman 593953 593953 Shepard, Arthur, of Tutbury, yeoman 3
5607868 2537365 2537365 defendant Shyngle William yeoman 593953 593953 Shyngle, William, of Tutbury, yeoman 1

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);