names

73 rows where place_id = 590965

✎ 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
3602842 1868559 1868559 defendant Yarham John, junior carpenter 590965 590965 Yarham, John, junior, of Hyndolneston, carpenter 0
3603415 1868739 1868739 defendant Wodcroft Robert yeoman 590965 590965 Wodcroft, Robert, of Hyndolneston, yeoman 4
3603584 1868790 1868790 defendant Itryngham John yeoman 590965 590965 Itryngham, John, of Hyndolneston, yeoman 0
3603997 1868916 1868916 defendant Odams John yeoman 590965 590965 Odams, John, of Hyndolneston, yeoman 0
3604001 1868917 1868917 defendant Yareham John yeoman 590965 590965 Yareham, John, of Hyndolneston, yeoman 0
3604469 1869066 1869066 defendant Robyns John yeoman 590965 590965 Robyns, John, of Hyndolneston, yeoman 3
3606718 1869778 1869778 defendant Hunt Geoffrey yeoman 590965 590965 Hunt, Geoffrey, of Hyndolneston, yeoman 0
3608417 1870292 1870292 defendant Ryburgh John tailor 590965 590965 Ryburgh, John, of Hyndolneston, tailor 1
3608420 1870293 1870293 defendant Ryburgh John tailor 590965 590965 Ryburgh, John, of Hyndolneston, tailor 1
3608847 1870423 1870423 defendant Wodcrofte Robert yeman 590965 590965 Wodcrofte, Robert, of Hyndolneston, yeman 0
3608849 1870424 1870424 defendant Wodcrofte Robert yeoman 590965 590965 Wodcrofte, Robert, of Hyndolneston, yeoman 0
3612725 1871627 1871627 defendant Dykkes Reginald carpenter 590965 590965 Dykkes, Reginald, of Hyndolneston, carpenter 0
3613553 1871887 1871887 defendant Danyell William clerk 590965 590965 Danyell, William, of Hyndolneston, clerk 0
3613835 1871982 1871982 defendant Danyell William clerk 590965 590965 Danyell, William, of Hyndolneston, clerk 0
3614205 1872110 1872110 defendant Robyns John yeoman 590965 590965 Robyns, John, of Hyndolneston, yeoman 3
3614900 1872314 1872314 defendant Odams John carpenter 590965 590965 Odams, John, of Hyndolneston, carpenter 3
3616373 1872759 1872759 defendant Odams John carpenter 590965 590965 Odams, John, of Hyndolneston, carpenter 3
3619638 1873711 1873711 defendant Bonde John carpenter 590965 590965 Bonde, John, of Hyndolneston, carpenter 2
3625033 1875360 1875360 defendant Wodecrofte Robert yeoman 590965 590965 Wodecrofte, Robert, of Hyndolneston, yeoman 0
3625035 1875361 1875361 defendant Wodecrofte Robert yeoman 590965 590965 Wodecrofte, Robert, of Hyndolneston, yeoman 0
3641113 1907666 1907666 defendant Grene Richard husbandman 590965 590965 Grene, Richard, of Hyndolneston, husbandman 0
3696541 1925147 1925147 defendant Yarham John carpenter 590965 590965 Yarham, John, of Hyndolneston, carpenter 0
3701424 1926691 1926691 defendant Yerham John carpenter 590965 590965 Yerham, John, of Hyndolneston, carpenter 3
3703554 1927386 1927386 defendant Chapman Robert butcher 590965 590965 Chapman, Robert, of Hyndolneston, butcher 4
3757916 1944459 1944459 defendant Yerham John carpenter 590965 590965 Yerham, John, of Hyndolneston, carpenter 1
3845770 1972225 1972225 defendant Fraunces Robert husbandman 590965 590965 Fraunces, Robert, of Hyndolneston, husbandman 1
3921915 1997675 1997675 defendant Gylberd Robert shragger 590965 590965 Gylberd, Robert, of Hyndolneston, shragger 2
3952648 2007995 2007995 defendant Crystmas Robert husbandman 590965 590965 (Crystmas, Robert, of Hyndolneston, husbandman 1
4016107 2030457 2030457 plaintiff Starkey Peter merchant 590965 590965 Starkey, Peter, of Hyndolneston, gent, merchant 0
4184982 2090254 2090254 defendant Be- Humphrey husbandman 590965 590965 Be-, Humphrey, of Hyndolneston, husbandman 0
4189097 2091678 2091678 defendant Gylbert Robert yeoman 590965 590965 Gylbert, Robert, of Hyndolneston, yeoman 0
5020870 2363001 2363001 defendant Pernell George husbandman 590965 590965 Pernell, George, of Hyndolneston, husbandman 1
5067103 2376680 2376680 defendant Clerk Thomas   590965 590965 Clerk, Thomas, of Hyndolneston, servant 0
5115276 2390895 2390895 defendant Pernell Richard   590965 590965 Pernell, Richard, of Hyndolneston, freemason 0
5284371 2440447 2440447 defendant Hunt Geoffrey husbandman 590965 590965 Hunt, Geoffrey, of Hyndolneston, husbandman 0
5331000 2454337 2454337 defendant Iteryngham John husbandman 590965 590965 Iteryngham, John, of Hyndolneston, husbandman 0
5353009 2461030 2461030 defendant Aker Thomas (legal representative) 590965 590965 Aker, Thomas, of Hyndolneston, husbandman, administrator of 0
5353010 2461030 2461030 defendant Acres John, junior husbandman 590965 590965 Acres, John, junior, of Hyndolneston, husbandman 1
5355364 2461752 2461752 defendant Yarham John carpenter 590965 590965 Yarham, John, of Hyndolneston, carpenter 1
5359525 2463010 2463010 defendant Meryell John husbandman 590965 590965 Meryell, John, of Hyndolneston, husbandman 1
5359526 2463010 2463010 defendant Glemsford Robert laborer 590965 590965 Glemsford, Robert, of Hyndolneston, laborer 2
5359527 2463010 2463010 defendant Tyllyngton Richard laborer 590965 590965 Tyllyngton, Richard, of Hyndolneston, laborer 3
5362365 2463886 2463886 defendant Robynes John yeoman 590965 590965 Robynes, John, of Hyndolneston, yeoman 3
5480622 2499167 2499167 defendant Fuller Robert husbandman 590965 590965 Fuller, Robert, of Hyndolneston, husbandman 18
5481710 2499463 2499463 defendant Yarham John carpenter 590965 590965 Yarham, John, of Hyndolneston, carpenter 0
5486888 2500975 2500975 defendant Tylney Richard yeoman 590965 590965 Tylney, Richard, of Hyndolneston, yeoman 3
5497755 2504271 2504271 defendant Robyns John husbandman 590965 590965 Robyns, John, of Hyndolneston, husbandman 1
5497756 2504271 2504271 defendant Ryburgh John tailor 590965 590965 Ryburgh, John, of Hyndolneston, tailor 2
5498347 2504467 2504467 defendant Yarham John carpenter 590965 590965 Yarham, John, of Hyndolneston, carpenter 0
5498350 2504468 2504468 defendant Yarham John carpenter 590965 590965 Yarham, John, of Hyndolneston, carpenter 0
5498351 2504468 2504468 defendant Quarles Edmund yeoman 590965 590965 Quarles, Edmund, of Hyndolneston, yeoman 1
5498915 2504612 2504612 defendant Hunt Thomas chaplain 590965 590965 Hunt, Thomas, of Hyndolneston, chaplain 0
5498916 2504612 2504612 defendant Hunt Geoffrey husbandman 590965 590965 Hunt, Geoffrey, of Hyndolneston, husbandman 1
5506277 2506879 2506879 defendant Hunt Geoffrey gent 590965 590965 Hunt, Geoffrey, of Hyndolneston, gent 14
5507641 2507292 2507292 defendant Quarles Edmund yeoman 590965 590965 Quarles, Edmund, of Hyndolneston, yeoman 0
5507643 2507293 2507293 defendant Yerham John carpenter 590965 590965 Yerham, John, of Hyndolneston, carpenter 0
5508451 2507513 2507513 defendant Yarham John, senior carpenter 590965 590965 Yarham, John, senior, of Hyndolneston, carpenter 0
5512400 2508739 2508739 defendant Robyns John yeoman 590965 590965 Robyns, John, of Hyndolneston, yeoman 0
5518428 2510591 2510591 defendant Hunt Geoffrey yeoman 590965 590965 Hunt, Geoffrey, of Hyndolneston, yeoman 0
5518430 2510592 2510592 defendant Hunte Geoffrey yeoman 590965 590965 Hunte, Geoffrey, of Hyndolneston, yeoman 0
5520664 2511286 2511286 defendant Jarham William, junior carpenter 590965 590965 Jarham, William, junior, of Hyndolneston, carpenter 0
5526572 2512879 2512879 defendant Grene Edmund barker 590965 590965 Grene, Edmund, of Hyndolneston, barker 1
5526577 2512880 2512880 defendant Grene Edmund barker 590965 590965 Grene, Edmund, of Hyndolneston, barker 1
5531031 2514222 2514222 defendant Welle William husbandman 590965 590965 Welle, William, of Hyndolneston, husbandman 1
5533147 2514914 2514914 defendant Yarham Thomas husbandman 590965 590965 Yarham, Thomas, of Hyndolneston, husbandman 0
5533148 2514914 2514914 defendant Bonde John husbandman 590965 590965 Bonde, John, of Hyndolneston, husbandman 1
5533207 2514936 2514936 defendant Holmyn John husbandman 590965 590965 Holmyn, John, of Hyndolneston, husbandman 0
5540970 2517299 2517299 plaintiff Hunt Nicholas   590965 590965 Hunt, Nicholas, of Hyndolneston, bailiff 0
5550920 2520301 2520301 defendant Woodcrofte Robert yeoman 590965 590965 Woodcrofte, Robert, of Hyndolneston, yeoman 0
5553839 2521161 2521161 defendant Quarles Robert   590965 590965 Quarles, Robert, of Hyndolneston 0
5580863 2529091 2529091 defendant Sheryngham William butcher 590965 590965 Sheryngham, William, of Hyndolneston, butcher 1
5583318 2529855 2529855 plaintiff Franceys Henry (legal representative) 590965 590965 Franceys, Henry, of Hyndolneston, executors of 0
5600626 2535087 2535087 defendant Sheryngham William yeoman 590965 590965 Sheryngham, William, of Hyndolneston, 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);