names

48 rows where place_id = 604286

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657489 1912603 1912603 defendant Northorpe Richard yeoman 604286 604286 Northorpe, Richard, of Mirfeld, yeoman 1
3673401 1917699 1917699 defendant Blakburn James clothier 604286 604286 Blakburn, James, of Mirfeld, clothier 3
3691889 1923624 1923624 defendant Beamont John gent 604286 604286 Beamont, John, of Mirfeld, gent 0
3695842 1924935 1924935 defendant Blakburn James clothmaker 604286 604286 Blakburn, James, of Mirfeld, clothmaker 0
3695843 1924935 1924935 defendant Legyerd William clothmaker 604286 604286 Legyerd, William, of Mirfeld, clothmaker 1
3782203 1952185 1952185 defendant Man Richard clothier 604286 604286 Man, Richard, of Mirfeld, clothier 0
3793985 1955983 1955983 defendant Man William husbandman 604286 604286 Man, William, of Mirfeld, husbandman 23
3793986 1955983 1955983 defendant Man Richard sherman 604286 604286 Man, Richard, of Mirfeld, sherman 24
3793987 1955983 1955983 defendant Fornes John yeoman 604286 604286 Fornes, John, of Mirfeld, yeoman 25
3803341 1958944 1958944 defendant Aglonby Clement clerk 604286 604286 Aglonby, Clement, of Mirfeld, clerk 0
3803342 1958944 1958944 defendant Haropp John yeoman 604286 604286 Haropp, John, of Mirfeld, yeoman 1
3845765 1972223 1972223 defendant Scott Mathew yeoman 604286 604286 Scott, Mathew, of Mirfeld, yeoman 0
3846096 1972337 1972337 defendant Songer Robert miller 604286 604286 Songer, Robert, of Mirfeld, miller 0
3846097 1972337 1972337 defendant Lee Robert laborer 604286 604286 Lee, Robert, of Mirfeld, laborer 1
3846098 1972337 1972337 defendant Fladder Thomas laborer 604286 604286 Fladder, Thomas, of Mirfeld, laborer 2
3875585 1982075 1982075 defendant Legerd William yeoman 604286 604286 Legerd, William, of Mirfeld, yeoman 0
4075812 2051648 2051648 plaintiff Savyle Elizabeth gent 604286 604286 Savyle, Elizabeth, of Mirfeld, widow of Thomas Savile, of Clyfton, gent 0
4139929 2074646 2074646 defendant Haighe James clothier 604286 604286 Haighe, James, of Mirfeld, clothier 0
4185855 2090547 2090547 defendant Thurgurland Richard gent 604286 604286 Thurgurland, Richard, of Mirfeld, gent 1
4189139 2091693 2091693 defendant Breare John clothier 604286 604286 Breare, John, of Mirfeld, clothier 1
4258034 2115658 2115658 defendant Ledgerd John yeoman 604286 604286 Ledgerd, John, of Mirfeld, yeoman 0
4258036 2115658 2115658 defendant Ledgerd John   604286 604286 Ledgerd, John, of Mirfeld, yeoman, son of John senior 2
4451258 2185354 2185354 plaintiff Heton John de   604286 604286 Heton, John de, of Mirfeld 0
4789205 2292680 2292680 defendant be the Water William yeoman 604286 604286 be the Water, William, of Mirfeld, yeoman 0
4971341 2348360 2348360 defendant Spynner John, senior yeoman 604286 604286 Spynner, John, senior, of Mirfeld, yeoman 0
5120208 2392352 2392352 defendant Bynglay William barker 604286 604286 Bynglay, William,of Mirfeld, barker 2
5120209 2392352 2392352 defendant Syke William husbandman 604286 604286 Syke, William, of Mirfeld, husbandman 3
5120210 2392352 2392352 defendant Emson John husbandman 604286 604286 Emson, John, of Mirfeld, husbandman 4
5120212 2392353 2392353 defendant Armytage John husbandman 604286 604286 Armytage, John, of Mirfeld, husbandman 0
5120213 2392353 2392353 defendant Lee William husbandman 604286 604286 Lee, William, of Mirfeld, husbandman 1
5120214 2392353 2392353 defendant Lee Thomas husbandman 604286 604286 Lee, Thomas, of Mirfeld, husbandman 2
5120215 2392353 2392353 defendant Northorp Richard husbandman 604286 604286 Northorp, Richard, of Mirfeld, husbandman 3
5120216 2392353 2392353 defendant Walker Richard husbandman 604286 604286 Walker, Richard, of Mirfeld, husbandman 4
5292464 2442793 2442793 defendant Bithewatir William gent 604286 604286 Bithewatir, William, of Mirfeld, gent 0
5356055 2461973 2461973 defendant Northorp John yeoman 604286 604286 Northorp, John, of Mirfeld, yeoman 3
5356056 2461973 2461973 defendant Geffon or Gesson Richard yeoman 604286 604286 Geffon or Gesson, Richard, of Mirfeld, yeoman 4
5416921 2479975 2479975 defendant Northorse John yeoman 604286 604286 Northorse, John, of Mirfeld, yeoman 4
5462486 2493685 2493685 defendant Rodes John husbandman 604286 604286 Rodes, John, of Mirfeld, husbandman 0
5474032 2497207 2497207 defendant Rodes John husbandman 604286 604286 Rodes, John, of Mirfeld, husbandman 0
5487079 2501032 2501032 defendant Lawe Robert husbandman 604286 604286 Lawe, Robert, of Mirfeld, husbandman 2
5536830 2516006 2516006 defendant Hopton Robert gent 604286 604286 Hopton, Robert, of Mirfeld, gent 0
5536831 2516006 2516006 defendant Hopton William gent 604286 604286 Hopton, William, of Mirfeld, gent 1
5572284 2526446 2526446 defendant Turnley William smith 604286 604286 Turnley, William, of Mirfeld, smith 0
5582182 2529499 2529499 defendant Blakburn James husbandman 604286 604286 Blakburn, James, of Mirfeld, husbandman 2
5604874 2536393 2536393 defendant Stansfeld Agnes widow 604286 604286 Stansfeld, Agnes, of Mirfeld, widow 1
5604876 2536393 2536393 defendant Northorp Richard yeoman 604286 604286 Northorp, Richard, of Mirfeld, yeoman 3
5604877 2536393 2536393 defendant Hochonson John husbandman 604286 604286 Hochonson, John, of Mirfeld, husbandman 4
5604878 2536393 2536393 defendant Dawson William yeoman 604286 604286 Dawson, William, of Mirfeld, yeoman 5

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);