johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
505 rows where confirmed = 1206 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755458 | 2755458 | 2022-12-29 | US | Oklahoma | Dewey | 40043 | 1206 | 35 | 0 | 35.98772922 | -99.00730714 | 2022-12-30 04:21:04 | Dewey, Oklahoma, US | |
2415540 | 2415540 | 2022-12-05 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-06 04:21:03 | Washington, Colorado, US | |
719148 | 719148 | 2022-12-04 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-05 04:20:58 | Washington, Colorado, US | |
2817437 | 2817437 | 2022-12-03 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-04 04:20:56 | Washington, Colorado, US | |
834293 | 834293 | 2022-12-02 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-03 04:21:02 | Washington, Colorado, US | |
2136823 | 2136823 | 2022-12-01 | US | Colorado | Washington | 8121 | 1206 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-02 04:21:07 | Washington, Colorado, US | |
1966997 | 1966997 | 2022-11-30 | US | North Dakota | Pierce | 38069 | 1206 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-12-01 04:21:03 | Pierce, North Dakota, US | |
516295 | 516295 | 2022-10-15 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-16 04:22:39 | Modoc, California, US | |
2033352 | 2033352 | 2022-10-14 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-15 04:22:00 | Modoc, California, US | |
3754040 | 3754040 | 2022-10-13 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-14 04:22:28 | Modoc, California, US | |
3214865 | 3214865 | 2022-10-12 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-13 04:22:39 | Modoc, California, US | |
3252577 | 3252577 | 2022-10-11 | US | North Dakota | Sargent | 38081 | 1206 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-10-12 04:22:51 | Sargent, North Dakota, US | |
3251397 | 3251397 | 2022-10-11 | US | Iowa | Unassigned | 90019 | 1206 | 0 | 0 | 43.38107862 | 0.0 | 2022-10-12 04:22:51 | Unassigned, Iowa, US | |
3250714 | 3250714 | 2022-10-11 | US | California | Modoc | 6049 | 1206 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-10-12 04:22:51 | Modoc, California, US | |
1627400 | 1627400 | 2022-09-22 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-23 04:23:13 | Hall, Texas, US | |
1373604 | 1373604 | 2022-09-21 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-22 04:22:56 | Hall, Texas, US | |
2019834 | 2019834 | 2022-09-20 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-21 04:23:22 | Hall, Texas, US | |
3573707 | 3573707 | 2022-09-19 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-20 04:22:48 | Hall, Texas, US | |
422446 | 422446 | 2022-09-18 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-19 04:21:49 | Hall, Texas, US | |
3376470 | 3376470 | 2022-09-17 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-18 04:22:50 | Hall, Texas, US | |
2358578 | 2358578 | 2022-09-16 | US | Texas | Hall | 48191 | 1206 | 24 | 0 | 34.5307555 | -100.6813852 | 2022-09-17 04:20:19 | Hall, Texas, US | |
2635798 | 2635798 | 2022-09-05 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-06 04:21:02 | Furnas, Nebraska, US | |
2989362 | 2989362 | 2022-09-04 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-05 04:21:01 | Furnas, Nebraska, US | |
2715047 | 2715047 | 2022-09-03 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-04 04:21:22 | Furnas, Nebraska, US | |
1395752 | 1395752 | 2022-09-02 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-03 04:21:04 | Furnas, Nebraska, US | |
3549581 | 3549581 | 2022-09-01 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-02 04:21:07 | Furnas, Nebraska, US | |
2345501 | 2345501 | 2022-08-31 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-09-01 04:21:03 | Furnas, Nebraska, US | |
2344968 | 2344968 | 2022-08-31 | US | Louisiana | Tensas | 22107 | 1206 | 13 | 0 | 32.00760749 | -91.32915234 | 2022-09-01 04:21:03 | Tensas, Louisiana, US | |
3775981 | 3775981 | 2022-08-30 | US | Nebraska | Furnas | 31065 | 1206 | 8 | 0 | 40.17642064 | -99.91247454 | 2022-08-31 04:20:57 | Furnas, Nebraska, US | |
1880387 | 1880387 | 2022-08-28 | US | Virginia | Rappahannock | 51157 | 1206 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-29 04:21:06 | Rappahannock, Virginia, US | |
2099514 | 2099514 | 2022-08-27 | US | Virginia | Rappahannock | 51157 | 1206 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-28 04:21:02 | Rappahannock, Virginia, US | |
1535329 | 1535329 | 2022-08-26 | US | Virginia | Rappahannock | 51157 | 1206 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-27 04:20:57 | Rappahannock, Virginia, US | |
2326408 | 2326408 | 2022-08-24 | US | Texas | Concho | 48095 | 1206 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-08-25 04:21:13 | Concho, Texas, US | |
1254045 | 1254045 | 2022-08-23 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-24 04:20:46 | Grand Isle, Vermont, US | |
1253817 | 1253817 | 2022-08-23 | US | Texas | Concho | 48095 | 1206 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-08-24 04:20:46 | Concho, Texas, US | |
2856149 | 2856149 | 2022-08-22 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-23 04:20:56 | Grand Isle, Vermont, US | |
2406121 | 2406121 | 2022-08-21 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-22 04:20:38 | Grand Isle, Vermont, US | |
3801199 | 3801199 | 2022-08-20 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-21 04:20:44 | Grand Isle, Vermont, US | |
2366785 | 2366785 | 2022-08-19 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-20 04:21:01 | Grand Isle, Vermont, US | |
1164456 | 1164456 | 2022-08-18 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-19 04:20:54 | Grand Isle, Vermont, US | |
1164202 | 1164202 | 2022-08-18 | US | Texas | Brewster | 48043 | 1206 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-08-19 04:20:54 | Brewster, Texas, US | |
3953780 | 3953780 | 2022-08-17 | US | Vermont | Grand Isle | 50013 | 1206 | 6 | 0 | 44.7975824 | -73.29679772 | 2022-08-18 04:21:11 | Grand Isle, Vermont, US | |
3649783 | 3649783 | 2022-08-14 | US | New Mexico | Hidalgo | 35023 | 1206 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-15 04:20:59 | Hidalgo, New Mexico, US | |
1970789 | 1970789 | 2022-08-13 | US | New Mexico | Hidalgo | 35023 | 1206 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-14 04:20:55 | Hidalgo, New Mexico, US | |
2890598 | 2890598 | 2022-08-12 | US | New Mexico | Hidalgo | 35023 | 1206 | 16 | 0 | 31.91383467 | -108.7151824 | 2022-08-13 04:20:52 | Hidalgo, New Mexico, US | |
1349647 | 1349647 | 2022-08-10 | US | Virginia | Craig | 51045 | 1206 | 22 | 0 | 37.48133648 | -80.21072274 | 2022-08-11 04:20:49 | Craig, Virginia, US | |
1491004 | 1491004 | 2022-07-26 | US | Virginia | Surry | 51181 | 1206 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-07-27 04:21:04 | Surry, Virginia, US | |
2597450 | 2597450 | 2022-07-25 | US | Virginia | Surry | 51181 | 1206 | 20 | 0 | 37.11781893 | -76.88450012 | 2022-07-26 04:20:58 | Surry, Virginia, US | |
2792398 | 2792398 | 2022-07-10 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-11 04:20:46 | King and Queen, Virginia, US | |
145351 | 145351 | 2022-07-09 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-10 04:20:54 | King and Queen, Virginia, US | |
1420451 | 1420451 | 2022-07-08 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-09 04:20:59 | King and Queen, Virginia, US | |
2744376 | 2744376 | 2022-07-07 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-08 04:20:56 | King and Queen, Virginia, US | |
1203171 | 1203171 | 2022-07-06 | US | Virginia | King and Queen | 51097 | 1206 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-07 04:20:55 | King and Queen, Virginia, US | |
3969805 | 3969805 | 2022-07-05 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-06 04:20:58 | Wheeler, Texas, US | |
3081316 | 3081316 | 2022-07-04 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-05 04:20:45 | Wheeler, Texas, US | |
1770598 | 1770598 | 2022-07-03 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-04 04:20:54 | Wheeler, Texas, US | |
3368584 | 3368584 | 2022-07-02 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-03 04:20:59 | Wheeler, Texas, US | |
596913 | 596913 | 2022-07-01 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-02 04:21:16 | Wheeler, Texas, US | |
3943314 | 3943314 | 2022-06-30 | US | Texas | Wheeler | 48483 | 1206 | 22 | 0 | 35.40114335 | -100.2699514 | 2022-07-01 04:21:10 | Wheeler, Texas, US | |
3271012 | 3271012 | 2022-06-19 | US | Louisiana | Cameron | 22023 | 1206 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-20 04:21:01 | Cameron, Louisiana, US | |
3398924 | 3398924 | 2022-06-18 | US | Louisiana | Cameron | 22023 | 1206 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-19 04:20:51 | Cameron, Louisiana, US | |
2312801 | 2312801 | 2022-06-17 | US | Louisiana | Cameron | 22023 | 1206 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-18 04:21:10 | Cameron, Louisiana, US | |
560305 | 560305 | 2022-06-16 | US | Louisiana | Cameron | 22023 | 1206 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-06-17 04:20:56 | Cameron, Louisiana, US | |
2981371 | 2981371 | 2022-06-13 | US | Nebraska | Polk | 31143 | 1206 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-06-14 04:20:52 | Polk, Nebraska, US | |
2237497 | 2237497 | 2022-06-12 | US | Nebraska | Polk | 31143 | 1206 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-06-13 04:21:14 | Polk, Nebraska, US | |
3143695 | 3143695 | 2022-06-11 | US | Nebraska | Polk | 31143 | 1206 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-06-12 04:20:53 | Polk, Nebraska, US | |
1946611 | 1946611 | 2022-06-10 | US | Nebraska | Polk | 31143 | 1206 | 12 | 0 | 41.18813488 | -97.56630712 | 2022-06-11 04:21:01 | Polk, Nebraska, US | |
232116 | 232116 | 2022-05-31 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-06-01 04:20:55 | Lyman, South Dakota, US | |
3188881 | 3188881 | 2022-05-30 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-31 04:20:51 | Lyman, South Dakota, US | |
3188059 | 3188059 | 2022-05-30 | US | Nebraska | Dixon | 31051 | 1206 | 11 | 0 | 42.49188363 | -96.86782408 | 2022-05-31 04:20:51 | Dixon, Nebraska, US | |
3201030 | 3201030 | 2022-05-29 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-30 04:20:50 | Lyman, South Dakota, US | |
3200208 | 3200208 | 2022-05-29 | US | Nebraska | Dixon | 31051 | 1206 | 11 | 0 | 42.49188363 | -96.86782408 | 2022-05-30 04:20:50 | Dixon, Nebraska, US | |
2727908 | 2727908 | 2022-05-28 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-29 04:20:53 | Lyman, South Dakota, US | |
2727086 | 2727086 | 2022-05-28 | US | Nebraska | Dixon | 31051 | 1206 | 11 | 0 | 42.49188363 | -96.86782408 | 2022-05-29 04:20:53 | Dixon, Nebraska, US | |
1317089 | 1317089 | 2022-05-27 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-28 04:21:07 | Lyman, South Dakota, US | |
1852881 | 1852881 | 2022-05-26 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-27 04:20:56 | Lyman, South Dakota, US | |
2051200 | 2051200 | 2022-05-25 | US | Virginia | Emporia | 51595 | 1206 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-26 04:20:50 | Emporia, Virginia, US | |
2050757 | 2050757 | 2022-05-25 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-26 04:20:50 | Lyman, South Dakota, US | |
625211 | 625211 | 2022-05-22 | US | Virginia | Emporia | 51595 | 1206 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-26 04:20:50 | Emporia, Virginia, US | |
624768 | 624768 | 2022-05-22 | US | South Dakota | Lyman | 46085 | 1206 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-05-26 04:20:50 | Lyman, South Dakota, US | |
2601215 | 2601215 | 2022-05-05 | US | Texas | Martin | 48317 | 1206 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-05-06 04:21:00 | Martin, Texas, US | |
3268664 | 3268664 | 2022-05-04 | US | Texas | Martin | 48317 | 1206 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-05-05 04:20:55 | Martin, Texas, US | |
1575303 | 1575303 | 2022-05-03 | US | Texas | Martin | 48317 | 1206 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-05-04 04:20:59 | Martin, Texas, US | |
466495 | 466495 | 2022-05-02 | US | Texas | Goliad | 48175 | 1206 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-05-03 04:21:00 | Goliad, Texas, US | |
1329539 | 1329539 | 2022-04-26 | US | Vermont | Unassigned | 90050 | 1206 | 1 | 0 | 44.85627605 | 0.0 | 2022-04-27 04:20:52 | Unassigned, Vermont, US | |
3725493 | 3725493 | 2022-04-25 | US | Vermont | Unassigned | 90050 | 1206 | 1 | 0 | 44.85627605 | 0.0 | 2022-04-26 04:20:51 | Unassigned, Vermont, US | |
2670468 | 2670468 | 2022-04-15 | US | Colorado | Saguache | 8109 | 1206 | 12 | 0 | 38.08054629 | -106.28246599999999 | 2022-04-16 04:20:48 | Saguache, Colorado, US | |
1299370 | 1299370 | 2022-02-17 | US | Kansas | Meade | 20119 | 1206 | 17 | 0 | 37.23859987 | -100.36483100000001 | 2022-02-18 04:21:04 | Meade, Kansas, US | |
3821756 | 3821756 | 2022-02-16 | US | Kansas | Meade | 20119 | 1206 | 17 | 0 | 37.23859987 | -100.36483100000001 | 2022-02-17 04:20:56 | Meade, Kansas, US | |
3673640 | 3673640 | 2022-02-15 | US | Montana | Broadwater | 30007 | 1206 | 18 | 0 | 46.33277565 | -111.49558130000001 | 2022-02-16 04:21:10 | Broadwater, Montana, US | |
2475259 | 2475259 | 2022-02-03 | US | Kansas | Kearny | 20093 | 1206 | 18 | 0 | 38.00017981 | -101.32168100000001 | 2022-02-04 04:21:10 | Kearny, Kansas, US | |
461413 | 461413 | 2022-02-02 | US | Montana | Teton | 30099 | 1206 | 18 | 0 | 47.83741052 | -112.24106880000001 | 2022-02-03 04:21:21 | Teton, Montana, US | |
460684 | 460684 | 2022-02-02 | US | Kansas | Kearny | 20093 | 1206 | 18 | 0 | 38.00017981 | -101.32168100000001 | 2022-02-03 04:21:21 | Kearny, Kansas, US | |
981280 | 981280 | 2022-02-01 | US | North Carolina | Hyde | 37095 | 1206 | 13 | 0 | 35.42017674 | -76.15180542 | 2022-02-02 04:21:09 | Hyde, North Carolina, US | |
2658289 | 2658289 | 2022-01-31 | US | Arkansas | Lafayette | 5073 | 1206 | 28 | 0 | 33.24116713 | -93.60677071 | 2022-02-01 04:21:11 | Lafayette, Arkansas, US | |
3065169 | 3065169 | 2022-01-29 | US | Texas | McCulloch | 48307 | 1206 | 42 | 0 | 31.1925468 | -99.34682807 | 2022-01-30 04:21:26 | McCulloch, Texas, US | |
1781438 | 1781438 | 2022-01-27 | US | Nebraska | Burt | 31021 | 1206 | 12 | 0 | 41.85056773 | -96.32605633 | 2022-01-28 04:21:09 | Burt, Nebraska, US | |
1321819 | 1321819 | 2022-01-26 | US | Wyoming | Crook | 56011 | 1206 | 22 | 0 | 44.58855102 | -104.56977049999999 | 2022-01-27 04:21:19 | Crook, Wyoming, US | |
1320956 | 1320956 | 2022-01-26 | US | Puerto Rico | Guanica | 72055 | 1206 | 0 | 0 | 17.982429 | -66.91964300000001 | 2022-01-27 04:21:19 | Guanica, Puerto Rico, US | |
3465299 | 3465299 | 2022-01-18 | US | Indiana | Ohio | 18115 | 1206 | 16 | 0 | 38.955304999999996 | -84.96515993 | 2022-01-19 04:21:23 | Ohio, Indiana, 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]);