ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Mecklenburg" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536378 | 536378 | 2020-09-15 | Mecklenburg | North Carolina | 37119 | 27271 | 340 |
533142 | 533142 | 2020-09-14 | Mecklenburg | North Carolina | 37119 | 27172 | 339 |
529907 | 529907 | 2020-09-13 | Mecklenburg | North Carolina | 37119 | 27087 | 339 |
526670 | 526670 | 2020-09-12 | Mecklenburg | North Carolina | 37119 | 27012 | 336 |
523434 | 523434 | 2020-09-11 | Mecklenburg | North Carolina | 37119 | 26920 | 336 |
520198 | 520198 | 2020-09-10 | Mecklenburg | North Carolina | 37119 | 26784 | 336 |
516962 | 516962 | 2020-09-09 | Mecklenburg | North Carolina | 37119 | 26666 | 332 |
513727 | 513727 | 2020-09-08 | Mecklenburg | North Carolina | 37119 | 26584 | 332 |
510494 | 510494 | 2020-09-07 | Mecklenburg | North Carolina | 37119 | 26520 | 322 |
507261 | 507261 | 2020-09-06 | Mecklenburg | North Carolina | 37119 | 26391 | 322 |
504029 | 504029 | 2020-09-05 | Mecklenburg | North Carolina | 37119 | 26223 | 316 |
500795 | 500795 | 2020-09-04 | Mecklenburg | North Carolina | 37119 | 26223 | 316 |
497561 | 497561 | 2020-09-03 | Mecklenburg | North Carolina | 37119 | 26061 | 310 |
494328 | 494328 | 2020-09-02 | Mecklenburg | North Carolina | 37119 | 25908 | 306 |
491094 | 491094 | 2020-09-01 | Mecklenburg | North Carolina | 37119 | 25790 | 300 |
487861 | 487861 | 2020-08-31 | Mecklenburg | North Carolina | 37119 | 25556 | 295 |
484628 | 484628 | 2020-08-30 | Mecklenburg | North Carolina | 37119 | 25386 | 295 |
481393 | 481393 | 2020-08-29 | Mecklenburg | North Carolina | 37119 | 25262 | 290 |
478160 | 478160 | 2020-08-28 | Mecklenburg | North Carolina | 37119 | 25063 | 290 |
474927 | 474927 | 2020-08-27 | Mecklenburg | North Carolina | 37119 | 24952 | 290 |
471693 | 471693 | 2020-08-26 | Mecklenburg | North Carolina | 37119 | 24741 | 290 |
468461 | 468461 | 2020-08-25 | Mecklenburg | North Carolina | 37119 | 24602 | 289 |
465233 | 465233 | 2020-08-24 | Mecklenburg | North Carolina | 37119 | 24472 | 282 |
462004 | 462004 | 2020-08-23 | Mecklenburg | North Carolina | 37119 | 24303 | 282 |
458776 | 458776 | 2020-08-22 | Mecklenburg | North Carolina | 37119 | 24174 | 278 |
455548 | 455548 | 2020-08-21 | Mecklenburg | North Carolina | 37119 | 24008 | 278 |
452320 | 452320 | 2020-08-20 | Mecklenburg | North Carolina | 37119 | 23824 | 276 |
449092 | 449092 | 2020-08-19 | Mecklenburg | North Carolina | 37119 | 23614 | 273 |
445864 | 445864 | 2020-08-18 | Mecklenburg | North Carolina | 37119 | 23464 | 266 |
442638 | 442638 | 2020-08-17 | Mecklenburg | North Carolina | 37119 | 23308 | 266 |
439411 | 439411 | 2020-08-16 | Mecklenburg | North Carolina | 37119 | 23203 | 263 |
436186 | 436186 | 2020-08-15 | Mecklenburg | North Carolina | 37119 | 23111 | 263 |
432960 | 432960 | 2020-08-14 | Mecklenburg | North Carolina | 37119 | 22973 | 263 |
429734 | 429734 | 2020-08-13 | Mecklenburg | North Carolina | 37119 | 22834 | 253 |
426509 | 426509 | 2020-08-12 | Mecklenburg | North Carolina | 37119 | 22684 | 252 |
423286 | 423286 | 2020-08-11 | Mecklenburg | North Carolina | 37119 | 22487 | 248 |
420063 | 420063 | 2020-08-10 | Mecklenburg | North Carolina | 37119 | 22315 | 239 |
416843 | 416843 | 2020-08-09 | Mecklenburg | North Carolina | 37119 | 22255 | 239 |
413622 | 413622 | 2020-08-08 | Mecklenburg | North Carolina | 37119 | 22078 | 234 |
410402 | 410402 | 2020-08-07 | Mecklenburg | North Carolina | 37119 | 21876 | 233 |
407182 | 407182 | 2020-08-06 | Mecklenburg | North Carolina | 37119 | 21704 | 230 |
403963 | 403963 | 2020-08-05 | Mecklenburg | North Carolina | 37119 | 21517 | 225 |
400745 | 400745 | 2020-08-04 | Mecklenburg | North Carolina | 37119 | 21316 | 224 |
397530 | 397530 | 2020-08-03 | Mecklenburg | North Carolina | 37119 | 21054 | 222 |
394313 | 394313 | 2020-08-02 | Mecklenburg | North Carolina | 37119 | 20864 | 217 |
391097 | 391097 | 2020-08-01 | Mecklenburg | North Carolina | 37119 | 20679 | 215 |
387880 | 387880 | 2020-07-31 | Mecklenburg | North Carolina | 37119 | 20502 | 202 |
384663 | 384663 | 2020-07-30 | Mecklenburg | North Carolina | 37119 | 20261 | 202 |
381445 | 381445 | 2020-07-29 | Mecklenburg | North Carolina | 37119 | 19924 | 198 |
378228 | 378228 | 2020-07-28 | Mecklenburg | North Carolina | 37119 | 19707 | 195 |
375012 | 375012 | 2020-07-27 | Mecklenburg | North Carolina | 37119 | 19480 | 189 |
371800 | 371800 | 2020-07-26 | Mecklenburg | North Carolina | 37119 | 19268 | 188 |
368588 | 368588 | 2020-07-25 | Mecklenburg | North Carolina | 37119 | 19041 | 188 |
365379 | 365379 | 2020-07-24 | Mecklenburg | North Carolina | 37119 | 18703 | 187 |
362173 | 362173 | 2020-07-23 | Mecklenburg | North Carolina | 37119 | 18403 | 187 |
358967 | 358967 | 2020-07-22 | Mecklenburg | North Carolina | 37119 | 18075 | 186 |
355763 | 355763 | 2020-07-21 | Mecklenburg | North Carolina | 37119 | 17800 | 184 |
352560 | 352560 | 2020-07-20 | Mecklenburg | North Carolina | 37119 | 17571 | 182 |
349357 | 349357 | 2020-07-19 | Mecklenburg | North Carolina | 37119 | 17379 | 179 |
346156 | 346156 | 2020-07-18 | Mecklenburg | North Carolina | 37119 | 17047 | 177 |
342957 | 342957 | 2020-07-17 | Mecklenburg | North Carolina | 37119 | 16657 | 177 |
339759 | 339759 | 2020-07-16 | Mecklenburg | North Carolina | 37119 | 16360 | 174 |
336563 | 336563 | 2020-07-15 | Mecklenburg | North Carolina | 37119 | 15950 | 169 |
333369 | 333369 | 2020-07-14 | Mecklenburg | North Carolina | 37119 | 15680 | 168 |
330179 | 330179 | 2020-07-13 | Mecklenburg | North Carolina | 37119 | 15319 | 168 |
326992 | 326992 | 2020-07-12 | Mecklenburg | North Carolina | 37119 | 15024 | 168 |
323808 | 323808 | 2020-07-11 | Mecklenburg | North Carolina | 37119 | 14607 | 163 |
320628 | 320628 | 2020-07-10 | Mecklenburg | North Carolina | 37119 | 14157 | 163 |
317451 | 317451 | 2020-07-09 | Mecklenburg | North Carolina | 37119 | 13757 | 163 |
314277 | 314277 | 2020-07-08 | Mecklenburg | North Carolina | 37119 | 13489 | 163 |
311106 | 311106 | 2020-07-07 | Mecklenburg | North Carolina | 37119 | 13317 | 160 |
307938 | 307938 | 2020-07-06 | Mecklenburg | North Carolina | 37119 | 13111 | 156 |
304771 | 304771 | 2020-07-05 | Mecklenburg | North Carolina | 37119 | 12806 | 155 |
301608 | 301608 | 2020-07-04 | Mecklenburg | North Carolina | 37119 | 12576 | 155 |
298445 | 298445 | 2020-07-03 | Mecklenburg | North Carolina | 37119 | 12233 | 155 |
295285 | 295285 | 2020-07-02 | Mecklenburg | North Carolina | 37119 | 11803 | 152 |
292130 | 292130 | 2020-07-01 | Mecklenburg | North Carolina | 37119 | 11534 | 151 |
288978 | 288978 | 2020-06-30 | Mecklenburg | North Carolina | 37119 | 11170 | 150 |
285828 | 285828 | 2020-06-29 | Mecklenburg | North Carolina | 37119 | 10863 | 149 |
282683 | 282683 | 2020-06-28 | Mecklenburg | North Carolina | 37119 | 10592 | 149 |
279537 | 279537 | 2020-06-27 | Mecklenburg | North Carolina | 37119 | 10287 | 149 |
276389 | 276389 | 2020-06-26 | Mecklenburg | North Carolina | 37119 | 9944 | 148 |
273243 | 273243 | 2020-06-25 | Mecklenburg | North Carolina | 37119 | 9614 | 147 |
270104 | 270104 | 2020-06-24 | Mecklenburg | North Carolina | 37119 | 9333 | 147 |
266970 | 266970 | 2020-06-23 | Mecklenburg | North Carolina | 37119 | 9086 | 144 |
263842 | 263842 | 2020-06-22 | Mecklenburg | North Carolina | 37119 | 8956 | 143 |
260714 | 260714 | 2020-06-21 | Mecklenburg | North Carolina | 37119 | 8752 | 141 |
257587 | 257587 | 2020-06-20 | Mecklenburg | North Carolina | 37119 | 8511 | 139 |
254464 | 254464 | 2020-06-19 | Mecklenburg | North Carolina | 37119 | 8166 | 137 |
251349 | 251349 | 2020-06-18 | Mecklenburg | North Carolina | 37119 | 7804 | 136 |
248234 | 248234 | 2020-06-17 | Mecklenburg | North Carolina | 37119 | 7563 | 134 |
245121 | 245121 | 2020-06-16 | Mecklenburg | North Carolina | 37119 | 7468 | 134 |
242009 | 242009 | 2020-06-15 | Mecklenburg | North Carolina | 37119 | 7321 | 131 |
238900 | 238900 | 2020-06-14 | Mecklenburg | North Carolina | 37119 | 7131 | 126 |
235792 | 235792 | 2020-06-13 | Mecklenburg | North Carolina | 37119 | 6862 | 125 |
232687 | 232687 | 2020-06-12 | Mecklenburg | North Carolina | 37119 | 6538 | 123 |
229582 | 229582 | 2020-06-11 | Mecklenburg | North Carolina | 37119 | 6155 | 123 |
226478 | 226478 | 2020-06-10 | Mecklenburg | North Carolina | 37119 | 5861 | 119 |
223378 | 223378 | 2020-06-09 | Mecklenburg | North Carolina | 37119 | 5744 | 115 |
220284 | 220284 | 2020-06-08 | Mecklenburg | North Carolina | 37119 | 5682 | 110 |
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);