ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Crowley" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635142 | 635142 | 2020-10-16 | Crowley | Colorado | 8025 | 80 | 1 |
631896 | 631896 | 2020-10-15 | Crowley | Colorado | 8025 | 78 | 1 |
628652 | 628652 | 2020-10-14 | Crowley | Colorado | 8025 | 77 | 1 |
625409 | 625409 | 2020-10-13 | Crowley | Colorado | 8025 | 77 | 1 |
622166 | 622166 | 2020-10-12 | Crowley | Colorado | 8025 | 77 | 1 |
618923 | 618923 | 2020-10-11 | Crowley | Colorado | 8025 | 76 | 1 |
615681 | 615681 | 2020-10-10 | Crowley | Colorado | 8025 | 74 | 1 |
612440 | 612440 | 2020-10-09 | Crowley | Colorado | 8025 | 74 | 1 |
609198 | 609198 | 2020-10-08 | Crowley | Colorado | 8025 | 74 | 1 |
605955 | 605955 | 2020-10-07 | Crowley | Colorado | 8025 | 74 | 1 |
602713 | 602713 | 2020-10-06 | Crowley | Colorado | 8025 | 74 | 1 |
599470 | 599470 | 2020-10-05 | Crowley | Colorado | 8025 | 74 | 1 |
596227 | 596227 | 2020-10-04 | Crowley | Colorado | 8025 | 74 | 1 |
592985 | 592985 | 2020-10-03 | Crowley | Colorado | 8025 | 74 | 1 |
589745 | 589745 | 2020-10-02 | Crowley | Colorado | 8025 | 74 | 1 |
586504 | 586504 | 2020-10-01 | Crowley | Colorado | 8025 | 74 | 1 |
583264 | 583264 | 2020-09-30 | Crowley | Colorado | 8025 | 74 | 1 |
580025 | 580025 | 2020-09-29 | Crowley | Colorado | 8025 | 74 | 1 |
576784 | 576784 | 2020-09-28 | Crowley | Colorado | 8025 | 73 | 1 |
573541 | 573541 | 2020-09-27 | Crowley | Colorado | 8025 | 73 | 1 |
570299 | 570299 | 2020-09-26 | Crowley | Colorado | 8025 | 73 | 1 |
567057 | 567057 | 2020-09-25 | Crowley | Colorado | 8025 | 73 | 1 |
563817 | 563817 | 2020-09-24 | Crowley | Colorado | 8025 | 73 | 1 |
560578 | 560578 | 2020-09-23 | Crowley | Colorado | 8025 | 73 | 1 |
557342 | 557342 | 2020-09-22 | Crowley | Colorado | 8025 | 73 | 1 |
554105 | 554105 | 2020-09-21 | Crowley | Colorado | 8025 | 73 | 1 |
550866 | 550866 | 2020-09-20 | Crowley | Colorado | 8025 | 73 | 1 |
547627 | 547627 | 2020-09-19 | Crowley | Colorado | 8025 | 73 | 1 |
544389 | 544389 | 2020-09-18 | Crowley | Colorado | 8025 | 73 | 1 |
541153 | 541153 | 2020-09-17 | Crowley | Colorado | 8025 | 73 | 1 |
537916 | 537916 | 2020-09-16 | Crowley | Colorado | 8025 | 73 | 1 |
534680 | 534680 | 2020-09-15 | Crowley | Colorado | 8025 | 73 | 1 |
531445 | 531445 | 2020-09-14 | Crowley | Colorado | 8025 | 73 | 1 |
528208 | 528208 | 2020-09-13 | Crowley | Colorado | 8025 | 73 | 1 |
524972 | 524972 | 2020-09-12 | Crowley | Colorado | 8025 | 73 | 1 |
521736 | 521736 | 2020-09-11 | Crowley | Colorado | 8025 | 73 | 1 |
518499 | 518499 | 2020-09-10 | Crowley | Colorado | 8025 | 73 | 1 |
515264 | 515264 | 2020-09-09 | Crowley | Colorado | 8025 | 73 | 1 |
512031 | 512031 | 2020-09-08 | Crowley | Colorado | 8025 | 73 | 1 |
508798 | 508798 | 2020-09-07 | Crowley | Colorado | 8025 | 73 | 1 |
505566 | 505566 | 2020-09-06 | Crowley | Colorado | 8025 | 73 | 1 |
502332 | 502332 | 2020-09-05 | Crowley | Colorado | 8025 | 73 | 1 |
499098 | 499098 | 2020-09-04 | Crowley | Colorado | 8025 | 73 | 1 |
495865 | 495865 | 2020-09-03 | Crowley | Colorado | 8025 | 73 | 1 |
492631 | 492631 | 2020-09-02 | Crowley | Colorado | 8025 | 73 | 1 |
489398 | 489398 | 2020-09-01 | Crowley | Colorado | 8025 | 73 | 1 |
486165 | 486165 | 2020-08-31 | Crowley | Colorado | 8025 | 73 | 1 |
482930 | 482930 | 2020-08-30 | Crowley | Colorado | 8025 | 73 | 1 |
479696 | 479696 | 2020-08-29 | Crowley | Colorado | 8025 | 73 | 1 |
476463 | 476463 | 2020-08-28 | Crowley | Colorado | 8025 | 73 | 1 |
473230 | 473230 | 2020-08-27 | Crowley | Colorado | 8025 | 73 | 1 |
469998 | 469998 | 2020-08-26 | Crowley | Colorado | 8025 | 73 | 1 |
466769 | 466769 | 2020-08-25 | Crowley | Colorado | 8025 | 73 | 1 |
463540 | 463540 | 2020-08-24 | Crowley | Colorado | 8025 | 73 | 1 |
460311 | 460311 | 2020-08-23 | Crowley | Colorado | 8025 | 73 | 1 |
457084 | 457084 | 2020-08-22 | Crowley | Colorado | 8025 | 73 | 1 |
453856 | 453856 | 2020-08-21 | Crowley | Colorado | 8025 | 73 | 1 |
450628 | 450628 | 2020-08-20 | Crowley | Colorado | 8025 | 73 | 1 |
447400 | 447400 | 2020-08-19 | Crowley | Colorado | 8025 | 73 | 1 |
444173 | 444173 | 2020-08-18 | Crowley | Colorado | 8025 | 73 | 1 |
440947 | 440947 | 2020-08-17 | Crowley | Colorado | 8025 | 73 | 1 |
437721 | 437721 | 2020-08-16 | Crowley | Colorado | 8025 | 73 | 1 |
434495 | 434495 | 2020-08-15 | Crowley | Colorado | 8025 | 73 | 1 |
431270 | 431270 | 2020-08-14 | Crowley | Colorado | 8025 | 73 | 1 |
428042 | 428042 | 2020-08-13 | Crowley | Colorado | 8025 | 73 | 1 |
424818 | 424818 | 2020-08-12 | Crowley | Colorado | 8025 | 73 | 1 |
421597 | 421597 | 2020-08-11 | Crowley | Colorado | 8025 | 72 | 1 |
418376 | 418376 | 2020-08-10 | Crowley | Colorado | 8025 | 72 | 1 |
415155 | 415155 | 2020-08-09 | Crowley | Colorado | 8025 | 72 | 1 |
411935 | 411935 | 2020-08-08 | Crowley | Colorado | 8025 | 72 | 1 |
408716 | 408716 | 2020-08-07 | Crowley | Colorado | 8025 | 72 | 1 |
405496 | 405496 | 2020-08-06 | Crowley | Colorado | 8025 | 72 | 1 |
402278 | 402278 | 2020-08-05 | Crowley | Colorado | 8025 | 72 | 1 |
399062 | 399062 | 2020-08-04 | Crowley | Colorado | 8025 | 72 | 1 |
395846 | 395846 | 2020-08-03 | Crowley | Colorado | 8025 | 72 | 1 |
392630 | 392630 | 2020-08-02 | Crowley | Colorado | 8025 | 72 | 1 |
389413 | 389413 | 2020-08-01 | Crowley | Colorado | 8025 | 72 | 1 |
386196 | 386196 | 2020-07-31 | Crowley | Colorado | 8025 | 72 | 1 |
382978 | 382978 | 2020-07-30 | Crowley | Colorado | 8025 | 72 | 1 |
379761 | 379761 | 2020-07-29 | Crowley | Colorado | 8025 | 72 | 1 |
376544 | 376544 | 2020-07-28 | Crowley | Colorado | 8025 | 72 | 1 |
373330 | 373330 | 2020-07-27 | Crowley | Colorado | 8025 | 72 | 1 |
370118 | 370118 | 2020-07-26 | Crowley | Colorado | 8025 | 72 | 1 |
366908 | 366908 | 2020-07-25 | Crowley | Colorado | 8025 | 72 | 1 |
363701 | 363701 | 2020-07-24 | Crowley | Colorado | 8025 | 72 | 1 |
360494 | 360494 | 2020-07-23 | Crowley | Colorado | 8025 | 72 | 1 |
357289 | 357289 | 2020-07-22 | Crowley | Colorado | 8025 | 73 | 1 |
354086 | 354086 | 2020-07-21 | Crowley | Colorado | 8025 | 72 | 1 |
350884 | 350884 | 2020-07-20 | Crowley | Colorado | 8025 | 72 | 1 |
347683 | 347683 | 2020-07-19 | Crowley | Colorado | 8025 | 72 | 1 |
344483 | 344483 | 2020-07-18 | Crowley | Colorado | 8025 | 72 | 1 |
341284 | 341284 | 2020-07-17 | Crowley | Colorado | 8025 | 71 | 1 |
338088 | 338088 | 2020-07-16 | Crowley | Colorado | 8025 | 71 | 1 |
334893 | 334893 | 2020-07-15 | Crowley | Colorado | 8025 | 71 | 1 |
331700 | 331700 | 2020-07-14 | Crowley | Colorado | 8025 | 71 | 1 |
328514 | 328514 | 2020-07-13 | Crowley | Colorado | 8025 | 71 | 1 |
325328 | 325328 | 2020-07-12 | Crowley | Colorado | 8025 | 71 | 1 |
322147 | 322147 | 2020-07-11 | Crowley | Colorado | 8025 | 71 | 1 |
318968 | 318968 | 2020-07-10 | Crowley | Colorado | 8025 | 71 | 1 |
315795 | 315795 | 2020-07-09 | Crowley | Colorado | 8025 | 71 | 1 |
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);