daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
278 rows where confirmed = 3200 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-29 | US | Louisiana | West Feliciana | 22125 | 3200 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-30 04:21:04 | West Feliciana, Louisiana, US | |
2022-12-28 | US | Louisiana | West Feliciana | 22125 | 3200 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-12-29 04:21:01 | West Feliciana, Louisiana, US | |
2022-11-03 | US | Wisconsin | Forest | 55041 | 3200 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-11-04 04:22:11 | Forest, Wisconsin, US | |
2022-10-04 | US | Virginia | Clarke | 51043 | 3200 | 54 | 0 | 39.11271747 | -77.99199425 | 2022-10-05 04:23:06 | Clarke, Virginia, US | |
2022-09-20 | US | North Carolina | Perquimans | 37143 | 3200 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-09-21 04:23:22 | Perquimans, North Carolina, US | |
2022-09-19 | US | North Carolina | Perquimans | 37143 | 3200 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-09-20 04:22:48 | Perquimans, North Carolina, US | |
2022-09-18 | US | North Carolina | Perquimans | 37143 | 3200 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-09-19 04:21:49 | Perquimans, North Carolina, US | |
2022-09-17 | US | North Carolina | Perquimans | 37143 | 3200 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-09-18 04:22:50 | Perquimans, North Carolina, US | |
2022-09-16 | US | North Carolina | Perquimans | 37143 | 3200 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-09-17 04:20:19 | Perquimans, North Carolina, US | |
2022-09-15 | US | North Carolina | Perquimans | 37143 | 3200 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-09-16 04:21:19 | Perquimans, North Carolina, US | |
2022-09-14 | US | North Carolina | Perquimans | 37143 | 3200 | 25 | 0 | 36.17847453 | -76.40603143 | 2022-09-15 04:21:02 | Perquimans, North Carolina, US | |
2022-09-06 | China | Heilongjiang | 3200 | 13 | 0 | 47.862 | 127.7615 | 2022-09-07 04:20:59 | Heilongjiang, China | |||
2022-08-31 | US | Texas | Pecos | 48371 | 3200 | 71 | 0 | 30.78097267 | -102.7241261 | 2022-09-01 04:21:03 | Pecos, Texas, US | |
2022-08-10 | US | Minnesota | Koochiching | 27071 | 3200 | 39 | 0 | 48.24539665 | -93.78352843 | 2022-08-11 04:20:49 | Koochiching, Minnesota, US | |
2022-08-09 | US | Minnesota | Koochiching | 27071 | 3200 | 39 | 0 | 48.24539665 | -93.78352843 | 2022-08-10 04:20:57 | Koochiching, Minnesota, US | |
2022-08-08 | US | Minnesota | Koochiching | 27071 | 3200 | 39 | 0 | 48.24539665 | -93.78352843 | 2022-08-09 04:20:34 | Koochiching, Minnesota, US | |
2022-08-07 | US | Minnesota | Koochiching | 27071 | 3200 | 39 | 0 | 48.24539665 | -93.78352843 | 2022-08-08 04:21:08 | Koochiching, Minnesota, US | |
2022-08-06 | US | Minnesota | Koochiching | 27071 | 3200 | 39 | 0 | 48.24539665 | -93.78352843 | 2022-08-07 04:20:54 | Koochiching, Minnesota, US | |
2022-08-06 | US | Colorado | Archuleta | 8007 | 3200 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-08-07 04:20:54 | Archuleta, Colorado, US | |
2022-08-05 | US | Minnesota | Koochiching | 27071 | 3200 | 39 | 0 | 48.24539665 | -93.78352843 | 2022-08-06 04:20:56 | Koochiching, Minnesota, US | |
2022-08-04 | US | Minnesota | Koochiching | 27071 | 3200 | 39 | 0 | 48.24539665 | -93.78352843 | 2022-08-05 04:20:52 | Koochiching, Minnesota, US | |
2022-07-24 | US | Alabama | Coosa | 1037 | 3200 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-25 04:20:51 | Coosa, Alabama, US | |
2022-07-23 | US | Alabama | Coosa | 1037 | 3200 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-24 04:20:47 | Coosa, Alabama, US | |
2022-07-22 | US | Alabama | Coosa | 1037 | 3200 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-23 04:20:53 | Coosa, Alabama, US | |
2022-07-16 | China | Henan | 3200 | 22 | 0 | 33.882 | 113.614 | 2022-07-17 04:21:15 | Henan, China | |||
2022-07-15 | China | Henan | 3200 | 22 | 0 | 33.882 | 113.614 | 2022-07-16 04:21:05 | Henan, China | |||
2022-06-30 | US | Florida | Franklin | 12037 | 3200 | 53 | 0 | 29.83791238 | -84.82731662 | 2022-07-01 04:21:10 | Franklin, Florida, US | |
2022-06-29 | US | Florida | Franklin | 12037 | 3200 | 53 | 0 | 29.83791238 | -84.82731662 | 2022-06-30 04:21:01 | Franklin, Florida, US | |
2022-06-28 | US | Florida | Franklin | 12037 | 3200 | 53 | 0 | 29.83791238 | -84.82731662 | 2022-06-29 04:20:59 | Franklin, Florida, US | |
2022-06-27 | US | Florida | Franklin | 12037 | 3200 | 53 | 0 | 29.83791238 | -84.82731662 | 2022-06-28 04:20:58 | Franklin, Florida, US | |
2022-06-26 | US | Florida | Franklin | 12037 | 3200 | 53 | 0 | 29.83791238 | -84.82731662 | 2022-06-27 04:21:00 | Franklin, Florida, US | |
2022-06-25 | US | Florida | Franklin | 12037 | 3200 | 53 | 0 | 29.83791238 | -84.82731662 | 2022-06-26 04:21:02 | Franklin, Florida, US | |
2022-06-24 | US | Florida | Franklin | 12037 | 3200 | 52 | 0 | 29.83791238 | -84.82731662 | 2022-06-25 04:20:57 | Franklin, Florida, US | |
2022-06-23 | US | Florida | Franklin | 12037 | 3200 | 52 | 0 | 29.83791238 | -84.82731662 | 2022-06-24 04:20:58 | Franklin, Florida, US | |
2022-06-22 | US | Florida | Franklin | 12037 | 3200 | 52 | 0 | 29.83791238 | -84.82731662 | 2022-06-23 04:20:55 | Franklin, Florida, US | |
2022-06-21 | US | Florida | Franklin | 12037 | 3200 | 52 | 0 | 29.83791238 | -84.82731662 | 2022-06-22 04:20:54 | Franklin, Florida, US | |
2022-06-20 | US | Florida | Franklin | 12037 | 3200 | 52 | 0 | 29.83791238 | -84.82731662 | 2022-06-21 04:20:56 | Franklin, Florida, US | |
2022-06-19 | US | Florida | Franklin | 12037 | 3200 | 52 | 0 | 29.83791238 | -84.82731662 | 2022-06-20 04:21:01 | Franklin, Florida, US | |
2022-06-18 | US | Florida | Franklin | 12037 | 3200 | 52 | 0 | 29.83791238 | -84.82731662 | 2022-06-19 04:20:51 | Franklin, Florida, US | |
2022-06-17 | US | Florida | Franklin | 12037 | 3200 | 52 | 0 | 29.83791238 | -84.82731662 | 2022-06-18 04:21:10 | Franklin, Florida, US | |
2022-06-05 | US | California | Mono | 6051 | 3200 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-06-06 04:20:57 | Mono, California, US | |
2022-06-04 | US | California | Mono | 6051 | 3200 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-06-05 04:20:55 | Mono, California, US | |
2022-06-03 | US | California | Mono | 6051 | 3200 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-06-04 04:20:58 | Mono, California, US | |
2022-06-02 | US | California | Mono | 6051 | 3200 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-06-03 04:20:58 | Mono, California, US | |
2022-06-01 | US | Puerto Rico | Luquillo | 72089 | 3200 | 0 | 0 | 18.342114 | -65.725097 | 2022-06-02 05:20:39 | Luquillo, Puerto Rico, US | |
2022-05-31 | US | Iowa | Madison | 19121 | 3200 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-06-01 04:20:55 | Madison, Iowa, US | |
2022-05-30 | US | Iowa | Madison | 19121 | 3200 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-05-31 04:20:51 | Madison, Iowa, US | |
2022-05-29 | US | Iowa | Madison | 19121 | 3200 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-05-30 04:20:50 | Madison, Iowa, US | |
2022-05-28 | US | Iowa | Madison | 19121 | 3200 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-05-29 04:20:53 | Madison, Iowa, US | |
2022-05-27 | US | Iowa | Madison | 19121 | 3200 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-05-28 04:21:07 | Madison, Iowa, US | |
2022-05-26 | US | Puerto Rico | Adjuntas | 72001 | 3200 | 0 | 0 | 18.180117 | -66.754367 | 2022-05-27 04:20:56 | Adjuntas, Puerto Rico, US | |
2022-05-26 | US | Iowa | Madison | 19121 | 3200 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-05-27 04:20:56 | Madison, Iowa, US | |
2022-05-25 | US | Iowa | Madison | 19121 | 3200 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-05-26 04:20:50 | Madison, Iowa, US | |
2022-05-22 | US | Iowa | Madison | 19121 | 3200 | 40 | 0 | 41.33081904 | -94.01554631 | 2022-05-26 04:20:50 | Madison, Iowa, US | |
2022-05-15 | US | Puerto Rico | Santa Isabel | 72133 | 3200 | 0 | 0 | 17.994525 | -66.388913 | 2022-05-16 04:20:47 | Santa Isabel, Puerto Rico, US | |
2022-05-12 | US | Puerto Rico | Orocovis | 72107 | 3200 | 0 | 0 | 18.215046 | -66.433604 | 2022-05-13 04:20:51 | Orocovis, Puerto Rico, US | |
2022-05-12 | US | New Jersey | Unassigned | 90034 | 3200 | 0 | 0 | 41.13891592 | 0.0 | 2022-05-13 04:20:51 | Unassigned, New Jersey, US | |
2022-04-26 | US | Michigan | Arenac | 26011 | 3200 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-27 04:20:52 | Arenac, Michigan, US | |
2022-04-25 | US | Michigan | Arenac | 26011 | 3200 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-26 04:20:51 | Arenac, Michigan, US | |
2022-04-24 | US | Michigan | Arenac | 26011 | 3200 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-25 04:20:56 | Arenac, Michigan, US | |
2022-04-23 | US | Michigan | Arenac | 26011 | 3200 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-24 04:20:56 | Arenac, Michigan, US | |
2022-04-22 | US | Michigan | Arenac | 26011 | 3200 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-23 04:20:50 | Arenac, Michigan, US | |
2022-04-21 | US | Michigan | Arenac | 26011 | 3200 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-22 04:20:45 | Arenac, Michigan, US | |
2022-04-20 | US | Michigan | Arenac | 26011 | 3200 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-21 04:20:46 | Arenac, Michigan, US | |
2022-04-15 | US | Pennsylvania | Potter | 42105 | 3200 | 92 | 0 | 41.74471626 | -77.89559864 | 2022-04-16 04:20:48 | Potter, Pennsylvania, US | |
2022-03-28 | US | Georgia | Oglethorpe | 13221 | 3200 | 53 | 0 | 33.878629600000004 | -83.08278123 | 2022-03-29 04:20:46 | Oglethorpe, Georgia, US | |
2022-03-27 | US | Georgia | Oglethorpe | 13221 | 3200 | 53 | 0 | 33.878629600000004 | -83.08278123 | 2022-03-28 04:20:33 | Oglethorpe, Georgia, US | |
2022-03-26 | US | Georgia | Oglethorpe | 13221 | 3200 | 53 | 0 | 33.878629600000004 | -83.08278123 | 2022-03-27 04:20:47 | Oglethorpe, Georgia, US | |
2022-03-25 | US | Georgia | Oglethorpe | 13221 | 3200 | 53 | 0 | 33.878629600000004 | -83.08278123 | 2022-03-26 04:20:23 | Oglethorpe, Georgia, US | |
2022-03-22 | US | Iowa | Butler | 19023 | 3200 | 52 | 0 | 42.73172833 | -92.79015971 | 2022-03-23 04:20:48 | Butler, Iowa, US | |
2022-03-21 | US | Iowa | Butler | 19023 | 3200 | 52 | 0 | 42.73172833 | -92.79015971 | 2022-03-22 04:20:54 | Butler, Iowa, US | |
2022-03-20 | US | Iowa | Butler | 19023 | 3200 | 52 | 0 | 42.73172833 | -92.79015971 | 2022-03-21 04:20:50 | Butler, Iowa, US | |
2022-03-19 | US | Iowa | Butler | 19023 | 3200 | 52 | 0 | 42.73172833 | -92.79015971 | 2022-03-20 04:20:45 | Butler, Iowa, US | |
2022-03-18 | US | Iowa | Butler | 19023 | 3200 | 52 | 0 | 42.73172833 | -92.79015971 | 2022-03-19 04:20:47 | Butler, Iowa, US | |
2022-03-17 | US | Iowa | Butler | 19023 | 3200 | 52 | 0 | 42.73172833 | -92.79015971 | 2022-03-18 04:20:55 | Butler, Iowa, US | |
2022-03-16 | US | Iowa | Butler | 19023 | 3200 | 52 | 0 | 42.73172833 | -92.79015971 | 2022-03-17 04:20:56 | Butler, Iowa, US | |
2022-03-15 | US | Minnesota | Cottonwood | 27033 | 3200 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-03-16 04:20:50 | Cottonwood, Minnesota, US | |
2022-03-13 | US | Oregon | Baker | 41001 | 3200 | 46 | 0 | 44.70915557 | -117.6749883 | 2022-03-14 04:20:46 | Baker, Oregon, US | |
2022-03-12 | US | Oregon | Baker | 41001 | 3200 | 46 | 0 | 44.70915557 | -117.6749883 | 2022-03-13 04:20:49 | Baker, Oregon, US | |
2022-03-11 | US | Oregon | Baker | 41001 | 3200 | 46 | 0 | 44.70915557 | -117.6749883 | 2022-03-12 04:20:50 | Baker, Oregon, US | |
2022-03-10 | US | Oregon | Baker | 41001 | 3200 | 46 | 0 | 44.70915557 | -117.6749883 | 2022-03-11 04:20:50 | Baker, Oregon, US | |
2022-03-10 | Canada | Nunavut | 3200 | 5 | 0 | 70.2998 | -83.1076 | 2022-03-11 04:20:50 | Nunavut, Canada | |||
2022-03-09 | Canada | Nunavut | 3200 | 5 | 0 | 70.2998 | -83.1076 | 2022-03-10 04:20:48 | Nunavut, Canada | |||
2022-03-08 | US | Missouri | Osage | 29151 | 3200 | 42 | 0 | 38.46036182 | -91.8613635 | 2022-03-09 04:20:59 | Osage, Missouri, US | |
2022-03-01 | US | Virginia | Rockbridge | 51163 | 3200 | 75 | 0 | 37.81204314 | -79.44605905 | 2022-03-02 04:21:07 | Rockbridge, Virginia, US | |
2022-02-28 | US | Virginia | Rockbridge | 51163 | 3200 | 75 | 0 | 37.81204314 | -79.44605905 | 2022-03-01 04:21:09 | Rockbridge, Virginia, US | |
2022-02-27 | US | Tennessee | Jackson | 47087 | 3200 | 58 | 0 | 36.36380466 | -85.67239905 | 2022-02-28 04:21:05 | Jackson, Tennessee, US | |
2022-02-26 | US | Tennessee | Jackson | 47087 | 3200 | 58 | 0 | 36.36380466 | -85.67239905 | 2022-02-27 04:21:04 | Jackson, Tennessee, US | |
2022-02-25 | US | Puerto Rico | San German | 72125 | 3200 | 0 | 0 | 18.111484 | -67.03858100000001 | 2022-02-26 04:21:12 | San German, Puerto Rico, US | |
2022-02-24 | US | Montana | Roosevelt | 30085 | 3200 | 70 | 0 | 48.29607488 | -105.00792679999999 | 2022-02-25 04:21:11 | Roosevelt, Montana, US | |
2022-02-21 | US | Vermont | Lamoille | 50015 | 3200 | 15 | 0 | 44.60353043 | -72.64356694 | 2022-02-22 04:21:01 | Lamoille, Vermont, US | |
2022-02-21 | US | North Dakota | McKenzie | 38053 | 3200 | 25 | 0 | 47.74133370000001 | -103.395905 | 2022-02-22 04:21:01 | McKenzie, North Dakota, US | |
2022-02-20 | US | Vermont | Lamoille | 50015 | 3200 | 15 | 0 | 44.60353043 | -72.64356694 | 2022-02-21 04:21:05 | Lamoille, Vermont, US | |
2022-02-19 | US | Vermont | Lamoille | 50015 | 3200 | 15 | 0 | 44.60353043 | -72.64356694 | 2022-02-20 04:21:00 | Lamoille, Vermont, US | |
2022-02-18 | US | Vermont | Lamoille | 50015 | 3200 | 15 | 0 | 44.60353043 | -72.64356694 | 2022-02-19 04:21:11 | Lamoille, Vermont, US | |
2022-02-13 | US | Kentucky | Breathitt | 21025 | 3200 | 50 | 0 | 37.52333168 | -83.31959161 | 2022-02-14 04:20:51 | Breathitt, Kentucky, US | |
2022-02-12 | US | Kentucky | Breathitt | 21025 | 3200 | 50 | 0 | 37.52333168 | -83.31959161 | 2022-02-13 04:21:00 | Breathitt, Kentucky, US | |
2022-02-11 | US | Kentucky | Breathitt | 21025 | 3200 | 50 | 0 | 37.52333168 | -83.31959161 | 2022-02-12 04:21:06 | Breathitt, Kentucky, US | |
2022-02-01 | US | Virginia | Patrick | 51141 | 3200 | 75 | 0 | 36.680163799999995 | -80.2865648 | 2022-02-02 04:21:09 | Patrick, Virginia, US | |
2022-01-27 | US | Texas | Tyler | 48457 | 3200 | 75 | 0 | 30.77031716 | -94.37690895 | 2022-01-28 04:21:09 | Tyler, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;