johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,184 rows where confirmed = 212 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
542907 | 542907 | 2022-12-15 | New Zealand | Niue | 212 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-16 04:21:01 | Niue, New Zealand | |||
2759801 | 2759801 | 2022-10-18 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-19 04:22:26 | Harding, South Dakota, US | |
2027635 | 2027635 | 2022-10-17 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-18 04:22:42 | Harding, South Dakota, US | |
2162413 | 2162413 | 2022-10-16 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-17 04:20:31 | Harding, South Dakota, US | |
2159335 | 2159335 | 2022-10-16 | China | Ningxia | 212 | 0 | 0 | 37.2692 | 106.1655 | 2022-10-17 04:20:31 | Ningxia, China | |||
518610 | 518610 | 2022-10-15 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-16 04:22:39 | Harding, South Dakota, US | |
515532 | 515532 | 2022-10-15 | China | Ningxia | 212 | 0 | 0 | 37.2692 | 106.1655 | 2022-10-16 04:22:39 | Ningxia, China | |||
2035667 | 2035667 | 2022-10-14 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-15 04:22:00 | Harding, South Dakota, US | |
2032589 | 2032589 | 2022-10-14 | China | Ningxia | 212 | 0 | 0 | 37.2692 | 106.1655 | 2022-10-15 04:22:00 | Ningxia, China | |||
3756355 | 3756355 | 2022-10-13 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-14 04:22:28 | Harding, South Dakota, US | |
3753277 | 3753277 | 2022-10-13 | China | Ningxia | 212 | 0 | 0 | 37.2692 | 106.1655 | 2022-10-14 04:22:28 | Ningxia, China | |||
3217180 | 3217180 | 2022-10-12 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-13 04:22:39 | Harding, South Dakota, US | |
3253029 | 3253029 | 2022-10-11 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-12 04:22:51 | Harding, South Dakota, US | |
2970288 | 2970288 | 2022-10-10 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-11 04:23:05 | Harding, South Dakota, US | |
3100324 | 3100324 | 2022-10-09 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-10 04:22:32 | Harding, South Dakota, US | |
4005549 | 4005549 | 2022-10-08 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-09 04:21:16 | Harding, South Dakota, US | |
399146 | 399146 | 2022-10-07 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-08 04:22:56 | Harding, South Dakota, US | |
2532263 | 2532263 | 2022-10-06 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-07 04:23:08 | Harding, South Dakota, US | |
1813657 | 1813657 | 2022-10-05 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-06 04:21:22 | Harding, South Dakota, US | |
133631 | 133631 | 2022-10-04 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-05 04:23:06 | Harding, South Dakota, US | |
2688578 | 2688578 | 2022-10-03 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-04 04:22:55 | Harding, South Dakota, US | |
2262645 | 2262645 | 2022-10-02 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-03 04:23:11 | Harding, South Dakota, US | |
2998171 | 2998171 | 2022-10-01 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-02 04:21:23 | Harding, South Dakota, US | |
856497 | 856497 | 2022-09-30 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-10-01 04:23:01 | Harding, South Dakota, US | |
2378423 | 2378423 | 2022-09-29 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-30 04:23:09 | Harding, South Dakota, US | |
1562974 | 1562974 | 2022-09-28 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-29 04:22:34 | Harding, South Dakota, US | |
3997517 | 3997517 | 2022-09-27 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-28 04:23:01 | Harding, South Dakota, US | |
2771845 | 2771845 | 2022-09-26 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-27 04:23:01 | Harding, South Dakota, US | |
1979498 | 1979498 | 2022-09-25 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-26 04:20:52 | Harding, South Dakota, US | |
2652665 | 2652665 | 2022-09-24 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-25 04:23:31 | Harding, South Dakota, US | |
387105 | 387105 | 2022-09-23 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-24 04:21:40 | Harding, South Dakota, US | |
1627171 | 1627171 | 2022-09-22 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-23 04:23:13 | Harding, South Dakota, US | |
1373375 | 1373375 | 2022-09-21 | US | South Dakota | Harding | 46063 | 212 | 3 | 0 | 45.58015551 | -103.4958629 | 2022-09-22 04:22:56 | Harding, South Dakota, US | |
2712777 | 2712777 | 2022-09-03 | China | Qinghai | 212 | 0 | 0 | 35.7452 | 95.9956 | 2022-09-04 04:21:22 | Qinghai, China | |||
3408601 | 3408601 | 2022-07-17 | US | Texas | Kent | 48263 | 212 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-18 04:20:59 | Kent, Texas, US | |
2154801 | 2154801 | 2022-07-16 | US | Texas | Kent | 48263 | 212 | 4 | 0 | 33.18104136 | -100.7780939 | 2022-07-17 04:21:15 | Kent, Texas, US | |
633007 | 633007 | 2022-07-12 | US | Texas | Glasscock | 48173 | 212 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-13 04:20:58 | Glasscock, Texas, US | |
1214651 | 1214651 | 2022-07-11 | US | Texas | Glasscock | 48173 | 212 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-12 04:20:51 | Glasscock, Texas, US | |
2792133 | 2792133 | 2022-07-10 | US | Texas | Glasscock | 48173 | 212 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-11 04:20:46 | Glasscock, Texas, US | |
145086 | 145086 | 2022-07-09 | US | Texas | Glasscock | 48173 | 212 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-10 04:20:54 | Glasscock, Texas, US | |
1420186 | 1420186 | 2022-07-08 | US | Texas | Glasscock | 48173 | 212 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-09 04:20:59 | Glasscock, Texas, US | |
2744111 | 2744111 | 2022-07-07 | US | Texas | Glasscock | 48173 | 212 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-08 04:20:56 | Glasscock, Texas, US | |
1202906 | 1202906 | 2022-07-06 | US | Texas | Glasscock | 48173 | 212 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-07 04:20:55 | Glasscock, Texas, US | |
3969649 | 3969649 | 2022-07-05 | US | Texas | Glasscock | 48173 | 212 | 3 | 0 | 31.86942909 | -101.5207776 | 2022-07-06 04:20:58 | Glasscock, Texas, US | |
3530628 | 3530628 | 2022-06-04 | US | Texas | Loving | 48301 | 212 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-05 04:20:55 | Loving, Texas, US | |
3136714 | 3136714 | 2022-06-03 | US | Texas | Loving | 48301 | 212 | 1 | 0 | 31.84947612 | -103.5818571 | 2022-06-04 04:20:58 | Loving, Texas, US | |
3186648 | 3186648 | 2022-05-30 | US | Colorado | San Juan | 8111 | 212 | 0 | 0 | 37.76248981 | -107.6763289 | 2022-05-31 04:20:51 | San Juan, Colorado, US | |
2835963 | 2835963 | 2022-01-22 | US | Texas | Jeff Davis | 48243 | 212 | 8 | 0 | 30.71490589 | -104.1399973 | 2022-01-23 04:21:13 | Jeff Davis, Texas, US | |
3428081 | 3428081 | 2022-01-21 | US | Texas | Jeff Davis | 48243 | 212 | 7 | 0 | 30.71490589 | -104.1399973 | 2022-01-22 04:21:13 | Jeff Davis, Texas, US | |
1963689 | 1963689 | 2022-01-20 | US | Texas | Jeff Davis | 48243 | 212 | 7 | 0 | 30.71490589 | -104.1399973 | 2022-01-21 04:21:09 | Jeff Davis, Texas, US | |
3229584 | 3229584 | 2022-01-19 | US | Texas | Jeff Davis | 48243 | 212 | 7 | 0 | 30.71490589 | -104.1399973 | 2022-01-20 04:21:07 | Jeff Davis, Texas, US | |
3467309 | 3467309 | 2022-01-18 | US | Texas | Jeff Davis | 48243 | 212 | 7 | 0 | 30.71490589 | -104.1399973 | 2022-01-19 04:21:23 | Jeff Davis, Texas, US | |
1475248 | 1475248 | 2022-01-17 | US | Texas | Jeff Davis | 48243 | 212 | 7 | 0 | 30.71490589 | -104.1399973 | 2022-01-18 04:21:04 | Jeff Davis, Texas, US | |
129638 | 129638 | 2022-01-09 | US | South Dakota | Sully | 46119 | 212 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-10 04:22:07 | Sully, South Dakota, US | |
129368 | 129368 | 2022-01-09 | US | Oregon | Sherman | 41055 | 212 | 3 | 0 | 45.41501554 | -120.6827834 | 2022-01-10 04:22:07 | Sherman, Oregon, US | |
1218473 | 1218473 | 2022-01-08 | US | South Dakota | Sully | 46119 | 212 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-09 04:21:46 | Sully, South Dakota, US | |
1218203 | 1218203 | 2022-01-08 | US | Oregon | Sherman | 41055 | 212 | 3 | 0 | 45.41501554 | -120.6827834 | 2022-01-09 04:21:46 | Sherman, Oregon, US | |
1392566 | 1392566 | 2022-01-07 | US | South Dakota | Sully | 46119 | 212 | 3 | 0 | 44.71571812 | -100.1278092 | 2022-01-08 04:21:53 | Sully, South Dakota, US | |
1392296 | 1392296 | 2022-01-07 | US | Oregon | Sherman | 41055 | 212 | 3 | 0 | 45.41501554 | -120.6827834 | 2022-01-08 04:21:53 | Sherman, Oregon, US | |
1703206 | 1703206 | 2022-01-03 | US | South Dakota | Campbell | 46021 | 212 | 6 | 0 | 45.77074915 | -100.0510181 | 2022-01-04 04:22:17 | Campbell, South Dakota, US | |
1434844 | 1434844 | 2021-12-28 | US | New York | Unassigned | 90036 | 212 | 1 | 0 | 44.74530905 | 0.0 | 2021-12-29 03:21:43 | Unassigned, New York, US | |
801613 | 801613 | 2021-12-22 | US | Texas | Motley | 48345 | 212 | 9 | 0 | 34.07408766 | -100.77972199999999 | 2021-12-23 04:21:21 | Motley, Texas, US | |
1261578 | 1261578 | 2021-12-18 | US | Puerto Rico | Vieques | 72147 | 212 | 0 | 0 | 18.123276 | -65.44097099999999 | 2021-12-19 04:21:11 | Vieques, Puerto Rico, US | |
1234056 | 1234056 | 2021-11-28 | US | North Dakota | Sheridan | 38083 | 212 | 4 | 0 | 47.57700669 | -100.3426391 | 2021-11-29 04:22:30 | Sheridan, North Dakota, US | |
723082 | 723082 | 2021-11-20 | US | California | Sierra | 6091 | 212 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-21 04:22:13 | Sierra, California, US | |
162612 | 162612 | 2021-11-19 | US | California | Sierra | 6091 | 212 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-20 04:22:17 | Sierra, California, US | |
3289499 | 3289499 | 2021-11-18 | US | California | Sierra | 6091 | 212 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-11-19 04:21:40 | Sierra, California, US | |
1324380 | 1324380 | 2021-11-14 | US | Nevada | Storey | 32029 | 212 | 5 | 0 | 39.44875482 | -119.5250207 | 2021-11-15 04:21:36 | Storey, Nevada, US | |
688506 | 688506 | 2021-11-13 | US | Nevada | Storey | 32029 | 212 | 5 | 0 | 39.44875482 | -119.5250207 | 2021-11-14 04:21:31 | Storey, Nevada, US | |
716615 | 716615 | 2021-11-12 | US | Nevada | Storey | 32029 | 212 | 5 | 0 | 39.44875482 | -119.5250207 | 2021-11-13 04:21:38 | Storey, Nevada, US | |
3641970 | 3641970 | 2021-11-08 | US | North Dakota | Oliver | 38065 | 212 | 3 | 0 | 47.11530482 | -101.3406158 | 2021-11-09 04:21:36 | Oliver, North Dakota, US | |
598267 | 598267 | 2021-10-19 | US | California | Unassigned | 90006 | 212 | 0 | 0 | 41.74228275 | 0.0 | 2021-10-20 04:21:00 | Unassigned, California, US | |
1494828 | 1494828 | 2021-10-12 | US | Texas | Stonewall | 48433 | 212 | 6 | 0 | 33.17906744 | -100.25384009999999 | 2021-10-13 04:20:51 | Stonewall, Texas, US | |
2458473 | 2458473 | 2021-10-06 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-07 04:21:36 | Northern Territory, Australia | |||
3832167 | 3832167 | 2021-10-05 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-06 04:21:33 | Northern Territory, Australia | |||
986660 | 986660 | 2021-10-04 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-05 04:21:27 | Northern Territory, Australia | |||
1273970 | 1273970 | 2021-10-03 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-04 04:21:31 | Northern Territory, Australia | |||
3927723 | 3927723 | 2021-10-02 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-03 04:21:24 | Northern Territory, Australia | |||
2131703 | 2131703 | 2021-10-01 | Australia | Northern Territory | 212 | 0 | 0 | -12.4634 | 130.8456 | 2021-10-02 04:21:25 | Northern Territory, Australia | |||
708445 | 708445 | 2021-09-29 | US | Montana | McCone | 30055 | 212 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-09-30 04:21:20 | McCone, Montana, US | |
1336287 | 1336287 | 2021-09-28 | US | Montana | McCone | 30055 | 212 | 2 | 0 | 47.64469406 | -105.79449939999999 | 2021-09-29 04:21:45 | McCone, Montana, US | |
1238705 | 1238705 | 2021-09-27 | US | Texas | Cottle | 48101 | 212 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-09-28 04:21:28 | Cottle, Texas, US | |
2079006 | 2079006 | 2021-09-26 | US | Texas | Cottle | 48101 | 212 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-09-27 04:21:16 | Cottle, Texas, US | |
2077304 | 2077304 | 2021-09-26 | US | Kansas | Wallace | 20199 | 212 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-09-27 04:21:16 | Wallace, Kansas, US | |
1727558 | 1727558 | 2021-09-25 | US | Texas | Cottle | 48101 | 212 | 9 | 0 | 34.07783319 | -100.27850620000001 | 2021-09-26 04:21:29 | Cottle, Texas, US | |
1725856 | 1725856 | 2021-09-25 | US | Kansas | Wallace | 20199 | 212 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-09-26 04:21:29 | Wallace, Kansas, US | |
1923339 | 1923339 | 2021-09-24 | US | Nebraska | Sherman | 31163 | 212 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-09-25 04:21:31 | Sherman, Nebraska, US | |
1922576 | 1922576 | 2021-09-24 | US | Kansas | Wallace | 20199 | 212 | 4 | 0 | 38.91686134 | -101.76388759999999 | 2021-09-25 04:21:31 | Wallace, Kansas, US | |
603810 | 603810 | 2021-09-23 | US | Nebraska | Sherman | 31163 | 212 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-09-24 04:21:44 | Sherman, Nebraska, US | |
3013454 | 3013454 | 2021-09-22 | US | Nebraska | Sherman | 31163 | 212 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-09-23 04:21:43 | Sherman, Nebraska, US | |
3759592 | 3759592 | 2021-09-21 | US | Nebraska | Sherman | 31163 | 212 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-09-22 04:21:45 | Sherman, Nebraska, US | |
3758064 | 3758064 | 2021-09-21 | US | California | Unassigned | 90006 | 212 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-22 04:21:45 | Unassigned, California, US | |
812003 | 812003 | 2021-09-20 | US | North Dakota | Steele | 38091 | 212 | 2 | 0 | 47.45611548 | -97.72728747 | 2021-09-21 04:21:26 | Steele, North Dakota, US | |
811695 | 811695 | 2021-09-20 | US | Nebraska | Sherman | 31163 | 212 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-09-21 04:21:26 | Sherman, Nebraska, US | |
809995 | 809995 | 2021-09-20 | US | Alaska | Denali | 2068 | 212 | 0 | 0 | 63.67264044 | -150.0076108 | 2021-09-21 04:21:26 | Denali, Alaska, US | |
1816894 | 1816894 | 2021-09-19 | US | Nebraska | Sherman | 31163 | 212 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-09-20 04:21:22 | Sherman, Nebraska, US | |
1816483 | 1816483 | 2021-09-19 | US | Minnesota | Cook | 27031 | 212 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-20 04:21:22 | Cook, Minnesota, US | |
18474 | 18474 | 2021-09-18 | US | Nebraska | Sherman | 31163 | 212 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-09-19 04:21:34 | Sherman, Nebraska, US | |
18063 | 18063 | 2021-09-18 | US | Minnesota | Cook | 27031 | 212 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-19 04:21:34 | Cook, Minnesota, US | |
2620159 | 2620159 | 2021-09-17 | US | Nebraska | Sherman | 31163 | 212 | 4 | 0 | 41.22045983 | -98.97588642 | 2021-09-18 04:21:24 | Sherman, Nebraska, 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]);