ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
680 rows where fips = 48447 and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
299303 | 299303 | 2020-07-03 | Throckmorton | Texas | 48447 | 1 | 0 |
302467 | 302467 | 2020-07-04 | Throckmorton | Texas | 48447 | 1 | 0 |
305631 | 305631 | 2020-07-05 | Throckmorton | Texas | 48447 | 1 | 0 |
308799 | 308799 | 2020-07-06 | Throckmorton | Texas | 48447 | 1 | 0 |
311968 | 311968 | 2020-07-07 | Throckmorton | Texas | 48447 | 1 | 0 |
315142 | 315142 | 2020-07-08 | Throckmorton | Texas | 48447 | 1 | 0 |
318315 | 318315 | 2020-07-09 | Throckmorton | Texas | 48447 | 1 | 0 |
321494 | 321494 | 2020-07-10 | Throckmorton | Texas | 48447 | 1 | 0 |
324675 | 324675 | 2020-07-11 | Throckmorton | Texas | 48447 | 1 | 0 |
327860 | 327860 | 2020-07-12 | Throckmorton | Texas | 48447 | 1 | 0 |
331046 | 331046 | 2020-07-13 | Throckmorton | Texas | 48447 | 1 | 0 |
334239 | 334239 | 2020-07-14 | Throckmorton | Texas | 48447 | 2 | 0 |
337434 | 337434 | 2020-07-15 | Throckmorton | Texas | 48447 | 2 | 0 |
340630 | 340630 | 2020-07-16 | Throckmorton | Texas | 48447 | 2 | 0 |
343829 | 343829 | 2020-07-17 | Throckmorton | Texas | 48447 | 2 | 0 |
347030 | 347030 | 2020-07-18 | Throckmorton | Texas | 48447 | 2 | 0 |
350230 | 350230 | 2020-07-19 | Throckmorton | Texas | 48447 | 2 | 0 |
353432 | 353432 | 2020-07-20 | Throckmorton | Texas | 48447 | 2 | 0 |
356635 | 356635 | 2020-07-21 | Throckmorton | Texas | 48447 | 2 | 0 |
359840 | 359840 | 2020-07-22 | Throckmorton | Texas | 48447 | 2 | 0 |
363047 | 363047 | 2020-07-23 | Throckmorton | Texas | 48447 | 2 | 0 |
366253 | 366253 | 2020-07-24 | Throckmorton | Texas | 48447 | 2 | 0 |
369462 | 369462 | 2020-07-25 | Throckmorton | Texas | 48447 | 2 | 0 |
372674 | 372674 | 2020-07-26 | Throckmorton | Texas | 48447 | 2 | 0 |
375887 | 375887 | 2020-07-27 | Throckmorton | Texas | 48447 | 2 | 0 |
379103 | 379103 | 2020-07-28 | Throckmorton | Texas | 48447 | 2 | 0 |
382320 | 382320 | 2020-07-29 | Throckmorton | Texas | 48447 | 2 | 0 |
385538 | 385538 | 2020-07-30 | Throckmorton | Texas | 48447 | 2 | 0 |
388755 | 388755 | 2020-07-31 | Throckmorton | Texas | 48447 | 3 | 0 |
391972 | 391972 | 2020-08-01 | Throckmorton | Texas | 48447 | 4 | 0 |
395188 | 395188 | 2020-08-02 | Throckmorton | Texas | 48447 | 4 | 0 |
398404 | 398404 | 2020-08-03 | Throckmorton | Texas | 48447 | 4 | 0 |
401620 | 401620 | 2020-08-04 | Throckmorton | Texas | 48447 | 4 | 0 |
404838 | 404838 | 2020-08-05 | Throckmorton | Texas | 48447 | 4 | 0 |
408058 | 408058 | 2020-08-06 | Throckmorton | Texas | 48447 | 4 | 2 |
411277 | 411277 | 2020-08-07 | Throckmorton | Texas | 48447 | 4 | 2 |
414497 | 414497 | 2020-08-08 | Throckmorton | Texas | 48447 | 4 | 2 |
417718 | 417718 | 2020-08-09 | Throckmorton | Texas | 48447 | 4 | 2 |
420939 | 420939 | 2020-08-10 | Throckmorton | Texas | 48447 | 4 | 2 |
424160 | 424160 | 2020-08-11 | Throckmorton | Texas | 48447 | 4 | 2 |
427384 | 427384 | 2020-08-12 | Throckmorton | Texas | 48447 | 4 | 2 |
430612 | 430612 | 2020-08-13 | Throckmorton | Texas | 48447 | 4 | 2 |
433837 | 433837 | 2020-08-14 | Throckmorton | Texas | 48447 | 4 | 2 |
437063 | 437063 | 2020-08-15 | Throckmorton | Texas | 48447 | 4 | 2 |
440289 | 440289 | 2020-08-16 | Throckmorton | Texas | 48447 | 4 | 2 |
443515 | 443515 | 2020-08-17 | Throckmorton | Texas | 48447 | 4 | 2 |
446742 | 446742 | 2020-08-18 | Throckmorton | Texas | 48447 | 4 | 2 |
449970 | 449970 | 2020-08-19 | Throckmorton | Texas | 48447 | 4 | 2 |
453198 | 453198 | 2020-08-20 | Throckmorton | Texas | 48447 | 4 | 2 |
456426 | 456426 | 2020-08-21 | Throckmorton | Texas | 48447 | 4 | 2 |
459653 | 459653 | 2020-08-22 | Throckmorton | Texas | 48447 | 4 | 2 |
462882 | 462882 | 2020-08-23 | Throckmorton | Texas | 48447 | 4 | 2 |
466111 | 466111 | 2020-08-24 | Throckmorton | Texas | 48447 | 4 | 2 |
469340 | 469340 | 2020-08-25 | Throckmorton | Texas | 48447 | 4 | 2 |
472572 | 472572 | 2020-08-26 | Throckmorton | Texas | 48447 | 4 | 2 |
475805 | 475805 | 2020-08-27 | Throckmorton | Texas | 48447 | 4 | 2 |
479038 | 479038 | 2020-08-28 | Throckmorton | Texas | 48447 | 4 | 2 |
482272 | 482272 | 2020-08-29 | Throckmorton | Texas | 48447 | 4 | 2 |
485507 | 485507 | 2020-08-30 | Throckmorton | Texas | 48447 | 4 | 2 |
488740 | 488740 | 2020-08-31 | Throckmorton | Texas | 48447 | 4 | 2 |
491973 | 491973 | 2020-09-01 | Throckmorton | Texas | 48447 | 5 | 2 |
495207 | 495207 | 2020-09-02 | Throckmorton | Texas | 48447 | 5 | 2 |
498440 | 498440 | 2020-09-03 | Throckmorton | Texas | 48447 | 5 | 2 |
501674 | 501674 | 2020-09-04 | Throckmorton | Texas | 48447 | 5 | 2 |
504908 | 504908 | 2020-09-05 | Throckmorton | Texas | 48447 | 5 | 2 |
508140 | 508140 | 2020-09-06 | Throckmorton | Texas | 48447 | 5 | 2 |
511373 | 511373 | 2020-09-07 | Throckmorton | Texas | 48447 | 5 | 2 |
514606 | 514606 | 2020-09-08 | Throckmorton | Texas | 48447 | 5 | 2 |
517841 | 517841 | 2020-09-09 | Throckmorton | Texas | 48447 | 5 | 2 |
521077 | 521077 | 2020-09-10 | Throckmorton | Texas | 48447 | 5 | 2 |
524313 | 524313 | 2020-09-11 | Throckmorton | Texas | 48447 | 6 | 2 |
527549 | 527549 | 2020-09-12 | Throckmorton | Texas | 48447 | 6 | 2 |
530786 | 530786 | 2020-09-13 | Throckmorton | Texas | 48447 | 6 | 2 |
534021 | 534021 | 2020-09-14 | Throckmorton | Texas | 48447 | 6 | 2 |
537257 | 537257 | 2020-09-15 | Throckmorton | Texas | 48447 | 6 | 2 |
540494 | 540494 | 2020-09-16 | Throckmorton | Texas | 48447 | 6 | 2 |
543730 | 543730 | 2020-09-17 | Throckmorton | Texas | 48447 | 6 | 2 |
546967 | 546967 | 2020-09-18 | Throckmorton | Texas | 48447 | 7 | 2 |
550206 | 550206 | 2020-09-19 | Throckmorton | Texas | 48447 | 7 | 2 |
553445 | 553445 | 2020-09-20 | Throckmorton | Texas | 48447 | 7 | 2 |
556682 | 556682 | 2020-09-21 | Throckmorton | Texas | 48447 | 7 | 2 |
559918 | 559918 | 2020-09-22 | Throckmorton | Texas | 48447 | 8 | 2 |
563157 | 563157 | 2020-09-23 | Throckmorton | Texas | 48447 | 8 | 2 |
566398 | 566398 | 2020-09-24 | Throckmorton | Texas | 48447 | 8 | 2 |
569639 | 569639 | 2020-09-25 | Throckmorton | Texas | 48447 | 8 | 2 |
572881 | 572881 | 2020-09-26 | Throckmorton | Texas | 48447 | 8 | 2 |
576125 | 576125 | 2020-09-27 | Throckmorton | Texas | 48447 | 8 | 2 |
579366 | 579366 | 2020-09-28 | Throckmorton | Texas | 48447 | 8 | 2 |
582605 | 582605 | 2020-09-29 | Throckmorton | Texas | 48447 | 8 | 2 |
585845 | 585845 | 2020-09-30 | Throckmorton | Texas | 48447 | 8 | 2 |
589086 | 589086 | 2020-10-01 | Throckmorton | Texas | 48447 | 8 | 2 |
592326 | 592326 | 2020-10-02 | Throckmorton | Texas | 48447 | 8 | 2 |
595568 | 595568 | 2020-10-03 | Throckmorton | Texas | 48447 | 8 | 2 |
598811 | 598811 | 2020-10-04 | Throckmorton | Texas | 48447 | 8 | 2 |
602054 | 602054 | 2020-10-05 | Throckmorton | Texas | 48447 | 8 | 2 |
605296 | 605296 | 2020-10-06 | Throckmorton | Texas | 48447 | 9 | 2 |
608539 | 608539 | 2020-10-07 | Throckmorton | Texas | 48447 | 10 | 2 |
611781 | 611781 | 2020-10-08 | Throckmorton | Texas | 48447 | 13 | 2 |
615022 | 615022 | 2020-10-09 | Throckmorton | Texas | 48447 | 14 | 2 |
618264 | 618264 | 2020-10-10 | Throckmorton | Texas | 48447 | 14 | 2 |
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);