johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
282 rows where confirmed = 2773 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
309162 | 309162 | 2022-12-13 | US | Kansas | Coffey | 20031 | 2773 | 47 | 0 | 38.2365018 | -95.73379515 | 2022-12-14 04:21:04 | Coffey, Kansas, US | |
1150223 | 1150223 | 2022-12-12 | US | Kansas | Coffey | 20031 | 2773 | 47 | 0 | 38.2365018 | -95.73379515 | 2022-12-13 04:21:01 | Coffey, Kansas, US | |
870077 | 870077 | 2022-12-11 | US | Kansas | Coffey | 20031 | 2773 | 47 | 0 | 38.2365018 | -95.73379515 | 2022-12-12 04:21:01 | Coffey, Kansas, US | |
258607 | 258607 | 2022-12-10 | US | Kansas | Coffey | 20031 | 2773 | 47 | 0 | 38.2365018 | -95.73379515 | 2022-12-11 04:20:50 | Coffey, Kansas, US | |
3937321 | 3937321 | 2022-12-09 | US | Kansas | Coffey | 20031 | 2773 | 47 | 0 | 38.2365018 | -95.73379515 | 2022-12-10 04:21:02 | Coffey, Kansas, US | |
3378653 | 3378653 | 2022-12-08 | US | Kansas | Coffey | 20031 | 2773 | 47 | 0 | 38.2365018 | -95.73379515 | 2022-12-09 04:21:05 | Coffey, Kansas, US | |
1985924 | 1985924 | 2022-12-07 | US | Kansas | Coffey | 20031 | 2773 | 47 | 0 | 38.2365018 | -95.73379515 | 2022-12-08 04:21:07 | Coffey, Kansas, US | |
323328 | 323328 | 2022-10-30 | US | Virginia | Poquoson | 51735 | 2773 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-10-31 04:21:36 | Poquoson, Virginia, US | |
915604 | 915604 | 2022-10-29 | US | Virginia | Poquoson | 51735 | 2773 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-10-30 04:22:14 | Poquoson, Virginia, US | |
1369873 | 1369873 | 2022-10-28 | US | Virginia | Poquoson | 51735 | 2773 | 31 | 0 | 37.14259351 | -76.35798148 | 2022-10-29 04:21:13 | Poquoson, Virginia, US | |
2017943 | 2017943 | 2022-09-20 | US | Iowa | Louisa | 19115 | 2773 | 64 | 0 | 41.21842119 | -91.26102611 | 2022-09-21 04:23:22 | Louisa, Iowa, US | |
3571816 | 3571816 | 2022-09-19 | US | Iowa | Louisa | 19115 | 2773 | 64 | 0 | 41.21842119 | -91.26102611 | 2022-09-20 04:22:48 | Louisa, Iowa, US | |
422795 | 422795 | 2022-09-18 | US | Washington | Pend Oreille | 53051 | 2773 | 39 | 0 | 48.53234021 | -117.2741804 | 2022-09-19 04:21:49 | Pend Oreille, Washington, US | |
420555 | 420555 | 2022-09-18 | US | Iowa | Louisa | 19115 | 2773 | 64 | 0 | 41.21842119 | -91.26102611 | 2022-09-19 04:21:49 | Louisa, Iowa, US | |
3376819 | 3376819 | 2022-09-17 | US | Washington | Pend Oreille | 53051 | 2773 | 39 | 0 | 48.53234021 | -117.2741804 | 2022-09-18 04:22:50 | Pend Oreille, Washington, US | |
3374579 | 3374579 | 2022-09-17 | US | Iowa | Louisa | 19115 | 2773 | 64 | 0 | 41.21842119 | -91.26102611 | 2022-09-18 04:22:50 | Louisa, Iowa, US | |
2358927 | 2358927 | 2022-09-16 | US | Washington | Pend Oreille | 53051 | 2773 | 39 | 0 | 48.53234021 | -117.2741804 | 2022-09-17 04:20:19 | Pend Oreille, Washington, US | |
2356687 | 2356687 | 2022-09-16 | US | Iowa | Louisa | 19115 | 2773 | 64 | 0 | 41.21842119 | -91.26102611 | 2022-09-17 04:20:19 | Louisa, Iowa, US | |
3990029 | 3990029 | 2022-09-15 | US | Virginia | Richmond | 51159 | 2773 | 27 | 0 | 37.937575 | -76.72920628 | 2022-09-16 04:21:19 | Richmond, Virginia, US | |
3987844 | 3987844 | 2022-09-15 | US | Iowa | Louisa | 19115 | 2773 | 64 | 0 | 41.21842119 | -91.26102611 | 2022-09-16 04:21:19 | Louisa, Iowa, US | |
1890361 | 1890361 | 2022-09-14 | US | Iowa | Louisa | 19115 | 2773 | 64 | 0 | 41.21842119 | -91.26102611 | 2022-09-15 04:21:02 | Louisa, Iowa, US | |
2395406 | 2395406 | 2022-09-12 | US | Colorado | Bent | 8011 | 2773 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-13 04:20:57 | Bent, Colorado, US | |
3766949 | 3766949 | 2022-09-11 | US | Indiana | Benton | 18007 | 2773 | 24 | 0 | 40.60626947 | -87.31093999 | 2022-09-12 04:20:58 | Benton, Indiana, US | |
3825524 | 3825524 | 2022-09-10 | US | Indiana | Benton | 18007 | 2773 | 24 | 0 | 40.60626947 | -87.31093999 | 2022-09-11 04:20:50 | Benton, Indiana, US | |
963981 | 963981 | 2022-09-09 | US | Indiana | Benton | 18007 | 2773 | 24 | 0 | 40.60626947 | -87.31093999 | 2022-09-10 04:21:10 | Benton, Indiana, US | |
3910746 | 3910746 | 2022-08-11 | US | Puerto Rico | Guanica | 72055 | 2773 | 0 | 0 | 17.982429 | -66.919643 | 2022-08-12 04:20:54 | Guanica, Puerto Rico, US | |
2011741 | 2011741 | 2022-08-04 | US | Texas | Childress | 48075 | 2773 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-08-05 04:20:52 | Childress, Texas, US | |
1101168 | 1101168 | 2022-08-03 | US | Texas | Childress | 48075 | 2773 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-08-04 04:20:58 | Childress, Texas, US | |
961852 | 961852 | 2022-07-19 | US | Tennessee | Houston | 47083 | 2773 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-07-20 04:20:59 | Houston, Tennessee, US | |
3213239 | 3213239 | 2022-07-18 | US | Tennessee | Houston | 47083 | 2773 | 62 | 0 | 36.28872054 | -87.71878828 | 2022-07-19 04:20:58 | Houston, Tennessee, US | |
2419541 | 2419541 | 2022-07-15 | US | Colorado | Prowers | 8099 | 2773 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-07-16 04:21:05 | Prowers, Colorado, US | |
632215 | 632215 | 2022-07-12 | US | North Carolina | Clay | 37043 | 2773 | 47 | 0 | 35.05704275 | -83.74353633 | 2022-07-13 04:20:58 | Clay, North Carolina, US | |
1213859 | 1213859 | 2022-07-11 | US | North Carolina | Clay | 37043 | 2773 | 47 | 0 | 35.05704275 | -83.74353633 | 2022-07-12 04:20:51 | Clay, North Carolina, US | |
2791341 | 2791341 | 2022-07-10 | US | North Carolina | Clay | 37043 | 2773 | 47 | 0 | 35.05704275 | -83.74353633 | 2022-07-11 04:20:46 | Clay, North Carolina, US | |
144294 | 144294 | 2022-07-09 | US | North Carolina | Clay | 37043 | 2773 | 47 | 0 | 35.05704275 | -83.74353633 | 2022-07-10 04:20:54 | Clay, North Carolina, US | |
1419394 | 1419394 | 2022-07-08 | US | North Carolina | Clay | 37043 | 2773 | 47 | 0 | 35.05704275 | -83.74353633 | 2022-07-09 04:20:59 | Clay, North Carolina, US | |
2743319 | 2743319 | 2022-07-07 | US | North Carolina | Clay | 37043 | 2773 | 47 | 0 | 35.05704275 | -83.74353633 | 2022-07-08 04:20:56 | Clay, North Carolina, US | |
1202114 | 1202114 | 2022-07-06 | US | North Carolina | Clay | 37043 | 2773 | 47 | 0 | 35.05704275 | -83.74353633 | 2022-07-07 04:20:55 | Clay, North Carolina, US | |
3969930 | 3969930 | 2022-07-05 | US | Virginia | Nelson | 51125 | 2773 | 36 | 0 | 37.78790447 | -78.88498513 | 2022-07-06 04:20:58 | Nelson, Virginia, US | |
3077868 | 3077868 | 2022-07-04 | China | Shandong | 2773 | 7 | 0 | 36.3427 | 118.1498 | 2022-07-05 04:20:45 | Shandong, China | |||
232550 | 232550 | 2022-05-31 | US | Virginia | Clarke | 51043 | 2773 | 43 | 0 | 39.11271747 | -77.99199425 | 2022-06-01 04:20:55 | Clarke, Virginia, US | |
1572974 | 1572974 | 2022-05-03 | US | Georgia | Long | 13183 | 2773 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-05-04 04:20:59 | Long, Georgia, US | |
464234 | 464234 | 2022-05-02 | US | Georgia | Long | 13183 | 2773 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-05-03 04:21:00 | Long, Georgia, US | |
3916873 | 3916873 | 2022-05-01 | US | Georgia | Long | 13183 | 2773 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-05-02 04:21:10 | Long, Georgia, US | |
2841677 | 2841677 | 2022-04-30 | US | Georgia | Long | 13183 | 2773 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-05-01 04:20:57 | Long, Georgia, US | |
1157990 | 1157990 | 2022-04-29 | US | Georgia | Long | 13183 | 2773 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-04-30 04:21:05 | Long, Georgia, US | |
1697172 | 1697172 | 2022-04-28 | US | Georgia | Long | 13183 | 2773 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-04-29 04:20:59 | Long, Georgia, US | |
3852655 | 3852655 | 2022-04-27 | US | Georgia | Long | 13183 | 2773 | 35 | 0 | 31.75218791 | -81.74952375 | 2022-04-28 04:20:47 | Long, Georgia, US | |
3723221 | 3723221 | 2022-04-25 | US | Illinois | Marshall | 17123 | 2773 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-04-26 04:20:51 | Marshall, Illinois, US | |
2029789 | 2029789 | 2022-04-24 | US | Illinois | Marshall | 17123 | 2773 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-04-25 04:20:56 | Marshall, Illinois, US | |
747364 | 747364 | 2022-04-23 | US | Illinois | Marshall | 17123 | 2773 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-04-24 04:20:56 | Marshall, Illinois, US | |
3437849 | 3437849 | 2022-04-22 | US | Illinois | Marshall | 17123 | 2773 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-04-23 04:20:50 | Marshall, Illinois, US | |
2443227 | 2443227 | 2022-04-13 | US | Arkansas | Chicot | 5017 | 2773 | 60 | 0 | 33.26458973 | -91.29539209 | 2022-04-13 23:21:06 | Chicot, Arkansas, US | |
2480531 | 2480531 | 2022-03-30 | US | Oklahoma | Haskell | 40061 | 2773 | 39 | 0 | 35.22257600000001 | -95.11513306 | 2022-03-31 04:20:56 | Haskell, Oklahoma, US | |
160572 | 160572 | 2022-03-29 | US | Oklahoma | Haskell | 40061 | 2773 | 39 | 0 | 35.22257600000001 | -95.11513306 | 2022-03-30 04:20:45 | Haskell, Oklahoma, US | |
1439143 | 1439143 | 2022-03-28 | US | Oklahoma | Haskell | 40061 | 2773 | 39 | 0 | 35.22257600000001 | -95.11513306 | 2022-03-29 04:20:46 | Haskell, Oklahoma, US | |
878824 | 878824 | 2022-03-27 | US | Oklahoma | Haskell | 40061 | 2773 | 39 | 0 | 35.22257600000001 | -95.11513306 | 2022-03-28 04:20:33 | Haskell, Oklahoma, US | |
2166107 | 2166107 | 2022-03-26 | US | Oklahoma | Haskell | 40061 | 2773 | 39 | 0 | 35.22257600000001 | -95.11513306 | 2022-03-27 04:20:47 | Haskell, Oklahoma, US | |
1723043 | 1723043 | 2022-03-25 | US | Oklahoma | Haskell | 40061 | 2773 | 39 | 0 | 35.22257600000001 | -95.11513306 | 2022-03-26 04:20:23 | Haskell, Oklahoma, US | |
1470660 | 1470660 | 2022-03-24 | US | Oklahoma | Haskell | 40061 | 2773 | 39 | 0 | 35.22257600000001 | -95.11513306 | 2022-03-25 04:20:46 | Haskell, Oklahoma, US | |
3241136 | 3241136 | 2022-03-21 | US | South Carolina | Calhoun | 45017 | 2773 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-03-22 04:20:54 | Calhoun, South Carolina, US | |
27209 | 27209 | 2022-03-20 | US | South Carolina | Calhoun | 45017 | 2773 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-03-21 04:20:50 | Calhoun, South Carolina, US | |
1659219 | 1659219 | 2022-03-19 | US | South Carolina | Calhoun | 45017 | 2773 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-03-20 04:20:45 | Calhoun, South Carolina, US | |
338745 | 338745 | 2022-03-18 | US | South Carolina | Calhoun | 45017 | 2773 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-03-19 04:20:47 | Calhoun, South Carolina, US | |
697198 | 697198 | 2022-03-17 | US | South Carolina | Calhoun | 45017 | 2773 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-03-18 04:20:55 | Calhoun, South Carolina, US | |
2322141 | 2322141 | 2022-03-16 | US | South Carolina | Calhoun | 45017 | 2773 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-03-17 04:20:56 | Calhoun, South Carolina, US | |
264341 | 264341 | 2022-03-15 | US | South Carolina | Calhoun | 45017 | 2773 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-03-16 04:20:50 | Calhoun, South Carolina, US | |
577875 | 577875 | 2022-02-25 | US | Texas | Camp | 48063 | 2773 | 72 | 0 | 32.97195142 | -94.97790104 | 2022-02-26 04:21:12 | Camp, Texas, US | |
1299415 | 1299415 | 2022-02-17 | US | Kansas | Wilson | 20205 | 2773 | 38 | 0 | 37.55937174 | -95.74323255 | 2022-02-18 04:21:04 | Wilson, Kansas, US | |
3821801 | 3821801 | 2022-02-16 | US | Kansas | Wilson | 20205 | 2773 | 38 | 0 | 37.55937174 | -95.74323255 | 2022-02-17 04:20:56 | Wilson, Kansas, US | |
3672964 | 3672964 | 2022-02-15 | US | Kansas | Linn | 20107 | 2773 | 24 | 0 | 38.21267844 | -94.84254089 | 2022-02-16 04:21:10 | Linn, Kansas, US | |
318707 | 318707 | 2022-02-12 | US | Puerto Rico | Villalba | 72149 | 2773 | 0 | 0 | 18.127951 | -66.473115 | 2022-02-13 04:21:00 | Villalba, Puerto Rico, US | |
236033 | 236033 | 2022-02-11 | US | Puerto Rico | Villalba | 72149 | 2773 | 0 | 0 | 18.127951 | -66.473115 | 2022-02-12 04:21:06 | Villalba, Puerto Rico, US | |
1464737 | 1464737 | 2022-02-10 | US | Colorado | Rio Grande | 8105 | 2773 | 46 | 0 | 37.5836865 | -106.3847838 | 2022-02-11 04:21:09 | Rio Grande, Colorado, US | |
3075596 | 3075596 | 2022-02-09 | US | Louisiana | West Feliciana | 22125 | 2773 | 42 | 0 | 30.87882871 | -91.41485379999999 | 2022-02-10 04:21:14 | West Feliciana, Louisiana, US | |
3467601 | 3467601 | 2022-01-18 | US | Virginia | Westmoreland | 51193 | 2773 | 39 | 0 | 38.11021557 | -76.80213247 | 2022-01-19 04:21:23 | Westmoreland, Virginia, US | |
3464683 | 3464683 | 2022-01-18 | US | Arkansas | Marion | 5089 | 2773 | 76 | 0 | 36.26844485 | -92.68451899 | 2022-01-19 04:21:23 | Marion, Arkansas, US | |
1693742 | 1693742 | 2022-01-10 | US | Kentucky | Knott | 21119 | 2773 | 49 | 0 | 37.35388197 | -82.94981134 | 2022-01-11 04:22:01 | Knott, Kentucky, US | |
800356 | 800356 | 2021-12-22 | US | Missouri | Livingston | 29117 | 2773 | 80 | 0 | 39.78110272 | -93.54645978 | 2021-12-23 04:21:21 | Livingston, Missouri, US | |
2091538 | 2091538 | 2021-12-14 | US | Wisconsin | Marquette | 55077 | 2773 | 38 | 0 | 43.81911946 | -89.40073763 | 2021-12-15 03:22:16 | Marquette, Wisconsin, US | |
2090048 | 2090048 | 2021-12-14 | US | Nebraska | Gage | 31067 | 2773 | 19 | 0 | 40.26186809 | -96.68946704 | 2021-12-15 03:22:16 | Gage, Nebraska, US | |
1667194 | 1667194 | 2021-12-11 | US | Puerto Rico | Juncos | 72077 | 2773 | 0 | 0 | 18.223793 | -65.909109 | 2021-12-12 04:22:12 | Juncos, Puerto Rico, US | |
3659079 | 3659079 | 2021-12-10 | US | West Virginia | Hardy | 54031 | 2773 | 37 | 0 | 39.00683177 | -78.85855301 | 2021-12-11 04:22:45 | Hardy, West Virginia, US | |
3658346 | 3658346 | 2021-12-10 | US | Puerto Rico | Juncos | 72077 | 2773 | 0 | 0 | 18.223793 | -65.909109 | 2021-12-11 04:22:45 | Juncos, Puerto Rico, US | |
2197066 | 2197066 | 2021-12-03 | US | Kentucky | Mason | 21161 | 2773 | 74 | 0 | 38.59471935 | -83.82151043 | 2021-12-04 04:22:18 | Mason, Kentucky, US | |
2196230 | 2196230 | 2021-12-03 | US | Colorado | Chaffee | 8015 | 2773 | 38 | 0 | 38.74745778 | -106.19265729999998 | 2021-12-04 04:22:18 | Chaffee, Colorado, US | |
3405095 | 3405095 | 2021-11-30 | United Kingdom | British Virgin Islands | 2773 | 38 | 0 | 18.4207 | -64.64 | 2021-12-01 04:22:29 | British Virgin Islands, United Kingdom | |||
153638 | 153638 | 2021-11-29 | United Kingdom | British Virgin Islands | 2773 | 38 | 0 | 18.4207 | -64.64 | 2021-11-30 04:22:53 | British Virgin Islands, United Kingdom | |||
1235284 | 1235284 | 2021-11-28 | United Kingdom | British Virgin Islands | 2773 | 38 | 0 | 18.4207 | -64.64 | 2021-11-29 04:22:30 | British Virgin Islands, United Kingdom | |||
1361991 | 1361991 | 2021-11-27 | United Kingdom | British Virgin Islands | 2773 | 38 | 0 | 18.4207 | -64.64 | 2021-11-28 04:22:43 | British Virgin Islands, United Kingdom | |||
761982 | 761982 | 2021-11-26 | United Kingdom | British Virgin Islands | 2773 | 38 | 0 | 18.4207 | -64.64 | 2021-11-27 04:22:45 | British Virgin Islands, United Kingdom | |||
1806399 | 1806399 | 2021-11-25 | United Kingdom | British Virgin Islands | 2773 | 38 | 0 | 18.4207 | -64.64 | 2021-11-26 04:22:33 | British Virgin Islands, United Kingdom | |||
3749324 | 3749324 | 2021-11-22 | Russia | Chukotka Autonomous Okrug | 2773 | 23 | 0 | 66.0006475 | 169.4900869 | 2021-11-23 04:22:39 | Chukotka Autonomous Okrug, Russia | |||
1017694 | 1017694 | 2021-11-21 | US | Virginia | King George | 51099 | 2773 | 24 | 0 | 38.26818502 | -77.15852768 | 2021-11-22 04:22:20 | King George, Virginia, US | |
1015847 | 1015847 | 2021-11-21 | US | Louisiana | LaSalle | 22059 | 2773 | 46 | 0 | 31.67884782 | -92.15907765 | 2021-11-22 04:22:20 | LaSalle, Louisiana, US | |
725858 | 725858 | 2021-11-20 | US | Virginia | King George | 51099 | 2773 | 24 | 0 | 38.26818502 | -77.15852768 | 2021-11-21 04:22:13 | King George, Virginia, US | |
724011 | 724011 | 2021-11-20 | US | Louisiana | LaSalle | 22059 | 2773 | 46 | 0 | 31.67884782 | -92.15907765 | 2021-11-21 04:22:13 | LaSalle, Louisiana, US | |
165388 | 165388 | 2021-11-19 | US | Virginia | King George | 51099 | 2773 | 24 | 0 | 38.26818502 | -77.15852768 | 2021-11-20 04:22:17 | King George, Virginia, US | |
163541 | 163541 | 2021-11-19 | US | Louisiana | LaSalle | 22059 | 2773 | 46 | 0 | 31.67884782 | -92.15907765 | 2021-11-20 04:22:17 | LaSalle, Louisiana, US | |
162500 | 162500 | 2021-11-19 | US | Arkansas | Clay | 5021 | 2773 | 74 | 0 | 36.36826212 | -90.4148172 | 2021-11-20 04:22:17 | Clay, 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]);