{
  "asset_id": "P5157",
  "asset_name": "Keystone Oil Pipeline Phase 3b",
  "asset_type": "Oil or NGL Pipeline",
  "operating_status": "operating",
  "operating_sub_status": "operating",
  "country": "United States",
  "state_province": "Texas",
  "latitude": null,
  "longitude": null,
  "capacity_value": 700000.0,
  "capacity_unit": "BOEd",
  "wiki_url": "https://www.gem.wiki/Keystone_Oil_Pipeline",
  "location_id": "P5157",
  "unit_id": null,
  "unit_name": "Phase 3b",
  "source_id": 4,
  "url": "/assets/P5157",
  "ownership_graph_url": "/ownership/graph?root=P5157&direction=up",
  "eventual_owners_url": "/owners?asset_id=P5157",
  "project_name": "Keystone Oil Pipeline",
  "upstream_entity_count": 11,
  "oil_pipeline_fields": {
    "cancelledyear": null,
    "capacity": "700,000.00",
    "capacityboed": "700000",
    "capacityunits": "bpd",
    "constructionyear": "2013",
    "cost": null,
    "costeuro": "--",
    "costusd": "--",
    "costunits": null,
    "countries": "[\"United States\"]",
    "delaytype": null,
    "diameter": null,
    "diameterunits": null,
    "endcountry": "United States",
    "endlocation": null,
    "endprefecture_district": "Houston area",
    "endregion": "Americas",
    "endstate_province": "Texas",
    "endsubregion": "Northern America",
    "fuel": "Oil",
    "fuelsource": null,
    "lastupdated": "2023-01-30",
    "lengthestimatekm": "77.73999999999999",
    "lengthknown": "47",
    "lengthknownkm": "75.64",
    "lengthknownunits": "mi",
    "lengthmergedkm": "75.64",
    "otherlanguageprimarypipelinename": null,
    "owner": "TC Energy [100.%]",
    "ownerentityids": "E100000000136",
    "parent": "TC Energy Corp [100.00%]",
    "pipelinename": "Keystone Oil Pipeline",
    "projectid": "P5157",
    "proposalyear": null,
    "routeaccuracy": "high",
    "routetype": "Mapped route (at any accuracy)",
    "segmentname": "Phase 3b",
    "shelvedyear": null,
    "startcountry": "United States",
    "startlocation": null,
    "startprefecture_district": "Liberty County",
    "startregion": "Americas",
    "startstate_province": "Texas",
    "startsubregion": "Northern America",
    "startyear1": "2017",
    "startyear2": null,
    "startyear3": null,
    "status": "operating",
    "stopyear": null,
    "wiki": "https://www.gem.wiki/Keystone_Oil_Pipeline",
    "unit_name": "Phase 3b",
    "wiki_url": "https://www.gem.wiki/Keystone_Oil_Pipeline"
  },
  "countries": [
    "United States"
  ]
}