ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 42077 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 396 ✖
- 861 23
- 345 14
- 1235 12
- 0 11
- 335 10
- 1228 9
- 342 8
- 353 8
- 853 8
- 863 8
- 372 7
- 865 7
- 875 7
- 883 7
- 1230 7
- 1234 7
- 1242 7
- 365 6
- 864 6
- 1229 6
- 1239 6
- 334 5
- 341 5
- 343 5
- 366 5
- 374 5
- 382 5
- 851 5
- 874 5
- 880 5
- 957 5
- 961 5
- 1227 5
- 49 4
- 307 4
- 361 4
- 780 4
- 804 4
- 812 4
- 844 4
- 850 4
- 858 4
- 862 4
- 872 4
- 897 4
- 915 4
- 922 4
- 933 4
- 953 4
- 1032 4
- 1047 4
- 1212 4
- 3 3
- 5 3
- 83 3
- 228 3
- 332 3
- 337 3
- 354 3
- 357 3
- 359 3
- 363 3
- 379 3
- 787 3
- 806 3
- 808 3
- 811 3
- 814 3
- 826 3
- 871 3
- 887 3
- 891 3
- 898 3
- 939 3
- 991 3
- 1108 3
- 1218 3
- 1236 3
- 1237 3
- 1246 3
- 8 2
- 16 2
- 29 2
- 121 2
- 139 2
- 248 2
- 267 2
- 278 2
- 292 2
- 297 2
- 330 2
- 336 2
- 338 2
- 340 2
- 344 2
- 346 2
- 350 2
- 362 2
- 376 2
- 409 2
- 424 2
- 444 2
- 473 2
- 511 2
- 513 2
- 556 2
- 652 2
- 732 2
- 733 2
- 746 2
- 755 2
- 758 2
- 796 2
- 797 2
- 799 2
- 818 2
- 820 2
- 824 2
- 834 2
- 837 2
- 846 2
- 847 2
- 856 2
- 866 2
- 867 2
- 868 2
- 873 2
- 879 2
- 895 2
- 910 2
- 911 2
- 914 2
- 918 2
- 937 2
- 938 2
- 946 2
- 947 2
- 951 2
- 958 2
- 963 2
- 982 2
- 1002 2
- 1010 2
- 1109 2
- 1139 2
- 1161 2
- 1181 2
- 1196 2
- 1211 2
- 1232 2
- 1 1
- 2 1
- 4 1
- 7 1
- 10 1
- 11 1
- 13 1
- 18 1
- 19 1
- 23 1
- 25 1
- 28 1
- 32 1
- 33 1
- 50 1
- 51 1
- 56 1
- 64 1
- 72 1
- 74 1
- 80 1
- 94 1
- 102 1
- 111 1
- 114 1
- 120 1
- 123 1
- 129 1
- 133 1
- 136 1
- 173 1
- 182 1
- 188 1
- 192 1
- 197 1
- 202 1
- 206 1
- 209 1
- 210 1
- 215 1
- 218 1
- 222 1
- 235 1
- 239 1
- 242 1
- 245 1
- 249 1
- 253 1
- 259 1
- 263 1
- 264 1
- 269 1
- 271 1
- 273 1
- 276 1
- 277 1
- 279 1
- 281 1
- 284 1
- 285 1
- 288 1
- 294 1
- 305 1
- 309 1
- 312 1
- 315 1
- 319 1
- 324 1
- 326 1
- 327 1
- 329 1
- 331 1
- 333 1
- 349 1
- 352 1
- 355 1
- 356 1
- 358 1
- 364 1
- 369 1
- 370 1
- 371 1
- 380 1
- 381 1
- 385 1
- 387 1
- 392 1
- 395 1
- 399 1
- 400 1
- 401 1
- 416 1
- 422 1
- 423 1
- 429 1
- 434 1
- 435 1
- 440 1
- 443 1
- 454 1
- 460 1
- 468 1
- 479 1
- 481 1
- 489 1
- 498 1
- 503 1
- 518 1
- 528 1
- 536 1
- 545 1
- 553 1
- 564 1
- 580 1
- 587 1
- 596 1
- 603 1
- 606 1
- 610 1
- 612 1
- 631 1
- 637 1
- 644 1
- 651 1
- 661 1
- 675 1
- 682 1
- 684 1
- 687 1
- 688 1
- 689 1
- 690 1
- 692 1
- 695 1
- 701 1
- 708 1
- 711 1
- 713 1
- 717 1
- 720 1
- 726 1
- 730 1
- 739 1
- 742 1
- 743 1
- 745 1
- 748 1
- 759 1
- 761 1
- 768 1
- 773 1
- 775 1
- 777 1
- 782 1
- 786 1
- 788 1
- 792 1
- 800 1
- 802 1
- 803 1
- 805 1
- 823 1
- 825 1
- 830 1
- 831 1
- 835 1
- 839 1
- 841 1
- 842 1
- 849 1
- 859 1
- 860 1
- 870 1
- 878 1
- 885 1
- 886 1
- 889 1
- 892 1
- 901 1
- 905 1
- 907 1
- 912 1
- 924 1
- 925 1
- 930 1
- 932 1
- 936 1
- 943 1
- 944 1
- 945 1
- 950 1
- 955 1
- 967 1
- 968 1
- 971 1
- 972 1
- 976 1
- 981 1
- 985 1
- 994 1
- 998 1
- 1009 1
- 1012 1
- 1021 1
- 1029 1
- 1033 1
- 1045 1
- 1049 1
- 1054 1
- 1055 1
- 1066 1
- 1071 1
- 1075 1
- 1076 1
- 1077 1
- 1083 1
- 1092 1
- 1097 1
- 1101 1
- 1126 1
- 1133 1
- 1137 1
- 1141 1
- 1143 1
- 1152 1
- 1155 1
- 1160 1
- 1166 1
- 1170 1
- 1177 1
- 1178 1
- 1182 1
- 1185 1
- 1189 1
- 1193 1
- 1195 1
- 1198 1
- 1205 1
- 1209 1
- 1210 1
- 1214 1
- 1217 1
- 1224 1
- 1226 1
- 1233 1
- 1241 1
state 1
- Pennsylvania 790
fips 1
- 42077 · 790 ✖
county 1
- Lehigh 790
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501885 | 2501885 | 2022-05-13 | Lehigh | Pennsylvania | 42077 | 91539 | 1246 |
2498627 | 2498627 | 2022-05-12 | Lehigh | Pennsylvania | 42077 | 91539 | 1246 |
2495369 | 2495369 | 2022-05-11 | Lehigh | Pennsylvania | 42077 | 91539 | 1246 |
2492111 | 2492111 | 2022-05-10 | Lehigh | Pennsylvania | 42077 | 90776 | 1242 |
2488853 | 2488853 | 2022-05-09 | Lehigh | Pennsylvania | 42077 | 90776 | 1242 |
2485596 | 2485596 | 2022-05-08 | Lehigh | Pennsylvania | 42077 | 90776 | 1242 |
2482338 | 2482338 | 2022-05-07 | Lehigh | Pennsylvania | 42077 | 90776 | 1242 |
2479080 | 2479080 | 2022-05-06 | Lehigh | Pennsylvania | 42077 | 90776 | 1242 |
2475822 | 2475822 | 2022-05-05 | Lehigh | Pennsylvania | 42077 | 90776 | 1242 |
2472565 | 2472565 | 2022-05-04 | Lehigh | Pennsylvania | 42077 | 90776 | 1242 |
2469309 | 2469309 | 2022-05-03 | Lehigh | Pennsylvania | 42077 | 90680 | 1241 |
2466053 | 2466053 | 2022-05-02 | Lehigh | Pennsylvania | 42077 | 90603 | 1239 |
2462798 | 2462798 | 2022-05-01 | Lehigh | Pennsylvania | 42077 | 90546 | 1239 |
2459542 | 2459542 | 2022-04-30 | Lehigh | Pennsylvania | 42077 | 90501 | 1239 |
2456286 | 2456286 | 2022-04-29 | Lehigh | Pennsylvania | 42077 | 90399 | 1239 |
2453030 | 2453030 | 2022-04-28 | Lehigh | Pennsylvania | 42077 | 90327 | 1239 |
2449774 | 2449774 | 2022-04-27 | Lehigh | Pennsylvania | 42077 | 90250 | 1239 |
2446517 | 2446517 | 2022-04-26 | Lehigh | Pennsylvania | 42077 | 90172 | 1237 |
2443262 | 2443262 | 2022-04-25 | Lehigh | Pennsylvania | 42077 | 90131 | 1237 |
2440006 | 2440006 | 2022-04-24 | Lehigh | Pennsylvania | 42077 | 90098 | 1237 |
2436750 | 2436750 | 2022-04-23 | Lehigh | Pennsylvania | 42077 | 90047 | 1236 |
2433494 | 2433494 | 2022-04-22 | Lehigh | Pennsylvania | 42077 | 89989 | 1236 |
2430238 | 2430238 | 2022-04-21 | Lehigh | Pennsylvania | 42077 | 89935 | 1236 |
2426982 | 2426982 | 2022-04-20 | Lehigh | Pennsylvania | 42077 | 89861 | 1235 |
2423726 | 2423726 | 2022-04-19 | Lehigh | Pennsylvania | 42077 | 89820 | 1235 |
2420470 | 2420470 | 2022-04-18 | Lehigh | Pennsylvania | 42077 | 89795 | 1235 |
2417214 | 2417214 | 2022-04-17 | Lehigh | Pennsylvania | 42077 | 89767 | 1235 |
2413958 | 2413958 | 2022-04-16 | Lehigh | Pennsylvania | 42077 | 89734 | 1235 |
2410702 | 2410702 | 2022-04-15 | Lehigh | Pennsylvania | 42077 | 89688 | 1235 |
2407446 | 2407446 | 2022-04-14 | Lehigh | Pennsylvania | 42077 | 89634 | 1235 |
2404190 | 2404190 | 2022-04-13 | Lehigh | Pennsylvania | 42077 | 89587 | 1235 |
2400935 | 2400935 | 2022-04-12 | Lehigh | Pennsylvania | 42077 | 89551 | 1235 |
2397680 | 2397680 | 2022-04-11 | Lehigh | Pennsylvania | 42077 | 89515 | 1235 |
2394425 | 2394425 | 2022-04-10 | Lehigh | Pennsylvania | 42077 | 89499 | 1235 |
2391169 | 2391169 | 2022-04-09 | Lehigh | Pennsylvania | 42077 | 89492 | 1235 |
2387913 | 2387913 | 2022-04-08 | Lehigh | Pennsylvania | 42077 | 89454 | 1234 |
2384658 | 2384658 | 2022-04-07 | Lehigh | Pennsylvania | 42077 | 89414 | 1234 |
2381403 | 2381403 | 2022-04-06 | Lehigh | Pennsylvania | 42077 | 89378 | 1234 |
2378148 | 2378148 | 2022-04-05 | Lehigh | Pennsylvania | 42077 | 89345 | 1234 |
2374894 | 2374894 | 2022-04-04 | Lehigh | Pennsylvania | 42077 | 89321 | 1234 |
2371642 | 2371642 | 2022-04-03 | Lehigh | Pennsylvania | 42077 | 89297 | 1234 |
2368389 | 2368389 | 2022-04-02 | Lehigh | Pennsylvania | 42077 | 89297 | 1234 |
2365136 | 2365136 | 2022-04-01 | Lehigh | Pennsylvania | 42077 | 89280 | 1233 |
2361883 | 2361883 | 2022-03-31 | Lehigh | Pennsylvania | 42077 | 89251 | 1232 |
2358629 | 2358629 | 2022-03-30 | Lehigh | Pennsylvania | 42077 | 89223 | 1232 |
2355375 | 2355375 | 2022-03-29 | Lehigh | Pennsylvania | 42077 | 89209 | 1230 |
2352122 | 2352122 | 2022-03-28 | Lehigh | Pennsylvania | 42077 | 89190 | 1230 |
2348870 | 2348870 | 2022-03-27 | Lehigh | Pennsylvania | 42077 | 89179 | 1230 |
2345617 | 2345617 | 2022-03-26 | Lehigh | Pennsylvania | 42077 | 89175 | 1230 |
2342364 | 2342364 | 2022-03-25 | Lehigh | Pennsylvania | 42077 | 89159 | 1230 |
2339111 | 2339111 | 2022-03-24 | Lehigh | Pennsylvania | 42077 | 89138 | 1230 |
2335857 | 2335857 | 2022-03-23 | Lehigh | Pennsylvania | 42077 | 89107 | 1230 |
2332603 | 2332603 | 2022-03-22 | Lehigh | Pennsylvania | 42077 | 89095 | 1229 |
2329350 | 2329350 | 2022-03-21 | Lehigh | Pennsylvania | 42077 | 89090 | 1229 |
2326098 | 2326098 | 2022-03-20 | Lehigh | Pennsylvania | 42077 | 89083 | 1229 |
2322845 | 2322845 | 2022-03-19 | Lehigh | Pennsylvania | 42077 | 89076 | 1229 |
2319591 | 2319591 | 2022-03-18 | Lehigh | Pennsylvania | 42077 | 89064 | 1229 |
2316337 | 2316337 | 2022-03-17 | Lehigh | Pennsylvania | 42077 | 89049 | 1229 |
2313084 | 2313084 | 2022-03-16 | Lehigh | Pennsylvania | 42077 | 89030 | 1228 |
2309831 | 2309831 | 2022-03-15 | Lehigh | Pennsylvania | 42077 | 89016 | 1228 |
2306578 | 2306578 | 2022-03-14 | Lehigh | Pennsylvania | 42077 | 89009 | 1228 |
2303327 | 2303327 | 2022-03-13 | Lehigh | Pennsylvania | 42077 | 89002 | 1228 |
2300075 | 2300075 | 2022-03-12 | Lehigh | Pennsylvania | 42077 | 88994 | 1228 |
2296823 | 2296823 | 2022-03-11 | Lehigh | Pennsylvania | 42077 | 88974 | 1228 |
2293571 | 2293571 | 2022-03-10 | Lehigh | Pennsylvania | 42077 | 88960 | 1228 |
2290319 | 2290319 | 2022-03-09 | Lehigh | Pennsylvania | 42077 | 88933 | 1228 |
2287067 | 2287067 | 2022-03-08 | Lehigh | Pennsylvania | 42077 | 88919 | 1228 |
2283815 | 2283815 | 2022-03-07 | Lehigh | Pennsylvania | 42077 | 88899 | 1227 |
2280563 | 2280563 | 2022-03-06 | Lehigh | Pennsylvania | 42077 | 88886 | 1227 |
2277310 | 2277310 | 2022-03-05 | Lehigh | Pennsylvania | 42077 | 88875 | 1227 |
2274057 | 2274057 | 2022-03-04 | Lehigh | Pennsylvania | 42077 | 88861 | 1227 |
2270804 | 2270804 | 2022-03-03 | Lehigh | Pennsylvania | 42077 | 88836 | 1227 |
2267552 | 2267552 | 2022-03-02 | Lehigh | Pennsylvania | 42077 | 88812 | 1226 |
2264299 | 2264299 | 2022-03-01 | Lehigh | Pennsylvania | 42077 | 88793 | 1224 |
2261049 | 2261049 | 2022-02-28 | Lehigh | Pennsylvania | 42077 | 88773 | 1218 |
2257798 | 2257798 | 2022-02-27 | Lehigh | Pennsylvania | 42077 | 88760 | 1218 |
2254547 | 2254547 | 2022-02-26 | Lehigh | Pennsylvania | 42077 | 88749 | 1218 |
2251296 | 2251296 | 2022-02-25 | Lehigh | Pennsylvania | 42077 | 88721 | 1217 |
2248045 | 2248045 | 2022-02-24 | Lehigh | Pennsylvania | 42077 | 88686 | 1214 |
2244794 | 2244794 | 2022-02-23 | Lehigh | Pennsylvania | 42077 | 88651 | 1212 |
2241543 | 2241543 | 2022-02-22 | Lehigh | Pennsylvania | 42077 | 88625 | 1212 |
2238292 | 2238292 | 2022-02-21 | Lehigh | Pennsylvania | 42077 | 88584 | 1212 |
2235041 | 2235041 | 2022-02-20 | Lehigh | Pennsylvania | 42077 | 88584 | 1212 |
2231790 | 2231790 | 2022-02-19 | Lehigh | Pennsylvania | 42077 | 88560 | 1211 |
2228539 | 2228539 | 2022-02-18 | Lehigh | Pennsylvania | 42077 | 88461 | 1211 |
2225288 | 2225288 | 2022-02-17 | Lehigh | Pennsylvania | 42077 | 88420 | 1210 |
2222037 | 2222037 | 2022-02-16 | Lehigh | Pennsylvania | 42077 | 88350 | 1209 |
2218786 | 2218786 | 2022-02-15 | Lehigh | Pennsylvania | 42077 | 88309 | 1205 |
2215535 | 2215535 | 2022-02-14 | Lehigh | Pennsylvania | 42077 | 88266 | 1198 |
2212284 | 2212284 | 2022-02-13 | Lehigh | Pennsylvania | 42077 | 88227 | 1196 |
2209031 | 2209031 | 2022-02-12 | Lehigh | Pennsylvania | 42077 | 88195 | 1196 |
2205778 | 2205778 | 2022-02-11 | Lehigh | Pennsylvania | 42077 | 88101 | 1195 |
2202525 | 2202525 | 2022-02-10 | Lehigh | Pennsylvania | 42077 | 88000 | 1193 |
2199271 | 2199271 | 2022-02-09 | Lehigh | Pennsylvania | 42077 | 87898 | 1189 |
2196017 | 2196017 | 2022-02-08 | Lehigh | Pennsylvania | 42077 | 87805 | 1185 |
2192763 | 2192763 | 2022-02-07 | Lehigh | Pennsylvania | 42077 | 88015 | 1182 |
2189509 | 2189509 | 2022-02-06 | Lehigh | Pennsylvania | 42077 | 87771 | 1181 |
2186256 | 2186256 | 2022-02-05 | Lehigh | Pennsylvania | 42077 | 87690 | 1181 |
2183004 | 2183004 | 2022-02-04 | Lehigh | Pennsylvania | 42077 | 87510 | 1178 |
2179752 | 2179752 | 2022-02-03 | Lehigh | Pennsylvania | 42077 | 87337 | 1177 |
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);