daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
206 rows where confirmed = 3737 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-07 | US | Georgia | Bleckley | 13023 | 3737 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-12-08 04:21:07 | Bleckley, Georgia, US | |
2022-12-06 | US | Oregon | Baker | 41001 | 3737 | 63 | 0 | 44.70915557 | -117.6749883 | 2022-12-07 04:20:58 | Baker, Oregon, US | |
2022-12-06 | US | Georgia | Bleckley | 13023 | 3737 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-12-07 04:20:58 | Bleckley, Georgia, US | |
2022-12-05 | US | Oregon | Baker | 41001 | 3737 | 63 | 0 | 44.70915557 | -117.6749883 | 2022-12-06 04:21:03 | Baker, Oregon, US | |
2022-12-05 | US | Georgia | Bleckley | 13023 | 3737 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-12-06 04:21:03 | Bleckley, Georgia, US | |
2022-12-04 | US | Oregon | Baker | 41001 | 3737 | 63 | 0 | 44.70915557 | -117.6749883 | 2022-12-05 04:20:58 | Baker, Oregon, US | |
2022-12-04 | US | Georgia | Bleckley | 13023 | 3737 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-12-05 04:20:58 | Bleckley, Georgia, US | |
2022-12-03 | US | Oregon | Baker | 41001 | 3737 | 63 | 0 | 44.70915557 | -117.6749883 | 2022-12-04 04:20:56 | Baker, Oregon, US | |
2022-12-03 | US | Georgia | Bleckley | 13023 | 3737 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-12-04 04:20:56 | Bleckley, Georgia, US | |
2022-12-02 | US | Oregon | Baker | 41001 | 3737 | 63 | 0 | 44.70915557 | -117.6749883 | 2022-12-03 04:21:02 | Baker, Oregon, US | |
2022-12-02 | US | Georgia | Bleckley | 13023 | 3737 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-12-03 04:21:02 | Bleckley, Georgia, US | |
2022-12-01 | US | Oregon | Baker | 41001 | 3737 | 63 | 0 | 44.70915557 | -117.6749883 | 2022-12-02 04:21:07 | Baker, Oregon, US | |
2022-12-01 | US | Georgia | Bleckley | 13023 | 3737 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-12-02 04:21:07 | Bleckley, Georgia, US | |
2022-11-30 | US | Oregon | Baker | 41001 | 3737 | 63 | 0 | 44.70915557 | -117.6749883 | 2022-12-01 04:21:03 | Baker, Oregon, US | |
2022-11-30 | US | Georgia | Bleckley | 13023 | 3737 | 107 | 0 | 32.43829035 | -83.33035166 | 2022-12-01 04:21:03 | Bleckley, Georgia, US | |
2022-11-29 | US | Pennsylvania | Potter | 42105 | 3737 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-11-30 04:21:07 | Potter, Pennsylvania, US | |
2022-11-28 | US | Pennsylvania | Potter | 42105 | 3737 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-11-29 04:21:05 | Potter, Pennsylvania, US | |
2022-11-27 | US | Tennessee | Jackson | 47087 | 3737 | 66 | 0 | 36.36380466 | -85.67239905 | 2022-11-28 04:21:02 | Jackson, Tennessee, US | |
2022-11-27 | US | Pennsylvania | Potter | 42105 | 3737 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-11-28 04:21:02 | Potter, Pennsylvania, US | |
2022-11-26 | US | Pennsylvania | Potter | 42105 | 3737 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-11-27 04:21:05 | Potter, Pennsylvania, US | |
2022-11-25 | US | Pennsylvania | Potter | 42105 | 3737 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-11-26 04:21:11 | Potter, Pennsylvania, US | |
2022-11-24 | US | Pennsylvania | Potter | 42105 | 3737 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-11-25 04:21:06 | Potter, Pennsylvania, US | |
2022-11-23 | US | Pennsylvania | Potter | 42105 | 3737 | 99 | 0 | 41.74471626 | -77.89559864 | 2022-11-24 04:21:09 | Potter, Pennsylvania, US | |
2022-10-27 | US | Maryland | Kent | 24029 | 3737 | 73 | 0 | 39.24976208 | -76.04741541 | 2022-10-28 04:22:31 | Kent, Maryland, US | |
2022-10-25 | US | Idaho | Gooding | 16047 | 3737 | 60 | 0 | 42.96927962 | -114.8108306 | 2022-10-26 04:22:19 | Gooding, Idaho, US | |
2022-10-24 | US | Idaho | Gooding | 16047 | 3737 | 60 | 0 | 42.96927962 | -114.8108306 | 2022-10-25 04:21:53 | Gooding, Idaho, US | |
2022-10-23 | US | Idaho | Gooding | 16047 | 3737 | 60 | 0 | 42.96927962 | -114.8108306 | 2022-10-24 04:22:29 | Gooding, Idaho, US | |
2022-10-22 | US | Idaho | Gooding | 16047 | 3737 | 60 | 0 | 42.96927962 | -114.8108306 | 2022-10-23 04:22:46 | Gooding, Idaho, US | |
2022-10-21 | US | Idaho | Gooding | 16047 | 3737 | 60 | 0 | 42.96927962 | -114.8108306 | 2022-10-22 04:22:53 | Gooding, Idaho, US | |
2022-10-20 | US | Idaho | Gooding | 16047 | 3737 | 60 | 0 | 42.96927962 | -114.8108306 | 2022-10-21 04:22:23 | Gooding, Idaho, US | |
2022-10-19 | US | Idaho | Gooding | 16047 | 3737 | 60 | 0 | 42.96927962 | -114.8108306 | 2022-10-20 04:22:59 | Gooding, Idaho, US | |
2022-10-04 | US | South Dakota | Clay | 46027 | 3737 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-10-05 04:23:06 | Clay, South Dakota, US | |
2022-10-03 | US | South Dakota | Clay | 46027 | 3737 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-10-04 04:22:55 | Clay, South Dakota, US | |
2022-10-02 | US | South Dakota | Clay | 46027 | 3737 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-10-03 04:23:11 | Clay, South Dakota, US | |
2022-10-01 | US | South Dakota | Clay | 46027 | 3737 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-10-02 04:21:23 | Clay, South Dakota, US | |
2022-09-30 | US | South Dakota | Clay | 46027 | 3737 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-10-01 04:23:01 | Clay, South Dakota, US | |
2022-09-29 | US | South Dakota | Clay | 46027 | 3737 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-30 04:23:09 | Clay, South Dakota, US | |
2022-09-28 | US | South Dakota | Clay | 46027 | 3737 | 24 | 0 | 42.91296147 | -96.97656917 | 2022-09-29 04:22:34 | Clay, South Dakota, US | |
2022-09-12 | US | Wisconsin | Price | 55099 | 3737 | 35 | 0 | 45.68051754 | -90.3609888 | 2022-09-13 04:20:57 | Price, Wisconsin, US | |
2022-07-31 | US | Wisconsin | Ashland | 55003 | 3737 | 39 | 0 | 46.31956891 | -90.67837132 | 2022-08-01 04:21:03 | Ashland, Wisconsin, US | |
2022-07-30 | US | Wisconsin | Ashland | 55003 | 3737 | 39 | 0 | 46.31956891 | -90.67837132 | 2022-07-31 04:21:02 | Ashland, Wisconsin, US | |
2022-07-30 | US | Tennessee | Lewis | 47101 | 3737 | 63 | 0 | 35.52853208 | -87.49022694 | 2022-07-31 04:21:02 | Lewis, Tennessee, US | |
2022-07-29 | US | Wisconsin | Ashland | 55003 | 3737 | 39 | 0 | 46.31956891 | -90.67837132 | 2022-07-30 04:20:42 | Ashland, Wisconsin, US | |
2022-06-29 | US | Wisconsin | Bayfield | 55007 | 3737 | 42 | 0 | 46.52868768 | -91.19716729 | 2022-06-30 04:21:01 | Bayfield, Wisconsin, US | |
2022-06-21 | US | North Carolina | Mitchell | 37121 | 3737 | 40 | 0 | 36.01059309 | -82.1582442 | 2022-06-22 04:20:54 | Mitchell, North Carolina, US | |
2022-06-20 | US | North Carolina | Mitchell | 37121 | 3737 | 40 | 0 | 36.01059309 | -82.1582442 | 2022-06-21 04:20:56 | Mitchell, North Carolina, US | |
2022-06-19 | US | North Carolina | Mitchell | 37121 | 3737 | 40 | 0 | 36.01059309 | -82.1582442 | 2022-06-20 04:21:01 | Mitchell, North Carolina, US | |
2022-06-18 | US | North Carolina | Mitchell | 37121 | 3737 | 40 | 0 | 36.01059309 | -82.1582442 | 2022-06-19 04:20:51 | Mitchell, North Carolina, US | |
2022-06-17 | US | North Carolina | Mitchell | 37121 | 3737 | 40 | 0 | 36.01059309 | -82.1582442 | 2022-06-18 04:21:10 | Mitchell, North Carolina, US | |
2022-06-16 | US | North Carolina | Mitchell | 37121 | 3737 | 40 | 0 | 36.01059309 | -82.1582442 | 2022-06-17 04:20:56 | Mitchell, North Carolina, US | |
2022-06-15 | US | North Carolina | Mitchell | 37121 | 3737 | 40 | 0 | 36.01059309 | -82.1582442 | 2022-06-16 04:20:55 | Mitchell, North Carolina, US | |
2022-06-12 | US | Colorado | Las Animas | 8071 | 3737 | 44 | 0 | 37.3153406 | -104.0376458 | 2022-06-13 04:21:14 | Las Animas, Colorado, US | |
2022-06-12 | US | Colorado | Grand | 8049 | 3737 | 28 | 0 | 40.10603347 | -106.1178042 | 2022-06-13 04:21:14 | Grand, Colorado, US | |
2022-05-31 | US | Texas | Leon | 48289 | 3737 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-06-01 04:20:55 | Leon, Texas, US | |
2022-05-30 | US | Texas | Leon | 48289 | 3737 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-05-31 04:20:51 | Leon, Texas, US | |
2022-05-29 | US | Texas | Leon | 48289 | 3737 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-05-30 04:20:50 | Leon, Texas, US | |
2022-05-28 | US | Texas | Leon | 48289 | 3737 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-05-29 04:20:53 | Leon, Texas, US | |
2022-05-27 | US | Texas | Leon | 48289 | 3737 | 93 | 0 | 31.29872538 | -95.9936328 | 2022-05-28 04:21:07 | Leon, Texas, US | |
2022-05-19 | US | Illinois | Wabash | 17185 | 3737 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-05-20 04:20:57 | Wabash, Illinois, US | |
2022-05-18 | US | Illinois | Wabash | 17185 | 3737 | 28 | 0 | 38.44272901 | -87.84922065 | 2022-05-19 04:20:54 | Wabash, Illinois, US | |
2022-05-17 | US | Alabama | Washington | 1129 | 3737 | 59 | 0 | 31.4092794 | -88.20689944 | 2022-05-18 04:20:50 | Washington, Alabama, US | |
2022-05-15 | US | New York | Schuyler | 36097 | 3737 | 25 | 0 | 42.39184015 | -76.8773299 | 2022-05-16 04:20:47 | Schuyler, New York, US | |
2022-05-10 | US | Alabama | Lamar | 1075 | 3737 | 65 | 0 | 33.77995024 | -88.09668032 | 2022-05-11 04:20:48 | Lamar, Alabama, US | |
2022-04-02 | US | Puerto Rico | Aguas Buenas | 72007 | 3737 | 0 | 0 | 18.251619 | -66.126806 | 2022-04-03 04:20:48 | Aguas Buenas, Puerto Rico, US | |
2022-03-29 | US | Tennessee | Decatur | 47039 | 3737 | 67 | 0 | 35.60048904 | -88.11043779 | 2022-03-30 04:20:45 | Decatur, Tennessee, US | |
2022-03-28 | US | Tennessee | Decatur | 47039 | 3737 | 67 | 0 | 35.60048904 | -88.11043779 | 2022-03-29 04:20:46 | Decatur, Tennessee, US | |
2022-03-22 | US | Puerto Rico | Catano | 72033 | 3737 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-03-23 04:20:48 | Catano, Puerto Rico, US | |
2022-03-21 | US | Puerto Rico | Catano | 72033 | 3737 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-03-22 04:20:54 | Catano, Puerto Rico, US | |
2022-03-20 | US | Puerto Rico | Catano | 72033 | 3737 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-03-21 04:20:50 | Catano, Puerto Rico, US | |
2022-03-19 | US | Puerto Rico | Catano | 72033 | 3737 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-03-20 04:20:45 | Catano, Puerto Rico, US | |
2022-03-18 | US | Puerto Rico | Yauco | 72153 | 3737 | 0 | 0 | 18.080374 | -66.858814 | 2022-03-19 04:20:47 | Yauco, Puerto Rico, US | |
2022-03-17 | US | Puerto Rico | Catano | 72033 | 3737 | 0 | 0 | 18.437269 | -66.14330600000001 | 2022-03-18 04:20:55 | Catano, Puerto Rico, US | |
2022-03-10 | US | Texas | Falls | 48145 | 3737 | 63 | 0 | 31.25350609 | -96.93630086 | 2022-03-11 04:20:50 | Falls, Texas, US | |
2022-03-07 | US | Arkansas | Howard | 5061 | 3737 | 48 | 0 | 34.09007427 | -93.9934871 | 2022-03-08 04:20:54 | Howard, Arkansas, US | |
2022-02-17 | US | Illinois | Wabash | 17185 | 3737 | 24 | 0 | 38.44272901 | -87.84922065 | 2022-02-18 04:21:04 | Wabash, Illinois, US | |
2022-02-16 | US | Missouri | Dallas | 29059 | 3737 | 67 | 0 | 37.681135499999996 | -93.02127031 | 2022-02-17 04:20:56 | Dallas, Missouri, US | |
2022-02-15 | US | Kentucky | Washington | 21229 | 3737 | 54 | 0 | 37.75599461 | -85.17407732 | 2022-02-16 04:21:10 | Washington, Kentucky, US | |
2022-02-08 | US | Minnesota | Redwood | 27127 | 3737 | 52 | 0 | 44.40555844 | -95.25207021 | 2022-02-09 04:21:04 | Redwood, Minnesota, US | |
2022-01-29 | China | Shanghai | 3737 | 7 | 0 | 31.201999999999998 | 121.4491 | 2022-01-30 04:21:26 | Shanghai, China | |||
2022-01-27 | China | Guangdong | 3737 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-28 04:21:09 | Guangdong, China | |||
2022-01-26 | US | Puerto Rico | Fajardo | 72053 | 3737 | 0 | 0 | 18.318373 | -65.666866 | 2022-01-27 04:21:19 | Fajardo, Puerto Rico, US | |
2022-01-24 | US | Texas | Lee | 48287 | 3737 | 55 | 0 | 30.31120597 | -96.97045773 | 2022-01-25 04:21:05 | Lee, Texas, US | |
2022-01-19 | US | Illinois | White | 17193 | 3737 | 35 | 0 | 38.08706198 | -88.17657461 | 2022-01-20 04:21:07 | White, Illinois, US | |
2022-01-12 | US | Colorado | Otero | 8089 | 3737 | 121 | 0 | 37.9014485 | -103.7173385 | 2022-01-13 08:00:09 | Otero, Colorado, US | |
2022-01-09 | US | Missouri | Andrew | 29003 | 3737 | 42 | 0 | 39.98492163 | -94.80163024 | 2022-01-10 04:22:07 | Andrew, Missouri, US | |
2022-01-01 | US | Tennessee | Union | 47173 | 3737 | 62 | 0 | 36.28590426 | -83.83651902 | 2022-01-02 04:20:52 | Union, Tennessee, US | |
2021-12-29 | US | Georgia | McDuffie | 13189 | 3737 | 79 | 0 | 33.47851918 | -82.48252774 | 2021-12-30 04:21:25 | McDuffie, Georgia, US | |
2021-12-27 | US | Indiana | Sullivan | 18153 | 3737 | 56 | 0 | 39.08952258 | -87.41414469 | 2021-12-28 04:21:47 | Sullivan, Indiana, US | |
2021-12-26 | US | Kentucky | Bourbon | 21017 | 3737 | 42 | 0 | 38.2054607 | -84.21827874 | 2021-12-27 04:21:58 | Bourbon, Kentucky, US | |
2021-12-25 | US | Kentucky | Bourbon | 21017 | 3737 | 42 | 0 | 38.2054607 | -84.21827874 | 2021-12-26 04:21:50 | Bourbon, Kentucky, US | |
2021-12-24 | US | Kentucky | Bourbon | 21017 | 3737 | 42 | 0 | 38.2054607 | -84.21827874 | 2021-12-25 04:21:37 | Bourbon, Kentucky, US | |
2021-12-23 | US | Kentucky | Bourbon | 21017 | 3737 | 42 | 0 | 38.2054607 | -84.21827874 | 2021-12-24 04:21:34 | Bourbon, Kentucky, US | |
2021-12-22 | US | Kentucky | Bourbon | 21017 | 3737 | 42 | 0 | 38.2054607 | -84.21827874 | 2021-12-23 04:21:21 | Bourbon, Kentucky, US | |
2021-12-22 | Sao Tome and Principe | 3737 | 57 | 0 | 0.1864 | 6.6131 | 2021-12-23 04:21:21 | Sao Tome and Principe | ||||
2021-12-21 | US | Minnesota | Hubbard | 27057 | 3737 | 51 | 0 | 47.10778564 | -94.91693868 | 2021-12-22 04:21:54 | Hubbard, Minnesota, US | |
2021-12-16 | US | Indiana | Owen | 18119 | 3737 | 79 | 0 | 39.31145587 | -86.83900724 | 2021-12-17 04:22:14 | Owen, Indiana, US | |
2021-12-12 | US | Indiana | Fulton | 18049 | 3737 | 75 | 0 | 41.0469907 | -86.26252745 | 2021-12-13 04:22:02 | Fulton, Indiana, US | |
2021-12-11 | US | Maryland | Caroline | 24011 | 3737 | 54 | 0 | 38.87172293 | -75.82904158 | 2021-12-12 04:22:12 | Caroline, Maryland, US | |
2021-12-11 | US | Indiana | Fulton | 18049 | 3737 | 75 | 0 | 41.0469907 | -86.26252745 | 2021-12-12 04:22:12 | Fulton, Indiana, US | |
2021-12-10 | US | Indiana | Fulton | 18049 | 3737 | 75 | 0 | 41.0469907 | -86.26252745 | 2021-12-11 04:22:45 | Fulton, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;