ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,794 rows where county = "Blaine" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
county 1
- Blaine · 2,794 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
114441 | 114441 | 2020-05-04 | Blaine | Oklahoma | 40011 | 1 | 0 |
141198 | 141198 | 2020-05-13 | Blaine | Oklahoma | 40011 | 1 | 0 |
144193 | 144193 | 2020-05-14 | Blaine | Oklahoma | 40011 | 1 | 0 |
339437 | 339437 | 2020-07-16 | Blaine | Montana | 30005 | 1 | 0 |
568471 | 568471 | 2020-09-25 | Blaine | Nebraska | 31009 | 1 | 0 |
571713 | 571713 | 2020-09-26 | Blaine | Nebraska | 31009 | 1 | 0 |
574956 | 574956 | 2020-09-27 | Blaine | Nebraska | 31009 | 1 | 0 |
578197 | 578197 | 2020-09-28 | Blaine | Nebraska | 31009 | 1 | 0 |
581438 | 581438 | 2020-09-29 | Blaine | Nebraska | 31009 | 1 | 0 |
584679 | 584679 | 2020-09-30 | Blaine | Nebraska | 31009 | 1 | 0 |
587919 | 587919 | 2020-10-01 | Blaine | Nebraska | 31009 | 1 | 0 |
591160 | 591160 | 2020-10-02 | Blaine | Nebraska | 31009 | 1 | 0 |
594401 | 594401 | 2020-10-03 | Blaine | Nebraska | 31009 | 1 | 0 |
597642 | 597642 | 2020-10-04 | Blaine | Nebraska | 31009 | 1 | 0 |
600886 | 600886 | 2020-10-05 | Blaine | Nebraska | 31009 | 1 | 0 |
604128 | 604128 | 2020-10-06 | Blaine | Nebraska | 31009 | 1 | 0 |
607371 | 607371 | 2020-10-07 | Blaine | Nebraska | 31009 | 1 | 0 |
610613 | 610613 | 2020-10-08 | Blaine | Nebraska | 31009 | 1 | 0 |
613855 | 613855 | 2020-10-09 | Blaine | Nebraska | 31009 | 1 | 0 |
617096 | 617096 | 2020-10-10 | Blaine | Nebraska | 31009 | 1 | 0 |
620338 | 620338 | 2020-10-11 | Blaine | Nebraska | 31009 | 1 | 0 |
2038 | 2038 | 2020-03-14 | Blaine | Idaho | 16013 | 2 | 0 |
2428 | 2428 | 2020-03-15 | Blaine | Idaho | 16013 | 2 | 0 |
2869 | 2869 | 2020-03-16 | Blaine | Idaho | 16013 | 2 | 0 |
117322 | 117322 | 2020-05-05 | Blaine | Oklahoma | 40011 | 2 | 0 |
120283 | 120283 | 2020-05-06 | Blaine | Oklahoma | 40011 | 2 | 0 |
123260 | 123260 | 2020-05-07 | Blaine | Oklahoma | 40011 | 2 | 0 |
126243 | 126243 | 2020-05-08 | Blaine | Oklahoma | 40011 | 2 | 0 |
129232 | 129232 | 2020-05-09 | Blaine | Oklahoma | 40011 | 2 | 0 |
138202 | 138202 | 2020-05-12 | Blaine | Oklahoma | 40011 | 2 | 0 |
147194 | 147194 | 2020-05-15 | Blaine | Oklahoma | 40011 | 2 | 0 |
623581 | 623581 | 2020-10-12 | Blaine | Nebraska | 31009 | 2 | 0 |
649542 | 649542 | 2020-10-20 | Blaine | Nebraska | 31009 | 2 | 0 |
652787 | 652787 | 2020-10-21 | Blaine | Nebraska | 31009 | 2 | 0 |
656032 | 656032 | 2020-10-22 | Blaine | Nebraska | 31009 | 2 | 0 |
659277 | 659277 | 2020-10-23 | Blaine | Nebraska | 31009 | 2 | 0 |
662521 | 662521 | 2020-10-24 | Blaine | Nebraska | 31009 | 2 | 0 |
665766 | 665766 | 2020-10-25 | Blaine | Nebraska | 31009 | 2 | 0 |
669010 | 669010 | 2020-10-26 | Blaine | Nebraska | 31009 | 2 | 0 |
672252 | 672252 | 2020-10-27 | Blaine | Nebraska | 31009 | 2 | 0 |
675495 | 675495 | 2020-10-28 | Blaine | Nebraska | 31009 | 2 | 0 |
678737 | 678737 | 2020-10-29 | Blaine | Nebraska | 31009 | 2 | 0 |
132221 | 132221 | 2020-05-10 | Blaine | Oklahoma | 40011 | 3 | 0 |
135212 | 135212 | 2020-05-11 | Blaine | Oklahoma | 40011 | 3 | 0 |
150201 | 150201 | 2020-05-16 | Blaine | Oklahoma | 40011 | 3 | 0 |
153212 | 153212 | 2020-05-17 | Blaine | Oklahoma | 40011 | 3 | 0 |
156229 | 156229 | 2020-05-18 | Blaine | Oklahoma | 40011 | 3 | 0 |
159249 | 159249 | 2020-05-19 | Blaine | Oklahoma | 40011 | 3 | 0 |
162276 | 162276 | 2020-05-20 | Blaine | Oklahoma | 40011 | 3 | 0 |
626823 | 626823 | 2020-10-13 | Blaine | Nebraska | 31009 | 3 | 0 |
630067 | 630067 | 2020-10-14 | Blaine | Nebraska | 31009 | 3 | 0 |
633312 | 633312 | 2020-10-15 | Blaine | Nebraska | 31009 | 3 | 0 |
636558 | 636558 | 2020-10-16 | Blaine | Nebraska | 31009 | 3 | 0 |
639804 | 639804 | 2020-10-17 | Blaine | Nebraska | 31009 | 3 | 0 |
643052 | 643052 | 2020-10-18 | Blaine | Nebraska | 31009 | 3 | 0 |
646298 | 646298 | 2020-10-19 | Blaine | Nebraska | 31009 | 3 | 0 |
681981 | 681981 | 2020-10-30 | Blaine | Nebraska | 31009 | 3 | 0 |
685224 | 685224 | 2020-10-31 | Blaine | Nebraska | 31009 | 3 | 0 |
3357 | 3357 | 2020-03-17 | Blaine | Idaho | 16013 | 4 | 0 |
165305 | 165305 | 2020-05-21 | Blaine | Oklahoma | 40011 | 4 | 0 |
168341 | 168341 | 2020-05-22 | Blaine | Oklahoma | 40011 | 4 | 0 |
171380 | 171380 | 2020-05-23 | Blaine | Oklahoma | 40011 | 4 | 0 |
174422 | 174422 | 2020-05-24 | Blaine | Oklahoma | 40011 | 4 | 0 |
342633 | 342633 | 2020-07-17 | Blaine | Montana | 30005 | 4 | 0 |
345833 | 345833 | 2020-07-18 | Blaine | Montana | 30005 | 4 | 0 |
349034 | 349034 | 2020-07-19 | Blaine | Montana | 30005 | 4 | 0 |
352234 | 352234 | 2020-07-20 | Blaine | Montana | 30005 | 4 | 0 |
688468 | 688468 | 2020-11-01 | Blaine | Nebraska | 31009 | 4 | 0 |
691713 | 691713 | 2020-11-02 | Blaine | Nebraska | 31009 | 4 | 0 |
694955 | 694955 | 2020-11-03 | Blaine | Nebraska | 31009 | 4 | 0 |
698198 | 698198 | 2020-11-04 | Blaine | Nebraska | 31009 | 4 | 0 |
701442 | 701442 | 2020-11-05 | Blaine | Nebraska | 31009 | 4 | 0 |
3919 | 3919 | 2020-03-18 | Blaine | Idaho | 16013 | 5 | 0 |
177466 | 177466 | 2020-05-25 | Blaine | Oklahoma | 40011 | 5 | 0 |
704684 | 704684 | 2020-11-06 | Blaine | Nebraska | 31009 | 5 | 0 |
180509 | 180509 | 2020-05-26 | Blaine | Oklahoma | 40011 | 6 | 0 |
183558 | 183558 | 2020-05-27 | Blaine | Oklahoma | 40011 | 6 | 0 |
186615 | 186615 | 2020-05-28 | Blaine | Oklahoma | 40011 | 6 | 0 |
189675 | 189675 | 2020-05-29 | Blaine | Oklahoma | 40011 | 6 | 0 |
192740 | 192740 | 2020-05-30 | Blaine | Oklahoma | 40011 | 6 | 0 |
195809 | 195809 | 2020-05-31 | Blaine | Oklahoma | 40011 | 6 | 0 |
355436 | 355436 | 2020-07-21 | Blaine | Montana | 30005 | 6 | 0 |
358639 | 358639 | 2020-07-22 | Blaine | Montana | 30005 | 6 | 0 |
707927 | 707927 | 2020-11-07 | Blaine | Nebraska | 31009 | 6 | 0 |
198882 | 198882 | 2020-06-01 | Blaine | Oklahoma | 40011 | 7 | 0 |
201957 | 201957 | 2020-06-02 | Blaine | Oklahoma | 40011 | 7 | 0 |
361844 | 361844 | 2020-07-23 | Blaine | Montana | 30005 | 7 | 0 |
365051 | 365051 | 2020-07-24 | Blaine | Montana | 30005 | 7 | 0 |
368259 | 368259 | 2020-07-25 | Blaine | Montana | 30005 | 7 | 0 |
371470 | 371470 | 2020-07-26 | Blaine | Montana | 30005 | 7 | 0 |
374682 | 374682 | 2020-07-27 | Blaine | Montana | 30005 | 7 | 0 |
377897 | 377897 | 2020-07-28 | Blaine | Montana | 30005 | 7 | 0 |
381114 | 381114 | 2020-07-29 | Blaine | Montana | 30005 | 7 | 0 |
384330 | 384330 | 2020-07-30 | Blaine | Montana | 30005 | 7 | 0 |
387548 | 387548 | 2020-07-31 | Blaine | Montana | 30005 | 7 | 0 |
711171 | 711171 | 2020-11-08 | Blaine | Nebraska | 31009 | 7 | 0 |
205034 | 205034 | 2020-06-03 | Blaine | Oklahoma | 40011 | 8 | 0 |
208115 | 208115 | 2020-06-04 | Blaine | Oklahoma | 40011 | 8 | 0 |
390765 | 390765 | 2020-08-01 | Blaine | Montana | 30005 | 8 | 0 |
714415 | 714415 | 2020-11-09 | Blaine | Nebraska | 31009 | 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);