Harvest Time Seafood, WHD Case 1630475

Below are key details of Wage and Hour Division's findings for case number 1630475.



In [1]:

    
import sys
sys.path.append("../utils")
import loaders



In [2]:

    
cases = loaders.load_cases().set_index("CASE_ID")



In [3]:

    
employers = loaders.load_employers().set_index("CASE_ID")



In [4]:

    
cases.ix[[1620475]].join(employers)[[
    "ER_LEGAL_NAME",
    "ER_TRADE_NAME",
    "ER_CITY",
    "ER_STATE_ID",
    "TTL_CASE_VIOLATION",
    "AMT_BW_ASSESSED",
    "REGISTRATION_ACT",
    "DATE_REGISTERED",
    "DATE_CONCLUDED",
]].T









    Out[4]:






  
    
      CASE_ID
      1620475
    
  
  
    
      ER_LEGAL_NAME
      Harvest Time Seafood, Inc.
    
    
      ER_TRADE_NAME
      Harvest Time Seafood, Inc.
    
    
      ER_CITY
      Abbeville
    
    
      ER_STATE_ID
      LA
    
    
      TTL_CASE_VIOLATION
      167
    
    
      AMT_BW_ASSESSED
      52202.39
    
    
      REGISTRATION_ACT
      H2B
    
    
      DATE_REGISTERED
      2011-05-26 00:00:00
    
    
      DATE_CONCLUDED
      2013-08-22 00:00:00

CASE_ID	1620475
ER_LEGAL_NAME	Harvest Time Seafood, Inc.
ER_TRADE_NAME	Harvest Time Seafood, Inc.
ER_CITY	Abbeville
ER_STATE_ID	LA
TTL_CASE_VIOLATION	167
AMT_BW_ASSESSED	52202.39
REGISTRATION_ACT	H2B
DATE_REGISTERED	2011-05-26 00:00:00
DATE_CONCLUDED	2013-08-22 00:00:00