ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where cases = 66 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
452297 | 452297 | 2020-08-20 | Gates | North Carolina | 37073 | 66 | 2 |
384606 | 384606 | 2020-07-30 | Alleghany | North Carolina | 37005 | 66 | 0 |
374979 | 374979 | 2020-07-27 | Currituck | North Carolina | 37053 | 66 | 0 |
352589 | 352589 | 2020-07-20 | Tyrrell | North Carolina | 37177 | 66 | 1 |
346196 | 346196 | 2020-07-18 | Yancey | North Carolina | 37199 | 66 | 0 |
326952 | 326952 | 2020-07-12 | Cherokee | North Carolina | 37039 | 66 | 2 |
276336 | 276336 | 2020-06-26 | Beaufort | North Carolina | 37013 | 66 | 0 |
263784 | 263784 | 2020-06-22 | Alexander | North Carolina | 37003 | 66 | 0 |
257577 | 257577 | 2020-06-20 | Jackson | North Carolina | 37099 | 66 | 1 |
201722 | 201722 | 2020-06-02 | Anson | North Carolina | 37007 | 66 | 1 |
192586 | 192586 | 2020-05-30 | Stokes | North Carolina | 37169 | 66 | 0 |
183360 | 183360 | 2020-05-27 | Greene | North Carolina | 37079 | 66 | 2 |
180312 | 180312 | 2020-05-26 | Greene | North Carolina | 37079 | 66 | 2 |
174231 | 174231 | 2020-05-24 | Hertford | North Carolina | 37091 | 66 | 1 |
143968 | 143968 | 2020-05-14 | Bladen | North Carolina | 37017 | 66 | 2 |
91396 | 91396 | 2020-04-26 | Duplin | North Carolina | 37061 | 66 | 0 |
85800 | 85800 | 2020-04-24 | New Hanover | North Carolina | 37129 | 66 | 3 |
82996 | 82996 | 2020-04-23 | New Hanover | North Carolina | 37129 | 66 | 2 |
80159 | 80159 | 2020-04-22 | Columbus | North Carolina | 37047 | 66 | 4 |
80177 | 80177 | 2020-04-22 | Harnett | North Carolina | 37085 | 66 | 5 |
69037 | 69037 | 2020-04-18 | Burke | North Carolina | 37023 | 66 | 5 |
63559 | 63559 | 2020-04-16 | Franklin | North Carolina | 37069 | 66 | 5 |
60833 | 60833 | 2020-04-15 | Franklin | North Carolina | 37069 | 66 | 3 |
60858 | 60858 | 2020-04-15 | Moore | North Carolina | 37125 | 66 | 0 |
58119 | 58119 | 2020-04-14 | Franklin | North Carolina | 37069 | 66 | 2 |
58144 | 58144 | 2020-04-14 | Moore | North Carolina | 37125 | 66 | 0 |
55444 | 55444 | 2020-04-13 | Moore | North Carolina | 37125 | 66 | 0 |
52760 | 52760 | 2020-04-12 | Moore | North Carolina | 37125 | 66 | 0 |
7866 | 7866 | 2020-03-22 | Mecklenburg | North Carolina | 37119 | 66 | 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);