johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
187 rows where confirmed = 5170 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331090 | 331090 | 2022-12-27 | US | Texas | Montague | 48337 | 5170 | 133 | 0 | 33.67521893 | -97.72500958 | 2022-12-28 04:21:04 | Montague, Texas, US | |
221163 | 221163 | 2022-12-26 | US | Texas | Montague | 48337 | 5170 | 133 | 0 | 33.67521893 | -97.72500958 | 2022-12-27 04:21:07 | Montague, Texas, US | |
3225620 | 3225620 | 2022-12-25 | US | Texas | Montague | 48337 | 5170 | 133 | 0 | 33.67521893 | -97.72500958 | 2022-12-26 04:21:06 | Montague, Texas, US | |
1021534 | 1021534 | 2022-12-24 | US | Texas | Montague | 48337 | 5170 | 133 | 0 | 33.67521893 | -97.72500958 | 2022-12-25 04:21:04 | Montague, Texas, US | |
693557 | 693557 | 2022-12-23 | US | Texas | Montague | 48337 | 5170 | 133 | 0 | 33.67521893 | -97.72500958 | 2022-12-24 04:21:02 | Montague, Texas, US | |
2182767 | 2182767 | 2022-12-22 | US | Texas | Montague | 48337 | 5170 | 133 | 0 | 33.67521893 | -97.72500958 | 2022-12-23 04:21:04 | Montague, Texas, US | |
454571 | 454571 | 2022-12-21 | US | Texas | Montague | 48337 | 5170 | 133 | 0 | 33.67521893 | -97.72500958 | 2022-12-22 04:20:56 | Montague, Texas, US | |
2952354 | 2952354 | 2022-12-20 | US | Illinois | Bond | 17005 | 5170 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-12-21 04:21:03 | Bond, Illinois, US | |
2137221 | 2137221 | 2022-12-01 | US | Illinois | White | 17193 | 5170 | 53 | 0 | 38.08706198 | -88.17657461 | 2022-12-02 04:21:07 | White, Illinois, US | |
2027675 | 2027675 | 2022-10-17 | US | Tennessee | Bledsoe | 47007 | 5170 | 62 | 0 | 35.59942968 | -85.20611967 | 2022-10-18 04:22:42 | Bledsoe, Tennessee, US | |
2162453 | 2162453 | 2022-10-16 | US | Tennessee | Bledsoe | 47007 | 5170 | 62 | 0 | 35.59942968 | -85.20611967 | 2022-10-17 04:20:31 | Bledsoe, Tennessee, US | |
518650 | 518650 | 2022-10-15 | US | Tennessee | Bledsoe | 47007 | 5170 | 62 | 0 | 35.59942968 | -85.20611967 | 2022-10-16 04:22:39 | Bledsoe, Tennessee, US | |
2035707 | 2035707 | 2022-10-14 | US | Tennessee | Bledsoe | 47007 | 5170 | 62 | 0 | 35.59942968 | -85.20611967 | 2022-10-15 04:22:00 | Bledsoe, Tennessee, US | |
3756395 | 3756395 | 2022-10-13 | US | Tennessee | Bledsoe | 47007 | 5170 | 62 | 0 | 35.59942968 | -85.20611967 | 2022-10-14 04:22:28 | Bledsoe, Tennessee, US | |
1812348 | 1812348 | 2022-10-05 | US | Maine | Washington | 23029 | 5170 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-10-06 04:21:22 | Washington, Maine, US | |
1561820 | 1561820 | 2022-09-28 | US | Minnesota | Houston | 27055 | 5170 | 21 | 0 | 43.67129565 | -91.49143057 | 2022-09-29 04:22:34 | Houston, Minnesota, US | |
3996363 | 3996363 | 2022-09-27 | US | Minnesota | Houston | 27055 | 5170 | 21 | 0 | 43.67129565 | -91.49143057 | 2022-09-28 04:23:01 | Houston, Minnesota, US | |
2770691 | 2770691 | 2022-09-26 | US | Minnesota | Houston | 27055 | 5170 | 21 | 0 | 43.67129565 | -91.49143057 | 2022-09-27 04:23:01 | Houston, Minnesota, US | |
1978344 | 1978344 | 2022-09-25 | US | Minnesota | Houston | 27055 | 5170 | 21 | 0 | 43.67129565 | -91.49143057 | 2022-09-26 04:20:52 | Houston, Minnesota, US | |
2651511 | 2651511 | 2022-09-24 | US | Minnesota | Houston | 27055 | 5170 | 21 | 0 | 43.67129565 | -91.49143057 | 2022-09-25 04:23:31 | Houston, Minnesota, US | |
385951 | 385951 | 2022-09-23 | US | Minnesota | Houston | 27055 | 5170 | 21 | 0 | 43.67129565 | -91.49143057 | 2022-09-24 04:21:40 | Houston, Minnesota, US | |
1626017 | 1626017 | 2022-09-22 | US | Minnesota | Houston | 27055 | 5170 | 21 | 0 | 43.67129565 | -91.49143057 | 2022-09-23 04:23:13 | Houston, Minnesota, US | |
1396595 | 1396595 | 2022-09-02 | US | Tennessee | Benton | 47005 | 5170 | 98 | 0 | 36.07110411 | -88.06849355 | 2022-09-03 04:21:04 | Benton, Tennessee, US | |
2403325 | 2403325 | 2022-08-21 | US | Arkansas | Hempstead | 5057 | 5170 | 73 | 0 | 33.73325583 | -93.66935133 | 2022-08-22 04:20:38 | Hempstead, Arkansas, US | |
3798403 | 3798403 | 2022-08-20 | US | Arkansas | Hempstead | 5057 | 5170 | 73 | 0 | 33.73325583 | -93.66935133 | 2022-08-21 04:20:44 | Hempstead, Arkansas, US | |
992122 | 992122 | 2022-08-16 | US | Indiana | Perry | 18123 | 5170 | 70 | 0 | 38.07809328 | -86.63741946 | 2022-08-17 04:20:59 | Perry, Indiana, US | |
2495161 | 2495161 | 2022-08-15 | US | Indiana | Perry | 18123 | 5170 | 70 | 0 | 38.07809328 | -86.63741946 | 2022-08-16 04:20:58 | Perry, Indiana, US | |
3872665 | 3872665 | 2022-07-31 | US | Indiana | Jay | 18075 | 5170 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-08-01 04:21:03 | Jay, Indiana, US | |
675419 | 675419 | 2022-07-30 | US | Indiana | Jay | 18075 | 5170 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-31 04:21:02 | Jay, Indiana, US | |
1784618 | 1784618 | 2022-07-29 | US | Indiana | Jay | 18075 | 5170 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-30 04:20:42 | Jay, Indiana, US | |
3430906 | 3430906 | 2022-07-14 | US | Missouri | New Madrid | 29143 | 5170 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-07-15 04:20:53 | New Madrid, Missouri, US | |
3111426 | 3111426 | 2022-07-13 | US | Missouri | New Madrid | 29143 | 5170 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-07-14 04:20:57 | New Madrid, Missouri, US | |
631849 | 631849 | 2022-07-12 | US | Missouri | New Madrid | 29143 | 5170 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-07-13 04:20:58 | New Madrid, Missouri, US | |
1213493 | 1213493 | 2022-07-11 | US | Missouri | New Madrid | 29143 | 5170 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-07-12 04:20:51 | New Madrid, Missouri, US | |
2790975 | 2790975 | 2022-07-10 | US | Missouri | New Madrid | 29143 | 5170 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-07-11 04:20:46 | New Madrid, Missouri, US | |
143928 | 143928 | 2022-07-09 | US | Missouri | New Madrid | 29143 | 5170 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-07-10 04:20:54 | New Madrid, Missouri, US | |
1419028 | 1419028 | 2022-07-08 | US | Missouri | New Madrid | 29143 | 5170 | 86 | 0 | 36.59666326 | -89.66070007 | 2022-07-09 04:20:59 | New Madrid, Missouri, US | |
2492227 | 2492227 | 2022-06-29 | US | New Mexico | Roosevelt | 35041 | 5170 | 98 | 0 | 34.02097406 | -103.4799493 | 2022-06-30 04:21:01 | Roosevelt, New Mexico, US | |
1650326 | 1650326 | 2022-06-23 | US | Missouri | Perry | 29157 | 5170 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-24 04:20:58 | Perry, Missouri, US | |
2189561 | 2189561 | 2022-06-22 | US | Missouri | Perry | 29157 | 5170 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-23 04:20:55 | Perry, Missouri, US | |
167992 | 167992 | 2022-06-21 | US | Missouri | Perry | 29157 | 5170 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-22 04:20:54 | Perry, Missouri, US | |
1765275 | 1765275 | 2022-06-20 | US | Missouri | Perry | 29157 | 5170 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-21 04:20:56 | Perry, Missouri, US | |
3271461 | 3271461 | 2022-06-19 | US | Missouri | Perry | 29157 | 5170 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-20 04:21:01 | Perry, Missouri, US | |
3399373 | 3399373 | 2022-06-18 | US | Missouri | Perry | 29157 | 5170 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-19 04:20:51 | Perry, Missouri, US | |
2313250 | 2313250 | 2022-06-17 | US | Missouri | Perry | 29157 | 5170 | 46 | 0 | 37.70660776 | -89.82741088 | 2022-06-18 04:21:10 | Perry, Missouri, US | |
559427 | 559427 | 2022-06-16 | US | Colorado | Elbert | 8039 | 5170 | 41 | 0 | 39.28656773 | -104.1358721 | 2022-06-17 04:20:56 | Elbert, Colorado, US | |
950174 | 950174 | 2022-06-14 | US | Virginia | Colonial Heights | 51570 | 5170 | 99 | 0 | 37.26420587 | -77.39609676 | 2022-06-15 04:20:54 | Colonial Heights, Virginia, US | |
950008 | 950008 | 2022-06-14 | US | Texas | Limestone | 48293 | 5170 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-06-15 04:20:54 | Limestone, Texas, US | |
3142046 | 3142046 | 2022-06-11 | US | Arkansas | Ashley | 5003 | 5170 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-06-12 04:20:53 | Ashley, Arkansas, US | |
3159615 | 3159615 | 2022-06-09 | US | Missouri | Vernon | 29217 | 5170 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-06-10 04:20:55 | Vernon, Missouri, US | |
1423082 | 1423082 | 2022-06-08 | US | Missouri | Vernon | 29217 | 5170 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-06-09 04:20:54 | Vernon, Missouri, US | |
3728196 | 3728196 | 2022-06-07 | US | Missouri | Vernon | 29217 | 5170 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-06-08 04:20:55 | Vernon, Missouri, US | |
3889598 | 3889598 | 2022-06-06 | US | Missouri | Vernon | 29217 | 5170 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-06-07 04:21:08 | Vernon, Missouri, US | |
3509367 | 3509367 | 2022-06-05 | US | Missouri | Vernon | 29217 | 5170 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-06-06 04:20:57 | Vernon, Missouri, US | |
3529444 | 3529444 | 2022-06-04 | US | Missouri | Vernon | 29217 | 5170 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-06-05 04:20:55 | Vernon, Missouri, US | |
3135530 | 3135530 | 2022-06-03 | US | Missouri | Vernon | 29217 | 5170 | 109 | 0 | 37.8457799 | -94.34127305 | 2022-06-04 04:20:58 | Vernon, Missouri, US | |
1504642 | 1504642 | 2022-05-16 | US | Illinois | Richland | 17159 | 5170 | 74 | 0 | 38.71240969 | -88.08475366 | 2022-05-17 04:20:59 | Richland, Illinois, US | |
2085338 | 2085338 | 2022-05-15 | US | Kentucky | Breckinridge | 21027 | 5170 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-05-16 04:20:47 | Breckinridge, Kentucky, US | |
3356048 | 3356048 | 2022-05-14 | US | Kentucky | Breckinridge | 21027 | 5170 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-05-15 04:20:53 | Breckinridge, Kentucky, US | |
659693 | 659693 | 2022-05-13 | US | Kentucky | Breckinridge | 21027 | 5170 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-05-14 04:20:48 | Breckinridge, Kentucky, US | |
2534776 | 2534776 | 2022-05-12 | US | Kentucky | Breckinridge | 21027 | 5170 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-05-13 04:20:51 | Breckinridge, Kentucky, US | |
3446222 | 3446222 | 2022-05-11 | US | Kentucky | Breckinridge | 21027 | 5170 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-05-12 04:20:54 | Breckinridge, Kentucky, US | |
3536839 | 3536839 | 2022-05-10 | US | Kentucky | Breckinridge | 21027 | 5170 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-05-11 04:20:48 | Breckinridge, Kentucky, US | |
223374 | 223374 | 2022-05-09 | US | Kentucky | Breckinridge | 21027 | 5170 | 78 | 0 | 37.77377239 | -86.42885017 | 2022-05-10 04:20:50 | Breckinridge, Kentucky, US | |
1846959 | 1846959 | 2022-04-18 | US | Illinois | Edgar | 17045 | 5170 | 59 | 0 | 39.6809186 | -87.74759563 | 2022-04-19 04:21:00 | Edgar, Illinois, US | |
3419879 | 3419879 | 2022-04-17 | US | Tennessee | Johnson | 47091 | 5170 | 93 | 0 | 36.45523950000001 | -81.84886538 | 2022-04-18 04:21:12 | Johnson, Tennessee, US | |
3417903 | 3417903 | 2022-04-17 | US | Illinois | Edgar | 17045 | 5170 | 59 | 0 | 39.6809186 | -87.74759563 | 2022-04-18 04:21:12 | Edgar, Illinois, US | |
306828 | 306828 | 2022-04-16 | US | Tennessee | Johnson | 47091 | 5170 | 93 | 0 | 36.45523950000001 | -81.84886538 | 2022-04-17 04:20:59 | Johnson, Tennessee, US | |
304852 | 304852 | 2022-04-16 | US | Illinois | Edgar | 17045 | 5170 | 59 | 0 | 39.6809186 | -87.74759563 | 2022-04-17 04:20:59 | Edgar, Illinois, US | |
2672773 | 2672773 | 2022-04-15 | US | Tennessee | Johnson | 47091 | 5170 | 93 | 0 | 36.45523950000001 | -81.84886538 | 2022-04-16 04:20:48 | Johnson, Tennessee, US | |
2670797 | 2670797 | 2022-04-15 | US | Illinois | Edgar | 17045 | 5170 | 59 | 0 | 39.6809186 | -87.74759563 | 2022-04-16 04:20:48 | Edgar, Illinois, US | |
3323242 | 3323242 | 2022-04-07 | US | Tennessee | Unicoi | 47171 | 5170 | 95 | 0 | 36.10890856 | -82.43709629 | 2022-04-08 04:20:48 | Unicoi, Tennessee, US | |
2803778 | 2803778 | 2022-04-06 | US | Tennessee | Unicoi | 47171 | 5170 | 95 | 0 | 36.10890856 | -82.43709629 | 2022-04-07 04:20:53 | Unicoi, Tennessee, US | |
2749410 | 2749410 | 2022-04-04 | US | Arkansas | Randolph | 5121 | 5170 | 86 | 0 | 36.3415714 | -91.02455531 | 2022-04-05 04:20:48 | Randolph, Arkansas, US | |
3730756 | 3730756 | 2022-04-03 | US | Arkansas | Randolph | 5121 | 5170 | 86 | 0 | 36.3415714 | -91.02455531 | 2022-04-04 04:20:51 | Randolph, Arkansas, US | |
500191 | 500191 | 2022-04-02 | US | Arkansas | Randolph | 5121 | 5170 | 85 | 0 | 36.3415714 | -91.02455531 | 2022-04-03 04:20:48 | Randolph, Arkansas, US | |
3351176 | 3351176 | 2022-04-01 | US | Arkansas | Randolph | 5121 | 5170 | 84 | 0 | 36.3415714 | -91.02455531 | 2022-04-02 04:20:47 | Randolph, Arkansas, US | |
1468980 | 1468980 | 2022-03-24 | US | Georgia | Tattnall | 13267 | 5170 | 130 | 0 | 32.04785085 | -82.05539188 | 2022-03-25 04:20:46 | Tattnall, Georgia, US | |
3023154 | 3023154 | 2022-03-23 | US | Georgia | Tattnall | 13267 | 5170 | 130 | 0 | 32.04785085 | -82.05539188 | 2022-03-24 04:20:43 | Tattnall, Georgia, US | |
695237 | 695237 | 2022-03-17 | US | Georgia | Mitchell | 13205 | 5170 | 115 | 0 | 31.22483255 | -84.19381821 | 2022-03-18 04:20:55 | Mitchell, Georgia, US | |
2320180 | 2320180 | 2022-03-16 | US | Georgia | Mitchell | 13205 | 5170 | 114 | 0 | 31.22483255 | -84.19381821 | 2022-03-17 04:20:56 | Mitchell, Georgia, US | |
262380 | 262380 | 2022-03-15 | US | Georgia | Mitchell | 13205 | 5170 | 114 | 0 | 31.22483255 | -84.19381821 | 2022-03-16 04:20:50 | Mitchell, Georgia, US | |
946393 | 946393 | 2022-02-28 | US | Wisconsin | Langlade | 55067 | 5170 | 78 | 0 | 45.26271619 | -89.07483625 | 2022-03-01 04:21:09 | Langlade, Wisconsin, US | |
3718977 | 3718977 | 2022-02-21 | US | Georgia | Dodge | 13091 | 5170 | 143 | 0 | 32.17265114 | -83.16948926 | 2022-02-22 04:21:01 | Dodge, Georgia, US | |
3878311 | 3878311 | 2022-02-19 | US | Puerto Rico | Cidra | 72041 | 5170 | 0 | 0 | 18.173559 | -66.161179 | 2022-02-20 04:21:00 | Cidra, Puerto Rico, US | |
2327877 | 2327877 | 2022-02-04 | US | Arkansas | Ouachita | 5103 | 5170 | 92 | 0 | 33.58839816 | -92.87795984 | 2022-02-05 04:21:05 | Ouachita, Arkansas, US | |
2474869 | 2474869 | 2022-02-03 | US | Hawaii | Out of HI | 80015 | 5170 | 12 | 0 | 22.03935037 | 0.0 | 2022-02-04 04:21:10 | Out of HI, Hawaii, US | |
1961990 | 1961990 | 2022-01-20 | US | Kentucky | Lincoln | 21137 | 5170 | 110 | 0 | 37.45475628 | -84.6565327 | 2022-01-21 04:21:09 | Lincoln, Kentucky, US | |
3465662 | 3465662 | 2022-01-18 | US | Kentucky | Woodford | 21239 | 5170 | 39 | 0 | 38.04178222 | -84.7417556 | 2022-01-19 04:21:23 | Woodford, Kentucky, US | |
3465285 | 3465285 | 2022-01-18 | US | Indiana | LaGrange | 18087 | 5170 | 96 | 0 | 41.64232188 | -85.42674232 | 2022-01-19 04:21:23 | LaGrange, Indiana, US | |
1474075 | 1474075 | 2022-01-17 | US | Missouri | Saline | 29195 | 5170 | 90 | 0 | 39.13734288 | -93.20259964 | 2022-01-18 04:21:04 | Saline, Missouri, US | |
556749 | 556749 | 2022-01-16 | US | Missouri | Saline | 29195 | 5170 | 90 | 0 | 39.13734288 | -93.20259964 | 2022-01-17 04:21:08 | Saline, Missouri, US | |
3842470 | 3842470 | 2022-01-15 | US | Missouri | Saline | 29195 | 5170 | 90 | 0 | 39.13734288 | -93.20259964 | 2022-01-16 04:21:12 | Saline, Missouri, US | |
128468 | 128468 | 2022-01-09 | US | Minnesota | Le Sueur | 27079 | 5170 | 43 | 0 | 44.37136597 | -93.72844721 | 2022-01-10 04:22:07 | Le Sueur, Minnesota, US | |
1217303 | 1217303 | 2022-01-08 | US | Minnesota | Le Sueur | 27079 | 5170 | 43 | 0 | 44.37136597 | -93.72844721 | 2022-01-09 04:21:46 | Le Sueur, Minnesota, US | |
1391396 | 1391396 | 2022-01-07 | US | Minnesota | Le Sueur | 27079 | 5170 | 43 | 0 | 44.37136597 | -93.72844721 | 2022-01-08 04:21:53 | Le Sueur, Minnesota, US | |
1286038 | 1286038 | 2022-01-04 | Japan | Yamanashi | 5170 | 29 | 0 | 35.612364 | 138.61148899999998 | 2022-01-05 04:21:59 | Yamanashi, Japan | |||
1433408 | 1433408 | 2021-12-28 | US | Georgia | Madison | 13195 | 5170 | 84 | 0 | 34.12920917 | -83.21218732 | 2021-12-29 03:21:43 | Madison, Georgia, US | |
798262 | 798262 | 2021-12-22 | Colombia | Guaviare | 5170 | 97 | 0 | 1.0654 | -73.2603 | 2021-12-23 04:21:21 | Guaviare, Colombia | |||
3828302 | 3828302 | 2021-12-21 | Colombia | Guaviare | 5170 | 97 | 0 | 1.0654 | -73.2603 | 2021-12-22 04:21:54 | Guaviare, Colombia |
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]);