daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
230 rows where confirmed = 2774 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 212
- Saint Kitts and Nevis 3
- China 2
- Germany 2
- United Kingdom 2
- Brazil 1
- Canada 1
- Colombia 1
- Italy 1
- Japan 1
- Liechtenstein 1
- Spain 1
- Sweden 1
- Ukraine 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Mississippi | Choctaw | 28019 | 2774 | 36 | 0 | 33.34598242 | -89.24809382 | 2022-12-30 04:21:04 | Choctaw, Mississippi, US | |
2022-12-29 | US | Georgia | McIntosh | 13191 | 2774 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-30 04:21:04 | McIntosh, Georgia, US | |
2022-12-28 | US | Mississippi | Choctaw | 28019 | 2774 | 36 | 0 | 33.34598242 | -89.24809382 | 2022-12-29 04:21:01 | Choctaw, Mississippi, US | |
2022-12-28 | US | Georgia | McIntosh | 13191 | 2774 | 39 | 0 | 31.49683595 | -81.40163426 | 2022-12-29 04:21:01 | McIntosh, Georgia, US | |
2022-12-27 | US | Mississippi | Choctaw | 28019 | 2774 | 36 | 0 | 33.34598242 | -89.24809382 | 2022-12-28 04:21:04 | Choctaw, Mississippi, US | |
2022-12-19 | US | Arkansas | Scott | 5127 | 2774 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-20 04:21:04 | Scott, Arkansas, US | |
2022-12-18 | US | Arkansas | Scott | 5127 | 2774 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-19 04:21:03 | Scott, Arkansas, US | |
2022-12-17 | US | Arkansas | Scott | 5127 | 2774 | 48 | 0 | 34.85588887 | -94.0632176 | 2022-12-18 04:21:03 | Scott, Arkansas, US | |
2022-11-15 | US | Iowa | Sac | 19161 | 2774 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-11-16 04:21:09 | Sac, Iowa, US | |
2022-11-14 | US | Iowa | Sac | 19161 | 2774 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-11-15 04:21:16 | Sac, Iowa, US | |
2022-11-13 | US | Iowa | Sac | 19161 | 2774 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-11-14 04:21:09 | Sac, Iowa, US | |
2022-11-12 | US | Iowa | Sac | 19161 | 2774 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-11-13 04:21:14 | Sac, Iowa, US | |
2022-11-11 | US | Iowa | Sac | 19161 | 2774 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-11-12 04:20:41 | Sac, Iowa, US | |
2022-11-10 | US | Iowa | Sac | 19161 | 2774 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-11-11 04:21:22 | Sac, Iowa, US | |
2022-11-09 | US | Iowa | Sac | 19161 | 2774 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-11-10 04:21:16 | Sac, Iowa, US | |
2022-09-22 | US | Washington | Pend Oreille | 53051 | 2774 | 39 | 0 | 48.53234021 | -117.2741804 | 2022-09-23 04:23:13 | Pend Oreille, Washington, US | |
2022-09-21 | US | Washington | Pend Oreille | 53051 | 2774 | 39 | 0 | 48.53234021 | -117.2741804 | 2022-09-22 04:22:56 | Pend Oreille, Washington, US | |
2022-09-20 | US | Washington | Pend Oreille | 53051 | 2774 | 39 | 0 | 48.53234021 | -117.2741804 | 2022-09-21 04:23:22 | Pend Oreille, Washington, US | |
2022-09-19 | US | Washington | Pend Oreille | 53051 | 2774 | 39 | 0 | 48.53234021 | -117.2741804 | 2022-09-20 04:22:48 | Pend Oreille, Washington, US | |
2022-09-19 | US | Virginia | Richmond | 51159 | 2774 | 27 | 0 | 37.937575 | -76.72920628 | 2022-09-20 04:22:48 | Richmond, Virginia, US | |
2022-08-24 | US | North Dakota | Mercer | 38057 | 2774 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-08-25 04:21:13 | Mercer, North Dakota, US | |
2022-08-18 | US | Arkansas | Perry | 5105 | 2774 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-08-19 04:20:54 | Perry, Arkansas, US | |
2022-08-16 | US | Connecticut | Unassigned | 90009 | 2774 | 1 | 0 | 41.85853803 | 0.0 | 2022-08-17 04:20:59 | Unassigned, Connecticut, US | |
2022-08-14 | US | Indiana | Crawford | 18025 | 2774 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-08-15 04:20:59 | Crawford, Indiana, US | |
2022-08-13 | US | Indiana | Crawford | 18025 | 2774 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-08-14 04:20:55 | Crawford, Indiana, US | |
2022-08-12 | US | Indiana | Crawford | 18025 | 2774 | 41 | 0 | 38.28814402 | -86.44518825 | 2022-08-13 04:20:52 | Crawford, Indiana, US | |
2022-08-03 | US | Louisiana | East Carroll | 22035 | 2774 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-08-04 04:20:58 | East Carroll, Louisiana, US | |
2022-07-16 | US | Colorado | Prowers | 8099 | 2774 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-07-17 04:21:15 | Prowers, Colorado, US | |
2022-07-15 | US | Texas | Blanco | 48031 | 2774 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-07-16 04:21:05 | Blanco, Texas, US | |
2022-06-29 | US | Texas | Trinity | 48455 | 2774 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-06-30 04:21:01 | Trinity, Texas, US | |
2022-06-28 | US | Idaho | Valley | 16085 | 2774 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-29 04:20:59 | Valley, Idaho, US | |
2022-06-27 | US | Idaho | Valley | 16085 | 2774 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-06-28 04:20:58 | Valley, Idaho, US | |
2022-06-21 | US | Kansas | Brown | 20013 | 2774 | 49 | 0 | 39.82652589 | -95.56421698 | 2022-06-22 04:20:54 | Brown, Kansas, US | |
2022-06-20 | US | Kansas | Brown | 20013 | 2774 | 49 | 0 | 39.82652589 | -95.56421698 | 2022-06-21 04:20:56 | Brown, Kansas, US | |
2022-06-19 | US | Kansas | Brown | 20013 | 2774 | 49 | 0 | 39.82652589 | -95.56421698 | 2022-06-20 04:21:01 | Brown, Kansas, US | |
2022-06-18 | US | Kansas | Brown | 20013 | 2774 | 49 | 0 | 39.82652589 | -95.56421698 | 2022-06-19 04:20:51 | Brown, Kansas, US | |
2022-06-17 | US | Kansas | Brown | 20013 | 2774 | 49 | 0 | 39.82652589 | -95.56421698 | 2022-06-18 04:21:10 | Brown, Kansas, US | |
2022-06-16 | US | Kansas | Brown | 20013 | 2774 | 49 | 0 | 39.82652589 | -95.56421698 | 2022-06-17 04:20:56 | Brown, Kansas, US | |
2022-06-15 | US | Kansas | Brown | 20013 | 2774 | 49 | 0 | 39.82652589 | -95.56421698 | 2022-06-16 04:20:55 | Brown, Kansas, US | |
2022-06-14 | US | Texas | Jim Hogg | 48247 | 2774 | 22 | 0 | 27.04453923 | -98.6968187 | 2022-06-15 04:20:54 | Jim Hogg, Texas, US | |
2022-06-12 | US | Wisconsin | Forest | 55041 | 2774 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-06-13 04:21:14 | Forest, Wisconsin, US | |
2022-06-12 | US | Tennessee | Lake | 47095 | 2774 | 43 | 0 | 36.3418017 | -89.48921915 | 2022-06-13 04:21:14 | Lake, Tennessee, US | |
2022-06-11 | US | Wisconsin | Forest | 55041 | 2774 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-06-12 04:20:53 | Forest, Wisconsin, US | |
2022-06-11 | US | Texas | Pecos | 48371 | 2774 | 71 | 0 | 30.78097267 | -102.7241261 | 2022-06-12 04:20:53 | Pecos, Texas, US | |
2022-06-10 | US | Wisconsin | Forest | 55041 | 2774 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-06-11 04:21:01 | Forest, Wisconsin, US | |
2022-04-29 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-30 04:21:05 | Chicot, Arkansas, US | |
2022-04-28 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-29 04:20:59 | Chicot, Arkansas, US | |
2022-04-27 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-28 04:20:47 | Chicot, Arkansas, US | |
2022-04-26 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-27 04:20:52 | Chicot, Arkansas, US | |
2022-04-25 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-26 04:20:51 | Chicot, Arkansas, US | |
2022-04-24 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-25 04:20:56 | Chicot, Arkansas, US | |
2022-04-23 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-24 04:20:56 | Chicot, Arkansas, US | |
2022-04-22 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-23 04:20:50 | Chicot, Arkansas, US | |
2022-04-21 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-22 04:20:45 | Chicot, Arkansas, US | |
2022-04-20 | US | New Mexico | Los Alamos | 35028 | 2774 | 16 | 0 | 35.86631386 | -106.31349850000001 | 2022-04-21 04:20:46 | Los Alamos, New Mexico, US | |
2022-04-20 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-21 04:20:46 | Chicot, Arkansas, US | |
2022-04-19 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-20 04:20:45 | Chicot, Arkansas, US | |
2022-04-18 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-19 04:21:00 | Chicot, Arkansas, US | |
2022-04-17 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-18 04:21:12 | Chicot, Arkansas, US | |
2022-04-16 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-17 04:20:59 | Chicot, Arkansas, US | |
2022-04-15 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-16 04:20:48 | Chicot, Arkansas, US | |
2022-04-14 | US | Arkansas | Chicot | 5017 | 2774 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-15 04:20:57 | Chicot, Arkansas, US | |
2022-04-12 | US | Georgia | Long | 13183 | 2774 | 34 | 0 | 31.75218791 | -81.74952375 | 2022-04-13 04:21:03 | Long, Georgia, US | |
2022-04-11 | US | Georgia | Long | 13183 | 2774 | 34 | 0 | 31.75218791 | -81.74952375 | 2022-04-12 04:20:49 | Long, Georgia, US | |
2022-02-21 | US | Missouri | Barton | 29011 | 2774 | 48 | 0 | 37.50207671 | -94.34757022 | 2022-02-22 04:21:01 | Barton, Missouri, US | |
2022-02-20 | US | Missouri | Barton | 29011 | 2774 | 48 | 0 | 37.50207671 | -94.34757022 | 2022-02-21 04:21:05 | Barton, Missouri, US | |
2022-02-19 | US | Missouri | Barton | 29011 | 2774 | 48 | 0 | 37.50207671 | -94.34757022 | 2022-02-20 04:21:00 | Barton, Missouri, US | |
2022-02-18 | US | Missouri | Barton | 29011 | 2774 | 48 | 0 | 37.50207671 | -94.34757022 | 2022-02-19 04:21:11 | Barton, Missouri, US | |
2022-02-17 | US | Missouri | Barton | 29011 | 2774 | 48 | 0 | 37.50207671 | -94.34757022 | 2022-02-18 04:21:04 | Barton, Missouri, US | |
2022-02-08 | US | Minnesota | Watonwan | 27165 | 2774 | 22 | 0 | 43.97823903 | -94.61413846 | 2022-02-09 04:21:04 | Watonwan, Minnesota, US | |
2022-01-23 | US | Puerto Rico | Loiza | 72087 | 2774 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-01-24 04:21:12 | Loiza, Puerto Rico, US | |
2022-01-20 | US | Colorado | Moffat | 8081 | 2774 | 51 | 0 | 40.61810999 | -108.2070876 | 2022-01-21 04:21:09 | Moffat, Colorado, US | |
2022-01-19 | US | Texas | Zapata | 48505 | 2774 | 46 | 0 | 27.00156391 | -99.16987152 | 2022-01-20 04:21:07 | Zapata, Texas, US | |
2022-01-12 | US | New Mexico | Socorro | 35053 | 2774 | 71 | 0 | 34.00715494 | -106.9298354 | 2022-01-13 08:00:09 | Socorro, New Mexico, US | |
2022-01-11 | US | Virginia | Giles | 51071 | 2774 | 38 | 0 | 37.31234791 | -80.70636931 | 2022-01-12 04:21:44 | Giles, Virginia, US | |
2022-01-04 | US | Iowa | Clayton | 19043 | 2774 | 64 | 0 | 42.84443388 | -91.34133693 | 2022-01-05 04:21:59 | Clayton, Iowa, US | |
2022-01-04 | US | Indiana | Tipton | 18159 | 2774 | 70 | 0 | 40.31123252 | -86.05234925 | 2022-01-05 04:21:59 | Tipton, Indiana, US | |
2022-01-03 | US | Iowa | Clayton | 19043 | 2774 | 64 | 0 | 42.84443388 | -91.34133693 | 2022-01-04 04:22:17 | Clayton, Iowa, US | |
2022-01-02 | US | Iowa | Clayton | 19043 | 2774 | 64 | 0 | 42.84443388 | -91.34133693 | 2022-01-03 02:22:25 | Clayton, Iowa, US | |
2022-01-01 | US | Iowa | Clayton | 19043 | 2774 | 64 | 0 | 42.84443388 | -91.34133693 | 2022-01-02 04:20:52 | Clayton, Iowa, US | |
2021-12-31 | US | Iowa | Clayton | 19043 | 2774 | 64 | 0 | 42.84443388 | -91.34133693 | 2022-01-01 04:22:14 | Clayton, Iowa, US | |
2021-12-31 | US | California | Inyo | 6027 | 2774 | 49 | 0 | 36.51112084 | -117.41119779999998 | 2022-01-01 04:22:14 | Inyo, California, US | |
2021-12-30 | US | Iowa | Clayton | 19043 | 2774 | 64 | 0 | 42.84443388 | -91.34133693 | 2021-12-31 04:21:50 | Clayton, Iowa, US | |
2021-12-29 | US | Iowa | Clayton | 19043 | 2774 | 64 | 0 | 42.84443388 | -91.34133693 | 2021-12-30 04:21:25 | Clayton, Iowa, US | |
2021-12-27 | US | Nebraska | Saline | 31151 | 2774 | 2 | 0 | 40.52418865 | -97.14085859 | 2021-12-28 04:21:47 | Saline, Nebraska, US | |
2021-12-26 | US | Nebraska | Saline | 31151 | 2774 | 2 | 0 | 40.52418865 | -97.14085859 | 2021-12-27 04:21:58 | Saline, Nebraska, US | |
2021-12-25 | US | Nebraska | Saline | 31151 | 2774 | 2 | 0 | 40.52418865 | -97.14085859 | 2021-12-26 04:21:50 | Saline, Nebraska, US | |
2021-12-24 | US | Nebraska | Saline | 31151 | 2774 | 2 | 0 | 40.52418865 | -97.14085859 | 2021-12-25 04:21:37 | Saline, Nebraska, US | |
2021-12-23 | US | Nebraska | Saline | 31151 | 2774 | 2 | 0 | 40.52418865 | -97.14085859 | 2021-12-24 04:21:34 | Saline, Nebraska, US | |
2021-12-18 | US | Puerto Rico | Aguadilla | 72005 | 2774 | 0 | 0 | 18.459681 | -67.12081500000001 | 2021-12-19 04:21:11 | Aguadilla, Puerto Rico, US | |
2021-12-08 | US | Pennsylvania | Fulton | 42057 | 2774 | 40 | 0 | 39.92913544 | -78.11163677 | 2021-12-09 04:22:49 | Fulton, Pennsylvania, US | |
2021-12-08 | US | Missouri | Wright | 29229 | 2774 | 66 | 0 | 37.27029221 | -92.46914488 | 2021-12-09 04:22:49 | Wright, Missouri, US | |
2021-12-04 | US | Puerto Rico | Dorado | 72051 | 2774 | 0 | 0 | 18.436115 | -66.278669 | 2021-12-05 04:22:25 | Dorado, Puerto Rico, US | |
2021-12-03 | US | Puerto Rico | Dorado | 72051 | 2774 | 0 | 0 | 18.436115 | -66.278669 | 2021-12-04 04:22:18 | Dorado, Puerto Rico, US | |
2021-11-25 | Saint Kitts and Nevis | 2774 | 28 | 0 | 17.357822 | -62.782998 | 2021-11-26 04:22:33 | Saint Kitts and Nevis | ||||
2021-11-24 | Saint Kitts and Nevis | 2774 | 28 | 0 | 17.357822 | -62.782998 | 2021-11-25 04:22:33 | Saint Kitts and Nevis | ||||
2021-11-23 | Saint Kitts and Nevis | 2774 | 28 | 0 | 17.357822 | -62.782998 | 2021-11-24 04:22:14 | Saint Kitts and Nevis | ||||
2021-11-21 | US | Pennsylvania | Montour | 42093 | 2774 | 75 | 0 | 41.03023987 | -76.66345939 | 2021-11-22 04:22:20 | Montour, Pennsylvania, US | |
2021-11-15 | US | South Dakota | Union | 46127 | 2774 | 46 | 0 | 42.83112163 | -96.6557828 | 2021-11-16 04:21:10 | Union, South Dakota, US | |
2021-11-02 | US | Michigan | Ogemaw | 26129 | 2774 | 60 | 0 | 44.33481032 | -84.12725175 | 2021-11-03 06:22:09 | Ogemaw, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;