warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
The EntityCommonStockSharesOutstanding does not exist |
industry.us_generic |
{} |
warning |
Ignoring company because Assets is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000038777', 'EntityCommonStockSharesOutstanding': 212293567, 'Assets': 0, 'CashAndCurrentAssets': 0, 'CostOfGoodsSold': 0, 'Debt': 0, 'DepositsAndPayablesToCustomers': 0, 'DepreciationInterestAndFeesExpenses': 0, 'Expenses': 5348500000, 'IntangibleAssets': 0, 'InvestmentIncome': 0, 'Investments': 0, 'LaborExpense': 1255500000, 'Liabilities': 0, 'LoansIncome': 0, 'LoansPayable': 0, 'NetIncome': 1915500000, 'OperatingAndEmployeeLiabilities': 0, 'OperatingExpenses': 4585800000, 'RevenueFromContractWithCustomer': 0, 'Revenues': 7101000000, 'SellingAndGeneralAdministrativeExpense': 3017500000, 'remainder_Assets': 0, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': -3510300000, 'remainder_Liabilities': 0, 'remainder_NetIncome': 163000000, 'remainder_Revenues': 7101000000, 'obs_EconomicCapitalRatio': nan}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4414579248457561, 'aggregate_val': 5283636000, 'exp_sum': 9459692000, 'exp_to_value': {'LaborExpense': 1231214000, 'SellingAndGeneralAdministrativeExpense': 2944842000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 4480212000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 803424000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.44410954632853505, 'aggregate_val': 5348500000, 'exp_sum': 9621500000, 'exp_to_value': {'LaborExpense': 1255500000, 'SellingAndGeneralAdministrativeExpense': 3017500000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 4585800000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 762700000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.24146787951861914, 'aggregate_val': 3375807000, 'exp_sum': 4450447000, 'exp_to_value': {'LaborExpense': 958511000, 'SellingAndGeneralAdministrativeExpense': 116129000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 2991493000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 384314000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.21547771891013243, 'aggregate_val': 4512631000, 'exp_sum': 5752075000, 'exp_to_value': {'LaborExpense': 1080986000, 'SellingAndGeneralAdministrativeExpense': 158458000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 3894319000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 618312000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.4414579248457561, 'aggregate_val': 5283636000, 'exp_sum': 9459692000, 'exp_to_value': {'LaborExpense': 1231214000, 'SellingAndGeneralAdministrativeExpense': 2944842000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 4480212000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 803424000}} |
info |
Minor missing amount for aggregate added to remainder |
industry.us_generic |
{'aggregate': 'Expenses', 'missing_ratio': 0.44410954632853505, 'aggregate_val': 5348500000, 'exp_sum': 9621500000, 'exp_to_value': {'LaborExpense': 1255500000, 'SellingAndGeneralAdministrativeExpense': 3017500000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 4585800000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 762700000}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000038777')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000038777')"} |