johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
309 rows where confirmed = 1932 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3523246 | 3523246 | 2022-11-24 | China | Hunan | 1932 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-25 04:21:06 | Hunan, China | |||
3598934 | 3598934 | 2022-11-14 | US | Missouri | Chariton | 29041 | 1932 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-15 04:21:16 | Chariton, Missouri, US | |
313792 | 313792 | 2022-11-13 | US | Missouri | Chariton | 29041 | 1932 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-14 04:21:09 | Chariton, Missouri, US | |
64953 | 64953 | 2022-11-12 | US | Missouri | Chariton | 29041 | 1932 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-13 04:21:14 | Chariton, Missouri, US | |
2929115 | 2929115 | 2022-11-11 | US | Missouri | Chariton | 29041 | 1932 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-12 04:20:41 | Chariton, Missouri, US | |
2507951 | 2507951 | 2022-11-10 | US | Missouri | Chariton | 29041 | 1932 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-11 04:21:22 | Chariton, Missouri, US | |
2432826 | 2432826 | 2022-11-09 | US | Missouri | Chariton | 29041 | 1932 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-10 04:21:16 | Chariton, Missouri, US | |
481482 | 481482 | 2022-11-08 | US | Missouri | Chariton | 29041 | 1932 | 41 | 0 | 39.51499357 | -92.9629191 | 2022-11-09 04:21:22 | Chariton, Missouri, US | |
3100612 | 3100612 | 2022-10-09 | US | Texas | Marion | 48315 | 1932 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-10 04:22:32 | Marion, Texas, US | |
4005837 | 4005837 | 2022-10-08 | US | Texas | Marion | 48315 | 1932 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-09 04:21:16 | Marion, Texas, US | |
399434 | 399434 | 2022-10-07 | US | Texas | Marion | 48315 | 1932 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-10-08 04:22:56 | Marion, Texas, US | |
131266 | 131266 | 2022-10-04 | US | Arkansas | Newton | 5101 | 1932 | 50 | 0 | 35.91947491 | -93.21612969 | 2022-10-05 04:23:06 | Newton, Arkansas, US | |
2377425 | 2377425 | 2022-09-29 | US | Missouri | Caldwell | 29025 | 1932 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-30 04:23:09 | Caldwell, Missouri, US | |
1561976 | 1561976 | 2022-09-28 | US | Missouri | Caldwell | 29025 | 1932 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-29 04:22:34 | Caldwell, Missouri, US | |
3996519 | 3996519 | 2022-09-27 | US | Missouri | Caldwell | 29025 | 1932 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-28 04:23:01 | Caldwell, Missouri, US | |
3995896 | 3995896 | 2022-09-27 | US | Iowa | Worth | 19195 | 1932 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-28 04:23:01 | Worth, Iowa, US | |
2770847 | 2770847 | 2022-09-26 | US | Missouri | Caldwell | 29025 | 1932 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-27 04:23:01 | Caldwell, Missouri, US | |
2770224 | 2770224 | 2022-09-26 | US | Iowa | Worth | 19195 | 1932 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-27 04:23:01 | Worth, Iowa, US | |
1978500 | 1978500 | 2022-09-25 | US | Missouri | Caldwell | 29025 | 1932 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-26 04:20:52 | Caldwell, Missouri, US | |
1977877 | 1977877 | 2022-09-25 | US | Iowa | Worth | 19195 | 1932 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-26 04:20:52 | Worth, Iowa, US | |
2651667 | 2651667 | 2022-09-24 | US | Missouri | Caldwell | 29025 | 1932 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-25 04:23:31 | Caldwell, Missouri, US | |
2651044 | 2651044 | 2022-09-24 | US | Iowa | Worth | 19195 | 1932 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-25 04:23:31 | Worth, Iowa, US | |
386107 | 386107 | 2022-09-23 | US | Missouri | Caldwell | 29025 | 1932 | 40 | 0 | 39.65620858 | -93.98308093 | 2022-09-24 04:21:40 | Caldwell, Missouri, US | |
385484 | 385484 | 2022-09-23 | US | Iowa | Worth | 19195 | 1932 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-24 04:21:40 | Worth, Iowa, US | |
1625550 | 1625550 | 2022-09-22 | US | Iowa | Worth | 19195 | 1932 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-23 04:23:13 | Worth, Iowa, US | |
1371754 | 1371754 | 2022-09-21 | US | Iowa | Worth | 19195 | 1932 | 17 | 0 | 43.37750768 | -93.26087602 | 2022-09-22 04:22:56 | Worth, Iowa, US | |
2635785 | 2635785 | 2022-09-05 | US | Nebraska | Cuming | 31039 | 1932 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-09-06 04:21:02 | Cuming, Nebraska, US | |
2989349 | 2989349 | 2022-09-04 | US | Nebraska | Cuming | 31039 | 1932 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-09-05 04:21:01 | Cuming, Nebraska, US | |
2715034 | 2715034 | 2022-09-03 | US | Nebraska | Cuming | 31039 | 1932 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-09-04 04:21:22 | Cuming, Nebraska, US | |
1395739 | 1395739 | 2022-09-02 | US | Nebraska | Cuming | 31039 | 1932 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-09-03 04:21:04 | Cuming, Nebraska, US | |
3549568 | 3549568 | 2022-09-01 | US | Nebraska | Cuming | 31039 | 1932 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-09-02 04:21:07 | Cuming, Nebraska, US | |
2345488 | 2345488 | 2022-08-31 | US | Nebraska | Cuming | 31039 | 1932 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-09-01 04:21:03 | Cuming, Nebraska, US | |
3775968 | 3775968 | 2022-08-30 | US | Nebraska | Cuming | 31039 | 1932 | 14 | 0 | 41.91637624 | -96.78730772 | 2022-08-31 04:20:57 | Cuming, Nebraska, US | |
2325082 | 2325082 | 2022-08-24 | US | Minnesota | Lac qui Parle | 27073 | 1932 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-08-25 04:21:13 | Lac qui Parle, Minnesota, US | |
1252491 | 1252491 | 2022-08-23 | US | Minnesota | Lac qui Parle | 27073 | 1932 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-08-24 04:20:46 | Lac qui Parle, Minnesota, US | |
2854595 | 2854595 | 2022-08-22 | US | Minnesota | Lac qui Parle | 27073 | 1932 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-08-23 04:20:56 | Lac qui Parle, Minnesota, US | |
2404567 | 2404567 | 2022-08-21 | US | Minnesota | Lac qui Parle | 27073 | 1932 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-08-22 04:20:38 | Lac qui Parle, Minnesota, US | |
3799645 | 3799645 | 2022-08-20 | US | Minnesota | Lac qui Parle | 27073 | 1932 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-08-21 04:20:44 | Lac qui Parle, Minnesota, US | |
2365231 | 2365231 | 2022-08-19 | US | Minnesota | Lac qui Parle | 27073 | 1932 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-08-20 04:21:01 | Lac qui Parle, Minnesota, US | |
1162902 | 1162902 | 2022-08-18 | US | Minnesota | Lac qui Parle | 27073 | 1932 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-08-19 04:20:54 | Lac qui Parle, Minnesota, US | |
1407343 | 1407343 | 2022-08-02 | US | North Carolina | Camden | 37029 | 1932 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-08-03 04:20:59 | Camden, North Carolina, US | |
3619381 | 3619381 | 2022-08-01 | US | North Carolina | Camden | 37029 | 1932 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-08-02 04:20:53 | Camden, North Carolina, US | |
3873861 | 3873861 | 2022-07-31 | US | North Carolina | Camden | 37029 | 1932 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-08-01 04:21:03 | Camden, North Carolina, US | |
676615 | 676615 | 2022-07-30 | US | North Carolina | Camden | 37029 | 1932 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-07-31 04:21:02 | Camden, North Carolina, US | |
1785814 | 1785814 | 2022-07-29 | US | North Carolina | Camden | 37029 | 1932 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-07-30 04:20:42 | Camden, North Carolina, US | |
1068177 | 1068177 | 2022-07-28 | US | North Carolina | Camden | 37029 | 1932 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-07-29 04:20:45 | Camden, North Carolina, US | |
2337696 | 2337696 | 2022-07-27 | US | North Carolina | Camden | 37029 | 1932 | 9 | 0 | 36.33804939 | -76.15568396 | 2022-07-28 04:20:56 | Camden, North Carolina, US | |
2594685 | 2594685 | 2022-07-25 | US | Colorado | Rio Blanco | 8103 | 1932 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-07-26 04:20:58 | Rio Blanco, Colorado, US | |
2744078 | 2744078 | 2022-07-07 | US | Texas | Crosby | 48107 | 1932 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-07-08 04:20:56 | Crosby, Texas, US | |
1203234 | 1203234 | 2022-07-06 | US | Virginia | Williamsburg | 51830 | 1932 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-07-07 04:20:55 | Williamsburg, Virginia, US | |
1202873 | 1202873 | 2022-07-06 | US | Texas | Crosby | 48107 | 1932 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-07-07 04:20:55 | Crosby, Texas, US | |
3888253 | 3888253 | 2022-06-06 | US | Colorado | Lake | 8065 | 1932 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-06-07 04:21:08 | Lake, Colorado, US | |
224048 | 224048 | 2022-05-09 | US | Nebraska | Butler | 31023 | 1932 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-05-10 04:20:50 | Butler, Nebraska, US | |
2333433 | 2333433 | 2022-05-08 | US | Nebraska | Butler | 31023 | 1932 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-05-09 04:20:54 | Butler, Nebraska, US | |
362395 | 362395 | 2022-05-07 | US | Nebraska | Butler | 31023 | 1932 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-05-08 04:20:49 | Butler, Nebraska, US | |
1399746 | 1399746 | 2022-05-06 | US | Nebraska | Butler | 31023 | 1932 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-05-07 04:21:09 | Butler, Nebraska, US | |
2600101 | 2600101 | 2022-05-05 | US | Nebraska | Butler | 31023 | 1932 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-05-06 04:21:00 | Butler, Nebraska, US | |
3267550 | 3267550 | 2022-05-04 | US | Nebraska | Butler | 31023 | 1932 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-05-05 04:20:55 | Butler, Nebraska, US | |
1574189 | 1574189 | 2022-05-03 | US | Nebraska | Butler | 31023 | 1932 | 18 | 0 | 41.22703692 | -97.13106306 | 2022-05-04 04:20:59 | Butler, Nebraska, US | |
2254169 | 2254169 | 2022-04-19 | US | Puerto Rico | Guayanilla | 72059 | 1932 | 0 | 0 | 18.039942 | -66.79186 | 2022-04-20 04:20:45 | Guayanilla, Puerto Rico, US | |
1848719 | 1848719 | 2022-04-18 | US | Puerto Rico | Guayanilla | 72059 | 1932 | 0 | 0 | 18.039942 | -66.79186 | 2022-04-19 04:21:00 | Guayanilla, Puerto Rico, US | |
3419663 | 3419663 | 2022-04-17 | US | Puerto Rico | Guayanilla | 72059 | 1932 | 0 | 0 | 18.039942 | -66.79186 | 2022-04-18 04:21:12 | Guayanilla, Puerto Rico, US | |
27906 | 27906 | 2022-03-20 | US | West Virginia | Pendleton | 54071 | 1932 | 17 | 0 | 38.68314479 | -79.35084086 | 2022-03-21 04:20:50 | Pendleton, West Virginia, US | |
1659916 | 1659916 | 2022-03-19 | US | West Virginia | Pendleton | 54071 | 1932 | 17 | 0 | 38.68314479 | -79.35084086 | 2022-03-20 04:20:45 | Pendleton, West Virginia, US | |
339442 | 339442 | 2022-03-18 | US | West Virginia | Pendleton | 54071 | 1932 | 17 | 0 | 38.68314479 | -79.35084086 | 2022-03-19 04:20:47 | Pendleton, West Virginia, US | |
359414 | 359414 | 2022-03-11 | US | Texas | Floyd | 48153 | 1932 | 48 | 0 | 34.07227468 | -101.3031546 | 2022-03-12 04:20:50 | Floyd, Texas, US | |
1868814 | 1868814 | 2022-03-10 | US | Virginia | Falls Church | 51610 | 1932 | 16 | 0 | 38.88485255 | -77.17560759 | 2022-03-11 04:20:50 | Falls Church, Virginia, US | |
3719231 | 3719231 | 2022-02-21 | US | Illinois | Schuyler | 17169 | 1932 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-02-22 04:21:01 | Schuyler, Illinois, US | |
3913065 | 3913065 | 2022-02-20 | US | Illinois | Schuyler | 17169 | 1932 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-02-21 04:21:05 | Schuyler, Illinois, US | |
3876623 | 3876623 | 2022-02-19 | US | Illinois | Schuyler | 17169 | 1932 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-02-20 04:21:00 | Schuyler, Illinois, US | |
3856879 | 3856879 | 2022-02-18 | US | Illinois | Schuyler | 17169 | 1932 | 17 | 0 | 40.157179799999994 | -90.61114163 | 2022-02-19 04:21:11 | Schuyler, Illinois, US | |
2644172 | 2644172 | 2022-02-14 | US | North Dakota | Pembina | 38067 | 1932 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-02-15 04:21:09 | Pembina, North Dakota, US | |
1365687 | 1365687 | 2022-02-08 | US | Virginia | Fairfax City | 51600 | 1932 | 39 | 0 | 38.85157547 | -77.29779640000002 | 2022-02-09 04:21:04 | Fairfax City, Virginia, US | |
73297 | 73297 | 2022-02-07 | US | New Mexico | Quay | 35037 | 1932 | 39 | 0 | 35.10403332 | -103.54817270000001 | 2022-02-08 04:21:15 | Quay, New Mexico, US | |
979474 | 979474 | 2022-02-01 | US | Arkansas | Searcy | 5129 | 1932 | 37 | 0 | 35.9109364 | -92.69936482 | 2022-02-02 04:21:09 | Searcy, Arkansas, US | |
1321264 | 1321264 | 2022-01-26 | US | Texas | Clay | 48077 | 1932 | 27 | 0 | 33.78686685 | -98.20771198 | 2022-01-27 04:21:19 | Clay, Texas, US | |
1230803 | 1230803 | 2022-01-24 | US | Texas | Ochiltree | 48357 | 1932 | 40 | 0 | 36.27829105 | -100.8158184 | 2022-01-25 04:21:05 | Ochiltree, Texas, US | |
1144102 | 1144102 | 2022-01-23 | US | Texas | Ochiltree | 48357 | 1932 | 40 | 0 | 36.27829105 | -100.8158184 | 2022-01-24 04:21:12 | Ochiltree, Texas, US | |
1142684 | 1142684 | 2022-01-23 | US | Minnesota | Swift | 27151 | 1932 | 31 | 0 | 45.2829032 | -95.68264092 | 2022-01-24 04:21:12 | Swift, Minnesota, US | |
2834602 | 2834602 | 2022-01-22 | US | Minnesota | Swift | 27151 | 1932 | 31 | 0 | 45.2829032 | -95.68264092 | 2022-01-23 04:21:13 | Swift, Minnesota, US | |
3426720 | 3426720 | 2022-01-21 | US | Minnesota | Swift | 27151 | 1932 | 31 | 0 | 45.2829032 | -95.68264092 | 2022-01-22 04:21:13 | Swift, Minnesota, US | |
3227281 | 3227281 | 2022-01-19 | US | Georgia | Johnson | 13167 | 1932 | 64 | 0 | 32.70211082 | -82.66166794 | 2022-01-20 04:21:07 | Johnson, Georgia, US | |
3841035 | 3841035 | 2022-01-15 | US | Arkansas | Scott | 5127 | 1932 | 35 | 0 | 34.85588887 | -94.0632176 | 2022-01-16 04:21:12 | Scott, Arkansas, US | |
3521061 | 3521061 | 2022-01-02 | US | Michigan | Crawford | 26039 | 1932 | 21 | 0 | 44.68255561 | -84.61006219 | 2022-01-03 02:22:25 | Crawford, Michigan, US | |
2169191 | 2169191 | 2022-01-01 | US | Michigan | Crawford | 26039 | 1932 | 21 | 0 | 44.68255561 | -84.61006219 | 2022-01-02 04:20:52 | Crawford, Michigan, US | |
2778622 | 2778622 | 2021-12-31 | US | Michigan | Crawford | 26039 | 1932 | 21 | 0 | 44.68255561 | -84.61006219 | 2022-01-01 04:22:14 | Crawford, Michigan, US | |
4000279 | 4000279 | 2021-12-30 | US | Michigan | Crawford | 26039 | 1932 | 21 | 0 | 44.68255561 | -84.61006219 | 2021-12-31 04:21:50 | Crawford, Michigan, US | |
1670086 | 1670086 | 2021-12-29 | US | Michigan | Crawford | 26039 | 1932 | 21 | 0 | 44.68255561 | -84.61006219 | 2021-12-30 04:21:25 | Crawford, Michigan, US | |
2400740 | 2400740 | 2021-12-17 | US | Missouri | Lewis | 29111 | 1932 | 30 | 0 | 40.09673161 | -91.72070156 | 2021-12-18 02:22:20 | Lewis, Missouri, US | |
1718360 | 1718360 | 2021-12-16 | US | Montana | Jefferson | 30043 | 1932 | 21 | 0 | 46.14907081 | -112.094396 | 2021-12-17 04:22:14 | Jefferson, Montana, US | |
3499702 | 3499702 | 2021-12-15 | US | West Virginia | Roane | 54087 | 1932 | 27 | 0 | 38.71622686 | -81.35243568 | 2021-12-16 04:22:11 | Roane, West Virginia, US | |
2091262 | 2091262 | 2021-12-14 | US | Vermont | Orange | 50017 | 1932 | 8 | 0 | 44.00470222 | -72.37640104 | 2021-12-15 03:22:16 | Orange, Vermont, US | |
785431 | 785431 | 2021-12-13 | US | Texas | Callahan | 48059 | 1932 | 57 | 0 | 32.29760619 | -99.37326312 | 2021-12-14 04:22:38 | Callahan, Texas, US | |
1661386 | 1661386 | 2021-12-12 | US | Idaho | Washington | 16087 | 1932 | 47 | 0 | 44.45275475 | -116.78476880000001 | 2021-12-13 04:22:02 | Washington, Idaho, US | |
1665402 | 1665402 | 2021-12-11 | US | Idaho | Washington | 16087 | 1932 | 47 | 0 | 44.45275475 | -116.78476880000001 | 2021-12-12 04:22:12 | Washington, Idaho, US | |
1079811 | 1079811 | 2021-12-09 | US | Missouri | Cedar | 29039 | 1932 | 42 | 0 | 37.72391475 | -93.85445441 | 2021-12-10 04:22:28 | Cedar, Missouri, US | |
551377 | 551377 | 2021-12-08 | US | Colorado | Bent | 8011 | 1932 | 40 | 0 | 37.95474293 | -103.0720195 | 2021-12-09 04:22:49 | Bent, Colorado, US | |
1033331 | 1033331 | 2021-12-06 | US | Tennessee | Houston | 47083 | 1932 | 46 | 0 | 36.28872054 | -87.71878828 | 2021-12-07 04:22:34 | Houston, Tennessee, US | |
1031960 | 1031960 | 2021-12-06 | US | Maryland | Kent | 24029 | 1932 | 57 | 0 | 39.24976208 | -76.04741541 | 2021-12-07 04:22:34 | Kent, Maryland, US | |
139846 | 139846 | 2021-12-04 | US | Missouri | Bollinger | 29017 | 1932 | 31 | 0 | 37.32449052 | -90.02725304 | 2021-12-05 04:22:25 | Bollinger, 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]);