ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36051 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 |
---|---|---|---|---|---|---|---|
636753 | 636753 | 2020-10-16 | Livingston | New York | 36051 | 234 | 6 |
633507 | 633507 | 2020-10-15 | Livingston | New York | 36051 | 232 | 6 |
630262 | 630262 | 2020-10-14 | Livingston | New York | 36051 | 227 | 6 |
627018 | 627018 | 2020-10-13 | Livingston | New York | 36051 | 227 | 6 |
623776 | 623776 | 2020-10-12 | Livingston | New York | 36051 | 225 | 6 |
620533 | 620533 | 2020-10-11 | Livingston | New York | 36051 | 222 | 6 |
617291 | 617291 | 2020-10-10 | Livingston | New York | 36051 | 219 | 6 |
614049 | 614049 | 2020-10-09 | Livingston | New York | 36051 | 219 | 6 |
610808 | 610808 | 2020-10-08 | Livingston | New York | 36051 | 216 | 6 |
607566 | 607566 | 2020-10-07 | Livingston | New York | 36051 | 213 | 6 |
604323 | 604323 | 2020-10-06 | Livingston | New York | 36051 | 212 | 6 |
601081 | 601081 | 2020-10-05 | Livingston | New York | 36051 | 211 | 6 |
597838 | 597838 | 2020-10-04 | Livingston | New York | 36051 | 211 | 6 |
594595 | 594595 | 2020-10-03 | Livingston | New York | 36051 | 210 | 6 |
591354 | 591354 | 2020-10-02 | Livingston | New York | 36051 | 209 | 6 |
588113 | 588113 | 2020-10-01 | Livingston | New York | 36051 | 208 | 6 |
584873 | 584873 | 2020-09-30 | Livingston | New York | 36051 | 208 | 6 |
581632 | 581632 | 2020-09-29 | Livingston | New York | 36051 | 207 | 6 |
578392 | 578392 | 2020-09-28 | Livingston | New York | 36051 | 207 | 6 |
575151 | 575151 | 2020-09-27 | Livingston | New York | 36051 | 207 | 6 |
571907 | 571907 | 2020-09-26 | Livingston | New York | 36051 | 207 | 6 |
568665 | 568665 | 2020-09-25 | Livingston | New York | 36051 | 206 | 6 |
565424 | 565424 | 2020-09-24 | Livingston | New York | 36051 | 205 | 6 |
562183 | 562183 | 2020-09-23 | Livingston | New York | 36051 | 202 | 6 |
558946 | 558946 | 2020-09-22 | Livingston | New York | 36051 | 202 | 6 |
555709 | 555709 | 2020-09-21 | Livingston | New York | 36051 | 201 | 6 |
552472 | 552472 | 2020-09-20 | Livingston | New York | 36051 | 201 | 6 |
549233 | 549233 | 2020-09-19 | Livingston | New York | 36051 | 201 | 6 |
545994 | 545994 | 2020-09-18 | Livingston | New York | 36051 | 201 | 6 |
542757 | 542757 | 2020-09-17 | Livingston | New York | 36051 | 199 | 6 |
539521 | 539521 | 2020-09-16 | Livingston | New York | 36051 | 197 | 6 |
536284 | 536284 | 2020-09-15 | Livingston | New York | 36051 | 196 | 6 |
533048 | 533048 | 2020-09-14 | Livingston | New York | 36051 | 196 | 6 |
529813 | 529813 | 2020-09-13 | Livingston | New York | 36051 | 196 | 6 |
526576 | 526576 | 2020-09-12 | Livingston | New York | 36051 | 194 | 6 |
523340 | 523340 | 2020-09-11 | Livingston | New York | 36051 | 190 | 6 |
520104 | 520104 | 2020-09-10 | Livingston | New York | 36051 | 190 | 6 |
516868 | 516868 | 2020-09-09 | Livingston | New York | 36051 | 190 | 6 |
513633 | 513633 | 2020-09-08 | Livingston | New York | 36051 | 189 | 6 |
510400 | 510400 | 2020-09-07 | Livingston | New York | 36051 | 189 | 6 |
507167 | 507167 | 2020-09-06 | Livingston | New York | 36051 | 189 | 6 |
503935 | 503935 | 2020-09-05 | Livingston | New York | 36051 | 188 | 6 |
500701 | 500701 | 2020-09-04 | Livingston | New York | 36051 | 188 | 6 |
497467 | 497467 | 2020-09-03 | Livingston | New York | 36051 | 187 | 6 |
494234 | 494234 | 2020-09-02 | Livingston | New York | 36051 | 184 | 6 |
491000 | 491000 | 2020-09-01 | Livingston | New York | 36051 | 183 | 6 |
487767 | 487767 | 2020-08-31 | Livingston | New York | 36051 | 183 | 6 |
484534 | 484534 | 2020-08-30 | Livingston | New York | 36051 | 182 | 6 |
481299 | 481299 | 2020-08-29 | Livingston | New York | 36051 | 182 | 6 |
478066 | 478066 | 2020-08-28 | Livingston | New York | 36051 | 181 | 6 |
474833 | 474833 | 2020-08-27 | Livingston | New York | 36051 | 181 | 6 |
471599 | 471599 | 2020-08-26 | Livingston | New York | 36051 | 181 | 6 |
468367 | 468367 | 2020-08-25 | Livingston | New York | 36051 | 181 | 6 |
465139 | 465139 | 2020-08-24 | Livingston | New York | 36051 | 180 | 6 |
461910 | 461910 | 2020-08-23 | Livingston | New York | 36051 | 180 | 6 |
458682 | 458682 | 2020-08-22 | Livingston | New York | 36051 | 179 | 6 |
455454 | 455454 | 2020-08-21 | Livingston | New York | 36051 | 178 | 6 |
452226 | 452226 | 2020-08-20 | Livingston | New York | 36051 | 178 | 6 |
448998 | 448998 | 2020-08-19 | Livingston | New York | 36051 | 178 | 6 |
445770 | 445770 | 2020-08-18 | Livingston | New York | 36051 | 178 | 6 |
442544 | 442544 | 2020-08-17 | Livingston | New York | 36051 | 178 | 6 |
439317 | 439317 | 2020-08-16 | Livingston | New York | 36051 | 178 | 6 |
436092 | 436092 | 2020-08-15 | Livingston | New York | 36051 | 178 | 6 |
432866 | 432866 | 2020-08-14 | Livingston | New York | 36051 | 178 | 6 |
429640 | 429640 | 2020-08-13 | Livingston | New York | 36051 | 176 | 6 |
426415 | 426415 | 2020-08-12 | Livingston | New York | 36051 | 176 | 6 |
423192 | 423192 | 2020-08-11 | Livingston | New York | 36051 | 176 | 6 |
419969 | 419969 | 2020-08-10 | Livingston | New York | 36051 | 176 | 6 |
416749 | 416749 | 2020-08-09 | Livingston | New York | 36051 | 176 | 6 |
413528 | 413528 | 2020-08-08 | Livingston | New York | 36051 | 176 | 6 |
410308 | 410308 | 2020-08-07 | Livingston | New York | 36051 | 174 | 6 |
407088 | 407088 | 2020-08-06 | Livingston | New York | 36051 | 173 | 6 |
403869 | 403869 | 2020-08-05 | Livingston | New York | 36051 | 171 | 6 |
400651 | 400651 | 2020-08-04 | Livingston | New York | 36051 | 170 | 6 |
397436 | 397436 | 2020-08-03 | Livingston | New York | 36051 | 167 | 6 |
394219 | 394219 | 2020-08-02 | Livingston | New York | 36051 | 167 | 6 |
391003 | 391003 | 2020-08-01 | Livingston | New York | 36051 | 166 | 4 |
387786 | 387786 | 2020-07-31 | Livingston | New York | 36051 | 165 | 4 |
384569 | 384569 | 2020-07-30 | Livingston | New York | 36051 | 164 | 4 |
381351 | 381351 | 2020-07-29 | Livingston | New York | 36051 | 163 | 4 |
378134 | 378134 | 2020-07-28 | Livingston | New York | 36051 | 162 | 4 |
374918 | 374918 | 2020-07-27 | Livingston | New York | 36051 | 162 | 4 |
371706 | 371706 | 2020-07-26 | Livingston | New York | 36051 | 162 | 4 |
368494 | 368494 | 2020-07-25 | Livingston | New York | 36051 | 162 | 4 |
365285 | 365285 | 2020-07-24 | Livingston | New York | 36051 | 161 | 4 |
362079 | 362079 | 2020-07-23 | Livingston | New York | 36051 | 161 | 4 |
358873 | 358873 | 2020-07-22 | Livingston | New York | 36051 | 161 | 4 |
355669 | 355669 | 2020-07-21 | Livingston | New York | 36051 | 160 | 4 |
352466 | 352466 | 2020-07-20 | Livingston | New York | 36051 | 159 | 4 |
349263 | 349263 | 2020-07-19 | Livingston | New York | 36051 | 158 | 4 |
346062 | 346062 | 2020-07-18 | Livingston | New York | 36051 | 157 | 4 |
342863 | 342863 | 2020-07-17 | Livingston | New York | 36051 | 155 | 4 |
339665 | 339665 | 2020-07-16 | Livingston | New York | 36051 | 153 | 4 |
336469 | 336469 | 2020-07-15 | Livingston | New York | 36051 | 151 | 4 |
333275 | 333275 | 2020-07-14 | Livingston | New York | 36051 | 151 | 4 |
330085 | 330085 | 2020-07-13 | Livingston | New York | 36051 | 147 | 4 |
326898 | 326898 | 2020-07-12 | Livingston | New York | 36051 | 147 | 4 |
323714 | 323714 | 2020-07-11 | Livingston | New York | 36051 | 145 | 4 |
320534 | 320534 | 2020-07-10 | Livingston | New York | 36051 | 144 | 4 |
317357 | 317357 | 2020-07-09 | Livingston | New York | 36051 | 140 | 4 |
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);