ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 42007 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388180 | 388180 | 2020-07-31 | Beaver | Pennsylvania | 42007 | 1212 | 88 |
384963 | 384963 | 2020-07-30 | Beaver | Pennsylvania | 42007 | 1189 | 88 |
381745 | 381745 | 2020-07-29 | Beaver | Pennsylvania | 42007 | 1176 | 85 |
378528 | 378528 | 2020-07-28 | Beaver | Pennsylvania | 42007 | 1164 | 85 |
375312 | 375312 | 2020-07-27 | Beaver | Pennsylvania | 42007 | 1127 | 82 |
372099 | 372099 | 2020-07-26 | Beaver | Pennsylvania | 42007 | 1116 | 82 |
368887 | 368887 | 2020-07-25 | Beaver | Pennsylvania | 42007 | 1101 | 82 |
365678 | 365678 | 2020-07-24 | Beaver | Pennsylvania | 42007 | 1084 | 82 |
362472 | 362472 | 2020-07-23 | Beaver | Pennsylvania | 42007 | 1053 | 82 |
359266 | 359266 | 2020-07-22 | Beaver | Pennsylvania | 42007 | 1046 | 82 |
356062 | 356062 | 2020-07-21 | Beaver | Pennsylvania | 42007 | 1011 | 81 |
352859 | 352859 | 2020-07-20 | Beaver | Pennsylvania | 42007 | 968 | 81 |
349656 | 349656 | 2020-07-19 | Beaver | Pennsylvania | 42007 | 958 | 81 |
346456 | 346456 | 2020-07-18 | Beaver | Pennsylvania | 42007 | 949 | 81 |
343256 | 343256 | 2020-07-17 | Beaver | Pennsylvania | 42007 | 918 | 81 |
340058 | 340058 | 2020-07-16 | Beaver | Pennsylvania | 42007 | 893 | 80 |
336861 | 336861 | 2020-07-15 | Beaver | Pennsylvania | 42007 | 884 | 79 |
333667 | 333667 | 2020-07-14 | Beaver | Pennsylvania | 42007 | 870 | 79 |
330475 | 330475 | 2020-07-13 | Beaver | Pennsylvania | 42007 | 845 | 79 |
327289 | 327289 | 2020-07-12 | Beaver | Pennsylvania | 42007 | 837 | 79 |
324104 | 324104 | 2020-07-11 | Beaver | Pennsylvania | 42007 | 823 | 79 |
320924 | 320924 | 2020-07-10 | Beaver | Pennsylvania | 42007 | 809 | 79 |
317746 | 317746 | 2020-07-09 | Beaver | Pennsylvania | 42007 | 796 | 79 |
314573 | 314573 | 2020-07-08 | Beaver | Pennsylvania | 42007 | 785 | 79 |
311401 | 311401 | 2020-07-07 | Beaver | Pennsylvania | 42007 | 770 | 79 |
308232 | 308232 | 2020-07-06 | Beaver | Pennsylvania | 42007 | 742 | 79 |
305065 | 305065 | 2020-07-05 | Beaver | Pennsylvania | 42007 | 737 | 79 |
301902 | 301902 | 2020-07-04 | Beaver | Pennsylvania | 42007 | 720 | 79 |
298738 | 298738 | 2020-07-03 | Beaver | Pennsylvania | 42007 | 706 | 79 |
295579 | 295579 | 2020-07-02 | Beaver | Pennsylvania | 42007 | 688 | 79 |
292423 | 292423 | 2020-07-01 | Beaver | Pennsylvania | 42007 | 678 | 78 |
289271 | 289271 | 2020-06-30 | Beaver | Pennsylvania | 42007 | 669 | 78 |
286120 | 286120 | 2020-06-29 | Beaver | Pennsylvania | 42007 | 651 | 78 |
282975 | 282975 | 2020-06-28 | Beaver | Pennsylvania | 42007 | 648 | 78 |
279829 | 279829 | 2020-06-27 | Beaver | Pennsylvania | 42007 | 642 | 78 |
276681 | 276681 | 2020-06-26 | Beaver | Pennsylvania | 42007 | 638 | 78 |
273534 | 273534 | 2020-06-25 | Beaver | Pennsylvania | 42007 | 637 | 78 |
270395 | 270395 | 2020-06-24 | Beaver | Pennsylvania | 42007 | 634 | 78 |
267261 | 267261 | 2020-06-23 | Beaver | Pennsylvania | 42007 | 630 | 78 |
264133 | 264133 | 2020-06-22 | Beaver | Pennsylvania | 42007 | 625 | 77 |
261005 | 261005 | 2020-06-21 | Beaver | Pennsylvania | 42007 | 624 | 77 |
257878 | 257878 | 2020-06-20 | Beaver | Pennsylvania | 42007 | 621 | 77 |
254752 | 254752 | 2020-06-19 | Beaver | Pennsylvania | 42007 | 619 | 77 |
251637 | 251637 | 2020-06-18 | Beaver | Pennsylvania | 42007 | 616 | 77 |
248522 | 248522 | 2020-06-17 | Beaver | Pennsylvania | 42007 | 615 | 77 |
245409 | 245409 | 2020-06-16 | Beaver | Pennsylvania | 42007 | 613 | 77 |
242297 | 242297 | 2020-06-15 | Beaver | Pennsylvania | 42007 | 613 | 77 |
239188 | 239188 | 2020-06-14 | Beaver | Pennsylvania | 42007 | 611 | 75 |
236080 | 236080 | 2020-06-13 | Beaver | Pennsylvania | 42007 | 611 | 75 |
232975 | 232975 | 2020-06-12 | Beaver | Pennsylvania | 42007 | 611 | 75 |
229870 | 229870 | 2020-06-11 | Beaver | Pennsylvania | 42007 | 610 | 75 |
226766 | 226766 | 2020-06-10 | Beaver | Pennsylvania | 42007 | 610 | 74 |
223666 | 223666 | 2020-06-09 | Beaver | Pennsylvania | 42007 | 608 | 74 |
220571 | 220571 | 2020-06-08 | Beaver | Pennsylvania | 42007 | 603 | 74 |
217479 | 217479 | 2020-06-07 | Beaver | Pennsylvania | 42007 | 603 | 74 |
214389 | 214389 | 2020-06-06 | Beaver | Pennsylvania | 42007 | 598 | 74 |
211303 | 211303 | 2020-06-05 | Beaver | Pennsylvania | 42007 | 598 | 74 |
208221 | 208221 | 2020-06-04 | Beaver | Pennsylvania | 42007 | 599 | 74 |
205140 | 205140 | 2020-06-03 | Beaver | Pennsylvania | 42007 | 594 | 74 |
202063 | 202063 | 2020-06-02 | Beaver | Pennsylvania | 42007 | 591 | 74 |
198988 | 198988 | 2020-06-01 | Beaver | Pennsylvania | 42007 | 590 | 73 |
195915 | 195915 | 2020-05-31 | Beaver | Pennsylvania | 42007 | 590 | 73 |
192846 | 192846 | 2020-05-30 | Beaver | Pennsylvania | 42007 | 589 | 73 |
189781 | 189781 | 2020-05-29 | Beaver | Pennsylvania | 42007 | 582 | 73 |
186720 | 186720 | 2020-05-28 | Beaver | Pennsylvania | 42007 | 579 | 72 |
183663 | 183663 | 2020-05-27 | Beaver | Pennsylvania | 42007 | 570 | 72 |
180613 | 180613 | 2020-05-26 | Beaver | Pennsylvania | 42007 | 570 | 72 |
177570 | 177570 | 2020-05-25 | Beaver | Pennsylvania | 42007 | 568 | 72 |
174526 | 174526 | 2020-05-24 | Beaver | Pennsylvania | 42007 | 554 | 72 |
171484 | 171484 | 2020-05-23 | Beaver | Pennsylvania | 42007 | 552 | 72 |
168445 | 168445 | 2020-05-22 | Beaver | Pennsylvania | 42007 | 550 | 71 |
165409 | 165409 | 2020-05-21 | Beaver | Pennsylvania | 42007 | 539 | 71 |
162380 | 162380 | 2020-05-20 | Beaver | Pennsylvania | 42007 | 539 | 70 |
159353 | 159353 | 2020-05-19 | Beaver | Pennsylvania | 42007 | 534 | 70 |
156332 | 156332 | 2020-05-18 | Beaver | Pennsylvania | 42007 | 533 | 70 |
153315 | 153315 | 2020-05-17 | Beaver | Pennsylvania | 42007 | 517 | 83 |
150304 | 150304 | 2020-05-16 | Beaver | Pennsylvania | 42007 | 518 | 83 |
147297 | 147297 | 2020-05-15 | Beaver | Pennsylvania | 42007 | 516 | 83 |
144296 | 144296 | 2020-05-14 | Beaver | Pennsylvania | 42007 | 512 | 82 |
141300 | 141300 | 2020-05-13 | Beaver | Pennsylvania | 42007 | 509 | 78 |
138304 | 138304 | 2020-05-12 | Beaver | Pennsylvania | 42007 | 493 | 78 |
135314 | 135314 | 2020-05-11 | Beaver | Pennsylvania | 42007 | 491 | 78 |
132323 | 132323 | 2020-05-10 | Beaver | Pennsylvania | 42007 | 491 | 78 |
129334 | 129334 | 2020-05-09 | Beaver | Pennsylvania | 42007 | 482 | 78 |
126345 | 126345 | 2020-05-08 | Beaver | Pennsylvania | 42007 | 479 | 78 |
123362 | 123362 | 2020-05-07 | Beaver | Pennsylvania | 42007 | 472 | 78 |
120385 | 120385 | 2020-05-06 | Beaver | Pennsylvania | 42007 | 471 | 76 |
117423 | 117423 | 2020-05-05 | Beaver | Pennsylvania | 42007 | 466 | 73 |
114542 | 114542 | 2020-05-04 | Beaver | Pennsylvania | 42007 | 458 | 68 |
111660 | 111660 | 2020-05-03 | Beaver | Pennsylvania | 42007 | 435 | 68 |
108786 | 108786 | 2020-05-02 | Beaver | Pennsylvania | 42007 | 435 | 68 |
105919 | 105919 | 2020-05-01 | Beaver | Pennsylvania | 42007 | 426 | 67 |
103056 | 103056 | 2020-04-30 | Beaver | Pennsylvania | 42007 | 405 | 65 |
100203 | 100203 | 2020-04-29 | Beaver | Pennsylvania | 42007 | 392 | 65 |
97354 | 97354 | 2020-04-28 | Beaver | Pennsylvania | 42007 | 388 | 59 |
94515 | 94515 | 2020-04-27 | Beaver | Pennsylvania | 42007 | 387 | 46 |
91688 | 91688 | 2020-04-26 | Beaver | Pennsylvania | 42007 | 366 | 46 |
88872 | 88872 | 2020-04-25 | Beaver | Pennsylvania | 42007 | 359 | 46 |
86058 | 86058 | 2020-04-24 | Beaver | Pennsylvania | 42007 | 337 | 46 |
83254 | 83254 | 2020-04-23 | Beaver | Pennsylvania | 42007 | 319 | 46 |
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);