johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
173 rows where confirmed = 5065 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221328 | 221328 | 2022-12-26 | US | Virginia | Giles | 51071 | 5065 | 54 | 0 | 37.31234791 | -80.70636931 | 2022-12-27 04:21:07 | Giles, Virginia, US | |
693110 | 693110 | 2022-12-23 | US | Puerto Rico | Ciales | 72039 | 5065 | 0 | 0 | 18.28885 | -66.516475 | 2022-12-24 04:21:02 | Ciales, Puerto Rico, US | |
308868 | 308868 | 2022-12-13 | US | Illinois | De Witt | 17039 | 5065 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-12-14 04:21:04 | De Witt, Illinois, US | |
1149438 | 1149438 | 2022-12-12 | US | Arkansas | Grant | 5053 | 5065 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-13 04:21:01 | Grant, Arkansas, US | |
869292 | 869292 | 2022-12-11 | US | Arkansas | Grant | 5053 | 5065 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-12 04:21:01 | Grant, Arkansas, US | |
2066677 | 2066677 | 2022-11-19 | US | Puerto Rico | Patillas | 72109 | 5065 | 0 | 0 | 18.03174 | -66.012242 | 2022-11-20 04:21:08 | Patillas, Puerto Rico, US | |
3597690 | 3597690 | 2022-11-14 | US | Colorado | Otero | 8089 | 5065 | 133 | 0 | 37.9014485 | -103.7173385 | 2022-11-15 04:21:16 | Otero, Colorado, US | |
3039331 | 3039331 | 2022-10-27 | US | Illinois | Hancock | 17067 | 5065 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-10-28 04:22:31 | Hancock, Illinois, US | |
2686244 | 2686244 | 2022-10-03 | US | California | Colusa | 6011 | 5065 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-04 04:22:55 | Colusa, California, US | |
2260311 | 2260311 | 2022-10-02 | US | California | Colusa | 6011 | 5065 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-10-03 04:23:11 | Colusa, California, US | |
1627831 | 1627831 | 2022-09-22 | US | Wisconsin | Crawford | 55023 | 5065 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-09-23 04:23:13 | Crawford, Wisconsin, US | |
3774753 | 3774753 | 2022-08-30 | US | Georgia | Meriwether | 13199 | 5065 | 149 | 0 | 33.04163534 | -84.68859732 | 2022-08-31 04:20:57 | Meriwether, Georgia, US | |
1682014 | 1682014 | 2022-08-29 | US | Louisiana | Jackson | 22049 | 5065 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-30 04:21:03 | Jackson, Louisiana, US | |
1681349 | 1681349 | 2022-08-29 | US | Georgia | Meriwether | 13199 | 5065 | 149 | 0 | 33.04163534 | -84.68859732 | 2022-08-30 04:21:03 | Meriwether, Georgia, US | |
1877833 | 1877833 | 2022-08-28 | US | Georgia | Meriwether | 13199 | 5065 | 149 | 0 | 33.04163534 | -84.68859732 | 2022-08-29 04:21:06 | Meriwether, Georgia, US | |
2096960 | 2096960 | 2022-08-27 | US | Georgia | Meriwether | 13199 | 5065 | 149 | 0 | 33.04163534 | -84.68859732 | 2022-08-28 04:21:02 | Meriwether, Georgia, US | |
1532775 | 1532775 | 2022-08-26 | US | Georgia | Meriwether | 13199 | 5065 | 149 | 0 | 33.04163534 | -84.68859732 | 2022-08-27 04:20:57 | Meriwether, Georgia, US | |
2831734 | 2831734 | 2022-08-25 | US | Tennessee | Bledsoe | 47007 | 5065 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-08-26 04:21:02 | Bledsoe, Tennessee, US | |
2829662 | 2829662 | 2022-08-25 | US | Georgia | Meriwether | 13199 | 5065 | 149 | 0 | 33.04163534 | -84.68859732 | 2022-08-26 04:21:02 | Meriwether, Georgia, US | |
2324195 | 2324195 | 2022-08-24 | US | Georgia | Meriwether | 13199 | 5065 | 149 | 0 | 33.04163534 | -84.68859732 | 2022-08-25 04:21:13 | Meriwether, Georgia, US | |
1163145 | 1163145 | 2022-08-18 | US | Missouri | Texas | 29215 | 5065 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-19 04:20:54 | Texas, Missouri, US | |
3952469 | 3952469 | 2022-08-17 | US | Missouri | Texas | 29215 | 5065 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-18 04:21:11 | Texas, Missouri, US | |
992971 | 992971 | 2022-08-16 | US | Missouri | Texas | 29215 | 5065 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-17 04:20:59 | Texas, Missouri, US | |
2496810 | 2496810 | 2022-08-15 | US | Puerto Rico | Sabana Grande | 72121 | 5065 | 0 | 0 | 18.08282 | -66.943758 | 2022-08-16 04:20:58 | Sabana Grande, Puerto Rico, US | |
2496010 | 2496010 | 2022-08-15 | US | Missouri | Texas | 29215 | 5065 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-16 04:20:58 | Texas, Missouri, US | |
3649560 | 3649560 | 2022-08-14 | US | Missouri | Texas | 29215 | 5065 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-15 04:20:59 | Texas, Missouri, US | |
1970566 | 1970566 | 2022-08-13 | US | Missouri | Texas | 29215 | 5065 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-14 04:20:55 | Texas, Missouri, US | |
2890375 | 2890375 | 2022-08-12 | US | Missouri | Texas | 29215 | 5065 | 107 | 0 | 37.31728859 | -91.96564727 | 2022-08-13 04:20:52 | Texas, Missouri, US | |
1408029 | 1408029 | 2022-08-02 | US | Tennessee | Polk | 47139 | 5065 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-08-03 04:20:59 | Polk, Tennessee, US | |
1406171 | 1406171 | 2022-08-02 | US | Indiana | Perry | 18123 | 5065 | 69 | 0 | 38.07809328 | -86.63741946 | 2022-08-03 04:20:59 | Perry, Indiana, US | |
3620067 | 3620067 | 2022-08-01 | US | Tennessee | Polk | 47139 | 5065 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-08-02 04:20:53 | Polk, Tennessee, US | |
3618209 | 3618209 | 2022-08-01 | US | Indiana | Perry | 18123 | 5065 | 69 | 0 | 38.07809328 | -86.63741946 | 2022-08-02 04:20:53 | Perry, Indiana, US | |
3872053 | 3872053 | 2022-07-31 | US | Arkansas | Hempstead | 5057 | 5065 | 70 | 0 | 33.73325583 | -93.66935133 | 2022-08-01 04:21:03 | Hempstead, Arkansas, US | |
3969982 | 3969982 | 2022-07-05 | US | Washington | Adams | 53001 | 5065 | 39 | 0 | 46.98299757 | -118.5601734 | 2022-07-06 04:20:58 | Adams, Washington, US | |
3081493 | 3081493 | 2022-07-04 | US | Washington | Adams | 53001 | 5065 | 39 | 0 | 46.98299757 | -118.5601734 | 2022-07-05 04:20:45 | Adams, Washington, US | |
1770775 | 1770775 | 2022-07-03 | US | Washington | Adams | 53001 | 5065 | 39 | 0 | 46.98299757 | -118.5601734 | 2022-07-04 04:20:54 | Adams, Washington, US | |
3368761 | 3368761 | 2022-07-02 | US | Washington | Adams | 53001 | 5065 | 39 | 0 | 46.98299757 | -118.5601734 | 2022-07-03 04:20:59 | Adams, Washington, US | |
597090 | 597090 | 2022-07-01 | US | Washington | Adams | 53001 | 5065 | 39 | 0 | 46.98299757 | -118.5601734 | 2022-07-02 04:21:16 | Adams, Washington, US | |
2242577 | 2242577 | 2022-06-28 | US | Texas | Milam | 48331 | 5065 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-06-29 04:20:59 | Milam, Texas, US | |
1649311 | 1649311 | 2022-06-23 | US | Idaho | Cassia | 16031 | 5065 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-24 04:20:58 | Cassia, Idaho, US | |
1648986 | 1648986 | 2022-06-23 | US | Colorado | Chaffee | 8015 | 5065 | 50 | 0 | 38.74745778 | -106.1926573 | 2022-06-24 04:20:58 | Chaffee, Colorado, US | |
2188546 | 2188546 | 2022-06-22 | US | Idaho | Cassia | 16031 | 5065 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-23 04:20:55 | Cassia, Idaho, US | |
948569 | 948569 | 2022-06-14 | US | Minnesota | Fillmore | 27045 | 5065 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-06-15 04:20:54 | Fillmore, Minnesota, US | |
3581664 | 3581664 | 2022-06-02 | US | Texas | Burleson | 48051 | 5065 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-06-03 04:20:58 | Burleson, Texas, US | |
3578778 | 3578778 | 2022-06-02 | Palau | 5065 | 6 | 0 | 7.515 | 134.5825 | 2022-06-03 04:20:58 | Palau | ||||
973957 | 973957 | 2022-06-01 | US | Texas | Burleson | 48051 | 5065 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-06-02 05:20:39 | Burleson, Texas, US | |
971071 | 971071 | 2022-06-01 | Palau | 5065 | 6 | 0 | 7.515 | 134.5825 | 2022-06-02 05:20:39 | Palau | ||||
229378 | 229378 | 2022-05-31 | Palau | 5065 | 6 | 0 | 7.515 | 134.5825 | 2022-06-01 04:20:55 | Palau | ||||
2334855 | 2334855 | 2022-05-08 | US | West Virginia | Brooke | 54009 | 5065 | 104 | 0 | 40.27367263 | -80.57915332 | 2022-05-09 04:20:54 | Brooke, West Virginia, US | |
363817 | 363817 | 2022-05-07 | US | West Virginia | Brooke | 54009 | 5065 | 104 | 0 | 40.27367263 | -80.57915332 | 2022-05-08 04:20:49 | Brooke, West Virginia, US | |
1401168 | 1401168 | 2022-05-06 | US | West Virginia | Brooke | 54009 | 5065 | 104 | 0 | 40.27367263 | -80.57915332 | 2022-05-07 04:21:09 | Brooke, West Virginia, US | |
2030148 | 2030148 | 2022-04-24 | US | Kentucky | Breckinridge | 21027 | 5065 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-04-25 04:20:56 | Breckinridge, Kentucky, US | |
747723 | 747723 | 2022-04-23 | US | Kentucky | Breckinridge | 21027 | 5065 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-04-24 04:20:56 | Breckinridge, Kentucky, US | |
3438208 | 3438208 | 2022-04-22 | US | Kentucky | Breckinridge | 21027 | 5065 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-04-23 04:20:50 | Breckinridge, Kentucky, US | |
2893793 | 2893793 | 2022-04-21 | US | Kentucky | Breckinridge | 21027 | 5065 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-04-22 04:20:45 | Breckinridge, Kentucky, US | |
2308665 | 2308665 | 2022-04-20 | US | Kentucky | Breckinridge | 21027 | 5065 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-04-21 04:20:46 | Breckinridge, Kentucky, US | |
2252804 | 2252804 | 2022-04-19 | US | Kentucky | Breckinridge | 21027 | 5065 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-04-20 04:20:45 | Breckinridge, Kentucky, US | |
1847354 | 1847354 | 2022-04-18 | US | Kentucky | Breckinridge | 21027 | 5065 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-04-19 04:21:00 | Breckinridge, Kentucky, US | |
2672081 | 2672081 | 2022-04-15 | US | New York | Schoharie | 36095 | 5065 | 36 | 0 | 42.58831742 | -74.44339029999998 | 2022-04-16 04:20:48 | Schoharie, New York, US | |
2444734 | 2444734 | 2022-04-13 | US | Missouri | Vernon | 29217 | 5065 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-13 23:21:06 | Vernon, Missouri, US | |
1950491 | 1950491 | 2022-04-12 | US | Missouri | Vernon | 29217 | 5065 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-13 04:21:03 | Vernon, Missouri, US | |
3208244 | 3208244 | 2022-04-11 | US | Missouri | Vernon | 29217 | 5065 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-12 04:20:49 | Vernon, Missouri, US | |
1578130 | 1578130 | 2022-04-10 | US | Missouri | Vernon | 29217 | 5065 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-11 04:21:02 | Vernon, Missouri, US | |
1654372 | 1654372 | 2022-04-09 | US | Missouri | Vernon | 29217 | 5065 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-10 04:20:52 | Vernon, Missouri, US | |
2117694 | 2117694 | 2022-04-08 | US | Missouri | Vernon | 29217 | 5065 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-09 04:20:42 | Vernon, Missouri, US | |
3322218 | 3322218 | 2022-04-07 | US | Missouri | Vernon | 29217 | 5065 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-04-08 04:20:48 | Vernon, Missouri, US | |
3353365 | 3353365 | 2022-04-01 | US | Pennsylvania | Wyoming | 42131 | 5065 | 104 | 0 | 41.51955538 | -76.01074915 | 2022-04-02 04:20:47 | Wyoming, Pennsylvania, US | |
2480683 | 2480683 | 2022-03-30 | US | Pennsylvania | Wyoming | 42131 | 5065 | 104 | 0 | 41.51955538 | -76.01074915 | 2022-03-31 04:20:56 | Wyoming, Pennsylvania, US | |
160353 | 160353 | 2022-03-29 | US | North Carolina | Madison | 37115 | 5065 | 79 | 0 | 35.85402722 | -82.71346418 | 2022-03-30 04:20:45 | Madison, North Carolina, US | |
1438924 | 1438924 | 2022-03-28 | US | North Carolina | Madison | 37115 | 5065 | 79 | 0 | 35.85402722 | -82.71346418 | 2022-03-29 04:20:46 | Madison, North Carolina, US | |
3025824 | 3025824 | 2022-03-23 | US | Wisconsin | Green Lake | 55047 | 5065 | 62 | 0 | 43.80025981 | -89.04679553 | 2022-03-24 04:20:43 | Green Lake, Wisconsin, US | |
3238728 | 3238728 | 2022-03-21 | US | Alabama | Randolph | 1111 | 5065 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-03-22 04:20:54 | Randolph, Alabama, US | |
24801 | 24801 | 2022-03-20 | US | Alabama | Randolph | 1111 | 5065 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-03-21 04:20:50 | Randolph, Alabama, US | |
1656811 | 1656811 | 2022-03-19 | US | Alabama | Randolph | 1111 | 5065 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-03-20 04:20:45 | Randolph, Alabama, US | |
336337 | 336337 | 2022-03-18 | US | Alabama | Randolph | 1111 | 5065 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-03-19 04:20:47 | Randolph, Alabama, US | |
2199820 | 2199820 | 2022-03-06 | Peru | Unknown | 5065 | 201 | 0 | 2022-03-07 04:20:47 | Unknown, Peru | |||||
982291 | 982291 | 2022-02-01 | US | Virginia | Fredericksburg | 51630 | 5065 | 29 | 0 | 38.2977863 | -77.4922454 | 2022-02-02 04:21:09 | Fredericksburg, Virginia, US | |
982130 | 982130 | 2022-02-01 | US | Texas | Moore | 48341 | 5065 | 104 | 0 | 35.83769242 | -101.8930281 | 2022-02-02 04:21:09 | Moore, Texas, US | |
3226721 | 3226721 | 2022-01-19 | Saint Kitts and Nevis | 5065 | 28 | 0 | 17.357822 | -62.782998 | 2022-01-20 04:21:07 | Saint Kitts and Nevis | ||||
1475049 | 1475049 | 2022-01-17 | US | Tennessee | DeKalb | 47041 | 5065 | 91 | 0 | 35.97616272 | -85.83689361 | 2022-01-18 04:21:04 | DeKalb, Tennessee, US | |
1474311 | 1474311 | 2022-01-17 | US | New Mexico | Grant | 35017 | 5065 | 70 | 0 | 32.73911281 | -108.3827845 | 2022-01-18 04:21:04 | Grant, New Mexico, US | |
556985 | 556985 | 2022-01-16 | US | New Mexico | Grant | 35017 | 5065 | 70 | 0 | 32.73911281 | -108.3827845 | 2022-01-17 04:21:08 | Grant, New Mexico, US | |
3842706 | 3842706 | 2022-01-15 | US | New Mexico | Grant | 35017 | 5065 | 70 | 0 | 32.73911281 | -108.3827845 | 2022-01-16 04:21:12 | Grant, New Mexico, US | |
101521 | 101521 | 2022-01-14 | US | New Mexico | Grant | 35017 | 5065 | 70 | 0 | 32.73911281 | -108.3827845 | 2022-01-15 04:21:07 | Grant, New Mexico, US | |
2610585 | 2610585 | 2022-01-06 | US | Arkansas | Yell | 5149 | 5065 | 90 | 0 | 35.00292371 | -93.41171338 | 2022-01-07 04:22:09 | Yell, Arkansas, US | |
1287853 | 1287853 | 2022-01-04 | US | Mississippi | Simpson | 28127 | 5065 | 117 | 0 | 31.91282117 | -89.91716179 | 2022-01-05 04:21:59 | Simpson, Mississippi, US | |
1661267 | 1661267 | 2021-12-12 | US | Georgia | Madison | 13195 | 5065 | 81 | 0 | 34.12920917 | -83.21218732 | 2021-12-13 04:22:02 | Madison, Georgia, US | |
1665283 | 1665283 | 2021-12-11 | US | Georgia | Madison | 13195 | 5065 | 81 | 0 | 34.12920917 | -83.21218732 | 2021-12-12 04:22:12 | Madison, Georgia, US | |
3656435 | 3656435 | 2021-12-10 | US | Georgia | Madison | 13195 | 5065 | 81 | 0 | 34.12920917 | -83.21218732 | 2021-12-11 04:22:45 | Madison, Georgia, US | |
407792 | 407792 | 2021-12-07 | US | West Virginia | Mineral | 54057 | 5065 | 127 | 0 | 39.41561583 | -78.94104895 | 2021-12-08 04:22:46 | Mineral, West Virginia, US | |
2198693 | 2198693 | 2021-12-03 | US | Texas | DeWitt | 48123 | 5065 | 85 | 0 | 29.08101855 | -97.35681170000001 | 2021-12-04 04:22:18 | DeWitt, Texas, US | |
3345877 | 3345877 | 2021-11-16 | US | Texas | Willacy | 48489 | 5065 | 112 | 0 | 26.47411727 | -97.61535848 | 2021-11-17 04:21:48 | Willacy, Texas, US | |
2290713 | 2290713 | 2021-11-15 | US | Texas | Willacy | 48489 | 5065 | 112 | 0 | 26.47411727 | -97.61535848 | 2021-11-16 04:21:10 | Willacy, Texas, US | |
1325487 | 1325487 | 2021-11-14 | US | Texas | Willacy | 48489 | 5065 | 112 | 0 | 26.47411727 | -97.61535848 | 2021-11-15 04:21:36 | Willacy, Texas, US | |
1322630 | 1322630 | 2021-11-14 | US | Alabama | Pike | 1109 | 5065 | 108 | 0 | 31.80396383 | -85.9408295 | 2021-11-15 04:21:36 | Pike, Alabama, US | |
689613 | 689613 | 2021-11-13 | US | Texas | Willacy | 48489 | 5065 | 112 | 0 | 26.47411727 | -97.61535848 | 2021-11-14 04:21:31 | Willacy, Texas, US | |
717722 | 717722 | 2021-11-12 | US | Texas | Willacy | 48489 | 5065 | 112 | 0 | 26.47411727 | -97.61535848 | 2021-11-13 04:21:38 | Willacy, Texas, US | |
28815 | 28815 | 2021-11-11 | US | Alabama | Pike | 1109 | 5065 | 108 | 0 | 31.80396383 | -85.9408295 | 2021-11-12 04:22:01 | Pike, Alabama, US | |
3641356 | 3641356 | 2021-11-08 | US | Mississippi | George | 28039 | 5065 | 80 | 0 | 30.86259065 | -88.64436789 | 2021-11-09 04:21:36 | George, Mississippi, US | |
3514526 | 3514526 | 2021-11-01 | US | Texas | Hopkins | 48223 | 5065 | 146 | 0 | 33.14875072 | -95.56351139 | 2021-11-02 04:22:03 | Hopkins, Texas, 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]);