ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 22051 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294506 | 294506 | 2020-07-02 | Jefferson | Louisiana | 22051 | 9712 | 486 |
291352 | 291352 | 2020-07-01 | Jefferson | Louisiana | 22051 | 9637 | 485 |
288201 | 288201 | 2020-06-30 | Jefferson | Louisiana | 22051 | 9489 | 484 |
285052 | 285052 | 2020-06-29 | Jefferson | Louisiana | 22051 | 9403 | 483 |
281906 | 281906 | 2020-06-28 | Jefferson | Louisiana | 22051 | 9342 | 483 |
278758 | 278758 | 2020-06-27 | Jefferson | Louisiana | 22051 | 9169 | 481 |
275610 | 275610 | 2020-06-26 | Jefferson | Louisiana | 22051 | 9169 | 481 |
272467 | 272467 | 2020-06-25 | Jefferson | Louisiana | 22051 | 9074 | 480 |
269331 | 269331 | 2020-06-24 | Jefferson | Louisiana | 22051 | 9003 | 479 |
266198 | 266198 | 2020-06-23 | Jefferson | Louisiana | 22051 | 8888 | 479 |
263071 | 263071 | 2020-06-22 | Jefferson | Louisiana | 22051 | 8741 | 477 |
259942 | 259942 | 2020-06-21 | Jefferson | Louisiana | 22051 | 8681 | 477 |
256816 | 256816 | 2020-06-20 | Jefferson | Louisiana | 22051 | 8647 | 477 |
253696 | 253696 | 2020-06-19 | Jefferson | Louisiana | 22051 | 8542 | 474 |
250581 | 250581 | 2020-06-18 | Jefferson | Louisiana | 22051 | 8507 | 472 |
247469 | 247469 | 2020-06-17 | Jefferson | Louisiana | 22051 | 8507 | 472 |
244356 | 244356 | 2020-06-16 | Jefferson | Louisiana | 22051 | 8468 | 471 |
241245 | 241245 | 2020-06-15 | Jefferson | Louisiana | 22051 | 8416 | 467 |
238136 | 238136 | 2020-06-14 | Jefferson | Louisiana | 22051 | 8379 | 466 |
235029 | 235029 | 2020-06-13 | Jefferson | Louisiana | 22051 | 8339 | 465 |
231924 | 231924 | 2020-06-12 | Jefferson | Louisiana | 22051 | 8091 | 465 |
228820 | 228820 | 2020-06-11 | Jefferson | Louisiana | 22051 | 8032 | 464 |
225718 | 225718 | 2020-06-10 | Jefferson | Louisiana | 22051 | 7971 | 463 |
222622 | 222622 | 2020-06-09 | Jefferson | Louisiana | 22051 | 7940 | 462 |
219527 | 219527 | 2020-06-08 | Jefferson | Louisiana | 22051 | 7885 | 462 |
216435 | 216435 | 2020-06-07 | Jefferson | Louisiana | 22051 | 7862 | 459 |
213348 | 213348 | 2020-06-06 | Jefferson | Louisiana | 22051 | 7831 | 458 |
210263 | 210263 | 2020-06-05 | Jefferson | Louisiana | 22051 | 7803 | 457 |
207182 | 207182 | 2020-06-04 | Jefferson | Louisiana | 22051 | 7763 | 455 |
204101 | 204101 | 2020-06-03 | Jefferson | Louisiana | 22051 | 7738 | 454 |
201024 | 201024 | 2020-06-02 | Jefferson | Louisiana | 22051 | 7711 | 453 |
197952 | 197952 | 2020-06-01 | Jefferson | Louisiana | 22051 | 7652 | 451 |
194881 | 194881 | 2020-05-31 | Jefferson | Louisiana | 22051 | 7584 | 450 |
191813 | 191813 | 2020-05-30 | Jefferson | Louisiana | 22051 | 7536 | 447 |
188749 | 188749 | 2020-05-29 | Jefferson | Louisiana | 22051 | 7424 | 446 |
185691 | 185691 | 2020-05-28 | Jefferson | Louisiana | 22051 | 7424 | 441 |
182636 | 182636 | 2020-05-27 | Jefferson | Louisiana | 22051 | 7394 | 438 |
179591 | 179591 | 2020-05-26 | Jefferson | Louisiana | 22051 | 7332 | 438 |
176547 | 176547 | 2020-05-25 | Jefferson | Louisiana | 22051 | 7298 | 432 |
173503 | 173503 | 2020-05-24 | Jefferson | Louisiana | 22051 | 7248 | 432 |
170462 | 170462 | 2020-05-23 | Jefferson | Louisiana | 22051 | 7233 | 432 |
167424 | 167424 | 2020-05-22 | Jefferson | Louisiana | 22051 | 7232 | 432 |
164388 | 164388 | 2020-05-21 | Jefferson | Louisiana | 22051 | 7175 | 432 |
161359 | 161359 | 2020-05-20 | Jefferson | Louisiana | 22051 | 7128 | 431 |
158333 | 158333 | 2020-05-19 | Jefferson | Louisiana | 22051 | 7095 | 429 |
155315 | 155315 | 2020-05-18 | Jefferson | Louisiana | 22051 | 7059 | 430 |
152301 | 152301 | 2020-05-17 | Jefferson | Louisiana | 22051 | 7039 | 430 |
149290 | 149290 | 2020-05-16 | Jefferson | Louisiana | 22051 | 6982 | 427 |
146285 | 146285 | 2020-05-15 | Jefferson | Louisiana | 22051 | 6897 | 424 |
143285 | 143285 | 2020-05-14 | Jefferson | Louisiana | 22051 | 6860 | 423 |
140290 | 140290 | 2020-05-13 | Jefferson | Louisiana | 22051 | 6833 | 408 |
137296 | 137296 | 2020-05-12 | Jefferson | Louisiana | 22051 | 6789 | 405 |
134306 | 134306 | 2020-05-11 | Jefferson | Louisiana | 22051 | 6755 | 402 |
131315 | 131315 | 2020-05-10 | Jefferson | Louisiana | 22051 | 6709 | 397 |
128325 | 128325 | 2020-05-09 | Jefferson | Louisiana | 22051 | 6679 | 396 |
125338 | 125338 | 2020-05-08 | Jefferson | Louisiana | 22051 | 6610 | 392 |
122356 | 122356 | 2020-05-07 | Jefferson | Louisiana | 22051 | 6588 | 391 |
119385 | 119385 | 2020-05-06 | Jefferson | Louisiana | 22051 | 6554 | 387 |
116424 | 116424 | 2020-05-05 | Jefferson | Louisiana | 22051 | 6491 | 381 |
113542 | 113542 | 2020-05-04 | Jefferson | Louisiana | 22051 | 6426 | 377 |
110665 | 110665 | 2020-05-03 | Jefferson | Louisiana | 22051 | 6388 | 371 |
107793 | 107793 | 2020-05-02 | Jefferson | Louisiana | 22051 | 6362 | 369 |
104929 | 104929 | 2020-05-01 | Jefferson | Louisiana | 22051 | 6305 | 368 |
102068 | 102068 | 2020-04-30 | Jefferson | Louisiana | 22051 | 6197 | 346 |
99216 | 99216 | 2020-04-29 | Jefferson | Louisiana | 22051 | 6173 | 340 |
96370 | 96370 | 2020-04-28 | Jefferson | Louisiana | 22051 | 6135 | 340 |
93535 | 93535 | 2020-04-27 | Jefferson | Louisiana | 22051 | 6104 | 331 |
90714 | 90714 | 2020-04-26 | Jefferson | Louisiana | 22051 | 6059 | 329 |
87898 | 87898 | 2020-04-25 | Jefferson | Louisiana | 22051 | 6007 | 325 |
85089 | 85089 | 2020-04-24 | Jefferson | Louisiana | 22051 | 5985 | 323 |
82285 | 82285 | 2020-04-23 | Jefferson | Louisiana | 22051 | 5929 | 306 |
79489 | 79489 | 2020-04-22 | Jefferson | Louisiana | 22051 | 5860 | 297 |
76703 | 76703 | 2020-04-21 | Jefferson | Louisiana | 22051 | 5802 | 288 |
73923 | 73923 | 2020-04-20 | Jefferson | Louisiana | 22051 | 5761 | 286 |
71151 | 71151 | 2020-04-19 | Jefferson | Louisiana | 22051 | 5592 | 282 |
68388 | 68388 | 2020-04-18 | Jefferson | Louisiana | 22051 | 5543 | 275 |
65639 | 65639 | 2020-04-17 | Jefferson | Louisiana | 22051 | 5476 | 269 |
62900 | 62900 | 2020-04-16 | Jefferson | Louisiana | 22051 | 5346 | 261 |
60179 | 60179 | 2020-04-15 | Jefferson | Louisiana | 22051 | 5265 | 247 |
57471 | 57471 | 2020-04-14 | Jefferson | Louisiana | 22051 | 5188 | 210 |
54773 | 54773 | 2020-04-13 | Jefferson | Louisiana | 22051 | 5088 | 186 |
52092 | 52092 | 2020-04-12 | Jefferson | Louisiana | 22051 | 4990 | 173 |
49422 | 49422 | 2020-04-11 | Jefferson | Louisiana | 22051 | 4877 | 170 |
46781 | 46781 | 2020-04-10 | Jefferson | Louisiana | 22051 | 4678 | 165 |
44173 | 44173 | 2020-04-09 | Jefferson | Louisiana | 22051 | 4480 | 158 |
41597 | 41597 | 2020-04-08 | Jefferson | Louisiana | 22051 | 4092 | 149 |
39045 | 39045 | 2020-04-07 | Jefferson | Louisiana | 22051 | 3922 | 137 |
36537 | 36537 | 2020-04-06 | Jefferson | Louisiana | 22051 | 3530 | 121 |
34079 | 34079 | 2020-04-05 | Jefferson | Louisiana | 22051 | 3088 | 113 |
31654 | 31654 | 2020-04-04 | Jefferson | Louisiana | 22051 | 3008 | 95 |
29276 | 29276 | 2020-04-03 | Jefferson | Louisiana | 22051 | 2495 | 85 |
26959 | 26959 | 2020-04-02 | Jefferson | Louisiana | 22051 | 2178 | 73 |
24708 | 24708 | 2020-04-01 | Jefferson | Louisiana | 22051 | 1433 | 64 |
22532 | 22532 | 2020-03-31 | Jefferson | Louisiana | 22051 | 1193 | 57 |
20424 | 20424 | 2020-03-30 | Jefferson | Louisiana | 22051 | 838 | 37 |
18408 | 18408 | 2020-03-29 | Jefferson | Louisiana | 22051 | 761 | 28 |
16496 | 16496 | 2020-03-28 | Jefferson | Louisiana | 22051 | 744 | 26 |
14676 | 14676 | 2020-03-27 | Jefferson | Louisiana | 22051 | 548 | 24 |
12969 | 12969 | 2020-03-26 | Jefferson | Louisiana | 22051 | 458 | 12 |
11393 | 11393 | 2020-03-25 | Jefferson | Louisiana | 22051 | 359 | 7 |
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);