johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
462 rows where confirmed = 1491 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954453 | 2954453 | 2022-12-20 | US | Texas | Crane | 48103 | 1491 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-21 04:21:03 | Crane, Texas, US | |
2952635 | 2952635 | 2022-12-20 | US | Iowa | Taylor | 19173 | 1491 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-21 04:21:03 | Taylor, Iowa, US | |
3176855 | 3176855 | 2022-12-19 | US | Texas | Crane | 48103 | 1491 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-20 04:21:04 | Crane, Texas, US | |
3175037 | 3175037 | 2022-12-19 | US | Iowa | Taylor | 19173 | 1491 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-20 04:21:04 | Taylor, Iowa, US | |
1631372 | 1631372 | 2022-12-18 | US | Texas | Crane | 48103 | 1491 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-19 04:21:03 | Crane, Texas, US | |
1629554 | 1629554 | 2022-12-18 | US | Iowa | Taylor | 19173 | 1491 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-19 04:21:03 | Taylor, Iowa, US | |
506751 | 506751 | 2022-12-17 | US | Texas | Crane | 48103 | 1491 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-18 04:21:03 | Crane, Texas, US | |
504933 | 504933 | 2022-12-17 | US | Iowa | Taylor | 19173 | 1491 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-18 04:21:03 | Taylor, Iowa, US | |
3327323 | 3327323 | 2022-12-16 | US | Texas | Crane | 48103 | 1491 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-17 04:21:04 | Crane, Texas, US | |
3325505 | 3325505 | 2022-12-16 | US | Iowa | Taylor | 19173 | 1491 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-17 04:21:04 | Taylor, Iowa, US | |
545835 | 545835 | 2022-12-15 | US | Texas | Crane | 48103 | 1491 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-16 04:21:01 | Crane, Texas, US | |
544017 | 544017 | 2022-12-15 | US | Iowa | Taylor | 19173 | 1491 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-16 04:21:01 | Taylor, Iowa, US | |
543769 | 543769 | 2022-12-15 | US | Illinois | Henderson | 17071 | 1491 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-12-16 04:21:01 | Henderson, Illinois, US | |
351363 | 351363 | 2022-12-14 | US | Texas | Crane | 48103 | 1491 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-12-15 04:20:58 | Crane, Texas, US | |
349545 | 349545 | 2022-12-14 | US | Iowa | Taylor | 19173 | 1491 | 24 | 0 | 40.73710579 | -94.69778563 | 2022-12-15 04:20:58 | Taylor, Iowa, US | |
1987213 | 1987213 | 2022-12-07 | US | Oklahoma | Jefferson | 40067 | 1491 | 28 | 0 | 34.11130184 | -97.83182974 | 2022-12-08 04:21:07 | Jefferson, Oklahoma, US | |
3716736 | 3716736 | 2022-12-06 | US | Oklahoma | Jefferson | 40067 | 1491 | 28 | 0 | 34.11130184 | -97.83182974 | 2022-12-07 04:20:58 | Jefferson, Oklahoma, US | |
2417441 | 2417441 | 2022-12-05 | US | Oklahoma | Jefferson | 40067 | 1491 | 28 | 0 | 34.11130184 | -97.83182974 | 2022-12-06 04:21:03 | Jefferson, Oklahoma, US | |
721049 | 721049 | 2022-12-04 | US | Oklahoma | Jefferson | 40067 | 1491 | 28 | 0 | 34.11130184 | -97.83182974 | 2022-12-05 04:20:58 | Jefferson, Oklahoma, US | |
2819338 | 2819338 | 2022-12-03 | US | Oklahoma | Jefferson | 40067 | 1491 | 28 | 0 | 34.11130184 | -97.83182974 | 2022-12-04 04:20:56 | Jefferson, Oklahoma, US | |
836194 | 836194 | 2022-12-02 | US | Oklahoma | Jefferson | 40067 | 1491 | 28 | 0 | 34.11130184 | -97.83182974 | 2022-12-03 04:21:02 | Jefferson, Oklahoma, US | |
2138724 | 2138724 | 2022-12-01 | US | Oklahoma | Jefferson | 40067 | 1491 | 28 | 0 | 34.11130184 | -97.83182974 | 2022-12-02 04:21:07 | Jefferson, Oklahoma, US | |
2138195 | 2138195 | 2022-12-01 | US | Montana | Teton | 30099 | 1491 | 27 | 0 | 47.83741052 | -112.2410688 | 2022-12-02 04:21:07 | Teton, Montana, US | |
1966611 | 1966611 | 2022-11-30 | US | Montana | Teton | 30099 | 1491 | 27 | 0 | 47.83741052 | -112.2410688 | 2022-12-01 04:21:03 | Teton, Montana, US | |
2558625 | 2558625 | 2022-11-29 | US | Montana | Teton | 30099 | 1491 | 27 | 0 | 47.83741052 | -112.2410688 | 2022-11-30 04:21:07 | Teton, Montana, US | |
1241699 | 1241699 | 2022-11-28 | US | Montana | Teton | 30099 | 1491 | 27 | 0 | 47.83741052 | -112.2410688 | 2022-11-29 04:21:05 | Teton, Montana, US | |
3553687 | 3553687 | 2022-11-27 | US | Montana | Teton | 30099 | 1491 | 27 | 0 | 47.83741052 | -112.2410688 | 2022-11-28 04:21:02 | Teton, Montana, US | |
2102167 | 2102167 | 2022-11-26 | US | Montana | Teton | 30099 | 1491 | 27 | 0 | 47.83741052 | -112.2410688 | 2022-11-27 04:21:05 | Teton, Montana, US | |
489658 | 489658 | 2022-11-25 | US | Montana | Teton | 30099 | 1491 | 27 | 0 | 47.83741052 | -112.2410688 | 2022-11-26 04:21:11 | Teton, Montana, US | |
1621615 | 1621615 | 2022-11-22 | US | Kansas | Republic | 20157 | 1491 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-11-23 04:21:06 | Republic, Kansas, US | |
3461503 | 3461503 | 2022-11-21 | US | Kansas | Republic | 20157 | 1491 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-11-22 04:20:47 | Republic, Kansas, US | |
1641688 | 1641688 | 2022-11-20 | US | Kansas | Republic | 20157 | 1491 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-11-21 04:21:05 | Republic, Kansas, US | |
2065245 | 2065245 | 2022-11-19 | US | Kansas | Republic | 20157 | 1491 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-11-20 04:21:08 | Republic, Kansas, US | |
1756639 | 1756639 | 2022-11-18 | US | Kansas | Republic | 20157 | 1491 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-11-19 04:21:14 | Republic, Kansas, US | |
3027632 | 3027632 | 2022-11-17 | US | Kansas | Republic | 20157 | 1491 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-11-18 04:21:15 | Republic, Kansas, US | |
2487343 | 2487343 | 2022-11-16 | US | Kansas | Republic | 20157 | 1491 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-11-17 04:21:11 | Republic, Kansas, US | |
710633 | 710633 | 2022-11-01 | Peru | Unknown | 1491 | 8 | 0 | 2022-11-02 04:22:09 | Unknown, Peru | |||||
200672 | 200672 | 2022-10-19 | US | North Dakota | McHenry | 38049 | 1491 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-10-20 04:22:59 | McHenry, North Dakota, US | |
2759333 | 2759333 | 2022-10-18 | US | North Dakota | McHenry | 38049 | 1491 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-10-19 04:22:26 | McHenry, North Dakota, US | |
2027167 | 2027167 | 2022-10-17 | US | North Dakota | McHenry | 38049 | 1491 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-10-18 04:22:42 | McHenry, North Dakota, US | |
2398407 | 2398407 | 2022-09-12 | US | Wyoming | Crook | 56011 | 1491 | 29 | 0 | 44.58855102 | -104.5697705 | 2022-09-13 04:20:57 | Crook, Wyoming, US | |
2394601 | 2394601 | 2022-09-12 | China | Jiangxi | 1491 | 1 | 0 | 27.614 | 115.7221 | 2022-09-13 04:20:57 | Jiangxi, China | |||
3769485 | 3769485 | 2022-09-11 | US | Wyoming | Crook | 56011 | 1491 | 29 | 0 | 44.58855102 | -104.5697705 | 2022-09-12 04:20:58 | Crook, Wyoming, US | |
3828060 | 3828060 | 2022-09-10 | US | Wyoming | Crook | 56011 | 1491 | 29 | 0 | 44.58855102 | -104.5697705 | 2022-09-11 04:20:50 | Crook, Wyoming, US | |
966517 | 966517 | 2022-09-09 | US | Wyoming | Crook | 56011 | 1491 | 29 | 0 | 44.58855102 | -104.5697705 | 2022-09-10 04:21:10 | Crook, Wyoming, US | |
256919 | 256919 | 2022-09-08 | US | Wyoming | Crook | 56011 | 1491 | 29 | 0 | 44.58855102 | -104.5697705 | 2022-09-09 04:21:11 | Crook, Wyoming, US | |
3748717 | 3748717 | 2022-09-07 | US | Wyoming | Crook | 56011 | 1491 | 29 | 0 | 44.58855102 | -104.5697705 | 2022-09-08 04:21:02 | Crook, Wyoming, US | |
118357 | 118357 | 2022-09-06 | US | Wyoming | Crook | 56011 | 1491 | 29 | 0 | 44.58855102 | -104.5697705 | 2022-09-07 04:20:59 | Crook, Wyoming, US | |
1252119 | 1252119 | 2022-08-23 | US | Kansas | Washington | 20201 | 1491 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-08-24 04:20:46 | Washington, Kansas, US | |
2854223 | 2854223 | 2022-08-22 | US | Kansas | Washington | 20201 | 1491 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-08-23 04:20:56 | Washington, Kansas, US | |
2404195 | 2404195 | 2022-08-21 | US | Kansas | Washington | 20201 | 1491 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-08-22 04:20:38 | Washington, Kansas, US | |
3799273 | 3799273 | 2022-08-20 | US | Kansas | Washington | 20201 | 1491 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-08-21 04:20:44 | Washington, Kansas, US | |
2364859 | 2364859 | 2022-08-19 | US | Kansas | Washington | 20201 | 1491 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-08-20 04:21:01 | Washington, Kansas, US | |
1162530 | 1162530 | 2022-08-18 | US | Kansas | Washington | 20201 | 1491 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-08-19 04:20:54 | Washington, Kansas, US | |
3951854 | 3951854 | 2022-08-17 | US | Kansas | Washington | 20201 | 1491 | 23 | 0 | 39.78420784 | -97.0875323 | 2022-08-18 04:21:11 | Washington, Kansas, US | |
3546876 | 3546876 | 2022-08-08 | US | Virginia | Norton | 51720 | 1491 | 22 | 0 | 36.93357076 | -82.62750411 | 2022-08-09 04:20:34 | Norton, Virginia, US | |
1099821 | 1099821 | 2022-08-03 | US | Minnesota | Big Stone | 27011 | 1491 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-04 04:20:58 | Big Stone, Minnesota, US | |
1406746 | 1406746 | 2022-08-02 | US | Minnesota | Big Stone | 27011 | 1491 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-03 04:20:59 | Big Stone, Minnesota, US | |
3618784 | 3618784 | 2022-08-01 | US | Minnesota | Big Stone | 27011 | 1491 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-02 04:20:53 | Big Stone, Minnesota, US | |
3873264 | 3873264 | 2022-07-31 | US | Minnesota | Big Stone | 27011 | 1491 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-08-01 04:21:03 | Big Stone, Minnesota, US | |
676018 | 676018 | 2022-07-30 | US | Minnesota | Big Stone | 27011 | 1491 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-07-31 04:21:02 | Big Stone, Minnesota, US | |
1785217 | 1785217 | 2022-07-29 | US | Minnesota | Big Stone | 27011 | 1491 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-07-30 04:20:42 | Big Stone, Minnesota, US | |
1067580 | 1067580 | 2022-07-28 | US | Minnesota | Big Stone | 27011 | 1491 | 9 | 0 | 45.42712824 | -96.41403739 | 2022-07-29 04:20:45 | Big Stone, Minnesota, US | |
2338575 | 2338575 | 2022-07-27 | US | Texas | Mills | 48333 | 1491 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-07-28 04:20:56 | Mills, Texas, US | |
1490765 | 1490765 | 2022-07-26 | US | Texas | Mills | 48333 | 1491 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-07-27 04:21:04 | Mills, Texas, US | |
2597211 | 2597211 | 2022-07-25 | US | Texas | Mills | 48333 | 1491 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-07-26 04:20:58 | Mills, Texas, US | |
899326 | 899326 | 2022-07-24 | US | Texas | Mills | 48333 | 1491 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-07-25 04:20:51 | Mills, Texas, US | |
94320 | 94320 | 2022-07-23 | US | Texas | Mills | 48333 | 1491 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-07-24 04:20:47 | Mills, Texas, US | |
3112814 | 3112814 | 2022-07-13 | US | Virginia | Cumberland | 51049 | 1491 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-07-14 04:20:57 | Cumberland, Virginia, US | |
2790026 | 2790026 | 2022-07-10 | US | Illinois | Gallatin | 17059 | 1491 | 18 | 0 | 37.76430935 | -88.22953869 | 2022-07-11 04:20:46 | Gallatin, Illinois, US | |
142979 | 142979 | 2022-07-09 | US | Illinois | Gallatin | 17059 | 1491 | 18 | 0 | 37.76430935 | -88.22953869 | 2022-07-10 04:20:54 | Gallatin, Illinois, US | |
1418079 | 1418079 | 2022-07-08 | US | Illinois | Gallatin | 17059 | 1491 | 18 | 0 | 37.76430935 | -88.22953869 | 2022-07-09 04:20:59 | Gallatin, Illinois, US | |
3188047 | 3188047 | 2022-05-30 | US | Nebraska | Cedar | 31027 | 1491 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-05-31 04:20:51 | Cedar, Nebraska, US | |
3200196 | 3200196 | 2022-05-29 | US | Nebraska | Cedar | 31027 | 1491 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-05-30 04:20:50 | Cedar, Nebraska, US | |
2727074 | 2727074 | 2022-05-28 | US | Nebraska | Cedar | 31027 | 1491 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-05-29 04:20:53 | Cedar, Nebraska, US | |
1316255 | 1316255 | 2022-05-27 | US | Nebraska | Cedar | 31027 | 1491 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-05-28 04:21:07 | Cedar, Nebraska, US | |
1852047 | 1852047 | 2022-05-26 | US | Nebraska | Cedar | 31027 | 1491 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-05-27 04:20:56 | Cedar, Nebraska, US | |
2049923 | 2049923 | 2022-05-25 | US | Nebraska | Cedar | 31027 | 1491 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-05-26 04:20:50 | Cedar, Nebraska, US | |
3000237 | 3000237 | 2022-05-24 | US | Idaho | Caribou | 16029 | 1491 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-25 04:20:56 | Caribou, Idaho, US | |
3593958 | 3593958 | 2022-05-23 | US | Idaho | Caribou | 16029 | 1491 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-24 04:20:57 | Caribou, Idaho, US | |
623934 | 623934 | 2022-05-22 | US | Nebraska | Cedar | 31027 | 1491 | 13 | 0 | 42.5988851 | -97.25311951 | 2022-05-26 04:20:50 | Cedar, Nebraska, US | |
1110506 | 1110506 | 2022-05-21 | US | Idaho | Caribou | 16029 | 1491 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-22 04:20:52 | Caribou, Idaho, US | |
1170130 | 1170130 | 2022-05-20 | US | Idaho | Caribou | 16029 | 1491 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-21 04:20:58 | Caribou, Idaho, US | |
3896893 | 3896893 | 2022-05-19 | US | Idaho | Caribou | 16029 | 1491 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-20 04:20:57 | Caribou, Idaho, US | |
1185677 | 1185677 | 2022-05-18 | US | Idaho | Caribou | 16029 | 1491 | 26 | 0 | 42.77149116 | -111.5597683 | 2022-05-19 04:20:54 | Caribou, Idaho, US | |
2444641 | 2444641 | 2022-04-13 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-13 23:21:06 | Carter, Missouri, US | |
2444506 | 2444506 | 2022-04-13 | US | Minnesota | Norman | 27107 | 1491 | 13 | 0 | 47.32628443 | -96.45620947 | 2022-04-13 23:21:06 | Norman, Minnesota, US | |
1950398 | 1950398 | 2022-04-12 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-13 04:21:03 | Carter, Missouri, US | |
1950263 | 1950263 | 2022-04-12 | US | Minnesota | Norman | 27107 | 1491 | 13 | 0 | 47.32628443 | -96.45620947 | 2022-04-13 04:21:03 | Norman, Minnesota, US | |
3208151 | 3208151 | 2022-04-11 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-12 04:20:49 | Carter, Missouri, US | |
3208016 | 3208016 | 2022-04-11 | US | Minnesota | Norman | 27107 | 1491 | 13 | 0 | 47.32628443 | -96.45620947 | 2022-04-12 04:20:49 | Norman, Minnesota, US | |
1578037 | 1578037 | 2022-04-10 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-11 04:21:02 | Carter, Missouri, US | |
1577902 | 1577902 | 2022-04-10 | US | Minnesota | Norman | 27107 | 1491 | 13 | 0 | 47.32628443 | -96.45620947 | 2022-04-11 04:21:02 | Norman, Minnesota, US | |
1654279 | 1654279 | 2022-04-09 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-10 04:20:52 | Carter, Missouri, US | |
1654144 | 1654144 | 2022-04-09 | US | Minnesota | Norman | 27107 | 1491 | 13 | 0 | 47.32628443 | -96.45620947 | 2022-04-10 04:20:52 | Norman, Minnesota, US | |
2117601 | 2117601 | 2022-04-08 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-09 04:20:42 | Carter, Missouri, US | |
2117466 | 2117466 | 2022-04-08 | US | Minnesota | Norman | 27107 | 1491 | 13 | 0 | 47.32628443 | -96.45620947 | 2022-04-09 04:20:42 | Norman, Minnesota, US | |
3322125 | 3322125 | 2022-04-07 | US | Missouri | Carter | 29035 | 1491 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-04-08 04:20:48 | Carter, Missouri, US | |
3321990 | 3321990 | 2022-04-07 | US | Minnesota | Norman | 27107 | 1491 | 13 | 0 | 47.32628443 | -96.45620947 | 2022-04-08 04:20:48 | Norman, Minnesota, US | |
1471560 | 1471560 | 2022-03-24 | US | Washington | Skamania | 53059 | 1491 | 12 | 0 | 46.02408726 | -121.91644029999999 | 2022-03-25 04:20:46 | Skamania, Washington, 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]);