johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
40 rows where confirmed = 11670 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1050501 | 1050501 | 2022-11-06 | US | Colorado | Summit | 8117 | 11670 | 15 | 0 | 39.63803232 | -106.1150762 | 2022-11-07 04:21:26 | Summit, Colorado, US | |
618525 | 618525 | 2022-11-05 | US | Colorado | Summit | 8117 | 11670 | 15 | 0 | 39.63803232 | -106.1150762 | 2022-11-06 04:21:24 | Summit, Colorado, US | |
1023029 | 1023029 | 2022-11-04 | US | Colorado | Summit | 8117 | 11670 | 15 | 0 | 39.63803232 | -106.1150762 | 2022-11-05 04:21:52 | Summit, Colorado, US | |
3874542 | 3874542 | 2022-07-31 | US | Tennessee | Obion | 47131 | 11670 | 203 | 0 | 36.35732446 | -89.14921589 | 2022-08-01 04:21:03 | Obion, Tennessee, US | |
3079683 | 3079683 | 2022-07-04 | US | Michigan | Branch | 26023 | 11670 | 185 | 0 | 41.91600556 | -85.05929476 | 2022-07-05 04:20:45 | Branch, Michigan, US | |
1768965 | 1768965 | 2022-07-03 | US | Michigan | Branch | 26023 | 11670 | 185 | 0 | 41.91600556 | -85.05929476 | 2022-07-04 04:20:54 | Branch, Michigan, US | |
3366951 | 3366951 | 2022-07-02 | US | Michigan | Branch | 26023 | 11670 | 185 | 0 | 41.91600556 | -85.05929476 | 2022-07-03 04:20:59 | Branch, Michigan, US | |
595280 | 595280 | 2022-07-01 | US | Michigan | Branch | 26023 | 11670 | 185 | 0 | 41.91600556 | -85.05929476 | 2022-07-02 04:21:16 | Branch, Michigan, US | |
3941681 | 3941681 | 2022-06-30 | US | Michigan | Branch | 26023 | 11670 | 185 | 0 | 41.91600556 | -85.05929476 | 2022-07-01 04:21:10 | Branch, Michigan, US | |
2491639 | 2491639 | 2022-06-29 | US | Michigan | Branch | 26023 | 11670 | 185 | 0 | 41.91600556 | -85.05929476 | 2022-06-30 04:21:01 | Branch, Michigan, US | |
2241021 | 2241021 | 2022-06-28 | US | Michigan | Branch | 26023 | 11670 | 185 | 0 | 41.91600556 | -85.05929476 | 2022-06-29 04:20:59 | Branch, Michigan, US | |
224425 | 224425 | 2022-05-09 | US | North Dakota | Stark | 38089 | 11670 | 86 | 0 | 46.80851182 | -102.6576326 | 2022-05-10 04:20:50 | Stark, North Dakota, US | |
878970 | 878970 | 2022-03-27 | US | Pennsylvania | Union | 42119 | 11670 | 152 | 0 | 40.96188846 | -77.05996014 | 2022-03-28 04:20:33 | Union, Pennsylvania, US | |
2166253 | 2166253 | 2022-03-26 | US | Pennsylvania | Union | 42119 | 11670 | 152 | 0 | 40.96188846 | -77.05996014 | 2022-03-27 04:20:47 | Union, Pennsylvania, US | |
2142114 | 2142114 | 2022-03-09 | US | Missouri | Newton | 29145 | 11670 | 194 | 0 | 36.90519407 | -94.3394104 | 2022-03-10 04:20:48 | Newton, Missouri, US | |
3046181 | 3046181 | 2022-02-26 | Japan | Kochi | 11670 | 76 | 0 | 33.422519 | 133.367307 | 2022-02-27 04:21:04 | Kochi, Japan | |||
460749 | 460749 | 2022-02-02 | US | Kentucky | Barren | 21009 | 11670 | 192 | 0 | 36.96469836 | -85.93338945 | 2022-02-03 04:21:21 | Barren, Kentucky, US | |
981276 | 981276 | 2022-02-01 | US | North Carolina | Haywood | 37087 | 11670 | 172 | 0 | 35.55269063 | -82.98196486 | 2022-02-02 04:21:09 | Haywood, North Carolina, US | |
1434024 | 1434024 | 2021-12-28 | US | Kentucky | Oldham | 21185 | 11670 | 112 | 0 | 38.39791089 | -85.448222 | 2021-12-29 03:21:43 | Oldham, Kentucky, US | |
448041 | 448041 | 2021-11-17 | US | Connecticut | Tolland | 9013 | 11670 | 198 | 0 | 41.85853803 | -72.3308481 | 2021-11-18 04:21:33 | Tolland, Connecticut, US | |
290824 | 290824 | 2021-10-31 | US | South Carolina | Laurens | 45059 | 11670 | 225 | 0 | 34.48244419 | -82.00490796 | 2021-11-01 04:22:01 | Laurens, South Carolina, US | |
2723830 | 2723830 | 2021-10-30 | US | South Carolina | Laurens | 45059 | 11670 | 225 | 0 | 34.48244419 | -82.00490796 | 2021-10-31 04:22:08 | Laurens, South Carolina, US | |
569932 | 569932 | 2021-10-29 | US | South Carolina | Laurens | 45059 | 11670 | 225 | 0 | 34.48244419 | -82.00490796 | 2021-10-30 04:22:03 | Laurens, South Carolina, US | |
683916 | 683916 | 2021-10-24 | US | Maryland | Carroll | 24013 | 11670 | 287 | 0 | 39.56453592 | -77.02373735 | 2021-10-25 04:22:31 | Carroll, Maryland, US | |
2900577 | 2900577 | 2021-08-12 | US | Georgia | Walton | 13297 | 11670 | 267 | 0 | 33.78017694 | -83.73552314 | 2021-08-13 04:21:24 | Walton, Georgia, US | |
107448 | 107448 | 2021-06-19 | Italy | Valle d'Aosta | 11670 | 472 | 11137 | 61 | 45.73750286 | 7.320149366 | 2021-06-20 04:21:48 | Valle d'Aosta, Italy | ||
956855 | 956855 | 2021-04-25 | US | Montana | Flathead | 30029 | 11670 | 91 | 0 | 48.29575866 | -114.0520569 | 2021-04-26 04:21:04 | Flathead, Montana, US | |
1409134 | 1409134 | 2021-04-23 | Mexico | Nayarit | 11670 | 1777 | 0 | 9893 | 21.7514 | -104.8455 | 2021-04-24 04:20:38 | Nayarit, Mexico | ||
3664302 | 3664302 | 2021-03-09 | US | Florida | Hernando | 12053 | 11670 | 420 | 0 | 28.55364461 | -82.42700204 | 2021-03-10 05:24:35 | Hernando, Florida, US | |
57322 | 57322 | 2021-03-07 | US | Ohio | Wood | 39173 | 11670 | 183 | 0 | 41.36224827 | -83.62285108 | 2021-03-08 05:24:48 | Wood, Ohio, US | |
1687462 | 1687462 | 2021-02-02 | US | Tennessee | Maury | 47119 | 11670 | 145 | 0 | 11550 | 35.6187413 | -87.07462444 | 2021-02-03 05:22:52 | Maury, Tennessee, US |
2213501 | 2213501 | 2021-01-30 | US | Mississippi | Rankin | 28121 | 11670 | 231 | 0 | 11439 | 32.26469147 | -89.94537876 | 2021-01-31 05:22:42 | Rankin, Mississippi, US |
376039 | 376039 | 2020-11-06 | Colombia | Quindio | 11670 | 280 | 9820 | 1570 | 4.461 | -75.6674 | 2020-11-07 05:24:52 | Quindio, Colombia | ||
1452371 | 1452371 | 2020-10-27 | Chile | Araucania | 11670 | 144 | 10561 | 965 | -38.9489 | -72.3311 | 2020-10-28 04:24:39 | Araucania, Chile | ||
3654716 | 3654716 | 2020-10-24 | US | Texas | Lubbock | 48303 | 11670 | 164 | 0 | 16747 | 33.61008596 | -101.8204789 | 2020-10-25 04:24:36 | Lubbock, Texas, US |
3654500 | 3654500 | 2020-10-24 | US | Tennessee | Hamilton | 47065 | 11670 | 108 | 0 | 11510 | 35.17670231 | -85.16652245 | 2020-10-25 04:24:36 | Hamilton, Tennessee, US |
668949 | 668949 | 2020-09-16 | US | Pennsylvania | Montgomery | 42091 | 11670 | 869 | 0 | 10801 | 40.21053671 | -75.36652296 | 2020-09-17 04:22:00 | Montgomery, Pennsylvania, US |
813803 | 813803 | 2020-09-05 | Russia | Novosibirsk Oblast | 11670 | 376 | 10413 | 881 | 54.9720169 | 79.48139240000002 | 2020-09-06 04:28:33 | Novosibirsk Oblast, Russia | ||
1928161 | 1928161 | 2020-07-30 | Peru | Ancash | 11670 | 1799 | 0 | 9871 | -9.407125 | -77.67179499999997 | 2020-07-31 04:35:18 | Ancash, Peru | ||
2958329 | 2958329 | 2020-07-29 | Peru | Ancash | 11670 | 1783 | 0 | 9887 | -9.407125 | -77.67179499999997 | 2020-07-30 04:35:05 | Ancash, Peru |
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]);