ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Lake" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635087 | 635087 | 2020-10-16 | Lake | California | 6033 | 642 | 14 |
631841 | 631841 | 2020-10-15 | Lake | California | 6033 | 642 | 14 |
628597 | 628597 | 2020-10-14 | Lake | California | 6033 | 639 | 14 |
625354 | 625354 | 2020-10-13 | Lake | California | 6033 | 633 | 13 |
622111 | 622111 | 2020-10-12 | Lake | California | 6033 | 631 | 13 |
618868 | 618868 | 2020-10-11 | Lake | California | 6033 | 630 | 13 |
615626 | 615626 | 2020-10-10 | Lake | California | 6033 | 610 | 13 |
612385 | 612385 | 2020-10-09 | Lake | California | 6033 | 604 | 12 |
609143 | 609143 | 2020-10-08 | Lake | California | 6033 | 599 | 12 |
605900 | 605900 | 2020-10-07 | Lake | California | 6033 | 596 | 12 |
602658 | 602658 | 2020-10-06 | Lake | California | 6033 | 592 | 12 |
599415 | 599415 | 2020-10-05 | Lake | California | 6033 | 589 | 11 |
596172 | 596172 | 2020-10-04 | Lake | California | 6033 | 588 | 11 |
592930 | 592930 | 2020-10-03 | Lake | California | 6033 | 579 | 11 |
589690 | 589690 | 2020-10-02 | Lake | California | 6033 | 572 | 11 |
586449 | 586449 | 2020-10-01 | Lake | California | 6033 | 567 | 11 |
583209 | 583209 | 2020-09-30 | Lake | California | 6033 | 566 | 11 |
579970 | 579970 | 2020-09-29 | Lake | California | 6033 | 559 | 11 |
576729 | 576729 | 2020-09-28 | Lake | California | 6033 | 555 | 11 |
573486 | 573486 | 2020-09-27 | Lake | California | 6033 | 549 | 11 |
570244 | 570244 | 2020-09-26 | Lake | California | 6033 | 539 | 11 |
567002 | 567002 | 2020-09-25 | Lake | California | 6033 | 531 | 11 |
563762 | 563762 | 2020-09-24 | Lake | California | 6033 | 519 | 11 |
560523 | 560523 | 2020-09-23 | Lake | California | 6033 | 516 | 11 |
557287 | 557287 | 2020-09-22 | Lake | California | 6033 | 508 | 11 |
554050 | 554050 | 2020-09-21 | Lake | California | 6033 | 492 | 10 |
550811 | 550811 | 2020-09-20 | Lake | California | 6033 | 465 | 10 |
547572 | 547572 | 2020-09-19 | Lake | California | 6033 | 458 | 10 |
544334 | 544334 | 2020-09-18 | Lake | California | 6033 | 433 | 10 |
541098 | 541098 | 2020-09-17 | Lake | California | 6033 | 417 | 7 |
537861 | 537861 | 2020-09-16 | Lake | California | 6033 | 416 | 7 |
534625 | 534625 | 2020-09-15 | Lake | California | 6033 | 407 | 7 |
531390 | 531390 | 2020-09-14 | Lake | California | 6033 | 397 | 7 |
528153 | 528153 | 2020-09-13 | Lake | California | 6033 | 393 | 7 |
524917 | 524917 | 2020-09-12 | Lake | California | 6033 | 382 | 7 |
521681 | 521681 | 2020-09-11 | Lake | California | 6033 | 377 | 6 |
518444 | 518444 | 2020-09-10 | Lake | California | 6033 | 371 | 6 |
515209 | 515209 | 2020-09-09 | Lake | California | 6033 | 370 | 5 |
511976 | 511976 | 2020-09-08 | Lake | California | 6033 | 367 | 5 |
508743 | 508743 | 2020-09-07 | Lake | California | 6033 | 362 | 5 |
505511 | 505511 | 2020-09-06 | Lake | California | 6033 | 359 | 5 |
502277 | 502277 | 2020-09-05 | Lake | California | 6033 | 347 | 5 |
499043 | 499043 | 2020-09-04 | Lake | California | 6033 | 347 | 5 |
495810 | 495810 | 2020-09-03 | Lake | California | 6033 | 342 | 5 |
492576 | 492576 | 2020-09-02 | Lake | California | 6033 | 341 | 5 |
489343 | 489343 | 2020-09-01 | Lake | California | 6033 | 341 | 4 |
486110 | 486110 | 2020-08-31 | Lake | California | 6033 | 334 | 4 |
482875 | 482875 | 2020-08-30 | Lake | California | 6033 | 329 | 4 |
479641 | 479641 | 2020-08-29 | Lake | California | 6033 | 320 | 3 |
476408 | 476408 | 2020-08-28 | Lake | California | 6033 | 314 | 3 |
473175 | 473175 | 2020-08-27 | Lake | California | 6033 | 308 | 3 |
469943 | 469943 | 2020-08-26 | Lake | California | 6033 | 304 | 3 |
466714 | 466714 | 2020-08-25 | Lake | California | 6033 | 302 | 3 |
463485 | 463485 | 2020-08-24 | Lake | California | 6033 | 299 | 3 |
460256 | 460256 | 2020-08-23 | Lake | California | 6033 | 291 | 3 |
457029 | 457029 | 2020-08-22 | Lake | California | 6033 | 281 | 3 |
453801 | 453801 | 2020-08-21 | Lake | California | 6033 | 280 | 3 |
450573 | 450573 | 2020-08-20 | Lake | California | 6033 | 277 | 2 |
447345 | 447345 | 2020-08-19 | Lake | California | 6033 | 270 | 2 |
444118 | 444118 | 2020-08-18 | Lake | California | 6033 | 270 | 2 |
440892 | 440892 | 2020-08-17 | Lake | California | 6033 | 269 | 2 |
437666 | 437666 | 2020-08-16 | Lake | California | 6033 | 268 | 2 |
434440 | 434440 | 2020-08-15 | Lake | California | 6033 | 267 | 2 |
431215 | 431215 | 2020-08-14 | Lake | California | 6033 | 263 | 2 |
427987 | 427987 | 2020-08-13 | Lake | California | 6033 | 253 | 2 |
424763 | 424763 | 2020-08-12 | Lake | California | 6033 | 243 | 2 |
421542 | 421542 | 2020-08-11 | Lake | California | 6033 | 239 | 2 |
418321 | 418321 | 2020-08-10 | Lake | California | 6033 | 225 | 2 |
415100 | 415100 | 2020-08-09 | Lake | California | 6033 | 221 | 2 |
411880 | 411880 | 2020-08-08 | Lake | California | 6033 | 215 | 2 |
408661 | 408661 | 2020-08-07 | Lake | California | 6033 | 209 | 2 |
405441 | 405441 | 2020-08-06 | Lake | California | 6033 | 209 | 2 |
402223 | 402223 | 2020-08-05 | Lake | California | 6033 | 206 | 1 |
399007 | 399007 | 2020-08-04 | Lake | California | 6033 | 201 | 1 |
395791 | 395791 | 2020-08-03 | Lake | California | 6033 | 201 | 1 |
392575 | 392575 | 2020-08-02 | Lake | California | 6033 | 195 | 1 |
389358 | 389358 | 2020-08-01 | Lake | California | 6033 | 195 | 1 |
386141 | 386141 | 2020-07-31 | Lake | California | 6033 | 195 | 1 |
382923 | 382923 | 2020-07-30 | Lake | California | 6033 | 183 | 1 |
379706 | 379706 | 2020-07-29 | Lake | California | 6033 | 179 | 1 |
376490 | 376490 | 2020-07-28 | Lake | California | 6033 | 176 | 1 |
373276 | 373276 | 2020-07-27 | Lake | California | 6033 | 175 | 1 |
370064 | 370064 | 2020-07-26 | Lake | California | 6033 | 173 | 1 |
366854 | 366854 | 2020-07-25 | Lake | California | 6033 | 168 | 1 |
363647 | 363647 | 2020-07-24 | Lake | California | 6033 | 168 | 1 |
360440 | 360440 | 2020-07-23 | Lake | California | 6033 | 166 | 1 |
357235 | 357235 | 2020-07-22 | Lake | California | 6033 | 157 | 1 |
354032 | 354032 | 2020-07-21 | Lake | California | 6033 | 156 | 1 |
350830 | 350830 | 2020-07-20 | Lake | California | 6033 | 151 | 1 |
347629 | 347629 | 2020-07-19 | Lake | California | 6033 | 142 | 1 |
344429 | 344429 | 2020-07-18 | Lake | California | 6033 | 140 | 1 |
341230 | 341230 | 2020-07-17 | Lake | California | 6033 | 140 | 1 |
338034 | 338034 | 2020-07-16 | Lake | California | 6033 | 137 | 1 |
334839 | 334839 | 2020-07-15 | Lake | California | 6033 | 133 | 1 |
331646 | 331646 | 2020-07-14 | Lake | California | 6033 | 122 | 1 |
328460 | 328460 | 2020-07-13 | Lake | California | 6033 | 121 | 1 |
325274 | 325274 | 2020-07-12 | Lake | California | 6033 | 110 | 1 |
322093 | 322093 | 2020-07-11 | Lake | California | 6033 | 108 | 1 |
318914 | 318914 | 2020-07-10 | Lake | California | 6033 | 108 | 1 |
315741 | 315741 | 2020-07-09 | Lake | California | 6033 | 101 | 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);