ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 36087 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 |
---|---|---|---|---|---|---|---|
536300 | 536300 | 2020-09-15 | Rockland | New York | 36087 | 14617 | 509 |
533064 | 533064 | 2020-09-14 | Rockland | New York | 36087 | 14581 | 509 |
529829 | 529829 | 2020-09-13 | Rockland | New York | 36087 | 14547 | 509 |
526592 | 526592 | 2020-09-12 | Rockland | New York | 36087 | 14530 | 509 |
523356 | 523356 | 2020-09-11 | Rockland | New York | 36087 | 14510 | 509 |
520120 | 520120 | 2020-09-10 | Rockland | New York | 36087 | 14480 | 509 |
516884 | 516884 | 2020-09-09 | Rockland | New York | 36087 | 14459 | 508 |
513649 | 513649 | 2020-09-08 | Rockland | New York | 36087 | 14439 | 508 |
510416 | 510416 | 2020-09-07 | Rockland | New York | 36087 | 14418 | 508 |
507183 | 507183 | 2020-09-06 | Rockland | New York | 36087 | 14396 | 508 |
503951 | 503951 | 2020-09-05 | Rockland | New York | 36087 | 14382 | 508 |
500717 | 500717 | 2020-09-04 | Rockland | New York | 36087 | 14358 | 508 |
497483 | 497483 | 2020-09-03 | Rockland | New York | 36087 | 14334 | 508 |
494250 | 494250 | 2020-09-02 | Rockland | New York | 36087 | 14305 | 508 |
491016 | 491016 | 2020-09-01 | Rockland | New York | 36087 | 14271 | 508 |
487783 | 487783 | 2020-08-31 | Rockland | New York | 36087 | 14255 | 508 |
484550 | 484550 | 2020-08-30 | Rockland | New York | 36087 | 14233 | 508 |
481315 | 481315 | 2020-08-29 | Rockland | New York | 36087 | 14218 | 508 |
478082 | 478082 | 2020-08-28 | Rockland | New York | 36087 | 14197 | 508 |
474849 | 474849 | 2020-08-27 | Rockland | New York | 36087 | 14183 | 508 |
471615 | 471615 | 2020-08-26 | Rockland | New York | 36087 | 14161 | 508 |
468383 | 468383 | 2020-08-25 | Rockland | New York | 36087 | 14149 | 508 |
465155 | 465155 | 2020-08-24 | Rockland | New York | 36087 | 14139 | 508 |
461926 | 461926 | 2020-08-23 | Rockland | New York | 36087 | 14129 | 508 |
458698 | 458698 | 2020-08-22 | Rockland | New York | 36087 | 14118 | 508 |
455470 | 455470 | 2020-08-21 | Rockland | New York | 36087 | 14106 | 508 |
452242 | 452242 | 2020-08-20 | Rockland | New York | 36087 | 14089 | 507 |
449014 | 449014 | 2020-08-19 | Rockland | New York | 36087 | 14067 | 507 |
445786 | 445786 | 2020-08-18 | Rockland | New York | 36087 | 14053 | 507 |
442560 | 442560 | 2020-08-17 | Rockland | New York | 36087 | 14011 | 507 |
439333 | 439333 | 2020-08-16 | Rockland | New York | 36087 | 14007 | 507 |
436108 | 436108 | 2020-08-15 | Rockland | New York | 36087 | 13997 | 507 |
432882 | 432882 | 2020-08-14 | Rockland | New York | 36087 | 13981 | 507 |
429656 | 429656 | 2020-08-13 | Rockland | New York | 36087 | 13973 | 507 |
426431 | 426431 | 2020-08-12 | Rockland | New York | 36087 | 13966 | 507 |
423208 | 423208 | 2020-08-11 | Rockland | New York | 36087 | 13954 | 507 |
419985 | 419985 | 2020-08-10 | Rockland | New York | 36087 | 13949 | 507 |
416765 | 416765 | 2020-08-09 | Rockland | New York | 36087 | 13942 | 507 |
413544 | 413544 | 2020-08-08 | Rockland | New York | 36087 | 13936 | 507 |
410324 | 410324 | 2020-08-07 | Rockland | New York | 36087 | 13925 | 507 |
407104 | 407104 | 2020-08-06 | Rockland | New York | 36087 | 13918 | 507 |
403885 | 403885 | 2020-08-05 | Rockland | New York | 36087 | 13903 | 470 |
400667 | 400667 | 2020-08-04 | Rockland | New York | 36087 | 13893 | 470 |
397452 | 397452 | 2020-08-03 | Rockland | New York | 36087 | 13885 | 470 |
394235 | 394235 | 2020-08-02 | Rockland | New York | 36087 | 13882 | 470 |
391019 | 391019 | 2020-08-01 | Rockland | New York | 36087 | 13880 | 470 |
387802 | 387802 | 2020-07-31 | Rockland | New York | 36087 | 13864 | 470 |
384585 | 384585 | 2020-07-30 | Rockland | New York | 36087 | 13860 | 470 |
381367 | 381367 | 2020-07-29 | Rockland | New York | 36087 | 13852 | 470 |
378150 | 378150 | 2020-07-28 | Rockland | New York | 36087 | 13845 | 470 |
374934 | 374934 | 2020-07-27 | Rockland | New York | 36087 | 13841 | 470 |
371722 | 371722 | 2020-07-26 | Rockland | New York | 36087 | 13839 | 470 |
368510 | 368510 | 2020-07-25 | Rockland | New York | 36087 | 13837 | 470 |
365301 | 365301 | 2020-07-24 | Rockland | New York | 36087 | 13830 | 470 |
362095 | 362095 | 2020-07-23 | Rockland | New York | 36087 | 13820 | 470 |
358889 | 358889 | 2020-07-22 | Rockland | New York | 36087 | 13812 | 469 |
355685 | 355685 | 2020-07-21 | Rockland | New York | 36087 | 13806 | 469 |
352482 | 352482 | 2020-07-20 | Rockland | New York | 36087 | 13798 | 469 |
349279 | 349279 | 2020-07-19 | Rockland | New York | 36087 | 13793 | 469 |
346078 | 346078 | 2020-07-18 | Rockland | New York | 36087 | 13784 | 469 |
342879 | 342879 | 2020-07-17 | Rockland | New York | 36087 | 13775 | 469 |
339681 | 339681 | 2020-07-16 | Rockland | New York | 36087 | 13763 | 469 |
336485 | 336485 | 2020-07-15 | Rockland | New York | 36087 | 13743 | 469 |
333291 | 333291 | 2020-07-14 | Rockland | New York | 36087 | 13733 | 469 |
330101 | 330101 | 2020-07-13 | Rockland | New York | 36087 | 13719 | 469 |
326914 | 326914 | 2020-07-12 | Rockland | New York | 36087 | 13716 | 469 |
323730 | 323730 | 2020-07-11 | Rockland | New York | 36087 | 13700 | 469 |
320550 | 320550 | 2020-07-10 | Rockland | New York | 36087 | 13691 | 469 |
317373 | 317373 | 2020-07-09 | Rockland | New York | 36087 | 13683 | 469 |
314199 | 314199 | 2020-07-08 | Rockland | New York | 36087 | 13679 | 469 |
311028 | 311028 | 2020-07-07 | Rockland | New York | 36087 | 13668 | 469 |
307860 | 307860 | 2020-07-06 | Rockland | New York | 36087 | 13656 | 469 |
304693 | 304693 | 2020-07-05 | Rockland | New York | 36087 | 13648 | 469 |
301530 | 301530 | 2020-07-04 | Rockland | New York | 36087 | 13629 | 469 |
298367 | 298367 | 2020-07-03 | Rockland | New York | 36087 | 13623 | 469 |
295207 | 295207 | 2020-07-02 | Rockland | New York | 36087 | 13612 | 469 |
292052 | 292052 | 2020-07-01 | Rockland | New York | 36087 | 13602 | 469 |
288900 | 288900 | 2020-06-30 | Rockland | New York | 36087 | 13590 | 469 |
285750 | 285750 | 2020-06-29 | Rockland | New York | 36087 | 13580 | 469 |
282605 | 282605 | 2020-06-28 | Rockland | New York | 36087 | 13576 | 469 |
279459 | 279459 | 2020-06-27 | Rockland | New York | 36087 | 13566 | 469 |
276311 | 276311 | 2020-06-26 | Rockland | New York | 36087 | 13557 | 469 |
273165 | 273165 | 2020-06-25 | Rockland | New York | 36087 | 13549 | 469 |
270026 | 270026 | 2020-06-24 | Rockland | New York | 36087 | 13534 | 469 |
266892 | 266892 | 2020-06-23 | Rockland | New York | 36087 | 13529 | 469 |
263764 | 263764 | 2020-06-22 | Rockland | New York | 36087 | 13514 | 469 |
260636 | 260636 | 2020-06-21 | Rockland | New York | 36087 | 13504 | 469 |
257509 | 257509 | 2020-06-20 | Rockland | New York | 36087 | 13495 | 469 |
254386 | 254386 | 2020-06-19 | Rockland | New York | 36087 | 13486 | 469 |
251271 | 251271 | 2020-06-18 | Rockland | New York | 36087 | 13474 | 469 |
248156 | 248156 | 2020-06-17 | Rockland | New York | 36087 | 13467 | 469 |
245043 | 245043 | 2020-06-16 | Rockland | New York | 36087 | 13460 | 468 |
241931 | 241931 | 2020-06-15 | Rockland | New York | 36087 | 13441 | 466 |
238822 | 238822 | 2020-06-14 | Rockland | New York | 36087 | 13423 | 466 |
235714 | 235714 | 2020-06-13 | Rockland | New York | 36087 | 13411 | 466 |
232609 | 232609 | 2020-06-12 | Rockland | New York | 36087 | 13396 | 466 |
229504 | 229504 | 2020-06-11 | Rockland | New York | 36087 | 13385 | 466 |
226400 | 226400 | 2020-06-10 | Rockland | New York | 36087 | 13372 | 466 |
223300 | 223300 | 2020-06-09 | Rockland | New York | 36087 | 13353 | 465 |
220206 | 220206 | 2020-06-08 | Rockland | New York | 36087 | 13340 | 465 |
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);