johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
346 rows where confirmed = 2173 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754930 | 2754930 | 2022-12-29 | US | Montana | Powell | 30077 | 2173 | 32 | 0 | 46.85538891 | -112.9359164 | 2022-12-30 04:21:04 | Powell, Montana, US | |
1075936 | 1075936 | 2022-12-28 | US | Montana | Powell | 30077 | 2173 | 32 | 0 | 46.85538891 | -112.9359164 | 2022-12-29 04:21:01 | Powell, Montana, US | |
329933 | 329933 | 2022-12-27 | US | Montana | Powell | 30077 | 2173 | 32 | 0 | 46.85538891 | -112.9359164 | 2022-12-28 04:21:04 | Powell, Montana, US | |
220006 | 220006 | 2022-12-26 | US | Montana | Powell | 30077 | 2173 | 32 | 0 | 46.85538891 | -112.9359164 | 2022-12-27 04:21:07 | Powell, Montana, US | |
3224463 | 3224463 | 2022-12-25 | US | Montana | Powell | 30077 | 2173 | 32 | 0 | 46.85538891 | -112.9359164 | 2022-12-26 04:21:06 | Powell, Montana, US | |
1020377 | 1020377 | 2022-12-24 | US | Montana | Powell | 30077 | 2173 | 32 | 0 | 46.85538891 | -112.9359164 | 2022-12-25 04:21:04 | Powell, Montana, US | |
692400 | 692400 | 2022-12-23 | US | Montana | Powell | 30077 | 2173 | 32 | 0 | 46.85538891 | -112.9359164 | 2022-12-24 04:21:02 | Powell, Montana, US | |
1628961 | 1628961 | 2022-12-18 | US | Colorado | Rio Blanco | 8103 | 2173 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-12-19 04:21:03 | Rio Blanco, Colorado, US | |
504340 | 504340 | 2022-12-17 | US | Colorado | Rio Blanco | 8103 | 2173 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-12-18 04:21:03 | Rio Blanco, Colorado, US | |
3324912 | 3324912 | 2022-12-16 | US | Colorado | Rio Blanco | 8103 | 2173 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-12-17 04:21:04 | Rio Blanco, Colorado, US | |
3380383 | 3380383 | 2022-12-08 | US | Tennessee | Van Buren | 47175 | 2173 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-09 04:21:05 | Van Buren, Tennessee, US | |
1987654 | 1987654 | 2022-12-07 | US | Tennessee | Van Buren | 47175 | 2173 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-12-08 04:21:07 | Van Buren, Tennessee, US | |
713880 | 713880 | 2022-11-01 | US | Virginia | Williamsburg | 51830 | 2173 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-11-02 04:22:09 | Williamsburg, Virginia, US | |
133141 | 133141 | 2022-10-04 | US | North Dakota | Benson | 38005 | 2173 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-10-05 04:23:06 | Benson, North Dakota, US | |
3990194 | 3990194 | 2022-09-15 | US | Wisconsin | Menominee | 55078 | 2173 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-09-16 04:21:19 | Menominee, Wisconsin, US | |
1889809 | 1889809 | 2022-09-14 | US | Colorado | Yuma | 8125 | 2173 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-09-15 04:21:02 | Yuma, Colorado, US | |
1889655 | 1889655 | 2022-09-14 | US | Arkansas | Monroe | 5095 | 2173 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-09-15 04:21:02 | Monroe, Arkansas, US | |
372710 | 372710 | 2022-09-13 | US | Arkansas | Monroe | 5095 | 2173 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-09-14 04:20:44 | Monroe, Arkansas, US | |
2347000 | 2347000 | 2022-08-31 | US | Wisconsin | Pepin | 55091 | 2173 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-09-01 04:21:03 | Pepin, Wisconsin, US | |
2831235 | 2831235 | 2022-08-25 | US | North Dakota | Pembina | 38067 | 2173 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-08-26 04:21:02 | Pembina, North Dakota, US | |
2325768 | 2325768 | 2022-08-24 | US | North Dakota | Pembina | 38067 | 2173 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-08-25 04:21:13 | Pembina, North Dakota, US | |
1488914 | 1488914 | 2022-07-26 | US | Kansas | Norton | 20137 | 2173 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-27 04:21:04 | Norton, Kansas, US | |
2595360 | 2595360 | 2022-07-25 | US | Kansas | Norton | 20137 | 2173 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-26 04:20:58 | Norton, Kansas, US | |
897475 | 897475 | 2022-07-24 | US | Kansas | Norton | 20137 | 2173 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-25 04:20:51 | Norton, Kansas, US | |
92469 | 92469 | 2022-07-23 | US | Kansas | Norton | 20137 | 2173 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-24 04:20:47 | Norton, Kansas, US | |
901491 | 901491 | 2022-07-22 | US | Kansas | Norton | 20137 | 2173 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-23 04:20:53 | Norton, Kansas, US | |
671627 | 671627 | 2022-07-21 | US | Kansas | Norton | 20137 | 2173 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-22 04:21:15 | Norton, Kansas, US | |
1609590 | 1609590 | 2022-07-20 | US | Kansas | Norton | 20137 | 2173 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-21 04:21:10 | Norton, Kansas, US | |
2239798 | 2239798 | 2022-06-28 | US | Alabama | Perry | 1105 | 2173 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-06-29 04:20:59 | Perry, Alabama, US | |
938632 | 938632 | 2022-06-25 | China | Yunnan | 2173 | 2 | 0 | 24.974 | 101.487 | 2022-06-26 04:21:02 | Yunnan, China | |||
2190664 | 2190664 | 2022-06-22 | US | Texas | Clay | 48077 | 2173 | 35 | 0 | 33.78686685 | -98.20771198 | 2022-06-23 04:20:55 | Clay, Texas, US | |
1766488 | 1766488 | 2022-06-20 | US | Texas | Live Oak | 48297 | 2173 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-21 04:20:56 | Live Oak, Texas, US | |
3272674 | 3272674 | 2022-06-19 | US | Texas | Live Oak | 48297 | 2173 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-20 04:21:01 | Live Oak, Texas, US | |
3158575 | 3158575 | 2022-06-09 | US | Idaho | Fremont | 16043 | 2173 | 28 | 0 | 44.22800938 | -111.4809943 | 2022-06-10 04:20:55 | Fremont, Idaho, US | |
1422042 | 1422042 | 2022-06-08 | US | Idaho | Fremont | 16043 | 2173 | 28 | 0 | 44.22800938 | -111.4809943 | 2022-06-09 04:20:54 | Fremont, Idaho, US | |
3889649 | 3889649 | 2022-06-06 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-07 04:21:08 | Sanders, Montana, US | |
3509418 | 3509418 | 2022-06-05 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-06 04:20:57 | Sanders, Montana, US | |
3529495 | 3529495 | 2022-06-04 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-05 04:20:55 | Sanders, Montana, US | |
3135581 | 3135581 | 2022-06-03 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-04 04:20:58 | Sanders, Montana, US | |
3580656 | 3580656 | 2022-06-02 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-03 04:20:58 | Sanders, Montana, US | |
972949 | 972949 | 2022-06-01 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-02 05:20:39 | Sanders, Montana, US | |
231256 | 231256 | 2022-05-31 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-06-01 04:20:55 | Sanders, Montana, US | |
230091 | 230091 | 2022-05-31 | US | Georgia | Pulaski | 13235 | 2173 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-06-01 04:20:55 | Pulaski, Georgia, US | |
3188021 | 3188021 | 2022-05-30 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-05-31 04:20:51 | Sanders, Montana, US | |
3186856 | 3186856 | 2022-05-30 | US | Georgia | Pulaski | 13235 | 2173 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-05-31 04:20:51 | Pulaski, Georgia, US | |
3200170 | 3200170 | 2022-05-29 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-05-30 04:20:50 | Sanders, Montana, US | |
3199005 | 3199005 | 2022-05-29 | US | Georgia | Pulaski | 13235 | 2173 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-05-30 04:20:50 | Pulaski, Georgia, US | |
2727048 | 2727048 | 2022-05-28 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-05-29 04:20:53 | Sanders, Montana, US | |
2725883 | 2725883 | 2022-05-28 | US | Georgia | Pulaski | 13235 | 2173 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-05-29 04:20:53 | Pulaski, Georgia, US | |
1316229 | 1316229 | 2022-05-27 | US | Montana | Sanders | 30089 | 2173 | 51 | 0 | 47.67657534 | -115.1329916 | 2022-05-28 04:21:07 | Sanders, Montana, US | |
1315064 | 1315064 | 2022-05-27 | US | Georgia | Pulaski | 13235 | 2173 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-05-28 04:21:07 | Pulaski, Georgia, US | |
1851897 | 1851897 | 2022-05-26 | US | Missouri | Gentry | 29075 | 2173 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-27 04:20:56 | Gentry, Missouri, US | |
1850856 | 1850856 | 2022-05-26 | US | Georgia | Pulaski | 13235 | 2173 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-05-27 04:20:56 | Pulaski, Georgia, US | |
2049773 | 2049773 | 2022-05-25 | US | Missouri | Gentry | 29075 | 2173 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-26 04:20:50 | Gentry, Missouri, US | |
2048732 | 2048732 | 2022-05-25 | US | Georgia | Pulaski | 13235 | 2173 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-05-26 04:20:50 | Pulaski, Georgia, US | |
3001211 | 3001211 | 2022-05-24 | US | Missouri | Gentry | 29075 | 2173 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-25 04:20:56 | Gentry, Missouri, US | |
3594932 | 3594932 | 2022-05-23 | US | Missouri | Gentry | 29075 | 2173 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-24 04:20:57 | Gentry, Missouri, US | |
3594755 | 3594755 | 2022-05-23 | US | Minnesota | Jackson | 27063 | 2173 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-05-24 04:20:57 | Jackson, Minnesota, US | |
623784 | 623784 | 2022-05-22 | US | Missouri | Gentry | 29075 | 2173 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-26 04:20:50 | Gentry, Missouri, US | |
622743 | 622743 | 2022-05-22 | US | Georgia | Pulaski | 13235 | 2173 | 78 | 0 | 32.23334561 | -83.4754996 | 2022-05-26 04:20:50 | Pulaski, Georgia, US | |
1111480 | 1111480 | 2022-05-21 | US | Missouri | Gentry | 29075 | 2173 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-22 04:20:52 | Gentry, Missouri, US | |
1111303 | 1111303 | 2022-05-21 | US | Minnesota | Jackson | 27063 | 2173 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-05-22 04:20:52 | Jackson, Minnesota, US | |
1171104 | 1171104 | 2022-05-20 | US | Missouri | Gentry | 29075 | 2173 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-21 04:20:58 | Gentry, Missouri, US | |
1170927 | 1170927 | 2022-05-20 | US | Minnesota | Jackson | 27063 | 2173 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-05-21 04:20:58 | Jackson, Minnesota, US | |
3583464 | 3583464 | 2022-05-17 | US | Georgia | Heard | 13149 | 2173 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-05-18 04:20:50 | Heard, Georgia, US | |
1504421 | 1504421 | 2022-05-16 | US | Georgia | Heard | 13149 | 2173 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-05-17 04:20:59 | Heard, Georgia, US | |
2085075 | 2085075 | 2022-05-15 | US | Indiana | Martin | 18101 | 2173 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-16 04:20:47 | Martin, Indiana, US | |
2084780 | 2084780 | 2022-05-15 | US | Georgia | Heard | 13149 | 2173 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-05-16 04:20:47 | Heard, Georgia, US | |
3355785 | 3355785 | 2022-05-14 | US | Indiana | Martin | 18101 | 2173 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-15 04:20:53 | Martin, Indiana, US | |
3355490 | 3355490 | 2022-05-14 | US | Georgia | Heard | 13149 | 2173 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-05-15 04:20:53 | Heard, Georgia, US | |
659430 | 659430 | 2022-05-13 | US | Indiana | Martin | 18101 | 2173 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-14 04:20:48 | Martin, Indiana, US | |
659135 | 659135 | 2022-05-13 | US | Georgia | Heard | 13149 | 2173 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-05-14 04:20:48 | Heard, Georgia, US | |
2534218 | 2534218 | 2022-05-12 | US | Georgia | Heard | 13149 | 2173 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-05-13 04:20:51 | Heard, Georgia, US | |
3445664 | 3445664 | 2022-05-11 | US | Georgia | Heard | 13149 | 2173 | 54 | 0 | 33.29686567 | -85.12886832 | 2022-05-12 04:20:54 | Heard, Georgia, US | |
3536576 | 3536576 | 2022-05-10 | US | Indiana | Martin | 18101 | 2173 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-11 04:20:48 | Martin, Indiana, US | |
223706 | 223706 | 2022-05-09 | US | Minnesota | Clearwater | 27029 | 2173 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-05-10 04:20:50 | Clearwater, Minnesota, US | |
223111 | 223111 | 2022-05-09 | US | Indiana | Martin | 18101 | 2173 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-05-10 04:20:50 | Martin, Indiana, US | |
1699104 | 1699104 | 2022-04-28 | US | Puerto Rico | Patillas | 72109 | 2173 | 0 | 0 | 18.03174 | -66.012242 | 2022-04-29 04:20:59 | Patillas, Puerto Rico, US | |
3725585 | 3725585 | 2022-04-25 | US | Virginia | Northumberland | 51133 | 2173 | 46 | 0 | 37.89202088 | -76.41949732 | 2022-04-26 04:20:51 | Northumberland, Virginia, US | |
3418296 | 3418296 | 2022-04-17 | US | Kentucky | Bracken | 21023 | 2173 | 26 | 0 | 38.69158994 | -84.08532444 | 2022-04-18 04:21:12 | Bracken, Kentucky, US | |
305245 | 305245 | 2022-04-16 | US | Kentucky | Bracken | 21023 | 2173 | 26 | 0 | 38.69158994 | -84.08532444 | 2022-04-17 04:20:59 | Bracken, Kentucky, US | |
2671190 | 2671190 | 2022-04-15 | US | Kentucky | Bracken | 21023 | 2173 | 26 | 0 | 38.69158994 | -84.08532444 | 2022-04-16 04:20:48 | Bracken, Kentucky, US | |
1224975 | 1224975 | 2022-04-14 | US | Kentucky | Bracken | 21023 | 2173 | 26 | 0 | 38.69158994 | -84.08532444 | 2022-04-15 04:20:57 | Bracken, Kentucky, US | |
2444133 | 2444133 | 2022-04-13 | US | Kentucky | Bracken | 21023 | 2173 | 26 | 0 | 38.69158994 | -84.08532444 | 2022-04-13 23:21:06 | Bracken, Kentucky, US | |
1949890 | 1949890 | 2022-04-12 | US | Kentucky | Bracken | 21023 | 2173 | 26 | 0 | 38.69158994 | -84.08532444 | 2022-04-13 04:21:03 | Bracken, Kentucky, US | |
3208085 | 3208085 | 2022-04-11 | US | Mississippi | Kemper | 28069 | 2173 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-04-12 04:20:49 | Kemper, Mississippi, US | |
3207643 | 3207643 | 2022-04-11 | US | Kentucky | Bracken | 21023 | 2173 | 26 | 0 | 38.69158994 | -84.08532444 | 2022-04-12 04:20:49 | Bracken, Kentucky, US | |
1577971 | 1577971 | 2022-04-10 | US | Mississippi | Kemper | 28069 | 2173 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-04-11 04:21:02 | Kemper, Mississippi, US | |
1654213 | 1654213 | 2022-04-09 | US | Mississippi | Kemper | 28069 | 2173 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-04-10 04:20:52 | Kemper, Mississippi, US | |
2117535 | 2117535 | 2022-04-08 | US | Mississippi | Kemper | 28069 | 2173 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-04-09 04:20:42 | Kemper, Mississippi, US | |
3322059 | 3322059 | 2022-04-07 | US | Mississippi | Kemper | 28069 | 2173 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-04-08 04:20:48 | Kemper, Mississippi, US | |
2802713 | 2802713 | 2022-04-06 | US | Missouri | Monroe | 29137 | 2173 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-04-07 04:20:53 | Monroe, Missouri, US | |
2802595 | 2802595 | 2022-04-06 | US | Mississippi | Kemper | 28069 | 2173 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-04-07 04:20:53 | Kemper, Mississippi, US | |
3869482 | 3869482 | 2022-04-05 | US | Missouri | Monroe | 29137 | 2173 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-04-06 04:20:49 | Monroe, Missouri, US | |
3869364 | 3869364 | 2022-04-05 | US | Mississippi | Kemper | 28069 | 2173 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-04-06 04:20:49 | Kemper, Mississippi, US | |
2750824 | 2750824 | 2022-04-04 | US | Missouri | Monroe | 29137 | 2173 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-04-05 04:20:48 | Monroe, Missouri, US | |
2750706 | 2750706 | 2022-04-04 | US | Mississippi | Kemper | 28069 | 2173 | 48 | 0 | 32.75462946 | -88.64105766 | 2022-04-05 04:20:48 | Kemper, Mississippi, US | |
3732170 | 3732170 | 2022-04-03 | US | Missouri | Monroe | 29137 | 2173 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-04-04 04:20:51 | Monroe, Missouri, US | |
3731227 | 3731227 | 2022-04-03 | US | Illinois | Hamilton | 17065 | 2173 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-04-04 04:20:51 | Hamilton, Illinois, US | |
501605 | 501605 | 2022-04-02 | US | Missouri | Monroe | 29137 | 2173 | 42 | 0 | 39.49593978 | -92.00043978 | 2022-04-03 04:20:48 | Monroe, Missouri, 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]);