ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Lackawanna" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195406 | 1195406 | 2021-04-06 | Lackawanna | Pennsylvania | 42069 | 16038 | 440 |
1192158 | 1192158 | 2021-04-05 | Lackawanna | Pennsylvania | 42069 | 15931 | 438 |
1188909 | 1188909 | 2021-04-04 | Lackawanna | Pennsylvania | 42069 | 15896 | 437 |
1185662 | 1185662 | 2021-04-03 | Lackawanna | Pennsylvania | 42069 | 15827 | 436 |
1182415 | 1182415 | 2021-04-02 | Lackawanna | Pennsylvania | 42069 | 15738 | 435 |
1179168 | 1179168 | 2021-04-01 | Lackawanna | Pennsylvania | 42069 | 15656 | 435 |
1175921 | 1175921 | 2021-03-31 | Lackawanna | Pennsylvania | 42069 | 15567 | 435 |
1172674 | 1172674 | 2021-03-30 | Lackawanna | Pennsylvania | 42069 | 15491 | 433 |
1169427 | 1169427 | 2021-03-29 | Lackawanna | Pennsylvania | 42069 | 15365 | 433 |
1166179 | 1166179 | 2021-03-28 | Lackawanna | Pennsylvania | 42069 | 15336 | 433 |
1162931 | 1162931 | 2021-03-27 | Lackawanna | Pennsylvania | 42069 | 15316 | 433 |
1159682 | 1159682 | 2021-03-26 | Lackawanna | Pennsylvania | 42069 | 15224 | 433 |
1156435 | 1156435 | 2021-03-25 | Lackawanna | Pennsylvania | 42069 | 15148 | 432 |
1153188 | 1153188 | 2021-03-24 | Lackawanna | Pennsylvania | 42069 | 15076 | 431 |
1149941 | 1149941 | 2021-03-23 | Lackawanna | Pennsylvania | 42069 | 14976 | 430 |
1146694 | 1146694 | 2021-03-22 | Lackawanna | Pennsylvania | 42069 | 14908 | 429 |
1143447 | 1143447 | 2021-03-21 | Lackawanna | Pennsylvania | 42069 | 14889 | 429 |
1140200 | 1140200 | 2021-03-20 | Lackawanna | Pennsylvania | 42069 | 14857 | 429 |
1136954 | 1136954 | 2021-03-19 | Lackawanna | Pennsylvania | 42069 | 14788 | 429 |
1133708 | 1133708 | 2021-03-18 | Lackawanna | Pennsylvania | 42069 | 14730 | 430 |
1130460 | 1130460 | 2021-03-17 | Lackawanna | Pennsylvania | 42069 | 14663 | 429 |
1127213 | 1127213 | 2021-03-16 | Lackawanna | Pennsylvania | 42069 | 14604 | 429 |
1123967 | 1123967 | 2021-03-15 | Lackawanna | Pennsylvania | 42069 | 14555 | 428 |
1120721 | 1120721 | 2021-03-14 | Lackawanna | Pennsylvania | 42069 | 14541 | 427 |
1117474 | 1117474 | 2021-03-13 | Lackawanna | Pennsylvania | 42069 | 14512 | 427 |
1114227 | 1114227 | 2021-03-12 | Lackawanna | Pennsylvania | 42069 | 14457 | 427 |
1110981 | 1110981 | 2021-03-11 | Lackawanna | Pennsylvania | 42069 | 14415 | 427 |
1107735 | 1107735 | 2021-03-10 | Lackawanna | Pennsylvania | 42069 | 14374 | 427 |
1104489 | 1104489 | 2021-03-09 | Lackawanna | Pennsylvania | 42069 | 14325 | 427 |
1101243 | 1101243 | 2021-03-08 | Lackawanna | Pennsylvania | 42069 | 14265 | 426 |
1097997 | 1097997 | 2021-03-07 | Lackawanna | Pennsylvania | 42069 | 14228 | 426 |
1094749 | 1094749 | 2021-03-06 | Lackawanna | Pennsylvania | 42069 | 14205 | 426 |
1091503 | 1091503 | 2021-03-05 | Lackawanna | Pennsylvania | 42069 | 14157 | 426 |
1088257 | 1088257 | 2021-03-04 | Lackawanna | Pennsylvania | 42069 | 14104 | 427 |
1085012 | 1085012 | 2021-03-03 | Lackawanna | Pennsylvania | 42069 | 14072 | 423 |
1081766 | 1081766 | 2021-03-02 | Lackawanna | Pennsylvania | 42069 | 14009 | 420 |
1078520 | 1078520 | 2021-03-01 | Lackawanna | Pennsylvania | 42069 | 13964 | 419 |
1075275 | 1075275 | 2021-02-28 | Lackawanna | Pennsylvania | 42069 | 13934 | 419 |
1072029 | 1072029 | 2021-02-27 | Lackawanna | Pennsylvania | 42069 | 13888 | 416 |
1068783 | 1068783 | 2021-02-26 | Lackawanna | Pennsylvania | 42069 | 13829 | 416 |
1065538 | 1065538 | 2021-02-25 | Lackawanna | Pennsylvania | 42069 | 13772 | 414 |
1062293 | 1062293 | 2021-02-24 | Lackawanna | Pennsylvania | 42069 | 13725 | 414 |
1059048 | 1059048 | 2021-02-23 | Lackawanna | Pennsylvania | 42069 | 13670 | 413 |
1055802 | 1055802 | 2021-02-22 | Lackawanna | Pennsylvania | 42069 | 13629 | 410 |
1052556 | 1052556 | 2021-02-21 | Lackawanna | Pennsylvania | 42069 | 13595 | 410 |
1049309 | 1049309 | 2021-02-20 | Lackawanna | Pennsylvania | 42069 | 13563 | 406 |
1046062 | 1046062 | 2021-02-19 | Lackawanna | Pennsylvania | 42069 | 13507 | 406 |
1042817 | 1042817 | 2021-02-18 | Lackawanna | Pennsylvania | 42069 | 13427 | 403 |
1039572 | 1039572 | 2021-02-17 | Lackawanna | Pennsylvania | 42069 | 13386 | 402 |
1036327 | 1036327 | 2021-02-16 | Lackawanna | Pennsylvania | 42069 | 13314 | 399 |
1033082 | 1033082 | 2021-02-15 | Lackawanna | Pennsylvania | 42069 | 13262 | 399 |
1029836 | 1029836 | 2021-02-14 | Lackawanna | Pennsylvania | 42069 | 13237 | 399 |
1026589 | 1026589 | 2021-02-13 | Lackawanna | Pennsylvania | 42069 | 13196 | 399 |
1023344 | 1023344 | 2021-02-12 | Lackawanna | Pennsylvania | 42069 | 13095 | 397 |
1020099 | 1020099 | 2021-02-11 | Lackawanna | Pennsylvania | 42069 | 13043 | 395 |
1016854 | 1016854 | 2021-02-10 | Lackawanna | Pennsylvania | 42069 | 12961 | 391 |
1013609 | 1013609 | 2021-02-09 | Lackawanna | Pennsylvania | 42069 | 12893 | 388 |
1010364 | 1010364 | 2021-02-08 | Lackawanna | Pennsylvania | 42069 | 12838 | 383 |
1007118 | 1007118 | 2021-02-07 | Lackawanna | Pennsylvania | 42069 | 12784 | 380 |
1003872 | 1003872 | 2021-02-06 | Lackawanna | Pennsylvania | 42069 | 12706 | 376 |
1000626 | 1000626 | 2021-02-05 | Lackawanna | Pennsylvania | 42069 | 12638 | 370 |
997380 | 997380 | 2021-02-04 | Lackawanna | Pennsylvania | 42069 | 12590 | 365 |
994134 | 994134 | 2021-02-03 | Lackawanna | Pennsylvania | 42069 | 12544 | 361 |
990888 | 990888 | 2021-02-02 | Lackawanna | Pennsylvania | 42069 | 12497 | 360 |
987642 | 987642 | 2021-02-01 | Lackawanna | Pennsylvania | 42069 | 12433 | 355 |
984395 | 984395 | 2021-01-31 | Lackawanna | Pennsylvania | 42069 | 12398 | 355 |
981148 | 981148 | 2021-01-30 | Lackawanna | Pennsylvania | 42069 | 12367 | 354 |
977902 | 977902 | 2021-01-29 | Lackawanna | Pennsylvania | 42069 | 12285 | 353 |
974657 | 974657 | 2021-01-28 | Lackawanna | Pennsylvania | 42069 | 12201 | 351 |
971412 | 971412 | 2021-01-27 | Lackawanna | Pennsylvania | 42069 | 12120 | 350 |
968167 | 968167 | 2021-01-26 | Lackawanna | Pennsylvania | 42069 | 11971 | 340 |
964923 | 964923 | 2021-01-25 | Lackawanna | Pennsylvania | 42069 | 11917 | 330 |
961678 | 961678 | 2021-01-24 | Lackawanna | Pennsylvania | 42069 | 11860 | 325 |
958433 | 958433 | 2021-01-23 | Lackawanna | Pennsylvania | 42069 | 11783 | 325 |
955187 | 955187 | 2021-01-22 | Lackawanna | Pennsylvania | 42069 | 11653 | 322 |
951942 | 951942 | 2021-01-21 | Lackawanna | Pennsylvania | 42069 | 11535 | 319 |
948697 | 948697 | 2021-01-20 | Lackawanna | Pennsylvania | 42069 | 11437 | 318 |
945451 | 945451 | 2021-01-19 | Lackawanna | Pennsylvania | 42069 | 11343 | 308 |
942204 | 942204 | 2021-01-18 | Lackawanna | Pennsylvania | 42069 | 11242 | 305 |
938959 | 938959 | 2021-01-17 | Lackawanna | Pennsylvania | 42069 | 11121 | 302 |
935714 | 935714 | 2021-01-16 | Lackawanna | Pennsylvania | 42069 | 10990 | 301 |
932469 | 932469 | 2021-01-15 | Lackawanna | Pennsylvania | 42069 | 10872 | 298 |
929224 | 929224 | 2021-01-14 | Lackawanna | Pennsylvania | 42069 | 10793 | 297 |
925979 | 925979 | 2021-01-13 | Lackawanna | Pennsylvania | 42069 | 10627 | 294 |
922733 | 922733 | 2021-01-12 | Lackawanna | Pennsylvania | 42069 | 10462 | 288 |
919488 | 919488 | 2021-01-11 | Lackawanna | Pennsylvania | 42069 | 10319 | 282 |
916243 | 916243 | 2021-01-10 | Lackawanna | Pennsylvania | 42069 | 10229 | 282 |
912998 | 912998 | 2021-01-09 | Lackawanna | Pennsylvania | 42069 | 10100 | 281 |
909753 | 909753 | 2021-01-08 | Lackawanna | Pennsylvania | 42069 | 9954 | 276 |
906508 | 906508 | 2021-01-07 | Lackawanna | Pennsylvania | 42069 | 9747 | 276 |
903262 | 903262 | 2021-01-06 | Lackawanna | Pennsylvania | 42069 | 9597 | 274 |
900017 | 900017 | 2021-01-05 | Lackawanna | Pennsylvania | 42069 | 9452 | 272 |
896772 | 896772 | 2021-01-04 | Lackawanna | Pennsylvania | 42069 | 9283 | 270 |
893526 | 893526 | 2021-01-03 | Lackawanna | Pennsylvania | 42069 | 9224 | 269 |
890280 | 890280 | 2021-01-02 | Lackawanna | Pennsylvania | 42069 | 9130 | 269 |
887033 | 887033 | 2021-01-01 | Lackawanna | Pennsylvania | 42069 | 8982 | 269 |
883788 | 883788 | 2020-12-31 | Lackawanna | Pennsylvania | 42069 | 8812 | 268 |
880543 | 880543 | 2020-12-30 | Lackawanna | Pennsylvania | 42069 | 8643 | 264 |
877298 | 877298 | 2020-12-29 | Lackawanna | Pennsylvania | 42069 | 8499 | 264 |
874053 | 874053 | 2020-12-28 | Lackawanna | Pennsylvania | 42069 | 8370 | 262 |
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);