johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
198 rows where confirmed = 3161 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1643600 | 1643600 | 2022-11-20 | US | Texas | Ward | 48475 | 3161 | 49 | 0 | 31.50999644 | -103.0927909 | 2022-11-21 04:21:05 | Ward, Texas, US | |
1641796 | 1641796 | 2022-11-20 | US | Kentucky | McLean | 21149 | 3161 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-11-21 04:21:05 | McLean, Kentucky, US | |
2067157 | 2067157 | 2022-11-19 | US | Texas | Ward | 48475 | 3161 | 49 | 0 | 31.50999644 | -103.0927909 | 2022-11-20 04:21:08 | Ward, Texas, US | |
2065353 | 2065353 | 2022-11-19 | US | Kentucky | McLean | 21149 | 3161 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-11-20 04:21:08 | McLean, Kentucky, US | |
1758551 | 1758551 | 2022-11-18 | US | Texas | Ward | 48475 | 3161 | 49 | 0 | 31.50999644 | -103.0927909 | 2022-11-19 04:21:14 | Ward, Texas, US | |
1756747 | 1756747 | 2022-11-18 | US | Kentucky | McLean | 21149 | 3161 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-11-19 04:21:14 | McLean, Kentucky, US | |
3027740 | 3027740 | 2022-11-17 | US | Kentucky | McLean | 21149 | 3161 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-11-18 04:21:15 | McLean, Kentucky, US | |
2489324 | 2489324 | 2022-11-16 | US | Virginia | Charlotte | 51037 | 3161 | 49 | 0 | 37.01909701 | -78.66314092 | 2022-11-17 04:21:11 | Charlotte, Virginia, US | |
2487451 | 2487451 | 2022-11-16 | US | Kentucky | McLean | 21149 | 3161 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-11-17 04:21:11 | McLean, Kentucky, US | |
294233 | 294233 | 2022-11-15 | US | New Mexico | Torrance | 35057 | 3161 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-11-16 04:21:09 | Torrance, New Mexico, US | |
293462 | 293462 | 2022-11-15 | US | Kentucky | McLean | 21149 | 3161 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-11-16 04:21:09 | McLean, Kentucky, US | |
3598492 | 3598492 | 2022-11-14 | US | Kentucky | McLean | 21149 | 3161 | 59 | 0 | 37.5301951 | -87.26803443 | 2022-11-15 04:21:16 | McLean, Kentucky, US | |
3217849 | 3217849 | 2022-10-12 | US | Wisconsin | Forest | 55041 | 3161 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-10-13 04:22:39 | Forest, Wisconsin, US | |
2637025 | 2637025 | 2022-09-05 | US | Virginia | Amelia | 51007 | 3161 | 59 | 0 | 37.34081025 | -77.98584649 | 2022-09-06 04:21:02 | Amelia, Virginia, US | |
1164366 | 1164366 | 2022-08-18 | US | Texas | Pecos | 48371 | 3161 | 71 | 0 | 30.78097267 | -102.7241261 | 2022-08-19 04:20:54 | Pecos, Texas, US | |
992015 | 992015 | 2022-08-16 | US | Illinois | Marshall | 17123 | 3161 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-08-17 04:20:59 | Marshall, Illinois, US | |
1406298 | 1406298 | 2022-08-02 | US | Iowa | Winnebago | 19189 | 3161 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-08-03 04:20:59 | Winnebago, Iowa, US | |
3618336 | 3618336 | 2022-08-01 | US | Iowa | Winnebago | 19189 | 3161 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-08-02 04:20:53 | Winnebago, Iowa, US | |
3872816 | 3872816 | 2022-07-31 | US | Iowa | Winnebago | 19189 | 3161 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-08-01 04:21:03 | Winnebago, Iowa, US | |
675570 | 675570 | 2022-07-30 | US | Iowa | Winnebago | 19189 | 3161 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-31 04:21:02 | Winnebago, Iowa, US | |
1784769 | 1784769 | 2022-07-29 | US | Iowa | Winnebago | 19189 | 3161 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-30 04:20:42 | Winnebago, Iowa, US | |
1067132 | 1067132 | 2022-07-28 | US | Iowa | Winnebago | 19189 | 3161 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-29 04:20:45 | Winnebago, Iowa, US | |
2336651 | 2336651 | 2022-07-27 | US | Iowa | Winnebago | 19189 | 3161 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-28 04:20:56 | Winnebago, Iowa, US | |
900766 | 900766 | 2022-07-22 | US | Colorado | Archuleta | 8007 | 3161 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-07-23 04:20:53 | Archuleta, Colorado, US | |
1200291 | 1200291 | 2022-07-06 | US | Arkansas | Desha | 5041 | 3161 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-07-07 04:20:55 | Desha, Arkansas, US | |
1767159 | 1767159 | 2022-07-03 | China | Zhejiang | 3161 | 1 | 0 | 29.1832 | 120.0934 | 2022-07-04 04:20:54 | Zhejiang, China | |||
168793 | 168793 | 2022-06-21 | US | Puerto Rico | Hormigueros | 72067 | 3161 | 0 | 0 | 18.134532 | -67.113972 | 2022-06-22 04:20:54 | Hormigueros, Puerto Rico, US | |
3891224 | 3891224 | 2022-06-06 | US | Wyoming | Converse | 56009 | 3161 | 55 | 0 | 42.97272268 | -105.5081848 | 2022-06-07 04:21:08 | Converse, Wyoming, US | |
3887656 | 3887656 | 2022-06-06 | Kiribati | 3161 | 13 | 0 | -3.3704 | -168.734 | 2022-06-07 04:21:08 | Kiribati | ||||
3510993 | 3510993 | 2022-06-05 | US | Wyoming | Converse | 56009 | 3161 | 55 | 0 | 42.97272268 | -105.5081848 | 2022-06-06 04:20:57 | Converse, Wyoming, US | |
3507425 | 3507425 | 2022-06-05 | Kiribati | 3161 | 13 | 0 | -3.3704 | -168.734 | 2022-06-06 04:20:57 | Kiribati | ||||
3531070 | 3531070 | 2022-06-04 | US | Wyoming | Converse | 56009 | 3161 | 55 | 0 | 42.97272268 | -105.5081848 | 2022-06-05 04:20:55 | Converse, Wyoming, US | |
3137156 | 3137156 | 2022-06-03 | US | Wyoming | Converse | 56009 | 3161 | 55 | 0 | 42.97272268 | -105.5081848 | 2022-06-04 04:20:58 | Converse, Wyoming, US | |
3582231 | 3582231 | 2022-06-02 | US | Wyoming | Converse | 56009 | 3161 | 55 | 0 | 42.97272268 | -105.5081848 | 2022-06-03 04:20:58 | Converse, Wyoming, US | |
974524 | 974524 | 2022-06-01 | US | Wyoming | Converse | 56009 | 3161 | 55 | 0 | 42.97272268 | -105.5081848 | 2022-06-02 05:20:39 | Converse, Wyoming, US | |
232831 | 232831 | 2022-05-31 | US | Wyoming | Converse | 56009 | 3161 | 55 | 0 | 42.97272268 | -105.5081848 | 2022-06-01 04:20:55 | Converse, Wyoming, US | |
2049576 | 2049576 | 2022-05-25 | US | Minnesota | Chippewa | 27023 | 3161 | 48 | 0 | 45.02343421 | -95.56403693 | 2022-05-26 04:20:50 | Chippewa, Minnesota, US | |
2049432 | 2049432 | 2022-05-25 | US | Maine | Piscataquis | 23021 | 3161 | 31 | 0 | 45.83839062 | -69.2860223 | 2022-05-26 04:20:50 | Piscataquis, Maine, US | |
623587 | 623587 | 2022-05-22 | US | Minnesota | Chippewa | 27023 | 3161 | 48 | 0 | 45.02343421 | -95.56403693 | 2022-05-26 04:20:50 | Chippewa, Minnesota, US | |
623443 | 623443 | 2022-05-22 | US | Maine | Piscataquis | 23021 | 3161 | 31 | 0 | 45.83839062 | -69.2860223 | 2022-05-26 04:20:50 | Piscataquis, Maine, US | |
3897547 | 3897547 | 2022-05-19 | US | Maryland | Kent | 24029 | 3161 | 66 | 0 | 39.24976208 | -76.04741541 | 2022-05-20 04:20:57 | Kent, Maryland, US | |
3024972 | 3024972 | 2022-03-23 | US | Pennsylvania | Potter | 42105 | 3161 | 91 | 0 | 41.74471626 | -77.89559864 | 2022-03-24 04:20:43 | Potter, Pennsylvania, US | |
1513023 | 1513023 | 2022-02-24 | US | Michigan | Arenac | 26011 | 3161 | 62 | 0 | 44.0636262 | -83.89277559 | 2022-02-25 04:21:11 | Arenac, Michigan, US | |
1059464 | 1059464 | 2022-02-23 | US | Michigan | Arenac | 26011 | 3161 | 62 | 0 | 44.0636262 | -83.89277559 | 2022-02-24 04:21:14 | Arenac, Michigan, US | |
1299904 | 1299904 | 2022-02-17 | US | Mississippi | Tallahatchie | 28135 | 3161 | 60 | 0 | 33.95339918 | -90.1729398 | 2022-02-18 04:21:04 | Tallahatchie, Mississippi, US | |
3823396 | 3823396 | 2022-02-16 | US | Tennessee | Jackson | 47087 | 3161 | 56 | 0 | 36.36380466 | -85.67239905 | 2022-02-17 04:20:56 | Jackson, Tennessee, US | |
3822290 | 3822290 | 2022-02-16 | US | Mississippi | Tallahatchie | 28135 | 3161 | 59 | 0 | 33.95339918 | -90.1729398 | 2022-02-17 04:20:56 | Tallahatchie, Mississippi, US | |
2644169 | 2644169 | 2022-02-14 | US | North Dakota | Mountrail | 38061 | 3161 | 34 | 0 | 48.20197971 | -102.3555315 | 2022-02-15 04:21:09 | Mountrail, North Dakota, US | |
1363208 | 1363208 | 2022-02-08 | US | Georgia | Oglethorpe | 13221 | 3161 | 47 | 0 | 33.878629600000004 | -83.08278123 | 2022-02-09 04:21:04 | Oglethorpe, Georgia, US | |
72659 | 72659 | 2022-02-07 | US | Maine | Washington | 23029 | 3161 | 45 | 0 | 45.01607142 | -67.62813524 | 2022-02-08 04:21:15 | Washington, Maine, US | |
2014275 | 2014275 | 2022-02-06 | US | Maine | Washington | 23029 | 3161 | 45 | 0 | 45.01607142 | -67.62813524 | 2022-02-07 04:21:05 | Washington, Maine, US | |
1295604 | 1295604 | 2022-02-05 | US | Maine | Washington | 23029 | 3161 | 45 | 0 | 45.01607142 | -67.62813524 | 2022-02-06 04:21:00 | Washington, Maine, US | |
2328932 | 2328932 | 2022-02-04 | US | Maine | Washington | 23029 | 3161 | 45 | 0 | 45.01607142 | -67.62813524 | 2022-02-05 04:21:05 | Washington, Maine, US | |
2327870 | 2327870 | 2022-02-04 | US | Arkansas | Marion | 5089 | 3161 | 76 | 0 | 36.26844485 | -92.68451899 | 2022-02-05 04:21:05 | Marion, Arkansas, US | |
2474461 | 2474461 | 2022-02-03 | US | Arkansas | Marion | 5089 | 3161 | 76 | 0 | 36.26844485 | -92.68451899 | 2022-02-04 04:21:10 | Marion, Arkansas, US | |
980424 | 980424 | 2022-02-01 | US | Kentucky | Trigg | 21221 | 3161 | 36 | 0 | 36.80767017 | -87.87333656 | 2022-02-02 04:21:09 | Trigg, Kentucky, US | |
1285582 | 1285582 | 2022-01-05 | US | Wisconsin | Washburn | 55129 | 3161 | 37 | 0 | 45.89838588 | -91.79050449 | 2022-01-06 04:22:09 | Washburn, Wisconsin, US | |
1435998 | 1435998 | 2021-12-28 | US | Washington | Asotin | 53003 | 3161 | 52 | 0 | 46.18894415 | -117.2022851 | 2021-12-29 03:21:43 | Asotin, Washington, US | |
733959 | 733959 | 2021-12-27 | US | Washington | Asotin | 53003 | 3161 | 52 | 0 | 46.18894415 | -117.2022851 | 2021-12-28 04:21:47 | Asotin, Washington, US | |
2112459 | 2112459 | 2021-12-26 | US | Georgia | Brantley | 13025 | 3161 | 89 | 0 | 31.19576557 | -81.97743999 | 2021-12-27 04:21:58 | Brantley, Georgia, US | |
3605831 | 3605831 | 2021-12-25 | US | Georgia | Brantley | 13025 | 3161 | 89 | 0 | 31.19576557 | -81.97743999 | 2021-12-26 04:21:50 | Brantley, Georgia, US | |
2966164 | 2966164 | 2021-12-24 | US | Puerto Rico | Rio Grande | 72119 | 3161 | 0 | 0 | 18.346329 | -65.813742 | 2021-12-25 04:21:37 | Rio Grande, Puerto Rico, US | |
2964149 | 2964149 | 2021-12-24 | US | Georgia | Brantley | 13025 | 3161 | 89 | 0 | 31.19576557 | -81.97743999 | 2021-12-25 04:21:37 | Brantley, Georgia, US | |
3819196 | 3819196 | 2021-12-23 | US | Puerto Rico | Rio Grande | 72119 | 3161 | 0 | 0 | 18.346329 | -65.813742 | 2021-12-24 04:21:34 | Rio Grande, Puerto Rico, US | |
3819113 | 3819113 | 2021-12-23 | US | Pennsylvania | Montour | 42093 | 3161 | 81 | 0 | 41.03023987 | -76.66345939 | 2021-12-24 04:21:34 | Montour, Pennsylvania, US | |
3817181 | 3817181 | 2021-12-23 | US | Georgia | Brantley | 13025 | 3161 | 89 | 0 | 31.19576557 | -81.97743999 | 2021-12-24 04:21:34 | Brantley, Georgia, US | |
1719753 | 1719753 | 2021-12-16 | US | Virginia | Radford | 51750 | 3161 | 37 | 0 | 37.12222899 | -80.56027320000003 | 2021-12-17 04:22:14 | Radford, Virginia, US | |
1718847 | 1718847 | 2021-12-16 | US | Ohio | Meigs | 39105 | 3161 | 69 | 0 | 39.09224872 | -82.0305041 | 2021-12-17 04:22:14 | Meigs, Ohio, US | |
1717328 | 1717328 | 2021-12-16 | US | Illinois | Clay | 17025 | 3161 | 55 | 0 | 38.75388572 | -88.48914513 | 2021-12-17 04:22:14 | Clay, Illinois, US | |
2089010 | 2089010 | 2021-12-14 | US | Illinois | Pike | 17149 | 3161 | 58 | 0 | 39.62265059 | -90.8877017 | 2021-12-15 03:22:16 | Pike, Illinois, US | |
785215 | 785215 | 2021-12-13 | US | South Carolina | Hampton | 45049 | 3161 | 75 | 0 | 32.77419582 | -81.13845571 | 2021-12-14 04:22:38 | Hampton, South Carolina, US | |
3656213 | 3656213 | 2021-12-10 | US | Colorado | Elbert | 8039 | 3161 | 30 | 0 | 39.28656773 | -104.13587209999999 | 2021-12-11 04:22:45 | Elbert, Colorado, US | |
1742407 | 1742407 | 2021-12-05 | US | Missouri | Andrew | 29003 | 3161 | 38 | 0 | 39.98492163 | -94.80163024 | 2021-12-06 04:22:34 | Andrew, Missouri, US | |
3404082 | 3404082 | 2021-11-30 | US | Oregon | Wasco | 41065 | 3161 | 46 | 0 | 45.16292781 | -121.16709540000001 | 2021-12-01 04:22:29 | Wasco, Oregon, US | |
3403233 | 3403233 | 2021-11-30 | US | Mississippi | Chickasaw | 28017 | 3161 | 67 | 0 | 33.91983202 | -88.9481545 | 2021-12-01 04:22:29 | Chickasaw, Mississippi, US | |
907521 | 907521 | 2021-11-24 | US | Virginia | Fredericksburg | 51630 | 3161 | 26 | 0 | 38.2977863 | -77.4922454 | 2021-11-25 04:22:33 | Fredericksburg, Virginia, US | |
904532 | 904532 | 2021-11-24 | US | Alabama | Cherokee | 1019 | 3161 | 62 | 0 | 34.17805983 | -85.60638968 | 2021-11-25 04:22:33 | Cherokee, Alabama, US | |
3071985 | 3071985 | 2021-11-23 | US | Missouri | Ray | 29177 | 3161 | 52 | 0 | 39.353746799999996 | -93.98905745 | 2021-11-24 04:22:14 | Ray, Missouri, US | |
3289291 | 3289291 | 2021-11-18 | US | Alabama | Hale | 1065 | 3161 | 89 | 0 | 32.76039258 | -87.63284988 | 2021-11-19 04:21:40 | Hale, Alabama, US | |
31569 | 31569 | 2021-11-11 | US | Texas | Lavaca | 48285 | 3161 | 98 | 0 | 29.38508402 | -96.93186692 | 2021-11-12 04:22:01 | Lavaca, Texas, US | |
2848008 | 2848008 | 2021-11-10 | US | Texas | Lavaca | 48285 | 3161 | 98 | 0 | 29.38508402 | -96.93186692 | 2021-11-11 04:21:45 | Lavaca, Texas, US | |
90278 | 90278 | 2021-11-09 | US | Texas | Lavaca | 48285 | 3161 | 98 | 0 | 29.38508402 | -96.93186692 | 2021-11-10 04:21:38 | Lavaca, Texas, US | |
700269 | 700269 | 2021-11-04 | US | Mississippi | Winston | 28159 | 3161 | 91 | 0 | 33.08747908 | -89.03391385 | 2021-11-05 04:21:54 | Winston, Mississippi, US | |
279362 | 279362 | 2021-11-03 | US | Texas | Montague | 48337 | 3161 | 94 | 0 | 33.67521893 | -97.72500958 | 2021-11-04 04:22:20 | Montague, Texas, US | |
278047 | 278047 | 2021-11-03 | US | Mississippi | Winston | 28159 | 3161 | 91 | 0 | 33.08747908 | -89.03391385 | 2021-11-04 04:22:20 | Winston, Mississippi, US | |
3794357 | 3794357 | 2021-10-25 | US | Arkansas | Ashley | 5003 | 3161 | 48 | 0 | 33.19153461 | -91.76984709999999 | 2021-10-26 04:22:09 | Ashley, Arkansas, US | |
682803 | 682803 | 2021-10-24 | US | Arkansas | Ashley | 5003 | 3161 | 48 | 0 | 33.19153461 | -91.76984709999999 | 2021-10-25 04:22:31 | Ashley, Arkansas, US | |
938005 | 938005 | 2021-10-16 | US | Texas | Reeves | 48389 | 3161 | 52 | 0 | 31.32323325 | -103.69038959999999 | 2021-10-17 04:21:29 | Reeves, Texas, US | |
1493233 | 1493233 | 2021-10-12 | US | Michigan | Emmet | 26047 | 3161 | 49 | 0 | 45.52625509 | -84.89083249 | 2021-10-13 04:20:51 | Emmet, Michigan, US | |
3008966 | 3008966 | 2021-10-11 | US | Michigan | Emmet | 26047 | 3161 | 49 | 0 | 45.52625509 | -84.89083249 | 2021-10-12 04:21:09 | Emmet, Michigan, US | |
424850 | 424850 | 2021-10-10 | US | Louisiana | Concordia | 22029 | 3161 | 75 | 0 | 31.44817835 | -91.63814433 | 2021-10-11 04:21:31 | Concordia, Louisiana, US | |
2877707 | 2877707 | 2021-10-09 | US | Louisiana | Concordia | 22029 | 3161 | 75 | 0 | 31.44817835 | -91.63814433 | 2021-10-10 04:21:38 | Concordia, Louisiana, US | |
2960873 | 2960873 | 2021-10-08 | US | Louisiana | Concordia | 22029 | 3161 | 75 | 0 | 31.44817835 | -91.63814433 | 2021-10-09 04:21:34 | Concordia, Louisiana, US | |
2461861 | 2461861 | 2021-10-06 | US | Texas | Deaf Smith | 48117 | 3161 | 70 | 0 | 34.96522957 | -102.6054267 | 2021-10-07 04:21:36 | Deaf Smith, Texas, US | |
604209 | 604209 | 2021-09-23 | US | Ohio | Van Wert | 39161 | 3161 | 75 | 0 | 40.8554138 | -84.59111700000003 | 2021-09-24 04:21:44 | Van Wert, Ohio, US | |
810508 | 810508 | 2021-09-20 | US | Idaho | Elmore | 16039 | 3161 | 27 | 0 | 43.3507101 | -115.4701578 | 2021-09-21 04:21:26 | Elmore, Idaho, US | |
1387816 | 1387816 | 2021-09-13 | US | New Mexico | Cibola | 35006 | 3161 | 131 | 0 | 34.91131525 | -107.998876 | 2021-09-14 04:21:41 | Cibola, New Mexico, US | |
3197205 | 3197205 | 2021-09-06 | US | Texas | Robertson | 48395 | 3161 | 52 | 0 | 31.02539637 | -96.51272246 | 2021-09-07 04:21:35 | Robertson, Texas, US | |
250718 | 250718 | 2021-09-04 | US | Kentucky | Marion | 21155 | 3161 | 40 | 0 | 37.55218078 | -85.26898542 | 2021-09-05 04:21:33 | Marion, Kentucky, US | |
3975074 | 3975074 | 2021-09-03 | US | Arkansas | Ouachita | 5103 | 3161 | 68 | 0 | 33.58839816 | -92.87795984 | 2021-09-04 04:21:28 | Ouachita, Arkansas, 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]);