ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Centre" and state = "Pennsylvania" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
282985 | 282985 | 2020-06-28 | Centre | Pennsylvania | 42027 | 201 | 7 |
286130 | 286130 | 2020-06-29 | Centre | Pennsylvania | 42027 | 201 | 7 |
289281 | 289281 | 2020-06-30 | Centre | Pennsylvania | 42027 | 201 | 7 |
292433 | 292433 | 2020-07-01 | Centre | Pennsylvania | 42027 | 205 | 7 |
295589 | 295589 | 2020-07-02 | Centre | Pennsylvania | 42027 | 211 | 7 |
298748 | 298748 | 2020-07-03 | Centre | Pennsylvania | 42027 | 218 | 7 |
301912 | 301912 | 2020-07-04 | Centre | Pennsylvania | 42027 | 224 | 7 |
305075 | 305075 | 2020-07-05 | Centre | Pennsylvania | 42027 | 227 | 8 |
308242 | 308242 | 2020-07-06 | Centre | Pennsylvania | 42027 | 228 | 8 |
311411 | 311411 | 2020-07-07 | Centre | Pennsylvania | 42027 | 230 | 8 |
314583 | 314583 | 2020-07-08 | Centre | Pennsylvania | 42027 | 232 | 8 |
317756 | 317756 | 2020-07-09 | Centre | Pennsylvania | 42027 | 235 | 8 |
320934 | 320934 | 2020-07-10 | Centre | Pennsylvania | 42027 | 239 | 8 |
324114 | 324114 | 2020-07-11 | Centre | Pennsylvania | 42027 | 241 | 8 |
327299 | 327299 | 2020-07-12 | Centre | Pennsylvania | 42027 | 243 | 8 |
330485 | 330485 | 2020-07-13 | Centre | Pennsylvania | 42027 | 251 | 8 |
333677 | 333677 | 2020-07-14 | Centre | Pennsylvania | 42027 | 253 | 8 |
336871 | 336871 | 2020-07-15 | Centre | Pennsylvania | 42027 | 262 | 8 |
340068 | 340068 | 2020-07-16 | Centre | Pennsylvania | 42027 | 262 | 9 |
343266 | 343266 | 2020-07-17 | Centre | Pennsylvania | 42027 | 270 | 9 |
346466 | 346466 | 2020-07-18 | Centre | Pennsylvania | 42027 | 277 | 9 |
349666 | 349666 | 2020-07-19 | Centre | Pennsylvania | 42027 | 279 | 9 |
352869 | 352869 | 2020-07-20 | Centre | Pennsylvania | 42027 | 288 | 9 |
356072 | 356072 | 2020-07-21 | Centre | Pennsylvania | 42027 | 294 | 9 |
359276 | 359276 | 2020-07-22 | Centre | Pennsylvania | 42027 | 299 | 9 |
362482 | 362482 | 2020-07-23 | Centre | Pennsylvania | 42027 | 304 | 9 |
365688 | 365688 | 2020-07-24 | Centre | Pennsylvania | 42027 | 306 | 9 |
368897 | 368897 | 2020-07-25 | Centre | Pennsylvania | 42027 | 313 | 9 |
372109 | 372109 | 2020-07-26 | Centre | Pennsylvania | 42027 | 356 | 9 |
375322 | 375322 | 2020-07-27 | Centre | Pennsylvania | 42027 | 357 | 9 |
378538 | 378538 | 2020-07-28 | Centre | Pennsylvania | 42027 | 365 | 10 |
381755 | 381755 | 2020-07-29 | Centre | Pennsylvania | 42027 | 370 | 10 |
384973 | 384973 | 2020-07-30 | Centre | Pennsylvania | 42027 | 353 | 10 |
388190 | 388190 | 2020-07-31 | Centre | Pennsylvania | 42027 | 357 | 10 |
391407 | 391407 | 2020-08-01 | Centre | Pennsylvania | 42027 | 354 | 10 |
394623 | 394623 | 2020-08-02 | Centre | Pennsylvania | 42027 | 357 | 10 |
397840 | 397840 | 2020-08-03 | Centre | Pennsylvania | 42027 | 358 | 10 |
401055 | 401055 | 2020-08-04 | Centre | Pennsylvania | 42027 | 359 | 10 |
404273 | 404273 | 2020-08-05 | Centre | Pennsylvania | 42027 | 361 | 10 |
407492 | 407492 | 2020-08-06 | Centre | Pennsylvania | 42027 | 364 | 10 |
410712 | 410712 | 2020-08-07 | Centre | Pennsylvania | 42027 | 368 | 10 |
413932 | 413932 | 2020-08-08 | Centre | Pennsylvania | 42027 | 370 | 10 |
417153 | 417153 | 2020-08-09 | Centre | Pennsylvania | 42027 | 372 | 10 |
420373 | 420373 | 2020-08-10 | Centre | Pennsylvania | 42027 | 372 | 10 |
423596 | 423596 | 2020-08-11 | Centre | Pennsylvania | 42027 | 373 | 10 |
426819 | 426819 | 2020-08-12 | Centre | Pennsylvania | 42027 | 377 | 10 |
430044 | 430044 | 2020-08-13 | Centre | Pennsylvania | 42027 | 380 | 10 |
433270 | 433270 | 2020-08-14 | Centre | Pennsylvania | 42027 | 386 | 11 |
436497 | 436497 | 2020-08-15 | Centre | Pennsylvania | 42027 | 391 | 11 |
439722 | 439722 | 2020-08-16 | Centre | Pennsylvania | 42027 | 392 | 11 |
442949 | 442949 | 2020-08-17 | Centre | Pennsylvania | 42027 | 393 | 11 |
446175 | 446175 | 2020-08-18 | Centre | Pennsylvania | 42027 | 399 | 11 |
449403 | 449403 | 2020-08-19 | Centre | Pennsylvania | 42027 | 406 | 11 |
452631 | 452631 | 2020-08-20 | Centre | Pennsylvania | 42027 | 407 | 11 |
455859 | 455859 | 2020-08-21 | Centre | Pennsylvania | 42027 | 410 | 11 |
459087 | 459087 | 2020-08-22 | Centre | Pennsylvania | 42027 | 415 | 11 |
462315 | 462315 | 2020-08-23 | Centre | Pennsylvania | 42027 | 417 | 11 |
465544 | 465544 | 2020-08-24 | Centre | Pennsylvania | 42027 | 423 | 11 |
468772 | 468772 | 2020-08-25 | Centre | Pennsylvania | 42027 | 427 | 11 |
472004 | 472004 | 2020-08-26 | Centre | Pennsylvania | 42027 | 429 | 11 |
475238 | 475238 | 2020-08-27 | Centre | Pennsylvania | 42027 | 433 | 11 |
478471 | 478471 | 2020-08-28 | Centre | Pennsylvania | 42027 | 442 | 11 |
481705 | 481705 | 2020-08-29 | Centre | Pennsylvania | 42027 | 462 | 11 |
484940 | 484940 | 2020-08-30 | Centre | Pennsylvania | 42027 | 469 | 11 |
488173 | 488173 | 2020-08-31 | Centre | Pennsylvania | 42027 | 486 | 11 |
491406 | 491406 | 2020-09-01 | Centre | Pennsylvania | 42027 | 491 | 11 |
494640 | 494640 | 2020-09-02 | Centre | Pennsylvania | 42027 | 538 | 11 |
497873 | 497873 | 2020-09-03 | Centre | Pennsylvania | 42027 | 578 | 11 |
501107 | 501107 | 2020-09-04 | Centre | Pennsylvania | 42027 | 615 | 11 |
504341 | 504341 | 2020-09-05 | Centre | Pennsylvania | 42027 | 652 | 11 |
507573 | 507573 | 2020-09-06 | Centre | Pennsylvania | 42027 | 661 | 11 |
510806 | 510806 | 2020-09-07 | Centre | Pennsylvania | 42027 | 674 | 11 |
514039 | 514039 | 2020-09-08 | Centre | Pennsylvania | 42027 | 686 | 11 |
517274 | 517274 | 2020-09-09 | Centre | Pennsylvania | 42027 | 870 | 11 |
520510 | 520510 | 2020-09-10 | Centre | Pennsylvania | 42027 | 925 | 11 |
523746 | 523746 | 2020-09-11 | Centre | Pennsylvania | 42027 | 1062 | 11 |
526982 | 526982 | 2020-09-12 | Centre | Pennsylvania | 42027 | 1135 | 11 |
530219 | 530219 | 2020-09-13 | Centre | Pennsylvania | 42027 | 1135 | 11 |
533454 | 533454 | 2020-09-14 | Centre | Pennsylvania | 42027 | 1237 | 11 |
536690 | 536690 | 2020-09-15 | Centre | Pennsylvania | 42027 | 1449 | 11 |
539927 | 539927 | 2020-09-16 | Centre | Pennsylvania | 42027 | 1508 | 11 |
543163 | 543163 | 2020-09-17 | Centre | Pennsylvania | 42027 | 1600 | 11 |
546400 | 546400 | 2020-09-18 | Centre | Pennsylvania | 42027 | 1630 | 11 |
549639 | 549639 | 2020-09-19 | Centre | Pennsylvania | 42027 | 1727 | 11 |
552878 | 552878 | 2020-09-20 | Centre | Pennsylvania | 42027 | 1799 | 11 |
556115 | 556115 | 2020-09-21 | Centre | Pennsylvania | 42027 | 1836 | 11 |
559352 | 559352 | 2020-09-22 | Centre | Pennsylvania | 42027 | 2031 | 11 |
562589 | 562589 | 2020-09-23 | Centre | Pennsylvania | 42027 | 2078 | 11 |
565830 | 565830 | 2020-09-24 | Centre | Pennsylvania | 42027 | 2202 | 11 |
569071 | 569071 | 2020-09-25 | Centre | Pennsylvania | 42027 | 2231 | 11 |
572313 | 572313 | 2020-09-26 | Centre | Pennsylvania | 42027 | 2393 | 11 |
575557 | 575557 | 2020-09-27 | Centre | Pennsylvania | 42027 | 2481 | 11 |
578798 | 578798 | 2020-09-28 | Centre | Pennsylvania | 42027 | 2551 | 11 |
582038 | 582038 | 2020-09-29 | Centre | Pennsylvania | 42027 | 2667 | 11 |
585278 | 585278 | 2020-09-30 | Centre | Pennsylvania | 42027 | 2710 | 11 |
588518 | 588518 | 2020-10-01 | Centre | Pennsylvania | 42027 | 2755 | 11 |
591759 | 591759 | 2020-10-02 | Centre | Pennsylvania | 42027 | 2854 | 11 |
595000 | 595000 | 2020-10-03 | Centre | Pennsylvania | 42027 | 2854 | 11 |
598243 | 598243 | 2020-10-04 | Centre | Pennsylvania | 42027 | 3024 | 11 |
601486 | 601486 | 2020-10-05 | Centre | Pennsylvania | 42027 | 3044 | 11 |
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);