daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
128 rows where confirmed = 5121 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 109
- Equatorial Guinea 4
- Russia 4
- Sweden 4
- Burundi 3
- Germany 1
- Spain 1
- Timor-Leste 1
- Ukraine 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Arkansas | Grant | 5053 | 5121 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-30 04:21:04 | Grant, Arkansas, US | |
2022-12-28 | US | Arkansas | Grant | 5053 | 5121 | 65 | 0 | 34.29017991 | -92.42320562 | 2022-12-29 04:21:01 | Grant, Arkansas, US | |
2022-12-07 | US | Illinois | Bond | 17005 | 5121 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-12-08 04:21:07 | Bond, Illinois, US | |
2022-12-06 | US | Texas | Shelby | 48419 | 5121 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-12-07 04:20:58 | Shelby, Texas, US | |
2022-12-05 | US | Texas | Shelby | 48419 | 5121 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-12-06 04:21:03 | Shelby, Texas, US | |
2022-12-04 | US | Texas | Shelby | 48419 | 5121 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-12-05 04:20:58 | Shelby, Texas, US | |
2022-12-03 | US | Texas | Shelby | 48419 | 5121 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-12-04 04:20:56 | Shelby, Texas, US | |
2022-12-02 | US | Texas | Shelby | 48419 | 5121 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-12-03 04:21:02 | Shelby, Texas, US | |
2022-12-01 | US | Texas | Shelby | 48419 | 5121 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-12-02 04:21:07 | Shelby, Texas, US | |
2022-11-30 | US | Texas | Shelby | 48419 | 5121 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-12-01 04:21:03 | Shelby, Texas, US | |
2022-11-27 | US | Kentucky | Casey | 21045 | 5121 | 81 | 0 | 37.32533118 | -84.92726209 | 2022-11-28 04:21:02 | Casey, Kentucky, US | |
2022-11-26 | US | Kentucky | Casey | 21045 | 5121 | 81 | 0 | 37.32533118 | -84.92726209 | 2022-11-27 04:21:05 | Casey, Kentucky, US | |
2022-11-25 | US | Kentucky | Casey | 21045 | 5121 | 81 | 0 | 37.32533118 | -84.92726209 | 2022-11-26 04:21:11 | Casey, Kentucky, US | |
2022-11-24 | US | Kentucky | Casey | 21045 | 5121 | 81 | 0 | 37.32533118 | -84.92726209 | 2022-11-25 04:21:06 | Casey, Kentucky, US | |
2022-11-23 | US | Kentucky | Casey | 21045 | 5121 | 81 | 0 | 37.32533118 | -84.92726209 | 2022-11-24 04:21:09 | Casey, Kentucky, US | |
2022-11-22 | US | Kentucky | Casey | 21045 | 5121 | 81 | 0 | 37.32533118 | -84.92726209 | 2022-11-23 04:21:06 | Casey, Kentucky, US | |
2022-11-21 | US | Kentucky | Casey | 21045 | 5121 | 81 | 0 | 37.32533118 | -84.92726209 | 2022-11-22 04:20:47 | Casey, Kentucky, US | |
2022-10-19 | US | Wisconsin | Crawford | 55023 | 5121 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-10-20 04:22:59 | Crawford, Wisconsin, US | |
2022-09-07 | US | Tennessee | Bledsoe | 47007 | 5121 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-09-08 04:21:02 | Bledsoe, Tennessee, US | |
2022-08-10 | US | Illinois | Cass | 17017 | 5121 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-08-11 04:20:49 | Cass, Illinois, US | |
2022-08-08 | US | Arkansas | Hempstead | 5057 | 5121 | 70 | 0 | 33.73325583 | -93.66935133 | 2022-08-09 04:20:34 | Hempstead, Arkansas, US | |
2022-08-02 | US | Kansas | Jefferson | 20087 | 5121 | 68 | 0 | 39.2347941 | -95.38289232 | 2022-08-03 04:20:59 | Jefferson, Kansas, US | |
2022-08-01 | US | Kansas | Jefferson | 20087 | 5121 | 68 | 0 | 39.2347941 | -95.38289232 | 2022-08-02 04:20:53 | Jefferson, Kansas, US | |
2022-07-31 | US | Kansas | Jefferson | 20087 | 5121 | 68 | 0 | 39.2347941 | -95.38289232 | 2022-08-01 04:21:03 | Jefferson, Kansas, US | |
2022-07-30 | US | Kansas | Jefferson | 20087 | 5121 | 68 | 0 | 39.2347941 | -95.38289232 | 2022-07-31 04:21:02 | Jefferson, Kansas, US | |
2022-07-29 | US | Kansas | Jefferson | 20087 | 5121 | 68 | 0 | 39.2347941 | -95.38289232 | 2022-07-30 04:20:42 | Jefferson, Kansas, US | |
2022-07-28 | US | Kansas | Jefferson | 20087 | 5121 | 68 | 0 | 39.2347941 | -95.38289232 | 2022-07-29 04:20:45 | Jefferson, Kansas, US | |
2022-07-27 | US | Kansas | Jefferson | 20087 | 5121 | 68 | 0 | 39.2347941 | -95.38289232 | 2022-07-28 04:20:56 | Jefferson, Kansas, US | |
2022-07-26 | US | Wisconsin | Sawyer | 55113 | 5121 | 63 | 0 | 45.87931905 | -91.14504927 | 2022-07-27 04:21:04 | Sawyer, Wisconsin, US | |
2022-07-17 | US | Virginia | New Kent | 51127 | 5121 | 34 | 0 | 37.50694406 | -76.99828634 | 2022-07-18 04:20:59 | New Kent, Virginia, US | |
2022-07-16 | US | Virginia | New Kent | 51127 | 5121 | 34 | 0 | 37.50694406 | -76.99828634 | 2022-07-17 04:21:15 | New Kent, Virginia, US | |
2022-07-15 | US | Virginia | New Kent | 51127 | 5121 | 34 | 0 | 37.50694406 | -76.99828634 | 2022-07-16 04:21:05 | New Kent, Virginia, US | |
2022-07-14 | US | Idaho | Cassia | 16031 | 5121 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-07-15 04:20:53 | Cassia, Idaho, US | |
2022-07-13 | US | Idaho | Cassia | 16031 | 5121 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-07-14 04:20:57 | Cassia, Idaho, US | |
2022-06-25 | US | Texas | Burleson | 48051 | 5121 | 66 | 0 | 30.49273808 | -96.62158484 | 2022-06-26 04:21:02 | Burleson, Texas, US | |
2022-06-08 | US | Alabama | Butler | 1013 | 5121 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-06-09 04:20:54 | Butler, Alabama, US | |
2022-05-31 | US | Oregon | Union | 41061 | 5121 | 82 | 0 | 45.30915495 | -118.0068979 | 2022-06-01 04:20:55 | Union, Oregon, US | |
2022-05-23 | US | Arkansas | Ashley | 5003 | 5121 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-24 04:20:57 | Ashley, Arkansas, US | |
2022-05-21 | US | Arkansas | Ashley | 5003 | 5121 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-22 04:20:52 | Ashley, Arkansas, US | |
2022-05-02 | US | Arkansas | Logan | 5083 | 5121 | 80 | 0 | 35.21413234 | -93.71951016 | 2022-05-03 04:21:00 | Logan, Arkansas, US | |
2022-05-01 | US | Arkansas | Logan | 5083 | 5121 | 80 | 0 | 35.21413234 | -93.71951016 | 2022-05-02 04:21:10 | Logan, Arkansas, US | |
2022-04-30 | US | Arkansas | Logan | 5083 | 5121 | 80 | 0 | 35.21413234 | -93.71951016 | 2022-05-01 04:20:57 | Logan, Arkansas, US | |
2022-04-22 | US | New York | Schoharie | 36095 | 5121 | 36 | 0 | 42.58831742 | -74.44339029999998 | 2022-04-23 04:20:50 | Schoharie, New York, US | |
2022-02-27 | US | Tennessee | Crockett | 47033 | 5121 | 82 | 0 | 35.81830662 | -89.14916269 | 2022-02-28 04:21:05 | Crockett, Tennessee, US | |
2022-02-26 | US | Tennessee | Crockett | 47033 | 5121 | 82 | 0 | 35.81830662 | -89.14916269 | 2022-02-27 04:21:04 | Crockett, Tennessee, US | |
2022-02-23 | US | New Mexico | Lincoln | 35027 | 5121 | 63 | 0 | 33.74526079 | -105.4586166 | 2022-02-24 04:21:14 | Lincoln, New Mexico, US | |
2022-02-20 | US | Wisconsin | Iowa | 55049 | 5121 | 25 | 0 | 43.00050278 | -90.13469017 | 2022-02-21 04:21:05 | Iowa, Wisconsin, US | |
2022-02-19 | US | Wisconsin | Iowa | 55049 | 5121 | 25 | 0 | 43.00050278 | -90.13469017 | 2022-02-20 04:21:00 | Iowa, Wisconsin, US | |
2022-02-18 | US | Wisconsin | Iowa | 55049 | 5121 | 25 | 0 | 43.00050278 | -90.13469017 | 2022-02-19 04:21:11 | Iowa, Wisconsin, US | |
2022-02-14 | US | Illinois | Richland | 17159 | 5121 | 71 | 0 | 38.71240969 | -88.08475366 | 2022-02-15 04:21:09 | Richland, Illinois, US | |
2022-02-10 | US | West Virginia | Lincoln | 54043 | 5121 | 63 | 0 | 38.172154 | -82.07017953 | 2022-02-11 04:21:09 | Lincoln, West Virginia, US | |
2022-02-09 | US | Puerto Rico | Cidra | 72041 | 5121 | 0 | 0 | 18.173559 | -66.161179 | 2022-02-10 04:21:14 | Cidra, Puerto Rico, US | |
2022-02-03 | US | California | Del Norte | 6015 | 5121 | 44 | 0 | 41.74228275 | -123.89740630000001 | 2022-02-04 04:21:10 | Del Norte, California, US | |
2022-02-02 | US | Hawaii | Out of HI | 80015 | 5121 | 12 | 0 | 22.03935037 | 0.0 | 2022-02-03 04:21:21 | Out of HI, Hawaii, US | |
2022-01-16 | US | Alabama | Geneva | 1061 | 5121 | 140 | 0 | 31.09389027 | -85.83572839 | 2022-01-17 04:21:08 | Geneva, Alabama, US | |
2021-12-29 | US | Vermont | Washington | 50023 | 5121 | 32 | 0 | 44.27343241 | -72.61604978 | 2021-12-30 04:21:25 | Washington, Vermont, US | |
2021-12-29 | US | Indiana | Decatur | 18031 | 5121 | 112 | 0 | 39.30712658 | -85.50087166 | 2021-12-30 04:21:25 | Decatur, Indiana, US | |
2021-12-14 | US | Minnesota | Todd | 27153 | 5121 | 48 | 0 | 46.06996226 | -94.89785296 | 2021-12-15 03:22:16 | Todd, Minnesota, US | |
2021-12-12 | US | Mississippi | George | 28039 | 5121 | 80 | 0 | 30.86259065 | -88.64436789 | 2021-12-13 04:22:02 | George, Mississippi, US | |
2021-12-11 | US | West Virginia | Mingo | 54059 | 5121 | 93 | 0 | 37.73048351 | -82.13338365 | 2021-12-12 04:22:12 | Mingo, West Virginia, US | |
2021-12-11 | US | Mississippi | George | 28039 | 5121 | 80 | 0 | 30.86259065 | -88.64436789 | 2021-12-12 04:22:12 | George, Mississippi, US | |
2021-12-10 | US | Mississippi | George | 28039 | 5121 | 80 | 0 | 30.86259065 | -88.64436789 | 2021-12-11 04:22:45 | George, Mississippi, US | |
2021-12-09 | US | Mississippi | George | 28039 | 5121 | 80 | 0 | 30.86259065 | -88.64436789 | 2021-12-10 04:22:28 | George, Mississippi, US | |
2021-12-06 | US | Missouri | Lafayette | 29107 | 5121 | 88 | 0 | 39.06986886 | -93.78076396 | 2021-12-07 04:22:34 | Lafayette, Missouri, US | |
2021-11-30 | US | North Carolina | Macon | 37113 | 5121 | 80 | 0 | 35.14867843 | -83.41696617 | 2021-12-01 04:22:29 | Macon, North Carolina, US | |
2021-11-29 | US | Texas | Willacy | 48489 | 5121 | 113 | 0 | 26.47411727 | -97.61535848 | 2021-11-30 04:22:53 | Willacy, Texas, US | |
2021-11-29 | US | North Carolina | Macon | 37113 | 5121 | 80 | 0 | 35.14867843 | -83.41696617 | 2021-11-30 04:22:53 | Macon, North Carolina, US | |
2021-10-17 | US | Ohio | Perry | 39127 | 5121 | 73 | 0 | 39.73508655 | -82.23804971 | 2021-10-18 04:21:10 | Perry, Ohio, US | |
2021-10-16 | US | Puerto Rico | Toa Baja | 72137 | 5121 | 0 | 0 | 18.431445999999998 | -66.213553 | 2021-10-17 04:21:29 | Toa Baja, Puerto Rico, US | |
2021-10-06 | US | Kentucky | Harlan | 21095 | 5121 | 119 | 0 | 36.85699301 | -83.21899516 | 2021-10-07 04:21:36 | Harlan, Kentucky, US | |
2021-09-23 | US | West Virginia | Fayette | 54019 | 5121 | 98 | 0 | 38.02974928 | -81.08286634 | 2021-09-24 04:21:44 | Fayette, West Virginia, US | |
2021-09-22 | US | Ohio | Logan | 39091 | 5121 | 90 | 0 | 40.38996525 | -83.76784341 | 2021-09-23 04:21:43 | Logan, Ohio, US | |
2021-09-07 | US | Oklahoma | Logan | 40083 | 5121 | 72 | 0 | 35.91899576 | -97.44352845 | 2021-09-08 04:21:31 | Logan, Oklahoma, US | |
2021-09-06 | US | Oklahoma | Logan | 40083 | 5121 | 72 | 0 | 35.91899576 | -97.44352845 | 2021-09-07 04:21:35 | Logan, Oklahoma, US | |
2021-09-05 | US | Oklahoma | Logan | 40083 | 5121 | 72 | 0 | 35.91899576 | -97.44352845 | 2021-09-06 04:21:22 | Logan, Oklahoma, US | |
2021-09-04 | US | Oklahoma | Logan | 40083 | 5121 | 72 | 0 | 35.91899576 | -97.44352845 | 2021-09-05 04:21:33 | Logan, Oklahoma, US | |
2021-09-03 | US | Oklahoma | Logan | 40083 | 5121 | 72 | 0 | 35.91899576 | -97.44352845 | 2021-09-04 04:21:28 | Logan, Oklahoma, US | |
2021-09-02 | US | Oklahoma | Logan | 40083 | 5121 | 72 | 0 | 35.91899576 | -97.44352845 | 2021-09-03 04:21:20 | Logan, Oklahoma, US | |
2021-09-01 | US | Oklahoma | Logan | 40083 | 5121 | 72 | 0 | 35.91899576 | -97.44352845 | 2021-09-02 04:21:15 | Logan, Oklahoma, US | |
2021-08-26 | US | Virginia | Culpeper | 51047 | 5121 | 70 | 0 | 38.48199985 | -77.95630870000002 | 2021-08-27 04:21:37 | Culpeper, Virginia, US | |
2021-08-23 | US | Missouri | Webster | 29225 | 5121 | 78 | 0 | 37.2813734 | -92.876329 | 2021-08-24 04:21:19 | Webster, Missouri, US | |
2021-08-19 | US | Wisconsin | Pierce | 55093 | 5121 | 44 | 0 | 44.71850291 | -92.4224416 | 2021-08-20 04:21:33 | Pierce, Wisconsin, US | |
2021-08-04 | US | Ohio | Auglaize | 39011 | 5121 | 87 | 0 | 40.55998859 | -84.22421429999999 | 2021-08-05 04:21:51 | Auglaize, Ohio, US | |
2021-07-01 | US | Illinois | Jackson | 17077 | 5121 | 65 | 0 | 37.78595185 | -89.38232563 | 2021-07-02 04:21:47 | Jackson, Illinois, US | |
2021-06-27 | US | Missouri | Callaway | 29027 | 5121 | 51 | 0 | 38.83674754 | -91.92186505 | 2021-06-28 04:21:29 | Callaway, Missouri, US | |
2021-06-26 | US | Missouri | Callaway | 29027 | 5121 | 51 | 0 | 38.83674754 | -91.92186505 | 2021-06-27 04:21:39 | Callaway, Missouri, US | |
2021-06-24 | US | Kentucky | Boyd | 21019 | 5121 | 76 | 0 | 38.36176608 | -82.68652187 | 2021-06-25 04:21:33 | Boyd, Kentucky, US | |
2021-06-20 | Burundi | 5121 | 8 | 773 | 4340 | -3.3731 | 29.9189 | 2021-06-21 04:21:41 | Burundi | |||
2021-06-19 | Burundi | 5121 | 8 | 773 | 4340 | -3.3731 | 29.9189 | 2021-06-20 04:21:48 | Burundi | |||
2021-06-18 | Burundi | 5121 | 8 | 773 | 4340 | -3.3731 | 29.9189 | 2021-06-19 04:22:33 | Burundi | |||
2021-05-22 | US | Tennessee | Fayette | 47047 | 5121 | 77 | 0 | 35.19615831 | -89.41399032 | 2021-05-23 04:20:51 | Fayette, Tennessee, US | |
2021-05-20 | Timor-Leste | 5121 | 11 | 2716 | 2394 | -8.874217 | 125.727539 | 2021-05-21 04:20:43 | Timor-Leste | |||
2021-05-19 | US | New York | Herkimer | 36043 | 5121 | 107 | 0 | 43.42034246 | -74.96145307 | 2021-05-20 04:21:05 | Herkimer, New York, US | |
2021-05-11 | US | Iowa | Webster | 19187 | 5121 | 93 | 0 | 42.42853483 | -94.17987389 | 2021-05-12 04:21:29 | Webster, Iowa, US | |
2021-05-10 | US | Arkansas | Hot Spring | 5059 | 5121 | 72 | 0 | 34.31709259 | -92.95396325 | 2021-05-11 04:20:41 | Hot Spring, Arkansas, US | |
2021-04-25 | US | Ohio | Athens | 39009 | 5121 | 59 | 0 | 39.33425634 | -82.04278644 | 2021-04-26 04:21:04 | Athens, Ohio, US | |
2021-04-05 | US | Ohio | Jefferson | 39081 | 5121 | 151 | 0 | 40.38614126 | -80.76259514 | 2021-04-06 04:20:32 | Jefferson, Ohio, US | |
2021-03-31 | Spain | Ceuta | 5121 | 95 | 163 | 4863 | 35.8894 | -5.3213 | 2021-04-01 04:27:05 | Ceuta, Spain | ||
2021-03-30 | US | Illinois | Knox | 17095 | 5121 | 135 | 0 | 40.93148779 | -90.21330340000002 | 2021-03-31 04:26:25 | Knox, Illinois, US | |
2021-03-23 | US | New York | Jefferson | 36045 | 5121 | 63 | 0 | 44.04200959 | -75.94653457 | 2021-03-24 05:25:40 | Jefferson, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;