names

456 rows where place_id = 588300

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594038 1865775 1865775 defendant Pynfeld William butcher 588300 588300 Pynfeld, William, of Dunstaple, butcher 1
3596164 1866430 1866430 defendant Hebbys or Hewys William chapman 588300 588300 Hebbys or Hewys, William, of Dunstaple, chapman 0
3596201 1866441 1866441 defendant Pynfold William butcher 588300 588300 Pynfold, William, of Dunstaple, butcher 0
3596857 1866652 1866652 defendant Hunt William innholder 588300 588300 Hunt, William, of Dunstaple, innholder 4
3603737 1868840 1868840 defendant Portaleyn Thomas painter 588300 588300 Portaleyn, Thomas, of Dunstaple, painter 0
3606797 1869799 1869799 defendant Knyghtley William carpenter 588300 588300 Knyghtley, William, of Dunstaple, carpenter 0
3616906 1872918 1872918 defendant Rede William chapman 588300 588300 Rede, William, of Dunstaple, chapman 3
3622540 1874587 1874587 defendant Straton Thomas husbandman 588300 588300 Straton, Thomas, of Dunstaple, husbandman 0
3626224 1903058 1903058 defendant Elys Henry painter 588300 588300 Elys, Henry, of Dunstaple, painter 1
3636497 1906207 1906207 defendant Leonard Cecily widow 588300 588300 Leonard, Cecily, of Dunstaple, widow 0
3679972 1919800 1919800 plaintiff Purvey Nicholas yeoman 588300 588300 Purvey, Nicholas, of Dunstaple, yeoman 0
3679973 1919800 1919800 defendant Knyghtley Robert yeoman 588300 588300 Knyghtley, Robert, of Dunstaple, yeoman 0
3714957 1930975 1930975 plaintiff Bradman Ambrose gent 588300 588300 Bradman, Ambrose, of Dunstaple, gent 0
3714958 1930975 1930975 defendant Kent John yeoman 588300 588300 Kent, John, of Dunstaple, yeoman 0
3714959 1930976 1930976 plaintiff Bradman Ambrose gent 588300 588300 Bradman, Ambrose, of Dunstaple, gent 0
3714960 1930976 1930976 defendant Kent John yeoman 588300 588300 Kent, John, of Dunstaple, yeoman 0
3735067 1937208 1937208 plaintiff Gyrton Robert gent 588300 588300 Gyrton, Robert, of Dunstaple, or of Ivyngho, Bucks, gent 0
3735070 1937208 1937208 defendant Wyllyams James carver 588300 588300 Wyllyams, James, of Dunstaple, carver 2
3797966 1957262 1957262 defendant Cavendissh George gent 588300 588300 Cavendissh, George, of Dunstaple, gent 0
3834953 1968869 1968869 defendant Hylton Adam yeoman 588300 588300 Hylton, Adam, of Dunstaple, yeoman 0
3846924 1972576 1972576 defendant Cavendysh George   588300 588300 Cavendysh, George, of Dunstaple 0
3846926 1972577 1972577 defendant Cavendysh George gent 588300 588300 Cavendysh, George, of Dunstaple, gent 0
3862353 1977598 1977598 defendant Cavendysshe George gent 588300 588300 Cavendysshe, George, of Dunstaple, gent 0
3876633 1982431 1982431 defendant Cavendyssh George gent 588300 588300 Cavendyssh, George, of Dunstaple, gent 0
3882387 1984373 1984373 defendant Alen Robert tailor 588300 588300 Alen, Robert, of Dunstaple, tailor 0
3887345 1986032 1986032 defendant Brandley Richard gent 588300 588300 Brandley, Richard, of Dunstaple, gent 0
3919714 1996932 1996932 plaintiff Longe John (legal representative) 588300 588300 Longe, John, of Dunstaple, maltman, executrix of 0
3954633 2008686 2008686 defendant Butler John gent 588300 588300 Butler, John, of Dunstaple, gent 0
3955385 2008948 2008948 defendant Dermar Richard chapman or mercer 588300 588300 Dermar, Richard, of Dunstaple, chapman or mercer 0
3978477 2017054 2017054 defendant Tydye James yeoman 588300 588300 Tydye, James, of Dunstaple, yeoman 0
3994320 2022722 2022722 defendant Davy John yeoman 588300 588300 Davy, John, of Dunstaple, yeoman 0
3994321 2022722 2022722 defendant Tample John husbandman 588300 588300 Tample, John, of Dunstaple, husbandman 1
3994322 2022722 2022722 defendant Bennett Roland laborer 588300 588300 Bennett, Roland, of Dunstaple, laborer 2
3994323 2022722 2022722 defendant Glover Thomas shoemaker 588300 588300 Glover, Thomas, of Dunstaple, shoemaker 3
3994324 2022722 2022722 defendant Fenton William laborer 588300 588300 Fenton, William, of Dunstaple, laborer 4
3994332 2022725 2022725 defendant Davye Richard yeoman 588300 588300 (Davye, Richard, of Dunstaple, yeoman 1
3994333 2022725 2022725 defendant Davye John yeoman 588300 588300 Davye, John, of Dunstaple, yeoman 2
3994868 2022919 2022919 defendant Davy John yeoman 588300 588300 Davy, John, of Dunstaple, yeoman 0
3994869 2022919 2022919 defendant Temple John husbandman 588300 588300 Temple, John, of Dunstaple, husbandman 1
3994870 2022919 2022919 defendant Bennett Roland laborer 588300 588300 Bennett, Roland, of Dunstaple, laborer 2
3994871 2022919 2022919 defendant Glover Thomas shoemaker 588300 588300 Glover, Thomas, of Dunstaple, shoemaker 3
3994872 2022919 2022919 defendant Fenton William laborer 588300 588300 Fenton, William, of Dunstaple, laborer 4
4006803 2027211 2027211 defendant Temple Thomas husbandman 588300 588300 Temple, Thomas, of Dunstaple, husbandman 0
4006805 2027212 2027212 defendant Brygges Richard tailor 588300 588300 Brygges, Richard, of Dunstaple, tailor 0
4026190 2034015 2034015 defendant Temple Thomas husbandman 588300 588300 Temple, Thomas, of Dunstaple, husbandman 0
4114413 2065439 2065439 defendant Medgate John yeoman 588300 588300 Medgate, John, of Dunstaple, yeoman 0
4358851 2150329 2150329 defendant Langto Thomas yeoman 588300 588300 Langto, Thomas, of Dunstaple, yeoman 2
4420399 2171286 2171286 defendant Coke Gilbert le   588300 588300 Coke, Gilbert le, of Dunstaple 0
4443688 2182994 2182994 defendant Markaunt John   588300 588300 Markaunt, John, of Dunstaple 0
4446609 2183855 2183855 plaintiff Derlyng Walter   588300 588300 Derlyng, Walter, of Dunstaple 0
4484542 2195858 2195858 defendant Russell William   588300 588300 Russell, William, of Dunstaple 0
4490071 2197611 2197611 plaintiff Umfrey Simon   588300 588300 Umfrey, Simon, of Dunstaple 0
4494687 2199032 2199032 defendant Gery Thomas   588300 588300 Gery, Thomas, of Dunstaple 1
4505257 2202175 2202175 plaintiff Smyth John   588300 588300 Smyth, John, of Dunstaple, on his own account 0
4505258 2202175 2202175 defendant Tyler Ivan   588300 588300 Tyler, Ivan, of Dunstaple 0
4509322 2203390 2203390 defendant Umphrey Simon   588300 588300 Umphrey, Simon, of Dunstaple 0
4509971 2203603 2203603 plaintiff Bakere John   588300 588300 Bakere, John, of Dunstaple 0
4513502 2204649 2204649 defendant London Thomas   588300 588300 London, Thomas, of Dunstaple 0
4515779 2205362 2205362 plaintiff Clerk William hosteller 588300 588300 Clerk, William, of Dunstaple, hosteller 0
4521597 2207088 2207088 defendant Pulter John   588300 588300 Pulter, John, of Dunstaple 0
4521598 2207088 2207088 defendant Brigge John   588300 588300 Brigge, John, of Dunstaple 1
4521606 2207089 2207089 defendant Pulter John   588300 588300 Pulter, John, of Dunstaple 0
4521607 2207089 2207089 defendant Brygge John   588300 588300 Brygge, John, of Dunstaple 1
4523808 2207775 2207775 plaintiff Hente John   588300 588300 Hente, John, of Dunstaple, on his own account 0
4527544 2208892 2208892 defendant Baker John   588300 588300 Baker, John, of Dunstaple 0
4527545 2208892 2208892 defendant Cookes Roger   588300 588300 Cookes, Roger, of Dunstaple 1
4527786 2208965 2208965 defendant Russell William   588300 588300 Russell, William, of Dunstaple 0
4542900 2213672 2213672 plaintiff Anable William   588300 588300 Anable, William, of Dunstaple 0
4543898 2213993 2213993 defendant Hemyngford Robert   588300 588300 Hemyngford, Robert, of Dunstaple 0
4546941 2214976 2214976 defendant Gryg John chapman 588300 588300 Gryg, John, of Dunstaple, chapman 0
4547480 2215142 2215142 defendant Trought John   588300 588300 Trought, John, of Dunstaple 0
4551455 2216393 2216393 defendant Umfrey Simon   588300 588300 Umfrey, Simon, of Dunstaple 0
4558245 2218522 2218522 plaintiff London Thomas   588300 588300 London, Thomas, of Dunstaple 0
4561656 2219579 2219579 defendant Blount John   588300 588300 Blount, John, of Dunstaple 0
4562005 2219683 2219683 defendant Newelove Richard   588300 588300 Newelove, Richard, of Dunstaple 4
4562843 2219938 2219938 defendant Milys Richard   588300 588300 Milys, Richard, of Dunstaple 0
4564895 2220584 2220584 defendant Lexham Richard   588300 588300 Lexham, Richard, of Dunstaple 1
4565539 2220793 2220793 defendant Pybaker Henry   588300 588300 Pybaker, Henry, of Dunstaple 0
4572433 2222918 2222918 defendant Blunt John   588300 588300 Blunt, John, of Dunstaple 0
4572436 2222919 2222919 defendant Blunt John   588300 588300 Blunt, John, of Dunstaple 0
4575205 2223766 2223766 defendant Merston Thomas   588300 588300 Merston, Thomas, of Dunstaple 0
4577192 2224381 2224381 plaintiff Holme John mercer 588300 588300 (Holme, John, of Dunstaple, mercer 1
4581420 2225655 2225655 defendant Jakes Thomas   588300 588300 Jakes, Thomas, of Dunstaple 0
4581422 2225656 2225656 defendant Morley Richard   588300 588300 Morley, Richard, of Dunstaple 0
4586076 2227071 2227071 plaintiff Hele Thomas   588300 588300 Hele, Thomas, of Dunstaple 0
4602878 2232113 2232113 defendant Martyn John   588300 588300 Martyn, John, of Dunstaple 0
4622230 2237933 2237933 plaintiff London Thomas maltman 588300 588300 London, Thomas, of Dunstaple, maltman 0
4630421 2240424 2240424 defendant Myls Richard   588300 588300 Myls, Richard, of Dunstaple 0
4632392 2241020 2241020 defendant Ordewey Richard   588300 588300 Ordewey, Richard, of Dunstaple 1
4633966 2241476 2241476 plaintiff White Henry   588300 588300 White, Henry, of Dunstaple 0
4635720 2242016 2242016 defendant Buske John   588300 588300 Buske, John, of Dunstaple 1
4643006 2244062 2244062 plaintiff Holm John (legal representative) 588300 588300 Holm, John, of Dunstaple, mercer, executors of 0
4643007 2244062 2244062 plaintiff Banham John   588300 588300 (Banham, John, of Dunstaple 1
4647516 2245333 2245333 defendant Myle Richard   588300 588300 Myle, Richard, of Dunstaple 1
4654112 2247167 2247167 defendant Neel William husbandman 588300 588300 Neel, William, of Dunstaple, husbandman 0
4654114 2247168 2247168 defendant Neell William husbandman 588300 588300 Neell, William, of Dunstaple, husbandman 0
4654287 2247220 2247220 defendant Neel William hosteler 588300 588300 Neel, William, of Dunstaple, hosteler 1
4654486 2247278 2247278 plaintiff Boldro John miller 588300 588300 Boldro, John, of Dunstaple, miller 0
4669271 2256097 2256097 plaintiff Boldre John miller 588300 588300 Boldre, John, of Dunstaple, miller 0
4670138 2256364 2256364 defendant Edwyn John shoemaker 588300 588300 Edwyn, John, of Dunstaple, shoemaker 1

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