names

42 rows where place_id = 654029

✎ 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
3673277 1917659 1917659 plaintiff Elwyn William (legal representative) 654029 654029 Elwyn, William, of Wygenhall St German, gent, executors of 0
3740942 1939028 1939028 defendant Boteler Gilbert yeoman 654029 654029 Boteler, Gilbert, of Wygenhall, yeoman 0
3740943 1939028 1939028 defendant Boteler Edmund yeoman 654029 654029 Boteler, Edmund, of Wygenhall, yeoman 1
3904830 1991879 1991879 defendant Shryve German husbandman 654029 654029 Shryve, German, of Wygenhall, husbandman 0
3904832 1991880 1991880 defendant Shryve German husbandman 654029 654029 Shryve, German, of Wygenhall, husbandman 0
3930724 2000627 2000627 defendant Browne William butcher 654029 654029 Browne, William, of Wygenhall St German, butcher 0
3930726 2000627 2000627 defendant Fenne Richard yeoman 654029 654029 Fenne, Richard, of Wygenhall St German, yeoman 2
3930729 2000628 2000628 defendant Browne William butcher 654029 654029 Browne, William, of Wygenhall St German, butcher 0
3937240 2002788 2002788 defendant Cobbe John husbandman 654029 654029 Cobbe, John, of Wygenhall, husbandman 0
3939890 2003642 2003642 plaintiff Sheryff Germanus yeoman 654029 654029 Sheryff, Germanus, of Wygenhall, yeoman 0
3939891 2003642 2003642 defendant Burrowgh Nicholas husbandman 654029 654029 Burrowgh, Nicholas, of Wygenhall, husbandman 0
3998537 2024215 2024215 defendant Sympspon Edward husbandman 654029 654029 Sympspon, Edward, of Wygenhall, husbandman 2
3998538 2024215 2024215 defendant Frenche John husbandman 654029 654029 Frenche, John, of Wygenhall, husbandman 3
4015328 2030176 2030176 defendant Baxter Nicholas yeoman 654029 654029 Baxter, Nicholas, of Wygenhall St German, yeoman 0
4015329 2030176 2030176 defendant Wryght John yeoman 654029 654029 Wryght, John, of Wygenhall St German, yeoman 1
4030691 2035638 2035638 defendant Palmer John yeoman 654029 654029 Palmer, John, of Wygenhall St German, yeoman 2
4037022 2037907 2037907 defendant Bradley Robert brickmaker 654029 654029 Bradley, Robert, of Wygenhall, brickmaker 3
4050736 2042698 2042698 defendant Spryngold John husbandman 654029 654029 Spryngold, John, of Wygenhall St Peter, husbandman 0
4050738 2042699 2042699 defendant Spryngold John husbandman 654029 654029 Spryngold, John, of Wygenhall St Peter, husbandman 0
4054177 2043882 2043882 defendant Armysted Hugh husbandman 654029 654029 Armysted, Hugh, of Wygenhall St German, husbandman 1
4067768 2048784 2048784 defendant Thorpe Robert yeoman 654029 654029 Thorpe, Robert, of Wygenhall, yeoman 0
4067770 2048785 2048785 defendant Thorpe Robert yeoman 654029 654029 Thorpe, Robert, of Wygenhall, yeoman 0
4074762 2051273 2051273 defendant Robinson John yeoman 654029 654029 Robinson, John, of Wygenhall St German, yeoman 0
4074763 2051273 2051273 defendant Wyllyamson Edward clerk 654029 654029 Wyllyamson, Edward, of Wygenhall St German, clerk 1
4076411 2051859 2051859 defendant Marshall Robert clerk 654029 654029 Marshall, Robert, of Wygenhall St Peter, clerk 0
4076418 2051861 2051861 defendant Adam John husbandman 654029 654029 Adam, John, of Wygenhall St German, husbandman 1
4081358 2053639 2053639 defendant Sutton Thomas husbandman 654029 654029 Sutton, Thomas, of Wygenhall St Jerman, husbandman 1
4082469 2054037 2054037 defendant Pers William yeoman 654029 654029 Pers, William, of Wygenhall St Peter, yeoman 0
4082660 2054109 2054109 defendant Harr James (legal representative) 654029 654029 Harr, James, of Wygenhall St Jerman, carpenter, executors of 1
4092068 2057460 2057460 defendant Robynson John yeoman 654029 654029 Robynson, John, of Wygenhall St Jerman, yeoman 0
4092069 2057460 2057460 defendant Kervyle Robert gent 654029 654029 Kervyle, Robert, of Wygenhall St Jerman, gent 1
4129736 2070945 2070945 defendant Funnell William clerk 654029 654029 Funnell, William, of Wygenhall, clerk 2
4166462 2083769 2083769 defendant Robynson John yeoman 654029 654029 Robynson, John, of Wygenhall St German, yeoman 1
4166463 2083769 2083769 defendant Parkyn Robert husbandman 654029 654029 Parkyn, Robert, of Wygenhall St German, husbandman 2
4166644 2083831 2083831 defendant Robynson John yeoman 654029 654029 Robynson, John, of Wygenhall St German, yeoman 0
4166646 2083832 2083832 defendant Robynson John yeoman 654029 654029 Robynson, John, of Wygenhall St German, yeoman 0
4169971 2084991 2084991 defendant Goodman Thomas husbandman 654029 654029 Goodman, Thomas, of Wygenhall St Peter, husbandman 0
4208974 2098690 2098690 defendant Cambridge William   654029 654029 Cambridge, William, of Wygenhall St German, mason 2
4243229 2110727 2110727 defendant Well Thomas husbandman 654029 654029 Well, Thomas, of Wygenhall St Peter, husbandman 0
4388857 2160905 2160905 defendant Thorp Robert husbandman 654029 654029 Thorp, Robert, of Wygenhall St Jerman, husbandman 2
4537285 2211932 2211932 defendant Mayner John   654029 654029 Mayner, John, of Wygenhall, son of John 1
5532322 2514651 2514651 defendant Acrys Simon yeoman 654029 654029 Acrys, Simon, of Wygenhall, 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);