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 |
---|---|---|---|---|---|---|---|
535561 | 535561 | 2020-09-15 | Franklin | Louisiana | 22041 | 1162 | 35 |
532326 | 532326 | 2020-09-14 | Franklin | Louisiana | 22041 | 1163 | 35 |
529089 | 529089 | 2020-09-13 | Franklin | Louisiana | 22041 | 1145 | 35 |
525853 | 525853 | 2020-09-12 | Franklin | Louisiana | 22041 | 1135 | 34 |
522617 | 522617 | 2020-09-11 | Franklin | Louisiana | 22041 | 1135 | 34 |
519380 | 519380 | 2020-09-10 | Franklin | Louisiana | 22041 | 1135 | 33 |
516145 | 516145 | 2020-09-09 | Franklin | Louisiana | 22041 | 1132 | 32 |
512912 | 512912 | 2020-09-08 | Franklin | Louisiana | 22041 | 1117 | 33 |
509680 | 509680 | 2020-09-07 | Franklin | Louisiana | 22041 | 1118 | 34 |
506447 | 506447 | 2020-09-06 | Franklin | Louisiana | 22041 | 1117 | 34 |
503213 | 503213 | 2020-09-05 | Franklin | Louisiana | 22041 | 1105 | 31 |
499980 | 499980 | 2020-09-04 | Franklin | Louisiana | 22041 | 1105 | 31 |
496746 | 496746 | 2020-09-03 | Franklin | Louisiana | 22041 | 1101 | 31 |
493513 | 493513 | 2020-09-02 | Franklin | Louisiana | 22041 | 1093 | 31 |
490279 | 490279 | 2020-09-01 | Franklin | Louisiana | 22041 | 1088 | 31 |
487046 | 487046 | 2020-08-31 | Franklin | Louisiana | 22041 | 1086 | 30 |
483811 | 483811 | 2020-08-30 | Franklin | Louisiana | 22041 | 1081 | 29 |
480577 | 480577 | 2020-08-29 | Franklin | Louisiana | 22041 | 1077 | 29 |
477344 | 477344 | 2020-08-28 | Franklin | Louisiana | 22041 | 1077 | 29 |
474111 | 474111 | 2020-08-27 | Franklin | Louisiana | 22041 | 1076 | 28 |
470879 | 470879 | 2020-08-26 | Franklin | Louisiana | 22041 | 1061 | 28 |
467650 | 467650 | 2020-08-25 | Franklin | Louisiana | 22041 | 1059 | 26 |
464421 | 464421 | 2020-08-24 | Franklin | Louisiana | 22041 | 1042 | 26 |
461190 | 461190 | 2020-08-23 | Franklin | Louisiana | 22041 | 1042 | 25 |
457963 | 457963 | 2020-08-22 | Franklin | Louisiana | 22041 | 1024 | 24 |
454735 | 454735 | 2020-08-21 | Franklin | Louisiana | 22041 | 1024 | 24 |
451507 | 451507 | 2020-08-20 | Franklin | Louisiana | 22041 | 1017 | 24 |
448279 | 448279 | 2020-08-19 | Franklin | Louisiana | 22041 | 1004 | 23 |
445052 | 445052 | 2020-08-18 | Franklin | Louisiana | 22041 | 998 | 23 |
441826 | 441826 | 2020-08-17 | Franklin | Louisiana | 22041 | 996 | 22 |
438599 | 438599 | 2020-08-16 | Franklin | Louisiana | 22041 | 993 | 22 |
435374 | 435374 | 2020-08-15 | Franklin | Louisiana | 22041 | 980 | 19 |
432149 | 432149 | 2020-08-14 | Franklin | Louisiana | 22041 | 980 | 19 |
428921 | 428921 | 2020-08-13 | Franklin | Louisiana | 22041 | 964 | 19 |
425697 | 425697 | 2020-08-12 | Franklin | Louisiana | 22041 | 954 | 19 |
422476 | 422476 | 2020-08-11 | Franklin | Louisiana | 22041 | 940 | 19 |
419254 | 419254 | 2020-08-10 | Franklin | Louisiana | 22041 | 938 | 18 |
416033 | 416033 | 2020-08-09 | Franklin | Louisiana | 22041 | 934 | 17 |
412813 | 412813 | 2020-08-08 | Franklin | Louisiana | 22041 | 896 | 17 |
409593 | 409593 | 2020-08-07 | Franklin | Louisiana | 22041 | 896 | 17 |
406373 | 406373 | 2020-08-06 | Franklin | Louisiana | 22041 | 875 | 17 |
403155 | 403155 | 2020-08-05 | Franklin | Louisiana | 22041 | 860 | 17 |
399938 | 399938 | 2020-08-04 | Franklin | Louisiana | 22041 | 850 | 17 |
396723 | 396723 | 2020-08-03 | Franklin | Louisiana | 22041 | 839 | 17 |
393507 | 393507 | 2020-08-02 | Franklin | Louisiana | 22041 | 826 | 17 |
390290 | 390290 | 2020-08-01 | Franklin | Louisiana | 22041 | 785 | 16 |
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 |
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);