johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,321 rows where confirmed = 75 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308941 | 308941 | 2022-12-13 | US | Illinois | Unassigned | 90017 | 75 | 4857 | 0 | 42.36542373 | 0.0 | 2022-12-14 04:21:04 | Unassigned, Illinois, US | |
3715226 | 3715226 | 2022-12-06 | US | Illinois | Unassigned | 90017 | 75 | 4848 | 0 | 42.36542373 | 0.0 | 2022-12-07 04:20:58 | Unassigned, Illinois, US | |
2757976 | 2757976 | 2022-10-18 | US | Illinois | Unassigned | 90017 | 75 | 4724 | 0 | 42.36542373 | 0.0 | 2022-10-19 04:22:26 | Unassigned, Illinois, US | |
1314332 | 1314332 | 2022-05-27 | Netherlands | Unknown | 75 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
1504653 | 1504653 | 2022-05-16 | US | Illinois | Unassigned | 90017 | 75 | 4295 | 0 | 42.36542373 | 0.0 | 2022-05-17 04:20:59 | Unassigned, Illinois, US | |
2892219 | 2892219 | 2022-04-21 | China | Qinghai | 75 | 0 | 0 | 35.7452 | 95.9956 | 2022-04-22 04:20:45 | Qinghai, China | |||
2307091 | 2307091 | 2022-04-20 | China | Qinghai | 75 | 0 | 0 | 35.7452 | 95.9956 | 2022-04-21 04:20:46 | Qinghai, China | |||
945031 | 945031 | 2022-02-28 | US | New Mexico | Harding | 35021 | 75 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2022-03-01 04:21:09 | Harding, New Mexico, US | |
2735222 | 2735222 | 2022-02-27 | US | New Mexico | Harding | 35021 | 75 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2022-02-28 04:21:05 | Harding, New Mexico, US | |
3048375 | 3048375 | 2022-02-26 | US | New Mexico | Harding | 35021 | 75 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2022-02-27 04:21:04 | Harding, New Mexico, US | |
577030 | 577030 | 2022-02-25 | US | New Mexico | Harding | 35021 | 75 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2022-02-26 04:21:12 | Harding, New Mexico, US | |
1513606 | 1513606 | 2022-02-24 | US | New Mexico | Harding | 35021 | 75 | 4 | 0 | 35.85751555 | -103.82209379999999 | 2022-02-25 04:21:11 | Harding, New Mexico, US | |
319058 | 319058 | 2022-02-12 | US | Texas | Kenedy | 48261 | 75 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-02-13 04:21:00 | Kenedy, Texas, US | |
236384 | 236384 | 2022-02-11 | US | Texas | Kenedy | 48261 | 75 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-02-12 04:21:06 | Kenedy, Texas, US | |
1467226 | 1467226 | 2022-02-10 | US | Texas | Kenedy | 48261 | 75 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-02-11 04:21:09 | Kenedy, Texas, US | |
3077187 | 3077187 | 2022-02-09 | US | Texas | Kenedy | 48261 | 75 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-02-10 04:21:14 | Kenedy, Texas, US | |
1365494 | 1365494 | 2022-02-08 | US | Texas | Kenedy | 48261 | 75 | 2 | 0 | 26.92601662 | -97.66413984 | 2022-02-09 04:21:04 | Kenedy, Texas, US | |
2014830 | 2014830 | 2022-02-06 | US | Nebraska | Sioux | 31165 | 75 | 0 | 0 | 42.48932059 | -103.7576544 | 2022-02-07 04:21:05 | Sioux, Nebraska, US | |
1296159 | 1296159 | 2022-02-05 | US | Nebraska | Sioux | 31165 | 75 | 0 | 0 | 42.48932059 | -103.7576544 | 2022-02-06 04:21:00 | Sioux, Nebraska, US | |
2329487 | 2329487 | 2022-02-04 | US | Nebraska | Sioux | 31165 | 75 | 0 | 0 | 42.48932059 | -103.7576544 | 2022-02-05 04:21:05 | Sioux, Nebraska, US | |
2476078 | 2476078 | 2022-02-03 | US | Nebraska | Sioux | 31165 | 75 | 0 | 0 | 42.48932059 | -103.7576544 | 2022-02-04 04:21:10 | Sioux, Nebraska, US | |
461503 | 461503 | 2022-02-02 | US | Nebraska | Sioux | 31165 | 75 | 0 | 0 | 42.48932059 | -103.7576544 | 2022-02-03 04:21:21 | Sioux, Nebraska, US | |
981072 | 981072 | 2022-02-01 | US | Nebraska | Sioux | 31165 | 75 | 0 | 0 | 42.48932059 | -103.7576544 | 2022-02-02 04:21:09 | Sioux, Nebraska, US | |
2659914 | 2659914 | 2022-01-31 | US | Nebraska | Sioux | 31165 | 75 | 0 | 0 | 42.48932059 | -103.7576544 | 2022-02-01 04:21:11 | Sioux, Nebraska, US | |
3467338 | 3467338 | 2022-01-18 | US | Texas | Loving | 48301 | 75 | 0 | 0 | 31.84947612 | -103.5818571 | 2022-01-19 04:21:23 | Loving, Texas, US | |
1115634 | 1115634 | 2022-01-11 | US | Nebraska | Banner | 31007 | 75 | 0 | 0 | 41.54634427 | -103.7114332 | 2022-01-12 04:21:44 | Banner, Nebraska, US | |
1695345 | 1695345 | 2022-01-10 | US | Texas | Borden | 48033 | 75 | 2 | 0 | 32.74363984 | -101.43165090000001 | 2022-01-11 04:22:01 | Borden, Texas, US | |
129760 | 129760 | 2022-01-09 | US | Texas | Borden | 48033 | 75 | 2 | 0 | 32.74363984 | -101.43165090000001 | 2022-01-10 04:22:07 | Borden, Texas, US | |
1218595 | 1218595 | 2022-01-08 | US | Texas | Borden | 48033 | 75 | 2 | 0 | 32.74363984 | -101.43165090000001 | 2022-01-09 04:21:46 | Borden, Texas, US | |
1032502 | 1032502 | 2021-12-06 | US | Nebraska | Thomas | 31171 | 75 | 1 | 0 | 41.91358968 | -100.5556632 | 2021-12-07 04:22:34 | Thomas, Nebraska, US | |
1742665 | 1742665 | 2021-12-05 | US | Nebraska | Thomas | 31171 | 75 | 1 | 0 | 41.91358968 | -100.5556632 | 2021-12-06 04:22:34 | Thomas, Nebraska, US | |
140097 | 140097 | 2021-12-04 | US | Nebraska | Thomas | 31171 | 75 | 1 | 0 | 41.91358968 | -100.5556632 | 2021-12-05 04:22:25 | Thomas, Nebraska, US | |
2197750 | 2197750 | 2021-12-03 | US | Nebraska | Thomas | 31171 | 75 | 1 | 0 | 41.91358968 | -100.5556632 | 2021-12-04 04:22:18 | Thomas, Nebraska, US | |
2288509 | 2288509 | 2021-11-15 | US | Illinois | Unassigned | 90017 | 75 | 2909 | 0 | 42.36542373 | 0.0 | 2021-11-16 04:21:10 | Unassigned, Illinois, US | |
689648 | 689648 | 2021-11-13 | US | Vermont | Unassigned | 90050 | 75 | 0 | 0 | 44.85627605 | 0.0 | 2021-11-14 04:21:31 | Unassigned, Vermont, US | |
3641636 | 3641636 | 2021-11-08 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-09 04:21:36 | Hayes, Nebraska, US | |
2002794 | 2002794 | 2021-11-07 | US | Nebraska | Wheeler | 31183 | 75 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-11-08 04:21:43 | Wheeler, Nebraska, US | |
2002744 | 2002744 | 2021-11-07 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-08 04:21:43 | Hayes, Nebraska, US | |
497785 | 497785 | 2021-11-06 | US | Nebraska | Wheeler | 31183 | 75 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-11-07 04:21:53 | Wheeler, Nebraska, US | |
497735 | 497735 | 2021-11-06 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-07 04:21:53 | Hayes, Nebraska, US | |
3123640 | 3123640 | 2021-11-05 | US | Nebraska | Wheeler | 31183 | 75 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-11-06 04:21:51 | Wheeler, Nebraska, US | |
3123590 | 3123590 | 2021-11-05 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-06 04:21:51 | Hayes, Nebraska, US | |
700538 | 700538 | 2021-11-04 | US | Nebraska | Wheeler | 31183 | 75 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-11-05 04:21:54 | Wheeler, Nebraska, US | |
700488 | 700488 | 2021-11-04 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-05 04:21:54 | Hayes, Nebraska, US | |
278316 | 278316 | 2021-11-03 | US | Nebraska | Wheeler | 31183 | 75 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-11-04 04:22:20 | Wheeler, Nebraska, US | |
278266 | 278266 | 2021-11-03 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-04 04:22:20 | Hayes, Nebraska, US | |
45791 | 45791 | 2021-11-02 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-03 06:22:09 | Hayes, Nebraska, US | |
45786 | 45786 | 2021-11-02 | US | Nebraska | Grant | 31075 | 75 | 4 | 0 | 41.91528587 | -101.740701 | 2021-11-03 06:22:09 | Grant, Nebraska, US | |
3513487 | 3513487 | 2021-11-01 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-02 04:22:03 | Hayes, Nebraska, US | |
3513482 | 3513482 | 2021-11-01 | US | Nebraska | Grant | 31075 | 75 | 4 | 0 | 41.91528587 | -101.740701 | 2021-11-02 04:22:03 | Grant, Nebraska, US | |
290078 | 290078 | 2021-10-31 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-11-01 04:22:01 | Hayes, Nebraska, US | |
290073 | 290073 | 2021-10-31 | US | Nebraska | Grant | 31075 | 75 | 4 | 0 | 41.91528587 | -101.740701 | 2021-11-01 04:22:01 | Grant, Nebraska, US | |
2723084 | 2723084 | 2021-10-30 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-10-31 04:22:08 | Hayes, Nebraska, US | |
2723079 | 2723079 | 2021-10-30 | US | Nebraska | Grant | 31075 | 75 | 4 | 0 | 41.91528587 | -101.740701 | 2021-10-31 04:22:08 | Grant, Nebraska, US | |
569186 | 569186 | 2021-10-29 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-10-30 04:22:03 | Hayes, Nebraska, US | |
569181 | 569181 | 2021-10-29 | US | Nebraska | Grant | 31075 | 75 | 4 | 0 | 41.91528587 | -101.740701 | 2021-10-30 04:22:03 | Grant, Nebraska, US | |
6428 | 6428 | 2021-10-28 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-10-29 04:22:03 | Hayes, Nebraska, US | |
6423 | 6423 | 2021-10-28 | US | Nebraska | Grant | 31075 | 75 | 4 | 0 | 41.91528587 | -101.740701 | 2021-10-29 04:22:03 | Grant, Nebraska, US | |
536818 | 536818 | 2021-10-27 | US | Nebraska | Hayes | 31085 | 75 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-10-28 04:22:08 | Hayes, Nebraska, US | |
536813 | 536813 | 2021-10-27 | US | Nebraska | Grant | 31075 | 75 | 4 | 0 | 41.91528587 | -101.740701 | 2021-10-28 04:22:08 | Grant, Nebraska, US | |
469497 | 469497 | 2021-10-07 | US | Nebraska | Hooker | 31091 | 75 | 2 | 0 | 41.91586243 | -101.1354293 | 2021-10-08 04:21:25 | Hooker, Nebraska, US | |
467214 | 467214 | 2021-10-07 | China | Macau | 75 | 0 | 0 | 22.1667 | 113.55 | 2021-10-08 04:21:25 | Macau, China | |||
2460877 | 2460877 | 2021-10-06 | US | Nebraska | Hooker | 31091 | 75 | 2 | 0 | 41.91586243 | -101.1354293 | 2021-10-07 04:21:36 | Hooker, Nebraska, US | |
2458594 | 2458594 | 2021-10-06 | China | Macau | 75 | 0 | 0 | 22.1667 | 113.55 | 2021-10-07 04:21:36 | Macau, China | |||
3834570 | 3834570 | 2021-10-05 | US | Nebraska | Hooker | 31091 | 75 | 2 | 0 | 41.91586243 | -101.1354293 | 2021-10-06 04:21:33 | Hooker, Nebraska, US | |
3832288 | 3832288 | 2021-10-05 | China | Macau | 75 | 0 | 0 | 22.1667 | 113.55 | 2021-10-06 04:21:33 | Macau, China | |||
70289 | 70289 | 2021-09-01 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-09-02 04:21:15 | Terrell, Texas, US | |
67684 | 67684 | 2021-09-01 | US | Colorado | Jackson | 8057 | 75 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-09-02 04:21:15 | Jackson, Colorado, US | |
2071131 | 2071131 | 2021-08-31 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-09-01 04:21:38 | Terrell, Texas, US | |
1778585 | 1778585 | 2021-08-30 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-31 04:21:46 | Terrell, Texas, US | |
3895159 | 3895159 | 2021-08-29 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-30 04:21:23 | Terrell, Texas, US | |
2796262 | 2796262 | 2021-08-28 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-29 04:21:14 | Terrell, Texas, US | |
2926421 | 2926421 | 2021-08-27 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-28 04:21:28 | Terrell, Texas, US | |
35644 | 35644 | 2021-08-25 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-26 04:21:28 | Terrell, Texas, US | |
3108683 | 3108683 | 2021-08-24 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-25 04:21:41 | Terrell, Texas, US | |
3168854 | 3168854 | 2021-08-23 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-24 04:21:19 | Terrell, Texas, US | |
2178781 | 2178781 | 2021-08-22 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-23 04:21:27 | Terrell, Texas, US | |
3558877 | 3558877 | 2021-08-21 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-22 04:21:29 | Terrell, Texas, US | |
1857219 | 1857219 | 2021-08-20 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-21 04:21:38 | Terrell, Texas, US | |
514926 | 514926 | 2021-08-19 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-20 04:21:33 | Terrell, Texas, US | |
2521405 | 2521405 | 2021-08-18 | US | Texas | Terrell | 48443 | 75 | 3 | 0 | 30.22429013 | -102.0766732 | 2021-08-19 04:21:15 | Terrell, Texas, US | |
104374 | 104374 | 2021-08-15 | US | Illinois | Unassigned | 90017 | 75 | 2497 | 0 | 42.36542373 | 0.0 | 2021-08-16 04:21:31 | Unassigned, Illinois, US | |
508732 | 508732 | 2021-08-14 | US | Illinois | Unassigned | 90017 | 75 | 2499 | 0 | 42.36542373 | 0.0 | 2021-08-15 04:21:41 | Unassigned, Illinois, US | |
1484604 | 1484604 | 2021-08-13 | US | Illinois | Unassigned | 90017 | 75 | 2499 | 0 | 42.36542373 | 0.0 | 2021-08-14 04:21:25 | Unassigned, Illinois, US | |
2352088 | 2352088 | 2021-08-10 | US | Colorado | San Juan | 8111 | 75 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-08-11 04:21:58 | San Juan, Colorado, US | |
590067 | 590067 | 2021-08-08 | US | Alaska | Wrangell | 2275 | 75 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-08-09 04:21:24 | Wrangell, Alaska, US | |
2204079 | 2204079 | 2021-08-07 | US | Alaska | Wrangell | 2275 | 75 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-08-08 04:21:33 | Wrangell, Alaska, US | |
1118029 | 1118029 | 2021-08-06 | US | Alaska | Wrangell | 2275 | 75 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-08-07 04:21:30 | Wrangell, Alaska, US | |
1956966 | 1956966 | 2021-08-05 | US | Alaska | Wrangell | 2275 | 75 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-08-06 04:21:18 | Wrangell, Alaska, US | |
332345 | 332345 | 2021-08-04 | US | Alaska | Wrangell | 2275 | 75 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-08-05 04:21:51 | Wrangell, Alaska, US | |
3468616 | 3468616 | 2021-08-03 | US | Alaska | Wrangell | 2275 | 75 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-08-04 04:21:25 | Wrangell, Alaska, US | |
3683890 | 3683890 | 2021-08-02 | US | Alaska | Wrangell | 2275 | 75 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-08-03 04:21:39 | Wrangell, Alaska, US | |
1307203 | 1307203 | 2021-07-27 | US | Illinois | Unassigned | 90017 | 75 | 2471 | 0 | 42.36542373 | 0.0 | 2021-07-28 04:21:39 | Unassigned, Illinois, US | |
486221 | 486221 | 2021-07-19 | US | Oregon | Sherman | 41055 | 75 | 2 | 0 | 45.41501554 | -120.6827834 | 2021-07-20 04:21:48 | Sherman, Oregon, US | |
299215 | 299215 | 2021-07-15 | US | Texas | Roberts | 48393 | 75 | 1 | 0 | 35.83809685 | -100.813175 | 2021-07-16 04:21:22 | Roberts, Texas, US | |
3635160 | 3635160 | 2021-07-14 | US | Texas | Roberts | 48393 | 75 | 1 | 0 | 35.83809685 | -100.813175 | 2021-07-15 04:21:48 | Roberts, Texas, US | |
582035 | 582035 | 2021-07-13 | US | Texas | Roberts | 48393 | 75 | 1 | 0 | 35.83809685 | -100.813175 | 2021-07-14 04:21:35 | Roberts, Texas, US | |
3744284 | 3744284 | 2021-07-12 | US | Texas | Roberts | 48393 | 75 | 1 | 0 | 35.83809685 | -100.813175 | 2021-07-13 04:21:18 | Roberts, Texas, US | |
3662797 | 3662797 | 2021-07-11 | US | Texas | Roberts | 48393 | 75 | 1 | 0 | 35.83809685 | -100.813175 | 2021-07-12 04:21:34 | Roberts, Texas, US | |
629081 | 629081 | 2021-07-10 | US | Texas | Roberts | 48393 | 75 | 1 | 0 | 35.83809685 | -100.813175 | 2021-07-11 04:21:43 | Roberts, Texas, 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]);