names

44 rows where place_id = 596879

✎ 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
3626491 1903139 1903139 defendant Hoo John yeoman 596879 596879 Hoo, John, of Bradeley, yeoman 8
3691023 1923357 1923357 defendant Hirst James, junior clothier 596879 596879 Hirst, James, junior, of Bradeley, clothier 0
3701252 1926634 1926634 defendant Alexan or Alexander Robert chaplain 596879 596879 Alexan or Alexander, Robert, of Bradeley, chaplain 0
3701392 1926682 1926682 defendant Hoxwode Richard husbandman 596879 596879 Hoxwode, Richard, of Bradeley, husbandman 0
3735333 1937286 1937286 defendant Jenyns Thomas husbandman 596879 596879 Jenyns, Thomas, of Bradeley, husbandman 0
3764323 1946504 1946504 defendant Flemmyng William husbandman 596879 596879 Flemmyng, William, of Bradeley, husbandman 0
3785296 1953188 1953188 defendant Pylkyngton Arthur esq 596879 596879 Pylkyngton, Arthur, of Bradeley, esq 0
3797309 1957047 1957047 defendant Broke William tanner 596879 596879 Broke, William, of Bradeley, tanner 0
3950720 2007325 2007325 defendant Pegg Edward yeoman 596879 596879 Pegg, Edward, of Bradeley, yeoman 0
3967551 2013283 2013283 defendant Dyckynson Richard gent 596879 596879 Dyckynson, Richard, of Bradeley, gent 0
3997427 2023825 2023825 defendant Turner Richard husbandman 596879 596879 Turner, Richard, of Bradeley, husbandman 0
3997428 2023825 2023825 defendant Cartwright John husbandman 596879 596879 Cartwright, John, of Bradeley, husbandman 1
4163723 2082836 2082836 defendant Dickenson Richard gent 596879 596879 Dickenson, Richard, of Bradeley, gent 0
4163725 2082837 2082837 defendant Dickenson Richard gent 596879 596879 Dickenson, Richard, of Bradeley, gent 0
4215813 2101028 2101028 defendant Chewe Simon husbandman 596879 596879 Chewe, Simon, of Bradeley, husbandman 0
4215814 2101028 2101028 defendant Sherley Richard husbandman 596879 596879 Sherley, Richard, of Bradeley, husbandman 1
4215815 2101028 2101028 defendant Heigham James husbandman 596879 596879 Heigham, James, of Bradeley, husbandman 2
4215816 2101028 2101028 defendant Chewe John husbandman 596879 596879 Chewe, John, of Bradeley, husbandman 3
4218896 2102105 2102105 defendant Dickenson Simon gent 596879 596879 Dickenson, Simon, of Bradeley, gent 1
4331517 2140836 2140836 defendant Harvey Robert husbandman 596879 596879 Harvey, Robert, of Bradeley, husbandman 1
4340803 2144056 2144056 defendant Sherley Robert husbandman 596879 596879 Sherley, Robert, of Bradeley, husbandman 0
4395530 2163086 2163086 defendant Owley Richard yeoman 596879 596879 Owley, Richard, of Bradeley, yeoman 0
4397911 2163878 2163878 defendant Wolley or Owley Richard yeoman 596879 596879 Wolley or Owley, Richard, of Bradeley, yeoman 1
4405671 2166465 2166465 defendant Wolley Richard husbandman 596879 596879 Wolley, Richard, of Bradeley, husbandman 0
4519091 2206327 2206327 defendant Davy Walter   596879 596879 Davy, Walter, of Bradeley 0
4545098 2214384 2214384 defendant Mary Roger   596879 596879 Mary, Roger, of Bradeley 6
4661932 2249578 2249578 defendant Aspeley Thomas husbandman 596879 596879 Aspeley, Thomas, of Bradeley, husbandman 2
4773433 2287663 2287663 defendant Amy Richard   596879 596879 Amy, Richard, of Bradeley, bailiff 2
4775004 2288179 2288179 defendant Hokyns alias Page John husbandman 596879 596879 Hokyns alias Page, John, of Bradeley, husbandman 0
4827337 2304598 2304598 defendant Rogers Thomas husbandman 596879 596879 Rogers, Thomas, of Bradeley, husbandman 0
4827372 2304609 2304609 defendant Rogers Thomas husbandman 596879 596879 Rogers, Thomas, of Bradeley, husbandman 0
4898978 2326324 2326324 defendant Pynner John husbandman 596879 596879 Pynner, John, of Bradeley, husbandman 2
4941965 2339471 2339471 plaintiff Faukes William clerk 596879 596879 Faukes, William, of Bradeley, clerk 0
5027737 2364990 2364990 defendant atte Hethe John husbandman 596879 596879 atte Hethe, John, of Bradeley, husbandman 0
5126821 2394318 2394318 plaintiff Brocas William   596879 596879 Brocas, William, of Bradeley 0
5145513 2399832 2399832 plaintiff Brocas William   596879 596879 Brocas, William, of Bradeley 0
5163634 2405101 2405101 defendant Jorce Thomas gent 596879 596879 Jorce, Thomas, of Bradeley, gent 0
5165918 2405777 2405777 plaintiff Brocas William   596879 596879 Brocas, William, of Bradeley 0
5267181 2435496 2435496 defendant Kneton Henry esq 596879 596879 Kneton, Henry, of Bradeley, esq 0
5515233 2509611 2509611 defendant Belham William husbandman 596879 596879 Belham, William, of Bradeley, husbandman 1
5515234 2509611 2509611 defendant Smyth John husbandman 596879 596879 Smyth, John, of Bradeley, husbandman 2
5527485 2513178 2513178 defendant Wyncher Hugh smith 596879 596879 Wyncher, Hugh, of Bradeley, smith 5
5581349 2529235 2529235 defendant Shyraker Roger husbandman 596879 596879 Shyraker, Roger, of Bradeley, husbandman 6
5625682 2551975 2551975 defendant Boteller Robert ploughman 596879 596879 Boteller, Robert, of Bradeley, ploughman 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);