names

85 rows where place_id = 753475

✎ 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
4413737 2169192 2169192 defendant Sidlewemelle John de   753475 753475 Sidlewemelle, John de, of _ 0
4434090 2175423 2175423 defendant Turney Lawrence   753475 753475 Turney, Lawrence, of _, parson 1
4557807 2218372 2218372 defendant Grymysham John   753475 753475 Grymysham, John, of _ 2
4589121 2227976 2227976 plaintiff Ledys William (legal representative) 753475 753475 Ledys, William, of _, formerly prebendary of the collegiate church of Holy Cross, executors of 0
4629187 2240060 2240060 plaintiff Smyth John   753475 753475 Smyth, John, of _ 0
4703123 2266354 2266354 defendant (illegible) John tailor 753475 753475 _, John, of _, tailor 1
4704080 2266654 2266654 defendant Daubeney John yeoman 753475 753475 Daubeney, John, of _, yeoman 0
4711512 2268930 2268930 defendant Parker Robert   753475 753475 Parker, Robert, of _, groom [ obscured ] 0
4714852 2269979 2269979 defendant Dyllyng John butcher 753475 753475 Dyllyng, John, of _, butcher 0
4722564 2272371 2272371 defendant Stonhous Nicholas husbandman 753475 753475 Stonhous, Nicholas, of _, husbandman 0
4754661 2281840 2281840 defendant W_   husbandman 753475 753475 _, W_, of _, husbandman 0
4754705 2281855 2281855 plaintiff Gayleston Thomas   753475 753475 Gayleston, Thomas, of _ 0
4754999 2281947 2281947 defendant Wysman John butcher 753475 753475 Wysman, John, of _, butcher 0
4756549 2282411 2282411 defendant Lake Margaret   753475 753475 Lake, Margaret, of _ 0
4762638 2284294 2284294 defendant atte Wode William farmer 753475 753475 atte Wode, William, of _, farmer 0
4769291 2286372 2286372 defendant Sparwe John husbandman 753475 753475 Sparwe, John, of _, husbandman 3
4771917 2287189 2287189 defendant _lo_ John husbandman 753475 753475 _lo_, John, of _, husbandman 1
4773025 2287534 2287534 defendant Ware John   753475 753475 Ware, John, of _ 1
4773834 2287796 2287796 defendant Grene Philip husbandman 753475 753475 Grene, Philip, of _, husbandman 0
4774809 2288114 2288114 defendant Kyllum Robert gent 753475 753475 Kyllum, Robert, of _, gent 0
4827873 2304772 2304772 defendant Putte Thomas   753475 753475 Putte, Thomas, of _, single man 1
4827941 2304794 2304794 defendant Grene John chapman 753475 753475 Grene, John, of _, chapman 0
4827943 2304794 2304794 defendant Grene William husbandman 753475 753475 Grene, William, of _, husbandman 2
4827945 2304794 2304794 defendant Grene Nicholas husbandman 753475 753475 Grene, Nicholas, of _, husbandman 4
4828512 2304958 2304958 defendant Strode John   753475 753475 Strode, John, of _, parson 0
4829678 2305328 2305328 defendant Coille John husbandman 753475 753475 Coille, John, of _, husbandman 1
4829827 2305372 2305372 defendant Button Nicholas yeoman 753475 753475 Button, Nicholas, of _, yeoman 0
4831906 2306005 2306005 defendant Hedden Thomas merchant 753475 753475 Hedden, Thomas, of _, merchant 0
4837536 2307675 2307675 defendant Dartoys James   753475 753475 Dartoys, James, of _, gent, living in London 0
4840672 2308624 2308624 defendant Thorp Robert gent [ out of focus ] 753475 753475 Thorp, Robert, of _, gent [ out of focus ] 1
4846199 2310315 2310315 defendant Jakkenycoll Martin yeoman 753475 753475 Jakkenycoll, Martin, of _, yeoman 3
4847422 2310698 2310698 defendant Garth John husbandman 753475 753475 Garth, John, of _, husbandman 1
4854240 2312738 2312738 defendant Skelbroke Nicholas gent 753475 753475 Skelbroke, Nicholas, of _, gent 0
4992173 2354551 2354551 defendant Phelip William husbandman 753475 753475 Phelip, William, of _, husbandman 2
4994802 2355304 2355304 defendant Synger Robert husbandman 753475 753475 Synger, Robert, of _, husbandman 5
5155724 2402833 2402833 defendant (illegible) Francis yeoman 753475 753475 _, Francis, of _, yeoman 0
5192647 2413587 2413587 defendant Symond John husbandman 753475 753475 Symond, John, of _, husbandman 2
5200900 2416029 2416029 defendant Warderop Robert yeoman 753475 753475 Warderop, Robert, of _, yeoman 2
5303962 2446189 2446189 defendant Bittesson John merchant 753475 753475 Bittesson, John, of _, merchant 2
5306141 2446826 2446826 defendant Martyn Thomas   753475 753475 Martyn, Thomas, of _ 1
5310119 2448058 2448058 defendant Temple William miller 753475 753475 Temple, William, of _, miller 0
5311006 2448330 2448330 plaintiff Williamson Henry merchant 753475 753475 Williamson, Henry, of _, merchant 0
5383324 2470308 2470308 defendant Strynger John   753475 753475 Strynger, John, of _ 1
5415332 2479522 2479522 defendant Goderyk Richard husbandman 753475 753475 Goderyk, Richard, of _, husbandman 0
5420712 2481118 2481118 defendant Thomas Thomas milner 753475 753475 Thomas, Thomas, of _, milner 2
5431802 2484479 2484479 defendant Gauge John timberman 753475 753475 Gauge, John, of _, timberman 3
5440935 2487197 2487197 plaintiff Adelard   (legal representative) 753475 753475 _, Adelard, of _, merchant, executors of , Thomas, of Boston 0
5440938 2487197 2487197 defendant Welby Thomas gent 753475 753475 Welby, Thomas, of _, gent 0
5441110 2487253 2487253 defendant Fynalke Thomas   753475 753475 Fynalke, Thomas, of _ 0
5441121 2487255 2487255 defendant Walter Richard   753475 753475 Walter, Richard, of _ 0
5441181 2487274 2487274 defendant Wadbroke Henry innholder 753475 753475 Wadbroke, Henry, of _, innholder 0
5442054 2487544 2487544 defendant Burgharde William husbandman 753475 753475 Burgharde, William, of _, husbandman 5
5442199 2487588 2487588 plaintiff Baroun Robert chaplain 753475 753475 Baroun, Robert, of _, chaplain 0
5442284 2487613 2487613 defendant Colbroke John gent 753475 753475 Colbroke, John, of _, gent 0
5442591 2487699 2487699 defendant burnham Robert husbandman 753475 753475 burnham, Robert, of _, husbandman 3
5442593 2487699 2487699 defendant Derham Richard husbandman 753475 753475 Derham, Richard, of _, husbandman 5
5442613 2487705 2487705 defendant Hendry John (legal representative) 753475 753475 Hendry, John, of _, executors of 1
5443322 2487921 2487921 defendant Spencer Thomas collier 753475 753475 Spencer, Thomas, of _, collier 1
5444118 2488147 2488147 plaintiff Cokette John, senior (legal representative) 753475 753475 Cokette, John, senior, of _, executors of 0
5444255 2488188 2488188 defendant Baron Benedict laborer 753475 753475 Baron, Benedict, of _, laborer 1
5444527 2488265 2488265 defendant Denton Richard tanner 753475 753475 Denton, Richard, of _, tanner 4
5444811 2488343 2488343 defendant (illegible) William husbandman 753475 753475 _, William, of _, by Bramber, husbandman 0
5444888 2488357 2488357 defendant Partrick William innholder 753475 753475 Partrick, William, of _, innholder 10
5444975 2488383 2488383 defendant Athirton John yeoman 753475 753475 Athirton, John, of _, yeoman 0
5445641 2488584 2488584 defendant Whitlok Robert husbandman 753475 753475 Whitlok, Robert, of _, husbandman 2
5446411 2488823 2488823 defendant Browen William chaplain 753475 753475 Browen, William, of _, chaplain 0
5446443 2488828 2488828 defendant Reve Thomas husbandman 753475 753475 Reve, Thomas, of _, husbandman 14
5447666 2489175 2489175 defendant Draper Richard husbandman 753475 753475 Draper, Richard, of _, husbandman 0
5448295 2489384 2489384 defendant Alfray Peter gent 753475 753475 Alfray, Peter, of _, gent 0
5448494 2489446 2489446 defendant Ad_ Thomas clerk 753475 753475 Ad_, Thomas, of _, clerk 3
5449534 2489749 2489749 defendant Baker Thomas yeoman 753475 753475 Baker, Thomas, of _, yeoman 2
5449595 2489770 2489770 defendant Isake Thomas weaver 753475 753475 Isake, Thomas, of _, weaver 0
5450251 2489959 2489959 defendant Tego Stephen draper 753475 753475 Tego, Stephen, of _, draper 0
5450937 2490169 2490169 defendant Propuse Alan   753475 753475 Propuse, Alan, of _ 2
5452043 2490491 2490491 defendant Southdon John husbandman 753475 753475 Southdon, John, of _, husbandman 6
5452069 2490501 2490501 defendant Grantham John   753475 753475 Grantham, John, of _ 0
5452449 2490608 2490608 defendant Watson John, junior yeoman 753475 753475 Watson, John, junior, of _, yeoman 0
5453880 2491052 2491052 defendant Potage John chandler 753475 753475 Potage, John, of _, chandler 0
5453881 2491052 2491052 defendant Stanfeld Thomas skepmaker 753475 753475 Stanfeld, Thomas, of _, skepmaker 1
5454009 2491091 2491091 defendant Hoggeson John chaplain 753475 753475 Hoggeson, John, of _, chaplain 0
5454092 2491118 2491118 defendant Cokshote Christopher husbandman 753475 753475 Cokshote, Christopher, of _, husbandman 0
5459420 2492731 2492731 defendant Turney Thomas   753475 753475 Turney, Thomas, of _ 2
5459433 2492734 2492734 defendant Pos_ Thomas husbandman 753475 753475 Pos_, Thomas, of _, husbandman 0
5468349 2495475 2495475 defendant Paunton John gent 753475 753475 together with Paunton, John, of _, gent 2
5475410 2497642 2497642 defendant Henfeld Thomas esq 753475 753475 Henfeld, Thomas, of _, esq 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);