ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2021-08-25 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alamance 1
- Alexander 1
- Alleghany 1
- Anson 1
- Ashe 1
- Avery 1
- Beaufort 1
- Bertie 1
- Bladen 1
- Brunswick 1
- Buncombe 1
- Burke 1
- Cabarrus 1
- Caldwell 1
- Camden 1
- Carteret 1
- Caswell 1
- Catawba 1
- Chatham 1
- Cherokee 1
- Chowan 1
- Clay 1
- Cleveland 1
- Columbus 1
- Craven 1
- Cumberland 1
- Currituck 1
- Dare 1
- Davidson 1
- Davie 1
- …
state 1
- North Carolina · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1652833 | 1652833 | 2021-08-25 | Alamance | North Carolina | 37001 | 21083 | 292 |
1652834 | 1652834 | 2021-08-25 | Alexander | North Carolina | 37003 | 5074 | 90 |
1652835 | 1652835 | 2021-08-25 | Alleghany | North Carolina | 37005 | 1167 | 5 |
1652836 | 1652836 | 2021-08-25 | Anson | North Carolina | 37007 | 2970 | 60 |
1652837 | 1652837 | 2021-08-25 | Ashe | North Carolina | 37009 | 2571 | 45 |
1652838 | 1652838 | 2021-08-25 | Avery | North Carolina | 37011 | 2274 | 22 |
1652839 | 1652839 | 2021-08-25 | Beaufort | North Carolina | 37013 | 5245 | 105 |
1652840 | 1652840 | 2021-08-25 | Bertie | North Carolina | 37015 | 1973 | 46 |
1652841 | 1652841 | 2021-08-25 | Bladen | North Carolina | 37017 | 4528 | 71 |
1652842 | 1652842 | 2021-08-25 | Brunswick | North Carolina | 37019 | 12177 | 175 |
1652843 | 1652843 | 2021-08-25 | Buncombe | North Carolina | 37021 | 21222 | 350 |
1652844 | 1652844 | 2021-08-25 | Burke | North Carolina | 37023 | 11734 | 164 |
1652845 | 1652845 | 2021-08-25 | Cabarrus | North Carolina | 37025 | 26350 | 276 |
1652846 | 1652846 | 2021-08-25 | Caldwell | North Carolina | 37027 | 10568 | 111 |
1652847 | 1652847 | 2021-08-25 | Camden | North Carolina | 37029 | 771 | 7 |
1652848 | 1652848 | 2021-08-25 | Carteret | North Carolina | 37031 | 6248 | 57 |
1652849 | 1652849 | 2021-08-25 | Caswell | North Carolina | 37033 | 2415 | 30 |
1652850 | 1652850 | 2021-08-25 | Catawba | North Carolina | 37035 | 22507 | 321 |
1652851 | 1652851 | 2021-08-25 | Chatham | North Carolina | 37037 | 5608 | 89 |
1652852 | 1652852 | 2021-08-25 | Cherokee | North Carolina | 37039 | 3389 | 39 |
1652853 | 1652853 | 2021-08-25 | Chowan | North Carolina | 37041 | 1705 | 37 |
1652854 | 1652854 | 2021-08-25 | Clay | North Carolina | 37043 | 1102 | 18 |
1652855 | 1652855 | 2021-08-25 | Cleveland | North Carolina | 37045 | 13821 | 243 |
1652856 | 1652856 | 2021-08-25 | Columbus | North Carolina | 37047 | 8208 | 171 |
1652857 | 1652857 | 2021-08-25 | Craven | North Carolina | 37049 | 10706 | 130 |
1652858 | 1652858 | 2021-08-25 | Cumberland | North Carolina | 37051 | 36379 | 371 |
1652859 | 1652859 | 2021-08-25 | Currituck | North Carolina | 37053 | 1863 | 17 |
1652860 | 1652860 | 2021-08-25 | Dare | North Carolina | 37055 | 2878 | 10 |
1652861 | 1652861 | 2021-08-25 | Davidson | North Carolina | 37057 | 19473 | 211 |
1652862 | 1652862 | 2021-08-25 | Davie | North Carolina | 37059 | 4887 | 48 |
1652863 | 1652863 | 2021-08-25 | Duplin | North Carolina | 37061 | 7873 | 151 |
1652864 | 1652864 | 2021-08-25 | Durham | North Carolina | 37063 | 29279 | 242 |
1652865 | 1652865 | 2021-08-25 | Edgecombe | North Carolina | 37065 | 6279 | 115 |
1652866 | 1652866 | 2021-08-25 | Forsyth | North Carolina | 37067 | 41724 | 443 |
1652867 | 1652867 | 2021-08-25 | Franklin | North Carolina | 37069 | 7920 | 55 |
1652868 | 1652868 | 2021-08-25 | Gaston | North Carolina | 37071 | 31080 | 468 |
1652869 | 1652869 | 2021-08-25 | Gates | North Carolina | 37073 | 829 | 13 |
1652870 | 1652870 | 2021-08-25 | Graham | North Carolina | 37075 | 863 | 16 |
1652871 | 1652871 | 2021-08-25 | Granville | North Carolina | 37077 | 6627 | 87 |
1652872 | 1652872 | 2021-08-25 | Greene | North Carolina | 37079 | 2778 | 49 |
1652873 | 1652873 | 2021-08-25 | Guilford | North Carolina | 37081 | 54435 | 757 |
1652874 | 1652874 | 2021-08-25 | Halifax | North Carolina | 37083 | 6343 | 116 |
1652875 | 1652875 | 2021-08-25 | Harnett | North Carolina | 37085 | 14461 | 194 |
1652876 | 1652876 | 2021-08-25 | Haywood | North Carolina | 37087 | 5407 | 105 |
1652877 | 1652877 | 2021-08-25 | Henderson | North Carolina | 37089 | 12134 | 165 |
1652878 | 1652878 | 2021-08-25 | Hertford | North Carolina | 37091 | 2280 | 65 |
1652879 | 1652879 | 2021-08-25 | Hoke | North Carolina | 37093 | 5814 | 59 |
1652880 | 1652880 | 2021-08-25 | Hyde | North Carolina | 37095 | 696 | 9 |
1652881 | 1652881 | 2021-08-25 | Iredell | North Carolina | 37097 | 22306 | 242 |
1652882 | 1652882 | 2021-08-25 | Jackson | North Carolina | 37099 | 4281 | 58 |
1652883 | 1652883 | 2021-08-25 | Johnston | North Carolina | 37101 | 26361 | 253 |
1652884 | 1652884 | 2021-08-25 | Jones | North Carolina | 37103 | 1002 | 29 |
1652885 | 1652885 | 2021-08-25 | Lee | North Carolina | 37105 | 7395 | 88 |
1652886 | 1652886 | 2021-08-25 | Lenoir | North Carolina | 37107 | 7188 | 130 |
1652887 | 1652887 | 2021-08-25 | Lincoln | North Carolina | 37109 | 11875 | 86 |
1652888 | 1652888 | 2021-08-25 | Macon | North Carolina | 37113 | 3652 | 43 |
1652889 | 1652889 | 2021-08-25 | Madison | North Carolina | 37115 | 1919 | 43 |
1652890 | 1652890 | 2021-08-25 | Martin | North Carolina | 37117 | 2757 | 50 |
1652891 | 1652891 | 2021-08-25 | McDowell | North Carolina | 37111 | 6203 | 65 |
1652892 | 1652892 | 2021-08-25 | Mecklenburg | North Carolina | 37119 | 132503 | 1025 |
1652893 | 1652893 | 2021-08-25 | Mitchell | North Carolina | 37121 | 1616 | 16 |
1652894 | 1652894 | 2021-08-25 | Montgomery | North Carolina | 37123 | 3714 | 97 |
1652895 | 1652895 | 2021-08-25 | Moore | North Carolina | 37125 | 10794 | 208 |
1652896 | 1652896 | 2021-08-25 | Nash | North Carolina | 37127 | 12634 | 201 |
1652897 | 1652897 | 2021-08-25 | New Hanover | North Carolina | 37129 | 22988 | 190 |
1652898 | 1652898 | 2021-08-25 | Northampton | North Carolina | 37131 | 2060 | 62 |
1652899 | 1652899 | 2021-08-25 | Onslow | North Carolina | 37133 | 21214 | 173 |
1652900 | 1652900 | 2021-08-25 | Orange | North Carolina | 37135 | 9602 | 102 |
1652901 | 1652901 | 2021-08-25 | Pamlico | North Carolina | 37137 | 1252 | 14 |
1652902 | 1652902 | 2021-08-25 | Pasquotank | North Carolina | 37139 | 3796 | 88 |
1652903 | 1652903 | 2021-08-25 | Pender | North Carolina | 37141 | 6746 | 74 |
1652904 | 1652904 | 2021-08-25 | Perquimans | North Carolina | 37143 | 1154 | 11 |
1652905 | 1652905 | 2021-08-25 | Person | North Carolina | 37145 | 4008 | 76 |
1652906 | 1652906 | 2021-08-25 | Pitt | North Carolina | 37147 | 23635 | 109 |
1652907 | 1652907 | 2021-08-25 | Polk | North Carolina | 37149 | 1724 | 33 |
1652908 | 1652908 | 2021-08-25 | Randolph | North Carolina | 37151 | 16997 | 249 |
1652909 | 1652909 | 2021-08-25 | Richmond | North Carolina | 37153 | 5758 | 114 |
1652910 | 1652910 | 2021-08-25 | Robeson | North Carolina | 37155 | 20692 | 309 |
1652911 | 1652911 | 2021-08-25 | Rockingham | North Carolina | 37157 | 9132 | 188 |
1652912 | 1652912 | 2021-08-25 | Rowan | North Carolina | 37159 | 20353 | 337 |
1652913 | 1652913 | 2021-08-25 | Rutherford | North Carolina | 37161 | 8599 | 226 |
1652914 | 1652914 | 2021-08-25 | Sampson | North Carolina | 37163 | 9310 | 115 |
1652915 | 1652915 | 2021-08-25 | Scotland | North Carolina | 37165 | 4575 | 96 |
1652916 | 1652916 | 2021-08-25 | Stanly | North Carolina | 37167 | 9107 | 147 |
1652917 | 1652917 | 2021-08-25 | Stokes | North Carolina | 37169 | 4810 | 83 |
1652918 | 1652918 | 2021-08-25 | Surry | North Carolina | 37171 | 9529 | 181 |
1652919 | 1652919 | 2021-08-25 | Swain | North Carolina | 37173 | 1442 | 19 |
1652920 | 1652920 | 2021-08-25 | Transylvania | North Carolina | 37175 | 2959 | 35 |
1652921 | 1652921 | 2021-08-25 | Tyrrell | North Carolina | 37177 | 418 | 6 |
1652922 | 1652922 | 2021-08-25 | Union | North Carolina | 37179 | 28792 | 243 |
1652923 | 1652923 | 2021-08-25 | Vance | North Carolina | 37181 | 5372 | 90 |
1652924 | 1652924 | 2021-08-25 | Wake | North Carolina | 37183 | 106469 | 767 |
1652925 | 1652925 | 2021-08-25 | Warren | North Carolina | 37185 | 1934 | 20 |
1652926 | 1652926 | 2021-08-25 | Washington | North Carolina | 37187 | 1244 | 32 |
1652927 | 1652927 | 2021-08-25 | Watauga | North Carolina | 37189 | 5402 | 33 |
1652928 | 1652928 | 2021-08-25 | Wayne | North Carolina | 37191 | 12967 | 247 |
1652929 | 1652929 | 2021-08-25 | Wilkes | North Carolina | 37193 | 8234 | 127 |
1652930 | 1652930 | 2021-08-25 | Wilson | North Carolina | 37195 | 10807 | 189 |
1652931 | 1652931 | 2021-08-25 | Yadkin | North Carolina | 37197 | 4739 | 57 |
1652932 | 1652932 | 2021-08-25 | Yancey | North Carolina | 37199 | 2077 | 28 |
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);