ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Douglas" and fips = 8035 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
306286 | 306286 | 2020-07-06 | Douglas | Colorado | 8035 | 1019 | 52 |
303122 | 303122 | 2020-07-05 | Douglas | Colorado | 8035 | 1013 | 52 |
299958 | 299958 | 2020-07-04 | Douglas | Colorado | 8035 | 1006 | 52 |
296796 | 296796 | 2020-07-03 | Douglas | Colorado | 8035 | 993 | 52 |
293640 | 293640 | 2020-07-02 | Douglas | Colorado | 8035 | 984 | 52 |
290486 | 290486 | 2020-07-01 | Douglas | Colorado | 8035 | 964 | 52 |
287335 | 287335 | 2020-06-30 | Douglas | Colorado | 8035 | 951 | 52 |
284189 | 284189 | 2020-06-29 | Douglas | Colorado | 8035 | 946 | 52 |
281043 | 281043 | 2020-06-28 | Douglas | Colorado | 8035 | 939 | 52 |
277896 | 277896 | 2020-06-27 | Douglas | Colorado | 8035 | 922 | 52 |
274748 | 274748 | 2020-06-26 | Douglas | Colorado | 8035 | 911 | 52 |
271608 | 271608 | 2020-06-25 | Douglas | Colorado | 8035 | 895 | 52 |
268473 | 268473 | 2020-06-24 | Douglas | Colorado | 8035 | 873 | 52 |
265343 | 265343 | 2020-06-23 | Douglas | Colorado | 8035 | 869 | 51 |
262215 | 262215 | 2020-06-22 | Douglas | Colorado | 8035 | 864 | 51 |
259088 | 259088 | 2020-06-21 | Douglas | Colorado | 8035 | 852 | 51 |
255961 | 255961 | 2020-06-20 | Douglas | Colorado | 8035 | 839 | 51 |
252842 | 252842 | 2020-06-19 | Douglas | Colorado | 8035 | 831 | 51 |
249727 | 249727 | 2020-06-18 | Douglas | Colorado | 8035 | 825 | 50 |
246615 | 246615 | 2020-06-17 | Douglas | Colorado | 8035 | 820 | 50 |
243502 | 243502 | 2020-06-16 | Douglas | Colorado | 8035 | 815 | 50 |
240391 | 240391 | 2020-06-15 | Douglas | Colorado | 8035 | 807 | 49 |
237283 | 237283 | 2020-06-14 | Douglas | Colorado | 8035 | 801 | 49 |
234176 | 234176 | 2020-06-13 | Douglas | Colorado | 8035 | 794 | 49 |
231070 | 231070 | 2020-06-12 | Douglas | Colorado | 8035 | 790 | 48 |
227967 | 227967 | 2020-06-11 | Douglas | Colorado | 8035 | 779 | 48 |
224865 | 224865 | 2020-06-10 | Douglas | Colorado | 8035 | 771 | 47 |
221770 | 221770 | 2020-06-09 | Douglas | Colorado | 8035 | 764 | 47 |
218675 | 218675 | 2020-06-08 | Douglas | Colorado | 8035 | 757 | 47 |
215584 | 215584 | 2020-06-07 | Douglas | Colorado | 8035 | 756 | 47 |
212497 | 212497 | 2020-06-06 | Douglas | Colorado | 8035 | 753 | 47 |
209412 | 209412 | 2020-06-05 | Douglas | Colorado | 8035 | 751 | 47 |
206331 | 206331 | 2020-06-04 | Douglas | Colorado | 8035 | 746 | 47 |
203251 | 203251 | 2020-06-03 | Douglas | Colorado | 8035 | 733 | 46 |
200175 | 200175 | 2020-06-02 | Douglas | Colorado | 8035 | 726 | 45 |
197102 | 197102 | 2020-06-01 | Douglas | Colorado | 8035 | 724 | 45 |
194032 | 194032 | 2020-05-31 | Douglas | Colorado | 8035 | 720 | 45 |
190965 | 190965 | 2020-05-30 | Douglas | Colorado | 8035 | 715 | 45 |
187900 | 187900 | 2020-05-29 | Douglas | Colorado | 8035 | 705 | 45 |
184844 | 184844 | 2020-05-28 | Douglas | Colorado | 8035 | 699 | 45 |
181790 | 181790 | 2020-05-27 | Douglas | Colorado | 8035 | 695 | 44 |
178746 | 178746 | 2020-05-26 | Douglas | Colorado | 8035 | 683 | 44 |
175702 | 175702 | 2020-05-25 | Douglas | Colorado | 8035 | 678 | 44 |
172658 | 172658 | 2020-05-24 | Douglas | Colorado | 8035 | 675 | 44 |
169617 | 169617 | 2020-05-23 | Douglas | Colorado | 8035 | 675 | 44 |
166580 | 166580 | 2020-05-22 | Douglas | Colorado | 8035 | 669 | 43 |
163547 | 163547 | 2020-05-21 | Douglas | Colorado | 8035 | 663 | 43 |
160519 | 160519 | 2020-05-20 | Douglas | Colorado | 8035 | 659 | 43 |
157493 | 157493 | 2020-05-19 | Douglas | Colorado | 8035 | 654 | 42 |
154477 | 154477 | 2020-05-18 | Douglas | Colorado | 8035 | 649 | 39 |
151465 | 151465 | 2020-05-17 | Douglas | Colorado | 8035 | 640 | 39 |
148456 | 148456 | 2020-05-16 | Douglas | Colorado | 8035 | 637 | 38 |
145453 | 145453 | 2020-05-15 | Douglas | Colorado | 8035 | 632 | 37 |
142453 | 142453 | 2020-05-14 | Douglas | Colorado | 8035 | 621 | 31 |
139457 | 139457 | 2020-05-13 | Douglas | Colorado | 8035 | 612 | 30 |
136466 | 136466 | 2020-05-12 | Douglas | Colorado | 8035 | 607 | 29 |
133477 | 133477 | 2020-05-11 | Douglas | Colorado | 8035 | 604 | 29 |
130486 | 130486 | 2020-05-10 | Douglas | Colorado | 8035 | 601 | 28 |
127495 | 127495 | 2020-05-09 | Douglas | Colorado | 8035 | 591 | 28 |
124509 | 124509 | 2020-05-08 | Douglas | Colorado | 8035 | 584 | 27 |
121529 | 121529 | 2020-05-07 | Douglas | Colorado | 8035 | 573 | 26 |
118560 | 118560 | 2020-05-06 | Douglas | Colorado | 8035 | 556 | 25 |
115601 | 115601 | 2020-05-05 | Douglas | Colorado | 8035 | 543 | 23 |
112718 | 112718 | 2020-05-04 | Douglas | Colorado | 8035 | 531 | 23 |
109843 | 109843 | 2020-05-03 | Douglas | Colorado | 8035 | 526 | 23 |
106974 | 106974 | 2020-05-02 | Douglas | Colorado | 8035 | 518 | 23 |
104109 | 104109 | 2020-05-01 | Douglas | Colorado | 8035 | 502 | 23 |
101254 | 101254 | 2020-04-30 | Douglas | Colorado | 8035 | 478 | 22 |
98404 | 98404 | 2020-04-29 | Douglas | Colorado | 8035 | 468 | 22 |
95559 | 95559 | 2020-04-28 | Douglas | Colorado | 8035 | 453 | 21 |
92727 | 92727 | 2020-04-27 | Douglas | Colorado | 8035 | 449 | 21 |
89909 | 89909 | 2020-04-26 | Douglas | Colorado | 8035 | 439 | 21 |
87092 | 87092 | 2020-04-25 | Douglas | Colorado | 8035 | 425 | 19 |
84284 | 84284 | 2020-04-24 | Douglas | Colorado | 8035 | 414 | 21 |
81484 | 81484 | 2020-04-23 | Douglas | Colorado | 8035 | 399 | 21 |
78690 | 78690 | 2020-04-22 | Douglas | Colorado | 8035 | 392 | 21 |
75906 | 75906 | 2020-04-21 | Douglas | Colorado | 8035 | 384 | 17 |
73130 | 73130 | 2020-04-20 | Douglas | Colorado | 8035 | 381 | 17 |
70361 | 70361 | 2020-04-19 | Douglas | Colorado | 8035 | 368 | 16 |
67599 | 67599 | 2020-04-18 | Douglas | Colorado | 8035 | 360 | 15 |
64851 | 64851 | 2020-04-17 | Douglas | Colorado | 8035 | 353 | 15 |
62118 | 62118 | 2020-04-16 | Douglas | Colorado | 8035 | 329 | 15 |
59399 | 59399 | 2020-04-15 | Douglas | Colorado | 8035 | 312 | 15 |
56691 | 56691 | 2020-04-14 | Douglas | Colorado | 8035 | 311 | 12 |
53999 | 53999 | 2020-04-13 | Douglas | Colorado | 8035 | 304 | 11 |
51320 | 51320 | 2020-04-12 | Douglas | Colorado | 8035 | 298 | 10 |
48658 | 48658 | 2020-04-11 | Douglas | Colorado | 8035 | 292 | 10 |
46028 | 46028 | 2020-04-10 | Douglas | Colorado | 8035 | 282 | 10 |
43428 | 43428 | 2020-04-09 | Douglas | Colorado | 8035 | 270 | 10 |
40856 | 40856 | 2020-04-08 | Douglas | Colorado | 8035 | 244 | 8 |
38313 | 38313 | 2020-04-07 | Douglas | Colorado | 8035 | 232 | 8 |
35823 | 35823 | 2020-04-06 | Douglas | Colorado | 8035 | 227 | 4 |
33378 | 33378 | 2020-04-05 | Douglas | Colorado | 8035 | 223 | 4 |
30972 | 30972 | 2020-04-04 | Douglas | Colorado | 8035 | 209 | 3 |
28615 | 28615 | 2020-04-03 | Douglas | Colorado | 8035 | 194 | 2 |
26315 | 26315 | 2020-04-02 | Douglas | Colorado | 8035 | 171 | 1 |
24085 | 24085 | 2020-04-01 | Douglas | Colorado | 8035 | 158 | 0 |
21926 | 21926 | 2020-03-31 | Douglas | Colorado | 8035 | 144 | 0 |
19851 | 19851 | 2020-03-30 | Douglas | Colorado | 8035 | 121 | 0 |
17873 | 17873 | 2020-03-29 | Douglas | Colorado | 8035 | 102 | 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);