johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
456 rows where confirmed = 1538 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331295 | 331295 | 2022-12-27 | US | Virginia | Norton | 51720 | 1538 | 21 | 0 | 36.93357076 | -82.62750411 | 2022-12-28 04:21:04 | Norton, Virginia, US | |
1152554 | 1152554 | 2022-12-12 | US | Wyoming | Crook | 56011 | 1538 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-13 04:21:01 | Crook, Wyoming, US | |
872408 | 872408 | 2022-12-11 | US | Wyoming | Crook | 56011 | 1538 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-12 04:21:01 | Crook, Wyoming, US | |
260938 | 260938 | 2022-12-10 | US | Wyoming | Crook | 56011 | 1538 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-11 04:20:50 | Crook, Wyoming, US | |
3939652 | 3939652 | 2022-12-09 | US | Wyoming | Crook | 56011 | 1538 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-10 04:21:02 | Crook, Wyoming, US | |
3380984 | 3380984 | 2022-12-08 | US | Wyoming | Crook | 56011 | 1538 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-09 04:21:05 | Crook, Wyoming, US | |
1988255 | 1988255 | 2022-12-07 | US | Wyoming | Crook | 56011 | 1538 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-08 04:21:07 | Crook, Wyoming, US | |
3717778 | 3717778 | 2022-12-06 | US | Wyoming | Crook | 56011 | 1538 | 31 | 0 | 44.58855102 | -104.5697705 | 2022-12-07 04:20:58 | Crook, Wyoming, US | |
2816571 | 2816571 | 2022-12-03 | China | Jiangxi | 1538 | 1 | 0 | 27.614 | 115.7221 | 2022-12-04 04:20:56 | Jiangxi, China | |||
833427 | 833427 | 2022-12-02 | China | Jiangxi | 1538 | 1 | 0 | 27.614 | 115.7221 | 2022-12-03 04:21:02 | Jiangxi, China | |||
2509381 | 2509381 | 2022-11-10 | US | Virginia | Charles City | 51036 | 1538 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-11-11 04:21:22 | Charles City, Virginia, US | |
1049647 | 1049647 | 2022-11-06 | China | Shanxi | 1538 | 0 | 0 | 37.5777 | 112.2922 | 2022-11-07 04:21:26 | Shanxi, China | |||
852031 | 852031 | 2022-11-02 | US | North Dakota | Sioux | 38085 | 1538 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-11-03 04:22:05 | Sioux, North Dakota, US | |
849382 | 849382 | 2022-11-02 | China | Anhui | 1538 | 6 | 0 | 31.8257 | 117.2264 | 2022-11-03 04:22:05 | Anhui, China | |||
710233 | 710233 | 2022-11-01 | China | Anhui | 1538 | 6 | 0 | 31.8257 | 117.2264 | 2022-11-02 04:22:09 | Anhui, China | |||
2017921 | 2017921 | 2022-09-20 | US | Iowa | Fremont | 19071 | 1538 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-09-21 04:23:22 | Fremont, Iowa, US | |
3571794 | 3571794 | 2022-09-19 | US | Iowa | Fremont | 19071 | 1538 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-09-20 04:22:48 | Fremont, Iowa, US | |
420533 | 420533 | 2022-09-18 | US | Iowa | Fremont | 19071 | 1538 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-09-19 04:21:49 | Fremont, Iowa, US | |
3374557 | 3374557 | 2022-09-17 | US | Iowa | Fremont | 19071 | 1538 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-09-18 04:22:50 | Fremont, Iowa, US | |
2356665 | 2356665 | 2022-09-16 | US | Iowa | Fremont | 19071 | 1538 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-09-17 04:20:19 | Fremont, Iowa, US | |
3989806 | 3989806 | 2022-09-15 | US | Texas | Mills | 48333 | 1538 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-16 04:21:19 | Mills, Texas, US | |
3987822 | 3987822 | 2022-09-15 | US | Iowa | Fremont | 19071 | 1538 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-09-16 04:21:19 | Fremont, Iowa, US | |
1892323 | 1892323 | 2022-09-14 | US | Texas | Mills | 48333 | 1538 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-09-15 04:21:02 | Mills, Texas, US | |
1890339 | 1890339 | 2022-09-14 | US | Iowa | Fremont | 19071 | 1538 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-09-15 04:21:02 | Fremont, Iowa, US | |
3952195 | 3952195 | 2022-08-17 | US | Minnesota | Big Stone | 27011 | 1538 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-18 04:21:11 | Big Stone, Minnesota, US | |
994166 | 994166 | 2022-08-16 | US | Texas | McCulloch | 48307 | 1538 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-08-17 04:20:59 | McCulloch, Texas, US | |
992697 | 992697 | 2022-08-16 | US | Minnesota | Big Stone | 27011 | 1538 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-17 04:20:59 | Big Stone, Minnesota, US | |
2495736 | 2495736 | 2022-08-15 | US | Minnesota | Big Stone | 27011 | 1538 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-16 04:20:58 | Big Stone, Minnesota, US | |
3649286 | 3649286 | 2022-08-14 | US | Minnesota | Big Stone | 27011 | 1538 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-15 04:20:59 | Big Stone, Minnesota, US | |
1970292 | 1970292 | 2022-08-13 | US | Minnesota | Big Stone | 27011 | 1538 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-14 04:20:55 | Big Stone, Minnesota, US | |
2890101 | 2890101 | 2022-08-12 | US | Minnesota | Big Stone | 27011 | 1538 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-13 04:20:52 | Big Stone, Minnesota, US | |
3909706 | 3909706 | 2022-08-11 | US | Minnesota | Big Stone | 27011 | 1538 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-12 04:20:54 | Big Stone, Minnesota, US | |
3908959 | 3908959 | 2022-08-11 | US | Idaho | Power | 16077 | 1538 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-08-12 04:20:54 | Power, Idaho, US | |
1347276 | 1347276 | 2022-08-10 | US | Idaho | Power | 16077 | 1538 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-08-11 04:20:49 | Power, Idaho, US | |
3545170 | 3545170 | 2022-08-08 | US | Michigan | Oscoda | 26135 | 1538 | 58 | 0 | 44.68192279 | -84.12939244 | 2022-08-09 04:20:34 | Oscoda, Michigan, US | |
1071573 | 1071573 | 2022-08-07 | US | Michigan | Oscoda | 26135 | 1538 | 58 | 0 | 44.68192279 | -84.12939244 | 2022-08-08 04:21:08 | Oscoda, Michigan, US | |
1942161 | 1942161 | 2022-08-06 | US | Michigan | Oscoda | 26135 | 1538 | 58 | 0 | 44.68192279 | -84.12939244 | 2022-08-07 04:20:54 | Oscoda, Michigan, US | |
881960 | 881960 | 2022-08-05 | US | Michigan | Oscoda | 26135 | 1538 | 58 | 0 | 44.68192279 | -84.12939244 | 2022-08-06 04:20:56 | Oscoda, Michigan, US | |
2010371 | 2010371 | 2022-08-04 | US | Michigan | Oscoda | 26135 | 1538 | 58 | 0 | 44.68192279 | -84.12939244 | 2022-08-05 04:20:52 | Oscoda, Michigan, US | |
1099798 | 1099798 | 2022-08-03 | US | Michigan | Oscoda | 26135 | 1538 | 58 | 0 | 44.68192279 | -84.12939244 | 2022-08-04 04:20:58 | Oscoda, Michigan, US | |
1406723 | 1406723 | 2022-08-02 | US | Michigan | Oscoda | 26135 | 1538 | 58 | 0 | 44.68192279 | -84.12939244 | 2022-08-03 04:20:59 | Oscoda, Michigan, US | |
2338921 | 2338921 | 2022-07-27 | US | West Virginia | Wirt | 54105 | 1538 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-07-28 04:20:56 | Wirt, West Virginia, US | |
2338584 | 2338584 | 2022-07-27 | US | Texas | Newton | 48351 | 1538 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-07-28 04:20:56 | Newton, Texas, US | |
2493570 | 2493570 | 2022-06-29 | US | Wisconsin | Iron | 55051 | 1538 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-06-30 04:21:01 | Iron, Wisconsin, US | |
2242952 | 2242952 | 2022-06-28 | US | Wisconsin | Iron | 55051 | 1538 | 48 | 0 | 46.26302338 | -90.24295041 | 2022-06-29 04:20:59 | Iron, Wisconsin, US | |
3271936 | 3271936 | 2022-06-19 | US | North Dakota | Ransom | 38073 | 1538 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-06-20 04:21:01 | Ransom, North Dakota, US | |
3399848 | 3399848 | 2022-06-18 | US | North Dakota | Ransom | 38073 | 1538 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-06-19 04:20:51 | Ransom, North Dakota, US | |
2313725 | 2313725 | 2022-06-17 | US | North Dakota | Ransom | 38073 | 1538 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-06-18 04:21:10 | Ransom, North Dakota, US | |
560529 | 560529 | 2022-06-16 | US | Minnesota | Grant | 27051 | 1538 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-06-17 04:20:56 | Grant, Minnesota, US | |
1423705 | 1423705 | 2022-06-08 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-09 04:20:54 | Tillman, Oklahoma, US | |
3728819 | 3728819 | 2022-06-07 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-08 04:20:55 | Tillman, Oklahoma, US | |
3890221 | 3890221 | 2022-06-06 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-07 04:21:08 | Tillman, Oklahoma, US | |
3509990 | 3509990 | 2022-06-05 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-06 04:20:57 | Tillman, Oklahoma, US | |
3530067 | 3530067 | 2022-06-04 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-05 04:20:55 | Tillman, Oklahoma, US | |
3136153 | 3136153 | 2022-06-03 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-04 04:20:58 | Tillman, Oklahoma, US | |
3581228 | 3581228 | 2022-06-02 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-03 04:20:58 | Tillman, Oklahoma, US | |
973964 | 973964 | 2022-06-01 | US | Texas | Carson | 48065 | 1538 | 36 | 0 | 35.40365929 | -101.3542669 | 2022-06-02 05:20:39 | Carson, Texas, US | |
973521 | 973521 | 2022-06-01 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-02 05:20:39 | Tillman, Oklahoma, US | |
231828 | 231828 | 2022-05-31 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-06-01 04:20:55 | Tillman, Oklahoma, US | |
3188593 | 3188593 | 2022-05-30 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-05-31 04:20:51 | Tillman, Oklahoma, US | |
3200742 | 3200742 | 2022-05-29 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-05-30 04:20:50 | Tillman, Oklahoma, US | |
2727620 | 2727620 | 2022-05-28 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-05-29 04:20:53 | Tillman, Oklahoma, US | |
1316801 | 1316801 | 2022-05-27 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-05-28 04:21:07 | Tillman, Oklahoma, US | |
1852593 | 1852593 | 2022-05-26 | US | Oklahoma | Tillman | 40141 | 1538 | 35 | 0 | 34.37288446 | -98.92426619 | 2022-05-27 04:20:56 | Tillman, Oklahoma, US | |
3002326 | 3002326 | 2022-05-24 | US | Texas | Bailey | 48017 | 1538 | 39 | 0 | 34.06854817 | -102.8299707 | 2022-05-25 04:20:56 | Bailey, Texas, US | |
3596402 | 3596402 | 2022-05-23 | US | Virginia | Mathews | 51115 | 1538 | 27 | 0 | 37.44164146 | -76.34098896 | 2022-05-24 04:20:57 | Mathews, Virginia, US | |
3897994 | 3897994 | 2022-05-19 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-20 04:20:57 | Stillwater, Montana, US | |
1186778 | 1186778 | 2022-05-18 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-19 04:20:54 | Stillwater, Montana, US | |
3584675 | 3584675 | 2022-05-17 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-18 04:20:50 | Stillwater, Montana, US | |
1505632 | 1505632 | 2022-05-16 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-17 04:20:59 | Stillwater, Montana, US | |
1504568 | 1504568 | 2022-05-16 | US | Illinois | Calhoun | 17013 | 1538 | 5 | 0 | 39.16840183 | -90.66330078 | 2022-05-17 04:20:59 | Calhoun, Illinois, US | |
2085991 | 2085991 | 2022-05-15 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-16 04:20:47 | Stillwater, Montana, US | |
3356701 | 3356701 | 2022-05-14 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-15 04:20:53 | Stillwater, Montana, US | |
660346 | 660346 | 2022-05-13 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-14 04:20:48 | Stillwater, Montana, US | |
2535429 | 2535429 | 2022-05-12 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-13 04:20:51 | Stillwater, Montana, US | |
3446875 | 3446875 | 2022-05-11 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-12 04:20:54 | Stillwater, Montana, US | |
3537492 | 3537492 | 2022-05-10 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-11 04:20:48 | Stillwater, Montana, US | |
224027 | 224027 | 2022-05-09 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-10 04:20:50 | Stillwater, Montana, US | |
2333412 | 2333412 | 2022-05-08 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-09 04:20:54 | Stillwater, Montana, US | |
362374 | 362374 | 2022-05-07 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-08 04:20:49 | Stillwater, Montana, US | |
1399725 | 1399725 | 2022-05-06 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-07 04:21:09 | Stillwater, Montana, US | |
2600080 | 2600080 | 2022-05-05 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-06 04:21:00 | Stillwater, Montana, US | |
3268239 | 3268239 | 2022-05-04 | US | Puerto Rico | Guanica | 72055 | 1538 | 0 | 0 | 17.982429 | -66.919643 | 2022-05-05 04:20:55 | Guanica, Puerto Rico, US | |
3267529 | 3267529 | 2022-05-04 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-05 04:20:55 | Stillwater, Montana, US | |
1574168 | 1574168 | 2022-05-03 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-04 04:20:59 | Stillwater, Montana, US | |
1573027 | 1573027 | 2022-05-03 | US | Georgia | Twiggs | 13289 | 1538 | 69 | 0 | 32.67435595 | -83.43078662 | 2022-05-04 04:20:59 | Twiggs, Georgia, US | |
465428 | 465428 | 2022-05-02 | US | Montana | Stillwater | 30095 | 1538 | 32 | 0 | 45.67071407 | -109.3950061 | 2022-05-03 04:21:00 | Stillwater, Montana, US | |
464287 | 464287 | 2022-05-02 | US | Georgia | Twiggs | 13289 | 1538 | 69 | 0 | 32.67435595 | -83.43078662 | 2022-05-03 04:21:00 | Twiggs, Georgia, US | |
3916926 | 3916926 | 2022-05-01 | US | Georgia | Twiggs | 13289 | 1538 | 69 | 0 | 32.67435595 | -83.43078662 | 2022-05-02 04:21:10 | Twiggs, Georgia, US | |
2841730 | 2841730 | 2022-04-30 | US | Georgia | Twiggs | 13289 | 1538 | 69 | 0 | 32.67435595 | -83.43078662 | 2022-05-01 04:20:57 | Twiggs, Georgia, US | |
1158043 | 1158043 | 2022-04-29 | US | Georgia | Twiggs | 13289 | 1538 | 69 | 0 | 32.67435595 | -83.43078662 | 2022-04-30 04:21:05 | Twiggs, Georgia, US | |
1697225 | 1697225 | 2022-04-28 | US | Georgia | Twiggs | 13289 | 1538 | 69 | 0 | 32.67435595 | -83.43078662 | 2022-04-29 04:20:59 | Twiggs, Georgia, US | |
3852708 | 3852708 | 2022-04-27 | US | Georgia | Twiggs | 13289 | 1538 | 69 | 0 | 32.67435595 | -83.43078662 | 2022-04-28 04:20:47 | Twiggs, Georgia, US | |
2480063 | 2480063 | 2022-03-30 | US | Nebraska | Keith | 31101 | 1538 | 10 | 0 | 41.19930341 | -101.66201640000001 | 2022-03-31 04:20:56 | Keith, Nebraska, US | |
1057635 | 1057635 | 2022-02-23 | China | Fujian | 1538 | 1 | 0 | 26.0789 | 117.9874 | 2022-02-24 04:21:14 | Fujian, China | |||
2450395 | 2450395 | 2022-02-22 | US | Wyoming | Weston | 56045 | 1538 | 18 | 0 | 43.83961191 | -104.56748809999999 | 2022-02-23 04:21:09 | Weston, Wyoming, US | |
1464901 | 1464901 | 2022-02-10 | US | Georgia | Hancock | 13141 | 1538 | 86 | 0 | 33.2721566 | -82.99766919 | 2022-02-11 04:21:09 | Hancock, Georgia, US | |
982114 | 982114 | 2022-02-01 | US | Texas | Marion | 48315 | 1538 | 55 | 0 | 32.79868409 | -94.35661230000001 | 2022-02-02 04:21:09 | Marion, Texas, US | |
980846 | 980846 | 2022-02-01 | US | Missouri | Daviess | 29061 | 1538 | 25 | 0 | 39.96145298 | -93.98519678 | 2022-02-02 04:21:09 | Daviess, Missouri, US | |
979785 | 979785 | 2022-02-01 | US | Georgia | Lincoln | 13181 | 1538 | 35 | 0 | 33.79201475 | -82.45024131 | 2022-02-02 04:21:09 | Lincoln, Georgia, 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]);