ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
680 rows where county = "Scott" and fips = 17171 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921122 | 921122 | 2021-01-12 | Scott | Illinois | 17171 | 362 | 1 |
917877 | 917877 | 2021-01-11 | Scott | Illinois | 17171 | 354 | 1 |
914632 | 914632 | 2021-01-10 | Scott | Illinois | 17171 | 352 | 1 |
911387 | 911387 | 2021-01-09 | Scott | Illinois | 17171 | 352 | 1 |
908142 | 908142 | 2021-01-08 | Scott | Illinois | 17171 | 344 | 1 |
904896 | 904896 | 2021-01-07 | Scott | Illinois | 17171 | 343 | 1 |
901651 | 901651 | 2021-01-06 | Scott | Illinois | 17171 | 341 | 1 |
898406 | 898406 | 2021-01-05 | Scott | Illinois | 17171 | 339 | 1 |
895161 | 895161 | 2021-01-04 | Scott | Illinois | 17171 | 335 | 1 |
891914 | 891914 | 2021-01-03 | Scott | Illinois | 17171 | 333 | 1 |
888667 | 888667 | 2021-01-02 | Scott | Illinois | 17171 | 333 | 1 |
885422 | 885422 | 2021-01-01 | Scott | Illinois | 17171 | 327 | 1 |
882177 | 882177 | 2020-12-31 | Scott | Illinois | 17171 | 327 | 1 |
878932 | 878932 | 2020-12-30 | Scott | Illinois | 17171 | 325 | 1 |
875687 | 875687 | 2020-12-29 | Scott | Illinois | 17171 | 321 | 1 |
872442 | 872442 | 2020-12-28 | Scott | Illinois | 17171 | 313 | 1 |
869197 | 869197 | 2020-12-27 | Scott | Illinois | 17171 | 311 | 1 |
865952 | 865952 | 2020-12-26 | Scott | Illinois | 17171 | 309 | 1 |
862707 | 862707 | 2020-12-25 | Scott | Illinois | 17171 | 307 | 1 |
859462 | 859462 | 2020-12-24 | Scott | Illinois | 17171 | 307 | 1 |
856217 | 856217 | 2020-12-23 | Scott | Illinois | 17171 | 299 | 1 |
852972 | 852972 | 2020-12-22 | Scott | Illinois | 17171 | 298 | 1 |
849727 | 849727 | 2020-12-21 | Scott | Illinois | 17171 | 292 | 1 |
846482 | 846482 | 2020-12-20 | Scott | Illinois | 17171 | 292 | 1 |
843236 | 843236 | 2020-12-19 | Scott | Illinois | 17171 | 292 | 1 |
839991 | 839991 | 2020-12-18 | Scott | Illinois | 17171 | 289 | 1 |
836746 | 836746 | 2020-12-17 | Scott | Illinois | 17171 | 289 | 1 |
833500 | 833500 | 2020-12-16 | Scott | Illinois | 17171 | 285 | 1 |
830253 | 830253 | 2020-12-15 | Scott | Illinois | 17171 | 285 | 1 |
827007 | 827007 | 2020-12-14 | Scott | Illinois | 17171 | 280 | 1 |
823760 | 823760 | 2020-12-13 | Scott | Illinois | 17171 | 279 | 1 |
820514 | 820514 | 2020-12-12 | Scott | Illinois | 17171 | 276 | 1 |
817268 | 817268 | 2020-12-11 | Scott | Illinois | 17171 | 274 | 0 |
814022 | 814022 | 2020-12-10 | Scott | Illinois | 17171 | 271 | 0 |
810777 | 810777 | 2020-12-09 | Scott | Illinois | 17171 | 268 | 0 |
807532 | 807532 | 2020-12-08 | Scott | Illinois | 17171 | 269 | 0 |
804287 | 804287 | 2020-12-07 | Scott | Illinois | 17171 | 265 | 0 |
801042 | 801042 | 2020-12-06 | Scott | Illinois | 17171 | 264 | 0 |
797797 | 797797 | 2020-12-05 | Scott | Illinois | 17171 | 264 | 0 |
794552 | 794552 | 2020-12-04 | Scott | Illinois | 17171 | 257 | 0 |
791307 | 791307 | 2020-12-03 | Scott | Illinois | 17171 | 251 | 0 |
788062 | 788062 | 2020-12-02 | Scott | Illinois | 17171 | 244 | 0 |
784818 | 784818 | 2020-12-01 | Scott | Illinois | 17171 | 244 | 0 |
781573 | 781573 | 2020-11-30 | Scott | Illinois | 17171 | 233 | 0 |
778327 | 778327 | 2020-11-29 | Scott | Illinois | 17171 | 231 | 0 |
775082 | 775082 | 2020-11-28 | Scott | Illinois | 17171 | 231 | 0 |
771837 | 771837 | 2020-11-27 | Scott | Illinois | 17171 | 231 | 0 |
768592 | 768592 | 2020-11-26 | Scott | Illinois | 17171 | 231 | 0 |
765346 | 765346 | 2020-11-25 | Scott | Illinois | 17171 | 223 | 0 |
762101 | 762101 | 2020-11-24 | Scott | Illinois | 17171 | 223 | 0 |
758856 | 758856 | 2020-11-23 | Scott | Illinois | 17171 | 212 | 0 |
755609 | 755609 | 2020-11-22 | Scott | Illinois | 17171 | 211 | 0 |
752363 | 752363 | 2020-11-21 | Scott | Illinois | 17171 | 211 | 0 |
749117 | 749117 | 2020-11-20 | Scott | Illinois | 17171 | 207 | 0 |
745871 | 745871 | 2020-11-19 | Scott | Illinois | 17171 | 203 | 0 |
742624 | 742624 | 2020-11-18 | Scott | Illinois | 17171 | 199 | 0 |
739377 | 739377 | 2020-11-17 | Scott | Illinois | 17171 | 194 | 0 |
736133 | 736133 | 2020-11-16 | Scott | Illinois | 17171 | 181 | 0 |
732887 | 732887 | 2020-11-15 | Scott | Illinois | 17171 | 179 | 0 |
729642 | 729642 | 2020-11-14 | Scott | Illinois | 17171 | 177 | 0 |
726399 | 726399 | 2020-11-13 | Scott | Illinois | 17171 | 175 | 0 |
723156 | 723156 | 2020-11-12 | Scott | Illinois | 17171 | 172 | 0 |
719913 | 719913 | 2020-11-11 | Scott | Illinois | 17171 | 166 | 0 |
716670 | 716670 | 2020-11-10 | Scott | Illinois | 17171 | 157 | 0 |
713426 | 713426 | 2020-11-09 | Scott | Illinois | 17171 | 151 | 0 |
710182 | 710182 | 2020-11-08 | Scott | Illinois | 17171 | 148 | 0 |
706938 | 706938 | 2020-11-07 | Scott | Illinois | 17171 | 146 | 0 |
703695 | 703695 | 2020-11-06 | Scott | Illinois | 17171 | 126 | 0 |
700452 | 700452 | 2020-11-05 | Scott | Illinois | 17171 | 123 | 0 |
697208 | 697208 | 2020-11-04 | Scott | Illinois | 17171 | 122 | 0 |
693966 | 693966 | 2020-11-03 | Scott | Illinois | 17171 | 121 | 0 |
690723 | 690723 | 2020-11-02 | Scott | Illinois | 17171 | 118 | 0 |
687478 | 687478 | 2020-11-01 | Scott | Illinois | 17171 | 116 | 0 |
684234 | 684234 | 2020-10-31 | Scott | Illinois | 17171 | 116 | 0 |
680991 | 680991 | 2020-10-30 | Scott | Illinois | 17171 | 116 | 0 |
677748 | 677748 | 2020-10-29 | Scott | Illinois | 17171 | 112 | 0 |
674505 | 674505 | 2020-10-28 | Scott | Illinois | 17171 | 109 | 0 |
671263 | 671263 | 2020-10-27 | Scott | Illinois | 17171 | 107 | 0 |
668020 | 668020 | 2020-10-26 | Scott | Illinois | 17171 | 107 | 0 |
664776 | 664776 | 2020-10-25 | Scott | Illinois | 17171 | 106 | 0 |
661531 | 661531 | 2020-10-24 | Scott | Illinois | 17171 | 102 | 0 |
658287 | 658287 | 2020-10-23 | Scott | Illinois | 17171 | 102 | 0 |
655042 | 655042 | 2020-10-22 | Scott | Illinois | 17171 | 100 | 0 |
651797 | 651797 | 2020-10-21 | Scott | Illinois | 17171 | 98 | 0 |
648553 | 648553 | 2020-10-20 | Scott | Illinois | 17171 | 95 | 0 |
645308 | 645308 | 2020-10-19 | Scott | Illinois | 17171 | 93 | 0 |
642061 | 642061 | 2020-10-18 | Scott | Illinois | 17171 | 93 | 0 |
638814 | 638814 | 2020-10-17 | Scott | Illinois | 17171 | 88 | 0 |
635568 | 635568 | 2020-10-16 | Scott | Illinois | 17171 | 88 | 0 |
632322 | 632322 | 2020-10-15 | Scott | Illinois | 17171 | 88 | 0 |
629078 | 629078 | 2020-10-14 | Scott | Illinois | 17171 | 84 | 0 |
625835 | 625835 | 2020-10-13 | Scott | Illinois | 17171 | 84 | 0 |
622593 | 622593 | 2020-10-12 | Scott | Illinois | 17171 | 84 | 0 |
619349 | 619349 | 2020-10-11 | Scott | Illinois | 17171 | 84 | 0 |
616107 | 616107 | 2020-10-10 | Scott | Illinois | 17171 | 84 | 0 |
612866 | 612866 | 2020-10-09 | Scott | Illinois | 17171 | 83 | 0 |
609624 | 609624 | 2020-10-08 | Scott | Illinois | 17171 | 82 | 0 |
606381 | 606381 | 2020-10-07 | Scott | Illinois | 17171 | 82 | 0 |
603139 | 603139 | 2020-10-06 | Scott | Illinois | 17171 | 82 | 0 |
599896 | 599896 | 2020-10-05 | Scott | Illinois | 17171 | 81 | 0 |
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);