daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
344 rows where confirmed = 2867 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-11-29 | US | Kansas | Thomas | 20193 | 2867 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-30 04:21:07 | Thomas, Kansas, US | |
2022-11-28 | US | Kansas | Thomas | 20193 | 2867 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-29 04:21:05 | Thomas, Kansas, US | |
2022-11-27 | US | Kansas | Thomas | 20193 | 2867 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-28 04:21:02 | Thomas, Kansas, US | |
2022-11-26 | US | Kansas | Thomas | 20193 | 2867 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-27 04:21:05 | Thomas, Kansas, US | |
2022-11-25 | US | Kansas | Thomas | 20193 | 2867 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-26 04:21:11 | Thomas, Kansas, US | |
2022-11-24 | US | Kansas | Thomas | 20193 | 2867 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-25 04:21:06 | Thomas, Kansas, US | |
2022-11-23 | US | Kansas | Thomas | 20193 | 2867 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-24 04:21:09 | Thomas, Kansas, US | |
2022-11-14 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-15 04:21:16 | Colfax, Nebraska, US | |
2022-11-13 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-14 04:21:09 | Colfax, Nebraska, US | |
2022-11-12 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-13 04:21:14 | Colfax, Nebraska, US | |
2022-11-11 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-12 04:20:41 | Colfax, Nebraska, US | |
2022-11-10 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-11 04:21:22 | Colfax, Nebraska, US | |
2022-11-09 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-10 04:21:16 | Colfax, Nebraska, US | |
2022-11-08 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-09 04:21:22 | Colfax, Nebraska, US | |
2022-11-07 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-08 04:21:21 | Colfax, Nebraska, US | |
2022-11-06 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-07 04:21:26 | Colfax, Nebraska, US | |
2022-11-05 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-06 04:21:24 | Colfax, Nebraska, US | |
2022-11-04 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-05 04:21:52 | Colfax, Nebraska, US | |
2022-11-03 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-04 04:22:11 | Colfax, Nebraska, US | |
2022-11-02 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-03 04:22:05 | Colfax, Nebraska, US | |
2022-11-01 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-02 04:22:09 | Colfax, Nebraska, US | |
2022-10-31 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-11-01 04:22:36 | Colfax, Nebraska, US | |
2022-10-31 | US | Michigan | Mackinac | 26097 | 2867 | 36 | 0 | 46.07028979 | -85.04980537 | 2022-11-01 04:22:36 | Mackinac, Michigan, US | |
2022-10-30 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-10-31 04:21:36 | Colfax, Nebraska, US | |
2022-10-30 | US | Michigan | Mackinac | 26097 | 2867 | 36 | 0 | 46.07028979 | -85.04980537 | 2022-10-31 04:21:36 | Mackinac, Michigan, US | |
2022-10-29 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-10-30 04:22:14 | Colfax, Nebraska, US | |
2022-10-29 | US | Michigan | Mackinac | 26097 | 2867 | 36 | 0 | 46.07028979 | -85.04980537 | 2022-10-30 04:22:14 | Mackinac, Michigan, US | |
2022-10-28 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-10-29 04:21:13 | Colfax, Nebraska, US | |
2022-10-28 | US | Michigan | Mackinac | 26097 | 2867 | 36 | 0 | 46.07028979 | -85.04980537 | 2022-10-29 04:21:13 | Mackinac, Michigan, US | |
2022-10-27 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-10-28 04:22:31 | Colfax, Nebraska, US | |
2022-10-27 | US | Michigan | Mackinac | 26097 | 2867 | 36 | 0 | 46.07028979 | -85.04980537 | 2022-10-28 04:22:31 | Mackinac, Michigan, US | |
2022-10-26 | US | Nebraska | Colfax | 31037 | 2867 | 31 | 0 | 41.57486951 | -97.0868542 | 2022-10-27 04:22:01 | Colfax, Nebraska, US | |
2022-10-26 | US | Michigan | Mackinac | 26097 | 2867 | 36 | 0 | 46.07028979 | -85.04980537 | 2022-10-27 04:22:01 | Mackinac, Michigan, US | |
2022-10-25 | US | Michigan | Mackinac | 26097 | 2867 | 36 | 0 | 46.07028979 | -85.04980537 | 2022-10-26 04:22:19 | Mackinac, Michigan, US | |
2022-10-24 | US | Arkansas | Perry | 5105 | 2867 | 40 | 0 | 34.9459153 | -92.94372564 | 2022-10-25 04:21:53 | Perry, Arkansas, US | |
2022-10-23 | US | Arkansas | Perry | 5105 | 2867 | 40 | 0 | 34.9459153 | -92.94372564 | 2022-10-24 04:22:29 | Perry, Arkansas, US | |
2022-10-22 | US | Arkansas | Perry | 5105 | 2867 | 40 | 0 | 34.9459153 | -92.94372564 | 2022-10-23 04:22:46 | Perry, Arkansas, US | |
2022-10-16 | US | North Dakota | Mercer | 38057 | 2867 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-10-17 04:20:31 | Mercer, North Dakota, US | |
2022-10-15 | US | North Dakota | Mercer | 38057 | 2867 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-10-16 04:22:39 | Mercer, North Dakota, US | |
2022-10-06 | US | Missouri | Montgomery | 29139 | 2867 | 61 | 0 | 38.94022054 | -91.47000721 | 2022-10-07 04:23:08 | Montgomery, Missouri, US | |
2022-10-05 | US | Missouri | Montgomery | 29139 | 2867 | 61 | 0 | 38.94022054 | -91.47000721 | 2022-10-06 04:21:22 | Montgomery, Missouri, US | |
2022-10-04 | US | Missouri | Montgomery | 29139 | 2867 | 61 | 0 | 38.94022054 | -91.47000721 | 2022-10-05 04:23:06 | Montgomery, Missouri, US | |
2022-10-03 | US | Missouri | Montgomery | 29139 | 2867 | 61 | 0 | 38.94022054 | -91.47000721 | 2022-10-04 04:22:55 | Montgomery, Missouri, US | |
2022-10-02 | US | Missouri | Montgomery | 29139 | 2867 | 61 | 0 | 38.94022054 | -91.47000721 | 2022-10-03 04:23:11 | Montgomery, Missouri, US | |
2022-10-01 | US | Missouri | Montgomery | 29139 | 2867 | 61 | 0 | 38.94022054 | -91.47000721 | 2022-10-02 04:21:23 | Montgomery, Missouri, US | |
2022-09-30 | US | Missouri | Montgomery | 29139 | 2867 | 61 | 0 | 38.94022054 | -91.47000721 | 2022-10-01 04:23:01 | Montgomery, Missouri, US | |
2022-09-08 | US | Missouri | Linn | 29115 | 2867 | 69 | 0 | 39.87001769 | -93.10704106 | 2022-09-09 04:21:11 | Linn, Missouri, US | |
2022-09-07 | US | Missouri | Linn | 29115 | 2867 | 69 | 0 | 39.87001769 | -93.10704106 | 2022-09-08 04:21:02 | Linn, Missouri, US | |
2022-09-06 | US | Missouri | Linn | 29115 | 2867 | 69 | 0 | 39.87001769 | -93.10704106 | 2022-09-07 04:20:59 | Linn, Missouri, US | |
2022-09-05 | US | Missouri | Linn | 29115 | 2867 | 69 | 0 | 39.87001769 | -93.10704106 | 2022-09-06 04:21:02 | Linn, Missouri, US | |
2022-09-05 | US | Kentucky | Hancock | 21091 | 2867 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-06 04:21:02 | Hancock, Kentucky, US | |
2022-09-04 | US | Missouri | Linn | 29115 | 2867 | 69 | 0 | 39.87001769 | -93.10704106 | 2022-09-05 04:21:01 | Linn, Missouri, US | |
2022-09-04 | US | Kentucky | Hancock | 21091 | 2867 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-05 04:21:01 | Hancock, Kentucky, US | |
2022-09-03 | US | Missouri | Linn | 29115 | 2867 | 69 | 0 | 39.87001769 | -93.10704106 | 2022-09-04 04:21:22 | Linn, Missouri, US | |
2022-09-03 | US | Kentucky | Hancock | 21091 | 2867 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-04 04:21:22 | Hancock, Kentucky, US | |
2022-09-02 | US | Tennessee | Houston | 47083 | 2867 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-09-03 04:21:04 | Houston, Tennessee, US | |
2022-09-02 | US | Missouri | Linn | 29115 | 2867 | 69 | 0 | 39.87001769 | -93.10704106 | 2022-09-03 04:21:04 | Linn, Missouri, US | |
2022-09-02 | US | Kentucky | Hancock | 21091 | 2867 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-03 04:21:04 | Hancock, Kentucky, US | |
2022-09-01 | US | Kentucky | Hancock | 21091 | 2867 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-02 04:21:07 | Hancock, Kentucky, US | |
2022-09-01 | US | Colorado | Prowers | 8099 | 2867 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-09-02 04:21:07 | Prowers, Colorado, US | |
2022-08-31 | US | Oklahoma | Hughes | 40063 | 2867 | 63 | 0 | 35.04912569 | -96.24921145 | 2022-09-01 04:21:03 | Hughes, Oklahoma, US | |
2022-08-31 | US | Kentucky | Hancock | 21091 | 2867 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-09-01 04:21:03 | Hancock, Kentucky, US | |
2022-08-30 | US | Texas | Terry | 48445 | 2867 | 85 | 0 | 33.17402785 | -102.3354521 | 2022-08-31 04:20:57 | Terry, Texas, US | |
2022-08-30 | US | Oklahoma | Hughes | 40063 | 2867 | 63 | 0 | 35.04912569 | -96.24921145 | 2022-08-31 04:20:57 | Hughes, Oklahoma, US | |
2022-08-30 | US | Kentucky | Hancock | 21091 | 2867 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-08-31 04:20:57 | Hancock, Kentucky, US | |
2022-08-29 | US | Oklahoma | Hughes | 40063 | 2867 | 63 | 0 | 35.04912569 | -96.24921145 | 2022-08-30 04:21:03 | Hughes, Oklahoma, US | |
2022-08-29 | US | Kentucky | Hancock | 21091 | 2867 | 27 | 0 | 37.83766422 | -86.78280584 | 2022-08-30 04:21:03 | Hancock, Kentucky, US | |
2022-08-28 | US | Oklahoma | Hughes | 40063 | 2867 | 63 | 0 | 35.04912569 | -96.24921145 | 2022-08-29 04:21:06 | Hughes, Oklahoma, US | |
2022-08-27 | US | Oklahoma | Hughes | 40063 | 2867 | 63 | 0 | 35.04912569 | -96.24921145 | 2022-08-28 04:21:02 | Hughes, Oklahoma, US | |
2022-08-26 | US | Oklahoma | Hughes | 40063 | 2867 | 63 | 0 | 35.04912569 | -96.24921145 | 2022-08-27 04:20:57 | Hughes, Oklahoma, US | |
2022-08-25 | US | Oklahoma | Hughes | 40063 | 2867 | 63 | 0 | 35.04912569 | -96.24921145 | 2022-08-26 04:21:02 | Hughes, Oklahoma, US | |
2022-08-25 | US | Montana | Deer Lodge | 30023 | 2867 | 30 | 0 | 46.05953325 | -113.073353 | 2022-08-26 04:21:02 | Deer Lodge, Montana, US | |
2022-08-25 | US | Missouri | Bollinger | 29017 | 2867 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-26 04:21:02 | Bollinger, Missouri, US | |
2022-08-24 | US | Oklahoma | Washita | 40149 | 2867 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-25 04:21:13 | Washita, Oklahoma, US | |
2022-08-24 | US | Montana | Deer Lodge | 30023 | 2867 | 30 | 0 | 46.05953325 | -113.073353 | 2022-08-25 04:21:13 | Deer Lodge, Montana, US | |
2022-08-24 | US | Missouri | Bollinger | 29017 | 2867 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-25 04:21:13 | Bollinger, Missouri, US | |
2022-08-23 | US | Oklahoma | Washita | 40149 | 2867 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-24 04:20:46 | Washita, Oklahoma, US | |
2022-08-23 | US | Montana | Deer Lodge | 30023 | 2867 | 30 | 0 | 46.05953325 | -113.073353 | 2022-08-24 04:20:46 | Deer Lodge, Montana, US | |
2022-08-23 | US | Missouri | Bollinger | 29017 | 2867 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-24 04:20:46 | Bollinger, Missouri, US | |
2022-08-22 | US | Oklahoma | Washita | 40149 | 2867 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-23 04:20:56 | Washita, Oklahoma, US | |
2022-08-22 | US | Montana | Deer Lodge | 30023 | 2867 | 30 | 0 | 46.05953325 | -113.073353 | 2022-08-23 04:20:56 | Deer Lodge, Montana, US | |
2022-08-22 | US | Missouri | Bollinger | 29017 | 2867 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-23 04:20:56 | Bollinger, Missouri, US | |
2022-08-21 | US | Oklahoma | Washita | 40149 | 2867 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-22 04:20:38 | Washita, Oklahoma, US | |
2022-08-21 | US | Montana | Deer Lodge | 30023 | 2867 | 30 | 0 | 46.05953325 | -113.073353 | 2022-08-22 04:20:38 | Deer Lodge, Montana, US | |
2022-08-21 | US | Missouri | Bollinger | 29017 | 2867 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-22 04:20:38 | Bollinger, Missouri, US | |
2022-08-20 | US | Oklahoma | Washita | 40149 | 2867 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-21 04:20:44 | Washita, Oklahoma, US | |
2022-08-20 | US | Montana | Deer Lodge | 30023 | 2867 | 30 | 0 | 46.05953325 | -113.073353 | 2022-08-21 04:20:44 | Deer Lodge, Montana, US | |
2022-08-20 | US | Missouri | Bollinger | 29017 | 2867 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-21 04:20:44 | Bollinger, Missouri, US | |
2022-08-19 | US | Oklahoma | Washita | 40149 | 2867 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-20 04:21:01 | Washita, Oklahoma, US | |
2022-08-19 | US | Montana | Deer Lodge | 30023 | 2867 | 30 | 0 | 46.05953325 | -113.073353 | 2022-08-20 04:21:01 | Deer Lodge, Montana, US | |
2022-08-19 | US | Missouri | Bollinger | 29017 | 2867 | 44 | 0 | 37.32449052 | -90.02725304 | 2022-08-20 04:21:01 | Bollinger, Missouri, US | |
2022-08-18 | US | Oklahoma | Washita | 40149 | 2867 | 56 | 0 | 35.29071824 | -98.99180434 | 2022-08-19 04:20:54 | Washita, Oklahoma, US | |
2022-08-07 | US | Texas | Blanco | 48031 | 2867 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-08-08 04:21:08 | Blanco, Texas, US | |
2022-08-06 | US | Texas | Blanco | 48031 | 2867 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-08-07 04:20:54 | Blanco, Texas, US | |
2022-08-05 | US | Texas | Blanco | 48031 | 2867 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-08-06 04:20:56 | Blanco, Texas, US | |
2022-07-27 | US | Louisiana | Catahoula | 22025 | 2867 | 57 | 0 | 31.66778967 | -91.84526385 | 2022-07-28 04:20:56 | Catahoula, Louisiana, US | |
2022-07-17 | US | Arkansas | Chicot | 5017 | 2867 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-07-18 04:20:59 | Chicot, Arkansas, US | |
2022-06-30 | US | New Mexico | Torrance | 35057 | 2867 | 58 | 0 | 34.64048375 | -105.8508949 | 2022-07-01 04:21:10 | Torrance, New Mexico, US | |
2022-06-26 | US | Texas | Ward | 48475 | 2867 | 44 | 0 | 31.50999644 | -103.0927909 | 2022-06-27 04:21:00 | Ward, Texas, US | |
2022-06-26 | US | Texas | Jim Hogg | 48247 | 2867 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-06-27 04:21:00 | Jim Hogg, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;