ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Beaver" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1078489 | 1078489 | 2021-03-01 | Beaver | Pennsylvania | 42007 | 12266 | 349 |
1075244 | 1075244 | 2021-02-28 | Beaver | Pennsylvania | 42007 | 12247 | 349 |
1071998 | 1071998 | 2021-02-27 | Beaver | Pennsylvania | 42007 | 12223 | 347 |
1068752 | 1068752 | 2021-02-26 | Beaver | Pennsylvania | 42007 | 12177 | 347 |
1065507 | 1065507 | 2021-02-25 | Beaver | Pennsylvania | 42007 | 12140 | 346 |
1062262 | 1062262 | 2021-02-24 | Beaver | Pennsylvania | 42007 | 12110 | 345 |
1059017 | 1059017 | 2021-02-23 | Beaver | Pennsylvania | 42007 | 12067 | 343 |
1055771 | 1055771 | 2021-02-22 | Beaver | Pennsylvania | 42007 | 11997 | 342 |
1052525 | 1052525 | 2021-02-21 | Beaver | Pennsylvania | 42007 | 11981 | 342 |
1049278 | 1049278 | 2021-02-20 | Beaver | Pennsylvania | 42007 | 11945 | 342 |
1046031 | 1046031 | 2021-02-19 | Beaver | Pennsylvania | 42007 | 11884 | 342 |
1042786 | 1042786 | 2021-02-18 | Beaver | Pennsylvania | 42007 | 11825 | 341 |
1039541 | 1039541 | 2021-02-17 | Beaver | Pennsylvania | 42007 | 11783 | 340 |
1036296 | 1036296 | 2021-02-16 | Beaver | Pennsylvania | 42007 | 11719 | 340 |
1033051 | 1033051 | 2021-02-15 | Beaver | Pennsylvania | 42007 | 11670 | 340 |
1029805 | 1029805 | 2021-02-14 | Beaver | Pennsylvania | 42007 | 11633 | 339 |
1026558 | 1026558 | 2021-02-13 | Beaver | Pennsylvania | 42007 | 11623 | 338 |
1023313 | 1023313 | 2021-02-12 | Beaver | Pennsylvania | 42007 | 11558 | 336 |
1020068 | 1020068 | 2021-02-11 | Beaver | Pennsylvania | 42007 | 11520 | 333 |
1016823 | 1016823 | 2021-02-10 | Beaver | Pennsylvania | 42007 | 11441 | 332 |
1013578 | 1013578 | 2021-02-09 | Beaver | Pennsylvania | 42007 | 11389 | 331 |
1010333 | 1010333 | 2021-02-08 | Beaver | Pennsylvania | 42007 | 11315 | 329 |
1007087 | 1007087 | 2021-02-07 | Beaver | Pennsylvania | 42007 | 11294 | 330 |
1003841 | 1003841 | 2021-02-06 | Beaver | Pennsylvania | 42007 | 11265 | 329 |
1000595 | 1000595 | 2021-02-05 | Beaver | Pennsylvania | 42007 | 11239 | 328 |
997349 | 997349 | 2021-02-04 | Beaver | Pennsylvania | 42007 | 11181 | 326 |
994103 | 994103 | 2021-02-03 | Beaver | Pennsylvania | 42007 | 11114 | 325 |
990857 | 990857 | 2021-02-02 | Beaver | Pennsylvania | 42007 | 11057 | 323 |
987611 | 987611 | 2021-02-01 | Beaver | Pennsylvania | 42007 | 11019 | 323 |
984364 | 984364 | 2021-01-31 | Beaver | Pennsylvania | 42007 | 10985 | 322 |
981117 | 981117 | 2021-01-30 | Beaver | Pennsylvania | 42007 | 10943 | 321 |
977871 | 977871 | 2021-01-29 | Beaver | Pennsylvania | 42007 | 10890 | 318 |
974626 | 974626 | 2021-01-28 | Beaver | Pennsylvania | 42007 | 10833 | 316 |
971381 | 971381 | 2021-01-27 | Beaver | Pennsylvania | 42007 | 10759 | 314 |
968136 | 968136 | 2021-01-26 | Beaver | Pennsylvania | 42007 | 10673 | 313 |
964892 | 964892 | 2021-01-25 | Beaver | Pennsylvania | 42007 | 10649 | 310 |
961647 | 961647 | 2021-01-24 | Beaver | Pennsylvania | 42007 | 10609 | 308 |
958402 | 958402 | 2021-01-23 | Beaver | Pennsylvania | 42007 | 10578 | 306 |
955156 | 955156 | 2021-01-22 | Beaver | Pennsylvania | 42007 | 10531 | 304 |
951911 | 951911 | 2021-01-21 | Beaver | Pennsylvania | 42007 | 10470 | 302 |
948666 | 948666 | 2021-01-20 | Beaver | Pennsylvania | 42007 | 10426 | 297 |
945420 | 945420 | 2021-01-19 | Beaver | Pennsylvania | 42007 | 10330 | 295 |
942173 | 942173 | 2021-01-18 | Beaver | Pennsylvania | 42007 | 10273 | 294 |
938928 | 938928 | 2021-01-17 | Beaver | Pennsylvania | 42007 | 10233 | 294 |
935683 | 935683 | 2021-01-16 | Beaver | Pennsylvania | 42007 | 10171 | 291 |
932438 | 932438 | 2021-01-15 | Beaver | Pennsylvania | 42007 | 10051 | 290 |
929193 | 929193 | 2021-01-14 | Beaver | Pennsylvania | 42007 | 9939 | 288 |
925948 | 925948 | 2021-01-13 | Beaver | Pennsylvania | 42007 | 9854 | 283 |
922702 | 922702 | 2021-01-12 | Beaver | Pennsylvania | 42007 | 9749 | 281 |
919457 | 919457 | 2021-01-11 | Beaver | Pennsylvania | 42007 | 9621 | 276 |
916212 | 916212 | 2021-01-10 | Beaver | Pennsylvania | 42007 | 9560 | 275 |
912967 | 912967 | 2021-01-09 | Beaver | Pennsylvania | 42007 | 9483 | 274 |
909722 | 909722 | 2021-01-08 | Beaver | Pennsylvania | 42007 | 9353 | 271 |
906477 | 906477 | 2021-01-07 | Beaver | Pennsylvania | 42007 | 9185 | 269 |
903231 | 903231 | 2021-01-06 | Beaver | Pennsylvania | 42007 | 9069 | 266 |
899986 | 899986 | 2021-01-05 | Beaver | Pennsylvania | 42007 | 8902 | 262 |
896741 | 896741 | 2021-01-04 | Beaver | Pennsylvania | 42007 | 8813 | 260 |
893495 | 893495 | 2021-01-03 | Beaver | Pennsylvania | 42007 | 8751 | 260 |
890249 | 890249 | 2021-01-02 | Beaver | Pennsylvania | 42007 | 8707 | 257 |
887002 | 887002 | 2021-01-01 | Beaver | Pennsylvania | 42007 | 8504 | 256 |
883757 | 883757 | 2020-12-31 | Beaver | Pennsylvania | 42007 | 8433 | 252 |
880512 | 880512 | 2020-12-30 | Beaver | Pennsylvania | 42007 | 8294 | 250 |
877267 | 877267 | 2020-12-29 | Beaver | Pennsylvania | 42007 | 8159 | 242 |
874022 | 874022 | 2020-12-28 | Beaver | Pennsylvania | 42007 | 7991 | 238 |
870777 | 870777 | 2020-12-27 | Beaver | Pennsylvania | 42007 | 7979 | 237 |
867532 | 867532 | 2020-12-26 | Beaver | Pennsylvania | 42007 | 7960 | 235 |
864287 | 864287 | 2020-12-25 | Beaver | Pennsylvania | 42007 | 7898 | 234 |
861042 | 861042 | 2020-12-24 | Beaver | Pennsylvania | 42007 | 7808 | 232 |
857797 | 857797 | 2020-12-23 | Beaver | Pennsylvania | 42007 | 7702 | 227 |
854552 | 854552 | 2020-12-22 | Beaver | Pennsylvania | 42007 | 7514 | 224 |
851307 | 851307 | 2020-12-21 | Beaver | Pennsylvania | 42007 | 7388 | 218 |
848062 | 848062 | 2020-12-20 | Beaver | Pennsylvania | 42007 | 7294 | 217 |
844817 | 844817 | 2020-12-19 | Beaver | Pennsylvania | 42007 | 7206 | 215 |
841571 | 841571 | 2020-12-18 | Beaver | Pennsylvania | 42007 | 7041 | 208 |
838326 | 838326 | 2020-12-17 | Beaver | Pennsylvania | 42007 | 6894 | 206 |
835080 | 835080 | 2020-12-16 | Beaver | Pennsylvania | 42007 | 6593 | 203 |
831834 | 831834 | 2020-12-15 | Beaver | Pennsylvania | 42007 | 6396 | 197 |
828587 | 828587 | 2020-12-14 | Beaver | Pennsylvania | 42007 | 6256 | 192 |
825341 | 825341 | 2020-12-13 | Beaver | Pennsylvania | 42007 | 6171 | 190 |
822094 | 822094 | 2020-12-12 | Beaver | Pennsylvania | 42007 | 6052 | 189 |
818848 | 818848 | 2020-12-11 | Beaver | Pennsylvania | 42007 | 5725 | 187 |
815602 | 815602 | 2020-12-10 | Beaver | Pennsylvania | 42007 | 5513 | 183 |
812356 | 812356 | 2020-12-09 | Beaver | Pennsylvania | 42007 | 5306 | 179 |
809112 | 809112 | 2020-12-08 | Beaver | Pennsylvania | 42007 | 5119 | 177 |
805867 | 805867 | 2020-12-07 | Beaver | Pennsylvania | 42007 | 5036 | 170 |
802622 | 802622 | 2020-12-06 | Beaver | Pennsylvania | 42007 | 4960 | 169 |
799377 | 799377 | 2020-12-05 | Beaver | Pennsylvania | 42007 | 4843 | 166 |
796132 | 796132 | 2020-12-04 | Beaver | Pennsylvania | 42007 | 4554 | 163 |
792887 | 792887 | 2020-12-03 | Beaver | Pennsylvania | 42007 | 4422 | 160 |
789642 | 789642 | 2020-12-02 | Beaver | Pennsylvania | 42007 | 4218 | 156 |
786397 | 786397 | 2020-12-01 | Beaver | Pennsylvania | 42007 | 4127 | 156 |
783153 | 783153 | 2020-11-30 | Beaver | Pennsylvania | 42007 | 4024 | 156 |
779908 | 779908 | 2020-11-29 | Beaver | Pennsylvania | 42007 | 3991 | 156 |
776662 | 776662 | 2020-11-28 | Beaver | Pennsylvania | 42007 | 3886 | 156 |
773417 | 773417 | 2020-11-27 | Beaver | Pennsylvania | 42007 | 3785 | 156 |
770172 | 770172 | 2020-11-26 | Beaver | Pennsylvania | 42007 | 3659 | 156 |
766926 | 766926 | 2020-11-25 | Beaver | Pennsylvania | 42007 | 3561 | 154 |
763681 | 763681 | 2020-11-24 | Beaver | Pennsylvania | 42007 | 3441 | 151 |
760436 | 760436 | 2020-11-23 | Beaver | Pennsylvania | 42007 | 3366 | 149 |
757191 | 757191 | 2020-11-22 | Beaver | Pennsylvania | 42007 | 3308 | 147 |
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);