daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
157 rows where confirmed = 4560 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 143
- Benin 5
- Saint Lucia 3
- China 2
- Comoros 1
- Japan 1
- Netherlands 1
- Russia 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-07 | US | Arkansas | Izard | 5065 | 4560 | 77 | 0 | 36.09604046 | -91.90847954 | 2022-12-08 04:21:07 | Izard, Arkansas, US | |
2022-11-17 | China | Shaanxi | 4560 | 3 | 0 | 35.1917 | 108.8701 | 2022-11-18 04:21:15 | Shaanxi, China | |||
2022-10-31 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-11-01 04:22:36 | Cooper, Missouri, US | |
2022-10-30 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-31 04:21:36 | Cooper, Missouri, US | |
2022-10-29 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-30 04:22:14 | Cooper, Missouri, US | |
2022-10-28 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-29 04:21:13 | Cooper, Missouri, US | |
2022-10-27 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-28 04:22:31 | Cooper, Missouri, US | |
2022-10-26 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-27 04:22:01 | Cooper, Missouri, US | |
2022-10-25 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-26 04:22:19 | Cooper, Missouri, US | |
2022-10-24 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-25 04:21:53 | Cooper, Missouri, US | |
2022-10-23 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-24 04:22:29 | Cooper, Missouri, US | |
2022-10-22 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-23 04:22:46 | Cooper, Missouri, US | |
2022-10-21 | US | Missouri | Cooper | 29053 | 4560 | 80 | 0 | 38.844478 | -92.80896081 | 2022-10-22 04:22:53 | Cooper, Missouri, US | |
2022-10-17 | US | North Dakota | Richland | 38077 | 4560 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-10-18 04:22:42 | Richland, North Dakota, US | |
2022-10-12 | US | Virginia | Appomattox | 51011 | 4560 | 58 | 0 | 37.37569884 | -78.81340003 | 2022-10-13 04:22:39 | Appomattox, Virginia, US | |
2022-09-24 | US | Puerto Rico | Ciales | 72039 | 4560 | 0 | 0 | 18.28885 | -66.516475 | 2022-09-25 04:23:31 | Ciales, Puerto Rico, US | |
2022-08-30 | US | Mississippi | Clarke | 28023 | 4560 | 109 | 0 | 32.04158545 | -88.6889622 | 2022-08-31 04:20:57 | Clarke, Mississippi, US | |
2022-08-29 | US | Mississippi | Clarke | 28023 | 4560 | 109 | 0 | 32.04158545 | -88.6889622 | 2022-08-30 04:21:03 | Clarke, Mississippi, US | |
2022-08-28 | US | Mississippi | Clarke | 28023 | 4560 | 109 | 0 | 32.04158545 | -88.6889622 | 2022-08-29 04:21:06 | Clarke, Mississippi, US | |
2022-08-27 | US | Mississippi | Clarke | 28023 | 4560 | 109 | 0 | 32.04158545 | -88.6889622 | 2022-08-28 04:21:02 | Clarke, Mississippi, US | |
2022-08-26 | US | Mississippi | Clarke | 28023 | 4560 | 109 | 0 | 32.04158545 | -88.6889622 | 2022-08-27 04:20:57 | Clarke, Mississippi, US | |
2022-08-25 | US | Mississippi | Clarke | 28023 | 4560 | 109 | 0 | 32.04158545 | -88.6889622 | 2022-08-26 04:21:02 | Clarke, Mississippi, US | |
2022-08-24 | US | Mississippi | Clarke | 28023 | 4560 | 109 | 0 | 32.04158545 | -88.6889622 | 2022-08-25 04:21:13 | Clarke, Mississippi, US | |
2022-08-23 | US | Mississippi | Clarke | 28023 | 4560 | 109 | 0 | 32.04158545 | -88.6889622 | 2022-08-24 04:20:46 | Clarke, Mississippi, US | |
2022-08-17 | US | West Virginia | Braxton | 54007 | 4560 | 48 | 0 | 38.70036159 | -80.72011184 | 2022-08-18 04:21:11 | Braxton, West Virginia, US | |
2022-08-15 | US | Illinois | Jo Daviess | 17085 | 4560 | 38 | 0 | 42.36542373 | -90.21094405 | 2022-08-16 04:20:58 | Jo Daviess, Illinois, US | |
2022-08-14 | US | Texas | Houston | 48225 | 4560 | 113 | 0 | 31.31925973 | -95.42226208 | 2022-08-15 04:20:59 | Houston, Texas, US | |
2022-08-13 | US | Texas | Houston | 48225 | 4560 | 113 | 0 | 31.31925973 | -95.42226208 | 2022-08-14 04:20:55 | Houston, Texas, US | |
2022-08-12 | US | Texas | Houston | 48225 | 4560 | 113 | 0 | 31.31925973 | -95.42226208 | 2022-08-13 04:20:52 | Houston, Texas, US | |
2022-07-27 | US | West Virginia | Hardy | 54031 | 4560 | 49 | 0 | 39.00683177 | -78.85855301 | 2022-07-28 04:20:56 | Hardy, West Virginia, US | |
2022-07-19 | US | North Carolina | Bertie | 37015 | 4560 | 71 | 0 | 36.0688473 | -76.96545943 | 2022-07-20 04:20:59 | Bertie, North Carolina, US | |
2022-07-18 | US | North Carolina | Bertie | 37015 | 4560 | 71 | 0 | 36.0688473 | -76.96545943 | 2022-07-19 04:20:58 | Bertie, North Carolina, US | |
2022-07-17 | US | North Carolina | Bertie | 37015 | 4560 | 71 | 0 | 36.0688473 | -76.96545943 | 2022-07-18 04:20:59 | Bertie, North Carolina, US | |
2022-07-16 | US | North Carolina | Bertie | 37015 | 4560 | 71 | 0 | 36.0688473 | -76.96545943 | 2022-07-17 04:21:15 | Bertie, North Carolina, US | |
2022-07-15 | US | North Carolina | Bertie | 37015 | 4560 | 71 | 0 | 36.0688473 | -76.96545943 | 2022-07-16 04:21:05 | Bertie, North Carolina, US | |
2022-07-14 | US | North Carolina | Bertie | 37015 | 4560 | 71 | 0 | 36.0688473 | -76.96545943 | 2022-07-15 04:20:53 | Bertie, North Carolina, US | |
2022-07-13 | US | North Carolina | Bertie | 37015 | 4560 | 71 | 0 | 36.0688473 | -76.96545943 | 2022-07-14 04:20:57 | Bertie, North Carolina, US | |
2022-07-10 | US | Illinois | White | 17193 | 4560 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-11 04:20:46 | White, Illinois, US | |
2022-07-09 | US | Illinois | White | 17193 | 4560 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-10 04:20:54 | White, Illinois, US | |
2022-07-08 | US | Illinois | White | 17193 | 4560 | 49 | 0 | 38.08706198 | -88.17657461 | 2022-07-09 04:20:59 | White, Illinois, US | |
2022-06-30 | US | Texas | Shelby | 48419 | 4560 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-07-01 04:21:10 | Shelby, Texas, US | |
2022-05-30 | US | Illinois | Ford | 17053 | 4560 | 67 | 0 | 40.59706922 | -88.22350769 | 2022-05-31 04:20:51 | Ford, Illinois, US | |
2022-05-29 | US | Illinois | Ford | 17053 | 4560 | 67 | 0 | 40.59706922 | -88.22350769 | 2022-05-30 04:20:50 | Ford, Illinois, US | |
2022-05-28 | US | Illinois | Ford | 17053 | 4560 | 67 | 0 | 40.59706922 | -88.22350769 | 2022-05-29 04:20:53 | Ford, Illinois, US | |
2022-05-27 | US | Illinois | Ford | 17053 | 4560 | 67 | 0 | 40.59706922 | -88.22350769 | 2022-05-28 04:21:07 | Ford, Illinois, US | |
2022-05-26 | US | Minnesota | Roseau | 27135 | 4560 | 44 | 0 | 48.77501878 | -95.81079919 | 2022-05-27 04:20:56 | Roseau, Minnesota, US | |
2022-05-17 | US | Washington | Asotin | 53003 | 4560 | 66 | 0 | 46.18894415 | -117.2022851 | 2022-05-18 04:20:50 | Asotin, Washington, US | |
2022-05-16 | US | Washington | Asotin | 53003 | 4560 | 66 | 0 | 46.18894415 | -117.2022851 | 2022-05-17 04:20:59 | Asotin, Washington, US | |
2022-05-11 | US | Puerto Rico | Quebradillas | 72115 | 4560 | 0 | 0 | 18.439692 | -66.926113 | 2022-05-12 04:20:54 | Quebradillas, Puerto Rico, US | |
2022-05-10 | US | Illinois | Piatt | 17147 | 4560 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-05-11 04:20:48 | Piatt, Illinois, US | |
2022-04-23 | US | Arkansas | Hempstead | 5057 | 4560 | 66 | 0 | 33.73325583 | -93.66935133 | 2022-04-24 04:20:56 | Hempstead, Arkansas, US | |
2022-04-22 | US | Arkansas | Hempstead | 5057 | 4560 | 66 | 0 | 33.73325583 | -93.66935133 | 2022-04-23 04:20:50 | Hempstead, Arkansas, US | |
2022-04-13 | US | California | Inyo | 6027 | 4560 | 56 | 0 | 36.51112084 | -117.41119779999998 | 2022-04-13 23:21:06 | Inyo, California, US | |
2022-04-12 | US | California | Inyo | 6027 | 4560 | 56 | 0 | 36.51112084 | -117.41119779999998 | 2022-04-13 04:21:03 | Inyo, California, US | |
2022-03-30 | US | Texas | Jones | 48253 | 4560 | 92 | 0 | 32.73997145 | -99.87861576 | 2022-03-31 04:20:56 | Jones, Texas, US | |
2022-03-08 | US | Puerto Rico | Cabo Rojo | 72023 | 4560 | 0 | 0 | 18.040993 | -67.154391 | 2022-03-09 04:20:59 | Cabo Rojo, Puerto Rico, US | |
2022-03-07 | US | Virginia | New Kent | 51127 | 4560 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-03-08 04:20:54 | New Kent, Virginia, US | |
2022-03-07 | US | Puerto Rico | Cabo Rojo | 72023 | 4560 | 0 | 0 | 18.040993 | -67.154391 | 2022-03-08 04:20:54 | Cabo Rojo, Puerto Rico, US | |
2022-03-02 | US | Virginia | New Kent | 51127 | 4560 | 32 | 0 | 37.50694406 | -76.99828634 | 2022-03-03 04:21:01 | New Kent, Virginia, US | |
2022-02-23 | US | Arkansas | Sharp | 5135 | 4560 | 96 | 0 | 36.16258158 | -91.47819342 | 2022-02-24 04:21:14 | Sharp, Arkansas, US | |
2022-02-21 | US | Illinois | Cass | 17017 | 4560 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-02-22 04:21:01 | Cass, Illinois, US | |
2022-02-20 | US | Illinois | Cass | 17017 | 4560 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-02-21 04:21:05 | Cass, Illinois, US | |
2022-02-19 | US | Illinois | Cass | 17017 | 4560 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-02-20 04:21:00 | Cass, Illinois, US | |
2022-02-18 | US | Illinois | Cass | 17017 | 4560 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-02-19 04:21:11 | Cass, Illinois, US | |
2022-02-16 | US | Wisconsin | Adams | 55001 | 4560 | 48 | 0 | 43.96974651 | -89.76782777 | 2022-02-17 04:20:56 | Adams, Wisconsin, US | |
2022-02-16 | US | Alabama | Fayette | 1057 | 4560 | 90 | 0 | 33.72076938 | -87.73886638 | 2022-02-17 04:20:56 | Fayette, Alabama, US | |
2022-02-15 | US | Missouri | Texas | 29215 | 4560 | 87 | 0 | 37.31728859 | -91.96564727 | 2022-02-16 04:21:10 | Texas, Missouri, US | |
2022-02-14 | US | Georgia | Worth | 13321 | 4560 | 105 | 0 | 31.55162306 | -83.85090513 | 2022-02-15 04:21:09 | Worth, Georgia, US | |
2022-02-10 | Japan | Tottori | 4560 | 5 | 0 | 35.359069 | 133.863619 | 2022-02-11 04:21:09 | Tottori, Japan | |||
2022-02-03 | US | Illinois | Clark | 17023 | 4560 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-04 04:21:10 | Clark, Illinois, US | |
2022-02-03 | US | Arkansas | Cross | 5037 | 4560 | 75 | 0 | 35.29631396 | -90.77185818 | 2022-02-04 04:21:10 | Cross, Arkansas, US | |
2022-02-02 | US | Illinois | Clark | 17023 | 4560 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-03 04:21:21 | Clark, Illinois, US | |
2022-01-30 | US | Indiana | Starke | 18149 | 4560 | 88 | 0 | 41.27890281 | -86.64686895 | 2022-01-31 04:21:09 | Starke, Indiana, US | |
2022-01-29 | US | Indiana | Starke | 18149 | 4560 | 88 | 0 | 41.27890281 | -86.64686895 | 2022-01-30 04:21:26 | Starke, Indiana, US | |
2022-01-28 | US | Indiana | Starke | 18149 | 4560 | 88 | 0 | 41.27890281 | -86.64686895 | 2022-01-29 04:21:10 | Starke, Indiana, US | |
2022-01-26 | US | Arkansas | Ashley | 5003 | 4560 | 56 | 0 | 33.19153461 | -91.76984709999999 | 2022-01-27 04:21:19 | Ashley, Arkansas, US | |
2022-01-23 | US | Mississippi | Stone | 28131 | 4560 | 67 | 0 | 30.79187949 | -89.11547539 | 2022-01-24 04:21:12 | Stone, Mississippi, US | |
2022-01-22 | US | Mississippi | Stone | 28131 | 4560 | 67 | 0 | 30.79187949 | -89.11547539 | 2022-01-23 04:21:13 | Stone, Mississippi, US | |
2022-01-21 | US | Pennsylvania | Wyoming | 42131 | 4560 | 94 | 0 | 41.51955538 | -76.01074915 | 2022-01-22 04:21:13 | Wyoming, Pennsylvania, US | |
2022-01-21 | US | Mississippi | Stone | 28131 | 4560 | 67 | 0 | 30.79187949 | -89.11547539 | 2022-01-22 04:21:13 | Stone, Mississippi, US | |
2022-01-19 | US | Wisconsin | Vilas | 55125 | 4560 | 83 | 0 | 46.05467334 | -89.51719204 | 2022-01-20 04:21:07 | Vilas, Wisconsin, US | |
2022-01-18 | US | Kentucky | Johnson | 21115 | 4560 | 82 | 0 | 37.85106355 | -82.8264322 | 2022-01-19 04:21:23 | Johnson, Kentucky, US | |
2021-12-10 | US | West Virginia | Upshur | 54097 | 4560 | 71 | 0 | 38.89285061 | -80.23689136 | 2021-12-11 04:22:45 | Upshur, West Virginia, US | |
2021-12-10 | Comoros | 4560 | 151 | 0 | -11.6455 | 43.3333 | 2021-12-11 04:22:45 | Comoros | ||||
2021-12-01 | US | Mississippi | Simpson | 28127 | 4560 | 117 | 0 | 31.91282117 | -89.91716179 | 2021-12-02 04:22:37 | Simpson, Mississippi, US | |
2021-11-22 | US | Indiana | Greene | 18055 | 4560 | 98 | 0 | 39.03630547 | -86.96223202 | 2021-11-23 04:22:39 | Greene, Indiana, US | |
2021-11-05 | US | New York | Greene | 36039 | 4560 | 87 | 0 | 42.275797 | -74.12384884 | 2021-11-06 04:21:51 | Greene, New York, US | |
2021-10-28 | US | Minnesota | Carlton | 27017 | 4560 | 66 | 0 | 46.59180601 | -92.67601019 | 2021-10-29 04:22:03 | Carlton, Minnesota, US | |
2021-10-28 | US | Kentucky | Carter | 21043 | 4560 | 59 | 0 | 38.31690743 | -83.05092385 | 2021-10-29 04:22:03 | Carter, Kentucky, US | |
2021-10-10 | US | Michigan | Huron | 26063 | 4560 | 88 | 0 | 43.83353985 | -83.04078453 | 2021-10-11 04:21:31 | Huron, Michigan, US | |
2021-10-09 | US | Michigan | Huron | 26063 | 4560 | 88 | 0 | 43.83353985 | -83.04078453 | 2021-10-10 04:21:38 | Huron, Michigan, US | |
2021-10-08 | US | Michigan | Huron | 26063 | 4560 | 88 | 0 | 43.83353985 | -83.04078453 | 2021-10-09 04:21:34 | Huron, Michigan, US | |
2021-10-06 | US | Georgia | Lee | 13177 | 4560 | 78 | 0 | 31.779330600000005 | -84.14324253 | 2021-10-07 04:21:36 | Lee, Georgia, US | |
2021-09-23 | US | Mississippi | Scott | 28123 | 4560 | 96 | 0 | 32.406704100000006 | -89.53789439 | 2021-09-24 04:21:44 | Scott, Mississippi, US | |
2021-09-20 | US | Illinois | Lee | 17103 | 4560 | 56 | 0 | 41.74583951 | -89.29977132 | 2021-09-21 04:21:26 | Lee, Illinois, US | |
2021-09-19 | US | Ohio | Guernsey | 39059 | 4560 | 66 | 0 | 40.05026529 | -81.49248905 | 2021-09-20 04:21:22 | Guernsey, Ohio, US | |
2021-09-01 | US | Pennsylvania | Wayne | 42127 | 4560 | 84 | 0 | 41.64938475 | -75.29956506 | 2021-09-02 04:21:15 | Wayne, Pennsylvania, US | |
2021-09-01 | US | Ohio | Clinton | 39027 | 4560 | 81 | 0 | 39.41485808 | -83.80852286 | 2021-09-02 04:21:15 | Clinton, Ohio, US | |
2021-08-24 | US | Iowa | Unassigned | 90019 | 4560 | 0 | 0 | 43.38107862 | 0.0 | 2021-08-25 04:21:41 | Unassigned, Iowa, US | |
2021-08-07 | US | Texas | Wharton | 48481 | 4560 | 122 | 0 | 29.27765923 | -96.22319248 | 2021-08-08 04:21:33 | Wharton, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;