johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by active
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
571476 | 571476 | 2020-06-06 | US | Ohio | Darke | 39037 | 191 | 17 | 0 | 174 | 40.13412966 | -84.6194517 | 2020-06-07 03:53:30 | Darke, Ohio, US |
571538 | 571538 | 2020-06-06 | US | South Carolina | Dillon | 45033 | 177 | 3 | 0 | 174 | 34.39007791 | -79.37741872 | 2020-06-07 03:53:30 | Dillon, South Carolina, US |
571566 | 571566 | 2020-06-06 | US | Washington | Douglas | 53017 | 177 | 3 | 0 | 174 | 47.7361335 | -119.692937 | 2020-06-07 03:53:30 | Douglas, Washington, US |
571939 | 571939 | 2020-06-06 | US | Indiana | Harrison | 18061 | 196 | 22 | 0 | 174 | 38.19467379 | -86.10948271 | 2020-06-07 03:53:30 | Harrison, Indiana, US |
571976 | 571976 | 2020-06-06 | US | Indiana | Henry | 18065 | 186 | 12 | 0 | 174 | 39.93029017 | -85.39625719 | 2020-06-07 03:53:30 | Henry, Indiana, US |
572448 | 572448 | 2020-06-06 | US | Tennessee | Macon | 47111 | 175 | 3 | 0 | 174 | 36.53157855 | -86.00778595 | 2020-06-07 03:53:30 | Macon, Tennessee, US |
573965 | 573965 | 2020-06-06 | US | Guam | 66 | 179 | 5 | 0 | 174 | 13.4443 | 144.7937 | 2020-06-07 03:53:30 | Guam, US | |
583752 | 583752 | 2020-08-13 | US | Idaho | Gooding | 16047 | 175 | 1 | 0 | 174 | 42.96927962 | -114.8108306 | 2020-08-14 04:51:19 | Gooding, Idaho, US |
583952 | 583952 | 2020-08-13 | US | Indiana | Starke | 18149 | 181 | 7 | 0 | 174 | 41.27890281 | -86.64686895 | 2020-08-14 04:51:19 | Starke, Indiana, US |
583963 | 583963 | 2020-08-13 | US | Indiana | Wabash | 18169 | 179 | 5 | 0 | 174 | 40.84704239 | -85.79328272 | 2020-08-14 04:51:19 | Wabash, Indiana, US |
586708 | 586708 | 2020-04-05 | US | Colorado | Boulder | 8013 | 345 | 24 | 0 | 174 | 40.09313619 | -105.3546767 | 2020-04-05 23:06:45 | Boulder, Colorado, US |
588349 | 588349 | 2020-04-05 | US | Virginia | Prince William | 51153 | 175 | 1 | 0 | 174 | 38.70916224 | -77.48713689 | 2020-04-05 23:06:45 | Prince William, Virginia, US |
605711 | 605711 | 2021-04-09 | Japan | Mie | 2941 | 72 | 2695 | 174 | 34.508018 | 136.376013 | 2021-04-10 04:20:59 | Mie, Japan | ||
610907 | 610907 | 2020-08-29 | US | Iowa | Poweshiek | 19157 | 182 | 8 | 0 | 174 | 41.68625425 | -92.53155731 | 2020-08-30 04:28:22 | Poweshiek, Iowa, US |
611913 | 611913 | 2020-08-29 | US | New York | Livingston | 36051 | 182 | 8 | 0 | 174 | 42.72596275 | -77.77966158 | 2020-08-30 04:28:22 | Livingston, New York, US |
612739 | 612739 | 2020-08-29 | US | Texas | Dimmit | 48127 | 185 | 6 | 0 | 174 | 28.42270064 | -99.75645095 | 2020-08-30 04:28:22 | Dimmit, Texas, US |
616739 | 616739 | 2021-02-08 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-09 05:23:30 | Cottle, Texas, US |
663452 | 663452 | 2020-08-11 | US | Indiana | Perry | 18123 | 187 | 13 | 0 | 174 | 38.07809328 | -86.63741946 | 2020-08-12 04:27:29 | Perry, Indiana, US |
665529 | 665529 | 2020-08-11 | US | Texas | San Jacinto | 48407 | 236 | 8 | 0 | 174 | 30.57933681 | -95.16260304 | 2020-08-12 04:27:29 | San Jacinto, Texas, US |
665654 | 665654 | 2020-08-11 | US | Virginia | Franklin | 51067 | 175 | 1 | 0 | 174 | 36.99536167 | -79.88023649 | 2020-08-12 04:27:29 | Franklin, Virginia, US |
665738 | 665738 | 2020-08-11 | US | Virginia | Waynesboro | 51820 | 177 | 3 | 0 | 174 | 38.06451466 | -78.90293905 | 2020-08-12 04:27:29 | Waynesboro, Virginia, US |
666773 | 666773 | 2020-09-16 | US | Arkansas | Nevada | 5099 | 187 | 13 | 0 | 174 | 33.66340119 | -93.30632432 | 2020-09-17 04:22:00 | Nevada, Arkansas, US |
666874 | 666874 | 2020-09-16 | US | Colorado | Delta | 8029 | 190 | 1 | 0 | 174 | 38.86246243 | -107.8631342 | 2020-09-17 04:22:00 | Delta, Colorado, US |
667141 | 667141 | 2020-09-16 | US | Georgia | Taylor | 13269 | 182 | 8 | 0 | 174 | 32.55792548 | -84.25077141 | 2020-09-17 04:22:00 | Taylor, Georgia, US |
679952 | 679952 | 2020-11-23 | US | Michigan | Lake | 26085 | 178 | 4 | 0 | 174 | 43.99050893 | -85.802173 | 2020-11-24 05:27:31 | Lake, Michigan, US |
680567 | 680567 | 2020-11-23 | US | New York | Schoharie | 36095 | 176 | 2 | 0 | 174 | 42.58831742 | -74.44339029999998 | 2020-11-24 05:27:31 | Schoharie, New York, US |
681588 | 681588 | 2020-11-23 | US | Vermont | Orange | 50017 | 174 | 0 | 0 | 174 | 44.00470222 | -72.37640104 | 2020-11-24 05:27:31 | Orange, Vermont, US |
734431 | 734431 | 2020-06-12 | US | Mississippi | Bolivar | 28011 | 185 | 11 | 0 | 174 | 33.79696941 | -90.87372121 | 2020-06-13 03:33:14 | Bolivar, Mississippi, US |
734774 | 734774 | 2020-06-12 | US | Arizona | Cochise | 4003 | 178 | 4 | 0 | 174 | 31.87934684 | -109.7516088 | 2020-06-13 03:33:14 | Cochise, Arizona, US |
743656 | 743656 | 2021-02-20 | US | Kansas | Stanton | 20187 | 181 | 7 | 0 | 174 | 37.56304714 | -101.7843534 | 2021-02-21 05:24:33 | Stanton, Kansas, US |
744223 | 744223 | 2021-02-20 | US | Missouri | Knox | 29103 | 176 | 2 | 0 | 174 | 40.12699751 | -92.14780832 | 2021-02-21 05:24:33 | Knox, Missouri, US |
750609 | 750609 | 2020-08-01 | US | Arkansas | Cleburne | 5023 | 179 | 5 | 0 | 174 | 35.53864922 | -92.02640019 | 2020-08-02 04:34:47 | Cleburne, Arkansas, US |
750684 | 750684 | 2020-08-01 | US | Puerto Rico | Corozal | 72047 | 174 | 0 | 0 | 174 | 18.304264 | -66.327738 | 2020-08-02 04:34:47 | Corozal, Puerto Rico, US |
750756 | 750756 | 2020-08-01 | US | Texas | Dallam | 48111 | 215 | 5 | 0 | 174 | 36.27787176 | -102.6020725 | 2020-08-02 04:34:47 | Dallam, Texas, US |
754771 | 754771 | 2020-10-28 | US | Arkansas | Dallas | 5039 | 180 | 6 | 0 | 174 | 33.97042763 | -92.65167437 | 2020-10-29 04:24:49 | Dallas, Arkansas, US |
755730 | 755730 | 2020-10-28 | US | Kentucky | Mason | 21161 | 176 | 2 | 0 | 174 | 38.59471935 | -83.82151043 | 2020-10-29 04:24:49 | Mason, Kentucky, US |
756192 | 756192 | 2020-10-28 | US | Missouri | Gentry | 29075 | 184 | 10 | 0 | 174 | 40.21097916 | -94.40944419 | 2020-10-29 04:24:49 | Gentry, Missouri, US |
756346 | 756346 | 2020-10-28 | US | Nebraska | Clay | 31035 | 175 | 1 | 0 | 174 | 40.52439441 | -98.05126296 | 2020-10-29 04:24:49 | Clay, Nebraska, US |
763503 | 763503 | 2020-10-18 | US | Iowa | Ida | 19093 | 176 | 2 | 0 | 174 | 42.38696136 | -95.51355387 | 2020-10-19 04:24:16 | Ida, Iowa, US |
764207 | 764207 | 2020-10-18 | US | Missouri | Hickory | 29085 | 177 | 3 | 0 | 174 | 37.94163617 | -93.3203037 | 2020-10-19 04:24:16 | Hickory, Missouri, US |
764242 | 764242 | 2020-10-18 | US | Missouri | Ozark | 29153 | 175 | 1 | 0 | 174 | 36.64916339 | -92.44459066 | 2020-10-19 04:24:16 | Ozark, Missouri, US |
765484 | 765484 | 2020-10-18 | US | Texas | Newton | 48351 | 158 | 13 | 0 | 174 | 30.78548982 | -93.74408813 | 2020-10-19 04:24:16 | Newton, Texas, US |
767669 | 767669 | 2020-12-29 | US | Kansas | Wichita | 20203 | 179 | 5 | 0 | 174 | 38.48178252 | -101.3471509 | 2020-12-30 05:22:34 | Wichita, Kansas, US |
769994 | 769994 | 2020-12-29 | Malaysia | Kelantan | 665 | 7 | 484 | 174 | 6.1254 | 102.2381 | 2020-12-30 05:22:34 | Kelantan, Malaysia | ||
776339 | 776339 | 2021-01-12 | US | Montana | Granite | 30039 | 176 | 2 | 0 | 174 | 46.40605220000001 | -113.4414186 | 2021-01-13 05:22:15 | Granite, Montana, US |
786980 | 786980 | 2020-10-15 | US | Colorado | Elbert | 8039 | 205 | 3 | 0 | 174 | 39.28656773 | -104.1358721 | 2020-10-16 04:24:01 | Elbert, Colorado, US |
787495 | 787495 | 2020-10-15 | US | Indiana | Rush | 18139 | 178 | 4 | 0 | 174 | 39.62002287 | -85.4655599 | 2020-10-16 04:24:01 | Rush, Indiana, US |
788704 | 788704 | 2020-10-15 | US | North Carolina | Mitchell | 37121 | 178 | 4 | 0 | 174 | 36.01059309 | -82.1582442 | 2020-10-16 04:24:01 | Mitchell, North Carolina, US |
789546 | 789546 | 2020-10-15 | US | Texas | Newton | 48351 | 158 | 13 | 0 | 174 | 30.78548982 | -93.74408813 | 2020-10-16 04:24:01 | Newton, Texas, US |
792450 | 792450 | 2021-02-04 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-05 05:22:38 | Gosper, Nebraska, US |
793434 | 793434 | 2021-02-04 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-05 05:22:38 | Cottle, Texas, US |
802162 | 802162 | 2020-06-01 | US | Louisiana | Allen | 22003 | 184 | 10 | 0 | 174 | 30.65385745 | -92.82442028 | 2020-06-02 02:33:08 | Allen, Louisiana, US |
804200 | 804200 | 2020-06-01 | US | Texas | Panola | 48365 | 65 | 23 | 0 | 174 | 32.163959600000005 | -94.30552481 | 2020-06-02 02:33:08 | Panola, Texas, US |
805622 | 805622 | 2020-06-01 | Cuba | 2083 | 83 | 1826 | 174 | 21.521757 | -77.78116700000002 | 2020-06-02 02:33:08 | Cuba | |||
814379 | 814379 | 2020-09-05 | US | Georgia | Heard | 13149 | 179 | 5 | 0 | 174 | 33.29686567 | -85.12886832 | 2020-09-06 04:28:33 | Heard, Georgia, US |
814732 | 814732 | 2020-09-05 | US | Iowa | Cedar | 19031 | 175 | 1 | 0 | 174 | 41.77233777 | -91.13246684 | 2020-09-06 04:28:33 | Cedar, Iowa, US |
814755 | 814755 | 2020-09-05 | US | Iowa | Guthrie | 19077 | 179 | 5 | 0 | 174 | 41.68378965 | -94.50111014 | 2020-09-06 04:28:33 | Guthrie, Iowa, US |
815999 | 815999 | 2020-09-05 | US | Ohio | Ashland | 39005 | 178 | 4 | 0 | 174 | 40.84772277 | -82.27280781 | 2020-09-06 04:28:33 | Ashland, Ohio, US |
816292 | 816292 | 2020-09-05 | US | Puerto Rico | Comerio | 72045 | 174 | 0 | 0 | 174 | 18.224687 | -66.221622 | 2020-09-06 04:28:33 | Comerio, Puerto Rico, US |
818796 | 818796 | 2020-10-09 | US | Iowa | Union | 19175 | 177 | 3 | 0 | 174 | 41.0277278 | -94.24234847 | 2020-10-10 04:23:57 | Union, Iowa, US |
820735 | 820735 | 2020-10-09 | US | Texas | Newton | 48351 | 157 | 13 | 0 | 174 | 30.78548982 | -93.74408813 | 2020-10-10 04:23:57 | Newton, Texas, US |
824172 | 824172 | 2020-11-19 | US | Oregon | Crook | 41013 | 180 | 6 | 0 | 174 | 44.14230227 | -120.356297 | 2020-11-20 05:26:28 | Crook, Oregon, US |
839090 | 839090 | 2020-08-17 | US | Louisiana | Cameron | 22023 | 174 | 0 | 0 | 174 | 29.87592238 | -93.19310676 | 2020-08-18 04:27:56 | Cameron, Louisiana, US |
839527 | 839527 | 2020-08-17 | US | Missouri | Mississippi | 29133 | 174 | 0 | 0 | 174 | 36.82516239 | -89.29505753 | 2020-08-18 04:27:56 | Mississippi, Missouri, US |
839799 | 839799 | 2020-08-17 | US | New Mexico | Roosevelt | 35041 | 175 | 1 | 0 | 174 | 34.02097406 | -103.4799493 | 2020-08-18 04:27:56 | Roosevelt, New Mexico, US |
842421 | 842421 | 2020-07-22 | US | Georgia | Greene | 13133 | 185 | 11 | 0 | 174 | 33.5769205 | -83.17139104 | 2020-07-23 05:15:04 | Greene, Georgia, US |
845089 | 845089 | 2020-07-22 | Cyprus | 1040 | 19 | 847 | 174 | 35.1264 | 33.4299 | 2020-07-23 05:15:04 | Cyprus | |||
846028 | 846028 | 2020-12-12 | US | Arkansas | Calhoun | 5013 | 175 | 1 | 0 | 174 | 33.55598792 | -92.49974403 | 2020-12-13 05:27:20 | Calhoun, Arkansas, US |
858633 | 858633 | 2020-04-15 | US | Florida | Lake | 12069 | 179 | 5 | 0 | 174 | 28.76202069 | -81.7125123 | 2020-04-15 22:56:51 | Lake, Florida, US |
860702 | 860702 | 2020-12-11 | Japan | Nagano | 909 | 6 | 729 | 174 | 36.132134 | 138.045528 | 2020-12-12 05:26:19 | Nagano, Japan | ||
863715 | 863715 | 2020-12-11 | US | Texas | Cochran | 48079 | 241 | 5 | 0 | 174 | 33.60425307 | -102.8284499 | 2020-12-12 05:26:19 | Cochran, Texas, US |
863947 | 863947 | 2020-12-11 | US | Vermont | Caledonia | 50005 | 176 | 2 | 0 | 174 | 44.46548598 | -72.10314651 | 2020-12-12 05:26:19 | Caledonia, Vermont, US |
867089 | 867089 | 2020-11-12 | US | North Carolina | Hyde | 37095 | 179 | 5 | 0 | 174 | 35.42017674 | -76.15180542 | 2020-11-13 05:25:30 | Hyde, North Carolina, US |
873559 | 873559 | 2020-05-24 | US | Colorado | Gunnison | 8051 | 177 | 4 | 0 | 174 | 38.66611652 | -107.0320729 | 2020-05-25 02:32:44 | Gunnison, Colorado, US |
874402 | 874402 | 2020-05-24 | US | North Carolina | Nash | 37127 | 178 | 4 | 0 | 174 | 35.96575634 | -77.98422508 | 2020-05-25 02:32:44 | Nash, North Carolina, US |
888402 | 888402 | 2021-04-26 | South Sudan | 10538 | 114 | 10250 | 174 | 6.877000000000002 | 31.307 | 2021-04-27 04:20:52 | South Sudan | |||
893366 | 893366 | 2020-11-05 | US | Kansas | Allen | 20001 | 175 | 1 | 0 | 174 | 37.88582951 | -95.30030847 | 2020-11-06 05:24:55 | Allen, Kansas, US |
919250 | 919250 | 2020-03-26 | Moldova | 177 | 1 | 2 | 174 | 47.4116 | 28.3699 | 2020-03-26 23:48:18 | Moldova | |||
924109 | 924109 | 2020-11-26 | US | Alaska | Sitka | 2220 | 174 | 0 | 0 | 174 | 57.24124555 | -135.3206587 | 2020-11-27 05:26:53 | Sitka, Alaska, US |
926061 | 926061 | 2020-11-26 | US | North Dakota | Burke | 38013 | 173 | 1 | 0 | 174 | 48.79094471 | -102.5182117 | 2020-11-27 05:26:53 | Burke, North Dakota, US |
929042 | 929042 | 2020-12-21 | US | Kansas | Wichita | 20203 | 179 | 5 | 0 | 174 | 38.48178252 | -101.3471509 | 2020-12-22 05:22:33 | Wichita, Kansas, US |
966684 | 966684 | 2020-09-29 | Chile | Aysen | 417 | 1 | 242 | 174 | -45.9864 | -73.7669 | 2020-09-30 04:23:33 | Aysen, Chile | ||
967081 | 967081 | 2020-09-29 | Russia | Bashkortostan Republic | 8748 | 41 | 8533 | 174 | 54.8573563 | 57.1439682 | 2020-09-30 04:23:33 | Bashkortostan Republic, Russia | ||
967355 | 967355 | 2020-09-29 | US | Arkansas | Cleveland | 5025 | 186 | 12 | 0 | 174 | 33.89723187 | -92.18537045 | 2020-09-30 04:23:33 | Cleveland, Arkansas, US |
967432 | 967432 | 2020-09-29 | US | California | Inyo | 6027 | 192 | 14 | 0 | 174 | 36.51112084 | -117.41119779999998 | 2020-09-30 04:23:33 | Inyo, California, US |
968052 | 968052 | 2020-09-29 | US | Iowa | Cass | 19029 | 176 | 2 | 0 | 174 | 41.33149454 | -94.92792482 | 2020-09-30 04:23:33 | Cass, Iowa, US |
968323 | 968323 | 2020-09-29 | US | Kentucky | McCreary | 21147 | 174 | 0 | 0 | 174 | 36.73874143 | -84.48102924 | 2020-09-30 04:23:33 | McCreary, Kentucky, US |
968790 | 968790 | 2020-09-29 | US | Missouri | Howard | 29089 | 176 | 2 | 0 | 174 | 39.1435761 | -92.69756691 | 2020-09-30 04:23:33 | Howard, Missouri, US |
977969 | 977969 | 2021-02-06 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-07 05:23:00 | Cottle, Texas, US |
978567 | 978567 | 2021-02-06 | United Kingdom | Gibraltar | 4177 | 80 | 3923 | 174 | 36.1408 | -5.3536 | 2021-02-07 05:23:00 | Gibraltar, United Kingdom | ||
996200 | 996200 | 2020-05-23 | US | South Carolina | Lee | 45061 | 187 | 13 | 0 | 174 | 34.16393091 | -80.25690731 | 2020-05-24 02:32:43 | Lee, South Carolina, US |
996459 | 996459 | 2020-05-23 | US | Ohio | Mercer | 39107 | 178 | 4 | 0 | 174 | 40.54043046 | -84.62912742 | 2020-05-24 02:32:43 | Mercer, Ohio, US |
997212 | 997212 | 2020-05-23 | US | Illinois | Stephenson | 17177 | 176 | 2 | 0 | 174 | 42.35129217 | -89.662598 | 2020-05-24 02:32:43 | Stephenson, Illinois, US |
1000498 | 1000498 | 2021-03-01 | US | Nebraska | Dundy | 31057 | 178 | 4 | 0 | 174 | 40.17638677 | -101.6876522 | 2021-03-02 05:23:30 | Dundy, Nebraska, US |
1002208 | 1002208 | 2020-07-09 | US | North Carolina | Anson | 37007 | 176 | 2 | 0 | 174 | 34.97403241 | -80.09953279 | 2020-07-10 04:34:24 | Anson, North Carolina, US |
1004843 | 1004843 | 2020-07-09 | US | Georgia | Tattnall | 13267 | 174 | 0 | 0 | 174 | 32.04785085 | -82.05539188 | 2020-07-10 04:34:24 | Tattnall, Georgia, US |
1005069 | 1005069 | 2020-07-09 | US | North Carolina | Warren | 37185 | 179 | 5 | 0 | 174 | 36.39728256 | -78.10652228 | 2020-07-10 04:34:24 | Warren, North Carolina, US |
1008235 | 1008235 | 2020-12-06 | US | Missouri | Putnam | 29171 | 175 | 1 | 0 | 174 | 40.47942497 | -93.02042674 | 2020-12-07 05:26:14 | Putnam, Missouri, US |
1008683 | 1008683 | 2020-12-06 | US | North Dakota | Golden Valley | 38033 | 176 | 0 | 0 | 174 | 46.94022281 | -103.8465421 | 2020-12-07 05:26:14 | Golden Valley, North Dakota, US |
1011600 | 1011600 | 2020-12-30 | US | Kansas | Kiowa | 20097 | 175 | 1 | 0 | 174 | 37.55848695 | -99.2856537 | 2020-12-31 05:22:49 | Kiowa, Kansas, 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]);