ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Ascension" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1392288 | 1392288 | 2021-06-06 | Ascension | Louisiana | 22005 | 12650 | 167 |
1389043 | 1389043 | 2021-06-05 | Ascension | Louisiana | 22005 | 12650 | 167 |
1385798 | 1385798 | 2021-06-04 | Ascension | Louisiana | 22005 | 12650 | 167 |
1382552 | 1382552 | 2021-06-03 | Ascension | Louisiana | 22005 | 12631 | 167 |
1379307 | 1379307 | 2021-06-02 | Ascension | Louisiana | 22005 | 12621 | 167 |
1376061 | 1376061 | 2021-06-01 | Ascension | Louisiana | 22005 | 12600 | 167 |
1372816 | 1372816 | 2021-05-31 | Ascension | Louisiana | 22005 | 12571 | 167 |
1369571 | 1369571 | 2021-05-30 | Ascension | Louisiana | 22005 | 12571 | 167 |
1366325 | 1366325 | 2021-05-29 | Ascension | Louisiana | 22005 | 12571 | 167 |
1363079 | 1363079 | 2021-05-28 | Ascension | Louisiana | 22005 | 12571 | 167 |
1359832 | 1359832 | 2021-05-27 | Ascension | Louisiana | 22005 | 12570 | 167 |
1356586 | 1356586 | 2021-05-26 | Ascension | Louisiana | 22005 | 12563 | 167 |
1353340 | 1353340 | 2021-05-25 | Ascension | Louisiana | 22005 | 12528 | 167 |
1350094 | 1350094 | 2021-05-24 | Ascension | Louisiana | 22005 | 12472 | 166 |
1346847 | 1346847 | 2021-05-23 | Ascension | Louisiana | 22005 | 12442 | 166 |
1343599 | 1343599 | 2021-05-22 | Ascension | Louisiana | 22005 | 12442 | 166 |
1340351 | 1340351 | 2021-05-21 | Ascension | Louisiana | 22005 | 12442 | 166 |
1337104 | 1337104 | 2021-05-20 | Ascension | Louisiana | 22005 | 12434 | 166 |
1333857 | 1333857 | 2021-05-19 | Ascension | Louisiana | 22005 | 12428 | 165 |
1330610 | 1330610 | 2021-05-18 | Ascension | Louisiana | 22005 | 12394 | 165 |
1327363 | 1327363 | 2021-05-17 | Ascension | Louisiana | 22005 | 12391 | 164 |
1324117 | 1324117 | 2021-05-16 | Ascension | Louisiana | 22005 | 12328 | 164 |
1320871 | 1320871 | 2021-05-15 | Ascension | Louisiana | 22005 | 12328 | 164 |
1317624 | 1317624 | 2021-05-14 | Ascension | Louisiana | 22005 | 12328 | 164 |
1314377 | 1314377 | 2021-05-13 | Ascension | Louisiana | 22005 | 12313 | 164 |
1311130 | 1311130 | 2021-05-12 | Ascension | Louisiana | 22005 | 12312 | 164 |
1307884 | 1307884 | 2021-05-11 | Ascension | Louisiana | 22005 | 12289 | 164 |
1304638 | 1304638 | 2021-05-10 | Ascension | Louisiana | 22005 | 12259 | 164 |
1301391 | 1301391 | 2021-05-09 | Ascension | Louisiana | 22005 | 12172 | 164 |
1298144 | 1298144 | 2021-05-08 | Ascension | Louisiana | 22005 | 12172 | 164 |
1294898 | 1294898 | 2021-05-07 | Ascension | Louisiana | 22005 | 12172 | 164 |
1291652 | 1291652 | 2021-05-06 | Ascension | Louisiana | 22005 | 12167 | 164 |
1288406 | 1288406 | 2021-05-05 | Ascension | Louisiana | 22005 | 12137 | 164 |
1285160 | 1285160 | 2021-05-04 | Ascension | Louisiana | 22005 | 12138 | 164 |
1281913 | 1281913 | 2021-05-03 | Ascension | Louisiana | 22005 | 12097 | 164 |
1278666 | 1278666 | 2021-05-02 | Ascension | Louisiana | 22005 | 12080 | 164 |
1275419 | 1275419 | 2021-05-01 | Ascension | Louisiana | 22005 | 12080 | 164 |
1272172 | 1272172 | 2021-04-30 | Ascension | Louisiana | 22005 | 12080 | 164 |
1268925 | 1268925 | 2021-04-29 | Ascension | Louisiana | 22005 | 12021 | 164 |
1265678 | 1265678 | 2021-04-28 | Ascension | Louisiana | 22005 | 12008 | 164 |
1262431 | 1262431 | 2021-04-27 | Ascension | Louisiana | 22005 | 11992 | 164 |
1259184 | 1259184 | 2021-04-26 | Ascension | Louisiana | 22005 | 11980 | 164 |
1255937 | 1255937 | 2021-04-25 | Ascension | Louisiana | 22005 | 11939 | 164 |
1252690 | 1252690 | 2021-04-24 | Ascension | Louisiana | 22005 | 11939 | 164 |
1249443 | 1249443 | 2021-04-23 | Ascension | Louisiana | 22005 | 11939 | 164 |
1246196 | 1246196 | 2021-04-22 | Ascension | Louisiana | 22005 | 11916 | 164 |
1242949 | 1242949 | 2021-04-21 | Ascension | Louisiana | 22005 | 11910 | 164 |
1239702 | 1239702 | 2021-04-20 | Ascension | Louisiana | 22005 | 11858 | 164 |
1236455 | 1236455 | 2021-04-19 | Ascension | Louisiana | 22005 | 11846 | 164 |
1233208 | 1233208 | 2021-04-18 | Ascension | Louisiana | 22005 | 11829 | 162 |
1229960 | 1229960 | 2021-04-17 | Ascension | Louisiana | 22005 | 11829 | 162 |
1226712 | 1226712 | 2021-04-16 | Ascension | Louisiana | 22005 | 11829 | 162 |
1223465 | 1223465 | 2021-04-15 | Ascension | Louisiana | 22005 | 11815 | 162 |
1220217 | 1220217 | 2021-04-14 | Ascension | Louisiana | 22005 | 11752 | 162 |
1216969 | 1216969 | 2021-04-13 | Ascension | Louisiana | 22005 | 11741 | 162 |
1213722 | 1213722 | 2021-04-12 | Ascension | Louisiana | 22005 | 11739 | 162 |
1210474 | 1210474 | 2021-04-11 | Ascension | Louisiana | 22005 | 11704 | 162 |
1207225 | 1207225 | 2021-04-10 | Ascension | Louisiana | 22005 | 11704 | 162 |
1203977 | 1203977 | 2021-04-09 | Ascension | Louisiana | 22005 | 11704 | 162 |
1200729 | 1200729 | 2021-04-08 | Ascension | Louisiana | 22005 | 11649 | 161 |
1197480 | 1197480 | 2021-04-07 | Ascension | Louisiana | 22005 | 11649 | 161 |
1194232 | 1194232 | 2021-04-06 | Ascension | Louisiana | 22005 | 11617 | 160 |
1190982 | 1190982 | 2021-04-05 | Ascension | Louisiana | 22005 | 11611 | 159 |
1187735 | 1187735 | 2021-04-04 | Ascension | Louisiana | 22005 | 11578 | 159 |
1184488 | 1184488 | 2021-04-03 | Ascension | Louisiana | 22005 | 11578 | 159 |
1181241 | 1181241 | 2021-04-02 | Ascension | Louisiana | 22005 | 11578 | 159 |
1177994 | 1177994 | 2021-04-01 | Ascension | Louisiana | 22005 | 11578 | 159 |
1174747 | 1174747 | 2021-03-31 | Ascension | Louisiana | 22005 | 11541 | 159 |
1171500 | 1171500 | 2021-03-30 | Ascension | Louisiana | 22005 | 11536 | 159 |
1168252 | 1168252 | 2021-03-29 | Ascension | Louisiana | 22005 | 11513 | 159 |
1165004 | 1165004 | 2021-03-28 | Ascension | Louisiana | 22005 | 11480 | 158 |
1161756 | 1161756 | 2021-03-27 | Ascension | Louisiana | 22005 | 11480 | 158 |
1158508 | 1158508 | 2021-03-26 | Ascension | Louisiana | 22005 | 11480 | 158 |
1155261 | 1155261 | 2021-03-25 | Ascension | Louisiana | 22005 | 11458 | 158 |
1152014 | 1152014 | 2021-03-24 | Ascension | Louisiana | 22005 | 11444 | 158 |
1148767 | 1148767 | 2021-03-23 | Ascension | Louisiana | 22005 | 11431 | 158 |
1145520 | 1145520 | 2021-03-22 | Ascension | Louisiana | 22005 | 11398 | 158 |
1142273 | 1142273 | 2021-03-21 | Ascension | Louisiana | 22005 | 11351 | 155 |
1139027 | 1139027 | 2021-03-20 | Ascension | Louisiana | 22005 | 11351 | 155 |
1135781 | 1135781 | 2021-03-19 | Ascension | Louisiana | 22005 | 11351 | 155 |
1132534 | 1132534 | 2021-03-18 | Ascension | Louisiana | 22005 | 11344 | 155 |
1129286 | 1129286 | 2021-03-17 | Ascension | Louisiana | 22005 | 11312 | 155 |
1126040 | 1126040 | 2021-03-16 | Ascension | Louisiana | 22005 | 11294 | 154 |
1122794 | 1122794 | 2021-03-15 | Ascension | Louisiana | 22005 | 11216 | 154 |
1119547 | 1119547 | 2021-03-14 | Ascension | Louisiana | 22005 | 11204 | 154 |
1116300 | 1116300 | 2021-03-13 | Ascension | Louisiana | 22005 | 11152 | 153 |
1113054 | 1113054 | 2021-03-12 | Ascension | Louisiana | 22005 | 11152 | 153 |
1109808 | 1109808 | 2021-03-11 | Ascension | Louisiana | 22005 | 11134 | 153 |
1106562 | 1106562 | 2021-03-10 | Ascension | Louisiana | 22005 | 11122 | 153 |
1103316 | 1103316 | 2021-03-09 | Ascension | Louisiana | 22005 | 11098 | 153 |
1100070 | 1100070 | 2021-03-08 | Ascension | Louisiana | 22005 | 11088 | 152 |
1096822 | 1096822 | 2021-03-07 | Ascension | Louisiana | 22005 | 11074 | 152 |
1093576 | 1093576 | 2021-03-06 | Ascension | Louisiana | 22005 | 11048 | 152 |
1090330 | 1090330 | 2021-03-05 | Ascension | Louisiana | 22005 | 11048 | 152 |
1087085 | 1087085 | 2021-03-04 | Ascension | Louisiana | 22005 | 11036 | 152 |
1083839 | 1083839 | 2021-03-03 | Ascension | Louisiana | 22005 | 11014 | 149 |
1080593 | 1080593 | 2021-03-02 | Ascension | Louisiana | 22005 | 11012 | 148 |
1077348 | 1077348 | 2021-03-01 | Ascension | Louisiana | 22005 | 10963 | 147 |
1074102 | 1074102 | 2021-02-28 | Ascension | Louisiana | 22005 | 10956 | 147 |
1070856 | 1070856 | 2021-02-27 | Ascension | Louisiana | 22005 | 10937 | 147 |
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);