Cryptocurency CoinTelegraph Newsfeed
All CoinTelegraph News from 2013 Until April. Data Set Will keep being updated.
@kaggle.asahicantu_cryptocurency_cointelegraph_newsfeed
All CoinTelegraph News from 2013 Until April. Data Set Will keep being updated.
@kaggle.asahicantu_cryptocurency_cointelegraph_newsfeed
unnamed_0Unnamed: 0 | idId | retinaRetina | imgImg | thumbThumb | thumb370Thumb370 | amp_thumbAmp Thumb | thumb150Thumb150 | urlUrl | titleTitle | leadLead | leadfullLeadfull | category_idCategory Id | category_urlCategory Url | category_titleCategory Title | author_urlAuthor Url | author_hashAuthor Hash | author_titleAuthor Title | author_imgAuthor Img | dateDate | flash_dateFlash Date | sponsoredSponsored | press_releasePress Release | sponsored_labelSponsored Label | explainedExplained | stat_uniqsStat Uniqs | rss_dateRss Date | publishedw3PublishedW3 | badge_titleBadge Title | badge_labelBadge Label | published_datePublished Date | published_timezone_typePublished Timezone Type | published_timezonePublished Timezone |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
42577 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9mODJhMzNlNTQzY2RkNTQyZGNiODQ1YTcyNzViZGI1Mi5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9mODJhMzNlNTQzY2RkNTQyZGNiODQ1YTcyNzViZGI1Mi5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9mODJhMzNlNTQzY2RkNTQyZGNiODQ1YTcyNzViZGI1Mi5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9mODJhMzNlNTQzY2RkNTQyZGNiODQ1YTcyNzViZGI1Mi5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9mODJhMzNlNTQzY2RkNTQyZGNiODQ1YTcyNzViZGI1Mi5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9mODJhMzNlNTQzY2RkNTQyZGNiODQ1YTcyNzViZGI1Mi5qcGc=.jpg | https://cointelegraph.com/news/cryptocurrency-news-from-japan-march-29-april-4-in-review | Cryptocurrency News From Japan: March 29 - April 4 in Review | Nomura Research Institute launched Japan’s first blockchain bond, Zaif exchange delisted three assets, and more headlined news from Japan this past week. | 90 | https://cointelegraph.com/category/hodlers-digest | Hodler’s Digest | https://cointelegraph.com/authors/benjamin-pirus | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL2JlbmphbWluLXBpcnVz | Benjamin Pirus | https://images.cointelegraph.com/images/32_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9iNjQwZDUzODM5ZDM2ZjcwNTc5YTA4OWY1ZGY4MzI2Ny5qcGc=.jpg | 2 HOURS AGO | Sun Apr 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 624 | Sun, 05 Apr 2020 00:00:00 +0100 | 2020-04-05T00:00:00+01:00 | Local News | default | Sun Apr 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | |||||
1 | 42575 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8zNmFiMjFmZjg5MjA2OGJkMDBkNWIyZmQwMWU0MWQ2Yy5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8zNmFiMjFmZjg5MjA2OGJkMDBkNWIyZmQwMWU0MWQ2Yy5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8zNmFiMjFmZjg5MjA2OGJkMDBkNWIyZmQwMWU0MWQ2Yy5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8zNmFiMjFmZjg5MjA2OGJkMDBkNWIyZmQwMWU0MWQ2Yy5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8zNmFiMjFmZjg5MjA2OGJkMDBkNWIyZmQwMWU0MWQ2Yy5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8zNmFiMjFmZjg5MjA2OGJkMDBkNWIyZmQwMWU0MWQ2Yy5qcGc=.jpg | https://cointelegraph.com/news/retail-bought-37k-bitcoin-price-dip-on-record-76b-volume-report | Retail Bought $3.7K Bitcoin Price Dip on Record $76B Volume: Report | Fear of the Coronavirus pandemic infected investor confidence, leading Bitcoin price to crash by 50% but as this occurred retail demand for Bitcoin increased an... | 89 | https://cointelegraph.com/category/market-analysis | Market Analysis | https://cointelegraph.com/authors/antonio-madeira | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL2FudG9uaW8tbWFkZWlyYQ== | António Madeira | https://images.cointelegraph.com/images/32_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy81MTYxMjQ3NmZjNzRkNjdjNDBlYmM2Zjc1OGFiNjJkNC5qcGc=.jpg | 3 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 2960 | Sat, 04 Apr 2020 22:50:00 +0100 | 2020-04-04T22:50:00+01:00 | Market Analysis | info | Sat Apr 04 2020 22:50:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | ||||
2 | 42574 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9jZjMwZTZlNzMxYzk2Y2I5NmEwNjRmMzgzMmJmNmU4MS5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9jZjMwZTZlNzMxYzk2Y2I5NmEwNjRmMzgzMmJmNmU4MS5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9jZjMwZTZlNzMxYzk2Y2I5NmEwNjRmMzgzMmJmNmU4MS5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9jZjMwZTZlNzMxYzk2Y2I5NmEwNjRmMzgzMmJmNmU4MS5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9jZjMwZTZlNzMxYzk2Y2I5NmEwNjRmMzgzMmJmNmU4MS5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9jZjMwZTZlNzMxYzk2Y2I5NmEwNjRmMzgzMmJmNmU4MS5qcGc=.jpg | https://cointelegraph.com/news/bitcoins-hedging-performance-in-the-wake-of-the-coronavirus-outbreak | Bitcoin’s Hedging Performance in the Wake of the Coronavirus Outbreak | Investigating the hedging abilities of Bitcoin in response to the global coronavirus pandemic crisis. | 81 | https://cointelegraph.com/category/opinion | Opinion | https://cointelegraph.com/authors/klaus-grobys | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL2tsYXVzLWdyb2J5cw== | Klaus Grobys | https://cointelegraph.com/assets/img/icons/author_male.jpg | 3 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 1498 | Sat, 04 Apr 2020 22:41:00 +0100 | 2020-04-04T22:41:00+01:00 | Opinion | success | Sat Apr 04 2020 22:41:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | ||||
3 | 42573 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84ZjE1ZmU4NWE5M2EyZDMzOGM4NTZlMGMyMGQxZDA4Yi5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84ZjE1ZmU4NWE5M2EyZDMzOGM4NTZlMGMyMGQxZDA4Yi5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84ZjE1ZmU4NWE5M2EyZDMzOGM4NTZlMGMyMGQxZDA4Yi5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84ZjE1ZmU4NWE5M2EyZDMzOGM4NTZlMGMyMGQxZDA4Yi5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84ZjE1ZmU4NWE5M2EyZDMzOGM4NTZlMGMyMGQxZDA4Yi5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84ZjE1ZmU4NWE5M2EyZDMzOGM4NTZlMGMyMGQxZDA4Yi5qcGc=.jpg | https://cointelegraph.com/news/minority-communities-targeted-by-crypto-bottled-water-scam | SEC Alleges Minority Communities Targeted By Bottled Water Scam | A former Christian pastor targeted his African-American parishioners with fake investments in ‘the first black-owned alkaline water company.' | 2 | https://cointelegraph.com/category/latest-news | Latest News | https://cointelegraph.com/authors/samuel-haig | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL3NhbXVlbC1oYWln | Samuel Haig | https://images.cointelegraph.com/images/32_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9jY2M5OGQ5NGY2NzUyNzY0YzBmNmZlNWZiMWMyYTRhNi5qcGc=.jpg | 4 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 3155 | Sat, 04 Apr 2020 21:58:00 +0100 | 2020-04-04T21:58:00+01:00 | News | default | Sat Apr 04 2020 21:58:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | ||||
4 | 42572 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84NDFmOTE2ODJkMGM4OTdlNTkyODkyNzRiYzA0MzM5ZC5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84NDFmOTE2ODJkMGM4OTdlNTkyODkyNzRiYzA0MzM5ZC5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84NDFmOTE2ODJkMGM4OTdlNTkyODkyNzRiYzA0MzM5ZC5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84NDFmOTE2ODJkMGM4OTdlNTkyODkyNzRiYzA0MzM5ZC5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84NDFmOTE2ODJkMGM4OTdlNTkyODkyNzRiYzA0MzM5ZC5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy84NDFmOTE2ODJkMGM4OTdlNTkyODkyNzRiYzA0MzM5ZC5qcGc=.jpg | https://cointelegraph.com/news/april-fools-celebrity-scams-manipulated-markets-bad-crypto-news-of-the-week | April Fools, Celebrity Scams, & Manipulated Markets: Bad Crypto News of the Week | Check the bad crypto news of the past week. | 19 | https://cointelegraph.com/category/analysis | Analysis | https://cointelegraph.com/authors/joel-comm | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL2pvZWwtY29tbQ== | Joel Comm | https://images.cointelegraph.com/images/32_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9kYzViOGM3NTc5NWEyMWMyZjk2OTc5ODU0M2FjZDgzZC5qcGc=.jpg | 5 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 1245 | Sat, 04 Apr 2020 20:53:00 +0100 | 2020-04-04T20:53:00+01:00 | AUDIO | success | Sat Apr 04 2020 20:53:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | ||||
5 | 42571 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy81ZDU4NTJmYWEwYWI5NGUzNjk5MGNmNzcyNzcwNTIxZC5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy81ZDU4NTJmYWEwYWI5NGUzNjk5MGNmNzcyNzcwNTIxZC5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy81ZDU4NTJmYWEwYWI5NGUzNjk5MGNmNzcyNzcwNTIxZC5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy81ZDU4NTJmYWEwYWI5NGUzNjk5MGNmNzcyNzcwNTIxZC5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy81ZDU4NTJmYWEwYWI5NGUzNjk5MGNmNzcyNzcwNTIxZC5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy81ZDU4NTJmYWEwYWI5NGUzNjk5MGNmNzcyNzcwNTIxZC5qcGc=.jpg | https://cointelegraph.com/news/staking-consensus-and-the-pursuit-of-decentralization | Staking, Consensus and the Pursuit of Decentralization | The proof-of-stake ecosystem continues to refine itself and find creative solutions in pursuit of decentralized consensus — despite the problem’s complexity and... | 92 | https://cointelegraph.com/category/use-case | Use Case | https://cointelegraph.com/authors/benjamin-crowell | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL2JlbmphbWluLWNyb3dlbGw= | Benjamin Crowell | https://cointelegraph.com/assets/img/icons/author_male.jpg | 6 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 913 | Sat, 04 Apr 2020 19:59:00 +0100 | 2020-04-04T19:59:00+01:00 | Use Case | default | Sat Apr 04 2020 19:59:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | ||||
6 | 42568 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy83MDBlOTlkMTk2MDU3ZmVmMDM3NmNlNmZkMWEyZjU4ZS5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy83MDBlOTlkMTk2MDU3ZmVmMDM3NmNlNmZkMWEyZjU4ZS5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy83MDBlOTlkMTk2MDU3ZmVmMDM3NmNlNmZkMWEyZjU4ZS5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy83MDBlOTlkMTk2MDU3ZmVmMDM3NmNlNmZkMWEyZjU4ZS5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy83MDBlOTlkMTk2MDU3ZmVmMDM3NmNlNmZkMWEyZjU4ZS5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy83MDBlOTlkMTk2MDU3ZmVmMDM3NmNlNmZkMWEyZjU4ZS5qcGc=.jpg | https://cointelegraph.com/news/blockchain-experts-weigh-in-on-russias-controversial-coronavirus-tracking-app | Blockchain Experts Weigh in on Russia’s Controversial Coronavirus Tracking App | Blockchain technology would have been a better solution for handling coronavirus-related data in Russia. | 2 | https://cointelegraph.com/category/latest-news | Latest News | https://cointelegraph.com/authors/michael-kapilkov | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL21pY2hhZWwta2FwaWxrb3Y= | Michael Kapilkov | https://images.cointelegraph.com/images/32_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8wZjFhZGRiOGE5MTAwZmRkZTZlODViNmZhZmIzMzZlMy5qcGc=.jpg | 6 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 2665 | Sat, 04 Apr 2020 19:30:00 +0100 | 2020-04-04T19:30:00+01:00 | News | default | Sat Apr 04 2020 19:30:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | ||||
7 | 42570 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8wYjM1NjI4ZjdiM2MwNmRiZmZkZGE4ZGJkMDliYWIxNi5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8wYjM1NjI4ZjdiM2MwNmRiZmZkZGE4ZGJkMDliYWIxNi5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8wYjM1NjI4ZjdiM2MwNmRiZmZkZGE4ZGJkMDliYWIxNi5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8wYjM1NjI4ZjdiM2MwNmRiZmZkZGE4ZGJkMDliYWIxNi5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8wYjM1NjI4ZjdiM2MwNmRiZmZkZGE4ZGJkMDliYWIxNi5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy8wYjM1NjI4ZjdiM2MwNmRiZmZkZGE4ZGJkMDliYWIxNi5qcGc=.jpg | https://cointelegraph.com/news/crypto-community-largely-approves-of-binance-acquiring-coinmarketcap | Crypto Community Largely Approves of Binance Acquiring CoinMarketCap | Experts believe that Binance’s acquisition of CoinMarketCap is a sign that the crypto industry is dealing with the ongoing market collapse well. | 83 | https://cointelegraph.com/category/follow-up | Follow-Up | https://cointelegraph.com/authors/shiraz-jagati | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL3NoaXJhei1qYWdhdGk= | Shiraz Jagati | https://images.cointelegraph.com/images/32_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy80NWFkZTVhZDI3NmQyOGMwNjZhMjA2NGE1MTc1ZDNhMy5qcGc=.jpg | 7 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 1420 | Sat, 04 Apr 2020 18:30:00 +0100 | 2020-04-04T18:30:00+01:00 | Follow up | info | Sat Apr 04 2020 18:30:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | ||||
8 | 42569 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9hY2FhN2I4YTE1YjdjZDk1MDUyMWFjNGU2NjcxODc0NC5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9hY2FhN2I4YTE1YjdjZDk1MDUyMWFjNGU2NjcxODc0NC5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9hY2FhN2I4YTE1YjdjZDk1MDUyMWFjNGU2NjcxODc0NC5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9hY2FhN2I4YTE1YjdjZDk1MDUyMWFjNGU2NjcxODc0NC5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9hY2FhN2I4YTE1YjdjZDk1MDUyMWFjNGU2NjcxODc0NC5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9hY2FhN2I4YTE1YjdjZDk1MDUyMWFjNGU2NjcxODc0NC5qcGc=.jpg | https://cointelegraph.com/news/billionaire-optimistic-on-bitcoin-as-a-flight-to-safety | Billionaire Optimistic On Bitcoin as a ‘Flight to Safety’ | Billionaire Chamath Palihapitiya explained a scenario which could see Bitcoin become a “flight to safety” asset. | 2 | https://cointelegraph.com/category/latest-news | Latest News | https://cointelegraph.com/authors/benjamin-pirus | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL2JlbmphbWluLXBpcnVz | Benjamin Pirus | https://images.cointelegraph.com/images/32_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9iNjQwZDUzODM5ZDM2ZjcwNTc5YTA4OWY1ZGY4MzI2Ny5qcGc=.jpg | 8 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 4921 | Sat, 04 Apr 2020 18:00:00 +0100 | 2020-04-04T18:00:00+01:00 | News | default | Sat Apr 04 2020 18:00:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London | ||||
9 | 42566 | https://images.cointelegraph.com/images/1480_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9kOGY4MzIwMGViN2RmYWI0MDFhZTcyMGI2MmFhNDg0NC5qcGc=.jpg | https://images.cointelegraph.com/images/740_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9kOGY4MzIwMGViN2RmYWI0MDFhZTcyMGI2MmFhNDg0NC5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9kOGY4MzIwMGViN2RmYWI0MDFhZTcyMGI2MmFhNDg0NC5qcGc=.jpg | https://images.cointelegraph.com/images/370_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9kOGY4MzIwMGViN2RmYWI0MDFhZTcyMGI2MmFhNDg0NC5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9kOGY4MzIwMGViN2RmYWI0MDFhZTcyMGI2MmFhNDg0NC5qcGc=.jpg | https://images.cointelegraph.com/images/150_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9kOGY4MzIwMGViN2RmYWI0MDFhZTcyMGI2MmFhNDg0NC5qcGc=.jpg | https://cointelegraph.com/news/voyager-onboards-40-000-circle-invest-customers | Voyager Onboards 40,000 Circle Invest Customers | Voyager has completed its acquisition of Circle Invest after onboarding 40,000 customers. | 2 | https://cointelegraph.com/category/latest-news | Latest News | https://cointelegraph.com/authors/samuel-haig | aHR0cHM6Ly9jb2ludGVsZWdyYXBoLmNvbS9hdXRob3JzL3NhbXVlbC1oYWln | Samuel Haig | https://images.cointelegraph.com/images/32_aHR0cHM6Ly9zMy5jb2ludGVsZWdyYXBoLmNvbS9zdG9yYWdlL3VwbG9hZHMvdmlldy9jY2M5OGQ5NGY2NzUyNzY0YzBmNmZlNWZiMWMyYTRhNi5qcGc=.jpg | 9 HOURS AGO | Sat Apr 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | Sponsored | 1913 | Sat, 04 Apr 2020 16:59:00 +0100 | 2020-04-04T16:59:00+01:00 | News | default | Sat Apr 04 2020 16:59:00 GMT+0000 (Coordinated Universal Time) | 3 | Europe/London |
CREATE TABLE cointelegraph_news_head (
"unnamed_0" BIGINT,
"id" BIGINT,
"retina" VARCHAR,
"img" VARCHAR,
"thumb" VARCHAR,
"thumb370" VARCHAR,
"amp_thumb" VARCHAR,
"thumb150" VARCHAR,
"url" VARCHAR,
"title" VARCHAR,
"lead" VARCHAR,
"leadfull" VARCHAR,
"category_id" BIGINT,
"category_url" VARCHAR,
"category_title" VARCHAR,
"author_url" VARCHAR,
"author_hash" VARCHAR,
"author_title" VARCHAR,
"author_img" VARCHAR,
"date" VARCHAR,
"flash_date" TIMESTAMP,
"sponsored" BOOLEAN,
"press_release" BOOLEAN,
"sponsored_label" VARCHAR,
"explained" BOOLEAN,
"stat_uniqs" BIGINT,
"rss_date" VARCHAR,
"publishedw3" VARCHAR,
"badge_title" VARCHAR,
"badge_label" VARCHAR,
"published_date" TIMESTAMP,
"published_timezone_type" BIGINT,
"published_timezone" VARCHAR
);
Anyone who has the link will be able to view this.