ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36027 and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636742 | 636742 | 2020-10-16 | Dutchess | New York | 36027 | 5305 | 163 |
633496 | 633496 | 2020-10-15 | Dutchess | New York | 36027 | 5289 | 163 |
630251 | 630251 | 2020-10-14 | Dutchess | New York | 36027 | 5281 | 163 |
627007 | 627007 | 2020-10-13 | Dutchess | New York | 36027 | 5271 | 163 |
623765 | 623765 | 2020-10-12 | Dutchess | New York | 36027 | 5259 | 162 |
620522 | 620522 | 2020-10-11 | Dutchess | New York | 36027 | 5252 | 162 |
617280 | 617280 | 2020-10-10 | Dutchess | New York | 36027 | 5245 | 161 |
614038 | 614038 | 2020-10-09 | Dutchess | New York | 36027 | 5233 | 161 |
610797 | 610797 | 2020-10-08 | Dutchess | New York | 36027 | 5222 | 161 |
607555 | 607555 | 2020-10-07 | Dutchess | New York | 36027 | 5214 | 161 |
604312 | 604312 | 2020-10-06 | Dutchess | New York | 36027 | 5205 | 160 |
601070 | 601070 | 2020-10-05 | Dutchess | New York | 36027 | 5187 | 160 |
597827 | 597827 | 2020-10-04 | Dutchess | New York | 36027 | 5179 | 158 |
594584 | 594584 | 2020-10-03 | Dutchess | New York | 36027 | 5169 | 158 |
591343 | 591343 | 2020-10-02 | Dutchess | New York | 36027 | 5165 | 157 |
588102 | 588102 | 2020-10-01 | Dutchess | New York | 36027 | 5148 | 157 |
584862 | 584862 | 2020-09-30 | Dutchess | New York | 36027 | 5137 | 156 |
581621 | 581621 | 2020-09-29 | Dutchess | New York | 36027 | 5130 | 156 |
578381 | 578381 | 2020-09-28 | Dutchess | New York | 36027 | 5124 | 156 |
575140 | 575140 | 2020-09-27 | Dutchess | New York | 36027 | 5120 | 156 |
571896 | 571896 | 2020-09-26 | Dutchess | New York | 36027 | 5115 | 156 |
568654 | 568654 | 2020-09-25 | Dutchess | New York | 36027 | 5108 | 156 |
565413 | 565413 | 2020-09-24 | Dutchess | New York | 36027 | 5105 | 156 |
562172 | 562172 | 2020-09-23 | Dutchess | New York | 36027 | 5089 | 156 |
558935 | 558935 | 2020-09-22 | Dutchess | New York | 36027 | 5084 | 156 |
555698 | 555698 | 2020-09-21 | Dutchess | New York | 36027 | 5076 | 156 |
552461 | 552461 | 2020-09-20 | Dutchess | New York | 36027 | 5059 | 156 |
549222 | 549222 | 2020-09-19 | Dutchess | New York | 36027 | 5053 | 156 |
545983 | 545983 | 2020-09-18 | Dutchess | New York | 36027 | 5050 | 156 |
542746 | 542746 | 2020-09-17 | Dutchess | New York | 36027 | 5042 | 156 |
539510 | 539510 | 2020-09-16 | Dutchess | New York | 36027 | 5014 | 156 |
536273 | 536273 | 2020-09-15 | Dutchess | New York | 36027 | 5006 | 155 |
533037 | 533037 | 2020-09-14 | Dutchess | New York | 36027 | 4994 | 154 |
529802 | 529802 | 2020-09-13 | Dutchess | New York | 36027 | 4986 | 154 |
526565 | 526565 | 2020-09-12 | Dutchess | New York | 36027 | 4984 | 154 |
523329 | 523329 | 2020-09-11 | Dutchess | New York | 36027 | 4975 | 154 |
520093 | 520093 | 2020-09-10 | Dutchess | New York | 36027 | 4962 | 154 |
516857 | 516857 | 2020-09-09 | Dutchess | New York | 36027 | 4956 | 154 |
513622 | 513622 | 2020-09-08 | Dutchess | New York | 36027 | 4944 | 153 |
510389 | 510389 | 2020-09-07 | Dutchess | New York | 36027 | 4939 | 153 |
507156 | 507156 | 2020-09-06 | Dutchess | New York | 36027 | 4928 | 153 |
503924 | 503924 | 2020-09-05 | Dutchess | New York | 36027 | 4914 | 153 |
500690 | 500690 | 2020-09-04 | Dutchess | New York | 36027 | 4902 | 153 |
497456 | 497456 | 2020-09-03 | Dutchess | New York | 36027 | 4892 | 153 |
494223 | 494223 | 2020-09-02 | Dutchess | New York | 36027 | 4878 | 153 |
490989 | 490989 | 2020-09-01 | Dutchess | New York | 36027 | 4868 | 153 |
487756 | 487756 | 2020-08-31 | Dutchess | New York | 36027 | 4865 | 153 |
484523 | 484523 | 2020-08-30 | Dutchess | New York | 36027 | 4852 | 153 |
481288 | 481288 | 2020-08-29 | Dutchess | New York | 36027 | 4846 | 153 |
478055 | 478055 | 2020-08-28 | Dutchess | New York | 36027 | 4827 | 153 |
474822 | 474822 | 2020-08-27 | Dutchess | New York | 36027 | 4815 | 153 |
471588 | 471588 | 2020-08-26 | Dutchess | New York | 36027 | 4798 | 153 |
468356 | 468356 | 2020-08-25 | Dutchess | New York | 36027 | 4790 | 153 |
465128 | 465128 | 2020-08-24 | Dutchess | New York | 36027 | 4777 | 153 |
461899 | 461899 | 2020-08-23 | Dutchess | New York | 36027 | 4767 | 153 |
458671 | 458671 | 2020-08-22 | Dutchess | New York | 36027 | 4753 | 153 |
455443 | 455443 | 2020-08-21 | Dutchess | New York | 36027 | 4734 | 153 |
452215 | 452215 | 2020-08-20 | Dutchess | New York | 36027 | 4721 | 153 |
448987 | 448987 | 2020-08-19 | Dutchess | New York | 36027 | 4710 | 153 |
445759 | 445759 | 2020-08-18 | Dutchess | New York | 36027 | 4704 | 153 |
442533 | 442533 | 2020-08-17 | Dutchess | New York | 36027 | 4700 | 153 |
439306 | 439306 | 2020-08-16 | Dutchess | New York | 36027 | 4686 | 153 |
436081 | 436081 | 2020-08-15 | Dutchess | New York | 36027 | 4668 | 153 |
432855 | 432855 | 2020-08-14 | Dutchess | New York | 36027 | 4655 | 153 |
429629 | 429629 | 2020-08-13 | Dutchess | New York | 36027 | 4640 | 153 |
426404 | 426404 | 2020-08-12 | Dutchess | New York | 36027 | 4631 | 153 |
423181 | 423181 | 2020-08-11 | Dutchess | New York | 36027 | 4619 | 153 |
419958 | 419958 | 2020-08-10 | Dutchess | New York | 36027 | 4613 | 153 |
416738 | 416738 | 2020-08-09 | Dutchess | New York | 36027 | 4607 | 153 |
413517 | 413517 | 2020-08-08 | Dutchess | New York | 36027 | 4600 | 153 |
410297 | 410297 | 2020-08-07 | Dutchess | New York | 36027 | 4589 | 153 |
407077 | 407077 | 2020-08-06 | Dutchess | New York | 36027 | 4582 | 153 |
403858 | 403858 | 2020-08-05 | Dutchess | New York | 36027 | 4568 | 162 |
400640 | 400640 | 2020-08-04 | Dutchess | New York | 36027 | 4557 | 162 |
397425 | 397425 | 2020-08-03 | Dutchess | New York | 36027 | 4543 | 162 |
394208 | 394208 | 2020-08-02 | Dutchess | New York | 36027 | 4520 | 162 |
390992 | 390992 | 2020-08-01 | Dutchess | New York | 36027 | 4504 | 162 |
387775 | 387775 | 2020-07-31 | Dutchess | New York | 36027 | 4490 | 162 |
384558 | 384558 | 2020-07-30 | Dutchess | New York | 36027 | 4468 | 162 |
381340 | 381340 | 2020-07-29 | Dutchess | New York | 36027 | 4453 | 162 |
378123 | 378123 | 2020-07-28 | Dutchess | New York | 36027 | 4447 | 162 |
374907 | 374907 | 2020-07-27 | Dutchess | New York | 36027 | 4440 | 162 |
371695 | 371695 | 2020-07-26 | Dutchess | New York | 36027 | 4425 | 162 |
368483 | 368483 | 2020-07-25 | Dutchess | New York | 36027 | 4412 | 162 |
365274 | 365274 | 2020-07-24 | Dutchess | New York | 36027 | 4408 | 162 |
362068 | 362068 | 2020-07-23 | Dutchess | New York | 36027 | 4400 | 162 |
358862 | 358862 | 2020-07-22 | Dutchess | New York | 36027 | 4387 | 161 |
355658 | 355658 | 2020-07-21 | Dutchess | New York | 36027 | 4380 | 161 |
352455 | 352455 | 2020-07-20 | Dutchess | New York | 36027 | 4376 | 161 |
349252 | 349252 | 2020-07-19 | Dutchess | New York | 36027 | 4376 | 161 |
346051 | 346051 | 2020-07-18 | Dutchess | New York | 36027 | 4373 | 161 |
342852 | 342852 | 2020-07-17 | Dutchess | New York | 36027 | 4363 | 161 |
339654 | 339654 | 2020-07-16 | Dutchess | New York | 36027 | 4357 | 160 |
336458 | 336458 | 2020-07-15 | Dutchess | New York | 36027 | 4337 | 160 |
333264 | 333264 | 2020-07-14 | Dutchess | New York | 36027 | 4318 | 160 |
330074 | 330074 | 2020-07-13 | Dutchess | New York | 36027 | 4280 | 160 |
326887 | 326887 | 2020-07-12 | Dutchess | New York | 36027 | 4276 | 160 |
323703 | 323703 | 2020-07-11 | Dutchess | New York | 36027 | 4269 | 160 |
320523 | 320523 | 2020-07-10 | Dutchess | New York | 36027 | 4262 | 160 |
317346 | 317346 | 2020-07-09 | Dutchess | New York | 36027 | 4255 | 160 |
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);