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.269113
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.29 KB
133 rows
8 columns


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

Historical Farmers Markets

@usgov.allegheny_county_city_of_pitts_allegheny_county_farmer_409a1223.historical_farmers_markets

23.53 KB
524 rows
14 columns


CREATE TABLE historical_farmers_markets (
  "n__id" BIGINT,
  "year" BIGINT,
  "market_id" BIGINT,
  "market_type" VARCHAR,
  "market_name" VARCHAR,
  "address1" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "phone" DOUBLE,
  "phone_ext" VARCHAR,
  "county" VARCHAR
);

Historical Vendors

@usgov.allegheny_county_city_of_pitts_allegheny_county_farmer_409a1223.historical_vendors

35.16 KB
1532 rows
9 columns


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