ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Surry" and state = "North Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
15175 | 15175 | 2020-03-27 | Surry | North Carolina | 37171 | 1 | 0 |
17009 | 17009 | 2020-03-28 | Surry | North Carolina | 37171 | 1 | 0 |
18941 | 18941 | 2020-03-29 | Surry | North Carolina | 37171 | 2 | 0 |
20982 | 20982 | 2020-03-30 | Surry | North Carolina | 37171 | 2 | 0 |
23110 | 23110 | 2020-03-31 | Surry | North Carolina | 37171 | 2 | 0 |
25304 | 25304 | 2020-04-01 | Surry | North Carolina | 37171 | 2 | 0 |
27570 | 27570 | 2020-04-02 | Surry | North Carolina | 37171 | 2 | 0 |
29897 | 29897 | 2020-04-03 | Surry | North Carolina | 37171 | 2 | 0 |
32284 | 32284 | 2020-04-04 | Surry | North Carolina | 37171 | 3 | 0 |
34716 | 34716 | 2020-04-05 | Surry | North Carolina | 37171 | 3 | 0 |
37185 | 37185 | 2020-04-06 | Surry | North Carolina | 37171 | 3 | 0 |
39701 | 39701 | 2020-04-07 | Surry | North Carolina | 37171 | 10 | 0 |
42258 | 42258 | 2020-04-08 | Surry | North Carolina | 37171 | 10 | 0 |
44842 | 44842 | 2020-04-09 | Surry | North Carolina | 37171 | 10 | 0 |
47455 | 47455 | 2020-04-10 | Surry | North Carolina | 37171 | 10 | 0 |
50110 | 50110 | 2020-04-11 | Surry | North Carolina | 37171 | 10 | 0 |
52783 | 52783 | 2020-04-12 | Surry | North Carolina | 37171 | 10 | 0 |
55467 | 55467 | 2020-04-13 | Surry | North Carolina | 37171 | 10 | 0 |
58167 | 58167 | 2020-04-14 | Surry | North Carolina | 37171 | 10 | 0 |
60881 | 60881 | 2020-04-15 | Surry | North Carolina | 37171 | 10 | 0 |
63607 | 63607 | 2020-04-16 | Surry | North Carolina | 37171 | 11 | 0 |
66350 | 66350 | 2020-04-17 | Surry | North Carolina | 37171 | 16 | 0 |
69107 | 69107 | 2020-04-18 | Surry | North Carolina | 37171 | 17 | 0 |
71873 | 71873 | 2020-04-19 | Surry | North Carolina | 37171 | 17 | 0 |
74648 | 74648 | 2020-04-20 | Surry | North Carolina | 37171 | 17 | 0 |
77429 | 77429 | 2020-04-21 | Surry | North Carolina | 37171 | 12 | 0 |
80218 | 80218 | 2020-04-22 | Surry | North Carolina | 37171 | 12 | 0 |
83017 | 83017 | 2020-04-23 | Surry | North Carolina | 37171 | 12 | 0 |
85821 | 85821 | 2020-04-24 | Surry | North Carolina | 37171 | 12 | 0 |
88634 | 88634 | 2020-04-25 | Surry | North Carolina | 37171 | 12 | 0 |
91449 | 91449 | 2020-04-26 | Surry | North Carolina | 37171 | 12 | 0 |
94275 | 94275 | 2020-04-27 | Surry | North Carolina | 37171 | 12 | 0 |
97112 | 97112 | 2020-04-28 | Surry | North Carolina | 37171 | 12 | 0 |
99960 | 99960 | 2020-04-29 | Surry | North Carolina | 37171 | 13 | 0 |
102813 | 102813 | 2020-04-30 | Surry | North Carolina | 37171 | 13 | 0 |
105675 | 105675 | 2020-05-01 | Surry | North Carolina | 37171 | 13 | 0 |
108542 | 108542 | 2020-05-02 | Surry | North Carolina | 37171 | 17 | 1 |
111415 | 111415 | 2020-05-03 | Surry | North Carolina | 37171 | 16 | 1 |
114296 | 114296 | 2020-05-04 | Surry | North Carolina | 37171 | 16 | 1 |
117176 | 117176 | 2020-05-05 | Surry | North Carolina | 37171 | 20 | 1 |
120137 | 120137 | 2020-05-06 | Surry | North Carolina | 37171 | 20 | 1 |
123112 | 123112 | 2020-05-07 | Surry | North Carolina | 37171 | 26 | 1 |
126095 | 126095 | 2020-05-08 | Surry | North Carolina | 37171 | 30 | 1 |
129084 | 129084 | 2020-05-09 | Surry | North Carolina | 37171 | 33 | 1 |
132073 | 132073 | 2020-05-10 | Surry | North Carolina | 37171 | 41 | 1 |
135064 | 135064 | 2020-05-11 | Surry | North Carolina | 37171 | 43 | 1 |
138054 | 138054 | 2020-05-12 | Surry | North Carolina | 37171 | 45 | 1 |
141050 | 141050 | 2020-05-13 | Surry | North Carolina | 37171 | 47 | 1 |
144045 | 144045 | 2020-05-14 | Surry | North Carolina | 37171 | 62 | 1 |
147046 | 147046 | 2020-05-15 | Surry | North Carolina | 37171 | 67 | 1 |
150053 | 150053 | 2020-05-16 | Surry | North Carolina | 37171 | 75 | 1 |
153063 | 153063 | 2020-05-17 | Surry | North Carolina | 37171 | 89 | 1 |
156080 | 156080 | 2020-05-18 | Surry | North Carolina | 37171 | 95 | 1 |
159099 | 159099 | 2020-05-19 | Surry | North Carolina | 37171 | 101 | 1 |
162126 | 162126 | 2020-05-20 | Surry | North Carolina | 37171 | 102 | 1 |
165155 | 165155 | 2020-05-21 | Surry | North Carolina | 37171 | 109 | 1 |
168190 | 168190 | 2020-05-22 | Surry | North Carolina | 37171 | 122 | 1 |
171229 | 171229 | 2020-05-23 | Surry | North Carolina | 37171 | 151 | 1 |
174271 | 174271 | 2020-05-24 | Surry | North Carolina | 37171 | 158 | 1 |
177315 | 177315 | 2020-05-25 | Surry | North Carolina | 37171 | 167 | 1 |
180358 | 180358 | 2020-05-26 | Surry | North Carolina | 37171 | 168 | 1 |
183406 | 183406 | 2020-05-27 | Surry | North Carolina | 37171 | 173 | 1 |
186463 | 186463 | 2020-05-28 | Surry | North Carolina | 37171 | 187 | 1 |
189523 | 189523 | 2020-05-29 | Surry | North Carolina | 37171 | 197 | 2 |
192587 | 192587 | 2020-05-30 | Surry | North Carolina | 37171 | 201 | 2 |
195657 | 195657 | 2020-05-31 | Surry | North Carolina | 37171 | 214 | 2 |
198730 | 198730 | 2020-06-01 | Surry | North Carolina | 37171 | 218 | 2 |
201804 | 201804 | 2020-06-02 | Surry | North Carolina | 37171 | 224 | 2 |
204881 | 204881 | 2020-06-03 | Surry | North Carolina | 37171 | 231 | 2 |
207962 | 207962 | 2020-06-04 | Surry | North Carolina | 37171 | 251 | 2 |
211044 | 211044 | 2020-06-05 | Surry | North Carolina | 37171 | 269 | 2 |
214128 | 214128 | 2020-06-06 | Surry | North Carolina | 37171 | 273 | 2 |
217218 | 217218 | 2020-06-07 | Surry | North Carolina | 37171 | 274 | 2 |
220310 | 220310 | 2020-06-08 | Surry | North Carolina | 37171 | 279 | 2 |
223404 | 223404 | 2020-06-09 | Surry | North Carolina | 37171 | 292 | 2 |
226504 | 226504 | 2020-06-10 | Surry | North Carolina | 37171 | 294 | 2 |
229608 | 229608 | 2020-06-11 | Surry | North Carolina | 37171 | 300 | 2 |
232713 | 232713 | 2020-06-12 | Surry | North Carolina | 37171 | 315 | 2 |
235818 | 235818 | 2020-06-13 | Surry | North Carolina | 37171 | 327 | 2 |
238926 | 238926 | 2020-06-14 | Surry | North Carolina | 37171 | 333 | 2 |
242035 | 242035 | 2020-06-15 | Surry | North Carolina | 37171 | 339 | 2 |
245147 | 245147 | 2020-06-16 | Surry | North Carolina | 37171 | 342 | 2 |
248260 | 248260 | 2020-06-17 | Surry | North Carolina | 37171 | 346 | 2 |
251375 | 251375 | 2020-06-18 | Surry | North Carolina | 37171 | 353 | 2 |
254490 | 254490 | 2020-06-19 | Surry | North Carolina | 37171 | 370 | 2 |
257613 | 257613 | 2020-06-20 | Surry | North Carolina | 37171 | 378 | 2 |
260740 | 260740 | 2020-06-21 | Surry | North Carolina | 37171 | 382 | 2 |
263868 | 263868 | 2020-06-22 | Surry | North Carolina | 37171 | 386 | 2 |
266996 | 266996 | 2020-06-23 | Surry | North Carolina | 37171 | 392 | 2 |
270130 | 270130 | 2020-06-24 | Surry | North Carolina | 37171 | 413 | 2 |
273269 | 273269 | 2020-06-25 | Surry | North Carolina | 37171 | 418 | 2 |
276415 | 276415 | 2020-06-26 | Surry | North Carolina | 37171 | 437 | 2 |
279563 | 279563 | 2020-06-27 | Surry | North Carolina | 37171 | 444 | 2 |
282709 | 282709 | 2020-06-28 | Surry | North Carolina | 37171 | 451 | 2 |
285854 | 285854 | 2020-06-29 | Surry | North Carolina | 37171 | 464 | 2 |
289004 | 289004 | 2020-06-30 | Surry | North Carolina | 37171 | 470 | 2 |
292156 | 292156 | 2020-07-01 | Surry | North Carolina | 37171 | 482 | 2 |
295311 | 295311 | 2020-07-02 | Surry | North Carolina | 37171 | 488 | 2 |
298471 | 298471 | 2020-07-03 | Surry | North Carolina | 37171 | 496 | 2 |
301634 | 301634 | 2020-07-04 | Surry | North Carolina | 37171 | 497 | 2 |
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);