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.247343
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

Events Archive (Cumulative)

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.events_archive_cumulative

61.51 kB
1,666 rows
17 columns

CREATE TABLE events_archive_cumulative (
  "n__id" BIGINT  -- Id,
  "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
);

Safe Places Archive (Cumulative)

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.safe_places_archive_cumulative

21.34 kB
476 rows
14 columns

CREATE TABLE safe_places_archive_cumulative (
  "n__id" BIGINT  -- Id,
  "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
);

Services Archive (Cumulative)

@usgov.allegheny_county_city_of_pitts_bigburgh_social_service_listings.services_archive_cumulative

129.53 kB
5,550 rows
16 columns

CREATE TABLE services_archive_cumulative (
  "n__id" BIGINT  -- Id,
  "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
);