ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Washington" and fips = 24043 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194333 | 1194333 | 2021-04-06 | Washington | Maryland | 24043 | 13447 | 264 |
1191084 | 1191084 | 2021-04-05 | Washington | Maryland | 24043 | 13428 | 263 |
1187836 | 1187836 | 2021-04-04 | Washington | Maryland | 24043 | 13412 | 263 |
1184589 | 1184589 | 2021-04-03 | Washington | Maryland | 24043 | 13366 | 263 |
1181343 | 1181343 | 2021-04-02 | Washington | Maryland | 24043 | 13329 | 263 |
1178096 | 1178096 | 2021-04-01 | Washington | Maryland | 24043 | 13297 | 263 |
1174849 | 1174849 | 2021-03-31 | Washington | Maryland | 24043 | 13248 | 263 |
1171602 | 1171602 | 2021-03-30 | Washington | Maryland | 24043 | 13175 | 263 |
1168354 | 1168354 | 2021-03-29 | Washington | Maryland | 24043 | 13159 | 262 |
1165106 | 1165106 | 2021-03-28 | Washington | Maryland | 24043 | 13135 | 262 |
1161858 | 1161858 | 2021-03-27 | Washington | Maryland | 24043 | 13090 | 262 |
1158610 | 1158610 | 2021-03-26 | Washington | Maryland | 24043 | 13049 | 262 |
1155363 | 1155363 | 2021-03-25 | Washington | Maryland | 24043 | 13001 | 262 |
1152116 | 1152116 | 2021-03-24 | Washington | Maryland | 24043 | 12950 | 262 |
1148869 | 1148869 | 2021-03-23 | Washington | Maryland | 24043 | 12911 | 262 |
1145622 | 1145622 | 2021-03-22 | Washington | Maryland | 24043 | 12897 | 260 |
1142375 | 1142375 | 2021-03-21 | Washington | Maryland | 24043 | 12881 | 260 |
1139128 | 1139128 | 2021-03-20 | Washington | Maryland | 24043 | 12860 | 260 |
1135882 | 1135882 | 2021-03-19 | Washington | Maryland | 24043 | 12835 | 260 |
1132636 | 1132636 | 2021-03-18 | Washington | Maryland | 24043 | 12785 | 260 |
1129388 | 1129388 | 2021-03-17 | Washington | Maryland | 24043 | 12756 | 260 |
1126141 | 1126141 | 2021-03-16 | Washington | Maryland | 24043 | 12701 | 259 |
1122895 | 1122895 | 2021-03-15 | Washington | Maryland | 24043 | 12686 | 259 |
1119648 | 1119648 | 2021-03-14 | Washington | Maryland | 24043 | 12668 | 259 |
1116401 | 1116401 | 2021-03-13 | Washington | Maryland | 24043 | 12652 | 259 |
1113155 | 1113155 | 2021-03-12 | Washington | Maryland | 24043 | 12616 | 259 |
1109909 | 1109909 | 2021-03-11 | Washington | Maryland | 24043 | 12602 | 259 |
1106663 | 1106663 | 2021-03-10 | Washington | Maryland | 24043 | 12574 | 259 |
1103417 | 1103417 | 2021-03-09 | Washington | Maryland | 24043 | 12541 | 259 |
1100171 | 1100171 | 2021-03-08 | Washington | Maryland | 24043 | 12529 | 258 |
1096924 | 1096924 | 2021-03-07 | Washington | Maryland | 24043 | 12522 | 258 |
1093677 | 1093677 | 2021-03-06 | Washington | Maryland | 24043 | 12503 | 257 |
1090431 | 1090431 | 2021-03-05 | Washington | Maryland | 24043 | 12487 | 257 |
1087186 | 1087186 | 2021-03-04 | Washington | Maryland | 24043 | 12468 | 255 |
1083941 | 1083941 | 2021-03-03 | Washington | Maryland | 24043 | 12451 | 255 |
1080695 | 1080695 | 2021-03-02 | Washington | Maryland | 24043 | 12430 | 254 |
1077449 | 1077449 | 2021-03-01 | Washington | Maryland | 24043 | 12420 | 253 |
1074203 | 1074203 | 2021-02-28 | Washington | Maryland | 24043 | 12411 | 253 |
1070957 | 1070957 | 2021-02-27 | Washington | Maryland | 24043 | 12386 | 253 |
1067712 | 1067712 | 2021-02-26 | Washington | Maryland | 24043 | 12369 | 252 |
1064467 | 1064467 | 2021-02-25 | Washington | Maryland | 24043 | 12347 | 252 |
1061223 | 1061223 | 2021-02-24 | Washington | Maryland | 24043 | 12284 | 251 |
1057977 | 1057977 | 2021-02-23 | Washington | Maryland | 24043 | 12267 | 249 |
1054731 | 1054731 | 2021-02-22 | Washington | Maryland | 24043 | 12252 | 248 |
1051484 | 1051484 | 2021-02-21 | Washington | Maryland | 24043 | 12235 | 248 |
1048237 | 1048237 | 2021-02-20 | Washington | Maryland | 24043 | 12206 | 248 |
1044991 | 1044991 | 2021-02-19 | Washington | Maryland | 24043 | 12192 | 247 |
1041746 | 1041746 | 2021-02-18 | Washington | Maryland | 24043 | 12167 | 248 |
1038501 | 1038501 | 2021-02-17 | Washington | Maryland | 24043 | 12139 | 245 |
1035256 | 1035256 | 2021-02-16 | Washington | Maryland | 24043 | 12103 | 245 |
1032011 | 1032011 | 2021-02-15 | Washington | Maryland | 24043 | 12089 | 243 |
1028764 | 1028764 | 2021-02-14 | Washington | Maryland | 24043 | 12068 | 240 |
1025518 | 1025518 | 2021-02-13 | Washington | Maryland | 24043 | 12033 | 240 |
1022273 | 1022273 | 2021-02-12 | Washington | Maryland | 24043 | 11894 | 240 |
1019028 | 1019028 | 2021-02-11 | Washington | Maryland | 24043 | 11862 | 240 |
1015783 | 1015783 | 2021-02-10 | Washington | Maryland | 24043 | 11802 | 240 |
1012538 | 1012538 | 2021-02-09 | Washington | Maryland | 24043 | 11759 | 239 |
1009293 | 1009293 | 2021-02-08 | Washington | Maryland | 24043 | 11732 | 238 |
1006046 | 1006046 | 2021-02-07 | Washington | Maryland | 24043 | 11717 | 236 |
1002800 | 1002800 | 2021-02-06 | Washington | Maryland | 24043 | 11667 | 235 |
999555 | 999555 | 2021-02-05 | Washington | Maryland | 24043 | 11623 | 233 |
996309 | 996309 | 2021-02-04 | Washington | Maryland | 24043 | 11573 | 231 |
993063 | 993063 | 2021-02-03 | Washington | Maryland | 24043 | 11524 | 230 |
989817 | 989817 | 2021-02-02 | Washington | Maryland | 24043 | 11497 | 228 |
986570 | 986570 | 2021-02-01 | Washington | Maryland | 24043 | 11474 | 227 |
983323 | 983323 | 2021-01-31 | Washington | Maryland | 24043 | 11445 | 226 |
980077 | 980077 | 2021-01-30 | Washington | Maryland | 24043 | 11379 | 226 |
976831 | 976831 | 2021-01-29 | Washington | Maryland | 24043 | 11310 | 222 |
973586 | 973586 | 2021-01-28 | Washington | Maryland | 24043 | 11231 | 222 |
970341 | 970341 | 2021-01-27 | Washington | Maryland | 24043 | 11156 | 219 |
967096 | 967096 | 2021-01-26 | Washington | Maryland | 24043 | 11105 | 217 |
963852 | 963852 | 2021-01-25 | Washington | Maryland | 24043 | 11051 | 210 |
960607 | 960607 | 2021-01-24 | Washington | Maryland | 24043 | 11009 | 209 |
957361 | 957361 | 2021-01-23 | Washington | Maryland | 24043 | 10951 | 206 |
954116 | 954116 | 2021-01-22 | Washington | Maryland | 24043 | 10872 | 203 |
950871 | 950871 | 2021-01-21 | Washington | Maryland | 24043 | 10817 | 195 |
947625 | 947625 | 2021-01-20 | Washington | Maryland | 24043 | 10733 | 193 |
944378 | 944378 | 2021-01-19 | Washington | Maryland | 24043 | 10628 | 187 |
941133 | 941133 | 2021-01-18 | Washington | Maryland | 24043 | 10552 | 184 |
937888 | 937888 | 2021-01-17 | Washington | Maryland | 24043 | 10498 | 181 |
934643 | 934643 | 2021-01-16 | Washington | Maryland | 24043 | 10421 | 181 |
931398 | 931398 | 2021-01-15 | Washington | Maryland | 24043 | 10309 | 180 |
928153 | 928153 | 2021-01-14 | Washington | Maryland | 24043 | 10125 | 180 |
924907 | 924907 | 2021-01-13 | Washington | Maryland | 24043 | 9962 | 178 |
921662 | 921662 | 2021-01-12 | Washington | Maryland | 24043 | 9855 | 176 |
918417 | 918417 | 2021-01-11 | Washington | Maryland | 24043 | 9771 | 174 |
915172 | 915172 | 2021-01-10 | Washington | Maryland | 24043 | 9681 | 174 |
911927 | 911927 | 2021-01-09 | Washington | Maryland | 24043 | 9583 | 173 |
908682 | 908682 | 2021-01-08 | Washington | Maryland | 24043 | 9395 | 172 |
905436 | 905436 | 2021-01-07 | Washington | Maryland | 24043 | 9263 | 165 |
902191 | 902191 | 2021-01-06 | Washington | Maryland | 24043 | 9085 | 163 |
898946 | 898946 | 2021-01-05 | Washington | Maryland | 24043 | 8881 | 161 |
895701 | 895701 | 2021-01-04 | Washington | Maryland | 24043 | 8768 | 157 |
892454 | 892454 | 2021-01-03 | Washington | Maryland | 24043 | 8635 | 156 |
889208 | 889208 | 2021-01-02 | Washington | Maryland | 24043 | 8570 | 155 |
885962 | 885962 | 2021-01-01 | Washington | Maryland | 24043 | 8434 | 153 |
882717 | 882717 | 2020-12-31 | Washington | Maryland | 24043 | 8208 | 149 |
879472 | 879472 | 2020-12-30 | Washington | Maryland | 24043 | 8007 | 147 |
876227 | 876227 | 2020-12-29 | Washington | Maryland | 24043 | 7829 | 142 |
872982 | 872982 | 2020-12-28 | Washington | Maryland | 24043 | 7732 | 138 |
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);