johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
370 rows where confirmed = 2128 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1075646 | 1075646 | 2022-12-28 | US | Minnesota | Lac qui Parle | 27073 | 2128 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-12-29 04:21:01 | Lac qui Parle, Minnesota, US | |
329643 | 329643 | 2022-12-27 | US | Minnesota | Lac qui Parle | 27073 | 2128 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-12-28 04:21:04 | Lac qui Parle, Minnesota, US | |
219716 | 219716 | 2022-12-26 | US | Minnesota | Lac qui Parle | 27073 | 2128 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-12-27 04:21:07 | Lac qui Parle, Minnesota, US | |
3224173 | 3224173 | 2022-12-25 | US | Minnesota | Lac qui Parle | 27073 | 2128 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-12-26 04:21:06 | Lac qui Parle, Minnesota, US | |
1020087 | 1020087 | 2022-12-24 | US | Minnesota | Lac qui Parle | 27073 | 2128 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-12-25 04:21:04 | Lac qui Parle, Minnesota, US | |
692110 | 692110 | 2022-12-23 | US | Minnesota | Lac qui Parle | 27073 | 2128 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-12-24 04:21:02 | Lac qui Parle, Minnesota, US | |
2181320 | 2181320 | 2022-12-22 | US | Minnesota | Lac qui Parle | 27073 | 2128 | 30 | 0 | 44.9973857 | -96.17488219 | 2022-12-23 04:21:04 | Lac qui Parle, Minnesota, US | |
1630473 | 1630473 | 2022-12-18 | US | New Hampshire | Unassigned | 90033 | 2128 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-19 04:21:03 | Unassigned, New Hampshire, US | |
505852 | 505852 | 2022-12-17 | US | New Hampshire | Unassigned | 90033 | 2128 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-18 04:21:03 | Unassigned, New Hampshire, US | |
3326424 | 3326424 | 2022-12-16 | US | New Hampshire | Unassigned | 90033 | 2128 | 6 | 0 | 44.69063265 | 0.0 | 2022-12-17 04:21:04 | Unassigned, New Hampshire, US | |
1830790 | 1830790 | 2022-10-25 | US | Colorado | Lake | 8065 | 2128 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-10-26 04:22:19 | Lake, Colorado, US | |
795051 | 795051 | 2022-10-24 | US | Colorado | Lake | 8065 | 2128 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-10-25 04:21:53 | Lake, Colorado, US | |
3277506 | 3277506 | 2022-10-23 | US | Colorado | Lake | 8065 | 2128 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-10-24 04:22:29 | Lake, Colorado, US | |
2268544 | 2268544 | 2022-10-22 | US | Colorado | Lake | 8065 | 2128 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-10-23 04:22:46 | Lake, Colorado, US | |
1592844 | 1592844 | 2022-10-21 | US | Colorado | Lake | 8065 | 2128 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-10-22 04:22:53 | Lake, Colorado, US | |
2272560 | 2272560 | 2022-10-20 | US | Colorado | Lake | 8065 | 2128 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-10-21 04:22:23 | Lake, Colorado, US | |
3253577 | 3253577 | 2022-10-11 | US | Virginia | Williamsburg | 51830 | 2128 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-12 04:22:51 | Williamsburg, Virginia, US | |
3769188 | 3769188 | 2022-09-11 | US | Virginia | Bland | 51021 | 2128 | 26 | 0 | 37.13128068 | -81.13599391 | 2022-09-12 04:20:58 | Bland, Virginia, US | |
3827763 | 3827763 | 2022-09-10 | US | Virginia | Bland | 51021 | 2128 | 26 | 0 | 37.13128068 | -81.13599391 | 2022-09-11 04:20:50 | Bland, Virginia, US | |
966220 | 966220 | 2022-09-09 | US | Virginia | Bland | 51021 | 2128 | 26 | 0 | 37.13128068 | -81.13599391 | 2022-09-10 04:21:10 | Bland, Virginia, US | |
2830724 | 2830724 | 2022-08-25 | US | Missouri | Harrison | 29081 | 2128 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-08-26 04:21:02 | Harrison, Missouri, US | |
2325257 | 2325257 | 2022-08-24 | US | Missouri | Harrison | 29081 | 2128 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-08-25 04:21:13 | Harrison, Missouri, US | |
1252666 | 1252666 | 2022-08-23 | US | Missouri | Harrison | 29081 | 2128 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-08-24 04:20:46 | Harrison, Missouri, US | |
2854770 | 2854770 | 2022-08-22 | US | Missouri | Harrison | 29081 | 2128 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-08-23 04:20:56 | Harrison, Missouri, US | |
2404742 | 2404742 | 2022-08-21 | US | Missouri | Harrison | 29081 | 2128 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-08-22 04:20:38 | Harrison, Missouri, US | |
2402644 | 2402644 | 2022-08-21 | China | Tianjin | 2128 | 3 | 0 | 39.3054 | 117.323 | 2022-08-22 04:20:38 | Tianjin, China | |||
3799820 | 3799820 | 2022-08-20 | US | Missouri | Harrison | 29081 | 2128 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-08-21 04:20:44 | Harrison, Missouri, US | |
2365406 | 2365406 | 2022-08-19 | US | Missouri | Harrison | 29081 | 2128 | 35 | 0 | 40.35570088 | -93.99222144 | 2022-08-20 04:21:01 | Harrison, Missouri, US | |
2890787 | 2890787 | 2022-08-12 | US | North Dakota | Benson | 38005 | 2128 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-08-13 04:20:52 | Benson, North Dakota, US | |
1087223 | 1087223 | 2022-08-09 | US | Indiana | Union | 18161 | 2128 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-08-10 04:20:57 | Union, Indiana, US | |
1086740 | 1086740 | 2022-08-09 | US | Colorado | Yuma | 8125 | 2128 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-10 04:20:57 | Yuma, Colorado, US | |
3544638 | 3544638 | 2022-08-08 | US | Indiana | Union | 18161 | 2128 | 22 | 0 | 39.62550777 | -84.92497066 | 2022-08-09 04:20:34 | Union, Indiana, US | |
960099 | 960099 | 2022-07-19 | US | Iowa | Howard | 19089 | 2128 | 36 | 0 | 43.35671042 | -92.31702714 | 2022-07-20 04:20:59 | Howard, Iowa, US | |
959252 | 959252 | 2022-07-19 | US | Alabama | Choctaw | 1023 | 2128 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-07-20 04:20:59 | Choctaw, Alabama, US | |
3211486 | 3211486 | 2022-07-18 | US | Iowa | Howard | 19089 | 2128 | 36 | 0 | 43.35671042 | -92.31702714 | 2022-07-19 04:20:58 | Howard, Iowa, US | |
3210639 | 3210639 | 2022-07-18 | US | Alabama | Choctaw | 1023 | 2128 | 37 | 0 | 32.02227341 | -88.2656443 | 2022-07-19 04:20:58 | Choctaw, Alabama, US | |
3406661 | 3406661 | 2022-07-17 | US | Iowa | Howard | 19089 | 2128 | 36 | 0 | 43.35671042 | -92.31702714 | 2022-07-18 04:20:59 | Howard, Iowa, US | |
2152861 | 2152861 | 2022-07-16 | US | Iowa | Howard | 19089 | 2128 | 36 | 0 | 43.35671042 | -92.31702714 | 2022-07-17 04:21:15 | Howard, Iowa, US | |
2420094 | 2420094 | 2022-07-15 | US | Iowa | Howard | 19089 | 2128 | 36 | 0 | 43.35671042 | -92.31702714 | 2022-07-16 04:21:05 | Howard, Iowa, US | |
3430169 | 3430169 | 2022-07-14 | US | Iowa | Howard | 19089 | 2128 | 36 | 0 | 43.35671042 | -92.31702714 | 2022-07-15 04:20:53 | Howard, Iowa, US | |
3110689 | 3110689 | 2022-07-13 | US | Iowa | Howard | 19089 | 2128 | 36 | 0 | 43.35671042 | -92.31702714 | 2022-07-14 04:20:57 | Howard, Iowa, US | |
2792543 | 2792543 | 2022-07-10 | US | West Virginia | Pocahontas | 54075 | 2128 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-07-11 04:20:46 | Pocahontas, West Virginia, US | |
2791242 | 2791242 | 2022-07-10 | US | New Mexico | Quay | 35037 | 2128 | 58 | 0 | 35.10403332 | -103.5481727 | 2022-07-11 04:20:46 | Quay, New Mexico, US | |
145496 | 145496 | 2022-07-09 | US | West Virginia | Pocahontas | 54075 | 2128 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-07-10 04:20:54 | Pocahontas, West Virginia, US | |
144195 | 144195 | 2022-07-09 | US | New Mexico | Quay | 35037 | 2128 | 58 | 0 | 35.10403332 | -103.5481727 | 2022-07-10 04:20:54 | Quay, New Mexico, US | |
1420596 | 1420596 | 2022-07-08 | US | West Virginia | Pocahontas | 54075 | 2128 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-07-09 04:20:59 | Pocahontas, West Virginia, US | |
1419295 | 1419295 | 2022-07-08 | US | New Mexico | Quay | 35037 | 2128 | 58 | 0 | 35.10403332 | -103.5481727 | 2022-07-09 04:20:59 | Quay, New Mexico, US | |
2744521 | 2744521 | 2022-07-07 | US | West Virginia | Pocahontas | 54075 | 2128 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-07-08 04:20:56 | Pocahontas, West Virginia, US | |
3943284 | 3943284 | 2022-06-30 | US | Texas | Somervell | 48425 | 2128 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-07-01 04:21:10 | Somervell, Texas, US | |
2493242 | 2493242 | 2022-06-29 | US | Texas | Somervell | 48425 | 2128 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-06-30 04:21:01 | Somervell, Texas, US | |
3891101 | 3891101 | 2022-06-06 | US | West Virginia | Gilmer | 54021 | 2128 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-06-07 04:21:08 | Gilmer, West Virginia, US | |
3896488 | 3896488 | 2022-05-19 | US | Arkansas | Searcy | 5129 | 2128 | 48 | 0 | 35.9109364 | -92.69936482 | 2022-05-20 04:20:57 | Searcy, Arkansas, US | |
1186486 | 1186486 | 2022-05-18 | US | Minnesota | Marshall | 27089 | 2128 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-05-19 04:20:54 | Marshall, Minnesota, US | |
2083773 | 2083773 | 2022-05-15 | China | Yunnan | 2128 | 2 | 0 | 24.974 | 101.487 | 2022-05-16 04:20:47 | Yunnan, China | |||
2534657 | 2534657 | 2022-05-12 | US | Kansas | Anderson | 20003 | 2128 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-13 04:20:51 | Anderson, Kansas, US | |
3446103 | 3446103 | 2022-05-11 | US | Kansas | Anderson | 20003 | 2128 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-12 04:20:54 | Anderson, Kansas, US | |
3536720 | 3536720 | 2022-05-10 | US | Kansas | Anderson | 20003 | 2128 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-11 04:20:48 | Anderson, Kansas, US | |
223255 | 223255 | 2022-05-09 | US | Kansas | Anderson | 20003 | 2128 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-10 04:20:50 | Anderson, Kansas, US | |
2332640 | 2332640 | 2022-05-08 | US | Kansas | Anderson | 20003 | 2128 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-09 04:20:54 | Anderson, Kansas, US | |
361602 | 361602 | 2022-05-07 | US | Kansas | Anderson | 20003 | 2128 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-08 04:20:49 | Anderson, Kansas, US | |
1398953 | 1398953 | 2022-05-06 | US | Kansas | Anderson | 20003 | 2128 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-07 04:21:09 | Anderson, Kansas, US | |
1950662 | 1950662 | 2022-04-12 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-13 04:21:03 | Pershing, Nevada, US | |
3208415 | 3208415 | 2022-04-11 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-12 04:20:49 | Pershing, Nevada, US | |
1578301 | 1578301 | 2022-04-10 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-11 04:21:02 | Pershing, Nevada, US | |
1654543 | 1654543 | 2022-04-09 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-10 04:20:52 | Pershing, Nevada, US | |
2117865 | 2117865 | 2022-04-08 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-09 04:20:42 | Pershing, Nevada, US | |
3322389 | 3322389 | 2022-04-07 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-08 04:20:48 | Pershing, Nevada, US | |
2802925 | 2802925 | 2022-04-06 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-07 04:20:53 | Pershing, Nevada, US | |
3869694 | 3869694 | 2022-04-05 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-06 04:20:49 | Pershing, Nevada, US | |
2751036 | 2751036 | 2022-04-04 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-05 04:20:48 | Pershing, Nevada, US | |
3732382 | 3732382 | 2022-04-03 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-04 04:20:51 | Pershing, Nevada, US | |
502409 | 502409 | 2022-04-02 | US | Puerto Rico | Florida | 72054 | 2128 | 0 | 0 | 18.373715 | -66.560488 | 2022-04-03 04:20:48 | Florida, Puerto Rico, US | |
501817 | 501817 | 2022-04-02 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-03 04:20:48 | Pershing, Nevada, US | |
3352802 | 3352802 | 2022-04-01 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-02 04:20:47 | Pershing, Nevada, US | |
3350926 | 3350926 | 2022-04-01 | Samoa | 2128 | 1 | 0 | -13.759 | -172.1046 | 2022-04-02 04:20:47 | Samoa | ||||
1542107 | 1542107 | 2022-03-31 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-04-01 04:20:28 | Pershing, Nevada, US | |
2480120 | 2480120 | 2022-03-30 | US | Nevada | Pershing | 32027 | 2128 | 29 | 0 | 40.44003782 | -118.40056409999998 | 2022-03-31 04:20:56 | Pershing, Nevada, US | |
159997 | 159997 | 2022-03-29 | US | Montana | Beaverhead | 30001 | 2128 | 29 | 0 | 45.13434354 | -112.89846940000001 | 2022-03-30 04:20:45 | Beaverhead, Montana, US | |
695262 | 695262 | 2022-03-17 | US | Georgia | Seminole | 13253 | 2128 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-18 04:20:55 | Seminole, Georgia, US | |
2320205 | 2320205 | 2022-03-16 | US | Georgia | Seminole | 13253 | 2128 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-17 04:20:56 | Seminole, Georgia, US | |
262405 | 262405 | 2022-03-15 | US | Georgia | Seminole | 13253 | 2128 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-16 04:20:50 | Seminole, Georgia, US | |
2264764 | 2264764 | 2022-03-14 | US | Georgia | Seminole | 13253 | 2128 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-15 04:20:47 | Seminole, Georgia, US | |
2263684 | 2263684 | 2022-03-14 | China | Heilongjiang | 2128 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-03-15 04:20:47 | Heilongjiang, China | |||
3628830 | 3628830 | 2022-03-13 | US | Georgia | Seminole | 13253 | 2128 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-14 04:20:46 | Seminole, Georgia, US | |
951738 | 951738 | 2022-03-12 | US | Georgia | Seminole | 13253 | 2128 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-13 04:20:49 | Seminole, Georgia, US | |
357199 | 357199 | 2022-03-11 | US | Georgia | Seminole | 13253 | 2128 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-12 04:20:50 | Seminole, Georgia, US | |
1868545 | 1868545 | 2022-03-10 | US | Texas | Dallam | 48111 | 2128 | 40 | 0 | 36.27787176 | -102.60207249999999 | 2022-03-11 04:20:50 | Dallam, Texas, US | |
1866351 | 1866351 | 2022-03-10 | US | Georgia | Seminole | 13253 | 2128 | 28 | 0 | 30.93464824 | -84.86823924 | 2022-03-11 04:20:50 | Seminole, Georgia, US | |
1647745 | 1647745 | 2022-03-03 | US | Virginia | Northampton | 51131 | 2128 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-04 04:21:09 | Northampton, Virginia, US | |
1646448 | 1646448 | 2022-03-03 | US | Nebraska | Holt | 31089 | 2128 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-03-04 04:21:09 | Holt, Nebraska, US | |
2528748 | 2528748 | 2022-03-02 | US | Virginia | Northampton | 51131 | 2128 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-03 04:21:01 | Northampton, Virginia, US | |
2527451 | 2527451 | 2022-03-02 | US | Nebraska | Holt | 31089 | 2128 | 16 | 0 | 42.45522056 | -98.78402558 | 2022-03-03 04:21:01 | Holt, Nebraska, US | |
2527394 | 2527394 | 2022-03-02 | US | Montana | Sanders | 30089 | 2128 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-03-03 04:21:01 | Sanders, Montana, US | |
2527093 | 2527093 | 2022-03-02 | US | Minnesota | Jackson | 27063 | 2128 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-03-03 04:21:01 | Jackson, Minnesota, US | |
1996042 | 1996042 | 2022-03-01 | US | Virginia | Northampton | 51131 | 2128 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-02 04:21:07 | Northampton, Virginia, US | |
1994387 | 1994387 | 2022-03-01 | US | Minnesota | Jackson | 27063 | 2128 | 17 | 0 | 43.67423373 | -95.15398258 | 2022-03-02 04:21:07 | Jackson, Minnesota, US | |
946216 | 946216 | 2022-02-28 | US | Virginia | Northampton | 51131 | 2128 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-01 04:21:09 | Northampton, Virginia, US | |
2734501 | 2734501 | 2022-02-27 | US | Kentucky | Trimble | 21223 | 2128 | 35 | 0 | 38.61056487 | -85.33775972 | 2022-02-28 04:21:05 | Trimble, Kentucky, US | |
3047654 | 3047654 | 2022-02-26 | US | Kentucky | Trimble | 21223 | 2128 | 35 | 0 | 38.61056487 | -85.33775972 | 2022-02-27 04:21:04 | Trimble, Kentucky, US | |
576309 | 576309 | 2022-02-25 | US | Kentucky | Trimble | 21223 | 2128 | 35 | 0 | 38.61056487 | -85.33775972 | 2022-02-26 04:21:12 | Trimble, Kentucky, 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]);