posts_gdocs_links
Data license: CC-BY
3 rows where sourceId = "19R3CYZqGslSjsZ1QPOwIjjVUdvhqMcA_Rx4QTVhPA3Q"
This data as json, CSV (advanced)
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1828698 | Primary, secondary, final, and useful energy: Why are there different ways of measuring energy? 19R3CYZqGslSjsZ1QPOwIjjVUdvhqMcA_Rx4QTVhPA3Q | https://www.eia.gov/todayinenergy/detail.php?id=44436 | url | span-link | two-thirds of the primary energy | ?id=44436 | |
1828699 | Primary, secondary, final, and useful energy: Why are there different ways of measuring energy? 19R3CYZqGslSjsZ1QPOwIjjVUdvhqMcA_Rx4QTVhPA3Q | https://www.eia.gov/todayinenergy/detail.php?id=18671 | url | span-link | much more efficient | ?id=18671 | |
1828700 | Primary, secondary, final, and useful energy: Why are there different ways of measuring energy? 19R3CYZqGslSjsZ1QPOwIjjVUdvhqMcA_Rx4QTVhPA3Q | https://www.fueleconomy.gov/feg/atv-ev.shtml | url | span-link | compared to losses |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_gdocs_links" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "sourceId" VARCHAR(255) NULL , "target" TEXT NOT NULL , "linkType" TEXT NULL , "componentType" VARCHAR(255) NOT NULL , "text" VARCHAR(255) NOT NULL , "queryString" VARCHAR(2047) NOT NULL , "hash" VARCHAR(2047) NOT NULL, FOREIGN KEY("sourceId") REFERENCES "posts_gdocs" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION ); CREATE INDEX "sourceId" ON "posts_gdocs_links" ("sourceId");