johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,119 rows where confirmed = 186 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 22
- US 1,043
- China 28
- Japan 12
- Canada 6
- Brunei 3
- France 3
- Netherlands 3
- United Kingdom 3
- Congo (Brazzaville) 2
- Madagascar 2
- Malaysia 2
- Mongolia 2
- Albania 1
- Angola 1
- Australia 1
- Cabo Verde 1
- Cuba 1
- India 1
- Mauritius 1
- Monaco 1
- Sweden 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
320597 | 320597 | 2022-10-30 | US | Colorado | Unassigned | 90008 | 186 | 2 | 0 | 40.87595412 | 0.0 | 2022-10-31 04:21:36 | Unassigned, Colorado, US | |
912873 | 912873 | 2022-10-29 | US | Colorado | Unassigned | 90008 | 186 | 2 | 0 | 40.87595412 | 0.0 | 2022-10-30 04:22:14 | Unassigned, Colorado, US | |
1367142 | 1367142 | 2022-10-28 | US | Colorado | Unassigned | 90008 | 186 | 2 | 0 | 40.87595412 | 0.0 | 2022-10-29 04:21:13 | Unassigned, Colorado, US | |
3038997 | 3038997 | 2022-10-27 | US | Colorado | Unassigned | 90008 | 186 | 2 | 0 | 40.87595412 | 0.0 | 2022-10-28 04:22:31 | Unassigned, Colorado, US | |
2019611 | 2019611 | 2022-09-20 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-21 04:23:22 | Jones, South Dakota, US | |
3573484 | 3573484 | 2022-09-19 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-20 04:22:48 | Jones, South Dakota, US | |
422223 | 422223 | 2022-09-18 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-19 04:21:49 | Jones, South Dakota, US | |
3376247 | 3376247 | 2022-09-17 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-18 04:22:50 | Jones, South Dakota, US | |
2358355 | 2358355 | 2022-09-16 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-17 04:20:19 | Jones, South Dakota, US | |
3989512 | 3989512 | 2022-09-15 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-16 04:21:19 | Jones, South Dakota, US | |
1892029 | 1892029 | 2022-09-14 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-15 04:21:02 | Jones, South Dakota, US | |
375408 | 375408 | 2022-09-13 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-14 04:20:44 | Roberts, Texas, US | |
375084 | 375084 | 2022-09-13 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-14 04:20:44 | Jones, South Dakota, US | |
2398010 | 2398010 | 2022-09-12 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-13 04:20:57 | Roberts, Texas, US | |
2397686 | 2397686 | 2022-09-12 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-13 04:20:57 | Jones, South Dakota, US | |
3769088 | 3769088 | 2022-09-11 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-12 04:20:58 | Roberts, Texas, US | |
3768764 | 3768764 | 2022-09-11 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-12 04:20:58 | Jones, South Dakota, US | |
3827663 | 3827663 | 2022-09-10 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-11 04:20:50 | Roberts, Texas, US | |
3827339 | 3827339 | 2022-09-10 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-11 04:20:50 | Jones, South Dakota, US | |
966120 | 966120 | 2022-09-09 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-10 04:21:10 | Roberts, Texas, US | |
965796 | 965796 | 2022-09-09 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-10 04:21:10 | Jones, South Dakota, US | |
256522 | 256522 | 2022-09-08 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-09 04:21:11 | Roberts, Texas, US | |
256198 | 256198 | 2022-09-08 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-09 04:21:11 | Jones, South Dakota, US | |
3748320 | 3748320 | 2022-09-07 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-08 04:21:02 | Roberts, Texas, US | |
3747996 | 3747996 | 2022-09-07 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-08 04:21:02 | Jones, South Dakota, US | |
117960 | 117960 | 2022-09-06 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-07 04:20:59 | Roberts, Texas, US | |
117636 | 117636 | 2022-09-06 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-07 04:20:59 | Jones, South Dakota, US | |
2636932 | 2636932 | 2022-09-05 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-06 04:21:02 | Roberts, Texas, US | |
2636608 | 2636608 | 2022-09-05 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-06 04:21:02 | Jones, South Dakota, US | |
2990496 | 2990496 | 2022-09-04 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-05 04:21:01 | Roberts, Texas, US | |
2990172 | 2990172 | 2022-09-04 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-05 04:21:01 | Jones, South Dakota, US | |
2716181 | 2716181 | 2022-09-03 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-04 04:21:22 | Roberts, Texas, US | |
2715857 | 2715857 | 2022-09-03 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-04 04:21:22 | Jones, South Dakota, US | |
1396886 | 1396886 | 2022-09-02 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-03 04:21:04 | Roberts, Texas, US | |
1396562 | 1396562 | 2022-09-02 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-03 04:21:04 | Jones, South Dakota, US | |
3550715 | 3550715 | 2022-09-01 | US | Texas | Roberts | 48393 | 186 | 2 | 0 | 35.83809685 | -100.813175 | 2022-09-02 04:21:07 | Roberts, Texas, US | |
3550391 | 3550391 | 2022-09-01 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-02 04:21:07 | Jones, South Dakota, US | |
2346311 | 2346311 | 2022-08-31 | US | South Dakota | Jones | 46075 | 186 | 2 | 0 | 43.96278565 | -100.6940008 | 2022-09-01 04:21:03 | Jones, South Dakota, US | |
880070 | 880070 | 2022-08-05 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-06 04:20:56 | Guizhou, China | |||
2008481 | 2008481 | 2022-08-04 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-05 04:20:52 | Guizhou, China | |||
1097908 | 1097908 | 2022-08-03 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-04 04:20:58 | Guizhou, China | |||
1404833 | 1404833 | 2022-08-02 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-03 04:20:59 | Guizhou, China | |||
3616871 | 3616871 | 2022-08-01 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-02 04:20:53 | Guizhou, China | |||
3871351 | 3871351 | 2022-07-31 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-08-01 04:21:03 | Guizhou, China | |||
674105 | 674105 | 2022-07-30 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-31 04:21:02 | Guizhou, China | |||
1783304 | 1783304 | 2022-07-29 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-30 04:20:42 | Guizhou, China | |||
1065667 | 1065667 | 2022-07-28 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-29 04:20:45 | Guizhou, China | |||
2335186 | 2335186 | 2022-07-27 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-28 04:20:56 | Guizhou, China | |||
1487376 | 1487376 | 2022-07-26 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-27 04:21:04 | Guizhou, China | |||
2593822 | 2593822 | 2022-07-25 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-26 04:20:58 | Guizhou, China | |||
895937 | 895937 | 2022-07-24 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-25 04:20:51 | Guizhou, China | |||
90931 | 90931 | 2022-07-23 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-24 04:20:47 | Guizhou, China | |||
899953 | 899953 | 2022-07-22 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-23 04:20:53 | Guizhou, China | |||
670089 | 670089 | 2022-07-21 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-22 04:21:15 | Guizhou, China | |||
1608891 | 1608891 | 2022-07-20 | US | Colorado | Jackson | 8057 | 186 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-21 04:21:10 | Jackson, Colorado, US | |
1608052 | 1608052 | 2022-07-20 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-21 04:21:10 | Guizhou, China | |||
959524 | 959524 | 2022-07-19 | US | Colorado | Jackson | 8057 | 186 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-20 04:20:59 | Jackson, Colorado, US | |
958685 | 958685 | 2022-07-19 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-20 04:20:59 | Guizhou, China | |||
3210911 | 3210911 | 2022-07-18 | US | Colorado | Jackson | 8057 | 186 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-19 04:20:58 | Jackson, Colorado, US | |
3210072 | 3210072 | 2022-07-18 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-19 04:20:58 | Guizhou, China | |||
3406086 | 3406086 | 2022-07-17 | US | Colorado | Jackson | 8057 | 186 | 0 | 0 | 40.6659387 | -106.3408905 | 2022-07-18 04:20:59 | Jackson, Colorado, US | |
3405247 | 3405247 | 2022-07-17 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-18 04:20:59 | Guizhou, China | |||
2151447 | 2151447 | 2022-07-16 | China | Guizhou | 186 | 2 | 0 | 26.8154 | 106.8748 | 2022-07-17 04:21:15 | Guizhou, China | |||
3919197 | 3919197 | 2022-05-01 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-02 04:21:10 | Loving, Texas, US | |
2844001 | 2844001 | 2022-04-30 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-05-01 04:20:57 | Loving, Texas, US | |
2843577 | 2843577 | 2022-04-30 | US | Puerto Rico | Culebra | 72049 | 186 | 0 | 0 | 18.31586 | -65.28813 | 2022-05-01 04:20:57 | Culebra, Puerto Rico, US | |
1160314 | 1160314 | 2022-04-29 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-30 04:21:05 | Loving, Texas, US | |
1699496 | 1699496 | 2022-04-28 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-29 04:20:59 | Loving, Texas, US | |
3854979 | 3854979 | 2022-04-27 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-28 04:20:47 | Loving, Texas, US | |
1329409 | 1329409 | 2022-04-26 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-27 04:20:52 | Loving, Texas, US | |
3725363 | 3725363 | 2022-04-25 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-26 04:20:51 | Loving, Texas, US | |
2031931 | 2031931 | 2022-04-24 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-25 04:20:56 | Loving, Texas, US | |
749506 | 749506 | 2022-04-23 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-24 04:20:56 | Loving, Texas, US | |
3439991 | 3439991 | 2022-04-22 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-23 04:20:50 | Loving, Texas, US | |
2895576 | 2895576 | 2022-04-21 | US | Texas | Loving | 48301 | 186 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-04-22 04:20:45 | Loving, Texas, US | |
2052935 | 2052935 | 2022-01-25 | US | Illinois | Unassigned | 90017 | 186 | 3648 | 0 | 42.36542373 | 0.0 | 2022-01-26 04:21:07 | Unassigned, Illinois, US | |
2835919 | 2835919 | 2022-01-22 | US | Texas | Foard | 48155 | 186 | 10 | 0 | 33.97308618 | -99.7767797 | 2022-01-23 04:21:13 | Foard, Texas, US | |
3428046 | 3428046 | 2022-01-21 | US | Texas | Glasscock | 48173 | 186 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-01-22 04:21:13 | Glasscock, Texas, US | |
3428037 | 3428037 | 2022-01-21 | US | Texas | Foard | 48155 | 186 | 10 | 0 | 33.97308618 | -99.7767797 | 2022-01-22 04:21:13 | Foard, Texas, US | |
3425604 | 3425604 | 2022-01-21 | US | Colorado | San Juan | 8111 | 186 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2022-01-22 04:21:13 | San Juan, Colorado, US | |
1963645 | 1963645 | 2022-01-20 | US | Texas | Foard | 48155 | 186 | 10 | 0 | 33.97308618 | -99.7767797 | 2022-01-21 04:21:09 | Foard, Texas, US | |
1693196 | 1693196 | 2022-01-10 | US | Georgia | Taliaferro | 13265 | 186 | 3 | 0 | 33.56543317 | -82.88136816 | 2022-01-11 04:22:01 | Taliaferro, Georgia, US | |
1702491 | 1702491 | 2022-01-03 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2022-01-04 04:22:17 | Eureka, Nevada, US | |
3521574 | 3521574 | 2022-01-02 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2022-01-03 02:22:25 | Eureka, Nevada, US | |
3520485 | 3520485 | 2022-01-02 | US | Illinois | Unassigned | 90017 | 186 | 3196 | 0 | 42.36542373 | 0.0 | 2022-01-03 02:22:25 | Unassigned, Illinois, US | |
2169704 | 2169704 | 2022-01-01 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2022-01-02 04:20:52 | Eureka, Nevada, US | |
2168615 | 2168615 | 2022-01-01 | US | Illinois | Unassigned | 90017 | 186 | 3196 | 0 | 42.36542373 | 0.0 | 2022-01-02 04:20:52 | Unassigned, Illinois, US | |
2779135 | 2779135 | 2021-12-31 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2022-01-01 04:22:14 | Eureka, Nevada, US | |
2778046 | 2778046 | 2021-12-31 | US | Illinois | Unassigned | 90017 | 186 | 3196 | 0 | 42.36542373 | 0.0 | 2022-01-01 04:22:14 | Unassigned, Illinois, US | |
4000792 | 4000792 | 2021-12-30 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-31 04:21:50 | Eureka, Nevada, US | |
3999703 | 3999703 | 2021-12-30 | US | Illinois | Unassigned | 90017 | 186 | 3174 | 0 | 42.36542373 | 0.0 | 2021-12-31 04:21:50 | Unassigned, Illinois, US | |
1670599 | 1670599 | 2021-12-29 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-30 04:21:25 | Eureka, Nevada, US | |
1434708 | 1434708 | 2021-12-28 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-29 03:21:43 | Eureka, Nevada, US | |
732669 | 732669 | 2021-12-27 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-28 04:21:47 | Eureka, Nevada, US | |
2113841 | 2113841 | 2021-12-26 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-27 04:21:58 | Eureka, Nevada, US | |
3607213 | 3607213 | 2021-12-25 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-26 04:21:50 | Eureka, Nevada, US | |
2965531 | 2965531 | 2021-12-24 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-25 04:21:37 | Eureka, Nevada, US | |
3818563 | 3818563 | 2021-12-23 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-24 04:21:34 | Eureka, Nevada, US | |
800571 | 800571 | 2021-12-22 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-23 04:21:21 | Eureka, Nevada, US | |
3830611 | 3830611 | 2021-12-21 | US | Nevada | Eureka | 32011 | 186 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-12-22 04:21:54 | Eureka, Nevada, 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]);