johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
430 rows where confirmed = 1485 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
454152 | 454152 | 2022-12-21 | US | Puerto Rico | Maricao | 72093 | 1485 | 0 | 0 | 18.171795 | -66.942126 | 2022-12-22 04:20:56 | Maricao, Puerto Rico, US | |
1628964 | 1628964 | 2022-12-18 | US | Colorado | Saguache | 8109 | 1485 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-19 04:21:03 | Saguache, Colorado, US | |
504343 | 504343 | 2022-12-17 | US | Colorado | Saguache | 8109 | 1485 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-18 04:21:03 | Saguache, Colorado, US | |
3324915 | 3324915 | 2022-12-16 | US | Colorado | Saguache | 8109 | 1485 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-17 04:21:04 | Saguache, Colorado, US | |
1150937 | 1150937 | 2022-12-12 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-11 23:21:04 | Broadwater, Montana, US | |
870791 | 870791 | 2022-12-11 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-11 23:21:04 | Broadwater, Montana, US | |
259321 | 259321 | 2022-12-10 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-11 04:20:50 | Broadwater, Montana, US | |
3938035 | 3938035 | 2022-12-09 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-10 04:21:02 | Broadwater, Montana, US | |
3379367 | 3379367 | 2022-12-08 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-09 04:21:05 | Broadwater, Montana, US | |
1986638 | 1986638 | 2022-12-07 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-08 04:21:07 | Broadwater, Montana, US | |
3716161 | 3716161 | 2022-12-06 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-07 04:20:58 | Broadwater, Montana, US | |
2416866 | 2416866 | 2022-12-05 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-06 04:21:03 | Broadwater, Montana, US | |
720474 | 720474 | 2022-12-04 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-05 04:20:58 | Broadwater, Montana, US | |
2818763 | 2818763 | 2022-12-03 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-04 04:20:56 | Broadwater, Montana, US | |
835619 | 835619 | 2022-12-02 | US | Montana | Broadwater | 30007 | 1485 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-12-03 04:21:02 | Broadwater, Montana, US | |
3555038 | 3555038 | 2022-11-27 | US | Virginia | Norton | 51720 | 1485 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-11-28 04:21:02 | Norton, Virginia, US | |
2103518 | 2103518 | 2022-11-26 | US | Virginia | Norton | 51720 | 1485 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-11-27 04:21:05 | Norton, Virginia, US | |
491009 | 491009 | 2022-11-25 | US | Virginia | Norton | 51720 | 1485 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-11-26 04:21:11 | Norton, Virginia, US | |
1621507 | 1621507 | 2022-11-22 | US | Iowa | Osceola | 19143 | 1485 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-11-23 04:21:06 | Osceola, Iowa, US | |
3461395 | 3461395 | 2022-11-21 | US | Iowa | Osceola | 19143 | 1485 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-11-22 04:20:47 | Osceola, Iowa, US | |
1641580 | 1641580 | 2022-11-20 | US | Iowa | Osceola | 19143 | 1485 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-11-21 04:21:05 | Osceola, Iowa, US | |
2065137 | 2065137 | 2022-11-19 | US | Iowa | Osceola | 19143 | 1485 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-11-20 04:21:08 | Osceola, Iowa, US | |
1756531 | 1756531 | 2022-11-18 | US | Iowa | Osceola | 19143 | 1485 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-11-19 04:21:14 | Osceola, Iowa, US | |
3027524 | 3027524 | 2022-11-17 | US | Iowa | Osceola | 19143 | 1485 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-11-18 04:21:15 | Osceola, Iowa, US | |
2487235 | 2487235 | 2022-11-16 | US | Iowa | Osceola | 19143 | 1485 | 22 | 0 | 43.37824276 | -95.62422844 | 2022-11-17 04:21:11 | Osceola, Iowa, US | |
2433495 | 2433495 | 2022-11-09 | US | Oklahoma | Greer | 40055 | 1485 | 42 | 0 | 34.93535801 | -99.5605612 | 2022-11-10 04:21:16 | Greer, Oklahoma, US | |
482151 | 482151 | 2022-11-08 | US | Oklahoma | Greer | 40055 | 1485 | 42 | 0 | 34.93535801 | -99.5605612 | 2022-11-09 04:21:22 | Greer, Oklahoma, US | |
2441301 | 2441301 | 2022-11-07 | US | Oklahoma | Greer | 40055 | 1485 | 42 | 0 | 34.93535801 | -99.5605612 | 2022-11-08 04:21:21 | Greer, Oklahoma, US | |
1052399 | 1052399 | 2022-11-06 | US | Oklahoma | Greer | 40055 | 1485 | 42 | 0 | 34.93535801 | -99.5605612 | 2022-11-07 04:21:26 | Greer, Oklahoma, US | |
620423 | 620423 | 2022-11-05 | US | Oklahoma | Greer | 40055 | 1485 | 42 | 0 | 34.93535801 | -99.5605612 | 2022-11-06 04:21:24 | Greer, Oklahoma, US | |
1024927 | 1024927 | 2022-11-04 | US | Oklahoma | Greer | 40055 | 1485 | 42 | 0 | 34.93535801 | -99.5605612 | 2022-11-05 04:21:52 | Greer, Oklahoma, US | |
433918 | 433918 | 2022-11-03 | US | Oklahoma | Greer | 40055 | 1485 | 42 | 0 | 34.93535801 | -99.5605612 | 2022-11-04 04:22:11 | Greer, Oklahoma, US | |
852166 | 852166 | 2022-11-02 | US | Oklahoma | Jefferson | 40067 | 1485 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-11-03 04:22:05 | Jefferson, Oklahoma, US | |
713017 | 713017 | 2022-11-01 | US | Oklahoma | Jefferson | 40067 | 1485 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-11-02 04:22:09 | Jefferson, Oklahoma, US | |
3287466 | 3287466 | 2022-10-31 | US | Oklahoma | Jefferson | 40067 | 1485 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-11-01 04:22:36 | Jefferson, Oklahoma, US | |
322499 | 322499 | 2022-10-30 | US | Oklahoma | Jefferson | 40067 | 1485 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-10-31 04:21:36 | Jefferson, Oklahoma, US | |
914775 | 914775 | 2022-10-29 | US | Oklahoma | Jefferson | 40067 | 1485 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-10-30 04:22:14 | Jefferson, Oklahoma, US | |
1369044 | 1369044 | 2022-10-28 | US | Oklahoma | Jefferson | 40067 | 1485 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-10-29 04:21:13 | Jefferson, Oklahoma, US | |
3040899 | 3040899 | 2022-10-27 | US | Oklahoma | Jefferson | 40067 | 1485 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-10-28 04:22:31 | Jefferson, Oklahoma, US | |
2529178 | 2529178 | 2022-10-06 | China | Hunan | 1485 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-07 04:23:08 | Hunan, China | |||
1814097 | 1814097 | 2022-10-05 | US | Virginia | Charles City | 51036 | 1485 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-10-06 04:21:22 | Charles City, Virginia, US | |
134071 | 134071 | 2022-10-04 | US | Virginia | Charles City | 51036 | 1485 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-10-05 04:23:06 | Charles City, Virginia, US | |
1489919 | 1489919 | 2022-07-26 | US | North Carolina | Hyde | 37095 | 1485 | 14 | 0 | 35.42017674 | -76.15180542 | 2022-07-27 04:21:04 | Hyde, North Carolina, US | |
2596365 | 2596365 | 2022-07-25 | US | North Carolina | Hyde | 37095 | 1485 | 14 | 0 | 35.42017674 | -76.15180542 | 2022-07-26 04:20:58 | Hyde, North Carolina, US | |
898480 | 898480 | 2022-07-24 | US | North Carolina | Hyde | 37095 | 1485 | 14 | 0 | 35.42017674 | -76.15180542 | 2022-07-25 04:20:51 | Hyde, North Carolina, US | |
93474 | 93474 | 2022-07-23 | US | North Carolina | Hyde | 37095 | 1485 | 14 | 0 | 35.42017674 | -76.15180542 | 2022-07-24 04:20:47 | Hyde, North Carolina, US | |
902496 | 902496 | 2022-07-22 | US | North Carolina | Hyde | 37095 | 1485 | 14 | 0 | 35.42017674 | -76.15180542 | 2022-07-23 04:20:53 | Hyde, North Carolina, US | |
672632 | 672632 | 2022-07-21 | US | North Carolina | Hyde | 37095 | 1485 | 14 | 0 | 35.42017674 | -76.15180542 | 2022-07-22 04:21:15 | Hyde, North Carolina, US | |
1610595 | 1610595 | 2022-07-20 | US | North Carolina | Hyde | 37095 | 1485 | 14 | 0 | 35.42017674 | -76.15180542 | 2022-07-21 04:21:10 | Hyde, North Carolina, US | |
1650275 | 1650275 | 2022-06-23 | US | Missouri | Dade | 29057 | 1485 | 43 | 0 | 37.431814 | -93.8503345 | 2022-06-24 04:20:58 | Dade, Missouri, US | |
2189510 | 2189510 | 2022-06-22 | US | Missouri | Dade | 29057 | 1485 | 43 | 0 | 37.431814 | -93.8503345 | 2022-06-23 04:20:55 | Dade, Missouri, US | |
167941 | 167941 | 2022-06-21 | US | Missouri | Dade | 29057 | 1485 | 43 | 0 | 37.431814 | -93.8503345 | 2022-06-22 04:20:54 | Dade, Missouri, US | |
1765224 | 1765224 | 2022-06-20 | US | Missouri | Dade | 29057 | 1485 | 43 | 0 | 37.431814 | -93.8503345 | 2022-06-21 04:20:56 | Dade, Missouri, US | |
3271410 | 3271410 | 2022-06-19 | US | Missouri | Dade | 29057 | 1485 | 43 | 0 | 37.431814 | -93.8503345 | 2022-06-20 04:21:01 | Dade, Missouri, US | |
3399322 | 3399322 | 2022-06-18 | US | Missouri | Dade | 29057 | 1485 | 43 | 0 | 37.431814 | -93.8503345 | 2022-06-19 04:20:51 | Dade, Missouri, US | |
2313199 | 2313199 | 2022-06-17 | US | Missouri | Dade | 29057 | 1485 | 43 | 0 | 37.431814 | -93.8503345 | 2022-06-18 04:21:10 | Dade, Missouri, US | |
2238908 | 2238908 | 2022-06-12 | US | West Virginia | Wirt | 54105 | 1485 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-13 04:21:14 | Wirt, West Virginia, US | |
3145106 | 3145106 | 2022-06-11 | US | West Virginia | Wirt | 54105 | 1485 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-12 04:20:53 | Wirt, West Virginia, US | |
1948022 | 1948022 | 2022-06-10 | US | West Virginia | Wirt | 54105 | 1485 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-11 04:21:01 | Wirt, West Virginia, US | |
3161161 | 3161161 | 2022-06-09 | US | West Virginia | Wirt | 54105 | 1485 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-10 04:20:55 | Wirt, West Virginia, US | |
1424628 | 1424628 | 2022-06-08 | US | West Virginia | Wirt | 54105 | 1485 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-09 04:20:54 | Wirt, West Virginia, US | |
3135607 | 3135607 | 2022-06-03 | US | Nebraska | Cedar | 31027 | 1485 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-06-04 04:20:58 | Cedar, Nebraska, US | |
3580682 | 3580682 | 2022-06-02 | US | Nebraska | Cedar | 31027 | 1485 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-06-03 04:20:58 | Cedar, Nebraska, US | |
972975 | 972975 | 2022-06-01 | US | Nebraska | Cedar | 31027 | 1485 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-06-02 05:20:39 | Cedar, Nebraska, US | |
231282 | 231282 | 2022-05-31 | US | Nebraska | Cedar | 31027 | 1485 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-06-01 04:20:55 | Cedar, Nebraska, US | |
230095 | 230095 | 2022-05-31 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-06-01 04:20:55 | Randolph, Georgia, US | |
3186860 | 3186860 | 2022-05-30 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-31 04:20:51 | Randolph, Georgia, US | |
3199009 | 3199009 | 2022-05-29 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-30 04:20:50 | Randolph, Georgia, US | |
2725887 | 2725887 | 2022-05-28 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-29 04:20:53 | Randolph, Georgia, US | |
1315068 | 1315068 | 2022-05-27 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-28 04:21:07 | Randolph, Georgia, US | |
1850860 | 1850860 | 2022-05-26 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-27 04:20:56 | Randolph, Georgia, US | |
2048736 | 2048736 | 2022-05-25 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-26 04:20:50 | Randolph, Georgia, US | |
3000174 | 3000174 | 2022-05-24 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-25 04:20:56 | Randolph, Georgia, US | |
3593895 | 3593895 | 2022-05-23 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-24 04:20:57 | Randolph, Georgia, US | |
622747 | 622747 | 2022-05-22 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-26 04:20:50 | Randolph, Georgia, US | |
1110443 | 1110443 | 2022-05-21 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-22 04:20:52 | Randolph, Georgia, US | |
1170067 | 1170067 | 2022-05-20 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-21 04:20:58 | Randolph, Georgia, US | |
3896830 | 3896830 | 2022-05-19 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-20 04:20:57 | Randolph, Georgia, US | |
1185614 | 1185614 | 2022-05-18 | US | Georgia | Randolph | 13243 | 1485 | 48 | 0 | 31.76622818 | -84.75732369 | 2022-05-19 04:20:54 | Randolph, Georgia, US | |
1507152 | 1507152 | 2022-05-16 | US | Wisconsin | Iron | 55051 | 1485 | 47 | 0 | 46.26302338 | -90.24295041 | 2022-05-17 04:20:59 | Iron, Wisconsin, US | |
3538222 | 3538222 | 2022-05-10 | US | Puerto Rico | Maunabo | 72095 | 1485 | 0 | 0 | 18.017889 | -65.922235 | 2022-05-11 04:20:48 | Maunabo, Puerto Rico, US | |
1697265 | 1697265 | 2022-04-28 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-29 04:20:59 | Caribou, Idaho, US | |
3852748 | 3852748 | 2022-04-27 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-28 04:20:47 | Caribou, Idaho, US | |
1327178 | 1327178 | 2022-04-26 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-27 04:20:52 | Caribou, Idaho, US | |
3723132 | 3723132 | 2022-04-25 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-26 04:20:51 | Caribou, Idaho, US | |
2029700 | 2029700 | 2022-04-24 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-25 04:20:56 | Caribou, Idaho, US | |
747275 | 747275 | 2022-04-23 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-24 04:20:56 | Caribou, Idaho, US | |
3437760 | 3437760 | 2022-04-22 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-23 04:20:50 | Caribou, Idaho, US | |
2893345 | 2893345 | 2022-04-21 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-22 04:20:45 | Caribou, Idaho, US | |
2308217 | 2308217 | 2022-04-20 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-21 04:20:46 | Caribou, Idaho, US | |
2307466 | 2307466 | 2022-04-20 | Peru | Unknown | 1485 | 50 | 0 | 2022-04-21 04:20:46 | Unknown, Peru | |||||
2252356 | 2252356 | 2022-04-19 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-20 04:20:45 | Caribou, Idaho, US | |
1846906 | 1846906 | 2022-04-18 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-19 04:21:00 | Caribou, Idaho, US | |
3419315 | 3419315 | 2022-04-17 | US | North Dakota | Dickey | 38021 | 1485 | 39 | 0 | 46.11017712 | -98.50490079999999 | 2022-04-18 04:21:12 | Dickey, North Dakota, US | |
3417850 | 3417850 | 2022-04-17 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-18 04:21:12 | Caribou, Idaho, US | |
306264 | 306264 | 2022-04-16 | US | North Dakota | Dickey | 38021 | 1485 | 39 | 0 | 46.11017712 | -98.50490079999999 | 2022-04-17 04:20:59 | Dickey, North Dakota, US | |
304799 | 304799 | 2022-04-16 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-17 04:20:59 | Caribou, Idaho, US | |
2672209 | 2672209 | 2022-04-15 | US | North Dakota | Dickey | 38021 | 1485 | 39 | 0 | 46.11017712 | -98.50490079999999 | 2022-04-16 04:20:48 | Dickey, North Dakota, US | |
2670744 | 2670744 | 2022-04-15 | US | Idaho | Caribou | 16029 | 1485 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-04-16 04:20:48 | Caribou, Idaho, US | |
1225994 | 1225994 | 2022-04-14 | US | North Dakota | Dickey | 38021 | 1485 | 39 | 0 | 46.11017712 | -98.50490079999999 | 2022-04-15 04:20:57 | Dickey, 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]);