names

42 rows where place_id = 633547

✎ 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
3813362 1962091 1962091 defendant Bygeden Henry yeoman 633547 633547 Bygeden, Henry, of Bolton on Derne, yeoman 0
3834228 1968646 1968646 defendant Mason Nicholas yeoman 633547 633547 Mason, Nicholas, of Bolton on Derne, yeoman 0
3983476 2018866 2018866 defendant Samon Isabel   633547 633547 Isabel his wife, alias Isabel Newneham, of Bolton on Derne, daughter of William Newneham, of Kyrkelington, Notts, knight 1
4012334 2029133 2029133 defendant Baxster Robert gent 633547 633547 Baxster, Robert, of Bolton on Derne, gent 0
4014077 2029765 2029765 defendant Skyrrowe Henry yeoman 633547 633547 Skyrrowe, Henry, of Bolton on Derne, yeoman 1
4138332 2074073 2074073 defendant Skirrowe Henry yeoman 633547 633547 Skirrowe, Henry, of Bolton on Derne, yeoman 0
4147395 2077231 2077231 defendant Woodrove William gent 633547 633547 Woodrove, William, of Bolton on Derne, gent 0
4162922 2082561 2082561 defendant Skyrrowe Henry yeoman 633547 633547 Skyrrowe, Henry, of Bolton on Derne, yeoman 0
4166118 2083657 2083657 defendant Woodrove William gent 633547 633547 Woodrove, William, of Bolton on Derne, gent 0
4173296 2086121 2086121 defendant Woderove William gent 633547 633547 Woderove, William, of Bolton on Derne, gent 0
4174074 2086386 2086386 defendant Woderove William gent 633547 633547 Woderove, William, of Bolton on Derne, gent 0
4182620 2089400 2089400 defendant Wilkinson Francis gent 633547 633547 Wilkinson, Francis, of Bolton on Derne, gent 0
4182621 2089400 2089400 defendant Woodetrove William gent 633547 633547 Woodetrove, William, of Bolton on Derne, gent 1
4605245 2232807 2232807 defendant Hoggeson William   633547 633547 Hoggeson, William, of Bolton on Derne 0
4751616 2280960 2280960 defendant Mason William husbandman 633547 633547 Mason, William, of Bolton on Derne, husbandman 0
4751617 2280960 2280960 defendant Mason John husbandman 633547 633547 Mason, John, of Bolton on Derne, husbandman 1
4888681 2323252 2323252 defendant Taillour William chaplain 633547 633547 Taillour, William, of Bolton on Derne, chaplain 0
4898082 2326068 2326068 plaintiff Falas John   633547 633547 Falas, John, of Bolton on Derne 8
4916445 2331644 2331644 defendant Bulder John husbandman 633547 633547 Bulder, John, of Bolton on Derne, husbandman 1
5019580 2362613 2362613 defendant del Bothe John laborer 633547 633547 del Bothe, John, of Bolton on Derne, laborer 0
5019582 2362614 2362614 defendant del Bothe John laborer 633547 633547 del Bothe, John, of Bolton on Derne, laborer 0
5058657 2374151 2374151 defendant Cr- William miller 633547 633547 Cr-, William, of Bolton on Derne, miller 2
5129650 2395162 2395162 defendant Mason Thomas chaplain 633547 633547 Mason, Thomas, of Bolton on Derne, chaplain 0
5243007 2428158 2428158 defendant Pygot Robert laborer 633547 633547 Pygot, Robert, of Bolton on Derne, laborer 0
5333555 2455108 2455108 defendant Gremet William miller 633547 633547 Gremet, William, of Bolton on Derne, miller 1
5338458 2456600 2456600 defendant Cremet or Bremet William miller 633547 633547 Cremet or Bremet, William, of Bolton on Derne, miller 2
5434114 2485157 2485157 defendant Watson William husbandman 633547 633547 Watson, William, of Bolton on Derne, husbandman 0
5473275 2496971 2496971 defendant Wattson William husbandman 633547 633547 Wattson William, of Bolton on Derne, husbandman 0
5579036 2528517 2528517 defendant Shepard Richard husbandman 633547 633547 Shepard, Richard, of Bolton on Derne, husbandman 0
5582470 2529588 2529588 defendant Baxster John gent 633547 633547 Baxster, John, of Bolton on Derne, gent 0
5582472 2529589 2529589 defendant Clerkson William husbandman 633547 633547 Clerkson, William, of Bolton on Derne, husbandman 0
5582473 2529589 2529589 defendant Makyn Thomas husbandman 633547 633547 Makyn, Thomas, of Bolton on Derne, husbandman 1
5582474 2529589 2529589 defendant Hall Robert husbandman 633547 633547 Hall, Robert, of Bolton on Derne, husbandman 2
5582475 2529589 2529589 defendant Smythe Hugh butcher 633547 633547 Smythe, Hugh, of Bolton on Derne, butcher 3
5582476 2529589 2529589 defendant Blakborn John husbandman 633547 633547 Blakborn, John, of Bolton on Derne, husbandman 4
5582477 2529589 2529589 defendant Sysson Robert husbandman 633547 633547 Sysson, Robert, of Bolton on Derne, husbandman 5
5582478 2529589 2529589 defendant Twysylton Richard husbandman 633547 633547 Twysylton, Richard, of Bolton on Derne, husbandman 6
5582479 2529589 2529589 defendant Ellys Rpbert husbandman 633547 633547 Ellys, Rpbert, of Bolton on Derne, husbandman 7
5582480 2529589 2529589 defendant Hopkynson Richard laborer 633547 633547 Hopkynson, Richard, of Bolton on Derne, laborer 8
5582481 2529589 2529589 defendant Swyfte John laborer 633547 633547 Swyfte, John, of Bolton on Derne, laborer 9
5590247 2531919 2531919 defendant Baxster John gent 633547 633547 Baxster, John, of Bolton on Derne, gent 0
5607035 2537096 2537096 plaintiff Wade Richard   633547 633547 Wade, Richard, of Bolton on Derne 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);