ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lake", fips = 30047 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636521 | 636521 | 2020-10-16 | Lake | Montana | 30047 | 400 | 1 |
633275 | 633275 | 2020-10-15 | Lake | Montana | 30047 | 376 | 1 |
630030 | 630030 | 2020-10-14 | Lake | Montana | 30047 | 372 | 1 |
626786 | 626786 | 2020-10-13 | Lake | Montana | 30047 | 370 | 1 |
623544 | 623544 | 2020-10-12 | Lake | Montana | 30047 | 358 | 1 |
620301 | 620301 | 2020-10-11 | Lake | Montana | 30047 | 350 | 1 |
617059 | 617059 | 2020-10-10 | Lake | Montana | 30047 | 334 | 1 |
613818 | 613818 | 2020-10-09 | Lake | Montana | 30047 | 333 | 1 |
610576 | 610576 | 2020-10-08 | Lake | Montana | 30047 | 328 | 1 |
607334 | 607334 | 2020-10-07 | Lake | Montana | 30047 | 315 | 1 |
604091 | 604091 | 2020-10-06 | Lake | Montana | 30047 | 304 | 1 |
600849 | 600849 | 2020-10-05 | Lake | Montana | 30047 | 294 | 1 |
597606 | 597606 | 2020-10-04 | Lake | Montana | 30047 | 292 | 1 |
594365 | 594365 | 2020-10-03 | Lake | Montana | 30047 | 292 | 1 |
591124 | 591124 | 2020-10-02 | Lake | Montana | 30047 | 287 | 1 |
587883 | 587883 | 2020-10-01 | Lake | Montana | 30047 | 284 | 1 |
584643 | 584643 | 2020-09-30 | Lake | Montana | 30047 | 284 | 1 |
581402 | 581402 | 2020-09-29 | Lake | Montana | 30047 | 281 | 1 |
578161 | 578161 | 2020-09-28 | Lake | Montana | 30047 | 277 | 1 |
574920 | 574920 | 2020-09-27 | Lake | Montana | 30047 | 276 | 1 |
571677 | 571677 | 2020-09-26 | Lake | Montana | 30047 | 276 | 1 |
568435 | 568435 | 2020-09-25 | Lake | Montana | 30047 | 274 | 1 |
565195 | 565195 | 2020-09-24 | Lake | Montana | 30047 | 265 | 1 |
561954 | 561954 | 2020-09-23 | Lake | Montana | 30047 | 260 | 1 |
558717 | 558717 | 2020-09-22 | Lake | Montana | 30047 | 255 | 1 |
555480 | 555480 | 2020-09-21 | Lake | Montana | 30047 | 254 | 1 |
552242 | 552242 | 2020-09-20 | Lake | Montana | 30047 | 251 | 1 |
549003 | 549003 | 2020-09-19 | Lake | Montana | 30047 | 251 | 1 |
545765 | 545765 | 2020-09-18 | Lake | Montana | 30047 | 254 | 1 |
542528 | 542528 | 2020-09-17 | Lake | Montana | 30047 | 252 | 1 |
539292 | 539292 | 2020-09-16 | Lake | Montana | 30047 | 245 | 1 |
536055 | 536055 | 2020-09-15 | Lake | Montana | 30047 | 243 | 1 |
532820 | 532820 | 2020-09-14 | Lake | Montana | 30047 | 241 | 1 |
529584 | 529584 | 2020-09-13 | Lake | Montana | 30047 | 241 | 1 |
526348 | 526348 | 2020-09-12 | Lake | Montana | 30047 | 232 | 1 |
523112 | 523112 | 2020-09-11 | Lake | Montana | 30047 | 232 | 1 |
519875 | 519875 | 2020-09-10 | Lake | Montana | 30047 | 227 | 1 |
516640 | 516640 | 2020-09-09 | Lake | Montana | 30047 | 227 | 1 |
513406 | 513406 | 2020-09-08 | Lake | Montana | 30047 | 224 | 1 |
510174 | 510174 | 2020-09-07 | Lake | Montana | 30047 | 222 | 1 |
506941 | 506941 | 2020-09-06 | Lake | Montana | 30047 | 222 | 1 |
503708 | 503708 | 2020-09-05 | Lake | Montana | 30047 | 222 | 1 |
500474 | 500474 | 2020-09-04 | Lake | Montana | 30047 | 217 | 1 |
497240 | 497240 | 2020-09-03 | Lake | Montana | 30047 | 209 | 1 |
494007 | 494007 | 2020-09-02 | Lake | Montana | 30047 | 204 | 1 |
490773 | 490773 | 2020-09-01 | Lake | Montana | 30047 | 203 | 1 |
487540 | 487540 | 2020-08-31 | Lake | Montana | 30047 | 202 | 1 |
484306 | 484306 | 2020-08-30 | Lake | Montana | 30047 | 202 | 1 |
481071 | 481071 | 2020-08-29 | Lake | Montana | 30047 | 202 | 1 |
477839 | 477839 | 2020-08-28 | Lake | Montana | 30047 | 199 | 1 |
474606 | 474606 | 2020-08-27 | Lake | Montana | 30047 | 199 | 1 |
471374 | 471374 | 2020-08-26 | Lake | Montana | 30047 | 192 | 1 |
468144 | 468144 | 2020-08-25 | Lake | Montana | 30047 | 193 | 1 |
464915 | 464915 | 2020-08-24 | Lake | Montana | 30047 | 193 | 1 |
461684 | 461684 | 2020-08-23 | Lake | Montana | 30047 | 192 | 1 |
458457 | 458457 | 2020-08-22 | Lake | Montana | 30047 | 192 | 1 |
455229 | 455229 | 2020-08-21 | Lake | Montana | 30047 | 193 | 1 |
452001 | 452001 | 2020-08-20 | Lake | Montana | 30047 | 191 | 1 |
448773 | 448773 | 2020-08-19 | Lake | Montana | 30047 | 191 | 1 |
445547 | 445547 | 2020-08-18 | Lake | Montana | 30047 | 189 | 1 |
442321 | 442321 | 2020-08-17 | Lake | Montana | 30047 | 187 | 1 |
439094 | 439094 | 2020-08-16 | Lake | Montana | 30047 | 187 | 1 |
435869 | 435869 | 2020-08-15 | Lake | Montana | 30047 | 187 | 1 |
432643 | 432643 | 2020-08-14 | Lake | Montana | 30047 | 184 | 1 |
429416 | 429416 | 2020-08-13 | Lake | Montana | 30047 | 184 | 1 |
426192 | 426192 | 2020-08-12 | Lake | Montana | 30047 | 184 | 1 |
422970 | 422970 | 2020-08-11 | Lake | Montana | 30047 | 183 | 1 |
419748 | 419748 | 2020-08-10 | Lake | Montana | 30047 | 181 | 1 |
416527 | 416527 | 2020-08-09 | Lake | Montana | 30047 | 180 | 1 |
413307 | 413307 | 2020-08-08 | Lake | Montana | 30047 | 179 | 1 |
410087 | 410087 | 2020-08-07 | Lake | Montana | 30047 | 179 | 1 |
406867 | 406867 | 2020-08-06 | Lake | Montana | 30047 | 176 | 1 |
403649 | 403649 | 2020-08-05 | Lake | Montana | 30047 | 170 | 1 |
400432 | 400432 | 2020-08-04 | Lake | Montana | 30047 | 169 | 1 |
397218 | 397218 | 2020-08-03 | Lake | Montana | 30047 | 164 | 1 |
394002 | 394002 | 2020-08-02 | Lake | Montana | 30047 | 166 | 1 |
390785 | 390785 | 2020-08-01 | Lake | Montana | 30047 | 165 | 1 |
387568 | 387568 | 2020-07-31 | Lake | Montana | 30047 | 165 | 1 |
384350 | 384350 | 2020-07-30 | Lake | Montana | 30047 | 160 | 1 |
381134 | 381134 | 2020-07-29 | Lake | Montana | 30047 | 160 | 1 |
377917 | 377917 | 2020-07-28 | Lake | Montana | 30047 | 146 | 1 |
374702 | 374702 | 2020-07-27 | Lake | Montana | 30047 | 140 | 1 |
371490 | 371490 | 2020-07-26 | Lake | Montana | 30047 | 139 | 1 |
368279 | 368279 | 2020-07-25 | Lake | Montana | 30047 | 136 | 1 |
365070 | 365070 | 2020-07-24 | Lake | Montana | 30047 | 117 | 1 |
361863 | 361863 | 2020-07-23 | Lake | Montana | 30047 | 116 | 0 |
358658 | 358658 | 2020-07-22 | Lake | Montana | 30047 | 116 | 0 |
355454 | 355454 | 2020-07-21 | Lake | Montana | 30047 | 117 | 0 |
352251 | 352251 | 2020-07-20 | Lake | Montana | 30047 | 105 | 0 |
349051 | 349051 | 2020-07-19 | Lake | Montana | 30047 | 102 | 0 |
345850 | 345850 | 2020-07-18 | Lake | Montana | 30047 | 100 | 0 |
342650 | 342650 | 2020-07-17 | Lake | Montana | 30047 | 100 | 0 |
339454 | 339454 | 2020-07-16 | Lake | Montana | 30047 | 81 | 0 |
336257 | 336257 | 2020-07-15 | Lake | Montana | 30047 | 81 | 0 |
333064 | 333064 | 2020-07-14 | Lake | Montana | 30047 | 80 | 0 |
329877 | 329877 | 2020-07-13 | Lake | Montana | 30047 | 53 | 0 |
326690 | 326690 | 2020-07-12 | Lake | Montana | 30047 | 51 | 0 |
323506 | 323506 | 2020-07-11 | Lake | Montana | 30047 | 48 | 0 |
320327 | 320327 | 2020-07-10 | Lake | Montana | 30047 | 40 | 0 |
317152 | 317152 | 2020-07-09 | Lake | Montana | 30047 | 38 | 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);