Skip to content

Instantly share code, notes, and snippets.

@janlukasschroeder

janlukasschroeder/xbrl-to-json-balance-sheet-item-example.json

Last active December 21, 2021 18:23
Show Gist options
  • Save janlukasschroeder/531012af0d8927fb7d50f3de78ffc7c7 to your computer and use it in GitHub Desktop.
Save janlukasschroeder/531012af0d8927fb7d50f3de78ffc7c7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
xbrl-to-json-balance-sheet-item-example.json
{
"BalanceSheets": {
"CashAndCashEquivalentsAtCarryingValue": [
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"value": "38016000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"value": "48844000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": {
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:CashMember"
},
"value": "17773000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel1Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:MoneyMarketFundsMember"
}
],
"value": "2171000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": {
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel1Member"
},
"value": "2171000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:USTreasurySecuritiesMember"
}
],
"value": "8580000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:USGovernmentAgenciesDebtSecuritiesMember"
}
],
"value": "2009000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:ForeignGovernmentDebtSecuritiesMember"
}
],
"value": "255000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:BankTimeDepositsMember"
}
],
"value": "4043000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:CommercialPaperMember"
}
],
"value": "3185000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:CorporateDebtSecuritiesMember"
}
],
"value": "0"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:USStatesAndPoliticalSubdivisionsMember"
}
],
"value": "0"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:AssetBackedSecuritiesMember"
}
],
"value": "0"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2020-09-26"
},
"segment": {
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
"value": "18072000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": {
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:CashMember"
},
"value": "12204000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel1Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:MoneyMarketFundsMember"
}
],
"value": "15897000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": {
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel1Member"
},
"value": "15897000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:USTreasurySecuritiesMember"
}
],
"value": "6165000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:USGovernmentAgenciesDebtSecuritiesMember"
}
],
"value": "6489000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:ForeignGovernmentDebtSecuritiesMember"
}
],
"value": "749000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:BankTimeDepositsMember"
}
],
"value": "2024000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:CommercialPaperMember"
}
],
"value": "5193000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:CorporateDebtSecuritiesMember"
}
],
"value": "123000000"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:USStatesAndPoliticalSubdivisionsMember"
}
],
"value": "0"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": [
{
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
{
"dimension": "us-gaap:FinancialInstrumentAxis",
"value": "us-gaap:AssetBackedSecuritiesMember"
}
],
"value": "0"
},
{
"decimals": "-6",
"unitRef": "usd",
"period": {
"instant": "2019-09-28"
},
"segment": {
"dimension": "us-gaap:FairValueByFairValueHierarchyLevelAxis",
"value": "us-gaap:FairValueInputsLevel2Member"
},
"value": "20743000000"
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment