names

103 rows where place_id = 592146

✎ 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
3606731 1869782 1869782 defendant Flegge John yeoman 592146 592146 Flegge, John, of Nedham, yeoman 0
3696743 1925206 1925206 defendant Rowght Rochard   592146 592146 Rowght, Rochard, of Nedham Market, trailor 2
3722221 1933209 1933209 defendant Studde William laborer 592146 592146 Studde, William, of Nedham, laborer 0
3734614 1937074 1937074 plaintiff Gooddale Thomas husbandman 592146 592146 Gooddale, Thomas, of Nedham, husbandman 0
3749258 1941696 1941696 defendant Bronwyn John colthmaker 592146 592146 Bronwyn, John, of Nedham, colthmaker 0
3752474 1942697 1942697 plaintiff Ravyn Thomas, senior   592146 592146 Ravyn, Thomas, senior, of Nedham 0
3752476 1942698 1942698 plaintiff Ravyn Thomas, senior   592146 592146 Ravyn, Thomas, senior, of Nedham 0
3783360 1952545 1952545 defendant Jacob Thomas mercer 592146 592146 Jacob, Thomas, of Nedham, mercer 0
3953851 2008417 2008417 defendant Alen John tailor 592146 592146 Alen, John, of Nedham, tailor 1
3994111 2022642 2022642 defendant Freman William tanner 592146 592146 Freman, William, of Nedham, tanner 0
4013961 2029728 2029728 plaintiff Salmon Robert clothier 592146 592146 Salmon, Robert, of Nedham, clothier 0
4016463 2030591 2030591 defendant Dowsyng Robert yeoman 592146 592146 Dowsyng, Robert, of Nedham, yeoman 0
4050507 2042608 2042608 defendant Cootes Thomas clothier 592146 592146 Cootes, Thomas, of Nedham, clothier 0
4087401 2055786 2055786 defendant Asshill John clerk 592146 592146 Asshill, John, of Nedham, clerk 1
4090277 2056810 2056810 defendant Dawson Thomas clothier 592146 592146 Dawson, Thomas, of Nedham, clothier 1
4090279 2056810 2056810 defendant Colchester William clothier 592146 592146 Colchester, William, of Nedham, clothier 3
4124750 2069145 2069145 defendant Revell Roger mercer 592146 592146 Revell, Roger, of Nedham, mercer 0
4329190 2140074 2140074 defendant Wood William yeoman 592146 592146 Wood, William, of Nedham, yeoman 0
4329191 2140074 2140074 defendant Goslyn Henry   592146 592146 Goslyn, Henry, of Nedham yeoman 1
4393430 2162404 2162404 defendant Deynes Robert butcher 592146 592146 Deynes, Robert, of Nedham, butcher 0
4393431 2162404 2162404 defendant Deynes Simon butcher 592146 592146 Deynes, Simon, of Nedham, butcher 1
4438514 2181333 2181333 defendant fuller John   592146 592146 fuller, John, of Nedham 1
4439522 2181624 2181624 defendant del Mor John   592146 592146 del Mor, John, of Nedham 0
4443127 2182811 2182811 defendant Fysshere William, junior   592146 592146 Fysshere, William, junior, of Nedham 1
4444732 2183332 2183332 defendant Fuller John   592146 592146 Fuller, John, of Nedham 0
4446707 2183886 2183886 defendant Barkere William   592146 592146 Barkere, William, of Nedham 7
4455608 2186764 2186764 plaintiff Moor John   592146 592146 Moor, John, of Nedham 0
4498409 2200155 2200155 defendant Elyngham John   592146 592146 Elyngham, John, of Nedham 3
4498413 2200155 2200155 defendant Sparwe Robert   592146 592146 Sparwe, Robert, of Nedham 7
4502338 2201318 2201318 defendant Moor John   592146 592146 Moor, John, of Nedham 2
4502469 2201355 2201355 defendant Balle Nicholas   592146 592146 Balle, Nicholas, of Nedham 0
4518743 2206236 2206236 defendant Poddere Giles   592146 592146 Poddere, Giles, of Nedham 3
4520576 2206785 2206785 defendant Marchale Ralph   592146 592146 Marchale, Ralph, of Nedham 0
4522229 2207297 2207297 defendant Chaloner Thomas   592146 592146 Chaloner, Thomas, of Nedham 5
4522805 2207470 2207470 defendant Balle John   592146 592146 Balle, John, of Nedham 0
4535175 2211279 2211279 defendant Elyngham Thomas   592146 592146 Elyngham, Thomas, of Nedham 0
4535177 2211279 2211279 defendant Sparowe John   592146 592146 Sparowe, John, of Nedham 2
4553650 2217065 2217065 defendant Balle Nicholas   592146 592146 Balle, Nicholas, of Nedham 0
4553655 2217067 2217067 defendant Balle Nicholas   592146 592146 Balle, Nicholas, of Nedham 0
4554881 2217455 2217455 defendant Balle Nicholas   592146 592146 Balle, Nicholas, of Nedham 0
4554883 2217455 2217455 defendant Barkere John   592146 592146 Barkere, John, of Nedham 2
4554885 2217456 2217456 defendant Balle Nicholas   592146 592146 Balle, Nicholas, of Nedham 0
4556273 2217904 2217904 defendant Nowell John   592146 592146 Nowell, John, of Nedham 2
4557203 2218187 2218187 defendant Filby John tanner 592146 592146 Filby, John, of Nedham, tanner 0
4557205 2218188 2218188 defendant Fyll John baker 592146 592146 Fyll, John, of Nedham, baker 0
4558626 2218651 2218651 defendant Deye Robert   592146 592146 Deye, Robert, of Nedham 0
4558627 2218651 2218651 defendant Nowell William   592146 592146 Nowell, William, of Nedham 1
4558629 2218652 2218652 defendant Doye Robert   592146 592146 Doye, Robert, of Nedham 0
4558630 2218652 2218652 defendant Nowell William   592146 592146 Nowell, William, of Nedham 1
4563598 2220181 2220181 defendant Cooik John   592146 592146 Cooik, John, of Nedham 1
4566707 2221163 2221163 defendant Baldewyn Robert   592146 592146 Baldewyn, Robert, of Nedham 0
4566716 2221164 2221164 defendant Baldewyn Robert   592146 592146 Baldewyn, Robert, of Nedham 0
4572063 2222827 2222827 defendant Nedham John de   592146 592146 Nedham, John de, of Nedham 3
4577559 2224490 2224490 defendant Gernon John tanner 592146 592146 Gernon, John, of Nedham, tanner 0
4577565 2224491 2224491 defendant Gernon John tanner 592146 592146 Gernon, John, of Nedham, tanner 0
4583126 2226143 2226143 defendant Cobald John fuller 592146 592146 Cobald, John, of Nedham, fuller 0
4583598 2226292 2226292 defendant Cook John   592146 592146 Cook, John, of Nedham 0
4584601 2226601 2226601 defendant Coke John   592146 592146 Coke, John, of Nedham 0
4584603 2226602 2226602 defendant Coke John   592146 592146 Coke, John, of Nedham 0
4595832 2229952 2229952 defendant Balle Nicholas   592146 592146 Balle, Nicholas, of Nedham 0
4604397 2232546 2232546 defendant Glovere Richard   592146 592146 Glovere, Richard, of Nedham 2
4610511 2234358 2234358 defendant Blake John tailor 592146 592146 Blake, John, of Nedham, tailor 5
4615778 2235930 2235930 plaintiff Fisshere Robert   592146 592146 Fisshere, Robert, of Nedham 0
4627529 2239542 2239542 defendant Fraunceys John   592146 592146 Fraunceys, John, of Nedham 3
4637826 2242601 2242601 plaintiff Tunbek John   592146 592146 Tunbek, John, of Nedham 1
4645740 2244819 2244819 defendant Sparewe Robert   592146 592146 Sparewe, Robert, of Nedham 0
4646236 2244971 2244971 defendant Sparwe Robert   592146 592146 Sparwe, Robert, of Nedham 1
4653138 2246918 2246918 plaintiff Pyn Hugh   592146 592146 Pyn, Hugh, of Nedham Marker 1
4708096 2267910 2267910 plaintiff Nedham John   592146 592146 Nedham, John, of Nedham 1
4708100 2267911 2267911 plaintiff Nedham John   592146 592146 Nedham, John, of Nedham 1
4841126 2308758 2308758 defendant Calwer John husbandman 592146 592146 Calwer, John, of Nedham, husbandman 1
4893691 2324723 2324723 defendant Havell or Hanell John chapman 592146 592146 Havell or Hanell, John, of Nedham, chapman 0
4894267 2324893 2324893 defendant Thorp John husbandman 592146 592146 Thorp, John, of Nedham, husbandman 2
4897775 2325969 2325969 defendant Neweman John miller 592146 592146 Neweman, John, of Nedham, miller 1
4904652 2328063 2328063 defendant Laverok John butcher 592146 592146 Laverok, John, of Nedham, butcher 1
4916607 2331701 2331701 defendant Thorp John husbandman 592146 592146 Thorp, John, of Nedham, husbandman 1
4922872 2333569 2333569 defendant Onewyn Thomas tailor 592146 592146 Onewyn, Thomas, of Nedham, tailor 0
4970466 2348113 2348113 defendant Bocher John butcher 592146 592146 Bocher, John, of Nedham, butcher 0
4970467 2348113 2348113 defendant Bocher Robert butcher 592146 592146 Bocher, Robert, of Nedham, butcher 1
5027843 2365023 2365023 defendant Baldewell or Baldewyn John husbandman 592146 592146 Baldewell or Baldewyn, John, of Nedham, husbandman 0
5027846 2365024 2365024 defendant Cappe Thomas peddler 592146 592146 Cappe, Thomas, of Nedham, peddler 0
5032889 2366506 2366506 defendant Kesewyk Robert husbandman 592146 592146 Kesewyk, Robert, of Nedham, husbandman 0
5038911 2368284 2368284 plaintiff Baldewyn John   592146 592146 Baldewyn, John, of Nedham 0
5038913 2368284 2368284 plaintiff Jay John   592146 592146 Jay, John, of Nedham 2
5043189 2369582 2369582 defendant Thorp Robert husbandman 592146 592146 Thorp, Robert, of Nedham, husbandman 0
5066124 2376392 2376392 defendant Armygeard Thomas laborer 592146 592146 Armygeard, Thomas, of Nedham, laborer 0
5066125 2376392 2376392 defendant Baron Roger laborer 592146 592146 Baron, Roger, of Nedham, laborer 1
5098328 2385940 2385940 defendant Cole John husbandman 592146 592146 Cole, John, of Nedham, husbandman 3
5104266 2387669 2387669 defendant Sparwe or Sparowe Richard pedder 592146 592146 Sparwe or Sparowe, Richard, of Nedham, pedder 6
5124698 2393699 2393699 plaintiff Letys Alan   592146 592146 Letys, Alan, of Nedham 2
5135634 2396933 2396933 plaintiff Middilton Geoffrey   592146 592146 Middilton, Geoffrey, of Nedham 0
5143270 2399168 2399168 plaintiff Letys Alan   592146 592146 Letys, Alan, of Nedham 2
5155881 2402882 2402882 plaintiff Middilton Geoffrey   592146 592146 Middilton, Geoffrey, of Nedham 0
5172300 2407624 2407624 plaintiff Middilton Geoffrey   592146 592146 Middilton, Geoffrey, of Nedham 0
5188321 2412294 2412294 defendant Feld Edmund carpenter 592146 592146 Feld, Edmund, of Nedham, carpenter 0
5271327 2436707 2436707 defendant Fleg John dyer 592146 592146 Fleg, John, of Nedham Market, junior, dyer 4
5494041 2503125 2503125 plaintiff Flegge Robert (legal representative) 592146 592146 Flegge, Robert, of Nedham, clothmaker, executors of 0
5494048 2503126 2503126 plaintiff Flegge Robert (legal representative) 592146 592146 Flegge, Robert, of Nedham, clothmaker, executors of 0
5494055 2503127 2503127 plaintiff Flegge Robert (legal representative) 592146 592146 Flegge, Robert, of Nedham, executors of 0
5509029 2507683 2507683 plaintiff Flegge Robert (legal representative) 592146 592146 Flegge, Robert, of Nedham, executors of 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);