ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 22127 and state = "Louisiana" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
272506 | 272506 | 2020-06-25 | Winn | Louisiana | 22127 | 231 | 5 |
275649 | 275649 | 2020-06-26 | Winn | Louisiana | 22127 | 238 | 5 |
278797 | 278797 | 2020-06-27 | Winn | Louisiana | 22127 | 238 | 5 |
281945 | 281945 | 2020-06-28 | Winn | Louisiana | 22127 | 241 | 5 |
285091 | 285091 | 2020-06-29 | Winn | Louisiana | 22127 | 242 | 5 |
288240 | 288240 | 2020-06-30 | Winn | Louisiana | 22127 | 242 | 5 |
291391 | 291391 | 2020-07-01 | Winn | Louisiana | 22127 | 244 | 5 |
294545 | 294545 | 2020-07-02 | Winn | Louisiana | 22127 | 247 | 5 |
297703 | 297703 | 2020-07-03 | Winn | Louisiana | 22127 | 248 | 5 |
300865 | 300865 | 2020-07-04 | Winn | Louisiana | 22127 | 248 | 5 |
304029 | 304029 | 2020-07-05 | Winn | Louisiana | 22127 | 254 | 5 |
307196 | 307196 | 2020-07-06 | Winn | Louisiana | 22127 | 258 | 5 |
310364 | 310364 | 2020-07-07 | Winn | Louisiana | 22127 | 263 | 5 |
313534 | 313534 | 2020-07-08 | Winn | Louisiana | 22127 | 270 | 5 |
316708 | 316708 | 2020-07-09 | Winn | Louisiana | 22127 | 273 | 5 |
319883 | 319883 | 2020-07-10 | Winn | Louisiana | 22127 | 283 | 5 |
323062 | 323062 | 2020-07-11 | Winn | Louisiana | 22127 | 287 | 5 |
326245 | 326245 | 2020-07-12 | Winn | Louisiana | 22127 | 290 | 5 |
329431 | 329431 | 2020-07-13 | Winn | Louisiana | 22127 | 292 | 5 |
332618 | 332618 | 2020-07-14 | Winn | Louisiana | 22127 | 295 | 5 |
335811 | 335811 | 2020-07-15 | Winn | Louisiana | 22127 | 299 | 5 |
339007 | 339007 | 2020-07-16 | Winn | Louisiana | 22127 | 308 | 5 |
342203 | 342203 | 2020-07-17 | Winn | Louisiana | 22127 | 311 | 5 |
345403 | 345403 | 2020-07-18 | Winn | Louisiana | 22127 | 311 | 5 |
348604 | 348604 | 2020-07-19 | Winn | Louisiana | 22127 | 317 | 5 |
351804 | 351804 | 2020-07-20 | Winn | Louisiana | 22127 | 327 | 5 |
355006 | 355006 | 2020-07-21 | Winn | Louisiana | 22127 | 334 | 5 |
358209 | 358209 | 2020-07-22 | Winn | Louisiana | 22127 | 339 | 5 |
361414 | 361414 | 2020-07-23 | Winn | Louisiana | 22127 | 347 | 5 |
364621 | 364621 | 2020-07-24 | Winn | Louisiana | 22127 | 351 | 5 |
367828 | 367828 | 2020-07-25 | Winn | Louisiana | 22127 | 351 | 5 |
371038 | 371038 | 2020-07-26 | Winn | Louisiana | 22127 | 358 | 7 |
374250 | 374250 | 2020-07-27 | Winn | Louisiana | 22127 | 358 | 7 |
377465 | 377465 | 2020-07-28 | Winn | Louisiana | 22127 | 363 | 8 |
380682 | 380682 | 2020-07-29 | Winn | Louisiana | 22127 | 364 | 7 |
383899 | 383899 | 2020-07-30 | Winn | Louisiana | 22127 | 371 | 7 |
387117 | 387117 | 2020-07-31 | Winn | Louisiana | 22127 | 374 | 7 |
390334 | 390334 | 2020-08-01 | Winn | Louisiana | 22127 | 374 | 7 |
393551 | 393551 | 2020-08-02 | Winn | Louisiana | 22127 | 386 | 7 |
396767 | 396767 | 2020-08-03 | Winn | Louisiana | 22127 | 398 | 7 |
399982 | 399982 | 2020-08-04 | Winn | Louisiana | 22127 | 399 | 7 |
403199 | 403199 | 2020-08-05 | Winn | Louisiana | 22127 | 401 | 7 |
406417 | 406417 | 2020-08-06 | Winn | Louisiana | 22127 | 410 | 7 |
409637 | 409637 | 2020-08-07 | Winn | Louisiana | 22127 | 413 | 7 |
412857 | 412857 | 2020-08-08 | Winn | Louisiana | 22127 | 413 | 7 |
416077 | 416077 | 2020-08-09 | Winn | Louisiana | 22127 | 423 | 7 |
419298 | 419298 | 2020-08-10 | Winn | Louisiana | 22127 | 425 | 7 |
422520 | 422520 | 2020-08-11 | Winn | Louisiana | 22127 | 426 | 7 |
425741 | 425741 | 2020-08-12 | Winn | Louisiana | 22127 | 450 | 7 |
428965 | 428965 | 2020-08-13 | Winn | Louisiana | 22127 | 453 | 7 |
432193 | 432193 | 2020-08-14 | Winn | Louisiana | 22127 | 467 | 7 |
435418 | 435418 | 2020-08-15 | Winn | Louisiana | 22127 | 467 | 7 |
438643 | 438643 | 2020-08-16 | Winn | Louisiana | 22127 | 479 | 9 |
441870 | 441870 | 2020-08-17 | Winn | Louisiana | 22127 | 492 | 9 |
445096 | 445096 | 2020-08-18 | Winn | Louisiana | 22127 | 495 | 10 |
448323 | 448323 | 2020-08-19 | Winn | Louisiana | 22127 | 499 | 10 |
451551 | 451551 | 2020-08-20 | Winn | Louisiana | 22127 | 499 | 10 |
454779 | 454779 | 2020-08-21 | Winn | Louisiana | 22127 | 505 | 15 |
458007 | 458007 | 2020-08-22 | Winn | Louisiana | 22127 | 505 | 15 |
461234 | 461234 | 2020-08-23 | Winn | Louisiana | 22127 | 511 | 15 |
464465 | 464465 | 2020-08-24 | Winn | Louisiana | 22127 | 517 | 15 |
467694 | 467694 | 2020-08-25 | Winn | Louisiana | 22127 | 531 | 15 |
470923 | 470923 | 2020-08-26 | Winn | Louisiana | 22127 | 535 | 15 |
474155 | 474155 | 2020-08-27 | Winn | Louisiana | 22127 | 540 | 15 |
477388 | 477388 | 2020-08-28 | Winn | Louisiana | 22127 | 542 | 16 |
480621 | 480621 | 2020-08-29 | Winn | Louisiana | 22127 | 542 | 16 |
483855 | 483855 | 2020-08-30 | Winn | Louisiana | 22127 | 546 | 16 |
487090 | 487090 | 2020-08-31 | Winn | Louisiana | 22127 | 548 | 16 |
490323 | 490323 | 2020-09-01 | Winn | Louisiana | 22127 | 552 | 16 |
493557 | 493557 | 2020-09-02 | Winn | Louisiana | 22127 | 555 | 16 |
496790 | 496790 | 2020-09-03 | Winn | Louisiana | 22127 | 556 | 16 |
500024 | 500024 | 2020-09-04 | Winn | Louisiana | 22127 | 573 | 16 |
503257 | 503257 | 2020-09-05 | Winn | Louisiana | 22127 | 573 | 16 |
506491 | 506491 | 2020-09-06 | Winn | Louisiana | 22127 | 578 | 17 |
509724 | 509724 | 2020-09-07 | Winn | Louisiana | 22127 | 578 | 17 |
512956 | 512956 | 2020-09-08 | Winn | Louisiana | 22127 | 578 | 17 |
516189 | 516189 | 2020-09-09 | Winn | Louisiana | 22127 | 581 | 17 |
519424 | 519424 | 2020-09-10 | Winn | Louisiana | 22127 | 582 | 17 |
522661 | 522661 | 2020-09-11 | Winn | Louisiana | 22127 | 586 | 17 |
525897 | 525897 | 2020-09-12 | Winn | Louisiana | 22127 | 586 | 17 |
529133 | 529133 | 2020-09-13 | Winn | Louisiana | 22127 | 588 | 17 |
532370 | 532370 | 2020-09-14 | Winn | Louisiana | 22127 | 592 | 18 |
535605 | 535605 | 2020-09-15 | Winn | Louisiana | 22127 | 598 | 18 |
538842 | 538842 | 2020-09-16 | Winn | Louisiana | 22127 | 597 | 18 |
542078 | 542078 | 2020-09-17 | Winn | Louisiana | 22127 | 597 | 18 |
545314 | 545314 | 2020-09-18 | Winn | Louisiana | 22127 | 603 | 18 |
548552 | 548552 | 2020-09-19 | Winn | Louisiana | 22127 | 603 | 18 |
551791 | 551791 | 2020-09-20 | Winn | Louisiana | 22127 | 608 | 18 |
555030 | 555030 | 2020-09-21 | Winn | Louisiana | 22127 | 606 | 18 |
558267 | 558267 | 2020-09-22 | Winn | Louisiana | 22127 | 611 | 18 |
561503 | 561503 | 2020-09-23 | Winn | Louisiana | 22127 | 616 | 18 |
564743 | 564743 | 2020-09-24 | Winn | Louisiana | 22127 | 619 | 18 |
567983 | 567983 | 2020-09-25 | Winn | Louisiana | 22127 | 622 | 18 |
571225 | 571225 | 2020-09-26 | Winn | Louisiana | 22127 | 622 | 18 |
574468 | 574468 | 2020-09-27 | Winn | Louisiana | 22127 | 628 | 18 |
577710 | 577710 | 2020-09-28 | Winn | Louisiana | 22127 | 627 | 18 |
580951 | 580951 | 2020-09-29 | Winn | Louisiana | 22127 | 632 | 18 |
584191 | 584191 | 2020-09-30 | Winn | Louisiana | 22127 | 634 | 18 |
587431 | 587431 | 2020-10-01 | Winn | Louisiana | 22127 | 635 | 18 |
590672 | 590672 | 2020-10-02 | Winn | Louisiana | 22127 | 639 | 18 |
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);