johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
38 rows where confirmed = 14120 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2273875 | 2273875 | 2022-10-20 | US | Missouri | Pettis | 29159 | 14120 | 179 | 0 | 38.72798918 | -93.28471706 | 2022-10-21 04:22:23 | Pettis, Missouri, US | |
200210 | 200210 | 2022-10-19 | US | Missouri | Pettis | 29159 | 14120 | 179 | 0 | 38.72798918 | -93.28471706 | 2022-10-20 04:22:59 | Pettis, Missouri, US | |
2758871 | 2758871 | 2022-10-18 | US | Missouri | Pettis | 29159 | 14120 | 179 | 0 | 38.72798918 | -93.28471706 | 2022-10-19 04:22:26 | Pettis, Missouri, US | |
2026705 | 2026705 | 2022-10-17 | US | Missouri | Pettis | 29159 | 14120 | 179 | 0 | 38.72798918 | -93.28471706 | 2022-10-18 04:22:42 | Pettis, Missouri, US | |
2161483 | 2161483 | 2022-10-16 | US | Missouri | Pettis | 29159 | 14120 | 179 | 0 | 38.72798918 | -93.28471706 | 2022-10-17 04:20:31 | Pettis, Missouri, US | |
517680 | 517680 | 2022-10-15 | US | Missouri | Pettis | 29159 | 14120 | 179 | 0 | 38.72798918 | -93.28471706 | 2022-10-16 04:22:39 | Pettis, Missouri, US | |
2034737 | 2034737 | 2022-10-14 | US | Missouri | Pettis | 29159 | 14120 | 179 | 0 | 38.72798918 | -93.28471706 | 2022-10-15 04:22:00 | Pettis, Missouri, US | |
2346703 | 2346703 | 2022-08-31 | US | Utah | TriCounty | 14120 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-09-01 04:21:03 | TriCounty, Utah, US | ||
3777183 | 3777183 | 2022-08-30 | US | Utah | TriCounty | 14120 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-08-31 04:20:57 | TriCounty, Utah, US | ||
1683779 | 1683779 | 2022-08-29 | US | Utah | TriCounty | 14120 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-08-30 04:21:03 | TriCounty, Utah, US | ||
1880263 | 1880263 | 2022-08-28 | US | Utah | TriCounty | 14120 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-08-29 04:21:06 | TriCounty, Utah, US | ||
2099390 | 2099390 | 2022-08-27 | US | Utah | TriCounty | 14120 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-08-28 04:21:02 | TriCounty, Utah, US | ||
1535205 | 1535205 | 2022-08-26 | US | Utah | TriCounty | 14120 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-08-27 04:20:57 | TriCounty, Utah, US | ||
2832092 | 2832092 | 2022-08-25 | US | Utah | TriCounty | 14120 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-08-26 04:21:02 | TriCounty, Utah, US | ||
169574 | 169574 | 2022-06-21 | US | Wisconsin | Barron | 55005 | 14120 | 146 | 0 | 45.42372701 | -91.84833627 | 2022-06-22 04:20:54 | Barron, Wisconsin, US | |
2665506 | 2665506 | 2022-03-04 | Bhutan | 14120 | 6 | 0 | 27.5142 | 90.4336 | 2022-03-05 04:21:10 | Bhutan | ||||
189315 | 189315 | 2022-02-13 | US | Texas | Val Verde | 48465 | 14120 | 274 | 0 | 29.89149232 | -101.1525205 | 2022-02-14 04:20:51 | Val Verde, Texas, US | |
1467051 | 1467051 | 2022-02-10 | US | Tennessee | Loudon | 47105 | 14120 | 174 | 0 | 35.73939663 | -84.31145275 | 2022-02-11 04:21:09 | Loudon, Tennessee, US | |
1464675 | 1464675 | 2022-02-10 | US | California | Tehama | 6103 | 14120 | 149 | 0 | 40.12570935 | -122.23701709999999 | 2022-02-11 04:21:09 | Tehama, California, US | |
1143433 | 1143433 | 2022-01-23 | US | Ohio | Union | 39159 | 14120 | 88 | 0 | 40.30016061 | -83.37239023 | 2022-01-24 04:21:12 | Union, Ohio, US | |
3689168 | 3689168 | 2022-01-13 | US | Michigan | Shiawassee | 26155 | 14120 | 196 | 0 | 42.95392800000001 | -84.14585902 | 2022-01-14 04:21:54 | Shiawassee, Michigan, US | |
3614752 | 3614752 | 2022-01-12 | US | Michigan | Shiawassee | 26155 | 14120 | 196 | 0 | 42.95392800000001 | -84.14585902 | 2022-01-13 08:00:09 | Shiawassee, Michigan, US | |
1081486 | 1081486 | 2021-12-09 | US | Wisconsin | Manitowoc | 55071 | 14120 | 128 | 0 | 44.11946801 | -87.80928853 | 2021-12-10 04:22:28 | Manitowoc, Wisconsin, US | |
989814 | 989814 | 2021-10-04 | US | South Carolina | Orangeburg | 45075 | 14120 | 313 | 0 | 33.4391073 | -80.79886287 | 2021-10-05 04:21:27 | Orangeburg, South Carolina, US | |
3013160 | 3013160 | 2021-09-22 | US | Mississippi | Madison | 28089 | 14120 | 271 | 0 | 32.63389156 | -90.03513564 | 2021-09-23 04:21:43 | Madison, Mississippi, US | |
2695528 | 2695528 | 2021-07-06 | US | Mississippi | Rankin | 28121 | 14120 | 282 | 0 | 32.26469147 | -89.94537876 | 2021-07-07 04:21:20 | Rankin, Mississippi, US | |
3955490 | 3955490 | 2021-05-11 | US | Illinois | Kankakee | 17091 | 14120 | 209 | 0 | 41.13746989 | -87.86205334 | 2021-05-12 04:21:29 | Kankakee, Illinois, US | |
241436 | 241436 | 2021-04-02 | Russia | Adygea Republic | 14120 | 165 | 13420 | 535 | 44.6939006 | 40.1520421 | 2021-04-03 04:20:44 | Adygea Republic, Russia | ||
638128 | 638128 | 2021-03-31 | Russia | Kamchatka Krai | 14120 | 201 | 13212 | 707 | 57.1914882 | 160.03838190000005 | 2021-04-01 04:27:05 | Kamchatka Krai, Russia | ||
3643942 | 3643942 | 2021-03-30 | US | Alabama | Morgan | 1103 | 14120 | 263 | 0 | 34.45500589 | -86.85475946 | 2021-03-31 04:26:25 | Morgan, Alabama, US | |
1841025 | 1841025 | 2021-03-12 | US | Texas | Guadalupe | 48187 | 14120 | 198 | 0 | 29.58165339 | -97.94786822 | 2021-03-13 05:25:15 | Guadalupe, Texas, US | |
12785 | 12785 | 2021-01-26 | US | Arizona | Navajo | 4017 | 14120 | 418 | 0 | 13702 | 35.3997715 | -110.3218983 | 2021-01-27 05:23:41 | Navajo, Arizona, US |
3880670 | 3880670 | 2021-01-14 | US | Indiana | Johnson | 18081 | 14120 | 302 | 0 | 13818 | 39.48994426 | -86.10149107 | 2021-01-15 05:22:24 | Johnson, Indiana, US |
2119918 | 2119918 | 2020-12-20 | Russia | Karachay-Cherkess Republic | 14120 | 38 | 12574 | 1508 | 43.7368326 | 41.7267991 | 2020-12-21 05:27:58 | Karachay-Cherkess Republic, Russia | ||
272187 | 272187 | 2020-11-10 | Japan | Osaka | 14120 | 256 | 12438 | 1426 | 34.620965000000005 | 135.507481 | 2020-11-11 05:25:30 | Osaka, Japan | ||
3781988 | 3781988 | 2020-10-13 | Mexico | Hidalgo | 14120 | 2103 | 11405 | 612 | 20.0911 | -98.7624 | 2020-10-14 04:24:05 | Hidalgo, Mexico | ||
1614676 | 1614676 | 2020-08-14 | US | Ohio | Cuyahoga | 39035 | 14120 | 501 | 0 | 13619 | 41.424119 | -81.65918339 | 2020-08-15 04:27:31 | Cuyahoga, Ohio, US |
3182699 | 3182699 | 2020-07-28 | US | California | Fresno | 6019 | 14120 | 125 | 0 | 13975 | 36.75733899 | -119.6466953 | 2020-07-29 04:35:11 | Fresno, California, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);