johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
590 rows where confirmed = 586 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756036 | 2756036 | 2022-12-29 | US | Texas | Irion | 48235 | 586 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-30 04:21:04 | Irion, Texas, US | |
1077042 | 1077042 | 2022-12-28 | US | Texas | Irion | 48235 | 586 | 3 | 0 | 31.30375559 | -100.982439 | 2022-12-29 04:21:01 | Irion, Texas, US | |
350707 | 350707 | 2022-12-14 | US | North Dakota | Kidder | 38043 | 586 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-15 04:20:58 | Kidder, North Dakota, US | |
310295 | 310295 | 2022-12-13 | US | North Dakota | Kidder | 38043 | 586 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-14 04:21:04 | Kidder, North Dakota, US | |
1151356 | 1151356 | 2022-12-12 | US | North Dakota | Kidder | 38043 | 586 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-13 04:21:01 | Kidder, North Dakota, US | |
871210 | 871210 | 2022-12-11 | US | North Dakota | Kidder | 38043 | 586 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-12 04:21:01 | Kidder, North Dakota, US | |
259740 | 259740 | 2022-12-10 | US | North Dakota | Kidder | 38043 | 586 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-11 04:20:50 | Kidder, North Dakota, US | |
3938454 | 3938454 | 2022-12-09 | US | North Dakota | Kidder | 38043 | 586 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-10 04:21:02 | Kidder, North Dakota, US | |
3379786 | 3379786 | 2022-12-08 | US | North Dakota | Kidder | 38043 | 586 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-09 04:21:05 | Kidder, North Dakota, US | |
1987057 | 1987057 | 2022-12-07 | US | North Dakota | Kidder | 38043 | 586 | 13 | 0 | 46.97830064 | -99.77507857 | 2022-12-08 04:21:07 | Kidder, North Dakota, US | |
1830934 | 1830934 | 2022-10-25 | US | Georgia | Clay | 13061 | 586 | 7 | 0 | 31.62221166 | -84.97713865 | 2022-10-26 04:22:19 | Clay, Georgia, US | |
795195 | 795195 | 2022-10-24 | US | Georgia | Clay | 13061 | 586 | 7 | 0 | 31.62221166 | -84.97713865 | 2022-10-25 04:21:53 | Clay, Georgia, US | |
3277650 | 3277650 | 2022-10-23 | US | Georgia | Clay | 13061 | 586 | 7 | 0 | 31.62221166 | -84.97713865 | 2022-10-24 04:22:29 | Clay, Georgia, US | |
2268688 | 2268688 | 2022-10-22 | US | Georgia | Clay | 13061 | 586 | 7 | 0 | 31.62221166 | -84.97713865 | 2022-10-23 04:22:46 | Clay, Georgia, US | |
1592988 | 1592988 | 2022-10-21 | US | Georgia | Clay | 13061 | 586 | 7 | 0 | 31.62221166 | -84.97713865 | 2022-10-22 04:22:53 | Clay, Georgia, US | |
2272704 | 2272704 | 2022-10-20 | US | Georgia | Clay | 13061 | 586 | 7 | 0 | 31.62221166 | -84.97713865 | 2022-10-21 04:22:23 | Clay, Georgia, US | |
199039 | 199039 | 2022-10-19 | US | Georgia | Clay | 13061 | 586 | 7 | 0 | 31.62221166 | -84.97713865 | 2022-10-20 04:22:59 | Clay, Georgia, US | |
3748222 | 3748222 | 2022-09-07 | US | Texas | Hardeman | 48197 | 586 | 20 | 0 | 34.28944521 | -99.74632408 | 2022-09-08 04:21:02 | Hardeman, Texas, US | |
117862 | 117862 | 2022-09-06 | US | Texas | Hardeman | 48197 | 586 | 20 | 0 | 34.28944521 | -99.74632408 | 2022-09-07 04:20:59 | Hardeman, Texas, US | |
2326524 | 2326524 | 2022-08-24 | US | Texas | Menard | 48327 | 586 | 12 | 0 | 30.88990665 | -99.8204794 | 2022-08-25 04:21:13 | Menard, Texas, US | |
2011115 | 2011115 | 2022-08-04 | US | North Dakota | Renville | 38075 | 586 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-08-05 04:20:52 | Renville, North Dakota, US | |
1406326 | 1406326 | 2022-08-02 | US | Kansas | Edwards | 20047 | 586 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-08-03 04:20:59 | Edwards, Kansas, US | |
3618364 | 3618364 | 2022-08-01 | US | Kansas | Edwards | 20047 | 586 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-08-02 04:20:53 | Edwards, Kansas, US | |
3872844 | 3872844 | 2022-07-31 | US | Kansas | Edwards | 20047 | 586 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-08-01 04:21:03 | Edwards, Kansas, US | |
675598 | 675598 | 2022-07-30 | US | Kansas | Edwards | 20047 | 586 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-31 04:21:02 | Edwards, Kansas, US | |
1784797 | 1784797 | 2022-07-29 | US | Kansas | Edwards | 20047 | 586 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-30 04:20:42 | Edwards, Kansas, US | |
1067160 | 1067160 | 2022-07-28 | US | Kansas | Edwards | 20047 | 586 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-29 04:20:45 | Edwards, Kansas, US | |
2338588 | 2338588 | 2022-07-27 | US | Texas | Oldham | 48359 | 586 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-07-28 04:20:56 | Oldham, Texas, US | |
2336679 | 2336679 | 2022-07-27 | US | Kansas | Edwards | 20047 | 586 | 13 | 0 | 37.88735543 | -99.31263309 | 2022-07-28 04:20:56 | Edwards, Kansas, US | |
1490778 | 1490778 | 2022-07-26 | US | Texas | Oldham | 48359 | 586 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-07-27 04:21:04 | Oldham, Texas, US | |
3940995 | 3940995 | 2022-06-30 | US | Idaho | Custer | 16037 | 586 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-07-01 04:21:10 | Custer, Idaho, US | |
2490953 | 2490953 | 2022-06-29 | US | Idaho | Custer | 16037 | 586 | 9 | 0 | 44.24186819 | -114.2855494 | 2022-06-30 04:21:01 | Custer, Idaho, US | |
2240691 | 2240691 | 2022-06-28 | US | Kansas | Graham | 20065 | 586 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-06-29 04:20:59 | Graham, Kansas, US | |
2148933 | 2148933 | 2022-06-27 | US | Kansas | Graham | 20065 | 586 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-06-28 04:20:58 | Graham, Kansas, US | |
476734 | 476734 | 2022-06-26 | US | Kansas | Graham | 20065 | 586 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-06-27 04:21:00 | Graham, Kansas, US | |
940109 | 940109 | 2022-06-25 | US | Kansas | Graham | 20065 | 586 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-06-26 04:21:02 | Graham, Kansas, US | |
3347929 | 3347929 | 2022-06-24 | US | Kansas | Graham | 20065 | 586 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-06-25 04:20:57 | Graham, Kansas, US | |
1649670 | 1649670 | 2022-06-23 | US | Kansas | Graham | 20065 | 586 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-06-24 04:20:58 | Graham, Kansas, US | |
2188905 | 2188905 | 2022-06-22 | US | Kansas | Graham | 20065 | 586 | 15 | 0 | 39.34987223 | -99.88332493 | 2022-06-23 04:20:55 | Graham, Kansas, US | |
1423509 | 1423509 | 2022-06-08 | US | North Dakota | Griggs | 38039 | 586 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-06-09 04:20:54 | Griggs, North Dakota, US | |
3509512 | 3509512 | 2022-06-05 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-06-06 04:20:57 | Sherman, Nebraska, US | |
3529589 | 3529589 | 2022-06-04 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-06-05 04:20:55 | Sherman, Nebraska, US | |
3537653 | 3537653 | 2022-05-10 | US | New Mexico | De Baca | 35011 | 586 | 6 | 0 | 34.34274529 | -104.4117842 | 2022-05-11 04:20:48 | De Baca, New Mexico, US | |
3537172 | 3537172 | 2022-05-10 | US | Minnesota | Cook | 27031 | 586 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-11 04:20:48 | Cook, Minnesota, US | |
3724324 | 3724324 | 2022-04-25 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-26 04:20:51 | Sherman, Nebraska, US | |
2030892 | 2030892 | 2022-04-24 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-25 04:20:56 | Sherman, Nebraska, US | |
748467 | 748467 | 2022-04-23 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-24 04:20:56 | Sherman, Nebraska, US | |
3438952 | 3438952 | 2022-04-22 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-23 04:20:50 | Sherman, Nebraska, US | |
2894537 | 2894537 | 2022-04-21 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-22 04:20:45 | Sherman, Nebraska, US | |
2309409 | 2309409 | 2022-04-20 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-21 04:20:46 | Sherman, Nebraska, US | |
2253548 | 2253548 | 2022-04-19 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-20 04:20:45 | Sherman, Nebraska, US | |
1848098 | 1848098 | 2022-04-18 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-19 04:21:00 | Sherman, Nebraska, US | |
3322363 | 3322363 | 2022-04-07 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-08 04:20:48 | Sherman, Nebraska, US | |
2802899 | 2802899 | 2022-04-06 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-07 04:20:53 | Sherman, Nebraska, US | |
3869668 | 3869668 | 2022-04-05 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-06 04:20:49 | Sherman, Nebraska, US | |
1542081 | 1542081 | 2022-03-31 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-04-01 04:20:28 | Sherman, Nebraska, US | |
2480094 | 2480094 | 2022-03-30 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-03-31 04:20:56 | Sherman, Nebraska, US | |
160135 | 160135 | 2022-03-29 | US | Nebraska | Sherman | 31163 | 586 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-03-30 04:20:45 | Sherman, Nebraska, US | |
3064431 | 3064431 | 2022-01-29 | US | North Dakota | Towner | 38095 | 586 | 11 | 0 | 48.68565745 | -99.24564265 | 2022-01-30 04:21:26 | Towner, North Dakota, US | |
1782268 | 1782268 | 2022-01-27 | US | South Dakota | Jackson | 46071 | 586 | 20 | 0 | 43.69318385 | -101.6255063 | 2022-01-28 04:21:09 | Jackson, South Dakota, US | |
1230468 | 1230468 | 2022-01-24 | US | South Dakota | Buffalo | 46017 | 586 | 17 | 0 | 44.07657829 | -99.20814467 | 2022-01-25 04:21:05 | Buffalo, South Dakota, US | |
3615025 | 3615025 | 2022-01-12 | US | Missouri | Schuyler | 29197 | 586 | 23 | 0 | 40.46921489 | -92.52311943 | 2022-01-13 08:00:09 | Schuyler, Missouri, US | |
127151 | 127151 | 2022-01-09 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 586 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-01-10 04:22:07 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1215986 | 1215986 | 2022-01-08 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 586 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-01-09 04:21:46 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1390079 | 1390079 | 2022-01-07 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 586 | 1 | 0 | 58.62403337 | -156.21405890000003 | 2022-01-08 04:21:53 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1284122 | 1284122 | 2022-01-05 | US | Nebraska | Webster | 31181 | 586 | 7 | 0 | 40.17642643 | -98.50019851 | 2022-01-06 04:22:09 | Webster, Nebraska, US | |
1671480 | 1671480 | 2021-12-29 | US | Texas | Baylor | 48023 | 586 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-30 04:21:25 | Baylor, Texas, US | |
1669998 | 1669998 | 2021-12-29 | US | Louisiana | Tensas | 22107 | 586 | 10 | 0 | 32.00760749 | -91.32915234 | 2021-12-30 04:21:25 | Tensas, Louisiana, US | |
1435589 | 1435589 | 2021-12-28 | US | Texas | Baylor | 48023 | 586 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-29 03:21:43 | Baylor, Texas, US | |
1435434 | 1435434 | 2021-12-28 | US | South Dakota | Douglas | 46043 | 586 | 14 | 0 | 43.38520741 | -98.36978007 | 2021-12-29 03:21:43 | Douglas, South Dakota, US | |
733550 | 733550 | 2021-12-27 | US | Texas | Baylor | 48023 | 586 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-28 04:21:47 | Baylor, Texas, US | |
2114722 | 2114722 | 2021-12-26 | US | Texas | Baylor | 48023 | 586 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-27 04:21:58 | Baylor, Texas, US | |
3608094 | 3608094 | 2021-12-25 | US | Texas | Baylor | 48023 | 586 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-26 04:21:50 | Baylor, Texas, US | |
2966412 | 2966412 | 2021-12-24 | US | Texas | Baylor | 48023 | 586 | 24 | 0 | 33.61640794 | -99.21352901 | 2021-12-25 04:21:37 | Baylor, Texas, US | |
801288 | 801288 | 2021-12-22 | US | South Dakota | Clark | 46025 | 586 | 6 | 0 | 44.85834507 | -97.72925109 | 2021-12-23 04:21:21 | Clark, South Dakota, US | |
2905057 | 2905057 | 2021-12-19 | US | Kansas | Rush | 20165 | 586 | 16 | 0 | 38.52275276 | -99.30863983 | 2021-12-20 04:21:43 | Rush, Kansas, US | |
1260130 | 1260130 | 2021-12-18 | US | Kansas | Rush | 20165 | 586 | 16 | 0 | 38.52275276 | -99.30863983 | 2021-12-19 04:21:11 | Rush, Kansas, US | |
2400158 | 2400158 | 2021-12-17 | US | Kansas | Rush | 20165 | 586 | 16 | 0 | 38.52275276 | -99.30863983 | 2021-12-18 02:22:20 | Rush, Kansas, US | |
782191 | 782191 | 2021-12-13 | China | Jilin | 586 | 3 | 0 | 43.6661 | 126.1923 | 2021-12-14 04:22:38 | Jilin, China | |||
1660226 | 1660226 | 2021-12-12 | China | Jilin | 586 | 3 | 0 | 43.6661 | 126.1923 | 2021-12-13 04:22:02 | Jilin, China | |||
553824 | 553824 | 2021-12-08 | US | Texas | Cochran | 48079 | 586 | 19 | 0 | 33.60425307 | -102.82844990000001 | 2021-12-09 04:22:49 | Cochran, Texas, US | |
405453 | 405453 | 2021-12-07 | US | Iowa | Adams | 19003 | 586 | 9 | 0 | 41.02903567 | -94.69932645 | 2021-12-08 04:22:46 | Adams, Iowa, US | |
1033604 | 1033604 | 2021-12-06 | US | Texas | Sutton | 48435 | 586 | 11 | 0 | 30.49856623 | -100.5382014 | 2021-12-07 04:22:34 | Sutton, Texas, US | |
1031535 | 1031535 | 2021-12-06 | US | Iowa | Adams | 19003 | 586 | 9 | 0 | 41.02903567 | -94.69932645 | 2021-12-07 04:22:34 | Adams, Iowa, US | |
1741698 | 1741698 | 2021-12-05 | US | Iowa | Adams | 19003 | 586 | 9 | 0 | 41.02903567 | -94.69932645 | 2021-12-06 04:22:34 | Adams, Iowa, US | |
139130 | 139130 | 2021-12-04 | US | Iowa | Adams | 19003 | 586 | 9 | 0 | 41.02903567 | -94.69932645 | 2021-12-05 04:22:25 | Adams, Iowa, US | |
138573 | 138573 | 2021-12-04 | US | Colorado | Baca | 8009 | 586 | 7 | 0 | 37.31940883 | -102.5603223 | 2021-12-05 04:22:25 | Baca, Colorado, US | |
2196783 | 2196783 | 2021-12-03 | US | Iowa | Adams | 19003 | 586 | 9 | 0 | 41.02903567 | -94.69932645 | 2021-12-04 04:22:18 | Adams, Iowa, US | |
2196226 | 2196226 | 2021-12-03 | US | Colorado | Baca | 8009 | 586 | 7 | 0 | 37.31940883 | -102.5603223 | 2021-12-04 04:22:18 | Baca, Colorado, US | |
1489 | 1489 | 2021-12-02 | US | Iowa | Adams | 19003 | 586 | 9 | 0 | 41.02903567 | -94.69932645 | 2021-12-03 04:23:05 | Adams, Iowa, US | |
1147032 | 1147032 | 2021-12-01 | US | Nebraska | Nance | 31125 | 586 | 10 | 0 | 41.39750195 | -97.99327291 | 2021-12-02 04:22:37 | Nance, Nebraska, US | |
1146471 | 1146471 | 2021-12-01 | US | Louisiana | Unassigned | 90022 | 586 | 0 | 0 | 32.83121059 | 0.0 | 2021-12-02 04:22:37 | Unassigned, Louisiana, US | |
1146088 | 1146088 | 2021-12-01 | US | Iowa | Adams | 19003 | 586 | 9 | 0 | 41.02903567 | -94.69932645 | 2021-12-02 04:22:37 | Adams, Iowa, US | |
3402858 | 3402858 | 2021-11-30 | US | Kentucky | Hickman | 21105 | 586 | 21 | 0 | 36.67948079999999 | -88.97875928 | 2021-12-01 04:22:29 | Hickman, Kentucky, US | |
152383 | 152383 | 2021-11-29 | US | North Dakota | Emmons | 38029 | 586 | 16 | 0 | 46.28398398 | -100.2389766 | 2021-11-30 04:22:53 | Emmons, North Dakota, US | |
29455 | 29455 | 2021-11-11 | US | Illinois | Putnam | 17155 | 586 | 4 | 0 | 41.2013541 | -89.2869272 | 2021-11-12 04:22:01 | Putnam, Illinois, US | |
2845894 | 2845894 | 2021-11-10 | US | Illinois | Putnam | 17155 | 586 | 4 | 0 | 41.2013541 | -89.2869272 | 2021-11-11 04:21:45 | Putnam, Illinois, US | |
2001959 | 2001959 | 2021-11-07 | US | Kansas | Haskell | 20081 | 586 | 9 | 0 | 37.562039399999996 | -100.8710738 | 2021-11-08 04:21:43 | Haskell, Kansas, US | |
496950 | 496950 | 2021-11-06 | US | Kansas | Haskell | 20081 | 586 | 9 | 0 | 37.562039399999996 | -100.8710738 | 2021-11-07 04:21:53 | Haskell, Kansas, US | |
3122805 | 3122805 | 2021-11-05 | US | Kansas | Haskell | 20081 | 586 | 9 | 0 | 37.562039399999996 | -100.8710738 | 2021-11-06 04:21:51 | Haskell, Kansas, 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]);