daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
46 rows where confirmed = 13837 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-27 | US | Louisiana | Avoyelles | 22009 | 13837 | 216 | 0 | 31.07796211 | -92.00079449 | 2022-12-28 04:21:04 | Avoyelles, Louisiana, US | |
2022-12-26 | US | Louisiana | Avoyelles | 22009 | 13837 | 216 | 0 | 31.07796211 | -92.00079449 | 2022-12-27 04:21:07 | Avoyelles, Louisiana, US | |
2022-12-25 | US | Louisiana | Avoyelles | 22009 | 13837 | 216 | 0 | 31.07796211 | -92.00079449 | 2022-12-26 04:21:06 | Avoyelles, Louisiana, US | |
2022-12-24 | US | Louisiana | Avoyelles | 22009 | 13837 | 216 | 0 | 31.07796211 | -92.00079449 | 2022-12-25 04:21:04 | Avoyelles, Louisiana, US | |
2022-12-23 | US | Louisiana | Avoyelles | 22009 | 13837 | 216 | 0 | 31.07796211 | -92.00079449 | 2022-12-24 04:21:02 | Avoyelles, Louisiana, US | |
2022-12-22 | US | Louisiana | Avoyelles | 22009 | 13837 | 216 | 0 | 31.07796211 | -92.00079449 | 2022-12-23 04:21:04 | Avoyelles, Louisiana, US | |
2022-12-21 | US | Louisiana | Avoyelles | 22009 | 13837 | 216 | 0 | 31.07796211 | -92.00079449 | 2022-12-22 04:20:56 | Avoyelles, Louisiana, US | |
2022-11-29 | US | North Carolina | Davie | 37059 | 13837 | 119 | 0 | 35.93099927 | -80.54496571 | 2022-11-30 04:21:07 | Davie, North Carolina, US | |
2022-11-28 | US | North Carolina | Davie | 37059 | 13837 | 119 | 0 | 35.93099927 | -80.54496571 | 2022-11-29 04:21:05 | Davie, North Carolina, US | |
2022-11-27 | US | North Carolina | Davie | 37059 | 13837 | 119 | 0 | 35.93099927 | -80.54496571 | 2022-11-28 04:21:02 | Davie, North Carolina, US | |
2022-11-26 | US | North Carolina | Davie | 37059 | 13837 | 119 | 0 | 35.93099927 | -80.54496571 | 2022-11-27 04:21:05 | Davie, North Carolina, US | |
2022-11-25 | US | North Carolina | Davie | 37059 | 13837 | 119 | 0 | 35.93099927 | -80.54496571 | 2022-11-26 04:21:11 | Davie, North Carolina, US | |
2022-11-24 | US | North Carolina | Davie | 37059 | 13837 | 119 | 0 | 35.93099927 | -80.54496571 | 2022-11-25 04:21:06 | Davie, North Carolina, US | |
2022-11-23 | US | North Carolina | Davie | 37059 | 13837 | 119 | 0 | 35.93099927 | -80.54496571 | 2022-11-24 04:21:09 | Davie, North Carolina, US | |
2022-11-01 | US | Maryland | Calvert | 24009 | 13837 | 157 | 0 | 38.53961642 | -76.56820632 | 2022-11-02 04:22:09 | Calvert, Maryland, US | |
2022-07-18 | US | Texas | Hood | 48221 | 13837 | 278 | 0 | 32.42990927 | -97.83242024 | 2022-07-19 04:20:58 | Hood, Texas, US | |
2022-06-28 | US | Georgia | Effingham | 13103 | 13837 | 197 | 0 | 32.36616021 | -81.34280942 | 2022-06-29 04:20:59 | Effingham, Georgia, US | |
2022-06-27 | US | Georgia | Effingham | 13103 | 13837 | 197 | 0 | 32.36616021 | -81.34280942 | 2022-06-28 04:20:58 | Effingham, Georgia, US | |
2022-06-26 | US | Georgia | Effingham | 13103 | 13837 | 197 | 0 | 32.36616021 | -81.34280942 | 2022-06-27 04:21:00 | Effingham, Georgia, US | |
2022-06-25 | US | Georgia | Effingham | 13103 | 13837 | 197 | 0 | 32.36616021 | -81.34280942 | 2022-06-26 04:21:02 | Effingham, Georgia, US | |
2022-06-24 | US | Georgia | Effingham | 13103 | 13837 | 197 | 0 | 32.36616021 | -81.34280942 | 2022-06-25 04:20:57 | Effingham, Georgia, US | |
2022-06-23 | US | Georgia | Effingham | 13103 | 13837 | 197 | 0 | 32.36616021 | -81.34280942 | 2022-06-24 04:20:58 | Effingham, Georgia, US | |
2022-06-22 | US | Georgia | Effingham | 13103 | 13837 | 197 | 0 | 32.36616021 | -81.34280942 | 2022-06-23 04:20:55 | Effingham, Georgia, US | |
2022-06-12 | US | Virginia | Harrisonburg | 51660 | 13837 | 162 | 0 | 38.43542574 | -78.87536254 | 2022-06-13 04:21:14 | Harrisonburg, Virginia, US | |
2022-06-11 | US | Virginia | Harrisonburg | 51660 | 13837 | 162 | 0 | 38.43542574 | -78.87536254 | 2022-06-12 04:20:53 | Harrisonburg, Virginia, US | |
2022-06-10 | US | Virginia | Harrisonburg | 51660 | 13837 | 162 | 0 | 38.43542574 | -78.87536254 | 2022-06-11 04:21:01 | Harrisonburg, Virginia, US | |
2022-02-22 | US | Colorado | Broomfield | 8014 | 13837 | 117 | 0 | 39.95998787 | -105.0566324 | 2022-02-23 04:21:09 | Broomfield, Colorado, US | |
2022-01-28 | US | Alabama | Blount | 1009 | 13837 | 207 | 0 | 33.98210918 | -86.56790593 | 2022-01-29 04:21:10 | Blount, Alabama, US | |
2022-01-05 | US | Ohio | Ross | 39141 | 13837 | 264 | 0 | 39.33705391 | -83.06000914 | 2022-01-06 04:22:09 | Ross, Ohio, US | |
2021-11-07 | US | Michigan | Lenawee | 26091 | 13837 | 201 | 0 | 41.89475156 | -84.06603727 | 2021-11-08 04:21:43 | Lenawee, Michigan, US | |
2021-11-06 | US | Michigan | Lenawee | 26091 | 13837 | 201 | 0 | 41.89475156 | -84.06603727 | 2021-11-07 04:21:53 | Lenawee, Michigan, US | |
2021-11-05 | US | Michigan | Lenawee | 26091 | 13837 | 201 | 0 | 41.89475156 | -84.06603727 | 2021-11-06 04:21:51 | Lenawee, Michigan, US | |
2021-10-12 | US | Michigan | Bay | 26017 | 13837 | 376 | 0 | 43.70639106 | -83.98731479 | 2021-10-13 04:20:51 | Bay, Michigan, US | |
2021-10-11 | US | Michigan | Bay | 26017 | 13837 | 376 | 0 | 43.70639106 | -83.98731479 | 2021-10-12 04:21:09 | Bay, Michigan, US | |
2021-06-30 | US | Mississippi | Jackson | 28059 | 13837 | 250 | 0 | 30.54020656 | -88.64184064 | 2021-07-01 04:21:19 | Jackson, Mississippi, US | |
2021-06-10 | US | Mississippi | Rankin | 28121 | 13837 | 282 | 0 | 32.26469147 | -89.94537876 | 2021-06-11 04:23:20 | Rankin, Mississippi, US | |
2021-06-01 | US | South Dakota | Pennington | 46103 | 13837 | 200 | 0 | 44.0025835 | -102.8240777 | 2021-06-02 04:24:34 | Pennington, South Dakota, US | |
2021-05-31 | US | South Dakota | Pennington | 46103 | 13837 | 200 | 0 | 44.0025835 | -102.8240777 | 2021-06-01 04:23:09 | Pennington, South Dakota, US | |
2021-03-31 | US | California | Marin | 6041 | 13837 | 221 | 0 | 38.07122463 | -122.7210631 | 2021-04-01 04:27:05 | Marin, California, US | |
2021-01-21 | US | Texas | Potter | 48375 | 13837 | 347 | 0 | 15823 | 35.40133773 | -101.893964 | 2021-01-22 05:22:10 | Potter, Texas, US |
2020-10-01 | Ukraine | Ivano-Frankivsk Oblast | 13837 | 318 | 6536 | 6983 | 48.9226 | 24.7111 | 2020-10-02 04:23:51 | Ivano-Frankivsk Oblast, Ukraine | ||
2020-09-16 | US | Utah | Utah | 49049 | 13837 | 53 | 0 | 13784 | 40.1166722 | -111.6657662 | 2020-09-17 04:22:00 | Utah, Utah, US |
2020-09-15 | Colombia | Norte de Santander | 13837 | 800 | 11296 | 1741 | 7.9463 | -72.8988 | 2020-09-16 04:22:53 | Norte de Santander, Colombia | ||
2020-07-25 | US | New York | Rockland | 36087 | 13837 | 507 | 0 | 13330 | 41.15027894 | -74.02560498 | 2020-07-26 04:35:00 | Rockland, New York, US |
2020-06-01 | Panama | 13837 | 344 | 9514 | 3979 | 8.538 | -80.7821 | 2020-06-02 02:33:08 | Panama | |||
2020-05-05 | Romania | 13837 | 841 | 5454 | 7542 | 45.9432 | 24.9668 | 2020-05-06 02:32:31 | Romania |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;