ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 27 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
397508 | 397508 | 2020-08-03 | Graham | North Carolina | 37075 | 27 | 0 |
394291 | 394291 | 2020-08-02 | Graham | North Carolina | 37075 | 27 | 0 |
362170 | 362170 | 2020-07-23 | Madison | North Carolina | 37115 | 27 | 0 |
342919 | 342919 | 2020-07-17 | Clay | North Carolina | 37043 | 27 | 0 |
317460 | 317460 | 2020-07-09 | Pamlico | North Carolina | 37137 | 27 | 0 |
311083 | 311083 | 2020-07-07 | Gates | North Carolina | 37073 | 27 | 2 |
307915 | 307915 | 2020-07-06 | Gates | North Carolina | 37073 | 27 | 2 |
304732 | 304732 | 2020-07-05 | Chowan | North Carolina | 37041 | 27 | 0 |
304748 | 304748 | 2020-07-05 | Gates | North Carolina | 37073 | 27 | 2 |
301569 | 301569 | 2020-07-04 | Chowan | North Carolina | 37041 | 27 | 0 |
301585 | 301585 | 2020-07-04 | Gates | North Carolina | 37073 | 27 | 2 |
298422 | 298422 | 2020-07-03 | Gates | North Carolina | 37073 | 27 | 2 |
295262 | 295262 | 2020-07-02 | Gates | North Carolina | 37073 | 27 | 2 |
292107 | 292107 | 2020-07-01 | Gates | North Carolina | 37073 | 27 | 2 |
288955 | 288955 | 2020-06-30 | Gates | North Carolina | 37073 | 27 | 2 |
282660 | 282660 | 2020-06-28 | Gates | North Carolina | 37073 | 27 | 2 |
279538 | 279538 | 2020-06-27 | Mitchell | North Carolina | 37121 | 27 | 0 |
263810 | 263810 | 2020-06-22 | Dare | North Carolina | 37055 | 27 | 1 |
260682 | 260682 | 2020-06-21 | Dare | North Carolina | 37055 | 27 | 1 |
257555 | 257555 | 2020-06-20 | Dare | North Carolina | 37055 | 27 | 1 |
254432 | 254432 | 2020-06-19 | Dare | North Carolina | 37055 | 27 | 1 |
251317 | 251317 | 2020-06-18 | Dare | North Carolina | 37055 | 27 | 1 |
248202 | 248202 | 2020-06-17 | Dare | North Carolina | 37055 | 27 | 1 |
242001 | 242001 | 2020-06-15 | Jones | North Carolina | 37103 | 27 | 3 |
242049 | 242049 | 2020-06-15 | Yancey | North Carolina | 37199 | 27 | 0 |
238892 | 238892 | 2020-06-14 | Jones | North Carolina | 37103 | 27 | 3 |
201813 | 201813 | 2020-06-02 | Watauga | North Carolina | 37189 | 27 | 0 |
192595 | 192595 | 2020-05-30 | Washington | North Carolina | 37187 | 27 | 3 |
189531 | 189531 | 2020-05-29 | Washington | North Carolina | 37187 | 27 | 3 |
186471 | 186471 | 2020-05-28 | Washington | North Carolina | 37187 | 27 | 3 |
183414 | 183414 | 2020-05-27 | Washington | North Carolina | 37187 | 27 | 3 |
180274 | 180274 | 2020-05-26 | Alexander | North Carolina | 37003 | 27 | 0 |
177231 | 177231 | 2020-05-25 | Alexander | North Carolina | 37003 | 27 | 0 |
174187 | 174187 | 2020-05-24 | Alexander | North Carolina | 37003 | 27 | 0 |
171145 | 171145 | 2020-05-23 | Alexander | North Carolina | 37003 | 27 | 0 |
152983 | 152983 | 2020-05-17 | Ashe | North Carolina | 37009 | 27 | 0 |
152984 | 152984 | 2020-05-17 | Beaufort | North Carolina | 37013 | 27 | 0 |
149974 | 149974 | 2020-05-16 | Beaufort | North Carolina | 37013 | 27 | 0 |
123084 | 123084 | 2020-05-07 | Martin | North Carolina | 37117 | 27 | 1 |
123099 | 123099 | 2020-05-07 | Person | North Carolina | 37145 | 27 | 1 |
120126 | 120126 | 2020-05-06 | Polk | North Carolina | 37149 | 27 | 0 |
120150 | 120150 | 2020-05-06 | Yadkin | North Carolina | 37197 | 27 | 1 |
117106 | 117106 | 2020-05-05 | Carteret | North Carolina | 37031 | 27 | 3 |
114226 | 114226 | 2020-05-04 | Carteret | North Carolina | 37031 | 27 | 3 |
114269 | 114269 | 2020-05-04 | McDowell | North Carolina | 37111 | 27 | 1 |
114289 | 114289 | 2020-05-04 | Rockingham | North Carolina | 37157 | 27 | 2 |
111338 | 111338 | 2020-05-03 | Bladen | North Carolina | 37017 | 27 | 0 |
111345 | 111345 | 2020-05-03 | Carteret | North Carolina | 37031 | 27 | 3 |
111388 | 111388 | 2020-05-03 | McDowell | North Carolina | 37111 | 27 | 1 |
108465 | 108465 | 2020-05-02 | Bladen | North Carolina | 37017 | 27 | 0 |
108472 | 108472 | 2020-05-02 | Carteret | North Carolina | 37031 | 27 | 3 |
105594 | 105594 | 2020-05-01 | Anson | North Carolina | 37007 | 27 | 0 |
105644 | 105644 | 2020-05-01 | Lincoln | North Carolina | 37109 | 27 | 0 |
102743 | 102743 | 2020-04-30 | Carteret | North Carolina | 37031 | 27 | 3 |
99890 | 99890 | 2020-04-29 | Carteret | North Carolina | 37031 | 27 | 3 |
99929 | 99929 | 2020-04-29 | Lincoln | North Carolina | 37109 | 27 | 0 |
91410 | 91410 | 2020-04-26 | Hertford | North Carolina | 37091 | 27 | 1 |
88595 | 88595 | 2020-04-25 | Hertford | North Carolina | 37091 | 27 | 1 |
85753 | 85753 | 2020-04-24 | Caldwell | North Carolina | 37027 | 27 | 0 |
80144 | 80144 | 2020-04-22 | Bertie | North Carolina | 37015 | 27 | 1 |
80187 | 80187 | 2020-04-22 | Lenoir | North Carolina | 37107 | 27 | 0 |
74640 | 74640 | 2020-04-20 | Robeson | North Carolina | 37155 | 27 | 0 |
55409 | 55409 | 2020-04-13 | Craven | North Carolina | 37049 | 27 | 1 |
50063 | 50063 | 2020-04-11 | Franklin | North Carolina | 37069 | 27 | 1 |
44778 | 44778 | 2020-04-09 | Catawba | North Carolina | 37035 | 27 | 1 |
44783 | 44783 | 2020-04-09 | Cleveland | North Carolina | 37045 | 27 | 0 |
44820 | 44820 | 2020-04-09 | Nash | North Carolina | 37127 | 27 | 1 |
42180 | 42180 | 2020-04-08 | Alamance | North Carolina | 37001 | 27 | 0 |
39638 | 39638 | 2020-04-07 | Catawba | North Carolina | 37035 | 27 | 1 |
32217 | 32217 | 2020-04-04 | Buncombe | North Carolina | 37021 | 27 | 1 |
25294 | 25294 | 2020-04-01 | Pitt | North Carolina | 37147 | 27 | 0 |
23100 | 23100 | 2020-03-31 | Pitt | North Carolina | 37147 | 27 | 0 |
16997 | 16997 | 2020-03-28 | Orange | North Carolina | 37135 | 27 | 0 |
15177 | 15177 | 2020-03-27 | Union | North Carolina | 37179 | 27 | 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);