ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Kenai Peninsula Borough" and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531266 | 531266 | 2020-09-14 | Kenai Peninsula Borough | Alaska | 2122 | 601 | 1 |
528029 | 528029 | 2020-09-13 | Kenai Peninsula Borough | Alaska | 2122 | 601 | 1 |
524793 | 524793 | 2020-09-12 | Kenai Peninsula Borough | Alaska | 2122 | 601 | 1 |
521557 | 521557 | 2020-09-11 | Kenai Peninsula Borough | Alaska | 2122 | 601 | 1 |
518320 | 518320 | 2020-09-10 | Kenai Peninsula Borough | Alaska | 2122 | 592 | 1 |
515085 | 515085 | 2020-09-09 | Kenai Peninsula Borough | Alaska | 2122 | 592 | 1 |
511852 | 511852 | 2020-09-08 | Kenai Peninsula Borough | Alaska | 2122 | 590 | 1 |
508619 | 508619 | 2020-09-07 | Kenai Peninsula Borough | Alaska | 2122 | 589 | 1 |
505387 | 505387 | 2020-09-06 | Kenai Peninsula Borough | Alaska | 2122 | 588 | 1 |
502153 | 502153 | 2020-09-05 | Kenai Peninsula Borough | Alaska | 2122 | 584 | 1 |
498919 | 498919 | 2020-09-04 | Kenai Peninsula Borough | Alaska | 2122 | 582 | 1 |
495686 | 495686 | 2020-09-03 | Kenai Peninsula Borough | Alaska | 2122 | 579 | 1 |
492452 | 492452 | 2020-09-02 | Kenai Peninsula Borough | Alaska | 2122 | 577 | 1 |
489219 | 489219 | 2020-09-01 | Kenai Peninsula Borough | Alaska | 2122 | 569 | 1 |
485986 | 485986 | 2020-08-31 | Kenai Peninsula Borough | Alaska | 2122 | 568 | 1 |
482751 | 482751 | 2020-08-30 | Kenai Peninsula Borough | Alaska | 2122 | 568 | 1 |
479517 | 479517 | 2020-08-29 | Kenai Peninsula Borough | Alaska | 2122 | 565 | 1 |
476284 | 476284 | 2020-08-28 | Kenai Peninsula Borough | Alaska | 2122 | 564 | 1 |
473051 | 473051 | 2020-08-27 | Kenai Peninsula Borough | Alaska | 2122 | 564 | 1 |
469819 | 469819 | 2020-08-26 | Kenai Peninsula Borough | Alaska | 2122 | 564 | 1 |
466590 | 466590 | 2020-08-25 | Kenai Peninsula Borough | Alaska | 2122 | 561 | 1 |
463361 | 463361 | 2020-08-24 | Kenai Peninsula Borough | Alaska | 2122 | 560 | 1 |
460132 | 460132 | 2020-08-23 | Kenai Peninsula Borough | Alaska | 2122 | 558 | 1 |
456905 | 456905 | 2020-08-22 | Kenai Peninsula Borough | Alaska | 2122 | 555 | 1 |
453677 | 453677 | 2020-08-21 | Kenai Peninsula Borough | Alaska | 2122 | 547 | 1 |
450449 | 450449 | 2020-08-20 | Kenai Peninsula Borough | Alaska | 2122 | 542 | 1 |
447221 | 447221 | 2020-08-19 | Kenai Peninsula Borough | Alaska | 2122 | 540 | 1 |
443994 | 443994 | 2020-08-18 | Kenai Peninsula Borough | Alaska | 2122 | 538 | 1 |
440768 | 440768 | 2020-08-17 | Kenai Peninsula Borough | Alaska | 2122 | 523 | 1 |
437542 | 437542 | 2020-08-16 | Kenai Peninsula Borough | Alaska | 2122 | 522 | 1 |
434316 | 434316 | 2020-08-15 | Kenai Peninsula Borough | Alaska | 2122 | 507 | 1 |
431091 | 431091 | 2020-08-14 | Kenai Peninsula Borough | Alaska | 2122 | 504 | 1 |
427863 | 427863 | 2020-08-13 | Kenai Peninsula Borough | Alaska | 2122 | 502 | 1 |
424639 | 424639 | 2020-08-12 | Kenai Peninsula Borough | Alaska | 2122 | 498 | 1 |
421418 | 421418 | 2020-08-11 | Kenai Peninsula Borough | Alaska | 2122 | 495 | 1 |
418197 | 418197 | 2020-08-10 | Kenai Peninsula Borough | Alaska | 2122 | 486 | 1 |
414976 | 414976 | 2020-08-09 | Kenai Peninsula Borough | Alaska | 2122 | 480 | 1 |
411756 | 411756 | 2020-08-08 | Kenai Peninsula Borough | Alaska | 2122 | 474 | 1 |
408537 | 408537 | 2020-08-07 | Kenai Peninsula Borough | Alaska | 2122 | 470 | 1 |
405317 | 405317 | 2020-08-06 | Kenai Peninsula Borough | Alaska | 2122 | 464 | 1 |
402099 | 402099 | 2020-08-05 | Kenai Peninsula Borough | Alaska | 2122 | 460 | 1 |
398883 | 398883 | 2020-08-04 | Kenai Peninsula Borough | Alaska | 2122 | 458 | 1 |
395667 | 395667 | 2020-08-03 | Kenai Peninsula Borough | Alaska | 2122 | 454 | 1 |
392451 | 392451 | 2020-08-02 | Kenai Peninsula Borough | Alaska | 2122 | 447 | 1 |
389234 | 389234 | 2020-08-01 | Kenai Peninsula Borough | Alaska | 2122 | 444 | 1 |
386017 | 386017 | 2020-07-31 | Kenai Peninsula Borough | Alaska | 2122 | 437 | 1 |
382799 | 382799 | 2020-07-30 | Kenai Peninsula Borough | Alaska | 2122 | 436 | 1 |
379582 | 379582 | 2020-07-29 | Kenai Peninsula Borough | Alaska | 2122 | 407 | 1 |
376366 | 376366 | 2020-07-28 | Kenai Peninsula Borough | Alaska | 2122 | 388 | 1 |
373152 | 373152 | 2020-07-27 | Kenai Peninsula Borough | Alaska | 2122 | 371 | 1 |
369940 | 369940 | 2020-07-26 | Kenai Peninsula Borough | Alaska | 2122 | 367 | 1 |
366730 | 366730 | 2020-07-25 | Kenai Peninsula Borough | Alaska | 2122 | 327 | 1 |
363523 | 363523 | 2020-07-24 | Kenai Peninsula Borough | Alaska | 2122 | 295 | 1 |
360317 | 360317 | 2020-07-23 | Kenai Peninsula Borough | Alaska | 2122 | 283 | 1 |
357112 | 357112 | 2020-07-22 | Kenai Peninsula Borough | Alaska | 2122 | 282 | 1 |
353909 | 353909 | 2020-07-21 | Kenai Peninsula Borough | Alaska | 2122 | 279 | 1 |
350707 | 350707 | 2020-07-20 | Kenai Peninsula Borough | Alaska | 2122 | 271 | 1 |
347506 | 347506 | 2020-07-19 | Kenai Peninsula Borough | Alaska | 2122 | 265 | 1 |
344306 | 344306 | 2020-07-18 | Kenai Peninsula Borough | Alaska | 2122 | 258 | 1 |
341107 | 341107 | 2020-07-17 | Kenai Peninsula Borough | Alaska | 2122 | 250 | 1 |
337911 | 337911 | 2020-07-16 | Kenai Peninsula Borough | Alaska | 2122 | 244 | 1 |
334716 | 334716 | 2020-07-15 | Kenai Peninsula Borough | Alaska | 2122 | 232 | 1 |
331523 | 331523 | 2020-07-14 | Kenai Peninsula Borough | Alaska | 2122 | 232 | 1 |
328337 | 328337 | 2020-07-13 | Kenai Peninsula Borough | Alaska | 2122 | 225 | 1 |
325151 | 325151 | 2020-07-12 | Kenai Peninsula Borough | Alaska | 2122 | 221 | 1 |
321970 | 321970 | 2020-07-11 | Kenai Peninsula Borough | Alaska | 2122 | 211 | 1 |
318791 | 318791 | 2020-07-10 | Kenai Peninsula Borough | Alaska | 2122 | 209 | 1 |
315618 | 315618 | 2020-07-09 | Kenai Peninsula Borough | Alaska | 2122 | 202 | 1 |
312443 | 312443 | 2020-07-08 | Kenai Peninsula Borough | Alaska | 2122 | 195 | 1 |
309274 | 309274 | 2020-07-07 | Kenai Peninsula Borough | Alaska | 2122 | 185 | 1 |
306105 | 306105 | 2020-07-06 | Kenai Peninsula Borough | Alaska | 2122 | 183 | 1 |
302941 | 302941 | 2020-07-05 | Kenai Peninsula Borough | Alaska | 2122 | 180 | 1 |
299777 | 299777 | 2020-07-04 | Kenai Peninsula Borough | Alaska | 2122 | 178 | 1 |
296615 | 296615 | 2020-07-03 | Kenai Peninsula Borough | Alaska | 2122 | 177 | 1 |
293460 | 293460 | 2020-07-02 | Kenai Peninsula Borough | Alaska | 2122 | 171 | 1 |
290307 | 290307 | 2020-07-01 | Kenai Peninsula Borough | Alaska | 2122 | 164 | 1 |
287157 | 287157 | 2020-06-30 | Kenai Peninsula Borough | Alaska | 2122 | 159 | 1 |
284011 | 284011 | 2020-06-29 | Kenai Peninsula Borough | Alaska | 2122 | 151 | 1 |
280865 | 280865 | 2020-06-28 | Kenai Peninsula Borough | Alaska | 2122 | 141 | 1 |
277717 | 277717 | 2020-06-27 | Kenai Peninsula Borough | Alaska | 2122 | 138 | 1 |
274569 | 274569 | 2020-06-26 | Kenai Peninsula Borough | Alaska | 2122 | 136 | 1 |
271429 | 271429 | 2020-06-25 | Kenai Peninsula Borough | Alaska | 2122 | 134 | 1 |
268294 | 268294 | 2020-06-24 | Kenai Peninsula Borough | Alaska | 2122 | 128 | 1 |
265165 | 265165 | 2020-06-23 | Kenai Peninsula Borough | Alaska | 2122 | 128 | 1 |
262036 | 262036 | 2020-06-22 | Kenai Peninsula Borough | Alaska | 2122 | 127 | 1 |
258909 | 258909 | 2020-06-21 | Kenai Peninsula Borough | Alaska | 2122 | 127 | 1 |
255782 | 255782 | 2020-06-20 | Kenai Peninsula Borough | Alaska | 2122 | 126 | 1 |
252663 | 252663 | 2020-06-19 | Kenai Peninsula Borough | Alaska | 2122 | 124 | 1 |
249548 | 249548 | 2020-06-18 | Kenai Peninsula Borough | Alaska | 2122 | 123 | 1 |
246436 | 246436 | 2020-06-17 | Kenai Peninsula Borough | Alaska | 2122 | 122 | 1 |
243323 | 243323 | 2020-06-16 | Kenai Peninsula Borough | Alaska | 2122 | 120 | 1 |
240212 | 240212 | 2020-06-15 | Kenai Peninsula Borough | Alaska | 2122 | 116 | 1 |
237104 | 237104 | 2020-06-14 | Kenai Peninsula Borough | Alaska | 2122 | 115 | 1 |
233997 | 233997 | 2020-06-13 | Kenai Peninsula Borough | Alaska | 2122 | 115 | 1 |
230892 | 230892 | 2020-06-12 | Kenai Peninsula Borough | Alaska | 2122 | 109 | 1 |
227788 | 227788 | 2020-06-11 | Kenai Peninsula Borough | Alaska | 2122 | 104 | 1 |
224687 | 224687 | 2020-06-10 | Kenai Peninsula Borough | Alaska | 2122 | 101 | 1 |
221591 | 221591 | 2020-06-09 | Kenai Peninsula Borough | Alaska | 2122 | 91 | 1 |
218497 | 218497 | 2020-06-08 | Kenai Peninsula Borough | Alaska | 2122 | 88 | 1 |
215407 | 215407 | 2020-06-07 | Kenai Peninsula Borough | Alaska | 2122 | 84 | 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);