johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
277 rows where confirmed = 2665 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
543284 | 543284 | 2022-12-15 | US | Arkansas | Nevada | 5099 | 2665 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-12-16 04:21:01 | Nevada, Arkansas, US | |
311093 | 311093 | 2022-12-13 | US | Texas | Red River | 48387 | 2665 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-14 04:21:04 | Red River, Texas, US | |
1152154 | 1152154 | 2022-12-12 | US | Texas | Red River | 48387 | 2665 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-13 04:21:01 | Red River, Texas, US | |
872008 | 872008 | 2022-12-11 | US | Texas | Red River | 48387 | 2665 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-12 04:21:01 | Red River, Texas, US | |
260538 | 260538 | 2022-12-10 | US | Texas | Red River | 48387 | 2665 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-11 04:20:50 | Red River, Texas, US | |
3939252 | 3939252 | 2022-12-09 | US | Texas | Red River | 48387 | 2665 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-10 04:21:02 | Red River, Texas, US | |
3380584 | 3380584 | 2022-12-08 | US | Texas | Red River | 48387 | 2665 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-09 04:21:05 | Red River, Texas, US | |
1987855 | 1987855 | 2022-12-07 | US | Texas | Red River | 48387 | 2665 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-12-08 04:21:07 | Red River, Texas, US | |
3029627 | 3029627 | 2022-11-17 | US | Virginia | Essex | 51057 | 2665 | 40 | 0 | 37.93357639 | -76.94230311 | 2022-11-18 04:21:15 | Essex, Virginia, US | |
2433921 | 2433921 | 2022-11-09 | US | Tennessee | Perry | 47135 | 2665 | 59 | 0 | 35.63708728 | -87.86139634 | 2022-11-10 04:21:16 | Perry, Tennessee, US | |
319747 | 319747 | 2022-10-30 | China | Yunnan | 2665 | 2 | 0 | 24.974 | 101.487 | 2022-10-31 04:21:36 | Yunnan, China | |||
912007 | 912007 | 2022-10-29 | China | Jiangsu | 2665 | 0 | 0 | 32.9711 | 119.455 | 2022-10-30 04:22:14 | Jiangsu, China | |||
2971032 | 2971032 | 2022-10-10 | US | Wyoming | Washakie | 56043 | 2665 | 47 | 0 | 43.90451606 | -107.680187 | 2022-10-11 04:23:05 | Washakie, Wyoming, US | |
3101068 | 3101068 | 2022-10-09 | US | Wyoming | Washakie | 56043 | 2665 | 47 | 0 | 43.90451606 | -107.680187 | 2022-10-10 04:22:32 | Washakie, Wyoming, US | |
4006293 | 4006293 | 2022-10-08 | US | Wyoming | Washakie | 56043 | 2665 | 47 | 0 | 43.90451606 | -107.680187 | 2022-10-09 04:21:16 | Washakie, Wyoming, US | |
399890 | 399890 | 2022-10-07 | US | Wyoming | Washakie | 56043 | 2665 | 47 | 0 | 43.90451606 | -107.680187 | 2022-10-08 04:22:56 | Washakie, Wyoming, US | |
2533007 | 2533007 | 2022-10-06 | US | Wyoming | Washakie | 56043 | 2665 | 47 | 0 | 43.90451606 | -107.680187 | 2022-10-07 04:23:08 | Washakie, Wyoming, US | |
1814401 | 1814401 | 2022-10-05 | US | Wyoming | Washakie | 56043 | 2665 | 47 | 0 | 43.90451606 | -107.680187 | 2022-10-06 04:21:22 | Washakie, Wyoming, US | |
134375 | 134375 | 2022-10-04 | US | Wyoming | Washakie | 56043 | 2665 | 47 | 0 | 43.90451606 | -107.680187 | 2022-10-05 04:23:06 | Washakie, Wyoming, US | |
2772350 | 2772350 | 2022-09-26 | US | Virginia | Northampton | 51131 | 2665 | 70 | 0 | 37.34062933 | -75.87751591 | 2022-09-27 04:23:01 | Northampton, Virginia, US | |
2398220 | 2398220 | 2022-09-12 | US | Virginia | Sussex | 51183 | 2665 | 43 | 0 | 36.92432914 | -77.25791182 | 2022-09-13 04:20:57 | Sussex, Virginia, US | |
115976 | 115976 | 2022-09-06 | US | Iowa | Mitchell | 19131 | 2665 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-07 04:20:59 | Mitchell, Iowa, US | |
115277 | 115277 | 2022-09-06 | US | Arkansas | Scott | 5127 | 2665 | 45 | 0 | 34.85588887 | -94.0632176 | 2022-09-07 04:20:59 | Scott, Arkansas, US | |
2634948 | 2634948 | 2022-09-05 | US | Iowa | Mitchell | 19131 | 2665 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-06 04:21:02 | Mitchell, Iowa, US | |
2634249 | 2634249 | 2022-09-05 | US | Arkansas | Scott | 5127 | 2665 | 45 | 0 | 34.85588887 | -94.0632176 | 2022-09-06 04:21:02 | Scott, Arkansas, US | |
2988512 | 2988512 | 2022-09-04 | US | Iowa | Mitchell | 19131 | 2665 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-05 04:21:01 | Mitchell, Iowa, US | |
2987813 | 2987813 | 2022-09-04 | US | Arkansas | Scott | 5127 | 2665 | 45 | 0 | 34.85588887 | -94.0632176 | 2022-09-05 04:21:01 | Scott, Arkansas, US | |
2714197 | 2714197 | 2022-09-03 | US | Iowa | Mitchell | 19131 | 2665 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-04 04:21:22 | Mitchell, Iowa, US | |
2713498 | 2713498 | 2022-09-03 | US | Arkansas | Scott | 5127 | 2665 | 45 | 0 | 34.85588887 | -94.0632176 | 2022-09-04 04:21:22 | Scott, Arkansas, US | |
1394902 | 1394902 | 2022-09-02 | US | Iowa | Mitchell | 19131 | 2665 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-03 04:21:04 | Mitchell, Iowa, US | |
3548731 | 3548731 | 2022-09-01 | US | Iowa | Mitchell | 19131 | 2665 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-02 04:21:07 | Mitchell, Iowa, US | |
2344651 | 2344651 | 2022-08-31 | US | Iowa | Mitchell | 19131 | 2665 | 49 | 0 | 43.35638371 | -92.78887719 | 2022-09-01 04:21:03 | Mitchell, Iowa, US | |
1683265 | 1683265 | 2022-08-29 | US | Puerto Rico | Maunabo | 72095 | 2665 | 0 | 0 | 18.017889 | -65.922235 | 2022-08-30 04:21:03 | Maunabo, Puerto Rico, US | |
3953885 | 3953885 | 2022-08-17 | US | Virginia | Poquoson | 51735 | 2665 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-08-18 04:21:11 | Poquoson, Virginia, US | |
1070963 | 1070963 | 2022-08-07 | US | Indiana | Benton | 18007 | 2665 | 23 | 0 | 40.60626947 | -87.31093999 | 2022-08-08 04:21:08 | Benton, Indiana, US | |
1941551 | 1941551 | 2022-08-06 | US | Indiana | Benton | 18007 | 2665 | 23 | 0 | 40.60626947 | -87.31093999 | 2022-08-07 04:20:54 | Benton, Indiana, US | |
881350 | 881350 | 2022-08-05 | US | Indiana | Benton | 18007 | 2665 | 23 | 0 | 40.60626947 | -87.31093999 | 2022-08-06 04:20:56 | Benton, Indiana, US | |
2338768 | 2338768 | 2022-07-27 | US | Virginia | Madison | 51113 | 2665 | 43 | 0 | 38.41531222 | -78.28220331 | 2022-07-28 04:20:56 | Madison, Virginia, US | |
2338580 | 2338580 | 2022-07-27 | US | Texas | Morris | 48343 | 2665 | 74 | 0 | 33.11304005 | -94.73255695 | 2022-07-28 04:20:56 | Morris, Texas, US | |
1417760 | 1417760 | 2022-07-08 | US | Connecticut | Unassigned | 90009 | 2665 | 2 | 0 | 41.85853803 | 0.0 | 2022-07-09 04:20:59 | Unassigned, Connecticut, US | |
3967068 | 3967068 | 2022-07-05 | US | Arkansas | Pike | 5109 | 2665 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-06 04:20:58 | Pike, Arkansas, US | |
3078579 | 3078579 | 2022-07-04 | US | Arkansas | Pike | 5109 | 2665 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-05 04:20:45 | Pike, Arkansas, US | |
1767861 | 1767861 | 2022-07-03 | US | Arkansas | Pike | 5109 | 2665 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-04 04:20:54 | Pike, Arkansas, US | |
3365847 | 3365847 | 2022-07-02 | US | Arkansas | Pike | 5109 | 2665 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-03 04:20:59 | Pike, Arkansas, US | |
594176 | 594176 | 2022-07-01 | US | Arkansas | Pike | 5109 | 2665 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-07-02 04:21:16 | Pike, Arkansas, US | |
3943461 | 3943461 | 2022-06-30 | US | Virginia | Richmond | 51159 | 2665 | 25 | 0 | 37.937575 | -76.72920628 | 2022-07-01 04:21:10 | Richmond, Virginia, US | |
2493419 | 2493419 | 2022-06-29 | US | Virginia | Richmond | 51159 | 2665 | 25 | 0 | 37.937575 | -76.72920628 | 2022-06-30 04:21:01 | Richmond, Virginia, US | |
2188019 | 2188019 | 2022-06-22 | US | Alabama | Sumter | 1119 | 2665 | 52 | 0 | 32.59117397 | -88.19916205 | 2022-06-23 04:20:55 | Sumter, Alabama, US | |
169364 | 169364 | 2022-06-21 | US | Virginia | Charlotte | 51037 | 2665 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-06-22 04:20:54 | Charlotte, Virginia, US | |
1766647 | 1766647 | 2022-06-20 | US | Virginia | Charlotte | 51037 | 2665 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-06-21 04:20:56 | Charlotte, Virginia, US | |
3272858 | 3272858 | 2022-06-19 | US | Virginia | Galax | 51640 | 2665 | 78 | 0 | 36.66601852 | -80.91703124 | 2022-06-20 04:21:01 | Galax, Virginia, US | |
3400770 | 3400770 | 2022-06-18 | US | Virginia | Galax | 51640 | 2665 | 78 | 0 | 36.66601852 | -80.91703124 | 2022-06-19 04:20:51 | Galax, Virginia, US | |
2314647 | 2314647 | 2022-06-17 | US | Virginia | Galax | 51640 | 2665 | 78 | 0 | 36.66601852 | -80.91703124 | 2022-06-18 04:21:10 | Galax, Virginia, US | |
2236830 | 2236830 | 2022-06-12 | US | Kentucky | McLean | 21149 | 2665 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-06-13 04:21:14 | McLean, Kentucky, US | |
3143028 | 3143028 | 2022-06-11 | US | Kentucky | McLean | 21149 | 2665 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-06-12 04:20:53 | McLean, Kentucky, US | |
1945944 | 1945944 | 2022-06-10 | US | Kentucky | McLean | 21149 | 2665 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-06-11 04:21:01 | McLean, Kentucky, US | |
3159083 | 3159083 | 2022-06-09 | US | Kentucky | McLean | 21149 | 2665 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-06-10 04:20:55 | McLean, Kentucky, US | |
1424442 | 1424442 | 2022-06-08 | US | Virginia | Floyd | 51063 | 2665 | 49 | 0 | 36.9302126 | -80.36738849 | 2022-06-09 04:20:54 | Floyd, Virginia, US | |
1422550 | 1422550 | 2022-06-08 | US | Kentucky | McLean | 21149 | 2665 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-06-09 04:20:54 | McLean, Kentucky, US | |
3727664 | 3727664 | 2022-06-07 | US | Kentucky | McLean | 21149 | 2665 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-06-08 04:20:55 | McLean, Kentucky, US | |
3889066 | 3889066 | 2022-06-06 | US | Kentucky | McLean | 21149 | 2665 | 54 | 0 | 37.5301951 | -87.26803443 | 2022-06-07 04:21:08 | McLean, Kentucky, US | |
1110535 | 1110535 | 2022-05-21 | US | Idaho | Valley | 16085 | 2665 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-05-22 04:20:52 | Valley, Idaho, US | |
1170159 | 1170159 | 2022-05-20 | US | Idaho | Valley | 16085 | 2665 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-05-21 04:20:58 | Valley, Idaho, US | |
3446614 | 3446614 | 2022-05-11 | US | Minnesota | Stevens | 27149 | 2665 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-05-12 04:20:54 | Stevens, Minnesota, US | |
3537231 | 3537231 | 2022-05-10 | US | Minnesota | Stevens | 27149 | 2665 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-05-11 04:20:48 | Stevens, Minnesota, US | |
2843593 | 2843593 | 2022-04-30 | US | Puerto Rico | Lajas | 72079 | 2665 | 0 | 0 | 18.011661 | -67.040585 | 2022-05-01 04:20:57 | Lajas, Puerto Rico, US | |
2319819 | 2319819 | 2022-03-16 | US | Arkansas | Fulton | 5049 | 2665 | 87 | 0 | 36.38177105 | -91.81729127 | 2022-03-17 04:20:56 | Fulton, Arkansas, US | |
2264847 | 2264847 | 2022-03-14 | US | Idaho | Shoshone | 16079 | 2665 | 75 | 0 | 47.35364087 | -115.89167490000001 | 2022-03-15 04:20:47 | Shoshone, Idaho, US | |
946380 | 946380 | 2022-02-28 | US | Wisconsin | Forest | 55041 | 2665 | 50 | 0 | 45.66678019 | -88.77084892 | 2022-03-01 04:21:09 | Forest, Wisconsin, US | |
2734983 | 2734983 | 2022-02-27 | US | Missouri | Ripley | 29181 | 2665 | 58 | 0 | 36.65460667 | -90.85990261 | 2022-02-28 04:21:05 | Ripley, Missouri, US | |
2734025 | 2734025 | 2022-02-27 | US | Illinois | Jasper | 17079 | 2665 | 26 | 0 | 39.01054275 | -88.15437049 | 2022-02-28 04:21:05 | Jasper, Illinois, US | |
3048136 | 3048136 | 2022-02-26 | US | Missouri | Ripley | 29181 | 2665 | 58 | 0 | 36.65460667 | -90.85990261 | 2022-02-27 04:21:04 | Ripley, Missouri, US | |
3047178 | 3047178 | 2022-02-26 | US | Illinois | Jasper | 17079 | 2665 | 26 | 0 | 39.01054275 | -88.15437049 | 2022-02-27 04:21:04 | Jasper, Illinois, US | |
576791 | 576791 | 2022-02-25 | US | Missouri | Ripley | 29181 | 2665 | 58 | 0 | 36.65460667 | -90.85990261 | 2022-02-26 04:21:12 | Ripley, Missouri, US | |
575833 | 575833 | 2022-02-25 | US | Illinois | Jasper | 17079 | 2665 | 26 | 0 | 39.01054275 | -88.15437049 | 2022-02-26 04:21:12 | Jasper, Illinois, US | |
1514477 | 1514477 | 2022-02-24 | US | Texas | Dawson | 48115 | 2665 | 93 | 0 | 32.74255572 | -101.94772420000001 | 2022-02-25 04:21:11 | Dawson, Texas, US | |
1512673 | 1512673 | 2022-02-24 | US | Kansas | Brown | 20013 | 2665 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-25 04:21:11 | Brown, Kansas, US | |
1060918 | 1060918 | 2022-02-23 | US | Texas | Dawson | 48115 | 2665 | 93 | 0 | 32.74255572 | -101.94772420000001 | 2022-02-24 04:21:14 | Dawson, Texas, US | |
1059114 | 1059114 | 2022-02-23 | US | Kansas | Brown | 20013 | 2665 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-24 04:21:14 | Brown, Kansas, US | |
2449841 | 2449841 | 2022-02-22 | US | Texas | Dawson | 48115 | 2665 | 93 | 0 | 32.74255572 | -101.94772420000001 | 2022-02-23 04:21:09 | Dawson, Texas, US | |
2448037 | 2448037 | 2022-02-22 | US | Kansas | Brown | 20013 | 2665 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-23 04:21:09 | Brown, Kansas, US | |
3721254 | 3721254 | 2022-02-21 | US | Texas | Dawson | 48115 | 2665 | 93 | 0 | 32.74255572 | -101.94772420000001 | 2022-02-22 04:21:01 | Dawson, Texas, US | |
3719450 | 3719450 | 2022-02-21 | US | Kansas | Brown | 20013 | 2665 | 47 | 0 | 39.82652589 | -95.56421698 | 2022-02-22 04:21:01 | Brown, Kansas, US | |
3915088 | 3915088 | 2022-02-20 | US | Texas | Dawson | 48115 | 2665 | 93 | 0 | 32.74255572 | -101.94772420000001 | 2022-02-21 04:21:05 | Dawson, Texas, US | |
3878646 | 3878646 | 2022-02-19 | US | Texas | Dawson | 48115 | 2665 | 93 | 0 | 32.74255572 | -101.94772420000001 | 2022-02-20 04:21:00 | Dawson, Texas, US | |
3858795 | 3858795 | 2022-02-18 | US | Tennessee | Lake | 47095 | 2665 | 38 | 0 | 36.34180170000001 | -89.48921915 | 2022-02-19 04:21:11 | Lake, Tennessee, US | |
3820475 | 3820475 | 2022-02-16 | Kiribati | 2665 | 8 | 0 | -3.3704 | -168.734 | 2022-02-17 04:20:56 | Kiribati | ||||
3671689 | 3671689 | 2022-02-15 | Kiribati | 2665 | 8 | 0 | -3.3704 | -168.734 | 2022-02-16 04:21:10 | Kiribati | ||||
2645268 | 2645268 | 2022-02-14 | US | West Virginia | Summers | 54089 | 2665 | 46 | 0 | 37.65390597 | -80.86009693 | 2022-02-15 04:21:09 | Summers, West Virginia, US | |
3301758 | 3301758 | 2022-01-30 | US | Louisiana | West Feliciana | 22125 | 2665 | 41 | 0 | 30.87882871 | -91.41485379999999 | 2022-01-31 04:21:09 | West Feliciana, Louisiana, US | |
3063549 | 3063549 | 2022-01-29 | US | Louisiana | West Feliciana | 22125 | 2665 | 41 | 0 | 30.87882871 | -91.41485379999999 | 2022-01-30 04:21:26 | West Feliciana, Louisiana, US | |
3811483 | 3811483 | 2022-01-28 | US | Louisiana | West Feliciana | 22125 | 2665 | 41 | 0 | 30.87882871 | -91.41485379999999 | 2022-01-29 04:21:10 | West Feliciana, Louisiana, US | |
1230229 | 1230229 | 2022-01-24 | US | Oregon | Curry | 41015 | 2665 | 41 | 0 | 42.45911325 | -124.15728200000001 | 2022-01-25 04:21:05 | Curry, Oregon, US | |
1142717 | 1142717 | 2022-01-23 | US | Mississippi | Greene | 28041 | 2665 | 50 | 0 | 31.21444233 | -88.63922281 | 2022-01-24 04:21:12 | Greene, Mississippi, US | |
2834635 | 2834635 | 2022-01-22 | US | Mississippi | Greene | 28041 | 2665 | 50 | 0 | 31.21444233 | -88.63922281 | 2022-01-23 04:21:13 | Greene, Mississippi, US | |
3426753 | 3426753 | 2022-01-21 | US | Mississippi | Greene | 28041 | 2665 | 50 | 0 | 31.21444233 | -88.63922281 | 2022-01-22 04:21:13 | Greene, Mississippi, US | |
3229639 | 3229639 | 2022-01-19 | US | Texas | Nolan | 48353 | 2665 | 86 | 0 | 32.30365282 | -100.4060208 | 2022-01-20 04:21:07 | Nolan, Texas, US | |
1472762 | 1472762 | 2022-01-17 | US | Colorado | Park | 8093 | 2665 | 18 | 0 | 39.120926000000004 | -105.7182065 | 2022-01-18 04:21:04 | Park, Colorado, US | |
130309 | 130309 | 2022-01-09 | US | Wisconsin | Price | 55099 | 2665 | 23 | 0 | 45.68051754 | -90.36098879999999 | 2022-01-10 04:22:07 | Price, Wisconsin, US | |
1219144 | 1219144 | 2022-01-08 | US | Wisconsin | Price | 55099 | 2665 | 23 | 0 | 45.68051754 | -90.36098879999999 | 2022-01-09 04:21:46 | Price, Wisconsin, 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]);