names

20 rows where place_id = 681686

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4046062 2041029 2041029 defendant Lincolne Nicholas husbandman 681686 681686 Lincolne, Nicholas, of Ellingham, husbandman 0
4068104 2048899 2048899 defendant Puttock Robert yeoman 681686 681686 Puttock, Robert, of Ellingham, yeoman 0
4084672 2054790 2054790 defendant Wyseman Stephen husbandman 681686 681686 Wyseman, Stephen, of Ellingham, husbandman 3
4084677 2054791 2054791 defendant Wyseman Stephen husbandman 681686 681686 Wyseman, Stephen, of Ellingham, husbandman 3
4088893 2056331 2056331 defendant Everarde Edward esq 681686 681686 Everarde, Edward, of Ellingham, esq 1
4098957 2059951 2059951 defendant Humble John yeoman 681686 681686 Humble, John, of Ellingham, yeoman 1
4112588 2064759 2064759 defendant Wyarde Nicholas husbandman 681686 681686 Wyarde, Nicholas, of Ellingham, husbandman 0
4112589 2064759 2064759 defendant Trappett Anne spinster 681686 681686 Trappett, Anne, of Ellingham, spinster 1
4221824 2103130 2103130 defendant Reighnold Richard yeoman 681686 681686 Reighnold, Richard, of Ellingham, yeoman 0
4241878 2110276 2110276 defendant Kede Thomas yeoman 681686 681686 Kede, Thomas, of Ellingham, yeoman 0
4258471 2115801 2115801 defendant Holden John husbandman 681686 681686 Holden, John, of Ellingham, husbandman 0
4267596 2118795 2118795 defendant Syer William husbandman 681686 681686 Syer, William, of Ellingham, husbandman 0
4281059 2123274 2123274 defendant Inbye or Jubye Bartholomew yeoman 681686 681686 Inbye or Jubye, Bartholomew, of Ellingham, yeoman 0
4285167 2124745 2124745 defendant Gaye William husbandman 681686 681686 Gaye, William, of Ellingham, husbandman 0
4290790 2126763 2126763 defendant Browne John gent 681686 681686 Browne, John, of Ellingham, gent 0
4357694 2149925 2149925 defendant Cone Richard yeoman 681686 681686 Cone, Richard, of Ellingham, yeoman 3
4363753 2152098 2152098 defendant Keridge Thomas singleman 681686 681686 Keridge, Thomas, of Ellingham, husbandman, singleman 0
4376625 2156708 2156708 defendant Pigeon John collier 681686 681686 Pigeon, John, of Ellingham, collier 3
4390262 2161365 2161365 defendant Keridge Thomas singleman 681686 681686 Keridge, Thomas, of Ellingham, husbandman, singleman 0
4393642 2162478 2162478 defendant Hunting Richard   681686 681686 Hunting, Richard, of Ellingham, linen weaver 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);