ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 42037 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536695 | 536695 | 2020-09-15 | Columbia | Pennsylvania | 42037 | 843 | 35 |
533459 | 533459 | 2020-09-14 | Columbia | Pennsylvania | 42037 | 842 | 35 |
530224 | 530224 | 2020-09-13 | Columbia | Pennsylvania | 42037 | 836 | 35 |
526987 | 526987 | 2020-09-12 | Columbia | Pennsylvania | 42037 | 836 | 35 |
523751 | 523751 | 2020-09-11 | Columbia | Pennsylvania | 42037 | 831 | 35 |
520515 | 520515 | 2020-09-10 | Columbia | Pennsylvania | 42037 | 824 | 35 |
517279 | 517279 | 2020-09-09 | Columbia | Pennsylvania | 42037 | 813 | 35 |
514044 | 514044 | 2020-09-08 | Columbia | Pennsylvania | 42037 | 798 | 35 |
510811 | 510811 | 2020-09-07 | Columbia | Pennsylvania | 42037 | 791 | 35 |
507578 | 507578 | 2020-09-06 | Columbia | Pennsylvania | 42037 | 784 | 35 |
504346 | 504346 | 2020-09-05 | Columbia | Pennsylvania | 42037 | 776 | 35 |
501112 | 501112 | 2020-09-04 | Columbia | Pennsylvania | 42037 | 754 | 35 |
497878 | 497878 | 2020-09-03 | Columbia | Pennsylvania | 42037 | 728 | 35 |
494645 | 494645 | 2020-09-02 | Columbia | Pennsylvania | 42037 | 692 | 35 |
491411 | 491411 | 2020-09-01 | Columbia | Pennsylvania | 42037 | 675 | 35 |
488178 | 488178 | 2020-08-31 | Columbia | Pennsylvania | 42037 | 665 | 35 |
484945 | 484945 | 2020-08-30 | Columbia | Pennsylvania | 42037 | 659 | 35 |
481710 | 481710 | 2020-08-29 | Columbia | Pennsylvania | 42037 | 598 | 35 |
478476 | 478476 | 2020-08-28 | Columbia | Pennsylvania | 42037 | 580 | 35 |
475243 | 475243 | 2020-08-27 | Columbia | Pennsylvania | 42037 | 562 | 35 |
472009 | 472009 | 2020-08-26 | Columbia | Pennsylvania | 42037 | 546 | 35 |
468777 | 468777 | 2020-08-25 | Columbia | Pennsylvania | 42037 | 532 | 35 |
465549 | 465549 | 2020-08-24 | Columbia | Pennsylvania | 42037 | 527 | 35 |
462320 | 462320 | 2020-08-23 | Columbia | Pennsylvania | 42037 | 521 | 35 |
459092 | 459092 | 2020-08-22 | Columbia | Pennsylvania | 42037 | 514 | 35 |
455864 | 455864 | 2020-08-21 | Columbia | Pennsylvania | 42037 | 505 | 35 |
452636 | 452636 | 2020-08-20 | Columbia | Pennsylvania | 42037 | 499 | 35 |
449408 | 449408 | 2020-08-19 | Columbia | Pennsylvania | 42037 | 496 | 35 |
446180 | 446180 | 2020-08-18 | Columbia | Pennsylvania | 42037 | 496 | 35 |
442954 | 442954 | 2020-08-17 | Columbia | Pennsylvania | 42037 | 492 | 35 |
439727 | 439727 | 2020-08-16 | Columbia | Pennsylvania | 42037 | 491 | 35 |
436502 | 436502 | 2020-08-15 | Columbia | Pennsylvania | 42037 | 485 | 35 |
433275 | 433275 | 2020-08-14 | Columbia | Pennsylvania | 42037 | 483 | 35 |
430049 | 430049 | 2020-08-13 | Columbia | Pennsylvania | 42037 | 483 | 35 |
426824 | 426824 | 2020-08-12 | Columbia | Pennsylvania | 42037 | 481 | 35 |
423601 | 423601 | 2020-08-11 | Columbia | Pennsylvania | 42037 | 478 | 35 |
420378 | 420378 | 2020-08-10 | Columbia | Pennsylvania | 42037 | 477 | 35 |
417158 | 417158 | 2020-08-09 | Columbia | Pennsylvania | 42037 | 471 | 35 |
413937 | 413937 | 2020-08-08 | Columbia | Pennsylvania | 42037 | 471 | 35 |
410717 | 410717 | 2020-08-07 | Columbia | Pennsylvania | 42037 | 470 | 35 |
407497 | 407497 | 2020-08-06 | Columbia | Pennsylvania | 42037 | 470 | 35 |
404278 | 404278 | 2020-08-05 | Columbia | Pennsylvania | 42037 | 468 | 35 |
401060 | 401060 | 2020-08-04 | Columbia | Pennsylvania | 42037 | 464 | 35 |
397845 | 397845 | 2020-08-03 | Columbia | Pennsylvania | 42037 | 462 | 35 |
394628 | 394628 | 2020-08-02 | Columbia | Pennsylvania | 42037 | 461 | 35 |
391412 | 391412 | 2020-08-01 | Columbia | Pennsylvania | 42037 | 459 | 35 |
388195 | 388195 | 2020-07-31 | Columbia | Pennsylvania | 42037 | 457 | 35 |
384978 | 384978 | 2020-07-30 | Columbia | Pennsylvania | 42037 | 456 | 35 |
381760 | 381760 | 2020-07-29 | Columbia | Pennsylvania | 42037 | 453 | 35 |
378543 | 378543 | 2020-07-28 | Columbia | Pennsylvania | 42037 | 453 | 35 |
375327 | 375327 | 2020-07-27 | Columbia | Pennsylvania | 42037 | 452 | 35 |
372114 | 372114 | 2020-07-26 | Columbia | Pennsylvania | 42037 | 451 | 35 |
368902 | 368902 | 2020-07-25 | Columbia | Pennsylvania | 42037 | 446 | 35 |
365693 | 365693 | 2020-07-24 | Columbia | Pennsylvania | 42037 | 445 | 35 |
362487 | 362487 | 2020-07-23 | Columbia | Pennsylvania | 42037 | 443 | 35 |
359281 | 359281 | 2020-07-22 | Columbia | Pennsylvania | 42037 | 438 | 35 |
356077 | 356077 | 2020-07-21 | Columbia | Pennsylvania | 42037 | 436 | 35 |
352874 | 352874 | 2020-07-20 | Columbia | Pennsylvania | 42037 | 433 | 35 |
349671 | 349671 | 2020-07-19 | Columbia | Pennsylvania | 42037 | 430 | 35 |
346471 | 346471 | 2020-07-18 | Columbia | Pennsylvania | 42037 | 428 | 35 |
343271 | 343271 | 2020-07-17 | Columbia | Pennsylvania | 42037 | 428 | 35 |
340073 | 340073 | 2020-07-16 | Columbia | Pennsylvania | 42037 | 427 | 35 |
336876 | 336876 | 2020-07-15 | Columbia | Pennsylvania | 42037 | 424 | 35 |
333682 | 333682 | 2020-07-14 | Columbia | Pennsylvania | 42037 | 421 | 35 |
330490 | 330490 | 2020-07-13 | Columbia | Pennsylvania | 42037 | 420 | 35 |
327304 | 327304 | 2020-07-12 | Columbia | Pennsylvania | 42037 | 419 | 35 |
324119 | 324119 | 2020-07-11 | Columbia | Pennsylvania | 42037 | 419 | 35 |
320939 | 320939 | 2020-07-10 | Columbia | Pennsylvania | 42037 | 417 | 35 |
317761 | 317761 | 2020-07-09 | Columbia | Pennsylvania | 42037 | 416 | 35 |
314588 | 314588 | 2020-07-08 | Columbia | Pennsylvania | 42037 | 413 | 35 |
311416 | 311416 | 2020-07-07 | Columbia | Pennsylvania | 42037 | 412 | 34 |
308247 | 308247 | 2020-07-06 | Columbia | Pennsylvania | 42037 | 411 | 34 |
305080 | 305080 | 2020-07-05 | Columbia | Pennsylvania | 42037 | 411 | 34 |
301917 | 301917 | 2020-07-04 | Columbia | Pennsylvania | 42037 | 408 | 34 |
298753 | 298753 | 2020-07-03 | Columbia | Pennsylvania | 42037 | 407 | 34 |
295594 | 295594 | 2020-07-02 | Columbia | Pennsylvania | 42037 | 405 | 34 |
292438 | 292438 | 2020-07-01 | Columbia | Pennsylvania | 42037 | 403 | 34 |
289286 | 289286 | 2020-06-30 | Columbia | Pennsylvania | 42037 | 400 | 34 |
286135 | 286135 | 2020-06-29 | Columbia | Pennsylvania | 42037 | 400 | 33 |
282990 | 282990 | 2020-06-28 | Columbia | Pennsylvania | 42037 | 399 | 33 |
279844 | 279844 | 2020-06-27 | Columbia | Pennsylvania | 42037 | 399 | 33 |
276696 | 276696 | 2020-06-26 | Columbia | Pennsylvania | 42037 | 399 | 33 |
273549 | 273549 | 2020-06-25 | Columbia | Pennsylvania | 42037 | 399 | 33 |
270410 | 270410 | 2020-06-24 | Columbia | Pennsylvania | 42037 | 398 | 33 |
267276 | 267276 | 2020-06-23 | Columbia | Pennsylvania | 42037 | 397 | 33 |
264148 | 264148 | 2020-06-22 | Columbia | Pennsylvania | 42037 | 397 | 33 |
261020 | 261020 | 2020-06-21 | Columbia | Pennsylvania | 42037 | 392 | 33 |
257893 | 257893 | 2020-06-20 | Columbia | Pennsylvania | 42037 | 391 | 33 |
254767 | 254767 | 2020-06-19 | Columbia | Pennsylvania | 42037 | 390 | 33 |
251652 | 251652 | 2020-06-18 | Columbia | Pennsylvania | 42037 | 389 | 33 |
248537 | 248537 | 2020-06-17 | Columbia | Pennsylvania | 42037 | 387 | 33 |
245424 | 245424 | 2020-06-16 | Columbia | Pennsylvania | 42037 | 385 | 33 |
242312 | 242312 | 2020-06-15 | Columbia | Pennsylvania | 42037 | 380 | 33 |
239203 | 239203 | 2020-06-14 | Columbia | Pennsylvania | 42037 | 378 | 33 |
236095 | 236095 | 2020-06-13 | Columbia | Pennsylvania | 42037 | 376 | 33 |
232990 | 232990 | 2020-06-12 | Columbia | Pennsylvania | 42037 | 371 | 33 |
229885 | 229885 | 2020-06-11 | Columbia | Pennsylvania | 42037 | 369 | 33 |
226781 | 226781 | 2020-06-10 | Columbia | Pennsylvania | 42037 | 368 | 32 |
223681 | 223681 | 2020-06-09 | Columbia | Pennsylvania | 42037 | 367 | 31 |
220586 | 220586 | 2020-06-08 | Columbia | Pennsylvania | 42037 | 364 | 31 |
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);