johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
227 rows where confirmed = 3063 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328870 | 328870 | 2022-12-27 | US | Idaho | Valley | 16085 | 3063 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-28 04:21:04 | Valley, Idaho, US | |
218943 | 218943 | 2022-12-26 | US | Idaho | Valley | 16085 | 3063 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-27 04:21:07 | Valley, Idaho, US | |
218470 | 218470 | 2022-12-26 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-27 04:21:07 | Fulton, Arkansas, US | |
3223400 | 3223400 | 2022-12-25 | US | Idaho | Valley | 16085 | 3063 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-26 04:21:06 | Valley, Idaho, US | |
3222927 | 3222927 | 2022-12-25 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-26 04:21:06 | Fulton, Arkansas, US | |
1019314 | 1019314 | 2022-12-24 | US | Idaho | Valley | 16085 | 3063 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-25 04:21:04 | Valley, Idaho, US | |
1018841 | 1018841 | 2022-12-24 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-25 04:21:04 | Fulton, Arkansas, US | |
691337 | 691337 | 2022-12-23 | US | Idaho | Valley | 16085 | 3063 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-24 04:21:02 | Valley, Idaho, US | |
690864 | 690864 | 2022-12-23 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-24 04:21:02 | Fulton, Arkansas, US | |
2180547 | 2180547 | 2022-12-22 | US | Idaho | Valley | 16085 | 3063 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-23 04:21:04 | Valley, Idaho, US | |
2180074 | 2180074 | 2022-12-22 | US | Arkansas | Fulton | 5049 | 3063 | 99 | 0 | 36.38177105 | -91.81729127 | 2022-12-23 04:21:04 | Fulton, Arkansas, US | |
454353 | 454353 | 2022-12-21 | US | Tennessee | Lake | 47095 | 3063 | 46 | 0 | 36.3418017 | -89.48921915 | 2022-12-22 04:20:56 | Lake, Tennessee, US | |
452351 | 452351 | 2022-12-21 | US | Idaho | Valley | 16085 | 3063 | 17 | 0 | 44.76728382 | -115.5676773 | 2022-12-22 04:20:56 | Valley, Idaho, US | |
2952262 | 2952262 | 2022-12-20 | US | Georgia | Screven | 13251 | 3063 | 75 | 0 | 32.74976524 | -81.60779441 | 2022-12-21 04:21:03 | Screven, Georgia, US | |
3174664 | 3174664 | 2022-12-19 | US | Georgia | Screven | 13251 | 3063 | 75 | 0 | 32.74976524 | -81.60779441 | 2022-12-20 04:21:04 | Screven, Georgia, US | |
1629181 | 1629181 | 2022-12-18 | US | Georgia | Screven | 13251 | 3063 | 75 | 0 | 32.74976524 | -81.60779441 | 2022-12-19 04:21:03 | Screven, Georgia, US | |
504560 | 504560 | 2022-12-17 | US | Georgia | Screven | 13251 | 3063 | 75 | 0 | 32.74976524 | -81.60779441 | 2022-12-18 04:21:03 | Screven, Georgia, US | |
3325132 | 3325132 | 2022-12-16 | US | Georgia | Screven | 13251 | 3063 | 75 | 0 | 32.74976524 | -81.60779441 | 2022-12-17 04:21:04 | Screven, Georgia, US | |
543644 | 543644 | 2022-12-15 | US | Georgia | Screven | 13251 | 3063 | 75 | 0 | 32.74976524 | -81.60779441 | 2022-12-16 04:21:01 | Screven, Georgia, US | |
349172 | 349172 | 2022-12-14 | US | Georgia | Screven | 13251 | 3063 | 75 | 0 | 32.74976524 | -81.60779441 | 2022-12-15 04:20:58 | Screven, Georgia, US | |
721830 | 721830 | 2022-12-04 | US | Virginia | Galax | 51640 | 3063 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-05 04:20:58 | Galax, Virginia, US | |
2820119 | 2820119 | 2022-12-03 | US | Virginia | Galax | 51640 | 3063 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-04 04:20:56 | Galax, Virginia, US | |
836975 | 836975 | 2022-12-02 | US | Virginia | Galax | 51640 | 3063 | 83 | 0 | 36.66601852 | -80.91703124 | 2022-12-03 04:21:02 | Galax, Virginia, US | |
1621542 | 1621542 | 2022-11-22 | US | Kansas | Brown | 20013 | 3063 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-11-23 04:21:06 | Brown, Kansas, US | |
3461430 | 3461430 | 2022-11-21 | US | Kansas | Brown | 20013 | 3063 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-11-22 04:20:47 | Brown, Kansas, US | |
1641615 | 1641615 | 2022-11-20 | US | Kansas | Brown | 20013 | 3063 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-11-21 04:21:05 | Brown, Kansas, US | |
2065172 | 2065172 | 2022-11-19 | US | Kansas | Brown | 20013 | 3063 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-11-20 04:21:08 | Brown, Kansas, US | |
1756566 | 1756566 | 2022-11-18 | US | Kansas | Brown | 20013 | 3063 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-11-19 04:21:14 | Brown, Kansas, US | |
1755112 | 1755112 | 2022-11-18 | China | Yunnan | 3063 | 2 | 0 | 24.974 | 101.487 | 2022-11-19 04:21:14 | Yunnan, China | |||
3027559 | 3027559 | 2022-11-17 | US | Kansas | Brown | 20013 | 3063 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-11-18 04:21:15 | Brown, Kansas, US | |
2487270 | 2487270 | 2022-11-16 | US | Kansas | Brown | 20013 | 3063 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-11-17 04:21:11 | Brown, Kansas, US | |
852016 | 852016 | 2022-11-02 | US | North Dakota | McLean | 38055 | 3063 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-11-03 04:22:05 | McLean, North Dakota, US | |
797797 | 797797 | 2022-10-24 | US | Virginia | Nelson | 51125 | 3063 | 38 | 0 | 37.78790447 | -78.88498513 | 2022-10-25 04:21:53 | Nelson, Virginia, US | |
133609 | 133609 | 2022-10-04 | US | South Dakota | Butte | 46019 | 3063 | 47 | 0 | 44.90608745 | -103.5079318 | 2022-10-05 04:23:06 | Butte, South Dakota, US | |
2688556 | 2688556 | 2022-10-03 | US | South Dakota | Butte | 46019 | 3063 | 47 | 0 | 44.90608745 | -103.5079318 | 2022-10-04 04:22:55 | Butte, South Dakota, US | |
2262623 | 2262623 | 2022-10-02 | US | South Dakota | Butte | 46019 | 3063 | 47 | 0 | 44.90608745 | -103.5079318 | 2022-10-03 04:23:11 | Butte, South Dakota, US | |
2998149 | 2998149 | 2022-10-01 | US | South Dakota | Butte | 46019 | 3063 | 47 | 0 | 44.90608745 | -103.5079318 | 2022-10-02 04:21:23 | Butte, South Dakota, US | |
856475 | 856475 | 2022-09-30 | US | South Dakota | Butte | 46019 | 3063 | 47 | 0 | 44.90608745 | -103.5079318 | 2022-10-01 04:23:01 | Butte, South Dakota, US | |
2378401 | 2378401 | 2022-09-29 | US | South Dakota | Butte | 46019 | 3063 | 47 | 0 | 44.90608745 | -103.5079318 | 2022-09-30 04:23:09 | Butte, South Dakota, US | |
1562952 | 1562952 | 2022-09-28 | US | South Dakota | Butte | 46019 | 3063 | 47 | 0 | 44.90608745 | -103.5079318 | 2022-09-29 04:22:34 | Butte, South Dakota, US | |
1372268 | 1372268 | 2022-09-21 | US | Minnesota | Stevens | 27149 | 3063 | 15 | 0 | 45.58613007 | -96.00163705 | 2022-09-22 04:22:56 | Stevens, Minnesota, US | |
2018498 | 2018498 | 2022-09-20 | US | Minnesota | Stevens | 27149 | 3063 | 15 | 0 | 45.58613007 | -96.00163705 | 2022-09-21 04:23:22 | Stevens, Minnesota, US | |
3572371 | 3572371 | 2022-09-19 | US | Minnesota | Stevens | 27149 | 3063 | 15 | 0 | 45.58613007 | -96.00163705 | 2022-09-20 04:22:48 | Stevens, Minnesota, US | |
421110 | 421110 | 2022-09-18 | US | Minnesota | Stevens | 27149 | 3063 | 15 | 0 | 45.58613007 | -96.00163705 | 2022-09-19 04:21:49 | Stevens, Minnesota, US | |
3375134 | 3375134 | 2022-09-17 | US | Minnesota | Stevens | 27149 | 3063 | 15 | 0 | 45.58613007 | -96.00163705 | 2022-09-18 04:22:50 | Stevens, Minnesota, US | |
2357242 | 2357242 | 2022-09-16 | US | Minnesota | Stevens | 27149 | 3063 | 15 | 0 | 45.58613007 | -96.00163705 | 2022-09-17 04:20:19 | Stevens, Minnesota, US | |
3988399 | 3988399 | 2022-09-15 | US | Minnesota | Stevens | 27149 | 3063 | 15 | 0 | 45.58613007 | -96.00163705 | 2022-09-16 04:21:19 | Stevens, Minnesota, US | |
1254008 | 1254008 | 2022-08-23 | US | Texas | Ward | 48475 | 3063 | 47 | 0 | 31.50999644 | -103.0927909 | 2022-08-24 04:20:46 | Ward, Texas, US | |
1162720 | 1162720 | 2022-08-18 | US | Louisiana | West Feliciana | 22125 | 3063 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-08-19 04:20:54 | West Feliciana, Louisiana, US | |
3952044 | 3952044 | 2022-08-17 | US | Louisiana | West Feliciana | 22125 | 3063 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-08-18 04:21:11 | West Feliciana, Louisiana, US | |
3617583 | 3617583 | 2022-08-01 | US | Arkansas | Lee | 5077 | 3063 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-08-02 04:20:53 | Lee, Arkansas, US | |
1068921 | 1068921 | 2022-07-28 | US | Texas | Camp | 48063 | 3063 | 76 | 0 | 32.97195142 | -94.97790104 | 2022-07-29 04:20:45 | Camp, Texas, US | |
2421075 | 2421075 | 2022-07-15 | US | New Jersey | Unassigned | 90034 | 3063 | 0 | 0 | 41.13891592 | 0.0 | 2022-07-16 04:21:05 | Unassigned, New Jersey, US | |
559290 | 559290 | 2022-06-16 | US | Arkansas | Desha | 5041 | 3063 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-06-17 04:20:56 | Desha, Arkansas, US | |
1852736 | 1852736 | 2022-05-26 | US | Puerto Rico | Guayanilla | 72059 | 3063 | 0 | 0 | 18.039942 | -66.79186 | 2022-05-27 04:20:56 | Guayanilla, Puerto Rico, US | |
3723786 | 3723786 | 2022-04-25 | US | Maryland | Kent | 24029 | 3063 | 66 | 0 | 39.24976208 | -76.04741541 | 2022-04-26 04:20:51 | Kent, Maryland, US | |
3722761 | 3722761 | 2022-04-25 | US | California | Mariposa | 6043 | 3063 | 34 | 0 | 37.57978556 | -119.9073334 | 2022-04-26 04:20:51 | Mariposa, California, US | |
2320463 | 2320463 | 2022-03-16 | US | Indiana | Pulaski | 18131 | 3063 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-03-17 04:20:56 | Pulaski, Indiana, US | |
262663 | 262663 | 2022-03-15 | US | Indiana | Pulaski | 18131 | 3063 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-03-16 04:20:50 | Pulaski, Indiana, US | |
2265022 | 2265022 | 2022-03-14 | US | Indiana | Pulaski | 18131 | 3063 | 83 | 0 | 41.04166107 | -86.69890683 | 2022-03-15 04:20:47 | Pulaski, Indiana, US | |
3672722 | 3672722 | 2022-02-15 | US | Indiana | Blackford | 18009 | 3063 | 62 | 0 | 40.47388153 | -85.32499702 | 2022-02-16 04:21:10 | Blackford, Indiana, US | |
2477482 | 2477482 | 2022-02-03 | US | Wisconsin | Ashland | 55003 | 3063 | 30 | 0 | 46.31956891 | -90.67837132 | 2022-02-04 04:21:10 | Ashland, Wisconsin, US | |
3064499 | 3064499 | 2022-01-29 | US | Ohio | Noble | 39121 | 3063 | 55 | 0 | 39.76818851 | -81.45937183 | 2022-01-30 04:21:26 | Noble, Ohio, US | |
3064410 | 3064410 | 2022-01-29 | US | North Dakota | McKenzie | 38053 | 3063 | 23 | 0 | 47.74133370000001 | -103.395905 | 2022-01-30 04:21:26 | McKenzie, North Dakota, US | |
3810130 | 3810130 | 2022-01-28 | Russia | Chukotka Autonomous Okrug | 3063 | 40 | 0 | 66.0006475 | 169.4900869 | 2022-01-29 04:21:10 | Chukotka Autonomous Okrug, Russia | |||
1320969 | 1320969 | 2022-01-26 | US | Puerto Rico | Lares | 72081 | 3063 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-01-27 04:21:19 | Lares, Puerto Rico, US | |
1320650 | 1320650 | 2022-01-26 | US | North Dakota | Walsh | 38099 | 3063 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-01-27 04:21:19 | Walsh, North Dakota, US | |
2053343 | 2053343 | 2022-01-25 | US | Kentucky | Pendleton | 21191 | 3063 | 32 | 0 | 38.69607718 | -84.35599463 | 2022-01-26 04:21:07 | Pendleton, Kentucky, US | |
1229052 | 1229052 | 2022-01-24 | US | Kentucky | Magoffin | 21153 | 3063 | 37 | 0 | 37.70820545 | -83.0657714 | 2022-01-25 04:21:05 | Magoffin, Kentucky, US | |
3427217 | 3427217 | 2022-01-21 | US | New York | Schuyler | 36097 | 3063 | 23 | 0 | 42.39184015 | -76.8773299 | 2022-01-22 04:21:13 | Schuyler, New York, US | |
3229754 | 3229754 | 2022-01-19 | US | Virginia | Appomattox | 51011 | 3063 | 39 | 0 | 37.37569884 | -78.81340003 | 2022-01-20 04:21:07 | Appomattox, Virginia, US | |
558348 | 558348 | 2022-01-16 | US | Wisconsin | Lafayette | 55065 | 3063 | 18 | 0 | 42.66005229 | -90.1317729 | 2022-01-17 04:21:08 | Lafayette, Wisconsin, US | |
3844069 | 3844069 | 2022-01-15 | US | Wisconsin | Lafayette | 55065 | 3063 | 18 | 0 | 42.66005229 | -90.1317729 | 2022-01-16 04:21:12 | Lafayette, Wisconsin, US | |
102884 | 102884 | 2022-01-14 | US | Wisconsin | Lafayette | 55065 | 3063 | 18 | 0 | 42.66005229 | -90.1317729 | 2022-01-15 04:21:07 | Lafayette, Wisconsin, US | |
3688105 | 3688105 | 2022-01-13 | US | Colorado | Gunnison | 8051 | 3063 | 13 | 0 | 38.66611652 | -107.0320729 | 2022-01-14 04:21:54 | Gunnison, Colorado, US | |
1114095 | 1114095 | 2022-01-11 | US | Arkansas | Madison | 5087 | 3063 | 47 | 0 | 36.01038185 | -93.72524943 | 2022-01-12 04:21:44 | Madison, Arkansas, US | |
1695346 | 1695346 | 2022-01-10 | US | Texas | Bosque | 48035 | 3063 | 59 | 0 | 31.89978581 | -97.63613524 | 2022-01-11 04:22:01 | Bosque, Texas, US | |
1694446 | 1694446 | 2022-01-10 | US | Nebraska | Unassigned | 90031 | 3063 | 1238 | 0 | 42.8997274 | 0.0 | 2022-01-11 04:22:01 | Unassigned, Nebraska, US | |
1693705 | 1693705 | 2022-01-10 | US | Kentucky | Casey | 21045 | 3063 | 62 | 0 | 37.32533118 | -84.92726209 | 2022-01-11 04:22:01 | Casey, Kentucky, US | |
1701406 | 1701406 | 2022-01-03 | US | Illinois | Warren | 17187 | 3063 | 72 | 0 | 40.84925021 | -90.6147432 | 2022-01-04 04:22:17 | Warren, Illinois, US | |
2777482 | 2777482 | 2021-12-31 | US | Arkansas | Grant | 5053 | 3063 | 52 | 0 | 34.29017991 | -92.42320562 | 2022-01-01 04:22:14 | Grant, Arkansas, US | |
1436159 | 1436159 | 2021-12-28 | US | Wisconsin | Washburn | 55129 | 3063 | 34 | 0 | 45.89838588 | -91.79050449 | 2021-12-29 03:21:43 | Washburn, Wisconsin, US | |
1433986 | 1433986 | 2021-12-28 | US | Kentucky | Jackson | 21109 | 3063 | 58 | 0 | 37.41866422 | -83.99825483 | 2021-12-29 03:21:43 | Jackson, Kentucky, US | |
1432320 | 1432320 | 2021-12-28 | Canada | Newfoundland and Labrador | 3063 | 18 | 0 | 53.1355 | -57.6604 | 2021-12-29 03:21:43 | Newfoundland and Labrador, Canada | |||
733619 | 733619 | 2021-12-27 | US | Texas | Freestone | 48161 | 3063 | 73 | 0 | 31.70422788 | -96.15072516 | 2021-12-28 04:21:47 | Freestone, Texas, US | |
799489 | 799489 | 2021-12-22 | US | Illinois | White | 17193 | 3063 | 33 | 0 | 38.08706198 | -88.17657461 | 2021-12-23 04:21:21 | White, Illinois, US | |
3831624 | 3831624 | 2021-12-21 | US | Texas | Lee | 48287 | 3063 | 54 | 0 | 30.31120597 | -96.97045773 | 2021-12-22 04:21:54 | Lee, Texas, US | |
1257927 | 1257927 | 2021-12-20 | US | Texas | Lee | 48287 | 3063 | 54 | 0 | 30.31120597 | -96.97045773 | 2021-12-21 03:21:27 | Lee, Texas, US | |
2906870 | 2906870 | 2021-12-19 | US | Texas | Lee | 48287 | 3063 | 54 | 0 | 30.31120597 | -96.97045773 | 2021-12-20 04:21:43 | Lee, Texas, US | |
3497593 | 3497593 | 2021-12-15 | US | Kentucky | Garrard | 21079 | 3063 | 55 | 0 | 37.638866799999995 | -84.53289319 | 2021-12-16 04:22:11 | Garrard, Kentucky, US | |
1667662 | 1667662 | 2021-12-11 | US | Texas | Shelby | 48419 | 3063 | 113 | 0 | 31.79211404 | -94.14550696 | 2021-12-12 04:22:12 | Shelby, Texas, US | |
3658814 | 3658814 | 2021-12-10 | US | Texas | Shelby | 48419 | 3063 | 113 | 0 | 31.79211404 | -94.14550696 | 2021-12-11 04:22:45 | Shelby, Texas, US | |
407725 | 407725 | 2021-12-07 | US | Washington | Asotin | 53003 | 3063 | 51 | 0 | 46.18894415 | -117.2022851 | 2021-12-08 04:22:46 | Asotin, Washington, US | |
404784 | 404784 | 2021-12-07 | US | Arkansas | Hempstead | 5057 | 3063 | 44 | 0 | 33.73325583 | -93.66935133 | 2021-12-08 04:22:46 | Hempstead, Arkansas, US | |
404774 | 404774 | 2021-12-07 | US | Arkansas | Cross | 5037 | 3063 | 68 | 0 | 35.29631396 | -90.77185818 | 2021-12-08 04:22:46 | Cross, Arkansas, US | |
1033807 | 1033807 | 2021-12-06 | US | Washington | Asotin | 53003 | 3063 | 51 | 0 | 46.18894415 | -117.2022851 | 2021-12-07 04:22:34 | Asotin, Washington, US | |
1232671 | 1232671 | 2021-11-28 | US | Illinois | Richland | 17159 | 3063 | 59 | 0 | 38.71240969 | -88.08475366 | 2021-11-29 04:22:30 | Richland, Illinois, US | |
1359378 | 1359378 | 2021-11-27 | US | Illinois | Richland | 17159 | 3063 | 59 | 0 | 38.71240969 | -88.08475366 | 2021-11-28 04:22:43 | Richland, Illinois, US | |
759369 | 759369 | 2021-11-26 | US | Illinois | Richland | 17159 | 3063 | 59 | 0 | 38.71240969 | -88.08475366 | 2021-11-27 04:22:45 | Richland, Illinois, US | |
1803786 | 1803786 | 2021-11-25 | US | Illinois | Richland | 17159 | 3063 | 59 | 0 | 38.71240969 | -88.08475366 | 2021-11-26 04:22:33 | Richland, Illinois, 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]);