names

44 rows where place_id = 586463

✎ 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
3588786 1864137 1864137 defendant Coke Richard yeoman 586463 586463 Coke, Richard, of Bedyngton, yeoman 0
3588787 1864137 1864137 defendant Stapele William cooper 586463 586463 Stapele, William, of Bedyngton, cooper 1
3589101 1864239 1864239 defendant Brighrede William yeoman 586463 586463 Brighrede, William, of Bedyngton, yeoman 2
3611337 1871218 1871218 defendant Cutby William laborer 586463 586463 Cutby, William, of Bedyngton, laborer 2
3611338 1871218 1871218 defendant Wydale William laborer 586463 586463 Wydale, William, of Bedyngton, laborer 3
3611339 1871218 1871218 defendant Akyrman John laborer 586463 586463 Akyrman, John, of Bedyngton, laborer 4
3615893 1872610 1872610 plaintiff Cowper John   586463 586463 Cowper, John, of Bedyngton 0
3615895 1872611 1872611 plaintiff Cowper John   586463 586463 Cowper, John, of Bedyngton 0
3619647 1873714 1873714 defendant Cutby William laborer 586463 586463 Cutby, William, of Bedyngton, laborer 2
3619648 1873714 1873714 defendant Tailler John laborer 586463 586463 Tailler, John, of Bedyngton, laborer 3
3619649 1873714 1873714 defendant Wydale William laborer 586463 586463 Wydale, William, of Bedyngton, laborer 4
3619650 1873714 1873714 defendant Akyrman John laborer 586463 586463 Akyrman, John, of Bedyngton, laborer 5
3877641 1982763 1982763 defendant East George miller 586463 586463 East, George, of Bedyngton, miller 0
4002733 2025743 2025743 defendant Marvyn Thomas yeoman 586463 586463 Marvyn, Thomas, of Bedyngton, yeoman 1
4405847 2166518 2166518 defendant Richbell William yeoman 586463 586463 Richbell, William, of Bedyngton, yeoman 0
4462513 2188971 2188971 defendant Mulleward Henry   586463 586463 Mulleward, Henry, of Bedyngton, servant of Huwe 1
4575113 2223738 2223738 plaintiff Snell John   586463 586463 Snell, John, of Bedyngton 1
4748821 2280142 2280142 defendant Byfeld Idonea   586463 586463 Byfeld, Idonea, of Bedyngton, servant 0
4811540 2299719 2299719 plaintiff Garren Nicholas, senior   586463 586463 Garren, Nicholas, senior, of Bedyngton, on his own account 0
4830656 2305612 2305612 plaintiff Bole Alice   586463 586463 Bole, Alice, of Bedyngton 0
4830657 2305612 2305612 defendant Topclif John husbandman 586463 586463 Topclif, John, of Bedyngton, husbandman 0
5026952 2364753 2364753 defendant Carrewe Nicholas esq 586463 586463 Carrewe, Nicholas, of Bedyngton, esq 0
5031038 2365954 2365954 defendant Carrewe Nicholas esq 586463 586463 Carrewe, Nicholas, of Bedyngton, esq 0
5165756 2405728 2405728 defendant Doget Henry laborer 586463 586463 Doget, Henry, of Bedyngton, laborer 2
5218523 2421149 2421149 defendant Carrewe Nicholas esq 586463 586463 Carrewe, Nicholas, of Bedyngton, esq 0
5218525 2421150 2421150 defendant Carrewe Nicholas esq 586463 586463 Carrewe, Nicholas, of Bedyngton, esq 0
5228268 2423876 2423876 defendant Tanner Richard clerk 586463 586463 Tanner, Richard, of Bedyngton, clerk 0
5253900 2431333 2431333 defendant Carrewe Nicholas   586463 586463 Carrewe, Nicholas, of Bedyngton, esq, administrators of 0
5253901 2431333 2431333 defendant Chaunterell John yeoman 586463 586463 (Chaunterell, John, of Bedyngton, yeoman 1
5349668 2460030 2460030 defendant Bonewyk William husbandman 586463 586463 Bonewyk, William, of Bedyngton, husbandman 0
5349669 2460030 2460030 defendant Derby alias Wodset John, junior husbandman 586463 586463 Derby alias Wodset, John, junior, of Bedyngton, husbandman 1
5371348 2466617 2466617 defendant Davy Richard husbandman 586463 586463 Davy, Richard, of Bedyngton, husbandman 0
5403210 2476000 2476000 defendant Broke William husbandman 586463 586463 Broke, William, of Bedyngton, husbandman 3
5411043 2478257 2478257 defendant Derby John husbandman 586463 586463 Derby, John, of Bedyngton, husbandman 4
5415763 2479652 2479652 defendant Broke William   586463 586463 Broke, William, of Bedyngton 3
5432949 2484823 2484823 defendant Broke William husbandman 586463 586463 Broke, William, of Bedyngton, husbandman 3
5432955 2484824 2484824 defendant Broke William husbandman 586463 586463 Broke, William, of Bedyngton, husbandman 3
5453617 2490972 2490972 defendant Denys Walter esq 586463 586463 Denys, Walter, of Bedyngton, esq 0
5478024 2498450 2498450 defendant Bonwyk William yeoman 586463 586463 Bonwyk, William, of Bedyngton, yeoman 0
5501051 2505262 2505262 defendant Bryghtrede William husbandman 586463 586463 Bryghtrede, William, of Bedyngton, husbandman 2
5501052 2505262 2505262 defendant Derby John husbandman 586463 586463 Derby, John, of Bedyngton, husbandman 3
5511336 2508389 2508389 defendant Bowemer Nicholas laborer 586463 586463 Bowemer, Nicholas, of Bedyngton, laborer 0
5511337 2508389 2508389 defendant Smyth John laborer 586463 586463 Smyth, John, of Bedyngton, laborer 1
5536403 2515875 2515875 defendant Carewe Richard   586463 586463 Carewe, Richard, of Bedyngton, knight 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);