johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
677 rows where confirmed = 891 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 21
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1150982 | 1150982 | 2022-12-12 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-11 23:21:04 | Sweet Grass, Montana, US | |
870836 | 870836 | 2022-12-11 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-11 23:21:04 | Sweet Grass, Montana, US | |
259366 | 259366 | 2022-12-10 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-11 04:20:50 | Sweet Grass, Montana, US | |
3938080 | 3938080 | 2022-12-09 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-10 04:21:02 | Sweet Grass, Montana, US | |
3379412 | 3379412 | 2022-12-08 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-09 04:21:05 | Sweet Grass, Montana, US | |
1986683 | 1986683 | 2022-12-07 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-08 04:21:07 | Sweet Grass, Montana, US | |
3716206 | 3716206 | 2022-12-06 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-07 04:20:58 | Sweet Grass, Montana, US | |
2416911 | 2416911 | 2022-12-05 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-06 04:21:03 | Sweet Grass, Montana, US | |
720519 | 720519 | 2022-12-04 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-05 04:20:58 | Sweet Grass, Montana, US | |
2818808 | 2818808 | 2022-12-03 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-04 04:20:56 | Sweet Grass, Montana, US | |
835664 | 835664 | 2022-12-02 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-03 04:21:02 | Sweet Grass, Montana, US | |
2138194 | 2138194 | 2022-12-01 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-02 04:21:07 | Sweet Grass, Montana, US | |
1966610 | 1966610 | 2022-11-30 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-12-01 04:21:03 | Sweet Grass, Montana, US | |
2558624 | 2558624 | 2022-11-29 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-11-30 04:21:07 | Sweet Grass, Montana, US | |
1241698 | 1241698 | 2022-11-28 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-11-29 04:21:05 | Sweet Grass, Montana, US | |
3553686 | 3553686 | 2022-11-27 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-11-28 04:21:02 | Sweet Grass, Montana, US | |
2102166 | 2102166 | 2022-11-26 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-11-27 04:21:05 | Sweet Grass, Montana, US | |
489657 | 489657 | 2022-11-25 | US | Montana | Sweet Grass | 30097 | 891 | 13 | 0 | 45.81367654 | -109.9425686 | 2022-11-26 04:21:11 | Sweet Grass, Montana, US | |
294866 | 294866 | 2022-11-15 | US | South Dakota | Bennett | 46007 | 891 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-11-16 04:21:09 | Bennett, South Dakota, US | |
3599896 | 3599896 | 2022-11-14 | US | South Dakota | Bennett | 46007 | 891 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-11-15 04:21:16 | Bennett, South Dakota, US | |
314754 | 314754 | 2022-11-13 | US | South Dakota | Bennett | 46007 | 891 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-11-14 04:21:09 | Bennett, South Dakota, US | |
65915 | 65915 | 2022-11-12 | US | South Dakota | Bennett | 46007 | 891 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-11-13 04:21:14 | Bennett, South Dakota, US | |
2930077 | 2930077 | 2022-11-11 | US | South Dakota | Bennett | 46007 | 891 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-11-12 04:20:41 | Bennett, South Dakota, US | |
2508913 | 2508913 | 2022-11-10 | US | South Dakota | Bennett | 46007 | 891 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-11-11 04:21:22 | Bennett, South Dakota, US | |
2433788 | 2433788 | 2022-11-09 | US | South Dakota | Bennett | 46007 | 891 | 15 | 0 | 43.19486375 | -101.6665572 | 2022-11-10 04:21:16 | Bennett, South Dakota, US | |
1831499 | 1831499 | 2022-10-25 | US | Kansas | Rush | 20165 | 891 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-26 04:22:19 | Rush, Kansas, US | |
1831447 | 1831447 | 2022-10-25 | US | Kansas | Gove | 20063 | 891 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-10-26 04:22:19 | Gove, Kansas, US | |
1830768 | 1830768 | 2022-10-25 | US | Colorado | Costilla | 8023 | 891 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-10-26 04:22:19 | Costilla, Colorado, US | |
795760 | 795760 | 2022-10-24 | US | Kansas | Rush | 20165 | 891 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-25 04:21:53 | Rush, Kansas, US | |
795708 | 795708 | 2022-10-24 | US | Kansas | Gove | 20063 | 891 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-10-25 04:21:53 | Gove, Kansas, US | |
3278215 | 3278215 | 2022-10-23 | US | Kansas | Rush | 20165 | 891 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-24 04:22:29 | Rush, Kansas, US | |
3278163 | 3278163 | 2022-10-23 | US | Kansas | Gove | 20063 | 891 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-10-24 04:22:29 | Gove, Kansas, US | |
2269253 | 2269253 | 2022-10-22 | US | Kansas | Rush | 20165 | 891 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-23 04:22:46 | Rush, Kansas, US | |
2269201 | 2269201 | 2022-10-22 | US | Kansas | Gove | 20063 | 891 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-10-23 04:22:46 | Gove, Kansas, US | |
1593553 | 1593553 | 2022-10-21 | US | Kansas | Rush | 20165 | 891 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-22 04:22:53 | Rush, Kansas, US | |
1593501 | 1593501 | 2022-10-21 | US | Kansas | Gove | 20063 | 891 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-10-22 04:22:53 | Gove, Kansas, US | |
2273269 | 2273269 | 2022-10-20 | US | Kansas | Rush | 20165 | 891 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-21 04:22:23 | Rush, Kansas, US | |
2273217 | 2273217 | 2022-10-20 | US | Kansas | Gove | 20063 | 891 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-10-21 04:22:23 | Gove, Kansas, US | |
199604 | 199604 | 2022-10-19 | US | Kansas | Rush | 20165 | 891 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-10-20 04:22:59 | Rush, Kansas, US | |
199552 | 199552 | 2022-10-19 | US | Kansas | Gove | 20063 | 891 | 23 | 0 | 38.91588178 | -100.4829321 | 2022-10-20 04:22:59 | Gove, Kansas, US | |
2759142 | 2759142 | 2022-10-18 | US | New Mexico | Union | 35059 | 891 | 19 | 0 | 36.48126404 | -103.4709624 | 2022-10-19 04:22:26 | Union, New Mexico, US | |
2017679 | 2017679 | 2022-09-20 | US | Idaho | Oneida | 16071 | 891 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-09-21 04:23:22 | Oneida, Idaho, US | |
3571552 | 3571552 | 2022-09-19 | US | Idaho | Oneida | 16071 | 891 | 11 | 0 | 42.1949428 | -112.5407838 | 2022-09-20 04:22:48 | Oneida, Idaho, US | |
3989651 | 3989651 | 2022-09-15 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-16 04:21:19 | Baylor, Texas, US | |
1892168 | 1892168 | 2022-09-14 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-15 04:21:02 | Baylor, Texas, US | |
375223 | 375223 | 2022-09-13 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-14 04:20:44 | Baylor, Texas, US | |
2397825 | 2397825 | 2022-09-12 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-13 04:20:57 | Baylor, Texas, US | |
2397193 | 2397193 | 2022-09-12 | US | North Dakota | Bowman | 38011 | 891 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-09-13 04:20:57 | Bowman, North Dakota, US | |
3768903 | 3768903 | 2022-09-11 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-12 04:20:58 | Baylor, Texas, US | |
3768271 | 3768271 | 2022-09-11 | US | North Dakota | Bowman | 38011 | 891 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-09-12 04:20:58 | Bowman, North Dakota, US | |
3827478 | 3827478 | 2022-09-10 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-11 04:20:50 | Baylor, Texas, US | |
3826846 | 3826846 | 2022-09-10 | US | North Dakota | Bowman | 38011 | 891 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-09-11 04:20:50 | Bowman, North Dakota, US | |
965935 | 965935 | 2022-09-09 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-10 04:21:10 | Baylor, Texas, US | |
965303 | 965303 | 2022-09-09 | US | North Dakota | Bowman | 38011 | 891 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-09-10 04:21:10 | Bowman, North Dakota, US | |
256337 | 256337 | 2022-09-08 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-09 04:21:11 | Baylor, Texas, US | |
3748135 | 3748135 | 2022-09-07 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-08 04:21:02 | Baylor, Texas, US | |
117775 | 117775 | 2022-09-06 | US | Texas | Baylor | 48023 | 891 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-09-07 04:20:59 | Baylor, Texas, US | |
3777150 | 3777150 | 2022-08-30 | US | Texas | Upton | 48461 | 891 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-08-31 04:20:57 | Upton, Texas, US | |
1682593 | 1682593 | 2022-08-29 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-30 04:21:03 | Johnson, Nebraska, US | |
1879077 | 1879077 | 2022-08-28 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-29 04:21:06 | Johnson, Nebraska, US | |
2098204 | 2098204 | 2022-08-27 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-28 04:21:02 | Johnson, Nebraska, US | |
1534019 | 1534019 | 2022-08-26 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-27 04:20:57 | Johnson, Nebraska, US | |
2830906 | 2830906 | 2022-08-25 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-26 04:21:02 | Johnson, Nebraska, US | |
2325439 | 2325439 | 2022-08-24 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-25 04:21:13 | Johnson, Nebraska, US | |
1252848 | 1252848 | 2022-08-23 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-24 04:20:46 | Johnson, Nebraska, US | |
2854952 | 2854952 | 2022-08-22 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-23 04:20:56 | Johnson, Nebraska, US | |
2404924 | 2404924 | 2022-08-21 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-22 04:20:38 | Johnson, Nebraska, US | |
3800002 | 3800002 | 2022-08-20 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-21 04:20:44 | Johnson, Nebraska, US | |
2365588 | 2365588 | 2022-08-19 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-20 04:21:01 | Johnson, Nebraska, US | |
1163259 | 1163259 | 2022-08-18 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-19 04:20:54 | Johnson, Nebraska, US | |
3952583 | 3952583 | 2022-08-17 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-18 04:21:11 | Johnson, Nebraska, US | |
993085 | 993085 | 2022-08-16 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-17 04:20:59 | Johnson, Nebraska, US | |
2496124 | 2496124 | 2022-08-15 | US | Nebraska | Johnson | 31097 | 891 | 9 | 0 | 40.39257596 | -96.26522753 | 2022-08-16 04:20:58 | Johnson, Nebraska, US | |
1406357 | 1406357 | 2022-08-02 | US | Kansas | Logan | 20109 | 891 | 13 | 0 | 38.91735806 | -101.148475 | 2022-08-03 04:20:59 | Logan, Kansas, US | |
3618395 | 3618395 | 2022-08-01 | US | Kansas | Logan | 20109 | 891 | 13 | 0 | 38.91735806 | -101.148475 | 2022-08-02 04:20:53 | Logan, Kansas, US | |
3873957 | 3873957 | 2022-07-31 | US | North Dakota | Cavalier | 38019 | 891 | 7 | 0 | 48.77286211 | -98.46685243 | 2022-08-01 04:21:03 | Cavalier, North Dakota, US | |
3872875 | 3872875 | 2022-07-31 | US | Kansas | Logan | 20109 | 891 | 13 | 0 | 38.91735806 | -101.148475 | 2022-08-01 04:21:03 | Logan, Kansas, US | |
675629 | 675629 | 2022-07-30 | US | Kansas | Logan | 20109 | 891 | 13 | 0 | 38.91735806 | -101.148475 | 2022-07-31 04:21:02 | Logan, Kansas, US | |
1784828 | 1784828 | 2022-07-29 | US | Kansas | Logan | 20109 | 891 | 13 | 0 | 38.91735806 | -101.148475 | 2022-07-30 04:20:42 | Logan, Kansas, US | |
1067191 | 1067191 | 2022-07-28 | US | Kansas | Logan | 20109 | 891 | 13 | 0 | 38.91735806 | -101.148475 | 2022-07-29 04:20:45 | Logan, Kansas, US | |
2336710 | 2336710 | 2022-07-27 | US | Kansas | Logan | 20109 | 891 | 13 | 0 | 38.91735806 | -101.148475 | 2022-07-28 04:20:56 | Logan, Kansas, US | |
1420291 | 1420291 | 2022-07-08 | US | Texas | Reagan | 48383 | 891 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-07-09 04:20:59 | Reagan, Texas, US | |
2149416 | 2149416 | 2022-06-27 | US | Minnesota | Traverse | 27155 | 891 | 10 | 0 | 45.77298854 | -96.47062949 | 2022-06-28 04:20:58 | Traverse, Minnesota, US | |
2148245 | 2148245 | 2022-06-27 | US | Colorado | Baca | 8009 | 891 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-06-28 04:20:58 | Baca, Colorado, US | |
477217 | 477217 | 2022-06-26 | US | Minnesota | Traverse | 27155 | 891 | 10 | 0 | 45.77298854 | -96.47062949 | 2022-06-27 04:21:00 | Traverse, Minnesota, US | |
940592 | 940592 | 2022-06-25 | US | Minnesota | Traverse | 27155 | 891 | 10 | 0 | 45.77298854 | -96.47062949 | 2022-06-26 04:21:02 | Traverse, Minnesota, US | |
3348412 | 3348412 | 2022-06-24 | US | Minnesota | Traverse | 27155 | 891 | 10 | 0 | 45.77298854 | -96.47062949 | 2022-06-25 04:20:57 | Traverse, Minnesota, US | |
1650153 | 1650153 | 2022-06-23 | US | Minnesota | Traverse | 27155 | 891 | 10 | 0 | 45.77298854 | -96.47062949 | 2022-06-24 04:20:58 | Traverse, Minnesota, US | |
1112626 | 1112626 | 2022-05-21 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-22 04:20:52 | Cochran, Texas, US | |
1172250 | 1172250 | 2022-05-20 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-21 04:20:58 | Cochran, Texas, US | |
3899013 | 3899013 | 2022-05-19 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-20 04:20:57 | Cochran, Texas, US | |
3898752 | 3898752 | 2022-05-19 | US | Puerto Rico | Vieques | 72147 | 891 | 0 | 0 | 18.123276 | -65.440971 | 2022-05-20 04:20:57 | Vieques, Puerto Rico, US | |
1187797 | 1187797 | 2022-05-18 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-19 04:20:54 | Cochran, Texas, US | |
3585694 | 3585694 | 2022-05-17 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-18 04:20:50 | Cochran, Texas, US | |
1506651 | 1506651 | 2022-05-16 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-17 04:20:59 | Cochran, Texas, US | |
2087010 | 2087010 | 2022-05-15 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-16 04:20:47 | Cochran, Texas, US | |
3357720 | 3357720 | 2022-05-14 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-15 04:20:53 | Cochran, Texas, US | |
661365 | 661365 | 2022-05-13 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-14 04:20:48 | Cochran, Texas, US | |
2536448 | 2536448 | 2022-05-12 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-13 04:20:51 | Cochran, Texas, US | |
3447894 | 3447894 | 2022-05-11 | US | Texas | Cochran | 48079 | 891 | 23 | 0 | 33.60425307 | -102.8284499 | 2022-05-12 04:20:54 | Cochran, 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]);