ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 36093 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 |
---|---|---|---|---|---|---|---|
636771 | 636771 | 2020-10-16 | Schenectady | New York | 36093 | 1485 | 48 |
633525 | 633525 | 2020-10-15 | Schenectady | New York | 36093 | 1477 | 48 |
630280 | 630280 | 2020-10-14 | Schenectady | New York | 36093 | 1464 | 47 |
627036 | 627036 | 2020-10-13 | Schenectady | New York | 36093 | 1461 | 47 |
623794 | 623794 | 2020-10-12 | Schenectady | New York | 36093 | 1459 | 47 |
620551 | 620551 | 2020-10-11 | Schenectady | New York | 36093 | 1454 | 47 |
617309 | 617309 | 2020-10-10 | Schenectady | New York | 36093 | 1451 | 47 |
614067 | 614067 | 2020-10-09 | Schenectady | New York | 36093 | 1445 | 47 |
610826 | 610826 | 2020-10-08 | Schenectady | New York | 36093 | 1438 | 47 |
607584 | 607584 | 2020-10-07 | Schenectady | New York | 36093 | 1432 | 47 |
604341 | 604341 | 2020-10-06 | Schenectady | New York | 36093 | 1430 | 47 |
601099 | 601099 | 2020-10-05 | Schenectady | New York | 36093 | 1429 | 47 |
597856 | 597856 | 2020-10-04 | Schenectady | New York | 36093 | 1429 | 47 |
594613 | 594613 | 2020-10-03 | Schenectady | New York | 36093 | 1425 | 46 |
591372 | 591372 | 2020-10-02 | Schenectady | New York | 36093 | 1420 | 46 |
588131 | 588131 | 2020-10-01 | Schenectady | New York | 36093 | 1417 | 46 |
584891 | 584891 | 2020-09-30 | Schenectady | New York | 36093 | 1410 | 46 |
581650 | 581650 | 2020-09-29 | Schenectady | New York | 36093 | 1405 | 46 |
578410 | 578410 | 2020-09-28 | Schenectady | New York | 36093 | 1403 | 46 |
575169 | 575169 | 2020-09-27 | Schenectady | New York | 36093 | 1402 | 46 |
571925 | 571925 | 2020-09-26 | Schenectady | New York | 36093 | 1399 | 46 |
568683 | 568683 | 2020-09-25 | Schenectady | New York | 36093 | 1398 | 46 |
565442 | 565442 | 2020-09-24 | Schenectady | New York | 36093 | 1395 | 46 |
562201 | 562201 | 2020-09-23 | Schenectady | New York | 36093 | 1388 | 46 |
558964 | 558964 | 2020-09-22 | Schenectady | New York | 36093 | 1383 | 46 |
555727 | 555727 | 2020-09-21 | Schenectady | New York | 36093 | 1383 | 46 |
552490 | 552490 | 2020-09-20 | Schenectady | New York | 36093 | 1380 | 46 |
549251 | 549251 | 2020-09-19 | Schenectady | New York | 36093 | 1377 | 46 |
546012 | 546012 | 2020-09-18 | Schenectady | New York | 36093 | 1374 | 46 |
542775 | 542775 | 2020-09-17 | Schenectady | New York | 36093 | 1372 | 46 |
539539 | 539539 | 2020-09-16 | Schenectady | New York | 36093 | 1362 | 46 |
536302 | 536302 | 2020-09-15 | Schenectady | New York | 36093 | 1358 | 46 |
533066 | 533066 | 2020-09-14 | Schenectady | New York | 36093 | 1357 | 46 |
529831 | 529831 | 2020-09-13 | Schenectady | New York | 36093 | 1356 | 46 |
526594 | 526594 | 2020-09-12 | Schenectady | New York | 36093 | 1351 | 46 |
523358 | 523358 | 2020-09-11 | Schenectady | New York | 36093 | 1343 | 46 |
520122 | 520122 | 2020-09-10 | Schenectady | New York | 36093 | 1335 | 46 |
516886 | 516886 | 2020-09-09 | Schenectady | New York | 36093 | 1324 | 46 |
513651 | 513651 | 2020-09-08 | Schenectady | New York | 36093 | 1322 | 46 |
510418 | 510418 | 2020-09-07 | Schenectady | New York | 36093 | 1314 | 45 |
507185 | 507185 | 2020-09-06 | Schenectady | New York | 36093 | 1310 | 45 |
503953 | 503953 | 2020-09-05 | Schenectady | New York | 36093 | 1299 | 44 |
500719 | 500719 | 2020-09-04 | Schenectady | New York | 36093 | 1298 | 44 |
497485 | 497485 | 2020-09-03 | Schenectady | New York | 36093 | 1290 | 44 |
494252 | 494252 | 2020-09-02 | Schenectady | New York | 36093 | 1278 | 43 |
491018 | 491018 | 2020-09-01 | Schenectady | New York | 36093 | 1271 | 43 |
487785 | 487785 | 2020-08-31 | Schenectady | New York | 36093 | 1263 | 43 |
484552 | 484552 | 2020-08-30 | Schenectady | New York | 36093 | 1260 | 43 |
481317 | 481317 | 2020-08-29 | Schenectady | New York | 36093 | 1255 | 42 |
478084 | 478084 | 2020-08-28 | Schenectady | New York | 36093 | 1233 | 42 |
474851 | 474851 | 2020-08-27 | Schenectady | New York | 36093 | 1231 | 41 |
471617 | 471617 | 2020-08-26 | Schenectady | New York | 36093 | 1211 | 41 |
468385 | 468385 | 2020-08-25 | Schenectady | New York | 36093 | 1206 | 41 |
465157 | 465157 | 2020-08-24 | Schenectady | New York | 36093 | 1182 | 41 |
461928 | 461928 | 2020-08-23 | Schenectady | New York | 36093 | 1179 | 41 |
458700 | 458700 | 2020-08-22 | Schenectady | New York | 36093 | 1172 | 41 |
455472 | 455472 | 2020-08-21 | Schenectady | New York | 36093 | 1159 | 41 |
452244 | 452244 | 2020-08-20 | Schenectady | New York | 36093 | 1143 | 41 |
449016 | 449016 | 2020-08-19 | Schenectady | New York | 36093 | 1133 | 41 |
445788 | 445788 | 2020-08-18 | Schenectady | New York | 36093 | 1130 | 41 |
442562 | 442562 | 2020-08-17 | Schenectady | New York | 36093 | 1121 | 41 |
439335 | 439335 | 2020-08-16 | Schenectady | New York | 36093 | 1119 | 41 |
436110 | 436110 | 2020-08-15 | Schenectady | New York | 36093 | 1101 | 41 |
432884 | 432884 | 2020-08-14 | Schenectady | New York | 36093 | 1092 | 40 |
429658 | 429658 | 2020-08-13 | Schenectady | New York | 36093 | 1084 | 40 |
426433 | 426433 | 2020-08-12 | Schenectady | New York | 36093 | 1079 | 40 |
423210 | 423210 | 2020-08-11 | Schenectady | New York | 36093 | 1075 | 40 |
419987 | 419987 | 2020-08-10 | Schenectady | New York | 36093 | 1060 | 40 |
416767 | 416767 | 2020-08-09 | Schenectady | New York | 36093 | 1058 | 40 |
413546 | 413546 | 2020-08-08 | Schenectady | New York | 36093 | 1058 | 40 |
410326 | 410326 | 2020-08-07 | Schenectady | New York | 36093 | 1055 | 40 |
407106 | 407106 | 2020-08-06 | Schenectady | New York | 36093 | 1050 | 40 |
403887 | 403887 | 2020-08-05 | Schenectady | New York | 36093 | 1045 | 38 |
400669 | 400669 | 2020-08-04 | Schenectady | New York | 36093 | 1041 | 37 |
397454 | 397454 | 2020-08-03 | Schenectady | New York | 36093 | 1037 | 37 |
394237 | 394237 | 2020-08-02 | Schenectady | New York | 36093 | 1035 | 37 |
391021 | 391021 | 2020-08-01 | Schenectady | New York | 36093 | 1032 | 37 |
387804 | 387804 | 2020-07-31 | Schenectady | New York | 36093 | 1023 | 37 |
384587 | 384587 | 2020-07-30 | Schenectady | New York | 36093 | 1018 | 36 |
381369 | 381369 | 2020-07-29 | Schenectady | New York | 36093 | 1010 | 36 |
378152 | 378152 | 2020-07-28 | Schenectady | New York | 36093 | 998 | 36 |
374936 | 374936 | 2020-07-27 | Schenectady | New York | 36093 | 990 | 36 |
371724 | 371724 | 2020-07-26 | Schenectady | New York | 36093 | 987 | 36 |
368512 | 368512 | 2020-07-25 | Schenectady | New York | 36093 | 975 | 36 |
365303 | 365303 | 2020-07-24 | Schenectady | New York | 36093 | 955 | 36 |
362097 | 362097 | 2020-07-23 | Schenectady | New York | 36093 | 946 | 34 |
358891 | 358891 | 2020-07-22 | Schenectady | New York | 36093 | 936 | 34 |
355687 | 355687 | 2020-07-21 | Schenectady | New York | 36093 | 926 | 34 |
352484 | 352484 | 2020-07-20 | Schenectady | New York | 36093 | 915 | 34 |
349281 | 349281 | 2020-07-19 | Schenectady | New York | 36093 | 915 | 34 |
346080 | 346080 | 2020-07-18 | Schenectady | New York | 36093 | 910 | 34 |
342881 | 342881 | 2020-07-17 | Schenectady | New York | 36093 | 902 | 34 |
339683 | 339683 | 2020-07-16 | Schenectady | New York | 36093 | 896 | 34 |
336487 | 336487 | 2020-07-15 | Schenectady | New York | 36093 | 891 | 34 |
333293 | 333293 | 2020-07-14 | Schenectady | New York | 36093 | 883 | 34 |
330103 | 330103 | 2020-07-13 | Schenectady | New York | 36093 | 868 | 34 |
326916 | 326916 | 2020-07-12 | Schenectady | New York | 36093 | 864 | 34 |
323732 | 323732 | 2020-07-11 | Schenectady | New York | 36093 | 856 | 34 |
320552 | 320552 | 2020-07-10 | Schenectady | New York | 36093 | 852 | 34 |
317375 | 317375 | 2020-07-09 | Schenectady | New York | 36093 | 848 | 34 |
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);