ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Madison" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921187 | 921187 | 2021-01-12 | Madison | Indiana | 18095 | 10196 | 223 |
917942 | 917942 | 2021-01-11 | Madison | Indiana | 18095 | 10113 | 221 |
914697 | 914697 | 2021-01-10 | Madison | Indiana | 18095 | 10043 | 217 |
911452 | 911452 | 2021-01-09 | Madison | Indiana | 18095 | 9958 | 217 |
908207 | 908207 | 2021-01-08 | Madison | Indiana | 18095 | 9817 | 213 |
904961 | 904961 | 2021-01-07 | Madison | Indiana | 18095 | 9698 | 213 |
901716 | 901716 | 2021-01-06 | Madison | Indiana | 18095 | 9593 | 212 |
898471 | 898471 | 2021-01-05 | Madison | Indiana | 18095 | 9408 | 207 |
895226 | 895226 | 2021-01-04 | Madison | Indiana | 18095 | 9333 | 201 |
891979 | 891979 | 2021-01-03 | Madison | Indiana | 18095 | 9264 | 199 |
888733 | 888733 | 2021-01-02 | Madison | Indiana | 18095 | 9184 | 196 |
885487 | 885487 | 2021-01-01 | Madison | Indiana | 18095 | 9097 | 195 |
882242 | 882242 | 2020-12-31 | Madison | Indiana | 18095 | 8994 | 189 |
878997 | 878997 | 2020-12-30 | Madison | Indiana | 18095 | 8872 | 186 |
875752 | 875752 | 2020-12-29 | Madison | Indiana | 18095 | 8772 | 181 |
872507 | 872507 | 2020-12-28 | Madison | Indiana | 18095 | 8677 | 178 |
869262 | 869262 | 2020-12-27 | Madison | Indiana | 18095 | 8611 | 178 |
866017 | 866017 | 2020-12-26 | Madison | Indiana | 18095 | 8595 | 177 |
862772 | 862772 | 2020-12-25 | Madison | Indiana | 18095 | 8544 | 176 |
859527 | 859527 | 2020-12-24 | Madison | Indiana | 18095 | 8415 | 176 |
856282 | 856282 | 2020-12-23 | Madison | Indiana | 18095 | 8262 | 175 |
853037 | 853037 | 2020-12-22 | Madison | Indiana | 18095 | 8165 | 175 |
849792 | 849792 | 2020-12-21 | Madison | Indiana | 18095 | 8079 | 171 |
846547 | 846547 | 2020-12-20 | Madison | Indiana | 18095 | 8006 | 171 |
843301 | 843301 | 2020-12-19 | Madison | Indiana | 18095 | 7861 | 168 |
840056 | 840056 | 2020-12-18 | Madison | Indiana | 18095 | 7755 | 168 |
836811 | 836811 | 2020-12-17 | Madison | Indiana | 18095 | 7646 | 165 |
833565 | 833565 | 2020-12-16 | Madison | Indiana | 18095 | 7496 | 164 |
830318 | 830318 | 2020-12-15 | Madison | Indiana | 18095 | 7360 | 157 |
827072 | 827072 | 2020-12-14 | Madison | Indiana | 18095 | 7267 | 153 |
823825 | 823825 | 2020-12-13 | Madison | Indiana | 18095 | 7188 | 153 |
820579 | 820579 | 2020-12-12 | Madison | Indiana | 18095 | 7060 | 153 |
817333 | 817333 | 2020-12-11 | Madison | Indiana | 18095 | 6911 | 150 |
814087 | 814087 | 2020-12-10 | Madison | Indiana | 18095 | 6781 | 149 |
810842 | 810842 | 2020-12-09 | Madison | Indiana | 18095 | 6642 | 144 |
807597 | 807597 | 2020-12-08 | Madison | Indiana | 18095 | 6442 | 145 |
804352 | 804352 | 2020-12-07 | Madison | Indiana | 18095 | 6337 | 142 |
801107 | 801107 | 2020-12-06 | Madison | Indiana | 18095 | 6244 | 142 |
797862 | 797862 | 2020-12-05 | Madison | Indiana | 18095 | 6113 | 141 |
794617 | 794617 | 2020-12-04 | Madison | Indiana | 18095 | 5984 | 139 |
791372 | 791372 | 2020-12-03 | Madison | Indiana | 18095 | 5882 | 138 |
788127 | 788127 | 2020-12-02 | Madison | Indiana | 18095 | 5756 | 138 |
784883 | 784883 | 2020-12-01 | Madison | Indiana | 18095 | 5604 | 137 |
781638 | 781638 | 2020-11-30 | Madison | Indiana | 18095 | 5530 | 137 |
778392 | 778392 | 2020-11-29 | Madison | Indiana | 18095 | 5434 | 135 |
775147 | 775147 | 2020-11-28 | Madison | Indiana | 18095 | 5359 | 135 |
771902 | 771902 | 2020-11-27 | Madison | Indiana | 18095 | 5263 | 135 |
768657 | 768657 | 2020-11-26 | Madison | Indiana | 18095 | 5177 | 135 |
765411 | 765411 | 2020-11-25 | Madison | Indiana | 18095 | 5084 | 135 |
762166 | 762166 | 2020-11-24 | Madison | Indiana | 18095 | 4882 | 134 |
758921 | 758921 | 2020-11-23 | Madison | Indiana | 18095 | 4783 | 131 |
755674 | 755674 | 2020-11-22 | Madison | Indiana | 18095 | 4674 | 131 |
752428 | 752428 | 2020-11-21 | Madison | Indiana | 18095 | 4510 | 130 |
749182 | 749182 | 2020-11-20 | Madison | Indiana | 18095 | 4428 | 130 |
745936 | 745936 | 2020-11-19 | Madison | Indiana | 18095 | 4313 | 130 |
742689 | 742689 | 2020-11-18 | Madison | Indiana | 18095 | 4206 | 130 |
739442 | 739442 | 2020-11-17 | Madison | Indiana | 18095 | 4092 | 125 |
736198 | 736198 | 2020-11-16 | Madison | Indiana | 18095 | 4001 | 125 |
732952 | 732952 | 2020-11-15 | Madison | Indiana | 18095 | 3931 | 125 |
729707 | 729707 | 2020-11-14 | Madison | Indiana | 18095 | 3804 | 125 |
726464 | 726464 | 2020-11-13 | Madison | Indiana | 18095 | 3699 | 125 |
723221 | 723221 | 2020-11-12 | Madison | Indiana | 18095 | 3595 | 122 |
719978 | 719978 | 2020-11-11 | Madison | Indiana | 18095 | 3507 | 122 |
716735 | 716735 | 2020-11-10 | Madison | Indiana | 18095 | 3447 | 121 |
713491 | 713491 | 2020-11-09 | Madison | Indiana | 18095 | 3366 | 118 |
710247 | 710247 | 2020-11-08 | Madison | Indiana | 18095 | 3297 | 118 |
707003 | 707003 | 2020-11-07 | Madison | Indiana | 18095 | 3250 | 118 |
703760 | 703760 | 2020-11-06 | Madison | Indiana | 18095 | 3152 | 118 |
700518 | 700518 | 2020-11-05 | Madison | Indiana | 18095 | 3098 | 116 |
697274 | 697274 | 2020-11-04 | Madison | Indiana | 18095 | 2991 | 114 |
694032 | 694032 | 2020-11-03 | Madison | Indiana | 18095 | 2944 | 113 |
690789 | 690789 | 2020-11-02 | Madison | Indiana | 18095 | 2916 | 113 |
687544 | 687544 | 2020-11-01 | Madison | Indiana | 18095 | 2880 | 112 |
684300 | 684300 | 2020-10-31 | Madison | Indiana | 18095 | 2832 | 111 |
681057 | 681057 | 2020-10-30 | Madison | Indiana | 18095 | 2776 | 110 |
677814 | 677814 | 2020-10-29 | Madison | Indiana | 18095 | 2721 | 109 |
674571 | 674571 | 2020-10-28 | Madison | Indiana | 18095 | 2625 | 108 |
671329 | 671329 | 2020-10-27 | Madison | Indiana | 18095 | 2564 | 107 |
668086 | 668086 | 2020-10-26 | Madison | Indiana | 18095 | 2525 | 107 |
664842 | 664842 | 2020-10-25 | Madison | Indiana | 18095 | 2497 | 107 |
661597 | 661597 | 2020-10-24 | Madison | Indiana | 18095 | 2466 | 107 |
658353 | 658353 | 2020-10-23 | Madison | Indiana | 18095 | 2422 | 106 |
655108 | 655108 | 2020-10-22 | Madison | Indiana | 18095 | 2367 | 104 |
651863 | 651863 | 2020-10-21 | Madison | Indiana | 18095 | 2341 | 104 |
648619 | 648619 | 2020-10-20 | Madison | Indiana | 18095 | 2312 | 104 |
645374 | 645374 | 2020-10-19 | Madison | Indiana | 18095 | 2286 | 102 |
642127 | 642127 | 2020-10-18 | Madison | Indiana | 18095 | 2262 | 98 |
638880 | 638880 | 2020-10-17 | Madison | Indiana | 18095 | 2231 | 98 |
635634 | 635634 | 2020-10-16 | Madison | Indiana | 18095 | 2175 | 97 |
632388 | 632388 | 2020-10-15 | Madison | Indiana | 18095 | 2128 | 95 |
629144 | 629144 | 2020-10-14 | Madison | Indiana | 18095 | 2101 | 95 |
625901 | 625901 | 2020-10-13 | Madison | Indiana | 18095 | 2084 | 95 |
622659 | 622659 | 2020-10-12 | Madison | Indiana | 18095 | 2067 | 93 |
619415 | 619415 | 2020-10-11 | Madison | Indiana | 18095 | 2046 | 93 |
616173 | 616173 | 2020-10-10 | Madison | Indiana | 18095 | 2014 | 93 |
612932 | 612932 | 2020-10-09 | Madison | Indiana | 18095 | 1970 | 92 |
609690 | 609690 | 2020-10-08 | Madison | Indiana | 18095 | 1941 | 91 |
606447 | 606447 | 2020-10-07 | Madison | Indiana | 18095 | 1919 | 90 |
603205 | 603205 | 2020-10-06 | Madison | Indiana | 18095 | 1895 | 90 |
599962 | 599962 | 2020-10-05 | Madison | Indiana | 18095 | 1875 | 86 |
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);