ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 4021 and state = "Arizona" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499682 | 2499682 | 2022-05-13 | Pinal | Arizona | 4021 | 132748 | 1666 |
2496424 | 2496424 | 2022-05-12 | Pinal | Arizona | 4021 | 132748 | 1666 |
2493166 | 2493166 | 2022-05-11 | Pinal | Arizona | 4021 | 132748 | 1666 |
2489908 | 2489908 | 2022-05-10 | Pinal | Arizona | 4021 | 132530 | 1665 |
2486651 | 2486651 | 2022-05-09 | Pinal | Arizona | 4021 | 132530 | 1665 |
2483393 | 2483393 | 2022-05-08 | Pinal | Arizona | 4021 | 132530 | 1665 |
2480135 | 2480135 | 2022-05-07 | Pinal | Arizona | 4021 | 132530 | 1665 |
2476877 | 2476877 | 2022-05-06 | Pinal | Arizona | 4021 | 132530 | 1665 |
2473619 | 2473619 | 2022-05-05 | Pinal | Arizona | 4021 | 132530 | 1665 |
2470362 | 2470362 | 2022-05-04 | Pinal | Arizona | 4021 | 132530 | 1665 |
2467106 | 2467106 | 2022-05-03 | Pinal | Arizona | 4021 | 132365 | 1651 |
2463851 | 2463851 | 2022-05-02 | Pinal | Arizona | 4021 | 132365 | 1651 |
2460595 | 2460595 | 2022-05-01 | Pinal | Arizona | 4021 | 132365 | 1651 |
2457339 | 2457339 | 2022-04-30 | Pinal | Arizona | 4021 | 132365 | 1651 |
2454083 | 2454083 | 2022-04-29 | Pinal | Arizona | 4021 | 132365 | 1651 |
2450827 | 2450827 | 2022-04-28 | Pinal | Arizona | 4021 | 132365 | 1651 |
2447571 | 2447571 | 2022-04-27 | Pinal | Arizona | 4021 | 132365 | 1651 |
2444315 | 2444315 | 2022-04-26 | Pinal | Arizona | 4021 | 132295 | 1645 |
2441059 | 2441059 | 2022-04-25 | Pinal | Arizona | 4021 | 132295 | 1645 |
2437803 | 2437803 | 2022-04-24 | Pinal | Arizona | 4021 | 132295 | 1645 |
2434547 | 2434547 | 2022-04-23 | Pinal | Arizona | 4021 | 132295 | 1645 |
2431291 | 2431291 | 2022-04-22 | Pinal | Arizona | 4021 | 132295 | 1645 |
2428035 | 2428035 | 2022-04-21 | Pinal | Arizona | 4021 | 132295 | 1645 |
2424779 | 2424779 | 2022-04-20 | Pinal | Arizona | 4021 | 132295 | 1645 |
2421523 | 2421523 | 2022-04-19 | Pinal | Arizona | 4021 | 132363 | 1646 |
2418267 | 2418267 | 2022-04-18 | Pinal | Arizona | 4021 | 132363 | 1646 |
2415011 | 2415011 | 2022-04-17 | Pinal | Arizona | 4021 | 132363 | 1646 |
2411755 | 2411755 | 2022-04-16 | Pinal | Arizona | 4021 | 132363 | 1646 |
2408499 | 2408499 | 2022-04-15 | Pinal | Arizona | 4021 | 132363 | 1646 |
2405243 | 2405243 | 2022-04-14 | Pinal | Arizona | 4021 | 132363 | 1646 |
2401988 | 2401988 | 2022-04-13 | Pinal | Arizona | 4021 | 132363 | 1646 |
2398733 | 2398733 | 2022-04-12 | Pinal | Arizona | 4021 | 131381 | 1619 |
2395478 | 2395478 | 2022-04-11 | Pinal | Arizona | 4021 | 131381 | 1619 |
2392222 | 2392222 | 2022-04-10 | Pinal | Arizona | 4021 | 131381 | 1619 |
2388966 | 2388966 | 2022-04-09 | Pinal | Arizona | 4021 | 131381 | 1619 |
2385711 | 2385711 | 2022-04-08 | Pinal | Arizona | 4021 | 131381 | 1619 |
2382456 | 2382456 | 2022-04-07 | Pinal | Arizona | 4021 | 131381 | 1619 |
2379201 | 2379201 | 2022-04-06 | Pinal | Arizona | 4021 | 131381 | 1619 |
2375947 | 2375947 | 2022-04-05 | Pinal | Arizona | 4021 | 130396 | 1594 |
2372695 | 2372695 | 2022-04-04 | Pinal | Arizona | 4021 | 130396 | 1594 |
2369442 | 2369442 | 2022-04-03 | Pinal | Arizona | 4021 | 130396 | 1594 |
2366189 | 2366189 | 2022-04-02 | Pinal | Arizona | 4021 | 130396 | 1594 |
2362936 | 2362936 | 2022-04-01 | Pinal | Arizona | 4021 | 130396 | 1594 |
2359682 | 2359682 | 2022-03-31 | Pinal | Arizona | 4021 | 130396 | 1594 |
2356428 | 2356428 | 2022-03-30 | Pinal | Arizona | 4021 | 130396 | 1594 |
2353175 | 2353175 | 2022-03-29 | Pinal | Arizona | 4021 | 129693 | 1582 |
2349923 | 2349923 | 2022-03-28 | Pinal | Arizona | 4021 | 129693 | 1582 |
2346670 | 2346670 | 2022-03-27 | Pinal | Arizona | 4021 | 129693 | 1582 |
2343417 | 2343417 | 2022-03-26 | Pinal | Arizona | 4021 | 129693 | 1582 |
2340164 | 2340164 | 2022-03-25 | Pinal | Arizona | 4021 | 129693 | 1582 |
2336911 | 2336911 | 2022-03-24 | Pinal | Arizona | 4021 | 129693 | 1582 |
2333657 | 2333657 | 2022-03-23 | Pinal | Arizona | 4021 | 129693 | 1582 |
2330403 | 2330403 | 2022-03-22 | Pinal | Arizona | 4021 | 129486 | 1566 |
2327151 | 2327151 | 2022-03-21 | Pinal | Arizona | 4021 | 129486 | 1566 |
2323898 | 2323898 | 2022-03-20 | Pinal | Arizona | 4021 | 129486 | 1566 |
2320644 | 2320644 | 2022-03-19 | Pinal | Arizona | 4021 | 129486 | 1566 |
2317390 | 2317390 | 2022-03-18 | Pinal | Arizona | 4021 | 129486 | 1566 |
2314137 | 2314137 | 2022-03-17 | Pinal | Arizona | 4021 | 129486 | 1566 |
2310884 | 2310884 | 2022-03-16 | Pinal | Arizona | 4021 | 129486 | 1566 |
2307631 | 2307631 | 2022-03-15 | Pinal | Arizona | 4021 | 129241 | 1549 |
2304380 | 2304380 | 2022-03-14 | Pinal | Arizona | 4021 | 129241 | 1549 |
2301128 | 2301128 | 2022-03-13 | Pinal | Arizona | 4021 | 129241 | 1549 |
2297876 | 2297876 | 2022-03-12 | Pinal | Arizona | 4021 | 129241 | 1549 |
2294624 | 2294624 | 2022-03-11 | Pinal | Arizona | 4021 | 129241 | 1549 |
2291372 | 2291372 | 2022-03-10 | Pinal | Arizona | 4021 | 129241 | 1549 |
2288120 | 2288120 | 2022-03-09 | Pinal | Arizona | 4021 | 129241 | 1549 |
2284868 | 2284868 | 2022-03-08 | Pinal | Arizona | 4021 | 128929 | 1544 |
2281616 | 2281616 | 2022-03-07 | Pinal | Arizona | 4021 | 128929 | 1544 |
2278363 | 2278363 | 2022-03-06 | Pinal | Arizona | 4021 | 128929 | 1544 |
2275110 | 2275110 | 2022-03-05 | Pinal | Arizona | 4021 | 128929 | 1544 |
2271857 | 2271857 | 2022-03-04 | Pinal | Arizona | 4021 | 128929 | 1544 |
2268605 | 2268605 | 2022-03-03 | Pinal | Arizona | 4021 | 128929 | 1544 |
2265352 | 2265352 | 2022-03-02 | Pinal | Arizona | 4021 | 128929 | 1544 |
2262102 | 2262102 | 2022-03-01 | Pinal | Arizona | 4021 | 128726 | 1544 |
2258851 | 2258851 | 2022-02-28 | Pinal | Arizona | 4021 | 128726 | 1544 |
2255600 | 2255600 | 2022-02-27 | Pinal | Arizona | 4021 | 128726 | 1544 |
2252349 | 2252349 | 2022-02-26 | Pinal | Arizona | 4021 | 128726 | 1544 |
2249098 | 2249098 | 2022-02-25 | Pinal | Arizona | 4021 | 128636 | 1542 |
2245847 | 2245847 | 2022-02-24 | Pinal | Arizona | 4021 | 128537 | 1539 |
2242596 | 2242596 | 2022-02-23 | Pinal | Arizona | 4021 | 128467 | 1531 |
2239345 | 2239345 | 2022-02-22 | Pinal | Arizona | 4021 | 128386 | 1530 |
2236094 | 2236094 | 2022-02-21 | Pinal | Arizona | 4021 | 128186 | 1523 |
2232843 | 2232843 | 2022-02-20 | Pinal | Arizona | 4021 | 128181 | 1523 |
2229592 | 2229592 | 2022-02-19 | Pinal | Arizona | 4021 | 128025 | 1522 |
2226341 | 2226341 | 2022-02-18 | Pinal | Arizona | 4021 | 127862 | 1518 |
2223090 | 2223090 | 2022-02-17 | Pinal | Arizona | 4021 | 127706 | 1516 |
2219839 | 2219839 | 2022-02-16 | Pinal | Arizona | 4021 | 127523 | 1498 |
2216588 | 2216588 | 2022-02-15 | Pinal | Arizona | 4021 | 127319 | 1499 |
2213337 | 2213337 | 2022-02-14 | Pinal | Arizona | 4021 | 127193 | 1499 |
2210085 | 2210085 | 2022-02-13 | Pinal | Arizona | 4021 | 126941 | 1499 |
2206832 | 2206832 | 2022-02-12 | Pinal | Arizona | 4021 | 126672 | 1499 |
2203579 | 2203579 | 2022-02-11 | Pinal | Arizona | 4021 | 126437 | 1494 |
2200325 | 2200325 | 2022-02-10 | Pinal | Arizona | 4021 | 126347 | 1491 |
2197071 | 2197071 | 2022-02-09 | Pinal | Arizona | 4021 | 125706 | 1480 |
2193816 | 2193816 | 2022-02-08 | Pinal | Arizona | 4021 | 125376 | 1478 |
2190563 | 2190563 | 2022-02-07 | Pinal | Arizona | 4021 | 125067 | 1466 |
2187310 | 2187310 | 2022-02-06 | Pinal | Arizona | 4021 | 124625 | 1466 |
2184057 | 2184057 | 2022-02-05 | Pinal | Arizona | 4021 | 124304 | 1466 |
2180805 | 2180805 | 2022-02-04 | Pinal | Arizona | 4021 | 123764 | 1457 |
2177554 | 2177554 | 2022-02-03 | Pinal | Arizona | 4021 | 123035 | 1453 |
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);