ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42103 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388228 | 388228 | 2020-07-31 | Pike | Pennsylvania | 42103 | 524 | 21 |
385011 | 385011 | 2020-07-30 | Pike | Pennsylvania | 42103 | 524 | 21 |
381793 | 381793 | 2020-07-29 | Pike | Pennsylvania | 42103 | 524 | 21 |
378576 | 378576 | 2020-07-28 | Pike | Pennsylvania | 42103 | 524 | 21 |
375360 | 375360 | 2020-07-27 | Pike | Pennsylvania | 42103 | 523 | 21 |
372147 | 372147 | 2020-07-26 | Pike | Pennsylvania | 42103 | 523 | 21 |
368935 | 368935 | 2020-07-25 | Pike | Pennsylvania | 42103 | 521 | 21 |
365726 | 365726 | 2020-07-24 | Pike | Pennsylvania | 42103 | 519 | 21 |
362520 | 362520 | 2020-07-23 | Pike | Pennsylvania | 42103 | 517 | 21 |
359314 | 359314 | 2020-07-22 | Pike | Pennsylvania | 42103 | 517 | 21 |
356110 | 356110 | 2020-07-21 | Pike | Pennsylvania | 42103 | 515 | 21 |
352907 | 352907 | 2020-07-20 | Pike | Pennsylvania | 42103 | 514 | 21 |
349704 | 349704 | 2020-07-19 | Pike | Pennsylvania | 42103 | 513 | 21 |
346504 | 346504 | 2020-07-18 | Pike | Pennsylvania | 42103 | 511 | 21 |
343304 | 343304 | 2020-07-17 | Pike | Pennsylvania | 42103 | 509 | 21 |
340106 | 340106 | 2020-07-16 | Pike | Pennsylvania | 42103 | 509 | 21 |
336909 | 336909 | 2020-07-15 | Pike | Pennsylvania | 42103 | 508 | 21 |
333715 | 333715 | 2020-07-14 | Pike | Pennsylvania | 42103 | 507 | 21 |
330523 | 330523 | 2020-07-13 | Pike | Pennsylvania | 42103 | 505 | 21 |
327337 | 327337 | 2020-07-12 | Pike | Pennsylvania | 42103 | 504 | 21 |
324152 | 324152 | 2020-07-11 | Pike | Pennsylvania | 42103 | 504 | 21 |
320972 | 320972 | 2020-07-10 | Pike | Pennsylvania | 42103 | 504 | 21 |
317794 | 317794 | 2020-07-09 | Pike | Pennsylvania | 42103 | 504 | 21 |
314621 | 314621 | 2020-07-08 | Pike | Pennsylvania | 42103 | 504 | 21 |
311449 | 311449 | 2020-07-07 | Pike | Pennsylvania | 42103 | 504 | 21 |
308280 | 308280 | 2020-07-06 | Pike | Pennsylvania | 42103 | 503 | 21 |
305113 | 305113 | 2020-07-05 | Pike | Pennsylvania | 42103 | 503 | 21 |
301950 | 301950 | 2020-07-04 | Pike | Pennsylvania | 42103 | 502 | 21 |
298786 | 298786 | 2020-07-03 | Pike | Pennsylvania | 42103 | 500 | 21 |
295627 | 295627 | 2020-07-02 | Pike | Pennsylvania | 42103 | 498 | 20 |
292471 | 292471 | 2020-07-01 | Pike | Pennsylvania | 42103 | 496 | 20 |
289319 | 289319 | 2020-06-30 | Pike | Pennsylvania | 42103 | 496 | 20 |
286168 | 286168 | 2020-06-29 | Pike | Pennsylvania | 42103 | 494 | 20 |
283023 | 283023 | 2020-06-28 | Pike | Pennsylvania | 42103 | 493 | 20 |
279877 | 279877 | 2020-06-27 | Pike | Pennsylvania | 42103 | 492 | 20 |
276729 | 276729 | 2020-06-26 | Pike | Pennsylvania | 42103 | 489 | 20 |
273582 | 273582 | 2020-06-25 | Pike | Pennsylvania | 42103 | 489 | 20 |
270443 | 270443 | 2020-06-24 | Pike | Pennsylvania | 42103 | 489 | 20 |
267309 | 267309 | 2020-06-23 | Pike | Pennsylvania | 42103 | 489 | 20 |
264181 | 264181 | 2020-06-22 | Pike | Pennsylvania | 42103 | 489 | 20 |
261053 | 261053 | 2020-06-21 | Pike | Pennsylvania | 42103 | 489 | 20 |
257926 | 257926 | 2020-06-20 | Pike | Pennsylvania | 42103 | 487 | 20 |
254800 | 254800 | 2020-06-19 | Pike | Pennsylvania | 42103 | 487 | 20 |
251685 | 251685 | 2020-06-18 | Pike | Pennsylvania | 42103 | 487 | 20 |
248570 | 248570 | 2020-06-17 | Pike | Pennsylvania | 42103 | 486 | 20 |
245457 | 245457 | 2020-06-16 | Pike | Pennsylvania | 42103 | 485 | 20 |
242345 | 242345 | 2020-06-15 | Pike | Pennsylvania | 42103 | 482 | 20 |
239236 | 239236 | 2020-06-14 | Pike | Pennsylvania | 42103 | 482 | 20 |
236128 | 236128 | 2020-06-13 | Pike | Pennsylvania | 42103 | 482 | 20 |
233023 | 233023 | 2020-06-12 | Pike | Pennsylvania | 42103 | 482 | 20 |
229918 | 229918 | 2020-06-11 | Pike | Pennsylvania | 42103 | 482 | 20 |
226814 | 226814 | 2020-06-10 | Pike | Pennsylvania | 42103 | 483 | 20 |
223714 | 223714 | 2020-06-09 | Pike | Pennsylvania | 42103 | 482 | 20 |
220619 | 220619 | 2020-06-08 | Pike | Pennsylvania | 42103 | 482 | 20 |
217527 | 217527 | 2020-06-07 | Pike | Pennsylvania | 42103 | 482 | 20 |
214437 | 214437 | 2020-06-06 | Pike | Pennsylvania | 42103 | 481 | 20 |
211351 | 211351 | 2020-06-05 | Pike | Pennsylvania | 42103 | 478 | 20 |
208269 | 208269 | 2020-06-04 | Pike | Pennsylvania | 42103 | 478 | 20 |
205188 | 205188 | 2020-06-03 | Pike | Pennsylvania | 42103 | 478 | 20 |
202111 | 202111 | 2020-06-02 | Pike | Pennsylvania | 42103 | 478 | 20 |
199036 | 199036 | 2020-06-01 | Pike | Pennsylvania | 42103 | 477 | 19 |
195963 | 195963 | 2020-05-31 | Pike | Pennsylvania | 42103 | 476 | 19 |
192894 | 192894 | 2020-05-30 | Pike | Pennsylvania | 42103 | 476 | 19 |
189829 | 189829 | 2020-05-29 | Pike | Pennsylvania | 42103 | 476 | 19 |
186768 | 186768 | 2020-05-28 | Pike | Pennsylvania | 42103 | 476 | 18 |
183711 | 183711 | 2020-05-27 | Pike | Pennsylvania | 42103 | 476 | 18 |
180661 | 180661 | 2020-05-26 | Pike | Pennsylvania | 42103 | 476 | 18 |
177618 | 177618 | 2020-05-25 | Pike | Pennsylvania | 42103 | 477 | 18 |
174574 | 174574 | 2020-05-24 | Pike | Pennsylvania | 42103 | 477 | 18 |
171532 | 171532 | 2020-05-23 | Pike | Pennsylvania | 42103 | 476 | 18 |
168493 | 168493 | 2020-05-22 | Pike | Pennsylvania | 42103 | 475 | 18 |
165457 | 165457 | 2020-05-21 | Pike | Pennsylvania | 42103 | 473 | 18 |
162428 | 162428 | 2020-05-20 | Pike | Pennsylvania | 42103 | 470 | 18 |
159401 | 159401 | 2020-05-19 | Pike | Pennsylvania | 42103 | 469 | 17 |
156380 | 156380 | 2020-05-18 | Pike | Pennsylvania | 42103 | 461 | 15 |
153363 | 153363 | 2020-05-17 | Pike | Pennsylvania | 42103 | 460 | 22 |
150352 | 150352 | 2020-05-16 | Pike | Pennsylvania | 42103 | 460 | 22 |
147345 | 147345 | 2020-05-15 | Pike | Pennsylvania | 42103 | 458 | 22 |
144344 | 144344 | 2020-05-14 | Pike | Pennsylvania | 42103 | 454 | 21 |
141348 | 141348 | 2020-05-13 | Pike | Pennsylvania | 42103 | 451 | 21 |
138352 | 138352 | 2020-05-12 | Pike | Pennsylvania | 42103 | 441 | 21 |
135362 | 135362 | 2020-05-11 | Pike | Pennsylvania | 42103 | 433 | 21 |
132371 | 132371 | 2020-05-10 | Pike | Pennsylvania | 42103 | 432 | 21 |
129382 | 129382 | 2020-05-09 | Pike | Pennsylvania | 42103 | 427 | 21 |
126393 | 126393 | 2020-05-08 | Pike | Pennsylvania | 42103 | 422 | 21 |
123410 | 123410 | 2020-05-07 | Pike | Pennsylvania | 42103 | 419 | 19 |
120433 | 120433 | 2020-05-06 | Pike | Pennsylvania | 42103 | 415 | 17 |
117471 | 117471 | 2020-05-05 | Pike | Pennsylvania | 42103 | 412 | 17 |
114590 | 114590 | 2020-05-04 | Pike | Pennsylvania | 42103 | 408 | 17 |
111708 | 111708 | 2020-05-03 | Pike | Pennsylvania | 42103 | 405 | 16 |
108834 | 108834 | 2020-05-02 | Pike | Pennsylvania | 42103 | 394 | 15 |
105967 | 105967 | 2020-05-01 | Pike | Pennsylvania | 42103 | 383 | 15 |
103104 | 103104 | 2020-04-30 | Pike | Pennsylvania | 42103 | 378 | 14 |
100251 | 100251 | 2020-04-29 | Pike | Pennsylvania | 42103 | 369 | 14 |
97402 | 97402 | 2020-04-28 | Pike | Pennsylvania | 42103 | 362 | 12 |
94563 | 94563 | 2020-04-27 | Pike | Pennsylvania | 42103 | 352 | 12 |
91736 | 91736 | 2020-04-26 | Pike | Pennsylvania | 42103 | 349 | 12 |
88920 | 88920 | 2020-04-25 | Pike | Pennsylvania | 42103 | 347 | 12 |
86106 | 86106 | 2020-04-24 | Pike | Pennsylvania | 42103 | 338 | 12 |
83302 | 83302 | 2020-04-23 | Pike | Pennsylvania | 42103 | 327 | 12 |
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);