ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Lawrence" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637182 | 637182 | 2020-10-16 | Lawrence | Pennsylvania | 42073 | 685 | 24 |
633936 | 633936 | 2020-10-15 | Lawrence | Pennsylvania | 42073 | 681 | 24 |
630691 | 630691 | 2020-10-14 | Lawrence | Pennsylvania | 42073 | 653 | 24 |
627447 | 627447 | 2020-10-13 | Lawrence | Pennsylvania | 42073 | 643 | 23 |
624205 | 624205 | 2020-10-12 | Lawrence | Pennsylvania | 42073 | 628 | 23 |
620962 | 620962 | 2020-10-11 | Lawrence | Pennsylvania | 42073 | 622 | 23 |
617719 | 617719 | 2020-10-10 | Lawrence | Pennsylvania | 42073 | 608 | 23 |
614477 | 614477 | 2020-10-09 | Lawrence | Pennsylvania | 42073 | 602 | 23 |
611236 | 611236 | 2020-10-08 | Lawrence | Pennsylvania | 42073 | 593 | 23 |
607994 | 607994 | 2020-10-07 | Lawrence | Pennsylvania | 42073 | 568 | 23 |
604751 | 604751 | 2020-10-06 | Lawrence | Pennsylvania | 42073 | 564 | 22 |
601509 | 601509 | 2020-10-05 | Lawrence | Pennsylvania | 42073 | 562 | 22 |
598266 | 598266 | 2020-10-04 | Lawrence | Pennsylvania | 42073 | 559 | 22 |
595023 | 595023 | 2020-10-03 | Lawrence | Pennsylvania | 42073 | 548 | 22 |
591782 | 591782 | 2020-10-02 | Lawrence | Pennsylvania | 42073 | 548 | 23 |
588541 | 588541 | 2020-10-01 | Lawrence | Pennsylvania | 42073 | 540 | 23 |
585301 | 585301 | 2020-09-30 | Lawrence | Pennsylvania | 42073 | 531 | 23 |
582061 | 582061 | 2020-09-29 | Lawrence | Pennsylvania | 42073 | 531 | 23 |
578821 | 578821 | 2020-09-28 | Lawrence | Pennsylvania | 42073 | 531 | 23 |
575580 | 575580 | 2020-09-27 | Lawrence | Pennsylvania | 42073 | 519 | 23 |
572336 | 572336 | 2020-09-26 | Lawrence | Pennsylvania | 42073 | 517 | 23 |
569094 | 569094 | 2020-09-25 | Lawrence | Pennsylvania | 42073 | 510 | 23 |
565853 | 565853 | 2020-09-24 | Lawrence | Pennsylvania | 42073 | 509 | 23 |
562612 | 562612 | 2020-09-23 | Lawrence | Pennsylvania | 42073 | 505 | 23 |
559375 | 559375 | 2020-09-22 | Lawrence | Pennsylvania | 42073 | 501 | 23 |
556138 | 556138 | 2020-09-21 | Lawrence | Pennsylvania | 42073 | 499 | 22 |
552901 | 552901 | 2020-09-20 | Lawrence | Pennsylvania | 42073 | 499 | 22 |
549662 | 549662 | 2020-09-19 | Lawrence | Pennsylvania | 42073 | 499 | 22 |
546423 | 546423 | 2020-09-18 | Lawrence | Pennsylvania | 42073 | 495 | 22 |
543186 | 543186 | 2020-09-17 | Lawrence | Pennsylvania | 42073 | 492 | 22 |
539950 | 539950 | 2020-09-16 | Lawrence | Pennsylvania | 42073 | 490 | 22 |
536713 | 536713 | 2020-09-15 | Lawrence | Pennsylvania | 42073 | 487 | 21 |
533477 | 533477 | 2020-09-14 | Lawrence | Pennsylvania | 42073 | 487 | 21 |
530242 | 530242 | 2020-09-13 | Lawrence | Pennsylvania | 42073 | 481 | 21 |
527005 | 527005 | 2020-09-12 | Lawrence | Pennsylvania | 42073 | 481 | 21 |
523769 | 523769 | 2020-09-11 | Lawrence | Pennsylvania | 42073 | 480 | 21 |
520533 | 520533 | 2020-09-10 | Lawrence | Pennsylvania | 42073 | 480 | 21 |
517297 | 517297 | 2020-09-09 | Lawrence | Pennsylvania | 42073 | 479 | 21 |
514062 | 514062 | 2020-09-08 | Lawrence | Pennsylvania | 42073 | 474 | 21 |
510829 | 510829 | 2020-09-07 | Lawrence | Pennsylvania | 42073 | 474 | 21 |
507596 | 507596 | 2020-09-06 | Lawrence | Pennsylvania | 42073 | 474 | 20 |
504364 | 504364 | 2020-09-05 | Lawrence | Pennsylvania | 42073 | 474 | 20 |
501130 | 501130 | 2020-09-04 | Lawrence | Pennsylvania | 42073 | 470 | 19 |
497896 | 497896 | 2020-09-03 | Lawrence | Pennsylvania | 42073 | 468 | 18 |
494663 | 494663 | 2020-09-02 | Lawrence | Pennsylvania | 42073 | 466 | 18 |
491429 | 491429 | 2020-09-01 | Lawrence | Pennsylvania | 42073 | 464 | 18 |
488196 | 488196 | 2020-08-31 | Lawrence | Pennsylvania | 42073 | 459 | 18 |
484963 | 484963 | 2020-08-30 | Lawrence | Pennsylvania | 42073 | 455 | 18 |
481728 | 481728 | 2020-08-29 | Lawrence | Pennsylvania | 42073 | 454 | 18 |
478494 | 478494 | 2020-08-28 | Lawrence | Pennsylvania | 42073 | 453 | 18 |
475261 | 475261 | 2020-08-27 | Lawrence | Pennsylvania | 42073 | 450 | 18 |
472027 | 472027 | 2020-08-26 | Lawrence | Pennsylvania | 42073 | 445 | 18 |
468795 | 468795 | 2020-08-25 | Lawrence | Pennsylvania | 42073 | 443 | 17 |
465567 | 465567 | 2020-08-24 | Lawrence | Pennsylvania | 42073 | 441 | 17 |
462338 | 462338 | 2020-08-23 | Lawrence | Pennsylvania | 42073 | 441 | 17 |
459110 | 459110 | 2020-08-22 | Lawrence | Pennsylvania | 42073 | 439 | 17 |
455882 | 455882 | 2020-08-21 | Lawrence | Pennsylvania | 42073 | 436 | 16 |
452654 | 452654 | 2020-08-20 | Lawrence | Pennsylvania | 42073 | 433 | 16 |
449426 | 449426 | 2020-08-19 | Lawrence | Pennsylvania | 42073 | 431 | 16 |
446198 | 446198 | 2020-08-18 | Lawrence | Pennsylvania | 42073 | 429 | 16 |
442972 | 442972 | 2020-08-17 | Lawrence | Pennsylvania | 42073 | 429 | 16 |
439745 | 439745 | 2020-08-16 | Lawrence | Pennsylvania | 42073 | 423 | 16 |
436520 | 436520 | 2020-08-15 | Lawrence | Pennsylvania | 42073 | 422 | 16 |
433293 | 433293 | 2020-08-14 | Lawrence | Pennsylvania | 42073 | 420 | 16 |
430067 | 430067 | 2020-08-13 | Lawrence | Pennsylvania | 42073 | 414 | 16 |
426842 | 426842 | 2020-08-12 | Lawrence | Pennsylvania | 42073 | 401 | 16 |
423619 | 423619 | 2020-08-11 | Lawrence | Pennsylvania | 42073 | 392 | 16 |
420396 | 420396 | 2020-08-10 | Lawrence | Pennsylvania | 42073 | 392 | 16 |
417176 | 417176 | 2020-08-09 | Lawrence | Pennsylvania | 42073 | 391 | 16 |
413955 | 413955 | 2020-08-08 | Lawrence | Pennsylvania | 42073 | 390 | 16 |
410735 | 410735 | 2020-08-07 | Lawrence | Pennsylvania | 42073 | 389 | 15 |
407515 | 407515 | 2020-08-06 | Lawrence | Pennsylvania | 42073 | 383 | 14 |
404296 | 404296 | 2020-08-05 | Lawrence | Pennsylvania | 42073 | 359 | 12 |
401078 | 401078 | 2020-08-04 | Lawrence | Pennsylvania | 42073 | 353 | 12 |
397863 | 397863 | 2020-08-03 | Lawrence | Pennsylvania | 42073 | 349 | 12 |
394646 | 394646 | 2020-08-02 | Lawrence | Pennsylvania | 42073 | 343 | 12 |
391430 | 391430 | 2020-08-01 | Lawrence | Pennsylvania | 42073 | 338 | 12 |
388213 | 388213 | 2020-07-31 | Lawrence | Pennsylvania | 42073 | 338 | 11 |
384996 | 384996 | 2020-07-30 | Lawrence | Pennsylvania | 42073 | 324 | 11 |
381778 | 381778 | 2020-07-29 | Lawrence | Pennsylvania | 42073 | 319 | 11 |
378561 | 378561 | 2020-07-28 | Lawrence | Pennsylvania | 42073 | 308 | 11 |
375345 | 375345 | 2020-07-27 | Lawrence | Pennsylvania | 42073 | 291 | 11 |
372132 | 372132 | 2020-07-26 | Lawrence | Pennsylvania | 42073 | 288 | 11 |
368920 | 368920 | 2020-07-25 | Lawrence | Pennsylvania | 42073 | 280 | 11 |
365711 | 365711 | 2020-07-24 | Lawrence | Pennsylvania | 42073 | 272 | 11 |
362505 | 362505 | 2020-07-23 | Lawrence | Pennsylvania | 42073 | 261 | 9 |
359299 | 359299 | 2020-07-22 | Lawrence | Pennsylvania | 42073 | 257 | 9 |
356095 | 356095 | 2020-07-21 | Lawrence | Pennsylvania | 42073 | 243 | 9 |
352892 | 352892 | 2020-07-20 | Lawrence | Pennsylvania | 42073 | 235 | 9 |
349689 | 349689 | 2020-07-19 | Lawrence | Pennsylvania | 42073 | 226 | 9 |
346489 | 346489 | 2020-07-18 | Lawrence | Pennsylvania | 42073 | 225 | 9 |
343289 | 343289 | 2020-07-17 | Lawrence | Pennsylvania | 42073 | 221 | 9 |
340091 | 340091 | 2020-07-16 | Lawrence | Pennsylvania | 42073 | 209 | 9 |
336894 | 336894 | 2020-07-15 | Lawrence | Pennsylvania | 42073 | 207 | 9 |
333700 | 333700 | 2020-07-14 | Lawrence | Pennsylvania | 42073 | 200 | 9 |
330508 | 330508 | 2020-07-13 | Lawrence | Pennsylvania | 42073 | 197 | 9 |
327322 | 327322 | 2020-07-12 | Lawrence | Pennsylvania | 42073 | 174 | 9 |
324137 | 324137 | 2020-07-11 | Lawrence | Pennsylvania | 42073 | 171 | 9 |
320957 | 320957 | 2020-07-10 | Lawrence | Pennsylvania | 42073 | 159 | 9 |
317779 | 317779 | 2020-07-09 | Lawrence | Pennsylvania | 42073 | 146 | 9 |
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);