johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
509 rows where confirmed = 1011 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2485791 | 2485791 | 2022-11-16 | China | Guizhou | 1011 | 2 | 0 | 26.8154 | 106.8748 | 2022-11-17 04:21:11 | Guizhou, China | |||
291802 | 291802 | 2022-11-15 | China | Guizhou | 1011 | 2 | 0 | 26.8154 | 106.8748 | 2022-11-16 04:21:09 | Guizhou, China | |||
2759792 | 2759792 | 2022-10-18 | US | South Dakota | Edmunds | 46045 | 1011 | 17 | 0 | 45.41846445 | -99.21545423 | 2022-10-19 04:22:26 | Edmunds, South Dakota, US | |
2027626 | 2027626 | 2022-10-17 | US | South Dakota | Edmunds | 46045 | 1011 | 17 | 0 | 45.41846445 | -99.21545423 | 2022-10-18 04:22:42 | Edmunds, South Dakota, US | |
2162841 | 2162841 | 2022-10-16 | US | Virginia | Bath | 51017 | 1011 | 21 | 0 | 38.05852573 | -79.73912095 | 2022-10-17 04:20:31 | Bath, Virginia, US | |
2162404 | 2162404 | 2022-10-16 | US | South Dakota | Edmunds | 46045 | 1011 | 17 | 0 | 45.41846445 | -99.21545423 | 2022-10-17 04:20:31 | Edmunds, South Dakota, US | |
519038 | 519038 | 2022-10-15 | US | Virginia | Bath | 51017 | 1011 | 21 | 0 | 38.05852573 | -79.73912095 | 2022-10-16 04:22:39 | Bath, Virginia, US | |
518601 | 518601 | 2022-10-15 | US | South Dakota | Edmunds | 46045 | 1011 | 17 | 0 | 45.41846445 | -99.21545423 | 2022-10-16 04:22:39 | Edmunds, South Dakota, US | |
2036095 | 2036095 | 2022-10-14 | US | Virginia | Bath | 51017 | 1011 | 21 | 0 | 38.05852573 | -79.73912095 | 2022-10-15 04:22:00 | Bath, Virginia, US | |
2035658 | 2035658 | 2022-10-14 | US | South Dakota | Edmunds | 46045 | 1011 | 17 | 0 | 45.41846445 | -99.21545423 | 2022-10-15 04:22:00 | Edmunds, South Dakota, US | |
3756783 | 3756783 | 2022-10-13 | US | Virginia | Bath | 51017 | 1011 | 21 | 0 | 38.05852573 | -79.73912095 | 2022-10-14 04:22:28 | Bath, Virginia, US | |
3756346 | 3756346 | 2022-10-13 | US | South Dakota | Edmunds | 46045 | 1011 | 17 | 0 | 45.41846445 | -99.21545423 | 2022-10-14 04:22:28 | Edmunds, South Dakota, US | |
3217608 | 3217608 | 2022-10-12 | US | Virginia | Bath | 51017 | 1011 | 21 | 0 | 38.05852573 | -79.73912095 | 2022-10-13 04:22:39 | Bath, Virginia, US | |
3217171 | 3217171 | 2022-10-12 | US | South Dakota | Edmunds | 46045 | 1011 | 17 | 0 | 45.41846445 | -99.21545423 | 2022-10-13 04:22:39 | Edmunds, South Dakota, US | |
3253457 | 3253457 | 2022-10-11 | US | Virginia | Bath | 51017 | 1011 | 21 | 0 | 38.05852573 | -79.73912095 | 2022-10-12 04:22:51 | Bath, Virginia, US | |
131401 | 131401 | 2022-10-04 | US | Colorado | Phillips | 8095 | 1011 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-10-05 04:23:06 | Phillips, Colorado, US | |
2686348 | 2686348 | 2022-10-03 | US | Colorado | Phillips | 8095 | 1011 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-10-04 04:22:55 | Phillips, Colorado, US | |
2260415 | 2260415 | 2022-10-02 | US | Colorado | Phillips | 8095 | 1011 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-10-03 04:23:11 | Phillips, Colorado, US | |
2997534 | 2997534 | 2022-10-01 | US | New York | Hamilton | 36041 | 1011 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-10-02 04:21:23 | Hamilton, New York, US | |
2995941 | 2995941 | 2022-10-01 | US | Colorado | Phillips | 8095 | 1011 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-10-02 04:21:23 | Phillips, Colorado, US | |
855860 | 855860 | 2022-09-30 | US | New York | Hamilton | 36041 | 1011 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-10-01 04:23:01 | Hamilton, New York, US | |
854267 | 854267 | 2022-09-30 | US | Colorado | Phillips | 8095 | 1011 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-10-01 04:23:01 | Phillips, Colorado, US | |
2377786 | 2377786 | 2022-09-29 | US | New York | Hamilton | 36041 | 1011 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-30 04:23:09 | Hamilton, New York, US | |
422559 | 422559 | 2022-09-18 | US | Texas | Shackelford | 48417 | 1011 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-09-19 04:21:49 | Shackelford, Texas, US | |
3376583 | 3376583 | 2022-09-17 | US | Texas | Shackelford | 48417 | 1011 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-09-18 04:22:50 | Shackelford, Texas, US | |
2358691 | 2358691 | 2022-09-16 | US | Texas | Shackelford | 48417 | 1011 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-09-17 04:20:19 | Shackelford, Texas, US | |
3989848 | 3989848 | 2022-09-15 | US | Texas | Shackelford | 48417 | 1011 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-09-16 04:21:19 | Shackelford, Texas, US | |
1892365 | 1892365 | 2022-09-14 | US | Texas | Shackelford | 48417 | 1011 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-09-15 04:21:02 | Shackelford, Texas, US | |
375420 | 375420 | 2022-09-13 | US | Texas | Shackelford | 48417 | 1011 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-09-14 04:20:44 | Shackelford, Texas, US | |
2398022 | 2398022 | 2022-09-12 | US | Texas | Shackelford | 48417 | 1011 | 12 | 0 | 32.73587756 | -99.35401337 | 2022-09-13 04:20:57 | Shackelford, Texas, US | |
3953799 | 3953799 | 2022-08-17 | US | Virginia | Bath | 51017 | 1011 | 22 | 0 | 38.05852573 | -79.73912095 | 2022-08-18 04:21:11 | Bath, Virginia, US | |
1101425 | 1101425 | 2022-08-03 | US | Virginia | Bath | 51017 | 1011 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-08-04 04:20:58 | Bath, Virginia, US | |
1066555 | 1066555 | 2022-07-28 | US | Delaware | Unassigned | 90010 | 1011 | 0 | 0 | 39.57992638 | 0.0 | 2022-07-29 04:20:45 | Unassigned, Delaware, US | |
3210928 | 3210928 | 2022-07-18 | US | Colorado | Ouray | 8091 | 1011 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-07-19 04:20:58 | Ouray, Colorado, US | |
949223 | 949223 | 2022-06-14 | US | North Carolina | Tyrrell | 37177 | 1011 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-06-15 04:20:54 | Tyrrell, North Carolina, US | |
2981631 | 2981631 | 2022-06-13 | US | North Carolina | Tyrrell | 37177 | 1011 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-06-14 04:20:52 | Tyrrell, North Carolina, US | |
2237757 | 2237757 | 2022-06-12 | US | North Carolina | Tyrrell | 37177 | 1011 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-06-13 04:21:14 | Tyrrell, North Carolina, US | |
3143955 | 3143955 | 2022-06-11 | US | North Carolina | Tyrrell | 37177 | 1011 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-06-12 04:20:53 | Tyrrell, North Carolina, US | |
1946899 | 1946899 | 2022-06-10 | US | North Dakota | Foster | 38031 | 1011 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-06-11 04:21:01 | Foster, North Dakota, US | |
1946871 | 1946871 | 2022-06-10 | US | North Carolina | Tyrrell | 37177 | 1011 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-06-11 04:21:01 | Tyrrell, North Carolina, US | |
3160010 | 3160010 | 2022-06-09 | US | North Carolina | Tyrrell | 37177 | 1011 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-06-10 04:20:55 | Tyrrell, North Carolina, US | |
1423477 | 1423477 | 2022-06-08 | US | North Carolina | Tyrrell | 37177 | 1011 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-06-09 04:20:54 | Tyrrell, North Carolina, US | |
1422647 | 1422647 | 2022-06-08 | US | Louisiana | Unassigned | 90022 | 1011 | 0 | 0 | 32.83121059 | 0.0 | 2022-06-09 04:20:54 | Unassigned, Louisiana, US | |
3899162 | 3899162 | 2022-05-19 | US | Texas | Presidio | 48377 | 1011 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-20 04:20:57 | Presidio, Texas, US | |
465518 | 465518 | 2022-05-02 | US | Nebraska | Sheridan | 31161 | 1011 | 22 | 0 | 42.50284406 | -102.4126613 | 2022-05-03 04:21:00 | Sheridan, Nebraska, US | |
3918157 | 3918157 | 2022-05-01 | US | Nebraska | Sheridan | 31161 | 1011 | 22 | 0 | 42.50284406 | -102.4126613 | 2022-05-02 04:21:10 | Sheridan, Nebraska, US | |
2842961 | 2842961 | 2022-04-30 | US | Nebraska | Sheridan | 31161 | 1011 | 22 | 0 | 42.50284406 | -102.4126613 | 2022-05-01 04:20:57 | Sheridan, Nebraska, US | |
1159274 | 1159274 | 2022-04-29 | US | Nebraska | Sheridan | 31161 | 1011 | 22 | 0 | 42.50284406 | -102.4126613 | 2022-04-30 04:21:05 | Sheridan, Nebraska, US | |
1698456 | 1698456 | 2022-04-28 | US | Nebraska | Sheridan | 31161 | 1011 | 22 | 0 | 42.50284406 | -102.4126613 | 2022-04-29 04:20:59 | Sheridan, Nebraska, US | |
3853939 | 3853939 | 2022-04-27 | US | Nebraska | Sheridan | 31161 | 1011 | 22 | 0 | 42.50284406 | -102.4126613 | 2022-04-28 04:20:47 | Sheridan, Nebraska, US | |
1328655 | 1328655 | 2022-04-26 | US | North Dakota | LaMoure | 38045 | 1011 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-04-27 04:20:52 | LaMoure, North Dakota, US | |
1328369 | 1328369 | 2022-04-26 | US | Nebraska | Sheridan | 31161 | 1011 | 22 | 0 | 42.50284406 | -102.4126613 | 2022-04-27 04:20:52 | Sheridan, Nebraska, US | |
3724609 | 3724609 | 2022-04-25 | US | North Dakota | LaMoure | 38045 | 1011 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-04-26 04:20:51 | LaMoure, North Dakota, US | |
2253863 | 2253863 | 2022-04-19 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-20 04:20:45 | Wells, North Dakota, US | |
1848413 | 1848413 | 2022-04-18 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-19 04:21:00 | Wells, North Dakota, US | |
3419357 | 3419357 | 2022-04-17 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-18 04:21:12 | Wells, North Dakota, US | |
306306 | 306306 | 2022-04-16 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-17 04:20:59 | Wells, North Dakota, US | |
2672251 | 2672251 | 2022-04-15 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-16 04:20:48 | Wells, North Dakota, US | |
1226036 | 1226036 | 2022-04-14 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-15 04:20:57 | Wells, North Dakota, US | |
2445194 | 2445194 | 2022-04-13 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-13 23:21:06 | Wells, North Dakota, US | |
1950951 | 1950951 | 2022-04-12 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-13 04:21:03 | Wells, North Dakota, US | |
3208704 | 3208704 | 2022-04-11 | US | North Dakota | Wells | 38103 | 1011 | 12 | 0 | 47.58614526 | -99.65904998 | 2022-04-12 04:20:49 | Wells, North Dakota, US | |
3732659 | 3732659 | 2022-04-03 | US | North Dakota | Sargent | 38081 | 1011 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-04-04 04:20:51 | Sargent, North Dakota, US | |
502094 | 502094 | 2022-04-02 | US | North Dakota | Sargent | 38081 | 1011 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-04-03 04:20:48 | Sargent, North Dakota, US | |
3353079 | 3353079 | 2022-04-01 | US | North Dakota | Sargent | 38081 | 1011 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-04-02 04:20:47 | Sargent, North Dakota, US | |
1542384 | 1542384 | 2022-03-31 | US | North Dakota | Sargent | 38081 | 1011 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-04-01 04:20:28 | Sargent, North Dakota, US | |
2480397 | 2480397 | 2022-03-30 | US | North Dakota | Sargent | 38081 | 1011 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-03-31 04:20:56 | Sargent, North Dakota, US | |
3025561 | 3025561 | 2022-03-23 | US | Vermont | Grand Isle | 50013 | 1011 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-24 04:20:43 | Grand Isle, Vermont, US | |
1908483 | 1908483 | 2022-03-22 | US | Vermont | Grand Isle | 50013 | 1011 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-23 04:20:48 | Grand Isle, Vermont, US | |
3241614 | 3241614 | 2022-03-21 | US | Vermont | Grand Isle | 50013 | 1011 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-22 04:20:54 | Grand Isle, Vermont, US | |
27687 | 27687 | 2022-03-20 | US | Vermont | Grand Isle | 50013 | 1011 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-21 04:20:50 | Grand Isle, Vermont, US | |
1659697 | 1659697 | 2022-03-19 | US | Vermont | Grand Isle | 50013 | 1011 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-20 04:20:45 | Grand Isle, Vermont, US | |
339223 | 339223 | 2022-03-18 | US | Vermont | Grand Isle | 50013 | 1011 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-19 04:20:47 | Grand Isle, Vermont, US | |
697676 | 697676 | 2022-03-17 | US | Vermont | Grand Isle | 50013 | 1011 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-18 04:20:55 | Grand Isle, Vermont, US | |
2322619 | 2322619 | 2022-03-16 | US | Vermont | Grand Isle | 50013 | 1011 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-17 04:20:56 | Grand Isle, Vermont, US | |
2526313 | 2526313 | 2022-03-02 | US | Idaho | Lincoln | 16063 | 1011 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-03-03 04:21:01 | Lincoln, Idaho, US | |
2732807 | 2732807 | 2022-02-27 | China | Anhui | 1011 | 6 | 0 | 31.8257 | 117.2264 | 2022-02-28 04:21:05 | Anhui, China | |||
3045960 | 3045960 | 2022-02-26 | China | Anhui | 1011 | 6 | 0 | 31.8257 | 117.2264 | 2022-02-27 04:21:04 | Anhui, China | |||
574615 | 574615 | 2022-02-25 | China | Anhui | 1011 | 6 | 0 | 31.8257 | 117.2264 | 2022-02-26 04:21:12 | Anhui, China | |||
1511191 | 1511191 | 2022-02-24 | China | Anhui | 1011 | 6 | 0 | 31.8257 | 117.2264 | 2022-02-25 04:21:11 | Anhui, China | |||
1057632 | 1057632 | 2022-02-23 | China | Anhui | 1011 | 6 | 0 | 31.8257 | 117.2264 | 2022-02-24 04:21:14 | Anhui, China | |||
2446555 | 2446555 | 2022-02-22 | China | Anhui | 1011 | 6 | 0 | 31.8257 | 117.2264 | 2022-02-23 04:21:09 | Anhui, China | |||
3717968 | 3717968 | 2022-02-21 | China | Anhui | 1011 | 6 | 0 | 31.8257 | 117.2264 | 2022-02-22 04:21:01 | Anhui, China | |||
3672066 | 3672066 | 2022-02-15 | US | Alaska | Aleutians East | 2013 | 1011 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-02-16 04:21:10 | Aleutians East, Alaska, US | |
3671441 | 3671441 | 2022-02-15 | China | Guangxi | 1011 | 2 | 0 | 23.8298 | 108.7881 | 2022-02-16 04:21:10 | Guangxi, China | |||
2642167 | 2642167 | 2022-02-14 | US | Alaska | Aleutians East | 2013 | 1011 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-02-15 04:21:09 | Aleutians East, Alaska, US | |
234166 | 234166 | 2022-02-11 | US | Idaho | Boise | 16015 | 1011 | 13 | 0 | 43.98829931 | -115.7309284 | 2022-02-12 04:21:06 | Boise, Idaho, US | |
2476820 | 2476820 | 2022-02-03 | US | South Dakota | Deuel | 46039 | 1011 | 12 | 0 | 44.75994309 | -96.66943645 | 2022-02-04 04:21:10 | Deuel, South Dakota, US | |
2476151 | 2476151 | 2022-02-03 | US | New Mexico | Guadalupe | 35019 | 1011 | 16 | 0 | 34.86319296 | -104.790669 | 2022-02-04 04:21:10 | Guadalupe, New Mexico, US | |
461426 | 461426 | 2022-02-02 | US | Nebraska | Boone | 31011 | 1011 | 4 | 0 | 41.70759415 | -98.06737183 | 2022-02-03 04:21:21 | Boone, Nebraska, US | |
1230898 | 1230898 | 2022-01-24 | US | Vermont | Essex | 50009 | 1011 | 3 | 0 | 44.72736416 | -71.73579864 | 2022-01-25 04:21:05 | Essex, Vermont, US | |
1961322 | 1961322 | 2022-01-20 | US | Georgia | Calhoun | 13037 | 1011 | 22 | 0 | 31.53169785 | -84.62725131 | 2022-01-21 04:21:09 | Calhoun, Georgia, US | |
1473613 | 1473613 | 2022-01-17 | US | Louisiana | Cameron | 22023 | 1011 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-01-18 04:21:04 | Cameron, Louisiana, US | |
556287 | 556287 | 2022-01-16 | US | Louisiana | Cameron | 22023 | 1011 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-01-17 04:21:08 | Cameron, Louisiana, US | |
3842008 | 3842008 | 2022-01-15 | US | Louisiana | Cameron | 22023 | 1011 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-01-16 04:21:12 | Cameron, Louisiana, US | |
100823 | 100823 | 2022-01-14 | US | Louisiana | Cameron | 22023 | 1011 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-01-15 04:21:07 | Cameron, Louisiana, US | |
1284417 | 1284417 | 2022-01-05 | US | North Dakota | Sioux | 38085 | 1011 | 18 | 0 | 46.11323337 | -101.04401490000001 | 2022-01-06 04:22:09 | Sioux, North Dakota, US | |
3522146 | 3522146 | 2022-01-02 | US | Puerto Rico | Adjuntas | 72001 | 1011 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-01-03 02:22:25 | Adjuntas, Puerto Rico, US | |
1434768 | 1434768 | 2021-12-28 | US | New Mexico | Los Alamos | 35028 | 1011 | 11 | 0 | 35.86631386 | -106.31349850000001 | 2021-12-29 03:21:43 | Los Alamos, New Mexico, US | |
1434601 | 1434601 | 2021-12-28 | US | Montana | Toole | 30101 | 1011 | 21 | 0 | 48.65577551 | -111.69424140000001 | 2021-12-29 03:21:43 | Toole, Montana, 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]);