ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2021-03-11" 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 |
---|---|---|---|---|---|---|---|
1110588 | 1110588 | 2021-03-11 | Alamance | North Carolina | 37001 | 16086 | 231 |
1110589 | 1110589 | 2021-03-11 | Alexander | North Carolina | 37003 | 3999 | 77 |
1110590 | 1110590 | 2021-03-11 | Alleghany | North Carolina | 37005 | 933 | 5 |
1110591 | 1110591 | 2021-03-11 | Anson | North Carolina | 37007 | 2361 | 53 |
1110592 | 1110592 | 2021-03-11 | Ashe | North Carolina | 37009 | 1900 | 40 |
1110593 | 1110593 | 2021-03-11 | Avery | North Carolina | 37011 | 1884 | 20 |
1110594 | 1110594 | 2021-03-11 | Beaufort | North Carolina | 37013 | 4323 | 84 |
1110595 | 1110595 | 2021-03-11 | Bertie | North Carolina | 37015 | 1678 | 41 |
1110596 | 1110596 | 2021-03-11 | Bladen | North Carolina | 37017 | 3008 | 41 |
1110597 | 1110597 | 2021-03-11 | Brunswick | North Carolina | 37019 | 8218 | 138 |
1110598 | 1110598 | 2021-03-11 | Buncombe | North Carolina | 37021 | 15883 | 302 |
1110599 | 1110599 | 2021-03-11 | Burke | North Carolina | 37023 | 9354 | 145 |
1110600 | 1110600 | 2021-03-11 | Cabarrus | North Carolina | 37025 | 18899 | 238 |
1110601 | 1110601 | 2021-03-11 | Caldwell | North Carolina | 37027 | 8752 | 93 |
1110602 | 1110602 | 2021-03-11 | Camden | North Carolina | 37029 | 604 | 5 |
1110603 | 1110603 | 2021-03-11 | Carteret | North Carolina | 37031 | 4529 | 44 |
1110604 | 1110604 | 2021-03-11 | Caswell | North Carolina | 37033 | 2009 | 24 |
1110605 | 1110605 | 2021-03-11 | Catawba | North Carolina | 37035 | 17732 | 286 |
1110606 | 1110606 | 2021-03-11 | Chatham | North Carolina | 37037 | 4223 | 79 |
1110607 | 1110607 | 2021-03-11 | Cherokee | North Carolina | 37039 | 2146 | 19 |
1110608 | 1110608 | 2021-03-11 | Chowan | North Carolina | 37041 | 1387 | 22 |
1110609 | 1110609 | 2021-03-11 | Clay | North Carolina | 37043 | 664 | 18 |
1110610 | 1110610 | 2021-03-11 | Cleveland | North Carolina | 37045 | 10510 | 218 |
1110611 | 1110611 | 2021-03-11 | Columbus | North Carolina | 37047 | 5975 | 147 |
1110612 | 1110612 | 2021-03-11 | Craven | North Carolina | 37049 | 8513 | 116 |
1110613 | 1110613 | 2021-03-11 | Cumberland | North Carolina | 37051 | 24759 | 282 |
1110614 | 1110614 | 2021-03-11 | Currituck | North Carolina | 37053 | 1409 | 15 |
1110615 | 1110615 | 2021-03-11 | Dare | North Carolina | 37055 | 1882 | 8 |
1110616 | 1110616 | 2021-03-11 | Davidson | North Carolina | 37057 | 14846 | 172 |
1110617 | 1110617 | 2021-03-11 | Davie | North Carolina | 37059 | 3618 | 35 |
1110618 | 1110618 | 2021-03-11 | Duplin | North Carolina | 37061 | 5801 | 128 |
1110619 | 1110619 | 2021-03-11 | Durham | North Carolina | 37063 | 22637 | 213 |
1110620 | 1110620 | 2021-03-11 | Edgecombe | North Carolina | 37065 | 4780 | 100 |
1110621 | 1110621 | 2021-03-11 | Forsyth | North Carolina | 37067 | 32425 | 352 |
1110622 | 1110622 | 2021-03-11 | Franklin | North Carolina | 37069 | 5616 | 45 |
1110623 | 1110623 | 2021-03-11 | Gaston | North Carolina | 37071 | 24131 | 381 |
1110624 | 1110624 | 2021-03-11 | Gates | North Carolina | 37073 | 686 | 12 |
1110625 | 1110625 | 2021-03-11 | Graham | North Carolina | 37075 | 568 | 12 |
1110626 | 1110626 | 2021-03-11 | Granville | North Carolina | 37077 | 5381 | 76 |
1110627 | 1110627 | 2021-03-11 | Greene | North Carolina | 37079 | 2153 | 42 |
1110628 | 1110628 | 2021-03-11 | Guilford | North Carolina | 37081 | 40845 | 563 |
1110629 | 1110629 | 2021-03-11 | Halifax | North Carolina | 37083 | 5054 | 102 |
1110630 | 1110630 | 2021-03-11 | Harnett | North Carolina | 37085 | 9964 | 157 |
1110631 | 1110631 | 2021-03-11 | Haywood | North Carolina | 37087 | 3921 | 88 |
1110632 | 1110632 | 2021-03-11 | Henderson | North Carolina | 37089 | 9105 | 151 |
1110633 | 1110633 | 2021-03-11 | Hertford | North Carolina | 37091 | 1970 | 62 |
1110634 | 1110634 | 2021-03-11 | Hoke | North Carolina | 37093 | 4210 | 54 |
1110635 | 1110635 | 2021-03-11 | Hyde | North Carolina | 37095 | 629 | 8 |
1110636 | 1110636 | 2021-03-11 | Iredell | North Carolina | 37097 | 16771 | 197 |
1110637 | 1110637 | 2021-03-11 | Jackson | North Carolina | 37099 | 3397 | 55 |
1110638 | 1110638 | 2021-03-11 | Johnston | North Carolina | 37101 | 18471 | 204 |
1110639 | 1110639 | 2021-03-11 | Jones | North Carolina | 37103 | 749 | 16 |
1110640 | 1110640 | 2021-03-11 | Lee | North Carolina | 37105 | 5530 | 73 |
1110641 | 1110641 | 2021-03-11 | Lenoir | North Carolina | 37107 | 5536 | 108 |
1110642 | 1110642 | 2021-03-11 | Lincoln | North Carolina | 37109 | 8973 | 75 |
1110643 | 1110643 | 2021-03-11 | Macon | North Carolina | 37113 | 2603 | 31 |
1110644 | 1110644 | 2021-03-11 | Madison | North Carolina | 37115 | 1397 | 40 |
1110645 | 1110645 | 2021-03-11 | Martin | North Carolina | 37117 | 2098 | 37 |
1110646 | 1110646 | 2021-03-11 | McDowell | North Carolina | 37111 | 4925 | 62 |
1110647 | 1110647 | 2021-03-11 | Mecklenburg | North Carolina | 37119 | 98652 | 895 |
1110648 | 1110648 | 2021-03-11 | Mitchell | North Carolina | 37121 | 1269 | 16 |
1110649 | 1110649 | 2021-03-11 | Montgomery | North Carolina | 37123 | 3122 | 89 |
1110650 | 1110650 | 2021-03-11 | Moore | North Carolina | 37125 | 8142 | 182 |
1110651 | 1110651 | 2021-03-11 | Nash | North Carolina | 37127 | 9972 | 172 |
1110652 | 1110652 | 2021-03-11 | New Hanover | North Carolina | 37129 | 16652 | 154 |
1110653 | 1110653 | 2021-03-11 | Northampton | North Carolina | 37131 | 1745 | 34 |
1110654 | 1110654 | 2021-03-11 | Onslow | North Carolina | 37133 | 14975 | 137 |
1110655 | 1110655 | 2021-03-11 | Orange | North Carolina | 37135 | 7847 | 97 |
1110656 | 1110656 | 2021-03-11 | Pamlico | North Carolina | 37137 | 983 | 10 |
1110657 | 1110657 | 2021-03-11 | Pasquotank | North Carolina | 37139 | 3116 | 78 |
1110658 | 1110658 | 2021-03-11 | Pender | North Carolina | 37141 | 4833 | 60 |
1110659 | 1110659 | 2021-03-11 | Perquimans | North Carolina | 37143 | 933 | 9 |
1110660 | 1110660 | 2021-03-11 | Person | North Carolina | 37145 | 3083 | 64 |
1110661 | 1110661 | 2021-03-11 | Pitt | North Carolina | 37147 | 17796 | 84 |
1110662 | 1110662 | 2021-03-11 | Polk | North Carolina | 37149 | 1366 | 27 |
1110663 | 1110663 | 2021-03-11 | Randolph | North Carolina | 37151 | 13658 | 206 |
1110664 | 1110664 | 2021-03-11 | Richmond | North Carolina | 37153 | 4273 | 92 |
1110665 | 1110665 | 2021-03-11 | Robeson | North Carolina | 37155 | 15432 | 215 |
1110666 | 1110666 | 2021-03-11 | Rockingham | North Carolina | 37157 | 6928 | 61 |
1110667 | 1110667 | 2021-03-11 | Rowan | North Carolina | 37159 | 15159 | 291 |
1110668 | 1110668 | 2021-03-11 | Rutherford | North Carolina | 37161 | 6817 | 201 |
1110669 | 1110669 | 2021-03-11 | Sampson | North Carolina | 37163 | 7025 | 94 |
1110670 | 1110670 | 2021-03-11 | Scotland | North Carolina | 37165 | 3522 | 79 |
1110671 | 1110671 | 2021-03-11 | Stanly | North Carolina | 37167 | 6992 | 111 |
1110672 | 1110672 | 2021-03-11 | Stokes | North Carolina | 37169 | 3706 | 74 |
1110673 | 1110673 | 2021-03-11 | Surry | North Carolina | 37171 | 7477 | 140 |
1110674 | 1110674 | 2021-03-11 | Swain | North Carolina | 37173 | 1174 | 16 |
1110675 | 1110675 | 2021-03-11 | Transylvania | North Carolina | 37175 | 1963 | 28 |
1110676 | 1110676 | 2021-03-11 | Tyrrell | North Carolina | 37177 | 305 | 6 |
1110677 | 1110677 | 2021-03-11 | Union | North Carolina | 37179 | 21246 | 204 |
1110678 | 1110678 | 2021-03-11 | Vance | North Carolina | 37181 | 4466 | 82 |
1110679 | 1110679 | 2021-03-11 | Wake | North Carolina | 37183 | 77038 | 566 |
1110680 | 1110680 | 2021-03-11 | Warren | North Carolina | 37185 | 1640 | 18 |
1110681 | 1110681 | 2021-03-11 | Washington | North Carolina | 37187 | 1003 | 31 |
1110682 | 1110682 | 2021-03-11 | Watauga | North Carolina | 37189 | 4080 | 30 |
1110683 | 1110683 | 2021-03-11 | Wayne | North Carolina | 37191 | 10379 | 226 |
1110684 | 1110684 | 2021-03-11 | Wilkes | North Carolina | 37193 | 6115 | 104 |
1110685 | 1110685 | 2021-03-11 | Wilson | North Carolina | 37195 | 8641 | 152 |
1110686 | 1110686 | 2021-03-11 | Yadkin | North Carolina | 37197 | 3703 | 46 |
1110687 | 1110687 | 2021-03-11 | Yancey | North Carolina | 37199 | 1472 | 26 |
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);