daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
196 rows where confirmed = 3226 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-11-23 | US | Wisconsin | Forest | 55041 | 3226 | 53 | 0 | 45.66678019 | -88.77084892 | 2022-11-24 04:21:09 | Forest, Wisconsin, US | |
2022-11-23 | China | Jiangsu | 3226 | 0 | 0 | 32.9711 | 119.455 | 2022-11-24 04:21:09 | Jiangsu, China | |||
2022-11-21 | US | Wisconsin | Forest | 55041 | 3226 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-11-22 04:20:47 | Forest, Wisconsin, US | |
2022-11-16 | US | Wisconsin | Forest | 55041 | 3226 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-11-17 04:21:11 | Forest, Wisconsin, US | |
2022-10-05 | US | Virginia | Amelia | 51007 | 3226 | 61 | 0 | 37.34081025 | -77.98584649 | 2022-10-06 04:21:22 | Amelia, Virginia, US | |
2022-08-03 | US | Oklahoma | Johnston | 40069 | 3226 | 56 | 0 | 34.31440473 | -96.66011537 | 2022-08-04 04:20:58 | Johnston, Oklahoma, US | |
2022-08-02 | US | Oklahoma | Johnston | 40069 | 3226 | 56 | 0 | 34.31440473 | -96.66011537 | 2022-08-03 04:20:59 | Johnston, Oklahoma, US | |
2022-08-02 | China | Henan | 3226 | 22 | 0 | 33.882 | 113.614 | 2022-08-03 04:20:59 | Henan, China | |||
2022-08-01 | US | Oklahoma | Johnston | 40069 | 3226 | 56 | 0 | 34.31440473 | -96.66011537 | 2022-08-02 04:20:53 | Johnston, Oklahoma, US | |
2022-08-01 | China | Henan | 3226 | 22 | 0 | 33.882 | 113.614 | 2022-08-02 04:20:53 | Henan, China | |||
2022-07-31 | US | Oklahoma | Johnston | 40069 | 3226 | 56 | 0 | 34.31440473 | -96.66011537 | 2022-08-01 04:21:03 | Johnston, Oklahoma, US | |
2022-07-30 | US | Oklahoma | Johnston | 40069 | 3226 | 56 | 0 | 34.31440473 | -96.66011537 | 2022-07-31 04:21:02 | Johnston, Oklahoma, US | |
2022-07-29 | US | Oklahoma | Johnston | 40069 | 3226 | 56 | 0 | 34.31440473 | -96.66011537 | 2022-07-30 04:20:42 | Johnston, Oklahoma, US | |
2022-07-28 | US | Oklahoma | Johnston | 40069 | 3226 | 56 | 0 | 34.31440473 | -96.66011537 | 2022-07-29 04:20:45 | Johnston, Oklahoma, US | |
2022-07-15 | US | Arkansas | Desha | 5041 | 3226 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-07-16 04:21:05 | Desha, Arkansas, US | |
2022-07-14 | US | Puerto Rico | Rincon | 72117 | 3226 | 0 | 0 | 18.335443 | -67.23174 | 2022-07-15 04:20:53 | Rincon, Puerto Rico, US | |
2022-06-30 | US | Indiana | Blackford | 18009 | 3226 | 69 | 0 | 40.47388153 | -85.32499702 | 2022-07-01 04:21:10 | Blackford, Indiana, US | |
2022-06-29 | US | Indiana | Blackford | 18009 | 3226 | 69 | 0 | 40.47388153 | -85.32499702 | 2022-06-30 04:21:01 | Blackford, Indiana, US | |
2022-06-21 | US | Iowa | Madison | 19121 | 3226 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-06-22 04:20:54 | Madison, Iowa, US | |
2022-06-20 | US | Iowa | Madison | 19121 | 3226 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-06-21 04:20:56 | Madison, Iowa, US | |
2022-06-19 | US | Iowa | Madison | 19121 | 3226 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-06-20 04:21:01 | Madison, Iowa, US | |
2022-06-18 | US | Iowa | Madison | 19121 | 3226 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-06-19 04:20:51 | Madison, Iowa, US | |
2022-06-17 | US | Iowa | Madison | 19121 | 3226 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-06-18 04:21:10 | Madison, Iowa, US | |
2022-06-16 | US | Iowa | Madison | 19121 | 3226 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-06-17 04:20:56 | Madison, Iowa, US | |
2022-06-15 | US | Iowa | Madison | 19121 | 3226 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-06-16 04:20:55 | Madison, Iowa, US | |
2022-06-14 | US | Minnesota | Chippewa | 27023 | 3226 | 48 | 0 | 45.02343421 | -95.56403693 | 2022-06-15 04:20:54 | Chippewa, Minnesota, US | |
2022-06-01 | US | Puerto Rico | Ciales | 72039 | 3226 | 0 | 0 | 18.28885 | -66.516475 | 2022-06-02 05:20:39 | Ciales, Puerto Rico, US | |
2022-05-12 | US | Missouri | Osage | 29151 | 3226 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-05-13 04:20:51 | Osage, Missouri, US | |
2022-05-11 | US | Oregon | Baker | 41001 | 3226 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-05-12 04:20:54 | Baker, Oregon, US | |
2022-05-11 | US | Missouri | Osage | 29151 | 3226 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-05-12 04:20:54 | Osage, Missouri, US | |
2022-05-10 | US | Oregon | Baker | 41001 | 3226 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-05-11 04:20:48 | Baker, Oregon, US | |
2022-05-10 | US | Missouri | Osage | 29151 | 3226 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-05-11 04:20:48 | Osage, Missouri, US | |
2022-05-09 | US | Oregon | Baker | 41001 | 3226 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-05-10 04:20:50 | Baker, Oregon, US | |
2022-05-09 | US | Missouri | Osage | 29151 | 3226 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-05-10 04:20:50 | Osage, Missouri, US | |
2022-05-08 | US | Oregon | Baker | 41001 | 3226 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-05-09 04:20:54 | Baker, Oregon, US | |
2022-05-08 | US | Missouri | Osage | 29151 | 3226 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-05-09 04:20:54 | Osage, Missouri, US | |
2022-05-07 | US | Oregon | Baker | 41001 | 3226 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-05-08 04:20:49 | Baker, Oregon, US | |
2022-05-07 | US | Missouri | Osage | 29151 | 3226 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-05-08 04:20:49 | Osage, Missouri, US | |
2022-05-06 | US | Oregon | Baker | 41001 | 3226 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-05-07 04:21:09 | Baker, Oregon, US | |
2022-05-06 | US | Missouri | Osage | 29151 | 3226 | 46 | 0 | 38.46036182 | -91.8613635 | 2022-05-07 04:21:09 | Osage, Missouri, US | |
2022-04-06 | China | Shaanxi | 3226 | 3 | 0 | 35.1917 | 108.8701 | 2022-04-07 04:20:53 | Shaanxi, China | |||
2022-04-05 | China | Shaanxi | 3226 | 3 | 0 | 35.1917 | 108.8701 | 2022-04-06 04:20:49 | Shaanxi, China | |||
2022-04-02 | Peru | Unknown | 3226 | 197 | 0 | 2022-04-03 04:20:48 | Unknown, Peru | |||||
2022-03-30 | US | Georgia | Dade | 13083 | 3226 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-03-31 04:20:56 | Dade, Georgia, US | |
2022-03-20 | US | North Dakota | Mountrail | 38061 | 3226 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-03-21 04:20:50 | Mountrail, North Dakota, US | |
2022-03-19 | US | North Dakota | Mountrail | 38061 | 3226 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-03-20 04:20:45 | Mountrail, North Dakota, US | |
2022-03-18 | US | North Dakota | Mountrail | 38061 | 3226 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-03-19 04:20:47 | Mountrail, North Dakota, US | |
2022-03-17 | US | North Dakota | Mountrail | 38061 | 3226 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-03-18 04:20:55 | Mountrail, North Dakota, US | |
2022-03-12 | US | Puerto Rico | San German | 72125 | 3226 | 0 | 0 | 18.111484 | -67.03858100000001 | 2022-03-13 04:20:49 | San German, Puerto Rico, US | |
2022-03-02 | US | Arkansas | Little River | 5081 | 3226 | 87 | 0 | 33.70375665 | -94.23468591 | 2022-03-03 04:21:01 | Little River, Arkansas, US | |
2022-03-01 | US | Kansas | Nemaha | 20131 | 3226 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-03-02 04:21:07 | Nemaha, Kansas, US | |
2022-02-28 | US | Kansas | Nemaha | 20131 | 3226 | 60 | 0 | 39.78345387 | -96.01392079 | 2022-03-01 04:21:09 | Nemaha, Kansas, US | |
2022-02-24 | US | Wisconsin | Price | 55099 | 3226 | 29 | 0 | 45.68051754 | -90.36098879999999 | 2022-02-25 04:21:11 | Price, Wisconsin, US | |
2022-02-15 | US | Puerto Rico | Lares | 72081 | 3226 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-02-16 04:21:10 | Lares, Puerto Rico, US | |
2022-02-14 | US | Louisiana | Madison | 22065 | 3226 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-02-15 04:21:09 | Madison, Louisiana, US | |
2022-02-14 | US | Louisiana | Claiborne | 22027 | 3226 | 71 | 0 | 32.82308512 | -92.99526883 | 2022-02-15 04:21:09 | Claiborne, Louisiana, US | |
2022-02-13 | US | Tennessee | Stewart | 47161 | 3226 | 47 | 0 | 36.50235092 | -87.83920548 | 2022-02-14 04:20:51 | Stewart, Tennessee, US | |
2022-02-08 | US | Virginia | Southampton | 51175 | 3226 | 78 | 0 | 36.72231125 | -77.10642712 | 2022-02-09 04:21:04 | Southampton, Virginia, US | |
2022-01-27 | US | Wyoming | Goshen | 56015 | 3226 | 53 | 0 | 42.08798185 | -104.3534743 | 2022-01-28 04:21:09 | Goshen, Wyoming, US | |
2022-01-20 | US | Missouri | Ste. Genevieve | 29186 | 3226 | 35 | 0 | 37.89090059 | -90.1949941 | 2022-01-21 04:21:09 | Ste. Genevieve, Missouri, US | |
2022-01-20 | US | Kentucky | Casey | 21045 | 3226 | 64 | 0 | 37.32533118 | -84.92726209 | 2022-01-21 04:21:09 | Casey, Kentucky, US | |
2022-01-18 | US | Illinois | Greene | 17061 | 3226 | 41 | 0 | 39.35907414 | -90.388865 | 2022-01-19 04:21:23 | Greene, Illinois, US | |
2022-01-17 | US | Texas | Leon | 48289 | 3226 | 75 | 0 | 31.29872538 | -95.9936328 | 2022-01-18 04:21:04 | Leon, Texas, US | |
2022-01-13 | US | Minnesota | Unassigned | 90027 | 3226 | 140 | 0 | 48.77754106 | 0.0 | 2022-01-14 04:21:54 | Unassigned, Minnesota, US | |
2022-01-06 | US | Arkansas | Drew | 5043 | 3226 | 58 | 0 | 33.59035001 | -91.71777921 | 2022-01-07 04:22:09 | Drew, Arkansas, US | |
2022-01-05 | US | Kentucky | Morgan | 21175 | 3226 | 17 | 0 | 37.92465657 | -83.25558245 | 2022-01-06 04:22:09 | Morgan, Kentucky, US | |
2021-12-28 | US | Hawaii | Out of HI | 80015 | 3226 | 11 | 0 | 22.03935037 | 0.0 | 2021-12-29 03:21:43 | Out of HI, Hawaii, US | |
2021-12-21 | US | Illinois | Clay | 17025 | 3226 | 55 | 0 | 38.75388572 | -88.48914513 | 2021-12-22 04:21:54 | Clay, Illinois, US | |
2021-12-15 | US | Illinois | Edgar | 17045 | 3226 | 51 | 0 | 39.6809186 | -87.74759563 | 2021-12-16 04:22:11 | Edgar, Illinois, US | |
2021-12-15 | US | Alabama | Hale | 1065 | 3226 | 89 | 0 | 32.76039258 | -87.63284988 | 2021-12-16 04:22:11 | Hale, Alabama, US | |
2021-12-12 | US | Wyoming | Carbon | 56007 | 3226 | 45 | 0 | 41.69357844 | -106.9326084 | 2021-12-13 04:22:02 | Carbon, Wyoming, US | |
2021-12-11 | US | Wyoming | Carbon | 56007 | 3226 | 45 | 0 | 41.69357844 | -106.9326084 | 2021-12-12 04:22:12 | Carbon, Wyoming, US | |
2021-12-10 | US | Wyoming | Carbon | 56007 | 3226 | 45 | 0 | 41.69357844 | -106.9326084 | 2021-12-11 04:22:45 | Carbon, Wyoming, US | |
2021-12-10 | US | Alabama | Cherokee | 1019 | 3226 | 64 | 0 | 34.17805983 | -85.60638968 | 2021-12-11 04:22:45 | Cherokee, Alabama, US | |
2021-12-09 | US | Alabama | Henry | 1067 | 3226 | 66 | 0 | 31.51148016 | -85.24267944 | 2021-12-10 04:22:28 | Henry, Alabama, US | |
2021-11-23 | US | Tennessee | Unicoi | 47171 | 3226 | 65 | 0 | 36.10890856 | -82.43709629 | 2021-11-24 04:22:14 | Unicoi, Tennessee, US | |
2021-11-17 | US | Tennessee | Polk | 47139 | 3226 | 31 | 0 | 35.12245443 | -84.52075859 | 2021-11-18 04:21:33 | Polk, Tennessee, US | |
2021-11-15 | US | Arkansas | Phillips | 5107 | 3226 | 77 | 0 | 34.43268455 | -90.84800154 | 2021-11-16 04:21:10 | Phillips, Arkansas, US | |
2021-11-11 | US | Kentucky | Rockcastle | 21203 | 3226 | 33 | 0 | 37.36642393 | -84.31176452 | 2021-11-12 04:22:01 | Rockcastle, Kentucky, US | |
2021-11-10 | US | Kentucky | Rockcastle | 21203 | 3226 | 33 | 0 | 37.36642393 | -84.31176452 | 2021-11-11 04:21:45 | Rockcastle, Kentucky, US | |
2021-11-09 | US | Texas | Panola | 48365 | 3226 | 108 | 0 | 32.163959600000005 | -94.30552481 | 2021-11-10 04:21:38 | Panola, Texas, US | |
2021-11-09 | US | Colorado | Pitkin | 8097 | 3226 | 6 | 0 | 39.21720112 | -106.9310027 | 2021-11-10 04:21:38 | Pitkin, Colorado, US | |
2021-11-08 | US | Georgia | Ben Hill | 13017 | 3226 | 101 | 0 | 31.76095874 | -83.22145359 | 2021-11-09 04:21:36 | Ben Hill, Georgia, US | |
2021-11-07 | US | Georgia | Ben Hill | 13017 | 3226 | 101 | 0 | 31.76095874 | -83.22145359 | 2021-11-08 04:21:43 | Ben Hill, Georgia, US | |
2021-11-06 | US | Georgia | Ben Hill | 13017 | 3226 | 101 | 0 | 31.76095874 | -83.22145359 | 2021-11-07 04:21:53 | Ben Hill, Georgia, US | |
2021-11-05 | US | Kentucky | Simpson | 21213 | 3226 | 56 | 0 | 36.74058474 | -86.58047435 | 2021-11-06 04:21:51 | Simpson, Kentucky, US | |
2021-11-05 | US | Georgia | Ben Hill | 13017 | 3226 | 101 | 0 | 31.76095874 | -83.22145359 | 2021-11-06 04:21:51 | Ben Hill, Georgia, US | |
2021-11-01 | China | Guangdong | 3226 | 8 | 0 | 23.3417 | 113.4244 | 2021-11-02 04:22:03 | Guangdong, China | |||
2021-10-27 | US | Tennessee | Humphreys | 47085 | 3226 | 47 | 0 | 36.03958805 | -87.77992872 | 2021-10-28 04:22:08 | Humphreys, Tennessee, US | |
2021-10-25 | US | Texas | Deaf Smith | 48117 | 3226 | 75 | 0 | 34.96522957 | -102.6054267 | 2021-10-26 04:22:09 | Deaf Smith, Texas, US | |
2021-10-24 | US | Texas | Deaf Smith | 48117 | 3226 | 75 | 0 | 34.96522957 | -102.6054267 | 2021-10-25 04:22:31 | Deaf Smith, Texas, US | |
2021-10-23 | US | Texas | Deaf Smith | 48117 | 3226 | 75 | 0 | 34.96522957 | -102.6054267 | 2021-10-24 04:21:22 | Deaf Smith, Texas, US | |
2021-10-17 | US | Missouri | Henry | 29083 | 3226 | 49 | 0 | 38.38482826 | -93.79293734 | 2021-10-18 04:21:10 | Henry, Missouri, US | |
2021-10-17 | US | Minnesota | Waseca | 27161 | 3226 | 29 | 0 | 44.02211116 | -93.58720034 | 2021-10-18 04:21:10 | Waseca, Minnesota, US | |
2021-10-16 | US | Minnesota | Waseca | 27161 | 3226 | 29 | 0 | 44.02211116 | -93.58720034 | 2021-10-17 04:21:29 | Waseca, Minnesota, US | |
2021-10-15 | US | Minnesota | Waseca | 27161 | 3226 | 29 | 0 | 44.02211116 | -93.58720034 | 2021-10-16 04:21:15 | Waseca, Minnesota, US | |
2021-10-09 | US | Alabama | Randolph | 1111 | 3226 | 60 | 0 | 33.29526734 | -85.45708831 | 2021-10-10 04:21:38 | Randolph, Alabama, US | |
2021-09-30 | US | Ohio | Hocking | 39073 | 3226 | 78 | 0 | 39.49537927 | -82.47991446 | 2021-10-01 04:21:35 | Hocking, Ohio, US | |
2021-09-21 | US | Ohio | Henry | 39069 | 3226 | 70 | 0 | 41.333964200000004 | -84.06830637 | 2021-09-22 04:21:45 | Henry, Ohio, US | |
2021-09-20 | US | Minnesota | Todd | 27153 | 3226 | 34 | 0 | 46.06996226 | -94.89785296 | 2021-09-21 04:21:26 | Todd, Minnesota, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;