Readme
Updated 6 days ago
‧ Indexed 6 hours ago
Prescription Drug Take-Back Box Locations County Drug and Alcohol Programs
This dataset reports the site name, street address, city, county, zip code, telephone number, hours of availability, latitude, and longitude of Pennsylvania prescription drug take-back boxes as of May 2018. These monitored locations include police departments, courthouses, pharmacies, and hospitals/medical centers.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| State | state_fips | state_fips | Text | State Name |
| US House Districts for PA 2019 | :@computed_region_3x3q_vpda | :@computed_region_3x3q_vpda | Number | This column was automatically created in order to record in what polygon from the dataset 'US House Districts for PA 2019' (3x3q-vpda) the point in column 'geo' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens. |
| Georeferenced Latitude & Longitude | geo | geo | Point | Georeferenced Latitude & Longitude Point field to help in creating mapping visuals. |
| Pennsylvania County Boundaries | :@computed_region_nmsq_hqvv | :@computed_region_nmsq_hqvv | Number | |
| Pa Senatorial Districts (2017-01) | :@computed_region_d3gw_znnf | :@computed_region_d3gw_znnf | Number | |
| Location | location_1 | location_1 | Point | Number and street name location of prescription drug take-back site. Geocoded with latitude and longitude |
| Phone Number | phone_number | phone_number | Text | Contact telephone number of prescription drug take-back site |
| County | county | county | Text | Geographic region in Pennsylvania of prescription drug take-back site. Pennsylvania has 67 counties. |
| Location 1 (state) | location_1_state | location_1_state | Text | |
| Location 1 (zip) | location_1_zip | location_1_zip | Text | |
| Zip Code | zip_code | zip_code | Text | Zip code location of prescription drug take-back site |
| Location 1 (city) | location_1_city | location_1_city | Text | |
| Pa House Districts (2017-01) | :@computed_region_r6rf_p9et | :@computed_region_r6rf_p9et | Number | |
| Pa School Districts (2017) | :@computed_region_rayf_jjgk | :@computed_region_rayf_jjgk | Number | |
| Municipality Boundary | :@computed_region_amqz_jbr4 | :@computed_region_amqz_jbr4 | Number | |
| City | city | city | Text | City |
| Drug Take-Back Site | drug_take_back_site | drug_take_back_site | Text | Name of prescription drug take-back site |
| Address | address | address | Text | Address |
| Location 1 (address) | location_1_address | location_1_address | Text | |
| Longitude | longitude | longitude | Text | Longitude |
| Hours of Availability | hours_of_availability | hours_of_availability | Text | Hours of availability of prescription drug take-back site |
| Latitude | latitude | latitude | Text | Latitude |
Upstream Metadata