ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Union" and fips = 5139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386118 | 386118 | 2020-07-31 | Union | Arkansas | 5139 | 428 | 16 |
382900 | 382900 | 2020-07-30 | Union | Arkansas | 5139 | 396 | 16 |
379683 | 379683 | 2020-07-29 | Union | Arkansas | 5139 | 379 | 16 |
376467 | 376467 | 2020-07-28 | Union | Arkansas | 5139 | 376 | 15 |
373253 | 373253 | 2020-07-27 | Union | Arkansas | 5139 | 373 | 15 |
370041 | 370041 | 2020-07-26 | Union | Arkansas | 5139 | 369 | 15 |
366831 | 366831 | 2020-07-25 | Union | Arkansas | 5139 | 361 | 15 |
363624 | 363624 | 2020-07-24 | Union | Arkansas | 5139 | 350 | 15 |
360417 | 360417 | 2020-07-23 | Union | Arkansas | 5139 | 345 | 15 |
357212 | 357212 | 2020-07-22 | Union | Arkansas | 5139 | 335 | 14 |
354009 | 354009 | 2020-07-21 | Union | Arkansas | 5139 | 333 | 14 |
350807 | 350807 | 2020-07-20 | Union | Arkansas | 5139 | 313 | 14 |
347606 | 347606 | 2020-07-19 | Union | Arkansas | 5139 | 306 | 14 |
344406 | 344406 | 2020-07-18 | Union | Arkansas | 5139 | 305 | 14 |
341207 | 341207 | 2020-07-17 | Union | Arkansas | 5139 | 292 | 14 |
338011 | 338011 | 2020-07-16 | Union | Arkansas | 5139 | 287 | 14 |
334816 | 334816 | 2020-07-15 | Union | Arkansas | 5139 | 284 | 14 |
331623 | 331623 | 2020-07-14 | Union | Arkansas | 5139 | 282 | 14 |
328437 | 328437 | 2020-07-13 | Union | Arkansas | 5139 | 275 | 14 |
325251 | 325251 | 2020-07-12 | Union | Arkansas | 5139 | 274 | 14 |
322070 | 322070 | 2020-07-11 | Union | Arkansas | 5139 | 273 | 14 |
318891 | 318891 | 2020-07-10 | Union | Arkansas | 5139 | 267 | 13 |
315718 | 315718 | 2020-07-09 | Union | Arkansas | 5139 | 266 | 13 |
312543 | 312543 | 2020-07-08 | Union | Arkansas | 5139 | 264 | 13 |
309373 | 309373 | 2020-07-07 | Union | Arkansas | 5139 | 256 | 13 |
306205 | 306205 | 2020-07-06 | Union | Arkansas | 5139 | 253 | 13 |
303041 | 303041 | 2020-07-05 | Union | Arkansas | 5139 | 252 | 13 |
299877 | 299877 | 2020-07-04 | Union | Arkansas | 5139 | 252 | 13 |
296715 | 296715 | 2020-07-03 | Union | Arkansas | 5139 | 252 | 13 |
293559 | 293559 | 2020-07-02 | Union | Arkansas | 5139 | 250 | 13 |
290405 | 290405 | 2020-07-01 | Union | Arkansas | 5139 | 249 | 13 |
287254 | 287254 | 2020-06-30 | Union | Arkansas | 5139 | 248 | 13 |
284108 | 284108 | 2020-06-29 | Union | Arkansas | 5139 | 247 | 13 |
280962 | 280962 | 2020-06-28 | Union | Arkansas | 5139 | 245 | 13 |
277815 | 277815 | 2020-06-27 | Union | Arkansas | 5139 | 245 | 13 |
274667 | 274667 | 2020-06-26 | Union | Arkansas | 5139 | 243 | 13 |
271527 | 271527 | 2020-06-25 | Union | Arkansas | 5139 | 237 | 13 |
268392 | 268392 | 2020-06-24 | Union | Arkansas | 5139 | 232 | 13 |
265262 | 265262 | 2020-06-23 | Union | Arkansas | 5139 | 232 | 13 |
262134 | 262134 | 2020-06-22 | Union | Arkansas | 5139 | 227 | 13 |
259007 | 259007 | 2020-06-21 | Union | Arkansas | 5139 | 224 | 13 |
255880 | 255880 | 2020-06-20 | Union | Arkansas | 5139 | 223 | 13 |
252761 | 252761 | 2020-06-19 | Union | Arkansas | 5139 | 220 | 13 |
249646 | 249646 | 2020-06-18 | Union | Arkansas | 5139 | 218 | 13 |
246534 | 246534 | 2020-06-17 | Union | Arkansas | 5139 | 213 | 11 |
243421 | 243421 | 2020-06-16 | Union | Arkansas | 5139 | 209 | 11 |
240310 | 240310 | 2020-06-15 | Union | Arkansas | 5139 | 208 | 11 |
237202 | 237202 | 2020-06-14 | Union | Arkansas | 5139 | 203 | 11 |
234095 | 234095 | 2020-06-13 | Union | Arkansas | 5139 | 202 | 11 |
230989 | 230989 | 2020-06-12 | Union | Arkansas | 5139 | 199 | 11 |
227886 | 227886 | 2020-06-11 | Union | Arkansas | 5139 | 194 | 11 |
224784 | 224784 | 2020-06-10 | Union | Arkansas | 5139 | 190 | 11 |
221689 | 221689 | 2020-06-09 | Union | Arkansas | 5139 | 190 | 11 |
218594 | 218594 | 2020-06-08 | Union | Arkansas | 5139 | 188 | 11 |
215503 | 215503 | 2020-06-07 | Union | Arkansas | 5139 | 188 | 11 |
212416 | 212416 | 2020-06-06 | Union | Arkansas | 5139 | 188 | 11 |
209331 | 209331 | 2020-06-05 | Union | Arkansas | 5139 | 185 | 11 |
206250 | 206250 | 2020-06-04 | Union | Arkansas | 5139 | 179 | 11 |
203170 | 203170 | 2020-06-03 | Union | Arkansas | 5139 | 177 | 10 |
200094 | 200094 | 2020-06-02 | Union | Arkansas | 5139 | 173 | 9 |
197021 | 197021 | 2020-06-01 | Union | Arkansas | 5139 | 173 | 8 |
193951 | 193951 | 2020-05-31 | Union | Arkansas | 5139 | 173 | 8 |
190884 | 190884 | 2020-05-30 | Union | Arkansas | 5139 | 171 | 8 |
187819 | 187819 | 2020-05-29 | Union | Arkansas | 5139 | 166 | 8 |
184763 | 184763 | 2020-05-28 | Union | Arkansas | 5139 | 164 | 8 |
181709 | 181709 | 2020-05-27 | Union | Arkansas | 5139 | 162 | 6 |
178665 | 178665 | 2020-05-26 | Union | Arkansas | 5139 | 162 | 6 |
175621 | 175621 | 2020-05-25 | Union | Arkansas | 5139 | 160 | 6 |
172577 | 172577 | 2020-05-24 | Union | Arkansas | 5139 | 157 | 6 |
169536 | 169536 | 2020-05-23 | Union | Arkansas | 5139 | 152 | 5 |
166500 | 166500 | 2020-05-22 | Union | Arkansas | 5139 | 144 | 4 |
163468 | 163468 | 2020-05-21 | Union | Arkansas | 5139 | 140 | 4 |
160440 | 160440 | 2020-05-20 | Union | Arkansas | 5139 | 121 | 4 |
157414 | 157414 | 2020-05-19 | Union | Arkansas | 5139 | 117 | 4 |
154398 | 154398 | 2020-05-18 | Union | Arkansas | 5139 | 107 | 4 |
151386 | 151386 | 2020-05-17 | Union | Arkansas | 5139 | 107 | 4 |
148377 | 148377 | 2020-05-16 | Union | Arkansas | 5139 | 107 | 4 |
145373 | 145373 | 2020-05-15 | Union | Arkansas | 5139 | 105 | 4 |
142374 | 142374 | 2020-05-14 | Union | Arkansas | 5139 | 105 | 4 |
139378 | 139378 | 2020-05-13 | Union | Arkansas | 5139 | 84 | 4 |
136387 | 136387 | 2020-05-12 | Union | Arkansas | 5139 | 80 | 4 |
133397 | 133397 | 2020-05-11 | Union | Arkansas | 5139 | 76 | 4 |
130407 | 130407 | 2020-05-10 | Union | Arkansas | 5139 | 76 | 2 |
127417 | 127417 | 2020-05-09 | Union | Arkansas | 5139 | 73 | 1 |
124432 | 124432 | 2020-05-08 | Union | Arkansas | 5139 | 73 | 1 |
121452 | 121452 | 2020-05-07 | Union | Arkansas | 5139 | 73 | 1 |
118485 | 118485 | 2020-05-06 | Union | Arkansas | 5139 | 67 | 1 |
115526 | 115526 | 2020-05-05 | Union | Arkansas | 5139 | 62 | 0 |
112643 | 112643 | 2020-05-04 | Union | Arkansas | 5139 | 62 | 0 |
109768 | 109768 | 2020-05-03 | Union | Arkansas | 5139 | 60 | 0 |
106899 | 106899 | 2020-05-02 | Union | Arkansas | 5139 | 54 | 0 |
104034 | 104034 | 2020-05-01 | Union | Arkansas | 5139 | 54 | 0 |
101179 | 101179 | 2020-04-30 | Union | Arkansas | 5139 | 50 | 0 |
98329 | 98329 | 2020-04-29 | Union | Arkansas | 5139 | 45 | 0 |
95484 | 95484 | 2020-04-28 | Union | Arkansas | 5139 | 43 | 0 |
92653 | 92653 | 2020-04-27 | Union | Arkansas | 5139 | 38 | 0 |
89835 | 89835 | 2020-04-26 | Union | Arkansas | 5139 | 33 | 0 |
87018 | 87018 | 2020-04-25 | Union | Arkansas | 5139 | 32 | 0 |
84210 | 84210 | 2020-04-24 | Union | Arkansas | 5139 | 30 | 0 |
81410 | 81410 | 2020-04-23 | Union | Arkansas | 5139 | 29 | 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);