johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
537 rows where confirmed = 1215 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1149611 | 1149611 | 2022-12-12 | US | Colorado | Washington | 8121 | 1215 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-13 04:21:01 | Washington, Colorado, US | |
869465 | 869465 | 2022-12-11 | US | Colorado | Washington | 8121 | 1215 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-12 04:21:01 | Washington, Colorado, US | |
257995 | 257995 | 2022-12-10 | US | Colorado | Washington | 8121 | 1215 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-11 04:20:50 | Washington, Colorado, US | |
3936709 | 3936709 | 2022-12-09 | US | Colorado | Washington | 8121 | 1215 | 33 | 0 | 39.97015535 | -103.202587 | 2022-12-10 04:21:02 | Washington, Colorado, US | |
3599089 | 3599089 | 2022-11-14 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-15 04:21:16 | Antelope, Nebraska, US | |
313947 | 313947 | 2022-11-13 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-14 04:21:09 | Antelope, Nebraska, US | |
65108 | 65108 | 2022-11-12 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-13 04:21:14 | Antelope, Nebraska, US | |
2929270 | 2929270 | 2022-11-11 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-12 04:20:41 | Antelope, Nebraska, US | |
2508106 | 2508106 | 2022-11-10 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-11 04:21:22 | Antelope, Nebraska, US | |
2432981 | 2432981 | 2022-11-09 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-10 04:21:16 | Antelope, Nebraska, US | |
481637 | 481637 | 2022-11-08 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-09 04:21:22 | Antelope, Nebraska, US | |
2440787 | 2440787 | 2022-11-07 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-08 04:21:21 | Antelope, Nebraska, US | |
1051885 | 1051885 | 2022-11-06 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-07 04:21:26 | Antelope, Nebraska, US | |
619909 | 619909 | 2022-11-05 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-06 04:21:24 | Antelope, Nebraska, US | |
1024413 | 1024413 | 2022-11-04 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-05 04:21:52 | Antelope, Nebraska, US | |
1022933 | 1022933 | 2022-11-04 | US | California | Modoc | 6049 | 1215 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-11-05 04:21:52 | Modoc, California, US | |
433404 | 433404 | 2022-11-03 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-04 04:22:11 | Antelope, Nebraska, US | |
431924 | 431924 | 2022-11-03 | US | California | Modoc | 6049 | 1215 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-11-04 04:22:11 | Modoc, California, US | |
852159 | 852159 | 2022-11-02 | US | Oklahoma | Grant | 40053 | 1215 | 17 | 0 | 36.796297 | -97.78638765 | 2022-11-03 04:22:05 | Grant, Oklahoma, US | |
851646 | 851646 | 2022-11-02 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-03 04:22:05 | Antelope, Nebraska, US | |
713010 | 713010 | 2022-11-01 | US | Oklahoma | Grant | 40053 | 1215 | 17 | 0 | 36.796297 | -97.78638765 | 2022-11-02 04:22:09 | Grant, Oklahoma, US | |
712497 | 712497 | 2022-11-01 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-02 04:22:09 | Antelope, Nebraska, US | |
3287459 | 3287459 | 2022-10-31 | US | Oklahoma | Grant | 40053 | 1215 | 17 | 0 | 36.796297 | -97.78638765 | 2022-11-01 04:22:36 | Grant, Oklahoma, US | |
3286946 | 3286946 | 2022-10-31 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-11-01 04:22:36 | Antelope, Nebraska, US | |
322492 | 322492 | 2022-10-30 | US | Oklahoma | Grant | 40053 | 1215 | 17 | 0 | 36.796297 | -97.78638765 | 2022-10-31 04:21:36 | Grant, Oklahoma, US | |
321979 | 321979 | 2022-10-30 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-10-31 04:21:36 | Antelope, Nebraska, US | |
914768 | 914768 | 2022-10-29 | US | Oklahoma | Grant | 40053 | 1215 | 17 | 0 | 36.796297 | -97.78638765 | 2022-10-30 04:22:14 | Grant, Oklahoma, US | |
914255 | 914255 | 2022-10-29 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-10-30 04:22:14 | Antelope, Nebraska, US | |
1369037 | 1369037 | 2022-10-28 | US | Oklahoma | Grant | 40053 | 1215 | 17 | 0 | 36.796297 | -97.78638765 | 2022-10-29 04:21:13 | Grant, Oklahoma, US | |
1368524 | 1368524 | 2022-10-28 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-10-29 04:21:13 | Antelope, Nebraska, US | |
3040892 | 3040892 | 2022-10-27 | US | Oklahoma | Grant | 40053 | 1215 | 17 | 0 | 36.796297 | -97.78638765 | 2022-10-28 04:22:31 | Grant, Oklahoma, US | |
3040379 | 3040379 | 2022-10-27 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-10-28 04:22:31 | Antelope, Nebraska, US | |
540799 | 540799 | 2022-10-26 | US | Nebraska | Antelope | 31003 | 1215 | 18 | 0 | 42.17695516 | -98.0666283 | 2022-10-27 04:22:01 | Antelope, Nebraska, US | |
2273838 | 2273838 | 2022-10-20 | US | Missouri | Holt | 29087 | 1215 | 31 | 0 | 40.09799248 | -95.2163888 | 2022-10-21 04:22:23 | Holt, Missouri, US | |
200173 | 200173 | 2022-10-19 | US | Missouri | Holt | 29087 | 1215 | 31 | 0 | 40.09799248 | -95.2163888 | 2022-10-20 04:22:59 | Holt, Missouri, US | |
2758834 | 2758834 | 2022-10-18 | US | Missouri | Holt | 29087 | 1215 | 31 | 0 | 40.09799248 | -95.2163888 | 2022-10-19 04:22:26 | Holt, Missouri, US | |
2026668 | 2026668 | 2022-10-17 | US | Missouri | Holt | 29087 | 1215 | 31 | 0 | 40.09799248 | -95.2163888 | 2022-10-18 04:22:42 | Holt, Missouri, US | |
2161446 | 2161446 | 2022-10-16 | US | Missouri | Holt | 29087 | 1215 | 31 | 0 | 40.09799248 | -95.2163888 | 2022-10-17 04:20:31 | Holt, Missouri, US | |
517643 | 517643 | 2022-10-15 | US | Missouri | Holt | 29087 | 1215 | 31 | 0 | 40.09799248 | -95.2163888 | 2022-10-16 04:22:39 | Holt, Missouri, US | |
2034700 | 2034700 | 2022-10-14 | US | Missouri | Holt | 29087 | 1215 | 31 | 0 | 40.09799248 | -95.2163888 | 2022-10-15 04:22:00 | Holt, Missouri, US | |
3754425 | 3754425 | 2022-10-13 | US | Idaho | Lincoln | 16063 | 1215 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-10-14 04:22:28 | Lincoln, Idaho, US | |
3215250 | 3215250 | 2022-10-12 | US | Idaho | Lincoln | 16063 | 1215 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-10-13 04:22:39 | Lincoln, Idaho, US | |
2969087 | 2969087 | 2022-10-10 | US | Michigan | Ontonagon | 26131 | 1215 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-10-11 04:23:05 | Ontonagon, Michigan, US | |
3099123 | 3099123 | 2022-10-09 | US | Michigan | Ontonagon | 26131 | 1215 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-10-10 04:22:32 | Ontonagon, Michigan, US | |
4004348 | 4004348 | 2022-10-08 | US | Michigan | Ontonagon | 26131 | 1215 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-10-09 04:21:16 | Ontonagon, Michigan, US | |
397945 | 397945 | 2022-10-07 | US | Michigan | Ontonagon | 26131 | 1215 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-10-08 04:22:56 | Ontonagon, Michigan, US | |
2531062 | 2531062 | 2022-10-06 | US | Michigan | Ontonagon | 26131 | 1215 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-10-07 04:23:08 | Ontonagon, Michigan, US | |
1812456 | 1812456 | 2022-10-05 | US | Michigan | Ontonagon | 26131 | 1215 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-10-06 04:21:22 | Ontonagon, Michigan, US | |
132430 | 132430 | 2022-10-04 | US | Michigan | Ontonagon | 26131 | 1215 | 43 | 0 | 46.6652262 | -89.31390481 | 2022-10-05 04:23:06 | Ontonagon, Michigan, US | |
373741 | 373741 | 2022-09-13 | US | Louisiana | Tensas | 22107 | 1215 | 13 | 0 | 32.00760749 | -91.32915234 | 2022-09-14 04:20:44 | Tensas, Louisiana, US | |
1877911 | 1877911 | 2022-08-28 | US | Idaho | Boise | 16015 | 1215 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-08-29 04:21:06 | Boise, Idaho, US | |
2097038 | 2097038 | 2022-08-27 | US | Idaho | Boise | 16015 | 1215 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-08-28 04:21:02 | Boise, Idaho, US | |
1532853 | 1532853 | 2022-08-26 | US | Idaho | Boise | 16015 | 1215 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-08-27 04:20:57 | Boise, Idaho, US | |
2010707 | 2010707 | 2022-08-04 | US | Montana | Mineral | 30061 | 1215 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-08-05 04:20:52 | Mineral, Montana, US | |
1100134 | 1100134 | 2022-08-03 | US | Montana | Mineral | 30061 | 1215 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-08-04 04:20:58 | Mineral, Montana, US | |
1407059 | 1407059 | 2022-08-02 | US | Montana | Mineral | 30061 | 1215 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-08-03 04:20:59 | Mineral, Montana, US | |
3619097 | 3619097 | 2022-08-01 | US | Montana | Mineral | 30061 | 1215 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-08-02 04:20:53 | Mineral, Montana, US | |
3873577 | 3873577 | 2022-07-31 | US | Montana | Mineral | 30061 | 1215 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-08-01 04:21:03 | Mineral, Montana, US | |
676331 | 676331 | 2022-07-30 | US | Montana | Mineral | 30061 | 1215 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-07-31 04:21:02 | Mineral, Montana, US | |
1785530 | 1785530 | 2022-07-29 | US | Montana | Mineral | 30061 | 1215 | 17 | 0 | 47.15283992 | -115.0015239 | 2022-07-30 04:20:42 | Mineral, Montana, US | |
3432329 | 3432329 | 2022-07-14 | US | Virginia | King and Queen | 51097 | 1215 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-15 04:20:53 | King and Queen, Virginia, US | |
2149730 | 2149730 | 2022-06-27 | US | Nebraska | Howard | 31093 | 1215 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-06-28 04:20:58 | Howard, Nebraska, US | |
477531 | 477531 | 2022-06-26 | US | Nebraska | Howard | 31093 | 1215 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-06-27 04:21:00 | Howard, Nebraska, US | |
940906 | 940906 | 2022-06-25 | US | Nebraska | Howard | 31093 | 1215 | 15 | 0 | 41.2200529 | -98.5166499 | 2022-06-26 04:21:02 | Howard, Nebraska, US | |
2980255 | 2980255 | 2022-06-13 | US | Illinois | Henderson | 17071 | 1215 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-06-14 04:20:52 | Henderson, Illinois, US | |
3729536 | 3729536 | 2022-06-07 | US | Virginia | Charles City | 51036 | 1215 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-06-08 04:20:55 | Charles City, Virginia, US | |
3189324 | 3189324 | 2022-05-30 | US | Virginia | Emporia | 51595 | 1215 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-31 04:20:51 | Emporia, Virginia, US | |
3201473 | 3201473 | 2022-05-29 | US | Virginia | Emporia | 51595 | 1215 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-30 04:20:50 | Emporia, Virginia, US | |
2728351 | 2728351 | 2022-05-28 | US | Virginia | Emporia | 51595 | 1215 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-29 04:20:53 | Emporia, Virginia, US | |
1317532 | 1317532 | 2022-05-27 | US | Virginia | Emporia | 51595 | 1215 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-28 04:21:07 | Emporia, Virginia, US | |
1853159 | 1853159 | 2022-05-26 | US | Texas | Martin | 48317 | 1215 | 26 | 0 | 32.30600051 | -101.9513518 | 2022-05-27 04:20:56 | Martin, Texas, US | |
3356758 | 3356758 | 2022-05-14 | US | Nebraska | Jefferson | 31095 | 1215 | 7 | 0 | 40.17584531 | -97.142601 | 2022-05-15 04:20:53 | Jefferson, Nebraska, US | |
660403 | 660403 | 2022-05-13 | US | Nebraska | Jefferson | 31095 | 1215 | 7 | 0 | 40.17584531 | -97.142601 | 2022-05-14 04:20:48 | Jefferson, Nebraska, US | |
2536496 | 2536496 | 2022-05-12 | US | Texas | Goliad | 48175 | 1215 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-05-13 04:20:51 | Goliad, Texas, US | |
2535486 | 2535486 | 2022-05-12 | US | Nebraska | Jefferson | 31095 | 1215 | 7 | 0 | 40.17584531 | -97.142601 | 2022-05-13 04:20:51 | Jefferson, Nebraska, US | |
3447942 | 3447942 | 2022-05-11 | US | Texas | Goliad | 48175 | 1215 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-05-12 04:20:54 | Goliad, Texas, US | |
3446932 | 3446932 | 2022-05-11 | US | Nebraska | Jefferson | 31095 | 1215 | 7 | 0 | 40.17584531 | -97.142601 | 2022-05-12 04:20:54 | Jefferson, Nebraska, US | |
3537549 | 3537549 | 2022-05-10 | US | Nebraska | Jefferson | 31095 | 1215 | 7 | 0 | 40.17584531 | -97.142601 | 2022-05-11 04:20:48 | Jefferson, Nebraska, US | |
1572791 | 1572791 | 2022-05-03 | US | Colorado | Saguache | 8109 | 1215 | 12 | 0 | 38.08054629 | -106.282466 | 2022-05-04 04:20:59 | Saguache, Colorado, US | |
3723938 | 3723938 | 2022-04-25 | US | Minnesota | Lincoln | 27081 | 1215 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-04-26 04:20:51 | Lincoln, Minnesota, US | |
2030506 | 2030506 | 2022-04-24 | US | Minnesota | Lincoln | 27081 | 1215 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-04-25 04:20:56 | Lincoln, Minnesota, US | |
748081 | 748081 | 2022-04-23 | US | Minnesota | Lincoln | 27081 | 1215 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-04-24 04:20:56 | Lincoln, Minnesota, US | |
3438566 | 3438566 | 2022-04-22 | US | Minnesota | Lincoln | 27081 | 1215 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-04-23 04:20:50 | Lincoln, Minnesota, US | |
2894151 | 2894151 | 2022-04-21 | US | Minnesota | Lincoln | 27081 | 1215 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-04-22 04:20:45 | Lincoln, Minnesota, US | |
2309023 | 2309023 | 2022-04-20 | US | Minnesota | Lincoln | 27081 | 1215 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-04-21 04:20:46 | Lincoln, Minnesota, US | |
2253162 | 2253162 | 2022-04-19 | US | Minnesota | Lincoln | 27081 | 1215 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-04-20 04:20:45 | Lincoln, Minnesota, US | |
1847712 | 1847712 | 2022-04-18 | US | Minnesota | Lincoln | 27081 | 1215 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-04-19 04:21:00 | Lincoln, Minnesota, US | |
3420377 | 3420377 | 2022-04-17 | US | Washington | San Juan | 53055 | 1215 | 2 | 0 | 48.60182783 | -122.96745 | 2022-04-18 04:21:12 | San Juan, Washington, US | |
307326 | 307326 | 2022-04-16 | US | Washington | San Juan | 53055 | 1215 | 2 | 0 | 48.60182783 | -122.96745 | 2022-04-17 04:20:59 | San Juan, Washington, US | |
2673271 | 2673271 | 2022-04-15 | US | Washington | San Juan | 53055 | 1215 | 2 | 0 | 48.60182783 | -122.96745 | 2022-04-16 04:20:48 | San Juan, Washington, US | |
2266623 | 2266623 | 2022-03-14 | US | Puerto Rico | Ceiba | 72037 | 1215 | 0 | 0 | 18.251818 | -65.666416 | 2022-03-15 04:20:47 | Ceiba, Puerto Rico, US | |
3630689 | 3630689 | 2022-03-13 | US | Puerto Rico | Ceiba | 72037 | 1215 | 0 | 0 | 18.251818 | -65.666416 | 2022-03-14 04:20:46 | Ceiba, Puerto Rico, US | |
2143458 | 2143458 | 2022-03-09 | US | Vermont | Essex | 50009 | 1215 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-03-10 04:20:48 | Essex, Vermont, US | |
3048939 | 3048939 | 2022-02-26 | US | Puerto Rico | Maunabo | 72095 | 1215 | 0 | 0 | 18.017889 | -65.922235 | 2022-02-27 04:21:04 | Maunabo, Puerto Rico, US | |
1300693 | 1300693 | 2022-02-17 | US | Oregon | Wallowa | 41063 | 1215 | 14 | 0 | 45.57894064 | -117.18353799999998 | 2022-02-18 04:21:04 | Wallowa, Oregon, US | |
3672904 | 3672904 | 2022-02-15 | US | Iowa | Wayne | 19185 | 1215 | 32 | 0 | 40.73969028 | -93.32752197 | 2022-02-16 04:21:10 | Wayne, Iowa, US | |
2643005 | 2643005 | 2022-02-14 | US | Iowa | Wayne | 19185 | 1215 | 32 | 0 | 40.73969028 | -93.32752197 | 2022-02-15 04:21:09 | Wayne, Iowa, US | |
187322 | 187322 | 2022-02-13 | US | Iowa | Wayne | 19185 | 1215 | 32 | 0 | 40.73969028 | -93.32752197 | 2022-02-14 04:20:51 | Wayne, Iowa, US | |
317168 | 317168 | 2022-02-12 | US | Iowa | Wayne | 19185 | 1215 | 32 | 0 | 40.73969028 | -93.32752197 | 2022-02-13 04:21:00 | Wayne, Iowa, US | |
234494 | 234494 | 2022-02-11 | US | Iowa | Wayne | 19185 | 1215 | 32 | 0 | 40.73969028 | -93.32752197 | 2022-02-12 04:21:06 | Wayne, Iowa, 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]);