daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
160 rows where confirmed = 4625 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-19 | US | Missouri | Cooper | 29053 | 4625 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-20 04:21:04 | Cooper, Missouri, US | |
2022-12-18 | US | Missouri | Cooper | 29053 | 4625 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-19 04:21:03 | Cooper, Missouri, US | |
2022-12-17 | US | Missouri | Cooper | 29053 | 4625 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-18 04:21:03 | Cooper, Missouri, US | |
2022-12-16 | US | Missouri | Cooper | 29053 | 4625 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-17 04:21:04 | Cooper, Missouri, US | |
2022-12-15 | US | Missouri | Cooper | 29053 | 4625 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-16 04:21:01 | Cooper, Missouri, US | |
2022-12-14 | US | New Mexico | Socorro | 35053 | 4625 | 98 | 0 | 34.00715494 | -106.9298354 | 2022-12-15 04:20:58 | Socorro, New Mexico, US | |
2022-12-14 | US | Missouri | Cooper | 29053 | 4625 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-15 04:20:58 | Cooper, Missouri, US | |
2022-12-13 | US | Missouri | Cooper | 29053 | 4625 | 80 | 0 | 38.844478 | -92.80896081 | 2022-12-14 04:21:04 | Cooper, Missouri, US | |
2022-12-07 | US | Puerto Rico | Hormigueros | 72067 | 4625 | 0 | 0 | 18.134532 | -67.113972 | 2022-12-08 04:21:07 | Hormigueros, Puerto Rico, US | |
2022-11-15 | US | Virginia | Appomattox | 51011 | 4625 | 58 | 0 | 37.37569884 | -78.81340003 | 2022-11-16 04:21:09 | Appomattox, Virginia, US | |
2022-11-02 | US | Arkansas | Madison | 5087 | 4625 | 65 | 0 | 36.01038185 | -93.72524943 | 2022-11-03 04:22:05 | Madison, Arkansas, US | |
2022-09-15 | US | Illinois | Moultrie | 17139 | 4625 | 49 | 0 | 39.64187451 | -88.62099969 | 2022-09-16 04:21:19 | Moultrie, Illinois, US | |
2022-09-14 | US | Virginia | Rockbridge | 51163 | 4625 | 89 | 0 | 37.81204314 | -79.44605905 | 2022-09-15 04:21:02 | Rockbridge, Virginia, US | |
2022-09-11 | US | Puerto Rico | Patillas | 72109 | 4625 | 0 | 0 | 18.03174 | -66.012242 | 2022-09-12 04:20:58 | Patillas, Puerto Rico, US | |
2022-09-07 | US | Texas | Andrews | 48003 | 4625 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-09-08 04:21:02 | Andrews, Texas, US | |
2022-09-06 | US | Texas | Andrews | 48003 | 4625 | 73 | 0 | 32.30468633 | -102.6376548 | 2022-09-07 04:20:59 | Andrews, Texas, US | |
2022-08-31 | US | Puerto Rico | Arroyo | 72015 | 4625 | 0 | 0 | 17.998457 | -66.056546 | 2022-09-01 04:21:03 | Arroyo, Puerto Rico, US | |
2022-08-28 | US | Indiana | Carroll | 18015 | 4625 | 71 | 0 | 40.5807832 | -86.56198812 | 2022-08-29 04:21:06 | Carroll, Indiana, US | |
2022-08-27 | US | Indiana | Carroll | 18015 | 4625 | 71 | 0 | 40.5807832 | -86.56198812 | 2022-08-28 04:21:02 | Carroll, Indiana, US | |
2022-08-26 | US | Indiana | Carroll | 18015 | 4625 | 71 | 0 | 40.5807832 | -86.56198812 | 2022-08-27 04:20:57 | Carroll, Indiana, US | |
2022-07-31 | US | Wisconsin | Crawford | 55023 | 4625 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-08-01 04:21:03 | Crawford, Wisconsin, US | |
2022-07-30 | US | Wisconsin | Crawford | 55023 | 4625 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-07-31 04:21:02 | Crawford, Wisconsin, US | |
2022-07-29 | US | Wisconsin | Crawford | 55023 | 4625 | 31 | 0 | 43.23870316 | -90.93073686 | 2022-07-30 04:20:42 | Crawford, Wisconsin, US | |
2022-07-14 | US | Texas | Shelby | 48419 | 4625 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-07-15 04:20:53 | Shelby, Texas, US | |
2022-06-01 | US | Texas | Panola | 48365 | 4625 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-06-02 05:20:39 | Panola, Texas, US | |
2022-06-01 | US | Alabama | Henry | 1067 | 4625 | 76 | 0 | 31.51148016 | -85.24267944 | 2022-06-02 05:20:39 | Henry, Alabama, US | |
2022-05-31 | US | Texas | Panola | 48365 | 4625 | 129 | 0 | 32.1639596 | -94.30552481 | 2022-06-01 04:20:55 | Panola, Texas, US | |
2022-05-25 | US | Illinois | Piatt | 17147 | 4625 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-05-26 04:20:50 | Piatt, Illinois, US | |
2022-05-22 | US | Illinois | Piatt | 17147 | 4625 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-05-26 04:20:50 | Piatt, Illinois, US | |
2022-05-21 | US | Puerto Rico | Anasco | 72011 | 4625 | 0 | 0 | 18.287985 | -67.120611 | 2022-05-22 04:20:52 | Anasco, Puerto Rico, US | |
2022-05-17 | US | Georgia | Worth | 13321 | 4625 | 119 | 0 | 31.55162306 | -83.85090513 | 2022-05-18 04:20:50 | Worth, Georgia, US | |
2022-05-16 | US | Georgia | Worth | 13321 | 4625 | 119 | 0 | 31.55162306 | -83.85090513 | 2022-05-17 04:20:59 | Worth, Georgia, US | |
2022-05-15 | US | Georgia | Worth | 13321 | 4625 | 119 | 0 | 31.55162306 | -83.85090513 | 2022-05-16 04:20:47 | Worth, Georgia, US | |
2022-05-14 | US | Georgia | Worth | 13321 | 4625 | 119 | 0 | 31.55162306 | -83.85090513 | 2022-05-15 04:20:53 | Worth, Georgia, US | |
2022-05-13 | US | Georgia | Worth | 13321 | 4625 | 119 | 0 | 31.55162306 | -83.85090513 | 2022-05-14 04:20:48 | Worth, Georgia, US | |
2022-05-12 | US | Georgia | Worth | 13321 | 4625 | 119 | 0 | 31.55162306 | -83.85090513 | 2022-05-13 04:20:51 | Worth, Georgia, US | |
2022-05-11 | US | Georgia | Worth | 13321 | 4625 | 119 | 0 | 31.55162306 | -83.85090513 | 2022-05-12 04:20:54 | Worth, Georgia, US | |
2022-05-08 | US | Minnesota | Houston | 27055 | 4625 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-05-09 04:20:54 | Houston, Minnesota, US | |
2022-05-07 | US | Minnesota | Houston | 27055 | 4625 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-05-08 04:20:49 | Houston, Minnesota, US | |
2022-05-06 | US | Minnesota | Houston | 27055 | 4625 | 18 | 0 | 43.67129565 | -91.49143057 | 2022-05-07 04:21:09 | Houston, Minnesota, US | |
2022-05-04 | US | Texas | Reeves | 48389 | 4625 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-05-05 04:20:55 | Reeves, Texas, US | |
2022-05-03 | US | Texas | Reeves | 48389 | 4625 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-05-04 04:20:59 | Reeves, Texas, US | |
2022-04-27 | US | Ohio | Meigs | 39105 | 4625 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-28 04:20:47 | Meigs, Ohio, US | |
2022-04-26 | US | Ohio | Meigs | 39105 | 4625 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-27 04:20:52 | Meigs, Ohio, US | |
2022-04-25 | US | Ohio | Meigs | 39105 | 4625 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-26 04:20:51 | Meigs, Ohio, US | |
2022-04-24 | US | Ohio | Meigs | 39105 | 4625 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-25 04:20:56 | Meigs, Ohio, US | |
2022-04-23 | US | Ohio | Meigs | 39105 | 4625 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-24 04:20:56 | Meigs, Ohio, US | |
2022-04-22 | US | Ohio | Meigs | 39105 | 4625 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-23 04:20:50 | Meigs, Ohio, US | |
2022-04-21 | US | Ohio | Meigs | 39105 | 4625 | 89 | 0 | 39.09224872 | -82.0305041 | 2022-04-22 04:20:45 | Meigs, Ohio, US | |
2022-03-28 | US | Wisconsin | Adams | 55001 | 4625 | 61 | 0 | 43.96974651 | -89.76782777 | 2022-03-29 04:20:46 | Adams, Wisconsin, US | |
2022-03-06 | US | Texas | Montague | 48337 | 4625 | 122 | 0 | 33.67521893 | -97.72500958 | 2022-03-07 04:20:47 | Montague, Texas, US | |
2022-03-05 | US | Texas | Montague | 48337 | 4625 | 122 | 0 | 33.67521893 | -97.72500958 | 2022-03-06 04:20:49 | Montague, Texas, US | |
2022-03-04 | US | Texas | Montague | 48337 | 4625 | 122 | 0 | 33.67521893 | -97.72500958 | 2022-03-05 04:21:10 | Montague, Texas, US | |
2022-03-03 | US | Texas | Montague | 48337 | 4625 | 121 | 0 | 33.67521893 | -97.72500958 | 2022-03-04 04:21:09 | Montague, Texas, US | |
2022-03-03 | US | Indiana | Perry | 18123 | 4625 | 62 | 0 | 38.07809328 | -86.63741946 | 2022-03-04 04:21:09 | Perry, Indiana, US | |
2022-02-24 | US | Minnesota | Fillmore | 27045 | 4625 | 23 | 0 | 43.67394126 | -92.08980382 | 2022-02-25 04:21:11 | Fillmore, Minnesota, US | |
2022-02-22 | US | Idaho | Cassia | 16031 | 4625 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-02-23 04:21:09 | Cassia, Idaho, US | |
2022-02-21 | US | Kentucky | Powell | 21197 | 4625 | 33 | 0 | 37.83218794 | -83.82553961 | 2022-02-22 04:21:01 | Powell, Kentucky, US | |
2022-02-02 | US | Puerto Rico | Hatillo | 72065 | 4625 | 0 | 0 | 18.410928 | -66.79632600000001 | 2022-02-03 04:21:21 | Hatillo, Puerto Rico, US | |
2022-01-30 | US | Mississippi | Winston | 28159 | 4625 | 96 | 0 | 33.08747908 | -89.03391385 | 2022-01-31 04:21:09 | Winston, Mississippi, US | |
2022-01-30 | US | Mississippi | Clay | 28025 | 4625 | 80 | 0 | 33.65358105 | -88.77784255 | 2022-01-31 04:21:09 | Clay, Mississippi, US | |
2022-01-29 | US | Mississippi | Winston | 28159 | 4625 | 96 | 0 | 33.08747908 | -89.03391385 | 2022-01-30 04:21:26 | Winston, Mississippi, US | |
2022-01-29 | US | Mississippi | Clay | 28025 | 4625 | 80 | 0 | 33.65358105 | -88.77784255 | 2022-01-30 04:21:26 | Clay, Mississippi, US | |
2022-01-28 | US | Mississippi | Winston | 28159 | 4625 | 96 | 0 | 33.08747908 | -89.03391385 | 2022-01-29 04:21:10 | Winston, Mississippi, US | |
2022-01-28 | US | Mississippi | Clay | 28025 | 4625 | 80 | 0 | 33.65358105 | -88.77784255 | 2022-01-29 04:21:10 | Clay, Mississippi, US | |
2022-01-25 | US | Illinois | Edgar | 17045 | 4625 | 55 | 0 | 39.6809186 | -87.74759563 | 2022-01-26 04:21:07 | Edgar, Illinois, US | |
2022-01-19 | US | Kentucky | Johnson | 21115 | 4625 | 82 | 0 | 37.85106355 | -82.8264322 | 2022-01-20 04:21:07 | Johnson, Kentucky, US | |
2022-01-18 | US | Virginia | Fredericksburg | 51630 | 4625 | 28 | 0 | 38.2977863 | -77.4922454 | 2022-01-19 04:21:23 | Fredericksburg, Virginia, US | |
2022-01-06 | US | Kentucky | Rowan | 21205 | 4625 | 46 | 0 | 38.19484205 | -83.42088935 | 2022-01-07 04:22:09 | Rowan, Kentucky, US | |
2022-01-05 | US | Missouri | Miller | 29131 | 4625 | 104 | 0 | 38.21450288 | -92.42610898 | 2022-01-06 04:22:09 | Miller, Missouri, US | |
2022-01-04 | US | Michigan | Emmet | 26047 | 4625 | 61 | 0 | 45.52625509 | -84.89083249 | 2022-01-05 04:21:59 | Emmet, Michigan, US | |
2022-01-03 | US | Michigan | Emmet | 26047 | 4625 | 61 | 0 | 45.52625509 | -84.89083249 | 2022-01-04 04:22:17 | Emmet, Michigan, US | |
2021-12-06 | US | Indiana | Fayette | 18041 | 4625 | 97 | 0 | 39.63684962 | -85.17797541 | 2021-12-07 04:22:34 | Fayette, Indiana, US | |
2021-12-04 | US | Texas | Gray | 48179 | 4625 | 84 | 0 | 35.40081878 | -100.8129222 | 2021-12-05 04:22:25 | Gray, Texas, US | |
2021-12-04 | US | New York | Delaware | 36025 | 4625 | 53 | 0 | 42.19837623 | -74.96709306 | 2021-12-05 04:22:25 | Delaware, New York, US | |
2021-12-01 | Japan | Port Quarantine | 4625 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2021-11-30 | Japan | Port Quarantine | 4625 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2021-11-29 | US | Missouri | Dunklin | 29069 | 4625 | 64 | 0 | 36.27167174 | -90.09122243 | 2021-11-30 04:22:53 | Dunklin, Missouri, US | |
2021-11-18 | US | Kentucky | Mercer | 21167 | 4625 | 76 | 0 | 37.81474237 | -84.87488475 | 2021-11-19 04:21:40 | Mercer, Kentucky, US | |
2021-11-15 | US | North Carolina | Montgomery | 37123 | 4625 | 110 | 0 | 35.33155144 | -79.90416657 | 2021-11-16 04:21:10 | Montgomery, North Carolina, US | |
2021-10-28 | US | Georgia | Unassigned | 90013 | 4625 | 9 | 0 | 34.91369188 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Georgia, US | |
2021-10-10 | US | Kansas | Geary | 20061 | 4625 | 54 | 0 | 38.99871131 | -96.7577178 | 2021-10-11 04:21:31 | Geary, Kansas, US | |
2021-10-09 | US | Kansas | Geary | 20061 | 4625 | 54 | 0 | 38.99871131 | -96.7577178 | 2021-10-10 04:21:38 | Geary, Kansas, US | |
2021-10-08 | US | Maine | Oxford | 23017 | 4625 | 74 | 0 | 44.49952995 | -70.75682123 | 2021-10-09 04:21:34 | Oxford, Maine, US | |
2021-10-08 | US | Kansas | Geary | 20061 | 4625 | 54 | 0 | 38.99871131 | -96.7577178 | 2021-10-09 04:21:34 | Geary, Kansas, US | |
2021-10-03 | US | Wisconsin | Trempealeau | 55121 | 4625 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-10-04 04:21:31 | Trempealeau, Wisconsin, US | |
2021-10-02 | US | Wisconsin | Trempealeau | 55121 | 4625 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-10-03 04:21:24 | Trempealeau, Wisconsin, US | |
2021-10-01 | US | Wisconsin | Trempealeau | 55121 | 4625 | 52 | 0 | 44.30360275 | -91.35893614 | 2021-10-02 04:21:25 | Trempealeau, Wisconsin, US | |
2021-09-29 | US | Idaho | Bonner | 16017 | 4625 | 69 | 0 | 48.29996017 | -116.6017932 | 2021-09-30 04:21:20 | Bonner, Idaho, US | |
2021-09-18 | US | New York | Warren | 36113 | 4625 | 76 | 0 | 43.56173026 | -73.8433699 | 2021-09-19 04:21:34 | Warren, New York, US | |
2021-09-15 | US | Georgia | Unassigned | 90013 | 4625 | 12 | 0 | 34.91369188 | 0.0 | 2021-09-16 04:22:19 | Unassigned, Georgia, US | |
2021-09-12 | US | Alaska | Bethel | 2050 | 4625 | 23 | 0 | 60.90980451 | -159.8561831 | 2021-09-13 04:21:15 | Bethel, Alaska, US | |
2021-09-11 | US | Alaska | Bethel | 2050 | 4625 | 23 | 0 | 60.90980451 | -159.8561831 | 2021-09-12 04:21:13 | Bethel, Alaska, US | |
2021-09-10 | US | Indiana | Wabash | 18169 | 4625 | 89 | 0 | 40.84704239 | -85.79328272 | 2021-09-11 04:21:30 | Wabash, Indiana, US | |
2021-09-10 | US | Alaska | Bethel | 2050 | 4625 | 23 | 0 | 60.90980451 | -159.8561831 | 2021-09-11 04:21:30 | Bethel, Alaska, US | |
2021-08-31 | US | Georgia | Upson | 13293 | 4625 | 136 | 0 | 32.87920671 | -84.30024826 | 2021-09-01 04:21:38 | Upson, Georgia, US | |
2021-08-26 | US | Virginia | Franklin | 51067 | 4625 | 83 | 0 | 36.99536167 | -79.88023649 | 2021-08-27 04:21:37 | Franklin, Virginia, US | |
2021-08-16 | US | New York | Livingston | 36051 | 4625 | 60 | 0 | 42.72596275 | -77.77966158 | 2021-08-17 04:21:49 | Livingston, New York, US | |
2021-08-12 | US | Indiana | Huntington | 18069 | 4625 | 82 | 0 | 40.82907273 | -85.48822092 | 2021-08-13 04:21:24 | Huntington, Indiana, US | |
2021-08-08 | US | Virginia | Danville | 51590 | 4625 | 144 | 0 | 36.58022376 | -79.40395668 | 2021-08-09 04:21:24 | Danville, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;