names

100 rows where place_id = 588508

✎ 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
3594765 1865987 1865987 defendant Baker John yeoman 588508 588508 Baker, John, of Maideston, yeoman 0
3599651 1867533 1867533 defendant Stone Adam butcher 588508 588508 Stone, Adam, of Maideston, butcher 0
3605780 1869474 1869474 defendant Weild John smith 588508 588508 Weild, John, of Maideston, smith 0
3605848 1869496 1869496 plaintiff Lilly William draper 588508 588508 Lilly, William, of Maideston, draper 0
3605983 1869534 1869534 defendant Dunham Robert smith 588508 588508 Dunham, Robert, of Maideston, smith 1
3606132 1869586 1869586 defendant Boycotte Henry laborer 588508 588508 Boycotte, Henry, of Maideston, laborer 0
3612568 1871566 1871566 defendant Lamherst William skinner 588508 588508 Lamherst, William, of Maideston, skinner 0
3614867 1872304 1872304 defendant Broun Thomas butcher 588508 588508 Broun, Thomas, of Maideston, butcher 1
3614868 1872304 1872304 defendant Holbeme William   588508 588508 Holbeme, William, of Maideston, tallow chandler 2
3619192 1873602 1873602 defendant Hegremond John   588508 588508 Hegremond, John, of Maideston, coverlet weaver 2
3620923 1874105 1874105 defendant Gulle Stephen smith 588508 588508 Gulle, Stephen, of Maideston, smith 4
3621664 1874315 1874315 defendant Yate Thomas saddler 588508 588508 Yate, Thomas, of Maideston, saddler 0
3624369 1875156 1875156 defendant Stace William laborer 588508 588508 Stace, William, of Maideston, laborer 1
3624371 1875156 1875156 defendant Prykkyll John cordwainer 588508 588508 Prykkyll, John, of Maideston, cordwainer 3
3649670 1910268 1910268 defendant Kele alias Pratt Joan widow 588508 588508 Kele alias Pratt, Joan, of Maideston, widow 1
3702749 1927131 1927131 defendant Gardener Alexander glover 588508 588508 Gardener, Alexander, of Maideston, glover 0
3702753 1927132 1927132 defendant Gardener Alexander glover 588508 588508 Gardener, Alexander, of Maideston, glover 0
3734738 1937110 1937110 defendant Ippyngbery John pewterer 588508 588508 Ippyngbery, John, of Maideston, pewterer 6
3754383 1943328 1943328 defendant Netter John   588508 588508 Netter, John, of Maideston, mason 0
3772726 1949165 1949165 defendant Fyssher Robert gent 588508 588508 Fyssher, Robert, of Maideston, gent 0
3866995 1979199 1979199 defendant Nynne Robert yeoman 588508 588508 Nynne, Robert, of Maideston, yeoman 3
3867000 1979200 1979200 defendant Nynne Robert yeoman 588508 588508 Nynne, Robert, of Maideston, yeoman 3
3904149 1991631 1991631 plaintiff Harper John smith 588508 588508 Harper, John, of Maideston, smith 0
3970994 2014412 2014412 defendant Kempe William butcher 588508 588508 Kempe, William, of Maideston, butcher 0
3970995 2014412 2014412 defendant Kempe Richard butcher 588508 588508 Kempe, Richard, of Maideston, butcher 1
3983358 2018821 2018821 plaintiff Smythe William yeoman 588508 588508 Smythe, William, of Maideston, yeoman 0
4174750 2086637 2086637 defendant Austen Stephen mercer 588508 588508 Austen, Stephen, of Maideston, mercer 0
4311501 2134164 2134164 defendant Coplande William smith 588508 588508 Coplande, William, of Maideston, smith 2
4338633 2143267 2143267 defendant Ball Roger draper 588508 588508 Ball, Roger, of Maideston, draper 1
4338634 2143267 2143267 defendant Younge John   588508 588508 Younge, John, of Maideston, freemason 2
4680571 2259534 2259534 defendant Cook Thomas chaplain 588508 588508 Cook, Thomas, of Maideston, chaplain 0
4680572 2259534 2259534 defendant Neel Stephen butcher 588508 588508 Neel, Stephen, of Maideston, butcher 1
4680573 2259534 2259534 defendant Grigge William butcher 588508 588508 Grigge, William, of Maideston, butcher 2
4680574 2259534 2259534 defendant Waspe William   588508 588508 Waspe, William, of Maideston skinner 3
4782129 2290411 2290411 defendant Chyrell William cooper 588508 588508 Chyrell, William, of Maideston, cooper 0
4791443 2293418 2293418 defendant Davy Reginald carpenter 588508 588508 Davy, Reginald, of Maideston, carpenter 0
4791444 2293418 2293418 defendant Salman Roger carpenter 588508 588508 Salman, Roger, of Maideston, carpenter 1
4794637 2294464 2294464 defendant Kete William   588508 588508 Kete, William, of Maideston, mason 1
4800742 2296417 2296417 defendant Warbulton John dyer 588508 588508 Warbulton, John, of Maideston, dyer 0
4873967 2318796 2318796 plaintiff Potekyn John   588508 588508 Potekyn, John, of Maideston 0
4873981 2318800 2318800 defendant Starlyng William chapman 588508 588508 Starlyng, William, of Maideston, chapman 3
4891805 2324178 2324178 defendant Pette Nicholas laborer 588508 588508 Pette, Nicholas, of Maideston, laborer 4
4892844 2324492 2324492 defendant Morice Richard laborer 588508 588508 Morice, Richard, of Maideston, laborer 0
4896902 2325684 2325684 defendant Frome Richard skinner 588508 588508 Frome, Richard, of Maideston, skinner 0
4896903 2325684 2325684 defendant Stonstrete Lawrence dyer 588508 588508 Stonstrete, Lawrence, of Maideston, dyer 1
4896904 2325684 2325684 defendant Derby William dyer 588508 588508 Derby, William, of Maideston, dyer 2
4897013 2325717 2325717 defendant Slendale John   588508 588508 Slendale, John, of Maideston, mason 0
4902231 2327307 2327307 defendant Walden Robert laborer 588508 588508 Walden, Robert, of Maideston, laborer 0
4935211 2337415 2337415 defendant Longe John yeoman 588508 588508 Longe, John, of Maideston, yeoman 1
4969912 2347952 2347952 defendant Ingham John husbandman 588508 588508 Ingham, John, of Maideston, husbandman 0
4974192 2349238 2349238 defendant Banaster Thomas skinner 588508 588508 Banaster, Thomas, of maideston, skinner 0
4974193 2349238 2349238 defendant Snelgar Richard yeoman 588508 588508 Snelgar, Richard, of Maideston, yeoman 1
4983206 2351879 2351879 defendant Ingham John husbandman 588508 588508 Ingham, John, of Maideston, husbandman 0
4984038 2352158 2352158 defendant Brok William barber 588508 588508 Brok, William, of Maideston, barber 1
4984975 2352440 2352440 defendant Hilles Thomas husbandman 588508 588508 Hilles, Thomas, of Maideston, husbandman 0
5018139 2362193 2362193 plaintiff Colle Stephen   588508 588508 Colle, Stephen, of Maideston 0
5031828 2366179 2366179 defendant Maundy Richard   588508 588508 Maundy, Richard, of Maideston, mason 1
5054331 2372874 2372874 defendant Dey John fuller 588508 588508 Dey, John, of Maideston, fuller 4
5056895 2373638 2373638 plaintiff Chirch John husbandman 588508 588508 Chirch, John, of Maideston, husbandman 0
5056896 2373638 2373638 defendant Frende Nicholas husandman 588508 588508 Frende, Nicholas, of Maideston, husandman 0
5056954 2373657 2373657 defendant Aleyn Thomas   588508 588508 Aleyn, Thomas, of Maideston, tallow chandler 0
5068552 2377085 2377085 plaintiff Poleyn Henry (legal representative) 588508 588508 Poleyn, Henry, of Maideston, executors of 0
5068558 2377085 2377085 defendant Sergeant John saddler 588508 588508 Sergeant, John, of Maideston, saddler 1
5081427 2380948 2380948 defendant Aston John butcher 588508 588508 Aston, John, of Maideston, butcher 4
5081428 2380948 2380948 defendant Freche Andrew husbandman 588508 588508 Freche, Andrew,of Maideston, husbandman 5
5083126 2381462 2381462 defendant Degon James cordwainer 588508 588508 Degon, James, of Maideston, cordwainer 1
5083127 2381462 2381462 defendant Chaloner Richard crdwainer 588508 588508 Chaloner, Richard, of Maideston, crdwainer 2
5083128 2381462 2381462 defendant Dene Richard tailor 588508 588508 Dene, Richard, of Maideston, tailor 3
5083129 2381462 2381462 defendant Reve Robert baker 588508 588508 Reve, Robert, of Maideston, baker 4
5083130 2381462 2381462 defendant Wode Richard chapman 588508 588508 Wode, Richard, of Maideston, chapman 5
5083131 2381462 2381462 defendant Frende Nicholas laborer 588508 588508 Frende, Nicholas, of Maideston, laborer 6
5083132 2381462 2381462 defendant Maynerd Richard shoemaker 588508 588508 Maynerd, Richard, of Maideston, shoemaker 7
5083133 2381462 2381462 defendant atte Hyll John tailor 588508 588508 atte Hyll, John, of Maideston, tailor 8
5083153 2381463 2381463 defendant Bele William butcher 588508 588508 Bele, William, of Maideston, butcher 10
5083154 2381463 2381463 defendant Florance Robert chaplain 588508 588508 Florance, Robert, of Maideston, chaplain 11
5083155 2381463 2381463 defendant Keystrete John laborer 588508 588508 Keystrete, John, of Maideston, laborer 12
5095800 2385195 2385195 defendant Hill Thomas   588508 588508 Hill, Thomas, of Maideston, mason 0
5109599 2389238 2389238 defendant Miller John shoemaker 588508 588508 Miller, John, of Maideston,shoemaker 3
5120746 2392495 2392495 plaintiff Stongate Beatrix widow 588508 588508 Stongate, Beatrix, of Maideston, widow 0
5218266 2421073 2421073 defendant Bedell Thomas yeoman 588508 588508 Bedell, Thomas, of Maideston, yeoman 0
5360430 2463297 2463297 defendant Mantyll Edmund   588508 588508 Mantyll, Edmund, of Maideston, wax chandler 2
5493102 2502847 2502847 defendant Maundy Robert   588508 588508 Maundy, Robert, of Maideston, mason 1
5495193 2503458 2503458 defendant Water William (legal representative) 588508 588508 Water, William, of Maideston, executrix of 0
5495194 2503458 2503458 defendant Water Christine widow 588508 588508 Water, Christine, of Maideston, widow 1
5508018 2507402 2507402 defendant Middelton John   588508 588508 Middelton, John, of Maideston, freemason 1
5525819 2512666 2512666 defendant Grenewey John   588508 588508 Grenewey, John, of Maideston 0
5525821 2512666 2512666 defendant Hikket John shoemaker 588508 588508 Hikket, John, of Maideston, shoemaker 2
5527247 2513100 2513100 defendant Ferram John baker 588508 588508 Ferram, John, of Maideston, baker 1
5528045 2513335 2513335 defendant Broke John laborer 588508 588508 Broke, John, of Maideston, laborer 0
5534625 2515371 2515371 defendant Stumbuller Christopher cutler 588508 588508 Stumbuller, Christopher, of Maideston, cutler 0
5535021 2515484 2515484 defendant Waren Richard weaver 588508 588508 Waren, Richard, of Maideston, weaver 0
5535257 2515556 2515556 plaintiff Blanket Thomas yeoman 588508 588508 Blanket, Thomas, of Maideston, yeoman 0
5537005 2516058 2516058 defendant Borden John   588508 588508 Borden, John, of Maideston, mason 3
5539679 2516891 2516891 defendant Peya Robert butcher 588508 588508 Peya, Robert, of Maideston, butcher 0
5549134 2519789 2519789 defendant Coward John weaver 588508 588508 Coward, John, of Maideston, weaver 0
5549847 2519987 2519987 defendant Purley Isabel widow 588508 588508 Purley, Isabel, of Maideston, widow 1
5553622 2521094 2521094 defendant Massy John fishmonger 588508 588508 Massy, John, of Maideston, fishmonger 0
5553973 2521201 2521201 plaintiff Leche Lawrence   588508 588508 Leche, Lawrence, of Maideston 2
5595825 2533606 2533606 defendant Burdon William smith 588508 588508 Burdon, William, of Maideston, smith 1
5636439 2555350 2555350 defendant Wrecok John carpenter 588508 588508 Wrecok, John, of Maideston, carpenter 1

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