johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
209 rows where confirmed = 2980 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2182543 | 2182543 | 2022-12-22 | US | Tennessee | Houston | 47083 | 2980 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-12-23 04:21:04 | Houston, Tennessee, US | |
870262 | 870262 | 2022-12-11 | US | Kentucky | Owen | 21187 | 2980 | 40 | 0 | 38.51679143 | -84.82404619 | 2022-12-12 04:21:01 | Owen, Kentucky, US | |
258792 | 258792 | 2022-12-10 | US | Kentucky | Owen | 21187 | 2980 | 40 | 0 | 38.51679143 | -84.82404619 | 2022-12-11 04:20:50 | Owen, Kentucky, US | |
3937506 | 3937506 | 2022-12-09 | US | Kentucky | Owen | 21187 | 2980 | 40 | 0 | 38.51679143 | -84.82404619 | 2022-12-10 04:21:02 | Owen, Kentucky, US | |
3378838 | 3378838 | 2022-12-08 | US | Kentucky | Owen | 21187 | 2980 | 40 | 0 | 38.51679143 | -84.82404619 | 2022-12-09 04:21:05 | Owen, Kentucky, US | |
1986109 | 1986109 | 2022-12-07 | US | Kentucky | Owen | 21187 | 2980 | 40 | 0 | 38.51679143 | -84.82404619 | 2022-12-08 04:21:07 | Owen, Kentucky, US | |
3715632 | 3715632 | 2022-12-06 | US | Kentucky | Owen | 21187 | 2980 | 40 | 0 | 38.51679143 | -84.82404619 | 2022-12-07 04:20:58 | Owen, Kentucky, US | |
2416337 | 2416337 | 2022-12-05 | US | Kentucky | Owen | 21187 | 2980 | 40 | 0 | 38.51679143 | -84.82404619 | 2022-12-06 04:21:03 | Owen, Kentucky, US | |
3526824 | 3526824 | 2022-11-24 | US | Virginia | Madison | 51113 | 2980 | 45 | 0 | 38.41531222 | -78.28220331 | 2022-11-25 04:21:06 | Madison, Virginia, US | |
3315607 | 3315607 | 2022-11-23 | US | Virginia | Madison | 51113 | 2980 | 45 | 0 | 38.41531222 | -78.28220331 | 2022-11-24 04:21:09 | Madison, Virginia, US | |
2758141 | 2758141 | 2022-10-18 | US | Iowa | Lyon | 19119 | 2980 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-19 04:22:26 | Lyon, Iowa, US | |
2025975 | 2025975 | 2022-10-17 | US | Iowa | Lyon | 19119 | 2980 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-18 04:22:42 | Lyon, Iowa, US | |
2160753 | 2160753 | 2022-10-16 | US | Iowa | Lyon | 19119 | 2980 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-17 04:20:31 | Lyon, Iowa, US | |
516950 | 516950 | 2022-10-15 | US | Iowa | Lyon | 19119 | 2980 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-16 04:22:39 | Lyon, Iowa, US | |
2034007 | 2034007 | 2022-10-14 | US | Iowa | Lyon | 19119 | 2980 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-15 04:22:00 | Lyon, Iowa, US | |
3754695 | 3754695 | 2022-10-13 | US | Iowa | Lyon | 19119 | 2980 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-14 04:22:28 | Lyon, Iowa, US | |
3215520 | 3215520 | 2022-10-12 | US | Iowa | Lyon | 19119 | 2980 | 52 | 0 | 43.38107862 | -96.20926845 | 2022-10-13 04:22:39 | Lyon, Iowa, US | |
2686187 | 2686187 | 2022-10-03 | US | Arkansas | Fulton | 5049 | 2980 | 96 | 0 | 36.38177105 | -91.81729127 | 2022-10-04 04:22:55 | Fulton, Arkansas, US | |
2260254 | 2260254 | 2022-10-02 | US | Arkansas | Fulton | 5049 | 2980 | 96 | 0 | 36.38177105 | -91.81729127 | 2022-10-03 04:23:11 | Fulton, Arkansas, US | |
2995780 | 2995780 | 2022-10-01 | US | Arkansas | Fulton | 5049 | 2980 | 96 | 0 | 36.38177105 | -91.81729127 | 2022-10-02 04:21:23 | Fulton, Arkansas, US | |
854106 | 854106 | 2022-09-30 | US | Arkansas | Fulton | 5049 | 2980 | 96 | 0 | 36.38177105 | -91.81729127 | 2022-10-01 04:23:01 | Fulton, Arkansas, US | |
2017904 | 2017904 | 2022-09-20 | US | Iowa | Chickasaw | 19037 | 2980 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-21 04:23:22 | Chickasaw, Iowa, US | |
3571777 | 3571777 | 2022-09-19 | US | Iowa | Chickasaw | 19037 | 2980 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-20 04:22:48 | Chickasaw, Iowa, US | |
420516 | 420516 | 2022-09-18 | US | Iowa | Chickasaw | 19037 | 2980 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-19 04:21:49 | Chickasaw, Iowa, US | |
3374540 | 3374540 | 2022-09-17 | US | Iowa | Chickasaw | 19037 | 2980 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-18 04:22:50 | Chickasaw, Iowa, US | |
2356648 | 2356648 | 2022-09-16 | US | Iowa | Chickasaw | 19037 | 2980 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-17 04:20:19 | Chickasaw, Iowa, US | |
3988127 | 3988127 | 2022-09-15 | US | Louisiana | Catahoula | 22025 | 2980 | 59 | 0 | 31.66778967 | -91.84526385 | 2022-09-16 04:21:19 | Catahoula, Louisiana, US | |
3987805 | 3987805 | 2022-09-15 | US | Iowa | Chickasaw | 19037 | 2980 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-16 04:21:19 | Chickasaw, Iowa, US | |
1890322 | 1890322 | 2022-09-14 | US | Iowa | Chickasaw | 19037 | 2980 | 34 | 0 | 43.06001295 | -92.31773347 | 2022-09-15 04:21:02 | Chickasaw, Iowa, US | |
2637093 | 2637093 | 2022-09-05 | US | Virginia | Lunenburg | 51111 | 2980 | 42 | 0 | 36.94618528 | -78.24133319 | 2022-09-06 04:21:02 | Lunenburg, Virginia, US | |
2715715 | 2715715 | 2022-09-03 | US | Puerto Rico | Guanica | 72055 | 2980 | 0 | 0 | 17.982429 | -66.919643 | 2022-09-04 04:21:22 | Guanica, Puerto Rico, US | |
1408345 | 1408345 | 2022-08-02 | US | Virginia | Amelia | 51007 | 2980 | 59 | 0 | 37.34081025 | -77.98584649 | 2022-08-03 04:20:59 | Amelia, Virginia, US | |
2597399 | 2597399 | 2022-07-25 | US | Virginia | Lexington | 51678 | 2980 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-07-26 04:20:58 | Lexington, Virginia, US | |
3940561 | 3940561 | 2022-06-30 | US | Arkansas | Lee | 5077 | 2980 | 61 | 0 | 34.78498904 | -90.78383866 | 2022-07-01 04:21:10 | Lee, Arkansas, US | |
2240562 | 2240562 | 2022-06-28 | US | Iowa | Appanoose | 19007 | 2980 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-06-29 04:20:59 | Appanoose, Iowa, US | |
2148804 | 2148804 | 2022-06-27 | US | Iowa | Appanoose | 19007 | 2980 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-06-28 04:20:58 | Appanoose, Iowa, US | |
476605 | 476605 | 2022-06-26 | US | Iowa | Appanoose | 19007 | 2980 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-06-27 04:21:00 | Appanoose, Iowa, US | |
939980 | 939980 | 2022-06-25 | US | Iowa | Appanoose | 19007 | 2980 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-06-26 04:21:02 | Appanoose, Iowa, US | |
3347800 | 3347800 | 2022-06-24 | US | Iowa | Appanoose | 19007 | 2980 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-06-25 04:20:57 | Appanoose, Iowa, US | |
1649541 | 1649541 | 2022-06-23 | US | Iowa | Appanoose | 19007 | 2980 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-06-24 04:20:58 | Appanoose, Iowa, US | |
2188776 | 2188776 | 2022-06-22 | US | Iowa | Appanoose | 19007 | 2980 | 70 | 0 | 40.74324454 | -92.86865906 | 2022-06-23 04:20:55 | Appanoose, Iowa, US | |
169086 | 169086 | 2022-06-21 | US | Texas | Callahan | 48059 | 2980 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-06-22 04:20:54 | Callahan, Texas, US | |
3727391 | 3727391 | 2022-06-07 | US | Iowa | Cass | 19029 | 2980 | 78 | 0 | 41.33149454 | -94.92792482 | 2022-06-08 04:20:55 | Cass, Iowa, US | |
3726871 | 3726871 | 2022-06-07 | US | Colorado | Rio Grande | 8105 | 2980 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-06-08 04:20:55 | Rio Grande, Colorado, US | |
3888793 | 3888793 | 2022-06-06 | US | Iowa | Cass | 19029 | 2980 | 78 | 0 | 41.33149454 | -94.92792482 | 2022-06-07 04:21:08 | Cass, Iowa, US | |
3508562 | 3508562 | 2022-06-05 | US | Iowa | Cass | 19029 | 2980 | 78 | 0 | 41.33149454 | -94.92792482 | 2022-06-06 04:20:57 | Cass, Iowa, US | |
3528639 | 3528639 | 2022-06-04 | US | Iowa | Cass | 19029 | 2980 | 78 | 0 | 41.33149454 | -94.92792482 | 2022-06-05 04:20:55 | Cass, Iowa, US | |
3134725 | 3134725 | 2022-06-03 | US | Iowa | Cass | 19029 | 2980 | 78 | 0 | 41.33149454 | -94.92792482 | 2022-06-04 04:20:58 | Cass, Iowa, US | |
3579800 | 3579800 | 2022-06-02 | US | Iowa | Cass | 19029 | 2980 | 78 | 0 | 41.33149454 | -94.92792482 | 2022-06-03 04:20:58 | Cass, Iowa, US | |
972093 | 972093 | 2022-06-01 | US | Iowa | Cass | 19029 | 2980 | 78 | 0 | 41.33149454 | -94.92792482 | 2022-06-02 05:20:39 | Cass, Iowa, US | |
3593390 | 3593390 | 2022-05-23 | US | Alabama | Coosa | 1037 | 2980 | 58 | 0 | 32.93690146 | -86.24847739 | 2022-05-24 04:20:57 | Coosa, Alabama, US | |
1109938 | 1109938 | 2022-05-21 | US | Alabama | Coosa | 1037 | 2980 | 58 | 0 | 32.93690146 | -86.24847739 | 2022-05-22 04:20:52 | Coosa, Alabama, US | |
1169562 | 1169562 | 2022-05-20 | US | Alabama | Coosa | 1037 | 2980 | 58 | 0 | 32.93690146 | -86.24847739 | 2022-05-21 04:20:58 | Coosa, Alabama, US | |
3896325 | 3896325 | 2022-05-19 | US | Alabama | Coosa | 1037 | 2980 | 58 | 0 | 32.93690146 | -86.24847739 | 2022-05-20 04:20:57 | Coosa, Alabama, US | |
1187379 | 1187379 | 2022-05-18 | US | Oregon | Morrow | 41049 | 2980 | 34 | 0 | 45.41846568 | -119.584546 | 2022-05-19 04:20:54 | Morrow, Oregon, US | |
3585276 | 3585276 | 2022-05-17 | US | Oregon | Morrow | 41049 | 2980 | 34 | 0 | 45.41846568 | -119.584546 | 2022-05-18 04:20:50 | Morrow, Oregon, US | |
1506233 | 1506233 | 2022-05-16 | US | Oregon | Morrow | 41049 | 2980 | 34 | 0 | 45.41846568 | -119.584546 | 2022-05-17 04:20:59 | Morrow, Oregon, US | |
2086592 | 2086592 | 2022-05-15 | US | Oregon | Morrow | 41049 | 2980 | 34 | 0 | 45.41846568 | -119.584546 | 2022-05-16 04:20:47 | Morrow, Oregon, US | |
3357302 | 3357302 | 2022-05-14 | US | Oregon | Morrow | 41049 | 2980 | 34 | 0 | 45.41846568 | -119.584546 | 2022-05-15 04:20:53 | Morrow, Oregon, US | |
660947 | 660947 | 2022-05-13 | US | Oregon | Morrow | 41049 | 2980 | 34 | 0 | 45.41846568 | -119.584546 | 2022-05-14 04:20:48 | Morrow, Oregon, US | |
2536030 | 2536030 | 2022-05-12 | US | Oregon | Morrow | 41049 | 2980 | 34 | 0 | 45.41846568 | -119.584546 | 2022-05-13 04:20:51 | Morrow, Oregon, US | |
3447476 | 3447476 | 2022-05-11 | US | Oregon | Morrow | 41049 | 2980 | 34 | 0 | 45.41846568 | -119.584546 | 2022-05-12 04:20:54 | Morrow, Oregon, US | |
2894194 | 2894194 | 2022-04-21 | US | Minnesota | Watonwan | 27165 | 2980 | 23 | 0 | 43.97823903 | -94.61413846 | 2022-04-22 04:20:45 | Watonwan, Minnesota, US | |
2309066 | 2309066 | 2022-04-20 | US | Minnesota | Watonwan | 27165 | 2980 | 23 | 0 | 43.97823903 | -94.61413846 | 2022-04-21 04:20:46 | Watonwan, Minnesota, US | |
2253205 | 2253205 | 2022-04-19 | US | Minnesota | Watonwan | 27165 | 2980 | 23 | 0 | 43.97823903 | -94.61413846 | 2022-04-20 04:20:45 | Watonwan, Minnesota, US | |
1847755 | 1847755 | 2022-04-18 | US | Minnesota | Watonwan | 27165 | 2980 | 23 | 0 | 43.97823903 | -94.61413846 | 2022-04-19 04:21:00 | Watonwan, Minnesota, US | |
3323017 | 3323017 | 2022-04-07 | US | Puerto Rico | Salinas | 72123 | 2980 | 0 | 0 | 18.010386999999994 | -66.256592 | 2022-04-08 04:20:48 | Salinas, Puerto Rico, US | |
920244 | 920244 | 2022-03-08 | US | California | Mariposa | 6043 | 2980 | 28 | 0 | 37.57978556 | -119.9073334 | 2022-03-09 04:20:59 | Mariposa, California, US | |
3820921 | 3820921 | 2022-02-16 | US | Arkansas | Desha | 5041 | 2980 | 37 | 0 | 33.83011025 | -91.25500948 | 2022-02-17 04:20:56 | Desha, Arkansas, US | |
1467272 | 1467272 | 2022-02-10 | US | Texas | Nolan | 48353 | 2980 | 91 | 0 | 32.30365282 | -100.4060208 | 2022-02-11 04:21:09 | Nolan, Texas, US | |
3465905 | 3465905 | 2022-01-18 | US | Minnesota | Kanabec | 27065 | 2980 | 49 | 0 | 45.9459309 | -93.29275192 | 2022-01-19 04:21:23 | Kanabec, Minnesota, US | |
1473596 | 1473596 | 2022-01-17 | US | Kentucky | Washington | 21229 | 2980 | 53 | 0 | 37.75599461 | -85.17407732 | 2022-01-18 04:21:04 | Washington, Kentucky, US | |
556270 | 556270 | 2022-01-16 | US | Kentucky | Washington | 21229 | 2980 | 53 | 0 | 37.75599461 | -85.17407732 | 2022-01-17 04:21:08 | Washington, Kentucky, US | |
3841991 | 3841991 | 2022-01-15 | US | Kentucky | Washington | 21229 | 2980 | 53 | 0 | 37.75599461 | -85.17407732 | 2022-01-16 04:21:12 | Washington, Kentucky, US | |
100806 | 100806 | 2022-01-14 | US | Kentucky | Washington | 21229 | 2980 | 53 | 0 | 37.75599461 | -85.17407732 | 2022-01-15 04:21:07 | Washington, Kentucky, US | |
99523 | 99523 | 2022-01-14 | Russia | Chukotka Autonomous Okrug | 2980 | 39 | 0 | 66.0006475 | 169.4900869 | 2022-01-15 04:21:07 | Chukotka Autonomous Okrug, Russia | |||
3616345 | 3616345 | 2022-01-12 | US | Vermont | Addison | 50001 | 2980 | 10 | 0 | 44.03217337 | -73.14130877 | 2022-01-13 08:00:09 | Addison, Vermont, US | |
1700822 | 1700822 | 2022-01-03 | US | Arkansas | Clay | 5021 | 2980 | 77 | 0 | 36.36826212 | -90.4148172 | 2022-01-04 04:22:17 | Clay, Arkansas, US | |
731496 | 731496 | 2021-12-27 | US | Illinois | Carroll | 17015 | 2980 | 41 | 0 | 42.06823429 | -89.93395545 | 2021-12-28 04:21:47 | Carroll, Illinois, US | |
801168 | 801168 | 2021-12-22 | US | Puerto Rico | Dorado | 72051 | 2980 | 0 | 0 | 18.436115 | -66.278669 | 2021-12-23 04:21:21 | Dorado, Puerto Rico, US | |
1254580 | 1254580 | 2021-12-20 | China | Shanghai | 2980 | 7 | 0 | 31.201999999999998 | 121.4491 | 2021-12-21 03:21:27 | Shanghai, China | |||
2904864 | 2904864 | 2021-12-19 | US | Indiana | Vermillion | 18165 | 2980 | 60 | 0 | 39.8523352 | -87.46160542 | 2021-12-20 04:21:43 | Vermillion, Indiana, US | |
1259937 | 1259937 | 2021-12-18 | US | Indiana | Vermillion | 18165 | 2980 | 60 | 0 | 39.8523352 | -87.46160542 | 2021-12-19 04:21:11 | Vermillion, Indiana, US | |
2399965 | 2399965 | 2021-12-17 | US | Indiana | Vermillion | 18165 | 2980 | 60 | 0 | 39.8523352 | -87.46160542 | 2021-12-18 02:22:20 | Vermillion, Indiana, US | |
1717047 | 1717047 | 2021-12-16 | US | Florida | Dixie | 12029 | 2980 | 24 | 0 | 29.60631086 | -83.15724673 | 2021-12-17 04:22:14 | Dixie, Florida, US | |
3496881 | 3496881 | 2021-12-15 | US | Florida | Dixie | 12029 | 2980 | 24 | 0 | 29.60631086 | -83.15724673 | 2021-12-16 04:22:11 | Dixie, Florida, US | |
2088666 | 2088666 | 2021-12-14 | US | Florida | Dixie | 12029 | 2980 | 24 | 0 | 29.60631086 | -83.15724673 | 2021-12-15 03:22:16 | Dixie, Florida, US | |
783083 | 783083 | 2021-12-13 | US | Florida | Dixie | 12029 | 2980 | 24 | 0 | 29.60631086 | -83.15724673 | 2021-12-14 04:22:38 | Dixie, Florida, US | |
1661252 | 1661252 | 2021-12-12 | US | Georgia | Jeff Davis | 13161 | 2980 | 61 | 0 | 31.80405727 | -82.63724870000001 | 2021-12-13 04:22:02 | Jeff Davis, Georgia, US | |
1661118 | 1661118 | 2021-12-12 | US | Florida | Dixie | 12029 | 2980 | 24 | 0 | 29.60631086 | -83.15724673 | 2021-12-13 04:22:02 | Dixie, Florida, US | |
1665268 | 1665268 | 2021-12-11 | US | Georgia | Jeff Davis | 13161 | 2980 | 61 | 0 | 31.80405727 | -82.63724870000001 | 2021-12-12 04:22:12 | Jeff Davis, Georgia, US | |
1665134 | 1665134 | 2021-12-11 | US | Florida | Dixie | 12029 | 2980 | 24 | 0 | 29.60631086 | -83.15724673 | 2021-12-12 04:22:12 | Dixie, Florida, US | |
3656420 | 3656420 | 2021-12-10 | US | Georgia | Jeff Davis | 13161 | 2980 | 61 | 0 | 31.80405727 | -82.63724870000001 | 2021-12-11 04:22:45 | Jeff Davis, Georgia, US | |
3656286 | 3656286 | 2021-12-10 | US | Florida | Dixie | 12029 | 2980 | 24 | 0 | 29.60631086 | -83.15724673 | 2021-12-11 04:22:45 | Dixie, Florida, US | |
3940 | 3940 | 2021-12-02 | US | Wyoming | Lincoln | 56023 | 2980 | 24 | 0 | 42.26376367 | -110.6563997 | 2021-12-03 04:23:05 | Lincoln, Wyoming, US | |
1148192 | 1148192 | 2021-12-01 | US | Texas | Young | 48503 | 2980 | 72 | 0 | 33.17659707 | -98.68790885 | 2021-12-02 04:22:37 | Young, Texas, US | |
3752677 | 3752677 | 2021-11-22 | US | Wisconsin | Iowa | 55049 | 2980 | 17 | 0 | 43.00050278 | -90.13469017 | 2021-11-23 04:22:39 | Iowa, Wisconsin, US | |
3290783 | 3290783 | 2021-11-18 | US | Missouri | Andrew | 29003 | 2980 | 24 | 0 | 39.98492163 | -94.80163024 | 2021-11-19 04:21:40 | Andrew, Missouri, US | |
686206 | 686206 | 2021-11-13 | Colombia | Vichada | 2980 | 53 | 0 | 4.4234 | -69.2878 | 2021-11-14 04:21:31 | Vichada, Colombia | |||
714994 | 714994 | 2021-11-12 | US | Arkansas | Sharp | 5135 | 2980 | 71 | 0 | 36.16258158 | -91.47819342 | 2021-11-13 04:21:38 | Sharp, Arkansas, 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]);