johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where active = 4034 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 18
- Michigan 3
- Ohio 3
- Tennessee 3
- Arkansas 2
- Georgia 2
- Illinois 2
- Kansas 2
- Louisiana 2
- New Jersey 2
- North Carolina 2
- Texas 2
- Alabama 1
- Alaska 1
- Mississippi 1
- New Mexico 1
- South Carolina 1
- Vermont 1
- Washington 1
country_or_region 1
- US · 32 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3668925 | 3668925 | 2021-03-06 | US | Kansas | Lyon | 20111 | 4115 | 81 | 0 | 4034 | 38.45576156 | -96.15275715 | 2021-03-07 05:21:54 | Lyon, Kansas, US |
1617546 | 1617546 | 2021-03-05 | US | Kansas | Lyon | 20111 | 4115 | 81 | 0 | 4034 | 38.45576156 | -96.15275715 | 2021-03-06 04:23:41 | Lyon, Kansas, US |
1091906 | 1091906 | 2021-03-03 | US | Mississippi | Pontotoc | 28115 | 4105 | 71 | 0 | 4034 | 34.226046000000004 | -89.03636807 | 2021-03-04 05:24:24 | Pontotoc, Mississippi, US |
1092282 | 1092282 | 2021-03-03 | US | New Mexico | Unassigned | 90035 | 4034 | 0 | 0 | 4034 | 36.60569702 | -108.7151824 | 2021-03-04 05:24:24 | Unassigned, New Mexico, US |
1860325 | 1860325 | 2021-02-25 | US | North Carolina | Hoke | 37093 | 4088 | 54 | 0 | 4034 | 35.01888303 | -79.23651674 | 2021-02-26 05:22:40 | Hoke, North Carolina, US |
1937324 | 1937324 | 2021-02-23 | US | Georgia | Thomas | 13275 | 4146 | 112 | 0 | 4034 | 30.86392347 | -83.91847289 | 2021-02-24 05:29:16 | Thomas, Georgia, US |
2284404 | 2284404 | 2021-02-14 | US | Illinois | Franklin | 17055 | 4099 | 65 | 0 | 4034 | 37.99189086 | -88.92567818 | 2021-02-15 05:24:49 | Franklin, Illinois, US |
3542495 | 3542495 | 2021-02-12 | US | Texas | Chambers | 48071 | 2916 | 19 | 0 | 4034 | 29.70972016 | -94.67154501 | 2021-02-13 05:22:12 | Chambers, Texas, US |
2640758 | 2640758 | 2021-02-11 | US | Texas | Chambers | 48071 | 2916 | 19 | 0 | 4034 | 29.70972016 | -94.67154501 | 2021-02-12 05:23:29 | Chambers, Texas, US |
1687774 | 1687774 | 2021-02-02 | US | Vermont | Chittenden | 50007 | 4114 | 80 | 0 | 4034 | 44.46322849 | -73.08359212 | 2021-02-03 05:22:52 | Chittenden, Vermont, US |
1900123 | 1900123 | 2021-01-29 | US | Tennessee | Obion | 47131 | 4251 | 86 | 0 | 4034 | 36.35732446 | -89.14921589 | 2021-01-30 05:22:49 | Obion, Tennessee, US |
2469275 | 2469275 | 2021-01-22 | US | Ohio | Jefferson | 39081 | 4167 | 133 | 0 | 4034 | 40.38614126 | -80.76259514 | 2021-01-23 05:22:03 | Jefferson, Ohio, US |
3882075 | 3882075 | 2021-01-14 | US | Ohio | Sandusky | 39143 | 4132 | 98 | 0 | 4034 | 41.35624126 | -83.137872 | 2021-01-15 05:22:24 | Sandusky, Ohio, US |
3037738 | 3037738 | 2021-01-05 | US | Washington | Kitsap | 53035 | 4076 | 42 | 0 | 4034 | 47.63479026 | -122.6436061 | 2021-01-06 05:22:16 | Kitsap, Washington, US |
1062845 | 1062845 | 2021-01-04 | US | Illinois | Knox | 17095 | 4139 | 105 | 0 | 4034 | 40.93148779 | -90.21330340000002 | 2021-01-05 05:21:49 | Knox, Illinois, US |
1139045 | 1139045 | 2021-01-01 | US | New Jersey | Hunterdon | 34019 | 4173 | 139 | 0 | 4034 | 40.56335249 | -74.91284156 | 2021-01-02 05:22:33 | Hunterdon, New Jersey, US |
3696373 | 3696373 | 2020-12-31 | US | Georgia | Walker | 13295 | 4093 | 59 | 0 | 4034 | 34.73376362 | -85.30165174 | 2021-01-01 05:23:07 | Walker, Georgia, US |
205216 | 205216 | 2020-12-25 | US | Tennessee | McMinn | 47107 | 4246 | 61 | 0 | 4034 | 35.42812616 | -84.61520715 | 2020-12-26 05:22:28 | McMinn, Tennessee, US |
3691948 | 3691948 | 2020-12-24 | US | Arkansas | Crittenden | 5035 | 4104 | 70 | 0 | 4034 | 35.21247318 | -90.30839406 | 2020-12-25 05:22:48 | Crittenden, Arkansas, US |
3694439 | 3694439 | 2020-12-24 | US | Tennessee | McMinn | 47107 | 4190 | 61 | 0 | 4034 | 35.42812616 | -84.61520715 | 2020-12-25 05:22:48 | McMinn, Tennessee, US |
2931574 | 2931574 | 2020-12-19 | US | Alabama | Colbert | 1033 | 4090 | 56 | 0 | 4034 | 34.69847452 | -87.80168544 | 2020-12-20 05:27:32 | Colbert, Alabama, US |
77586 | 77586 | 2020-12-03 | US | Ohio | Richland | 39139 | 4096 | 62 | 0 | 4034 | 40.77180308 | -82.53799609999999 | 2020-12-04 05:27:27 | Richland, Ohio, US |
740615 | 740615 | 2020-12-02 | US | North Carolina | Harnett | 37085 | 4112 | 78 | 0 | 4034 | 35.36731853 | -78.87243571 | 2020-12-03 05:28:22 | Harnett, North Carolina, US |
8815 | 8815 | 2020-10-25 | US | Arkansas | Jefferson | 5069 | 4136 | 102 | 0 | 4034 | 34.26767081 | -91.92619839 | 2020-10-26 04:25:02 | Jefferson, Arkansas, US |
1180317 | 1180317 | 2020-10-22 | US | South Carolina | Pickens | 45077 | 4091 | 57 | 0 | 4034 | 34.88807695 | -82.72791551 | 2020-10-23 04:24:46 | Pickens, South Carolina, US |
763946 | 763946 | 2020-10-18 | US | Michigan | Kalamazoo | 26077 | 4133 | 99 | 0 | 4034 | 42.24542231 | -85.53038622 | 2020-10-19 04:24:16 | Kalamazoo, Michigan, US |
1027984 | 1027984 | 2020-10-17 | US | Michigan | Kalamazoo | 26077 | 4133 | 99 | 0 | 4034 | 42.24542231 | -85.53038622 | 2020-10-18 04:24:25 | Kalamazoo, Michigan, US |
2615542 | 2615542 | 2020-09-26 | US | Louisiana | Rapides | 22079 | 4182 | 148 | 0 | 4034 | 31.19778499 | -92.52997303 | 2020-09-27 04:23:00 | Rapides, Louisiana, US |
2813154 | 2813154 | 2020-09-25 | US | Alaska | Anchorage | 2020 | 4065 | 31 | 0 | 4034 | 61.14998174 | -149.1426986 | 2020-09-26 04:23:00 | Anchorage, Alaska, US |
2814257 | 2814257 | 2020-09-25 | US | Louisiana | Rapides | 22079 | 4182 | 148 | 0 | 4034 | 31.19778499 | -92.52997303 | 2020-09-26 04:23:00 | Rapides, Louisiana, US |
2814895 | 2814895 | 2020-09-25 | US | New Jersey | Atlantic | 34001 | 4290 | 256 | 0 | 4034 | 39.47538693 | -74.65848483 | 2020-09-26 04:23:00 | Atlantic, New Jersey, US |
1267901 | 1267901 | 2020-06-05 | US | Michigan | Kent | 26081 | 4130 | 96 | 0 | 4034 | 43.03197711 | -85.54934642 | 2020-06-06 02:33:00 | Kent, Michigan, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);