ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Warren" and fips = 18171 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054294 | 1054294 | 2021-02-22 | Warren | Indiana | 18171 | 747 | 13 |
1051047 | 1051047 | 2021-02-21 | Warren | Indiana | 18171 | 746 | 13 |
1047800 | 1047800 | 2021-02-20 | Warren | Indiana | 18171 | 744 | 13 |
1044555 | 1044555 | 2021-02-19 | Warren | Indiana | 18171 | 743 | 13 |
1041310 | 1041310 | 2021-02-18 | Warren | Indiana | 18171 | 739 | 13 |
1038065 | 1038065 | 2021-02-17 | Warren | Indiana | 18171 | 738 | 13 |
1034820 | 1034820 | 2021-02-16 | Warren | Indiana | 18171 | 736 | 13 |
1031574 | 1031574 | 2021-02-15 | Warren | Indiana | 18171 | 735 | 13 |
1028327 | 1028327 | 2021-02-14 | Warren | Indiana | 18171 | 734 | 13 |
1025082 | 1025082 | 2021-02-13 | Warren | Indiana | 18171 | 733 | 13 |
1021837 | 1021837 | 2021-02-12 | Warren | Indiana | 18171 | 732 | 13 |
1018592 | 1018592 | 2021-02-11 | Warren | Indiana | 18171 | 732 | 13 |
1015347 | 1015347 | 2021-02-10 | Warren | Indiana | 18171 | 730 | 13 |
1012102 | 1012102 | 2021-02-09 | Warren | Indiana | 18171 | 728 | 12 |
1008856 | 1008856 | 2021-02-08 | Warren | Indiana | 18171 | 727 | 12 |
1005610 | 1005610 | 2021-02-07 | Warren | Indiana | 18171 | 725 | 12 |
1002364 | 1002364 | 2021-02-06 | Warren | Indiana | 18171 | 719 | 12 |
999118 | 999118 | 2021-02-05 | Warren | Indiana | 18171 | 716 | 11 |
995872 | 995872 | 2021-02-04 | Warren | Indiana | 18171 | 713 | 11 |
992626 | 992626 | 2021-02-03 | Warren | Indiana | 18171 | 708 | 8 |
989380 | 989380 | 2021-02-02 | Warren | Indiana | 18171 | 707 | 8 |
986133 | 986133 | 2021-02-01 | Warren | Indiana | 18171 | 707 | 8 |
982886 | 982886 | 2021-01-31 | Warren | Indiana | 18171 | 706 | 8 |
979640 | 979640 | 2021-01-30 | Warren | Indiana | 18171 | 705 | 8 |
976394 | 976394 | 2021-01-29 | Warren | Indiana | 18171 | 703 | 8 |
973149 | 973149 | 2021-01-28 | Warren | Indiana | 18171 | 703 | 8 |
969904 | 969904 | 2021-01-27 | Warren | Indiana | 18171 | 696 | 8 |
966660 | 966660 | 2021-01-26 | Warren | Indiana | 18171 | 688 | 8 |
963415 | 963415 | 2021-01-25 | Warren | Indiana | 18171 | 687 | 8 |
960170 | 960170 | 2021-01-24 | Warren | Indiana | 18171 | 687 | 8 |
956924 | 956924 | 2021-01-23 | Warren | Indiana | 18171 | 683 | 8 |
953679 | 953679 | 2021-01-22 | Warren | Indiana | 18171 | 679 | 8 |
950434 | 950434 | 2021-01-21 | Warren | Indiana | 18171 | 677 | 8 |
947188 | 947188 | 2021-01-20 | Warren | Indiana | 18171 | 665 | 8 |
943941 | 943941 | 2021-01-19 | Warren | Indiana | 18171 | 665 | 8 |
940696 | 940696 | 2021-01-18 | Warren | Indiana | 18171 | 662 | 8 |
937451 | 937451 | 2021-01-17 | Warren | Indiana | 18171 | 660 | 8 |
934206 | 934206 | 2021-01-16 | Warren | Indiana | 18171 | 655 | 8 |
930961 | 930961 | 2021-01-15 | Warren | Indiana | 18171 | 651 | 8 |
927716 | 927716 | 2021-01-14 | Warren | Indiana | 18171 | 644 | 8 |
924470 | 924470 | 2021-01-13 | Warren | Indiana | 18171 | 643 | 8 |
921225 | 921225 | 2021-01-12 | Warren | Indiana | 18171 | 636 | 8 |
917980 | 917980 | 2021-01-11 | Warren | Indiana | 18171 | 632 | 8 |
914735 | 914735 | 2021-01-10 | Warren | Indiana | 18171 | 630 | 8 |
911490 | 911490 | 2021-01-09 | Warren | Indiana | 18171 | 624 | 8 |
908245 | 908245 | 2021-01-08 | Warren | Indiana | 18171 | 613 | 8 |
904999 | 904999 | 2021-01-07 | Warren | Indiana | 18171 | 600 | 8 |
901754 | 901754 | 2021-01-06 | Warren | Indiana | 18171 | 593 | 8 |
898509 | 898509 | 2021-01-05 | Warren | Indiana | 18171 | 580 | 8 |
895264 | 895264 | 2021-01-04 | Warren | Indiana | 18171 | 576 | 8 |
892017 | 892017 | 2021-01-03 | Warren | Indiana | 18171 | 565 | 8 |
888771 | 888771 | 2021-01-02 | Warren | Indiana | 18171 | 558 | 8 |
885525 | 885525 | 2021-01-01 | Warren | Indiana | 18171 | 547 | 8 |
882280 | 882280 | 2020-12-31 | Warren | Indiana | 18171 | 537 | 8 |
879035 | 879035 | 2020-12-30 | Warren | Indiana | 18171 | 522 | 8 |
875790 | 875790 | 2020-12-29 | Warren | Indiana | 18171 | 499 | 8 |
872545 | 872545 | 2020-12-28 | Warren | Indiana | 18171 | 497 | 8 |
869300 | 869300 | 2020-12-27 | Warren | Indiana | 18171 | 495 | 8 |
866055 | 866055 | 2020-12-26 | Warren | Indiana | 18171 | 488 | 8 |
862810 | 862810 | 2020-12-25 | Warren | Indiana | 18171 | 484 | 8 |
859565 | 859565 | 2020-12-24 | Warren | Indiana | 18171 | 478 | 8 |
856320 | 856320 | 2020-12-23 | Warren | Indiana | 18171 | 476 | 8 |
853075 | 853075 | 2020-12-22 | Warren | Indiana | 18171 | 469 | 8 |
849830 | 849830 | 2020-12-21 | Warren | Indiana | 18171 | 461 | 8 |
846585 | 846585 | 2020-12-20 | Warren | Indiana | 18171 | 457 | 8 |
843339 | 843339 | 2020-12-19 | Warren | Indiana | 18171 | 444 | 8 |
840094 | 840094 | 2020-12-18 | Warren | Indiana | 18171 | 440 | 8 |
836849 | 836849 | 2020-12-17 | Warren | Indiana | 18171 | 433 | 8 |
833603 | 833603 | 2020-12-16 | Warren | Indiana | 18171 | 403 | 8 |
830356 | 830356 | 2020-12-15 | Warren | Indiana | 18171 | 387 | 7 |
827110 | 827110 | 2020-12-14 | Warren | Indiana | 18171 | 380 | 7 |
823863 | 823863 | 2020-12-13 | Warren | Indiana | 18171 | 379 | 7 |
820617 | 820617 | 2020-12-12 | Warren | Indiana | 18171 | 372 | 7 |
817371 | 817371 | 2020-12-11 | Warren | Indiana | 18171 | 359 | 7 |
814125 | 814125 | 2020-12-10 | Warren | Indiana | 18171 | 352 | 6 |
810880 | 810880 | 2020-12-09 | Warren | Indiana | 18171 | 341 | 4 |
807635 | 807635 | 2020-12-08 | Warren | Indiana | 18171 | 321 | 4 |
804390 | 804390 | 2020-12-07 | Warren | Indiana | 18171 | 319 | 4 |
801145 | 801145 | 2020-12-06 | Warren | Indiana | 18171 | 316 | 4 |
797900 | 797900 | 2020-12-05 | Warren | Indiana | 18171 | 313 | 4 |
794655 | 794655 | 2020-12-04 | Warren | Indiana | 18171 | 303 | 4 |
791410 | 791410 | 2020-12-03 | Warren | Indiana | 18171 | 291 | 4 |
788165 | 788165 | 2020-12-02 | Warren | Indiana | 18171 | 278 | 4 |
784921 | 784921 | 2020-12-01 | Warren | Indiana | 18171 | 270 | 4 |
781676 | 781676 | 2020-11-30 | Warren | Indiana | 18171 | 268 | 4 |
778430 | 778430 | 2020-11-29 | Warren | Indiana | 18171 | 267 | 4 |
775185 | 775185 | 2020-11-28 | Warren | Indiana | 18171 | 260 | 4 |
771940 | 771940 | 2020-11-27 | Warren | Indiana | 18171 | 258 | 3 |
768695 | 768695 | 2020-11-26 | Warren | Indiana | 18171 | 256 | 3 |
765449 | 765449 | 2020-11-25 | Warren | Indiana | 18171 | 240 | 3 |
762204 | 762204 | 2020-11-24 | Warren | Indiana | 18171 | 240 | 3 |
758959 | 758959 | 2020-11-23 | Warren | Indiana | 18171 | 237 | 3 |
755712 | 755712 | 2020-11-22 | Warren | Indiana | 18171 | 229 | 3 |
752466 | 752466 | 2020-11-21 | Warren | Indiana | 18171 | 226 | 3 |
749220 | 749220 | 2020-11-20 | Warren | Indiana | 18171 | 218 | 3 |
745974 | 745974 | 2020-11-19 | Warren | Indiana | 18171 | 203 | 3 |
742727 | 742727 | 2020-11-18 | Warren | Indiana | 18171 | 195 | 3 |
739480 | 739480 | 2020-11-17 | Warren | Indiana | 18171 | 187 | 3 |
736236 | 736236 | 2020-11-16 | Warren | Indiana | 18171 | 180 | 1 |
732990 | 732990 | 2020-11-15 | Warren | Indiana | 18171 | 176 | 1 |
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);