johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
761 rows where confirmed = 599 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
713603 | 713603 | 2022-11-01 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-11-02 04:22:09 | Knox, Texas, US | |
3288052 | 3288052 | 2022-10-31 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-11-01 04:22:36 | Knox, Texas, US | |
323085 | 323085 | 2022-10-30 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-31 04:21:36 | Knox, Texas, US | |
915361 | 915361 | 2022-10-29 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-30 04:22:14 | Knox, Texas, US | |
1369630 | 1369630 | 2022-10-28 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-29 04:21:13 | Knox, Texas, US | |
3041485 | 3041485 | 2022-10-27 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-28 04:22:31 | Knox, Texas, US | |
541905 | 541905 | 2022-10-26 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-27 04:22:01 | Knox, Texas, US | |
1833306 | 1833306 | 2022-10-25 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-26 04:22:19 | Knox, Texas, US | |
797567 | 797567 | 2022-10-24 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-25 04:21:53 | Knox, Texas, US | |
3280022 | 3280022 | 2022-10-23 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-24 04:22:29 | Knox, Texas, US | |
2271060 | 2271060 | 2022-10-22 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-23 04:22:46 | Knox, Texas, US | |
1595360 | 1595360 | 2022-10-21 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-22 04:22:53 | Knox, Texas, US | |
2275076 | 2275076 | 2022-10-20 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-21 04:22:23 | Knox, Texas, US | |
201411 | 201411 | 2022-10-19 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-20 04:22:59 | Knox, Texas, US | |
2760072 | 2760072 | 2022-10-18 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-19 04:22:26 | Knox, Texas, US | |
2027906 | 2027906 | 2022-10-17 | US | Texas | Knox | 48275 | 599 | 25 | 0 | 33.60519951 | -99.7422906 | 2022-10-18 04:22:42 | Knox, Texas, US | |
2635781 | 2635781 | 2022-09-05 | US | Nebraska | Cherry | 31031 | 599 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-09-06 04:21:02 | Cherry, Nebraska, US | |
2989345 | 2989345 | 2022-09-04 | US | Nebraska | Cherry | 31031 | 599 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-09-05 04:21:01 | Cherry, Nebraska, US | |
2715030 | 2715030 | 2022-09-03 | US | Nebraska | Cherry | 31031 | 599 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-09-04 04:21:22 | Cherry, Nebraska, US | |
1395735 | 1395735 | 2022-09-02 | US | Nebraska | Cherry | 31031 | 599 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-09-03 04:21:04 | Cherry, Nebraska, US | |
3550973 | 3550973 | 2022-09-01 | US | Washington | Wahkiakum | 53069 | 599 | 9 | 0 | 46.2918004 | -123.4250831 | 2022-09-02 04:21:07 | Wahkiakum, Washington, US | |
3549564 | 3549564 | 2022-09-01 | US | Nebraska | Cherry | 31031 | 599 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-09-02 04:21:07 | Cherry, Nebraska, US | |
2346893 | 2346893 | 2022-08-31 | US | Washington | Wahkiakum | 53069 | 599 | 9 | 0 | 46.2918004 | -123.4250831 | 2022-09-01 04:21:03 | Wahkiakum, Washington, US | |
2345484 | 2345484 | 2022-08-31 | US | Nebraska | Cherry | 31031 | 599 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-09-01 04:21:03 | Cherry, Nebraska, US | |
3777373 | 3777373 | 2022-08-30 | US | Washington | Wahkiakum | 53069 | 599 | 9 | 0 | 46.2918004 | -123.4250831 | 2022-08-31 04:20:57 | Wahkiakum, Washington, US | |
3775964 | 3775964 | 2022-08-30 | US | Nebraska | Cherry | 31031 | 599 | 12 | 0 | 42.54502621 | -101.1244332 | 2022-08-31 04:20:57 | Cherry, Nebraska, US | |
1683969 | 1683969 | 2022-08-29 | US | Washington | Wahkiakum | 53069 | 599 | 9 | 0 | 46.2918004 | -123.4250831 | 2022-08-30 04:21:03 | Wahkiakum, Washington, US | |
1880453 | 1880453 | 2022-08-28 | US | Washington | Wahkiakum | 53069 | 599 | 9 | 0 | 46.2918004 | -123.4250831 | 2022-08-29 04:21:06 | Wahkiakum, Washington, US | |
2099580 | 2099580 | 2022-08-27 | US | Washington | Wahkiakum | 53069 | 599 | 9 | 0 | 46.2918004 | -123.4250831 | 2022-08-28 04:21:02 | Wahkiakum, Washington, US | |
1535395 | 1535395 | 2022-08-26 | US | Washington | Wahkiakum | 53069 | 599 | 9 | 0 | 46.2918004 | -123.4250831 | 2022-08-27 04:20:57 | Wahkiakum, Washington, US | |
1253181 | 1253181 | 2022-08-23 | US | North Dakota | Renville | 38075 | 599 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-08-24 04:20:46 | Renville, North Dakota, US | |
2855285 | 2855285 | 2022-08-22 | US | North Dakota | Renville | 38075 | 599 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-08-23 04:20:56 | Renville, North Dakota, US | |
2405257 | 2405257 | 2022-08-21 | US | North Dakota | Renville | 38075 | 599 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-08-22 04:20:38 | Renville, North Dakota, US | |
3800335 | 3800335 | 2022-08-20 | US | North Dakota | Renville | 38075 | 599 | 15 | 0 | 48.71982533 | -101.6603912 | 2022-08-21 04:20:44 | Renville, North Dakota, US | |
673317 | 673317 | 2022-07-21 | US | Texas | Armstrong | 48011 | 599 | 10 | 0 | 34.96507426 | -101.3574874 | 2022-07-22 04:21:15 | Armstrong, Texas, US | |
961767 | 961767 | 2022-07-19 | US | South Dakota | Faulk | 46049 | 599 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-20 04:20:59 | Faulk, South Dakota, US | |
3213154 | 3213154 | 2022-07-18 | US | South Dakota | Faulk | 46049 | 599 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-19 04:20:58 | Faulk, South Dakota, US | |
3408329 | 3408329 | 2022-07-17 | US | South Dakota | Faulk | 46049 | 599 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-18 04:20:59 | Faulk, South Dakota, US | |
2154529 | 2154529 | 2022-07-16 | US | South Dakota | Faulk | 46049 | 599 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-17 04:21:15 | Faulk, South Dakota, US | |
2421762 | 2421762 | 2022-07-15 | US | South Dakota | Faulk | 46049 | 599 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-16 04:21:05 | Faulk, South Dakota, US | |
3431837 | 3431837 | 2022-07-14 | US | South Dakota | Faulk | 46049 | 599 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-15 04:20:53 | Faulk, South Dakota, US | |
3112357 | 3112357 | 2022-07-13 | US | South Dakota | Faulk | 46049 | 599 | 17 | 0 | 45.07082625 | -99.14535601 | 2022-07-14 04:20:57 | Faulk, South Dakota, US | |
1202213 | 1202213 | 2022-07-06 | US | North Dakota | Griggs | 38039 | 599 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-07-07 04:20:55 | Griggs, North Dakota, US | |
3968956 | 3968956 | 2022-07-05 | US | North Dakota | Griggs | 38039 | 599 | 2 | 0 | 47.45785838 | -98.23850925 | 2022-07-06 04:20:58 | Griggs, North Dakota, US | |
3728604 | 3728604 | 2022-06-07 | US | North Dakota | Adams | 38001 | 599 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-06-08 04:20:55 | Adams, North Dakota, US | |
3890006 | 3890006 | 2022-06-06 | US | North Dakota | Adams | 38001 | 599 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-06-07 04:21:08 | Adams, North Dakota, US | |
3509775 | 3509775 | 2022-06-05 | US | North Dakota | Adams | 38001 | 599 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-06-06 04:20:57 | Adams, North Dakota, US | |
3529852 | 3529852 | 2022-06-04 | US | North Dakota | Adams | 38001 | 599 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-06-05 04:20:55 | Adams, North Dakota, US | |
3135938 | 3135938 | 2022-06-03 | US | North Dakota | Adams | 38001 | 599 | 10 | 0 | 46.09686891 | -102.5285397 | 2022-06-04 04:20:58 | Adams, North Dakota, US | |
3001018 | 3001018 | 2022-05-24 | US | Minnesota | Cook | 27031 | 599 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-25 04:20:56 | Cook, Minnesota, US | |
2999749 | 2999749 | 2022-05-24 | US | Alaska | Yakutat | 2282 | 599 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-05-25 04:20:56 | Yakutat, Alaska, US | |
3594739 | 3594739 | 2022-05-23 | US | Minnesota | Cook | 27031 | 599 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-24 04:20:57 | Cook, Minnesota, US | |
3593470 | 3593470 | 2022-05-23 | US | Alaska | Yakutat | 2282 | 599 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-05-24 04:20:57 | Yakutat, Alaska, US | |
1111287 | 1111287 | 2022-05-21 | US | Minnesota | Cook | 27031 | 599 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-22 04:20:52 | Cook, Minnesota, US | |
1110018 | 1110018 | 2022-05-21 | US | Alaska | Yakutat | 2282 | 599 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-05-22 04:20:52 | Yakutat, Alaska, US | |
1170911 | 1170911 | 2022-05-20 | US | Minnesota | Cook | 27031 | 599 | 4 | 0 | 47.90504893 | -90.52629546 | 2022-05-21 04:20:58 | Cook, Minnesota, US | |
1169642 | 1169642 | 2022-05-20 | US | Alaska | Yakutat | 2282 | 599 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-05-21 04:20:58 | Yakutat, Alaska, US | |
3896405 | 3896405 | 2022-05-19 | US | Alaska | Yakutat | 2282 | 599 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-05-20 04:20:57 | Yakutat, Alaska, US | |
1185189 | 1185189 | 2022-05-18 | US | Alaska | Yakutat | 2282 | 599 | 5 | 0 | 59.8909808 | -140.3601451 | 2022-05-19 04:20:54 | Yakutat, Alaska, US | |
3913485 | 3913485 | 2022-02-20 | US | Kentucky | Robertson | 21201 | 599 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-02-21 04:21:05 | Robertson, Kentucky, US | |
3877043 | 3877043 | 2022-02-19 | US | Kentucky | Robertson | 21201 | 599 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-02-20 04:21:00 | Robertson, Kentucky, US | |
3858920 | 3858920 | 2022-02-18 | US | Texas | Fisher | 48151 | 599 | 22 | 0 | 32.74281316 | -100.40193020000001 | 2022-02-19 04:21:11 | Fisher, Texas, US | |
3857299 | 3857299 | 2022-02-18 | US | Kentucky | Robertson | 21201 | 599 | 21 | 0 | 38.51923469 | -84.05055616 | 2022-02-19 04:21:11 | Robertson, Kentucky, US | |
1301139 | 1301139 | 2022-02-17 | US | Texas | Fisher | 48151 | 599 | 22 | 0 | 32.74281316 | -100.40193020000001 | 2022-02-18 04:21:04 | Fisher, Texas, US | |
2053189 | 2053189 | 2022-01-25 | US | Kansas | Kiowa | 20097 | 599 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-01-26 04:21:07 | Kiowa, Kansas, US | |
1229575 | 1229575 | 2022-01-24 | US | Missouri | Scotland | 29199 | 599 | 17 | 0 | 40.45214695 | -92.14709064 | 2022-01-25 04:21:05 | Scotland, Missouri, US | |
1229546 | 1229546 | 2022-01-24 | US | Missouri | Mercer | 29129 | 599 | 12 | 0 | 40.42212303 | -93.56829590000001 | 2022-01-25 04:21:05 | Mercer, Missouri, US | |
1228920 | 1228920 | 2022-01-24 | US | Kansas | Kiowa | 20097 | 599 | 7 | 0 | 37.55848695 | -99.2856537 | 2022-01-25 04:21:05 | Kiowa, Kansas, US | |
1144132 | 1144132 | 2022-01-23 | US | Texas | Shackelford | 48417 | 599 | 11 | 0 | 32.73587756 | -99.35401337 | 2022-01-24 04:21:12 | Shackelford, Texas, US | |
2836050 | 2836050 | 2022-01-22 | US | Texas | Shackelford | 48417 | 599 | 11 | 0 | 32.73587756 | -99.35401337 | 2022-01-23 04:21:13 | Shackelford, Texas, US | |
3229506 | 3229506 | 2022-01-19 | US | Texas | Collingsworth | 48087 | 599 | 13 | 0 | 34.96489496 | -100.27001109999999 | 2022-01-20 04:21:07 | Collingsworth, Texas, US | |
1695485 | 1695485 | 2022-01-10 | US | Texas | Mason | 48319 | 599 | 9 | 0 | 30.71780434 | -99.22629416 | 2022-01-11 04:22:01 | Mason, Texas, US | |
129900 | 129900 | 2022-01-09 | US | Texas | Mason | 48319 | 599 | 9 | 0 | 30.71780434 | -99.22629416 | 2022-01-10 04:22:07 | Mason, Texas, US | |
2613353 | 2613353 | 2022-01-06 | US | Virginia | Bath | 51017 | 599 | 15 | 0 | 38.05852573 | -79.73912095 | 2022-01-07 04:22:09 | Bath, Virginia, US | |
2612177 | 2612177 | 2022-01-06 | US | Nebraska | Valley | 31175 | 599 | 2 | 0 | 41.56730777 | -98.98197724 | 2022-01-07 04:22:09 | Valley, Nebraska, US | |
1288400 | 1288400 | 2022-01-04 | US | North Dakota | Cavalier | 38019 | 599 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-01-05 04:21:59 | Cavalier, North Dakota, US | |
1703372 | 1703372 | 2022-01-03 | US | Texas | Baylor | 48023 | 599 | 24 | 0 | 33.61640794 | -99.21352901 | 2022-01-04 04:22:17 | Baylor, Texas, US | |
1435336 | 1435336 | 2021-12-28 | US | Puerto Rico | Patillas | 72109 | 599 | 0 | 0 | 18.03174 | -66.012242 | 2021-12-29 03:21:43 | Patillas, Puerto Rico, US | |
733375 | 733375 | 2021-12-27 | US | South Dakota | Aurora | 46003 | 599 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-28 04:21:47 | Aurora, South Dakota, US | |
730316 | 730316 | 2021-12-27 | China | Guangxi | 599 | 2 | 0 | 23.8298 | 108.7881 | 2021-12-28 04:21:47 | Guangxi, China | |||
2114547 | 2114547 | 2021-12-26 | US | South Dakota | Aurora | 46003 | 599 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-27 04:21:58 | Aurora, South Dakota, US | |
2113117 | 2113117 | 2021-12-26 | US | Kentucky | Hickman | 21105 | 599 | 22 | 0 | 36.67948079999999 | -88.97875928 | 2021-12-27 04:21:58 | Hickman, Kentucky, US | |
3607919 | 3607919 | 2021-12-25 | US | South Dakota | Aurora | 46003 | 599 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-26 04:21:50 | Aurora, South Dakota, US | |
3606489 | 3606489 | 2021-12-25 | US | Kentucky | Hickman | 21105 | 599 | 22 | 0 | 36.67948079999999 | -88.97875928 | 2021-12-26 04:21:50 | Hickman, Kentucky, US | |
2966618 | 2966618 | 2021-12-24 | US | Texas | Sutton | 48435 | 599 | 11 | 0 | 30.49856623 | -100.5382014 | 2021-12-25 04:21:37 | Sutton, Texas, US | |
2966237 | 2966237 | 2021-12-24 | US | South Dakota | Aurora | 46003 | 599 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-25 04:21:37 | Aurora, South Dakota, US | |
2964807 | 2964807 | 2021-12-24 | US | Kentucky | Hickman | 21105 | 599 | 22 | 0 | 36.67948079999999 | -88.97875928 | 2021-12-25 04:21:37 | Hickman, Kentucky, US | |
3819650 | 3819650 | 2021-12-23 | US | Texas | Sutton | 48435 | 599 | 11 | 0 | 30.49856623 | -100.5382014 | 2021-12-24 04:21:34 | Sutton, Texas, US | |
3819269 | 3819269 | 2021-12-23 | US | South Dakota | Aurora | 46003 | 599 | 17 | 0 | 43.71757685 | -98.56050467 | 2021-12-24 04:21:34 | Aurora, South Dakota, US | |
3817839 | 3817839 | 2021-12-23 | US | Kentucky | Hickman | 21105 | 599 | 22 | 0 | 36.67948079999999 | -88.97875928 | 2021-12-24 04:21:34 | Hickman, Kentucky, US | |
801658 | 801658 | 2021-12-22 | US | Texas | Sutton | 48435 | 599 | 11 | 0 | 30.49856623 | -100.5382014 | 2021-12-23 04:21:21 | Sutton, Texas, US | |
799847 | 799847 | 2021-12-22 | US | Kentucky | Hickman | 21105 | 599 | 22 | 0 | 36.67948079999999 | -88.97875928 | 2021-12-23 04:21:21 | Hickman, Kentucky, US | |
3830502 | 3830502 | 2021-12-21 | US | Montana | Sweet Grass | 30097 | 599 | 8 | 0 | 45.81367654 | -109.9425686 | 2021-12-22 04:21:54 | Sweet Grass, Montana, US | |
1256805 | 1256805 | 2021-12-20 | US | Montana | Sweet Grass | 30097 | 599 | 8 | 0 | 45.81367654 | -109.9425686 | 2021-12-21 03:21:27 | Sweet Grass, Montana, US | |
1255724 | 1255724 | 2021-12-20 | US | Idaho | Oneida | 16071 | 599 | 10 | 0 | 42.19494279999999 | -112.5407838 | 2021-12-21 03:21:27 | Oneida, Idaho, US | |
1255375 | 1255375 | 2021-12-20 | US | Colorado | Baca | 8009 | 599 | 7 | 0 | 37.31940883 | -102.5603223 | 2021-12-21 03:21:27 | Baca, Colorado, US | |
2905748 | 2905748 | 2021-12-19 | US | Montana | Sweet Grass | 30097 | 599 | 8 | 0 | 45.81367654 | -109.9425686 | 2021-12-20 04:21:43 | Sweet Grass, Montana, US | |
2904667 | 2904667 | 2021-12-19 | US | Idaho | Oneida | 16071 | 599 | 10 | 0 | 42.19494279999999 | -112.5407838 | 2021-12-20 04:21:43 | Oneida, Idaho, US | |
1260821 | 1260821 | 2021-12-18 | US | Montana | Sweet Grass | 30097 | 599 | 8 | 0 | 45.81367654 | -109.9425686 | 2021-12-19 04:21:11 | Sweet Grass, Montana, US | |
1259740 | 1259740 | 2021-12-18 | US | Idaho | Oneida | 16071 | 599 | 10 | 0 | 42.19494279999999 | -112.5407838 | 2021-12-19 04:21:11 | Oneida, Idaho, 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]);