ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 1093 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
592775 | 592775 | 2020-10-03 | Marion | Alabama | 1093 | 992 | 29 |
589535 | 589535 | 2020-10-02 | Marion | Alabama | 1093 | 987 | 29 |
586294 | 586294 | 2020-10-01 | Marion | Alabama | 1093 | 981 | 29 |
583054 | 583054 | 2020-09-30 | Marion | Alabama | 1093 | 976 | 29 |
579815 | 579815 | 2020-09-29 | Marion | Alabama | 1093 | 975 | 29 |
576574 | 576574 | 2020-09-28 | Marion | Alabama | 1093 | 971 | 29 |
573330 | 573330 | 2020-09-27 | Marion | Alabama | 1093 | 968 | 29 |
570088 | 570088 | 2020-09-26 | Marion | Alabama | 1093 | 964 | 29 |
566847 | 566847 | 2020-09-25 | Marion | Alabama | 1093 | 957 | 29 |
563606 | 563606 | 2020-09-24 | Marion | Alabama | 1093 | 957 | 29 |
560367 | 560367 | 2020-09-23 | Marion | Alabama | 1093 | 954 | 29 |
557131 | 557131 | 2020-09-22 | Marion | Alabama | 1093 | 952 | 28 |
553894 | 553894 | 2020-09-21 | Marion | Alabama | 1093 | 948 | 28 |
550655 | 550655 | 2020-09-20 | Marion | Alabama | 1093 | 942 | 28 |
547416 | 547416 | 2020-09-19 | Marion | Alabama | 1093 | 937 | 28 |
544179 | 544179 | 2020-09-18 | Marion | Alabama | 1093 | 921 | 28 |
540943 | 540943 | 2020-09-17 | Marion | Alabama | 1093 | 914 | 28 |
537706 | 537706 | 2020-09-16 | Marion | Alabama | 1093 | 903 | 28 |
534470 | 534470 | 2020-09-15 | Marion | Alabama | 1093 | 900 | 28 |
531235 | 531235 | 2020-09-14 | Marion | Alabama | 1093 | 892 | 28 |
527998 | 527998 | 2020-09-13 | Marion | Alabama | 1093 | 891 | 28 |
524762 | 524762 | 2020-09-12 | Marion | Alabama | 1093 | 883 | 28 |
521526 | 521526 | 2020-09-11 | Marion | Alabama | 1093 | 876 | 28 |
518289 | 518289 | 2020-09-10 | Marion | Alabama | 1093 | 868 | 28 |
515054 | 515054 | 2020-09-09 | Marion | Alabama | 1093 | 854 | 28 |
511821 | 511821 | 2020-09-08 | Marion | Alabama | 1093 | 847 | 28 |
508588 | 508588 | 2020-09-07 | Marion | Alabama | 1093 | 842 | 28 |
505356 | 505356 | 2020-09-06 | Marion | Alabama | 1093 | 826 | 28 |
502122 | 502122 | 2020-09-05 | Marion | Alabama | 1093 | 822 | 28 |
498888 | 498888 | 2020-09-04 | Marion | Alabama | 1093 | 807 | 28 |
495655 | 495655 | 2020-09-03 | Marion | Alabama | 1093 | 803 | 28 |
492421 | 492421 | 2020-09-02 | Marion | Alabama | 1093 | 799 | 28 |
489188 | 489188 | 2020-09-01 | Marion | Alabama | 1093 | 794 | 28 |
485955 | 485955 | 2020-08-31 | Marion | Alabama | 1093 | 791 | 28 |
482720 | 482720 | 2020-08-30 | Marion | Alabama | 1093 | 786 | 28 |
479486 | 479486 | 2020-08-29 | Marion | Alabama | 1093 | 781 | 28 |
476253 | 476253 | 2020-08-28 | Marion | Alabama | 1093 | 773 | 28 |
473020 | 473020 | 2020-08-27 | Marion | Alabama | 1093 | 765 | 28 |
469788 | 469788 | 2020-08-26 | Marion | Alabama | 1093 | 752 | 28 |
466559 | 466559 | 2020-08-25 | Marion | Alabama | 1093 | 747 | 28 |
463330 | 463330 | 2020-08-24 | Marion | Alabama | 1093 | 735 | 27 |
460101 | 460101 | 2020-08-23 | Marion | Alabama | 1093 | 715 | 27 |
456874 | 456874 | 2020-08-22 | Marion | Alabama | 1093 | 709 | 27 |
453646 | 453646 | 2020-08-21 | Marion | Alabama | 1093 | 699 | 27 |
450418 | 450418 | 2020-08-20 | Marion | Alabama | 1093 | 688 | 27 |
447190 | 447190 | 2020-08-19 | Marion | Alabama | 1093 | 679 | 27 |
443963 | 443963 | 2020-08-18 | Marion | Alabama | 1093 | 674 | 27 |
440737 | 440737 | 2020-08-17 | Marion | Alabama | 1093 | 659 | 27 |
437511 | 437511 | 2020-08-16 | Marion | Alabama | 1093 | 655 | 26 |
434285 | 434285 | 2020-08-15 | Marion | Alabama | 1093 | 647 | 26 |
431060 | 431060 | 2020-08-14 | Marion | Alabama | 1093 | 638 | 26 |
427832 | 427832 | 2020-08-13 | Marion | Alabama | 1093 | 631 | 26 |
424608 | 424608 | 2020-08-12 | Marion | Alabama | 1093 | 624 | 26 |
421387 | 421387 | 2020-08-11 | Marion | Alabama | 1093 | 619 | 26 |
418166 | 418166 | 2020-08-10 | Marion | Alabama | 1093 | 614 | 26 |
414945 | 414945 | 2020-08-09 | Marion | Alabama | 1093 | 608 | 24 |
411725 | 411725 | 2020-08-08 | Marion | Alabama | 1093 | 604 | 24 |
408506 | 408506 | 2020-08-07 | Marion | Alabama | 1093 | 601 | 24 |
405286 | 405286 | 2020-08-06 | Marion | Alabama | 1093 | 595 | 24 |
402068 | 402068 | 2020-08-05 | Marion | Alabama | 1093 | 580 | 24 |
398852 | 398852 | 2020-08-04 | Marion | Alabama | 1093 | 578 | 24 |
395636 | 395636 | 2020-08-03 | Marion | Alabama | 1093 | 573 | 24 |
392420 | 392420 | 2020-08-02 | Marion | Alabama | 1093 | 567 | 24 |
389203 | 389203 | 2020-08-01 | Marion | Alabama | 1093 | 558 | 24 |
385986 | 385986 | 2020-07-31 | Marion | Alabama | 1093 | 552 | 24 |
382768 | 382768 | 2020-07-30 | Marion | Alabama | 1093 | 537 | 24 |
379551 | 379551 | 2020-07-29 | Marion | Alabama | 1093 | 519 | 24 |
376335 | 376335 | 2020-07-28 | Marion | Alabama | 1093 | 509 | 24 |
373121 | 373121 | 2020-07-27 | Marion | Alabama | 1093 | 504 | 24 |
369909 | 369909 | 2020-07-26 | Marion | Alabama | 1093 | 493 | 24 |
366699 | 366699 | 2020-07-25 | Marion | Alabama | 1093 | 483 | 23 |
363492 | 363492 | 2020-07-24 | Marion | Alabama | 1093 | 478 | 22 |
360286 | 360286 | 2020-07-23 | Marion | Alabama | 1093 | 465 | 21 |
357081 | 357081 | 2020-07-22 | Marion | Alabama | 1093 | 453 | 21 |
353878 | 353878 | 2020-07-21 | Marion | Alabama | 1093 | 447 | 17 |
350676 | 350676 | 2020-07-20 | Marion | Alabama | 1093 | 441 | 16 |
347475 | 347475 | 2020-07-19 | Marion | Alabama | 1093 | 428 | 16 |
344275 | 344275 | 2020-07-18 | Marion | Alabama | 1093 | 416 | 16 |
341076 | 341076 | 2020-07-17 | Marion | Alabama | 1093 | 389 | 14 |
337880 | 337880 | 2020-07-16 | Marion | Alabama | 1093 | 369 | 14 |
334685 | 334685 | 2020-07-15 | Marion | Alabama | 1093 | 359 | 14 |
331492 | 331492 | 2020-07-14 | Marion | Alabama | 1093 | 336 | 14 |
328306 | 328306 | 2020-07-13 | Marion | Alabama | 1093 | 313 | 14 |
325120 | 325120 | 2020-07-12 | Marion | Alabama | 1093 | 294 | 14 |
321939 | 321939 | 2020-07-11 | Marion | Alabama | 1093 | 279 | 14 |
318760 | 318760 | 2020-07-10 | Marion | Alabama | 1093 | 271 | 14 |
315587 | 315587 | 2020-07-09 | Marion | Alabama | 1093 | 249 | 14 |
312412 | 312412 | 2020-07-08 | Marion | Alabama | 1093 | 245 | 14 |
309243 | 309243 | 2020-07-07 | Marion | Alabama | 1093 | 240 | 13 |
306074 | 306074 | 2020-07-06 | Marion | Alabama | 1093 | 237 | 13 |
302910 | 302910 | 2020-07-05 | Marion | Alabama | 1093 | 228 | 13 |
299746 | 299746 | 2020-07-04 | Marion | Alabama | 1093 | 223 | 13 |
296584 | 296584 | 2020-07-03 | Marion | Alabama | 1093 | 218 | 13 |
293429 | 293429 | 2020-07-02 | Marion | Alabama | 1093 | 210 | 13 |
290276 | 290276 | 2020-07-01 | Marion | Alabama | 1093 | 208 | 12 |
287126 | 287126 | 2020-06-30 | Marion | Alabama | 1093 | 205 | 12 |
283980 | 283980 | 2020-06-29 | Marion | Alabama | 1093 | 202 | 12 |
280834 | 280834 | 2020-06-28 | Marion | Alabama | 1093 | 194 | 12 |
277686 | 277686 | 2020-06-27 | Marion | Alabama | 1093 | 193 | 12 |
274538 | 274538 | 2020-06-26 | Marion | Alabama | 1093 | 189 | 12 |
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);