johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
516 rows where confirmed = 953 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1630587 | 1630587 | 2022-12-18 | US | New York | Unassigned | 90036 | 953 | 2 | 0 | 44.74530905 | 0.0 | 2022-12-19 04:21:03 | Unassigned, New York, US | |
505966 | 505966 | 2022-12-17 | US | New York | Unassigned | 90036 | 953 | 2 | 0 | 44.74530905 | 0.0 | 2022-12-18 04:21:03 | Unassigned, New York, US | |
3326538 | 3326538 | 2022-12-16 | US | New York | Unassigned | 90036 | 953 | 2 | 0 | 44.74530905 | 0.0 | 2022-12-17 04:21:04 | Unassigned, New York, US | |
3599251 | 3599251 | 2022-11-14 | US | New Mexico | Mora | 35033 | 953 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-11-15 04:21:16 | Mora, New Mexico, US | |
2433490 | 2433490 | 2022-11-09 | US | Oklahoma | Ellis | 40045 | 953 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-11-10 04:21:16 | Ellis, Oklahoma, US | |
482146 | 482146 | 2022-11-08 | US | Oklahoma | Ellis | 40045 | 953 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-11-09 04:21:22 | Ellis, Oklahoma, US | |
2441296 | 2441296 | 2022-11-07 | US | Oklahoma | Ellis | 40045 | 953 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-11-08 04:21:21 | Ellis, Oklahoma, US | |
1052394 | 1052394 | 2022-11-06 | US | Oklahoma | Ellis | 40045 | 953 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-11-07 04:21:26 | Ellis, Oklahoma, US | |
620418 | 620418 | 2022-11-05 | US | Oklahoma | Ellis | 40045 | 953 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-11-06 04:21:24 | Ellis, Oklahoma, US | |
1024922 | 1024922 | 2022-11-04 | US | Oklahoma | Ellis | 40045 | 953 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-11-05 04:21:52 | Ellis, Oklahoma, US | |
1022156 | 1022156 | 2022-11-04 | China | Guizhou | 953 | 2 | 0 | 26.8154 | 106.8748 | 2022-11-05 04:21:52 | Guizhou, China | |||
433913 | 433913 | 2022-11-03 | US | Oklahoma | Ellis | 40045 | 953 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-11-04 04:22:11 | Ellis, Oklahoma, US | |
3768931 | 3768931 | 2022-09-11 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-12 04:20:58 | Cochran, Texas, US | |
3827506 | 3827506 | 2022-09-10 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-11 04:20:50 | Cochran, Texas, US | |
965963 | 965963 | 2022-09-09 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-10 04:21:10 | Cochran, Texas, US | |
256365 | 256365 | 2022-09-08 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-09 04:21:11 | Cochran, Texas, US | |
3748163 | 3748163 | 2022-09-07 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-08 04:21:02 | Cochran, Texas, US | |
117803 | 117803 | 2022-09-06 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-07 04:20:59 | Cochran, Texas, US | |
2636775 | 2636775 | 2022-09-05 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-06 04:21:02 | Cochran, Texas, US | |
2990339 | 2990339 | 2022-09-04 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-05 04:21:01 | Cochran, Texas, US | |
2716024 | 2716024 | 2022-09-03 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-04 04:21:22 | Cochran, Texas, US | |
1396729 | 1396729 | 2022-09-02 | US | Texas | Cochran | 48079 | 953 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-09-03 04:21:04 | Cochran, Texas, US | |
1877590 | 1877590 | 2022-08-28 | US | Colorado | Baca | 8009 | 953 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-08-29 04:21:06 | Baca, Colorado, US | |
2096717 | 2096717 | 2022-08-27 | US | Colorado | Baca | 8009 | 953 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-08-28 04:21:02 | Baca, Colorado, US | |
1532532 | 1532532 | 2022-08-26 | US | Colorado | Baca | 8009 | 953 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-08-27 04:20:57 | Baca, Colorado, US | |
595900 | 595900 | 2022-07-01 | US | New York | Hamilton | 36041 | 953 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-07-02 04:21:16 | Hamilton, New York, US | |
3942301 | 3942301 | 2022-06-30 | US | New York | Hamilton | 36041 | 953 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-07-01 04:21:10 | Hamilton, New York, US | |
1766634 | 1766634 | 2022-06-20 | US | Virginia | Bath | 51017 | 953 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-06-21 04:20:56 | Bath, Virginia, US | |
232017 | 232017 | 2022-05-31 | US | Puerto Rico | Vieques | 72147 | 953 | 0 | 0 | 18.123276 | -65.440971 | 2022-06-01 04:20:55 | Vieques, Puerto Rico, US | |
1186505 | 1186505 | 2022-05-18 | US | Minnesota | Red Lake | 27125 | 953 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-05-19 04:20:54 | Red Lake, Minnesota, US | |
3584402 | 3584402 | 2022-05-17 | US | Minnesota | Red Lake | 27125 | 953 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-05-18 04:20:50 | Red Lake, Minnesota, US | |
1505359 | 1505359 | 2022-05-16 | US | Minnesota | Red Lake | 27125 | 953 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-05-17 04:20:59 | Red Lake, Minnesota, US | |
2085806 | 2085806 | 2022-05-15 | US | Mississippi | Sharkey | 28125 | 953 | 26 | 0 | 32.88149103 | -90.8159538 | 2022-05-16 04:20:47 | Sharkey, Mississippi, US | |
2085718 | 2085718 | 2022-05-15 | US | Minnesota | Red Lake | 27125 | 953 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-05-16 04:20:47 | Red Lake, Minnesota, US | |
3356516 | 3356516 | 2022-05-14 | US | Mississippi | Sharkey | 28125 | 953 | 26 | 0 | 32.88149103 | -90.8159538 | 2022-05-15 04:20:53 | Sharkey, Mississippi, US | |
3356428 | 3356428 | 2022-05-14 | US | Minnesota | Red Lake | 27125 | 953 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-05-15 04:20:53 | Red Lake, Minnesota, US | |
660161 | 660161 | 2022-05-13 | US | Mississippi | Sharkey | 28125 | 953 | 26 | 0 | 32.88149103 | -90.8159538 | 2022-05-14 04:20:48 | Sharkey, Mississippi, US | |
660073 | 660073 | 2022-05-13 | US | Minnesota | Red Lake | 27125 | 953 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-05-14 04:20:48 | Red Lake, Minnesota, US | |
2535244 | 2535244 | 2022-05-12 | US | Mississippi | Sharkey | 28125 | 953 | 26 | 0 | 32.88149103 | -90.8159538 | 2022-05-13 04:20:51 | Sharkey, Mississippi, US | |
3446690 | 3446690 | 2022-05-11 | US | Mississippi | Sharkey | 28125 | 953 | 26 | 0 | 32.88149103 | -90.8159538 | 2022-05-12 04:20:54 | Sharkey, Mississippi, US | |
3537307 | 3537307 | 2022-05-10 | US | Mississippi | Sharkey | 28125 | 953 | 26 | 0 | 32.88149103 | -90.8159538 | 2022-05-11 04:20:48 | Sharkey, Mississippi, US | |
223842 | 223842 | 2022-05-09 | US | Mississippi | Sharkey | 28125 | 953 | 26 | 0 | 32.88149103 | -90.8159538 | 2022-05-10 04:20:50 | Sharkey, Mississippi, US | |
1469138 | 1469138 | 2022-03-24 | US | Illinois | Pope | 17151 | 953 | 8 | 0 | 37.41391284 | -88.56152109 | 2022-03-25 04:20:46 | Pope, Illinois, US | |
3023312 | 3023312 | 2022-03-23 | US | Illinois | Pope | 17151 | 953 | 8 | 0 | 37.41391284 | -88.56152109 | 2022-03-24 04:20:43 | Pope, Illinois, US | |
261953 | 261953 | 2022-03-15 | US | Alaska | Copper River | 2066 | 953 | 8 | 0 | 60.3886 | -162.8905196 | 2022-03-16 04:20:50 | Copper River, Alaska, US | |
2264312 | 2264312 | 2022-03-14 | US | Alaska | Copper River | 2066 | 953 | 8 | 0 | 60.3886 | -162.8905196 | 2022-03-15 04:20:47 | Copper River, Alaska, US | |
3628378 | 3628378 | 2022-03-13 | US | Alaska | Copper River | 2066 | 953 | 8 | 0 | 60.3886 | -162.8905196 | 2022-03-14 04:20:46 | Copper River, Alaska, US | |
951286 | 951286 | 2022-03-12 | US | Alaska | Copper River | 2066 | 953 | 8 | 0 | 60.3886 | -162.8905196 | 2022-03-13 04:20:49 | Copper River, Alaska, US | |
356747 | 356747 | 2022-03-11 | US | Alaska | Copper River | 2066 | 953 | 8 | 0 | 60.3886 | -162.8905196 | 2022-03-12 04:20:50 | Copper River, Alaska, US | |
944753 | 944753 | 2022-02-28 | US | Missouri | Knox | 29103 | 953 | 12 | 0 | 40.12699751 | -92.14780832 | 2022-03-01 04:21:09 | Knox, Missouri, US | |
3720330 | 3720330 | 2022-02-21 | US | Nevada | Lincoln | 32017 | 953 | 5 | 0 | 37.64268459 | -114.8790388 | 2022-02-22 04:21:01 | Lincoln, Nevada, US | |
3914164 | 3914164 | 2022-02-20 | US | Nevada | Lincoln | 32017 | 953 | 5 | 0 | 37.64268459 | -114.8790388 | 2022-02-21 04:21:05 | Lincoln, Nevada, US | |
3877722 | 3877722 | 2022-02-19 | US | Nevada | Lincoln | 32017 | 953 | 5 | 0 | 37.64268459 | -114.8790388 | 2022-02-20 04:21:00 | Lincoln, Nevada, US | |
3857978 | 3857978 | 2022-02-18 | US | Nevada | Lincoln | 32017 | 953 | 5 | 0 | 37.64268459 | -114.8790388 | 2022-02-19 04:21:11 | Lincoln, Nevada, US | |
1300197 | 1300197 | 2022-02-17 | US | Nevada | Lincoln | 32017 | 953 | 5 | 0 | 37.64268459 | -114.8790388 | 2022-02-18 04:21:04 | Lincoln, Nevada, US | |
1300044 | 1300044 | 2022-02-17 | US | Montana | Chouteau | 30015 | 953 | 14 | 0 | 47.88084126 | -110.4353362 | 2022-02-18 04:21:04 | Chouteau, Montana, US | |
2644953 | 2644953 | 2022-02-14 | US | Texas | Presidio | 48377 | 953 | 33 | 0 | 29.99954402 | -104.24080790000001 | 2022-02-15 04:21:09 | Presidio, Texas, US | |
187747 | 187747 | 2022-02-13 | US | Michigan | Ontonagon | 26131 | 953 | 35 | 0 | 46.665226200000006 | -89.31390481 | 2022-02-14 04:20:51 | Ontonagon, Michigan, US | |
317593 | 317593 | 2022-02-12 | US | Michigan | Ontonagon | 26131 | 953 | 35 | 0 | 46.665226200000006 | -89.31390481 | 2022-02-13 04:21:00 | Ontonagon, Michigan, US | |
236368 | 236368 | 2022-02-11 | US | Texas | Hudspeth | 48229 | 953 | 16 | 0 | 31.45628381 | -105.388178 | 2022-02-12 04:21:06 | Hudspeth, Texas, US | |
234919 | 234919 | 2022-02-11 | US | Michigan | Ontonagon | 26131 | 953 | 35 | 0 | 46.665226200000006 | -89.31390481 | 2022-02-12 04:21:06 | Ontonagon, Michigan, US | |
1364753 | 1364753 | 2022-02-08 | US | North Dakota | Foster | 38031 | 953 | 20 | 0 | 47.457108399999996 | -98.88279923 | 2022-02-09 04:21:04 | Foster, North Dakota, US | |
2473839 | 2473839 | 2022-02-03 | France | Saint Pierre and Miquelon | 953 | 1 | 0 | 46.8852 | -56.3159 | 2022-02-04 04:21:10 | Saint Pierre and Miquelon, France | |||
460922 | 460922 | 2022-02-02 | US | Louisiana | Unassigned | 90022 | 953 | 0 | 0 | 32.83121059 | 0.0 | 2022-02-03 04:21:21 | Unassigned, Louisiana, US | |
980491 | 980491 | 2022-02-01 | US | Louisiana | Unassigned | 90022 | 953 | 0 | 0 | 32.83121059 | 0.0 | 2022-02-02 04:21:09 | Unassigned, Louisiana, US | |
1781401 | 1781401 | 2022-01-27 | US | Montana | Mineral | 30061 | 953 | 15 | 0 | 47.15283992 | -115.00152390000001 | 2022-01-28 04:21:09 | Mineral, Montana, US | |
2053793 | 2053793 | 2022-01-25 | US | Missouri | Holt | 29087 | 953 | 25 | 0 | 40.09799248 | -95.21638879999999 | 2022-01-26 04:21:07 | Holt, Missouri, US | |
1228537 | 1228537 | 2022-01-24 | US | Idaho | Boise | 16015 | 953 | 11 | 0 | 43.98829931 | -115.7309284 | 2022-01-25 04:21:05 | Boise, Idaho, US | |
1962603 | 1962603 | 2022-01-20 | US | Nebraska | Boone | 31011 | 953 | 4 | 0 | 41.70759415 | -98.06737183 | 2022-01-21 04:21:09 | Boone, Nebraska, US | |
3466596 | 3466596 | 2022-01-18 | US | North Dakota | Pierce | 38069 | 953 | 29 | 0 | 48.24977025 | -99.96407787 | 2022-01-19 04:21:23 | Pierce, North Dakota, US | |
556856 | 556856 | 2022-01-16 | US | Nebraska | Dixon | 31051 | 953 | 9 | 0 | 42.49188363 | -96.86782408 | 2022-01-17 04:21:08 | Dixon, Nebraska, US | |
3842577 | 3842577 | 2022-01-15 | US | Nebraska | Dixon | 31051 | 953 | 9 | 0 | 42.49188363 | -96.86782408 | 2022-01-16 04:21:12 | Dixon, Nebraska, US | |
101392 | 101392 | 2022-01-14 | US | Nebraska | Dixon | 31051 | 953 | 9 | 0 | 42.49188363 | -96.86782408 | 2022-01-15 04:21:07 | Dixon, Nebraska, US | |
3616392 | 3616392 | 2022-01-12 | US | Virginia | Cumberland | 51049 | 953 | 19 | 0 | 37.51328851 | -78.24398086 | 2022-01-13 08:00:09 | Cumberland, Virginia, US | |
1114552 | 1114552 | 2022-01-11 | US | Illinois | Alexander | 17003 | 953 | 13 | 0 | 37.18049267 | -89.32910838 | 2022-01-12 04:21:44 | Alexander, Illinois, US | |
1695350 | 1695350 | 2022-01-10 | US | Texas | Brewster | 48043 | 953 | 24 | 0 | 29.81008251 | -103.25203259999999 | 2022-01-11 04:22:01 | Brewster, Texas, US | |
1702452 | 1702452 | 2022-01-03 | US | Nebraska | Morrill | 31123 | 953 | 7 | 0 | 41.71711774 | -103.0061405 | 2022-01-04 04:22:17 | Morrill, Nebraska, US | |
1702086 | 1702086 | 2022-01-03 | US | Minnesota | Lincoln | 27081 | 953 | 5 | 0 | 44.41311883 | -96.26688165 | 2022-01-04 04:22:17 | Lincoln, Minnesota, US | |
1435820 | 1435820 | 2021-12-28 | US | Texas | Wheeler | 48483 | 953 | 15 | 0 | 35.40114335 | -100.26995140000001 | 2021-12-29 03:21:43 | Wheeler, Texas, US | |
1432981 | 1432981 | 2021-12-28 | US | Alaska | Aleutians West | 2016 | 953 | 2 | 0 | 52.3233 | -174.1596 | 2021-12-29 03:21:43 | Aleutians West, Alaska, US | |
730942 | 730942 | 2021-12-27 | US | Alaska | Aleutians West | 2016 | 953 | 2 | 0 | 52.3233 | -174.1596 | 2021-12-28 04:21:47 | Aleutians West, Alaska, US | |
801525 | 801525 | 2021-12-22 | US | Texas | Garza | 48169 | 953 | 25 | 0 | 33.17969345 | -101.2984114 | 2021-12-23 04:21:21 | Garza, Texas, US | |
3831565 | 3831565 | 2021-12-21 | US | Texas | Garza | 48169 | 953 | 25 | 0 | 33.17969345 | -101.2984114 | 2021-12-22 04:21:54 | Garza, Texas, US | |
1719251 | 1719251 | 2021-12-16 | US | South Dakota | Moody | 46101 | 953 | 24 | 0 | 44.02266214 | -96.67081159 | 2021-12-17 04:22:14 | Moody, South Dakota, US | |
3499096 | 3499096 | 2021-12-15 | US | South Dakota | Tripp | 46123 | 953 | 21 | 0 | 43.34459388 | -99.8854891 | 2021-12-16 04:22:11 | Tripp, South Dakota, US | |
3498921 | 3498921 | 2021-12-15 | US | Puerto Rico | Ciales | 72039 | 953 | 0 | 0 | 18.28885 | -66.516475 | 2021-12-16 04:22:11 | Ciales, Puerto Rico, US | |
2090706 | 2090706 | 2021-12-14 | US | Puerto Rico | Ciales | 72039 | 953 | 0 | 0 | 18.28885 | -66.516475 | 2021-12-15 03:22:16 | Ciales, Puerto Rico, US | |
406404 | 406404 | 2021-12-07 | US | Nebraska | Pierce | 31139 | 953 | 20 | 0 | 42.26434853 | -97.60122773 | 2021-12-08 04:22:46 | Pierce, Nebraska, US | |
1032486 | 1032486 | 2021-12-06 | US | Nebraska | Pierce | 31139 | 953 | 20 | 0 | 42.26434853 | -97.60122773 | 2021-12-07 04:22:34 | Pierce, Nebraska, US | |
3107 | 3107 | 2021-12-02 | US | Puerto Rico | San German | 72125 | 953 | 0 | 0 | 18.111484 | -67.03858100000001 | 2021-12-03 04:23:05 | San German, Puerto Rico, US | |
13 | 13 | 2021-12-02 | Australia | South Australia | 953 | 4 | 0 | -34.9285 | 138.6007 | 2021-12-03 04:23:05 | South Australia, Australia | |||
1147706 | 1147706 | 2021-12-01 | US | Puerto Rico | San German | 72125 | 953 | 0 | 0 | 18.111484 | -67.03858100000001 | 2021-12-02 04:22:37 | San German, Puerto Rico, US | |
3402386 | 3402386 | 2021-11-30 | US | Idaho | Lemhi | 16059 | 953 | 20 | 0 | 44.9438088 | -113.9309747 | 2021-12-01 04:22:29 | Lemhi, Idaho, US | |
1234057 | 1234057 | 2021-11-28 | US | North Dakota | Sioux | 38085 | 953 | 18 | 0 | 46.11323337 | -101.04401490000001 | 2021-11-29 04:22:30 | Sioux, North Dakota, US | |
1233617 | 1233617 | 2021-11-28 | US | Montana | Broadwater | 30007 | 953 | 17 | 0 | 46.33277565 | -111.49558130000001 | 2021-11-29 04:22:30 | Broadwater, Montana, US | |
1360764 | 1360764 | 2021-11-27 | US | North Dakota | Sioux | 38085 | 953 | 18 | 0 | 46.11323337 | -101.04401490000001 | 2021-11-28 04:22:43 | Sioux, North Dakota, US | |
1360324 | 1360324 | 2021-11-27 | US | Montana | Broadwater | 30007 | 953 | 17 | 0 | 46.33277565 | -111.49558130000001 | 2021-11-28 04:22:43 | Broadwater, Montana, US | |
760315 | 760315 | 2021-11-26 | US | Montana | Broadwater | 30007 | 953 | 17 | 0 | 46.33277565 | -111.49558130000001 | 2021-11-27 04:22:45 | Broadwater, Montana, US | |
3071639 | 3071639 | 2021-11-23 | US | Michigan | Alger | 26003 | 953 | 9 | 0 | 46.41292944 | -86.60260122 | 2021-11-24 04:22:14 | Alger, Michigan, US | |
3750737 | 3750737 | 2021-11-22 | US | Michigan | Alger | 26003 | 953 | 9 | 0 | 46.41292944 | -86.60260122 | 2021-11-23 04:22:39 | Alger, Michigan, 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]);