johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
382 rows where deaths = 640 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 256
- Russia 18
- Sweden 18
- Papua New Guinea 10
- Colombia 7
- France 7
- Mexico 6
- Japan 5
- Peru 5
- Australia 4
- Brazil 4
- Chile 4
- India 4
- Italy 4
- Ukraine 4
- Congo (Kinshasa) 2
- Cote d'Ivoire 2
- Malaysia 2
- Spain 2
- Uzbekistan 2
- Canada 1
- Denmark 1
- El Salvador 1
- Eswatini 1
- Germany 1
- Ghana 1
- Guyana 1
- Laos 1
- Lithuania 1
- Mauritania 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
348320 | 348320 | 2022-12-14 | Japan | Tochigi | 314610 | 640 | 0 | 36.689912 | 139.819213 | 2022-12-15 04:20:58 | Tochigi, Japan | |||
3598629 | 3598629 | 2022-11-14 | US | Maryland | Harford | 24025 | 46890 | 640 | 0 | 39.55010644 | -76.3077594 | 2022-11-15 04:21:16 | Harford, Maryland, US | |
313487 | 313487 | 2022-11-13 | US | Maryland | Harford | 24025 | 46864 | 640 | 0 | 39.55010644 | -76.3077594 | 2022-11-14 04:21:09 | Harford, Maryland, US | |
64648 | 64648 | 2022-11-12 | US | Maryland | Harford | 24025 | 46864 | 640 | 0 | 39.55010644 | -76.3077594 | 2022-11-13 04:21:14 | Harford, Maryland, US | |
2928810 | 2928810 | 2022-11-11 | US | Maryland | Harford | 24025 | 46864 | 640 | 0 | 39.55010644 | -76.3077594 | 2022-11-12 04:20:41 | Harford, Maryland, US | |
2927216 | 2927216 | 2022-11-11 | Japan | Gifu | 323587 | 640 | 0 | 35.778671 | 137.055925 | 2022-11-12 04:20:41 | Gifu, Japan | |||
2507646 | 2507646 | 2022-11-10 | US | Maryland | Harford | 24025 | 46864 | 640 | 0 | 39.55010644 | -76.3077594 | 2022-11-11 04:21:22 | Harford, Maryland, US | |
398438 | 398438 | 2022-10-07 | US | New Jersey | Cumberland | 34011 | 47706 | 640 | 0 | 39.37199394 | -75.10712559 | 2022-10-08 04:22:56 | Cumberland, New Jersey, US | |
2531555 | 2531555 | 2022-10-06 | US | New Jersey | Cumberland | 34011 | 47643 | 640 | 0 | 39.37199394 | -75.10712559 | 2022-10-07 04:23:08 | Cumberland, New Jersey, US | |
133055 | 133055 | 2022-10-04 | US | North Carolina | Catawba | 37035 | 56035 | 640 | 0 | 35.66211129 | -81.2132617 | 2022-10-05 04:23:06 | Catawba, North Carolina, US | |
2688002 | 2688002 | 2022-10-03 | US | North Carolina | Catawba | 37035 | 56035 | 640 | 0 | 35.66211129 | -81.2132617 | 2022-10-04 04:22:55 | Catawba, North Carolina, US | |
2262069 | 2262069 | 2022-10-02 | US | North Carolina | Catawba | 37035 | 56035 | 640 | 0 | 35.66211129 | -81.2132617 | 2022-10-03 04:23:11 | Catawba, North Carolina, US | |
2997595 | 2997595 | 2022-10-01 | US | North Carolina | Catawba | 37035 | 56035 | 640 | 0 | 35.66211129 | -81.2132617 | 2022-10-02 04:21:23 | Catawba, North Carolina, US | |
855921 | 855921 | 2022-09-30 | US | North Carolina | Catawba | 37035 | 56035 | 640 | 0 | 35.66211129 | -81.2132617 | 2022-10-01 04:23:01 | Catawba, North Carolina, US | |
2377847 | 2377847 | 2022-09-29 | US | North Carolina | Catawba | 37035 | 56035 | 640 | 0 | 35.66211129 | -81.2132617 | 2022-09-30 04:23:09 | Catawba, North Carolina, US | |
1562398 | 1562398 | 2022-09-28 | US | North Carolina | Catawba | 37035 | 56035 | 640 | 0 | 35.66211129 | -81.2132617 | 2022-09-29 04:22:34 | Catawba, North Carolina, US | |
1625399 | 1625399 | 2022-09-22 | US | Indiana | Johnson | 18081 | 47773 | 640 | 0 | 39.48994426 | -86.10149107 | 2022-09-23 04:23:13 | Johnson, Indiana, US | |
1371603 | 1371603 | 2022-09-21 | US | Indiana | Johnson | 18081 | 47773 | 640 | 0 | 39.48994426 | -86.10149107 | 2022-09-22 04:22:56 | Johnson, Indiana, US | |
3373046 | 3373046 | 2022-09-17 | Australia | Western Australia | 1145119 | 640 | 0 | -31.9505 | 115.8605 | 2022-09-18 04:22:50 | Western Australia, Australia | |||
2355154 | 2355154 | 2022-09-16 | Australia | Western Australia | 1145119 | 640 | 0 | -31.9505 | 115.8605 | 2022-09-17 04:20:19 | Western Australia, Australia | |||
3986311 | 3986311 | 2022-09-15 | Australia | Western Australia | 1145119 | 640 | 0 | -31.9505 | 115.8605 | 2022-09-16 04:21:19 | Western Australia, Australia | |||
2343779 | 2343779 | 2022-08-31 | US | Alabama | Calhoun | 1015 | 35737 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-09-01 04:21:03 | Calhoun, Alabama, US | |
3774259 | 3774259 | 2022-08-30 | US | Alabama | Calhoun | 1015 | 35737 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-31 04:20:57 | Calhoun, Alabama, US | |
1680855 | 1680855 | 2022-08-29 | US | Alabama | Calhoun | 1015 | 35737 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-30 04:21:03 | Calhoun, Alabama, US | |
1877339 | 1877339 | 2022-08-28 | US | Alabama | Calhoun | 1015 | 35737 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-29 04:21:06 | Calhoun, Alabama, US | |
2096466 | 2096466 | 2022-08-27 | US | Alabama | Calhoun | 1015 | 35737 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-28 04:21:02 | Calhoun, Alabama, US | |
1532281 | 1532281 | 2022-08-26 | US | Alabama | Calhoun | 1015 | 35737 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-27 04:20:57 | Calhoun, Alabama, US | |
2829168 | 2829168 | 2022-08-25 | US | Alabama | Calhoun | 1015 | 35737 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-26 04:21:02 | Calhoun, Alabama, US | |
2323701 | 2323701 | 2022-08-24 | US | Alabama | Calhoun | 1015 | 35426 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-25 04:21:13 | Calhoun, Alabama, US | |
1251110 | 1251110 | 2022-08-23 | US | Alabama | Calhoun | 1015 | 35426 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-24 04:20:46 | Calhoun, Alabama, US | |
2855701 | 2855701 | 2022-08-22 | US | South Carolina | Pickens | 45077 | 49508 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-23 04:20:56 | Pickens, South Carolina, US | |
2853214 | 2853214 | 2022-08-22 | US | Alabama | Calhoun | 1015 | 35426 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-23 04:20:56 | Calhoun, Alabama, US | |
2405673 | 2405673 | 2022-08-21 | US | South Carolina | Pickens | 45077 | 49508 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-22 04:20:38 | Pickens, South Carolina, US | |
2403186 | 2403186 | 2022-08-21 | US | Alabama | Calhoun | 1015 | 35426 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-22 04:20:38 | Calhoun, Alabama, US | |
3800751 | 3800751 | 2022-08-20 | US | South Carolina | Pickens | 45077 | 49508 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-21 04:20:44 | Pickens, South Carolina, US | |
3798264 | 3798264 | 2022-08-20 | US | Alabama | Calhoun | 1015 | 35426 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-21 04:20:44 | Calhoun, Alabama, US | |
2366337 | 2366337 | 2022-08-19 | US | South Carolina | Pickens | 45077 | 49508 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-20 04:21:01 | Pickens, South Carolina, US | |
2363850 | 2363850 | 2022-08-19 | US | Alabama | Calhoun | 1015 | 35426 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-20 04:21:01 | Calhoun, Alabama, US | |
1164008 | 1164008 | 2022-08-18 | US | South Carolina | Pickens | 45077 | 49508 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-19 04:20:54 | Pickens, South Carolina, US | |
1161521 | 1161521 | 2022-08-18 | US | Alabama | Calhoun | 1015 | 35426 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-19 04:20:54 | Calhoun, Alabama, US | |
3953332 | 3953332 | 2022-08-17 | US | South Carolina | Pickens | 45077 | 49508 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-18 04:21:11 | Pickens, South Carolina, US | |
3950845 | 3950845 | 2022-08-17 | US | Alabama | Calhoun | 1015 | 35055 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-18 04:21:11 | Calhoun, Alabama, US | |
993834 | 993834 | 2022-08-16 | US | South Carolina | Pickens | 45077 | 49508 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-17 04:20:59 | Pickens, South Carolina, US | |
991347 | 991347 | 2022-08-16 | US | Alabama | Calhoun | 1015 | 35055 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-17 04:20:59 | Calhoun, Alabama, US | |
2496873 | 2496873 | 2022-08-15 | US | South Carolina | Pickens | 45077 | 49174 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-16 04:20:58 | Pickens, South Carolina, US | |
2494386 | 2494386 | 2022-08-15 | US | Alabama | Calhoun | 1015 | 35055 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-16 04:20:58 | Calhoun, Alabama, US | |
3650423 | 3650423 | 2022-08-14 | US | South Carolina | Pickens | 45077 | 49174 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-15 04:20:59 | Pickens, South Carolina, US | |
3647936 | 3647936 | 2022-08-14 | US | Alabama | Calhoun | 1015 | 35055 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-15 04:20:59 | Calhoun, Alabama, US | |
1971429 | 1971429 | 2022-08-13 | US | South Carolina | Pickens | 45077 | 49174 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-14 04:20:55 | Pickens, South Carolina, US | |
1968942 | 1968942 | 2022-08-13 | US | Alabama | Calhoun | 1015 | 35055 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-14 04:20:55 | Calhoun, Alabama, US | |
2891238 | 2891238 | 2022-08-12 | US | South Carolina | Pickens | 45077 | 49174 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-13 04:20:52 | Pickens, South Carolina, US | |
2888751 | 2888751 | 2022-08-12 | US | Alabama | Calhoun | 1015 | 35055 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-13 04:20:52 | Calhoun, Alabama, US | |
3910843 | 3910843 | 2022-08-11 | US | South Carolina | Pickens | 45077 | 49174 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-12 04:20:54 | Pickens, South Carolina, US | |
3908356 | 3908356 | 2022-08-11 | US | Alabama | Calhoun | 1015 | 35055 | 640 | 0 | 33.77483727 | -85.82630386 | 2022-08-12 04:20:54 | Calhoun, Alabama, US | |
1349160 | 1349160 | 2022-08-10 | US | South Carolina | Pickens | 45077 | 49174 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-11 04:20:49 | Pickens, South Carolina, US | |
1088915 | 1088915 | 2022-08-09 | US | South Carolina | Pickens | 45077 | 49174 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-10 04:20:57 | Pickens, South Carolina, US | |
3546330 | 3546330 | 2022-08-08 | US | South Carolina | Pickens | 45077 | 48858 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-09 04:20:34 | Pickens, South Carolina, US | |
1072733 | 1072733 | 2022-08-07 | US | South Carolina | Pickens | 45077 | 48858 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-08 04:21:08 | Pickens, South Carolina, US | |
1943321 | 1943321 | 2022-08-06 | US | South Carolina | Pickens | 45077 | 48858 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-07 04:20:54 | Pickens, South Carolina, US | |
883120 | 883120 | 2022-08-05 | US | South Carolina | Pickens | 45077 | 48858 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-06 04:20:56 | Pickens, South Carolina, US | |
2011531 | 2011531 | 2022-08-04 | US | South Carolina | Pickens | 45077 | 48858 | 640 | 0 | 34.88807695 | -82.72791551 | 2022-08-05 04:20:52 | Pickens, South Carolina, US | |
3405993 | 3405993 | 2022-07-17 | US | Arkansas | Washington | 5143 | 72318 | 640 | 0 | 35.976844 | -94.21800746 | 2022-07-18 04:20:59 | Washington, Arkansas, US | |
2152193 | 2152193 | 2022-07-16 | US | Arkansas | Washington | 5143 | 72279 | 640 | 0 | 35.976844 | -94.21800746 | 2022-07-17 04:21:15 | Washington, Arkansas, US | |
2151630 | 2151630 | 2022-07-16 | Italy | Molise | 77564 | 640 | 0 | 41.55774754 | 14.65916051 | 2022-07-17 04:21:15 | Molise, Italy | |||
3969653 | 3969653 | 2022-07-05 | US | Texas | Grayson | 48181 | 27839 | 640 | 0 | 33.62744998 | -96.67753461 | 2022-07-06 04:20:58 | Grayson, Texas, US | |
3967326 | 3967326 | 2022-07-05 | US | Georgia | Cherokee | 13057 | 66451 | 640 | 0 | 34.24393976 | -84.47431861 | 2022-07-06 04:20:58 | Cherokee, Georgia, US | |
3078837 | 3078837 | 2022-07-04 | US | Georgia | Cherokee | 13057 | 66451 | 640 | 0 | 34.24393976 | -84.47431861 | 2022-07-05 04:20:45 | Cherokee, Georgia, US | |
1768119 | 1768119 | 2022-07-03 | US | Georgia | Cherokee | 13057 | 66451 | 640 | 0 | 34.24393976 | -84.47431861 | 2022-07-04 04:20:54 | Cherokee, Georgia, US | |
3366105 | 3366105 | 2022-07-02 | US | Georgia | Cherokee | 13057 | 66451 | 640 | 0 | 34.24393976 | -84.47431861 | 2022-07-03 04:20:59 | Cherokee, Georgia, US | |
594434 | 594434 | 2022-07-01 | US | Georgia | Cherokee | 13057 | 66451 | 640 | 0 | 34.24393976 | -84.47431861 | 2022-07-02 04:21:16 | Cherokee, Georgia, US | |
3940835 | 3940835 | 2022-06-30 | US | Georgia | Cherokee | 13057 | 66451 | 640 | 0 | 34.24393976 | -84.47431861 | 2022-07-01 04:21:10 | Cherokee, Georgia, US | |
2490793 | 2490793 | 2022-06-29 | US | Georgia | Cherokee | 13057 | 66451 | 640 | 0 | 34.24393976 | -84.47431861 | 2022-06-30 04:21:01 | Cherokee, Georgia, US | |
2191170 | 2191170 | 2022-06-22 | US | Wisconsin | Kenosha | 55059 | 47434 | 640 | 0 | 42.57639354 | -88.04051686 | 2022-06-23 04:20:55 | Kenosha, Wisconsin, US | |
169601 | 169601 | 2022-06-21 | US | Wisconsin | Kenosha | 55059 | 47380 | 640 | 0 | 42.57639354 | -88.04051686 | 2022-06-22 04:20:54 | Kenosha, Wisconsin, US | |
1766884 | 1766884 | 2022-06-20 | US | Wisconsin | Kenosha | 55059 | 47341 | 640 | 0 | 42.57639354 | -88.04051686 | 2022-06-21 04:20:56 | Kenosha, Wisconsin, US | |
3273070 | 3273070 | 2022-06-19 | US | Wisconsin | Kenosha | 55059 | 47223 | 640 | 0 | 42.57639354 | -88.04051686 | 2022-06-20 04:21:01 | Kenosha, Wisconsin, US | |
3400982 | 3400982 | 2022-06-18 | US | Wisconsin | Kenosha | 55059 | 47223 | 640 | 0 | 42.57639354 | -88.04051686 | 2022-06-19 04:20:51 | Kenosha, Wisconsin, US | |
2314859 | 2314859 | 2022-06-17 | US | Wisconsin | Kenosha | 55059 | 47223 | 640 | 0 | 42.57639354 | -88.04051686 | 2022-06-18 04:21:10 | Kenosha, Wisconsin, US | |
3581238 | 3581238 | 2022-06-02 | US | Oregon | Clackamas | 41005 | 67082 | 640 | 0 | 45.18787398 | -122.2179634 | 2022-06-03 04:20:58 | Clackamas, Oregon, US | |
973531 | 973531 | 2022-06-01 | US | Oregon | Clackamas | 41005 | 66920 | 640 | 0 | 45.18787398 | -122.2179634 | 2022-06-02 05:20:39 | Clackamas, Oregon, US | |
231838 | 231838 | 2022-05-31 | US | Oregon | Clackamas | 41005 | 66743 | 640 | 0 | 45.18787398 | -122.2179634 | 2022-06-01 04:20:55 | Clackamas, Oregon, US | |
230899 | 230899 | 2022-05-31 | US | Michigan | Muskegon | 26121 | 41006 | 640 | 0 | 43.29123859 | -86.15176712 | 2022-06-01 04:20:55 | Muskegon, Michigan, US | |
3187664 | 3187664 | 2022-05-30 | US | Michigan | Muskegon | 26121 | 41006 | 640 | 0 | 43.29123859 | -86.15176712 | 2022-05-31 04:20:51 | Muskegon, Michigan, US | |
3199813 | 3199813 | 2022-05-29 | US | Michigan | Muskegon | 26121 | 41006 | 640 | 0 | 43.29123859 | -86.15176712 | 2022-05-30 04:20:50 | Muskegon, Michigan, US | |
2726691 | 2726691 | 2022-05-28 | US | Michigan | Muskegon | 26121 | 41006 | 640 | 0 | 43.29123859 | -86.15176712 | 2022-05-29 04:20:53 | Muskegon, Michigan, US | |
1315872 | 1315872 | 2022-05-27 | US | Michigan | Muskegon | 26121 | 41006 | 640 | 0 | 43.29123859 | -86.15176712 | 2022-05-28 04:21:07 | Muskegon, Michigan, US | |
1851664 | 1851664 | 2022-05-26 | US | Michigan | Muskegon | 26121 | 41006 | 640 | 0 | 43.29123859 | -86.15176712 | 2022-05-27 04:20:56 | Muskegon, Michigan, US | |
2049540 | 2049540 | 2022-05-25 | US | Michigan | Muskegon | 26121 | 41006 | 640 | 0 | 43.29123859 | -86.15176712 | 2022-05-26 04:20:50 | Muskegon, Michigan, US | |
623551 | 623551 | 2022-05-22 | US | Michigan | Muskegon | 26121 | 41006 | 640 | 0 | 43.29123859 | -86.15176712 | 2022-05-26 04:20:50 | Muskegon, Michigan, US | |
3583791 | 3583791 | 2022-05-17 | US | Indiana | Vanderburgh | 18163 | 57910 | 640 | 0 | 38.02658833 | -87.58763124 | 2022-05-18 04:20:50 | Vanderburgh, Indiana, US | |
1504748 | 1504748 | 2022-05-16 | US | Indiana | Vanderburgh | 18163 | 57910 | 640 | 0 | 38.02658833 | -87.58763124 | 2022-05-17 04:20:59 | Vanderburgh, Indiana, US | |
2085107 | 2085107 | 2022-05-15 | US | Indiana | Vanderburgh | 18163 | 57824 | 640 | 0 | 38.02658833 | -87.58763124 | 2022-05-16 04:20:47 | Vanderburgh, Indiana, US | |
3355817 | 3355817 | 2022-05-14 | US | Indiana | Vanderburgh | 18163 | 57824 | 640 | 0 | 38.02658833 | -87.58763124 | 2022-05-15 04:20:53 | Vanderburgh, Indiana, US | |
659462 | 659462 | 2022-05-13 | US | Indiana | Vanderburgh | 18163 | 57824 | 640 | 0 | 38.02658833 | -87.58763124 | 2022-05-14 04:20:48 | Vanderburgh, Indiana, US | |
2534545 | 2534545 | 2022-05-12 | US | Indiana | Vanderburgh | 18163 | 57756 | 640 | 0 | 38.02658833 | -87.58763124 | 2022-05-13 04:20:51 | Vanderburgh, Indiana, US | |
3445991 | 3445991 | 2022-05-11 | US | Indiana | Vanderburgh | 18163 | 57756 | 640 | 0 | 38.02658833 | -87.58763124 | 2022-05-12 04:20:54 | Vanderburgh, Indiana, US | |
1224272 | 1224272 | 2022-04-14 | US | Delaware | Kent | 10001 | 50356 | 640 | 0 | 39.08646628 | -75.56884914 | 2022-04-15 04:20:57 | Kent, Delaware, US | |
2443430 | 2443430 | 2022-04-13 | US | Delaware | Kent | 10001 | 50300 | 640 | 0 | 39.08646628 | -75.56884914 | 2022-04-13 23:21:06 | Kent, Delaware, US | |
1949187 | 1949187 | 2022-04-12 | US | Delaware | Kent | 10001 | 50256 | 640 | 0 | 39.08646628 | -75.56884914 | 2022-04-13 04:21:03 | Kent, Delaware, US | |
3206940 | 3206940 | 2022-04-11 | US | Delaware | Kent | 10001 | 50244 | 640 | 0 | 39.08646628 | -75.56884914 | 2022-04-12 04:20:49 | Kent, Delaware, 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]);