ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Wayne" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921228 | 921228 | 2021-01-12 | Wayne | Indiana | 18177 | 6122 | 156 |
917983 | 917983 | 2021-01-11 | Wayne | Indiana | 18177 | 6095 | 154 |
914738 | 914738 | 2021-01-10 | Wayne | Indiana | 18177 | 6066 | 154 |
911493 | 911493 | 2021-01-09 | Wayne | Indiana | 18177 | 6033 | 154 |
908248 | 908248 | 2021-01-08 | Wayne | Indiana | 18177 | 5984 | 151 |
905002 | 905002 | 2021-01-07 | Wayne | Indiana | 18177 | 5925 | 151 |
901757 | 901757 | 2021-01-06 | Wayne | Indiana | 18177 | 5835 | 151 |
898512 | 898512 | 2021-01-05 | Wayne | Indiana | 18177 | 5799 | 151 |
895267 | 895267 | 2021-01-04 | Wayne | Indiana | 18177 | 5762 | 149 |
892020 | 892020 | 2021-01-03 | Wayne | Indiana | 18177 | 5734 | 149 |
888774 | 888774 | 2021-01-02 | Wayne | Indiana | 18177 | 5717 | 148 |
885528 | 885528 | 2021-01-01 | Wayne | Indiana | 18177 | 5684 | 148 |
882283 | 882283 | 2020-12-31 | Wayne | Indiana | 18177 | 5615 | 144 |
879038 | 879038 | 2020-12-30 | Wayne | Indiana | 18177 | 5556 | 143 |
875793 | 875793 | 2020-12-29 | Wayne | Indiana | 18177 | 5509 | 140 |
872548 | 872548 | 2020-12-28 | Wayne | Indiana | 18177 | 5464 | 135 |
869303 | 869303 | 2020-12-27 | Wayne | Indiana | 18177 | 5450 | 134 |
866058 | 866058 | 2020-12-26 | Wayne | Indiana | 18177 | 5441 | 133 |
862813 | 862813 | 2020-12-25 | Wayne | Indiana | 18177 | 5403 | 133 |
859568 | 859568 | 2020-12-24 | Wayne | Indiana | 18177 | 5328 | 133 |
856323 | 856323 | 2020-12-23 | Wayne | Indiana | 18177 | 5290 | 133 |
853078 | 853078 | 2020-12-22 | Wayne | Indiana | 18177 | 5247 | 133 |
849833 | 849833 | 2020-12-21 | Wayne | Indiana | 18177 | 5216 | 130 |
846588 | 846588 | 2020-12-20 | Wayne | Indiana | 18177 | 5178 | 130 |
843342 | 843342 | 2020-12-19 | Wayne | Indiana | 18177 | 5108 | 130 |
840097 | 840097 | 2020-12-18 | Wayne | Indiana | 18177 | 5058 | 129 |
836852 | 836852 | 2020-12-17 | Wayne | Indiana | 18177 | 5021 | 127 |
833606 | 833606 | 2020-12-16 | Wayne | Indiana | 18177 | 4928 | 126 |
830359 | 830359 | 2020-12-15 | Wayne | Indiana | 18177 | 4861 | 124 |
827113 | 827113 | 2020-12-14 | Wayne | Indiana | 18177 | 4801 | 120 |
823866 | 823866 | 2020-12-13 | Wayne | Indiana | 18177 | 4754 | 119 |
820620 | 820620 | 2020-12-12 | Wayne | Indiana | 18177 | 4709 | 118 |
817374 | 817374 | 2020-12-11 | Wayne | Indiana | 18177 | 4621 | 117 |
814128 | 814128 | 2020-12-10 | Wayne | Indiana | 18177 | 4543 | 114 |
810883 | 810883 | 2020-12-09 | Wayne | Indiana | 18177 | 4456 | 110 |
807638 | 807638 | 2020-12-08 | Wayne | Indiana | 18177 | 4368 | 107 |
804393 | 804393 | 2020-12-07 | Wayne | Indiana | 18177 | 4286 | 103 |
801148 | 801148 | 2020-12-06 | Wayne | Indiana | 18177 | 4226 | 103 |
797903 | 797903 | 2020-12-05 | Wayne | Indiana | 18177 | 4186 | 101 |
794658 | 794658 | 2020-12-04 | Wayne | Indiana | 18177 | 4097 | 98 |
791413 | 791413 | 2020-12-03 | Wayne | Indiana | 18177 | 4023 | 95 |
788168 | 788168 | 2020-12-02 | Wayne | Indiana | 18177 | 3947 | 94 |
784924 | 784924 | 2020-12-01 | Wayne | Indiana | 18177 | 3907 | 92 |
781679 | 781679 | 2020-11-30 | Wayne | Indiana | 18177 | 3854 | 88 |
778433 | 778433 | 2020-11-29 | Wayne | Indiana | 18177 | 3805 | 87 |
775188 | 775188 | 2020-11-28 | Wayne | Indiana | 18177 | 3720 | 86 |
771943 | 771943 | 2020-11-27 | Wayne | Indiana | 18177 | 3654 | 80 |
768698 | 768698 | 2020-11-26 | Wayne | Indiana | 18177 | 3579 | 76 |
765452 | 765452 | 2020-11-25 | Wayne | Indiana | 18177 | 3473 | 72 |
762207 | 762207 | 2020-11-24 | Wayne | Indiana | 18177 | 3410 | 69 |
758962 | 758962 | 2020-11-23 | Wayne | Indiana | 18177 | 3349 | 63 |
755715 | 755715 | 2020-11-22 | Wayne | Indiana | 18177 | 3319 | 63 |
752469 | 752469 | 2020-11-21 | Wayne | Indiana | 18177 | 3248 | 60 |
749223 | 749223 | 2020-11-20 | Wayne | Indiana | 18177 | 3169 | 58 |
745977 | 745977 | 2020-11-19 | Wayne | Indiana | 18177 | 3072 | 55 |
742730 | 742730 | 2020-11-18 | Wayne | Indiana | 18177 | 2971 | 53 |
739483 | 739483 | 2020-11-17 | Wayne | Indiana | 18177 | 2893 | 52 |
736239 | 736239 | 2020-11-16 | Wayne | Indiana | 18177 | 2851 | 46 |
732993 | 732993 | 2020-11-15 | Wayne | Indiana | 18177 | 2811 | 46 |
729748 | 729748 | 2020-11-14 | Wayne | Indiana | 18177 | 2752 | 45 |
726505 | 726505 | 2020-11-13 | Wayne | Indiana | 18177 | 2682 | 44 |
723262 | 723262 | 2020-11-12 | Wayne | Indiana | 18177 | 2630 | 44 |
720019 | 720019 | 2020-11-11 | Wayne | Indiana | 18177 | 2542 | 43 |
716776 | 716776 | 2020-11-10 | Wayne | Indiana | 18177 | 2495 | 43 |
713532 | 713532 | 2020-11-09 | Wayne | Indiana | 18177 | 2450 | 42 |
710288 | 710288 | 2020-11-08 | Wayne | Indiana | 18177 | 2428 | 42 |
707044 | 707044 | 2020-11-07 | Wayne | Indiana | 18177 | 2367 | 42 |
703801 | 703801 | 2020-11-06 | Wayne | Indiana | 18177 | 2330 | 40 |
700559 | 700559 | 2020-11-05 | Wayne | Indiana | 18177 | 2288 | 40 |
697315 | 697315 | 2020-11-04 | Wayne | Indiana | 18177 | 2213 | 40 |
694073 | 694073 | 2020-11-03 | Wayne | Indiana | 18177 | 2175 | 39 |
690830 | 690830 | 2020-11-02 | Wayne | Indiana | 18177 | 2142 | 37 |
687585 | 687585 | 2020-11-01 | Wayne | Indiana | 18177 | 2118 | 37 |
684341 | 684341 | 2020-10-31 | Wayne | Indiana | 18177 | 2100 | 37 |
681098 | 681098 | 2020-10-30 | Wayne | Indiana | 18177 | 2047 | 35 |
677855 | 677855 | 2020-10-29 | Wayne | Indiana | 18177 | 1960 | 34 |
674612 | 674612 | 2020-10-28 | Wayne | Indiana | 18177 | 1889 | 34 |
671370 | 671370 | 2020-10-27 | Wayne | Indiana | 18177 | 1844 | 34 |
668127 | 668127 | 2020-10-26 | Wayne | Indiana | 18177 | 1809 | 32 |
664883 | 664883 | 2020-10-25 | Wayne | Indiana | 18177 | 1768 | 32 |
661638 | 661638 | 2020-10-24 | Wayne | Indiana | 18177 | 1742 | 32 |
658394 | 658394 | 2020-10-23 | Wayne | Indiana | 18177 | 1710 | 31 |
655149 | 655149 | 2020-10-22 | Wayne | Indiana | 18177 | 1658 | 31 |
651904 | 651904 | 2020-10-21 | Wayne | Indiana | 18177 | 1608 | 28 |
648660 | 648660 | 2020-10-20 | Wayne | Indiana | 18177 | 1580 | 28 |
645415 | 645415 | 2020-10-19 | Wayne | Indiana | 18177 | 1556 | 24 |
642168 | 642168 | 2020-10-18 | Wayne | Indiana | 18177 | 1534 | 24 |
638921 | 638921 | 2020-10-17 | Wayne | Indiana | 18177 | 1512 | 22 |
635675 | 635675 | 2020-10-16 | Wayne | Indiana | 18177 | 1477 | 19 |
632429 | 632429 | 2020-10-15 | Wayne | Indiana | 18177 | 1442 | 18 |
629185 | 629185 | 2020-10-14 | Wayne | Indiana | 18177 | 1400 | 18 |
625942 | 625942 | 2020-10-13 | Wayne | Indiana | 18177 | 1384 | 18 |
622700 | 622700 | 2020-10-12 | Wayne | Indiana | 18177 | 1364 | 17 |
619456 | 619456 | 2020-10-11 | Wayne | Indiana | 18177 | 1335 | 16 |
616214 | 616214 | 2020-10-10 | Wayne | Indiana | 18177 | 1301 | 16 |
612973 | 612973 | 2020-10-09 | Wayne | Indiana | 18177 | 1281 | 16 |
609731 | 609731 | 2020-10-08 | Wayne | Indiana | 18177 | 1257 | 16 |
606488 | 606488 | 2020-10-07 | Wayne | Indiana | 18177 | 1233 | 16 |
603246 | 603246 | 2020-10-06 | Wayne | Indiana | 18177 | 1218 | 16 |
600003 | 600003 | 2020-10-05 | Wayne | Indiana | 18177 | 1211 | 16 |
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);