names

202 rows where place_id = 601931

✎ 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
3647731 1909680 1909680 defendant Hyper Thomas yeoman 601931 601931 Hyper, Thomas, of Sutton in Holand, yeoman 0
3655403 1911949 1911949 defendant Hyppe William yeoman 601931 601931 Hyppe, William, of Sutton in Holand, yeoman 0
3660858 1913664 1913664 defendant Wylson Thomas yeoman 601931 601931 Wylson, Thomas, of Sutton in Holand, yeoman 0
3660918 1913684 1913684 defendant Wylson Thomas yeoman 601931 601931 Wylson, Thomas, of Sutton in Holand, yeoman 0
4463018 2189136 2189136 defendant Souter Thomas   601931 601931 Souter, Thomas, of Sutton in Holand 0
4466382 2190150 2190150 defendant Watson William   601931 601931 Watson, William, of Sutton in Holand 0
4474814 2192796 2192796 plaintiff Dygill John   601931 601931 Dygill, John, of Sutton in Holand 0
4474823 2192800 2192800 plaintiff Dygyll John   601931 601931 Dygyll, John, of Sutton in Holand 0
4492368 2198292 2198292 plaintiff Wytheson or Wycheson John   601931 601931 Wytheson or Wycheson, John, of Sutton in Holand 0
4535727 2211455 2211455 defendant Dode Robert   601931 601931 Dode, Robert, of Sutton in Holand 0
4542147 2213435 2213435 plaintiff Wytheson John   601931 601931 Wytheson, John, of Sutton in Holand 0
4542148 2213435 2213435 defendant Heppeley John   601931 601931 Heppeley, John, of Sutton in Holand 0
4542170 2213443 2213443 plaintiff Wythson John   601931 601931 Wythson, John, of Sutton in Holand 0
4553352 2216984 2216984 defendant Levet Thomas   601931 601931 Levet, Thomas, of Sutton in Holand 0
4561848 2219640 2219640 defendant Bacon John   601931 601931 Bacon, John, of Sutton in Holand 0
4578706 2224830 2224830 defendant Stoke William   601931 601931 Stoke, William, of Sutton in Holand, bailiff 2
4617457 2236472 2236472 defendant Cot Robert tailor 601931 601931 Cot, Robert, of Sutton in Holand, tailor 0
4617458 2236472 2236472 defendant Dod Robert   601931 601931 Dod, Robert, of Sutton in Holand 1
4617459 2236472 2236472 defendant Rummyn (illegible)   601931 601931 Rummyn, _, of Sutton in Holand 2
4617648 2236526 2236526 defendant Huson Simon   601931 601931 Huson, Simon, of Sutton in Holand 0
4631089 2240620 2240620 defendant Phelip William   601931 601931 Phelip, William, of Sutton in Holand 0
4631090 2240620 2240620 defendant Phelip John   601931 601931 Phelip, John, of Sutton in Holand, servant of William 1
4642072 2243789 2243789 defendant Skerer Ralph   601931 601931 Skerer, Ralph, of Sutton in Holand 0
4652240 2246647 2246647 defendant Fysshe John husbandman 601931 601931 Fysshe, John, of Sutton in Holand, husbandman 0
4652241 2246647 2246647 defendant Dobyn John husbandman 601931 601931 Dobyn, John, of Sutton in Holand, husbandman 1
4663806 2250164 2250164 defendant Wythson John husbandman 601931 601931 Wythson, John, of Sutton in Holand, husbandman 0
4673705 2257405 2257405 defendant Dawe Robert husbandman 601931 601931 Dawe, Robert, of Sutton in Holand, husbandman 0
4673707 2257406 2257406 defendant Galardun John husbandman 601931 601931 Galardun, John, of Sutton in Holand, husbandman 0
4691467 2262854 2262854 defendant Bacon John husbandman 601931 601931 Bacon, John, of Sutton in Holand, husbandman 0
4692065 2263051 2263051 defendant Nicholson John   601931 601931 Nicholson, John, of Sutton in Holand, bailiff 0
4692870 2263278 2263278 defendant Nicholson John   601931 601931 Nicholson, John, of Sutton in Holand, bailiff 0
4701210 2265780 2265780 defendant Jurdan William   601931 601931 Jurdan, William, of Sutton in Holand 0
4701493 2265866 2265866 defendant Bacon John husbandman 601931 601931 Bacon, John, of Sutton in Holand, husbandman 0
4708953 2268169 2268169 defendant Harecroft Richard husbandman 601931 601931 Harecroft, Richard, of Sutton in Holand, husbandman 0
4710015 2268490 2268490 defendant Robynson John   601931 601931 Robynson, John, of Sutton in Holand, husbandman, son of Geoffrey Robinson 0
4710016 2268490 2268490 defendant Gosselyne William husbandman 601931 601931 Gosselyne, William, of Sutton in Holand, husbandman 1
4710018 2268491 2268491 defendant Dernelove William husbandman 601931 601931 Dernelove, William, of Sutton in Holand, husbandman 0
4710019 2268491 2268491 defendant Kirketon Thomas husbandman 601931 601931 Kirketon, Thomas, of Sutton in Holand, husbandman 1
4712759 2269304 2269304 defendant Bacon John husbandman 601931 601931 Bacon, John, of Sutton in Holand, husbandman 0
4714391 2269830 2269830 defendant Jurdan William husbandman 601931 601931 Jurdan, William, of Sutton in Holand, husbandman 0
4719370 2271400 2271400 defendant Wythson Robert husbandman 601931 601931 Wythson, Robert, of Sutton in Holand, husbandman 0
4723756 2272735 2272735 defendant White William (legal representative) 601931 601931 White, William, of Sutton in Holand, vicar, executors of 0
4729072 2274327 2274327 plaintiff Lambard William   601931 601931 Lambard, William, of Sutton in Holand 0
4747700 2279835 2279835 defendant Tomson John husbandman 601931 601931 Tomson, John, of Sutton in Holand, husbandman 0
4779580 2289599 2289599 defendant Symson Gilbert chaplain 601931 601931 (Symson, Gilbert, of Sutton in Holand, chaplain 1
4779581 2289599 2289599 defendant Reyner Richard husbandman 601931 601931 Reyner, Richard, of Sutton in Holand, husbandman 2
4784017 2291011 2291011 plaintiff de Sutton Gilbert   601931 601931 de Sutton, Gilbert, of Sutton in Holand, chaplain, son of de Sutton, Simon 0
4784018 2291011 2291011 defendant Nicolasson John husbandman 601931 601931 Nicolasson, John, of Sutton in Holand, husbandman 0
4784019 2291011 2291011 defendant Edmond Thomas husbandman 601931 601931 Edmond, Thomas, of Sutton in Holand, husbandman 1
4786367 2291781 2291781 defendant Jurdan William husbandman 601931 601931 Jurdan, William, of Sutton in Holand, husbandman 0
4786368 2291781 2291781 defendant Harecroft Richard husbandman 601931 601931 Harecroft, Richard, of Sutton in Holand, husbandman 1
4786369 2291781 2291781 defendant Dobyn John husbandman 601931 601931 Dobyn, John, of Sutton in Holand, husbandman 2
4786370 2291781 2291781 defendant Dewe John husbandman 601931 601931 Dewe, John, of Sutton in Holand, husbandman 3
4789855 2292897 2292897 plaintiff Colson Thomas   601931 601931 Colson, Thomas, of Sutton in Holand 1
4789859 2292898 2292898 plaintiff Colson Thomas   601931 601931 Colson, Thomas, of Sutton in Holand 1
4799190 2295927 2295927 defendant Hocto William   601931 601931 Hocto, William, of Sutton in Holand, wright 0
4804908 2297740 2297740 defendant Whtewell William (legal representative) 601931 601931 Whtewell, William, of Sutton in Holand, vicar, executors of 0
4807235 2298464 2298464 defendant Nicoll Robert husbandman 601931 601931 Nicoll, Robert, of Sutton in Holand, husbandman 0
4809405 2299118 2299118 defendant Whitewell William (legal representative) 601931 601931 Whitewell, William, of Sutton in Holand, vicar, executors of 0
4809406 2299118 2299118 defendant Symson Gilbert chaplain 601931 601931 (Symson, Gilbert, of Sutton in Holand, chaplain 1
4815261 2300884 2300884 defendant Botell John yeoman 601931 601931 Botell, John, of Sutton in Holand, yeoman 0
4822839 2303226 2303226 defendant Marke John husbandman 601931 601931 Marke, John, of Sutton in Holand, husbandman 0
4829254 2305189 2305189 defendant Wyson Robert gent 601931 601931 Wyson, Robert, of Sutton in Holand, gent 0
4829255 2305189 2305189 defendant Pender John husbandman 601931 601931 Pender, John, of Sutton in Holand, husbandman 1
4839072 2308149 2308149 defendant Joye Adam miller 601931 601931 Joye, Adam, of Sutton in Holand, miller 1
4845539 2310116 2310116 defendant Erle Simon husbandman 601931 601931 Erle, Simon, of Sutton in Holand, husbandman 0
4846307 2310351 2310351 defendant Yonge John husbandman 601931 601931 Yonge, John, of Sutton in Holand, husbandman 0
4847432 2310700 2310700 defendant Belle Robert butcher 601931 601931 Belle, Robert, of Sutton in Holand, butcher 0
4850134 2311503 2311503 defendant Coke John chaplain 601931 601931 Coke, John, of Sutton in Holand, chaplain 2
4851249 2311840 2311840 plaintiff Turnay Maurice   601931 601931 Turnay, Maurice, of Sutton in Holand, vicar 0
4851478 2311908 2311908 defendant Beche Robert   601931 601931 Beche, Robert, of Sutton in Holand 0
4856054 2313264 2313264 defendant Whyson Robert gent 601931 601931 Whyson, Robert, of Sutton in Holand, gent 0
4856059 2313265 2313265 defendant Wyson Robert gent 601931 601931 Wyson, Robert, of Sutton in Holand, gent 0
4862277 2315211 2315211 defendant Tomson Robert husbandman 601931 601931 Tomson, Robert, of Sutton in Holand, husbandman 0
4862278 2315211 2315211 defendant Pore Nicholas husbandman 601931 601931 Pore, Nicholas, of Sutton in Holand, husbandman 1
4866742 2316561 2316561 defendant Peynder Henry husbandman 601931 601931 Peynder, Henry, of Sutton in Holand, husbandman 5
4868232 2317042 2317042 defendant Robynson William husbandman 601931 601931 Robynson, William, of Sutton in Holand, husbandman 0
4871204 2317973 2317973 defendant Lawys Richard, senior husbandman 601931 601931 Lawys, Richard, senior, of Sutton in Holand, husbandman 0
4876728 2319694 2319694 defendant Pory Roger husbandman 601931 601931 Pory, Roger, of Sutton in Holand, husbandman 0
4878908 2320337 2320337 defendant Reynald Thomas yeoman 601931 601931 Reynald, Thomas, of Sutton in Holand, yeoman 2
4880010 2320661 2320661 defendant Beche Robert husbandman 601931 601931 Beche, Robert, of Sutton in Holand, husbandman 0
4880012 2320661 2320661 defendant Noryse Geoffrey husbandman 601931 601931 Noryse, Geoffrey, of Sutton in Holand, husbandman 2
4881514 2321121 2321121 defendant Porgey Thomas tailor 601931 601931 Porgey, Thomas, of Sutton in Holand, tailor 0
4881515 2321121 2321121 defendant Porgey Joan   601931 601931 Porgey, Joan, of Sutton in Holand, servant 1
4886128 2322520 2322520 defendant Dynyell Robert husbandman 601931 601931 Dynyell, Robert, of Sutton in Holand, husbandman 0
4891430 2324051 2324051 defendant Baldewer Nicholas husbandman 601931 601931 Baldewer, Nicholas, of Sutton in Holand, husbandman 0
4903312 2327644 2327644 defendant Goslyn Thomas husbandman 601931 601931 Goslyn, Thomas, of Sutton in Holand, husbandman 0
4915380 2331318 2331318 defendant Pory Richard husbandman 601931 601931 Pory, Richard, of Sutton in Holand, husbandman 0
4918219 2332217 2332217 defendant Gosyln Robert husbandman 601931 601931 Gosyln, Robert, of Sutton in Holand, husbandman 0
4918774 2332384 2332384 defendant Poore Roger husbandman 601931 601931 Poore, Roger, of Sutton in Holand, husbandman 1
4919167 2332507 2332507 defendant Gymer Gregory husbandman 601931 601931 Gymer, Gregory, of Sutton in Holand, husbandman 0
4919168 2332507 2332507 defendant Gime John husbandman 601931 601931 Gime, John, of Sutton in Holand, husbandman 1
4922971 2333603 2333603 defendant Souter Nicholas husbandman 601931 601931 Souter, Nicholas, of Sutton in Holand, husbandman 0
4929328 2335591 2335591 defendant Ryche Thomas husbandman 601931 601931 Ryche, Thomas, of Sutton in Holand, husbandman 0
4944436 2340239 2340239 defendant Fyssh Clement   601931 601931 Fyssh, Clement, of Sutton in Holand, servant 0
4945929 2340712 2340712 defendant Amery John husbandman 601931 601931 Amery, John, of Sutton in Holand, husbandman 2
4950395 2342090 2342090 defendant Herryson Robert (legal representative) 601931 601931 Herryson, Robert, of Sutton in Holand, executors of 0
4950396 2342090 2342090 defendant Herryson Henry husbandman 601931 601931 (Herryson, Henry, of Sutton in Holand, husbandman 1
4950397 2342090 2342090 defendant Herryson Margaret widow 601931 601931 Herryson, Margaret, of Sutton in Holand, widow 2
4955603 2343641 2343641 defendant Wyson Robert husbandman 601931 601931 Wyson, Robert, of Sutton in Holand, husbandman 1

Next page

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);