Places – Count People and Events
I have attempted to use the scripts on a file containing many places and many people. PlaceReverse.sql fails, finding 0 records. The screenshots show, first, the first few records in the place table and, second, the result of executing the script. Can someone suggest what I might be doing wrong?
Oops. Here are the screenshots.
Uploaded files:
The script creates SQLite VIEWs (stored queries) that you see under the "temp" label on the left. Click on xPlaceReverseView to see the places in reverse order or issue:
SELECT * FROM xPlaceReverseView;
I've revised the page to highlight that the ReversePlace.sql script was written to process the Standardized Place name. If that field has not been filled, there will be no result for it. Alternatively, the script can be easily revised to process the Place [Name] field in reverse order.