ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Broome" 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 |
---|---|---|---|---|---|---|---|
636732 | 636732 | 2020-10-16 | Broome | New York | 36007 | 2784 | 87 |
633486 | 633486 | 2020-10-15 | Broome | New York | 36007 | 2703 | 87 |
630241 | 630241 | 2020-10-14 | Broome | New York | 36007 | 2607 | 86 |
626997 | 626997 | 2020-10-13 | Broome | New York | 36007 | 2538 | 86 |
623755 | 623755 | 2020-10-12 | Broome | New York | 36007 | 2485 | 86 |
620512 | 620512 | 2020-10-11 | Broome | New York | 36007 | 2442 | 86 |
617270 | 617270 | 2020-10-10 | Broome | New York | 36007 | 2400 | 86 |
614028 | 614028 | 2020-10-09 | Broome | New York | 36007 | 2314 | 86 |
610787 | 610787 | 2020-10-08 | Broome | New York | 36007 | 2239 | 86 |
607545 | 607545 | 2020-10-07 | Broome | New York | 36007 | 2131 | 86 |
604302 | 604302 | 2020-10-06 | Broome | New York | 36007 | 2026 | 86 |
601060 | 601060 | 2020-10-05 | Broome | New York | 36007 | 1974 | 86 |
597817 | 597817 | 2020-10-04 | Broome | New York | 36007 | 1947 | 85 |
594574 | 594574 | 2020-10-03 | Broome | New York | 36007 | 1896 | 85 |
591333 | 591333 | 2020-10-02 | Broome | New York | 36007 | 1786 | 85 |
588092 | 588092 | 2020-10-01 | Broome | New York | 36007 | 1729 | 85 |
584852 | 584852 | 2020-09-30 | Broome | New York | 36007 | 1673 | 85 |
581611 | 581611 | 2020-09-29 | Broome | New York | 36007 | 1642 | 85 |
578371 | 578371 | 2020-09-28 | Broome | New York | 36007 | 1606 | 85 |
575130 | 575130 | 2020-09-27 | Broome | New York | 36007 | 1572 | 85 |
571886 | 571886 | 2020-09-26 | Broome | New York | 36007 | 1550 | 85 |
568644 | 568644 | 2020-09-25 | Broome | New York | 36007 | 1513 | 85 |
565403 | 565403 | 2020-09-24 | Broome | New York | 36007 | 1496 | 85 |
562162 | 562162 | 2020-09-23 | Broome | New York | 36007 | 1480 | 85 |
558925 | 558925 | 2020-09-22 | Broome | New York | 36007 | 1476 | 85 |
555688 | 555688 | 2020-09-21 | Broome | New York | 36007 | 1472 | 85 |
552451 | 552451 | 2020-09-20 | Broome | New York | 36007 | 1465 | 85 |
549212 | 549212 | 2020-09-19 | Broome | New York | 36007 | 1459 | 85 |
545973 | 545973 | 2020-09-18 | Broome | New York | 36007 | 1450 | 85 |
542736 | 542736 | 2020-09-17 | Broome | New York | 36007 | 1437 | 85 |
539500 | 539500 | 2020-09-16 | Broome | New York | 36007 | 1428 | 85 |
536263 | 536263 | 2020-09-15 | Broome | New York | 36007 | 1423 | 85 |
533027 | 533027 | 2020-09-14 | Broome | New York | 36007 | 1420 | 85 |
529792 | 529792 | 2020-09-13 | Broome | New York | 36007 | 1418 | 85 |
526555 | 526555 | 2020-09-12 | Broome | New York | 36007 | 1410 | 85 |
523319 | 523319 | 2020-09-11 | Broome | New York | 36007 | 1395 | 85 |
520083 | 520083 | 2020-09-10 | Broome | New York | 36007 | 1383 | 85 |
516847 | 516847 | 2020-09-09 | Broome | New York | 36007 | 1378 | 84 |
513612 | 513612 | 2020-09-08 | Broome | New York | 36007 | 1374 | 84 |
510379 | 510379 | 2020-09-07 | Broome | New York | 36007 | 1365 | 84 |
507146 | 507146 | 2020-09-06 | Broome | New York | 36007 | 1357 | 84 |
503914 | 503914 | 2020-09-05 | Broome | New York | 36007 | 1350 | 83 |
500680 | 500680 | 2020-09-04 | Broome | New York | 36007 | 1342 | 83 |
497446 | 497446 | 2020-09-03 | Broome | New York | 36007 | 1333 | 83 |
494213 | 494213 | 2020-09-02 | Broome | New York | 36007 | 1315 | 83 |
490979 | 490979 | 2020-09-01 | Broome | New York | 36007 | 1311 | 82 |
487746 | 487746 | 2020-08-31 | Broome | New York | 36007 | 1307 | 82 |
484513 | 484513 | 2020-08-30 | Broome | New York | 36007 | 1295 | 82 |
481278 | 481278 | 2020-08-29 | Broome | New York | 36007 | 1286 | 82 |
478045 | 478045 | 2020-08-28 | Broome | New York | 36007 | 1283 | 82 |
474812 | 474812 | 2020-08-27 | Broome | New York | 36007 | 1274 | 82 |
471578 | 471578 | 2020-08-26 | Broome | New York | 36007 | 1268 | 82 |
468346 | 468346 | 2020-08-25 | Broome | New York | 36007 | 1256 | 82 |
465118 | 465118 | 2020-08-24 | Broome | New York | 36007 | 1250 | 81 |
461889 | 461889 | 2020-08-23 | Broome | New York | 36007 | 1239 | 81 |
458661 | 458661 | 2020-08-22 | Broome | New York | 36007 | 1227 | 80 |
455433 | 455433 | 2020-08-21 | Broome | New York | 36007 | 1211 | 80 |
452205 | 452205 | 2020-08-20 | Broome | New York | 36007 | 1196 | 80 |
448977 | 448977 | 2020-08-19 | Broome | New York | 36007 | 1189 | 80 |
445749 | 445749 | 2020-08-18 | Broome | New York | 36007 | 1177 | 79 |
442523 | 442523 | 2020-08-17 | Broome | New York | 36007 | 1172 | 78 |
439296 | 439296 | 2020-08-16 | Broome | New York | 36007 | 1166 | 78 |
436071 | 436071 | 2020-08-15 | Broome | New York | 36007 | 1165 | 78 |
432845 | 432845 | 2020-08-14 | Broome | New York | 36007 | 1165 | 78 |
429619 | 429619 | 2020-08-13 | Broome | New York | 36007 | 1153 | 78 |
426394 | 426394 | 2020-08-12 | Broome | New York | 36007 | 1150 | 75 |
423171 | 423171 | 2020-08-11 | Broome | New York | 36007 | 1143 | 75 |
419948 | 419948 | 2020-08-10 | Broome | New York | 36007 | 1131 | 74 |
416728 | 416728 | 2020-08-09 | Broome | New York | 36007 | 1126 | 74 |
413507 | 413507 | 2020-08-08 | Broome | New York | 36007 | 1120 | 74 |
410287 | 410287 | 2020-08-07 | Broome | New York | 36007 | 1115 | 74 |
407067 | 407067 | 2020-08-06 | Broome | New York | 36007 | 1094 | 74 |
403848 | 403848 | 2020-08-05 | Broome | New York | 36007 | 1082 | 78 |
400630 | 400630 | 2020-08-04 | Broome | New York | 36007 | 1078 | 78 |
397415 | 397415 | 2020-08-03 | Broome | New York | 36007 | 1064 | 78 |
394198 | 394198 | 2020-08-02 | Broome | New York | 36007 | 1054 | 77 |
390982 | 390982 | 2020-08-01 | Broome | New York | 36007 | 1048 | 76 |
387765 | 387765 | 2020-07-31 | Broome | New York | 36007 | 1037 | 76 |
384548 | 384548 | 2020-07-30 | Broome | New York | 36007 | 1029 | 76 |
381330 | 381330 | 2020-07-29 | Broome | New York | 36007 | 1015 | 74 |
378113 | 378113 | 2020-07-28 | Broome | New York | 36007 | 992 | 73 |
374897 | 374897 | 2020-07-27 | Broome | New York | 36007 | 986 | 72 |
371685 | 371685 | 2020-07-26 | Broome | New York | 36007 | 978 | 72 |
368473 | 368473 | 2020-07-25 | Broome | New York | 36007 | 966 | 72 |
365264 | 365264 | 2020-07-24 | Broome | New York | 36007 | 954 | 71 |
362058 | 362058 | 2020-07-23 | Broome | New York | 36007 | 934 | 70 |
358852 | 358852 | 2020-07-22 | Broome | New York | 36007 | 930 | 69 |
355648 | 355648 | 2020-07-21 | Broome | New York | 36007 | 917 | 69 |
352445 | 352445 | 2020-07-20 | Broome | New York | 36007 | 902 | 69 |
349242 | 349242 | 2020-07-19 | Broome | New York | 36007 | 883 | 69 |
346041 | 346041 | 2020-07-18 | Broome | New York | 36007 | 877 | 69 |
342842 | 342842 | 2020-07-17 | Broome | New York | 36007 | 870 | 69 |
339644 | 339644 | 2020-07-16 | Broome | New York | 36007 | 861 | 68 |
336448 | 336448 | 2020-07-15 | Broome | New York | 36007 | 852 | 67 |
333254 | 333254 | 2020-07-14 | Broome | New York | 36007 | 841 | 66 |
330064 | 330064 | 2020-07-13 | Broome | New York | 36007 | 827 | 64 |
326877 | 326877 | 2020-07-12 | Broome | New York | 36007 | 820 | 63 |
323693 | 323693 | 2020-07-11 | Broome | New York | 36007 | 807 | 63 |
320513 | 320513 | 2020-07-10 | Broome | New York | 36007 | 784 | 63 |
317336 | 317336 | 2020-07-09 | Broome | New York | 36007 | 770 | 63 |
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);