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 |
---|---|---|---|---|---|---|---|
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 |
314162 | 314162 | 2020-07-08 | Broome | New York | 36007 | 766 | 63 |
310991 | 310991 | 2020-07-07 | Broome | New York | 36007 | 762 | 62 |
307823 | 307823 | 2020-07-06 | Broome | New York | 36007 | 757 | 62 |
304656 | 304656 | 2020-07-05 | Broome | New York | 36007 | 753 | 62 |
301493 | 301493 | 2020-07-04 | Broome | New York | 36007 | 752 | 62 |
298330 | 298330 | 2020-07-03 | Broome | New York | 36007 | 736 | 62 |
295170 | 295170 | 2020-07-02 | Broome | New York | 36007 | 729 | 62 |
292015 | 292015 | 2020-07-01 | Broome | New York | 36007 | 722 | 61 |
288863 | 288863 | 2020-06-30 | Broome | New York | 36007 | 716 | 61 |
285713 | 285713 | 2020-06-29 | Broome | New York | 36007 | 710 | 61 |
282568 | 282568 | 2020-06-28 | Broome | New York | 36007 | 703 | 61 |
279422 | 279422 | 2020-06-27 | Broome | New York | 36007 | 701 | 61 |
276274 | 276274 | 2020-06-26 | Broome | New York | 36007 | 697 | 61 |
273128 | 273128 | 2020-06-25 | Broome | New York | 36007 | 680 | 61 |
269989 | 269989 | 2020-06-24 | Broome | New York | 36007 | 671 | 61 |
266855 | 266855 | 2020-06-23 | Broome | New York | 36007 | 671 | 61 |
263727 | 263727 | 2020-06-22 | Broome | New York | 36007 | 670 | 59 |
260599 | 260599 | 2020-06-21 | Broome | New York | 36007 | 668 | 59 |
257472 | 257472 | 2020-06-20 | Broome | New York | 36007 | 665 | 59 |
254349 | 254349 | 2020-06-19 | Broome | New York | 36007 | 663 | 59 |
251234 | 251234 | 2020-06-18 | Broome | New York | 36007 | 657 | 59 |
248119 | 248119 | 2020-06-17 | Broome | New York | 36007 | 657 | 59 |
245006 | 245006 | 2020-06-16 | Broome | New York | 36007 | 656 | 59 |
241894 | 241894 | 2020-06-15 | Broome | New York | 36007 | 655 | 59 |
238785 | 238785 | 2020-06-14 | Broome | New York | 36007 | 651 | 59 |
235677 | 235677 | 2020-06-13 | Broome | New York | 36007 | 647 | 59 |
232572 | 232572 | 2020-06-12 | Broome | New York | 36007 | 644 | 58 |
229467 | 229467 | 2020-06-11 | Broome | New York | 36007 | 641 | 58 |
226363 | 226363 | 2020-06-10 | Broome | New York | 36007 | 630 | 57 |
223263 | 223263 | 2020-06-09 | Broome | New York | 36007 | 627 | 57 |
220169 | 220169 | 2020-06-08 | Broome | New York | 36007 | 624 | 56 |
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);