johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
250 rows where confirmed = 2991 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1623039 | 1623039 | 2022-11-22 | US | Puerto Rico | Maunabo | 72095 | 2991 | 0 | 0 | 18.017889 | -65.922235 | 2022-11-23 04:21:06 | Maunabo, Puerto Rico, US | |
480266 | 480266 | 2022-11-08 | US | Connecticut | Unassigned | 90009 | 2991 | 9 | 0 | 41.85853803 | 0.0 | 2022-11-09 04:21:22 | Unassigned, Connecticut, US | |
1595173 | 1595173 | 2022-10-21 | US | Tennessee | Lake | 47095 | 2991 | 45 | 0 | 36.3418017 | -89.48921915 | 2022-10-22 04:22:53 | Lake, Tennessee, US | |
2033276 | 2033276 | 2022-10-14 | US | Arkansas | Fulton | 5049 | 2991 | 97 | 0 | 36.38177105 | -91.81729127 | 2022-10-15 04:22:00 | Fulton, Arkansas, US | |
3253178 | 3253178 | 2022-10-11 | US | Texas | Blanco | 48031 | 2991 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-10-12 04:22:51 | Blanco, Texas, US | |
2970437 | 2970437 | 2022-10-10 | US | Texas | Blanco | 48031 | 2991 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-10-11 04:23:05 | Blanco, Texas, US | |
2377044 | 2377044 | 2022-09-29 | US | Louisiana | Catahoula | 22025 | 2991 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-09-30 04:23:09 | Catahoula, Louisiana, US | |
1561595 | 1561595 | 2022-09-28 | US | Louisiana | Catahoula | 22025 | 2991 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-09-29 04:22:34 | Catahoula, Louisiana, US | |
3995816 | 3995816 | 2022-09-27 | US | Iowa | Chickasaw | 19037 | 2991 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-28 04:23:01 | Chickasaw, Iowa, US | |
2770144 | 2770144 | 2022-09-26 | US | Iowa | Chickasaw | 19037 | 2991 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-27 04:23:01 | Chickasaw, Iowa, US | |
1977797 | 1977797 | 2022-09-25 | US | Iowa | Chickasaw | 19037 | 2991 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-26 04:20:52 | Chickasaw, Iowa, US | |
2650964 | 2650964 | 2022-09-24 | US | Iowa | Chickasaw | 19037 | 2991 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-25 04:23:31 | Chickasaw, Iowa, US | |
385404 | 385404 | 2022-09-23 | US | Iowa | Chickasaw | 19037 | 2991 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-24 04:21:40 | Chickasaw, Iowa, US | |
1625470 | 1625470 | 2022-09-22 | US | Iowa | Chickasaw | 19037 | 2991 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-23 04:23:13 | Chickasaw, Iowa, US | |
1371674 | 1371674 | 2022-09-21 | US | Iowa | Chickasaw | 19037 | 2991 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-22 04:22:56 | Chickasaw, Iowa, US | |
420843 | 420843 | 2022-09-18 | US | Louisiana | East Carroll | 22035 | 2991 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-09-19 04:21:49 | East Carroll, Louisiana, US | |
3374867 | 3374867 | 2022-09-17 | US | Louisiana | East Carroll | 22035 | 2991 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-09-18 04:22:50 | East Carroll, Louisiana, US | |
2356975 | 2356975 | 2022-09-16 | US | Louisiana | East Carroll | 22035 | 2991 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-09-17 04:20:19 | East Carroll, Louisiana, US | |
3768293 | 3768293 | 2022-09-11 | US | North Dakota | McLean | 38055 | 2991 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-09-12 04:20:58 | McLean, North Dakota, US | |
3747854 | 3747854 | 2022-09-07 | US | Puerto Rico | Guanica | 72055 | 2991 | 0 | 0 | 17.982429 | -66.919643 | 2022-09-08 04:21:02 | Guanica, Puerto Rico, US | |
2324350 | 2324350 | 2022-08-24 | US | Illinois | Jasper | 17079 | 2991 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-08-25 04:21:13 | Jasper, Illinois, US | |
3953829 | 3953829 | 2022-08-17 | US | Virginia | Falls Church | 51610 | 2991 | 18 | 0 | 38.88485255 | -77.17560759 | 2022-08-18 04:21:11 | Falls Church, Virginia, US | |
1101420 | 1101420 | 2022-08-03 | US | Virginia | Amelia | 51007 | 2991 | 59 | 0 | 37.34081025 | -77.98584649 | 2022-08-04 04:20:58 | Amelia, Virginia, US | |
674108 | 674108 | 2022-07-30 | China | Heilongjiang | 2991 | 13 | 0 | 47.862 | 127.7615 | 2022-07-31 04:21:02 | Heilongjiang, China | |||
2790055 | 2790055 | 2022-07-10 | US | Illinois | Marshall | 17123 | 2991 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-07-11 04:20:46 | Marshall, Illinois, US | |
143008 | 143008 | 2022-07-09 | US | Illinois | Marshall | 17123 | 2991 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-07-10 04:20:54 | Marshall, Illinois, US | |
1418108 | 1418108 | 2022-07-08 | US | Illinois | Marshall | 17123 | 2991 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-07-09 04:20:59 | Marshall, Illinois, US | |
3967052 | 3967052 | 2022-07-05 | US | Arkansas | Lee | 5077 | 2991 | 61 | 0 | 34.78498904 | -90.78383866 | 2022-07-06 04:20:58 | Lee, Arkansas, US | |
973553 | 973553 | 2022-06-01 | US | Oregon | Morrow | 41049 | 2991 | 34 | 0 | 45.41846568 | -119.584546 | 2022-06-02 05:20:39 | Morrow, Oregon, US | |
232134 | 232134 | 2022-05-31 | US | South Dakota | Todd | 46121 | 2991 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-06-01 04:20:55 | Todd, South Dakota, US | |
3188899 | 3188899 | 2022-05-30 | US | South Dakota | Todd | 46121 | 2991 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-31 04:20:51 | Todd, South Dakota, US | |
3201048 | 3201048 | 2022-05-29 | US | South Dakota | Todd | 46121 | 2991 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-30 04:20:50 | Todd, South Dakota, US | |
2727926 | 2727926 | 2022-05-28 | US | South Dakota | Todd | 46121 | 2991 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-29 04:20:53 | Todd, South Dakota, US | |
1317107 | 1317107 | 2022-05-27 | US | South Dakota | Todd | 46121 | 2991 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-28 04:21:07 | Todd, South Dakota, US | |
1852899 | 1852899 | 2022-05-26 | US | South Dakota | Todd | 46121 | 2991 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-27 04:20:56 | Todd, South Dakota, US | |
2050775 | 2050775 | 2022-05-25 | US | South Dakota | Todd | 46121 | 2991 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-26 04:20:50 | Todd, South Dakota, US | |
624786 | 624786 | 2022-05-22 | US | South Dakota | Todd | 46121 | 2991 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-05-26 04:20:50 | Todd, South Dakota, US | |
3584423 | 3584423 | 2022-05-17 | US | Minnesota | Watonwan | 27165 | 2991 | 23 | 0 | 43.97823903 | -94.61413846 | 2022-05-18 04:20:50 | Watonwan, Minnesota, US | |
2307754 | 2307754 | 2022-04-20 | US | Arkansas | Bradley | 5011 | 2991 | 49 | 0 | 33.46755808 | -92.15980837 | 2022-04-21 04:20:46 | Bradley, Arkansas, US | |
2251893 | 2251893 | 2022-04-19 | US | Arkansas | Bradley | 5011 | 2991 | 49 | 0 | 33.46755808 | -92.15980837 | 2022-04-20 04:20:45 | Bradley, Arkansas, US | |
262092 | 262092 | 2022-03-15 | US | California | Mariposa | 6043 | 2991 | 30 | 0 | 37.57978556 | -119.9073334 | 2022-03-16 04:20:50 | Mariposa, California, US | |
2264451 | 2264451 | 2022-03-14 | US | California | Mariposa | 6043 | 2991 | 30 | 0 | 37.57978556 | -119.9073334 | 2022-03-15 04:20:47 | Mariposa, California, US | |
1548008 | 1548008 | 2022-03-07 | Kiribati | 2991 | 12 | 0 | -3.3704 | -168.734 | 2022-03-08 04:20:54 | Kiribati | ||||
1995240 | 1995240 | 2022-03-01 | US | Oklahoma | Noble | 40103 | 2991 | 36 | 0 | 36.38953329 | -97.22928674 | 2022-03-02 04:21:07 | Noble, Oklahoma, US | |
945414 | 945414 | 2022-02-28 | US | Oklahoma | Noble | 40103 | 2991 | 36 | 0 | 36.38953329 | -97.22928674 | 2022-03-01 04:21:09 | Noble, Oklahoma, US | |
2735605 | 2735605 | 2022-02-27 | US | Oklahoma | Noble | 40103 | 2991 | 36 | 0 | 36.38953329 | -97.22928674 | 2022-02-28 04:21:05 | Noble, Oklahoma, US | |
3048758 | 3048758 | 2022-02-26 | US | Oklahoma | Noble | 40103 | 2991 | 36 | 0 | 36.38953329 | -97.22928674 | 2022-02-27 04:21:04 | Noble, Oklahoma, US | |
577413 | 577413 | 2022-02-25 | US | Oklahoma | Noble | 40103 | 2991 | 36 | 0 | 36.38953329 | -97.22928674 | 2022-02-26 04:21:12 | Noble, Oklahoma, US | |
1514873 | 1514873 | 2022-02-24 | US | Washington | Unassigned | 90053 | 2991 | 7 | 0 | 48.82227976 | 0.0 | 2022-02-25 04:21:11 | Unassigned, Washington, US | |
1513989 | 1513989 | 2022-02-24 | US | Oklahoma | Noble | 40103 | 2991 | 36 | 0 | 36.38953329 | -97.22928674 | 2022-02-25 04:21:11 | Noble, Oklahoma, US | |
1060430 | 1060430 | 2022-02-23 | US | Oklahoma | Noble | 40103 | 2991 | 36 | 0 | 36.38953329 | -97.22928674 | 2022-02-24 04:21:14 | Noble, Oklahoma, US | |
187567 | 187567 | 2022-02-13 | US | Louisiana | Caldwell | 22021 | 2991 | 46 | 0 | 32.0902519 | -92.11752148 | 2022-02-14 04:20:51 | Caldwell, Louisiana, US | |
317501 | 317501 | 2022-02-12 | US | Maryland | Kent | 24029 | 2991 | 64 | 0 | 39.24976208 | -76.04741541 | 2022-02-13 04:21:00 | Kent, Maryland, US | |
317413 | 317413 | 2022-02-12 | US | Louisiana | Caldwell | 22021 | 2991 | 46 | 0 | 32.0902519 | -92.11752148 | 2022-02-13 04:21:00 | Caldwell, Louisiana, US | |
234739 | 234739 | 2022-02-11 | US | Louisiana | Caldwell | 22021 | 2991 | 46 | 0 | 32.0902519 | -92.11752148 | 2022-02-12 04:21:06 | Caldwell, Louisiana, US | |
1464966 | 1464966 | 2022-02-10 | US | Georgia | Telfair | 13271 | 2991 | 76 | 0 | 31.92829517 | -82.93491155 | 2022-02-11 04:21:09 | Telfair, Georgia, US | |
1362992 | 1362992 | 2022-02-08 | US | Colorado | Moffat | 8081 | 2991 | 52 | 0 | 40.61810999 | -108.2070876 | 2022-02-09 04:21:04 | Moffat, Colorado, US | |
461314 | 461314 | 2022-02-02 | US | Missouri | Mississippi | 29133 | 2991 | 52 | 0 | 36.82516239 | -89.29505753 | 2022-02-03 04:21:21 | Mississippi, Missouri, US | |
2659503 | 2659503 | 2022-01-31 | US | Minnesota | Cottonwood | 27033 | 2991 | 38 | 0 | 44.00715262 | -95.18138802 | 2022-02-01 04:21:11 | Cottonwood, Minnesota, US | |
1230087 | 1230087 | 2022-01-24 | US | Ohio | Harrison | 39067 | 2991 | 69 | 0 | 40.29380509 | -81.09068544 | 2022-01-25 04:21:05 | Harrison, Ohio, US | |
1144262 | 1144262 | 2022-01-23 | US | Virginia | Greensville | 51081 | 2991 | 30 | 0 | 36.67878901 | -77.56351439 | 2022-01-24 04:21:12 | Greensville, Virginia, US | |
2836180 | 2836180 | 2022-01-22 | US | Virginia | Greensville | 51081 | 2991 | 30 | 0 | 36.67878901 | -77.56351439 | 2022-01-23 04:21:13 | Greensville, Virginia, US | |
3428298 | 3428298 | 2022-01-21 | US | Virginia | Greensville | 51081 | 2991 | 30 | 0 | 36.67878901 | -77.56351439 | 2022-01-22 04:21:13 | Greensville, Virginia, US | |
3227902 | 3227902 | 2022-01-19 | US | Kentucky | Monroe | 21171 | 2991 | 69 | 0 | 36.71225341 | -85.71596443 | 2022-01-20 04:21:07 | Monroe, Kentucky, US | |
1472313 | 1472313 | 2022-01-17 | Russia | Chukotka Autonomous Okrug | 2991 | 39 | 0 | 66.0006475 | 169.4900869 | 2022-01-18 04:21:04 | Chukotka Autonomous Okrug, Russia | |||
555915 | 555915 | 2022-01-16 | US | Indiana | Parke | 18121 | 2991 | 38 | 0 | 39.77202286 | -87.20375833 | 2022-01-17 04:21:08 | Parke, Indiana, US | |
3841636 | 3841636 | 2022-01-15 | US | Indiana | Parke | 18121 | 2991 | 38 | 0 | 39.77202286 | -87.20375833 | 2022-01-16 04:21:12 | Parke, Indiana, US | |
100451 | 100451 | 2022-01-14 | US | Indiana | Parke | 18121 | 2991 | 38 | 0 | 39.77202286 | -87.20375833 | 2022-01-15 04:21:07 | Parke, Indiana, US | |
3688608 | 3688608 | 2022-01-13 | US | Indiana | Pike | 18125 | 2991 | 45 | 0 | 38.40112197 | -87.23574907 | 2022-01-14 04:21:54 | Pike, Indiana, US | |
1287941 | 1287941 | 2022-01-04 | US | Missouri | Moniteau | 29135 | 2991 | 46 | 0 | 38.63571781 | -92.57976951 | 2022-01-05 04:21:59 | Moniteau, Missouri, US | |
1286944 | 1286944 | 2022-01-04 | US | Idaho | Gem | 16045 | 2991 | 72 | 0 | 44.06482372 | -116.398376 | 2022-01-05 04:21:59 | Gem, Idaho, US | |
1671995 | 1671995 | 2021-12-29 | US | Wisconsin | Crawford | 55023 | 2991 | 25 | 0 | 43.23870316 | -90.93073686 | 2021-12-30 04:21:25 | Crawford, Wisconsin, US | |
731354 | 731354 | 2021-12-27 | US | Georgia | Jeff Davis | 13161 | 2991 | 63 | 0 | 31.80405727 | -82.63724870000001 | 2021-12-28 04:21:47 | Jeff Davis, Georgia, US | |
2966513 | 2966513 | 2021-12-24 | US | Texas | Houston | 48225 | 2991 | 89 | 0 | 31.31925973 | -95.42226208 | 2021-12-25 04:21:37 | Houston, Texas, US | |
3829439 | 3829439 | 2021-12-21 | US | Illinois | Cass | 17017 | 2991 | 31 | 0 | 39.96991073 | -90.24734436 | 2021-12-22 04:21:54 | Cass, Illinois, US | |
405267 | 405267 | 2021-12-07 | US | Illinois | Clay | 17025 | 2991 | 54 | 0 | 38.75388572 | -88.48914513 | 2021-12-08 04:22:46 | Clay, Illinois, US | |
1233348 | 1233348 | 2021-11-28 | US | Minnesota | Fillmore | 27045 | 2991 | 15 | 0 | 43.67394126 | -92.08980382 | 2021-11-29 04:22:30 | Fillmore, Minnesota, US | |
1360055 | 1360055 | 2021-11-27 | US | Minnesota | Fillmore | 27045 | 2991 | 15 | 0 | 43.67394126 | -92.08980382 | 2021-11-28 04:22:43 | Fillmore, Minnesota, US | |
760046 | 760046 | 2021-11-26 | US | Minnesota | Fillmore | 27045 | 2991 | 15 | 0 | 43.67394126 | -92.08980382 | 2021-11-27 04:22:45 | Fillmore, Minnesota, US | |
759780 | 759780 | 2021-11-26 | US | Kentucky | Morgan | 21175 | 2991 | 11 | 0 | 37.92465657 | -83.25558245 | 2021-11-27 04:22:45 | Morgan, Kentucky, US | |
1804197 | 1804197 | 2021-11-25 | US | Kentucky | Morgan | 21175 | 2991 | 11 | 0 | 37.92465657 | -83.25558245 | 2021-11-26 04:22:33 | Morgan, Kentucky, US | |
3748976 | 3748976 | 2021-11-22 | Colombia | Vichada | 2991 | 53 | 0 | 4.4234 | -69.2878 | 2021-11-23 04:22:39 | Vichada, Colombia | |||
1014183 | 1014183 | 2021-11-21 | Colombia | Vichada | 2991 | 53 | 0 | 4.4234 | -69.2878 | 2021-11-22 04:22:20 | Vichada, Colombia | |||
448749 | 448749 | 2021-11-17 | US | Kentucky | Breckinridge | 21027 | 2991 | 36 | 0 | 37.77377239 | -86.42885017 | 2021-11-18 04:21:33 | Breckinridge, Kentucky, US | |
28547 | 28547 | 2021-11-11 | Netherlands | Unknown | 2991 | 25 | 0 | 2021-11-12 04:22:01 | Unknown, Netherlands | |||||
88840 | 88840 | 2021-11-09 | US | Minnesota | Dodge | 27039 | 2991 | 11 | 0 | 44.02238415 | -92.86244324 | 2021-11-10 04:21:38 | Dodge, Minnesota, US | |
2002285 | 2002285 | 2021-11-07 | US | Michigan | Cheboygan | 26031 | 2991 | 68 | 0 | 45.44787015 | -84.50122149 | 2021-11-08 04:21:43 | Cheboygan, Michigan, US | |
497276 | 497276 | 2021-11-06 | US | Michigan | Cheboygan | 26031 | 2991 | 68 | 0 | 45.44787015 | -84.50122149 | 2021-11-07 04:21:53 | Cheboygan, Michigan, US | |
3123131 | 3123131 | 2021-11-05 | US | Michigan | Cheboygan | 26031 | 2991 | 68 | 0 | 45.44787015 | -84.50122149 | 2021-11-06 04:21:51 | Cheboygan, Michigan, US | |
278861 | 278861 | 2021-11-03 | US | Pennsylvania | Juniata | 42067 | 2991 | 116 | 0 | 40.53358749 | -77.39975129999998 | 2021-11-04 04:22:20 | Juniata, Pennsylvania, US | |
3513379 | 3513379 | 2021-11-01 | US | Missouri | Texas | 29215 | 2991 | 42 | 0 | 37.31728859 | -91.96564727 | 2021-11-02 04:22:03 | Texas, Missouri, US | |
568226 | 568226 | 2021-10-29 | US | Indiana | Orange | 18117 | 2991 | 64 | 0 | 38.54118920000001 | -86.49523093 | 2021-10-30 04:22:03 | Orange, Indiana, US | |
5045 | 5045 | 2021-10-28 | US | Florida | Gulf | 12045 | 2991 | 45 | 0 | 29.93543004 | -85.24270990000002 | 2021-10-29 04:22:03 | Gulf, Florida, US | |
537726 | 537726 | 2021-10-27 | US | Tennessee | Sequatchie | 47153 | 2991 | 33 | 0 | 35.36979721 | -85.41022136 | 2021-10-28 04:22:08 | Sequatchie, Tennessee, US | |
535435 | 535435 | 2021-10-27 | US | Florida | Gulf | 12045 | 2991 | 45 | 0 | 29.93543004 | -85.24270990000002 | 2021-10-28 04:22:08 | Gulf, Florida, US | |
3492872 | 3492872 | 2021-10-26 | US | Florida | Gulf | 12045 | 2991 | 45 | 0 | 29.93543004 | -85.24270990000002 | 2021-10-27 04:22:32 | Gulf, Florida, US | |
3794594 | 3794594 | 2021-10-25 | US | Florida | Gulf | 12045 | 2991 | 45 | 0 | 29.93543004 | -85.24270990000002 | 2021-10-26 04:22:09 | Gulf, Florida, US | |
683040 | 683040 | 2021-10-24 | US | Florida | Gulf | 12045 | 2991 | 45 | 0 | 29.93543004 | -85.24270990000002 | 2021-10-25 04:22:31 | Gulf, Florida, US | |
771048 | 771048 | 2021-10-23 | US | Florida | Gulf | 12045 | 2991 | 45 | 0 | 29.93543004 | -85.24270990000002 | 2021-10-24 04:21:22 | Gulf, Florida, US | |
654695 | 654695 | 2021-10-22 | US | Florida | Gulf | 12045 | 2991 | 45 | 0 | 29.93543004 | -85.24270990000002 | 2021-10-23 04:21:32 | Gulf, Florida, 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]);