ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Macon" 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 |
---|---|---|---|---|---|---|---|
536374 | 536374 | 2020-09-15 | Macon | North Carolina | 37113 | 567 | 2 |
533138 | 533138 | 2020-09-14 | Macon | North Carolina | 37113 | 564 | 2 |
529903 | 529903 | 2020-09-13 | Macon | North Carolina | 37113 | 562 | 2 |
526666 | 526666 | 2020-09-12 | Macon | North Carolina | 37113 | 561 | 2 |
523430 | 523430 | 2020-09-11 | Macon | North Carolina | 37113 | 559 | 2 |
520194 | 520194 | 2020-09-10 | Macon | North Carolina | 37113 | 557 | 2 |
516958 | 516958 | 2020-09-09 | Macon | North Carolina | 37113 | 553 | 2 |
513723 | 513723 | 2020-09-08 | Macon | North Carolina | 37113 | 551 | 2 |
510490 | 510490 | 2020-09-07 | Macon | North Carolina | 37113 | 551 | 2 |
507257 | 507257 | 2020-09-06 | Macon | North Carolina | 37113 | 549 | 2 |
504025 | 504025 | 2020-09-05 | Macon | North Carolina | 37113 | 549 | 2 |
500791 | 500791 | 2020-09-04 | Macon | North Carolina | 37113 | 548 | 2 |
497557 | 497557 | 2020-09-03 | Macon | North Carolina | 37113 | 548 | 2 |
494324 | 494324 | 2020-09-02 | Macon | North Carolina | 37113 | 545 | 2 |
491090 | 491090 | 2020-09-01 | Macon | North Carolina | 37113 | 545 | 2 |
487857 | 487857 | 2020-08-31 | Macon | North Carolina | 37113 | 540 | 2 |
484624 | 484624 | 2020-08-30 | Macon | North Carolina | 37113 | 539 | 2 |
481389 | 481389 | 2020-08-29 | Macon | North Carolina | 37113 | 538 | 2 |
478156 | 478156 | 2020-08-28 | Macon | North Carolina | 37113 | 529 | 2 |
474923 | 474923 | 2020-08-27 | Macon | North Carolina | 37113 | 529 | 2 |
471689 | 471689 | 2020-08-26 | Macon | North Carolina | 37113 | 521 | 2 |
468457 | 468457 | 2020-08-25 | Macon | North Carolina | 37113 | 520 | 2 |
465229 | 465229 | 2020-08-24 | Macon | North Carolina | 37113 | 520 | 2 |
462000 | 462000 | 2020-08-23 | Macon | North Carolina | 37113 | 516 | 2 |
458772 | 458772 | 2020-08-22 | Macon | North Carolina | 37113 | 505 | 2 |
455544 | 455544 | 2020-08-21 | Macon | North Carolina | 37113 | 497 | 2 |
452316 | 452316 | 2020-08-20 | Macon | North Carolina | 37113 | 492 | 2 |
449088 | 449088 | 2020-08-19 | Macon | North Carolina | 37113 | 485 | 2 |
445860 | 445860 | 2020-08-18 | Macon | North Carolina | 37113 | 480 | 2 |
442634 | 442634 | 2020-08-17 | Macon | North Carolina | 37113 | 480 | 2 |
439407 | 439407 | 2020-08-16 | Macon | North Carolina | 37113 | 478 | 2 |
436182 | 436182 | 2020-08-15 | Macon | North Carolina | 37113 | 475 | 2 |
432956 | 432956 | 2020-08-14 | Macon | North Carolina | 37113 | 469 | 2 |
429730 | 429730 | 2020-08-13 | Macon | North Carolina | 37113 | 469 | 2 |
426505 | 426505 | 2020-08-12 | Macon | North Carolina | 37113 | 467 | 2 |
423282 | 423282 | 2020-08-11 | Macon | North Carolina | 37113 | 465 | 2 |
420059 | 420059 | 2020-08-10 | Macon | North Carolina | 37113 | 463 | 2 |
416839 | 416839 | 2020-08-09 | Macon | North Carolina | 37113 | 463 | 2 |
413618 | 413618 | 2020-08-08 | Macon | North Carolina | 37113 | 459 | 2 |
410398 | 410398 | 2020-08-07 | Macon | North Carolina | 37113 | 457 | 2 |
407178 | 407178 | 2020-08-06 | Macon | North Carolina | 37113 | 456 | 2 |
403959 | 403959 | 2020-08-05 | Macon | North Carolina | 37113 | 452 | 2 |
400741 | 400741 | 2020-08-04 | Macon | North Carolina | 37113 | 453 | 2 |
397526 | 397526 | 2020-08-03 | Macon | North Carolina | 37113 | 450 | 2 |
394309 | 394309 | 2020-08-02 | Macon | North Carolina | 37113 | 446 | 2 |
391093 | 391093 | 2020-08-01 | Macon | North Carolina | 37113 | 444 | 2 |
387876 | 387876 | 2020-07-31 | Macon | North Carolina | 37113 | 439 | 2 |
384659 | 384659 | 2020-07-30 | Macon | North Carolina | 37113 | 439 | 2 |
381441 | 381441 | 2020-07-29 | Macon | North Carolina | 37113 | 435 | 1 |
378224 | 378224 | 2020-07-28 | Macon | North Carolina | 37113 | 431 | 1 |
375008 | 375008 | 2020-07-27 | Macon | North Carolina | 37113 | 429 | 1 |
371796 | 371796 | 2020-07-26 | Macon | North Carolina | 37113 | 422 | 1 |
368584 | 368584 | 2020-07-25 | Macon | North Carolina | 37113 | 421 | 1 |
365375 | 365375 | 2020-07-24 | Macon | North Carolina | 37113 | 417 | 1 |
362169 | 362169 | 2020-07-23 | Macon | North Carolina | 37113 | 407 | 1 |
358963 | 358963 | 2020-07-22 | Macon | North Carolina | 37113 | 397 | 1 |
355759 | 355759 | 2020-07-21 | Macon | North Carolina | 37113 | 392 | 1 |
352556 | 352556 | 2020-07-20 | Macon | North Carolina | 37113 | 382 | 1 |
349353 | 349353 | 2020-07-19 | Macon | North Carolina | 37113 | 381 | 1 |
346152 | 346152 | 2020-07-18 | Macon | North Carolina | 37113 | 379 | 1 |
342953 | 342953 | 2020-07-17 | Macon | North Carolina | 37113 | 368 | 1 |
339755 | 339755 | 2020-07-16 | Macon | North Carolina | 37113 | 360 | 1 |
336559 | 336559 | 2020-07-15 | Macon | North Carolina | 37113 | 337 | 1 |
333365 | 333365 | 2020-07-14 | Macon | North Carolina | 37113 | 333 | 1 |
330175 | 330175 | 2020-07-13 | Macon | North Carolina | 37113 | 328 | 1 |
326988 | 326988 | 2020-07-12 | Macon | North Carolina | 37113 | 323 | 1 |
323804 | 323804 | 2020-07-11 | Macon | North Carolina | 37113 | 322 | 1 |
320624 | 320624 | 2020-07-10 | Macon | North Carolina | 37113 | 322 | 1 |
317447 | 317447 | 2020-07-09 | Macon | North Carolina | 37113 | 315 | 1 |
314273 | 314273 | 2020-07-08 | Macon | North Carolina | 37113 | 298 | 1 |
311102 | 311102 | 2020-07-07 | Macon | North Carolina | 37113 | 293 | 1 |
307934 | 307934 | 2020-07-06 | Macon | North Carolina | 37113 | 291 | 1 |
304767 | 304767 | 2020-07-05 | Macon | North Carolina | 37113 | 289 | 1 |
301604 | 301604 | 2020-07-04 | Macon | North Carolina | 37113 | 288 | 1 |
298441 | 298441 | 2020-07-03 | Macon | North Carolina | 37113 | 288 | 1 |
295281 | 295281 | 2020-07-02 | Macon | North Carolina | 37113 | 289 | 1 |
292126 | 292126 | 2020-07-01 | Macon | North Carolina | 37113 | 282 | 1 |
288974 | 288974 | 2020-06-30 | Macon | North Carolina | 37113 | 282 | 1 |
285824 | 285824 | 2020-06-29 | Macon | North Carolina | 37113 | 280 | 1 |
282679 | 282679 | 2020-06-28 | Macon | North Carolina | 37113 | 277 | 1 |
279533 | 279533 | 2020-06-27 | Macon | North Carolina | 37113 | 266 | 1 |
276385 | 276385 | 2020-06-26 | Macon | North Carolina | 37113 | 263 | 1 |
273239 | 273239 | 2020-06-25 | Macon | North Carolina | 37113 | 262 | 1 |
270100 | 270100 | 2020-06-24 | Macon | North Carolina | 37113 | 259 | 1 |
266966 | 266966 | 2020-06-23 | Macon | North Carolina | 37113 | 256 | 1 |
263838 | 263838 | 2020-06-22 | Macon | North Carolina | 37113 | 252 | 1 |
260710 | 260710 | 2020-06-21 | Macon | North Carolina | 37113 | 252 | 1 |
257583 | 257583 | 2020-06-20 | Macon | North Carolina | 37113 | 247 | 1 |
254460 | 254460 | 2020-06-19 | Macon | North Carolina | 37113 | 243 | 1 |
251345 | 251345 | 2020-06-18 | Macon | North Carolina | 37113 | 235 | 1 |
248230 | 248230 | 2020-06-17 | Macon | North Carolina | 37113 | 236 | 1 |
245117 | 245117 | 2020-06-16 | Macon | North Carolina | 37113 | 237 | 1 |
242005 | 242005 | 2020-06-15 | Macon | North Carolina | 37113 | 231 | 1 |
238896 | 238896 | 2020-06-14 | Macon | North Carolina | 37113 | 217 | 1 |
235788 | 235788 | 2020-06-13 | Macon | North Carolina | 37113 | 185 | 1 |
232683 | 232683 | 2020-06-12 | Macon | North Carolina | 37113 | 178 | 1 |
229578 | 229578 | 2020-06-11 | Macon | North Carolina | 37113 | 159 | 1 |
226474 | 226474 | 2020-06-10 | Macon | North Carolina | 37113 | 158 | 1 |
223374 | 223374 | 2020-06-09 | Macon | North Carolina | 37113 | 157 | 1 |
220280 | 220280 | 2020-06-08 | Macon | North Carolina | 37113 | 146 | 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);