ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Franklin" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387073 | 387073 | 2020-07-31 | Franklin | Louisiana | 22041 | 785 | 16 |
383855 | 383855 | 2020-07-30 | Franklin | Louisiana | 22041 | 759 | 16 |
380638 | 380638 | 2020-07-29 | Franklin | Louisiana | 22041 | 745 | 16 |
377421 | 377421 | 2020-07-28 | Franklin | Louisiana | 22041 | 731 | 16 |
374206 | 374206 | 2020-07-27 | Franklin | Louisiana | 22041 | 729 | 16 |
370994 | 370994 | 2020-07-26 | Franklin | Louisiana | 22041 | 719 | 16 |
367784 | 367784 | 2020-07-25 | Franklin | Louisiana | 22041 | 681 | 16 |
364577 | 364577 | 2020-07-24 | Franklin | Louisiana | 22041 | 681 | 16 |
361370 | 361370 | 2020-07-23 | Franklin | Louisiana | 22041 | 669 | 16 |
358165 | 358165 | 2020-07-22 | Franklin | Louisiana | 22041 | 649 | 16 |
354962 | 354962 | 2020-07-21 | Franklin | Louisiana | 22041 | 641 | 15 |
351760 | 351760 | 2020-07-20 | Franklin | Louisiana | 22041 | 634 | 14 |
348560 | 348560 | 2020-07-19 | Franklin | Louisiana | 22041 | 628 | 14 |
345359 | 345359 | 2020-07-18 | Franklin | Louisiana | 22041 | 610 | 14 |
342159 | 342159 | 2020-07-17 | Franklin | Louisiana | 22041 | 610 | 14 |
338963 | 338963 | 2020-07-16 | Franklin | Louisiana | 22041 | 595 | 14 |
335767 | 335767 | 2020-07-15 | Franklin | Louisiana | 22041 | 580 | 14 |
332574 | 332574 | 2020-07-14 | Franklin | Louisiana | 22041 | 575 | 14 |
329387 | 329387 | 2020-07-13 | Franklin | Louisiana | 22041 | 568 | 14 |
326201 | 326201 | 2020-07-12 | Franklin | Louisiana | 22041 | 558 | 14 |
323018 | 323018 | 2020-07-11 | Franklin | Louisiana | 22041 | 554 | 14 |
319839 | 319839 | 2020-07-10 | Franklin | Louisiana | 22041 | 538 | 14 |
316664 | 316664 | 2020-07-09 | Franklin | Louisiana | 22041 | 527 | 14 |
313490 | 313490 | 2020-07-08 | Franklin | Louisiana | 22041 | 508 | 14 |
310320 | 310320 | 2020-07-07 | Franklin | Louisiana | 22041 | 502 | 14 |
307152 | 307152 | 2020-07-06 | Franklin | Louisiana | 22041 | 501 | 14 |
303985 | 303985 | 2020-07-05 | Franklin | Louisiana | 22041 | 501 | 14 |
300821 | 300821 | 2020-07-04 | Franklin | Louisiana | 22041 | 483 | 14 |
297659 | 297659 | 2020-07-03 | Franklin | Louisiana | 22041 | 483 | 14 |
294501 | 294501 | 2020-07-02 | Franklin | Louisiana | 22041 | 475 | 14 |
291347 | 291347 | 2020-07-01 | Franklin | Louisiana | 22041 | 471 | 14 |
288196 | 288196 | 2020-06-30 | Franklin | Louisiana | 22041 | 467 | 14 |
285047 | 285047 | 2020-06-29 | Franklin | Louisiana | 22041 | 468 | 14 |
281901 | 281901 | 2020-06-28 | Franklin | Louisiana | 22041 | 464 | 14 |
278753 | 278753 | 2020-06-27 | Franklin | Louisiana | 22041 | 455 | 14 |
275605 | 275605 | 2020-06-26 | Franklin | Louisiana | 22041 | 455 | 14 |
272462 | 272462 | 2020-06-25 | Franklin | Louisiana | 22041 | 448 | 14 |
269326 | 269326 | 2020-06-24 | Franklin | Louisiana | 22041 | 447 | 14 |
266193 | 266193 | 2020-06-23 | Franklin | Louisiana | 22041 | 443 | 14 |
263066 | 263066 | 2020-06-22 | Franklin | Louisiana | 22041 | 421 | 14 |
259937 | 259937 | 2020-06-21 | Franklin | Louisiana | 22041 | 416 | 14 |
256811 | 256811 | 2020-06-20 | Franklin | Louisiana | 22041 | 414 | 14 |
253691 | 253691 | 2020-06-19 | Franklin | Louisiana | 22041 | 412 | 14 |
250576 | 250576 | 2020-06-18 | Franklin | Louisiana | 22041 | 439 | 14 |
247464 | 247464 | 2020-06-17 | Franklin | Louisiana | 22041 | 439 | 14 |
244351 | 244351 | 2020-06-16 | Franklin | Louisiana | 22041 | 425 | 14 |
241240 | 241240 | 2020-06-15 | Franklin | Louisiana | 22041 | 424 | 13 |
238131 | 238131 | 2020-06-14 | Franklin | Louisiana | 22041 | 415 | 13 |
235024 | 235024 | 2020-06-13 | Franklin | Louisiana | 22041 | 415 | 13 |
231919 | 231919 | 2020-06-12 | Franklin | Louisiana | 22041 | 395 | 13 |
228815 | 228815 | 2020-06-11 | Franklin | Louisiana | 22041 | 395 | 13 |
225713 | 225713 | 2020-06-10 | Franklin | Louisiana | 22041 | 391 | 12 |
222617 | 222617 | 2020-06-09 | Franklin | Louisiana | 22041 | 390 | 12 |
219522 | 219522 | 2020-06-08 | Franklin | Louisiana | 22041 | 389 | 12 |
216430 | 216430 | 2020-06-07 | Franklin | Louisiana | 22041 | 386 | 12 |
213343 | 213343 | 2020-06-06 | Franklin | Louisiana | 22041 | 384 | 12 |
210258 | 210258 | 2020-06-05 | Franklin | Louisiana | 22041 | 383 | 12 |
207177 | 207177 | 2020-06-04 | Franklin | Louisiana | 22041 | 378 | 12 |
204096 | 204096 | 2020-06-03 | Franklin | Louisiana | 22041 | 377 | 12 |
201019 | 201019 | 2020-06-02 | Franklin | Louisiana | 22041 | 377 | 10 |
197947 | 197947 | 2020-06-01 | Franklin | Louisiana | 22041 | 376 | 10 |
194876 | 194876 | 2020-05-31 | Franklin | Louisiana | 22041 | 332 | 10 |
191808 | 191808 | 2020-05-30 | Franklin | Louisiana | 22041 | 314 | 10 |
188744 | 188744 | 2020-05-29 | Franklin | Louisiana | 22041 | 311 | 10 |
185686 | 185686 | 2020-05-28 | Franklin | Louisiana | 22041 | 311 | 10 |
182631 | 182631 | 2020-05-27 | Franklin | Louisiana | 22041 | 310 | 10 |
179586 | 179586 | 2020-05-26 | Franklin | Louisiana | 22041 | 297 | 10 |
176542 | 176542 | 2020-05-25 | Franklin | Louisiana | 22041 | 294 | 10 |
173498 | 173498 | 2020-05-24 | Franklin | Louisiana | 22041 | 288 | 10 |
170457 | 170457 | 2020-05-23 | Franklin | Louisiana | 22041 | 287 | 10 |
167419 | 167419 | 2020-05-22 | Franklin | Louisiana | 22041 | 287 | 10 |
164383 | 164383 | 2020-05-21 | Franklin | Louisiana | 22041 | 287 | 9 |
161354 | 161354 | 2020-05-20 | Franklin | Louisiana | 22041 | 274 | 9 |
158328 | 158328 | 2020-05-19 | Franklin | Louisiana | 22041 | 274 | 9 |
155310 | 155310 | 2020-05-18 | Franklin | Louisiana | 22041 | 273 | 8 |
152296 | 152296 | 2020-05-17 | Franklin | Louisiana | 22041 | 273 | 8 |
149285 | 149285 | 2020-05-16 | Franklin | Louisiana | 22041 | 268 | 8 |
146280 | 146280 | 2020-05-15 | Franklin | Louisiana | 22041 | 266 | 8 |
143280 | 143280 | 2020-05-14 | Franklin | Louisiana | 22041 | 266 | 8 |
140285 | 140285 | 2020-05-13 | Franklin | Louisiana | 22041 | 256 | 7 |
137291 | 137291 | 2020-05-12 | Franklin | Louisiana | 22041 | 208 | 6 |
134301 | 134301 | 2020-05-11 | Franklin | Louisiana | 22041 | 208 | 4 |
131310 | 131310 | 2020-05-10 | Franklin | Louisiana | 22041 | 206 | 4 |
128320 | 128320 | 2020-05-09 | Franklin | Louisiana | 22041 | 188 | 4 |
125333 | 125333 | 2020-05-08 | Franklin | Louisiana | 22041 | 146 | 4 |
122351 | 122351 | 2020-05-07 | Franklin | Louisiana | 22041 | 145 | 4 |
119380 | 119380 | 2020-05-06 | Franklin | Louisiana | 22041 | 146 | 4 |
116419 | 116419 | 2020-05-05 | Franklin | Louisiana | 22041 | 140 | 3 |
113537 | 113537 | 2020-05-04 | Franklin | Louisiana | 22041 | 139 | 3 |
110660 | 110660 | 2020-05-03 | Franklin | Louisiana | 22041 | 131 | 3 |
107788 | 107788 | 2020-05-02 | Franklin | Louisiana | 22041 | 131 | 3 |
104924 | 104924 | 2020-05-01 | Franklin | Louisiana | 22041 | 130 | 3 |
102063 | 102063 | 2020-04-30 | Franklin | Louisiana | 22041 | 125 | 3 |
99211 | 99211 | 2020-04-29 | Franklin | Louisiana | 22041 | 123 | 3 |
96365 | 96365 | 2020-04-28 | Franklin | Louisiana | 22041 | 121 | 3 |
93530 | 93530 | 2020-04-27 | Franklin | Louisiana | 22041 | 119 | 2 |
90709 | 90709 | 2020-04-26 | Franklin | Louisiana | 22041 | 116 | 2 |
87893 | 87893 | 2020-04-25 | Franklin | Louisiana | 22041 | 113 | 2 |
85084 | 85084 | 2020-04-24 | Franklin | Louisiana | 22041 | 108 | 2 |
82280 | 82280 | 2020-04-23 | Franklin | Louisiana | 22041 | 108 | 2 |
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);