ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 24021 and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194321 | 1194321 | 2021-04-06 | Frederick | Maryland | 24021 | 18488 | 302 |
1191072 | 1191072 | 2021-04-05 | Frederick | Maryland | 24021 | 18434 | 302 |
1187824 | 1187824 | 2021-04-04 | Frederick | Maryland | 24021 | 18393 | 301 |
1184577 | 1184577 | 2021-04-03 | Frederick | Maryland | 24021 | 18356 | 301 |
1181331 | 1181331 | 2021-04-02 | Frederick | Maryland | 24021 | 18295 | 301 |
1178084 | 1178084 | 2021-04-01 | Frederick | Maryland | 24021 | 18261 | 301 |
1174837 | 1174837 | 2021-03-31 | Frederick | Maryland | 24021 | 18192 | 301 |
1171590 | 1171590 | 2021-03-30 | Frederick | Maryland | 24021 | 18142 | 300 |
1168342 | 1168342 | 2021-03-29 | Frederick | Maryland | 24021 | 18106 | 300 |
1165094 | 1165094 | 2021-03-28 | Frederick | Maryland | 24021 | 18062 | 300 |
1161846 | 1161846 | 2021-03-27 | Frederick | Maryland | 24021 | 18012 | 300 |
1158598 | 1158598 | 2021-03-26 | Frederick | Maryland | 24021 | 17970 | 298 |
1155351 | 1155351 | 2021-03-25 | Frederick | Maryland | 24021 | 17902 | 297 |
1152104 | 1152104 | 2021-03-24 | Frederick | Maryland | 24021 | 17847 | 296 |
1148857 | 1148857 | 2021-03-23 | Frederick | Maryland | 24021 | 17797 | 296 |
1145610 | 1145610 | 2021-03-22 | Frederick | Maryland | 24021 | 17781 | 293 |
1142363 | 1142363 | 2021-03-21 | Frederick | Maryland | 24021 | 17754 | 292 |
1139116 | 1139116 | 2021-03-20 | Frederick | Maryland | 24021 | 17695 | 292 |
1135870 | 1135870 | 2021-03-19 | Frederick | Maryland | 24021 | 17655 | 291 |
1132624 | 1132624 | 2021-03-18 | Frederick | Maryland | 24021 | 17602 | 289 |
1129376 | 1129376 | 2021-03-17 | Frederick | Maryland | 24021 | 17554 | 287 |
1126129 | 1126129 | 2021-03-16 | Frederick | Maryland | 24021 | 17533 | 287 |
1122883 | 1122883 | 2021-03-15 | Frederick | Maryland | 24021 | 17493 | 287 |
1119636 | 1119636 | 2021-03-14 | Frederick | Maryland | 24021 | 17460 | 287 |
1116389 | 1116389 | 2021-03-13 | Frederick | Maryland | 24021 | 17416 | 287 |
1113143 | 1113143 | 2021-03-12 | Frederick | Maryland | 24021 | 17369 | 287 |
1109897 | 1109897 | 2021-03-11 | Frederick | Maryland | 24021 | 17333 | 287 |
1106651 | 1106651 | 2021-03-10 | Frederick | Maryland | 24021 | 17291 | 286 |
1103405 | 1103405 | 2021-03-09 | Frederick | Maryland | 24021 | 17256 | 283 |
1100159 | 1100159 | 2021-03-08 | Frederick | Maryland | 24021 | 17228 | 283 |
1096912 | 1096912 | 2021-03-07 | Frederick | Maryland | 24021 | 17205 | 282 |
1093665 | 1093665 | 2021-03-06 | Frederick | Maryland | 24021 | 17175 | 281 |
1090419 | 1090419 | 2021-03-05 | Frederick | Maryland | 24021 | 17150 | 281 |
1087174 | 1087174 | 2021-03-04 | Frederick | Maryland | 24021 | 17104 | 281 |
1083929 | 1083929 | 2021-03-03 | Frederick | Maryland | 24021 | 17044 | 281 |
1080683 | 1080683 | 2021-03-02 | Frederick | Maryland | 24021 | 17012 | 281 |
1077437 | 1077437 | 2021-03-01 | Frederick | Maryland | 24021 | 16978 | 280 |
1074191 | 1074191 | 2021-02-28 | Frederick | Maryland | 24021 | 16947 | 280 |
1070945 | 1070945 | 2021-02-27 | Frederick | Maryland | 24021 | 16919 | 278 |
1067700 | 1067700 | 2021-02-26 | Frederick | Maryland | 24021 | 16878 | 276 |
1064455 | 1064455 | 2021-02-25 | Frederick | Maryland | 24021 | 16835 | 272 |
1061211 | 1061211 | 2021-02-24 | Frederick | Maryland | 24021 | 16787 | 269 |
1057965 | 1057965 | 2021-02-23 | Frederick | Maryland | 24021 | 16756 | 267 |
1054719 | 1054719 | 2021-02-22 | Frederick | Maryland | 24021 | 16724 | 267 |
1051472 | 1051472 | 2021-02-21 | Frederick | Maryland | 24021 | 16700 | 267 |
1048225 | 1048225 | 2021-02-20 | Frederick | Maryland | 24021 | 16668 | 266 |
1044979 | 1044979 | 2021-02-19 | Frederick | Maryland | 24021 | 16638 | 265 |
1041734 | 1041734 | 2021-02-18 | Frederick | Maryland | 24021 | 16591 | 265 |
1038489 | 1038489 | 2021-02-17 | Frederick | Maryland | 24021 | 16520 | 264 |
1035244 | 1035244 | 2021-02-16 | Frederick | Maryland | 24021 | 16490 | 263 |
1031999 | 1031999 | 2021-02-15 | Frederick | Maryland | 24021 | 16457 | 263 |
1028752 | 1028752 | 2021-02-14 | Frederick | Maryland | 24021 | 16418 | 261 |
1025506 | 1025506 | 2021-02-13 | Frederick | Maryland | 24021 | 16375 | 261 |
1022261 | 1022261 | 2021-02-12 | Frederick | Maryland | 24021 | 16303 | 260 |
1019016 | 1019016 | 2021-02-11 | Frederick | Maryland | 24021 | 16258 | 257 |
1015771 | 1015771 | 2021-02-10 | Frederick | Maryland | 24021 | 16199 | 257 |
1012526 | 1012526 | 2021-02-09 | Frederick | Maryland | 24021 | 16168 | 256 |
1009281 | 1009281 | 2021-02-08 | Frederick | Maryland | 24021 | 16109 | 256 |
1006034 | 1006034 | 2021-02-07 | Frederick | Maryland | 24021 | 16066 | 256 |
1002788 | 1002788 | 2021-02-06 | Frederick | Maryland | 24021 | 15977 | 256 |
999543 | 999543 | 2021-02-05 | Frederick | Maryland | 24021 | 15918 | 253 |
996297 | 996297 | 2021-02-04 | Frederick | Maryland | 24021 | 15853 | 251 |
993051 | 993051 | 2021-02-03 | Frederick | Maryland | 24021 | 15767 | 250 |
989805 | 989805 | 2021-02-02 | Frederick | Maryland | 24021 | 15730 | 245 |
986558 | 986558 | 2021-02-01 | Frederick | Maryland | 24021 | 15654 | 245 |
983311 | 983311 | 2021-01-31 | Frederick | Maryland | 24021 | 15623 | 244 |
980065 | 980065 | 2021-01-30 | Frederick | Maryland | 24021 | 15539 | 243 |
976819 | 976819 | 2021-01-29 | Frederick | Maryland | 24021 | 15455 | 243 |
973574 | 973574 | 2021-01-28 | Frederick | Maryland | 24021 | 15350 | 240 |
970329 | 970329 | 2021-01-27 | Frederick | Maryland | 24021 | 15247 | 241 |
967084 | 967084 | 2021-01-26 | Frederick | Maryland | 24021 | 15224 | 240 |
963840 | 963840 | 2021-01-25 | Frederick | Maryland | 24021 | 15121 | 239 |
960595 | 960595 | 2021-01-24 | Frederick | Maryland | 24021 | 15054 | 237 |
957349 | 957349 | 2021-01-23 | Frederick | Maryland | 24021 | 14933 | 234 |
954104 | 954104 | 2021-01-22 | Frederick | Maryland | 24021 | 14825 | 233 |
950859 | 950859 | 2021-01-21 | Frederick | Maryland | 24021 | 14701 | 229 |
947613 | 947613 | 2021-01-20 | Frederick | Maryland | 24021 | 14582 | 226 |
944366 | 944366 | 2021-01-19 | Frederick | Maryland | 24021 | 14455 | 224 |
941121 | 941121 | 2021-01-18 | Frederick | Maryland | 24021 | 14333 | 224 |
937876 | 937876 | 2021-01-17 | Frederick | Maryland | 24021 | 14238 | 223 |
934631 | 934631 | 2021-01-16 | Frederick | Maryland | 24021 | 14158 | 222 |
931386 | 931386 | 2021-01-15 | Frederick | Maryland | 24021 | 13978 | 221 |
928141 | 928141 | 2021-01-14 | Frederick | Maryland | 24021 | 13844 | 217 |
924895 | 924895 | 2021-01-13 | Frederick | Maryland | 24021 | 13684 | 215 |
921650 | 921650 | 2021-01-12 | Frederick | Maryland | 24021 | 13509 | 212 |
918405 | 918405 | 2021-01-11 | Frederick | Maryland | 24021 | 12945 | 209 |
915160 | 915160 | 2021-01-10 | Frederick | Maryland | 24021 | 12826 | 209 |
911915 | 911915 | 2021-01-09 | Frederick | Maryland | 24021 | 12738 | 209 |
908670 | 908670 | 2021-01-08 | Frederick | Maryland | 24021 | 12600 | 205 |
905424 | 905424 | 2021-01-07 | Frederick | Maryland | 24021 | 12454 | 204 |
902179 | 902179 | 2021-01-06 | Frederick | Maryland | 24021 | 12317 | 202 |
898934 | 898934 | 2021-01-05 | Frederick | Maryland | 24021 | 12198 | 200 |
895689 | 895689 | 2021-01-04 | Frederick | Maryland | 24021 | 12062 | 198 |
892442 | 892442 | 2021-01-03 | Frederick | Maryland | 24021 | 11876 | 198 |
889196 | 889196 | 2021-01-02 | Frederick | Maryland | 24021 | 11660 | 196 |
885950 | 885950 | 2021-01-01 | Frederick | Maryland | 24021 | 11526 | 196 |
882705 | 882705 | 2020-12-31 | Frederick | Maryland | 24021 | 11309 | 194 |
879460 | 879460 | 2020-12-30 | Frederick | Maryland | 24021 | 11108 | 189 |
876215 | 876215 | 2020-12-29 | Frederick | Maryland | 24021 | 10899 | 182 |
872970 | 872970 | 2020-12-28 | Frederick | Maryland | 24021 | 10796 | 182 |
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);