ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,561 rows where county = "Allegany" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535622 | 535622 | 2020-09-15 | Allegany | Maryland | 24001 | 429 | 22 |
536262 | 536262 | 2020-09-15 | Allegany | New York | 36003 | 94 | 2 |
532387 | 532387 | 2020-09-14 | Allegany | Maryland | 24001 | 424 | 22 |
533026 | 533026 | 2020-09-14 | Allegany | New York | 36003 | 94 | 2 |
529151 | 529151 | 2020-09-13 | Allegany | Maryland | 24001 | 421 | 22 |
529791 | 529791 | 2020-09-13 | Allegany | New York | 36003 | 94 | 2 |
525915 | 525915 | 2020-09-12 | Allegany | Maryland | 24001 | 415 | 22 |
526554 | 526554 | 2020-09-12 | Allegany | New York | 36003 | 94 | 2 |
522679 | 522679 | 2020-09-11 | Allegany | Maryland | 24001 | 411 | 22 |
523318 | 523318 | 2020-09-11 | Allegany | New York | 36003 | 93 | 2 |
519442 | 519442 | 2020-09-10 | Allegany | Maryland | 24001 | 409 | 22 |
520082 | 520082 | 2020-09-10 | Allegany | New York | 36003 | 93 | 2 |
516207 | 516207 | 2020-09-09 | Allegany | Maryland | 24001 | 408 | 22 |
516846 | 516846 | 2020-09-09 | Allegany | New York | 36003 | 92 | 2 |
512973 | 512973 | 2020-09-08 | Allegany | Maryland | 24001 | 407 | 22 |
513611 | 513611 | 2020-09-08 | Allegany | New York | 36003 | 92 | 2 |
509741 | 509741 | 2020-09-07 | Allegany | Maryland | 24001 | 407 | 22 |
510378 | 510378 | 2020-09-07 | Allegany | New York | 36003 | 92 | 2 |
506508 | 506508 | 2020-09-06 | Allegany | Maryland | 24001 | 404 | 22 |
507145 | 507145 | 2020-09-06 | Allegany | New York | 36003 | 92 | 2 |
503275 | 503275 | 2020-09-05 | Allegany | Maryland | 24001 | 403 | 22 |
503913 | 503913 | 2020-09-05 | Allegany | New York | 36003 | 92 | 2 |
500041 | 500041 | 2020-09-04 | Allegany | Maryland | 24001 | 401 | 21 |
500679 | 500679 | 2020-09-04 | Allegany | New York | 36003 | 90 | 2 |
496807 | 496807 | 2020-09-03 | Allegany | Maryland | 24001 | 398 | 20 |
497445 | 497445 | 2020-09-03 | Allegany | New York | 36003 | 90 | 2 |
493574 | 493574 | 2020-09-02 | Allegany | Maryland | 24001 | 396 | 20 |
494212 | 494212 | 2020-09-02 | Allegany | New York | 36003 | 89 | 2 |
490340 | 490340 | 2020-09-01 | Allegany | Maryland | 24001 | 395 | 20 |
490978 | 490978 | 2020-09-01 | Allegany | New York | 36003 | 89 | 2 |
487107 | 487107 | 2020-08-31 | Allegany | Maryland | 24001 | 393 | 20 |
487745 | 487745 | 2020-08-31 | Allegany | New York | 36003 | 89 | 2 |
483873 | 483873 | 2020-08-30 | Allegany | Maryland | 24001 | 391 | 20 |
484512 | 484512 | 2020-08-30 | Allegany | New York | 36003 | 89 | 2 |
480638 | 480638 | 2020-08-29 | Allegany | Maryland | 24001 | 391 | 20 |
481277 | 481277 | 2020-08-29 | Allegany | New York | 36003 | 88 | 2 |
477406 | 477406 | 2020-08-28 | Allegany | Maryland | 24001 | 392 | 20 |
478044 | 478044 | 2020-08-28 | Allegany | New York | 36003 | 87 | 2 |
474173 | 474173 | 2020-08-27 | Allegany | Maryland | 24001 | 389 | 20 |
474811 | 474811 | 2020-08-27 | Allegany | New York | 36003 | 87 | 2 |
470941 | 470941 | 2020-08-26 | Allegany | Maryland | 24001 | 388 | 20 |
471577 | 471577 | 2020-08-26 | Allegany | New York | 36003 | 86 | 2 |
467711 | 467711 | 2020-08-25 | Allegany | Maryland | 24001 | 387 | 20 |
468345 | 468345 | 2020-08-25 | Allegany | New York | 36003 | 86 | 2 |
464482 | 464482 | 2020-08-24 | Allegany | Maryland | 24001 | 381 | 20 |
465117 | 465117 | 2020-08-24 | Allegany | New York | 36003 | 85 | 2 |
461251 | 461251 | 2020-08-23 | Allegany | Maryland | 24001 | 377 | 20 |
461888 | 461888 | 2020-08-23 | Allegany | New York | 36003 | 85 | 2 |
458024 | 458024 | 2020-08-22 | Allegany | Maryland | 24001 | 367 | 20 |
458660 | 458660 | 2020-08-22 | Allegany | New York | 36003 | 84 | 2 |
454796 | 454796 | 2020-08-21 | Allegany | Maryland | 24001 | 365 | 20 |
455432 | 455432 | 2020-08-21 | Allegany | New York | 36003 | 84 | 2 |
451568 | 451568 | 2020-08-20 | Allegany | Maryland | 24001 | 358 | 20 |
452204 | 452204 | 2020-08-20 | Allegany | New York | 36003 | 81 | 2 |
448340 | 448340 | 2020-08-19 | Allegany | Maryland | 24001 | 354 | 19 |
448976 | 448976 | 2020-08-19 | Allegany | New York | 36003 | 80 | 2 |
445114 | 445114 | 2020-08-18 | Allegany | Maryland | 24001 | 348 | 19 |
445748 | 445748 | 2020-08-18 | Allegany | New York | 36003 | 80 | 2 |
441888 | 441888 | 2020-08-17 | Allegany | Maryland | 24001 | 343 | 19 |
442522 | 442522 | 2020-08-17 | Allegany | New York | 36003 | 80 | 2 |
438661 | 438661 | 2020-08-16 | Allegany | Maryland | 24001 | 341 | 19 |
439295 | 439295 | 2020-08-16 | Allegany | New York | 36003 | 80 | 2 |
435436 | 435436 | 2020-08-15 | Allegany | Maryland | 24001 | 338 | 18 |
436070 | 436070 | 2020-08-15 | Allegany | New York | 36003 | 80 | 2 |
432210 | 432210 | 2020-08-14 | Allegany | Maryland | 24001 | 326 | 18 |
432844 | 432844 | 2020-08-14 | Allegany | New York | 36003 | 80 | 2 |
428983 | 428983 | 2020-08-13 | Allegany | Maryland | 24001 | 312 | 18 |
429618 | 429618 | 2020-08-13 | Allegany | New York | 36003 | 80 | 2 |
425759 | 425759 | 2020-08-12 | Allegany | Maryland | 24001 | 303 | 18 |
426393 | 426393 | 2020-08-12 | Allegany | New York | 36003 | 80 | 2 |
422537 | 422537 | 2020-08-11 | Allegany | Maryland | 24001 | 300 | 18 |
423170 | 423170 | 2020-08-11 | Allegany | New York | 36003 | 80 | 2 |
419315 | 419315 | 2020-08-10 | Allegany | Maryland | 24001 | 299 | 18 |
419947 | 419947 | 2020-08-10 | Allegany | New York | 36003 | 80 | 2 |
416094 | 416094 | 2020-08-09 | Allegany | Maryland | 24001 | 291 | 18 |
416727 | 416727 | 2020-08-09 | Allegany | New York | 36003 | 79 | 2 |
412874 | 412874 | 2020-08-08 | Allegany | Maryland | 24001 | 287 | 18 |
413506 | 413506 | 2020-08-08 | Allegany | New York | 36003 | 79 | 2 |
409654 | 409654 | 2020-08-07 | Allegany | Maryland | 24001 | 280 | 18 |
410286 | 410286 | 2020-08-07 | Allegany | New York | 36003 | 79 | 2 |
406434 | 406434 | 2020-08-06 | Allegany | Maryland | 24001 | 279 | 18 |
407066 | 407066 | 2020-08-06 | Allegany | New York | 36003 | 78 | 2 |
403216 | 403216 | 2020-08-05 | Allegany | Maryland | 24001 | 276 | 18 |
403847 | 403847 | 2020-08-05 | Allegany | New York | 36003 | 76 | 0 |
399999 | 399999 | 2020-08-04 | Allegany | Maryland | 24001 | 276 | 18 |
400629 | 400629 | 2020-08-04 | Allegany | New York | 36003 | 75 | 0 |
396785 | 396785 | 2020-08-03 | Allegany | Maryland | 24001 | 273 | 18 |
397414 | 397414 | 2020-08-03 | Allegany | New York | 36003 | 75 | 0 |
393569 | 393569 | 2020-08-02 | Allegany | Maryland | 24001 | 271 | 18 |
394197 | 394197 | 2020-08-02 | Allegany | New York | 36003 | 74 | 0 |
390352 | 390352 | 2020-08-01 | Allegany | Maryland | 24001 | 267 | 18 |
390981 | 390981 | 2020-08-01 | Allegany | New York | 36003 | 74 | 0 |
387135 | 387135 | 2020-07-31 | Allegany | Maryland | 24001 | 266 | 18 |
387764 | 387764 | 2020-07-31 | Allegany | New York | 36003 | 74 | 0 |
383917 | 383917 | 2020-07-30 | Allegany | Maryland | 24001 | 264 | 18 |
384547 | 384547 | 2020-07-30 | Allegany | New York | 36003 | 74 | 0 |
380700 | 380700 | 2020-07-29 | Allegany | Maryland | 24001 | 260 | 18 |
381329 | 381329 | 2020-07-29 | Allegany | New York | 36003 | 74 | 0 |
377483 | 377483 | 2020-07-28 | Allegany | Maryland | 24001 | 262 | 18 |
378112 | 378112 | 2020-07-28 | Allegany | New York | 36003 | 74 | 0 |
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);