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

91.56 kB
312 rows
22 columns

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

63.66 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

71.72 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

112.83 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

112.93 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

107.37 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

73.71 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
);