How to search the databases

The Newpaper cuttings are handled a different way to the other databases as the raw data format is not suitable for conversion to a database, instead that uses a simple search.  Enter 5 or more characters and up to 10 records containing a match will be shown with the match highlighted and a count of total matches.

The “public” view of the databases allows access to the entire data-set but signed in PDMHS members get enhanced database access facilities.  The members view database controls look like this:

  1. Click this after first selecting a row in the grid to see an alternative view of the data in that line.
  2. Opens the search options (see below)
  3. Refresh the grid, cancelling all currently selected search options
  4. Select which columns of the grid are shown
  5. Export your selected rows to an Excel spreadsheet (only logged in PDMHS members have this option enabled)
  6. Back to start of file
  7. Back one page
  8. Current page number
  9. Number of pages
  10. Forward one page
  11. Forward to end of file
  12. Select the number of rows shown per page  (only logged in PDMHS members have this option enabled)
  13. Which lines are currently shown
  14. Number of lines in the database
  15. Search box for each column.  Start typing and matching entries will be shown. (only logged in PDMHS members have this option enabled)





As you start typing into any of the search boxes the program starts to find matches in the database.  It returns a list of matches as below.  Note that the search for hat finds a match not just for Hathersage and  Hatton but also for Brough and Shatton (Post Office database)


The results can be further refined by typing into a second search box, so looking for a surname containing Cot the result is as below.

Search (2: Magnifying glass icon) 


Starting from the top:

Non-PDMHS members are limited to a single search parameter.

  • You can search on all or any of the data fields
  • The plus sign adds a new row to the search box
  • The first column allows you to select the data field to search
  • The second column offers a choice of 10 search types
  • The third column is where you enter the text you’re searching for
  • The fourth column, a minus sign, allows you to remove that row from the search