johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
141 rows where confirmed = 5493 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 127
- China 10
- Russia 3
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752696 | 2752696 | 2022-12-29 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-30 04:21:04 | Heilongjiang, China | |||
1073702 | 1073702 | 2022-12-28 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-29 04:21:01 | Heilongjiang, China | |||
327699 | 327699 | 2022-12-27 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-28 04:21:04 | Heilongjiang, China | |||
218953 | 218953 | 2022-12-26 | US | Illinois | Cass | 17017 | 5493 | 37 | 0 | 39.96991073 | -90.24734436 | 2022-12-27 04:21:07 | Cass, Illinois, US | |
217772 | 217772 | 2022-12-26 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-27 04:21:07 | Heilongjiang, China | |||
3223410 | 3223410 | 2022-12-25 | US | Illinois | Cass | 17017 | 5493 | 37 | 0 | 39.96991073 | -90.24734436 | 2022-12-26 04:21:06 | Cass, Illinois, US | |
3222229 | 3222229 | 2022-12-25 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-26 04:21:06 | Heilongjiang, China | |||
1019324 | 1019324 | 2022-12-24 | US | Illinois | Cass | 17017 | 5493 | 37 | 0 | 39.96991073 | -90.24734436 | 2022-12-25 04:21:04 | Cass, Illinois, US | |
1018143 | 1018143 | 2022-12-24 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-25 04:21:04 | Heilongjiang, China | |||
691347 | 691347 | 2022-12-23 | US | Illinois | Cass | 17017 | 5493 | 37 | 0 | 39.96991073 | -90.24734436 | 2022-12-24 04:21:02 | Cass, Illinois, US | |
690166 | 690166 | 2022-12-23 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-24 04:21:02 | Heilongjiang, China | |||
2179376 | 2179376 | 2022-12-22 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-23 04:21:04 | Heilongjiang, China | |||
451180 | 451180 | 2022-12-21 | China | Heilongjiang | 5493 | 13 | 0 | 47.862 | 127.7615 | 2022-12-22 04:20:56 | Heilongjiang, China | |||
1631795 | 1631795 | 2022-12-18 | US | West Virginia | Hardy | 54031 | 5493 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-19 04:21:03 | Hardy, West Virginia, US | |
1631053 | 1631053 | 2022-12-18 | US | Puerto Rico | Guayanilla | 72059 | 5493 | 0 | 0 | 18.039942 | -66.79186 | 2022-12-19 04:21:03 | Guayanilla, Puerto Rico, US | |
1628111 | 1628111 | 2022-12-18 | China | Shaanxi | 5493 | 3 | 0 | 35.1917 | 108.8701 | 2022-12-19 04:21:03 | Shaanxi, China | |||
507174 | 507174 | 2022-12-17 | US | West Virginia | Hardy | 54031 | 5493 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-18 04:21:03 | Hardy, West Virginia, US | |
3327746 | 3327746 | 2022-12-16 | US | West Virginia | Hardy | 54031 | 5493 | 52 | 0 | 39.00683177 | -78.85855301 | 2022-12-17 04:21:04 | Hardy, West Virginia, US | |
2416447 | 2416447 | 2022-12-05 | US | Maine | Washington | 23029 | 5493 | 64 | 0 | 45.01607142 | -67.62813524 | 2022-12-06 04:21:03 | Washington, Maine, US | |
720055 | 720055 | 2022-12-04 | US | Maine | Washington | 23029 | 5493 | 64 | 0 | 45.01607142 | -67.62813524 | 2022-12-05 04:20:58 | Washington, Maine, US | |
2818344 | 2818344 | 2022-12-03 | US | Maine | Washington | 23029 | 5493 | 64 | 0 | 45.01607142 | -67.62813524 | 2022-12-04 04:20:56 | Washington, Maine, US | |
3552182 | 3552182 | 2022-11-27 | US | Arkansas | Sharp | 5135 | 5493 | 119 | 0 | 36.16258158 | -91.47819342 | 2022-11-28 04:21:02 | Sharp, Arkansas, US | |
292800 | 292800 | 2022-11-15 | US | Georgia | Cook | 13075 | 5493 | 80 | 0 | 31.16068491 | -83.42947229 | 2022-11-16 04:21:09 | Cook, Georgia, US | |
3597830 | 3597830 | 2022-11-14 | US | Georgia | Cook | 13075 | 5493 | 80 | 0 | 31.16068491 | -83.42947229 | 2022-11-15 04:21:16 | Cook, Georgia, US | |
312688 | 312688 | 2022-11-13 | US | Georgia | Cook | 13075 | 5493 | 80 | 0 | 31.16068491 | -83.42947229 | 2022-11-14 04:21:09 | Cook, Georgia, US | |
63849 | 63849 | 2022-11-12 | US | Georgia | Cook | 13075 | 5493 | 80 | 0 | 31.16068491 | -83.42947229 | 2022-11-13 04:21:14 | Cook, Georgia, US | |
2928011 | 2928011 | 2022-11-11 | US | Georgia | Cook | 13075 | 5493 | 80 | 0 | 31.16068491 | -83.42947229 | 2022-11-12 04:20:41 | Cook, Georgia, US | |
2506847 | 2506847 | 2022-11-10 | US | Georgia | Cook | 13075 | 5493 | 80 | 0 | 31.16068491 | -83.42947229 | 2022-11-11 04:21:22 | Cook, Georgia, US | |
2431722 | 2431722 | 2022-11-09 | US | Georgia | Cook | 13075 | 5493 | 80 | 0 | 31.16068491 | -83.42947229 | 2022-11-10 04:21:16 | Cook, Georgia, US | |
850210 | 850210 | 2022-11-02 | US | Colorado | Chaffee | 8015 | 5493 | 56 | 0 | 38.74745778 | -106.1926573 | 2022-11-03 04:22:05 | Chaffee, Colorado, US | |
198743 | 198743 | 2022-10-19 | US | Arkansas | Cross | 5037 | 5493 | 96 | 0 | 35.29631396 | -90.77185818 | 2022-10-20 04:22:59 | Cross, Arkansas, US | |
2757404 | 2757404 | 2022-10-18 | US | Arkansas | Cross | 5037 | 5493 | 96 | 0 | 35.29631396 | -90.77185818 | 2022-10-19 04:22:26 | Cross, Arkansas, US | |
2529937 | 2529937 | 2022-10-06 | US | California | Inyo | 6027 | 5493 | 59 | 0 | 36.51112084 | -117.4111978 | 2022-10-07 04:23:08 | Inyo, California, US | |
1562872 | 1562872 | 2022-09-28 | US | Puerto Rico | Sabana Grande | 72121 | 5493 | 0 | 0 | 18.08282 | -66.943758 | 2022-09-29 04:22:34 | Sabana Grande, Puerto Rico, US | |
373335 | 373335 | 2022-09-13 | US | Indiana | Rush | 18139 | 5493 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-09-14 04:20:44 | Rush, Indiana, US | |
2395937 | 2395937 | 2022-09-12 | US | Indiana | Rush | 18139 | 5493 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-09-13 04:20:57 | Rush, Indiana, US | |
254287 | 254287 | 2022-09-08 | US | Illinois | Clark | 17023 | 5493 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-09-09 04:21:11 | Clark, Illinois, US | |
1251882 | 1251882 | 2022-08-23 | US | Indiana | Orange | 18117 | 5493 | 99 | 0 | 38.5411892 | -86.49523093 | 2022-08-24 04:20:46 | Orange, Indiana, US | |
2853986 | 2853986 | 2022-08-22 | US | Indiana | Orange | 18117 | 5493 | 99 | 0 | 38.5411892 | -86.49523093 | 2022-08-23 04:20:56 | Orange, Indiana, US | |
3908508 | 3908508 | 2022-08-11 | US | Arkansas | Logan | 5083 | 5493 | 80 | 0 | 35.21413234 | -93.71951016 | 2022-08-12 04:20:54 | Logan, Arkansas, US | |
1071311 | 1071311 | 2022-08-07 | US | Kentucky | Henry | 21103 | 5493 | 53 | 0 | 38.44942688 | -85.11587507 | 2022-08-08 04:21:08 | Henry, Kentucky, US | |
1941899 | 1941899 | 2022-08-06 | US | Kentucky | Henry | 21103 | 5493 | 53 | 0 | 38.44942688 | -85.11587507 | 2022-08-07 04:20:54 | Henry, Kentucky, US | |
881698 | 881698 | 2022-08-05 | US | Kentucky | Henry | 21103 | 5493 | 53 | 0 | 38.44942688 | -85.11587507 | 2022-08-06 04:20:56 | Henry, Kentucky, US | |
880941 | 880941 | 2022-08-05 | US | Colorado | Teller | 8119 | 5493 | 59 | 0 | 38.88133511 | -105.1614893 | 2022-08-06 04:20:56 | Teller, Colorado, US | |
2010109 | 2010109 | 2022-08-04 | US | Kentucky | Henry | 21103 | 5493 | 53 | 0 | 38.44942688 | -85.11587507 | 2022-08-05 04:20:52 | Henry, Kentucky, US | |
1099536 | 1099536 | 2022-08-03 | US | Kentucky | Henry | 21103 | 5493 | 53 | 0 | 38.44942688 | -85.11587507 | 2022-08-04 04:20:58 | Henry, Kentucky, US | |
1406461 | 1406461 | 2022-08-02 | US | Kentucky | Henry | 21103 | 5493 | 53 | 0 | 38.44942688 | -85.11587507 | 2022-08-03 04:20:59 | Henry, Kentucky, US | |
3618499 | 3618499 | 2022-08-01 | US | Kentucky | Henry | 21103 | 5493 | 53 | 0 | 38.44942688 | -85.11587507 | 2022-08-02 04:20:53 | Henry, Kentucky, US | |
1487941 | 1487941 | 2022-07-26 | US | Alabama | Cherokee | 1019 | 5493 | 87 | 0 | 34.17805983 | -85.60638968 | 2022-07-27 04:21:04 | Cherokee, Alabama, US | |
2190333 | 2190333 | 2022-06-22 | US | Puerto Rico | Anasco | 72011 | 5493 | 0 | 0 | 18.287985 | -67.120611 | 2022-06-23 04:20:55 | Anasco, Puerto Rico, US | |
3729315 | 3729315 | 2022-06-07 | US | Texas | Gillespie | 48171 | 5493 | 109 | 0 | 30.31824095 | -98.94676915 | 2022-06-08 04:20:55 | Gillespie, Texas, US | |
3201144 | 3201144 | 2022-05-29 | US | Tennessee | Union | 47173 | 5493 | 77 | 0 | 36.28590426 | -83.83651902 | 2022-05-30 04:20:50 | Union, Tennessee, US | |
1169713 | 1169713 | 2022-05-20 | US | Arkansas | Ouachita | 5103 | 5493 | 104 | 0 | 33.58839816 | -92.87795984 | 2022-05-21 04:20:58 | Ouachita, Arkansas, US | |
3583655 | 3583655 | 2022-05-17 | US | Illinois | Lawrence | 17101 | 5493 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-05-18 04:20:50 | Lawrence, Illinois, US | |
3583120 | 3583120 | 2022-05-17 | US | Arkansas | Conway | 5029 | 5493 | 65 | 0 | 35.26205537 | -92.70506566 | 2022-05-18 04:20:50 | Conway, Arkansas, US | |
1504077 | 1504077 | 2022-05-16 | US | Arkansas | Conway | 5029 | 5493 | 65 | 0 | 35.26205537 | -92.70506566 | 2022-05-17 04:20:59 | Conway, Arkansas, US | |
2084436 | 2084436 | 2022-05-15 | US | Arkansas | Conway | 5029 | 5493 | 65 | 0 | 35.26205537 | -92.70506566 | 2022-05-16 04:20:47 | Conway, Arkansas, US | |
3355146 | 3355146 | 2022-05-14 | US | Arkansas | Conway | 5029 | 5493 | 65 | 0 | 35.26205537 | -92.70506566 | 2022-05-15 04:20:53 | Conway, Arkansas, US | |
2332392 | 2332392 | 2022-05-08 | US | Illinois | Lawrence | 17101 | 5493 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-05-09 04:20:54 | Lawrence, Illinois, US | |
361354 | 361354 | 2022-05-07 | US | Illinois | Lawrence | 17101 | 5493 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-05-08 04:20:49 | Lawrence, Illinois, US | |
1398705 | 1398705 | 2022-05-06 | US | Illinois | Lawrence | 17101 | 5493 | 43 | 0 | 38.71987914 | -87.72884035 | 2022-05-07 04:21:09 | Lawrence, Illinois, US | |
1578912 | 1578912 | 2022-04-10 | US | Puerto Rico | Manati | 72091 | 5493 | 0 | 0 | 18.420473 | -66.490461 | 2022-04-11 04:21:02 | Manati, Puerto Rico, US | |
879028 | 879028 | 2022-03-27 | US | Puerto Rico | Moca | 72099 | 5493 | 0 | 0 | 18.377805 | -67.080952 | 2022-03-28 04:20:33 | Moca, Puerto Rico, US | |
1471315 | 1471315 | 2022-03-24 | US | Texas | San Jacinto | 48407 | 5493 | 100 | 0 | 30.57933681 | -95.16260304 | 2022-03-25 04:20:46 | San Jacinto, Texas, US | |
264269 | 264269 | 2022-03-15 | US | Puerto Rico | Corozal | 72047 | 5493 | 0 | 0 | 18.304264 | -66.327738 | 2022-03-16 04:20:50 | Corozal, Puerto Rico, US | |
2266628 | 2266628 | 2022-03-14 | US | Puerto Rico | Corozal | 72047 | 5493 | 0 | 0 | 18.304264 | -66.327738 | 2022-03-15 04:20:47 | Corozal, Puerto Rico, US | |
3630694 | 3630694 | 2022-03-13 | US | Puerto Rico | Corozal | 72047 | 5493 | 0 | 0 | 18.304264 | -66.327738 | 2022-03-14 04:20:46 | Corozal, Puerto Rico, US | |
576388 | 576388 | 2022-02-25 | US | Maine | Franklin | 23007 | 5493 | 55 | 0 | 44.97330019 | -70.44381045 | 2022-02-26 04:21:12 | Franklin, Maine, US | |
1061237 | 1061237 | 2022-02-23 | US | Virginia | Page | 51139 | 5493 | 112 | 0 | 38.61807452 | -78.48797204 | 2022-02-24 04:21:14 | Page, Virginia, US | |
2450187 | 2450187 | 2022-02-22 | US | Virginia | Staunton | 51790 | 5493 | 100 | 0 | 38.15965544 | -79.05979937 | 2022-02-23 04:21:09 | Staunton, Virginia, US | |
3673142 | 3673142 | 2022-02-15 | US | Louisiana | Assumption | 22007 | 5493 | 67 | 0 | 29.89946234 | -91.06461642 | 2022-02-16 04:21:10 | Assumption, Louisiana, US | |
2643964 | 2643964 | 2022-02-14 | US | New Mexico | San Miguel | 35047 | 5493 | 49 | 0 | 35.48014807 | -104.8163562 | 2022-02-15 04:21:09 | San Miguel, New Mexico, US | |
1141382 | 1141382 | 2022-01-23 | US | Arkansas | Carroll | 5015 | 5493 | 87 | 0 | 36.34038560000001 | -93.54270261 | 2022-01-24 04:21:12 | Carroll, Arkansas, US | |
3426524 | 3426524 | 2022-01-21 | US | Maryland | Caroline | 24011 | 5493 | 63 | 0 | 38.87172293 | -75.82904158 | 2022-01-22 04:21:13 | Caroline, Maryland, US | |
3520511 | 3520511 | 2022-01-02 | US | Indiana | Daviess | 18027 | 5493 | 123 | 0 | 38.70186039 | -87.07185406 | 2022-01-03 02:22:25 | Daviess, Indiana, US | |
2168641 | 2168641 | 2022-01-01 | US | Indiana | Daviess | 18027 | 5493 | 123 | 0 | 38.70186039 | -87.07185406 | 2022-01-02 04:20:52 | Daviess, Indiana, US | |
2778072 | 2778072 | 2021-12-31 | US | Indiana | Daviess | 18027 | 5493 | 123 | 0 | 38.70186039 | -87.07185406 | 2022-01-01 04:22:14 | Daviess, Indiana, US | |
3999729 | 3999729 | 2021-12-30 | US | Indiana | Daviess | 18027 | 5493 | 123 | 0 | 38.70186039 | -87.07185406 | 2021-12-31 04:21:50 | Daviess, Indiana, US | |
1256208 | 1256208 | 2021-12-20 | US | Kentucky | Logan | 21141 | 5493 | 97 | 0 | 36.85949479 | -86.877635 | 2021-12-21 03:21:27 | Logan, Kentucky, US | |
1261287 | 1261287 | 2021-12-18 | US | Ohio | Morrow | 39117 | 5493 | 73 | 0 | 40.52363560000001 | -82.7892599 | 2021-12-19 04:21:11 | Morrow, Ohio, US | |
2400199 | 2400199 | 2021-12-17 | US | Kentucky | Calloway | 21035 | 5493 | 66 | 0 | 36.62093411 | -88.2731593 | 2021-12-18 02:22:20 | Calloway, Kentucky, US | |
1145587 | 1145587 | 2021-12-01 | US | Colorado | Summit | 8117 | 5493 | 12 | 0 | 39.63803232 | -106.1150762 | 2021-12-02 04:22:37 | Summit, Colorado, US | |
3071670 | 3071670 | 2021-11-23 | US | Michigan | Huron | 26063 | 5493 | 100 | 0 | 43.83353985 | -83.04078453 | 2021-11-24 04:22:14 | Huron, Michigan, US | |
3750768 | 3750768 | 2021-11-22 | US | Michigan | Huron | 26063 | 5493 | 100 | 0 | 43.83353985 | -83.04078453 | 2021-11-23 04:22:39 | Huron, Michigan, US | |
687732 | 687732 | 2021-11-13 | US | Kentucky | Boyle | 21021 | 5493 | 83 | 0 | 37.62680923 | -84.8633779 | 2021-11-14 04:21:31 | Boyle, Kentucky, US | |
1912160 | 1912160 | 2021-10-17 | US | Tennessee | Hardin | 47071 | 5493 | 81 | 0 | 35.19732531 | -88.18593755 | 2021-10-18 04:21:10 | Hardin, Tennessee, US | |
937749 | 937749 | 2021-10-16 | US | Tennessee | Hardin | 47071 | 5493 | 81 | 0 | 35.19732531 | -88.18593755 | 2021-10-17 04:21:29 | Hardin, Tennessee, US | |
2946304 | 2946304 | 2021-10-15 | US | Tennessee | Hardin | 47071 | 5493 | 81 | 0 | 35.19732531 | -88.18593755 | 2021-10-16 04:21:15 | Hardin, Tennessee, US | |
2946064 | 2946064 | 2021-10-15 | US | Pennsylvania | Wayne | 42127 | 5493 | 103 | 0 | 41.64938475 | -75.29956506 | 2021-10-16 04:21:15 | Wayne, Pennsylvania, US | |
2961880 | 2961880 | 2021-10-08 | US | Ohio | Preble | 39135 | 5493 | 129 | 0 | 39.7420247 | -84.64787018 | 2021-10-09 04:21:34 | Preble, Ohio, US | |
1274640 | 1274640 | 2021-10-03 | US | Alabama | Chambers | 1017 | 5493 | 138 | 0 | 32.91360079 | -85.39072749 | 2021-10-04 04:21:31 | Chambers, Alabama, US | |
2774762 | 2774762 | 2021-09-30 | US | Mississippi | Alcorn | 28003 | 5493 | 91 | 0 | 34.88084463 | -88.57996173 | 2021-10-01 04:21:35 | Alcorn, Mississippi, US | |
1337816 | 1337816 | 2021-09-28 | US | Wisconsin | Douglas | 55031 | 5493 | 66 | 0 | 46.43222285 | -91.91595768 | 2021-09-29 04:21:45 | Douglas, Wisconsin, US | |
1237105 | 1237105 | 2021-09-27 | US | Kentucky | Perry | 21193 | 5493 | 77 | 0 | 37.25023553 | -83.22922731 | 2021-09-28 04:21:28 | Perry, Kentucky, US | |
1923705 | 1923705 | 2021-09-24 | US | Ohio | Madison | 39097 | 5493 | 74 | 0 | 39.89381073 | -83.40178317 | 2021-09-25 04:21:31 | Madison, Ohio, US | |
605192 | 605192 | 2021-09-23 | US | West Virginia | Ohio | 54069 | 5493 | 93 | 0 | 40.0955451 | -80.62203992 | 2021-09-24 04:21:44 | Ohio, West Virginia, US | |
3107240 | 3107240 | 2021-08-24 | US | Mississippi | Bolivar | 28011 | 5493 | 140 | 0 | 33.79696941 | -90.87372121 | 2021-08-25 04:21:41 | Bolivar, Mississippi, US | |
2901821 | 2901821 | 2021-08-12 | US | Nevada | Elko | 32007 | 5493 | 64 | 0 | 41.14531606 | -115.3577619 | 2021-08-13 04:21:24 | Elko, Nevada, US | |
332815 | 332815 | 2021-08-04 | US | Hawaii | Maui | 15009 | 5493 | 62 | 0 | 20.86399628 | -156.56890969999995 | 2021-08-05 04:21:51 | Maui, Hawaii, US | |
3743765 | 3743765 | 2021-07-12 | US | Pennsylvania | Mifflin | 42087 | 5493 | 182 | 0 | 40.61116939 | -77.61070738 | 2021-07-13 04:21:18 | Mifflin, Pennsylvania, 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]);