ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-07-25" 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 |
---|---|---|---|---|---|---|---|
368529 | 368529 | 2020-07-25 | Alamance | North Carolina | 37001 | 1920 | 40 |
368530 | 368530 | 2020-07-25 | Alexander | North Carolina | 37003 | 250 | 2 |
368531 | 368531 | 2020-07-25 | Alleghany | North Carolina | 37005 | 61 | 0 |
368532 | 368532 | 2020-07-25 | Anson | North Carolina | 37007 | 279 | 2 |
368533 | 368533 | 2020-07-25 | Ashe | North Carolina | 37009 | 83 | 1 |
368534 | 368534 | 2020-07-25 | Avery | North Carolina | 37011 | 60 | 0 |
368535 | 368535 | 2020-07-25 | Beaufort | North Carolina | 37013 | 258 | 1 |
368536 | 368536 | 2020-07-25 | Bertie | North Carolina | 37015 | 204 | 4 |
368537 | 368537 | 2020-07-25 | Bladen | North Carolina | 37017 | 523 | 5 |
368538 | 368538 | 2020-07-25 | Brunswick | North Carolina | 37019 | 1059 | 15 |
368539 | 368539 | 2020-07-25 | Buncombe | North Carolina | 37021 | 1400 | 51 |
368540 | 368540 | 2020-07-25 | Burke | North Carolina | 37023 | 1415 | 24 |
368541 | 368541 | 2020-07-25 | Cabarrus | North Carolina | 37025 | 2129 | 38 |
368542 | 368542 | 2020-07-25 | Caldwell | North Carolina | 37027 | 936 | 7 |
368543 | 368543 | 2020-07-25 | Camden | North Carolina | 37029 | 52 | 2 |
368544 | 368544 | 2020-07-25 | Carteret | North Carolina | 37031 | 238 | 4 |
368545 | 368545 | 2020-07-25 | Caswell | North Carolina | 37033 | 172 | 2 |
368546 | 368546 | 2020-07-25 | Catawba | North Carolina | 37035 | 1694 | 15 |
368547 | 368547 | 2020-07-25 | Chatham | North Carolina | 37037 | 1162 | 49 |
368548 | 368548 | 2020-07-25 | Cherokee | North Carolina | 37039 | 183 | 3 |
368549 | 368549 | 2020-07-25 | Chowan | North Carolina | 37041 | 92 | 0 |
368550 | 368550 | 2020-07-25 | Clay | North Carolina | 37043 | 50 | 0 |
368551 | 368551 | 2020-07-25 | Cleveland | North Carolina | 37045 | 809 | 13 |
368552 | 368552 | 2020-07-25 | Columbus | North Carolina | 37047 | 741 | 42 |
368553 | 368553 | 2020-07-25 | Craven | North Carolina | 37049 | 569 | 8 |
368554 | 368554 | 2020-07-25 | Cumberland | North Carolina | 37051 | 2276 | 49 |
368555 | 368555 | 2020-07-25 | Currituck | North Carolina | 37053 | 62 | 0 |
368556 | 368556 | 2020-07-25 | Dare | North Carolina | 37055 | 176 | 1 |
368557 | 368557 | 2020-07-25 | Davidson | North Carolina | 37057 | 1510 | 16 |
368558 | 368558 | 2020-07-25 | Davie | North Carolina | 37059 | 294 | 3 |
368559 | 368559 | 2020-07-25 | Duplin | North Carolina | 37061 | 1846 | 40 |
368560 | 368560 | 2020-07-25 | Durham | North Carolina | 37063 | 5469 | 76 |
368561 | 368561 | 2020-07-25 | Edgecombe | North Carolina | 37065 | 503 | 10 |
368562 | 368562 | 2020-07-25 | Forsyth | North Carolina | 37067 | 4515 | 41 |
368563 | 368563 | 2020-07-25 | Franklin | North Carolina | 37069 | 682 | 25 |
368564 | 368564 | 2020-07-25 | Gaston | North Carolina | 37071 | 2635 | 24 |
368565 | 368565 | 2020-07-25 | Gates | North Carolina | 37073 | 36 | 2 |
368566 | 368566 | 2020-07-25 | Graham | North Carolina | 37075 | 15 | 0 |
368567 | 368567 | 2020-07-25 | Granville | North Carolina | 37077 | 1087 | 25 |
368568 | 368568 | 2020-07-25 | Greene | North Carolina | 37079 | 270 | 3 |
368569 | 368569 | 2020-07-25 | Guilford | North Carolina | 37081 | 4651 | 139 |
368570 | 368570 | 2020-07-25 | Halifax | North Carolina | 37083 | 545 | 5 |
368571 | 368571 | 2020-07-25 | Harnett | North Carolina | 37085 | 987 | 35 |
368572 | 368572 | 2020-07-25 | Haywood | North Carolina | 37087 | 219 | 0 |
368573 | 368573 | 2020-07-25 | Henderson | North Carolina | 37089 | 1265 | 53 |
368574 | 368574 | 2020-07-25 | Hertford | North Carolina | 37091 | 228 | 11 |
368575 | 368575 | 2020-07-25 | Hoke | North Carolina | 37093 | 608 | 7 |
368576 | 368576 | 2020-07-25 | Hyde | North Carolina | 37095 | 35 | 0 |
368577 | 368577 | 2020-07-25 | Iredell | North Carolina | 37097 | 1482 | 16 |
368578 | 368578 | 2020-07-25 | Jackson | North Carolina | 37099 | 348 | 3 |
368579 | 368579 | 2020-07-25 | Johnston | North Carolina | 37101 | 2595 | 43 |
368580 | 368580 | 2020-07-25 | Jones | North Carolina | 37103 | 45 | 3 |
368581 | 368581 | 2020-07-25 | Lee | North Carolina | 37105 | 1055 | 9 |
368582 | 368582 | 2020-07-25 | Lenoir | North Carolina | 37107 | 479 | 11 |
368583 | 368583 | 2020-07-25 | Lincoln | North Carolina | 37109 | 633 | 2 |
368584 | 368584 | 2020-07-25 | Macon | North Carolina | 37113 | 421 | 1 |
368585 | 368585 | 2020-07-25 | Madison | North Carolina | 37115 | 28 | 0 |
368586 | 368586 | 2020-07-25 | Martin | North Carolina | 37117 | 201 | 6 |
368587 | 368587 | 2020-07-25 | McDowell | North Carolina | 37111 | 454 | 5 |
368588 | 368588 | 2020-07-25 | Mecklenburg | North Carolina | 37119 | 19041 | 188 |
368589 | 368589 | 2020-07-25 | Mitchell | North Carolina | 37121 | 68 | 2 |
368590 | 368590 | 2020-07-25 | Montgomery | North Carolina | 37123 | 499 | 13 |
368591 | 368591 | 2020-07-25 | Moore | North Carolina | 37125 | 795 | 20 |
368592 | 368592 | 2020-07-25 | Nash | North Carolina | 37127 | 830 | 10 |
368593 | 368593 | 2020-07-25 | New Hanover | North Carolina | 37129 | 2052 | 15 |
368594 | 368594 | 2020-07-25 | Northampton | North Carolina | 37131 | 252 | 16 |
368595 | 368595 | 2020-07-25 | Onslow | North Carolina | 37133 | 707 | 9 |
368596 | 368596 | 2020-07-25 | Orange | North Carolina | 37135 | 1191 | 45 |
368597 | 368597 | 2020-07-25 | Pamlico | North Carolina | 37137 | 50 | 1 |
368598 | 368598 | 2020-07-25 | Pasquotank | North Carolina | 37139 | 295 | 17 |
368599 | 368599 | 2020-07-25 | Pender | North Carolina | 37141 | 552 | 3 |
368600 | 368600 | 2020-07-25 | Perquimans | North Carolina | 37143 | 54 | 2 |
368601 | 368601 | 2020-07-25 | Person | North Carolina | 37145 | 169 | 1 |
368602 | 368602 | 2020-07-25 | Pitt | North Carolina | 37147 | 1421 | 10 |
368603 | 368603 | 2020-07-25 | Polk | North Carolina | 37149 | 124 | 5 |
368604 | 368604 | 2020-07-25 | Randolph | North Carolina | 37151 | 1904 | 35 |
368605 | 368605 | 2020-07-25 | Richmond | North Carolina | 37153 | 432 | 8 |
368606 | 368606 | 2020-07-25 | Robeson | North Carolina | 37155 | 2175 | 49 |
368607 | 368607 | 2020-07-25 | Rockingham | North Carolina | 37157 | 401 | 3 |
368608 | 368608 | 2020-07-25 | Rowan | North Carolina | 37159 | 1853 | 48 |
368609 | 368609 | 2020-07-25 | Rutherford | North Carolina | 37161 | 560 | 13 |
368610 | 368610 | 2020-07-25 | Sampson | North Carolina | 37163 | 1374 | 10 |
368611 | 368611 | 2020-07-25 | Scotland | North Carolina | 37165 | 225 | 2 |
368612 | 368612 | 2020-07-25 | Stanly | North Carolina | 37167 | 764 | 6 |
368613 | 368613 | 2020-07-25 | Stokes | North Carolina | 37169 | 215 | 2 |
368614 | 368614 | 2020-07-25 | Surry | North Carolina | 37171 | 748 | 4 |
368615 | 368615 | 2020-07-25 | Swain | North Carolina | 37173 | 90 | 2 |
368616 | 368616 | 2020-07-25 | Transylvania | North Carolina | 37175 | 106 | 1 |
368617 | 368617 | 2020-07-25 | Tyrrell | North Carolina | 37177 | 83 | 1 |
368618 | 368618 | 2020-07-25 | Union | North Carolina | 37179 | 2470 | 35 |
368619 | 368619 | 2020-07-25 | Vance | North Carolina | 37181 | 681 | 40 |
368620 | 368620 | 2020-07-25 | Wake | North Carolina | 37183 | 9914 | 105 |
368621 | 368621 | 2020-07-25 | Warren | North Carolina | 37185 | 225 | 6 |
368622 | 368622 | 2020-07-25 | Washington | North Carolina | 37187 | 97 | 3 |
368623 | 368623 | 2020-07-25 | Watauga | North Carolina | 37189 | 203 | 0 |
368624 | 368624 | 2020-07-25 | Wayne | North Carolina | 37191 | 2195 | 36 |
368625 | 368625 | 2020-07-25 | Wilkes | North Carolina | 37193 | 694 | 9 |
368626 | 368626 | 2020-07-25 | Wilson | North Carolina | 37195 | 1272 | 28 |
368627 | 368627 | 2020-07-25 | Yadkin | North Carolina | 37197 | 439 | 6 |
368628 | 368628 | 2020-07-25 | Yancey | North Carolina | 37199 | 68 | 0 |
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);