daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
306 rows where confirmed = 2666 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-28 | US | Mississippi | Benton | 28009 | 2666 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-11-29 04:21:05 | Benton, Mississippi, US | |
2022-11-27 | US | Texas | Runnels | 48399 | 2666 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-11-28 04:21:02 | Runnels, Texas, US | |
2022-11-26 | US | Texas | Runnels | 48399 | 2666 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-11-27 04:21:05 | Runnels, Texas, US | |
2022-11-25 | US | Texas | Runnels | 48399 | 2666 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-11-26 04:21:11 | Runnels, Texas, US | |
2022-11-24 | US | Texas | Runnels | 48399 | 2666 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-11-25 04:21:06 | Runnels, Texas, US | |
2022-11-23 | US | Texas | Runnels | 48399 | 2666 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-11-24 04:21:09 | Runnels, Texas, US | |
2022-10-20 | US | New Mexico | Colfax | 35007 | 2666 | 67 | 0 | 36.60569702 | -104.6472674 | 2022-10-21 04:22:23 | Colfax, New Mexico, US | |
2022-10-19 | US | New Mexico | Colfax | 35007 | 2666 | 67 | 0 | 36.60569702 | -104.6472674 | 2022-10-20 04:22:59 | Colfax, New Mexico, US | |
2022-10-18 | US | New Mexico | Colfax | 35007 | 2666 | 67 | 0 | 36.60569702 | -104.6472674 | 2022-10-19 04:22:26 | Colfax, New Mexico, US | |
2022-10-17 | US | New Mexico | Colfax | 35007 | 2666 | 67 | 0 | 36.60569702 | -104.6472674 | 2022-10-18 04:22:42 | Colfax, New Mexico, US | |
2022-10-11 | US | Idaho | Benewah | 16009 | 2666 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-10-12 04:22:51 | Benewah, Idaho, US | |
2022-10-10 | US | Idaho | Benewah | 16009 | 2666 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-10-11 04:23:05 | Benewah, Idaho, US | |
2022-10-09 | US | Idaho | Benewah | 16009 | 2666 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-10-10 04:22:32 | Benewah, Idaho, US | |
2022-10-08 | US | Idaho | Benewah | 16009 | 2666 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-10-09 04:21:16 | Benewah, Idaho, US | |
2022-10-07 | US | Idaho | Benewah | 16009 | 2666 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-10-08 04:22:56 | Benewah, Idaho, US | |
2022-10-06 | US | Idaho | Benewah | 16009 | 2666 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-10-07 04:23:08 | Benewah, Idaho, US | |
2022-10-05 | US | Idaho | Benewah | 16009 | 2666 | 42 | 0 | 47.21754179 | -116.6586851 | 2022-10-06 04:21:22 | Benewah, Idaho, US | |
2022-09-27 | US | Kansas | Coffey | 20031 | 2666 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-09-28 04:23:01 | Coffey, Kansas, US | |
2022-09-26 | US | Kansas | Coffey | 20031 | 2666 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-09-27 04:23:01 | Coffey, Kansas, US | |
2022-09-25 | US | Kansas | Coffey | 20031 | 2666 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-09-26 04:20:52 | Coffey, Kansas, US | |
2022-09-24 | US | Kansas | Coffey | 20031 | 2666 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-09-25 04:23:31 | Coffey, Kansas, US | |
2022-09-23 | US | Kansas | Coffey | 20031 | 2666 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-09-24 04:21:40 | Coffey, Kansas, US | |
2022-09-22 | US | Kansas | Coffey | 20031 | 2666 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-09-23 04:23:13 | Coffey, Kansas, US | |
2022-09-21 | US | Kansas | Coffey | 20031 | 2666 | 44 | 0 | 38.2365018 | -95.73379515 | 2022-09-22 04:22:56 | Coffey, Kansas, US | |
2022-09-07 | US | Illinois | Brown | 17009 | 2666 | 16 | 0 | 39.96209138 | -90.75068024 | 2022-09-08 04:21:02 | Brown, Illinois, US | |
2022-09-06 | US | Georgia | Towns | 13281 | 2666 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-09-07 04:20:59 | Towns, Georgia, US | |
2022-09-05 | US | Georgia | Towns | 13281 | 2666 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-09-06 04:21:02 | Towns, Georgia, US | |
2022-09-04 | US | Georgia | Towns | 13281 | 2666 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-09-05 04:21:01 | Towns, Georgia, US | |
2022-09-03 | US | Georgia | Towns | 13281 | 2666 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-09-04 04:21:22 | Towns, Georgia, US | |
2022-09-02 | US | Georgia | Towns | 13281 | 2666 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-09-03 04:21:04 | Towns, Georgia, US | |
2022-09-01 | US | Georgia | Towns | 13281 | 2666 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-09-02 04:21:07 | Towns, Georgia, US | |
2022-08-31 | US | Georgia | Towns | 13281 | 2666 | 118 | 0 | 34.91369188 | -83.7410746 | 2022-09-01 04:21:03 | Towns, Georgia, US | |
2022-08-18 | US | Missouri | Howard | 29089 | 2666 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-08-19 04:20:54 | Howard, Missouri, US | |
2022-08-17 | US | Missouri | Howard | 29089 | 2666 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-08-18 04:21:11 | Howard, Missouri, US | |
2022-08-16 | US | Missouri | Howard | 29089 | 2666 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-08-17 04:20:59 | Howard, Missouri, US | |
2022-08-15 | US | Missouri | Howard | 29089 | 2666 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-08-16 04:20:58 | Howard, Missouri, US | |
2022-08-14 | US | Missouri | Howard | 29089 | 2666 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-08-15 04:20:59 | Howard, Missouri, US | |
2022-08-13 | US | Missouri | Howard | 29089 | 2666 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-08-14 04:20:55 | Howard, Missouri, US | |
2022-08-12 | US | Missouri | Howard | 29089 | 2666 | 30 | 0 | 39.1435761 | -92.69756691 | 2022-08-13 04:20:52 | Howard, Missouri, US | |
2022-08-04 | US | Virginia | Richmond | 51159 | 2666 | 25 | 0 | 37.937575 | -76.72920628 | 2022-08-05 04:20:52 | Richmond, Virginia, US | |
2022-07-21 | US | Missouri | Douglas | 29067 | 2666 | 81 | 0 | 36.9325593 | -92.49905109 | 2022-07-22 04:21:15 | Douglas, Missouri, US | |
2022-07-20 | US | Missouri | Douglas | 29067 | 2666 | 81 | 0 | 36.9325593 | -92.49905109 | 2022-07-21 04:21:10 | Douglas, Missouri, US | |
2022-07-20 | US | Arkansas | Perry | 5105 | 2666 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-07-21 04:21:10 | Perry, Arkansas, US | |
2022-07-19 | US | Missouri | Douglas | 29067 | 2666 | 81 | 0 | 36.9325593 | -92.49905109 | 2022-07-20 04:20:59 | Douglas, Missouri, US | |
2022-07-19 | US | Iowa | Grundy | 19075 | 2666 | 44 | 0 | 42.40183723 | -92.78829551 | 2022-07-20 04:20:59 | Grundy, Iowa, US | |
2022-07-18 | US | Missouri | Douglas | 29067 | 2666 | 81 | 0 | 36.9325593 | -92.49905109 | 2022-07-19 04:20:58 | Douglas, Missouri, US | |
2022-07-18 | US | Iowa | Grundy | 19075 | 2666 | 44 | 0 | 42.40183723 | -92.78829551 | 2022-07-19 04:20:58 | Grundy, Iowa, US | |
2022-07-17 | US | Missouri | Douglas | 29067 | 2666 | 81 | 0 | 36.9325593 | -92.49905109 | 2022-07-18 04:20:59 | Douglas, Missouri, US | |
2022-07-17 | US | Iowa | Grundy | 19075 | 2666 | 44 | 0 | 42.40183723 | -92.78829551 | 2022-07-18 04:20:59 | Grundy, Iowa, US | |
2022-07-17 | US | Indiana | Crawford | 18025 | 2666 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-07-18 04:20:59 | Crawford, Indiana, US | |
2022-07-16 | US | Missouri | Douglas | 29067 | 2666 | 81 | 0 | 36.9325593 | -92.49905109 | 2022-07-17 04:21:15 | Douglas, Missouri, US | |
2022-07-16 | US | Iowa | Grundy | 19075 | 2666 | 44 | 0 | 42.40183723 | -92.78829551 | 2022-07-17 04:21:15 | Grundy, Iowa, US | |
2022-07-16 | US | Indiana | Crawford | 18025 | 2666 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-07-17 04:21:15 | Crawford, Indiana, US | |
2022-07-15 | US | Missouri | Douglas | 29067 | 2666 | 81 | 0 | 36.9325593 | -92.49905109 | 2022-07-16 04:21:05 | Douglas, Missouri, US | |
2022-07-15 | US | Iowa | Grundy | 19075 | 2666 | 44 | 0 | 42.40183723 | -92.78829551 | 2022-07-16 04:21:05 | Grundy, Iowa, US | |
2022-07-15 | US | Indiana | Crawford | 18025 | 2666 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-07-16 04:21:05 | Crawford, Indiana, US | |
2022-07-14 | US | Iowa | Grundy | 19075 | 2666 | 44 | 0 | 42.40183723 | -92.78829551 | 2022-07-15 04:20:53 | Grundy, Iowa, US | |
2022-07-13 | US | Iowa | Grundy | 19075 | 2666 | 44 | 0 | 42.40183723 | -92.78829551 | 2022-07-14 04:20:57 | Grundy, Iowa, US | |
2022-07-07 | US | North Dakota | Mercer | 38057 | 2666 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-07-08 04:20:56 | Mercer, North Dakota, US | |
2022-07-06 | US | North Dakota | Mercer | 38057 | 2666 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-07-07 04:20:55 | Mercer, North Dakota, US | |
2022-06-30 | US | Montana | Deer Lodge | 30023 | 2666 | 29 | 0 | 46.05953325 | -113.073353 | 2022-07-01 04:21:10 | Deer Lodge, Montana, US | |
2022-06-29 | US | Montana | Deer Lodge | 30023 | 2666 | 29 | 0 | 46.05953325 | -113.073353 | 2022-06-30 04:21:01 | Deer Lodge, Montana, US | |
2022-06-28 | US | Montana | Deer Lodge | 30023 | 2666 | 29 | 0 | 46.05953325 | -113.073353 | 2022-06-29 04:20:59 | Deer Lodge, Montana, US | |
2022-06-27 | US | Montana | Deer Lodge | 30023 | 2666 | 29 | 0 | 46.05953325 | -113.073353 | 2022-06-28 04:20:58 | Deer Lodge, Montana, US | |
2022-06-26 | US | Texas | Childress | 48075 | 2666 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-06-27 04:21:00 | Childress, Texas, US | |
2022-06-26 | US | Montana | Deer Lodge | 30023 | 2666 | 29 | 0 | 46.05953325 | -113.073353 | 2022-06-27 04:21:00 | Deer Lodge, Montana, US | |
2022-06-25 | US | Montana | Deer Lodge | 30023 | 2666 | 29 | 0 | 46.05953325 | -113.073353 | 2022-06-26 04:21:02 | Deer Lodge, Montana, US | |
2022-06-24 | US | Montana | Deer Lodge | 30023 | 2666 | 29 | 0 | 46.05953325 | -113.073353 | 2022-06-25 04:20:57 | Deer Lodge, Montana, US | |
2022-05-31 | US | Georgia | Stewart | 13259 | 2666 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-06-01 04:20:55 | Stewart, Georgia, US | |
2022-05-30 | US | Georgia | Stewart | 13259 | 2666 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-05-31 04:20:51 | Stewart, Georgia, US | |
2022-05-29 | US | Georgia | Stewart | 13259 | 2666 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-05-30 04:20:50 | Stewart, Georgia, US | |
2022-05-28 | US | Georgia | Stewart | 13259 | 2666 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-05-29 04:20:53 | Stewart, Georgia, US | |
2022-05-27 | US | Georgia | Stewart | 13259 | 2666 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-05-28 04:21:07 | Stewart, Georgia, US | |
2022-05-26 | US | Georgia | Stewart | 13259 | 2666 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-05-27 04:20:56 | Stewart, Georgia, US | |
2022-05-25 | US | Georgia | Stewart | 13259 | 2666 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-05-26 04:20:50 | Stewart, Georgia, US | |
2022-05-22 | US | Georgia | Stewart | 13259 | 2666 | 35 | 0 | 32.07996777 | -84.83208037 | 2022-05-26 04:20:50 | Stewart, Georgia, US | |
2022-05-09 | US | Virginia | Clarke | 51043 | 2666 | 42 | 0 | 39.11271747 | -77.99199425 | 2022-05-10 04:20:50 | Clarke, Virginia, US | |
2022-05-08 | US | Virginia | Amelia | 51007 | 2666 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-05-09 04:20:54 | Amelia, Virginia, US | |
2022-05-07 | US | Virginia | Amelia | 51007 | 2666 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-05-08 04:20:49 | Amelia, Virginia, US | |
2022-05-06 | US | Virginia | Amelia | 51007 | 2666 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-05-07 04:21:09 | Amelia, Virginia, US | |
2022-04-05 | US | Puerto Rico | Orocovis | 72107 | 2666 | 0 | 0 | 18.215046 | -66.433604 | 2022-04-06 04:20:49 | Orocovis, Puerto Rico, US | |
2022-03-23 | US | New Mexico | Torrance | 35057 | 2666 | 52 | 0 | 34.64048375 | -105.8508949 | 2022-03-24 04:20:43 | Torrance, New Mexico, US | |
2022-03-14 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-15 04:20:47 | Forest, Wisconsin, US | |
2022-03-13 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-14 04:20:46 | Forest, Wisconsin, US | |
2022-03-12 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-13 04:20:49 | Forest, Wisconsin, US | |
2022-03-11 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-12 04:20:50 | Forest, Wisconsin, US | |
2022-03-10 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-11 04:20:50 | Forest, Wisconsin, US | |
2022-03-09 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-10 04:20:48 | Forest, Wisconsin, US | |
2022-03-08 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-09 04:20:59 | Forest, Wisconsin, US | |
2022-03-07 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-08 04:20:54 | Forest, Wisconsin, US | |
2022-03-07 | US | Tennessee | Houston | 47083 | 2666 | 59 | 0 | 36.28872054 | -87.71878828 | 2022-03-08 04:20:54 | Houston, Tennessee, US | |
2022-03-06 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-07 04:20:47 | Forest, Wisconsin, US | |
2022-03-05 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-06 04:20:49 | Forest, Wisconsin, US | |
2022-03-04 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-05 04:21:10 | Forest, Wisconsin, US | |
2022-03-03 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-04 04:21:09 | Forest, Wisconsin, US | |
2022-03-02 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-03 04:21:01 | Forest, Wisconsin, US | |
2022-03-01 | US | Wisconsin | Forest | 55041 | 2666 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-02 04:21:07 | Forest, Wisconsin, US | |
2022-03-01 | US | Minnesota | Koochiching | 27071 | 2666 | 34 | 0 | 48.24539665 | -93.78352843 | 2022-03-02 04:21:07 | Koochiching, Minnesota, US | |
2022-02-28 | US | Illinois | Jasper | 17079 | 2666 | 26 | 0 | 39.01054275 | -88.15437049 | 2022-03-01 04:21:09 | Jasper, Illinois, US | |
2022-02-28 | China | Henan | 2666 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-03-01 04:21:09 | Henan, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;