johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
564 rows where confirmed = 1049 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756213 | 2756213 | 2022-12-29 | US | Virginia | Bath | 51017 | 1049 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-30 04:21:04 | Bath, Virginia, US | |
2754666 | 2754666 | 2022-12-29 | US | Minnesota | Red Lake | 27125 | 1049 | 14 | 0 | 47.87197525 | -96.09561104 | 2022-12-30 04:21:04 | Red Lake, Minnesota, US | |
1077219 | 1077219 | 2022-12-28 | US | Virginia | Bath | 51017 | 1049 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-12-29 04:21:01 | Bath, Virginia, US | |
1075672 | 1075672 | 2022-12-28 | US | Minnesota | Red Lake | 27125 | 1049 | 14 | 0 | 47.87197525 | -96.09561104 | 2022-12-29 04:21:01 | Red Lake, Minnesota, US | |
329669 | 329669 | 2022-12-27 | US | Minnesota | Red Lake | 27125 | 1049 | 14 | 0 | 47.87197525 | -96.09561104 | 2022-12-28 04:21:04 | Red Lake, Minnesota, US | |
219742 | 219742 | 2022-12-26 | US | Minnesota | Red Lake | 27125 | 1049 | 14 | 0 | 47.87197525 | -96.09561104 | 2022-12-27 04:21:07 | Red Lake, Minnesota, US | |
3224199 | 3224199 | 2022-12-25 | US | Minnesota | Red Lake | 27125 | 1049 | 14 | 0 | 47.87197525 | -96.09561104 | 2022-12-26 04:21:06 | Red Lake, Minnesota, US | |
1020113 | 1020113 | 2022-12-24 | US | Minnesota | Red Lake | 27125 | 1049 | 14 | 0 | 47.87197525 | -96.09561104 | 2022-12-25 04:21:04 | Red Lake, Minnesota, US | |
692136 | 692136 | 2022-12-23 | US | Minnesota | Red Lake | 27125 | 1049 | 14 | 0 | 47.87197525 | -96.09561104 | 2022-12-24 04:21:02 | Red Lake, Minnesota, US | |
2181346 | 2181346 | 2022-12-22 | US | Minnesota | Red Lake | 27125 | 1049 | 14 | 0 | 47.87197525 | -96.09561104 | 2022-12-23 04:21:04 | Red Lake, Minnesota, US | |
719904 | 719904 | 2022-12-04 | US | Kentucky | Hickman | 21105 | 1049 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-05 04:20:58 | Hickman, Kentucky, US | |
2818193 | 2818193 | 2022-12-03 | US | Kentucky | Hickman | 21105 | 1049 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-04 04:20:56 | Hickman, Kentucky, US | |
835049 | 835049 | 2022-12-02 | US | Kentucky | Hickman | 21105 | 1049 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-03 04:21:02 | Hickman, Kentucky, US | |
2137579 | 2137579 | 2022-12-01 | US | Kentucky | Hickman | 21105 | 1049 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-02 04:21:07 | Hickman, Kentucky, US | |
1965995 | 1965995 | 2022-11-30 | US | Kentucky | Hickman | 21105 | 1049 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-12-01 04:21:03 | Hickman, Kentucky, US | |
2558009 | 2558009 | 2022-11-29 | US | Kentucky | Hickman | 21105 | 1049 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-11-30 04:21:07 | Hickman, Kentucky, US | |
1241083 | 1241083 | 2022-11-28 | US | Kentucky | Hickman | 21105 | 1049 | 31 | 0 | 36.6794808 | -88.97875928 | 2022-11-29 04:21:05 | Hickman, Kentucky, US | |
2488246 | 2488246 | 2022-11-16 | US | New York | Hamilton | 36041 | 1049 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-11-17 04:21:11 | Hamilton, New York, US | |
132052 | 132052 | 2022-10-04 | US | Kansas | Haskell | 20081 | 1049 | 13 | 0 | 37.5620394 | -100.8710738 | 2022-10-05 04:23:06 | Haskell, Kansas, US | |
2686999 | 2686999 | 2022-10-03 | US | Kansas | Haskell | 20081 | 1049 | 13 | 0 | 37.5620394 | -100.8710738 | 2022-10-04 04:22:55 | Haskell, Kansas, US | |
2685481 | 2685481 | 2022-10-03 | China | Chongqing | 1049 | 6 | 0 | 30.0572 | 107.874 | 2022-10-04 04:22:55 | Chongqing, China | |||
2261066 | 2261066 | 2022-10-02 | US | Kansas | Haskell | 20081 | 1049 | 13 | 0 | 37.5620394 | -100.8710738 | 2022-10-03 04:23:11 | Haskell, Kansas, US | |
2996592 | 2996592 | 2022-10-01 | US | Kansas | Haskell | 20081 | 1049 | 13 | 0 | 37.5620394 | -100.8710738 | 2022-10-02 04:21:23 | Haskell, Kansas, US | |
854918 | 854918 | 2022-09-30 | US | Kansas | Haskell | 20081 | 1049 | 13 | 0 | 37.5620394 | -100.8710738 | 2022-10-01 04:23:01 | Haskell, Kansas, US | |
2376844 | 2376844 | 2022-09-29 | US | Kansas | Haskell | 20081 | 1049 | 13 | 0 | 37.5620394 | -100.8710738 | 2022-09-30 04:23:09 | Haskell, Kansas, US | |
1561395 | 1561395 | 2022-09-28 | US | Kansas | Haskell | 20081 | 1049 | 13 | 0 | 37.5620394 | -100.8710738 | 2022-09-29 04:22:34 | Haskell, Kansas, US | |
1560741 | 1560741 | 2022-09-28 | US | Colorado | Ouray | 8091 | 1049 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-09-29 04:22:34 | Ouray, Colorado, US | |
2020033 | 2020033 | 2022-09-20 | US | Virginia | Bath | 51017 | 1049 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-21 04:23:22 | Bath, Virginia, US | |
3573906 | 3573906 | 2022-09-19 | US | Virginia | Bath | 51017 | 1049 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-20 04:22:48 | Bath, Virginia, US | |
422645 | 422645 | 2022-09-18 | US | Virginia | Bath | 51017 | 1049 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-19 04:21:49 | Bath, Virginia, US | |
3376669 | 3376669 | 2022-09-17 | US | Virginia | Bath | 51017 | 1049 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-18 04:22:50 | Bath, Virginia, US | |
2358777 | 2358777 | 2022-09-16 | US | Virginia | Bath | 51017 | 1049 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-17 04:20:19 | Bath, Virginia, US | |
3989934 | 3989934 | 2022-09-15 | US | Virginia | Bath | 51017 | 1049 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-09-16 04:21:19 | Bath, Virginia, US | |
3908681 | 3908681 | 2022-08-11 | US | Delaware | Unassigned | 90010 | 1049 | 0 | 0 | 39.57992638 | 0.0 | 2022-08-12 04:20:54 | Unassigned, Delaware, US | |
3545892 | 3545892 | 2022-08-08 | US | North Dakota | Foster | 38031 | 1049 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-08-09 04:20:34 | Foster, North Dakota, US | |
1069684 | 1069684 | 2022-08-07 | China | Hainan | 1049 | 6 | 0 | 19.1959 | 109.7453 | 2022-08-08 04:21:08 | Hainan, China | |||
3213483 | 3213483 | 2022-07-18 | US | Texas | Presidio | 48377 | 1049 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-07-19 04:20:58 | Presidio, Texas, US | |
3111027 | 3111027 | 2022-07-13 | US | Louisiana | Tensas | 22107 | 1049 | 12 | 0 | 32.00760749 | -91.32915234 | 2022-07-14 04:20:57 | Tensas, Louisiana, US | |
167722 | 167722 | 2022-06-21 | US | Michigan | Ontonagon | 26131 | 1049 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-06-22 04:20:54 | Ontonagon, Michigan, US | |
1765005 | 1765005 | 2022-06-20 | US | Michigan | Ontonagon | 26131 | 1049 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-06-21 04:20:56 | Ontonagon, Michigan, US | |
3271191 | 3271191 | 2022-06-19 | US | Michigan | Ontonagon | 26131 | 1049 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-06-20 04:21:01 | Ontonagon, Michigan, US | |
3399103 | 3399103 | 2022-06-18 | US | Michigan | Ontonagon | 26131 | 1049 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-06-19 04:20:51 | Ontonagon, Michigan, US | |
2312980 | 2312980 | 2022-06-17 | US | Michigan | Ontonagon | 26131 | 1049 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-06-18 04:21:10 | Ontonagon, Michigan, US | |
560484 | 560484 | 2022-06-16 | US | Michigan | Ontonagon | 26131 | 1049 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-06-17 04:20:56 | Ontonagon, Michigan, US | |
3984286 | 3984286 | 2022-06-15 | US | Michigan | Ontonagon | 26131 | 1049 | 40 | 0 | 46.6652262 | -89.31390481 | 2022-06-16 04:20:55 | Ontonagon, Michigan, US | |
1947288 | 1947288 | 2022-06-10 | US | Puerto Rico | Vieques | 72147 | 1049 | 0 | 0 | 18.123276 | -65.440971 | 2022-06-11 04:21:01 | Vieques, Puerto Rico, US | |
230489 | 230489 | 2022-05-31 | US | Kansas | Barber | 20007 | 1049 | 9 | 0 | 37.2288586 | -98.68460053 | 2022-06-01 04:20:55 | Barber, Kansas, US | |
3187254 | 3187254 | 2022-05-30 | US | Kansas | Barber | 20007 | 1049 | 9 | 0 | 37.2288586 | -98.68460053 | 2022-05-31 04:20:51 | Barber, Kansas, US | |
3199403 | 3199403 | 2022-05-29 | US | Kansas | Barber | 20007 | 1049 | 9 | 0 | 37.2288586 | -98.68460053 | 2022-05-30 04:20:50 | Barber, Kansas, US | |
2727445 | 2727445 | 2022-05-28 | US | North Dakota | Sargent | 38081 | 1049 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-05-29 04:20:53 | Sargent, North Dakota, US | |
2727417 | 2727417 | 2022-05-28 | US | North Dakota | Dunn | 38025 | 1049 | 8 | 0 | 47.35423935 | -102.6160468 | 2022-05-29 04:20:53 | Dunn, North Dakota, US | |
2726281 | 2726281 | 2022-05-28 | US | Kansas | Barber | 20007 | 1049 | 9 | 0 | 37.2288586 | -98.68460053 | 2022-05-29 04:20:53 | Barber, Kansas, US | |
1316626 | 1316626 | 2022-05-27 | US | North Dakota | Sargent | 38081 | 1049 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-05-28 04:21:07 | Sargent, North Dakota, US | |
1315462 | 1315462 | 2022-05-27 | US | Kansas | Barber | 20007 | 1049 | 9 | 0 | 37.2288586 | -98.68460053 | 2022-05-28 04:21:07 | Barber, Kansas, US | |
1851254 | 1851254 | 2022-05-26 | US | Kansas | Barber | 20007 | 1049 | 9 | 0 | 37.2288586 | -98.68460053 | 2022-05-27 04:20:56 | Barber, Kansas, US | |
2049130 | 2049130 | 2022-05-25 | US | Kansas | Barber | 20007 | 1049 | 9 | 0 | 37.2288586 | -98.68460053 | 2022-05-26 04:20:50 | Barber, Kansas, US | |
623141 | 623141 | 2022-05-22 | US | Kansas | Barber | 20007 | 1049 | 9 | 0 | 37.2288586 | -98.68460053 | 2022-05-26 04:20:50 | Barber, Kansas, US | |
1226885 | 1226885 | 2022-04-14 | US | Vermont | Grand Isle | 50013 | 1049 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-04-15 04:20:57 | Grand Isle, Vermont, US | |
2751589 | 2751589 | 2022-04-04 | US | Pennsylvania | Sullivan | 42113 | 1049 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-04-05 04:20:48 | Sullivan, Pennsylvania, US | |
3732935 | 3732935 | 2022-04-03 | US | Pennsylvania | Sullivan | 42113 | 1049 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-04-04 04:20:51 | Sullivan, Pennsylvania, US | |
502370 | 502370 | 2022-04-02 | US | Pennsylvania | Sullivan | 42113 | 1049 | 36 | 0 | 41.44634738 | -76.51246591 | 2022-04-03 04:20:48 | Sullivan, Pennsylvania, US | |
3023270 | 3023270 | 2022-03-23 | US | Illinois | Hardin | 17069 | 1049 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-03-24 04:20:43 | Hardin, Illinois, US | |
1906192 | 1906192 | 2022-03-22 | US | Illinois | Hardin | 17069 | 1049 | 20 | 0 | 37.51810645 | -88.26873022 | 2022-03-23 04:20:48 | Hardin, Illinois, US | |
3239323 | 3239323 | 2022-03-21 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-22 04:20:54 | Hardin, Illinois, US | |
25396 | 25396 | 2022-03-20 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-21 04:20:50 | Hardin, Illinois, US | |
1657406 | 1657406 | 2022-03-19 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-20 04:20:45 | Hardin, Illinois, US | |
336932 | 336932 | 2022-03-18 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-19 04:20:47 | Hardin, Illinois, US | |
695385 | 695385 | 2022-03-17 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-18 04:20:55 | Hardin, Illinois, US | |
2320328 | 2320328 | 2022-03-16 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-17 04:20:56 | Hardin, Illinois, US | |
262528 | 262528 | 2022-03-15 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-16 04:20:50 | Hardin, Illinois, US | |
2264887 | 2264887 | 2022-03-14 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-15 04:20:47 | Hardin, Illinois, US | |
3628953 | 3628953 | 2022-03-13 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-14 04:20:46 | Hardin, Illinois, US | |
951861 | 951861 | 2022-03-12 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-13 04:20:49 | Hardin, Illinois, US | |
357322 | 357322 | 2022-03-11 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-12 04:20:50 | Hardin, Illinois, US | |
1866474 | 1866474 | 2022-03-10 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-11 04:20:50 | Hardin, Illinois, US | |
2141169 | 2141169 | 2022-03-09 | US | Illinois | Hardin | 17069 | 1049 | 19 | 0 | 37.51810645 | -88.26873022 | 2022-03-10 04:20:48 | Hardin, Illinois, US | |
1513455 | 1513455 | 2022-02-24 | US | Nebraska | Boone | 31011 | 1049 | 4 | 0 | 41.70759415 | -98.06737183 | 2022-02-25 04:21:11 | Boone, Nebraska, US | |
1060882 | 1060882 | 2022-02-23 | US | Texas | Brewster | 48043 | 1049 | 26 | 0 | 29.81008251 | -103.25203259999999 | 2022-02-24 04:21:14 | Brewster, Texas, US | |
3912917 | 3912917 | 2022-02-20 | US | Georgia | Warren | 13301 | 1049 | 28 | 0 | 33.41146451 | -82.67795848 | 2022-02-21 04:21:05 | Warren, Georgia, US | |
3876475 | 3876475 | 2022-02-19 | US | Georgia | Warren | 13301 | 1049 | 28 | 0 | 33.41146451 | -82.67795848 | 2022-02-20 04:21:00 | Warren, Georgia, US | |
3856731 | 3856731 | 2022-02-18 | US | Georgia | Warren | 13301 | 1049 | 28 | 0 | 33.41146451 | -82.67795848 | 2022-02-19 04:21:11 | Warren, Georgia, US | |
3822637 | 3822637 | 2022-02-16 | US | New Mexico | Hidalgo | 35023 | 1049 | 13 | 0 | 31.91383467 | -108.7151824 | 2022-02-17 04:20:56 | Hidalgo, New Mexico, US | |
3674514 | 3674514 | 2022-02-15 | US | South Dakota | Corson | 46031 | 1049 | 16 | 0 | 45.70889983 | -101.1970473 | 2022-02-16 04:21:10 | Corson, South Dakota, US | |
188943 | 188943 | 2022-02-13 | US | South Dakota | Gregory | 46053 | 1049 | 33 | 0 | 43.19419064 | -99.18883902 | 2022-02-14 04:20:51 | Gregory, South Dakota, US | |
188267 | 188267 | 2022-02-13 | US | New Mexico | Guadalupe | 35019 | 1049 | 16 | 0 | 34.86319296 | -104.790669 | 2022-02-14 04:20:51 | Guadalupe, New Mexico, US | |
318789 | 318789 | 2022-02-12 | US | South Dakota | Gregory | 46053 | 1049 | 33 | 0 | 43.19419064 | -99.18883902 | 2022-02-13 04:21:00 | Gregory, South Dakota, US | |
318113 | 318113 | 2022-02-12 | US | New Mexico | Guadalupe | 35019 | 1049 | 16 | 0 | 34.86319296 | -104.790669 | 2022-02-13 04:21:00 | Guadalupe, New Mexico, US | |
236115 | 236115 | 2022-02-11 | US | South Dakota | Gregory | 46053 | 1049 | 33 | 0 | 43.19419064 | -99.18883902 | 2022-02-12 04:21:06 | Gregory, South Dakota, US | |
235439 | 235439 | 2022-02-11 | US | New Mexico | Guadalupe | 35019 | 1049 | 16 | 0 | 34.86319296 | -104.790669 | 2022-02-12 04:21:06 | Guadalupe, New Mexico, US | |
3076171 | 3076171 | 2022-02-09 | US | Nebraska | Thayer | 31169 | 1049 | 4 | 0 | 40.17626377 | -97.59504381 | 2022-02-10 04:21:14 | Thayer, Nebraska, US | |
3074707 | 3074707 | 2022-02-09 | US | Colorado | Washington | 8121 | 1049 | 28 | 0 | 39.97015535 | -103.202587 | 2022-02-10 04:21:14 | Washington, Colorado, US | |
74507 | 74507 | 2022-02-07 | US | Virginia | Surry | 51181 | 1049 | 16 | 0 | 37.11781893 | -76.88450012 | 2022-02-08 04:21:15 | Surry, Virginia, US | |
3065283 | 3065283 | 2022-01-29 | US | Vermont | Essex | 50009 | 1049 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-01-30 04:21:26 | Essex, Vermont, US | |
2053949 | 2053949 | 2022-01-25 | US | Nebraska | Dixon | 31051 | 1049 | 9 | 0 | 42.49188363 | -96.86782408 | 2022-01-26 04:21:07 | Dixon, Nebraska, US | |
3425603 | 3425603 | 2022-01-21 | US | Colorado | Saguache | 8109 | 1049 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-01-22 04:21:13 | Saguache, Colorado, US | |
1474847 | 1474847 | 2022-01-17 | US | Puerto Rico | Ceiba | 72037 | 1049 | 0 | 0 | 18.251818 | -65.666416 | 2022-01-18 04:21:04 | Ceiba, Puerto Rico, US | |
1473985 | 1473985 | 2022-01-17 | US | Missouri | Atchison | 29005 | 1049 | 19 | 0 | 40.43238737 | -95.42970639 | 2022-01-18 04:21:04 | Atchison, Missouri, US | |
556659 | 556659 | 2022-01-16 | US | Missouri | Atchison | 29005 | 1049 | 19 | 0 | 40.43238737 | -95.42970639 | 2022-01-17 04:21:08 | Atchison, Missouri, US | |
3842380 | 3842380 | 2022-01-15 | US | Missouri | Atchison | 29005 | 1049 | 19 | 0 | 40.43238737 | -95.42970639 | 2022-01-16 04:21:12 | Atchison, Missouri, US | |
3690697 | 3690697 | 2022-01-13 | US | Texas | San Saba | 48411 | 1049 | 29 | 0 | 31.1577796 | -98.81758731 | 2022-01-14 04:21:54 | San Saba, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);