ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Franklin" and fips = 22041 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16491 | 16491 | 2020-03-28 | Franklin | Louisiana | 22041 | 4 | 0 |
18403 | 18403 | 2020-03-29 | Franklin | Louisiana | 22041 | 4 | 0 |
20419 | 20419 | 2020-03-30 | Franklin | Louisiana | 22041 | 5 | 0 |
22527 | 22527 | 2020-03-31 | Franklin | Louisiana | 22041 | 5 | 0 |
24703 | 24703 | 2020-04-01 | Franklin | Louisiana | 22041 | 5 | 0 |
26954 | 26954 | 2020-04-02 | Franklin | Louisiana | 22041 | 5 | 0 |
29271 | 29271 | 2020-04-03 | Franklin | Louisiana | 22041 | 10 | 0 |
31649 | 31649 | 2020-04-04 | Franklin | Louisiana | 22041 | 19 | 0 |
34074 | 34074 | 2020-04-05 | Franklin | Louisiana | 22041 | 25 | 0 |
36532 | 36532 | 2020-04-06 | Franklin | Louisiana | 22041 | 28 | 0 |
39040 | 39040 | 2020-04-07 | Franklin | Louisiana | 22041 | 28 | 0 |
41592 | 41592 | 2020-04-08 | Franklin | Louisiana | 22041 | 30 | 0 |
44168 | 44168 | 2020-04-09 | Franklin | Louisiana | 22041 | 37 | 0 |
46776 | 46776 | 2020-04-10 | Franklin | Louisiana | 22041 | 40 | 1 |
49417 | 49417 | 2020-04-11 | Franklin | Louisiana | 22041 | 47 | 1 |
52087 | 52087 | 2020-04-12 | Franklin | Louisiana | 22041 | 48 | 1 |
54768 | 54768 | 2020-04-13 | Franklin | Louisiana | 22041 | 49 | 1 |
57466 | 57466 | 2020-04-14 | Franklin | Louisiana | 22041 | 49 | 2 |
60174 | 60174 | 2020-04-15 | Franklin | Louisiana | 22041 | 53 | 2 |
62895 | 62895 | 2020-04-16 | Franklin | Louisiana | 22041 | 58 | 2 |
65634 | 65634 | 2020-04-17 | Franklin | Louisiana | 22041 | 67 | 2 |
68383 | 68383 | 2020-04-18 | Franklin | Louisiana | 22041 | 78 | 2 |
71146 | 71146 | 2020-04-19 | Franklin | Louisiana | 22041 | 81 | 2 |
73918 | 73918 | 2020-04-20 | Franklin | Louisiana | 22041 | 83 | 2 |
76698 | 76698 | 2020-04-21 | Franklin | Louisiana | 22041 | 87 | 2 |
79484 | 79484 | 2020-04-22 | Franklin | Louisiana | 22041 | 95 | 2 |
82280 | 82280 | 2020-04-23 | Franklin | Louisiana | 22041 | 108 | 2 |
85084 | 85084 | 2020-04-24 | Franklin | Louisiana | 22041 | 108 | 2 |
87893 | 87893 | 2020-04-25 | Franklin | Louisiana | 22041 | 113 | 2 |
90709 | 90709 | 2020-04-26 | Franklin | Louisiana | 22041 | 116 | 2 |
93530 | 93530 | 2020-04-27 | Franklin | Louisiana | 22041 | 119 | 2 |
96365 | 96365 | 2020-04-28 | Franklin | Louisiana | 22041 | 121 | 3 |
99211 | 99211 | 2020-04-29 | Franklin | Louisiana | 22041 | 123 | 3 |
102063 | 102063 | 2020-04-30 | Franklin | Louisiana | 22041 | 125 | 3 |
104924 | 104924 | 2020-05-01 | Franklin | Louisiana | 22041 | 130 | 3 |
107788 | 107788 | 2020-05-02 | Franklin | Louisiana | 22041 | 131 | 3 |
110660 | 110660 | 2020-05-03 | Franklin | Louisiana | 22041 | 131 | 3 |
113537 | 113537 | 2020-05-04 | Franklin | Louisiana | 22041 | 139 | 3 |
116419 | 116419 | 2020-05-05 | Franklin | Louisiana | 22041 | 140 | 3 |
119380 | 119380 | 2020-05-06 | Franklin | Louisiana | 22041 | 146 | 4 |
122351 | 122351 | 2020-05-07 | Franklin | Louisiana | 22041 | 145 | 4 |
125333 | 125333 | 2020-05-08 | Franklin | Louisiana | 22041 | 146 | 4 |
128320 | 128320 | 2020-05-09 | Franklin | Louisiana | 22041 | 188 | 4 |
131310 | 131310 | 2020-05-10 | Franklin | Louisiana | 22041 | 206 | 4 |
134301 | 134301 | 2020-05-11 | Franklin | Louisiana | 22041 | 208 | 4 |
137291 | 137291 | 2020-05-12 | Franklin | Louisiana | 22041 | 208 | 6 |
140285 | 140285 | 2020-05-13 | Franklin | Louisiana | 22041 | 256 | 7 |
143280 | 143280 | 2020-05-14 | Franklin | Louisiana | 22041 | 266 | 8 |
146280 | 146280 | 2020-05-15 | Franklin | Louisiana | 22041 | 266 | 8 |
149285 | 149285 | 2020-05-16 | Franklin | Louisiana | 22041 | 268 | 8 |
152296 | 152296 | 2020-05-17 | Franklin | Louisiana | 22041 | 273 | 8 |
155310 | 155310 | 2020-05-18 | Franklin | Louisiana | 22041 | 273 | 8 |
158328 | 158328 | 2020-05-19 | Franklin | Louisiana | 22041 | 274 | 9 |
161354 | 161354 | 2020-05-20 | Franklin | Louisiana | 22041 | 274 | 9 |
164383 | 164383 | 2020-05-21 | Franklin | Louisiana | 22041 | 287 | 9 |
167419 | 167419 | 2020-05-22 | Franklin | Louisiana | 22041 | 287 | 10 |
170457 | 170457 | 2020-05-23 | Franklin | Louisiana | 22041 | 287 | 10 |
173498 | 173498 | 2020-05-24 | Franklin | Louisiana | 22041 | 288 | 10 |
176542 | 176542 | 2020-05-25 | Franklin | Louisiana | 22041 | 294 | 10 |
179586 | 179586 | 2020-05-26 | Franklin | Louisiana | 22041 | 297 | 10 |
182631 | 182631 | 2020-05-27 | Franklin | Louisiana | 22041 | 310 | 10 |
185686 | 185686 | 2020-05-28 | Franklin | Louisiana | 22041 | 311 | 10 |
188744 | 188744 | 2020-05-29 | Franklin | Louisiana | 22041 | 311 | 10 |
191808 | 191808 | 2020-05-30 | Franklin | Louisiana | 22041 | 314 | 10 |
194876 | 194876 | 2020-05-31 | Franklin | Louisiana | 22041 | 332 | 10 |
197947 | 197947 | 2020-06-01 | Franklin | Louisiana | 22041 | 376 | 10 |
201019 | 201019 | 2020-06-02 | Franklin | Louisiana | 22041 | 377 | 10 |
204096 | 204096 | 2020-06-03 | Franklin | Louisiana | 22041 | 377 | 12 |
207177 | 207177 | 2020-06-04 | Franklin | Louisiana | 22041 | 378 | 12 |
210258 | 210258 | 2020-06-05 | Franklin | Louisiana | 22041 | 383 | 12 |
213343 | 213343 | 2020-06-06 | Franklin | Louisiana | 22041 | 384 | 12 |
216430 | 216430 | 2020-06-07 | Franklin | Louisiana | 22041 | 386 | 12 |
219522 | 219522 | 2020-06-08 | Franklin | Louisiana | 22041 | 389 | 12 |
222617 | 222617 | 2020-06-09 | Franklin | Louisiana | 22041 | 390 | 12 |
225713 | 225713 | 2020-06-10 | Franklin | Louisiana | 22041 | 391 | 12 |
228815 | 228815 | 2020-06-11 | Franklin | Louisiana | 22041 | 395 | 13 |
231919 | 231919 | 2020-06-12 | Franklin | Louisiana | 22041 | 395 | 13 |
235024 | 235024 | 2020-06-13 | Franklin | Louisiana | 22041 | 415 | 13 |
238131 | 238131 | 2020-06-14 | Franklin | Louisiana | 22041 | 415 | 13 |
241240 | 241240 | 2020-06-15 | Franklin | Louisiana | 22041 | 424 | 13 |
244351 | 244351 | 2020-06-16 | Franklin | Louisiana | 22041 | 425 | 14 |
247464 | 247464 | 2020-06-17 | Franklin | Louisiana | 22041 | 439 | 14 |
250576 | 250576 | 2020-06-18 | Franklin | Louisiana | 22041 | 439 | 14 |
253691 | 253691 | 2020-06-19 | Franklin | Louisiana | 22041 | 412 | 14 |
256811 | 256811 | 2020-06-20 | Franklin | Louisiana | 22041 | 414 | 14 |
259937 | 259937 | 2020-06-21 | Franklin | Louisiana | 22041 | 416 | 14 |
263066 | 263066 | 2020-06-22 | Franklin | Louisiana | 22041 | 421 | 14 |
266193 | 266193 | 2020-06-23 | Franklin | Louisiana | 22041 | 443 | 14 |
269326 | 269326 | 2020-06-24 | Franklin | Louisiana | 22041 | 447 | 14 |
272462 | 272462 | 2020-06-25 | Franklin | Louisiana | 22041 | 448 | 14 |
275605 | 275605 | 2020-06-26 | Franklin | Louisiana | 22041 | 455 | 14 |
278753 | 278753 | 2020-06-27 | Franklin | Louisiana | 22041 | 455 | 14 |
281901 | 281901 | 2020-06-28 | Franklin | Louisiana | 22041 | 464 | 14 |
285047 | 285047 | 2020-06-29 | Franklin | Louisiana | 22041 | 468 | 14 |
288196 | 288196 | 2020-06-30 | Franklin | Louisiana | 22041 | 467 | 14 |
291347 | 291347 | 2020-07-01 | Franklin | Louisiana | 22041 | 471 | 14 |
294501 | 294501 | 2020-07-02 | Franklin | Louisiana | 22041 | 475 | 14 |
297659 | 297659 | 2020-07-03 | Franklin | Louisiana | 22041 | 483 | 14 |
300821 | 300821 | 2020-07-04 | Franklin | Louisiana | 22041 | 483 | 14 |
303985 | 303985 | 2020-07-05 | Franklin | Louisiana | 22041 | 501 | 14 |
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);