names

140 rows where place_id = 782849

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4679498 2259201 2259201 defendant Sextayn Richard butcher 782849 782849 Sextayn, Richard, of Cambridge, Cambs, butcher 3
4681209 2259748 2259748 defendant Bristolwe Richard   782849 782849 Bristolwe, Richard, of Cambridge, Cambs, beadle 0
4681214 2259749 2259749 defendant Bristowe Richard   782849 782849 Bristowe, Richard, of Cambridge, Cambs, beadle 0
4683014 2260301 2260301 defendant Brasyngton Thomas   782849 782849 Brasyngton, Thomas, of Cambridge, Cambs, parson of the church of St John Baptist 0
4683072 2260322 2260322 defendant Gale John hosier 782849 782849 Gale, John, of Cambridge, Cambs, hosier 0
4684728 2260824 2260824 defendant Bristowe Richard master & beadle 782849 782849 Bristowe, Richard, of Cambridge, Cambs, master & beadle 0
4704526 2266790 2266790 defendant Hetham John   782849 782849 Hetham, John, of Cambridge, Cambs, notary 2
4710455 2268628 2268628 plaintiff Radwynter William master of Clare Hall or College 782849 782849 Radwynter, William, of Cambridge, Cambs, master of Clare Hall or College 0
4716681 2270537 2270537 defendant Knapton John chapman 782849 782849 Knapton, John, of Cambridge, Cambs, chapman 0
4724238 2272874 2272874 defendant Berry Henry yeoman 782849 782849 Berry, Henry, of Cambridge, Cambs, yeoman 1
4733411 2275627 2275627 defendant Fayrye John clerk 782849 782849 Fayrye, John, of Cambridge, Cambs, clerk 0
4746550 2279485 2279485 defendant Lawe William brother of Robert Lawe of Dokesworth 782849 782849 Lawe, William, of Cambridge, Cambs, yeoman, brother of Robert Lawe of Dokesworth 0
4752529 2281198 2281198 defendant Pulter John yeoman 782849 782849 Pulter, John, of Cambridge, Cambs, yeoman 0
4753507 2281475 2281475 defendant Lenn William taverner 782849 782849 Lenn, William, of Cambridge, Cambs, taverner 1
4768126 2286001 2286001 defendant Pightesle Richard   782849 782849 Pightesle, Richard, of Cambridge, Cambs, notary 1
4774784 2288106 2288106 defendant Lumley Marmaduke clerk 782849 782849 Lumley, Marmaduke, of Cambridge, Cambs, clerk 0
4810826 2299510 2299510 defendant Bank John clerk 782849 782849 Bank, John, of Cambridge, Cambs, clerk 0
4815083 2300828 2300828 defendant Dyne John clerk 782849 782849 Dyne, John, of Cambridge, Cambs, clerk 0
4820578 2302508 2302508 defendant Bristowe Richard gentleman beadle 782849 782849 Bristowe, Richard, of Cambridge, Cambs, gentleman beadle 0
4830339 2305523 2305523 defendant Mason Thomas skinner 782849 782849 Mason, Thomas, of Cambridge, Cambs, skinner 0
4830345 2305524 2305524 defendant Mason Thomas skinner 782849 782849 Mason, Thomas, of Cambridge, Cambs, skinner 0
4839806 2308362 2308362 defendant Mast Thomas husbandman 782849 782849 Mast, Thomas, of Cambridge, Cambs, husbandman 0
4840890 2308688 2308688 defendant Coke John ostler 782849 782849 Coke, John, of Cambridge, Cambs, ostler 2
4840896 2308689 2308689 defendant Coke John ostler 782849 782849 Coke, John, of Cambridge, Cambs, ostler 2
4845831 2310206 2310206 defendant Spenser William husbandman 782849 782849 (Spenser, William, of Cambridge, Cambs, husbandman 4
4852501 2312205 2312205 defendant More William clerk 782849 782849 More, William, of Cambridge, Cambs, clerk 0
4909289 2329447 2329447 defendant Marchall John   782849 782849 (Marchall, John, of Cambridge, Cambs, notary 1
4917330 2331930 2331930 defendant Lokworth Thomas fishmonger 782849 782849 Lokworth, Thomas, of Cambridge, Cambs, fishmonger 0
4917967 2332133 2332133 defendant Lukolne Robert draper 782849 782849 Lukolne, Robert, of Cambridge, Cambs, draper 3
4917972 2332134 2332134 defendant Lynhome Robert draper 782849 782849 Lynhome, Robert, of Cambridge, Cambs, draper 3
4920349 2332880 2332880 defendant Doget Richard miller 782849 782849 Doget, Richard, of Cambridge, Cambs, miller 0
4922016 2333296 2333296 defendant Lolleworth Thomas   782849 782849 Lolleworth, Thomas, of Cambridge, Cambs, burgess & merchant 0
4922596 2333482 2333482 defendant Sawston John, junior goldsmith 782849 782849 Sawston, John, junior, of Cambridge, Cambs, goldsmith 1
4923869 2333907 2333907 defendant Miller Willam husbandman 782849 782849 Miller, Willam, of Cambridge, Cambs, husbandman 1
4923878 2333908 2333908 defendant Miller William husbandman 782849 782849 Miller, William, of Cambridge, Cambs, husbandman 1
4989020 2353652 2353652 defendant Godbed Bartholomew chandler 782849 782849 Godbed, Bartholomew, of Cambridge, Cambs, chandler 0
4989474 2353786 2353786 defendant Clyf alias Bramston Margery widow 782849 782849 Clyf alias Bramston, Margery, of Cambridge, Cambs, widow 0
4989489 2353791 2353791 defendant Bramston Margery widow 782849 782849 Bramston, Margery, of Cambridge, Cambs, widow 0
4992351 2354601 2354601 defendant Webster Richard fishmonger 782849 782849 Webster, Richard, of Cambridge, Cambs, fishmonger 0
4993612 2354962 2354962 defendant Kyllesby William cardmaker 782849 782849 Kyllesby, William, of Cambridge, Cambs, cardmaker 5
5000719 2357086 2357086 defendant Belton John   782849 782849 Belton, John, of Cambridge, Cambs, burgess & merchant 0
5004050 2358070 2358070 defendant Seymer Thomas merchant 782849 782849 Seymer, Thomas, of Cambridge, Cambs, merchant 0
5004055 2358071 2358071 defendant Seymer Thomas merchant 782849 782849 Seymer, Thomas, of Cambridge, Cambs, merchant 0
5004986 2358355 2358355 defendant Swerd Thomas husbandman 782849 782849 Swerd, Thomas, of Cambridge, Cambs, husbandman 0
5008273 2359310 2359310 defendant Marchall John   782849 782849 Marchall, John, of Cambridge, Cambs, notary 0
5008277 2359311 2359311 defendant Marchall John   782849 782849 Marchall, John, of Cambridge, Cambs, notary 0
5127296 2394460 2394460 defendant Frynge John clerk 782849 782849 Frynge, John, of Cambridge, Cambs, clerk 0
5143474 2399224 2399224 defendant Lolworth William yeoman 782849 782849 Lolworth, William, of Cambridge, Cambs, yeoman 0
5143476 2399225 2399225 defendant Lolworth William yeoman 782849 782849 Lolworth, William, of Cambridge, Cambs, yeoman 0
5150000 2401133 2401133 defendant Barton Ralph   782849 782849 Barton, Ralph, of Cambridge, Cambs, clerk & master of Arts, at the University 0
5151192 2401492 2401492 defendant Lowe William gent 782849 782849 Lowe, William, of Cambridge, Cambs, gent 0
5151246 2401510 2401510 defendant Draper Thomas clerk 782849 782849 Draper, Thomas, of Cambridge, Cambs, clerk 1
5152666 2401920 2401920 defendant Grene Thomas tailor 782849 782849 Grene, Thomas, of Cambridge, Cambs, tailor 0
5153176 2402075 2402075 defendant Denaham John   782849 782849 Denaham, John, of Cambridge, Cambs, scholar 0
5161836 2404569 2404569 defendant Turnour John clerk 782849 782849 Turnour, John, of Cambridge, Cambs, clerk 0
5164683 2405406 2405406 defendant Lolworth William yeoman 782849 782849 Lolworth, William, of Cambridge, Cambs, yeoman 0
5164708 2405412 2405412 defendant Seriaunt John yeoman 782849 782849 Seriaunt, John, of Cambridge, Cambs, yeoman 1
5168715 2406575 2406575 defendant Barton Ralph clerk & master at the University 782849 782849 Barton, Ralph, of Cambridge, Cambs, clerk & master at the University 0
5169433 2406795 2406795 defendant Lewe William gent 782849 782849 Lewe, William, of Cambridge, Cambs, gent 0
5170703 2407152 2407152 defendant Deneham John   782849 782849 Deneham, John, of Cambridge, Cambs, scholar 0
5171576 2407406 2407406 defendant Symson Thomas dyer 782849 782849 Symson, Thomas, of Cambridge, Cambs, dyer 3
5176109 2408700 2408700 defendant Turnour John clerk 782849 782849 Turnour, John, of Cambridge, Cambs, clerk 0
5182025 2410492 2410492 defendant Styward John chapman 782849 782849 Styward, John, of Cambridge, Cambs, chapman 0
5184736 2411286 2411286 defendant Barton Ralph clerk & master in the university 782849 782849 Barton, Ralph, of Cambridge, Cambs, clerk & master in the university 0
5184740 2411287 2411287 defendant Barton Ralph   782849 782849 Barton, Ralph, of Cambridge, Cambs, clerk & master of Arts, at the University 0
5186059 2411670 2411670 defendant Lowe William gent 782849 782849 Lowe, William, of Cambridge, Cambs, gent 0
5186235 2411724 2411724 defendant Draper Thomas clerk 782849 782849 Draper, Thomas, of Cambridge, Cambs, clerk 1
5191429 2413235 2413235 defendant Sergeaunt John yeoman 782849 782849 Sergeaunt, John, of Cambridge, Cambs, yeoman 0
5194185 2414030 2414030 defendant Andrewe John chapman 782849 782849 Andrewe, John, of Cambridge, Cambs, chapman 3
5197515 2415013 2415013 defendant Deverose George sheerman 782849 782849 Deverose, George, of Cambridge, Cambs, sheerman 3
5198011 2415156 2415156 defendant Turnour John clerk 782849 782849 Turnour, John, of Cambridge, Cambs, clerk 0
5198013 2415157 2415157 defendant Turnour John clerk 782849 782849 Turnour, John, of Cambridge, Cambs, clerk 0
5200178 2415808 2415808 defendant Tapton Hugh clerk 782849 782849 Tapton, Hugh, of Cambridge, Cambs, clerk 0
5200180 2415809 2415809 defendant Tapton Hugh clerk 782849 782849 Tapton, Hugh, of Cambridge, Cambs, clerk 0
5200182 2415810 2415810 defendant Tapton Hugh clerk 782849 782849 Tapton, Hugh, of Cambridge, Cambs, clerk 0
5207334 2417887 2417887 defendant Sergeaunt John yeoman 782849 782849 Sergeaunt, John, of Cambridge, Cambs, yeoman 0
5208633 2418248 2418248 defendant Andrewe John chapman 782849 782849 Andrewe, John, of Cambridge, Cambs, chapman 2
5208639 2418249 2418249 defendant Andrewe John chapman 782849 782849 Andrewe, John, of Cambridge, Cambs, chapman 2
5211385 2419063 2419063 defendant Tapton Hugh clerk 782849 782849 Tapton, Hugh, of Cambridge, Cambs, clerk 0
5271533 2436768 2436768 defendant Colleby (illegible) widow 782849 782849 Colleby, -----, of Cambridge, Cambs, widow 3
5276820 2438302 2438302 defendant Lemster William   782849 782849 Lemster, William, of Cambridge, Cambs, physician 0
5300556 2445130 2445130 defendant Bothe Robert clerk 782849 782849 (Bothe, Robert, of Cambridge, Cambs, clerk 1
5309050 2447743 2447743 defendant Brydon Robert   782849 782849 Brydon, Robert, of Cambridge, Cambs, notary 0
5384454 2470639 2470639 defendant Rumbald Robert plumber 782849 782849 Rumbald, Robert, of Cambridge, Cambs, plumber 1
5388734 2471834 2471834 defendant Wynter John glasier 782849 782849 Wynter, John, of Cambridge, Cambs, glasier 0
5393308 2473140 2473140 defendant Frewell John gent 782849 782849 Frewell, John, of Cambridge, Cambs, gent 3
5409583 2477832 2477832 defendant Rumbald Robert plumber 782849 782849 Rumbald, Robert, of Cambridge, Cambs, plumber 1
5409948 2477946 2477946 defendant Dunham Robert clerk & master of the house & churche of St John Evangelist 782849 782849 Dunham, Robert, of Cambridge, Cambs, clerk & master of the house & churche of St John Evangelist 2
5415836 2479671 2479671 defendant Sergiaunt Walter yeoman 782849 782849 Sergiaunt, Walter, of Cambridge, Cambs, yeoman 0
5417205 2480057 2480057 defendant Mores Elizabeth widow 782849 782849 Mores, Elizabeth, of Cambridge, Cambs, widow 1
5419588 2480778 2480778 defendant Frewall John gent 782849 782849 Frewall, John, of Cambridge, Cambs, gent 1
5420196 2480958 2480958 defendant Crakenthorp John draper 782849 782849 Crakenthorp, John, of Cambridge, Cambs, draper 2
5421647 2481411 2481411 defendant Wyghtman William fishmonger 782849 782849 Wyghtman, William, of Cambridge, Cambs, fishmonger 1
5424754 2482362 2482362 defendant More Richard baker 782849 782849 More, Richard, of Cambridge, Cambs, baker 1
5425282 2482531 2482531 defendant Bell John yeoman 782849 782849 Bell, John, of Cambridge, Cambs, yeoman 0
5428168 2483363 2483363 defendant Reve Thomas brewer & burgess 782849 782849 Reve, Thomas, of Cambridge, Cambs, brewer & burgess 0
5430012 2483914 2483914 defendant Palfryman William butcher 782849 782849 Palfryman, William, of Cambridge, Cambs, butcher 1
5430037 2483917 2483917 defendant Palfryman William butcher 782849 782849 Palfryman, William, of Cambridge, Cambs, butcher 1
5432331 2484643 2484643 defendant Sergeaunt Walter yeoman 782849 782849 Sergeaunt, Walter, of Cambridge, Cambs, yeoman 0
5432333 2484644 2484644 defendant Sergiaunt Walter yeoman 782849 782849 Sergiaunt, Walter, of Cambridge, Cambs, 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);