daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
121 rows where confirmed = 6117 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 29
- Missouri 16
- Arkansas 14
- Georgia 10
- Kentucky 9
- Indiana 8
- Iowa 7
- Michigan 5
- North Carolina 5
- Texas 5
- Virginia 5
- Alabama 4
- New York 4
- Nebraska 3
- Ohio 3
- Pennsylvania 3
- Puerto Rico 3
- Tennessee 3
- Maryland 2
- New Hampshire 2
- California 1
- Illinois 1
- Minnesota 1
- Mississippi 1
- Nevada 1
- New Jersey 1
- Oklahoma 1
- South Carolina 1
- Washington 1
- Wisconsin 1
country_or_region 1
- US · 121 ✖
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-19 | US | Missouri | Perry | 29157 | 6117 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-20 04:21:04 | Perry, Missouri, US | |
2022-12-18 | US | Missouri | Perry | 29157 | 6117 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-19 04:21:03 | Perry, Missouri, US | |
2022-12-17 | US | Missouri | Perry | 29157 | 6117 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-18 04:21:03 | Perry, Missouri, US | |
2022-12-16 | US | Missouri | Perry | 29157 | 6117 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-17 04:21:04 | Perry, Missouri, US | |
2022-12-15 | US | Missouri | Perry | 29157 | 6117 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-16 04:21:01 | Perry, Missouri, US | |
2022-12-14 | US | Missouri | Perry | 29157 | 6117 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-15 04:20:58 | Perry, Missouri, US | |
2022-12-13 | US | Missouri | Perry | 29157 | 6117 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-14 04:21:04 | Perry, Missouri, US | |
2022-11-30 | US | Tennessee | Crockett | 47033 | 6117 | 89 | 0 | 35.81830662 | -89.14916269 | 2022-12-01 04:21:03 | Crockett, Tennessee, US | |
2022-11-28 | US | Virginia | Powhatan | 51145 | 6117 | 68 | 0 | 37.55016038 | -77.91267882 | 2022-11-29 04:21:05 | Powhatan, Virginia, US | |
2022-10-18 | US | Texas | Lampasas | 48281 | 6117 | 93 | 0 | 31.19531316 | -98.24206613 | 2022-10-19 04:22:26 | Lampasas, Texas, US | |
2022-10-17 | US | Texas | Lampasas | 48281 | 6117 | 93 | 0 | 31.19531316 | -98.24206613 | 2022-10-18 04:22:42 | Lampasas, Texas, US | |
2022-10-04 | US | Arkansas | Clark | 5019 | 6117 | 88 | 0 | 34.04613432 | -93.17484713 | 2022-10-05 04:23:06 | Clark, Arkansas, US | |
2022-10-03 | US | Arkansas | Clark | 5019 | 6117 | 88 | 0 | 34.04613432 | -93.17484713 | 2022-10-04 04:22:55 | Clark, Arkansas, US | |
2022-10-02 | US | Arkansas | Clark | 5019 | 6117 | 88 | 0 | 34.04613432 | -93.17484713 | 2022-10-03 04:23:11 | Clark, Arkansas, US | |
2022-10-01 | US | Arkansas | Clark | 5019 | 6117 | 88 | 0 | 34.04613432 | -93.17484713 | 2022-10-02 04:21:23 | Clark, Arkansas, US | |
2022-09-30 | US | Arkansas | Clark | 5019 | 6117 | 87 | 0 | 34.04613432 | -93.17484713 | 2022-10-01 04:23:01 | Clark, Arkansas, US | |
2022-09-21 | US | Virginia | Prince Edward | 51147 | 6117 | 78 | 0 | 37.22554789 | -78.43597949 | 2022-09-22 04:22:56 | Prince Edward, Virginia, US | |
2022-09-13 | US | Georgia | Pike | 13231 | 6117 | 102 | 0 | 33.09310242 | -84.38790389 | 2022-09-14 04:20:44 | Pike, Georgia, US | |
2022-09-12 | US | Georgia | Pike | 13231 | 6117 | 102 | 0 | 33.09310242 | -84.38790389 | 2022-09-13 04:20:57 | Pike, Georgia, US | |
2022-09-11 | US | Georgia | Pike | 13231 | 6117 | 102 | 0 | 33.09310242 | -84.38790389 | 2022-09-12 04:20:58 | Pike, Georgia, US | |
2022-09-10 | US | Georgia | Pike | 13231 | 6117 | 102 | 0 | 33.09310242 | -84.38790389 | 2022-09-11 04:20:50 | Pike, Georgia, US | |
2022-09-09 | US | Georgia | Pike | 13231 | 6117 | 102 | 0 | 33.09310242 | -84.38790389 | 2022-09-10 04:21:10 | Pike, Georgia, US | |
2022-09-08 | US | Georgia | Pike | 13231 | 6117 | 102 | 0 | 33.09310242 | -84.38790389 | 2022-09-09 04:21:11 | Pike, Georgia, US | |
2022-09-08 | US | Kentucky | Unassigned | 90021 | 6117 | 38 | 0 | 38.97065142 | 0.0 | 2022-09-09 04:21:11 | Unassigned, Kentucky, US | |
2022-09-07 | US | Georgia | Pike | 13231 | 6117 | 102 | 0 | 33.09310242 | -84.38790389 | 2022-09-08 04:21:02 | Pike, Georgia, US | |
2022-08-08 | US | Puerto Rico | Villalba | 72149 | 6117 | 0 | 0 | 18.127951 | -66.473115 | 2022-08-09 04:20:34 | Villalba, Puerto Rico, US | |
2022-07-15 | US | Puerto Rico | Aguas Buenas | 72007 | 6117 | 0 | 0 | 18.251619 | -66.126806 | 2022-07-16 04:21:05 | Aguas Buenas, Puerto Rico, US | |
2022-07-15 | US | Texas | Calhoun | 48057 | 6117 | 51 | 0 | 28.47048236 | -96.61633945 | 2022-07-16 04:21:05 | Calhoun, Texas, US | |
2022-06-28 | US | Indiana | Owen | 18119 | 6117 | 123 | 0 | 39.31145587 | -86.83900724 | 2022-06-29 04:20:59 | Owen, Indiana, US | |
2022-06-27 | US | Indiana | Owen | 18119 | 6117 | 123 | 0 | 39.31145587 | -86.83900724 | 2022-06-28 04:20:58 | Owen, Indiana, US | |
2022-06-19 | US | Indiana | Washington | 18175 | 6117 | 87 | 0 | 38.60219804 | -86.1049363 | 2022-06-20 04:21:01 | Washington, Indiana, US | |
2022-06-18 | US | Indiana | Washington | 18175 | 6117 | 87 | 0 | 38.60219804 | -86.1049363 | 2022-06-19 04:20:51 | Washington, Indiana, US | |
2022-06-17 | US | Indiana | Washington | 18175 | 6117 | 87 | 0 | 38.60219804 | -86.1049363 | 2022-06-18 04:21:10 | Washington, Indiana, US | |
2022-06-07 | US | Puerto Rico | Morovis | 72101 | 6117 | 0 | 0 | 18.316963 | -66.420383 | 2022-06-08 04:20:55 | Morovis, Puerto Rico, US | |
2022-05-21 | US | Texas | Jasper | 48241 | 6117 | 187 | 0 | 30.74685667 | -94.02667579 | 2022-05-22 04:20:52 | Jasper, Texas, US | |
2022-05-12 | US | Missouri | Miller | 29131 | 6117 | 123 | 0 | 38.21450288 | -92.42610898 | 2022-05-13 04:20:51 | Miller, Missouri, US | |
2022-05-11 | US | Missouri | Miller | 29131 | 6117 | 123 | 0 | 38.21450288 | -92.42610898 | 2022-05-12 04:20:54 | Miller, Missouri, US | |
2022-05-10 | US | Missouri | Miller | 29131 | 6117 | 123 | 0 | 38.21450288 | -92.42610898 | 2022-05-11 04:20:48 | Miller, Missouri, US | |
2022-05-09 | US | Missouri | Miller | 29131 | 6117 | 123 | 0 | 38.21450288 | -92.42610898 | 2022-05-10 04:20:50 | Miller, Missouri, US | |
2022-05-08 | US | Missouri | Miller | 29131 | 6117 | 123 | 0 | 38.21450288 | -92.42610898 | 2022-05-09 04:20:54 | Miller, Missouri, US | |
2022-05-07 | US | Missouri | Miller | 29131 | 6117 | 123 | 0 | 38.21450288 | -92.42610898 | 2022-05-08 04:20:49 | Miller, Missouri, US | |
2022-05-06 | US | Missouri | Miller | 29131 | 6117 | 123 | 0 | 38.21450288 | -92.42610898 | 2022-05-07 04:21:09 | Miller, Missouri, US | |
2022-05-05 | US | Maryland | Caroline | 24011 | 6117 | 80 | 0 | 38.87172293 | -75.82904158 | 2022-05-06 04:21:00 | Caroline, Maryland, US | |
2022-05-02 | US | Arkansas | Jackson | 5067 | 6117 | 63 | 0 | 35.59802983 | -91.21494602 | 2022-05-03 04:21:00 | Jackson, Arkansas, US | |
2022-05-01 | US | Arkansas | Jackson | 5067 | 6117 | 63 | 0 | 35.59802983 | -91.21494602 | 2022-05-02 04:21:10 | Jackson, Arkansas, US | |
2022-05-01 | US | Kentucky | Johnson | 21115 | 6117 | 113 | 0 | 37.85106355 | -82.8264322 | 2022-05-02 04:21:10 | Johnson, Kentucky, US | |
2022-04-30 | US | Arkansas | Jackson | 5067 | 6117 | 63 | 0 | 35.59802983 | -91.21494602 | 2022-05-01 04:20:57 | Jackson, Arkansas, US | |
2022-04-30 | US | Kentucky | Johnson | 21115 | 6117 | 113 | 0 | 37.85106355 | -82.8264322 | 2022-05-01 04:20:57 | Johnson, Kentucky, US | |
2022-04-29 | US | Arkansas | Jackson | 5067 | 6117 | 63 | 0 | 35.59802983 | -91.21494602 | 2022-04-30 04:21:05 | Jackson, Arkansas, US | |
2022-04-29 | US | Kentucky | Johnson | 21115 | 6117 | 113 | 0 | 37.85106355 | -82.8264322 | 2022-04-30 04:21:05 | Johnson, Kentucky, US | |
2022-04-28 | US | Kentucky | Johnson | 21115 | 6117 | 113 | 0 | 37.85106355 | -82.8264322 | 2022-04-29 04:20:59 | Johnson, Kentucky, US | |
2022-04-27 | US | Kentucky | Johnson | 21115 | 6117 | 113 | 0 | 37.85106355 | -82.8264322 | 2022-04-28 04:20:47 | Johnson, Kentucky, US | |
2022-04-26 | US | Kentucky | Johnson | 21115 | 6117 | 113 | 0 | 37.85106355 | -82.8264322 | 2022-04-27 04:20:52 | Johnson, Kentucky, US | |
2022-04-25 | US | Kentucky | Johnson | 21115 | 6117 | 113 | 0 | 37.85106355 | -82.8264322 | 2022-04-26 04:20:51 | Johnson, Kentucky, US | |
2022-04-13 | US | New Hampshire | Unassigned | 90033 | 6117 | 2 | 0 | 44.69063265 | 0.0 | 2022-04-13 23:21:06 | Unassigned, New Hampshire, US | |
2022-04-12 | US | New Hampshire | Unassigned | 90033 | 6117 | 2 | 0 | 44.69063265 | 0.0 | 2022-04-13 04:21:03 | Unassigned, New Hampshire, US | |
2022-03-21 | US | Nebraska | Cass | 31025 | 6117 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-03-22 04:20:54 | Cass, Nebraska, US | |
2022-03-16 | US | Nebraska | Cass | 31025 | 6117 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-03-17 04:20:56 | Cass, Nebraska, US | |
2022-03-14 | US | Georgia | Peach | 13225 | 6117 | 125 | 0 | 32.56934316 | -83.82937 | 2022-03-15 04:20:47 | Peach, Georgia, US | |
2022-03-08 | US | Nebraska | Cass | 31025 | 6117 | 16 | 0 | 40.90899107 | -96.13971217 | 2022-03-09 04:20:59 | Cass, Nebraska, US | |
2022-02-09 | US | Kentucky | Marion | 21155 | 6117 | 67 | 0 | 37.55218078 | -85.26898542 | 2022-02-10 04:21:14 | Marion, Kentucky, US | |
2022-02-08 | US | Missouri | Saline | 29195 | 6117 | 95 | 0 | 39.13734288 | -93.20259964 | 2022-02-09 04:21:04 | Saline, Missouri, US | |
2022-02-03 | US | Michigan | Emmet | 26047 | 6117 | 70 | 0 | 45.52625509 | -84.89083249 | 2022-02-04 04:21:10 | Emmet, Michigan, US | |
2022-02-02 | US | Michigan | Emmet | 26047 | 6117 | 70 | 0 | 45.52625509 | -84.89083249 | 2022-02-03 04:21:21 | Emmet, Michigan, US | |
2022-01-24 | US | Mississippi | Marion | 28091 | 6117 | 122 | 0 | 31.23132643 | -89.8209217 | 2022-01-25 04:21:05 | Marion, Mississippi, US | |
2021-12-07 | US | Maryland | Calvert | 24009 | 6117 | 102 | 0 | 38.53961642 | -76.56820632 | 2021-12-08 04:22:46 | Calvert, Maryland, US | |
2021-12-03 | US | Pennsylvania | Clinton | 42035 | 6117 | 94 | 0 | 41.23255967 | -77.63785995 | 2021-12-04 04:22:18 | Clinton, Pennsylvania, US | |
2021-11-29 | US | Missouri | Howell | 29091 | 6117 | 80 | 0 | 36.77383887 | -91.88683935 | 2021-11-30 04:22:53 | Howell, Missouri, US | |
2021-11-25 | US | Arkansas | Baxter | 5005 | 6117 | 187 | 0 | 36.28784385 | -92.33782872 | 2021-11-26 04:22:33 | Baxter, Arkansas, US | |
2021-11-05 | US | New York | Livingston | 36051 | 6117 | 71 | 0 | 42.72596275 | -77.77966158 | 2021-11-06 04:21:51 | Livingston, New York, US | |
2021-11-01 | US | Washington | Douglas | 53017 | 6117 | 38 | 0 | 47.7361335 | -119.69293700000001 | 2021-11-02 04:22:03 | Douglas, Washington, US | |
2021-10-29 | US | Ohio | Fulton | 39051 | 6117 | 107 | 0 | 41.60213491 | -84.12571393 | 2021-10-30 04:22:03 | Fulton, Ohio, US | |
2021-10-05 | US | Iowa | Muscatine | 19139 | 6117 | 111 | 0 | 41.48370744 | -91.11216970000001 | 2021-10-06 04:21:33 | Muscatine, Iowa, US | |
2021-10-04 | US | Iowa | Muscatine | 19139 | 6117 | 111 | 0 | 41.48370744 | -91.11216970000001 | 2021-10-05 04:21:27 | Muscatine, Iowa, US | |
2021-10-03 | US | Iowa | Muscatine | 19139 | 6117 | 111 | 0 | 41.48370744 | -91.11216970000001 | 2021-10-04 04:21:31 | Muscatine, Iowa, US | |
2021-10-02 | US | Iowa | Muscatine | 19139 | 6117 | 111 | 0 | 41.48370744 | -91.11216970000001 | 2021-10-03 04:21:24 | Muscatine, Iowa, US | |
2021-10-01 | US | Iowa | Muscatine | 19139 | 6117 | 111 | 0 | 41.48370744 | -91.11216970000001 | 2021-10-02 04:21:25 | Muscatine, Iowa, US | |
2021-09-30 | US | Georgia | Bryan | 13029 | 6117 | 56 | 0 | 32.00979311 | -81.44002948 | 2021-10-01 04:21:35 | Bryan, Georgia, US | |
2021-09-30 | US | Iowa | Muscatine | 19139 | 6117 | 111 | 0 | 41.48370744 | -91.11216970000001 | 2021-10-01 04:21:35 | Muscatine, Iowa, US | |
2021-09-29 | US | Iowa | Muscatine | 19139 | 6117 | 111 | 0 | 41.48370744 | -91.11216970000001 | 2021-09-30 04:21:20 | Muscatine, Iowa, US | |
2021-09-26 | US | Arkansas | Miller | 5091 | 6117 | 40 | 0 | 33.31403423 | -93.89285258 | 2021-09-27 04:21:16 | Miller, Arkansas, US | |
2021-08-04 | US | Illinois | Grundy | 17063 | 6117 | 79 | 0 | 41.28569601 | -88.41905692 | 2021-08-05 04:21:51 | Grundy, Illinois, US | |
2021-07-27 | US | Alabama | Coffee | 1031 | 6117 | 131 | 0 | 31.39932826 | -85.98901039 | 2021-07-28 04:21:39 | Coffee, Alabama, US | |
2021-06-29 | US | New Jersey | Salem | 34033 | 6117 | 188 | 0 | 39.58719656 | -75.34696629999998 | 2021-06-30 04:21:41 | Salem, New Jersey, US | |
2021-06-10 | US | New York | Jefferson | 36045 | 6117 | 68 | 0 | 44.04200959 | -75.94653457 | 2021-06-11 04:23:20 | Jefferson, New York, US | |
2021-06-07 | US | North Carolina | Lee | 37105 | 6117 | 81 | 0 | 35.47623147 | -79.17569362 | 2021-06-08 04:22:35 | Lee, North Carolina, US | |
2021-06-03 | US | Pennsylvania | Bradford | 42015 | 6117 | 90 | 0 | 41.78869215 | -76.51570822 | 2021-06-04 04:23:37 | Bradford, Pennsylvania, US | |
2021-06-02 | US | Ohio | Belmont | 39013 | 6117 | 176 | 0 | 40.01625942 | -80.9924051 | 2021-06-03 04:23:32 | Belmont, Ohio, US | |
2021-05-21 | US | Pennsylvania | Union | 42119 | 6117 | 86 | 0 | 40.96188846 | -77.05996014 | 2021-05-22 04:20:45 | Union, Pennsylvania, US | |
2021-05-17 | US | Michigan | Ionia | 26067 | 6117 | 79 | 0 | 42.94502238 | -85.07413319 | 2021-05-18 04:20:33 | Ionia, Michigan, US | |
2021-05-10 | US | Arkansas | Greene | 5055 | 6117 | 77 | 0 | 36.11735460000001 | -90.55832668 | 2021-05-11 04:20:41 | Greene, Arkansas, US | |
2021-05-09 | US | Arkansas | Greene | 5055 | 6117 | 77 | 0 | 36.11735460000001 | -90.55832668 | 2021-05-10 04:20:38 | Greene, Arkansas, US | |
2021-05-07 | US | Texas | Navarro | 48349 | 6117 | 141 | 0 | 32.04620681 | -96.47428766 | 2021-05-08 04:21:04 | Navarro, Texas, US | |
2021-04-27 | US | Indiana | Dubois | 18037 | 6117 | 117 | 0 | 38.36597551 | -86.87924170000002 | 2021-04-28 04:20:32 | Dubois, Indiana, US | |
2021-04-19 | US | North Carolina | Duplin | 37061 | 6117 | 128 | 0 | 34.93449805 | -77.93140529 | 2021-04-20 04:20:41 | Duplin, North Carolina, US | |
2021-04-06 | US | Virginia | Bedford | 51019 | 6117 | 98 | 0 | 37.3080028 | -79.5281964 | 2021-04-07 04:20:53 | Bedford, Virginia, US | |
2021-03-20 | US | New York | Ontario | 36069 | 6117 | 90 | 0 | 42.85145728 | -77.30874425 | 2021-03-21 05:25:44 | Ontario, New York, US | |
2021-03-20 | US | Tennessee | McMinn | 47107 | 6117 | 94 | 0 | 35.42812616 | -84.61520715 | 2021-03-21 05:25:44 | McMinn, Tennessee, US | |
2021-03-19 | US | Alabama | Colbert | 1033 | 6117 | 125 | 0 | 34.69847452 | -87.80168544 | 2021-03-20 05:25:46 | Colbert, Alabama, US | |
2021-03-10 | US | Minnesota | Blue Earth | 27013 | 6117 | 37 | 0 | 44.03554215 | -94.06699781 | 2021-03-11 05:25:48 | Blue Earth, Minnesota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;