🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 168 (from laksa033)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa168.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases\')), getAhrefsUnparsedNoserviceFromURL(\'https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases","crawl_time":1760813485,"first_indexed_time":1665521464,"http_code":200,"src_unparsed":"com,microsoft!learn,\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases s443","src_root_hash":"14615152987638977768","history_drop_reason":null,"meta_title":"European Centre for Disease Prevention and Control (ECDC) COVID-19 Cases - Azure Open Datasets | Microsoft Learn","meta_descriptions":["Learn how to use the European Centre for Disease Prevention and Control (ECDC) COVID-19 Cases dataset in Azure Open Datasets."],"attrs_boilerpipe_text":"The  latest available public data  on geographic distribution of COVID-19 cases worldwide from the European Center for Disease Prevention and Control (ECDC). Each row\/entry contains the number of new cases reported per day and per country or region.  Note Microsoft provides Azure Open Datasets on an “as is” basis. Microsoft makes no warranties, express or implied, guarantees or conditions with respect to your use of the datasets. To the extent permitted under your local law, Microsoft disclaims all liability for any damages or losses, including direct, consequential, special, indirect, incidental or punitive, resulting from your use of the datasets. This dataset is provided under the original terms that Microsoft received source data. The dataset may include data sourced from Microsoft. Modified versions of the dataset are available in CSV, JSON, JSON-Lines, and Parquet, updated daily: All modified versions have iso_country_region codes and load times added, and use lower case column names with underscore separators. Raw data:\n https:\/\/pandemicdatalake.blob.core.windows.net\/public\/raw\/covid-19\/ecdc_cases\/latest\/ECDCCases.csv Previous versions of modified and raw data:\n https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/ https:\/\/pandemicdatalake.blob.core.windows.net\/public\/raw\/covid-19\/ecdc_cases\/ As of May 28, 2020 they contained 19,876 rows (CSV 1.5 MB, JSON 4.9 MB, JSONL 4.9 MB, Parquet 54.1 KB). Raw data is ingested daily from the  ECDC csv file . For more information on this dataset, including its origins, see the  ECDC data collection page . The ECDC does not guarantee the accuracy or timeliness of the data.  Read the disclaimer . License and use rights attribution This data is made available and may be used as permitted under the ECDC copyright policy here. For any documents where the copyright lies with a third party, permission for reproduction must be obtained from the copyright holder. ECDC must always be acknowledged as the original source of this data. Such acknowledgment must be included in each copy of the material. For any questions or feedback about this or other datasets in the COVID-19 Data Lake, please contact askcovid19dl@microsoft.com. Name Data type Unique Values (sample) Description cases smallint 5,515 1 2 Number of reported cases continent_exp string 6 Europe Africa Continent name countries_and_territories string 214 Canada Belgium Country or territory name country_territory_code string 213 KOR ISL Three letter country or territory code date_rep date 350 2020-12-11 2020-11-22 Date of the report day smallint 31 14 13 Day of month deaths smallint 1,049 1 2 Number of reported deaths geo_id string 214 CA SE Geo identifier iso_country string 214 SE US ISO 3166 country or region code load_date timestamp 1 2021-04-26 00:06:22.123000 Date the data was loaded to Azure month smallint 12 10 8 Month number year smallint 2 2020 2019 Year date_rep day month year cases deaths countries_and_territories geo_id country_territory_code continent_exp load_date iso_country 2020-12-14 14 12 2020 746 6 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-13 13 12 2020 298 9 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-12 12 12 2020 113 11 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-11 11 12 2020 63 10 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-10 10 12 2020 202 16 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-09 9 12 2020 135 13 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-08 8 12 2020 200 6 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-07 7 12 2020 210 26 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-06 6 12 2020 234 10 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF 2020-12-05 5 12 2020 235 18 Afghanistan AF AFG Asia 4\/26\/2021 12:06:22 AM AF Sample not available for this platform\/package combination. \nblob_account_name =  \"pandemicdatalake\" \nblob_container_name =  \"public\" \nblob_relative_path =  \"curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.parquet\" \nblob_sas_token =  r\"\" \nwasbs_path =  'wasbs:\/\/%s@%s.blob.core.windows.net\/%s'  % (blob_container_name, blob_account_name, blob_relative_path)\nspark.conf.set(\n   'fs.azure.sas.%s.%s.blob.core.windows.net'  % (blob_container_name, blob_account_name),\n  blob_sas_token)\nprint( 'Remote blob path: '  + wasbs_path)\n\n\ndf = spark.read.parquet(wasbs_path)\nprint( 'Register the DataFrame as a SQL temporary view: source' )\ndf.createOrReplaceTempView( 'source' )\n\n\nprint( 'Displaying top 10 rows: ' )\ndisplay(spark.sql( 'SELECT * FROM source LIMIT 10' ))\n Sample not available for this platform\/package combination. \nblob_account_name =  \"pandemicdatalake\" \nblob_container_name =  \"public\" \nblob_relative_path =  \"curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.parquet\" \nblob_sas_token =  r\"\" \nwasbs_path =  'wasbs:\/\/%s@%s.blob.core.windows.net\/%s'  % (blob_container_name, blob_account_name, blob_relative_path)\nspark.conf.set(\n   'fs.azure.sas.%s.%s.blob.core.windows.net'  % (blob_container_name, blob_account_name),\n  blob_sas_token)\nprint( 'Remote blob path: '  + wasbs_path)\n\n\ndf = spark.read.parquet(wasbs_path)\nprint( 'Register the DataFrame as a SQL temporary view: source' )\ndf.createOrReplaceTempView( 'source' )\n\n\nprint( 'Displaying top 10 rows: ' )\ndisplay(spark.sql( 'SELECT * FROM source LIMIT 10' ))\n See examples of how this dataset can be used: View the rest of the datasets in the  Open Datasets catalog .","attrs_markdown":"[Skip to main content](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#main)   [Skip to Ask Learn chat experience](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases)\n\n## Microsoft Ignite\nNovember 17–21, 2025\n\nSession catalog is live—personalize your event experience across AI, cloud, and more.\n\n[Register now](https:\/\/aka.ms\/msigniteFY26_MSLearn2?wt.mc_ID=Ignite2025_marx_corp_bn_oo_bn_MS_Learn)\n\nDismiss alert\n\nThis browser is no longer supported.\n\nUpgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.\n\n[Download Microsoft Edge](https:\/\/go.microsoft.com\/fwlink\/p\/?LinkID=2092881%20)   [More info about Internet Explorer and Microsoft Edge](https:\/\/learn.microsoft.com\/en-us\/lifecycle\/faq\/internet-explorer-microsoft-edge)\n\n- [Azure Open Datasets documentation](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/)\n- Overview\n  - [What are Azure Open Datasets?](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/overview-what-are-open-datasets)\n- Tutorial\n- How-to guides\n- Dataset catalog\n  - [Dataset catalog](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-catalog)\n  - Transportation\n  - Health and genomics\n    - COVID-19 data lake\n      - [COVID-19 data lake](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-covid-19-data-lake)\n      - [Bing COVID-19 Data](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-bing-covid-19)\n      - [COVID Tracking Project](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-covid-tracking)\n      - [ECDC COVID-19 cases](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases)\n      - [Oxford COVID-19 Government Response Tracker](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-oxford-covid-government-response-tracker)\n    - Genomics Data lake\n  - Labor and economics\n  - Population and safety\n  - Common datasets\n- [Samples](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/samples)\n- Reference\n- Resources\n\nDownload PDF\n\nTable of contents\n\nExit editor mode\n\n1. [Learn](https:\/\/learn.microsoft.com\/en-us\/)\n2. [Azure](https:\/\/learn.microsoft.com\/en-us\/azure\/index\/)\n3. [Open Datasets](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/)\n\n1. [Learn](https:\/\/learn.microsoft.com\/en-us\/)\n2. [Azure](https:\/\/learn.microsoft.com\/en-us\/azure\/index\/)\n3. [Open Datasets](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/)\n\nAsk Learn\n\nAsk Learn\n\nFocus mode\n\nTable of contents\n\n[Read in English](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases?tabs=azure-storage)\n\nAdd to Collections\n\nAdd to plan\n\n[Edit](https:\/\/github.com\/MicrosoftDocs\/azure-ai-docs\/blob\/main\/articles\/open-datasets\/dataset-ecdc-covid-cases.md)\n***\n#### Share via\n[Facebook](https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dfacebook)   [x.com](https:\/\/twitter.com\/intent\/tweet?original_referer=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dtwitter&text=%0A%0D%0Ahttps%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dtwitter&tw_p=tweetbutton&url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dtwitter)   [LinkedIn](https:\/\/www.linkedin.com\/feed\/?shareActive=true&text=%0A%0D%0Ahttps%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dlinkedin)   [Email](mailto:?subject=%5BShared%20Article%5D%20European%20Centre%20for%20Disease%20Prevention%20and%20Control%20\\(ECDC\\)%20COVID-19%20Cases%20-%20Azure%20Open%20Datasets%20%7C%20Microsoft%20Learn&body=%0A%0D%0Ahttps%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Demail)\n***\nPrint\n\n***\nNote\n\nAccess to this page requires authorization. You can try [signing in](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases) or [changing directories]().\n\nAccess to this page requires authorization. You can try [changing directories]().\n# European Centre for Disease Prevention and Control (ECDC) COVID-19 Cases\n- 08\/28\/2024\n\nFeedback\n\n## In this article\n1. [Datasets](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#datasets)\n2. [Data volume](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#data-volume)\n3. [Data source](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#data-source)\n4. [Data quality](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#data-quality)\n5. [License and use rights attribution](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#license-and-use-rights-attribution)\n6. [Contact](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#contact)\n7. [Columns](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#columns)\n8. [Preview](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#preview)\n9. [Data access](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#data-access)\n10. [Examples](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#examples)\n11. [Next steps](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#next-steps)\n\nShow 7 more\n\nThe [latest available public data](https:\/\/www.ecdc.europa.eu\/en\/publications-data\/download-todays-data-geographic-distribution-covid-19-cases-worldwide) on geographic distribution of COVID-19 cases worldwide from the European Center for Disease Prevention and Control (ECDC). Each row\/entry contains the number of new cases reported per day and per country or region.\n\nNote\n\nMicrosoft provides Azure Open Datasets on an “as is” basis. Microsoft makes no warranties, express or implied, guarantees or conditions with respect to your use of the datasets. To the extent permitted under your local law, Microsoft disclaims all liability for any damages or losses, including direct, consequential, special, indirect, incidental or punitive, resulting from your use of the datasets.\n\nThis dataset is provided under the original terms that Microsoft received source data. The dataset may include data sourced from Microsoft.\n## Datasets\nModified versions of the dataset are available in CSV, JSON, JSON-Lines, and Parquet, updated daily:\n\n- <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.csv>\n- <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.json>\n- <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.jsonl>\n- <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.parquet>\n\nAll modified versions have iso\\_country\\_region codes and load times added, and use lower case column names with underscore separators.\n\nRaw data: <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/raw\/covid-19\/ecdc_cases\/latest\/ECDCCases.csv>\n\nPrevious versions of modified and raw data: <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/> <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/raw\/covid-19\/ecdc_cases\/>\n\n## Data volume\nAs of May 28, 2020 they contained 19,876 rows (CSV 1.5 MB, JSON 4.9 MB, JSONL 4.9 MB, Parquet 54.1 KB).\n\n## Data source\nRaw data is ingested daily from the [ECDC csv file](https:\/\/opendata.ecdc.europa.eu\/covid19\/casedistribution\/csv). For more information on this dataset, including its origins, see the [ECDC data collection page](https:\/\/www.ecdc.europa.eu\/en\/covid-19\/data-collection).\n\n## Data quality\nThe ECDC does not guarantee the accuracy or timeliness of the data. [Read the disclaimer](https:\/\/www.ecdc.europa.eu\/en\/covid-19\/data-collection).\n\n## License and use rights attribution\nThis data is made available and may be used as permitted under the ECDC copyright policy here. For any documents where the copyright lies with a third party, permission for reproduction must be obtained from the copyright holder.\n\nECDC must always be acknowledged as the original source of this data. Such acknowledgment must be included in each copy of the material.\n\n## Contact\nFor any questions or feedback about this or other datasets in the COVID-19 Data Lake, please contact askcovid19dl@microsoft.com.\n\n## Columns\nExpand table\n\n| Name | Data type | Unique | Values (sample) | Description |\n|---|---|---|---|---|\n| cases | smallint | 5,515 | 1 2 | Number of reported cases |\n| continent\\_exp | string | 6 | Europe Africa | Continent name |\n| countries\\_and\\_territories | string | 214 | Canada Belgium | Country or territory name |\n| country\\_territory\\_code | string | 213 | KOR ISL | Three letter country or territory code |\n| date\\_rep | date | 350 | 2020-12-11 2020-11-22 | Date of the report |\n| day | smallint | 31 | 14 13 | Day of month |\n| deaths | smallint | 1,049 | 1 2 | Number of reported deaths |\n| geo\\_id | string | 214 | CA SE | Geo identifier |\n| iso\\_country | string | 214 | SE US | ISO 3166 country or region code |\n| load\\_date | timestamp | 1 | 2021-04-26 00:06:22.123000 | Date the data was loaded to Azure |\n| month | smallint | 12 | 10 8 | Month number |\n| year | smallint | 2 | 2020 2019 | Year |\n## Preview\nExpand table\n\n| date\\_rep | day | month | year | cases | deaths | countries\\_and\\_territories | geo\\_id | country\\_territory\\_code | continent\\_exp | load\\_date | iso\\_country |\n|---|---|---|---|---|---|---|---|---|---|---|---|\n| 2020-12-14 | 14 | 12 | 2020 | 746 | 6 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-13 | 13 | 12 | 2020 | 298 | 9 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-12 | 12 | 12 | 2020 | 113 | 11 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-11 | 11 | 12 | 2020 | 63 | 10 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-10 | 10 | 12 | 2020 | 202 | 16 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-09 | 9 | 12 | 2020 | 135 | 13 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-08 | 8 | 12 | 2020 | 200 | 6 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-07 | 7 | 12 | 2020 | 210 | 26 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-06 | 6 | 12 | 2020 | 234 | 10 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n| 2020-12-05 | 5 | 12 | 2020 | 235 | 18 | Afghanistan | AF | AFG | Asia | 4\/26\/2021 12:06:22 AM | AF |\n## Data access\n### Azure Notebooks\n- [azure-storage](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#tabpanel_1_azure-storage)\n- [pyspark](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#tabpanel_1_pyspark)\n\nThis notebook documents the URLs and sample code to access the European Centre for Disease Prevention and Control (ECDC) Covid-19 Cases dataset URLs of different dataset file formats hosted on Azure Blob Storage:¶ CSV: <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.csv>\n\nJSON: <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.json>\n\nJSONL: <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.jsonl>\n\nParquet: <https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.parquet>\n\nDownload the dataset file using the built-in capability download from an http URL in Pandas. Pandas has readers for various file formats:\n\n<https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.read_parquet.html>\n\n<https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.read_csv.html>\n\nPython\n\nCopy\n```\nimport pandas as pd\nimport numpy as np\n%matplotlib inline\nimport matplotlib.pyplot as plt\n\ndf = pd.read_parquet(\"https:\/\/pandemicdatalake.blob.core.windows.net\/public\/curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.parquet\")\ndf.head(10)\n\ndf.dtypes\n\ndf.groupby('countries_and_territories').first().filter(['continent_exp','cases', 'deaths','date_rep'])\n\ndf.groupby('continent_exp').agg({'countries_and_territories': 'count','cases': 'count','deaths': 'count'})\n\nimport plotly.graph_objects as go\nimport plotly.express as px\nimport matplotlib.pyplot as plt\n\ndf.loc[: , ['countries_and_territories', 'cases', 'deaths']].groupby(['countries_and_territories'\n         ]).max().sort_values(by='cases',ascending=False).reset_index()[:15].style.background_gradient(cmap='rainbow')\n\ndf_Worldwide=df[df['countries_and_territories']=='United_States_of_America']\n\ndf.plot(kind='line',x='date_rep',y=\"cases\",grid=True)\ndf.plot(kind='line',x='date_rep',y=\"deaths\",grid=True)\n#df_Worldwide.plot(kind='line',x='date_rep',y=\"confirmed_change\",grid=True)\n#df_Worldwide.plot(kind='line',x='date_rep',y=\"deaths_change\",grid=True)\n```\n\nSample not available for this platform\/package combination.\n### Azure Databricks\n- [azure-storage](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#tabpanel_2_azure-storage)\n- [pyspark](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#tabpanel_2_pyspark)\n\nSample not available for this platform\/package combination.\n\nPython\n\nCopy\n```\n# Azure storage access info\nblob_account_name = \"pandemicdatalake\"\nblob_container_name = \"public\"\nblob_relative_path = \"curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.parquet\"\nblob_sas_token = r\"\"\n\n# Allow SPARK to read from Blob remotely\nwasbs_path = 'wasbs:\/\/%s@%s.blob.core.windows.net\/%s' % (blob_container_name, blob_account_name, blob_relative_path)\nspark.conf.set(\n  'fs.azure.sas.%s.%s.blob.core.windows.net' % (blob_container_name, blob_account_name),\n  blob_sas_token)\nprint('Remote blob path: ' + wasbs_path)\n\n# SPARK read parquet, note that it won't load any data yet by now\ndf = spark.read.parquet(wasbs_path)\nprint('Register the DataFrame as a SQL temporary view: source')\ndf.createOrReplaceTempView('source')\n\n# Display top 10 rows\nprint('Displaying top 10 rows: ')\ndisplay(spark.sql('SELECT * FROM source LIMIT 10'))\n```\n### Azure Synapse\n- [azure-storage](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#tabpanel_3_azure-storage)\n- [pyspark](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#tabpanel_3_pyspark)\n\nSample not available for this platform\/package combination.\n\nPython\n\nCopy\n```\n# Azure storage access info\nblob_account_name = \"pandemicdatalake\"\nblob_container_name = \"public\"\nblob_relative_path = \"curated\/covid-19\/ecdc_cases\/latest\/ecdc_cases.parquet\"\nblob_sas_token = r\"\"\n\n# Allow SPARK to read from Blob remotely\nwasbs_path = 'wasbs:\/\/%s@%s.blob.core.windows.net\/%s' % (blob_container_name, blob_account_name, blob_relative_path)\nspark.conf.set(\n  'fs.azure.sas.%s.%s.blob.core.windows.net' % (blob_container_name, blob_account_name),\n  blob_sas_token)\nprint('Remote blob path: ' + wasbs_path)\n\n# SPARK read parquet, note that it won't load any data yet by now\ndf = spark.read.parquet(wasbs_path)\nprint('Register the DataFrame as a SQL temporary view: source')\ndf.createOrReplaceTempView('source')\n\n# Display top 10 rows\nprint('Displaying top 10 rows: ')\ndisplay(spark.sql('SELECT * FROM source LIMIT 10'))\n```\n## Examples\nSee examples of how this dataset can be used:\n\n- [Analyze COVID data with Synapse SQL serverless endpoint](https:\/\/techcommunity.microsoft.com\/t5\/azure-synapse-analytics\/how-azure-synapse-analytics-helps-you-analyze-covid-data-with\/ba-p\/1457836)\n- [Linear regression analysis on COVID data using SQL endpoint in Azure Synapse Analytics](https:\/\/techcommunity.microsoft.com\/t5\/azure-synapse-analytics\/linear-regression-analysis-on-covid-data-using-sql-endpoint-in\/ba-p\/1468697)\n## Next steps\nView the rest of the datasets in the [Open Datasets catalog](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-catalog).\n\n***\n## Feedback\nWas this page helpful?\n\nYes\n\nNo\n\nNo\n\nNeed help with this topic?\n\nWant to try using Ask Learn to clarify or guide you through this topic?\n\nAsk Learn\n\nAsk Learn\n\nSuggest a fix?\n\nWas this page helpful?\n\nNeed help with this topic?\n\nWant to try using Ask Learn to clarify or guide you through this topic?\n\nAsk Learn\n\nAsk Learn\n\nSuggest a fix?\n\n***\n## Additional resources\nTraining\n\nLearning path\n\n[Explore healthcare data solutions in Microsoft Fabric - Training](https:\/\/learn.microsoft.com\/en-us\/training\/paths\/explore-healthcare-data-solutions\/?source=recommendations)\n\nLearn how to deploy and use healthcare data solutions in Microsoft Fabric.\n\nCertification\n\n[Microsoft Certified: Azure Data Scientist Associate - Certifications](https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/azure-data-scientist\/?source=recommendations)\n\nManage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Python, Azure Machine Learning and MLflow.\n\n## In this article\n1. [Datasets](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#datasets)\n2. [Data volume](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#data-volume)\n3. [Data source](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#data-source)\n4. [Data quality](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#data-quality)\n5. [License and use rights attribution](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#license-and-use-rights-attribution)\n6. [Contact](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#contact)\n7. [Columns](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#columns)\n8. [Preview](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#preview)\n9. [Data access](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#data-access)\n10. [Examples](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#examples)\n11. [Next steps](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases#next-steps)\n\nShow 2 more\n\nWas this page helpful?\n\nYes\n\nNo\n\nNo\n\nNeed help with this topic?\n\nWant to try using Ask Learn to clarify or guide you through this topic?\n\nAsk Learn\n\nAsk Learn\n\nSuggest a fix?\n\nWas this page helpful?\n\nNeed help with this topic?\n\nWant to try using Ask Learn to clarify or guide you through this topic?\n\nAsk Learn\n\nAsk Learn\n\nSuggest a fix?\n\n## Ask Learn\nPreview\n\nAsk Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation.\n\nPlease sign in to use Ask Learn.\n\n[Sign in](https:\/\/learn.microsoft.com\/en-us\/azure\/open-datasets\/dataset-ecdc-covid-cases)\n\n[English (United States)](https:\/\/learn.microsoft.com\/en-us\/locale?target=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases)\n\n[Your Privacy Choices](https:\/\/aka.ms\/yourcaliforniaprivacychoices)\n\nTheme\n\n- Light\n- Dark\n- High contrast\n\n- [AI Disclaimer](https:\/\/learn.microsoft.com\/en-us\/principles-for-ai-generated-content)\n- [Previous Versions](https:\/\/learn.microsoft.com\/en-us\/previous-versions\/)\n- [Blog](https:\/\/techcommunity.microsoft.com\/t5\/microsoft-learn-blog\/bg-p\/MicrosoftLearnBlog)\n- [Contribute](https:\/\/learn.microsoft.com\/en-us\/contribute)\n- [Privacy](https:\/\/go.microsoft.com\/fwlink\/?LinkId=521839)\n- [Terms of Use](https:\/\/learn.microsoft.com\/en-us\/legal\/termsofuse)\n- [Trademarks](https:\/\/www.microsoft.com\/legal\/intellectualproperty\/Trademarks\/)\n- © Microsoft 2025","attrs_readable_markdown":null,"meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

