ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Carroll" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
908065 | 908065 | 2021-01-08 | Carroll | Illinois | 17015 | 1374 | 32 |
904819 | 904819 | 2021-01-07 | Carroll | Illinois | 17015 | 1366 | 32 |
901574 | 901574 | 2021-01-06 | Carroll | Illinois | 17015 | 1357 | 32 |
898329 | 898329 | 2021-01-05 | Carroll | Illinois | 17015 | 1354 | 31 |
895084 | 895084 | 2021-01-04 | Carroll | Illinois | 17015 | 1348 | 31 |
891837 | 891837 | 2021-01-03 | Carroll | Illinois | 17015 | 1343 | 31 |
888590 | 888590 | 2021-01-02 | Carroll | Illinois | 17015 | 1342 | 31 |
885345 | 885345 | 2021-01-01 | Carroll | Illinois | 17015 | 1333 | 31 |
882100 | 882100 | 2020-12-31 | Carroll | Illinois | 17015 | 1333 | 31 |
878855 | 878855 | 2020-12-30 | Carroll | Illinois | 17015 | 1326 | 31 |
875610 | 875610 | 2020-12-29 | Carroll | Illinois | 17015 | 1320 | 31 |
872365 | 872365 | 2020-12-28 | Carroll | Illinois | 17015 | 1314 | 30 |
869120 | 869120 | 2020-12-27 | Carroll | Illinois | 17015 | 1306 | 30 |
865875 | 865875 | 2020-12-26 | Carroll | Illinois | 17015 | 1300 | 30 |
862630 | 862630 | 2020-12-25 | Carroll | Illinois | 17015 | 1284 | 30 |
859385 | 859385 | 2020-12-24 | Carroll | Illinois | 17015 | 1284 | 30 |
856140 | 856140 | 2020-12-23 | Carroll | Illinois | 17015 | 1277 | 30 |
852895 | 852895 | 2020-12-22 | Carroll | Illinois | 17015 | 1272 | 29 |
849650 | 849650 | 2020-12-21 | Carroll | Illinois | 17015 | 1269 | 29 |
846405 | 846405 | 2020-12-20 | Carroll | Illinois | 17015 | 1268 | 29 |
843159 | 843159 | 2020-12-19 | Carroll | Illinois | 17015 | 1263 | 29 |
839914 | 839914 | 2020-12-18 | Carroll | Illinois | 17015 | 1253 | 29 |
836669 | 836669 | 2020-12-17 | Carroll | Illinois | 17015 | 1245 | 29 |
833423 | 833423 | 2020-12-16 | Carroll | Illinois | 17015 | 1232 | 28 |
830176 | 830176 | 2020-12-15 | Carroll | Illinois | 17015 | 1230 | 28 |
826930 | 826930 | 2020-12-14 | Carroll | Illinois | 17015 | 1219 | 28 |
823683 | 823683 | 2020-12-13 | Carroll | Illinois | 17015 | 1218 | 28 |
820437 | 820437 | 2020-12-12 | Carroll | Illinois | 17015 | 1216 | 28 |
817191 | 817191 | 2020-12-11 | Carroll | Illinois | 17015 | 1208 | 28 |
813945 | 813945 | 2020-12-10 | Carroll | Illinois | 17015 | 1200 | 27 |
810700 | 810700 | 2020-12-09 | Carroll | Illinois | 17015 | 1188 | 27 |
807455 | 807455 | 2020-12-08 | Carroll | Illinois | 17015 | 1184 | 27 |
804210 | 804210 | 2020-12-07 | Carroll | Illinois | 17015 | 1162 | 27 |
800965 | 800965 | 2020-12-06 | Carroll | Illinois | 17015 | 1156 | 27 |
797720 | 797720 | 2020-12-05 | Carroll | Illinois | 17015 | 1141 | 27 |
794475 | 794475 | 2020-12-04 | Carroll | Illinois | 17015 | 1125 | 27 |
791230 | 791230 | 2020-12-03 | Carroll | Illinois | 17015 | 1109 | 27 |
787985 | 787985 | 2020-12-02 | Carroll | Illinois | 17015 | 1090 | 25 |
784741 | 784741 | 2020-12-01 | Carroll | Illinois | 17015 | 1084 | 25 |
781496 | 781496 | 2020-11-30 | Carroll | Illinois | 17015 | 1073 | 24 |
778250 | 778250 | 2020-11-29 | Carroll | Illinois | 17015 | 1070 | 24 |
775005 | 775005 | 2020-11-28 | Carroll | Illinois | 17015 | 1063 | 24 |
771760 | 771760 | 2020-11-27 | Carroll | Illinois | 17015 | 1047 | 24 |
768515 | 768515 | 2020-11-26 | Carroll | Illinois | 17015 | 1028 | 24 |
765269 | 765269 | 2020-11-25 | Carroll | Illinois | 17015 | 1013 | 24 |
762024 | 762024 | 2020-11-24 | Carroll | Illinois | 17015 | 1001 | 24 |
758779 | 758779 | 2020-11-23 | Carroll | Illinois | 17015 | 984 | 24 |
755532 | 755532 | 2020-11-22 | Carroll | Illinois | 17015 | 978 | 24 |
752286 | 752286 | 2020-11-21 | Carroll | Illinois | 17015 | 966 | 24 |
749040 | 749040 | 2020-11-20 | Carroll | Illinois | 17015 | 959 | 23 |
745794 | 745794 | 2020-11-19 | Carroll | Illinois | 17015 | 941 | 23 |
742547 | 742547 | 2020-11-18 | Carroll | Illinois | 17015 | 930 | 23 |
739300 | 739300 | 2020-11-17 | Carroll | Illinois | 17015 | 911 | 23 |
736056 | 736056 | 2020-11-16 | Carroll | Illinois | 17015 | 898 | 23 |
732810 | 732810 | 2020-11-15 | Carroll | Illinois | 17015 | 881 | 23 |
729565 | 729565 | 2020-11-14 | Carroll | Illinois | 17015 | 871 | 22 |
726322 | 726322 | 2020-11-13 | Carroll | Illinois | 17015 | 838 | 22 |
723079 | 723079 | 2020-11-12 | Carroll | Illinois | 17015 | 806 | 21 |
719836 | 719836 | 2020-11-11 | Carroll | Illinois | 17015 | 787 | 21 |
716593 | 716593 | 2020-11-10 | Carroll | Illinois | 17015 | 755 | 18 |
713349 | 713349 | 2020-11-09 | Carroll | Illinois | 17015 | 723 | 18 |
710105 | 710105 | 2020-11-08 | Carroll | Illinois | 17015 | 679 | 17 |
706861 | 706861 | 2020-11-07 | Carroll | Illinois | 17015 | 670 | 17 |
703618 | 703618 | 2020-11-06 | Carroll | Illinois | 17015 | 641 | 17 |
700375 | 700375 | 2020-11-05 | Carroll | Illinois | 17015 | 620 | 16 |
697131 | 697131 | 2020-11-04 | Carroll | Illinois | 17015 | 571 | 15 |
693889 | 693889 | 2020-11-03 | Carroll | Illinois | 17015 | 559 | 14 |
690646 | 690646 | 2020-11-02 | Carroll | Illinois | 17015 | 521 | 14 |
687401 | 687401 | 2020-11-01 | Carroll | Illinois | 17015 | 506 | 14 |
684157 | 684157 | 2020-10-31 | Carroll | Illinois | 17015 | 490 | 13 |
680914 | 680914 | 2020-10-30 | Carroll | Illinois | 17015 | 490 | 13 |
677671 | 677671 | 2020-10-29 | Carroll | Illinois | 17015 | 457 | 12 |
674428 | 674428 | 2020-10-28 | Carroll | Illinois | 17015 | 437 | 12 |
671186 | 671186 | 2020-10-27 | Carroll | Illinois | 17015 | 430 | 12 |
667943 | 667943 | 2020-10-26 | Carroll | Illinois | 17015 | 419 | 11 |
664699 | 664699 | 2020-10-25 | Carroll | Illinois | 17015 | 410 | 11 |
661454 | 661454 | 2020-10-24 | Carroll | Illinois | 17015 | 401 | 11 |
658210 | 658210 | 2020-10-23 | Carroll | Illinois | 17015 | 384 | 9 |
654965 | 654965 | 2020-10-22 | Carroll | Illinois | 17015 | 383 | 9 |
651720 | 651720 | 2020-10-21 | Carroll | Illinois | 17015 | 372 | 8 |
648476 | 648476 | 2020-10-20 | Carroll | Illinois | 17015 | 367 | 8 |
645231 | 645231 | 2020-10-19 | Carroll | Illinois | 17015 | 365 | 8 |
641984 | 641984 | 2020-10-18 | Carroll | Illinois | 17015 | 356 | 7 |
638737 | 638737 | 2020-10-17 | Carroll | Illinois | 17015 | 350 | 7 |
635491 | 635491 | 2020-10-16 | Carroll | Illinois | 17015 | 336 | 7 |
632245 | 632245 | 2020-10-15 | Carroll | Illinois | 17015 | 328 | 7 |
629001 | 629001 | 2020-10-14 | Carroll | Illinois | 17015 | 293 | 6 |
625758 | 625758 | 2020-10-13 | Carroll | Illinois | 17015 | 287 | 6 |
622516 | 622516 | 2020-10-12 | Carroll | Illinois | 17015 | 277 | 6 |
619272 | 619272 | 2020-10-11 | Carroll | Illinois | 17015 | 274 | 6 |
616030 | 616030 | 2020-10-10 | Carroll | Illinois | 17015 | 266 | 6 |
612789 | 612789 | 2020-10-09 | Carroll | Illinois | 17015 | 261 | 6 |
609547 | 609547 | 2020-10-08 | Carroll | Illinois | 17015 | 259 | 6 |
606304 | 606304 | 2020-10-07 | Carroll | Illinois | 17015 | 252 | 6 |
603062 | 603062 | 2020-10-06 | Carroll | Illinois | 17015 | 251 | 6 |
599819 | 599819 | 2020-10-05 | Carroll | Illinois | 17015 | 245 | 6 |
596577 | 596577 | 2020-10-04 | Carroll | Illinois | 17015 | 243 | 6 |
593335 | 593335 | 2020-10-03 | Carroll | Illinois | 17015 | 242 | 6 |
590094 | 590094 | 2020-10-02 | Carroll | Illinois | 17015 | 243 | 6 |
586853 | 586853 | 2020-10-01 | Carroll | Illinois | 17015 | 242 | 6 |
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);