ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where fips = 36119 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 |
---|---|---|---|---|---|---|---|
636785 | 636785 | 2020-10-16 | Westchester | New York | 36119 | 39287 | 1465 |
633539 | 633539 | 2020-10-15 | Westchester | New York | 36119 | 39199 | 1463 |
630294 | 630294 | 2020-10-14 | Westchester | New York | 36119 | 39117 | 1462 |
627050 | 627050 | 2020-10-13 | Westchester | New York | 36119 | 39063 | 1462 |
623808 | 623808 | 2020-10-12 | Westchester | New York | 36119 | 39000 | 1462 |
620565 | 620565 | 2020-10-11 | Westchester | New York | 36119 | 38893 | 1461 |
617323 | 617323 | 2020-10-10 | Westchester | New York | 36119 | 38846 | 1461 |
614081 | 614081 | 2020-10-09 | Westchester | New York | 36119 | 38770 | 1460 |
610840 | 610840 | 2020-10-08 | Westchester | New York | 36119 | 38693 | 1459 |
607598 | 607598 | 2020-10-07 | Westchester | New York | 36119 | 38627 | 1458 |
604355 | 604355 | 2020-10-06 | Westchester | New York | 36119 | 38566 | 1457 |
601113 | 601113 | 2020-10-05 | Westchester | New York | 36119 | 38514 | 1457 |
597870 | 597870 | 2020-10-04 | Westchester | New York | 36119 | 38474 | 1457 |
594627 | 594627 | 2020-10-03 | Westchester | New York | 36119 | 38430 | 1456 |
591386 | 591386 | 2020-10-02 | Westchester | New York | 36119 | 38345 | 1456 |
588145 | 588145 | 2020-10-01 | Westchester | New York | 36119 | 38299 | 1456 |
584905 | 584905 | 2020-09-30 | Westchester | New York | 36119 | 38238 | 1456 |
581664 | 581664 | 2020-09-29 | Westchester | New York | 36119 | 38181 | 1456 |
578424 | 578424 | 2020-09-28 | Westchester | New York | 36119 | 38132 | 1456 |
575183 | 575183 | 2020-09-27 | Westchester | New York | 36119 | 38097 | 1456 |
571939 | 571939 | 2020-09-26 | Westchester | New York | 36119 | 38050 | 1456 |
568697 | 568697 | 2020-09-25 | Westchester | New York | 36119 | 38000 | 1456 |
565456 | 565456 | 2020-09-24 | Westchester | New York | 36119 | 37947 | 1455 |
562215 | 562215 | 2020-09-23 | Westchester | New York | 36119 | 37902 | 1455 |
558978 | 558978 | 2020-09-22 | Westchester | New York | 36119 | 37865 | 1454 |
555741 | 555741 | 2020-09-21 | Westchester | New York | 36119 | 37836 | 1454 |
552504 | 552504 | 2020-09-20 | Westchester | New York | 36119 | 37800 | 1454 |
549265 | 549265 | 2020-09-19 | Westchester | New York | 36119 | 37754 | 1454 |
546026 | 546026 | 2020-09-18 | Westchester | New York | 36119 | 37717 | 1454 |
542789 | 542789 | 2020-09-17 | Westchester | New York | 36119 | 37671 | 1454 |
539553 | 539553 | 2020-09-16 | Westchester | New York | 36119 | 37633 | 1454 |
536316 | 536316 | 2020-09-15 | Westchester | New York | 36119 | 37600 | 1453 |
533080 | 533080 | 2020-09-14 | Westchester | New York | 36119 | 37570 | 1453 |
529845 | 529845 | 2020-09-13 | Westchester | New York | 36119 | 37530 | 1452 |
526608 | 526608 | 2020-09-12 | Westchester | New York | 36119 | 37485 | 1452 |
523372 | 523372 | 2020-09-11 | Westchester | New York | 36119 | 37453 | 1452 |
520136 | 520136 | 2020-09-10 | Westchester | New York | 36119 | 37404 | 1452 |
516900 | 516900 | 2020-09-09 | Westchester | New York | 36119 | 37354 | 1452 |
513665 | 513665 | 2020-09-08 | Westchester | New York | 36119 | 37313 | 1452 |
510432 | 510432 | 2020-09-07 | Westchester | New York | 36119 | 37276 | 1452 |
507199 | 507199 | 2020-09-06 | Westchester | New York | 36119 | 37245 | 1452 |
503967 | 503967 | 2020-09-05 | Westchester | New York | 36119 | 37204 | 1452 |
500733 | 500733 | 2020-09-04 | Westchester | New York | 36119 | 37151 | 1452 |
497499 | 497499 | 2020-09-03 | Westchester | New York | 36119 | 37105 | 1452 |
494266 | 494266 | 2020-09-02 | Westchester | New York | 36119 | 37056 | 1452 |
491032 | 491032 | 2020-09-01 | Westchester | New York | 36119 | 37020 | 1452 |
487799 | 487799 | 2020-08-31 | Westchester | New York | 36119 | 36983 | 1452 |
484566 | 484566 | 2020-08-30 | Westchester | New York | 36119 | 36948 | 1451 |
481331 | 481331 | 2020-08-29 | Westchester | New York | 36119 | 36894 | 1450 |
478098 | 478098 | 2020-08-28 | Westchester | New York | 36119 | 36862 | 1450 |
474865 | 474865 | 2020-08-27 | Westchester | New York | 36119 | 36824 | 1450 |
471631 | 471631 | 2020-08-26 | Westchester | New York | 36119 | 36779 | 1449 |
468399 | 468399 | 2020-08-25 | Westchester | New York | 36119 | 36741 | 1449 |
465171 | 465171 | 2020-08-24 | Westchester | New York | 36119 | 36709 | 1449 |
461942 | 461942 | 2020-08-23 | Westchester | New York | 36119 | 36688 | 1449 |
458714 | 458714 | 2020-08-22 | Westchester | New York | 36119 | 36650 | 1449 |
455486 | 455486 | 2020-08-21 | Westchester | New York | 36119 | 36620 | 1449 |
452258 | 452258 | 2020-08-20 | Westchester | New York | 36119 | 36585 | 1449 |
449030 | 449030 | 2020-08-19 | Westchester | New York | 36119 | 36562 | 1449 |
445802 | 445802 | 2020-08-18 | Westchester | New York | 36119 | 36539 | 1448 |
442576 | 442576 | 2020-08-17 | Westchester | New York | 36119 | 36485 | 1448 |
439349 | 439349 | 2020-08-16 | Westchester | New York | 36119 | 36452 | 1447 |
436124 | 436124 | 2020-08-15 | Westchester | New York | 36119 | 36434 | 1447 |
432898 | 432898 | 2020-08-14 | Westchester | New York | 36119 | 36401 | 1447 |
429672 | 429672 | 2020-08-13 | Westchester | New York | 36119 | 36356 | 1447 |
426447 | 426447 | 2020-08-12 | Westchester | New York | 36119 | 36323 | 1447 |
423224 | 423224 | 2020-08-11 | Westchester | New York | 36119 | 36271 | 1447 |
420001 | 420001 | 2020-08-10 | Westchester | New York | 36119 | 36232 | 1447 |
416781 | 416781 | 2020-08-09 | Westchester | New York | 36119 | 36204 | 1447 |
413560 | 413560 | 2020-08-08 | Westchester | New York | 36119 | 36179 | 1447 |
410340 | 410340 | 2020-08-07 | Westchester | New York | 36119 | 36135 | 1447 |
407120 | 407120 | 2020-08-06 | Westchester | New York | 36119 | 36106 | 1447 |
403901 | 403901 | 2020-08-05 | Westchester | New York | 36119 | 36074 | 1579 |
400683 | 400683 | 2020-08-04 | Westchester | New York | 36119 | 36048 | 1579 |
397468 | 397468 | 2020-08-03 | Westchester | New York | 36119 | 36013 | 1579 |
394251 | 394251 | 2020-08-02 | Westchester | New York | 36119 | 35997 | 1579 |
391035 | 391035 | 2020-08-01 | Westchester | New York | 36119 | 35973 | 1578 |
387818 | 387818 | 2020-07-31 | Westchester | New York | 36119 | 35932 | 1578 |
384601 | 384601 | 2020-07-30 | Westchester | New York | 36119 | 35912 | 1578 |
381383 | 381383 | 2020-07-29 | Westchester | New York | 36119 | 35873 | 1577 |
378166 | 378166 | 2020-07-28 | Westchester | New York | 36119 | 35837 | 1577 |
374950 | 374950 | 2020-07-27 | Westchester | New York | 36119 | 35798 | 1577 |
371738 | 371738 | 2020-07-26 | Westchester | New York | 36119 | 35776 | 1576 |
368526 | 368526 | 2020-07-25 | Westchester | New York | 36119 | 35737 | 1576 |
365317 | 365317 | 2020-07-24 | Westchester | New York | 36119 | 35699 | 1576 |
362111 | 362111 | 2020-07-23 | Westchester | New York | 36119 | 35666 | 1576 |
358905 | 358905 | 2020-07-22 | Westchester | New York | 36119 | 35635 | 1574 |
355701 | 355701 | 2020-07-21 | Westchester | New York | 36119 | 35586 | 1572 |
352498 | 352498 | 2020-07-20 | Westchester | New York | 36119 | 35550 | 1572 |
349295 | 349295 | 2020-07-19 | Westchester | New York | 36119 | 35514 | 1572 |
346094 | 346094 | 2020-07-18 | Westchester | New York | 36119 | 35502 | 1569 |
342895 | 342895 | 2020-07-17 | Westchester | New York | 36119 | 35462 | 1568 |
339697 | 339697 | 2020-07-16 | Westchester | New York | 36119 | 35421 | 1568 |
336501 | 336501 | 2020-07-15 | Westchester | New York | 36119 | 35393 | 1568 |
333307 | 333307 | 2020-07-14 | Westchester | New York | 36119 | 35365 | 1567 |
330117 | 330117 | 2020-07-13 | Westchester | New York | 36119 | 35326 | 1567 |
326930 | 326930 | 2020-07-12 | Westchester | New York | 36119 | 35296 | 1567 |
323746 | 323746 | 2020-07-11 | Westchester | New York | 36119 | 35259 | 1565 |
320566 | 320566 | 2020-07-10 | Westchester | New York | 36119 | 35225 | 1565 |
317389 | 317389 | 2020-07-09 | Westchester | New York | 36119 | 35182 | 1564 |
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);