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 |
---|---|---|---|---|---|---|---|
386201 | 386201 | 2020-07-31 | Douglas | Colorado | 8035 | 1616 | 58 |
382983 | 382983 | 2020-07-30 | Douglas | Colorado | 8035 | 1594 | 58 |
379766 | 379766 | 2020-07-29 | Douglas | Colorado | 8035 | 1577 | 58 |
376549 | 376549 | 2020-07-28 | Douglas | Colorado | 8035 | 1558 | 56 |
373335 | 373335 | 2020-07-27 | Douglas | Colorado | 8035 | 1529 | 56 |
370123 | 370123 | 2020-07-26 | Douglas | Colorado | 8035 | 1519 | 56 |
366913 | 366913 | 2020-07-25 | Douglas | Colorado | 8035 | 1494 | 56 |
363706 | 363706 | 2020-07-24 | Douglas | Colorado | 8035 | 1462 | 56 |
360499 | 360499 | 2020-07-23 | Douglas | Colorado | 8035 | 1433 | 55 |
357294 | 357294 | 2020-07-22 | Douglas | Colorado | 8035 | 1410 | 54 |
354091 | 354091 | 2020-07-21 | Douglas | Colorado | 8035 | 1377 | 54 |
350889 | 350889 | 2020-07-20 | Douglas | Colorado | 8035 | 1357 | 54 |
347688 | 347688 | 2020-07-19 | Douglas | Colorado | 8035 | 1331 | 54 |
344488 | 344488 | 2020-07-18 | Douglas | Colorado | 8035 | 1310 | 54 |
341289 | 341289 | 2020-07-17 | Douglas | Colorado | 8035 | 1293 | 54 |
338092 | 338092 | 2020-07-16 | Douglas | Colorado | 8035 | 1263 | 54 |
334897 | 334897 | 2020-07-15 | Douglas | Colorado | 8035 | 1224 | 54 |
331704 | 331704 | 2020-07-14 | Douglas | Colorado | 8035 | 1201 | 53 |
328518 | 328518 | 2020-07-13 | Douglas | Colorado | 8035 | 1178 | 52 |
325332 | 325332 | 2020-07-12 | Douglas | Colorado | 8035 | 1161 | 52 |
322151 | 322151 | 2020-07-11 | Douglas | Colorado | 8035 | 1134 | 52 |
318972 | 318972 | 2020-07-10 | Douglas | Colorado | 8035 | 1120 | 52 |
315799 | 315799 | 2020-07-09 | Douglas | Colorado | 8035 | 1078 | 52 |
312624 | 312624 | 2020-07-08 | Douglas | Colorado | 8035 | 1056 | 52 |
309454 | 309454 | 2020-07-07 | Douglas | Colorado | 8035 | 1042 | 52 |
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 |
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);