names

256 rows where place_id = 586311

✎ 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
3588402 1864020 1864020 defendant Baron Richard husbandman 586311 586311 Baron, Richard, of Hadle, husbandman 3
3588403 1864020 1864020 defendant Coopyn John yeoman 586311 586311 Coopyn, John, of Hadle, yeoman 4
3599774 1867573 1867573 plaintiff Wale Edmund   586311 586311 Wale, Edmund, of Hadle 0
3923292 1998101 1998101 plaintiff Smyth Edward   586311 586311 Smyth, Edward, of Hadle 0
4147160 2077145 2077145 defendant Scrivener William   586311 586311 Scrivener, William, of Hadle, ash burner 2
4512002 2204193 2204193 defendant Parker John   586311 586311 Parker, John, of Hadle 2
4517125 2205759 2205759 defendant Whitford William   586311 586311 Whitford, William, of Hadle 0
4531028 2209994 2209994 defendant Lenyng John dyer 586311 586311 Lenyng, John, of Hadle, dyer 1
4531076 2210001 2210001 defendant Lenyng John dyer 586311 586311 Lenyng, John, of Hadle, dyer 0
4534274 2210986 2210986 plaintiff Salman Richard   586311 586311 Salman, Richard, of Hadle 0
4549131 2215664 2215664 plaintiff Colman John butcher 586311 586311 Colman, John, of Hadle, butcher 0
4549133 2215665 2215665 plaintiff Colman John butcher 586311 586311 Colman, John, of Hadle, butcher 0
4549135 2215666 2215666 plaintiff Colman John butcher 586311 586311 Colman, John, of Hadle, butcher 0
4549137 2215667 2215667 plaintiff Colman John butcher 586311 586311 Colman, John, of Hadle, butcher 0
4549525 2215797 2215797 defendant Levyng John dyer 586311 586311 Levyng, John, of Hadle, dyer 4
4559256 2218849 2218849 defendant Poyt Simon   586311 586311 Poyt, Simon, of Hadle 3
4559276 2218852 2218852 defendant Poyt S_   586311 586311 Poyt, S_, of Hadle 7
4572161 2222845 2222845 defendant Parker Peter   586311 586311 Parker, Peter, of Hadle 0
4572162 2222845 2222845 defendant Ive William   586311 586311 Ive, William, of Hadle 1
4572163 2222845 2222845 defendant Ventoser Roger   586311 586311 Ventoser, Roger, of Hadle 2
4572236 2222855 2222855 plaintiff Arundell John   586311 586311 Arundell, John, of Hadle 0
4572962 2223083 2223083 plaintiff Baker Henry   586311 586311 Baker, Henry, of Hadle 0
4572964 2223083 2223083 defendant Hosyer Thomas   586311 586311 Hosyer, Thomas, of Hadle 1
4572965 2223083 2223083 defendant Sadeler Peter   586311 586311 Sadeler, Peter, of Hadle 2
4572966 2223083 2223083 defendant Elys John   586311 586311 Elys, John, of Hadle 3
4573893 2223351 2223351 defendant Pypere Richard, sen   586311 586311 Pypere, Richard, sen, of Hadle 0
4577238 2224399 2224399 defendant Pypere Richard   586311 586311 Pypere, Richard, of Hadle 0
4578905 2224883 2224883 defendant Pulter John spicer 586311 586311 Pulter, John, of Hadle, spicer 0
4580998 2225535 2225535 defendant Groom John   586311 586311 Groom, John, of Hadle 0
4584464 2226556 2226556 defendant Sadeler Peter   586311 586311 Sadeler, Peter, of Hadle 0
4584465 2226556 2226556 defendant Goldsmyth Nicholas   586311 586311 Goldsmyth, Nicholas, of Hadle 1
4585328 2226834 2226834 defendant Kempston William   586311 586311 Kempston, William, of Hadle 0
4585400 2226857 2226857 defendant Man Henry   586311 586311 Man, Henry, of Hadle 1
4585401 2226857 2226857 defendant Barker John   586311 586311 Barker, John, of Hadle 2
4588860 2227890 2227890 plaintiff Langeford Thomas   586311 586311 Langeford, Thomas, of Hadle 0
4589158 2227988 2227988 defendant Bayn William   586311 586311 Bayn, William, of Hadle 0
4594889 2229655 2229655 defendant Multon John   586311 586311 Multon, John, of Hadle 0
4596032 2230007 2230007 defendant Leg Simon   586311 586311 Leg, Simon, of Hadle 0
4596648 2230188 2230188 defendant Palmer William   586311 586311 Palmer, William, of Hadle 0
4596651 2230189 2230189 defendant Benet John   586311 586311 Benet, John, of Hadle 1
4599352 2231016 2231016 defendant Bayn Thomas   586311 586311 Bayn, Thomas, of Hadle 0
4605246 2232808 2232808 plaintiff Ardley Thomas (legal representative) 586311 586311 Ardley, Thomas, of Hadle, executors of 0
4615177 2235754 2235754 plaintiff Everard William   586311 586311 Everard, William, of Hadle 0
4619338 2237041 2237041 defendant Dade Thomas   586311 586311 Dade, Thomas, of Hadle 5
4621362 2237673 2237673 defendant Pope Henry draper 586311 586311 Pope, Henry, of Hadle, draper 1
4632270 2240980 2240980 defendant Arnesby William   586311 586311 Arnesby, William, of Hadle 0
4633570 2241354 2241354 defendant Reynold John   586311 586311 Reynold, John, of Hadle 0
4637813 2242598 2242598 defendant Bayn John   586311 586311 Bayn, John, of Hadle 2
4637818 2242599 2242599 defendant Bayn John   586311 586311 Bayn, John, of Hadle 1
4638286 2242744 2242744 defendant Stoke Richard   586311 586311 Stoke, Richard, of Hadle 0
4638287 2242744 2242744 defendant Tylere Roger   586311 586311 Tylere, Roger, of Hadle 1
4638289 2242744 2242744 defendant Kempe John   586311 586311 Kempe, John, of Hadle 3
4638290 2242744 2242744 defendant Wade John   586311 586311 Wade, John, of Hadle 4
4642879 2244026 2244026 defendant Chaumbyrlayn Henry   586311 586311 Chaumbyrlayn, Henry, of Hadle 6
4645891 2244867 2244867 defendant Frost John   586311 586311 Frost, John, of Hadle 0
4645899 2244869 2244869 defendant Bryd_ John fuller 586311 586311 Bryd_, John, of Hadle, fuller 4
4646235 2244971 2244971 defendant Fisshere Richard   586311 586311 Fisshere, Richard, of Hadle 0
4646237 2244971 2244971 defendant Gowene John summoner 586311 586311 Gowene, John, of Hadle, summoner 2
4646239 2244971 2244971 defendant Wade John   586311 586311 Wade, John, of Hadle 4
4656525 2247937 2247937 defendant Balle John   586311 586311 Balle, John, of Hadle, wire drawer 0
4673998 2257483 2257483 defendant Bakere William yeoman 586311 586311 Bakere, William, of Hadle, yeoman 0
4674000 2257483 2257483 defendant Strangman John, junior draper 586311 586311 Strangman, John, junior, of Hadle, draper 2
4675846 2258054 2258054 defendant Wynnelove John laborer 586311 586311 Wynnelove, John, of Hadle, laborer 1
4679701 2259268 2259268 defendant Lorkyn John barber 586311 586311 Lorkyn, John, of Hadle, barber 0
4679702 2259268 2259268 defendant Mouchesy John fuller 586311 586311 Mouchesy, John, of Hadle, fuller 1
4682246 2260070 2260070 defendant Lambe William glover 586311 586311 Lambe, William, of Hadle, glover 2
4684485 2260750 2260750 defendant Knapton John yeoman 586311 586311 Knapton, John, of Hadle, yeoman 0
4686910 2261512 2261512 defendant Ballesden William chapman 586311 586311 Ballesden, William, of Hadle, chapman 2
4688361 2261926 2261926 defendant Clerk John   586311 586311 Clerk, John, of Hadle, wright 0
4688364 2261927 2261927 defendant Clerk John   586311 586311 Clerk, John, of Hadle, wright 0
4690308 2262524 2262524 defendant Carter Richard   586311 586311 Carter, Richard, of Hadle 0
4697282 2264630 2264630 defendant Dade Thomas yeoman 586311 586311 Dade, Thomas, of Hadle, yeoman 0
4698946 2265147 2265147 defendant Lodbrok Thomas yeoman 586311 586311 Lodbrok, Thomas, of Hadle, yeoman 6
4706678 2267471 2267471 defendant Halton John husbandman 586311 586311 Halton, John, of Hadle, husbandman 0
4707707 2267776 2267776 defendant Couper John cooper 586311 586311 Couper, John, of Hadle, cooper 0
4716392 2270446 2270446 defendant Lambe William   586311 586311 Lambe, William, of Hadle, glove maker 0
4722351 2272313 2272313 defendant Curteys Thomas taverner 586311 586311 Curteys, Thomas, of Hadle, taverner 0
4722353 2272313 2272313 defendant Lelye Thomas dyer 586311 586311 Lelye, Thomas, of Hadle, dyer 2
4722354 2272313 2272313 defendant Dade Thomas yeoman 586311 586311 Dade, Thomas, of Hadle, yeoman 3
4722355 2272313 2272313 defendant Parker John taverner 586311 586311 Parker, John, of Hadle, taverner 4
4722359 2272314 2272314 defendant Curteys Thomas taverner 586311 586311 Curteys, Thomas, of Hadle, taverner 0
4722361 2272314 2272314 defendant Lelye Thomas dyer 586311 586311 Lelye, Thomas, of Hadle, dyer 2
4722362 2272314 2272314 defendant Dade Thomas yeoman 586311 586311 Dade, Thomas, of Hadle, yeoman 3
4722363 2272314 2272314 defendant Parker John tanner 586311 586311 Parker, John, of Hadle, tanner 4
4733202 2275564 2275564 defendant Knapton John yeoman 586311 586311 Knapton, John, of Hadle, yeoman 0
4741129 2277910 2277910 defendant Daunce John husbandman 586311 586311 Daunce, John, of Hadle, husbandman 0
4744297 2278855 2278855 defendant Benecroft John yeoman 586311 586311 Benecroft, John, of Hadle, yeoman 0
4744300 2278855 2278855 defendant Kyng John weaver 586311 586311 Kyng, John, of Hadle, weaver 3
4746498 2279468 2279468 defendant Hacston John yeoman 586311 586311 Hacston, John, of Hadle, yeoman 0
4746499 2279468 2279468 defendant Bayne William yeoman 586311 586311 Bayne, William, of Hadle, yeoman 1
4746500 2279468 2279468 defendant Cokefeld John cardmaker 586311 586311 Cokefeld, John, of Hadle, cardmaker 2
4746501 2279468 2279468 defendant Ernewe John yeoman 586311 586311 Ernewe, John, of Hadle, yeoman 3
4749663 2280388 2280388 defendant Armysby William yeoman 586311 586311 Armysby, William, of Hadle, yeoman 0
4751667 2280977 2280977 defendant Markele Thomas yeoman 586311 586311 Markele, Thomas, of Hadle, yeoman 0
4751668 2280977 2280977 defendant Cokkerell Simon yeoman 586311 586311 Cokkerell, Simon, of Hadle, yeoman 1
4751669 2280977 2280977 defendant Wynnelove John yeoman 586311 586311 Wynnelove, John, of Hadle, yeoman 2
4751670 2280977 2280977 defendant Maytons Nicholas yeoman 586311 586311 Maytons, Nicholas, of Hadle, yeoman 3
4752110 2281099 2281099 defendant Parker John yeoman 586311 586311 Parker, John, of Hadle, yeoman 0
4753426 2281447 2281447 defendant Mounchelsy John chapman 586311 586311 Mounchelsy, John, of Hadle, chapman 1
4753474 2281464 2281464 defendant Nenge John carpenter 586311 586311 Nenge, John, of Hadle, carpenter 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);