ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,809 rows where state = "North Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 37183 802
- 37037 799
- 37025 793
- 37067 793
- 37101 793
- 37119 793
- 37133 793
- 37191 792
- 37019 791
- 37049 791
- 37085 791
- 37189 790
- 37195 790
- 37063 789
- 37097 788
- 37163 788
- 37071 787
- 37081 787
- 37093 787
- 37109 787
- 37125 787
- 37129 787
- 37031 785
- 37057 785
- 37069 785
- 37135 785
- 37139 785
- 37147 785
- 37159 785
- 37167 785
- …
county >30
- Wake 802
- Chatham 799
- Cabarrus 793
- Forsyth 793
- Johnston 793
- Mecklenburg 793
- Onslow 793
- Wayne 792
- Brunswick 791
- Craven 791
- Harnett 791
- Watauga 790
- Wilson 790
- Durham 789
- Iredell 788
- Sampson 788
- Gaston 787
- Guilford 787
- Hoke 787
- Lincoln 787
- Moore 787
- New Hanover 787
- Carteret 785
- Davidson 785
- Franklin 785
- Orange 785
- Pasquotank 785
- Pitt 785
- Rowan 785
- Stanly 785
- …
state 1
- North Carolina · 77,709 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
292071 | 292071 | 2020-07-01 | Alamance | North Carolina | 37001 | 1151 | 37 |
295226 | 295226 | 2020-07-02 | Alamance | North Carolina | 37001 | 1179 | 37 |
298386 | 298386 | 2020-07-03 | Alamance | North Carolina | 37001 | 1207 | 37 |
301549 | 301549 | 2020-07-04 | Alamance | North Carolina | 37001 | 1240 | 37 |
304712 | 304712 | 2020-07-05 | Alamance | North Carolina | 37001 | 1274 | 37 |
307879 | 307879 | 2020-07-06 | Alamance | North Carolina | 37001 | 1292 | 37 |
311047 | 311047 | 2020-07-07 | Alamance | North Carolina | 37001 | 1309 | 37 |
314218 | 314218 | 2020-07-08 | Alamance | North Carolina | 37001 | 1319 | 37 |
317392 | 317392 | 2020-07-09 | Alamance | North Carolina | 37001 | 1357 | 37 |
320569 | 320569 | 2020-07-10 | Alamance | North Carolina | 37001 | 1388 | 37 |
323749 | 323749 | 2020-07-11 | Alamance | North Carolina | 37001 | 1401 | 37 |
326933 | 326933 | 2020-07-12 | Alamance | North Carolina | 37001 | 1428 | 37 |
330120 | 330120 | 2020-07-13 | Alamance | North Carolina | 37001 | 1460 | 37 |
333310 | 333310 | 2020-07-14 | Alamance | North Carolina | 37001 | 1492 | 37 |
336504 | 336504 | 2020-07-15 | Alamance | North Carolina | 37001 | 1535 | 37 |
339700 | 339700 | 2020-07-16 | Alamance | North Carolina | 37001 | 1569 | 37 |
342898 | 342898 | 2020-07-17 | Alamance | North Carolina | 37001 | 1607 | 38 |
346097 | 346097 | 2020-07-18 | Alamance | North Carolina | 37001 | 1648 | 39 |
349298 | 349298 | 2020-07-19 | Alamance | North Carolina | 37001 | 1684 | 39 |
352501 | 352501 | 2020-07-20 | Alamance | North Carolina | 37001 | 1718 | 39 |
355704 | 355704 | 2020-07-21 | Alamance | North Carolina | 37001 | 1755 | 40 |
358908 | 358908 | 2020-07-22 | Alamance | North Carolina | 37001 | 1809 | 40 |
362114 | 362114 | 2020-07-23 | Alamance | North Carolina | 37001 | 1842 | 40 |
365320 | 365320 | 2020-07-24 | Alamance | North Carolina | 37001 | 1896 | 40 |
368529 | 368529 | 2020-07-25 | Alamance | North Carolina | 37001 | 1920 | 40 |
371741 | 371741 | 2020-07-26 | Alamance | North Carolina | 37001 | 1954 | 41 |
374953 | 374953 | 2020-07-27 | Alamance | North Carolina | 37001 | 1973 | 41 |
378169 | 378169 | 2020-07-28 | Alamance | North Carolina | 37001 | 2029 | 41 |
381386 | 381386 | 2020-07-29 | Alamance | North Carolina | 37001 | 2066 | 41 |
384604 | 384604 | 2020-07-30 | Alamance | North Carolina | 37001 | 2101 | 41 |
387821 | 387821 | 2020-07-31 | Alamance | North Carolina | 37001 | 2148 | 41 |
391038 | 391038 | 2020-08-01 | Alamance | North Carolina | 37001 | 2189 | 41 |
394254 | 394254 | 2020-08-02 | Alamance | North Carolina | 37001 | 2207 | 41 |
397471 | 397471 | 2020-08-03 | Alamance | North Carolina | 37001 | 2248 | 41 |
400686 | 400686 | 2020-08-04 | Alamance | North Carolina | 37001 | 2280 | 41 |
403904 | 403904 | 2020-08-05 | Alamance | North Carolina | 37001 | 2298 | 41 |
407123 | 407123 | 2020-08-06 | Alamance | North Carolina | 37001 | 2343 | 41 |
410343 | 410343 | 2020-08-07 | Alamance | North Carolina | 37001 | 2365 | 41 |
413563 | 413563 | 2020-08-08 | Alamance | North Carolina | 37001 | 2396 | 41 |
416784 | 416784 | 2020-08-09 | Alamance | North Carolina | 37001 | 2448 | 41 |
420004 | 420004 | 2020-08-10 | Alamance | North Carolina | 37001 | 2472 | 41 |
423227 | 423227 | 2020-08-11 | Alamance | North Carolina | 37001 | 2496 | 41 |
426450 | 426450 | 2020-08-12 | Alamance | North Carolina | 37001 | 2526 | 41 |
429675 | 429675 | 2020-08-13 | Alamance | North Carolina | 37001 | 2567 | 42 |
432901 | 432901 | 2020-08-14 | Alamance | North Carolina | 37001 | 2586 | 42 |
436127 | 436127 | 2020-08-15 | Alamance | North Carolina | 37001 | 2612 | 42 |
439352 | 439352 | 2020-08-16 | Alamance | North Carolina | 37001 | 2639 | 42 |
442579 | 442579 | 2020-08-17 | Alamance | North Carolina | 37001 | 2653 | 42 |
445805 | 445805 | 2020-08-18 | Alamance | North Carolina | 37001 | 2681 | 42 |
449033 | 449033 | 2020-08-19 | Alamance | North Carolina | 37001 | 2698 | 44 |
452261 | 452261 | 2020-08-20 | Alamance | North Carolina | 37001 | 2726 | 44 |
455489 | 455489 | 2020-08-21 | Alamance | North Carolina | 37001 | 2786 | 44 |
458717 | 458717 | 2020-08-22 | Alamance | North Carolina | 37001 | 2838 | 44 |
461945 | 461945 | 2020-08-23 | Alamance | North Carolina | 37001 | 2876 | 44 |
465174 | 465174 | 2020-08-24 | Alamance | North Carolina | 37001 | 2921 | 44 |
468402 | 468402 | 2020-08-25 | Alamance | North Carolina | 37001 | 2931 | 44 |
471634 | 471634 | 2020-08-26 | Alamance | North Carolina | 37001 | 2955 | 44 |
474868 | 474868 | 2020-08-27 | Alamance | North Carolina | 37001 | 3012 | 44 |
478101 | 478101 | 2020-08-28 | Alamance | North Carolina | 37001 | 3027 | 45 |
481334 | 481334 | 2020-08-29 | Alamance | North Carolina | 37001 | 3076 | 46 |
484569 | 484569 | 2020-08-30 | Alamance | North Carolina | 37001 | 3100 | 46 |
487802 | 487802 | 2020-08-31 | Alamance | North Carolina | 37001 | 3209 | 46 |
491035 | 491035 | 2020-09-01 | Alamance | North Carolina | 37001 | 3243 | 46 |
494269 | 494269 | 2020-09-02 | Alamance | North Carolina | 37001 | 3259 | 46 |
497502 | 497502 | 2020-09-03 | Alamance | North Carolina | 37001 | 3294 | 46 |
500736 | 500736 | 2020-09-04 | Alamance | North Carolina | 37001 | 3334 | 46 |
503970 | 503970 | 2020-09-05 | Alamance | North Carolina | 37001 | 3379 | 46 |
507202 | 507202 | 2020-09-06 | Alamance | North Carolina | 37001 | 3391 | 46 |
510435 | 510435 | 2020-09-07 | Alamance | North Carolina | 37001 | 3417 | 46 |
513668 | 513668 | 2020-09-08 | Alamance | North Carolina | 37001 | 3428 | 47 |
516903 | 516903 | 2020-09-09 | Alamance | North Carolina | 37001 | 3431 | 47 |
520139 | 520139 | 2020-09-10 | Alamance | North Carolina | 37001 | 3452 | 48 |
523375 | 523375 | 2020-09-11 | Alamance | North Carolina | 37001 | 3502 | 48 |
526611 | 526611 | 2020-09-12 | Alamance | North Carolina | 37001 | 3526 | 48 |
529848 | 529848 | 2020-09-13 | Alamance | North Carolina | 37001 | 3558 | 48 |
533083 | 533083 | 2020-09-14 | Alamance | North Carolina | 37001 | 3573 | 48 |
536319 | 536319 | 2020-09-15 | Alamance | North Carolina | 37001 | 3584 | 48 |
539556 | 539556 | 2020-09-16 | Alamance | North Carolina | 37001 | 3601 | 48 |
542792 | 542792 | 2020-09-17 | Alamance | North Carolina | 37001 | 3630 | 48 |
546029 | 546029 | 2020-09-18 | Alamance | North Carolina | 37001 | 3668 | 48 |
549268 | 549268 | 2020-09-19 | Alamance | North Carolina | 37001 | 3695 | 48 |
552507 | 552507 | 2020-09-20 | Alamance | North Carolina | 37001 | 3728 | 54 |
555744 | 555744 | 2020-09-21 | Alamance | North Carolina | 37001 | 3749 | 54 |
558981 | 558981 | 2020-09-22 | Alamance | North Carolina | 37001 | 3771 | 54 |
562218 | 562218 | 2020-09-23 | Alamance | North Carolina | 37001 | 3793 | 54 |
565459 | 565459 | 2020-09-24 | Alamance | North Carolina | 37001 | 3837 | 54 |
568700 | 568700 | 2020-09-25 | Alamance | North Carolina | 37001 | 3881 | 54 |
571942 | 571942 | 2020-09-26 | Alamance | North Carolina | 37001 | 3916 | 54 |
575186 | 575186 | 2020-09-27 | Alamance | North Carolina | 37001 | 3934 | 54 |
578427 | 578427 | 2020-09-28 | Alamance | North Carolina | 37001 | 3950 | 54 |
581667 | 581667 | 2020-09-29 | Alamance | North Carolina | 37001 | 3962 | 54 |
584908 | 584908 | 2020-09-30 | Alamance | North Carolina | 37001 | 3977 | 55 |
588148 | 588148 | 2020-10-01 | Alamance | North Carolina | 37001 | 4018 | 55 |
591389 | 591389 | 2020-10-02 | Alamance | North Carolina | 37001 | 4081 | 56 |
594630 | 594630 | 2020-10-03 | Alamance | North Carolina | 37001 | 4117 | 56 |
597873 | 597873 | 2020-10-04 | Alamance | North Carolina | 37001 | 4121 | 56 |
601116 | 601116 | 2020-10-05 | Alamance | North Carolina | 37001 | 4155 | 57 |
604358 | 604358 | 2020-10-06 | Alamance | North Carolina | 37001 | 4172 | 59 |
607601 | 607601 | 2020-10-07 | Alamance | North Carolina | 37001 | 4204 | 59 |
610843 | 610843 | 2020-10-08 | Alamance | North Carolina | 37001 | 4287 | 59 |
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);