johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66,723 rows where province_or_state = "Louisiana" sorted by latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
353827 | 353827 | 2021-03-11 | US | Louisiana | Terrebonne | 22109 | 9710 | 209 | 0 | 29.37343766 | -90.82626855 | 2021-03-12 05:26:50 | Terrebonne, Louisiana, US | |
357868 | 357868 | 2022-03-11 | US | Louisiana | Terrebonne | 22109 | 30771 | 408 | 0 | 29.37343766 | -90.82626855 | 2022-03-12 04:20:50 | Terrebonne, Louisiana, US | |
361884 | 361884 | 2022-05-07 | US | Louisiana | Terrebonne | 22109 | 30943 | 419 | 0 | 29.37343766 | -90.82626855 | 2022-05-08 04:20:49 | Terrebonne, Louisiana, US | |
366763 | 366763 | 2020-07-16 | US | Louisiana | Terrebonne | 22109 | 1901 | 67 | 0 | 1834 | 29.37343766 | -90.82626855 | 2020-07-17 04:34:50 | Terrebonne, Louisiana, US |
370714 | 370714 | 2020-08-08 | US | Louisiana | Terrebonne | 22109 | 2986 | 85 | 0 | 2901 | 29.37343766 | -90.82626855 | 2020-08-09 04:34:54 | Terrebonne, Louisiana, US |
373742 | 373742 | 2022-09-13 | US | Louisiana | Terrebonne | 22109 | 36593 | 429 | 0 | 29.37343766 | -90.82626855 | 2022-09-14 04:20:44 | Terrebonne, Louisiana, US | |
377710 | 377710 | 2020-11-06 | US | Louisiana | Terrebonne | 22109 | 3922 | 126 | 0 | 3796 | 29.37343766 | -90.82626855 | 2020-11-07 05:24:52 | Terrebonne, Louisiana, US |
381726 | 381726 | 2021-04-30 | US | Louisiana | Terrebonne | 22109 | 10100 | 220 | 0 | 29.37343766 | -90.82626855 | 2021-05-01 04:20:47 | Terrebonne, Louisiana, US | |
385769 | 385769 | 2022-09-23 | US | Louisiana | Terrebonne | 22109 | 36729 | 430 | 0 | 29.37343766 | -90.82626855 | 2022-09-24 04:21:40 | Terrebonne, Louisiana, US | |
389756 | 389756 | 2021-04-04 | US | Louisiana | Terrebonne | 22109 | 9867 | 218 | 0 | 29.37343766 | -90.82626855 | 2021-04-05 04:20:35 | Terrebonne, Louisiana, US | |
393764 | 393764 | 2020-11-27 | US | Louisiana | Terrebonne | 22109 | 4455 | 136 | 0 | 4319 | 29.37343766 | -90.82626855 | 2020-11-28 05:25:50 | Terrebonne, Louisiana, US |
397810 | 397810 | 2022-10-07 | US | Louisiana | Terrebonne | 22109 | 36817 | 432 | 0 | 29.37343766 | -90.82626855 | 2022-10-08 04:22:56 | Terrebonne, Louisiana, US | |
401801 | 401801 | 2021-06-29 | US | Louisiana | Terrebonne | 22109 | 10964 | 226 | 0 | 29.37343766 | -90.82626855 | 2021-06-30 04:21:41 | Terrebonne, Louisiana, US | |
405835 | 405835 | 2021-12-07 | US | Louisiana | Terrebonne | 22109 | 19859 | 357 | 0 | 29.37343766 | -90.82626855 | 2021-12-08 04:22:46 | Terrebonne, Louisiana, US | |
409831 | 409831 | 2021-07-28 | US | Louisiana | Terrebonne | 22109 | 12341 | 233 | 0 | 29.37343766 | -90.82626855 | 2021-07-29 04:21:33 | Terrebonne, Louisiana, US | |
414707 | 414707 | 2020-07-05 | US | Louisiana | Terrebonne | 22109 | 1228 | 61 | 0 | 1167 | 29.37343766 | -90.82626855 | 2020-07-06 04:33:57 | Terrebonne, Louisiana, US |
418333 | 418333 | 2020-04-18 | US | Louisiana | Terrebonne | 22109 | 310 | 21 | 0 | 289 | 29.37343766 | -90.82626855 | 2020-04-18 22:32:47 | Terrebonne, Louisiana, US |
420881 | 420881 | 2022-09-18 | US | Louisiana | Terrebonne | 22109 | 36637 | 429 | 0 | 29.37343766 | -90.82626855 | 2022-09-19 04:21:49 | Terrebonne, Louisiana, US | |
424891 | 424891 | 2021-10-10 | US | Louisiana | Terrebonne | 22109 | 19162 | 324 | 0 | 29.37343766 | -90.82626855 | 2021-10-11 04:21:31 | Terrebonne, Louisiana, US | |
428859 | 428859 | 2020-09-07 | US | Louisiana | Terrebonne | 22109 | 3433 | 102 | 0 | 3331 | 29.37343766 | -90.82626855 | 2020-09-08 04:28:25 | Terrebonne, Louisiana, US |
432903 | 432903 | 2022-11-03 | US | Louisiana | Terrebonne | 22109 | 36882 | 433 | 0 | 29.37343766 | -90.82626855 | 2022-11-04 04:22:11 | Terrebonne, Louisiana, US | |
436887 | 436887 | 2021-01-21 | US | Louisiana | Terrebonne | 22109 | 7876 | 166 | 0 | 7710 | 29.37343766 | -90.82626855 | 2021-01-22 05:22:10 | Terrebonne, Louisiana, US |
441871 | 441871 | 2020-07-26 | US | Louisiana | Terrebonne | 22109 | 2453 | 72 | 0 | 2381 | 29.37343766 | -90.82626855 | 2020-07-27 04:35:02 | Terrebonne, Louisiana, US |
444895 | 444895 | 2021-10-20 | US | Louisiana | Terrebonne | 22109 | 19299 | 334 | 0 | 29.37343766 | -90.82626855 | 2021-10-21 04:21:18 | Terrebonne, Louisiana, US | |
448912 | 448912 | 2021-11-17 | US | Louisiana | Terrebonne | 22109 | 19575 | 352 | 0 | 29.37343766 | -90.82626855 | 2021-11-18 04:21:33 | Terrebonne, Louisiana, US | |
452933 | 452933 | 2022-12-21 | US | Louisiana | Terrebonne | 22109 | 37428 | 437 | 0 | 29.37343766 | -90.82626855 | 2022-12-22 04:20:56 | Terrebonne, Louisiana, US | |
457898 | 457898 | 2020-08-07 | US | Louisiana | Terrebonne | 22109 | 2986 | 85 | 0 | 2901 | 29.37343766 | -90.82626855 | 2020-08-08 04:34:53 | Terrebonne, Louisiana, US |
460921 | 460921 | 2022-02-02 | US | Louisiana | Terrebonne | 22109 | 29432 | 381 | 0 | 29.37343766 | -90.82626855 | 2022-02-03 04:21:21 | Terrebonne, Louisiana, US | |
464938 | 464938 | 2022-05-02 | US | Louisiana | Terrebonne | 22109 | 30906 | 417 | 0 | 29.37343766 | -90.82626855 | 2022-05-03 04:21:00 | Terrebonne, Louisiana, US | |
468952 | 468952 | 2021-10-07 | US | Louisiana | Terrebonne | 22109 | 19154 | 323 | 0 | 29.37343766 | -90.82626855 | 2021-10-08 04:21:25 | Terrebonne, Louisiana, US | |
472943 | 472943 | 2021-02-19 | US | Louisiana | Terrebonne | 22109 | 9281 | 192 | 0 | 9089 | 29.37343766 | -90.82626855 | 2021-02-20 05:22:51 | Terrebonne, Louisiana, US |
476985 | 476985 | 2022-06-26 | US | Louisiana | Terrebonne | 22109 | 32616 | 420 | 0 | 29.37343766 | -90.82626855 | 2022-06-27 04:21:00 | Terrebonne, Louisiana, US | |
481136 | 481136 | 2022-11-08 | US | Louisiana | Terrebonne | 22109 | 36882 | 433 | 0 | 29.37343766 | -90.82626855 | 2022-11-09 04:21:22 | Terrebonne, Louisiana, US | |
485127 | 485127 | 2021-07-19 | US | Louisiana | Terrebonne | 22109 | 11537 | 229 | 0 | 29.37343766 | -90.82626855 | 2021-07-20 04:21:48 | Terrebonne, Louisiana, US | |
489166 | 489166 | 2022-11-25 | US | Louisiana | Terrebonne | 22109 | 36973 | 434 | 0 | 29.37343766 | -90.82626855 | 2022-11-26 04:21:11 | Terrebonne, Louisiana, US | |
493176 | 493176 | 2021-10-14 | US | Louisiana | Terrebonne | 22109 | 19233 | 326 | 0 | 29.37343766 | -90.82626855 | 2021-10-15 04:21:26 | Terrebonne, Louisiana, US | |
497193 | 497193 | 2021-11-06 | US | Louisiana | Terrebonne | 22109 | 19453 | 349 | 0 | 29.37343766 | -90.82626855 | 2021-11-07 04:21:53 | Terrebonne, Louisiana, US | |
501210 | 501210 | 2022-04-02 | US | Louisiana | Terrebonne | 22109 | 30819 | 412 | 0 | 29.37343766 | -90.82626855 | 2022-04-03 04:20:48 | Terrebonne, Louisiana, US | |
505230 | 505230 | 2022-12-17 | US | Louisiana | Terrebonne | 22109 | 37266 | 435 | 0 | 29.37343766 | -90.82626855 | 2022-12-18 04:21:03 | Terrebonne, Louisiana, US | |
509221 | 509221 | 2021-08-14 | US | Louisiana | Terrebonne | 22109 | 15082 | 250 | 0 | 29.37343766 | -90.82626855 | 2021-08-15 04:21:41 | Terrebonne, Louisiana, US | |
513235 | 513235 | 2021-08-19 | US | Louisiana | Terrebonne | 22109 | 16288 | 258 | 0 | 29.37343766 | -90.82626855 | 2021-08-20 04:21:33 | Terrebonne, Louisiana, US | |
517274 | 517274 | 2022-10-15 | US | Louisiana | Terrebonne | 22109 | 36843 | 432 | 0 | 29.37343766 | -90.82626855 | 2022-10-16 04:22:39 | Terrebonne, Louisiana, US | |
521865 | 521865 | 2020-04-21 | US | Louisiana | Terrebonne | 22109 | 346 | 25 | 0 | 321 | 29.37343766 | -90.82626855 | 2020-04-21 23:30:50 | Terrebonne, Louisiana, US |
524391 | 524391 | 2021-06-09 | US | Louisiana | Terrebonne | 22109 | 10733 | 224 | 0 | 29.37343766 | -90.82626855 | 2021-06-10 04:23:17 | Terrebonne, Louisiana, US | |
529269 | 529269 | 2020-07-04 | US | Louisiana | Terrebonne | 22109 | 1147 | 61 | 0 | 1086 | 29.37343766 | -90.82626855 | 2020-07-05 04:33:46 | Terrebonne, Louisiana, US |
532237 | 532237 | 2021-02-22 | US | Louisiana | Terrebonne | 22109 | 9356 | 192 | 0 | 9164 | 29.37343766 | -90.82626855 | 2021-02-23 05:23:41 | Terrebonne, Louisiana, US |
536276 | 536276 | 2021-10-27 | US | Louisiana | Terrebonne | 22109 | 19356 | 340 | 0 | 29.37343766 | -90.82626855 | 2021-10-28 04:22:08 | Terrebonne, Louisiana, US | |
540298 | 540298 | 2022-10-26 | US | Louisiana | Terrebonne | 22109 | 36866 | 432 | 0 | 29.37343766 | -90.82626855 | 2022-10-27 04:22:01 | Terrebonne, Louisiana, US | |
544314 | 544314 | 2022-12-15 | US | Louisiana | Terrebonne | 22109 | 37266 | 435 | 0 | 29.37343766 | -90.82626855 | 2022-12-16 04:21:01 | Terrebonne, Louisiana, US | |
548276 | 548276 | 2020-09-12 | US | Louisiana | Terrebonne | 22109 | 3485 | 106 | 0 | 3379 | 29.37343766 | -90.82626855 | 2020-09-13 04:30:52 | Terrebonne, Louisiana, US |
552315 | 552315 | 2021-12-08 | US | Louisiana | Terrebonne | 22109 | 19878 | 357 | 0 | 29.37343766 | -90.82626855 | 2021-12-09 04:22:49 | Terrebonne, Louisiana, US | |
556331 | 556331 | 2022-01-16 | US | Louisiana | Terrebonne | 22109 | 24742 | 369 | 0 | 29.37343766 | -90.82626855 | 2022-01-17 04:21:08 | Terrebonne, Louisiana, US | |
560349 | 560349 | 2022-06-16 | US | Louisiana | Terrebonne | 22109 | 32127 | 420 | 0 | 29.37343766 | -90.82626855 | 2022-06-17 04:20:56 | Terrebonne, Louisiana, US | |
564503 | 564503 | 2021-06-22 | US | Louisiana | Terrebonne | 22109 | 10892 | 226 | 0 | 29.37343766 | -90.82626855 | 2021-06-23 04:21:46 | Terrebonne, Louisiana, US | |
568644 | 568644 | 2021-10-29 | US | Louisiana | Terrebonne | 22109 | 19389 | 342 | 0 | 29.37343766 | -90.82626855 | 2021-10-30 04:22:03 | Terrebonne, Louisiana, US | |
573432 | 573432 | 2020-06-06 | US | Louisiana | Terrebonne | 22109 | 738 | 55 | 0 | 683 | 29.37343766 | -90.82626855 | 2020-06-07 03:53:30 | Terrebonne, Louisiana, US |
576374 | 576374 | 2022-02-25 | US | Louisiana | Terrebonne | 22109 | 30684 | 403 | 0 | 29.37343766 | -90.82626855 | 2022-02-26 04:21:12 | Terrebonne, Louisiana, US | |
580369 | 580369 | 2021-07-13 | US | Louisiana | Terrebonne | 22109 | 11269 | 228 | 0 | 29.37343766 | -90.82626855 | 2021-07-14 04:21:35 | Terrebonne, Louisiana, US | |
584351 | 584351 | 2020-08-13 | US | Louisiana | Terrebonne | 22109 | 3115 | 86 | 0 | 3029 | 29.37343766 | -90.82626855 | 2020-08-14 04:51:19 | Terrebonne, Louisiana, US |
588675 | 588675 | 2020-04-05 | US | Louisiana | Terrebonne | 22109 | 148 | 8 | 0 | 140 | 29.37343766 | -90.82626855 | 2020-04-05 23:06:45 | Terrebonne, Louisiana, US |
591165 | 591165 | 2021-08-08 | US | Louisiana | Terrebonne | 22109 | 13834 | 236 | 0 | 29.37343766 | -90.82626855 | 2021-08-09 04:21:24 | Terrebonne, Louisiana, US | |
595201 | 595201 | 2022-07-01 | US | Louisiana | Terrebonne | 22109 | 32990 | 420 | 0 | 29.37343766 | -90.82626855 | 2022-07-02 04:21:16 | Terrebonne, Louisiana, US | |
599214 | 599214 | 2021-10-19 | US | Louisiana | Terrebonne | 22109 | 19287 | 333 | 0 | 29.37343766 | -90.82626855 | 2021-10-20 04:21:00 | Terrebonne, Louisiana, US | |
603229 | 603229 | 2021-09-23 | US | Louisiana | Terrebonne | 22109 | 18949 | 301 | 0 | 29.37343766 | -90.82626855 | 2021-09-24 04:21:44 | Terrebonne, Louisiana, US | |
607222 | 607222 | 2021-04-09 | US | Louisiana | Terrebonne | 22109 | 9915 | 219 | 0 | 29.37343766 | -90.82626855 | 2021-04-10 04:20:59 | Terrebonne, Louisiana, US | |
611211 | 611211 | 2020-08-29 | US | Louisiana | Terrebonne | 22109 | 3294 | 97 | 0 | 3197 | 29.37343766 | -90.82626855 | 2020-08-30 04:28:22 | Terrebonne, Louisiana, US |
615219 | 615219 | 2021-02-08 | US | Louisiana | Terrebonne | 22109 | 8993 | 188 | 0 | 8805 | 29.37343766 | -90.82626855 | 2021-02-09 05:23:30 | Terrebonne, Louisiana, US |
619408 | 619408 | 2022-11-05 | US | Louisiana | Terrebonne | 22109 | 36882 | 433 | 0 | 29.37343766 | -90.82626855 | 2022-11-06 04:21:24 | Terrebonne, Louisiana, US | |
623421 | 623421 | 2022-05-22 | US | Louisiana | Terrebonne | 22109 | 31120 | 419 | 0 | 29.37343766 | -90.82626855 | 2022-05-26 04:20:50 | Terrebonne, Louisiana, US | |
627415 | 627415 | 2021-07-10 | US | Louisiana | Terrebonne | 22109 | 11170 | 228 | 0 | 29.37343766 | -90.82626855 | 2021-07-11 04:21:43 | Terrebonne, Louisiana, US | |
631451 | 631451 | 2022-07-12 | US | Louisiana | Terrebonne | 22109 | 33727 | 422 | 0 | 29.37343766 | -90.82626855 | 2022-07-13 04:20:58 | Terrebonne, Louisiana, US | |
635464 | 635464 | 2021-10-13 | US | Louisiana | Terrebonne | 22109 | 19221 | 326 | 0 | 29.37343766 | -90.82626855 | 2021-10-14 04:21:29 | Terrebonne, Louisiana, US | |
639455 | 639455 | 2021-03-31 | US | Louisiana | Terrebonne | 22109 | 9855 | 218 | 0 | 29.37343766 | -90.82626855 | 2021-04-01 04:27:05 | Terrebonne, Louisiana, US | |
643475 | 643475 | 2021-09-07 | US | Louisiana | Terrebonne | 22109 | 18217 | 273 | 0 | 29.37343766 | -90.82626855 | 2021-09-08 04:21:31 | Terrebonne, Louisiana, US | |
647485 | 647485 | 2021-05-05 | US | Louisiana | Terrebonne | 22109 | 10195 | 221 | 0 | 29.37343766 | -90.82626855 | 2021-05-06 04:20:38 | Terrebonne, Louisiana, US | |
651503 | 651503 | 2021-08-09 | US | Louisiana | Terrebonne | 22109 | 14402 | 244 | 0 | 29.37343766 | -90.82626855 | 2021-08-10 04:21:27 | Terrebonne, Louisiana, US | |
655536 | 655536 | 2021-10-22 | US | Louisiana | Terrebonne | 22109 | 19315 | 338 | 0 | 29.37343766 | -90.82626855 | 2021-10-23 04:21:32 | Terrebonne, Louisiana, US | |
659856 | 659856 | 2022-05-13 | US | Louisiana | Terrebonne | 22109 | 31012 | 419 | 0 | 29.37343766 | -90.82626855 | 2022-05-14 04:20:48 | Terrebonne, Louisiana, US | |
663864 | 663864 | 2020-08-11 | US | Louisiana | Terrebonne | 22109 | 3072 | 85 | 0 | 2987 | 29.37343766 | -90.82626855 | 2020-08-12 04:27:29 | Terrebonne, Louisiana, US |
667801 | 667801 | 2020-09-16 | US | Louisiana | Terrebonne | 22109 | 3528 | 108 | 0 | 3420 | 29.37343766 | -90.82626855 | 2020-09-17 04:22:00 | Terrebonne, Louisiana, US |
671842 | 671842 | 2022-07-21 | US | Louisiana | Terrebonne | 22109 | 34420 | 424 | 0 | 29.37343766 | -90.82626855 | 2022-07-22 04:21:15 | Terrebonne, Louisiana, US | |
675858 | 675858 | 2022-07-30 | US | Louisiana | Terrebonne | 22109 | 34873 | 425 | 0 | 29.37343766 | -90.82626855 | 2022-07-31 04:21:02 | Terrebonne, Louisiana, US | |
679841 | 679841 | 2020-11-23 | US | Louisiana | Terrebonne | 22109 | 4362 | 134 | 0 | 4228 | 29.37343766 | -90.82626855 | 2020-11-24 05:27:31 | Terrebonne, Louisiana, US |
683881 | 683881 | 2021-10-24 | US | Louisiana | Terrebonne | 22109 | 19315 | 338 | 0 | 29.37343766 | -90.82626855 | 2021-10-25 04:22:31 | Terrebonne, Louisiana, US | |
687898 | 687898 | 2021-11-13 | US | Louisiana | Terrebonne | 22109 | 19527 | 352 | 0 | 29.37343766 | -90.82626855 | 2021-11-14 04:21:31 | Terrebonne, Louisiana, US | |
691919 | 691919 | 2022-12-23 | US | Louisiana | Terrebonne | 22109 | 37428 | 437 | 0 | 29.37343766 | -90.82626855 | 2022-12-24 04:21:02 | Terrebonne, Louisiana, US | |
695931 | 695931 | 2022-03-17 | US | Louisiana | Terrebonne | 22109 | 30794 | 408 | 0 | 29.37343766 | -90.82626855 | 2022-03-18 04:20:55 | Terrebonne, Louisiana, US | |
699946 | 699946 | 2021-11-04 | US | Louisiana | Terrebonne | 22109 | 19444 | 349 | 0 | 29.37343766 | -90.82626855 | 2021-11-05 04:21:54 | Terrebonne, Louisiana, US | |
703936 | 703936 | 2021-03-16 | US | Louisiana | Terrebonne | 22109 | 9748 | 211 | 0 | 29.37343766 | -90.82626855 | 2021-03-17 05:25:07 | Terrebonne, Louisiana, US | |
707974 | 707974 | 2021-09-29 | US | Louisiana | Terrebonne | 22109 | 19041 | 312 | 0 | 29.37343766 | -90.82626855 | 2021-09-30 04:21:20 | Terrebonne, Louisiana, US | |
711996 | 711996 | 2022-11-01 | US | Louisiana | Terrebonne | 22109 | 36866 | 432 | 0 | 29.37343766 | -90.82626855 | 2022-11-02 04:22:09 | Terrebonne, Louisiana, US | |
716007 | 716007 | 2021-11-12 | US | Louisiana | Terrebonne | 22109 | 19527 | 352 | 0 | 29.37343766 | -90.82626855 | 2021-11-13 04:21:38 | Terrebonne, Louisiana, US | |
720028 | 720028 | 2022-12-04 | US | Louisiana | Terrebonne | 22109 | 37024 | 435 | 0 | 29.37343766 | -90.82626855 | 2022-12-05 04:20:58 | Terrebonne, Louisiana, US | |
724039 | 724039 | 2021-11-20 | US | Louisiana | Terrebonne | 22109 | 19594 | 353 | 0 | 29.37343766 | -90.82626855 | 2021-11-21 04:22:13 | Terrebonne, Louisiana, US | |
728031 | 728031 | 2021-05-22 | US | Louisiana | Terrebonne | 22109 | 10422 | 223 | 0 | 29.37343766 | -90.82626855 | 2021-05-23 04:20:51 | Terrebonne, Louisiana, US | |
732069 | 732069 | 2021-12-27 | US | Louisiana | Terrebonne | 22109 | 20442 | 360 | 0 | 29.37343766 | -90.82626855 | 2021-12-28 04:21:47 | Terrebonne, Louisiana, US | |
736876 | 736876 | 2020-06-12 | US | Louisiana | Terrebonne | 22109 | 780 | 57 | 0 | 723 | 29.37343766 | -90.82626855 | 2020-06-13 03:33:14 | Terrebonne, Louisiana, US |
739830 | 739830 | 2020-12-02 | US | Louisiana | Terrebonne | 22109 | 4637 | 138 | 0 | 4499 | 29.37343766 | -90.82626855 | 2020-12-03 05:28:22 | Terrebonne, Louisiana, US |
743845 | 743845 | 2021-02-20 | US | Louisiana | Terrebonne | 22109 | 9281 | 192 | 0 | 9089 | 29.37343766 | -90.82626855 | 2021-02-21 05:24:33 | Terrebonne, Louisiana, US |
747886 | 747886 | 2022-04-23 | US | Louisiana | Terrebonne | 22109 | 30866 | 416 | 0 | 29.37343766 | -90.82626855 | 2022-04-24 04:20:56 | Terrebonne, Louisiana, 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]);