names

79 rows where place_id = 589045

✎ 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
3596171 1866433 1866433 defendant Skeven John husbandman 589045 589045 Skeven, John, of Possewyk, laborer, son of Skeven, John, husbandman 0
3596367 1866496 1866496 defendant Thursfeld William husbandman 589045 589045 Thursfeld, William, of Possewyk, husbandman 4
3603278 1868698 1868698 defendant Clyfton Henry clerk 589045 589045 Clyfton, Henry, of Possewyk, clerk 1
3605721 1869452 1869452 defendant Thurkeld William   589045 589045 Thurkeld, William, of Possewyk, tile burner 0
3605722 1869452 1869452 defendant Thurkeld John yeoman 589045 589045 Thurkeld, John, of Possewyk, yeoman 1
3605723 1869452 1869452 defendant Amys Richard husbandman 589045 589045 Amys, Richard, of Possewyk, husbandman 2
3608079 1870179 1870179 plaintiff Spany or Spavy John (legal representative) 589045 589045 Spany or Spavy, John, of Possewyk, executors of 0
3609096 1870502 1870502 defendant Clyfton Henry clerk 589045 589045 Clyfton, Henry, of Possewyk, clerk 2
3609097 1870502 1870502 defendant Amys Richard husbandman 589045 589045 Amys, Richard, of Possewyk, husbandman 3
3609098 1870502 1870502 defendant Amys William husbandman 589045 589045 Amys, William, of Possewyk, husbandman 4
3614054 1872057 1872057 defendant Waren Andrew laborer 589045 589045 Waren, Andrew, of Possewyk, laborer 0
3614055 1872057 1872057 defendant Amys Richard husbandman 589045 589045 Amys, Richard, of Possewyk, husbandman 1
3621973 1874415 1874415 defendant Amys Richard husbandman 589045 589045 Amys, Richard, of Possewyk, husbandman 0
3621974 1874415 1874415 defendant Amys William laborer 589045 589045 Amys, William, of Possewyk, laborer 1
3630639 1904412 1904412 defendant Skevyn Robert husbandman 589045 589045 Skevyn, Robert, of Possewyk, husbandman 1
3647866 1909729 1909729 defendant Skeveyn John husbandman 589045 589045 Skeveyn, John, of Possewyk, husbandman 0
3647872 1909730 1909730 defendant Skeveyn John husbandman 589045 589045 Skeveyn, John, of Possewyk, husbandman 0
3668463 1916088 1916088 defendant Skeveyn John husbandman 589045 589045 Skeveyn, John, of Possewyk, husbandman 3
3670937 1916878 1916878 defendant Spany Robert husbandman 589045 589045 Spany, Robert, of Possewyk, husbandman 0
3762751 1945990 1945990 defendant York Henry husbandman 589045 589045 York, Henry, of Possewyk, husbandman 0
3762757 1945991 1945991 defendant Yorke Henry husbandman 589045 589045 Yorke, Henry, of Possewyk, husbandman 0
4553610 2217055 2217055 defendant Topcroft Hugh   589045 589045 Topcroft, Hugh, of Possewyk 0
4626433 2239218 2239218 defendant Large Richard   589045 589045 Large, Richard, of Possewyk 0
4626435 2239219 2239219 defendant Large Richard   589045 589045 Large, Richard, of Possewyk 0
4639144 2242965 2242965 defendant atte Yates Richard   589045 589045 atte Yates, Richard, of Possewyk 3
4639145 2242965 2242965 defendant Spanye John   589045 589045 Spanye, John, of Possewyk 4
4644280 2244417 2244417 defendant atte Yates Richard   589045 589045 atte Yates, Richard, of Possewyk 2
4665018 2250539 2250539 defendant Hervy Thomas yeoman 589045 589045 Hervy, Thomas, of Possewyk, yeoman 1
4680834 2259628 2259628 defendant Knape John boatman 589045 589045 Knape, John, of Possewyk, boatman 0
4816066 2301117 2301117 plaintiff Loot Thomas   589045 589045 Loot, Thomas, of Possewyk 0
4816067 2301117 2301117 defendant Thurkeld John carpenter 589045 589045 Thurkeld, John, of Possewyk, carpenter 0
4816068 2301117 2301117 defendant Thurkeld Robert yeoman 589045 589045 Thurkeld, Robert, of Possewyk, yeoman 1
4820298 2302418 2302418 defendant Thurkheld John husbandman 589045 589045 Thurkheld, John, of Possewyk, husbandman 0
4835917 2307217 2307217 defendant Rawelyns John husbandman 589045 589045 Rawelyns, John, of Possewyk, husbandman 0
4839234 2308199 2308199 defendant Knape John, sen husbandman 589045 589045 Knape, John, sen, of Possewyk, husbandman 0
4863082 2315433 2315433 defendant Drake Joan widow 589045 589045 Drake, Joan, of Possewyk, widow 1
4901171 2326980 2326980 defendant Amys John husbandman 589045 589045 Amys, John, of Possewyk, husbandman 0
4906664 2328670 2328670 defendant Thurkeld John husbandman 589045 589045 Thurkeld, John, of Possewyk, husbandman 4
4906665 2328670 2328670 defendant Godeson James husbandman 589045 589045 Godeson, James, of Possewyk, husbandman 5
4909614 2329540 2329540 defendant Lungy John yeoman 589045 589045 Lungy, John, of Possewyk, yeoman 3
4933089 2336743 2336743 defendant Thurkeld John yeoman 589045 589045 Thurkeld, John, of Possewyk, yeoman 0
4933090 2336743 2336743 defendant Thurkeld Thomas yeoman & son of John 589045 589045 Thurkeld, Thomas, of Possewyk, yeoman & son of John 1
4938834 2338536 2338536 defendant Alfeld Wiot courser 589045 589045 Alfeld, Wiot, of Possewyk, courser 0
4944194 2340154 2340154 defendant Knape John, senior husbandman 589045 589045 Knape, John, senior, of Possewyk, husbandman 0
4946565 2340922 2340922 defendant Thurkeld John carpenter 589045 589045 Thurkeld, John, of Possewyk, carpenter 0
4985037 2352455 2352455 defendant Woderove Henry husbandman 589045 589045 Woderove, Henry, of Possewyk, husbandman 7
4986796 2352989 2352989 defendant Thurkeld John yeoman 589045 589045 Thurkeld, John, of Possewyk, yeoman 1
5012884 2360602 2360602 plaintiff Alfeld William   589045 589045 Alfeld, William, of Possewyk 0
5066371 2376467 2376467 defendant Thurkeld John, senior husbandman 589045 589045 Thurkeld, John, senior, of Possewyk, husbandman 0
5068265 2377013 2377013 defendant Thurkyld Thomas husbandman 589045 589045 Thurkyld, Thomas, of Possewyk, husbandman 0
5072352 2378217 2378217 defendant Alfeld Guy husbandman 589045 589045 Alfeld, Guy, of Possewyk, husbandman 2
5072353 2378217 2378217 defendant Skyveyn Richard husbandman 589045 589045 Skyveyn, Richard, of Possewyk, husbandman 3
5093095 2384369 2384369 defendant Alfeld Wiotus husbandman 589045 589045 Alfeld, Wiotus, of Possewyk, husbandman 0
5116356 2391211 2391211 defendant Thurkeld John husbandman 589045 589045 Thurkeld, John, of Possewyk, husbandman 4
5130109 2395294 2395294 defendant Frede John   589045 589045 Frede, John, of Possewyk 0
5130110 2395294 2395294 defendant Frede Robert laborer 589045 589045 Frede, Robert, of Possewyk, laborer 1
5149425 2400965 2400965 defendant Frede John husbandman 589045 589045 Frede, John, of Possewyk, husbandman 0
5149426 2400965 2400965 defendant Frede Robert laborer 589045 589045 Frede, Robert, of Possewyk, laborer 1
5229370 2424201 2424201 defendant Alfeld Wiotus husbandman 589045 589045 Alfeld, Wiotus, of Possewyk, husbandman 0
5233018 2425238 2425238 defendant Thurkeld William yeoman 589045 589045 Thurkeld, William, of Possewyk, yeoman 3
5249090 2429853 2429853 defendant Alfeld Wiot yeoman 589045 589045 Alfeld, Wiot, of Possewyk, yeoman 1
5256919 2432293 2432293 defendant Skeven or Skenen Richard (legal representative) 589045 589045 Skeven or Skenen, Richard, of Possewyk, husbandman, executors of 3
5262573 2434037 2434037 defendant Alfeld Guy (legal representative) 589045 589045 Alfeld, Guy, of Possewyk, husbandman, executors of 0
5262574 2434037 2434037 defendant Alfeld Christine widow 589045 589045 (Alfeld, Christine, of Possewyk, widow 1
5262575 2434037 2434037 defendant Alfeld Robert laborer 589045 589045 Alfeld, Robert, of Possewyk, laborer 2
5280241 2439297 2439297 defendant Thurkeld Thomas husbandman 589045 589045 Thurkeld, Thomas, of Possewyk, husbandman 0
5297471 2444263 2444263 defendant Tryppe John husbandman 589045 589045 Tryppe, John, of Possewyk, husbandman 0
5311603 2448494 2448494 defendant Baxter alias Barber John (legal representative) 589045 589045 Baxter alias Barber, John, of Possewyk, husbandman, executors of 0
5366957 2465315 2465315 defendant Thurkeld William husbandman 589045 589045 Thurkeld, William, of Possewyk, husbandman 1
5374394 2467594 2467594 defendant Thurkeld William husbandman 589045 589045 Thurkeld, William, of Possewyk, husbandman 0
5436076 2485729 2485729 defendant Amys Richard husbandman 589045 589045 Amys, Richard, of Possewyk, husbandman 1
5440314 2487005 2487005 defendant Amys Richard yeoman 589045 589045 Amys, Richard, of Possewyk, yeoman 2
5453766 2491017 2491017 defendant Thurkell Katherine widow 589045 589045 Thurkell, Katherine, of Possewyk, widow 10
5454222 2491166 2491166 defendant Amys (illegible) husbandman 589045 589045 Amys, _, of Possewyk, husbandman 1
5454422 2491232 2491232 defendant Amys William yeoman 589045 589045 Amys, William, of Possewyk, yeoman 1
5477153 2498173 2498173 defendant Thurkell Katheine widow 589045 589045 Thurkell, Katheine, of Possewyk, widow 8
5526302 2512804 2512804 defendant Thyrkyld John husbandman 589045 589045 Thyrkyld, John,of Possewyk, husbandman 3
5531673 2514440 2514440 defendant Skenen or Skeven John, junior husbandman 589045 589045 Skenen or Skeven, John, junior, of Possewyk, husbandman 0
5601788 2535461 2535461 defendant Skeveyne Robert husbandman 589045 589045 Skeveyne, Robert, of Possewyk, husbandman 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);