ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lincoln" and fips = 8073 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
618947 | 618947 | 2020-10-11 | Lincoln | Colorado | 8073 | 24 | 0 |
615705 | 615705 | 2020-10-10 | Lincoln | Colorado | 8073 | 24 | 0 |
612464 | 612464 | 2020-10-09 | Lincoln | Colorado | 8073 | 24 | 0 |
609222 | 609222 | 2020-10-08 | Lincoln | Colorado | 8073 | 25 | 0 |
605979 | 605979 | 2020-10-07 | Lincoln | Colorado | 8073 | 22 | 0 |
602737 | 602737 | 2020-10-06 | Lincoln | Colorado | 8073 | 21 | 0 |
599494 | 599494 | 2020-10-05 | Lincoln | Colorado | 8073 | 20 | 0 |
596251 | 596251 | 2020-10-04 | Lincoln | Colorado | 8073 | 20 | 0 |
593009 | 593009 | 2020-10-03 | Lincoln | Colorado | 8073 | 16 | 0 |
589769 | 589769 | 2020-10-02 | Lincoln | Colorado | 8073 | 13 | 0 |
586528 | 586528 | 2020-10-01 | Lincoln | Colorado | 8073 | 13 | 0 |
583288 | 583288 | 2020-09-30 | Lincoln | Colorado | 8073 | 11 | 0 |
580049 | 580049 | 2020-09-29 | Lincoln | Colorado | 8073 | 10 | 0 |
576808 | 576808 | 2020-09-28 | Lincoln | Colorado | 8073 | 10 | 0 |
573565 | 573565 | 2020-09-27 | Lincoln | Colorado | 8073 | 11 | 0 |
570323 | 570323 | 2020-09-26 | Lincoln | Colorado | 8073 | 11 | 0 |
567081 | 567081 | 2020-09-25 | Lincoln | Colorado | 8073 | 10 | 0 |
563841 | 563841 | 2020-09-24 | Lincoln | Colorado | 8073 | 9 | 0 |
560601 | 560601 | 2020-09-23 | Lincoln | Colorado | 8073 | 9 | 0 |
557365 | 557365 | 2020-09-22 | Lincoln | Colorado | 8073 | 8 | 0 |
554128 | 554128 | 2020-09-21 | Lincoln | Colorado | 8073 | 9 | 0 |
550889 | 550889 | 2020-09-20 | Lincoln | Colorado | 8073 | 9 | 0 |
547650 | 547650 | 2020-09-19 | Lincoln | Colorado | 8073 | 9 | 0 |
544412 | 544412 | 2020-09-18 | Lincoln | Colorado | 8073 | 9 | 0 |
541176 | 541176 | 2020-09-17 | Lincoln | Colorado | 8073 | 8 | 0 |
537939 | 537939 | 2020-09-16 | Lincoln | Colorado | 8073 | 8 | 0 |
534703 | 534703 | 2020-09-15 | Lincoln | Colorado | 8073 | 8 | 0 |
531468 | 531468 | 2020-09-14 | Lincoln | Colorado | 8073 | 8 | 0 |
528231 | 528231 | 2020-09-13 | Lincoln | Colorado | 8073 | 8 | 0 |
524995 | 524995 | 2020-09-12 | Lincoln | Colorado | 8073 | 8 | 0 |
521759 | 521759 | 2020-09-11 | Lincoln | Colorado | 8073 | 8 | 0 |
518522 | 518522 | 2020-09-10 | Lincoln | Colorado | 8073 | 8 | 0 |
515287 | 515287 | 2020-09-09 | Lincoln | Colorado | 8073 | 8 | 0 |
512054 | 512054 | 2020-09-08 | Lincoln | Colorado | 8073 | 8 | 0 |
508821 | 508821 | 2020-09-07 | Lincoln | Colorado | 8073 | 8 | 0 |
505589 | 505589 | 2020-09-06 | Lincoln | Colorado | 8073 | 8 | 0 |
502355 | 502355 | 2020-09-05 | Lincoln | Colorado | 8073 | 8 | 0 |
499121 | 499121 | 2020-09-04 | Lincoln | Colorado | 8073 | 8 | 0 |
495888 | 495888 | 2020-09-03 | Lincoln | Colorado | 8073 | 8 | 0 |
492654 | 492654 | 2020-09-02 | Lincoln | Colorado | 8073 | 8 | 0 |
489421 | 489421 | 2020-09-01 | Lincoln | Colorado | 8073 | 8 | 0 |
486188 | 486188 | 2020-08-31 | Lincoln | Colorado | 8073 | 8 | 0 |
482953 | 482953 | 2020-08-30 | Lincoln | Colorado | 8073 | 8 | 0 |
479719 | 479719 | 2020-08-29 | Lincoln | Colorado | 8073 | 8 | 0 |
476486 | 476486 | 2020-08-28 | Lincoln | Colorado | 8073 | 8 | 0 |
473253 | 473253 | 2020-08-27 | Lincoln | Colorado | 8073 | 8 | 0 |
470021 | 470021 | 2020-08-26 | Lincoln | Colorado | 8073 | 8 | 0 |
466792 | 466792 | 2020-08-25 | Lincoln | Colorado | 8073 | 8 | 0 |
463563 | 463563 | 2020-08-24 | Lincoln | Colorado | 8073 | 8 | 0 |
460334 | 460334 | 2020-08-23 | Lincoln | Colorado | 8073 | 8 | 0 |
457107 | 457107 | 2020-08-22 | Lincoln | Colorado | 8073 | 8 | 0 |
453879 | 453879 | 2020-08-21 | Lincoln | Colorado | 8073 | 8 | 0 |
450651 | 450651 | 2020-08-20 | Lincoln | Colorado | 8073 | 8 | 0 |
447423 | 447423 | 2020-08-19 | Lincoln | Colorado | 8073 | 8 | 0 |
444196 | 444196 | 2020-08-18 | Lincoln | Colorado | 8073 | 8 | 0 |
440970 | 440970 | 2020-08-17 | Lincoln | Colorado | 8073 | 8 | 0 |
437744 | 437744 | 2020-08-16 | Lincoln | Colorado | 8073 | 8 | 0 |
434518 | 434518 | 2020-08-15 | Lincoln | Colorado | 8073 | 8 | 0 |
431293 | 431293 | 2020-08-14 | Lincoln | Colorado | 8073 | 8 | 0 |
428065 | 428065 | 2020-08-13 | Lincoln | Colorado | 8073 | 8 | 0 |
424841 | 424841 | 2020-08-12 | Lincoln | Colorado | 8073 | 8 | 0 |
421620 | 421620 | 2020-08-11 | Lincoln | Colorado | 8073 | 8 | 0 |
418399 | 418399 | 2020-08-10 | Lincoln | Colorado | 8073 | 8 | 0 |
415178 | 415178 | 2020-08-09 | Lincoln | Colorado | 8073 | 8 | 0 |
411958 | 411958 | 2020-08-08 | Lincoln | Colorado | 8073 | 8 | 0 |
408739 | 408739 | 2020-08-07 | Lincoln | Colorado | 8073 | 8 | 0 |
405519 | 405519 | 2020-08-06 | Lincoln | Colorado | 8073 | 8 | 0 |
402301 | 402301 | 2020-08-05 | Lincoln | Colorado | 8073 | 7 | 0 |
399085 | 399085 | 2020-08-04 | Lincoln | Colorado | 8073 | 6 | 0 |
395869 | 395869 | 2020-08-03 | Lincoln | Colorado | 8073 | 6 | 0 |
392653 | 392653 | 2020-08-02 | Lincoln | Colorado | 8073 | 6 | 0 |
389436 | 389436 | 2020-08-01 | Lincoln | Colorado | 8073 | 6 | 0 |
386219 | 386219 | 2020-07-31 | Lincoln | Colorado | 8073 | 6 | 0 |
383001 | 383001 | 2020-07-30 | Lincoln | Colorado | 8073 | 6 | 0 |
379784 | 379784 | 2020-07-29 | Lincoln | Colorado | 8073 | 6 | 0 |
376567 | 376567 | 2020-07-28 | Lincoln | Colorado | 8073 | 6 | 0 |
373353 | 373353 | 2020-07-27 | Lincoln | Colorado | 8073 | 6 | 0 |
370141 | 370141 | 2020-07-26 | Lincoln | Colorado | 8073 | 6 | 0 |
366931 | 366931 | 2020-07-25 | Lincoln | Colorado | 8073 | 6 | 0 |
363724 | 363724 | 2020-07-24 | Lincoln | Colorado | 8073 | 6 | 0 |
360517 | 360517 | 2020-07-23 | Lincoln | Colorado | 8073 | 6 | 0 |
357312 | 357312 | 2020-07-22 | Lincoln | Colorado | 8073 | 6 | 0 |
354109 | 354109 | 2020-07-21 | Lincoln | Colorado | 8073 | 7 | 0 |
350907 | 350907 | 2020-07-20 | Lincoln | Colorado | 8073 | 6 | 0 |
347706 | 347706 | 2020-07-19 | Lincoln | Colorado | 8073 | 6 | 0 |
344506 | 344506 | 2020-07-18 | Lincoln | Colorado | 8073 | 6 | 0 |
341307 | 341307 | 2020-07-17 | Lincoln | Colorado | 8073 | 6 | 0 |
338110 | 338110 | 2020-07-16 | Lincoln | Colorado | 8073 | 4 | 0 |
334915 | 334915 | 2020-07-15 | Lincoln | Colorado | 8073 | 4 | 0 |
331722 | 331722 | 2020-07-14 | Lincoln | Colorado | 8073 | 4 | 0 |
328536 | 328536 | 2020-07-13 | Lincoln | Colorado | 8073 | 4 | 0 |
325350 | 325350 | 2020-07-12 | Lincoln | Colorado | 8073 | 4 | 0 |
322169 | 322169 | 2020-07-11 | Lincoln | Colorado | 8073 | 4 | 0 |
318990 | 318990 | 2020-07-10 | Lincoln | Colorado | 8073 | 4 | 0 |
315817 | 315817 | 2020-07-09 | Lincoln | Colorado | 8073 | 4 | 0 |
312642 | 312642 | 2020-07-08 | Lincoln | Colorado | 8073 | 4 | 0 |
309472 | 309472 | 2020-07-07 | Lincoln | Colorado | 8073 | 4 | 0 |
306304 | 306304 | 2020-07-06 | Lincoln | Colorado | 8073 | 4 | 0 |
303140 | 303140 | 2020-07-05 | Lincoln | Colorado | 8073 | 4 | 0 |
299976 | 299976 | 2020-07-04 | Lincoln | Colorado | 8073 | 4 | 0 |
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);