names

113 rows where place_id = 586372

✎ 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
3588540 1864059 1864059 defendant Cukcok Robert butcher 586372 586372 Cukcok, Robert, of Billerica, butcher 3
3588541 1864059 1864059 defendant Broun John butcher 586372 586372 Broun, John, of Billerica, butcher 4
3590648 1864717 1864717 defendant Broun John butcher 586372 586372 Broun, John, of Billerica, butcher 2
3590649 1864717 1864717 defendant Clerke William fuller 586372 586372 Clerke, William, of Billerica, fuller 3
3601616 1868161 1868161 plaintiff Barneby William (legal representative) 586372 586372 Barneby, William, of Billerica, executor of 0
3608193 1870220 1870220 defendant Awdele Thomas woolman 586372 586372 Awdele, Thomas, of Billerica, woolman 0
3608195 1870220 1870220 defendant Cukhook Robert butcher 586372 586372 Cukhook, Robert, of Billerica, butcher 2
3608197 1870220 1870220 defendant Hacche John butcher 586372 586372 Hacche, John, of Billerica, butcher 4
3610295 1870875 1870875 defendant Jenyn John yeoman 586372 586372 Jenyn, John, of Billerica, yeoman 1
3610301 1870876 1870876 defendant Jenyn John yeoman 586372 586372 Jenyn, John, of Billerica, yeoman 1
3622028 1874431 1874431 defendant Kempe John woolman 586372 586372 Kempe, John, of Billerica, woolman 0
3622407 1874543 1874543 defendant Whelpton Thomas sawyer 586372 586372 Whelpton, Thomas, of Billerica, sawyer 1
3630889 1904481 1904481 defendant Clovyll Thomas haberdasher 586372 586372 Clovyll, Thomas, of Billerica, haberdasher 0
3647669 1909660 1909660 defendant Grenehyll Richard yeoman 586372 586372 Grenehyll, Richard, of Billerica, yeoman 0
3681956 1920461 1920461 defendant Cukkowe William butcher 586372 586372 Cukkowe, William, of Billerica, butcher 0
3713963 1930666 1930666 defendant Cuccuk alias Bocher John butcher 586372 586372 Cuccuk alias Bocher, John, of Billerica, butcher 0
3770056 1948295 1948295 defendant Parker Henry yeoman 586372 586372 Parker, Henry, of Billerica, yeoman 1
3788991 1954367 1954367 defendant Parker William woolman 586372 586372 Parker, William, of Billerica, woolman 2
3820965 1964452 1964452 defendant Newman John shoemaker 586372 586372 Newman, John, of Billerica, shoemaker 0
3835111 1968920 1968920 defendant Cuckoke alias Bocher John, junior butcher 586372 586372 Cuckoke alias Bocher, John, junior, of Billerica, butcher 2
3840461 1970578 1970578 defendant Humfrey Thomas laborer 586372 586372 Humfrey, Thomas, of Billerica, laborer 1
3840462 1970578 1970578 defendant Taylour Richard smith 586372 586372 Taylour, Richard, of Billerica, smith 2
3906345 1992407 1992407 defendant Clovell William husbandman 586372 586372 Clovell, William, of Billerica, husbandman 4
3914030 1995037 1995037 plaintiff Bryce John beer brewer 586372 586372 Bryce, John, of Billerica, beer brewer 0
4136923 2073553 2073553 defendant Freman William yeoman 586372 586372 Freman, William, of Billerica, yeoman 0
4167746 2084208 2084208 defendant Careles James husbandman 586372 586372 Careles, James, of Billerica, husbandman 1
4182226 2089262 2089262 defendant Joyce Thomas shoemaker 586372 586372 Joyce, Thomas, of Billerica, shoemaker 2
4313976 2134994 2134994 defendant Reynoldes Richard tailor 586372 586372 Reynoldes, Richard, of Billerica, tailor 0
4354721 2148879 2148879 defendant Hills George chapman 586372 586372 Hills, George, of Billerica, chapman 2
4354744 2148883 2148883 defendant Bee Gabriel chapman 586372 586372 Bee, Gabriel, of Billerica, chapman 1
4359838 2150681 2150681 defendant Harrys James yeoman 586372 586372 Harrys, James, of Billerica, yeoman 0
4392396 2162083 2162083 defendant Harvey John butcher 586372 586372 Harvey, John, of Billerica, butcher 0
4395020 2162920 2162920 defendant Mawbrooke Alice widow 586372 586372 Mawbrooke, Alice, of Billerica, widow 1
4464953 2189709 2189709 defendant Bret Thomas   586372 586372 Bret, Thomas, of Billerica 0
4483528 2195535 2195535 defendant Normyngton Roland   586372 586372 Normyngton, Roland, of Billerica 4
4487654 2196854 2196854 defendant atte Cherche William   586372 586372 atte Cherche, William, of Billerica 0
4488511 2197129 2197129 plaintiff Stubbere Benet   586372 586372 Stubbere, Benet, of Billerica 0
4510934 2203874 2203874 defendant Lythyng Henry   586372 586372 Lythyng, Henry, of Billerica 0
4525955 2208418 2208418 defendant Lorkyn John   586372 586372 Lorkyn, John, of Billerica 1
4544823 2214299 2214299 defendant atte Ponde Hugh   586372 586372 atte Ponde, Hugh, of Billerica 0
4549126 2215663 2215663 defendant Marcaunt Richard   586372 586372 Marcaunt, Richard, of Billerica 0
4567405 2221367 2221367 defendant Baret John   586372 586372 Baret, John, of Billerica 0
4567411 2221368 2221368 defendant Baret John   586372 586372 Baret, John, of Billerica 0
4626867 2239344 2239344 defendant Syden John   586372 586372 Syden, John, of Billerica 0
4626974 2239386 2239386 defendant Roo John   586372 586372 Roo, John, of Billerica 0
4643655 2244245 2244245 defendant Lynton Thomas tailor 586372 586372 Lynton, Thomas, of Billerica, tailor 0
4652096 2246596 2246596 defendant Baldok John chandler 586372 586372 Baldok, John, of Billerica, chandler 0
4654796 2247378 2247378 defendant Gilmyn John (legal representative) 586372 586372 Gilmyn, John, of Billerica, hosteler, executors of 0
4654797 2247378 2247378 defendant Baker John husbandman 586372 586372 (Baker, John, of Billerica, husbandman 1
4698391 2264976 2264976 defendant Gylot Thomas laborer 586372 586372 Gylot, Thomas, of Billerica, laborer 0
4698393 2264976 2264976 defendant Taillour John tailor 586372 586372 Taillour, John, of Billerica, tailor 2
4704736 2266860 2266860 defendant Markaunt Richard chapman 586372 586372 Markaunt, Richard, of Billerica, chapman 0
4708962 2268172 2268172 defendant Hache William de butcher 586372 586372 Hache, William de, of Billerica, butcher 0
4708963 2268172 2268172 defendant Sherebred Robert butcher 586372 586372 Sherebred, Robert, of Billerica, butcher 1
4708965 2268172 2268172 defendant Gylot Thomas laborer 586372 586372 Gylot, Thomas, of Billerica, laborer 3
4714743 2269940 2269940 defendant Hach William butcher 586372 586372 Hach, William, of Billerica, butcher 2
4789648 2292830 2292830 defendant Whyte William husbandman 586372 586372 Whyte, William, of Billerica, husbandman 0
4796179 2294956 2294956 defendant Hert John laborer 586372 586372 Hert, John, of Billerica, laborer 0
4963446 2345980 2345980 defendant atte Wode Richard laborer 586372 586372 atte Wode, Richard, of Billerica, laborer 1
5019979 2362725 2362725 defendant Bryncot John butcher 586372 586372 Bryncot, John, of Billerica, butcher 0
5094333 2384748 2384748 defendant Pounde John woolman 586372 586372 Pounde, John, of Billerica, woolman 2
5094337 2384749 2384749 defendant Pounde John woolman 586372 586372 Pounde, John, of Billerica, woolman 2
5095539 2385115 2385115 defendant Rynge John carpenter 586372 586372 Rynge, John, of Billerica, carpenter 0
5100737 2386640 2386640 defendant Basset Thomas woolman 586372 586372 Basset, Thomas, of Billerica, woolman 2
5118182 2391754 2391754 defendant Pr- John yeoman 586372 586372 Pr-, John, of Billerica, yeoman 1
5133422 2396265 2396265 defendant Elys Robert husbandman 586372 586372 Elys, Robert, of Billerica, husbandman 1
5159354 2403850 2403850 defendant Tanner William (legal representative) 586372 586372 Tanner, William, of Billerica, woolman, executor of 3
5240253 2427356 2427356 defendant Bett John drover 586372 586372 Bett, John, of Billerica, drover 1
5240254 2427356 2427356 defendant Cukkock William drover 586372 586372 Cukkock, William, of Billerica, drover 2
5300158 2445009 2445009 defendant Dalby William yeoman 586372 586372 Dalby, William, of Billerica, yeoman 1
5300162 2445010 2445010 defendant Dalby William yeoman 586372 586372 Dalby, William, of Billerica, yeoman 2
5346693 2459120 2459120 defendant Hacche Thomas woolman 586372 586372 Hacche, Thomas, of Billerica, woolman 0
5346694 2459120 2459120 defendant Ponde John woolman 586372 586372 Ponde, John, of Billerica, woolman 1
5351070 2460441 2460441 plaintiff Cukhok Robert butcher 586372 586372 Cukhok, Robert, of Billerica, butcher 0
5351074 2460441 2460441 defendant Sadeler Thomas saddler 586372 586372 Sadeler, Thomas, of Billerica, saddler 3
5368335 2465712 2465712 defendant Capper alias Caton John yeoman 586372 586372 Capper alias Caton, John, of Billerica, yeoman 1
5374543 2467642 2467642 defendant Broun John butcher 586372 586372 Broun, John, of Billerica, butcher 0
5388467 2471753 2471753 defendant Wattys John butcher 586372 586372 Wattys, John, of Billerica, butcher 1
5389395 2472013 2472013 defendant Ponde John   586372 586372 Ponde, John, of Billerica 0
5391246 2472573 2472573 defendant Prentys John yeoman 586372 586372 Prentys, John, of Billerica, yeoman 0
5402070 2475654 2475654 defendant Ponde John   586372 586372 Ponde, John, of Billerica, wool man 0
5411266 2478328 2478328 defendant Gates (illegible) husbandman 586372 586372 Gates, _, of Billerica, husbandman 4
5425517 2482609 2482609 defendant Gates Thomas husbandman 586372 586372 Gates, Thomas, of Billerica, husbandman 3
5425522 2482610 2482610 defendant Gates Thomas husbandman 586372 586372 Gates, Thomas, of Billerica, husbandman 3
5434467 2485250 2485250 defendant Ponde John woolman 586372 586372 Ponde, John, of Billerica, woolman 0
5445633 2488583 2488583 defendant Atwode William mercer 586372 586372 Atwode, William, of Billerica, mercer 0
5451948 2490465 2490465 plaintiff Stace John   586372 586372 Stace, John, of Billerica 0
5457504 2492142 2492142 defendant Atwode William mercer 586372 586372 Atwode, William, of Billerica, mercer 1
5468771 2495587 2495587 defendant Atwode William chapman 586372 586372 Atwode, William, of Billerica, chapman 2
5473552 2497053 2497053 defendant Ponde John woolman 586372 586372 Ponde, John, of Billerica, woolman 0
5473554 2497054 2497054 defendant Ponde John woolman 586372 586372 Ponde, John, of Billerica, woolman 0
5475453 2497656 2497656 plaintiff Stace John butcher 586372 586372 Stace, John, of Billerica, butcher 0
5475455 2497657 2497657 plaintiff Stace John butcher 586372 586372 Stace, John, of Billerica, butcher 0
5494711 2503308 2503308 defendant Cokoke Robert butcher 586372 586372 Cokoke, Robert, of Billerica, butcher 1
5495445 2503539 2503539 defendant Hatche Roger woolman 586372 586372 Hatche, Roger, of Billerica, woolman 0
5501825 2505496 2505496 defendant Scryvener Richard   586372 586372 Scryvener, Richard, of Billerica, wax chandler 1
5501827 2505496 2505496 defendant Broun John butcher 586372 586372 Broun, John, of Billerica, butcher 3
5516115 2509889 2509889 defendant Doget William yeoman 586372 586372 Doget, William, of Billerica, yeoman 2
5516207 2509904 2509904 defendant Doget William yeoman 586372 586372 Doget, William, of Billerica, yeoman 2
5523636 2512217 2512217 defendant Roos Thomas yeoman 586372 586372 Roos, Thomas, of Billerica, yeoman 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);