ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Northampton" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922746 | 922746 | 2021-01-12 | Northampton | Pennsylvania | 42095 | 19508 | 485 |
919501 | 919501 | 2021-01-11 | Northampton | Pennsylvania | 42095 | 19334 | 481 |
916256 | 916256 | 2021-01-10 | Northampton | Pennsylvania | 42095 | 19205 | 481 |
913011 | 913011 | 2021-01-09 | Northampton | Pennsylvania | 42095 | 18990 | 480 |
909766 | 909766 | 2021-01-08 | Northampton | Pennsylvania | 42095 | 18653 | 473 |
906521 | 906521 | 2021-01-07 | Northampton | Pennsylvania | 42095 | 18331 | 469 |
903275 | 903275 | 2021-01-06 | Northampton | Pennsylvania | 42095 | 18017 | 460 |
900030 | 900030 | 2021-01-05 | Northampton | Pennsylvania | 42095 | 17738 | 450 |
896785 | 896785 | 2021-01-04 | Northampton | Pennsylvania | 42095 | 17430 | 439 |
893539 | 893539 | 2021-01-03 | Northampton | Pennsylvania | 42095 | 17358 | 438 |
890293 | 890293 | 2021-01-02 | Northampton | Pennsylvania | 42095 | 17261 | 438 |
887046 | 887046 | 2021-01-01 | Northampton | Pennsylvania | 42095 | 16940 | 436 |
883801 | 883801 | 2020-12-31 | Northampton | Pennsylvania | 42095 | 16648 | 431 |
880556 | 880556 | 2020-12-30 | Northampton | Pennsylvania | 42095 | 16380 | 427 |
877311 | 877311 | 2020-12-29 | Northampton | Pennsylvania | 42095 | 16084 | 416 |
874066 | 874066 | 2020-12-28 | Northampton | Pennsylvania | 42095 | 15893 | 411 |
870821 | 870821 | 2020-12-27 | Northampton | Pennsylvania | 42095 | 15779 | 410 |
867576 | 867576 | 2020-12-26 | Northampton | Pennsylvania | 42095 | 15679 | 406 |
864331 | 864331 | 2020-12-25 | Northampton | Pennsylvania | 42095 | 15460 | 405 |
861086 | 861086 | 2020-12-24 | Northampton | Pennsylvania | 42095 | 15226 | 403 |
857841 | 857841 | 2020-12-23 | Northampton | Pennsylvania | 42095 | 14876 | 395 |
854596 | 854596 | 2020-12-22 | Northampton | Pennsylvania | 42095 | 14638 | 391 |
851351 | 851351 | 2020-12-21 | Northampton | Pennsylvania | 42095 | 14443 | 384 |
848106 | 848106 | 2020-12-20 | Northampton | Pennsylvania | 42095 | 14123 | 384 |
844861 | 844861 | 2020-12-19 | Northampton | Pennsylvania | 42095 | 13855 | 381 |
841615 | 841615 | 2020-12-18 | Northampton | Pennsylvania | 42095 | 13642 | 375 |
838370 | 838370 | 2020-12-17 | Northampton | Pennsylvania | 42095 | 13459 | 372 |
835124 | 835124 | 2020-12-16 | Northampton | Pennsylvania | 42095 | 13151 | 370 |
831878 | 831878 | 2020-12-15 | Northampton | Pennsylvania | 42095 | 12818 | 363 |
828631 | 828631 | 2020-12-14 | Northampton | Pennsylvania | 42095 | 12672 | 360 |
825385 | 825385 | 2020-12-13 | Northampton | Pennsylvania | 42095 | 12446 | 361 |
822138 | 822138 | 2020-12-12 | Northampton | Pennsylvania | 42095 | 12151 | 360 |
818892 | 818892 | 2020-12-11 | Northampton | Pennsylvania | 42095 | 11908 | 357 |
815646 | 815646 | 2020-12-10 | Northampton | Pennsylvania | 42095 | 11639 | 352 |
812400 | 812400 | 2020-12-09 | Northampton | Pennsylvania | 42095 | 11226 | 348 |
809156 | 809156 | 2020-12-08 | Northampton | Pennsylvania | 42095 | 11000 | 348 |
805911 | 805911 | 2020-12-07 | Northampton | Pennsylvania | 42095 | 10767 | 346 |
802666 | 802666 | 2020-12-06 | Northampton | Pennsylvania | 42095 | 10539 | 345 |
799421 | 799421 | 2020-12-05 | Northampton | Pennsylvania | 42095 | 10327 | 344 |
796176 | 796176 | 2020-12-04 | Northampton | Pennsylvania | 42095 | 10036 | 343 |
792931 | 792931 | 2020-12-03 | Northampton | Pennsylvania | 42095 | 9632 | 340 |
789686 | 789686 | 2020-12-02 | Northampton | Pennsylvania | 42095 | 9444 | 337 |
786441 | 786441 | 2020-12-01 | Northampton | Pennsylvania | 42095 | 9199 | 336 |
783197 | 783197 | 2020-11-30 | Northampton | Pennsylvania | 42095 | 9104 | 333 |
779952 | 779952 | 2020-11-29 | Northampton | Pennsylvania | 42095 | 9000 | 333 |
776706 | 776706 | 2020-11-28 | Northampton | Pennsylvania | 42095 | 8903 | 332 |
773461 | 773461 | 2020-11-27 | Northampton | Pennsylvania | 42095 | 8667 | 331 |
770216 | 770216 | 2020-11-26 | Northampton | Pennsylvania | 42095 | 8478 | 331 |
766970 | 766970 | 2020-11-25 | Northampton | Pennsylvania | 42095 | 8277 | 330 |
763725 | 763725 | 2020-11-24 | Northampton | Pennsylvania | 42095 | 8137 | 330 |
760480 | 760480 | 2020-11-23 | Northampton | Pennsylvania | 42095 | 7984 | 328 |
757235 | 757235 | 2020-11-22 | Northampton | Pennsylvania | 42095 | 7840 | 327 |
753988 | 753988 | 2020-11-21 | Northampton | Pennsylvania | 42095 | 7666 | 327 |
750742 | 750742 | 2020-11-20 | Northampton | Pennsylvania | 42095 | 7472 | 326 |
747496 | 747496 | 2020-11-19 | Northampton | Pennsylvania | 42095 | 7311 | 324 |
744250 | 744250 | 2020-11-18 | Northampton | Pennsylvania | 42095 | 7143 | 324 |
741003 | 741003 | 2020-11-17 | Northampton | Pennsylvania | 42095 | 7013 | 323 |
737757 | 737757 | 2020-11-16 | Northampton | Pennsylvania | 42095 | 6918 | 323 |
734513 | 734513 | 2020-11-15 | Northampton | Pennsylvania | 42095 | 6842 | 322 |
731267 | 731267 | 2020-11-14 | Northampton | Pennsylvania | 42095 | 6700 | 322 |
728023 | 728023 | 2020-11-13 | Northampton | Pennsylvania | 42095 | 6593 | 322 |
724779 | 724779 | 2020-11-12 | Northampton | Pennsylvania | 42095 | 6457 | 322 |
721536 | 721536 | 2020-11-11 | Northampton | Pennsylvania | 42095 | 6324 | 319 |
718293 | 718293 | 2020-11-10 | Northampton | Pennsylvania | 42095 | 6207 | 319 |
715050 | 715050 | 2020-11-09 | Northampton | Pennsylvania | 42095 | 6131 | 319 |
711806 | 711806 | 2020-11-08 | Northampton | Pennsylvania | 42095 | 6058 | 319 |
708562 | 708562 | 2020-11-07 | Northampton | Pennsylvania | 42095 | 6004 | 319 |
705319 | 705319 | 2020-11-06 | Northampton | Pennsylvania | 42095 | 5911 | 317 |
702076 | 702076 | 2020-11-05 | Northampton | Pennsylvania | 42095 | 5826 | 316 |
698832 | 698832 | 2020-11-04 | Northampton | Pennsylvania | 42095 | 5748 | 315 |
695589 | 695589 | 2020-11-03 | Northampton | Pennsylvania | 42095 | 5700 | 315 |
692347 | 692347 | 2020-11-02 | Northampton | Pennsylvania | 42095 | 5655 | 315 |
689103 | 689103 | 2020-11-01 | Northampton | Pennsylvania | 42095 | 5619 | 315 |
685858 | 685858 | 2020-10-31 | Northampton | Pennsylvania | 42095 | 5568 | 315 |
682615 | 682615 | 2020-10-30 | Northampton | Pennsylvania | 42095 | 5481 | 313 |
679372 | 679372 | 2020-10-29 | Northampton | Pennsylvania | 42095 | 5439 | 312 |
676129 | 676129 | 2020-10-28 | Northampton | Pennsylvania | 42095 | 5393 | 311 |
672886 | 672886 | 2020-10-27 | Northampton | Pennsylvania | 42095 | 5341 | 311 |
669644 | 669644 | 2020-10-26 | Northampton | Pennsylvania | 42095 | 5304 | 311 |
666400 | 666400 | 2020-10-25 | Northampton | Pennsylvania | 42095 | 5269 | 311 |
663155 | 663155 | 2020-10-24 | Northampton | Pennsylvania | 42095 | 5232 | 311 |
659911 | 659911 | 2020-10-23 | Northampton | Pennsylvania | 42095 | 5184 | 311 |
656667 | 656667 | 2020-10-22 | Northampton | Pennsylvania | 42095 | 5155 | 310 |
653422 | 653422 | 2020-10-21 | Northampton | Pennsylvania | 42095 | 5108 | 309 |
650177 | 650177 | 2020-10-20 | Northampton | Pennsylvania | 42095 | 5088 | 309 |
646933 | 646933 | 2020-10-19 | Northampton | Pennsylvania | 42095 | 5062 | 309 |
643687 | 643687 | 2020-10-18 | Northampton | Pennsylvania | 42095 | 5049 | 309 |
640439 | 640439 | 2020-10-17 | Northampton | Pennsylvania | 42095 | 5022 | 309 |
637193 | 637193 | 2020-10-16 | Northampton | Pennsylvania | 42095 | 4972 | 309 |
633947 | 633947 | 2020-10-15 | Northampton | Pennsylvania | 42095 | 4929 | 309 |
630702 | 630702 | 2020-10-14 | Northampton | Pennsylvania | 42095 | 4905 | 309 |
627458 | 627458 | 2020-10-13 | Northampton | Pennsylvania | 42095 | 4883 | 309 |
624216 | 624216 | 2020-10-12 | Northampton | Pennsylvania | 42095 | 4864 | 309 |
620973 | 620973 | 2020-10-11 | Northampton | Pennsylvania | 42095 | 4852 | 309 |
617730 | 617730 | 2020-10-10 | Northampton | Pennsylvania | 42095 | 4820 | 308 |
614488 | 614488 | 2020-10-09 | Northampton | Pennsylvania | 42095 | 4737 | 307 |
611247 | 611247 | 2020-10-08 | Northampton | Pennsylvania | 42095 | 4714 | 307 |
608005 | 608005 | 2020-10-07 | Northampton | Pennsylvania | 42095 | 4684 | 306 |
604762 | 604762 | 2020-10-06 | Northampton | Pennsylvania | 42095 | 4638 | 305 |
601520 | 601520 | 2020-10-05 | Northampton | Pennsylvania | 42095 | 4606 | 305 |
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);