ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Lee" and fips = 19111 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193959 | 1193959 | 2021-04-06 | Lee | Iowa | 19111 | 3655 | 55 |
1190709 | 1190709 | 2021-04-05 | Lee | Iowa | 19111 | 3652 | 55 |
1187462 | 1187462 | 2021-04-04 | Lee | Iowa | 19111 | 3652 | 55 |
1184215 | 1184215 | 2021-04-03 | Lee | Iowa | 19111 | 3651 | 55 |
1180968 | 1180968 | 2021-04-02 | Lee | Iowa | 19111 | 3644 | 55 |
1177721 | 1177721 | 2021-04-01 | Lee | Iowa | 19111 | 3642 | 55 |
1174474 | 1174474 | 2021-03-31 | Lee | Iowa | 19111 | 3637 | 55 |
1171227 | 1171227 | 2021-03-30 | Lee | Iowa | 19111 | 3634 | 55 |
1167979 | 1167979 | 2021-03-29 | Lee | Iowa | 19111 | 3633 | 55 |
1164731 | 1164731 | 2021-03-28 | Lee | Iowa | 19111 | 3632 | 55 |
1161483 | 1161483 | 2021-03-27 | Lee | Iowa | 19111 | 3632 | 55 |
1158235 | 1158235 | 2021-03-26 | Lee | Iowa | 19111 | 3632 | 55 |
1154988 | 1154988 | 2021-03-25 | Lee | Iowa | 19111 | 3631 | 55 |
1151741 | 1151741 | 2021-03-24 | Lee | Iowa | 19111 | 3556 | 55 |
1148494 | 1148494 | 2021-03-23 | Lee | Iowa | 19111 | 3555 | 54 |
1145247 | 1145247 | 2021-03-22 | Lee | Iowa | 19111 | 3553 | 54 |
1142000 | 1142000 | 2021-03-21 | Lee | Iowa | 19111 | 3552 | 54 |
1138754 | 1138754 | 2021-03-20 | Lee | Iowa | 19111 | 3552 | 54 |
1135508 | 1135508 | 2021-03-19 | Lee | Iowa | 19111 | 3552 | 54 |
1132261 | 1132261 | 2021-03-18 | Lee | Iowa | 19111 | 3552 | 54 |
1129013 | 1129013 | 2021-03-17 | Lee | Iowa | 19111 | 3552 | 54 |
1125767 | 1125767 | 2021-03-16 | Lee | Iowa | 19111 | 3551 | 55 |
1122521 | 1122521 | 2021-03-15 | Lee | Iowa | 19111 | 3549 | 55 |
1119274 | 1119274 | 2021-03-14 | Lee | Iowa | 19111 | 3549 | 55 |
1116027 | 1116027 | 2021-03-13 | Lee | Iowa | 19111 | 3549 | 55 |
1112781 | 1112781 | 2021-03-12 | Lee | Iowa | 19111 | 3549 | 55 |
1109535 | 1109535 | 2021-03-11 | Lee | Iowa | 19111 | 3549 | 55 |
1106289 | 1106289 | 2021-03-10 | Lee | Iowa | 19111 | 3549 | 54 |
1103043 | 1103043 | 2021-03-09 | Lee | Iowa | 19111 | 3546 | 53 |
1099797 | 1099797 | 2021-03-08 | Lee | Iowa | 19111 | 3546 | 53 |
1096549 | 1096549 | 2021-03-07 | Lee | Iowa | 19111 | 3544 | 53 |
1093303 | 1093303 | 2021-03-06 | Lee | Iowa | 19111 | 3544 | 53 |
1090057 | 1090057 | 2021-03-05 | Lee | Iowa | 19111 | 3544 | 53 |
1086812 | 1086812 | 2021-03-04 | Lee | Iowa | 19111 | 3542 | 53 |
1083566 | 1083566 | 2021-03-03 | Lee | Iowa | 19111 | 3539 | 52 |
1080320 | 1080320 | 2021-03-02 | Lee | Iowa | 19111 | 3538 | 52 |
1077075 | 1077075 | 2021-03-01 | Lee | Iowa | 19111 | 3534 | 52 |
1073829 | 1073829 | 2021-02-28 | Lee | Iowa | 19111 | 3526 | 52 |
1070583 | 1070583 | 2021-02-27 | Lee | Iowa | 19111 | 3526 | 52 |
1067338 | 1067338 | 2021-02-26 | Lee | Iowa | 19111 | 3526 | 52 |
1064093 | 1064093 | 2021-02-25 | Lee | Iowa | 19111 | 3519 | 51 |
1060848 | 1060848 | 2021-02-24 | Lee | Iowa | 19111 | 3483 | 51 |
1057602 | 1057602 | 2021-02-23 | Lee | Iowa | 19111 | 3483 | 51 |
1054356 | 1054356 | 2021-02-22 | Lee | Iowa | 19111 | 3483 | 51 |
1051109 | 1051109 | 2021-02-21 | Lee | Iowa | 19111 | 3483 | 51 |
1047862 | 1047862 | 2021-02-20 | Lee | Iowa | 19111 | 3483 | 51 |
1044617 | 1044617 | 2021-02-19 | Lee | Iowa | 19111 | 3483 | 51 |
1041372 | 1041372 | 2021-02-18 | Lee | Iowa | 19111 | 3480 | 51 |
1038127 | 1038127 | 2021-02-17 | Lee | Iowa | 19111 | 3475 | 51 |
1034882 | 1034882 | 2021-02-16 | Lee | Iowa | 19111 | 3470 | 50 |
1031636 | 1031636 | 2021-02-15 | Lee | Iowa | 19111 | 3465 | 47 |
1028389 | 1028389 | 2021-02-14 | Lee | Iowa | 19111 | 3458 | 47 |
1025144 | 1025144 | 2021-02-13 | Lee | Iowa | 19111 | 3456 | 47 |
1021899 | 1021899 | 2021-02-12 | Lee | Iowa | 19111 | 3449 | 47 |
1018654 | 1018654 | 2021-02-11 | Lee | Iowa | 19111 | 3448 | 47 |
1015409 | 1015409 | 2021-02-10 | Lee | Iowa | 19111 | 3446 | 47 |
1012164 | 1012164 | 2021-02-09 | Lee | Iowa | 19111 | 3438 | 47 |
1008918 | 1008918 | 2021-02-08 | Lee | Iowa | 19111 | 3427 | 46 |
1005672 | 1005672 | 2021-02-07 | Lee | Iowa | 19111 | 3425 | 46 |
1002426 | 1002426 | 2021-02-06 | Lee | Iowa | 19111 | 3421 | 46 |
999180 | 999180 | 2021-02-05 | Lee | Iowa | 19111 | 3410 | 45 |
995934 | 995934 | 2021-02-04 | Lee | Iowa | 19111 | 3404 | 43 |
992688 | 992688 | 2021-02-03 | Lee | Iowa | 19111 | 3395 | 43 |
989442 | 989442 | 2021-02-02 | Lee | Iowa | 19111 | 3390 | 42 |
986195 | 986195 | 2021-02-01 | Lee | Iowa | 19111 | 3376 | 42 |
982948 | 982948 | 2021-01-31 | Lee | Iowa | 19111 | 3365 | 42 |
979702 | 979702 | 2021-01-30 | Lee | Iowa | 19111 | 3360 | 35 |
976456 | 976456 | 2021-01-29 | Lee | Iowa | 19111 | 3336 | 35 |
973211 | 973211 | 2021-01-28 | Lee | Iowa | 19111 | 3328 | 34 |
969966 | 969966 | 2021-01-27 | Lee | Iowa | 19111 | 3303 | 33 |
966722 | 966722 | 2021-01-26 | Lee | Iowa | 19111 | 3271 | 32 |
963477 | 963477 | 2021-01-25 | Lee | Iowa | 19111 | 3269 | 32 |
960232 | 960232 | 2021-01-24 | Lee | Iowa | 19111 | 3246 | 32 |
956986 | 956986 | 2021-01-23 | Lee | Iowa | 19111 | 3241 | 32 |
953741 | 953741 | 2021-01-22 | Lee | Iowa | 19111 | 3226 | 32 |
950496 | 950496 | 2021-01-21 | Lee | Iowa | 19111 | 3211 | 32 |
947250 | 947250 | 2021-01-20 | Lee | Iowa | 19111 | 3181 | 31 |
944003 | 944003 | 2021-01-19 | Lee | Iowa | 19111 | 3171 | 30 |
940758 | 940758 | 2021-01-18 | Lee | Iowa | 19111 | 3158 | 30 |
937513 | 937513 | 2021-01-17 | Lee | Iowa | 19111 | 3144 | 30 |
934268 | 934268 | 2021-01-16 | Lee | Iowa | 19111 | 3135 | 30 |
931023 | 931023 | 2021-01-15 | Lee | Iowa | 19111 | 3125 | 28 |
927778 | 927778 | 2021-01-14 | Lee | Iowa | 19111 | 3108 | 28 |
924532 | 924532 | 2021-01-13 | Lee | Iowa | 19111 | 3093 | 28 |
921287 | 921287 | 2021-01-12 | Lee | Iowa | 19111 | 3076 | 28 |
918042 | 918042 | 2021-01-11 | Lee | Iowa | 19111 | 3068 | 28 |
914797 | 914797 | 2021-01-10 | Lee | Iowa | 19111 | 3058 | 28 |
911552 | 911552 | 2021-01-09 | Lee | Iowa | 19111 | 3053 | 28 |
908307 | 908307 | 2021-01-08 | Lee | Iowa | 19111 | 3042 | 28 |
905061 | 905061 | 2021-01-07 | Lee | Iowa | 19111 | 3017 | 28 |
901816 | 901816 | 2021-01-06 | Lee | Iowa | 19111 | 2990 | 28 |
898571 | 898571 | 2021-01-05 | Lee | Iowa | 19111 | 2967 | 27 |
895326 | 895326 | 2021-01-04 | Lee | Iowa | 19111 | 2932 | 27 |
892079 | 892079 | 2021-01-03 | Lee | Iowa | 19111 | 2906 | 25 |
888833 | 888833 | 2021-01-02 | Lee | Iowa | 19111 | 2895 | 25 |
885587 | 885587 | 2021-01-01 | Lee | Iowa | 19111 | 2878 | 24 |
882342 | 882342 | 2020-12-31 | Lee | Iowa | 19111 | 2859 | 24 |
879097 | 879097 | 2020-12-30 | Lee | Iowa | 19111 | 2840 | 24 |
875852 | 875852 | 2020-12-29 | Lee | Iowa | 19111 | 2828 | 24 |
872607 | 872607 | 2020-12-28 | Lee | Iowa | 19111 | 2818 | 24 |
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);