johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
449 rows where confirmed = 1490 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753562 | 2753562 | 2022-12-29 | US | Colorado | Saguache | 8109 | 1490 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-30 04:21:04 | Saguache, Colorado, US | |
1074568 | 1074568 | 2022-12-28 | US | Colorado | Saguache | 8109 | 1490 | 12 | 0 | 38.08054629 | -106.282466 | 2022-12-29 04:21:01 | Saguache, Colorado, US | |
309133 | 309133 | 2022-12-13 | US | Iowa | Taylor | 19173 | 1490 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-14 04:21:04 | Taylor, Iowa, US | |
1150194 | 1150194 | 2022-12-12 | US | Iowa | Taylor | 19173 | 1490 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-13 04:21:01 | Taylor, Iowa, US | |
870048 | 870048 | 2022-12-11 | US | Iowa | Taylor | 19173 | 1490 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-12 04:21:01 | Taylor, Iowa, US | |
869850 | 869850 | 2022-12-11 | US | Illinois | Scott | 17171 | 1490 | 14 | 0 | 39.6429169 | -90.47814431 | 2022-12-12 04:21:01 | Scott, Illinois, US | |
258578 | 258578 | 2022-12-10 | US | Iowa | Taylor | 19173 | 1490 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-11 04:20:50 | Taylor, Iowa, US | |
258380 | 258380 | 2022-12-10 | US | Illinois | Scott | 17171 | 1490 | 14 | 0 | 39.6429169 | -90.47814431 | 2022-12-11 04:20:50 | Scott, Illinois, US | |
3937292 | 3937292 | 2022-12-09 | US | Iowa | Taylor | 19173 | 1490 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-10 04:21:02 | Taylor, Iowa, US | |
3937094 | 3937094 | 2022-12-09 | US | Illinois | Scott | 17171 | 1490 | 14 | 0 | 39.6429169 | -90.47814431 | 2022-12-10 04:21:02 | Scott, Illinois, US | |
3378624 | 3378624 | 2022-12-08 | US | Iowa | Taylor | 19173 | 1490 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-09 04:21:05 | Taylor, Iowa, US | |
1985895 | 1985895 | 2022-12-07 | US | Iowa | Taylor | 19173 | 1490 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-08 04:21:07 | Taylor, Iowa, US | |
1755109 | 1755109 | 2022-11-18 | China | Tibet | 1490 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-19 04:21:14 | Tibet, China | |||
482979 | 482979 | 2022-11-08 | US | Virginia | Norton | 51720 | 1490 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-11-09 04:21:22 | Norton, Virginia, US | |
2161945 | 2161945 | 2022-10-16 | US | North Dakota | McHenry | 38049 | 1490 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-10-17 04:20:31 | McHenry, North Dakota, US | |
518142 | 518142 | 2022-10-15 | US | North Dakota | McHenry | 38049 | 1490 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-10-16 04:22:39 | McHenry, North Dakota, US | |
2035199 | 2035199 | 2022-10-14 | US | North Dakota | McHenry | 38049 | 1490 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-10-15 04:22:00 | McHenry, North Dakota, US | |
396061 | 396061 | 2022-10-07 | China | Hunan | 1490 | 4 | 0 | 27.6104 | 111.7088 | 2022-10-08 04:22:56 | Hunan, China | |||
1977583 | 1977583 | 2022-09-25 | US | Illinois | Alexander | 17003 | 1490 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-09-26 04:20:52 | Alexander, Illinois, US | |
2650750 | 2650750 | 2022-09-24 | US | Illinois | Alexander | 17003 | 1490 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-09-25 04:23:31 | Alexander, Illinois, US | |
385190 | 385190 | 2022-09-23 | US | Illinois | Alexander | 17003 | 1490 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-09-24 04:21:40 | Alexander, Illinois, US | |
3375791 | 3375791 | 2022-09-17 | US | North Dakota | Sioux | 38085 | 1490 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-09-18 04:22:50 | Sioux, North Dakota, US | |
1251660 | 1251660 | 2022-08-23 | US | Georgia | Wheeler | 13309 | 1490 | 39 | 0 | 32.12009104 | -82.72574721 | 2022-08-24 04:20:46 | Wheeler, Georgia, US | |
2853764 | 2853764 | 2022-08-22 | US | Georgia | Wheeler | 13309 | 1490 | 39 | 0 | 32.12009104 | -82.72574721 | 2022-08-23 04:20:56 | Wheeler, Georgia, US | |
2403736 | 2403736 | 2022-08-21 | US | Georgia | Wheeler | 13309 | 1490 | 39 | 0 | 32.12009104 | -82.72574721 | 2022-08-22 04:20:38 | Wheeler, Georgia, US | |
3798814 | 3798814 | 2022-08-20 | US | Georgia | Wheeler | 13309 | 1490 | 39 | 0 | 32.12009104 | -82.72574721 | 2022-08-21 04:20:44 | Wheeler, Georgia, US | |
2364400 | 2364400 | 2022-08-19 | US | Georgia | Wheeler | 13309 | 1490 | 39 | 0 | 32.12009104 | -82.72574721 | 2022-08-20 04:21:01 | Wheeler, Georgia, US | |
1162071 | 1162071 | 2022-08-18 | US | Georgia | Wheeler | 13309 | 1490 | 39 | 0 | 32.12009104 | -82.72574721 | 2022-08-19 04:20:54 | Wheeler, Georgia, US | |
3951395 | 3951395 | 2022-08-17 | US | Georgia | Wheeler | 13309 | 1490 | 39 | 0 | 32.12009104 | -82.72574721 | 2022-08-18 04:21:11 | Wheeler, Georgia, US | |
903342 | 903342 | 2022-07-22 | US | Texas | Mills | 48333 | 1490 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-07-23 04:20:53 | Mills, Texas, US | |
673478 | 673478 | 2022-07-21 | US | Texas | Mills | 48333 | 1490 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-07-22 04:21:15 | Mills, Texas, US | |
1610809 | 1610809 | 2022-07-20 | US | Oklahoma | Cotton | 40033 | 1490 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-07-21 04:21:10 | Cotton, Oklahoma, US | |
961442 | 961442 | 2022-07-19 | US | Oklahoma | Cotton | 40033 | 1490 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-07-20 04:20:59 | Cotton, Oklahoma, US | |
3212829 | 3212829 | 2022-07-18 | US | Oklahoma | Cotton | 40033 | 1490 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-07-19 04:20:58 | Cotton, Oklahoma, US | |
3408004 | 3408004 | 2022-07-17 | US | Oklahoma | Cotton | 40033 | 1490 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-07-18 04:20:59 | Cotton, Oklahoma, US | |
2154204 | 2154204 | 2022-07-16 | US | Oklahoma | Cotton | 40033 | 1490 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-07-17 04:21:15 | Cotton, Oklahoma, US | |
2421437 | 2421437 | 2022-07-15 | US | Oklahoma | Cotton | 40033 | 1490 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-07-16 04:21:05 | Cotton, Oklahoma, US | |
3431512 | 3431512 | 2022-07-14 | US | Oklahoma | Cotton | 40033 | 1490 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-07-15 04:20:53 | Cotton, Oklahoma, US | |
2744338 | 2744338 | 2022-07-07 | US | Virginia | Covington | 51580 | 1490 | 28 | 0 | 37.7824656 | -79.98631446 | 2022-07-08 04:20:56 | Covington, Virginia, US | |
3967506 | 3967506 | 2022-07-05 | US | Idaho | Power | 16077 | 1490 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-06 04:20:58 | Power, Idaho, US | |
3079017 | 3079017 | 2022-07-04 | US | Idaho | Power | 16077 | 1490 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-05 04:20:45 | Power, Idaho, US | |
1768299 | 1768299 | 2022-07-03 | US | Idaho | Power | 16077 | 1490 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-04 04:20:54 | Power, Idaho, US | |
3366285 | 3366285 | 2022-07-02 | US | Idaho | Power | 16077 | 1490 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-03 04:20:59 | Power, Idaho, US | |
594614 | 594614 | 2022-07-01 | US | Idaho | Power | 16077 | 1490 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-02 04:21:16 | Power, Idaho, US | |
1651819 | 1651819 | 2022-06-23 | US | Washington | Ferry | 53019 | 1490 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-06-24 04:20:58 | Ferry, Washington, US | |
1649502 | 1649502 | 2022-06-23 | US | Indiana | Ohio | 18115 | 1490 | 19 | 0 | 38.955305 | -84.96515993 | 2022-06-24 04:20:58 | Ohio, Indiana, US | |
2191054 | 2191054 | 2022-06-22 | US | Washington | Ferry | 53019 | 1490 | 29 | 0 | 48.4711431 | -118.5154041 | 2022-06-23 04:20:55 | Ferry, Washington, US | |
2188737 | 2188737 | 2022-06-22 | US | Indiana | Ohio | 18115 | 1490 | 19 | 0 | 38.955305 | -84.96515993 | 2022-06-23 04:20:55 | Ohio, Indiana, US | |
1766852 | 1766852 | 2022-06-20 | US | West Virginia | Wirt | 54105 | 1490 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-21 04:20:56 | Wirt, West Virginia, US | |
3273038 | 3273038 | 2022-06-19 | US | West Virginia | Wirt | 54105 | 1490 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-20 04:21:01 | Wirt, West Virginia, US | |
3400950 | 3400950 | 2022-06-18 | US | West Virginia | Wirt | 54105 | 1490 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-19 04:20:51 | Wirt, West Virginia, US | |
2314827 | 2314827 | 2022-06-17 | US | West Virginia | Wirt | 54105 | 1490 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-18 04:21:10 | Wirt, West Virginia, US | |
562331 | 562331 | 2022-06-16 | US | West Virginia | Wirt | 54105 | 1490 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-06-17 04:20:56 | Wirt, West Virginia, US | |
948529 | 948529 | 2022-06-14 | US | Michigan | Oscoda | 26135 | 1490 | 56 | 0 | 44.68192279 | -84.12939244 | 2022-06-15 04:20:54 | Oscoda, Michigan, US | |
947294 | 947294 | 2022-06-14 | US | Alaska | Yukon-Koyukuk | 2290 | 1490 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-15 04:20:54 | Yukon-Koyukuk, Alaska, US | |
2980937 | 2980937 | 2022-06-13 | US | Michigan | Oscoda | 26135 | 1490 | 56 | 0 | 44.68192279 | -84.12939244 | 2022-06-14 04:20:52 | Oscoda, Michigan, US | |
2979702 | 2979702 | 2022-06-13 | US | Alaska | Yukon-Koyukuk | 2290 | 1490 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-14 04:20:52 | Yukon-Koyukuk, Alaska, US | |
2237063 | 2237063 | 2022-06-12 | US | Michigan | Oscoda | 26135 | 1490 | 56 | 0 | 44.68192279 | -84.12939244 | 2022-06-13 04:21:14 | Oscoda, Michigan, US | |
2235828 | 2235828 | 2022-06-12 | US | Alaska | Yukon-Koyukuk | 2290 | 1490 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-13 04:21:14 | Yukon-Koyukuk, Alaska, US | |
3143261 | 3143261 | 2022-06-11 | US | Michigan | Oscoda | 26135 | 1490 | 56 | 0 | 44.68192279 | -84.12939244 | 2022-06-12 04:20:53 | Oscoda, Michigan, US | |
3142209 | 3142209 | 2022-06-11 | US | Colorado | Huerfano | 8055 | 1490 | 35 | 0 | 37.68473101 | -104.9612585 | 2022-06-12 04:20:53 | Huerfano, Colorado, US | |
3142026 | 3142026 | 2022-06-11 | US | Alaska | Yukon-Koyukuk | 2290 | 1490 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-12 04:20:53 | Yukon-Koyukuk, Alaska, US | |
1946177 | 1946177 | 2022-06-10 | US | Michigan | Oscoda | 26135 | 1490 | 56 | 0 | 44.68192279 | -84.12939244 | 2022-06-11 04:21:01 | Oscoda, Michigan, US | |
1944942 | 1944942 | 2022-06-10 | US | Alaska | Yukon-Koyukuk | 2290 | 1490 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-11 04:21:01 | Yukon-Koyukuk, Alaska, US | |
3159316 | 3159316 | 2022-06-09 | US | Michigan | Oscoda | 26135 | 1490 | 56 | 0 | 44.68192279 | -84.12939244 | 2022-06-10 04:20:55 | Oscoda, Michigan, US | |
3158081 | 3158081 | 2022-06-09 | US | Alaska | Yukon-Koyukuk | 2290 | 1490 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-10 04:20:55 | Yukon-Koyukuk, Alaska, US | |
1422783 | 1422783 | 2022-06-08 | US | Michigan | Oscoda | 26135 | 1490 | 56 | 0 | 44.68192279 | -84.12939244 | 2022-06-09 04:20:54 | Oscoda, Michigan, US | |
1421548 | 1421548 | 2022-06-08 | US | Alaska | Yukon-Koyukuk | 2290 | 1490 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-09 04:20:54 | Yukon-Koyukuk, Alaska, US | |
971512 | 971512 | 2022-06-01 | US | California | Trinity | 6105 | 1490 | 20 | 0 | 40.6491767 | -123.114713 | 2022-06-02 05:20:39 | Trinity, California, US | |
229819 | 229819 | 2022-05-31 | US | California | Trinity | 6105 | 1490 | 20 | 0 | 40.6491767 | -123.114713 | 2022-06-01 04:20:55 | Trinity, California, US | |
3186584 | 3186584 | 2022-05-30 | US | California | Trinity | 6105 | 1490 | 20 | 0 | 40.6491767 | -123.114713 | 2022-05-31 04:20:51 | Trinity, California, US | |
3596579 | 3596579 | 2022-05-23 | US | Wisconsin | Iron | 55051 | 1490 | 47 | 0 | 46.26302338 | -90.24295041 | 2022-05-24 04:20:57 | Iron, Wisconsin, US | |
1113127 | 1113127 | 2022-05-21 | US | Wisconsin | Iron | 55051 | 1490 | 47 | 0 | 46.26302338 | -90.24295041 | 2022-05-22 04:20:52 | Iron, Wisconsin, US | |
1172751 | 1172751 | 2022-05-20 | US | Wisconsin | Iron | 55051 | 1490 | 47 | 0 | 46.26302338 | -90.24295041 | 2022-05-21 04:20:58 | Iron, Wisconsin, US | |
3583574 | 3583574 | 2022-05-17 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-18 04:20:50 | Caribou, Idaho, US | |
1504531 | 1504531 | 2022-05-16 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-17 04:20:59 | Caribou, Idaho, US | |
2084890 | 2084890 | 2022-05-15 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-16 04:20:47 | Caribou, Idaho, US | |
3355600 | 3355600 | 2022-05-14 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-15 04:20:53 | Caribou, Idaho, US | |
659245 | 659245 | 2022-05-13 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-14 04:20:48 | Caribou, Idaho, US | |
2534328 | 2534328 | 2022-05-12 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-13 04:20:51 | Caribou, Idaho, US | |
3445774 | 3445774 | 2022-05-11 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-12 04:20:54 | Caribou, Idaho, US | |
3536391 | 3536391 | 2022-05-10 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-11 04:20:48 | Caribou, Idaho, US | |
222926 | 222926 | 2022-05-09 | US | Idaho | Caribou | 16029 | 1490 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-10 04:20:50 | Caribou, Idaho, US | |
2333776 | 2333776 | 2022-05-08 | US | North Dakota | Dickey | 38021 | 1490 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-05-09 04:20:54 | Dickey, North Dakota, US | |
2333196 | 2333196 | 2022-05-08 | US | Mississippi | Jefferson | 28063 | 1490 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-09 04:20:54 | Jefferson, Mississippi, US | |
362738 | 362738 | 2022-05-07 | US | North Dakota | Dickey | 38021 | 1490 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-05-08 04:20:49 | Dickey, North Dakota, US | |
362158 | 362158 | 2022-05-07 | US | Mississippi | Jefferson | 28063 | 1490 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-08 04:20:49 | Jefferson, Mississippi, US | |
1400089 | 1400089 | 2022-05-06 | US | North Dakota | Dickey | 38021 | 1490 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-05-07 04:21:09 | Dickey, North Dakota, US | |
1399509 | 1399509 | 2022-05-06 | US | Mississippi | Jefferson | 28063 | 1490 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-07 04:21:09 | Jefferson, Mississippi, US | |
2600444 | 2600444 | 2022-05-05 | US | North Dakota | Dickey | 38021 | 1490 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-05-06 04:21:00 | Dickey, North Dakota, US | |
2599864 | 2599864 | 2022-05-05 | US | Mississippi | Jefferson | 28063 | 1490 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-06 04:21:00 | Jefferson, Mississippi, US | |
3267313 | 3267313 | 2022-05-04 | US | Mississippi | Jefferson | 28063 | 1490 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-05 04:20:55 | Jefferson, Mississippi, US | |
1573952 | 1573952 | 2022-05-03 | US | Mississippi | Jefferson | 28063 | 1490 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-04 04:20:59 | Jefferson, Mississippi, US | |
465212 | 465212 | 2022-05-02 | US | Mississippi | Jefferson | 28063 | 1490 | 37 | 0 | 31.73397872 | -91.03764977 | 2022-05-03 04:21:00 | Jefferson, Mississippi, US | |
2309171 | 2309171 | 2022-04-20 | US | Missouri | Carter | 29035 | 1490 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-21 04:20:46 | Carter, Missouri, US | |
2253310 | 2253310 | 2022-04-19 | US | Missouri | Carter | 29035 | 1490 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-20 04:20:45 | Carter, Missouri, US | |
1847860 | 1847860 | 2022-04-18 | US | Missouri | Carter | 29035 | 1490 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-19 04:21:00 | Carter, Missouri, US | |
3418804 | 3418804 | 2022-04-17 | US | Missouri | Carter | 29035 | 1490 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-18 04:21:12 | Carter, Missouri, US | |
305753 | 305753 | 2022-04-16 | US | Missouri | Carter | 29035 | 1490 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-17 04:20:59 | Carter, Missouri, US | |
2671698 | 2671698 | 2022-04-15 | US | Missouri | Carter | 29035 | 1490 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-16 04:20:48 | Carter, Missouri, 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]);