johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
100,603 rows where province_or_state = "Iowa" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1478666 | 1478666 | 2020-03-24 | US | Iowa | Unassigned | 2 | 0 | 0 | 2 | 0.0 | 0.0 | 2020-03-24 23:37:31 | Unassigned, Iowa, US | |
3364461 | 3364461 | 2020-04-01 | US | Iowa | Unassigned | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-04-01 21:58:49 | Unassigned, Iowa, US | |
3815558 | 3815558 | 2020-03-31 | US | Iowa | Unassigned | 2 | 1 | 0 | 1 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Iowa, US | |
1543 | 1543 | 2021-12-02 | US | Iowa | Lee | 19111 | 5977 | 106 | 0 | 40.64181461 | -91.48183025 | 2021-12-03 04:23:05 | Lee, Iowa, US | |
5558 | 5558 | 2021-10-28 | US | Iowa | Lee | 19111 | 5703 | 97 | 0 | 40.64181461 | -91.48183025 | 2021-10-29 04:22:03 | Lee, Iowa, US | |
9531 | 9531 | 2020-10-25 | US | Iowa | Lee | 19111 | 954 | 10 | 0 | 944 | 40.64181461 | -91.48183025 | 2020-10-26 04:25:02 | Lee, Iowa, US |
13543 | 13543 | 2021-01-26 | US | Iowa | Lee | 19111 | 3271 | 32 | 0 | 3239 | 40.64181461 | -91.48183025 | 2021-01-27 05:23:41 | Lee, Iowa, US |
17565 | 17565 | 2021-09-18 | US | Iowa | Lee | 19111 | 5110 | 78 | 0 | 40.64181461 | -91.48183025 | 2021-09-19 04:21:34 | Lee, Iowa, US | |
21576 | 21576 | 2021-05-28 | US | Iowa | Lee | 19111 | 3791 | 55 | 0 | 40.64181461 | -91.48183025 | 2021-05-29 04:20:41 | Lee, Iowa, US | |
25614 | 25614 | 2022-03-20 | US | Iowa | Lee | 19111 | 7831 | 141 | 0 | 40.64181461 | -91.48183025 | 2022-03-21 04:20:50 | Lee, Iowa, US | |
29629 | 29629 | 2021-11-11 | US | Iowa | Lee | 19111 | 5795 | 101 | 0 | 40.64181461 | -91.48183025 | 2021-11-12 04:22:01 | Lee, Iowa, US | |
33625 | 33625 | 2021-08-25 | US | Iowa | Lee | 19111 | 4598 | 63 | 0 | 40.64181461 | -91.48183025 | 2021-08-26 04:21:28 | Lee, Iowa, US | |
37635 | 37635 | 2021-04-12 | US | Iowa | Lee | 19111 | 3668 | 55 | 0 | 40.64181461 | -91.48183025 | 2021-04-13 04:20:37 | Lee, Iowa, US | |
41715 | 41715 | 2020-04-13 | US | Iowa | Lee | 19111 | 2 | 0 | 0 | 2 | 40.64181461 | -91.48183025 | 2020-04-13 23:07:54 | Lee, Iowa, US |
44921 | 44921 | 2021-11-02 | US | Iowa | Lee | 19111 | 5745 | 97 | 0 | 40.64181461 | -91.48183025 | 2021-11-03 06:22:09 | Lee, Iowa, US | |
48786 | 48786 | 2020-04-17 | US | Iowa | Lee | 19111 | 3 | 0 | 0 | 3 | 40.64181461 | -91.48183025 | 2020-04-17 23:30:52 | Lee, Iowa, US |
51997 | 51997 | 2021-05-29 | US | Iowa | Lee | 19111 | 3791 | 55 | 0 | 40.64181461 | -91.48183025 | 2021-05-30 04:20:55 | Lee, Iowa, US | |
56008 | 56008 | 2021-03-07 | US | Iowa | Lee | 19111 | 3546 | 53 | 0 | 40.64181461 | -91.48183025 | 2021-03-08 05:24:48 | Lee, Iowa, US | |
60153 | 60153 | 2020-07-23 | US | Iowa | Lee | 19111 | 67 | 2 | 0 | 65 | 40.64181461 | -91.48183025 | 2020-07-24 05:30:40 | Lee, Iowa, US |
64279 | 64279 | 2022-11-12 | US | Iowa | Lee | 19111 | 8854 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-11-13 04:21:14 | Lee, Iowa, US | |
68270 | 68270 | 2021-09-01 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-02 04:21:15 | Lee, Iowa, US | |
72304 | 72304 | 2022-02-07 | US | Iowa | Lee | 19111 | 7558 | 121 | 0 | 40.64181461 | -91.48183025 | 2022-02-08 04:21:15 | Lee, Iowa, US | |
76291 | 76291 | 2020-12-03 | US | Iowa | Lee | 19111 | 2287 | 19 | 0 | 2268 | 40.64181461 | -91.48183025 | 2020-12-04 05:27:27 | Lee, Iowa, US |
80285 | 80285 | 2020-10-14 | US | Iowa | Lee | 19111 | 803 | 9 | 0 | 794 | 40.64181461 | -91.48183025 | 2020-10-15 04:24:28 | Lee, Iowa, US |
84300 | 84300 | 2021-05-25 | US | Iowa | Lee | 19111 | 3783 | 55 | 0 | 40.64181461 | -91.48183025 | 2021-05-26 04:20:35 | Lee, Iowa, US | |
88338 | 88338 | 2021-11-09 | US | Iowa | Lee | 19111 | 5745 | 100 | 0 | 40.64181461 | -91.48183025 | 2021-11-10 04:21:38 | Lee, Iowa, US | |
92356 | 92356 | 2022-07-23 | US | Iowa | Lee | 19111 | 8161 | 143 | 0 | 40.64181461 | -91.48183025 | 2022-07-24 04:20:47 | Lee, Iowa, US | |
96478 | 96478 | 2020-08-04 | US | Iowa | Lee | 19111 | 97 | 3 | 0 | 94 | 40.64181461 | -91.48183025 | 2020-08-05 04:34:43 | Lee, Iowa, US |
100539 | 100539 | 2022-01-14 | US | Iowa | Lee | 19111 | 6707 | 116 | 0 | 40.64181461 | -91.48183025 | 2022-01-15 04:21:07 | Lee, Iowa, US | |
104535 | 104535 | 2021-08-15 | US | Iowa | Lee | 19111 | 4321 | 59 | 0 | 40.64181461 | -91.48183025 | 2021-08-16 04:21:31 | Lee, Iowa, US | |
108659 | 108659 | 2021-06-19 | US | Iowa | Lee | 19111 | 3823 | 56 | 0 | 40.64181461 | -91.48183025 | 2021-06-20 04:21:48 | Lee, Iowa, US | |
112641 | 112641 | 2020-05-08 | US | Iowa | Lee | 19111 | 18 | 0 | 0 | 18 | 40.64181461 | -91.48183025 | 2020-05-09 02:32:35 | Lee, Iowa, US |
115966 | 115966 | 2022-09-06 | US | Iowa | Lee | 19111 | 8527 | 145 | 0 | 40.64181461 | -91.48183025 | 2022-09-07 04:20:59 | Lee, Iowa, US | |
120080 | 120080 | 2020-07-19 | US | Iowa | Lee | 19111 | 58 | 2 | 0 | 56 | 40.64181461 | -91.48183025 | 2020-07-20 05:34:40 | Lee, Iowa, US |
123906 | 123906 | 2020-11-18 | US | Iowa | Lee | 19111 | 1757 | 14 | 0 | 1743 | 40.64181461 | -91.48183025 | 2020-11-19 05:25:23 | Lee, Iowa, US |
127946 | 127946 | 2022-01-09 | US | Iowa | Lee | 19111 | 6488 | 112 | 0 | 40.64181461 | -91.48183025 | 2022-01-10 04:22:07 | Lee, Iowa, US | |
131967 | 131967 | 2022-10-04 | US | Iowa | Lee | 19111 | 8714 | 146 | 0 | 40.64181461 | -91.48183025 | 2022-10-05 04:23:06 | Lee, Iowa, US | |
135886 | 135886 | 2020-04-29 | US | Iowa | Lee | 19111 | 8 | 0 | 0 | 8 | 40.64181461 | -91.48183025 | 2020-04-30 02:32:27 | Lee, Iowa, US |
139184 | 139184 | 2021-12-04 | US | Iowa | Lee | 19111 | 5977 | 106 | 0 | 40.64181461 | -91.48183025 | 2021-12-05 04:22:25 | Lee, Iowa, US | |
143202 | 143202 | 2022-07-09 | US | Iowa | Lee | 19111 | 8080 | 142 | 0 | 40.64181461 | -91.48183025 | 2022-07-10 04:20:54 | Lee, Iowa, US | |
147167 | 147167 | 2020-08-15 | US | Iowa | Lee | 19111 | 149 | 5 | 0 | 144 | 40.64181461 | -91.48183025 | 2020-08-16 04:27:42 | Lee, Iowa, US |
151197 | 151197 | 2021-11-29 | US | Iowa | Lee | 19111 | 5908 | 105 | 0 | 40.64181461 | -91.48183025 | 2021-11-30 04:22:53 | Lee, Iowa, US | |
155185 | 155185 | 2021-01-08 | US | Iowa | Lee | 19111 | 3042 | 28 | 0 | 3014 | 40.64181461 | -91.48183025 | 2021-01-09 05:22:18 | Lee, Iowa, US |
159226 | 159226 | 2022-03-29 | US | Iowa | Lee | 19111 | 7837 | 141 | 0 | 40.64181461 | -91.48183025 | 2022-03-30 04:20:45 | Lee, Iowa, US | |
163241 | 163241 | 2021-11-19 | US | Iowa | Lee | 19111 | 5838 | 104 | 0 | 40.64181461 | -91.48183025 | 2021-11-20 04:22:17 | Lee, Iowa, US | |
167259 | 167259 | 2022-06-21 | US | Iowa | Lee | 19111 | 7997 | 142 | 0 | 40.64181461 | -91.48183025 | 2022-06-22 04:20:54 | Lee, Iowa, US | |
171249 | 171249 | 2021-04-16 | US | Iowa | Lee | 19111 | 3681 | 55 | 0 | 40.64181461 | -91.48183025 | 2021-04-17 04:20:40 | Lee, Iowa, US | |
175393 | 175393 | 2020-07-27 | US | Iowa | Lee | 19111 | 77 | 2 | 0 | 75 | 40.64181461 | -91.48183025 | 2020-07-28 04:58:43 | Lee, Iowa, US |
179235 | 179235 | 2021-09-02 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-03 04:21:20 | Lee, Iowa, US | |
183243 | 183243 | 2021-02-21 | US | Iowa | Lee | 19111 | 3498 | 51 | 0 | 3447 | 40.64181461 | -91.48183025 | 2021-02-22 05:24:21 | Lee, Iowa, US |
187284 | 187284 | 2022-02-13 | US | Iowa | Lee | 19111 | 7690 | 128 | 0 | 40.64181461 | -91.48183025 | 2022-02-14 04:20:51 | Lee, Iowa, US | |
191271 | 191271 | 2021-01-11 | US | Iowa | Lee | 19111 | 3068 | 28 | 0 | 3040 | 40.64181461 | -91.48183025 | 2021-01-12 05:22:15 | Lee, Iowa, US |
195263 | 195263 | 2020-08-31 | US | Iowa | Lee | 19111 | 422 | 5 | 0 | 417 | 40.64181461 | -91.48183025 | 2020-09-01 04:28:31 | Lee, Iowa, US |
199476 | 199476 | 2022-10-19 | US | Iowa | Lee | 19111 | 8782 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-20 04:22:59 | Lee, Iowa, US | |
203458 | 203458 | 2020-12-25 | US | Iowa | Lee | 19111 | 2794 | 24 | 0 | 2770 | 40.64181461 | -91.48183025 | 2020-12-26 05:22:28 | Lee, Iowa, US |
207449 | 207449 | 2020-08-19 | US | Iowa | Lee | 19111 | 189 | 5 | 0 | 184 | 40.64181461 | -91.48183025 | 2020-08-20 04:27:43 | Lee, Iowa, US |
211440 | 211440 | 2020-10-29 | US | Iowa | Lee | 19111 | 1013 | 12 | 0 | 1001 | 40.64181461 | -91.48183025 | 2020-10-30 04:24:49 | Lee, Iowa, US |
215476 | 215476 | 2020-06-08 | US | Iowa | Lee | 19111 | 31 | 0 | 0 | 31 | 40.64181461 | -91.48183025 | 2020-06-09 03:33:03 | Lee, Iowa, US |
219197 | 219197 | 2022-12-26 | US | Iowa | Lee | 19111 | 8994 | 148 | 0 | 40.64181461 | -91.48183025 | 2022-12-27 04:21:07 | Lee, Iowa, US | |
223209 | 223209 | 2022-05-09 | US | Iowa | Lee | 19111 | 7866 | 142 | 0 | 40.64181461 | -91.48183025 | 2022-05-10 04:20:50 | Lee, Iowa, US | |
227138 | 227138 | 2020-04-30 | US | Iowa | Lee | 19111 | 8 | 0 | 0 | 8 | 40.64181461 | -91.48183025 | 2020-05-01 02:32:28 | Lee, Iowa, US |
230441 | 230441 | 2022-05-31 | US | Iowa | Lee | 19111 | 7950 | 142 | 0 | 40.64181461 | -91.48183025 | 2022-06-01 04:20:55 | Lee, Iowa, US | |
234456 | 234456 | 2022-02-11 | US | Iowa | Lee | 19111 | 7690 | 128 | 0 | 40.64181461 | -91.48183025 | 2022-02-12 04:21:06 | Lee, Iowa, US | |
238443 | 238443 | 2021-01-18 | US | Iowa | Lee | 19111 | 3158 | 30 | 0 | 3128 | 40.64181461 | -91.48183025 | 2021-01-19 05:22:15 | Lee, Iowa, US |
242460 | 242460 | 2021-04-02 | US | Iowa | Lee | 19111 | 3644 | 55 | 0 | 40.64181461 | -91.48183025 | 2021-04-03 04:20:44 | Lee, Iowa, US | |
246478 | 246478 | 2021-08-17 | US | Iowa | Lee | 19111 | 4321 | 59 | 0 | 40.64181461 | -91.48183025 | 2021-08-18 04:21:35 | Lee, Iowa, US | |
250492 | 250492 | 2021-09-04 | US | Iowa | Lee | 19111 | 4752 | 69 | 0 | 40.64181461 | -91.48183025 | 2021-09-05 04:21:33 | Lee, Iowa, US | |
254528 | 254528 | 2022-09-08 | US | Iowa | Lee | 19111 | 8592 | 146 | 0 | 40.64181461 | -91.48183025 | 2022-09-09 04:21:11 | Lee, Iowa, US | |
258547 | 258547 | 2022-12-10 | US | Iowa | Lee | 19111 | 8935 | 148 | 0 | 40.64181461 | -91.48183025 | 2022-12-11 04:20:50 | Lee, Iowa, US | |
262746 | 262746 | 2022-03-15 | US | Iowa | Lee | 19111 | 7820 | 138 | 0 | 40.64181461 | -91.48183025 | 2022-03-16 04:20:50 | Lee, Iowa, US | |
266728 | 266728 | 2020-05-21 | US | Iowa | Lee | 19111 | 20 | 0 | 0 | 20 | 40.64181461 | -91.48183025 | 2020-05-22 02:36:51 | Lee, Iowa, US |
270103 | 270103 | 2020-04-28 | US | Iowa | Lee | 19111 | 7 | 0 | 0 | 7 | 40.64181461 | -91.48183025 | 2020-04-29 02:32:29 | Lee, Iowa, US |
273356 | 273356 | 2020-11-10 | US | Iowa | Lee | 19111 | 1387 | 14 | 0 | 1373 | 40.64181461 | -91.48183025 | 2020-11-11 05:25:30 | Lee, Iowa, US |
277396 | 277396 | 2021-11-03 | US | Iowa | Lee | 19111 | 5745 | 100 | 0 | 40.64181461 | -91.48183025 | 2021-11-04 04:22:20 | Lee, Iowa, US | |
281386 | 281386 | 2021-02-24 | US | Iowa | Lee | 19111 | 3518 | 51 | 0 | 3467 | 40.64181461 | -91.48183025 | 2021-02-25 05:24:57 | Lee, Iowa, US |
285439 | 285439 | 2020-06-15 | US | Iowa | Lee | 19111 | 40 | 1 | 0 | 39 | 40.64181461 | -91.48183025 | 2020-06-16 04:33:09 | Lee, Iowa, US |
289208 | 289208 | 2021-10-31 | US | Iowa | Lee | 19111 | 5703 | 97 | 0 | 40.64181461 | -91.48183025 | 2021-11-01 04:22:01 | Lee, Iowa, US | |
293230 | 293230 | 2022-11-15 | US | Iowa | Lee | 19111 | 8854 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-11-16 04:21:09 | Lee, Iowa, US | |
297221 | 297221 | 2021-07-15 | US | Iowa | Lee | 19111 | 3879 | 58 | 0 | 40.64181461 | -91.48183025 | 2021-07-16 04:21:22 | Lee, Iowa, US | |
301290 | 301290 | 2020-07-01 | US | Iowa | Lee | 19111 | 49 | 2 | 0 | 47 | 40.64181461 | -91.48183025 | 2020-07-02 04:33:46 | Lee, Iowa, US |
305082 | 305082 | 2022-04-16 | US | Iowa | Lee | 19111 | 7856 | 142 | 0 | 40.64181461 | -91.48183025 | 2022-04-17 04:20:59 | Lee, Iowa, US | |
309102 | 309102 | 2022-12-13 | US | Iowa | Lee | 19111 | 8935 | 148 | 0 | 40.64181461 | -91.48183025 | 2022-12-14 04:21:04 | Lee, Iowa, US | |
313118 | 313118 | 2022-11-13 | US | Iowa | Lee | 19111 | 8854 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-11-14 04:21:09 | Lee, Iowa, US | |
317130 | 317130 | 2022-02-12 | US | Iowa | Lee | 19111 | 7690 | 128 | 0 | 40.64181461 | -91.48183025 | 2022-02-13 04:21:00 | Lee, Iowa, US | |
321150 | 321150 | 2022-10-30 | US | Iowa | Lee | 19111 | 8808 | 147 | 0 | 40.64181461 | -91.48183025 | 2022-10-31 04:21:36 | Lee, Iowa, US | |
325222 | 325222 | 2020-07-20 | US | Iowa | Lee | 19111 | 62 | 2 | 0 | 60 | 40.64181461 | -91.48183025 | 2020-07-21 04:38:46 | Lee, Iowa, US |
329124 | 329124 | 2022-12-27 | US | Iowa | Lee | 19111 | 8994 | 148 | 0 | 40.64181461 | -91.48183025 | 2022-12-28 04:21:04 | Lee, Iowa, US | |
333115 | 333115 | 2021-08-04 | US | Iowa | Lee | 19111 | 4148 | 59 | 0 | 40.64181461 | -91.48183025 | 2021-08-05 04:21:51 | Lee, Iowa, US | |
337150 | 337150 | 2022-03-18 | US | Iowa | Lee | 19111 | 7831 | 141 | 0 | 40.64181461 | -91.48183025 | 2022-03-19 04:20:47 | Lee, Iowa, US | |
341478 | 341478 | 2021-02-03 | US | Iowa | Lee | 19111 | 3395 | 43 | 0 | 3352 | 40.64181461 | -91.48183025 | 2021-02-04 05:22:26 | Lee, Iowa, US |
345471 | 345471 | 2020-09-14 | US | Iowa | Lee | 19111 | 551 | 6 | 0 | 545 | 40.64181461 | -91.48183025 | 2020-09-15 03:22:50 | Lee, Iowa, US |
349514 | 349514 | 2022-12-14 | US | Iowa | Lee | 19111 | 8965 | 148 | 0 | 40.64181461 | -91.48183025 | 2022-12-15 04:20:58 | Lee, Iowa, US | |
353499 | 353499 | 2021-03-11 | US | Iowa | Lee | 19111 | 3548 | 55 | 0 | 40.64181461 | -91.48183025 | 2021-03-12 05:26:50 | Lee, Iowa, US | |
357540 | 357540 | 2022-03-11 | US | Iowa | Lee | 19111 | 7820 | 138 | 0 | 40.64181461 | -91.48183025 | 2022-03-12 04:20:50 | Lee, Iowa, US | |
361556 | 361556 | 2022-05-07 | US | Iowa | Lee | 19111 | 7866 | 142 | 0 | 40.64181461 | -91.48183025 | 2022-05-08 04:20:49 | Lee, Iowa, US | |
365626 | 365626 | 2020-07-16 | US | Iowa | Lee | 19111 | 54 | 2 | 0 | 52 | 40.64181461 | -91.48183025 | 2020-07-17 04:34:50 | Lee, Iowa, US |
369542 | 369542 | 2020-08-08 | US | Iowa | Lee | 19111 | 113 | 3 | 0 | 110 | 40.64181461 | -91.48183025 | 2020-08-09 04:34:54 | Lee, Iowa, US |
373414 | 373414 | 2022-09-13 | US | Iowa | Lee | 19111 | 8592 | 146 | 0 | 40.64181461 | -91.48183025 | 2022-09-14 04:20:44 | Lee, Iowa, US | |
377383 | 377383 | 2020-11-06 | US | Iowa | Lee | 19111 | 1237 | 13 | 0 | 1224 | 40.64181461 | -91.48183025 | 2020-11-07 05:24:52 | Lee, Iowa, US |
381398 | 381398 | 2021-04-30 | US | Iowa | Lee | 19111 | 3710 | 55 | 0 | 40.64181461 | -91.48183025 | 2021-05-01 04:20:47 | Lee, 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]);