About this Dataset

BigBurgh Social Service Listings

Information on social services in the City of Pittsburgh and Allegheny County for individuals experiencing homeless and for those in dire need, including crisis lines, activities and events, medical, housing, and food help. All listings have been independently verified and all listings are for free services, with minimal requirements. This data is updated on a monthly basis.

BigBurgh.com is a free "web-app" maintained by the City of Pittsburgh, and is intended to be used by individuals experiencing homelessness, social service providers, public safety personnel, including the Pittsburgh Police, and the general public.

BigBurgh.com is also available in Spanish.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T17:59:38.247332
Tags: 211, _etl, addiction, bigburgh, bigburgh-com, crisis, crisis-lines, daytime-shelter, department-of-human-services, food-bank, food-pantries, food-pantry, free-clinic, free-clothing, homeless, homeless-shelter, homeless-youth, homlessness, hotlines, housing, laundry, mental-health, needle-exchange, operation-safety-net, opioid, shelter, shower, social-service-providers, social-services, soup-kitchen, veterans, veterans-services

Tables

Current List Of Safe Places

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.current_list_of_safe_places

16.46 KB
19 rows
13 columns


CREATE TABLE current_list_of_safe_places (
  "n__id" BIGINT,
  "safe_place_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR
);

Current List Of Services

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.current_list_of_services

58.45 KB
207 rows
15 columns


CREATE TABLE current_list_of_services (
  "n__id" BIGINT,
  "service_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

Events Archive (Cumulative)

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.events_archive_cumulative

75.76 KB
4006 rows
17 columns


CREATE TABLE events_archive_cumulative (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "event_name" VARCHAR,
  "recurrence" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "event_phone" VARCHAR,
  "event_narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

Events Data Dictionary

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.events_data_dictionary

5.73 KB
15 rows
5 columns


CREATE TABLE events_data_dictionary (
  "field_name" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR,
  "example" VARCHAR,
  "notes" VARCHAR
);

2018-03 Events Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_03_events_archive

23.25 KB
44 rows
17 columns


CREATE TABLE n_2018_03_events_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "event_name" VARCHAR,
  "recurrence" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "event_phone" VARCHAR,
  "event_narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-03 Safe Places Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_03_safe_places_archive

15.64 KB
18 rows
14 columns


CREATE TABLE n_2018_03_safe_places_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "safe_place_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR
);

2018-03 Services Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_03_services_archive

51.81 KB
178 rows
16 columns


CREATE TABLE n_2018_03_services_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "service_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-04 Events Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_04_events_archive

23.97 KB
51 rows
17 columns


CREATE TABLE n_2018_04_events_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "event_name" VARCHAR,
  "recurrence" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "event_phone" VARCHAR,
  "event_narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-04 Safe Places Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_04_safe_places_archive

16.13 KB
19 rows
14 columns


CREATE TABLE n_2018_04_safe_places_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "safe_place_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR
);

2018-04 Services Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_04_services_archive

51.81 KB
180 rows
16 columns


CREATE TABLE n_2018_04_services_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "service_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-05 Events Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_05_events_archive

26 KB
59 rows
17 columns


CREATE TABLE n_2018_05_events_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "event_name" VARCHAR,
  "recurrence" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "event_phone" VARCHAR,
  "event_narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-05 Safe Places Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_05_safe_places_archive

16.16 KB
19 rows
14 columns


CREATE TABLE n_2018_05_safe_places_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "safe_place_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR
);

2018-05 Services Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_05_services_archive

52.46 KB
184 rows
16 columns


CREATE TABLE n_2018_05_services_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "service_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-06 Events Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_06_events_archive

29.01 KB
71 rows
17 columns


CREATE TABLE n_2018_06_events_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "event_name" VARCHAR,
  "recurrence" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "event_phone" VARCHAR,
  "event_narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-06 Safe Places Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_06_safe_places_archive

17.11 KB
20 rows
14 columns


CREATE TABLE n_2018_06_safe_places_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "safe_place_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR
);

2018-06 Services Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_06_services_archive

58.13 KB
215 rows
16 columns


CREATE TABLE n_2018_06_services_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "service_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-07 Events Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_07_events_archive

29.37 KB
73 rows
17 columns


CREATE TABLE n_2018_07_events_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "event_name" VARCHAR,
  "recurrence" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "event_phone" VARCHAR,
  "event_narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-07 Safe Places Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_07_safe_places_archive

17.07 KB
20 rows
14 columns


CREATE TABLE n_2018_07_safe_places_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "safe_place_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR
);

2018-07 Services Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_07_services_archive

62.2 KB
266 rows
16 columns


CREATE TABLE n_2018_07_services_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "service_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-08 Events Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_08_events_archive

29.33 KB
73 rows
17 columns


CREATE TABLE n_2018_08_events_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "event_name" VARCHAR,
  "recurrence" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "event_phone" VARCHAR,
  "event_narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-08 Safe Places Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_08_safe_places_archive

17.07 KB
20 rows
14 columns


CREATE TABLE n_2018_08_safe_places_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "safe_place_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR
);

2018-08 Services Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_08_services_archive

62.35 KB
264 rows
16 columns


CREATE TABLE n_2018_08_services_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "service_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-09 Events Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_09_events_archive

29.69 KB
75 rows
17 columns


CREATE TABLE n_2018_09_events_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "event_name" VARCHAR,
  "recurrence" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "event_phone" VARCHAR,
  "event_narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);

2018-09 Safe Places Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_09_safe_places_archive

17.08 KB
20 rows
14 columns


CREATE TABLE n_2018_09_safe_places_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "safe_place_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR
);

2018-09 Services Archive

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.n_2018_09_services_archive

56.11 KB
206 rows
16 columns


CREATE TABLE n_2018_09_services_archive (
  "n__id" BIGINT,
  "year_month" BIGINT,
  "service_name" VARCHAR,
  "program_or_facility" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "organization" VARCHAR,
  "category" VARCHAR,
  "recommended_for" VARCHAR,
  "requirements" VARCHAR,
  "phone" VARCHAR,
  "narrative" VARCHAR,
  "schedule" VARCHAR,
  "holiday_exception" VARCHAR
);