5 months ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	5.7 months ago (distributed domain, exempt)
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases
Last Crawled	2025-10-18 18:51:25 (5 months ago)
First Indexed	2022-10-11 20:51:04 (3 years ago)
HTTP Status Code	200
Meta Title	European Centre for Disease Prevention and Control (ECDC) COVID-19 Cases - Azure Open Datasets \| Microsoft Learn
Meta Description	Learn how to use the European Centre for Disease Prevention and Control (ECDC) COVID-19 Cases dataset in Azure Open Datasets.
Meta Canonical	null
Boilerpipe Text	The latest available public data on geographic distribution of COVID-19 cases worldwide from the European Center for Disease Prevention and Control (ECDC). Each row/entry contains the number of new cases reported per day and per country or region. Note Microsoft provides Azure Open Datasets on an “as is” basis. Microsoft makes no warranties, express or implied, guarantees or conditions with respect to your use of the datasets. To the extent permitted under your local law, Microsoft disclaims all liability for any damages or losses, including direct, consequential, special, indirect, incidental or punitive, resulting from your use of the datasets. This dataset is provided under the original terms that Microsoft received source data. The dataset may include data sourced from Microsoft. Modified versions of the dataset are available in CSV, JSON, JSON-Lines, and Parquet, updated daily: All modified versions have iso_country_region codes and load times added, and use lower case column names with underscore separators. Raw data: https://pandemicdatalake.blob.core.windows.net/public/raw/covid-19/ecdc_cases/latest/ECDCCases.csv Previous versions of modified and raw data: https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/ https://pandemicdatalake.blob.core.windows.net/public/raw/covid-19/ecdc_cases/ As of May 28, 2020 they contained 19,876 rows (CSV 1.5 MB, JSON 4.9 MB, JSONL 4.9 MB, Parquet 54.1 KB). Raw data is ingested daily from the ECDC csv file . For more information on this dataset, including its origins, see the ECDC data collection page . The ECDC does not guarantee the accuracy or timeliness of the data. Read the disclaimer . License and use rights attribution This data is made available and may be used as permitted under the ECDC copyright policy here. For any documents where the copyright lies with a third party, permission for reproduction must be obtained from the copyright holder. ECDC must always be acknowledged as the original source of this data. Such acknowledgment must be included in each copy of the material. For any questions or feedback about this or other datasets in the COVID-19 Data Lake, please contact askcovid19dl@microsoft.com. Name Data type Unique Values (sample) Description cases smallint 5,515 1 2 Number of reported cases continent_exp string 6 Europe Africa Continent name countries_and_territories string 214 Canada Belgium Country or territory name country_territory_code string 213 KOR ISL Three letter country or territory code date_rep date 350 2020-12-11 2020-11-22 Date of the report day smallint 31 14 13 Day of month deaths smallint 1,049 1 2 Number of reported deaths geo_id string 214 CA SE Geo identifier iso_country string 214 SE US ISO 3166 country or region code load_date timestamp 1 2021-04-26 00:06:22.123000 Date the data was loaded to Azure month smallint 12 10 8 Month number year smallint 2 2020 2019 Year date_rep day month year cases deaths countries_and_territories geo_id country_territory_code continent_exp load_date iso_country 2020-12-14 14 12 2020 746 6 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-13 13 12 2020 298 9 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-12 12 12 2020 113 11 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-11 11 12 2020 63 10 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-10 10 12 2020 202 16 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-09 9 12 2020 135 13 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-08 8 12 2020 200 6 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-07 7 12 2020 210 26 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-06 6 12 2020 234 10 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF 2020-12-05 5 12 2020 235 18 Afghanistan AF AFG Asia 4/26/2021 12:06:22 AM AF Sample not available for this platform/package combination. blob_account_name = "pandemicdatalake" blob_container_name = "public" blob_relative_path = "curated/covid-19/ecdc_cases/latest/ecdc_cases.parquet" blob_sas_token = r"" wasbs_path = 'wasbs://%s@%s.blob.core.windows.net/%s' % (blob_container_name, blob_account_name, blob_relative_path) spark.conf.set( 'fs.azure.sas.%s.%s.blob.core.windows.net' % (blob_container_name, blob_account_name), blob_sas_token) print( 'Remote blob path: ' + wasbs_path) df = spark.read.parquet(wasbs_path) print( 'Register the DataFrame as a SQL temporary view: source' ) df.createOrReplaceTempView( 'source' ) print( 'Displaying top 10 rows: ' ) display(spark.sql( 'SELECT * FROM source LIMIT 10' )) Sample not available for this platform/package combination. blob_account_name = "pandemicdatalake" blob_container_name = "public" blob_relative_path = "curated/covid-19/ecdc_cases/latest/ecdc_cases.parquet" blob_sas_token = r"" wasbs_path = 'wasbs://%s@%s.blob.core.windows.net/%s' % (blob_container_name, blob_account_name, blob_relative_path) spark.conf.set( 'fs.azure.sas.%s.%s.blob.core.windows.net' % (blob_container_name, blob_account_name), blob_sas_token) print( 'Remote blob path: ' + wasbs_path) df = spark.read.parquet(wasbs_path) print( 'Register the DataFrame as a SQL temporary view: source' ) df.createOrReplaceTempView( 'source' ) print( 'Displaying top 10 rows: ' ) display(spark.sql( 'SELECT * FROM source LIMIT 10' )) See examples of how this dataset can be used: View the rest of the datasets in the Open Datasets catalog .
Markdown	[Skip to main content](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#main) [Skip to Ask Learn chat experience](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases) ## Microsoft Ignite November 17–21, 2025 Session catalog is live—personalize your event experience across AI, cloud, and more. [Register now](https://aka.ms/msigniteFY26_MSLearn2?wt.mc_ID=Ignite2025_marx_corp_bn_oo_bn_MS_Learn) Dismiss alert This browser is no longer supported. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. [Download Microsoft Edge](https://go.microsoft.com/fwlink/p/?LinkID=2092881%20) [More info about Internet Explorer and Microsoft Edge](https://learn.microsoft.com/en-us/lifecycle/faq/internet-explorer-microsoft-edge) - [Azure Open Datasets documentation](https://learn.microsoft.com/en-us/azure/open-datasets/) - Overview - [What are Azure Open Datasets?](https://learn.microsoft.com/en-us/azure/open-datasets/overview-what-are-open-datasets) - Tutorial - How-to guides - Dataset catalog - [Dataset catalog](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-catalog) - Transportation - Health and genomics - COVID-19 data lake - [COVID-19 data lake](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-covid-19-data-lake) - [Bing COVID-19 Data](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-bing-covid-19) - [COVID Tracking Project](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-covid-tracking) - [ECDC COVID-19 cases](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases) - [Oxford COVID-19 Government Response Tracker](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-oxford-covid-government-response-tracker) - Genomics Data lake - Labor and economics - Population and safety - Common datasets - [Samples](https://learn.microsoft.com/en-us/azure/open-datasets/samples) - Reference - Resources Download PDF Table of contents Exit editor mode 1. [Learn](https://learn.microsoft.com/en-us/) 2. [Azure](https://learn.microsoft.com/en-us/azure/index/) 3. [Open Datasets](https://learn.microsoft.com/en-us/azure/open-datasets/) 1. [Learn](https://learn.microsoft.com/en-us/) 2. [Azure](https://learn.microsoft.com/en-us/azure/index/) 3. [Open Datasets](https://learn.microsoft.com/en-us/azure/open-datasets/) Ask Learn Ask Learn Focus mode Table of contents [Read in English](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases?tabs=azure-storage) Add to Collections Add to plan [Edit](https://github.com/MicrosoftDocs/azure-ai-docs/blob/main/articles/open-datasets/dataset-ecdc-covid-cases.md) * #### Share via [Facebook](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dfacebook) [x.com](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dtwitter&text=%0A%0D%0Ahttps%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dtwitter&tw_p=tweetbutton&url=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dtwitter) [LinkedIn](https://www.linkedin.com/feed/?shareActive=true&text=%0A%0D%0Ahttps%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Dlinkedin) [Email](mailto:?subject=%5BShared%20Article%5D%20European%20Centre%20for%20Disease%20Prevention%20and%20Control%20\(ECDC\)%20COVID-19%20Cases%20-%20Azure%20Open%20Datasets%20%7C%20Microsoft%20Learn&body=%0A%0D%0Ahttps%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases%3Ftabs%3Dazure-storage%26WT.mc_id%3Demail) * Print *** Note Access to this page requires authorization. You can try [signing in](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases) or [changing directories](). Access to this page requires authorization. You can try [changing directories](). # European Centre for Disease Prevention and Control (ECDC) COVID-19 Cases - 08/28/2024 Feedback ## In this article 1. [Datasets](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#datasets) 2. [Data volume](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#data-volume) 3. [Data source](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#data-source) 4. [Data quality](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#data-quality) 5. [License and use rights attribution](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#license-and-use-rights-attribution) 6. [Contact](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#contact) 7. [Columns](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#columns) 8. [Preview](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#preview) 9. [Data access](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#data-access) 10. [Examples](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#examples) 11. [Next steps](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#next-steps) Show 7 more The [latest available public data](https://www.ecdc.europa.eu/en/publications-data/download-todays-data-geographic-distribution-covid-19-cases-worldwide) on geographic distribution of COVID-19 cases worldwide from the European Center for Disease Prevention and Control (ECDC). Each row/entry contains the number of new cases reported per day and per country or region. Note Microsoft provides Azure Open Datasets on an “as is” basis. Microsoft makes no warranties, express or implied, guarantees or conditions with respect to your use of the datasets. To the extent permitted under your local law, Microsoft disclaims all liability for any damages or losses, including direct, consequential, special, indirect, incidental or punitive, resulting from your use of the datasets. This dataset is provided under the original terms that Microsoft received source data. The dataset may include data sourced from Microsoft. ## Datasets Modified versions of the dataset are available in CSV, JSON, JSON-Lines, and Parquet, updated daily: - <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.csv> - <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.json> - <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.jsonl> - <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.parquet> All modified versions have iso\_country\_region codes and load times added, and use lower case column names with underscore separators. Raw data: <https://pandemicdatalake.blob.core.windows.net/public/raw/covid-19/ecdc_cases/latest/ECDCCases.csv> Previous versions of modified and raw data: <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/> <https://pandemicdatalake.blob.core.windows.net/public/raw/covid-19/ecdc_cases/> ## Data volume As of May 28, 2020 they contained 19,876 rows (CSV 1.5 MB, JSON 4.9 MB, JSONL 4.9 MB, Parquet 54.1 KB). ## Data source Raw data is ingested daily from the [ECDC csv file](https://opendata.ecdc.europa.eu/covid19/casedistribution/csv). For more information on this dataset, including its origins, see the [ECDC data collection page](https://www.ecdc.europa.eu/en/covid-19/data-collection). ## Data quality The ECDC does not guarantee the accuracy or timeliness of the data. [Read the disclaimer](https://www.ecdc.europa.eu/en/covid-19/data-collection). ## License and use rights attribution This data is made available and may be used as permitted under the ECDC copyright policy here. For any documents where the copyright lies with a third party, permission for reproduction must be obtained from the copyright holder. ECDC must always be acknowledged as the original source of this data. Such acknowledgment must be included in each copy of the material. ## Contact For any questions or feedback about this or other datasets in the COVID-19 Data Lake, please contact askcovid19dl@microsoft.com. ## Columns Expand table \| Name \| Data type \| Unique \| Values (sample) \| Description \| \|---\|---\|---\|---\|---\| \| cases \| smallint \| 5,515 \| 1 2 \| Number of reported cases \| \| continent\_exp \| string \| 6 \| Europe Africa \| Continent name \| \| countries\_and\_territories \| string \| 214 \| Canada Belgium \| Country or territory name \| \| country\_territory\_code \| string \| 213 \| KOR ISL \| Three letter country or territory code \| \| date\_rep \| date \| 350 \| 2020-12-11 2020-11-22 \| Date of the report \| \| day \| smallint \| 31 \| 14 13 \| Day of month \| \| deaths \| smallint \| 1,049 \| 1 2 \| Number of reported deaths \| \| geo\_id \| string \| 214 \| CA SE \| Geo identifier \| \| iso\_country \| string \| 214 \| SE US \| ISO 3166 country or region code \| \| load\_date \| timestamp \| 1 \| 2021-04-26 00:06:22.123000 \| Date the data was loaded to Azure \| \| month \| smallint \| 12 \| 10 8 \| Month number \| \| year \| smallint \| 2 \| 2020 2019 \| Year \| ## Preview Expand table \| date\_rep \| day \| month \| year \| cases \| deaths \| countries\_and\_territories \| geo\_id \| country\_territory\_code \| continent\_exp \| load\_date \| iso\_country \| \|---\|---\|---\|---\|---\|---\|---\|---\|---\|---\|---\|---\| \| 2020-12-14 \| 14 \| 12 \| 2020 \| 746 \| 6 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-13 \| 13 \| 12 \| 2020 \| 298 \| 9 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-12 \| 12 \| 12 \| 2020 \| 113 \| 11 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-11 \| 11 \| 12 \| 2020 \| 63 \| 10 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-10 \| 10 \| 12 \| 2020 \| 202 \| 16 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-09 \| 9 \| 12 \| 2020 \| 135 \| 13 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-08 \| 8 \| 12 \| 2020 \| 200 \| 6 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-07 \| 7 \| 12 \| 2020 \| 210 \| 26 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-06 \| 6 \| 12 \| 2020 \| 234 \| 10 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| \| 2020-12-05 \| 5 \| 12 \| 2020 \| 235 \| 18 \| Afghanistan \| AF \| AFG \| Asia \| 4/26/2021 12:06:22 AM \| AF \| ## Data access ### Azure Notebooks - [azure-storage](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#tabpanel_1_azure-storage) - [pyspark](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#tabpanel_1_pyspark) This notebook documents the URLs and sample code to access the European Centre for Disease Prevention and Control (ECDC) Covid-19 Cases dataset URLs of different dataset file formats hosted on Azure Blob Storage:¶ CSV: <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.csv> JSON: <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.json> JSONL: <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.jsonl> Parquet: <https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.parquet> Download the dataset file using the built-in capability download from an http URL in Pandas. Pandas has readers for various file formats: <https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_parquet.html> <https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html> Python Copy ``` import pandas as pd import numpy as np %matplotlib inline import matplotlib.pyplot as plt df = pd.read_parquet("https://pandemicdatalake.blob.core.windows.net/public/curated/covid-19/ecdc_cases/latest/ecdc_cases.parquet") df.head(10) df.dtypes df.groupby('countries_and_territories').first().filter(['continent_exp','cases', 'deaths','date_rep']) df.groupby('continent_exp').agg({'countries_and_territories': 'count','cases': 'count','deaths': 'count'}) import plotly.graph_objects as go import plotly.express as px import matplotlib.pyplot as plt df.loc[: , ['countries_and_territories', 'cases', 'deaths']].groupby(['countries_and_territories' ]).max().sort_values(by='cases',ascending=False).reset_index()[:15].style.background_gradient(cmap='rainbow') df_Worldwide=df[df['countries_and_territories']=='United_States_of_America'] df.plot(kind='line',x='date_rep',y="cases",grid=True) df.plot(kind='line',x='date_rep',y="deaths",grid=True) #df_Worldwide.plot(kind='line',x='date_rep',y="confirmed_change",grid=True) #df_Worldwide.plot(kind='line',x='date_rep',y="deaths_change",grid=True) ``` Sample not available for this platform/package combination. ### Azure Databricks - [azure-storage](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#tabpanel_2_azure-storage) - [pyspark](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#tabpanel_2_pyspark) Sample not available for this platform/package combination. Python Copy ``` # Azure storage access info blob_account_name = "pandemicdatalake" blob_container_name = "public" blob_relative_path = "curated/covid-19/ecdc_cases/latest/ecdc_cases.parquet" blob_sas_token = r"" # Allow SPARK to read from Blob remotely wasbs_path = 'wasbs://%s@%s.blob.core.windows.net/%s' % (blob_container_name, blob_account_name, blob_relative_path) spark.conf.set( 'fs.azure.sas.%s.%s.blob.core.windows.net' % (blob_container_name, blob_account_name), blob_sas_token) print('Remote blob path: ' + wasbs_path) # SPARK read parquet, note that it won't load any data yet by now df = spark.read.parquet(wasbs_path) print('Register the DataFrame as a SQL temporary view: source') df.createOrReplaceTempView('source') # Display top 10 rows print('Displaying top 10 rows: ') display(spark.sql('SELECT * FROM source LIMIT 10')) ``` ### Azure Synapse - [azure-storage](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#tabpanel_3_azure-storage) - [pyspark](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#tabpanel_3_pyspark) Sample not available for this platform/package combination. Python Copy ``` # Azure storage access info blob_account_name = "pandemicdatalake" blob_container_name = "public" blob_relative_path = "curated/covid-19/ecdc_cases/latest/ecdc_cases.parquet" blob_sas_token = r"" # Allow SPARK to read from Blob remotely wasbs_path = 'wasbs://%s@%s.blob.core.windows.net/%s' % (blob_container_name, blob_account_name, blob_relative_path) spark.conf.set( 'fs.azure.sas.%s.%s.blob.core.windows.net' % (blob_container_name, blob_account_name), blob_sas_token) print('Remote blob path: ' + wasbs_path) # SPARK read parquet, note that it won't load any data yet by now df = spark.read.parquet(wasbs_path) print('Register the DataFrame as a SQL temporary view: source') df.createOrReplaceTempView('source') # Display top 10 rows print('Displaying top 10 rows: ') display(spark.sql('SELECT * FROM source LIMIT 10')) ``` ## Examples See examples of how this dataset can be used: - [Analyze COVID data with Synapse SQL serverless endpoint](https://techcommunity.microsoft.com/t5/azure-synapse-analytics/how-azure-synapse-analytics-helps-you-analyze-covid-data-with/ba-p/1457836) - [Linear regression analysis on COVID data using SQL endpoint in Azure Synapse Analytics](https://techcommunity.microsoft.com/t5/azure-synapse-analytics/linear-regression-analysis-on-covid-data-using-sql-endpoint-in/ba-p/1468697) ## Next steps View the rest of the datasets in the [Open Datasets catalog](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-catalog). * ## Feedback Was this page helpful? Yes No No Need help with this topic? Want to try using Ask Learn to clarify or guide you through this topic? Ask Learn Ask Learn Suggest a fix? Was this page helpful? Need help with this topic? Want to try using Ask Learn to clarify or guide you through this topic? Ask Learn Ask Learn Suggest a fix? * ## Additional resources Training Learning path [Explore healthcare data solutions in Microsoft Fabric - Training](https://learn.microsoft.com/en-us/training/paths/explore-healthcare-data-solutions/?source=recommendations) Learn how to deploy and use healthcare data solutions in Microsoft Fabric. Certification [Microsoft Certified: Azure Data Scientist Associate - Certifications](https://learn.microsoft.com/en-us/credentials/certifications/azure-data-scientist/?source=recommendations) Manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring with Python, Azure Machine Learning and MLflow. ## In this article 1. [Datasets](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#datasets) 2. [Data volume](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#data-volume) 3. [Data source](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#data-source) 4. [Data quality](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#data-quality) 5. [License and use rights attribution](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#license-and-use-rights-attribution) 6. [Contact](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#contact) 7. [Columns](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#columns) 8. [Preview](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#preview) 9. [Data access](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#data-access) 10. [Examples](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#examples) 11. [Next steps](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases#next-steps) Show 2 more Was this page helpful? Yes No No Need help with this topic? Want to try using Ask Learn to clarify or guide you through this topic? Ask Learn Ask Learn Suggest a fix? Was this page helpful? Need help with this topic? Want to try using Ask Learn to clarify or guide you through this topic? Ask Learn Ask Learn Suggest a fix? ## Ask Learn Preview Ask Learn is an AI assistant that can answer questions, clarify concepts, and define terms using trusted Microsoft documentation. Please sign in to use Ask Learn. [Sign in](https://learn.microsoft.com/en-us/azure/open-datasets/dataset-ecdc-covid-cases) [English (United States)](https://learn.microsoft.com/en-us/locale?target=https%3A%2F%2Flearn.microsoft.com%2Fen-us%2Fazure%2Fopen-datasets%2Fdataset-ecdc-covid-cases) [Your Privacy Choices](https://aka.ms/yourcaliforniaprivacychoices) Theme - Light - Dark - High contrast - [AI Disclaimer](https://learn.microsoft.com/en-us/principles-for-ai-generated-content) - [Previous Versions](https://learn.microsoft.com/en-us/previous-versions/) - [Blog](https://techcommunity.microsoft.com/t5/microsoft-learn-blog/bg-p/MicrosoftLearnBlog) - [Contribute](https://learn.microsoft.com/en-us/contribute) - [Privacy](https://go.microsoft.com/fwlink/?LinkId=521839) - [Terms of Use](https://learn.microsoft.com/en-us/legal/termsofuse) - [Trademarks](https://www.microsoft.com/legal/intellectualproperty/Trademarks/) - © Microsoft 2025
Readable Markdown	null
Shard	168 (laksa)
Root Hash	14615152987638977768
Unparsed URL	com,microsoft!learn,/en-us/azure/open-datasets/dataset-ecdc-covid-cases s443