johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
409 rows where confirmed = 1627 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309136 | 309136 | 2022-12-13 | US | Iowa | Van Buren | 19177 | 1627 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-12-14 04:21:04 | Van Buren, Iowa, US | |
1150197 | 1150197 | 2022-12-12 | US | Iowa | Van Buren | 19177 | 1627 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-12-13 04:21:01 | Van Buren, Iowa, US | |
870051 | 870051 | 2022-12-11 | US | Iowa | Van Buren | 19177 | 1627 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-12-12 04:21:01 | Van Buren, Iowa, US | |
258581 | 258581 | 2022-12-10 | US | Iowa | Van Buren | 19177 | 1627 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-12-11 04:20:50 | Van Buren, Iowa, US | |
3937295 | 3937295 | 2022-12-09 | US | Iowa | Van Buren | 19177 | 1627 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-12-10 04:21:02 | Van Buren, Iowa, US | |
3378627 | 3378627 | 2022-12-08 | US | Iowa | Van Buren | 19177 | 1627 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-12-09 04:21:05 | Van Buren, Iowa, US | |
1985898 | 1985898 | 2022-12-07 | US | Iowa | Van Buren | 19177 | 1627 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-12-08 04:21:07 | Van Buren, Iowa, US | |
2559499 | 2559499 | 2022-11-29 | US | South Dakota | Tripp | 46123 | 1627 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-11-30 04:21:07 | Tripp, South Dakota, US | |
1242573 | 1242573 | 2022-11-28 | US | South Dakota | Tripp | 46123 | 1627 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-11-29 04:21:05 | Tripp, South Dakota, US | |
3554561 | 3554561 | 2022-11-27 | US | South Dakota | Tripp | 46123 | 1627 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-11-28 04:21:02 | Tripp, South Dakota, US | |
2103041 | 2103041 | 2022-11-26 | US | South Dakota | Tripp | 46123 | 1627 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-11-27 04:21:05 | Tripp, South Dakota, US | |
490532 | 490532 | 2022-11-25 | US | South Dakota | Tripp | 46123 | 1627 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-11-26 04:21:11 | Tripp, South Dakota, US | |
3526361 | 3526361 | 2022-11-24 | US | South Dakota | Tripp | 46123 | 1627 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-11-25 04:21:06 | Tripp, South Dakota, US | |
3315144 | 3315144 | 2022-11-23 | US | South Dakota | Tripp | 46123 | 1627 | 27 | 0 | 43.34459388 | -99.8854891 | 2022-11-24 04:21:09 | Tripp, South Dakota, US | |
1623181 | 1623181 | 2022-11-22 | US | South Dakota | Spink | 46115 | 1627 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-11-23 04:21:06 | Spink, South Dakota, US | |
1621208 | 1621208 | 2022-11-22 | US | Idaho | Caribou | 16029 | 1627 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-11-23 04:21:06 | Caribou, Idaho, US | |
3463069 | 3463069 | 2022-11-21 | US | South Dakota | Spink | 46115 | 1627 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-11-22 04:20:47 | Spink, South Dakota, US | |
3461096 | 3461096 | 2022-11-21 | US | Idaho | Caribou | 16029 | 1627 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-11-22 04:20:47 | Caribou, Idaho, US | |
1643254 | 1643254 | 2022-11-20 | US | South Dakota | Spink | 46115 | 1627 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-11-21 04:21:05 | Spink, South Dakota, US | |
1641281 | 1641281 | 2022-11-20 | US | Idaho | Caribou | 16029 | 1627 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-11-21 04:21:05 | Caribou, Idaho, US | |
2066811 | 2066811 | 2022-11-19 | US | South Dakota | Spink | 46115 | 1627 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-11-20 04:21:08 | Spink, South Dakota, US | |
2064838 | 2064838 | 2022-11-19 | US | Idaho | Caribou | 16029 | 1627 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-11-20 04:21:08 | Caribou, Idaho, US | |
1758205 | 1758205 | 2022-11-18 | US | South Dakota | Spink | 46115 | 1627 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-11-19 04:21:14 | Spink, South Dakota, US | |
1756232 | 1756232 | 2022-11-18 | US | Idaho | Caribou | 16029 | 1627 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-11-19 04:21:14 | Caribou, Idaho, US | |
3029198 | 3029198 | 2022-11-17 | US | South Dakota | Spink | 46115 | 1627 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-11-18 04:21:15 | Spink, South Dakota, US | |
3027225 | 3027225 | 2022-11-17 | US | Idaho | Caribou | 16029 | 1627 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-11-18 04:21:15 | Caribou, Idaho, US | |
2488909 | 2488909 | 2022-11-16 | US | South Dakota | Spink | 46115 | 1627 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-11-17 04:21:11 | Spink, South Dakota, US | |
2486936 | 2486936 | 2022-11-16 | US | Idaho | Caribou | 16029 | 1627 | 34 | 0 | 42.77149116 | -111.5597683 | 2022-11-17 04:21:11 | Caribou, Idaho, US | |
481273 | 481273 | 2022-11-08 | US | Michigan | Oscoda | 26135 | 1627 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-11-09 04:21:22 | Oscoda, Michigan, US | |
481252 | 481252 | 2022-11-08 | US | Michigan | Luce | 26095 | 1627 | 18 | 0 | 46.47227431 | -85.54471223 | 2022-11-09 04:21:22 | Luce, Michigan, US | |
2440423 | 2440423 | 2022-11-07 | US | Michigan | Oscoda | 26135 | 1627 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-11-08 04:21:21 | Oscoda, Michigan, US | |
2440402 | 2440402 | 2022-11-07 | US | Michigan | Luce | 26095 | 1627 | 18 | 0 | 46.47227431 | -85.54471223 | 2022-11-08 04:21:21 | Luce, Michigan, US | |
1051521 | 1051521 | 2022-11-06 | US | Michigan | Oscoda | 26135 | 1627 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-11-07 04:21:26 | Oscoda, Michigan, US | |
1051500 | 1051500 | 2022-11-06 | US | Michigan | Luce | 26095 | 1627 | 18 | 0 | 46.47227431 | -85.54471223 | 2022-11-07 04:21:26 | Luce, Michigan, US | |
619545 | 619545 | 2022-11-05 | US | Michigan | Oscoda | 26135 | 1627 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-11-06 04:21:24 | Oscoda, Michigan, US | |
619524 | 619524 | 2022-11-05 | US | Michigan | Luce | 26095 | 1627 | 18 | 0 | 46.47227431 | -85.54471223 | 2022-11-06 04:21:24 | Luce, Michigan, US | |
1024049 | 1024049 | 2022-11-04 | US | Michigan | Oscoda | 26135 | 1627 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-11-05 04:21:52 | Oscoda, Michigan, US | |
1024028 | 1024028 | 2022-11-04 | US | Michigan | Luce | 26095 | 1627 | 18 | 0 | 46.47227431 | -85.54471223 | 2022-11-05 04:21:52 | Luce, Michigan, US | |
433040 | 433040 | 2022-11-03 | US | Michigan | Oscoda | 26135 | 1627 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-11-04 04:22:11 | Oscoda, Michigan, US | |
433019 | 433019 | 2022-11-03 | US | Michigan | Luce | 26095 | 1627 | 18 | 0 | 46.47227431 | -85.54471223 | 2022-11-04 04:22:11 | Luce, Michigan, US | |
851282 | 851282 | 2022-11-02 | US | Michigan | Oscoda | 26135 | 1627 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-11-03 04:22:05 | Oscoda, Michigan, US | |
851261 | 851261 | 2022-11-02 | US | Michigan | Luce | 26095 | 1627 | 18 | 0 | 46.47227431 | -85.54471223 | 2022-11-03 04:22:05 | Luce, Michigan, US | |
712133 | 712133 | 2022-11-01 | US | Michigan | Oscoda | 26135 | 1627 | 59 | 0 | 44.68192279 | -84.12939244 | 2022-11-02 04:22:09 | Oscoda, Michigan, US | |
712112 | 712112 | 2022-11-01 | US | Michigan | Luce | 26095 | 1627 | 18 | 0 | 46.47227431 | -85.54471223 | 2022-11-02 04:22:09 | Luce, Michigan, US | |
198072 | 198072 | 2022-10-19 | China | Xinjiang | 1627 | 3 | 0 | 41.1129 | 85.2401 | 2022-10-20 04:22:59 | Xinjiang, China | |||
2531255 | 2531255 | 2022-10-06 | US | Missouri | Atchison | 29005 | 1627 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-10-07 04:23:08 | Atchison, Missouri, US | |
1812649 | 1812649 | 2022-10-05 | US | Missouri | Atchison | 29005 | 1627 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-10-06 04:21:22 | Atchison, Missouri, US | |
133883 | 133883 | 2022-10-04 | US | Texas | Jack | 48237 | 1627 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-10-05 04:23:06 | Jack, Texas, US | |
132623 | 132623 | 2022-10-04 | US | Missouri | Atchison | 29005 | 1627 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-10-05 04:23:06 | Atchison, Missouri, US | |
2688830 | 2688830 | 2022-10-03 | US | Texas | Jack | 48237 | 1627 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-10-04 04:22:55 | Jack, Texas, US | |
2687570 | 2687570 | 2022-10-03 | US | Missouri | Atchison | 29005 | 1627 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-10-04 04:22:55 | Atchison, Missouri, US | |
2262897 | 2262897 | 2022-10-02 | US | Texas | Jack | 48237 | 1627 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-10-03 04:23:11 | Jack, Texas, US | |
2261637 | 2261637 | 2022-10-02 | US | Missouri | Atchison | 29005 | 1627 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-10-03 04:23:11 | Atchison, Missouri, US | |
2998423 | 2998423 | 2022-10-01 | US | Texas | Jack | 48237 | 1627 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-10-02 04:21:23 | Jack, Texas, US | |
2997163 | 2997163 | 2022-10-01 | US | Missouri | Atchison | 29005 | 1627 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-10-02 04:21:23 | Atchison, Missouri, US | |
856749 | 856749 | 2022-09-30 | US | Texas | Jack | 48237 | 1627 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-10-01 04:23:01 | Jack, Texas, US | |
855489 | 855489 | 2022-09-30 | US | Missouri | Atchison | 29005 | 1627 | 23 | 0 | 40.43238737 | -95.42970639 | 2022-10-01 04:23:01 | Atchison, Missouri, US | |
2378675 | 2378675 | 2022-09-29 | US | Texas | Jack | 48237 | 1627 | 30 | 0 | 33.23377248 | -98.17283469 | 2022-09-30 04:23:09 | Jack, Texas, US | |
1880174 | 1880174 | 2022-08-28 | US | Texas | Newton | 48351 | 1627 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-29 04:21:06 | Newton, Texas, US | |
2099301 | 2099301 | 2022-08-27 | US | Texas | Newton | 48351 | 1627 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-28 04:21:02 | Newton, Texas, US | |
1535116 | 1535116 | 2022-08-26 | US | Texas | Newton | 48351 | 1627 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-08-27 04:20:57 | Newton, Texas, US | |
3951484 | 3951484 | 2022-08-17 | US | Illinois | Gallatin | 17059 | 1627 | 20 | 0 | 37.76430935 | -88.22953869 | 2022-08-18 04:21:11 | Gallatin, Illinois, US | |
3967601 | 3967601 | 2022-07-05 | US | Illinois | Stark | 17175 | 1627 | 36 | 0 | 41.09309773 | -89.79745866 | 2022-07-06 04:20:58 | Stark, Illinois, US | |
2149486 | 2149486 | 2022-06-27 | US | Mississippi | Quitman | 28119 | 1627 | 31 | 0 | 34.25157572 | -90.28908 | 2022-06-28 04:20:58 | Quitman, Mississippi, US | |
477287 | 477287 | 2022-06-26 | US | Mississippi | Quitman | 28119 | 1627 | 31 | 0 | 34.25157572 | -90.28908 | 2022-06-27 04:21:00 | Quitman, Mississippi, US | |
940662 | 940662 | 2022-06-25 | US | Mississippi | Quitman | 28119 | 1627 | 31 | 0 | 34.25157572 | -90.28908 | 2022-06-26 04:21:02 | Quitman, Mississippi, US | |
3348482 | 3348482 | 2022-06-24 | US | Mississippi | Quitman | 28119 | 1627 | 31 | 0 | 34.25157572 | -90.28908 | 2022-06-25 04:20:57 | Quitman, Mississippi, US | |
1650223 | 1650223 | 2022-06-23 | US | Mississippi | Quitman | 28119 | 1627 | 31 | 0 | 34.25157572 | -90.28908 | 2022-06-24 04:20:58 | Quitman, Mississippi, US | |
2189458 | 2189458 | 2022-06-22 | US | Mississippi | Quitman | 28119 | 1627 | 31 | 0 | 34.25157572 | -90.28908 | 2022-06-23 04:20:55 | Quitman, Mississippi, US | |
167889 | 167889 | 2022-06-21 | US | Mississippi | Quitman | 28119 | 1627 | 31 | 0 | 34.25157572 | -90.28908 | 2022-06-22 04:20:54 | Quitman, Mississippi, US | |
2238404 | 2238404 | 2022-06-12 | US | Texas | Bailey | 48017 | 1627 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-13 04:21:14 | Bailey, Texas, US | |
3144602 | 3144602 | 2022-06-11 | US | Texas | Bailey | 48017 | 1627 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-12 04:20:53 | Bailey, Texas, US | |
1947518 | 1947518 | 2022-06-10 | US | Texas | Bailey | 48017 | 1627 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-11 04:21:01 | Bailey, Texas, US | |
3160657 | 3160657 | 2022-06-09 | US | Texas | Bailey | 48017 | 1627 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-10 04:20:55 | Bailey, Texas, US | |
1424124 | 1424124 | 2022-06-08 | US | Texas | Bailey | 48017 | 1627 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-09 04:20:54 | Bailey, Texas, US | |
3729238 | 3729238 | 2022-06-07 | US | Texas | Bailey | 48017 | 1627 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-06-08 04:20:55 | Bailey, Texas, US | |
231617 | 231617 | 2022-05-31 | US | North Dakota | Bottineau | 38009 | 1627 | 26 | 0 | 48.79106111 | -100.8378166 | 2022-06-01 04:20:55 | Bottineau, North Dakota, US | |
2724807 | 2724807 | 2022-05-28 | China | Guangxi | 1627 | 2 | 0 | 23.8298 | 108.7881 | 2022-05-29 04:20:53 | Guangxi, China | |||
3206875 | 3206875 | 2022-04-11 | US | Colorado | Clear Creek | 8019 | 1627 | 12 | 0 | 39.68864463 | -105.6463118 | 2022-04-12 04:20:49 | Clear Creek, Colorado, US | |
2478859 | 2478859 | 2022-03-30 | US | Georgia | Treutlen | 13283 | 1627 | 60 | 0 | 32.40422134 | -82.56904553 | 2022-03-31 04:20:56 | Treutlen, Georgia, US | |
158900 | 158900 | 2022-03-29 | US | Georgia | Treutlen | 13283 | 1627 | 60 | 0 | 32.40422134 | -82.56904553 | 2022-03-30 04:20:45 | Treutlen, Georgia, US | |
950649 | 950649 | 2022-03-12 | China | Beijing | 1627 | 9 | 0 | 40.1824 | 116.4142 | 2022-03-13 04:20:49 | Beijing, China | |||
1867259 | 1867259 | 2022-03-10 | US | Minnesota | Wilkin | 27167 | 1627 | 22 | 0 | 46.35721532 | -96.4684375 | 2022-03-11 04:20:50 | Wilkin, Minnesota, US | |
3077471 | 3077471 | 2022-02-09 | US | Virginia | Williamsburg | 51830 | 1627 | 13 | 0 | 37.28131268 | -76.70905141 | 2022-02-10 04:21:14 | Williamsburg, Virginia, US | |
2016014 | 2016014 | 2022-02-06 | US | Virginia | Bland | 51021 | 1627 | 19 | 0 | 37.13128068 | -81.13599391 | 2022-02-07 04:21:05 | Bland, Virginia, US | |
2014439 | 2014439 | 2022-02-06 | US | Minnesota | Lac qui Parle | 27073 | 1627 | 28 | 0 | 44.9973857 | -96.17488219 | 2022-02-07 04:21:05 | Lac qui Parle, Minnesota, US | |
1297343 | 1297343 | 2022-02-05 | US | Virginia | Bland | 51021 | 1627 | 19 | 0 | 37.13128068 | -81.13599391 | 2022-02-06 04:21:00 | Bland, Virginia, US | |
1295768 | 1295768 | 2022-02-05 | US | Minnesota | Lac qui Parle | 27073 | 1627 | 28 | 0 | 44.9973857 | -96.17488219 | 2022-02-06 04:21:00 | Lac qui Parle, Minnesota, US | |
2330671 | 2330671 | 2022-02-04 | US | Virginia | Bland | 51021 | 1627 | 19 | 0 | 37.13128068 | -81.13599391 | 2022-02-05 04:21:05 | Bland, Virginia, US | |
2329096 | 2329096 | 2022-02-04 | US | Minnesota | Lac qui Parle | 27073 | 1627 | 28 | 0 | 44.9973857 | -96.17488219 | 2022-02-05 04:21:05 | Lac qui Parle, Minnesota, US | |
2476082 | 2476082 | 2022-02-03 | US | Nebraska | Thurston | 31173 | 1627 | 11 | 0 | 42.15725356 | -96.54157099 | 2022-02-04 04:21:10 | Thurston, Nebraska, US | |
1473161 | 1473161 | 2022-01-17 | US | Illinois | Schuyler | 17169 | 1627 | 15 | 0 | 40.157179799999994 | -90.61114163 | 2022-01-18 04:21:04 | Schuyler, Illinois, US | |
555835 | 555835 | 2022-01-16 | US | Illinois | Schuyler | 17169 | 1627 | 15 | 0 | 40.157179799999994 | -90.61114163 | 2022-01-17 04:21:08 | Schuyler, Illinois, US | |
3841556 | 3841556 | 2022-01-15 | US | Illinois | Schuyler | 17169 | 1627 | 15 | 0 | 40.157179799999994 | -90.61114163 | 2022-01-16 04:21:12 | Schuyler, Illinois, US | |
100371 | 100371 | 2022-01-14 | US | Illinois | Schuyler | 17169 | 1627 | 15 | 0 | 40.157179799999994 | -90.61114163 | 2022-01-15 04:21:07 | Schuyler, Illinois, US | |
3613728 | 3613728 | 2022-01-12 | US | Colorado | Yuma | 8125 | 1627 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-01-13 08:00:09 | Yuma, Colorado, US | |
1116768 | 1116768 | 2022-01-11 | US | Texas | Mitchell | 48335 | 1627 | 44 | 0 | 32.30623474 | -100.9212058 | 2022-01-12 04:21:44 | Mitchell, Texas, US | |
1114741 | 1114741 | 2022-01-11 | US | Indiana | Warren | 18171 | 1627 | 20 | 0 | 40.34728141 | -87.35602659 | 2022-01-12 04:21:44 | Warren, Indiana, US | |
127244 | 127244 | 2022-01-09 | US | Arkansas | Nevada | 5099 | 1627 | 43 | 0 | 33.66340119 | -93.30632432 | 2022-01-10 04:22:07 | Nevada, Arkansas, US | |
127207 | 127207 | 2022-01-09 | US | Arkansas | Cleveland | 5025 | 1627 | 33 | 0 | 33.89723187 | -92.18537045 | 2022-01-10 04:22:07 | Cleveland, Arkansas, 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]);