ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Madison" and fips = 1089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1176915 | 1176915 | 2021-04-01 | Madison | Alabama | 1089 | 33577 | 489 |
1173668 | 1173668 | 2021-03-31 | Madison | Alabama | 1089 | 33533 | 489 |
1170421 | 1170421 | 2021-03-30 | Madison | Alabama | 1089 | 33508 | 488 |
1167173 | 1167173 | 2021-03-29 | Madison | Alabama | 1089 | 33480 | 488 |
1163925 | 1163925 | 2021-03-28 | Madison | Alabama | 1089 | 33463 | 488 |
1160677 | 1160677 | 2021-03-27 | Madison | Alabama | 1089 | 33431 | 488 |
1157429 | 1157429 | 2021-03-26 | Madison | Alabama | 1089 | 33401 | 488 |
1154182 | 1154182 | 2021-03-25 | Madison | Alabama | 1089 | 33362 | 487 |
1150935 | 1150935 | 2021-03-24 | Madison | Alabama | 1089 | 33326 | 486 |
1147688 | 1147688 | 2021-03-23 | Madison | Alabama | 1089 | 33285 | 485 |
1144441 | 1144441 | 2021-03-22 | Madison | Alabama | 1089 | 33292 | 486 |
1141194 | 1141194 | 2021-03-21 | Madison | Alabama | 1089 | 33268 | 486 |
1137948 | 1137948 | 2021-03-20 | Madison | Alabama | 1089 | 33249 | 486 |
1134702 | 1134702 | 2021-03-19 | Madison | Alabama | 1089 | 33210 | 486 |
1131454 | 1131454 | 2021-03-18 | Madison | Alabama | 1089 | 33174 | 483 |
1128207 | 1128207 | 2021-03-17 | Madison | Alabama | 1089 | 33108 | 480 |
1124961 | 1124961 | 2021-03-16 | Madison | Alabama | 1089 | 33049 | 479 |
1121715 | 1121715 | 2021-03-15 | Madison | Alabama | 1089 | 33013 | 479 |
1118468 | 1118468 | 2021-03-14 | Madison | Alabama | 1089 | 32922 | 479 |
1115221 | 1115221 | 2021-03-13 | Madison | Alabama | 1089 | 32892 | 479 |
1111975 | 1111975 | 2021-03-12 | Madison | Alabama | 1089 | 32850 | 479 |
1108729 | 1108729 | 2021-03-11 | Madison | Alabama | 1089 | 32818 | 478 |
1105483 | 1105483 | 2021-03-10 | Madison | Alabama | 1089 | 32786 | 475 |
1102237 | 1102237 | 2021-03-09 | Madison | Alabama | 1089 | 32754 | 474 |
1098991 | 1098991 | 2021-03-08 | Madison | Alabama | 1089 | 32722 | 469 |
1095743 | 1095743 | 2021-03-07 | Madison | Alabama | 1089 | 32708 | 469 |
1092497 | 1092497 | 2021-03-06 | Madison | Alabama | 1089 | 32674 | 469 |
1089251 | 1089251 | 2021-03-05 | Madison | Alabama | 1089 | 32639 | 469 |
1086006 | 1086006 | 2021-03-04 | Madison | Alabama | 1089 | 32616 | 468 |
1082760 | 1082760 | 2021-03-03 | Madison | Alabama | 1089 | 32573 | 462 |
1079514 | 1079514 | 2021-03-02 | Madison | Alabama | 1089 | 32457 | 458 |
1076269 | 1076269 | 2021-03-01 | Madison | Alabama | 1089 | 32425 | 455 |
1073023 | 1073023 | 2021-02-28 | Madison | Alabama | 1089 | 32405 | 455 |
1069777 | 1069777 | 2021-02-27 | Madison | Alabama | 1089 | 32355 | 455 |
1066532 | 1066532 | 2021-02-26 | Madison | Alabama | 1089 | 32307 | 450 |
1063287 | 1063287 | 2021-02-25 | Madison | Alabama | 1089 | 32255 | 442 |
1060042 | 1060042 | 2021-02-24 | Madison | Alabama | 1089 | 32203 | 443 |
1056796 | 1056796 | 2021-02-23 | Madison | Alabama | 1089 | 32088 | 437 |
1053550 | 1053550 | 2021-02-22 | Madison | Alabama | 1089 | 32008 | 432 |
1050303 | 1050303 | 2021-02-21 | Madison | Alabama | 1089 | 31957 | 432 |
1047056 | 1047056 | 2021-02-20 | Madison | Alabama | 1089 | 31869 | 432 |
1043811 | 1043811 | 2021-02-19 | Madison | Alabama | 1089 | 31823 | 431 |
1040566 | 1040566 | 2021-02-18 | Madison | Alabama | 1089 | 31741 | 422 |
1037321 | 1037321 | 2021-02-17 | Madison | Alabama | 1089 | 31664 | 411 |
1034076 | 1034076 | 2021-02-16 | Madison | Alabama | 1089 | 31649 | 402 |
1030830 | 1030830 | 2021-02-15 | Madison | Alabama | 1089 | 31593 | 402 |
1027583 | 1027583 | 2021-02-14 | Madison | Alabama | 1089 | 31538 | 402 |
1024338 | 1024338 | 2021-02-13 | Madison | Alabama | 1089 | 31432 | 402 |
1021093 | 1021093 | 2021-02-12 | Madison | Alabama | 1089 | 31312 | 403 |
1017848 | 1017848 | 2021-02-11 | Madison | Alabama | 1089 | 31219 | 400 |
1014603 | 1014603 | 2021-02-10 | Madison | Alabama | 1089 | 31076 | 397 |
1011358 | 1011358 | 2021-02-09 | Madison | Alabama | 1089 | 30919 | 364 |
1008112 | 1008112 | 2021-02-08 | Madison | Alabama | 1089 | 30840 | 363 |
1004866 | 1004866 | 2021-02-07 | Madison | Alabama | 1089 | 30744 | 363 |
1001620 | 1001620 | 2021-02-06 | Madison | Alabama | 1089 | 30626 | 363 |
998374 | 998374 | 2021-02-05 | Madison | Alabama | 1089 | 30473 | 360 |
995128 | 995128 | 2021-02-04 | Madison | Alabama | 1089 | 30305 | 353 |
991882 | 991882 | 2021-02-03 | Madison | Alabama | 1089 | 30103 | 345 |
988636 | 988636 | 2021-02-02 | Madison | Alabama | 1089 | 29906 | 306 |
985389 | 985389 | 2021-02-01 | Madison | Alabama | 1089 | 29781 | 287 |
982142 | 982142 | 2021-01-31 | Madison | Alabama | 1089 | 29680 | 287 |
978896 | 978896 | 2021-01-30 | Madison | Alabama | 1089 | 29333 | 274 |
975651 | 975651 | 2021-01-29 | Madison | Alabama | 1089 | 29333 | 274 |
972406 | 972406 | 2021-01-28 | Madison | Alabama | 1089 | 29098 | 248 |
969161 | 969161 | 2021-01-27 | Madison | Alabama | 1089 | 28795 | 237 |
965917 | 965917 | 2021-01-26 | Madison | Alabama | 1089 | 28596 | 223 |
962672 | 962672 | 2021-01-25 | Madison | Alabama | 1089 | 28413 | 217 |
959427 | 959427 | 2021-01-24 | Madison | Alabama | 1089 | 28310 | 217 |
956181 | 956181 | 2021-01-23 | Madison | Alabama | 1089 | 28158 | 217 |
952936 | 952936 | 2021-01-22 | Madison | Alabama | 1089 | 27851 | 208 |
949691 | 949691 | 2021-01-21 | Madison | Alabama | 1089 | 27627 | 201 |
946445 | 946445 | 2021-01-20 | Madison | Alabama | 1089 | 27486 | 201 |
943198 | 943198 | 2021-01-19 | Madison | Alabama | 1089 | 27303 | 186 |
939953 | 939953 | 2021-01-18 | Madison | Alabama | 1089 | 27160 | 186 |
936708 | 936708 | 2021-01-17 | Madison | Alabama | 1089 | 27052 | 186 |
933463 | 933463 | 2021-01-16 | Madison | Alabama | 1089 | 26852 | 186 |
930218 | 930218 | 2021-01-15 | Madison | Alabama | 1089 | 26637 | 185 |
926973 | 926973 | 2021-01-14 | Madison | Alabama | 1089 | 26466 | 183 |
923727 | 923727 | 2021-01-13 | Madison | Alabama | 1089 | 26190 | 182 |
920482 | 920482 | 2021-01-12 | Madison | Alabama | 1089 | 26012 | 181 |
917237 | 917237 | 2021-01-11 | Madison | Alabama | 1089 | 25643 | 178 |
913992 | 913992 | 2021-01-10 | Madison | Alabama | 1089 | 25463 | 178 |
910747 | 910747 | 2021-01-09 | Madison | Alabama | 1089 | 25219 | 177 |
907502 | 907502 | 2021-01-08 | Madison | Alabama | 1089 | 24795 | 179 |
904256 | 904256 | 2021-01-07 | Madison | Alabama | 1089 | 24395 | 179 |
901011 | 901011 | 2021-01-06 | Madison | Alabama | 1089 | 24111 | 181 |
897766 | 897766 | 2021-01-05 | Madison | Alabama | 1089 | 23840 | 179 |
894520 | 894520 | 2021-01-04 | Madison | Alabama | 1089 | 23563 | 179 |
891274 | 891274 | 2021-01-03 | Madison | Alabama | 1089 | 23364 | 179 |
888027 | 888027 | 2021-01-02 | Madison | Alabama | 1089 | 23115 | 179 |
884782 | 884782 | 2021-01-01 | Madison | Alabama | 1089 | 22590 | 179 |
881537 | 881537 | 2020-12-31 | Madison | Alabama | 1089 | 22197 | 178 |
878292 | 878292 | 2020-12-30 | Madison | Alabama | 1089 | 21884 | 178 |
875047 | 875047 | 2020-12-29 | Madison | Alabama | 1089 | 21621 | 178 |
871802 | 871802 | 2020-12-28 | Madison | Alabama | 1089 | 21385 | 179 |
868557 | 868557 | 2020-12-27 | Madison | Alabama | 1089 | 21206 | 179 |
865312 | 865312 | 2020-12-26 | Madison | Alabama | 1089 | 21038 | 179 |
862067 | 862067 | 2020-12-25 | Madison | Alabama | 1089 | 20915 | 179 |
858822 | 858822 | 2020-12-24 | Madison | Alabama | 1089 | 20540 | 179 |
855577 | 855577 | 2020-12-23 | Madison | Alabama | 1089 | 20254 | 178 |
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);