ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 48103 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637556 | 637556 | 2020-10-16 | Crane | Texas | 48103 | 73 | 2 |
634311 | 634311 | 2020-10-15 | Crane | Texas | 48103 | 73 | 2 |
631066 | 631066 | 2020-10-14 | Crane | Texas | 48103 | 73 | 2 |
627822 | 627822 | 2020-10-13 | Crane | Texas | 48103 | 73 | 2 |
624580 | 624580 | 2020-10-12 | Crane | Texas | 48103 | 73 | 2 |
621337 | 621337 | 2020-10-11 | Crane | Texas | 48103 | 73 | 2 |
618094 | 618094 | 2020-10-10 | Crane | Texas | 48103 | 73 | 2 |
614852 | 614852 | 2020-10-09 | Crane | Texas | 48103 | 73 | 2 |
611611 | 611611 | 2020-10-08 | Crane | Texas | 48103 | 72 | 2 |
608369 | 608369 | 2020-10-07 | Crane | Texas | 48103 | 72 | 2 |
605126 | 605126 | 2020-10-06 | Crane | Texas | 48103 | 72 | 2 |
601884 | 601884 | 2020-10-05 | Crane | Texas | 48103 | 72 | 2 |
598641 | 598641 | 2020-10-04 | Crane | Texas | 48103 | 72 | 2 |
595398 | 595398 | 2020-10-03 | Crane | Texas | 48103 | 72 | 2 |
592156 | 592156 | 2020-10-02 | Crane | Texas | 48103 | 72 | 2 |
588916 | 588916 | 2020-10-01 | Crane | Texas | 48103 | 72 | 2 |
585675 | 585675 | 2020-09-30 | Crane | Texas | 48103 | 72 | 2 |
582435 | 582435 | 2020-09-29 | Crane | Texas | 48103 | 72 | 2 |
579196 | 579196 | 2020-09-28 | Crane | Texas | 48103 | 72 | 2 |
575955 | 575955 | 2020-09-27 | Crane | Texas | 48103 | 72 | 2 |
572711 | 572711 | 2020-09-26 | Crane | Texas | 48103 | 72 | 2 |
569469 | 569469 | 2020-09-25 | Crane | Texas | 48103 | 71 | 2 |
566228 | 566228 | 2020-09-24 | Crane | Texas | 48103 | 71 | 2 |
562987 | 562987 | 2020-09-23 | Crane | Texas | 48103 | 71 | 2 |
559748 | 559748 | 2020-09-22 | Crane | Texas | 48103 | 71 | 2 |
556512 | 556512 | 2020-09-21 | Crane | Texas | 48103 | 71 | 2 |
553275 | 553275 | 2020-09-20 | Crane | Texas | 48103 | 71 | 2 |
550036 | 550036 | 2020-09-19 | Crane | Texas | 48103 | 71 | 2 |
546797 | 546797 | 2020-09-18 | Crane | Texas | 48103 | 71 | 2 |
543560 | 543560 | 2020-09-17 | Crane | Texas | 48103 | 71 | 2 |
540324 | 540324 | 2020-09-16 | Crane | Texas | 48103 | 71 | 2 |
537087 | 537087 | 2020-09-15 | Crane | Texas | 48103 | 71 | 2 |
533851 | 533851 | 2020-09-14 | Crane | Texas | 48103 | 71 | 2 |
530616 | 530616 | 2020-09-13 | Crane | Texas | 48103 | 71 | 2 |
527379 | 527379 | 2020-09-12 | Crane | Texas | 48103 | 71 | 2 |
524143 | 524143 | 2020-09-11 | Crane | Texas | 48103 | 71 | 2 |
520907 | 520907 | 2020-09-10 | Crane | Texas | 48103 | 71 | 2 |
517671 | 517671 | 2020-09-09 | Crane | Texas | 48103 | 71 | 2 |
514436 | 514436 | 2020-09-08 | Crane | Texas | 48103 | 71 | 2 |
511203 | 511203 | 2020-09-07 | Crane | Texas | 48103 | 71 | 2 |
507970 | 507970 | 2020-09-06 | Crane | Texas | 48103 | 71 | 2 |
504738 | 504738 | 2020-09-05 | Crane | Texas | 48103 | 71 | 2 |
501504 | 501504 | 2020-09-04 | Crane | Texas | 48103 | 71 | 2 |
498270 | 498270 | 2020-09-03 | Crane | Texas | 48103 | 71 | 2 |
495037 | 495037 | 2020-09-02 | Crane | Texas | 48103 | 71 | 2 |
491803 | 491803 | 2020-09-01 | Crane | Texas | 48103 | 71 | 2 |
488570 | 488570 | 2020-08-31 | Crane | Texas | 48103 | 70 | 2 |
485337 | 485337 | 2020-08-30 | Crane | Texas | 48103 | 70 | 2 |
482102 | 482102 | 2020-08-29 | Crane | Texas | 48103 | 70 | 2 |
478868 | 478868 | 2020-08-28 | Crane | Texas | 48103 | 70 | 2 |
475635 | 475635 | 2020-08-27 | Crane | Texas | 48103 | 70 | 2 |
472402 | 472402 | 2020-08-26 | Crane | Texas | 48103 | 70 | 2 |
469170 | 469170 | 2020-08-25 | Crane | Texas | 48103 | 70 | 2 |
465941 | 465941 | 2020-08-24 | Crane | Texas | 48103 | 70 | 2 |
462712 | 462712 | 2020-08-23 | Crane | Texas | 48103 | 70 | 2 |
459483 | 459483 | 2020-08-22 | Crane | Texas | 48103 | 70 | 2 |
456256 | 456256 | 2020-08-21 | Crane | Texas | 48103 | 70 | 2 |
453028 | 453028 | 2020-08-20 | Crane | Texas | 48103 | 71 | 2 |
449800 | 449800 | 2020-08-19 | Crane | Texas | 48103 | 70 | 2 |
446572 | 446572 | 2020-08-18 | Crane | Texas | 48103 | 70 | 2 |
443345 | 443345 | 2020-08-17 | Crane | Texas | 48103 | 70 | 2 |
440119 | 440119 | 2020-08-16 | Crane | Texas | 48103 | 70 | 2 |
436893 | 436893 | 2020-08-15 | Crane | Texas | 48103 | 70 | 2 |
433667 | 433667 | 2020-08-14 | Crane | Texas | 48103 | 70 | 2 |
430442 | 430442 | 2020-08-13 | Crane | Texas | 48103 | 70 | 2 |
427215 | 427215 | 2020-08-12 | Crane | Texas | 48103 | 71 | 2 |
423991 | 423991 | 2020-08-11 | Crane | Texas | 48103 | 70 | 2 |
420770 | 420770 | 2020-08-10 | Crane | Texas | 48103 | 70 | 2 |
417549 | 417549 | 2020-08-09 | Crane | Texas | 48103 | 70 | 2 |
414328 | 414328 | 2020-08-08 | Crane | Texas | 48103 | 70 | 2 |
411108 | 411108 | 2020-08-07 | Crane | Texas | 48103 | 70 | 2 |
407889 | 407889 | 2020-08-06 | Crane | Texas | 48103 | 71 | 2 |
404669 | 404669 | 2020-08-05 | Crane | Texas | 48103 | 70 | 2 |
401451 | 401451 | 2020-08-04 | Crane | Texas | 48103 | 75 | 2 |
398235 | 398235 | 2020-08-03 | Crane | Texas | 48103 | 75 | 2 |
395019 | 395019 | 2020-08-02 | Crane | Texas | 48103 | 75 | 2 |
391803 | 391803 | 2020-08-01 | Crane | Texas | 48103 | 75 | 2 |
388586 | 388586 | 2020-07-31 | Crane | Texas | 48103 | 72 | 2 |
385369 | 385369 | 2020-07-30 | Crane | Texas | 48103 | 72 | 2 |
382151 | 382151 | 2020-07-29 | Crane | Texas | 48103 | 66 | 2 |
378934 | 378934 | 2020-07-28 | Crane | Texas | 48103 | 66 | 2 |
375718 | 375718 | 2020-07-27 | Crane | Texas | 48103 | 65 | 2 |
372505 | 372505 | 2020-07-26 | Crane | Texas | 48103 | 65 | 10 |
369293 | 369293 | 2020-07-25 | Crane | Texas | 48103 | 65 | 10 |
366084 | 366084 | 2020-07-24 | Crane | Texas | 48103 | 65 | 10 |
362878 | 362878 | 2020-07-23 | Crane | Texas | 48103 | 65 | 10 |
359671 | 359671 | 2020-07-22 | Crane | Texas | 48103 | 65 | 10 |
356466 | 356466 | 2020-07-21 | Crane | Texas | 48103 | 65 | 10 |
353263 | 353263 | 2020-07-20 | Crane | Texas | 48103 | 65 | 10 |
350061 | 350061 | 2020-07-19 | Crane | Texas | 48103 | 65 | 10 |
346861 | 346861 | 2020-07-18 | Crane | Texas | 48103 | 65 | 10 |
343661 | 343661 | 2020-07-17 | Crane | Texas | 48103 | 65 | 10 |
340462 | 340462 | 2020-07-16 | Crane | Texas | 48103 | 64 | 10 |
337266 | 337266 | 2020-07-15 | Crane | Texas | 48103 | 64 | 10 |
334071 | 334071 | 2020-07-14 | Crane | Texas | 48103 | 64 | 9 |
330880 | 330880 | 2020-07-13 | Crane | Texas | 48103 | 64 | 9 |
327694 | 327694 | 2020-07-12 | Crane | Texas | 48103 | 64 | 9 |
324509 | 324509 | 2020-07-11 | Crane | Texas | 48103 | 64 | 9 |
321328 | 321328 | 2020-07-10 | Crane | Texas | 48103 | 63 | 9 |
318150 | 318150 | 2020-07-09 | Crane | Texas | 48103 | 62 | 9 |
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);