ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22097 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194278 | 1194278 | 2021-04-06 | St. Landry | Louisiana | 22097 | 8568 | 250 |
1191028 | 1191028 | 2021-04-05 | St. Landry | Louisiana | 22097 | 8556 | 250 |
1187781 | 1187781 | 2021-04-04 | St. Landry | Louisiana | 22097 | 8555 | 250 |
1184534 | 1184534 | 2021-04-03 | St. Landry | Louisiana | 22097 | 8555 | 250 |
1181287 | 1181287 | 2021-04-02 | St. Landry | Louisiana | 22097 | 8555 | 250 |
1178040 | 1178040 | 2021-04-01 | St. Landry | Louisiana | 22097 | 8555 | 250 |
1174793 | 1174793 | 2021-03-31 | St. Landry | Louisiana | 22097 | 8544 | 250 |
1171546 | 1171546 | 2021-03-30 | St. Landry | Louisiana | 22097 | 8547 | 249 |
1168298 | 1168298 | 2021-03-29 | St. Landry | Louisiana | 22097 | 8534 | 249 |
1165050 | 1165050 | 2021-03-28 | St. Landry | Louisiana | 22097 | 8514 | 247 |
1161802 | 1161802 | 2021-03-27 | St. Landry | Louisiana | 22097 | 8514 | 247 |
1158554 | 1158554 | 2021-03-26 | St. Landry | Louisiana | 22097 | 8514 | 247 |
1155307 | 1155307 | 2021-03-25 | St. Landry | Louisiana | 22097 | 8501 | 247 |
1152060 | 1152060 | 2021-03-24 | St. Landry | Louisiana | 22097 | 8485 | 247 |
1148813 | 1148813 | 2021-03-23 | St. Landry | Louisiana | 22097 | 8481 | 247 |
1145566 | 1145566 | 2021-03-22 | St. Landry | Louisiana | 22097 | 8489 | 247 |
1142319 | 1142319 | 2021-03-21 | St. Landry | Louisiana | 22097 | 8444 | 247 |
1139073 | 1139073 | 2021-03-20 | St. Landry | Louisiana | 22097 | 8444 | 247 |
1135827 | 1135827 | 2021-03-19 | St. Landry | Louisiana | 22097 | 8444 | 247 |
1132580 | 1132580 | 2021-03-18 | St. Landry | Louisiana | 22097 | 8449 | 247 |
1129332 | 1129332 | 2021-03-17 | St. Landry | Louisiana | 22097 | 8427 | 247 |
1126086 | 1126086 | 2021-03-16 | St. Landry | Louisiana | 22097 | 8427 | 246 |
1122840 | 1122840 | 2021-03-15 | St. Landry | Louisiana | 22097 | 8410 | 246 |
1119593 | 1119593 | 2021-03-14 | St. Landry | Louisiana | 22097 | 8412 | 246 |
1116346 | 1116346 | 2021-03-13 | St. Landry | Louisiana | 22097 | 8394 | 246 |
1113100 | 1113100 | 2021-03-12 | St. Landry | Louisiana | 22097 | 8394 | 246 |
1109854 | 1109854 | 2021-03-11 | St. Landry | Louisiana | 22097 | 8376 | 246 |
1106608 | 1106608 | 2021-03-10 | St. Landry | Louisiana | 22097 | 8375 | 246 |
1103362 | 1103362 | 2021-03-09 | St. Landry | Louisiana | 22097 | 8372 | 245 |
1100116 | 1100116 | 2021-03-08 | St. Landry | Louisiana | 22097 | 8352 | 245 |
1096868 | 1096868 | 2021-03-07 | St. Landry | Louisiana | 22097 | 8350 | 246 |
1093622 | 1093622 | 2021-03-06 | St. Landry | Louisiana | 22097 | 8346 | 245 |
1090376 | 1090376 | 2021-03-05 | St. Landry | Louisiana | 22097 | 8346 | 245 |
1087131 | 1087131 | 2021-03-04 | St. Landry | Louisiana | 22097 | 8332 | 245 |
1083885 | 1083885 | 2021-03-03 | St. Landry | Louisiana | 22097 | 8322 | 244 |
1080639 | 1080639 | 2021-03-02 | St. Landry | Louisiana | 22097 | 8311 | 244 |
1077394 | 1077394 | 2021-03-01 | St. Landry | Louisiana | 22097 | 8302 | 243 |
1074148 | 1074148 | 2021-02-28 | St. Landry | Louisiana | 22097 | 8291 | 243 |
1070902 | 1070902 | 2021-02-27 | St. Landry | Louisiana | 22097 | 8271 | 243 |
1067657 | 1067657 | 2021-02-26 | St. Landry | Louisiana | 22097 | 8271 | 243 |
1064412 | 1064412 | 2021-02-25 | St. Landry | Louisiana | 22097 | 8264 | 241 |
1061167 | 1061167 | 2021-02-24 | St. Landry | Louisiana | 22097 | 8252 | 241 |
1057921 | 1057921 | 2021-02-23 | St. Landry | Louisiana | 22097 | 8237 | 241 |
1054675 | 1054675 | 2021-02-22 | St. Landry | Louisiana | 22097 | 8230 | 242 |
1051428 | 1051428 | 2021-02-21 | St. Landry | Louisiana | 22097 | 8206 | 242 |
1048181 | 1048181 | 2021-02-20 | St. Landry | Louisiana | 22097 | 8175 | 241 |
1044936 | 1044936 | 2021-02-19 | St. Landry | Louisiana | 22097 | 8175 | 241 |
1041691 | 1041691 | 2021-02-18 | St. Landry | Louisiana | 22097 | 8172 | 241 |
1038446 | 1038446 | 2021-02-17 | St. Landry | Louisiana | 22097 | 8155 | 241 |
1035201 | 1035201 | 2021-02-16 | St. Landry | Louisiana | 22097 | 8163 | 239 |
1031955 | 1031955 | 2021-02-15 | St. Landry | Louisiana | 22097 | 8163 | 239 |
1028708 | 1028708 | 2021-02-14 | St. Landry | Louisiana | 22097 | 8128 | 236 |
1025463 | 1025463 | 2021-02-13 | St. Landry | Louisiana | 22097 | 8130 | 236 |
1022218 | 1022218 | 2021-02-12 | St. Landry | Louisiana | 22097 | 8130 | 236 |
1018973 | 1018973 | 2021-02-11 | St. Landry | Louisiana | 22097 | 8121 | 234 |
1015728 | 1015728 | 2021-02-10 | St. Landry | Louisiana | 22097 | 8068 | 232 |
1012483 | 1012483 | 2021-02-09 | St. Landry | Louisiana | 22097 | 8072 | 232 |
1009237 | 1009237 | 2021-02-08 | St. Landry | Louisiana | 22097 | 8064 | 231 |
1005991 | 1005991 | 2021-02-07 | St. Landry | Louisiana | 22097 | 8047 | 230 |
1002745 | 1002745 | 2021-02-06 | St. Landry | Louisiana | 22097 | 7990 | 230 |
999499 | 999499 | 2021-02-05 | St. Landry | Louisiana | 22097 | 7990 | 230 |
996253 | 996253 | 2021-02-04 | St. Landry | Louisiana | 22097 | 7968 | 229 |
993007 | 993007 | 2021-02-03 | St. Landry | Louisiana | 22097 | 7948 | 229 |
989761 | 989761 | 2021-02-02 | St. Landry | Louisiana | 22097 | 7920 | 227 |
986514 | 986514 | 2021-02-01 | St. Landry | Louisiana | 22097 | 7902 | 227 |
983267 | 983267 | 2021-01-31 | St. Landry | Louisiana | 22097 | 7870 | 226 |
980021 | 980021 | 2021-01-30 | St. Landry | Louisiana | 22097 | 7830 | 225 |
976775 | 976775 | 2021-01-29 | St. Landry | Louisiana | 22097 | 7830 | 225 |
973530 | 973530 | 2021-01-28 | St. Landry | Louisiana | 22097 | 7794 | 225 |
970285 | 970285 | 2021-01-27 | St. Landry | Louisiana | 22097 | 7757 | 225 |
967041 | 967041 | 2021-01-26 | St. Landry | Louisiana | 22097 | 7706 | 223 |
963796 | 963796 | 2021-01-25 | St. Landry | Louisiana | 22097 | 7678 | 222 |
960551 | 960551 | 2021-01-24 | St. Landry | Louisiana | 22097 | 7663 | 222 |
957305 | 957305 | 2021-01-23 | St. Landry | Louisiana | 22097 | 7587 | 221 |
954060 | 954060 | 2021-01-22 | St. Landry | Louisiana | 22097 | 7587 | 221 |
950815 | 950815 | 2021-01-21 | St. Landry | Louisiana | 22097 | 7562 | 220 |
947569 | 947569 | 2021-01-20 | St. Landry | Louisiana | 22097 | 7518 | 218 |
944322 | 944322 | 2021-01-19 | St. Landry | Louisiana | 22097 | 7466 | 216 |
941077 | 941077 | 2021-01-18 | St. Landry | Louisiana | 22097 | 7432 | 214 |
937832 | 937832 | 2021-01-17 | St. Landry | Louisiana | 22097 | 7416 | 214 |
934587 | 934587 | 2021-01-16 | St. Landry | Louisiana | 22097 | 7355 | 211 |
931342 | 931342 | 2021-01-15 | St. Landry | Louisiana | 22097 | 7355 | 211 |
928097 | 928097 | 2021-01-14 | St. Landry | Louisiana | 22097 | 7295 | 211 |
924851 | 924851 | 2021-01-13 | St. Landry | Louisiana | 22097 | 7247 | 210 |
921606 | 921606 | 2021-01-12 | St. Landry | Louisiana | 22097 | 7213 | 209 |
918361 | 918361 | 2021-01-11 | St. Landry | Louisiana | 22097 | 7125 | 208 |
915116 | 915116 | 2021-01-10 | St. Landry | Louisiana | 22097 | 7122 | 208 |
911871 | 911871 | 2021-01-09 | St. Landry | Louisiana | 22097 | 7010 | 206 |
908626 | 908626 | 2021-01-08 | St. Landry | Louisiana | 22097 | 7010 | 206 |
905380 | 905380 | 2021-01-07 | St. Landry | Louisiana | 22097 | 6961 | 204 |
902135 | 902135 | 2021-01-06 | St. Landry | Louisiana | 22097 | 6882 | 204 |
898890 | 898890 | 2021-01-05 | St. Landry | Louisiana | 22097 | 6758 | 204 |
895645 | 895645 | 2021-01-04 | St. Landry | Louisiana | 22097 | 6677 | 204 |
892398 | 892398 | 2021-01-03 | St. Landry | Louisiana | 22097 | 6663 | 204 |
889152 | 889152 | 2021-01-02 | St. Landry | Louisiana | 22097 | 6576 | 202 |
885906 | 885906 | 2021-01-01 | St. Landry | Louisiana | 22097 | 6576 | 202 |
882661 | 882661 | 2020-12-31 | St. Landry | Louisiana | 22097 | 6576 | 202 |
879416 | 879416 | 2020-12-30 | St. Landry | Louisiana | 22097 | 6509 | 198 |
876171 | 876171 | 2020-12-29 | St. Landry | Louisiana | 22097 | 6365 | 197 |
872926 | 872926 | 2020-12-28 | St. Landry | Louisiana | 22097 | 6340 | 197 |
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);