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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
7879 | 7879 | 2020-03-22 | Union | North Carolina | 37179 | 9 | 0 |
9080 | 9080 | 2020-03-23 | Union | North Carolina | 37179 | 12 | 0 |
10391 | 10391 | 2020-03-24 | Union | North Carolina | 37179 | 13 | 0 |
11836 | 11836 | 2020-03-25 | Union | North Carolina | 37179 | 16 | 0 |
13440 | 13440 | 2020-03-26 | Union | North Carolina | 37179 | 24 | 0 |
15177 | 15177 | 2020-03-27 | Union | North Carolina | 37179 | 27 | 0 |
17011 | 17011 | 2020-03-28 | Union | North Carolina | 37179 | 30 | 0 |
18943 | 18943 | 2020-03-29 | Union | North Carolina | 37179 | 38 | 0 |
20984 | 20984 | 2020-03-30 | Union | North Carolina | 37179 | 38 | 0 |
23112 | 23112 | 2020-03-31 | Union | North Carolina | 37179 | 42 | 0 |
25306 | 25306 | 2020-04-01 | Union | North Carolina | 37179 | 47 | 0 |
27572 | 27572 | 2020-04-02 | Union | North Carolina | 37179 | 55 | 0 |
29899 | 29899 | 2020-04-03 | Union | North Carolina | 37179 | 60 | 0 |
32286 | 32286 | 2020-04-04 | Union | North Carolina | 37179 | 67 | 0 |
34718 | 34718 | 2020-04-05 | Union | North Carolina | 37179 | 67 | 0 |
37187 | 37187 | 2020-04-06 | Union | North Carolina | 37179 | 75 | 0 |
39703 | 39703 | 2020-04-07 | Union | North Carolina | 37179 | 83 | 0 |
42260 | 42260 | 2020-04-08 | Union | North Carolina | 37179 | 87 | 0 |
44844 | 44844 | 2020-04-09 | Union | North Carolina | 37179 | 93 | 1 |
47457 | 47457 | 2020-04-10 | Union | North Carolina | 37179 | 100 | 1 |
50112 | 50112 | 2020-04-11 | Union | North Carolina | 37179 | 101 | 1 |
52785 | 52785 | 2020-04-12 | Union | North Carolina | 37179 | 101 | 1 |
55469 | 55469 | 2020-04-13 | Union | North Carolina | 37179 | 104 | 1 |
58170 | 58170 | 2020-04-14 | Union | North Carolina | 37179 | 110 | 3 |
60884 | 60884 | 2020-04-15 | Union | North Carolina | 37179 | 112 | 3 |
63610 | 63610 | 2020-04-16 | Union | North Carolina | 37179 | 129 | 3 |
66353 | 66353 | 2020-04-17 | Union | North Carolina | 37179 | 137 | 3 |
69110 | 69110 | 2020-04-18 | Union | North Carolina | 37179 | 139 | 3 |
71876 | 71876 | 2020-04-19 | Union | North Carolina | 37179 | 149 | 3 |
74651 | 74651 | 2020-04-20 | Union | North Carolina | 37179 | 163 | 4 |
77432 | 77432 | 2020-04-21 | Union | North Carolina | 37179 | 171 | 5 |
80221 | 80221 | 2020-04-22 | Union | North Carolina | 37179 | 179 | 6 |
83020 | 83020 | 2020-04-23 | Union | North Carolina | 37179 | 186 | 6 |
85824 | 85824 | 2020-04-24 | Union | North Carolina | 37179 | 190 | 7 |
88637 | 88637 | 2020-04-25 | Union | North Carolina | 37179 | 195 | 7 |
91452 | 91452 | 2020-04-26 | Union | North Carolina | 37179 | 201 | 8 |
94278 | 94278 | 2020-04-27 | Union | North Carolina | 37179 | 205 | 9 |
97115 | 97115 | 2020-04-28 | Union | North Carolina | 37179 | 211 | 9 |
99964 | 99964 | 2020-04-29 | Union | North Carolina | 37179 | 228 | 9 |
102817 | 102817 | 2020-04-30 | Union | North Carolina | 37179 | 240 | 9 |
105679 | 105679 | 2020-05-01 | Union | North Carolina | 37179 | 254 | 11 |
108546 | 108546 | 2020-05-02 | Union | North Carolina | 37179 | 257 | 11 |
111419 | 111419 | 2020-05-03 | Union | North Carolina | 37179 | 263 | 12 |
114300 | 114300 | 2020-05-04 | Union | North Carolina | 37179 | 263 | 13 |
117180 | 117180 | 2020-05-05 | Union | North Carolina | 37179 | 271 | 14 |
120141 | 120141 | 2020-05-06 | Union | North Carolina | 37179 | 275 | 15 |
123116 | 123116 | 2020-05-07 | Union | North Carolina | 37179 | 283 | 15 |
126099 | 126099 | 2020-05-08 | Union | North Carolina | 37179 | 284 | 16 |
129088 | 129088 | 2020-05-09 | Union | North Carolina | 37179 | 294 | 17 |
132077 | 132077 | 2020-05-10 | Union | North Carolina | 37179 | 297 | 17 |
135068 | 135068 | 2020-05-11 | Union | North Carolina | 37179 | 301 | 17 |
138058 | 138058 | 2020-05-12 | Union | North Carolina | 37179 | 310 | 17 |
141054 | 141054 | 2020-05-13 | Union | North Carolina | 37179 | 310 | 17 |
144049 | 144049 | 2020-05-14 | Union | North Carolina | 37179 | 313 | 17 |
147050 | 147050 | 2020-05-15 | Union | North Carolina | 37179 | 337 | 17 |
150057 | 150057 | 2020-05-16 | Union | North Carolina | 37179 | 352 | 17 |
153067 | 153067 | 2020-05-17 | Union | North Carolina | 37179 | 354 | 17 |
156084 | 156084 | 2020-05-18 | Union | North Carolina | 37179 | 354 | 17 |
159103 | 159103 | 2020-05-19 | Union | North Carolina | 37179 | 365 | 17 |
162130 | 162130 | 2020-05-20 | Union | North Carolina | 37179 | 371 | 17 |
165159 | 165159 | 2020-05-21 | Union | North Carolina | 37179 | 373 | 17 |
168194 | 168194 | 2020-05-22 | Union | North Carolina | 37179 | 373 | 17 |
171233 | 171233 | 2020-05-23 | Union | North Carolina | 37179 | 393 | 17 |
174275 | 174275 | 2020-05-24 | Union | North Carolina | 37179 | 394 | 17 |
177319 | 177319 | 2020-05-25 | Union | North Carolina | 37179 | 408 | 17 |
180362 | 180362 | 2020-05-26 | Union | North Carolina | 37179 | 408 | 17 |
183410 | 183410 | 2020-05-27 | Union | North Carolina | 37179 | 417 | 18 |
186467 | 186467 | 2020-05-28 | Union | North Carolina | 37179 | 417 | 18 |
189527 | 189527 | 2020-05-29 | Union | North Carolina | 37179 | 439 | 20 |
192591 | 192591 | 2020-05-30 | Union | North Carolina | 37179 | 439 | 20 |
195661 | 195661 | 2020-05-31 | Union | North Carolina | 37179 | 442 | 20 |
198734 | 198734 | 2020-06-01 | Union | North Carolina | 37179 | 466 | 21 |
201808 | 201808 | 2020-06-02 | Union | North Carolina | 37179 | 466 | 21 |
204885 | 204885 | 2020-06-03 | Union | North Carolina | 37179 | 533 | 21 |
207966 | 207966 | 2020-06-04 | Union | North Carolina | 37179 | 533 | 21 |
211048 | 211048 | 2020-06-05 | Union | North Carolina | 37179 | 562 | 21 |
214132 | 214132 | 2020-06-06 | Union | North Carolina | 37179 | 567 | 21 |
217222 | 217222 | 2020-06-07 | Union | North Carolina | 37179 | 575 | 21 |
220314 | 220314 | 2020-06-08 | Union | North Carolina | 37179 | 604 | 22 |
223408 | 223408 | 2020-06-09 | Union | North Carolina | 37179 | 604 | 22 |
226508 | 226508 | 2020-06-10 | Union | North Carolina | 37179 | 616 | 22 |
229612 | 229612 | 2020-06-11 | Union | North Carolina | 37179 | 656 | 22 |
232717 | 232717 | 2020-06-12 | Union | North Carolina | 37179 | 690 | 22 |
235822 | 235822 | 2020-06-13 | Union | North Carolina | 37179 | 690 | 22 |
238930 | 238930 | 2020-06-14 | Union | North Carolina | 37179 | 717 | 22 |
242039 | 242039 | 2020-06-15 | Union | North Carolina | 37179 | 733 | 22 |
245151 | 245151 | 2020-06-16 | Union | North Carolina | 37179 | 754 | 22 |
248264 | 248264 | 2020-06-17 | Union | North Carolina | 37179 | 764 | 24 |
251379 | 251379 | 2020-06-18 | Union | North Carolina | 37179 | 802 | 24 |
254494 | 254494 | 2020-06-19 | Union | North Carolina | 37179 | 867 | 24 |
257617 | 257617 | 2020-06-20 | Union | North Carolina | 37179 | 876 | 24 |
260744 | 260744 | 2020-06-21 | Union | North Carolina | 37179 | 920 | 24 |
263872 | 263872 | 2020-06-22 | Union | North Carolina | 37179 | 971 | 24 |
267000 | 267000 | 2020-06-23 | Union | North Carolina | 37179 | 971 | 24 |
270134 | 270134 | 2020-06-24 | Union | North Carolina | 37179 | 1032 | 24 |
273273 | 273273 | 2020-06-25 | Union | North Carolina | 37179 | 1042 | 24 |
276419 | 276419 | 2020-06-26 | Union | North Carolina | 37179 | 1114 | 24 |
279567 | 279567 | 2020-06-27 | Union | North Carolina | 37179 | 1123 | 24 |
282713 | 282713 | 2020-06-28 | Union | North Carolina | 37179 | 1151 | 24 |
285858 | 285858 | 2020-06-29 | Union | North Carolina | 37179 | 1190 | 25 |
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);