ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "St. Clair" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930860 | 930860 | 2021-01-15 | St. Clair | Illinois | 17163 | 24023 | 415 |
927615 | 927615 | 2021-01-14 | St. Clair | Illinois | 17163 | 23809 | 410 |
924369 | 924369 | 2021-01-13 | St. Clair | Illinois | 17163 | 23648 | 405 |
921124 | 921124 | 2021-01-12 | St. Clair | Illinois | 17163 | 23479 | 398 |
917879 | 917879 | 2021-01-11 | St. Clair | Illinois | 17163 | 23291 | 392 |
914634 | 914634 | 2021-01-10 | St. Clair | Illinois | 17163 | 23150 | 392 |
911389 | 911389 | 2021-01-09 | St. Clair | Illinois | 17163 | 22981 | 393 |
908144 | 908144 | 2021-01-08 | St. Clair | Illinois | 17163 | 22713 | 386 |
904898 | 904898 | 2021-01-07 | St. Clair | Illinois | 17163 | 22383 | 382 |
901653 | 901653 | 2021-01-06 | St. Clair | Illinois | 17163 | 22069 | 372 |
898408 | 898408 | 2021-01-05 | St. Clair | Illinois | 17163 | 21926 | 364 |
895163 | 895163 | 2021-01-04 | St. Clair | Illinois | 17163 | 21701 | 361 |
891916 | 891916 | 2021-01-03 | St. Clair | Illinois | 17163 | 21541 | 359 |
888669 | 888669 | 2021-01-02 | St. Clair | Illinois | 17163 | 21425 | 357 |
885424 | 885424 | 2021-01-01 | St. Clair | Illinois | 17163 | 21160 | 353 |
882179 | 882179 | 2020-12-31 | St. Clair | Illinois | 17163 | 20854 | 353 |
878934 | 878934 | 2020-12-30 | St. Clair | Illinois | 17163 | 20662 | 348 |
875689 | 875689 | 2020-12-29 | St. Clair | Illinois | 17163 | 20449 | 343 |
872444 | 872444 | 2020-12-28 | St. Clair | Illinois | 17163 | 20350 | 338 |
869199 | 869199 | 2020-12-27 | St. Clair | Illinois | 17163 | 20204 | 333 |
865954 | 865954 | 2020-12-26 | St. Clair | Illinois | 17163 | 20035 | 331 |
862709 | 862709 | 2020-12-25 | St. Clair | Illinois | 17163 | 19779 | 331 |
859464 | 859464 | 2020-12-24 | St. Clair | Illinois | 17163 | 19779 | 326 |
856219 | 856219 | 2020-12-23 | St. Clair | Illinois | 17163 | 19580 | 325 |
852974 | 852974 | 2020-12-22 | St. Clair | Illinois | 17163 | 19463 | 326 |
849729 | 849729 | 2020-12-21 | St. Clair | Illinois | 17163 | 19304 | 325 |
846484 | 846484 | 2020-12-20 | St. Clair | Illinois | 17163 | 19162 | 325 |
843238 | 843238 | 2020-12-19 | St. Clair | Illinois | 17163 | 19048 | 323 |
839993 | 839993 | 2020-12-18 | St. Clair | Illinois | 17163 | 18891 | 321 |
836748 | 836748 | 2020-12-17 | St. Clair | Illinois | 17163 | 18764 | 319 |
833502 | 833502 | 2020-12-16 | St. Clair | Illinois | 17163 | 18540 | 317 |
830255 | 830255 | 2020-12-15 | St. Clair | Illinois | 17163 | 18354 | 312 |
827009 | 827009 | 2020-12-14 | St. Clair | Illinois | 17163 | 18155 | 310 |
823762 | 823762 | 2020-12-13 | St. Clair | Illinois | 17163 | 17959 | 309 |
820516 | 820516 | 2020-12-12 | St. Clair | Illinois | 17163 | 17780 | 306 |
817270 | 817270 | 2020-12-11 | St. Clair | Illinois | 17163 | 17589 | 304 |
814024 | 814024 | 2020-12-10 | St. Clair | Illinois | 17163 | 17348 | 297 |
810779 | 810779 | 2020-12-09 | St. Clair | Illinois | 17163 | 17074 | 290 |
807534 | 807534 | 2020-12-08 | St. Clair | Illinois | 17163 | 16905 | 284 |
804289 | 804289 | 2020-12-07 | St. Clair | Illinois | 17163 | 16684 | 280 |
801044 | 801044 | 2020-12-06 | St. Clair | Illinois | 17163 | 16430 | 279 |
797799 | 797799 | 2020-12-05 | St. Clair | Illinois | 17163 | 16277 | 279 |
794554 | 794554 | 2020-12-04 | St. Clair | Illinois | 17163 | 15964 | 274 |
791309 | 791309 | 2020-12-03 | St. Clair | Illinois | 17163 | 15678 | 269 |
788064 | 788064 | 2020-12-02 | St. Clair | Illinois | 17163 | 15469 | 266 |
784820 | 784820 | 2020-12-01 | St. Clair | Illinois | 17163 | 15207 | 262 |
781575 | 781575 | 2020-11-30 | St. Clair | Illinois | 17163 | 14980 | 259 |
778329 | 778329 | 2020-11-29 | St. Clair | Illinois | 17163 | 14783 | 259 |
775084 | 775084 | 2020-11-28 | St. Clair | Illinois | 17163 | 14532 | 259 |
771839 | 771839 | 2020-11-27 | St. Clair | Illinois | 17163 | 14273 | 257 |
768594 | 768594 | 2020-11-26 | St. Clair | Illinois | 17163 | 13858 | 256 |
765348 | 765348 | 2020-11-25 | St. Clair | Illinois | 17163 | 13858 | 255 |
762103 | 762103 | 2020-11-24 | St. Clair | Illinois | 17163 | 13632 | 255 |
758858 | 758858 | 2020-11-23 | St. Clair | Illinois | 17163 | 13340 | 254 |
755611 | 755611 | 2020-11-22 | St. Clair | Illinois | 17163 | 13077 | 253 |
752365 | 752365 | 2020-11-21 | St. Clair | Illinois | 17163 | 12866 | 251 |
749119 | 749119 | 2020-11-20 | St. Clair | Illinois | 17163 | 12626 | 248 |
745873 | 745873 | 2020-11-19 | St. Clair | Illinois | 17163 | 12385 | 248 |
742626 | 742626 | 2020-11-18 | St. Clair | Illinois | 17163 | 12245 | 247 |
739379 | 739379 | 2020-11-17 | St. Clair | Illinois | 17163 | 12085 | 246 |
736135 | 736135 | 2020-11-16 | St. Clair | Illinois | 17163 | 11851 | 245 |
732889 | 732889 | 2020-11-15 | St. Clair | Illinois | 17163 | 11572 | 245 |
729644 | 729644 | 2020-11-14 | St. Clair | Illinois | 17163 | 11427 | 245 |
726401 | 726401 | 2020-11-13 | St. Clair | Illinois | 17163 | 11239 | 245 |
723158 | 723158 | 2020-11-12 | St. Clair | Illinois | 17163 | 11031 | 244 |
719915 | 719915 | 2020-11-11 | St. Clair | Illinois | 17163 | 10881 | 243 |
716672 | 716672 | 2020-11-10 | St. Clair | Illinois | 17163 | 10676 | 242 |
713428 | 713428 | 2020-11-09 | St. Clair | Illinois | 17163 | 10464 | 241 |
710184 | 710184 | 2020-11-08 | St. Clair | Illinois | 17163 | 10276 | 241 |
706940 | 706940 | 2020-11-07 | St. Clair | Illinois | 17163 | 10134 | 240 |
703697 | 703697 | 2020-11-06 | St. Clair | Illinois | 17163 | 9942 | 239 |
700454 | 700454 | 2020-11-05 | St. Clair | Illinois | 17163 | 9786 | 228 |
697210 | 697210 | 2020-11-04 | St. Clair | Illinois | 17163 | 9679 | 228 |
693968 | 693968 | 2020-11-03 | St. Clair | Illinois | 17163 | 9608 | 228 |
690725 | 690725 | 2020-11-02 | St. Clair | Illinois | 17163 | 9500 | 225 |
687480 | 687480 | 2020-11-01 | St. Clair | Illinois | 17163 | 9431 | 224 |
684236 | 684236 | 2020-10-31 | St. Clair | Illinois | 17163 | 9344 | 223 |
680993 | 680993 | 2020-10-30 | St. Clair | Illinois | 17163 | 9246 | 224 |
677750 | 677750 | 2020-10-29 | St. Clair | Illinois | 17163 | 9152 | 223 |
674507 | 674507 | 2020-10-28 | St. Clair | Illinois | 17163 | 9078 | 221 |
671265 | 671265 | 2020-10-27 | St. Clair | Illinois | 17163 | 9023 | 221 |
668022 | 668022 | 2020-10-26 | St. Clair | Illinois | 17163 | 8967 | 220 |
664778 | 664778 | 2020-10-25 | St. Clair | Illinois | 17163 | 8884 | 220 |
661533 | 661533 | 2020-10-24 | St. Clair | Illinois | 17163 | 8827 | 220 |
658289 | 658289 | 2020-10-23 | St. Clair | Illinois | 17163 | 8762 | 220 |
655044 | 655044 | 2020-10-22 | St. Clair | Illinois | 17163 | 8696 | 219 |
651799 | 651799 | 2020-10-21 | St. Clair | Illinois | 17163 | 8603 | 219 |
648555 | 648555 | 2020-10-20 | St. Clair | Illinois | 17163 | 8541 | 217 |
645310 | 645310 | 2020-10-19 | St. Clair | Illinois | 17163 | 8475 | 215 |
642063 | 642063 | 2020-10-18 | St. Clair | Illinois | 17163 | 8419 | 214 |
638816 | 638816 | 2020-10-17 | St. Clair | Illinois | 17163 | 8354 | 214 |
635570 | 635570 | 2020-10-16 | St. Clair | Illinois | 17163 | 8309 | 213 |
632324 | 632324 | 2020-10-15 | St. Clair | Illinois | 17163 | 8249 | 208 |
629080 | 629080 | 2020-10-14 | St. Clair | Illinois | 17163 | 8187 | 207 |
625837 | 625837 | 2020-10-13 | St. Clair | Illinois | 17163 | 8147 | 205 |
622595 | 622595 | 2020-10-12 | St. Clair | Illinois | 17163 | 8105 | 202 |
619351 | 619351 | 2020-10-11 | St. Clair | Illinois | 17163 | 8038 | 202 |
616109 | 616109 | 2020-10-10 | St. Clair | Illinois | 17163 | 7993 | 202 |
612868 | 612868 | 2020-10-09 | St. Clair | Illinois | 17163 | 7952 | 202 |
609626 | 609626 | 2020-10-08 | St. Clair | Illinois | 17163 | 7894 | 200 |
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);