ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where county = "Graham" and state = "North Carolina" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
97065 | 97065 | 2020-04-28 | Graham | North Carolina | 37075 | 1 | 0 |
99912 | 99912 | 2020-04-29 | Graham | North Carolina | 37075 | 1 | 0 |
102765 | 102765 | 2020-04-30 | Graham | North Carolina | 37075 | 2 | 0 |
105627 | 105627 | 2020-05-01 | Graham | North Carolina | 37075 | 1 | 0 |
108494 | 108494 | 2020-05-02 | Graham | North Carolina | 37075 | 1 | 0 |
111367 | 111367 | 2020-05-03 | Graham | North Carolina | 37075 | 1 | 0 |
114248 | 114248 | 2020-05-04 | Graham | North Carolina | 37075 | 1 | 0 |
117128 | 117128 | 2020-05-05 | Graham | North Carolina | 37075 | 2 | 0 |
120089 | 120089 | 2020-05-06 | Graham | North Carolina | 37075 | 2 | 0 |
123064 | 123064 | 2020-05-07 | Graham | North Carolina | 37075 | 2 | 0 |
126047 | 126047 | 2020-05-08 | Graham | North Carolina | 37075 | 2 | 0 |
129036 | 129036 | 2020-05-09 | Graham | North Carolina | 37075 | 2 | 0 |
132025 | 132025 | 2020-05-10 | Graham | North Carolina | 37075 | 2 | 0 |
135016 | 135016 | 2020-05-11 | Graham | North Carolina | 37075 | 2 | 0 |
138006 | 138006 | 2020-05-12 | Graham | North Carolina | 37075 | 2 | 0 |
141002 | 141002 | 2020-05-13 | Graham | North Carolina | 37075 | 2 | 0 |
143997 | 143997 | 2020-05-14 | Graham | North Carolina | 37075 | 2 | 0 |
146998 | 146998 | 2020-05-15 | Graham | North Carolina | 37075 | 2 | 0 |
150005 | 150005 | 2020-05-16 | Graham | North Carolina | 37075 | 2 | 0 |
153015 | 153015 | 2020-05-17 | Graham | North Carolina | 37075 | 2 | 0 |
156032 | 156032 | 2020-05-18 | Graham | North Carolina | 37075 | 2 | 0 |
159051 | 159051 | 2020-05-19 | Graham | North Carolina | 37075 | 2 | 0 |
162078 | 162078 | 2020-05-20 | Graham | North Carolina | 37075 | 2 | 0 |
165107 | 165107 | 2020-05-21 | Graham | North Carolina | 37075 | 2 | 0 |
168142 | 168142 | 2020-05-22 | Graham | North Carolina | 37075 | 2 | 0 |
171181 | 171181 | 2020-05-23 | Graham | North Carolina | 37075 | 2 | 0 |
174223 | 174223 | 2020-05-24 | Graham | North Carolina | 37075 | 2 | 0 |
177267 | 177267 | 2020-05-25 | Graham | North Carolina | 37075 | 2 | 0 |
180310 | 180310 | 2020-05-26 | Graham | North Carolina | 37075 | 2 | 0 |
183358 | 183358 | 2020-05-27 | Graham | North Carolina | 37075 | 2 | 0 |
186415 | 186415 | 2020-05-28 | Graham | North Carolina | 37075 | 2 | 0 |
189475 | 189475 | 2020-05-29 | Graham | North Carolina | 37075 | 2 | 0 |
192539 | 192539 | 2020-05-30 | Graham | North Carolina | 37075 | 2 | 0 |
195609 | 195609 | 2020-05-31 | Graham | North Carolina | 37075 | 2 | 0 |
198682 | 198682 | 2020-06-01 | Graham | North Carolina | 37075 | 2 | 0 |
201756 | 201756 | 2020-06-02 | Graham | North Carolina | 37075 | 2 | 0 |
204833 | 204833 | 2020-06-03 | Graham | North Carolina | 37075 | 2 | 0 |
207914 | 207914 | 2020-06-04 | Graham | North Carolina | 37075 | 2 | 0 |
210996 | 210996 | 2020-06-05 | Graham | North Carolina | 37075 | 4 | 0 |
214080 | 214080 | 2020-06-06 | Graham | North Carolina | 37075 | 4 | 0 |
217170 | 217170 | 2020-06-07 | Graham | North Carolina | 37075 | 4 | 0 |
220262 | 220262 | 2020-06-08 | Graham | North Carolina | 37075 | 4 | 0 |
223356 | 223356 | 2020-06-09 | Graham | North Carolina | 37075 | 5 | 0 |
226456 | 226456 | 2020-06-10 | Graham | North Carolina | 37075 | 6 | 0 |
229560 | 229560 | 2020-06-11 | Graham | North Carolina | 37075 | 6 | 0 |
232665 | 232665 | 2020-06-12 | Graham | North Carolina | 37075 | 6 | 0 |
235770 | 235770 | 2020-06-13 | Graham | North Carolina | 37075 | 6 | 0 |
238878 | 238878 | 2020-06-14 | Graham | North Carolina | 37075 | 6 | 0 |
241987 | 241987 | 2020-06-15 | Graham | North Carolina | 37075 | 6 | 0 |
245099 | 245099 | 2020-06-16 | Graham | North Carolina | 37075 | 6 | 0 |
248212 | 248212 | 2020-06-17 | Graham | North Carolina | 37075 | 6 | 0 |
251327 | 251327 | 2020-06-18 | Graham | North Carolina | 37075 | 6 | 0 |
254442 | 254442 | 2020-06-19 | Graham | North Carolina | 37075 | 6 | 0 |
257565 | 257565 | 2020-06-20 | Graham | North Carolina | 37075 | 6 | 0 |
260692 | 260692 | 2020-06-21 | Graham | North Carolina | 37075 | 6 | 0 |
263820 | 263820 | 2020-06-22 | Graham | North Carolina | 37075 | 6 | 0 |
266948 | 266948 | 2020-06-23 | Graham | North Carolina | 37075 | 6 | 0 |
270082 | 270082 | 2020-06-24 | Graham | North Carolina | 37075 | 8 | 0 |
273221 | 273221 | 2020-06-25 | Graham | North Carolina | 37075 | 8 | 0 |
276367 | 276367 | 2020-06-26 | Graham | North Carolina | 37075 | 9 | 0 |
279515 | 279515 | 2020-06-27 | Graham | North Carolina | 37075 | 9 | 0 |
282661 | 282661 | 2020-06-28 | Graham | North Carolina | 37075 | 9 | 0 |
285806 | 285806 | 2020-06-29 | Graham | North Carolina | 37075 | 9 | 0 |
288956 | 288956 | 2020-06-30 | Graham | North Carolina | 37075 | 9 | 0 |
292108 | 292108 | 2020-07-01 | Graham | North Carolina | 37075 | 10 | 0 |
295263 | 295263 | 2020-07-02 | Graham | North Carolina | 37075 | 10 | 0 |
298423 | 298423 | 2020-07-03 | Graham | North Carolina | 37075 | 10 | 0 |
301586 | 301586 | 2020-07-04 | Graham | North Carolina | 37075 | 10 | 0 |
304749 | 304749 | 2020-07-05 | Graham | North Carolina | 37075 | 10 | 0 |
307916 | 307916 | 2020-07-06 | Graham | North Carolina | 37075 | 10 | 0 |
311084 | 311084 | 2020-07-07 | Graham | North Carolina | 37075 | 10 | 0 |
314255 | 314255 | 2020-07-08 | Graham | North Carolina | 37075 | 10 | 0 |
317429 | 317429 | 2020-07-09 | Graham | North Carolina | 37075 | 10 | 0 |
320606 | 320606 | 2020-07-10 | Graham | North Carolina | 37075 | 10 | 0 |
323786 | 323786 | 2020-07-11 | Graham | North Carolina | 37075 | 10 | 0 |
326970 | 326970 | 2020-07-12 | Graham | North Carolina | 37075 | 10 | 0 |
330157 | 330157 | 2020-07-13 | Graham | North Carolina | 37075 | 10 | 0 |
333347 | 333347 | 2020-07-14 | Graham | North Carolina | 37075 | 10 | 0 |
336541 | 336541 | 2020-07-15 | Graham | North Carolina | 37075 | 10 | 0 |
339737 | 339737 | 2020-07-16 | Graham | North Carolina | 37075 | 10 | 0 |
342935 | 342935 | 2020-07-17 | Graham | North Carolina | 37075 | 10 | 0 |
346134 | 346134 | 2020-07-18 | Graham | North Carolina | 37075 | 10 | 0 |
349335 | 349335 | 2020-07-19 | Graham | North Carolina | 37075 | 10 | 0 |
352538 | 352538 | 2020-07-20 | Graham | North Carolina | 37075 | 10 | 0 |
355741 | 355741 | 2020-07-21 | Graham | North Carolina | 37075 | 12 | 0 |
358945 | 358945 | 2020-07-22 | Graham | North Carolina | 37075 | 15 | 0 |
362151 | 362151 | 2020-07-23 | Graham | North Carolina | 37075 | 17 | 0 |
365357 | 365357 | 2020-07-24 | Graham | North Carolina | 37075 | 15 | 0 |
368566 | 368566 | 2020-07-25 | Graham | North Carolina | 37075 | 15 | 0 |
371778 | 371778 | 2020-07-26 | Graham | North Carolina | 37075 | 17 | 0 |
374990 | 374990 | 2020-07-27 | Graham | North Carolina | 37075 | 17 | 0 |
378206 | 378206 | 2020-07-28 | Graham | North Carolina | 37075 | 21 | 0 |
381423 | 381423 | 2020-07-29 | Graham | North Carolina | 37075 | 22 | 0 |
384641 | 384641 | 2020-07-30 | Graham | North Carolina | 37075 | 23 | 0 |
387858 | 387858 | 2020-07-31 | Graham | North Carolina | 37075 | 23 | 0 |
391075 | 391075 | 2020-08-01 | Graham | North Carolina | 37075 | 26 | 0 |
394291 | 394291 | 2020-08-02 | Graham | North Carolina | 37075 | 27 | 0 |
397508 | 397508 | 2020-08-03 | Graham | North Carolina | 37075 | 27 | 0 |
400723 | 400723 | 2020-08-04 | Graham | North Carolina | 37075 | 29 | 0 |
403941 | 403941 | 2020-08-05 | Graham | North Carolina | 37075 | 29 | 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);