johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where confirmed = 14216 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717741 | 3717741 | 2022-12-06 | US | Wisconsin | Monroe | 55081 | 14216 | 106 | 0 | 43.94641218 | -90.618819 | 2022-12-07 04:20:58 | Monroe, Wisconsin, US | |
1611617 | 1611617 | 2022-07-20 | US | Virginia | Harrisonburg | 51660 | 14216 | 166 | 0 | 38.43542574 | -78.87536254 | 2022-07-21 04:21:10 | Harrisonburg, Virginia, US | |
2153896 | 2153896 | 2022-07-16 | US | New York | Fulton | 36035 | 14216 | 173 | 0 | 43.11363907 | -74.41798804 | 2022-07-17 04:21:15 | Fulton, New York, US | |
1849014 | 1849014 | 2022-04-18 | US | Texas | Caldwell | 48055 | 14216 | 175 | 0 | 29.83668859 | -97.61814775 | 2022-04-19 04:21:00 | Caldwell, Texas, US | |
3732556 | 3732556 | 2022-04-03 | US | North Carolina | Granville | 37077 | 14216 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-04 04:20:51 | Granville, North Carolina, US | |
501991 | 501991 | 2022-04-02 | US | North Carolina | Granville | 37077 | 14216 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-03 04:20:48 | Granville, North Carolina, US | |
3352976 | 3352976 | 2022-04-01 | US | North Carolina | Granville | 37077 | 14216 | 111 | 0 | 36.30337451 | -78.65184241 | 2022-04-02 04:20:47 | Granville, North Carolina, US | |
920454 | 920454 | 2022-03-08 | US | Georgia | Catoosa | 13047 | 14216 | 154 | 0 | 34.89872298 | -85.13757014 | 2022-03-09 04:20:59 | Catoosa, Georgia, US | |
3077579 | 3077579 | 2022-02-09 | US | Wisconsin | Calumet | 55015 | 14216 | 110 | 0 | 44.0816316 | -88.21780273 | 2022-02-10 04:21:14 | Calumet, Wisconsin, US | |
1437 | 1437 | 2021-12-02 | US | Indiana | Kosciusko | 18085 | 14216 | 167 | 0 | 41.24521668 | -85.86312322 | 2021-12-03 04:23:05 | Kosciusko, Indiana, US | |
700930 | 700930 | 2021-11-04 | US | Ohio | Wayne | 39169 | 14216 | 302 | 0 | 40.82925852 | -81.88844833 | 2021-11-05 04:21:54 | Wayne, Ohio, US | |
2075951 | 2075951 | 2021-09-26 | Japan | Kumamoto | 14216 | 134 | 0 | 32.608154 | 130.74523100000002 | 2021-09-27 04:21:16 | Kumamoto, Japan | |||
2175890 | 2175890 | 2021-08-22 | Timor-Leste | 14216 | 48 | 0 | -8.874217 | 125.727539 | 2021-08-23 04:21:27 | Timor-Leste | ||||
1738953 | 1738953 | 2021-06-12 | US | Ohio | Clark | 39023 | 14216 | 308 | 0 | 39.91592258 | -83.78498252 | 2021-06-13 04:22:44 | Clark, Ohio, US | |
3927009 | 3927009 | 2021-04-24 | US | Tennessee | Washington | 47179 | 14216 | 243 | 0 | 36.29472368 | -82.49454720000001 | 2021-04-25 04:20:32 | Washington, Tennessee, US | |
2247599 | 2247599 | 2021-04-07 | Russia | Kamchatka Krai | 14216 | 211 | 13408 | 597 | 57.1914882 | 160.03838190000005 | 2021-04-08 04:21:13 | Kamchatka Krai, Russia | ||
3643898 | 3643898 | 2021-03-30 | US | Alabama | Calhoun | 1015 | 14216 | 304 | 0 | 33.77483727 | -85.82630386 | 2021-03-31 04:26:25 | Calhoun, Alabama, US | |
1882027 | 1882027 | 2021-03-26 | US | Illinois | Tazewell | 17179 | 14216 | 244 | 0 | 40.50716185 | -89.51404662 | 2021-03-27 05:25:04 | Tazewell, Illinois, US | |
2606021 | 2606021 | 2020-09-24 | Italy | Toscana | 14216 | 1153 | 9907 | 3156 | 43.76923077 | 11.25588885 | 2020-09-25 04:23:00 | Toscana, Italy | ||
3276355 | 3276355 | 2020-05-15 | Colombia | 14216 | 546 | 3460 | 10210 | 4.5709 | -74.2973 | 2020-05-16 02:32:19 | Colombia |
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]);