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 |
---|---|---|---|---|---|---|---|
280839 | 280839 | 2020-06-28 | Morgan | Alabama | 1103 | 925 | 3 |
281068 | 281068 | 2020-06-28 | Morgan | Colorado | 8087 | 652 | 46 |
281272 | 281272 | 2020-06-28 | Morgan | Georgia | 13211 | 49 | 0 |
281441 | 281441 | 2020-06-28 | Morgan | Illinois | 17137 | 126 | 3 |
281529 | 281529 | 2020-06-28 | Morgan | Indiana | 18109 | 324 | 34 |
281849 | 281849 | 2020-06-28 | Morgan | Kentucky | 21175 | 8 | 0 |
282326 | 282326 | 2020-06-28 | Morgan | Missouri | 29141 | 13 | 0 |
282832 | 282832 | 2020-06-28 | Morgan | Ohio | 39115 | 7 | 0 |
283293 | 283293 | 2020-06-28 | Morgan | Tennessee | 47129 | 23 | 1 |
283581 | 283581 | 2020-06-28 | Morgan | Utah | 49029 | 18 | 0 |
283816 | 283816 | 2020-06-28 | Morgan | West Virginia | 54065 | 20 | 0 |
277691 | 277691 | 2020-06-27 | Morgan | Alabama | 1103 | 916 | 3 |
277921 | 277921 | 2020-06-27 | Morgan | Colorado | 8087 | 651 | 46 |
278125 | 278125 | 2020-06-27 | Morgan | Georgia | 13211 | 46 | 0 |
278293 | 278293 | 2020-06-27 | Morgan | Illinois | 17137 | 126 | 3 |
278381 | 278381 | 2020-06-27 | Morgan | Indiana | 18109 | 323 | 34 |
278701 | 278701 | 2020-06-27 | Morgan | Kentucky | 21175 | 8 | 0 |
279178 | 279178 | 2020-06-27 | Morgan | Missouri | 29141 | 13 | 0 |
279686 | 279686 | 2020-06-27 | Morgan | Ohio | 39115 | 7 | 0 |
280147 | 280147 | 2020-06-27 | Morgan | Tennessee | 47129 | 23 | 1 |
280435 | 280435 | 2020-06-27 | Morgan | Utah | 49029 | 18 | 0 |
280670 | 280670 | 2020-06-27 | Morgan | West Virginia | 54065 | 20 | 0 |
274543 | 274543 | 2020-06-26 | Morgan | Alabama | 1103 | 895 | 3 |
274773 | 274773 | 2020-06-26 | Morgan | Colorado | 8087 | 650 | 46 |
274977 | 274977 | 2020-06-26 | Morgan | Georgia | 13211 | 46 | 0 |
275145 | 275145 | 2020-06-26 | Morgan | Illinois | 17137 | 124 | 3 |
275233 | 275233 | 2020-06-26 | Morgan | Indiana | 18109 | 319 | 34 |
275553 | 275553 | 2020-06-26 | Morgan | Kentucky | 21175 | 8 | 0 |
276030 | 276030 | 2020-06-26 | Morgan | Missouri | 29141 | 13 | 0 |
276538 | 276538 | 2020-06-26 | Morgan | Ohio | 39115 | 7 | 0 |
276999 | 276999 | 2020-06-26 | Morgan | Tennessee | 47129 | 23 | 1 |
277287 | 277287 | 2020-06-26 | Morgan | Utah | 49029 | 18 | 0 |
277522 | 277522 | 2020-06-26 | Morgan | West Virginia | 54065 | 20 | 0 |
271403 | 271403 | 2020-06-25 | Morgan | Alabama | 1103 | 866 | 2 |
271633 | 271633 | 2020-06-25 | Morgan | Colorado | 8087 | 649 | 46 |
271837 | 271837 | 2020-06-25 | Morgan | Georgia | 13211 | 46 | 0 |
272003 | 272003 | 2020-06-25 | Morgan | Illinois | 17137 | 123 | 3 |
272091 | 272091 | 2020-06-25 | Morgan | Indiana | 18109 | 318 | 33 |
272410 | 272410 | 2020-06-25 | Morgan | Kentucky | 21175 | 8 | 0 |
272887 | 272887 | 2020-06-25 | Morgan | Missouri | 29141 | 13 | 0 |
273391 | 273391 | 2020-06-25 | Morgan | Ohio | 39115 | 6 | 0 |
273852 | 273852 | 2020-06-25 | Morgan | Tennessee | 47129 | 22 | 1 |
274139 | 274139 | 2020-06-25 | Morgan | Utah | 49029 | 17 | 0 |
274374 | 274374 | 2020-06-25 | Morgan | West Virginia | 54065 | 20 | 0 |
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 |
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);