johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
497 rows where confirmed = 974 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954594 | 2954594 | 2022-12-20 | US | Texas | Real | 48385 | 974 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-12-21 04:21:03 | Real, Texas, US | |
3176996 | 3176996 | 2022-12-19 | US | Texas | Real | 48385 | 974 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-12-20 04:21:04 | Real, Texas, US | |
1631513 | 1631513 | 2022-12-18 | US | Texas | Real | 48385 | 974 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-12-19 04:21:03 | Real, Texas, US | |
506892 | 506892 | 2022-12-17 | US | Texas | Real | 48385 | 974 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-12-18 04:21:03 | Real, Texas, US | |
3327464 | 3327464 | 2022-12-16 | US | Texas | Real | 48385 | 974 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-12-17 04:21:04 | Real, Texas, US | |
545976 | 545976 | 2022-12-15 | US | Texas | Real | 48385 | 974 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-12-16 04:21:01 | Real, Texas, US | |
351504 | 351504 | 2022-12-14 | US | Texas | Real | 48385 | 974 | 25 | 0 | 29.83321503 | -99.82018052 | 2022-12-15 04:20:58 | Real, Texas, US | |
2557920 | 2557920 | 2022-11-29 | US | Kansas | Osborne | 20141 | 974 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-11-30 04:21:07 | Osborne, Kansas, US | |
1240994 | 1240994 | 2022-11-28 | US | Kansas | Osborne | 20141 | 974 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-11-29 04:21:05 | Osborne, Kansas, US | |
3552982 | 3552982 | 2022-11-27 | US | Kansas | Osborne | 20141 | 974 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-11-28 04:21:02 | Osborne, Kansas, US | |
2101462 | 2101462 | 2022-11-26 | US | Kansas | Osborne | 20141 | 974 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-11-27 04:21:05 | Osborne, Kansas, US | |
488953 | 488953 | 2022-11-25 | US | Kansas | Osborne | 20141 | 974 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-11-26 04:21:11 | Osborne, Kansas, US | |
3524782 | 3524782 | 2022-11-24 | US | Kansas | Osborne | 20141 | 974 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-11-25 04:21:06 | Osborne, Kansas, US | |
3313565 | 3313565 | 2022-11-23 | US | Kansas | Osborne | 20141 | 974 | 20 | 0 | 39.3503437 | -98.76753828 | 2022-11-24 04:21:09 | Osborne, Kansas, US | |
3987231 | 3987231 | 2022-09-15 | US | Colorado | Baca | 8009 | 974 | 15 | 0 | 37.31940883 | -102.5603223 | 2022-09-16 04:21:19 | Baca, Colorado, US | |
3776959 | 3776959 | 2022-08-30 | US | Texas | Coke | 48081 | 974 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-08-31 04:20:57 | Coke, Texas, US | |
1683555 | 1683555 | 2022-08-29 | US | Texas | Coke | 48081 | 974 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-08-30 04:21:03 | Coke, Texas, US | |
3910021 | 3910021 | 2022-08-11 | US | Montana | Musselshell | 30065 | 974 | 31 | 0 | 46.49684637 | -108.39498 | 2022-08-12 04:20:54 | Musselshell, Montana, US | |
1348338 | 1348338 | 2022-08-10 | US | Montana | Musselshell | 30065 | 974 | 31 | 0 | 46.49684637 | -108.39498 | 2022-08-11 04:20:49 | Musselshell, Montana, US | |
1088093 | 1088093 | 2022-08-09 | US | Montana | Musselshell | 30065 | 974 | 31 | 0 | 46.49684637 | -108.39498 | 2022-08-10 04:20:57 | Musselshell, Montana, US | |
3545508 | 3545508 | 2022-08-08 | US | Montana | Musselshell | 30065 | 974 | 31 | 0 | 46.49684637 | -108.39498 | 2022-08-09 04:20:34 | Musselshell, Montana, US | |
1071911 | 1071911 | 2022-08-07 | US | Montana | Musselshell | 30065 | 974 | 31 | 0 | 46.49684637 | -108.39498 | 2022-08-08 04:21:08 | Musselshell, Montana, US | |
1942499 | 1942499 | 2022-08-06 | US | Montana | Musselshell | 30065 | 974 | 31 | 0 | 46.49684637 | -108.39498 | 2022-08-07 04:20:54 | Musselshell, Montana, US | |
882298 | 882298 | 2022-08-05 | US | Montana | Musselshell | 30065 | 974 | 31 | 0 | 46.49684637 | -108.39498 | 2022-08-06 04:20:56 | Musselshell, Montana, US | |
2337156 | 2337156 | 2022-07-27 | US | Minnesota | Red Lake | 27125 | 974 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-07-28 04:20:56 | Red Lake, Minnesota, US | |
1489346 | 1489346 | 2022-07-26 | US | Minnesota | Red Lake | 27125 | 974 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-07-27 04:21:04 | Red Lake, Minnesota, US | |
2595792 | 2595792 | 2022-07-25 | US | Minnesota | Red Lake | 27125 | 974 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-07-26 04:20:58 | Red Lake, Minnesota, US | |
897907 | 897907 | 2022-07-24 | US | Minnesota | Red Lake | 27125 | 974 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-07-25 04:20:51 | Red Lake, Minnesota, US | |
92901 | 92901 | 2022-07-23 | US | Minnesota | Red Lake | 27125 | 974 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-07-24 04:20:47 | Red Lake, Minnesota, US | |
901923 | 901923 | 2022-07-22 | US | Minnesota | Red Lake | 27125 | 974 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-07-23 04:20:53 | Red Lake, Minnesota, US | |
672059 | 672059 | 2022-07-21 | US | Minnesota | Red Lake | 27125 | 974 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-07-22 04:21:15 | Red Lake, Minnesota, US | |
3983078 | 3983078 | 2022-06-15 | US | Arkansas | Calhoun | 5013 | 974 | 11 | 0 | 33.55598792 | -92.49974403 | 2022-06-16 04:20:55 | Calhoun, Arkansas, US | |
3135674 | 3135674 | 2022-06-03 | US | Nebraska | Sheridan | 31161 | 974 | 21 | 0 | 42.50284406 | -102.4126613 | 2022-06-04 04:20:58 | Sheridan, Nebraska, US | |
3580749 | 3580749 | 2022-06-02 | US | Nebraska | Sheridan | 31161 | 974 | 21 | 0 | 42.50284406 | -102.4126613 | 2022-06-03 04:20:58 | Sheridan, Nebraska, US | |
973042 | 973042 | 2022-06-01 | US | Nebraska | Sheridan | 31161 | 974 | 21 | 0 | 42.50284406 | -102.4126613 | 2022-06-02 05:20:39 | Sheridan, Nebraska, US | |
231349 | 231349 | 2022-05-31 | US | Nebraska | Sheridan | 31161 | 974 | 21 | 0 | 42.50284406 | -102.4126613 | 2022-06-01 04:20:55 | Sheridan, Nebraska, US | |
3869918 | 3869918 | 2022-04-05 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-06 04:20:49 | Tyrrell, North Carolina, US | |
2751260 | 2751260 | 2022-04-04 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-05 04:20:48 | Tyrrell, North Carolina, US | |
3732606 | 3732606 | 2022-04-03 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-04 04:20:51 | Tyrrell, North Carolina, US | |
502041 | 502041 | 2022-04-02 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-03 04:20:48 | Tyrrell, North Carolina, US | |
3353026 | 3353026 | 2022-04-01 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-02 04:20:47 | Tyrrell, North Carolina, US | |
1542331 | 1542331 | 2022-03-31 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-04-01 04:20:28 | Tyrrell, North Carolina, US | |
2480344 | 2480344 | 2022-03-30 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-31 04:20:56 | Tyrrell, North Carolina, US | |
160385 | 160385 | 2022-03-29 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-30 04:20:45 | Tyrrell, North Carolina, US | |
1438956 | 1438956 | 2022-03-28 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-29 04:20:46 | Tyrrell, North Carolina, US | |
1438503 | 1438503 | 2022-03-28 | US | Missouri | Knox | 29103 | 974 | 13 | 0 | 40.12699751 | -92.14780832 | 2022-03-29 04:20:46 | Knox, Missouri, US | |
878637 | 878637 | 2022-03-27 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-28 04:20:33 | Tyrrell, North Carolina, US | |
2165920 | 2165920 | 2022-03-26 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-27 04:20:47 | Tyrrell, North Carolina, US | |
1722856 | 1722856 | 2022-03-25 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-26 04:20:23 | Tyrrell, North Carolina, US | |
3024380 | 3024380 | 2022-03-23 | US | Nebraska | Nuckolls | 31129 | 974 | 11 | 0 | 40.17637905 | -98.04743961 | 2022-03-24 04:20:43 | Nuckolls, Nebraska, US | |
1907302 | 1907302 | 2022-03-22 | US | Nebraska | Nuckolls | 31129 | 974 | 11 | 0 | 40.17637905 | -98.04743961 | 2022-03-23 04:20:48 | Nuckolls, Nebraska, US | |
3240433 | 3240433 | 2022-03-21 | US | Nebraska | Nuckolls | 31129 | 974 | 11 | 0 | 40.17637905 | -98.04743961 | 2022-03-22 04:20:54 | Nuckolls, Nebraska, US | |
26077 | 26077 | 2022-03-20 | US | Michigan | Ontonagon | 26131 | 974 | 37 | 0 | 46.665226200000006 | -89.31390481 | 2022-03-21 04:20:50 | Ontonagon, Michigan, US | |
1658087 | 1658087 | 2022-03-19 | US | Michigan | Ontonagon | 26131 | 974 | 37 | 0 | 46.665226200000006 | -89.31390481 | 2022-03-20 04:20:45 | Ontonagon, Michigan, US | |
337613 | 337613 | 2022-03-18 | US | Michigan | Ontonagon | 26131 | 974 | 37 | 0 | 46.665226200000006 | -89.31390481 | 2022-03-19 04:20:47 | Ontonagon, Michigan, US | |
696066 | 696066 | 2022-03-17 | US | Michigan | Ontonagon | 26131 | 974 | 37 | 0 | 46.665226200000006 | -89.31390481 | 2022-03-18 04:20:55 | Ontonagon, Michigan, US | |
695932 | 695932 | 2022-03-17 | US | Louisiana | Unassigned | 90022 | 974 | 0 | 0 | 32.83121059 | 0.0 | 2022-03-18 04:20:55 | Unassigned, Louisiana, US | |
2321705 | 2321705 | 2022-03-16 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-17 04:20:56 | Tyrrell, North Carolina, US | |
2321009 | 2321009 | 2022-03-16 | US | Michigan | Ontonagon | 26131 | 974 | 37 | 0 | 46.665226200000006 | -89.31390481 | 2022-03-17 04:20:56 | Ontonagon, Michigan, US | |
263905 | 263905 | 2022-03-15 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-16 04:20:50 | Tyrrell, North Carolina, US | |
2266264 | 2266264 | 2022-03-14 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-15 04:20:47 | Tyrrell, North Carolina, US | |
3630330 | 3630330 | 2022-03-13 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-14 04:20:46 | Tyrrell, North Carolina, US | |
953238 | 953238 | 2022-03-12 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-13 04:20:49 | Tyrrell, North Carolina, US | |
358699 | 358699 | 2022-03-11 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-12 04:20:50 | Tyrrell, North Carolina, US | |
1867851 | 1867851 | 2022-03-10 | US | North Carolina | Tyrrell | 37177 | 974 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-03-11 04:20:50 | Tyrrell, North Carolina, US | |
1549963 | 1549963 | 2022-03-07 | US | Montana | Chouteau | 30015 | 974 | 14 | 0 | 47.88084126 | -110.4353362 | 2022-03-08 04:20:54 | Chouteau, Montana, US | |
2201632 | 2201632 | 2022-03-06 | US | Montana | Chouteau | 30015 | 974 | 14 | 0 | 47.88084126 | -110.4353362 | 2022-03-07 04:20:47 | Chouteau, Montana, US | |
2094089 | 2094089 | 2022-03-05 | US | Montana | Chouteau | 30015 | 974 | 14 | 0 | 47.88084126 | -110.4353362 | 2022-03-06 04:20:49 | Chouteau, Montana, US | |
2667789 | 2667789 | 2022-03-04 | US | Montana | Chouteau | 30015 | 974 | 14 | 0 | 47.88084126 | -110.4353362 | 2022-03-05 04:21:10 | Chouteau, Montana, US | |
1646354 | 1646354 | 2022-03-03 | US | Montana | Chouteau | 30015 | 974 | 14 | 0 | 47.88084126 | -110.4353362 | 2022-03-04 04:21:09 | Chouteau, Montana, US | |
2527357 | 2527357 | 2022-03-02 | US | Montana | Chouteau | 30015 | 974 | 14 | 0 | 47.88084126 | -110.4353362 | 2022-03-03 04:21:01 | Chouteau, Montana, US | |
1994651 | 1994651 | 2022-03-01 | US | Montana | Chouteau | 30015 | 974 | 14 | 0 | 47.88084126 | -110.4353362 | 2022-03-02 04:21:07 | Chouteau, Montana, US | |
943396 | 943396 | 2022-02-28 | US | California | Modoc | 6049 | 974 | 7 | 0 | 41.58965602 | -120.7244817 | 2022-03-01 04:21:09 | Modoc, California, US | |
2733587 | 2733587 | 2022-02-27 | US | California | Modoc | 6049 | 974 | 7 | 0 | 41.58965602 | -120.7244817 | 2022-02-28 04:21:05 | Modoc, California, US | |
2448726 | 2448726 | 2022-02-22 | US | Missouri | Putnam | 29171 | 974 | 22 | 0 | 40.47942497 | -93.02042674 | 2022-02-23 04:21:09 | Putnam, Missouri, US | |
3720586 | 3720586 | 2022-02-21 | US | North Dakota | Foster | 38031 | 974 | 21 | 0 | 47.457108399999996 | -98.88279923 | 2022-02-22 04:21:01 | Foster, North Dakota, US | |
3719726 | 3719726 | 2022-02-21 | US | Louisiana | Tensas | 22107 | 974 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-02-22 04:21:01 | Tensas, Louisiana, US | |
3914420 | 3914420 | 2022-02-20 | US | North Dakota | Foster | 38031 | 974 | 21 | 0 | 47.457108399999996 | -98.88279923 | 2022-02-21 04:21:05 | Foster, North Dakota, US | |
3913560 | 3913560 | 2022-02-20 | US | Louisiana | Tensas | 22107 | 974 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-02-21 04:21:05 | Tensas, Louisiana, US | |
3877978 | 3877978 | 2022-02-19 | US | North Dakota | Foster | 38031 | 974 | 21 | 0 | 47.457108399999996 | -98.88279923 | 2022-02-20 04:21:00 | Foster, North Dakota, US | |
3877118 | 3877118 | 2022-02-19 | US | Louisiana | Tensas | 22107 | 974 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-02-20 04:21:00 | Tensas, Louisiana, US | |
3858234 | 3858234 | 2022-02-18 | US | North Dakota | Foster | 38031 | 974 | 21 | 0 | 47.457108399999996 | -98.88279923 | 2022-02-19 04:21:11 | Foster, North Dakota, US | |
3857374 | 3857374 | 2022-02-18 | US | Louisiana | Tensas | 22107 | 974 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-02-19 04:21:11 | Tensas, Louisiana, US | |
1298675 | 1298675 | 2022-02-17 | US | Colorado | Gilpin | 8047 | 974 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-02-18 04:21:04 | Gilpin, Colorado, US | |
3821061 | 3821061 | 2022-02-16 | US | Colorado | Gilpin | 8047 | 974 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-02-17 04:20:56 | Gilpin, Colorado, US | |
3672275 | 3672275 | 2022-02-15 | US | Colorado | Gilpin | 8047 | 974 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-02-16 04:21:10 | Gilpin, Colorado, US | |
2642376 | 2642376 | 2022-02-14 | US | Colorado | Gilpin | 8047 | 974 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-02-15 04:21:09 | Gilpin, Colorado, US | |
188478 | 188478 | 2022-02-13 | US | North Dakota | LaMoure | 38045 | 974 | 19 | 0 | 46.45681054 | -98.53542355 | 2022-02-14 04:20:51 | LaMoure, North Dakota, US | |
186693 | 186693 | 2022-02-13 | US | Colorado | Gilpin | 8047 | 974 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-02-14 04:20:51 | Gilpin, Colorado, US | |
316539 | 316539 | 2022-02-12 | US | Colorado | Gilpin | 8047 | 974 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-02-13 04:21:00 | Gilpin, Colorado, US | |
233865 | 233865 | 2022-02-11 | US | Colorado | Gilpin | 8047 | 974 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-02-12 04:21:06 | Gilpin, Colorado, US | |
2659987 | 2659987 | 2022-01-31 | US | New Mexico | Guadalupe | 35019 | 974 | 16 | 0 | 34.86319296 | -104.790669 | 2022-02-01 04:21:11 | Guadalupe, New Mexico, US | |
1320257 | 1320257 | 2022-01-26 | US | Nebraska | Antelope | 31003 | 974 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-01-27 04:21:19 | Antelope, Nebraska, US | |
1230827 | 1230827 | 2022-01-24 | US | Texas | San Augustine | 48405 | 974 | 38 | 0 | 31.39457611 | -94.17000399 | 2022-01-25 04:21:05 | San Augustine, Texas, US | |
1143332 | 1143332 | 2022-01-23 | US | North Dakota | Pierce | 38069 | 974 | 29 | 0 | 48.24977025 | -99.96407787 | 2022-01-24 04:21:12 | Pierce, North Dakota, US | |
3465506 | 3465506 | 2022-01-18 | US | Kansas | Ottawa | 20143 | 974 | 15 | 0 | 39.13237408 | -97.65020313 | 2022-01-19 04:21:23 | Ottawa, Kansas, US | |
1473445 | 1473445 | 2022-01-17 | US | Kansas | Ottawa | 20143 | 974 | 15 | 0 | 39.13237408 | -97.65020313 | 2022-01-18 04:21:04 | Ottawa, Kansas, US | |
556119 | 556119 | 2022-01-16 | US | Kansas | Ottawa | 20143 | 974 | 15 | 0 | 39.13237408 | -97.65020313 | 2022-01-17 04:21:08 | Ottawa, Kansas, US | |
3841840 | 3841840 | 2022-01-15 | US | Kansas | Ottawa | 20143 | 974 | 15 | 0 | 39.13237408 | -97.65020313 | 2022-01-16 04:21:12 | Ottawa, Kansas, US | |
100655 | 100655 | 2022-01-14 | US | Kansas | Ottawa | 20143 | 974 | 15 | 0 | 39.13237408 | -97.65020313 | 2022-01-15 04:21:07 | Ottawa, Kansas, 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]);