names

18 rows where place_id = 589583

✎ 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
3598058 1867016 1867016 defendant Bedell William yeoman 589583 589583 Bedell, William, of Waldron, yeoman 0
3701520 1926725 1926725 defendant Frankwell Richard, junior yeoman 589583 589583 Frankwell, Richard, junior, of Waldron, yeoman 0
4137236 2073665 2073665 defendant Fawkner John yeoman 589583 589583 Fawkner, John, of Waldron, yeoman 0
4161633 2082136 2082136 defendant Fawkener John yeoman 589583 589583 Fawkener, John, of Waldron, yeoman 0
4176126 2087125 2087125 defendant Erle Gregory yeoman 589583 589583 Erle, Gregory, of Waldron, yeoman 0
4186079 2090619 2090619 defendant Garle or Earle George yeoman 589583 589583 Garle or Earle, George, of Waldron, yeoman 0
4225827 2104497 2104497 defendant Longley Richard tailor 589583 589583 Longley, Richard, of Waldron, or of Redarsfeld, tailor 0
4230526 2106172 2106172 defendant Frye John yeoman 589583 589583 Frye, John, of Waldron, yeoman 0
4230527 2106172 2106172 defendant Cattestreate Thomas yeoman 589583 589583 Cattestreate, Thomas, of Waldron, yeoman 1
4232622 2106913 2106913 defendant Akherste John husbandman 589583 589583 Akherste, John, of Waldron, husbandman 2
4237385 2108667 2108667 defendant Fuller Thomas smith 589583 589583 Fuller, Thomas, of Waldron, smith 0
4313278 2134752 2134752 defendant Fuller William husbandman 589583 589583 Fuller, William, of Waldron, husbandman 0
4318269 2136498 2136498 defendant Sherwood Walter yeoman 589583 589583 Sherwood, Walter, of Waldron, yeoman 0
4326540 2139237 2139237 defendant Fuller William husbandman 589583 589583 Fuller, William, of Waldron, husbandman 0
4361879 2151409 2151409 defendant Tayler John carpenter 589583 589583 Tayler, John, of Waldron, carpenter 0
4361880 2151409 2151409 defendant Kenwarde Robert tanner 589583 589583 Kenwarde, Robert, of Waldron, tanner 1
4400199 2164657 2164657 defendant Castrate Thomas   589583 589583 Castrate, Thomas, of Waldron, "ryper" 0
5500224 2505018 2505018 defendant Nycholas alias Holdenby William yeoman 589583 589583 Nycholas alias Holdenby, William, of Waldron, 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);