johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,403 rows where country_or_region = "US" and deaths = 272 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 219
- Ohio 131
- Tennessee 78
- Georgia 67
- South Carolina 62
- Arkansas 60
- Indiana 55
- North Carolina 53
- Maryland 52
- Kentucky 46
- Pennsylvania 45
- Florida 41
- Nevada 36
- Alabama 35
- Virginia 34
- Minnesota 32
- Montana 32
- California 29
- Wisconsin 28
- Louisiana 20
- West Virginia 20
- Missouri 19
- Mississippi 18
- Michigan 17
- Illinois 16
- Oklahoma 15
- Connecticut 14
- New Mexico 13
- Washington 13
- Utah 12
- …
country_or_region 1
- US · 1,403 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754416 | 2754416 | 2022-12-29 | US | Louisiana | Iberia | 22045 | 23480 | 272 | 0 | 29.86803617 | -91.75871777 | 2022-12-30 04:21:04 | Iberia, Louisiana, US | |
2755179 | 2755179 | 2022-12-29 | US | New York | Steuben | 36101 | 24866 | 272 | 0 | 42.2689144 | -77.3829924 | 2022-12-30 04:21:04 | Steuben, New York, US | |
2755571 | 2755571 | 2022-12-29 | US | Pennsylvania | Columbia | 42037 | 18843 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-30 04:21:04 | Columbia, Pennsylvania, US | |
1075422 | 1075422 | 2022-12-28 | US | Louisiana | Iberia | 22045 | 23480 | 272 | 0 | 29.86803617 | -91.75871777 | 2022-12-29 04:21:01 | Iberia, Louisiana, US | |
1076577 | 1076577 | 2022-12-28 | US | Pennsylvania | Columbia | 42037 | 18843 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-29 04:21:01 | Columbia, Pennsylvania, US | |
330574 | 330574 | 2022-12-27 | US | Pennsylvania | Columbia | 42037 | 18742 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-28 04:21:04 | Columbia, Pennsylvania, US | |
220647 | 220647 | 2022-12-26 | US | Pennsylvania | Columbia | 42037 | 18742 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-27 04:21:07 | Columbia, Pennsylvania, US | |
3225104 | 3225104 | 2022-12-25 | US | Pennsylvania | Columbia | 42037 | 18742 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-26 04:21:06 | Columbia, Pennsylvania, US | |
1021018 | 1021018 | 2022-12-24 | US | Pennsylvania | Columbia | 42037 | 18742 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-25 04:21:04 | Columbia, Pennsylvania, US | |
693041 | 693041 | 2022-12-23 | US | Pennsylvania | Columbia | 42037 | 18742 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-24 04:21:02 | Columbia, Pennsylvania, US | |
2182251 | 2182251 | 2022-12-22 | US | Pennsylvania | Columbia | 42037 | 18742 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-23 04:21:04 | Columbia, Pennsylvania, US | |
454055 | 454055 | 2022-12-21 | US | Pennsylvania | Columbia | 42037 | 18742 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-22 04:20:56 | Columbia, Pennsylvania, US | |
2952172 | 2952172 | 2022-12-20 | US | Georgia | Colquitt | 13071 | 12677 | 272 | 0 | 31.18810588 | -83.7677946 | 2022-12-21 04:21:03 | Colquitt, Georgia, US | |
2954054 | 2954054 | 2022-12-20 | US | Pennsylvania | Columbia | 42037 | 18656 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-21 04:21:03 | Columbia, Pennsylvania, US | |
3174574 | 3174574 | 2022-12-19 | US | Georgia | Colquitt | 13071 | 12677 | 272 | 0 | 31.18810588 | -83.7677946 | 2022-12-20 04:21:04 | Colquitt, Georgia, US | |
3176456 | 3176456 | 2022-12-19 | US | Pennsylvania | Columbia | 42037 | 18656 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-20 04:21:04 | Columbia, Pennsylvania, US | |
1629091 | 1629091 | 2022-12-18 | US | Georgia | Colquitt | 13071 | 12677 | 272 | 0 | 31.18810588 | -83.7677946 | 2022-12-19 04:21:03 | Colquitt, Georgia, US | |
1630973 | 1630973 | 2022-12-18 | US | Pennsylvania | Columbia | 42037 | 18656 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-19 04:21:03 | Columbia, Pennsylvania, US | |
504470 | 504470 | 2022-12-17 | US | Georgia | Colquitt | 13071 | 12677 | 272 | 0 | 31.18810588 | -83.7677946 | 2022-12-18 04:21:03 | Colquitt, Georgia, US | |
506352 | 506352 | 2022-12-17 | US | Pennsylvania | Columbia | 42037 | 18656 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-18 04:21:03 | Columbia, Pennsylvania, US | |
3325042 | 3325042 | 2022-12-16 | US | Georgia | Colquitt | 13071 | 12677 | 272 | 0 | 31.18810588 | -83.7677946 | 2022-12-17 04:21:04 | Colquitt, Georgia, US | |
3326924 | 3326924 | 2022-12-16 | US | Pennsylvania | Columbia | 42037 | 18656 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-17 04:21:04 | Columbia, Pennsylvania, US | |
543554 | 543554 | 2022-12-15 | US | Georgia | Colquitt | 13071 | 12677 | 272 | 0 | 31.18810588 | -83.7677946 | 2022-12-16 04:21:01 | Colquitt, Georgia, US | |
545436 | 545436 | 2022-12-15 | US | Pennsylvania | Columbia | 42037 | 18656 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-16 04:21:01 | Columbia, Pennsylvania, US | |
349082 | 349082 | 2022-12-14 | US | Georgia | Colquitt | 13071 | 12677 | 272 | 0 | 31.18810588 | -83.7677946 | 2022-12-15 04:20:58 | Colquitt, Georgia, US | |
350964 | 350964 | 2022-12-14 | US | Pennsylvania | Columbia | 42037 | 18656 | 272 | 0 | 41.04821986 | -76.40565017 | 2022-12-15 04:20:58 | Columbia, Pennsylvania, US | |
311039 | 311039 | 2022-12-13 | US | Texas | Lamar | 48277 | 11420 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-14 04:21:04 | Lamar, Texas, US | |
1151777 | 1151777 | 2022-12-12 | US | South Carolina | Kershaw | 45055 | 26131 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-13 04:21:01 | Kershaw, South Carolina, US | |
1152100 | 1152100 | 2022-12-12 | US | Texas | Lamar | 48277 | 11420 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-13 04:21:01 | Lamar, Texas, US | |
871631 | 871631 | 2022-12-11 | US | South Carolina | Kershaw | 45055 | 26131 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-12 04:21:01 | Kershaw, South Carolina, US | |
871954 | 871954 | 2022-12-11 | US | Texas | Lamar | 48277 | 11420 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-12 04:21:01 | Lamar, Texas, US | |
260161 | 260161 | 2022-12-10 | US | South Carolina | Kershaw | 45055 | 26131 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-11 04:20:50 | Kershaw, South Carolina, US | |
260484 | 260484 | 2022-12-10 | US | Texas | Lamar | 48277 | 11420 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-11 04:20:50 | Lamar, Texas, US | |
3938875 | 3938875 | 2022-12-09 | US | South Carolina | Kershaw | 45055 | 26131 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-10 04:21:02 | Kershaw, South Carolina, US | |
3939198 | 3939198 | 2022-12-09 | US | Texas | Lamar | 48277 | 11420 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-10 04:21:02 | Lamar, Texas, US | |
3380207 | 3380207 | 2022-12-08 | US | South Carolina | Kershaw | 45055 | 26131 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-09 04:21:05 | Kershaw, South Carolina, US | |
3380530 | 3380530 | 2022-12-08 | US | Texas | Lamar | 48277 | 11420 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-09 04:21:05 | Lamar, Texas, US | |
3380686 | 3380686 | 2022-12-08 | US | Virginia | Bedford | 51019 | 20886 | 272 | 0 | 37.3080028 | -79.5281964 | 2022-12-09 04:21:05 | Bedford, Virginia, US | |
1987478 | 1987478 | 2022-12-07 | US | South Carolina | Kershaw | 45055 | 26131 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-08 04:21:07 | Kershaw, South Carolina, US | |
1987801 | 1987801 | 2022-12-07 | US | Texas | Lamar | 48277 | 11420 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-08 04:21:07 | Lamar, Texas, US | |
3717001 | 3717001 | 2022-12-06 | US | South Carolina | Kershaw | 45055 | 26131 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-07 04:20:58 | Kershaw, South Carolina, US | |
3717324 | 3717324 | 2022-12-06 | US | Texas | Lamar | 48277 | 11221 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-07 04:20:58 | Lamar, Texas, US | |
3717383 | 3717383 | 2022-12-06 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-07 04:20:58 | Rockwall, Texas, US | |
2417706 | 2417706 | 2022-12-05 | US | South Carolina | Kershaw | 45055 | 25967 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-06 04:21:03 | Kershaw, South Carolina, US | |
2418029 | 2418029 | 2022-12-05 | US | Texas | Lamar | 48277 | 11221 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-06 04:21:03 | Lamar, Texas, US | |
2418088 | 2418088 | 2022-12-05 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-06 04:21:03 | Rockwall, Texas, US | |
721314 | 721314 | 2022-12-04 | US | South Carolina | Kershaw | 45055 | 25967 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-05 04:20:58 | Kershaw, South Carolina, US | |
721637 | 721637 | 2022-12-04 | US | Texas | Lamar | 48277 | 11221 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-05 04:20:58 | Lamar, Texas, US | |
721696 | 721696 | 2022-12-04 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-05 04:20:58 | Rockwall, Texas, US | |
2819603 | 2819603 | 2022-12-03 | US | South Carolina | Kershaw | 45055 | 25967 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-04 04:20:56 | Kershaw, South Carolina, US | |
2819926 | 2819926 | 2022-12-03 | US | Texas | Lamar | 48277 | 11221 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-04 04:20:56 | Lamar, Texas, US | |
2819985 | 2819985 | 2022-12-03 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-04 04:20:56 | Rockwall, Texas, US | |
836459 | 836459 | 2022-12-02 | US | South Carolina | Kershaw | 45055 | 25967 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-03 04:21:02 | Kershaw, South Carolina, US | |
836782 | 836782 | 2022-12-02 | US | Texas | Lamar | 48277 | 11221 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-03 04:21:02 | Lamar, Texas, US | |
836841 | 836841 | 2022-12-02 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-03 04:21:02 | Rockwall, Texas, US | |
2138989 | 2138989 | 2022-12-01 | US | South Carolina | Kershaw | 45055 | 25967 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-02 04:21:07 | Kershaw, South Carolina, US | |
2139312 | 2139312 | 2022-12-01 | US | Texas | Lamar | 48277 | 11221 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-02 04:21:07 | Lamar, Texas, US | |
2139371 | 2139371 | 2022-12-01 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-02 04:21:07 | Rockwall, Texas, US | |
2139503 | 2139503 | 2022-12-01 | US | Virginia | Frederick | 51069 | 25366 | 272 | 0 | 39.20172582 | -78.25974949 | 2022-12-02 04:21:07 | Frederick, Virginia, US | |
1967405 | 1967405 | 2022-11-30 | US | South Carolina | Kershaw | 45055 | 25967 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-12-01 04:21:03 | Kershaw, South Carolina, US | |
1967728 | 1967728 | 2022-11-30 | US | Texas | Lamar | 48277 | 11221 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-12-01 04:21:03 | Lamar, Texas, US | |
1967787 | 1967787 | 2022-11-30 | US | Texas | Rockwall | 48397 | 30355 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-12-01 04:21:03 | Rockwall, Texas, US | |
1967919 | 1967919 | 2022-11-30 | US | Virginia | Frederick | 51069 | 25349 | 272 | 0 | 39.20172582 | -78.25974949 | 2022-12-01 04:21:03 | Frederick, Virginia, US | |
2556952 | 2556952 | 2022-11-29 | US | Alabama | Colbert | 1033 | 19801 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-30 04:21:07 | Colbert, Alabama, US | |
2559419 | 2559419 | 2022-11-29 | US | South Carolina | Kershaw | 45055 | 25967 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-30 04:21:07 | Kershaw, South Carolina, US | |
2559742 | 2559742 | 2022-11-29 | US | Texas | Lamar | 48277 | 11128 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-11-30 04:21:07 | Lamar, Texas, US | |
2559801 | 2559801 | 2022-11-29 | US | Texas | Rockwall | 48397 | 30335 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-30 04:21:07 | Rockwall, Texas, US | |
1240026 | 1240026 | 2022-11-28 | US | Alabama | Colbert | 1033 | 19801 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-29 04:21:05 | Colbert, Alabama, US | |
1242493 | 1242493 | 2022-11-28 | US | South Carolina | Kershaw | 45055 | 25905 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-29 04:21:05 | Kershaw, South Carolina, US | |
1242816 | 1242816 | 2022-11-28 | US | Texas | Lamar | 48277 | 11128 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-11-29 04:21:05 | Lamar, Texas, US | |
1242875 | 1242875 | 2022-11-28 | US | Texas | Rockwall | 48397 | 30335 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-29 04:21:05 | Rockwall, Texas, US | |
3552014 | 3552014 | 2022-11-27 | US | Alabama | Colbert | 1033 | 19801 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-28 04:21:02 | Colbert, Alabama, US | |
3554481 | 3554481 | 2022-11-27 | US | South Carolina | Kershaw | 45055 | 25905 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-28 04:21:02 | Kershaw, South Carolina, US | |
3554804 | 3554804 | 2022-11-27 | US | Texas | Lamar | 48277 | 11120 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-11-28 04:21:02 | Lamar, Texas, US | |
3554863 | 3554863 | 2022-11-27 | US | Texas | Rockwall | 48397 | 30287 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-28 04:21:02 | Rockwall, Texas, US | |
2100494 | 2100494 | 2022-11-26 | US | Alabama | Colbert | 1033 | 19801 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-27 04:21:05 | Colbert, Alabama, US | |
2102961 | 2102961 | 2022-11-26 | US | South Carolina | Kershaw | 45055 | 25905 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-27 04:21:05 | Kershaw, South Carolina, US | |
2103284 | 2103284 | 2022-11-26 | US | Texas | Lamar | 48277 | 11120 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-11-27 04:21:05 | Lamar, Texas, US | |
2103343 | 2103343 | 2022-11-26 | US | Texas | Rockwall | 48397 | 30287 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-27 04:21:05 | Rockwall, Texas, US | |
487985 | 487985 | 2022-11-25 | US | Alabama | Colbert | 1033 | 19801 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-26 04:21:11 | Colbert, Alabama, US | |
490452 | 490452 | 2022-11-25 | US | South Carolina | Kershaw | 45055 | 25905 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-26 04:21:11 | Kershaw, South Carolina, US | |
490775 | 490775 | 2022-11-25 | US | Texas | Lamar | 48277 | 11120 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-11-26 04:21:11 | Lamar, Texas, US | |
490834 | 490834 | 2022-11-25 | US | Texas | Rockwall | 48397 | 30287 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-26 04:21:11 | Rockwall, Texas, US | |
3523814 | 3523814 | 2022-11-24 | US | Alabama | Colbert | 1033 | 19801 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-25 04:21:06 | Colbert, Alabama, US | |
3526281 | 3526281 | 2022-11-24 | US | South Carolina | Kershaw | 45055 | 25905 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-25 04:21:06 | Kershaw, South Carolina, US | |
3526604 | 3526604 | 2022-11-24 | US | Texas | Lamar | 48277 | 11120 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-11-25 04:21:06 | Lamar, Texas, US | |
3526663 | 3526663 | 2022-11-24 | US | Texas | Rockwall | 48397 | 30287 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-25 04:21:06 | Rockwall, Texas, US | |
3312597 | 3312597 | 2022-11-23 | US | Alabama | Colbert | 1033 | 19801 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-24 04:21:09 | Colbert, Alabama, US | |
3315064 | 3315064 | 2022-11-23 | US | South Carolina | Kershaw | 45055 | 25905 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-24 04:21:09 | Kershaw, South Carolina, US | |
3315387 | 3315387 | 2022-11-23 | US | Texas | Lamar | 48277 | 11120 | 272 | 0 | 33.66981763 | -95.57404777 | 2022-11-24 04:21:09 | Lamar, Texas, US | |
3315446 | 3315446 | 2022-11-23 | US | Texas | Rockwall | 48397 | 30287 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-24 04:21:09 | Rockwall, Texas, US | |
1620638 | 1620638 | 2022-11-22 | US | Alabama | Colbert | 1033 | 19757 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-23 04:21:06 | Colbert, Alabama, US | |
1621172 | 1621172 | 2022-11-22 | US | Georgia | Walker | 13295 | 19280 | 272 | 0 | 34.73376362 | -85.30165174 | 2022-11-23 04:21:06 | Walker, Georgia, US | |
1623105 | 1623105 | 2022-11-22 | US | South Carolina | Kershaw | 45055 | 25905 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-23 04:21:06 | Kershaw, South Carolina, US | |
1623487 | 1623487 | 2022-11-22 | US | Texas | Rockwall | 48397 | 30268 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-23 04:21:06 | Rockwall, Texas, US | |
3460526 | 3460526 | 2022-11-21 | US | Alabama | Colbert | 1033 | 19757 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-22 04:20:47 | Colbert, Alabama, US | |
3461060 | 3461060 | 2022-11-21 | US | Georgia | Walker | 13295 | 19280 | 272 | 0 | 34.73376362 | -85.30165174 | 2022-11-22 04:20:47 | Walker, Georgia, US | |
3462993 | 3462993 | 2022-11-21 | US | South Carolina | Kershaw | 45055 | 25865 | 272 | 0 | 34.33988254 | -80.58763164 | 2022-11-22 04:20:47 | Kershaw, South Carolina, US | |
3463375 | 3463375 | 2022-11-21 | US | Texas | Rockwall | 48397 | 30268 | 272 | 0 | 32.89779518 | -96.40771592 | 2022-11-22 04:20:47 | Rockwall, Texas, US | |
1640711 | 1640711 | 2022-11-20 | US | Alabama | Colbert | 1033 | 19757 | 272 | 0 | 34.69847452 | -87.80168544 | 2022-11-21 04:21:05 | Colbert, Alabama, 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]);