ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
797 rows where fips = 36103 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 |
---|---|---|---|---|---|---|---|
636777 | 636777 | 2020-10-16 | Suffolk | New York | 36103 | 47815 | 2017 |
633531 | 633531 | 2020-10-15 | Suffolk | New York | 36103 | 47711 | 2017 |
630286 | 630286 | 2020-10-14 | Suffolk | New York | 36103 | 47630 | 2017 |
627042 | 627042 | 2020-10-13 | Suffolk | New York | 36103 | 47561 | 2017 |
623800 | 623800 | 2020-10-12 | Suffolk | New York | 36103 | 47493 | 2017 |
620557 | 620557 | 2020-10-11 | Suffolk | New York | 36103 | 47431 | 2016 |
617315 | 617315 | 2020-10-10 | Suffolk | New York | 36103 | 47357 | 2016 |
614073 | 614073 | 2020-10-09 | Suffolk | New York | 36103 | 47285 | 2016 |
610832 | 610832 | 2020-10-08 | Suffolk | New York | 36103 | 47196 | 2016 |
607590 | 607590 | 2020-10-07 | Suffolk | New York | 36103 | 47089 | 2016 |
604347 | 604347 | 2020-10-06 | Suffolk | New York | 36103 | 46980 | 2016 |
601105 | 601105 | 2020-10-05 | Suffolk | New York | 36103 | 46891 | 2015 |
597862 | 597862 | 2020-10-04 | Suffolk | New York | 36103 | 46842 | 2015 |
594619 | 594619 | 2020-10-03 | Suffolk | New York | 36103 | 46770 | 2015 |
591378 | 591378 | 2020-10-02 | Suffolk | New York | 36103 | 46667 | 2015 |
588137 | 588137 | 2020-10-01 | Suffolk | New York | 36103 | 46563 | 2015 |
584897 | 584897 | 2020-09-30 | Suffolk | New York | 36103 | 46517 | 2015 |
581656 | 581656 | 2020-09-29 | Suffolk | New York | 36103 | 46464 | 2014 |
578416 | 578416 | 2020-09-28 | Suffolk | New York | 36103 | 46428 | 2014 |
575175 | 575175 | 2020-09-27 | Suffolk | New York | 36103 | 46387 | 2013 |
571931 | 571931 | 2020-09-26 | Suffolk | New York | 36103 | 46345 | 2013 |
568689 | 568689 | 2020-09-25 | Suffolk | New York | 36103 | 46293 | 2013 |
565448 | 565448 | 2020-09-24 | Suffolk | New York | 36103 | 46241 | 2012 |
562207 | 562207 | 2020-09-23 | Suffolk | New York | 36103 | 46208 | 2012 |
558970 | 558970 | 2020-09-22 | Suffolk | New York | 36103 | 46176 | 2012 |
555733 | 555733 | 2020-09-21 | Suffolk | New York | 36103 | 46109 | 2012 |
552496 | 552496 | 2020-09-20 | Suffolk | New York | 36103 | 46061 | 2012 |
549257 | 549257 | 2020-09-19 | Suffolk | New York | 36103 | 46010 | 2011 |
546018 | 546018 | 2020-09-18 | Suffolk | New York | 36103 | 45956 | 2011 |
542781 | 542781 | 2020-09-17 | Suffolk | New York | 36103 | 45915 | 2011 |
539545 | 539545 | 2020-09-16 | Suffolk | New York | 36103 | 45843 | 2011 |
536308 | 536308 | 2020-09-15 | Suffolk | New York | 36103 | 45785 | 2011 |
533072 | 533072 | 2020-09-14 | Suffolk | New York | 36103 | 45714 | 2010 |
529837 | 529837 | 2020-09-13 | Suffolk | New York | 36103 | 45683 | 2009 |
526600 | 526600 | 2020-09-12 | Suffolk | New York | 36103 | 45615 | 2008 |
523364 | 523364 | 2020-09-11 | Suffolk | New York | 36103 | 45534 | 2008 |
520128 | 520128 | 2020-09-10 | Suffolk | New York | 36103 | 45463 | 2006 |
516892 | 516892 | 2020-09-09 | Suffolk | New York | 36103 | 45411 | 2006 |
513657 | 513657 | 2020-09-08 | Suffolk | New York | 36103 | 45356 | 2006 |
510424 | 510424 | 2020-09-07 | Suffolk | New York | 36103 | 45304 | 2006 |
507191 | 507191 | 2020-09-06 | Suffolk | New York | 36103 | 45258 | 2006 |
503959 | 503959 | 2020-09-05 | Suffolk | New York | 36103 | 45200 | 2006 |
500725 | 500725 | 2020-09-04 | Suffolk | New York | 36103 | 45102 | 2005 |
497491 | 497491 | 2020-09-03 | Suffolk | New York | 36103 | 45006 | 2005 |
494258 | 494258 | 2020-09-02 | Suffolk | New York | 36103 | 44940 | 2003 |
491024 | 491024 | 2020-09-01 | Suffolk | New York | 36103 | 44885 | 2002 |
487791 | 487791 | 2020-08-31 | Suffolk | New York | 36103 | 44820 | 2002 |
484558 | 484558 | 2020-08-30 | Suffolk | New York | 36103 | 44763 | 2002 |
481323 | 481323 | 2020-08-29 | Suffolk | New York | 36103 | 44712 | 2002 |
478090 | 478090 | 2020-08-28 | Suffolk | New York | 36103 | 44678 | 2001 |
474857 | 474857 | 2020-08-27 | Suffolk | New York | 36103 | 44641 | 2001 |
471623 | 471623 | 2020-08-26 | Suffolk | New York | 36103 | 44605 | 2001 |
468391 | 468391 | 2020-08-25 | Suffolk | New York | 36103 | 44561 | 2001 |
465163 | 465163 | 2020-08-24 | Suffolk | New York | 36103 | 44519 | 2001 |
461934 | 461934 | 2020-08-23 | Suffolk | New York | 36103 | 44498 | 2001 |
458706 | 458706 | 2020-08-22 | Suffolk | New York | 36103 | 44456 | 2001 |
455478 | 455478 | 2020-08-21 | Suffolk | New York | 36103 | 44400 | 2000 |
452250 | 452250 | 2020-08-20 | Suffolk | New York | 36103 | 44353 | 2000 |
449022 | 449022 | 2020-08-19 | Suffolk | New York | 36103 | 44305 | 2000 |
445794 | 445794 | 2020-08-18 | Suffolk | New York | 36103 | 44235 | 2000 |
442568 | 442568 | 2020-08-17 | Suffolk | New York | 36103 | 44185 | 1999 |
439341 | 439341 | 2020-08-16 | Suffolk | New York | 36103 | 44159 | 1998 |
436116 | 436116 | 2020-08-15 | Suffolk | New York | 36103 | 44109 | 1998 |
432890 | 432890 | 2020-08-14 | Suffolk | New York | 36103 | 44045 | 1998 |
429664 | 429664 | 2020-08-13 | Suffolk | New York | 36103 | 43987 | 1998 |
426439 | 426439 | 2020-08-12 | Suffolk | New York | 36103 | 43948 | 1998 |
423216 | 423216 | 2020-08-11 | Suffolk | New York | 36103 | 43893 | 1998 |
419993 | 419993 | 2020-08-10 | Suffolk | New York | 36103 | 43844 | 1998 |
416773 | 416773 | 2020-08-09 | Suffolk | New York | 36103 | 43786 | 1998 |
413552 | 413552 | 2020-08-08 | Suffolk | New York | 36103 | 43749 | 1998 |
410332 | 410332 | 2020-08-07 | Suffolk | New York | 36103 | 43681 | 1998 |
407112 | 407112 | 2020-08-06 | Suffolk | New York | 36103 | 43630 | 1998 |
403893 | 403893 | 2020-08-05 | Suffolk | New York | 36103 | 43553 | 2044 |
400675 | 400675 | 2020-08-04 | Suffolk | New York | 36103 | 43468 | 2044 |
397460 | 397460 | 2020-08-03 | Suffolk | New York | 36103 | 43395 | 2044 |
394243 | 394243 | 2020-08-02 | Suffolk | New York | 36103 | 43345 | 2044 |
391027 | 391027 | 2020-08-01 | Suffolk | New York | 36103 | 43300 | 2044 |
387810 | 387810 | 2020-07-31 | Suffolk | New York | 36103 | 43224 | 2044 |
384593 | 384593 | 2020-07-30 | Suffolk | New York | 36103 | 43170 | 2043 |
381375 | 381375 | 2020-07-29 | Suffolk | New York | 36103 | 43084 | 2043 |
378158 | 378158 | 2020-07-28 | Suffolk | New York | 36103 | 43024 | 2043 |
374942 | 374942 | 2020-07-27 | Suffolk | New York | 36103 | 42967 | 2043 |
371730 | 371730 | 2020-07-26 | Suffolk | New York | 36103 | 42883 | 2043 |
368518 | 368518 | 2020-07-25 | Suffolk | New York | 36103 | 42822 | 2043 |
365309 | 365309 | 2020-07-24 | Suffolk | New York | 36103 | 42773 | 2042 |
362103 | 362103 | 2020-07-23 | Suffolk | New York | 36103 | 42715 | 2042 |
358897 | 358897 | 2020-07-22 | Suffolk | New York | 36103 | 42621 | 2042 |
355693 | 355693 | 2020-07-21 | Suffolk | New York | 36103 | 42575 | 2042 |
352490 | 352490 | 2020-07-20 | Suffolk | New York | 36103 | 42496 | 2041 |
349287 | 349287 | 2020-07-19 | Suffolk | New York | 36103 | 42466 | 2041 |
346086 | 346086 | 2020-07-18 | Suffolk | New York | 36103 | 42440 | 2040 |
342887 | 342887 | 2020-07-17 | Suffolk | New York | 36103 | 42382 | 2040 |
339689 | 339689 | 2020-07-16 | Suffolk | New York | 36103 | 42333 | 2039 |
336493 | 336493 | 2020-07-15 | Suffolk | New York | 36103 | 42267 | 2039 |
333299 | 333299 | 2020-07-14 | Suffolk | New York | 36103 | 42214 | 2039 |
330109 | 330109 | 2020-07-13 | Suffolk | New York | 36103 | 42112 | 2039 |
326922 | 326922 | 2020-07-12 | Suffolk | New York | 36103 | 42028 | 2039 |
323738 | 323738 | 2020-07-11 | Suffolk | New York | 36103 | 41987 | 2039 |
320558 | 320558 | 2020-07-10 | Suffolk | New York | 36103 | 41911 | 2038 |
317381 | 317381 | 2020-07-09 | Suffolk | New York | 36103 | 41849 | 2037 |
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);