ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Monroe" 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 |
---|---|---|---|---|---|---|---|
636755 | 636755 | 2020-10-16 | Monroe | New York | 36055 | 6629 | 260 |
633509 | 633509 | 2020-10-15 | Monroe | New York | 36055 | 6573 | 260 |
630264 | 630264 | 2020-10-14 | Monroe | New York | 36055 | 6517 | 260 |
627020 | 627020 | 2020-10-13 | Monroe | New York | 36055 | 6491 | 260 |
623778 | 623778 | 2020-10-12 | Monroe | New York | 36055 | 6454 | 260 |
620535 | 620535 | 2020-10-11 | Monroe | New York | 36055 | 6422 | 260 |
617293 | 617293 | 2020-10-10 | Monroe | New York | 36055 | 6388 | 260 |
614051 | 614051 | 2020-10-09 | Monroe | New York | 36055 | 6350 | 260 |
610810 | 610810 | 2020-10-08 | Monroe | New York | 36055 | 6317 | 260 |
607568 | 607568 | 2020-10-07 | Monroe | New York | 36055 | 6267 | 260 |
604325 | 604325 | 2020-10-06 | Monroe | New York | 36055 | 6249 | 260 |
601083 | 601083 | 2020-10-05 | Monroe | New York | 36055 | 6221 | 260 |
597840 | 597840 | 2020-10-04 | Monroe | New York | 36055 | 6207 | 260 |
594597 | 594597 | 2020-10-03 | Monroe | New York | 36055 | 6187 | 260 |
591356 | 591356 | 2020-10-02 | Monroe | New York | 36055 | 6161 | 260 |
588115 | 588115 | 2020-10-01 | Monroe | New York | 36055 | 6122 | 260 |
584875 | 584875 | 2020-09-30 | Monroe | New York | 36055 | 6086 | 260 |
581634 | 581634 | 2020-09-29 | Monroe | New York | 36055 | 6075 | 260 |
578394 | 578394 | 2020-09-28 | Monroe | New York | 36055 | 6046 | 260 |
575153 | 575153 | 2020-09-27 | Monroe | New York | 36055 | 6027 | 259 |
571909 | 571909 | 2020-09-26 | Monroe | New York | 36055 | 6003 | 259 |
568667 | 568667 | 2020-09-25 | Monroe | New York | 36055 | 5986 | 259 |
565426 | 565426 | 2020-09-24 | Monroe | New York | 36055 | 5971 | 259 |
562185 | 562185 | 2020-09-23 | Monroe | New York | 36055 | 5941 | 259 |
558948 | 558948 | 2020-09-22 | Monroe | New York | 36055 | 5926 | 259 |
555711 | 555711 | 2020-09-21 | Monroe | New York | 36055 | 5912 | 259 |
552474 | 552474 | 2020-09-20 | Monroe | New York | 36055 | 5895 | 259 |
549235 | 549235 | 2020-09-19 | Monroe | New York | 36055 | 5877 | 259 |
545996 | 545996 | 2020-09-18 | Monroe | New York | 36055 | 5858 | 259 |
542759 | 542759 | 2020-09-17 | Monroe | New York | 36055 | 5840 | 259 |
539523 | 539523 | 2020-09-16 | Monroe | New York | 36055 | 5810 | 259 |
536286 | 536286 | 2020-09-15 | Monroe | New York | 36055 | 5794 | 258 |
533050 | 533050 | 2020-09-14 | Monroe | New York | 36055 | 5765 | 258 |
529815 | 529815 | 2020-09-13 | Monroe | New York | 36055 | 5728 | 258 |
526578 | 526578 | 2020-09-12 | Monroe | New York | 36055 | 5713 | 258 |
523342 | 523342 | 2020-09-11 | Monroe | New York | 36055 | 5677 | 258 |
520106 | 520106 | 2020-09-10 | Monroe | New York | 36055 | 5649 | 258 |
516870 | 516870 | 2020-09-09 | Monroe | New York | 36055 | 5616 | 258 |
513635 | 513635 | 2020-09-08 | Monroe | New York | 36055 | 5603 | 258 |
510402 | 510402 | 2020-09-07 | Monroe | New York | 36055 | 5586 | 258 |
507169 | 507169 | 2020-09-06 | Monroe | New York | 36055 | 5573 | 258 |
503937 | 503937 | 2020-09-05 | Monroe | New York | 36055 | 5552 | 258 |
500703 | 500703 | 2020-09-04 | Monroe | New York | 36055 | 5530 | 258 |
497469 | 497469 | 2020-09-03 | Monroe | New York | 36055 | 5503 | 258 |
494236 | 494236 | 2020-09-02 | Monroe | New York | 36055 | 5469 | 257 |
491002 | 491002 | 2020-09-01 | Monroe | New York | 36055 | 5463 | 257 |
487769 | 487769 | 2020-08-31 | Monroe | New York | 36055 | 5453 | 257 |
484536 | 484536 | 2020-08-30 | Monroe | New York | 36055 | 5444 | 257 |
481301 | 481301 | 2020-08-29 | Monroe | New York | 36055 | 5423 | 256 |
478068 | 478068 | 2020-08-28 | Monroe | New York | 36055 | 5399 | 256 |
474835 | 474835 | 2020-08-27 | Monroe | New York | 36055 | 5386 | 256 |
471601 | 471601 | 2020-08-26 | Monroe | New York | 36055 | 5365 | 255 |
468369 | 468369 | 2020-08-25 | Monroe | New York | 36055 | 5349 | 255 |
465141 | 465141 | 2020-08-24 | Monroe | New York | 36055 | 5331 | 255 |
461912 | 461912 | 2020-08-23 | Monroe | New York | 36055 | 5318 | 255 |
458684 | 458684 | 2020-08-22 | Monroe | New York | 36055 | 5298 | 255 |
455456 | 455456 | 2020-08-21 | Monroe | New York | 36055 | 5274 | 255 |
452228 | 452228 | 2020-08-20 | Monroe | New York | 36055 | 5257 | 255 |
449000 | 449000 | 2020-08-19 | Monroe | New York | 36055 | 5242 | 255 |
445772 | 445772 | 2020-08-18 | Monroe | New York | 36055 | 5214 | 255 |
442546 | 442546 | 2020-08-17 | Monroe | New York | 36055 | 5184 | 255 |
439319 | 439319 | 2020-08-16 | Monroe | New York | 36055 | 5166 | 255 |
436094 | 436094 | 2020-08-15 | Monroe | New York | 36055 | 5144 | 255 |
432868 | 432868 | 2020-08-14 | Monroe | New York | 36055 | 5123 | 255 |
429642 | 429642 | 2020-08-13 | Monroe | New York | 36055 | 5080 | 255 |
426417 | 426417 | 2020-08-12 | Monroe | New York | 36055 | 5036 | 255 |
423194 | 423194 | 2020-08-11 | Monroe | New York | 36055 | 5003 | 255 |
419971 | 419971 | 2020-08-10 | Monroe | New York | 36055 | 4977 | 254 |
416751 | 416751 | 2020-08-09 | Monroe | New York | 36055 | 4957 | 254 |
413530 | 413530 | 2020-08-08 | Monroe | New York | 36055 | 4923 | 254 |
410310 | 410310 | 2020-08-07 | Monroe | New York | 36055 | 4902 | 254 |
407090 | 407090 | 2020-08-06 | Monroe | New York | 36055 | 4869 | 254 |
403871 | 403871 | 2020-08-05 | Monroe | New York | 36055 | 4842 | 269 |
400653 | 400653 | 2020-08-04 | Monroe | New York | 36055 | 4822 | 269 |
397438 | 397438 | 2020-08-03 | Monroe | New York | 36055 | 4791 | 268 |
394221 | 394221 | 2020-08-02 | Monroe | New York | 36055 | 4769 | 268 |
391005 | 391005 | 2020-08-01 | Monroe | New York | 36055 | 4743 | 266 |
387788 | 387788 | 2020-07-31 | Monroe | New York | 36055 | 4711 | 266 |
384571 | 384571 | 2020-07-30 | Monroe | New York | 36055 | 4678 | 266 |
381353 | 381353 | 2020-07-29 | Monroe | New York | 36055 | 4657 | 266 |
378136 | 378136 | 2020-07-28 | Monroe | New York | 36055 | 4633 | 266 |
374920 | 374920 | 2020-07-27 | Monroe | New York | 36055 | 4621 | 266 |
371708 | 371708 | 2020-07-26 | Monroe | New York | 36055 | 4592 | 266 |
368496 | 368496 | 2020-07-25 | Monroe | New York | 36055 | 4570 | 266 |
365287 | 365287 | 2020-07-24 | Monroe | New York | 36055 | 4538 | 266 |
362081 | 362081 | 2020-07-23 | Monroe | New York | 36055 | 4512 | 266 |
358875 | 358875 | 2020-07-22 | Monroe | New York | 36055 | 4493 | 266 |
355671 | 355671 | 2020-07-21 | Monroe | New York | 36055 | 4453 | 265 |
352468 | 352468 | 2020-07-20 | Monroe | New York | 36055 | 4423 | 265 |
349265 | 349265 | 2020-07-19 | Monroe | New York | 36055 | 4402 | 265 |
346064 | 346064 | 2020-07-18 | Monroe | New York | 36055 | 4384 | 264 |
342865 | 342865 | 2020-07-17 | Monroe | New York | 36055 | 4354 | 264 |
339667 | 339667 | 2020-07-16 | Monroe | New York | 36055 | 4318 | 264 |
336471 | 336471 | 2020-07-15 | Monroe | New York | 36055 | 4282 | 264 |
333277 | 333277 | 2020-07-14 | Monroe | New York | 36055 | 4248 | 264 |
330087 | 330087 | 2020-07-13 | Monroe | New York | 36055 | 4201 | 264 |
326900 | 326900 | 2020-07-12 | Monroe | New York | 36055 | 4178 | 264 |
323716 | 323716 | 2020-07-11 | Monroe | New York | 36055 | 4154 | 263 |
320536 | 320536 | 2020-07-10 | Monroe | New York | 36055 | 4121 | 263 |
317359 | 317359 | 2020-07-09 | Monroe | New York | 36055 | 4075 | 263 |
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);