time_series_covid19_deaths_global

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are time series reports which provide cases, deaths and recovered for global locations as well as United States counties. Each file covers from Jan 22 to the present. For the United States there is one file for cases and one for deaths. For the global locations, there is one file for cases, one for deaths and one for recovered cases. The entire set of CSV files are refreshed daily. The zipped archives contain previous time series reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: big-local-datasette

1 row where 3/19/20 = 76

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

3/19/20 ✖

Link rowid â–¼ Province/State Country/Region Lat Long 1/22/20 1/23/20 1/24/20 1/25/20 1/26/20 1/27/20 1/28/20 1/29/20 1/30/20 1/31/20 2/1/20 2/2/20 2/3/20 2/4/20 2/5/20 2/6/20 2/7/20 2/8/20 2/9/20 2/10/20 2/11/20 2/12/20 2/13/20 2/14/20 2/15/20 2/16/20 2/17/20 2/18/20 2/19/20 2/20/20 2/21/20 2/22/20 2/23/20 2/24/20 2/25/20 2/26/20 2/27/20 2/28/20 2/29/20 3/1/20 3/2/20 3/3/20 3/4/20 3/5/20 3/6/20 3/7/20 3/8/20 3/9/20 3/10/20 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20 3/28/20 3/29/20 3/30/20 3/31/20 4/1/20 4/2/20 4/3/20 4/4/20 4/5/20 4/6/20 4/7/20 4/8/20 4/9/20 4/10/20 4/11/20 4/12/20 4/13/20 4/14/20 4/15/20 4/16/20 4/17/20 4/18/20 4/19/20 4/20/20 4/21/20 4/22/20 4/23/20 4/24/20 4/25/20 4/26/20 4/27/20 4/28/20 4/29/20 4/30/20 5/1/20 5/2/20 5/3/20 5/4/20 5/5/20 5/6/20 5/7/20 5/8/20 5/9/20 5/10/20 5/11/20 5/12/20 5/13/20 5/14/20 5/15/20 5/16/20 5/17/20 5/18/20 5/19/20 5/20/20 5/21/20 5/22/20 5/23/20 5/24/20 5/25/20 5/26/20 5/27/20 5/28/20 5/29/20 5/30/20 5/31/20 6/1/20 6/2/20 6/3/20 6/4/20 6/5/20 6/6/20 6/7/20 6/8/20 6/9/20 6/10/20 6/11/20 6/12/20 6/13/20 6/14/20 6/15/20 6/16/20 6/17/20 6/18/20 6/19/20 6/20/20 6/21/20 6/22/20 6/23/20 6/24/20 6/25/20 6/26/20 6/27/20 6/28/20 6/29/20 6/30/20 7/1/20 7/2/20 7/3/20 7/4/20 7/5/20 7/6/20 7/7/20 7/8/20 7/9/20 7/10/20 7/11/20 7/12/20 7/13/20 7/14/20 7/15/20 7/16/20 7/17/20 7/18/20 7/19/20 7/20/20 7/21/20 7/22/20 7/23/20 7/24/20 7/25/20 7/26/20 7/27/20 7/28/20 7/29/20 7/30/20 7/31/20 8/1/20 8/2/20 8/3/20 8/4/20 8/5/20 8/6/20 8/7/20 8/8/20 8/9/20 8/10/20 8/11/20 8/12/20 8/13/20 8/14/20 8/15/20 8/16/20 8/17/20 8/18/20 8/19/20 8/20/20 8/21/20 8/22/20 8/23/20 8/24/20 8/25/20 8/26/20 8/27/20 8/28/20 8/29/20 8/30/20 8/31/20 9/1/20 9/2/20 9/3/20 9/4/20 9/5/20 9/6/20 9/7/20 9/8/20 9/9/20 9/10/20 9/11/20 9/12/20 9/13/20 9/14/20 9/15/20 9/16/20 9/17/20 9/18/20 9/19/20 9/20/20 9/21/20 9/22/20 9/23/20 9/24/20 9/25/20 9/26/20 9/27/20 9/28/20 9/29/20 9/30/20 10/1/20 10/2/20 10/3/20 10/4/20 10/5/20 10/6/20 10/7/20 10/8/20 10/9/20 10/10/20 10/11/20 10/12/20 10/13/20 10/14/20 10/15/20 10/16/20 10/17/20 10/18/20 10/19/20 10/20/20 10/21/20 10/22/20 10/23/20 10/24/20 10/25/20 10/26/20 10/27/20 10/28/20 10/29/20 10/30/20 10/31/20 11/1/20 11/2/20 11/3/20 11/4/20 11/5/20 11/6/20 11/7/20 11/8/20 11/9/20 11/10/20 11/11/20 11/12/20 11/13/20 11/14/20 11/15/20 11/16/20 11/17/20 11/18/20 11/19/20 11/20/20 11/21/20 11/22/20 11/23/20 11/24/20 11/25/20 11/26/20 11/27/20 11/28/20 11/29/20 11/30/20 12/1/20 12/2/20 12/3/20 12/4/20 12/5/20 12/6/20 12/7/20 12/8/20 12/9/20 12/10/20 12/11/20 12/12/20 12/13/20 12/14/20 12/15/20 12/16/20 12/17/20 12/18/20 12/19/20 12/20/20 12/21/20 12/22/20 12/23/20 12/24/20 12/25/20 12/26/20 12/27/20 12/28/20 12/29/20 12/30/20 12/31/20 1/1/21 1/2/21 1/3/21 1/4/21 1/5/21 1/6/21 1/7/21 1/8/21 1/9/21 1/10/21 1/11/21 1/12/21 1/13/21 1/14/21 1/15/21 1/16/21 1/17/21 1/18/21 1/19/21 1/20/21 1/21/21 1/22/21 1/23/21 1/24/21 1/25/21 1/26/21 1/27/21 1/28/21 1/29/21 1/30/21 1/31/21 2/1/21 2/2/21 2/3/21 2/4/21 2/5/21 2/6/21 2/7/21 2/8/21 2/9/21 2/10/21 2/11/21 2/12/21 2/13/21 2/14/21 2/15/21 2/16/21 2/17/21 2/18/21 2/19/21 2/20/21 2/21/21 2/22/21 2/23/21 2/24/21 2/25/21 2/26/21 2/27/21 2/28/21
196 196   Netherlands 52.1326 5.2913 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 3 3 4 5 5 10 12 20 24 43 58 76 106 136 179 213 276 356 434 546 639 771 864 1039 1173 1339 1487 1651 1766 1867 2101 2248 2396 2511 2643 2737 2823 2945 3134 3315 3459 3601 3684 3751 3916 4054 4177 4289 4409 4475 4518 4566 4711 4795 4893 4987 5056 5082 5168 5204 5288 5359 5422 5440 5456 5510 5562 5590 5643 5670 5680 5694 5715 5748 5775 5788 5811 5822 5830 5856 5871 5903 5931 5951 5956 5962 5967 5977 5990 6005 6011 6013 6016 6031 6042 6044 6053 6057 6059 6065 6070 6074 6078 6081 6089 6090 6090 6095 6097 6100 6103 6105 6105 6107 6113 6115 6118 6120 6126 6127 6128 6132 6135 6137 6136 6137 6137 6137 6135 6136 6137 6138 6136 6136 6136 6136 6139 6139 6139 6140 6159 6141 6145 6147 6147 6147 6148 6149 6149 6150 6153 6153 6154 6157 6157 6157 6141 6161 6165 6167 6169 6172 6172 6175 6181 6191 6195 6200 6200 6202 6207 6215 6218 6220 6224 6224 6224 6230 6235 6235 6237 6241 6243 6243 6244 6246 6249 6252 6253 6254 6256 6258 6260 6266 6273 6275 6279 6281 6291 6296 6312 6328 6366 6374 6380 6393 6406 6419 6428 6449 6454 6454 6482 6518 6531 6544 6567 6584 6596 6631 6663 6692 6708 6737 6751 6768 6814 6873 6919 6964 7019 7046 7072 7142 7202 7258 7345 7395 7434 7463 7576 7682 7769 7887 7960 8004 8043 8141 8215 8304 8358 8443 8486 8530 8616 8698 8771 8822 8870 8891 8945 9035 9109 9184 9267 9326 9349 9376 9438 9504 9565 9623 9662 9687 9704 9775 9841 9902 9966 10019 10048 10082 10168 10246 10321 10405 10459 10491 10519 10633 10737 10826 10924 10970 10998 11042 11212 11324 11432 11529 11565 11612 11675 11826 11999 12084 12171 12307 12361 12411 12563 12685 12774 12868 12965 13006 13056 13162 13248 13337 13422 13510 13540 13579 13665 13733 13816 13872 13959 13998 14025 14108 14169 14234 14294 14355 14403 14428 14511 14590 14662 14727 14793 14816 14843 14929 15017 15089 15138 15200 15217 15249 15343 15406 15438 15503 15543 15563

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [time_series_covid19_deaths_global] (
   [Province/State] TEXT,
   [Country/Region] TEXT,
   [Lat] FLOAT,
   [Long] FLOAT,
   [1/22/20] INTEGER,
   [1/23/20] INTEGER,
   [1/24/20] INTEGER,
   [1/25/20] INTEGER,
   [1/26/20] INTEGER,
   [1/27/20] INTEGER,
   [1/28/20] INTEGER,
   [1/29/20] INTEGER,
   [1/30/20] INTEGER,
   [1/31/20] INTEGER,
   [2/1/20] INTEGER,
   [2/2/20] INTEGER,
   [2/3/20] INTEGER,
   [2/4/20] INTEGER,
   [2/5/20] INTEGER,
   [2/6/20] INTEGER,
   [2/7/20] INTEGER,
   [2/8/20] INTEGER,
   [2/9/20] INTEGER,
   [2/10/20] INTEGER,
   [2/11/20] INTEGER,
   [2/12/20] INTEGER,
   [2/13/20] INTEGER,
   [2/14/20] INTEGER,
   [2/15/20] INTEGER,
   [2/16/20] INTEGER,
   [2/17/20] INTEGER,
   [2/18/20] INTEGER,
   [2/19/20] INTEGER,
   [2/20/20] INTEGER,
   [2/21/20] INTEGER,
   [2/22/20] INTEGER,
   [2/23/20] INTEGER,
   [2/24/20] INTEGER,
   [2/25/20] INTEGER,
   [2/26/20] INTEGER,
   [2/27/20] INTEGER,
   [2/28/20] INTEGER,
   [2/29/20] INTEGER,
   [3/1/20] INTEGER,
   [3/2/20] INTEGER,
   [3/3/20] INTEGER,
   [3/4/20] INTEGER,
   [3/5/20] INTEGER,
   [3/6/20] INTEGER,
   [3/7/20] INTEGER,
   [3/8/20] INTEGER,
   [3/9/20] INTEGER,
   [3/10/20] INTEGER,
   [3/11/20] INTEGER,
   [3/12/20] INTEGER,
   [3/13/20] INTEGER,
   [3/14/20] INTEGER,
   [3/15/20] INTEGER,
   [3/16/20] INTEGER,
   [3/17/20] INTEGER,
   [3/18/20] INTEGER,
   [3/19/20] INTEGER,
   [3/20/20] INTEGER,
   [3/21/20] INTEGER,
   [3/22/20] INTEGER,
   [3/23/20] INTEGER,
   [3/24/20] INTEGER,
   [3/25/20] INTEGER,
   [3/26/20] INTEGER,
   [3/27/20] INTEGER,
   [3/28/20] INTEGER,
   [3/29/20] INTEGER,
   [3/30/20] INTEGER,
   [3/31/20] INTEGER,
   [4/1/20] INTEGER,
   [4/2/20] INTEGER,
   [4/3/20] INTEGER,
   [4/4/20] INTEGER,
   [4/5/20] INTEGER,
   [4/6/20] INTEGER,
   [4/7/20] INTEGER,
   [4/8/20] INTEGER,
   [4/9/20] INTEGER,
   [4/10/20] INTEGER,
   [4/11/20] INTEGER,
   [4/12/20] INTEGER,
   [4/13/20] INTEGER,
   [4/14/20] INTEGER,
   [4/15/20] INTEGER,
   [4/16/20] INTEGER,
   [4/17/20] INTEGER,
   [4/18/20] INTEGER,
   [4/19/20] INTEGER,
   [4/20/20] INTEGER,
   [4/21/20] INTEGER,
   [4/22/20] INTEGER,
   [4/23/20] INTEGER,
   [4/24/20] INTEGER,
   [4/25/20] INTEGER,
   [4/26/20] INTEGER,
   [4/27/20] INTEGER,
   [4/28/20] INTEGER,
   [4/29/20] INTEGER,
   [4/30/20] INTEGER,
   [5/1/20] INTEGER,
   [5/2/20] INTEGER,
   [5/3/20] INTEGER,
   [5/4/20] INTEGER,
   [5/5/20] INTEGER,
   [5/6/20] INTEGER,
   [5/7/20] INTEGER,
   [5/8/20] INTEGER,
   [5/9/20] INTEGER,
   [5/10/20] INTEGER,
   [5/11/20] INTEGER,
   [5/12/20] INTEGER,
   [5/13/20] INTEGER,
   [5/14/20] INTEGER,
   [5/15/20] INTEGER,
   [5/16/20] INTEGER,
   [5/17/20] INTEGER,
   [5/18/20] INTEGER,
   [5/19/20] INTEGER,
   [5/20/20] INTEGER,
   [5/21/20] INTEGER,
   [5/22/20] INTEGER,
   [5/23/20] INTEGER,
   [5/24/20] INTEGER,
   [5/25/20] INTEGER,
   [5/26/20] INTEGER,
   [5/27/20] INTEGER,
   [5/28/20] INTEGER,
   [5/29/20] INTEGER,
   [5/30/20] INTEGER,
   [5/31/20] INTEGER,
   [6/1/20] INTEGER,
   [6/2/20] INTEGER,
   [6/3/20] INTEGER,
   [6/4/20] INTEGER,
   [6/5/20] INTEGER,
   [6/6/20] INTEGER,
   [6/7/20] INTEGER,
   [6/8/20] INTEGER,
   [6/9/20] INTEGER,
   [6/10/20] INTEGER,
   [6/11/20] INTEGER,
   [6/12/20] INTEGER,
   [6/13/20] INTEGER,
   [6/14/20] INTEGER,
   [6/15/20] INTEGER,
   [6/16/20] INTEGER,
   [6/17/20] INTEGER,
   [6/18/20] INTEGER,
   [6/19/20] INTEGER,
   [6/20/20] INTEGER,
   [6/21/20] INTEGER,
   [6/22/20] INTEGER,
   [6/23/20] INTEGER,
   [6/24/20] INTEGER,
   [6/25/20] INTEGER,
   [6/26/20] INTEGER,
   [6/27/20] INTEGER,
   [6/28/20] INTEGER,
   [6/29/20] INTEGER,
   [6/30/20] INTEGER,
   [7/1/20] INTEGER,
   [7/2/20] INTEGER,
   [7/3/20] INTEGER,
   [7/4/20] INTEGER,
   [7/5/20] INTEGER,
   [7/6/20] INTEGER,
   [7/7/20] INTEGER,
   [7/8/20] INTEGER,
   [7/9/20] INTEGER,
   [7/10/20] INTEGER,
   [7/11/20] INTEGER,
   [7/12/20] INTEGER,
   [7/13/20] INTEGER,
   [7/14/20] INTEGER,
   [7/15/20] INTEGER,
   [7/16/20] INTEGER,
   [7/17/20] INTEGER,
   [7/18/20] INTEGER,
   [7/19/20] INTEGER,
   [7/20/20] INTEGER,
   [7/21/20] INTEGER,
   [7/22/20] INTEGER,
   [7/23/20] INTEGER,
   [7/24/20] INTEGER,
   [7/25/20] INTEGER,
   [7/26/20] INTEGER,
   [7/27/20] INTEGER,
   [7/28/20] INTEGER,
   [7/29/20] INTEGER,
   [7/30/20] INTEGER,
   [7/31/20] INTEGER,
   [8/1/20] INTEGER,
   [8/2/20] INTEGER,
   [8/3/20] INTEGER,
   [8/4/20] INTEGER,
   [8/5/20] INTEGER,
   [8/6/20] INTEGER,
   [8/7/20] INTEGER,
   [8/8/20] INTEGER,
   [8/9/20] INTEGER,
   [8/10/20] INTEGER,
   [8/11/20] INTEGER,
   [8/12/20] INTEGER,
   [8/13/20] INTEGER,
   [8/14/20] INTEGER,
   [8/15/20] INTEGER,
   [8/16/20] INTEGER,
   [8/17/20] INTEGER,
   [8/18/20] INTEGER,
   [8/19/20] INTEGER,
   [8/20/20] INTEGER,
   [8/21/20] INTEGER,
   [8/22/20] INTEGER,
   [8/23/20] INTEGER,
   [8/24/20] INTEGER,
   [8/25/20] INTEGER,
   [8/26/20] INTEGER,
   [8/27/20] INTEGER,
   [8/28/20] INTEGER,
   [8/29/20] INTEGER,
   [8/30/20] INTEGER,
   [8/31/20] INTEGER,
   [9/1/20] INTEGER,
   [9/2/20] INTEGER,
   [9/3/20] INTEGER,
   [9/4/20] INTEGER,
   [9/5/20] INTEGER,
   [9/6/20] INTEGER,
   [9/7/20] INTEGER,
   [9/8/20] INTEGER,
   [9/9/20] INTEGER,
   [9/10/20] INTEGER,
   [9/11/20] INTEGER,
   [9/12/20] INTEGER,
   [9/13/20] INTEGER,
   [9/14/20] INTEGER,
   [9/15/20] INTEGER,
   [9/16/20] INTEGER,
   [9/17/20] INTEGER,
   [9/18/20] INTEGER,
   [9/19/20] INTEGER,
   [9/20/20] INTEGER,
   [9/21/20] INTEGER,
   [9/22/20] INTEGER,
   [9/23/20] INTEGER,
   [9/24/20] INTEGER,
   [9/25/20] INTEGER,
   [9/26/20] INTEGER,
   [9/27/20] INTEGER,
   [9/28/20] INTEGER,
   [9/29/20] INTEGER,
   [9/30/20] INTEGER,
   [10/1/20] INTEGER,
   [10/2/20] INTEGER,
   [10/3/20] INTEGER,
   [10/4/20] INTEGER,
   [10/5/20] INTEGER,
   [10/6/20] INTEGER,
   [10/7/20] INTEGER,
   [10/8/20] INTEGER,
   [10/9/20] INTEGER,
   [10/10/20] INTEGER,
   [10/11/20] INTEGER,
   [10/12/20] INTEGER,
   [10/13/20] INTEGER,
   [10/14/20] INTEGER,
   [10/15/20] INTEGER,
   [10/16/20] INTEGER,
   [10/17/20] INTEGER,
   [10/18/20] INTEGER,
   [10/19/20] INTEGER,
   [10/20/20] INTEGER,
   [10/21/20] INTEGER,
   [10/22/20] INTEGER,
   [10/23/20] INTEGER,
   [10/24/20] INTEGER,
   [10/25/20] INTEGER,
   [10/26/20] INTEGER,
   [10/27/20] INTEGER,
   [10/28/20] INTEGER,
   [10/29/20] INTEGER,
   [10/30/20] INTEGER,
   [10/31/20] INTEGER,
   [11/1/20] INTEGER,
   [11/2/20] INTEGER,
   [11/3/20] INTEGER,
   [11/4/20] INTEGER,
   [11/5/20] INTEGER,
   [11/6/20] INTEGER,
   [11/7/20] INTEGER,
   [11/8/20] INTEGER,
   [11/9/20] INTEGER,
   [11/10/20] INTEGER,
   [11/11/20] INTEGER,
   [11/12/20] INTEGER,
   [11/13/20] INTEGER,
   [11/14/20] INTEGER,
   [11/15/20] INTEGER,
   [11/16/20] INTEGER,
   [11/17/20] INTEGER,
   [11/18/20] INTEGER,
   [11/19/20] INTEGER,
   [11/20/20] INTEGER,
   [11/21/20] INTEGER,
   [11/22/20] INTEGER,
   [11/23/20] INTEGER,
   [11/24/20] INTEGER,
   [11/25/20] INTEGER,
   [11/26/20] INTEGER,
   [11/27/20] INTEGER,
   [11/28/20] INTEGER,
   [11/29/20] INTEGER,
   [11/30/20] INTEGER,
   [12/1/20] INTEGER,
   [12/2/20] INTEGER,
   [12/3/20] INTEGER,
   [12/4/20] INTEGER,
   [12/5/20] INTEGER,
   [12/6/20] INTEGER,
   [12/7/20] INTEGER,
   [12/8/20] INTEGER,
   [12/9/20] INTEGER,
   [12/10/20] INTEGER,
   [12/11/20] INTEGER,
   [12/12/20] INTEGER,
   [12/13/20] INTEGER,
   [12/14/20] INTEGER,
   [12/15/20] INTEGER,
   [12/16/20] INTEGER,
   [12/17/20] INTEGER,
   [12/18/20] INTEGER,
   [12/19/20] INTEGER,
   [12/20/20] INTEGER,
   [12/21/20] INTEGER,
   [12/22/20] INTEGER,
   [12/23/20] INTEGER,
   [12/24/20] INTEGER,
   [12/25/20] INTEGER,
   [12/26/20] INTEGER,
   [12/27/20] INTEGER,
   [12/28/20] INTEGER,
   [12/29/20] INTEGER,
   [12/30/20] INTEGER,
   [12/31/20] INTEGER,
   [1/1/21] INTEGER,
   [1/2/21] INTEGER,
   [1/3/21] INTEGER,
   [1/4/21] INTEGER,
   [1/5/21] INTEGER,
   [1/6/21] INTEGER,
   [1/7/21] INTEGER,
   [1/8/21] INTEGER,
   [1/9/21] INTEGER,
   [1/10/21] INTEGER,
   [1/11/21] INTEGER,
   [1/12/21] INTEGER,
   [1/13/21] INTEGER,
   [1/14/21] INTEGER,
   [1/15/21] INTEGER,
   [1/16/21] INTEGER,
   [1/17/21] INTEGER,
   [1/18/21] INTEGER,
   [1/19/21] INTEGER,
   [1/20/21] INTEGER,
   [1/21/21] INTEGER,
   [1/22/21] INTEGER,
   [1/23/21] INTEGER,
   [1/24/21] INTEGER,
   [1/25/21] INTEGER,
   [1/26/21] INTEGER,
   [1/27/21] INTEGER,
   [1/28/21] INTEGER,
   [1/29/21] INTEGER,
   [1/30/21] INTEGER,
   [1/31/21] INTEGER,
   [2/1/21] INTEGER,
   [2/2/21] INTEGER,
   [2/3/21] INTEGER,
   [2/4/21] INTEGER,
   [2/5/21] INTEGER,
   [2/6/21] INTEGER,
   [2/7/21] INTEGER,
   [2/8/21] INTEGER,
   [2/9/21] INTEGER,
   [2/10/21] INTEGER,
   [2/11/21] INTEGER,
   [2/12/21] INTEGER,
   [2/13/21] INTEGER,
   [2/14/21] INTEGER,
   [2/15/21] INTEGER,
   [2/16/21] INTEGER,
   [2/17/21] INTEGER,
   [2/18/21] INTEGER,
   [2/19/21] INTEGER,
   [2/20/21] INTEGER,
   [2/21/21] INTEGER,
   [2/22/21] INTEGER,
   [2/23/21] INTEGER,
   [2/24/21] INTEGER,
   [2/25/21] INTEGER,
   [2/26/21] INTEGER,
   [2/27/21] INTEGER,
   [2/28/21] INTEGER
);