johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
356 rows where active = 576 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Missouri 34
- Georgia 31
- Texas 26
- Virginia 19
- Mississippi 17
- Michigan 14
- North Carolina 14
- Arkansas 13
- Kentucky 13
- Iowa 12
- Nebraska 11
- Alabama 9
- Idaho 9
- Indiana 9
- Oklahoma 9
- Puerto Rico 9
- Florida 8
- Illinois 8
- Kansas 8
- Wisconsin 7
- Alaska 6
- Minnesota 6
- Tennessee 6
- Louisiana 5
- Wyoming 5
- Colorado 4
- Ohio 4
- Oregon 4
- South Carolina 4
- South Dakota 4
- …
country_or_region 1
- US · 356 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1618130 | 1618130 | 2021-03-05 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-03-06 04:23:41 | Daviess, Missouri, US |
2209541 | 2209541 | 2021-03-04 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-03-05 05:26:29 | Daviess, Missouri, US |
1091632 | 1091632 | 2021-03-03 | US | Maine | Waldo | 23027 | 595 | 19 | 0 | 576 | 44.4858305 | -69.12061935 | 2021-03-04 05:24:24 | Waldo, Maine, US |
1091962 | 1091962 | 2021-03-03 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-03-04 05:24:24 | Daviess, Missouri, US |
3256034 | 3256034 | 2021-03-02 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-03-03 05:23:28 | Daviess, Missouri, US |
3256165 | 3256165 | 2021-03-02 | US | Montana | Sanders | 30089 | 585 | 9 | 0 | 576 | 47.67657534 | -115.1329916 | 2021-03-03 05:23:28 | Sanders, Montana, US |
1000326 | 1000326 | 2021-03-01 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-03-02 05:23:30 | Daviess, Missouri, US |
1000395 | 1000395 | 2021-03-01 | US | Missouri | St. Clair | 29185 | 583 | 7 | 0 | 576 | 38.03699437 | -93.77631447 | 2021-03-02 05:23:30 | St. Clair, Missouri, US |
2369384 | 2369384 | 2021-02-28 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-03-01 05:23:01 | Daviess, Missouri, US |
2369453 | 2369453 | 2021-02-28 | US | Missouri | St. Clair | 29185 | 583 | 7 | 0 | 576 | 38.03699437 | -93.77631447 | 2021-03-01 05:23:01 | St. Clair, Missouri, US |
3067886 | 3067886 | 2021-02-27 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-02-28 05:22:20 | Daviess, Missouri, US |
3067955 | 3067955 | 2021-02-27 | US | Missouri | St. Clair | 29185 | 583 | 7 | 0 | 576 | 38.03699437 | -93.77631447 | 2021-02-28 05:22:20 | St. Clair, Missouri, US |
3068756 | 3068756 | 2021-02-27 | US | Puerto Rico | Orocovis | 72107 | 576 | 0 | 0 | 576 | 18.215046 | -66.433604 | 2021-02-28 05:22:20 | Orocovis, Puerto Rico, US |
2185470 | 2185470 | 2021-02-26 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-02-27 05:22:28 | Daviess, Missouri, US |
2186904 | 2186904 | 2021-02-26 | US | Virginia | Emporia | 51595 | 615 | 39 | 0 | 576 | 36.69455571 | -77.53406129 | 2021-02-27 05:22:28 | Emporia, Virginia, US |
1859892 | 1859892 | 2021-02-25 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-02-26 05:22:40 | Daviess, Missouri, US |
1861609 | 1861609 | 2021-02-25 | US | Wyoming | Platte | 56031 | 587 | 11 | 0 | 576 | 42.13299116 | -104.966331 | 2021-02-26 05:22:40 | Platte, Wyoming, US |
282070 | 282070 | 2021-02-24 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-02-25 05:24:57 | Daviess, Missouri, US |
282905 | 282905 | 2021-02-24 | US | Puerto Rico | Ciales | 72039 | 576 | 0 | 0 | 576 | 18.28885 | -66.516475 | 2021-02-25 05:24:57 | Ciales, Puerto Rico, US |
283504 | 283504 | 2021-02-24 | US | Virginia | Emporia | 51595 | 614 | 38 | 0 | 576 | 36.69455571 | -77.53406129 | 2021-02-25 05:24:57 | Emporia, Virginia, US |
1937331 | 1937331 | 2021-02-23 | US | Georgia | Twiggs | 13289 | 611 | 35 | 0 | 576 | 32.67435595 | -83.43078662 | 2021-02-24 05:29:16 | Twiggs, Georgia, US |
1938069 | 1938069 | 2021-02-23 | US | Michigan | Crawford | 26039 | 581 | 5 | 0 | 576 | 44.68255561 | -84.61006219 | 2021-02-24 05:29:16 | Crawford, Michigan, US |
1938338 | 1938338 | 2021-02-23 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-02-24 05:29:16 | Daviess, Missouri, US |
532593 | 532593 | 2021-02-22 | US | Missouri | Daviess | 29061 | 587 | 11 | 0 | 576 | 39.96145298 | -93.98519678 | 2021-02-23 05:23:41 | Daviess, Missouri, US |
745635 | 745635 | 2021-02-20 | US | Virginia | Emporia | 51595 | 611 | 35 | 0 | 576 | 36.69455571 | -77.53406129 | 2021-02-21 05:24:33 | Emporia, Virginia, US |
474733 | 474733 | 2021-02-19 | US | Virginia | Emporia | 51595 | 611 | 35 | 0 | 576 | 36.69455571 | -77.53406129 | 2021-02-20 05:22:51 | Emporia, Virginia, US |
1156442 | 1156442 | 2021-02-18 | US | Virginia | Emporia | 51595 | 611 | 35 | 0 | 576 | 36.69455571 | -77.53406129 | 2021-02-19 05:24:16 | Emporia, Virginia, US |
1338700 | 1338700 | 2021-02-15 | US | Alaska | Northwest Arctic | 2188 | 577 | 1 | 0 | 576 | 67.04919196 | -159.7503946 | 2021-02-16 05:24:38 | Northwest Arctic, Alaska, US |
1340201 | 1340201 | 2021-02-15 | US | Missouri | Monroe | 29137 | 586 | 10 | 0 | 576 | 39.49593978 | -92.00043978 | 2021-02-16 05:24:38 | Monroe, Missouri, US |
1340375 | 1340375 | 2021-02-15 | US | Nebraska | Pierce | 31139 | 596 | 20 | 0 | 576 | 42.26434853 | -97.60122773 | 2021-02-16 05:24:38 | Pierce, Nebraska, US |
2283851 | 2283851 | 2021-02-14 | US | Alaska | Northwest Arctic | 2188 | 577 | 1 | 0 | 576 | 67.04919196 | -159.7503946 | 2021-02-15 05:24:49 | Northwest Arctic, Alaska, US |
2285526 | 2285526 | 2021-02-14 | US | Nebraska | Pierce | 31139 | 596 | 20 | 0 | 576 | 42.26434853 | -97.60122773 | 2021-02-15 05:24:49 | Pierce, Nebraska, US |
2678251 | 2678251 | 2021-02-13 | US | Alaska | Northwest Arctic | 2188 | 577 | 1 | 0 | 576 | 67.04919196 | -159.7503946 | 2021-02-14 05:23:43 | Northwest Arctic, Alaska, US |
2679926 | 2679926 | 2021-02-13 | US | Nebraska | Pierce | 31139 | 596 | 20 | 0 | 576 | 42.26434853 | -97.60122773 | 2021-02-14 05:23:43 | Pierce, Nebraska, US |
3539884 | 3539884 | 2021-02-12 | US | Alaska | Northwest Arctic | 2188 | 577 | 1 | 0 | 576 | 67.04919196 | -159.7503946 | 2021-02-13 05:22:12 | Northwest Arctic, Alaska, US |
3541559 | 3541559 | 2021-02-12 | US | Nebraska | Pierce | 31139 | 596 | 20 | 0 | 576 | 42.26434853 | -97.60122773 | 2021-02-13 05:22:12 | Pierce, Nebraska, US |
2638147 | 2638147 | 2021-02-11 | US | Alaska | Northwest Arctic | 2188 | 577 | 1 | 0 | 576 | 67.04919196 | -159.7503946 | 2021-02-12 05:23:29 | Northwest Arctic, Alaska, US |
2640841 | 2640841 | 2021-02-11 | US | Texas | Jack | 48237 | 582 | 13 | 0 | 576 | 33.23377248 | -98.17283469 | 2021-02-12 05:23:29 | Jack, Texas, US |
3980503 | 3980503 | 2021-02-10 | US | Missouri | Monroe | 29137 | 584 | 8 | 0 | 576 | 39.49593978 | -92.00043978 | 2021-02-11 05:23:55 | Monroe, Missouri, US |
3981773 | 3981773 | 2021-02-10 | US | Texas | Refugio | 48391 | 635 | 17 | 0 | 576 | 28.3238976 | -97.15766311 | 2021-02-11 05:23:55 | Refugio, Texas, US |
1529823 | 1529823 | 2021-02-09 | US | Missouri | Monroe | 29137 | 584 | 8 | 0 | 576 | 39.49593978 | -92.00043978 | 2021-02-10 05:22:41 | Monroe, Missouri, US |
1531399 | 1531399 | 2021-02-09 | US | West Virginia | Ritchie | 54085 | 585 | 9 | 0 | 576 | 39.18094587 | -81.06356878 | 2021-02-10 05:22:41 | Ritchie, West Virginia, US |
615493 | 615493 | 2021-02-08 | US | Mississippi | Jefferson | 28063 | 601 | 25 | 0 | 576 | 31.73397872 | -91.03764977 | 2021-02-09 05:23:30 | Jefferson, Mississippi, US |
615614 | 615614 | 2021-02-08 | US | Missouri | Monroe | 29137 | 584 | 8 | 0 | 576 | 39.49593978 | -92.00043978 | 2021-02-09 05:23:30 | Monroe, Missouri, US |
1673232 | 1673232 | 2021-02-07 | US | Georgia | Crawford | 13079 | 589 | 13 | 0 | 576 | 32.71391813 | -83.98061238 | 2021-02-08 05:22:39 | Crawford, Georgia, US |
1675779 | 1675779 | 2021-02-07 | US | Virginia | Essex | 51057 | 580 | 4 | 0 | 576 | 37.93357639 | -76.94230311 | 2021-02-08 05:22:39 | Essex, Virginia, US |
976366 | 976366 | 2021-02-06 | US | Kentucky | Owen | 21187 | 583 | 7 | 0 | 576 | 38.51679143 | -84.82404619 | 2021-02-07 05:23:00 | Owen, Kentucky, US |
1589067 | 1589067 | 2021-02-05 | US | Georgia | Wheeler | 13309 | 598 | 22 | 0 | 576 | 32.12009104 | -82.72574721 | 2021-02-06 05:23:55 | Wheeler, Georgia, US |
1589569 | 1589569 | 2021-02-05 | US | Kentucky | Gallatin | 21077 | 595 | 19 | 0 | 576 | 38.75398691 | -84.8558382 | 2021-02-06 05:23:55 | Gallatin, Kentucky, US |
793577 | 793577 | 2021-02-04 | US | Texas | Red River | 48387 | 652 | 34 | 0 | 576 | 33.61886692 | -95.04841765 | 2021-02-05 05:22:38 | Red River, Texas, US |
1686826 | 1686826 | 2021-02-02 | US | North Carolina | Jones | 37103 | 592 | 16 | 0 | 576 | 35.02254606 | -77.35870791 | 2021-02-03 05:22:52 | Jones, North Carolina, US |
1687036 | 1687036 | 2021-02-02 | US | Oklahoma | Cotton | 40033 | 589 | 13 | 0 | 576 | 34.28845626 | -98.37053567 | 2021-02-03 05:22:52 | Cotton, Oklahoma, US |
1687654 | 1687654 | 2021-02-02 | US | Texas | Lynn | 48305 | 579 | 18 | 0 | 576 | 33.17657705 | -101.8162849 | 2021-02-03 05:22:52 | Lynn, Texas, US |
1678796 | 1678796 | 2021-02-01 | US | North Carolina | Jones | 37103 | 592 | 16 | 0 | 576 | 35.02254606 | -77.35870791 | 2021-02-02 05:22:49 | Jones, North Carolina, US |
1679624 | 1679624 | 2021-02-01 | US | Texas | Lynn | 48305 | 579 | 18 | 0 | 576 | 33.17657705 | -101.8162849 | 2021-02-02 05:22:49 | Lynn, Texas, US |
1462912 | 1462912 | 2021-01-31 | US | Texas | Lynn | 48305 | 579 | 18 | 0 | 576 | 33.17657705 | -101.8162849 | 2021-02-01 05:22:53 | Lynn, Texas, US |
2214820 | 2214820 | 2021-01-30 | US | Texas | Lynn | 48305 | 579 | 18 | 0 | 576 | 33.17657705 | -101.8162849 | 2021-01-31 05:22:42 | Lynn, Texas, US |
1899934 | 1899934 | 2021-01-29 | US | Puerto Rico | Villalba | 72149 | 576 | 0 | 0 | 576 | 18.127951 | -66.473115 | 2021-01-30 05:22:49 | Villalba, Puerto Rico, US |
1900307 | 1900307 | 2021-01-29 | US | Texas | Lynn | 48305 | 579 | 18 | 0 | 576 | 33.17657705 | -101.8162849 | 2021-01-30 05:22:49 | Lynn, Texas, US |
2485351 | 2485351 | 2021-01-28 | US | Virginia | Poquoson | 51735 | 583 | 7 | 0 | 576 | 37.14259351 | -76.35798148 | 2021-01-29 05:22:23 | Poquoson, Virginia, US |
3155900 | 3155900 | 2021-01-27 | US | North Carolina | Clay | 37043 | 581 | 5 | 0 | 576 | 35.05704275 | -83.74353633 | 2021-01-28 05:22:24 | Clay, North Carolina, US |
14193 | 14193 | 2021-01-26 | US | Mississippi | Wilkinson | 28157 | 601 | 25 | 0 | 576 | 31.16078225 | -91.31018819 | 2021-01-27 05:23:41 | Wilkinson, Mississippi, US |
15712 | 15712 | 2021-01-26 | US | Virginia | Northampton | 51131 | 609 | 33 | 0 | 576 | 37.34062933 | -75.87751591 | 2021-01-27 05:23:41 | Northampton, Virginia, US |
1761707 | 1761707 | 2021-01-24 | US | North Dakota | Ransom | 38073 | 587 | 15 | 0 | 576 | 46.45621782 | -97.65742504 | 2021-01-25 05:22:16 | Ransom, North Dakota, US |
2427545 | 2427545 | 2021-01-23 | US | Colorado | Rio Grande | 8105 | 641 | 12 | 0 | 576 | 37.5836865 | -106.3847838 | 2021-01-24 05:22:35 | Rio Grande, Colorado, US |
2429007 | 2429007 | 2021-01-23 | US | Nebraska | Richardson | 31147 | 591 | 15 | 0 | 576 | 40.1247415 | -95.71755036 | 2021-01-24 05:22:35 | Richardson, Nebraska, US |
2467321 | 2467321 | 2021-01-22 | US | Arkansas | Searcy | 5129 | 590 | 14 | 0 | 576 | 35.9109364 | -92.69936482 | 2021-01-23 05:22:03 | Searcy, Arkansas, US |
2469403 | 2469403 | 2021-01-22 | US | Oregon | Baker | 41001 | 581 | 5 | 0 | 576 | 44.70915557 | -117.6749883 | 2021-01-23 05:22:03 | Baker, Oregon, US |
436686 | 436686 | 2021-01-21 | US | Kansas | Rooks | 20163 | 587 | 11 | 0 | 576 | 39.35022773 | -99.32484567 | 2021-01-22 05:22:10 | Rooks, Kansas, US |
1095417 | 1095417 | 2021-01-20 | US | Kansas | Rooks | 20163 | 587 | 11 | 0 | 576 | 39.35022773 | -99.32484567 | 2021-01-21 05:22:01 | Rooks, Kansas, US |
1096140 | 1096140 | 2021-01-20 | US | Nebraska | Dawes | 31045 | 594 | 18 | 0 | 576 | 42.71985036 | -103.1313774 | 2021-01-21 05:22:01 | Dawes, Nebraska, US |
1096620 | 1096620 | 2021-01-20 | US | Oklahoma | Coal | 40029 | 584 | 8 | 0 | 576 | 34.58840127 | -96.29798747 | 2021-01-21 05:22:01 | Coal, Oklahoma, US |
238160 | 238160 | 2021-01-18 | US | Idaho | Caribou | 16029 | 586 | 10 | 0 | 576 | 42.77149116 | -111.5597683 | 2021-01-19 05:22:15 | Caribou, Idaho, US |
239773 | 239773 | 2021-01-18 | US | Oklahoma | Coal | 40029 | 583 | 7 | 0 | 576 | 34.58840127 | -96.29798747 | 2021-01-19 05:22:15 | Coal, Oklahoma, US |
3504277 | 3504277 | 2021-01-17 | US | Idaho | Caribou | 16029 | 586 | 10 | 0 | 576 | 42.77149116 | -111.5597683 | 2021-01-18 05:22:34 | Caribou, Idaho, US |
3506018 | 3506018 | 2021-01-17 | US | Pennsylvania | Forest | 42053 | 585 | 9 | 0 | 576 | 41.51095103 | -79.23229292 | 2021-01-18 05:22:34 | Forest, Pennsylvania, US |
3102360 | 3102360 | 2021-01-16 | US | Idaho | Caribou | 16029 | 586 | 10 | 0 | 576 | 42.77149116 | -111.5597683 | 2021-01-17 05:22:17 | Caribou, Idaho, US |
3516232 | 3516232 | 2021-01-15 | US | Georgia | Macon | 13193 | 592 | 16 | 0 | 576 | 32.35207048 | -84.04234127 | 2021-01-16 05:22:40 | Macon, Georgia, US |
3518006 | 3518006 | 2021-01-15 | US | Oregon | Crook | 41013 | 585 | 9 | 0 | 576 | 44.14230227 | -120.356297 | 2021-01-16 05:22:40 | Crook, Oregon, US |
3880075 | 3880075 | 2021-01-14 | US | Arkansas | Monroe | 5095 | 586 | 10 | 0 | 576 | 34.6815935 | -91.20540287 | 2021-01-15 05:22:24 | Monroe, Arkansas, US |
3882366 | 3882366 | 2021-01-14 | US | South Carolina | Allendale | 45005 | 587 | 11 | 0 | 576 | 32.98837386 | -81.35321066 | 2021-01-15 05:22:24 | Allendale, South Carolina, US |
3309151 | 3309151 | 2021-01-13 | US | Idaho | Valley | 16085 | 580 | 4 | 0 | 576 | 44.76728382 | -115.5676773 | 2021-01-14 05:22:32 | Valley, Idaho, US |
3310222 | 3310222 | 2021-01-13 | US | Montana | Stillwater | 30095 | 586 | 10 | 0 | 576 | 45.67071407 | -109.3950061 | 2021-01-14 05:22:32 | Stillwater, Montana, US |
3310279 | 3310279 | 2021-01-13 | US | Nebraska | Jefferson | 31095 | 577 | 1 | 0 | 576 | 40.17584531 | -97.142601 | 2021-01-14 05:22:32 | Jefferson, Nebraska, US |
3311645 | 3311645 | 2021-01-13 | US | Washington | Pacific | 53049 | 584 | 8 | 0 | 576 | 46.55418369 | -123.7285716 | 2021-01-14 05:22:32 | Pacific, Washington, US |
774848 | 774848 | 2021-01-12 | US | Arkansas | Montgomery | 5097 | 597 | 21 | 0 | 576 | 34.53704874 | -93.65824478 | 2021-01-13 05:22:15 | Montgomery, Arkansas, US |
2626741 | 2626741 | 2021-01-10 | US | Georgia | Taylor | 13269 | 591 | 15 | 0 | 576 | 32.55792548 | -84.25077141 | 2021-01-11 05:21:50 | Taylor, Georgia, US |
2628651 | 2628651 | 2021-01-10 | US | Puerto Rico | Yabucoa | 72151 | 576 | 0 | 0 | 576 | 18.070399 | -65.896289 | 2021-01-11 05:21:50 | Yabucoa, Puerto Rico, US |
155196 | 155196 | 2021-01-08 | US | Iowa | Monona | 19133 | 592 | 16 | 0 | 576 | 42.05220391 | -95.95743843 | 2021-01-09 05:22:18 | Monona, Iowa, US |
157196 | 157196 | 2021-01-08 | US | Texas | Stephens | 48429 | 664 | 17 | 0 | 576 | 32.73553157 | -98.83631615 | 2021-01-09 05:22:18 | Stephens, Texas, US |
2542707 | 2542707 | 2021-01-07 | US | Kansas | Linn | 20107 | 579 | 3 | 0 | 576 | 38.21267844 | -94.84254089 | 2021-01-08 05:22:42 | Linn, Kansas, US |
2865743 | 2865743 | 2021-01-06 | US | Illinois | Pulaski | 17153 | 579 | 3 | 0 | 576 | 37.22631423 | -89.13085001 | 2021-01-07 05:22:03 | Pulaski, Illinois, US |
2866016 | 2866016 | 2021-01-06 | US | Kansas | Linn | 20107 | 579 | 3 | 0 | 576 | 38.21267844 | -94.84254089 | 2021-01-07 05:22:03 | Linn, Kansas, US |
2866149 | 2866149 | 2021-01-06 | US | Kentucky | McLean | 21149 | 596 | 20 | 0 | 576 | 37.5301951 | -87.26803443 | 2021-01-07 05:22:03 | McLean, Kentucky, US |
3034767 | 3034767 | 2021-01-05 | US | Arkansas | Cleveland | 5025 | 596 | 20 | 0 | 576 | 33.89723187 | -92.18537045 | 2021-01-06 05:22:16 | Cleveland, Arkansas, US |
1063168 | 1063168 | 2021-01-04 | US | Kansas | Phillips | 20147 | 588 | 12 | 0 | 576 | 39.78465501 | -99.34668865 | 2021-01-05 05:21:49 | Phillips, Kansas, US |
1138089 | 1138089 | 2021-01-01 | US | Iowa | Lucas | 19117 | 584 | 8 | 0 | 576 | 41.02958964 | -93.32780803 | 2021-01-02 05:22:33 | Lucas, Iowa, US |
1138532 | 1138532 | 2021-01-01 | US | Michigan | Manistee | 26101 | 591 | 15 | 0 | 576 | 44.33352407 | -86.05626916 | 2021-01-02 05:22:33 | Manistee, Michigan, US |
3697138 | 3697138 | 2020-12-31 | US | Michigan | Manistee | 26101 | 591 | 15 | 0 | 576 | 44.33352407 | -86.05626916 | 2021-01-01 05:23:07 | Manistee, Michigan, US |
3698217 | 3698217 | 2020-12-31 | US | Puerto Rico | Fajardo | 72053 | 576 | 0 | 0 | 576 | 18.318373 | -65.666866 | 2021-01-01 05:23:07 | Fajardo, Puerto Rico, 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]);