ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "McKinley" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282551 | 282551 | 2020-06-28 | McKinley | New Mexico | 35031 | 3336 | 166 |
285696 | 285696 | 2020-06-29 | McKinley | New Mexico | 35031 | 3347 | 166 |
288846 | 288846 | 2020-06-30 | McKinley | New Mexico | 35031 | 3375 | 168 |
291998 | 291998 | 2020-07-01 | McKinley | New Mexico | 35031 | 3395 | 170 |
295153 | 295153 | 2020-07-02 | McKinley | New Mexico | 35031 | 3408 | 172 |
298313 | 298313 | 2020-07-03 | McKinley | New Mexico | 35031 | 3450 | 177 |
301476 | 301476 | 2020-07-04 | McKinley | New Mexico | 35031 | 3483 | 179 |
304639 | 304639 | 2020-07-05 | McKinley | New Mexico | 35031 | 3502 | 179 |
307806 | 307806 | 2020-07-06 | McKinley | New Mexico | 35031 | 3514 | 179 |
310974 | 310974 | 2020-07-07 | McKinley | New Mexico | 35031 | 3525 | 181 |
314145 | 314145 | 2020-07-08 | McKinley | New Mexico | 35031 | 3548 | 184 |
317319 | 317319 | 2020-07-09 | McKinley | New Mexico | 35031 | 3567 | 186 |
320495 | 320495 | 2020-07-10 | McKinley | New Mexico | 35031 | 3600 | 188 |
323675 | 323675 | 2020-07-11 | McKinley | New Mexico | 35031 | 3614 | 190 |
326859 | 326859 | 2020-07-12 | McKinley | New Mexico | 35031 | 3634 | 190 |
330046 | 330046 | 2020-07-13 | McKinley | New Mexico | 35031 | 3657 | 191 |
333236 | 333236 | 2020-07-14 | McKinley | New Mexico | 35031 | 3679 | 192 |
336430 | 336430 | 2020-07-15 | McKinley | New Mexico | 35031 | 3689 | 194 |
339626 | 339626 | 2020-07-16 | McKinley | New Mexico | 35031 | 3709 | 196 |
342824 | 342824 | 2020-07-17 | McKinley | New Mexico | 35031 | 3724 | 198 |
346023 | 346023 | 2020-07-18 | McKinley | New Mexico | 35031 | 3743 | 198 |
349224 | 349224 | 2020-07-19 | McKinley | New Mexico | 35031 | 3754 | 199 |
352427 | 352427 | 2020-07-20 | McKinley | New Mexico | 35031 | 3767 | 202 |
355630 | 355630 | 2020-07-21 | McKinley | New Mexico | 35031 | 3783 | 206 |
358834 | 358834 | 2020-07-22 | McKinley | New Mexico | 35031 | 3818 | 208 |
362040 | 362040 | 2020-07-23 | McKinley | New Mexico | 35031 | 3844 | 209 |
365246 | 365246 | 2020-07-24 | McKinley | New Mexico | 35031 | 3868 | 209 |
368455 | 368455 | 2020-07-25 | McKinley | New Mexico | 35031 | 3896 | 210 |
371667 | 371667 | 2020-07-26 | McKinley | New Mexico | 35031 | 3909 | 214 |
374879 | 374879 | 2020-07-27 | McKinley | New Mexico | 35031 | 3921 | 215 |
378094 | 378094 | 2020-07-28 | McKinley | New Mexico | 35031 | 3934 | 216 |
381312 | 381312 | 2020-07-29 | McKinley | New Mexico | 35031 | 3942 | 217 |
384530 | 384530 | 2020-07-30 | McKinley | New Mexico | 35031 | 3977 | 219 |
387747 | 387747 | 2020-07-31 | McKinley | New Mexico | 35031 | 3988 | 219 |
390963 | 390963 | 2020-08-01 | McKinley | New Mexico | 35031 | 3999 | 220 |
394180 | 394180 | 2020-08-02 | McKinley | New Mexico | 35031 | 4002 | 221 |
397397 | 397397 | 2020-08-03 | McKinley | New Mexico | 35031 | 4004 | 221 |
400612 | 400612 | 2020-08-04 | McKinley | New Mexico | 35031 | 4009 | 222 |
403830 | 403830 | 2020-08-05 | McKinley | New Mexico | 35031 | 4025 | 222 |
407049 | 407049 | 2020-08-06 | McKinley | New Mexico | 35031 | 4033 | 222 |
410269 | 410269 | 2020-08-07 | McKinley | New Mexico | 35031 | 4037 | 222 |
413489 | 413489 | 2020-08-08 | McKinley | New Mexico | 35031 | 4043 | 224 |
416710 | 416710 | 2020-08-09 | McKinley | New Mexico | 35031 | 4046 | 225 |
419930 | 419930 | 2020-08-10 | McKinley | New Mexico | 35031 | 4057 | 226 |
423153 | 423153 | 2020-08-11 | McKinley | New Mexico | 35031 | 4067 | 227 |
426376 | 426376 | 2020-08-12 | McKinley | New Mexico | 35031 | 4077 | 229 |
429600 | 429600 | 2020-08-13 | McKinley | New Mexico | 35031 | 4087 | 230 |
432827 | 432827 | 2020-08-14 | McKinley | New Mexico | 35031 | 4104 | 232 |
436053 | 436053 | 2020-08-15 | McKinley | New Mexico | 35031 | 4120 | 232 |
439278 | 439278 | 2020-08-16 | McKinley | New Mexico | 35031 | 4121 | 233 |
442505 | 442505 | 2020-08-17 | McKinley | New Mexico | 35031 | 4125 | 233 |
445731 | 445731 | 2020-08-18 | McKinley | New Mexico | 35031 | 4131 | 234 |
448958 | 448958 | 2020-08-19 | McKinley | New Mexico | 35031 | 4134 | 235 |
452187 | 452187 | 2020-08-20 | McKinley | New Mexico | 35031 | 4141 | 236 |
455415 | 455415 | 2020-08-21 | McKinley | New Mexico | 35031 | 4148 | 237 |
458642 | 458642 | 2020-08-22 | McKinley | New Mexico | 35031 | 4119 | 237 |
461870 | 461870 | 2020-08-23 | McKinley | New Mexico | 35031 | 4157 | 238 |
465100 | 465100 | 2020-08-24 | McKinley | New Mexico | 35031 | 4159 | 239 |
468328 | 468328 | 2020-08-25 | McKinley | New Mexico | 35031 | 4164 | 239 |
471560 | 471560 | 2020-08-26 | McKinley | New Mexico | 35031 | 4167 | 241 |
474794 | 474794 | 2020-08-27 | McKinley | New Mexico | 35031 | 4170 | 242 |
478027 | 478027 | 2020-08-28 | McKinley | New Mexico | 35031 | 4178 | 242 |
481259 | 481259 | 2020-08-29 | McKinley | New Mexico | 35031 | 4193 | 242 |
484494 | 484494 | 2020-08-30 | McKinley | New Mexico | 35031 | 4195 | 242 |
487728 | 487728 | 2020-08-31 | McKinley | New Mexico | 35031 | 4203 | 242 |
490961 | 490961 | 2020-09-01 | McKinley | New Mexico | 35031 | 4213 | 243 |
494195 | 494195 | 2020-09-02 | McKinley | New Mexico | 35031 | 4223 | 243 |
497428 | 497428 | 2020-09-03 | McKinley | New Mexico | 35031 | 4229 | 243 |
500662 | 500662 | 2020-09-04 | McKinley | New Mexico | 35031 | 4230 | 243 |
503896 | 503896 | 2020-09-05 | McKinley | New Mexico | 35031 | 4239 | 246 |
507128 | 507128 | 2020-09-06 | McKinley | New Mexico | 35031 | 4240 | 247 |
510361 | 510361 | 2020-09-07 | McKinley | New Mexico | 35031 | 4244 | 249 |
513594 | 513594 | 2020-09-08 | McKinley | New Mexico | 35031 | 4244 | 249 |
516828 | 516828 | 2020-09-09 | McKinley | New Mexico | 35031 | 4250 | 249 |
520064 | 520064 | 2020-09-10 | McKinley | New Mexico | 35031 | 4252 | 250 |
523301 | 523301 | 2020-09-11 | McKinley | New Mexico | 35031 | 4259 | 250 |
526537 | 526537 | 2020-09-12 | McKinley | New Mexico | 35031 | 4264 | 251 |
529773 | 529773 | 2020-09-13 | McKinley | New Mexico | 35031 | 4266 | 251 |
533009 | 533009 | 2020-09-14 | McKinley | New Mexico | 35031 | 4266 | 251 |
536244 | 536244 | 2020-09-15 | McKinley | New Mexico | 35031 | 4278 | 252 |
539481 | 539481 | 2020-09-16 | McKinley | New Mexico | 35031 | 4280 | 252 |
542718 | 542718 | 2020-09-17 | McKinley | New Mexico | 35031 | 4285 | 253 |
545955 | 545955 | 2020-09-18 | McKinley | New Mexico | 35031 | 4290 | 255 |
549193 | 549193 | 2020-09-19 | McKinley | New Mexico | 35031 | 4292 | 255 |
552432 | 552432 | 2020-09-20 | McKinley | New Mexico | 35031 | 4292 | 255 |
555670 | 555670 | 2020-09-21 | McKinley | New Mexico | 35031 | 4295 | 255 |
558907 | 558907 | 2020-09-22 | McKinley | New Mexico | 35031 | 4300 | 255 |
562144 | 562144 | 2020-09-23 | McKinley | New Mexico | 35031 | 4304 | 256 |
565385 | 565385 | 2020-09-24 | McKinley | New Mexico | 35031 | 4311 | 256 |
568626 | 568626 | 2020-09-25 | McKinley | New Mexico | 35031 | 4316 | 256 |
571868 | 571868 | 2020-09-26 | McKinley | New Mexico | 35031 | 4317 | 257 |
575111 | 575111 | 2020-09-27 | McKinley | New Mexico | 35031 | 4322 | 257 |
578352 | 578352 | 2020-09-28 | McKinley | New Mexico | 35031 | 4335 | 257 |
581593 | 581593 | 2020-09-29 | McKinley | New Mexico | 35031 | 4338 | 257 |
584834 | 584834 | 2020-09-30 | McKinley | New Mexico | 35031 | 4343 | 257 |
588074 | 588074 | 2020-10-01 | McKinley | New Mexico | 35031 | 4346 | 257 |
591315 | 591315 | 2020-10-02 | McKinley | New Mexico | 35031 | 4353 | 257 |
594556 | 594556 | 2020-10-03 | McKinley | New Mexico | 35031 | 4355 | 257 |
597798 | 597798 | 2020-10-04 | McKinley | New Mexico | 35031 | 4355 | 257 |
601042 | 601042 | 2020-10-05 | McKinley | New Mexico | 35031 | 4356 | 257 |
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);