daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
253 rows where confirmed = 3011 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-22 | US | Connecticut | Unassigned | 90009 | 3011 | 8 | 0 | 41.85853803 | 0.0 | 2022-11-23 04:21:06 | Unassigned, Connecticut, US | |
2022-11-20 | US | Connecticut | Unassigned | 90009 | 3011 | 8 | 0 | 41.85853803 | 0.0 | 2022-11-21 04:21:05 | Unassigned, Connecticut, US | |
2022-11-13 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-14 04:21:09 | Jefferson, Montana, US | |
2022-11-12 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-13 04:21:14 | Jefferson, Montana, US | |
2022-11-11 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-12 04:20:41 | Jefferson, Montana, US | |
2022-11-10 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-11 04:21:22 | Jefferson, Montana, US | |
2022-11-09 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-10 04:21:16 | Jefferson, Montana, US | |
2022-11-08 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-09 04:21:22 | Jefferson, Montana, US | |
2022-11-07 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-08 04:21:21 | Jefferson, Montana, US | |
2022-11-06 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-07 04:21:26 | Jefferson, Montana, US | |
2022-11-05 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-06 04:21:24 | Jefferson, Montana, US | |
2022-11-04 | US | Montana | Jefferson | 30043 | 3011 | 25 | 0 | 46.14907081 | -112.094396 | 2022-11-05 04:21:52 | Jefferson, Montana, US | |
2022-11-01 | US | Idaho | Shoshone | 16079 | 3011 | 79 | 0 | 47.35364087 | -115.8916749 | 2022-11-02 04:22:09 | Shoshone, Idaho, US | |
2022-10-31 | US | Idaho | Shoshone | 16079 | 3011 | 79 | 0 | 47.35364087 | -115.8916749 | 2022-11-01 04:22:36 | Shoshone, Idaho, US | |
2022-10-30 | US | Idaho | Shoshone | 16079 | 3011 | 79 | 0 | 47.35364087 | -115.8916749 | 2022-10-31 04:21:36 | Shoshone, Idaho, US | |
2022-10-29 | US | Idaho | Shoshone | 16079 | 3011 | 79 | 0 | 47.35364087 | -115.8916749 | 2022-10-30 04:22:14 | Shoshone, Idaho, US | |
2022-10-28 | US | Idaho | Shoshone | 16079 | 3011 | 79 | 0 | 47.35364087 | -115.8916749 | 2022-10-29 04:21:13 | Shoshone, Idaho, US | |
2022-10-27 | US | Idaho | Shoshone | 16079 | 3011 | 79 | 0 | 47.35364087 | -115.8916749 | 2022-10-28 04:22:31 | Shoshone, Idaho, US | |
2022-10-26 | US | Tennessee | Lake | 47095 | 3011 | 45 | 0 | 36.3418017 | -89.48921915 | 2022-10-27 04:22:01 | Lake, Tennessee, US | |
2022-10-26 | US | Idaho | Shoshone | 16079 | 3011 | 79 | 0 | 47.35364087 | -115.8916749 | 2022-10-27 04:22:01 | Shoshone, Idaho, US | |
2022-10-25 | US | Iowa | Chickasaw | 19037 | 3011 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-10-26 04:22:19 | Chickasaw, Iowa, US | |
2022-10-24 | US | Iowa | Chickasaw | 19037 | 3011 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-10-25 04:21:53 | Chickasaw, Iowa, US | |
2022-10-23 | US | Iowa | Chickasaw | 19037 | 3011 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-10-24 04:22:29 | Chickasaw, Iowa, US | |
2022-10-22 | US | Iowa | Chickasaw | 19037 | 3011 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-10-23 04:22:46 | Chickasaw, Iowa, US | |
2022-10-21 | US | Iowa | Chickasaw | 19037 | 3011 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-10-22 04:22:53 | Chickasaw, Iowa, US | |
2022-10-20 | US | Iowa | Chickasaw | 19037 | 3011 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-10-21 04:22:23 | Chickasaw, Iowa, US | |
2022-10-19 | US | Iowa | Chickasaw | 19037 | 3011 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-10-20 04:22:59 | Chickasaw, Iowa, US | |
2022-10-13 | US | Virginia | Galax | 51640 | 3011 | 80 | 0 | 36.66601852 | -80.91703124 | 2022-10-14 04:22:28 | Galax, Virginia, US | |
2022-09-21 | US | North Dakota | McLean | 38055 | 3011 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-09-22 04:22:56 | McLean, North Dakota, US | |
2022-08-02 | US | North Carolina | Perquimans | 37143 | 3011 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-08-03 04:20:59 | Perquimans, North Carolina, US | |
2022-08-01 | US | North Carolina | Perquimans | 37143 | 3011 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-08-02 04:20:53 | Perquimans, North Carolina, US | |
2022-07-31 | US | North Carolina | Perquimans | 37143 | 3011 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-08-01 04:21:03 | Perquimans, North Carolina, US | |
2022-07-30 | US | North Carolina | Perquimans | 37143 | 3011 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-07-31 04:21:02 | Perquimans, North Carolina, US | |
2022-07-29 | US | North Carolina | Perquimans | 37143 | 3011 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-07-30 04:20:42 | Perquimans, North Carolina, US | |
2022-07-28 | US | North Carolina | Perquimans | 37143 | 3011 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-07-29 04:20:45 | Perquimans, North Carolina, US | |
2022-07-27 | US | North Carolina | Perquimans | 37143 | 3011 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-07-28 04:20:56 | Perquimans, North Carolina, US | |
2022-07-21 | US | Texas | Camp | 48063 | 3011 | 75 | 0 | 32.97195142 | -94.97790104 | 2022-07-22 04:21:15 | Camp, Texas, US | |
2022-06-26 | US | Kentucky | Todd | 21219 | 3011 | 44 | 0 | 36.8381152 | -87.17878374 | 2022-06-27 04:21:00 | Todd, Kentucky, US | |
2022-06-25 | US | Kentucky | Todd | 21219 | 3011 | 44 | 0 | 36.8381152 | -87.17878374 | 2022-06-26 04:21:02 | Todd, Kentucky, US | |
2022-06-24 | US | Kentucky | Todd | 21219 | 3011 | 44 | 0 | 36.8381152 | -87.17878374 | 2022-06-25 04:20:57 | Todd, Kentucky, US | |
2022-06-24 | US | Arkansas | Stone | 5137 | 3011 | 68 | 0 | 35.86251946 | -92.15684085 | 2022-06-25 04:20:57 | Stone, Arkansas, US | |
2022-06-23 | US | Kentucky | Todd | 21219 | 3011 | 44 | 0 | 36.8381152 | -87.17878374 | 2022-06-24 04:20:58 | Todd, Kentucky, US | |
2022-06-22 | US | Kentucky | Todd | 21219 | 3011 | 44 | 0 | 36.8381152 | -87.17878374 | 2022-06-23 04:20:55 | Todd, Kentucky, US | |
2022-06-21 | US | Kentucky | Todd | 21219 | 3011 | 44 | 0 | 36.8381152 | -87.17878374 | 2022-06-22 04:20:54 | Todd, Kentucky, US | |
2022-06-20 | US | Mississippi | Montgomery | 28097 | 3011 | 78 | 0 | 33.49419589 | -89.61729103 | 2022-06-21 04:20:56 | Montgomery, Mississippi, US | |
2022-06-20 | US | Kentucky | Todd | 21219 | 3011 | 44 | 0 | 36.8381152 | -87.17878374 | 2022-06-21 04:20:56 | Todd, Kentucky, US | |
2022-06-19 | US | Mississippi | Montgomery | 28097 | 3011 | 78 | 0 | 33.49419589 | -89.61729103 | 2022-06-20 04:21:01 | Montgomery, Mississippi, US | |
2022-06-18 | US | Mississippi | Montgomery | 28097 | 3011 | 78 | 0 | 33.49419589 | -89.61729103 | 2022-06-19 04:20:51 | Montgomery, Mississippi, US | |
2022-06-17 | US | Mississippi | Montgomery | 28097 | 3011 | 78 | 0 | 33.49419589 | -89.61729103 | 2022-06-18 04:21:10 | Montgomery, Mississippi, US | |
2022-06-16 | US | Mississippi | Montgomery | 28097 | 3011 | 78 | 0 | 33.49419589 | -89.61729103 | 2022-06-17 04:20:56 | Montgomery, Mississippi, US | |
2022-06-15 | US | Mississippi | Montgomery | 28097 | 3011 | 78 | 0 | 33.49419589 | -89.61729103 | 2022-06-16 04:20:55 | Montgomery, Mississippi, US | |
2022-06-14 | US | Mississippi | Montgomery | 28097 | 3011 | 78 | 0 | 33.49419589 | -89.61729103 | 2022-06-15 04:20:54 | Montgomery, Mississippi, US | |
2022-06-13 | US | Mississippi | Montgomery | 28097 | 3011 | 78 | 0 | 33.49419589 | -89.61729103 | 2022-06-14 04:20:52 | Montgomery, Mississippi, US | |
2022-06-01 | US | Minnesota | Watonwan | 27165 | 3011 | 23 | 0 | 43.97823903 | -94.61413846 | 2022-06-02 05:20:39 | Watonwan, Minnesota, US | |
2022-05-08 | US | North Dakota | Barnes | 38003 | 3011 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-05-09 04:20:54 | Barnes, North Dakota, US | |
2022-05-07 | US | North Dakota | Barnes | 38003 | 3011 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-05-08 04:20:49 | Barnes, North Dakota, US | |
2022-05-06 | US | North Dakota | Barnes | 38003 | 3011 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-05-07 04:21:09 | Barnes, North Dakota, US | |
2022-04-27 | China | Fujian | 3011 | 1 | 0 | 26.0789 | 117.9874 | 2022-04-28 04:20:47 | Fujian, China | |||
2022-03-30 | US | California | Mariposa | 6043 | 3011 | 31 | 0 | 37.57978556 | -119.9073334 | 2022-03-31 04:20:56 | Mariposa, California, US | |
2022-03-29 | US | Puerto Rico | Barceloneta | 72017 | 3011 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-03-30 04:20:45 | Barceloneta, Puerto Rico, US | |
2022-03-28 | US | Puerto Rico | Barceloneta | 72017 | 3011 | 0 | 0 | 18.445532999999998 | -66.56053100000001 | 2022-03-29 04:20:46 | Barceloneta, Puerto Rico, US | |
2022-03-14 | US | Minnesota | Pope | 27121 | 3011 | 17 | 0 | 45.58606667 | -95.44451209 | 2022-03-15 04:20:47 | Pope, Minnesota, US | |
2022-03-12 | US | Arkansas | Desha | 5041 | 3011 | 38 | 0 | 33.83011025 | -91.25500948 | 2022-03-13 04:20:49 | Desha, Arkansas, US | |
2022-02-13 | US | Georgia | Dade | 13083 | 3011 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-02-14 04:20:51 | Dade, Georgia, US | |
2022-02-12 | US | Georgia | Dade | 13083 | 3011 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-02-13 04:21:00 | Dade, Georgia, US | |
2022-02-11 | US | Georgia | Dade | 13083 | 3011 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-02-12 04:21:06 | Dade, Georgia, US | |
2022-02-07 | US | Virginia | Dickenson | 51051 | 3011 | 40 | 0 | 37.12560977 | -82.35124171 | 2022-02-08 04:21:15 | Dickenson, Virginia, US | |
2022-02-02 | US | Nebraska | Seward | 31159 | 3011 | 32 | 0 | 40.87241834 | -97.139673 | 2022-02-03 04:21:21 | Seward, Nebraska, US | |
2022-01-31 | US | Kentucky | Leslie | 21131 | 3011 | 39 | 0 | 37.09246661 | -83.37999606 | 2022-02-01 04:21:11 | Leslie, Kentucky, US | |
2022-01-26 | US | Georgia | Oglethorpe | 13221 | 3011 | 46 | 0 | 33.878629600000004 | -83.08278123 | 2022-01-27 04:21:19 | Oglethorpe, Georgia, US | |
2022-01-25 | US | North Dakota | Walsh | 38099 | 3011 | 34 | 0 | 48.36876964 | -97.72574783 | 2022-01-26 04:21:07 | Walsh, North Dakota, US | |
2022-01-24 | US | Mississippi | Walthall | 28147 | 3011 | 70 | 0 | 31.14971548 | -90.10446654 | 2022-01-25 04:21:05 | Walthall, Mississippi, US | |
2022-01-23 | US | Michigan | Manistee | 26101 | 3011 | 72 | 0 | 44.33352407 | -86.05626916 | 2022-01-24 04:21:12 | Manistee, Michigan, US | |
2022-01-22 | US | Michigan | Manistee | 26101 | 3011 | 72 | 0 | 44.33352407 | -86.05626916 | 2022-01-23 04:21:13 | Manistee, Michigan, US | |
2022-01-22 | Russia | Chukotka Autonomous Okrug | 3011 | 39 | 0 | 66.0006475 | 169.4900869 | 2022-01-23 04:21:13 | Chukotka Autonomous Okrug, Russia | |||
2022-01-21 | US | Michigan | Manistee | 26101 | 3011 | 72 | 0 | 44.33352407 | -86.05626916 | 2022-01-22 04:21:13 | Manistee, Michigan, US | |
2022-01-13 | US | Missouri | Livingston | 29117 | 3011 | 83 | 0 | 39.78110272 | -93.54645978 | 2022-01-14 04:21:54 | Livingston, Missouri, US | |
2022-01-11 | US | Mississippi | Yalobusha | 28161 | 3011 | 48 | 0 | 34.02824175 | -89.70762049999998 | 2022-01-12 04:21:44 | Yalobusha, Mississippi, US | |
2022-01-11 | US | Mississippi | Smith | 28129 | 3011 | 54 | 0 | 32.01744532 | -89.50644846 | 2022-01-12 04:21:44 | Smith, Mississippi, US | |
2022-01-07 | US | Texas | Falls | 48145 | 3011 | 52 | 0 | 31.25350609 | -96.93630086 | 2022-01-08 04:21:53 | Falls, Texas, US | |
2021-12-30 | US | Wisconsin | Crawford | 55023 | 3011 | 25 | 0 | 43.23870316 | -90.93073686 | 2021-12-31 04:21:50 | Crawford, Wisconsin, US | |
2021-12-27 | US | North Carolina | Avery | 37011 | 3011 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-12-28 04:21:47 | Avery, North Carolina, US | |
2021-12-26 | US | North Carolina | Avery | 37011 | 3011 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-12-27 04:21:58 | Avery, North Carolina, US | |
2021-12-25 | US | Tennessee | Grundy | 47061 | 3011 | 64 | 0 | 35.38433717 | -85.72142731 | 2021-12-26 04:21:50 | Grundy, Tennessee, US | |
2021-12-25 | US | North Carolina | Avery | 37011 | 3011 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-12-26 04:21:50 | Avery, North Carolina, US | |
2021-12-24 | US | North Carolina | Avery | 37011 | 3011 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-12-25 04:21:37 | Avery, North Carolina, US | |
2021-12-23 | US | North Carolina | Avery | 37011 | 3011 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-12-24 04:21:34 | Avery, North Carolina, US | |
2021-12-22 | US | North Carolina | Avery | 37011 | 3011 | 39 | 0 | 36.07569796 | -81.92308483 | 2021-12-23 04:21:21 | Avery, North Carolina, US | |
2021-12-09 | US | Indiana | Franklin | 18047 | 3011 | 44 | 0 | 39.4142482 | -85.06062647 | 2021-12-10 04:22:28 | Franklin, Indiana, US | |
2021-12-02 | US | Kentucky | Morgan | 21175 | 3011 | 11 | 0 | 37.92465657 | -83.25558245 | 2021-12-03 04:23:05 | Morgan, Kentucky, US | |
2021-11-29 | US | Washington | Asotin | 53003 | 3011 | 50 | 0 | 46.18894415 | -117.2022851 | 2021-11-30 04:22:53 | Asotin, Washington, US | |
2021-11-29 | US | Mississippi | Clarke | 28023 | 3011 | 95 | 0 | 32.04158545 | -88.68896219999998 | 2021-11-30 04:22:53 | Clarke, Mississippi, US | |
2021-11-28 | US | Mississippi | Clarke | 28023 | 3011 | 95 | 0 | 32.04158545 | -88.68896219999998 | 2021-11-29 04:22:30 | Clarke, Mississippi, US | |
2021-11-27 | US | Mississippi | Clarke | 28023 | 3011 | 95 | 0 | 32.04158545 | -88.68896219999998 | 2021-11-28 04:22:43 | Clarke, Mississippi, US | |
2021-11-26 | US | Mississippi | Clarke | 28023 | 3011 | 95 | 0 | 32.04158545 | -88.68896219999998 | 2021-11-27 04:22:45 | Clarke, Mississippi, US | |
2021-11-25 | US | Mississippi | Clarke | 28023 | 3011 | 95 | 0 | 32.04158545 | -88.68896219999998 | 2021-11-26 04:22:33 | Clarke, Mississippi, US | |
2021-11-24 | US | Mississippi | Clarke | 28023 | 3011 | 95 | 0 | 32.04158545 | -88.68896219999998 | 2021-11-25 04:22:33 | Clarke, Mississippi, US | |
2021-11-18 | US | Florida | Calhoun | 12013 | 3011 | 45 | 0 | 30.40666734 | -85.19394153 | 2021-11-19 04:21:40 | Calhoun, Florida, US | |
2021-11-17 | US | Florida | Calhoun | 12013 | 3011 | 45 | 0 | 30.40666734 | -85.19394153 | 2021-11-18 04:21:33 | Calhoun, Florida, US | |
2021-11-16 | US | Florida | Calhoun | 12013 | 3011 | 45 | 0 | 30.40666734 | -85.19394153 | 2021-11-17 04:21:48 | Calhoun, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;