johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
602 rows where confirmed = 526 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
314938 | 314938 | 2022-11-13 | US | Texas | Briscoe | 48045 | 526 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-11-14 04:21:09 | Briscoe, Texas, US | |
66099 | 66099 | 2022-11-12 | US | Texas | Briscoe | 48045 | 526 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-11-13 04:21:14 | Briscoe, Texas, US | |
2930261 | 2930261 | 2022-11-11 | US | Texas | Briscoe | 48045 | 526 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-11-12 04:20:41 | Briscoe, Texas, US | |
2509097 | 2509097 | 2022-11-10 | US | Texas | Briscoe | 48045 | 526 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-11-11 04:21:22 | Briscoe, Texas, US | |
2433972 | 2433972 | 2022-11-09 | US | Texas | Briscoe | 48045 | 526 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-11-10 04:21:16 | Briscoe, Texas, US | |
322345 | 322345 | 2022-10-30 | US | North Dakota | Logan | 38047 | 526 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-10-31 04:21:36 | Logan, North Dakota, US | |
914621 | 914621 | 2022-10-29 | US | North Dakota | Logan | 38047 | 526 | 12 | 0 | 46.45729487 | -99.47719806 | 2022-10-30 04:22:14 | Logan, North Dakota, US | |
1832561 | 1832561 | 2022-10-25 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-26 04:22:19 | Grant, North Dakota, US | |
796822 | 796822 | 2022-10-24 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-25 04:21:53 | Grant, North Dakota, US | |
3279277 | 3279277 | 2022-10-23 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-24 04:22:29 | Grant, North Dakota, US | |
2270315 | 2270315 | 2022-10-22 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-23 04:22:46 | Grant, North Dakota, US | |
1594615 | 1594615 | 2022-10-21 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-22 04:22:53 | Grant, North Dakota, US | |
2274331 | 2274331 | 2022-10-20 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-21 04:22:23 | Grant, North Dakota, US | |
200666 | 200666 | 2022-10-19 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-20 04:22:59 | Grant, North Dakota, US | |
2759327 | 2759327 | 2022-10-18 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-19 04:22:26 | Grant, North Dakota, US | |
2027161 | 2027161 | 2022-10-17 | US | North Dakota | Grant | 38037 | 526 | 11 | 0 | 46.35821257 | -101.6390013 | 2022-10-18 04:22:42 | Grant, North Dakota, US | |
3251079 | 3251079 | 2022-10-11 | US | Idaho | Butte | 16023 | 526 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-12 04:22:51 | Butte, Idaho, US | |
2968338 | 2968338 | 2022-10-10 | US | Idaho | Butte | 16023 | 526 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-11 04:23:05 | Butte, Idaho, US | |
3098374 | 3098374 | 2022-10-09 | US | Idaho | Butte | 16023 | 526 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-10 04:22:32 | Butte, Idaho, US | |
4003599 | 4003599 | 2022-10-08 | US | Idaho | Butte | 16023 | 526 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-09 04:21:16 | Butte, Idaho, US | |
397196 | 397196 | 2022-10-07 | US | Idaho | Butte | 16023 | 526 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-08 04:22:56 | Butte, Idaho, US | |
2530313 | 2530313 | 2022-10-06 | US | Idaho | Butte | 16023 | 526 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-07 04:23:08 | Butte, Idaho, US | |
1811707 | 1811707 | 2022-10-05 | US | Idaho | Butte | 16023 | 526 | 12 | 0 | 43.72592209 | -113.1735463 | 2022-10-06 04:21:22 | Butte, Idaho, US | |
253972 | 253972 | 2022-09-08 | US | Colorado | Sedgwick | 8115 | 526 | 10 | 0 | 40.87595412 | -102.3519227 | 2022-09-09 04:21:11 | Sedgwick, Colorado, US | |
116048 | 116048 | 2022-09-06 | US | Kansas | Hamilton | 20075 | 526 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-09-07 04:20:59 | Hamilton, Kansas, US | |
2635020 | 2635020 | 2022-09-05 | US | Kansas | Hamilton | 20075 | 526 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-09-06 04:21:02 | Hamilton, Kansas, US | |
2988584 | 2988584 | 2022-09-04 | US | Kansas | Hamilton | 20075 | 526 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-09-05 04:21:01 | Hamilton, Kansas, US | |
2714269 | 2714269 | 2022-09-03 | US | Kansas | Hamilton | 20075 | 526 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-09-04 04:21:22 | Hamilton, Kansas, US | |
1394974 | 1394974 | 2022-09-02 | US | Kansas | Hamilton | 20075 | 526 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-09-03 04:21:04 | Hamilton, Kansas, US | |
3548803 | 3548803 | 2022-09-01 | US | Kansas | Hamilton | 20075 | 526 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-09-02 04:21:07 | Hamilton, Kansas, US | |
2344723 | 2344723 | 2022-08-31 | US | Kansas | Hamilton | 20075 | 526 | 3 | 0 | 37.99978709 | -101.7921066 | 2022-09-01 04:21:03 | Hamilton, Kansas, US | |
2831213 | 2831213 | 2022-08-25 | US | North Dakota | Divide | 38023 | 526 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-08-26 04:21:02 | Divide, North Dakota, US | |
3911133 | 3911133 | 2022-08-11 | US | Texas | Irion | 48235 | 526 | 3 | 0 | 31.30375559 | -100.982439 | 2022-08-12 04:20:54 | Irion, Texas, US | |
1349450 | 1349450 | 2022-08-10 | US | Texas | Irion | 48235 | 526 | 3 | 0 | 31.30375559 | -100.982439 | 2022-08-11 04:20:49 | Irion, Texas, US | |
1089205 | 1089205 | 2022-08-09 | US | Texas | Irion | 48235 | 526 | 3 | 0 | 31.30375559 | -100.982439 | 2022-08-10 04:20:57 | Irion, Texas, US | |
2190172 | 2190172 | 2022-06-22 | US | Oklahoma | Harmon | 40057 | 526 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-06-23 04:20:55 | Harmon, Oklahoma, US | |
168603 | 168603 | 2022-06-21 | US | Oklahoma | Harmon | 40057 | 526 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-06-22 04:20:54 | Harmon, Oklahoma, US | |
1765886 | 1765886 | 2022-06-20 | US | Oklahoma | Harmon | 40057 | 526 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-06-21 04:20:56 | Harmon, Oklahoma, US | |
3272072 | 3272072 | 2022-06-19 | US | Oklahoma | Harmon | 40057 | 526 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-06-20 04:21:01 | Harmon, Oklahoma, US | |
3399984 | 3399984 | 2022-06-18 | US | Oklahoma | Harmon | 40057 | 526 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-06-19 04:20:51 | Harmon, Oklahoma, US | |
2313861 | 2313861 | 2022-06-17 | US | Oklahoma | Harmon | 40057 | 526 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-06-18 04:21:10 | Harmon, Oklahoma, US | |
561365 | 561365 | 2022-06-16 | US | Oklahoma | Harmon | 40057 | 526 | 12 | 0 | 34.7440135 | -99.84741652 | 2022-06-17 04:20:56 | Harmon, Oklahoma, US | |
1327182 | 1327182 | 2022-04-26 | US | Idaho | Custer | 16037 | 526 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-27 04:20:52 | Custer, Idaho, US | |
3723136 | 3723136 | 2022-04-25 | US | Idaho | Custer | 16037 | 526 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-26 04:20:51 | Custer, Idaho, US | |
2029704 | 2029704 | 2022-04-24 | US | Idaho | Custer | 16037 | 526 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-25 04:20:56 | Custer, Idaho, US | |
747279 | 747279 | 2022-04-23 | US | Idaho | Custer | 16037 | 526 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-24 04:20:56 | Custer, Idaho, US | |
3437764 | 3437764 | 2022-04-22 | US | Idaho | Custer | 16037 | 526 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-23 04:20:50 | Custer, Idaho, US | |
2895632 | 2895632 | 2022-04-21 | US | Texas | Schleicher | 48413 | 526 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-04-22 04:20:45 | Schleicher, Texas, US | |
2893349 | 2893349 | 2022-04-21 | US | Idaho | Custer | 16037 | 526 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-22 04:20:45 | Custer, Idaho, US | |
2310504 | 2310504 | 2022-04-20 | US | Texas | Schleicher | 48413 | 526 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-04-21 04:20:46 | Schleicher, Texas, US | |
2310303 | 2310303 | 2022-04-20 | US | Texas | Armstrong | 48011 | 526 | 9 | 0 | 34.96507426 | -101.35748740000001 | 2022-04-21 04:20:46 | Armstrong, Texas, US | |
2308221 | 2308221 | 2022-04-20 | US | Idaho | Custer | 16037 | 526 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-04-21 04:20:46 | Custer, Idaho, US | |
2254643 | 2254643 | 2022-04-19 | US | Texas | Schleicher | 48413 | 526 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-04-20 04:20:45 | Schleicher, Texas, US | |
2254442 | 2254442 | 2022-04-19 | US | Texas | Armstrong | 48011 | 526 | 9 | 0 | 34.96507426 | -101.35748740000001 | 2022-04-20 04:20:45 | Armstrong, Texas, US | |
1849193 | 1849193 | 2022-04-18 | US | Texas | Schleicher | 48413 | 526 | 9 | 0 | 30.89740592 | -100.5384842 | 2022-04-19 04:21:00 | Schleicher, Texas, US | |
1948955 | 1948955 | 2022-04-12 | US | Alaska | Wrangell | 2275 | 526 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-04-13 04:21:03 | Wrangell, Alaska, US | |
3206708 | 3206708 | 2022-04-11 | US | Alaska | Wrangell | 2275 | 526 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-04-12 04:20:49 | Wrangell, Alaska, US | |
1576594 | 1576594 | 2022-04-10 | US | Alaska | Wrangell | 2275 | 526 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-04-11 04:21:02 | Wrangell, Alaska, US | |
1652836 | 1652836 | 2022-04-09 | US | Alaska | Wrangell | 2275 | 526 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-04-10 04:20:52 | Wrangell, Alaska, US | |
2116158 | 2116158 | 2022-04-08 | US | Alaska | Wrangell | 2275 | 526 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-04-09 04:20:42 | Wrangell, Alaska, US | |
3321017 | 3321017 | 2022-04-07 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-08 04:20:48 | Clay, Georgia, US | |
3320682 | 3320682 | 2022-04-07 | US | Alaska | Wrangell | 2275 | 526 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-04-08 04:20:48 | Wrangell, Alaska, US | |
2801553 | 2801553 | 2022-04-06 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-07 04:20:53 | Clay, Georgia, US | |
2801218 | 2801218 | 2022-04-06 | US | Alaska | Wrangell | 2275 | 526 | 1 | 0 | 56.3202004 | -132.05837309999998 | 2022-04-07 04:20:53 | Wrangell, Alaska, US | |
3870439 | 3870439 | 2022-04-05 | US | South Dakota | Mellette | 46095 | 526 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-04-06 04:20:49 | Mellette, South Dakota, US | |
3868322 | 3868322 | 2022-04-05 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-06 04:20:49 | Clay, Georgia, US | |
2751781 | 2751781 | 2022-04-04 | US | South Dakota | Mellette | 46095 | 526 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-04-05 04:20:48 | Mellette, South Dakota, US | |
2749664 | 2749664 | 2022-04-04 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-05 04:20:48 | Clay, Georgia, US | |
3733127 | 3733127 | 2022-04-03 | US | South Dakota | Mellette | 46095 | 526 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-04-04 04:20:51 | Mellette, South Dakota, US | |
3731010 | 3731010 | 2022-04-03 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-04 04:20:51 | Clay, Georgia, US | |
502562 | 502562 | 2022-04-02 | US | South Dakota | Mellette | 46095 | 526 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-04-03 04:20:48 | Mellette, South Dakota, US | |
500445 | 500445 | 2022-04-02 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-03 04:20:48 | Clay, Georgia, US | |
3353547 | 3353547 | 2022-04-01 | US | South Dakota | Mellette | 46095 | 526 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-04-02 04:20:47 | Mellette, South Dakota, US | |
3351430 | 3351430 | 2022-04-01 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-02 04:20:47 | Clay, Georgia, US | |
1542852 | 1542852 | 2022-03-31 | US | South Dakota | Mellette | 46095 | 526 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-04-01 04:20:28 | Mellette, South Dakota, US | |
1540735 | 1540735 | 2022-03-31 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-04-01 04:20:28 | Clay, Georgia, US | |
2480865 | 2480865 | 2022-03-30 | US | South Dakota | Mellette | 46095 | 526 | 8 | 0 | 43.58078848 | -100.7563186 | 2022-03-31 04:20:56 | Mellette, South Dakota, US | |
2478748 | 2478748 | 2022-03-30 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-03-31 04:20:56 | Clay, Georgia, US | |
158789 | 158789 | 2022-03-29 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-03-30 04:20:45 | Clay, Georgia, US | |
1437360 | 1437360 | 2022-03-28 | US | Georgia | Clay | 13061 | 526 | 6 | 0 | 31.62221166 | -84.97713865 | 2022-03-29 04:20:46 | Clay, Georgia, US | |
1648039 | 1648039 | 2022-03-03 | Winter Olympics 2022 | 526 | 0 | 0 | 39.9042 | 116.4074 | 2022-03-04 04:21:09 | Winter Olympics 2022 | ||||
3859299 | 3859299 | 2022-02-18 | US | Washington | Wahkiakum | 53069 | 526 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-02-19 04:21:11 | Wahkiakum, Washington, US | |
1301518 | 1301518 | 2022-02-17 | US | Washington | Wahkiakum | 53069 | 526 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-02-18 04:21:04 | Wahkiakum, Washington, US | |
3823904 | 3823904 | 2022-02-16 | US | Washington | Wahkiakum | 53069 | 526 | 5 | 0 | 46.29180039999999 | -123.4250831 | 2022-02-17 04:20:56 | Wahkiakum, Washington, US | |
3823352 | 3823352 | 2022-02-16 | US | South Dakota | Ziebach | 46137 | 526 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-02-17 04:20:56 | Ziebach, South Dakota, US | |
3674566 | 3674566 | 2022-02-15 | US | South Dakota | Ziebach | 46137 | 526 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-02-16 04:21:10 | Ziebach, South Dakota, US | |
2644667 | 2644667 | 2022-02-14 | US | South Dakota | Ziebach | 46137 | 526 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-02-15 04:21:09 | Ziebach, South Dakota, US | |
188984 | 188984 | 2022-02-13 | US | South Dakota | Ziebach | 46137 | 526 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-02-14 04:20:51 | Ziebach, South Dakota, US | |
318830 | 318830 | 2022-02-12 | US | South Dakota | Ziebach | 46137 | 526 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-02-13 04:21:00 | Ziebach, South Dakota, US | |
236156 | 236156 | 2022-02-11 | US | South Dakota | Ziebach | 46137 | 526 | 11 | 0 | 44.97881876 | -101.6654622 | 2022-02-12 04:21:06 | Ziebach, South Dakota, US | |
2013457 | 2013457 | 2022-02-06 | US | Georgia | Baker | 13007 | 526 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-07 04:21:05 | Baker, Georgia, US | |
1294786 | 1294786 | 2022-02-05 | US | Georgia | Baker | 13007 | 526 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-06 04:21:00 | Baker, Georgia, US | |
2328114 | 2328114 | 2022-02-04 | US | Georgia | Baker | 13007 | 526 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-02-05 04:21:05 | Baker, Georgia, US | |
1782262 | 1782262 | 2022-01-27 | US | South Dakota | Hand | 46059 | 526 | 8 | 0 | 44.54708407 | -99.00386459 | 2022-01-28 04:21:09 | Hand, South Dakota, US | |
1229999 | 1229999 | 2022-01-24 | US | North Dakota | Adams | 38001 | 526 | 9 | 0 | 46.09686891 | -102.5285397 | 2022-01-25 04:21:05 | Adams, North Dakota, US | |
2835940 | 2835940 | 2022-01-22 | US | Texas | Hardeman | 48197 | 526 | 14 | 0 | 34.28944521 | -99.74632408 | 2022-01-23 04:21:13 | Hardeman, Texas, US | |
1964169 | 1964169 | 2022-01-20 | US | Wyoming | Niobrara | 56027 | 526 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-21 04:21:09 | Niobrara, Wyoming, US | |
1962961 | 1962961 | 2022-01-20 | US | North Dakota | Griggs | 38039 | 526 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-01-21 04:21:09 | Griggs, North Dakota, US | |
3230064 | 3230064 | 2022-01-19 | US | Wyoming | Niobrara | 56027 | 526 | 8 | 0 | 43.05607708 | -104.47588959999999 | 2022-01-20 04:21:07 | Niobrara, Wyoming, US | |
1474548 | 1474548 | 2022-01-17 | US | North Dakota | Towner | 38095 | 526 | 11 | 0 | 48.68565745 | -99.24564265 | 2022-01-18 04:21:04 | Towner, North Dakota, 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]);