johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
206 rows where confirmed = 3086 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752705 | 2752705 | 2022-12-29 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-30 04:21:04 | Liaoning, China | |||
1073711 | 1073711 | 2022-12-28 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-29 04:21:01 | Liaoning, China | |||
327708 | 327708 | 2022-12-27 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-28 04:21:04 | Liaoning, China | |||
217781 | 217781 | 2022-12-26 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-27 04:21:07 | Liaoning, China | |||
3222238 | 3222238 | 2022-12-25 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-26 04:21:06 | Liaoning, China | |||
1018152 | 1018152 | 2022-12-24 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-25 04:21:04 | Liaoning, China | |||
690175 | 690175 | 2022-12-23 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-24 04:21:02 | Liaoning, China | |||
2179385 | 2179385 | 2022-12-22 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-23 04:21:04 | Liaoning, China | |||
451189 | 451189 | 2022-12-21 | China | Liaoning | 3086 | 2 | 0 | 41.2956 | 122.6085 | 2022-12-22 04:20:56 | Liaoning, China | |||
545534 | 545534 | 2022-12-15 | US | Puerto Rico | Maunabo | 72095 | 3086 | 0 | 0 | 18.017889 | -65.922235 | 2022-12-16 04:21:01 | Maunabo, Puerto Rico, US | |
2559004 | 2559004 | 2022-11-29 | US | North Dakota | McLean | 38055 | 3086 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-11-30 04:21:07 | McLean, North Dakota, US | |
3526832 | 3526832 | 2022-11-24 | US | Virginia | Nelson | 51125 | 3086 | 38 | 0 | 37.78790447 | -78.88498513 | 2022-11-25 04:21:06 | Nelson, Virginia, US | |
3315615 | 3315615 | 2022-11-23 | US | Virginia | Nelson | 51125 | 3086 | 38 | 0 | 37.78790447 | -78.88498513 | 2022-11-24 04:21:09 | Nelson, Virginia, US | |
1623656 | 1623656 | 2022-11-22 | US | Virginia | Nelson | 51125 | 3086 | 38 | 0 | 37.78790447 | -78.88498513 | 2022-11-23 04:21:06 | Nelson, Virginia, US | |
1620927 | 1620927 | 2022-11-22 | US | Colorado | Prowers | 8099 | 3086 | 52 | 0 | 37.95544985 | -102.3926052 | 2022-11-23 04:21:06 | Prowers, Colorado, US | |
3463544 | 3463544 | 2022-11-21 | US | Virginia | Nelson | 51125 | 3086 | 38 | 0 | 37.78790447 | -78.88498513 | 2022-11-22 04:20:47 | Nelson, Virginia, US | |
2431939 | 2431939 | 2022-11-09 | US | Illinois | Jasper | 17079 | 3086 | 32 | 0 | 39.01054275 | -88.15437049 | 2022-11-10 04:21:16 | Jasper, Illinois, US | |
201581 | 201581 | 2022-10-19 | US | Virginia | Charlotte | 51037 | 3086 | 48 | 0 | 37.01909701 | -78.66314092 | 2022-10-20 04:22:59 | Charlotte, Virginia, US | |
2760242 | 2760242 | 2022-10-18 | US | Virginia | Charlotte | 51037 | 3086 | 48 | 0 | 37.01909701 | -78.66314092 | 2022-10-19 04:22:26 | Charlotte, Virginia, US | |
1978837 | 1978837 | 2022-09-25 | US | New Mexico | Torrance | 35057 | 3086 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-09-26 04:20:52 | Torrance, New Mexico, US | |
2652004 | 2652004 | 2022-09-24 | US | New Mexico | Torrance | 35057 | 3086 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-09-25 04:23:31 | Torrance, New Mexico, US | |
386444 | 386444 | 2022-09-23 | US | New Mexico | Torrance | 35057 | 3086 | 59 | 0 | 34.64048375 | -105.8508949 | 2022-09-24 04:21:40 | Torrance, New Mexico, US | |
2635275 | 2635275 | 2022-09-05 | US | Louisiana | West Feliciana | 22125 | 3086 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-06 04:21:02 | West Feliciana, Louisiana, US | |
2988839 | 2988839 | 2022-09-04 | US | Louisiana | West Feliciana | 22125 | 3086 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-05 04:21:01 | West Feliciana, Louisiana, US | |
2714524 | 2714524 | 2022-09-03 | US | Louisiana | West Feliciana | 22125 | 3086 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-04 04:21:22 | West Feliciana, Louisiana, US | |
1395229 | 1395229 | 2022-09-02 | US | Louisiana | West Feliciana | 22125 | 3086 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-03 04:21:04 | West Feliciana, Louisiana, US | |
3549058 | 3549058 | 2022-09-01 | US | Louisiana | West Feliciana | 22125 | 3086 | 48 | 0 | 30.87882871 | -91.4148538 | 2022-09-02 04:21:07 | West Feliciana, Louisiana, US | |
1164492 | 1164492 | 2022-08-18 | US | Virginia | Clarke | 51043 | 3086 | 51 | 0 | 39.11271747 | -77.99199425 | 2022-08-19 04:20:54 | Clarke, Virginia, US | |
993179 | 993179 | 2022-08-16 | US | New Jersey | Unassigned | 90034 | 3086 | 0 | 0 | 41.13891592 | 0.0 | 2022-08-17 04:20:59 | Unassigned, New Jersey, US | |
1088934 | 1088934 | 2022-08-09 | US | South Dakota | Charles Mix | 46023 | 3086 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-08-10 04:20:57 | Charles Mix, South Dakota, US | |
1086577 | 1086577 | 2022-08-09 | US | Arkansas | Lee | 5077 | 3086 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-08-10 04:20:57 | Lee, Arkansas, US | |
3546349 | 3546349 | 2022-08-08 | US | South Dakota | Charles Mix | 46023 | 3086 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-08-09 04:20:34 | Charles Mix, South Dakota, US | |
1072752 | 1072752 | 2022-08-07 | US | South Dakota | Charles Mix | 46023 | 3086 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-08-08 04:21:08 | Charles Mix, South Dakota, US | |
1943340 | 1943340 | 2022-08-06 | US | South Dakota | Charles Mix | 46023 | 3086 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-08-07 04:20:54 | Charles Mix, South Dakota, US | |
883139 | 883139 | 2022-08-05 | US | South Dakota | Charles Mix | 46023 | 3086 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-08-06 04:20:56 | Charles Mix, South Dakota, US | |
2011550 | 2011550 | 2022-08-04 | US | South Dakota | Charles Mix | 46023 | 3086 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-08-05 04:20:52 | Charles Mix, South Dakota, US | |
1100977 | 1100977 | 2022-08-03 | US | South Dakota | Charles Mix | 46023 | 3086 | 35 | 0 | 43.20660134 | -98.58856175 | 2022-08-04 04:20:58 | Charles Mix, South Dakota, US | |
631163 | 631163 | 2022-07-12 | US | Iowa | Winnebago | 19189 | 3086 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-13 04:20:58 | Winnebago, Iowa, US | |
1212807 | 1212807 | 2022-07-11 | US | Iowa | Winnebago | 19189 | 3086 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-12 04:20:51 | Winnebago, Iowa, US | |
2790289 | 2790289 | 2022-07-10 | US | Iowa | Winnebago | 19189 | 3086 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-11 04:20:46 | Winnebago, Iowa, US | |
143242 | 143242 | 2022-07-09 | US | Iowa | Winnebago | 19189 | 3086 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-10 04:20:54 | Winnebago, Iowa, US | |
1418342 | 1418342 | 2022-07-08 | US | Iowa | Winnebago | 19189 | 3086 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-09 04:20:59 | Winnebago, Iowa, US | |
2742267 | 2742267 | 2022-07-07 | US | Iowa | Winnebago | 19189 | 3086 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-08 04:20:56 | Winnebago, Iowa, US | |
1201062 | 1201062 | 2022-07-06 | US | Iowa | Winnebago | 19189 | 3086 | 47 | 0 | 43.37751174 | -93.73407298 | 2022-07-07 04:20:55 | Winnebago, Iowa, US | |
2240341 | 2240341 | 2022-06-28 | US | Idaho | Idaho | 16049 | 3086 | 52 | 0 | 45.84721541 | -115.4634436 | 2022-06-29 04:20:59 | Idaho, Idaho, US | |
2148583 | 2148583 | 2022-06-27 | US | Idaho | Idaho | 16049 | 3086 | 52 | 0 | 45.84721541 | -115.4634436 | 2022-06-28 04:20:58 | Idaho, Idaho, US | |
2148295 | 2148295 | 2022-06-27 | US | Colorado | Rio Grande | 8105 | 3086 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-06-28 04:20:58 | Rio Grande, Colorado, US | |
2148110 | 2148110 | 2022-06-27 | US | Arkansas | Bradley | 5011 | 3086 | 51 | 0 | 33.46755808 | -92.15980837 | 2022-06-28 04:20:58 | Bradley, Arkansas, US | |
560800 | 560800 | 2022-06-16 | US | Montana | Custer | 30017 | 3086 | 49 | 0 | 46.25319932 | -105.5737526 | 2022-06-17 04:20:56 | Custer, Montana, US | |
3984602 | 3984602 | 2022-06-15 | US | Montana | Custer | 30017 | 3086 | 49 | 0 | 46.25319932 | -105.5737526 | 2022-06-16 04:20:55 | Custer, Montana, US | |
948843 | 948843 | 2022-06-14 | US | Montana | Custer | 30017 | 3086 | 49 | 0 | 46.25319932 | -105.5737526 | 2022-06-15 04:20:54 | Custer, Montana, US | |
2981251 | 2981251 | 2022-06-13 | US | Montana | Custer | 30017 | 3086 | 49 | 0 | 46.25319932 | -105.5737526 | 2022-06-14 04:20:52 | Custer, Montana, US | |
2237377 | 2237377 | 2022-06-12 | US | Montana | Custer | 30017 | 3086 | 49 | 0 | 46.25319932 | -105.5737526 | 2022-06-13 04:21:14 | Custer, Montana, US | |
3143575 | 3143575 | 2022-06-11 | US | Montana | Custer | 30017 | 3086 | 49 | 0 | 46.25319932 | -105.5737526 | 2022-06-12 04:20:53 | Custer, Montana, US | |
1946491 | 1946491 | 2022-06-10 | US | Montana | Custer | 30017 | 3086 | 49 | 0 | 46.25319932 | -105.5737526 | 2022-06-11 04:21:01 | Custer, Montana, US | |
1421751 | 1421751 | 2022-06-08 | US | Colorado | Park | 8093 | 3086 | 21 | 0 | 39.120926 | -105.7182065 | 2022-06-09 04:20:54 | Park, Colorado, US | |
3584827 | 3584827 | 2022-05-17 | US | New Jersey | Unassigned | 90034 | 3086 | 0 | 0 | 41.13891592 | 0.0 | 2022-05-18 04:20:50 | Unassigned, New Jersey, US | |
2085090 | 2085090 | 2022-05-15 | US | Indiana | Pulaski | 18131 | 3086 | 86 | 0 | 41.04166107 | -86.69890683 | 2022-05-16 04:20:47 | Pulaski, Indiana, US | |
3355800 | 3355800 | 2022-05-14 | US | Indiana | Pulaski | 18131 | 3086 | 86 | 0 | 41.04166107 | -86.69890683 | 2022-05-15 04:20:53 | Pulaski, Indiana, US | |
659445 | 659445 | 2022-05-13 | US | Indiana | Pulaski | 18131 | 3086 | 86 | 0 | 41.04166107 | -86.69890683 | 2022-05-14 04:20:48 | Pulaski, Indiana, US | |
1572776 | 1572776 | 2022-05-03 | US | Colorado | Moffat | 8081 | 3086 | 52 | 0 | 40.61810999 | -108.2070876 | 2022-05-04 04:20:59 | Moffat, Colorado, US | |
1058637 | 1058637 | 2022-02-23 | US | Georgia | Dade | 13083 | 3086 | 28 | 0 | 34.854916700000004 | -85.50490424 | 2022-02-24 04:21:14 | Dade, Georgia, US | |
1298878 | 1298878 | 2022-02-17 | US | Georgia | Jasper | 13159 | 3086 | 68 | 0 | 33.31535543 | -83.68844964 | 2022-02-18 04:21:04 | Jasper, Georgia, US | |
189475 | 189475 | 2022-02-13 | US | Virginia | Rockbridge | 51163 | 3086 | 73 | 0 | 37.81204314 | -79.44605905 | 2022-02-14 04:20:51 | Rockbridge, Virginia, US | |
319321 | 319321 | 2022-02-12 | US | Virginia | Rockbridge | 51163 | 3086 | 73 | 0 | 37.81204314 | -79.44605905 | 2022-02-13 04:21:00 | Rockbridge, Virginia, US | |
236647 | 236647 | 2022-02-11 | US | Virginia | Rockbridge | 51163 | 3086 | 73 | 0 | 37.81204314 | -79.44605905 | 2022-02-12 04:21:06 | Rockbridge, Virginia, US | |
3077575 | 3077575 | 2022-02-09 | US | Wisconsin | Bayfield | 55007 | 3086 | 38 | 0 | 46.52868768 | -91.19716729 | 2022-02-10 04:21:14 | Bayfield, Wisconsin, US | |
1365310 | 1365310 | 2022-02-08 | US | Tennessee | Jackson | 47087 | 3086 | 52 | 0 | 36.36380466 | -85.67239905 | 2022-02-09 04:21:04 | Jackson, Tennessee, US | |
3813063 | 3813063 | 2022-01-28 | US | Texas | Jackson | 48239 | 3086 | 55 | 0 | 28.95472367 | -96.57749563 | 2022-01-29 04:21:10 | Jackson, Texas, US | |
1782141 | 1782141 | 2022-01-27 | US | Puerto Rico | Lares | 72081 | 3086 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-01-28 04:21:09 | Lares, Puerto Rico, US | |
1116754 | 1116754 | 2022-01-11 | US | Texas | Madison | 48313 | 3086 | 47 | 0 | 30.96694679 | -95.93003775 | 2022-01-12 04:21:44 | Madison, Texas, US | |
1692812 | 1692812 | 2022-01-10 | US | Arkansas | Izard | 5065 | 3086 | 58 | 0 | 36.09604046 | -91.90847954 | 2022-01-11 04:22:01 | Izard, Arkansas, US | |
1282958 | 1282958 | 2022-01-05 | US | Illinois | Carroll | 17015 | 3086 | 42 | 0 | 42.06823429 | -89.93395545 | 2022-01-06 04:22:09 | Carroll, Illinois, US | |
2168046 | 2168046 | 2022-01-01 | US | Arkansas | Drew | 5043 | 3086 | 57 | 0 | 33.59035001 | -91.71777921 | 2022-01-02 04:20:52 | Drew, Arkansas, US | |
4001914 | 4001914 | 2021-12-30 | US | Texas | Young | 48503 | 3086 | 74 | 0 | 33.17659707 | -98.68790885 | 2021-12-31 04:21:50 | Young, Texas, US | |
3999257 | 3999257 | 2021-12-30 | US | Colorado | Chaffee | 8015 | 3086 | 38 | 0 | 38.74745778 | -106.19265729999998 | 2021-12-31 04:21:50 | Chaffee, Colorado, US | |
2907110 | 2907110 | 2021-12-19 | US | Virginia | Prince Edward | 51147 | 3086 | 53 | 0 | 37.22554789 | -78.43597949 | 2021-12-20 04:21:43 | Prince Edward, Virginia, US | |
1262183 | 1262183 | 2021-12-18 | US | Virginia | Prince Edward | 51147 | 3086 | 53 | 0 | 37.22554789 | -78.43597949 | 2021-12-19 04:21:11 | Prince Edward, Virginia, US | |
2402211 | 2402211 | 2021-12-17 | US | Virginia | Prince Edward | 51147 | 3086 | 53 | 0 | 37.22554789 | -78.43597949 | 2021-12-18 02:22:20 | Prince Edward, Virginia, US | |
3496669 | 3496669 | 2021-12-15 | US | Arkansas | Cross | 5037 | 3086 | 69 | 0 | 35.29631396 | -90.77185818 | 2021-12-16 04:22:11 | Cross, Arkansas, US | |
2091444 | 2091444 | 2021-12-14 | US | West Virginia | Barbour | 54001 | 3086 | 53 | 0 | 39.1307219 | -80.00350858 | 2021-12-15 03:22:16 | Barbour, West Virginia, US | |
3657046 | 3657046 | 2021-12-10 | US | Kentucky | Morgan | 21175 | 3086 | 16 | 0 | 37.92465657 | -83.25558245 | 2021-12-11 04:22:45 | Morgan, Kentucky, US | |
553765 | 553765 | 2021-12-08 | US | Tennessee | Sequatchie | 47153 | 3086 | 39 | 0 | 35.36979721 | -85.41022136 | 2021-12-09 04:22:49 | Sequatchie, Tennessee, US | |
1233102 | 1233102 | 2021-11-28 | US | Kentucky | Spencer | 21215 | 3086 | 40 | 0 | 38.03223971 | -85.32749335 | 2021-11-29 04:22:30 | Spencer, Kentucky, US | |
3071307 | 3071307 | 2021-11-23 | US | Kansas | Dickinson | 20041 | 3086 | 62 | 0 | 38.86600962 | -97.15532383 | 2021-11-24 04:22:14 | Dickinson, Kansas, US | |
3750405 | 3750405 | 2021-11-22 | US | Kansas | Dickinson | 20041 | 3086 | 62 | 0 | 38.86600962 | -97.15532383 | 2021-11-23 04:22:39 | Dickinson, Kansas, US | |
1015241 | 1015241 | 2021-11-21 | US | Georgia | Worth | 13321 | 3086 | 93 | 0 | 31.55162306 | -83.85090513 | 2021-11-22 04:22:20 | Worth, Georgia, US | |
723405 | 723405 | 2021-11-20 | US | Georgia | Worth | 13321 | 3086 | 93 | 0 | 31.55162306 | -83.85090513 | 2021-11-21 04:22:13 | Worth, Georgia, US | |
162935 | 162935 | 2021-11-19 | US | Georgia | Worth | 13321 | 3086 | 93 | 0 | 31.55162306 | -83.85090513 | 2021-11-20 04:22:17 | Worth, Georgia, US | |
688332 | 688332 | 2021-11-13 | US | Missouri | Texas | 29215 | 3086 | 43 | 0 | 37.31728859 | -91.96564727 | 2021-11-14 04:21:31 | Texas, Missouri, US | |
2000840 | 2000840 | 2021-11-07 | Peru | Unknown | 3086 | 88 | 0 | 2021-11-08 04:21:43 | Unknown, Peru | |||||
278797 | 278797 | 2021-11-03 | US | Oregon | Crook | 41013 | 3086 | 52 | 0 | 44.14230227 | -120.356297 | 2021-11-04 04:22:20 | Crook, Oregon, US | |
278160 | 278160 | 2021-11-03 | US | Missouri | Vernon | 29217 | 3086 | 65 | 0 | 37.8457799 | -94.34127305 | 2021-11-04 04:22:20 | Vernon, Missouri, US | |
3514990 | 3514990 | 2021-11-01 | US | Wisconsin | Taylor | 55119 | 3086 | 46 | 0 | 45.21179252 | -90.5004405 | 2021-11-02 04:22:03 | Taylor, Wisconsin, US | |
3514746 | 3514746 | 2021-11-01 | US | Virginia | Fredericksburg | 51630 | 3086 | 26 | 0 | 38.2977863 | -77.4922454 | 2021-11-02 04:22:03 | Fredericksburg, Virginia, US | |
3514228 | 3514228 | 2021-11-01 | US | South Carolina | Hampton | 45049 | 3086 | 74 | 0 | 32.77419582 | -81.13845571 | 2021-11-02 04:22:03 | Hampton, South Carolina, US | |
601232 | 601232 | 2021-10-19 | US | Wisconsin | Langlade | 55067 | 3086 | 54 | 0 | 45.26271619 | -89.07483625 | 2021-10-20 04:21:00 | Langlade, Wisconsin, US | |
493008 | 493008 | 2021-10-14 | US | Kentucky | Bourbon | 21017 | 3086 | 32 | 0 | 38.2054607 | -84.21827874 | 2021-10-15 04:21:26 | Bourbon, Kentucky, US | |
1492360 | 1492360 | 2021-10-12 | US | Georgia | Brantley | 13025 | 3086 | 80 | 0 | 31.19576557 | -81.97743999 | 2021-10-13 04:20:51 | Brantley, Georgia, US | |
423727 | 423727 | 2021-10-10 | US | Alabama | Henry | 1067 | 3086 | 63 | 0 | 31.51148016 | -85.24267944 | 2021-10-11 04:21:31 | Henry, Alabama, 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]);