johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
177 rows where confirmed = 4698 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
718297 | 718297 | 2022-12-04 | China | Yunnan | 4698 | 2 | 0 | 24.974 | 101.487 | 2022-12-05 04:20:58 | Yunnan, China | |||
2817281 | 2817281 | 2022-12-03 | US | Arkansas | Madison | 5087 | 4698 | 67 | 0 | 36.01038185 | -93.72524943 | 2022-12-04 04:20:56 | Madison, Arkansas, US | |
1623732 | 1623732 | 2022-11-22 | US | Washington | Pacific | 53049 | 4698 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-11-23 04:21:06 | Pacific, Washington, US | |
3463620 | 3463620 | 2022-11-21 | US | Washington | Pacific | 53049 | 4698 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-11-22 04:20:47 | Pacific, Washington, US | |
1643805 | 1643805 | 2022-11-20 | US | Washington | Pacific | 53049 | 4698 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-11-21 04:21:05 | Pacific, Washington, US | |
2067362 | 2067362 | 2022-11-19 | US | Washington | Pacific | 53049 | 4698 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-11-20 04:21:08 | Pacific, Washington, US | |
1758756 | 1758756 | 2022-11-18 | US | Washington | Pacific | 53049 | 4698 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-11-19 04:21:14 | Pacific, Washington, US | |
3029749 | 3029749 | 2022-11-17 | US | Washington | Pacific | 53049 | 4698 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-11-18 04:21:15 | Pacific, Washington, US | |
2489460 | 2489460 | 2022-11-16 | US | Washington | Pacific | 53049 | 4698 | 73 | 0 | 46.55418369 | -123.7285716 | 2022-11-17 04:21:11 | Pacific, Washington, US | |
713483 | 713483 | 2022-11-01 | US | Texas | Bosque | 48035 | 4698 | 74 | 0 | 31.89978581 | -97.63613524 | 2022-11-02 04:22:09 | Bosque, Texas, US | |
3287932 | 3287932 | 2022-10-31 | US | Texas | Bosque | 48035 | 4698 | 74 | 0 | 31.89978581 | -97.63613524 | 2022-11-01 04:22:36 | Bosque, Texas, US | |
3253556 | 3253556 | 2022-10-11 | US | Virginia | Rockbridge | 51163 | 4698 | 90 | 0 | 37.81204314 | -79.44605905 | 2022-10-12 04:22:51 | Rockbridge, Virginia, US | |
3252788 | 3252788 | 2022-10-11 | US | Oregon | Tillamook | 41057 | 4698 | 74 | 0 | 45.46248721 | -123.712066 | 2022-10-12 04:22:51 | Tillamook, Oregon, US | |
2970047 | 2970047 | 2022-10-10 | US | Oregon | Tillamook | 41057 | 4698 | 74 | 0 | 45.46248721 | -123.712066 | 2022-10-11 04:23:05 | Tillamook, Oregon, US | |
3100686 | 3100686 | 2022-10-09 | US | Texas | Tyler | 48457 | 4698 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-10-10 04:22:32 | Tyler, Texas, US | |
3100083 | 3100083 | 2022-10-09 | US | Oregon | Tillamook | 41057 | 4698 | 74 | 0 | 45.46248721 | -123.712066 | 2022-10-10 04:22:32 | Tillamook, Oregon, US | |
4005911 | 4005911 | 2022-10-08 | US | Texas | Tyler | 48457 | 4698 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-10-09 04:21:16 | Tyler, Texas, US | |
4005308 | 4005308 | 2022-10-08 | US | Oregon | Tillamook | 41057 | 4698 | 74 | 0 | 45.46248721 | -123.712066 | 2022-10-09 04:21:16 | Tillamook, Oregon, US | |
399508 | 399508 | 2022-10-07 | US | Texas | Tyler | 48457 | 4698 | 88 | 0 | 30.77031716 | -94.37690895 | 2022-10-08 04:22:56 | Tyler, Texas, US | |
398905 | 398905 | 2022-10-07 | US | Oregon | Tillamook | 41057 | 4698 | 74 | 0 | 45.46248721 | -123.712066 | 2022-10-08 04:22:56 | Tillamook, Oregon, US | |
2532022 | 2532022 | 2022-10-06 | US | Oregon | Tillamook | 41057 | 4698 | 74 | 0 | 45.46248721 | -123.712066 | 2022-10-07 04:23:08 | Tillamook, Oregon, US | |
1813416 | 1813416 | 2022-10-05 | US | Oregon | Tillamook | 41057 | 4698 | 74 | 0 | 45.46248721 | -123.712066 | 2022-10-06 04:21:22 | Tillamook, Oregon, US | |
1813368 | 1813368 | 2022-10-05 | US | Oklahoma | Pawnee | 40117 | 4698 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-10-06 04:21:22 | Pawnee, Oklahoma, US | |
133342 | 133342 | 2022-10-04 | US | Oklahoma | Pawnee | 40117 | 4698 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-10-05 04:23:06 | Pawnee, Oklahoma, US | |
131810 | 131810 | 2022-10-04 | US | Illinois | Warren | 17187 | 4698 | 87 | 0 | 40.84925021 | -90.6147432 | 2022-10-05 04:23:06 | Warren, Illinois, US | |
2688289 | 2688289 | 2022-10-03 | US | Oklahoma | Pawnee | 40117 | 4698 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-10-04 04:22:55 | Pawnee, Oklahoma, US | |
2262356 | 2262356 | 2022-10-02 | US | Oklahoma | Pawnee | 40117 | 4698 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-10-03 04:23:11 | Pawnee, Oklahoma, US | |
2997882 | 2997882 | 2022-10-01 | US | Oklahoma | Pawnee | 40117 | 4698 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-10-02 04:21:23 | Pawnee, Oklahoma, US | |
856208 | 856208 | 2022-09-30 | US | Oklahoma | Pawnee | 40117 | 4698 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-10-01 04:23:01 | Pawnee, Oklahoma, US | |
2378134 | 2378134 | 2022-09-29 | US | Oklahoma | Pawnee | 40117 | 4698 | 85 | 0 | 36.31743373 | -96.7033176 | 2022-09-30 04:23:09 | Pawnee, Oklahoma, US | |
3767258 | 3767258 | 2022-09-11 | US | Kentucky | Breathitt | 21025 | 4698 | 56 | 0 | 37.52333168 | -83.31959161 | 2022-09-12 04:20:58 | Breathitt, Kentucky, US | |
3766884 | 3766884 | 2022-09-11 | US | Illinois | Jo Daviess | 17085 | 4698 | 40 | 0 | 42.36542373 | -90.21094405 | 2022-09-12 04:20:58 | Jo Daviess, Illinois, US | |
3825833 | 3825833 | 2022-09-10 | US | Kentucky | Breathitt | 21025 | 4698 | 56 | 0 | 37.52333168 | -83.31959161 | 2022-09-11 04:20:50 | Breathitt, Kentucky, US | |
3825459 | 3825459 | 2022-09-10 | US | Illinois | Jo Daviess | 17085 | 4698 | 40 | 0 | 42.36542373 | -90.21094405 | 2022-09-11 04:20:50 | Jo Daviess, Illinois, US | |
964290 | 964290 | 2022-09-09 | US | Kentucky | Breathitt | 21025 | 4698 | 56 | 0 | 37.52333168 | -83.31959161 | 2022-09-10 04:21:10 | Breathitt, Kentucky, US | |
963916 | 963916 | 2022-09-09 | US | Illinois | Jo Daviess | 17085 | 4698 | 40 | 0 | 42.36542373 | -90.21094405 | 2022-09-10 04:21:10 | Jo Daviess, Illinois, US | |
254692 | 254692 | 2022-09-08 | US | Kentucky | Breathitt | 21025 | 4698 | 56 | 0 | 37.52333168 | -83.31959161 | 2022-09-09 04:21:11 | Breathitt, Kentucky, US | |
3746490 | 3746490 | 2022-09-07 | US | Kentucky | Breathitt | 21025 | 4698 | 56 | 0 | 37.52333168 | -83.31959161 | 2022-09-08 04:21:02 | Breathitt, Kentucky, US | |
116130 | 116130 | 2022-09-06 | US | Kentucky | Breathitt | 21025 | 4698 | 56 | 0 | 37.52333168 | -83.31959161 | 2022-09-07 04:20:59 | Breathitt, Kentucky, US | |
2990009 | 2990009 | 2022-09-04 | US | Puerto Rico | Arroyo | 72015 | 4698 | 0 | 0 | 17.998457 | -66.056546 | 2022-09-05 04:21:01 | Arroyo, Puerto Rico, US | |
3774663 | 3774663 | 2022-08-30 | US | Georgia | Ben Hill | 13017 | 4698 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-08-31 04:20:57 | Ben Hill, Georgia, US | |
1681259 | 1681259 | 2022-08-29 | US | Georgia | Ben Hill | 13017 | 4698 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-08-30 04:21:03 | Ben Hill, Georgia, US | |
1878375 | 1878375 | 2022-08-28 | US | Kentucky | Casey | 21045 | 4698 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-29 04:21:06 | Casey, Kentucky, US | |
1877743 | 1877743 | 2022-08-28 | US | Georgia | Ben Hill | 13017 | 4698 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-08-29 04:21:06 | Ben Hill, Georgia, US | |
2097502 | 2097502 | 2022-08-27 | US | Kentucky | Casey | 21045 | 4698 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-28 04:21:02 | Casey, Kentucky, US | |
2096870 | 2096870 | 2022-08-27 | US | Georgia | Ben Hill | 13017 | 4698 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-08-28 04:21:02 | Ben Hill, Georgia, US | |
1533317 | 1533317 | 2022-08-26 | US | Kentucky | Casey | 21045 | 4698 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-27 04:20:57 | Casey, Kentucky, US | |
1532685 | 1532685 | 2022-08-26 | US | Georgia | Ben Hill | 13017 | 4698 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-08-27 04:20:57 | Ben Hill, Georgia, US | |
2830204 | 2830204 | 2022-08-25 | US | Kentucky | Casey | 21045 | 4698 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-26 04:21:02 | Casey, Kentucky, US | |
2829572 | 2829572 | 2022-08-25 | US | Georgia | Ben Hill | 13017 | 4698 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-08-26 04:21:02 | Ben Hill, Georgia, US | |
2324737 | 2324737 | 2022-08-24 | US | Kentucky | Casey | 21045 | 4698 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-25 04:21:13 | Casey, Kentucky, US | |
2324105 | 2324105 | 2022-08-24 | US | Georgia | Ben Hill | 13017 | 4698 | 123 | 0 | 31.76095874 | -83.22145359 | 2022-08-25 04:21:13 | Ben Hill, Georgia, US | |
1252146 | 1252146 | 2022-08-23 | US | Kentucky | Casey | 21045 | 4698 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-24 04:20:46 | Casey, Kentucky, US | |
2854250 | 2854250 | 2022-08-22 | US | Kentucky | Casey | 21045 | 4698 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-23 04:20:56 | Casey, Kentucky, US | |
1407780 | 1407780 | 2022-08-02 | US | Puerto Rico | Comerio | 72045 | 4698 | 0 | 0 | 18.224687 | -66.221622 | 2022-08-03 04:20:59 | Comerio, Puerto Rico, US | |
900653 | 900653 | 2022-07-22 | US | Arkansas | Grant | 5053 | 4698 | 62 | 0 | 34.29017991 | -92.42320562 | 2022-07-23 04:20:53 | Grant, Arkansas, US | |
3365874 | 3365874 | 2022-07-02 | US | California | Colusa | 6011 | 4698 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-07-03 04:20:59 | Colusa, California, US | |
594203 | 594203 | 2022-07-01 | US | California | Colusa | 6011 | 4698 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-07-02 04:21:16 | Colusa, California, US | |
3940759 | 3940759 | 2022-06-30 | US | Florida | Gilchrist | 12041 | 4698 | 95 | 0 | 29.72856978 | -82.79880657 | 2022-07-01 04:21:10 | Gilchrist, Florida, US | |
2490717 | 2490717 | 2022-06-29 | US | Florida | Gilchrist | 12041 | 4698 | 95 | 0 | 29.72856978 | -82.79880657 | 2022-06-30 04:21:01 | Gilchrist, Florida, US | |
2240099 | 2240099 | 2022-06-28 | US | Florida | Gilchrist | 12041 | 4698 | 95 | 0 | 29.72856978 | -82.79880657 | 2022-06-29 04:20:59 | Gilchrist, Florida, US | |
2148341 | 2148341 | 2022-06-27 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-28 04:20:58 | Gilchrist, Florida, US | |
476142 | 476142 | 2022-06-26 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-27 04:21:00 | Gilchrist, Florida, US | |
939517 | 939517 | 2022-06-25 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-26 04:21:02 | Gilchrist, Florida, US | |
3347337 | 3347337 | 2022-06-24 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-25 04:20:57 | Gilchrist, Florida, US | |
1649078 | 1649078 | 2022-06-23 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-24 04:20:58 | Gilchrist, Florida, US | |
2188313 | 2188313 | 2022-06-22 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-23 04:20:55 | Gilchrist, Florida, US | |
166744 | 166744 | 2022-06-21 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-22 04:20:54 | Gilchrist, Florida, US | |
1764027 | 1764027 | 2022-06-20 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-21 04:20:56 | Gilchrist, Florida, US | |
3270213 | 3270213 | 2022-06-19 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-20 04:21:01 | Gilchrist, Florida, US | |
3398125 | 3398125 | 2022-06-18 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-19 04:20:51 | Gilchrist, Florida, US | |
2312002 | 2312002 | 2022-06-17 | US | Florida | Gilchrist | 12041 | 4698 | 94 | 0 | 29.72856978 | -82.79880657 | 2022-06-18 04:21:10 | Gilchrist, Florida, US | |
3985815 | 3985815 | 2022-06-15 | US | Texas | Reeves | 48389 | 4698 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-06-16 04:20:55 | Reeves, Texas, US | |
3508359 | 3508359 | 2022-06-05 | US | Illinois | Cass | 17017 | 4698 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-06-06 04:20:57 | Cass, Illinois, US | |
3528436 | 3528436 | 2022-06-04 | US | Illinois | Cass | 17017 | 4698 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-06-05 04:20:55 | Cass, Illinois, US | |
3527995 | 3527995 | 2022-06-04 | US | Arkansas | Sharp | 5135 | 4698 | 108 | 0 | 36.16258158 | -91.47819342 | 2022-06-05 04:20:55 | Sharp, Arkansas, US | |
3134522 | 3134522 | 2022-06-03 | US | Illinois | Cass | 17017 | 4698 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-06-04 04:20:58 | Cass, Illinois, US | |
3579111 | 3579111 | 2022-06-02 | US | Arkansas | Drew | 5043 | 4698 | 70 | 0 | 33.59035001 | -91.71777921 | 2022-06-03 04:20:58 | Drew, Arkansas, US | |
3585561 | 3585561 | 2022-05-17 | US | Tennessee | Bledsoe | 47007 | 4698 | 58 | 0 | 35.59942968 | -85.20611967 | 2022-05-18 04:20:50 | Bledsoe, Tennessee, US | |
943973 | 943973 | 2022-02-28 | US | Indiana | Starke | 18149 | 4698 | 89 | 0 | 41.27890281 | -86.64686895 | 2022-03-01 04:21:09 | Starke, Indiana, US | |
3913436 | 3913436 | 2022-02-20 | US | Kentucky | Henry | 21103 | 4698 | 46 | 0 | 38.44942688 | -85.11587507 | 2022-02-21 04:21:05 | Henry, Kentucky, US | |
3876994 | 3876994 | 2022-02-19 | US | Kentucky | Henry | 21103 | 4698 | 46 | 0 | 38.44942688 | -85.11587507 | 2022-02-20 04:21:00 | Henry, Kentucky, US | |
3857250 | 3857250 | 2022-02-18 | US | Kentucky | Henry | 21103 | 4698 | 46 | 0 | 38.44942688 | -85.11587507 | 2022-02-19 04:21:11 | Henry, Kentucky, US | |
2645077 | 2645077 | 2022-02-14 | US | Virginia | Colonial Heights | 51570 | 4698 | 87 | 0 | 37.26420587 | -77.39609676 | 2022-02-15 04:21:09 | Colonial Heights, Virginia, US | |
187043 | 187043 | 2022-02-13 | US | Illinois | Clark | 17023 | 4698 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-14 04:20:51 | Clark, Illinois, US | |
316889 | 316889 | 2022-02-12 | US | Illinois | Clark | 17023 | 4698 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-13 04:21:00 | Clark, Illinois, US | |
234215 | 234215 | 2022-02-11 | US | Illinois | Clark | 17023 | 4698 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-12 04:21:06 | Clark, Illinois, US | |
1465057 | 1465057 | 2022-02-10 | US | Illinois | Clark | 17023 | 4698 | 47 | 0 | 39.33425789 | -87.78705622 | 2022-02-11 04:21:09 | Clark, Illinois, US | |
2477541 | 2477541 | 2022-02-03 | US | Wisconsin | Taylor | 55119 | 4698 | 65 | 0 | 45.21179252 | -90.5004405 | 2022-02-04 04:21:10 | Taylor, Wisconsin, US | |
2833306 | 2833306 | 2022-01-22 | US | Arkansas | Columbia | 5027 | 4698 | 77 | 0 | 33.21230701 | -93.22642793 | 2022-01-23 04:21:13 | Columbia, Arkansas, US | |
3467195 | 3467195 | 2022-01-18 | US | Texas | Austin | 48015 | 4698 | 58 | 0 | 29.88548725 | -96.27736949 | 2022-01-19 04:21:23 | Austin, Texas, US | |
2612419 | 2612419 | 2022-01-06 | US | North Carolina | Transylvania | 37175 | 4698 | 54 | 0 | 35.20383864 | -82.79638423 | 2022-01-07 04:22:09 | Transylvania, North Carolina, US | |
3522819 | 3522819 | 2022-01-02 | US | Virginia | Orange | 51137 | 4698 | 69 | 0 | 38.24530219 | -78.01560400000002 | 2022-01-03 02:22:25 | Orange, Virginia, US | |
2170949 | 2170949 | 2022-01-01 | US | Virginia | Orange | 51137 | 4698 | 69 | 0 | 38.24530219 | -78.01560400000002 | 2022-01-02 04:20:52 | Orange, Virginia, US | |
2780380 | 2780380 | 2021-12-31 | US | Virginia | Orange | 51137 | 4698 | 69 | 0 | 38.24530219 | -78.01560400000002 | 2022-01-01 04:22:14 | Orange, Virginia, US | |
2777647 | 2777647 | 2021-12-31 | US | Colorado | Routt | 8107 | 4698 | 24 | 0 | 40.48596505 | -106.9905548 | 2022-01-01 04:22:14 | Routt, Colorado, US | |
3499481 | 3499481 | 2021-12-15 | US | Vermont | Washington | 50023 | 4698 | 31 | 0 | 44.27343241 | -72.61604978 | 2021-12-16 04:22:11 | Washington, Vermont, US | |
1077942 | 1077942 | 2021-12-09 | Japan | Port Quarantine | 4698 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
550791 | 550791 | 2021-12-08 | Japan | Port Quarantine | 4698 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
1015785 | 1015785 | 2021-11-21 | US | Kentucky | Montgomery | 21173 | 4698 | 60 | 0 | 38.03253032 | -83.9145241 | 2021-11-22 04:22:20 | Montgomery, Kentucky, 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]);