johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
235 rows where confirmed = 2520 sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1077394 | 1077394 | 2022-12-28 | US | West Virginia | Gilmer | 54021 | 2520 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-29 04:21:01 | Gilmer, West Virginia, US | |
1987598 | 1987598 | 2022-12-07 | US | Tennessee | Hancock | 47067 | 2520 | 42 | 0 | 36.52692871 | -83.22375847 | 2022-12-08 04:21:07 | Hancock, Tennessee, US | |
2557421 | 2557421 | 2022-11-29 | US | Georgia | Johnson | 13167 | 2520 | 82 | 0 | 32.70211082 | -82.66166794 | 2022-11-30 04:21:07 | Johnson, Georgia, US | |
1240495 | 1240495 | 2022-11-28 | US | Georgia | Johnson | 13167 | 2520 | 82 | 0 | 32.70211082 | -82.66166794 | 2022-11-29 04:21:05 | Johnson, Georgia, US | |
3552483 | 3552483 | 2022-11-27 | US | Georgia | Johnson | 13167 | 2520 | 82 | 0 | 32.70211082 | -82.66166794 | 2022-11-28 04:21:02 | Johnson, Georgia, US | |
2100963 | 2100963 | 2022-11-26 | US | Georgia | Johnson | 13167 | 2520 | 82 | 0 | 32.70211082 | -82.66166794 | 2022-11-27 04:21:05 | Johnson, Georgia, US | |
488454 | 488454 | 2022-11-25 | US | Georgia | Johnson | 13167 | 2520 | 82 | 0 | 32.70211082 | -82.66166794 | 2022-11-26 04:21:11 | Johnson, Georgia, US | |
3524283 | 3524283 | 2022-11-24 | US | Georgia | Johnson | 13167 | 2520 | 82 | 0 | 32.70211082 | -82.66166794 | 2022-11-25 04:21:06 | Johnson, Georgia, US | |
3313066 | 3313066 | 2022-11-23 | US | Georgia | Johnson | 13167 | 2520 | 82 | 0 | 32.70211082 | -82.66166794 | 2022-11-24 04:21:09 | Johnson, Georgia, US | |
134119 | 134119 | 2022-10-04 | US | Virginia | Lexington | 51678 | 2520 | 34 | 0 | 37.78258621 | -79.44262866 | 2022-10-05 04:23:06 | Lexington, Virginia, US | |
2260701 | 2260701 | 2022-10-02 | US | Idaho | Clearwater | 16035 | 2520 | 36 | 0 | 46.67459924 | -115.6622393 | 2022-10-03 04:23:11 | Clearwater, Idaho, US | |
2996227 | 2996227 | 2022-10-01 | US | Idaho | Clearwater | 16035 | 2520 | 36 | 0 | 46.67459924 | -115.6622393 | 2022-10-02 04:21:23 | Clearwater, Idaho, US | |
854553 | 854553 | 2022-09-30 | US | Idaho | Clearwater | 16035 | 2520 | 36 | 0 | 46.67459924 | -115.6622393 | 2022-10-01 04:23:01 | Clearwater, Idaho, US | |
3573435 | 3573435 | 2022-09-19 | US | South Carolina | McCormick | 45065 | 2520 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-20 04:22:48 | McCormick, South Carolina, US | |
422174 | 422174 | 2022-09-18 | US | South Carolina | McCormick | 45065 | 2520 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-19 04:21:49 | McCormick, South Carolina, US | |
3376198 | 3376198 | 2022-09-17 | US | South Carolina | McCormick | 45065 | 2520 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-18 04:22:50 | McCormick, South Carolina, US | |
2358306 | 2358306 | 2022-09-16 | US | South Carolina | McCormick | 45065 | 2520 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-17 04:20:19 | McCormick, South Carolina, US | |
3989463 | 3989463 | 2022-09-15 | US | South Carolina | McCormick | 45065 | 2520 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-16 04:21:19 | McCormick, South Carolina, US | |
1891980 | 1891980 | 2022-09-14 | US | South Carolina | McCormick | 45065 | 2520 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-15 04:21:02 | McCormick, South Carolina, US | |
375035 | 375035 | 2022-09-13 | US | South Carolina | McCormick | 45065 | 2520 | 40 | 0 | 33.90161443 | -82.30794338 | 2022-09-14 04:20:44 | McCormick, South Carolina, US | |
2395314 | 2395314 | 2022-09-12 | US | Arkansas | Nevada | 5099 | 2520 | 45 | 0 | 33.66340119 | -93.30632432 | 2022-09-13 04:20:57 | Nevada, Arkansas, US | |
1253804 | 1253804 | 2022-08-23 | US | Texas | Castro | 48069 | 2520 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-08-24 04:20:46 | Castro, Texas, US | |
2855908 | 2855908 | 2022-08-22 | US | Texas | Castro | 48069 | 2520 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-08-23 04:20:56 | Castro, Texas, US | |
1071287 | 1071287 | 2022-08-07 | US | Kentucky | Crittenden | 21055 | 2520 | 51 | 0 | 37.35839237 | -88.0882609 | 2022-08-08 04:21:08 | Crittenden, Kentucky, US | |
1941875 | 1941875 | 2022-08-06 | US | Kentucky | Crittenden | 21055 | 2520 | 51 | 0 | 37.35839237 | -88.0882609 | 2022-08-07 04:20:54 | Crittenden, Kentucky, US | |
881674 | 881674 | 2022-08-05 | US | Kentucky | Crittenden | 21055 | 2520 | 51 | 0 | 37.35839237 | -88.0882609 | 2022-08-06 04:20:56 | Crittenden, Kentucky, US | |
2010085 | 2010085 | 2022-08-04 | US | Kentucky | Crittenden | 21055 | 2520 | 51 | 0 | 37.35839237 | -88.0882609 | 2022-08-05 04:20:52 | Crittenden, Kentucky, US | |
1099512 | 1099512 | 2022-08-03 | US | Kentucky | Crittenden | 21055 | 2520 | 51 | 0 | 37.35839237 | -88.0882609 | 2022-08-04 04:20:58 | Crittenden, Kentucky, US | |
1406437 | 1406437 | 2022-08-02 | US | Kentucky | Crittenden | 21055 | 2520 | 51 | 0 | 37.35839237 | -88.0882609 | 2022-08-03 04:20:59 | Crittenden, Kentucky, US | |
3618475 | 3618475 | 2022-08-01 | US | Kentucky | Crittenden | 21055 | 2520 | 51 | 0 | 37.35839237 | -88.0882609 | 2022-08-02 04:20:53 | Crittenden, Kentucky, US | |
1488861 | 1488861 | 2022-07-26 | US | Kansas | Coffey | 20031 | 2520 | 45 | 0 | 38.2365018 | -95.73379515 | 2022-07-27 04:21:04 | Coffey, Kansas, US | |
2595307 | 2595307 | 2022-07-25 | US | Kansas | Coffey | 20031 | 2520 | 45 | 0 | 38.2365018 | -95.73379515 | 2022-07-26 04:20:58 | Coffey, Kansas, US | |
897422 | 897422 | 2022-07-24 | US | Kansas | Coffey | 20031 | 2520 | 45 | 0 | 38.2365018 | -95.73379515 | 2022-07-25 04:20:51 | Coffey, Kansas, US | |
92416 | 92416 | 2022-07-23 | US | Kansas | Coffey | 20031 | 2520 | 45 | 0 | 38.2365018 | -95.73379515 | 2022-07-24 04:20:47 | Coffey, Kansas, US | |
901438 | 901438 | 2022-07-22 | US | Kansas | Coffey | 20031 | 2520 | 45 | 0 | 38.2365018 | -95.73379515 | 2022-07-23 04:20:53 | Coffey, Kansas, US | |
671574 | 671574 | 2022-07-21 | US | Kansas | Coffey | 20031 | 2520 | 45 | 0 | 38.2365018 | -95.73379515 | 2022-07-22 04:21:15 | Coffey, Kansas, US | |
1609537 | 1609537 | 2022-07-20 | US | Kansas | Coffey | 20031 | 2520 | 45 | 0 | 38.2365018 | -95.73379515 | 2022-07-21 04:21:10 | Coffey, Kansas, US | |
3272932 | 3272932 | 2022-06-19 | US | Virginia | Sussex | 51183 | 2520 | 42 | 0 | 36.92432914 | -77.25791182 | 2022-06-20 04:21:01 | Sussex, Virginia, US | |
3400844 | 3400844 | 2022-06-18 | US | Virginia | Sussex | 51183 | 2520 | 42 | 0 | 36.92432914 | -77.25791182 | 2022-06-19 04:20:51 | Sussex, Virginia, US | |
2314721 | 2314721 | 2022-06-17 | US | Virginia | Sussex | 51183 | 2520 | 42 | 0 | 36.92432914 | -77.25791182 | 2022-06-18 04:21:10 | Sussex, Virginia, US | |
230443 | 230443 | 2022-05-31 | US | Iowa | Louisa | 19115 | 2520 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-06-01 04:20:55 | Louisa, Iowa, US | |
3187208 | 3187208 | 2022-05-30 | US | Iowa | Louisa | 19115 | 2520 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-31 04:20:51 | Louisa, Iowa, US | |
3199357 | 3199357 | 2022-05-29 | US | Iowa | Louisa | 19115 | 2520 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-30 04:20:50 | Louisa, Iowa, US | |
2726235 | 2726235 | 2022-05-28 | US | Iowa | Louisa | 19115 | 2520 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-29 04:20:53 | Louisa, Iowa, US | |
1315416 | 1315416 | 2022-05-27 | US | Iowa | Louisa | 19115 | 2520 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-28 04:21:07 | Louisa, Iowa, US | |
1851208 | 1851208 | 2022-05-26 | US | Iowa | Louisa | 19115 | 2520 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-27 04:20:56 | Louisa, Iowa, US | |
2049084 | 2049084 | 2022-05-25 | US | Iowa | Louisa | 19115 | 2520 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-26 04:20:50 | Louisa, Iowa, US | |
623095 | 623095 | 2022-05-22 | US | Iowa | Louisa | 19115 | 2520 | 62 | 0 | 41.21842119 | -91.26102611 | 2022-05-26 04:20:50 | Louisa, Iowa, US | |
1113031 | 1113031 | 2022-05-21 | US | Washington | Pend Oreille | 53051 | 2520 | 36 | 0 | 48.53234021 | -117.2741804 | 2022-05-22 04:20:52 | Pend Oreille, Washington, US | |
1172655 | 1172655 | 2022-05-20 | US | Washington | Pend Oreille | 53051 | 2520 | 36 | 0 | 48.53234021 | -117.2741804 | 2022-05-21 04:20:58 | Pend Oreille, Washington, US | |
360857 | 360857 | 2022-05-07 | US | Arkansas | Perry | 5105 | 2520 | 37 | 0 | 34.9459153 | -92.94372564 | 2022-05-08 04:20:49 | Perry, Arkansas, US | |
1398208 | 1398208 | 2022-05-06 | US | Arkansas | Perry | 5105 | 2520 | 37 | 0 | 34.9459153 | -92.94372564 | 2022-05-07 04:21:09 | Perry, Arkansas, US | |
3440012 | 3440012 | 2022-04-22 | US | Texas | Morris | 48343 | 2520 | 73 | 0 | 33.11304005 | -94.73255695 | 2022-04-23 04:20:50 | Morris, Texas, US | |
161246 | 161246 | 2022-03-29 | US | Texas | Terry | 48445 | 2520 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-03-30 04:20:45 | Terry, Texas, US | |
2734653 | 2734653 | 2022-02-27 | US | Michigan | Crawford | 26039 | 2520 | 29 | 0 | 44.68255561 | -84.61006219 | 2022-02-28 04:21:05 | Crawford, Michigan, US | |
3047806 | 3047806 | 2022-02-26 | US | Michigan | Crawford | 26039 | 2520 | 29 | 0 | 44.68255561 | -84.61006219 | 2022-02-27 04:21:04 | Crawford, Michigan, US | |
576461 | 576461 | 2022-02-25 | US | Michigan | Crawford | 26039 | 2520 | 29 | 0 | 44.68255561 | -84.61006219 | 2022-02-26 04:21:12 | Crawford, Michigan, US | |
1513822 | 1513822 | 2022-02-24 | US | North Dakota | Mercer | 38057 | 2520 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-02-25 04:21:11 | Mercer, North Dakota, US | |
2448673 | 2448673 | 2022-02-22 | US | Missouri | Douglas | 29067 | 2520 | 72 | 0 | 36.9325593 | -92.49905109 | 2022-02-23 04:21:09 | Douglas, Missouri, US | |
2447662 | 2447662 | 2022-02-22 | US | Georgia | Turner | 13287 | 2520 | 53 | 0 | 31.71612656 | -83.62069378 | 2022-02-23 04:21:09 | Turner, Georgia, US | |
3672968 | 3672968 | 2022-02-15 | US | Kansas | Marshall | 20117 | 2520 | 41 | 0 | 39.78359669 | -96.52278974 | 2022-02-16 04:21:10 | Marshall, Kansas, US | |
2642874 | 2642874 | 2022-02-14 | US | Indiana | Newton | 18111 | 2520 | 63 | 0 | 40.95610449 | -87.39635768 | 2022-02-15 04:21:09 | Newton, Indiana, US | |
3075491 | 3075491 | 2022-02-09 | US | Kentucky | McLean | 21149 | 2520 | 45 | 0 | 37.5301951 | -87.26803443 | 2022-02-10 04:21:14 | McLean, Kentucky, US | |
2330319 | 2330319 | 2022-02-04 | US | Tennessee | Houston | 47083 | 2520 | 56 | 0 | 36.28872054 | -87.71878828 | 2022-02-05 04:21:05 | Houston, Tennessee, US | |
3303580 | 3303580 | 2022-01-30 | US | Virginia | Manassas Park | 51685 | 2520 | 16 | 0 | 38.77058531 | -77.44399307 | 2022-01-31 04:21:09 | Manassas Park, Virginia, US | |
3065371 | 3065371 | 2022-01-29 | US | Virginia | Manassas Park | 51685 | 2520 | 16 | 0 | 38.77058531 | -77.44399307 | 2022-01-30 04:21:26 | Manassas Park, Virginia, US | |
3813305 | 3813305 | 2022-01-28 | US | Virginia | Manassas Park | 51685 | 2520 | 16 | 0 | 38.77058531 | -77.44399307 | 2022-01-29 04:21:10 | Manassas Park, Virginia, US | |
3465873 | 3465873 | 2022-01-18 | US | Minnesota | Aitkin | 27001 | 2520 | 56 | 0 | 46.60962049 | -93.41168259999999 | 2022-01-19 04:21:23 | Aitkin, Minnesota, US | |
1475445 | 1475445 | 2022-01-17 | US | Virginia | Dickenson | 51051 | 2520 | 40 | 0 | 37.12560977 | -82.35124171 | 2022-01-18 04:21:04 | Dickenson, Virginia, US | |
1473056 | 1473056 | 2022-01-17 | US | Idaho | Idaho | 16049 | 2520 | 42 | 0 | 45.84721541 | -115.4634436 | 2022-01-18 04:21:04 | Idaho, Idaho, US | |
555730 | 555730 | 2022-01-16 | US | Idaho | Idaho | 16049 | 2520 | 42 | 0 | 45.84721541 | -115.4634436 | 2022-01-17 04:21:08 | Idaho, Idaho, US | |
3841451 | 3841451 | 2022-01-15 | US | Idaho | Idaho | 16049 | 2520 | 42 | 0 | 45.84721541 | -115.4634436 | 2022-01-16 04:21:12 | Idaho, Idaho, US | |
100266 | 100266 | 2022-01-14 | US | Idaho | Idaho | 16049 | 2520 | 42 | 0 | 45.84721541 | -115.4634436 | 2022-01-15 04:21:07 | Idaho, Idaho, US | |
3690930 | 3690930 | 2022-01-13 | US | Washington | Klickitat | 53039 | 2520 | 36 | 0 | 45.87325839 | -120.7913598 | 2022-01-14 04:21:54 | Klickitat, Washington, US | |
1695845 | 1695845 | 2022-01-10 | US | Wisconsin | Ashland | 55003 | 2520 | 28 | 0 | 46.31956891 | -90.67837132 | 2022-01-11 04:22:01 | Ashland, Wisconsin, US | |
1288865 | 1288865 | 2022-01-04 | US | South Dakota | Clay | 46027 | 2520 | 17 | 0 | 42.91296147 | -96.97656917 | 2022-01-05 04:21:59 | Clay, South Dakota, US | |
732431 | 732431 | 2021-12-27 | US | Missouri | Gasconade | 29073 | 2520 | 86 | 0 | 38.43947277 | -91.50847147 | 2021-12-28 04:21:47 | Gasconade, Missouri, US | |
2113565 | 2113565 | 2021-12-26 | US | Mississippi | Yalobusha | 28161 | 2520 | 47 | 0 | 34.02824175 | -89.70762049999998 | 2021-12-27 04:21:58 | Yalobusha, Mississippi, US | |
3606937 | 3606937 | 2021-12-25 | US | Mississippi | Yalobusha | 28161 | 2520 | 47 | 0 | 34.02824175 | -89.70762049999998 | 2021-12-26 04:21:50 | Yalobusha, Mississippi, US | |
2965255 | 2965255 | 2021-12-24 | US | Mississippi | Yalobusha | 28161 | 2520 | 47 | 0 | 34.02824175 | -89.70762049999998 | 2021-12-25 04:21:37 | Yalobusha, Mississippi, US | |
3818287 | 3818287 | 2021-12-23 | US | Mississippi | Yalobusha | 28161 | 2520 | 47 | 0 | 34.02824175 | -89.70762049999998 | 2021-12-24 04:21:34 | Yalobusha, Mississippi, US | |
800295 | 800295 | 2021-12-22 | US | Mississippi | Yalobusha | 28161 | 2520 | 47 | 0 | 34.02824175 | -89.70762049999998 | 2021-12-23 04:21:21 | Yalobusha, Mississippi, US | |
1719289 | 1719289 | 2021-12-16 | US | Tennessee | Decatur | 47039 | 2520 | 44 | 0 | 35.60048904 | -88.11043779 | 2021-12-17 04:22:14 | Decatur, Tennessee, US | |
3498309 | 3498309 | 2021-12-15 | US | Nebraska | Seward | 31159 | 2520 | 32 | 0 | 40.87241834 | -97.139673 | 2021-12-16 04:22:11 | Seward, Nebraska, US | |
3497215 | 3497215 | 2021-12-15 | US | Illinois | Mercer | 17131 | 2520 | 37 | 0 | 41.20596782 | -90.74290052 | 2021-12-16 04:22:11 | Mercer, Illinois, US | |
783841 | 783841 | 2021-12-13 | US | Kentucky | Monroe | 21171 | 2520 | 66 | 0 | 36.71225341 | -85.71596443 | 2021-12-14 04:22:38 | Monroe, Kentucky, US | |
3658029 | 3658029 | 2021-12-10 | US | North Dakota | Walsh | 38099 | 2520 | 30 | 0 | 48.36876964 | -97.72574783 | 2021-12-11 04:22:45 | Walsh, North Dakota, US | |
405720 | 405720 | 2021-12-07 | US | Kentucky | Larue | 21123 | 2520 | 53 | 0 | 37.54567114 | -85.70138352 | 2021-12-08 04:22:46 | Larue, Kentucky, US | |
2195981 | 2195981 | 2021-12-03 | US | Alabama | Clay | 1027 | 2520 | 69 | 0 | 33.26984193 | -85.85836077 | 2021-12-04 04:22:18 | Clay, Alabama, US | |
1017354 | 1017354 | 2021-11-21 | US | Texas | Bandera | 48019 | 2520 | 61 | 0 | 29.74619598 | -99.24598147 | 2021-11-22 04:22:20 | Bandera, Texas, US | |
725518 | 725518 | 2021-11-20 | US | Texas | Bandera | 48019 | 2520 | 61 | 0 | 29.74619598 | -99.24598147 | 2021-11-21 04:22:13 | Bandera, Texas, US | |
165048 | 165048 | 2021-11-19 | US | Texas | Bandera | 48019 | 2520 | 61 | 0 | 29.74619598 | -99.24598147 | 2021-11-20 04:22:17 | Bandera, Texas, US | |
3292447 | 3292447 | 2021-11-18 | US | Wisconsin | Burnett | 55013 | 2520 | 33 | 0 | 45.86303537 | -92.36711412 | 2021-11-19 04:21:40 | Burnett, Wisconsin, US | |
3346000 | 3346000 | 2021-11-16 | US | Virginia | New Kent | 51127 | 2520 | 26 | 0 | 37.50694406 | -76.99828634 | 2021-11-17 04:21:48 | New Kent, Virginia, US | |
714824 | 714824 | 2021-11-12 | US | Alabama | Cleburne | 1029 | 2520 | 60 | 0 | 33.67679204 | -85.52005899 | 2021-11-13 04:21:38 | Cleburne, Alabama, US | |
31027 | 31027 | 2021-11-11 | US | Oregon | Clatsop | 41007 | 2520 | 32 | 0 | 45.99712889 | -123.660711 | 2021-11-12 04:22:01 | Clatsop, Oregon, US | |
2847466 | 2847466 | 2021-11-10 | US | Oregon | Clatsop | 41007 | 2520 | 32 | 0 | 45.99712889 | -123.660711 | 2021-11-11 04:21:45 | Clatsop, Oregon, US | |
88181 | 88181 | 2021-11-09 | US | Illinois | Warren | 17187 | 2520 | 68 | 0 | 40.84925021 | -90.6147432 | 2021-11-10 04:21:38 | Warren, Illinois, US | |
2723965 | 2723965 | 2021-10-30 | US | Tennessee | Lewis | 47101 | 2520 | 38 | 0 | 35.52853208 | -87.49022694 | 2021-10-31 04:22:08 | Lewis, Tennessee, US | |
570067 | 570067 | 2021-10-29 | US | Tennessee | Lewis | 47101 | 2520 | 38 | 0 | 35.52853208 | -87.49022694 | 2021-10-30 04:22:03 | Lewis, Tennessee, 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]);