ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 22009 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1392290 | 1392290 | 2021-06-06 | Avoyelles | Louisiana | 22009 | 4311 | 123 |
1389045 | 1389045 | 2021-06-05 | Avoyelles | Louisiana | 22009 | 4311 | 123 |
1385800 | 1385800 | 2021-06-04 | Avoyelles | Louisiana | 22009 | 4311 | 123 |
1382554 | 1382554 | 2021-06-03 | Avoyelles | Louisiana | 22009 | 4306 | 123 |
1379309 | 1379309 | 2021-06-02 | Avoyelles | Louisiana | 22009 | 4302 | 123 |
1376063 | 1376063 | 2021-06-01 | Avoyelles | Louisiana | 22009 | 4298 | 123 |
1372818 | 1372818 | 2021-05-31 | Avoyelles | Louisiana | 22009 | 4283 | 123 |
1369573 | 1369573 | 2021-05-30 | Avoyelles | Louisiana | 22009 | 4283 | 123 |
1366327 | 1366327 | 2021-05-29 | Avoyelles | Louisiana | 22009 | 4283 | 123 |
1363081 | 1363081 | 2021-05-28 | Avoyelles | Louisiana | 22009 | 4283 | 123 |
1359834 | 1359834 | 2021-05-27 | Avoyelles | Louisiana | 22009 | 4282 | 123 |
1356588 | 1356588 | 2021-05-26 | Avoyelles | Louisiana | 22009 | 4272 | 123 |
1353342 | 1353342 | 2021-05-25 | Avoyelles | Louisiana | 22009 | 4266 | 123 |
1350096 | 1350096 | 2021-05-24 | Avoyelles | Louisiana | 22009 | 4253 | 123 |
1346849 | 1346849 | 2021-05-23 | Avoyelles | Louisiana | 22009 | 4246 | 123 |
1343601 | 1343601 | 2021-05-22 | Avoyelles | Louisiana | 22009 | 4246 | 123 |
1340353 | 1340353 | 2021-05-21 | Avoyelles | Louisiana | 22009 | 4246 | 123 |
1337106 | 1337106 | 2021-05-20 | Avoyelles | Louisiana | 22009 | 4246 | 123 |
1333859 | 1333859 | 2021-05-19 | Avoyelles | Louisiana | 22009 | 4243 | 123 |
1330612 | 1330612 | 2021-05-18 | Avoyelles | Louisiana | 22009 | 4240 | 123 |
1327365 | 1327365 | 2021-05-17 | Avoyelles | Louisiana | 22009 | 4233 | 123 |
1324119 | 1324119 | 2021-05-16 | Avoyelles | Louisiana | 22009 | 4226 | 123 |
1320873 | 1320873 | 2021-05-15 | Avoyelles | Louisiana | 22009 | 4226 | 123 |
1317626 | 1317626 | 2021-05-14 | Avoyelles | Louisiana | 22009 | 4226 | 123 |
1314379 | 1314379 | 2021-05-13 | Avoyelles | Louisiana | 22009 | 4222 | 123 |
1311132 | 1311132 | 2021-05-12 | Avoyelles | Louisiana | 22009 | 4227 | 123 |
1307886 | 1307886 | 2021-05-11 | Avoyelles | Louisiana | 22009 | 4215 | 123 |
1304640 | 1304640 | 2021-05-10 | Avoyelles | Louisiana | 22009 | 4213 | 123 |
1301393 | 1301393 | 2021-05-09 | Avoyelles | Louisiana | 22009 | 4208 | 123 |
1298146 | 1298146 | 2021-05-08 | Avoyelles | Louisiana | 22009 | 4208 | 123 |
1294900 | 1294900 | 2021-05-07 | Avoyelles | Louisiana | 22009 | 4208 | 123 |
1291654 | 1291654 | 2021-05-06 | Avoyelles | Louisiana | 22009 | 4196 | 123 |
1288408 | 1288408 | 2021-05-05 | Avoyelles | Louisiana | 22009 | 4197 | 123 |
1285162 | 1285162 | 2021-05-04 | Avoyelles | Louisiana | 22009 | 4190 | 123 |
1281915 | 1281915 | 2021-05-03 | Avoyelles | Louisiana | 22009 | 4183 | 123 |
1278668 | 1278668 | 2021-05-02 | Avoyelles | Louisiana | 22009 | 4178 | 123 |
1275421 | 1275421 | 2021-05-01 | Avoyelles | Louisiana | 22009 | 4178 | 123 |
1272174 | 1272174 | 2021-04-30 | Avoyelles | Louisiana | 22009 | 4178 | 123 |
1268927 | 1268927 | 2021-04-29 | Avoyelles | Louisiana | 22009 | 4175 | 123 |
1265680 | 1265680 | 2021-04-28 | Avoyelles | Louisiana | 22009 | 4161 | 123 |
1262433 | 1262433 | 2021-04-27 | Avoyelles | Louisiana | 22009 | 4165 | 123 |
1259186 | 1259186 | 2021-04-26 | Avoyelles | Louisiana | 22009 | 4153 | 123 |
1255939 | 1255939 | 2021-04-25 | Avoyelles | Louisiana | 22009 | 4141 | 123 |
1252692 | 1252692 | 2021-04-24 | Avoyelles | Louisiana | 22009 | 4141 | 123 |
1249445 | 1249445 | 2021-04-23 | Avoyelles | Louisiana | 22009 | 4141 | 123 |
1246198 | 1246198 | 2021-04-22 | Avoyelles | Louisiana | 22009 | 4133 | 123 |
1242951 | 1242951 | 2021-04-21 | Avoyelles | Louisiana | 22009 | 4128 | 123 |
1239704 | 1239704 | 2021-04-20 | Avoyelles | Louisiana | 22009 | 4121 | 123 |
1236457 | 1236457 | 2021-04-19 | Avoyelles | Louisiana | 22009 | 4126 | 122 |
1233210 | 1233210 | 2021-04-18 | Avoyelles | Louisiana | 22009 | 4045 | 122 |
1229962 | 1229962 | 2021-04-17 | Avoyelles | Louisiana | 22009 | 4045 | 122 |
1226714 | 1226714 | 2021-04-16 | Avoyelles | Louisiana | 22009 | 4045 | 122 |
1223467 | 1223467 | 2021-04-15 | Avoyelles | Louisiana | 22009 | 4044 | 122 |
1220219 | 1220219 | 2021-04-14 | Avoyelles | Louisiana | 22009 | 4042 | 122 |
1216971 | 1216971 | 2021-04-13 | Avoyelles | Louisiana | 22009 | 4040 | 122 |
1213724 | 1213724 | 2021-04-12 | Avoyelles | Louisiana | 22009 | 4027 | 122 |
1210476 | 1210476 | 2021-04-11 | Avoyelles | Louisiana | 22009 | 4027 | 122 |
1207227 | 1207227 | 2021-04-10 | Avoyelles | Louisiana | 22009 | 4027 | 122 |
1203979 | 1203979 | 2021-04-09 | Avoyelles | Louisiana | 22009 | 4027 | 122 |
1200731 | 1200731 | 2021-04-08 | Avoyelles | Louisiana | 22009 | 4018 | 122 |
1197482 | 1197482 | 2021-04-07 | Avoyelles | Louisiana | 22009 | 4014 | 122 |
1194234 | 1194234 | 2021-04-06 | Avoyelles | Louisiana | 22009 | 4013 | 122 |
1190984 | 1190984 | 2021-04-05 | Avoyelles | Louisiana | 22009 | 4009 | 121 |
1187737 | 1187737 | 2021-04-04 | Avoyelles | Louisiana | 22009 | 4005 | 121 |
1184490 | 1184490 | 2021-04-03 | Avoyelles | Louisiana | 22009 | 4005 | 121 |
1181243 | 1181243 | 2021-04-02 | Avoyelles | Louisiana | 22009 | 4005 | 121 |
1177996 | 1177996 | 2021-04-01 | Avoyelles | Louisiana | 22009 | 4005 | 121 |
1174749 | 1174749 | 2021-03-31 | Avoyelles | Louisiana | 22009 | 3997 | 121 |
1171502 | 1171502 | 2021-03-30 | Avoyelles | Louisiana | 22009 | 3998 | 121 |
1168254 | 1168254 | 2021-03-29 | Avoyelles | Louisiana | 22009 | 3991 | 121 |
1165006 | 1165006 | 2021-03-28 | Avoyelles | Louisiana | 22009 | 3988 | 121 |
1161758 | 1161758 | 2021-03-27 | Avoyelles | Louisiana | 22009 | 3988 | 121 |
1158510 | 1158510 | 2021-03-26 | Avoyelles | Louisiana | 22009 | 3988 | 121 |
1155263 | 1155263 | 2021-03-25 | Avoyelles | Louisiana | 22009 | 3987 | 121 |
1152016 | 1152016 | 2021-03-24 | Avoyelles | Louisiana | 22009 | 3987 | 121 |
1148769 | 1148769 | 2021-03-23 | Avoyelles | Louisiana | 22009 | 3982 | 121 |
1145522 | 1145522 | 2021-03-22 | Avoyelles | Louisiana | 22009 | 3981 | 121 |
1142275 | 1142275 | 2021-03-21 | Avoyelles | Louisiana | 22009 | 3973 | 121 |
1139029 | 1139029 | 2021-03-20 | Avoyelles | Louisiana | 22009 | 3973 | 121 |
1135783 | 1135783 | 2021-03-19 | Avoyelles | Louisiana | 22009 | 3973 | 121 |
1132536 | 1132536 | 2021-03-18 | Avoyelles | Louisiana | 22009 | 3974 | 121 |
1129288 | 1129288 | 2021-03-17 | Avoyelles | Louisiana | 22009 | 3969 | 119 |
1126042 | 1126042 | 2021-03-16 | Avoyelles | Louisiana | 22009 | 3971 | 119 |
1122796 | 1122796 | 2021-03-15 | Avoyelles | Louisiana | 22009 | 3971 | 119 |
1119549 | 1119549 | 2021-03-14 | Avoyelles | Louisiana | 22009 | 3969 | 119 |
1116302 | 1116302 | 2021-03-13 | Avoyelles | Louisiana | 22009 | 3966 | 118 |
1113056 | 1113056 | 2021-03-12 | Avoyelles | Louisiana | 22009 | 3966 | 118 |
1109810 | 1109810 | 2021-03-11 | Avoyelles | Louisiana | 22009 | 3955 | 118 |
1106564 | 1106564 | 2021-03-10 | Avoyelles | Louisiana | 22009 | 3956 | 118 |
1103318 | 1103318 | 2021-03-09 | Avoyelles | Louisiana | 22009 | 3957 | 118 |
1100072 | 1100072 | 2021-03-08 | Avoyelles | Louisiana | 22009 | 3948 | 118 |
1096824 | 1096824 | 2021-03-07 | Avoyelles | Louisiana | 22009 | 3948 | 118 |
1093578 | 1093578 | 2021-03-06 | Avoyelles | Louisiana | 22009 | 3942 | 118 |
1090332 | 1090332 | 2021-03-05 | Avoyelles | Louisiana | 22009 | 3942 | 118 |
1087087 | 1087087 | 2021-03-04 | Avoyelles | Louisiana | 22009 | 3938 | 118 |
1083841 | 1083841 | 2021-03-03 | Avoyelles | Louisiana | 22009 | 3932 | 118 |
1080595 | 1080595 | 2021-03-02 | Avoyelles | Louisiana | 22009 | 3935 | 118 |
1077350 | 1077350 | 2021-03-01 | Avoyelles | Louisiana | 22009 | 3932 | 118 |
1074104 | 1074104 | 2021-02-28 | Avoyelles | Louisiana | 22009 | 3924 | 117 |
1070858 | 1070858 | 2021-02-27 | Avoyelles | Louisiana | 22009 | 3896 | 117 |
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);