ACS Community Partners
City of New York
@usgov.city_of_new_york_acs_community_partners
City of New York
@usgov.city_of_new_york_acs_community_partners
List of preventive providers with locations, contact information, office hours.
Organization: City of New York
Last updated: 2020-11-10T17:01:36.630262
Tags: acs-community-partners, administration-for-childrens-services-acs, children, partner, preventative, service
CREATE TABLE table_1 (
"program_lst_id" BIGINT,
"program_code" VARCHAR,
"program_name" VARCHAR,
"active_flag" VARCHAR,
"agency_name" VARCHAR,
"description" VARCHAR,
"borough" VARCHAR,
"prog_contact_last_name" VARCHAR,
"prog_contact_first_name" VARCHAR,
"prog_contact_phone_no" BIGINT,
"prog_contact_fax_no" DOUBLE,
"prog_contact_extension" DOUBLE,
"prog_contact_email" VARCHAR,
"program_address_1" VARCHAR,
"program_address_2" VARCHAR,
"program_city" VARCHAR,
"postcode" BIGINT,
"office_mon_from_time" VARCHAR,
"office_mon_to_time" VARCHAR,
"office_tues_from_time" VARCHAR,
"office_tues_to_time" VARCHAR,
"office_wed_from_time" VARCHAR,
"office_wed_to_time" VARCHAR,
"office_thurs_from_time" VARCHAR,
"office_thurs_to_time" VARCHAR,
"office_fri_from_time" VARCHAR,
"office_fri_to_time" VARCHAR,
"office_sat_from_time" VARCHAR,
"office_sat_to_time" VARCHAR,
"office_sun_from_time" VARCHAR,
"office_sun_to_time" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"community_board" DOUBLE,
"council_district" DOUBLE,
"census_tract" DOUBLE,
"bin" DOUBLE,
"bbl" DOUBLE,
"nta" VARCHAR
);Anyone who has the link will be able to view this.