ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Pima" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 445 ✖
- 0 18
- 3646 11
- 2407 9
- 2664 9
- 2459 8
- 633 7
- 3663 7
- 3722 7
- 3751 7
- 3773 7
- 3794 7
- 3802 7
- 3803 7
- 3815 7
- 3843 7
- 596 5
- 622 5
- 636 5
- 674 5
- 185 4
- 282 4
- 602 4
- 627 4
- 670 4
- 730 4
- 983 4
- 2261 4
- 2359 4
- 2391 4
- 2409 4
- 2410 4
- 2413 4
- 2416 4
- 2420 4
- 2424 4
- 2437 4
- 2468 4
- 2470 4
- 2736 4
- 3554 4
- 6 3
- 29 3
- 76 3
- 89 3
- 157 3
- 173 3
- 174 3
- 205 3
- 223 3
- 242 3
- 268 3
- 462 3
- 489 3
- 551 3
- 576 3
- 613 3
- 634 3
- 635 3
- 669 3
- 1084 3
- 1422 3
- 2075 3
- 2216 3
- 2300 3
- 2381 3
- 2395 3
- 2403 3
- 2411 3
- 2412 3
- 2433 3
- 2440 3
- 2451 3
- 2455 3
- 2467 3
- 2481 3
- 2496 3
- 2526 3
- 2570 3
- 2614 3
- 2660 3
- 2769 3
- 2807 3
- 2844 3
- 2883 3
- 2928 3
- 3052 3
- 3121 3
- 3177 3
- 3369 3
- 3850 3
- 11 2
- 12 2
- 13 2
- 20 2
- 56 2
- 80 2
- 134 2
- 202 2
- 280 2
- 302 2
- 313 2
- 327 2
- 382 2
- 418 2
- 431 2
- 531 2
- 534 2
- 574 2
- 600 2
- 615 2
- 617 2
- 630 2
- 642 2
- 659 2
- 679 2
- 682 2
- 691 2
- 800 2
- 905 2
- 1263 2
- 1611 2
- 1740 2
- 1904 2
- 2149 2
- 2326 2
- 2345 2
- 2369 2
- 2388 2
- 2389 2
- 2406 2
- 2418 2
- 2421 2
- 2427 2
- 2444 2
- 2458 2
- 2485 2
- 2541 2
- 2562 2
- 2669 2
- 2670 2
- 2708 2
- 2733 2
- 2984 2
- 3022 2
- 3210 2
- 3242 2
- 3273 2
- 3304 2
- 3441 2
- 3495 2
- 3539 2
- 3604 2
- 4 1
- 5 1
- 10 1
- 16 1
- 32 1
- 34 1
- 37 1
- 51 1
- 58 1
- 65 1
- 68 1
- 70 1
- 74 1
- 78 1
- 81 1
- 105 1
- 116 1
- 118 1
- 131 1
- 133 1
- 136 1
- 144 1
- 152 1
- 155 1
- 158 1
- 167 1
- 175 1
- 186 1
- 191 1
- 196 1
- 212 1
- 216 1
- 218 1
- 222 1
- 226 1
- 229 1
- 235 1
- 240 1
- 247 1
- 255 1
- 266 1
- 272 1
- 273 1
- 326 1
- 338 1
- 347 1
- 360 1
- 367 1
- 384 1
- 391 1
- 392 1
- 405 1
- 409 1
- 417 1
- 450 1
- 459 1
- 465 1
- 469 1
- 480 1
- 482 1
- 501 1
- 505 1
- 511 1
- 524 1
- 530 1
- 532 1
- 537 1
- 553 1
- 563 1
- 567 1
- 575 1
- 590 1
- 593 1
- 601 1
- 612 1
- 620 1
- 621 1
- 628 1
- 629 1
- 631 1
- 638 1
- 639 1
- 641 1
- 646 1
- 647 1
- 650 1
- 653 1
- 658 1
- 661 1
- 673 1
- 690 1
- 695 1
- 697 1
- 717 1
- 722 1
- 746 1
- 762 1
- 776 1
- 799 1
- 817 1
- 836 1
- 853 1
- 875 1
- 901 1
- 938 1
- 946 1
- 962 1
- 1023 1
- 1039 1
- 1064 1
- 1082 1
- 1137 1
- 1142 1
- 1189 1
- 1216 1
- 1219 1
- 1311 1
- 1335 1
- 1362 1
- 1393 1
- 1421 1
- 1495 1
- 1531 1
- 1571 1
- 1608 1
- 1649 1
- 1680 1
- 1706 1
- 1736 1
- 1738 1
- 1795 1
- 1831 1
- 1868 1
- 1899 1
- 1903 1
- 1958 1
- 1981 1
- 2023 1
- 2053 1
- 2072 1
- 2082 1
- 2119 1
- 2144 1
- 2146 1
- 2180 1
- 2186 1
- 2202 1
- 2212 1
- 2227 1
- 2233 1
- 2247 1
- 2254 1
- 2270 1
- 2285 1
- 2293 1
- 2304 1
- 2308 1
- 2317 1
- 2322 1
- 2325 1
- 2334 1
- 2338 1
- 2339 1
- 2341 1
- 2344 1
- 2348 1
- 2350 1
- 2351 1
- 2355 1
- 2361 1
- 2366 1
- 2367 1
- 2370 1
- 2372 1
- 2373 1
- 2376 1
- 2378 1
- 2386 1
- 2390 1
- 2392 1
- 2396 1
- 2397 1
- 2398 1
- 2399 1
- 2408 1
- 2414 1
- 2419 1
- 2422 1
- 2426 1
- 2431 1
- 2445 1
- 2448 1
- 2453 1
- 2461 1
- 2462 1
- 2463 1
- 2466 1
- 2472 1
- 2473 1
- 2479 1
- 2486 1
- 2492 1
- 2497 1
- 2507 1
- 2509 1
- 2519 1
- 2532 1
- 2533 1
- 2535 1
- 2536 1
- 2540 1
- 2560 1
- 2561 1
- 2589 1
- 2602 1
- 2606 1
- 2607 1
- 2633 1
- 2637 1
- 2639 1
- 2644 1
- 2668 1
- 2690 1
- 2691 1
- 2693 1
- 2703 1
- 2706 1
- 2726 1
- 2730 1
- 2756 1
- 2757 1
- 2766 1
- 2786 1
- 2789 1
- 2790 1
- 2792 1
- 2827 1
- 2829 1
- 2831 1
- 2838 1
- 2863 1
- 2865 1
- 2877 1
- 2878 1
- 2899 1
- 2900 1
- 2901 1
- 2903 1
- 2949 1
- 2951 1
- 2961 1
- 2972 1
- 2983 1
- 3020 1
- 3050 1
- 3094 1
- 3098 1
- 3099 1
- 3112 1
- 3150 1
- 3151 1
- 3153 1
- 3154 1
- 3206 1
- 3216 1
- 3230 1
- 3270 1
- 3288 1
- 3300 1
- 3342 1
- 3344 1
- 3345 1
- 3349 1
- 3353 1
- 3395 1
- 3397 1
- 3410 1
- 3437 1
- 3461 1
- 3467 1
- 3473 1
- 3484 1
- 3494 1
- 3523 1
- 3529 1
- 3553 1
- 3579 1
- 3597 1
- 3603 1
- 3623 1
- 3626 1
- 3639 1
- 3644 1
state 1
- Arizona 796
fips 1
- 4019 796
county 1
- Pima · 796 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499681 | 2499681 | 2022-05-13 | Pima | Arizona | 4019 | 255688 | 3850 |
2496423 | 2496423 | 2022-05-12 | Pima | Arizona | 4019 | 255688 | 3850 |
2493165 | 2493165 | 2022-05-11 | Pima | Arizona | 4019 | 255688 | 3850 |
2489907 | 2489907 | 2022-05-10 | Pima | Arizona | 4019 | 254912 | 3843 |
2486650 | 2486650 | 2022-05-09 | Pima | Arizona | 4019 | 254912 | 3843 |
2483392 | 2483392 | 2022-05-08 | Pima | Arizona | 4019 | 254912 | 3843 |
2480134 | 2480134 | 2022-05-07 | Pima | Arizona | 4019 | 254912 | 3843 |
2476876 | 2476876 | 2022-05-06 | Pima | Arizona | 4019 | 254912 | 3843 |
2473618 | 2473618 | 2022-05-05 | Pima | Arizona | 4019 | 254912 | 3843 |
2470361 | 2470361 | 2022-05-04 | Pima | Arizona | 4019 | 254912 | 3843 |
2467105 | 2467105 | 2022-05-03 | Pima | Arizona | 4019 | 254402 | 3815 |
2463850 | 2463850 | 2022-05-02 | Pima | Arizona | 4019 | 254402 | 3815 |
2460594 | 2460594 | 2022-05-01 | Pima | Arizona | 4019 | 254402 | 3815 |
2457338 | 2457338 | 2022-04-30 | Pima | Arizona | 4019 | 254402 | 3815 |
2454082 | 2454082 | 2022-04-29 | Pima | Arizona | 4019 | 254402 | 3815 |
2450826 | 2450826 | 2022-04-28 | Pima | Arizona | 4019 | 254402 | 3815 |
2447570 | 2447570 | 2022-04-27 | Pima | Arizona | 4019 | 254402 | 3815 |
2444314 | 2444314 | 2022-04-26 | Pima | Arizona | 4019 | 254407 | 3803 |
2441058 | 2441058 | 2022-04-25 | Pima | Arizona | 4019 | 254407 | 3803 |
2437802 | 2437802 | 2022-04-24 | Pima | Arizona | 4019 | 254407 | 3803 |
2434546 | 2434546 | 2022-04-23 | Pima | Arizona | 4019 | 254407 | 3803 |
2431290 | 2431290 | 2022-04-22 | Pima | Arizona | 4019 | 254407 | 3803 |
2428034 | 2428034 | 2022-04-21 | Pima | Arizona | 4019 | 254407 | 3803 |
2424778 | 2424778 | 2022-04-20 | Pima | Arizona | 4019 | 254407 | 3803 |
2421522 | 2421522 | 2022-04-19 | Pima | Arizona | 4019 | 254195 | 3802 |
2418266 | 2418266 | 2022-04-18 | Pima | Arizona | 4019 | 254195 | 3802 |
2415010 | 2415010 | 2022-04-17 | Pima | Arizona | 4019 | 254195 | 3802 |
2411754 | 2411754 | 2022-04-16 | Pima | Arizona | 4019 | 254195 | 3802 |
2408498 | 2408498 | 2022-04-15 | Pima | Arizona | 4019 | 254195 | 3802 |
2405242 | 2405242 | 2022-04-14 | Pima | Arizona | 4019 | 254195 | 3802 |
2401987 | 2401987 | 2022-04-13 | Pima | Arizona | 4019 | 254195 | 3802 |
2398732 | 2398732 | 2022-04-12 | Pima | Arizona | 4019 | 253451 | 3794 |
2395477 | 2395477 | 2022-04-11 | Pima | Arizona | 4019 | 253451 | 3794 |
2392221 | 2392221 | 2022-04-10 | Pima | Arizona | 4019 | 253451 | 3794 |
2388965 | 2388965 | 2022-04-09 | Pima | Arizona | 4019 | 253451 | 3794 |
2385710 | 2385710 | 2022-04-08 | Pima | Arizona | 4019 | 253451 | 3794 |
2382455 | 2382455 | 2022-04-07 | Pima | Arizona | 4019 | 253451 | 3794 |
2379200 | 2379200 | 2022-04-06 | Pima | Arizona | 4019 | 253451 | 3794 |
2375946 | 2375946 | 2022-04-05 | Pima | Arizona | 4019 | 252925 | 3773 |
2372694 | 2372694 | 2022-04-04 | Pima | Arizona | 4019 | 252925 | 3773 |
2369441 | 2369441 | 2022-04-03 | Pima | Arizona | 4019 | 252925 | 3773 |
2366188 | 2366188 | 2022-04-02 | Pima | Arizona | 4019 | 252925 | 3773 |
2362935 | 2362935 | 2022-04-01 | Pima | Arizona | 4019 | 252925 | 3773 |
2359681 | 2359681 | 2022-03-31 | Pima | Arizona | 4019 | 252925 | 3773 |
2356427 | 2356427 | 2022-03-30 | Pima | Arizona | 4019 | 252925 | 3773 |
2353174 | 2353174 | 2022-03-29 | Pima | Arizona | 4019 | 252256 | 3751 |
2349922 | 2349922 | 2022-03-28 | Pima | Arizona | 4019 | 252256 | 3751 |
2346669 | 2346669 | 2022-03-27 | Pima | Arizona | 4019 | 252256 | 3751 |
2343416 | 2343416 | 2022-03-26 | Pima | Arizona | 4019 | 252256 | 3751 |
2340163 | 2340163 | 2022-03-25 | Pima | Arizona | 4019 | 252256 | 3751 |
2336910 | 2336910 | 2022-03-24 | Pima | Arizona | 4019 | 252256 | 3751 |
2333656 | 2333656 | 2022-03-23 | Pima | Arizona | 4019 | 252256 | 3751 |
2330402 | 2330402 | 2022-03-22 | Pima | Arizona | 4019 | 251765 | 3722 |
2327150 | 2327150 | 2022-03-21 | Pima | Arizona | 4019 | 251765 | 3722 |
2323897 | 2323897 | 2022-03-20 | Pima | Arizona | 4019 | 251765 | 3722 |
2320643 | 2320643 | 2022-03-19 | Pima | Arizona | 4019 | 251765 | 3722 |
2317389 | 2317389 | 2022-03-18 | Pima | Arizona | 4019 | 251765 | 3722 |
2314136 | 2314136 | 2022-03-17 | Pima | Arizona | 4019 | 251765 | 3722 |
2310883 | 2310883 | 2022-03-16 | Pima | Arizona | 4019 | 251765 | 3722 |
2307630 | 2307630 | 2022-03-15 | Pima | Arizona | 4019 | 250949 | 3663 |
2304379 | 2304379 | 2022-03-14 | Pima | Arizona | 4019 | 250949 | 3663 |
2301127 | 2301127 | 2022-03-13 | Pima | Arizona | 4019 | 250949 | 3663 |
2297875 | 2297875 | 2022-03-12 | Pima | Arizona | 4019 | 250949 | 3663 |
2294623 | 2294623 | 2022-03-11 | Pima | Arizona | 4019 | 250949 | 3663 |
2291371 | 2291371 | 2022-03-10 | Pima | Arizona | 4019 | 250949 | 3663 |
2288119 | 2288119 | 2022-03-09 | Pima | Arizona | 4019 | 250949 | 3663 |
2284867 | 2284867 | 2022-03-08 | Pima | Arizona | 4019 | 250137 | 3646 |
2281615 | 2281615 | 2022-03-07 | Pima | Arizona | 4019 | 250137 | 3646 |
2278362 | 2278362 | 2022-03-06 | Pima | Arizona | 4019 | 250137 | 3646 |
2275109 | 2275109 | 2022-03-05 | Pima | Arizona | 4019 | 250137 | 3646 |
2271856 | 2271856 | 2022-03-04 | Pima | Arizona | 4019 | 250137 | 3646 |
2268604 | 2268604 | 2022-03-03 | Pima | Arizona | 4019 | 250137 | 3646 |
2265351 | 2265351 | 2022-03-02 | Pima | Arizona | 4019 | 250137 | 3646 |
2262101 | 2262101 | 2022-03-01 | Pima | Arizona | 4019 | 249678 | 3646 |
2258850 | 2258850 | 2022-02-28 | Pima | Arizona | 4019 | 249678 | 3646 |
2255599 | 2255599 | 2022-02-27 | Pima | Arizona | 4019 | 249678 | 3646 |
2252348 | 2252348 | 2022-02-26 | Pima | Arizona | 4019 | 249678 | 3646 |
2249097 | 2249097 | 2022-02-25 | Pima | Arizona | 4019 | 249449 | 3644 |
2245846 | 2245846 | 2022-02-24 | Pima | Arizona | 4019 | 249186 | 3639 |
2242595 | 2242595 | 2022-02-23 | Pima | Arizona | 4019 | 249002 | 3626 |
2239344 | 2239344 | 2022-02-22 | Pima | Arizona | 4019 | 248712 | 3623 |
2236093 | 2236093 | 2022-02-21 | Pima | Arizona | 4019 | 248248 | 3604 |
2232842 | 2232842 | 2022-02-20 | Pima | Arizona | 4019 | 248248 | 3604 |
2229591 | 2229591 | 2022-02-19 | Pima | Arizona | 4019 | 247896 | 3603 |
2226340 | 2226340 | 2022-02-18 | Pima | Arizona | 4019 | 247464 | 3597 |
2223089 | 2223089 | 2022-02-17 | Pima | Arizona | 4019 | 246962 | 3579 |
2219838 | 2219838 | 2022-02-16 | Pima | Arizona | 4019 | 246502 | 3554 |
2216587 | 2216587 | 2022-02-15 | Pima | Arizona | 4019 | 246181 | 3554 |
2213336 | 2213336 | 2022-02-14 | Pima | Arizona | 4019 | 245956 | 3554 |
2210084 | 2210084 | 2022-02-13 | Pima | Arizona | 4019 | 245532 | 3554 |
2206831 | 2206831 | 2022-02-12 | Pima | Arizona | 4019 | 244785 | 3553 |
2203578 | 2203578 | 2022-02-11 | Pima | Arizona | 4019 | 244051 | 3539 |
2200324 | 2200324 | 2022-02-10 | Pima | Arizona | 4019 | 243670 | 3539 |
2197070 | 2197070 | 2022-02-09 | Pima | Arizona | 4019 | 242519 | 3529 |
2193815 | 2193815 | 2022-02-08 | Pima | Arizona | 4019 | 241807 | 3523 |
2190562 | 2190562 | 2022-02-07 | Pima | Arizona | 4019 | 241551 | 3495 |
2187309 | 2187309 | 2022-02-06 | Pima | Arizona | 4019 | 240783 | 3495 |
2184056 | 2184056 | 2022-02-05 | Pima | Arizona | 4019 | 239935 | 3494 |
2180804 | 2180804 | 2022-02-04 | Pima | Arizona | 4019 | 238526 | 3484 |
2177553 | 2177553 | 2022-02-03 | Pima | Arizona | 4019 | 237193 | 3473 |
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);