ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marion" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1174281 | 1174281 | 2021-03-31 | Marion | Illinois | 17121 | 4364 | 120 |
1171034 | 1171034 | 2021-03-30 | Marion | Illinois | 17121 | 4359 | 120 |
1167786 | 1167786 | 2021-03-29 | Marion | Illinois | 17121 | 4355 | 120 |
1164538 | 1164538 | 2021-03-28 | Marion | Illinois | 17121 | 4354 | 120 |
1161290 | 1161290 | 2021-03-27 | Marion | Illinois | 17121 | 4351 | 120 |
1158042 | 1158042 | 2021-03-26 | Marion | Illinois | 17121 | 4347 | 120 |
1154795 | 1154795 | 2021-03-25 | Marion | Illinois | 17121 | 4347 | 120 |
1151548 | 1151548 | 2021-03-24 | Marion | Illinois | 17121 | 4342 | 119 |
1148301 | 1148301 | 2021-03-23 | Marion | Illinois | 17121 | 4333 | 119 |
1145054 | 1145054 | 2021-03-22 | Marion | Illinois | 17121 | 4326 | 119 |
1141807 | 1141807 | 2021-03-21 | Marion | Illinois | 17121 | 4326 | 119 |
1138561 | 1138561 | 2021-03-20 | Marion | Illinois | 17121 | 4322 | 119 |
1135315 | 1135315 | 2021-03-19 | Marion | Illinois | 17121 | 4313 | 119 |
1132068 | 1132068 | 2021-03-18 | Marion | Illinois | 17121 | 4312 | 119 |
1128820 | 1128820 | 2021-03-17 | Marion | Illinois | 17121 | 4305 | 119 |
1125574 | 1125574 | 2021-03-16 | Marion | Illinois | 17121 | 4298 | 119 |
1122328 | 1122328 | 2021-03-15 | Marion | Illinois | 17121 | 4296 | 119 |
1119081 | 1119081 | 2021-03-14 | Marion | Illinois | 17121 | 4297 | 119 |
1115834 | 1115834 | 2021-03-13 | Marion | Illinois | 17121 | 4296 | 119 |
1112588 | 1112588 | 2021-03-12 | Marion | Illinois | 17121 | 4294 | 119 |
1109342 | 1109342 | 2021-03-11 | Marion | Illinois | 17121 | 4290 | 119 |
1106096 | 1106096 | 2021-03-10 | Marion | Illinois | 17121 | 4291 | 119 |
1102850 | 1102850 | 2021-03-09 | Marion | Illinois | 17121 | 4283 | 119 |
1099604 | 1099604 | 2021-03-08 | Marion | Illinois | 17121 | 4282 | 119 |
1096356 | 1096356 | 2021-03-07 | Marion | Illinois | 17121 | 4280 | 119 |
1093110 | 1093110 | 2021-03-06 | Marion | Illinois | 17121 | 4276 | 119 |
1089864 | 1089864 | 2021-03-05 | Marion | Illinois | 17121 | 4272 | 118 |
1086619 | 1086619 | 2021-03-04 | Marion | Illinois | 17121 | 4270 | 118 |
1083373 | 1083373 | 2021-03-03 | Marion | Illinois | 17121 | 4268 | 118 |
1080127 | 1080127 | 2021-03-02 | Marion | Illinois | 17121 | 4261 | 117 |
1076882 | 1076882 | 2021-03-01 | Marion | Illinois | 17121 | 4262 | 117 |
1073636 | 1073636 | 2021-02-28 | Marion | Illinois | 17121 | 4262 | 117 |
1070390 | 1070390 | 2021-02-27 | Marion | Illinois | 17121 | 4262 | 117 |
1067145 | 1067145 | 2021-02-26 | Marion | Illinois | 17121 | 4257 | 117 |
1063900 | 1063900 | 2021-02-25 | Marion | Illinois | 17121 | 4255 | 117 |
1060655 | 1060655 | 2021-02-24 | Marion | Illinois | 17121 | 4253 | 117 |
1057409 | 1057409 | 2021-02-23 | Marion | Illinois | 17121 | 4253 | 117 |
1054163 | 1054163 | 2021-02-22 | Marion | Illinois | 17121 | 4249 | 116 |
1050916 | 1050916 | 2021-02-21 | Marion | Illinois | 17121 | 4244 | 116 |
1047669 | 1047669 | 2021-02-20 | Marion | Illinois | 17121 | 4240 | 116 |
1044424 | 1044424 | 2021-02-19 | Marion | Illinois | 17121 | 4237 | 116 |
1041179 | 1041179 | 2021-02-18 | Marion | Illinois | 17121 | 4235 | 116 |
1037934 | 1037934 | 2021-02-17 | Marion | Illinois | 17121 | 4236 | 116 |
1034689 | 1034689 | 2021-02-16 | Marion | Illinois | 17121 | 4236 | 116 |
1031443 | 1031443 | 2021-02-15 | Marion | Illinois | 17121 | 4227 | 116 |
1028196 | 1028196 | 2021-02-14 | Marion | Illinois | 17121 | 4225 | 116 |
1024951 | 1024951 | 2021-02-13 | Marion | Illinois | 17121 | 4225 | 116 |
1021706 | 1021706 | 2021-02-12 | Marion | Illinois | 17121 | 4223 | 116 |
1018461 | 1018461 | 2021-02-11 | Marion | Illinois | 17121 | 4219 | 116 |
1015216 | 1015216 | 2021-02-10 | Marion | Illinois | 17121 | 4224 | 115 |
1011971 | 1011971 | 2021-02-09 | Marion | Illinois | 17121 | 4220 | 115 |
1008725 | 1008725 | 2021-02-08 | Marion | Illinois | 17121 | 4214 | 115 |
1005479 | 1005479 | 2021-02-07 | Marion | Illinois | 17121 | 4211 | 115 |
1002233 | 1002233 | 2021-02-06 | Marion | Illinois | 17121 | 4209 | 114 |
998987 | 998987 | 2021-02-05 | Marion | Illinois | 17121 | 4207 | 114 |
995741 | 995741 | 2021-02-04 | Marion | Illinois | 17121 | 4201 | 114 |
992495 | 992495 | 2021-02-03 | Marion | Illinois | 17121 | 4207 | 114 |
989249 | 989249 | 2021-02-02 | Marion | Illinois | 17121 | 4187 | 114 |
986002 | 986002 | 2021-02-01 | Marion | Illinois | 17121 | 4181 | 114 |
982755 | 982755 | 2021-01-31 | Marion | Illinois | 17121 | 4178 | 113 |
979509 | 979509 | 2021-01-30 | Marion | Illinois | 17121 | 4173 | 113 |
976264 | 976264 | 2021-01-29 | Marion | Illinois | 17121 | 4165 | 113 |
973019 | 973019 | 2021-01-28 | Marion | Illinois | 17121 | 4152 | 113 |
969774 | 969774 | 2021-01-27 | Marion | Illinois | 17121 | 4131 | 113 |
966530 | 966530 | 2021-01-26 | Marion | Illinois | 17121 | 4115 | 113 |
963285 | 963285 | 2021-01-25 | Marion | Illinois | 17121 | 4093 | 113 |
960040 | 960040 | 2021-01-24 | Marion | Illinois | 17121 | 4081 | 113 |
956794 | 956794 | 2021-01-23 | Marion | Illinois | 17121 | 4063 | 113 |
953549 | 953549 | 2021-01-22 | Marion | Illinois | 17121 | 4051 | 113 |
950304 | 950304 | 2021-01-21 | Marion | Illinois | 17121 | 4026 | 113 |
947058 | 947058 | 2021-01-20 | Marion | Illinois | 17121 | 4024 | 112 |
943811 | 943811 | 2021-01-19 | Marion | Illinois | 17121 | 3994 | 112 |
940566 | 940566 | 2021-01-18 | Marion | Illinois | 17121 | 3970 | 111 |
937321 | 937321 | 2021-01-17 | Marion | Illinois | 17121 | 3958 | 111 |
934076 | 934076 | 2021-01-16 | Marion | Illinois | 17121 | 3938 | 111 |
930831 | 930831 | 2021-01-15 | Marion | Illinois | 17121 | 3923 | 111 |
927586 | 927586 | 2021-01-14 | Marion | Illinois | 17121 | 3896 | 111 |
924340 | 924340 | 2021-01-13 | Marion | Illinois | 17121 | 3886 | 111 |
921095 | 921095 | 2021-01-12 | Marion | Illinois | 17121 | 3857 | 111 |
917850 | 917850 | 2021-01-11 | Marion | Illinois | 17121 | 3843 | 110 |
914605 | 914605 | 2021-01-10 | Marion | Illinois | 17121 | 3829 | 111 |
911360 | 911360 | 2021-01-09 | Marion | Illinois | 17121 | 3766 | 111 |
908115 | 908115 | 2021-01-08 | Marion | Illinois | 17121 | 3746 | 111 |
904869 | 904869 | 2021-01-07 | Marion | Illinois | 17121 | 3702 | 109 |
901624 | 901624 | 2021-01-06 | Marion | Illinois | 17121 | 3677 | 107 |
898379 | 898379 | 2021-01-05 | Marion | Illinois | 17121 | 3639 | 105 |
895134 | 895134 | 2021-01-04 | Marion | Illinois | 17121 | 3611 | 104 |
891887 | 891887 | 2021-01-03 | Marion | Illinois | 17121 | 3600 | 104 |
888640 | 888640 | 2021-01-02 | Marion | Illinois | 17121 | 3575 | 103 |
885395 | 885395 | 2021-01-01 | Marion | Illinois | 17121 | 3548 | 103 |
882150 | 882150 | 2020-12-31 | Marion | Illinois | 17121 | 3548 | 103 |
878905 | 878905 | 2020-12-30 | Marion | Illinois | 17121 | 3525 | 103 |
875660 | 875660 | 2020-12-29 | Marion | Illinois | 17121 | 3492 | 103 |
872415 | 872415 | 2020-12-28 | Marion | Illinois | 17121 | 3454 | 102 |
869170 | 869170 | 2020-12-27 | Marion | Illinois | 17121 | 3445 | 101 |
865925 | 865925 | 2020-12-26 | Marion | Illinois | 17121 | 3439 | 101 |
862680 | 862680 | 2020-12-25 | Marion | Illinois | 17121 | 3430 | 101 |
859435 | 859435 | 2020-12-24 | Marion | Illinois | 17121 | 3401 | 101 |
856190 | 856190 | 2020-12-23 | Marion | Illinois | 17121 | 3359 | 99 |
852945 | 852945 | 2020-12-22 | Marion | Illinois | 17121 | 3330 | 97 |
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);