johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
316 rows where confirmed = 2040 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1239458 | 1239458 | 2022-11-28 | China | Hunan | 2040 | 4 | 0 | 27.6104 | 111.7088 | 2022-11-29 04:21:05 | Hunan, China | |||
1050827 | 1050827 | 2022-11-06 | US | Illinois | Edwards | 17047 | 2040 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-11-07 04:21:26 | Edwards, Illinois, US | |
618851 | 618851 | 2022-11-05 | US | Illinois | Edwards | 17047 | 2040 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-11-06 04:21:24 | Edwards, Illinois, US | |
1023355 | 1023355 | 2022-11-04 | US | Illinois | Edwards | 17047 | 2040 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-11-05 04:21:52 | Edwards, Illinois, US | |
431159 | 431159 | 2022-11-03 | China | Liaoning | 2040 | 2 | 0 | 41.2956 | 122.6085 | 2022-11-04 04:22:11 | Liaoning, China | |||
3280099 | 3280099 | 2022-10-23 | US | Texas | Stephens | 48429 | 2040 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-10-24 04:22:29 | Stephens, Texas, US | |
2271137 | 2271137 | 2022-10-22 | US | Texas | Stephens | 48429 | 2040 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-10-23 04:22:46 | Stephens, Texas, US | |
1595437 | 1595437 | 2022-10-21 | US | Texas | Stephens | 48429 | 2040 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-10-22 04:22:53 | Stephens, Texas, US | |
1880413 | 1880413 | 2022-08-28 | US | Virginia | Williamsburg | 51830 | 2040 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-08-29 04:21:06 | Williamsburg, Virginia, US | |
2099540 | 2099540 | 2022-08-27 | US | Virginia | Williamsburg | 51830 | 2040 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-08-28 04:21:02 | Williamsburg, Virginia, US | |
1535355 | 1535355 | 2022-08-26 | US | Virginia | Williamsburg | 51830 | 2040 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-08-27 04:20:57 | Williamsburg, Virginia, US | |
2366502 | 2366502 | 2022-08-19 | US | Tennessee | Van Buren | 47175 | 2040 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-20 04:21:01 | Van Buren, Tennessee, US | |
994060 | 994060 | 2022-08-16 | US | Texas | Crosby | 48107 | 2040 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-08-17 04:20:59 | Crosby, Texas, US | |
3650892 | 3650892 | 2022-08-14 | US | Virginia | Bland | 51021 | 2040 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-15 04:20:59 | Bland, Virginia, US | |
1971898 | 1971898 | 2022-08-13 | US | Virginia | Bland | 51021 | 2040 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-14 04:20:55 | Bland, Virginia, US | |
2891707 | 2891707 | 2022-08-12 | US | Virginia | Bland | 51021 | 2040 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-13 04:20:52 | Bland, Virginia, US | |
3875039 | 3875039 | 2022-07-31 | US | West Virginia | Calhoun | 54013 | 2040 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-08-01 04:21:03 | Calhoun, West Virginia, US | |
3874926 | 3874926 | 2022-07-31 | US | Virginia | Lancaster | 51103 | 2040 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-08-01 04:21:03 | Lancaster, Virginia, US | |
677793 | 677793 | 2022-07-30 | US | West Virginia | Calhoun | 54013 | 2040 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-07-31 04:21:02 | Calhoun, West Virginia, US | |
677680 | 677680 | 2022-07-30 | US | Virginia | Lancaster | 51103 | 2040 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-07-31 04:21:02 | Lancaster, Virginia, US | |
1786992 | 1786992 | 2022-07-29 | US | West Virginia | Calhoun | 54013 | 2040 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-07-30 04:20:42 | Calhoun, West Virginia, US | |
1786879 | 1786879 | 2022-07-29 | US | Virginia | Lancaster | 51103 | 2040 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-07-30 04:20:42 | Lancaster, Virginia, US | |
3210804 | 3210804 | 2022-07-18 | US | Arkansas | Prairie | 5117 | 2040 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-07-19 04:20:58 | Prairie, Arkansas, US | |
3113052 | 3113052 | 2022-07-13 | US | Wisconsin | Menominee | 55078 | 2040 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-14 04:20:57 | Menominee, Wisconsin, US | |
3111874 | 3111874 | 2022-07-13 | US | North Dakota | Benson | 38005 | 2040 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-07-14 04:20:57 | Benson, North Dakota, US | |
633475 | 633475 | 2022-07-12 | US | Wisconsin | Menominee | 55078 | 2040 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-07-13 04:20:58 | Menominee, Wisconsin, US | |
1766834 | 1766834 | 2022-06-20 | US | West Virginia | Pendleton | 54071 | 2040 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-06-21 04:20:56 | Pendleton, West Virginia, US | |
3273020 | 3273020 | 2022-06-19 | US | West Virginia | Pendleton | 54071 | 2040 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-06-20 04:21:01 | Pendleton, West Virginia, US | |
3400932 | 3400932 | 2022-06-18 | US | West Virginia | Pendleton | 54071 | 2040 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-06-19 04:20:51 | Pendleton, West Virginia, US | |
2314809 | 2314809 | 2022-06-17 | US | West Virginia | Pendleton | 54071 | 2040 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-06-18 04:21:10 | Pendleton, West Virginia, US | |
562313 | 562313 | 2022-06-16 | US | West Virginia | Pendleton | 54071 | 2040 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-06-17 04:20:56 | Pendleton, West Virginia, US | |
949582 | 949582 | 2022-06-14 | US | Puerto Rico | Ceiba | 72037 | 2040 | 0 | 0 | 18.251818 | -65.666416 | 2022-06-15 04:20:54 | Ceiba, Puerto Rico, US | |
2981990 | 2981990 | 2022-06-13 | US | Puerto Rico | Ceiba | 72037 | 2040 | 0 | 0 | 18.251818 | -65.666416 | 2022-06-14 04:20:52 | Ceiba, Puerto Rico, US | |
2979055 | 2979055 | 2022-06-13 | China | Inner Mongolia | 2040 | 1 | 0 | 44.0935 | 113.9448 | 2022-06-14 04:20:52 | Inner Mongolia, China | |||
1424677 | 1424677 | 2022-06-08 | US | Wisconsin | Pepin | 55091 | 2040 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-06-09 04:20:54 | Pepin, Wisconsin, US | |
232744 | 232744 | 2022-05-31 | US | West Virginia | Tucker | 54093 | 2040 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-06-01 04:20:55 | Tucker, West Virginia, US | |
1316619 | 1316619 | 2022-05-27 | US | North Dakota | Pembina | 38067 | 2040 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-05-28 04:21:07 | Pembina, North Dakota, US | |
3002169 | 3002169 | 2022-05-24 | US | South Dakota | Custer | 46033 | 2040 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-05-25 04:20:56 | Custer, South Dakota, US | |
3595890 | 3595890 | 2022-05-23 | US | South Dakota | Custer | 46033 | 2040 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-05-24 04:20:57 | Custer, South Dakota, US | |
1112438 | 1112438 | 2022-05-21 | US | South Dakota | Custer | 46033 | 2040 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-05-22 04:20:52 | Custer, South Dakota, US | |
1172062 | 1172062 | 2022-05-20 | US | South Dakota | Custer | 46033 | 2040 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-05-21 04:20:58 | Custer, South Dakota, US | |
3898825 | 3898825 | 2022-05-19 | US | South Dakota | Custer | 46033 | 2040 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-05-20 04:20:57 | Custer, South Dakota, US | |
1187609 | 1187609 | 2022-05-18 | US | South Dakota | Custer | 46033 | 2040 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-05-19 04:20:54 | Custer, South Dakota, US | |
2333127 | 2333127 | 2022-05-08 | US | Minnesota | Murray | 27101 | 2040 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-05-09 04:20:54 | Murray, Minnesota, US | |
362089 | 362089 | 2022-05-07 | US | Minnesota | Murray | 27101 | 2040 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-05-08 04:20:49 | Murray, Minnesota, US | |
1399440 | 1399440 | 2022-05-06 | US | Minnesota | Murray | 27101 | 2040 | 16 | 0 | 44.02216709 | -95.76328482 | 2022-05-07 04:21:09 | Murray, Minnesota, US | |
1575008 | 1575008 | 2022-05-03 | US | South Dakota | Grant | 46051 | 2040 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-04 04:20:59 | Grant, South Dakota, US | |
1573368 | 1573368 | 2022-05-03 | US | Iowa | Palo Alto | 19147 | 2040 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-05-04 04:20:59 | Palo Alto, Iowa, US | |
466268 | 466268 | 2022-05-02 | US | South Dakota | Grant | 46051 | 2040 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-03 04:21:00 | Grant, South Dakota, US | |
464628 | 464628 | 2022-05-02 | US | Iowa | Palo Alto | 19147 | 2040 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-05-03 04:21:00 | Palo Alto, Iowa, US | |
3918907 | 3918907 | 2022-05-01 | US | South Dakota | Grant | 46051 | 2040 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-02 04:21:10 | Grant, South Dakota, US | |
3917267 | 3917267 | 2022-05-01 | US | Iowa | Palo Alto | 19147 | 2040 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-05-02 04:21:10 | Palo Alto, Iowa, US | |
2843711 | 2843711 | 2022-04-30 | US | South Dakota | Grant | 46051 | 2040 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-05-01 04:20:57 | Grant, South Dakota, US | |
2842071 | 2842071 | 2022-04-30 | US | Iowa | Palo Alto | 19147 | 2040 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-05-01 04:20:57 | Palo Alto, Iowa, US | |
1160024 | 1160024 | 2022-04-29 | US | South Dakota | Grant | 46051 | 2040 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-04-30 04:21:05 | Grant, South Dakota, US | |
1158384 | 1158384 | 2022-04-29 | US | Iowa | Palo Alto | 19147 | 2040 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-04-30 04:21:05 | Palo Alto, Iowa, US | |
1699206 | 1699206 | 2022-04-28 | US | South Dakota | Grant | 46051 | 2040 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-04-29 04:20:59 | Grant, South Dakota, US | |
1697566 | 1697566 | 2022-04-28 | US | Iowa | Palo Alto | 19147 | 2040 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-04-29 04:20:59 | Palo Alto, Iowa, US | |
3854689 | 3854689 | 2022-04-27 | US | South Dakota | Grant | 46051 | 2040 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-04-28 04:20:47 | Grant, South Dakota, US | |
3853049 | 3853049 | 2022-04-27 | US | Iowa | Palo Alto | 19147 | 2040 | 38 | 0 | 43.08193849 | -94.67824621 | 2022-04-28 04:20:47 | Palo Alto, Iowa, US | |
2253041 | 2253041 | 2022-04-19 | US | Michigan | Baraga | 26013 | 2040 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-04-20 04:20:45 | Baraga, Michigan, US | |
1847591 | 1847591 | 2022-04-18 | US | Michigan | Baraga | 26013 | 2040 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-04-19 04:21:00 | Baraga, Michigan, US | |
3418535 | 3418535 | 2022-04-17 | US | Michigan | Baraga | 26013 | 2040 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-04-18 04:21:12 | Baraga, Michigan, US | |
305484 | 305484 | 2022-04-16 | US | Michigan | Baraga | 26013 | 2040 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-04-17 04:20:59 | Baraga, Michigan, US | |
2671429 | 2671429 | 2022-04-15 | US | Michigan | Baraga | 26013 | 2040 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-04-16 04:20:48 | Baraga, Michigan, US | |
1225214 | 1225214 | 2022-04-14 | US | Michigan | Baraga | 26013 | 2040 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-04-15 04:20:57 | Baraga, Michigan, US | |
2444372 | 2444372 | 2022-04-13 | US | Michigan | Baraga | 26013 | 2040 | 53 | 0 | 46.6720582 | -88.36363591 | 2022-04-13 23:21:06 | Baraga, Michigan, US | |
3868748 | 3868748 | 2022-04-05 | US | Iowa | Howard | 19089 | 2040 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-04-06 04:20:49 | Howard, Iowa, US | |
2750090 | 2750090 | 2022-04-04 | US | Iowa | Howard | 19089 | 2040 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-04-05 04:20:48 | Howard, Iowa, US | |
3731436 | 3731436 | 2022-04-03 | US | Iowa | Howard | 19089 | 2040 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-04-04 04:20:51 | Howard, Iowa, US | |
500871 | 500871 | 2022-04-02 | US | Iowa | Howard | 19089 | 2040 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-04-03 04:20:48 | Howard, Iowa, US | |
3351856 | 3351856 | 2022-04-01 | US | Iowa | Howard | 19089 | 2040 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-04-02 04:20:47 | Howard, Iowa, US | |
1541161 | 1541161 | 2022-03-31 | US | Iowa | Howard | 19089 | 2040 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-04-01 04:20:28 | Howard, Iowa, US | |
2479174 | 2479174 | 2022-03-30 | US | Iowa | Howard | 19089 | 2040 | 35 | 0 | 43.35671042 | -92.31702714 | 2022-03-31 04:20:56 | Howard, Iowa, US | |
1438572 | 1438572 | 2022-03-28 | US | Montana | Carbon | 30009 | 2040 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-03-29 04:20:46 | Carbon, Montana, US | |
878253 | 878253 | 2022-03-27 | US | Montana | Carbon | 30009 | 2040 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-03-28 04:20:33 | Carbon, Montana, US | |
2165536 | 2165536 | 2022-03-26 | US | Montana | Carbon | 30009 | 2040 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-03-27 04:20:47 | Carbon, Montana, US | |
1722472 | 1722472 | 2022-03-25 | US | Montana | Carbon | 30009 | 2040 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-03-26 04:20:23 | Carbon, Montana, US | |
2668847 | 2668847 | 2022-03-04 | US | Texas | Clay | 48077 | 2040 | 32 | 0 | 33.78686685 | -98.20771198 | 2022-03-05 04:21:10 | Clay, Texas, US | |
1647412 | 1647412 | 2022-03-03 | US | Texas | Clay | 48077 | 2040 | 32 | 0 | 33.78686685 | -98.20771198 | 2022-03-04 04:21:09 | Clay, Texas, US | |
2528415 | 2528415 | 2022-03-02 | US | Texas | Clay | 48077 | 2040 | 32 | 0 | 33.78686685 | -98.20771198 | 2022-03-03 04:21:01 | Clay, Texas, US | |
1995709 | 1995709 | 2022-03-01 | US | Texas | Clay | 48077 | 2040 | 31 | 0 | 33.78686685 | -98.20771198 | 2022-03-02 04:21:07 | Clay, Texas, US | |
945883 | 945883 | 2022-02-28 | US | Texas | Clay | 48077 | 2040 | 31 | 0 | 33.78686685 | -98.20771198 | 2022-03-01 04:21:09 | Clay, Texas, US | |
189549 | 189549 | 2022-02-13 | US | West Virginia | Doddridge | 54017 | 2040 | 16 | 0 | 39.27057157 | -80.70671527 | 2022-02-14 04:20:51 | Doddridge, West Virginia, US | |
1467175 | 1467175 | 2022-02-10 | US | Texas | Franklin | 48159 | 2040 | 37 | 0 | 33.17653242 | -95.21917243 | 2022-02-11 04:21:09 | Franklin, Texas, US | |
2013966 | 2013966 | 2022-02-06 | US | Kansas | Anderson | 20003 | 2040 | 24 | 0 | 38.21413251 | -95.29272815 | 2022-02-07 04:21:05 | Anderson, Kansas, US | |
1295295 | 1295295 | 2022-02-05 | US | Kansas | Anderson | 20003 | 2040 | 24 | 0 | 38.21413251 | -95.29272815 | 2022-02-06 04:21:00 | Anderson, Kansas, US | |
2330379 | 2330379 | 2022-02-04 | US | Texas | Archer | 48009 | 2040 | 25 | 0 | 33.61569967 | -98.68754589 | 2022-02-05 04:21:05 | Archer, Texas, US | |
2328623 | 2328623 | 2022-02-04 | US | Kansas | Anderson | 20003 | 2040 | 24 | 0 | 38.21413251 | -95.29272815 | 2022-02-05 04:21:05 | Anderson, Kansas, US | |
3303367 | 3303367 | 2022-01-30 | US | Texas | Live Oak | 48297 | 2040 | 40 | 0 | 28.35101362 | -98.1246786 | 2022-01-31 04:21:09 | Live Oak, Texas, US | |
3301996 | 3301996 | 2022-01-30 | US | Mississippi | Benton | 28009 | 2040 | 43 | 0 | 34.81681228 | -89.18945516 | 2022-01-31 04:21:09 | Benton, Mississippi, US | |
3063935 | 3063935 | 2022-01-29 | US | Missouri | Monroe | 29137 | 2040 | 38 | 0 | 39.49593978 | -92.00043978 | 2022-01-30 04:21:26 | Monroe, Missouri, US | |
3063787 | 3063787 | 2022-01-29 | US | Mississippi | Benton | 28009 | 2040 | 43 | 0 | 34.81681228 | -89.18945516 | 2022-01-30 04:21:26 | Benton, Mississippi, US | |
3811721 | 3811721 | 2022-01-28 | US | Mississippi | Benton | 28009 | 2040 | 43 | 0 | 34.81681228 | -89.18945516 | 2022-01-29 04:21:10 | Benton, Mississippi, US | |
2052789 | 2052789 | 2022-01-25 | US | Georgia | Wilkinson | 13319 | 2040 | 49 | 0 | 32.80291082 | -83.17140684 | 2022-01-26 04:21:07 | Wilkinson, Georgia, US | |
1142185 | 1142185 | 2022-01-23 | US | Kansas | Cloud | 20029 | 2040 | 34 | 0 | 39.48028352 | -97.64925343 | 2022-01-24 04:21:12 | Cloud, Kansas, US | |
2835502 | 2835502 | 2022-01-22 | US | Pennsylvania | Forest | 42053 | 2040 | 33 | 0 | 41.51095103 | -79.23229292 | 2022-01-23 04:21:13 | Forest, Pennsylvania, US | |
2834103 | 2834103 | 2022-01-22 | US | Kansas | Cloud | 20029 | 2040 | 34 | 0 | 39.48028352 | -97.64925343 | 2022-01-23 04:21:13 | Cloud, Kansas, US | |
3426221 | 3426221 | 2022-01-21 | US | Kansas | Cloud | 20029 | 2040 | 34 | 0 | 39.48028352 | -97.64925343 | 2022-01-22 04:21:13 | Cloud, Kansas, US | |
1472960 | 1472960 | 2022-01-17 | US | Georgia | McIntosh | 13191 | 2040 | 33 | 0 | 31.49683595 | -81.40163426 | 2022-01-18 04:21:04 | McIntosh, Georgia, 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]);