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 |
---|---|---|---|---|---|---|---|
268269 | 268269 | 2020-06-24 | Morgan | Alabama | 1103 | 825 | 2 |
268497 | 268497 | 2020-06-24 | Morgan | Colorado | 8087 | 649 | 46 |
268701 | 268701 | 2020-06-24 | Morgan | Georgia | 13211 | 45 | 0 |
268866 | 268866 | 2020-06-24 | Morgan | Illinois | 17137 | 123 | 3 |
268954 | 268954 | 2020-06-24 | Morgan | Indiana | 18109 | 317 | 33 |
269274 | 269274 | 2020-06-24 | Morgan | Kentucky | 21175 | 8 | 0 |
269748 | 269748 | 2020-06-24 | Morgan | Missouri | 29141 | 13 | 0 |
270252 | 270252 | 2020-06-24 | Morgan | Ohio | 39115 | 6 | 0 |
270713 | 270713 | 2020-06-24 | Morgan | Tennessee | 47129 | 22 | 1 |
270999 | 270999 | 2020-06-24 | Morgan | Utah | 49029 | 17 | 0 |
271234 | 271234 | 2020-06-24 | Morgan | West Virginia | 54065 | 20 | 0 |
265140 | 265140 | 2020-06-23 | Morgan | Alabama | 1103 | 782 | 2 |
265367 | 265367 | 2020-06-23 | Morgan | Colorado | 8087 | 649 | 46 |
265571 | 265571 | 2020-06-23 | Morgan | Georgia | 13211 | 45 | 0 |
265736 | 265736 | 2020-06-23 | Morgan | Illinois | 17137 | 121 | 3 |
265824 | 265824 | 2020-06-23 | Morgan | Indiana | 18109 | 314 | 32 |
266141 | 266141 | 2020-06-23 | Morgan | Kentucky | 21175 | 7 | 0 |
266615 | 266615 | 2020-06-23 | Morgan | Missouri | 29141 | 11 | 0 |
267118 | 267118 | 2020-06-23 | Morgan | Ohio | 39115 | 6 | 0 |
267579 | 267579 | 2020-06-23 | Morgan | Tennessee | 47129 | 22 | 1 |
267865 | 267865 | 2020-06-23 | Morgan | Utah | 49029 | 17 | 0 |
268100 | 268100 | 2020-06-23 | Morgan | West Virginia | 54065 | 20 | 0 |
262011 | 262011 | 2020-06-22 | Morgan | Alabama | 1103 | 766 | 2 |
262239 | 262239 | 2020-06-22 | Morgan | Colorado | 8087 | 649 | 46 |
262443 | 262443 | 2020-06-22 | Morgan | Georgia | 13211 | 45 | 0 |
262608 | 262608 | 2020-06-22 | Morgan | Illinois | 17137 | 119 | 3 |
262696 | 262696 | 2020-06-22 | Morgan | Indiana | 18109 | 314 | 32 |
263014 | 263014 | 2020-06-22 | Morgan | Kentucky | 21175 | 7 | 0 |
263489 | 263489 | 2020-06-22 | Morgan | Missouri | 29141 | 12 | 0 |
263990 | 263990 | 2020-06-22 | Morgan | Ohio | 39115 | 6 | 0 |
264451 | 264451 | 2020-06-22 | Morgan | Tennessee | 47129 | 22 | 1 |
264736 | 264736 | 2020-06-22 | Morgan | Utah | 49029 | 17 | 0 |
264971 | 264971 | 2020-06-22 | Morgan | West Virginia | 54065 | 20 | 0 |
258884 | 258884 | 2020-06-21 | Morgan | Alabama | 1103 | 754 | 2 |
259112 | 259112 | 2020-06-21 | Morgan | Colorado | 8087 | 649 | 46 |
259316 | 259316 | 2020-06-21 | Morgan | Georgia | 13211 | 45 | 0 |
259481 | 259481 | 2020-06-21 | Morgan | Illinois | 17137 | 119 | 3 |
259569 | 259569 | 2020-06-21 | Morgan | Indiana | 18109 | 315 | 32 |
259885 | 259885 | 2020-06-21 | Morgan | Kentucky | 21175 | 7 | 0 |
260361 | 260361 | 2020-06-21 | Morgan | Missouri | 29141 | 12 | 0 |
260862 | 260862 | 2020-06-21 | Morgan | Ohio | 39115 | 6 | 0 |
261323 | 261323 | 2020-06-21 | Morgan | Tennessee | 47129 | 22 | 1 |
261607 | 261607 | 2020-06-21 | Morgan | Utah | 49029 | 18 | 0 |
261842 | 261842 | 2020-06-21 | Morgan | West Virginia | 54065 | 20 | 0 |
255757 | 255757 | 2020-06-20 | Morgan | Alabama | 1103 | 733 | 2 |
255985 | 255985 | 2020-06-20 | Morgan | Colorado | 8087 | 649 | 46 |
256189 | 256189 | 2020-06-20 | Morgan | Georgia | 13211 | 44 | 0 |
256355 | 256355 | 2020-06-20 | Morgan | Illinois | 17137 | 119 | 3 |
256443 | 256443 | 2020-06-20 | Morgan | Indiana | 18109 | 313 | 32 |
256759 | 256759 | 2020-06-20 | Morgan | Kentucky | 21175 | 7 | 0 |
257235 | 257235 | 2020-06-20 | Morgan | Missouri | 29141 | 12 | 0 |
257735 | 257735 | 2020-06-20 | Morgan | Ohio | 39115 | 6 | 0 |
258196 | 258196 | 2020-06-20 | Morgan | Tennessee | 47129 | 22 | 1 |
258480 | 258480 | 2020-06-20 | Morgan | Utah | 49029 | 17 | 0 |
258715 | 258715 | 2020-06-20 | Morgan | West Virginia | 54065 | 20 | 0 |
252638 | 252638 | 2020-06-19 | Morgan | Alabama | 1103 | 717 | 2 |
252866 | 252866 | 2020-06-19 | Morgan | Colorado | 8087 | 649 | 46 |
253070 | 253070 | 2020-06-19 | Morgan | Georgia | 13211 | 44 | 0 |
253235 | 253235 | 2020-06-19 | Morgan | Illinois | 17137 | 119 | 3 |
253323 | 253323 | 2020-06-19 | Morgan | Indiana | 18109 | 310 | 32 |
253639 | 253639 | 2020-06-19 | Morgan | Kentucky | 21175 | 7 | 0 |
254115 | 254115 | 2020-06-19 | Morgan | Missouri | 29141 | 12 | 0 |
254610 | 254610 | 2020-06-19 | Morgan | Ohio | 39115 | 6 | 0 |
255070 | 255070 | 2020-06-19 | Morgan | Tennessee | 47129 | 22 | 1 |
255353 | 255353 | 2020-06-19 | Morgan | Utah | 49029 | 17 | 0 |
255588 | 255588 | 2020-06-19 | Morgan | West Virginia | 54065 | 20 | 0 |
249523 | 249523 | 2020-06-18 | Morgan | Alabama | 1103 | 708 | 2 |
249751 | 249751 | 2020-06-18 | Morgan | Colorado | 8087 | 647 | 46 |
249955 | 249955 | 2020-06-18 | Morgan | Georgia | 13211 | 42 | 0 |
250120 | 250120 | 2020-06-18 | Morgan | Illinois | 17137 | 118 | 2 |
250208 | 250208 | 2020-06-18 | Morgan | Indiana | 18109 | 310 | 32 |
250524 | 250524 | 2020-06-18 | Morgan | Kentucky | 21175 | 7 | 0 |
251000 | 251000 | 2020-06-18 | Morgan | Missouri | 29141 | 12 | 0 |
251495 | 251495 | 2020-06-18 | Morgan | Ohio | 39115 | 6 | 0 |
251955 | 251955 | 2020-06-18 | Morgan | Tennessee | 47129 | 22 | 1 |
252236 | 252236 | 2020-06-18 | Morgan | Utah | 49029 | 17 | 0 |
252469 | 252469 | 2020-06-18 | Morgan | West Virginia | 54065 | 19 | 0 |
246411 | 246411 | 2020-06-17 | Morgan | Alabama | 1103 | 682 | 2 |
246639 | 246639 | 2020-06-17 | Morgan | Colorado | 8087 | 646 | 45 |
246843 | 246843 | 2020-06-17 | Morgan | Georgia | 13211 | 42 | 0 |
247008 | 247008 | 2020-06-17 | Morgan | Illinois | 17137 | 110 | 2 |
247096 | 247096 | 2020-06-17 | Morgan | Indiana | 18109 | 309 | 32 |
247412 | 247412 | 2020-06-17 | Morgan | Kentucky | 21175 | 7 | 0 |
247887 | 247887 | 2020-06-17 | Morgan | Missouri | 29141 | 11 | 0 |
248380 | 248380 | 2020-06-17 | Morgan | Ohio | 39115 | 6 | 0 |
248840 | 248840 | 2020-06-17 | Morgan | Tennessee | 47129 | 21 | 1 |
249121 | 249121 | 2020-06-17 | Morgan | Utah | 49029 | 16 | 0 |
249354 | 249354 | 2020-06-17 | Morgan | West Virginia | 54065 | 19 | 0 |
243298 | 243298 | 2020-06-16 | Morgan | Alabama | 1103 | 670 | 2 |
243526 | 243526 | 2020-06-16 | Morgan | Colorado | 8087 | 646 | 45 |
243730 | 243730 | 2020-06-16 | Morgan | Georgia | 13211 | 41 | 0 |
243895 | 243895 | 2020-06-16 | Morgan | Illinois | 17137 | 108 | 2 |
243983 | 243983 | 2020-06-16 | Morgan | Indiana | 18109 | 309 | 31 |
244299 | 244299 | 2020-06-16 | Morgan | Kentucky | 21175 | 6 | 0 |
244774 | 244774 | 2020-06-16 | Morgan | Missouri | 29141 | 9 | 0 |
245267 | 245267 | 2020-06-16 | Morgan | Ohio | 39115 | 6 | 0 |
245727 | 245727 | 2020-06-16 | Morgan | Tennessee | 47129 | 21 | 1 |
246008 | 246008 | 2020-06-16 | Morgan | Utah | 49029 | 17 | 0 |
246242 | 246242 | 2020-06-16 | Morgan | West Virginia | 54065 | 19 | 0 |
240187 | 240187 | 2020-06-15 | Morgan | Alabama | 1103 | 644 | 2 |
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);