ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Eagle" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053769 | 1053769 | 2021-02-22 | Eagle | Colorado | 8037 | 4907 | 20 |
1050522 | 1050522 | 2021-02-21 | Eagle | Colorado | 8037 | 4897 | 20 |
1047275 | 1047275 | 2021-02-20 | Eagle | Colorado | 8037 | 4878 | 20 |
1044030 | 1044030 | 2021-02-19 | Eagle | Colorado | 8037 | 4860 | 20 |
1040785 | 1040785 | 2021-02-18 | Eagle | Colorado | 8037 | 4825 | 20 |
1037540 | 1037540 | 2021-02-17 | Eagle | Colorado | 8037 | 4800 | 20 |
1034295 | 1034295 | 2021-02-16 | Eagle | Colorado | 8037 | 4778 | 20 |
1031049 | 1031049 | 2021-02-15 | Eagle | Colorado | 8037 | 4755 | 20 |
1027802 | 1027802 | 2021-02-14 | Eagle | Colorado | 8037 | 4732 | 20 |
1024557 | 1024557 | 2021-02-13 | Eagle | Colorado | 8037 | 4721 | 20 |
1021312 | 1021312 | 2021-02-12 | Eagle | Colorado | 8037 | 4700 | 20 |
1018067 | 1018067 | 2021-02-11 | Eagle | Colorado | 8037 | 4673 | 20 |
1014822 | 1014822 | 2021-02-10 | Eagle | Colorado | 8037 | 4648 | 20 |
1011577 | 1011577 | 2021-02-09 | Eagle | Colorado | 8037 | 4635 | 20 |
1008331 | 1008331 | 2021-02-08 | Eagle | Colorado | 8037 | 4621 | 20 |
1005085 | 1005085 | 2021-02-07 | Eagle | Colorado | 8037 | 4598 | 20 |
1001839 | 1001839 | 2021-02-06 | Eagle | Colorado | 8037 | 4578 | 20 |
998593 | 998593 | 2021-02-05 | Eagle | Colorado | 8037 | 4553 | 19 |
995347 | 995347 | 2021-02-04 | Eagle | Colorado | 8037 | 4522 | 19 |
992101 | 992101 | 2021-02-03 | Eagle | Colorado | 8037 | 4479 | 17 |
988855 | 988855 | 2021-02-02 | Eagle | Colorado | 8037 | 4427 | 17 |
985608 | 985608 | 2021-02-01 | Eagle | Colorado | 8037 | 4402 | 17 |
982361 | 982361 | 2021-01-31 | Eagle | Colorado | 8037 | 4342 | 17 |
979115 | 979115 | 2021-01-30 | Eagle | Colorado | 8037 | 4342 | 17 |
975870 | 975870 | 2021-01-29 | Eagle | Colorado | 8037 | 4342 | 17 |
972625 | 972625 | 2021-01-28 | Eagle | Colorado | 8037 | 4311 | 17 |
969380 | 969380 | 2021-01-27 | Eagle | Colorado | 8037 | 4282 | 17 |
966136 | 966136 | 2021-01-26 | Eagle | Colorado | 8037 | 4268 | 18 |
962891 | 962891 | 2021-01-25 | Eagle | Colorado | 8037 | 4192 | 18 |
959646 | 959646 | 2021-01-24 | Eagle | Colorado | 8037 | 4192 | 18 |
956400 | 956400 | 2021-01-23 | Eagle | Colorado | 8037 | 4172 | 18 |
953155 | 953155 | 2021-01-22 | Eagle | Colorado | 8037 | 4147 | 18 |
949910 | 949910 | 2021-01-21 | Eagle | Colorado | 8037 | 4121 | 17 |
946664 | 946664 | 2021-01-20 | Eagle | Colorado | 8037 | 4063 | 17 |
943417 | 943417 | 2021-01-19 | Eagle | Colorado | 8037 | 4022 | 17 |
940172 | 940172 | 2021-01-18 | Eagle | Colorado | 8037 | 4000 | 17 |
936927 | 936927 | 2021-01-17 | Eagle | Colorado | 8037 | 3976 | 17 |
933682 | 933682 | 2021-01-16 | Eagle | Colorado | 8037 | 3951 | 17 |
930437 | 930437 | 2021-01-15 | Eagle | Colorado | 8037 | 3917 | 17 |
927192 | 927192 | 2021-01-14 | Eagle | Colorado | 8037 | 3837 | 17 |
923946 | 923946 | 2021-01-13 | Eagle | Colorado | 8037 | 3752 | 17 |
920701 | 920701 | 2021-01-12 | Eagle | Colorado | 8037 | 3720 | 16 |
917456 | 917456 | 2021-01-11 | Eagle | Colorado | 8037 | 3704 | 16 |
914211 | 914211 | 2021-01-10 | Eagle | Colorado | 8037 | 3692 | 16 |
910966 | 910966 | 2021-01-09 | Eagle | Colorado | 8037 | 3665 | 16 |
907721 | 907721 | 2021-01-08 | Eagle | Colorado | 8037 | 3635 | 16 |
904475 | 904475 | 2021-01-07 | Eagle | Colorado | 8037 | 3579 | 16 |
901230 | 901230 | 2021-01-06 | Eagle | Colorado | 8037 | 3512 | 16 |
897985 | 897985 | 2021-01-05 | Eagle | Colorado | 8037 | 3512 | 16 |
894740 | 894740 | 2021-01-04 | Eagle | Colorado | 8037 | 3450 | 16 |
891493 | 891493 | 2021-01-03 | Eagle | Colorado | 8037 | 3426 | 16 |
888246 | 888246 | 2021-01-02 | Eagle | Colorado | 8037 | 3404 | 16 |
885001 | 885001 | 2021-01-01 | Eagle | Colorado | 8037 | 3392 | 16 |
881756 | 881756 | 2020-12-31 | Eagle | Colorado | 8037 | 3374 | 16 |
878511 | 878511 | 2020-12-30 | Eagle | Colorado | 8037 | 3323 | 15 |
875266 | 875266 | 2020-12-29 | Eagle | Colorado | 8037 | 3268 | 15 |
872021 | 872021 | 2020-12-28 | Eagle | Colorado | 8037 | 3250 | 14 |
868776 | 868776 | 2020-12-27 | Eagle | Colorado | 8037 | 3226 | 14 |
865531 | 865531 | 2020-12-26 | Eagle | Colorado | 8037 | 3200 | 14 |
862286 | 862286 | 2020-12-25 | Eagle | Colorado | 8037 | 3190 | 14 |
859041 | 859041 | 2020-12-24 | Eagle | Colorado | 8037 | 3167 | 14 |
855796 | 855796 | 2020-12-23 | Eagle | Colorado | 8037 | 3138 | 13 |
852551 | 852551 | 2020-12-22 | Eagle | Colorado | 8037 | 3124 | 12 |
849306 | 849306 | 2020-12-21 | Eagle | Colorado | 8037 | 3097 | 12 |
846061 | 846061 | 2020-12-20 | Eagle | Colorado | 8037 | 3082 | 12 |
842815 | 842815 | 2020-12-19 | Eagle | Colorado | 8037 | 3070 | 12 |
839570 | 839570 | 2020-12-18 | Eagle | Colorado | 8037 | 3030 | 12 |
836325 | 836325 | 2020-12-17 | Eagle | Colorado | 8037 | 2982 | 12 |
833079 | 833079 | 2020-12-16 | Eagle | Colorado | 8037 | 2961 | 12 |
829832 | 829832 | 2020-12-15 | Eagle | Colorado | 8037 | 2938 | 12 |
826586 | 826586 | 2020-12-14 | Eagle | Colorado | 8037 | 2851 | 12 |
823339 | 823339 | 2020-12-13 | Eagle | Colorado | 8037 | 2851 | 12 |
820093 | 820093 | 2020-12-12 | Eagle | Colorado | 8037 | 2811 | 12 |
816847 | 816847 | 2020-12-11 | Eagle | Colorado | 8037 | 2782 | 12 |
813601 | 813601 | 2020-12-10 | Eagle | Colorado | 8037 | 2752 | 12 |
810357 | 810357 | 2020-12-09 | Eagle | Colorado | 8037 | 2720 | 12 |
807112 | 807112 | 2020-12-08 | Eagle | Colorado | 8037 | 2652 | 12 |
803867 | 803867 | 2020-12-07 | Eagle | Colorado | 8037 | 2601 | 12 |
800622 | 800622 | 2020-12-06 | Eagle | Colorado | 8037 | 2572 | 12 |
797377 | 797377 | 2020-12-05 | Eagle | Colorado | 8037 | 2536 | 12 |
794132 | 794132 | 2020-12-04 | Eagle | Colorado | 8037 | 2498 | 12 |
790887 | 790887 | 2020-12-03 | Eagle | Colorado | 8037 | 2477 | 12 |
787642 | 787642 | 2020-12-02 | Eagle | Colorado | 8037 | 2438 | 11 |
784398 | 784398 | 2020-12-01 | Eagle | Colorado | 8037 | 2403 | 11 |
781153 | 781153 | 2020-11-30 | Eagle | Colorado | 8037 | 2390 | 11 |
777907 | 777907 | 2020-11-29 | Eagle | Colorado | 8037 | 2364 | 11 |
774662 | 774662 | 2020-11-28 | Eagle | Colorado | 8037 | 2338 | 11 |
771417 | 771417 | 2020-11-27 | Eagle | Colorado | 8037 | 2272 | 11 |
768172 | 768172 | 2020-11-26 | Eagle | Colorado | 8037 | 2237 | 11 |
764926 | 764926 | 2020-11-25 | Eagle | Colorado | 8037 | 2214 | 11 |
761681 | 761681 | 2020-11-24 | Eagle | Colorado | 8037 | 2155 | 11 |
758436 | 758436 | 2020-11-23 | Eagle | Colorado | 8037 | 2066 | 11 |
755189 | 755189 | 2020-11-22 | Eagle | Colorado | 8037 | 2051 | 11 |
751943 | 751943 | 2020-11-21 | Eagle | Colorado | 8037 | 2028 | 11 |
748697 | 748697 | 2020-11-20 | Eagle | Colorado | 8037 | 2012 | 11 |
745451 | 745451 | 2020-11-19 | Eagle | Colorado | 8037 | 1987 | 11 |
742204 | 742204 | 2020-11-18 | Eagle | Colorado | 8037 | 1968 | 11 |
738957 | 738957 | 2020-11-17 | Eagle | Colorado | 8037 | 1930 | 11 |
735713 | 735713 | 2020-11-16 | Eagle | Colorado | 8037 | 1894 | 11 |
732467 | 732467 | 2020-11-15 | Eagle | Colorado | 8037 | 1882 | 11 |
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);