ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Washington" and fips = 42125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195434 | 1195434 | 2021-04-06 | Washington | Pennsylvania | 42125 | 15502 | 276 |
1192186 | 1192186 | 2021-04-05 | Washington | Pennsylvania | 42125 | 15390 | 276 |
1188937 | 1188937 | 2021-04-04 | Washington | Pennsylvania | 42125 | 15368 | 276 |
1185690 | 1185690 | 2021-04-03 | Washington | Pennsylvania | 42125 | 15345 | 276 |
1182443 | 1182443 | 2021-04-02 | Washington | Pennsylvania | 42125 | 15243 | 275 |
1179196 | 1179196 | 2021-04-01 | Washington | Pennsylvania | 42125 | 15154 | 275 |
1175949 | 1175949 | 2021-03-31 | Washington | Pennsylvania | 42125 | 15114 | 275 |
1172702 | 1172702 | 2021-03-30 | Washington | Pennsylvania | 42125 | 15034 | 274 |
1169455 | 1169455 | 2021-03-29 | Washington | Pennsylvania | 42125 | 14947 | 274 |
1166207 | 1166207 | 2021-03-28 | Washington | Pennsylvania | 42125 | 14876 | 274 |
1162959 | 1162959 | 2021-03-27 | Washington | Pennsylvania | 42125 | 14850 | 274 |
1159710 | 1159710 | 2021-03-26 | Washington | Pennsylvania | 42125 | 14785 | 273 |
1156463 | 1156463 | 2021-03-25 | Washington | Pennsylvania | 42125 | 14687 | 273 |
1153216 | 1153216 | 2021-03-24 | Washington | Pennsylvania | 42125 | 14650 | 273 |
1149969 | 1149969 | 2021-03-23 | Washington | Pennsylvania | 42125 | 14564 | 271 |
1146722 | 1146722 | 2021-03-22 | Washington | Pennsylvania | 42125 | 14484 | 271 |
1143475 | 1143475 | 2021-03-21 | Washington | Pennsylvania | 42125 | 14468 | 271 |
1140228 | 1140228 | 2021-03-20 | Washington | Pennsylvania | 42125 | 14434 | 271 |
1136982 | 1136982 | 2021-03-19 | Washington | Pennsylvania | 42125 | 14374 | 271 |
1133736 | 1133736 | 2021-03-18 | Washington | Pennsylvania | 42125 | 14327 | 271 |
1130488 | 1130488 | 2021-03-17 | Washington | Pennsylvania | 42125 | 14289 | 271 |
1127241 | 1127241 | 2021-03-16 | Washington | Pennsylvania | 42125 | 14245 | 271 |
1123995 | 1123995 | 2021-03-15 | Washington | Pennsylvania | 42125 | 14182 | 271 |
1120749 | 1120749 | 2021-03-14 | Washington | Pennsylvania | 42125 | 14179 | 268 |
1117502 | 1117502 | 2021-03-13 | Washington | Pennsylvania | 42125 | 14163 | 268 |
1114255 | 1114255 | 2021-03-12 | Washington | Pennsylvania | 42125 | 14112 | 268 |
1111009 | 1111009 | 2021-03-11 | Washington | Pennsylvania | 42125 | 14076 | 268 |
1107763 | 1107763 | 2021-03-10 | Washington | Pennsylvania | 42125 | 14047 | 266 |
1104517 | 1104517 | 2021-03-09 | Washington | Pennsylvania | 42125 | 14003 | 266 |
1101271 | 1101271 | 2021-03-08 | Washington | Pennsylvania | 42125 | 13938 | 265 |
1098025 | 1098025 | 2021-03-07 | Washington | Pennsylvania | 42125 | 13926 | 265 |
1094777 | 1094777 | 2021-03-06 | Washington | Pennsylvania | 42125 | 13904 | 264 |
1091531 | 1091531 | 2021-03-05 | Washington | Pennsylvania | 42125 | 13863 | 262 |
1088285 | 1088285 | 2021-03-04 | Washington | Pennsylvania | 42125 | 13833 | 261 |
1085040 | 1085040 | 2021-03-03 | Washington | Pennsylvania | 42125 | 13795 | 260 |
1081794 | 1081794 | 2021-03-02 | Washington | Pennsylvania | 42125 | 13766 | 258 |
1078548 | 1078548 | 2021-03-01 | Washington | Pennsylvania | 42125 | 13727 | 258 |
1075303 | 1075303 | 2021-02-28 | Washington | Pennsylvania | 42125 | 13701 | 258 |
1072057 | 1072057 | 2021-02-27 | Washington | Pennsylvania | 42125 | 13687 | 257 |
1068811 | 1068811 | 2021-02-26 | Washington | Pennsylvania | 42125 | 13664 | 257 |
1065566 | 1065566 | 2021-02-25 | Washington | Pennsylvania | 42125 | 13621 | 258 |
1062321 | 1062321 | 2021-02-24 | Washington | Pennsylvania | 42125 | 13607 | 257 |
1059076 | 1059076 | 2021-02-23 | Washington | Pennsylvania | 42125 | 13574 | 257 |
1055830 | 1055830 | 2021-02-22 | Washington | Pennsylvania | 42125 | 13544 | 257 |
1052584 | 1052584 | 2021-02-21 | Washington | Pennsylvania | 42125 | 13534 | 256 |
1049337 | 1049337 | 2021-02-20 | Washington | Pennsylvania | 42125 | 13493 | 254 |
1046090 | 1046090 | 2021-02-19 | Washington | Pennsylvania | 42125 | 13462 | 250 |
1042845 | 1042845 | 2021-02-18 | Washington | Pennsylvania | 42125 | 13430 | 249 |
1039600 | 1039600 | 2021-02-17 | Washington | Pennsylvania | 42125 | 13395 | 248 |
1036355 | 1036355 | 2021-02-16 | Washington | Pennsylvania | 42125 | 13362 | 246 |
1033110 | 1033110 | 2021-02-15 | Washington | Pennsylvania | 42125 | 13311 | 246 |
1029864 | 1029864 | 2021-02-14 | Washington | Pennsylvania | 42125 | 13278 | 246 |
1026617 | 1026617 | 2021-02-13 | Washington | Pennsylvania | 42125 | 13246 | 246 |
1023372 | 1023372 | 2021-02-12 | Washington | Pennsylvania | 42125 | 13198 | 244 |
1020127 | 1020127 | 2021-02-11 | Washington | Pennsylvania | 42125 | 13150 | 242 |
1016882 | 1016882 | 2021-02-10 | Washington | Pennsylvania | 42125 | 13116 | 240 |
1013637 | 1013637 | 2021-02-09 | Washington | Pennsylvania | 42125 | 13082 | 240 |
1010392 | 1010392 | 2021-02-08 | Washington | Pennsylvania | 42125 | 13028 | 238 |
1007146 | 1007146 | 2021-02-07 | Washington | Pennsylvania | 42125 | 13003 | 245 |
1003900 | 1003900 | 2021-02-06 | Washington | Pennsylvania | 42125 | 12949 | 242 |
1000654 | 1000654 | 2021-02-05 | Washington | Pennsylvania | 42125 | 12874 | 237 |
997408 | 997408 | 2021-02-04 | Washington | Pennsylvania | 42125 | 12812 | 235 |
994162 | 994162 | 2021-02-03 | Washington | Pennsylvania | 42125 | 12741 | 234 |
990916 | 990916 | 2021-02-02 | Washington | Pennsylvania | 42125 | 12682 | 228 |
987670 | 987670 | 2021-02-01 | Washington | Pennsylvania | 42125 | 12596 | 226 |
984423 | 984423 | 2021-01-31 | Washington | Pennsylvania | 42125 | 12562 | 225 |
981176 | 981176 | 2021-01-30 | Washington | Pennsylvania | 42125 | 12531 | 223 |
977930 | 977930 | 2021-01-29 | Washington | Pennsylvania | 42125 | 12452 | 222 |
974685 | 974685 | 2021-01-28 | Washington | Pennsylvania | 42125 | 12348 | 216 |
971440 | 971440 | 2021-01-27 | Washington | Pennsylvania | 42125 | 12267 | 207 |
968195 | 968195 | 2021-01-26 | Washington | Pennsylvania | 42125 | 12163 | 204 |
964951 | 964951 | 2021-01-25 | Washington | Pennsylvania | 42125 | 12090 | 199 |
961706 | 961706 | 2021-01-24 | Washington | Pennsylvania | 42125 | 11996 | 199 |
958461 | 958461 | 2021-01-23 | Washington | Pennsylvania | 42125 | 11945 | 197 |
955215 | 955215 | 2021-01-22 | Washington | Pennsylvania | 42125 | 11822 | 190 |
951970 | 951970 | 2021-01-21 | Washington | Pennsylvania | 42125 | 11771 | 181 |
948725 | 948725 | 2021-01-20 | Washington | Pennsylvania | 42125 | 11667 | 178 |
945479 | 945479 | 2021-01-19 | Washington | Pennsylvania | 42125 | 11556 | 172 |
942232 | 942232 | 2021-01-18 | Washington | Pennsylvania | 42125 | 11448 | 171 |
938987 | 938987 | 2021-01-17 | Washington | Pennsylvania | 42125 | 11384 | 170 |
935742 | 935742 | 2021-01-16 | Washington | Pennsylvania | 42125 | 11260 | 168 |
932497 | 932497 | 2021-01-15 | Washington | Pennsylvania | 42125 | 11148 | 168 |
929252 | 929252 | 2021-01-14 | Washington | Pennsylvania | 42125 | 11028 | 166 |
926007 | 926007 | 2021-01-13 | Washington | Pennsylvania | 42125 | 10831 | 165 |
922761 | 922761 | 2021-01-12 | Washington | Pennsylvania | 42125 | 10648 | 164 |
919516 | 919516 | 2021-01-11 | Washington | Pennsylvania | 42125 | 10515 | 157 |
916271 | 916271 | 2021-01-10 | Washington | Pennsylvania | 42125 | 10433 | 156 |
913026 | 913026 | 2021-01-09 | Washington | Pennsylvania | 42125 | 10353 | 156 |
909781 | 909781 | 2021-01-08 | Washington | Pennsylvania | 42125 | 10121 | 152 |
906536 | 906536 | 2021-01-07 | Washington | Pennsylvania | 42125 | 9900 | 148 |
903290 | 903290 | 2021-01-06 | Washington | Pennsylvania | 42125 | 9774 | 144 |
900045 | 900045 | 2021-01-05 | Washington | Pennsylvania | 42125 | 9567 | 138 |
896800 | 896800 | 2021-01-04 | Washington | Pennsylvania | 42125 | 9462 | 138 |
893554 | 893554 | 2021-01-03 | Washington | Pennsylvania | 42125 | 9345 | 137 |
890308 | 890308 | 2021-01-02 | Washington | Pennsylvania | 42125 | 9278 | 136 |
887061 | 887061 | 2021-01-01 | Washington | Pennsylvania | 42125 | 9084 | 135 |
883816 | 883816 | 2020-12-31 | Washington | Pennsylvania | 42125 | 8947 | 131 |
880571 | 880571 | 2020-12-30 | Washington | Pennsylvania | 42125 | 8798 | 128 |
877326 | 877326 | 2020-12-29 | Washington | Pennsylvania | 42125 | 8727 | 122 |
874081 | 874081 | 2020-12-28 | Washington | Pennsylvania | 42125 | 8438 | 122 |
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);