{ "cells": [ { "cell_type": "markdown", "metadata": { "toc": true }, "source": [ "
\n", " | case_id | \n", "trade_nm | \n", "legal_name | \n", "street_addr_1_txt | \n", "cty_nm | \n", "st_cd | \n", "zip_cd | \n", "naic_cd | \n", "naics_code_description | \n", "case_violtn_cnt | \n", "cmp_assd_cnt | \n", "ee_violtd_cnt | \n", "bw_atp_amt | \n", "ee_atp_cnt | \n", "findings_start_date | \n", "findings_end_date | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "1473280.0 | \n", "EMTA | \n", "Erie Metropolitan Transit Authority | \n", "127 East 14th Street | \n", "Erie | \n", "PA | \n", "16503.0 | \n", "9770.0 | \n", "Local Transit Systems | \n", "3.0 | \n", "0.0 | \n", "2.0 | \n", "570.00 | \n", "1.0 | \n", "4/22/05 | \n", "4/20/07 | \n", "
1 | \n", "1768364.0 | \n", "Heartland Living & Rehab. | \n", "Heartoland of Greensboro, Inc. | \n", "1131 North Church St. | \n", "Greensboro | \n", "NC | \n", "27401.0 | \n", "623110.0 | \n", "Nursing Care Facilities | \n", "3.0 | \n", "0.0 | \n", "2.0 | \n", "4528.98 | \n", "2.0 | \n", "11/30/13 | \n", "11/28/15 | \n", "
2 | \n", "1692721.0 | \n", "Eli's Table | \n", "Joseph's Cafe, LLC | \n", "129 Meeting Street | \n", "Charleston | \n", "SC | \n", "29401.0 | \n", "722110.0 | \n", "Full-Service Restaurants | \n", "4.0 | \n", "0.0 | \n", "4.0 | \n", "1033.80 | \n", "4.0 | \n", "10/1/11 | \n", "5/29/13 | \n", "
3 | \n", "1768367.0 | \n", "McDowell County Dept. Social Services | \n", "McDowell County Local Government | \n", "60 East Court Street | \n", "Marion | \n", "NC | \n", "28752.0 | \n", "9890.0 | \n", "Other Local Governmental Facilities | \n", "2.0 | \n", "0.0 | \n", "1.0 | \n", "586.42 | \n", "1.0 | \n", "11/9/13 | \n", "11/6/15 | \n", "
4 | \n", "1768533.0 | \n", "Marietta Aesthetic Center | \n", "Sanda Gane European Day Spa & Hair Studio | \n", "3405 Dallas Hwy. | \n", "Marietta | \n", "GA | \n", "30064.0 | \n", "812112.0 | \n", "Beauty Salons | \n", "15.0 | \n", "0.0 | \n", "14.0 | \n", "3873.60 | \n", "14.0 | \n", "8/3/13 | \n", "8/8/15 | \n", "
\n", " | case_id | \n", "trade_nm | \n", "legal_name | \n", "street_addr_1_txt | \n", "cty_nm | \n", "st_cd | \n", "zip_cd | \n", "naic_cd | \n", "naics_code_description | \n", "case_violtn_cnt | \n", "cmp_assd_cnt | \n", "ee_violtd_cnt | \n", "bw_atp_amt | \n", "ee_atp_cnt | \n", "findings_start_date | \n", "findings_end_date | \n", "Group | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308 | \n", "1448316.0 | \n", "Wal-Mart | \n", "Wal-Mart Stores East LP | \n", "103 W. Polk | \n", "Warsaw | \n", "MO | \n", "65355.0 | \n", "452910.0 | \n", "Warehouse Clubs and Supercenters | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "7/17/04 | \n", "7/14/06 | \n", "Wal-Mart Stores East LP | \n", "
1886 | \n", "1503906.0 | \n", "Wal-Mart | \n", "Wal-Mart Stores, Inc. | \n", "702 S.W. 8th St. | \n", "Bentonville | \n", "AR | \n", "72716.0 | \n", "45211.0 | \n", "Department Stores | \n", "154.0 | \n", "0.0 | \n", "154.0 | \n", "42844.39 | \n", "154.0 | \n", "2/3/02 | \n", "1/31/07 | \n", "Wal-Mart Stores East LP | \n", "
3275 | \n", "1642363.0 | \n", "Walmart | \n", "Walmart Stores, Inc. | \n", "1091 Millcreek Road | \n", "Allentown | \n", "PA | \n", "18106.0 | \n", "452990.0 | \n", "All Other General Merchandise Stores | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "0.00 | \n", "0.0 | \n", "3/11/10 | \n", "3/10/12 | \n", "Wal-Mart Stores East LP | \n", "
6518 | \n", "1487151.0 | \n", "Wal-Mart | \n", "Wal-Mart Stores, Inc. | \n", "3209 S. Louise Ave | \n", "Sioux Falls | \n", "SD | \n", "57106.0 | \n", "452990.0 | \n", "All Other General Merchandise Stores | \n", "1.0 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "7/23/07 | \n", "9/12/07 | \n", "Wal-Mart Stores East LP | \n", "
8594 | \n", "1446927.0 | \n", "Wal-Mart #1069 | \n", "Wal-Mart Stores, Inc. | \n", "231 Eastside Drive | \n", "Newton | \n", "MS | \n", "39345.0 | \n", "452910.0 | \n", "Warehouse Clubs and Supercenters | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "6/18/04 | \n", "6/9/06 | \n", "Wal-Mart Stores East LP | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
249003 | \n", "1403735.0 | \n", "Wal-Mart Supercenter | \n", "Wal-Mart Stores, Inc. | \n", "11250 E. Colonial Dr. | \n", "Orlando | \n", "FL | \n", "32817.0 | \n", "4529.0 | \n", "Other General Merchandise Stores | \n", "1.0 | \n", "0.0 | \n", "1.0 | \n", "4622.40 | \n", "1.0 | \n", "2/5/05 | \n", "5/6/05 | \n", "Wal-Mart Stores East LP | \n", "
255254 | \n", "1841415.0 | \n", "Walmart Supercenter #3229 | \n", "Walmart Stores, Inc. | \n", "3800 U.S. Highway 287 W. | \n", "Vernon | \n", "TX | \n", "76384.0 | \n", "452112.0 | \n", "Discount Department Stores | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "0.00 | \n", "0.0 | \n", "1/11/16 | \n", "1/10/18 | \n", "Wal-Mart Stores East LP | \n", "
257478 | \n", "1855178.0 | \n", "Wal-Mart | \n", "Wal-Mart Stores, Inc. | \n", "1400 S. Lamb Blvd | \n", "Las Vegas | \n", "NV | \n", "89104.0 | \n", "452112.0 | \n", "Discount Department Stores | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "0.00 | \n", "0.0 | \n", "9/16/17 | \n", "12/18/17 | \n", "Wal-Mart Stores East LP | \n", "
262300 | \n", "1842192.0 | \n", "Walmart Store #2474 | \n", "Walmart Stores, Inc. | \n", "Railroad 4 Box 82 | \n", "Keyser | \n", "WV | \n", "26726.0 | \n", "452910.0 | \n", "Warehouse Clubs and Supercenters | \n", "1.0 | \n", "0.0 | \n", "1.0 | \n", "0.00 | \n", "0.0 | \n", "12/17/16 | \n", "12/17/17 | \n", "Wal-Mart Stores East LP | \n", "
274193 | \n", "1862876.0 | \n", "Wal-Mart Supercenter | \n", "Wal-Mart Stores East LP | \n", "950 Hwy. 80 East | \n", "Clinton | \n", "MS | \n", "39056.0 | \n", "452112.0 | \n", "Discount Department Stores | \n", "0.0 | \n", "0.0 | \n", "1.0 | \n", "0.00 | \n", "0.0 | \n", "3/28/18 | \n", "6/4/18 | \n", "Wal-Mart Stores East LP | \n", "
144 rows × 17 columns
\n", "