ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where deaths = 18, fips = 8107 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
927227 | 927227 | 2021-01-14 | Routt | Colorado | 8107 | 1252 | 18 |
923981 | 923981 | 2021-01-13 | Routt | Colorado | 8107 | 1231 | 18 |
920736 | 920736 | 2021-01-12 | Routt | Colorado | 8107 | 1209 | 18 |
917491 | 917491 | 2021-01-11 | Routt | Colorado | 8107 | 1180 | 18 |
914246 | 914246 | 2021-01-10 | Routt | Colorado | 8107 | 1168 | 18 |
911001 | 911001 | 2021-01-09 | Routt | Colorado | 8107 | 1159 | 18 |
907756 | 907756 | 2021-01-08 | Routt | Colorado | 8107 | 1147 | 18 |
904510 | 904510 | 2021-01-07 | Routt | Colorado | 8107 | 1112 | 18 |
901265 | 901265 | 2021-01-06 | Routt | Colorado | 8107 | 1084 | 18 |
898020 | 898020 | 2021-01-05 | Routt | Colorado | 8107 | 1084 | 18 |
894775 | 894775 | 2021-01-04 | Routt | Colorado | 8107 | 1077 | 18 |
891528 | 891528 | 2021-01-03 | Routt | Colorado | 8107 | 1075 | 18 |
888281 | 888281 | 2021-01-02 | Routt | Colorado | 8107 | 1068 | 18 |
885036 | 885036 | 2021-01-01 | Routt | Colorado | 8107 | 1058 | 18 |
881791 | 881791 | 2020-12-31 | Routt | Colorado | 8107 | 1042 | 18 |
878546 | 878546 | 2020-12-30 | Routt | Colorado | 8107 | 1031 | 18 |
875301 | 875301 | 2020-12-29 | Routt | Colorado | 8107 | 1023 | 18 |
872056 | 872056 | 2020-12-28 | Routt | Colorado | 8107 | 1013 | 18 |
868811 | 868811 | 2020-12-27 | Routt | Colorado | 8107 | 1010 | 18 |
865566 | 865566 | 2020-12-26 | Routt | Colorado | 8107 | 1004 | 18 |
862321 | 862321 | 2020-12-25 | Routt | Colorado | 8107 | 998 | 18 |
859076 | 859076 | 2020-12-24 | Routt | Colorado | 8107 | 988 | 18 |
855831 | 855831 | 2020-12-23 | Routt | Colorado | 8107 | 978 | 18 |
852586 | 852586 | 2020-12-22 | Routt | Colorado | 8107 | 964 | 18 |
849341 | 849341 | 2020-12-21 | Routt | Colorado | 8107 | 957 | 18 |
846096 | 846096 | 2020-12-20 | Routt | Colorado | 8107 | 951 | 18 |
842850 | 842850 | 2020-12-19 | Routt | Colorado | 8107 | 946 | 18 |
839605 | 839605 | 2020-12-18 | Routt | Colorado | 8107 | 945 | 18 |
836360 | 836360 | 2020-12-17 | Routt | Colorado | 8107 | 941 | 18 |
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);