ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Clay" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637543 | 637543 | 2020-10-16 | Clay | Texas | 48077 | 91 | 2 |
634298 | 634298 | 2020-10-15 | Clay | Texas | 48077 | 90 | 2 |
631053 | 631053 | 2020-10-14 | Clay | Texas | 48077 | 89 | 2 |
627809 | 627809 | 2020-10-13 | Clay | Texas | 48077 | 87 | 2 |
624567 | 624567 | 2020-10-12 | Clay | Texas | 48077 | 87 | 2 |
621324 | 621324 | 2020-10-11 | Clay | Texas | 48077 | 87 | 2 |
618081 | 618081 | 2020-10-10 | Clay | Texas | 48077 | 87 | 2 |
614839 | 614839 | 2020-10-09 | Clay | Texas | 48077 | 87 | 2 |
611598 | 611598 | 2020-10-08 | Clay | Texas | 48077 | 86 | 2 |
608356 | 608356 | 2020-10-07 | Clay | Texas | 48077 | 83 | 2 |
605113 | 605113 | 2020-10-06 | Clay | Texas | 48077 | 83 | 2 |
601871 | 601871 | 2020-10-05 | Clay | Texas | 48077 | 81 | 2 |
598628 | 598628 | 2020-10-04 | Clay | Texas | 48077 | 81 | 2 |
595385 | 595385 | 2020-10-03 | Clay | Texas | 48077 | 81 | 2 |
592143 | 592143 | 2020-10-02 | Clay | Texas | 48077 | 79 | 2 |
588903 | 588903 | 2020-10-01 | Clay | Texas | 48077 | 79 | 2 |
585662 | 585662 | 2020-09-30 | Clay | Texas | 48077 | 79 | 2 |
582422 | 582422 | 2020-09-29 | Clay | Texas | 48077 | 79 | 2 |
579183 | 579183 | 2020-09-28 | Clay | Texas | 48077 | 90 | 2 |
575942 | 575942 | 2020-09-27 | Clay | Texas | 48077 | 90 | 2 |
572698 | 572698 | 2020-09-26 | Clay | Texas | 48077 | 90 | 2 |
569456 | 569456 | 2020-09-25 | Clay | Texas | 48077 | 86 | 2 |
566215 | 566215 | 2020-09-24 | Clay | Texas | 48077 | 86 | 2 |
562974 | 562974 | 2020-09-23 | Clay | Texas | 48077 | 84 | 1 |
559735 | 559735 | 2020-09-22 | Clay | Texas | 48077 | 80 | 1 |
556499 | 556499 | 2020-09-21 | Clay | Texas | 48077 | 76 | 1 |
553262 | 553262 | 2020-09-20 | Clay | Texas | 48077 | 76 | 1 |
550023 | 550023 | 2020-09-19 | Clay | Texas | 48077 | 76 | 1 |
546784 | 546784 | 2020-09-18 | Clay | Texas | 48077 | 76 | 1 |
543547 | 543547 | 2020-09-17 | Clay | Texas | 48077 | 75 | 1 |
540311 | 540311 | 2020-09-16 | Clay | Texas | 48077 | 73 | 1 |
537074 | 537074 | 2020-09-15 | Clay | Texas | 48077 | 73 | 1 |
533838 | 533838 | 2020-09-14 | Clay | Texas | 48077 | 72 | 1 |
530603 | 530603 | 2020-09-13 | Clay | Texas | 48077 | 72 | 1 |
527366 | 527366 | 2020-09-12 | Clay | Texas | 48077 | 72 | 1 |
524130 | 524130 | 2020-09-11 | Clay | Texas | 48077 | 72 | 1 |
520894 | 520894 | 2020-09-10 | Clay | Texas | 48077 | 71 | 1 |
517658 | 517658 | 2020-09-09 | Clay | Texas | 48077 | 71 | 1 |
514423 | 514423 | 2020-09-08 | Clay | Texas | 48077 | 71 | 1 |
511190 | 511190 | 2020-09-07 | Clay | Texas | 48077 | 71 | 1 |
507957 | 507957 | 2020-09-06 | Clay | Texas | 48077 | 71 | 1 |
504725 | 504725 | 2020-09-05 | Clay | Texas | 48077 | 71 | 1 |
501491 | 501491 | 2020-09-04 | Clay | Texas | 48077 | 70 | 1 |
498257 | 498257 | 2020-09-03 | Clay | Texas | 48077 | 69 | 1 |
495024 | 495024 | 2020-09-02 | Clay | Texas | 48077 | 69 | 1 |
491790 | 491790 | 2020-09-01 | Clay | Texas | 48077 | 67 | 1 |
488557 | 488557 | 2020-08-31 | Clay | Texas | 48077 | 63 | 1 |
485324 | 485324 | 2020-08-30 | Clay | Texas | 48077 | 63 | 1 |
482089 | 482089 | 2020-08-29 | Clay | Texas | 48077 | 63 | 1 |
478855 | 478855 | 2020-08-28 | Clay | Texas | 48077 | 63 | 1 |
475622 | 475622 | 2020-08-27 | Clay | Texas | 48077 | 62 | 1 |
472389 | 472389 | 2020-08-26 | Clay | Texas | 48077 | 61 | 1 |
469157 | 469157 | 2020-08-25 | Clay | Texas | 48077 | 60 | 1 |
465928 | 465928 | 2020-08-24 | Clay | Texas | 48077 | 59 | 1 |
462699 | 462699 | 2020-08-23 | Clay | Texas | 48077 | 59 | 1 |
459470 | 459470 | 2020-08-22 | Clay | Texas | 48077 | 59 | 1 |
456243 | 456243 | 2020-08-21 | Clay | Texas | 48077 | 59 | 1 |
453015 | 453015 | 2020-08-20 | Clay | Texas | 48077 | 51 | 1 |
449787 | 449787 | 2020-08-19 | Clay | Texas | 48077 | 50 | 1 |
446559 | 446559 | 2020-08-18 | Clay | Texas | 48077 | 47 | 1 |
443332 | 443332 | 2020-08-17 | Clay | Texas | 48077 | 47 | 1 |
440106 | 440106 | 2020-08-16 | Clay | Texas | 48077 | 47 | 1 |
436880 | 436880 | 2020-08-15 | Clay | Texas | 48077 | 47 | 1 |
433654 | 433654 | 2020-08-14 | Clay | Texas | 48077 | 45 | 1 |
430429 | 430429 | 2020-08-13 | Clay | Texas | 48077 | 45 | 1 |
427202 | 427202 | 2020-08-12 | Clay | Texas | 48077 | 43 | 1 |
423978 | 423978 | 2020-08-11 | Clay | Texas | 48077 | 43 | 1 |
420757 | 420757 | 2020-08-10 | Clay | Texas | 48077 | 40 | 1 |
417536 | 417536 | 2020-08-09 | Clay | Texas | 48077 | 40 | 1 |
414315 | 414315 | 2020-08-08 | Clay | Texas | 48077 | 40 | 1 |
411095 | 411095 | 2020-08-07 | Clay | Texas | 48077 | 40 | 1 |
407876 | 407876 | 2020-08-06 | Clay | Texas | 48077 | 38 | 1 |
404656 | 404656 | 2020-08-05 | Clay | Texas | 48077 | 36 | 1 |
401438 | 401438 | 2020-08-04 | Clay | Texas | 48077 | 35 | 1 |
398222 | 398222 | 2020-08-03 | Clay | Texas | 48077 | 34 | 1 |
395006 | 395006 | 2020-08-02 | Clay | Texas | 48077 | 34 | 1 |
391790 | 391790 | 2020-08-01 | Clay | Texas | 48077 | 34 | 1 |
388573 | 388573 | 2020-07-31 | Clay | Texas | 48077 | 33 | 1 |
385356 | 385356 | 2020-07-30 | Clay | Texas | 48077 | 32 | 1 |
382138 | 382138 | 2020-07-29 | Clay | Texas | 48077 | 32 | 1 |
378921 | 378921 | 2020-07-28 | Clay | Texas | 48077 | 26 | 1 |
375705 | 375705 | 2020-07-27 | Clay | Texas | 48077 | 25 | 1 |
372492 | 372492 | 2020-07-26 | Clay | Texas | 48077 | 25 | 0 |
369280 | 369280 | 2020-07-25 | Clay | Texas | 48077 | 25 | 0 |
366071 | 366071 | 2020-07-24 | Clay | Texas | 48077 | 24 | 0 |
362865 | 362865 | 2020-07-23 | Clay | Texas | 48077 | 21 | 0 |
359658 | 359658 | 2020-07-22 | Clay | Texas | 48077 | 20 | 0 |
356453 | 356453 | 2020-07-21 | Clay | Texas | 48077 | 19 | 0 |
353250 | 353250 | 2020-07-20 | Clay | Texas | 48077 | 19 | 0 |
350048 | 350048 | 2020-07-19 | Clay | Texas | 48077 | 19 | 0 |
346848 | 346848 | 2020-07-18 | Clay | Texas | 48077 | 19 | 0 |
343648 | 343648 | 2020-07-17 | Clay | Texas | 48077 | 20 | 0 |
340449 | 340449 | 2020-07-16 | Clay | Texas | 48077 | 19 | 0 |
337253 | 337253 | 2020-07-15 | Clay | Texas | 48077 | 19 | 0 |
334058 | 334058 | 2020-07-14 | Clay | Texas | 48077 | 19 | 0 |
330867 | 330867 | 2020-07-13 | Clay | Texas | 48077 | 16 | 0 |
327681 | 327681 | 2020-07-12 | Clay | Texas | 48077 | 16 | 0 |
324496 | 324496 | 2020-07-11 | Clay | Texas | 48077 | 16 | 0 |
321315 | 321315 | 2020-07-10 | Clay | Texas | 48077 | 14 | 0 |
318137 | 318137 | 2020-07-09 | Clay | Texas | 48077 | 13 | 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);