johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where deaths = 1882 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
292806 | 292806 | 2022-11-15 | US | Georgia | DeKalb | 13089 | 181975 | 1882 | 0 | 33.76944049 | -84.22396017 | 2022-11-16 04:21:09 | DeKalb, Georgia, US | |
3597836 | 3597836 | 2022-11-14 | US | Georgia | DeKalb | 13089 | 181975 | 1882 | 0 | 33.76944049 | -84.22396017 | 2022-11-15 04:21:16 | DeKalb, Georgia, US | |
312694 | 312694 | 2022-11-13 | US | Georgia | DeKalb | 13089 | 181975 | 1882 | 0 | 33.76944049 | -84.22396017 | 2022-11-14 04:21:09 | DeKalb, Georgia, US | |
63855 | 63855 | 2022-11-12 | US | Georgia | DeKalb | 13089 | 181975 | 1882 | 0 | 33.76944049 | -84.22396017 | 2022-11-13 04:21:14 | DeKalb, Georgia, US | |
2928017 | 2928017 | 2022-11-11 | US | Georgia | DeKalb | 13089 | 181975 | 1882 | 0 | 33.76944049 | -84.22396017 | 2022-11-12 04:20:41 | DeKalb, Georgia, US | |
2506853 | 2506853 | 2022-11-10 | US | Georgia | DeKalb | 13089 | 181975 | 1882 | 0 | 33.76944049 | -84.22396017 | 2022-11-11 04:21:22 | DeKalb, Georgia, US | |
2431728 | 2431728 | 2022-11-09 | US | Georgia | DeKalb | 13089 | 181975 | 1882 | 0 | 33.76944049 | -84.22396017 | 2022-11-10 04:21:16 | DeKalb, Georgia, US | |
795992 | 795992 | 2022-10-24 | US | Maryland | Baltimore City | 24510 | 138314 | 1882 | 0 | 39.30211911 | -76.61151012 | 2022-10-25 04:21:53 | Baltimore City, Maryland, US | |
3278447 | 3278447 | 2022-10-23 | US | Maryland | Baltimore City | 24510 | 138224 | 1882 | 0 | 39.30211911 | -76.61151012 | 2022-10-24 04:22:29 | Baltimore City, Maryland, US | |
2269485 | 2269485 | 2022-10-22 | US | Maryland | Baltimore City | 24510 | 138224 | 1882 | 0 | 39.30211911 | -76.61151012 | 2022-10-23 04:22:46 | Baltimore City, Maryland, US | |
1593785 | 1593785 | 2022-10-21 | US | Maryland | Baltimore City | 24510 | 138224 | 1882 | 0 | 39.30211911 | -76.61151012 | 2022-10-22 04:22:53 | Baltimore City, Maryland, US | |
1976382 | 1976382 | 2022-09-25 | Chile | Antofagasta | 165151 | 1882 | 0 | -23.6509 | -70.3975 | 2022-09-26 04:20:52 | Antofagasta, Chile | |||
2345029 | 2345029 | 2022-08-31 | US | Massachusetts | Hampden | 25013 | 153726 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-09-01 04:21:03 | Hampden, Massachusetts, US | |
3775509 | 3775509 | 2022-08-30 | US | Massachusetts | Hampden | 25013 | 153726 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-31 04:20:57 | Hampden, Massachusetts, US | |
1682105 | 1682105 | 2022-08-29 | US | Massachusetts | Hampden | 25013 | 153726 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-30 04:21:03 | Hampden, Massachusetts, US | |
1878589 | 1878589 | 2022-08-28 | US | Massachusetts | Hampden | 25013 | 153726 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-29 04:21:06 | Hampden, Massachusetts, US | |
2097716 | 2097716 | 2022-08-27 | US | Massachusetts | Hampden | 25013 | 153726 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-28 04:21:02 | Hampden, Massachusetts, US | |
1533531 | 1533531 | 2022-08-26 | US | Massachusetts | Hampden | 25013 | 153726 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-27 04:20:57 | Hampden, Massachusetts, US | |
2830418 | 2830418 | 2022-08-25 | US | Massachusetts | Hampden | 25013 | 153726 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-26 04:21:02 | Hampden, Massachusetts, US | |
2324951 | 2324951 | 2022-08-24 | US | Massachusetts | Hampden | 25013 | 152827 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-25 04:21:13 | Hampden, Massachusetts, US | |
1252926 | 1252926 | 2022-08-23 | US | New Jersey | Camden | 34007 | 148610 | 1882 | 0 | 39.80343818 | -74.96388753 | 2022-08-24 04:20:46 | Camden, New Jersey, US | |
1252360 | 1252360 | 2022-08-23 | US | Massachusetts | Hampden | 25013 | 152827 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-24 04:20:46 | Hampden, Massachusetts, US | |
1251869 | 1251869 | 2022-08-23 | US | Indiana | Lake | 18089 | 121107 | 1882 | 0 | 41.41874274 | -87.38277575 | 2022-08-24 04:20:46 | Lake, Indiana, US | |
2854464 | 2854464 | 2022-08-22 | US | Massachusetts | Hampden | 25013 | 152827 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-23 04:20:56 | Hampden, Massachusetts, US | |
2853973 | 2853973 | 2022-08-22 | US | Indiana | Lake | 18089 | 121107 | 1882 | 0 | 41.41874274 | -87.38277575 | 2022-08-23 04:20:56 | Lake, Indiana, US | |
2404436 | 2404436 | 2022-08-21 | US | Massachusetts | Hampden | 25013 | 152827 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-22 04:20:38 | Hampden, Massachusetts, US | |
2403945 | 2403945 | 2022-08-21 | US | Indiana | Lake | 18089 | 120885 | 1882 | 0 | 41.41874274 | -87.38277575 | 2022-08-22 04:20:38 | Lake, Indiana, US | |
3799514 | 3799514 | 2022-08-20 | US | Massachusetts | Hampden | 25013 | 152827 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-21 04:20:44 | Hampden, Massachusetts, US | |
3799023 | 3799023 | 2022-08-20 | US | Indiana | Lake | 18089 | 120885 | 1882 | 0 | 41.41874274 | -87.38277575 | 2022-08-21 04:20:44 | Lake, Indiana, US | |
2365100 | 2365100 | 2022-08-19 | US | Massachusetts | Hampden | 25013 | 152827 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-20 04:21:01 | Hampden, Massachusetts, US | |
2364609 | 2364609 | 2022-08-19 | US | Indiana | Lake | 18089 | 120885 | 1882 | 0 | 41.41874274 | -87.38277575 | 2022-08-20 04:21:01 | Lake, Indiana, US | |
1162771 | 1162771 | 2022-08-18 | US | Massachusetts | Hampden | 25013 | 152827 | 1882 | 0 | 42.13440424 | -72.63235561 | 2022-08-19 04:20:54 | Hampden, Massachusetts, US | |
3617324 | 3617324 | 2022-08-01 | Russia | Pskov Oblast | 112029 | 1882 | 0 | 57.5358729 | 28.8586826 | 2022-08-02 04:20:53 | Pskov Oblast, Russia | |||
3871804 | 3871804 | 2022-07-31 | Russia | Pskov Oblast | 111992 | 1882 | 0 | 57.5358729 | 28.8586826 | 2022-08-01 04:21:03 | Pskov Oblast, Russia | |||
1211758 | 1211758 | 2022-07-11 | Russia | Kabardino-Balkarian Republic | 62194 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-12 04:20:51 | Kabardino-Balkarian Republic, Russia | |||
2789240 | 2789240 | 2022-07-10 | Russia | Kabardino-Balkarian Republic | 62186 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-11 04:20:46 | Kabardino-Balkarian Republic, Russia | |||
142193 | 142193 | 2022-07-09 | Russia | Kabardino-Balkarian Republic | 62179 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-10 04:20:54 | Kabardino-Balkarian Republic, Russia | |||
1417293 | 1417293 | 2022-07-08 | Russia | Kabardino-Balkarian Republic | 62172 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-09 04:20:59 | Kabardino-Balkarian Republic, Russia | |||
2741218 | 2741218 | 2022-07-07 | Russia | Kabardino-Balkarian Republic | 62166 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-08 04:20:56 | Kabardino-Balkarian Republic, Russia | |||
1200013 | 1200013 | 2022-07-06 | Russia | Kabardino-Balkarian Republic | 62162 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-07 04:20:55 | Kabardino-Balkarian Republic, Russia | |||
3966756 | 3966756 | 2022-07-05 | Russia | Kabardino-Balkarian Republic | 62158 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-06 04:20:58 | Kabardino-Balkarian Republic, Russia | |||
3078267 | 3078267 | 2022-07-04 | Russia | Kabardino-Balkarian Republic | 62154 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-05 04:20:45 | Kabardino-Balkarian Republic, Russia | |||
1767549 | 1767549 | 2022-07-03 | Russia | Kabardino-Balkarian Republic | 62149 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-04 04:20:54 | Kabardino-Balkarian Republic, Russia | |||
3365535 | 3365535 | 2022-07-02 | Russia | Kabardino-Balkarian Republic | 62144 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-03 04:20:59 | Kabardino-Balkarian Republic, Russia | |||
593864 | 593864 | 2022-07-01 | Russia | Kabardino-Balkarian Republic | 62137 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-02 04:21:16 | Kabardino-Balkarian Republic, Russia | |||
3940265 | 3940265 | 2022-06-30 | Russia | Kabardino-Balkarian Republic | 62132 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-07-01 04:21:10 | Kabardino-Balkarian Republic, Russia | |||
2490223 | 2490223 | 2022-06-29 | Russia | Kabardino-Balkarian Republic | 62127 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-30 04:21:01 | Kabardino-Balkarian Republic, Russia | |||
2239605 | 2239605 | 2022-06-28 | Russia | Kabardino-Balkarian Republic | 62121 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-29 04:20:59 | Kabardino-Balkarian Republic, Russia | |||
2147847 | 2147847 | 2022-06-27 | Russia | Kabardino-Balkarian Republic | 62115 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-28 04:20:58 | Kabardino-Balkarian Republic, Russia | |||
475648 | 475648 | 2022-06-26 | Russia | Kabardino-Balkarian Republic | 62107 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-27 04:21:00 | Kabardino-Balkarian Republic, Russia | |||
939023 | 939023 | 2022-06-25 | Russia | Kabardino-Balkarian Republic | 62099 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-26 04:21:02 | Kabardino-Balkarian Republic, Russia | |||
3346843 | 3346843 | 2022-06-24 | Russia | Kabardino-Balkarian Republic | 62091 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-25 04:20:57 | Kabardino-Balkarian Republic, Russia | |||
1648584 | 1648584 | 2022-06-23 | Russia | Kabardino-Balkarian Republic | 62084 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-24 04:20:58 | Kabardino-Balkarian Republic, Russia | |||
2187819 | 2187819 | 2022-06-22 | Russia | Kabardino-Balkarian Republic | 62078 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-23 04:20:55 | Kabardino-Balkarian Republic, Russia | |||
166250 | 166250 | 2022-06-21 | Russia | Kabardino-Balkarian Republic | 62073 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-22 04:20:54 | Kabardino-Balkarian Republic, Russia | |||
166025 | 166025 | 2022-06-21 | Italy | Umbria | 296016 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-22 04:20:54 | Umbria, Italy | |||
1763533 | 1763533 | 2022-06-20 | Russia | Kabardino-Balkarian Republic | 62068 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-21 04:20:56 | Kabardino-Balkarian Republic, Russia | |||
1763308 | 1763308 | 2022-06-20 | Italy | Umbria | 295154 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-21 04:20:56 | Umbria, Italy | |||
3269719 | 3269719 | 2022-06-19 | Russia | Kabardino-Balkarian Republic | 62062 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-20 04:21:01 | Kabardino-Balkarian Republic, Russia | |||
3269494 | 3269494 | 2022-06-19 | Italy | Umbria | 294852 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-20 04:21:01 | Umbria, Italy | |||
3397631 | 3397631 | 2022-06-18 | Russia | Kabardino-Balkarian Republic | 62056 | 1882 | 0 | 43.4806048 | 43.5978976 | 2022-06-19 04:20:51 | Kabardino-Balkarian Republic, Russia | |||
3397406 | 3397406 | 2022-06-18 | Italy | Umbria | 294253 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-19 04:20:51 | Umbria, Italy | |||
2311283 | 2311283 | 2022-06-17 | Italy | Umbria | 293615 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-18 04:21:10 | Umbria, Italy | |||
558787 | 558787 | 2022-06-16 | Italy | Umbria | 292982 | 1882 | 0 | 43.10675841 | 12.38824698 | 2022-06-17 04:20:56 | Umbria, Italy | |||
3728886 | 3728886 | 2022-06-07 | US | Pennsylvania | Delaware | 42045 | 117605 | 1882 | 0 | 39.91680171 | -75.40243663 | 2022-06-08 04:20:55 | Delaware, Pennsylvania, US | |
3890288 | 3890288 | 2022-06-06 | US | Pennsylvania | Delaware | 42045 | 117605 | 1882 | 0 | 39.91680171 | -75.40243663 | 2022-06-07 04:21:08 | Delaware, Pennsylvania, US | |
3510057 | 3510057 | 2022-06-05 | US | Pennsylvania | Delaware | 42045 | 117605 | 1882 | 0 | 39.91680171 | -75.40243663 | 2022-06-06 04:20:57 | Delaware, Pennsylvania, US | |
3530134 | 3530134 | 2022-06-04 | US | Pennsylvania | Delaware | 42045 | 117605 | 1882 | 0 | 39.91680171 | -75.40243663 | 2022-06-05 04:20:55 | Delaware, Pennsylvania, US | |
3136220 | 3136220 | 2022-06-03 | US | Pennsylvania | Delaware | 42045 | 117605 | 1882 | 0 | 39.91680171 | -75.40243663 | 2022-06-04 04:20:58 | Delaware, Pennsylvania, US | |
3581295 | 3581295 | 2022-06-02 | US | Pennsylvania | Delaware | 42045 | 117605 | 1882 | 0 | 39.91680171 | -75.40243663 | 2022-06-03 04:20:58 | Delaware, Pennsylvania, US | |
973588 | 973588 | 2022-06-01 | US | Pennsylvania | Delaware | 42045 | 117605 | 1882 | 0 | 39.91680171 | -75.40243663 | 2022-06-02 05:20:39 | Delaware, Pennsylvania, US | |
3722407 | 3722407 | 2022-04-25 | Russia | Kaliningrad Oblast | 167694 | 1882 | 0 | 54.7293041 | 21.1489473 | 2022-04-26 04:20:51 | Kaliningrad Oblast, Russia | |||
2253030 | 2253030 | 2022-04-19 | US | Massachusetts | Norfolk | 25021 | 134286 | 1882 | 0 | 42.16073095 | -71.20530408 | 2022-04-20 04:20:45 | Norfolk, Massachusetts, US | |
1848656 | 1848656 | 2022-04-18 | US | Pennsylvania | Lancaster | 42071 | 121233 | 1882 | 0 | 40.03904563 | -76.24770128 | 2022-04-19 04:21:00 | Lancaster, Pennsylvania, US | |
3419600 | 3419600 | 2022-04-17 | US | Pennsylvania | Lancaster | 42071 | 121212 | 1882 | 0 | 40.03904563 | -76.24770128 | 2022-04-18 04:21:12 | Lancaster, Pennsylvania, US | |
306549 | 306549 | 2022-04-16 | US | Pennsylvania | Lancaster | 42071 | 121190 | 1882 | 0 | 40.03904563 | -76.24770128 | 2022-04-17 04:20:59 | Lancaster, Pennsylvania, US | |
2445410 | 2445410 | 2022-04-13 | US | Pennsylvania | Bucks | 42017 | 123455 | 1882 | 0 | 40.33682119 | -75.10836643 | 2022-04-13 23:21:06 | Bucks, Pennsylvania, US | |
1951167 | 1951167 | 2022-04-12 | US | Pennsylvania | Bucks | 42017 | 123401 | 1882 | 0 | 40.33682119 | -75.10836643 | 2022-04-13 04:21:03 | Bucks, Pennsylvania, US | |
3208920 | 3208920 | 2022-04-11 | US | Pennsylvania | Bucks | 42017 | 123322 | 1882 | 0 | 40.33682119 | -75.10836643 | 2022-04-12 04:20:49 | Bucks, Pennsylvania, US | |
1578806 | 1578806 | 2022-04-10 | US | Pennsylvania | Bucks | 42017 | 123296 | 1882 | 0 | 40.33682119 | -75.10836643 | 2022-04-11 04:21:02 | Bucks, Pennsylvania, US | |
1655048 | 1655048 | 2022-04-09 | US | Pennsylvania | Bucks | 42017 | 123270 | 1882 | 0 | 40.33682119 | -75.10836643 | 2022-04-10 04:20:52 | Bucks, Pennsylvania, US | |
2118370 | 2118370 | 2022-04-08 | US | Pennsylvania | Bucks | 42017 | 123222 | 1882 | 0 | 40.33682119 | -75.10836643 | 2022-04-09 04:20:42 | Bucks, Pennsylvania, US | |
694288 | 694288 | 2022-03-17 | Germany | Mecklenburg-Vorpommern | 323039 | 1882 | 0 | 53.6127 | 12.4296 | 2022-03-18 04:20:55 | Mecklenburg-Vorpommern, Germany | |||
71810 | 71810 | 2022-02-07 | US | Florida | Marion | 12083 | 79757 | 1882 | 0 | 29.21227113 | -82.05803627 | 2022-02-08 04:21:15 | Marion, Florida, US | |
2013426 | 2013426 | 2022-02-06 | US | Florida | Marion | 12083 | 79757 | 1882 | 0 | 29.21227113 | -82.05803627 | 2022-02-07 04:21:05 | Marion, Florida, US | |
1294755 | 1294755 | 2022-02-05 | US | Florida | Marion | 12083 | 79757 | 1882 | 0 | 29.21227113 | -82.05803627 | 2022-02-06 04:21:00 | Marion, Florida, US | |
2328083 | 2328083 | 2022-02-04 | US | Florida | Marion | 12083 | 79757 | 1882 | 0 | 29.21227113 | -82.05803627 | 2022-02-05 04:21:05 | Marion, Florida, US | |
2476451 | 2476451 | 2022-02-03 | US | Ohio | Montgomery | 39113 | 123292 | 1882 | 0 | 39.75394919 | -84.29050975 | 2022-02-04 04:21:10 | Montgomery, Ohio, US | |
459155 | 459155 | 2022-02-02 | Chile | Maule | 124045 | 1882 | 0 | -35.5183 | -71.6885 | 2022-02-03 04:21:21 | Maule, Chile | |||
981990 | 981990 | 2022-02-01 | US | Texas | Cameron | 48061 | 92050 | 1882 | 0 | 26.14524221 | -97.48140372 | 2022-02-02 04:21:09 | Cameron, Texas, US | |
978724 | 978724 | 2022-02-01 | Chile | Maule | 122394 | 1882 | 0 | -35.5183 | -71.6885 | 2022-02-02 04:21:09 | Maule, Chile | |||
2657566 | 2657566 | 2022-01-31 | Chile | Maule | 121157 | 1882 | 0 | -35.5183 | -71.6885 | 2022-02-01 04:21:11 | Maule, Chile | |||
1964123 | 1964123 | 2022-01-20 | US | Wisconsin | Milwaukee | 55079 | 252921 | 1882 | 0 | 43.00486062 | -87.96733172 | 2022-01-21 04:21:09 | Milwaukee, Wisconsin, US | |
555093 | 555093 | 2022-01-16 | Spain | Murcia | 245050 | 1882 | 0 | 37.9922 | -1.1307 | 2022-01-17 04:21:08 | Murcia, Spain | |||
3840814 | 3840814 | 2022-01-15 | Spain | Murcia | 245050 | 1882 | 0 | 37.9922 | -1.1307 | 2022-01-16 04:21:12 | Murcia, Spain | |||
99629 | 99629 | 2022-01-14 | Spain | Murcia | 245050 | 1882 | 0 | 37.9922 | -1.1307 | 2022-01-15 04:21:07 | Murcia, Spain | |||
1113536 | 1113536 | 2022-01-11 | India | Puducherry | 131211 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-12 04:21:44 | Puducherry, India | |||
1692264 | 1692264 | 2022-01-10 | India | Puducherry | 131211 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-11 04:22:01 | Puducherry, India | |||
126679 | 126679 | 2022-01-09 | India | Puducherry | 130722 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-10 04:22:07 | Puducherry, India | |||
1215514 | 1215514 | 2022-01-08 | India | Puducherry | 130278 | 1882 | 0 | 11.882658000000001 | 78.86498 | 2022-01-09 04:21:46 | Puducherry, India |
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]);