johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
298 rows where confirmed = 2491 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221491 | 221491 | 2022-12-26 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-27 04:21:07 | Pocahontas, West Virginia, US | |
3225948 | 3225948 | 2022-12-25 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-26 04:21:06 | Pocahontas, West Virginia, US | |
1021862 | 1021862 | 2022-12-24 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-25 04:21:04 | Pocahontas, West Virginia, US | |
693885 | 693885 | 2022-12-23 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-24 04:21:02 | Pocahontas, West Virginia, US | |
2183095 | 2183095 | 2022-12-22 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-23 04:21:04 | Pocahontas, West Virginia, US | |
1621550 | 1621550 | 2022-11-22 | US | Kansas | Cloud | 20029 | 2491 | 47 | 0 | 39.48028352 | -97.64925343 | 2022-11-23 04:21:06 | Cloud, Kansas, US | |
3461438 | 3461438 | 2022-11-21 | US | Kansas | Cloud | 20029 | 2491 | 47 | 0 | 39.48028352 | -97.64925343 | 2022-11-22 04:20:47 | Cloud, Kansas, US | |
1641623 | 1641623 | 2022-11-20 | US | Kansas | Cloud | 20029 | 2491 | 47 | 0 | 39.48028352 | -97.64925343 | 2022-11-21 04:21:05 | Cloud, Kansas, US | |
2065180 | 2065180 | 2022-11-19 | US | Kansas | Cloud | 20029 | 2491 | 47 | 0 | 39.48028352 | -97.64925343 | 2022-11-20 04:21:08 | Cloud, Kansas, US | |
1756574 | 1756574 | 2022-11-18 | US | Kansas | Cloud | 20029 | 2491 | 47 | 0 | 39.48028352 | -97.64925343 | 2022-11-19 04:21:14 | Cloud, Kansas, US | |
3027567 | 3027567 | 2022-11-17 | US | Kansas | Cloud | 20029 | 2491 | 47 | 0 | 39.48028352 | -97.64925343 | 2022-11-18 04:21:15 | Cloud, Kansas, US | |
2487278 | 2487278 | 2022-11-16 | US | Kansas | Cloud | 20029 | 2491 | 47 | 0 | 39.48028352 | -97.64925343 | 2022-11-17 04:21:11 | Cloud, Kansas, US | |
315385 | 315385 | 2022-11-13 | US | West Virginia | Gilmer | 54021 | 2491 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-11-14 04:21:09 | Gilmer, West Virginia, US | |
66546 | 66546 | 2022-11-12 | US | West Virginia | Gilmer | 54021 | 2491 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-11-13 04:21:14 | Gilmer, West Virginia, US | |
2930708 | 2930708 | 2022-11-11 | US | West Virginia | Gilmer | 54021 | 2491 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-11-12 04:20:41 | Gilmer, West Virginia, US | |
2509544 | 2509544 | 2022-11-10 | US | West Virginia | Gilmer | 54021 | 2491 | 22 | 0 | 38.9251277 | -80.85952723 | 2022-11-11 04:21:22 | Gilmer, West Virginia, US | |
2162291 | 2162291 | 2022-10-16 | US | Puerto Rico | Las Marias | 72083 | 2491 | 0 | 0 | 18.23679 | -66.98362 | 2022-10-17 04:20:31 | Las Marias, Puerto Rico, US | |
3097241 | 3097241 | 2022-10-09 | China | Jiangsu | 2491 | 0 | 0 | 32.9711 | 119.455 | 2022-10-10 04:22:32 | Jiangsu, China | |||
422723 | 422723 | 2022-09-18 | US | Virginia | Northumberland | 51133 | 2491 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-09-19 04:21:49 | Northumberland, Virginia, US | |
3376747 | 3376747 | 2022-09-17 | US | Virginia | Northumberland | 51133 | 2491 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-09-18 04:22:50 | Northumberland, Virginia, US | |
2358855 | 2358855 | 2022-09-16 | US | Virginia | Northumberland | 51133 | 2491 | 43 | 0 | 37.89202088 | -76.41949732 | 2022-09-17 04:20:19 | Northumberland, Virginia, US | |
373064 | 373064 | 2022-09-13 | US | Georgia | Pulaski | 13235 | 2491 | 81 | 0 | 32.23334561 | -83.4754996 | 2022-09-14 04:20:44 | Pulaski, Georgia, US | |
2395666 | 2395666 | 2022-09-12 | US | Georgia | Pulaski | 13235 | 2491 | 81 | 0 | 32.23334561 | -83.4754996 | 2022-09-13 04:20:57 | Pulaski, Georgia, US | |
3766744 | 3766744 | 2022-09-11 | US | Georgia | Pulaski | 13235 | 2491 | 81 | 0 | 32.23334561 | -83.4754996 | 2022-09-12 04:20:58 | Pulaski, Georgia, US | |
3825319 | 3825319 | 2022-09-10 | US | Georgia | Pulaski | 13235 | 2491 | 81 | 0 | 32.23334561 | -83.4754996 | 2022-09-11 04:20:50 | Pulaski, Georgia, US | |
963776 | 963776 | 2022-09-09 | US | Georgia | Pulaski | 13235 | 2491 | 81 | 0 | 32.23334561 | -83.4754996 | 2022-09-10 04:21:10 | Pulaski, Georgia, US | |
254178 | 254178 | 2022-09-08 | US | Georgia | Pulaski | 13235 | 2491 | 81 | 0 | 32.23334561 | -83.4754996 | 2022-09-09 04:21:11 | Pulaski, Georgia, US | |
3745976 | 3745976 | 2022-09-07 | US | Georgia | Pulaski | 13235 | 2491 | 81 | 0 | 32.23334561 | -83.4754996 | 2022-09-08 04:21:02 | Pulaski, Georgia, US | |
115658 | 115658 | 2022-09-06 | US | Georgia | Wilkes | 13317 | 2491 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-09-07 04:20:59 | Wilkes, Georgia, US | |
2634630 | 2634630 | 2022-09-05 | US | Georgia | Wilkes | 13317 | 2491 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-09-06 04:21:02 | Wilkes, Georgia, US | |
2988194 | 2988194 | 2022-09-04 | US | Georgia | Wilkes | 13317 | 2491 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-09-05 04:21:01 | Wilkes, Georgia, US | |
2713879 | 2713879 | 2022-09-03 | US | Georgia | Wilkes | 13317 | 2491 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-09-04 04:21:22 | Wilkes, Georgia, US | |
1394584 | 1394584 | 2022-09-02 | US | Georgia | Wilkes | 13317 | 2491 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-09-03 04:21:04 | Wilkes, Georgia, US | |
3548413 | 3548413 | 2022-09-01 | US | Georgia | Wilkes | 13317 | 2491 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-09-02 04:21:07 | Wilkes, Georgia, US | |
2344333 | 2344333 | 2022-08-31 | US | Georgia | Wilkes | 13317 | 2491 | 56 | 0 | 33.78290391 | -82.74286107 | 2022-09-01 04:21:03 | Wilkes, Georgia, US | |
2343902 | 2343902 | 2022-08-31 | US | Arkansas | Cleveland | 5025 | 2491 | 39 | 0 | 33.89723187 | -92.18537045 | 2022-09-01 04:21:03 | Cleveland, Arkansas, US | |
3775097 | 3775097 | 2022-08-30 | US | Iowa | Emmet | 19063 | 2491 | 54 | 0 | 43.37782951 | -94.67858943 | 2022-08-31 04:20:57 | Emmet, Iowa, US | |
1681693 | 1681693 | 2022-08-29 | US | Iowa | Emmet | 19063 | 2491 | 54 | 0 | 43.37782951 | -94.67858943 | 2022-08-30 04:21:03 | Emmet, Iowa, US | |
1878177 | 1878177 | 2022-08-28 | US | Iowa | Emmet | 19063 | 2491 | 54 | 0 | 43.37782951 | -94.67858943 | 2022-08-29 04:21:06 | Emmet, Iowa, US | |
2097304 | 2097304 | 2022-08-27 | US | Iowa | Emmet | 19063 | 2491 | 54 | 0 | 43.37782951 | -94.67858943 | 2022-08-28 04:21:02 | Emmet, Iowa, US | |
1533119 | 1533119 | 2022-08-26 | US | Iowa | Emmet | 19063 | 2491 | 54 | 0 | 43.37782951 | -94.67858943 | 2022-08-27 04:20:57 | Emmet, Iowa, US | |
2830006 | 2830006 | 2022-08-25 | US | Iowa | Emmet | 19063 | 2491 | 54 | 0 | 43.37782951 | -94.67858943 | 2022-08-26 04:21:02 | Emmet, Iowa, US | |
2326277 | 2326277 | 2022-08-24 | US | Tennessee | Clay | 47027 | 2491 | 52 | 0 | 36.55151008 | -85.53930419 | 2022-08-25 04:21:13 | Clay, Tennessee, US | |
2324539 | 2324539 | 2022-08-24 | US | Iowa | Emmet | 19063 | 2491 | 54 | 0 | 43.37782951 | -94.67858943 | 2022-08-25 04:21:13 | Emmet, Iowa, US | |
1089226 | 1089226 | 2022-08-09 | US | Texas | La Salle | 48283 | 2491 | 49 | 0 | 28.34453111 | -99.09908775 | 2022-08-10 04:20:57 | La Salle, Texas, US | |
1088158 | 1088158 | 2022-08-09 | US | Nebraska | Hamilton | 31081 | 2491 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-08-10 04:20:57 | Hamilton, Nebraska, US | |
3545573 | 3545573 | 2022-08-08 | US | Nebraska | Hamilton | 31081 | 2491 | 26 | 0 | 40.87349452 | -98.02099117 | 2022-08-09 04:20:34 | Hamilton, Nebraska, US | |
1068861 | 1068861 | 2022-07-28 | US | Tennessee | Perry | 47135 | 2491 | 56 | 0 | 35.63708728 | -87.86139634 | 2022-07-29 04:20:45 | Perry, Tennessee, US | |
959697 | 959697 | 2022-07-19 | US | Georgia | Evans | 13109 | 2491 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-07-20 04:20:59 | Evans, Georgia, US | |
3213473 | 3213473 | 2022-07-18 | US | Texas | Ochiltree | 48357 | 2491 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-07-19 04:20:58 | Ochiltree, Texas, US | |
3211084 | 3211084 | 2022-07-18 | US | Georgia | Evans | 13109 | 2491 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-07-19 04:20:58 | Evans, Georgia, US | |
3408648 | 3408648 | 2022-07-17 | US | Texas | Ochiltree | 48357 | 2491 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-07-18 04:20:59 | Ochiltree, Texas, US | |
3406259 | 3406259 | 2022-07-17 | US | Georgia | Evans | 13109 | 2491 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-07-18 04:20:59 | Evans, Georgia, US | |
2154848 | 2154848 | 2022-07-16 | US | Texas | Ochiltree | 48357 | 2491 | 48 | 0 | 36.27829105 | -100.8158184 | 2022-07-17 04:21:15 | Ochiltree, Texas, US | |
2152459 | 2152459 | 2022-07-16 | US | Georgia | Evans | 13109 | 2491 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-07-17 04:21:15 | Evans, Georgia, US | |
2419692 | 2419692 | 2022-07-15 | US | Georgia | Evans | 13109 | 2491 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-07-16 04:21:05 | Evans, Georgia, US | |
3429767 | 3429767 | 2022-07-14 | US | Georgia | Evans | 13109 | 2491 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-07-15 04:20:53 | Evans, Georgia, US | |
3110287 | 3110287 | 2022-07-13 | US | Georgia | Evans | 13109 | 2491 | 64 | 0 | 32.15328841 | -81.8870105 | 2022-07-14 04:20:57 | Evans, Georgia, US | |
477634 | 477634 | 2022-06-26 | US | New Mexico | Colfax | 35007 | 2491 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-06-27 04:21:00 | Colfax, New Mexico, US | |
941009 | 941009 | 2022-06-25 | US | New Mexico | Colfax | 35007 | 2491 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-06-26 04:21:02 | Colfax, New Mexico, US | |
3348829 | 3348829 | 2022-06-24 | US | New Mexico | Colfax | 35007 | 2491 | 65 | 0 | 36.60569702 | -104.6472674 | 2022-06-25 04:20:57 | Colfax, New Mexico, US | |
559773 | 559773 | 2022-06-16 | US | Illinois | Brown | 17009 | 2491 | 15 | 0 | 39.96209138 | -90.75068024 | 2022-06-17 04:20:56 | Brown, Illinois, US | |
2599117 | 2599117 | 2022-05-05 | US | Indiana | Benton | 18007 | 2491 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-05-06 04:21:00 | Benton, Indiana, US | |
3266566 | 3266566 | 2022-05-04 | US | Indiana | Benton | 18007 | 2491 | 21 | 0 | 40.60626947 | -87.31093999 | 2022-05-05 04:20:55 | Benton, Indiana, US | |
3917446 | 3917446 | 2022-05-01 | US | Kentucky | Hancock | 21091 | 2491 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-05-02 04:21:10 | Hancock, Kentucky, US | |
2842250 | 2842250 | 2022-04-30 | US | Kentucky | Hancock | 21091 | 2491 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-05-01 04:20:57 | Hancock, Kentucky, US | |
1158563 | 1158563 | 2022-04-29 | US | Kentucky | Hancock | 21091 | 2491 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-30 04:21:05 | Hancock, Kentucky, US | |
1697745 | 1697745 | 2022-04-28 | US | Kentucky | Hancock | 21091 | 2491 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-29 04:20:59 | Hancock, Kentucky, US | |
3853228 | 3853228 | 2022-04-27 | US | Kentucky | Hancock | 21091 | 2491 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-28 04:20:47 | Hancock, Kentucky, US | |
1327658 | 1327658 | 2022-04-26 | US | Kentucky | Hancock | 21091 | 2491 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-27 04:20:52 | Hancock, Kentucky, US | |
1327471 | 1327471 | 2022-04-26 | US | Iowa | Mitchell | 19131 | 2491 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-27 04:20:52 | Mitchell, Iowa, US | |
3723612 | 3723612 | 2022-04-25 | US | Kentucky | Hancock | 21091 | 2491 | 24 | 0 | 37.83766422 | -86.78280584 | 2022-04-26 04:20:51 | Hancock, Kentucky, US | |
3723425 | 3723425 | 2022-04-25 | US | Iowa | Mitchell | 19131 | 2491 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-26 04:20:51 | Mitchell, Iowa, US | |
2029993 | 2029993 | 2022-04-24 | US | Iowa | Mitchell | 19131 | 2491 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-25 04:20:56 | Mitchell, Iowa, US | |
747568 | 747568 | 2022-04-23 | US | Iowa | Mitchell | 19131 | 2491 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-24 04:20:56 | Mitchell, Iowa, US | |
3438053 | 3438053 | 2022-04-22 | US | Iowa | Mitchell | 19131 | 2491 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-23 04:20:50 | Mitchell, Iowa, US | |
2893638 | 2893638 | 2022-04-21 | US | Iowa | Mitchell | 19131 | 2491 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-22 04:20:45 | Mitchell, Iowa, US | |
2308510 | 2308510 | 2022-04-20 | US | Iowa | Mitchell | 19131 | 2491 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-04-21 04:20:46 | Mitchell, Iowa, US | |
1865993 | 1865993 | 2022-03-10 | US | Arkansas | Perry | 5105 | 2491 | 35 | 0 | 34.945915299999996 | -92.94372564 | 2022-03-11 04:20:50 | Perry, Arkansas, US | |
922867 | 922867 | 2022-03-08 | US | Texas | Morris | 48343 | 2491 | 69 | 0 | 33.11304005 | -94.73255695 | 2022-03-09 04:20:59 | Morris, Texas, US | |
921682 | 921682 | 2022-03-08 | US | Montana | Fergus | 30027 | 2491 | 54 | 0 | 47.26331584 | -109.2245206 | 2022-03-09 04:20:59 | Fergus, Montana, US | |
1994535 | 1994535 | 2022-03-01 | US | Missouri | Bollinger | 29017 | 2491 | 36 | 0 | 37.32449052 | -90.02725304 | 2022-03-02 04:21:07 | Bollinger, Missouri, US | |
3675108 | 3675108 | 2022-02-15 | US | Washington | Pend Oreille | 53051 | 2491 | 30 | 0 | 48.53234021 | -117.2741804 | 2022-02-16 04:21:10 | Pend Oreille, Washington, US | |
2645209 | 2645209 | 2022-02-14 | US | Washington | Pend Oreille | 53051 | 2491 | 30 | 0 | 48.53234021 | -117.2741804 | 2022-02-15 04:21:09 | Pend Oreille, Washington, US | |
188484 | 188484 | 2022-02-13 | US | North Dakota | Mercer | 38057 | 2491 | 23 | 0 | 47.31213126 | -101.8318399 | 2022-02-14 04:20:51 | Mercer, North Dakota, US | |
318330 | 318330 | 2022-02-12 | US | North Dakota | Mercer | 38057 | 2491 | 23 | 0 | 47.31213126 | -101.8318399 | 2022-02-13 04:21:00 | Mercer, North Dakota, US | |
235656 | 235656 | 2022-02-11 | US | North Dakota | Mercer | 38057 | 2491 | 23 | 0 | 47.31213126 | -101.8318399 | 2022-02-12 04:21:06 | Mercer, North Dakota, US | |
1364144 | 1364144 | 2022-02-08 | US | Mississippi | Carroll | 28015 | 2491 | 48 | 0 | 33.44834567 | -89.91994479 | 2022-02-09 04:21:04 | Carroll, Mississippi, US | |
73443 | 73443 | 2022-02-07 | US | North Carolina | Pamlico | 37137 | 2491 | 27 | 0 | 35.15253315 | -76.66559823 | 2022-02-08 04:21:15 | Pamlico, North Carolina, US | |
462758 | 462758 | 2022-02-02 | US | Virginia | Nelson | 51125 | 2491 | 25 | 0 | 37.78790447 | -78.88498513 | 2022-02-03 04:21:21 | Nelson, Virginia, US | |
981684 | 981684 | 2022-02-01 | US | Puerto Rico | Comerio | 72045 | 2491 | 0 | 0 | 18.224687 | -66.221622 | 2022-02-02 04:21:09 | Comerio, Puerto Rico, US | |
2658862 | 2658862 | 2022-01-31 | US | Indiana | Brown | 18013 | 2491 | 58 | 0 | 39.19605589 | -86.22868909 | 2022-02-01 04:21:11 | Brown, Indiana, US | |
3300594 | 3300594 | 2022-01-30 | US | Alabama | Lowndes | 1085 | 2491 | 68 | 0 | 32.1597283 | -86.65158371 | 2022-01-31 04:21:09 | Lowndes, Alabama, US | |
2835792 | 2835792 | 2022-01-22 | US | Tennessee | Lake | 47095 | 2491 | 34 | 0 | 36.34180170000001 | -89.48921915 | 2022-01-23 04:21:13 | Lake, Tennessee, US | |
1473055 | 1473055 | 2022-01-17 | US | Idaho | Gooding | 16047 | 2491 | 46 | 0 | 42.96927962 | -114.81083059999999 | 2022-01-18 04:21:04 | Gooding, Idaho, US | |
555729 | 555729 | 2022-01-16 | US | Idaho | Gooding | 16047 | 2491 | 46 | 0 | 42.96927962 | -114.81083059999999 | 2022-01-17 04:21:08 | Gooding, Idaho, US | |
3841450 | 3841450 | 2022-01-15 | US | Idaho | Gooding | 16047 | 2491 | 46 | 0 | 42.96927962 | -114.81083059999999 | 2022-01-16 04:21:12 | Gooding, Idaho, US | |
1114377 | 1114377 | 2022-01-11 | US | Georgia | Dade | 13083 | 2491 | 23 | 0 | 34.854916700000004 | -85.50490424 | 2022-01-12 04:21:44 | Dade, Georgia, US | |
1695505 | 1695505 | 2022-01-10 | US | Texas | Nolan | 48353 | 2491 | 85 | 0 | 32.30365282 | -100.4060208 | 2022-01-11 04:22:01 | Nolan, Texas, US | |
1284487 | 1284487 | 2022-01-05 | US | Ohio | Morgan | 39115 | 2491 | 48 | 0 | 39.62081738 | -81.85308173 | 2022-01-06 04:22:09 | Morgan, Ohio, 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]);