ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 42129 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388241 | 388241 | 2020-07-31 | Westmoreland | Pennsylvania | 42129 | 1409 | 46 |
385024 | 385024 | 2020-07-30 | Westmoreland | Pennsylvania | 42129 | 1382 | 45 |
381806 | 381806 | 2020-07-29 | Westmoreland | Pennsylvania | 42129 | 1351 | 45 |
378589 | 378589 | 2020-07-28 | Westmoreland | Pennsylvania | 42129 | 1327 | 44 |
375373 | 375373 | 2020-07-27 | Westmoreland | Pennsylvania | 42129 | 1313 | 43 |
372160 | 372160 | 2020-07-26 | Westmoreland | Pennsylvania | 42129 | 1302 | 43 |
368948 | 368948 | 2020-07-25 | Westmoreland | Pennsylvania | 42129 | 1271 | 43 |
365739 | 365739 | 2020-07-24 | Westmoreland | Pennsylvania | 42129 | 1252 | 42 |
362533 | 362533 | 2020-07-23 | Westmoreland | Pennsylvania | 42129 | 1234 | 41 |
359327 | 359327 | 2020-07-22 | Westmoreland | Pennsylvania | 42129 | 1214 | 41 |
356123 | 356123 | 2020-07-21 | Westmoreland | Pennsylvania | 42129 | 1193 | 40 |
352920 | 352920 | 2020-07-20 | Westmoreland | Pennsylvania | 42129 | 1174 | 40 |
349717 | 349717 | 2020-07-19 | Westmoreland | Pennsylvania | 42129 | 1153 | 40 |
346517 | 346517 | 2020-07-18 | Westmoreland | Pennsylvania | 42129 | 1135 | 40 |
343317 | 343317 | 2020-07-17 | Westmoreland | Pennsylvania | 42129 | 1117 | 40 |
340119 | 340119 | 2020-07-16 | Westmoreland | Pennsylvania | 42129 | 1089 | 40 |
336922 | 336922 | 2020-07-15 | Westmoreland | Pennsylvania | 42129 | 1054 | 39 |
333728 | 333728 | 2020-07-14 | Westmoreland | Pennsylvania | 42129 | 1033 | 39 |
330536 | 330536 | 2020-07-13 | Westmoreland | Pennsylvania | 42129 | 1010 | 39 |
327350 | 327350 | 2020-07-12 | Westmoreland | Pennsylvania | 42129 | 994 | 39 |
324165 | 324165 | 2020-07-11 | Westmoreland | Pennsylvania | 42129 | 975 | 39 |
320985 | 320985 | 2020-07-10 | Westmoreland | Pennsylvania | 42129 | 952 | 39 |
317807 | 317807 | 2020-07-09 | Westmoreland | Pennsylvania | 42129 | 917 | 39 |
314634 | 314634 | 2020-07-08 | Westmoreland | Pennsylvania | 42129 | 896 | 39 |
311462 | 311462 | 2020-07-07 | Westmoreland | Pennsylvania | 42129 | 863 | 39 |
308293 | 308293 | 2020-07-06 | Westmoreland | Pennsylvania | 42129 | 828 | 38 |
305126 | 305126 | 2020-07-05 | Westmoreland | Pennsylvania | 42129 | 801 | 38 |
301963 | 301963 | 2020-07-04 | Westmoreland | Pennsylvania | 42129 | 774 | 38 |
298799 | 298799 | 2020-07-03 | Westmoreland | Pennsylvania | 42129 | 744 | 38 |
295640 | 295640 | 2020-07-02 | Westmoreland | Pennsylvania | 42129 | 711 | 38 |
292484 | 292484 | 2020-07-01 | Westmoreland | Pennsylvania | 42129 | 675 | 38 |
289332 | 289332 | 2020-06-30 | Westmoreland | Pennsylvania | 42129 | 646 | 38 |
286181 | 286181 | 2020-06-29 | Westmoreland | Pennsylvania | 42129 | 640 | 38 |
283036 | 283036 | 2020-06-28 | Westmoreland | Pennsylvania | 42129 | 620 | 38 |
279890 | 279890 | 2020-06-27 | Westmoreland | Pennsylvania | 42129 | 607 | 38 |
276742 | 276742 | 2020-06-26 | Westmoreland | Pennsylvania | 42129 | 587 | 38 |
273595 | 273595 | 2020-06-25 | Westmoreland | Pennsylvania | 42129 | 578 | 38 |
270456 | 270456 | 2020-06-24 | Westmoreland | Pennsylvania | 42129 | 563 | 38 |
267322 | 267322 | 2020-06-23 | Westmoreland | Pennsylvania | 42129 | 552 | 38 |
264194 | 264194 | 2020-06-22 | Westmoreland | Pennsylvania | 42129 | 546 | 38 |
261066 | 261066 | 2020-06-21 | Westmoreland | Pennsylvania | 42129 | 530 | 38 |
257939 | 257939 | 2020-06-20 | Westmoreland | Pennsylvania | 42129 | 519 | 38 |
254813 | 254813 | 2020-06-19 | Westmoreland | Pennsylvania | 42129 | 510 | 38 |
251698 | 251698 | 2020-06-18 | Westmoreland | Pennsylvania | 42129 | 502 | 38 |
248583 | 248583 | 2020-06-17 | Westmoreland | Pennsylvania | 42129 | 498 | 38 |
245470 | 245470 | 2020-06-16 | Westmoreland | Pennsylvania | 42129 | 493 | 38 |
242358 | 242358 | 2020-06-15 | Westmoreland | Pennsylvania | 42129 | 492 | 38 |
239249 | 239249 | 2020-06-14 | Westmoreland | Pennsylvania | 42129 | 490 | 38 |
236141 | 236141 | 2020-06-13 | Westmoreland | Pennsylvania | 42129 | 487 | 38 |
233036 | 233036 | 2020-06-12 | Westmoreland | Pennsylvania | 42129 | 483 | 38 |
229931 | 229931 | 2020-06-11 | Westmoreland | Pennsylvania | 42129 | 474 | 38 |
226827 | 226827 | 2020-06-10 | Westmoreland | Pennsylvania | 42129 | 473 | 38 |
223727 | 223727 | 2020-06-09 | Westmoreland | Pennsylvania | 42129 | 467 | 38 |
220632 | 220632 | 2020-06-08 | Westmoreland | Pennsylvania | 42129 | 461 | 38 |
217540 | 217540 | 2020-06-07 | Westmoreland | Pennsylvania | 42129 | 459 | 38 |
214450 | 214450 | 2020-06-06 | Westmoreland | Pennsylvania | 42129 | 457 | 38 |
211364 | 211364 | 2020-06-05 | Westmoreland | Pennsylvania | 42129 | 456 | 38 |
208282 | 208282 | 2020-06-04 | Westmoreland | Pennsylvania | 42129 | 455 | 38 |
205201 | 205201 | 2020-06-03 | Westmoreland | Pennsylvania | 42129 | 453 | 38 |
202124 | 202124 | 2020-06-02 | Westmoreland | Pennsylvania | 42129 | 451 | 38 |
199049 | 199049 | 2020-06-01 | Westmoreland | Pennsylvania | 42129 | 449 | 38 |
195976 | 195976 | 2020-05-31 | Westmoreland | Pennsylvania | 42129 | 449 | 38 |
192907 | 192907 | 2020-05-30 | Westmoreland | Pennsylvania | 42129 | 447 | 38 |
189842 | 189842 | 2020-05-29 | Westmoreland | Pennsylvania | 42129 | 444 | 38 |
186781 | 186781 | 2020-05-28 | Westmoreland | Pennsylvania | 42129 | 443 | 38 |
183724 | 183724 | 2020-05-27 | Westmoreland | Pennsylvania | 42129 | 442 | 38 |
180674 | 180674 | 2020-05-26 | Westmoreland | Pennsylvania | 42129 | 442 | 38 |
177631 | 177631 | 2020-05-25 | Westmoreland | Pennsylvania | 42129 | 441 | 38 |
174587 | 174587 | 2020-05-24 | Westmoreland | Pennsylvania | 42129 | 440 | 38 |
171545 | 171545 | 2020-05-23 | Westmoreland | Pennsylvania | 42129 | 437 | 38 |
168506 | 168506 | 2020-05-22 | Westmoreland | Pennsylvania | 42129 | 436 | 38 |
165470 | 165470 | 2020-05-21 | Westmoreland | Pennsylvania | 42129 | 434 | 38 |
162441 | 162441 | 2020-05-20 | Westmoreland | Pennsylvania | 42129 | 432 | 38 |
159414 | 159414 | 2020-05-19 | Westmoreland | Pennsylvania | 42129 | 431 | 32 |
156393 | 156393 | 2020-05-18 | Westmoreland | Pennsylvania | 42129 | 432 | 32 |
153376 | 153376 | 2020-05-17 | Westmoreland | Pennsylvania | 42129 | 427 | 32 |
150365 | 150365 | 2020-05-16 | Westmoreland | Pennsylvania | 42129 | 423 | 32 |
147358 | 147358 | 2020-05-15 | Westmoreland | Pennsylvania | 42129 | 423 | 32 |
144357 | 144357 | 2020-05-14 | Westmoreland | Pennsylvania | 42129 | 422 | 32 |
141361 | 141361 | 2020-05-13 | Westmoreland | Pennsylvania | 42129 | 419 | 32 |
138365 | 138365 | 2020-05-12 | Westmoreland | Pennsylvania | 42129 | 419 | 32 |
135375 | 135375 | 2020-05-11 | Westmoreland | Pennsylvania | 42129 | 418 | 32 |
132384 | 132384 | 2020-05-10 | Westmoreland | Pennsylvania | 42129 | 417 | 32 |
129395 | 129395 | 2020-05-09 | Westmoreland | Pennsylvania | 42129 | 415 | 32 |
126406 | 126406 | 2020-05-08 | Westmoreland | Pennsylvania | 42129 | 413 | 32 |
123423 | 123423 | 2020-05-07 | Westmoreland | Pennsylvania | 42129 | 411 | 32 |
120446 | 120446 | 2020-05-06 | Westmoreland | Pennsylvania | 42129 | 409 | 31 |
117484 | 117484 | 2020-05-05 | Westmoreland | Pennsylvania | 42129 | 405 | 31 |
114603 | 114603 | 2020-05-04 | Westmoreland | Pennsylvania | 42129 | 403 | 31 |
111721 | 111721 | 2020-05-03 | Westmoreland | Pennsylvania | 42129 | 401 | 30 |
108847 | 108847 | 2020-05-02 | Westmoreland | Pennsylvania | 42129 | 396 | 30 |
105980 | 105980 | 2020-05-01 | Westmoreland | Pennsylvania | 42129 | 393 | 30 |
103117 | 103117 | 2020-04-30 | Westmoreland | Pennsylvania | 42129 | 391 | 30 |
100264 | 100264 | 2020-04-29 | Westmoreland | Pennsylvania | 42129 | 386 | 30 |
97415 | 97415 | 2020-04-28 | Westmoreland | Pennsylvania | 42129 | 383 | 30 |
94576 | 94576 | 2020-04-27 | Westmoreland | Pennsylvania | 42129 | 377 | 30 |
91749 | 91749 | 2020-04-26 | Westmoreland | Pennsylvania | 42129 | 374 | 27 |
88933 | 88933 | 2020-04-25 | Westmoreland | Pennsylvania | 42129 | 360 | 27 |
86119 | 86119 | 2020-04-24 | Westmoreland | Pennsylvania | 42129 | 317 | 27 |
83315 | 83315 | 2020-04-23 | Westmoreland | Pennsylvania | 42129 | 307 | 27 |
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);