ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Hays" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637609 | 637609 | 2020-10-16 | Hays | Texas | 48209 | 6155 | 70 |
634364 | 634364 | 2020-10-15 | Hays | Texas | 48209 | 6134 | 70 |
631119 | 631119 | 2020-10-14 | Hays | Texas | 48209 | 6110 | 69 |
627875 | 627875 | 2020-10-13 | Hays | Texas | 48209 | 6084 | 69 |
624633 | 624633 | 2020-10-12 | Hays | Texas | 48209 | 6037 | 69 |
621390 | 621390 | 2020-10-11 | Hays | Texas | 48209 | 6037 | 69 |
618147 | 618147 | 2020-10-10 | Hays | Texas | 48209 | 6037 | 69 |
614905 | 614905 | 2020-10-09 | Hays | Texas | 48209 | 6037 | 69 |
611664 | 611664 | 2020-10-08 | Hays | Texas | 48209 | 6018 | 68 |
608422 | 608422 | 2020-10-07 | Hays | Texas | 48209 | 6008 | 68 |
605179 | 605179 | 2020-10-06 | Hays | Texas | 48209 | 5995 | 67 |
601937 | 601937 | 2020-10-05 | Hays | Texas | 48209 | 5965 | 66 |
598694 | 598694 | 2020-10-04 | Hays | Texas | 48209 | 5951 | 66 |
595451 | 595451 | 2020-10-03 | Hays | Texas | 48209 | 5951 | 66 |
592209 | 592209 | 2020-10-02 | Hays | Texas | 48209 | 5951 | 66 |
588969 | 588969 | 2020-10-01 | Hays | Texas | 48209 | 5946 | 65 |
585728 | 585728 | 2020-09-30 | Hays | Texas | 48209 | 5940 | 65 |
582488 | 582488 | 2020-09-29 | Hays | Texas | 48209 | 5926 | 63 |
579249 | 579249 | 2020-09-28 | Hays | Texas | 48209 | 5916 | 61 |
576008 | 576008 | 2020-09-27 | Hays | Texas | 48209 | 5871 | 61 |
572764 | 572764 | 2020-09-26 | Hays | Texas | 48209 | 5871 | 61 |
569522 | 569522 | 2020-09-25 | Hays | Texas | 48209 | 5871 | 61 |
566281 | 566281 | 2020-09-24 | Hays | Texas | 48209 | 5832 | 61 |
563040 | 563040 | 2020-09-23 | Hays | Texas | 48209 | 5818 | 60 |
559801 | 559801 | 2020-09-22 | Hays | Texas | 48209 | 5799 | 60 |
556565 | 556565 | 2020-09-21 | Hays | Texas | 48209 | 5778 | 60 |
553328 | 553328 | 2020-09-20 | Hays | Texas | 48209 | 5736 | 60 |
550089 | 550089 | 2020-09-19 | Hays | Texas | 48209 | 5736 | 60 |
546850 | 546850 | 2020-09-18 | Hays | Texas | 48209 | 5736 | 60 |
543613 | 543613 | 2020-09-17 | Hays | Texas | 48209 | 5719 | 60 |
540377 | 540377 | 2020-09-16 | Hays | Texas | 48209 | 5697 | 60 |
537140 | 537140 | 2020-09-15 | Hays | Texas | 48209 | 5665 | 60 |
533904 | 533904 | 2020-09-14 | Hays | Texas | 48209 | 5656 | 60 |
530669 | 530669 | 2020-09-13 | Hays | Texas | 48209 | 5598 | 60 |
527432 | 527432 | 2020-09-12 | Hays | Texas | 48209 | 5598 | 60 |
524196 | 524196 | 2020-09-11 | Hays | Texas | 48209 | 5598 | 59 |
520960 | 520960 | 2020-09-10 | Hays | Texas | 48209 | 5568 | 59 |
517724 | 517724 | 2020-09-09 | Hays | Texas | 48209 | 5560 | 59 |
514489 | 514489 | 2020-09-08 | Hays | Texas | 48209 | 5526 | 58 |
511256 | 511256 | 2020-09-07 | Hays | Texas | 48209 | 5471 | 58 |
508023 | 508023 | 2020-09-06 | Hays | Texas | 48209 | 5471 | 58 |
504791 | 504791 | 2020-09-05 | Hays | Texas | 48209 | 5471 | 58 |
501557 | 501557 | 2020-09-04 | Hays | Texas | 48209 | 5471 | 58 |
498323 | 498323 | 2020-09-03 | Hays | Texas | 48209 | 5446 | 58 |
495090 | 495090 | 2020-09-02 | Hays | Texas | 48209 | 5425 | 56 |
491856 | 491856 | 2020-09-01 | Hays | Texas | 48209 | 5410 | 56 |
488623 | 488623 | 2020-08-31 | Hays | Texas | 48209 | 5396 | 56 |
485390 | 485390 | 2020-08-30 | Hays | Texas | 48209 | 5361 | 56 |
482155 | 482155 | 2020-08-29 | Hays | Texas | 48209 | 5361 | 56 |
478921 | 478921 | 2020-08-28 | Hays | Texas | 48209 | 5361 | 56 |
475688 | 475688 | 2020-08-27 | Hays | Texas | 48209 | 5340 | 55 |
472455 | 472455 | 2020-08-26 | Hays | Texas | 48209 | 5322 | 53 |
469223 | 469223 | 2020-08-25 | Hays | Texas | 48209 | 5308 | 53 |
465994 | 465994 | 2020-08-24 | Hays | Texas | 48209 | 5297 | 53 |
462765 | 462765 | 2020-08-23 | Hays | Texas | 48209 | 5250 | 52 |
459536 | 459536 | 2020-08-22 | Hays | Texas | 48209 | 5250 | 52 |
456309 | 456309 | 2020-08-21 | Hays | Texas | 48209 | 5250 | 48 |
453081 | 453081 | 2020-08-20 | Hays | Texas | 48209 | 5230 | 47 |
449853 | 449853 | 2020-08-19 | Hays | Texas | 48209 | 5210 | 46 |
446625 | 446625 | 2020-08-18 | Hays | Texas | 48209 | 5192 | 46 |
443398 | 443398 | 2020-08-17 | Hays | Texas | 48209 | 5150 | 46 |
440172 | 440172 | 2020-08-16 | Hays | Texas | 48209 | 5111 | 46 |
436946 | 436946 | 2020-08-15 | Hays | Texas | 48209 | 5111 | 46 |
433720 | 433720 | 2020-08-14 | Hays | Texas | 48209 | 5111 | 45 |
430495 | 430495 | 2020-08-13 | Hays | Texas | 48209 | 5103 | 44 |
427268 | 427268 | 2020-08-12 | Hays | Texas | 48209 | 5083 | 42 |
424044 | 424044 | 2020-08-11 | Hays | Texas | 48209 | 5066 | 41 |
420823 | 420823 | 2020-08-10 | Hays | Texas | 48209 | 5050 | 39 |
417602 | 417602 | 2020-08-09 | Hays | Texas | 48209 | 5012 | 38 |
414381 | 414381 | 2020-08-08 | Hays | Texas | 48209 | 5012 | 37 |
411161 | 411161 | 2020-08-07 | Hays | Texas | 48209 | 5012 | 37 |
407942 | 407942 | 2020-08-06 | Hays | Texas | 48209 | 4989 | 37 |
404722 | 404722 | 2020-08-05 | Hays | Texas | 48209 | 4969 | 35 |
401504 | 401504 | 2020-08-04 | Hays | Texas | 48209 | 4931 | 34 |
398288 | 398288 | 2020-08-03 | Hays | Texas | 48209 | 4893 | 33 |
395072 | 395072 | 2020-08-02 | Hays | Texas | 48209 | 4297 | 32 |
391856 | 391856 | 2020-08-01 | Hays | Texas | 48209 | 4297 | 32 |
388639 | 388639 | 2020-07-31 | Hays | Texas | 48209 | 4297 | 31 |
385422 | 385422 | 2020-07-30 | Hays | Texas | 48209 | 4297 | 29 |
382204 | 382204 | 2020-07-29 | Hays | Texas | 48209 | 4276 | 28 |
378987 | 378987 | 2020-07-28 | Hays | Texas | 48209 | 4245 | 28 |
375771 | 375771 | 2020-07-27 | Hays | Texas | 48209 | 4203 | 28 |
372558 | 372558 | 2020-07-26 | Hays | Texas | 48209 | 4133 | 24 |
369346 | 369346 | 2020-07-25 | Hays | Texas | 48209 | 4133 | 24 |
366137 | 366137 | 2020-07-24 | Hays | Texas | 48209 | 4133 | 24 |
362931 | 362931 | 2020-07-23 | Hays | Texas | 48209 | 4091 | 22 |
359724 | 359724 | 2020-07-22 | Hays | Texas | 48209 | 4045 | 22 |
356519 | 356519 | 2020-07-21 | Hays | Texas | 48209 | 4004 | 21 |
353316 | 353316 | 2020-07-20 | Hays | Texas | 48209 | 3979 | 17 |
350114 | 350114 | 2020-07-19 | Hays | Texas | 48209 | 3865 | 17 |
346914 | 346914 | 2020-07-18 | Hays | Texas | 48209 | 3865 | 17 |
343714 | 343714 | 2020-07-17 | Hays | Texas | 48209 | 3865 | 17 |
340515 | 340515 | 2020-07-16 | Hays | Texas | 48209 | 3816 | 14 |
337319 | 337319 | 2020-07-15 | Hays | Texas | 48209 | 3769 | 14 |
334124 | 334124 | 2020-07-14 | Hays | Texas | 48209 | 3699 | 13 |
330933 | 330933 | 2020-07-13 | Hays | Texas | 48209 | 3643 | 11 |
327747 | 327747 | 2020-07-12 | Hays | Texas | 48209 | 3555 | 11 |
324562 | 324562 | 2020-07-11 | Hays | Texas | 48209 | 3534 | 11 |
321381 | 321381 | 2020-07-10 | Hays | Texas | 48209 | 3501 | 11 |
318202 | 318202 | 2020-07-09 | Hays | Texas | 48209 | 3409 | 11 |
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);