names

71 rows where place_id = 587478

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591523 1864974 1864974 defendant Tadymer Thomas pulter 587478 587478 Tadymer, Thomas, of Dodyngherst, pulter 2
3591557 1864984 1864984 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 0
3592486 1865266 1865266 defendant Lorkyn John yeoman 587478 587478 Lorkyn, John, of Dodyngherst, yeoman 0
3592488 1865267 1865267 defendant Lorkyn John yeoman 587478 587478 Lorkyn, John, of Dodyngherst, yeoman 0
3592490 1865267 1865267 defendant Wyndam alias Bleke John husbandman 587478 587478 Wyndam alias Bleke, John, of Dodyngherst, husbandman 2
3595245 1866147 1866147 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 2
3596090 1866406 1866406 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 0
3596093 1866407 1866407 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 1
3600810 1867915 1867915 defendant Wede John laborer 587478 587478 Wede, John, of Dodyngherst, laborer 0
3634739 1905660 1905660 defendant Elmeshale John gent 587478 587478 Elmeshale, John, of Dodyngherst, gent 1
3690036 1923042 1923042 defendant Baylly John husbandman 587478 587478 Baylly, John, of Dodyngherst, husbandman 3
3708830 1929058 1929058 defendant Watson John butcher 587478 587478 Watson, John, of Dodyngherst, butcher 1
3710915 1929732 1929732 defendant Bocher John butcher 587478 587478 Bocher, John, of Dodyngherst, butcher 2
3710920 1929733 1929733 defendant Bocher John butcher 587478 587478 Bocher, John, of Dodyngherst, butcher 2
3710925 1929734 1929734 defendant Bocher John butcher 587478 587478 Bocher, John, of Dodyngherst, butcher 2
3748442 1941447 1941447 defendant Bocher John butcher 587478 587478 Bocher, John, of Dodyngherst, butcher 1
3851287 1974001 1974001 defendant Colebroke Roger clerk 587478 587478 Colebroke, Roger, of Dodyngherst, clerk 0
4486531 2196497 2196497 defendant Parker Richard   587478 587478 Parker, Richard, of Dodyngherst 1
4487903 2196936 2196936 defendant Turnour Nicholas   587478 587478 Turnour, Nicholas, of Dodyngherst 0
4503059 2201527 2201527 defendant Aunger Adam   587478 587478 Aunger, Adam, of Dodyngherst 0
4503133 2201550 2201550 defendant Aunger Adam   587478 587478 Aunger, Adam, of Dodyngherst 0
4595325 2229790 2229790 defendant Bocher Robert   587478 587478 Bocher, Robert, of Dodyngherst 1
4661118 2249302 2249302 defendant Sayer Richard husbandman 587478 587478 Sayer, Richard, of Dodyngherst, husbandman 0
4661477 2249417 2249417 defendant Serle William yeoman 587478 587478 Serle, William, of Dodyngherst, yeoman 0
4687480 2261680 2261680 defendant Hert John tanner 587478 587478 Hert, John, of Dodyngherst, tanner 0
4725777 2273350 2273350 defendant atte Style John yeoman 587478 587478 atte Style, John, of Dodyngherst, yeoman 0
4725780 2273351 2273351 defendant atte Style John yeoman 587478 587478 atte Style, John, of Dodyngherst, yeoman 1
4764706 2284949 2284949 defendant atte Style John butcher 587478 587478 atte Style, John, of Dodyngherst, butcher 0
4865379 2316141 2316141 defendant Pope Richard husbandman 587478 587478 Pope, Richard, of Dodyngherst, husbandman 1
4906290 2328555 2328555 defendant Ferrour or Smith William smith 587478 587478 Ferrour or Smith, William, of Dodyngherst, smith 0
4909298 2329451 2329451 defendant Danby Geoffrey yeoman 587478 587478 Danby, Geoffrey, of Dodyngherst, yeoman 0
4981016 2351255 2351255 defendant Boltere John fisher 587478 587478 Boltere, John, of Dodyngherst, fisher 1
4984130 2352185 2352185 defendant Felde John husbandman 587478 587478 Felde, John, of Dodyngherst, husbandman 2
4984134 2352186 2352186 defendant Felde John husbandman 587478 587478 Felde, John, of Dodyngherst, husbandman 2
5000725 2357087 2357087 defendant Cole James laborer 587478 587478 Cole, James, of Dodyngherst, laborer 3
5000730 2357088 2357088 defendant Cole James laborer 587478 587478 Cole, James, of Dodyngherst, laborer 3
5019690 2362640 2362640 defendant Felde John yeoman 587478 587478 Felde, John, of Dodyngherst, yeoman 0
5022059 2363345 2363345 defendant Welles William husbandman 587478 587478 Welles, William, of Dodyngherst, husbandman 1
5022060 2363345 2363345 defendant Pope John husbandman 587478 587478 Pope, John, of Dodyngherst, husbandman 2
5026415 2364614 2364614 defendant Feld John husbandman 587478 587478 Feld, John, of Dodyngherst, husbandman 1
5029008 2365354 2365354 defendant Sewale John husbandman 587478 587478 Sewale, John, of Dodyngherst, husbandman 1
5029010 2365355 2365355 defendant Sewale John husbandman 587478 587478 Sewale, John, of Dodyngherst, husbandman 0
5033480 2366675 2366675 defendant Sewale John husbandman 587478 587478 Sewale, John, of Dodyngherst, husbandman 0
5050005 2371622 2371622 defendant Bogher John carpenter 587478 587478 Bogher, John, of Dodyngherst, carpenter 2
5139498 2398038 2398038 defendant Bank Robert yeoman 587478 587478 Bank, Robert, of Dodyngherst, yeoman 1
5175273 2408460 2408460 defendant Bank Robert yeoman 587478 587478 Bank, Robert, of Dodyngherst, yeoman 1
5222956 2422429 2422429 defendant Raynold Thomas laborer 587478 587478 Raynold, Thomas, of Dodyngherst, laborer 2
5224323 2422789 2422789 defendant Reynold William (legal representative) 587478 587478 Reynold, William, of Dodyngherst, tanner, executors of 0
5232477 2425077 2425077 defendant Peche Richard husbandman 587478 587478 Peche, Richard, of Dodyngherst, husbandman 0
5232478 2425077 2425077 defendant Peche Thomas laborer 587478 587478 Peche, Thomas, of Dodyngherst, laborer 1
5232479 2425077 2425077 defendant Ferby William   587478 587478 Ferby, William, of Dodyngherst, servant 2
5244881 2428676 2428676 defendant Reynold William (legal representative) 587478 587478 Reynold, William, of Dodyngherst, Essex tanner, executors of 0
5244883 2428676 2428676 defendant Spencer John tanner 587478 587478 Spencer, John, of Dodyngherst, tanner 2
5244979 2428706 2428706 defendant Pope John husbandman 587478 587478 Pope, John, of Dodyngherst, husbandman 0
5254030 2431380 2431380 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 0
5317873 2450432 2450432 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 0
5317874 2450432 2450432 defendant Reynold William pulter 587478 587478 Reynold, William, of Dodyngherst, pulter 1
5319687 2450984 2450984 defendant Glover Thomas gent 587478 587478 Glover, Thomas, of Dodyngherst, gent 0
5369432 2466032 2466032 defendant Shepman Thomas husbandman 587478 587478 Shepman, Thomas, of Dodyngherst, husbandman 1
5371373 2466626 2466626 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 1
5444340 2488213 2488213 defendant Reynold William husbandman 587478 587478 Reynold, William, of Dodyngherst, husbandman 0
5444341 2488213 2488213 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 1
5463868 2494107 2494107 defendant Reynold William husbandman 587478 587478 Reynold, William, of Dodyngherst, husbandman 0
5463869 2494107 2494107 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 1
5475986 2497829 2497829 defendant Lorkyn John husbandman 587478 587478 Lorkyn, John, of Dodyngherst, husbandman 0
5481447 2499386 2499386 defendant Lorkyn William husbandman 587478 587478 Lorkyn, William, of Dodyngherst, husbandman 0
5481448 2499386 2499386 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 1
5481664 2499447 2499447 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 2
5503659 2506058 2506058 defendant Lorkyn John butcher 587478 587478 Lorkyn, John, of Dodyngherst, butcher 1
5503660 2506058 2506058 defendant Hose John smith 587478 587478 Hose, John, of Dodyngherst, smith 2
5547031 2519137 2519137 defendant Marden George husbandman 587478 587478 (Marden, George, of Dodyngherst, husbandman 1

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);