names

59 rows where place_id = 610195

✎ 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
3682392 1920593 1920593 defendant Flegge Henry turner 610195 610195 Flegge, Henry, of Hanworth, turner 2
3690781 1923282 1923282 defendant Reculver Agnes widow 610195 610195 Reculver, Agnes, of Hanworth, widow 4
3776270 1950324 1950324 plaintiff Browne Thomas   610195 610195 Browne, Thomas, of Hanworth 0
3861056 1977181 1977181 defendant Starlyng William husbandman 610195 610195 Starlyng, William, of Hanworth, husbandman 0
3945336 2005452 2005452 defendant Sheriffe Thomas yeoman 610195 610195 Sheriffe, Thomas, of Hanworth, yeoman 0
4150858 2078432 2078432 defendant Oldfelde Christopher laborer 610195 610195 Oldfelde, Christopher, of Hanworth alias Potter, laborer 1
4171888 2085629 2085629 defendant Daglas Richard yeoman 610195 610195 Daglas, Richard, of Hanworth, yeoman 1
4216068 2101114 2101114 defendant Blowfeild Margaret spinster 610195 610195 Blowfeild, Margaret, of Hanworth, spinster 1
4318802 2136691 2136691 defendant Jackson Charles husbandman 610195 610195 together with Jackson, Charles, of Hanworth, husbandman 1
4373134 2155459 2155459 defendant Sherife Robert yeoman 610195 610195 Sherife, Robert, of Hanworth, yeoman 0
4456296 2186992 2186992 defendant Smyth William (legal representative) 610195 610195 Smyth, William, of Hanworth, executor of 0
4543173 2213747 2213747 defendant Grevelle John   610195 610195 Grevelle, John, of Hanworth 1
4555518 2217656 2217656 defendant Kyng William   610195 610195 Kyng, William, of Hanworth 0
4555616 2217685 2217685 defendant Trewelove John   610195 610195 Trewelove, John, of Hanworth 0
4684327 2260703 2260703 defendant Bedale John   610195 610195 Bedale, John, of Hanworth, friary clerk 0
4686388 2261347 2261347 defendant Pynchum Thomas smith 610195 610195 Pynchum, Thomas, of Hanworth, smith 3
4696761 2264465 2264465 defendant Aunfleys John weaver 610195 610195 Aunfleys, John, of Hanworth, weaver 3
4749278 2280269 2280269 defendant Wodereve John husbandman 610195 610195 Wodereve, John, of Hanworth, bailiff, Belys, John, of Southfeld, husbandman 3
4775705 2288398 2288398 defendant Fayrenogh Nicholas husbandman 610195 610195 Fayrenogh, Nicholas, of Hanworth, husbandman 0
4781695 2290287 2290287 defendant Kyng Richard husbandman 610195 610195 Kyng, Richard, of Hanworth, husbandman 1
4830750 2305646 2305646 defendant Soteby Robert husbandman 610195 610195 Soteby, Robert, of Hanworth, husbandman 0
4830751 2305646 2305646 defendant Soteby John husbandman 610195 610195 Soteby, John, of Hanworth, husbandman 1
4830752 2305646 2305646 defendant Trusse John laborer 610195 610195 Trusse, John, of Hanworth, laborer 2
4849459 2311306 2311306 defendant Soterby John husbandman 610195 610195 Soterby, John, of Hanworth, husbandman 0
4874755 2319047 2319047 defendant Somer William yeoman 610195 610195 Somer, William, of Hanworth, yeoman 1
4949845 2341939 2341939 defendant Roke John, senior yeoman 610195 610195 Roke, John, senior, of Hanworth, yeoman 3
4956026 2343768 2343768 defendant Doughty Cecily widow 610195 610195 Doughty, Cecily, of Hanworth, widow 0
5026521 2364637 2364637 defendant Marnham Robert clerk 610195 610195 Marnham, Robert, of Hanworth, clerk 2
5026525 2364638 2364638 defendant Marnham Robert clerk 610195 610195 Marnham, Robert, of Hanworth, clerk 2
5088394 2382982 2382982 defendant More William capman 610195 610195 More, William, of Hanworth, capman 1
5107515 2388628 2388628 plaintiff Doraunt Margaret   610195 610195 Doraunt, Margaret, of Hanworth, administrators of 0
5107516 2388628 2388628 plaintiff Kyng William   610195 610195 (Kyng, William, of Hanworth 1
5107517 2388628 2388628 plaintiff Ynstas or Yustas William   610195 610195 Ynstas or Yustas, William, of Hanworth 2
5148664 2400732 2400732 defendant Eustas William   610195 610195 Eustas, William, of Hanworth 0
5184117 2411092 2411092 plaintiff Doughty Robert   610195 610195 Doughty, Robert, of Hanworth, bailiff of the manor 0
5219435 2421412 2421412 defendant Eustace William husbandman 610195 610195 Eustace, William, of Hanworth, husbandman 0
5219436 2421412 2421412 defendant Kyng William husbandman 610195 610195 Kyng, William, of Hanworth, husbandman 1
5288219 2441569 2441569 plaintiff Kyng William   610195 610195 Kyng, William, of Hanworth 1
5288220 2441569 2441569 defendant Ynstas or Enstas or Eustas William husbandman 610195 610195 Ynstas or Enstas or Eustas, William, of Hanworth, husbandman 0
5288221 2441569 2441569 defendant Beteryng John husbandman 610195 610195 Beteryng, John, of Hanworth, husbandman 1
5299465 2444821 2444821 defendant Pekhill John yeoman 610195 610195 Pekhill, John, of Hanworth, yeoman 0
5300074 2444987 2444987 defendant Kyng William husbandman 610195 610195 Kyng, William, of Hanworth, husbandman 3
5314664 2449420 2449420 defendant Kyng William husandman 610195 610195 Kyng, William, of Hanworth, husandman 0
5316618 2450055 2450055 plaintiff Doughty Robert   610195 610195 Doughty, Robert, of Hanworth 0
5320779 2451305 2451305 plaintiff Kyng William   610195 610195 Kyng, William, of Hanworth 0
5343856 2458264 2458264 defendant Bysshop Richard chaplain 610195 610195 Bysshop, Richard, of Hanworth, chaplain 0
5350767 2460350 2460350 defendant Kyng William husbandman 610195 610195 Kyng, William, of Hanworth, husbandman 1
5355015 2461638 2461638 defendant Kyng William husbandman 610195 610195 Kyng, William, of Hanworth, husbandman 0
5386970 2471340 2471340 plaintiff Doughty Thomas   610195 610195 Doughty, Thomas, of Hanworth 1
5399430 2474914 2474914 plaintiff Doughty Thomas   610195 610195 Doughty, Thomas, of Hanworth 1
5444677 2488310 2488310 defendant Hoggeson Thomas clerk 610195 610195 Hoggeson, Thomas, of Hanworth, clerk 0
5451429 2490301 2490301 defendant Haley Thomas husbandman 610195 610195 Haley, Thomas, of Hanworth, husbandman 3
5454152 2491139 2491139 defendant Kyng William   610195 610195 Kyng, William, of Hanworth 0
5463448 2493976 2493976 defendant Haley Thomas husbandman 610195 610195 Haley, Thomas, of Hanworth, husbandman 3
5469524 2495809 2495809 plaintiff Doughty Thomas   610195 610195 Doughty, Thomas, of Hanworth 1
5469527 2495810 2495810 plaintiff Doughty Thomas   610195 610195 Doughty, Thomas, of Hanworth 1
5489317 2501691 2501691 defendant Beteryng Stephen husbandman 610195 610195 Beteryng, Stephen, of Hanworth, husbandman 0
5550829 2520274 2520274 defendant More John husbandman 610195 610195 More, John, of Hanworth, husbandman 1
5597410 2534092 2534092 defendant Howse John laborer 610195 610195 Howse, John, of Hanworth, laborer 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);