johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
135 rows where confirmed = 5970 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308732 | 308732 | 2022-12-13 | US | Georgia | McDuffie | 13189 | 5970 | 110 | 0 | 33.47851918 | -82.48252774 | 2022-12-14 04:21:04 | McDuffie, Georgia, US | |
1149793 | 1149793 | 2022-12-12 | US | Georgia | McDuffie | 13189 | 5970 | 110 | 0 | 33.47851918 | -82.48252774 | 2022-12-13 04:21:01 | McDuffie, Georgia, US | |
869647 | 869647 | 2022-12-11 | US | Georgia | McDuffie | 13189 | 5970 | 110 | 0 | 33.47851918 | -82.48252774 | 2022-12-12 04:21:01 | McDuffie, Georgia, US | |
258177 | 258177 | 2022-12-10 | US | Georgia | McDuffie | 13189 | 5970 | 110 | 0 | 33.47851918 | -82.48252774 | 2022-12-11 04:20:50 | McDuffie, Georgia, US | |
3936891 | 3936891 | 2022-12-09 | US | Georgia | McDuffie | 13189 | 5970 | 110 | 0 | 33.47851918 | -82.48252774 | 2022-12-10 04:21:02 | McDuffie, Georgia, US | |
3378223 | 3378223 | 2022-12-08 | US | Georgia | McDuffie | 13189 | 5970 | 110 | 0 | 33.47851918 | -82.48252774 | 2022-12-09 04:21:05 | McDuffie, Georgia, US | |
2017575 | 2017575 | 2022-09-20 | US | Georgia | Mitchell | 13205 | 5970 | 123 | 0 | 31.22483255 | -84.19381821 | 2022-09-21 04:23:22 | Mitchell, Georgia, US | |
3571448 | 3571448 | 2022-09-19 | US | Georgia | Mitchell | 13205 | 5970 | 123 | 0 | 31.22483255 | -84.19381821 | 2022-09-20 04:22:48 | Mitchell, Georgia, US | |
420187 | 420187 | 2022-09-18 | US | Georgia | Mitchell | 13205 | 5970 | 123 | 0 | 31.22483255 | -84.19381821 | 2022-09-19 04:21:49 | Mitchell, Georgia, US | |
3374211 | 3374211 | 2022-09-17 | US | Georgia | Mitchell | 13205 | 5970 | 123 | 0 | 31.22483255 | -84.19381821 | 2022-09-18 04:22:50 | Mitchell, Georgia, US | |
2356319 | 2356319 | 2022-09-16 | US | Georgia | Mitchell | 13205 | 5970 | 123 | 0 | 31.22483255 | -84.19381821 | 2022-09-17 04:20:19 | Mitchell, Georgia, US | |
3987476 | 3987476 | 2022-09-15 | US | Georgia | Mitchell | 13205 | 5970 | 123 | 0 | 31.22483255 | -84.19381821 | 2022-09-16 04:21:19 | Mitchell, Georgia, US | |
1889993 | 1889993 | 2022-09-14 | US | Georgia | Mitchell | 13205 | 5970 | 123 | 0 | 31.22483255 | -84.19381821 | 2022-09-15 04:21:02 | Mitchell, Georgia, US | |
2343927 | 2343927 | 2022-08-31 | US | Arkansas | Lawrence | 5075 | 5970 | 84 | 0 | 36.04188196 | -91.10867198 | 2022-09-01 04:21:03 | Lawrence, Arkansas, US | |
3798110 | 3798110 | 2022-08-20 | Russia | Chukotka Autonomous Okrug | 5970 | 42 | 0 | 66.0006475 | 169.4900869 | 2022-08-21 04:20:44 | Chukotka Autonomous Okrug, Russia | |||
3953259 | 3953259 | 2022-08-17 | US | Puerto Rico | Naguabo | 72103 | 5970 | 0 | 0 | 18.230637 | -65.753897 | 2022-08-18 04:21:11 | Naguabo, Puerto Rico, US | |
1072624 | 1072624 | 2022-08-07 | US | Puerto Rico | Catano | 72033 | 5970 | 0 | 0 | 18.437269 | -66.143306 | 2022-08-08 04:21:08 | Catano, Puerto Rico, US | |
1406399 | 1406399 | 2022-08-02 | US | Kansas | Sumner | 20191 | 5970 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-08-03 04:20:59 | Sumner, Kansas, US | |
3618437 | 3618437 | 2022-08-01 | US | Kansas | Sumner | 20191 | 5970 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-08-02 04:20:53 | Sumner, Kansas, US | |
3872917 | 3872917 | 2022-07-31 | US | Kansas | Sumner | 20191 | 5970 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-08-01 04:21:03 | Sumner, Kansas, US | |
675671 | 675671 | 2022-07-30 | US | Kansas | Sumner | 20191 | 5970 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-07-31 04:21:02 | Sumner, Kansas, US | |
1784870 | 1784870 | 2022-07-29 | US | Kansas | Sumner | 20191 | 5970 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-07-30 04:20:42 | Sumner, Kansas, US | |
1067233 | 1067233 | 2022-07-28 | US | Kansas | Sumner | 20191 | 5970 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-07-29 04:20:45 | Sumner, Kansas, US | |
2338785 | 2338785 | 2022-07-27 | US | Virginia | Page | 51139 | 5970 | 123 | 0 | 38.61807452 | -78.48797204 | 2022-07-28 04:20:56 | Page, Virginia, US | |
2336752 | 2336752 | 2022-07-27 | US | Kansas | Sumner | 20191 | 5970 | 76 | 0 | 37.23682549 | -97.47721621 | 2022-07-28 04:20:56 | Sumner, Kansas, US | |
1488838 | 1488838 | 2022-07-26 | US | Iowa | Washington | 19183 | 5970 | 79 | 0 | 41.33577126 | -91.71725711 | 2022-07-27 04:21:04 | Washington, Iowa, US | |
2595284 | 2595284 | 2022-07-25 | US | Iowa | Washington | 19183 | 5970 | 79 | 0 | 41.33577126 | -91.71725711 | 2022-07-26 04:20:58 | Washington, Iowa, US | |
897399 | 897399 | 2022-07-24 | US | Iowa | Washington | 19183 | 5970 | 79 | 0 | 41.33577126 | -91.71725711 | 2022-07-25 04:20:51 | Washington, Iowa, US | |
92393 | 92393 | 2022-07-23 | US | Iowa | Washington | 19183 | 5970 | 79 | 0 | 41.33577126 | -91.71725711 | 2022-07-24 04:20:47 | Washington, Iowa, US | |
901415 | 901415 | 2022-07-22 | US | Iowa | Washington | 19183 | 5970 | 79 | 0 | 41.33577126 | -91.71725711 | 2022-07-23 04:20:53 | Washington, Iowa, US | |
671551 | 671551 | 2022-07-21 | US | Iowa | Washington | 19183 | 5970 | 79 | 0 | 41.33577126 | -91.71725711 | 2022-07-22 04:21:15 | Washington, Iowa, US | |
1609514 | 1609514 | 2022-07-20 | US | Iowa | Washington | 19183 | 5970 | 79 | 0 | 41.33577126 | -91.71725711 | 2022-07-21 04:21:10 | Washington, Iowa, US | |
2154376 | 2154376 | 2022-07-16 | US | Puerto Rico | Aibonito | 72009 | 5970 | 0 | 0 | 18.131361 | -66.264131 | 2022-07-17 04:21:15 | Aibonito, Puerto Rico, US | |
3112829 | 3112829 | 2022-07-13 | US | Virginia | Fredericksburg | 51630 | 5970 | 41 | 0 | 38.2977863 | -77.4922454 | 2022-07-14 04:20:57 | Fredericksburg, Virginia, US | |
1766347 | 1766347 | 2022-06-20 | US | Texas | Austin | 48015 | 5970 | 74 | 0 | 29.88548725 | -96.27736949 | 2022-06-21 04:20:56 | Austin, Texas, US | |
949714 | 949714 | 2022-06-14 | US | South Dakota | Davison | 46035 | 5970 | 80 | 0 | 43.67490933 | -98.14458906 | 2022-06-15 04:20:54 | Davison, South Dakota, US | |
2982122 | 2982122 | 2022-06-13 | US | South Dakota | Davison | 46035 | 5970 | 80 | 0 | 43.67490933 | -98.14458906 | 2022-06-14 04:20:52 | Davison, South Dakota, US | |
2238248 | 2238248 | 2022-06-12 | US | South Dakota | Davison | 46035 | 5970 | 80 | 0 | 43.67490933 | -98.14458906 | 2022-06-13 04:21:14 | Davison, South Dakota, US | |
3144446 | 3144446 | 2022-06-11 | US | South Dakota | Davison | 46035 | 5970 | 80 | 0 | 43.67490933 | -98.14458906 | 2022-06-12 04:20:53 | Davison, South Dakota, US | |
1947362 | 1947362 | 2022-06-10 | US | South Dakota | Davison | 46035 | 5970 | 80 | 0 | 43.67490933 | -98.14458906 | 2022-06-11 04:21:01 | Davison, South Dakota, US | |
3160501 | 3160501 | 2022-06-09 | US | South Dakota | Davison | 46035 | 5970 | 80 | 0 | 43.67490933 | -98.14458906 | 2022-06-10 04:20:55 | Davison, South Dakota, US | |
1423968 | 1423968 | 2022-06-08 | US | South Dakota | Davison | 46035 | 5970 | 80 | 0 | 43.67490933 | -98.14458906 | 2022-06-09 04:20:54 | Davison, South Dakota, US | |
2727812 | 2727812 | 2022-05-28 | US | Puerto Rico | Yauco | 72153 | 5970 | 0 | 0 | 18.080374 | -66.858814 | 2022-05-29 04:20:53 | Yauco, Puerto Rico, US | |
2084234 | 2084234 | 2022-05-15 | Sao Tome and Principe | 5970 | 73 | 0 | 0.1864 | 6.6131 | 2022-05-16 04:20:47 | Sao Tome and Principe | ||||
3354944 | 3354944 | 2022-05-14 | Sao Tome and Principe | 5970 | 73 | 0 | 0.1864 | 6.6131 | 2022-05-15 04:20:53 | Sao Tome and Principe | ||||
658589 | 658589 | 2022-05-13 | Sao Tome and Principe | 5970 | 73 | 0 | 0.1864 | 6.6131 | 2022-05-14 04:20:48 | Sao Tome and Principe | ||||
2533672 | 2533672 | 2022-05-12 | Sao Tome and Principe | 5970 | 73 | 0 | 0.1864 | 6.6131 | 2022-05-13 04:20:51 | Sao Tome and Principe | ||||
3445118 | 3445118 | 2022-05-11 | Sao Tome and Principe | 5970 | 73 | 0 | 0.1864 | 6.6131 | 2022-05-12 04:20:54 | Sao Tome and Principe | ||||
3535735 | 3535735 | 2022-05-10 | Sao Tome and Principe | 5970 | 73 | 0 | 0.1864 | 6.6131 | 2022-05-11 04:20:48 | Sao Tome and Principe | ||||
222270 | 222270 | 2022-05-09 | Sao Tome and Principe | 5970 | 73 | 0 | 0.1864 | 6.6131 | 2022-05-10 04:20:50 | Sao Tome and Principe | ||||
1848795 | 1848795 | 2022-04-18 | US | South Carolina | Fairfield | 45039 | 5970 | 107 | 0 | 34.39287073 | -81.1195624 | 2022-04-19 04:21:00 | Fairfield, South Carolina, US | |
3419739 | 3419739 | 2022-04-17 | US | South Carolina | Fairfield | 45039 | 5970 | 107 | 0 | 34.39287073 | -81.1195624 | 2022-04-18 04:21:12 | Fairfield, South Carolina, US | |
306688 | 306688 | 2022-04-16 | US | South Carolina | Fairfield | 45039 | 5970 | 107 | 0 | 34.39287073 | -81.1195624 | 2022-04-17 04:20:59 | Fairfield, South Carolina, US | |
2672633 | 2672633 | 2022-04-15 | US | South Carolina | Fairfield | 45039 | 5970 | 107 | 0 | 34.39287073 | -81.1195624 | 2022-04-16 04:20:48 | Fairfield, South Carolina, US | |
1226418 | 1226418 | 2022-04-14 | US | South Carolina | Fairfield | 45039 | 5970 | 107 | 0 | 34.39287073 | -81.1195624 | 2022-04-15 04:20:57 | Fairfield, South Carolina, US | |
2445576 | 2445576 | 2022-04-13 | US | South Carolina | Fairfield | 45039 | 5970 | 107 | 0 | 34.39287073 | -81.1195624 | 2022-04-13 23:21:06 | Fairfield, South Carolina, US | |
1951333 | 1951333 | 2022-04-12 | US | South Carolina | Fairfield | 45039 | 5970 | 107 | 0 | 34.39287073 | -81.1195624 | 2022-04-13 04:21:03 | Fairfield, South Carolina, US | |
1577075 | 1577075 | 2022-04-10 | US | Idaho | Blaine | 16013 | 5970 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-04-11 04:21:02 | Blaine, Idaho, US | |
1653317 | 1653317 | 2022-04-09 | US | Idaho | Blaine | 16013 | 5970 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-04-10 04:20:52 | Blaine, Idaho, US | |
2116639 | 2116639 | 2022-04-08 | US | Idaho | Blaine | 16013 | 5970 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-04-09 04:20:42 | Blaine, Idaho, US | |
2803046 | 2803046 | 2022-04-06 | US | New York | Seneca | 36099 | 5970 | 89 | 0 | 42.78081007 | -76.82497064 | 2022-04-07 04:20:53 | Seneca, New York, US | |
2749810 | 2749810 | 2022-04-04 | US | Idaho | Blaine | 16013 | 5970 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-04-05 04:20:48 | Blaine, Idaho, US | |
1469668 | 1469668 | 2022-03-24 | US | Maine | Waldo | 23027 | 5970 | 56 | 0 | 44.4858305 | -69.12061935 | 2022-03-25 04:20:46 | Waldo, Maine, US | |
2320275 | 2320275 | 2022-03-16 | US | Idaho | Jerome | 16053 | 5970 | 64 | 0 | 42.68891267 | -114.2655033 | 2022-03-17 04:20:56 | Jerome, Idaho, US | |
2200794 | 2200794 | 2022-03-06 | US | Indiana | Washington | 18175 | 5970 | 77 | 0 | 38.60219804 | -86.1049363 | 2022-03-07 04:20:47 | Washington, Indiana, US | |
2093251 | 2093251 | 2022-03-05 | US | Indiana | Washington | 18175 | 5970 | 77 | 0 | 38.60219804 | -86.1049363 | 2022-03-06 04:20:49 | Washington, Indiana, US | |
2666951 | 2666951 | 2022-03-04 | US | Indiana | Washington | 18175 | 5970 | 77 | 0 | 38.60219804 | -86.1049363 | 2022-03-05 04:21:10 | Washington, Indiana, US | |
3857409 | 3857409 | 2022-02-18 | US | Maryland | Caroline | 24011 | 5970 | 78 | 0 | 38.87172293 | -75.82904158 | 2022-02-19 04:21:11 | Caroline, Maryland, US | |
3823803 | 3823803 | 2022-02-16 | US | Virginia | Lee | 51105 | 5970 | 80 | 0 | 36.70586667 | -83.12606515 | 2022-02-17 04:20:56 | Lee, Virginia, US | |
189202 | 189202 | 2022-02-13 | US | Texas | Jasper | 48241 | 5970 | 173 | 0 | 30.74685667 | -94.02667579 | 2022-02-14 04:20:51 | Jasper, Texas, US | |
71731 | 71731 | 2022-02-07 | US | Colorado | Montezuma | 8083 | 5970 | 72 | 0 | 37.33859579 | -108.59588570000001 | 2022-02-08 04:21:15 | Montezuma, Colorado, US | |
1296987 | 1296987 | 2022-02-05 | US | Tennessee | Haywood | 47075 | 5970 | 88 | 0 | 35.58332824 | -89.28536625 | 2022-02-06 04:21:00 | Haywood, Tennessee, US | |
2657794 | 2657794 | 2022-01-31 | Japan | Kochi | 5970 | 37 | 0 | 33.422519 | 133.367307 | 2022-02-01 04:21:11 | Kochi, Japan | |||
2835785 | 2835785 | 2022-01-22 | US | Tennessee | Hickman | 47081 | 5970 | 95 | 0 | 35.80609681 | -87.47643507 | 2022-01-23 04:21:13 | Hickman, Tennessee, US | |
3831100 | 3831100 | 2021-12-21 | US | Oregon | Malheur | 41045 | 5970 | 94 | 0 | 43.1937027 | -117.62273950000001 | 2021-12-22 04:21:54 | Malheur, Oregon, US | |
3830174 | 3830174 | 2021-12-21 | US | Minnesota | Carlton | 27017 | 5970 | 80 | 0 | 46.59180601 | -92.67601019 | 2021-12-22 04:21:54 | Carlton, Minnesota, US | |
3829975 | 3829975 | 2021-12-21 | US | Louisiana | Evangeline | 22039 | 5970 | 143 | 0 | 30.72985248 | -92.39915924 | 2021-12-22 04:21:54 | Evangeline, Louisiana, US | |
2401318 | 2401318 | 2021-12-17 | US | Ohio | Ottawa | 39123 | 5970 | 116 | 0 | 41.53781826 | -83.0940185 | 2021-12-18 02:22:20 | Ottawa, Ohio, US | |
1667364 | 1667364 | 2021-12-11 | US | Tennessee | Carroll | 47017 | 5970 | 110 | 0 | 35.97366108 | -88.45189331 | 2021-12-12 04:22:12 | Carroll, Tennessee, US | |
406524 | 406524 | 2021-12-07 | US | New York | Columbia | 36021 | 5970 | 115 | 0 | 42.24819348 | -73.63089095 | 2021-12-08 04:22:46 | Columbia, New York, US | |
290240 | 290240 | 2021-10-31 | US | New York | Livingston | 36051 | 5970 | 71 | 0 | 42.72596275 | -77.77966158 | 2021-11-01 04:22:01 | Livingston, New York, US | |
3796917 | 3796917 | 2021-10-25 | US | Texas | Bee | 48025 | 5970 | 127 | 0 | 28.41761668 | -97.74215593 | 2021-10-26 04:22:09 | Bee, Texas, US | |
685363 | 685363 | 2021-10-24 | US | Texas | Bee | 48025 | 5970 | 127 | 0 | 28.41761668 | -97.74215593 | 2021-10-25 04:22:31 | Bee, Texas, US | |
600259 | 600259 | 2021-10-19 | US | Oklahoma | Ottawa | 40115 | 5970 | 90 | 0 | 36.83532655 | -94.81011909 | 2021-10-20 04:21:00 | Ottawa, Oklahoma, US | |
2046436 | 2046436 | 2021-10-18 | US | Oklahoma | Ottawa | 40115 | 5970 | 90 | 0 | 36.83532655 | -94.81011909 | 2021-10-19 04:20:54 | Ottawa, Oklahoma, US | |
1912715 | 1912715 | 2021-10-17 | US | West Virginia | Ohio | 54069 | 5970 | 102 | 0 | 40.0955451 | -80.62203992 | 2021-10-18 04:21:10 | Ohio, West Virginia, US | |
1911797 | 1911797 | 2021-10-17 | US | Oklahoma | Ottawa | 40115 | 5970 | 90 | 0 | 36.83532655 | -94.81011909 | 2021-10-18 04:21:10 | Ottawa, Oklahoma, US | |
937386 | 937386 | 2021-10-16 | US | Oklahoma | Ottawa | 40115 | 5970 | 90 | 0 | 36.83532655 | -94.81011909 | 2021-10-17 04:21:29 | Ottawa, Oklahoma, US | |
2945941 | 2945941 | 2021-10-15 | US | Oklahoma | Ottawa | 40115 | 5970 | 90 | 0 | 36.83532655 | -94.81011909 | 2021-10-16 04:21:15 | Ottawa, Oklahoma, US | |
494221 | 494221 | 2021-10-14 | US | Oklahoma | Ottawa | 40115 | 5970 | 90 | 0 | 36.83532655 | -94.81011909 | 2021-10-15 04:21:26 | Ottawa, Oklahoma, US | |
636509 | 636509 | 2021-10-13 | US | Oklahoma | Ottawa | 40115 | 5970 | 90 | 0 | 36.83532655 | -94.81011909 | 2021-10-14 04:21:29 | Ottawa, Oklahoma, US | |
1817692 | 1817692 | 2021-09-19 | US | Tennessee | Campbell | 47013 | 5970 | 69 | 0 | 36.40355516 | -84.15108559999999 | 2021-09-20 04:21:22 | Campbell, Tennessee, US | |
2282772 | 2282772 | 2021-09-08 | US | Wyoming | Sweetwater | 56037 | 5970 | 51 | 0 | 41.65943896 | -108.8827882 | 2021-09-09 04:21:27 | Sweetwater, Wyoming, US | |
642950 | 642950 | 2021-09-07 | US | Illinois | Macoupin | 17117 | 5970 | 93 | 0 | 39.26119767 | -89.92424028 | 2021-09-08 04:21:31 | Macoupin, Illinois, US | |
35959 | 35959 | 2021-08-25 | US | Wisconsin | Grant | 55043 | 5970 | 97 | 0 | 42.8671731 | -90.7063218 | 2021-08-26 04:21:28 | Grant, Wisconsin, US | |
2177079 | 2177079 | 2021-08-22 | US | Louisiana | St. Bernard | 22087 | 5970 | 69 | 0 | 29.87761636 | -89.51887093 | 2021-08-23 04:21:27 | St. Bernard, Louisiana, US | |
3557175 | 3557175 | 2021-08-21 | US | Louisiana | St. Bernard | 22087 | 5970 | 69 | 0 | 29.87761636 | -89.51887093 | 2021-08-22 04:21:29 | St. Bernard, Louisiana, US | |
1855517 | 1855517 | 2021-08-20 | US | Louisiana | St. Bernard | 22087 | 5970 | 69 | 0 | 29.87761636 | -89.51887093 | 2021-08-21 04:21:38 | St. Bernard, Louisiana, US | |
2521177 | 2521177 | 2021-08-18 | US | Tennessee | Warren | 47177 | 5970 | 87 | 0 | 35.672829899999996 | -85.77969117 | 2021-08-19 04:21:15 | Warren, Tennessee, US | |
1443242 | 1443242 | 2021-07-07 | US | Pennsylvania | Columbia | 42037 | 5970 | 136 | 0 | 41.04821986 | -76.40565017 | 2021-07-08 04:21:26 | Columbia, Pennsylvania, 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]);