johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
172 rows where confirmed = 4220 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954482 | 2954482 | 2022-12-20 | US | Texas | Freestone | 48161 | 4220 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-21 04:21:03 | Freestone, Texas, US | |
3176884 | 3176884 | 2022-12-19 | US | Texas | Freestone | 48161 | 4220 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-20 04:21:04 | Freestone, Texas, US | |
1631401 | 1631401 | 2022-12-18 | US | Texas | Freestone | 48161 | 4220 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-19 04:21:03 | Freestone, Texas, US | |
506780 | 506780 | 2022-12-17 | US | Texas | Freestone | 48161 | 4220 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-18 04:21:03 | Freestone, Texas, US | |
3327352 | 3327352 | 2022-12-16 | US | Texas | Freestone | 48161 | 4220 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-17 04:21:04 | Freestone, Texas, US | |
545864 | 545864 | 2022-12-15 | US | Texas | Freestone | 48161 | 4220 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-16 04:21:01 | Freestone, Texas, US | |
351392 | 351392 | 2022-12-14 | US | Texas | Freestone | 48161 | 4220 | 85 | 0 | 31.70422788 | -96.15072516 | 2022-12-15 04:20:58 | Freestone, Texas, US | |
1643864 | 1643864 | 2022-11-20 | US | West Virginia | Roane | 54087 | 4220 | 46 | 0 | 38.71622686 | -81.35243568 | 2022-11-21 04:21:05 | Roane, West Virginia, US | |
2067421 | 2067421 | 2022-11-19 | US | West Virginia | Roane | 54087 | 4220 | 46 | 0 | 38.71622686 | -81.35243568 | 2022-11-20 04:21:08 | Roane, West Virginia, US | |
1758815 | 1758815 | 2022-11-18 | US | West Virginia | Roane | 54087 | 4220 | 46 | 0 | 38.71622686 | -81.35243568 | 2022-11-19 04:21:14 | Roane, West Virginia, US | |
1595146 | 1595146 | 2022-10-21 | US | Tennessee | Decatur | 47039 | 4220 | 71 | 0 | 35.60048904 | -88.11043779 | 2022-10-22 04:22:53 | Decatur, Tennessee, US | |
2969612 | 2969612 | 2022-10-10 | US | New Mexico | Los Alamos | 35028 | 4220 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-10-11 04:23:05 | Los Alamos, New Mexico, US | |
3099648 | 3099648 | 2022-10-09 | US | New Mexico | Los Alamos | 35028 | 4220 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-10-10 04:22:32 | Los Alamos, New Mexico, US | |
4004873 | 4004873 | 2022-10-08 | US | New Mexico | Los Alamos | 35028 | 4220 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-10-09 04:21:16 | Los Alamos, New Mexico, US | |
398470 | 398470 | 2022-10-07 | US | New Mexico | Los Alamos | 35028 | 4220 | 22 | 0 | 35.86631386 | -106.3134985 | 2022-10-08 04:22:56 | Los Alamos, New Mexico, US | |
1979704 | 1979704 | 2022-09-25 | US | Texas | Falls | 48145 | 4220 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-26 04:20:52 | Falls, Texas, US | |
2652871 | 2652871 | 2022-09-24 | US | Texas | Falls | 48145 | 4220 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-25 04:23:31 | Falls, Texas, US | |
387311 | 387311 | 2022-09-23 | US | Texas | Falls | 48145 | 4220 | 68 | 0 | 31.25350609 | -96.93630086 | 2022-09-24 04:21:40 | Falls, Texas, US | |
3373849 | 3373849 | 2022-09-17 | US | Arkansas | Franklin | 5047 | 4220 | 74 | 0 | 35.51202821 | -93.89299569 | 2022-09-18 04:22:50 | Franklin, Arkansas, US | |
2830366 | 2830366 | 2022-08-25 | US | Louisiana | West Carroll | 22123 | 4220 | 70 | 0 | 32.78550125 | -91.461201 | 2022-08-26 04:21:02 | West Carroll, Louisiana, US | |
3648077 | 3648077 | 2022-08-14 | US | Arkansas | Howard | 5061 | 4220 | 53 | 0 | 34.09007427 | -93.9934871 | 2022-08-15 04:20:59 | Howard, Arkansas, US | |
1068093 | 1068093 | 2022-07-28 | US | New Mexico | Socorro | 35053 | 4220 | 93 | 0 | 34.00715494 | -106.9298354 | 2022-07-29 04:20:45 | Socorro, New Mexico, US | |
1202232 | 1202232 | 2022-07-06 | US | North Dakota | Richland | 38077 | 4220 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-07-07 04:20:55 | Richland, North Dakota, US | |
2149491 | 2149491 | 2022-06-27 | US | Mississippi | Smith | 28129 | 4220 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-06-28 04:20:58 | Smith, Mississippi, US | |
477292 | 477292 | 2022-06-26 | US | Mississippi | Smith | 28129 | 4220 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-06-27 04:21:00 | Smith, Mississippi, US | |
940667 | 940667 | 2022-06-25 | US | Mississippi | Smith | 28129 | 4220 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-06-26 04:21:02 | Smith, Mississippi, US | |
3348487 | 3348487 | 2022-06-24 | US | Mississippi | Smith | 28129 | 4220 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-06-25 04:20:57 | Smith, Mississippi, US | |
1651727 | 1651727 | 2022-06-23 | US | Virginia | Grayson | 51077 | 4220 | 83 | 0 | 36.65677234 | -81.23215889 | 2022-06-24 04:20:58 | Grayson, Virginia, US | |
1650228 | 1650228 | 2022-06-23 | US | Mississippi | Smith | 28129 | 4220 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-06-24 04:20:58 | Smith, Mississippi, US | |
2189463 | 2189463 | 2022-06-22 | US | Mississippi | Smith | 28129 | 4220 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-06-23 04:20:55 | Smith, Mississippi, US | |
167894 | 167894 | 2022-06-21 | US | Mississippi | Smith | 28129 | 4220 | 69 | 0 | 32.01744532 | -89.50644846 | 2022-06-22 04:20:54 | Smith, Mississippi, US | |
3158664 | 3158664 | 2022-06-09 | US | Illinois | Mercer | 17131 | 4220 | 49 | 0 | 41.20596782 | -90.74290052 | 2022-06-10 04:20:55 | Mercer, Illinois, US | |
232572 | 232572 | 2022-05-31 | US | Virginia | Giles | 51071 | 4220 | 50 | 0 | 37.31234791 | -80.70636931 | 2022-06-01 04:20:55 | Giles, Virginia, US | |
3731747 | 3731747 | 2022-04-03 | US | Louisiana | LaSalle | 22059 | 4220 | 56 | 0 | 31.67884782 | -92.15907765 | 2022-04-04 04:20:51 | LaSalle, Louisiana, US | |
501182 | 501182 | 2022-04-02 | US | Louisiana | LaSalle | 22059 | 4220 | 56 | 0 | 31.67884782 | -92.15907765 | 2022-04-03 04:20:48 | LaSalle, Louisiana, US | |
3352167 | 3352167 | 2022-04-01 | US | Louisiana | LaSalle | 22059 | 4220 | 56 | 0 | 31.67884782 | -92.15907765 | 2022-04-02 04:20:47 | LaSalle, Louisiana, US | |
3241327 | 3241327 | 2022-03-21 | US | Tennessee | Trousdale | 47169 | 4220 | 45 | 0 | 36.39026213 | -86.16087954 | 2022-03-22 04:20:54 | Trousdale, Tennessee, US | |
27400 | 27400 | 2022-03-20 | US | Tennessee | Trousdale | 47169 | 4220 | 45 | 0 | 36.39026213 | -86.16087954 | 2022-03-21 04:20:50 | Trousdale, Tennessee, US | |
1659133 | 1659133 | 2022-03-19 | US | Puerto Rico | Barranquitas | 72019 | 4220 | 0 | 0 | 18.201592 | -66.30963 | 2022-03-20 04:20:45 | Barranquitas, Puerto Rico, US | |
2320901 | 2320901 | 2022-03-16 | US | Maine | Washington | 23029 | 4220 | 51 | 0 | 45.01607142 | -67.62813524 | 2022-03-17 04:20:56 | Washington, Maine, US | |
922839 | 922839 | 2022-03-08 | US | Texas | Lee | 48287 | 4220 | 60 | 0 | 30.31120597 | -96.97045773 | 2022-03-09 04:20:59 | Lee, Texas, US | |
1548940 | 1548940 | 2022-03-07 | US | Illinois | Carroll | 17015 | 4220 | 47 | 0 | 42.06823429 | -89.93395545 | 2022-03-08 04:20:54 | Carroll, Illinois, US | |
1513786 | 1513786 | 2022-02-24 | US | North Carolina | Warren | 37185 | 4220 | 39 | 0 | 36.39728256 | -78.10652228 | 2022-02-25 04:21:11 | Warren, North Carolina, US | |
2448386 | 2448386 | 2022-02-22 | US | Michigan | Antrim | 26009 | 4220 | 57 | 0 | 44.99690221 | -85.15503082 | 2022-02-23 04:21:09 | Antrim, Michigan, US | |
3719799 | 3719799 | 2022-02-21 | US | Michigan | Antrim | 26009 | 4220 | 57 | 0 | 44.99690221 | -85.15503082 | 2022-02-22 04:21:01 | Antrim, Michigan, US | |
3913633 | 3913633 | 2022-02-20 | US | Michigan | Antrim | 26009 | 4220 | 57 | 0 | 44.99690221 | -85.15503082 | 2022-02-21 04:21:05 | Antrim, Michigan, US | |
3877191 | 3877191 | 2022-02-19 | US | Michigan | Antrim | 26009 | 4220 | 57 | 0 | 44.99690221 | -85.15503082 | 2022-02-20 04:21:00 | Antrim, Michigan, US | |
3857447 | 3857447 | 2022-02-18 | US | Michigan | Antrim | 26009 | 4220 | 57 | 0 | 44.99690221 | -85.15503082 | 2022-02-19 04:21:11 | Antrim, Michigan, US | |
2642509 | 2642509 | 2022-02-14 | US | Georgia | Ben Hill | 13017 | 4220 | 114 | 0 | 31.76095874 | -83.22145359 | 2022-02-15 04:21:09 | Ben Hill, Georgia, US | |
1365573 | 1365573 | 2022-02-08 | US | Texas | Shelby | 48419 | 4220 | 121 | 0 | 31.79211404 | -94.14550696 | 2022-02-09 04:21:04 | Shelby, Texas, US | |
1363251 | 1363251 | 2022-02-08 | US | Georgia | Washington | 13303 | 4220 | 132 | 0 | 32.96711864 | -82.79357039 | 2022-02-09 04:21:04 | Washington, Georgia, US | |
2658168 | 2658168 | 2022-01-31 | US | Alabama | Henry | 1067 | 4220 | 67 | 0 | 31.51148016 | -85.24267944 | 2022-02-01 04:21:11 | Henry, Alabama, US | |
1782669 | 1782669 | 2022-01-27 | US | Vermont | Caledonia | 50005 | 4220 | 22 | 0 | 44.46548598 | -72.10314651 | 2022-01-28 04:21:09 | Caledonia, Vermont, US | |
1782388 | 1782388 | 2022-01-27 | US | Tennessee | Unicoi | 47171 | 4220 | 85 | 0 | 36.10890856 | -82.43709629 | 2022-01-28 04:21:09 | Unicoi, Tennessee, US | |
1319079 | 1319079 | 2022-01-26 | US | Georgia | Putnam | 13237 | 4220 | 92 | 0 | 33.32056115 | -83.37552891 | 2022-01-27 04:21:19 | Putnam, Georgia, US | |
1319065 | 1319065 | 2022-01-26 | US | Georgia | Morgan | 13211 | 4220 | 52 | 0 | 33.59232073 | -83.49129491 | 2022-01-27 04:21:19 | Morgan, Georgia, US | |
2055062 | 2055062 | 2022-01-25 | US | Texas | Montague | 48337 | 4220 | 106 | 0 | 33.67521893 | -97.72500958 | 2022-01-26 04:21:07 | Montague, Texas, US | |
1962421 | 1962421 | 2022-01-20 | US | Mississippi | Winston | 28159 | 4220 | 95 | 0 | 33.08747908 | -89.03391385 | 2022-01-21 04:21:09 | Winston, Mississippi, US | |
1472631 | 1472631 | 2022-01-17 | US | Arkansas | Phillips | 5107 | 4220 | 84 | 0 | 34.43268455 | -90.84800154 | 2022-01-18 04:21:04 | Phillips, Arkansas, US | |
1285609 | 1285609 | 2022-01-05 | US | Wyoming | Uinta | 56041 | 4220 | 34 | 0 | 41.2878183 | -110.54757820000002 | 2022-01-06 04:22:09 | Uinta, Wyoming, US | |
1287428 | 1287428 | 2022-01-04 | US | Kentucky | Johnson | 21115 | 4220 | 80 | 0 | 37.85106355 | -82.8264322 | 2022-01-05 04:21:59 | Johnson, Kentucky, US | |
4001100 | 4001100 | 2021-12-30 | US | Ohio | Carroll | 39019 | 4220 | 103 | 0 | 40.578968599999996 | -81.09178213 | 2021-12-31 04:21:50 | Carroll, Ohio, US | |
1255415 | 1255415 | 2021-12-20 | US | Colorado | Morgan | 8087 | 4220 | 129 | 0 | 40.26279810000001 | -103.8093302 | 2021-12-21 03:21:27 | Morgan, Colorado, US | |
1717662 | 1717662 | 2021-12-16 | US | Kansas | Labette | 20099 | 4220 | 64 | 0 | 37.19113093 | -95.29849679 | 2021-12-17 04:22:14 | Labette, Kansas, US | |
3497496 | 3497496 | 2021-12-15 | US | Kansas | Labette | 20099 | 4220 | 64 | 0 | 37.19113093 | -95.29849679 | 2021-12-16 04:22:11 | Labette, Kansas, US | |
1148110 | 1148110 | 2021-12-01 | US | Texas | Moore | 48341 | 4220 | 89 | 0 | 35.83769242 | -101.8930281 | 2021-12-02 04:22:37 | Moore, Texas, US | |
760802 | 760802 | 2021-11-26 | US | Ohio | Henry | 39069 | 4220 | 82 | 0 | 41.333964200000004 | -84.06830637 | 2021-11-27 04:22:45 | Henry, Ohio, US | |
1806060 | 1806060 | 2021-11-25 | US | Virginia | Caroline | 51033 | 4220 | 54 | 0 | 38.02679129 | -77.34901405 | 2021-11-26 04:22:33 | Caroline, Virginia, US | |
3640429 | 3640429 | 2021-11-08 | US | Georgia | Sumter | 13261 | 4220 | 135 | 0 | 32.03650571 | -84.19821492 | 2021-11-09 04:21:36 | Sumter, Georgia, US | |
2001537 | 2001537 | 2021-11-07 | US | Georgia | Sumter | 13261 | 4220 | 135 | 0 | 32.03650571 | -84.19821492 | 2021-11-08 04:21:43 | Sumter, Georgia, US | |
496528 | 496528 | 2021-11-06 | US | Georgia | Sumter | 13261 | 4220 | 135 | 0 | 32.03650571 | -84.19821492 | 2021-11-07 04:21:53 | Sumter, Georgia, US | |
3122383 | 3122383 | 2021-11-05 | US | Georgia | Sumter | 13261 | 4220 | 135 | 0 | 32.03650571 | -84.19821492 | 2021-11-06 04:21:51 | Sumter, Georgia, US | |
46641 | 46641 | 2021-11-02 | US | Tennessee | DeKalb | 47041 | 4220 | 75 | 0 | 35.97616272 | -85.83689361 | 2021-11-03 06:22:09 | DeKalb, Tennessee, US | |
683282 | 683282 | 2021-10-24 | US | Idaho | Jerome | 16053 | 4220 | 49 | 0 | 42.68891267 | -114.2655033 | 2021-10-25 04:22:31 | Jerome, Idaho, US | |
771290 | 771290 | 2021-10-23 | US | Idaho | Jerome | 16053 | 4220 | 49 | 0 | 42.68891267 | -114.2655033 | 2021-10-24 04:21:22 | Jerome, Idaho, US | |
1910366 | 1910366 | 2021-10-17 | US | Indiana | Wells | 18179 | 4220 | 87 | 0 | 40.72934187 | -85.22132966 | 2021-10-18 04:21:10 | Wells, Indiana, US | |
1239192 | 1239192 | 2021-09-27 | US | Wisconsin | Green | 55045 | 4220 | 26 | 0 | 42.6794956 | -89.60243287 | 2021-09-28 04:21:28 | Green, Wisconsin, US | |
2809711 | 2809711 | 2021-09-16 | US | Illinois | Bureau | 17011 | 4220 | 87 | 0 | 41.40385234 | -89.5283051 | 2021-09-17 04:21:46 | Bureau, Illinois, US | |
2464635 | 2464635 | 2021-09-14 | US | Mississippi | Simpson | 28127 | 4220 | 107 | 0 | 31.91282117 | -89.91716179 | 2021-09-15 03:22:37 | Simpson, Mississippi, US | |
2464586 | 2464586 | 2021-09-14 | US | Mississippi | Copiah | 28029 | 4220 | 83 | 0 | 31.86977774 | -90.44565118 | 2021-09-15 03:22:37 | Copiah, Mississippi, US | |
1886751 | 1886751 | 2021-09-12 | US | Minnesota | Polk | 27119 | 4220 | 75 | 0 | 47.77372465 | -96.40134647 | 2021-09-13 04:21:15 | Polk, Minnesota, US | |
1885494 | 1885494 | 2021-09-12 | US | Arkansas | Johnson | 5071 | 4220 | 54 | 0 | 35.56759135 | -93.46036368 | 2021-09-13 04:21:15 | Johnson, Arkansas, US | |
3807654 | 3807654 | 2021-09-11 | US | Minnesota | Polk | 27119 | 4220 | 75 | 0 | 47.77372465 | -96.40134647 | 2021-09-12 04:21:13 | Polk, Minnesota, US | |
3450594 | 3450594 | 2021-09-10 | US | Minnesota | Polk | 27119 | 4220 | 75 | 0 | 47.77372465 | -96.40134647 | 2021-09-11 04:21:30 | Polk, Minnesota, US | |
3197119 | 3197119 | 2021-09-06 | US | Texas | Hopkins | 48223 | 4220 | 126 | 0 | 33.14875072 | -95.56351139 | 2021-09-07 04:21:35 | Hopkins, Texas, US | |
3107089 | 3107089 | 2021-08-24 | US | Michigan | Gratiot | 26057 | 4220 | 121 | 0 | 43.29265605 | -84.60505416 | 2021-08-25 04:21:41 | Gratiot, Michigan, US | |
3167260 | 3167260 | 2021-08-23 | US | Michigan | Gratiot | 26057 | 4220 | 121 | 0 | 43.29265605 | -84.60505416 | 2021-08-24 04:21:19 | Gratiot, Michigan, US | |
246150 | 246150 | 2021-08-17 | US | Georgia | Toombs | 13279 | 4220 | 123 | 0 | 32.12059861 | -82.32957247 | 2021-08-18 04:21:35 | Toombs, Georgia, US | |
1605334 | 1605334 | 2021-08-16 | US | Indiana | Knox | 18083 | 4220 | 91 | 0 | 38.68861576 | -87.4194665 | 2021-08-17 04:21:49 | Knox, Indiana, US | |
1484952 | 1484952 | 2021-08-13 | US | Kentucky | Floyd | 21071 | 4220 | 75 | 0 | 37.56213922 | -82.74750924 | 2021-08-14 04:21:25 | Floyd, Kentucky, US | |
2900822 | 2900822 | 2021-08-12 | US | Indiana | Steuben | 18151 | 4220 | 62 | 0 | 41.64423868 | -85.00101094 | 2021-08-13 04:21:24 | Steuben, Indiana, US | |
410999 | 410999 | 2021-07-28 | US | Pennsylvania | Wayne | 42127 | 4220 | 84 | 0 | 41.64938475 | -75.29956506 | 2021-07-29 04:21:33 | Wayne, Pennsylvania, US | |
3218666 | 3218666 | 2021-07-26 | US | Alabama | Escambia | 1053 | 4220 | 82 | 0 | 31.1256789 | -87.15918694 | 2021-07-27 04:21:18 | Escambia, Alabama, US | |
1332165 | 1332165 | 2021-07-24 | US | Missouri | Lawrence | 29109 | 4220 | 90 | 0 | 37.10626634 | -93.83293097 | 2021-07-25 04:22:12 | Lawrence, Missouri, US | |
3139498 | 3139498 | 2021-07-23 | US | Missouri | Polk | 29167 | 4220 | 39 | 0 | 37.6162296 | -93.39828174 | 2021-07-24 00:21:36 | Polk, Missouri, US | |
3139030 | 3139030 | 2021-07-23 | US | Kentucky | Whitley | 21235 | 4220 | 62 | 0 | 36.75700531 | -84.14541217 | 2021-07-24 00:21:36 | Whitley, Kentucky, US | |
2676122 | 2676122 | 2021-07-18 | US | North Carolina | Davie | 37059 | 4220 | 40 | 0 | 35.93099927 | -80.54496571 | 2021-07-19 04:21:24 | Davie, North Carolina, US | |
3708434 | 3708434 | 2021-07-17 | US | North Carolina | Davie | 37059 | 4220 | 40 | 0 | 35.93099927 | -80.54496571 | 2021-07-18 04:22:07 | Davie, North Carolina, US | |
2949665 | 2949665 | 2021-07-16 | US | North Carolina | Davie | 37059 | 4220 | 40 | 0 | 35.93099927 | -80.54496571 | 2021-07-17 04:22:22 | Davie, North Carolina, US | |
299256 | 299256 | 2021-07-15 | US | Texas | Waller | 48473 | 4220 | 52 | 0 | 30.01058447 | -95.99011759 | 2021-07-16 04:21:22 | Waller, 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]);