ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Madera" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635090 | 635090 | 2020-10-16 | Madera | California | 6039 | 4836 | 73 |
631844 | 631844 | 2020-10-15 | Madera | California | 6039 | 4822 | 73 |
628600 | 628600 | 2020-10-14 | Madera | California | 6039 | 4808 | 73 |
625357 | 625357 | 2020-10-13 | Madera | California | 6039 | 4796 | 71 |
622114 | 622114 | 2020-10-12 | Madera | California | 6039 | 4748 | 71 |
618871 | 618871 | 2020-10-11 | Madera | California | 6039 | 4748 | 71 |
615629 | 615629 | 2020-10-10 | Madera | California | 6039 | 4748 | 71 |
612388 | 612388 | 2020-10-09 | Madera | California | 6039 | 4748 | 71 |
609146 | 609146 | 2020-10-08 | Madera | California | 6039 | 4739 | 70 |
605903 | 605903 | 2020-10-07 | Madera | California | 6039 | 4706 | 70 |
602661 | 602661 | 2020-10-06 | Madera | California | 6039 | 4706 | 70 |
599418 | 599418 | 2020-10-05 | Madera | California | 6039 | 4706 | 70 |
596175 | 596175 | 2020-10-04 | Madera | California | 6039 | 4642 | 70 |
592933 | 592933 | 2020-10-03 | Madera | California | 6039 | 4642 | 70 |
589693 | 589693 | 2020-10-02 | Madera | California | 6039 | 4642 | 70 |
586452 | 586452 | 2020-10-01 | Madera | California | 6039 | 4614 | 68 |
583212 | 583212 | 2020-09-30 | Madera | California | 6039 | 4557 | 65 |
579973 | 579973 | 2020-09-29 | Madera | California | 6039 | 4557 | 65 |
576732 | 576732 | 2020-09-28 | Madera | California | 6039 | 4539 | 65 |
573489 | 573489 | 2020-09-27 | Madera | California | 6039 | 4458 | 65 |
570247 | 570247 | 2020-09-26 | Madera | California | 6039 | 4458 | 65 |
567005 | 567005 | 2020-09-25 | Madera | California | 6039 | 4458 | 65 |
563765 | 563765 | 2020-09-24 | Madera | California | 6039 | 4458 | 65 |
560526 | 560526 | 2020-09-23 | Madera | California | 6039 | 4424 | 65 |
557290 | 557290 | 2020-09-22 | Madera | California | 6039 | 4424 | 65 |
554053 | 554053 | 2020-09-21 | Madera | California | 6039 | 4391 | 62 |
550814 | 550814 | 2020-09-20 | Madera | California | 6039 | 4296 | 58 |
547575 | 547575 | 2020-09-19 | Madera | California | 6039 | 4296 | 58 |
544337 | 544337 | 2020-09-18 | Madera | California | 6039 | 4296 | 58 |
541101 | 541101 | 2020-09-17 | Madera | California | 6039 | 4270 | 58 |
537864 | 537864 | 2020-09-16 | Madera | California | 6039 | 4267 | 58 |
534628 | 534628 | 2020-09-15 | Madera | California | 6039 | 4230 | 58 |
531393 | 531393 | 2020-09-14 | Madera | California | 6039 | 4226 | 58 |
528156 | 528156 | 2020-09-13 | Madera | California | 6039 | 4150 | 58 |
524920 | 524920 | 2020-09-12 | Madera | California | 6039 | 4150 | 58 |
521684 | 521684 | 2020-09-11 | Madera | California | 6039 | 4150 | 58 |
518447 | 518447 | 2020-09-10 | Madera | California | 6039 | 4079 | 58 |
515212 | 515212 | 2020-09-09 | Madera | California | 6039 | 4064 | 58 |
511979 | 511979 | 2020-09-08 | Madera | California | 6039 | 4025 | 58 |
508746 | 508746 | 2020-09-07 | Madera | California | 6039 | 3953 | 58 |
505514 | 505514 | 2020-09-06 | Madera | California | 6039 | 3953 | 58 |
502280 | 502280 | 2020-09-05 | Madera | California | 6039 | 3953 | 58 |
499046 | 499046 | 2020-09-04 | Madera | California | 6039 | 3953 | 58 |
495813 | 495813 | 2020-09-03 | Madera | California | 6039 | 3889 | 57 |
492579 | 492579 | 2020-09-02 | Madera | California | 6039 | 3876 | 55 |
489346 | 489346 | 2020-09-01 | Madera | California | 6039 | 3836 | 55 |
486113 | 486113 | 2020-08-31 | Madera | California | 6039 | 3783 | 54 |
482878 | 482878 | 2020-08-30 | Madera | California | 6039 | 3674 | 54 |
479644 | 479644 | 2020-08-29 | Madera | California | 6039 | 3674 | 54 |
476411 | 476411 | 2020-08-28 | Madera | California | 6039 | 3674 | 54 |
473178 | 473178 | 2020-08-27 | Madera | California | 6039 | 3551 | 53 |
469946 | 469946 | 2020-08-26 | Madera | California | 6039 | 3551 | 53 |
466717 | 466717 | 2020-08-25 | Madera | California | 6039 | 3509 | 51 |
463488 | 463488 | 2020-08-24 | Madera | California | 6039 | 3484 | 50 |
460259 | 460259 | 2020-08-23 | Madera | California | 6039 | 3339 | 49 |
457032 | 457032 | 2020-08-22 | Madera | California | 6039 | 3339 | 49 |
453804 | 453804 | 2020-08-21 | Madera | California | 6039 | 3339 | 49 |
450576 | 450576 | 2020-08-20 | Madera | California | 6039 | 3278 | 49 |
447348 | 447348 | 2020-08-19 | Madera | California | 6039 | 3236 | 47 |
444121 | 444121 | 2020-08-18 | Madera | California | 6039 | 3196 | 47 |
440895 | 440895 | 2020-08-17 | Madera | California | 6039 | 3129 | 47 |
437669 | 437669 | 2020-08-16 | Madera | California | 6039 | 2950 | 47 |
434443 | 434443 | 2020-08-15 | Madera | California | 6039 | 2924 | 47 |
431218 | 431218 | 2020-08-14 | Madera | California | 6039 | 2924 | 47 |
427990 | 427990 | 2020-08-13 | Madera | California | 6039 | 2853 | 46 |
424766 | 424766 | 2020-08-12 | Madera | California | 6039 | 2759 | 44 |
421545 | 421545 | 2020-08-11 | Madera | California | 6039 | 2463 | 39 |
418324 | 418324 | 2020-08-10 | Madera | California | 6039 | 2463 | 39 |
415103 | 415103 | 2020-08-09 | Madera | California | 6039 | 2302 | 39 |
411883 | 411883 | 2020-08-08 | Madera | California | 6039 | 2302 | 39 |
408664 | 408664 | 2020-08-07 | Madera | California | 6039 | 2302 | 39 |
405444 | 405444 | 2020-08-06 | Madera | California | 6039 | 2267 | 36 |
402226 | 402226 | 2020-08-05 | Madera | California | 6039 | 2161 | 32 |
399010 | 399010 | 2020-08-04 | Madera | California | 6039 | 2143 | 32 |
395794 | 395794 | 2020-08-03 | Madera | California | 6039 | 2123 | 32 |
392578 | 392578 | 2020-08-02 | Madera | California | 6039 | 2103 | 30 |
389361 | 389361 | 2020-08-01 | Madera | California | 6039 | 2036 | 30 |
386144 | 386144 | 2020-07-31 | Madera | California | 6039 | 2007 | 30 |
382926 | 382926 | 2020-07-30 | Madera | California | 6039 | 1941 | 28 |
379709 | 379709 | 2020-07-29 | Madera | California | 6039 | 1889 | 28 |
376493 | 376493 | 2020-07-28 | Madera | California | 6039 | 1841 | 23 |
373279 | 373279 | 2020-07-27 | Madera | California | 6039 | 1744 | 21 |
370067 | 370067 | 2020-07-26 | Madera | California | 6039 | 1724 | 19 |
366857 | 366857 | 2020-07-25 | Madera | California | 6039 | 1679 | 19 |
363650 | 363650 | 2020-07-24 | Madera | California | 6039 | 1659 | 19 |
360443 | 360443 | 2020-07-23 | Madera | California | 6039 | 1599 | 18 |
357238 | 357238 | 2020-07-22 | Madera | California | 6039 | 1530 | 16 |
354035 | 354035 | 2020-07-21 | Madera | California | 6039 | 1439 | 13 |
350833 | 350833 | 2020-07-20 | Madera | California | 6039 | 1451 | 13 |
347632 | 347632 | 2020-07-19 | Madera | California | 6039 | 1260 | 11 |
344432 | 344432 | 2020-07-18 | Madera | California | 6039 | 1214 | 11 |
341233 | 341233 | 2020-07-17 | Madera | California | 6039 | 1192 | 11 |
338037 | 338037 | 2020-07-16 | Madera | California | 6039 | 1147 | 11 |
334842 | 334842 | 2020-07-15 | Madera | California | 6039 | 1118 | 10 |
331649 | 331649 | 2020-07-14 | Madera | California | 6039 | 1059 | 9 |
328463 | 328463 | 2020-07-13 | Madera | California | 6039 | 1025 | 8 |
325277 | 325277 | 2020-07-12 | Madera | California | 6039 | 988 | 8 |
322096 | 322096 | 2020-07-11 | Madera | California | 6039 | 914 | 8 |
318917 | 318917 | 2020-07-10 | Madera | California | 6039 | 893 | 8 |
315744 | 315744 | 2020-07-09 | Madera | California | 6039 | 857 | 8 |
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);