names

65 rows where place_id = 590534

✎ 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
3601514 1868130 1868130 defendant Cukcowe alias Crykkowe Robert burcher 590534 590534 Cukcowe alias Crykkowe, Robert, of Billerica, Essex, burcher 0
3616748 1872868 1872868 defendant Aleyn John chapman 590534 590534 Aleyn, John, of Billerica, Essex, chapman 2
3682203 1920538 1920538 defendant Debnam John smith 590534 590534 Debnam, John, of Billerica, Essex, smith 3
3746751 1940898 1940898 defendant Parker William yeoman 590534 590534 Parker, William, of Billerica, Essex, yeoman 1
3760793 1945379 1945379 defendant Parker William yeoman 590534 590534 Parker, William, of Billerica, Essex, yeoman 0
3788990 1954367 1954367 defendant Gowleston Thomas smith 590534 590534 Gowleston, Thomas, of Billerica, Essex, smith 1
3817487 1963381 1963381 defendant Laurance Robert husbandman 590534 590534 Laurance, Robert, of Billerica, Essex, husbandman 0
3859437 1976646 1976646 defendant Trovy Robert innholder 590534 590534 Trovy, Robert, of Billerica, Essex, innholder 0
4193055 2093138 2093138 defendant Grymshawe James yeoman 590534 590534 Grymshawe, James, of Billerica, Essex, yeoman 0
4354719 2148879 2148879 defendant Freeman Benjamin chapman 590534 590534 Freeman, Benjamin, of Billerica, Essex, chapman 0
4354720 2148879 2148879 defendant Carley Thomas chapman 590534 590534 Carley, Thomas, of Billerica, Essex, chapman 1
4354743 2148883 2148883 defendant Ponde William chapman 590534 590534 Ponde, William, of Billerica, Essex, chapman 0
4355311 2149077 2149077 defendant Hall William chapman 590534 590534 Hall, William, of Billerica, Essex, chapman 2
4379366 2157702 2157702 defendant Hall William chapman 590534 590534 Hall, William, of Billerica, Essex, chapman 2
4621765 2237789 2237789 defendant atte Hacche William   590534 590534 atte Hacche, William, of Billerica, Essex 0
4776500 2288644 2288644 defendant Baker John chapman 590534 590534 Baker, John, of Billerica, Essex, chapman 2
4989147 2353692 2353692 defendant Crakebon John chapman 590534 590534 Crakebon, John, of Billerica, Essex, chapman 0
5002915 2357759 2357759 defendant Crakebon John chapman 590534 590534 Crakebon, John, of Billerica, Essex, chapman 0
5002942 2357764 2357764 defendant Crakebon John chapman 590534 590534 Crakebon, John, of Billerica, Essex, chapman 0
5015922 2361547 2361547 defendant Devenshire William husbandman 590534 590534 Devenshire, William, of Billerica, Essex, husbandman 0
5050181 2371678 2371678 defendant Cole John merchant 590534 590534 Cole, John, of Billerica, Essex, merchant 0
5088381 2382977 2382977 plaintiff Knyght Richard (legal representative) 590534 590534 Knyght, Richard, of Billerica, Essex, tailor, executor of 0
5094332 2384748 2384748 defendant Jolef Thomas woolman 590534 590534 Jolef, Thomas, of Billerica, Essex, woolman 1
5094336 2384749 2384749 defendant Jolef Thomas woolman 590534 590534 Jolef, Thomas, of Billerica, Essex, woolman 1
5096822 2385502 2385502 defendant Tanner William husbandman 590534 590534 Tanner, William, of Billerica, Essex, husbandman 1
5109341 2389161 2389161 plaintiff Garald or Gerold William drover 590534 590534 Garald or Gerold, William, of Billerica, Essex, drover 0
5109348 2389163 2389163 plaintiff Garard alias Garold William drover 590534 590534 Garard alias Garold, William, of Billerica, Essex, drover 0
5118181 2391754 2391754 defendant Baker John yeoman 590534 590534 Baker, John, of Billerica, Essex, yeoman 0
5135308 2396827 2396827 defendant Seller John smith 590534 590534 Seller, John, of Billerica, Essex, smith 1
5138323 2397719 2397719 defendant (illegible) John   590534 590534 ----, John, of Billerica, Essex, wool man 0
5149881 2401095 2401095 defendant Prentys John chapman 590534 590534 Prentys, John, of Billerica, Essex, chapman 1
5161407 2404433 2404433 defendant Basset Thomas woolman 590534 590534 Basset, Thomas, of Billerica, Essex, woolman 0
5163994 2405208 2405208 defendant Basset Thomas woolman 590534 590534 Basset, Thomas, of Billerica, Essex, woolman 0
5168643 2406549 2406549 defendant Prentys John chapman 590534 590534 Prentys, John, of Billerica, Essex, chapman 1
5184663 2411261 2411261 defendant Prentys John chapman 590534 590534 Prentys, John, of Billerica, Essex, chapman 1
5197379 2414978 2414978 defendant Basset Thomas   590534 590534 Basset, Thomas, of Billerica, Essex, wool man 0
5204436 2417047 2417047 defendant Prentys John chapman 590534 590534 Prentys, John, of Billerica, Essex, chapman 0
5264268 2434582 2434582 defendant Debenham William yeoman 590534 590534 Debenham, William, of Billerica, Essex, yeoman 0
5279896 2439197 2439197 defendant Prentys John chapman 590534 590534 Prentys, John, of Billerica, Essex, chapman 0
5279900 2439198 2439198 defendant Prentys John chapman 590534 590534 Prentys, John, of Billerica, Essex, chapman 0
5301058 2445271 2445271 defendant Cap John yeoman 590534 590534 Cap, John, of Billerica, Essex, yeoman 3
5329860 2453999 2453999 defendant Hamper Thomas woolman 590534 590534 Hamper, Thomas, of Billerica, Essex, woolman 0
5331152 2454391 2454391 defendant Tabyr John yeoman 590534 590534 Tabyr, John, of Billerica, Essex, yeoman 0
5340281 2457168 2457168 defendant Capp John husbandman 590534 590534 Capp, John, of Billerica, Essex, husbandman 0
5361150 2463516 2463516 defendant Tanner William woolman 590534 590534 Tanner, William, of Billerica, Essex, woolman 0
5361818 2463724 2463724 defendant Hacche Thomas woolman 590534 590534 Hacche, Thomas, of Billerica, Essex, woolman 0
5362776 2464000 2464000 defendant Tanner William woolman 590534 590534 Tanner, William, of Billerica, Essex, woolman 0
5414161 2479173 2479173 defendant Clovell John chapman 590534 590534 Clovell, John, of Billerica, Essex, chapman 1
5423901 2482102 2482102 defendant Ponde John   590534 590534 Ponde, John, of Billerica, Essex 0
5423903 2482103 2482103 defendant Ponde John yeoman 590534 590534 Ponde, John, of Billerica, Essex, yeoman 0
5436288 2485790 2485790 defendant Cukhoke Robert butcher 590534 590534 Cukhoke, Robert, of Billerica, Essex, butcher 1
5436716 2485910 2485910 defendant Yates Thomas sadler 590534 590534 Yates, Thomas, of Billerica, Essex, sadler 2
5443010 2487818 2487818 defendant Ponde John yeoman 590534 590534 Ponde, John, of Billerica, Essex, yeoman 0
5451001 2490191 2490191 defendant cukhoke Robert butcher 590534 590534 cukhoke, Robert, of Billerica, Essex, butcher 1
5451358 2490282 2490282 defendant Yates Thomas sadler 590534 590534 Yates, Thomas, of Billerica, Essex, sadler 2
5454483 2491254 2491254 defendant Freman John husbandman 590534 590534 Freman, John, of Billerica, Essex, husbandman 0
5463141 2493889 2493889 defendant Cukhoke Robert butcher 590534 590534 Cukhoke, Robert, of Billerica, Essex, butcher 0
5463146 2493891 2493891 defendant Cukhoke Robert butcher 590534 590534 Cukhoke, Robert, of Billerica, Essex, butcher 1
5463399 2493961 2493961 defendant Yates Thomas sadler 590534 590534 Yates, Thomas, of Billerica, Essex, sadler 2
5466371 2494878 2494878 defendant Freman John husbandman 590534 590534 Freman, John, of Billerica, Essex, husbandman 0
5474685 2497412 2497412 defendant Cukhoke Robert butcher 590534 590534 Cukhoke, Robert, of Billerica, Essex, butcher 0
5479825 2498975 2498975 defendant at Wode William chapman 590534 590534 at Wode, William, of Billerica, Essex, chapman 2
5500397 2505063 2505063 defendant Cokehole alias Cokok alias Bocher Robert butcher 590534 590534 Cokehole alias Cokok alias Bocher, Robert, of Billerica, Essex, butcher 0
5500405 2505064 2505064 defendant Hache Thomas yeoman 590534 590534 (Hache, Thomas, of Billerica, Essex, yeoman 4
5572434 2526480 2526480 defendant Aleyn John chapman 590534 590534 Aleyn, John, of Billerica, Essex, chapman 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);