johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
697 rows where confirmed = 473 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311245 | 311245 | 2022-12-13 | US | Virginia | Highland | 51091 | 473 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-14 04:21:04 | Highland, Virginia, US | |
1988007 | 1988007 | 2022-12-07 | US | Virginia | Highland | 51091 | 473 | 6 | 0 | 38.35799465 | -79.56124594 | 2022-12-08 04:21:07 | Highland, Virginia, US | |
3314628 | 3314628 | 2022-11-23 | US | North Dakota | Burke | 38013 | 473 | 3 | 0 | 48.79094471 | -102.5182117 | 2022-11-24 04:21:09 | Burke, North Dakota, US | |
1623719 | 1623719 | 2022-11-22 | US | Washington | Garfield | 53023 | 473 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-11-23 04:21:06 | Garfield, Washington, US | |
3463607 | 3463607 | 2022-11-21 | US | Washington | Garfield | 53023 | 473 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-11-22 04:20:47 | Garfield, Washington, US | |
1643792 | 1643792 | 2022-11-20 | US | Washington | Garfield | 53023 | 473 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-11-21 04:21:05 | Garfield, Washington, US | |
2067349 | 2067349 | 2022-11-19 | US | Washington | Garfield | 53023 | 473 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-11-20 04:21:08 | Garfield, Washington, US | |
1758743 | 1758743 | 2022-11-18 | US | Washington | Garfield | 53023 | 473 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-11-19 04:21:14 | Garfield, Washington, US | |
3029736 | 3029736 | 2022-11-17 | US | Washington | Garfield | 53023 | 473 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-11-18 04:21:15 | Garfield, Washington, US | |
2489447 | 2489447 | 2022-11-16 | US | Washington | Garfield | 53023 | 473 | 7 | 0 | 46.43197502 | -117.5454032 | 2022-11-17 04:21:11 | Garfield, Washington, US | |
293376 | 293376 | 2022-11-15 | US | Kansas | Wallace | 20199 | 473 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-11-16 04:21:09 | Wallace, Kansas, US | |
3599118 | 3599118 | 2022-11-14 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-15 04:21:16 | Franklin, Nebraska, US | |
3598406 | 3598406 | 2022-11-14 | US | Kansas | Wallace | 20199 | 473 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-11-15 04:21:16 | Wallace, Kansas, US | |
313976 | 313976 | 2022-11-13 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-14 04:21:09 | Franklin, Nebraska, US | |
313264 | 313264 | 2022-11-13 | US | Kansas | Wallace | 20199 | 473 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-11-14 04:21:09 | Wallace, Kansas, US | |
65137 | 65137 | 2022-11-12 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-13 04:21:14 | Franklin, Nebraska, US | |
64425 | 64425 | 2022-11-12 | US | Kansas | Wallace | 20199 | 473 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-11-13 04:21:14 | Wallace, Kansas, US | |
2929299 | 2929299 | 2022-11-11 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-12 04:20:41 | Franklin, Nebraska, US | |
2928587 | 2928587 | 2022-11-11 | US | Kansas | Wallace | 20199 | 473 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-11-12 04:20:41 | Wallace, Kansas, US | |
2508135 | 2508135 | 2022-11-10 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-11 04:21:22 | Franklin, Nebraska, US | |
2507423 | 2507423 | 2022-11-10 | US | Kansas | Wallace | 20199 | 473 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-11-11 04:21:22 | Wallace, Kansas, US | |
2433010 | 2433010 | 2022-11-09 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-10 04:21:16 | Franklin, Nebraska, US | |
2432298 | 2432298 | 2022-11-09 | US | Kansas | Wallace | 20199 | 473 | 8 | 0 | 38.91686134 | -101.7638876 | 2022-11-10 04:21:16 | Wallace, Kansas, US | |
481666 | 481666 | 2022-11-08 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-09 04:21:22 | Franklin, Nebraska, US | |
2440816 | 2440816 | 2022-11-07 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-08 04:21:21 | Franklin, Nebraska, US | |
1051914 | 1051914 | 2022-11-06 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-07 04:21:26 | Franklin, Nebraska, US | |
619938 | 619938 | 2022-11-05 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-06 04:21:24 | Franklin, Nebraska, US | |
1024442 | 1024442 | 2022-11-04 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-05 04:21:52 | Franklin, Nebraska, US | |
433433 | 433433 | 2022-11-03 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-04 04:22:11 | Franklin, Nebraska, US | |
851675 | 851675 | 2022-11-02 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-03 04:22:05 | Franklin, Nebraska, US | |
712526 | 712526 | 2022-11-01 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-02 04:22:09 | Franklin, Nebraska, US | |
3286975 | 3286975 | 2022-10-31 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-11-01 04:22:36 | Franklin, Nebraska, US | |
322008 | 322008 | 2022-10-30 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-10-31 04:21:36 | Franklin, Nebraska, US | |
914284 | 914284 | 2022-10-29 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-10-30 04:22:14 | Franklin, Nebraska, US | |
1368553 | 1368553 | 2022-10-28 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-10-29 04:21:13 | Franklin, Nebraska, US | |
3040408 | 3040408 | 2022-10-27 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-10-28 04:22:31 | Franklin, Nebraska, US | |
540828 | 540828 | 2022-10-26 | US | Nebraska | Franklin | 31061 | 473 | 14 | 0 | 40.17636348 | -98.95299073 | 2022-10-27 04:22:01 | Franklin, Nebraska, US | |
993183 | 993183 | 2022-08-16 | US | New Mexico | Catron | 35003 | 473 | 22 | 0 | 33.91514144 | -108.4046587 | 2022-08-17 04:20:59 | Catron, New Mexico, US | |
903238 | 903238 | 2022-07-22 | US | Texas | Dickens | 48125 | 473 | 16 | 0 | 33.61616822 | -100.7788855 | 2022-07-23 04:20:53 | Dickens, Texas, US | |
2493052 | 2493052 | 2022-06-29 | US | Texas | Briscoe | 48045 | 473 | 8 | 0 | 34.53026962 | -101.2084947 | 2022-06-30 04:21:01 | Briscoe, Texas, US | |
3349767 | 3349767 | 2022-06-24 | US | Texas | Irion | 48235 | 473 | 3 | 0 | 31.30375559 | -100.982439 | 2022-06-25 04:20:57 | Irion, Texas, US | |
3510469 | 3510469 | 2022-06-05 | US | Texas | Edwards | 48137 | 473 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-06 04:20:57 | Edwards, Texas, US | |
3530546 | 3530546 | 2022-06-04 | US | Texas | Edwards | 48137 | 473 | 11 | 0 | 29.98202582 | -100.304252 | 2022-06-05 04:20:55 | Edwards, Texas, US | |
3188389 | 3188389 | 2022-05-30 | US | North Dakota | Divide | 38023 | 473 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-31 04:20:51 | Divide, North Dakota, US | |
3200538 | 3200538 | 2022-05-29 | US | North Dakota | Divide | 38023 | 473 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-30 04:20:50 | Divide, North Dakota, US | |
2727416 | 2727416 | 2022-05-28 | US | North Dakota | Divide | 38023 | 473 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-29 04:20:53 | Divide, North Dakota, US | |
1316597 | 1316597 | 2022-05-27 | US | North Dakota | Divide | 38023 | 473 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-28 04:21:07 | Divide, North Dakota, US | |
1852389 | 1852389 | 2022-05-26 | US | North Dakota | Divide | 38023 | 473 | 4 | 0 | 48.8149387 | -103.4873611 | 2022-05-27 04:20:56 | Divide, North Dakota, US | |
698062 | 698062 | 2022-03-17 | Vanuatu | 473 | 1 | 0 | -15.3767 | 166.9592 | 2022-03-18 04:20:55 | Vanuatu | ||||
2094499 | 2094499 | 2022-03-05 | US | North Dakota | Golden Valley | 38033 | 473 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-03-06 04:20:49 | Golden Valley, North Dakota, US | |
2668199 | 2668199 | 2022-03-04 | US | North Dakota | Golden Valley | 38033 | 473 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-03-05 04:21:10 | Golden Valley, North Dakota, US | |
1646764 | 1646764 | 2022-03-03 | US | North Dakota | Golden Valley | 38033 | 473 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-03-04 04:21:09 | Golden Valley, North Dakota, US | |
2527767 | 2527767 | 2022-03-02 | US | North Dakota | Golden Valley | 38033 | 473 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-03-03 04:21:01 | Golden Valley, North Dakota, US | |
1995061 | 1995061 | 2022-03-01 | US | North Dakota | Golden Valley | 38033 | 473 | 4 | 0 | 46.94022281 | -103.8465421 | 2022-03-02 04:21:07 | Golden Valley, North Dakota, US | |
3048455 | 3048455 | 2022-02-26 | US | New York | Unassigned | 90036 | 473 | 1 | 0 | 44.74530905 | 0.0 | 2022-02-27 04:21:04 | Unassigned, New York, US | |
577110 | 577110 | 2022-02-25 | US | New York | Unassigned | 90036 | 473 | 1 | 0 | 44.74530905 | 0.0 | 2022-02-26 04:21:12 | Unassigned, New York, US | |
462554 | 462554 | 2022-02-02 | US | Texas | Menard | 48327 | 473 | 12 | 0 | 30.88990665 | -99.82047940000001 | 2022-02-03 04:21:21 | Menard, Texas, US | |
981965 | 981965 | 2022-02-01 | US | Texas | Armstrong | 48011 | 473 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2022-02-02 04:21:09 | Armstrong, Texas, US | |
2660807 | 2660807 | 2022-01-31 | US | Texas | Armstrong | 48011 | 473 | 8 | 0 | 34.96507426 | -101.35748740000001 | 2022-02-01 04:21:11 | Armstrong, Texas, US | |
1780657 | 1780657 | 2022-01-27 | US | Kansas | Clark | 20025 | 473 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-01-28 04:21:09 | Clark, Kansas, US | |
1319485 | 1319485 | 2022-01-26 | US | Kansas | Clark | 20025 | 473 | 7 | 0 | 37.23577007 | -99.81883015 | 2022-01-27 04:21:19 | Clark, Kansas, US | |
2054424 | 2054424 | 2022-01-25 | US | Oklahoma | Cimarron | 40025 | 473 | 0 | 0 | 36.74817177 | -102.5173885 | 2022-01-26 04:21:07 | Cimarron, Oklahoma, US | |
1230155 | 1230155 | 2022-01-24 | US | Oklahoma | Cimarron | 40025 | 473 | 0 | 0 | 36.74817177 | -102.5173885 | 2022-01-25 04:21:05 | Cimarron, Oklahoma, US | |
1143978 | 1143978 | 2022-01-23 | US | Texas | Culberson | 48109 | 473 | 13 | 0 | 31.44506775 | -104.5185739 | 2022-01-24 04:21:12 | Culberson, Texas, US | |
1143454 | 1143454 | 2022-01-23 | US | Oklahoma | Cimarron | 40025 | 473 | 0 | 0 | 36.74817177 | -102.5173885 | 2022-01-24 04:21:12 | Cimarron, Oklahoma, US | |
2835372 | 2835372 | 2022-01-22 | US | Oklahoma | Cimarron | 40025 | 473 | 0 | 0 | 36.74817177 | -102.5173885 | 2022-01-23 04:21:13 | Cimarron, Oklahoma, US | |
3427490 | 3427490 | 2022-01-21 | US | Oklahoma | Cimarron | 40025 | 473 | 0 | 0 | 36.74817177 | -102.5173885 | 2022-01-22 04:21:13 | Cimarron, Oklahoma, US | |
1963098 | 1963098 | 2022-01-20 | US | Oklahoma | Cimarron | 40025 | 473 | 0 | 0 | 36.74817177 | -102.5173885 | 2022-01-21 04:21:09 | Cimarron, Oklahoma, US | |
1962560 | 1962560 | 2022-01-20 | US | Montana | Granite | 30039 | 473 | 6 | 0 | 46.40605220000001 | -113.4414186 | 2022-01-21 04:21:09 | Granite, Montana, US | |
1961307 | 1961307 | 2022-01-20 | US | Georgia | Baker | 13007 | 473 | 14 | 0 | 31.32669878 | -84.44218806 | 2022-01-21 04:21:09 | Baker, Georgia, US | |
3228993 | 3228993 | 2022-01-19 | US | Oklahoma | Cimarron | 40025 | 473 | 0 | 0 | 36.74817177 | -102.5173885 | 2022-01-20 04:21:07 | Cimarron, Oklahoma, US | |
3228524 | 3228524 | 2022-01-19 | US | Nebraska | Frontier | 31063 | 473 | 1 | 0 | 40.52993007 | -100.3924658 | 2022-01-20 04:21:07 | Frontier, Nebraska, US | |
3690590 | 3690590 | 2022-01-13 | US | Texas | Hardeman | 48197 | 473 | 14 | 0 | 34.28944521 | -99.74632408 | 2022-01-14 04:21:54 | Hardeman, Texas, US | |
129603 | 129603 | 2022-01-09 | US | South Dakota | Faulk | 46049 | 473 | 16 | 0 | 45.07082625 | -99.14535601 | 2022-01-10 04:22:07 | Faulk, South Dakota, US | |
1218438 | 1218438 | 2022-01-08 | US | South Dakota | Faulk | 46049 | 473 | 16 | 0 | 45.07082625 | -99.14535601 | 2022-01-09 04:21:46 | Faulk, South Dakota, US | |
1392531 | 1392531 | 2022-01-07 | US | South Dakota | Faulk | 46049 | 473 | 16 | 0 | 45.07082625 | -99.14535601 | 2022-01-08 04:21:53 | Faulk, South Dakota, US | |
2613238 | 2613238 | 2022-01-06 | US | Texas | Oldham | 48359 | 473 | 6 | 0 | 35.40425596 | -102.6027606 | 2022-01-07 04:22:09 | Oldham, Texas, US | |
1284112 | 1284112 | 2022-01-05 | US | Nebraska | Sherman | 31163 | 473 | 4 | 0 | 41.22045983 | -98.97588642 | 2022-01-06 04:22:09 | Sherman, Nebraska, US | |
1287272 | 1287272 | 2022-01-04 | US | Kansas | Chase | 20017 | 473 | 6 | 0 | 38.30292938 | -96.59563862 | 2022-01-05 04:21:59 | Chase, Kansas, US | |
1701616 | 1701616 | 2022-01-03 | US | Kansas | Chase | 20017 | 473 | 6 | 0 | 38.30292938 | -96.59563862 | 2022-01-04 04:22:17 | Chase, Kansas, US | |
4001036 | 4001036 | 2021-12-30 | US | North Dakota | Adams | 38001 | 473 | 8 | 0 | 46.09686891 | -102.5285397 | 2021-12-31 04:21:50 | Adams, North Dakota, US | |
1434999 | 1434999 | 2021-12-28 | US | North Dakota | Towner | 38095 | 473 | 11 | 0 | 48.68565745 | -99.24564265 | 2021-12-29 03:21:43 | Towner, North Dakota, US | |
801199 | 801199 | 2021-12-22 | US | Puerto Rico | Patillas | 72109 | 473 | 0 | 0 | 18.03174 | -66.012242 | 2021-12-23 04:21:21 | Patillas, Puerto Rico, US | |
1080838 | 1080838 | 2021-12-09 | US | South Dakota | Ziebach | 46137 | 473 | 10 | 0 | 44.97881876 | -101.6654622 | 2021-12-10 04:22:28 | Ziebach, South Dakota, US | |
553687 | 553687 | 2021-12-08 | US | South Dakota | Ziebach | 46137 | 473 | 10 | 0 | 44.97881876 | -101.6654622 | 2021-12-09 04:22:49 | Ziebach, South Dakota, US | |
1033252 | 1033252 | 2021-12-06 | US | South Dakota | Hanson | 46061 | 473 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-12-07 04:22:34 | Hanson, South Dakota, US | |
1743415 | 1743415 | 2021-12-05 | US | South Dakota | Hanson | 46061 | 473 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-12-06 04:22:34 | Hanson, South Dakota, US | |
140847 | 140847 | 2021-12-04 | US | South Dakota | Hanson | 46061 | 473 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-12-05 04:22:25 | Hanson, South Dakota, US | |
2198500 | 2198500 | 2021-12-03 | US | South Dakota | Hanson | 46061 | 473 | 5 | 0 | 43.6746384 | -97.78715148 | 2021-12-04 04:22:18 | Hanson, South Dakota, US | |
1680 | 1680 | 2021-12-02 | US | Kansas | Smith | 20183 | 473 | 4 | 0 | 39.78516566 | -98.78566062 | 2021-12-03 04:23:05 | Smith, Kansas, US | |
1146279 | 1146279 | 2021-12-01 | US | Kansas | Smith | 20183 | 473 | 4 | 0 | 39.78516566 | -98.78566062 | 2021-12-02 04:22:37 | Smith, Kansas, US | |
3402791 | 3402791 | 2021-11-30 | US | Kansas | Smith | 20183 | 473 | 3 | 0 | 39.78516566 | -98.78566062 | 2021-12-01 04:22:29 | Smith, Kansas, US | |
151334 | 151334 | 2021-11-29 | US | Kansas | Smith | 20183 | 473 | 3 | 0 | 39.78516566 | -98.78566062 | 2021-11-30 04:22:53 | Smith, Kansas, US | |
904791 | 904791 | 2021-11-24 | US | Colorado | Custer | 8027 | 473 | 13 | 0 | 38.10883162 | -105.3683478 | 2021-11-25 04:22:33 | Custer, Colorado, US | |
165082 | 165082 | 2021-11-19 | US | Texas | Collingsworth | 48087 | 473 | 11 | 0 | 34.96489496 | -100.27001109999999 | 2021-11-20 04:22:17 | Collingsworth, Texas, US | |
3291969 | 3291969 | 2021-11-18 | US | Texas | Collingsworth | 48087 | 473 | 11 | 0 | 34.96489496 | -100.27001109999999 | 2021-11-19 04:21:40 | Collingsworth, Texas, US | |
450425 | 450425 | 2021-11-17 | US | Texas | Collingsworth | 48087 | 473 | 11 | 0 | 34.96489496 | -100.27001109999999 | 2021-11-18 04:21:33 | Collingsworth, Texas, US | |
278593 | 278593 | 2021-11-03 | US | North Dakota | McIntosh | 38051 | 473 | 8 | 0 | 46.11182017 | -99.44145858 | 2021-11-04 04:22:20 | McIntosh, North Dakota, US | |
46118 | 46118 | 2021-11-02 | US | North Dakota | McIntosh | 38051 | 473 | 8 | 0 | 46.11182017 | -99.44145858 | 2021-11-03 06:22:09 | McIntosh, North Dakota, US | |
290844 | 290844 | 2021-10-31 | US | South Dakota | Bennett | 46007 | 473 | 9 | 0 | 43.19486375 | -101.6665572 | 2021-11-01 04:22:01 | Bennett, South Dakota, 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]);