names

65 rows where place_id = 600793

✎ 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
3642582 1908123 1908123 defendant Hill John gent 600793 600793 Hill, John, of Hameldon, gent 0
3656476 1912272 1912272 defendant Hyll John gent 600793 600793 Hyll, John, of Hameldon, gent 0
3733890 1936847 1936847 defendant Jonys Walter tailor 600793 600793 Jonys, Walter, of Hameldon, tailor 0
3736644 1937713 1937713 defendant Parker Richard tanner 600793 600793 Parker, Richard, of Hameldon, tanner 0
3736645 1937713 1937713 defendant Makenes Richard tanner 600793 600793 Makenes, Richard, of Hameldon, tanner 1
3775842 1950195 1950195 defendant Jure Richard butcher 600793 600793 Jure, Richard, of Hameldon, butcher 0
4436385 2176118 2176118 defendant Morcote Ralph de   600793 600793 Morcote, Ralph de, of Hameldon, vicar 0
4454564 2186445 2186445 defendant Shovelere William   600793 600793 Shovelere, William, of Hameldon 0
4454566 2186446 2186446 defendant Shavelere William   600793 600793 Shavelere, William, of Hameldon 0
4467389 2190481 2190481 defendant atte Vikers Ann   600793 600793 atte Vikers, Ann, of Hameldon 0
4492032 2198195 2198195 defendant Wayte Richard   600793 600793 Wayte, Richard, of Hameldon, son of Philip Wayte 0
4498588 2200201 2200201 defendant Dene Thomas   600793 600793 Dene, Thomas, of Hameldon, mason 0
4541726 2213305 2213305 defendant Wayte Richard   600793 600793 Wayte, Richard, of Hameldon, son of Philip Wayte 0
4552455 2216725 2216725 defendant Bardolf John   600793 600793 Bardolf, John, of Hameldon 0
4595296 2229781 2229781 plaintiff Raynold John   600793 600793 Raynold, John, of Hameldon 0
4595297 2229781 2229781 defendant Cook Thomas   600793 600793 Cook, Thomas, of Hameldon 0
4605584 2232865 2232865 plaintiff Arnold William   600793 600793 Arnold, William, of Hameldon 0
4621232 2237629 2237629 defendant atte Mille William   600793 600793 atte Mille, William, of Hameldon 0
4831384 2305847 2305847 defendant Bulle Theobald butcher 600793 600793 Bulle, Theobald, of Hameldon, butcher 0
4832831 2306291 2306291 defendant Bole Theobald butcher 600793 600793 Bole, Theobald, of Hameldon, butcher 1
4836101 2307270 2307270 defendant Fryth Thomas tailor 600793 600793 Fryth, Thomas, of Hameldon, tailor 1
4853358 2312461 2312461 defendant Caunes Thomas husbandman 600793 600793 Caunes, Thomas, of Hameldon, husbandman 2
4853363 2312462 2312462 defendant Turnour Thomas butcher 600793 600793 Turnour, Thomas, of Hameldon, butcher 3
4855674 2313145 2313145 defendant Strodewyk John glasier 600793 600793 Strodewyk, John, of Hameldon, glasier 0
4860403 2314617 2314617 defendant Soundy William husbandman 600793 600793 Soundy, William, of Hameldon, husbandman 0
4871439 2318031 2318031 defendant Strodewyk Richard   600793 600793 Strodewyk, Richard, of Hameldon, servant 2
4871440 2318031 2318031 defendant Strodewyk Thomas   600793 600793 Strodewyk, Thomas, of Hameldon, servant 3
4881197 2321023 2321023 defendant Russell John laborer 600793 600793 Russell, John, of Hameldon, laborer 3
4881199 2321023 2321023 defendant Smyth Richard laborer 600793 600793 Smyth, Richard, of Hameldon, laborer 5
4912386 2330376 2330376 defendant Rede John wheeler 600793 600793 Rede, John, of Hameldon, wheeler 0
4920960 2333068 2333068 defendant Worther Lawrence fuller 600793 600793 Worther, Lawrence, of Hameldon, fuller 0
4939333 2338683 2338683 defendant Andrewe William husbandman 600793 600793 Andrewe, William, of Hameldon, husbandman 0
4939334 2338683 2338683 defendant Rawelyn Robert husbandman 600793 600793 Rawelyn, Robert, of Hameldon, husbandman 1
4952090 2342591 2342591 defendant Freytheby or Freycheby John husbandman 600793 600793 Freytheby or Freycheby, John, of Hameldon, husbandman 0
4953409 2342985 2342985 defendant Brigge Richard husbandman 600793 600793 Brigge, Richard, of Hameldon, husbandman 0
4953410 2342985 2342985 defendant Brigge William husbandman 600793 600793 Brigge, William, of Hameldon, husbandman 1
4953413 2342986 2342986 defendant Brigge Richard husbandman 600793 600793 (Brigge, Richard, of Hameldon, husbandman 1
4953414 2342986 2342986 defendant Brigge William husbandman 600793 600793 Brigge, William, of Hameldon, husbandman 2
4955292 2343541 2343541 defendant Beteson Richard husbandman 600793 600793 Beteson, Richard, of Hameldon, husbandman 0
4955293 2343541 2343541 defendant Clerk John husbandman 600793 600793 Clerk, John, of Hameldon, husbandman 1
4955294 2343541 2343541 defendant atte Halle John husbandman 600793 600793 atte Halle, John, of Hameldon, husbandman 2
4955295 2343541 2343541 defendant Roos John, junior husbandman 600793 600793 Roos, John, junior, of Hameldon, husbandman 3
4955296 2343541 2343541 defendant Brigge William husbandman 600793 600793 Brigge, William, of Hameldon, husbandman 4
4955297 2343541 2343541 defendant Kewe Robert husbandman 600793 600793 Kewe, Robert, of Hameldon, husbandman 5
4955298 2343541 2343541 defendant Kelby Richard husbandman 600793 600793 Kelby, Richard, of Hameldon, husbandman 6
4955299 2343541 2343541 defendant Crossewell John husbandman 600793 600793 Crossewell, John, of Hameldon, husbandman 7
4955300 2343541 2343541 defendant Andrewe John husbandman 600793 600793 Andrewe, John, of Hameldon, husbandman 8
4970063 2347994 2347994 defendant Wymbyssh John gent 600793 600793 Wymbyssh, John, of Hameldon, gent 0
5023062 2363652 2363652 defendant Douse or Donse Thomas chapman 600793 600793 Douse or Donse, Thomas, of Hameldon, chapman 1
5048491 2371188 2371188 defendant Hardevyle Nicholas husbandman 600793 600793 Hardevyle, Nicholas, of Hameldon, husbandman 0
5151496 2401588 2401588 defendant Worthye Thomas chapman 600793 600793 Worthye, Thomas, of Hameldon, chapman 0
5151498 2401588 2401588 defendant Hegger John, sen husbandman 600793 600793 Hegger, John, sen, of Hameldon, husbandman 2
5186140 2411696 2411696 defendant Payne John husbandman 600793 600793 Payne, John, of Hameldon, husbandman 0
5186152 2411700 2411700 defendant Payne John husbandman 600793 600793 Payne, John, of Hameldon, husbandman 0
5201542 2416209 2416209 defendant Cammes Thomas husbandman 600793 600793 Cammes, Thomas, of Hameldon, husbandman 1
5236502 2426262 2426262 defendant Milward John chapman 600793 600793 Milward, John, of Hameldon, chapman 1
5255387 2431801 2431801 defendant Furneus or Furnens John butcher 600793 600793 Furneus or Furnens, John, of Hameldon, butcher 0
5319370 2450885 2450885 defendant Collys Richard husbandman 600793 600793 Collys, Richard, of Hameldon, husbandman 3
5386825 2471297 2471297 defendant Shalden Thomas yeoman 600793 600793 Shalden, Thomas, of Hameldon, yeoman 0
5399263 2474860 2474860 defendant Shalden Thomas yeoman 600793 600793 Shalden, Thomas, of Hameldon, yeoman 0
5411574 2478417 2478417 defendant Ryng Andrew laborer 600793 600793 Ryng, Andrew, of Hameldon, laborer 0
5515332 2509640 2509640 defendant Salter John yeoman 600793 600793 Salter, John, of Hameldon, yeoman 0
5610145 2546882 2546882 plaintiff atte Hulle Thomas   600793 600793 atte Hulle, Thomas, of Hameldon 0
5612830 2547772 2547772 plaintiff Clere William (legal representative) 600793 600793 Clere, William, of Hameldon, formerly vicar, executors of 0
5612833 2547772 2547772 defendant Welles William   600793 600793 Welles, William, of Hameldon, vicar 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);