johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where confirmed = 17209 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2817366 | 2817366 | 2022-12-03 | US | California | Tehama | 6103 | 17209 | 216 | 0 | 40.12570935 | -122.2370171 | 2022-12-04 04:20:56 | Tehama, California, US | |
1369397 | 1369397 | 2022-10-28 | US | Tennessee | Bedford | 47003 | 17209 | 244 | 0 | 35.51123746 | -86.45549096 | 2022-10-29 04:21:13 | Bedford, Tennessee, US | |
3250757 | 3250757 | 2022-10-11 | US | Colorado | Broomfield | 8014 | 17209 | 123 | 0 | 39.95998787 | -105.0566324 | 2022-10-12 04:22:51 | Broomfield, Colorado, US | |
2687347 | 2687347 | 2022-10-03 | US | Michigan | Isabella | 26073 | 17209 | 223 | 0 | 43.64060976 | -84.84664923 | 2022-10-04 04:22:55 | Isabella, Michigan, US | |
2261414 | 2261414 | 2022-10-02 | US | Michigan | Isabella | 26073 | 17209 | 223 | 0 | 43.64060976 | -84.84664923 | 2022-10-03 04:23:11 | Isabella, Michigan, US | |
2996940 | 2996940 | 2022-10-01 | US | Michigan | Isabella | 26073 | 17209 | 223 | 0 | 43.64060976 | -84.84664923 | 2022-10-02 04:21:23 | Isabella, Michigan, US | |
855266 | 855266 | 2022-09-30 | US | Michigan | Isabella | 26073 | 17209 | 223 | 0 | 43.64060976 | -84.84664923 | 2022-10-01 04:23:01 | Isabella, Michigan, US | |
2377824 | 2377824 | 2022-09-29 | US | New York | Warren | 36113 | 17209 | 137 | 0 | 43.56173026 | -73.8433699 | 2022-09-30 04:23:09 | Warren, New York, US | |
2377192 | 2377192 | 2022-09-29 | US | Michigan | Isabella | 26073 | 17209 | 223 | 0 | 43.64060976 | -84.84664923 | 2022-09-30 04:23:09 | Isabella, Michigan, US | |
1561743 | 1561743 | 2022-09-28 | US | Michigan | Isabella | 26073 | 17209 | 223 | 0 | 43.64060976 | -84.84664923 | 2022-09-29 04:22:34 | Isabella, Michigan, US | |
3996286 | 3996286 | 2022-09-27 | US | Michigan | Isabella | 26073 | 17209 | 223 | 0 | 43.64060976 | -84.84664923 | 2022-09-28 04:23:01 | Isabella, Michigan, US | |
1346800 | 1346800 | 2022-08-10 | US | Arkansas | Crawford | 5033 | 17209 | 257 | 0 | 35.58928601 | -94.2446814 | 2022-08-11 04:20:49 | Crawford, Arkansas, US | |
1943470 | 1943470 | 2022-08-06 | US | Tennessee | Roane | 47145 | 17209 | 239 | 0 | 35.84923189 | -84.52458689 | 2022-08-07 04:20:54 | Roane, Tennessee, US | |
464967 | 464967 | 2022-05-02 | US | Maryland | Allegany | 24001 | 17209 | 361 | 0 | 39.62357628 | -78.69280486 | 2022-05-03 04:21:00 | Allegany, Maryland, US | |
2892475 | 2892475 | 2022-04-21 | Malaysia | Perlis | 17209 | 182 | 0 | 6.4449 | 100.2048 | 2022-04-22 04:20:45 | Perlis, Malaysia | |||
3350657 | 3350657 | 2022-04-01 | Japan | Kochi | 17209 | 101 | 0 | 33.422519 | 133.367307 | 2022-04-02 04:20:47 | Kochi, Japan | |||
1016349 | 1016349 | 2021-11-21 | US | Montana | Missoula | 30063 | 17209 | 176 | 0 | 47.03728583 | -113.92135079999998 | 2021-11-22 04:22:20 | Missoula, Montana, US | |
724513 | 724513 | 2021-11-20 | US | Montana | Missoula | 30063 | 17209 | 176 | 0 | 47.03728583 | -113.92135079999998 | 2021-11-21 04:22:13 | Missoula, Montana, US | |
164043 | 164043 | 2021-11-19 | US | Montana | Missoula | 30063 | 17209 | 176 | 0 | 47.03728583 | -113.92135079999998 | 2021-11-20 04:22:17 | Missoula, Montana, US | |
699799 | 699799 | 2021-11-04 | US | Kentucky | Daviess | 21059 | 17209 | 269 | 0 | 37.73028906 | -87.09019479999998 | 2021-11-05 04:21:54 | Daviess, Kentucky, US | |
770894 | 770894 | 2021-10-23 | US | California | El Dorado | 6017 | 17209 | 149 | 0 | 38.77965956 | -120.5233166 | 2021-10-24 04:21:22 | El Dorado, California, US | |
2046952 | 2046952 | 2021-10-18 | US | Texas | Gregg | 48183 | 17209 | 528 | 0 | 32.47940482 | -94.81591935 | 2021-10-19 04:20:54 | Gregg, Texas, US | |
1912313 | 1912313 | 2021-10-17 | US | Texas | Gregg | 48183 | 17209 | 528 | 0 | 32.47940482 | -94.81591935 | 2021-10-18 04:21:10 | Gregg, Texas, US | |
937902 | 937902 | 2021-10-16 | US | Texas | Gregg | 48183 | 17209 | 527 | 0 | 32.47940482 | -94.81591935 | 2021-10-17 04:21:29 | Gregg, Texas, US | |
2946457 | 2946457 | 2021-10-15 | US | Texas | Gregg | 48183 | 17209 | 526 | 0 | 32.47940482 | -94.81591935 | 2021-10-16 04:21:15 | Gregg, Texas, US | |
2297615 | 2297615 | 2021-06-24 | US | New Jersey | Cumberland | 34011 | 17209 | 441 | 0 | 39.37199394 | -75.10712559 | 2021-06-25 04:21:33 | Cumberland, New Jersey, US | |
1426191 | 1426191 | 2021-05-09 | US | Indiana | Hendricks | 18063 | 17209 | 315 | 0 | 39.76719009 | -86.51037283 | 2021-05-10 04:20:38 | Hendricks, Indiana, US | |
3245898 | 3245898 | 2021-04-21 | US | Wisconsin | Rock | 55105 | 17209 | 187 | 0 | 42.67151616 | -89.07147900000002 | 2021-04-22 04:20:53 | Rock, Wisconsin, US | |
3088112 | 3088112 | 2021-04-05 | US | South Carolina | Florence | 45041 | 17209 | 397 | 0 | 34.02361754 | -79.70189312 | 2021-04-06 04:20:32 | Florence, South Carolina, US | |
1883436 | 1883436 | 2021-03-26 | US | Ohio | Delaware | 39041 | 17209 | 129 | 0 | 40.27942393 | -83.00457058 | 2021-03-27 05:25:04 | Delaware, Ohio, US | |
2783316 | 2783316 | 2021-03-24 | US | North Carolina | Iredell | 37097 | 17209 | 203 | 0 | 35.80950511 | -80.8743128 | 2021-03-25 05:27:00 | Iredell, North Carolina, US | |
1759864 | 1759864 | 2021-01-24 | US | California | San Luis Obispo | 6079 | 17209 | 179 | 0 | 17054 | 35.38822029 | -120.4039028 | 2021-01-25 05:22:16 | San Luis Obispo, California, US |
2933114 | 2933114 | 2020-12-19 | US | Missouri | Greene | 29077 | 17209 | 238 | 0 | 16971 | 37.2575872 | -93.34230916 | 2020-12-20 05:27:32 | Greene, Missouri, US |
1819870 | 1819870 | 2020-12-08 | US | Indiana | Hamilton | 18057 | 17209 | 220 | 0 | 16989 | 40.07306535 | -86.05244729 | 2020-12-09 05:28:01 | Hamilton, Indiana, US |
2708804 | 2708804 | 2020-07-17 | Brazil | Tocantins | 17209 | 288 | 10314 | 6357 | -10.1753 | -48.2982 | 2020-07-18 04:34:45 | Tocantins, Brazil |
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]);