ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Macon" and state = "North Carolina" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
27543 | 27543 | 2020-04-02 | Macon | North Carolina | 37113 | 1 | 0 |
29870 | 29870 | 2020-04-03 | Macon | North Carolina | 37113 | 1 | 0 |
32257 | 32257 | 2020-04-04 | Macon | North Carolina | 37113 | 1 | 0 |
34688 | 34688 | 2020-04-05 | Macon | North Carolina | 37113 | 1 | 0 |
37157 | 37157 | 2020-04-06 | Macon | North Carolina | 37113 | 1 | 0 |
39672 | 39672 | 2020-04-07 | Macon | North Carolina | 37113 | 1 | 1 |
42229 | 42229 | 2020-04-08 | Macon | North Carolina | 37113 | 1 | 1 |
44813 | 44813 | 2020-04-09 | Macon | North Carolina | 37113 | 2 | 1 |
47426 | 47426 | 2020-04-10 | Macon | North Carolina | 37113 | 2 | 1 |
50081 | 50081 | 2020-04-11 | Macon | North Carolina | 37113 | 2 | 1 |
52754 | 52754 | 2020-04-12 | Macon | North Carolina | 37113 | 2 | 1 |
55438 | 55438 | 2020-04-13 | Macon | North Carolina | 37113 | 2 | 1 |
58138 | 58138 | 2020-04-14 | Macon | North Carolina | 37113 | 2 | 1 |
60852 | 60852 | 2020-04-15 | Macon | North Carolina | 37113 | 2 | 1 |
63578 | 63578 | 2020-04-16 | Macon | North Carolina | 37113 | 2 | 1 |
66321 | 66321 | 2020-04-17 | Macon | North Carolina | 37113 | 2 | 1 |
69078 | 69078 | 2020-04-18 | Macon | North Carolina | 37113 | 2 | 1 |
71844 | 71844 | 2020-04-19 | Macon | North Carolina | 37113 | 2 | 1 |
74619 | 74619 | 2020-04-20 | Macon | North Carolina | 37113 | 2 | 1 |
77400 | 77400 | 2020-04-21 | Macon | North Carolina | 37113 | 2 | 1 |
80189 | 80189 | 2020-04-22 | Macon | North Carolina | 37113 | 2 | 1 |
82988 | 82988 | 2020-04-23 | Macon | North Carolina | 37113 | 2 | 1 |
85792 | 85792 | 2020-04-24 | Macon | North Carolina | 37113 | 2 | 1 |
88604 | 88604 | 2020-04-25 | Macon | North Carolina | 37113 | 2 | 1 |
91419 | 91419 | 2020-04-26 | Macon | North Carolina | 37113 | 2 | 1 |
94245 | 94245 | 2020-04-27 | Macon | North Carolina | 37113 | 2 | 1 |
97082 | 97082 | 2020-04-28 | Macon | North Carolina | 37113 | 2 | 1 |
99930 | 99930 | 2020-04-29 | Macon | North Carolina | 37113 | 2 | 1 |
102783 | 102783 | 2020-04-30 | Macon | North Carolina | 37113 | 3 | 1 |
105645 | 105645 | 2020-05-01 | Macon | North Carolina | 37113 | 3 | 1 |
108512 | 108512 | 2020-05-02 | Macon | North Carolina | 37113 | 3 | 1 |
111385 | 111385 | 2020-05-03 | Macon | North Carolina | 37113 | 3 | 1 |
114266 | 114266 | 2020-05-04 | Macon | North Carolina | 37113 | 3 | 1 |
117146 | 117146 | 2020-05-05 | Macon | North Carolina | 37113 | 3 | 1 |
120107 | 120107 | 2020-05-06 | Macon | North Carolina | 37113 | 3 | 1 |
123082 | 123082 | 2020-05-07 | Macon | North Carolina | 37113 | 3 | 1 |
126065 | 126065 | 2020-05-08 | Macon | North Carolina | 37113 | 3 | 1 |
129054 | 129054 | 2020-05-09 | Macon | North Carolina | 37113 | 3 | 1 |
132043 | 132043 | 2020-05-10 | Macon | North Carolina | 37113 | 3 | 1 |
135034 | 135034 | 2020-05-11 | Macon | North Carolina | 37113 | 3 | 1 |
138024 | 138024 | 2020-05-12 | Macon | North Carolina | 37113 | 3 | 1 |
141020 | 141020 | 2020-05-13 | Macon | North Carolina | 37113 | 3 | 1 |
144015 | 144015 | 2020-05-14 | Macon | North Carolina | 37113 | 3 | 1 |
147016 | 147016 | 2020-05-15 | Macon | North Carolina | 37113 | 3 | 1 |
150023 | 150023 | 2020-05-16 | Macon | North Carolina | 37113 | 4 | 1 |
153033 | 153033 | 2020-05-17 | Macon | North Carolina | 37113 | 4 | 1 |
156050 | 156050 | 2020-05-18 | Macon | North Carolina | 37113 | 5 | 1 |
159069 | 159069 | 2020-05-19 | Macon | North Carolina | 37113 | 5 | 1 |
162096 | 162096 | 2020-05-20 | Macon | North Carolina | 37113 | 5 | 1 |
165125 | 165125 | 2020-05-21 | Macon | North Carolina | 37113 | 5 | 1 |
168160 | 168160 | 2020-05-22 | Macon | North Carolina | 37113 | 7 | 1 |
171199 | 171199 | 2020-05-23 | Macon | North Carolina | 37113 | 8 | 1 |
174241 | 174241 | 2020-05-24 | Macon | North Carolina | 37113 | 9 | 1 |
177285 | 177285 | 2020-05-25 | Macon | North Carolina | 37113 | 18 | 1 |
180328 | 180328 | 2020-05-26 | Macon | North Carolina | 37113 | 18 | 1 |
183376 | 183376 | 2020-05-27 | Macon | North Carolina | 37113 | 18 | 1 |
186433 | 186433 | 2020-05-28 | Macon | North Carolina | 37113 | 19 | 1 |
189493 | 189493 | 2020-05-29 | Macon | North Carolina | 37113 | 47 | 1 |
192557 | 192557 | 2020-05-30 | Macon | North Carolina | 37113 | 62 | 1 |
195627 | 195627 | 2020-05-31 | Macon | North Carolina | 37113 | 70 | 1 |
198700 | 198700 | 2020-06-01 | Macon | North Carolina | 37113 | 84 | 1 |
201774 | 201774 | 2020-06-02 | Macon | North Carolina | 37113 | 89 | 1 |
204851 | 204851 | 2020-06-03 | Macon | North Carolina | 37113 | 89 | 1 |
207932 | 207932 | 2020-06-04 | Macon | North Carolina | 37113 | 98 | 1 |
211014 | 211014 | 2020-06-05 | Macon | North Carolina | 37113 | 119 | 1 |
214098 | 214098 | 2020-06-06 | Macon | North Carolina | 37113 | 120 | 1 |
217188 | 217188 | 2020-06-07 | Macon | North Carolina | 37113 | 121 | 1 |
220280 | 220280 | 2020-06-08 | Macon | North Carolina | 37113 | 146 | 1 |
223374 | 223374 | 2020-06-09 | Macon | North Carolina | 37113 | 157 | 1 |
226474 | 226474 | 2020-06-10 | Macon | North Carolina | 37113 | 158 | 1 |
229578 | 229578 | 2020-06-11 | Macon | North Carolina | 37113 | 159 | 1 |
232683 | 232683 | 2020-06-12 | Macon | North Carolina | 37113 | 178 | 1 |
235788 | 235788 | 2020-06-13 | Macon | North Carolina | 37113 | 185 | 1 |
238896 | 238896 | 2020-06-14 | Macon | North Carolina | 37113 | 217 | 1 |
242005 | 242005 | 2020-06-15 | Macon | North Carolina | 37113 | 231 | 1 |
251345 | 251345 | 2020-06-18 | Macon | North Carolina | 37113 | 235 | 1 |
248230 | 248230 | 2020-06-17 | Macon | North Carolina | 37113 | 236 | 1 |
245117 | 245117 | 2020-06-16 | Macon | North Carolina | 37113 | 237 | 1 |
254460 | 254460 | 2020-06-19 | Macon | North Carolina | 37113 | 243 | 1 |
257583 | 257583 | 2020-06-20 | Macon | North Carolina | 37113 | 247 | 1 |
260710 | 260710 | 2020-06-21 | Macon | North Carolina | 37113 | 252 | 1 |
263838 | 263838 | 2020-06-22 | Macon | North Carolina | 37113 | 252 | 1 |
266966 | 266966 | 2020-06-23 | Macon | North Carolina | 37113 | 256 | 1 |
270100 | 270100 | 2020-06-24 | Macon | North Carolina | 37113 | 259 | 1 |
273239 | 273239 | 2020-06-25 | Macon | North Carolina | 37113 | 262 | 1 |
276385 | 276385 | 2020-06-26 | Macon | North Carolina | 37113 | 263 | 1 |
279533 | 279533 | 2020-06-27 | Macon | North Carolina | 37113 | 266 | 1 |
282679 | 282679 | 2020-06-28 | Macon | North Carolina | 37113 | 277 | 1 |
285824 | 285824 | 2020-06-29 | Macon | North Carolina | 37113 | 280 | 1 |
288974 | 288974 | 2020-06-30 | Macon | North Carolina | 37113 | 282 | 1 |
292126 | 292126 | 2020-07-01 | Macon | North Carolina | 37113 | 282 | 1 |
298441 | 298441 | 2020-07-03 | Macon | North Carolina | 37113 | 288 | 1 |
301604 | 301604 | 2020-07-04 | Macon | North Carolina | 37113 | 288 | 1 |
295281 | 295281 | 2020-07-02 | Macon | North Carolina | 37113 | 289 | 1 |
304767 | 304767 | 2020-07-05 | Macon | North Carolina | 37113 | 289 | 1 |
307934 | 307934 | 2020-07-06 | Macon | North Carolina | 37113 | 291 | 1 |
311102 | 311102 | 2020-07-07 | Macon | North Carolina | 37113 | 293 | 1 |
314273 | 314273 | 2020-07-08 | Macon | North Carolina | 37113 | 298 | 1 |
317447 | 317447 | 2020-07-09 | Macon | North Carolina | 37113 | 315 | 1 |
320624 | 320624 | 2020-07-10 | Macon | North Carolina | 37113 | 322 | 1 |
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);