ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Ontario" 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 |
---|---|---|---|---|---|---|---|
636762 | 636762 | 2020-10-16 | Ontario | New York | 36069 | 549 | 28 |
633516 | 633516 | 2020-10-15 | Ontario | New York | 36069 | 537 | 28 |
630271 | 630271 | 2020-10-14 | Ontario | New York | 36069 | 532 | 28 |
627027 | 627027 | 2020-10-13 | Ontario | New York | 36069 | 527 | 28 |
623785 | 623785 | 2020-10-12 | Ontario | New York | 36069 | 519 | 28 |
620542 | 620542 | 2020-10-11 | Ontario | New York | 36069 | 516 | 28 |
617300 | 617300 | 2020-10-10 | Ontario | New York | 36069 | 512 | 28 |
614058 | 614058 | 2020-10-09 | Ontario | New York | 36069 | 511 | 28 |
610817 | 610817 | 2020-10-08 | Ontario | New York | 36069 | 505 | 28 |
607575 | 607575 | 2020-10-07 | Ontario | New York | 36069 | 502 | 28 |
604332 | 604332 | 2020-10-06 | Ontario | New York | 36069 | 500 | 28 |
601090 | 601090 | 2020-10-05 | Ontario | New York | 36069 | 491 | 28 |
597847 | 597847 | 2020-10-04 | Ontario | New York | 36069 | 489 | 28 |
594604 | 594604 | 2020-10-03 | Ontario | New York | 36069 | 486 | 28 |
591363 | 591363 | 2020-10-02 | Ontario | New York | 36069 | 484 | 28 |
588122 | 588122 | 2020-10-01 | Ontario | New York | 36069 | 481 | 28 |
584882 | 584882 | 2020-09-30 | Ontario | New York | 36069 | 475 | 28 |
581641 | 581641 | 2020-09-29 | Ontario | New York | 36069 | 475 | 28 |
578401 | 578401 | 2020-09-28 | Ontario | New York | 36069 | 474 | 28 |
575160 | 575160 | 2020-09-27 | Ontario | New York | 36069 | 473 | 28 |
571916 | 571916 | 2020-09-26 | Ontario | New York | 36069 | 471 | 28 |
568674 | 568674 | 2020-09-25 | Ontario | New York | 36069 | 469 | 28 |
565433 | 565433 | 2020-09-24 | Ontario | New York | 36069 | 467 | 28 |
562192 | 562192 | 2020-09-23 | Ontario | New York | 36069 | 466 | 28 |
558955 | 558955 | 2020-09-22 | Ontario | New York | 36069 | 465 | 28 |
555718 | 555718 | 2020-09-21 | Ontario | New York | 36069 | 464 | 28 |
552481 | 552481 | 2020-09-20 | Ontario | New York | 36069 | 461 | 28 |
549242 | 549242 | 2020-09-19 | Ontario | New York | 36069 | 456 | 28 |
546003 | 546003 | 2020-09-18 | Ontario | New York | 36069 | 454 | 28 |
542766 | 542766 | 2020-09-17 | Ontario | New York | 36069 | 452 | 28 |
539530 | 539530 | 2020-09-16 | Ontario | New York | 36069 | 449 | 28 |
536293 | 536293 | 2020-09-15 | Ontario | New York | 36069 | 444 | 28 |
533057 | 533057 | 2020-09-14 | Ontario | New York | 36069 | 443 | 28 |
529822 | 529822 | 2020-09-13 | Ontario | New York | 36069 | 439 | 28 |
526585 | 526585 | 2020-09-12 | Ontario | New York | 36069 | 435 | 28 |
523349 | 523349 | 2020-09-11 | Ontario | New York | 36069 | 427 | 28 |
520113 | 520113 | 2020-09-10 | Ontario | New York | 36069 | 423 | 28 |
516877 | 516877 | 2020-09-09 | Ontario | New York | 36069 | 421 | 28 |
513642 | 513642 | 2020-09-08 | Ontario | New York | 36069 | 413 | 28 |
510409 | 510409 | 2020-09-07 | Ontario | New York | 36069 | 408 | 28 |
507176 | 507176 | 2020-09-06 | Ontario | New York | 36069 | 405 | 28 |
503944 | 503944 | 2020-09-05 | Ontario | New York | 36069 | 401 | 28 |
500710 | 500710 | 2020-09-04 | Ontario | New York | 36069 | 398 | 28 |
497476 | 497476 | 2020-09-03 | Ontario | New York | 36069 | 396 | 28 |
494243 | 494243 | 2020-09-02 | Ontario | New York | 36069 | 393 | 28 |
491009 | 491009 | 2020-09-01 | Ontario | New York | 36069 | 393 | 28 |
487776 | 487776 | 2020-08-31 | Ontario | New York | 36069 | 391 | 28 |
484543 | 484543 | 2020-08-30 | Ontario | New York | 36069 | 389 | 28 |
481308 | 481308 | 2020-08-29 | Ontario | New York | 36069 | 386 | 28 |
478075 | 478075 | 2020-08-28 | Ontario | New York | 36069 | 385 | 28 |
474842 | 474842 | 2020-08-27 | Ontario | New York | 36069 | 384 | 28 |
471608 | 471608 | 2020-08-26 | Ontario | New York | 36069 | 381 | 28 |
468376 | 468376 | 2020-08-25 | Ontario | New York | 36069 | 381 | 28 |
465148 | 465148 | 2020-08-24 | Ontario | New York | 36069 | 381 | 28 |
461919 | 461919 | 2020-08-23 | Ontario | New York | 36069 | 381 | 28 |
458691 | 458691 | 2020-08-22 | Ontario | New York | 36069 | 378 | 28 |
455463 | 455463 | 2020-08-21 | Ontario | New York | 36069 | 373 | 28 |
452235 | 452235 | 2020-08-20 | Ontario | New York | 36069 | 373 | 28 |
449007 | 449007 | 2020-08-19 | Ontario | New York | 36069 | 371 | 28 |
445779 | 445779 | 2020-08-18 | Ontario | New York | 36069 | 371 | 28 |
442553 | 442553 | 2020-08-17 | Ontario | New York | 36069 | 369 | 28 |
439326 | 439326 | 2020-08-16 | Ontario | New York | 36069 | 368 | 28 |
436101 | 436101 | 2020-08-15 | Ontario | New York | 36069 | 367 | 27 |
432875 | 432875 | 2020-08-14 | Ontario | New York | 36069 | 366 | 27 |
429649 | 429649 | 2020-08-13 | Ontario | New York | 36069 | 365 | 27 |
426424 | 426424 | 2020-08-12 | Ontario | New York | 36069 | 363 | 27 |
423201 | 423201 | 2020-08-11 | Ontario | New York | 36069 | 362 | 27 |
419978 | 419978 | 2020-08-10 | Ontario | New York | 36069 | 361 | 27 |
416758 | 416758 | 2020-08-09 | Ontario | New York | 36069 | 360 | 27 |
413537 | 413537 | 2020-08-08 | Ontario | New York | 36069 | 357 | 27 |
410317 | 410317 | 2020-08-07 | Ontario | New York | 36069 | 357 | 27 |
407097 | 407097 | 2020-08-06 | Ontario | New York | 36069 | 355 | 27 |
403878 | 403878 | 2020-08-05 | Ontario | New York | 36069 | 352 | 26 |
400660 | 400660 | 2020-08-04 | Ontario | New York | 36069 | 352 | 26 |
397445 | 397445 | 2020-08-03 | Ontario | New York | 36069 | 351 | 26 |
394228 | 394228 | 2020-08-02 | Ontario | New York | 36069 | 349 | 26 |
391012 | 391012 | 2020-08-01 | Ontario | New York | 36069 | 349 | 26 |
387795 | 387795 | 2020-07-31 | Ontario | New York | 36069 | 349 | 26 |
384578 | 384578 | 2020-07-30 | Ontario | New York | 36069 | 349 | 26 |
381360 | 381360 | 2020-07-29 | Ontario | New York | 36069 | 347 | 26 |
378143 | 378143 | 2020-07-28 | Ontario | New York | 36069 | 345 | 26 |
374927 | 374927 | 2020-07-27 | Ontario | New York | 36069 | 343 | 26 |
371715 | 371715 | 2020-07-26 | Ontario | New York | 36069 | 341 | 26 |
368503 | 368503 | 2020-07-25 | Ontario | New York | 36069 | 338 | 26 |
365294 | 365294 | 2020-07-24 | Ontario | New York | 36069 | 337 | 26 |
362088 | 362088 | 2020-07-23 | Ontario | New York | 36069 | 334 | 26 |
358882 | 358882 | 2020-07-22 | Ontario | New York | 36069 | 333 | 26 |
355678 | 355678 | 2020-07-21 | Ontario | New York | 36069 | 329 | 26 |
352475 | 352475 | 2020-07-20 | Ontario | New York | 36069 | 326 | 26 |
349272 | 349272 | 2020-07-19 | Ontario | New York | 36069 | 324 | 26 |
346071 | 346071 | 2020-07-18 | Ontario | New York | 36069 | 324 | 26 |
342872 | 342872 | 2020-07-17 | Ontario | New York | 36069 | 319 | 26 |
339674 | 339674 | 2020-07-16 | Ontario | New York | 36069 | 317 | 26 |
336478 | 336478 | 2020-07-15 | Ontario | New York | 36069 | 312 | 26 |
333284 | 333284 | 2020-07-14 | Ontario | New York | 36069 | 307 | 25 |
330094 | 330094 | 2020-07-13 | Ontario | New York | 36069 | 302 | 25 |
326907 | 326907 | 2020-07-12 | Ontario | New York | 36069 | 300 | 25 |
323723 | 323723 | 2020-07-11 | Ontario | New York | 36069 | 296 | 25 |
320543 | 320543 | 2020-07-10 | Ontario | New York | 36069 | 293 | 25 |
317366 | 317366 | 2020-07-09 | Ontario | New York | 36069 | 290 | 25 |
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);