johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
639 rows where confirmed = 779 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 617
- Japan 6
- China 3
- Canada 2
- Timor-Leste 2
- Angola 1
- Denmark 1
- Egypt 1
- Estonia 1
- Mainland China 1
- Malaysia 1
- Mali 1
- Netherlands 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2181584 | 2181584 | 2022-12-22 | US | Montana | Fallon | 30025 | 779 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-23 04:21:04 | Fallon, Montana, US | |
453388 | 453388 | 2022-12-21 | US | Montana | Fallon | 30025 | 779 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-22 04:20:56 | Fallon, Montana, US | |
2954290 | 2954290 | 2022-12-20 | US | South Dakota | Perkins | 46105 | 779 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-21 04:21:03 | Perkins, South Dakota, US | |
2953387 | 2953387 | 2022-12-20 | US | Montana | Fallon | 30025 | 779 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-21 04:21:03 | Fallon, Montana, US | |
3176692 | 3176692 | 2022-12-19 | US | South Dakota | Perkins | 46105 | 779 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-20 04:21:04 | Perkins, South Dakota, US | |
3175789 | 3175789 | 2022-12-19 | US | Montana | Fallon | 30025 | 779 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-20 04:21:04 | Fallon, Montana, US | |
1631209 | 1631209 | 2022-12-18 | US | South Dakota | Perkins | 46105 | 779 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-19 04:21:03 | Perkins, South Dakota, US | |
1630306 | 1630306 | 2022-12-18 | US | Montana | Fallon | 30025 | 779 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-19 04:21:03 | Fallon, Montana, US | |
506588 | 506588 | 2022-12-17 | US | South Dakota | Perkins | 46105 | 779 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-18 04:21:03 | Perkins, South Dakota, US | |
505685 | 505685 | 2022-12-17 | US | Montana | Fallon | 30025 | 779 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-18 04:21:03 | Fallon, Montana, US | |
3327160 | 3327160 | 2022-12-16 | US | South Dakota | Perkins | 46105 | 779 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-17 04:21:04 | Perkins, South Dakota, US | |
3326257 | 3326257 | 2022-12-16 | US | Montana | Fallon | 30025 | 779 | 12 | 0 | 46.33478338 | -104.4183565 | 2022-12-17 04:21:04 | Fallon, Montana, US | |
545672 | 545672 | 2022-12-15 | US | South Dakota | Perkins | 46105 | 779 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-16 04:21:01 | Perkins, South Dakota, US | |
351200 | 351200 | 2022-12-14 | US | South Dakota | Perkins | 46105 | 779 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-15 04:20:58 | Perkins, South Dakota, US | |
2559459 | 2559459 | 2022-11-29 | US | South Dakota | Douglas | 46043 | 779 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-30 04:21:07 | Douglas, South Dakota, US | |
1242533 | 1242533 | 2022-11-28 | US | South Dakota | Douglas | 46043 | 779 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-29 04:21:05 | Douglas, South Dakota, US | |
3554521 | 3554521 | 2022-11-27 | US | South Dakota | Douglas | 46043 | 779 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-28 04:21:02 | Douglas, South Dakota, US | |
2103001 | 2103001 | 2022-11-26 | US | South Dakota | Douglas | 46043 | 779 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-27 04:21:05 | Douglas, South Dakota, US | |
490492 | 490492 | 2022-11-25 | US | South Dakota | Douglas | 46043 | 779 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-26 04:21:11 | Douglas, South Dakota, US | |
3526321 | 3526321 | 2022-11-24 | US | South Dakota | Douglas | 46043 | 779 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-25 04:21:06 | Douglas, South Dakota, US | |
3315104 | 3315104 | 2022-11-23 | US | South Dakota | Douglas | 46043 | 779 | 16 | 0 | 43.38520741 | -98.36978007 | 2022-11-24 04:21:09 | Douglas, South Dakota, US | |
3599008 | 3599008 | 2022-11-14 | US | Missouri | Scotland | 29199 | 779 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-15 04:21:16 | Scotland, Missouri, US | |
313866 | 313866 | 2022-11-13 | US | Missouri | Scotland | 29199 | 779 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-14 04:21:09 | Scotland, Missouri, US | |
65027 | 65027 | 2022-11-12 | US | Missouri | Scotland | 29199 | 779 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-13 04:21:14 | Scotland, Missouri, US | |
2929189 | 2929189 | 2022-11-11 | US | Missouri | Scotland | 29199 | 779 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-12 04:20:41 | Scotland, Missouri, US | |
2508025 | 2508025 | 2022-11-10 | US | Missouri | Scotland | 29199 | 779 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-11 04:21:22 | Scotland, Missouri, US | |
2432900 | 2432900 | 2022-11-09 | US | Missouri | Scotland | 29199 | 779 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-10 04:21:16 | Scotland, Missouri, US | |
481556 | 481556 | 2022-11-08 | US | Missouri | Scotland | 29199 | 779 | 18 | 0 | 40.45214695 | -92.14709064 | 2022-11-09 04:21:22 | Scotland, Missouri, US | |
2968023 | 2968023 | 2022-10-10 | US | Colorado | Custer | 8027 | 779 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-10-11 04:23:05 | Custer, Colorado, US | |
3098059 | 3098059 | 2022-10-09 | US | Colorado | Custer | 8027 | 779 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-10-10 04:22:32 | Custer, Colorado, US | |
4003284 | 4003284 | 2022-10-08 | US | Colorado | Custer | 8027 | 779 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-10-09 04:21:16 | Custer, Colorado, US | |
396881 | 396881 | 2022-10-07 | US | Colorado | Custer | 8027 | 779 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-10-08 04:22:56 | Custer, Colorado, US | |
2529998 | 2529998 | 2022-10-06 | US | Colorado | Custer | 8027 | 779 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-10-07 04:23:08 | Custer, Colorado, US | |
1811392 | 1811392 | 2022-10-05 | US | Colorado | Custer | 8027 | 779 | 22 | 0 | 38.10883162 | -105.3683478 | 2022-10-06 04:21:22 | Custer, Colorado, US | |
3573000 | 3573000 | 2022-09-19 | US | North Dakota | Emmons | 38029 | 779 | 18 | 0 | 46.28398398 | -100.2389766 | 2022-09-20 04:22:48 | Emmons, North Dakota, US | |
1251183 | 1251183 | 2022-08-23 | US | Alaska | Haines | 2100 | 779 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-08-24 04:20:46 | Haines, Alaska, US | |
2853287 | 2853287 | 2022-08-22 | US | Alaska | Haines | 2100 | 779 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-08-23 04:20:56 | Haines, Alaska, US | |
2403259 | 2403259 | 2022-08-21 | US | Alaska | Haines | 2100 | 779 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-08-22 04:20:38 | Haines, Alaska, US | |
3798337 | 3798337 | 2022-08-20 | US | Alaska | Haines | 2100 | 779 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-08-21 04:20:44 | Haines, Alaska, US | |
2363923 | 2363923 | 2022-08-19 | US | Alaska | Haines | 2100 | 779 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-08-20 04:21:01 | Haines, Alaska, US | |
1161594 | 1161594 | 2022-08-18 | US | Alaska | Haines | 2100 | 779 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-08-19 04:20:54 | Haines, Alaska, US | |
3950918 | 3950918 | 2022-08-17 | US | Alaska | Haines | 2100 | 779 | 1 | 0 | 59.09893571 | -135.4679843 | 2022-08-18 04:21:11 | Haines, Alaska, US | |
2010722 | 2010722 | 2022-08-04 | US | Montana | Sheridan | 30091 | 779 | 12 | 0 | 48.72085833 | -104.503829 | 2022-08-05 04:20:52 | Sheridan, Montana, US | |
1100149 | 1100149 | 2022-08-03 | US | Montana | Sheridan | 30091 | 779 | 12 | 0 | 48.72085833 | -104.503829 | 2022-08-04 04:20:58 | Sheridan, Montana, US | |
1407074 | 1407074 | 2022-08-02 | US | Montana | Sheridan | 30091 | 779 | 12 | 0 | 48.72085833 | -104.503829 | 2022-08-03 04:20:59 | Sheridan, Montana, US | |
3620229 | 3620229 | 2022-08-01 | US | Texas | Kinney | 48271 | 779 | 11 | 0 | 29.34967888 | -100.4186638 | 2022-08-02 04:20:53 | Kinney, Texas, US | |
3619112 | 3619112 | 2022-08-01 | US | Montana | Sheridan | 30091 | 779 | 12 | 0 | 48.72085833 | -104.503829 | 2022-08-02 04:20:53 | Sheridan, Montana, US | |
3874709 | 3874709 | 2022-07-31 | US | Texas | Kinney | 48271 | 779 | 11 | 0 | 29.34967888 | -100.4186638 | 2022-08-01 04:21:03 | Kinney, Texas, US | |
3873592 | 3873592 | 2022-07-31 | US | Montana | Sheridan | 30091 | 779 | 12 | 0 | 48.72085833 | -104.503829 | 2022-08-01 04:21:03 | Sheridan, Montana, US | |
677463 | 677463 | 2022-07-30 | US | Texas | Kinney | 48271 | 779 | 11 | 0 | 29.34967888 | -100.4186638 | 2022-07-31 04:21:02 | Kinney, Texas, US | |
676346 | 676346 | 2022-07-30 | US | Montana | Sheridan | 30091 | 779 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-31 04:21:02 | Sheridan, Montana, US | |
1786662 | 1786662 | 2022-07-29 | US | Texas | Kinney | 48271 | 779 | 11 | 0 | 29.34967888 | -100.4186638 | 2022-07-30 04:20:42 | Kinney, Texas, US | |
1785545 | 1785545 | 2022-07-29 | US | Montana | Sheridan | 30091 | 779 | 12 | 0 | 48.72085833 | -104.503829 | 2022-07-30 04:20:42 | Sheridan, Montana, US | |
1069025 | 1069025 | 2022-07-28 | US | Texas | Kinney | 48271 | 779 | 11 | 0 | 29.34967888 | -100.4186638 | 2022-07-29 04:20:45 | Kinney, Texas, US | |
2338544 | 2338544 | 2022-07-27 | US | Texas | Kinney | 48271 | 779 | 11 | 0 | 29.34967888 | -100.4186638 | 2022-07-28 04:20:56 | Kinney, Texas, US | |
1419487 | 1419487 | 2022-07-08 | US | North Dakota | Eddy | 38027 | 779 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-07-09 04:20:59 | Eddy, North Dakota, US | |
2743412 | 2743412 | 2022-07-07 | US | North Dakota | Eddy | 38027 | 779 | 6 | 0 | 47.71701474 | -98.90432337 | 2022-07-08 04:20:56 | Eddy, North Dakota, US | |
3271931 | 3271931 | 2022-06-19 | US | North Dakota | Nelson | 38063 | 779 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-20 04:21:01 | Nelson, North Dakota, US | |
3399843 | 3399843 | 2022-06-18 | US | North Dakota | Nelson | 38063 | 779 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-19 04:20:51 | Nelson, North Dakota, US | |
2313720 | 2313720 | 2022-06-17 | US | North Dakota | Nelson | 38063 | 779 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-18 04:21:10 | Nelson, North Dakota, US | |
561224 | 561224 | 2022-06-16 | US | North Dakota | Nelson | 38063 | 779 | 18 | 0 | 47.9226426 | -98.19038437 | 2022-06-17 04:20:56 | Nelson, North Dakota, US | |
3509493 | 3509493 | 2022-06-05 | US | Nebraska | Nance | 31125 | 779 | 12 | 0 | 41.39750195 | -97.99327291 | 2022-06-06 04:20:57 | Nance, Nebraska, US | |
3529570 | 3529570 | 2022-06-04 | US | Nebraska | Nance | 31125 | 779 | 12 | 0 | 41.39750195 | -97.99327291 | 2022-06-05 04:20:55 | Nance, Nebraska, US | |
3898167 | 3898167 | 2022-05-19 | US | New Mexico | Mora | 35033 | 779 | 18 | 0 | 36.01095101 | -104.9497716 | 2022-05-20 04:20:57 | Mora, New Mexico, US | |
1505335 | 1505335 | 2022-05-16 | US | Minnesota | Lake of the Woods | 27077 | 779 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-17 04:20:59 | Lake of the Woods, Minnesota, US | |
2085694 | 2085694 | 2022-05-15 | US | Minnesota | Lake of the Woods | 27077 | 779 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-16 04:20:47 | Lake of the Woods, Minnesota, US | |
3356404 | 3356404 | 2022-05-14 | US | Minnesota | Lake of the Woods | 27077 | 779 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-15 04:20:53 | Lake of the Woods, Minnesota, US | |
660049 | 660049 | 2022-05-13 | US | Minnesota | Lake of the Woods | 27077 | 779 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-14 04:20:48 | Lake of the Woods, Minnesota, US | |
3537195 | 3537195 | 2022-05-10 | US | Minnesota | Lake of the Woods | 27077 | 779 | 6 | 0 | 48.77217001 | -94.90274472 | 2022-05-11 04:20:48 | Lake of the Woods, Minnesota, US | |
1697660 | 1697660 | 2022-04-28 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-29 04:20:59 | Ness, Kansas, US | |
3853143 | 3853143 | 2022-04-27 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-28 04:20:47 | Ness, Kansas, US | |
1327573 | 1327573 | 2022-04-26 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-27 04:20:52 | Ness, Kansas, US | |
3723527 | 3723527 | 2022-04-25 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-26 04:20:51 | Ness, Kansas, US | |
2030095 | 2030095 | 2022-04-24 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-25 04:20:56 | Ness, Kansas, US | |
747670 | 747670 | 2022-04-23 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-24 04:20:56 | Ness, Kansas, US | |
3438155 | 3438155 | 2022-04-22 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-23 04:20:50 | Ness, Kansas, US | |
2893740 | 2893740 | 2022-04-21 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-22 04:20:45 | Ness, Kansas, US | |
2308612 | 2308612 | 2022-04-20 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-21 04:20:46 | Ness, Kansas, US | |
2252751 | 2252751 | 2022-04-19 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-20 04:20:45 | Ness, Kansas, US | |
1847301 | 1847301 | 2022-04-18 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-19 04:21:00 | Ness, Kansas, US | |
3418245 | 3418245 | 2022-04-17 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-18 04:21:12 | Ness, Kansas, US | |
305194 | 305194 | 2022-04-16 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-17 04:20:59 | Ness, Kansas, US | |
2671139 | 2671139 | 2022-04-15 | US | Kansas | Ness | 20135 | 779 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-04-16 04:20:48 | Ness, Kansas, US | |
3732008 | 3732008 | 2022-04-03 | US | Minnesota | Unassigned | 90027 | 779 | 230 | 0 | 48.77754106 | 0.0 | 2022-04-04 04:20:51 | Unassigned, Minnesota, US | |
501443 | 501443 | 2022-04-02 | US | Minnesota | Unassigned | 90027 | 779 | 230 | 0 | 48.77754106 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Minnesota, US | |
3352428 | 3352428 | 2022-04-01 | US | Minnesota | Unassigned | 90027 | 779 | 230 | 0 | 48.77754106 | 0.0 | 2022-04-02 04:20:47 | Unassigned, Minnesota, US | |
1541733 | 1541733 | 2022-03-31 | US | Minnesota | Unassigned | 90027 | 779 | 230 | 0 | 48.77754106 | 0.0 | 2022-04-01 04:20:28 | Unassigned, Minnesota, US | |
1907415 | 1907415 | 2022-03-22 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-23 04:20:48 | Union, New Mexico, US | |
3240546 | 3240546 | 2022-03-21 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-22 04:20:54 | Union, New Mexico, US | |
26619 | 26619 | 2022-03-20 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-21 04:20:50 | Union, New Mexico, US | |
1658629 | 1658629 | 2022-03-19 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-20 04:20:45 | Union, New Mexico, US | |
338155 | 338155 | 2022-03-18 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-19 04:20:47 | Union, New Mexico, US | |
696608 | 696608 | 2022-03-17 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-18 04:20:55 | Union, New Mexico, US | |
694834 | 694834 | 2022-03-17 | US | American Samoa | 60 | 779 | 0 | 0 | -14.270999999999999 | -170.132 | 2022-03-18 04:20:55 | American Samoa, US | ||
2321551 | 2321551 | 2022-03-16 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-17 04:20:56 | Union, New Mexico, US | |
2319777 | 2319777 | 2022-03-16 | US | American Samoa | 60 | 779 | 0 | 0 | -14.270999999999999 | -170.132 | 2022-03-17 04:20:56 | American Samoa, US | ||
263751 | 263751 | 2022-03-15 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-16 04:20:50 | Union, New Mexico, US | |
2266110 | 2266110 | 2022-03-14 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-15 04:20:47 | Union, New Mexico, US | |
3631125 | 3631125 | 2022-03-13 | US | Texas | Mason | 48319 | 779 | 12 | 0 | 30.71780434 | -99.22629416 | 2022-03-14 04:20:46 | Mason, Texas, US | |
3630176 | 3630176 | 2022-03-13 | US | New Mexico | Union | 35059 | 779 | 15 | 0 | 36.48126404 | -103.4709624 | 2022-03-14 04:20:46 | Union, New Mexico, 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]);