ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42133 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
276744 | 276744 | 2020-06-26 | York | Pennsylvania | 42133 | 1428 | 43 |
279892 | 279892 | 2020-06-27 | York | Pennsylvania | 42133 | 1443 | 44 |
283038 | 283038 | 2020-06-28 | York | Pennsylvania | 42133 | 1456 | 44 |
286183 | 286183 | 2020-06-29 | York | Pennsylvania | 42133 | 1477 | 45 |
289334 | 289334 | 2020-06-30 | York | Pennsylvania | 42133 | 1515 | 48 |
292486 | 292486 | 2020-07-01 | York | Pennsylvania | 42133 | 1531 | 48 |
295642 | 295642 | 2020-07-02 | York | Pennsylvania | 42133 | 1555 | 52 |
298801 | 298801 | 2020-07-03 | York | Pennsylvania | 42133 | 1577 | 54 |
301965 | 301965 | 2020-07-04 | York | Pennsylvania | 42133 | 1595 | 54 |
305128 | 305128 | 2020-07-05 | York | Pennsylvania | 42133 | 1609 | 54 |
308295 | 308295 | 2020-07-06 | York | Pennsylvania | 42133 | 1613 | 54 |
311464 | 311464 | 2020-07-07 | York | Pennsylvania | 42133 | 1654 | 55 |
314636 | 314636 | 2020-07-08 | York | Pennsylvania | 42133 | 1692 | 57 |
317809 | 317809 | 2020-07-09 | York | Pennsylvania | 42133 | 1714 | 57 |
320987 | 320987 | 2020-07-10 | York | Pennsylvania | 42133 | 1791 | 61 |
324167 | 324167 | 2020-07-11 | York | Pennsylvania | 42133 | 1830 | 62 |
327352 | 327352 | 2020-07-12 | York | Pennsylvania | 42133 | 1850 | 63 |
330538 | 330538 | 2020-07-13 | York | Pennsylvania | 42133 | 1858 | 63 |
333730 | 333730 | 2020-07-14 | York | Pennsylvania | 42133 | 1872 | 63 |
336924 | 336924 | 2020-07-15 | York | Pennsylvania | 42133 | 1908 | 66 |
340121 | 340121 | 2020-07-16 | York | Pennsylvania | 42133 | 1942 | 67 |
343319 | 343319 | 2020-07-17 | York | Pennsylvania | 42133 | 1963 | 70 |
346519 | 346519 | 2020-07-18 | York | Pennsylvania | 42133 | 1975 | 72 |
349719 | 349719 | 2020-07-19 | York | Pennsylvania | 42133 | 1985 | 72 |
352922 | 352922 | 2020-07-20 | York | Pennsylvania | 42133 | 2006 | 72 |
356125 | 356125 | 2020-07-21 | York | Pennsylvania | 42133 | 2052 | 74 |
359329 | 359329 | 2020-07-22 | York | Pennsylvania | 42133 | 2067 | 76 |
362535 | 362535 | 2020-07-23 | York | Pennsylvania | 42133 | 2098 | 78 |
365741 | 365741 | 2020-07-24 | York | Pennsylvania | 42133 | 2119 | 79 |
368950 | 368950 | 2020-07-25 | York | Pennsylvania | 42133 | 2152 | 80 |
372162 | 372162 | 2020-07-26 | York | Pennsylvania | 42133 | 2161 | 80 |
375375 | 375375 | 2020-07-27 | York | Pennsylvania | 42133 | 2182 | 81 |
378591 | 378591 | 2020-07-28 | York | Pennsylvania | 42133 | 2196 | 84 |
381808 | 381808 | 2020-07-29 | York | Pennsylvania | 42133 | 2223 | 84 |
385026 | 385026 | 2020-07-30 | York | Pennsylvania | 42133 | 2243 | 85 |
388243 | 388243 | 2020-07-31 | York | Pennsylvania | 42133 | 2269 | 86 |
391460 | 391460 | 2020-08-01 | York | Pennsylvania | 42133 | 2286 | 87 |
394676 | 394676 | 2020-08-02 | York | Pennsylvania | 42133 | 2325 | 88 |
397893 | 397893 | 2020-08-03 | York | Pennsylvania | 42133 | 2350 | 88 |
401108 | 401108 | 2020-08-04 | York | Pennsylvania | 42133 | 2365 | 89 |
404326 | 404326 | 2020-08-05 | York | Pennsylvania | 42133 | 2400 | 89 |
407545 | 407545 | 2020-08-06 | York | Pennsylvania | 42133 | 2444 | 92 |
410765 | 410765 | 2020-08-07 | York | Pennsylvania | 42133 | 2485 | 93 |
413985 | 413985 | 2020-08-08 | York | Pennsylvania | 42133 | 2501 | 93 |
417206 | 417206 | 2020-08-09 | York | Pennsylvania | 42133 | 2572 | 93 |
420426 | 420426 | 2020-08-10 | York | Pennsylvania | 42133 | 2591 | 93 |
423649 | 423649 | 2020-08-11 | York | Pennsylvania | 42133 | 2637 | 94 |
426872 | 426872 | 2020-08-12 | York | Pennsylvania | 42133 | 2680 | 97 |
430097 | 430097 | 2020-08-13 | York | Pennsylvania | 42133 | 2751 | 100 |
433323 | 433323 | 2020-08-14 | York | Pennsylvania | 42133 | 2801 | 105 |
436550 | 436550 | 2020-08-15 | York | Pennsylvania | 42133 | 2854 | 105 |
439775 | 439775 | 2020-08-16 | York | Pennsylvania | 42133 | 2884 | 105 |
443002 | 443002 | 2020-08-17 | York | Pennsylvania | 42133 | 2907 | 105 |
446228 | 446228 | 2020-08-18 | York | Pennsylvania | 42133 | 2929 | 108 |
449456 | 449456 | 2020-08-19 | York | Pennsylvania | 42133 | 2966 | 110 |
452684 | 452684 | 2020-08-20 | York | Pennsylvania | 42133 | 3011 | 111 |
455912 | 455912 | 2020-08-21 | York | Pennsylvania | 42133 | 3038 | 112 |
459140 | 459140 | 2020-08-22 | York | Pennsylvania | 42133 | 3086 | 114 |
462368 | 462368 | 2020-08-23 | York | Pennsylvania | 42133 | 3119 | 114 |
465597 | 465597 | 2020-08-24 | York | Pennsylvania | 42133 | 3136 | 114 |
468825 | 468825 | 2020-08-25 | York | Pennsylvania | 42133 | 3158 | 116 |
472057 | 472057 | 2020-08-26 | York | Pennsylvania | 42133 | 3189 | 116 |
475291 | 475291 | 2020-08-27 | York | Pennsylvania | 42133 | 3232 | 117 |
478524 | 478524 | 2020-08-28 | York | Pennsylvania | 42133 | 3269 | 118 |
481758 | 481758 | 2020-08-29 | York | Pennsylvania | 42133 | 3301 | 122 |
484993 | 484993 | 2020-08-30 | York | Pennsylvania | 42133 | 3328 | 122 |
488226 | 488226 | 2020-08-31 | York | Pennsylvania | 42133 | 3368 | 122 |
491459 | 491459 | 2020-09-01 | York | Pennsylvania | 42133 | 3442 | 123 |
494693 | 494693 | 2020-09-02 | York | Pennsylvania | 42133 | 3490 | 127 |
497926 | 497926 | 2020-09-03 | York | Pennsylvania | 42133 | 3618 | 127 |
501160 | 501160 | 2020-09-04 | York | Pennsylvania | 42133 | 3667 | 127 |
504394 | 504394 | 2020-09-05 | York | Pennsylvania | 42133 | 3739 | 130 |
507626 | 507626 | 2020-09-06 | York | Pennsylvania | 42133 | 3773 | 130 |
510859 | 510859 | 2020-09-07 | York | Pennsylvania | 42133 | 3807 | 132 |
514092 | 514092 | 2020-09-08 | York | Pennsylvania | 42133 | 3832 | 132 |
517327 | 517327 | 2020-09-09 | York | Pennsylvania | 42133 | 3889 | 131 |
520563 | 520563 | 2020-09-10 | York | Pennsylvania | 42133 | 3929 | 132 |
523799 | 523799 | 2020-09-11 | York | Pennsylvania | 42133 | 3995 | 132 |
527035 | 527035 | 2020-09-12 | York | Pennsylvania | 42133 | 4124 | 132 |
530272 | 530272 | 2020-09-13 | York | Pennsylvania | 42133 | 4124 | 132 |
533507 | 533507 | 2020-09-14 | York | Pennsylvania | 42133 | 4216 | 134 |
536743 | 536743 | 2020-09-15 | York | Pennsylvania | 42133 | 4258 | 134 |
539980 | 539980 | 2020-09-16 | York | Pennsylvania | 42133 | 4333 | 135 |
543216 | 543216 | 2020-09-17 | York | Pennsylvania | 42133 | 4361 | 136 |
546453 | 546453 | 2020-09-18 | York | Pennsylvania | 42133 | 4391 | 138 |
549692 | 549692 | 2020-09-19 | York | Pennsylvania | 42133 | 4453 | 141 |
552931 | 552931 | 2020-09-20 | York | Pennsylvania | 42133 | 4490 | 142 |
556168 | 556168 | 2020-09-21 | York | Pennsylvania | 42133 | 4520 | 142 |
559405 | 559405 | 2020-09-22 | York | Pennsylvania | 42133 | 4554 | 143 |
562642 | 562642 | 2020-09-23 | York | Pennsylvania | 42133 | 4606 | 149 |
565883 | 565883 | 2020-09-24 | York | Pennsylvania | 42133 | 4650 | 152 |
569124 | 569124 | 2020-09-25 | York | Pennsylvania | 42133 | 4752 | 153 |
572366 | 572366 | 2020-09-26 | York | Pennsylvania | 42133 | 4784 | 156 |
575610 | 575610 | 2020-09-27 | York | Pennsylvania | 42133 | 4828 | 156 |
578851 | 578851 | 2020-09-28 | York | Pennsylvania | 42133 | 4851 | 156 |
582091 | 582091 | 2020-09-29 | York | Pennsylvania | 42133 | 4891 | 158 |
585331 | 585331 | 2020-09-30 | York | Pennsylvania | 42133 | 4941 | 159 |
588571 | 588571 | 2020-10-01 | York | Pennsylvania | 42133 | 4971 | 159 |
591812 | 591812 | 2020-10-02 | York | Pennsylvania | 42133 | 5008 | 161 |
595053 | 595053 | 2020-10-03 | York | Pennsylvania | 42133 | 5008 | 164 |
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);