johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
454 rows where confirmed = 1500 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
349347 | 349347 | 2022-12-14 | US | Illinois | Scott | 17171 | 1500 | 14 | 0 | 39.6429169 | -90.47814431 | 2022-12-15 04:20:58 | Scott, Illinois, US | |
3715511 | 3715511 | 2022-12-06 | US | Kansas | Republic | 20157 | 1500 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-07 04:20:58 | Republic, Kansas, US | |
2416216 | 2416216 | 2022-12-05 | US | Kansas | Republic | 20157 | 1500 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-06 04:21:03 | Republic, Kansas, US | |
719824 | 719824 | 2022-12-04 | US | Kansas | Republic | 20157 | 1500 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-05 04:20:58 | Republic, Kansas, US | |
2818113 | 2818113 | 2022-12-03 | US | Kansas | Republic | 20157 | 1500 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-04 04:20:56 | Republic, Kansas, US | |
834969 | 834969 | 2022-12-02 | US | Kansas | Republic | 20157 | 1500 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-03 04:21:02 | Republic, Kansas, US | |
2137499 | 2137499 | 2022-12-01 | US | Kansas | Republic | 20157 | 1500 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-02 04:21:07 | Republic, Kansas, US | |
1965915 | 1965915 | 2022-11-30 | US | Kansas | Republic | 20157 | 1500 | 21 | 0 | 39.82799632 | -97.65036709 | 2022-12-01 04:21:03 | Republic, Kansas, US | |
487432 | 487432 | 2022-11-25 | China | Tibet | 1500 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-26 04:21:11 | Tibet, China | |||
2438540 | 2438540 | 2022-11-07 | China | Jiangxi | 1500 | 1 | 0 | 27.614 | 115.7221 | 2022-11-08 04:21:21 | Jiangxi, China | |||
2760241 | 2760241 | 2022-10-18 | US | Virginia | Charles City | 51036 | 1500 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-10-19 04:22:26 | Charles City, Virginia, US | |
1811742 | 1811742 | 2022-10-05 | US | Illinois | Alexander | 17003 | 1500 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-10-06 04:21:22 | Alexander, Illinois, US | |
118084 | 118084 | 2022-09-06 | US | Virginia | Emporia | 51595 | 1500 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-09-07 04:20:59 | Emporia, Virginia, US | |
3775248 | 3775248 | 2022-08-30 | US | Kansas | Rooks | 20163 | 1500 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-08-31 04:20:57 | Rooks, Kansas, US | |
1681844 | 1681844 | 2022-08-29 | US | Kansas | Rooks | 20163 | 1500 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-08-30 04:21:03 | Rooks, Kansas, US | |
1878328 | 1878328 | 2022-08-28 | US | Kansas | Rooks | 20163 | 1500 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-08-29 04:21:06 | Rooks, Kansas, US | |
2097455 | 2097455 | 2022-08-27 | US | Kansas | Rooks | 20163 | 1500 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-08-28 04:21:02 | Rooks, Kansas, US | |
1533270 | 1533270 | 2022-08-26 | US | Kansas | Rooks | 20163 | 1500 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-08-27 04:20:57 | Rooks, Kansas, US | |
2830157 | 2830157 | 2022-08-25 | US | Kansas | Rooks | 20163 | 1500 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-08-26 04:21:02 | Rooks, Kansas, US | |
2324690 | 2324690 | 2022-08-24 | US | Kansas | Rooks | 20163 | 1500 | 21 | 0 | 39.35022773 | -99.32484567 | 2022-08-25 04:21:13 | Rooks, Kansas, US | |
992243 | 992243 | 2022-08-16 | US | Iowa | Van Buren | 19177 | 1500 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-17 04:20:59 | Van Buren, Iowa, US | |
2495282 | 2495282 | 2022-08-15 | US | Iowa | Van Buren | 19177 | 1500 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-16 04:20:58 | Van Buren, Iowa, US | |
3648832 | 3648832 | 2022-08-14 | US | Iowa | Van Buren | 19177 | 1500 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-15 04:20:59 | Van Buren, Iowa, US | |
1969838 | 1969838 | 2022-08-13 | US | Iowa | Van Buren | 19177 | 1500 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-14 04:20:55 | Van Buren, Iowa, US | |
2889647 | 2889647 | 2022-08-12 | US | Iowa | Van Buren | 19177 | 1500 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-13 04:20:52 | Van Buren, Iowa, US | |
3909252 | 3909252 | 2022-08-11 | US | Iowa | Van Buren | 19177 | 1500 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-12 04:20:54 | Van Buren, Iowa, US | |
1349499 | 1349499 | 2022-08-10 | US | Texas | Mills | 48333 | 1500 | 37 | 0 | 31.49557106 | -98.59272068 | 2022-08-11 04:20:49 | Mills, Texas, US | |
1347569 | 1347569 | 2022-08-10 | US | Iowa | Van Buren | 19177 | 1500 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-08-11 04:20:49 | Van Buren, Iowa, US | |
1088980 | 1088980 | 2022-08-09 | US | South Dakota | Spink | 46115 | 1500 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-08-10 04:20:57 | Spink, South Dakota, US | |
3546395 | 3546395 | 2022-08-08 | US | South Dakota | Spink | 46115 | 1500 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-08-09 04:20:34 | Spink, South Dakota, US | |
1072798 | 1072798 | 2022-08-07 | US | South Dakota | Spink | 46115 | 1500 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-08-08 04:21:08 | Spink, South Dakota, US | |
1943386 | 1943386 | 2022-08-06 | US | South Dakota | Spink | 46115 | 1500 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-08-07 04:20:54 | Spink, South Dakota, US | |
883185 | 883185 | 2022-08-05 | US | South Dakota | Spink | 46115 | 1500 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-08-06 04:20:56 | Spink, South Dakota, US | |
2011596 | 2011596 | 2022-08-04 | US | South Dakota | Spink | 46115 | 1500 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-08-05 04:20:52 | Spink, South Dakota, US | |
1101023 | 1101023 | 2022-08-03 | US | South Dakota | Spink | 46115 | 1500 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-08-04 04:20:58 | Spink, South Dakota, US | |
3408786 | 3408786 | 2022-07-17 | US | Virginia | Cumberland | 51049 | 1500 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-07-18 04:20:59 | Cumberland, Virginia, US | |
2154986 | 2154986 | 2022-07-16 | US | Virginia | Cumberland | 51049 | 1500 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-07-17 04:21:15 | Cumberland, Virginia, US | |
2422219 | 2422219 | 2022-07-15 | US | Virginia | Cumberland | 51049 | 1500 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-07-16 04:21:05 | Cumberland, Virginia, US | |
1214878 | 1214878 | 2022-07-11 | US | Virginia | Covington | 51580 | 1500 | 28 | 0 | 37.7824656 | -79.98631446 | 2022-07-12 04:20:51 | Covington, Virginia, US | |
2789990 | 2789990 | 2022-07-10 | US | Idaho | Power | 16077 | 1500 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-11 04:20:46 | Power, Idaho, US | |
142943 | 142943 | 2022-07-09 | US | Idaho | Power | 16077 | 1500 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-10 04:20:54 | Power, Idaho, US | |
1418043 | 1418043 | 2022-07-08 | US | Idaho | Power | 16077 | 1500 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-09 04:20:59 | Power, Idaho, US | |
2741968 | 2741968 | 2022-07-07 | US | Idaho | Power | 16077 | 1500 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-08 04:20:56 | Power, Idaho, US | |
1200763 | 1200763 | 2022-07-06 | US | Idaho | Power | 16077 | 1500 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-07-07 04:20:55 | Power, Idaho, US | |
166489 | 166489 | 2022-06-21 | US | Alaska | Yukon-Koyukuk | 2290 | 1500 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-22 04:20:54 | Yukon-Koyukuk, Alaska, US | |
1763772 | 1763772 | 2022-06-20 | US | Alaska | Yukon-Koyukuk | 2290 | 1500 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-21 04:20:56 | Yukon-Koyukuk, Alaska, US | |
3269958 | 3269958 | 2022-06-19 | US | Alaska | Yukon-Koyukuk | 2290 | 1500 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-20 04:21:01 | Yukon-Koyukuk, Alaska, US | |
3397870 | 3397870 | 2022-06-18 | US | Alaska | Yukon-Koyukuk | 2290 | 1500 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-19 04:20:51 | Yukon-Koyukuk, Alaska, US | |
2311747 | 2311747 | 2022-06-17 | US | Alaska | Yukon-Koyukuk | 2290 | 1500 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-18 04:21:10 | Yukon-Koyukuk, Alaska, US | |
559434 | 559434 | 2022-06-16 | US | Colorado | Huerfano | 8055 | 1500 | 36 | 0 | 37.68473101 | -104.9612585 | 2022-06-17 04:20:56 | Huerfano, Colorado, US | |
559251 | 559251 | 2022-06-16 | US | Alaska | Yukon-Koyukuk | 2290 | 1500 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-17 04:20:56 | Yukon-Koyukuk, Alaska, US | |
3983053 | 3983053 | 2022-06-15 | US | Alaska | Yukon-Koyukuk | 2290 | 1500 | 10 | 0 | 65.50815459 | -151.3907387 | 2022-06-16 04:20:55 | Yukon-Koyukuk, Alaska, US | |
1851877 | 1851877 | 2022-05-26 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-27 04:20:56 | Carter, Missouri, US | |
2049753 | 2049753 | 2022-05-25 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-26 04:20:50 | Carter, Missouri, US | |
3001191 | 3001191 | 2022-05-24 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-25 04:20:56 | Carter, Missouri, US | |
3594912 | 3594912 | 2022-05-23 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-24 04:20:57 | Carter, Missouri, US | |
623764 | 623764 | 2022-05-22 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-26 04:20:50 | Carter, Missouri, US | |
1111460 | 1111460 | 2022-05-21 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-22 04:20:52 | Carter, Missouri, US | |
1171084 | 1171084 | 2022-05-20 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-21 04:20:58 | Carter, Missouri, US | |
3898358 | 3898358 | 2022-05-19 | US | North Dakota | Dickey | 38021 | 1500 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-05-20 04:20:57 | Dickey, North Dakota, US | |
3897847 | 3897847 | 2022-05-19 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-20 04:20:57 | Carter, Missouri, US | |
1187142 | 1187142 | 2022-05-18 | US | North Dakota | Dickey | 38021 | 1500 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-05-19 04:20:54 | Dickey, North Dakota, US | |
1186631 | 1186631 | 2022-05-18 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-19 04:20:54 | Carter, Missouri, US | |
3585039 | 3585039 | 2022-05-17 | US | North Dakota | Dickey | 38021 | 1500 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-05-18 04:20:50 | Dickey, North Dakota, US | |
3584528 | 3584528 | 2022-05-17 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-18 04:20:50 | Carter, Missouri, US | |
1505996 | 1505996 | 2022-05-16 | US | North Dakota | Dickey | 38021 | 1500 | 39 | 0 | 46.11017712 | -98.5049008 | 2022-05-17 04:20:59 | Dickey, North Dakota, US | |
1505485 | 1505485 | 2022-05-16 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-17 04:20:59 | Carter, Missouri, US | |
2085844 | 2085844 | 2022-05-15 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-16 04:20:47 | Carter, Missouri, US | |
3356554 | 3356554 | 2022-05-14 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-15 04:20:53 | Carter, Missouri, US | |
660199 | 660199 | 2022-05-13 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-14 04:20:48 | Carter, Missouri, US | |
2535282 | 2535282 | 2022-05-12 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-13 04:20:51 | Carter, Missouri, US | |
3447605 | 3447605 | 2022-05-11 | US | Puerto Rico | Maunabo | 72095 | 1500 | 0 | 0 | 18.017889 | -65.922235 | 2022-05-12 04:20:54 | Maunabo, Puerto Rico, US | |
3446728 | 3446728 | 2022-05-11 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-12 04:20:54 | Carter, Missouri, US | |
3537345 | 3537345 | 2022-05-10 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-11 04:20:48 | Carter, Missouri, US | |
3537182 | 3537182 | 2022-05-10 | US | Minnesota | Grant | 27051 | 1500 | 12 | 0 | 45.93424769 | -96.01139609 | 2022-05-11 04:20:48 | Grant, Minnesota, US | |
223880 | 223880 | 2022-05-09 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-10 04:20:50 | Carter, Missouri, US | |
2333265 | 2333265 | 2022-05-08 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-09 04:20:54 | Carter, Missouri, US | |
362227 | 362227 | 2022-05-07 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-08 04:20:49 | Carter, Missouri, US | |
1399578 | 1399578 | 2022-05-06 | US | Missouri | Carter | 29035 | 1500 | 24 | 0 | 36.94160441 | -90.96051322 | 2022-05-07 04:21:09 | Carter, Missouri, US | |
1698084 | 1698084 | 2022-04-28 | US | Minnesota | Norman | 27107 | 1500 | 13 | 0 | 47.32628443 | -96.45620947 | 2022-04-29 04:20:59 | Norman, Minnesota, US | |
1951388 | 1951388 | 2022-04-12 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-13 04:21:03 | Hamlin, South Dakota, US | |
3209141 | 3209141 | 2022-04-11 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-12 04:20:49 | Hamlin, South Dakota, US | |
1579027 | 1579027 | 2022-04-10 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-11 04:21:02 | Hamlin, South Dakota, US | |
1655269 | 1655269 | 2022-04-09 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-10 04:20:52 | Hamlin, South Dakota, US | |
2118591 | 2118591 | 2022-04-08 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-09 04:20:42 | Hamlin, South Dakota, US | |
3323700 | 3323700 | 2022-04-07 | US | Washington | Skamania | 53059 | 1500 | 13 | 0 | 46.02408726 | -121.91644029999999 | 2022-04-08 04:20:48 | Skamania, Washington, US | |
3323115 | 3323115 | 2022-04-07 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-08 04:20:48 | Hamlin, South Dakota, US | |
2804236 | 2804236 | 2022-04-06 | US | Washington | Skamania | 53059 | 1500 | 13 | 0 | 46.02408726 | -121.91644029999999 | 2022-04-07 04:20:53 | Skamania, Washington, US | |
2803651 | 2803651 | 2022-04-06 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-07 04:20:53 | Hamlin, South Dakota, US | |
3871005 | 3871005 | 2022-04-05 | US | Washington | Skamania | 53059 | 1500 | 12 | 0 | 46.02408726 | -121.91644029999999 | 2022-04-06 04:20:49 | Skamania, Washington, US | |
3870420 | 3870420 | 2022-04-05 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-06 04:20:49 | Hamlin, South Dakota, US | |
2752347 | 2752347 | 2022-04-04 | US | Washington | Skamania | 53059 | 1500 | 12 | 0 | 46.02408726 | -121.91644029999999 | 2022-04-05 04:20:48 | Skamania, Washington, US | |
2751762 | 2751762 | 2022-04-04 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-05 04:20:48 | Hamlin, South Dakota, US | |
3733108 | 3733108 | 2022-04-03 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-04 04:20:51 | Hamlin, South Dakota, US | |
502543 | 502543 | 2022-04-02 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-03 04:20:48 | Hamlin, South Dakota, US | |
3353528 | 3353528 | 2022-04-01 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-02 04:20:47 | Hamlin, South Dakota, US | |
1542833 | 1542833 | 2022-03-31 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-04-01 04:20:28 | Hamlin, South Dakota, US | |
2480846 | 2480846 | 2022-03-30 | US | South Dakota | Hamlin | 46057 | 1500 | 41 | 0 | 44.67385954 | -97.18829593 | 2022-03-31 04:20:56 | Hamlin, South Dakota, US | |
1908326 | 1908326 | 2022-03-22 | US | Texas | Jack | 48237 | 1500 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-03-23 04:20:48 | Jack, Texas, US | |
3241457 | 3241457 | 2022-03-21 | US | Texas | Jack | 48237 | 1500 | 28 | 0 | 33.23377248 | -98.17283469 | 2022-03-22 04:20:54 | Jack, Texas, 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]);