ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 4013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631741 | 631741 | 2020-10-15 | Maricopa | Arizona | 4013 | 148152 | 3489 |
628497 | 628497 | 2020-10-14 | Maricopa | Arizona | 4013 | 147551 | 3475 |
625254 | 625254 | 2020-10-13 | Maricopa | Arizona | 4013 | 147010 | 3471 |
622011 | 622011 | 2020-10-12 | Maricopa | Arizona | 4013 | 146574 | 3464 |
618768 | 618768 | 2020-10-11 | Maricopa | Arizona | 4013 | 146278 | 3464 |
615526 | 615526 | 2020-10-10 | Maricopa | Arizona | 4013 | 145847 | 3466 |
612285 | 612285 | 2020-10-09 | Maricopa | Arizona | 4013 | 145298 | 3458 |
609043 | 609043 | 2020-10-08 | Maricopa | Arizona | 4013 | 144867 | 3454 |
605800 | 605800 | 2020-10-07 | Maricopa | Arizona | 4013 | 144342 | 3450 |
602558 | 602558 | 2020-10-06 | Maricopa | Arizona | 4013 | 143917 | 3431 |
599315 | 599315 | 2020-10-05 | Maricopa | Arizona | 4013 | 143411 | 3427 |
596072 | 596072 | 2020-10-04 | Maricopa | Arizona | 4013 | 143183 | 3426 |
592830 | 592830 | 2020-10-03 | Maricopa | Arizona | 4013 | 142968 | 3424 |
589590 | 589590 | 2020-10-02 | Maricopa | Arizona | 4013 | 142566 | 3416 |
586349 | 586349 | 2020-10-01 | Maricopa | Arizona | 4013 | 142287 | 3405 |
583109 | 583109 | 2020-09-30 | Maricopa | Arizona | 4013 | 141856 | 3395 |
579870 | 579870 | 2020-09-29 | Maricopa | Arizona | 4013 | 141738 | 3372 |
576629 | 576629 | 2020-09-28 | Maricopa | Arizona | 4013 | 141377 | 3364 |
573385 | 573385 | 2020-09-27 | Maricopa | Arizona | 4013 | 141211 | 3363 |
570143 | 570143 | 2020-09-26 | Maricopa | Arizona | 4013 | 140963 | 3363 |
566902 | 566902 | 2020-09-25 | Maricopa | Arizona | 4013 | 140753 | 3343 |
563661 | 563661 | 2020-09-24 | Maricopa | Arizona | 4013 | 140584 | 3329 |
560422 | 560422 | 2020-09-23 | Maricopa | Arizona | 4013 | 140409 | 3304 |
557186 | 557186 | 2020-09-22 | Maricopa | Arizona | 4013 | 140314 | 3275 |
553949 | 553949 | 2020-09-21 | Maricopa | Arizona | 4013 | 140006 | 3262 |
550710 | 550710 | 2020-09-20 | Maricopa | Arizona | 4013 | 139856 | 3261 |
547471 | 547471 | 2020-09-19 | Maricopa | Arizona | 4013 | 139586 | 3260 |
544234 | 544234 | 2020-09-18 | Maricopa | Arizona | 4013 | 139963 | 3245 |
540998 | 540998 | 2020-09-17 | Maricopa | Arizona | 4013 | 139051 | 3210 |
537761 | 537761 | 2020-09-16 | Maricopa | Arizona | 4013 | 138151 | 3199 |
534525 | 534525 | 2020-09-15 | Maricopa | Arizona | 4013 | 137870 | 3172 |
531290 | 531290 | 2020-09-14 | Maricopa | Arizona | 4013 | 137589 | 3154 |
528053 | 528053 | 2020-09-13 | Maricopa | Arizona | 4013 | 137507 | 3154 |
524817 | 524817 | 2020-09-12 | Maricopa | Arizona | 4013 | 137292 | 3158 |
521581 | 521581 | 2020-09-11 | Maricopa | Arizona | 4013 | 136887 | 3140 |
518344 | 518344 | 2020-09-10 | Maricopa | Arizona | 4013 | 136571 | 3133 |
515109 | 515109 | 2020-09-09 | Maricopa | Arizona | 4013 | 136324 | 3116 |
511876 | 511876 | 2020-09-08 | Maricopa | Arizona | 4013 | 136040 | 3093 |
508643 | 508643 | 2020-09-07 | Maricopa | Arizona | 4013 | 136004 | 3091 |
505411 | 505411 | 2020-09-06 | Maricopa | Arizona | 4013 | 135964 | 3093 |
502177 | 502177 | 2020-09-05 | Maricopa | Arizona | 4013 | 135856 | 3088 |
498943 | 498943 | 2020-09-04 | Maricopa | Arizona | 4013 | 135495 | 3064 |
495710 | 495710 | 2020-09-03 | Maricopa | Arizona | 4013 | 135109 | 3030 |
492476 | 492476 | 2020-09-02 | Maricopa | Arizona | 4013 | 134346 | 2995 |
489243 | 489243 | 2020-09-01 | Maricopa | Arizona | 4013 | 134004 | 2976 |
486010 | 486010 | 2020-08-31 | Maricopa | Arizona | 4013 | 133728 | 2961 |
482775 | 482775 | 2020-08-30 | Maricopa | Arizona | 4013 | 133641 | 2962 |
479541 | 479541 | 2020-08-29 | Maricopa | Arizona | 4013 | 133389 | 2950 |
476308 | 476308 | 2020-08-28 | Maricopa | Arizona | 4013 | 132986 | 2924 |
473075 | 473075 | 2020-08-27 | Maricopa | Arizona | 4013 | 132704 | 2896 |
469843 | 469843 | 2020-08-26 | Maricopa | Arizona | 4013 | 132434 | 2869 |
466614 | 466614 | 2020-08-25 | Maricopa | Arizona | 4013 | 132290 | 2804 |
463385 | 463385 | 2020-08-24 | Maricopa | Arizona | 4013 | 131962 | 2790 |
460156 | 460156 | 2020-08-23 | Maricopa | Arizona | 4013 | 131787 | 2790 |
456929 | 456929 | 2020-08-22 | Maricopa | Arizona | 4013 | 131685 | 2776 |
453701 | 453701 | 2020-08-21 | Maricopa | Arizona | 4013 | 131166 | 2745 |
450473 | 450473 | 2020-08-20 | Maricopa | Arizona | 4013 | 130800 | 2739 |
447245 | 447245 | 2020-08-19 | Maricopa | Arizona | 4013 | 130384 | 2702 |
444018 | 444018 | 2020-08-18 | Maricopa | Arizona | 4013 | 129958 | 2612 |
440792 | 440792 | 2020-08-17 | Maricopa | Arizona | 4013 | 129562 | 2595 |
437566 | 437566 | 2020-08-16 | Maricopa | Arizona | 4013 | 129385 | 2596 |
434340 | 434340 | 2020-08-15 | Maricopa | Arizona | 4013 | 128865 | 2585 |
431115 | 431115 | 2020-08-14 | Maricopa | Arizona | 4013 | 128352 | 2536 |
427887 | 427887 | 2020-08-13 | Maricopa | Arizona | 4013 | 127768 | 2517 |
424663 | 424663 | 2020-08-12 | Maricopa | Arizona | 4013 | 127188 | 2493 |
421442 | 421442 | 2020-08-11 | Maricopa | Arizona | 4013 | 126791 | 2382 |
418221 | 418221 | 2020-08-10 | Maricopa | Arizona | 4013 | 126371 | 2356 |
415000 | 415000 | 2020-08-09 | Maricopa | Arizona | 4013 | 126053 | 2353 |
411780 | 411780 | 2020-08-08 | Maricopa | Arizona | 4013 | 125545 | 2347 |
408561 | 408561 | 2020-08-07 | Maricopa | Arizona | 4013 | 124924 | 2307 |
405341 | 405341 | 2020-08-06 | Maricopa | Arizona | 4013 | 124022 | 2259 |
402123 | 402123 | 2020-08-05 | Maricopa | Arizona | 4013 | 123082 | 2204 |
398907 | 398907 | 2020-08-04 | Maricopa | Arizona | 4013 | 121789 | 2153 |
395691 | 395691 | 2020-08-03 | Maricopa | Arizona | 4013 | 120960 | 2108 |
392475 | 392475 | 2020-08-02 | Maricopa | Arizona | 4013 | 120279 | 2101 |
389258 | 389258 | 2020-08-01 | Maricopa | Arizona | 4013 | 119295 | 2089 |
386041 | 386041 | 2020-07-31 | Maricopa | Arizona | 4013 | 117293 | 2054 |
382823 | 382823 | 2020-07-30 | Maricopa | Arizona | 4013 | 114852 | 2011 |
379606 | 379606 | 2020-07-29 | Maricopa | Arizona | 4013 | 113148 | 1915 |
376390 | 376390 | 2020-07-28 | Maricopa | Arizona | 4013 | 111446 | 1882 |
373176 | 373176 | 2020-07-27 | Maricopa | Arizona | 4013 | 109988 | 1807 |
369964 | 369964 | 2020-07-26 | Maricopa | Arizona | 4013 | 108677 | 1808 |
366754 | 366754 | 2020-07-25 | Maricopa | Arizona | 4013 | 107291 | 1793 |
363547 | 363547 | 2020-07-24 | Maricopa | Arizona | 4013 | 104613 | 1718 |
360340 | 360340 | 2020-07-23 | Maricopa | Arizona | 4013 | 102247 | 1651 |
357135 | 357135 | 2020-07-22 | Maricopa | Arizona | 4013 | 100543 | 1599 |
353932 | 353932 | 2020-07-21 | Maricopa | Arizona | 4013 | 98988 | 1556 |
350730 | 350730 | 2020-07-20 | Maricopa | Arizona | 4013 | 96711 | 1485 |
347529 | 347529 | 2020-07-19 | Maricopa | Arizona | 4013 | 95471 | 1473 |
344329 | 344329 | 2020-07-18 | Maricopa | Arizona | 4013 | 93870 | 1444 |
341130 | 341130 | 2020-07-17 | Maricopa | Arizona | 4013 | 91863 | 1374 |
337934 | 337934 | 2020-07-16 | Maricopa | Arizona | 4013 | 88954 | 1311 |
334739 | 334739 | 2020-07-15 | Maricopa | Arizona | 4013 | 86483 | 1277 |
331546 | 331546 | 2020-07-14 | Maricopa | Arizona | 4013 | 84233 | 1198 |
328360 | 328360 | 2020-07-13 | Maricopa | Arizona | 4013 | 81216 | 1140 |
325174 | 325174 | 2020-07-12 | Maricopa | Arizona | 4013 | 80146 | 1133 |
321993 | 321993 | 2020-07-11 | Maricopa | Arizona | 4013 | 78481 | 1093 |
318814 | 318814 | 2020-07-10 | Maricopa | Arizona | 4013 | 76328 | 1049 |
315641 | 315641 | 2020-07-09 | Maricopa | Arizona | 4013 | 73165 | 1012 |
312466 | 312466 | 2020-07-08 | Maricopa | Arizona | 4013 | 70128 | 959 |
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);