johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
347 rows where confirmed = 1937 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3462053 | 3462053 | 2022-11-21 | US | Missouri | Chariton | 29041 | 1937 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-22 04:20:47 | Chariton, Missouri, US | |
1642238 | 1642238 | 2022-11-20 | US | Missouri | Chariton | 29041 | 1937 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-21 04:21:05 | Chariton, Missouri, US | |
2065795 | 2065795 | 2022-11-19 | US | Missouri | Chariton | 29041 | 1937 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-20 04:21:08 | Chariton, Missouri, US | |
1757189 | 1757189 | 2022-11-18 | US | Missouri | Chariton | 29041 | 1937 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-19 04:21:14 | Chariton, Missouri, US | |
3028182 | 3028182 | 2022-11-17 | US | Missouri | Chariton | 29041 | 1937 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-18 04:21:15 | Chariton, Missouri, US | |
2487893 | 2487893 | 2022-11-16 | US | Missouri | Chariton | 29041 | 1937 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-17 04:21:11 | Chariton, Missouri, US | |
293904 | 293904 | 2022-11-15 | US | Missouri | Chariton | 29041 | 1937 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-16 04:21:09 | Chariton, Missouri, US | |
2162701 | 2162701 | 2022-10-16 | US | Texas | Marion | 48315 | 1937 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-17 04:20:31 | Marion, Texas, US | |
518898 | 518898 | 2022-10-15 | US | Texas | Marion | 48315 | 1937 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-16 04:22:39 | Marion, Texas, US | |
2035955 | 2035955 | 2022-10-14 | US | Texas | Marion | 48315 | 1937 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-15 04:22:00 | Marion, Texas, US | |
3753990 | 3753990 | 2022-10-13 | US | Arkansas | Newton | 5101 | 1937 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-10-14 04:22:28 | Newton, Arkansas, US | |
3214815 | 3214815 | 2022-10-12 | US | Arkansas | Newton | 5101 | 1937 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-10-13 04:22:39 | Newton, Arkansas, US | |
3250664 | 3250664 | 2022-10-11 | US | Arkansas | Newton | 5101 | 1937 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-10-12 04:22:51 | Newton, Arkansas, US | |
2967923 | 2967923 | 2022-10-10 | US | Arkansas | Newton | 5101 | 1937 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-10-11 04:23:05 | Newton, Arkansas, US | |
3097959 | 3097959 | 2022-10-09 | US | Arkansas | Newton | 5101 | 1937 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-10-10 04:22:32 | Newton, Arkansas, US | |
4003184 | 4003184 | 2022-10-08 | US | Arkansas | Newton | 5101 | 1937 | 51 | 0 | 35.91947491 | -93.21612969 | 2022-10-09 04:21:16 | Newton, Arkansas, US | |
1880059 | 1880059 | 2022-08-28 | US | Texas | Delta | 48119 | 1937 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-08-29 04:21:06 | Delta, Texas, US | |
2099186 | 2099186 | 2022-08-27 | US | Texas | Delta | 48119 | 1937 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-08-28 04:21:02 | Delta, Texas, US | |
1535001 | 1535001 | 2022-08-26 | US | Texas | Delta | 48119 | 1937 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-08-27 04:20:57 | Delta, Texas, US | |
1408304 | 1408304 | 2022-08-02 | US | Texas | Winkler | 48495 | 1937 | 34 | 0 | 31.85008651 | -103.0485163 | 2022-08-03 04:20:59 | Winkler, Texas, US | |
2597259 | 2597259 | 2022-07-25 | US | Texas | Stephens | 48429 | 1937 | 46 | 0 | 32.73553157 | -98.83631615 | 2022-07-26 04:20:58 | Stephens, Texas, US | |
3213287 | 3213287 | 2022-07-18 | US | Tennessee | Van Buren | 47175 | 1937 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-07-19 04:20:58 | Van Buren, Tennessee, US | |
1766937 | 1766937 | 2022-06-20 | US | Wyoming | Johnson | 56019 | 1937 | 19 | 0 | 44.04057166 | -106.5845174 | 2022-06-21 04:20:56 | Johnson, Wyoming, US | |
3273123 | 3273123 | 2022-06-19 | US | Wyoming | Johnson | 56019 | 1937 | 19 | 0 | 44.04057166 | -106.5845174 | 2022-06-20 04:21:01 | Johnson, Wyoming, US | |
3401035 | 3401035 | 2022-06-18 | US | Wyoming | Johnson | 56019 | 1937 | 19 | 0 | 44.04057166 | -106.5845174 | 2022-06-19 04:20:51 | Johnson, Wyoming, US | |
2314912 | 2314912 | 2022-06-17 | US | Wyoming | Johnson | 56019 | 1937 | 19 | 0 | 44.04057166 | -106.5845174 | 2022-06-18 04:21:10 | Johnson, Wyoming, US | |
562416 | 562416 | 2022-06-16 | US | Wyoming | Johnson | 56019 | 1937 | 19 | 0 | 44.04057166 | -106.5845174 | 2022-06-17 04:20:56 | Johnson, Wyoming, US | |
3986218 | 3986218 | 2022-06-15 | US | Wyoming | Johnson | 56019 | 1937 | 19 | 0 | 44.04057166 | -106.5845174 | 2022-06-16 04:20:55 | Johnson, Wyoming, US | |
950459 | 950459 | 2022-06-14 | US | Wyoming | Johnson | 56019 | 1937 | 19 | 0 | 44.04057166 | -106.5845174 | 2022-06-15 04:20:54 | Johnson, Wyoming, US | |
1424481 | 1424481 | 2022-06-08 | US | Virginia | Middlesex | 51119 | 1937 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-06-09 04:20:54 | Middlesex, Virginia, US | |
3729595 | 3729595 | 2022-06-07 | US | Virginia | Middlesex | 51119 | 1937 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-06-08 04:20:55 | Middlesex, Virginia, US | |
3509442 | 3509442 | 2022-06-05 | US | Nebraska | Butler | 31023 | 1937 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-06-06 04:20:57 | Butler, Nebraska, US | |
3529519 | 3529519 | 2022-06-04 | US | Nebraska | Butler | 31023 | 1937 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-06-05 04:20:55 | Butler, Nebraska, US | |
3001627 | 3001627 | 2022-05-24 | US | North Carolina | Gates | 37073 | 1937 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-05-24 23:20:57 | Gates, North Carolina, US | |
3595348 | 3595348 | 2022-05-23 | US | North Carolina | Gates | 37073 | 1937 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-05-24 04:20:57 | Gates, North Carolina, US | |
1111896 | 1111896 | 2022-05-21 | US | North Carolina | Gates | 37073 | 1937 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-05-22 04:20:52 | Gates, North Carolina, US | |
1110085 | 1110085 | 2022-05-21 | US | Arkansas | Monroe | 5095 | 1937 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-05-22 04:20:52 | Monroe, Arkansas, US | |
1171520 | 1171520 | 2022-05-20 | US | North Carolina | Gates | 37073 | 1937 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-05-21 04:20:58 | Gates, North Carolina, US | |
1169709 | 1169709 | 2022-05-20 | US | Arkansas | Monroe | 5095 | 1937 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-05-21 04:20:58 | Monroe, Arkansas, US | |
3898283 | 3898283 | 2022-05-19 | US | North Carolina | Gates | 37073 | 1937 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-05-20 04:20:57 | Gates, North Carolina, US | |
3896472 | 3896472 | 2022-05-19 | US | Arkansas | Monroe | 5095 | 1937 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-05-20 04:20:57 | Monroe, Arkansas, US | |
1187067 | 1187067 | 2022-05-18 | US | North Carolina | Gates | 37073 | 1937 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-05-19 04:20:54 | Gates, North Carolina, US | |
1185256 | 1185256 | 2022-05-18 | US | Arkansas | Monroe | 5095 | 1937 | 36 | 0 | 34.6815935 | -91.20540287 | 2022-05-19 04:20:54 | Monroe, Arkansas, US | |
3583153 | 3583153 | 2022-05-17 | US | Arkansas | Monroe | 5095 | 1937 | 35 | 0 | 34.6815935 | -91.20540287 | 2022-05-18 04:20:50 | Monroe, Arkansas, US | |
3583066 | 3583066 | 2022-05-17 | US | Alaska | Dillingham | 2070 | 1937 | 11 | 0 | 59.79603738 | -158.2381942 | 2022-05-18 04:20:50 | Dillingham, Alaska, US | |
1504023 | 1504023 | 2022-05-16 | US | Alaska | Dillingham | 2070 | 1937 | 11 | 0 | 59.79603738 | -158.2381942 | 2022-05-17 04:20:59 | Dillingham, Alaska, US | |
2084382 | 2084382 | 2022-05-15 | US | Alaska | Dillingham | 2070 | 1937 | 11 | 0 | 59.79603738 | -158.2381942 | 2022-05-16 04:20:47 | Dillingham, Alaska, US | |
3355092 | 3355092 | 2022-05-14 | US | Alaska | Dillingham | 2070 | 1937 | 11 | 0 | 59.79603738 | -158.2381942 | 2022-05-15 04:20:53 | Dillingham, Alaska, US | |
658737 | 658737 | 2022-05-13 | US | Alaska | Dillingham | 2070 | 1937 | 11 | 0 | 59.79603738 | -158.2381942 | 2022-05-14 04:20:48 | Dillingham, Alaska, US | |
2533820 | 2533820 | 2022-05-12 | US | Alaska | Dillingham | 2070 | 1937 | 11 | 0 | 59.79603738 | -158.2381942 | 2022-05-13 04:20:51 | Dillingham, Alaska, US | |
3445266 | 3445266 | 2022-05-11 | US | Alaska | Dillingham | 2070 | 1937 | 11 | 0 | 59.79603738 | -158.2381942 | 2022-05-12 04:20:54 | Dillingham, Alaska, US | |
943879 | 943879 | 2022-02-28 | US | Illinois | Schuyler | 17169 | 1937 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-03-01 04:21:09 | Schuyler, Illinois, US | |
2734070 | 2734070 | 2022-02-27 | US | Illinois | Schuyler | 17169 | 1937 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-02-28 04:21:05 | Schuyler, Illinois, US | |
3047223 | 3047223 | 2022-02-26 | US | Illinois | Schuyler | 17169 | 1937 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-02-27 04:21:04 | Schuyler, Illinois, US | |
575878 | 575878 | 2022-02-25 | US | Illinois | Schuyler | 17169 | 1937 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-02-26 04:21:12 | Schuyler, Illinois, US | |
574647 | 574647 | 2022-02-25 | China | Yunnan | 1937 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-02-26 04:21:12 | Yunnan, China | |||
1299358 | 1299358 | 2022-02-17 | US | Kansas | Kingman | 20095 | 1937 | 26 | 0 | 37.55909527 | -98.13638678 | 2022-02-18 04:21:04 | Kingman, Kansas, US | |
3821744 | 3821744 | 2022-02-16 | US | Kansas | Kingman | 20095 | 1937 | 26 | 0 | 37.55909527 | -98.13638678 | 2022-02-17 04:20:56 | Kingman, Kansas, US | |
3673639 | 3673639 | 2022-02-15 | US | Montana | Blaine | 30005 | 1937 | 29 | 0 | 48.43175214 | -108.9582723 | 2022-02-16 04:21:10 | Blaine, Montana, US | |
236190 | 236190 | 2022-02-11 | US | Tennessee | Hancock | 47067 | 1937 | 30 | 0 | 36.52692871 | -83.22375847 | 2022-02-12 04:21:06 | Hancock, Tennessee, US | |
1467192 | 1467192 | 2022-02-10 | US | Texas | Hamilton | 48193 | 1937 | 30 | 0 | 31.70470573 | -98.11083887 | 2022-02-11 04:21:09 | Hamilton, Texas, US | |
3077153 | 3077153 | 2022-02-09 | US | Texas | Hamilton | 48193 | 1937 | 29 | 0 | 31.70470573 | -98.11083887 | 2022-02-10 04:21:14 | Hamilton, Texas, US | |
3076107 | 3076107 | 2022-02-09 | US | Nebraska | Custer | 31041 | 1937 | 19 | 0 | 41.39374521 | -99.72805369 | 2022-02-10 04:21:14 | Custer, Nebraska, US | |
2330137 | 2330137 | 2022-02-04 | US | Puerto Rico | Rincon | 72117 | 1937 | 0 | 0 | 18.335442999999998 | -67.23174 | 2022-02-05 04:21:05 | Rincon, Puerto Rico, US | |
980695 | 980695 | 2022-02-01 | US | Minnesota | Murray | 27101 | 1937 | 15 | 0 | 44.02216709 | -95.76328482 | 2022-02-02 04:21:09 | Murray, Minnesota, US | |
1319167 | 1319167 | 2022-01-26 | US | Idaho | Owyhee | 16073 | 1937 | 45 | 0 | 42.58016894 | -116.16938710000001 | 2022-01-27 04:21:19 | Owyhee, Idaho, US | |
1230997 | 1230997 | 2022-01-24 | US | Virginia | Northumberland | 51133 | 1937 | 39 | 0 | 37.89202088 | -76.41949732 | 2022-01-25 04:21:05 | Northumberland, Virginia, US | |
1229017 | 1229017 | 2022-01-24 | US | Kentucky | Gallatin | 21077 | 1937 | 45 | 0 | 38.75398691 | -84.8558382 | 2022-01-25 04:21:05 | Gallatin, Kentucky, US | |
1142707 | 1142707 | 2022-01-23 | US | Mississippi | Claiborne | 28021 | 1937 | 42 | 0 | 31.97061673 | -90.90702196 | 2022-01-24 04:21:12 | Claiborne, Mississippi, US | |
2834735 | 2834735 | 2022-01-22 | US | Missouri | Gentry | 29075 | 1937 | 28 | 0 | 40.21097916 | -94.40944419 | 2022-01-23 04:21:13 | Gentry, Missouri, US | |
2834625 | 2834625 | 2022-01-22 | US | Mississippi | Claiborne | 28021 | 1937 | 42 | 0 | 31.97061673 | -90.90702196 | 2022-01-23 04:21:13 | Claiborne, Mississippi, US | |
3426743 | 3426743 | 2022-01-21 | US | Mississippi | Claiborne | 28021 | 1937 | 42 | 0 | 31.97061673 | -90.90702196 | 2022-01-22 04:21:13 | Claiborne, Mississippi, US | |
3229434 | 3229434 | 2022-01-19 | US | Tennessee | Perry | 47135 | 1937 | 43 | 0 | 35.63708728 | -87.86139634 | 2022-01-20 04:21:07 | Perry, Tennessee, US | |
3613909 | 3613909 | 2022-01-12 | US | Georgia | McIntosh | 13191 | 1937 | 33 | 0 | 31.49683595 | -81.40163426 | 2022-01-13 08:00:09 | McIntosh, Georgia, US | |
1116927 | 1116927 | 2022-01-11 | US | Virginia | Floyd | 51063 | 1937 | 33 | 0 | 36.9302126 | -80.36738849 | 2022-01-12 04:21:44 | Floyd, Virginia, US | |
1217474 | 1217474 | 2022-01-08 | US | Missouri | Grundy | 29079 | 1937 | 58 | 0 | 40.11406587 | -93.56509276 | 2022-01-09 04:21:46 | Grundy, Missouri, US | |
1215553 | 1215553 | 2022-01-08 | Japan | Akita | 1937 | 27 | 0 | 39.748678999999996 | 140.408228 | 2022-01-09 04:21:46 | Akita, Japan | |||
3521268 | 3521268 | 2022-01-02 | US | Mississippi | Noxubee | 28103 | 1937 | 44 | 0 | 33.11009499 | -88.56949061 | 2022-01-03 02:22:25 | Noxubee, Mississippi, US | |
2169398 | 2169398 | 2022-01-01 | US | Mississippi | Noxubee | 28103 | 1937 | 44 | 0 | 33.11009499 | -88.56949061 | 2022-01-02 04:20:52 | Noxubee, Mississippi, US | |
2778829 | 2778829 | 2021-12-31 | US | Mississippi | Noxubee | 28103 | 1937 | 44 | 0 | 33.11009499 | -88.56949061 | 2022-01-01 04:22:14 | Noxubee, Mississippi, US | |
4000486 | 4000486 | 2021-12-30 | US | Mississippi | Noxubee | 28103 | 1937 | 44 | 0 | 33.11009499 | -88.56949061 | 2021-12-31 04:21:50 | Noxubee, Mississippi, US | |
3830475 | 3830475 | 2021-12-21 | US | Montana | Jefferson | 30043 | 1937 | 21 | 0 | 46.14907081 | -112.094396 | 2021-12-22 04:21:54 | Jefferson, Montana, US | |
2399777 | 2399777 | 2021-12-17 | US | Idaho | Washington | 16087 | 1937 | 47 | 0 | 44.45275475 | -116.78476880000001 | 2021-12-18 02:22:20 | Washington, Idaho, US | |
1718227 | 1718227 | 2021-12-16 | US | Missouri | Barton | 29011 | 1937 | 40 | 0 | 37.50207671 | -94.34757022 | 2021-12-17 04:22:14 | Barton, Missouri, US | |
1717315 | 1717315 | 2021-12-16 | US | Idaho | Washington | 16087 | 1937 | 47 | 0 | 44.45275475 | -116.78476880000001 | 2021-12-17 04:22:14 | Washington, Idaho, US | |
1716215 | 1716215 | 2021-12-16 | Denmark | Greenland | 1937 | 0 | 0 | 71.7069 | -42.6043 | 2021-12-17 04:22:14 | Greenland, Denmark | |||
3497149 | 3497149 | 2021-12-15 | US | Idaho | Washington | 16087 | 1937 | 47 | 0 | 44.45275475 | -116.78476880000001 | 2021-12-16 04:22:11 | Washington, Idaho, US | |
2091014 | 2091014 | 2021-12-14 | US | Texas | Callahan | 48059 | 1937 | 57 | 0 | 32.29760619 | -99.37326312 | 2021-12-15 03:22:16 | Callahan, Texas, US | |
552358 | 552358 | 2021-12-08 | US | Maryland | Kent | 24029 | 1937 | 57 | 0 | 39.24976208 | -76.04741541 | 2021-12-09 04:22:49 | Kent, Maryland, US | |
1033625 | 1033625 | 2021-12-06 | US | Texas | Ward | 48475 | 1937 | 35 | 0 | 31.50999644 | -103.09279090000001 | 2021-12-07 04:22:34 | Ward, Texas, US | |
1743788 | 1743788 | 2021-12-05 | US | Texas | Ward | 48475 | 1937 | 35 | 0 | 31.50999644 | -103.09279090000001 | 2021-12-06 04:22:34 | Ward, Texas, US | |
141220 | 141220 | 2021-12-04 | US | Texas | Ward | 48475 | 1937 | 35 | 0 | 31.50999644 | -103.09279090000001 | 2021-12-05 04:22:25 | Ward, Texas, US | |
2198390 | 2198390 | 2021-12-03 | US | Puerto Rico | Naranjito | 72105 | 1937 | 0 | 0 | 18.288019 | -66.252703 | 2021-12-04 04:22:18 | Naranjito, Puerto Rico, US | |
1804524 | 1804524 | 2021-11-25 | US | Minnesota | Watonwan | 27165 | 1937 | 20 | 0 | 43.97823903 | -94.61413846 | 2021-11-26 04:22:33 | Watonwan, Minnesota, US | |
1803227 | 1803227 | 2021-11-25 | US | Arkansas | Desha | 5041 | 1937 | 33 | 0 | 33.83011025 | -91.25500948 | 2021-11-26 04:22:33 | Desha, Arkansas, US | |
905958 | 905958 | 2021-11-24 | US | Minnesota | Watonwan | 27165 | 1937 | 20 | 0 | 43.97823903 | -94.61413846 | 2021-11-25 04:22:33 | Watonwan, Minnesota, US | |
904661 | 904661 | 2021-11-24 | US | Arkansas | Desha | 5041 | 1937 | 33 | 0 | 33.83011025 | -91.25500948 | 2021-11-25 04:22:33 | Desha, Arkansas, US | |
44342 | 44342 | 2021-11-02 | US | Colorado | Las Animas | 8071 | 1937 | 26 | 0 | 37.3153406 | -104.03764579999999 | 2021-11-03 06:22:09 | Las Animas, Colorado, US | |
2124811 | 2124811 | 2021-10-21 | US | Indiana | Blackford | 18009 | 1937 | 42 | 0 | 40.47388153 | -85.32499702 | 2021-10-22 04:21:14 | Blackford, Indiana, US | |
3010722 | 3010722 | 2021-10-11 | US | Virginia | Patrick | 51141 | 1937 | 55 | 0 | 36.680163799999995 | -80.2865648 | 2021-10-12 04:21:09 | Patrick, Virginia, 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]);