Pittsburgh Fish Fry Locations by US Government | Environmental and Climate Sciences

About this Dataset

Pittsburgh Fish Fry Locations

Lenten Fish Fry records for the Greater Pittsburgh region. Data is collected before and during the Lenten fish fry season each year by Code for Pittsburgh. Data is sourced from news outlets, social media, and public requests.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-03-14T22:55:13.421964
Tags: _etl, baked-goods, fish, fish-fry, food, fry, haluski, pierogi, pierogies, pirohi, pyrohi

Tables

Table 1

@usgov.allegheny_county_city_of_pitts_pittsburgh_fish_fry_locations.table_1

89.41 KB
312 rows
22 columns


CREATE TABLE table_1 (
  "n__id" BIGINT,
  "validated" VARCHAR,
  "venue_name" VARCHAR,
  "venue_type" VARCHAR,
  "venue_address" VARCHAR,
  "website" VARCHAR,
  "events" VARCHAR,
  "etc" VARCHAR,
  "menu_url" VARCHAR,
  "menu_text" VARCHAR,
  "venue_notes" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "homemade_pierogies" VARCHAR,
  "take_out" VARCHAR,
  "alcohol" VARCHAR,
  "lunch" VARCHAR,
  "handicap" VARCHAR,
  "publish" VARCHAR,
  "id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Table 2

@usgov.allegheny_county_city_of_pitts_pittsburgh_fish_fry_locations.table_2

62.17 KB
224 rows
21 columns


CREATE TABLE table_2 (
  "validated" BOOLEAN,
  "venue_name" VARCHAR,
  "venue_type" VARCHAR,
  "venue_address" VARCHAR,
  "website" VARCHAR,
  "events" VARCHAR,
  "etc" VARCHAR,
  "menu_url" VARCHAR,
  "menu_text" VARCHAR,
  "venue_notes" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "homemade_pierogies" VARCHAR,
  "take_out" VARCHAR,
  "alcohol" VARCHAR,
  "lunch" VARCHAR,
  "handicap" VARCHAR,
  "publish" BOOLEAN,
  "id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Table 3

@usgov.allegheny_county_city_of_pitts_pittsburgh_fish_fry_locations.table_3

70.04 KB
247 rows
21 columns


CREATE TABLE table_3 (
  "validated" BOOLEAN,
  "venue_name" VARCHAR,
  "venue_type" VARCHAR,
  "venue_address" VARCHAR,
  "website" VARCHAR,
  "events" VARCHAR,
  "etc" VARCHAR,
  "menu_url" VARCHAR,
  "menu_text" VARCHAR,
  "venue_notes" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "homemade_pierogies" VARCHAR,
  "take_out" VARCHAR,
  "alcohol" VARCHAR,
  "lunch" VARCHAR,
  "handicap" VARCHAR,
  "publish" BOOLEAN,
  "id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Table 4

@usgov.allegheny_county_city_of_pitts_pittsburgh_fish_fry_locations.table_4

110.18 KB
331 rows
21 columns


CREATE TABLE table_4 (
  "validated" BOOLEAN,
  "venue_name" VARCHAR,
  "venue_type" VARCHAR,
  "venue_address" VARCHAR,
  "website" VARCHAR,
  "events" VARCHAR,
  "etc" VARCHAR,
  "menu_url" VARCHAR,
  "menu_text" VARCHAR,
  "venue_notes" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "homemade_pierogies" VARCHAR,
  "take_out" VARCHAR,
  "alcohol" VARCHAR,
  "lunch" VARCHAR,
  "handicap" VARCHAR,
  "publish" BOOLEAN,
  "id" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Table 5

@usgov.allegheny_county_city_of_pitts_pittsburgh_fish_fry_locations.table_5

110.28 KB
357 rows
21 columns


CREATE TABLE table_5 (
  "validated" BOOLEAN,
  "venue_name" VARCHAR,
  "venue_type" VARCHAR,
  "venue_address" VARCHAR,
  "website" VARCHAR,
  "events" VARCHAR,
  "etc" VARCHAR,
  "menu_url" VARCHAR,
  "menu_text" VARCHAR,
  "venue_notes" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "homemade_pierogies" VARCHAR,
  "take_out" VARCHAR,
  "alcohol" VARCHAR,
  "lunch" VARCHAR,
  "handicap" VARCHAR,
  "publish" BOOLEAN,
  "id" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Table 6

@usgov.allegheny_county_city_of_pitts_pittsburgh_fish_fry_locations.table_6

104.85 KB
351 rows
21 columns


CREATE TABLE table_6 (
  "validated" BOOLEAN,
  "venue_name" VARCHAR,
  "venue_type" VARCHAR,
  "venue_address" VARCHAR,
  "website" VARCHAR,
  "events" VARCHAR,
  "etc" VARCHAR,
  "menu_url" VARCHAR,
  "menu_text" VARCHAR,
  "venue_notes" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "homemade_pierogies" VARCHAR,
  "take_out" VARCHAR,
  "alcohol" VARCHAR,
  "lunch" VARCHAR,
  "handicap" VARCHAR,
  "publish" BOOLEAN,
  "id" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Table 7

@usgov.allegheny_county_city_of_pitts_pittsburgh_fish_fry_locations.table_7

71.98 KB
276 rows
20 columns


CREATE TABLE table_7 (
  "validated" BOOLEAN,
  "venue_name" VARCHAR,
  "venue_type" VARCHAR,
  "venue_address" VARCHAR,
  "website" VARCHAR,
  "events" VARCHAR,
  "etc" VARCHAR,
  "menu" VARCHAR,
  "venue_notes" VARCHAR,
  "phone" VARCHAR,
  "email" VARCHAR,
  "homemade_pierogies" VARCHAR,
  "take_out" VARCHAR,
  "alcohol" VARCHAR,
  "lunch" VARCHAR,
  "handicap" VARCHAR,
  "publish" BOOLEAN,
  "id" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);