johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
381 rows where confirmed = 1742 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330785 | 330785 | 2022-12-27 | US | South Dakota | Hamlin | 46057 | 1742 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-28 04:21:04 | Hamlin, South Dakota, US | |
220858 | 220858 | 2022-12-26 | US | South Dakota | Hamlin | 46057 | 1742 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-27 04:21:07 | Hamlin, South Dakota, US | |
3225315 | 3225315 | 2022-12-25 | US | South Dakota | Hamlin | 46057 | 1742 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-26 04:21:06 | Hamlin, South Dakota, US | |
1021229 | 1021229 | 2022-12-24 | US | South Dakota | Hamlin | 46057 | 1742 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-25 04:21:04 | Hamlin, South Dakota, US | |
693252 | 693252 | 2022-12-23 | US | South Dakota | Hamlin | 46057 | 1742 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-24 04:21:02 | Hamlin, South Dakota, US | |
2182462 | 2182462 | 2022-12-22 | US | South Dakota | Hamlin | 46057 | 1742 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-23 04:21:04 | Hamlin, South Dakota, US | |
454266 | 454266 | 2022-12-21 | US | South Dakota | Hamlin | 46057 | 1742 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-12-22 04:20:56 | Hamlin, South Dakota, US | |
1149460 | 1149460 | 2022-12-12 | US | Arkansas | Montgomery | 5097 | 1742 | 64 | 0 | 34.53704874 | -93.65824478 | 2022-12-13 04:21:01 | Montgomery, Arkansas, US | |
3553469 | 3553469 | 2022-11-27 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-28 04:21:02 | Jefferson, Mississippi, US | |
2101949 | 2101949 | 2022-11-26 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-27 04:21:05 | Jefferson, Mississippi, US | |
489440 | 489440 | 2022-11-25 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-26 04:21:11 | Jefferson, Mississippi, US | |
3525269 | 3525269 | 2022-11-24 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-25 04:21:06 | Jefferson, Mississippi, US | |
3314052 | 3314052 | 2022-11-23 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-24 04:21:09 | Jefferson, Mississippi, US | |
1622093 | 1622093 | 2022-11-22 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-23 04:21:06 | Jefferson, Mississippi, US | |
3461981 | 3461981 | 2022-11-21 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-22 04:20:47 | Jefferson, Mississippi, US | |
1642166 | 1642166 | 2022-11-20 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-21 04:21:05 | Jefferson, Mississippi, US | |
1641341 | 1641341 | 2022-11-20 | US | Illinois | Gallatin | 17059 | 1742 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-21 04:21:05 | Gallatin, Illinois, US | |
2065723 | 2065723 | 2022-11-19 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-20 04:21:08 | Jefferson, Mississippi, US | |
2064898 | 2064898 | 2022-11-19 | US | Illinois | Gallatin | 17059 | 1742 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-20 04:21:08 | Gallatin, Illinois, US | |
1757117 | 1757117 | 2022-11-18 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-19 04:21:14 | Jefferson, Mississippi, US | |
1756292 | 1756292 | 2022-11-18 | US | Illinois | Gallatin | 17059 | 1742 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-19 04:21:14 | Gallatin, Illinois, US | |
3028110 | 3028110 | 2022-11-17 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-18 04:21:15 | Jefferson, Mississippi, US | |
3027285 | 3027285 | 2022-11-17 | US | Illinois | Gallatin | 17059 | 1742 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-11-18 04:21:15 | Gallatin, Illinois, US | |
2487821 | 2487821 | 2022-11-16 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-17 04:21:11 | Jefferson, Mississippi, US | |
293832 | 293832 | 2022-11-15 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-16 04:21:09 | Jefferson, Mississippi, US | |
3598862 | 3598862 | 2022-11-14 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-15 04:21:16 | Jefferson, Mississippi, US | |
313720 | 313720 | 2022-11-13 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-14 04:21:09 | Jefferson, Mississippi, US | |
64881 | 64881 | 2022-11-12 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-13 04:21:14 | Jefferson, Mississippi, US | |
2929043 | 2929043 | 2022-11-11 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-12 04:20:41 | Jefferson, Mississippi, US | |
2507879 | 2507879 | 2022-11-10 | US | Mississippi | Jefferson | 28063 | 1742 | 38 | 0 | 31.73397872 | -91.03764977 | 2022-11-11 04:21:22 | Jefferson, Mississippi, US | |
3280198 | 3280198 | 2022-10-23 | US | Virginia | Covington | 51580 | 1742 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-24 04:22:29 | Covington, Virginia, US | |
2271236 | 2271236 | 2022-10-22 | US | Virginia | Covington | 51580 | 1742 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-23 04:22:46 | Covington, Virginia, US | |
1595536 | 1595536 | 2022-10-21 | US | Virginia | Covington | 51580 | 1742 | 30 | 0 | 37.7824656 | -79.98631446 | 2022-10-22 04:22:53 | Covington, Virginia, US | |
254282 | 254282 | 2022-09-08 | US | Illinois | Calhoun | 17013 | 1742 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-09-09 04:21:11 | Calhoun, Illinois, US | |
1163559 | 1163559 | 2022-08-18 | US | North Dakota | Bottineau | 38009 | 1742 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-08-19 04:20:54 | Bottineau, North Dakota, US | |
3875020 | 3875020 | 2022-07-31 | US | Washington | San Juan | 53055 | 1742 | 2 | 0 | 48.60182783 | -122.96745 | 2022-08-01 04:21:03 | San Juan, Washington, US | |
677774 | 677774 | 2022-07-30 | US | Washington | San Juan | 53055 | 1742 | 2 | 0 | 48.60182783 | -122.96745 | 2022-07-31 04:21:02 | San Juan, Washington, US | |
1786973 | 1786973 | 2022-07-29 | US | Washington | San Juan | 53055 | 1742 | 2 | 0 | 48.60182783 | -122.96745 | 2022-07-30 04:20:42 | San Juan, Washington, US | |
1069336 | 1069336 | 2022-07-28 | US | Washington | San Juan | 53055 | 1742 | 2 | 0 | 48.60182783 | -122.96745 | 2022-07-29 04:20:45 | San Juan, Washington, US | |
2338855 | 2338855 | 2022-07-27 | US | Washington | San Juan | 53055 | 1742 | 2 | 0 | 48.60182783 | -122.96745 | 2022-07-28 04:20:56 | San Juan, Washington, US | |
1214719 | 1214719 | 2022-07-11 | US | Texas | Marion | 48315 | 1742 | 60 | 0 | 32.79868409 | -94.3566123 | 2022-07-12 04:20:51 | Marion, Texas, US | |
1648892 | 1648892 | 2022-06-23 | US | Arkansas | Newton | 5101 | 1742 | 49 | 0 | 35.91947491 | -93.21612969 | 2022-06-24 04:20:58 | Newton, Arkansas, US | |
948075 | 948075 | 2022-06-14 | US | Iowa | Monona | 19133 | 1742 | 48 | 0 | 42.05220391 | -95.95743843 | 2022-06-15 04:20:54 | Monona, Iowa, US | |
2980483 | 2980483 | 2022-06-13 | US | Iowa | Monona | 19133 | 1742 | 48 | 0 | 42.05220391 | -95.95743843 | 2022-06-14 04:20:52 | Monona, Iowa, US | |
2236609 | 2236609 | 2022-06-12 | US | Iowa | Monona | 19133 | 1742 | 48 | 0 | 42.05220391 | -95.95743843 | 2022-06-13 04:21:14 | Monona, Iowa, US | |
3142807 | 3142807 | 2022-06-11 | US | Iowa | Monona | 19133 | 1742 | 48 | 0 | 42.05220391 | -95.95743843 | 2022-06-12 04:20:53 | Monona, Iowa, US | |
1945723 | 1945723 | 2022-06-10 | US | Iowa | Monona | 19133 | 1742 | 48 | 0 | 42.05220391 | -95.95743843 | 2022-06-11 04:21:01 | Monona, Iowa, US | |
3158862 | 3158862 | 2022-06-09 | US | Iowa | Monona | 19133 | 1742 | 48 | 0 | 42.05220391 | -95.95743843 | 2022-06-10 04:20:55 | Monona, Iowa, US | |
1422329 | 1422329 | 2022-06-08 | US | Iowa | Monona | 19133 | 1742 | 48 | 0 | 42.05220391 | -95.95743843 | 2022-06-09 04:20:54 | Monona, Iowa, US | |
3510009 | 3510009 | 2022-06-05 | US | Oregon | Grant | 41023 | 1742 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-06 04:20:57 | Grant, Oregon, US | |
3508428 | 3508428 | 2022-06-05 | US | Illinois | Pulaski | 17153 | 1742 | 20 | 0 | 37.22631423 | -89.13085001 | 2022-06-06 04:20:57 | Pulaski, Illinois, US | |
3530086 | 3530086 | 2022-06-04 | US | Oregon | Grant | 41023 | 1742 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-05 04:20:55 | Grant, Oregon, US | |
3528505 | 3528505 | 2022-06-04 | US | Illinois | Pulaski | 17153 | 1742 | 20 | 0 | 37.22631423 | -89.13085001 | 2022-06-05 04:20:55 | Pulaski, Illinois, US | |
3136172 | 3136172 | 2022-06-03 | US | Oregon | Grant | 41023 | 1742 | 22 | 0 | 44.49024544 | -119.0068631 | 2022-06-04 04:20:58 | Grant, Oregon, US | |
3134591 | 3134591 | 2022-06-03 | US | Illinois | Pulaski | 17153 | 1742 | 20 | 0 | 37.22631423 | -89.13085001 | 2022-06-04 04:20:58 | Pulaski, Illinois, US | |
3580572 | 3580572 | 2022-06-02 | US | Missouri | Ozark | 29153 | 1742 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-03 04:20:58 | Ozark, Missouri, US | |
972865 | 972865 | 2022-06-01 | US | Missouri | Ozark | 29153 | 1742 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-02 05:20:39 | Ozark, Missouri, US | |
231172 | 231172 | 2022-05-31 | US | Missouri | Ozark | 29153 | 1742 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-06-01 04:20:55 | Ozark, Missouri, US | |
3187937 | 3187937 | 2022-05-30 | US | Missouri | Ozark | 29153 | 1742 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-05-31 04:20:51 | Ozark, Missouri, US | |
3200086 | 3200086 | 2022-05-29 | US | Missouri | Ozark | 29153 | 1742 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-05-30 04:20:50 | Ozark, Missouri, US | |
2726964 | 2726964 | 2022-05-28 | US | Missouri | Ozark | 29153 | 1742 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-05-29 04:20:53 | Ozark, Missouri, US | |
1316145 | 1316145 | 2022-05-27 | US | Missouri | Ozark | 29153 | 1742 | 62 | 0 | 36.64916339 | -92.44459066 | 2022-05-28 04:21:07 | Ozark, Missouri, US | |
3000917 | 3000917 | 2022-05-24 | US | Michigan | Alger | 26003 | 1742 | 13 | 0 | 46.41292944 | -86.60260122 | 2022-05-25 04:20:56 | Alger, Michigan, US | |
3594638 | 3594638 | 2022-05-23 | US | Michigan | Alger | 26003 | 1742 | 13 | 0 | 46.41292944 | -86.60260122 | 2022-05-24 04:20:57 | Alger, Michigan, US | |
622531 | 622531 | 2022-05-22 | US | Colorado | Rio Blanco | 8103 | 1742 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-05-26 04:20:50 | Rio Blanco, Colorado, US | |
1111186 | 1111186 | 2022-05-21 | US | Michigan | Alger | 26003 | 1742 | 13 | 0 | 46.41292944 | -86.60260122 | 2022-05-22 04:20:52 | Alger, Michigan, US | |
1110227 | 1110227 | 2022-05-21 | US | Colorado | Rio Blanco | 8103 | 1742 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-05-22 04:20:52 | Rio Blanco, Colorado, US | |
1170810 | 1170810 | 2022-05-20 | US | Michigan | Alger | 26003 | 1742 | 13 | 0 | 46.41292944 | -86.60260122 | 2022-05-21 04:20:58 | Alger, Michigan, US | |
3897573 | 3897573 | 2022-05-19 | US | Michigan | Alger | 26003 | 1742 | 13 | 0 | 46.41292944 | -86.60260122 | 2022-05-20 04:20:57 | Alger, Michigan, US | |
1186357 | 1186357 | 2022-05-18 | US | Michigan | Alger | 26003 | 1742 | 13 | 0 | 46.41292944 | -86.60260122 | 2022-05-19 04:20:54 | Alger, Michigan, US | |
1573331 | 1573331 | 2022-05-03 | US | Iowa | Greene | 19073 | 1742 | 21 | 0 | 42.03614551 | -94.39658081 | 2022-05-04 04:20:59 | Greene, Iowa, US | |
464591 | 464591 | 2022-05-02 | US | Iowa | Greene | 19073 | 1742 | 21 | 0 | 42.03614551 | -94.39658081 | 2022-05-03 04:21:00 | Greene, Iowa, US | |
3917230 | 3917230 | 2022-05-01 | US | Iowa | Greene | 19073 | 1742 | 21 | 0 | 42.03614551 | -94.39658081 | 2022-05-02 04:21:10 | Greene, Iowa, US | |
2842034 | 2842034 | 2022-04-30 | US | Iowa | Greene | 19073 | 1742 | 21 | 0 | 42.03614551 | -94.39658081 | 2022-05-01 04:20:57 | Greene, Iowa, US | |
1158347 | 1158347 | 2022-04-29 | US | Iowa | Greene | 19073 | 1742 | 21 | 0 | 42.03614551 | -94.39658081 | 2022-04-30 04:21:05 | Greene, Iowa, US | |
1697529 | 1697529 | 2022-04-28 | US | Iowa | Greene | 19073 | 1742 | 21 | 0 | 42.03614551 | -94.39658081 | 2022-04-29 04:20:59 | Greene, Iowa, US | |
1696132 | 1696132 | 2022-04-28 | China | Inner Mongolia | 1742 | 1 | 0 | 44.0935 | 113.9448 | 2022-04-29 04:20:59 | Inner Mongolia, China | |||
3853012 | 3853012 | 2022-04-27 | US | Iowa | Greene | 19073 | 1742 | 21 | 0 | 42.03614551 | -94.39658081 | 2022-04-28 04:20:47 | Greene, Iowa, US | |
3852802 | 3852802 | 2022-04-27 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-28 04:20:47 | Edwards, Illinois, US | |
1327232 | 1327232 | 2022-04-26 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-27 04:20:52 | Edwards, Illinois, US | |
3723186 | 3723186 | 2022-04-25 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-26 04:20:51 | Edwards, Illinois, US | |
2029754 | 2029754 | 2022-04-24 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-25 04:20:56 | Edwards, Illinois, US | |
747329 | 747329 | 2022-04-23 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-24 04:20:56 | Edwards, Illinois, US | |
3437814 | 3437814 | 2022-04-22 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-23 04:20:50 | Edwards, Illinois, US | |
2893399 | 2893399 | 2022-04-21 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-22 04:20:45 | Edwards, Illinois, US | |
2308271 | 2308271 | 2022-04-20 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-21 04:20:46 | Edwards, Illinois, US | |
2252410 | 2252410 | 2022-04-19 | US | Illinois | Edwards | 17047 | 1742 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-04-20 04:20:45 | Edwards, Illinois, US | |
3022058 | 3022058 | 2022-03-23 | China | Beijing | 1742 | 9 | 0 | 40.1824 | 116.4142 | 2022-03-24 04:20:43 | Beijing, China | |||
27826 | 27826 | 2022-03-20 | US | Virginia | Williamsburg | 51830 | 1742 | 22 | 0 | 37.28131268 | -76.70905141 | 2022-03-21 04:20:50 | Williamsburg, Virginia, US | |
1659836 | 1659836 | 2022-03-19 | US | Virginia | Williamsburg | 51830 | 1742 | 22 | 0 | 37.28131268 | -76.70905141 | 2022-03-20 04:20:45 | Williamsburg, Virginia, US | |
339362 | 339362 | 2022-03-18 | US | Virginia | Williamsburg | 51830 | 1742 | 22 | 0 | 37.28131268 | -76.70905141 | 2022-03-19 04:20:47 | Williamsburg, Virginia, US | |
2322758 | 2322758 | 2022-03-16 | US | Virginia | Williamsburg | 51830 | 1742 | 22 | 0 | 37.28131268 | -76.70905141 | 2022-03-17 04:20:56 | Williamsburg, Virginia, US | |
262749 | 262749 | 2022-03-15 | US | Iowa | Lucas | 19117 | 1742 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-03-16 04:20:50 | Lucas, Iowa, US | |
2265108 | 2265108 | 2022-03-14 | US | Iowa | Lucas | 19117 | 1742 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-03-15 04:20:47 | Lucas, Iowa, US | |
3629174 | 3629174 | 2022-03-13 | US | Iowa | Lucas | 19117 | 1742 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-03-14 04:20:46 | Lucas, Iowa, US | |
952082 | 952082 | 2022-03-12 | US | Iowa | Lucas | 19117 | 1742 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-03-13 04:20:49 | Lucas, Iowa, US | |
357543 | 357543 | 2022-03-11 | US | Iowa | Lucas | 19117 | 1742 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-03-12 04:20:50 | Lucas, Iowa, US | |
1866695 | 1866695 | 2022-03-10 | US | Iowa | Lucas | 19117 | 1742 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-03-11 04:20:50 | Lucas, Iowa, US | |
2141390 | 2141390 | 2022-03-09 | US | Iowa | Lucas | 19117 | 1742 | 32 | 0 | 41.02958964 | -93.32780803 | 2022-03-10 04:20:48 | Lucas, Iowa, US | |
1994346 | 1994346 | 2022-03-01 | US | Michigan | Schoolcraft | 26153 | 1742 | 13 | 0 | 46.19235734 | -86.19972234 | 2022-03-02 04:21:07 | Schoolcraft, Michigan, 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]);