johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where confirmed = 13261 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756481 | 2756481 | 2022-12-29 | US | Wisconsin | Pierce | 55093 | 13261 | 77 | 0 | 44.71850291 | -92.4224416 | 2022-12-30 04:21:04 | Pierce, Wisconsin, US | |
311316 | 311316 | 2022-12-13 | US | Virginia | Wise | 51195 | 13261 | 223 | 0 | 36.9746148 | -82.62410519 | 2022-12-14 04:21:04 | Wise, Virginia, US | |
131616 | 131616 | 2022-10-04 | US | Georgia | Polk | 13233 | 13261 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-05 04:23:06 | Polk, Georgia, US | |
2686563 | 2686563 | 2022-10-03 | US | Georgia | Polk | 13233 | 13261 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-04 04:22:55 | Polk, Georgia, US | |
2260630 | 2260630 | 2022-10-02 | US | Georgia | Polk | 13233 | 13261 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-03 04:23:11 | Polk, Georgia, US | |
2996156 | 2996156 | 2022-10-01 | US | Georgia | Polk | 13233 | 13261 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-02 04:21:23 | Polk, Georgia, US | |
854482 | 854482 | 2022-09-30 | US | Georgia | Polk | 13233 | 13261 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-10-01 04:23:01 | Polk, Georgia, US | |
2376408 | 2376408 | 2022-09-29 | US | Georgia | Polk | 13233 | 13261 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-09-30 04:23:09 | Polk, Georgia, US | |
1560959 | 1560959 | 2022-09-28 | US | Georgia | Polk | 13233 | 13261 | 204 | 0 | 34.00267074 | -85.18677781 | 2022-09-29 04:22:34 | Polk, Georgia, US | |
1979947 | 1979947 | 2022-09-25 | US | Virginia | Culpeper | 51047 | 13261 | 164 | 0 | 38.48199985 | -77.9563087 | 2022-09-26 04:20:52 | Culpeper, Virginia, US | |
2653114 | 2653114 | 2022-09-24 | US | Virginia | Culpeper | 51047 | 13261 | 164 | 0 | 38.48199985 | -77.9563087 | 2022-09-25 04:23:31 | Culpeper, Virginia, US | |
387554 | 387554 | 2022-09-23 | US | Virginia | Culpeper | 51047 | 13261 | 164 | 0 | 38.48199985 | -77.9563087 | 2022-09-24 04:21:40 | Culpeper, Virginia, US | |
3745519 | 3745519 | 2022-09-07 | US | Alabama | Tallapoosa | 1123 | 13261 | 246 | 0 | 32.86698258 | -85.79833053 | 2022-09-08 04:21:02 | Tallapoosa, Alabama, US | |
115159 | 115159 | 2022-09-06 | US | Alabama | Tallapoosa | 1123 | 13261 | 246 | 0 | 32.86698258 | -85.79833053 | 2022-09-07 04:20:59 | Tallapoosa, Alabama, US | |
2634131 | 2634131 | 2022-09-05 | US | Alabama | Tallapoosa | 1123 | 13261 | 246 | 0 | 32.86698258 | -85.79833053 | 2022-09-06 04:21:02 | Tallapoosa, Alabama, US | |
2987695 | 2987695 | 2022-09-04 | US | Alabama | Tallapoosa | 1123 | 13261 | 246 | 0 | 32.86698258 | -85.79833053 | 2022-09-05 04:21:01 | Tallapoosa, Alabama, US | |
2713380 | 2713380 | 2022-09-03 | US | Alabama | Tallapoosa | 1123 | 13261 | 246 | 0 | 32.86698258 | -85.79833053 | 2022-09-04 04:21:22 | Tallapoosa, Alabama, US | |
1394085 | 1394085 | 2022-09-02 | US | Alabama | Tallapoosa | 1123 | 13261 | 246 | 0 | 32.86698258 | -85.79833053 | 2022-09-03 04:21:04 | Tallapoosa, Alabama, US | |
3547914 | 3547914 | 2022-09-01 | US | Alabama | Tallapoosa | 1123 | 13261 | 246 | 0 | 32.86698258 | -85.79833053 | 2022-09-02 04:21:07 | Tallapoosa, Alabama, US | |
2600286 | 2600286 | 2022-05-05 | US | New York | Fulton | 36035 | 13261 | 169 | 0 | 43.11363907 | -74.41798804 | 2022-05-06 04:21:00 | Fulton, New York, US | |
3209102 | 3209102 | 2022-04-11 | US | South Carolina | Newberry | 45071 | 13261 | 190 | 0 | 34.28629098 | -81.59935761 | 2022-04-12 04:20:49 | Newberry, South Carolina, US | |
1578988 | 1578988 | 2022-04-10 | US | South Carolina | Newberry | 45071 | 13261 | 190 | 0 | 34.28629098 | -81.59935761 | 2022-04-11 04:21:02 | Newberry, South Carolina, US | |
1655230 | 1655230 | 2022-04-09 | US | South Carolina | Newberry | 45071 | 13261 | 190 | 0 | 34.28629098 | -81.59935761 | 2022-04-10 04:20:52 | Newberry, South Carolina, US | |
2118552 | 2118552 | 2022-04-08 | US | South Carolina | Newberry | 45071 | 13261 | 190 | 0 | 34.28629098 | -81.59935761 | 2022-04-09 04:20:42 | Newberry, South Carolina, US | |
3323076 | 3323076 | 2022-04-07 | US | South Carolina | Newberry | 45071 | 13261 | 190 | 0 | 34.28629098 | -81.59935761 | 2022-04-08 04:20:48 | Newberry, South Carolina, US | |
2803612 | 2803612 | 2022-04-06 | US | South Carolina | Newberry | 45071 | 13261 | 190 | 0 | 34.28629098 | -81.59935761 | 2022-04-07 04:20:53 | Newberry, South Carolina, US | |
3870381 | 3870381 | 2022-04-05 | US | South Carolina | Newberry | 45071 | 13261 | 190 | 0 | 34.28629098 | -81.59935761 | 2022-04-06 04:20:49 | Newberry, South Carolina, US | |
945112 | 945112 | 2022-02-28 | US | New York | Warren | 36113 | 13261 | 122 | 0 | 43.56173026 | -73.8433699 | 2022-03-01 04:21:09 | Warren, New York, US | |
2449115 | 2449115 | 2022-02-22 | US | North Carolina | McDowell | 37111 | 13261 | 159 | 0 | 35.67736232 | -82.0482425 | 2022-02-23 04:21:09 | McDowell, North Carolina, US | |
3823712 | 3823712 | 2022-02-16 | US | Utah | Summit | 49043 | 13261 | 22 | 0 | 40.86688146 | -110.9535882 | 2022-02-17 04:20:56 | Summit, Utah, US | |
89351 | 89351 | 2021-11-09 | US | New York | Chautauqua | 36013 | 13261 | 184 | 0 | 42.22769210000001 | -79.36691763 | 2021-11-10 04:21:38 | Chautauqua, New York, US | |
2069727 | 2069727 | 2021-08-31 | US | Mississippi | Madison | 28089 | 13261 | 255 | 0 | 32.63389156 | -90.03513564 | 2021-09-01 04:21:38 | Madison, Mississippi, US | |
653198 | 653198 | 2021-08-09 | US | Texas | Tom Green | 48451 | 13261 | 284 | 0 | 31.40464436 | -100.46244300000001 | 2021-08-10 04:21:27 | Tom Green, Texas, US | |
592860 | 592860 | 2021-08-08 | US | Texas | Tom Green | 48451 | 13261 | 282 | 0 | 31.40464436 | -100.462443 | 2021-08-09 04:21:24 | Tom Green, Texas, US | |
2206872 | 2206872 | 2021-08-07 | US | Texas | Tom Green | 48451 | 13261 | 282 | 0 | 31.40464436 | -100.462443 | 2021-08-08 04:21:33 | Tom Green, Texas, US | |
2761077 | 2761077 | 2021-05-03 | Peru | Huancavelica | 13261 | 941 | 0 | 12320 | -13.023888 | -75.00277 | 2021-05-04 04:20:34 | Huancavelica, Peru | ||
2450930 | 2450930 | 2021-05-02 | Peru | Huancavelica | 13261 | 934 | 0 | 12327 | -13.023888 | -75.00277 | 2021-05-03 04:20:39 | Huancavelica, Peru | ||
3394904 | 3394904 | 2021-04-28 | US | Louisiana | Livingston | 22063 | 13261 | 204 | 0 | 30.44143993 | -90.73061664 | 2021-04-29 04:20:55 | Livingston, Louisiana, US | |
1305685 | 1305685 | 2021-04-01 | Ukraine | Sevastopol* | 13261 | 564 | 12232 | 465 | 44.6054 | 33.522 | 2021-04-02 04:20:36 | Sevastopol*, Ukraine | ||
182244 | 182244 | 2021-02-21 | Russia | Kamchatka Krai | 13261 | 118 | 11802 | 1341 | 57.1914882 | 160.03838190000005 | 2021-02-22 05:24:21 | Kamchatka Krai, Russia | ||
2568042 | 2568042 | 2021-01-25 | US | Alabama | Lee | 1081 | 13261 | 107 | 0 | 13154 | 32.60154883 | -85.35132246 | 2021-01-26 05:22:02 | Lee, Alabama, US |
1012169 | 1012169 | 2020-12-30 | US | Missouri | Boone | 29019 | 13261 | 44 | 0 | 13217 | 38.99186229 | -92.30723575 | 2020-12-31 05:22:49 | Boone, Missouri, US |
2130373 | 2130373 | 2020-12-17 | US | North Dakota | Burleigh | 38015 | 13261 | 159 | 0 | 13115 | 46.97847375 | -100.4645214 | 2020-12-18 05:28:18 | Burleigh, North Dakota, US |
824238 | 824238 | 2020-11-19 | US | Pennsylvania | Lancaster | 42071 | 13261 | 502 | 0 | 12759 | 40.03904563 | -76.24770128 | 2020-11-20 05:26:28 | Lancaster, Pennsylvania, US |
125960 | 125960 | 2020-11-18 | US | Utah | Davis | 49011 | 13261 | 55 | 0 | 13206 | 40.99001837 | -112.1139997 | 2020-11-19 05:25:23 | Davis, Utah, US |
122694 | 122694 | 2020-11-18 | Italy | P.A. Trento | 13261 | 549 | 9852 | 2860 | 46.06893511 | 11.12123097 | 2020-11-19 05:25:23 | P.A. Trento, Italy | ||
2079775 | 2079775 | 2020-10-31 | Colombia | Cauca | 13261 | 373 | 11600 | 1288 | 2.705 | -76.82600000000002 | 2020-11-01 04:36:19 | Cauca, Colombia | ||
210078 | 210078 | 2020-10-29 | Colombia | Boyaca | 13261 | 285 | 11104 | 1872 | 5.4545 | -73.362 | 2020-10-30 04:24:49 | Boyaca, Colombia | ||
754140 | 754140 | 2020-10-28 | Colombia | Boyaca | 13261 | 285 | 11104 | 1872 | 5.4545 | -73.362 | 2020-10-29 04:24:49 | Boyaca, Colombia | ||
1795078 | 1795078 | 2020-10-19 | US | Arizona | Yuma | 4027 | 13261 | 353 | 0 | 12908 | 32.76895712 | -113.90666740000002 | 2020-10-20 04:24:22 | Yuma, Arizona, US |
1523354 | 1523354 | 2020-08-28 | Peru | Ucayali | 13261 | 1355 | 0 | 11906 | -9.621718 | -73.444929 | 2020-08-29 04:28:19 | Ucayali, 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]);