names

23 rows where place_id = 612185

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692022 1923672 1923672 defendant Natures William yeoman 612185 612185 Natures, William, of Haveryll, Suff, yeoman 0
3780711 1951699 1951699 defendant Man John tanner 612185 612185 Man, John, of Haveryll, Suff, tanner 2
3871651 1980755 1980755 defendant Sturdy Robert turner 612185 612185 Sturdy, Robert, of Haveryll, Suff, turner 2
4689223 2262188 2262188 defendant Gyffard William gent 612185 612185 Gyffard, William, of Haveryll, Suff, gent 2
4912059 2330272 2330272 defendant Glover William (legal representative) 612185 612185 Glover, William, of Haveryll, Suff, chapman, executrix of 4
4949731 2341909 2341909 defendant Renell or Revell Robert husbandman 612185 612185 Renell or Revell, Robert, of Haveryll, Suff, husbandman 1
4960054 2344974 2344974 defendant Cornewell John   612185 612185 Cornewell, John, of Haveryll, Suff, receiver general for Burghchier, Henry, Earl of Ewe, Lord Burghchier 0
4974141 2349225 2349225 defendant Cote William smith 612185 612185 Cote, William, of Haveryll, Suff, smith 0
4974149 2349226 2349226 defendant Cote William smith 612185 612185 Cote, William, of Haveryll, Suff, smith 0
4976965 2350065 2350065 defendant Lane John tanner 612185 612185 Lane, John, of Haveryll, Suff, tanner 2
4976971 2350066 2350066 defendant Lane John tanner 612185 612185 Lane, John, of Haveryll, Suff, tanner 3
5019783 2362666 2362666 defendant Cook Walter husbandman 612185 612185 Cook, Walter, of Haveryll, Suff, husbandman 0
5031644 2366118 2366118 defendant Stalon or Scalon John baker 612185 612185 Stalon or Scalon, John, of Haveryll, Suff, baker 2
5037426 2367817 2367817 defendant Cote William husbandman 612185 612185 Cote, William, of Haveryll, Suff, husbandman 0
5063406 2375579 2375579 defendant Rewel Robert (legal representative) 612185 612185 Rewel, Robert, of Haveryll, Suff, husbandman, executor of 3
5070239 2377590 2377590 defendant Dale William chandler 612185 612185 Dale, William, of Haveryll, Suff, chandler 0
5123499 2393325 2393325 defendant Denys John husbandman 612185 612185 Denys, John, of Haveryll, Suff, husbandman 0
5133765 2396367 2396367 defendant Stalon John tanner 612185 612185 Stalon, John, of Haveryll, Suff, tanner 0
5353575 2461190 2461190 defendant Potyer John yeoman 612185 612185 Potyer, John, of Haveryll, Suff, yeoman 0
5362704 2463984 2463984 defendant Turour or Turnour Henry gent 612185 612185 Turour or Turnour, Henry, of Haveryll, Suff, gent 0
5434647 2485300 2485300 defendant Hovyle John shoemaker 612185 612185 Hovyle, John, of Haveryll, Suff, shoemaker 0
5449971 2489881 2489881 defendant Hovyle John shoemaker 612185 612185 Hovyle, John, of Haveryll, Suff, shoemaker 0
5462129 2493566 2493566 defendant Hovyle John shoemaker 612185 612185 Hovyle, John, of Haveryll, Suff, shoemaker 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);