names

71 rows where place_id = 587485

✎ 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
3591539 1864979 1864979 defendant Burges John miller 587485 587485 Burges, John, of Stratford Langthorn, Essex, miller 3
3591544 1864980 1864980 defendant Burges John miller 587485 587485 Burges, John, of Stratford Langthorn, Essex, miller 3
3591551 1864981 1864981 defendant Burges John miller 587485 587485 Burges, John, of Stratford Langthorn, Essex, miller 4
3621686 1874322 1874322 defendant Jervys John yeoman 587485 587485 Jervys, John, of Stratford Langthorn, Essex, yeoman 0
3702646 1927095 1927095 defendant Banes Thomas yeoman 587485 587485 Banes, Thomas, of Stratford Langthorn, Essex, yeoman 0
3774702 1949819 1949819 defendant Osborne John tanner 587485 587485 Osborne, John, of Stratford Langthorn, Essex, tanner 1
3826544 1966149 1966149 defendant Fissher Elizabeth widow 587485 587485 Fissher, Elizabeth, of Stratford Langthorn, Essex, widow 2
3827619 1966498 1966498 defendant Byklond John yeoman 587485 587485 Byklond, John, of Stratford Langthorn, Essex, yeoman 2
3931150 2000718 2000718 defendant Taverner Silverster gent 587485 587485 Taverner, Silverster, of Stratford Langthorn, Essex, gent 1
3981320 2018087 2018087 defendant Posland John gent 587485 587485 Posland, John, of Stratford Langthorn, Essex, gent 0
4620114 2237271 2237271 defendant Lecche William tanner 587485 587485 Lecche, William, of Stratford Langthorn, Essex, tanner 0
4666210 2250903 2250903 defendant Toleys John fisher 587485 587485 Toleys, John, of Stratford Langthorn, Essex, fisher 3
4781963 2290363 2290363 defendant Skynner William   587485 587485 Skynner, William, of Stratford Langthorn, Essex, "tewyer" 1
4840341 2308524 2308524 defendant Blakhed Roger husbandman 587485 587485 Blakhed, Roger, of Stratford Langthorn, Essex, husbandman 0
4907456 2328893 2328893 defendant Wodecok John   587485 587485 Wodecok, John, of Stratford Langthorn, Essex, bladesmith 0
5058615 2374135 2374135 defendant Havelok William smith 587485 587485 Havelok, William, of Stratford Langthorn, Essex, smith 0
5070396 2377639 2377639 defendant Heywode William brewer 587485 587485 Heywode, William, of Stratford Langthorn, Essex, brewer 0
5077086 2379647 2379647 defendant Havelok William smith 587485 587485 Havelok, William, of Stratford Langthorn, Essex, smith 0
5101438 2386833 2386833 defendant Parker Richard tanner 587485 587485 Parker, Richard, of Stratford Langthorn, Essex, tanner 1
5124336 2393565 2393565 defendant Newenton John yeoman 587485 587485 Newenton, John, of Stratford Langthorn, Essex, yeoman 0
5140937 2398468 2398468 defendant Ky--gesman William   587485 587485 Ky--gesman, William, of Stratford Langthorn, Essex, shoe maker 2
5159909 2403995 2403995 defendant Haywode William husbandman 587485 587485 Haywode, William, of Stratford Langthorn, Essex, husbandman 1
5160270 2404099 2404099 defendant Ferers John esq 587485 587485 Ferers, John, of Stratford Langthorn, Essex, esq 0
5160273 2404100 2404100 defendant Ferers John esq 587485 587485 Ferers, John, of Stratford Langthorn, Essex, esq 0
5162058 2404638 2404638 defendant Kyngesman William   587485 587485 Kyngesman, William, of Stratford Langthorn, Essex, shoe maker 2
5162064 2404639 2404639 defendant Kyngesman William shoemaker 587485 587485 Kyngesman, William, of Stratford Langthorn, Essex, shoemaker 2
5174879 2408348 2408348 defendant Haywode William husbandman 587485 587485 Haywode, William, of Stratford Langthorn, Essex, husbandman 1
5174880 2408348 2408348 defendant Havelok William brewer 587485 587485 Havelok, William, of Stratford Langthorn, Essex, brewer 2
5193237 2413752 2413752 defendant Reffeld John   587485 587485 Reffeld, John, of Stratford Langthorn, Essex, abbot of the monastery of the BM 0
5195732 2414495 2414495 defendant Haywode William husbandman 587485 587485 Haywode, William, of Stratford Langthorn, Essex, husbandman 0
5196174 2414627 2414627 defendant Ferers John esq 587485 587485 Ferers, John, of Stratford Langthorn, Essex, esq 0
5205804 2417435 2417435 defendant Fraunces John sawyer 587485 587485 Fraunces, John, of Stratford Langthorn, Essex, sawyer 2
5244548 2428587 2428587 defendant (not given) Richard   587485 587485 Blank, Richard, of Stratford Langthorn, Essex, tallow chandler 1
5252863 2431010 2431010 defendant Lasomby William tanner 587485 587485 Lasomby, William, of Stratford Langthorn, Essex, tanner 0
5267406 2435570 2435570 defendant Lambe John brewer 587485 587485 Lambe, John, of Stratford Langthorn, Essex, brewer 1
5267409 2435571 2435571 defendant Lambe John brewer 587485 587485 Lambe, John, of Stratford Langthorn, Essex, brewer 1
5271037 2436623 2436623 defendant Bylte William   587485 587485 Bylte, William, of Stratford Langthorn, Essex, wheel wright 2
5272609 2437063 2437063 defendant Watford Hugh   587485 587485 Watford, Hugh, of Stratford Langthorn, Essex, abbot 0
5280042 2439236 2439236 defendant Burgeys John miller 587485 587485 Burgeys, John, of Stratford Langthorn, Essex, miller 0
5280145 2439265 2439265 plaintiff Jenyn John yeoman 587485 587485 Jenyn, John, of Stratford Langthorn, Essex, yeoman 1
5292408 2442777 2442777 defendant Whetehede William yeoman 587485 587485 Whetehede, William, of Stratford Langthorn, Essex, yeoman 0
5292414 2442779 2442779 defendant Whitehede William yeoman 587485 587485 Whitehede, William,of Stratford Langthorn, Essex, yeoman 0
5315240 2449613 2449613 defendant Burgeys John miller 587485 587485 Burgeys, John, of Stratford Langthorn, Essex, miller 1
5319492 2450922 2450922 defendant Forster John gent 587485 587485 Forster, John, of Stratford Langthorn, Essex, gent 1
5322015 2451653 2451653 defendant Cleffe John husbandman 587485 587485 Cleffe, John, of Stratford Langthorn, Essex, husbandman 1
5376663 2468295 2468295 defendant Batell John gent 587485 587485 Batell, John, of Stratford Langthorn, Essex, gent 0
5382698 2470111 2470111 defendant Sewall Thomas yeoman 587485 587485 Sewall, Thomas, of Stratford Langthorn, Essex, yeoman 0
5382703 2470112 2470112 defendant Sewall Thomas yeoman 587485 587485 Sewall, Thomas, of Stratford Langthorn, Essex, yeoman 0
5392884 2473037 2473037 defendant Sewall Thomas   587485 587485 Sewall, Thomas, of Stratford Langthorn, Essex 0
5401965 2475620 2475620 defendant Bataill Henry esq 587485 587485 Bataill, Henry, of Stratford Langthorn, Essex, esq 0
5437104 2486035 2486035 defendant Batell John gent 587485 587485 Batell, John, of Stratford Langthorn, Essex, gent 0
5451578 2490347 2490347 defendant (illegible) John gent 587485 587485 _, John, of Stratford Langthorn, Essex, gent 0
5451584 2490348 2490348 defendant (illegible) John gent 587485 587485 _, John, of Stratford Langthorn, Essex, gent 0
5451588 2490348 2490348 defendant Wryght Richard butcher 587485 587485 Wryght, Richard, of Stratford Langthorn, Essex, butcher 4
5467856 2495325 2495325 defendant Russhe Robert baker 587485 587485 Russhe, Robert, of Stratford Langthorn, Essex, baker 1
5488593 2501472 2501472 defendant Root John brewer 587485 587485 Root, John, of Stratford Langthorn, Essex, brewer 0
5488599 2501474 2501474 defendant Root John brewer 587485 587485 Root, John,of Stratford Langthorn, Essex, brewer 0
5497576 2504216 2504216 defendant Burgeys John miller 587485 587485 Burgeys, John, of Stratford Langthorn, Essex, miller 1
5500966 2505237 2505237 defendant Batell John gent 587485 587485 Batell, John, of Stratford Langthorn, Essex, gent 3
5505404 2506604 2506604 defendant Roote John brewer 587485 587485 Roote, John, of Stratford Langthorn, Essex, brewer 0
5515549 2509706 2509706 defendant Stevyns John miller 587485 587485 Stevyns, John, of Stratford Langthorn, Essex, miller 3
5519435 2510927 2510927 defendant Clare Henry cordwainer 587485 587485 Clare, Henry, of Stratford Langthorn, Essex, cordwainer 2
5527454 2513169 2513169 defendant Fanne John   587485 587485 Fanne, John, of Stratford Langthorn, Essex, collar maker 0
5531286 2514302 2514302 defendant Bakewell John tanner 587485 587485 Bakewell, John, of Stratford Langthorn, Essex, tanner 0
5531291 2514304 2514304 defendant Blakewell John tanner 587485 587485 Blakewell, John, of Stratford Langthorn, Essex, tanner 1
5549969 2520028 2520028 defendant Gaston alias Gaskyn Reginald gent 587485 587485 Gaston alias Gaskyn, Reginald, of Stratford Langthorn, Essex, gent 0
5576127 2527596 2527596 defendant Parker Richard tanner 587485 587485 Parker, Richard, of Stratford Langthorn, Essex, tanner 0
5600281 2534972 2534972 defendant Cotes William tanner 587485 587485 Cotes, William, of Stratford Langthorn, Essex, tanner 1
5605764 2536690 2536690 defendant Osborne John tanner 587485 587485 Osborne, John, of Stratford Langthorn, Essex, tanner 5
5605771 2536691 2536691 defendant Osborne John tanner 587485 587485 Osborne, John, of Stratford Langthorn, Essex, tanner 5
5609435 2537848 2537848 plaintiff Sewell Thomas yeoman 587485 587485 Sewell, Thomas, of Stratford Langthorn, Essex, yeoman 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);