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 |
---|---|---|---|---|---|---|---|
357524 | 357524 | 2020-07-22 | Morgan | Georgia | 13211 | 119 | 0 |
357695 | 357695 | 2020-07-22 | Morgan | Illinois | 17137 | 146 | 5 |
357784 | 357784 | 2020-07-22 | Morgan | Indiana | 18109 | 379 | 34 |
358112 | 358112 | 2020-07-22 | Morgan | Kentucky | 21175 | 24 | 0 |
358592 | 358592 | 2020-07-22 | Morgan | Missouri | 29141 | 37 | 0 |
359120 | 359120 | 2020-07-22 | Morgan | Ohio | 39115 | 15 | 0 |
359589 | 359589 | 2020-07-22 | Morgan | Tennessee | 47129 | 46 | 1 |
359884 | 359884 | 2020-07-22 | Morgan | Utah | 49029 | 41 | 0 |
360121 | 360121 | 2020-07-22 | Morgan | West Virginia | 54065 | 25 | 0 |
353883 | 353883 | 2020-07-21 | Morgan | Alabama | 1103 | 1767 | 10 |
354116 | 354116 | 2020-07-21 | Morgan | Colorado | 8087 | 665 | 46 |
354321 | 354321 | 2020-07-21 | Morgan | Georgia | 13211 | 112 | 0 |
354493 | 354493 | 2020-07-21 | Morgan | Illinois | 17137 | 145 | 5 |
354582 | 354582 | 2020-07-21 | Morgan | Indiana | 18109 | 379 | 34 |
354909 | 354909 | 2020-07-21 | Morgan | Kentucky | 21175 | 24 | 0 |
355389 | 355389 | 2020-07-21 | Morgan | Missouri | 29141 | 34 | 0 |
355916 | 355916 | 2020-07-21 | Morgan | Ohio | 39115 | 15 | 0 |
356385 | 356385 | 2020-07-21 | Morgan | Tennessee | 47129 | 45 | 1 |
356679 | 356679 | 2020-07-21 | Morgan | Utah | 49029 | 41 | 0 |
356916 | 356916 | 2020-07-21 | Morgan | West Virginia | 54065 | 22 | 0 |
350681 | 350681 | 2020-07-20 | Morgan | Alabama | 1103 | 1744 | 10 |
350914 | 350914 | 2020-07-20 | Morgan | Colorado | 8087 | 665 | 46 |
351119 | 351119 | 2020-07-20 | Morgan | Georgia | 13211 | 115 | 0 |
351291 | 351291 | 2020-07-20 | Morgan | Illinois | 17137 | 145 | 5 |
351380 | 351380 | 2020-07-20 | Morgan | Indiana | 18109 | 381 | 34 |
351707 | 351707 | 2020-07-20 | Morgan | Kentucky | 21175 | 23 | 0 |
352187 | 352187 | 2020-07-20 | Morgan | Missouri | 29141 | 34 | 0 |
352713 | 352713 | 2020-07-20 | Morgan | Ohio | 39115 | 14 | 0 |
353182 | 353182 | 2020-07-20 | Morgan | Tennessee | 47129 | 42 | 1 |
353476 | 353476 | 2020-07-20 | Morgan | Utah | 49029 | 40 | 0 |
353713 | 353713 | 2020-07-20 | Morgan | West Virginia | 54065 | 22 | 0 |
347480 | 347480 | 2020-07-19 | Morgan | Alabama | 1103 | 1685 | 10 |
347713 | 347713 | 2020-07-19 | Morgan | Colorado | 8087 | 665 | 46 |
347918 | 347918 | 2020-07-19 | Morgan | Georgia | 13211 | 107 | 0 |
348091 | 348091 | 2020-07-19 | Morgan | Illinois | 17137 | 145 | 5 |
348180 | 348180 | 2020-07-19 | Morgan | Indiana | 18109 | 380 | 34 |
348507 | 348507 | 2020-07-19 | Morgan | Kentucky | 21175 | 23 | 0 |
348987 | 348987 | 2020-07-19 | Morgan | Missouri | 29141 | 31 | 0 |
349510 | 349510 | 2020-07-19 | Morgan | Ohio | 39115 | 14 | 0 |
349979 | 349979 | 2020-07-19 | Morgan | Tennessee | 47129 | 41 | 1 |
350274 | 350274 | 2020-07-19 | Morgan | Utah | 49029 | 39 | 0 |
350511 | 350511 | 2020-07-19 | Morgan | West Virginia | 54065 | 21 | 0 |
344280 | 344280 | 2020-07-18 | Morgan | Alabama | 1103 | 1641 | 10 |
344513 | 344513 | 2020-07-18 | Morgan | Colorado | 8087 | 665 | 46 |
344718 | 344718 | 2020-07-18 | Morgan | Georgia | 13211 | 102 | 0 |
344890 | 344890 | 2020-07-18 | Morgan | Illinois | 17137 | 142 | 5 |
344979 | 344979 | 2020-07-18 | Morgan | Indiana | 18109 | 377 | 34 |
345306 | 345306 | 2020-07-18 | Morgan | Kentucky | 21175 | 22 | 0 |
345786 | 345786 | 2020-07-18 | Morgan | Missouri | 29141 | 29 | 0 |
346309 | 346309 | 2020-07-18 | Morgan | Ohio | 39115 | 14 | 0 |
346779 | 346779 | 2020-07-18 | Morgan | Tennessee | 47129 | 40 | 1 |
347074 | 347074 | 2020-07-18 | Morgan | Utah | 49029 | 36 | 0 |
347310 | 347310 | 2020-07-18 | Morgan | West Virginia | 54065 | 21 | 0 |
341081 | 341081 | 2020-07-17 | Morgan | Alabama | 1103 | 1596 | 10 |
341314 | 341314 | 2020-07-17 | Morgan | Colorado | 8087 | 665 | 46 |
341519 | 341519 | 2020-07-17 | Morgan | Georgia | 13211 | 100 | 0 |
341690 | 341690 | 2020-07-17 | Morgan | Illinois | 17137 | 138 | 4 |
341779 | 341779 | 2020-07-17 | Morgan | Indiana | 18109 | 375 | 34 |
342106 | 342106 | 2020-07-17 | Morgan | Kentucky | 21175 | 21 | 0 |
342586 | 342586 | 2020-07-17 | Morgan | Missouri | 29141 | 28 | 0 |
343110 | 343110 | 2020-07-17 | Morgan | Ohio | 39115 | 14 | 0 |
343579 | 343579 | 2020-07-17 | Morgan | Tennessee | 47129 | 38 | 1 |
343873 | 343873 | 2020-07-17 | Morgan | Utah | 49029 | 36 | 0 |
344110 | 344110 | 2020-07-17 | Morgan | West Virginia | 54065 | 20 | 0 |
337885 | 337885 | 2020-07-16 | Morgan | Alabama | 1103 | 1534 | 7 |
338117 | 338117 | 2020-07-16 | Morgan | Colorado | 8087 | 663 | 46 |
338322 | 338322 | 2020-07-16 | Morgan | Georgia | 13211 | 94 | 0 |
338494 | 338494 | 2020-07-16 | Morgan | Illinois | 17137 | 137 | 4 |
338583 | 338583 | 2020-07-16 | Morgan | Indiana | 18109 | 364 | 34 |
338910 | 338910 | 2020-07-16 | Morgan | Kentucky | 21175 | 20 | 0 |
339390 | 339390 | 2020-07-16 | Morgan | Missouri | 29141 | 28 | 0 |
339912 | 339912 | 2020-07-16 | Morgan | Ohio | 39115 | 13 | 0 |
340381 | 340381 | 2020-07-16 | Morgan | Tennessee | 47129 | 38 | 1 |
340674 | 340674 | 2020-07-16 | Morgan | Utah | 49029 | 34 | 0 |
340911 | 340911 | 2020-07-16 | Morgan | West Virginia | 54065 | 20 | 0 |
334690 | 334690 | 2020-07-15 | Morgan | Alabama | 1103 | 1506 | 7 |
334922 | 334922 | 2020-07-15 | Morgan | Colorado | 8087 | 663 | 46 |
335127 | 335127 | 2020-07-15 | Morgan | Georgia | 13211 | 91 | 0 |
335298 | 335298 | 2020-07-15 | Morgan | Illinois | 17137 | 135 | 4 |
335387 | 335387 | 2020-07-15 | Morgan | Indiana | 18109 | 358 | 34 |
335714 | 335714 | 2020-07-15 | Morgan | Kentucky | 21175 | 20 | 0 |
336194 | 336194 | 2020-07-15 | Morgan | Missouri | 29141 | 28 | 0 |
336716 | 336716 | 2020-07-15 | Morgan | Ohio | 39115 | 13 | 0 |
337184 | 337184 | 2020-07-15 | Morgan | Tennessee | 47129 | 37 | 1 |
337478 | 337478 | 2020-07-15 | Morgan | Utah | 49029 | 34 | 0 |
337715 | 337715 | 2020-07-15 | Morgan | West Virginia | 54065 | 20 | 0 |
331497 | 331497 | 2020-07-14 | Morgan | Alabama | 1103 | 1446 | 6 |
331729 | 331729 | 2020-07-14 | Morgan | Colorado | 8087 | 661 | 46 |
331934 | 331934 | 2020-07-14 | Morgan | Georgia | 13211 | 88 | 0 |
332105 | 332105 | 2020-07-14 | Morgan | Illinois | 17137 | 134 | 4 |
332194 | 332194 | 2020-07-14 | Morgan | Indiana | 18109 | 355 | 34 |
332521 | 332521 | 2020-07-14 | Morgan | Kentucky | 21175 | 20 | 0 |
333001 | 333001 | 2020-07-14 | Morgan | Missouri | 29141 | 28 | 0 |
333522 | 333522 | 2020-07-14 | Morgan | Ohio | 39115 | 13 | 0 |
333990 | 333990 | 2020-07-14 | Morgan | Tennessee | 47129 | 34 | 1 |
334283 | 334283 | 2020-07-14 | Morgan | Utah | 49029 | 33 | 0 |
334520 | 334520 | 2020-07-14 | Morgan | West Virginia | 54065 | 20 | 0 |
328311 | 328311 | 2020-07-13 | Morgan | Alabama | 1103 | 1413 | 5 |
328543 | 328543 | 2020-07-13 | Morgan | Colorado | 8087 | 660 | 46 |
328747 | 328747 | 2020-07-13 | Morgan | Georgia | 13211 | 81 | 0 |
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);