ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
749 rows where county = "Madison" and fips = 37115 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
88605 | 88605 | 2020-04-25 | Madison | North Carolina | 37115 | 1 | 0 |
91420 | 91420 | 2020-04-26 | Madison | North Carolina | 37115 | 1 | 0 |
94246 | 94246 | 2020-04-27 | Madison | North Carolina | 37115 | 1 | 0 |
97083 | 97083 | 2020-04-28 | Madison | North Carolina | 37115 | 1 | 0 |
99931 | 99931 | 2020-04-29 | Madison | North Carolina | 37115 | 1 | 0 |
102784 | 102784 | 2020-04-30 | Madison | North Carolina | 37115 | 1 | 0 |
105646 | 105646 | 2020-05-01 | Madison | North Carolina | 37115 | 1 | 0 |
108513 | 108513 | 2020-05-02 | Madison | North Carolina | 37115 | 1 | 0 |
111386 | 111386 | 2020-05-03 | Madison | North Carolina | 37115 | 1 | 0 |
114267 | 114267 | 2020-05-04 | Madison | North Carolina | 37115 | 1 | 0 |
117147 | 117147 | 2020-05-05 | Madison | North Carolina | 37115 | 1 | 0 |
120108 | 120108 | 2020-05-06 | Madison | North Carolina | 37115 | 1 | 0 |
123083 | 123083 | 2020-05-07 | Madison | North Carolina | 37115 | 1 | 0 |
126066 | 126066 | 2020-05-08 | Madison | North Carolina | 37115 | 1 | 0 |
129055 | 129055 | 2020-05-09 | Madison | North Carolina | 37115 | 1 | 0 |
132044 | 132044 | 2020-05-10 | Madison | North Carolina | 37115 | 1 | 0 |
135035 | 135035 | 2020-05-11 | Madison | North Carolina | 37115 | 1 | 0 |
138025 | 138025 | 2020-05-12 | Madison | North Carolina | 37115 | 1 | 0 |
141021 | 141021 | 2020-05-13 | Madison | North Carolina | 37115 | 1 | 0 |
144016 | 144016 | 2020-05-14 | Madison | North Carolina | 37115 | 1 | 0 |
147017 | 147017 | 2020-05-15 | Madison | North Carolina | 37115 | 1 | 0 |
150024 | 150024 | 2020-05-16 | Madison | North Carolina | 37115 | 1 | 0 |
153034 | 153034 | 2020-05-17 | Madison | North Carolina | 37115 | 2 | 0 |
156051 | 156051 | 2020-05-18 | Madison | North Carolina | 37115 | 2 | 0 |
159070 | 159070 | 2020-05-19 | Madison | North Carolina | 37115 | 2 | 0 |
162097 | 162097 | 2020-05-20 | Madison | North Carolina | 37115 | 2 | 0 |
165126 | 165126 | 2020-05-21 | Madison | North Carolina | 37115 | 4 | 0 |
168161 | 168161 | 2020-05-22 | Madison | North Carolina | 37115 | 2 | 0 |
171200 | 171200 | 2020-05-23 | Madison | North Carolina | 37115 | 3 | 0 |
174242 | 174242 | 2020-05-24 | Madison | North Carolina | 37115 | 2 | 0 |
177286 | 177286 | 2020-05-25 | Madison | North Carolina | 37115 | 3 | 0 |
180329 | 180329 | 2020-05-26 | Madison | North Carolina | 37115 | 3 | 0 |
183377 | 183377 | 2020-05-27 | Madison | North Carolina | 37115 | 3 | 0 |
186434 | 186434 | 2020-05-28 | Madison | North Carolina | 37115 | 3 | 0 |
189494 | 189494 | 2020-05-29 | Madison | North Carolina | 37115 | 3 | 0 |
192558 | 192558 | 2020-05-30 | Madison | North Carolina | 37115 | 3 | 0 |
195628 | 195628 | 2020-05-31 | Madison | North Carolina | 37115 | 3 | 0 |
198701 | 198701 | 2020-06-01 | Madison | North Carolina | 37115 | 3 | 0 |
201775 | 201775 | 2020-06-02 | Madison | North Carolina | 37115 | 3 | 0 |
204852 | 204852 | 2020-06-03 | Madison | North Carolina | 37115 | 4 | 0 |
207933 | 207933 | 2020-06-04 | Madison | North Carolina | 37115 | 3 | 0 |
211015 | 211015 | 2020-06-05 | Madison | North Carolina | 37115 | 3 | 0 |
214099 | 214099 | 2020-06-06 | Madison | North Carolina | 37115 | 3 | 0 |
217189 | 217189 | 2020-06-07 | Madison | North Carolina | 37115 | 3 | 0 |
220281 | 220281 | 2020-06-08 | Madison | North Carolina | 37115 | 3 | 0 |
223375 | 223375 | 2020-06-09 | Madison | North Carolina | 37115 | 3 | 0 |
226475 | 226475 | 2020-06-10 | Madison | North Carolina | 37115 | 3 | 0 |
229579 | 229579 | 2020-06-11 | Madison | North Carolina | 37115 | 4 | 0 |
232684 | 232684 | 2020-06-12 | Madison | North Carolina | 37115 | 4 | 0 |
235789 | 235789 | 2020-06-13 | Madison | North Carolina | 37115 | 5 | 0 |
238897 | 238897 | 2020-06-14 | Madison | North Carolina | 37115 | 5 | 0 |
242006 | 242006 | 2020-06-15 | Madison | North Carolina | 37115 | 5 | 0 |
245118 | 245118 | 2020-06-16 | Madison | North Carolina | 37115 | 5 | 0 |
248231 | 248231 | 2020-06-17 | Madison | North Carolina | 37115 | 5 | 0 |
251346 | 251346 | 2020-06-18 | Madison | North Carolina | 37115 | 5 | 0 |
254461 | 254461 | 2020-06-19 | Madison | North Carolina | 37115 | 5 | 0 |
257584 | 257584 | 2020-06-20 | Madison | North Carolina | 37115 | 6 | 0 |
260711 | 260711 | 2020-06-21 | Madison | North Carolina | 37115 | 6 | 0 |
263839 | 263839 | 2020-06-22 | Madison | North Carolina | 37115 | 6 | 0 |
266967 | 266967 | 2020-06-23 | Madison | North Carolina | 37115 | 7 | 0 |
270101 | 270101 | 2020-06-24 | Madison | North Carolina | 37115 | 8 | 0 |
273240 | 273240 | 2020-06-25 | Madison | North Carolina | 37115 | 9 | 0 |
276386 | 276386 | 2020-06-26 | Madison | North Carolina | 37115 | 9 | 0 |
279534 | 279534 | 2020-06-27 | Madison | North Carolina | 37115 | 11 | 0 |
282680 | 282680 | 2020-06-28 | Madison | North Carolina | 37115 | 12 | 0 |
285825 | 285825 | 2020-06-29 | Madison | North Carolina | 37115 | 13 | 0 |
288975 | 288975 | 2020-06-30 | Madison | North Carolina | 37115 | 12 | 0 |
292127 | 292127 | 2020-07-01 | Madison | North Carolina | 37115 | 14 | 0 |
295282 | 295282 | 2020-07-02 | Madison | North Carolina | 37115 | 13 | 0 |
298442 | 298442 | 2020-07-03 | Madison | North Carolina | 37115 | 14 | 0 |
301605 | 301605 | 2020-07-04 | Madison | North Carolina | 37115 | 14 | 0 |
304768 | 304768 | 2020-07-05 | Madison | North Carolina | 37115 | 16 | 0 |
307935 | 307935 | 2020-07-06 | Madison | North Carolina | 37115 | 17 | 0 |
311103 | 311103 | 2020-07-07 | Madison | North Carolina | 37115 | 15 | 0 |
314274 | 314274 | 2020-07-08 | Madison | North Carolina | 37115 | 15 | 0 |
317448 | 317448 | 2020-07-09 | Madison | North Carolina | 37115 | 15 | 0 |
320625 | 320625 | 2020-07-10 | Madison | North Carolina | 37115 | 15 | 0 |
323805 | 323805 | 2020-07-11 | Madison | North Carolina | 37115 | 17 | 0 |
326989 | 326989 | 2020-07-12 | Madison | North Carolina | 37115 | 17 | 0 |
330176 | 330176 | 2020-07-13 | Madison | North Carolina | 37115 | 18 | 0 |
333366 | 333366 | 2020-07-14 | Madison | North Carolina | 37115 | 18 | 0 |
336560 | 336560 | 2020-07-15 | Madison | North Carolina | 37115 | 18 | 0 |
339756 | 339756 | 2020-07-16 | Madison | North Carolina | 37115 | 19 | 0 |
342954 | 342954 | 2020-07-17 | Madison | North Carolina | 37115 | 20 | 0 |
346153 | 346153 | 2020-07-18 | Madison | North Carolina | 37115 | 21 | 0 |
349354 | 349354 | 2020-07-19 | Madison | North Carolina | 37115 | 22 | 0 |
352557 | 352557 | 2020-07-20 | Madison | North Carolina | 37115 | 24 | 0 |
355760 | 355760 | 2020-07-21 | Madison | North Carolina | 37115 | 24 | 0 |
358964 | 358964 | 2020-07-22 | Madison | North Carolina | 37115 | 25 | 0 |
362170 | 362170 | 2020-07-23 | Madison | North Carolina | 37115 | 27 | 0 |
365376 | 365376 | 2020-07-24 | Madison | North Carolina | 37115 | 28 | 0 |
368585 | 368585 | 2020-07-25 | Madison | North Carolina | 37115 | 28 | 0 |
371797 | 371797 | 2020-07-26 | Madison | North Carolina | 37115 | 30 | 0 |
375009 | 375009 | 2020-07-27 | Madison | North Carolina | 37115 | 30 | 0 |
378225 | 378225 | 2020-07-28 | Madison | North Carolina | 37115 | 32 | 0 |
381442 | 381442 | 2020-07-29 | Madison | North Carolina | 37115 | 34 | 0 |
384660 | 384660 | 2020-07-30 | Madison | North Carolina | 37115 | 36 | 0 |
387877 | 387877 | 2020-07-31 | Madison | North Carolina | 37115 | 38 | 0 |
391094 | 391094 | 2020-08-01 | Madison | North Carolina | 37115 | 38 | 0 |
394310 | 394310 | 2020-08-02 | Madison | North Carolina | 37115 | 38 | 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);