ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Allegany" 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 |
---|---|---|---|---|---|---|---|
536262 | 536262 | 2020-09-15 | Allegany | New York | 36003 | 94 | 2 |
533026 | 533026 | 2020-09-14 | Allegany | New York | 36003 | 94 | 2 |
529791 | 529791 | 2020-09-13 | Allegany | New York | 36003 | 94 | 2 |
526554 | 526554 | 2020-09-12 | Allegany | New York | 36003 | 94 | 2 |
523318 | 523318 | 2020-09-11 | Allegany | New York | 36003 | 93 | 2 |
520082 | 520082 | 2020-09-10 | Allegany | New York | 36003 | 93 | 2 |
516846 | 516846 | 2020-09-09 | Allegany | New York | 36003 | 92 | 2 |
513611 | 513611 | 2020-09-08 | Allegany | New York | 36003 | 92 | 2 |
510378 | 510378 | 2020-09-07 | Allegany | New York | 36003 | 92 | 2 |
507145 | 507145 | 2020-09-06 | Allegany | New York | 36003 | 92 | 2 |
503913 | 503913 | 2020-09-05 | Allegany | New York | 36003 | 92 | 2 |
500679 | 500679 | 2020-09-04 | Allegany | New York | 36003 | 90 | 2 |
497445 | 497445 | 2020-09-03 | Allegany | New York | 36003 | 90 | 2 |
494212 | 494212 | 2020-09-02 | Allegany | New York | 36003 | 89 | 2 |
490978 | 490978 | 2020-09-01 | Allegany | New York | 36003 | 89 | 2 |
487745 | 487745 | 2020-08-31 | Allegany | New York | 36003 | 89 | 2 |
484512 | 484512 | 2020-08-30 | Allegany | New York | 36003 | 89 | 2 |
481277 | 481277 | 2020-08-29 | Allegany | New York | 36003 | 88 | 2 |
478044 | 478044 | 2020-08-28 | Allegany | New York | 36003 | 87 | 2 |
474811 | 474811 | 2020-08-27 | Allegany | New York | 36003 | 87 | 2 |
471577 | 471577 | 2020-08-26 | Allegany | New York | 36003 | 86 | 2 |
468345 | 468345 | 2020-08-25 | Allegany | New York | 36003 | 86 | 2 |
465117 | 465117 | 2020-08-24 | Allegany | New York | 36003 | 85 | 2 |
461888 | 461888 | 2020-08-23 | Allegany | New York | 36003 | 85 | 2 |
458660 | 458660 | 2020-08-22 | Allegany | New York | 36003 | 84 | 2 |
455432 | 455432 | 2020-08-21 | Allegany | New York | 36003 | 84 | 2 |
452204 | 452204 | 2020-08-20 | Allegany | New York | 36003 | 81 | 2 |
448976 | 448976 | 2020-08-19 | Allegany | New York | 36003 | 80 | 2 |
445748 | 445748 | 2020-08-18 | Allegany | New York | 36003 | 80 | 2 |
442522 | 442522 | 2020-08-17 | Allegany | New York | 36003 | 80 | 2 |
439295 | 439295 | 2020-08-16 | Allegany | New York | 36003 | 80 | 2 |
436070 | 436070 | 2020-08-15 | Allegany | New York | 36003 | 80 | 2 |
432844 | 432844 | 2020-08-14 | Allegany | New York | 36003 | 80 | 2 |
429618 | 429618 | 2020-08-13 | Allegany | New York | 36003 | 80 | 2 |
426393 | 426393 | 2020-08-12 | Allegany | New York | 36003 | 80 | 2 |
423170 | 423170 | 2020-08-11 | Allegany | New York | 36003 | 80 | 2 |
419947 | 419947 | 2020-08-10 | Allegany | New York | 36003 | 80 | 2 |
416727 | 416727 | 2020-08-09 | Allegany | New York | 36003 | 79 | 2 |
413506 | 413506 | 2020-08-08 | Allegany | New York | 36003 | 79 | 2 |
410286 | 410286 | 2020-08-07 | Allegany | New York | 36003 | 79 | 2 |
407066 | 407066 | 2020-08-06 | Allegany | New York | 36003 | 78 | 2 |
403847 | 403847 | 2020-08-05 | Allegany | New York | 36003 | 76 | 0 |
400629 | 400629 | 2020-08-04 | Allegany | New York | 36003 | 75 | 0 |
397414 | 397414 | 2020-08-03 | Allegany | New York | 36003 | 75 | 0 |
394197 | 394197 | 2020-08-02 | Allegany | New York | 36003 | 74 | 0 |
390981 | 390981 | 2020-08-01 | Allegany | New York | 36003 | 74 | 0 |
387764 | 387764 | 2020-07-31 | Allegany | New York | 36003 | 74 | 0 |
384547 | 384547 | 2020-07-30 | Allegany | New York | 36003 | 74 | 0 |
381329 | 381329 | 2020-07-29 | Allegany | New York | 36003 | 74 | 0 |
378112 | 378112 | 2020-07-28 | Allegany | New York | 36003 | 74 | 0 |
374896 | 374896 | 2020-07-27 | Allegany | New York | 36003 | 74 | 0 |
371684 | 371684 | 2020-07-26 | Allegany | New York | 36003 | 74 | 0 |
368472 | 368472 | 2020-07-25 | Allegany | New York | 36003 | 74 | 0 |
365263 | 365263 | 2020-07-24 | Allegany | New York | 36003 | 74 | 0 |
362057 | 362057 | 2020-07-23 | Allegany | New York | 36003 | 72 | 0 |
358851 | 358851 | 2020-07-22 | Allegany | New York | 36003 | 72 | 0 |
355647 | 355647 | 2020-07-21 | Allegany | New York | 36003 | 72 | 0 |
352444 | 352444 | 2020-07-20 | Allegany | New York | 36003 | 71 | 0 |
349241 | 349241 | 2020-07-19 | Allegany | New York | 36003 | 71 | 0 |
346040 | 346040 | 2020-07-18 | Allegany | New York | 36003 | 71 | 0 |
342841 | 342841 | 2020-07-17 | Allegany | New York | 36003 | 71 | 0 |
339643 | 339643 | 2020-07-16 | Allegany | New York | 36003 | 70 | 0 |
336447 | 336447 | 2020-07-15 | Allegany | New York | 36003 | 69 | 0 |
333253 | 333253 | 2020-07-14 | Allegany | New York | 36003 | 68 | 0 |
330063 | 330063 | 2020-07-13 | Allegany | New York | 36003 | 66 | 0 |
326876 | 326876 | 2020-07-12 | Allegany | New York | 36003 | 66 | 0 |
323692 | 323692 | 2020-07-11 | Allegany | New York | 36003 | 66 | 0 |
320512 | 320512 | 2020-07-10 | Allegany | New York | 36003 | 64 | 0 |
317335 | 317335 | 2020-07-09 | Allegany | New York | 36003 | 64 | 0 |
314161 | 314161 | 2020-07-08 | Allegany | New York | 36003 | 64 | 0 |
310990 | 310990 | 2020-07-07 | Allegany | New York | 36003 | 63 | 0 |
307822 | 307822 | 2020-07-06 | Allegany | New York | 36003 | 63 | 0 |
304655 | 304655 | 2020-07-05 | Allegany | New York | 36003 | 63 | 0 |
301492 | 301492 | 2020-07-04 | Allegany | New York | 36003 | 63 | 0 |
298329 | 298329 | 2020-07-03 | Allegany | New York | 36003 | 63 | 0 |
295169 | 295169 | 2020-07-02 | Allegany | New York | 36003 | 62 | 0 |
292014 | 292014 | 2020-07-01 | Allegany | New York | 36003 | 61 | 0 |
288862 | 288862 | 2020-06-30 | Allegany | New York | 36003 | 59 | 0 |
285712 | 285712 | 2020-06-29 | Allegany | New York | 36003 | 59 | 0 |
282567 | 282567 | 2020-06-28 | Allegany | New York | 36003 | 59 | 0 |
279421 | 279421 | 2020-06-27 | Allegany | New York | 36003 | 58 | 0 |
276273 | 276273 | 2020-06-26 | Allegany | New York | 36003 | 58 | 0 |
273127 | 273127 | 2020-06-25 | Allegany | New York | 36003 | 58 | 0 |
269988 | 269988 | 2020-06-24 | Allegany | New York | 36003 | 58 | 0 |
266854 | 266854 | 2020-06-23 | Allegany | New York | 36003 | 58 | 0 |
263726 | 263726 | 2020-06-22 | Allegany | New York | 36003 | 58 | 0 |
260598 | 260598 | 2020-06-21 | Allegany | New York | 36003 | 58 | 0 |
257471 | 257471 | 2020-06-20 | Allegany | New York | 36003 | 58 | 0 |
254348 | 254348 | 2020-06-19 | Allegany | New York | 36003 | 58 | 0 |
251233 | 251233 | 2020-06-18 | Allegany | New York | 36003 | 57 | 0 |
248118 | 248118 | 2020-06-17 | Allegany | New York | 36003 | 55 | 0 |
245005 | 245005 | 2020-06-16 | Allegany | New York | 36003 | 55 | 0 |
241893 | 241893 | 2020-06-15 | Allegany | New York | 36003 | 55 | 0 |
238784 | 238784 | 2020-06-14 | Allegany | New York | 36003 | 54 | 0 |
235676 | 235676 | 2020-06-13 | Allegany | New York | 36003 | 54 | 0 |
232571 | 232571 | 2020-06-12 | Allegany | New York | 36003 | 53 | 0 |
229466 | 229466 | 2020-06-11 | Allegany | New York | 36003 | 53 | 0 |
226362 | 226362 | 2020-06-10 | Allegany | New York | 36003 | 52 | 0 |
223262 | 223262 | 2020-06-09 | Allegany | New York | 36003 | 51 | 0 |
220168 | 220168 | 2020-06-08 | Allegany | New York | 36003 | 51 | 0 |
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);