ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Rock Island" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
930854 | 930854 | 2021-01-15 | Rock Island | Illinois | 17161 | 11752 | 301 |
927609 | 927609 | 2021-01-14 | Rock Island | Illinois | 17161 | 11688 | 301 |
924363 | 924363 | 2021-01-13 | Rock Island | Illinois | 17161 | 11636 | 298 |
921118 | 921118 | 2021-01-12 | Rock Island | Illinois | 17161 | 11595 | 294 |
917873 | 917873 | 2021-01-11 | Rock Island | Illinois | 17161 | 11548 | 291 |
914628 | 914628 | 2021-01-10 | Rock Island | Illinois | 17161 | 11514 | 291 |
911383 | 911383 | 2021-01-09 | Rock Island | Illinois | 17161 | 11467 | 291 |
908138 | 908138 | 2021-01-08 | Rock Island | Illinois | 17161 | 11418 | 284 |
904892 | 904892 | 2021-01-07 | Rock Island | Illinois | 17161 | 11345 | 279 |
901647 | 901647 | 2021-01-06 | Rock Island | Illinois | 17161 | 11260 | 274 |
898402 | 898402 | 2021-01-05 | Rock Island | Illinois | 17161 | 11208 | 271 |
895157 | 895157 | 2021-01-04 | Rock Island | Illinois | 17161 | 11162 | 266 |
891910 | 891910 | 2021-01-03 | Rock Island | Illinois | 17161 | 11134 | 263 |
888663 | 888663 | 2021-01-02 | Rock Island | Illinois | 17161 | 11117 | 264 |
885418 | 885418 | 2021-01-01 | Rock Island | Illinois | 17161 | 11014 | 259 |
882173 | 882173 | 2020-12-31 | Rock Island | Illinois | 17161 | 11014 | 259 |
878928 | 878928 | 2020-12-30 | Rock Island | Illinois | 17161 | 10938 | 254 |
875683 | 875683 | 2020-12-29 | Rock Island | Illinois | 17161 | 10890 | 248 |
872438 | 872438 | 2020-12-28 | Rock Island | Illinois | 17161 | 10828 | 243 |
869193 | 869193 | 2020-12-27 | Rock Island | Illinois | 17161 | 10776 | 236 |
865948 | 865948 | 2020-12-26 | Rock Island | Illinois | 17161 | 10744 | 235 |
862703 | 862703 | 2020-12-25 | Rock Island | Illinois | 17161 | 10721 | 234 |
859458 | 859458 | 2020-12-24 | Rock Island | Illinois | 17161 | 10654 | 228 |
856213 | 856213 | 2020-12-23 | Rock Island | Illinois | 17161 | 10555 | 228 |
852968 | 852968 | 2020-12-22 | Rock Island | Illinois | 17161 | 10479 | 227 |
849723 | 849723 | 2020-12-21 | Rock Island | Illinois | 17161 | 10423 | 223 |
846478 | 846478 | 2020-12-20 | Rock Island | Illinois | 17161 | 10391 | 220 |
843232 | 843232 | 2020-12-19 | Rock Island | Illinois | 17161 | 10341 | 219 |
839987 | 839987 | 2020-12-18 | Rock Island | Illinois | 17161 | 10255 | 216 |
836742 | 836742 | 2020-12-17 | Rock Island | Illinois | 17161 | 10179 | 211 |
833496 | 833496 | 2020-12-16 | Rock Island | Illinois | 17161 | 10085 | 207 |
830249 | 830249 | 2020-12-15 | Rock Island | Illinois | 17161 | 9995 | 205 |
827003 | 827003 | 2020-12-14 | Rock Island | Illinois | 17161 | 9934 | 202 |
823756 | 823756 | 2020-12-13 | Rock Island | Illinois | 17161 | 9883 | 202 |
820510 | 820510 | 2020-12-12 | Rock Island | Illinois | 17161 | 9805 | 198 |
817264 | 817264 | 2020-12-11 | Rock Island | Illinois | 17161 | 9762 | 195 |
814018 | 814018 | 2020-12-10 | Rock Island | Illinois | 17161 | 9666 | 192 |
810773 | 810773 | 2020-12-09 | Rock Island | Illinois | 17161 | 9512 | 187 |
807528 | 807528 | 2020-12-08 | Rock Island | Illinois | 17161 | 9410 | 181 |
804283 | 804283 | 2020-12-07 | Rock Island | Illinois | 17161 | 9314 | 178 |
801038 | 801038 | 2020-12-06 | Rock Island | Illinois | 17161 | 9191 | 175 |
797793 | 797793 | 2020-12-05 | Rock Island | Illinois | 17161 | 9203 | 173 |
794548 | 794548 | 2020-12-04 | Rock Island | Illinois | 17161 | 9110 | 170 |
791303 | 791303 | 2020-12-03 | Rock Island | Illinois | 17161 | 8981 | 164 |
788058 | 788058 | 2020-12-02 | Rock Island | Illinois | 17161 | 8864 | 157 |
784814 | 784814 | 2020-12-01 | Rock Island | Illinois | 17161 | 8750 | 151 |
781569 | 781569 | 2020-11-30 | Rock Island | Illinois | 17161 | 8685 | 148 |
778323 | 778323 | 2020-11-29 | Rock Island | Illinois | 17161 | 8612 | 141 |
775078 | 775078 | 2020-11-28 | Rock Island | Illinois | 17161 | 8532 | 141 |
771833 | 771833 | 2020-11-27 | Rock Island | Illinois | 17161 | 8444 | 140 |
768588 | 768588 | 2020-11-26 | Rock Island | Illinois | 17161 | 8358 | 140 |
765342 | 765342 | 2020-11-25 | Rock Island | Illinois | 17161 | 8278 | 140 |
762097 | 762097 | 2020-11-24 | Rock Island | Illinois | 17161 | 8152 | 137 |
758852 | 758852 | 2020-11-23 | Rock Island | Illinois | 17161 | 8025 | 134 |
755605 | 755605 | 2020-11-22 | Rock Island | Illinois | 17161 | 7905 | 129 |
752359 | 752359 | 2020-11-21 | Rock Island | Illinois | 17161 | 7794 | 127 |
749113 | 749113 | 2020-11-20 | Rock Island | Illinois | 17161 | 7606 | 125 |
745867 | 745867 | 2020-11-19 | Rock Island | Illinois | 17161 | 7310 | 123 |
742620 | 742620 | 2020-11-18 | Rock Island | Illinois | 17161 | 7186 | 120 |
739373 | 739373 | 2020-11-17 | Rock Island | Illinois | 17161 | 7057 | 117 |
736129 | 736129 | 2020-11-16 | Rock Island | Illinois | 17161 | 6927 | 117 |
732883 | 732883 | 2020-11-15 | Rock Island | Illinois | 17161 | 6759 | 115 |
729638 | 729638 | 2020-11-14 | Rock Island | Illinois | 17161 | 6647 | 115 |
726395 | 726395 | 2020-11-13 | Rock Island | Illinois | 17161 | 6415 | 115 |
723152 | 723152 | 2020-11-12 | Rock Island | Illinois | 17161 | 6189 | 111 |
719909 | 719909 | 2020-11-11 | Rock Island | Illinois | 17161 | 6012 | 109 |
716666 | 716666 | 2020-11-10 | Rock Island | Illinois | 17161 | 5772 | 109 |
713422 | 713422 | 2020-11-09 | Rock Island | Illinois | 17161 | 5636 | 109 |
710178 | 710178 | 2020-11-08 | Rock Island | Illinois | 17161 | 5503 | 109 |
706934 | 706934 | 2020-11-07 | Rock Island | Illinois | 17161 | 5366 | 109 |
703691 | 703691 | 2020-11-06 | Rock Island | Illinois | 17161 | 5217 | 109 |
700448 | 700448 | 2020-11-05 | Rock Island | Illinois | 17161 | 5089 | 108 |
697204 | 697204 | 2020-11-04 | Rock Island | Illinois | 17161 | 4940 | 106 |
693962 | 693962 | 2020-11-03 | Rock Island | Illinois | 17161 | 4833 | 105 |
690719 | 690719 | 2020-11-02 | Rock Island | Illinois | 17161 | 4757 | 104 |
687474 | 687474 | 2020-11-01 | Rock Island | Illinois | 17161 | 4674 | 103 |
684230 | 684230 | 2020-10-31 | Rock Island | Illinois | 17161 | 4609 | 103 |
680987 | 680987 | 2020-10-30 | Rock Island | Illinois | 17161 | 4477 | 102 |
677744 | 677744 | 2020-10-29 | Rock Island | Illinois | 17161 | 4364 | 101 |
674501 | 674501 | 2020-10-28 | Rock Island | Illinois | 17161 | 4297 | 101 |
671259 | 671259 | 2020-10-27 | Rock Island | Illinois | 17161 | 4251 | 101 |
668016 | 668016 | 2020-10-26 | Rock Island | Illinois | 17161 | 4197 | 100 |
664772 | 664772 | 2020-10-25 | Rock Island | Illinois | 17161 | 4132 | 100 |
661527 | 661527 | 2020-10-24 | Rock Island | Illinois | 17161 | 4082 | 99 |
658283 | 658283 | 2020-10-23 | Rock Island | Illinois | 17161 | 4017 | 99 |
655038 | 655038 | 2020-10-22 | Rock Island | Illinois | 17161 | 3939 | 98 |
651793 | 651793 | 2020-10-21 | Rock Island | Illinois | 17161 | 3886 | 97 |
648549 | 648549 | 2020-10-20 | Rock Island | Illinois | 17161 | 3837 | 97 |
645304 | 645304 | 2020-10-19 | Rock Island | Illinois | 17161 | 3788 | 97 |
642057 | 642057 | 2020-10-18 | Rock Island | Illinois | 17161 | 3756 | 97 |
638810 | 638810 | 2020-10-17 | Rock Island | Illinois | 17161 | 3698 | 97 |
635564 | 635564 | 2020-10-16 | Rock Island | Illinois | 17161 | 3653 | 97 |
632318 | 632318 | 2020-10-15 | Rock Island | Illinois | 17161 | 3602 | 96 |
629074 | 629074 | 2020-10-14 | Rock Island | Illinois | 17161 | 3567 | 93 |
625831 | 625831 | 2020-10-13 | Rock Island | Illinois | 17161 | 3521 | 93 |
622589 | 622589 | 2020-10-12 | Rock Island | Illinois | 17161 | 3489 | 90 |
619345 | 619345 | 2020-10-11 | Rock Island | Illinois | 17161 | 3464 | 89 |
616103 | 616103 | 2020-10-10 | Rock Island | Illinois | 17161 | 3442 | 89 |
612862 | 612862 | 2020-10-09 | Rock Island | Illinois | 17161 | 3415 | 89 |
609620 | 609620 | 2020-10-08 | Rock Island | Illinois | 17161 | 3380 | 88 |
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);