johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
153 rows where confirmed = 4879 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1629790 | 1629790 | 2022-12-18 | US | Kentucky | Washington | 21229 | 4879 | 68 | 0 | 37.75599461 | -85.17407732 | 2022-12-19 04:21:03 | Washington, Kentucky, US | |
505169 | 505169 | 2022-12-17 | US | Kentucky | Washington | 21229 | 4879 | 68 | 0 | 37.75599461 | -85.17407732 | 2022-12-18 04:21:03 | Washington, Kentucky, US | |
3325741 | 3325741 | 2022-12-16 | US | Kentucky | Washington | 21229 | 4879 | 68 | 0 | 37.75599461 | -85.17407732 | 2022-12-17 04:21:04 | Washington, Kentucky, US | |
544253 | 544253 | 2022-12-15 | US | Kentucky | Washington | 21229 | 4879 | 68 | 0 | 37.75599461 | -85.17407732 | 2022-12-16 04:21:01 | Washington, Kentucky, US | |
349781 | 349781 | 2022-12-14 | US | Kentucky | Washington | 21229 | 4879 | 68 | 0 | 37.75599461 | -85.17407732 | 2022-12-15 04:20:58 | Washington, Kentucky, US | |
309369 | 309369 | 2022-12-13 | US | Kentucky | Washington | 21229 | 4879 | 68 | 0 | 37.75599461 | -85.17407732 | 2022-12-14 04:21:04 | Washington, Kentucky, US | |
308945 | 308945 | 2022-12-13 | US | Illinois | Warren | 17187 | 4879 | 87 | 0 | 40.84925021 | -90.6147432 | 2022-12-14 04:21:04 | Warren, Illinois, US | |
1150430 | 1150430 | 2022-12-12 | US | Kentucky | Washington | 21229 | 4879 | 68 | 0 | 37.75599461 | -85.17407732 | 2022-12-13 04:21:01 | Washington, Kentucky, US | |
872277 | 872277 | 2022-12-11 | US | West Virginia | Braxton | 54007 | 4879 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-12 04:21:01 | Braxton, West Virginia, US | |
260807 | 260807 | 2022-12-10 | US | West Virginia | Braxton | 54007 | 4879 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-11 04:20:50 | Braxton, West Virginia, US | |
3939521 | 3939521 | 2022-12-09 | US | West Virginia | Braxton | 54007 | 4879 | 52 | 0 | 38.70036159 | -80.72011184 | 2022-12-10 04:21:02 | Braxton, West Virginia, US | |
315437 | 315437 | 2022-11-13 | US | Wisconsin | Burnett | 55013 | 4879 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-11-14 04:21:09 | Burnett, Wisconsin, US | |
66598 | 66598 | 2022-11-12 | US | Wisconsin | Burnett | 55013 | 4879 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-11-13 04:21:14 | Burnett, Wisconsin, US | |
2930760 | 2930760 | 2022-11-11 | US | Wisconsin | Burnett | 55013 | 4879 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-11-12 04:20:41 | Burnett, Wisconsin, US | |
713446 | 713446 | 2022-11-01 | US | Tennessee | Sequatchie | 47153 | 4879 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-11-02 04:22:09 | Sequatchie, Tennessee, US | |
3287895 | 3287895 | 2022-10-31 | US | Tennessee | Sequatchie | 47153 | 4879 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-11-01 04:22:36 | Sequatchie, Tennessee, US | |
1626311 | 1626311 | 2022-09-22 | US | Montana | Park | 30067 | 4879 | 36 | 0 | 45.48965095 | -110.5264394 | 2022-09-23 04:23:13 | Park, Montana, US | |
1372515 | 1372515 | 2022-09-21 | US | Montana | Park | 30067 | 4879 | 36 | 0 | 45.48965095 | -110.5264394 | 2022-09-22 04:22:56 | Park, Montana, US | |
2018745 | 2018745 | 2022-09-20 | US | Montana | Park | 30067 | 4879 | 36 | 0 | 45.48965095 | -110.5264394 | 2022-09-21 04:23:22 | Park, Montana, US | |
3572618 | 3572618 | 2022-09-19 | US | Montana | Park | 30067 | 4879 | 36 | 0 | 45.48965095 | -110.5264394 | 2022-09-20 04:22:48 | Park, Montana, US | |
421357 | 421357 | 2022-09-18 | US | Montana | Park | 30067 | 4879 | 36 | 0 | 45.48965095 | -110.5264394 | 2022-09-19 04:21:49 | Park, Montana, US | |
3375381 | 3375381 | 2022-09-17 | US | Montana | Park | 30067 | 4879 | 36 | 0 | 45.48965095 | -110.5264394 | 2022-09-18 04:22:50 | Park, Montana, US | |
2357489 | 2357489 | 2022-09-16 | US | Montana | Park | 30067 | 4879 | 36 | 0 | 45.48965095 | -110.5264394 | 2022-09-17 04:20:19 | Park, Montana, US | |
115732 | 115732 | 2022-09-06 | US | Illinois | De Witt | 17039 | 4879 | 40 | 0 | 40.17514519 | -88.90959682 | 2022-09-07 04:20:59 | De Witt, Illinois, US | |
2634688 | 2634688 | 2022-09-05 | US | Illinois | Bond | 17005 | 4879 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-09-06 04:21:02 | Bond, Illinois, US | |
2988252 | 2988252 | 2022-09-04 | US | Illinois | Bond | 17005 | 4879 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-09-05 04:21:01 | Bond, Illinois, US | |
2713937 | 2713937 | 2022-09-03 | US | Illinois | Bond | 17005 | 4879 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-09-04 04:21:22 | Bond, Illinois, US | |
1394642 | 1394642 | 2022-09-02 | US | Illinois | Bond | 17005 | 4879 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-09-03 04:21:04 | Bond, Illinois, US | |
1532418 | 1532418 | 2022-08-26 | US | Arkansas | Grant | 5053 | 4879 | 61 | 0 | 34.29017991 | -92.42320562 | 2022-08-27 04:20:57 | Grant, Arkansas, US | |
1405588 | 1405588 | 2022-08-02 | US | California | Colusa | 6011 | 4879 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-08-03 04:20:59 | Colusa, California, US | |
3874994 | 3874994 | 2022-07-31 | US | Washington | Asotin | 53003 | 4879 | 71 | 0 | 46.18894415 | -117.2022851 | 2022-08-01 04:21:03 | Asotin, Washington, US | |
677748 | 677748 | 2022-07-30 | US | Washington | Asotin | 53003 | 4879 | 71 | 0 | 46.18894415 | -117.2022851 | 2022-07-31 04:21:02 | Asotin, Washington, US | |
1786947 | 1786947 | 2022-07-29 | US | Washington | Asotin | 53003 | 4879 | 71 | 0 | 46.18894415 | -117.2022851 | 2022-07-30 04:20:42 | Asotin, Washington, US | |
1069310 | 1069310 | 2022-07-28 | US | Washington | Asotin | 53003 | 4879 | 71 | 0 | 46.18894415 | -117.2022851 | 2022-07-29 04:20:45 | Asotin, Washington, US | |
2338829 | 2338829 | 2022-07-27 | US | Washington | Asotin | 53003 | 4879 | 71 | 0 | 46.18894415 | -117.2022851 | 2022-07-28 04:20:56 | Asotin, Washington, US | |
2338707 | 2338707 | 2022-07-27 | US | Virginia | Bristol | 51520 | 4879 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-07-28 04:20:56 | Bristol, Virginia, US | |
3405942 | 3405942 | 2022-07-17 | US | Arkansas | Drew | 5043 | 4879 | 71 | 0 | 33.59035001 | -91.71777921 | 2022-07-18 04:20:59 | Drew, Arkansas, US | |
3581345 | 3581345 | 2022-06-02 | US | Puerto Rico | Aibonito | 72009 | 4879 | 0 | 0 | 18.131361 | -66.264131 | 2022-06-03 04:20:58 | Aibonito, Puerto Rico, US | |
973650 | 973650 | 2022-06-01 | US | Puerto Rico | Catano | 72033 | 4879 | 0 | 0 | 18.437269 | -66.143306 | 2022-06-02 05:20:39 | Catano, Puerto Rico, US | |
973498 | 973498 | 2022-06-01 | US | Oklahoma | McIntosh | 40091 | 4879 | 125 | 0 | 35.37235506 | -95.66599306 | 2022-06-02 05:20:39 | McIntosh, Oklahoma, US | |
231805 | 231805 | 2022-05-31 | US | Oklahoma | McIntosh | 40091 | 4879 | 125 | 0 | 35.37235506 | -95.66599306 | 2022-06-01 04:20:55 | McIntosh, Oklahoma, US | |
3188570 | 3188570 | 2022-05-30 | US | Oklahoma | McIntosh | 40091 | 4879 | 125 | 0 | 35.37235506 | -95.66599306 | 2022-05-31 04:20:51 | McIntosh, Oklahoma, US | |
3200719 | 3200719 | 2022-05-29 | US | Oklahoma | McIntosh | 40091 | 4879 | 125 | 0 | 35.37235506 | -95.66599306 | 2022-05-30 04:20:50 | McIntosh, Oklahoma, US | |
2727597 | 2727597 | 2022-05-28 | US | Oklahoma | McIntosh | 40091 | 4879 | 125 | 0 | 35.37235506 | -95.66599306 | 2022-05-29 04:20:53 | McIntosh, Oklahoma, US | |
1316778 | 1316778 | 2022-05-27 | US | Oklahoma | McIntosh | 40091 | 4879 | 125 | 0 | 35.37235506 | -95.66599306 | 2022-05-28 04:21:07 | McIntosh, Oklahoma, US | |
1852570 | 1852570 | 2022-05-26 | US | Oklahoma | McIntosh | 40091 | 4879 | 125 | 0 | 35.37235506 | -95.66599306 | 2022-05-27 04:20:56 | McIntosh, Oklahoma, US | |
1851095 | 1851095 | 2022-05-26 | US | Indiana | Jay | 18075 | 4879 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-05-27 04:20:56 | Jay, Indiana, US | |
2048971 | 2048971 | 2022-05-25 | US | Indiana | Jay | 18075 | 4879 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-05-26 04:20:50 | Jay, Indiana, US | |
3000199 | 3000199 | 2022-05-24 | US | Georgia | Union | 13291 | 4879 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-05-25 04:20:56 | Union, Georgia, US | |
3593920 | 3593920 | 2022-05-23 | US | Georgia | Union | 13291 | 4879 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-05-24 04:20:57 | Union, Georgia, US | |
622982 | 622982 | 2022-05-22 | US | Indiana | Jay | 18075 | 4879 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-05-26 04:20:50 | Jay, Indiana, US | |
1110468 | 1110468 | 2022-05-21 | US | Georgia | Union | 13291 | 4879 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-05-22 04:20:52 | Union, Georgia, US | |
1170092 | 1170092 | 2022-05-20 | US | Georgia | Union | 13291 | 4879 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-05-21 04:20:58 | Union, Georgia, US | |
3896855 | 3896855 | 2022-05-19 | US | Georgia | Union | 13291 | 4879 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-05-20 04:20:57 | Union, Georgia, US | |
1185639 | 1185639 | 2022-05-18 | US | Georgia | Union | 13291 | 4879 | 159 | 0 | 34.82995757 | -83.98967069 | 2022-05-19 04:20:54 | Union, Georgia, US | |
3583250 | 3583250 | 2022-05-17 | US | Colorado | Chaffee | 8015 | 4879 | 48 | 0 | 38.74745778 | -106.1926573 | 2022-05-18 04:20:50 | Chaffee, Colorado, US | |
1503751 | 1503751 | 2022-05-16 | Palau | 4879 | 6 | 0 | 7.515 | 134.5825 | 2022-05-17 04:20:59 | Palau | ||||
2084110 | 2084110 | 2022-05-15 | Palau | 4879 | 6 | 0 | 7.515 | 134.5825 | 2022-05-16 04:20:47 | Palau | ||||
3354820 | 3354820 | 2022-05-14 | Palau | 4879 | 6 | 0 | 7.515 | 134.5825 | 2022-05-15 04:20:53 | Palau | ||||
658465 | 658465 | 2022-05-13 | Palau | 4879 | 6 | 0 | 7.515 | 134.5825 | 2022-05-14 04:20:48 | Palau | ||||
3448430 | 3448430 | 2022-05-11 | US | Wisconsin | Taylor | 55119 | 4879 | 72 | 0 | 45.21179252 | -90.5004405 | 2022-05-12 04:20:54 | Taylor, Wisconsin, US | |
2599767 | 2599767 | 2022-05-05 | US | Minnesota | Fillmore | 27045 | 4879 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-05-06 04:21:00 | Fillmore, Minnesota, US | |
2032081 | 2032081 | 2022-04-24 | US | Virginia | Buchanan | 51027 | 4879 | 119 | 0 | 37.26818323 | -82.03749726 | 2022-04-25 04:20:56 | Buchanan, Virginia, US | |
749656 | 749656 | 2022-04-23 | US | Virginia | Buchanan | 51027 | 4879 | 119 | 0 | 37.26818323 | -82.03749726 | 2022-04-24 04:20:56 | Buchanan, Virginia, US | |
3440141 | 3440141 | 2022-04-22 | US | Virginia | Buchanan | 51027 | 4879 | 119 | 0 | 37.26818323 | -82.03749726 | 2022-04-23 04:20:50 | Buchanan, Virginia, US | |
2895726 | 2895726 | 2022-04-21 | US | Virginia | Buchanan | 51027 | 4879 | 118 | 0 | 37.26818323 | -82.03749726 | 2022-04-22 04:20:45 | Buchanan, Virginia, US | |
2310598 | 2310598 | 2022-04-20 | US | Virginia | Buchanan | 51027 | 4879 | 118 | 0 | 37.26818323 | -82.03749726 | 2022-04-21 04:20:46 | Buchanan, Virginia, US | |
1579441 | 1579441 | 2022-04-10 | US | Vermont | Orange | 50017 | 4879 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-04-11 04:21:02 | Orange, Vermont, US | |
1655683 | 1655683 | 2022-04-09 | US | Vermont | Orange | 50017 | 4879 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-04-10 04:20:52 | Orange, Vermont, US | |
2119005 | 2119005 | 2022-04-08 | US | Vermont | Orange | 50017 | 4879 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-04-09 04:20:42 | Orange, Vermont, US | |
2803523 | 2803523 | 2022-04-06 | US | Puerto Rico | Hatillo | 72065 | 4879 | 0 | 0 | 18.410928 | -66.79632600000001 | 2022-04-07 04:20:53 | Hatillo, Puerto Rico, US | |
3868329 | 3868329 | 2022-04-05 | US | Georgia | Cook | 13075 | 4879 | 73 | 0 | 31.16068491 | -83.42947229 | 2022-04-06 04:20:49 | Cook, Georgia, US | |
2749671 | 2749671 | 2022-04-04 | US | Georgia | Cook | 13075 | 4879 | 73 | 0 | 31.16068491 | -83.42947229 | 2022-04-05 04:20:48 | Cook, Georgia, US | |
3731017 | 3731017 | 2022-04-03 | US | Georgia | Cook | 13075 | 4879 | 72 | 0 | 31.16068491 | -83.42947229 | 2022-04-04 04:20:51 | Cook, Georgia, US | |
500452 | 500452 | 2022-04-02 | US | Georgia | Cook | 13075 | 4879 | 72 | 0 | 31.16068491 | -83.42947229 | 2022-04-03 04:20:48 | Cook, Georgia, US | |
3351437 | 3351437 | 2022-04-01 | US | Georgia | Cook | 13075 | 4879 | 72 | 0 | 31.16068491 | -83.42947229 | 2022-04-02 04:20:47 | Cook, Georgia, US | |
1867102 | 1867102 | 2022-03-10 | US | Michigan | Charlevoix | 26029 | 4879 | 59 | 0 | 45.37790017 | -85.19614053 | 2022-03-11 04:20:50 | Charlevoix, Michigan, US | |
2142751 | 2142751 | 2022-03-09 | US | Oklahoma | McIntosh | 40091 | 4879 | 118 | 0 | 35.37235506 | -95.66599306 | 2022-03-10 04:20:48 | McIntosh, Oklahoma, US | |
2141797 | 2141797 | 2022-03-09 | US | Michigan | Charlevoix | 26029 | 4879 | 59 | 0 | 45.37790017 | -85.19614053 | 2022-03-10 04:20:48 | Charlevoix, Michigan, US | |
922262 | 922262 | 2022-03-08 | US | Oklahoma | McIntosh | 40091 | 4879 | 118 | 0 | 35.37235506 | -95.66599306 | 2022-03-09 04:20:59 | McIntosh, Oklahoma, US | |
920616 | 920616 | 2022-03-08 | US | Idaho | Cassia | 16031 | 4879 | 52 | 0 | 42.28347888 | -113.6012409 | 2022-03-09 04:20:59 | Cassia, Idaho, US | |
1550549 | 1550549 | 2022-03-07 | US | Oklahoma | McIntosh | 40091 | 4879 | 118 | 0 | 35.37235506 | -95.66599306 | 2022-03-08 04:20:54 | McIntosh, Oklahoma, US | |
2202218 | 2202218 | 2022-03-06 | US | Oklahoma | McIntosh | 40091 | 4879 | 118 | 0 | 35.37235506 | -95.66599306 | 2022-03-07 04:20:47 | McIntosh, Oklahoma, US | |
2094675 | 2094675 | 2022-03-05 | US | Oklahoma | McIntosh | 40091 | 4879 | 118 | 0 | 35.37235506 | -95.66599306 | 2022-03-06 04:20:49 | McIntosh, Oklahoma, US | |
2668375 | 2668375 | 2022-03-04 | US | Oklahoma | McIntosh | 40091 | 4879 | 118 | 0 | 35.37235506 | -95.66599306 | 2022-03-05 04:21:10 | McIntosh, Oklahoma, US | |
1646940 | 1646940 | 2022-03-03 | US | Oklahoma | McIntosh | 40091 | 4879 | 118 | 0 | 35.37235506 | -95.66599306 | 2022-03-04 04:21:09 | McIntosh, Oklahoma, US | |
2527943 | 2527943 | 2022-03-02 | US | Oklahoma | McIntosh | 40091 | 4879 | 118 | 0 | 35.37235506 | -95.66599306 | 2022-03-03 04:21:01 | McIntosh, Oklahoma, US | |
1061188 | 1061188 | 2022-02-23 | US | Virginia | Fluvanna | 51065 | 4879 | 39 | 0 | 37.84157909 | -78.27715475 | 2022-02-24 04:21:14 | Fluvanna, Virginia, US | |
73068 | 73068 | 2022-02-07 | US | Missouri | Vernon | 29217 | 4879 | 95 | 0 | 37.8457799 | -94.34127305 | 2022-02-08 04:21:15 | Vernon, Missouri, US | |
2658638 | 2658638 | 2022-01-31 | US | Georgia | Mitchell | 13205 | 4879 | 104 | 0 | 31.22483255 | -84.19381821 | 2022-02-01 04:21:11 | Mitchell, Georgia, US | |
2055306 | 2055306 | 2022-01-25 | US | Virginia | Waynesboro | 51820 | 4879 | 55 | 0 | 38.06451466 | -78.90293905 | 2022-01-26 04:21:07 | Waynesboro, Virginia, US | |
2053256 | 2053256 | 2022-01-25 | US | Kentucky | Bourbon | 21017 | 4879 | 45 | 0 | 38.2054607 | -84.21827874 | 2022-01-26 04:21:07 | Bourbon, Kentucky, US | |
3615977 | 3615977 | 2022-01-12 | US | South Dakota | Yankton | 46135 | 4879 | 46 | 0 | 43.00924485 | -97.39467635 | 2022-01-13 08:00:09 | Yankton, South Dakota, US | |
1283789 | 1283789 | 2022-01-05 | US | Mississippi | Covington | 28031 | 4879 | 97 | 0 | 31.63225413 | -89.55389939 | 2022-01-06 04:22:09 | Covington, Mississippi, US | |
1702391 | 1702391 | 2022-01-03 | US | Nebraska | Adams | 31001 | 4879 | 46 | 0 | 40.52449420000001 | -98.50117804 | 2022-01-04 04:22:17 | Adams, Nebraska, US | |
3522375 | 3522375 | 2022-01-02 | US | Tennessee | Grainger | 47057 | 4879 | 91 | 0 | 36.27469206 | -83.51254721 | 2022-01-03 02:22:25 | Grainger, Tennessee, US | |
3999148 | 3999148 | 2021-12-30 | US | Arkansas | Johnson | 5071 | 4879 | 63 | 0 | 35.56759135 | -93.46036368 | 2021-12-31 04:21:50 | Johnson, Arkansas, US | |
1254790 | 1254790 | 2021-12-20 | Japan | Port Quarantine | 4879 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2088781 | 2088781 | 2021-12-14 | US | Georgia | Gilmer | 13123 | 4879 | 139 | 0 | 34.69316688 | -84.45802506 | 2021-12-15 03:22:16 | Gilmer, Georgia, US | |
3174 | 3174 | 2021-12-02 | US | South Carolina | Union | 45087 | 4879 | 112 | 0 | 34.68835752 | -81.61730349 | 2021-12-03 04:23:05 | Union, South Carolina, 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]);