names

129 rows where place_id = 585888

✎ 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
3587420 1863710 1863710 defendant Alby John carpenter 585888 585888 Alby, John, of Maidstone, Kent, carpenter 2
3587424 1863711 1863711 defendant Lilly John carpenter 585888 585888 Lilly, John, of Maidstone, Kent, carpenter 2
3930433 2000525 2000525 defendant Marten Edward   585888 585888 Marten, Edward, of Maidstone, Kent, cloth maker 1
3938308 2003150 2003150 defendant Robynson Robert yeoman 585888 585888 (Robynson, Robert, of Maidstone, Kent, yeoman 1
3941903 2004303 2004303 defendant Josselyn John smith 585888 585888 Josselyn, John, of Maidstone, Kent, smith 2
4131125 2071449 2071449 defendant Austen Stephen tailor 585888 585888 Austen, Stephen, of Maidstone, Kent, tailor 1
4487769 2196892 2196892 defendant Kapell Thomas   585888 585888 Kapell, Thomas, of Maidstone, Kent 3
4493374 2198632 2198632 defendant Sleye Simon   585888 585888 Sleye, Simon, of Maidstone, Kent, mason 0
4507535 2202817 2202817 defendant Capell Thomas   585888 585888 Capell, Thomas, of Maidstone, kent 0
4519819 2206554 2206554 defendant Londeneys William   585888 585888 Londeneys, William, of Maidstone, Kent 1
4523544 2207687 2207687 defendant Reve John   585888 585888 Reve, John, of Maidstone, Kent 0
4539705 2212680 2212680 defendant Marchall John   585888 585888 Marchall, John, of Maidstone, Kent 1
4539709 2212681 2212681 defendant Marchall John   585888 585888 Marchall, John, of Maidstone, Kent 1
4574916 2223679 2223679 defendant Propchaunt Richard, sen tanner 585888 585888 Propchaunt, Richard, sen, of Maidstone, Kent, tanner 0
4585952 2227031 2227031 defendant Marler John   585888 585888 Marler, John, of Maidstone, Kent 0
4585957 2227032 2227032 defendant Marler John   585888 585888 Marler, John, of Maidstone, Kent 0
4614087 2235418 2235418 defendant Cowelyng John sadler 585888 585888 Cowelyng, John, of Maidstone, Kent, sadler 2
4614088 2235418 2235418 defendant Bound Thomas   585888 585888 Bound, Thomas, of Maidstone, Kent 3
4622517 2238021 2238021 defendant Castelman William   585888 585888 Castelman, William, of Maidstone, Kent 0
4633876 2241443 2241443 defendant Sly Simon   585888 585888 Sly, Simon, of Maidstone, Kent, mason 0
4675065 2257811 2257811 defendant Sutton John esq 585888 585888 Sutton, John, of Maidstone, Kent, esq 0
4694834 2263875 2263875 defendant Slye (illegible)   585888 585888 Slye, _, of Maidstone, Kent, mason 2
4696243 2264310 2264310 defendant Warbulton John bondman 585888 585888 Warbulton, John, of Maidstone, Kent, bondman 0
4702665 2266237 2266237 defendant Elmere Thomas   585888 585888 Elmere, Thomas, of Maidstone, Kent, tallow chandler 2
4702680 2266239 2266239 defendant Elmere Thomas   585888 585888 Elmere, Thomas, of Maidstone, Kent, tallow chandler 2
4709137 2268223 2268223 defendant Dallyngton Walter spicer 585888 585888 Dallyngton, Walter, of Maidstone, Kent, spicer 0
4712992 2269380 2269380 defendant Helman John   585888 585888 Helman, John, of Maidstone, Kent, shoe maker 3
4728911 2274281 2274281 defendant Darlyngton Walter spicer 585888 585888 Darlyngton, Walter, of Maidstone, Kent, spicer 0
4728914 2274282 2274282 defendant Darlyngton Walter spicer 585888 585888 Darlyngton, Walter, of Maidstone, Kent, spicer 0
4738384 2277102 2277102 defendant Costedel John   585888 585888 (Costedel, John, of Maidstone, Kent, mason 1
4743765 2278705 2278705 defendant Dalyngton Walter chapman 585888 585888 Dalyngton, Walter, of Maidstone, Kent, chapman 2
4749688 2280393 2280393 defendant Dalyngton Walter chapman 585888 585888 Dalyngton, Walter, of Maidstone, Kent, chapman 2
4749693 2280394 2280394 defendant Dalyngton Walter chapman 585888 585888 Dalyngton, Walter, of Maidstone, Kent, chapman 1
4751217 2280833 2280833 defendant Wyke Alice widow & formerly wife of Thomas Wyke 585888 585888 Wyke, Alice, of Maidstone, Kent, widow & formerly wife of Thomas Wyke 1
4752399 2281160 2281160 defendant Costewell John   585888 585888 Costewell, John, of Maidstone, Kent, mason 0
4765013 2285033 2285033 defendant Wellys John carpenter 585888 585888 (Wellys, John, of Maidstone, Kent, carpenter 1
4805604 2297962 2297962 defendant Ifeld Walter draper 585888 585888 Ifeld, Walter, of Maidstone, Kent, draper 0
4807000 2298386 2298386 defendant Hudde alias Ifeld Walter draper 585888 585888 Hudde alias Ifeld, Walter, of Maidstone, Kent, draper 4
4818861 2301983 2301983 defendant Poley Henry dyer 585888 585888 Poley, Henry, of Maidstone, Kent, dyer 2
4818997 2302020 2302020 defendant Colyn William chapman 585888 585888 Colyn, William, of Maidstone, Kent, chapman 1
4819000 2302020 2302020 defendant Warbylton John spicer 585888 585888 Warbylton, John, of Maidstone, Kent, spicer 4
4822168 2303011 2303011 defendant Feld John esq 585888 585888 Feld, John, of Maidstone, Kent, esq 0
4822366 2303077 2303077 defendant Costedell John laborer 585888 585888 Costedell, John, of Maidstone, Kent, laborer 1
4831242 2305800 2305800 defendant Webbe Richard husbandman 585888 585888 Webbe, Richard, of Maidstone, Kent, husbandman 0
4831244 2305801 2305801 defendant Webbe Richard husbandman 585888 585888 Webbe, Richard, of Maidstone, Kent, husbandman 0
4846840 2310517 2310517 defendant Bery Edmund chapman 585888 585888 Bery, Edmund, of Maidstone, Kent, chapman 0
4852685 2312261 2312261 defendant Smyth William   585888 585888 Smyth, William, of Maidstone, Kent, mason 0
4914470 2331045 2331045 defendant Serle John yeoman 585888 585888 Serle, John, of Maidstone, Kent, yeoman 0
4924483 2334095 2334095 defendant Colny John goldsmith 585888 585888 Colny, John, of Maidstone, Kent, goldsmith 1
4926182 2334614 2334614 defendant Brokke John chapman 585888 585888 Brokke, John, of Maidstone, Kent, chapman 3
4926187 2334615 2334615 defendant Dounton Adam yeoman 585888 585888 Dounton, Adam, of Maidstone, Kent, yeoman 2
4927753 2335117 2335117 defendant Sterlyng William chapman 585888 585888 Sterlyng, William, of Maidstone, Kent, chapman 1
4987264 2353140 2353140 defendant Hokyng Robert carpenter 585888 585888 Hokyng, Robert, of Maidstone, Kent, carpenter 0
4987266 2353141 2353141 defendant Hokyng Robert carpenter 585888 585888 Hokyng, Robert, of Maidstone, Kent, carpenter 0
4987946 2353362 2353362 defendant Druell John clerk 585888 585888 Druell, John, of Maidstone, Kent, clerk 0
4996592 2355835 2355835 defendant Aleyn John husbandman 585888 585888 Aleyn, John, of Maidstone, Kent, husbandman 0
5011584 2360250 2360250 defendant Tylden Robert chapman 585888 585888 Tylden, Robert, of Maidstone, Kent, chapman 3
5011591 2360251 2360251 defendant Tylden Robert chapman 585888 585888 Tylden, Robert, of Maidstone, Kent, chapman 3
5038329 2368103 2368103 defendant Florens Robert chaplain 585888 585888 Florens, Robert, of Maidstone, Kent, chaplain 1
5039584 2368487 2368487 defendant Feld John gent 585888 585888 Feld, John, of Maidstone, Kent, gent 0
5046606 2370617 2370617 defendant Gast Robert gent 585888 585888 Gast, Robert, of Maidstone, Kent, gent 2
5046654 2370623 2370623 defendant Gast Robert gent 585888 585888 Gast, Robert, of Maidstone, Kent, gent 2
5046854 2370679 2370679 defendant Stucle or Stackley Peter clerk & master of the college of All Saints 585888 585888 Stucle or Stackley, Peter, of Maidstone, Kent, clerk & master of the college of All Saints 0
5051665 2372113 2372113 defendant Tylden Robert chapman 585888 585888 Tylden, Robert, of Maidstone, Kent, chapman 2
5051672 2372114 2372114 defendant Tylden Robert chapman 585888 585888 Tylden, Robert, of Maidstone, Kent, chapman 2
5133234 2396204 2396204 defendant Palmer Lawrence husbandman 585888 585888 Palmer, Lawrence, of Maidstone, Kent, husbandman 0
5134387 2396553 2396553 defendant atte H--- William   585888 585888 atte H---, William, of Maidstone, Kent, mason 3
5141402 2398602 2398602 defendant Hall Thomas   585888 585888 Hall, Thomas, of Maidstone, Kent, mason 1
5151125 2401470 2401470 defendant Fynche William tailor 585888 585888 Fynche, William, of Maidstone, Kent, tailor 2
5151131 2401472 2401472 defendant Walter Thomas dyer 585888 585888 Walter, Thomas, of Maidstone, Kent, dyer 0
5151135 2401473 2401473 defendant Walter Thomas dyer 585888 585888 Walter, Thomas, of Maidstone, Kent, dyer 0
5151194 2401492 2401492 defendant Covenay John skinner 585888 585888 Covenay, John, of Maidstone, Kent, skinner 2
5151196 2401492 2401492 defendant Haute William esq 585888 585888 Haute, William, of Maidstone, Kent, esq 4
5152253 2401789 2401789 defendant Culpeper William esq 585888 585888 Culpeper, William, of Maidstone, Kent, esq 2
5157921 2403439 2403439 defendant Pollerd John carpenter 585888 585888 Pollerd, John, of Maidstone, Kent, carpenter 4
5162558 2404771 2404771 defendant Hyll Thomas   585888 585888 Hyll, Thomas, of Maidstone, Kent, mason 1
5162566 2404772 2404772 defendant Hill Thomas   585888 585888 Hill, Thomas, of Maidstone, Kent, mason 1
5169404 2406786 2406786 defendant Fynch William tailor 585888 585888 Fynch, William, of Maidstone, Kent, tailor 1
5169407 2406787 2406787 defendant Walter Thomas dyer 585888 585888 Walter, Thomas, of Maidstone, Kent, dyer 0
5173671 2407995 2407995 defendant Pollerd John carpenter 585888 585888 Pollerd, John, of Maidstone, Kent, carpenter 4
5173681 2407996 2407996 defendant Pollerd John carpenter 585888 585888 Pollerd, John, of Maidstone, Kent, carpenter 4
5178234 2409338 2409338 defendant Dyne John dyer 585888 585888 Dyne, John, of Maidstone, Kent, dyer 0
5178245 2409342 2409342 defendant Deyne John dyer 585888 585888 Deyne, John, of Maidstone, Kent, dyer 0
5182592 2410663 2410663 defendant Fynche William husbandman 585888 585888 Fynche, William, of Maidstone, Kent, husbandman 1
5183787 2410994 2410994 defendant Ford Richard potter & brass worker 585888 585888 Ford, Richard, of Maidstone, Kent, potter & brass worker 0
5186097 2411685 2411685 defendant Walter Thomas dyer 585888 585888 Walter, Thomas, of Maidstone, Kent, dyer 0
5186210 2411716 2411716 defendant Haute William esq 585888 585888 Haute, William, of Maidstone, Kent, esq 3
5187518 2412068 2412068 defendant Culpeper William esq 585888 585888 Culpeper, William, of Maidstone, Kent, esq 2
5189791 2412761 2412761 defendant Atthill John tailor 585888 585888 Atthill, John, of Maidstone, Kent, tailor 0
5193750 2413896 2413896 defendant Polberd John carpenter 585888 585888 Polberd, John, of Maidstone, Kent, carpenter 3
5194096 2414004 2414004 defendant Poleyn Thomas husbandman 585888 585888 Poleyn, Thomas, of Maidstone, Kent, husbandman 0
5194103 2414006 2414006 defendant Poleyn Thomas husbandman 585888 585888 Poleyn, Thomas, of Maidstone, Kent, husbandman 0
5194890 2414254 2414254 defendant Laston William yeoman 585888 585888 Laston, William, of Maidstone, Kent, yeoman 0
5195036 2414297 2414297 defendant Barre John husbandman 585888 585888 Barre, John, of Maidstone, Kent, husbandman 3
5197415 2414986 2414986 defendant Crompe John baker 585888 585888 Crompe, John, of Maidstone, Kent, baker 0
5201351 2416153 2416153 defendant Dyne John dyer 585888 585888 Dyne, John, of Maidstone, Kent, dyer 0
5201353 2416154 2416154 defendant Deyne John dyer 585888 585888 Deyne, John, of Maidstone, Kent, dyer 0
5203493 2416774 2416774 defendant Fynche William husbandman 585888 585888 Fynche, William, of Maidstone, Kent, husbandman 1
5204009 2416922 2416922 defendant Ford Richard potter & brass worker 585888 585888 Ford, Richard, of Maidstone, Kent, potter & brass worker 0
5204011 2416923 2416923 defendant Ford Richard potter & brass worker 585888 585888 Ford, Richard, of Maidstone, Kent, potter & brass worker 0

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