johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
156 rows where confirmed = 3750 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954297 | 2954297 | 2022-12-20 | US | South Dakota | Todd | 46121 | 3750 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-12-21 04:21:03 | Todd, South Dakota, US | |
3176699 | 3176699 | 2022-12-19 | US | South Dakota | Todd | 46121 | 3750 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-12-20 04:21:04 | Todd, South Dakota, US | |
1631216 | 1631216 | 2022-12-18 | US | South Dakota | Todd | 46121 | 3750 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-12-19 04:21:03 | Todd, South Dakota, US | |
506595 | 506595 | 2022-12-17 | US | South Dakota | Todd | 46121 | 3750 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-12-18 04:21:03 | Todd, South Dakota, US | |
3327167 | 3327167 | 2022-12-16 | US | South Dakota | Todd | 46121 | 3750 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-12-17 04:21:04 | Todd, South Dakota, US | |
545679 | 545679 | 2022-12-15 | US | South Dakota | Todd | 46121 | 3750 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-12-16 04:21:01 | Todd, South Dakota, US | |
351207 | 351207 | 2022-12-14 | US | South Dakota | Todd | 46121 | 3750 | 53 | 0 | 43.19338568 | -100.7195503 | 2022-12-15 04:20:58 | Todd, South Dakota, US | |
1966993 | 1966993 | 2022-11-30 | US | North Dakota | Mountrail | 38061 | 3750 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-12-01 04:21:03 | Mountrail, North Dakota, US | |
2558110 | 2558110 | 2022-11-29 | US | Louisiana | Madison | 22065 | 3750 | 64 | 0 | 32.36918118 | -91.23973355 | 2022-11-30 04:21:07 | Madison, Louisiana, US | |
1241184 | 1241184 | 2022-11-28 | US | Louisiana | Madison | 22065 | 3750 | 64 | 0 | 32.36918118 | -91.23973355 | 2022-11-29 04:21:05 | Madison, Louisiana, US | |
3553172 | 3553172 | 2022-11-27 | US | Louisiana | Madison | 22065 | 3750 | 64 | 0 | 32.36918118 | -91.23973355 | 2022-11-28 04:21:02 | Madison, Louisiana, US | |
2101652 | 2101652 | 2022-11-26 | US | Louisiana | Madison | 22065 | 3750 | 64 | 0 | 32.36918118 | -91.23973355 | 2022-11-27 04:21:05 | Madison, Louisiana, US | |
489143 | 489143 | 2022-11-25 | US | Louisiana | Madison | 22065 | 3750 | 64 | 0 | 32.36918118 | -91.23973355 | 2022-11-26 04:21:11 | Madison, Louisiana, US | |
3524972 | 3524972 | 2022-11-24 | US | Louisiana | Madison | 22065 | 3750 | 64 | 0 | 32.36918118 | -91.23973355 | 2022-11-25 04:21:06 | Madison, Louisiana, US | |
3313755 | 3313755 | 2022-11-23 | US | Louisiana | Madison | 22065 | 3750 | 64 | 0 | 32.36918118 | -91.23973355 | 2022-11-24 04:21:09 | Madison, Louisiana, US | |
2259569 | 2259569 | 2022-10-02 | China | Shaanxi | 3750 | 3 | 0 | 35.1917 | 108.8701 | 2022-10-03 04:23:11 | Shaanxi, China | |||
387001 | 387001 | 2022-09-23 | US | Puerto Rico | Rincon | 72117 | 3750 | 0 | 0 | 18.335443 | -67.23174 | 2022-09-24 04:21:40 | Rincon, Puerto Rico, US | |
2403341 | 2403341 | 2022-08-21 | US | Arkansas | Marion | 5089 | 3750 | 90 | 0 | 36.26844485 | -92.68451899 | 2022-08-22 04:20:38 | Marion, Arkansas, US | |
3798419 | 3798419 | 2022-08-20 | US | Arkansas | Marion | 5089 | 3750 | 90 | 0 | 36.26844485 | -92.68451899 | 2022-08-21 04:20:44 | Marion, Arkansas, US | |
3910745 | 3910745 | 2022-08-11 | US | Puerto Rico | Florida | 72054 | 3750 | 0 | 0 | 18.373715 | -66.560488 | 2022-08-12 04:20:54 | Florida, Puerto Rico, US | |
1089041 | 1089041 | 2022-08-09 | US | Tennessee | Lewis | 47101 | 3750 | 63 | 0 | 35.52853208 | -87.49022694 | 2022-08-10 04:20:57 | Lewis, Tennessee, US | |
1101647 | 1101647 | 2022-08-03 | US | Wisconsin | Ashland | 55003 | 3750 | 39 | 0 | 46.31956891 | -90.67837132 | 2022-08-04 04:20:58 | Ashland, Wisconsin, US | |
960022 | 960022 | 2022-07-19 | US | Indiana | Parke | 18121 | 3750 | 50 | 0 | 39.77202286 | -87.20375833 | 2022-07-20 04:20:59 | Parke, Indiana, US | |
2240950 | 2240950 | 2022-06-28 | US | Louisiana | West Carroll | 22123 | 3750 | 66 | 0 | 32.78550125 | -91.461201 | 2022-06-29 04:20:59 | West Carroll, Louisiana, US | |
559442 | 559442 | 2022-06-16 | US | Colorado | Las Animas | 8071 | 3750 | 44 | 0 | 37.3153406 | -104.0376458 | 2022-06-17 04:20:56 | Las Animas, Colorado, US | |
3580380 | 3580380 | 2022-06-02 | US | Minnesota | Pennington | 27113 | 3750 | 41 | 0 | 48.06642577 | -96.0370814 | 2022-06-03 04:20:58 | Pennington, Minnesota, US | |
229638 | 229638 | 2022-05-31 | US | Alabama | Washington | 1129 | 3750 | 59 | 0 | 31.4092794 | -88.20689944 | 2022-06-01 04:20:55 | Washington, Alabama, US | |
3187048 | 3187048 | 2022-05-30 | US | Illinois | Wabash | 17185 | 3750 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-05-31 04:20:51 | Wabash, Illinois, US | |
3199197 | 3199197 | 2022-05-29 | US | Illinois | Wabash | 17185 | 3750 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-05-30 04:20:50 | Wabash, Illinois, US | |
2726075 | 2726075 | 2022-05-28 | US | Illinois | Wabash | 17185 | 3750 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-05-29 04:20:53 | Wabash, Illinois, US | |
1315256 | 1315256 | 2022-05-27 | US | Illinois | Wabash | 17185 | 3750 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-05-28 04:21:07 | Wabash, Illinois, US | |
2048250 | 2048250 | 2022-05-25 | US | Alabama | Lamar | 1075 | 3750 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-05-26 04:20:50 | Lamar, Alabama, US | |
2999688 | 2999688 | 2022-05-24 | US | Alabama | Lamar | 1075 | 3750 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-05-25 04:20:56 | Lamar, Alabama, US | |
622261 | 622261 | 2022-05-22 | US | Alabama | Lamar | 1075 | 3750 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-05-26 04:20:50 | Lamar, Alabama, US | |
2536662 | 2536662 | 2022-05-12 | US | Texas | Zapata | 48505 | 3750 | 55 | 0 | 27.00156391 | -99.16987152 | 2022-05-13 04:20:51 | Zapata, Texas, US | |
3322369 | 3322369 | 2022-04-07 | US | Nebraska | Unassigned | 90031 | 3750 | 756 | 0 | 42.8997274 | 0.0 | 2022-04-08 04:20:48 | Unassigned, Nebraska, US | |
878994 | 878994 | 2022-03-27 | US | Puerto Rico | Catano | 72033 | 3750 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-03-28 04:20:33 | Catano, Puerto Rico, US | |
264588 | 264588 | 2022-03-15 | US | Texas | Colorado | 48089 | 3750 | 61 | 0 | 29.622097999999998 | -96.5273805 | 2022-03-16 04:20:50 | Colorado, Texas, US | |
1551453 | 1551453 | 2022-03-07 | US | West Virginia | Grant | 54023 | 3750 | 56 | 0 | 39.10314817 | -79.19440518 | 2022-03-08 04:20:54 | Grant, West Virginia, US | |
2450085 | 2450085 | 2022-02-22 | US | Virginia | Buckingham | 51029 | 3750 | 48 | 0 | 37.57242268 | -78.52518834 | 2022-02-23 04:21:09 | Buckingham, Virginia, US | |
2449131 | 2449131 | 2022-02-22 | US | North Carolina | Polk | 37149 | 3750 | 50 | 0 | 35.27820615 | -82.16812354 | 2022-02-23 04:21:09 | Polk, North Carolina, US | |
2448987 | 2448987 | 2022-02-22 | US | New Mexico | Socorro | 35053 | 3750 | 85 | 0 | 34.00715494 | -106.9298354 | 2022-02-23 04:21:09 | Socorro, New Mexico, US | |
3672017 | 3672017 | 2022-02-15 | US | Alabama | Crenshaw | 1041 | 3750 | 85 | 0 | 31.72941803 | -86.31593104 | 2022-02-16 04:21:10 | Crenshaw, Alabama, US | |
2643178 | 2643178 | 2022-02-14 | US | Kentucky | Knott | 21119 | 3750 | 55 | 0 | 37.35388197 | -82.94981134 | 2022-02-15 04:21:09 | Knott, Kentucky, US | |
3075805 | 3075805 | 2022-02-09 | US | Minnesota | Redwood | 27127 | 3750 | 52 | 0 | 44.40555844 | -95.25207021 | 2022-02-10 04:21:14 | Redwood, Minnesota, US | |
462660 | 462660 | 2022-02-02 | US | Vermont | Addison | 50001 | 3750 | 13 | 0 | 44.03217337 | -73.14130877 | 2022-02-03 04:21:21 | Addison, Vermont, US | |
981977 | 981977 | 2022-02-01 | US | Texas | Bosque | 48035 | 3750 | 62 | 0 | 31.89978581 | -97.63613524 | 2022-02-02 04:21:09 | Bosque, Texas, US | |
2661401 | 2661401 | 2022-01-31 | US | Wyoming | Lincoln | 56023 | 3750 | 27 | 0 | 42.26376367 | -110.6563997 | 2022-02-01 04:21:11 | Lincoln, Wyoming, US | |
1474608 | 1474608 | 2022-01-17 | US | Ohio | Meigs | 39105 | 3750 | 79 | 0 | 39.09224872 | -82.0305041 | 2022-01-18 04:21:04 | Meigs, Ohio, US | |
1700821 | 1700821 | 2022-01-03 | US | Arkansas | Clark | 5019 | 3750 | 66 | 0 | 34.04613432 | -93.17484713 | 2022-01-04 04:22:17 | Clark, Arkansas, US | |
1669991 | 1669991 | 2021-12-29 | US | Louisiana | St. James | 22093 | 3750 | 70 | 0 | 30.02531716 | -90.80212061 | 2021-12-30 04:21:25 | St. James, Louisiana, US | |
1433459 | 1433459 | 2021-12-28 | US | Georgia | Union | 13291 | 3750 | 132 | 0 | 34.82995757 | -83.98967069 | 2021-12-29 03:21:43 | Union, Georgia, US | |
1432913 | 1432913 | 2021-12-28 | US | Alabama | Barbour | 1005 | 3750 | 81 | 0 | 31.868263 | -85.3871286 | 2021-12-29 03:21:43 | Barbour, Alabama, US | |
2114378 | 2114378 | 2021-12-26 | US | Pennsylvania | Juniata | 42067 | 3750 | 143 | 0 | 40.53358749 | -77.39975129999998 | 2021-12-27 04:21:58 | Juniata, Pennsylvania, US | |
3831759 | 3831759 | 2021-12-21 | US | Vermont | Orleans | 50019 | 3750 | 28 | 0 | 44.82964024 | -72.24562697 | 2021-12-22 04:21:54 | Orleans, Vermont, US | |
3830739 | 3830739 | 2021-12-21 | US | New York | Seneca | 36099 | 3750 | 74 | 0 | 42.78081007 | -76.82497064 | 2021-12-22 04:21:54 | Seneca, New York, US | |
3829361 | 3829361 | 2021-12-21 | US | Georgia | Unassigned | 90013 | 3750 | 6 | 0 | 34.91369188 | 0.0 | 2021-12-22 04:21:54 | Unassigned, Georgia, US | |
404797 | 404797 | 2021-12-07 | US | Arkansas | Logan | 5083 | 3750 | 52 | 0 | 35.21413234 | -93.71951016 | 2021-12-08 04:22:46 | Logan, Arkansas, US | |
1744 | 1744 | 2021-12-02 | US | Kentucky | Hart | 21099 | 3750 | 72 | 0 | 37.29943898 | -85.88461055 | 2021-12-03 04:23:05 | Hart, Kentucky, US | |
189 | 189 | 2021-12-02 | Denmark | Faroe Islands | 3750 | 13 | 0 | 61.8926 | -6.9118 | 2021-12-03 04:23:05 | Faroe Islands, Denmark | |||
45578 | 45578 | 2021-11-02 | US | Missouri | Audrain | 29007 | 3750 | 64 | 0 | 39.215877 | -91.84242683 | 2021-11-03 06:22:09 | Audrain, Missouri, US | |
2721474 | 2721474 | 2021-10-30 | US | Arkansas | Cleburne | 5023 | 3750 | 92 | 0 | 35.53864922 | -92.02640019 | 2021-10-31 04:22:08 | Cleburne, Arkansas, US | |
1910577 | 1910577 | 2021-10-17 | US | Kentucky | Allen | 21003 | 3750 | 63 | 0 | 36.75197631 | -86.19457544 | 2021-10-18 04:21:10 | Allen, Kentucky, US | |
1910028 | 1910028 | 2021-10-17 | US | Georgia | Haralson | 13143 | 3750 | 111 | 0 | 33.79602175 | -85.21005667 | 2021-10-18 04:21:10 | Haralson, Georgia, US | |
935617 | 935617 | 2021-10-16 | US | Georgia | Haralson | 13143 | 3750 | 111 | 0 | 33.79602175 | -85.21005667 | 2021-10-17 04:21:29 | Haralson, Georgia, US | |
2944786 | 2944786 | 2021-10-15 | US | Kentucky | Letcher | 21133 | 3750 | 65 | 0 | 37.12306748 | -82.85346474 | 2021-10-16 04:21:15 | Letcher, Kentucky, US | |
2944172 | 2944172 | 2021-10-15 | US | Georgia | Haralson | 13143 | 3750 | 111 | 0 | 33.79602175 | -85.21005667 | 2021-10-16 04:21:15 | Haralson, Georgia, US | |
3007011 | 3007011 | 2021-10-11 | Antigua and Barbuda | 3750 | 93 | 0 | 17.0608 | -61.7964 | 2021-10-12 04:21:09 | Antigua and Barbuda | ||||
423027 | 423027 | 2021-10-10 | Antigua and Barbuda | 3750 | 93 | 0 | 17.0608 | -61.7964 | 2021-10-11 04:21:31 | Antigua and Barbuda | ||||
988720 | 988720 | 2021-10-04 | US | Minnesota | Mille Lacs | 27095 | 3750 | 63 | 0 | 45.93705297 | -93.63236823 | 2021-10-05 04:21:27 | Mille Lacs, Minnesota, US | |
2776129 | 2776129 | 2021-09-30 | US | Texas | Lampasas | 48281 | 3750 | 58 | 0 | 31.19531316 | -98.24206613 | 2021-10-01 04:21:35 | Lampasas, Texas, US | |
3760544 | 3760544 | 2021-09-21 | US | Texas | Dimmit | 48127 | 3750 | 41 | 0 | 28.42270064 | -99.75645095 | 2021-09-22 04:21:45 | Dimmit, Texas, US | |
812647 | 812647 | 2021-09-20 | US | Texas | Dimmit | 48127 | 3750 | 41 | 0 | 28.42270064 | -99.75645095 | 2021-09-21 04:21:26 | Dimmit, Texas, US | |
1817475 | 1817475 | 2021-09-19 | US | Pennsylvania | Tioga | 42117 | 3750 | 115 | 0 | 41.77255149 | -77.25433032 | 2021-09-20 04:21:22 | Tioga, Pennsylvania, US | |
644216 | 644216 | 2021-09-07 | US | New York | Wyoming | 36121 | 3750 | 54 | 0 | 42.70145109 | -78.22199579 | 2021-09-08 04:21:31 | Wyoming, New York, US | |
643731 | 643731 | 2021-09-07 | US | Mississippi | Coahoma | 28027 | 3750 | 93 | 0 | 34.22772299 | -90.60415045 | 2021-09-08 04:21:31 | Coahoma, Mississippi, US | |
2521295 | 2521295 | 2021-08-18 | US | Texas | Hopkins | 48223 | 3750 | 120 | 0 | 33.14875072 | -95.56351139 | 2021-08-19 04:21:15 | Hopkins, Texas, US | |
2520023 | 2520023 | 2021-08-18 | US | Mississippi | Sunflower | 28133 | 3750 | 97 | 0 | 33.60192578 | -90.58882684 | 2021-08-19 04:21:15 | Sunflower, Mississippi, US | |
104775 | 104775 | 2021-08-15 | US | Kentucky | Muhlenberg | 21177 | 3750 | 71 | 0 | 37.21425819 | -87.14632053 | 2021-08-16 04:21:31 | Muhlenberg, Kentucky, US | |
1342818 | 1342818 | 2021-08-11 | US | Arkansas | Unassigned | 90005 | 3750 | 0 | 0 | 36.38177105 | 0.0 | 2021-08-12 04:21:25 | Unassigned, Arkansas, US | |
653009 | 653009 | 2021-08-09 | US | Texas | Cherokee | 48073 | 3750 | 149 | 0 | 31.837258000000002 | -95.16559897 | 2021-08-10 04:21:27 | Cherokee, Texas, US | |
651337 | 651337 | 2021-08-09 | US | Kentucky | Boyle | 21021 | 3750 | 80 | 0 | 37.62680923 | -84.8633779 | 2021-08-10 04:21:27 | Boyle, Kentucky, US | |
592671 | 592671 | 2021-08-08 | US | Texas | Cherokee | 48073 | 3750 | 149 | 0 | 31.837258 | -95.16559897 | 2021-08-09 04:21:24 | Cherokee, Texas, US | |
592437 | 592437 | 2021-08-08 | US | South Carolina | Clarendon | 45027 | 3750 | 114 | 0 | 33.66610974 | -80.21647898 | 2021-08-09 04:21:24 | Clarendon, South Carolina, US | |
2206683 | 2206683 | 2021-08-07 | US | Texas | Cherokee | 48073 | 3750 | 149 | 0 | 31.837258 | -95.16559897 | 2021-08-08 04:21:33 | Cherokee, Texas, US | |
2206449 | 2206449 | 2021-08-07 | US | South Carolina | Clarendon | 45027 | 3750 | 114 | 0 | 33.66610974 | -80.21647898 | 2021-08-08 04:21:33 | Clarendon, South Carolina, US | |
1120633 | 1120633 | 2021-08-06 | US | Texas | Cherokee | 48073 | 3750 | 149 | 0 | 31.837258 | -95.16559897 | 2021-08-07 04:21:30 | Cherokee, Texas, US | |
1120399 | 1120399 | 2021-08-06 | US | South Carolina | Clarendon | 45027 | 3750 | 114 | 0 | 33.66610974 | -80.21647898 | 2021-08-07 04:21:30 | Clarendon, South Carolina, US | |
1957382 | 1957382 | 2021-08-05 | US | Georgia | Pickens | 13227 | 3750 | 79 | 0 | 34.46589159 | -84.46406611 | 2021-08-06 04:21:18 | Pickens, Georgia, US | |
3686396 | 3686396 | 2021-08-02 | US | Tennessee | Hardin | 47071 | 3750 | 68 | 0 | 35.19732531 | -88.18593755 | 2021-08-03 04:21:39 | Hardin, Tennessee, US | |
3140469 | 3140469 | 2021-07-23 | US | Tennessee | Carroll | 47017 | 3750 | 81 | 0 | 35.97366108 | -88.45189331 | 2021-07-24 00:21:36 | Carroll, Tennessee, US | |
2694815 | 2694815 | 2021-07-06 | US | Indiana | Putnam | 18133 | 3750 | 62 | 0 | 39.66437981 | -86.84517605 | 2021-07-07 04:21:20 | Putnam, Indiana, US | |
84370 | 84370 | 2021-05-25 | US | Kansas | Ellis | 20051 | 3750 | 72 | 0 | 38.91458712 | -99.31751551 | 2021-05-26 04:20:35 | Ellis, Kansas, US | |
1414332 | 1414332 | 2021-05-24 | US | Kansas | Ellis | 20051 | 3750 | 72 | 0 | 38.91458712 | -99.31751551 | 2021-05-25 04:21:08 | Ellis, Kansas, US | |
1413707 | 1413707 | 2021-05-24 | US | Colorado | Summit | 8117 | 3750 | 8 | 0 | 39.63803232 | -106.1150762 | 2021-05-25 04:21:08 | Summit, Colorado, US | |
1772618 | 1772618 | 2021-05-23 | US | Kansas | Ellis | 20051 | 3750 | 72 | 0 | 38.91458712 | -99.31751551 | 2021-05-24 04:20:53 | Ellis, Kansas, US | |
1771993 | 1771993 | 2021-05-23 | US | Colorado | Summit | 8117 | 3750 | 8 | 0 | 39.63803232 | -106.1150762 | 2021-05-24 04:20:53 | Summit, Colorado, US | |
727773 | 727773 | 2021-05-22 | US | Kansas | Ellis | 20051 | 3750 | 72 | 0 | 38.91458712 | -99.31751551 | 2021-05-23 04:20:51 | Ellis, Kansas, US | |
1953788 | 1953788 | 2021-05-21 | US | Kansas | Ellis | 20051 | 3750 | 72 | 0 | 38.91458712 | -99.31751551 | 2021-05-22 04:20:45 | Ellis, Kansas, US | |
2258178 | 2258178 | 2021-05-19 | US | Ohio | Clinton | 39027 | 3750 | 64 | 0 | 39.41485808 | -83.80852286 | 2021-05-20 04:21:05 | Clinton, Ohio, 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]);