ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Carroll" and fips = 51035 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23672 | 23672 | 2020-03-31 | Carroll | Virginia | 51035 | 1 | 0 |
25888 | 25888 | 2020-04-01 | Carroll | Virginia | 51035 | 1 | 0 |
28177 | 28177 | 2020-04-02 | Carroll | Virginia | 51035 | 1 | 0 |
30522 | 30522 | 2020-04-03 | Carroll | Virginia | 51035 | 1 | 0 |
32920 | 32920 | 2020-04-04 | Carroll | Virginia | 51035 | 1 | 0 |
35358 | 35358 | 2020-04-05 | Carroll | Virginia | 51035 | 1 | 0 |
37840 | 37840 | 2020-04-06 | Carroll | Virginia | 51035 | 1 | 0 |
40371 | 40371 | 2020-04-07 | Carroll | Virginia | 51035 | 2 | 0 |
42940 | 42940 | 2020-04-08 | Carroll | Virginia | 51035 | 2 | 0 |
45534 | 45534 | 2020-04-09 | Carroll | Virginia | 51035 | 3 | 0 |
48158 | 48158 | 2020-04-10 | Carroll | Virginia | 51035 | 3 | 0 |
50816 | 50816 | 2020-04-11 | Carroll | Virginia | 51035 | 3 | 0 |
53491 | 53491 | 2020-04-12 | Carroll | Virginia | 51035 | 3 | 0 |
56180 | 56180 | 2020-04-13 | Carroll | Virginia | 51035 | 3 | 0 |
58886 | 58886 | 2020-04-14 | Carroll | Virginia | 51035 | 3 | 0 |
61605 | 61605 | 2020-04-15 | Carroll | Virginia | 51035 | 3 | 0 |
64337 | 64337 | 2020-04-16 | Carroll | Virginia | 51035 | 3 | 0 |
67085 | 67085 | 2020-04-17 | Carroll | Virginia | 51035 | 3 | 0 |
69847 | 69847 | 2020-04-18 | Carroll | Virginia | 51035 | 3 | 0 |
72617 | 72617 | 2020-04-19 | Carroll | Virginia | 51035 | 3 | 0 |
75393 | 75393 | 2020-04-20 | Carroll | Virginia | 51035 | 3 | 0 |
78175 | 78175 | 2020-04-21 | Carroll | Virginia | 51035 | 3 | 0 |
80967 | 80967 | 2020-04-22 | Carroll | Virginia | 51035 | 3 | 0 |
83768 | 83768 | 2020-04-23 | Carroll | Virginia | 51035 | 3 | 0 |
86575 | 86575 | 2020-04-24 | Carroll | Virginia | 51035 | 3 | 0 |
89390 | 89390 | 2020-04-25 | Carroll | Virginia | 51035 | 3 | 0 |
92207 | 92207 | 2020-04-26 | Carroll | Virginia | 51035 | 3 | 0 |
95036 | 95036 | 2020-04-27 | Carroll | Virginia | 51035 | 4 | 0 |
97878 | 97878 | 2020-04-28 | Carroll | Virginia | 51035 | 4 | 0 |
100728 | 100728 | 2020-04-29 | Carroll | Virginia | 51035 | 9 | 0 |
103583 | 103583 | 2020-04-30 | Carroll | Virginia | 51035 | 11 | 0 |
106447 | 106447 | 2020-05-01 | Carroll | Virginia | 51035 | 12 | 0 |
109316 | 109316 | 2020-05-02 | Carroll | Virginia | 51035 | 13 | 0 |
112190 | 112190 | 2020-05-03 | Carroll | Virginia | 51035 | 15 | 0 |
115073 | 115073 | 2020-05-04 | Carroll | Virginia | 51035 | 19 | 0 |
118032 | 118032 | 2020-05-05 | Carroll | Virginia | 51035 | 19 | 0 |
120996 | 120996 | 2020-05-06 | Carroll | Virginia | 51035 | 19 | 0 |
123977 | 123977 | 2020-05-07 | Carroll | Virginia | 51035 | 25 | 0 |
126962 | 126962 | 2020-05-08 | Carroll | Virginia | 51035 | 26 | 0 |
129951 | 129951 | 2020-05-09 | Carroll | Virginia | 51035 | 28 | 0 |
132941 | 132941 | 2020-05-10 | Carroll | Virginia | 51035 | 33 | 0 |
135931 | 135931 | 2020-05-11 | Carroll | Virginia | 51035 | 34 | 0 |
138922 | 138922 | 2020-05-12 | Carroll | Virginia | 51035 | 34 | 0 |
141918 | 141918 | 2020-05-13 | Carroll | Virginia | 51035 | 39 | 0 |
144915 | 144915 | 2020-05-14 | Carroll | Virginia | 51035 | 40 | 0 |
147918 | 147918 | 2020-05-15 | Carroll | Virginia | 51035 | 42 | 0 |
150927 | 150927 | 2020-05-16 | Carroll | Virginia | 51035 | 45 | 0 |
153938 | 153938 | 2020-05-17 | Carroll | Virginia | 51035 | 48 | 0 |
156955 | 156955 | 2020-05-18 | Carroll | Virginia | 51035 | 49 | 0 |
159979 | 159979 | 2020-05-19 | Carroll | Virginia | 51035 | 50 | 0 |
163007 | 163007 | 2020-05-20 | Carroll | Virginia | 51035 | 64 | 1 |
166036 | 166036 | 2020-05-21 | Carroll | Virginia | 51035 | 64 | 1 |
169072 | 169072 | 2020-05-22 | Carroll | Virginia | 51035 | 66 | 1 |
172113 | 172113 | 2020-05-23 | Carroll | Virginia | 51035 | 66 | 1 |
175156 | 175156 | 2020-05-24 | Carroll | Virginia | 51035 | 74 | 1 |
178201 | 178201 | 2020-05-25 | Carroll | Virginia | 51035 | 77 | 1 |
181245 | 181245 | 2020-05-26 | Carroll | Virginia | 51035 | 84 | 1 |
184296 | 184296 | 2020-05-27 | Carroll | Virginia | 51035 | 86 | 1 |
187353 | 187353 | 2020-05-28 | Carroll | Virginia | 51035 | 88 | 1 |
190417 | 190417 | 2020-05-29 | Carroll | Virginia | 51035 | 90 | 1 |
193483 | 193483 | 2020-05-30 | Carroll | Virginia | 51035 | 91 | 1 |
196553 | 196553 | 2020-05-31 | Carroll | Virginia | 51035 | 96 | 1 |
199626 | 199626 | 2020-06-01 | Carroll | Virginia | 51035 | 97 | 1 |
202702 | 202702 | 2020-06-02 | Carroll | Virginia | 51035 | 100 | 1 |
205781 | 205781 | 2020-06-03 | Carroll | Virginia | 51035 | 105 | 1 |
208863 | 208863 | 2020-06-04 | Carroll | Virginia | 51035 | 122 | 1 |
211948 | 211948 | 2020-06-05 | Carroll | Virginia | 51035 | 122 | 1 |
215035 | 215035 | 2020-06-06 | Carroll | Virginia | 51035 | 125 | 1 |
218125 | 218125 | 2020-06-07 | Carroll | Virginia | 51035 | 130 | 2 |
221217 | 221217 | 2020-06-08 | Carroll | Virginia | 51035 | 141 | 4 |
224313 | 224313 | 2020-06-09 | Carroll | Virginia | 51035 | 149 | 5 |
227413 | 227413 | 2020-06-10 | Carroll | Virginia | 51035 | 153 | 5 |
230517 | 230517 | 2020-06-11 | Carroll | Virginia | 51035 | 158 | 5 |
233622 | 233622 | 2020-06-12 | Carroll | Virginia | 51035 | 159 | 5 |
236729 | 236729 | 2020-06-13 | Carroll | Virginia | 51035 | 165 | 5 |
239837 | 239837 | 2020-06-14 | Carroll | Virginia | 51035 | 171 | 5 |
242948 | 242948 | 2020-06-15 | Carroll | Virginia | 51035 | 173 | 5 |
246060 | 246060 | 2020-06-16 | Carroll | Virginia | 51035 | 175 | 5 |
249172 | 249172 | 2020-06-17 | Carroll | Virginia | 51035 | 177 | 5 |
252287 | 252287 | 2020-06-18 | Carroll | Virginia | 51035 | 178 | 5 |
255406 | 255406 | 2020-06-19 | Carroll | Virginia | 51035 | 187 | 5 |
258533 | 258533 | 2020-06-20 | Carroll | Virginia | 51035 | 187 | 5 |
261660 | 261660 | 2020-06-21 | Carroll | Virginia | 51035 | 188 | 5 |
264789 | 264789 | 2020-06-22 | Carroll | Virginia | 51035 | 189 | 5 |
267918 | 267918 | 2020-06-23 | Carroll | Virginia | 51035 | 193 | 5 |
271052 | 271052 | 2020-06-24 | Carroll | Virginia | 51035 | 196 | 6 |
274192 | 274192 | 2020-06-25 | Carroll | Virginia | 51035 | 200 | 6 |
277340 | 277340 | 2020-06-26 | Carroll | Virginia | 51035 | 198 | 6 |
280488 | 280488 | 2020-06-27 | Carroll | Virginia | 51035 | 203 | 8 |
283634 | 283634 | 2020-06-28 | Carroll | Virginia | 51035 | 206 | 8 |
286780 | 286780 | 2020-06-29 | Carroll | Virginia | 51035 | 209 | 8 |
289930 | 289930 | 2020-06-30 | Carroll | Virginia | 51035 | 214 | 8 |
293083 | 293083 | 2020-07-01 | Carroll | Virginia | 51035 | 221 | 8 |
296238 | 296238 | 2020-07-02 | Carroll | Virginia | 51035 | 224 | 8 |
299400 | 299400 | 2020-07-03 | Carroll | Virginia | 51035 | 225 | 9 |
302564 | 302564 | 2020-07-04 | Carroll | Virginia | 51035 | 227 | 9 |
305728 | 305728 | 2020-07-05 | Carroll | Virginia | 51035 | 232 | 9 |
308896 | 308896 | 2020-07-06 | Carroll | Virginia | 51035 | 233 | 9 |
312065 | 312065 | 2020-07-07 | Carroll | Virginia | 51035 | 235 | 9 |
315240 | 315240 | 2020-07-08 | Carroll | Virginia | 51035 | 239 | 9 |
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);