johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
345 rows where confirmed = 2161 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3714825 | 3714825 | 2022-12-06 | US | Colorado | Rio Blanco | 8103 | 2161 | 15 | 0 | 39.97913541 | -108.2179009 | 2022-12-07 04:20:58 | Rio Blanco, Colorado, US | |
3463479 | 3463479 | 2022-11-21 | US | Virginia | Buena Vista | 51530 | 2161 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-11-22 04:20:47 | Buena Vista, Virginia, US | |
1643664 | 1643664 | 2022-11-20 | US | Virginia | Buena Vista | 51530 | 2161 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-11-21 04:21:05 | Buena Vista, Virginia, US | |
2067221 | 2067221 | 2022-11-19 | US | Virginia | Buena Vista | 51530 | 2161 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-11-20 04:21:08 | Buena Vista, Virginia, US | |
1758615 | 1758615 | 2022-11-18 | US | Virginia | Buena Vista | 51530 | 2161 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-11-19 04:21:14 | Buena Vista, Virginia, US | |
1833583 | 1833583 | 2022-10-25 | US | Virginia | Williamsburg | 51830 | 2161 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-26 04:22:19 | Williamsburg, Virginia, US | |
2970774 | 2970774 | 2022-10-10 | US | Virginia | Lancaster | 51103 | 2161 | 38 | 0 | 37.71889653 | -76.46400482 | 2022-10-11 04:23:05 | Lancaster, Virginia, US | |
117861 | 117861 | 2022-09-06 | US | Texas | Hansford | 48195 | 2161 | 30 | 0 | 36.27743284 | -101.3545796 | 2022-09-07 04:20:59 | Hansford, Texas, US | |
115899 | 115899 | 2022-09-06 | US | Indiana | Union | 18161 | 2161 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-09-07 04:20:59 | Union, Indiana, US | |
2635786 | 2635786 | 2022-09-05 | US | Nebraska | Custer | 31041 | 2161 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-09-06 04:21:02 | Custer, Nebraska, US | |
2634871 | 2634871 | 2022-09-05 | US | Indiana | Union | 18161 | 2161 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-09-06 04:21:02 | Union, Indiana, US | |
2989350 | 2989350 | 2022-09-04 | US | Nebraska | Custer | 31041 | 2161 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-09-05 04:21:01 | Custer, Nebraska, US | |
2988435 | 2988435 | 2022-09-04 | US | Indiana | Union | 18161 | 2161 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-09-05 04:21:01 | Union, Indiana, US | |
2715035 | 2715035 | 2022-09-03 | US | Nebraska | Custer | 31041 | 2161 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-09-04 04:21:22 | Custer, Nebraska, US | |
2714120 | 2714120 | 2022-09-03 | US | Indiana | Union | 18161 | 2161 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-09-04 04:21:22 | Union, Indiana, US | |
1395740 | 1395740 | 2022-09-02 | US | Nebraska | Custer | 31041 | 2161 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-09-03 04:21:04 | Custer, Nebraska, US | |
1394825 | 1394825 | 2022-09-02 | US | Indiana | Union | 18161 | 2161 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-09-03 04:21:04 | Union, Indiana, US | |
3549569 | 3549569 | 2022-09-01 | US | Nebraska | Custer | 31041 | 2161 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-09-02 04:21:07 | Custer, Nebraska, US | |
2345489 | 2345489 | 2022-08-31 | US | Nebraska | Custer | 31041 | 2161 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-09-01 04:21:03 | Custer, Nebraska, US | |
3775969 | 3775969 | 2022-08-30 | US | Nebraska | Custer | 31041 | 2161 | 31 | 0 | 41.39374521 | -99.72805369 | 2022-08-31 04:20:57 | Custer, Nebraska, US | |
3953717 | 3953717 | 2022-08-17 | US | Texas | Somervell | 48425 | 2161 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-18 04:21:11 | Somervell, Texas, US | |
994219 | 994219 | 2022-08-16 | US | Texas | Somervell | 48425 | 2161 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-17 04:20:59 | Somervell, Texas, US | |
2497258 | 2497258 | 2022-08-15 | US | Texas | Somervell | 48425 | 2161 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-08-16 04:20:58 | Somervell, Texas, US | |
1088134 | 1088134 | 2022-08-09 | US | Nebraska | Cheyenne | 31033 | 2161 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-08-10 04:20:57 | Cheyenne, Nebraska, US | |
3545549 | 3545549 | 2022-08-08 | US | Nebraska | Cheyenne | 31033 | 2161 | 24 | 0 | 41.21999357 | -102.9941693 | 2022-08-09 04:20:34 | Cheyenne, Nebraska, US | |
2012006 | 2012006 | 2022-08-04 | US | Virginia | Buena Vista | 51530 | 2161 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-08-05 04:20:52 | Buena Vista, Virginia, US | |
962210 | 962210 | 2022-07-19 | US | Virginia | Buena Vista | 51530 | 2161 | 46 | 0 | 37.73484642 | -79.35296097 | 2022-07-20 04:20:59 | Buena Vista, Virginia, US | |
3213086 | 3213086 | 2022-07-18 | US | South Carolina | Allendale | 45005 | 2161 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-19 04:20:58 | Allendale, South Carolina, US | |
3408261 | 3408261 | 2022-07-17 | US | South Carolina | Allendale | 45005 | 2161 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-18 04:20:59 | Allendale, South Carolina, US | |
3407665 | 3407665 | 2022-07-17 | US | New Mexico | Quay | 35037 | 2161 | 61 | 0 | 35.10403332 | -103.5481727 | 2022-07-18 04:20:59 | Quay, New Mexico, US | |
3406504 | 3406504 | 2022-07-17 | US | Illinois | Schuyler | 17169 | 2161 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-07-18 04:20:59 | Schuyler, Illinois, US | |
2154461 | 2154461 | 2022-07-16 | US | South Carolina | Allendale | 45005 | 2161 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-17 04:21:15 | Allendale, South Carolina, US | |
2153865 | 2153865 | 2022-07-16 | US | New Mexico | Quay | 35037 | 2161 | 61 | 0 | 35.10403332 | -103.5481727 | 2022-07-17 04:21:15 | Quay, New Mexico, US | |
2152704 | 2152704 | 2022-07-16 | US | Illinois | Schuyler | 17169 | 2161 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-07-17 04:21:15 | Schuyler, Illinois, US | |
2421694 | 2421694 | 2022-07-15 | US | South Carolina | Allendale | 45005 | 2161 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-16 04:21:05 | Allendale, South Carolina, US | |
2421098 | 2421098 | 2022-07-15 | US | New Mexico | Quay | 35037 | 2161 | 61 | 0 | 35.10403332 | -103.5481727 | 2022-07-16 04:21:05 | Quay, New Mexico, US | |
2419937 | 2419937 | 2022-07-15 | US | Illinois | Schuyler | 17169 | 2161 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-07-16 04:21:05 | Schuyler, Illinois, US | |
3431769 | 3431769 | 2022-07-14 | US | South Carolina | Allendale | 45005 | 2161 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-15 04:20:53 | Allendale, South Carolina, US | |
3112289 | 3112289 | 2022-07-13 | US | South Carolina | Allendale | 45005 | 2161 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-14 04:20:57 | Allendale, South Carolina, US | |
632712 | 632712 | 2022-07-12 | US | South Carolina | Allendale | 45005 | 2161 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-13 04:20:58 | Allendale, South Carolina, US | |
3967878 | 3967878 | 2022-07-05 | US | Kansas | Norton | 20137 | 2161 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-06 04:20:58 | Norton, Kansas, US | |
3079389 | 3079389 | 2022-07-04 | US | Kansas | Norton | 20137 | 2161 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-05 04:20:45 | Norton, Kansas, US | |
1768671 | 1768671 | 2022-07-03 | US | Kansas | Norton | 20137 | 2161 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-04 04:20:54 | Norton, Kansas, US | |
3366657 | 3366657 | 2022-07-02 | US | Kansas | Norton | 20137 | 2161 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-03 04:20:59 | Norton, Kansas, US | |
594986 | 594986 | 2022-07-01 | US | Kansas | Norton | 20137 | 2161 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-02 04:21:16 | Norton, Kansas, US | |
3941387 | 3941387 | 2022-06-30 | US | Kansas | Norton | 20137 | 2161 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-07-01 04:21:10 | Norton, Kansas, US | |
2491546 | 2491546 | 2022-06-29 | US | Louisiana | Red River | 22081 | 2161 | 54 | 0 | 32.09530039 | -93.34213308 | 2022-06-30 04:21:01 | Red River, Louisiana, US | |
2491345 | 2491345 | 2022-06-29 | US | Kansas | Norton | 20137 | 2161 | 36 | 0 | 39.78443827 | -99.90286639 | 2022-06-30 04:21:01 | Norton, Kansas, US | |
475841 | 475841 | 2022-06-26 | US | Alabama | Perry | 1105 | 2161 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-06-27 04:21:00 | Perry, Alabama, US | |
939216 | 939216 | 2022-06-25 | US | Alabama | Perry | 1105 | 2161 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-06-26 04:21:02 | Perry, Alabama, US | |
3347036 | 3347036 | 2022-06-24 | US | Alabama | Perry | 1105 | 2161 | 47 | 0 | 32.64048341 | -87.29770589 | 2022-06-25 04:20:57 | Perry, Alabama, US | |
1650119 | 1650119 | 2022-06-23 | US | Minnesota | Marshall | 27089 | 2161 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-06-24 04:20:58 | Marshall, Minnesota, US | |
2311117 | 2311117 | 2022-06-17 | China | Yunnan | 2161 | 2 | 0 | 24.974 | 101.487 | 2022-06-18 04:21:10 | Yunnan, China | |||
562142 | 562142 | 2022-06-16 | US | Virginia | Fairfax City | 51600 | 2161 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-06-17 04:20:56 | Fairfax City, Virginia, US | |
3136712 | 3136712 | 2022-06-03 | US | Texas | Live Oak | 48297 | 2161 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-04 04:20:58 | Live Oak, Texas, US | |
3581787 | 3581787 | 2022-06-02 | US | Texas | Live Oak | 48297 | 2161 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-03 04:20:58 | Live Oak, Texas, US | |
3581694 | 3581694 | 2022-06-02 | US | Texas | Dallam | 48111 | 2161 | 40 | 0 | 36.27787176 | -102.6020725 | 2022-06-03 04:20:58 | Dallam, Texas, US | |
974080 | 974080 | 2022-06-01 | US | Texas | Live Oak | 48297 | 2161 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-02 05:20:39 | Live Oak, Texas, US | |
232387 | 232387 | 2022-05-31 | US | Texas | Live Oak | 48297 | 2161 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-06-01 04:20:55 | Live Oak, Texas, US | |
1111370 | 1111370 | 2022-05-21 | US | Mississippi | Claiborne | 28021 | 2161 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-05-22 04:20:52 | Claiborne, Mississippi, US | |
1111309 | 1111309 | 2022-05-21 | US | Minnesota | Lake | 27075 | 2161 | 28 | 0 | 47.64270764 | -91.44557998 | 2022-05-22 04:20:52 | Lake, Minnesota, US | |
1170994 | 1170994 | 2022-05-20 | US | Mississippi | Claiborne | 28021 | 2161 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-05-21 04:20:58 | Claiborne, Mississippi, US | |
1170933 | 1170933 | 2022-05-20 | US | Minnesota | Lake | 27075 | 2161 | 28 | 0 | 47.64270764 | -91.44557998 | 2022-05-21 04:20:58 | Lake, Minnesota, US | |
3897757 | 3897757 | 2022-05-19 | US | Mississippi | Claiborne | 28021 | 2161 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-05-20 04:20:57 | Claiborne, Mississippi, US | |
1186541 | 1186541 | 2022-05-18 | US | Mississippi | Claiborne | 28021 | 2161 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-05-19 04:20:54 | Claiborne, Mississippi, US | |
3584438 | 3584438 | 2022-05-17 | US | Mississippi | Claiborne | 28021 | 2161 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-05-18 04:20:50 | Claiborne, Mississippi, US | |
1505395 | 1505395 | 2022-05-16 | US | Mississippi | Claiborne | 28021 | 2161 | 46 | 0 | 31.97061673 | -90.90702196 | 2022-05-17 04:20:59 | Claiborne, Mississippi, US | |
2599953 | 2599953 | 2022-05-05 | US | Missouri | Gentry | 29075 | 2161 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-06 04:21:00 | Gentry, Missouri, US | |
3267402 | 3267402 | 2022-05-04 | US | Missouri | Gentry | 29075 | 2161 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-05 04:20:55 | Gentry, Missouri, US | |
3267225 | 3267225 | 2022-05-04 | US | Minnesota | Jackson | 27063 | 2161 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-05-05 04:20:55 | Jackson, Minnesota, US | |
1574041 | 1574041 | 2022-05-03 | US | Missouri | Gentry | 29075 | 2161 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-04 04:20:59 | Gentry, Missouri, US | |
465301 | 465301 | 2022-05-02 | US | Missouri | Gentry | 29075 | 2161 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-03 04:21:00 | Gentry, Missouri, US | |
3917940 | 3917940 | 2022-05-01 | US | Missouri | Gentry | 29075 | 2161 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-02 04:21:10 | Gentry, Missouri, US | |
2842744 | 2842744 | 2022-04-30 | US | Missouri | Gentry | 29075 | 2161 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-05-01 04:20:57 | Gentry, Missouri, US | |
1159057 | 1159057 | 2022-04-29 | US | Missouri | Gentry | 29075 | 2161 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-04-30 04:21:05 | Gentry, Missouri, US | |
1698239 | 1698239 | 2022-04-28 | US | Missouri | Gentry | 29075 | 2161 | 31 | 0 | 40.21097916 | -94.40944419 | 2022-04-29 04:20:59 | Gentry, Missouri, US | |
3855200 | 3855200 | 2022-04-27 | US | Virginia | Northampton | 51131 | 2161 | 64 | 0 | 37.34062933 | -75.87751591 | 2022-04-28 04:20:47 | Northampton, Virginia, US | |
3725584 | 3725584 | 2022-04-25 | US | Virginia | Northampton | 51131 | 2161 | 63 | 0 | 37.34062933 | -75.87751591 | 2022-04-26 04:20:51 | Northampton, Virginia, US | |
3723912 | 3723912 | 2022-04-25 | US | Minnesota | Clearwater | 27029 | 2161 | 30 | 0 | 47.57992111 | -95.37790562 | 2022-04-26 04:20:51 | Clearwater, Minnesota, US | |
2254441 | 2254441 | 2022-04-19 | US | Texas | Archer | 48009 | 2161 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-04-20 04:20:45 | Archer, Texas, US | |
1471484 | 1471484 | 2022-03-24 | US | Virginia | Northumberland | 51133 | 2161 | 44 | 0 | 37.89202088 | -76.41949732 | 2022-03-25 04:20:46 | Northumberland, Virginia, US | |
1906312 | 1906312 | 2022-03-22 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-23 04:20:48 | Martin, Indiana, US | |
3239443 | 3239443 | 2022-03-21 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-22 04:20:54 | Martin, Indiana, US | |
25516 | 25516 | 2022-03-20 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-21 04:20:50 | Martin, Indiana, US | |
1657526 | 1657526 | 2022-03-19 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-20 04:20:45 | Martin, Indiana, US | |
337052 | 337052 | 2022-03-18 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-19 04:20:47 | Martin, Indiana, US | |
695505 | 695505 | 2022-03-17 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-18 04:20:55 | Martin, Indiana, US | |
2320448 | 2320448 | 2022-03-16 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-17 04:20:56 | Martin, Indiana, US | |
262648 | 262648 | 2022-03-15 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-16 04:20:50 | Martin, Indiana, US | |
2265007 | 2265007 | 2022-03-14 | US | Indiana | Martin | 18101 | 2161 | 24 | 0 | 38.7099921 | -86.80373186 | 2022-03-15 04:20:47 | Martin, Indiana, US | |
2140994 | 2140994 | 2022-03-09 | US | Georgia | Heard | 13149 | 2161 | 49 | 0 | 33.29686567 | -85.12886832 | 2022-03-10 04:20:48 | Heard, Georgia, US | |
921621 | 921621 | 2022-03-08 | US | Missouri | Monroe | 29137 | 2161 | 40 | 0 | 39.49593978 | -92.00043978 | 2022-03-09 04:20:59 | Monroe, Missouri, US | |
2200461 | 2200461 | 2022-03-06 | US | Georgia | Heard | 13149 | 2161 | 49 | 0 | 33.29686567 | -85.12886832 | 2022-03-07 04:20:47 | Heard, Georgia, US | |
2092918 | 2092918 | 2022-03-05 | US | Georgia | Heard | 13149 | 2161 | 49 | 0 | 33.29686567 | -85.12886832 | 2022-03-06 04:20:49 | Heard, Georgia, US | |
2666618 | 2666618 | 2022-03-04 | US | Georgia | Heard | 13149 | 2161 | 49 | 0 | 33.29686567 | -85.12886832 | 2022-03-05 04:21:10 | Heard, Georgia, US | |
1645766 | 1645766 | 2022-03-03 | US | Kentucky | Gallatin | 21077 | 2161 | 45 | 0 | 38.75398691 | -84.8558382 | 2022-03-04 04:21:09 | Gallatin, Kentucky, US | |
1645183 | 1645183 | 2022-03-03 | US | Georgia | Heard | 13149 | 2161 | 49 | 0 | 33.29686567 | -85.12886832 | 2022-03-04 04:21:09 | Heard, Georgia, US | |
2527184 | 2527184 | 2022-03-02 | US | Mississippi | Kemper | 28069 | 2161 | 47 | 0 | 32.75462946 | -88.64105766 | 2022-03-03 04:21:01 | Kemper, Mississippi, US | |
2526186 | 2526186 | 2022-03-02 | US | Georgia | Heard | 13149 | 2161 | 49 | 0 | 33.29686567 | -85.12886832 | 2022-03-03 04:21:01 | Heard, Georgia, US | |
1994478 | 1994478 | 2022-03-01 | US | Mississippi | Kemper | 28069 | 2161 | 47 | 0 | 32.75462946 | -88.64105766 | 2022-03-02 04:21:07 | Kemper, Mississippi, 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]);