Grocery Stores - 2013
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | 53t8-wyrc |
| Name | Grocery Stores - 2013 |
| Attribution | City of Chicago |
| Category | Community & Economic Development |
| Tags | food, food desert |
| Created | 2013-08-23T04:26:07Z |
| Publication Date | 2013-08-26T20:39:15Z |
Description
Contains a list of grocery stores which was used by the city to calculate the estimates of Chicagoans living in food deserts in 2011. Data in this file can be cross-referenced with the city’s business license data (http://bit.ly/sMFZdN).
Columns
| Included | Schema Type | Field Name | Name | Data Type | Render Type |
| ======== | ============== | =================== | =================== | ========= | =========== |
| Yes | series tag | store_name | STORE NAME | text | text |
| Yes | series tag | license_id | LICENSE ID | text | number |
| Yes | series tag | account_number | ACCOUNT NUMBER | text | number |
| Yes | numeric metric | square_feet | SQUARE FEET | number | number |
| Yes | series tag | buffer_size | BUFFER SIZE | text | text |
| No | | address | ADDRESS | text | text |
| Yes | series tag | zip_code | ZIP CODE | text | number |
| Yes | series tag | community_area_name | COMMUNITY AREA NAME | text | text |
| Yes | series tag | community_area | COMMUNITY AREA | text | number |
| Yes | series tag | ward | WARD | text | number |
| Yes | numeric metric | census_tract | CENSUS TRACT | number | number |
| Yes | numeric metric | census_block | CENSUS BLOCK | number | number |
| No | | x_coordinate | X COORDINATE | number | number |
| No | | y_coordinate | Y COORDINATE | number | number |
| No | | latitude | LATITUDE | number | number |
| No | | longitude | LONGITUDE | number | number |
Time Field
Value = 2013
Format & Zone = yyyy
Series Fields
Excluded Fields = address,x_coordinate,y_coordinate,latitude,longitude
Data Commands
series e:53t8-wyrc d:2013-01-01T00:00:00.000Z t:ward=3 t:account_number=17055 t:zip_code=60653 t:buffer_size=B t:community_area_name="GRAND BOULEVARD" t:license_id=48663 t:community_area=38 t:store_name="200 LIQUORS" m:census_block=170313815001007 m:census_tract=17031381500 m:square_feet=5000
series e:53t8-wyrc d:2013-01-01T00:00:00.000Z t:ward=46 t:account_number=9830 t:zip_code=60613 t:buffer_size=B t:community_area_name="LAKE VIEW" t:license_id=24279 t:community_area=6 t:store_name="3600 COMMISSARY" m:census_block=170310609004001 m:census_tract=17031060900 m:square_feet=3800
series e:53t8-wyrc d:2013-01-01T00:00:00.000Z t:ward=14 t:account_number=260303 t:zip_code=60632 t:buffer_size=A t:community_area_name="ARCHER HEIGHTS" t:license_id=1336669 t:community_area=57 t:store_name="4343 PETES FRESH MARKET" m:census_block=170315701001015 m:census_tract=17031570100 m:square_feet=57000
Meta Commands
metric m:square_feet p:integer l:"SQUARE FEET" t:dataTypeName=number
metric m:census_tract p:long l:"CENSUS TRACT" t:dataTypeName=number
metric m:census_block p:long l:"CENSUS BLOCK" t:dataTypeName=number
entity e:53t8-wyrc l:"Grocery Stores - 2013" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/53t8-wyrc
property e:53t8-wyrc t:meta.view v:id=53t8-wyrc v:category="Community & Economic Development" v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="Grocery Stores - 2013" v:attribution="City of Chicago"
property e:53t8-wyrc t:meta.view.owner v:id=3qqc-w7ag v:profileImageUrlMedium=/api/users/3qqc-w7ag/profile_images/THUMB v:profileImageUrlLarge=/api/users/3qqc-w7ag/profile_images/LARGE v:screenName="Tom Schenk Jr" v:profileImageUrlSmall=/api/users/3qqc-w7ag/profile_images/TINY v:lastNotificationSeenAt=1491330280 v:displayName="Tom Schenk Jr"
property e:53t8-wyrc t:meta.view.tableauthor v:id=3qqc-w7ag v:profileImageUrlMedium=/api/users/3qqc-w7ag/profile_images/THUMB v:profileImageUrlLarge=/api/users/3qqc-w7ag/profile_images/LARGE v:screenName="Tom Schenk Jr" v:profileImageUrlSmall=/api/users/3qqc-w7ag/profile_images/TINY v:roleName=administrator v:lastNotificationSeenAt=1491330280 v:displayName="Tom Schenk Jr"
Top Records
| store_name | license_id | account_number | square_feet | buffer_size | address | zip_code | community_area_name | community_area | ward | census_tract | census_block | x_coordinate | y_coordinate | latitude | longitude |
| ===================================== | ========== | ============== | =========== | =========== | ==================== | ======== | ====================== | ============== | ==== | ============ | =============== | ================== | ================== | ============= | ============== |
| 200 LIQUORS | 48663 | 17055 | 5000 | B | 204 E 47TH ST | 60653 | GRAND BOULEVARD | 38 | 3 | 17031381500 | 170313815001007 | 1178461.6344048942 | 1873949.3843109086 | 41.8094238941 | -87.6209518020 |
| 3600 COMMISSARY | 24279 | 9830 | 3800 | B | 3600 N LAKE SHORE DR | 60613 | LAKE VIEW | 6 | 46 | 17031060900 | 170310609004001 | 1171865.8187503873 | 1924645.0382131825 | 41.9486836744 | -87.6436497585 |
| 4343 PETES FRESH MARKET | 1336669 | 260303 | 57000 | A | 4343 S PULASKI RD | 60632 | ARCHER HEIGHTS | 57 | 14 | 17031570100 | 170315701001015 | 1150447.9257608664 | 1875370.2855434741 | 41.8139143113 | -87.7236649419 |
| 4700 PETE'S FRESH MARKET | 1243125 | 245519 | 45000 | A | 4700 S KEDZIE AVE | 60632 | BRIGHTON PARK | 58 | 14 | 17031842800 | 170318428004023 | 1155791.9493024794 | 1873270.7784828772 | 41.8080472717 | -87.7041188223 |
| 5659 W. DIVERSEY | 1575023 | 277375 | 4000 | B | 5659 W DIVERSEY AVE | 60639 | BELMONT CRAGIN | 19 | 30 | 17031190602 | 170311906022001 | 1137914.0810304238 | 1918001.6539807494 | 41.9311354035 | -87.7686121306 |
| 7400 S HALSTED FOOD AND LIQUORS, INC. | 980 | 186 | 10001 | A | 7400 S HALSTED ST | 60621 | ENGLEWOOD | 68 | 17 | 17031681300 | 170316813003005 | 1172208.8098604858 | 1855768.9165432698 | 41.7596745819 | -87.6444202389 |
| 79 FOOD BASKET | 1958784 | 341069 | 3000 | B | 1351 W 79TH ST | 60620 | AUBURN GRESHAM | 71 | 21 | 17031710700 | 170317107001012 | 1168478.9380996425 | 1852330.8146064386 | 41.7503211206 | -87.6581890529 |
| A & B FOOD MARKET INC | 43181 | 6483 | 10001 | A | 5057 W DIVISION ST | 60651 | AUSTIN | 25 | 37 | 17031251100 | 170312511004000 | 1142184.0432471954 | 1907473.3799980525 | 41.9021664421 | -87.7531823487 |
| A & G LIQUORS | 44373 | 35423 | 4800 | B | 6945 S STATE ST | 60637 | GREATER GRAND CROSSING | 69 | 6 | 17031690400 | 170316904003005 | 1177546.7151574378 | 1858784.7080415017 | 41.7678312792 | -87.6247659397 |
| A & R FOOD MART | 9125 | 4227 | 2500 | B | 5952 W GRAND AVE | 60639 | BELMONT CRAGIN | 19 | 37 | 17031191302 | 170311913021018 | 1136148.4645573950 | 1914149.5267326030 | 41.9205964582 | -87.7751926809 |