ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Hinsdale" and state = "Colorado" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
6200 | 6200 | 2020-03-21 | Hinsdale | Colorado | 8053 | 1 | 0 |
7235 | 7235 | 2020-03-22 | Hinsdale | Colorado | 8053 | 1 | 0 |
8378 | 8378 | 2020-03-23 | Hinsdale | Colorado | 8053 | 1 | 0 |
9622 | 9622 | 2020-03-24 | Hinsdale | Colorado | 8053 | 1 | 0 |
10995 | 10995 | 2020-03-25 | Hinsdale | Colorado | 8053 | 1 | 0 |
12540 | 12540 | 2020-03-26 | Hinsdale | Colorado | 8053 | 1 | 0 |
14208 | 14208 | 2020-03-27 | Hinsdale | Colorado | 8053 | 1 | 0 |
15991 | 15991 | 2020-03-28 | Hinsdale | Colorado | 8053 | 1 | 0 |
17881 | 17881 | 2020-03-29 | Hinsdale | Colorado | 8053 | 1 | 0 |
19859 | 19859 | 2020-03-30 | Hinsdale | Colorado | 8053 | 1 | 0 |
21934 | 21934 | 2020-03-31 | Hinsdale | Colorado | 8053 | 1 | 0 |
24093 | 24093 | 2020-04-01 | Hinsdale | Colorado | 8053 | 1 | 0 |
26323 | 26323 | 2020-04-02 | Hinsdale | Colorado | 8053 | 1 | 0 |
28623 | 28623 | 2020-04-03 | Hinsdale | Colorado | 8053 | 1 | 0 |
30980 | 30980 | 2020-04-04 | Hinsdale | Colorado | 8053 | 1 | 0 |
33386 | 33386 | 2020-04-05 | Hinsdale | Colorado | 8053 | 1 | 0 |
35831 | 35831 | 2020-04-06 | Hinsdale | Colorado | 8053 | 1 | 0 |
38321 | 38321 | 2020-04-07 | Hinsdale | Colorado | 8053 | 1 | 0 |
40864 | 40864 | 2020-04-08 | Hinsdale | Colorado | 8053 | 1 | 0 |
43437 | 43437 | 2020-04-09 | Hinsdale | Colorado | 8053 | 1 | 0 |
46037 | 46037 | 2020-04-10 | Hinsdale | Colorado | 8053 | 1 | 0 |
48667 | 48667 | 2020-04-11 | Hinsdale | Colorado | 8053 | 1 | 0 |
51329 | 51329 | 2020-04-12 | Hinsdale | Colorado | 8053 | 2 | 0 |
54008 | 54008 | 2020-04-13 | Hinsdale | Colorado | 8053 | 2 | 0 |
56700 | 56700 | 2020-04-14 | Hinsdale | Colorado | 8053 | 3 | 0 |
59408 | 59408 | 2020-04-15 | Hinsdale | Colorado | 8053 | 3 | 0 |
62127 | 62127 | 2020-04-16 | Hinsdale | Colorado | 8053 | 3 | 0 |
64860 | 64860 | 2020-04-17 | Hinsdale | Colorado | 8053 | 3 | 0 |
67608 | 67608 | 2020-04-18 | Hinsdale | Colorado | 8053 | 3 | 0 |
70370 | 70370 | 2020-04-19 | Hinsdale | Colorado | 8053 | 3 | 0 |
73139 | 73139 | 2020-04-20 | Hinsdale | Colorado | 8053 | 3 | 0 |
75915 | 75915 | 2020-04-21 | Hinsdale | Colorado | 8053 | 3 | 0 |
78699 | 78699 | 2020-04-22 | Hinsdale | Colorado | 8053 | 3 | 0 |
81493 | 81493 | 2020-04-23 | Hinsdale | Colorado | 8053 | 3 | 0 |
84293 | 84293 | 2020-04-24 | Hinsdale | Colorado | 8053 | 3 | 0 |
87101 | 87101 | 2020-04-25 | Hinsdale | Colorado | 8053 | 3 | 0 |
89918 | 89918 | 2020-04-26 | Hinsdale | Colorado | 8053 | 3 | 0 |
92736 | 92736 | 2020-04-27 | Hinsdale | Colorado | 8053 | 3 | 0 |
95568 | 95568 | 2020-04-28 | Hinsdale | Colorado | 8053 | 3 | 0 |
98413 | 98413 | 2020-04-29 | Hinsdale | Colorado | 8053 | 3 | 0 |
101263 | 101263 | 2020-04-30 | Hinsdale | Colorado | 8053 | 3 | 0 |
104118 | 104118 | 2020-05-01 | Hinsdale | Colorado | 8053 | 3 | 0 |
106983 | 106983 | 2020-05-02 | Hinsdale | Colorado | 8053 | 3 | 0 |
109852 | 109852 | 2020-05-03 | Hinsdale | Colorado | 8053 | 3 | 0 |
112727 | 112727 | 2020-05-04 | Hinsdale | Colorado | 8053 | 3 | 0 |
115610 | 115610 | 2020-05-05 | Hinsdale | Colorado | 8053 | 3 | 0 |
118569 | 118569 | 2020-05-06 | Hinsdale | Colorado | 8053 | 3 | 0 |
121538 | 121538 | 2020-05-07 | Hinsdale | Colorado | 8053 | 3 | 0 |
124518 | 124518 | 2020-05-08 | Hinsdale | Colorado | 8053 | 3 | 0 |
127504 | 127504 | 2020-05-09 | Hinsdale | Colorado | 8053 | 3 | 0 |
130495 | 130495 | 2020-05-10 | Hinsdale | Colorado | 8053 | 3 | 0 |
133486 | 133486 | 2020-05-11 | Hinsdale | Colorado | 8053 | 3 | 0 |
136475 | 136475 | 2020-05-12 | Hinsdale | Colorado | 8053 | 3 | 0 |
139466 | 139466 | 2020-05-13 | Hinsdale | Colorado | 8053 | 3 | 0 |
142462 | 142462 | 2020-05-14 | Hinsdale | Colorado | 8053 | 3 | 0 |
145462 | 145462 | 2020-05-15 | Hinsdale | Colorado | 8053 | 3 | 0 |
148465 | 148465 | 2020-05-16 | Hinsdale | Colorado | 8053 | 3 | 0 |
151474 | 151474 | 2020-05-17 | Hinsdale | Colorado | 8053 | 3 | 0 |
154486 | 154486 | 2020-05-18 | Hinsdale | Colorado | 8053 | 3 | 0 |
157502 | 157502 | 2020-05-19 | Hinsdale | Colorado | 8053 | 3 | 0 |
160528 | 160528 | 2020-05-20 | Hinsdale | Colorado | 8053 | 3 | 0 |
163556 | 163556 | 2020-05-21 | Hinsdale | Colorado | 8053 | 3 | 0 |
166589 | 166589 | 2020-05-22 | Hinsdale | Colorado | 8053 | 3 | 0 |
169626 | 169626 | 2020-05-23 | Hinsdale | Colorado | 8053 | 3 | 0 |
172667 | 172667 | 2020-05-24 | Hinsdale | Colorado | 8053 | 3 | 0 |
175711 | 175711 | 2020-05-25 | Hinsdale | Colorado | 8053 | 3 | 0 |
178755 | 178755 | 2020-05-26 | Hinsdale | Colorado | 8053 | 3 | 0 |
181799 | 181799 | 2020-05-27 | Hinsdale | Colorado | 8053 | 3 | 0 |
184853 | 184853 | 2020-05-28 | Hinsdale | Colorado | 8053 | 3 | 0 |
187909 | 187909 | 2020-05-29 | Hinsdale | Colorado | 8053 | 3 | 0 |
190974 | 190974 | 2020-05-30 | Hinsdale | Colorado | 8053 | 3 | 0 |
194041 | 194041 | 2020-05-31 | Hinsdale | Colorado | 8053 | 3 | 0 |
197111 | 197111 | 2020-06-01 | Hinsdale | Colorado | 8053 | 3 | 0 |
200184 | 200184 | 2020-06-02 | Hinsdale | Colorado | 8053 | 3 | 0 |
203260 | 203260 | 2020-06-03 | Hinsdale | Colorado | 8053 | 3 | 0 |
206340 | 206340 | 2020-06-04 | Hinsdale | Colorado | 8053 | 3 | 0 |
209421 | 209421 | 2020-06-05 | Hinsdale | Colorado | 8053 | 3 | 0 |
212506 | 212506 | 2020-06-06 | Hinsdale | Colorado | 8053 | 3 | 0 |
215593 | 215593 | 2020-06-07 | Hinsdale | Colorado | 8053 | 3 | 0 |
218684 | 218684 | 2020-06-08 | Hinsdale | Colorado | 8053 | 3 | 0 |
221779 | 221779 | 2020-06-09 | Hinsdale | Colorado | 8053 | 3 | 0 |
224874 | 224874 | 2020-06-10 | Hinsdale | Colorado | 8053 | 3 | 0 |
227976 | 227976 | 2020-06-11 | Hinsdale | Colorado | 8053 | 3 | 0 |
231079 | 231079 | 2020-06-12 | Hinsdale | Colorado | 8053 | 3 | 0 |
234185 | 234185 | 2020-06-13 | Hinsdale | Colorado | 8053 | 3 | 0 |
237292 | 237292 | 2020-06-14 | Hinsdale | Colorado | 8053 | 3 | 0 |
240400 | 240400 | 2020-06-15 | Hinsdale | Colorado | 8053 | 3 | 0 |
243511 | 243511 | 2020-06-16 | Hinsdale | Colorado | 8053 | 3 | 0 |
246624 | 246624 | 2020-06-17 | Hinsdale | Colorado | 8053 | 3 | 0 |
249736 | 249736 | 2020-06-18 | Hinsdale | Colorado | 8053 | 3 | 0 |
252851 | 252851 | 2020-06-19 | Hinsdale | Colorado | 8053 | 3 | 0 |
255970 | 255970 | 2020-06-20 | Hinsdale | Colorado | 8053 | 3 | 0 |
259097 | 259097 | 2020-06-21 | Hinsdale | Colorado | 8053 | 3 | 0 |
262224 | 262224 | 2020-06-22 | Hinsdale | Colorado | 8053 | 3 | 0 |
265352 | 265352 | 2020-06-23 | Hinsdale | Colorado | 8053 | 3 | 0 |
268482 | 268482 | 2020-06-24 | Hinsdale | Colorado | 8053 | 3 | 0 |
271617 | 271617 | 2020-06-25 | Hinsdale | Colorado | 8053 | 3 | 0 |
274757 | 274757 | 2020-06-26 | Hinsdale | Colorado | 8053 | 3 | 0 |
277905 | 277905 | 2020-06-27 | Hinsdale | Colorado | 8053 | 3 | 0 |
281052 | 281052 | 2020-06-28 | Hinsdale | Colorado | 8053 | 3 | 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);