ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Mecklenburg" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388912 | 388912 | 2020-07-31 | Mecklenburg | Virginia | 51117 | 303 | 32 |
385695 | 385695 | 2020-07-30 | Mecklenburg | Virginia | 51117 | 303 | 31 |
382477 | 382477 | 2020-07-29 | Mecklenburg | Virginia | 51117 | 303 | 31 |
379260 | 379260 | 2020-07-28 | Mecklenburg | Virginia | 51117 | 297 | 30 |
376044 | 376044 | 2020-07-27 | Mecklenburg | Virginia | 51117 | 295 | 30 |
372830 | 372830 | 2020-07-26 | Mecklenburg | Virginia | 51117 | 294 | 30 |
369618 | 369618 | 2020-07-25 | Mecklenburg | Virginia | 51117 | 293 | 30 |
366409 | 366409 | 2020-07-24 | Mecklenburg | Virginia | 51117 | 288 | 30 |
363203 | 363203 | 2020-07-23 | Mecklenburg | Virginia | 51117 | 286 | 30 |
359997 | 359997 | 2020-07-22 | Mecklenburg | Virginia | 51117 | 283 | 30 |
356792 | 356792 | 2020-07-21 | Mecklenburg | Virginia | 51117 | 281 | 30 |
353589 | 353589 | 2020-07-20 | Mecklenburg | Virginia | 51117 | 280 | 30 |
350387 | 350387 | 2020-07-19 | Mecklenburg | Virginia | 51117 | 277 | 30 |
347186 | 347186 | 2020-07-18 | Mecklenburg | Virginia | 51117 | 273 | 30 |
343986 | 343986 | 2020-07-17 | Mecklenburg | Virginia | 51117 | 271 | 29 |
340787 | 340787 | 2020-07-16 | Mecklenburg | Virginia | 51117 | 269 | 29 |
337591 | 337591 | 2020-07-15 | Mecklenburg | Virginia | 51117 | 267 | 29 |
334396 | 334396 | 2020-07-14 | Mecklenburg | Virginia | 51117 | 263 | 29 |
331203 | 331203 | 2020-07-13 | Mecklenburg | Virginia | 51117 | 262 | 29 |
328017 | 328017 | 2020-07-12 | Mecklenburg | Virginia | 51117 | 257 | 29 |
324832 | 324832 | 2020-07-11 | Mecklenburg | Virginia | 51117 | 257 | 29 |
321651 | 321651 | 2020-07-10 | Mecklenburg | Virginia | 51117 | 253 | 29 |
318472 | 318472 | 2020-07-09 | Mecklenburg | Virginia | 51117 | 252 | 29 |
315299 | 315299 | 2020-07-08 | Mecklenburg | Virginia | 51117 | 250 | 29 |
312124 | 312124 | 2020-07-07 | Mecklenburg | Virginia | 51117 | 249 | 28 |
308955 | 308955 | 2020-07-06 | Mecklenburg | Virginia | 51117 | 249 | 28 |
305787 | 305787 | 2020-07-05 | Mecklenburg | Virginia | 51117 | 248 | 28 |
302623 | 302623 | 2020-07-04 | Mecklenburg | Virginia | 51117 | 248 | 28 |
299459 | 299459 | 2020-07-03 | Mecklenburg | Virginia | 51117 | 248 | 28 |
296297 | 296297 | 2020-07-02 | Mecklenburg | Virginia | 51117 | 246 | 28 |
293142 | 293142 | 2020-07-01 | Mecklenburg | Virginia | 51117 | 242 | 26 |
289989 | 289989 | 2020-06-30 | Mecklenburg | Virginia | 51117 | 240 | 26 |
286839 | 286839 | 2020-06-29 | Mecklenburg | Virginia | 51117 | 240 | 26 |
283693 | 283693 | 2020-06-28 | Mecklenburg | Virginia | 51117 | 240 | 26 |
280547 | 280547 | 2020-06-27 | Mecklenburg | Virginia | 51117 | 240 | 26 |
277399 | 277399 | 2020-06-26 | Mecklenburg | Virginia | 51117 | 238 | 26 |
274251 | 274251 | 2020-06-25 | Mecklenburg | Virginia | 51117 | 238 | 26 |
271111 | 271111 | 2020-06-24 | Mecklenburg | Virginia | 51117 | 237 | 26 |
267977 | 267977 | 2020-06-23 | Mecklenburg | Virginia | 51117 | 237 | 24 |
264848 | 264848 | 2020-06-22 | Mecklenburg | Virginia | 51117 | 235 | 24 |
261719 | 261719 | 2020-06-21 | Mecklenburg | Virginia | 51117 | 234 | 24 |
258592 | 258592 | 2020-06-20 | Mecklenburg | Virginia | 51117 | 234 | 24 |
255465 | 255465 | 2020-06-19 | Mecklenburg | Virginia | 51117 | 234 | 24 |
252346 | 252346 | 2020-06-18 | Mecklenburg | Virginia | 51117 | 233 | 24 |
249231 | 249231 | 2020-06-17 | Mecklenburg | Virginia | 51117 | 231 | 24 |
246119 | 246119 | 2020-06-16 | Mecklenburg | Virginia | 51117 | 231 | 24 |
243006 | 243006 | 2020-06-15 | Mecklenburg | Virginia | 51117 | 229 | 24 |
239895 | 239895 | 2020-06-14 | Mecklenburg | Virginia | 51117 | 226 | 24 |
236787 | 236787 | 2020-06-13 | Mecklenburg | Virginia | 51117 | 226 | 24 |
233680 | 233680 | 2020-06-12 | Mecklenburg | Virginia | 51117 | 226 | 24 |
230575 | 230575 | 2020-06-11 | Mecklenburg | Virginia | 51117 | 225 | 24 |
227471 | 227471 | 2020-06-10 | Mecklenburg | Virginia | 51117 | 224 | 24 |
224371 | 224371 | 2020-06-09 | Mecklenburg | Virginia | 51117 | 224 | 24 |
221275 | 221275 | 2020-06-08 | Mecklenburg | Virginia | 51117 | 224 | 23 |
218183 | 218183 | 2020-06-07 | Mecklenburg | Virginia | 51117 | 224 | 23 |
215093 | 215093 | 2020-06-06 | Mecklenburg | Virginia | 51117 | 222 | 23 |
212006 | 212006 | 2020-06-05 | Mecklenburg | Virginia | 51117 | 220 | 23 |
208921 | 208921 | 2020-06-04 | Mecklenburg | Virginia | 51117 | 219 | 23 |
205839 | 205839 | 2020-06-03 | Mecklenburg | Virginia | 51117 | 219 | 23 |
202760 | 202760 | 2020-06-02 | Mecklenburg | Virginia | 51117 | 218 | 22 |
199684 | 199684 | 2020-06-01 | Mecklenburg | Virginia | 51117 | 218 | 21 |
196611 | 196611 | 2020-05-31 | Mecklenburg | Virginia | 51117 | 217 | 21 |
193541 | 193541 | 2020-05-30 | Mecklenburg | Virginia | 51117 | 217 | 21 |
190475 | 190475 | 2020-05-29 | Mecklenburg | Virginia | 51117 | 214 | 21 |
187411 | 187411 | 2020-05-28 | Mecklenburg | Virginia | 51117 | 214 | 21 |
184354 | 184354 | 2020-05-27 | Mecklenburg | Virginia | 51117 | 212 | 21 |
181303 | 181303 | 2020-05-26 | Mecklenburg | Virginia | 51117 | 211 | 20 |
178259 | 178259 | 2020-05-25 | Mecklenburg | Virginia | 51117 | 205 | 20 |
175214 | 175214 | 2020-05-24 | Mecklenburg | Virginia | 51117 | 200 | 20 |
172171 | 172171 | 2020-05-23 | Mecklenburg | Virginia | 51117 | 193 | 20 |
169130 | 169130 | 2020-05-22 | Mecklenburg | Virginia | 51117 | 192 | 20 |
166094 | 166094 | 2020-05-21 | Mecklenburg | Virginia | 51117 | 185 | 20 |
163065 | 163065 | 2020-05-20 | Mecklenburg | Virginia | 51117 | 178 | 19 |
160037 | 160037 | 2020-05-19 | Mecklenburg | Virginia | 51117 | 178 | 17 |
157013 | 157013 | 2020-05-18 | Mecklenburg | Virginia | 51117 | 169 | 16 |
153996 | 153996 | 2020-05-17 | Mecklenburg | Virginia | 51117 | 167 | 16 |
150985 | 150985 | 2020-05-16 | Mecklenburg | Virginia | 51117 | 164 | 16 |
147976 | 147976 | 2020-05-15 | Mecklenburg | Virginia | 51117 | 152 | 15 |
144973 | 144973 | 2020-05-14 | Mecklenburg | Virginia | 51117 | 146 | 13 |
141976 | 141976 | 2020-05-13 | Mecklenburg | Virginia | 51117 | 138 | 13 |
138980 | 138980 | 2020-05-12 | Mecklenburg | Virginia | 51117 | 138 | 10 |
135989 | 135989 | 2020-05-11 | Mecklenburg | Virginia | 51117 | 134 | 10 |
132999 | 132999 | 2020-05-10 | Mecklenburg | Virginia | 51117 | 122 | 10 |
130009 | 130009 | 2020-05-09 | Mecklenburg | Virginia | 51117 | 118 | 10 |
127019 | 127019 | 2020-05-08 | Mecklenburg | Virginia | 51117 | 111 | 10 |
124034 | 124034 | 2020-05-07 | Mecklenburg | Virginia | 51117 | 109 | 10 |
121053 | 121053 | 2020-05-06 | Mecklenburg | Virginia | 51117 | 106 | 10 |
118089 | 118089 | 2020-05-05 | Mecklenburg | Virginia | 51117 | 106 | 10 |
115130 | 115130 | 2020-05-04 | Mecklenburg | Virginia | 51117 | 106 | 10 |
112247 | 112247 | 2020-05-03 | Mecklenburg | Virginia | 51117 | 106 | 10 |
109373 | 109373 | 2020-05-02 | Mecklenburg | Virginia | 51117 | 104 | 10 |
106504 | 106504 | 2020-05-01 | Mecklenburg | Virginia | 51117 | 103 | 10 |
103640 | 103640 | 2020-04-30 | Mecklenburg | Virginia | 51117 | 100 | 10 |
100785 | 100785 | 2020-04-29 | Mecklenburg | Virginia | 51117 | 100 | 10 |
97935 | 97935 | 2020-04-28 | Mecklenburg | Virginia | 51117 | 100 | 9 |
95091 | 95091 | 2020-04-27 | Mecklenburg | Virginia | 51117 | 98 | 9 |
92262 | 92262 | 2020-04-26 | Mecklenburg | Virginia | 51117 | 94 | 9 |
89445 | 89445 | 2020-04-25 | Mecklenburg | Virginia | 51117 | 85 | 9 |
86630 | 86630 | 2020-04-24 | Mecklenburg | Virginia | 51117 | 74 | 7 |
83823 | 83823 | 2020-04-23 | Mecklenburg | Virginia | 51117 | 71 | 1 |
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);