ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 48439 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
598807 | 598807 | 2020-10-04 | Tarrant | Texas | 48439 | 52100 | 734 |
595564 | 595564 | 2020-10-03 | Tarrant | Texas | 48439 | 51499 | 734 |
592322 | 592322 | 2020-10-02 | Tarrant | Texas | 48439 | 51081 | 728 |
589082 | 589082 | 2020-10-01 | Tarrant | Texas | 48439 | 50729 | 725 |
585841 | 585841 | 2020-09-30 | Tarrant | Texas | 48439 | 50417 | 721 |
582601 | 582601 | 2020-09-29 | Tarrant | Texas | 48439 | 50057 | 719 |
579362 | 579362 | 2020-09-28 | Tarrant | Texas | 48439 | 49569 | 711 |
576121 | 576121 | 2020-09-27 | Tarrant | Texas | 48439 | 49329 | 711 |
572877 | 572877 | 2020-09-26 | Tarrant | Texas | 48439 | 49159 | 710 |
569635 | 569635 | 2020-09-25 | Tarrant | Texas | 48439 | 48897 | 701 |
566394 | 566394 | 2020-09-24 | Tarrant | Texas | 48439 | 48504 | 701 |
563153 | 563153 | 2020-09-23 | Tarrant | Texas | 48439 | 47917 | 698 |
559914 | 559914 | 2020-09-22 | Tarrant | Texas | 48439 | 47533 | 693 |
556678 | 556678 | 2020-09-21 | Tarrant | Texas | 48439 | 47231 | 693 |
553441 | 553441 | 2020-09-20 | Tarrant | Texas | 48439 | 46898 | 693 |
550202 | 550202 | 2020-09-19 | Tarrant | Texas | 48439 | 46537 | 690 |
546963 | 546963 | 2020-09-18 | Tarrant | Texas | 48439 | 46150 | 684 |
543726 | 543726 | 2020-09-17 | Tarrant | Texas | 48439 | 45868 | 679 |
540490 | 540490 | 2020-09-16 | Tarrant | Texas | 48439 | 45583 | 673 |
537253 | 537253 | 2020-09-15 | Tarrant | Texas | 48439 | 45163 | 667 |
534017 | 534017 | 2020-09-14 | Tarrant | Texas | 48439 | 44727 | 662 |
530782 | 530782 | 2020-09-13 | Tarrant | Texas | 48439 | 44454 | 661 |
527545 | 527545 | 2020-09-12 | Tarrant | Texas | 48439 | 44140 | 660 |
524309 | 524309 | 2020-09-11 | Tarrant | Texas | 48439 | 43937 | 657 |
521073 | 521073 | 2020-09-10 | Tarrant | Texas | 48439 | 43726 | 643 |
517837 | 517837 | 2020-09-09 | Tarrant | Texas | 48439 | 43515 | 643 |
514602 | 514602 | 2020-09-08 | Tarrant | Texas | 48439 | 43055 | 639 |
511369 | 511369 | 2020-09-07 | Tarrant | Texas | 48439 | 42798 | 638 |
508136 | 508136 | 2020-09-06 | Tarrant | Texas | 48439 | 42798 | 638 |
504904 | 504904 | 2020-09-05 | Tarrant | Texas | 48439 | 42798 | 636 |
501670 | 501670 | 2020-09-04 | Tarrant | Texas | 48439 | 42511 | 630 |
498436 | 498436 | 2020-09-03 | Tarrant | Texas | 48439 | 42297 | 624 |
495203 | 495203 | 2020-09-02 | Tarrant | Texas | 48439 | 42070 | 620 |
491969 | 491969 | 2020-09-01 | Tarrant | Texas | 48439 | 41860 | 614 |
488736 | 488736 | 2020-08-31 | Tarrant | Texas | 48439 | 41617 | 610 |
485503 | 485503 | 2020-08-30 | Tarrant | Texas | 48439 | 41486 | 610 |
482268 | 482268 | 2020-08-29 | Tarrant | Texas | 48439 | 41272 | 606 |
479034 | 479034 | 2020-08-28 | Tarrant | Texas | 48439 | 41035 | 599 |
475801 | 475801 | 2020-08-27 | Tarrant | Texas | 48439 | 40777 | 590 |
472568 | 472568 | 2020-08-26 | Tarrant | Texas | 48439 | 40530 | 586 |
469336 | 469336 | 2020-08-25 | Tarrant | Texas | 48439 | 40331 | 570 |
466107 | 466107 | 2020-08-24 | Tarrant | Texas | 48439 | 39920 | 564 |
462878 | 462878 | 2020-08-23 | Tarrant | Texas | 48439 | 39811 | 564 |
459649 | 459649 | 2020-08-22 | Tarrant | Texas | 48439 | 39556 | 557 |
456422 | 456422 | 2020-08-21 | Tarrant | Texas | 48439 | 39328 | 547 |
453194 | 453194 | 2020-08-20 | Tarrant | Texas | 48439 | 39053 | 537 |
449966 | 449966 | 2020-08-19 | Tarrant | Texas | 48439 | 38822 | 528 |
446738 | 446738 | 2020-08-18 | Tarrant | Texas | 48439 | 38476 | 513 |
443511 | 443511 | 2020-08-17 | Tarrant | Texas | 48439 | 38016 | 504 |
440285 | 440285 | 2020-08-16 | Tarrant | Texas | 48439 | 37760 | 504 |
437059 | 437059 | 2020-08-15 | Tarrant | Texas | 48439 | 37072 | 499 |
433833 | 433833 | 2020-08-14 | Tarrant | Texas | 48439 | 35629 | 492 |
430608 | 430608 | 2020-08-13 | Tarrant | Texas | 48439 | 35129 | 480 |
427380 | 427380 | 2020-08-12 | Tarrant | Texas | 48439 | 34774 | 469 |
424156 | 424156 | 2020-08-11 | Tarrant | Texas | 48439 | 34369 | 457 |
420935 | 420935 | 2020-08-10 | Tarrant | Texas | 48439 | 34165 | 449 |
417714 | 417714 | 2020-08-09 | Tarrant | Texas | 48439 | 33860 | 447 |
414493 | 414493 | 2020-08-08 | Tarrant | Texas | 48439 | 33369 | 445 |
411273 | 411273 | 2020-08-07 | Tarrant | Texas | 48439 | 32590 | 437 |
408054 | 408054 | 2020-08-06 | Tarrant | Texas | 48439 | 32299 | 422 |
404834 | 404834 | 2020-08-05 | Tarrant | Texas | 48439 | 31835 | 410 |
401616 | 401616 | 2020-08-04 | Tarrant | Texas | 48439 | 30162 | 398 |
398400 | 398400 | 2020-08-03 | Tarrant | Texas | 48439 | 29357 | 391 |
395184 | 395184 | 2020-08-02 | Tarrant | Texas | 48439 | 29054 | 391 |
391968 | 391968 | 2020-08-01 | Tarrant | Texas | 48439 | 28871 | 388 |
388751 | 388751 | 2020-07-31 | Tarrant | Texas | 48439 | 28410 | 381 |
385534 | 385534 | 2020-07-30 | Tarrant | Texas | 48439 | 27823 | 363 |
382316 | 382316 | 2020-07-29 | Tarrant | Texas | 48439 | 27151 | 355 |
379099 | 379099 | 2020-07-28 | Tarrant | Texas | 48439 | 26315 | 349 |
375883 | 375883 | 2020-07-27 | Tarrant | Texas | 48439 | 25739 | 348 |
372670 | 372670 | 2020-07-26 | Tarrant | Texas | 48439 | 25499 | 348 |
369458 | 369458 | 2020-07-25 | Tarrant | Texas | 48439 | 25146 | 344 |
366249 | 366249 | 2020-07-24 | Tarrant | Texas | 48439 | 24562 | 329 |
363043 | 363043 | 2020-07-23 | Tarrant | Texas | 48439 | 23967 | 319 |
359836 | 359836 | 2020-07-22 | Tarrant | Texas | 48439 | 23536 | 310 |
356631 | 356631 | 2020-07-21 | Tarrant | Texas | 48439 | 22665 | 304 |
353428 | 353428 | 2020-07-20 | Tarrant | Texas | 48439 | 22002 | 299 |
350226 | 350226 | 2020-07-19 | Tarrant | Texas | 48439 | 21617 | 298 |
347026 | 347026 | 2020-07-18 | Tarrant | Texas | 48439 | 21195 | 293 |
343825 | 343825 | 2020-07-17 | Tarrant | Texas | 48439 | 20907 | 288 |
340626 | 340626 | 2020-07-16 | Tarrant | Texas | 48439 | 20433 | 283 |
337430 | 337430 | 2020-07-15 | Tarrant | Texas | 48439 | 19871 | 277 |
334235 | 334235 | 2020-07-14 | Tarrant | Texas | 48439 | 19014 | 272 |
331042 | 331042 | 2020-07-13 | Tarrant | Texas | 48439 | 18483 | 272 |
327856 | 327856 | 2020-07-12 | Tarrant | Texas | 48439 | 18161 | 272 |
324671 | 324671 | 2020-07-11 | Tarrant | Texas | 48439 | 17757 | 268 |
321490 | 321490 | 2020-07-10 | Tarrant | Texas | 48439 | 17334 | 262 |
318311 | 318311 | 2020-07-09 | Tarrant | Texas | 48439 | 16700 | 259 |
315138 | 315138 | 2020-07-08 | Tarrant | Texas | 48439 | 16180 | 254 |
311964 | 311964 | 2020-07-07 | Tarrant | Texas | 48439 | 15585 | 248 |
308795 | 308795 | 2020-07-06 | Tarrant | Texas | 48439 | 14828 | 238 |
305627 | 305627 | 2020-07-05 | Tarrant | Texas | 48439 | 14008 | 236 |
302463 | 302463 | 2020-07-04 | Tarrant | Texas | 48439 | 13423 | 233 |
299299 | 299299 | 2020-07-03 | Tarrant | Texas | 48439 | 13423 | 233 |
296138 | 296138 | 2020-07-02 | Tarrant | Texas | 48439 | 13423 | 233 |
292983 | 292983 | 2020-07-01 | Tarrant | Texas | 48439 | 12950 | 231 |
289830 | 289830 | 2020-06-30 | Tarrant | Texas | 48439 | 12344 | 228 |
286680 | 286680 | 2020-06-29 | Tarrant | Texas | 48439 | 11739 | 225 |
283534 | 283534 | 2020-06-28 | Tarrant | Texas | 48439 | 11476 | 225 |
280388 | 280388 | 2020-06-27 | Tarrant | Texas | 48439 | 11083 | 224 |
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);