johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
552 rows where active = 325 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 477
- Japan 14
- Malaysia 6
- Colombia 5
- Italy 5
- India 4
- Russia 4
- Australia 3
- China 3
- Germany 3
- Mexico 3
- Ukraine 3
- Benin 2
- Canada 2
- Chile 2
- Zimbabwe 2
- Comoros 1
- Congo (Kinshasa) 1
- Cote d'Ivoire 1
- El Salvador 1
- Georgia 1
- Lithuania 1
- Montenegro 1
- Namibia 1
- New Zealand 1
- Singapore 1
- Sri Lanka 1
- Sweden 1
- Trinidad and Tobago 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3221931 | 3221931 | 2021-07-26 | Ukraine | Luhansk Oblast | 27000 | 967 | 25708 | 325 | 48.574 | 39.3078 | 2021-07-27 04:21:18 | Luhansk Oblast, Ukraine | ||
3218128 | 3218128 | 2021-07-26 | China | Yunnan | 740 | 2 | 413 | 325 | 24.974 | 101.487 | 2021-07-27 04:21:18 | Yunnan, China | ||
3631812 | 3631812 | 2021-07-14 | Colombia | Putumayo | 14411 | 593 | 13493 | 325 | 0.436 | -75.5277 | 2021-07-15 04:21:48 | Putumayo, Colombia | ||
625990 | 625990 | 2021-07-10 | Montenegro | 100459 | 1620 | 98514 | 325 | 42.708678000000006 | 19.37439 | 2021-07-11 04:21:43 | Montenegro | |||
833217 | 833217 | 2021-07-09 | Ukraine | Cherkasy Oblast | 81902 | 1316 | 80261 | 325 | 49.4444 | 32.0598 | 2021-07-10 04:21:25 | Cherkasy Oblast, Ukraine | ||
1440595 | 1440595 | 2021-07-07 | Japan | Hyogo | 41112 | 1309 | 39478 | 325 | 35.039913 | 134.828057 | 2021-07-08 04:21:26 | Hyogo, Japan | ||
2693558 | 2693558 | 2021-07-06 | Cote d'Ivoire | 48634 | 315 | 47994 | 325 | 7.54 | -5.5471 | 2021-07-07 04:21:20 | Cote d'Ivoire | |||
2072141 | 2072141 | 2021-07-02 | Russia | Mari El Republic | 14404 | 293 | 13786 | 325 | 56.5767504 | 47.8817512 | 2021-07-03 04:21:37 | Mari El Republic, Russia | ||
3125428 | 3125428 | 2021-06-28 | Germany | Schleswig-Holstein | 63858 | 1620 | 61930 | 325 | 54.2194 | 9.6961 | 2021-06-29 04:21:28 | Schleswig-Holstein, Germany | ||
2422928 | 2422928 | 2021-06-23 | Japan | Shizuoka | 9105 | 149 | 8631 | 325 | 34.916975 | 138.40778400000002 | 2021-06-24 04:21:55 | Shizuoka, Japan | ||
3358948 | 3358948 | 2021-06-21 | Singapore | 62430 | 35 | 62070 | 325 | 1.2833 | 103.8333 | 2021-06-22 04:21:34 | Singapore | |||
2716962 | 2716962 | 2021-06-10 | Italy | P.A. Trento | 45640 | 1359 | 43956 | 325 | 46.06893511 | 11.12123097 | 2021-06-11 04:23:20 | P.A. Trento, Italy | ||
2315487 | 2315487 | 2021-06-04 | Russia | Amur Oblast | 22797 | 293 | 22179 | 325 | 52.8032368 | 128.437295 | 2021-06-05 04:23:03 | Amur Oblast, Russia | ||
1448626 | 1448626 | 2021-06-03 | Japan | Tochigi | 6427 | 78 | 6024 | 325 | 36.689912 | 139.819213 | 2021-06-04 04:23:37 | Tochigi, Japan | ||
1188688 | 1188688 | 2021-05-31 | India | Dadra and Nagar Haveli and Daman and Diu | 10286 | 4 | 9957 | 325 | 20.194742 | 73.080901 | 2021-06-01 04:23:09 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1952510 | 1952510 | 2021-05-21 | Italy | Valle d'Aosta | 11456 | 471 | 10660 | 325 | 45.73750286 | 7.320149366 | 2021-05-22 04:20:45 | Valle d'Aosta, Italy | ||
3574381 | 3574381 | 2021-05-17 | Chile | Aysen | 4967 | 33 | 4609 | 325 | -45.9864 | -73.7669 | 2021-05-18 04:20:33 | Aysen, Chile | ||
983161 | 983161 | 2021-04-17 | Russia | Komi Republic | 42689 | 861 | 41503 | 325 | 63.9881421 | 54.3326073 | 2021-04-18 04:20:41 | Komi Republic, Russia | ||
170256 | 170256 | 2021-04-16 | Russia | Komi Republic | 42630 | 857 | 41448 | 325 | 63.9881421 | 54.3326073 | 2021-04-17 04:20:40 | Komi Republic, Russia | ||
2247408 | 2247408 | 2021-04-07 | Japan | Ibaraki | 6954 | 127 | 6502 | 325 | 36.303588 | 140.319591 | 2021-04-08 04:21:13 | Ibaraki, Japan | ||
1293685 | 1293685 | 2021-03-29 | Malaysia | Perak | 12889 | 44 | 12520 | 325 | 4.5921 | 101.0901 | 2021-03-30 04:26:23 | Perak, Malaysia | ||
1090712 | 1090712 | 2021-03-03 | US | Colorado | Phillips | 8095 | 359 | 13 | 0 | 325 | 40.59414277 | -102.3577703 | 2021-03-04 05:24:24 | Phillips, Colorado, US |
3254784 | 3254784 | 2021-03-02 | US | Colorado | Phillips | 8095 | 359 | 13 | 0 | 325 | 40.59414277 | -102.3577703 | 2021-03-03 05:23:28 | Phillips, Colorado, US |
999076 | 999076 | 2021-03-01 | US | Colorado | Phillips | 8095 | 358 | 13 | 0 | 325 | 40.59414277 | -102.3577703 | 2021-03-02 05:23:30 | Phillips, Colorado, US |
2368134 | 2368134 | 2021-02-28 | US | Colorado | Phillips | 8095 | 357 | 13 | 0 | 325 | 40.59414277 | -102.3577703 | 2021-03-01 05:23:01 | Phillips, Colorado, US |
3066636 | 3066636 | 2021-02-27 | US | Colorado | Phillips | 8095 | 356 | 13 | 0 | 325 | 40.59414277 | -102.3577703 | 2021-02-28 05:22:20 | Phillips, Colorado, US |
2186475 | 2186475 | 2021-02-26 | US | South Dakota | Sanborn | 46111 | 328 | 3 | 0 | 325 | 44.02351092 | -98.0909816 | 2021-02-27 05:22:28 | Sanborn, South Dakota, US |
2184220 | 2184220 | 2021-02-26 | US | Colorado | Phillips | 8095 | 356 | 13 | 0 | 325 | 40.59414277 | -102.3577703 | 2021-02-27 05:22:28 | Phillips, Colorado, US |
1860897 | 1860897 | 2021-02-25 | US | South Dakota | Sanborn | 46111 | 328 | 3 | 0 | 325 | 44.02351092 | -98.0909816 | 2021-02-26 05:22:40 | Sanborn, South Dakota, US |
283075 | 283075 | 2021-02-24 | US | South Dakota | Sanborn | 46111 | 328 | 3 | 0 | 325 | 44.02351092 | -98.0909816 | 2021-02-25 05:24:57 | Sanborn, South Dakota, US |
533600 | 533600 | 2021-02-22 | US | South Dakota | Stanley | 46117 | 327 | 2 | 0 | 325 | 44.41381872 | -100.7349153 | 2021-02-23 05:23:41 | Stanley, South Dakota, US |
533571 | 533571 | 2021-02-22 | US | South Dakota | Hand | 46059 | 331 | 6 | 0 | 325 | 44.54708407 | -99.00386459 | 2021-02-23 05:23:41 | Hand, South Dakota, US |
184934 | 184934 | 2021-02-21 | US | South Dakota | Stanley | 46117 | 327 | 2 | 0 | 325 | 44.41381872 | -100.7349153 | 2021-02-22 05:24:21 | Stanley, South Dakota, US |
182475 | 182475 | 2021-02-21 | US | Alaska | Yukon-Koyukuk | 2290 | 329 | 4 | 0 | 325 | 65.50815459 | -151.3907387 | 2021-02-22 05:24:21 | Yukon-Koyukuk, Alaska, US |
745208 | 745208 | 2021-02-20 | US | South Dakota | Stanley | 46117 | 327 | 2 | 0 | 325 | 44.41381872 | -100.7349153 | 2021-02-21 05:24:33 | Stanley, South Dakota, US |
742749 | 742749 | 2021-02-20 | US | Alaska | Yukon-Koyukuk | 2290 | 329 | 4 | 0 | 325 | 65.50815459 | -151.3907387 | 2021-02-21 05:24:33 | Yukon-Koyukuk, Alaska, US |
474306 | 474306 | 2021-02-19 | US | South Dakota | Stanley | 46117 | 327 | 2 | 0 | 325 | 44.41381872 | -100.7349153 | 2021-02-20 05:22:51 | Stanley, South Dakota, US |
474183 | 474183 | 2021-02-19 | US | Puerto Rico | Santa Isabel | 72133 | 325 | 0 | 0 | 325 | 17.994525 | -66.388913 | 2021-02-20 05:22:51 | Santa Isabel, Puerto Rico, US |
471847 | 471847 | 2021-02-19 | US | Alaska | Yukon-Koyukuk | 2290 | 329 | 4 | 0 | 325 | 65.50815459 | -151.3907387 | 2021-02-20 05:22:51 | Yukon-Koyukuk, Alaska, US |
1152932 | 1152932 | 2021-02-18 | China | Hong Kong | 10820 | 197 | 10298 | 325 | 22.3 | 114.2 | 2021-02-19 05:24:16 | Hong Kong, China | ||
3053617 | 3053617 | 2021-02-16 | US | Washington | Lincoln | 53043 | 330 | 5 | 0 | 325 | 47.57705241 | -118.4194388 | 2021-02-17 05:23:10 | Lincoln, Washington, US |
3050042 | 3050042 | 2021-02-16 | Comoros | 3393 | 133 | 2935 | 325 | -11.6455 | 43.3333 | 2021-02-17 05:23:10 | Comoros | |||
1339633 | 1339633 | 2021-02-15 | US | Kentucky | Ballard | 21007 | 330 | 5 | 0 | 325 | 37.05842757 | -88.99427697 | 2021-02-16 05:24:38 | Ballard, Kentucky, US |
2284784 | 2284784 | 2021-02-14 | US | Kentucky | Ballard | 21007 | 330 | 5 | 0 | 325 | 37.05842757 | -88.99427697 | 2021-02-15 05:24:49 | Ballard, Kentucky, US |
2680014 | 2680014 | 2021-02-13 | US | New Mexico | Hidalgo | 35023 | 334 | 9 | 0 | 325 | 31.91383467 | -108.7151824 | 2021-02-14 05:23:43 | Hidalgo, New Mexico, US |
2679184 | 2679184 | 2021-02-13 | US | Kentucky | Ballard | 21007 | 330 | 5 | 0 | 325 | 37.05842757 | -88.99427697 | 2021-02-14 05:23:43 | Ballard, Kentucky, US |
2677835 | 2677835 | 2021-02-13 | Japan | Gunma | 4231 | 79 | 3827 | 325 | 36.504479 | 138.985605 | 2021-02-14 05:23:43 | Gunma, Japan | ||
3540444 | 3540444 | 2021-02-12 | US | Illinois | Hardin | 17069 | 336 | 11 | 0 | 325 | 37.51810645 | -88.26873022 | 2021-02-13 05:22:12 | Hardin, Illinois, US |
793438 | 793438 | 2021-02-04 | US | Texas | Culberson | 48109 | 306 | 7 | 0 | 325 | 31.44506775 | -104.5185739 | 2021-02-05 05:22:38 | Culberson, Texas, US |
343135 | 343135 | 2021-02-03 | US | South Dakota | Faulk | 46049 | 338 | 13 | 0 | 325 | 45.07082625 | -99.14535601 | 2021-02-04 05:22:26 | Faulk, South Dakota, US |
1678493 | 1678493 | 2021-02-01 | US | Montana | Sweet Grass | 30097 | 331 | 6 | 0 | 325 | 45.81367654 | -109.9425686 | 2021-02-02 05:22:49 | Sweet Grass, Montana, US |
1463421 | 1463421 | 2021-01-31 | Vietnam | 1817 | 35 | 1457 | 325 | 14.058324 | 108.277199 | 2021-02-01 05:22:53 | Vietnam | |||
1462364 | 1462364 | 2021-01-31 | US | Oregon | Curry | 41015 | 330 | 5 | 0 | 325 | 42.45911325 | -124.157282 | 2021-02-01 05:22:53 | Curry, Oregon, US |
1461781 | 1461781 | 2021-01-31 | US | Montana | Sweet Grass | 30097 | 331 | 6 | 0 | 325 | 45.81367654 | -109.9425686 | 2021-02-01 05:22:53 | Sweet Grass, Montana, US |
1461074 | 1461074 | 2021-01-31 | US | Kansas | Ness | 20135 | 340 | 15 | 0 | 325 | 38.47974157 | -99.91547333 | 2021-02-01 05:22:53 | Ness, Kansas, US |
2215180 | 2215180 | 2021-01-30 | US | West Virginia | Wirt | 54105 | 327 | 2 | 0 | 325 | 39.02775007 | -81.37473928 | 2021-01-31 05:22:42 | Wirt, West Virginia, US |
2214570 | 2214570 | 2021-01-30 | US | South Dakota | Ziebach | 46137 | 334 | 9 | 0 | 325 | 44.97881876 | -101.6654622 | 2021-01-31 05:22:42 | Ziebach, South Dakota, US |
2214272 | 2214272 | 2021-01-30 | US | Oregon | Curry | 41015 | 330 | 5 | 0 | 325 | 42.45911325 | -124.157282 | 2021-01-31 05:22:42 | Curry, Oregon, US |
2213689 | 2213689 | 2021-01-30 | US | Montana | Sweet Grass | 30097 | 331 | 6 | 0 | 325 | 45.81367654 | -109.9425686 | 2021-01-31 05:22:42 | Sweet Grass, Montana, US |
2212982 | 2212982 | 2021-01-30 | US | Kansas | Ness | 20135 | 340 | 15 | 0 | 325 | 38.47974157 | -99.91547333 | 2021-01-31 05:22:42 | Ness, Kansas, US |
1900057 | 1900057 | 2021-01-29 | US | South Dakota | Ziebach | 46137 | 334 | 9 | 0 | 325 | 44.97881876 | -101.6654622 | 2021-01-30 05:22:49 | Ziebach, South Dakota, US |
1899176 | 1899176 | 2021-01-29 | US | Montana | Sweet Grass | 30097 | 331 | 6 | 0 | 325 | 45.81367654 | -109.9425686 | 2021-01-30 05:22:49 | Sweet Grass, Montana, US |
1898469 | 1898469 | 2021-01-29 | US | Kansas | Ness | 20135 | 340 | 15 | 0 | 325 | 38.47974157 | -99.91547333 | 2021-01-30 05:22:49 | Ness, Kansas, US |
2484873 | 2484873 | 2021-01-28 | US | South Dakota | Ziebach | 46137 | 334 | 9 | 0 | 325 | 44.97881876 | -101.6654622 | 2021-01-29 05:22:23 | Ziebach, South Dakota, US |
3156508 | 3156508 | 2021-01-27 | US | South Dakota | Ziebach | 46137 | 334 | 9 | 0 | 325 | 44.97881876 | -101.6654622 | 2021-01-28 05:22:24 | Ziebach, South Dakota, US |
3154514 | 3154514 | 2021-01-27 | US | Idaho | Bear Lake | 16007 | 327 | 2 | 0 | 325 | 42.28269683 | -111.32892379999998 | 2021-01-28 05:22:24 | Bear Lake, Idaho, US |
15243 | 15243 | 2021-01-26 | US | South Dakota | Ziebach | 46137 | 334 | 9 | 0 | 325 | 44.97881876 | -101.6654622 | 2021-01-27 05:23:41 | Ziebach, South Dakota, US |
15206 | 15206 | 2021-01-26 | US | South Dakota | Hanson | 46061 | 329 | 4 | 0 | 325 | 43.6746384 | -97.78715148 | 2021-01-27 05:23:41 | Hanson, South Dakota, US |
2570530 | 2570530 | 2021-01-25 | US | South Dakota | Hanson | 46061 | 329 | 4 | 0 | 325 | 43.6746384 | -97.78715148 | 2021-01-26 05:22:02 | Hanson, South Dakota, US |
1762162 | 1762162 | 2021-01-24 | US | South Dakota | Hanson | 46061 | 329 | 4 | 0 | 325 | 43.6746384 | -97.78715148 | 2021-01-25 05:22:16 | Hanson, South Dakota, US |
1760962 | 1760962 | 2021-01-24 | US | Michigan | Ontonagon | 26131 | 343 | 18 | 0 | 325 | 46.665226200000006 | -89.31390481 | 2021-01-25 05:22:16 | Ontonagon, Michigan, US |
2429806 | 2429806 | 2021-01-23 | US | South Dakota | Ziebach | 46137 | 333 | 8 | 0 | 325 | 44.97881876 | -101.6654622 | 2021-01-24 05:22:35 | Ziebach, South Dakota, US |
2429769 | 2429769 | 2021-01-23 | US | South Dakota | Hanson | 46061 | 329 | 4 | 0 | 325 | 43.6746384 | -97.78715148 | 2021-01-24 05:22:35 | Hanson, South Dakota, US |
2428569 | 2428569 | 2021-01-23 | US | Michigan | Ontonagon | 26131 | 343 | 18 | 0 | 325 | 46.665226200000006 | -89.31390481 | 2021-01-24 05:22:35 | Ontonagon, Michigan, US |
2470082 | 2470082 | 2021-01-22 | US | Vermont | Lamoille | 50015 | 326 | 1 | 0 | 325 | 44.60353043 | -72.64356694 | 2021-01-23 05:22:03 | Lamoille, Vermont, US |
2469671 | 2469671 | 2021-01-22 | US | South Dakota | Hanson | 46061 | 329 | 4 | 0 | 325 | 43.6746384 | -97.78715148 | 2021-01-23 05:22:03 | Hanson, South Dakota, US |
2469653 | 2469653 | 2021-01-22 | US | South Dakota | Clark | 46025 | 329 | 4 | 0 | 325 | 44.85834507 | -97.72925109 | 2021-01-23 05:22:03 | Clark, South Dakota, US |
438259 | 438259 | 2021-01-21 | US | South Dakota | Ziebach | 46137 | 333 | 8 | 0 | 325 | 44.97881876 | -101.6654622 | 2021-01-22 05:22:10 | Ziebach, South Dakota, US |
438222 | 438222 | 2021-01-21 | US | South Dakota | Hanson | 46061 | 329 | 4 | 0 | 325 | 43.6746384 | -97.78715148 | 2021-01-22 05:22:10 | Hanson, South Dakota, US |
438204 | 438204 | 2021-01-21 | US | South Dakota | Clark | 46025 | 329 | 4 | 0 | 325 | 44.85834507 | -97.72925109 | 2021-01-22 05:22:10 | Clark, South Dakota, US |
435125 | 435125 | 2021-01-21 | Canada | New Brunswick | 1057 | 13 | 719 | 325 | 46.5653 | -66.4619 | 2021-01-22 05:22:10 | New Brunswick, Canada | ||
1096990 | 1096990 | 2021-01-20 | US | South Dakota | Ziebach | 46137 | 333 | 8 | 0 | 325 | 44.97881876 | -101.6654622 | 2021-01-21 05:22:01 | Ziebach, South Dakota, US |
1096935 | 1096935 | 2021-01-20 | US | South Dakota | Clark | 46025 | 329 | 4 | 0 | 325 | 44.85834507 | -97.72925109 | 2021-01-21 05:22:01 | Clark, South Dakota, US |
1095755 | 1095755 | 2021-01-20 | US | Michigan | Oscoda | 26135 | 344 | 19 | 0 | 325 | 44.68192279 | -84.12939244 | 2021-01-21 05:22:01 | Oscoda, Michigan, US |
239194 | 239194 | 2021-01-18 | US | Missouri | Shelby | 29205 | 329 | 4 | 0 | 325 | 39.79742518 | -92.07634971 | 2021-01-19 05:22:15 | Shelby, Missouri, US |
3103535 | 3103535 | 2021-01-16 | US | Nebraska | Nuckolls | 31129 | 326 | 1 | 0 | 325 | 40.17637905 | -98.04743961 | 2021-01-17 05:22:17 | Nuckolls, Nebraska, US |
3517497 | 3517497 | 2021-01-15 | US | Nebraska | Nuckolls | 31129 | 326 | 1 | 0 | 325 | 40.17637905 | -98.04743961 | 2021-01-16 05:22:40 | Nuckolls, Nebraska, US |
3880173 | 3880173 | 2021-01-14 | US | Colorado | Clear Creek | 8019 | 346 | 2 | 0 | 325 | 39.68864463 | -105.6463118 | 2021-01-15 05:22:24 | Clear Creek, Colorado, US |
776369 | 776369 | 2021-01-12 | US | Montana | Teton | 30099 | 330 | 5 | 0 | 325 | 47.83741052 | -112.2410688 | 2021-01-13 05:22:15 | Teton, Montana, US |
2628577 | 2628577 | 2021-01-10 | US | Puerto Rico | Aibonito | 72009 | 325 | 0 | 0 | 325 | 18.131361 | -66.264131 | 2021-01-11 05:21:50 | Aibonito, Puerto Rico, US |
3902072 | 3902072 | 2021-01-09 | US | Nebraska | Stanton | 31167 | 333 | 8 | 0 | 325 | 41.9169835 | -97.19394708 | 2021-01-10 05:22:12 | Stanton, Nebraska, US |
3901935 | 3901935 | 2021-01-09 | US | Montana | Broadwater | 30007 | 326 | 1 | 0 | 325 | 46.33277565 | -111.4955813 | 2021-01-10 05:22:12 | Broadwater, Montana, US |
156095 | 156095 | 2021-01-08 | US | Nebraska | Stanton | 31167 | 333 | 8 | 0 | 325 | 41.9169835 | -97.19394708 | 2021-01-09 05:22:18 | Stanton, Nebraska, US |
154814 | 154814 | 2021-01-08 | US | Georgia | Marion | 13197 | 335 | 10 | 0 | 325 | 32.3483402 | -84.52733571 | 2021-01-09 05:22:18 | Marion, Georgia, US |
2542879 | 2542879 | 2021-01-07 | US | Kentucky | Wolfe | 21237 | 329 | 4 | 0 | 325 | 37.73941626 | -83.49303612 | 2021-01-08 05:22:42 | Wolfe, Kentucky, US |
2542854 | 2542854 | 2021-01-07 | US | Kentucky | Owsley | 21189 | 335 | 10 | 0 | 325 | 37.42823949 | -83.68811419 | 2021-01-08 05:22:42 | Owsley, Kentucky, US |
2868394 | 2868394 | 2021-01-06 | Malaysia | Perak | 3424 | 18 | 3081 | 325 | 4.5921 | 101.0901 | 2021-01-07 05:22:03 | Perak, Malaysia | ||
2866434 | 2866434 | 2021-01-06 | US | Minnesota | Kittson | 27069 | 343 | 18 | 0 | 325 | 48.77754106 | -96.78317184 | 2021-01-07 05:22:03 | Kittson, Minnesota, US |
2865050 | 2865050 | 2021-01-06 | Trinidad and Tobago | 7196 | 127 | 6744 | 325 | 10.6918 | -61.2225 | 2021-01-07 05:22:03 | Trinidad and Tobago | |||
1062876 | 1062876 | 2021-01-04 | US | Illinois | Putnam | 17155 | 326 | 1 | 0 | 325 | 41.2013541 | -89.2869272 | 2021-01-05 05:21:49 | Putnam, Illinois, 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]);