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 |
---|---|---|---|---|---|---|---|
2470544 | 2470544 | 2022-05-04 | Morgan | Colorado | 8087 | 5693 | 138 |
2470749 | 2470749 | 2022-05-04 | Morgan | Georgia | 13211 | 4698 | 69 |
2470925 | 2470925 | 2022-05-04 | Morgan | Illinois | 17137 | 9596 | 144 |
2471014 | 2471014 | 2022-05-04 | Morgan | Indiana | 18109 | 16529 | 287 |
2471346 | 2471346 | 2022-05-04 | Morgan | Kentucky | 21175 | 5247 | 25 |
2471828 | 2471828 | 2022-05-04 | Morgan | Missouri | 29141 | 4025 | 109 |
2472381 | 2472381 | 2022-05-04 | Morgan | Ohio | 39115 | 3271 | 60 |
2472855 | 2472855 | 2022-05-04 | Morgan | Tennessee | 47129 | 6201 | 86 |
2473155 | 2473155 | 2022-05-04 | Morgan | Utah | 49029 | 2898 | 15 |
2473394 | 2473394 | 2022-05-04 | Morgan | West Virginia | 54065 | 4290 | 69 |
2467050 | 2467050 | 2022-05-03 | Morgan | Alabama | 1103 | 36098 | 516 |
2467288 | 2467288 | 2022-05-03 | Morgan | Colorado | 8087 | 5690 | 138 |
2467493 | 2467493 | 2022-05-03 | Morgan | Georgia | 13211 | 4691 | 68 |
2467669 | 2467669 | 2022-05-03 | Morgan | Illinois | 17137 | 9586 | 144 |
2467758 | 2467758 | 2022-05-03 | Morgan | Indiana | 18109 | 16514 | 287 |
2468090 | 2468090 | 2022-05-03 | Morgan | Kentucky | 21175 | 5247 | 25 |
2468572 | 2468572 | 2022-05-03 | Morgan | Missouri | 29141 | 4025 | 109 |
2469125 | 2469125 | 2022-05-03 | Morgan | Ohio | 39115 | 3271 | 60 |
2469599 | 2469599 | 2022-05-03 | Morgan | Tennessee | 47129 | 6197 | 86 |
2469899 | 2469899 | 2022-05-03 | Morgan | Utah | 49029 | 2898 | 15 |
2470137 | 2470137 | 2022-05-03 | Morgan | West Virginia | 54065 | 4289 | 69 |
2463795 | 2463795 | 2022-05-02 | Morgan | Alabama | 1103 | 36091 | 515 |
2464033 | 2464033 | 2022-05-02 | Morgan | Colorado | 8087 | 5689 | 136 |
2464238 | 2464238 | 2022-05-02 | Morgan | Georgia | 13211 | 4691 | 68 |
2464414 | 2464414 | 2022-05-02 | Morgan | Illinois | 17137 | 9580 | 144 |
2464503 | 2464503 | 2022-05-02 | Morgan | Indiana | 18109 | 16514 | 287 |
2464835 | 2464835 | 2022-05-02 | Morgan | Kentucky | 21175 | 5247 | 25 |
2465316 | 2465316 | 2022-05-02 | Morgan | Missouri | 29141 | 4025 | 109 |
2465869 | 2465869 | 2022-05-02 | Morgan | Ohio | 39115 | 3271 | 60 |
2466343 | 2466343 | 2022-05-02 | Morgan | Tennessee | 47129 | 6197 | 86 |
2466643 | 2466643 | 2022-05-02 | Morgan | Utah | 49029 | 2898 | 15 |
2466881 | 2466881 | 2022-05-02 | Morgan | West Virginia | 54065 | 4287 | 69 |
2460539 | 2460539 | 2022-05-01 | Morgan | Alabama | 1103 | 36081 | 515 |
2460777 | 2460777 | 2022-05-01 | Morgan | Colorado | 8087 | 5688 | 136 |
2460982 | 2460982 | 2022-05-01 | Morgan | Georgia | 13211 | 4691 | 68 |
2461158 | 2461158 | 2022-05-01 | Morgan | Illinois | 17137 | 9565 | 144 |
2461247 | 2461247 | 2022-05-01 | Morgan | Indiana | 18109 | 16507 | 287 |
2461579 | 2461579 | 2022-05-01 | Morgan | Kentucky | 21175 | 5211 | 23 |
2462061 | 2462061 | 2022-05-01 | Morgan | Missouri | 29141 | 4025 | 109 |
2462614 | 2462614 | 2022-05-01 | Morgan | Ohio | 39115 | 3271 | 60 |
2463088 | 2463088 | 2022-05-01 | Morgan | Tennessee | 47129 | 6197 | 86 |
2463388 | 2463388 | 2022-05-01 | Morgan | Utah | 49029 | 2897 | 15 |
2463626 | 2463626 | 2022-05-01 | Morgan | West Virginia | 54065 | 4283 | 69 |
2457283 | 2457283 | 2022-04-30 | Morgan | Alabama | 1103 | 36081 | 515 |
2457521 | 2457521 | 2022-04-30 | Morgan | Colorado | 8087 | 5688 | 136 |
2457726 | 2457726 | 2022-04-30 | Morgan | Georgia | 13211 | 4691 | 68 |
2457902 | 2457902 | 2022-04-30 | Morgan | Illinois | 17137 | 9565 | 144 |
2457991 | 2457991 | 2022-04-30 | Morgan | Indiana | 18109 | 16507 | 287 |
2458323 | 2458323 | 2022-04-30 | Morgan | Kentucky | 21175 | 5211 | 23 |
2458805 | 2458805 | 2022-04-30 | Morgan | Missouri | 29141 | 4025 | 109 |
2459358 | 2459358 | 2022-04-30 | Morgan | Ohio | 39115 | 3271 | 60 |
2459832 | 2459832 | 2022-04-30 | Morgan | Tennessee | 47129 | 6197 | 86 |
2460132 | 2460132 | 2022-04-30 | Morgan | Utah | 49029 | 2897 | 15 |
2460370 | 2460370 | 2022-04-30 | Morgan | West Virginia | 54065 | 4283 | 69 |
2454027 | 2454027 | 2022-04-29 | Morgan | Alabama | 1103 | 36081 | 515 |
2454265 | 2454265 | 2022-04-29 | Morgan | Colorado | 8087 | 5688 | 136 |
2454470 | 2454470 | 2022-04-29 | Morgan | Georgia | 13211 | 4691 | 68 |
2454646 | 2454646 | 2022-04-29 | Morgan | Illinois | 17137 | 9565 | 144 |
2454735 | 2454735 | 2022-04-29 | Morgan | Indiana | 18109 | 16507 | 287 |
2455067 | 2455067 | 2022-04-29 | Morgan | Kentucky | 21175 | 5211 | 23 |
2455549 | 2455549 | 2022-04-29 | Morgan | Missouri | 29141 | 4025 | 109 |
2456102 | 2456102 | 2022-04-29 | Morgan | Ohio | 39115 | 3271 | 60 |
2456576 | 2456576 | 2022-04-29 | Morgan | Tennessee | 47129 | 6197 | 86 |
2456876 | 2456876 | 2022-04-29 | Morgan | Utah | 49029 | 2897 | 15 |
2457114 | 2457114 | 2022-04-29 | Morgan | West Virginia | 54065 | 4283 | 69 |
2450771 | 2450771 | 2022-04-28 | Morgan | Alabama | 1103 | 36077 | 515 |
2451009 | 2451009 | 2022-04-28 | Morgan | Colorado | 8087 | 5688 | 136 |
2451214 | 2451214 | 2022-04-28 | Morgan | Georgia | 13211 | 4691 | 68 |
2451390 | 2451390 | 2022-04-28 | Morgan | Illinois | 17137 | 9561 | 144 |
2451479 | 2451479 | 2022-04-28 | Morgan | Indiana | 18109 | 16501 | 286 |
2451811 | 2451811 | 2022-04-28 | Morgan | Kentucky | 21175 | 5211 | 23 |
2452293 | 2452293 | 2022-04-28 | Morgan | Missouri | 29141 | 4025 | 109 |
2452846 | 2452846 | 2022-04-28 | Morgan | Ohio | 39115 | 3271 | 60 |
2453320 | 2453320 | 2022-04-28 | Morgan | Tennessee | 47129 | 6197 | 86 |
2453620 | 2453620 | 2022-04-28 | Morgan | Utah | 49029 | 2897 | 15 |
2453858 | 2453858 | 2022-04-28 | Morgan | West Virginia | 54065 | 4280 | 69 |
2447515 | 2447515 | 2022-04-27 | Morgan | Alabama | 1103 | 36072 | 515 |
2447753 | 2447753 | 2022-04-27 | Morgan | Colorado | 8087 | 5688 | 136 |
2447958 | 2447958 | 2022-04-27 | Morgan | Georgia | 13211 | 4691 | 68 |
2448134 | 2448134 | 2022-04-27 | Morgan | Illinois | 17137 | 9546 | 144 |
2448223 | 2448223 | 2022-04-27 | Morgan | Indiana | 18109 | 16501 | 286 |
2448555 | 2448555 | 2022-04-27 | Morgan | Kentucky | 21175 | 5211 | 23 |
2449037 | 2449037 | 2022-04-27 | Morgan | Missouri | 29141 | 4025 | 109 |
2449590 | 2449590 | 2022-04-27 | Morgan | Ohio | 39115 | 3266 | 60 |
2450064 | 2450064 | 2022-04-27 | Morgan | Tennessee | 47129 | 6197 | 86 |
2450364 | 2450364 | 2022-04-27 | Morgan | Utah | 49029 | 2895 | 15 |
2450602 | 2450602 | 2022-04-27 | Morgan | West Virginia | 54065 | 4276 | 69 |
2444259 | 2444259 | 2022-04-26 | Morgan | Alabama | 1103 | 36065 | 515 |
2444497 | 2444497 | 2022-04-26 | Morgan | Colorado | 8087 | 5688 | 136 |
2444702 | 2444702 | 2022-04-26 | Morgan | Georgia | 13211 | 4666 | 68 |
2444878 | 2444878 | 2022-04-26 | Morgan | Illinois | 17137 | 9532 | 144 |
2444967 | 2444967 | 2022-04-26 | Morgan | Indiana | 18109 | 16486 | 286 |
2445299 | 2445299 | 2022-04-26 | Morgan | Kentucky | 21175 | 5211 | 23 |
2445780 | 2445780 | 2022-04-26 | Morgan | Missouri | 29141 | 4025 | 109 |
2446333 | 2446333 | 2022-04-26 | Morgan | Ohio | 39115 | 3266 | 60 |
2446807 | 2446807 | 2022-04-26 | Morgan | Tennessee | 47129 | 6190 | 86 |
2447107 | 2447107 | 2022-04-26 | Morgan | Utah | 49029 | 2895 | 15 |
2447346 | 2447346 | 2022-04-26 | Morgan | West Virginia | 54065 | 4273 | 69 |
2441003 | 2441003 | 2022-04-25 | Morgan | Alabama | 1103 | 36062 | 515 |
2441241 | 2441241 | 2022-04-25 | Morgan | Colorado | 8087 | 5686 | 136 |
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);