johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where active = 174, country_or_region = "US" and province_or_state = "Iowa" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3481480 | 3481480 | 2020-10-26 | US | Iowa | Davis | 19051 | 178 | 4 | 0 | 174 | 40.74773536 | -92.41005468 | 2020-10-27 04:24:45 | Davis, Iowa, US |
3991790 | 3991790 | 2020-10-20 | US | Iowa | Greene | 19073 | 174 | 0 | 0 | 174 | 42.03614551 | -94.39658081 | 2020-10-21 04:24:14 | Greene, Iowa, US |
763503 | 763503 | 2020-10-18 | US | Iowa | Ida | 19093 | 176 | 2 | 0 | 174 | 42.38696136 | -95.51355387 | 2020-10-19 04:24:16 | Ida, Iowa, US |
1027541 | 1027541 | 2020-10-17 | US | Iowa | Ida | 19093 | 176 | 2 | 0 | 174 | 42.38696136 | -95.51355387 | 2020-10-18 04:24:25 | Ida, Iowa, US |
2292635 | 2292635 | 2020-10-12 | US | Iowa | Jefferson | 19101 | 175 | 1 | 0 | 174 | 41.03192394 | -91.94849466 | 2020-10-13 04:24:02 | Jefferson, Iowa, US |
2603263 | 2603263 | 2020-10-10 | US | Iowa | Union | 19175 | 177 | 3 | 0 | 174 | 41.0277278 | -94.24234847 | 2020-10-11 04:23:46 | Union, Iowa, US |
818796 | 818796 | 2020-10-09 | US | Iowa | Union | 19175 | 177 | 3 | 0 | 174 | 41.0277278 | -94.24234847 | 2020-10-10 04:23:57 | Union, Iowa, US |
1823994 | 1823994 | 2020-10-04 | US | Iowa | Monona | 19133 | 175 | 1 | 0 | 174 | 42.05220391 | -95.95743843 | 2020-10-05 04:23:33 | Monona, Iowa, US |
968052 | 968052 | 2020-09-29 | US | Iowa | Cass | 19029 | 176 | 2 | 0 | 174 | 41.33149454 | -94.92792482 | 2020-09-30 04:23:33 | Cass, Iowa, US |
3317371 | 3317371 | 2020-09-22 | US | Iowa | Calhoun | 19025 | 176 | 2 | 0 | 174 | 42.38521079 | -94.64046046 | 2020-09-23 04:23:00 | Calhoun, Iowa, US |
3317399 | 3317399 | 2020-09-22 | US | Iowa | Hancock | 19081 | 176 | 2 | 0 | 174 | 43.08178477 | -93.73454884 | 2020-09-23 04:23:00 | Hancock, Iowa, US |
3317404 | 3317404 | 2020-09-22 | US | Iowa | Humboldt | 19091 | 177 | 3 | 0 | 174 | 42.7764426 | -94.20722537 | 2020-09-23 04:23:00 | Humboldt, Iowa, US |
2850025 | 2850025 | 2020-09-18 | US | Iowa | Howard | 19089 | 179 | 5 | 0 | 174 | 43.35671042 | -92.31702714 | 2020-09-19 04:22:00 | Howard, Iowa, US |
1122762 | 1122762 | 2020-09-17 | US | Iowa | Fayette | 19065 | 175 | 1 | 0 | 174 | 42.86271799 | -91.8441231 | 2020-09-18 05:05:00 | Fayette, Iowa, US |
2730198 | 2730198 | 2020-09-15 | US | Iowa | Kossuth | 19109 | 174 | 0 | 0 | 174 | 43.20405458 | -94.20691791 | 2020-09-16 04:22:53 | Kossuth, Iowa, US |
1174384 | 1174384 | 2020-09-10 | US | Iowa | Madison | 19121 | 176 | 2 | 0 | 174 | 41.33081904 | -94.01554631 | 2020-09-11 04:46:23 | Madison, Iowa, US |
814732 | 814732 | 2020-09-05 | US | Iowa | Cedar | 19031 | 175 | 1 | 0 | 174 | 41.77233777 | -91.13246684 | 2020-09-06 04:28:33 | Cedar, Iowa, US |
814755 | 814755 | 2020-09-05 | US | Iowa | Guthrie | 19077 | 179 | 5 | 0 | 174 | 41.68378965 | -94.50111014 | 2020-09-06 04:28:33 | Guthrie, Iowa, US |
1355509 | 1355509 | 2020-09-03 | US | Iowa | Jones | 19105 | 176 | 2 | 0 | 174 | 42.12118609 | -91.13139641 | 2020-09-04 04:28:26 | Jones, Iowa, US |
1106746 | 1106746 | 2020-09-02 | US | Iowa | Jones | 19105 | 176 | 2 | 0 | 174 | 42.12118609 | -91.13139641 | 2020-09-03 04:28:22 | Jones, Iowa, US |
195210 | 195210 | 2020-08-31 | US | Iowa | Allamakee | 19005 | 178 | 4 | 0 | 174 | 43.28383218 | -91.37860922 | 2020-09-01 04:28:31 | Allamakee, Iowa, US |
195217 | 195217 | 2020-08-31 | US | Iowa | Buchanan | 19019 | 175 | 1 | 0 | 174 | 42.4709188 | -91.83510825 | 2020-09-01 04:28:31 | Buchanan, Iowa, US |
610907 | 610907 | 2020-08-29 | US | Iowa | Poweshiek | 19157 | 182 | 8 | 0 | 174 | 41.68625425 | -92.53155731 | 2020-08-30 04:28:22 | Poweshiek, Iowa, US |
1524345 | 1524345 | 2020-08-28 | US | Iowa | Clayton | 19043 | 177 | 3 | 0 | 174 | 42.84443388 | -91.34133693 | 2020-08-29 04:28:19 | Clayton, Iowa, US |
1524402 | 1524402 | 2020-08-28 | US | Iowa | Poweshiek | 19157 | 182 | 8 | 0 | 174 | 41.68625425 | -92.53155731 | 2020-08-29 04:28:19 | Poweshiek, Iowa, US |
2511395 | 2511395 | 2020-08-27 | US | Iowa | O'Brien | 19141 | 181 | 7 | 0 | 174 | 43.08310673 | -95.62474482 | 2020-08-28 04:28:11 | O'Brien, Iowa, US |
207437 | 207437 | 2020-08-19 | US | Iowa | Henry | 19087 | 178 | 4 | 0 | 174 | 40.98767962 | -91.54436349 | 2020-08-20 04:27:43 | Henry, Iowa, US |
147145 | 147145 | 2020-08-15 | US | Iowa | Floyd | 19067 | 177 | 3 | 0 | 174 | 43.06000529999999 | -92.78940097 | 2020-08-16 04:27:42 | Floyd, Iowa, US |
1918737 | 1918737 | 2020-08-10 | US | Iowa | Marion | 19125 | 174 | 0 | 0 | 174 | 41.33445101 | -93.09934783 | 2020-08-11 04:35:08 | Marion, Iowa, US |
3261472 | 3261472 | 2020-07-31 | US | Iowa | Bremer | 19017 | 181 | 7 | 0 | 174 | 42.77461496 | -92.31795937 | 2020-08-01 04:36:27 | Bremer, Iowa, US |
3261603 | 3261603 | 2020-07-31 | US | Iowa | Carroll | 19027 | 175 | 1 | 0 | 174 | 42.03617207 | -94.86032705 | 2020-08-01 04:36:27 | Carroll, Iowa, US |
3488223 | 3488223 | 2020-07-13 | US | Iowa | Boone | 19015 | 175 | 1 | 0 | 174 | 42.03657094 | -93.9313999 | 2020-07-14 04:34:46 | Boone, Iowa, US |
2896718 | 2896718 | 2020-05-09 | US | Iowa | Crawford | 19047 | 175 | 1 | 0 | 174 | 42.03718237 | -95.3819718 | 2020-05-10 02:32:30 | Crawford, Iowa, US |
2041551 | 2041551 | 2020-05-02 | US | Iowa | Jasper | 19099 | 175 | 1 | 0 | 174 | 41.68576082 | -93.05567785 | 2020-05-03 02:32:28 | Jasper, Iowa, 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]);