ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 36029 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 |
---|---|---|---|---|---|---|---|
536274 | 536274 | 2020-09-15 | Erie | New York | 36029 | 10716 | 619 |
533038 | 533038 | 2020-09-14 | Erie | New York | 36029 | 10668 | 616 |
529803 | 529803 | 2020-09-13 | Erie | New York | 36029 | 10637 | 615 |
526566 | 526566 | 2020-09-12 | Erie | New York | 36029 | 10567 | 615 |
523330 | 523330 | 2020-09-11 | Erie | New York | 36029 | 10503 | 615 |
520094 | 520094 | 2020-09-10 | Erie | New York | 36029 | 10444 | 614 |
516858 | 516858 | 2020-09-09 | Erie | New York | 36029 | 10394 | 611 |
513623 | 513623 | 2020-09-08 | Erie | New York | 36029 | 10346 | 610 |
510390 | 510390 | 2020-09-07 | Erie | New York | 36029 | 10320 | 609 |
507157 | 507157 | 2020-09-06 | Erie | New York | 36029 | 10266 | 609 |
503925 | 503925 | 2020-09-05 | Erie | New York | 36029 | 10212 | 607 |
500691 | 500691 | 2020-09-04 | Erie | New York | 36029 | 10156 | 607 |
497457 | 497457 | 2020-09-03 | Erie | New York | 36029 | 10086 | 607 |
494224 | 494224 | 2020-09-02 | Erie | New York | 36029 | 10017 | 607 |
490990 | 490990 | 2020-09-01 | Erie | New York | 36029 | 9947 | 607 |
487757 | 487757 | 2020-08-31 | Erie | New York | 36029 | 9872 | 606 |
484524 | 484524 | 2020-08-30 | Erie | New York | 36029 | 9807 | 606 |
481289 | 481289 | 2020-08-29 | Erie | New York | 36029 | 9741 | 605 |
478056 | 478056 | 2020-08-28 | Erie | New York | 36029 | 9713 | 605 |
474823 | 474823 | 2020-08-27 | Erie | New York | 36029 | 9668 | 605 |
471589 | 471589 | 2020-08-26 | Erie | New York | 36029 | 9589 | 605 |
468357 | 468357 | 2020-08-25 | Erie | New York | 36029 | 9546 | 605 |
465129 | 465129 | 2020-08-24 | Erie | New York | 36029 | 9491 | 605 |
461900 | 461900 | 2020-08-23 | Erie | New York | 36029 | 9465 | 605 |
458672 | 458672 | 2020-08-22 | Erie | New York | 36029 | 9413 | 604 |
455444 | 455444 | 2020-08-21 | Erie | New York | 36029 | 9364 | 604 |
452216 | 452216 | 2020-08-20 | Erie | New York | 36029 | 9283 | 604 |
448988 | 448988 | 2020-08-19 | Erie | New York | 36029 | 9241 | 604 |
445760 | 445760 | 2020-08-18 | Erie | New York | 36029 | 9187 | 603 |
442534 | 442534 | 2020-08-17 | Erie | New York | 36029 | 9157 | 603 |
439307 | 439307 | 2020-08-16 | Erie | New York | 36029 | 9147 | 602 |
436082 | 436082 | 2020-08-15 | Erie | New York | 36029 | 9114 | 601 |
432856 | 432856 | 2020-08-14 | Erie | New York | 36029 | 9064 | 601 |
429630 | 429630 | 2020-08-13 | Erie | New York | 36029 | 9033 | 601 |
426405 | 426405 | 2020-08-12 | Erie | New York | 36029 | 9013 | 601 |
423182 | 423182 | 2020-08-11 | Erie | New York | 36029 | 8987 | 599 |
419959 | 419959 | 2020-08-10 | Erie | New York | 36029 | 8918 | 598 |
416739 | 416739 | 2020-08-09 | Erie | New York | 36029 | 8904 | 598 |
413518 | 413518 | 2020-08-08 | Erie | New York | 36029 | 8850 | 597 |
410298 | 410298 | 2020-08-07 | Erie | New York | 36029 | 8791 | 597 |
407078 | 407078 | 2020-08-06 | Erie | New York | 36029 | 8737 | 596 |
403859 | 403859 | 2020-08-05 | Erie | New York | 36029 | 8702 | 623 |
400641 | 400641 | 2020-08-04 | Erie | New York | 36029 | 8667 | 623 |
397426 | 397426 | 2020-08-03 | Erie | New York | 36029 | 8626 | 622 |
394209 | 394209 | 2020-08-02 | Erie | New York | 36029 | 8572 | 621 |
390993 | 390993 | 2020-08-01 | Erie | New York | 36029 | 8548 | 621 |
387776 | 387776 | 2020-07-31 | Erie | New York | 36029 | 8492 | 621 |
384559 | 384559 | 2020-07-30 | Erie | New York | 36029 | 8434 | 621 |
381341 | 381341 | 2020-07-29 | Erie | New York | 36029 | 8410 | 620 |
378124 | 378124 | 2020-07-28 | Erie | New York | 36029 | 8364 | 619 |
374908 | 374908 | 2020-07-27 | Erie | New York | 36029 | 8327 | 619 |
371696 | 371696 | 2020-07-26 | Erie | New York | 36029 | 8301 | 619 |
368484 | 368484 | 2020-07-25 | Erie | New York | 36029 | 8282 | 619 |
365275 | 365275 | 2020-07-24 | Erie | New York | 36029 | 8234 | 616 |
362069 | 362069 | 2020-07-23 | Erie | New York | 36029 | 8187 | 614 |
358863 | 358863 | 2020-07-22 | Erie | New York | 36029 | 8135 | 614 |
355659 | 355659 | 2020-07-21 | Erie | New York | 36029 | 8106 | 613 |
352456 | 352456 | 2020-07-20 | Erie | New York | 36029 | 8046 | 613 |
349253 | 349253 | 2020-07-19 | Erie | New York | 36029 | 8035 | 610 |
346052 | 346052 | 2020-07-18 | Erie | New York | 36029 | 8016 | 610 |
342853 | 342853 | 2020-07-17 | Erie | New York | 36029 | 7982 | 608 |
339655 | 339655 | 2020-07-16 | Erie | New York | 36029 | 7927 | 607 |
336459 | 336459 | 2020-07-15 | Erie | New York | 36029 | 7891 | 606 |
333265 | 333265 | 2020-07-14 | Erie | New York | 36029 | 7833 | 604 |
330075 | 330075 | 2020-07-13 | Erie | New York | 36029 | 7766 | 603 |
326888 | 326888 | 2020-07-12 | Erie | New York | 36029 | 7742 | 602 |
323704 | 323704 | 2020-07-11 | Erie | New York | 36029 | 7711 | 602 |
320524 | 320524 | 2020-07-10 | Erie | New York | 36029 | 7660 | 601 |
317347 | 317347 | 2020-07-09 | Erie | New York | 36029 | 7624 | 601 |
314173 | 314173 | 2020-07-08 | Erie | New York | 36029 | 7596 | 601 |
311002 | 311002 | 2020-07-07 | Erie | New York | 36029 | 7544 | 601 |
307834 | 307834 | 2020-07-06 | Erie | New York | 36029 | 7500 | 599 |
304667 | 304667 | 2020-07-05 | Erie | New York | 36029 | 7475 | 599 |
301504 | 301504 | 2020-07-04 | Erie | New York | 36029 | 7462 | 598 |
298341 | 298341 | 2020-07-03 | Erie | New York | 36029 | 7427 | 598 |
295181 | 295181 | 2020-07-02 | Erie | New York | 36029 | 7370 | 598 |
292026 | 292026 | 2020-07-01 | Erie | New York | 36029 | 7337 | 597 |
288874 | 288874 | 2020-06-30 | Erie | New York | 36029 | 7292 | 596 |
285724 | 285724 | 2020-06-29 | Erie | New York | 36029 | 7249 | 594 |
282579 | 282579 | 2020-06-28 | Erie | New York | 36029 | 7228 | 594 |
279433 | 279433 | 2020-06-27 | Erie | New York | 36029 | 7206 | 594 |
276285 | 276285 | 2020-06-26 | Erie | New York | 36029 | 7181 | 594 |
273139 | 273139 | 2020-06-25 | Erie | New York | 36029 | 7138 | 594 |
270000 | 270000 | 2020-06-24 | Erie | New York | 36029 | 7108 | 593 |
266866 | 266866 | 2020-06-23 | Erie | New York | 36029 | 7073 | 593 |
263738 | 263738 | 2020-06-22 | Erie | New York | 36029 | 7035 | 592 |
260610 | 260610 | 2020-06-21 | Erie | New York | 36029 | 7004 | 590 |
257483 | 257483 | 2020-06-20 | Erie | New York | 36029 | 6980 | 588 |
254360 | 254360 | 2020-06-19 | Erie | New York | 36029 | 6955 | 586 |
251245 | 251245 | 2020-06-18 | Erie | New York | 36029 | 6920 | 585 |
248130 | 248130 | 2020-06-17 | Erie | New York | 36029 | 6882 | 583 |
245017 | 245017 | 2020-06-16 | Erie | New York | 36029 | 6852 | 582 |
241905 | 241905 | 2020-06-15 | Erie | New York | 36029 | 6817 | 579 |
238796 | 238796 | 2020-06-14 | Erie | New York | 36029 | 6785 | 577 |
235688 | 235688 | 2020-06-13 | Erie | New York | 36029 | 6753 | 573 |
232583 | 232583 | 2020-06-12 | Erie | New York | 36029 | 6717 | 568 |
229478 | 229478 | 2020-06-11 | Erie | New York | 36029 | 6659 | 566 |
226374 | 226374 | 2020-06-10 | Erie | New York | 36029 | 6616 | 563 |
223274 | 223274 | 2020-06-09 | Erie | New York | 36029 | 6595 | 560 |
220180 | 220180 | 2020-06-08 | Erie | New York | 36029 | 6531 | 554 |
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);