{
  "id" : "9a8c-vfzj",
  "name" : "Retail Food Stores",
  "assetType" : "dataset",
  "attribution" : "New York State Department of Agriculture and Markets",
  "attributionLink" : "http://www.agriculture.ny.gov/FS/FSHome.html",
  "averageRating" : 0,
  "category" : "Economic Development",
  "createdAt" : 1361890199,
  "description" : "A listing of all retail food stores which are licensed by the Department of Agriculture and Markets.",
  "diciBackend" : false,
  "displayType" : "table",
  "downloadCount" : 133710,
  "hideFromCatalog" : false,
  "hideFromDataJson" : false,
  "locked" : false,
  "newBackend" : true,
  "numberOfComments" : 0,
  "oid" : 37623274,
  "provenance" : "official",
  "publicationAppendEnabled" : false,
  "publicationDate" : 1630695397,
  "publicationGroup" : 700965,
  "publicationStage" : "published",
  "rowsUpdatedAt" : 1759245315,
  "rowsUpdatedBy" : "xzik-pf59",
  "tableId" : 18431384,
  "totalTimesRated" : 0,
  "viewCount" : 256082,
  "viewLastModified" : 1776974549,
  "viewType" : "tabular",
  "approvals" : [ {
    "reviewedAt" : 1533931405,
    "reviewedAutomatically" : true,
    "state" : "approved",
    "submissionId" : 3975309,
    "submissionObject" : "public_audience_request",
    "submissionOutcome" : "change_audience",
    "submittedAt" : 1533931405,
    "targetAudience" : "public",
    "workflowId" : 2254,
    "submissionDetails" : {
      "permissionType" : "READ"
    },
    "submissionOutcomeApplication" : {
      "failureCount" : 0,
      "status" : "success"
    },
    "submitter" : {
      "id" : "xzik-pf59",
      "displayName" : "NY Open Data"
    }
  } ],
  "clientContext" : {
    "clientContextVariables" : [ ],
    "inheritedVariables" : { }
  },
  "columns" : [ {
    "id" : 547687020,
    "name" : "County",
    "dataTypeName" : "text",
    "description" : "The county in which the licensed entity is physically located",
    "fieldName" : "county",
    "position" : 1,
    "renderTypeName" : "text",
    "tableColumnId" : 8179659,
    "width" : 137,
    "cachedContents" : {
      "non_null" : "24277",
      "largest" : "YATES",
      "null" : "4",
      "top" : [ {
        "item" : "KINGS",
        "count" : "4254"
      }, {
        "item" : "QUEENS",
        "count" : "2542"
      }, {
        "item" : "BRONX",
        "count" : "2235"
      }, {
        "item" : "NEW YORK",
        "count" : "1921"
      }, {
        "item" : "SUFFOLK",
        "count" : "1635"
      }, {
        "item" : "NASSAU",
        "count" : "1142"
      }, {
        "item" : "ERIE",
        "count" : "1089"
      }, {
        "item" : "WESTCHESTER",
        "count" : "999"
      }, {
        "item" : "MONROE",
        "count" : "698"
      }, {
        "item" : "RICHMOND",
        "count" : "520"
      }, {
        "item" : "ONONDAGA",
        "count" : "515"
      }, {
        "item" : "ORANGE",
        "count" : "446"
      }, {
        "item" : "ALBANY",
        "count" : "384"
      }, {
        "item" : "DUTCHESS",
        "count" : "375"
      }, {
        "item" : "ONEIDA",
        "count" : "328"
      }, {
        "item" : "ROCKLAND",
        "count" : "315"
      }, {
        "item" : "ULSTER",
        "count" : "275"
      }, {
        "item" : "BROOME",
        "count" : "241"
      }, {
        "item" : "SARATOGA",
        "count" : "230"
      }, {
        "item" : "NIAGARA",
        "count" : "230"
      } ],
      "smallest" : "ALBANY",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "center"
    }
  }, {
    "id" : 547687021,
    "name" : "License Number",
    "dataTypeName" : "text",
    "description" : "The licensed entity’s license number for this location",
    "fieldName" : "license_number",
    "position" : 2,
    "renderTypeName" : "text",
    "tableColumnId" : 8179648,
    "width" : 183,
    "cachedContents" : {
      "non_null" : "24281",
      "largest" : "768379",
      "null" : "0",
      "top" : [ {
        "item" : "010056",
        "count" : "1"
      }, {
        "item" : "010086",
        "count" : "1"
      }, {
        "item" : "010090",
        "count" : "1"
      }, {
        "item" : "010103",
        "count" : "1"
      }, {
        "item" : "010115",
        "count" : "1"
      }, {
        "item" : "010135",
        "count" : "1"
      }, {
        "item" : "010166",
        "count" : "1"
      }, {
        "item" : "010169",
        "count" : "1"
      }, {
        "item" : "010172",
        "count" : "1"
      }, {
        "item" : "010179",
        "count" : "1"
      }, {
        "item" : "010197",
        "count" : "1"
      }, {
        "item" : "010206",
        "count" : "1"
      }, {
        "item" : "010221",
        "count" : "1"
      }, {
        "item" : "010222",
        "count" : "1"
      }, {
        "item" : "010227",
        "count" : "1"
      }, {
        "item" : "010230",
        "count" : "1"
      }, {
        "item" : "010231",
        "count" : "1"
      }, {
        "item" : "010233",
        "count" : "1"
      }, {
        "item" : "010278",
        "count" : "1"
      }, {
        "item" : "010008",
        "count" : "1"
      } ],
      "smallest" : "010008",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "center"
    }
  }, {
    "id" : 547687022,
    "name" : "Operation Type",
    "dataTypeName" : "text",
    "description" : "The type of operation the licensed entity conducts",
    "fieldName" : "operation_type",
    "position" : 3,
    "renderTypeName" : "text",
    "tableColumnId" : 8179649,
    "width" : 176,
    "cachedContents" : {
      "non_null" : "24281",
      "largest" : "Store",
      "null" : "0",
      "top" : [ {
        "item" : "Store",
        "count" : "24281"
      } ],
      "smallest" : "Store",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "center"
    }
  }, {
    "id" : 547687023,
    "name" : "Establishment Type",
    "dataTypeName" : "text",
    "description" : "The establishment type for the licensed entity at this location; see document in ‘About’ section, or go to https://data.ny.gov/api/views/9a8c-vfzj/files/UBDP3oW2f-K767I4f51EJaIUO8eNGPrAQQj8tSvBhbo?download=true&filename=NYSDAM_RetailFoodStoresEstablishmentTypeCodes.pdf",
    "fieldName" : "estab_type",
    "position" : 4,
    "renderTypeName" : "text",
    "tableColumnId" : 21635505,
    "width" : 196,
    "cachedContents" : {
      "non_null" : "24281",
      "largest" : "AW",
      "null" : "0",
      "top" : [ {
        "item" : "AC",
        "count" : "17727"
      }, {
        "item" : "A",
        "count" : "4685"
      }, {
        "item" : "ABC",
        "count" : "1114"
      }, {
        "item" : "ACH",
        "count" : "135"
      }, {
        "item" : "ABCH",
        "count" : "88"
      }, {
        "item" : "ACD",
        "count" : "67"
      }, {
        "item" : "ACK",
        "count" : "64"
      }, {
        "item" : "ACDK",
        "count" : "41"
      }, {
        "item" : "ABH",
        "count" : "31"
      }, {
        "item" : "AB",
        "count" : "30"
      }, {
        "item" : "AD",
        "count" : "29"
      }, {
        "item" : "ADK",
        "count" : "24"
      }, {
        "item" : "ACW",
        "count" : "22"
      }, {
        "item" : "ABCK",
        "count" : "22"
      }, {
        "item" : "ACHK",
        "count" : "18"
      }, {
        "item" : "ABHK",
        "count" : "17"
      }, {
        "item" : "ABCHK",
        "count" : "14"
      }, {
        "item" : "ACY",
        "count" : "14"
      }, {
        "item" : "ACHDK",
        "count" : "12"
      }, {
        "item" : "AAC",
        "count" : "10"
      } ],
      "smallest" : "A",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "center"
    }
  }, {
    "id" : 547687024,
    "name" : "Entity Name",
    "dataTypeName" : "text",
    "description" : "The name of the licensed entity",
    "fieldName" : "entity_name",
    "position" : 5,
    "renderTypeName" : "text",
    "tableColumnId" : 8179650,
    "width" : 306,
    "cachedContents" : {
      "non_null" : "24281",
      "largest" : "Z&Z TWO BROTHERS INC",
      "null" : "0",
      "top" : [ {
        "item" : "DOLGEN NEW YORK LLC",
        "count" : "617"
      }, {
        "item" : "CVS ALBANY LLC",
        "count" : "440"
      }, {
        "item" : "STEWARTS SHOPS CORP",
        "count" : "350"
      }, {
        "item" : "WALGREEN EASTERN CO INC",
        "count" : "329"
      }, {
        "item" : "DOLLAR TREE STORES INC",
        "count" : "300"
      }, {
        "item" : "FAMILY DOLLAR STORES OF NEW YORK LLC",
        "count" : "264"
      }, {
        "item" : "SPEEDWAY LLC",
        "count" : "224"
      }, {
        "item" : "ALDI INC",
        "count" : "136"
      }, {
        "item" : "UNITED REFINING CO OF PA INC",
        "count" : "109"
      }, {
        "item" : "TOPS MARKETS LLC",
        "count" : "106"
      }, {
        "item" : "TARGET CORPORATION",
        "count" : "102"
      }, {
        "item" : "MIRABITO HOLDINGS INC",
        "count" : "100"
      }, {
        "item" : "A PLUS CONVENIENCE STORES INC",
        "count" : "91"
      }, {
        "item" : "WAL-MART STORES EAST LP",
        "count" : "91"
      }, {
        "item" : "RITE AID OF NEW YORK INC",
        "count" : "81"
      }, {
        "item" : "BOLLA OPERATING LI CORP",
        "count" : "81"
      }, {
        "item" : "SONBYRNE SALES INC",
        "count" : "80"
      }, {
        "item" : "PRICE CHOPPER OPERATING CO INC",
        "count" : "80"
      }, {
        "item" : "CUMBERLAND FARMS INC",
        "count" : "77"
      }, {
        "item" : "REID STORES INC",
        "count" : "75"
      } ],
      "smallest" : "0113 FOOD CORP",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 547687025,
    "name" : "DBA Name",
    "dataTypeName" : "text",
    "description" : "“Doing business as” (DBA) name for the licensed entity",
    "fieldName" : "dba_name",
    "position" : 6,
    "renderTypeName" : "text",
    "tableColumnId" : 8179651,
    "width" : 196,
    "cachedContents" : {
      "non_null" : "24281",
      "largest" : "ZZ PETROLEUM",
      "null" : "0",
      "top" : [ {
        "item" : "EDIBLE ARRANGEMENTS",
        "count" : "45"
      }, {
        "item" : "KEY FOOD",
        "count" : "43"
      }, {
        "item" : "C TOWN",
        "count" : "37"
      }, {
        "item" : "MOBIL MART",
        "count" : "31"
      }, {
        "item" : "FINE FARE SUPERMARKET",
        "count" : "27"
      }, {
        "item" : "IDEAL FOOD BASKET",
        "count" : "27"
      }, {
        "item" : "BP",
        "count" : "23"
      }, {
        "item" : "FOODTOWN",
        "count" : "22"
      }, {
        "item" : "HEALTHY MEALS DIRECT",
        "count" : "22"
      }, {
        "item" : "SUNOCO",
        "count" : "22"
      }, {
        "item" : "BRAVO SUPERMARKET",
        "count" : "22"
      }, {
        "item" : "WHOLE FOODS MARKET",
        "count" : "21"
      }, {
        "item" : "FOOD BAZAAR",
        "count" : "20"
      }, {
        "item" : "FINE FARE",
        "count" : "20"
      }, {
        "item" : "FOOD UNIVERSE",
        "count" : "20"
      }, {
        "item" : "CLIFFS LOCAL MARKET",
        "count" : "20"
      }, {
        "item" : "C TOWN SUPERMARKET",
        "count" : "19"
      }, {
        "item" : "CONSUMERS BEVERAGES",
        "count" : "17"
      }, {
        "item" : "H MART",
        "count" : "16"
      }, {
        "item" : "CORNER MARKET",
        "count" : "15"
      } ],
      "smallest" : "056 DELI & GROCERY",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 547687026,
    "name" : "Street Number",
    "dataTypeName" : "text",
    "description" : "The street number for the physical address of the licensed entity; will be blank if no data is recorded",
    "fieldName" : "street_number",
    "position" : 7,
    "renderTypeName" : "text",
    "tableColumnId" : 8179652,
    "width" : 174,
    "cachedContents" : {
      "non_null" : "24231",
      "largest" : "US RT 9H &",
      "null" : "50",
      "top" : [ {
        "item" : "1",
        "count" : "131"
      }, {
        "item" : "2",
        "count" : "109"
      }, {
        "item" : "100",
        "count" : "83"
      }, {
        "item" : "10",
        "count" : "69"
      }, {
        "item" : "50",
        "count" : "58"
      }, {
        "item" : "200",
        "count" : "54"
      }, {
        "item" : "20",
        "count" : "54"
      }, {
        "item" : "5",
        "count" : "53"
      }, {
        "item" : "15",
        "count" : "51"
      }, {
        "item" : "500",
        "count" : "49"
      }, {
        "item" : "7",
        "count" : "48"
      }, {
        "item" : "9",
        "count" : "47"
      }, {
        "item" : "40",
        "count" : "47"
      }, {
        "item" : "19",
        "count" : "46"
      }, {
        "item" : "6",
        "count" : "46"
      }, {
        "item" : "3",
        "count" : "46"
      }, {
        "item" : "4",
        "count" : "45"
      }, {
        "item" : "201",
        "count" : "45"
      }, {
        "item" : "300",
        "count" : "45"
      }, {
        "item" : "16",
        "count" : "43"
      } ],
      "smallest" : "1",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "center"
    }
  }, {
    "id" : 547687027,
    "name" : "Street Name",
    "dataTypeName" : "text",
    "description" : "The street name for the physical location of the licensed entity; the first address line recorded",
    "fieldName" : "street_name",
    "position" : 8,
    "renderTypeName" : "text",
    "tableColumnId" : 8179653,
    "width" : 232,
    "cachedContents" : {
      "non_null" : "24281",
      "largest" : "ZEREGA AVENUE",
      "null" : "0",
      "top" : [ {
        "item" : "BROADWAY",
        "count" : "390"
      }, {
        "item" : "MAIN ST",
        "count" : "325"
      }, {
        "item" : "5TH AVE",
        "count" : "125"
      }, {
        "item" : "JAMAICA AVE",
        "count" : "112"
      }, {
        "item" : "3RD AVE",
        "count" : "110"
      }, {
        "item" : "E MAIN ST",
        "count" : "102"
      }, {
        "item" : "N MAIN ST",
        "count" : "94"
      }, {
        "item" : "NOSTRAND AVE",
        "count" : "93"
      }, {
        "item" : "W MAIN ST",
        "count" : "88"
      }, {
        "item" : "LIBERTY AVE",
        "count" : "85"
      }, {
        "item" : "WHITE PLAINS RD",
        "count" : "84"
      }, {
        "item" : "MYRTLE AVE",
        "count" : "80"
      }, {
        "item" : "MAIN STREET",
        "count" : "78"
      }, {
        "item" : "NORTHERN BLVD",
        "count" : "75"
      }, {
        "item" : "AVENUE U",
        "count" : "74"
      }, {
        "item" : "FULTON ST",
        "count" : "73"
      }, {
        "item" : "CHURCH AVE",
        "count" : "73"
      }, {
        "item" : "2ND AVE",
        "count" : "70"
      }, {
        "item" : "HILLSIDE AVE",
        "count" : "68"
      }, {
        "item" : "FLATBUSH AVE",
        "count" : "68"
      } ],
      "smallest" : "02 ATLANTIC AVE###",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 547687028,
    "name" : "Address Line 2",
    "dataTypeName" : "text",
    "description" : "The second address line recorded for the physical location of the licensed entity; blank if no data is recorded",
    "fieldName" : "address_line_2",
    "position" : 9,
    "renderTypeName" : "text",
    "tableColumnId" : 8179654,
    "width" : 188,
    "cachedContents" : {
      "non_null" : "299",
      "largest" : "XX",
      "null" : "23982",
      "top" : [ {
        "item" : "KITCHEN AT THE MARKET",
        "count" : "5"
      }, {
        "item" : "-C/O STONY BROOK CALVERTON KITCHEN",
        "count" : "5"
      }, {
        "item" : "-C/O COOK COLLECTIVE/APIARI KITCHEN",
        "count" : "4"
      }, {
        "item" : "1ST FL",
        "count" : "3"
      }, {
        "item" : "SUITE 100",
        "count" : "3"
      }, {
        "item" : "SUITE 10",
        "count" : "3"
      }, {
        "item" : "STORE 1",
        "count" : "3"
      }, {
        "item" : "ENTREPRENEUR SPACE",
        "count" : "3"
      }, {
        "item" : "FLATBUSH CENTRAL KITCHEN",
        "count" : "3"
      }, {
        "item" : "UNIT B",
        "count" : "3"
      }, {
        "item" : "###",
        "count" : "2"
      }, {
        "item" : "STORE #2",
        "count" : "2"
      }, {
        "item" : "SUITE #1",
        "count" : "2"
      }, {
        "item" : "SUITE 6",
        "count" : "2"
      }, {
        "item" : "ROCHESTER COMMISSARY",
        "count" : "2"
      }, {
        "item" : "(INSIDE MORTON WILLIAMS)",
        "count" : "2"
      }, {
        "item" : "-C/O STONYBROOK CALVERTON KITCHEN",
        "count" : "2"
      }, {
        "item" : "#1",
        "count" : "2"
      }, {
        "item" : "-C/O LAURELS BUTTER KITCHEN",
        "count" : "2"
      }, {
        "item" : "STORE #1",
        "count" : "2"
      } ],
      "smallest" : "`",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 547687029,
    "name" : "Address Line 3",
    "dataTypeName" : "text",
    "description" : "The third address line recorded for the physical location of the licensed entity; blank if no data is recorded",
    "fieldName" : "address_line_3",
    "position" : 10,
    "renderTypeName" : "text",
    "tableColumnId" : 8179655,
    "width" : 187,
    "cachedContents" : {
      "non_null" : "1",
      "largest" : "SPACE LL5102",
      "null" : "24280",
      "top" : [ {
        "item" : "SPACE LL5102",
        "count" : "1"
      } ],
      "smallest" : "SPACE LL5102",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 547687030,
    "name" : "City",
    "dataTypeName" : "text",
    "description" : "The name of the city in which the licensed entity is physically located",
    "fieldName" : "city",
    "position" : 11,
    "renderTypeName" : "text",
    "tableColumnId" : 8179656,
    "width" : 148,
    "cachedContents" : {
      "non_null" : "24280",
      "largest" : "YOUNGSVILLE",
      "null" : "1",
      "top" : [ {
        "item" : "BROOKLYN",
        "count" : "4252"
      }, {
        "item" : "BRONX",
        "count" : "2235"
      }, {
        "item" : "NEW YORK",
        "count" : "1919"
      }, {
        "item" : "BUFFALO",
        "count" : "596"
      }, {
        "item" : "ROCHESTER",
        "count" : "538"
      }, {
        "item" : "STATEN ISLAND",
        "count" : "520"
      }, {
        "item" : "SYRACUSE",
        "count" : "297"
      }, {
        "item" : "JAMAICA",
        "count" : "292"
      }, {
        "item" : "YONKERS",
        "count" : "275"
      }, {
        "item" : "ALBANY",
        "count" : "226"
      }, {
        "item" : "FLUSHING",
        "count" : "202"
      }, {
        "item" : "ASTORIA",
        "count" : "197"
      }, {
        "item" : "CORONA",
        "count" : "174"
      }, {
        "item" : "RIDGEWOOD",
        "count" : "166"
      }, {
        "item" : "SCHENECTADY",
        "count" : "161"
      }, {
        "item" : "UTICA",
        "count" : "126"
      }, {
        "item" : "POUGHKEEPSIE",
        "count" : "119"
      }, {
        "item" : "JACKSON HEIGHTS",
        "count" : "114"
      }, {
        "item" : "BINGHAMTON",
        "count" : "104"
      }, {
        "item" : "WOODSIDE",
        "count" : "104"
      } ],
      "smallest" : "ACCORD",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "left"
    }
  }, {
    "id" : 547687031,
    "name" : "State",
    "dataTypeName" : "text",
    "description" : "The two character state code for the physical location of the licensed entity",
    "fieldName" : "state",
    "position" : 12,
    "renderTypeName" : "text",
    "tableColumnId" : 8179657,
    "width" : 123,
    "cachedContents" : {
      "non_null" : "24281",
      "largest" : "NY",
      "null" : "0",
      "top" : [ {
        "item" : "NY",
        "count" : "24281"
      } ],
      "smallest" : "NY",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "center"
    }
  }, {
    "id" : 547687032,
    "name" : "Zip Code",
    "dataTypeName" : "text",
    "description" : "The United States Postal Service (USPS) ZIP code for the physical location of the licensed entity",
    "fieldName" : "zip_code",
    "position" : 13,
    "renderTypeName" : "text",
    "tableColumnId" : 8179658,
    "width" : 152,
    "cachedContents" : {
      "non_null" : "24281",
      "largest" : "14905",
      "null" : "0",
      "top" : [ {
        "item" : "11220",
        "count" : "246"
      }, {
        "item" : "11207",
        "count" : "195"
      }, {
        "item" : "11385",
        "count" : "179"
      }, {
        "item" : "10467",
        "count" : "179"
      }, {
        "item" : "10456",
        "count" : "177"
      }, {
        "item" : "11368",
        "count" : "174"
      }, {
        "item" : "11226",
        "count" : "173"
      }, {
        "item" : "10458",
        "count" : "172"
      }, {
        "item" : "11208",
        "count" : "168"
      }, {
        "item" : "11214",
        "count" : "160"
      }, {
        "item" : "11219",
        "count" : "159"
      }, {
        "item" : "11212",
        "count" : "157"
      }, {
        "item" : "11223",
        "count" : "152"
      }, {
        "item" : "11211",
        "count" : "151"
      }, {
        "item" : "10029",
        "count" : "150"
      }, {
        "item" : "11204",
        "count" : "138"
      }, {
        "item" : "11206",
        "count" : "137"
      }, {
        "item" : "11218",
        "count" : "137"
      }, {
        "item" : "11221",
        "count" : "136"
      }, {
        "item" : "10462",
        "count" : "136"
      } ],
      "smallest" : "06390",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "align" : "center"
    }
  }, {
    "id" : 547687033,
    "name" : "Square Footage",
    "dataTypeName" : "number",
    "description" : "The square footage of the entire physical location of the licensed entity",
    "fieldName" : "square_footage",
    "position" : 14,
    "renderTypeName" : "number",
    "tableColumnId" : 21635506,
    "width" : 184,
    "cachedContents" : {
      "non_null" : "18972",
      "largest" : "1200733",
      "null" : "5309",
      "top" : [ {
        "item" : "1000",
        "count" : "1975"
      }, {
        "item" : "2000",
        "count" : "1628"
      }, {
        "item" : "1500",
        "count" : "1564"
      }, {
        "item" : "1200",
        "count" : "1315"
      }, {
        "item" : "3000",
        "count" : "755"
      }, {
        "item" : "2500",
        "count" : "688"
      }, {
        "item" : "800",
        "count" : "662"
      }, {
        "item" : "1800",
        "count" : "576"
      }, {
        "item" : "5000",
        "count" : "452"
      }, {
        "item" : "10000",
        "count" : "448"
      }, {
        "item" : "4000",
        "count" : "411"
      }, {
        "item" : "500",
        "count" : "344"
      }, {
        "item" : "0",
        "count" : "343"
      }, {
        "item" : "900",
        "count" : "322"
      }, {
        "item" : "1600",
        "count" : "288"
      }, {
        "item" : "600",
        "count" : "287"
      }, {
        "item" : "8000",
        "count" : "285"
      }, {
        "item" : "1100",
        "count" : "241"
      }, {
        "item" : "1400",
        "count" : "239"
      }, {
        "item" : "6000",
        "count" : "236"
      } ],
      "smallest" : "0",
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : {
      "precisionStyle" : "standard",
      "align" : "right"
    }
  }, {
    "id" : 547687034,
    "name" : "Georeference",
    "dataTypeName" : "point",
    "description" : "Open Data platform-generated geocoding information from supplied address components. Point-type location is the centroid of the address components provided and does not reflect a specific address if the street address component is not provided. Point-type location is supplied in \"POINT (<geocoded longitude> <geocoded latitude>)\" format.",
    "fieldName" : "georeference",
    "position" : 15,
    "renderTypeName" : "point",
    "tableColumnId" : 139258330,
    "cachedContents" : {
      "non_null" : "22999",
      "null" : "1282",
      "top" : [ {
        "item" : {
          "coordinates" : [ -72.78596, 40.92697 ],
          "type" : "Point"
        },
        "count" : "16"
      }, {
        "item" : {
          "coordinates" : [ -78.83812, 42.89244 ],
          "type" : "Point"
        },
        "count" : "11"
      }, {
        "item" : {
          "coordinates" : [ -74.04684, 41.18244 ],
          "type" : "Point"
        },
        "count" : "9"
      }, {
        "item" : {
          "coordinates" : [ -73.98861, 40.71777 ],
          "type" : "Point"
        },
        "count" : "9"
      }, {
        "item" : {
          "coordinates" : [ -73.99036, 40.75646 ],
          "type" : "Point"
        },
        "count" : "9"
      }, {
        "item" : {
          "coordinates" : [ -77.61581, 43.08877 ],
          "type" : "Point"
        },
        "count" : "7"
      }, {
        "item" : {
          "coordinates" : [ -73.94869, 40.69994 ],
          "type" : "Point"
        },
        "count" : "7"
      }, {
        "item" : {
          "coordinates" : [ -74.00611, 40.74217 ],
          "type" : "Point"
        },
        "count" : "6"
      }, {
        "item" : {
          "coordinates" : [ -77.03731, 42.5753 ],
          "type" : "Point"
        },
        "count" : "6"
      }, {
        "item" : {
          "coordinates" : [ -73.67097, 40.66664 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -73.613, 40.7385 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -74.10835, 41.11191 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -74.0246, 41.10537 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -77.6053, 43.15737 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -73.81584, 42.68379 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -74.07425, 41.0929 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -73.97121, 40.69786 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -73.95693, 40.69849 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -73.1171, 40.78274 ],
          "type" : "Point"
        },
        "count" : "5"
      }, {
        "item" : {
          "coordinates" : [ -77.5907, 43.16612 ],
          "type" : "Point"
        },
        "count" : "4"
      } ],
      "count" : "24281",
      "cardinality" : "24281"
    },
    "format" : { }
  }, {
    "id" : 547687035,
    "name" : "NYS Municipal Boundaries",
    "dataTypeName" : "number",
    "description" : "This column was automatically created in order to record in what polygon from the dataset 'NYS Municipal Boundaries' (yamh-8v7k) the point in column 'georeference' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
    "fieldName" : ":@computed_region_yamh_8v7k",
    "position" : 22,
    "renderTypeName" : "number",
    "tableColumnId" : 139258331,
    "computationStrategy" : {
      "source_columns" : [ "georeference" ],
      "type" : "georegion_match_on_point",
      "parameters" : {
        "region" : "_yamh-8v7k",
        "primary_key" : "_feature_id"
      }
    },
    "format" : { }
  } ],
  "grants" : [ {
    "inherited" : false,
    "type" : "viewer",
    "flags" : [ "public" ]
  } ],
  "metadata" : {
    "rdfSubject" : "0",
    "jsonQuery" : {
      "order" : [ {
        "columnFieldName" : "license_number",
        "ascending" : false
      } ]
    },
    "attachments" : [ {
      "filename" : "NYSDAM_RetailFoodStores_Overview.pdf",
      "assetId" : "997df6cf-5721-4d33-9ff1-0c0201f3c97e",
      "name" : "NYSDAM_RetailFoodStores_Overview.pdf"
    }, {
      "filename" : "NYSDAM_RetailFoodStores_DataDictionary.pdf",
      "assetId" : "fb18aaf7-b5ba-409c-b26b-914c616a9eef",
      "name" : "NYSDAM_RetailFoodStores_DataDictionary.pdf"
    }, {
      "filename" : "NYSDAM_RetailFoodStoresEstablishmentTypeCodes.pdf",
      "assetId" : "f870212a-cc59-46d7-ac7e-67f8173649fa",
      "name" : "NYSDAM_RetailFoodStoresEstablishmentTypeCodes.pdf"
    } ],
    "custom_fields" : {
      "Dataset Summary" : {
        "Posting Frequency" : "Annually",
        "Organization" : "Division of Food Safety & Inspection",
        "Contact Information" : "FSIWebInquiries@agriculture.ny.gov",
        "Time Period" : "Current",
        "Coverage" : "Statewide",
        "Granularity" : "Licensed entity",
        "Dataset Owner" : "New York State Department of Agriculture and Markets"
      },
      "Local Data" : {
        "County_Column" : "county",
        "County Filter" : "Yes",
        "Municipality_Column" : "city",
        "Municipality Filter" : "Yes"
      },
      "Disclaimers" : {
        "Limitations" : "This dataset is from a snap-shot in time and may not always reflect the day-to-day operations of an establishment."
      },
      "Dataset Information" : {
        "Agency" : "Agriculture and Markets, Department of"
      }
    },
    "rowIdentifier" : 547687045,
    "rowLabel" : "Row",
    "availableDisplayTypes" : [ "table", "fatrow", "page" ],
    "renderTypeConfig" : {
      "visible" : {
        "table" : true
      }
    }
  },
  "owner" : {
    "id" : "xzik-pf59",
    "displayName" : "NY Open Data",
    "profileImageUrlLarge" : "/api/users/xzik-pf59/profile_images/LARGE",
    "profileImageUrlMedium" : "/api/users/xzik-pf59/profile_images/THUMB",
    "profileImageUrlSmall" : "/api/users/xzik-pf59/profile_images/TINY",
    "screenName" : "NY Open Data",
    "type" : "interactive",
    "flags" : [ "acceptedEula", "mayBeStoriesCoOwner" ]
  },
  "query" : {
    "orderBys" : [ {
      "ascending" : false,
      "expression" : {
        "columnId" : 547687021,
        "type" : "column"
      }
    } ]
  },
  "rights" : [ "read" ],
  "tableAuthor" : {
    "id" : "xzik-pf59",
    "displayName" : "NY Open Data",
    "profileImageUrlLarge" : "/api/users/xzik-pf59/profile_images/LARGE",
    "profileImageUrlMedium" : "/api/users/xzik-pf59/profile_images/THUMB",
    "profileImageUrlSmall" : "/api/users/xzik-pf59/profile_images/TINY",
    "screenName" : "NY Open Data",
    "type" : "interactive",
    "flags" : [ "acceptedEula", "mayBeStoriesCoOwner" ]
  },
  "tags" : [ "retail food store", "food safety", "license" ],
  "flags" : [ "default", "ownerMayBeContacted", "restorable", "restorePossibleForType" ]
}
