ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Union" and fips = 37179 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387910 | 387910 | 2020-07-31 | Union | North Carolina | 37179 | 2727 | 41 |
384693 | 384693 | 2020-07-30 | Union | North Carolina | 37179 | 2671 | 39 |
381475 | 381475 | 2020-07-29 | Union | North Carolina | 37179 | 2624 | 39 |
378258 | 378258 | 2020-07-28 | Union | North Carolina | 37179 | 2572 | 38 |
375042 | 375042 | 2020-07-27 | Union | North Carolina | 37179 | 2533 | 38 |
371830 | 371830 | 2020-07-26 | Union | North Carolina | 37179 | 2503 | 35 |
368618 | 368618 | 2020-07-25 | Union | North Carolina | 37179 | 2470 | 35 |
365409 | 365409 | 2020-07-24 | Union | North Carolina | 37179 | 2416 | 35 |
362203 | 362203 | 2020-07-23 | Union | North Carolina | 37179 | 2356 | 34 |
358997 | 358997 | 2020-07-22 | Union | North Carolina | 37179 | 2287 | 33 |
355793 | 355793 | 2020-07-21 | Union | North Carolina | 37179 | 2251 | 33 |
352590 | 352590 | 2020-07-20 | Union | North Carolina | 37179 | 2215 | 33 |
349387 | 349387 | 2020-07-19 | Union | North Carolina | 37179 | 2190 | 32 |
346186 | 346186 | 2020-07-18 | Union | North Carolina | 37179 | 2145 | 30 |
342987 | 342987 | 2020-07-17 | Union | North Carolina | 37179 | 2091 | 30 |
339789 | 339789 | 2020-07-16 | Union | North Carolina | 37179 | 2036 | 30 |
336593 | 336593 | 2020-07-15 | Union | North Carolina | 37179 | 2004 | 30 |
333399 | 333399 | 2020-07-14 | Union | North Carolina | 37179 | 1909 | 30 |
330209 | 330209 | 2020-07-13 | Union | North Carolina | 37179 | 1864 | 30 |
327022 | 327022 | 2020-07-12 | Union | North Carolina | 37179 | 1821 | 26 |
323838 | 323838 | 2020-07-11 | Union | North Carolina | 37179 | 1778 | 25 |
320658 | 320658 | 2020-07-10 | Union | North Carolina | 37179 | 1712 | 25 |
317481 | 317481 | 2020-07-09 | Union | North Carolina | 37179 | 1643 | 25 |
314307 | 314307 | 2020-07-08 | Union | North Carolina | 37179 | 1579 | 25 |
311136 | 311136 | 2020-07-07 | Union | North Carolina | 37179 | 1551 | 25 |
307968 | 307968 | 2020-07-06 | Union | North Carolina | 37179 | 1528 | 25 |
304801 | 304801 | 2020-07-05 | Union | North Carolina | 37179 | 1452 | 25 |
301638 | 301638 | 2020-07-04 | Union | North Carolina | 37179 | 1420 | 25 |
298475 | 298475 | 2020-07-03 | Union | North Carolina | 37179 | 1393 | 25 |
295315 | 295315 | 2020-07-02 | Union | North Carolina | 37179 | 1311 | 25 |
292160 | 292160 | 2020-07-01 | Union | North Carolina | 37179 | 1279 | 25 |
289008 | 289008 | 2020-06-30 | Union | North Carolina | 37179 | 1201 | 25 |
285858 | 285858 | 2020-06-29 | Union | North Carolina | 37179 | 1190 | 25 |
282713 | 282713 | 2020-06-28 | Union | North Carolina | 37179 | 1151 | 24 |
279567 | 279567 | 2020-06-27 | Union | North Carolina | 37179 | 1123 | 24 |
276419 | 276419 | 2020-06-26 | Union | North Carolina | 37179 | 1114 | 24 |
273273 | 273273 | 2020-06-25 | Union | North Carolina | 37179 | 1042 | 24 |
270134 | 270134 | 2020-06-24 | Union | North Carolina | 37179 | 1032 | 24 |
267000 | 267000 | 2020-06-23 | Union | North Carolina | 37179 | 971 | 24 |
263872 | 263872 | 2020-06-22 | Union | North Carolina | 37179 | 971 | 24 |
260744 | 260744 | 2020-06-21 | Union | North Carolina | 37179 | 920 | 24 |
257617 | 257617 | 2020-06-20 | Union | North Carolina | 37179 | 876 | 24 |
254494 | 254494 | 2020-06-19 | Union | North Carolina | 37179 | 867 | 24 |
251379 | 251379 | 2020-06-18 | Union | North Carolina | 37179 | 802 | 24 |
248264 | 248264 | 2020-06-17 | Union | North Carolina | 37179 | 764 | 24 |
245151 | 245151 | 2020-06-16 | Union | North Carolina | 37179 | 754 | 22 |
242039 | 242039 | 2020-06-15 | Union | North Carolina | 37179 | 733 | 22 |
238930 | 238930 | 2020-06-14 | Union | North Carolina | 37179 | 717 | 22 |
235822 | 235822 | 2020-06-13 | Union | North Carolina | 37179 | 690 | 22 |
232717 | 232717 | 2020-06-12 | Union | North Carolina | 37179 | 690 | 22 |
229612 | 229612 | 2020-06-11 | Union | North Carolina | 37179 | 656 | 22 |
226508 | 226508 | 2020-06-10 | Union | North Carolina | 37179 | 616 | 22 |
223408 | 223408 | 2020-06-09 | Union | North Carolina | 37179 | 604 | 22 |
220314 | 220314 | 2020-06-08 | Union | North Carolina | 37179 | 604 | 22 |
217222 | 217222 | 2020-06-07 | Union | North Carolina | 37179 | 575 | 21 |
214132 | 214132 | 2020-06-06 | Union | North Carolina | 37179 | 567 | 21 |
211048 | 211048 | 2020-06-05 | Union | North Carolina | 37179 | 562 | 21 |
207966 | 207966 | 2020-06-04 | Union | North Carolina | 37179 | 533 | 21 |
204885 | 204885 | 2020-06-03 | Union | North Carolina | 37179 | 533 | 21 |
201808 | 201808 | 2020-06-02 | Union | North Carolina | 37179 | 466 | 21 |
198734 | 198734 | 2020-06-01 | Union | North Carolina | 37179 | 466 | 21 |
195661 | 195661 | 2020-05-31 | Union | North Carolina | 37179 | 442 | 20 |
192591 | 192591 | 2020-05-30 | Union | North Carolina | 37179 | 439 | 20 |
189527 | 189527 | 2020-05-29 | Union | North Carolina | 37179 | 439 | 20 |
186467 | 186467 | 2020-05-28 | Union | North Carolina | 37179 | 417 | 18 |
183410 | 183410 | 2020-05-27 | Union | North Carolina | 37179 | 417 | 18 |
180362 | 180362 | 2020-05-26 | Union | North Carolina | 37179 | 408 | 17 |
177319 | 177319 | 2020-05-25 | Union | North Carolina | 37179 | 408 | 17 |
174275 | 174275 | 2020-05-24 | Union | North Carolina | 37179 | 394 | 17 |
171233 | 171233 | 2020-05-23 | Union | North Carolina | 37179 | 393 | 17 |
168194 | 168194 | 2020-05-22 | Union | North Carolina | 37179 | 373 | 17 |
165159 | 165159 | 2020-05-21 | Union | North Carolina | 37179 | 373 | 17 |
162130 | 162130 | 2020-05-20 | Union | North Carolina | 37179 | 371 | 17 |
159103 | 159103 | 2020-05-19 | Union | North Carolina | 37179 | 365 | 17 |
156084 | 156084 | 2020-05-18 | Union | North Carolina | 37179 | 354 | 17 |
153067 | 153067 | 2020-05-17 | Union | North Carolina | 37179 | 354 | 17 |
150057 | 150057 | 2020-05-16 | Union | North Carolina | 37179 | 352 | 17 |
147050 | 147050 | 2020-05-15 | Union | North Carolina | 37179 | 337 | 17 |
144049 | 144049 | 2020-05-14 | Union | North Carolina | 37179 | 313 | 17 |
141054 | 141054 | 2020-05-13 | Union | North Carolina | 37179 | 310 | 17 |
138058 | 138058 | 2020-05-12 | Union | North Carolina | 37179 | 310 | 17 |
135068 | 135068 | 2020-05-11 | Union | North Carolina | 37179 | 301 | 17 |
132077 | 132077 | 2020-05-10 | Union | North Carolina | 37179 | 297 | 17 |
129088 | 129088 | 2020-05-09 | Union | North Carolina | 37179 | 294 | 17 |
126099 | 126099 | 2020-05-08 | Union | North Carolina | 37179 | 284 | 16 |
123116 | 123116 | 2020-05-07 | Union | North Carolina | 37179 | 283 | 15 |
120141 | 120141 | 2020-05-06 | Union | North Carolina | 37179 | 275 | 15 |
117180 | 117180 | 2020-05-05 | Union | North Carolina | 37179 | 271 | 14 |
114300 | 114300 | 2020-05-04 | Union | North Carolina | 37179 | 263 | 13 |
111419 | 111419 | 2020-05-03 | Union | North Carolina | 37179 | 263 | 12 |
108546 | 108546 | 2020-05-02 | Union | North Carolina | 37179 | 257 | 11 |
105679 | 105679 | 2020-05-01 | Union | North Carolina | 37179 | 254 | 11 |
102817 | 102817 | 2020-04-30 | Union | North Carolina | 37179 | 240 | 9 |
99964 | 99964 | 2020-04-29 | Union | North Carolina | 37179 | 228 | 9 |
97115 | 97115 | 2020-04-28 | Union | North Carolina | 37179 | 211 | 9 |
94278 | 94278 | 2020-04-27 | Union | North Carolina | 37179 | 205 | 9 |
91452 | 91452 | 2020-04-26 | Union | North Carolina | 37179 | 201 | 8 |
88637 | 88637 | 2020-04-25 | Union | North Carolina | 37179 | 195 | 7 |
85824 | 85824 | 2020-04-24 | Union | North Carolina | 37179 | 190 | 7 |
83020 | 83020 | 2020-04-23 | Union | North Carolina | 37179 | 186 | 6 |
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);