ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Charlottesville city" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388856 | 388856 | 2020-07-31 | Charlottesville city | Virginia | 51540 | 466 | 11 |
385639 | 385639 | 2020-07-30 | Charlottesville city | Virginia | 51540 | 451 | 9 |
382421 | 382421 | 2020-07-29 | Charlottesville city | Virginia | 51540 | 443 | 8 |
379204 | 379204 | 2020-07-28 | Charlottesville city | Virginia | 51540 | 441 | 8 |
375988 | 375988 | 2020-07-27 | Charlottesville city | Virginia | 51540 | 433 | 8 |
372774 | 372774 | 2020-07-26 | Charlottesville city | Virginia | 51540 | 420 | 8 |
369562 | 369562 | 2020-07-25 | Charlottesville city | Virginia | 51540 | 412 | 8 |
366353 | 366353 | 2020-07-24 | Charlottesville city | Virginia | 51540 | 405 | 8 |
363147 | 363147 | 2020-07-23 | Charlottesville city | Virginia | 51540 | 385 | 8 |
359941 | 359941 | 2020-07-22 | Charlottesville city | Virginia | 51540 | 371 | 8 |
356736 | 356736 | 2020-07-21 | Charlottesville city | Virginia | 51540 | 367 | 8 |
353533 | 353533 | 2020-07-20 | Charlottesville city | Virginia | 51540 | 361 | 7 |
350331 | 350331 | 2020-07-19 | Charlottesville city | Virginia | 51540 | 343 | 7 |
347130 | 347130 | 2020-07-18 | Charlottesville city | Virginia | 51540 | 341 | 7 |
343930 | 343930 | 2020-07-17 | Charlottesville city | Virginia | 51540 | 333 | 7 |
340731 | 340731 | 2020-07-16 | Charlottesville city | Virginia | 51540 | 318 | 7 |
337535 | 337535 | 2020-07-15 | Charlottesville city | Virginia | 51540 | 318 | 7 |
334340 | 334340 | 2020-07-14 | Charlottesville city | Virginia | 51540 | 310 | 7 |
331147 | 331147 | 2020-07-13 | Charlottesville city | Virginia | 51540 | 285 | 7 |
327961 | 327961 | 2020-07-12 | Charlottesville city | Virginia | 51540 | 276 | 7 |
324776 | 324776 | 2020-07-11 | Charlottesville city | Virginia | 51540 | 270 | 7 |
321595 | 321595 | 2020-07-10 | Charlottesville city | Virginia | 51540 | 260 | 7 |
318416 | 318416 | 2020-07-09 | Charlottesville city | Virginia | 51540 | 251 | 7 |
315243 | 315243 | 2020-07-08 | Charlottesville city | Virginia | 51540 | 241 | 7 |
312068 | 312068 | 2020-07-07 | Charlottesville city | Virginia | 51540 | 239 | 7 |
308899 | 308899 | 2020-07-06 | Charlottesville city | Virginia | 51540 | 237 | 6 |
305731 | 305731 | 2020-07-05 | Charlottesville city | Virginia | 51540 | 237 | 6 |
302567 | 302567 | 2020-07-04 | Charlottesville city | Virginia | 51540 | 230 | 6 |
299403 | 299403 | 2020-07-03 | Charlottesville city | Virginia | 51540 | 220 | 6 |
296241 | 296241 | 2020-07-02 | Charlottesville city | Virginia | 51540 | 218 | 5 |
293086 | 293086 | 2020-07-01 | Charlottesville city | Virginia | 51540 | 216 | 4 |
289933 | 289933 | 2020-06-30 | Charlottesville city | Virginia | 51540 | 212 | 3 |
286783 | 286783 | 2020-06-29 | Charlottesville city | Virginia | 51540 | 211 | 3 |
283637 | 283637 | 2020-06-28 | Charlottesville city | Virginia | 51540 | 209 | 3 |
280491 | 280491 | 2020-06-27 | Charlottesville city | Virginia | 51540 | 200 | 3 |
277343 | 277343 | 2020-06-26 | Charlottesville city | Virginia | 51540 | 196 | 3 |
274195 | 274195 | 2020-06-25 | Charlottesville city | Virginia | 51540 | 193 | 3 |
271055 | 271055 | 2020-06-24 | Charlottesville city | Virginia | 51540 | 182 | 3 |
267921 | 267921 | 2020-06-23 | Charlottesville city | Virginia | 51540 | 176 | 3 |
264792 | 264792 | 2020-06-22 | Charlottesville city | Virginia | 51540 | 172 | 3 |
261663 | 261663 | 2020-06-21 | Charlottesville city | Virginia | 51540 | 169 | 3 |
258536 | 258536 | 2020-06-20 | Charlottesville city | Virginia | 51540 | 166 | 3 |
255409 | 255409 | 2020-06-19 | Charlottesville city | Virginia | 51540 | 164 | 3 |
252290 | 252290 | 2020-06-18 | Charlottesville city | Virginia | 51540 | 164 | 3 |
249175 | 249175 | 2020-06-17 | Charlottesville city | Virginia | 51540 | 161 | 3 |
246063 | 246063 | 2020-06-16 | Charlottesville city | Virginia | 51540 | 160 | 3 |
242951 | 242951 | 2020-06-15 | Charlottesville city | Virginia | 51540 | 154 | 3 |
239840 | 239840 | 2020-06-14 | Charlottesville city | Virginia | 51540 | 152 | 3 |
236732 | 236732 | 2020-06-13 | Charlottesville city | Virginia | 51540 | 148 | 3 |
233625 | 233625 | 2020-06-12 | Charlottesville city | Virginia | 51540 | 146 | 3 |
230520 | 230520 | 2020-06-11 | Charlottesville city | Virginia | 51540 | 144 | 3 |
227416 | 227416 | 2020-06-10 | Charlottesville city | Virginia | 51540 | 142 | 3 |
224316 | 224316 | 2020-06-09 | Charlottesville city | Virginia | 51540 | 141 | 3 |
221220 | 221220 | 2020-06-08 | Charlottesville city | Virginia | 51540 | 139 | 3 |
218128 | 218128 | 2020-06-07 | Charlottesville city | Virginia | 51540 | 137 | 3 |
215038 | 215038 | 2020-06-06 | Charlottesville city | Virginia | 51540 | 131 | 3 |
211951 | 211951 | 2020-06-05 | Charlottesville city | Virginia | 51540 | 131 | 3 |
208866 | 208866 | 2020-06-04 | Charlottesville city | Virginia | 51540 | 131 | 3 |
205784 | 205784 | 2020-06-03 | Charlottesville city | Virginia | 51540 | 128 | 3 |
202705 | 202705 | 2020-06-02 | Charlottesville city | Virginia | 51540 | 128 | 3 |
199629 | 199629 | 2020-06-01 | Charlottesville city | Virginia | 51540 | 125 | 3 |
196556 | 196556 | 2020-05-31 | Charlottesville city | Virginia | 51540 | 116 | 3 |
193486 | 193486 | 2020-05-30 | Charlottesville city | Virginia | 51540 | 108 | 3 |
190420 | 190420 | 2020-05-29 | Charlottesville city | Virginia | 51540 | 105 | 3 |
187356 | 187356 | 2020-05-28 | Charlottesville city | Virginia | 51540 | 102 | 3 |
184299 | 184299 | 2020-05-27 | Charlottesville city | Virginia | 51540 | 97 | 3 |
181248 | 181248 | 2020-05-26 | Charlottesville city | Virginia | 51540 | 90 | 3 |
178204 | 178204 | 2020-05-25 | Charlottesville city | Virginia | 51540 | 82 | 3 |
175159 | 175159 | 2020-05-24 | Charlottesville city | Virginia | 51540 | 80 | 3 |
172116 | 172116 | 2020-05-23 | Charlottesville city | Virginia | 51540 | 74 | 3 |
169075 | 169075 | 2020-05-22 | Charlottesville city | Virginia | 51540 | 74 | 2 |
166039 | 166039 | 2020-05-21 | Charlottesville city | Virginia | 51540 | 72 | 2 |
163010 | 163010 | 2020-05-20 | Charlottesville city | Virginia | 51540 | 72 | 2 |
159982 | 159982 | 2020-05-19 | Charlottesville city | Virginia | 51540 | 72 | 2 |
156958 | 156958 | 2020-05-18 | Charlottesville city | Virginia | 51540 | 72 | 2 |
153941 | 153941 | 2020-05-17 | Charlottesville city | Virginia | 51540 | 71 | 2 |
150930 | 150930 | 2020-05-16 | Charlottesville city | Virginia | 51540 | 71 | 2 |
147921 | 147921 | 2020-05-15 | Charlottesville city | Virginia | 51540 | 71 | 2 |
144918 | 144918 | 2020-05-14 | Charlottesville city | Virginia | 51540 | 68 | 2 |
141921 | 141921 | 2020-05-13 | Charlottesville city | Virginia | 51540 | 68 | 2 |
138925 | 138925 | 2020-05-12 | Charlottesville city | Virginia | 51540 | 68 | 2 |
135934 | 135934 | 2020-05-11 | Charlottesville city | Virginia | 51540 | 68 | 2 |
132944 | 132944 | 2020-05-10 | Charlottesville city | Virginia | 51540 | 66 | 2 |
129954 | 129954 | 2020-05-09 | Charlottesville city | Virginia | 51540 | 66 | 2 |
126965 | 126965 | 2020-05-08 | Charlottesville city | Virginia | 51540 | 66 | 2 |
123980 | 123980 | 2020-05-07 | Charlottesville city | Virginia | 51540 | 65 | 2 |
120999 | 120999 | 2020-05-06 | Charlottesville city | Virginia | 51540 | 64 | 2 |
118035 | 118035 | 2020-05-05 | Charlottesville city | Virginia | 51540 | 64 | 2 |
115076 | 115076 | 2020-05-04 | Charlottesville city | Virginia | 51540 | 63 | 2 |
112193 | 112193 | 2020-05-03 | Charlottesville city | Virginia | 51540 | 63 | 2 |
109319 | 109319 | 2020-05-02 | Charlottesville city | Virginia | 51540 | 58 | 2 |
106450 | 106450 | 2020-05-01 | Charlottesville city | Virginia | 51540 | 58 | 2 |
103586 | 103586 | 2020-04-30 | Charlottesville city | Virginia | 51540 | 56 | 2 |
100731 | 100731 | 2020-04-29 | Charlottesville city | Virginia | 51540 | 52 | 2 |
97881 | 97881 | 2020-04-28 | Charlottesville city | Virginia | 51540 | 51 | 2 |
95039 | 95039 | 2020-04-27 | Charlottesville city | Virginia | 51540 | 50 | 2 |
92210 | 92210 | 2020-04-26 | Charlottesville city | Virginia | 51540 | 49 | 2 |
89393 | 89393 | 2020-04-25 | Charlottesville city | Virginia | 51540 | 48 | 2 |
86578 | 86578 | 2020-04-24 | Charlottesville city | Virginia | 51540 | 45 | 2 |
83771 | 83771 | 2020-04-23 | Charlottesville city | Virginia | 51540 | 44 | 2 |
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);