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 |
---|---|---|---|---|---|---|---|
1054297 | 1054297 | 2021-02-22 | Wayne | Indiana | 18177 | 6973 | 191 |
1051050 | 1051050 | 2021-02-21 | Wayne | Indiana | 18177 | 6970 | 191 |
1047803 | 1047803 | 2021-02-20 | Wayne | Indiana | 18177 | 6967 | 190 |
1044558 | 1044558 | 2021-02-19 | Wayne | Indiana | 18177 | 6952 | 190 |
1041313 | 1041313 | 2021-02-18 | Wayne | Indiana | 18177 | 6948 | 189 |
1038068 | 1038068 | 2021-02-17 | Wayne | Indiana | 18177 | 6943 | 189 |
1034823 | 1034823 | 2021-02-16 | Wayne | Indiana | 18177 | 6934 | 188 |
1031577 | 1031577 | 2021-02-15 | Wayne | Indiana | 18177 | 6923 | 187 |
1028330 | 1028330 | 2021-02-14 | Wayne | Indiana | 18177 | 6914 | 187 |
1025085 | 1025085 | 2021-02-13 | Wayne | Indiana | 18177 | 6906 | 187 |
1021840 | 1021840 | 2021-02-12 | Wayne | Indiana | 18177 | 6886 | 187 |
1018595 | 1018595 | 2021-02-11 | Wayne | Indiana | 18177 | 6869 | 185 |
1015350 | 1015350 | 2021-02-10 | Wayne | Indiana | 18177 | 6851 | 184 |
1012105 | 1012105 | 2021-02-09 | Wayne | Indiana | 18177 | 6837 | 183 |
1008859 | 1008859 | 2021-02-08 | Wayne | Indiana | 18177 | 6826 | 183 |
1005613 | 1005613 | 2021-02-07 | Wayne | Indiana | 18177 | 6813 | 183 |
1002367 | 1002367 | 2021-02-06 | Wayne | Indiana | 18177 | 6803 | 183 |
999121 | 999121 | 2021-02-05 | Wayne | Indiana | 18177 | 6793 | 182 |
995875 | 995875 | 2021-02-04 | Wayne | Indiana | 18177 | 6771 | 182 |
992629 | 992629 | 2021-02-03 | Wayne | Indiana | 18177 | 6752 | 173 |
989383 | 989383 | 2021-02-02 | Wayne | Indiana | 18177 | 6734 | 173 |
986136 | 986136 | 2021-02-01 | Wayne | Indiana | 18177 | 6717 | 170 |
982889 | 982889 | 2021-01-31 | Wayne | Indiana | 18177 | 6713 | 170 |
979643 | 979643 | 2021-01-30 | Wayne | Indiana | 18177 | 6692 | 170 |
976397 | 976397 | 2021-01-29 | Wayne | Indiana | 18177 | 6665 | 168 |
973152 | 973152 | 2021-01-28 | Wayne | Indiana | 18177 | 6644 | 167 |
969907 | 969907 | 2021-01-27 | Wayne | Indiana | 18177 | 6606 | 167 |
966663 | 966663 | 2021-01-26 | Wayne | Indiana | 18177 | 6587 | 167 |
963418 | 963418 | 2021-01-25 | Wayne | Indiana | 18177 | 6569 | 165 |
960173 | 960173 | 2021-01-24 | Wayne | Indiana | 18177 | 6549 | 165 |
956927 | 956927 | 2021-01-23 | Wayne | Indiana | 18177 | 6528 | 165 |
953682 | 953682 | 2021-01-22 | Wayne | Indiana | 18177 | 6498 | 164 |
950437 | 950437 | 2021-01-21 | Wayne | Indiana | 18177 | 6468 | 164 |
947191 | 947191 | 2021-01-20 | Wayne | Indiana | 18177 | 6429 | 162 |
943944 | 943944 | 2021-01-19 | Wayne | Indiana | 18177 | 6376 | 162 |
940699 | 940699 | 2021-01-18 | Wayne | Indiana | 18177 | 6347 | 160 |
937454 | 937454 | 2021-01-17 | Wayne | Indiana | 18177 | 6324 | 160 |
934209 | 934209 | 2021-01-16 | Wayne | Indiana | 18177 | 6294 | 159 |
930964 | 930964 | 2021-01-15 | Wayne | Indiana | 18177 | 6263 | 159 |
927719 | 927719 | 2021-01-14 | Wayne | Indiana | 18177 | 6202 | 158 |
924473 | 924473 | 2021-01-13 | Wayne | Indiana | 18177 | 6156 | 157 |
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 |
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);