ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Arapahoe" and state = "Colorado" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
888 | 888 | 2020-03-09 | Arapahoe | Colorado | 8005 | 1 | 0 |
1022 | 1022 | 2020-03-10 | Arapahoe | Colorado | 8005 | 2 | 0 |
1189 | 1189 | 2020-03-11 | Arapahoe | Colorado | 8005 | 3 | 0 |
1397 | 1397 | 2020-03-12 | Arapahoe | Colorado | 8005 | 3 | 0 |
1658 | 1658 | 2020-03-13 | Arapahoe | Colorado | 8005 | 7 | 0 |
1976 | 1976 | 2020-03-14 | Arapahoe | Colorado | 8005 | 10 | 0 |
2357 | 2357 | 2020-03-15 | Arapahoe | Colorado | 8005 | 15 | 0 |
2792 | 2792 | 2020-03-16 | Arapahoe | Colorado | 8005 | 15 | 0 |
3274 | 3274 | 2020-03-17 | Arapahoe | Colorado | 8005 | 18 | 0 |
3828 | 3828 | 2020-03-18 | Arapahoe | Colorado | 8005 | 22 | 0 |
4488 | 4488 | 2020-03-19 | Arapahoe | Colorado | 8005 | 22 | 0 |
5263 | 5263 | 2020-03-20 | Arapahoe | Colorado | 8005 | 29 | 0 |
6186 | 6186 | 2020-03-21 | Arapahoe | Colorado | 8005 | 40 | 0 |
7221 | 7221 | 2020-03-22 | Arapahoe | Colorado | 8005 | 45 | 0 |
8364 | 8364 | 2020-03-23 | Arapahoe | Colorado | 8005 | 58 | 0 |
9606 | 9606 | 2020-03-24 | Arapahoe | Colorado | 8005 | 69 | 0 |
10979 | 10979 | 2020-03-25 | Arapahoe | Colorado | 8005 | 88 | 0 |
12524 | 12524 | 2020-03-26 | Arapahoe | Colorado | 8005 | 119 | 1 |
14191 | 14191 | 2020-03-27 | Arapahoe | Colorado | 8005 | 155 | 1 |
15973 | 15973 | 2020-03-28 | Arapahoe | Colorado | 8005 | 204 | 3 |
17863 | 17863 | 2020-03-29 | Arapahoe | Colorado | 8005 | 241 | 3 |
19840 | 19840 | 2020-03-30 | Arapahoe | Colorado | 8005 | 308 | 0 |
21915 | 21915 | 2020-03-31 | Arapahoe | Colorado | 8005 | 350 | 6 |
24074 | 24074 | 2020-04-01 | Arapahoe | Colorado | 8005 | 381 | 7 |
26303 | 26303 | 2020-04-02 | Arapahoe | Colorado | 8005 | 441 | 10 |
28603 | 28603 | 2020-04-03 | Arapahoe | Colorado | 8005 | 500 | 10 |
30960 | 30960 | 2020-04-04 | Arapahoe | Colorado | 8005 | 552 | 10 |
33366 | 33366 | 2020-04-05 | Arapahoe | Colorado | 8005 | 608 | 13 |
35811 | 35811 | 2020-04-06 | Arapahoe | Colorado | 8005 | 652 | 15 |
38301 | 38301 | 2020-04-07 | Arapahoe | Colorado | 8005 | 718 | 16 |
40844 | 40844 | 2020-04-08 | Arapahoe | Colorado | 8005 | 764 | 19 |
43416 | 43416 | 2020-04-09 | Arapahoe | Colorado | 8005 | 877 | 24 |
46016 | 46016 | 2020-04-10 | Arapahoe | Colorado | 8005 | 931 | 30 |
48646 | 48646 | 2020-04-11 | Arapahoe | Colorado | 8005 | 998 | 37 |
51308 | 51308 | 2020-04-12 | Arapahoe | Colorado | 8005 | 1083 | 38 |
53987 | 53987 | 2020-04-13 | Arapahoe | Colorado | 8005 | 1142 | 39 |
56679 | 56679 | 2020-04-14 | Arapahoe | Colorado | 8005 | 1183 | 43 |
59387 | 59387 | 2020-04-15 | Arapahoe | Colorado | 8005 | 1243 | 52 |
62106 | 62106 | 2020-04-16 | Arapahoe | Colorado | 8005 | 1342 | 55 |
64839 | 64839 | 2020-04-17 | Arapahoe | Colorado | 8005 | 1419 | 58 |
67587 | 67587 | 2020-04-18 | Arapahoe | Colorado | 8005 | 1498 | 62 |
70349 | 70349 | 2020-04-19 | Arapahoe | Colorado | 8005 | 1536 | 65 |
73118 | 73118 | 2020-04-20 | Arapahoe | Colorado | 8005 | 1602 | 72 |
75894 | 75894 | 2020-04-21 | Arapahoe | Colorado | 8005 | 1649 | 80 |
78678 | 78678 | 2020-04-22 | Arapahoe | Colorado | 8005 | 1717 | 96 |
81472 | 81472 | 2020-04-23 | Arapahoe | Colorado | 8005 | 1824 | 101 |
84272 | 84272 | 2020-04-24 | Arapahoe | Colorado | 8005 | 2030 | 125 |
87080 | 87080 | 2020-04-25 | Arapahoe | Colorado | 8005 | 2083 | 127 |
89897 | 89897 | 2020-04-26 | Arapahoe | Colorado | 8005 | 2160 | 127 |
92715 | 92715 | 2020-04-27 | Arapahoe | Colorado | 8005 | 2252 | 130 |
95547 | 95547 | 2020-04-28 | Arapahoe | Colorado | 8005 | 2312 | 136 |
98392 | 98392 | 2020-04-29 | Arapahoe | Colorado | 8005 | 2389 | 140 |
101242 | 101242 | 2020-04-30 | Arapahoe | Colorado | 8005 | 2472 | 141 |
104097 | 104097 | 2020-05-01 | Arapahoe | Colorado | 8005 | 2557 | 152 |
106962 | 106962 | 2020-05-02 | Arapahoe | Colorado | 8005 | 2625 | 153 |
109831 | 109831 | 2020-05-03 | Arapahoe | Colorado | 8005 | 2706 | 156 |
112706 | 112706 | 2020-05-04 | Arapahoe | Colorado | 8005 | 2758 | 157 |
115589 | 115589 | 2020-05-05 | Arapahoe | Colorado | 8005 | 2883 | 165 |
118548 | 118548 | 2020-05-06 | Arapahoe | Colorado | 8005 | 2977 | 169 |
121515 | 121515 | 2020-05-07 | Arapahoe | Colorado | 8005 | 3089 | 172 |
124495 | 124495 | 2020-05-08 | Arapahoe | Colorado | 8005 | 3148 | 177 |
127481 | 127481 | 2020-05-09 | Arapahoe | Colorado | 8005 | 3228 | 176 |
130471 | 130471 | 2020-05-10 | Arapahoe | Colorado | 8005 | 3272 | 176 |
133462 | 133462 | 2020-05-11 | Arapahoe | Colorado | 8005 | 3313 | 179 |
136451 | 136451 | 2020-05-12 | Arapahoe | Colorado | 8005 | 3370 | 183 |
139442 | 139442 | 2020-05-13 | Arapahoe | Colorado | 8005 | 3464 | 200 |
142438 | 142438 | 2020-05-14 | Arapahoe | Colorado | 8005 | 3526 | 213 |
145438 | 145438 | 2020-05-15 | Arapahoe | Colorado | 8005 | 3583 | 227 |
148441 | 148441 | 2020-05-16 | Arapahoe | Colorado | 8005 | 3652 | 244 |
151450 | 151450 | 2020-05-17 | Arapahoe | Colorado | 8005 | 3703 | 254 |
154462 | 154462 | 2020-05-18 | Arapahoe | Colorado | 8005 | 3767 | 253 |
157478 | 157478 | 2020-05-19 | Arapahoe | Colorado | 8005 | 3827 | 258 |
160504 | 160504 | 2020-05-20 | Arapahoe | Colorado | 8005 | 3889 | 272 |
163532 | 163532 | 2020-05-21 | Arapahoe | Colorado | 8005 | 3943 | 273 |
166565 | 166565 | 2020-05-22 | Arapahoe | Colorado | 8005 | 3974 | 276 |
169602 | 169602 | 2020-05-23 | Arapahoe | Colorado | 8005 | 4027 | 278 |
172643 | 172643 | 2020-05-24 | Arapahoe | Colorado | 8005 | 4039 | 280 |
175687 | 175687 | 2020-05-25 | Arapahoe | Colorado | 8005 | 4075 | 280 |
178731 | 178731 | 2020-05-26 | Arapahoe | Colorado | 8005 | 4121 | 284 |
181775 | 181775 | 2020-05-27 | Arapahoe | Colorado | 8005 | 4166 | 298 |
184829 | 184829 | 2020-05-28 | Arapahoe | Colorado | 8005 | 4201 | 301 |
187885 | 187885 | 2020-05-29 | Arapahoe | Colorado | 8005 | 4254 | 304 |
190950 | 190950 | 2020-05-30 | Arapahoe | Colorado | 8005 | 4353 | 305 |
194017 | 194017 | 2020-05-31 | Arapahoe | Colorado | 8005 | 4394 | 305 |
197087 | 197087 | 2020-06-01 | Arapahoe | Colorado | 8005 | 4416 | 307 |
200160 | 200160 | 2020-06-02 | Arapahoe | Colorado | 8005 | 4453 | 309 |
203236 | 203236 | 2020-06-03 | Arapahoe | Colorado | 8005 | 4496 | 320 |
206316 | 206316 | 2020-06-04 | Arapahoe | Colorado | 8005 | 4553 | 325 |
209397 | 209397 | 2020-06-05 | Arapahoe | Colorado | 8005 | 4591 | 326 |
212482 | 212482 | 2020-06-06 | Arapahoe | Colorado | 8005 | 4626 | 326 |
215569 | 215569 | 2020-06-07 | Arapahoe | Colorado | 8005 | 4637 | 326 |
218660 | 218660 | 2020-06-08 | Arapahoe | Colorado | 8005 | 4663 | 326 |
221755 | 221755 | 2020-06-09 | Arapahoe | Colorado | 8005 | 4687 | 329 |
224850 | 224850 | 2020-06-10 | Arapahoe | Colorado | 8005 | 4709 | 331 |
227952 | 227952 | 2020-06-11 | Arapahoe | Colorado | 8005 | 4723 | 334 |
231055 | 231055 | 2020-06-12 | Arapahoe | Colorado | 8005 | 4754 | 335 |
234161 | 234161 | 2020-06-13 | Arapahoe | Colorado | 8005 | 4788 | 335 |
237268 | 237268 | 2020-06-14 | Arapahoe | Colorado | 8005 | 4803 | 335 |
240376 | 240376 | 2020-06-15 | Arapahoe | Colorado | 8005 | 4818 | 335 |
243487 | 243487 | 2020-06-16 | Arapahoe | Colorado | 8005 | 4826 | 338 |
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);