ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where "date" is on date 2020-04-02 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
- Beaufort 1
- Bertie 1
- Brunswick 1
- Buncombe 1
- Burke 1
- Cabarrus 1
- Caldwell 1
- Carteret 1
- Caswell 1
- Catawba 1
- Chatham 1
- Cherokee 1
- Clay 1
- Cleveland 1
- Columbus 1
- Craven 1
- Cumberland 1
- Currituck 1
- Dare 1
- Davidson 1
- Davie 1
- Duplin 1
- Durham 1
- Edgecombe 1
- Forsyth 1
- Franklin 1
- …
state 1
- North Carolina · 83 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
27498 | 27498 | 2020-04-02 | Alamance | North Carolina | 37001 | 13 | 0 |
27499 | 27499 | 2020-04-02 | Alexander | North Carolina | 37003 | 2 | 0 |
27500 | 27500 | 2020-04-02 | Alleghany | North Carolina | 37005 | 2 | 0 |
27501 | 27501 | 2020-04-02 | Anson | North Carolina | 37007 | 1 | 0 |
27502 | 27502 | 2020-04-02 | Beaufort | North Carolina | 37013 | 7 | 0 |
27503 | 27503 | 2020-04-02 | Bertie | North Carolina | 37015 | 6 | 1 |
27504 | 27504 | 2020-04-02 | Brunswick | North Carolina | 37019 | 19 | 0 |
27505 | 27505 | 2020-04-02 | Buncombe | North Carolina | 37021 | 22 | 1 |
27506 | 27506 | 2020-04-02 | Burke | North Carolina | 37023 | 9 | 0 |
27507 | 27507 | 2020-04-02 | Cabarrus | North Carolina | 37025 | 50 | 1 |
27508 | 27508 | 2020-04-02 | Caldwell | North Carolina | 37027 | 3 | 0 |
27509 | 27509 | 2020-04-02 | Carteret | North Carolina | 37031 | 13 | 0 |
27510 | 27510 | 2020-04-02 | Caswell | North Carolina | 37033 | 1 | 0 |
27511 | 27511 | 2020-04-02 | Catawba | North Carolina | 37035 | 16 | 0 |
27512 | 27512 | 2020-04-02 | Chatham | North Carolina | 37037 | 19 | 0 |
27513 | 27513 | 2020-04-02 | Cherokee | North Carolina | 37039 | 8 | 1 |
27514 | 27514 | 2020-04-02 | Clay | North Carolina | 37043 | 2 | 0 |
27515 | 27515 | 2020-04-02 | Cleveland | North Carolina | 37045 | 7 | 0 |
27516 | 27516 | 2020-04-02 | Columbus | North Carolina | 37047 | 2 | 0 |
27517 | 27517 | 2020-04-02 | Craven | North Carolina | 37049 | 7 | 0 |
27518 | 27518 | 2020-04-02 | Cumberland | North Carolina | 37051 | 25 | 0 |
27519 | 27519 | 2020-04-02 | Currituck | North Carolina | 37053 | 2 | 0 |
27520 | 27520 | 2020-04-02 | Dare | North Carolina | 37055 | 1 | 0 |
27521 | 27521 | 2020-04-02 | Davidson | North Carolina | 37057 | 35 | 0 |
27522 | 27522 | 2020-04-02 | Davie | North Carolina | 37059 | 11 | 1 |
27523 | 27523 | 2020-04-02 | Duplin | North Carolina | 37061 | 2 | 0 |
27524 | 27524 | 2020-04-02 | Durham | North Carolina | 37063 | 147 | 0 |
27525 | 27525 | 2020-04-02 | Edgecombe | North Carolina | 37065 | 4 | 0 |
27526 | 27526 | 2020-04-02 | Forsyth | North Carolina | 37067 | 56 | 1 |
27527 | 27527 | 2020-04-02 | Franklin | North Carolina | 37069 | 12 | 0 |
27528 | 27528 | 2020-04-02 | Gaston | North Carolina | 37071 | 33 | 1 |
27529 | 27529 | 2020-04-02 | Gates | North Carolina | 37073 | 1 | 0 |
27530 | 27530 | 2020-04-02 | Granville | North Carolina | 37077 | 20 | 0 |
27531 | 27531 | 2020-04-02 | Greene | North Carolina | 37079 | 4 | 0 |
27532 | 27532 | 2020-04-02 | Guilford | North Carolina | 37081 | 71 | 1 |
27533 | 27533 | 2020-04-02 | Halifax | North Carolina | 37083 | 6 | 0 |
27534 | 27534 | 2020-04-02 | Harnett | North Carolina | 37085 | 19 | 1 |
27535 | 27535 | 2020-04-02 | Henderson | North Carolina | 37089 | 22 | 0 |
27536 | 27536 | 2020-04-02 | Hertford | North Carolina | 37091 | 4 | 0 |
27537 | 27537 | 2020-04-02 | Hoke | North Carolina | 37093 | 7 | 0 |
27538 | 27538 | 2020-04-02 | Iredell | North Carolina | 37097 | 31 | 0 |
27539 | 27539 | 2020-04-02 | Johnston | North Carolina | 37101 | 20 | 1 |
27540 | 27540 | 2020-04-02 | Lee | North Carolina | 37105 | 3 | 0 |
27541 | 27541 | 2020-04-02 | Lenoir | North Carolina | 37107 | 3 | 0 |
27542 | 27542 | 2020-04-02 | Lincoln | North Carolina | 37109 | 8 | 0 |
27543 | 27543 | 2020-04-02 | Macon | North Carolina | 37113 | 1 | 0 |
27544 | 27544 | 2020-04-02 | Martin | North Carolina | 37117 | 3 | 0 |
27545 | 27545 | 2020-04-02 | McDowell | North Carolina | 37111 | 8 | 0 |
27546 | 27546 | 2020-04-02 | Mecklenburg | North Carolina | 37119 | 495 | 2 |
27547 | 27547 | 2020-04-02 | Mitchell | North Carolina | 37121 | 1 | 0 |
27548 | 27548 | 2020-04-02 | Montgomery | North Carolina | 37123 | 8 | 1 |
27549 | 27549 | 2020-04-02 | Moore | North Carolina | 37125 | 8 | 0 |
27550 | 27550 | 2020-04-02 | Nash | North Carolina | 37127 | 10 | 0 |
27551 | 27551 | 2020-04-02 | New Hanover | North Carolina | 37129 | 33 | 0 |
27552 | 27552 | 2020-04-02 | Northampton | North Carolina | 37131 | 30 | 0 |
27553 | 27553 | 2020-04-02 | Onslow | North Carolina | 37133 | 8 | 1 |
27554 | 27554 | 2020-04-02 | Orange | North Carolina | 37135 | 37 | 0 |
27555 | 27555 | 2020-04-02 | Pamlico | North Carolina | 37137 | 1 | 0 |
27556 | 27556 | 2020-04-02 | Pasquotank | North Carolina | 37139 | 7 | 0 |
27557 | 27557 | 2020-04-02 | Perquimans | North Carolina | 37143 | 1 | 0 |
27558 | 27558 | 2020-04-02 | Person | North Carolina | 37145 | 2 | 0 |
27559 | 27559 | 2020-04-02 | Pitt | North Carolina | 37147 | 29 | 0 |
27560 | 27560 | 2020-04-02 | Polk | North Carolina | 37149 | 4 | 0 |
27561 | 27561 | 2020-04-02 | Randolph | North Carolina | 37151 | 19 | 0 |
27562 | 27562 | 2020-04-02 | Robeson | North Carolina | 37155 | 3 | 0 |
27563 | 27563 | 2020-04-02 | Rockingham | North Carolina | 37157 | 2 | 1 |
27564 | 27564 | 2020-04-02 | Rowan | North Carolina | 37159 | 31 | 1 |
27565 | 27565 | 2020-04-02 | Rutherford | North Carolina | 37161 | 9 | 0 |
27566 | 27566 | 2020-04-02 | Sampson | North Carolina | 37163 | 1 | 0 |
27567 | 27567 | 2020-04-02 | Scotland | North Carolina | 37165 | 2 | 0 |
27568 | 27568 | 2020-04-02 | Stanly | North Carolina | 37167 | 5 | 0 |
27569 | 27569 | 2020-04-02 | Stokes | North Carolina | 37169 | 2 | 0 |
27570 | 27570 | 2020-04-02 | Surry | North Carolina | 37171 | 2 | 0 |
27571 | 27571 | 2020-04-02 | Transylvania | North Carolina | 37175 | 5 | 0 |
27572 | 27572 | 2020-04-02 | Union | North Carolina | 37179 | 55 | 0 |
27573 | 27573 | 2020-04-02 | Vance | North Carolina | 37181 | 6 | 0 |
27574 | 27574 | 2020-04-02 | Wake | North Carolina | 37183 | 234 | 0 |
27575 | 27575 | 2020-04-02 | Washington | North Carolina | 37187 | 2 | 0 |
27576 | 27576 | 2020-04-02 | Watauga | North Carolina | 37189 | 7 | 0 |
27577 | 27577 | 2020-04-02 | Wayne | North Carolina | 37191 | 6 | 0 |
27578 | 27578 | 2020-04-02 | Wilkes | North Carolina | 37193 | 4 | 1 |
27579 | 27579 | 2020-04-02 | Wilson | North Carolina | 37195 | 17 | 0 |
27580 | 27580 | 2020-04-02 | Yadkin | North Carolina | 37197 | 4 | 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);