ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Franklin" and fips = 42055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195399 | 1195399 | 2021-04-06 | Franklin | Pennsylvania | 42055 | 13744 | 343 |
1192151 | 1192151 | 2021-04-05 | Franklin | Pennsylvania | 42055 | 13669 | 341 |
1188902 | 1188902 | 2021-04-04 | Franklin | Pennsylvania | 42055 | 13648 | 341 |
1185655 | 1185655 | 2021-04-03 | Franklin | Pennsylvania | 42055 | 13624 | 341 |
1182408 | 1182408 | 2021-04-02 | Franklin | Pennsylvania | 42055 | 13582 | 340 |
1179161 | 1179161 | 2021-04-01 | Franklin | Pennsylvania | 42055 | 13532 | 338 |
1175914 | 1175914 | 2021-03-31 | Franklin | Pennsylvania | 42055 | 13496 | 338 |
1172667 | 1172667 | 2021-03-30 | Franklin | Pennsylvania | 42055 | 13448 | 338 |
1169420 | 1169420 | 2021-03-29 | Franklin | Pennsylvania | 42055 | 13371 | 338 |
1166172 | 1166172 | 2021-03-28 | Franklin | Pennsylvania | 42055 | 13348 | 338 |
1162924 | 1162924 | 2021-03-27 | Franklin | Pennsylvania | 42055 | 13327 | 338 |
1159675 | 1159675 | 2021-03-26 | Franklin | Pennsylvania | 42055 | 13292 | 338 |
1156428 | 1156428 | 2021-03-25 | Franklin | Pennsylvania | 42055 | 13251 | 338 |
1153181 | 1153181 | 2021-03-24 | Franklin | Pennsylvania | 42055 | 13226 | 338 |
1149934 | 1149934 | 2021-03-23 | Franklin | Pennsylvania | 42055 | 13182 | 338 |
1146687 | 1146687 | 2021-03-22 | Franklin | Pennsylvania | 42055 | 13123 | 337 |
1143440 | 1143440 | 2021-03-21 | Franklin | Pennsylvania | 42055 | 13119 | 337 |
1140193 | 1140193 | 2021-03-20 | Franklin | Pennsylvania | 42055 | 13101 | 337 |
1136947 | 1136947 | 2021-03-19 | Franklin | Pennsylvania | 42055 | 13067 | 337 |
1133701 | 1133701 | 2021-03-18 | Franklin | Pennsylvania | 42055 | 13029 | 335 |
1130453 | 1130453 | 2021-03-17 | Franklin | Pennsylvania | 42055 | 13007 | 335 |
1127206 | 1127206 | 2021-03-16 | Franklin | Pennsylvania | 42055 | 12976 | 335 |
1123960 | 1123960 | 2021-03-15 | Franklin | Pennsylvania | 42055 | 12903 | 332 |
1120714 | 1120714 | 2021-03-14 | Franklin | Pennsylvania | 42055 | 12891 | 331 |
1117467 | 1117467 | 2021-03-13 | Franklin | Pennsylvania | 42055 | 12872 | 331 |
1114220 | 1114220 | 2021-03-12 | Franklin | Pennsylvania | 42055 | 12837 | 331 |
1110974 | 1110974 | 2021-03-11 | Franklin | Pennsylvania | 42055 | 12795 | 330 |
1107728 | 1107728 | 2021-03-10 | Franklin | Pennsylvania | 42055 | 12767 | 329 |
1104482 | 1104482 | 2021-03-09 | Franklin | Pennsylvania | 42055 | 12725 | 328 |
1101236 | 1101236 | 2021-03-08 | Franklin | Pennsylvania | 42055 | 12688 | 326 |
1097990 | 1097990 | 2021-03-07 | Franklin | Pennsylvania | 42055 | 12679 | 326 |
1094742 | 1094742 | 2021-03-06 | Franklin | Pennsylvania | 42055 | 12662 | 326 |
1091496 | 1091496 | 2021-03-05 | Franklin | Pennsylvania | 42055 | 12645 | 326 |
1088250 | 1088250 | 2021-03-04 | Franklin | Pennsylvania | 42055 | 12620 | 326 |
1085005 | 1085005 | 2021-03-03 | Franklin | Pennsylvania | 42055 | 12586 | 325 |
1081759 | 1081759 | 2021-03-02 | Franklin | Pennsylvania | 42055 | 12556 | 324 |
1078513 | 1078513 | 2021-03-01 | Franklin | Pennsylvania | 42055 | 12520 | 324 |
1075268 | 1075268 | 2021-02-28 | Franklin | Pennsylvania | 42055 | 12503 | 324 |
1072022 | 1072022 | 2021-02-27 | Franklin | Pennsylvania | 42055 | 12494 | 323 |
1068776 | 1068776 | 2021-02-26 | Franklin | Pennsylvania | 42055 | 12464 | 323 |
1065531 | 1065531 | 2021-02-25 | Franklin | Pennsylvania | 42055 | 12425 | 321 |
1062286 | 1062286 | 2021-02-24 | Franklin | Pennsylvania | 42055 | 12406 | 320 |
1059041 | 1059041 | 2021-02-23 | Franklin | Pennsylvania | 42055 | 12370 | 318 |
1055795 | 1055795 | 2021-02-22 | Franklin | Pennsylvania | 42055 | 12309 | 317 |
1052549 | 1052549 | 2021-02-21 | Franklin | Pennsylvania | 42055 | 12308 | 317 |
1049302 | 1049302 | 2021-02-20 | Franklin | Pennsylvania | 42055 | 12292 | 317 |
1046055 | 1046055 | 2021-02-19 | Franklin | Pennsylvania | 42055 | 12275 | 317 |
1042810 | 1042810 | 2021-02-18 | Franklin | Pennsylvania | 42055 | 12252 | 317 |
1039565 | 1039565 | 2021-02-17 | Franklin | Pennsylvania | 42055 | 12224 | 317 |
1036320 | 1036320 | 2021-02-16 | Franklin | Pennsylvania | 42055 | 12182 | 314 |
1033075 | 1033075 | 2021-02-15 | Franklin | Pennsylvania | 42055 | 12121 | 314 |
1029829 | 1029829 | 2021-02-14 | Franklin | Pennsylvania | 42055 | 12101 | 313 |
1026582 | 1026582 | 2021-02-13 | Franklin | Pennsylvania | 42055 | 12067 | 313 |
1023337 | 1023337 | 2021-02-12 | Franklin | Pennsylvania | 42055 | 12043 | 313 |
1020092 | 1020092 | 2021-02-11 | Franklin | Pennsylvania | 42055 | 11990 | 313 |
1016847 | 1016847 | 2021-02-10 | Franklin | Pennsylvania | 42055 | 11949 | 311 |
1013602 | 1013602 | 2021-02-09 | Franklin | Pennsylvania | 42055 | 11917 | 309 |
1010357 | 1010357 | 2021-02-08 | Franklin | Pennsylvania | 42055 | 11813 | 309 |
1007111 | 1007111 | 2021-02-07 | Franklin | Pennsylvania | 42055 | 11795 | 307 |
1003865 | 1003865 | 2021-02-06 | Franklin | Pennsylvania | 42055 | 11749 | 306 |
1000619 | 1000619 | 2021-02-05 | Franklin | Pennsylvania | 42055 | 11683 | 304 |
997373 | 997373 | 2021-02-04 | Franklin | Pennsylvania | 42055 | 11638 | 302 |
994127 | 994127 | 2021-02-03 | Franklin | Pennsylvania | 42055 | 11609 | 302 |
990881 | 990881 | 2021-02-02 | Franklin | Pennsylvania | 42055 | 11583 | 301 |
987635 | 987635 | 2021-02-01 | Franklin | Pennsylvania | 42055 | 11502 | 300 |
984388 | 984388 | 2021-01-31 | Franklin | Pennsylvania | 42055 | 11476 | 300 |
981141 | 981141 | 2021-01-30 | Franklin | Pennsylvania | 42055 | 11437 | 300 |
977895 | 977895 | 2021-01-29 | Franklin | Pennsylvania | 42055 | 11405 | 299 |
974650 | 974650 | 2021-01-28 | Franklin | Pennsylvania | 42055 | 11345 | 298 |
971405 | 971405 | 2021-01-27 | Franklin | Pennsylvania | 42055 | 11302 | 297 |
968160 | 968160 | 2021-01-26 | Franklin | Pennsylvania | 42055 | 11245 | 295 |
964916 | 964916 | 2021-01-25 | Franklin | Pennsylvania | 42055 | 11120 | 292 |
961671 | 961671 | 2021-01-24 | Franklin | Pennsylvania | 42055 | 11091 | 292 |
958426 | 958426 | 2021-01-23 | Franklin | Pennsylvania | 42055 | 11057 | 291 |
955180 | 955180 | 2021-01-22 | Franklin | Pennsylvania | 42055 | 10987 | 290 |
951935 | 951935 | 2021-01-21 | Franklin | Pennsylvania | 42055 | 10933 | 286 |
948690 | 948690 | 2021-01-20 | Franklin | Pennsylvania | 42055 | 10878 | 283 |
945444 | 945444 | 2021-01-19 | Franklin | Pennsylvania | 42055 | 10801 | 278 |
942197 | 942197 | 2021-01-18 | Franklin | Pennsylvania | 42055 | 10652 | 278 |
938952 | 938952 | 2021-01-17 | Franklin | Pennsylvania | 42055 | 10607 | 277 |
935707 | 935707 | 2021-01-16 | Franklin | Pennsylvania | 42055 | 10535 | 276 |
932462 | 932462 | 2021-01-15 | Franklin | Pennsylvania | 42055 | 10442 | 273 |
929217 | 929217 | 2021-01-14 | Franklin | Pennsylvania | 42055 | 10367 | 271 |
925972 | 925972 | 2021-01-13 | Franklin | Pennsylvania | 42055 | 10263 | 265 |
922726 | 922726 | 2021-01-12 | Franklin | Pennsylvania | 42055 | 10180 | 261 |
919481 | 919481 | 2021-01-11 | Franklin | Pennsylvania | 42055 | 10035 | 261 |
916236 | 916236 | 2021-01-10 | Franklin | Pennsylvania | 42055 | 9952 | 261 |
912991 | 912991 | 2021-01-09 | Franklin | Pennsylvania | 42055 | 9855 | 259 |
909746 | 909746 | 2021-01-08 | Franklin | Pennsylvania | 42055 | 9723 | 254 |
906501 | 906501 | 2021-01-07 | Franklin | Pennsylvania | 42055 | 9515 | 253 |
903255 | 903255 | 2021-01-06 | Franklin | Pennsylvania | 42055 | 9404 | 250 |
900010 | 900010 | 2021-01-05 | Franklin | Pennsylvania | 42055 | 9189 | 240 |
896765 | 896765 | 2021-01-04 | Franklin | Pennsylvania | 42055 | 8963 | 238 |
893519 | 893519 | 2021-01-03 | Franklin | Pennsylvania | 42055 | 8924 | 236 |
890273 | 890273 | 2021-01-02 | Franklin | Pennsylvania | 42055 | 8854 | 234 |
887026 | 887026 | 2021-01-01 | Franklin | Pennsylvania | 42055 | 8766 | 231 |
883781 | 883781 | 2020-12-31 | Franklin | Pennsylvania | 42055 | 8699 | 225 |
880536 | 880536 | 2020-12-30 | Franklin | Pennsylvania | 42055 | 8570 | 220 |
877291 | 877291 | 2020-12-29 | Franklin | Pennsylvania | 42055 | 8391 | 215 |
874046 | 874046 | 2020-12-28 | Franklin | Pennsylvania | 42055 | 8294 | 211 |
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);