johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
146 rows where confirmed = 5047 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1628114 | 1628114 | 2022-12-18 | China | Shanxi | 5047 | 0 | 0 | 37.5777 | 112.2922 | 2022-12-19 04:21:03 | Shanxi, China | |||
3378359 | 3378359 | 2022-12-08 | US | Illinois | De Witt | 17039 | 5047 | 41 | 0 | 40.17514519 | -88.90959682 | 2022-12-09 04:21:05 | De Witt, Illinois, US | |
2531260 | 2531260 | 2022-10-06 | US | Missouri | Benton | 29015 | 5047 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-10-07 04:23:08 | Benton, Missouri, US | |
1812654 | 1812654 | 2022-10-05 | US | Missouri | Benton | 29015 | 5047 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-10-06 04:21:22 | Benton, Missouri, US | |
132628 | 132628 | 2022-10-04 | US | Missouri | Benton | 29015 | 5047 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-10-05 04:23:06 | Benton, Missouri, US | |
2687575 | 2687575 | 2022-10-03 | US | Missouri | Benton | 29015 | 5047 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-10-04 04:22:55 | Benton, Missouri, US | |
2261642 | 2261642 | 2022-10-02 | US | Missouri | Benton | 29015 | 5047 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-10-03 04:23:11 | Benton, Missouri, US | |
2997168 | 2997168 | 2022-10-01 | US | Missouri | Benton | 29015 | 5047 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-10-02 04:21:23 | Benton, Missouri, US | |
855494 | 855494 | 2022-09-30 | US | Missouri | Benton | 29015 | 5047 | 110 | 0 | 38.29503305 | -93.28756116 | 2022-10-01 04:23:01 | Benton, Missouri, US | |
1977164 | 1977164 | 2022-09-25 | US | California | Colusa | 6011 | 5047 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-09-26 04:20:52 | Colusa, California, US | |
116016 | 116016 | 2022-09-06 | US | Kansas | Bourbon | 20011 | 5047 | 57 | 0 | 37.85508555 | -94.84865997 | 2022-09-07 04:20:59 | Bourbon, Kansas, US | |
2637247 | 2637247 | 2022-09-05 | US | West Virginia | Wetzel | 54103 | 5047 | 89 | 0 | 39.6065771 | -80.6401654 | 2022-09-06 04:21:02 | Wetzel, West Virginia, US | |
2634988 | 2634988 | 2022-09-05 | US | Kansas | Bourbon | 20011 | 5047 | 57 | 0 | 37.85508555 | -94.84865997 | 2022-09-06 04:21:02 | Bourbon, Kansas, US | |
2990811 | 2990811 | 2022-09-04 | US | West Virginia | Wetzel | 54103 | 5047 | 89 | 0 | 39.6065771 | -80.6401654 | 2022-09-05 04:21:01 | Wetzel, West Virginia, US | |
2988552 | 2988552 | 2022-09-04 | US | Kansas | Bourbon | 20011 | 5047 | 57 | 0 | 37.85508555 | -94.84865997 | 2022-09-05 04:21:01 | Bourbon, Kansas, US | |
2716496 | 2716496 | 2022-09-03 | US | West Virginia | Wetzel | 54103 | 5047 | 89 | 0 | 39.6065771 | -80.6401654 | 2022-09-04 04:21:22 | Wetzel, West Virginia, US | |
2714237 | 2714237 | 2022-09-03 | US | Kansas | Bourbon | 20011 | 5047 | 57 | 0 | 37.85508555 | -94.84865997 | 2022-09-04 04:21:22 | Bourbon, Kansas, US | |
1397201 | 1397201 | 2022-09-02 | US | West Virginia | Wetzel | 54103 | 5047 | 89 | 0 | 39.6065771 | -80.6401654 | 2022-09-03 04:21:04 | Wetzel, West Virginia, US | |
1394942 | 1394942 | 2022-09-02 | US | Kansas | Bourbon | 20011 | 5047 | 57 | 0 | 37.85508555 | -94.84865997 | 2022-09-03 04:21:04 | Bourbon, Kansas, US | |
3548771 | 3548771 | 2022-09-01 | US | Kansas | Bourbon | 20011 | 5047 | 57 | 0 | 37.85508555 | -94.84865997 | 2022-09-02 04:21:07 | Bourbon, Kansas, US | |
2344691 | 2344691 | 2022-08-31 | US | Kansas | Bourbon | 20011 | 5047 | 57 | 0 | 37.85508555 | -94.84865997 | 2022-09-01 04:21:03 | Bourbon, Kansas, US | |
2831831 | 2831831 | 2022-08-25 | US | Texas | Aransas | 48007 | 5047 | 91 | 0 | 28.10556197 | -96.9995047 | 2022-08-26 04:21:02 | Aransas, Texas, US | |
630286 | 630286 | 2022-07-12 | US | Alabama | Hale | 1065 | 5047 | 106 | 0 | 32.76039258 | -87.63284988 | 2022-07-13 04:20:58 | Hale, Alabama, US | |
475816 | 475816 | 2022-06-26 | US | Alabama | Fayette | 1057 | 5047 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-06-27 04:21:00 | Fayette, Alabama, US | |
939191 | 939191 | 2022-06-25 | US | Alabama | Fayette | 1057 | 5047 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-06-26 04:21:02 | Fayette, Alabama, US | |
3347011 | 3347011 | 2022-06-24 | US | Alabama | Fayette | 1057 | 5047 | 97 | 0 | 33.72076938 | -87.73886638 | 2022-06-25 04:20:57 | Fayette, Alabama, US | |
2311910 | 2311910 | 2022-06-17 | US | Colorado | Chaffee | 8015 | 5047 | 49 | 0 | 38.74745778 | -106.1926573 | 2022-06-18 04:21:10 | Chaffee, Colorado, US | |
2237103 | 2237103 | 2022-06-12 | US | Minnesota | Fillmore | 27045 | 5047 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-06-13 04:21:14 | Fillmore, Minnesota, US | |
3143301 | 3143301 | 2022-06-11 | US | Minnesota | Fillmore | 27045 | 5047 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-06-12 04:20:53 | Fillmore, Minnesota, US | |
1946217 | 1946217 | 2022-06-10 | US | Minnesota | Fillmore | 27045 | 5047 | 24 | 0 | 43.67394126 | -92.08980382 | 2022-06-11 04:21:01 | Fillmore, Minnesota, US | |
3579559 | 3579559 | 2022-06-02 | US | Idaho | Cassia | 16031 | 5047 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-03 04:20:58 | Cassia, Idaho, US | |
971852 | 971852 | 2022-06-01 | US | Idaho | Cassia | 16031 | 5047 | 53 | 0 | 42.28347888 | -113.6012409 | 2022-06-02 05:20:39 | Cassia, Idaho, US | |
2534434 | 2534434 | 2022-05-12 | US | Illinois | Pike | 17149 | 5047 | 67 | 0 | 39.62265059 | -90.8877017 | 2022-05-13 04:20:51 | Pike, Illinois, US | |
1573260 | 1573260 | 2022-05-03 | US | Indiana | Orange | 18117 | 5047 | 96 | 0 | 38.5411892 | -86.49523093 | 2022-05-04 04:20:59 | Orange, Indiana, US | |
464520 | 464520 | 2022-05-02 | US | Indiana | Orange | 18117 | 5047 | 96 | 0 | 38.5411892 | -86.49523093 | 2022-05-03 04:21:00 | Orange, Indiana, US | |
3917502 | 3917502 | 2022-05-01 | US | Kentucky | Rockcastle | 21203 | 5047 | 59 | 0 | 37.36642393 | -84.31176452 | 2022-05-02 04:21:10 | Rockcastle, Kentucky, US | |
2842306 | 2842306 | 2022-04-30 | US | Kentucky | Rockcastle | 21203 | 5047 | 59 | 0 | 37.36642393 | -84.31176452 | 2022-05-01 04:20:57 | Rockcastle, Kentucky, US | |
1158619 | 1158619 | 2022-04-29 | US | Kentucky | Rockcastle | 21203 | 5047 | 59 | 0 | 37.36642393 | -84.31176452 | 2022-04-30 04:21:05 | Rockcastle, Kentucky, US | |
1697801 | 1697801 | 2022-04-28 | US | Kentucky | Rockcastle | 21203 | 5047 | 59 | 0 | 37.36642393 | -84.31176452 | 2022-04-29 04:20:59 | Rockcastle, Kentucky, US | |
3853284 | 3853284 | 2022-04-27 | US | Kentucky | Rockcastle | 21203 | 5047 | 59 | 0 | 37.36642393 | -84.31176452 | 2022-04-28 04:20:47 | Rockcastle, Kentucky, US | |
1327714 | 1327714 | 2022-04-26 | US | Kentucky | Rockcastle | 21203 | 5047 | 59 | 0 | 37.36642393 | -84.31176452 | 2022-04-27 04:20:52 | Rockcastle, Kentucky, US | |
3723668 | 3723668 | 2022-04-25 | US | Kentucky | Rockcastle | 21203 | 5047 | 59 | 0 | 37.36642393 | -84.31176452 | 2022-04-26 04:20:51 | Rockcastle, Kentucky, US | |
1849370 | 1849370 | 2022-04-18 | US | Virginia | Prince Edward | 51147 | 5047 | 70 | 0 | 37.22554789 | -78.43597949 | 2022-04-19 04:21:00 | Prince Edward, Virginia, US | |
2321673 | 2321673 | 2022-03-16 | US | North Carolina | Madison | 37115 | 5047 | 79 | 0 | 35.85402722 | -82.71346418 | 2022-03-17 04:20:56 | Madison, North Carolina, US | |
263873 | 263873 | 2022-03-15 | US | North Carolina | Madison | 37115 | 5047 | 79 | 0 | 35.85402722 | -82.71346418 | 2022-03-16 04:20:50 | Madison, North Carolina, US | |
2200041 | 2200041 | 2022-03-06 | US | Alabama | Randolph | 1111 | 5047 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-03-07 04:20:47 | Randolph, Alabama, US | |
2092498 | 2092498 | 2022-03-05 | US | Alabama | Randolph | 1111 | 5047 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-03-06 04:20:49 | Randolph, Alabama, US | |
2666198 | 2666198 | 2022-03-04 | US | Alabama | Randolph | 1111 | 5047 | 74 | 0 | 33.29526734 | -85.45708831 | 2022-03-05 04:21:10 | Randolph, Alabama, US | |
1995301 | 1995301 | 2022-03-01 | US | Oregon | Wasco | 41065 | 5047 | 53 | 0 | 45.16292781 | -121.16709540000001 | 2022-03-02 04:21:07 | Wasco, Oregon, US | |
3878537 | 3878537 | 2022-02-19 | US | Tennessee | Johnson | 47091 | 5047 | 77 | 0 | 36.45523950000001 | -81.84886538 | 2022-02-20 04:21:00 | Johnson, Tennessee, US | |
186993 | 186993 | 2022-02-13 | US | Idaho | Blaine | 16013 | 5047 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-02-14 04:20:51 | Blaine, Idaho, US | |
316839 | 316839 | 2022-02-12 | US | Idaho | Blaine | 16013 | 5047 | 30 | 0 | 43.4085812 | -113.9752658 | 2022-02-13 04:21:00 | Blaine, Idaho, US | |
1362828 | 1362828 | 2022-02-08 | US | Arkansas | Columbia | 5027 | 5047 | 77 | 0 | 33.21230701 | -93.22642793 | 2022-02-09 04:21:04 | Columbia, Arkansas, US | |
2013844 | 2013844 | 2022-02-06 | US | Indiana | Spencer | 18147 | 5047 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-02-07 04:21:05 | Spencer, Indiana, US | |
1295173 | 1295173 | 2022-02-05 | US | Indiana | Spencer | 18147 | 5047 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-02-06 04:21:00 | Spencer, Indiana, US | |
2328501 | 2328501 | 2022-02-04 | US | Indiana | Spencer | 18147 | 5047 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-02-05 04:21:05 | Spencer, Indiana, US | |
2661133 | 2661133 | 2022-01-31 | US | Virginia | Fredericksburg | 51630 | 5047 | 29 | 0 | 38.2977863 | -77.4922454 | 2022-02-01 04:21:11 | Fredericksburg, Virginia, US | |
1782150 | 1782150 | 2022-01-27 | US | Puerto Rico | Moca | 72099 | 5047 | 0 | 0 | 18.377805 | -67.080952 | 2022-01-28 04:21:09 | Moca, Puerto Rico, US | |
2834421 | 2834421 | 2022-01-22 | US | Maryland | Talbot | 24041 | 5047 | 72 | 0 | 38.76618159 | -76.10882561 | 2022-01-23 04:21:13 | Talbot, Maryland, US | |
1962138 | 1962138 | 2022-01-20 | US | Maryland | Garrett | 24023 | 5047 | 103 | 0 | 39.52786077 | -79.27355126 | 2022-01-21 04:21:09 | Garrett, Maryland, US | |
3689056 | 3689056 | 2022-01-13 | US | Maryland | Caroline | 24011 | 5047 | 59 | 0 | 38.87172293 | -75.82904158 | 2022-01-14 04:21:54 | Caroline, Maryland, US | |
3615024 | 3615024 | 2022-01-12 | US | Missouri | Saline | 29195 | 5047 | 90 | 0 | 39.13734288 | -93.20259964 | 2022-01-13 08:00:09 | Saline, Missouri, US | |
1669959 | 1669959 | 2021-12-29 | US | Louisiana | De Soto | 22031 | 5047 | 115 | 0 | 32.05457447 | -93.74130302 | 2021-12-30 04:21:25 | De Soto, Louisiana, US | |
3497345 | 3497345 | 2021-12-15 | US | Indiana | White | 18181 | 5047 | 71 | 0 | 40.74911165 | -86.86492015 | 2021-12-16 04:22:11 | White, Indiana, US | |
1233847 | 1233847 | 2021-11-28 | US | New Mexico | Unassigned | 90035 | 5047 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-29 04:22:30 | Unassigned, New Mexico, US | |
1360554 | 1360554 | 2021-11-27 | US | New Mexico | Unassigned | 90035 | 5047 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-28 04:22:43 | Unassigned, New Mexico, US | |
760545 | 760545 | 2021-11-26 | US | New Mexico | Unassigned | 90035 | 5047 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-27 04:22:45 | Unassigned, New Mexico, US | |
1804962 | 1804962 | 2021-11-25 | US | New Mexico | Unassigned | 90035 | 5047 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-26 04:22:33 | Unassigned, New Mexico, US | |
906396 | 906396 | 2021-11-24 | US | New Mexico | Unassigned | 90035 | 5047 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-25 04:22:33 | Unassigned, New Mexico, US | |
3071041 | 3071041 | 2021-11-23 | US | Illinois | Lee | 17103 | 5047 | 65 | 0 | 41.74583951 | -89.29977132 | 2021-11-24 04:22:14 | Lee, Illinois, US | |
3749644 | 3749644 | 2021-11-22 | US | Arkansas | Poinsett | 5111 | 5047 | 102 | 0 | 35.57433534 | -90.66268713 | 2021-11-23 04:22:39 | Poinsett, Arkansas, US | |
3291173 | 3291173 | 2021-11-18 | US | New York | Otsego | 36077 | 5047 | 59 | 0 | 42.63492579 | -75.03151402 | 2021-11-19 04:21:40 | Otsego, New York, US | |
3344838 | 3344838 | 2021-11-16 | US | New Mexico | Unassigned | 90035 | 5047 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-17 04:21:48 | Unassigned, New Mexico, US | |
2289674 | 2289674 | 2021-11-15 | US | New Mexico | Unassigned | 90035 | 5047 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-11-16 04:21:10 | Unassigned, New Mexico, US | |
29430 | 29430 | 2021-11-11 | US | Illinois | Logan | 17107 | 5047 | 76 | 0 | 40.12581572 | -89.36638784 | 2021-11-12 04:22:01 | Logan, Illinois, US | |
2845869 | 2845869 | 2021-11-10 | US | Illinois | Logan | 17107 | 5047 | 76 | 0 | 40.12581572 | -89.36638784 | 2021-11-11 04:21:45 | Logan, Illinois, US | |
699845 | 699845 | 2021-11-04 | US | Kentucky | Marshall | 21157 | 5047 | 79 | 0 | 36.88007070000001 | -88.32803576 | 2021-11-05 04:21:54 | Marshall, Kentucky, US | |
3495294 | 3495294 | 2021-10-26 | US | Texas | Hopkins | 48223 | 5047 | 144 | 0 | 33.14875072 | -95.56351139 | 2021-10-27 04:22:32 | Hopkins, Texas, US | |
3797405 | 3797405 | 2021-10-25 | US | West Virginia | Randolph | 54083 | 5047 | 47 | 0 | 38.769899 | -79.87919615 | 2021-10-26 04:22:09 | Randolph, West Virginia, US | |
685793 | 685793 | 2021-10-24 | US | Washington | Okanogan | 53047 | 5047 | 78 | 0 | 48.54855019 | -119.73872240000001 | 2021-10-25 04:22:31 | Okanogan, Washington, US | |
773801 | 773801 | 2021-10-23 | US | Washington | Okanogan | 53047 | 5047 | 78 | 0 | 48.54855019 | -119.73872240000001 | 2021-10-24 04:21:22 | Okanogan, Washington, US | |
657448 | 657448 | 2021-10-22 | US | Washington | Okanogan | 53047 | 5047 | 78 | 0 | 48.54855019 | -119.73872240000001 | 2021-10-23 04:21:32 | Okanogan, Washington, US | |
1912638 | 1912638 | 2021-10-17 | US | Virginia | Wise | 51195 | 5047 | 123 | 0 | 36.9746148 | -82.62410519 | 2021-10-18 04:21:10 | Wise, Virginia, US | |
938227 | 938227 | 2021-10-16 | US | Virginia | Wise | 51195 | 5047 | 123 | 0 | 36.9746148 | -82.62410519 | 2021-10-17 04:21:29 | Wise, Virginia, US | |
2946782 | 2946782 | 2021-10-15 | US | Virginia | Wise | 51195 | 5047 | 123 | 0 | 36.9746148 | -82.62410519 | 2021-10-16 04:21:15 | Wise, Virginia, US | |
1492991 | 1492991 | 2021-10-12 | US | Kentucky | Clay | 21051 | 5047 | 56 | 0 | 37.16451126 | -83.712575 | 2021-10-13 04:20:51 | Clay, Kentucky, US | |
3009032 | 3009032 | 2021-10-11 | US | Minnesota | Becker | 27005 | 5047 | 62 | 0 | 46.93479392 | -95.67158144 | 2021-10-12 04:21:09 | Becker, Minnesota, US | |
470531 | 470531 | 2021-10-07 | US | Texas | Hockley | 48219 | 5047 | 128 | 0 | 33.60771256 | -102.3431676 | 2021-10-08 04:21:25 | Hockley, Texas, US | |
3833473 | 3833473 | 2021-10-05 | US | Illinois | Fulton | 17057 | 5047 | 71 | 0 | 40.47289135 | -90.20862357 | 2021-10-06 04:21:33 | Fulton, Illinois, US | |
988078 | 988078 | 2021-10-04 | US | Indiana | Jasper | 18073 | 5047 | 64 | 0 | 41.02078733 | -87.11553319 | 2021-10-05 04:21:27 | Jasper, Indiana, US | |
1725950 | 1725950 | 2021-09-25 | US | Kentucky | Muhlenberg | 21177 | 5047 | 83 | 0 | 37.21425819 | -87.14632053 | 2021-09-26 04:21:29 | Muhlenberg, Kentucky, US | |
3014038 | 3014038 | 2021-09-22 | US | Pennsylvania | Venango | 42121 | 5047 | 109 | 0 | 41.40323442 | -79.75845449 | 2021-09-23 04:21:43 | Venango, Pennsylvania, US | |
1814530 | 1814530 | 2021-09-19 | Brunei | 5047 | 26 | 0 | 4.5353 | 114.7277 | 2021-09-20 04:21:22 | Brunei | ||||
644393 | 644393 | 2021-09-07 | US | Ohio | Defiance | 39039 | 5047 | 101 | 0 | 41.32398837 | -84.49076944 | 2021-09-08 04:21:31 | Defiance, Ohio, US | |
70620 | 70620 | 2021-09-01 | US | Wisconsin | Marinette | 55075 | 5047 | 77 | 0 | 45.38553432 | -88.03324599999998 | 2021-09-02 04:21:15 | Marinette, Wisconsin, US | |
2796198 | 2796198 | 2021-08-28 | US | Texas | Matagorda | 48321 | 5047 | 118 | 0 | 28.81955746 | -96.01230294 | 2021-08-29 04:21:14 | Matagorda, Texas, US | |
3166543 | 3166543 | 2021-08-23 | US | Idaho | Bingham | 16011 | 5047 | 78 | 0 | 43.21672879999999 | -112.3978437 | 2021-08-24 04:21:19 | Bingham, Idaho, US | |
1117438 | 1117438 | 2021-08-06 | Colombia | Guaviare | 5047 | 91 | 0 | 1.0654 | -73.2603 | 2021-08-07 04:21:30 | Guaviare, Colombia | |||
1960096 | 1960096 | 2021-08-05 | US | Wisconsin | Pierce | 55093 | 5047 | 44 | 0 | 44.71850291 | -92.4224416 | 2021-08-06 04:21:18 | Pierce, Wisconsin, US | |
3387760 | 3387760 | 2021-07-29 | US | North Carolina | Vance | 37181 | 5047 | 90 | 0 | 36.36880673 | -78.40670845 | 2021-07-30 04:21:34 | Vance, North Carolina, 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]);