ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Boulder" and state = "Colorado" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1977 | 1977 | 2020-03-14 | Boulder | Colorado | 8013 | 1 | 0 |
2358 | 2358 | 2020-03-15 | Boulder | Colorado | 8013 | 7 | 0 |
2793 | 2793 | 2020-03-16 | Boulder | Colorado | 8013 | 7 | 0 |
3275 | 3275 | 2020-03-17 | Boulder | Colorado | 8013 | 8 | 0 |
3829 | 3829 | 2020-03-18 | Boulder | Colorado | 8013 | 8 | 0 |
4489 | 4489 | 2020-03-19 | Boulder | Colorado | 8013 | 11 | 0 |
5264 | 5264 | 2020-03-20 | Boulder | Colorado | 8013 | 24 | 0 |
6187 | 6187 | 2020-03-21 | Boulder | Colorado | 8013 | 30 | 0 |
7222 | 7222 | 2020-03-22 | Boulder | Colorado | 8013 | 37 | 0 |
8365 | 8365 | 2020-03-23 | Boulder | Colorado | 8013 | 39 | 0 |
9607 | 9607 | 2020-03-24 | Boulder | Colorado | 8013 | 49 | 0 |
10980 | 10980 | 2020-03-25 | Boulder | Colorado | 8013 | 51 | 0 |
12525 | 12525 | 2020-03-26 | Boulder | Colorado | 8013 | 66 | 0 |
14192 | 14192 | 2020-03-27 | Boulder | Colorado | 8013 | 76 | 1 |
15975 | 15975 | 2020-03-28 | Boulder | Colorado | 8013 | 84 | 1 |
17865 | 17865 | 2020-03-29 | Boulder | Colorado | 8013 | 90 | 1 |
19843 | 19843 | 2020-03-30 | Boulder | Colorado | 8013 | 100 | 1 |
21918 | 21918 | 2020-03-31 | Boulder | Colorado | 8013 | 107 | 2 |
24077 | 24077 | 2020-04-01 | Boulder | Colorado | 8013 | 114 | 2 |
26306 | 26306 | 2020-04-02 | Boulder | Colorado | 8013 | 132 | 2 |
28606 | 28606 | 2020-04-03 | Boulder | Colorado | 8013 | 143 | 2 |
30963 | 30963 | 2020-04-04 | Boulder | Colorado | 8013 | 159 | 3 |
33369 | 33369 | 2020-04-05 | Boulder | Colorado | 8013 | 177 | 3 |
35814 | 35814 | 2020-04-06 | Boulder | Colorado | 8013 | 189 | 3 |
38304 | 38304 | 2020-04-07 | Boulder | Colorado | 8013 | 206 | 3 |
40847 | 40847 | 2020-04-08 | Boulder | Colorado | 8013 | 207 | 3 |
43419 | 43419 | 2020-04-09 | Boulder | Colorado | 8013 | 217 | 7 |
46019 | 46019 | 2020-04-10 | Boulder | Colorado | 8013 | 234 | 7 |
48649 | 48649 | 2020-04-11 | Boulder | Colorado | 8013 | 246 | 8 |
51311 | 51311 | 2020-04-12 | Boulder | Colorado | 8013 | 264 | 11 |
53990 | 53990 | 2020-04-13 | Boulder | Colorado | 8013 | 284 | 12 |
56682 | 56682 | 2020-04-14 | Boulder | Colorado | 8013 | 293 | 14 |
59390 | 59390 | 2020-04-15 | Boulder | Colorado | 8013 | 300 | 15 |
62109 | 62109 | 2020-04-16 | Boulder | Colorado | 8013 | 312 | 15 |
64842 | 64842 | 2020-04-17 | Boulder | Colorado | 8013 | 327 | 15 |
67590 | 67590 | 2020-04-18 | Boulder | Colorado | 8013 | 342 | 17 |
70352 | 70352 | 2020-04-19 | Boulder | Colorado | 8013 | 352 | 17 |
73121 | 73121 | 2020-04-20 | Boulder | Colorado | 8013 | 360 | 17 |
75897 | 75897 | 2020-04-21 | Boulder | Colorado | 8013 | 390 | 18 |
78681 | 78681 | 2020-04-22 | Boulder | Colorado | 8013 | 417 | 23 |
81475 | 81475 | 2020-04-23 | Boulder | Colorado | 8013 | 426 | 28 |
84275 | 84275 | 2020-04-24 | Boulder | Colorado | 8013 | 470 | 28 |
87083 | 87083 | 2020-04-25 | Boulder | Colorado | 8013 | 497 | 29 |
89900 | 89900 | 2020-04-26 | Boulder | Colorado | 8013 | 500 | 30 |
92718 | 92718 | 2020-04-27 | Boulder | Colorado | 8013 | 515 | 33 |
95550 | 95550 | 2020-04-28 | Boulder | Colorado | 8013 | 543 | 33 |
98395 | 98395 | 2020-04-29 | Boulder | Colorado | 8013 | 565 | 39 |
101245 | 101245 | 2020-04-30 | Boulder | Colorado | 8013 | 580 | 40 |
104100 | 104100 | 2020-05-01 | Boulder | Colorado | 8013 | 618 | 40 |
106965 | 106965 | 2020-05-02 | Boulder | Colorado | 8013 | 646 | 42 |
109834 | 109834 | 2020-05-03 | Boulder | Colorado | 8013 | 661 | 44 |
112709 | 112709 | 2020-05-04 | Boulder | Colorado | 8013 | 679 | 44 |
115592 | 115592 | 2020-05-05 | Boulder | Colorado | 8013 | 685 | 46 |
118551 | 118551 | 2020-05-06 | Boulder | Colorado | 8013 | 700 | 46 |
121518 | 121518 | 2020-05-07 | Boulder | Colorado | 8013 | 720 | 49 |
124498 | 124498 | 2020-05-08 | Boulder | Colorado | 8013 | 743 | 50 |
127484 | 127484 | 2020-05-09 | Boulder | Colorado | 8013 | 757 | 50 |
130475 | 130475 | 2020-05-10 | Boulder | Colorado | 8013 | 767 | 53 |
133466 | 133466 | 2020-05-11 | Boulder | Colorado | 8013 | 777 | 55 |
136455 | 136455 | 2020-05-12 | Boulder | Colorado | 8013 | 788 | 56 |
139446 | 139446 | 2020-05-13 | Boulder | Colorado | 8013 | 797 | 57 |
142442 | 142442 | 2020-05-14 | Boulder | Colorado | 8013 | 805 | 58 |
145442 | 145442 | 2020-05-15 | Boulder | Colorado | 8013 | 825 | 58 |
148445 | 148445 | 2020-05-16 | Boulder | Colorado | 8013 | 835 | 59 |
151454 | 151454 | 2020-05-17 | Boulder | Colorado | 8013 | 844 | 60 |
154466 | 154466 | 2020-05-18 | Boulder | Colorado | 8013 | 857 | 60 |
157482 | 157482 | 2020-05-19 | Boulder | Colorado | 8013 | 871 | 60 |
160508 | 160508 | 2020-05-20 | Boulder | Colorado | 8013 | 878 | 60 |
163536 | 163536 | 2020-05-21 | Boulder | Colorado | 8013 | 890 | 61 |
166569 | 166569 | 2020-05-22 | Boulder | Colorado | 8013 | 898 | 61 |
169606 | 169606 | 2020-05-23 | Boulder | Colorado | 8013 | 923 | 61 |
172647 | 172647 | 2020-05-24 | Boulder | Colorado | 8013 | 928 | 61 |
175691 | 175691 | 2020-05-25 | Boulder | Colorado | 8013 | 932 | 61 |
178735 | 178735 | 2020-05-26 | Boulder | Colorado | 8013 | 941 | 63 |
181779 | 181779 | 2020-05-27 | Boulder | Colorado | 8013 | 947 | 63 |
184833 | 184833 | 2020-05-28 | Boulder | Colorado | 8013 | 956 | 63 |
187889 | 187889 | 2020-05-29 | Boulder | Colorado | 8013 | 964 | 63 |
190954 | 190954 | 2020-05-30 | Boulder | Colorado | 8013 | 974 | 64 |
194021 | 194021 | 2020-05-31 | Boulder | Colorado | 8013 | 980 | 65 |
197091 | 197091 | 2020-06-01 | Boulder | Colorado | 8013 | 984 | 66 |
200164 | 200164 | 2020-06-02 | Boulder | Colorado | 8013 | 986 | 67 |
203240 | 203240 | 2020-06-03 | Boulder | Colorado | 8013 | 995 | 67 |
206320 | 206320 | 2020-06-04 | Boulder | Colorado | 8013 | 1004 | 67 |
209401 | 209401 | 2020-06-05 | Boulder | Colorado | 8013 | 1008 | 67 |
212486 | 212486 | 2020-06-06 | Boulder | Colorado | 8013 | 1011 | 67 |
215573 | 215573 | 2020-06-07 | Boulder | Colorado | 8013 | 1016 | 67 |
218664 | 218664 | 2020-06-08 | Boulder | Colorado | 8013 | 1022 | 67 |
221759 | 221759 | 2020-06-09 | Boulder | Colorado | 8013 | 1027 | 67 |
224854 | 224854 | 2020-06-10 | Boulder | Colorado | 8013 | 1031 | 67 |
227956 | 227956 | 2020-06-11 | Boulder | Colorado | 8013 | 1040 | 68 |
231059 | 231059 | 2020-06-12 | Boulder | Colorado | 8013 | 1049 | 68 |
234165 | 234165 | 2020-06-13 | Boulder | Colorado | 8013 | 1065 | 69 |
237272 | 237272 | 2020-06-14 | Boulder | Colorado | 8013 | 1070 | 70 |
240380 | 240380 | 2020-06-15 | Boulder | Colorado | 8013 | 1088 | 70 |
243491 | 243491 | 2020-06-16 | Boulder | Colorado | 8013 | 1100 | 70 |
246604 | 246604 | 2020-06-17 | Boulder | Colorado | 8013 | 1137 | 70 |
249716 | 249716 | 2020-06-18 | Boulder | Colorado | 8013 | 1173 | 70 |
252831 | 252831 | 2020-06-19 | Boulder | Colorado | 8013 | 1211 | 71 |
255950 | 255950 | 2020-06-20 | Boulder | Colorado | 8013 | 1228 | 71 |
259077 | 259077 | 2020-06-21 | Boulder | Colorado | 8013 | 1243 | 71 |
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);