ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lincoln" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418280 | 1418280 | 2021-06-14 | Lincoln | Louisiana | 22061 | 4631 | 93 |
1415034 | 1415034 | 2021-06-13 | Lincoln | Louisiana | 22061 | 4631 | 93 |
1411789 | 1411789 | 2021-06-12 | Lincoln | Louisiana | 22061 | 4631 | 93 |
1408544 | 1408544 | 2021-06-11 | Lincoln | Louisiana | 22061 | 4631 | 93 |
1405298 | 1405298 | 2021-06-10 | Lincoln | Louisiana | 22061 | 4631 | 93 |
1402053 | 1402053 | 2021-06-09 | Lincoln | Louisiana | 22061 | 4627 | 93 |
1398808 | 1398808 | 2021-06-08 | Lincoln | Louisiana | 22061 | 4604 | 93 |
1395561 | 1395561 | 2021-06-07 | Lincoln | Louisiana | 22061 | 4619 | 93 |
1392316 | 1392316 | 2021-06-06 | Lincoln | Louisiana | 22061 | 4604 | 93 |
1389071 | 1389071 | 2021-06-05 | Lincoln | Louisiana | 22061 | 4604 | 93 |
1385826 | 1385826 | 2021-06-04 | Lincoln | Louisiana | 22061 | 4604 | 93 |
1382580 | 1382580 | 2021-06-03 | Lincoln | Louisiana | 22061 | 4601 | 93 |
1379335 | 1379335 | 2021-06-02 | Lincoln | Louisiana | 22061 | 4602 | 93 |
1376089 | 1376089 | 2021-06-01 | Lincoln | Louisiana | 22061 | 4591 | 93 |
1372844 | 1372844 | 2021-05-31 | Lincoln | Louisiana | 22061 | 4581 | 93 |
1369599 | 1369599 | 2021-05-30 | Lincoln | Louisiana | 22061 | 4581 | 93 |
1366353 | 1366353 | 2021-05-29 | Lincoln | Louisiana | 22061 | 4581 | 93 |
1363107 | 1363107 | 2021-05-28 | Lincoln | Louisiana | 22061 | 4581 | 93 |
1359860 | 1359860 | 2021-05-27 | Lincoln | Louisiana | 22061 | 4575 | 93 |
1356614 | 1356614 | 2021-05-26 | Lincoln | Louisiana | 22061 | 4579 | 93 |
1353368 | 1353368 | 2021-05-25 | Lincoln | Louisiana | 22061 | 4571 | 93 |
1350122 | 1350122 | 2021-05-24 | Lincoln | Louisiana | 22061 | 4574 | 93 |
1346875 | 1346875 | 2021-05-23 | Lincoln | Louisiana | 22061 | 4558 | 93 |
1343627 | 1343627 | 2021-05-22 | Lincoln | Louisiana | 22061 | 4558 | 93 |
1340379 | 1340379 | 2021-05-21 | Lincoln | Louisiana | 22061 | 4558 | 93 |
1337132 | 1337132 | 2021-05-20 | Lincoln | Louisiana | 22061 | 4561 | 93 |
1333885 | 1333885 | 2021-05-19 | Lincoln | Louisiana | 22061 | 4549 | 93 |
1330638 | 1330638 | 2021-05-18 | Lincoln | Louisiana | 22061 | 4551 | 93 |
1327391 | 1327391 | 2021-05-17 | Lincoln | Louisiana | 22061 | 4533 | 93 |
1324145 | 1324145 | 2021-05-16 | Lincoln | Louisiana | 22061 | 4538 | 93 |
1320899 | 1320899 | 2021-05-15 | Lincoln | Louisiana | 22061 | 4538 | 93 |
1317652 | 1317652 | 2021-05-14 | Lincoln | Louisiana | 22061 | 4538 | 93 |
1314405 | 1314405 | 2021-05-13 | Lincoln | Louisiana | 22061 | 4537 | 93 |
1311158 | 1311158 | 2021-05-12 | Lincoln | Louisiana | 22061 | 4520 | 93 |
1307912 | 1307912 | 2021-05-11 | Lincoln | Louisiana | 22061 | 4524 | 93 |
1304666 | 1304666 | 2021-05-10 | Lincoln | Louisiana | 22061 | 4517 | 92 |
1301419 | 1301419 | 2021-05-09 | Lincoln | Louisiana | 22061 | 4506 | 92 |
1298172 | 1298172 | 2021-05-08 | Lincoln | Louisiana | 22061 | 4506 | 92 |
1294926 | 1294926 | 2021-05-07 | Lincoln | Louisiana | 22061 | 4506 | 92 |
1291680 | 1291680 | 2021-05-06 | Lincoln | Louisiana | 22061 | 4491 | 92 |
1288434 | 1288434 | 2021-05-05 | Lincoln | Louisiana | 22061 | 4489 | 92 |
1285188 | 1285188 | 2021-05-04 | Lincoln | Louisiana | 22061 | 4483 | 92 |
1281941 | 1281941 | 2021-05-03 | Lincoln | Louisiana | 22061 | 4484 | 92 |
1278694 | 1278694 | 2021-05-02 | Lincoln | Louisiana | 22061 | 4482 | 92 |
1275447 | 1275447 | 2021-05-01 | Lincoln | Louisiana | 22061 | 4482 | 92 |
1272200 | 1272200 | 2021-04-30 | Lincoln | Louisiana | 22061 | 4482 | 92 |
1268953 | 1268953 | 2021-04-29 | Lincoln | Louisiana | 22061 | 4470 | 92 |
1265706 | 1265706 | 2021-04-28 | Lincoln | Louisiana | 22061 | 4462 | 92 |
1262459 | 1262459 | 2021-04-27 | Lincoln | Louisiana | 22061 | 4451 | 92 |
1259212 | 1259212 | 2021-04-26 | Lincoln | Louisiana | 22061 | 4456 | 92 |
1255965 | 1255965 | 2021-04-25 | Lincoln | Louisiana | 22061 | 4450 | 92 |
1252718 | 1252718 | 2021-04-24 | Lincoln | Louisiana | 22061 | 4450 | 92 |
1249471 | 1249471 | 2021-04-23 | Lincoln | Louisiana | 22061 | 4450 | 92 |
1246224 | 1246224 | 2021-04-22 | Lincoln | Louisiana | 22061 | 4436 | 92 |
1242977 | 1242977 | 2021-04-21 | Lincoln | Louisiana | 22061 | 4431 | 92 |
1239730 | 1239730 | 2021-04-20 | Lincoln | Louisiana | 22061 | 4423 | 92 |
1236483 | 1236483 | 2021-04-19 | Lincoln | Louisiana | 22061 | 4409 | 92 |
1233236 | 1233236 | 2021-04-18 | Lincoln | Louisiana | 22061 | 4409 | 92 |
1229988 | 1229988 | 2021-04-17 | Lincoln | Louisiana | 22061 | 4409 | 92 |
1226740 | 1226740 | 2021-04-16 | Lincoln | Louisiana | 22061 | 4409 | 92 |
1223493 | 1223493 | 2021-04-15 | Lincoln | Louisiana | 22061 | 4407 | 92 |
1220245 | 1220245 | 2021-04-14 | Lincoln | Louisiana | 22061 | 4404 | 92 |
1216997 | 1216997 | 2021-04-13 | Lincoln | Louisiana | 22061 | 4381 | 91 |
1213750 | 1213750 | 2021-04-12 | Lincoln | Louisiana | 22061 | 4379 | 91 |
1210502 | 1210502 | 2021-04-11 | Lincoln | Louisiana | 22061 | 4365 | 91 |
1207253 | 1207253 | 2021-04-10 | Lincoln | Louisiana | 22061 | 4365 | 91 |
1204005 | 1204005 | 2021-04-09 | Lincoln | Louisiana | 22061 | 4365 | 91 |
1200757 | 1200757 | 2021-04-08 | Lincoln | Louisiana | 22061 | 4368 | 91 |
1197508 | 1197508 | 2021-04-07 | Lincoln | Louisiana | 22061 | 4362 | 91 |
1194260 | 1194260 | 2021-04-06 | Lincoln | Louisiana | 22061 | 4350 | 91 |
1191010 | 1191010 | 2021-04-05 | Lincoln | Louisiana | 22061 | 4348 | 91 |
1187763 | 1187763 | 2021-04-04 | Lincoln | Louisiana | 22061 | 4334 | 91 |
1184516 | 1184516 | 2021-04-03 | Lincoln | Louisiana | 22061 | 4334 | 91 |
1181269 | 1181269 | 2021-04-02 | Lincoln | Louisiana | 22061 | 4334 | 91 |
1178022 | 1178022 | 2021-04-01 | Lincoln | Louisiana | 22061 | 4334 | 91 |
1174775 | 1174775 | 2021-03-31 | Lincoln | Louisiana | 22061 | 4325 | 91 |
1171528 | 1171528 | 2021-03-30 | Lincoln | Louisiana | 22061 | 4306 | 91 |
1168280 | 1168280 | 2021-03-29 | Lincoln | Louisiana | 22061 | 4311 | 91 |
1165032 | 1165032 | 2021-03-28 | Lincoln | Louisiana | 22061 | 4307 | 91 |
1161784 | 1161784 | 2021-03-27 | Lincoln | Louisiana | 22061 | 4307 | 91 |
1158536 | 1158536 | 2021-03-26 | Lincoln | Louisiana | 22061 | 4307 | 91 |
1155289 | 1155289 | 2021-03-25 | Lincoln | Louisiana | 22061 | 4296 | 91 |
1152042 | 1152042 | 2021-03-24 | Lincoln | Louisiana | 22061 | 4288 | 91 |
1148795 | 1148795 | 2021-03-23 | Lincoln | Louisiana | 22061 | 4279 | 91 |
1145548 | 1145548 | 2021-03-22 | Lincoln | Louisiana | 22061 | 4280 | 91 |
1142301 | 1142301 | 2021-03-21 | Lincoln | Louisiana | 22061 | 4278 | 91 |
1139055 | 1139055 | 2021-03-20 | Lincoln | Louisiana | 22061 | 4278 | 91 |
1135809 | 1135809 | 2021-03-19 | Lincoln | Louisiana | 22061 | 4278 | 91 |
1132562 | 1132562 | 2021-03-18 | Lincoln | Louisiana | 22061 | 4273 | 91 |
1129314 | 1129314 | 2021-03-17 | Lincoln | Louisiana | 22061 | 4269 | 91 |
1126068 | 1126068 | 2021-03-16 | Lincoln | Louisiana | 22061 | 4255 | 89 |
1122822 | 1122822 | 2021-03-15 | Lincoln | Louisiana | 22061 | 4254 | 89 |
1119575 | 1119575 | 2021-03-14 | Lincoln | Louisiana | 22061 | 4257 | 89 |
1116328 | 1116328 | 2021-03-13 | Lincoln | Louisiana | 22061 | 4256 | 89 |
1113082 | 1113082 | 2021-03-12 | Lincoln | Louisiana | 22061 | 4256 | 89 |
1109836 | 1109836 | 2021-03-11 | Lincoln | Louisiana | 22061 | 4253 | 89 |
1106590 | 1106590 | 2021-03-10 | Lincoln | Louisiana | 22061 | 4251 | 89 |
1103344 | 1103344 | 2021-03-09 | Lincoln | Louisiana | 22061 | 4250 | 89 |
1100098 | 1100098 | 2021-03-08 | Lincoln | Louisiana | 22061 | 4237 | 89 |
1096850 | 1096850 | 2021-03-07 | Lincoln | Louisiana | 22061 | 4243 | 89 |
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);