Dataset: Pharmacy Locations

About this Dataset

Pharmacy Locations

The pharmacy license dataset is pulled from the Health Regulation and Licensing Administration's Pharmacy Control Division within DC Health. RX licenses are updated monthly through an automated process. For more information on pharmaceutical licensing, please visit the DC Health's website at dchealth.dc.gov. Search for Pharmaceutical Control Division.
Organization: District of Columbia
Last updated: 2024-04-30T18:35:23.360876
Tags: controlled-substance, dc, district-of-columbia, doctor, health, medical, medication, pharmacy, prescription, rx, washington-dc

Tables

Table 1

@usgov.district_of_columbia_pharmacy_locations.table_1

31.61 KB
141 rows
26 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "name" VARCHAR,
  "license_number" VARCHAR,
  "factype" VARCHAR,
  "address" VARCHAR,
  "addressline2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" BIGINT,
  "phone" VARCHAR,
  "ward" VARCHAR,
  "anc" VARCHAR,
  "ssl" VARCHAR,
  "seasonal" VARCHAR,
  "h1n1" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "mar_id" BIGINT,
  "gis_id" VARCHAR,
  "gis_last_mod_dttm" TIMESTAMP,
  "se_anno_cad_data" VARCHAR,
  "globalid" VARCHAR,
  "created" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT
);