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 |
---|---|---|---|---|---|---|---|
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 |
314201 | 314201 | 2020-07-08 | Schenectady | New York | 36093 | 844 | 34 |
311030 | 311030 | 2020-07-07 | Schenectady | New York | 36093 | 843 | 34 |
307862 | 307862 | 2020-07-06 | Schenectady | New York | 36093 | 838 | 34 |
304695 | 304695 | 2020-07-05 | Schenectady | New York | 36093 | 834 | 34 |
301532 | 301532 | 2020-07-04 | Schenectady | New York | 36093 | 831 | 34 |
298369 | 298369 | 2020-07-03 | Schenectady | New York | 36093 | 824 | 34 |
295209 | 295209 | 2020-07-02 | Schenectady | New York | 36093 | 816 | 34 |
292054 | 292054 | 2020-07-01 | Schenectady | New York | 36093 | 805 | 34 |
288902 | 288902 | 2020-06-30 | Schenectady | New York | 36093 | 800 | 34 |
285752 | 285752 | 2020-06-29 | Schenectady | New York | 36093 | 799 | 34 |
282607 | 282607 | 2020-06-28 | Schenectady | New York | 36093 | 792 | 34 |
279461 | 279461 | 2020-06-27 | Schenectady | New York | 36093 | 786 | 34 |
276313 | 276313 | 2020-06-26 | Schenectady | New York | 36093 | 781 | 34 |
273167 | 273167 | 2020-06-25 | Schenectady | New York | 36093 | 778 | 34 |
270028 | 270028 | 2020-06-24 | Schenectady | New York | 36093 | 772 | 33 |
266894 | 266894 | 2020-06-23 | Schenectady | New York | 36093 | 770 | 33 |
263766 | 263766 | 2020-06-22 | Schenectady | New York | 36093 | 761 | 33 |
260638 | 260638 | 2020-06-21 | Schenectady | New York | 36093 | 754 | 32 |
257511 | 257511 | 2020-06-20 | Schenectady | New York | 36093 | 749 | 32 |
254388 | 254388 | 2020-06-19 | Schenectady | New York | 36093 | 746 | 32 |
251273 | 251273 | 2020-06-18 | Schenectady | New York | 36093 | 738 | 32 |
248158 | 248158 | 2020-06-17 | Schenectady | New York | 36093 | 737 | 32 |
245045 | 245045 | 2020-06-16 | Schenectady | New York | 36093 | 735 | 32 |
241933 | 241933 | 2020-06-15 | Schenectady | New York | 36093 | 732 | 32 |
238824 | 238824 | 2020-06-14 | Schenectady | New York | 36093 | 725 | 32 |
235716 | 235716 | 2020-06-13 | Schenectady | New York | 36093 | 723 | 32 |
232611 | 232611 | 2020-06-12 | Schenectady | New York | 36093 | 721 | 32 |
229506 | 229506 | 2020-06-11 | Schenectady | New York | 36093 | 717 | 32 |
226402 | 226402 | 2020-06-10 | Schenectady | New York | 36093 | 716 | 32 |
223302 | 223302 | 2020-06-09 | Schenectady | New York | 36093 | 715 | 32 |
220208 | 220208 | 2020-06-08 | Schenectady | New York | 36093 | 712 | 32 |
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);