johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
262 rows where confirmed = 2652 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 248
- Japan 3
- Bhutan 2
- Burkina Faso 2
- China 2
- Canada 1
- Germany 1
- Liechtenstein 1
- Namibia 1
- Russia 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754363 | 2754363 | 2022-12-29 | US | Kentucky | Nicholas | 21181 | 2652 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-30 04:21:04 | Nicholas, Kentucky, US | |
1075369 | 1075369 | 2022-12-28 | US | Kentucky | Nicholas | 21181 | 2652 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-29 04:21:01 | Nicholas, Kentucky, US | |
329366 | 329366 | 2022-12-27 | US | Kentucky | Nicholas | 21181 | 2652 | 35 | 0 | 38.33342292 | -84.01889177 | 2022-12-28 04:21:04 | Nicholas, Kentucky, US | |
2954368 | 2954368 | 2022-12-20 | US | Tennessee | Moore | 47127 | 2652 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-12-21 04:21:03 | Moore, Tennessee, US | |
3553030 | 3553030 | 2022-11-27 | US | Kentucky | Bracken | 21023 | 2652 | 29 | 0 | 38.69158994 | -84.08532444 | 2022-11-28 04:21:02 | Bracken, Kentucky, US | |
2101510 | 2101510 | 2022-11-26 | US | Kentucky | Bracken | 21023 | 2652 | 29 | 0 | 38.69158994 | -84.08532444 | 2022-11-27 04:21:05 | Bracken, Kentucky, US | |
489001 | 489001 | 2022-11-25 | US | Kentucky | Bracken | 21023 | 2652 | 29 | 0 | 38.69158994 | -84.08532444 | 2022-11-26 04:21:11 | Bracken, Kentucky, US | |
3524830 | 3524830 | 2022-11-24 | US | Kentucky | Bracken | 21023 | 2652 | 29 | 0 | 38.69158994 | -84.08532444 | 2022-11-25 04:21:06 | Bracken, Kentucky, US | |
3313613 | 3313613 | 2022-11-23 | US | Kentucky | Bracken | 21023 | 2652 | 29 | 0 | 38.69158994 | -84.08532444 | 2022-11-24 04:21:09 | Bracken, Kentucky, US | |
1621654 | 1621654 | 2022-11-22 | US | Kentucky | Bracken | 21023 | 2652 | 29 | 0 | 38.69158994 | -84.08532444 | 2022-11-23 04:21:06 | Bracken, Kentucky, US | |
3461542 | 3461542 | 2022-11-21 | US | Kentucky | Bracken | 21023 | 2652 | 29 | 0 | 38.69158994 | -84.08532444 | 2022-11-22 04:20:47 | Bracken, Kentucky, US | |
1643828 | 1643828 | 2022-11-20 | US | West Virginia | Clay | 54015 | 2652 | 52 | 0 | 38.46231092 | -81.07652217 | 2022-11-21 04:21:05 | Clay, West Virginia, US | |
2067385 | 2067385 | 2022-11-19 | US | West Virginia | Clay | 54015 | 2652 | 52 | 0 | 38.46231092 | -81.07652217 | 2022-11-20 04:21:08 | Clay, West Virginia, US | |
1758779 | 1758779 | 2022-11-18 | US | West Virginia | Clay | 54015 | 2652 | 52 | 0 | 38.46231092 | -81.07652217 | 2022-11-19 04:21:14 | Clay, West Virginia, US | |
313899 | 313899 | 2022-11-13 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-14 04:21:09 | Dawson, Montana, US | |
65060 | 65060 | 2022-11-12 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-13 04:21:14 | Dawson, Montana, US | |
2929222 | 2929222 | 2022-11-11 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-12 04:20:41 | Dawson, Montana, US | |
2508058 | 2508058 | 2022-11-10 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-11 04:21:22 | Dawson, Montana, US | |
2432933 | 2432933 | 2022-11-09 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-10 04:21:16 | Dawson, Montana, US | |
481589 | 481589 | 2022-11-08 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-09 04:21:22 | Dawson, Montana, US | |
2440739 | 2440739 | 2022-11-07 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-08 04:21:21 | Dawson, Montana, US | |
1053175 | 1053175 | 2022-11-06 | US | Virginia | Essex | 51057 | 2652 | 40 | 0 | 37.93357639 | -76.94230311 | 2022-11-07 04:21:26 | Essex, Virginia, US | |
1051837 | 1051837 | 2022-11-06 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-07 04:21:26 | Dawson, Montana, US | |
621199 | 621199 | 2022-11-05 | US | Virginia | Essex | 51057 | 2652 | 40 | 0 | 37.93357639 | -76.94230311 | 2022-11-06 04:21:24 | Essex, Virginia, US | |
619861 | 619861 | 2022-11-05 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-06 04:21:24 | Dawson, Montana, US | |
1025703 | 1025703 | 2022-11-04 | US | Virginia | Essex | 51057 | 2652 | 40 | 0 | 37.93357639 | -76.94230311 | 2022-11-05 04:21:52 | Essex, Virginia, US | |
1024365 | 1024365 | 2022-11-04 | US | Montana | Dawson | 30021 | 2652 | 59 | 0 | 47.26584855 | -104.8944417 | 2022-11-05 04:21:52 | Dawson, Montana, US | |
434694 | 434694 | 2022-11-03 | US | Virginia | Essex | 51057 | 2652 | 40 | 0 | 37.93357639 | -76.94230311 | 2022-11-04 04:22:11 | Essex, Virginia, US | |
2772589 | 2772589 | 2022-09-26 | US | Wyoming | Washakie | 56043 | 2652 | 47 | 0 | 43.90451606 | -107.680187 | 2022-09-27 04:23:01 | Washakie, Wyoming, US | |
1980242 | 1980242 | 2022-09-25 | US | Wyoming | Washakie | 56043 | 2652 | 47 | 0 | 43.90451606 | -107.680187 | 2022-09-26 04:20:52 | Washakie, Wyoming, US | |
2653409 | 2653409 | 2022-09-24 | US | Wyoming | Washakie | 56043 | 2652 | 47 | 0 | 43.90451606 | -107.680187 | 2022-09-25 04:23:31 | Washakie, Wyoming, US | |
387849 | 387849 | 2022-09-23 | US | Wyoming | Washakie | 56043 | 2652 | 47 | 0 | 43.90451606 | -107.680187 | 2022-09-24 04:21:40 | Washakie, Wyoming, US | |
1627915 | 1627915 | 2022-09-22 | US | Wyoming | Washakie | 56043 | 2652 | 47 | 0 | 43.90451606 | -107.680187 | 2022-09-23 04:23:13 | Washakie, Wyoming, US | |
1374119 | 1374119 | 2022-09-21 | US | Wyoming | Washakie | 56043 | 2652 | 47 | 0 | 43.90451606 | -107.680187 | 2022-09-22 04:22:56 | Washakie, Wyoming, US | |
2020349 | 2020349 | 2022-09-20 | US | Wyoming | Washakie | 56043 | 2652 | 47 | 0 | 43.90451606 | -107.680187 | 2022-09-21 04:23:22 | Washakie, Wyoming, US | |
3987549 | 3987549 | 2022-09-15 | US | Idaho | Benewah | 16009 | 2652 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-09-16 04:21:19 | Benewah, Idaho, US | |
1890066 | 1890066 | 2022-09-14 | US | Idaho | Benewah | 16009 | 2652 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-09-15 04:21:02 | Benewah, Idaho, US | |
3769402 | 3769402 | 2022-09-11 | US | West Virginia | Webster | 54101 | 2652 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-09-12 04:20:58 | Webster, West Virginia, US | |
3827977 | 3827977 | 2022-09-10 | US | West Virginia | Webster | 54101 | 2652 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-09-11 04:20:50 | Webster, West Virginia, US | |
966434 | 966434 | 2022-09-09 | US | West Virginia | Webster | 54101 | 2652 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-09-10 04:21:10 | Webster, West Virginia, US | |
3550925 | 3550925 | 2022-09-01 | US | Virginia | Sussex | 51183 | 2652 | 43 | 0 | 36.92432914 | -77.25791182 | 2022-09-02 04:21:07 | Sussex, Virginia, US | |
3774794 | 3774794 | 2022-08-30 | US | Georgia | Towns | 13281 | 2652 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-08-31 04:20:57 | Towns, Georgia, US | |
1681390 | 1681390 | 2022-08-29 | US | Georgia | Towns | 13281 | 2652 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-08-30 04:21:03 | Towns, Georgia, US | |
1877874 | 1877874 | 2022-08-28 | US | Georgia | Towns | 13281 | 2652 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-08-29 04:21:06 | Towns, Georgia, US | |
2097001 | 2097001 | 2022-08-27 | US | Georgia | Towns | 13281 | 2652 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-08-28 04:21:02 | Towns, Georgia, US | |
1532816 | 1532816 | 2022-08-26 | US | Georgia | Towns | 13281 | 2652 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-08-27 04:20:57 | Towns, Georgia, US | |
2829703 | 2829703 | 2022-08-25 | US | Georgia | Towns | 13281 | 2652 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-08-26 04:21:02 | Towns, Georgia, US | |
2324236 | 2324236 | 2022-08-24 | US | Georgia | Towns | 13281 | 2652 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-08-25 04:21:13 | Towns, Georgia, US | |
2366230 | 2366230 | 2022-08-19 | US | Puerto Rico | Ceiba | 72037 | 2652 | 0 | 0 | 18.251818 | -65.666416 | 2022-08-20 04:21:01 | Ceiba, Puerto Rico, US | |
1405889 | 1405889 | 2022-08-02 | US | Georgia | McIntosh | 13191 | 2652 | 38 | 0 | 31.49683595 | -81.40163426 | 2022-08-03 04:20:59 | McIntosh, Georgia, US | |
3617927 | 3617927 | 2022-08-01 | US | Georgia | McIntosh | 13191 | 2652 | 38 | 0 | 31.49683595 | -81.40163426 | 2022-08-02 04:20:53 | McIntosh, Georgia, US | |
3872407 | 3872407 | 2022-07-31 | US | Georgia | McIntosh | 13191 | 2652 | 38 | 0 | 31.49683595 | -81.40163426 | 2022-08-01 04:21:03 | McIntosh, Georgia, US | |
675161 | 675161 | 2022-07-30 | US | Georgia | McIntosh | 13191 | 2652 | 38 | 0 | 31.49683595 | -81.40163426 | 2022-07-31 04:21:02 | McIntosh, Georgia, US | |
1784360 | 1784360 | 2022-07-29 | US | Georgia | McIntosh | 13191 | 2652 | 38 | 0 | 31.49683595 | -81.40163426 | 2022-07-30 04:20:42 | McIntosh, Georgia, US | |
1783324 | 1783324 | 2022-07-29 | China | Sichuan | 2652 | 3 | 0 | 30.6171 | 102.7103 | 2022-07-30 04:20:42 | Sichuan, China | |||
1066723 | 1066723 | 2022-07-28 | US | Georgia | McIntosh | 13191 | 2652 | 38 | 0 | 31.49683595 | -81.40163426 | 2022-07-29 04:20:45 | McIntosh, Georgia, US | |
2336242 | 2336242 | 2022-07-27 | US | Georgia | McIntosh | 13191 | 2652 | 38 | 0 | 31.49683595 | -81.40163426 | 2022-07-28 04:20:56 | McIntosh, Georgia, US | |
1488780 | 1488780 | 2022-07-26 | US | Iowa | Franklin | 19069 | 2652 | 43 | 0 | 42.73270384 | -93.26256925 | 2022-07-27 04:21:04 | Franklin, Iowa, US | |
2595226 | 2595226 | 2022-07-25 | US | Iowa | Franklin | 19069 | 2652 | 43 | 0 | 42.73270384 | -93.26256925 | 2022-07-26 04:20:58 | Franklin, Iowa, US | |
899604 | 899604 | 2022-07-24 | US | Washington | Pend Oreille | 53051 | 2652 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-07-25 04:20:51 | Pend Oreille, Washington, US | |
897341 | 897341 | 2022-07-24 | US | Iowa | Franklin | 19069 | 2652 | 43 | 0 | 42.73270384 | -93.26256925 | 2022-07-25 04:20:51 | Franklin, Iowa, US | |
94598 | 94598 | 2022-07-23 | US | Washington | Pend Oreille | 53051 | 2652 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-07-24 04:20:47 | Pend Oreille, Washington, US | |
92335 | 92335 | 2022-07-23 | US | Iowa | Franklin | 19069 | 2652 | 43 | 0 | 42.73270384 | -93.26256925 | 2022-07-24 04:20:47 | Franklin, Iowa, US | |
903620 | 903620 | 2022-07-22 | US | Washington | Pend Oreille | 53051 | 2652 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-07-23 04:20:53 | Pend Oreille, Washington, US | |
901357 | 901357 | 2022-07-22 | US | Iowa | Franklin | 19069 | 2652 | 43 | 0 | 42.73270384 | -93.26256925 | 2022-07-23 04:20:53 | Franklin, Iowa, US | |
671493 | 671493 | 2022-07-21 | US | Iowa | Franklin | 19069 | 2652 | 43 | 0 | 42.73270384 | -93.26256925 | 2022-07-22 04:21:15 | Franklin, Iowa, US | |
1609456 | 1609456 | 2022-07-20 | US | Iowa | Franklin | 19069 | 2652 | 43 | 0 | 42.73270384 | -93.26256925 | 2022-07-21 04:21:10 | Franklin, Iowa, US | |
3429481 | 3429481 | 2022-07-14 | US | Arkansas | Perry | 5105 | 2652 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-07-15 04:20:53 | Perry, Arkansas, US | |
3941986 | 3941986 | 2022-06-30 | US | Missouri | Linn | 29115 | 2652 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-07-01 04:21:10 | Linn, Missouri, US | |
2491944 | 2491944 | 2022-06-29 | US | Missouri | Linn | 29115 | 2652 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-30 04:21:01 | Linn, Missouri, US | |
2241326 | 2241326 | 2022-06-28 | US | Missouri | Linn | 29115 | 2652 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-29 04:20:59 | Linn, Missouri, US | |
2149568 | 2149568 | 2022-06-27 | US | Missouri | Linn | 29115 | 2652 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-28 04:20:58 | Linn, Missouri, US | |
2149434 | 2149434 | 2022-06-27 | US | Mississippi | Carroll | 28015 | 2652 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-06-28 04:20:58 | Carroll, Mississippi, US | |
477369 | 477369 | 2022-06-26 | US | Missouri | Linn | 29115 | 2652 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-27 04:21:00 | Linn, Missouri, US | |
477235 | 477235 | 2022-06-26 | US | Mississippi | Carroll | 28015 | 2652 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-06-27 04:21:00 | Carroll, Mississippi, US | |
940744 | 940744 | 2022-06-25 | US | Missouri | Linn | 29115 | 2652 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-26 04:21:02 | Linn, Missouri, US | |
940610 | 940610 | 2022-06-25 | US | Mississippi | Carroll | 28015 | 2652 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-06-26 04:21:02 | Carroll, Mississippi, US | |
939335 | 939335 | 2022-06-25 | US | Arkansas | Pike | 5109 | 2652 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-06-26 04:21:02 | Pike, Arkansas, US | |
3348564 | 3348564 | 2022-06-24 | US | Missouri | Linn | 29115 | 2652 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-25 04:20:57 | Linn, Missouri, US | |
3348430 | 3348430 | 2022-06-24 | US | Mississippi | Carroll | 28015 | 2652 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-06-25 04:20:57 | Carroll, Mississippi, US | |
1651780 | 1651780 | 2022-06-23 | US | Virginia | Richmond | 51159 | 2652 | 25 | 0 | 37.937575 | -76.72920628 | 2022-06-24 04:20:58 | Richmond, Virginia, US | |
1650171 | 1650171 | 2022-06-23 | US | Mississippi | Carroll | 28015 | 2652 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-06-24 04:20:58 | Carroll, Mississippi, US | |
2189406 | 2189406 | 2022-06-22 | US | Mississippi | Carroll | 28015 | 2652 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-06-23 04:20:55 | Carroll, Mississippi, US | |
167837 | 167837 | 2022-06-21 | US | Mississippi | Carroll | 28015 | 2652 | 55 | 0 | 33.44834567 | -89.91994479 | 2022-06-22 04:20:54 | Carroll, Mississippi, US | |
167829 | 167829 | 2022-06-21 | US | Minnesota | Yellow Medicine | 27173 | 2652 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-06-22 04:20:54 | Yellow Medicine, Minnesota, US | |
2314352 | 2314352 | 2022-06-17 | US | Texas | Childress | 48075 | 2652 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-06-18 04:21:10 | Childress, Texas, US | |
561856 | 561856 | 2022-06-16 | US | Texas | Childress | 48075 | 2652 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-06-17 04:20:56 | Childress, Texas, US | |
559212 | 559212 | 2022-06-16 | US | Alabama | Sumter | 1119 | 2652 | 52 | 0 | 32.59117397 | -88.19916205 | 2022-06-17 04:20:56 | Sumter, Alabama, US | |
3985928 | 3985928 | 2022-06-15 | US | Virginia | Charlotte | 51037 | 2652 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-06-16 04:20:55 | Charlotte, Virginia, US | |
3726605 | 3726605 | 2022-06-07 | US | Alabama | Lowndes | 1085 | 2652 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-06-08 04:20:55 | Lowndes, Alabama, US | |
2601371 | 2601371 | 2022-05-05 | US | Virginia | Clarke | 51043 | 2652 | 42 | 0 | 39.11271747 | -77.99199425 | 2022-05-06 04:21:00 | Clarke, Virginia, US | |
2895653 | 2895653 | 2022-04-21 | US | Texas | Trinity | 48455 | 2652 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-04-22 04:20:45 | Trinity, Texas, US | |
502436 | 502436 | 2022-04-02 | US | Puerto Rico | Orocovis | 72107 | 2652 | 0 | 0 | 18.215046 | -66.433604 | 2022-04-03 04:20:48 | Orocovis, Puerto Rico, US | |
1548458 | 1548458 | 2022-03-07 | US | Arkansas | Fulton | 5049 | 2652 | 85 | 0 | 36.38177105 | -91.81729127 | 2022-03-08 04:20:54 | Fulton, Arkansas, US | |
1994861 | 1994861 | 2022-03-01 | US | New Mexico | Los Alamos | 35028 | 2652 | 13 | 0 | 35.86631386 | -106.31349850000001 | 2022-03-02 04:21:07 | Los Alamos, New Mexico, US | |
1993836 | 1993836 | 2022-03-01 | US | Iowa | Chickasaw | 19037 | 2652 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-02 04:21:07 | Chickasaw, Iowa, US | |
944010 | 944010 | 2022-02-28 | US | Iowa | Chickasaw | 19037 | 2652 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-03-01 04:21:09 | Chickasaw, Iowa, US | |
2735241 | 2735241 | 2022-02-27 | US | New Mexico | Torrance | 35057 | 2652 | 50 | 0 | 34.64048375 | -105.8508949 | 2022-02-28 04:21:05 | Torrance, New Mexico, US | |
2734756 | 2734756 | 2022-02-27 | US | Minnesota | Koochiching | 27071 | 2652 | 34 | 0 | 48.24539665 | -93.78352843 | 2022-02-28 04:21:05 | Koochiching, Minnesota, US | |
2734201 | 2734201 | 2022-02-27 | US | Iowa | Chickasaw | 19037 | 2652 | 31 | 0 | 43.06001295 | -92.31773347 | 2022-02-28 04:21:05 | Chickasaw, Iowa, 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]);