warning |
The stock price does not exist |
industry.us_generic |
{} |
warning |
The EntityCommonStockSharesOutstanding does not exist |
industry.us_generic |
{} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': inf, 'aggregate_val': 18313000000, 'exp_sum': 0, 'exp_to_value': {'remainder_Revenues': 0}} |
warning |
Large missing amount for aggregate "Revenues" added to remainder. |
industry.us_generic |
{'missing_ratio': inf, 'aggregate_val': 18479000000, 'exp_sum': 0, 'exp_to_value': {'remainder_Revenues': 0}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000070318', 'Assets': 8500000000, 'AssetsCurrent': 2311000000, 'AssetsNonCurrent': 164000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillImpairmentLoss': 0, 'IntangibleAssets': 1094000000, 'LaborExpense': 0, 'Liabilities': 6681000000, 'LiabilitiesAndStockholdersEquity': 8500000000, 'LiabilitiesCurrent': 1725000000, 'LongTermLiabilities': 4551000000, 'NetIncome': 1152000000, 'OperatingCostsAndExpenses': 0, 'PropertyPlantAndEquipment': 4304000000, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingAndMarketingExpense': 0, 'remainder_Assets': 627000000, 'remainder_ComprehensiveNetIncome': -44000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 405000000, 'remainder_NetIncome': 1152000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 1819000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000070318', 'EntityCommonStockSharesOutstanding': 434349003, 'Assets': 8462000000, 'AssetsCurrent': 2357000000, 'AssetsNonCurrent': 156000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillImpairmentLoss': 0, 'IntangibleAssets': 736000000, 'LaborExpense': 0, 'Liabilities': 6954000000, 'LiabilitiesAndStockholdersEquity': 8462000000, 'LiabilitiesCurrent': 1815000000, 'LongTermLiabilities': 5137000000, 'NetIncome': 94000000, 'OperatingCostsAndExpenses': 0, 'PropertyPlantAndEquipment': 4350000000, 'RedeemableEquity': 16000000, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingAndMarketingExpense': 0, 'remainder_Assets': 863000000, 'remainder_ComprehensiveNetIncome': -45000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 2000000, 'remainder_NetIncome': 94000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 1492000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000070318', 'EntityCommonStockSharesOutstanding': 106475474, 'Assets': 9044000000, 'AssetsCurrent': 2681000000, 'AssetsNonCurrent': 162000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillImpairmentLoss': 0, 'IntangibleAssets': 916000000, 'LaborExpense': 0, 'Liabilities': 7810000000, 'LiabilitiesAndStockholdersEquity': 9044000000, 'LiabilitiesCurrent': 1763000000, 'LongTermLiabilities': 6045000000, 'NetIncome': 133000000, 'OperatingCostsAndExpenses': 0, 'PropertyPlantAndEquipment': 4293000000, 'RedeemableEquity': 16000000, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingAndMarketingExpense': 0, 'remainder_Assets': 992000000, 'remainder_ComprehensiveNetIncome': -8000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 2000000, 'remainder_NetIncome': 133000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 1218000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000070318', 'EntityCommonStockSharesOutstanding': 99226697, 'Assets': 16130000000, 'AssetsCurrent': 3710000000, 'AssetsNonCurrent': 405000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillImpairmentLoss': 0, 'IntangibleAssets': 3042000000, 'LaborExpense': 0, 'Liabilities': 15005000000, 'LiabilitiesAndStockholdersEquity': 16130000000, 'LiabilitiesCurrent': 2928000000, 'LongTermLiabilities': 11679000000, 'NetIncome': -104000000, 'OperatingCostsAndExpenses': 0, 'PropertyPlantAndEquipment': 7691000000, 'RedeemableEquity': 247000000, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingAndMarketingExpense': 0, 'remainder_Assets': 1282000000, 'remainder_ComprehensiveNetIncome': 14000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 398000000, 'remainder_NetIncome': -104000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 878000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000070318', 'EntityCommonStockSharesOutstanding': 98280152, 'Assets': 18141000000, 'AssetsCurrent': 4717000000, 'AssetsNonCurrent': 384000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillImpairmentLoss': 0, 'IntangibleAssets': 5191000000, 'LaborExpense': 0, 'Liabilities': 16955000000, 'LiabilitiesAndStockholdersEquity': 18141000000, 'LiabilitiesCurrent': 3577000000, 'LongTermLiabilities': 12745000000, 'NetIncome': 76000000, 'OperatingCostsAndExpenses': 0, 'PropertyPlantAndEquipment': 7733000000, 'RedeemableEquity': 401000000, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingAndMarketingExpense': 0, 'remainder_Assets': 116000000, 'remainder_ComprehensiveNetIncome': -222000000, 'remainder_Expenses': 0, 'remainder_Liabilities': 633000000, 'remainder_NetIncome': 76000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 785000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000070318', 'EntityCommonStockSharesOutstanding': 99669208, 'Assets': 23682000000, 'AssetsCurrent': 5171000000, 'AssetsNonCurrent': 1175000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillImpairmentLoss': 0, 'IntangibleAssets': 8645000000, 'LaborExpense': 0, 'Liabilities': 20458000000, 'LiabilitiesAndStockholdersEquity': 23682000000, 'LiabilitiesCurrent': 4308000000, 'LongTermLiabilities': 15555000000, 'NetIncome': 78000000, 'OperatingCostsAndExpenses': 0, 'PropertyPlantAndEquipment': 7915000000, 'RedeemableEquity': 2266000000, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingAndMarketingExpense': 0, 'remainder_Assets': 776000000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 595000000, 'remainder_NetIncome': 78000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 958000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000070318', 'EntityCommonStockSharesOutstanding': 99635674, 'Assets': 24701000000, 'AssetsCurrent': 5257000000, 'AssetsNonCurrent': 1250000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillImpairmentLoss': 0, 'IntangibleAssets': 9270000000, 'LaborExpense': 0, 'Liabilities': 21226000000, 'LiabilitiesAndStockholdersEquity': 24701000000, 'LiabilitiesCurrent': 4313000000, 'LongTermLiabilities': 16287000000, 'NetIncome': 176000000, 'OperatingCostsAndExpenses': 0, 'PropertyPlantAndEquipment': 8053000000, 'RedeemableEquity': 2393000000, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingAndMarketingExpense': 0, 'remainder_Assets': 871000000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 626000000, 'remainder_NetIncome': 176000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 1082000000, 'obs_EconomicCapitalRatio': nan}} |
warning |
Ignoring company because Expenses is zero |
pre-agg |
{'balance_sheet': {'company_id': '0000070318', 'EntityCommonStockSharesOutstanding': 100936869, 'Assets': 23385000000, 'AssetsCurrent': 5573000000, 'AssetsNonCurrent': 1543000000, 'CostOfGoodsAndServicesSold': 0, 'DepreciationDepletionAndAmortization': 0, 'Expenses': 0, 'GeneralAndAdministrativeExpense': 0, 'GoodwillImpairmentLoss': 0, 'IntangibleAssets': 8784000000, 'LaborExpense': 0, 'Liabilities': 20980000000, 'LiabilitiesAndStockholdersEquity': 23385000000, 'LiabilitiesCurrent': 4368000000, 'LongTermLiabilities': 16076000000, 'NetIncome': -320000000, 'OperatingCostsAndExpenses': 0, 'PropertyPlantAndEquipment': 7030000000, 'RedeemableEquity': 1866000000, 'ResearchAndDevelopmentExpense': 0, 'Revenues': 0, 'SellingAndMarketingExpense': 0, 'remainder_Assets': 455000000, 'remainder_ComprehensiveNetIncome': 0, 'remainder_Expenses': 0, 'remainder_Liabilities': 536000000, 'remainder_NetIncome': -320000000, 'remainder_Revenues': 0, 'remainder_StockholdersEquity': 539000000, 'obs_EconomicCapitalRatio': nan}} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('EntityCommonStockSharesOutstanding')"} |
info |
Failed to set obs_EconomicCapitalRatio |
industry.us_generic |
{'reason': "KeyError('0000070318')"} |
info |
Added remainder_ComprehensiveNetIncome directly from 10K |
industry.us_generic |
{} |