ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18003 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921141 | 921141 | 2021-01-12 | Allen | Indiana | 18003 | 31055 | 552 |
917896 | 917896 | 2021-01-11 | Allen | Indiana | 18003 | 30851 | 549 |
914651 | 914651 | 2021-01-10 | Allen | Indiana | 18003 | 30714 | 547 |
911406 | 911406 | 2021-01-09 | Allen | Indiana | 18003 | 30236 | 544 |
908161 | 908161 | 2021-01-08 | Allen | Indiana | 18003 | 29978 | 541 |
904915 | 904915 | 2021-01-07 | Allen | Indiana | 18003 | 29712 | 536 |
901670 | 901670 | 2021-01-06 | Allen | Indiana | 18003 | 29418 | 534 |
898425 | 898425 | 2021-01-05 | Allen | Indiana | 18003 | 29143 | 532 |
895180 | 895180 | 2021-01-04 | Allen | Indiana | 18003 | 28954 | 517 |
891933 | 891933 | 2021-01-03 | Allen | Indiana | 18003 | 28711 | 516 |
888687 | 888687 | 2021-01-02 | Allen | Indiana | 18003 | 28579 | 513 |
885441 | 885441 | 2021-01-01 | Allen | Indiana | 18003 | 28321 | 509 |
882196 | 882196 | 2020-12-31 | Allen | Indiana | 18003 | 28059 | 508 |
878951 | 878951 | 2020-12-30 | Allen | Indiana | 18003 | 27822 | 503 |
875706 | 875706 | 2020-12-29 | Allen | Indiana | 18003 | 27556 | 501 |
872461 | 872461 | 2020-12-28 | Allen | Indiana | 18003 | 27278 | 492 |
869216 | 869216 | 2020-12-27 | Allen | Indiana | 18003 | 27150 | 488 |
865971 | 865971 | 2020-12-26 | Allen | Indiana | 18003 | 27088 | 484 |
862726 | 862726 | 2020-12-25 | Allen | Indiana | 18003 | 26916 | 482 |
859481 | 859481 | 2020-12-24 | Allen | Indiana | 18003 | 26698 | 479 |
856236 | 856236 | 2020-12-23 | Allen | Indiana | 18003 | 26399 | 477 |
852991 | 852991 | 2020-12-22 | Allen | Indiana | 18003 | 26162 | 473 |
849746 | 849746 | 2020-12-21 | Allen | Indiana | 18003 | 25980 | 449 |
846501 | 846501 | 2020-12-20 | Allen | Indiana | 18003 | 25827 | 446 |
843255 | 843255 | 2020-12-19 | Allen | Indiana | 18003 | 25568 | 443 |
840010 | 840010 | 2020-12-18 | Allen | Indiana | 18003 | 25284 | 440 |
836765 | 836765 | 2020-12-17 | Allen | Indiana | 18003 | 25102 | 440 |
833519 | 833519 | 2020-12-16 | Allen | Indiana | 18003 | 24813 | 432 |
830272 | 830272 | 2020-12-15 | Allen | Indiana | 18003 | 24463 | 419 |
827026 | 827026 | 2020-12-14 | Allen | Indiana | 18003 | 24288 | 412 |
823779 | 823779 | 2020-12-13 | Allen | Indiana | 18003 | 24059 | 410 |
820533 | 820533 | 2020-12-12 | Allen | Indiana | 18003 | 23815 | 404 |
817287 | 817287 | 2020-12-11 | Allen | Indiana | 18003 | 23459 | 398 |
814041 | 814041 | 2020-12-10 | Allen | Indiana | 18003 | 22997 | 397 |
810796 | 810796 | 2020-12-09 | Allen | Indiana | 18003 | 22780 | 395 |
807551 | 807551 | 2020-12-08 | Allen | Indiana | 18003 | 22458 | 379 |
804306 | 804306 | 2020-12-07 | Allen | Indiana | 18003 | 22179 | 372 |
801061 | 801061 | 2020-12-06 | Allen | Indiana | 18003 | 21855 | 368 |
797816 | 797816 | 2020-12-05 | Allen | Indiana | 18003 | 21567 | 366 |
794571 | 794571 | 2020-12-04 | Allen | Indiana | 18003 | 21092 | 357 |
791326 | 791326 | 2020-12-03 | Allen | Indiana | 18003 | 20706 | 353 |
788081 | 788081 | 2020-12-02 | Allen | Indiana | 18003 | 20294 | 348 |
784837 | 784837 | 2020-12-01 | Allen | Indiana | 18003 | 19871 | 344 |
781592 | 781592 | 2020-11-30 | Allen | Indiana | 18003 | 19608 | 320 |
778346 | 778346 | 2020-11-29 | Allen | Indiana | 18003 | 19361 | 317 |
775101 | 775101 | 2020-11-28 | Allen | Indiana | 18003 | 19041 | 316 |
771856 | 771856 | 2020-11-27 | Allen | Indiana | 18003 | 18695 | 313 |
768611 | 768611 | 2020-11-26 | Allen | Indiana | 18003 | 18398 | 311 |
765365 | 765365 | 2020-11-25 | Allen | Indiana | 18003 | 18045 | 310 |
762120 | 762120 | 2020-11-24 | Allen | Indiana | 18003 | 17656 | 307 |
758875 | 758875 | 2020-11-23 | Allen | Indiana | 18003 | 17334 | 302 |
755628 | 755628 | 2020-11-22 | Allen | Indiana | 18003 | 17060 | 301 |
752382 | 752382 | 2020-11-21 | Allen | Indiana | 18003 | 16684 | 299 |
749136 | 749136 | 2020-11-20 | Allen | Indiana | 18003 | 16252 | 297 |
745890 | 745890 | 2020-11-19 | Allen | Indiana | 18003 | 15849 | 293 |
742643 | 742643 | 2020-11-18 | Allen | Indiana | 18003 | 15377 | 290 |
739396 | 739396 | 2020-11-17 | Allen | Indiana | 18003 | 14889 | 282 |
736152 | 736152 | 2020-11-16 | Allen | Indiana | 18003 | 14579 | 279 |
732906 | 732906 | 2020-11-15 | Allen | Indiana | 18003 | 14265 | 277 |
729661 | 729661 | 2020-11-14 | Allen | Indiana | 18003 | 13812 | 276 |
726418 | 726418 | 2020-11-13 | Allen | Indiana | 18003 | 13191 | 274 |
723175 | 723175 | 2020-11-12 | Allen | Indiana | 18003 | 12810 | 270 |
719932 | 719932 | 2020-11-11 | Allen | Indiana | 18003 | 12414 | 266 |
716689 | 716689 | 2020-11-10 | Allen | Indiana | 18003 | 12006 | 266 |
713445 | 713445 | 2020-11-09 | Allen | Indiana | 18003 | 11681 | 263 |
710201 | 710201 | 2020-11-08 | Allen | Indiana | 18003 | 11475 | 261 |
706957 | 706957 | 2020-11-07 | Allen | Indiana | 18003 | 11140 | 255 |
703714 | 703714 | 2020-11-06 | Allen | Indiana | 18003 | 10823 | 255 |
700472 | 700472 | 2020-11-05 | Allen | Indiana | 18003 | 10477 | 254 |
697228 | 697228 | 2020-11-04 | Allen | Indiana | 18003 | 10226 | 252 |
693986 | 693986 | 2020-11-03 | Allen | Indiana | 18003 | 9954 | 251 |
690743 | 690743 | 2020-11-02 | Allen | Indiana | 18003 | 9800 | 250 |
687498 | 687498 | 2020-11-01 | Allen | Indiana | 18003 | 9673 | 248 |
684254 | 684254 | 2020-10-31 | Allen | Indiana | 18003 | 9523 | 248 |
681011 | 681011 | 2020-10-30 | Allen | Indiana | 18003 | 9310 | 246 |
677768 | 677768 | 2020-10-29 | Allen | Indiana | 18003 | 9158 | 246 |
674525 | 674525 | 2020-10-28 | Allen | Indiana | 18003 | 8921 | 246 |
671283 | 671283 | 2020-10-27 | Allen | Indiana | 18003 | 8776 | 243 |
668040 | 668040 | 2020-10-26 | Allen | Indiana | 18003 | 8682 | 242 |
664796 | 664796 | 2020-10-25 | Allen | Indiana | 18003 | 8587 | 241 |
661551 | 661551 | 2020-10-24 | Allen | Indiana | 18003 | 8459 | 241 |
658307 | 658307 | 2020-10-23 | Allen | Indiana | 18003 | 8313 | 241 |
655062 | 655062 | 2020-10-22 | Allen | Indiana | 18003 | 8164 | 239 |
651817 | 651817 | 2020-10-21 | Allen | Indiana | 18003 | 8013 | 233 |
648573 | 648573 | 2020-10-20 | Allen | Indiana | 18003 | 7915 | 233 |
645328 | 645328 | 2020-10-19 | Allen | Indiana | 18003 | 7850 | 232 |
642081 | 642081 | 2020-10-18 | Allen | Indiana | 18003 | 7791 | 232 |
638834 | 638834 | 2020-10-17 | Allen | Indiana | 18003 | 7702 | 231 |
635588 | 635588 | 2020-10-16 | Allen | Indiana | 18003 | 7577 | 230 |
632342 | 632342 | 2020-10-15 | Allen | Indiana | 18003 | 7441 | 227 |
629098 | 629098 | 2020-10-14 | Allen | Indiana | 18003 | 7354 | 223 |
625855 | 625855 | 2020-10-13 | Allen | Indiana | 18003 | 7274 | 223 |
622613 | 622613 | 2020-10-12 | Allen | Indiana | 18003 | 7192 | 222 |
619369 | 619369 | 2020-10-11 | Allen | Indiana | 18003 | 7145 | 221 |
616127 | 616127 | 2020-10-10 | Allen | Indiana | 18003 | 7059 | 221 |
612886 | 612886 | 2020-10-09 | Allen | Indiana | 18003 | 6971 | 221 |
609644 | 609644 | 2020-10-08 | Allen | Indiana | 18003 | 6882 | 219 |
606401 | 606401 | 2020-10-07 | Allen | Indiana | 18003 | 6808 | 219 |
603159 | 603159 | 2020-10-06 | Allen | Indiana | 18003 | 6734 | 219 |
599916 | 599916 | 2020-10-05 | Allen | Indiana | 18003 | 6692 | 219 |
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);