| warning |
The stock price 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.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.4414579248457561, 'aggregate_val': 5283636000, 'exp_sum': 9459692000, 'exp_to_value': {'LaborExpense': 1231214000, 'SellingAndGeneralAdministrativeExpense': 2944842000, 'CostOfGoodsSold': 0, 'OperatingExpenses': 4480212000, 'DepreciationInterestAndFeesExpenses': 0, 'remainder_Expenses': 803424000}} |
| info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000038777')"} |