johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,759 rows where deaths = 269 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755883 | 2755883 | 2022-12-29 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-30 04:21:04 | Monroe, Tennessee, US | |
2754545 | 2754545 | 2022-12-29 | US | Michigan | Grand Traverse | 26055 | 21131 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-30 04:21:04 | Grand Traverse, Michigan, US | |
1076889 | 1076889 | 2022-12-28 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-29 04:21:01 | Monroe, Tennessee, US | |
1075551 | 1075551 | 2022-12-28 | US | Michigan | Grand Traverse | 26055 | 21131 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-29 04:21:01 | Grand Traverse, Michigan, US | |
330886 | 330886 | 2022-12-27 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-28 04:21:04 | Monroe, Tennessee, US | |
329548 | 329548 | 2022-12-27 | US | Michigan | Grand Traverse | 26055 | 21131 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-28 04:21:04 | Grand Traverse, Michigan, US | |
220959 | 220959 | 2022-12-26 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-27 04:21:07 | Monroe, Tennessee, US | |
219621 | 219621 | 2022-12-26 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-27 04:21:07 | Grand Traverse, Michigan, US | |
218004 | 218004 | 2022-12-26 | Japan | Tokushima | 126947 | 269 | 0 | 33.919178 | 134.242091 | 2022-12-27 04:21:07 | Tokushima, Japan | |||
217992 | 217992 | 2022-12-26 | Japan | Niigata | 384781 | 269 | 0 | 37.521819 | 138.918647 | 2022-12-27 04:21:07 | Niigata, Japan | |||
3225416 | 3225416 | 2022-12-25 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-26 04:21:06 | Monroe, Tennessee, US | |
3224078 | 3224078 | 2022-12-25 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-26 04:21:06 | Grand Traverse, Michigan, US | |
3222449 | 3222449 | 2022-12-25 | Japan | Niigata | 383660 | 269 | 0 | 37.521819 | 138.918647 | 2022-12-26 04:21:06 | Niigata, Japan | |||
1021330 | 1021330 | 2022-12-24 | US | Tennessee | Monroe | 47123 | 17627 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-25 04:21:04 | Monroe, Tennessee, US | |
1019992 | 1019992 | 2022-12-24 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-25 04:21:04 | Grand Traverse, Michigan, US | |
1018363 | 1018363 | 2022-12-24 | Japan | Niigata | 381702 | 269 | 0 | 37.521819 | 138.918647 | 2022-12-25 04:21:04 | Niigata, Japan | |||
693353 | 693353 | 2022-12-23 | US | Tennessee | Monroe | 47123 | 17626 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-24 04:21:02 | Monroe, Tennessee, US | |
692015 | 692015 | 2022-12-23 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-24 04:21:02 | Grand Traverse, Michigan, US | |
2182563 | 2182563 | 2022-12-22 | US | Tennessee | Monroe | 47123 | 17614 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-23 04:21:04 | Monroe, Tennessee, US | |
2181225 | 2181225 | 2022-12-22 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-23 04:21:04 | Grand Traverse, Michigan, US | |
454367 | 454367 | 2022-12-21 | US | Tennessee | Monroe | 47123 | 17606 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-22 04:20:56 | Monroe, Tennessee, US | |
453029 | 453029 | 2022-12-21 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-22 04:20:56 | Grand Traverse, Michigan, US | |
452454 | 452454 | 2022-12-21 | US | Illinois | Williamson | 17199 | 28007 | 269 | 0 | 37.73033511 | -88.92994027 | 2022-12-22 04:20:56 | Williamson, Illinois, US | |
2954366 | 2954366 | 2022-12-20 | US | Tennessee | Monroe | 47123 | 17598 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-21 04:21:03 | Monroe, Tennessee, US | |
2953028 | 2953028 | 2022-12-20 | US | Michigan | Grand Traverse | 26055 | 21056 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-21 04:21:03 | Grand Traverse, Michigan, US | |
2952453 | 2952453 | 2022-12-20 | US | Illinois | Williamson | 17199 | 27975 | 269 | 0 | 37.73033511 | -88.92994027 | 2022-12-21 04:21:03 | Williamson, Illinois, US | |
3176768 | 3176768 | 2022-12-19 | US | Tennessee | Monroe | 47123 | 17576 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-20 04:21:04 | Monroe, Tennessee, US | |
3175430 | 3175430 | 2022-12-19 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-20 04:21:04 | Grand Traverse, Michigan, US | |
3174855 | 3174855 | 2022-12-19 | US | Illinois | Williamson | 17199 | 27967 | 269 | 0 | 37.73033511 | -88.92994027 | 2022-12-20 04:21:04 | Williamson, Illinois, US | |
3174223 | 3174223 | 2022-12-19 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-20 04:21:04 | Matanuska-Susitna, Alaska, US | |
1631285 | 1631285 | 2022-12-18 | US | Tennessee | Monroe | 47123 | 17562 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-19 04:21:03 | Monroe, Tennessee, US | |
1629947 | 1629947 | 2022-12-18 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-19 04:21:03 | Grand Traverse, Michigan, US | |
1628740 | 1628740 | 2022-12-18 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-19 04:21:03 | Matanuska-Susitna, Alaska, US | |
506664 | 506664 | 2022-12-17 | US | Tennessee | Monroe | 47123 | 17562 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-18 04:21:03 | Monroe, Tennessee, US | |
505326 | 505326 | 2022-12-17 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-18 04:21:03 | Grand Traverse, Michigan, US | |
504119 | 504119 | 2022-12-17 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-18 04:21:03 | Matanuska-Susitna, Alaska, US | |
3327236 | 3327236 | 2022-12-16 | US | Tennessee | Monroe | 47123 | 17562 | 269 | 0 | 35.44550387 | -84.24902965 | 2022-12-17 04:21:04 | Monroe, Tennessee, US | |
3325898 | 3325898 | 2022-12-16 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-17 04:21:04 | Grand Traverse, Michigan, US | |
3324691 | 3324691 | 2022-12-16 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-17 04:21:04 | Matanuska-Susitna, Alaska, US | |
544410 | 544410 | 2022-12-15 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-16 04:21:01 | Grand Traverse, Michigan, US | |
543203 | 543203 | 2022-12-15 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-16 04:21:01 | Matanuska-Susitna, Alaska, US | |
349938 | 349938 | 2022-12-14 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-15 04:20:58 | Grand Traverse, Michigan, US | |
348731 | 348731 | 2022-12-14 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-15 04:20:58 | Matanuska-Susitna, Alaska, US | |
310564 | 310564 | 2022-12-13 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-14 04:21:04 | Huntingdon, Pennsylvania, US | |
309526 | 309526 | 2022-12-13 | US | Michigan | Grand Traverse | 26055 | 20965 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-14 04:21:04 | Grand Traverse, Michigan, US | |
308807 | 308807 | 2022-12-13 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-14 04:21:04 | Bannock, Idaho, US | |
308319 | 308319 | 2022-12-13 | US | Alaska | Matanuska-Susitna | 2170 | 40235 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-14 04:21:04 | Matanuska-Susitna, Alaska, US | |
1151625 | 1151625 | 2022-12-12 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-13 04:21:01 | Huntingdon, Pennsylvania, US | |
1150587 | 1150587 | 2022-12-12 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-13 04:21:01 | Grand Traverse, Michigan, US | |
1149868 | 1149868 | 2022-12-12 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-13 04:21:01 | Bannock, Idaho, US | |
1149380 | 1149380 | 2022-12-12 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-13 04:21:01 | Matanuska-Susitna, Alaska, US | |
871479 | 871479 | 2022-12-11 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-12 04:21:01 | Huntingdon, Pennsylvania, US | |
871075 | 871075 | 2022-12-11 | US | New York | Steuben | 36101 | 24669 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-12 04:21:01 | Steuben, New York, US | |
870441 | 870441 | 2022-12-11 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-12 04:21:01 | Grand Traverse, Michigan, US | |
869722 | 869722 | 2022-12-11 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-12 04:21:01 | Bannock, Idaho, US | |
869234 | 869234 | 2022-12-11 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-12 04:21:01 | Matanuska-Susitna, Alaska, US | |
260009 | 260009 | 2022-12-10 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-11 04:20:50 | Huntingdon, Pennsylvania, US | |
259605 | 259605 | 2022-12-10 | US | New York | Steuben | 36101 | 24657 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-11 04:20:50 | Steuben, New York, US | |
258971 | 258971 | 2022-12-10 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-11 04:20:50 | Grand Traverse, Michigan, US | |
258252 | 258252 | 2022-12-10 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-11 04:20:50 | Bannock, Idaho, US | |
257764 | 257764 | 2022-12-10 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-11 04:20:50 | Matanuska-Susitna, Alaska, US | |
257360 | 257360 | 2022-12-10 | Japan | Yamagata | 177502 | 269 | 0 | 38.448396 | 140.102154 | 2022-12-11 04:20:50 | Yamagata, Japan | |||
3938723 | 3938723 | 2022-12-09 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-10 04:21:02 | Huntingdon, Pennsylvania, US | |
3938319 | 3938319 | 2022-12-09 | US | New York | Steuben | 36101 | 24642 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-10 04:21:02 | Steuben, New York, US | |
3937685 | 3937685 | 2022-12-09 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-10 04:21:02 | Grand Traverse, Michigan, US | |
3936966 | 3936966 | 2022-12-09 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-10 04:21:02 | Bannock, Idaho, US | |
3936478 | 3936478 | 2022-12-09 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-10 04:21:02 | Matanuska-Susitna, Alaska, US | |
3936074 | 3936074 | 2022-12-09 | Japan | Yamagata | 176062 | 269 | 0 | 38.448396 | 140.102154 | 2022-12-10 04:21:02 | Yamagata, Japan | |||
3380055 | 3380055 | 2022-12-08 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-09 04:21:05 | Huntingdon, Pennsylvania, US | |
3379651 | 3379651 | 2022-12-08 | US | New York | Steuben | 36101 | 24624 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-09 04:21:05 | Steuben, New York, US | |
3379017 | 3379017 | 2022-12-08 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-09 04:21:05 | Grand Traverse, Michigan, US | |
3378298 | 3378298 | 2022-12-08 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-09 04:21:05 | Bannock, Idaho, US | |
3377810 | 3377810 | 2022-12-08 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-09 04:21:05 | Matanuska-Susitna, Alaska, US | |
3377406 | 3377406 | 2022-12-08 | Japan | Yamagata | 174715 | 269 | 0 | 38.448396 | 140.102154 | 2022-12-09 04:21:05 | Yamagata, Japan | |||
1987326 | 1987326 | 2022-12-07 | US | Pennsylvania | Huntingdon | 42061 | 13357 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-08 04:21:07 | Huntingdon, Pennsylvania, US | |
1986922 | 1986922 | 2022-12-07 | US | New York | Steuben | 36101 | 24600 | 269 | 0 | 42.2689144 | -77.3829924 | 2022-12-08 04:21:07 | Steuben, New York, US | |
1986288 | 1986288 | 2022-12-07 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-08 04:21:07 | Grand Traverse, Michigan, US | |
1985569 | 1985569 | 2022-12-07 | US | Idaho | Bannock | 16005 | 24051 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-08 04:21:07 | Bannock, Idaho, US | |
1985081 | 1985081 | 2022-12-07 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-08 04:21:07 | Matanuska-Susitna, Alaska, US | |
3716849 | 3716849 | 2022-12-06 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-07 04:20:58 | Huntingdon, Pennsylvania, US | |
3715811 | 3715811 | 2022-12-06 | US | Michigan | Grand Traverse | 26055 | 20871 | 269 | 0 | 44.69565625 | -85.55585247 | 2022-12-07 04:20:58 | Grand Traverse, Michigan, US | |
3715092 | 3715092 | 2022-12-06 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-07 04:20:58 | Bannock, Idaho, US | |
3714604 | 3714604 | 2022-12-06 | US | Alaska | Matanuska-Susitna | 2170 | 40191 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-07 04:20:58 | Matanuska-Susitna, Alaska, US | |
3714188 | 3714188 | 2022-12-06 | Japan | Saga | 182017 | 269 | 0 | 33.286977 | 130.115738 | 2022-12-07 04:20:58 | Saga, Japan | |||
2417554 | 2417554 | 2022-12-05 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-06 04:21:03 | Huntingdon, Pennsylvania, US | |
2415797 | 2415797 | 2022-12-05 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-06 04:21:03 | Bannock, Idaho, US | |
2415309 | 2415309 | 2022-12-05 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-06 04:21:03 | Matanuska-Susitna, Alaska, US | |
721162 | 721162 | 2022-12-04 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-05 04:20:58 | Huntingdon, Pennsylvania, US | |
719405 | 719405 | 2022-12-04 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-05 04:20:58 | Bannock, Idaho, US | |
718917 | 718917 | 2022-12-04 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-05 04:20:58 | Matanuska-Susitna, Alaska, US | |
2819451 | 2819451 | 2022-12-03 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-04 04:20:56 | Huntingdon, Pennsylvania, US | |
2817694 | 2817694 | 2022-12-03 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-04 04:20:56 | Bannock, Idaho, US | |
2817206 | 2817206 | 2022-12-03 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-04 04:20:56 | Matanuska-Susitna, Alaska, US | |
836307 | 836307 | 2022-12-02 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-03 04:21:02 | Huntingdon, Pennsylvania, US | |
834550 | 834550 | 2022-12-02 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-03 04:21:02 | Bannock, Idaho, US | |
834062 | 834062 | 2022-12-02 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-03 04:21:02 | Matanuska-Susitna, Alaska, US | |
2138837 | 2138837 | 2022-12-01 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-02 04:21:07 | Huntingdon, Pennsylvania, US | |
2137080 | 2137080 | 2022-12-01 | US | Idaho | Bannock | 16005 | 23975 | 269 | 0 | 42.67002716 | -112.2233311 | 2022-12-02 04:21:07 | Bannock, Idaho, US | |
2136592 | 2136592 | 2022-12-01 | US | Alaska | Matanuska-Susitna | 2170 | 40132 | 269 | 0 | 62.31305045 | -149.5741743 | 2022-12-02 04:21:07 | Matanuska-Susitna, Alaska, US | |
1967253 | 1967253 | 2022-11-30 | US | Pennsylvania | Huntingdon | 42061 | 13317 | 269 | 0 | 40.42162652 | -77.97673273 | 2022-12-01 04:21:03 | Huntingdon, Pennsylvania, 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]);