ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Union" and fips = 46127 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388436 | 388436 | 2020-07-31 | Union | South Dakota | 46127 | 191 | 3 |
385219 | 385219 | 2020-07-30 | Union | South Dakota | 46127 | 187 | 3 |
382001 | 382001 | 2020-07-29 | Union | South Dakota | 46127 | 187 | 3 |
378784 | 378784 | 2020-07-28 | Union | South Dakota | 46127 | 180 | 2 |
375568 | 375568 | 2020-07-27 | Union | South Dakota | 46127 | 178 | 2 |
372355 | 372355 | 2020-07-26 | Union | South Dakota | 46127 | 175 | 2 |
369143 | 369143 | 2020-07-25 | Union | South Dakota | 46127 | 172 | 2 |
365934 | 365934 | 2020-07-24 | Union | South Dakota | 46127 | 171 | 2 |
362728 | 362728 | 2020-07-23 | Union | South Dakota | 46127 | 168 | 2 |
359521 | 359521 | 2020-07-22 | Union | South Dakota | 46127 | 166 | 2 |
356317 | 356317 | 2020-07-21 | Union | South Dakota | 46127 | 166 | 2 |
353114 | 353114 | 2020-07-20 | Union | South Dakota | 46127 | 164 | 2 |
349911 | 349911 | 2020-07-19 | Union | South Dakota | 46127 | 161 | 2 |
346711 | 346711 | 2020-07-18 | Union | South Dakota | 46127 | 159 | 2 |
343511 | 343511 | 2020-07-17 | Union | South Dakota | 46127 | 157 | 2 |
340313 | 340313 | 2020-07-16 | Union | South Dakota | 46127 | 157 | 2 |
337116 | 337116 | 2020-07-15 | Union | South Dakota | 46127 | 156 | 1 |
333922 | 333922 | 2020-07-14 | Union | South Dakota | 46127 | 156 | 1 |
330730 | 330730 | 2020-07-13 | Union | South Dakota | 46127 | 151 | 1 |
327544 | 327544 | 2020-07-12 | Union | South Dakota | 46127 | 151 | 1 |
324359 | 324359 | 2020-07-11 | Union | South Dakota | 46127 | 150 | 1 |
321178 | 321178 | 2020-07-10 | Union | South Dakota | 46127 | 148 | 1 |
318000 | 318000 | 2020-07-09 | Union | South Dakota | 46127 | 140 | 1 |
314827 | 314827 | 2020-07-08 | Union | South Dakota | 46127 | 138 | 1 |
311653 | 311653 | 2020-07-07 | Union | South Dakota | 46127 | 137 | 1 |
308484 | 308484 | 2020-07-06 | Union | South Dakota | 46127 | 137 | 1 |
305316 | 305316 | 2020-07-05 | Union | South Dakota | 46127 | 133 | 1 |
302153 | 302153 | 2020-07-04 | Union | South Dakota | 46127 | 133 | 1 |
298989 | 298989 | 2020-07-03 | Union | South Dakota | 46127 | 132 | 1 |
295829 | 295829 | 2020-07-02 | Union | South Dakota | 46127 | 126 | 1 |
292673 | 292673 | 2020-07-01 | Union | South Dakota | 46127 | 124 | 1 |
289521 | 289521 | 2020-06-30 | Union | South Dakota | 46127 | 123 | 1 |
286370 | 286370 | 2020-06-29 | Union | South Dakota | 46127 | 121 | 1 |
283225 | 283225 | 2020-06-28 | Union | South Dakota | 46127 | 121 | 1 |
280079 | 280079 | 2020-06-27 | Union | South Dakota | 46127 | 119 | 1 |
276931 | 276931 | 2020-06-26 | Union | South Dakota | 46127 | 118 | 1 |
273784 | 273784 | 2020-06-25 | Union | South Dakota | 46127 | 118 | 1 |
270645 | 270645 | 2020-06-24 | Union | South Dakota | 46127 | 118 | 1 |
267511 | 267511 | 2020-06-23 | Union | South Dakota | 46127 | 117 | 1 |
264383 | 264383 | 2020-06-22 | Union | South Dakota | 46127 | 117 | 1 |
261255 | 261255 | 2020-06-21 | Union | South Dakota | 46127 | 117 | 1 |
258128 | 258128 | 2020-06-20 | Union | South Dakota | 46127 | 116 | 1 |
255002 | 255002 | 2020-06-19 | Union | South Dakota | 46127 | 114 | 1 |
251887 | 251887 | 2020-06-18 | Union | South Dakota | 46127 | 113 | 1 |
248772 | 248772 | 2020-06-17 | Union | South Dakota | 46127 | 113 | 1 |
245659 | 245659 | 2020-06-16 | Union | South Dakota | 46127 | 113 | 1 |
242547 | 242547 | 2020-06-15 | Union | South Dakota | 46127 | 113 | 1 |
239437 | 239437 | 2020-06-14 | Union | South Dakota | 46127 | 113 | 1 |
236329 | 236329 | 2020-06-13 | Union | South Dakota | 46127 | 109 | 1 |
233223 | 233223 | 2020-06-12 | Union | South Dakota | 46127 | 109 | 1 |
230118 | 230118 | 2020-06-11 | Union | South Dakota | 46127 | 105 | 1 |
227014 | 227014 | 2020-06-10 | Union | South Dakota | 46127 | 105 | 0 |
223914 | 223914 | 2020-06-09 | Union | South Dakota | 46127 | 103 | 0 |
220819 | 220819 | 2020-06-08 | Union | South Dakota | 46127 | 100 | 0 |
217727 | 217727 | 2020-06-07 | Union | South Dakota | 46127 | 100 | 0 |
214637 | 214637 | 2020-06-06 | Union | South Dakota | 46127 | 98 | 0 |
211550 | 211550 | 2020-06-05 | Union | South Dakota | 46127 | 93 | 0 |
208468 | 208468 | 2020-06-04 | Union | South Dakota | 46127 | 93 | 0 |
205386 | 205386 | 2020-06-03 | Union | South Dakota | 46127 | 92 | 0 |
202307 | 202307 | 2020-06-02 | Union | South Dakota | 46127 | 91 | 0 |
199232 | 199232 | 2020-06-01 | Union | South Dakota | 46127 | 91 | 0 |
196159 | 196159 | 2020-05-31 | Union | South Dakota | 46127 | 89 | 0 |
193089 | 193089 | 2020-05-30 | Union | South Dakota | 46127 | 89 | 0 |
190024 | 190024 | 2020-05-29 | Union | South Dakota | 46127 | 88 | 0 |
186960 | 186960 | 2020-05-28 | Union | South Dakota | 46127 | 88 | 0 |
183903 | 183903 | 2020-05-27 | Union | South Dakota | 46127 | 87 | 0 |
180853 | 180853 | 2020-05-26 | Union | South Dakota | 46127 | 86 | 0 |
177810 | 177810 | 2020-05-25 | Union | South Dakota | 46127 | 79 | 0 |
174766 | 174766 | 2020-05-24 | Union | South Dakota | 46127 | 79 | 0 |
171723 | 171723 | 2020-05-23 | Union | South Dakota | 46127 | 75 | 0 |
168684 | 168684 | 2020-05-22 | Union | South Dakota | 46127 | 73 | 0 |
165648 | 165648 | 2020-05-21 | Union | South Dakota | 46127 | 68 | 0 |
162619 | 162619 | 2020-05-20 | Union | South Dakota | 46127 | 68 | 0 |
159592 | 159592 | 2020-05-19 | Union | South Dakota | 46127 | 62 | 0 |
156571 | 156571 | 2020-05-18 | Union | South Dakota | 46127 | 62 | 0 |
153554 | 153554 | 2020-05-17 | Union | South Dakota | 46127 | 60 | 0 |
150543 | 150543 | 2020-05-16 | Union | South Dakota | 46127 | 60 | 0 |
147535 | 147535 | 2020-05-15 | Union | South Dakota | 46127 | 57 | 0 |
144534 | 144534 | 2020-05-14 | Union | South Dakota | 46127 | 57 | 0 |
141537 | 141537 | 2020-05-13 | Union | South Dakota | 46127 | 56 | 0 |
138541 | 138541 | 2020-05-12 | Union | South Dakota | 46127 | 56 | 0 |
135551 | 135551 | 2020-05-11 | Union | South Dakota | 46127 | 53 | 0 |
132560 | 132560 | 2020-05-10 | Union | South Dakota | 46127 | 53 | 0 |
129571 | 129571 | 2020-05-09 | Union | South Dakota | 46127 | 53 | 0 |
126582 | 126582 | 2020-05-08 | Union | South Dakota | 46127 | 50 | 0 |
123599 | 123599 | 2020-05-07 | Union | South Dakota | 46127 | 48 | 0 |
120621 | 120621 | 2020-05-06 | Union | South Dakota | 46127 | 46 | 0 |
117658 | 117658 | 2020-05-05 | Union | South Dakota | 46127 | 46 | 0 |
114702 | 114702 | 2020-05-04 | Union | South Dakota | 46127 | 32 | 0 |
111820 | 111820 | 2020-05-03 | Union | South Dakota | 46127 | 31 | 0 |
108946 | 108946 | 2020-05-02 | Union | South Dakota | 46127 | 27 | 0 |
106079 | 106079 | 2020-05-01 | Union | South Dakota | 46127 | 21 | 0 |
103216 | 103216 | 2020-04-30 | Union | South Dakota | 46127 | 18 | 0 |
100363 | 100363 | 2020-04-29 | Union | South Dakota | 46127 | 17 | 0 |
97513 | 97513 | 2020-04-28 | Union | South Dakota | 46127 | 14 | 0 |
94673 | 94673 | 2020-04-27 | Union | South Dakota | 46127 | 12 | 0 |
91845 | 91845 | 2020-04-26 | Union | South Dakota | 46127 | 12 | 0 |
89028 | 89028 | 2020-04-25 | Union | South Dakota | 46127 | 12 | 0 |
86213 | 86213 | 2020-04-24 | Union | South Dakota | 46127 | 11 | 0 |
83408 | 83408 | 2020-04-23 | Union | South Dakota | 46127 | 8 | 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);