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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 37183 589
- 37037 586
- 37025 580
- 37067 580
- 37101 580
- 37119 580
- 37133 580
- 37191 579
- 37019 578
- 37049 578
- 37085 578
- 37189 577
- 37195 577
- 37063 576
- 37097 575
- 37163 575
- 37071 574
- 37081 574
- 37093 574
- 37109 574
- 37125 574
- 37129 574
- 37031 572
- 37057 572
- 37069 572
- 37135 572
- 37139 572
- 37147 572
- 37159 572
- 37167 572
- …
county >30
- Wake 589
- Chatham 586
- Cabarrus 580
- Forsyth 580
- Johnston 580
- Mecklenburg 580
- Onslow 580
- Wayne 579
- Brunswick 578
- Craven 578
- Harnett 578
- Watauga 577
- Wilson 577
- Durham 576
- Iredell 575
- Sampson 575
- Gaston 574
- Guilford 574
- Hoke 574
- Lincoln 574
- Moore 574
- New Hanover 574
- Carteret 572
- Davidson 572
- Franklin 572
- Orange 572
- Pasquotank 572
- Pitt 572
- Rowan 572
- Stanly 572
- …
state 1
- North Carolina · 56,509 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1808774 | 1808774 | 2021-10-12 | Alamance | North Carolina | 37001 | 25745 | 323 |
1808775 | 1808775 | 2021-10-12 | Alexander | North Carolina | 37003 | 6264 | 111 |
1808776 | 1808776 | 2021-10-12 | Alleghany | North Carolina | 37005 | 1580 | 5 |
1808777 | 1808777 | 2021-10-12 | Anson | North Carolina | 37007 | 3758 | 75 |
1808778 | 1808778 | 2021-10-12 | Ashe | North Carolina | 37009 | 3354 | 46 |
1808779 | 1808779 | 2021-10-12 | Avery | North Carolina | 37011 | 2661 | 32 |
1808780 | 1808780 | 2021-10-12 | Beaufort | North Carolina | 37013 | 6893 | 124 |
1808781 | 1808781 | 2021-10-12 | Bertie | North Carolina | 37015 | 2424 | 49 |
1808782 | 1808782 | 2021-10-12 | Bladen | North Carolina | 37017 | 5385 | 94 |
1808783 | 1808783 | 2021-10-12 | Brunswick | North Carolina | 37019 | 15841 | 228 |
1808784 | 1808784 | 2021-10-12 | Buncombe | North Carolina | 37021 | 27180 | 412 |
1808785 | 1808785 | 2021-10-12 | Burke | North Carolina | 37023 | 15337 | 206 |
1808786 | 1808786 | 2021-10-12 | Cabarrus | North Carolina | 37025 | 32084 | 325 |
1808787 | 1808787 | 2021-10-12 | Caldwell | North Carolina | 37027 | 12951 | 199 |
1808788 | 1808788 | 2021-10-12 | Camden | North Carolina | 37029 | 1076 | 8 |
1808789 | 1808789 | 2021-10-12 | Carteret | North Carolina | 37031 | 8110 | 76 |
1808790 | 1808790 | 2021-10-12 | Caswell | North Carolina | 37033 | 3117 | 37 |
1808791 | 1808791 | 2021-10-12 | Catawba | North Carolina | 37035 | 27685 | 407 |
1808792 | 1808792 | 2021-10-12 | Chatham | North Carolina | 37037 | 6589 | 91 |
1808793 | 1808793 | 2021-10-12 | Cherokee | North Carolina | 37039 | 4579 | 74 |
1808794 | 1808794 | 2021-10-12 | Chowan | North Carolina | 37041 | 2234 | 40 |
1808795 | 1808795 | 2021-10-12 | Clay | North Carolina | 37043 | 1609 | 35 |
1808796 | 1808796 | 2021-10-12 | Cleveland | North Carolina | 37045 | 17884 | 295 |
1808797 | 1808797 | 2021-10-12 | Columbus | North Carolina | 37047 | 9851 | 219 |
1808798 | 1808798 | 2021-10-12 | Craven | North Carolina | 37049 | 13959 | 151 |
1808799 | 1808799 | 2021-10-12 | Cumberland | North Carolina | 37051 | 43737 | 453 |
1808800 | 1808800 | 2021-10-12 | Currituck | North Carolina | 37053 | 2633 | 25 |
1808801 | 1808801 | 2021-10-12 | Dare | North Carolina | 37055 | 3656 | 12 |
1808802 | 1808802 | 2021-10-12 | Davidson | North Carolina | 37057 | 25195 | 290 |
1808803 | 1808803 | 2021-10-12 | Davie | North Carolina | 37059 | 6238 | 68 |
1808804 | 1808804 | 2021-10-12 | Duplin | North Carolina | 37061 | 9711 | 172 |
1808805 | 1808805 | 2021-10-12 | Durham | North Carolina | 37063 | 34333 | 255 |
1808806 | 1808806 | 2021-10-12 | Edgecombe | North Carolina | 37065 | 7771 | 123 |
1808807 | 1808807 | 2021-10-12 | Forsyth | North Carolina | 37067 | 50390 | 534 |
1808808 | 1808808 | 2021-10-12 | Franklin | North Carolina | 37069 | 9604 | 60 |
1808809 | 1808809 | 2021-10-12 | Gaston | North Carolina | 37071 | 39027 | 588 |
1808810 | 1808810 | 2021-10-12 | Gates | North Carolina | 37073 | 1047 | 18 |
1808811 | 1808811 | 2021-10-12 | Graham | North Carolina | 37075 | 1297 | 27 |
1808812 | 1808812 | 2021-10-12 | Granville | North Carolina | 37077 | 7738 | 99 |
1808813 | 1808813 | 2021-10-12 | Greene | North Carolina | 37079 | 3239 | 54 |
1808814 | 1808814 | 2021-10-12 | Guilford | North Carolina | 37081 | 65987 | 845 |
1808815 | 1808815 | 2021-10-12 | Halifax | North Carolina | 37083 | 7661 | 133 |
1808816 | 1808816 | 2021-10-12 | Harnett | North Carolina | 37085 | 17937 | 243 |
1808817 | 1808817 | 2021-10-12 | Haywood | North Carolina | 37087 | 7192 | 136 |
1808818 | 1808818 | 2021-10-12 | Henderson | North Carolina | 37089 | 14773 | 195 |
1808819 | 1808819 | 2021-10-12 | Hertford | North Carolina | 37091 | 2736 | 69 |
1808820 | 1808820 | 2021-10-12 | Hoke | North Carolina | 37093 | 6969 | 77 |
1808821 | 1808821 | 2021-10-12 | Hyde | North Carolina | 37095 | 819 | 11 |
1808822 | 1808822 | 2021-10-12 | Iredell | North Carolina | 37097 | 28098 | 311 |
1808823 | 1808823 | 2021-10-12 | Jackson | North Carolina | 37099 | 5472 | 70 |
1808824 | 1808824 | 2021-10-12 | Johnston | North Carolina | 37101 | 31615 | 317 |
1808825 | 1808825 | 2021-10-12 | Jones | North Carolina | 37103 | 1292 | 29 |
1808826 | 1808826 | 2021-10-12 | Lee | North Carolina | 37105 | 9255 | 104 |
1808827 | 1808827 | 2021-10-12 | Lenoir | North Carolina | 37107 | 9324 | 147 |
1808828 | 1808828 | 2021-10-12 | Lincoln | North Carolina | 37109 | 14571 | 107 |
1808829 | 1808829 | 2021-10-12 | Macon | North Carolina | 37113 | 4824 | 54 |
1808830 | 1808830 | 2021-10-12 | Madison | North Carolina | 37115 | 2688 | 56 |
1808831 | 1808831 | 2021-10-12 | Martin | North Carolina | 37117 | 3557 | 64 |
1808832 | 1808832 | 2021-10-12 | McDowell | North Carolina | 37111 | 8403 | 114 |
1808833 | 1808833 | 2021-10-12 | Mecklenburg | North Carolina | 37119 | 153971 | 1192 |
1808834 | 1808834 | 2021-10-12 | Mitchell | North Carolina | 37121 | 1958 | 18 |
1808835 | 1808835 | 2021-10-12 | Montgomery | North Carolina | 37123 | 4414 | 108 |
1808836 | 1808836 | 2021-10-12 | Moore | North Carolina | 37125 | 13318 | 240 |
1808837 | 1808837 | 2021-10-12 | Nash | North Carolina | 37127 | 15066 | 226 |
1808838 | 1808838 | 2021-10-12 | New Hanover | North Carolina | 37129 | 28194 | 277 |
1808839 | 1808839 | 2021-10-12 | Northampton | North Carolina | 37131 | 2544 | 62 |
1808840 | 1808840 | 2021-10-12 | Onslow | North Carolina | 37133 | 27562 | 241 |
1808841 | 1808841 | 2021-10-12 | Orange | North Carolina | 37135 | 11523 | 109 |
1808842 | 1808842 | 2021-10-12 | Pamlico | North Carolina | 37137 | 1662 | 23 |
1808843 | 1808843 | 2021-10-12 | Pasquotank | North Carolina | 37139 | 4915 | 98 |
1808844 | 1808844 | 2021-10-12 | Pender | North Carolina | 37141 | 8635 | 95 |
1808845 | 1808845 | 2021-10-12 | Perquimans | North Carolina | 37143 | 1475 | 15 |
1808846 | 1808846 | 2021-10-12 | Person | North Carolina | 37145 | 5021 | 87 |
1808847 | 1808847 | 2021-10-12 | Pitt | North Carolina | 37147 | 29036 | 138 |
1808848 | 1808848 | 2021-10-12 | Polk | North Carolina | 37149 | 2254 | 43 |
1808849 | 1808849 | 2021-10-12 | Randolph | North Carolina | 37151 | 21108 | 299 |
1808850 | 1808850 | 2021-10-12 | Richmond | North Carolina | 37153 | 6978 | 134 |
1808851 | 1808851 | 2021-10-12 | Robeson | North Carolina | 37155 | 24600 | 419 |
1808852 | 1808852 | 2021-10-12 | Rockingham | North Carolina | 37157 | 11561 | 192 |
1808853 | 1808853 | 2021-10-12 | Rowan | North Carolina | 37159 | 25739 | 426 |
1808854 | 1808854 | 2021-10-12 | Rutherford | North Carolina | 37161 | 11076 | 293 |
1808855 | 1808855 | 2021-10-12 | Sampson | North Carolina | 37163 | 10976 | 129 |
1808856 | 1808856 | 2021-10-12 | Scotland | North Carolina | 37165 | 5610 | 105 |
1808857 | 1808857 | 2021-10-12 | Stanly | North Carolina | 37167 | 11356 | 173 |
1808858 | 1808858 | 2021-10-12 | Stokes | North Carolina | 37169 | 5979 | 101 |
1808859 | 1808859 | 2021-10-12 | Surry | North Carolina | 37171 | 11939 | 220 |
1808860 | 1808860 | 2021-10-12 | Swain | North Carolina | 37173 | 1920 | 22 |
1808861 | 1808861 | 2021-10-12 | Transylvania | North Carolina | 37175 | 3814 | 47 |
1808862 | 1808862 | 2021-10-12 | Tyrrell | North Carolina | 37177 | 538 | 7 |
1808863 | 1808863 | 2021-10-12 | Union | North Carolina | 37179 | 35432 | 320 |
1808864 | 1808864 | 2021-10-12 | Vance | North Carolina | 37181 | 6554 | 97 |
1808865 | 1808865 | 2021-10-12 | Wake | North Carolina | 37183 | 127882 | 878 |
1808866 | 1808866 | 2021-10-12 | Warren | North Carolina | 37185 | 2311 | 28 |
1808867 | 1808867 | 2021-10-12 | Washington | North Carolina | 37187 | 1549 | 37 |
1808868 | 1808868 | 2021-10-12 | Watauga | North Carolina | 37189 | 6423 | 35 |
1808869 | 1808869 | 2021-10-12 | Wayne | North Carolina | 37191 | 15494 | 297 |
1808870 | 1808870 | 2021-10-12 | Wilkes | North Carolina | 37193 | 10340 | 173 |
1808871 | 1808871 | 2021-10-12 | Wilson | North Carolina | 37195 | 12920 | 225 |
1808872 | 1808872 | 2021-10-12 | Yadkin | North Carolina | 37197 | 5840 | 70 |
1808873 | 1808873 | 2021-10-12 | Yancey | North Carolina | 37199 | 2741 | 29 |
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);