ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36001 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 |
---|---|---|---|---|---|---|---|
536261 | 536261 | 2020-09-15 | Albany | New York | 36001 | 2936 | 123 |
533025 | 533025 | 2020-09-14 | Albany | New York | 36001 | 2921 | 123 |
529790 | 529790 | 2020-09-13 | Albany | New York | 36001 | 2915 | 123 |
526553 | 526553 | 2020-09-12 | Albany | New York | 36001 | 2896 | 123 |
523317 | 523317 | 2020-09-11 | Albany | New York | 36001 | 2882 | 122 |
520081 | 520081 | 2020-09-10 | Albany | New York | 36001 | 2859 | 122 |
516845 | 516845 | 2020-09-09 | Albany | New York | 36001 | 2846 | 122 |
513610 | 513610 | 2020-09-08 | Albany | New York | 36001 | 2840 | 122 |
510377 | 510377 | 2020-09-07 | Albany | New York | 36001 | 2833 | 122 |
507144 | 507144 | 2020-09-06 | Albany | New York | 36001 | 2831 | 122 |
503912 | 503912 | 2020-09-05 | Albany | New York | 36001 | 2823 | 122 |
500678 | 500678 | 2020-09-04 | Albany | New York | 36001 | 2819 | 122 |
497444 | 497444 | 2020-09-03 | Albany | New York | 36001 | 2802 | 122 |
494211 | 494211 | 2020-09-02 | Albany | New York | 36001 | 2791 | 122 |
490977 | 490977 | 2020-09-01 | Albany | New York | 36001 | 2786 | 122 |
487744 | 487744 | 2020-08-31 | Albany | New York | 36001 | 2770 | 122 |
484511 | 484511 | 2020-08-30 | Albany | New York | 36001 | 2764 | 122 |
481276 | 481276 | 2020-08-29 | Albany | New York | 36001 | 2754 | 122 |
478043 | 478043 | 2020-08-28 | Albany | New York | 36001 | 2746 | 121 |
474810 | 474810 | 2020-08-27 | Albany | New York | 36001 | 2736 | 121 |
471576 | 471576 | 2020-08-26 | Albany | New York | 36001 | 2718 | 120 |
468344 | 468344 | 2020-08-25 | Albany | New York | 36001 | 2711 | 120 |
465116 | 465116 | 2020-08-24 | Albany | New York | 36001 | 2701 | 120 |
461887 | 461887 | 2020-08-23 | Albany | New York | 36001 | 2699 | 120 |
458659 | 458659 | 2020-08-22 | Albany | New York | 36001 | 2693 | 120 |
455431 | 455431 | 2020-08-21 | Albany | New York | 36001 | 2691 | 120 |
452203 | 452203 | 2020-08-20 | Albany | New York | 36001 | 2684 | 120 |
448975 | 448975 | 2020-08-19 | Albany | New York | 36001 | 2675 | 119 |
445747 | 445747 | 2020-08-18 | Albany | New York | 36001 | 2661 | 119 |
442521 | 442521 | 2020-08-17 | Albany | New York | 36001 | 2657 | 119 |
439294 | 439294 | 2020-08-16 | Albany | New York | 36001 | 2654 | 118 |
436069 | 436069 | 2020-08-15 | Albany | New York | 36001 | 2643 | 118 |
432843 | 432843 | 2020-08-14 | Albany | New York | 36001 | 2639 | 118 |
429617 | 429617 | 2020-08-13 | Albany | New York | 36001 | 2636 | 118 |
426392 | 426392 | 2020-08-12 | Albany | New York | 36001 | 2624 | 117 |
423169 | 423169 | 2020-08-11 | Albany | New York | 36001 | 2614 | 117 |
419946 | 419946 | 2020-08-10 | Albany | New York | 36001 | 2600 | 116 |
416726 | 416726 | 2020-08-09 | Albany | New York | 36001 | 2595 | 116 |
413505 | 413505 | 2020-08-08 | Albany | New York | 36001 | 2581 | 116 |
410285 | 410285 | 2020-08-07 | Albany | New York | 36001 | 2573 | 116 |
407065 | 407065 | 2020-08-06 | Albany | New York | 36001 | 2565 | 116 |
403846 | 403846 | 2020-08-05 | Albany | New York | 36001 | 2556 | 170 |
400628 | 400628 | 2020-08-04 | Albany | New York | 36001 | 2543 | 170 |
397413 | 397413 | 2020-08-03 | Albany | New York | 36001 | 2531 | 170 |
394196 | 394196 | 2020-08-02 | Albany | New York | 36001 | 2521 | 170 |
390980 | 390980 | 2020-08-01 | Albany | New York | 36001 | 2515 | 170 |
387763 | 387763 | 2020-07-31 | Albany | New York | 36001 | 2503 | 169 |
384546 | 384546 | 2020-07-30 | Albany | New York | 36001 | 2493 | 169 |
381328 | 381328 | 2020-07-29 | Albany | New York | 36001 | 2480 | 168 |
378111 | 378111 | 2020-07-28 | Albany | New York | 36001 | 2468 | 167 |
374895 | 374895 | 2020-07-27 | Albany | New York | 36001 | 2453 | 166 |
371683 | 371683 | 2020-07-26 | Albany | New York | 36001 | 2451 | 166 |
368471 | 368471 | 2020-07-25 | Albany | New York | 36001 | 2438 | 166 |
365262 | 365262 | 2020-07-24 | Albany | New York | 36001 | 2426 | 166 |
362056 | 362056 | 2020-07-23 | Albany | New York | 36001 | 2401 | 166 |
358850 | 358850 | 2020-07-22 | Albany | New York | 36001 | 2369 | 166 |
355646 | 355646 | 2020-07-21 | Albany | New York | 36001 | 2351 | 165 |
352443 | 352443 | 2020-07-20 | Albany | New York | 36001 | 2322 | 164 |
349240 | 349240 | 2020-07-19 | Albany | New York | 36001 | 2318 | 164 |
346039 | 346039 | 2020-07-18 | Albany | New York | 36001 | 2315 | 163 |
342840 | 342840 | 2020-07-17 | Albany | New York | 36001 | 2310 | 162 |
339642 | 339642 | 2020-07-16 | Albany | New York | 36001 | 2290 | 161 |
336446 | 336446 | 2020-07-15 | Albany | New York | 36001 | 2280 | 161 |
333252 | 333252 | 2020-07-14 | Albany | New York | 36001 | 2247 | 161 |
330062 | 330062 | 2020-07-13 | Albany | New York | 36001 | 2225 | 161 |
326875 | 326875 | 2020-07-12 | Albany | New York | 36001 | 2219 | 161 |
323691 | 323691 | 2020-07-11 | Albany | New York | 36001 | 2208 | 161 |
320511 | 320511 | 2020-07-10 | Albany | New York | 36001 | 2190 | 161 |
317334 | 317334 | 2020-07-09 | Albany | New York | 36001 | 2183 | 161 |
314160 | 314160 | 2020-07-08 | Albany | New York | 36001 | 2175 | 161 |
310989 | 310989 | 2020-07-07 | Albany | New York | 36001 | 2164 | 161 |
307821 | 307821 | 2020-07-06 | Albany | New York | 36001 | 2160 | 161 |
304654 | 304654 | 2020-07-05 | Albany | New York | 36001 | 2152 | 160 |
301491 | 301491 | 2020-07-04 | Albany | New York | 36001 | 2145 | 160 |
298328 | 298328 | 2020-07-03 | Albany | New York | 36001 | 2130 | 160 |
295168 | 295168 | 2020-07-02 | Albany | New York | 36001 | 2125 | 160 |
292013 | 292013 | 2020-07-01 | Albany | New York | 36001 | 2112 | 160 |
288861 | 288861 | 2020-06-30 | Albany | New York | 36001 | 2102 | 159 |
285711 | 285711 | 2020-06-29 | Albany | New York | 36001 | 2099 | 159 |
282566 | 282566 | 2020-06-28 | Albany | New York | 36001 | 2097 | 159 |
279420 | 279420 | 2020-06-27 | Albany | New York | 36001 | 2091 | 159 |
276272 | 276272 | 2020-06-26 | Albany | New York | 36001 | 2084 | 159 |
273126 | 273126 | 2020-06-25 | Albany | New York | 36001 | 2076 | 159 |
269987 | 269987 | 2020-06-24 | Albany | New York | 36001 | 2065 | 157 |
266853 | 266853 | 2020-06-23 | Albany | New York | 36001 | 2062 | 157 |
263725 | 263725 | 2020-06-22 | Albany | New York | 36001 | 2060 | 157 |
260597 | 260597 | 2020-06-21 | Albany | New York | 36001 | 2054 | 157 |
257470 | 257470 | 2020-06-20 | Albany | New York | 36001 | 2053 | 157 |
254347 | 254347 | 2020-06-19 | Albany | New York | 36001 | 2049 | 157 |
251232 | 251232 | 2020-06-18 | Albany | New York | 36001 | 2034 | 157 |
248117 | 248117 | 2020-06-17 | Albany | New York | 36001 | 2029 | 157 |
245004 | 245004 | 2020-06-16 | Albany | New York | 36001 | 2026 | 156 |
241892 | 241892 | 2020-06-15 | Albany | New York | 36001 | 2022 | 154 |
238783 | 238783 | 2020-06-14 | Albany | New York | 36001 | 2020 | 153 |
235675 | 235675 | 2020-06-13 | Albany | New York | 36001 | 2016 | 152 |
232570 | 232570 | 2020-06-12 | Albany | New York | 36001 | 2007 | 152 |
229465 | 229465 | 2020-06-11 | Albany | New York | 36001 | 1996 | 152 |
226361 | 226361 | 2020-06-10 | Albany | New York | 36001 | 1986 | 150 |
223261 | 223261 | 2020-06-09 | Albany | New York | 36001 | 1983 | 149 |
220167 | 220167 | 2020-06-08 | Albany | New York | 36001 | 1978 | 148 |
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);