johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
562 rows where deaths = 549 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 388
- Russia 55
- Colombia 29
- Sweden 29
- Japan 10
- Italy 6
- Ukraine 6
- Spain 4
- Luxembourg 3
- Mali 3
- Angola 2
- Chile 2
- Germany 2
- Guyana 2
- India 2
- Peru 2
- Albania 1
- Canada 1
- El Salvador 1
- Greece 1
- Iraq 1
- Korea, South 1
- Mainland China 1
- Malaysia 1
- Moldova 1
- Montenegro 1
- Nigeria 1
- North Macedonia 1
- Pakistan 1
- Qatar 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755703 | 2755703 | 2022-12-29 | US | Rhode Island | Kent | 44003 | 61830 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-30 04:21:04 | Kent, Rhode Island, US | |
2755204 | 2755204 | 2022-12-29 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-30 04:21:04 | Cabarrus, North Carolina, US | |
1076709 | 1076709 | 2022-12-28 | US | Rhode Island | Kent | 44003 | 61830 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-29 04:21:01 | Kent, Rhode Island, US | |
1076210 | 1076210 | 2022-12-28 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-29 04:21:01 | Cabarrus, North Carolina, US | |
1075692 | 1075692 | 2022-12-28 | US | Minnesota | Washington | 27163 | 80632 | 549 | 0 | 45.03864533 | -92.88429635 | 2022-12-29 04:21:01 | Washington, Minnesota, US | |
1074228 | 1074228 | 2022-12-28 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-29 04:21:01 | Halland, Sweden | |||
330806 | 330806 | 2022-12-27 | US | South Dakota | Minnehaha | 46099 | 63742 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-28 04:21:04 | Minnehaha, South Dakota, US | |
330706 | 330706 | 2022-12-27 | US | Rhode Island | Kent | 44003 | 61830 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-28 04:21:04 | Kent, Rhode Island, US | |
330207 | 330207 | 2022-12-27 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-28 04:21:04 | Cabarrus, North Carolina, US | |
329689 | 329689 | 2022-12-27 | US | Minnesota | Washington | 27163 | 80632 | 549 | 0 | 45.03864533 | -92.88429635 | 2022-12-28 04:21:04 | Washington, Minnesota, US | |
328225 | 328225 | 2022-12-27 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-28 04:21:04 | Halland, Sweden | |||
220879 | 220879 | 2022-12-26 | US | South Dakota | Minnehaha | 46099 | 63742 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-27 04:21:07 | Minnehaha, South Dakota, US | |
220779 | 220779 | 2022-12-26 | US | Rhode Island | Kent | 44003 | 61830 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-27 04:21:07 | Kent, Rhode Island, US | |
220280 | 220280 | 2022-12-26 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-27 04:21:07 | Cabarrus, North Carolina, US | |
219762 | 219762 | 2022-12-26 | US | Minnesota | Washington | 27163 | 80632 | 549 | 0 | 45.03864533 | -92.88429635 | 2022-12-27 04:21:07 | Washington, Minnesota, US | |
218298 | 218298 | 2022-12-26 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-27 04:21:07 | Halland, Sweden | |||
3225336 | 3225336 | 2022-12-25 | US | South Dakota | Minnehaha | 46099 | 63742 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-26 04:21:06 | Minnehaha, South Dakota, US | |
3225236 | 3225236 | 2022-12-25 | US | Rhode Island | Kent | 44003 | 61830 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-26 04:21:06 | Kent, Rhode Island, US | |
3224737 | 3224737 | 2022-12-25 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-26 04:21:06 | Cabarrus, North Carolina, US | |
3224219 | 3224219 | 2022-12-25 | US | Minnesota | Washington | 27163 | 80632 | 549 | 0 | 45.03864533 | -92.88429635 | 2022-12-26 04:21:06 | Washington, Minnesota, US | |
3222755 | 3222755 | 2022-12-25 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-26 04:21:06 | Halland, Sweden | |||
1021250 | 1021250 | 2022-12-24 | US | South Dakota | Minnehaha | 46099 | 63742 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-25 04:21:04 | Minnehaha, South Dakota, US | |
1021150 | 1021150 | 2022-12-24 | US | Rhode Island | Kent | 44003 | 61830 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-25 04:21:04 | Kent, Rhode Island, US | |
1020651 | 1020651 | 2022-12-24 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-25 04:21:04 | Cabarrus, North Carolina, US | |
1020133 | 1020133 | 2022-12-24 | US | Minnesota | Washington | 27163 | 80632 | 549 | 0 | 45.03864533 | -92.88429635 | 2022-12-25 04:21:04 | Washington, Minnesota, US | |
1018669 | 1018669 | 2022-12-24 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-25 04:21:04 | Halland, Sweden | |||
693273 | 693273 | 2022-12-23 | US | South Dakota | Minnehaha | 46099 | 63742 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-24 04:21:02 | Minnehaha, South Dakota, US | |
693173 | 693173 | 2022-12-23 | US | Rhode Island | Kent | 44003 | 61830 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-24 04:21:02 | Kent, Rhode Island, US | |
692674 | 692674 | 2022-12-23 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-24 04:21:02 | Cabarrus, North Carolina, US | |
692156 | 692156 | 2022-12-23 | US | Minnesota | Washington | 27163 | 80632 | 549 | 0 | 45.03864533 | -92.88429635 | 2022-12-24 04:21:02 | Washington, Minnesota, US | |
690692 | 690692 | 2022-12-23 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-24 04:21:02 | Halland, Sweden | |||
2182483 | 2182483 | 2022-12-22 | US | South Dakota | Minnehaha | 46099 | 63742 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-23 04:21:04 | Minnehaha, South Dakota, US | |
2182383 | 2182383 | 2022-12-22 | US | Rhode Island | Kent | 44003 | 61830 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-23 04:21:04 | Kent, Rhode Island, US | |
2181884 | 2181884 | 2022-12-22 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-23 04:21:04 | Cabarrus, North Carolina, US | |
2181366 | 2181366 | 2022-12-22 | US | Minnesota | Washington | 27163 | 80632 | 549 | 0 | 45.03864533 | -92.88429635 | 2022-12-23 04:21:04 | Washington, Minnesota, US | |
2179902 | 2179902 | 2022-12-22 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-23 04:21:04 | Halland, Sweden | |||
454287 | 454287 | 2022-12-21 | US | South Dakota | Minnehaha | 46099 | 63742 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-22 04:20:56 | Minnehaha, South Dakota, US | |
454187 | 454187 | 2022-12-21 | US | Rhode Island | Kent | 44003 | 61543 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-22 04:20:56 | Kent, Rhode Island, US | |
453688 | 453688 | 2022-12-21 | US | North Carolina | Cabarrus | 37025 | 69043 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-22 04:20:56 | Cabarrus, North Carolina, US | |
451712 | 451712 | 2022-12-21 | Sweden | Orebro | 101556 | 549 | 0 | 59.535 | 15.0066 | 2022-12-22 04:20:56 | Orebro, Sweden | |||
2954506 | 2954506 | 2022-12-20 | US | Texas | Hays | 48209 | 75903 | 549 | 0 | 30.05669873 | -98.02944344 | 2022-12-21 04:21:03 | Hays, Texas, US | |
2954286 | 2954286 | 2022-12-20 | US | South Dakota | Minnehaha | 46099 | 63548 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-21 04:21:03 | Minnehaha, South Dakota, US | |
2954186 | 2954186 | 2022-12-20 | US | Rhode Island | Kent | 44003 | 61543 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-21 04:21:03 | Kent, Rhode Island, US | |
2953687 | 2953687 | 2022-12-20 | US | North Carolina | Cabarrus | 37025 | 68720 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-21 04:21:03 | Cabarrus, North Carolina, US | |
2952184 | 2952184 | 2022-12-20 | US | Georgia | Dougherty | 13095 | 23221 | 549 | 0 | 31.53328528 | -84.21722377 | 2022-12-21 04:21:03 | Dougherty, Georgia, US | |
2951711 | 2951711 | 2022-12-20 | Sweden | Orebro | 101556 | 549 | 0 | 59.535 | 15.0066 | 2022-12-21 04:21:03 | Orebro, Sweden | |||
3176908 | 3176908 | 2022-12-19 | US | Texas | Hays | 48209 | 75903 | 549 | 0 | 30.05669873 | -98.02944344 | 2022-12-20 04:21:04 | Hays, Texas, US | |
3176688 | 3176688 | 2022-12-19 | US | South Dakota | Minnehaha | 46099 | 63548 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-20 04:21:04 | Minnehaha, South Dakota, US | |
3176588 | 3176588 | 2022-12-19 | US | Rhode Island | Kent | 44003 | 61543 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-20 04:21:04 | Kent, Rhode Island, US | |
3176089 | 3176089 | 2022-12-19 | US | North Carolina | Cabarrus | 37025 | 68720 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-20 04:21:04 | Cabarrus, North Carolina, US | |
3174586 | 3174586 | 2022-12-19 | US | Georgia | Dougherty | 13095 | 23221 | 549 | 0 | 31.53328528 | -84.21722377 | 2022-12-20 04:21:04 | Dougherty, Georgia, US | |
3174113 | 3174113 | 2022-12-19 | Sweden | Orebro | 101556 | 549 | 0 | 59.535 | 15.0066 | 2022-12-20 04:21:04 | Orebro, Sweden | |||
1631425 | 1631425 | 2022-12-18 | US | Texas | Hays | 48209 | 75903 | 549 | 0 | 30.05669873 | -98.02944344 | 2022-12-19 04:21:03 | Hays, Texas, US | |
1631205 | 1631205 | 2022-12-18 | US | South Dakota | Minnehaha | 46099 | 63548 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-19 04:21:03 | Minnehaha, South Dakota, US | |
1631105 | 1631105 | 2022-12-18 | US | Rhode Island | Kent | 44003 | 61543 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-19 04:21:03 | Kent, Rhode Island, US | |
1630606 | 1630606 | 2022-12-18 | US | North Carolina | Cabarrus | 37025 | 68720 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-19 04:21:03 | Cabarrus, North Carolina, US | |
1629103 | 1629103 | 2022-12-18 | US | Georgia | Dougherty | 13095 | 23221 | 549 | 0 | 31.53328528 | -84.21722377 | 2022-12-19 04:21:03 | Dougherty, Georgia, US | |
1628630 | 1628630 | 2022-12-18 | Sweden | Orebro | 101556 | 549 | 0 | 59.535 | 15.0066 | 2022-12-19 04:21:03 | Orebro, Sweden | |||
506804 | 506804 | 2022-12-17 | US | Texas | Hays | 48209 | 75903 | 549 | 0 | 30.05669873 | -98.02944344 | 2022-12-18 04:21:03 | Hays, Texas, US | |
506584 | 506584 | 2022-12-17 | US | South Dakota | Minnehaha | 46099 | 63548 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-18 04:21:03 | Minnehaha, South Dakota, US | |
506484 | 506484 | 2022-12-17 | US | Rhode Island | Kent | 44003 | 61543 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-18 04:21:03 | Kent, Rhode Island, US | |
505985 | 505985 | 2022-12-17 | US | North Carolina | Cabarrus | 37025 | 68720 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-18 04:21:03 | Cabarrus, North Carolina, US | |
504482 | 504482 | 2022-12-17 | US | Georgia | Dougherty | 13095 | 23221 | 549 | 0 | 31.53328528 | -84.21722377 | 2022-12-18 04:21:03 | Dougherty, Georgia, US | |
504009 | 504009 | 2022-12-17 | Sweden | Orebro | 101556 | 549 | 0 | 59.535 | 15.0066 | 2022-12-18 04:21:03 | Orebro, Sweden | |||
3327376 | 3327376 | 2022-12-16 | US | Texas | Hays | 48209 | 75903 | 549 | 0 | 30.05669873 | -98.02944344 | 2022-12-17 04:21:04 | Hays, Texas, US | |
3327156 | 3327156 | 2022-12-16 | US | South Dakota | Minnehaha | 46099 | 63548 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-17 04:21:04 | Minnehaha, South Dakota, US | |
3327056 | 3327056 | 2022-12-16 | US | Rhode Island | Kent | 44003 | 61543 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-17 04:21:04 | Kent, Rhode Island, US | |
3326557 | 3326557 | 2022-12-16 | US | North Carolina | Cabarrus | 37025 | 68720 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-17 04:21:04 | Cabarrus, North Carolina, US | |
3325054 | 3325054 | 2022-12-16 | US | Georgia | Dougherty | 13095 | 23221 | 549 | 0 | 31.53328528 | -84.21722377 | 2022-12-17 04:21:04 | Dougherty, Georgia, US | |
3324581 | 3324581 | 2022-12-16 | Sweden | Orebro | 101556 | 549 | 0 | 59.535 | 15.0066 | 2022-12-17 04:21:04 | Orebro, Sweden | |||
545888 | 545888 | 2022-12-15 | US | Texas | Hays | 48209 | 75903 | 549 | 0 | 30.05669873 | -98.02944344 | 2022-12-16 04:21:01 | Hays, Texas, US | |
545668 | 545668 | 2022-12-15 | US | South Dakota | Minnehaha | 46099 | 63548 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-16 04:21:01 | Minnehaha, South Dakota, US | |
545568 | 545568 | 2022-12-15 | US | Rhode Island | Kent | 44003 | 61543 | 549 | 0 | 41.67106337 | -71.57641596 | 2022-12-16 04:21:01 | Kent, Rhode Island, US | |
545069 | 545069 | 2022-12-15 | US | North Carolina | Cabarrus | 37025 | 68720 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-16 04:21:01 | Cabarrus, North Carolina, US | |
543566 | 543566 | 2022-12-15 | US | Georgia | Dougherty | 13095 | 23221 | 549 | 0 | 31.53328528 | -84.21722377 | 2022-12-16 04:21:01 | Dougherty, Georgia, US | |
543093 | 543093 | 2022-12-15 | Sweden | Orebro | 101556 | 549 | 0 | 59.535 | 15.0066 | 2022-12-16 04:21:01 | Orebro, Sweden | |||
351196 | 351196 | 2022-12-14 | US | South Dakota | Minnehaha | 46099 | 63548 | 549 | 0 | 43.67441641 | -96.7910885 | 2022-12-15 04:20:58 | Minnehaha, South Dakota, US | |
350597 | 350597 | 2022-12-14 | US | North Carolina | Cabarrus | 37025 | 68720 | 549 | 0 | 35.3877799 | -80.55267168 | 2022-12-15 04:20:58 | Cabarrus, North Carolina, US | |
349094 | 349094 | 2022-12-14 | US | Georgia | Dougherty | 13095 | 23221 | 549 | 0 | 31.53328528 | -84.21722377 | 2022-12-15 04:20:58 | Dougherty, Georgia, US | |
310571 | 310571 | 2022-12-13 | US | Pennsylvania | Lebanon | 42075 | 43236 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-14 04:21:04 | Lebanon, Pennsylvania, US | |
1151632 | 1151632 | 2022-12-12 | US | Pennsylvania | Lebanon | 42075 | 43236 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-13 04:21:01 | Lebanon, Pennsylvania, US | |
871486 | 871486 | 2022-12-11 | US | Pennsylvania | Lebanon | 42075 | 43236 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-12 04:21:01 | Lebanon, Pennsylvania, US | |
260016 | 260016 | 2022-12-10 | US | Pennsylvania | Lebanon | 42075 | 43236 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-11 04:20:50 | Lebanon, Pennsylvania, US | |
3938730 | 3938730 | 2022-12-09 | US | Pennsylvania | Lebanon | 42075 | 43236 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-10 04:21:02 | Lebanon, Pennsylvania, US | |
3380062 | 3380062 | 2022-12-08 | US | Pennsylvania | Lebanon | 42075 | 43236 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-09 04:21:05 | Lebanon, Pennsylvania, US | |
1987333 | 1987333 | 2022-12-07 | US | Pennsylvania | Lebanon | 42075 | 43236 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-08 04:21:07 | Lebanon, Pennsylvania, US | |
3716856 | 3716856 | 2022-12-06 | US | Pennsylvania | Lebanon | 42075 | 42999 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-07 04:20:58 | Lebanon, Pennsylvania, US | |
2417561 | 2417561 | 2022-12-05 | US | Pennsylvania | Lebanon | 42075 | 42999 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-06 04:21:03 | Lebanon, Pennsylvania, US | |
721169 | 721169 | 2022-12-04 | US | Pennsylvania | Lebanon | 42075 | 42999 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-05 04:20:58 | Lebanon, Pennsylvania, US | |
2819458 | 2819458 | 2022-12-03 | US | Pennsylvania | Lebanon | 42075 | 42999 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-04 04:20:56 | Lebanon, Pennsylvania, US | |
836314 | 836314 | 2022-12-02 | US | Pennsylvania | Lebanon | 42075 | 42999 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-03 04:21:02 | Lebanon, Pennsylvania, US | |
2138844 | 2138844 | 2022-12-01 | US | Pennsylvania | Lebanon | 42075 | 42999 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-02 04:21:07 | Lebanon, Pennsylvania, US | |
1967260 | 1967260 | 2022-11-30 | US | Pennsylvania | Lebanon | 42075 | 42999 | 549 | 0 | 40.36680311 | -76.45651841 | 2022-12-01 04:21:03 | Lebanon, Pennsylvania, US | |
1643490 | 1643490 | 2022-11-20 | US | Texas | Kaufman | 48257 | 40882 | 549 | 0 | 32.5991417 | -96.28734728 | 2022-11-21 04:21:05 | Kaufman, Texas, US | |
2067047 | 2067047 | 2022-11-19 | US | Texas | Kaufman | 48257 | 40882 | 549 | 0 | 32.5991417 | -96.28734728 | 2022-11-20 04:21:08 | Kaufman, Texas, US | |
1758441 | 1758441 | 2022-11-18 | US | Texas | Kaufman | 48257 | 40882 | 549 | 0 | 32.5991417 | -96.28734728 | 2022-11-19 04:21:14 | Kaufman, Texas, US | |
3029434 | 3029434 | 2022-11-17 | US | Texas | Kaufman | 48257 | 40855 | 549 | 0 | 32.5991417 | -96.28734728 | 2022-11-18 04:21:15 | Kaufman, Texas, US | |
2489145 | 2489145 | 2022-11-16 | US | Texas | Kaufman | 48257 | 40855 | 549 | 0 | 32.5991417 | -96.28734728 | 2022-11-17 04:21:11 | Kaufman, Texas, US | |
295156 | 295156 | 2022-11-15 | US | Texas | Kaufman | 48257 | 40847 | 549 | 0 | 32.5991417 | -96.28734728 | 2022-11-16 04:21:09 | Kaufman, Texas, US | |
292820 | 292820 | 2022-11-15 | US | Georgia | Floyd | 13115 | 30900 | 549 | 0 | 34.26268279 | -85.21577392 | 2022-11-16 04:21:09 | Floyd, Georgia, 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]);