daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
252 rows where confirmed = 3106 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-20 | US | Iowa | Chickasaw | 19037 | 3106 | 36 | 0 | 43.06001295 | -92.31773347 | 2022-12-21 04:21:03 | Chickasaw, Iowa, US | |
2022-12-20 | US | Georgia | Stewart | 13259 | 3106 | 36 | 0 | 32.07996777 | -84.83208037 | 2022-12-21 04:21:03 | Stewart, Georgia, US | |
2022-12-19 | US | Missouri | Ripley | 29181 | 3106 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-20 04:21:04 | Ripley, Missouri, US | |
2022-12-19 | US | Iowa | Chickasaw | 19037 | 3106 | 36 | 0 | 43.06001295 | -92.31773347 | 2022-12-20 04:21:04 | Chickasaw, Iowa, US | |
2022-12-19 | US | Georgia | Stewart | 13259 | 3106 | 36 | 0 | 32.07996777 | -84.83208037 | 2022-12-20 04:21:04 | Stewart, Georgia, US | |
2022-12-18 | US | Missouri | Ripley | 29181 | 3106 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-19 04:21:03 | Ripley, Missouri, US | |
2022-12-18 | US | Iowa | Chickasaw | 19037 | 3106 | 36 | 0 | 43.06001295 | -92.31773347 | 2022-12-19 04:21:03 | Chickasaw, Iowa, US | |
2022-12-18 | US | Georgia | Stewart | 13259 | 3106 | 36 | 0 | 32.07996777 | -84.83208037 | 2022-12-19 04:21:03 | Stewart, Georgia, US | |
2022-12-17 | US | Missouri | Ripley | 29181 | 3106 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-18 04:21:03 | Ripley, Missouri, US | |
2022-12-17 | US | Iowa | Chickasaw | 19037 | 3106 | 36 | 0 | 43.06001295 | -92.31773347 | 2022-12-18 04:21:03 | Chickasaw, Iowa, US | |
2022-12-17 | US | Georgia | Stewart | 13259 | 3106 | 36 | 0 | 32.07996777 | -84.83208037 | 2022-12-18 04:21:03 | Stewart, Georgia, US | |
2022-12-16 | US | Missouri | Ripley | 29181 | 3106 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-17 04:21:04 | Ripley, Missouri, US | |
2022-12-16 | US | Iowa | Chickasaw | 19037 | 3106 | 36 | 0 | 43.06001295 | -92.31773347 | 2022-12-17 04:21:04 | Chickasaw, Iowa, US | |
2022-12-16 | US | Georgia | Stewart | 13259 | 3106 | 36 | 0 | 32.07996777 | -84.83208037 | 2022-12-17 04:21:04 | Stewart, Georgia, US | |
2022-12-15 | US | Missouri | Ripley | 29181 | 3106 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-16 04:21:01 | Ripley, Missouri, US | |
2022-12-15 | US | Iowa | Chickasaw | 19037 | 3106 | 36 | 0 | 43.06001295 | -92.31773347 | 2022-12-16 04:21:01 | Chickasaw, Iowa, US | |
2022-12-15 | US | Georgia | Stewart | 13259 | 3106 | 36 | 0 | 32.07996777 | -84.83208037 | 2022-12-16 04:21:01 | Stewart, Georgia, US | |
2022-12-14 | US | Missouri | Ripley | 29181 | 3106 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-15 04:20:58 | Ripley, Missouri, US | |
2022-12-14 | US | Iowa | Chickasaw | 19037 | 3106 | 36 | 0 | 43.06001295 | -92.31773347 | 2022-12-15 04:20:58 | Chickasaw, Iowa, US | |
2022-12-14 | US | Georgia | Stewart | 13259 | 3106 | 36 | 0 | 32.07996777 | -84.83208037 | 2022-12-15 04:20:58 | Stewart, Georgia, US | |
2022-12-13 | US | Missouri | Ripley | 29181 | 3106 | 67 | 0 | 36.65460667 | -90.85990261 | 2022-12-14 04:21:04 | Ripley, Missouri, US | |
2022-11-22 | US | Louisiana | West Feliciana | 22125 | 3106 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-11-23 04:21:06 | West Feliciana, Louisiana, US | |
2022-11-21 | US | Louisiana | West Feliciana | 22125 | 3106 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-11-22 04:20:47 | West Feliciana, Louisiana, US | |
2022-11-20 | US | Louisiana | West Feliciana | 22125 | 3106 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-11-21 04:21:05 | West Feliciana, Louisiana, US | |
2022-11-19 | US | Louisiana | West Feliciana | 22125 | 3106 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-11-20 04:21:08 | West Feliciana, Louisiana, US | |
2022-11-18 | US | Louisiana | West Feliciana | 22125 | 3106 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-11-19 04:21:14 | West Feliciana, Louisiana, US | |
2022-11-17 | US | Louisiana | West Feliciana | 22125 | 3106 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-11-18 04:21:15 | West Feliciana, Louisiana, US | |
2022-11-16 | US | Louisiana | West Feliciana | 22125 | 3106 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-11-17 04:21:11 | West Feliciana, Louisiana, US | |
2022-11-13 | US | Texas | Trinity | 48455 | 3106 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-11-14 04:21:09 | Trinity, Texas, US | |
2022-11-12 | US | Texas | Trinity | 48455 | 3106 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-11-13 04:21:14 | Trinity, Texas, US | |
2022-11-11 | US | Texas | Trinity | 48455 | 3106 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-11-12 04:20:41 | Trinity, Texas, US | |
2022-11-10 | US | Texas | Trinity | 48455 | 3106 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-11-11 04:21:22 | Trinity, Texas, US | |
2022-11-09 | US | Texas | Trinity | 48455 | 3106 | 75 | 0 | 31.0879489 | -95.1367187 | 2022-11-10 04:21:16 | Trinity, Texas, US | |
2022-10-18 | US | Iowa | Allamakee | 19005 | 3106 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-19 04:22:26 | Allamakee, Iowa, US | |
2022-10-17 | US | Iowa | Allamakee | 19005 | 3106 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-18 04:22:42 | Allamakee, Iowa, US | |
2022-10-16 | US | Iowa | Allamakee | 19005 | 3106 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-17 04:20:31 | Allamakee, Iowa, US | |
2022-10-15 | US | Iowa | Allamakee | 19005 | 3106 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-16 04:22:39 | Allamakee, Iowa, US | |
2022-10-14 | US | Iowa | Allamakee | 19005 | 3106 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-15 04:22:00 | Allamakee, Iowa, US | |
2022-10-13 | US | Iowa | Allamakee | 19005 | 3106 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-14 04:22:28 | Allamakee, Iowa, US | |
2022-10-12 | US | Iowa | Allamakee | 19005 | 3106 | 62 | 0 | 43.28383218 | -91.37860922 | 2022-10-13 04:22:39 | Allamakee, Iowa, US | |
2022-10-11 | US | North Carolina | Clay | 37043 | 3106 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-10-12 04:22:51 | Clay, North Carolina, US | |
2022-10-10 | US | North Carolina | Clay | 37043 | 3106 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-10-11 04:23:05 | Clay, North Carolina, US | |
2022-10-09 | US | North Carolina | Clay | 37043 | 3106 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-10-10 04:22:32 | Clay, North Carolina, US | |
2022-10-08 | US | North Carolina | Clay | 37043 | 3106 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-10-09 04:21:16 | Clay, North Carolina, US | |
2022-10-07 | US | North Carolina | Clay | 37043 | 3106 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-10-08 04:22:56 | Clay, North Carolina, US | |
2022-10-06 | US | North Carolina | Clay | 37043 | 3106 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-10-07 04:23:08 | Clay, North Carolina, US | |
2022-10-05 | US | North Carolina | Clay | 37043 | 3106 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-10-06 04:21:22 | Clay, North Carolina, US | |
2022-09-30 | China | Shandong | 3106 | 7 | 0 | 36.3427 | 118.1498 | 2022-10-01 04:23:01 | Shandong, China | |||
2022-09-22 | US | Missouri | Lewis | 29111 | 3106 | 43 | 0 | 40.09673161 | -91.72070156 | 2022-09-23 04:23:13 | Lewis, Missouri, US | |
2022-09-21 | US | Missouri | Lewis | 29111 | 3106 | 43 | 0 | 40.09673161 | -91.72070156 | 2022-09-22 04:22:56 | Lewis, Missouri, US | |
2022-09-20 | US | Missouri | Lewis | 29111 | 3106 | 43 | 0 | 40.09673161 | -91.72070156 | 2022-09-21 04:23:22 | Lewis, Missouri, US | |
2022-09-19 | US | Missouri | Lewis | 29111 | 3106 | 43 | 0 | 40.09673161 | -91.72070156 | 2022-09-20 04:22:48 | Lewis, Missouri, US | |
2022-09-18 | US | Virginia | Falls Church | 51610 | 3106 | 18 | 0 | 38.88485255 | -77.17560759 | 2022-09-19 04:21:49 | Falls Church, Virginia, US | |
2022-09-18 | US | Missouri | Lewis | 29111 | 3106 | 43 | 0 | 40.09673161 | -91.72070156 | 2022-09-19 04:21:49 | Lewis, Missouri, US | |
2022-09-17 | US | Virginia | Falls Church | 51610 | 3106 | 18 | 0 | 38.88485255 | -77.17560759 | 2022-09-18 04:22:50 | Falls Church, Virginia, US | |
2022-09-17 | US | Missouri | Lewis | 29111 | 3106 | 43 | 0 | 40.09673161 | -91.72070156 | 2022-09-18 04:22:50 | Lewis, Missouri, US | |
2022-09-16 | US | Virginia | Falls Church | 51610 | 3106 | 18 | 0 | 38.88485255 | -77.17560759 | 2022-09-17 04:20:19 | Falls Church, Virginia, US | |
2022-09-16 | US | Missouri | Lewis | 29111 | 3106 | 43 | 0 | 40.09673161 | -91.72070156 | 2022-09-17 04:20:19 | Lewis, Missouri, US | |
2022-08-25 | US | Virginia | Amelia | 51007 | 3106 | 58 | 0 | 37.34081025 | -77.98584649 | 2022-08-26 04:21:02 | Amelia, Virginia, US | |
2022-08-15 | US | New Jersey | Unassigned | 90034 | 3106 | 0 | 0 | 41.13891592 | 0.0 | 2022-08-16 04:20:58 | Unassigned, New Jersey, US | |
2022-07-27 | US | Illinois | Marshall | 17123 | 3106 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-07-28 04:20:56 | Marshall, Illinois, US | |
2022-07-10 | US | Alabama | Coosa | 1037 | 3106 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-11 04:20:46 | Coosa, Alabama, US | |
2022-07-09 | US | Alabama | Coosa | 1037 | 3106 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-10 04:20:54 | Coosa, Alabama, US | |
2022-07-08 | US | Colorado | Archuleta | 8007 | 3106 | 16 | 0 | 37.19474156 | -107.0476867 | 2022-07-09 04:20:59 | Archuleta, Colorado, US | |
2022-07-08 | US | Alabama | Coosa | 1037 | 3106 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-09 04:20:59 | Coosa, Alabama, US | |
2022-07-05 | US | Arkansas | Bradley | 5011 | 3106 | 52 | 0 | 33.46755808 | -92.15980837 | 2022-07-06 04:20:58 | Bradley, Arkansas, US | |
2022-07-04 | US | Arkansas | Bradley | 5011 | 3106 | 52 | 0 | 33.46755808 | -92.15980837 | 2022-07-05 04:20:45 | Bradley, Arkansas, US | |
2022-05-16 | US | Colorado | Moffat | 8081 | 3106 | 52 | 0 | 40.61810999 | -108.2070876 | 2022-05-17 04:20:59 | Moffat, Colorado, US | |
2022-05-11 | US | Puerto Rico | Lajas | 72079 | 3106 | 0 | 0 | 18.011661 | -67.040585 | 2022-05-12 04:20:54 | Lajas, Puerto Rico, US | |
2022-04-12 | US | Indiana | Blackford | 18009 | 3106 | 69 | 0 | 40.47388153 | -85.32499702 | 2022-04-13 04:21:03 | Blackford, Indiana, US | |
2022-04-11 | US | Indiana | Blackford | 18009 | 3106 | 69 | 0 | 40.47388153 | -85.32499702 | 2022-04-12 04:20:49 | Blackford, Indiana, US | |
2022-04-01 | US | Puerto Rico | Utuado | 72141 | 3106 | 0 | 0 | 18.271214 | -66.702984 | 2022-04-02 04:20:47 | Utuado, Puerto Rico, US | |
2022-03-20 | US | Indiana | Blackford | 18009 | 3106 | 65 | 0 | 40.47388153 | -85.32499702 | 2022-03-21 04:20:50 | Blackford, Indiana, US | |
2022-03-19 | US | Indiana | Blackford | 18009 | 3106 | 65 | 0 | 40.47388153 | -85.32499702 | 2022-03-20 04:20:45 | Blackford, Indiana, US | |
2022-03-18 | US | Indiana | Blackford | 18009 | 3106 | 65 | 0 | 40.47388153 | -85.32499702 | 2022-03-19 04:20:47 | Blackford, Indiana, US | |
2022-03-17 | US | Indiana | Blackford | 18009 | 3106 | 65 | 0 | 40.47388153 | -85.32499702 | 2022-03-18 04:20:55 | Blackford, Indiana, US | |
2022-03-16 | US | Puerto Rico | Naguabo | 72103 | 3106 | 0 | 0 | 18.230636999999998 | -65.753897 | 2022-03-17 04:20:56 | Naguabo, Puerto Rico, US | |
2022-03-16 | US | Indiana | Blackford | 18009 | 3106 | 65 | 0 | 40.47388153 | -85.32499702 | 2022-03-17 04:20:56 | Blackford, Indiana, US | |
2022-03-15 | US | Puerto Rico | Naguabo | 72103 | 3106 | 0 | 0 | 18.230636999999998 | -65.753897 | 2022-03-16 04:20:50 | Naguabo, Puerto Rico, US | |
2022-03-14 | US | Puerto Rico | Naguabo | 72103 | 3106 | 0 | 0 | 18.230636999999998 | -65.753897 | 2022-03-15 04:20:47 | Naguabo, Puerto Rico, US | |
2022-03-13 | US | Puerto Rico | Naguabo | 72103 | 3106 | 0 | 0 | 18.230636999999998 | -65.753897 | 2022-03-14 04:20:46 | Naguabo, Puerto Rico, US | |
2022-03-01 | US | West Virginia | Roane | 54087 | 3106 | 36 | 0 | 38.71622686 | -81.35243568 | 2022-03-02 04:21:07 | Roane, West Virginia, US | |
2022-02-17 | US | Virginia | Martinsville | 51690 | 3106 | 108 | 0 | 36.68212094 | -79.86352771 | 2022-02-18 04:21:04 | Martinsville, Virginia, US | |
2022-02-15 | US | Wyoming | Converse | 56009 | 3106 | 52 | 0 | 42.97272268 | -105.5081848 | 2022-02-16 04:21:10 | Converse, Wyoming, US | |
2022-02-06 | US | Arkansas | Little River | 5081 | 3106 | 85 | 0 | 33.70375665 | -94.23468591 | 2022-02-07 04:21:05 | Little River, Arkansas, US | |
2022-02-03 | US | Virginia | Westmoreland | 51193 | 3106 | 41 | 0 | 38.11021557 | -76.80213247 | 2022-02-04 04:21:10 | Westmoreland, Virginia, US | |
2022-01-31 | US | Arkansas | Marion | 5089 | 3106 | 76 | 0 | 36.26844485 | -92.68451899 | 2022-02-01 04:21:11 | Marion, Arkansas, US | |
2022-01-31 | Canada | Yukon | 3106 | 16 | 0 | 64.2823 | -135.0 | 2022-02-01 04:21:11 | Yukon, Canada | |||
2022-01-23 | US | North Dakota | Ramsey | 38071 | 3106 | 47 | 0 | 48.26886249 | -98.72223879 | 2022-01-24 04:21:12 | Ramsey, North Dakota, US | |
2022-01-20 | US | Virginia | Appomattox | 51011 | 3106 | 41 | 0 | 37.37569884 | -78.81340003 | 2022-01-21 04:21:09 | Appomattox, Virginia, US | |
2022-01-18 | US | Texas | Wilbarger | 48487 | 3106 | 77 | 0 | 34.07945812 | -99.24178437 | 2022-01-19 04:21:23 | Wilbarger, Texas, US | |
2022-01-16 | US | West Virginia | Braxton | 54007 | 3106 | 32 | 0 | 38.70036159 | -80.72011184 | 2022-01-17 04:21:08 | Braxton, West Virginia, US | |
2022-01-06 | US | Tennessee | Cannon | 47015 | 3106 | 50 | 0 | 35.80990797 | -86.05738983 | 2022-01-07 04:22:09 | Cannon, Tennessee, US | |
2022-01-04 | US | Texas | Houston | 48225 | 3106 | 90 | 0 | 31.31925973 | -95.42226208 | 2022-01-05 04:21:59 | Houston, Texas, US | |
2022-01-03 | US | Kentucky | Jackson | 21109 | 3106 | 59 | 0 | 37.41866422 | -83.99825483 | 2022-01-04 04:22:17 | Jackson, Kentucky, US | |
2022-01-03 | US | Arkansas | Polk | 5113 | 3106 | 129 | 0 | 34.48254879 | -94.22728802 | 2022-01-04 04:22:17 | Polk, Arkansas, US | |
2022-01-02 | US | Arkansas | Polk | 5113 | 3106 | 129 | 0 | 34.48254879 | -94.22728802 | 2022-01-03 02:22:25 | Polk, Arkansas, US | |
2022-01-01 | US | Puerto Rico | Isabela | 72071 | 3106 | 0 | 0 | 18.44981 | -67.005093 | 2022-01-02 04:20:52 | Isabela, Puerto Rico, US | |
2022-01-01 | US | Puerto Rico | Aguada | 72003 | 3106 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-01-02 04:20:52 | Aguada, Puerto Rico, US | |
2021-12-31 | US | Puerto Rico | Isabela | 72071 | 3106 | 0 | 0 | 18.44981 | -67.005093 | 2022-01-01 04:22:14 | Isabela, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;