ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Stephenson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193797 | 1193797 | 2021-04-06 | Stephenson | Illinois | 17177 | 4346 | 98 |
1190547 | 1190547 | 2021-04-05 | Stephenson | Illinois | 17177 | 4342 | 98 |
1187300 | 1187300 | 2021-04-04 | Stephenson | Illinois | 17177 | 4331 | 98 |
1184053 | 1184053 | 2021-04-03 | Stephenson | Illinois | 17177 | 4322 | 98 |
1180806 | 1180806 | 2021-04-02 | Stephenson | Illinois | 17177 | 4305 | 98 |
1177559 | 1177559 | 2021-04-01 | Stephenson | Illinois | 17177 | 4291 | 98 |
1174312 | 1174312 | 2021-03-31 | Stephenson | Illinois | 17177 | 4279 | 98 |
1171065 | 1171065 | 2021-03-30 | Stephenson | Illinois | 17177 | 4261 | 98 |
1167817 | 1167817 | 2021-03-29 | Stephenson | Illinois | 17177 | 4259 | 98 |
1164569 | 1164569 | 2021-03-28 | Stephenson | Illinois | 17177 | 4256 | 98 |
1161321 | 1161321 | 2021-03-27 | Stephenson | Illinois | 17177 | 4250 | 98 |
1158073 | 1158073 | 2021-03-26 | Stephenson | Illinois | 17177 | 4239 | 98 |
1154826 | 1154826 | 2021-03-25 | Stephenson | Illinois | 17177 | 4226 | 98 |
1151579 | 1151579 | 2021-03-24 | Stephenson | Illinois | 17177 | 4221 | 98 |
1148332 | 1148332 | 2021-03-23 | Stephenson | Illinois | 17177 | 4212 | 97 |
1145085 | 1145085 | 2021-03-22 | Stephenson | Illinois | 17177 | 4212 | 97 |
1141838 | 1141838 | 2021-03-21 | Stephenson | Illinois | 17177 | 4212 | 97 |
1138592 | 1138592 | 2021-03-20 | Stephenson | Illinois | 17177 | 4207 | 97 |
1135346 | 1135346 | 2021-03-19 | Stephenson | Illinois | 17177 | 4204 | 97 |
1132099 | 1132099 | 2021-03-18 | Stephenson | Illinois | 17177 | 4197 | 97 |
1128851 | 1128851 | 2021-03-17 | Stephenson | Illinois | 17177 | 4191 | 97 |
1125605 | 1125605 | 2021-03-16 | Stephenson | Illinois | 17177 | 4190 | 97 |
1122359 | 1122359 | 2021-03-15 | Stephenson | Illinois | 17177 | 4180 | 97 |
1119112 | 1119112 | 2021-03-14 | Stephenson | Illinois | 17177 | 4172 | 97 |
1115865 | 1115865 | 2021-03-13 | Stephenson | Illinois | 17177 | 4165 | 97 |
1112619 | 1112619 | 2021-03-12 | Stephenson | Illinois | 17177 | 4150 | 97 |
1109373 | 1109373 | 2021-03-11 | Stephenson | Illinois | 17177 | 4144 | 96 |
1106127 | 1106127 | 2021-03-10 | Stephenson | Illinois | 17177 | 4139 | 96 |
1102881 | 1102881 | 2021-03-09 | Stephenson | Illinois | 17177 | 4132 | 95 |
1099635 | 1099635 | 2021-03-08 | Stephenson | Illinois | 17177 | 4127 | 95 |
1096387 | 1096387 | 2021-03-07 | Stephenson | Illinois | 17177 | 4122 | 95 |
1093141 | 1093141 | 2021-03-06 | Stephenson | Illinois | 17177 | 4115 | 95 |
1089895 | 1089895 | 2021-03-05 | Stephenson | Illinois | 17177 | 4111 | 95 |
1086650 | 1086650 | 2021-03-04 | Stephenson | Illinois | 17177 | 4102 | 95 |
1083404 | 1083404 | 2021-03-03 | Stephenson | Illinois | 17177 | 4100 | 94 |
1080158 | 1080158 | 2021-03-02 | Stephenson | Illinois | 17177 | 4098 | 94 |
1076913 | 1076913 | 2021-03-01 | Stephenson | Illinois | 17177 | 4098 | 94 |
1073667 | 1073667 | 2021-02-28 | Stephenson | Illinois | 17177 | 4096 | 94 |
1070421 | 1070421 | 2021-02-27 | Stephenson | Illinois | 17177 | 4092 | 94 |
1067176 | 1067176 | 2021-02-26 | Stephenson | Illinois | 17177 | 4085 | 94 |
1063931 | 1063931 | 2021-02-25 | Stephenson | Illinois | 17177 | 4078 | 94 |
1060686 | 1060686 | 2021-02-24 | Stephenson | Illinois | 17177 | 4071 | 94 |
1057440 | 1057440 | 2021-02-23 | Stephenson | Illinois | 17177 | 4062 | 92 |
1054194 | 1054194 | 2021-02-22 | Stephenson | Illinois | 17177 | 4052 | 92 |
1050947 | 1050947 | 2021-02-21 | Stephenson | Illinois | 17177 | 4047 | 92 |
1047700 | 1047700 | 2021-02-20 | Stephenson | Illinois | 17177 | 4044 | 92 |
1044455 | 1044455 | 2021-02-19 | Stephenson | Illinois | 17177 | 4032 | 92 |
1041210 | 1041210 | 2021-02-18 | Stephenson | Illinois | 17177 | 4016 | 91 |
1037965 | 1037965 | 2021-02-17 | Stephenson | Illinois | 17177 | 4005 | 90 |
1034720 | 1034720 | 2021-02-16 | Stephenson | Illinois | 17177 | 3981 | 90 |
1031474 | 1031474 | 2021-02-15 | Stephenson | Illinois | 17177 | 3977 | 90 |
1028227 | 1028227 | 2021-02-14 | Stephenson | Illinois | 17177 | 3973 | 90 |
1024982 | 1024982 | 2021-02-13 | Stephenson | Illinois | 17177 | 3969 | 90 |
1021737 | 1021737 | 2021-02-12 | Stephenson | Illinois | 17177 | 3953 | 88 |
1018492 | 1018492 | 2021-02-11 | Stephenson | Illinois | 17177 | 3935 | 88 |
1015247 | 1015247 | 2021-02-10 | Stephenson | Illinois | 17177 | 3913 | 87 |
1012002 | 1012002 | 2021-02-09 | Stephenson | Illinois | 17177 | 3876 | 86 |
1008756 | 1008756 | 2021-02-08 | Stephenson | Illinois | 17177 | 3832 | 86 |
1005510 | 1005510 | 2021-02-07 | Stephenson | Illinois | 17177 | 3824 | 86 |
1002264 | 1002264 | 2021-02-06 | Stephenson | Illinois | 17177 | 3817 | 85 |
999018 | 999018 | 2021-02-05 | Stephenson | Illinois | 17177 | 3806 | 84 |
995772 | 995772 | 2021-02-04 | Stephenson | Illinois | 17177 | 3793 | 84 |
992526 | 992526 | 2021-02-03 | Stephenson | Illinois | 17177 | 3783 | 84 |
989280 | 989280 | 2021-02-02 | Stephenson | Illinois | 17177 | 3764 | 84 |
986033 | 986033 | 2021-02-01 | Stephenson | Illinois | 17177 | 3759 | 83 |
982786 | 982786 | 2021-01-31 | Stephenson | Illinois | 17177 | 3750 | 82 |
979540 | 979540 | 2021-01-30 | Stephenson | Illinois | 17177 | 3739 | 82 |
976295 | 976295 | 2021-01-29 | Stephenson | Illinois | 17177 | 3727 | 82 |
973050 | 973050 | 2021-01-28 | Stephenson | Illinois | 17177 | 3702 | 80 |
969805 | 969805 | 2021-01-27 | Stephenson | Illinois | 17177 | 3687 | 78 |
966561 | 966561 | 2021-01-26 | Stephenson | Illinois | 17177 | 3654 | 77 |
963316 | 963316 | 2021-01-25 | Stephenson | Illinois | 17177 | 3646 | 77 |
960071 | 960071 | 2021-01-24 | Stephenson | Illinois | 17177 | 3639 | 77 |
956825 | 956825 | 2021-01-23 | Stephenson | Illinois | 17177 | 3618 | 77 |
953580 | 953580 | 2021-01-22 | Stephenson | Illinois | 17177 | 3601 | 77 |
950335 | 950335 | 2021-01-21 | Stephenson | Illinois | 17177 | 3567 | 77 |
947089 | 947089 | 2021-01-20 | Stephenson | Illinois | 17177 | 3547 | 77 |
943842 | 943842 | 2021-01-19 | Stephenson | Illinois | 17177 | 3532 | 74 |
940597 | 940597 | 2021-01-18 | Stephenson | Illinois | 17177 | 3524 | 74 |
937352 | 937352 | 2021-01-17 | Stephenson | Illinois | 17177 | 3499 | 74 |
934107 | 934107 | 2021-01-16 | Stephenson | Illinois | 17177 | 3495 | 74 |
930862 | 930862 | 2021-01-15 | Stephenson | Illinois | 17177 | 3488 | 74 |
927617 | 927617 | 2021-01-14 | Stephenson | Illinois | 17177 | 3467 | 74 |
924371 | 924371 | 2021-01-13 | Stephenson | Illinois | 17177 | 3441 | 74 |
921126 | 921126 | 2021-01-12 | Stephenson | Illinois | 17177 | 3428 | 73 |
917881 | 917881 | 2021-01-11 | Stephenson | Illinois | 17177 | 3418 | 72 |
914636 | 914636 | 2021-01-10 | Stephenson | Illinois | 17177 | 3408 | 72 |
911391 | 911391 | 2021-01-09 | Stephenson | Illinois | 17177 | 3390 | 72 |
908146 | 908146 | 2021-01-08 | Stephenson | Illinois | 17177 | 3367 | 71 |
904900 | 904900 | 2021-01-07 | Stephenson | Illinois | 17177 | 3344 | 69 |
901655 | 901655 | 2021-01-06 | Stephenson | Illinois | 17177 | 3325 | 68 |
898410 | 898410 | 2021-01-05 | Stephenson | Illinois | 17177 | 3305 | 67 |
895165 | 895165 | 2021-01-04 | Stephenson | Illinois | 17177 | 3296 | 67 |
891918 | 891918 | 2021-01-03 | Stephenson | Illinois | 17177 | 3282 | 66 |
888671 | 888671 | 2021-01-02 | Stephenson | Illinois | 17177 | 3276 | 64 |
885426 | 885426 | 2021-01-01 | Stephenson | Illinois | 17177 | 3242 | 62 |
882181 | 882181 | 2020-12-31 | Stephenson | Illinois | 17177 | 3242 | 62 |
878936 | 878936 | 2020-12-30 | Stephenson | Illinois | 17177 | 3215 | 60 |
875691 | 875691 | 2020-12-29 | Stephenson | Illinois | 17177 | 3205 | 58 |
872446 | 872446 | 2020-12-28 | Stephenson | Illinois | 17177 | 3179 | 58 |
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);