ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,549 rows where county = "Morgan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386226 | 386226 | 2020-07-31 | Morgan | Colorado | 8087 | 674 | 46 |
386431 | 386431 | 2020-07-31 | Morgan | Georgia | 13211 | 191 | 0 |
386603 | 386603 | 2020-07-31 | Morgan | Illinois | 17137 | 184 | 5 |
386692 | 386692 | 2020-07-31 | Morgan | Indiana | 18109 | 422 | 35 |
387020 | 387020 | 2020-07-31 | Morgan | Kentucky | 21175 | 28 | 0 |
387501 | 387501 | 2020-07-31 | Morgan | Missouri | 29141 | 62 | 0 |
388034 | 388034 | 2020-07-31 | Morgan | Ohio | 39115 | 17 | 0 |
388504 | 388504 | 2020-07-31 | Morgan | Tennessee | 47129 | 70 | 1 |
388799 | 388799 | 2020-07-31 | Morgan | Utah | 49029 | 43 | 0 |
389038 | 389038 | 2020-07-31 | Morgan | West Virginia | 54065 | 26 | 0 |
382773 | 382773 | 2020-07-30 | Morgan | Alabama | 1103 | 2125 | 15 |
383008 | 383008 | 2020-07-30 | Morgan | Colorado | 8087 | 673 | 46 |
383213 | 383213 | 2020-07-30 | Morgan | Georgia | 13211 | 183 | 0 |
383385 | 383385 | 2020-07-30 | Morgan | Illinois | 17137 | 176 | 5 |
383474 | 383474 | 2020-07-30 | Morgan | Indiana | 18109 | 420 | 35 |
383802 | 383802 | 2020-07-30 | Morgan | Kentucky | 21175 | 28 | 0 |
384283 | 384283 | 2020-07-30 | Morgan | Missouri | 29141 | 61 | 0 |
384817 | 384817 | 2020-07-30 | Morgan | Ohio | 39115 | 17 | 0 |
385287 | 385287 | 2020-07-30 | Morgan | Tennessee | 47129 | 65 | 1 |
385582 | 385582 | 2020-07-30 | Morgan | Utah | 49029 | 42 | 0 |
385821 | 385821 | 2020-07-30 | Morgan | West Virginia | 54065 | 25 | 0 |
379556 | 379556 | 2020-07-29 | Morgan | Alabama | 1103 | 2057 | 15 |
379791 | 379791 | 2020-07-29 | Morgan | Colorado | 8087 | 673 | 46 |
379996 | 379996 | 2020-07-29 | Morgan | Georgia | 13211 | 177 | 0 |
380168 | 380168 | 2020-07-29 | Morgan | Illinois | 17137 | 167 | 5 |
380257 | 380257 | 2020-07-29 | Morgan | Indiana | 18109 | 414 | 34 |
380585 | 380585 | 2020-07-29 | Morgan | Kentucky | 21175 | 28 | 0 |
381067 | 381067 | 2020-07-29 | Morgan | Missouri | 29141 | 55 | 0 |
381599 | 381599 | 2020-07-29 | Morgan | Ohio | 39115 | 17 | 0 |
382069 | 382069 | 2020-07-29 | Morgan | Tennessee | 47129 | 64 | 1 |
382364 | 382364 | 2020-07-29 | Morgan | Utah | 49029 | 42 | 0 |
382603 | 382603 | 2020-07-29 | Morgan | West Virginia | 54065 | 25 | 0 |
376340 | 376340 | 2020-07-28 | Morgan | Alabama | 1103 | 2023 | 14 |
376574 | 376574 | 2020-07-28 | Morgan | Colorado | 8087 | 673 | 46 |
376779 | 376779 | 2020-07-28 | Morgan | Georgia | 13211 | 175 | 0 |
376951 | 376951 | 2020-07-28 | Morgan | Illinois | 17137 | 161 | 5 |
377040 | 377040 | 2020-07-28 | Morgan | Indiana | 18109 | 411 | 34 |
377368 | 377368 | 2020-07-28 | Morgan | Kentucky | 21175 | 28 | 0 |
377850 | 377850 | 2020-07-28 | Morgan | Missouri | 29141 | 55 | 0 |
378382 | 378382 | 2020-07-28 | Morgan | Ohio | 39115 | 17 | 0 |
378852 | 378852 | 2020-07-28 | Morgan | Tennessee | 47129 | 62 | 1 |
379147 | 379147 | 2020-07-28 | Morgan | Utah | 49029 | 42 | 0 |
379386 | 379386 | 2020-07-28 | Morgan | West Virginia | 54065 | 25 | 0 |
373126 | 373126 | 2020-07-27 | Morgan | Alabama | 1103 | 1997 | 14 |
373360 | 373360 | 2020-07-27 | Morgan | Colorado | 8087 | 673 | 46 |
373565 | 373565 | 2020-07-27 | Morgan | Georgia | 13211 | 157 | 0 |
373736 | 373736 | 2020-07-27 | Morgan | Illinois | 17137 | 160 | 5 |
373825 | 373825 | 2020-07-27 | Morgan | Indiana | 18109 | 405 | 34 |
374153 | 374153 | 2020-07-27 | Morgan | Kentucky | 21175 | 28 | 0 |
374635 | 374635 | 2020-07-27 | Morgan | Missouri | 29141 | 46 | 0 |
375165 | 375165 | 2020-07-27 | Morgan | Ohio | 39115 | 16 | 0 |
375636 | 375636 | 2020-07-27 | Morgan | Tennessee | 47129 | 59 | 1 |
375931 | 375931 | 2020-07-27 | Morgan | Utah | 49029 | 42 | 0 |
376170 | 376170 | 2020-07-27 | Morgan | West Virginia | 54065 | 25 | 0 |
369914 | 369914 | 2020-07-26 | Morgan | Alabama | 1103 | 1957 | 13 |
370148 | 370148 | 2020-07-26 | Morgan | Colorado | 8087 | 672 | 46 |
370353 | 370353 | 2020-07-26 | Morgan | Georgia | 13211 | 155 | 0 |
370524 | 370524 | 2020-07-26 | Morgan | Illinois | 17137 | 156 | 5 |
370613 | 370613 | 2020-07-26 | Morgan | Indiana | 18109 | 405 | 34 |
370941 | 370941 | 2020-07-26 | Morgan | Kentucky | 21175 | 28 | 0 |
371423 | 371423 | 2020-07-26 | Morgan | Missouri | 29141 | 45 | 0 |
371953 | 371953 | 2020-07-26 | Morgan | Ohio | 39115 | 16 | 0 |
372423 | 372423 | 2020-07-26 | Morgan | Tennessee | 47129 | 55 | 1 |
372718 | 372718 | 2020-07-26 | Morgan | Utah | 49029 | 41 | 0 |
372956 | 372956 | 2020-07-26 | Morgan | West Virginia | 54065 | 25 | 0 |
366704 | 366704 | 2020-07-25 | Morgan | Alabama | 1103 | 1936 | 12 |
366938 | 366938 | 2020-07-25 | Morgan | Colorado | 8087 | 672 | 46 |
367143 | 367143 | 2020-07-25 | Morgan | Georgia | 13211 | 147 | 0 |
367314 | 367314 | 2020-07-25 | Morgan | Illinois | 17137 | 153 | 5 |
367403 | 367403 | 2020-07-25 | Morgan | Indiana | 18109 | 397 | 34 |
367731 | 367731 | 2020-07-25 | Morgan | Kentucky | 21175 | 27 | 0 |
368212 | 368212 | 2020-07-25 | Morgan | Missouri | 29141 | 42 | 0 |
368741 | 368741 | 2020-07-25 | Morgan | Ohio | 39115 | 16 | 0 |
369211 | 369211 | 2020-07-25 | Morgan | Tennessee | 47129 | 51 | 1 |
369506 | 369506 | 2020-07-25 | Morgan | Utah | 49029 | 41 | 0 |
369744 | 369744 | 2020-07-25 | Morgan | West Virginia | 54065 | 25 | 0 |
363497 | 363497 | 2020-07-24 | Morgan | Alabama | 1103 | 1885 | 12 |
363731 | 363731 | 2020-07-24 | Morgan | Colorado | 8087 | 670 | 46 |
363936 | 363936 | 2020-07-24 | Morgan | Georgia | 13211 | 132 | 0 |
364107 | 364107 | 2020-07-24 | Morgan | Illinois | 17137 | 151 | 5 |
364196 | 364196 | 2020-07-24 | Morgan | Indiana | 18109 | 395 | 34 |
364524 | 364524 | 2020-07-24 | Morgan | Kentucky | 21175 | 25 | 0 |
365004 | 365004 | 2020-07-24 | Morgan | Missouri | 29141 | 41 | 0 |
365532 | 365532 | 2020-07-24 | Morgan | Ohio | 39115 | 16 | 0 |
366002 | 366002 | 2020-07-24 | Morgan | Tennessee | 47129 | 50 | 1 |
366297 | 366297 | 2020-07-24 | Morgan | Utah | 49029 | 41 | 0 |
366534 | 366534 | 2020-07-24 | Morgan | West Virginia | 54065 | 25 | 0 |
360291 | 360291 | 2020-07-23 | Morgan | Alabama | 1103 | 1853 | 11 |
360524 | 360524 | 2020-07-23 | Morgan | Colorado | 8087 | 666 | 46 |
360729 | 360729 | 2020-07-23 | Morgan | Georgia | 13211 | 129 | 0 |
360900 | 360900 | 2020-07-23 | Morgan | Illinois | 17137 | 148 | 5 |
360989 | 360989 | 2020-07-23 | Morgan | Indiana | 18109 | 392 | 34 |
361317 | 361317 | 2020-07-23 | Morgan | Kentucky | 21175 | 24 | 0 |
361797 | 361797 | 2020-07-23 | Morgan | Missouri | 29141 | 38 | 0 |
362326 | 362326 | 2020-07-23 | Morgan | Ohio | 39115 | 16 | 0 |
362796 | 362796 | 2020-07-23 | Morgan | Tennessee | 47129 | 50 | 1 |
363091 | 363091 | 2020-07-23 | Morgan | Utah | 49029 | 41 | 0 |
363327 | 363327 | 2020-07-23 | Morgan | West Virginia | 54065 | 25 | 0 |
357086 | 357086 | 2020-07-22 | Morgan | Alabama | 1103 | 1808 | 11 |
357319 | 357319 | 2020-07-22 | Morgan | Colorado | 8087 | 666 | 46 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);