johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
377 rows where active = 467 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 27
- Illinois 22
- Virginia 22
- Indiana 20
- Georgia 18
- Iowa 15
- Kansas 15
- Nebraska 15
- South Dakota 14
- Missouri 13
- Puerto Rico 13
- Minnesota 12
- North Carolina 11
- Oklahoma 11
- Alabama 10
- Mississippi 10
- New York 10
- Arkansas 9
- Kentucky 9
- Michigan 8
- California 7
- Florida 7
- Ohio 7
- Rhode Island 7
- Oregon 6
- Pennsylvania 6
- Wisconsin 6
- Colorado 5
- Louisiana 5
- Tennessee 5
- …
country_or_region 1
- US · 377 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3668774 | 3668774 | 2021-03-06 | US | Iowa | Audubon | 19009 | 476 | 9 | 0 | 467 | 41.6844628 | -94.90581859 | 2021-03-07 05:21:54 | Audubon, Iowa, US |
3669733 | 3669733 | 2021-03-06 | US | Nebraska | Sheridan | 31161 | 485 | 18 | 0 | 467 | 42.50284406 | -102.4126613 | 2021-03-07 05:21:54 | Sheridan, Nebraska, US |
3670477 | 3670477 | 2021-03-06 | US | South Dakota | Deuel | 46039 | 475 | 8 | 0 | 467 | 44.75994309 | -96.66943645 | 2021-03-07 05:21:54 | Deuel, South Dakota, US |
3670894 | 3670894 | 2021-03-06 | US | Vermont | Caledonia | 50005 | 472 | 5 | 0 | 467 | 44.46548598 | -72.10314651 | 2021-03-07 05:21:54 | Caledonia, Vermont, US |
1618354 | 1618354 | 2021-03-05 | US | Nebraska | Sheridan | 31161 | 485 | 18 | 0 | 467 | 42.50284406 | -102.4126613 | 2021-03-06 04:23:41 | Sheridan, Nebraska, US |
2208806 | 2208806 | 2021-03-04 | US | Iowa | Audubon | 19009 | 476 | 9 | 0 | 467 | 41.6844628 | -94.90581859 | 2021-03-05 05:26:29 | Audubon, Iowa, US |
1000471 | 1000471 | 2021-03-01 | US | Nebraska | Antelope | 31003 | 473 | 6 | 0 | 467 | 42.17695516 | -98.0666283 | 2021-03-02 05:23:30 | Antelope, Nebraska, US |
2369529 | 2369529 | 2021-02-28 | US | Nebraska | Antelope | 31003 | 473 | 6 | 0 | 467 | 42.17695516 | -98.0666283 | 2021-03-01 05:23:01 | Antelope, Nebraska, US |
2370774 | 2370774 | 2021-02-28 | US | Vermont | Lamoille | 50015 | 469 | 2 | 0 | 467 | 44.60353043 | -72.64356694 | 2021-03-01 05:23:01 | Lamoille, Vermont, US |
2185675 | 2185675 | 2021-02-26 | US | Nebraska | Morrill | 31123 | 482 | 15 | 0 | 467 | 41.71711774 | -103.0061405 | 2021-02-27 05:22:28 | Morrill, Nebraska, US |
533564 | 533564 | 2021-02-22 | US | South Dakota | Edmunds | 46045 | 479 | 12 | 0 | 467 | 45.41846445 | -99.21545423 | 2021-02-23 05:23:41 | Edmunds, South Dakota, US |
474778 | 474778 | 2021-02-19 | US | Virginia | Middlesex | 51119 | 483 | 16 | 0 | 467 | 37.63191998 | -76.55064617 | 2021-02-20 05:22:51 | Middlesex, Virginia, US |
1155236 | 1155236 | 2021-02-18 | US | Nebraska | Thayer | 31169 | 470 | 3 | 0 | 467 | 40.17626377 | -97.59504381 | 2021-02-19 05:24:16 | Thayer, Nebraska, US |
3051133 | 3051133 | 2021-02-16 | US | Illinois | Calhoun | 17013 | 469 | 2 | 0 | 467 | 39.16840183 | -90.66330078 | 2021-02-17 05:23:10 | Calhoun, Illinois, US |
1339232 | 1339232 | 2021-02-15 | US | Illinois | Calhoun | 17013 | 469 | 2 | 0 | 467 | 39.16840183 | -90.66330078 | 2021-02-16 05:24:38 | Calhoun, Illinois, US |
2284383 | 2284383 | 2021-02-14 | US | Illinois | Calhoun | 17013 | 469 | 2 | 0 | 467 | 39.16840183 | -90.66330078 | 2021-02-15 05:24:49 | Calhoun, Illinois, US |
2678783 | 2678783 | 2021-02-13 | US | Illinois | Calhoun | 17013 | 469 | 2 | 0 | 467 | 39.16840183 | -90.66330078 | 2021-02-14 05:23:43 | Calhoun, Illinois, US |
3540416 | 3540416 | 2021-02-12 | US | Illinois | Calhoun | 17013 | 469 | 2 | 0 | 467 | 39.16840183 | -90.66330078 | 2021-02-13 05:22:12 | Calhoun, Illinois, US |
2638679 | 2638679 | 2021-02-11 | US | Illinois | Calhoun | 17013 | 469 | 2 | 0 | 467 | 39.16840183 | -90.66330078 | 2021-02-12 05:23:29 | Calhoun, Illinois, US |
2640877 | 2640877 | 2021-02-11 | US | Texas | Marion | 48315 | 573 | 24 | 0 | 467 | 32.79868409 | -94.3566123 | 2021-02-12 05:23:29 | Marion, Texas, US |
3980413 | 3980413 | 2021-02-10 | US | Mississippi | Sharkey | 28125 | 484 | 17 | 0 | 467 | 32.88149103 | -90.8159538 | 2021-02-11 05:23:55 | Sharkey, Mississippi, US |
1529733 | 1529733 | 2021-02-09 | US | Mississippi | Sharkey | 28125 | 484 | 17 | 0 | 467 | 32.88149103 | -90.8159538 | 2021-02-10 05:22:41 | Sharkey, Mississippi, US |
1530443 | 1530443 | 2021-02-09 | US | Oklahoma | Greer | 40055 | 483 | 16 | 0 | 467 | 34.93535801 | -99.5605612 | 2021-02-10 05:22:41 | Greer, Oklahoma, US |
614915 | 614915 | 2021-02-08 | US | Iowa | Ringgold | 19159 | 483 | 16 | 0 | 467 | 40.73518949 | -94.24368535 | 2021-02-09 05:23:30 | Ringgold, Iowa, US |
615524 | 615524 | 2021-02-08 | US | Mississippi | Sharkey | 28125 | 484 | 17 | 0 | 467 | 32.88149103 | -90.8159538 | 2021-02-09 05:23:30 | Sharkey, Mississippi, US |
1674293 | 1674293 | 2021-02-07 | US | Mississippi | Sharkey | 28125 | 484 | 17 | 0 | 467 | 32.88149103 | -90.8159538 | 2021-02-08 05:22:39 | Sharkey, Mississippi, US |
1589063 | 1589063 | 2021-02-05 | US | Georgia | Warren | 13301 | 477 | 10 | 0 | 467 | 33.41146451 | -82.67795848 | 2021-02-06 05:23:55 | Warren, Georgia, US |
1589403 | 1589403 | 2021-02-05 | US | Iowa | Ringgold | 19159 | 482 | 15 | 0 | 467 | 40.73518949 | -94.24368535 | 2021-02-06 05:23:55 | Ringgold, Iowa, US |
1463119 | 1463119 | 2021-01-31 | US | Virginia | Madison | 51113 | 473 | 6 | 0 | 467 | 38.41531222 | -78.28220331 | 2021-02-01 05:22:53 | Madison, Virginia, US |
1898140 | 1898140 | 2021-01-29 | US | Illinois | Henderson | 17071 | 475 | 8 | 0 | 467 | 40.81908672 | -90.92491462 | 2021-01-30 05:22:49 | Henderson, Illinois, US |
3155296 | 3155296 | 2021-01-27 | US | Minnesota | Big Stone | 27011 | 470 | 3 | 0 | 467 | 45.42712824 | -96.41403739 | 2021-01-28 05:22:24 | Big Stone, Minnesota, US |
14031 | 14031 | 2021-01-26 | US | Minnesota | Big Stone | 27011 | 470 | 3 | 0 | 467 | 45.42712824 | -96.41403739 | 2021-01-27 05:23:41 | Big Stone, Minnesota, US |
2569355 | 2569355 | 2021-01-25 | US | Minnesota | Big Stone | 27011 | 470 | 3 | 0 | 467 | 45.42712824 | -96.41403739 | 2021-01-26 05:22:02 | Big Stone, Minnesota, US |
1094944 | 1094944 | 2021-01-20 | US | Georgia | Randolph | 13243 | 498 | 31 | 0 | 467 | 31.76622818 | -84.75732369 | 2021-01-21 05:22:01 | Randolph, Georgia, US |
908797 | 908797 | 2021-01-19 | US | Colorado | Kit Carson | 8063 | 509 | 10 | 0 | 467 | 39.30497777 | -102.6022199 | 2021-01-20 05:21:54 | Kit Carson, Colorado, US |
911039 | 911039 | 2021-01-19 | US | South Dakota | Gregory | 46053 | 493 | 26 | 0 | 467 | 43.19419064 | -99.18883902 | 2021-01-20 05:21:54 | Gregory, South Dakota, US |
240102 | 240102 | 2021-01-18 | US | South Dakota | Gregory | 46053 | 493 | 26 | 0 | 467 | 43.19419064 | -99.18883902 | 2021-01-19 05:22:15 | Gregory, South Dakota, US |
3506219 | 3506219 | 2021-01-17 | US | South Dakota | Gregory | 46053 | 493 | 26 | 0 | 467 | 43.19419064 | -99.18883902 | 2021-01-18 05:22:34 | Gregory, South Dakota, US |
3506679 | 3506679 | 2021-01-17 | US | Virginia | Essex | 51057 | 470 | 3 | 0 | 467 | 37.93357639 | -76.94230311 | 2021-01-18 05:22:34 | Essex, Virginia, US |
3104302 | 3104302 | 2021-01-16 | US | South Dakota | Gregory | 46053 | 493 | 26 | 0 | 467 | 43.19419064 | -99.18883902 | 2021-01-17 05:22:17 | Gregory, South Dakota, US |
3515843 | 3515843 | 2021-01-15 | US | Arizona | Greenlee | 4011 | 471 | 4 | 0 | 467 | 33.21498827 | -109.2405279 | 2021-01-16 05:22:40 | Greenlee, Arizona, US |
3518146 | 3518146 | 2021-01-15 | US | Puerto Rico | Lares | 72081 | 467 | 0 | 0 | 467 | 18.269035 | -66.867236 | 2021-01-16 05:22:40 | Lares, Puerto Rico, US |
3518264 | 3518264 | 2021-01-15 | US | South Dakota | Gregory | 46053 | 493 | 26 | 0 | 467 | 43.19419064 | -99.18883902 | 2021-01-16 05:22:40 | Gregory, South Dakota, US |
3882114 | 3882114 | 2021-01-14 | US | Oklahoma | Dewey | 40043 | 470 | 3 | 0 | 467 | 35.98772922 | -99.00730714 | 2021-01-15 05:22:24 | Dewey, Oklahoma, US |
3882436 | 3882436 | 2021-01-14 | US | South Dakota | Gregory | 46053 | 493 | 26 | 0 | 467 | 43.19419064 | -99.18883902 | 2021-01-15 05:22:24 | Gregory, South Dakota, US |
3311063 | 3311063 | 2021-01-13 | US | South Dakota | Gregory | 46053 | 493 | 26 | 0 | 467 | 43.19419064 | -99.18883902 | 2021-01-14 05:22:32 | Gregory, South Dakota, US |
775631 | 775631 | 2021-01-12 | US | Kansas | Greenwood | 20073 | 473 | 6 | 0 | 467 | 37.8774388 | -96.23250453 | 2021-01-13 05:22:15 | Greenwood, Kansas, US |
191352 | 191352 | 2021-01-11 | US | Kansas | Greenwood | 20073 | 473 | 6 | 0 | 467 | 37.8774388 | -96.23250453 | 2021-01-12 05:22:15 | Greenwood, Kansas, US |
2626910 | 2626910 | 2021-01-10 | US | Illinois | Stark | 17175 | 487 | 20 | 0 | 467 | 41.09309773 | -89.79745866 | 2021-01-11 05:21:50 | Stark, Illinois, US |
2627108 | 2627108 | 2021-01-10 | US | Iowa | Van Buren | 19177 | 479 | 12 | 0 | 467 | 40.75326764 | -91.95017958 | 2021-01-11 05:21:50 | Van Buren, Iowa, US |
2627947 | 2627947 | 2021-01-10 | US | Nebraska | Howard | 31093 | 480 | 13 | 0 | 467 | 41.2200529 | -98.5166499 | 2021-01-11 05:21:50 | Howard, Nebraska, US |
3901196 | 3901196 | 2021-01-09 | US | Iowa | Van Buren | 19177 | 479 | 12 | 0 | 467 | 40.75326764 | -91.95017958 | 2021-01-10 05:22:12 | Van Buren, Iowa, US |
3903562 | 3903562 | 2021-01-09 | US | Wyoming | Platte | 56031 | 476 | 9 | 0 | 467 | 42.13299116 | -104.966331 | 2021-01-10 05:22:12 | Platte, Wyoming, US |
157585 | 157585 | 2021-01-08 | US | Wyoming | Platte | 56031 | 476 | 9 | 0 | 467 | 42.13299116 | -104.966331 | 2021-01-09 05:22:18 | Platte, Wyoming, US |
2543131 | 2543131 | 2021-01-07 | US | Minnesota | Lincoln | 27081 | 468 | 1 | 0 | 467 | 44.41311883 | -96.26688165 | 2021-01-08 05:22:42 | Lincoln, Minnesota, US |
2544167 | 2544167 | 2021-01-07 | US | Puerto Rico | Quebradillas | 72115 | 467 | 0 | 0 | 467 | 18.439692 | -66.926113 | 2021-01-08 05:22:42 | Quebradillas, Puerto Rico, US |
1063864 | 1063864 | 2021-01-04 | US | Montana | Sanders | 30089 | 471 | 4 | 0 | 467 | 47.67657534 | -115.1329916 | 2021-01-05 05:21:49 | Sanders, Montana, US |
3232368 | 3232368 | 2021-01-03 | US | Missouri | Maries | 29125 | 473 | 6 | 0 | 467 | 38.16193985 | -91.92249662 | 2021-01-04 05:22:02 | Maries, Missouri, US |
3232467 | 3232467 | 2021-01-03 | US | Montana | Sanders | 30089 | 471 | 4 | 0 | 467 | 47.67657534 | -115.1329916 | 2021-01-04 05:22:02 | Sanders, Montana, US |
3233800 | 3233800 | 2021-01-03 | US | Virginia | King William | 51101 | 471 | 4 | 0 | 467 | 37.70965316 | -77.09384941 | 2021-01-04 05:22:02 | King William, Virginia, US |
2230300 | 2230300 | 2021-01-02 | US | Puerto Rico | Yauco | 72153 | 467 | 0 | 0 | 467 | 18.080374 | -66.858814 | 2021-01-03 05:22:52 | Yauco, Puerto Rico, US |
1138066 | 1138066 | 2021-01-01 | US | Iowa | Fremont | 19071 | 472 | 5 | 0 | 467 | 40.74542720000001 | -95.60129045 | 2021-01-02 05:22:33 | Fremont, Iowa, US |
1139480 | 1139480 | 2021-01-01 | US | Oregon | Baker | 41001 | 472 | 5 | 0 | 467 | 44.70915557 | -117.6749883 | 2021-01-02 05:22:33 | Baker, Oregon, US |
1139663 | 1139663 | 2021-01-01 | US | Puerto Rico | Yabucoa | 72151 | 467 | 0 | 0 | 467 | 18.070399 | -65.896289 | 2021-01-02 05:22:33 | Yabucoa, Puerto Rico, US |
3698086 | 3698086 | 2020-12-31 | US | Oregon | Baker | 41001 | 472 | 5 | 0 | 467 | 44.70915557 | -117.6749883 | 2021-01-01 05:23:07 | Baker, Oregon, US |
1012397 | 1012397 | 2020-12-30 | US | Nebraska | Nemaha | 31127 | 477 | 10 | 0 | 467 | 40.38514847 | -95.85433992 | 2020-12-31 05:22:49 | Nemaha, Nebraska, US |
3764754 | 3764754 | 2020-12-28 | US | Texas | Morris | 48343 | 556 | 8 | 0 | 467 | 33.11304005 | -94.73255695 | 2020-12-29 05:22:37 | Morris, Texas, US |
3778494 | 3778494 | 2020-12-27 | US | Colorado | Archuleta | 8007 | 500 | 1 | 0 | 467 | 37.19474156 | -107.0476867 | 2020-12-28 05:22:06 | Archuleta, Colorado, US |
3779039 | 3779039 | 2020-12-27 | US | Indiana | Union | 18161 | 471 | 4 | 0 | 467 | 39.62550777 | -84.92497066 | 2020-12-28 05:22:06 | Union, Indiana, US |
3780006 | 3780006 | 2020-12-27 | US | Nebraska | Richardson | 31147 | 482 | 15 | 0 | 467 | 40.1247415 | -95.71755036 | 2020-12-28 05:22:06 | Richardson, Nebraska, US |
3781074 | 3781074 | 2020-12-27 | US | Texas | Morris | 48343 | 537 | 8 | 0 | 467 | 33.11304005 | -94.73255695 | 2020-12-28 05:22:06 | Morris, Texas, US |
2224644 | 2224644 | 2020-12-26 | US | Indiana | Union | 18161 | 471 | 4 | 0 | 467 | 39.62550777 | -84.92497066 | 2020-12-27 05:22:55 | Union, Indiana, US |
2225434 | 2225434 | 2020-12-26 | US | Missouri | Montgomery | 29139 | 475 | 8 | 0 | 467 | 38.94022054 | -91.47000721 | 2020-12-27 05:22:55 | Montgomery, Missouri, US |
2225611 | 2225611 | 2020-12-26 | US | Nebraska | Richardson | 31147 | 482 | 15 | 0 | 467 | 40.1247415 | -95.71755036 | 2020-12-27 05:22:55 | Richardson, Nebraska, US |
2226215 | 2226215 | 2020-12-26 | US | Puerto Rico | Anasco | 72011 | 467 | 0 | 0 | 467 | 18.287985 | -67.120611 | 2020-12-27 05:22:55 | Anasco, Puerto Rico, US |
204511 | 204511 | 2020-12-25 | US | New York | Schoharie | 36095 | 471 | 4 | 0 | 467 | 42.58831742 | -74.44339029999998 | 2020-12-26 05:22:28 | Schoharie, New York, US |
204811 | 204811 | 2020-12-25 | US | Oklahoma | Latimer | 40077 | 472 | 5 | 0 | 467 | 34.87844729 | -95.25215049 | 2020-12-26 05:22:28 | Latimer, Oklahoma, US |
3692305 | 3692305 | 2020-12-24 | US | Georgia | Long | 13183 | 472 | 5 | 0 | 467 | 31.75218791 | -81.74952375 | 2020-12-25 05:22:48 | Long, Georgia, US |
3692619 | 3692619 | 2020-12-24 | US | Indiana | Warren | 18171 | 476 | 9 | 0 | 467 | 40.34728141 | -87.35602659 | 2020-12-25 05:22:48 | Warren, Indiana, US |
3694034 | 3694034 | 2020-12-24 | US | Oklahoma | Latimer | 40077 | 472 | 5 | 0 | 467 | 34.87844729 | -95.25215049 | 2020-12-25 05:22:48 | Latimer, Oklahoma, US |
2409885 | 2409885 | 2020-12-23 | US | Texas | Dallam | 48111 | 769 | 18 | 0 | 467 | 36.27787176 | -102.6020725 | 2020-12-24 05:23:04 | Dallam, Texas, US |
2120962 | 2120962 | 2020-12-20 | US | Kansas | Anderson | 20003 | 469 | 2 | 0 | 467 | 38.21413251 | -95.29272815 | 2020-12-21 05:27:58 | Anderson, Kansas, US |
2932469 | 2932469 | 2020-12-19 | US | Kansas | Anderson | 20003 | 469 | 2 | 0 | 467 | 38.21413251 | -95.29272815 | 2020-12-20 05:27:32 | Anderson, Kansas, US |
2933298 | 2933298 | 2020-12-19 | US | Nebraska | Johnson | 31097 | 471 | 4 | 0 | 467 | 40.39257596 | -96.26522753 | 2020-12-20 05:27:32 | Johnson, Nebraska, US |
1902082 | 1902082 | 2020-12-18 | US | Idaho | Boundary | 16021 | 473 | 6 | 0 | 467 | 48.76684761 | -116.4630179 | 2020-12-19 05:27:52 | Boundary, Idaho, US |
1902415 | 1902415 | 2020-12-18 | US | Kansas | Anderson | 20003 | 469 | 2 | 0 | 467 | 38.21413251 | -95.29272815 | 2020-12-19 05:27:52 | Anderson, Kansas, US |
2129366 | 2129366 | 2020-12-17 | US | Kentucky | Carroll | 21041 | 474 | 7 | 0 | 467 | 38.66599534 | -85.12601074 | 2020-12-18 05:28:18 | Carroll, Kentucky, US |
2129844 | 2129844 | 2020-12-17 | US | Mississippi | Wilkinson | 28157 | 489 | 22 | 0 | 467 | 31.16078225 | -91.31018819 | 2020-12-18 05:28:18 | Wilkinson, Mississippi, US |
2129867 | 2129867 | 2020-12-17 | US | Missouri | Cedar | 29039 | 475 | 8 | 0 | 467 | 37.72391475 | -93.85445441 | 2020-12-18 05:28:18 | Cedar, Missouri, US |
2130783 | 2130783 | 2020-12-17 | US | South Carolina | Allendale | 45005 | 476 | 9 | 0 | 467 | 32.98837386 | -81.35321066 | 2020-12-18 05:28:18 | Allendale, South Carolina, US |
2130964 | 2130964 | 2020-12-17 | US | Tennessee | Pickett | 47137 | 500 | 16 | 0 | 467 | 36.55606529 | -85.07763299999998 | 2020-12-18 05:28:18 | Pickett, Tennessee, US |
3152643 | 3152643 | 2020-12-16 | US | Texas | Crane | 48103 | 324 | 9 | 0 | 467 | 31.43052248 | -102.5143314 | 2020-12-17 05:28:12 | Crane, Texas, US |
1036598 | 1036598 | 2020-12-15 | US | New York | Franklin | 36033 | 476 | 9 | 0 | 467 | 44.59040891 | -74.29926032 | 2020-12-16 05:28:04 | Franklin, New York, US |
1037119 | 1037119 | 2020-12-15 | US | Puerto Rico | Loiza | 72087 | 467 | 0 | 0 | 467 | 18.425688 | -65.89943000000001 | 2020-12-16 05:28:04 | Loiza, Puerto Rico, US |
1037226 | 1037226 | 2020-12-15 | US | South Dakota | Day | 46037 | 481 | 14 | 0 | 467 | 45.367281 | -97.60737498 | 2020-12-16 05:28:04 | Day, South Dakota, US |
1037424 | 1037424 | 2020-12-15 | US | Texas | Crane | 48103 | 323 | 9 | 0 | 467 | 31.43052248 | -102.5143314 | 2020-12-16 05:28:04 | Crane, Texas, US |
1037913 | 1037913 | 2020-12-15 | US | Wisconsin | Iron | 55051 | 483 | 16 | 0 | 467 | 46.26302338 | -90.24295041 | 2020-12-16 05:28:04 | Iron, Wisconsin, US |
1752250 | 1752250 | 2020-12-14 | US | Illinois | Hamilton | 17065 | 475 | 8 | 0 | 467 | 38.08163641 | -88.53883373 | 2020-12-15 05:26:38 | Hamilton, Illinois, US |
1754319 | 1754319 | 2020-12-14 | US | Texas | Crockett | 48105 | 320 | 8 | 0 | 467 | 30.72367027 | -101.4134238 | 2020-12-15 05:26:38 | Crockett, Texas, US |
1754364 | 1754364 | 2020-12-14 | US | Texas | Hansford | 48195 | 626 | 12 | 0 | 467 | 36.27743284 | -101.3545796 | 2020-12-15 05:26:38 | Hansford, Texas, 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]);