ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 8077 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635168 | 635168 | 2020-10-16 | Mesa | Colorado | 8077 | 956 | 8 |
631922 | 631922 | 2020-10-15 | Mesa | Colorado | 8077 | 847 | 8 |
628678 | 628678 | 2020-10-14 | Mesa | Colorado | 8077 | 837 | 8 |
625435 | 625435 | 2020-10-13 | Mesa | Colorado | 8077 | 823 | 7 |
622192 | 622192 | 2020-10-12 | Mesa | Colorado | 8077 | 804 | 7 |
618949 | 618949 | 2020-10-11 | Mesa | Colorado | 8077 | 798 | 7 |
615707 | 615707 | 2020-10-10 | Mesa | Colorado | 8077 | 781 | 7 |
612466 | 612466 | 2020-10-09 | Mesa | Colorado | 8077 | 766 | 7 |
609224 | 609224 | 2020-10-08 | Mesa | Colorado | 8077 | 744 | 7 |
605981 | 605981 | 2020-10-07 | Mesa | Colorado | 8077 | 724 | 7 |
602739 | 602739 | 2020-10-06 | Mesa | Colorado | 8077 | 716 | 7 |
599496 | 599496 | 2020-10-05 | Mesa | Colorado | 8077 | 712 | 7 |
596253 | 596253 | 2020-10-04 | Mesa | Colorado | 8077 | 708 | 7 |
593011 | 593011 | 2020-10-03 | Mesa | Colorado | 8077 | 696 | 7 |
589771 | 589771 | 2020-10-02 | Mesa | Colorado | 8077 | 689 | 7 |
586530 | 586530 | 2020-10-01 | Mesa | Colorado | 8077 | 663 | 7 |
583290 | 583290 | 2020-09-30 | Mesa | Colorado | 8077 | 643 | 7 |
580051 | 580051 | 2020-09-29 | Mesa | Colorado | 8077 | 636 | 7 |
576810 | 576810 | 2020-09-28 | Mesa | Colorado | 8077 | 629 | 7 |
573567 | 573567 | 2020-09-27 | Mesa | Colorado | 8077 | 615 | 7 |
570325 | 570325 | 2020-09-26 | Mesa | Colorado | 8077 | 607 | 7 |
567083 | 567083 | 2020-09-25 | Mesa | Colorado | 8077 | 592 | 7 |
563843 | 563843 | 2020-09-24 | Mesa | Colorado | 8077 | 558 | 7 |
560603 | 560603 | 2020-09-23 | Mesa | Colorado | 8077 | 551 | 7 |
557367 | 557367 | 2020-09-22 | Mesa | Colorado | 8077 | 550 | 7 |
554130 | 554130 | 2020-09-21 | Mesa | Colorado | 8077 | 544 | 7 |
550891 | 550891 | 2020-09-20 | Mesa | Colorado | 8077 | 539 | 6 |
547652 | 547652 | 2020-09-19 | Mesa | Colorado | 8077 | 533 | 6 |
544414 | 544414 | 2020-09-18 | Mesa | Colorado | 8077 | 521 | 6 |
541178 | 541178 | 2020-09-17 | Mesa | Colorado | 8077 | 504 | 6 |
537941 | 537941 | 2020-09-16 | Mesa | Colorado | 8077 | 503 | 6 |
534705 | 534705 | 2020-09-15 | Mesa | Colorado | 8077 | 500 | 6 |
531470 | 531470 | 2020-09-14 | Mesa | Colorado | 8077 | 492 | 6 |
528233 | 528233 | 2020-09-13 | Mesa | Colorado | 8077 | 489 | 6 |
524997 | 524997 | 2020-09-12 | Mesa | Colorado | 8077 | 488 | 6 |
521761 | 521761 | 2020-09-11 | Mesa | Colorado | 8077 | 485 | 5 |
518524 | 518524 | 2020-09-10 | Mesa | Colorado | 8077 | 477 | 5 |
515289 | 515289 | 2020-09-09 | Mesa | Colorado | 8077 | 475 | 5 |
512056 | 512056 | 2020-09-08 | Mesa | Colorado | 8077 | 467 | 5 |
508823 | 508823 | 2020-09-07 | Mesa | Colorado | 8077 | 467 | 5 |
505591 | 505591 | 2020-09-06 | Mesa | Colorado | 8077 | 465 | 5 |
502357 | 502357 | 2020-09-05 | Mesa | Colorado | 8077 | 448 | 5 |
499123 | 499123 | 2020-09-04 | Mesa | Colorado | 8077 | 434 | 5 |
495890 | 495890 | 2020-09-03 | Mesa | Colorado | 8077 | 426 | 5 |
492656 | 492656 | 2020-09-02 | Mesa | Colorado | 8077 | 419 | 5 |
489423 | 489423 | 2020-09-01 | Mesa | Colorado | 8077 | 416 | 5 |
486190 | 486190 | 2020-08-31 | Mesa | Colorado | 8077 | 408 | 5 |
482955 | 482955 | 2020-08-30 | Mesa | Colorado | 8077 | 407 | 5 |
479721 | 479721 | 2020-08-29 | Mesa | Colorado | 8077 | 403 | 5 |
476488 | 476488 | 2020-08-28 | Mesa | Colorado | 8077 | 403 | 5 |
473255 | 473255 | 2020-08-27 | Mesa | Colorado | 8077 | 397 | 5 |
470023 | 470023 | 2020-08-26 | Mesa | Colorado | 8077 | 393 | 5 |
466794 | 466794 | 2020-08-25 | Mesa | Colorado | 8077 | 393 | 5 |
463565 | 463565 | 2020-08-24 | Mesa | Colorado | 8077 | 388 | 5 |
460336 | 460336 | 2020-08-23 | Mesa | Colorado | 8077 | 383 | 5 |
457109 | 457109 | 2020-08-22 | Mesa | Colorado | 8077 | 377 | 5 |
453881 | 453881 | 2020-08-21 | Mesa | Colorado | 8077 | 375 | 5 |
450653 | 450653 | 2020-08-20 | Mesa | Colorado | 8077 | 372 | 5 |
447425 | 447425 | 2020-08-19 | Mesa | Colorado | 8077 | 371 | 5 |
444198 | 444198 | 2020-08-18 | Mesa | Colorado | 8077 | 369 | 5 |
440972 | 440972 | 2020-08-17 | Mesa | Colorado | 8077 | 368 | 5 |
437746 | 437746 | 2020-08-16 | Mesa | Colorado | 8077 | 367 | 5 |
434520 | 434520 | 2020-08-15 | Mesa | Colorado | 8077 | 365 | 5 |
431295 | 431295 | 2020-08-14 | Mesa | Colorado | 8077 | 361 | 4 |
428067 | 428067 | 2020-08-13 | Mesa | Colorado | 8077 | 351 | 4 |
424843 | 424843 | 2020-08-12 | Mesa | Colorado | 8077 | 343 | 4 |
421622 | 421622 | 2020-08-11 | Mesa | Colorado | 8077 | 329 | 4 |
418401 | 418401 | 2020-08-10 | Mesa | Colorado | 8077 | 316 | 4 |
415180 | 415180 | 2020-08-09 | Mesa | Colorado | 8077 | 306 | 4 |
411960 | 411960 | 2020-08-08 | Mesa | Colorado | 8077 | 301 | 4 |
408741 | 408741 | 2020-08-07 | Mesa | Colorado | 8077 | 293 | 4 |
405521 | 405521 | 2020-08-06 | Mesa | Colorado | 8077 | 289 | 4 |
402303 | 402303 | 2020-08-05 | Mesa | Colorado | 8077 | 280 | 3 |
399087 | 399087 | 2020-08-04 | Mesa | Colorado | 8077 | 274 | 3 |
395871 | 395871 | 2020-08-03 | Mesa | Colorado | 8077 | 271 | 3 |
392655 | 392655 | 2020-08-02 | Mesa | Colorado | 8077 | 267 | 3 |
389438 | 389438 | 2020-08-01 | Mesa | Colorado | 8077 | 260 | 3 |
386221 | 386221 | 2020-07-31 | Mesa | Colorado | 8077 | 255 | 3 |
383003 | 383003 | 2020-07-30 | Mesa | Colorado | 8077 | 250 | 2 |
379786 | 379786 | 2020-07-29 | Mesa | Colorado | 8077 | 244 | 2 |
376569 | 376569 | 2020-07-28 | Mesa | Colorado | 8077 | 241 | 1 |
373355 | 373355 | 2020-07-27 | Mesa | Colorado | 8077 | 233 | 1 |
370143 | 370143 | 2020-07-26 | Mesa | Colorado | 8077 | 231 | 1 |
366933 | 366933 | 2020-07-25 | Mesa | Colorado | 8077 | 227 | 1 |
363726 | 363726 | 2020-07-24 | Mesa | Colorado | 8077 | 219 | 1 |
360519 | 360519 | 2020-07-23 | Mesa | Colorado | 8077 | 213 | 1 |
357314 | 357314 | 2020-07-22 | Mesa | Colorado | 8077 | 199 | 0 |
354111 | 354111 | 2020-07-21 | Mesa | Colorado | 8077 | 191 | 0 |
350909 | 350909 | 2020-07-20 | Mesa | Colorado | 8077 | 189 | 0 |
347708 | 347708 | 2020-07-19 | Mesa | Colorado | 8077 | 185 | 0 |
344508 | 344508 | 2020-07-18 | Mesa | Colorado | 8077 | 180 | 0 |
341309 | 341309 | 2020-07-17 | Mesa | Colorado | 8077 | 174 | 0 |
338112 | 338112 | 2020-07-16 | Mesa | Colorado | 8077 | 163 | 0 |
334917 | 334917 | 2020-07-15 | Mesa | Colorado | 8077 | 162 | 0 |
331724 | 331724 | 2020-07-14 | Mesa | Colorado | 8077 | 153 | 0 |
328538 | 328538 | 2020-07-13 | Mesa | Colorado | 8077 | 146 | 0 |
325352 | 325352 | 2020-07-12 | Mesa | Colorado | 8077 | 142 | 0 |
322171 | 322171 | 2020-07-11 | Mesa | Colorado | 8077 | 140 | 0 |
318992 | 318992 | 2020-07-10 | Mesa | Colorado | 8077 | 137 | 0 |
315819 | 315819 | 2020-07-09 | Mesa | Colorado | 8077 | 129 | 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);