ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rapides" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194269 | 1194269 | 2021-04-06 | Rapides | Louisiana | 22079 | 11656 | 307 |
1191019 | 1191019 | 2021-04-05 | Rapides | Louisiana | 22079 | 11645 | 306 |
1187772 | 1187772 | 2021-04-04 | Rapides | Louisiana | 22079 | 11595 | 306 |
1184525 | 1184525 | 2021-04-03 | Rapides | Louisiana | 22079 | 11595 | 306 |
1181278 | 1181278 | 2021-04-02 | Rapides | Louisiana | 22079 | 11595 | 306 |
1178031 | 1178031 | 2021-04-01 | Rapides | Louisiana | 22079 | 11595 | 306 |
1174784 | 1174784 | 2021-03-31 | Rapides | Louisiana | 22079 | 11580 | 306 |
1171537 | 1171537 | 2021-03-30 | Rapides | Louisiana | 22079 | 11573 | 306 |
1168289 | 1168289 | 2021-03-29 | Rapides | Louisiana | 22079 | 11566 | 305 |
1165041 | 1165041 | 2021-03-28 | Rapides | Louisiana | 22079 | 11560 | 305 |
1161793 | 1161793 | 2021-03-27 | Rapides | Louisiana | 22079 | 11560 | 305 |
1158545 | 1158545 | 2021-03-26 | Rapides | Louisiana | 22079 | 11560 | 305 |
1155298 | 1155298 | 2021-03-25 | Rapides | Louisiana | 22079 | 11551 | 305 |
1152051 | 1152051 | 2021-03-24 | Rapides | Louisiana | 22079 | 11548 | 304 |
1148804 | 1148804 | 2021-03-23 | Rapides | Louisiana | 22079 | 11533 | 304 |
1145557 | 1145557 | 2021-03-22 | Rapides | Louisiana | 22079 | 11517 | 303 |
1142310 | 1142310 | 2021-03-21 | Rapides | Louisiana | 22079 | 11433 | 303 |
1139064 | 1139064 | 2021-03-20 | Rapides | Louisiana | 22079 | 11433 | 303 |
1135818 | 1135818 | 2021-03-19 | Rapides | Louisiana | 22079 | 11433 | 303 |
1132571 | 1132571 | 2021-03-18 | Rapides | Louisiana | 22079 | 11417 | 303 |
1129323 | 1129323 | 2021-03-17 | Rapides | Louisiana | 22079 | 11413 | 302 |
1126077 | 1126077 | 2021-03-16 | Rapides | Louisiana | 22079 | 11409 | 302 |
1122831 | 1122831 | 2021-03-15 | Rapides | Louisiana | 22079 | 11374 | 302 |
1119584 | 1119584 | 2021-03-14 | Rapides | Louisiana | 22079 | 11366 | 300 |
1116337 | 1116337 | 2021-03-13 | Rapides | Louisiana | 22079 | 11360 | 300 |
1113091 | 1113091 | 2021-03-12 | Rapides | Louisiana | 22079 | 11360 | 300 |
1109845 | 1109845 | 2021-03-11 | Rapides | Louisiana | 22079 | 11356 | 300 |
1106599 | 1106599 | 2021-03-10 | Rapides | Louisiana | 22079 | 11347 | 300 |
1103353 | 1103353 | 2021-03-09 | Rapides | Louisiana | 22079 | 11337 | 297 |
1100107 | 1100107 | 2021-03-08 | Rapides | Louisiana | 22079 | 11339 | 296 |
1096859 | 1096859 | 2021-03-07 | Rapides | Louisiana | 22079 | 11328 | 296 |
1093613 | 1093613 | 2021-03-06 | Rapides | Louisiana | 22079 | 11313 | 295 |
1090367 | 1090367 | 2021-03-05 | Rapides | Louisiana | 22079 | 11313 | 295 |
1087122 | 1087122 | 2021-03-04 | Rapides | Louisiana | 22079 | 11310 | 294 |
1083876 | 1083876 | 2021-03-03 | Rapides | Louisiana | 22079 | 11305 | 294 |
1080630 | 1080630 | 2021-03-02 | Rapides | Louisiana | 22079 | 11284 | 293 |
1077385 | 1077385 | 2021-03-01 | Rapides | Louisiana | 22079 | 11276 | 293 |
1074139 | 1074139 | 2021-02-28 | Rapides | Louisiana | 22079 | 11283 | 292 |
1070893 | 1070893 | 2021-02-27 | Rapides | Louisiana | 22079 | 11245 | 292 |
1067648 | 1067648 | 2021-02-26 | Rapides | Louisiana | 22079 | 11245 | 292 |
1064403 | 1064403 | 2021-02-25 | Rapides | Louisiana | 22079 | 11224 | 291 |
1061158 | 1061158 | 2021-02-24 | Rapides | Louisiana | 22079 | 11209 | 291 |
1057912 | 1057912 | 2021-02-23 | Rapides | Louisiana | 22079 | 11202 | 291 |
1054666 | 1054666 | 2021-02-22 | Rapides | Louisiana | 22079 | 11175 | 291 |
1051419 | 1051419 | 2021-02-21 | Rapides | Louisiana | 22079 | 11174 | 291 |
1048172 | 1048172 | 2021-02-20 | Rapides | Louisiana | 22079 | 11140 | 290 |
1044927 | 1044927 | 2021-02-19 | Rapides | Louisiana | 22079 | 11140 | 290 |
1041682 | 1041682 | 2021-02-18 | Rapides | Louisiana | 22079 | 11131 | 287 |
1038437 | 1038437 | 2021-02-17 | Rapides | Louisiana | 22079 | 11112 | 287 |
1035192 | 1035192 | 2021-02-16 | Rapides | Louisiana | 22079 | 11098 | 284 |
1031946 | 1031946 | 2021-02-15 | Rapides | Louisiana | 22079 | 11098 | 284 |
1028699 | 1028699 | 2021-02-14 | Rapides | Louisiana | 22079 | 11098 | 282 |
1025454 | 1025454 | 2021-02-13 | Rapides | Louisiana | 22079 | 11080 | 281 |
1022209 | 1022209 | 2021-02-12 | Rapides | Louisiana | 22079 | 11080 | 281 |
1018964 | 1018964 | 2021-02-11 | Rapides | Louisiana | 22079 | 11073 | 280 |
1015719 | 1015719 | 2021-02-10 | Rapides | Louisiana | 22079 | 10998 | 279 |
1012474 | 1012474 | 2021-02-09 | Rapides | Louisiana | 22079 | 10988 | 272 |
1009228 | 1009228 | 2021-02-08 | Rapides | Louisiana | 22079 | 10951 | 270 |
1005982 | 1005982 | 2021-02-07 | Rapides | Louisiana | 22079 | 10931 | 270 |
1002736 | 1002736 | 2021-02-06 | Rapides | Louisiana | 22079 | 10888 | 269 |
999490 | 999490 | 2021-02-05 | Rapides | Louisiana | 22079 | 10888 | 269 |
996244 | 996244 | 2021-02-04 | Rapides | Louisiana | 22079 | 10861 | 266 |
992998 | 992998 | 2021-02-03 | Rapides | Louisiana | 22079 | 10834 | 266 |
989752 | 989752 | 2021-02-02 | Rapides | Louisiana | 22079 | 10804 | 265 |
986505 | 986505 | 2021-02-01 | Rapides | Louisiana | 22079 | 10728 | 265 |
983258 | 983258 | 2021-01-31 | Rapides | Louisiana | 22079 | 10710 | 261 |
980012 | 980012 | 2021-01-30 | Rapides | Louisiana | 22079 | 10648 | 259 |
976766 | 976766 | 2021-01-29 | Rapides | Louisiana | 22079 | 10648 | 259 |
973521 | 973521 | 2021-01-28 | Rapides | Louisiana | 22079 | 10602 | 252 |
970276 | 970276 | 2021-01-27 | Rapides | Louisiana | 22079 | 10566 | 248 |
967032 | 967032 | 2021-01-26 | Rapides | Louisiana | 22079 | 10368 | 244 |
963787 | 963787 | 2021-01-25 | Rapides | Louisiana | 22079 | 10317 | 244 |
960542 | 960542 | 2021-01-24 | Rapides | Louisiana | 22079 | 10280 | 243 |
957296 | 957296 | 2021-01-23 | Rapides | Louisiana | 22079 | 10193 | 242 |
954051 | 954051 | 2021-01-22 | Rapides | Louisiana | 22079 | 10193 | 242 |
950806 | 950806 | 2021-01-21 | Rapides | Louisiana | 22079 | 10140 | 238 |
947560 | 947560 | 2021-01-20 | Rapides | Louisiana | 22079 | 10022 | 237 |
944313 | 944313 | 2021-01-19 | Rapides | Louisiana | 22079 | 9987 | 237 |
941068 | 941068 | 2021-01-18 | Rapides | Louisiana | 22079 | 9865 | 233 |
937823 | 937823 | 2021-01-17 | Rapides | Louisiana | 22079 | 9847 | 231 |
934578 | 934578 | 2021-01-16 | Rapides | Louisiana | 22079 | 9742 | 226 |
931333 | 931333 | 2021-01-15 | Rapides | Louisiana | 22079 | 9742 | 226 |
928088 | 928088 | 2021-01-14 | Rapides | Louisiana | 22079 | 9670 | 226 |
924842 | 924842 | 2021-01-13 | Rapides | Louisiana | 22079 | 9584 | 226 |
921597 | 921597 | 2021-01-12 | Rapides | Louisiana | 22079 | 9521 | 225 |
918352 | 918352 | 2021-01-11 | Rapides | Louisiana | 22079 | 9281 | 221 |
915107 | 915107 | 2021-01-10 | Rapides | Louisiana | 22079 | 9272 | 218 |
911862 | 911862 | 2021-01-09 | Rapides | Louisiana | 22079 | 9117 | 218 |
908617 | 908617 | 2021-01-08 | Rapides | Louisiana | 22079 | 9117 | 218 |
905371 | 905371 | 2021-01-07 | Rapides | Louisiana | 22079 | 9006 | 215 |
902126 | 902126 | 2021-01-06 | Rapides | Louisiana | 22079 | 8899 | 214 |
898881 | 898881 | 2021-01-05 | Rapides | Louisiana | 22079 | 8504 | 213 |
895636 | 895636 | 2021-01-04 | Rapides | Louisiana | 22079 | 8393 | 213 |
892389 | 892389 | 2021-01-03 | Rapides | Louisiana | 22079 | 8386 | 213 |
889143 | 889143 | 2021-01-02 | Rapides | Louisiana | 22079 | 8258 | 212 |
885897 | 885897 | 2021-01-01 | Rapides | Louisiana | 22079 | 8258 | 212 |
882652 | 882652 | 2020-12-31 | Rapides | Louisiana | 22079 | 8258 | 212 |
879407 | 879407 | 2020-12-30 | Rapides | Louisiana | 22079 | 8162 | 212 |
876162 | 876162 | 2020-12-29 | Rapides | Louisiana | 22079 | 7905 | 210 |
872917 | 872917 | 2020-12-28 | Rapides | Louisiana | 22079 | 7747 | 210 |
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);