ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Union" and fips = 22111 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387108 | 387108 | 2020-07-31 | Union | Louisiana | 22111 | 596 | 32 |
383890 | 383890 | 2020-07-30 | Union | Louisiana | 22111 | 573 | 32 |
380673 | 380673 | 2020-07-29 | Union | Louisiana | 22111 | 561 | 31 |
377456 | 377456 | 2020-07-28 | Union | Louisiana | 22111 | 551 | 31 |
374241 | 374241 | 2020-07-27 | Union | Louisiana | 22111 | 547 | 31 |
371029 | 371029 | 2020-07-26 | Union | Louisiana | 22111 | 543 | 31 |
367819 | 367819 | 2020-07-25 | Union | Louisiana | 22111 | 533 | 31 |
364612 | 364612 | 2020-07-24 | Union | Louisiana | 22111 | 533 | 31 |
361405 | 361405 | 2020-07-23 | Union | Louisiana | 22111 | 525 | 31 |
358200 | 358200 | 2020-07-22 | Union | Louisiana | 22111 | 519 | 30 |
354997 | 354997 | 2020-07-21 | Union | Louisiana | 22111 | 511 | 30 |
351795 | 351795 | 2020-07-20 | Union | Louisiana | 22111 | 506 | 30 |
348595 | 348595 | 2020-07-19 | Union | Louisiana | 22111 | 499 | 30 |
345394 | 345394 | 2020-07-18 | Union | Louisiana | 22111 | 495 | 30 |
342194 | 342194 | 2020-07-17 | Union | Louisiana | 22111 | 495 | 30 |
338998 | 338998 | 2020-07-16 | Union | Louisiana | 22111 | 491 | 30 |
335802 | 335802 | 2020-07-15 | Union | Louisiana | 22111 | 488 | 29 |
332609 | 332609 | 2020-07-14 | Union | Louisiana | 22111 | 483 | 28 |
329422 | 329422 | 2020-07-13 | Union | Louisiana | 22111 | 478 | 28 |
326236 | 326236 | 2020-07-12 | Union | Louisiana | 22111 | 476 | 28 |
323053 | 323053 | 2020-07-11 | Union | Louisiana | 22111 | 474 | 28 |
319874 | 319874 | 2020-07-10 | Union | Louisiana | 22111 | 471 | 27 |
316699 | 316699 | 2020-07-09 | Union | Louisiana | 22111 | 463 | 27 |
313525 | 313525 | 2020-07-08 | Union | Louisiana | 22111 | 452 | 27 |
310355 | 310355 | 2020-07-07 | Union | Louisiana | 22111 | 447 | 27 |
307187 | 307187 | 2020-07-06 | Union | Louisiana | 22111 | 445 | 26 |
304020 | 304020 | 2020-07-05 | Union | Louisiana | 22111 | 443 | 25 |
300856 | 300856 | 2020-07-04 | Union | Louisiana | 22111 | 441 | 24 |
297694 | 297694 | 2020-07-03 | Union | Louisiana | 22111 | 441 | 24 |
294536 | 294536 | 2020-07-02 | Union | Louisiana | 22111 | 437 | 24 |
291382 | 291382 | 2020-07-01 | Union | Louisiana | 22111 | 433 | 24 |
288231 | 288231 | 2020-06-30 | Union | Louisiana | 22111 | 422 | 24 |
285082 | 285082 | 2020-06-29 | Union | Louisiana | 22111 | 417 | 24 |
281936 | 281936 | 2020-06-28 | Union | Louisiana | 22111 | 412 | 24 |
278788 | 278788 | 2020-06-27 | Union | Louisiana | 22111 | 405 | 24 |
275640 | 275640 | 2020-06-26 | Union | Louisiana | 22111 | 405 | 24 |
272497 | 272497 | 2020-06-25 | Union | Louisiana | 22111 | 398 | 23 |
269361 | 269361 | 2020-06-24 | Union | Louisiana | 22111 | 395 | 23 |
266228 | 266228 | 2020-06-23 | Union | Louisiana | 22111 | 391 | 21 |
263101 | 263101 | 2020-06-22 | Union | Louisiana | 22111 | 378 | 20 |
259972 | 259972 | 2020-06-21 | Union | Louisiana | 22111 | 375 | 20 |
256846 | 256846 | 2020-06-20 | Union | Louisiana | 22111 | 375 | 20 |
253726 | 253726 | 2020-06-19 | Union | Louisiana | 22111 | 372 | 20 |
250611 | 250611 | 2020-06-18 | Union | Louisiana | 22111 | 435 | 20 |
247499 | 247499 | 2020-06-17 | Union | Louisiana | 22111 | 435 | 20 |
244386 | 244386 | 2020-06-16 | Union | Louisiana | 22111 | 422 | 20 |
241275 | 241275 | 2020-06-15 | Union | Louisiana | 22111 | 422 | 20 |
238166 | 238166 | 2020-06-14 | Union | Louisiana | 22111 | 411 | 20 |
235059 | 235059 | 2020-06-13 | Union | Louisiana | 22111 | 409 | 20 |
231954 | 231954 | 2020-06-12 | Union | Louisiana | 22111 | 385 | 20 |
228850 | 228850 | 2020-06-11 | Union | Louisiana | 22111 | 383 | 20 |
225748 | 225748 | 2020-06-10 | Union | Louisiana | 22111 | 375 | 20 |
222652 | 222652 | 2020-06-09 | Union | Louisiana | 22111 | 366 | 20 |
219557 | 219557 | 2020-06-08 | Union | Louisiana | 22111 | 349 | 20 |
216465 | 216465 | 2020-06-07 | Union | Louisiana | 22111 | 348 | 20 |
213378 | 213378 | 2020-06-06 | Union | Louisiana | 22111 | 344 | 20 |
210293 | 210293 | 2020-06-05 | Union | Louisiana | 22111 | 343 | 20 |
207212 | 207212 | 2020-06-04 | Union | Louisiana | 22111 | 333 | 19 |
204131 | 204131 | 2020-06-03 | Union | Louisiana | 22111 | 331 | 19 |
201054 | 201054 | 2020-06-02 | Union | Louisiana | 22111 | 324 | 19 |
197982 | 197982 | 2020-06-01 | Union | Louisiana | 22111 | 324 | 17 |
194911 | 194911 | 2020-05-31 | Union | Louisiana | 22111 | 317 | 17 |
191843 | 191843 | 2020-05-30 | Union | Louisiana | 22111 | 313 | 17 |
188779 | 188779 | 2020-05-29 | Union | Louisiana | 22111 | 306 | 17 |
185721 | 185721 | 2020-05-28 | Union | Louisiana | 22111 | 306 | 17 |
182666 | 182666 | 2020-05-27 | Union | Louisiana | 22111 | 303 | 17 |
179621 | 179621 | 2020-05-26 | Union | Louisiana | 22111 | 295 | 17 |
176577 | 176577 | 2020-05-25 | Union | Louisiana | 22111 | 291 | 16 |
173533 | 173533 | 2020-05-24 | Union | Louisiana | 22111 | 287 | 16 |
170492 | 170492 | 2020-05-23 | Union | Louisiana | 22111 | 287 | 16 |
167454 | 167454 | 2020-05-22 | Union | Louisiana | 22111 | 287 | 16 |
164418 | 164418 | 2020-05-21 | Union | Louisiana | 22111 | 287 | 16 |
161389 | 161389 | 2020-05-20 | Union | Louisiana | 22111 | 245 | 14 |
158363 | 158363 | 2020-05-19 | Union | Louisiana | 22111 | 245 | 15 |
155345 | 155345 | 2020-05-18 | Union | Louisiana | 22111 | 243 | 14 |
152331 | 152331 | 2020-05-17 | Union | Louisiana | 22111 | 242 | 14 |
149320 | 149320 | 2020-05-16 | Union | Louisiana | 22111 | 236 | 14 |
146315 | 146315 | 2020-05-15 | Union | Louisiana | 22111 | 238 | 13 |
143315 | 143315 | 2020-05-14 | Union | Louisiana | 22111 | 231 | 11 |
140320 | 140320 | 2020-05-13 | Union | Louisiana | 22111 | 227 | 11 |
137326 | 137326 | 2020-05-12 | Union | Louisiana | 22111 | 171 | 11 |
134336 | 134336 | 2020-05-11 | Union | Louisiana | 22111 | 169 | 10 |
131345 | 131345 | 2020-05-10 | Union | Louisiana | 22111 | 165 | 9 |
128355 | 128355 | 2020-05-09 | Union | Louisiana | 22111 | 162 | 8 |
125368 | 125368 | 2020-05-08 | Union | Louisiana | 22111 | 153 | 8 |
122386 | 122386 | 2020-05-07 | Union | Louisiana | 22111 | 151 | 8 |
119415 | 119415 | 2020-05-06 | Union | Louisiana | 22111 | 148 | 7 |
116454 | 116454 | 2020-05-05 | Union | Louisiana | 22111 | 144 | 7 |
113572 | 113572 | 2020-05-04 | Union | Louisiana | 22111 | 143 | 7 |
110695 | 110695 | 2020-05-03 | Union | Louisiana | 22111 | 135 | 7 |
107823 | 107823 | 2020-05-02 | Union | Louisiana | 22111 | 131 | 7 |
104959 | 104959 | 2020-05-01 | Union | Louisiana | 22111 | 125 | 6 |
102098 | 102098 | 2020-04-30 | Union | Louisiana | 22111 | 117 | 6 |
99246 | 99246 | 2020-04-29 | Union | Louisiana | 22111 | 114 | 6 |
96400 | 96400 | 2020-04-28 | Union | Louisiana | 22111 | 108 | 6 |
93565 | 93565 | 2020-04-27 | Union | Louisiana | 22111 | 103 | 6 |
90744 | 90744 | 2020-04-26 | Union | Louisiana | 22111 | 102 | 6 |
87928 | 87928 | 2020-04-25 | Union | Louisiana | 22111 | 102 | 6 |
85119 | 85119 | 2020-04-24 | Union | Louisiana | 22111 | 95 | 6 |
82315 | 82315 | 2020-04-23 | Union | Louisiana | 22111 | 89 | 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);