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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
293434 | 293434 | 2020-07-02 | Morgan | Alabama | 1103 | 1032 | 3 |
296589 | 296589 | 2020-07-03 | Morgan | Alabama | 1103 | 1060 | 5 |
299751 | 299751 | 2020-07-04 | Morgan | Alabama | 1103 | 1084 | 5 |
302915 | 302915 | 2020-07-05 | Morgan | Alabama | 1103 | 1115 | 5 |
306079 | 306079 | 2020-07-06 | Morgan | Alabama | 1103 | 1134 | 5 |
309248 | 309248 | 2020-07-07 | Morgan | Alabama | 1103 | 1142 | 5 |
312417 | 312417 | 2020-07-08 | Morgan | Alabama | 1103 | 1171 | 5 |
315592 | 315592 | 2020-07-09 | Morgan | Alabama | 1103 | 1234 | 5 |
318765 | 318765 | 2020-07-10 | Morgan | Alabama | 1103 | 1255 | 5 |
321944 | 321944 | 2020-07-11 | Morgan | Alabama | 1103 | 1283 | 5 |
325125 | 325125 | 2020-07-12 | Morgan | Alabama | 1103 | 1352 | 5 |
328311 | 328311 | 2020-07-13 | Morgan | Alabama | 1103 | 1413 | 5 |
331497 | 331497 | 2020-07-14 | Morgan | Alabama | 1103 | 1446 | 6 |
334690 | 334690 | 2020-07-15 | Morgan | Alabama | 1103 | 1506 | 7 |
337885 | 337885 | 2020-07-16 | Morgan | Alabama | 1103 | 1534 | 7 |
341081 | 341081 | 2020-07-17 | Morgan | Alabama | 1103 | 1596 | 10 |
344280 | 344280 | 2020-07-18 | Morgan | Alabama | 1103 | 1641 | 10 |
347480 | 347480 | 2020-07-19 | Morgan | Alabama | 1103 | 1685 | 10 |
350681 | 350681 | 2020-07-20 | Morgan | Alabama | 1103 | 1744 | 10 |
353883 | 353883 | 2020-07-21 | Morgan | Alabama | 1103 | 1767 | 10 |
357086 | 357086 | 2020-07-22 | Morgan | Alabama | 1103 | 1808 | 11 |
360291 | 360291 | 2020-07-23 | Morgan | Alabama | 1103 | 1853 | 11 |
363497 | 363497 | 2020-07-24 | Morgan | Alabama | 1103 | 1885 | 12 |
366704 | 366704 | 2020-07-25 | Morgan | Alabama | 1103 | 1936 | 12 |
369914 | 369914 | 2020-07-26 | Morgan | Alabama | 1103 | 1957 | 13 |
373126 | 373126 | 2020-07-27 | Morgan | Alabama | 1103 | 1997 | 14 |
376340 | 376340 | 2020-07-28 | Morgan | Alabama | 1103 | 2023 | 14 |
379556 | 379556 | 2020-07-29 | Morgan | Alabama | 1103 | 2057 | 15 |
382773 | 382773 | 2020-07-30 | Morgan | Alabama | 1103 | 2125 | 15 |
385991 | 385991 | 2020-07-31 | Morgan | Alabama | 1103 | 2160 | 15 |
389208 | 389208 | 2020-08-01 | Morgan | Alabama | 1103 | 2189 | 15 |
392425 | 392425 | 2020-08-02 | Morgan | Alabama | 1103 | 2239 | 16 |
395641 | 395641 | 2020-08-03 | Morgan | Alabama | 1103 | 2257 | 17 |
398857 | 398857 | 2020-08-04 | Morgan | Alabama | 1103 | 2277 | 17 |
402073 | 402073 | 2020-08-05 | Morgan | Alabama | 1103 | 2307 | 17 |
405291 | 405291 | 2020-08-06 | Morgan | Alabama | 1103 | 2336 | 19 |
408511 | 408511 | 2020-08-07 | Morgan | Alabama | 1103 | 2371 | 19 |
411730 | 411730 | 2020-08-08 | Morgan | Alabama | 1103 | 2410 | 20 |
414950 | 414950 | 2020-08-09 | Morgan | Alabama | 1103 | 2434 | 20 |
418171 | 418171 | 2020-08-10 | Morgan | Alabama | 1103 | 2452 | 20 |
421392 | 421392 | 2020-08-11 | Morgan | Alabama | 1103 | 2460 | 21 |
424613 | 424613 | 2020-08-12 | Morgan | Alabama | 1103 | 2467 | 22 |
427837 | 427837 | 2020-08-13 | Morgan | Alabama | 1103 | 2486 | 22 |
431065 | 431065 | 2020-08-14 | Morgan | Alabama | 1103 | 2503 | 22 |
434290 | 434290 | 2020-08-15 | Morgan | Alabama | 1103 | 2536 | 22 |
437516 | 437516 | 2020-08-16 | Morgan | Alabama | 1103 | 2550 | 22 |
440742 | 440742 | 2020-08-17 | Morgan | Alabama | 1103 | 2563 | 23 |
443968 | 443968 | 2020-08-18 | Morgan | Alabama | 1103 | 2606 | 24 |
447195 | 447195 | 2020-08-19 | Morgan | Alabama | 1103 | 2633 | 24 |
450423 | 450423 | 2020-08-20 | Morgan | Alabama | 1103 | 2636 | 24 |
453651 | 453651 | 2020-08-21 | Morgan | Alabama | 1103 | 2663 | 24 |
456879 | 456879 | 2020-08-22 | Morgan | Alabama | 1103 | 2671 | 24 |
460106 | 460106 | 2020-08-23 | Morgan | Alabama | 1103 | 2679 | 24 |
463335 | 463335 | 2020-08-24 | Morgan | Alabama | 1103 | 2705 | 24 |
466564 | 466564 | 2020-08-25 | Morgan | Alabama | 1103 | 2719 | 24 |
469793 | 469793 | 2020-08-26 | Morgan | Alabama | 1103 | 2788 | 24 |
473025 | 473025 | 2020-08-27 | Morgan | Alabama | 1103 | 2816 | 24 |
476258 | 476258 | 2020-08-28 | Morgan | Alabama | 1103 | 2836 | 24 |
479491 | 479491 | 2020-08-29 | Morgan | Alabama | 1103 | 2874 | 24 |
482725 | 482725 | 2020-08-30 | Morgan | Alabama | 1103 | 2902 | 24 |
485960 | 485960 | 2020-08-31 | Morgan | Alabama | 1103 | 2910 | 24 |
489193 | 489193 | 2020-09-01 | Morgan | Alabama | 1103 | 2934 | 24 |
492426 | 492426 | 2020-09-02 | Morgan | Alabama | 1103 | 2935 | 24 |
495660 | 495660 | 2020-09-03 | Morgan | Alabama | 1103 | 2950 | 24 |
498893 | 498893 | 2020-09-04 | Morgan | Alabama | 1103 | 2962 | 24 |
502127 | 502127 | 2020-09-05 | Morgan | Alabama | 1103 | 2982 | 24 |
505361 | 505361 | 2020-09-06 | Morgan | Alabama | 1103 | 2995 | 24 |
508593 | 508593 | 2020-09-07 | Morgan | Alabama | 1103 | 3002 | 24 |
511826 | 511826 | 2020-09-08 | Morgan | Alabama | 1103 | 3010 | 24 |
515059 | 515059 | 2020-09-09 | Morgan | Alabama | 1103 | 3027 | 24 |
518294 | 518294 | 2020-09-10 | Morgan | Alabama | 1103 | 3034 | 24 |
521531 | 521531 | 2020-09-11 | Morgan | Alabama | 1103 | 3053 | 25 |
524767 | 524767 | 2020-09-12 | Morgan | Alabama | 1103 | 3062 | 25 |
528003 | 528003 | 2020-09-13 | Morgan | Alabama | 1103 | 3080 | 25 |
531240 | 531240 | 2020-09-14 | Morgan | Alabama | 1103 | 3094 | 25 |
534475 | 534475 | 2020-09-15 | Morgan | Alabama | 1103 | 3106 | 25 |
537711 | 537711 | 2020-09-16 | Morgan | Alabama | 1103 | 3118 | 25 |
540948 | 540948 | 2020-09-17 | Morgan | Alabama | 1103 | 3129 | 25 |
544184 | 544184 | 2020-09-18 | Morgan | Alabama | 1103 | 3142 | 26 |
547421 | 547421 | 2020-09-19 | Morgan | Alabama | 1103 | 3181 | 26 |
550660 | 550660 | 2020-09-20 | Morgan | Alabama | 1103 | 3197 | 26 |
553899 | 553899 | 2020-09-21 | Morgan | Alabama | 1103 | 3214 | 26 |
557136 | 557136 | 2020-09-22 | Morgan | Alabama | 1103 | 3226 | 26 |
560372 | 560372 | 2020-09-23 | Morgan | Alabama | 1103 | 3239 | 26 |
563611 | 563611 | 2020-09-24 | Morgan | Alabama | 1103 | 3254 | 28 |
566852 | 566852 | 2020-09-25 | Morgan | Alabama | 1103 | 3273 | 28 |
570093 | 570093 | 2020-09-26 | Morgan | Alabama | 1103 | 3292 | 28 |
573335 | 573335 | 2020-09-27 | Morgan | Alabama | 1103 | 3314 | 28 |
576579 | 576579 | 2020-09-28 | Morgan | Alabama | 1103 | 3327 | 28 |
579820 | 579820 | 2020-09-29 | Morgan | Alabama | 1103 | 3334 | 28 |
583059 | 583059 | 2020-09-30 | Morgan | Alabama | 1103 | 3349 | 29 |
586299 | 586299 | 2020-10-01 | Morgan | Alabama | 1103 | 3362 | 29 |
589540 | 589540 | 2020-10-02 | Morgan | Alabama | 1103 | 3389 | 30 |
592780 | 592780 | 2020-10-03 | Morgan | Alabama | 1103 | 3420 | 31 |
596022 | 596022 | 2020-10-04 | Morgan | Alabama | 1103 | 3461 | 31 |
599265 | 599265 | 2020-10-05 | Morgan | Alabama | 1103 | 3481 | 31 |
602508 | 602508 | 2020-10-06 | Morgan | Alabama | 1103 | 3503 | 31 |
605750 | 605750 | 2020-10-07 | Morgan | Alabama | 1103 | 3536 | 31 |
608993 | 608993 | 2020-10-08 | Morgan | Alabama | 1103 | 3551 | 33 |
612235 | 612235 | 2020-10-09 | Morgan | Alabama | 1103 | 3600 | 32 |
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);