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 |
---|---|---|---|---|---|---|---|
1054210 | 1054210 | 2021-02-22 | Allen | Indiana | 18003 | 35545 | 655 |
1050963 | 1050963 | 2021-02-21 | Allen | Indiana | 18003 | 35490 | 654 |
1047716 | 1047716 | 2021-02-20 | Allen | Indiana | 18003 | 35434 | 655 |
1044471 | 1044471 | 2021-02-19 | Allen | Indiana | 18003 | 35355 | 655 |
1041226 | 1041226 | 2021-02-18 | Allen | Indiana | 18003 | 35298 | 654 |
1037981 | 1037981 | 2021-02-17 | Allen | Indiana | 18003 | 35256 | 651 |
1034736 | 1034736 | 2021-02-16 | Allen | Indiana | 18003 | 35181 | 649 |
1031490 | 1031490 | 2021-02-15 | Allen | Indiana | 18003 | 35106 | 647 |
1028243 | 1028243 | 2021-02-14 | Allen | Indiana | 18003 | 35063 | 647 |
1024998 | 1024998 | 2021-02-13 | Allen | Indiana | 18003 | 34978 | 644 |
1021753 | 1021753 | 2021-02-12 | Allen | Indiana | 18003 | 34906 | 644 |
1018508 | 1018508 | 2021-02-11 | Allen | Indiana | 18003 | 34815 | 643 |
1015263 | 1015263 | 2021-02-10 | Allen | Indiana | 18003 | 34724 | 642 |
1012018 | 1012018 | 2021-02-09 | Allen | Indiana | 18003 | 34622 | 639 |
1008772 | 1008772 | 2021-02-08 | Allen | Indiana | 18003 | 34537 | 636 |
1005526 | 1005526 | 2021-02-07 | Allen | Indiana | 18003 | 34473 | 636 |
1002280 | 1002280 | 2021-02-06 | Allen | Indiana | 18003 | 34365 | 633 |
999034 | 999034 | 2021-02-05 | Allen | Indiana | 18003 | 34199 | 631 |
995788 | 995788 | 2021-02-04 | Allen | Indiana | 18003 | 34130 | 626 |
992542 | 992542 | 2021-02-03 | Allen | Indiana | 18003 | 33995 | 590 |
989296 | 989296 | 2021-02-02 | Allen | Indiana | 18003 | 33917 | 590 |
986049 | 986049 | 2021-02-01 | Allen | Indiana | 18003 | 33824 | 588 |
982802 | 982802 | 2021-01-31 | Allen | Indiana | 18003 | 33740 | 588 |
979556 | 979556 | 2021-01-30 | Allen | Indiana | 18003 | 33664 | 588 |
976310 | 976310 | 2021-01-29 | Allen | Indiana | 18003 | 33530 | 586 |
973065 | 973065 | 2021-01-28 | Allen | Indiana | 18003 | 33417 | 586 |
969820 | 969820 | 2021-01-27 | Allen | Indiana | 18003 | 33286 | 584 |
966576 | 966576 | 2021-01-26 | Allen | Indiana | 18003 | 33151 | 582 |
963331 | 963331 | 2021-01-25 | Allen | Indiana | 18003 | 33029 | 575 |
960086 | 960086 | 2021-01-24 | Allen | Indiana | 18003 | 32940 | 575 |
956840 | 956840 | 2021-01-23 | Allen | Indiana | 18003 | 32852 | 571 |
953595 | 953595 | 2021-01-22 | Allen | Indiana | 18003 | 32695 | 570 |
950350 | 950350 | 2021-01-21 | Allen | Indiana | 18003 | 32547 | 568 |
947104 | 947104 | 2021-01-20 | Allen | Indiana | 18003 | 32380 | 566 |
943857 | 943857 | 2021-01-19 | Allen | Indiana | 18003 | 32214 | 566 |
940612 | 940612 | 2021-01-18 | Allen | Indiana | 18003 | 32084 | 566 |
937367 | 937367 | 2021-01-17 | Allen | Indiana | 18003 | 31968 | 564 |
934122 | 934122 | 2021-01-16 | Allen | Indiana | 18003 | 31846 | 564 |
930877 | 930877 | 2021-01-15 | Allen | Indiana | 18003 | 31657 | 562 |
927632 | 927632 | 2021-01-14 | Allen | Indiana | 18003 | 31429 | 560 |
924386 | 924386 | 2021-01-13 | Allen | Indiana | 18003 | 31234 | 558 |
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 |
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);