ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
758 rows where county = "Marion" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637658 | 637658 | 2020-10-16 | Marion | Texas | 48315 | 162 | 14 |
634413 | 634413 | 2020-10-15 | Marion | Texas | 48315 | 162 | 14 |
631168 | 631168 | 2020-10-14 | Marion | Texas | 48315 | 162 | 14 |
627924 | 627924 | 2020-10-13 | Marion | Texas | 48315 | 160 | 14 |
624681 | 624681 | 2020-10-12 | Marion | Texas | 48315 | 158 | 14 |
621438 | 621438 | 2020-10-11 | Marion | Texas | 48315 | 158 | 14 |
618195 | 618195 | 2020-10-10 | Marion | Texas | 48315 | 158 | 14 |
614953 | 614953 | 2020-10-09 | Marion | Texas | 48315 | 158 | 14 |
611712 | 611712 | 2020-10-08 | Marion | Texas | 48315 | 156 | 14 |
608470 | 608470 | 2020-10-07 | Marion | Texas | 48315 | 156 | 14 |
605227 | 605227 | 2020-10-06 | Marion | Texas | 48315 | 156 | 14 |
601985 | 601985 | 2020-10-05 | Marion | Texas | 48315 | 153 | 14 |
598742 | 598742 | 2020-10-04 | Marion | Texas | 48315 | 152 | 14 |
595499 | 595499 | 2020-10-03 | Marion | Texas | 48315 | 152 | 14 |
592257 | 592257 | 2020-10-02 | Marion | Texas | 48315 | 152 | 14 |
589017 | 589017 | 2020-10-01 | Marion | Texas | 48315 | 151 | 14 |
585776 | 585776 | 2020-09-30 | Marion | Texas | 48315 | 150 | 14 |
582536 | 582536 | 2020-09-29 | Marion | Texas | 48315 | 150 | 14 |
579297 | 579297 | 2020-09-28 | Marion | Texas | 48315 | 150 | 14 |
576056 | 576056 | 2020-09-27 | Marion | Texas | 48315 | 150 | 14 |
572812 | 572812 | 2020-09-26 | Marion | Texas | 48315 | 150 | 14 |
569570 | 569570 | 2020-09-25 | Marion | Texas | 48315 | 150 | 14 |
566329 | 566329 | 2020-09-24 | Marion | Texas | 48315 | 150 | 14 |
563088 | 563088 | 2020-09-23 | Marion | Texas | 48315 | 150 | 14 |
559849 | 559849 | 2020-09-22 | Marion | Texas | 48315 | 150 | 14 |
556613 | 556613 | 2020-09-21 | Marion | Texas | 48315 | 150 | 13 |
553376 | 553376 | 2020-09-20 | Marion | Texas | 48315 | 149 | 13 |
550137 | 550137 | 2020-09-19 | Marion | Texas | 48315 | 149 | 13 |
546898 | 546898 | 2020-09-18 | Marion | Texas | 48315 | 149 | 13 |
543661 | 543661 | 2020-09-17 | Marion | Texas | 48315 | 147 | 13 |
540425 | 540425 | 2020-09-16 | Marion | Texas | 48315 | 147 | 13 |
537188 | 537188 | 2020-09-15 | Marion | Texas | 48315 | 147 | 13 |
533952 | 533952 | 2020-09-14 | Marion | Texas | 48315 | 147 | 13 |
530717 | 530717 | 2020-09-13 | Marion | Texas | 48315 | 147 | 13 |
527480 | 527480 | 2020-09-12 | Marion | Texas | 48315 | 147 | 13 |
524244 | 524244 | 2020-09-11 | Marion | Texas | 48315 | 147 | 13 |
521008 | 521008 | 2020-09-10 | Marion | Texas | 48315 | 147 | 13 |
517772 | 517772 | 2020-09-09 | Marion | Texas | 48315 | 147 | 13 |
514537 | 514537 | 2020-09-08 | Marion | Texas | 48315 | 147 | 12 |
511304 | 511304 | 2020-09-07 | Marion | Texas | 48315 | 147 | 12 |
508071 | 508071 | 2020-09-06 | Marion | Texas | 48315 | 146 | 12 |
504839 | 504839 | 2020-09-05 | Marion | Texas | 48315 | 146 | 12 |
501605 | 501605 | 2020-09-04 | Marion | Texas | 48315 | 146 | 12 |
498371 | 498371 | 2020-09-03 | Marion | Texas | 48315 | 143 | 12 |
495138 | 495138 | 2020-09-02 | Marion | Texas | 48315 | 142 | 10 |
491904 | 491904 | 2020-09-01 | Marion | Texas | 48315 | 140 | 10 |
488671 | 488671 | 2020-08-31 | Marion | Texas | 48315 | 140 | 10 |
485438 | 485438 | 2020-08-30 | Marion | Texas | 48315 | 140 | 10 |
482203 | 482203 | 2020-08-29 | Marion | Texas | 48315 | 140 | 10 |
478969 | 478969 | 2020-08-28 | Marion | Texas | 48315 | 140 | 10 |
475736 | 475736 | 2020-08-27 | Marion | Texas | 48315 | 139 | 10 |
472503 | 472503 | 2020-08-26 | Marion | Texas | 48315 | 139 | 10 |
469271 | 469271 | 2020-08-25 | Marion | Texas | 48315 | 139 | 10 |
466042 | 466042 | 2020-08-24 | Marion | Texas | 48315 | 139 | 10 |
462813 | 462813 | 2020-08-23 | Marion | Texas | 48315 | 139 | 10 |
459584 | 459584 | 2020-08-22 | Marion | Texas | 48315 | 139 | 10 |
456357 | 456357 | 2020-08-21 | Marion | Texas | 48315 | 139 | 10 |
453129 | 453129 | 2020-08-20 | Marion | Texas | 48315 | 136 | 10 |
449901 | 449901 | 2020-08-19 | Marion | Texas | 48315 | 136 | 10 |
446673 | 446673 | 2020-08-18 | Marion | Texas | 48315 | 136 | 10 |
443446 | 443446 | 2020-08-17 | Marion | Texas | 48315 | 136 | 9 |
440220 | 440220 | 2020-08-16 | Marion | Texas | 48315 | 136 | 9 |
436994 | 436994 | 2020-08-15 | Marion | Texas | 48315 | 136 | 9 |
433768 | 433768 | 2020-08-14 | Marion | Texas | 48315 | 135 | 9 |
430543 | 430543 | 2020-08-13 | Marion | Texas | 48315 | 135 | 9 |
427316 | 427316 | 2020-08-12 | Marion | Texas | 48315 | 134 | 9 |
424092 | 424092 | 2020-08-11 | Marion | Texas | 48315 | 134 | 9 |
420871 | 420871 | 2020-08-10 | Marion | Texas | 48315 | 133 | 8 |
417650 | 417650 | 2020-08-09 | Marion | Texas | 48315 | 133 | 8 |
414429 | 414429 | 2020-08-08 | Marion | Texas | 48315 | 133 | 8 |
411209 | 411209 | 2020-08-07 | Marion | Texas | 48315 | 130 | 8 |
407990 | 407990 | 2020-08-06 | Marion | Texas | 48315 | 129 | 8 |
404770 | 404770 | 2020-08-05 | Marion | Texas | 48315 | 128 | 8 |
401552 | 401552 | 2020-08-04 | Marion | Texas | 48315 | 127 | 8 |
398336 | 398336 | 2020-08-03 | Marion | Texas | 48315 | 127 | 7 |
395120 | 395120 | 2020-08-02 | Marion | Texas | 48315 | 124 | 7 |
391904 | 391904 | 2020-08-01 | Marion | Texas | 48315 | 123 | 7 |
388687 | 388687 | 2020-07-31 | Marion | Texas | 48315 | 123 | 7 |
385470 | 385470 | 2020-07-30 | Marion | Texas | 48315 | 122 | 7 |
382252 | 382252 | 2020-07-29 | Marion | Texas | 48315 | 122 | 7 |
379035 | 379035 | 2020-07-28 | Marion | Texas | 48315 | 119 | 7 |
375819 | 375819 | 2020-07-27 | Marion | Texas | 48315 | 117 | 6 |
372606 | 372606 | 2020-07-26 | Marion | Texas | 48315 | 117 | 7 |
369394 | 369394 | 2020-07-25 | Marion | Texas | 48315 | 116 | 7 |
366185 | 366185 | 2020-07-24 | Marion | Texas | 48315 | 114 | 4 |
362979 | 362979 | 2020-07-23 | Marion | Texas | 48315 | 113 | 4 |
359772 | 359772 | 2020-07-22 | Marion | Texas | 48315 | 111 | 4 |
356567 | 356567 | 2020-07-21 | Marion | Texas | 48315 | 111 | 2 |
353364 | 353364 | 2020-07-20 | Marion | Texas | 48315 | 108 | 2 |
350162 | 350162 | 2020-07-19 | Marion | Texas | 48315 | 71 | 2 |
346962 | 346962 | 2020-07-18 | Marion | Texas | 48315 | 71 | 2 |
343762 | 343762 | 2020-07-17 | Marion | Texas | 48315 | 68 | 2 |
340563 | 340563 | 2020-07-16 | Marion | Texas | 48315 | 67 | 2 |
337367 | 337367 | 2020-07-15 | Marion | Texas | 48315 | 64 | 2 |
334172 | 334172 | 2020-07-14 | Marion | Texas | 48315 | 64 | 2 |
330980 | 330980 | 2020-07-13 | Marion | Texas | 48315 | 58 | 2 |
327794 | 327794 | 2020-07-12 | Marion | Texas | 48315 | 40 | 1 |
324609 | 324609 | 2020-07-11 | Marion | Texas | 48315 | 37 | 1 |
321428 | 321428 | 2020-07-10 | Marion | Texas | 48315 | 37 | 1 |
318249 | 318249 | 2020-07-09 | Marion | Texas | 48315 | 37 | 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);