About this Dataset

Primary Care Facility

Primary care centers where residents can find available health care services in the District of Columbia. The dataset contains locations and attributes of Primary Care Centers, created as part of the DC Geographic Information System (DC GIS) for the D.C. Office of the Chief Technology Officer (OCTO) and participating D.C. government agencies. A database provided by the DC Department of Health (DOH) identified Primary Care Centers and DC GIS staff geo-processed the data.
Organization: District of Columbia
Last updated: 2024-04-30T19:17:12.850836
Tags: clinics, d-c, dc, dc-gis, dcgis, district-of-columbia, health, healthcare, hospitals, primary-care, treatment, washington, washington-dc

Tables

Table 1

@usgov.district_of_columbia_primary_care_facility.table_1

145.06 kB
49 rows
152 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "dcgisprimarycareptname" VARCHAR,
  "dcgisprimarycareptaddress" VARCHAR,
  "dcgisprimarycareptcity" VARCHAR,
  "dcgisprimarycareptstate" VARCHAR,
  "dcgisprimarycareptward" BIGINT,
  "dcgisprimarycareptphone" VARCHAR,
  "dcgisprimarycareptfax" VARCHAR,
  "dcgisprimarycareptct_hpsa" VARCHAR,
  "dcgisprimarycareptmedicaldir" VARCHAR,
  "dcgisprimarycareptchargenurs" VARCHAR,
  "dcgisprimarycareptadministra" VARCHAR,
  "dcgisprimarycareptweb_url" VARCHAR,
  "dcgisprimarycareptmar_census" BIGINT,
  "dcgisprimarycareptsee_patients_who_cant_pay" VARCHAR,
  "dcgisprimarycareptpopulation_served" VARCHAR,
  "dcgisprimarycareptwalkin_unscheduled" VARCHAR,
  "dcgisprimarycareptinsurance_accepted" VARCHAR,
  "dcgisprimarycareptopen_to_public" VARCHAR,
  "dcgisprimarycareptlimited_access" VARCHAR,
  "dcgisprimarycarepttreatment_for_all" VARCHAR,
  "dcgisprimarycareptpublic_insurance" VARCHAR,
  "dcgisprimarycareptmedicaid" VARCHAR,
  "dcgisprimarycareptmedicare" VARCHAR,
  "dcgisprimarycareptprivate_employer_insurance" VARCHAR,
  "dcgisprimarycareptprivate_insurance" VARCHAR,
  "dcgisprimarycareptsliding_scale" VARCHAR,
  "dcgisprimarycareptfacility_setting" VARCHAR,
  "dcgisprimarycareptfacility_type" VARCHAR,
  "dcgisprimarycareptpractice_type" VARCHAR,
  "dcgisprimarycareptyesno" VARCHAR,
  "dcgisprimarycareptlast_modified_date" TIMESTAMP,
  "dcgisprimarycareptlast_modified_user" VARCHAR,
  "dcgisprimarycareptlast_modified_action" VARCHAR,
  "dcgisprimarycareptgis_id" VARCHAR,
  "dcgisprimarycareptobjectid" BIGINT,
  "dcgisprimarycareptxcoord" DOUBLE,
  "dcgisprimarycareptycoord" DOUBLE,
  "dcgisprimarycareptzip_1" BIGINT,
  "dcgisprimarycareptzipcode" BIGINT,
  "dcgisprimarycareptmar_id" BIGINT,
  "dcgisprimarycareptse_anno_cad_data" VARCHAR,
  "dcgisprimarycareptglobalid" VARCHAR,
  "dcgisprimarycareptcreator" VARCHAR,
  "dcgisprimarycareptcreated" TIMESTAMP,
  "dcgisprimarycarepteditor" VARCHAR,
  "dcgisprimarycareptedited" TIMESTAMP,
  "dcgisprimary_care_infoobjectid" BIGINT,
  "dcgisprimary_care_infoopen_to_public" VARCHAR,
  "dcgisprimary_care_infolimited_access" VARCHAR,
  "dcgisprimary_care_infotreatment_for_all" VARCHAR,
  "dcgisprimary_care_infopublic_insurance" VARCHAR,
  "dcgisprimary_care_infomedicaid" VARCHAR,
  "dcgisprimary_care_infomedicare" VARCHAR,
  "dcgisprimary_care_infoprivate_employer_insurance" VARCHAR,
  "dcgisprimary_care_infoprivate_insurance" VARCHAR,
  "dcgisprimary_care_infosliding_scale" VARCHAR,
  "dcgisprimary_care_infofacility_setting" VARCHAR,
  "dcgisprimary_care_infofacility_type" VARCHAR,
  "dcgisprimary_care_infopractice_type" VARCHAR,
  "dcgisprimary_care_infoyesno" VARCHAR,
  "dcgisprimary_care_infohr_contact" VARCHAR,
  "dcgisprimary_care_infohr_phone" VARCHAR,
  "dcgisprimary_care_infohr_email" VARCHAR,
  "dcgisprimary_care_infopublic_services" VARCHAR,
  "dcgisprimary_care_infopop_served" VARCHAR,
  "dcgisprimary_care_infochild_special_needs" VARCHAR,
  "dcgisprimary_care_infoelderly" VARCHAR,
  "dcgisprimary_care_infohiv" VARCHAR,
  "dcgisprimary_care_infohomeless" VARCHAR,
  "dcgisprimary_care_infolbgt" VARCHAR,
  "dcgisprimary_care_infointel_disabled" VARCHAR,
  "dcgisprimary_care_infolanguage_limited" VARCHAR,
  "dcgisprimary_care_infoother_special_pop" VARCHAR,
  "dcgisprimary_care_infophysically_disabled" VARCHAR,
  "dcgisprimary_care_infomental_illness" VARCHAR,
  "dcgisprimary_care_infoability_to_pay" VARCHAR,
  "dcgisprimary_care_infoinsurance_alliance" VARCHAR,
  "dcgisprimary_care_infoprivate_plans" VARCHAR,
  "dcgisprimary_care_infoexcluded_plans" VARCHAR,
  "dcgisprimary_care_infopractice_setting" VARCHAR,
  "dcgisprimary_care_infohospital_affiliation" VARCHAR,
  "dcgisprimary_care_infocardiology" VARCHAR,
  "dcgisprimary_care_infodermatology" VARCHAR,
  "dcgisprimary_care_infoendocrinology" VARCHAR,
  "dcgisprimary_care_infogastroenterology" VARCHAR,
  "dcgisprimary_care_infogeneral_surgery" VARCHAR,
  "dcgisprimary_care_infohiv_aids" VARCHAR,
  "dcgisprimary_care_infoinfectious_disease" VARCHAR,
  "dcgisprimary_care_infonephrology" VARCHAR,
  "dcgisprimary_care_infoneurology" VARCHAR,
  "dcgisprimary_care_infoobstetrics" VARCHAR,
  "dcgisprimary_care_infooncology" VARCHAR,
  "dcgisprimary_care_infoopthalmology" VARCHAR,
  "dcgisprimary_care_infooral_surgery" VARCHAR,
  "dcgisprimary_care_infoother_specialty" VARCHAR,
  "dcgisprimary_care_infoorthopedic" VARCHAR,
  "dcgisprimary_care_infogastro_ent" VARCHAR,
  "dcgisprimary_care_infopediatrics" VARCHAR
);