johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where combined_key = "Hunterdon, New Jersey, US" and province_or_state = "New Jersey" sorted by active
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2503 | 2503 | 2021-12-02 | US | New Jersey | Hunterdon | 34019 | 13103 | 196 | 0 | 40.56335249 | -74.91284156 | 2021-12-03 04:23:05 | Hunterdon, New Jersey, US | |
6518 | 6518 | 2021-10-28 | US | New Jersey | Hunterdon | 34019 | 12025 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-10-29 04:22:03 | Hunterdon, New Jersey, US | |
18525 | 18525 | 2021-09-18 | US | New Jersey | Hunterdon | 34019 | 11141 | 185 | 0 | 40.56335249 | -74.91284156 | 2021-09-19 04:21:34 | Hunterdon, New Jersey, US | |
22536 | 22536 | 2021-05-28 | US | New Jersey | Hunterdon | 34019 | 9773 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-05-29 04:20:41 | Hunterdon, New Jersey, US | |
26574 | 26574 | 2022-03-20 | US | New Jersey | Hunterdon | 34019 | 24364 | 269 | 0 | 40.56335249 | -74.91284156 | 2022-03-21 04:20:50 | Hunterdon, New Jersey, US | |
30589 | 30589 | 2021-11-11 | US | New Jersey | Hunterdon | 34019 | 12282 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-11-12 04:22:01 | Hunterdon, New Jersey, US | |
34585 | 34585 | 2021-08-25 | US | New Jersey | Hunterdon | 34019 | 10567 | 180 | 0 | 40.56335249 | -74.91284156 | 2021-08-26 04:21:28 | Hunterdon, New Jersey, US | |
38595 | 38595 | 2021-04-12 | US | New Jersey | Hunterdon | 34019 | 8965 | 171 | 0 | 40.56335249 | -74.91284156 | 2021-04-13 04:20:37 | Hunterdon, New Jersey, US | |
45881 | 45881 | 2021-11-02 | US | New Jersey | Hunterdon | 34019 | 12110 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-11-03 06:22:09 | Hunterdon, New Jersey, US | |
52957 | 52957 | 2021-05-29 | US | New Jersey | Hunterdon | 34019 | 9777 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-05-30 04:20:55 | Hunterdon, New Jersey, US | |
56968 | 56968 | 2021-03-07 | US | New Jersey | Hunterdon | 34019 | 7165 | 164 | 0 | 40.56335249 | -74.91284156 | 2021-03-08 05:24:48 | Hunterdon, New Jersey, US | |
65239 | 65239 | 2022-11-12 | US | New Jersey | Hunterdon | 34019 | 32032 | 290 | 0 | 40.56335249 | -74.91284156 | 2022-11-13 04:21:14 | Hunterdon, New Jersey, US | |
69230 | 69230 | 2021-09-01 | US | New Jersey | Hunterdon | 34019 | 10738 | 180 | 0 | 40.56335249 | -74.91284156 | 2021-09-02 04:21:15 | Hunterdon, New Jersey, US | |
73264 | 73264 | 2022-02-07 | US | New Jersey | Hunterdon | 34019 | 23675 | 256 | 0 | 40.56335249 | -74.91284156 | 2022-02-08 04:21:15 | Hunterdon, New Jersey, US | |
85260 | 85260 | 2021-05-25 | US | New Jersey | Hunterdon | 34019 | 9758 | 175 | 0 | 40.56335249 | -74.91284156 | 2021-05-26 04:20:35 | Hunterdon, New Jersey, US | |
89298 | 89298 | 2021-11-09 | US | New Jersey | Hunterdon | 34019 | 12211 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-11-10 04:21:38 | Hunterdon, New Jersey, US | |
93316 | 93316 | 2022-07-23 | US | New Jersey | Hunterdon | 34019 | 29006 | 281 | 0 | 40.56335249 | -74.91284156 | 2022-07-24 04:20:47 | Hunterdon, New Jersey, US | |
101499 | 101499 | 2022-01-14 | US | New Jersey | Hunterdon | 34019 | 21410 | 217 | 0 | 40.56335249 | -74.91284156 | 2022-01-15 04:21:07 | Hunterdon, New Jersey, US | |
105495 | 105495 | 2021-08-15 | US | New Jersey | Hunterdon | 34019 | 10347 | 178 | 0 | 40.56335249 | -74.91284156 | 2021-08-16 04:21:31 | Hunterdon, New Jersey, US | |
109619 | 109619 | 2021-06-19 | US | New Jersey | Hunterdon | 34019 | 9848 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-06-20 04:21:48 | Hunterdon, New Jersey, US | |
116926 | 116926 | 2022-09-06 | US | New Jersey | Hunterdon | 34019 | 30379 | 284 | 0 | 40.56335249 | -74.91284156 | 2022-09-07 04:20:59 | Hunterdon, New Jersey, US | |
128906 | 128906 | 2022-01-09 | US | New Jersey | Hunterdon | 34019 | 19705 | 210 | 0 | 40.56335249 | -74.91284156 | 2022-01-10 04:22:07 | Hunterdon, New Jersey, US | |
132927 | 132927 | 2022-10-04 | US | New Jersey | Hunterdon | 34019 | 31137 | 289 | 0 | 40.56335249 | -74.91284156 | 2022-10-05 04:23:06 | Hunterdon, New Jersey, US | |
140144 | 140144 | 2021-12-04 | US | New Jersey | Hunterdon | 34019 | 13245 | 196 | 0 | 40.56335249 | -74.91284156 | 2021-12-05 04:22:25 | Hunterdon, New Jersey, US | |
144162 | 144162 | 2022-07-09 | US | New Jersey | Hunterdon | 34019 | 28459 | 280 | 0 | 40.56335249 | -74.91284156 | 2022-07-10 04:20:54 | Hunterdon, New Jersey, US | |
152157 | 152157 | 2021-11-29 | US | New Jersey | Hunterdon | 34019 | 12938 | 195 | 0 | 40.56335249 | -74.91284156 | 2021-11-30 04:22:53 | Hunterdon, New Jersey, US | |
160186 | 160186 | 2022-03-29 | US | New Jersey | Hunterdon | 34019 | 24490 | 270 | 0 | 40.56335249 | -74.91284156 | 2022-03-30 04:20:45 | Hunterdon, New Jersey, US | |
164201 | 164201 | 2021-11-19 | US | New Jersey | Hunterdon | 34019 | 12559 | 193 | 0 | 40.56335249 | -74.91284156 | 2021-11-20 04:22:17 | Hunterdon, New Jersey, US | |
168219 | 168219 | 2022-06-21 | US | New Jersey | Hunterdon | 34019 | 27863 | 277 | 0 | 40.56335249 | -74.91284156 | 2022-06-22 04:20:54 | Hunterdon, New Jersey, US | |
172209 | 172209 | 2021-04-16 | US | New Jersey | Hunterdon | 34019 | 9163 | 170 | 0 | 40.56335249 | -74.91284156 | 2021-04-17 04:20:40 | Hunterdon, New Jersey, US | |
180195 | 180195 | 2021-09-02 | US | New Jersey | Hunterdon | 34019 | 10773 | 180 | 0 | 40.56335249 | -74.91284156 | 2021-09-03 04:21:20 | Hunterdon, New Jersey, US | |
188244 | 188244 | 2022-02-13 | US | New Jersey | Hunterdon | 34019 | 23858 | 261 | 0 | 40.56335249 | -74.91284156 | 2022-02-14 04:20:51 | Hunterdon, New Jersey, US | |
200436 | 200436 | 2022-10-19 | US | New Jersey | Hunterdon | 34019 | 31548 | 290 | 0 | 40.56335249 | -74.91284156 | 2022-10-20 04:22:59 | Hunterdon, New Jersey, US | |
220157 | 220157 | 2022-12-26 | US | New Jersey | Hunterdon | 34019 | 33156 | 297 | 0 | 40.56335249 | -74.91284156 | 2022-12-27 04:21:07 | Hunterdon, New Jersey, US | |
224169 | 224169 | 2022-05-09 | US | New Jersey | Hunterdon | 34019 | 25694 | 275 | 0 | 40.56335249 | -74.91284156 | 2022-05-10 04:20:50 | Hunterdon, New Jersey, US | |
231401 | 231401 | 2022-05-31 | US | New Jersey | Hunterdon | 34019 | 27068 | 276 | 0 | 40.56335249 | -74.91284156 | 2022-06-01 04:20:55 | Hunterdon, New Jersey, US | |
235416 | 235416 | 2022-02-11 | US | New Jersey | Hunterdon | 34019 | 23797 | 261 | 0 | 40.56335249 | -74.91284156 | 2022-02-12 04:21:06 | Hunterdon, New Jersey, US | |
243420 | 243420 | 2021-04-02 | US | New Jersey | Hunterdon | 34019 | 8492 | 169 | 0 | 40.56335249 | -74.91284156 | 2021-04-03 04:20:44 | Hunterdon, New Jersey, US | |
247438 | 247438 | 2021-08-17 | US | New Jersey | Hunterdon | 34019 | 10381 | 178 | 0 | 40.56335249 | -74.91284156 | 2021-08-18 04:21:35 | Hunterdon, New Jersey, US | |
251452 | 251452 | 2021-09-04 | US | New Jersey | Hunterdon | 34019 | 10816 | 180 | 0 | 40.56335249 | -74.91284156 | 2021-09-05 04:21:33 | Hunterdon, New Jersey, US | |
255488 | 255488 | 2022-09-08 | US | New Jersey | Hunterdon | 34019 | 30448 | 284 | 0 | 40.56335249 | -74.91284156 | 2022-09-09 04:21:11 | Hunterdon, New Jersey, US | |
259507 | 259507 | 2022-12-10 | US | New Jersey | Hunterdon | 34019 | 32646 | 294 | 0 | 40.56335249 | -74.91284156 | 2022-12-11 04:20:50 | Hunterdon, New Jersey, US | |
263706 | 263706 | 2022-03-15 | US | New Jersey | Hunterdon | 34019 | 24278 | 269 | 0 | 40.56335249 | -74.91284156 | 2022-03-16 04:20:50 | Hunterdon, New Jersey, US | |
278356 | 278356 | 2021-11-03 | US | New Jersey | Hunterdon | 34019 | 12118 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-11-04 04:22:20 | Hunterdon, New Jersey, US | |
290168 | 290168 | 2021-10-31 | US | New Jersey | Hunterdon | 34019 | 12086 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-11-01 04:22:01 | Hunterdon, New Jersey, US | |
294190 | 294190 | 2022-11-15 | US | New Jersey | Hunterdon | 34019 | 32118 | 290 | 0 | 40.56335249 | -74.91284156 | 2022-11-16 04:21:09 | Hunterdon, New Jersey, US | |
298181 | 298181 | 2021-07-15 | US | New Jersey | Hunterdon | 34019 | 9945 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-07-16 04:21:22 | Hunterdon, New Jersey, US | |
306042 | 306042 | 2022-04-16 | US | New Jersey | Hunterdon | 34019 | 24902 | 275 | 0 | 40.56335249 | -74.91284156 | 2022-04-17 04:20:59 | Hunterdon, New Jersey, US | |
310062 | 310062 | 2022-12-13 | US | New Jersey | Hunterdon | 34019 | 32751 | 294 | 0 | 40.56335249 | -74.91284156 | 2022-12-14 04:21:04 | Hunterdon, New Jersey, US | |
314078 | 314078 | 2022-11-13 | US | New Jersey | Hunterdon | 34019 | 32032 | 290 | 0 | 40.56335249 | -74.91284156 | 2022-11-14 04:21:09 | Hunterdon, New Jersey, US | |
318090 | 318090 | 2022-02-12 | US | New Jersey | Hunterdon | 34019 | 23838 | 261 | 0 | 40.56335249 | -74.91284156 | 2022-02-13 04:21:00 | Hunterdon, New Jersey, US | |
322110 | 322110 | 2022-10-30 | US | New Jersey | Hunterdon | 34019 | 31745 | 290 | 0 | 40.56335249 | -74.91284156 | 2022-10-31 04:21:36 | Hunterdon, New Jersey, US | |
330084 | 330084 | 2022-12-27 | US | New Jersey | Hunterdon | 34019 | 33260 | 297 | 0 | 40.56335249 | -74.91284156 | 2022-12-28 04:21:04 | Hunterdon, New Jersey, US | |
334075 | 334075 | 2021-08-04 | US | New Jersey | Hunterdon | 34019 | 10124 | 178 | 0 | 40.56335249 | -74.91284156 | 2021-08-05 04:21:51 | Hunterdon, New Jersey, US | |
338110 | 338110 | 2022-03-18 | US | New Jersey | Hunterdon | 34019 | 24344 | 269 | 0 | 40.56335249 | -74.91284156 | 2022-03-19 04:20:47 | Hunterdon, New Jersey, US | |
350474 | 350474 | 2022-12-14 | US | New Jersey | Hunterdon | 34019 | 32777 | 294 | 0 | 40.56335249 | -74.91284156 | 2022-12-15 04:20:58 | Hunterdon, New Jersey, US | |
354459 | 354459 | 2021-03-11 | US | New Jersey | Hunterdon | 34019 | 7309 | 165 | 0 | 40.56335249 | -74.91284156 | 2021-03-12 05:26:50 | Hunterdon, New Jersey, US | |
358500 | 358500 | 2022-03-11 | US | New Jersey | Hunterdon | 34019 | 24229 | 269 | 0 | 40.56335249 | -74.91284156 | 2022-03-12 04:20:50 | Hunterdon, New Jersey, US | |
362516 | 362516 | 2022-05-07 | US | New Jersey | Hunterdon | 34019 | 25638 | 275 | 0 | 40.56335249 | -74.91284156 | 2022-05-08 04:20:49 | Hunterdon, New Jersey, US | |
374374 | 374374 | 2022-09-13 | US | New Jersey | Hunterdon | 34019 | 30588 | 285 | 0 | 40.56335249 | -74.91284156 | 2022-09-14 04:20:44 | Hunterdon, New Jersey, US | |
382358 | 382358 | 2021-04-30 | US | New Jersey | Hunterdon | 34019 | 9508 | 172 | 0 | 40.56335249 | -74.91284156 | 2021-05-01 04:20:47 | Hunterdon, New Jersey, US | |
386401 | 386401 | 2022-09-23 | US | New Jersey | Hunterdon | 34019 | 30884 | 286 | 0 | 40.56335249 | -74.91284156 | 2022-09-24 04:21:40 | Hunterdon, New Jersey, US | |
390388 | 390388 | 2021-04-04 | US | New Jersey | Hunterdon | 34019 | 8601 | 169 | 0 | 40.56335249 | -74.91284156 | 2021-04-05 04:20:35 | Hunterdon, New Jersey, US | |
398442 | 398442 | 2022-10-07 | US | New Jersey | Hunterdon | 34019 | 31234 | 289 | 0 | 40.56335249 | -74.91284156 | 2022-10-08 04:22:56 | Hunterdon, New Jersey, US | |
402433 | 402433 | 2021-06-29 | US | New Jersey | Hunterdon | 34019 | 9888 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-06-30 04:21:41 | Hunterdon, New Jersey, US | |
406467 | 406467 | 2021-12-07 | US | New Jersey | Hunterdon | 34019 | 13381 | 196 | 0 | 40.56335249 | -74.91284156 | 2021-12-08 04:22:46 | Hunterdon, New Jersey, US | |
410463 | 410463 | 2021-07-28 | US | New Jersey | Hunterdon | 34019 | 10034 | 177 | 0 | 40.56335249 | -74.91284156 | 2021-07-29 04:21:33 | Hunterdon, New Jersey, US | |
421513 | 421513 | 2022-09-18 | US | New Jersey | Hunterdon | 34019 | 30749 | 285 | 0 | 40.56335249 | -74.91284156 | 2022-09-19 04:21:49 | Hunterdon, New Jersey, US | |
425523 | 425523 | 2021-10-10 | US | New Jersey | Hunterdon | 34019 | 11634 | 189 | 0 | 40.56335249 | -74.91284156 | 2021-10-11 04:21:31 | Hunterdon, New Jersey, US | |
433535 | 433535 | 2022-11-03 | US | New Jersey | Hunterdon | 34019 | 31867 | 290 | 0 | 40.56335249 | -74.91284156 | 2022-11-04 04:22:11 | Hunterdon, New Jersey, US | |
445527 | 445527 | 2021-10-20 | US | New Jersey | Hunterdon | 34019 | 11881 | 191 | 0 | 40.56335249 | -74.91284156 | 2021-10-21 04:21:18 | Hunterdon, New Jersey, US | |
449544 | 449544 | 2021-11-17 | US | New Jersey | Hunterdon | 34019 | 12453 | 193 | 0 | 40.56335249 | -74.91284156 | 2021-11-18 04:21:33 | Hunterdon, New Jersey, US | |
453565 | 453565 | 2022-12-21 | US | New Jersey | Hunterdon | 34019 | 33032 | 297 | 0 | 40.56335249 | -74.91284156 | 2022-12-22 04:20:56 | Hunterdon, New Jersey, US | |
461553 | 461553 | 2022-02-02 | US | New Jersey | Hunterdon | 34019 | 23474 | 252 | 0 | 40.56335249 | -74.91284156 | 2022-02-03 04:21:21 | Hunterdon, New Jersey, US | |
465570 | 465570 | 2022-05-02 | US | New Jersey | Hunterdon | 34019 | 25386 | 275 | 0 | 40.56335249 | -74.91284156 | 2022-05-03 04:21:00 | Hunterdon, New Jersey, US | |
469584 | 469584 | 2021-10-07 | US | New Jersey | Hunterdon | 34019 | 11548 | 187 | 0 | 40.56335249 | -74.91284156 | 2021-10-08 04:21:25 | Hunterdon, New Jersey, US | |
477617 | 477617 | 2022-06-26 | US | New Jersey | Hunterdon | 34019 | 28057 | 278 | 0 | 40.56335249 | -74.91284156 | 2022-06-27 04:21:00 | Hunterdon, New Jersey, US | |
481768 | 481768 | 2022-11-08 | US | New Jersey | Hunterdon | 34019 | 31973 | 290 | 0 | 40.56335249 | -74.91284156 | 2022-11-09 04:21:22 | Hunterdon, New Jersey, US | |
485759 | 485759 | 2021-07-19 | US | New Jersey | Hunterdon | 34019 | 9967 | 177 | 0 | 40.56335249 | -74.91284156 | 2021-07-20 04:21:48 | Hunterdon, New Jersey, US | |
489798 | 489798 | 2022-11-25 | US | New Jersey | Hunterdon | 34019 | 32275 | 294 | 0 | 40.56335249 | -74.91284156 | 2022-11-26 04:21:11 | Hunterdon, New Jersey, US | |
493808 | 493808 | 2021-10-14 | US | New Jersey | Hunterdon | 34019 | 11742 | 190 | 0 | 40.56335249 | -74.91284156 | 2021-10-15 04:21:26 | Hunterdon, New Jersey, US | |
497825 | 497825 | 2021-11-06 | US | New Jersey | Hunterdon | 34019 | 12165 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-11-07 04:21:53 | Hunterdon, New Jersey, US | |
501842 | 501842 | 2022-04-02 | US | New Jersey | Hunterdon | 34019 | 24562 | 271 | 0 | 40.56335249 | -74.91284156 | 2022-04-03 04:20:48 | Hunterdon, New Jersey, US | |
505862 | 505862 | 2022-12-17 | US | New Jersey | Hunterdon | 34019 | 32852 | 294 | 0 | 40.56335249 | -74.91284156 | 2022-12-18 04:21:03 | Hunterdon, New Jersey, US | |
509853 | 509853 | 2021-08-14 | US | New Jersey | Hunterdon | 34019 | 10336 | 178 | 0 | 40.56335249 | -74.91284156 | 2021-08-15 04:21:41 | Hunterdon, New Jersey, US | |
513867 | 513867 | 2021-08-19 | US | New Jersey | Hunterdon | 34019 | 10426 | 178 | 0 | 40.56335249 | -74.91284156 | 2021-08-20 04:21:33 | Hunterdon, New Jersey, US | |
517906 | 517906 | 2022-10-15 | US | New Jersey | Hunterdon | 34019 | 31451 | 289 | 0 | 40.56335249 | -74.91284156 | 2022-10-16 04:22:39 | Hunterdon, New Jersey, US | |
525023 | 525023 | 2021-06-09 | US | New Jersey | Hunterdon | 34019 | 9814 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-06-10 04:23:17 | Hunterdon, New Jersey, US | |
536908 | 536908 | 2021-10-27 | US | New Jersey | Hunterdon | 34019 | 12016 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-10-28 04:22:08 | Hunterdon, New Jersey, US | |
540930 | 540930 | 2022-10-26 | US | New Jersey | Hunterdon | 34019 | 31678 | 290 | 0 | 40.56335249 | -74.91284156 | 2022-10-27 04:22:01 | Hunterdon, New Jersey, US | |
544946 | 544946 | 2022-12-15 | US | New Jersey | Hunterdon | 34019 | 32822 | 294 | 0 | 40.56335249 | -74.91284156 | 2022-12-16 04:21:01 | Hunterdon, New Jersey, US | |
552947 | 552947 | 2021-12-08 | US | New Jersey | Hunterdon | 34019 | 13448 | 196 | 0 | 40.56335249 | -74.91284156 | 2021-12-09 04:22:49 | Hunterdon, New Jersey, US | |
556963 | 556963 | 2022-01-16 | US | New Jersey | Hunterdon | 34019 | 21836 | 220 | 0 | 40.56335249 | -74.91284156 | 2022-01-17 04:21:08 | Hunterdon, New Jersey, US | |
560981 | 560981 | 2022-06-16 | US | New Jersey | Hunterdon | 34019 | 27713 | 277 | 0 | 40.56335249 | -74.91284156 | 2022-06-17 04:20:56 | Hunterdon, New Jersey, US | |
565135 | 565135 | 2021-06-22 | US | New Jersey | Hunterdon | 34019 | 9856 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-06-23 04:21:46 | Hunterdon, New Jersey, US | |
569276 | 569276 | 2021-10-29 | US | New Jersey | Hunterdon | 34019 | 12047 | 192 | 0 | 40.56335249 | -74.91284156 | 2021-10-30 04:22:03 | Hunterdon, New Jersey, US | |
577006 | 577006 | 2022-02-25 | US | New Jersey | Hunterdon | 34019 | 24055 | 269 | 0 | 40.56335249 | -74.91284156 | 2022-02-26 04:21:12 | Hunterdon, New Jersey, US | |
581001 | 581001 | 2021-07-13 | US | New Jersey | Hunterdon | 34019 | 9937 | 176 | 0 | 40.56335249 | -74.91284156 | 2021-07-14 04:21:35 | Hunterdon, New Jersey, US | |
591797 | 591797 | 2021-08-08 | US | New Jersey | Hunterdon | 34019 | 10220 | 178 | 0 | 40.56335249 | -74.91284156 | 2021-08-09 04:21:24 | Hunterdon, New Jersey, US | |
595833 | 595833 | 2022-07-01 | US | New Jersey | Hunterdon | 34019 | 28234 | 280 | 0 | 40.56335249 | -74.91284156 | 2022-07-02 04:21:16 | Hunterdon, New Jersey, 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]);