About this Dataset

Allegheny County Farmers Market Nutrition Program

This dataset provides information about Allegheny County vendors accepting WIC who participate in the Pennsylvania Department of Agriculture's Farmers Market Nutrition Program (FMNP). These markets provide the public, including WIC recipients, with fresh, nutritious, locally grown fruits, vegetables, and herbs from approved farmers in Pennsylvania.

Each row in the data includes details about location, days/hours of operation, and the length of the season. Additional directions and affiliations have also been provided when available.

Users may also be interested in the PA Department of Agriculture's new PA FMNP Market Locator app, a free mobile tool to help residents find markets closest to them across the entire state. The FMNP Market Locator app is available both in the Apple Store (https://apple.co/2KNJ4dk) and Google Play (http://bit.ly/2Z86Ytg).
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:05:18.269115
Tags: _etl, agriculture, farmers, food, health, social-services, vegetables, wic

Tables

Current Vendors

@usgov.allegheny_county_city_of_pitts_allegheny_county_farmer_409a1223.current_vendors

12.63 kB
135 rows
8 columns

CREATE TABLE current_vendors (
  "n__id" BIGINT  -- Id,
  "market_id" BIGINT,
  "vendor_id" BIGINT,
  "vendor_name" VARCHAR,
  "vendor_phone" DOUBLE,
  "vendor_schedule" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Farmers Market Locations And Hours (2017)

@usgov.allegheny_county_city_of_pitts_allegheny_county_farmer_409a1223.farmers_market_locations_and_hours_2017

12.3 kB
54 rows
10 columns

CREATE TABLE farmers_market_locations_and_hours_2017 (
  "name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additional_directions" VARCHAR,
  "day_time" VARCHAR,
  "season" VARCHAR
);

Farmers Market Locations And Hours (2019)

@usgov.allegheny_county_city_of_pitts_allegheny_county_farmer_409a1223.farmers_market_locations_and_hours_2019

15.81 kB
92 rows
11 columns

CREATE TABLE farmers_market_locations_and_hours_2019 (
  "name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "additional_directions" VARCHAR,
  "day_time" VARCHAR,
  "season" VARCHAR,
  "affiliations" VARCHAR
);

Historical Vendors

@usgov.allegheny_county_city_of_pitts_allegheny_county_farmer_409a1223.historical_vendors

37.25 kB
1,612 rows
9 columns

CREATE TABLE historical_vendors (
  "n__id" BIGINT  -- Id,
  "year" BIGINT,
  "market_id" BIGINT,
  "vendor_id" BIGINT,
  "vendor_name" VARCHAR,
  "vendor_phone" DOUBLE,
  "vendor_schedule" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);