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 |
---|---|---|---|---|---|---|---|
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 |
729745 | 729745 | 2020-11-14 | Warren | Indiana | 18171 | 175 | 1 |
726502 | 726502 | 2020-11-13 | Warren | Indiana | 18171 | 167 | 1 |
723259 | 723259 | 2020-11-12 | Warren | Indiana | 18171 | 162 | 1 |
720016 | 720016 | 2020-11-11 | Warren | Indiana | 18171 | 153 | 1 |
716773 | 716773 | 2020-11-10 | Warren | Indiana | 18171 | 150 | 1 |
713529 | 713529 | 2020-11-09 | Warren | Indiana | 18171 | 149 | 1 |
710285 | 710285 | 2020-11-08 | Warren | Indiana | 18171 | 147 | 1 |
707041 | 707041 | 2020-11-07 | Warren | Indiana | 18171 | 144 | 1 |
703798 | 703798 | 2020-11-06 | Warren | Indiana | 18171 | 139 | 1 |
700556 | 700556 | 2020-11-05 | Warren | Indiana | 18171 | 133 | 1 |
697312 | 697312 | 2020-11-04 | Warren | Indiana | 18171 | 127 | 1 |
694070 | 694070 | 2020-11-03 | Warren | Indiana | 18171 | 124 | 1 |
690827 | 690827 | 2020-11-02 | Warren | Indiana | 18171 | 117 | 1 |
687582 | 687582 | 2020-11-01 | Warren | Indiana | 18171 | 116 | 1 |
684338 | 684338 | 2020-10-31 | Warren | Indiana | 18171 | 116 | 1 |
681095 | 681095 | 2020-10-30 | Warren | Indiana | 18171 | 109 | 1 |
677852 | 677852 | 2020-10-29 | Warren | Indiana | 18171 | 103 | 1 |
674609 | 674609 | 2020-10-28 | Warren | Indiana | 18171 | 103 | 1 |
671367 | 671367 | 2020-10-27 | Warren | Indiana | 18171 | 93 | 1 |
668124 | 668124 | 2020-10-26 | Warren | Indiana | 18171 | 92 | 1 |
664880 | 664880 | 2020-10-25 | Warren | Indiana | 18171 | 90 | 1 |
661635 | 661635 | 2020-10-24 | Warren | Indiana | 18171 | 90 | 1 |
658391 | 658391 | 2020-10-23 | Warren | Indiana | 18171 | 85 | 1 |
655146 | 655146 | 2020-10-22 | Warren | Indiana | 18171 | 79 | 1 |
651901 | 651901 | 2020-10-21 | Warren | Indiana | 18171 | 77 | 1 |
648657 | 648657 | 2020-10-20 | Warren | Indiana | 18171 | 76 | 1 |
645412 | 645412 | 2020-10-19 | Warren | Indiana | 18171 | 74 | 1 |
642165 | 642165 | 2020-10-18 | Warren | Indiana | 18171 | 73 | 1 |
638918 | 638918 | 2020-10-17 | Warren | Indiana | 18171 | 73 | 1 |
635672 | 635672 | 2020-10-16 | Warren | Indiana | 18171 | 66 | 1 |
632426 | 632426 | 2020-10-15 | Warren | Indiana | 18171 | 61 | 1 |
629182 | 629182 | 2020-10-14 | Warren | Indiana | 18171 | 61 | 1 |
625939 | 625939 | 2020-10-13 | Warren | Indiana | 18171 | 60 | 1 |
622697 | 622697 | 2020-10-12 | Warren | Indiana | 18171 | 60 | 1 |
619453 | 619453 | 2020-10-11 | Warren | Indiana | 18171 | 56 | 1 |
616211 | 616211 | 2020-10-10 | Warren | Indiana | 18171 | 56 | 1 |
612970 | 612970 | 2020-10-09 | Warren | Indiana | 18171 | 51 | 1 |
609728 | 609728 | 2020-10-08 | Warren | Indiana | 18171 | 49 | 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);