ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Madison" and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054094 | 1054094 | 2021-02-22 | Madison | Idaho | 16065 | 6250 | 21 |
1050847 | 1050847 | 2021-02-21 | Madison | Idaho | 16065 | 6190 | 21 |
1047600 | 1047600 | 2021-02-20 | Madison | Idaho | 16065 | 6190 | 21 |
1044355 | 1044355 | 2021-02-19 | Madison | Idaho | 16065 | 6172 | 21 |
1041110 | 1041110 | 2021-02-18 | Madison | Idaho | 16065 | 6155 | 21 |
1037865 | 1037865 | 2021-02-17 | Madison | Idaho | 16065 | 6130 | 21 |
1034620 | 1034620 | 2021-02-16 | Madison | Idaho | 16065 | 6119 | 21 |
1031374 | 1031374 | 2021-02-15 | Madison | Idaho | 16065 | 6105 | 21 |
1028127 | 1028127 | 2021-02-14 | Madison | Idaho | 16065 | 6105 | 21 |
1024882 | 1024882 | 2021-02-13 | Madison | Idaho | 16065 | 6105 | 21 |
1021637 | 1021637 | 2021-02-12 | Madison | Idaho | 16065 | 6091 | 21 |
1018392 | 1018392 | 2021-02-11 | Madison | Idaho | 16065 | 6064 | 21 |
1015147 | 1015147 | 2021-02-10 | Madison | Idaho | 16065 | 6059 | 21 |
1011902 | 1011902 | 2021-02-09 | Madison | Idaho | 16065 | 6045 | 21 |
1008656 | 1008656 | 2021-02-08 | Madison | Idaho | 16065 | 6020 | 21 |
1005410 | 1005410 | 2021-02-07 | Madison | Idaho | 16065 | 5998 | 21 |
1002164 | 1002164 | 2021-02-06 | Madison | Idaho | 16065 | 5998 | 21 |
998918 | 998918 | 2021-02-05 | Madison | Idaho | 16065 | 5981 | 21 |
995672 | 995672 | 2021-02-04 | Madison | Idaho | 16065 | 5953 | 21 |
992426 | 992426 | 2021-02-03 | Madison | Idaho | 16065 | 5932 | 21 |
989180 | 989180 | 2021-02-02 | Madison | Idaho | 16065 | 5892 | 21 |
985933 | 985933 | 2021-02-01 | Madison | Idaho | 16065 | 5873 | 21 |
982686 | 982686 | 2021-01-31 | Madison | Idaho | 16065 | 5862 | 21 |
979440 | 979440 | 2021-01-30 | Madison | Idaho | 16065 | 5862 | 21 |
976195 | 976195 | 2021-01-29 | Madison | Idaho | 16065 | 5852 | 21 |
972950 | 972950 | 2021-01-28 | Madison | Idaho | 16065 | 5831 | 21 |
969705 | 969705 | 2021-01-27 | Madison | Idaho | 16065 | 5812 | 21 |
966461 | 966461 | 2021-01-26 | Madison | Idaho | 16065 | 5777 | 21 |
963216 | 963216 | 2021-01-25 | Madison | Idaho | 16065 | 5765 | 21 |
959971 | 959971 | 2021-01-24 | Madison | Idaho | 16065 | 5760 | 21 |
956725 | 956725 | 2021-01-23 | Madison | Idaho | 16065 | 5751 | 21 |
953480 | 953480 | 2021-01-22 | Madison | Idaho | 16065 | 5738 | 21 |
950235 | 950235 | 2021-01-21 | Madison | Idaho | 16065 | 5724 | 21 |
946989 | 946989 | 2021-01-20 | Madison | Idaho | 16065 | 5712 | 21 |
943742 | 943742 | 2021-01-19 | Madison | Idaho | 16065 | 5690 | 21 |
940497 | 940497 | 2021-01-18 | Madison | Idaho | 16065 | 5658 | 21 |
937252 | 937252 | 2021-01-17 | Madison | Idaho | 16065 | 5658 | 21 |
934007 | 934007 | 2021-01-16 | Madison | Idaho | 16065 | 5647 | 21 |
930762 | 930762 | 2021-01-15 | Madison | Idaho | 16065 | 5631 | 21 |
927517 | 927517 | 2021-01-14 | Madison | Idaho | 16065 | 5582 | 21 |
924271 | 924271 | 2021-01-13 | Madison | Idaho | 16065 | 5540 | 21 |
921026 | 921026 | 2021-01-12 | Madison | Idaho | 16065 | 5490 | 21 |
917781 | 917781 | 2021-01-11 | Madison | Idaho | 16065 | 5467 | 21 |
914536 | 914536 | 2021-01-10 | Madison | Idaho | 16065 | 5461 | 21 |
911291 | 911291 | 2021-01-09 | Madison | Idaho | 16065 | 5444 | 21 |
908046 | 908046 | 2021-01-08 | Madison | Idaho | 16065 | 5425 | 21 |
904800 | 904800 | 2021-01-07 | Madison | Idaho | 16065 | 5386 | 21 |
901555 | 901555 | 2021-01-06 | Madison | Idaho | 16065 | 5356 | 21 |
898310 | 898310 | 2021-01-05 | Madison | Idaho | 16065 | 5310 | 19 |
895065 | 895065 | 2021-01-04 | Madison | Idaho | 16065 | 5291 | 19 |
891818 | 891818 | 2021-01-03 | Madison | Idaho | 16065 | 5277 | 18 |
888571 | 888571 | 2021-01-02 | Madison | Idaho | 16065 | 5266 | 18 |
885326 | 885326 | 2021-01-01 | Madison | Idaho | 16065 | 5248 | 18 |
882081 | 882081 | 2020-12-31 | Madison | Idaho | 16065 | 5248 | 18 |
878836 | 878836 | 2020-12-30 | Madison | Idaho | 16065 | 5212 | 15 |
875591 | 875591 | 2020-12-29 | Madison | Idaho | 16065 | 5197 | 14 |
872346 | 872346 | 2020-12-28 | Madison | Idaho | 16065 | 5177 | 14 |
869101 | 869101 | 2020-12-27 | Madison | Idaho | 16065 | 5168 | 13 |
865856 | 865856 | 2020-12-26 | Madison | Idaho | 16065 | 5162 | 13 |
862611 | 862611 | 2020-12-25 | Madison | Idaho | 16065 | 5144 | 13 |
859366 | 859366 | 2020-12-24 | Madison | Idaho | 16065 | 5144 | 13 |
856121 | 856121 | 2020-12-23 | Madison | Idaho | 16065 | 5132 | 13 |
852876 | 852876 | 2020-12-22 | Madison | Idaho | 16065 | 5097 | 11 |
849631 | 849631 | 2020-12-21 | Madison | Idaho | 16065 | 5084 | 10 |
846386 | 846386 | 2020-12-20 | Madison | Idaho | 16065 | 5073 | 10 |
843140 | 843140 | 2020-12-19 | Madison | Idaho | 16065 | 5017 | 10 |
839895 | 839895 | 2020-12-18 | Madison | Idaho | 16065 | 5019 | 10 |
836650 | 836650 | 2020-12-17 | Madison | Idaho | 16065 | 5005 | 10 |
833404 | 833404 | 2020-12-16 | Madison | Idaho | 16065 | 4978 | 10 |
830157 | 830157 | 2020-12-15 | Madison | Idaho | 16065 | 4937 | 10 |
826911 | 826911 | 2020-12-14 | Madison | Idaho | 16065 | 4919 | 10 |
823664 | 823664 | 2020-12-13 | Madison | Idaho | 16065 | 4910 | 10 |
820418 | 820418 | 2020-12-12 | Madison | Idaho | 16065 | 4876 | 10 |
817172 | 817172 | 2020-12-11 | Madison | Idaho | 16065 | 4862 | 10 |
813926 | 813926 | 2020-12-10 | Madison | Idaho | 16065 | 4825 | 10 |
810681 | 810681 | 2020-12-09 | Madison | Idaho | 16065 | 4758 | 10 |
807436 | 807436 | 2020-12-08 | Madison | Idaho | 16065 | 4678 | 10 |
804191 | 804191 | 2020-12-07 | Madison | Idaho | 16065 | 4594 | 9 |
800946 | 800946 | 2020-12-06 | Madison | Idaho | 16065 | 4487 | 9 |
797701 | 797701 | 2020-12-05 | Madison | Idaho | 16065 | 4440 | 9 |
794456 | 794456 | 2020-12-04 | Madison | Idaho | 16065 | 4438 | 8 |
791211 | 791211 | 2020-12-03 | Madison | Idaho | 16065 | 4386 | 8 |
787966 | 787966 | 2020-12-02 | Madison | Idaho | 16065 | 4328 | 8 |
784722 | 784722 | 2020-12-01 | Madison | Idaho | 16065 | 4276 | 8 |
781477 | 781477 | 2020-11-30 | Madison | Idaho | 16065 | 4238 | 8 |
778231 | 778231 | 2020-11-29 | Madison | Idaho | 16065 | 4191 | 8 |
774986 | 774986 | 2020-11-28 | Madison | Idaho | 16065 | 4121 | 8 |
771741 | 771741 | 2020-11-27 | Madison | Idaho | 16065 | 4053 | 8 |
768496 | 768496 | 2020-11-26 | Madison | Idaho | 16065 | 4011 | 7 |
765250 | 765250 | 2020-11-25 | Madison | Idaho | 16065 | 4011 | 7 |
762005 | 762005 | 2020-11-24 | Madison | Idaho | 16065 | 3973 | 7 |
758760 | 758760 | 2020-11-23 | Madison | Idaho | 16065 | 3888 | 7 |
755513 | 755513 | 2020-11-22 | Madison | Idaho | 16065 | 3864 | 7 |
752267 | 752267 | 2020-11-21 | Madison | Idaho | 16065 | 3798 | 7 |
749021 | 749021 | 2020-11-20 | Madison | Idaho | 16065 | 3739 | 7 |
745775 | 745775 | 2020-11-19 | Madison | Idaho | 16065 | 3681 | 7 |
742528 | 742528 | 2020-11-18 | Madison | Idaho | 16065 | 3590 | 7 |
739281 | 739281 | 2020-11-17 | Madison | Idaho | 16065 | 3518 | 7 |
736037 | 736037 | 2020-11-16 | Madison | Idaho | 16065 | 3472 | 7 |
732791 | 732791 | 2020-11-15 | Madison | Idaho | 16065 | 3412 | 7 |
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);