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-01-26 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
967775 | 967775 | 2021-01-26 | Alamance | North Carolina | 37001 | 13380 | 171 |
967776 | 967776 | 2021-01-26 | Alexander | North Carolina | 37003 | 3398 | 57 |
967777 | 967777 | 2021-01-26 | Alleghany | North Carolina | 37005 | 810 | 3 |
967778 | 967778 | 2021-01-26 | Anson | North Carolina | 37007 | 1956 | 41 |
967779 | 967779 | 2021-01-26 | Ashe | North Carolina | 37009 | 1645 | 34 |
967780 | 967780 | 2021-01-26 | Avery | North Carolina | 37011 | 1652 | 16 |
967781 | 967781 | 2021-01-26 | Beaufort | North Carolina | 37013 | 3675 | 69 |
967782 | 967782 | 2021-01-26 | Bertie | North Carolina | 37015 | 1490 | 35 |
967783 | 967783 | 2021-01-26 | Bladen | North Carolina | 37017 | 2495 | 32 |
967784 | 967784 | 2021-01-26 | Brunswick | North Carolina | 37019 | 6245 | 86 |
967785 | 967785 | 2021-01-26 | Buncombe | North Carolina | 37021 | 12833 | 257 |
967786 | 967786 | 2021-01-26 | Burke | North Carolina | 37023 | 8231 | 102 |
967787 | 967787 | 2021-01-26 | Cabarrus | North Carolina | 37025 | 15442 | 187 |
967788 | 967788 | 2021-01-26 | Caldwell | North Carolina | 37027 | 7665 | 36 |
967789 | 967789 | 2021-01-26 | Camden | North Carolina | 37029 | 441 | 5 |
967790 | 967790 | 2021-01-26 | Carteret | North Carolina | 37031 | 3629 | 19 |
967791 | 967791 | 2021-01-26 | Caswell | North Carolina | 37033 | 1664 | 12 |
967792 | 967792 | 2021-01-26 | Catawba | North Carolina | 37035 | 15026 | 227 |
967793 | 967793 | 2021-01-26 | Chatham | North Carolina | 37037 | 3575 | 69 |
967794 | 967794 | 2021-01-26 | Cherokee | North Carolina | 37039 | 1787 | 16 |
967795 | 967795 | 2021-01-26 | Chowan | North Carolina | 37041 | 1159 | 20 |
967796 | 967796 | 2021-01-26 | Clay | North Carolina | 37043 | 578 | 5 |
967797 | 967797 | 2021-01-26 | Cleveland | North Carolina | 37045 | 9088 | 175 |
967798 | 967798 | 2021-01-26 | Columbus | North Carolina | 37047 | 4903 | 107 |
967799 | 967799 | 2021-01-26 | Craven | North Carolina | 37049 | 6879 | 96 |
967800 | 967800 | 2021-01-26 | Cumberland | North Carolina | 37051 | 19190 | 178 |
967801 | 967801 | 2021-01-26 | Currituck | North Carolina | 37053 | 1044 | 13 |
967802 | 967802 | 2021-01-26 | Dare | North Carolina | 37055 | 1615 | 6 |
967803 | 967803 | 2021-01-26 | Davidson | North Carolina | 37057 | 12430 | 115 |
967804 | 967804 | 2021-01-26 | Davie | North Carolina | 37059 | 2884 | 17 |
967805 | 967805 | 2021-01-26 | Duplin | North Carolina | 37061 | 5120 | 103 |
967806 | 967806 | 2021-01-26 | Durham | North Carolina | 37063 | 19016 | 180 |
967807 | 967807 | 2021-01-26 | Edgecombe | North Carolina | 37065 | 3871 | 90 |
967808 | 967808 | 2021-01-26 | Forsyth | North Carolina | 37067 | 26819 | 275 |
967809 | 967809 | 2021-01-26 | Franklin | North Carolina | 37069 | 4443 | 40 |
967810 | 967810 | 2021-01-26 | Gaston | North Carolina | 37071 | 20750 | 312 |
967811 | 967811 | 2021-01-26 | Gates | North Carolina | 37073 | 510 | 12 |
967812 | 967812 | 2021-01-26 | Graham | North Carolina | 37075 | 516 | 12 |
967813 | 967813 | 2021-01-26 | Granville | North Carolina | 37077 | 4563 | 71 |
967814 | 967814 | 2021-01-26 | Greene | North Carolina | 37079 | 1889 | 35 |
967815 | 967815 | 2021-01-26 | Guilford | North Carolina | 37081 | 33578 | 377 |
967816 | 967816 | 2021-01-26 | Halifax | North Carolina | 37083 | 4078 | 74 |
967817 | 967817 | 2021-01-26 | Harnett | North Carolina | 37085 | 7935 | 109 |
967818 | 967818 | 2021-01-26 | Haywood | North Carolina | 37087 | 3211 | 76 |
967819 | 967819 | 2021-01-26 | Henderson | North Carolina | 37089 | 7347 | 100 |
967820 | 967820 | 2021-01-26 | Hertford | North Carolina | 37091 | 1745 | 54 |
967821 | 967821 | 2021-01-26 | Hoke | North Carolina | 37093 | 3546 | 40 |
967822 | 967822 | 2021-01-26 | Hyde | North Carolina | 37095 | 574 | 6 |
967823 | 967823 | 2021-01-26 | Iredell | North Carolina | 37097 | 13508 | 141 |
967824 | 967824 | 2021-01-26 | Jackson | North Carolina | 37099 | 2927 | 22 |
967825 | 967825 | 2021-01-26 | Johnston | North Carolina | 37101 | 15289 | 158 |
967826 | 967826 | 2021-01-26 | Jones | North Carolina | 37103 | 553 | 16 |
967827 | 967827 | 2021-01-26 | Lee | North Carolina | 37105 | 4679 | 55 |
967828 | 967828 | 2021-01-26 | Lenoir | North Carolina | 37107 | 4437 | 90 |
967829 | 967829 | 2021-01-26 | Lincoln | North Carolina | 37109 | 7550 | 43 |
967830 | 967830 | 2021-01-26 | Macon | North Carolina | 37113 | 2146 | 12 |
967831 | 967831 | 2021-01-26 | Madison | North Carolina | 37115 | 1167 | 27 |
967832 | 967832 | 2021-01-26 | Martin | North Carolina | 37117 | 1815 | 27 |
967833 | 967833 | 2021-01-26 | McDowell | North Carolina | 37111 | 4198 | 49 |
967834 | 967834 | 2021-01-26 | Mecklenburg | North Carolina | 37119 | 83209 | 754 |
967835 | 967835 | 2021-01-26 | Mitchell | North Carolina | 37121 | 1040 | 10 |
967836 | 967836 | 2021-01-26 | Montgomery | North Carolina | 37123 | 2648 | 56 |
967837 | 967837 | 2021-01-26 | Moore | North Carolina | 37125 | 6770 | 106 |
967838 | 967838 | 2021-01-26 | Nash | North Carolina | 37127 | 7698 | 138 |
967839 | 967839 | 2021-01-26 | New Hanover | North Carolina | 37129 | 12992 | 110 |
967840 | 967840 | 2021-01-26 | Northampton | North Carolina | 37131 | 1449 | 27 |
967841 | 967841 | 2021-01-26 | Onslow | North Carolina | 37133 | 12245 | 103 |
967842 | 967842 | 2021-01-26 | Orange | North Carolina | 37135 | 6440 | 80 |
967843 | 967843 | 2021-01-26 | Pamlico | North Carolina | 37137 | 725 | 6 |
967844 | 967844 | 2021-01-26 | Pasquotank | North Carolina | 37139 | 2582 | 71 |
967845 | 967845 | 2021-01-26 | Pender | North Carolina | 37141 | 3995 | 39 |
967846 | 967846 | 2021-01-26 | Perquimans | North Carolina | 37143 | 731 | 5 |
967847 | 967847 | 2021-01-26 | Person | North Carolina | 37145 | 2399 | 46 |
967848 | 967848 | 2021-01-26 | Pitt | North Carolina | 37147 | 14822 | 70 |
967849 | 967849 | 2021-01-26 | Polk | North Carolina | 37149 | 1134 | 16 |
967850 | 967850 | 2021-01-26 | Randolph | North Carolina | 37151 | 10865 | 167 |
967851 | 967851 | 2021-01-26 | Richmond | North Carolina | 37153 | 3522 | 68 |
967852 | 967852 | 2021-01-26 | Robeson | North Carolina | 37155 | 12927 | 177 |
967853 | 967853 | 2021-01-26 | Rockingham | North Carolina | 37157 | 6053 | 36 |
967854 | 967854 | 2021-01-26 | Rowan | North Carolina | 37159 | 12476 | 238 |
967855 | 967855 | 2021-01-26 | Rutherford | North Carolina | 37161 | 6042 | 161 |
967856 | 967856 | 2021-01-26 | Sampson | North Carolina | 37163 | 5960 | 79 |
967857 | 967857 | 2021-01-26 | Scotland | North Carolina | 37165 | 3102 | 63 |
967858 | 967858 | 2021-01-26 | Stanly | North Carolina | 37167 | 5812 | 92 |
967859 | 967859 | 2021-01-26 | Stokes | North Carolina | 37169 | 2964 | 53 |
967860 | 967860 | 2021-01-26 | Surry | North Carolina | 37171 | 6097 | 107 |
967861 | 967861 | 2021-01-26 | Swain | North Carolina | 37173 | 1029 | 11 |
967862 | 967862 | 2021-01-26 | Transylvania | North Carolina | 37175 | 1508 | 14 |
967863 | 967863 | 2021-01-26 | Tyrrell | North Carolina | 37177 | 250 | 6 |
967864 | 967864 | 2021-01-26 | Union | North Carolina | 37179 | 17603 | 140 |
967865 | 967865 | 2021-01-26 | Vance | North Carolina | 37181 | 3545 | 73 |
967866 | 967866 | 2021-01-26 | Wake | North Carolina | 37183 | 62414 | 413 |
967867 | 967867 | 2021-01-26 | Warren | North Carolina | 37185 | 1356 | 13 |
967868 | 967868 | 2021-01-26 | Washington | North Carolina | 37187 | 723 | 21 |
967869 | 967869 | 2021-01-26 | Watauga | North Carolina | 37189 | 3249 | 24 |
967870 | 967870 | 2021-01-26 | Wayne | North Carolina | 37191 | 8902 | 177 |
967871 | 967871 | 2021-01-26 | Wilkes | North Carolina | 37193 | 5148 | 90 |
967872 | 967872 | 2021-01-26 | Wilson | North Carolina | 37195 | 7183 | 123 |
967873 | 967873 | 2021-01-26 | Yadkin | North Carolina | 37197 | 3185 | 35 |
967874 | 967874 | 2021-01-26 | Yancey | North Carolina | 37199 | 1262 | 9 |
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);