ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jackson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
624648 | 624648 | 2020-10-12 | Jackson | Texas | 48239 | 632 | 16 |
621405 | 621405 | 2020-10-11 | Jackson | Texas | 48239 | 626 | 16 |
618162 | 618162 | 2020-10-10 | Jackson | Texas | 48239 | 626 | 16 |
614920 | 614920 | 2020-10-09 | Jackson | Texas | 48239 | 627 | 16 |
611679 | 611679 | 2020-10-08 | Jackson | Texas | 48239 | 627 | 16 |
608437 | 608437 | 2020-10-07 | Jackson | Texas | 48239 | 626 | 16 |
605194 | 605194 | 2020-10-06 | Jackson | Texas | 48239 | 630 | 16 |
601952 | 601952 | 2020-10-05 | Jackson | Texas | 48239 | 633 | 16 |
598709 | 598709 | 2020-10-04 | Jackson | Texas | 48239 | 614 | 16 |
595466 | 595466 | 2020-10-03 | Jackson | Texas | 48239 | 614 | 16 |
592224 | 592224 | 2020-10-02 | Jackson | Texas | 48239 | 614 | 16 |
588984 | 588984 | 2020-10-01 | Jackson | Texas | 48239 | 612 | 16 |
585743 | 585743 | 2020-09-30 | Jackson | Texas | 48239 | 607 | 16 |
582503 | 582503 | 2020-09-29 | Jackson | Texas | 48239 | 608 | 16 |
579264 | 579264 | 2020-09-28 | Jackson | Texas | 48239 | 606 | 16 |
576023 | 576023 | 2020-09-27 | Jackson | Texas | 48239 | 606 | 16 |
572779 | 572779 | 2020-09-26 | Jackson | Texas | 48239 | 606 | 16 |
569537 | 569537 | 2020-09-25 | Jackson | Texas | 48239 | 606 | 15 |
566296 | 566296 | 2020-09-24 | Jackson | Texas | 48239 | 606 | 15 |
563055 | 563055 | 2020-09-23 | Jackson | Texas | 48239 | 606 | 15 |
559816 | 559816 | 2020-09-22 | Jackson | Texas | 48239 | 605 | 15 |
556580 | 556580 | 2020-09-21 | Jackson | Texas | 48239 | 604 | 15 |
553343 | 553343 | 2020-09-20 | Jackson | Texas | 48239 | 527 | 15 |
550104 | 550104 | 2020-09-19 | Jackson | Texas | 48239 | 527 | 15 |
546865 | 546865 | 2020-09-18 | Jackson | Texas | 48239 | 527 | 15 |
543628 | 543628 | 2020-09-17 | Jackson | Texas | 48239 | 526 | 15 |
540392 | 540392 | 2020-09-16 | Jackson | Texas | 48239 | 523 | 15 |
537155 | 537155 | 2020-09-15 | Jackson | Texas | 48239 | 522 | 15 |
533919 | 533919 | 2020-09-14 | Jackson | Texas | 48239 | 518 | 15 |
530684 | 530684 | 2020-09-13 | Jackson | Texas | 48239 | 518 | 15 |
527447 | 527447 | 2020-09-12 | Jackson | Texas | 48239 | 518 | 15 |
524211 | 524211 | 2020-09-11 | Jackson | Texas | 48239 | 517 | 15 |
520975 | 520975 | 2020-09-10 | Jackson | Texas | 48239 | 511 | 15 |
517739 | 517739 | 2020-09-09 | Jackson | Texas | 48239 | 511 | 15 |
514504 | 514504 | 2020-09-08 | Jackson | Texas | 48239 | 504 | 14 |
511271 | 511271 | 2020-09-07 | Jackson | Texas | 48239 | 505 | 14 |
508038 | 508038 | 2020-09-06 | Jackson | Texas | 48239 | 505 | 14 |
504806 | 504806 | 2020-09-05 | Jackson | Texas | 48239 | 505 | 14 |
501572 | 501572 | 2020-09-04 | Jackson | Texas | 48239 | 505 | 14 |
498338 | 498338 | 2020-09-03 | Jackson | Texas | 48239 | 505 | 14 |
495105 | 495105 | 2020-09-02 | Jackson | Texas | 48239 | 503 | 14 |
491871 | 491871 | 2020-09-01 | Jackson | Texas | 48239 | 502 | 14 |
488638 | 488638 | 2020-08-31 | Jackson | Texas | 48239 | 501 | 14 |
485405 | 485405 | 2020-08-30 | Jackson | Texas | 48239 | 501 | 14 |
482170 | 482170 | 2020-08-29 | Jackson | Texas | 48239 | 501 | 14 |
478936 | 478936 | 2020-08-28 | Jackson | Texas | 48239 | 496 | 14 |
475703 | 475703 | 2020-08-27 | Jackson | Texas | 48239 | 495 | 14 |
472470 | 472470 | 2020-08-26 | Jackson | Texas | 48239 | 492 | 13 |
469238 | 469238 | 2020-08-25 | Jackson | Texas | 48239 | 486 | 13 |
466009 | 466009 | 2020-08-24 | Jackson | Texas | 48239 | 477 | 13 |
462780 | 462780 | 2020-08-23 | Jackson | Texas | 48239 | 477 | 13 |
459551 | 459551 | 2020-08-22 | Jackson | Texas | 48239 | 477 | 13 |
456324 | 456324 | 2020-08-21 | Jackson | Texas | 48239 | 477 | 13 |
453096 | 453096 | 2020-08-20 | Jackson | Texas | 48239 | 463 | 13 |
449868 | 449868 | 2020-08-19 | Jackson | Texas | 48239 | 443 | 12 |
446640 | 446640 | 2020-08-18 | Jackson | Texas | 48239 | 438 | 11 |
443413 | 443413 | 2020-08-17 | Jackson | Texas | 48239 | 418 | 11 |
440187 | 440187 | 2020-08-16 | Jackson | Texas | 48239 | 418 | 11 |
436961 | 436961 | 2020-08-15 | Jackson | Texas | 48239 | 418 | 11 |
433735 | 433735 | 2020-08-14 | Jackson | Texas | 48239 | 415 | 11 |
430510 | 430510 | 2020-08-13 | Jackson | Texas | 48239 | 411 | 10 |
427283 | 427283 | 2020-08-12 | Jackson | Texas | 48239 | 411 | 9 |
424059 | 424059 | 2020-08-11 | Jackson | Texas | 48239 | 408 | 7 |
420838 | 420838 | 2020-08-10 | Jackson | Texas | 48239 | 406 | 7 |
417617 | 417617 | 2020-08-09 | Jackson | Texas | 48239 | 406 | 7 |
414396 | 414396 | 2020-08-08 | Jackson | Texas | 48239 | 406 | 6 |
411176 | 411176 | 2020-08-07 | Jackson | Texas | 48239 | 400 | 6 |
407957 | 407957 | 2020-08-06 | Jackson | Texas | 48239 | 383 | 5 |
404737 | 404737 | 2020-08-05 | Jackson | Texas | 48239 | 380 | 5 |
401519 | 401519 | 2020-08-04 | Jackson | Texas | 48239 | 344 | 5 |
398303 | 398303 | 2020-08-03 | Jackson | Texas | 48239 | 320 | 5 |
395087 | 395087 | 2020-08-02 | Jackson | Texas | 48239 | 320 | 4 |
391871 | 391871 | 2020-08-01 | Jackson | Texas | 48239 | 320 | 4 |
388654 | 388654 | 2020-07-31 | Jackson | Texas | 48239 | 319 | 4 |
385437 | 385437 | 2020-07-30 | Jackson | Texas | 48239 | 319 | 4 |
382219 | 382219 | 2020-07-29 | Jackson | Texas | 48239 | 272 | 3 |
379002 | 379002 | 2020-07-28 | Jackson | Texas | 48239 | 251 | 3 |
375786 | 375786 | 2020-07-27 | Jackson | Texas | 48239 | 202 | 3 |
372573 | 372573 | 2020-07-26 | Jackson | Texas | 48239 | 202 | 1 |
369361 | 369361 | 2020-07-25 | Jackson | Texas | 48239 | 202 | 1 |
366152 | 366152 | 2020-07-24 | Jackson | Texas | 48239 | 194 | 1 |
362946 | 362946 | 2020-07-23 | Jackson | Texas | 48239 | 171 | 1 |
359739 | 359739 | 2020-07-22 | Jackson | Texas | 48239 | 159 | 1 |
356534 | 356534 | 2020-07-21 | Jackson | Texas | 48239 | 150 | 1 |
353331 | 353331 | 2020-07-20 | Jackson | Texas | 48239 | 147 | 1 |
350129 | 350129 | 2020-07-19 | Jackson | Texas | 48239 | 147 | 1 |
346929 | 346929 | 2020-07-18 | Jackson | Texas | 48239 | 174 | 1 |
343729 | 343729 | 2020-07-17 | Jackson | Texas | 48239 | 130 | 1 |
340530 | 340530 | 2020-07-16 | Jackson | Texas | 48239 | 121 | 1 |
337334 | 337334 | 2020-07-15 | Jackson | Texas | 48239 | 97 | 1 |
334139 | 334139 | 2020-07-14 | Jackson | Texas | 48239 | 90 | 1 |
330948 | 330948 | 2020-07-13 | Jackson | Texas | 48239 | 89 | 1 |
327762 | 327762 | 2020-07-12 | Jackson | Texas | 48239 | 89 | 1 |
324577 | 324577 | 2020-07-11 | Jackson | Texas | 48239 | 89 | 1 |
321396 | 321396 | 2020-07-10 | Jackson | Texas | 48239 | 79 | 1 |
318217 | 318217 | 2020-07-09 | Jackson | Texas | 48239 | 73 | 1 |
315044 | 315044 | 2020-07-08 | Jackson | Texas | 48239 | 68 | 1 |
311870 | 311870 | 2020-07-07 | Jackson | Texas | 48239 | 68 | 1 |
308701 | 308701 | 2020-07-06 | Jackson | Texas | 48239 | 53 | 1 |
305533 | 305533 | 2020-07-05 | Jackson | Texas | 48239 | 53 | 1 |
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);