johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
523 rows where confirmed = 942 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753859 | 2753859 | 2022-12-29 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-30 04:21:04 | Oneida, Idaho, US | |
1074865 | 1074865 | 2022-12-28 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-29 04:21:01 | Oneida, Idaho, US | |
328862 | 328862 | 2022-12-27 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-28 04:21:04 | Oneida, Idaho, US | |
218935 | 218935 | 2022-12-26 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-27 04:21:07 | Oneida, Idaho, US | |
3223392 | 3223392 | 2022-12-25 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-26 04:21:06 | Oneida, Idaho, US | |
1019306 | 1019306 | 2022-12-24 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-25 04:21:04 | Oneida, Idaho, US | |
691329 | 691329 | 2022-12-23 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-24 04:21:02 | Oneida, Idaho, US | |
2180539 | 2180539 | 2022-12-22 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-23 04:21:04 | Oneida, Idaho, US | |
452343 | 452343 | 2022-12-21 | US | Idaho | Oneida | 16071 | 942 | 12 | 0 | 42.1949428 | -112.5407838 | 2022-12-22 04:20:56 | Oneida, Idaho, US | |
3554048 | 3554048 | 2022-11-27 | US | North Dakota | Cavalier | 38019 | 942 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-11-28 04:21:02 | Cavalier, North Dakota, US | |
2102528 | 2102528 | 2022-11-26 | US | North Dakota | Cavalier | 38019 | 942 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-11-27 04:21:05 | Cavalier, North Dakota, US | |
490019 | 490019 | 2022-11-25 | US | North Dakota | Cavalier | 38019 | 942 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-11-26 04:21:11 | Cavalier, North Dakota, US | |
3525848 | 3525848 | 2022-11-24 | US | North Dakota | Cavalier | 38019 | 942 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-11-25 04:21:06 | Cavalier, North Dakota, US | |
3314631 | 3314631 | 2022-11-23 | US | North Dakota | Cavalier | 38019 | 942 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-11-24 04:21:09 | Cavalier, North Dakota, US | |
434564 | 434564 | 2022-11-03 | US | Texas | Reagan | 48383 | 942 | 15 | 0 | 31.36607041 | -101.5232659 | 2022-11-04 04:22:11 | Reagan, Texas, US | |
852806 | 852806 | 2022-11-02 | US | Texas | Reagan | 48383 | 942 | 15 | 0 | 31.36607041 | -101.5232659 | 2022-11-03 04:22:05 | Reagan, Texas, US | |
713657 | 713657 | 2022-11-01 | US | Texas | Reagan | 48383 | 942 | 15 | 0 | 31.36607041 | -101.5232659 | 2022-11-02 04:22:09 | Reagan, Texas, US | |
3288106 | 3288106 | 2022-10-31 | US | Texas | Reagan | 48383 | 942 | 15 | 0 | 31.36607041 | -101.5232659 | 2022-11-01 04:22:36 | Reagan, Texas, US | |
1832362 | 1832362 | 2022-10-25 | US | New Mexico | Mora | 35033 | 942 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-10-26 04:22:19 | Mora, New Mexico, US | |
2271713 | 2271713 | 2022-10-20 | China | Guizhou | 942 | 2 | 0 | 26.8154 | 106.8748 | 2022-10-21 04:22:23 | Guizhou, China | |||
198048 | 198048 | 2022-10-19 | China | Guizhou | 942 | 2 | 0 | 26.8154 | 106.8748 | 2022-10-20 04:22:59 | Guizhou, China | |||
2756709 | 2756709 | 2022-10-18 | China | Guizhou | 942 | 2 | 0 | 26.8154 | 106.8748 | 2022-10-19 04:22:26 | Guizhou, China | |||
1372271 | 1372271 | 2022-09-21 | US | Minnesota | Traverse | 27155 | 942 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-09-22 04:22:56 | Traverse, Minnesota, US | |
2018501 | 2018501 | 2022-09-20 | US | Minnesota | Traverse | 27155 | 942 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-09-21 04:23:22 | Traverse, Minnesota, US | |
3572374 | 3572374 | 2022-09-19 | US | Minnesota | Traverse | 27155 | 942 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-09-20 04:22:48 | Traverse, Minnesota, US | |
421113 | 421113 | 2022-09-18 | US | Minnesota | Traverse | 27155 | 942 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-09-19 04:21:49 | Traverse, Minnesota, US | |
3375137 | 3375137 | 2022-09-17 | US | Minnesota | Traverse | 27155 | 942 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-09-18 04:22:50 | Traverse, Minnesota, US | |
2357245 | 2357245 | 2022-09-16 | US | Minnesota | Traverse | 27155 | 942 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-09-17 04:20:19 | Traverse, Minnesota, US | |
3988402 | 3988402 | 2022-09-15 | US | Minnesota | Traverse | 27155 | 942 | 11 | 0 | 45.77298854 | -96.47062949 | 2022-09-16 04:21:19 | Traverse, Minnesota, US | |
899263 | 899263 | 2022-07-24 | US | Texas | Haskell | 48207 | 942 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-07-25 04:20:51 | Haskell, Texas, US | |
94257 | 94257 | 2022-07-23 | US | Texas | Haskell | 48207 | 942 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-07-24 04:20:47 | Haskell, Texas, US | |
166842 | 166842 | 2022-06-21 | US | Georgia | Echols | 13101 | 942 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-06-22 04:20:54 | Echols, Georgia, US | |
1764125 | 1764125 | 2022-06-20 | US | Georgia | Echols | 13101 | 942 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-06-21 04:20:56 | Echols, Georgia, US | |
3270311 | 3270311 | 2022-06-19 | US | Georgia | Echols | 13101 | 942 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-06-20 04:21:01 | Echols, Georgia, US | |
3398223 | 3398223 | 2022-06-18 | US | Georgia | Echols | 13101 | 942 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-06-19 04:20:51 | Echols, Georgia, US | |
2312100 | 2312100 | 2022-06-17 | US | Georgia | Echols | 13101 | 942 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-06-18 04:21:10 | Echols, Georgia, US | |
561048 | 561048 | 2022-06-16 | US | New York | Hamilton | 36041 | 942 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-06-17 04:20:56 | Hamilton, New York, US | |
559727 | 559727 | 2022-06-16 | US | Idaho | Bear Lake | 16007 | 942 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-06-17 04:20:56 | Bear Lake, Idaho, US | |
559604 | 559604 | 2022-06-16 | US | Georgia | Echols | 13101 | 942 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-06-17 04:20:56 | Echols, Georgia, US | |
3983529 | 3983529 | 2022-06-15 | US | Idaho | Bear Lake | 16007 | 942 | 16 | 0 | 42.28269683 | -111.3289238 | 2022-06-16 04:20:55 | Bear Lake, Idaho, US | |
3983406 | 3983406 | 2022-06-15 | US | Georgia | Echols | 13101 | 942 | 12 | 0 | 30.71101099 | -82.89687287 | 2022-06-16 04:20:55 | Echols, Georgia, US | |
3160943 | 3160943 | 2022-06-09 | US | Virginia | Bath | 51017 | 942 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-06-10 04:20:55 | Bath, Virginia, US | |
1575005 | 1575005 | 2022-05-03 | US | South Dakota | Edmunds | 46045 | 942 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-05-04 04:20:59 | Edmunds, South Dakota, US | |
466265 | 466265 | 2022-05-02 | US | South Dakota | Edmunds | 46045 | 942 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-05-03 04:21:00 | Edmunds, South Dakota, US | |
3918904 | 3918904 | 2022-05-01 | US | South Dakota | Edmunds | 46045 | 942 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-05-02 04:21:10 | Edmunds, South Dakota, US | |
2843708 | 2843708 | 2022-04-30 | US | South Dakota | Edmunds | 46045 | 942 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-05-01 04:20:57 | Edmunds, South Dakota, US | |
1160021 | 1160021 | 2022-04-29 | US | South Dakota | Edmunds | 46045 | 942 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-30 04:21:05 | Edmunds, South Dakota, US | |
1699203 | 1699203 | 2022-04-28 | US | South Dakota | Edmunds | 46045 | 942 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-29 04:20:59 | Edmunds, South Dakota, US | |
3854686 | 3854686 | 2022-04-27 | US | South Dakota | Edmunds | 46045 | 942 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-04-28 04:20:47 | Edmunds, South Dakota, US | |
1512446 | 1512446 | 2022-02-24 | US | Illinois | Pope | 17151 | 942 | 7 | 0 | 37.41391284 | -88.56152109 | 2022-02-25 04:21:11 | Pope, Illinois, US | |
982148 | 982148 | 2022-02-01 | US | Texas | Presidio | 48377 | 942 | 32 | 0 | 29.99954402 | -104.24080790000001 | 2022-02-02 04:21:09 | Presidio, Texas, US | |
2052878 | 2052878 | 2022-01-25 | US | Illinois | Hardin | 17069 | 942 | 18 | 0 | 37.51810645 | -88.26873022 | 2022-01-26 04:21:07 | Hardin, Illinois, US | |
1142823 | 1142823 | 2022-01-23 | US | Missouri | Holt | 29087 | 942 | 25 | 0 | 40.09799248 | -95.21638879999999 | 2022-01-24 04:21:12 | Holt, Missouri, US | |
2613507 | 2613507 | 2022-01-06 | US | Washington | Skamania | 53059 | 942 | 9 | 0 | 46.02408726 | -121.91644029999999 | 2022-01-07 04:22:09 | Skamania, Washington, US | |
2609804 | 2609804 | 2022-01-06 | Canada | Nunavut | 942 | 4 | 0 | 70.2998 | -83.1076 | 2022-01-07 04:22:09 | Nunavut, Canada | |||
1670194 | 1670194 | 2021-12-29 | US | Minnesota | Lincoln | 27081 | 942 | 5 | 0 | 44.41311883 | -96.26688165 | 2021-12-30 04:21:25 | Lincoln, Minnesota, US | |
800299 | 800299 | 2021-12-22 | US | Missouri | Atchison | 29005 | 942 | 18 | 0 | 40.43238737 | -95.42970639 | 2021-12-23 04:21:21 | Atchison, Missouri, US | |
2905767 | 2905767 | 2021-12-19 | US | Nebraska | Burt | 31021 | 942 | 12 | 0 | 41.85056773 | -96.32605633 | 2021-12-20 04:21:43 | Burt, Nebraska, US | |
1260840 | 1260840 | 2021-12-18 | US | Nebraska | Burt | 31021 | 942 | 12 | 0 | 41.85056773 | -96.32605633 | 2021-12-19 04:21:11 | Burt, Nebraska, US | |
2400868 | 2400868 | 2021-12-17 | US | Nebraska | Burt | 31021 | 942 | 12 | 0 | 41.85056773 | -96.32605633 | 2021-12-18 02:22:20 | Burt, Nebraska, US | |
1717676 | 1717676 | 2021-12-16 | US | Kansas | Morris | 20127 | 942 | 23 | 0 | 38.68827511 | -96.65128437 | 2021-12-17 04:22:14 | Morris, Kansas, US | |
3498906 | 3498906 | 2021-12-15 | US | Puerto Rico | Aibonito | 72009 | 942 | 0 | 0 | 18.131361 | -66.264131 | 2021-12-16 04:22:11 | Aibonito, Puerto Rico, US | |
3497510 | 3497510 | 2021-12-15 | US | Kansas | Morris | 20127 | 942 | 23 | 0 | 38.68827511 | -96.65128437 | 2021-12-16 04:22:11 | Morris, Kansas, US | |
1661786 | 1661786 | 2021-12-12 | US | Kansas | Washington | 20201 | 942 | 17 | 0 | 39.78420784 | -97.08753229999999 | 2021-12-13 04:22:02 | Washington, Kansas, US | |
1665802 | 1665802 | 2021-12-11 | US | Kansas | Washington | 20201 | 942 | 17 | 0 | 39.78420784 | -97.08753229999999 | 2021-12-12 04:22:12 | Washington, Kansas, US | |
3658764 | 3658764 | 2021-12-10 | US | Texas | McCulloch | 48307 | 942 | 39 | 0 | 31.1925468 | -99.34682807 | 2021-12-11 04:22:45 | McCulloch, Texas, US | |
3656954 | 3656954 | 2021-12-10 | US | Kansas | Washington | 20201 | 942 | 17 | 0 | 39.78420784 | -97.08753229999999 | 2021-12-11 04:22:45 | Washington, Kansas, US | |
1081095 | 1081095 | 2021-12-09 | US | Texas | McCulloch | 48307 | 942 | 39 | 0 | 31.1925468 | -99.34682807 | 2021-12-10 04:22:28 | McCulloch, Texas, US | |
1080027 | 1080027 | 2021-12-09 | US | Nebraska | Morrill | 31123 | 942 | 7 | 0 | 41.71711774 | -103.0061405 | 2021-12-10 04:22:28 | Morrill, Nebraska, US | |
553944 | 553944 | 2021-12-08 | US | Texas | McCulloch | 48307 | 942 | 39 | 0 | 31.1925468 | -99.34682807 | 2021-12-09 04:22:49 | McCulloch, Texas, US | |
553506 | 553506 | 2021-12-08 | US | Puerto Rico | Ciales | 72039 | 942 | 0 | 0 | 18.28885 | -66.516475 | 2021-12-09 04:22:49 | Ciales, Puerto Rico, US | |
407464 | 407464 | 2021-12-07 | US | Texas | McCulloch | 48307 | 942 | 39 | 0 | 31.1925468 | -99.34682807 | 2021-12-08 04:22:46 | McCulloch, Texas, US | |
2418 | 2418 | 2021-12-02 | US | Nebraska | Jefferson | 31095 | 942 | 1 | 0 | 40.17584531 | -97.142601 | 2021-12-03 04:23:05 | Jefferson, Nebraska, US | |
3402778 | 3402778 | 2021-11-30 | US | Kansas | Republic | 20157 | 942 | 14 | 0 | 39.82799632 | -97.65036709 | 2021-12-01 04:22:29 | Republic, Kansas, US | |
3402733 | 3402733 | 2021-11-30 | US | Kansas | Gray | 20069 | 942 | 22 | 0 | 37.73836671 | -100.4369088 | 2021-12-01 04:22:29 | Gray, Kansas, US | |
151321 | 151321 | 2021-11-29 | US | Kansas | Republic | 20157 | 942 | 14 | 0 | 39.82799632 | -97.65036709 | 2021-11-30 04:22:53 | Republic, Kansas, US | |
151276 | 151276 | 2021-11-29 | US | Kansas | Gray | 20069 | 942 | 22 | 0 | 37.73836671 | -100.4369088 | 2021-11-30 04:22:53 | Gray, Kansas, US | |
3073580 | 3073580 | 2021-11-23 | US | Wisconsin | Iron | 55051 | 942 | 42 | 0 | 46.26302338 | -90.24295041 | 2021-11-24 04:22:14 | Iron, Wisconsin, US | |
3749541 | 3749541 | 2021-11-22 | US | Alaska | Aleutians West | 2016 | 942 | 2 | 0 | 52.3233 | -174.1596 | 2021-11-23 04:22:39 | Aleutians West, Alaska, US | |
1014748 | 1014748 | 2021-11-21 | US | Alaska | Aleutians West | 2016 | 942 | 2 | 0 | 52.3233 | -174.1596 | 2021-11-22 04:22:20 | Aleutians West, Alaska, US | |
722912 | 722912 | 2021-11-20 | US | Alaska | Aleutians West | 2016 | 942 | 2 | 0 | 52.3233 | -174.1596 | 2021-11-21 04:22:13 | Aleutians West, Alaska, US | |
162442 | 162442 | 2021-11-19 | US | Alaska | Aleutians West | 2016 | 942 | 2 | 0 | 52.3233 | -174.1596 | 2021-11-20 04:22:17 | Aleutians West, Alaska, US | |
3291799 | 3291799 | 2021-11-18 | US | South Dakota | Kingsbury | 46077 | 942 | 18 | 0 | 44.36956169 | -97.4913945 | 2021-11-19 04:21:40 | Kingsbury, South Dakota, US | |
3289329 | 3289329 | 2021-11-18 | US | Alaska | Aleutians West | 2016 | 942 | 2 | 0 | 52.3233 | -174.1596 | 2021-11-19 04:21:40 | Aleutians West, Alaska, US | |
2290368 | 2290368 | 2021-11-15 | US | South Dakota | Walworth | 46129 | 942 | 18 | 0 | 45.43019636 | -100.03075140000001 | 2021-11-16 04:21:10 | Walworth, South Dakota, US | |
688778 | 688778 | 2021-11-13 | US | North Dakota | Ransom | 38073 | 942 | 20 | 0 | 46.45621782 | -97.65742504 | 2021-11-14 04:21:31 | Ransom, North Dakota, US | |
716887 | 716887 | 2021-11-12 | US | North Dakota | Ransom | 38073 | 942 | 20 | 0 | 46.45621782 | -97.65742504 | 2021-11-13 04:21:38 | Ransom, North Dakota, US | |
31306 | 31306 | 2021-11-11 | US | South Dakota | McCook | 46087 | 942 | 25 | 0 | 43.6742571 | -97.36863144 | 2021-11-12 04:22:01 | McCook, South Dakota, US | |
2847745 | 2847745 | 2021-11-10 | US | South Dakota | McCook | 46087 | 942 | 25 | 0 | 43.6742571 | -97.36863144 | 2021-11-11 04:21:45 | McCook, South Dakota, US | |
90729 | 90729 | 2021-11-09 | US | Wyoming | Crook | 56011 | 942 | 20 | 0 | 44.58855102 | -104.56977049999999 | 2021-11-10 04:21:38 | Crook, Wyoming, US | |
89239 | 89239 | 2021-11-09 | US | Nebraska | Richardson | 31147 | 942 | 19 | 0 | 40.1247415 | -95.71755036 | 2021-11-10 04:21:38 | Richardson, Nebraska, US | |
700369 | 700369 | 2021-11-04 | US | Missouri | Shelby | 29205 | 942 | 9 | 0 | 39.79742518 | -92.07634971 | 2021-11-05 04:21:54 | Shelby, Missouri, US | |
700154 | 700154 | 2021-11-04 | US | Minnesota | Norman | 27107 | 942 | 9 | 0 | 47.32628443 | -96.45620947 | 2021-11-05 04:21:54 | Norman, Minnesota, US | |
46485 | 46485 | 2021-11-02 | US | Puerto Rico | San German | 72125 | 942 | 0 | 0 | 18.111484 | -67.03858100000001 | 2021-11-03 06:22:09 | San German, Puerto Rico, US | |
3495548 | 3495548 | 2021-10-26 | US | Virginia | Middlesex | 51119 | 942 | 30 | 0 | 37.63191998 | -76.55064617 | 2021-10-27 04:22:32 | Middlesex, Virginia, US | |
684018 | 684018 | 2021-10-24 | US | Michigan | Oscoda | 26135 | 942 | 34 | 0 | 44.68192279 | -84.12939244 | 2021-10-25 04:22:31 | Oscoda, Michigan, US | |
772026 | 772026 | 2021-10-23 | US | Michigan | Oscoda | 26135 | 942 | 34 | 0 | 44.68192279 | -84.12939244 | 2021-10-24 04:21:22 | Oscoda, Michigan, US | |
655673 | 655673 | 2021-10-22 | US | Michigan | Oscoda | 26135 | 942 | 34 | 0 | 44.68192279 | -84.12939244 | 2021-10-23 04:21:32 | Oscoda, Michigan, US | |
2045665 | 2045665 | 2021-10-18 | US | Mississippi | Jefferson | 28063 | 942 | 34 | 0 | 31.73397872 | -91.03764977 | 2021-10-19 04:20:54 | Jefferson, Mississippi, US | |
1911026 | 1911026 | 2021-10-17 | US | Mississippi | Jefferson | 28063 | 942 | 34 | 0 | 31.73397872 | -91.03764977 | 2021-10-18 04:21:10 | Jefferson, Mississippi, 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]);