ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Fresno" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635080 | 635080 | 2020-10-16 | Fresno | California | 6019 | 29727 | 429 |
631834 | 631834 | 2020-10-15 | Fresno | California | 6019 | 29650 | 424 |
628590 | 628590 | 2020-10-14 | Fresno | California | 6019 | 29579 | 424 |
625347 | 625347 | 2020-10-13 | Fresno | California | 6019 | 29523 | 424 |
622104 | 622104 | 2020-10-12 | Fresno | California | 6019 | 29419 | 406 |
618861 | 618861 | 2020-10-11 | Fresno | California | 6019 | 29286 | 406 |
615619 | 615619 | 2020-10-10 | Fresno | California | 6019 | 29208 | 406 |
612378 | 612378 | 2020-10-09 | Fresno | California | 6019 | 29111 | 406 |
609136 | 609136 | 2020-10-08 | Fresno | California | 6019 | 29069 | 406 |
605893 | 605893 | 2020-10-07 | Fresno | California | 6019 | 29022 | 406 |
602651 | 602651 | 2020-10-06 | Fresno | California | 6019 | 29136 | 406 |
599408 | 599408 | 2020-10-05 | Fresno | California | 6019 | 29065 | 399 |
596165 | 596165 | 2020-10-04 | Fresno | California | 6019 | 28975 | 399 |
592923 | 592923 | 2020-10-03 | Fresno | California | 6019 | 28855 | 399 |
589683 | 589683 | 2020-10-02 | Fresno | California | 6019 | 28796 | 399 |
586442 | 586442 | 2020-10-01 | Fresno | California | 6019 | 28706 | 390 |
583202 | 583202 | 2020-09-30 | Fresno | California | 6019 | 28621 | 390 |
579963 | 579963 | 2020-09-29 | Fresno | California | 6019 | 28517 | 390 |
576722 | 576722 | 2020-09-28 | Fresno | California | 6019 | 28441 | 382 |
573479 | 573479 | 2020-09-27 | Fresno | California | 6019 | 28336 | 382 |
570237 | 570237 | 2020-09-26 | Fresno | California | 6019 | 28199 | 382 |
566995 | 566995 | 2020-09-25 | Fresno | California | 6019 | 28106 | 382 |
563755 | 563755 | 2020-09-24 | Fresno | California | 6019 | 28019 | 362 |
560516 | 560516 | 2020-09-23 | Fresno | California | 6019 | 27944 | 362 |
557280 | 557280 | 2020-09-22 | Fresno | California | 6019 | 27843 | 362 |
554043 | 554043 | 2020-09-21 | Fresno | California | 6019 | 27769 | 355 |
550804 | 550804 | 2020-09-20 | Fresno | California | 6019 | 27668 | 355 |
547565 | 547565 | 2020-09-19 | Fresno | California | 6019 | 27560 | 355 |
544327 | 544327 | 2020-09-18 | Fresno | California | 6019 | 27487 | 355 |
541091 | 541091 | 2020-09-17 | Fresno | California | 6019 | 27381 | 348 |
537854 | 537854 | 2020-09-16 | Fresno | California | 6019 | 27312 | 348 |
534618 | 534618 | 2020-09-15 | Fresno | California | 6019 | 27232 | 348 |
531383 | 531383 | 2020-09-14 | Fresno | California | 6019 | 27196 | 337 |
528146 | 528146 | 2020-09-13 | Fresno | California | 6019 | 27076 | 337 |
524910 | 524910 | 2020-09-12 | Fresno | California | 6019 | 26917 | 337 |
521674 | 521674 | 2020-09-11 | Fresno | California | 6019 | 26783 | 337 |
518437 | 518437 | 2020-09-10 | Fresno | California | 6019 | 26724 | 326 |
515202 | 515202 | 2020-09-09 | Fresno | California | 6019 | 26640 | 326 |
511969 | 511969 | 2020-09-08 | Fresno | California | 6019 | 26565 | 326 |
508736 | 508736 | 2020-09-07 | Fresno | California | 6019 | 26471 | 312 |
505504 | 505504 | 2020-09-06 | Fresno | California | 6019 | 26325 | 312 |
502270 | 502270 | 2020-09-05 | Fresno | California | 6019 | 26147 | 312 |
499036 | 499036 | 2020-09-04 | Fresno | California | 6019 | 25978 | 312 |
495803 | 495803 | 2020-09-03 | Fresno | California | 6019 | 25785 | 290 |
492569 | 492569 | 2020-09-02 | Fresno | California | 6019 | 25542 | 290 |
489336 | 489336 | 2020-09-01 | Fresno | California | 6019 | 25185 | 290 |
486103 | 486103 | 2020-08-31 | Fresno | California | 6019 | 24963 | 263 |
482868 | 482868 | 2020-08-30 | Fresno | California | 6019 | 24821 | 263 |
479634 | 479634 | 2020-08-29 | Fresno | California | 6019 | 24612 | 263 |
476401 | 476401 | 2020-08-28 | Fresno | California | 6019 | 24367 | 263 |
473168 | 473168 | 2020-08-27 | Fresno | California | 6019 | 24071 | 239 |
469936 | 469936 | 2020-08-26 | Fresno | California | 6019 | 23932 | 239 |
466707 | 466707 | 2020-08-25 | Fresno | California | 6019 | 23618 | 239 |
463478 | 463478 | 2020-08-24 | Fresno | California | 6019 | 23414 | 226 |
460249 | 460249 | 2020-08-23 | Fresno | California | 6019 | 23197 | 226 |
457022 | 457022 | 2020-08-22 | Fresno | California | 6019 | 22840 | 226 |
453794 | 453794 | 2020-08-21 | Fresno | California | 6019 | 22535 | 226 |
450566 | 450566 | 2020-08-20 | Fresno | California | 6019 | 22167 | 205 |
447338 | 447338 | 2020-08-19 | Fresno | California | 6019 | 21316 | 205 |
444111 | 444111 | 2020-08-18 | Fresno | California | 6019 | 21316 | 205 |
440885 | 440885 | 2020-08-17 | Fresno | California | 6019 | 21010 | 203 |
437659 | 437659 | 2020-08-16 | Fresno | California | 6019 | 20603 | 203 |
434433 | 434433 | 2020-08-15 | Fresno | California | 6019 | 19900 | 203 |
431208 | 431208 | 2020-08-14 | Fresno | California | 6019 | 19157 | 203 |
427980 | 427980 | 2020-08-13 | Fresno | California | 6019 | 18690 | 191 |
424756 | 424756 | 2020-08-12 | Fresno | California | 6019 | 18344 | 191 |
421535 | 421535 | 2020-08-11 | Fresno | California | 6019 | 17978 | 191 |
418314 | 418314 | 2020-08-10 | Fresno | California | 6019 | 17846 | 171 |
415093 | 415093 | 2020-08-09 | Fresno | California | 6019 | 17538 | 171 |
411873 | 411873 | 2020-08-08 | Fresno | California | 6019 | 17290 | 171 |
408654 | 408654 | 2020-08-07 | Fresno | California | 6019 | 16641 | 171 |
405434 | 405434 | 2020-08-06 | Fresno | California | 6019 | 16625 | 157 |
402216 | 402216 | 2020-08-05 | Fresno | California | 6019 | 16272 | 157 |
399000 | 399000 | 2020-08-04 | Fresno | California | 6019 | 15945 | 157 |
395784 | 395784 | 2020-08-03 | Fresno | California | 6019 | 15759 | 138 |
392568 | 392568 | 2020-08-02 | Fresno | California | 6019 | 15448 | 138 |
389351 | 389351 | 2020-08-01 | Fresno | California | 6019 | 15083 | 138 |
386134 | 386134 | 2020-07-31 | Fresno | California | 6019 | 14793 | 138 |
382916 | 382916 | 2020-07-30 | Fresno | California | 6019 | 14312 | 120 |
379699 | 379699 | 2020-07-29 | Fresno | California | 6019 | 13933 | 120 |
376483 | 376483 | 2020-07-28 | Fresno | California | 6019 | 13485 | 120 |
373269 | 373269 | 2020-07-27 | Fresno | California | 6019 | 13209 | 112 |
370057 | 370057 | 2020-07-26 | Fresno | California | 6019 | 12866 | 112 |
366847 | 366847 | 2020-07-25 | Fresno | California | 6019 | 12564 | 112 |
363640 | 363640 | 2020-07-24 | Fresno | California | 6019 | 12164 | 112 |
360433 | 360433 | 2020-07-23 | Fresno | California | 6019 | 11756 | 104 |
357228 | 357228 | 2020-07-22 | Fresno | California | 6019 | 11412 | 104 |
354025 | 354025 | 2020-07-21 | Fresno | California | 6019 | 10970 | 104 |
350823 | 350823 | 2020-07-20 | Fresno | California | 6019 | 10639 | 100 |
347622 | 347622 | 2020-07-19 | Fresno | California | 6019 | 10381 | 100 |
344422 | 344422 | 2020-07-18 | Fresno | California | 6019 | 9954 | 100 |
341223 | 341223 | 2020-07-17 | Fresno | California | 6019 | 9565 | 100 |
338027 | 338027 | 2020-07-16 | Fresno | California | 6019 | 9124 | 91 |
334832 | 334832 | 2020-07-15 | Fresno | California | 6019 | 8941 | 91 |
331639 | 331639 | 2020-07-14 | Fresno | California | 6019 | 8756 | 91 |
328453 | 328453 | 2020-07-13 | Fresno | California | 6019 | 8407 | 88 |
325267 | 325267 | 2020-07-12 | Fresno | California | 6019 | 8282 | 88 |
322086 | 322086 | 2020-07-11 | Fresno | California | 6019 | 8282 | 88 |
318907 | 318907 | 2020-07-10 | Fresno | California | 6019 | 7906 | 88 |
315734 | 315734 | 2020-07-09 | Fresno | California | 6019 | 7627 | 87 |
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);