ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lincoln" and fips = 22061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535571 | 535571 | 2020-09-15 | Lincoln | Louisiana | 22061 | 1048 | 44 |
532336 | 532336 | 2020-09-14 | Lincoln | Louisiana | 22061 | 1057 | 43 |
529099 | 529099 | 2020-09-13 | Lincoln | Louisiana | 22061 | 1043 | 43 |
525863 | 525863 | 2020-09-12 | Lincoln | Louisiana | 22061 | 1008 | 43 |
522627 | 522627 | 2020-09-11 | Lincoln | Louisiana | 22061 | 1008 | 43 |
519390 | 519390 | 2020-09-10 | Lincoln | Louisiana | 22061 | 996 | 43 |
516155 | 516155 | 2020-09-09 | Lincoln | Louisiana | 22061 | 989 | 42 |
512922 | 512922 | 2020-09-08 | Lincoln | Louisiana | 22061 | 969 | 42 |
509690 | 509690 | 2020-09-07 | Lincoln | Louisiana | 22061 | 971 | 42 |
506457 | 506457 | 2020-09-06 | Lincoln | Louisiana | 22061 | 955 | 41 |
503223 | 503223 | 2020-09-05 | Lincoln | Louisiana | 22061 | 941 | 40 |
499990 | 499990 | 2020-09-04 | Lincoln | Louisiana | 22061 | 941 | 40 |
496756 | 496756 | 2020-09-03 | Lincoln | Louisiana | 22061 | 937 | 40 |
493523 | 493523 | 2020-09-02 | Lincoln | Louisiana | 22061 | 930 | 40 |
490289 | 490289 | 2020-09-01 | Lincoln | Louisiana | 22061 | 912 | 40 |
487056 | 487056 | 2020-08-31 | Lincoln | Louisiana | 22061 | 906 | 40 |
483821 | 483821 | 2020-08-30 | Lincoln | Louisiana | 22061 | 905 | 40 |
480587 | 480587 | 2020-08-29 | Lincoln | Louisiana | 22061 | 896 | 39 |
477354 | 477354 | 2020-08-28 | Lincoln | Louisiana | 22061 | 896 | 39 |
474121 | 474121 | 2020-08-27 | Lincoln | Louisiana | 22061 | 887 | 39 |
470889 | 470889 | 2020-08-26 | Lincoln | Louisiana | 22061 | 884 | 39 |
467660 | 467660 | 2020-08-25 | Lincoln | Louisiana | 22061 | 883 | 39 |
464431 | 464431 | 2020-08-24 | Lincoln | Louisiana | 22061 | 885 | 39 |
461200 | 461200 | 2020-08-23 | Lincoln | Louisiana | 22061 | 881 | 39 |
457973 | 457973 | 2020-08-22 | Lincoln | Louisiana | 22061 | 867 | 38 |
454745 | 454745 | 2020-08-21 | Lincoln | Louisiana | 22061 | 867 | 38 |
451517 | 451517 | 2020-08-20 | Lincoln | Louisiana | 22061 | 867 | 40 |
448289 | 448289 | 2020-08-19 | Lincoln | Louisiana | 22061 | 867 | 39 |
445062 | 445062 | 2020-08-18 | Lincoln | Louisiana | 22061 | 857 | 36 |
441836 | 441836 | 2020-08-17 | Lincoln | Louisiana | 22061 | 856 | 35 |
438609 | 438609 | 2020-08-16 | Lincoln | Louisiana | 22061 | 857 | 35 |
435384 | 435384 | 2020-08-15 | Lincoln | Louisiana | 22061 | 839 | 34 |
432159 | 432159 | 2020-08-14 | Lincoln | Louisiana | 22061 | 839 | 34 |
428931 | 428931 | 2020-08-13 | Lincoln | Louisiana | 22061 | 819 | 32 |
425707 | 425707 | 2020-08-12 | Lincoln | Louisiana | 22061 | 815 | 32 |
422486 | 422486 | 2020-08-11 | Lincoln | Louisiana | 22061 | 806 | 31 |
419264 | 419264 | 2020-08-10 | Lincoln | Louisiana | 22061 | 805 | 31 |
416043 | 416043 | 2020-08-09 | Lincoln | Louisiana | 22061 | 797 | 31 |
412823 | 412823 | 2020-08-08 | Lincoln | Louisiana | 22061 | 766 | 29 |
409603 | 409603 | 2020-08-07 | Lincoln | Louisiana | 22061 | 766 | 29 |
406383 | 406383 | 2020-08-06 | Lincoln | Louisiana | 22061 | 754 | 28 |
403165 | 403165 | 2020-08-05 | Lincoln | Louisiana | 22061 | 744 | 24 |
399948 | 399948 | 2020-08-04 | Lincoln | Louisiana | 22061 | 733 | 24 |
396733 | 396733 | 2020-08-03 | Lincoln | Louisiana | 22061 | 720 | 24 |
393517 | 393517 | 2020-08-02 | Lincoln | Louisiana | 22061 | 716 | 24 |
390300 | 390300 | 2020-08-01 | Lincoln | Louisiana | 22061 | 695 | 23 |
387083 | 387083 | 2020-07-31 | Lincoln | Louisiana | 22061 | 695 | 23 |
383865 | 383865 | 2020-07-30 | Lincoln | Louisiana | 22061 | 672 | 23 |
380648 | 380648 | 2020-07-29 | Lincoln | Louisiana | 22061 | 662 | 24 |
377431 | 377431 | 2020-07-28 | Lincoln | Louisiana | 22061 | 642 | 24 |
374216 | 374216 | 2020-07-27 | Lincoln | Louisiana | 22061 | 641 | 23 |
371004 | 371004 | 2020-07-26 | Lincoln | Louisiana | 22061 | 639 | 23 |
367794 | 367794 | 2020-07-25 | Lincoln | Louisiana | 22061 | 610 | 22 |
364587 | 364587 | 2020-07-24 | Lincoln | Louisiana | 22061 | 610 | 22 |
361380 | 361380 | 2020-07-23 | Lincoln | Louisiana | 22061 | 571 | 20 |
358175 | 358175 | 2020-07-22 | Lincoln | Louisiana | 22061 | 568 | 20 |
354972 | 354972 | 2020-07-21 | Lincoln | Louisiana | 22061 | 556 | 20 |
351770 | 351770 | 2020-07-20 | Lincoln | Louisiana | 22061 | 558 | 20 |
348570 | 348570 | 2020-07-19 | Lincoln | Louisiana | 22061 | 505 | 20 |
345369 | 345369 | 2020-07-18 | Lincoln | Louisiana | 22061 | 482 | 19 |
342169 | 342169 | 2020-07-17 | Lincoln | Louisiana | 22061 | 482 | 19 |
338973 | 338973 | 2020-07-16 | Lincoln | Louisiana | 22061 | 473 | 19 |
335777 | 335777 | 2020-07-15 | Lincoln | Louisiana | 22061 | 468 | 19 |
332584 | 332584 | 2020-07-14 | Lincoln | Louisiana | 22061 | 460 | 19 |
329397 | 329397 | 2020-07-13 | Lincoln | Louisiana | 22061 | 442 | 19 |
326211 | 326211 | 2020-07-12 | Lincoln | Louisiana | 22061 | 438 | 19 |
323028 | 323028 | 2020-07-11 | Lincoln | Louisiana | 22061 | 432 | 19 |
319849 | 319849 | 2020-07-10 | Lincoln | Louisiana | 22061 | 401 | 19 |
316674 | 316674 | 2020-07-09 | Lincoln | Louisiana | 22061 | 383 | 19 |
313500 | 313500 | 2020-07-08 | Lincoln | Louisiana | 22061 | 366 | 19 |
310330 | 310330 | 2020-07-07 | Lincoln | Louisiana | 22061 | 354 | 19 |
307162 | 307162 | 2020-07-06 | Lincoln | Louisiana | 22061 | 353 | 19 |
303995 | 303995 | 2020-07-05 | Lincoln | Louisiana | 22061 | 350 | 19 |
300831 | 300831 | 2020-07-04 | Lincoln | Louisiana | 22061 | 344 | 19 |
297669 | 297669 | 2020-07-03 | Lincoln | Louisiana | 22061 | 344 | 19 |
294511 | 294511 | 2020-07-02 | Lincoln | Louisiana | 22061 | 338 | 19 |
291357 | 291357 | 2020-07-01 | Lincoln | Louisiana | 22061 | 329 | 18 |
288206 | 288206 | 2020-06-30 | Lincoln | Louisiana | 22061 | 323 | 18 |
285057 | 285057 | 2020-06-29 | Lincoln | Louisiana | 22061 | 314 | 18 |
281911 | 281911 | 2020-06-28 | Lincoln | Louisiana | 22061 | 312 | 18 |
278763 | 278763 | 2020-06-27 | Lincoln | Louisiana | 22061 | 300 | 18 |
275615 | 275615 | 2020-06-26 | Lincoln | Louisiana | 22061 | 300 | 18 |
272472 | 272472 | 2020-06-25 | Lincoln | Louisiana | 22061 | 294 | 18 |
269336 | 269336 | 2020-06-24 | Lincoln | Louisiana | 22061 | 290 | 18 |
266203 | 266203 | 2020-06-23 | Lincoln | Louisiana | 22061 | 281 | 18 |
263076 | 263076 | 2020-06-22 | Lincoln | Louisiana | 22061 | 274 | 18 |
259947 | 259947 | 2020-06-21 | Lincoln | Louisiana | 22061 | 274 | 19 |
256821 | 256821 | 2020-06-20 | Lincoln | Louisiana | 22061 | 273 | 19 |
253701 | 253701 | 2020-06-19 | Lincoln | Louisiana | 22061 | 269 | 19 |
250586 | 250586 | 2020-06-18 | Lincoln | Louisiana | 22061 | 259 | 18 |
247474 | 247474 | 2020-06-17 | Lincoln | Louisiana | 22061 | 259 | 18 |
244361 | 244361 | 2020-06-16 | Lincoln | Louisiana | 22061 | 248 | 18 |
241250 | 241250 | 2020-06-15 | Lincoln | Louisiana | 22061 | 241 | 18 |
238141 | 238141 | 2020-06-14 | Lincoln | Louisiana | 22061 | 235 | 18 |
235034 | 235034 | 2020-06-13 | Lincoln | Louisiana | 22061 | 227 | 18 |
231929 | 231929 | 2020-06-12 | Lincoln | Louisiana | 22061 | 202 | 18 |
228825 | 228825 | 2020-06-11 | Lincoln | Louisiana | 22061 | 196 | 18 |
225723 | 225723 | 2020-06-10 | Lincoln | Louisiana | 22061 | 193 | 18 |
222627 | 222627 | 2020-06-09 | Lincoln | Louisiana | 22061 | 184 | 18 |
219532 | 219532 | 2020-06-08 | Lincoln | Louisiana | 22061 | 175 | 17 |
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);