johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
23 rows where confirmed = 14569 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
259582 | 259582 | 2022-12-10 | US | New York | Montgomery | 36057 | 14569 | 226 | 0 | 42.90123494 | -74.44011632 | 2022-12-11 04:20:50 | Montgomery, New York, US | |
2687980 | 2687980 | 2022-10-03 | US | New York | Washington | 36115 | 14569 | 127 | 0 | 43.31153794 | -73.43043448 | 2022-10-04 04:22:55 | Washington, New York, US | |
1681512 | 1681512 | 2022-08-29 | US | Illinois | Knox | 17095 | 14569 | 224 | 0 | 40.93148779 | -90.2133034 | 2022-08-30 04:21:03 | Knox, Illinois, US | |
1251390 | 1251390 | 2022-08-23 | US | Colorado | La Plata | 8067 | 14569 | 90 | 0 | 37.28632032 | -107.8429014 | 2022-08-24 04:20:46 | La Plata, Colorado, US | |
3649822 | 3649822 | 2022-08-14 | US | New York | Fulton | 36035 | 14569 | 174 | 0 | 43.11363907 | -74.41798804 | 2022-08-15 04:20:59 | Fulton, New York, US | |
1575542 | 1575542 | 2022-05-03 | US | Virginia | Rockingham | 51165 | 14569 | 227 | 0 | 38.51006137 | -78.87260325 | 2022-05-04 04:20:59 | Rockingham, Virginia, US | |
2443526 | 2443526 | 2022-04-13 | US | Georgia | Catoosa | 13047 | 14569 | 162 | 0 | 34.89872298 | -85.13757014 | 2022-04-13 23:21:06 | Catoosa, Georgia, US | |
1579119 | 1579119 | 2022-04-10 | US | Tennessee | Loudon | 47105 | 14569 | 192 | 0 | 35.73939663 | -84.31145275 | 2022-04-11 04:21:02 | Loudon, Tennessee, US | |
3830816 | 3830816 | 2021-12-21 | US | North Carolina | Moore | 37125 | 14569 | 257 | 0 | 35.30885257 | -79.48474178 | 2021-12-22 04:21:54 | Moore, North Carolina, US | |
277761 | 277761 | 2021-11-03 | US | Maryland | Charles | 24017 | 14569 | 260 | 0 | 38.51092331 | -76.98580666 | 2021-11-04 04:22:20 | Charles, Maryland, US | |
1275244 | 1275244 | 2021-10-03 | US | Idaho | Twin Falls | 16083 | 14569 | 183 | 0 | 42.35440512 | -114.6685381 | 2021-10-04 04:21:31 | Twin Falls, Idaho, US | |
1442072 | 1442072 | 2021-07-07 | US | Louisiana | Bossier | 22015 | 14569 | 310 | 0 | 32.67932307 | -93.60460152 | 2021-07-08 04:21:26 | Bossier, Louisiana, US | |
2766550 | 2766550 | 2021-07-01 | US | Michigan | Calhoun | 26025 | 14569 | 318 | 0 | 42.24633834 | -85.00493569 | 2021-07-02 04:21:47 | Calhoun, Michigan, US | |
1873301 | 1873301 | 2021-05-15 | US | Alabama | Calhoun | 1015 | 14569 | 319 | 0 | 33.77483727 | -85.82630386 | 2021-05-16 04:20:49 | Calhoun, Alabama, US | |
2825531 | 2825531 | 2021-05-01 | US | Georgia | Bartow | 13015 | 14569 | 223 | 0 | 34.23732119 | -84.83887523 | 2021-05-02 04:20:48 | Bartow, Georgia, US | |
37216 | 37216 | 2021-04-12 | US | Georgia | Douglas | 13097 | 14569 | 207 | 0 | 33.70291126 | -84.77026156 | 2021-04-13 04:20:37 | Douglas, Georgia, US | |
705313 | 705313 | 2021-03-16 | US | Tennessee | Blount | 47009 | 14569 | 186 | 0 | 35.68938198 | -83.92847788 | 2021-03-17 05:25:07 | Blount, Tennessee, US | |
283367 | 283367 | 2021-02-24 | US | Texas | Parker | 48367 | 14569 | 161 | 0 | 14402 | 32.77757172 | -97.80500621 | 2021-02-25 05:24:57 | Parker, Texas, US |
1065202 | 1065202 | 2021-01-04 | US | Virginia | Loudoun | 51107 | 14569 | 161 | 0 | 14408 | 39.08990083 | -77.63481877 | 2021-01-05 05:21:49 | Loudoun, Virginia, US |
3149786 | 3149786 | 2020-12-16 | Russia | Chuvashia Republic | 14569 | 385 | 13023 | 1161 | 55.4259922 | 47.0849429 | 2020-12-17 05:28:12 | Chuvashia Republic, Russia | ||
2703102 | 2703102 | 2020-11-20 | US | Massachusetts | Norfolk | 25021 | 14569 | 994 | 0 | 13414 | 42.16073095 | -71.20530408 | 2020-11-21 05:25:51 | Norfolk, Massachusetts, US |
3413023 | 3413023 | 2020-11-01 | US | Wisconsin | Waukesha | 55133 | 14569 | 125 | 0 | 14444 | 43.01833055 | -88.30431188 | 2020-11-02 05:25:04 | Waukesha, Wisconsin, US |
1107108 | 1107108 | 2020-09-02 | US | Maryland | Baltimore City | 24510 | 14569 | 461 | 0 | 14108 | 39.30211911 | -76.61151012 | 2020-09-03 04:28:22 | Baltimore City, Maryland, 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]);