ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,245 rows where county = "Oneida" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
county 1
- Oneida · 2,245 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
287659 | 287659 | 2020-06-30 | Oneida | Idaho | 16071 | 2 | 0 |
290809 | 290809 | 2020-07-01 | Oneida | Idaho | 16071 | 3 | 0 |
293963 | 293963 | 2020-07-02 | Oneida | Idaho | 16071 | 4 | 0 |
297119 | 297119 | 2020-07-03 | Oneida | Idaho | 16071 | 5 | 0 |
300281 | 300281 | 2020-07-04 | Oneida | Idaho | 16071 | 5 | 0 |
303445 | 303445 | 2020-07-05 | Oneida | Idaho | 16071 | 5 | 0 |
306610 | 306610 | 2020-07-06 | Oneida | Idaho | 16071 | 5 | 0 |
309778 | 309778 | 2020-07-07 | Oneida | Idaho | 16071 | 4 | 0 |
312948 | 312948 | 2020-07-08 | Oneida | Idaho | 16071 | 4 | 0 |
316122 | 316122 | 2020-07-09 | Oneida | Idaho | 16071 | 6 | 0 |
319295 | 319295 | 2020-07-10 | Oneida | Idaho | 16071 | 8 | 0 |
322474 | 322474 | 2020-07-11 | Oneida | Idaho | 16071 | 8 | 0 |
325655 | 325655 | 2020-07-12 | Oneida | Idaho | 16071 | 8 | 0 |
328841 | 328841 | 2020-07-13 | Oneida | Idaho | 16071 | 8 | 0 |
332028 | 332028 | 2020-07-14 | Oneida | Idaho | 16071 | 8 | 0 |
335221 | 335221 | 2020-07-15 | Oneida | Idaho | 16071 | 8 | 0 |
338417 | 338417 | 2020-07-16 | Oneida | Idaho | 16071 | 8 | 0 |
341613 | 341613 | 2020-07-17 | Oneida | Idaho | 16071 | 8 | 0 |
344813 | 344813 | 2020-07-18 | Oneida | Idaho | 16071 | 8 | 0 |
348014 | 348014 | 2020-07-19 | Oneida | Idaho | 16071 | 8 | 0 |
351214 | 351214 | 2020-07-20 | Oneida | Idaho | 16071 | 8 | 0 |
354416 | 354416 | 2020-07-21 | Oneida | Idaho | 16071 | 8 | 0 |
357618 | 357618 | 2020-07-22 | Oneida | Idaho | 16071 | 8 | 0 |
360823 | 360823 | 2020-07-23 | Oneida | Idaho | 16071 | 8 | 0 |
364030 | 364030 | 2020-07-24 | Oneida | Idaho | 16071 | 9 | 0 |
367237 | 367237 | 2020-07-25 | Oneida | Idaho | 16071 | 9 | 0 |
370447 | 370447 | 2020-07-26 | Oneida | Idaho | 16071 | 9 | 0 |
373659 | 373659 | 2020-07-27 | Oneida | Idaho | 16071 | 9 | 0 |
376874 | 376874 | 2020-07-28 | Oneida | Idaho | 16071 | 9 | 0 |
380091 | 380091 | 2020-07-29 | Oneida | Idaho | 16071 | 9 | 0 |
383308 | 383308 | 2020-07-30 | Oneida | Idaho | 16071 | 9 | 0 |
386526 | 386526 | 2020-07-31 | Oneida | Idaho | 16071 | 9 | 0 |
389743 | 389743 | 2020-08-01 | Oneida | Idaho | 16071 | 9 | 0 |
392960 | 392960 | 2020-08-02 | Oneida | Idaho | 16071 | 9 | 0 |
396176 | 396176 | 2020-08-03 | Oneida | Idaho | 16071 | 13 | 0 |
399392 | 399392 | 2020-08-04 | Oneida | Idaho | 16071 | 13 | 0 |
402608 | 402608 | 2020-08-05 | Oneida | Idaho | 16071 | 13 | 0 |
405826 | 405826 | 2020-08-06 | Oneida | Idaho | 16071 | 13 | 0 |
409046 | 409046 | 2020-08-07 | Oneida | Idaho | 16071 | 13 | 0 |
412265 | 412265 | 2020-08-08 | Oneida | Idaho | 16071 | 13 | 0 |
415485 | 415485 | 2020-08-09 | Oneida | Idaho | 16071 | 13 | 0 |
418706 | 418706 | 2020-08-10 | Oneida | Idaho | 16071 | 15 | 0 |
421929 | 421929 | 2020-08-11 | Oneida | Idaho | 16071 | 15 | 0 |
425150 | 425150 | 2020-08-12 | Oneida | Idaho | 16071 | 16 | 0 |
428374 | 428374 | 2020-08-13 | Oneida | Idaho | 16071 | 16 | 0 |
431602 | 431602 | 2020-08-14 | Oneida | Idaho | 16071 | 16 | 0 |
434827 | 434827 | 2020-08-15 | Oneida | Idaho | 16071 | 16 | 0 |
438053 | 438053 | 2020-08-16 | Oneida | Idaho | 16071 | 16 | 0 |
441279 | 441279 | 2020-08-17 | Oneida | Idaho | 16071 | 17 | 0 |
444505 | 444505 | 2020-08-18 | Oneida | Idaho | 16071 | 18 | 0 |
447732 | 447732 | 2020-08-19 | Oneida | Idaho | 16071 | 18 | 0 |
450960 | 450960 | 2020-08-20 | Oneida | Idaho | 16071 | 18 | 0 |
454188 | 454188 | 2020-08-21 | Oneida | Idaho | 16071 | 18 | 0 |
457416 | 457416 | 2020-08-22 | Oneida | Idaho | 16071 | 18 | 0 |
460643 | 460643 | 2020-08-23 | Oneida | Idaho | 16071 | 18 | 0 |
463872 | 463872 | 2020-08-24 | Oneida | Idaho | 16071 | 18 | 0 |
467101 | 467101 | 2020-08-25 | Oneida | Idaho | 16071 | 20 | 0 |
470330 | 470330 | 2020-08-26 | Oneida | Idaho | 16071 | 20 | 0 |
473562 | 473562 | 2020-08-27 | Oneida | Idaho | 16071 | 21 | 0 |
476795 | 476795 | 2020-08-28 | Oneida | Idaho | 16071 | 21 | 0 |
480028 | 480028 | 2020-08-29 | Oneida | Idaho | 16071 | 21 | 0 |
483262 | 483262 | 2020-08-30 | Oneida | Idaho | 16071 | 21 | 0 |
486497 | 486497 | 2020-08-31 | Oneida | Idaho | 16071 | 22 | 0 |
489730 | 489730 | 2020-09-01 | Oneida | Idaho | 16071 | 22 | 0 |
492963 | 492963 | 2020-09-02 | Oneida | Idaho | 16071 | 22 | 0 |
496197 | 496197 | 2020-09-03 | Oneida | Idaho | 16071 | 22 | 0 |
499430 | 499430 | 2020-09-04 | Oneida | Idaho | 16071 | 22 | 0 |
502664 | 502664 | 2020-09-05 | Oneida | Idaho | 16071 | 22 | 0 |
505898 | 505898 | 2020-09-06 | Oneida | Idaho | 16071 | 22 | 0 |
509130 | 509130 | 2020-09-07 | Oneida | Idaho | 16071 | 22 | 0 |
512363 | 512363 | 2020-09-08 | Oneida | Idaho | 16071 | 22 | 0 |
515596 | 515596 | 2020-09-09 | Oneida | Idaho | 16071 | 22 | 0 |
518831 | 518831 | 2020-09-10 | Oneida | Idaho | 16071 | 22 | 0 |
522068 | 522068 | 2020-09-11 | Oneida | Idaho | 16071 | 22 | 0 |
525304 | 525304 | 2020-09-12 | Oneida | Idaho | 16071 | 22 | 0 |
528540 | 528540 | 2020-09-13 | Oneida | Idaho | 16071 | 22 | 0 |
531777 | 531777 | 2020-09-14 | Oneida | Idaho | 16071 | 22 | 0 |
535012 | 535012 | 2020-09-15 | Oneida | Idaho | 16071 | 22 | 0 |
538248 | 538248 | 2020-09-16 | Oneida | Idaho | 16071 | 22 | 0 |
541485 | 541485 | 2020-09-17 | Oneida | Idaho | 16071 | 22 | 0 |
544721 | 544721 | 2020-09-18 | Oneida | Idaho | 16071 | 23 | 0 |
547959 | 547959 | 2020-09-19 | Oneida | Idaho | 16071 | 23 | 0 |
551198 | 551198 | 2020-09-20 | Oneida | Idaho | 16071 | 23 | 0 |
554437 | 554437 | 2020-09-21 | Oneida | Idaho | 16071 | 23 | 0 |
557674 | 557674 | 2020-09-22 | Oneida | Idaho | 16071 | 23 | 0 |
560910 | 560910 | 2020-09-23 | Oneida | Idaho | 16071 | 24 | 0 |
564150 | 564150 | 2020-09-24 | Oneida | Idaho | 16071 | 24 | 0 |
567390 | 567390 | 2020-09-25 | Oneida | Idaho | 16071 | 26 | 0 |
570632 | 570632 | 2020-09-26 | Oneida | Idaho | 16071 | 27 | 0 |
573874 | 573874 | 2020-09-27 | Oneida | Idaho | 16071 | 27 | 0 |
577117 | 577117 | 2020-09-28 | Oneida | Idaho | 16071 | 27 | 0 |
580358 | 580358 | 2020-09-29 | Oneida | Idaho | 16071 | 28 | 0 |
583597 | 583597 | 2020-09-30 | Oneida | Idaho | 16071 | 28 | 0 |
586837 | 586837 | 2020-10-01 | Oneida | Idaho | 16071 | 28 | 0 |
590078 | 590078 | 2020-10-02 | Oneida | Idaho | 16071 | 29 | 0 |
593318 | 593318 | 2020-10-03 | Oneida | Idaho | 16071 | 29 | 0 |
596560 | 596560 | 2020-10-04 | Oneida | Idaho | 16071 | 29 | 0 |
599803 | 599803 | 2020-10-05 | Oneida | Idaho | 16071 | 29 | 0 |
603046 | 603046 | 2020-10-06 | Oneida | Idaho | 16071 | 30 | 0 |
606288 | 606288 | 2020-10-07 | Oneida | Idaho | 16071 | 31 | 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);