ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Buffalo" and state = "Nebraska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536095 | 536095 | 2020-09-15 | Buffalo | Nebraska | 31019 | 892 | 4 |
532860 | 532860 | 2020-09-14 | Buffalo | Nebraska | 31019 | 883 | 4 |
529624 | 529624 | 2020-09-13 | Buffalo | Nebraska | 31019 | 867 | 3 |
526388 | 526388 | 2020-09-12 | Buffalo | Nebraska | 31019 | 858 | 3 |
523152 | 523152 | 2020-09-11 | Buffalo | Nebraska | 31019 | 850 | 3 |
519915 | 519915 | 2020-09-10 | Buffalo | Nebraska | 31019 | 818 | 3 |
516680 | 516680 | 2020-09-09 | Buffalo | Nebraska | 31019 | 796 | 3 |
513446 | 513446 | 2020-09-08 | Buffalo | Nebraska | 31019 | 784 | 3 |
510214 | 510214 | 2020-09-07 | Buffalo | Nebraska | 31019 | 764 | 3 |
506981 | 506981 | 2020-09-06 | Buffalo | Nebraska | 31019 | 759 | 3 |
503748 | 503748 | 2020-09-05 | Buffalo | Nebraska | 31019 | 750 | 3 |
500514 | 500514 | 2020-09-04 | Buffalo | Nebraska | 31019 | 740 | 3 |
497280 | 497280 | 2020-09-03 | Buffalo | Nebraska | 31019 | 732 | 3 |
494047 | 494047 | 2020-09-02 | Buffalo | Nebraska | 31019 | 713 | 3 |
490813 | 490813 | 2020-09-01 | Buffalo | Nebraska | 31019 | 697 | 3 |
487580 | 487580 | 2020-08-31 | Buffalo | Nebraska | 31019 | 682 | 3 |
484346 | 484346 | 2020-08-30 | Buffalo | Nebraska | 31019 | 676 | 3 |
481111 | 481111 | 2020-08-29 | Buffalo | Nebraska | 31019 | 664 | 3 |
477879 | 477879 | 2020-08-28 | Buffalo | Nebraska | 31019 | 654 | 3 |
474646 | 474646 | 2020-08-27 | Buffalo | Nebraska | 31019 | 632 | 3 |
471414 | 471414 | 2020-08-26 | Buffalo | Nebraska | 31019 | 612 | 3 |
468184 | 468184 | 2020-08-25 | Buffalo | Nebraska | 31019 | 591 | 3 |
464955 | 464955 | 2020-08-24 | Buffalo | Nebraska | 31019 | 582 | 3 |
461724 | 461724 | 2020-08-23 | Buffalo | Nebraska | 31019 | 573 | 3 |
458497 | 458497 | 2020-08-22 | Buffalo | Nebraska | 31019 | 566 | 2 |
455269 | 455269 | 2020-08-21 | Buffalo | Nebraska | 31019 | 554 | 2 |
452041 | 452041 | 2020-08-20 | Buffalo | Nebraska | 31019 | 544 | 1 |
448813 | 448813 | 2020-08-19 | Buffalo | Nebraska | 31019 | 535 | 1 |
445587 | 445587 | 2020-08-18 | Buffalo | Nebraska | 31019 | 480 | 1 |
442361 | 442361 | 2020-08-17 | Buffalo | Nebraska | 31019 | 512 | 1 |
439134 | 439134 | 2020-08-16 | Buffalo | Nebraska | 31019 | 500 | 1 |
435909 | 435909 | 2020-08-15 | Buffalo | Nebraska | 31019 | 494 | 1 |
432683 | 432683 | 2020-08-14 | Buffalo | Nebraska | 31019 | 481 | 1 |
429456 | 429456 | 2020-08-13 | Buffalo | Nebraska | 31019 | 462 | 1 |
426231 | 426231 | 2020-08-12 | Buffalo | Nebraska | 31019 | 456 | 1 |
423009 | 423009 | 2020-08-11 | Buffalo | Nebraska | 31019 | 449 | 1 |
419786 | 419786 | 2020-08-10 | Buffalo | Nebraska | 31019 | 435 | 1 |
416565 | 416565 | 2020-08-09 | Buffalo | Nebraska | 31019 | 415 | 1 |
413345 | 413345 | 2020-08-08 | Buffalo | Nebraska | 31019 | 406 | 1 |
410125 | 410125 | 2020-08-07 | Buffalo | Nebraska | 31019 | 401 | 1 |
406905 | 406905 | 2020-08-06 | Buffalo | Nebraska | 31019 | 385 | 1 |
403686 | 403686 | 2020-08-05 | Buffalo | Nebraska | 31019 | 376 | 1 |
400468 | 400468 | 2020-08-04 | Buffalo | Nebraska | 31019 | 360 | 1 |
397253 | 397253 | 2020-08-03 | Buffalo | Nebraska | 31019 | 357 | 1 |
394037 | 394037 | 2020-08-02 | Buffalo | Nebraska | 31019 | 347 | 1 |
390820 | 390820 | 2020-08-01 | Buffalo | Nebraska | 31019 | 333 | 1 |
387603 | 387603 | 2020-07-31 | Buffalo | Nebraska | 31019 | 329 | 1 |
384385 | 384385 | 2020-07-30 | Buffalo | Nebraska | 31019 | 319 | 1 |
381169 | 381169 | 2020-07-29 | Buffalo | Nebraska | 31019 | 305 | 1 |
377951 | 377951 | 2020-07-28 | Buffalo | Nebraska | 31019 | 293 | 1 |
374736 | 374736 | 2020-07-27 | Buffalo | Nebraska | 31019 | 287 | 1 |
371524 | 371524 | 2020-07-26 | Buffalo | Nebraska | 31019 | 280 | 1 |
368313 | 368313 | 2020-07-25 | Buffalo | Nebraska | 31019 | 273 | 1 |
365104 | 365104 | 2020-07-24 | Buffalo | Nebraska | 31019 | 268 | 1 |
361897 | 361897 | 2020-07-23 | Buffalo | Nebraska | 31019 | 261 | 1 |
358691 | 358691 | 2020-07-22 | Buffalo | Nebraska | 31019 | 253 | 1 |
355487 | 355487 | 2020-07-21 | Buffalo | Nebraska | 31019 | 242 | 1 |
352284 | 352284 | 2020-07-20 | Buffalo | Nebraska | 31019 | 237 | 1 |
349083 | 349083 | 2020-07-19 | Buffalo | Nebraska | 31019 | 233 | 1 |
345882 | 345882 | 2020-07-18 | Buffalo | Nebraska | 31019 | 230 | 1 |
342682 | 342682 | 2020-07-17 | Buffalo | Nebraska | 31019 | 230 | 1 |
339486 | 339486 | 2020-07-16 | Buffalo | Nebraska | 31019 | 225 | 1 |
336289 | 336289 | 2020-07-15 | Buffalo | Nebraska | 31019 | 221 | 1 |
333095 | 333095 | 2020-07-14 | Buffalo | Nebraska | 31019 | 218 | 1 |
329906 | 329906 | 2020-07-13 | Buffalo | Nebraska | 31019 | 217 | 1 |
326719 | 326719 | 2020-07-12 | Buffalo | Nebraska | 31019 | 212 | 1 |
323535 | 323535 | 2020-07-11 | Buffalo | Nebraska | 31019 | 206 | 1 |
320356 | 320356 | 2020-07-10 | Buffalo | Nebraska | 31019 | 205 | 1 |
317181 | 317181 | 2020-07-09 | Buffalo | Nebraska | 31019 | 202 | 1 |
314007 | 314007 | 2020-07-08 | Buffalo | Nebraska | 31019 | 198 | 1 |
310836 | 310836 | 2020-07-07 | Buffalo | Nebraska | 31019 | 196 | 1 |
307668 | 307668 | 2020-07-06 | Buffalo | Nebraska | 31019 | 194 | 1 |
304501 | 304501 | 2020-07-05 | Buffalo | Nebraska | 31019 | 194 | 1 |
301337 | 301337 | 2020-07-04 | Buffalo | Nebraska | 31019 | 195 | 1 |
298174 | 298174 | 2020-07-03 | Buffalo | Nebraska | 31019 | 192 | 1 |
295015 | 295015 | 2020-07-02 | Buffalo | Nebraska | 31019 | 187 | 1 |
291860 | 291860 | 2020-07-01 | Buffalo | Nebraska | 31019 | 189 | 1 |
288709 | 288709 | 2020-06-30 | Buffalo | Nebraska | 31019 | 184 | 1 |
285559 | 285559 | 2020-06-29 | Buffalo | Nebraska | 31019 | 184 | 1 |
282414 | 282414 | 2020-06-28 | Buffalo | Nebraska | 31019 | 183 | 1 |
279266 | 279266 | 2020-06-27 | Buffalo | Nebraska | 31019 | 183 | 1 |
276118 | 276118 | 2020-06-26 | Buffalo | Nebraska | 31019 | 182 | 1 |
272975 | 272975 | 2020-06-25 | Buffalo | Nebraska | 31019 | 181 | 1 |
269836 | 269836 | 2020-06-24 | Buffalo | Nebraska | 31019 | 181 | 1 |
266702 | 266702 | 2020-06-23 | Buffalo | Nebraska | 31019 | 181 | 1 |
263576 | 263576 | 2020-06-22 | Buffalo | Nebraska | 31019 | 180 | 1 |
260447 | 260447 | 2020-06-21 | Buffalo | Nebraska | 31019 | 179 | 1 |
257321 | 257321 | 2020-06-20 | Buffalo | Nebraska | 31019 | 179 | 1 |
254198 | 254198 | 2020-06-19 | Buffalo | Nebraska | 31019 | 178 | 1 |
251083 | 251083 | 2020-06-18 | Buffalo | Nebraska | 31019 | 177 | 1 |
247968 | 247968 | 2020-06-17 | Buffalo | Nebraska | 31019 | 176 | 1 |
244855 | 244855 | 2020-06-16 | Buffalo | Nebraska | 31019 | 176 | 1 |
241744 | 241744 | 2020-06-15 | Buffalo | Nebraska | 31019 | 176 | 1 |
238634 | 238634 | 2020-06-14 | Buffalo | Nebraska | 31019 | 177 | 1 |
235527 | 235527 | 2020-06-13 | Buffalo | Nebraska | 31019 | 177 | 1 |
232421 | 232421 | 2020-06-12 | Buffalo | Nebraska | 31019 | 177 | 1 |
229316 | 229316 | 2020-06-11 | Buffalo | Nebraska | 31019 | 177 | 1 |
226213 | 226213 | 2020-06-10 | Buffalo | Nebraska | 31019 | 175 | 1 |
223114 | 223114 | 2020-06-09 | Buffalo | Nebraska | 31019 | 175 | 1 |
220018 | 220018 | 2020-06-08 | Buffalo | Nebraska | 31019 | 174 | 1 |
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);