johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
177 rows where confirmed = 5016 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753806 | 2753806 | 2022-12-29 | US | Georgia | Washington | 13303 | 5016 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-30 04:21:04 | Washington, Georgia, US | |
1074812 | 1074812 | 2022-12-28 | US | Georgia | Washington | 13303 | 5016 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-29 04:21:01 | Washington, Georgia, US | |
2418381 | 2418381 | 2022-12-05 | US | West Virginia | Morgan | 54065 | 5016 | 76 | 0 | 39.55439028 | -78.26311676 | 2022-12-06 04:21:03 | Morgan, West Virginia, US | |
618355 | 618355 | 2022-11-05 | US | Arkansas | Grant | 5053 | 5016 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-11-06 04:21:24 | Grant, Arkansas, US | |
1022859 | 1022859 | 2022-11-04 | US | Arkansas | Grant | 5053 | 5016 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-11-05 04:21:52 | Grant, Arkansas, US | |
1811774 | 1811774 | 2022-10-05 | US | Illinois | Hancock | 17067 | 5016 | 50 | 0 | 40.40423981 | -91.16313899 | 2022-10-06 04:21:22 | Hancock, Illinois, US | |
2262538 | 2262538 | 2022-10-02 | US | Puerto Rico | Penuelas | 72111 | 5016 | 0 | 0 | 18.059645 | -66.721572 | 2022-10-03 04:23:11 | Penuelas, Puerto Rico, US | |
2395790 | 2395790 | 2022-09-12 | US | Illinois | Ford | 17053 | 5016 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-13 04:20:57 | Ford, Illinois, US | |
2404345 | 2404345 | 2022-08-21 | US | Louisiana | Jackson | 22049 | 5016 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-22 04:20:38 | Jackson, Louisiana, US | |
3799423 | 3799423 | 2022-08-20 | US | Louisiana | Jackson | 22049 | 5016 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-21 04:20:44 | Jackson, Louisiana, US | |
2365009 | 2365009 | 2022-08-19 | US | Louisiana | Jackson | 22049 | 5016 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-20 04:21:01 | Jackson, Louisiana, US | |
3951529 | 3951529 | 2022-08-17 | US | Illinois | Piatt | 17147 | 5016 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-08-18 04:21:11 | Piatt, Illinois, US | |
3409041 | 3409041 | 2022-07-17 | US | Wisconsin | Sawyer | 55113 | 5016 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-07-18 04:20:59 | Sawyer, Wisconsin, US | |
2155241 | 2155241 | 2022-07-16 | US | Wisconsin | Sawyer | 55113 | 5016 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-07-17 04:21:15 | Sawyer, Wisconsin, US | |
2422474 | 2422474 | 2022-07-15 | US | Wisconsin | Sawyer | 55113 | 5016 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-07-16 04:21:05 | Sawyer, Wisconsin, US | |
3967686 | 3967686 | 2022-07-05 | US | Indiana | Rush | 18139 | 5016 | 58 | 0 | 39.62002287 | -85.4655599 | 2022-07-06 04:20:58 | Rush, Indiana, US | |
3079197 | 3079197 | 2022-07-04 | US | Indiana | Rush | 18139 | 5016 | 58 | 0 | 39.62002287 | -85.4655599 | 2022-07-05 04:20:45 | Rush, Indiana, US | |
1768479 | 1768479 | 2022-07-03 | US | Indiana | Rush | 18139 | 5016 | 58 | 0 | 39.62002287 | -85.4655599 | 2022-07-04 04:20:54 | Rush, Indiana, US | |
3366465 | 3366465 | 2022-07-02 | US | Indiana | Rush | 18139 | 5016 | 58 | 0 | 39.62002287 | -85.4655599 | 2022-07-03 04:20:59 | Rush, Indiana, US | |
594794 | 594794 | 2022-07-01 | US | Indiana | Rush | 18139 | 5016 | 58 | 0 | 39.62002287 | -85.4655599 | 2022-07-02 04:21:16 | Rush, Indiana, US | |
3940660 | 3940660 | 2022-06-30 | US | Colorado | Alamosa | 8003 | 5016 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-07-01 04:21:10 | Alamosa, Colorado, US | |
2151229 | 2151229 | 2022-06-27 | US | Wisconsin | Taylor | 55119 | 5016 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-06-28 04:20:58 | Taylor, Wisconsin, US | |
950069 | 950069 | 2022-06-14 | US | Texas | Scurry | 48415 | 5016 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-06-15 04:20:54 | Scurry, Texas, US | |
2982477 | 2982477 | 2022-06-13 | US | Texas | Scurry | 48415 | 5016 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-06-14 04:20:52 | Scurry, Texas, US | |
3158010 | 3158010 | 2022-06-09 | US | Alabama | Fayette | 1057 | 5016 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-06-10 04:20:55 | Fayette, Alabama, US | |
1421711 | 1421711 | 2022-06-08 | US | Colorado | Chaffee | 8015 | 5016 | 48 | 0 | 38.74745778 | -106.1926573 | 2022-06-09 04:20:54 | Chaffee, Colorado, US | |
1421477 | 1421477 | 2022-06-08 | US | Alabama | Fayette | 1057 | 5016 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-06-09 04:20:54 | Fayette, Alabama, US | |
3583072 | 3583072 | 2022-05-17 | US | Alaska | Kodiak Island | 2150 | 5016 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-18 04:20:50 | Kodiak Island, Alaska, US | |
1504029 | 1504029 | 2022-05-16 | US | Alaska | Kodiak Island | 2150 | 5016 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-17 04:20:59 | Kodiak Island, Alaska, US | |
2084388 | 2084388 | 2022-05-15 | US | Alaska | Kodiak Island | 2150 | 5016 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-16 04:20:47 | Kodiak Island, Alaska, US | |
3355098 | 3355098 | 2022-05-14 | US | Alaska | Kodiak Island | 2150 | 5016 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-15 04:20:53 | Kodiak Island, Alaska, US | |
658743 | 658743 | 2022-05-13 | US | Alaska | Kodiak Island | 2150 | 5016 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-14 04:20:48 | Kodiak Island, Alaska, US | |
2533826 | 2533826 | 2022-05-12 | US | Alaska | Kodiak Island | 2150 | 5016 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-13 04:20:51 | Kodiak Island, Alaska, US | |
3445272 | 3445272 | 2022-05-11 | US | Alaska | Kodiak Island | 2150 | 5016 | 12 | 0 | 57.65529415 | -153.7493579 | 2022-05-12 04:20:54 | Kodiak Island, Alaska, US | |
2333544 | 2333544 | 2022-05-08 | US | New Hampshire | Unassigned | 90033 | 5016 | 2 | 0 | 44.69063265 | 0.0 | 2022-05-09 04:20:54 | Unassigned, New Hampshire, US | |
362506 | 362506 | 2022-05-07 | US | New Hampshire | Unassigned | 90033 | 5016 | 2 | 0 | 44.69063265 | 0.0 | 2022-05-08 04:20:49 | Unassigned, New Hampshire, US | |
1399857 | 1399857 | 2022-05-06 | US | New Hampshire | Unassigned | 90033 | 5016 | 2 | 0 | 44.69063265 | 0.0 | 2022-05-07 04:21:09 | Unassigned, New Hampshire, US | |
3268534 | 3268534 | 2022-05-04 | US | Texas | Burleson | 48051 | 5016 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-05-05 04:20:55 | Burleson, Texas, US | |
1574345 | 1574345 | 2022-05-03 | US | New Mexico | Roosevelt | 35041 | 5016 | 95 | 0 | 34.02097406 | -103.4799493 | 2022-05-04 04:20:59 | Roosevelt, New Mexico, US | |
1159271 | 1159271 | 2022-04-29 | US | Nebraska | Saunders | 31155 | 5016 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-04-30 04:21:05 | Saunders, Nebraska, US | |
1698453 | 1698453 | 2022-04-28 | US | Nebraska | Saunders | 31155 | 5016 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-04-29 04:20:59 | Saunders, Nebraska, US | |
3853936 | 3853936 | 2022-04-27 | US | Nebraska | Saunders | 31155 | 5016 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-04-28 04:20:47 | Saunders, Nebraska, US | |
1328366 | 1328366 | 2022-04-26 | US | Nebraska | Saunders | 31155 | 5016 | 30 | 0 | 41.227810299999994 | -96.63773905 | 2022-04-27 04:20:52 | Saunders, Nebraska, US | |
1327925 | 1327925 | 2022-04-26 | US | Michigan | Osceola | 26133 | 5016 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-04-27 04:20:52 | Osceola, Michigan, US | |
3724928 | 3724928 | 2022-04-25 | US | Puerto Rico | Camuy | 72027 | 5016 | 0 | 0 | 18.418578 | -66.860206 | 2022-04-26 04:20:51 | Camuy, Puerto Rico, US | |
3723879 | 3723879 | 2022-04-25 | US | Michigan | Osceola | 26133 | 5016 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-04-26 04:20:51 | Osceola, Michigan, US | |
2030447 | 2030447 | 2022-04-24 | US | Michigan | Osceola | 26133 | 5016 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-04-25 04:20:56 | Osceola, Michigan, US | |
748022 | 748022 | 2022-04-23 | US | Michigan | Osceola | 26133 | 5016 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-04-24 04:20:56 | Osceola, Michigan, US | |
3438507 | 3438507 | 2022-04-22 | US | Michigan | Osceola | 26133 | 5016 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-04-23 04:20:50 | Osceola, Michigan, US | |
2894092 | 2894092 | 2022-04-21 | US | Michigan | Osceola | 26133 | 5016 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-04-22 04:20:45 | Osceola, Michigan, US | |
2310761 | 2310761 | 2022-04-20 | US | West Virginia | Brooke | 54009 | 5016 | 104 | 0 | 40.27367263 | -80.57915332 | 2022-04-21 04:20:46 | Brooke, West Virginia, US | |
2308964 | 2308964 | 2022-04-20 | US | Michigan | Osceola | 26133 | 5016 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-04-21 04:20:46 | Osceola, Michigan, US | |
1950898 | 1950898 | 2022-04-12 | US | North Carolina | Yancey | 37199 | 5016 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-04-13 04:21:03 | Yancey, North Carolina, US | |
3208651 | 3208651 | 2022-04-11 | US | North Carolina | Yancey | 37199 | 5016 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-04-12 04:20:49 | Yancey, North Carolina, US | |
1578537 | 1578537 | 2022-04-10 | US | North Carolina | Yancey | 37199 | 5016 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-04-11 04:21:02 | Yancey, North Carolina, US | |
1654779 | 1654779 | 2022-04-09 | US | North Carolina | Yancey | 37199 | 5016 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-04-10 04:20:52 | Yancey, North Carolina, US | |
2118101 | 2118101 | 2022-04-08 | US | North Carolina | Yancey | 37199 | 5016 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-04-09 04:20:42 | Yancey, North Carolina, US | |
3323020 | 3323020 | 2022-04-07 | US | Puerto Rico | San Lorenzo | 72129 | 5016 | 0 | 0 | 18.147987 | -65.976392 | 2022-04-08 04:20:48 | San Lorenzo, Puerto Rico, US | |
3322625 | 3322625 | 2022-04-07 | US | North Carolina | Yancey | 37199 | 5016 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-04-08 04:20:48 | Yancey, North Carolina, US | |
2803161 | 2803161 | 2022-04-06 | US | North Carolina | Yancey | 37199 | 5016 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-04-07 04:20:53 | Yancey, North Carolina, US | |
3870185 | 3870185 | 2022-04-05 | US | Oregon | Union | 41061 | 5016 | 76 | 0 | 45.30915495 | -118.0068979 | 2022-04-06 04:20:49 | Union, Oregon, US | |
2751527 | 2751527 | 2022-04-04 | US | Oregon | Union | 41061 | 5016 | 76 | 0 | 45.30915495 | -118.0068979 | 2022-04-05 04:20:48 | Union, Oregon, US | |
3732873 | 3732873 | 2022-04-03 | US | Oregon | Union | 41061 | 5016 | 76 | 0 | 45.30915495 | -118.0068979 | 2022-04-04 04:20:51 | Union, Oregon, US | |
502308 | 502308 | 2022-04-02 | US | Oregon | Union | 41061 | 5016 | 76 | 0 | 45.30915495 | -118.0068979 | 2022-04-03 04:20:48 | Union, Oregon, US | |
3353293 | 3353293 | 2022-04-01 | US | Oregon | Union | 41061 | 5016 | 76 | 0 | 45.30915495 | -118.0068979 | 2022-04-02 04:20:47 | Union, Oregon, US | |
1542598 | 1542598 | 2022-03-31 | US | Oregon | Union | 41061 | 5016 | 76 | 0 | 45.30915495 | -118.0068979 | 2022-04-01 04:20:28 | Union, Oregon, US | |
2480611 | 2480611 | 2022-03-30 | US | Oregon | Union | 41061 | 5016 | 76 | 0 | 45.30915495 | -118.0068979 | 2022-03-31 04:20:56 | Union, Oregon, US | |
160652 | 160652 | 2022-03-29 | US | Oregon | Union | 41061 | 5016 | 75 | 0 | 45.30915495 | -118.0068979 | 2022-03-30 04:20:45 | Union, Oregon, US | |
1438702 | 1438702 | 2022-03-28 | US | Nebraska | Saunders | 31155 | 5016 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2022-03-29 04:20:46 | Saunders, Nebraska, US | |
877301 | 877301 | 2022-03-27 | US | Illinois | Pike | 17149 | 5016 | 65 | 0 | 39.62265059 | -90.8877017 | 2022-03-28 04:20:33 | Pike, Illinois, US | |
2164584 | 2164584 | 2022-03-26 | US | Illinois | Pike | 17149 | 5016 | 65 | 0 | 39.62265059 | -90.8877017 | 2022-03-27 04:20:47 | Pike, Illinois, US | |
1721520 | 1721520 | 2022-03-25 | US | Illinois | Pike | 17149 | 5016 | 65 | 0 | 39.62265059 | -90.8877017 | 2022-03-26 04:20:23 | Pike, Illinois, US | |
3023105 | 3023105 | 2022-03-23 | US | Georgia | Jones | 13169 | 5016 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-03-24 04:20:43 | Jones, Georgia, US | |
1906027 | 1906027 | 2022-03-22 | US | Georgia | Jones | 13169 | 5016 | 108 | 0 | 33.02512137 | -83.56019163 | 2022-03-23 04:20:48 | Jones, Georgia, US | |
3856333 | 3856333 | 2022-02-18 | US | Arkansas | Lawrence | 5075 | 5016 | 68 | 0 | 36.04188196 | -91.10867198 | 2022-02-19 04:21:11 | Lawrence, Arkansas, US | |
3672051 | 3672051 | 2022-02-15 | US | Alabama | Pickens | 1107 | 5016 | 95 | 0 | 33.28094866 | -88.08818103 | 2022-02-16 04:21:10 | Pickens, Alabama, US | |
186471 | 186471 | 2022-02-13 | US | Alabama | Randolph | 1111 | 5016 | 72 | 0 | 33.29526734 | -85.45708831 | 2022-02-14 04:20:51 | Randolph, Alabama, US | |
316317 | 316317 | 2022-02-12 | US | Alabama | Randolph | 1111 | 5016 | 72 | 0 | 33.29526734 | -85.45708831 | 2022-02-13 04:21:00 | Randolph, Alabama, US | |
1465027 | 1465027 | 2022-02-10 | US | Idaho | Jerome | 16053 | 5016 | 60 | 0 | 42.68891267 | -114.2655033 | 2022-02-11 04:21:09 | Jerome, Idaho, US | |
982508 | 982508 | 2022-02-01 | US | Wisconsin | Langlade | 55067 | 5016 | 73 | 0 | 45.26271619 | -89.07483625 | 2022-02-02 04:21:09 | Langlade, Wisconsin, US | |
982372 | 982372 | 2022-02-01 | US | Virginia | Waynesboro | 51820 | 5016 | 55 | 0 | 38.06451466 | -78.90293905 | 2022-02-02 04:21:09 | Waynesboro, Virginia, US | |
2659566 | 2659566 | 2022-01-31 | US | Minnesota | Wabasha | 27157 | 5016 | 14 | 0 | 44.28424356 | -92.23121312 | 2022-02-01 04:21:11 | Wabasha, Minnesota, US | |
2835837 | 2835837 | 2022-01-22 | US | Tennessee | Wayne | 47181 | 5016 | 52 | 0 | 35.23868267 | -87.78644456 | 2022-01-23 04:21:13 | Wayne, Tennessee, US | |
1114448 | 1114448 | 2022-01-11 | US | Georgia | Peach | 13225 | 5016 | 115 | 0 | 32.56934316 | -83.82937 | 2022-01-12 04:21:44 | Peach, Georgia, US | |
2090756 | 2090756 | 2021-12-14 | US | Puerto Rico | Toa Alta | 72135 | 5016 | 0 | 0 | 18.362406 | -66.246616 | 2021-12-15 03:22:16 | Toa Alta, Puerto Rico, US | |
1661581 | 1661581 | 2021-12-12 | US | Indiana | Wells | 18179 | 5016 | 107 | 0 | 40.72934187 | -85.22132966 | 2021-12-13 04:22:02 | Wells, Indiana, US | |
1665597 | 1665597 | 2021-12-11 | US | Indiana | Wells | 18179 | 5016 | 107 | 0 | 40.72934187 | -85.22132966 | 2021-12-12 04:22:12 | Wells, Indiana, US | |
3656749 | 3656749 | 2021-12-10 | US | Indiana | Wells | 18179 | 5016 | 107 | 0 | 40.72934187 | -85.22132966 | 2021-12-11 04:22:45 | Wells, Indiana, US | |
1079987 | 1079987 | 2021-12-09 | US | Nebraska | Dakota | 31043 | 5016 | 65 | 0 | 42.39040144 | -96.56656425 | 2021-12-10 04:22:28 | Dakota, Nebraska, US | |
1146850 | 1146850 | 2021-12-01 | US | Missouri | Lafayette | 29107 | 5016 | 77 | 0 | 39.06986886 | -93.78076396 | 2021-12-02 04:22:37 | Lafayette, Missouri, US | |
3750870 | 3750870 | 2021-11-22 | US | Minnesota | Mille Lacs | 27095 | 5016 | 71 | 0 | 45.93705297 | -93.63236823 | 2021-11-23 04:22:39 | Mille Lacs, Minnesota, US | |
3639952 | 3639952 | 2021-11-08 | US | Alabama | Pike | 1109 | 5016 | 108 | 0 | 31.80396383 | -85.9408295 | 2021-11-09 04:21:36 | Pike, Alabama, US | |
2001060 | 2001060 | 2021-11-07 | US | Alabama | Pike | 1109 | 5016 | 108 | 0 | 31.80396383 | -85.9408295 | 2021-11-08 04:21:43 | Pike, Alabama, US | |
496051 | 496051 | 2021-11-06 | US | Alabama | Pike | 1109 | 5016 | 108 | 0 | 31.80396383 | -85.9408295 | 2021-11-07 04:21:53 | Pike, Alabama, US | |
3121906 | 3121906 | 2021-11-05 | US | Alabama | Pike | 1109 | 5016 | 107 | 0 | 31.80396383 | -85.9408295 | 2021-11-06 04:21:51 | Pike, Alabama, US | |
3513611 | 3513611 | 2021-11-01 | US | New Mexico | Rio Arriba | 35039 | 5016 | 85 | 0 | 36.51072137 | -106.69316740000001 | 2021-11-02 04:22:03 | Rio Arriba, New Mexico, US | |
568697 | 568697 | 2021-10-29 | US | Maryland | Worcester | 24047 | 5016 | 119 | 0 | 38.21274277 | -75.33200012 | 2021-10-30 04:22:03 | Worcester, Maryland, US | |
6323 | 6323 | 2021-10-28 | US | Missouri | Warren | 29219 | 5016 | 47 | 0 | 38.76529479 | -91.16124662 | 2021-10-29 04:22:03 | Warren, Missouri, US | |
4744 | 4744 | 2021-10-28 | US | Alabama | Pike | 1109 | 5016 | 106 | 0 | 31.80396383 | -85.9408295 | 2021-10-29 04:22:03 | Pike, Alabama, US | |
3493612 | 3493612 | 2021-10-26 | US | Kentucky | Marshall | 21157 | 5016 | 78 | 0 | 36.88007070000001 | -88.32803576 | 2021-10-27 04:22:32 | Marshall, Kentucky, 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]);