ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Jefferson" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387078 | 387078 | 2020-07-31 | Jefferson | Louisiana | 22051 | 14155 | 513 |
383860 | 383860 | 2020-07-30 | Jefferson | Louisiana | 22051 | 14026 | 513 |
380643 | 380643 | 2020-07-29 | Jefferson | Louisiana | 22051 | 13872 | 510 |
377426 | 377426 | 2020-07-28 | Jefferson | Louisiana | 22051 | 13780 | 510 |
374211 | 374211 | 2020-07-27 | Jefferson | Louisiana | 22051 | 13680 | 510 |
370999 | 370999 | 2020-07-26 | Jefferson | Louisiana | 22051 | 13448 | 510 |
367789 | 367789 | 2020-07-25 | Jefferson | Louisiana | 22051 | 13128 | 507 |
364582 | 364582 | 2020-07-24 | Jefferson | Louisiana | 22051 | 13128 | 507 |
361375 | 361375 | 2020-07-23 | Jefferson | Louisiana | 22051 | 12945 | 507 |
358170 | 358170 | 2020-07-22 | Jefferson | Louisiana | 22051 | 12812 | 507 |
354967 | 354967 | 2020-07-21 | Jefferson | Louisiana | 22051 | 12637 | 504 |
351765 | 351765 | 2020-07-20 | Jefferson | Louisiana | 22051 | 12486 | 501 |
348565 | 348565 | 2020-07-19 | Jefferson | Louisiana | 22051 | 12254 | 500 |
345364 | 345364 | 2020-07-18 | Jefferson | Louisiana | 22051 | 12030 | 498 |
342164 | 342164 | 2020-07-17 | Jefferson | Louisiana | 22051 | 12030 | 498 |
338968 | 338968 | 2020-07-16 | Jefferson | Louisiana | 22051 | 11836 | 497 |
335772 | 335772 | 2020-07-15 | Jefferson | Louisiana | 22051 | 11614 | 495 |
332579 | 332579 | 2020-07-14 | Jefferson | Louisiana | 22051 | 11450 | 495 |
329392 | 329392 | 2020-07-13 | Jefferson | Louisiana | 22051 | 11256 | 495 |
326206 | 326206 | 2020-07-12 | Jefferson | Louisiana | 22051 | 11100 | 493 |
323023 | 323023 | 2020-07-11 | Jefferson | Louisiana | 22051 | 10995 | 491 |
319844 | 319844 | 2020-07-10 | Jefferson | Louisiana | 22051 | 10812 | 490 |
316669 | 316669 | 2020-07-09 | Jefferson | Louisiana | 22051 | 10544 | 489 |
313495 | 313495 | 2020-07-08 | Jefferson | Louisiana | 22051 | 10452 | 488 |
310325 | 310325 | 2020-07-07 | Jefferson | Louisiana | 22051 | 10272 | 488 |
307157 | 307157 | 2020-07-06 | Jefferson | Louisiana | 22051 | 10097 | 487 |
303990 | 303990 | 2020-07-05 | Jefferson | Louisiana | 22051 | 10024 | 487 |
300826 | 300826 | 2020-07-04 | Jefferson | Louisiana | 22051 | 9874 | 486 |
297664 | 297664 | 2020-07-03 | Jefferson | Louisiana | 22051 | 9874 | 486 |
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 |
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);