johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
169 rows where confirmed = 4970 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
351033 | 351033 | 2022-12-14 | US | Puerto Rico | Ciales | 72039 | 4970 | 0 | 0 | 18.28885 | -66.516475 | 2022-12-15 04:20:58 | Ciales, Puerto Rico, US | |
1985549 | 1985549 | 2022-12-07 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-08 04:21:07 | Washington, Georgia, US | |
3715072 | 3715072 | 2022-12-06 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-07 04:20:58 | Washington, Georgia, US | |
2418223 | 2418223 | 2022-12-05 | US | Virginia | Giles | 51071 | 4970 | 53 | 0 | 37.31234791 | -80.70636931 | 2022-12-06 04:21:03 | Giles, Virginia, US | |
2415777 | 2415777 | 2022-12-05 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-06 04:21:03 | Washington, Georgia, US | |
719385 | 719385 | 2022-12-04 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-05 04:20:58 | Washington, Georgia, US | |
2817674 | 2817674 | 2022-12-03 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-04 04:20:56 | Washington, Georgia, US | |
834530 | 834530 | 2022-12-02 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-03 04:21:02 | Washington, Georgia, US | |
2137060 | 2137060 | 2022-12-01 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-02 04:21:07 | Washington, Georgia, US | |
1965476 | 1965476 | 2022-11-30 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-12-01 04:21:03 | Washington, Georgia, US | |
2557490 | 2557490 | 2022-11-29 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-11-30 04:21:07 | Washington, Georgia, US | |
1240564 | 1240564 | 2022-11-28 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-11-29 04:21:05 | Washington, Georgia, US | |
3552552 | 3552552 | 2022-11-27 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-11-28 04:21:02 | Washington, Georgia, US | |
2101032 | 2101032 | 2022-11-26 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-11-27 04:21:05 | Washington, Georgia, US | |
488523 | 488523 | 2022-11-25 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-11-26 04:21:11 | Washington, Georgia, US | |
3524352 | 3524352 | 2022-11-24 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-11-25 04:21:06 | Washington, Georgia, US | |
3313135 | 3313135 | 2022-11-23 | US | Georgia | Washington | 13303 | 4970 | 141 | 0 | 32.96711864 | -82.79357039 | 2022-11-24 04:21:09 | Washington, Georgia, US | |
1049601 | 1049601 | 2022-11-06 | Canada | Yukon | 4970 | 32 | 0 | 64.2823 | -135.0 | 2022-11-07 04:21:26 | Yukon, Canada | |||
617625 | 617625 | 2022-11-05 | Canada | Yukon | 4970 | 32 | 0 | 64.2823 | -135.0 | 2022-11-06 04:21:24 | Yukon, Canada | |||
1022129 | 1022129 | 2022-11-04 | Canada | Yukon | 4970 | 32 | 0 | 64.2823 | -135.0 | 2022-11-05 04:21:52 | Yukon, Canada | |||
713376 | 713376 | 2022-11-01 | US | Tennessee | Cannon | 47015 | 4970 | 71 | 0 | 35.80990797 | -86.05738983 | 2022-11-02 04:22:09 | Cannon, Tennessee, US | |
2757887 | 2757887 | 2022-10-18 | US | Illinois | Bond | 17005 | 4970 | 31 | 0 | 38.88829622 | -89.43534887 | 2022-10-19 04:22:26 | Bond, Illinois, US | |
1979841 | 1979841 | 2022-09-25 | US | Texas | Shelby | 48419 | 4970 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-26 04:20:52 | Shelby, Texas, US | |
2653008 | 2653008 | 2022-09-24 | US | Texas | Shelby | 48419 | 4970 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-25 04:23:31 | Shelby, Texas, US | |
387448 | 387448 | 2022-09-23 | US | Texas | Shelby | 48419 | 4970 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-24 04:21:40 | Shelby, Texas, US | |
3571089 | 3571089 | 2022-09-19 | US | Arkansas | Grant | 5053 | 4970 | 62 | 0 | 34.29017991 | -92.42320562 | 2022-09-20 04:22:48 | Grant, Arkansas, US | |
3767359 | 3767359 | 2022-09-11 | US | Kentucky | Union | 21225 | 4970 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-12 04:20:58 | Union, Kentucky, US | |
3825934 | 3825934 | 2022-09-10 | US | Kentucky | Union | 21225 | 4970 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-11 04:20:50 | Union, Kentucky, US | |
964391 | 964391 | 2022-09-09 | US | Kentucky | Union | 21225 | 4970 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-10 04:21:10 | Union, Kentucky, US | |
254793 | 254793 | 2022-09-08 | US | Kentucky | Union | 21225 | 4970 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-09 04:21:11 | Union, Kentucky, US | |
3748459 | 3748459 | 2022-09-07 | US | Virginia | Goochland | 51075 | 4970 | 57 | 0 | 37.71714806 | -77.90381514 | 2022-09-08 04:21:02 | Goochland, Virginia, US | |
3746591 | 3746591 | 2022-09-07 | US | Kentucky | Union | 21225 | 4970 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-08 04:21:02 | Union, Kentucky, US | |
116231 | 116231 | 2022-09-06 | US | Kentucky | Union | 21225 | 4970 | 59 | 0 | 37.66166713 | -87.94300009 | 2022-09-07 04:20:59 | Union, Kentucky, US | |
3777116 | 3777116 | 2022-08-30 | US | Texas | Robertson | 48395 | 4970 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-08-31 04:20:57 | Robertson, Texas, US | |
2832302 | 2832302 | 2022-08-25 | US | West Virginia | Hardy | 54031 | 4970 | 50 | 0 | 39.00683177 | -78.85855301 | 2022-08-26 04:21:02 | Hardy, West Virginia, US | |
1163174 | 1163174 | 2022-08-18 | US | Montana | Hill | 30041 | 4970 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-08-19 04:20:54 | Hill, Montana, US | |
3952498 | 3952498 | 2022-08-17 | US | Montana | Hill | 30041 | 4970 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-08-18 04:21:11 | Hill, Montana, US | |
993000 | 993000 | 2022-08-16 | US | Montana | Hill | 30041 | 4970 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-08-17 04:20:59 | Hill, Montana, US | |
992564 | 992564 | 2022-08-16 | US | Maine | Washington | 23029 | 4970 | 60 | 0 | 45.01607142 | -67.62813524 | 2022-08-17 04:20:59 | Washington, Maine, US | |
2496039 | 2496039 | 2022-08-15 | US | Montana | Hill | 30041 | 4970 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-08-16 04:20:58 | Hill, Montana, US | |
3651016 | 3651016 | 2022-08-14 | US | Washington | Asotin | 53003 | 4970 | 72 | 0 | 46.18894415 | -117.2022851 | 2022-08-15 04:20:59 | Asotin, Washington, US | |
3649589 | 3649589 | 2022-08-14 | US | Montana | Hill | 30041 | 4970 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-08-15 04:20:59 | Hill, Montana, US | |
1972022 | 1972022 | 2022-08-13 | US | Washington | Asotin | 53003 | 4970 | 72 | 0 | 46.18894415 | -117.2022851 | 2022-08-14 04:20:55 | Asotin, Washington, US | |
1970595 | 1970595 | 2022-08-13 | US | Montana | Hill | 30041 | 4970 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-08-14 04:20:55 | Hill, Montana, US | |
2891831 | 2891831 | 2022-08-12 | US | Washington | Asotin | 53003 | 4970 | 72 | 0 | 46.18894415 | -117.2022851 | 2022-08-13 04:20:52 | Asotin, Washington, US | |
2890404 | 2890404 | 2022-08-12 | US | Montana | Hill | 30041 | 4970 | 73 | 0 | 48.62879827 | -110.1129252 | 2022-08-13 04:20:52 | Hill, Montana, US | |
1086560 | 1086560 | 2022-08-09 | US | Arkansas | Drew | 5043 | 4970 | 72 | 0 | 33.59035001 | -91.71777921 | 2022-08-10 04:20:57 | Drew, Arkansas, US | |
3545002 | 3545002 | 2022-08-08 | US | Louisiana | Jackson | 22049 | 4970 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-09 04:20:34 | Jackson, Louisiana, US | |
3408443 | 3408443 | 2022-07-17 | US | Tennessee | Polk | 47139 | 4970 | 82 | 0 | 35.12245443 | -84.52075859 | 2022-07-18 04:20:59 | Polk, Tennessee, US | |
2154643 | 2154643 | 2022-07-16 | US | Tennessee | Polk | 47139 | 4970 | 82 | 0 | 35.12245443 | -84.52075859 | 2022-07-17 04:21:15 | Polk, Tennessee, US | |
2236357 | 2236357 | 2022-06-12 | US | Illinois | Clark | 17023 | 4970 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-06-13 04:21:14 | Clark, Illinois, US | |
3142555 | 3142555 | 2022-06-11 | US | Illinois | Clark | 17023 | 4970 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-06-12 04:20:53 | Clark, Illinois, US | |
1945471 | 1945471 | 2022-06-10 | US | Illinois | Clark | 17023 | 4970 | 52 | 0 | 39.33425789 | -87.78705622 | 2022-06-11 04:21:01 | Clark, Illinois, US | |
3729530 | 3729530 | 2022-06-07 | US | Virginia | Buchanan | 51027 | 4970 | 123 | 0 | 37.26818323 | -82.03749726 | 2022-06-08 04:20:55 | Buchanan, Virginia, US | |
2601447 | 2601447 | 2022-05-05 | US | Virginia | Radford | 51750 | 4970 | 53 | 0 | 37.12222899 | -80.5602732 | 2022-05-06 04:21:00 | Radford, Virginia, US | |
1572796 | 1572796 | 2022-05-03 | US | Colorado | Teller | 8119 | 4970 | 57 | 0 | 38.88133511 | -105.1614893 | 2022-05-04 04:20:59 | Teller, Colorado, US | |
1698059 | 1698059 | 2022-04-28 | US | Minnesota | Hubbard | 27057 | 4970 | 59 | 0 | 47.10778564 | -94.91693868 | 2022-04-29 04:20:59 | Hubbard, Minnesota, US | |
3420138 | 3420138 | 2022-04-17 | US | Texas | Scurry | 48415 | 4970 | 103 | 0 | 32.74613808 | -100.91626640000001 | 2022-04-18 04:21:12 | Scurry, Texas, US | |
307087 | 307087 | 2022-04-16 | US | Texas | Scurry | 48415 | 4970 | 103 | 0 | 32.74613808 | -100.91626640000001 | 2022-04-17 04:20:59 | Scurry, Texas, US | |
306625 | 306625 | 2022-04-16 | US | Puerto Rico | Las Piedras | 72085 | 4970 | 0 | 0 | 18.187527 | -65.86946800000001 | 2022-04-17 04:20:59 | Las Piedras, Puerto Rico, US | |
2673032 | 2673032 | 2022-04-15 | US | Texas | Scurry | 48415 | 4970 | 103 | 0 | 32.74613808 | -100.91626640000001 | 2022-04-16 04:20:48 | Scurry, Texas, US | |
2672570 | 2672570 | 2022-04-15 | US | Puerto Rico | Las Piedras | 72085 | 4970 | 0 | 0 | 18.187527 | -65.86946800000001 | 2022-04-16 04:20:48 | Las Piedras, Puerto Rico, US | |
1226817 | 1226817 | 2022-04-14 | US | Texas | Scurry | 48415 | 4970 | 103 | 0 | 32.74613808 | -100.91626640000001 | 2022-04-15 04:20:57 | Scurry, Texas, US | |
1226355 | 1226355 | 2022-04-14 | US | Puerto Rico | Las Piedras | 72085 | 4970 | 0 | 0 | 18.187527 | -65.86946800000001 | 2022-04-15 04:20:57 | Las Piedras, Puerto Rico, US | |
3206886 | 3206886 | 2022-04-11 | US | Colorado | Elbert | 8039 | 4970 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-12 04:20:49 | Elbert, Colorado, US | |
1576772 | 1576772 | 2022-04-10 | US | Colorado | Elbert | 8039 | 4970 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-11 04:21:02 | Elbert, Colorado, US | |
1653014 | 1653014 | 2022-04-09 | US | Colorado | Elbert | 8039 | 4970 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-10 04:20:52 | Elbert, Colorado, US | |
2116336 | 2116336 | 2022-04-08 | US | Colorado | Elbert | 8039 | 4970 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-09 04:20:42 | Elbert, Colorado, US | |
3320860 | 3320860 | 2022-04-07 | US | Colorado | Elbert | 8039 | 4970 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-08 04:20:48 | Elbert, Colorado, US | |
2801396 | 2801396 | 2022-04-06 | US | Colorado | Elbert | 8039 | 4970 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-04-07 04:20:53 | Elbert, Colorado, US | |
1438530 | 1438530 | 2022-03-28 | US | Missouri | Perry | 29157 | 4970 | 45 | 0 | 37.70660776 | -89.82741088 | 2022-03-29 04:20:46 | Perry, Missouri, US | |
1905569 | 1905569 | 2022-03-22 | US | Alabama | Fayette | 1057 | 4970 | 94 | 0 | 33.72076938 | -87.73886638 | 2022-03-23 04:20:48 | Fayette, Alabama, US | |
3238700 | 3238700 | 2022-03-21 | US | Alabama | Fayette | 1057 | 4970 | 94 | 0 | 33.72076938 | -87.73886638 | 2022-03-22 04:20:54 | Fayette, Alabama, US | |
24773 | 24773 | 2022-03-20 | US | Alabama | Fayette | 1057 | 4970 | 93 | 0 | 33.72076938 | -87.73886638 | 2022-03-21 04:20:50 | Fayette, Alabama, US | |
1656783 | 1656783 | 2022-03-19 | US | Alabama | Fayette | 1057 | 4970 | 93 | 0 | 33.72076938 | -87.73886638 | 2022-03-20 04:20:45 | Fayette, Alabama, US | |
336309 | 336309 | 2022-03-18 | US | Alabama | Fayette | 1057 | 4970 | 93 | 0 | 33.72076938 | -87.73886638 | 2022-03-19 04:20:47 | Fayette, Alabama, US | |
694762 | 694762 | 2022-03-17 | US | Alabama | Fayette | 1057 | 4970 | 93 | 0 | 33.72076938 | -87.73886638 | 2022-03-18 04:20:55 | Fayette, Alabama, US | |
2143534 | 2143534 | 2022-03-09 | US | Virginia | King George | 51099 | 4970 | 36 | 0 | 38.26818502 | -77.15852768 | 2022-03-10 04:20:48 | King George, Virginia, US | |
923045 | 923045 | 2022-03-08 | US | Virginia | King George | 51099 | 4970 | 36 | 0 | 38.26818502 | -77.15852768 | 2022-03-09 04:20:59 | King George, Virginia, US | |
1551332 | 1551332 | 2022-03-07 | US | Virginia | King George | 51099 | 4970 | 36 | 0 | 38.26818502 | -77.15852768 | 2022-03-08 04:20:54 | King George, Virginia, US | |
577869 | 577869 | 2022-02-25 | US | Texas | Burleson | 48051 | 4970 | 65 | 0 | 30.49273808 | -96.62158484 | 2022-02-26 04:21:12 | Burleson, Texas, US | |
2447809 | 2447809 | 2022-02-22 | US | Illinois | Pike | 17149 | 4970 | 64 | 0 | 39.62265059 | -90.8877017 | 2022-02-23 04:21:09 | Pike, Illinois, US | |
3912850 | 3912850 | 2022-02-20 | US | Georgia | Jones | 13169 | 4970 | 104 | 0 | 33.02512137 | -83.56019163 | 2022-02-21 04:21:05 | Jones, Georgia, US | |
3876408 | 3876408 | 2022-02-19 | US | Georgia | Jones | 13169 | 4970 | 104 | 0 | 33.02512137 | -83.56019163 | 2022-02-20 04:21:00 | Jones, Georgia, US | |
3856664 | 3856664 | 2022-02-18 | US | Georgia | Jones | 13169 | 4970 | 104 | 0 | 33.02512137 | -83.56019163 | 2022-02-19 04:21:11 | Jones, Georgia, US | |
1300877 | 1300877 | 2022-02-17 | US | South Carolina | Hampton | 45049 | 4970 | 78 | 0 | 32.77419582 | -81.13845571 | 2022-02-18 04:21:04 | Hampton, South Carolina, US | |
3673220 | 3673220 | 2022-02-15 | US | Maine | Waldo | 23027 | 4970 | 52 | 0 | 44.4858305 | -69.12061935 | 2022-02-16 04:21:10 | Waldo, Maine, US | |
189030 | 189030 | 2022-02-13 | US | Tennessee | Johnson | 47091 | 4970 | 75 | 0 | 36.45523950000001 | -81.84886538 | 2022-02-14 04:20:51 | Johnson, Tennessee, US | |
3075977 | 3075977 | 2022-02-09 | US | Missouri | McDonald | 29119 | 4970 | 62 | 0 | 36.62869595 | -94.34867205 | 2022-02-10 04:21:14 | McDonald, Missouri, US | |
1362753 | 1362753 | 2022-02-08 | US | Alabama | Randolph | 1111 | 4970 | 71 | 0 | 33.29526734 | -85.45708831 | 2022-02-09 04:21:04 | Randolph, Alabama, US | |
461444 | 461444 | 2022-02-02 | US | Nebraska | Dawson | 31047 | 4970 | 31 | 0 | 40.87028216 | -99.82014609999999 | 2022-02-03 04:21:21 | Dawson, Nebraska, US | |
2053777 | 2053777 | 2022-01-25 | US | Missouri | Crawford | 29055 | 4970 | 87 | 0 | 37.97663738 | -91.30528104 | 2022-01-26 04:21:07 | Crawford, Missouri, US | |
1963344 | 1963344 | 2022-01-20 | US | Puerto Rico | Vega Alta | 72143 | 4970 | 0 | 0 | 18.409346 | -66.33725 | 2022-01-21 04:21:09 | Vega Alta, Puerto Rico, US | |
3843225 | 3843225 | 2022-01-15 | US | Puerto Rico | Aguada | 72003 | 4970 | 0 | 0 | 18.360255 | -67.17513100000001 | 2022-01-16 04:21:12 | Aguada, Puerto Rico, US | |
3613707 | 3613707 | 2022-01-12 | US | Colorado | Morgan | 8087 | 4970 | 131 | 0 | 40.26279810000001 | -103.8093302 | 2022-01-13 08:00:09 | Morgan, Colorado, US | |
1115597 | 1115597 | 2022-01-11 | US | Montana | Lake | 30047 | 4970 | 87 | 0 | 47.64514965 | -114.0898013 | 2022-01-12 04:21:44 | Lake, Montana, US | |
2114205 | 2114205 | 2021-12-26 | US | Ohio | Pike | 39131 | 4970 | 88 | 0 | 39.07634001 | -83.06769584 | 2021-12-27 04:21:58 | Pike, Ohio, US | |
3831314 | 3831314 | 2021-12-21 | US | South Carolina | Union | 45087 | 4970 | 113 | 0 | 34.68835752 | -81.61730349 | 2021-12-22 04:21:54 | Union, South Carolina, US | |
3497028 | 3497028 | 2021-12-15 | US | Georgia | Lumpkin | 13187 | 4970 | 110 | 0 | 34.57286511 | -84.00425681 | 2021-12-16 04:22:11 | Lumpkin, Georgia, US | |
1016176 | 1016176 | 2021-11-21 | US | Mississippi | Prentiss | 28117 | 4970 | 83 | 0 | 34.61810501 | -88.51986294 | 2021-11-22 04:22:20 | Prentiss, Mississippi, 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]);