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.  

Non-PDMHS members access is limited to a subset of the members view where the more extended 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:
Search can be set to all or any of the following criteria
+ allows you to add rows to the search criteria
Each row identifies a field to search in, 16 search types like contains and ends with then the text to search for. The final cell contains a minus, this removes the line from the criteria.

Example: As above search for All using Surname begins with cot and Place contains hat on the Post Office Directory 1849 database returns Cottingham of Hathersage and Cotterill of Brough & Shatton

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