ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 78 and state = "Arizona" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Arizona · 63 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1569815 | 1569815 | 2021-07-31 | La Paz | Arizona | 4012 | 2571 | 78 |
1566567 | 1566567 | 2021-07-30 | La Paz | Arizona | 4012 | 2570 | 78 |
1563319 | 1563319 | 2021-07-29 | La Paz | Arizona | 4012 | 2559 | 78 |
1560071 | 1560071 | 2021-07-28 | La Paz | Arizona | 4012 | 2552 | 78 |
1556824 | 1556824 | 2021-07-27 | La Paz | Arizona | 4012 | 2542 | 78 |
1553577 | 1553577 | 2021-07-26 | La Paz | Arizona | 4012 | 2541 | 78 |
1550330 | 1550330 | 2021-07-25 | La Paz | Arizona | 4012 | 2537 | 78 |
1547083 | 1547083 | 2021-07-24 | La Paz | Arizona | 4012 | 2533 | 78 |
1543836 | 1543836 | 2021-07-23 | La Paz | Arizona | 4012 | 2533 | 78 |
1540588 | 1540588 | 2021-07-22 | La Paz | Arizona | 4012 | 2527 | 78 |
1537341 | 1537341 | 2021-07-21 | La Paz | Arizona | 4012 | 2526 | 78 |
1534093 | 1534093 | 2021-07-20 | La Paz | Arizona | 4012 | 2522 | 78 |
1504870 | 1504870 | 2021-07-11 | La Paz | Arizona | 4012 | 2508 | 78 |
1501624 | 1501624 | 2021-07-10 | La Paz | Arizona | 4012 | 2506 | 78 |
1498378 | 1498378 | 2021-07-09 | La Paz | Arizona | 4012 | 2505 | 78 |
1495131 | 1495131 | 2021-07-08 | La Paz | Arizona | 4012 | 2499 | 78 |
1491884 | 1491884 | 2021-07-07 | La Paz | Arizona | 4012 | 2498 | 78 |
1488637 | 1488637 | 2021-07-06 | La Paz | Arizona | 4012 | 2497 | 78 |
1485390 | 1485390 | 2021-07-05 | La Paz | Arizona | 4012 | 2493 | 78 |
1482144 | 1482144 | 2021-07-04 | La Paz | Arizona | 4012 | 2493 | 78 |
1478897 | 1478897 | 2021-07-03 | La Paz | Arizona | 4012 | 2493 | 78 |
1475651 | 1475651 | 2021-07-02 | La Paz | Arizona | 4012 | 2492 | 78 |
1472405 | 1472405 | 2021-07-01 | La Paz | Arizona | 4012 | 2495 | 78 |
1469160 | 1469160 | 2021-06-30 | La Paz | Arizona | 4012 | 2495 | 78 |
1465915 | 1465915 | 2021-06-29 | La Paz | Arizona | 4012 | 2485 | 78 |
1462670 | 1462670 | 2021-06-28 | La Paz | Arizona | 4012 | 2485 | 78 |
1459425 | 1459425 | 2021-06-27 | La Paz | Arizona | 4012 | 2485 | 78 |
1456180 | 1456180 | 2021-06-26 | La Paz | Arizona | 4012 | 2485 | 78 |
1452935 | 1452935 | 2021-06-25 | La Paz | Arizona | 4012 | 2484 | 78 |
1449689 | 1449689 | 2021-06-24 | La Paz | Arizona | 4012 | 2484 | 78 |
1446444 | 1446444 | 2021-06-23 | La Paz | Arizona | 4012 | 2480 | 78 |
1443199 | 1443199 | 2021-06-22 | La Paz | Arizona | 4012 | 2480 | 78 |
1439954 | 1439954 | 2021-06-21 | La Paz | Arizona | 4012 | 2480 | 78 |
1436707 | 1436707 | 2021-06-20 | La Paz | Arizona | 4012 | 2480 | 78 |
1433460 | 1433460 | 2021-06-19 | La Paz | Arizona | 4012 | 2480 | 78 |
1280890 | 1280890 | 2021-05-03 | Graham | Arizona | 4009 | 5552 | 78 |
1277643 | 1277643 | 2021-05-02 | Graham | Arizona | 4009 | 5550 | 78 |
1274396 | 1274396 | 2021-05-01 | Graham | Arizona | 4009 | 5549 | 78 |
1222443 | 1222443 | 2021-04-15 | La Paz | Arizona | 4012 | 2448 | 78 |
1219195 | 1219195 | 2021-04-14 | La Paz | Arizona | 4012 | 2450 | 78 |
1215947 | 1215947 | 2021-04-13 | La Paz | Arizona | 4012 | 2450 | 78 |
1212700 | 1212700 | 2021-04-12 | La Paz | Arizona | 4012 | 2450 | 78 |
1209451 | 1209451 | 2021-04-11 | La Paz | Arizona | 4012 | 2450 | 78 |
1206203 | 1206203 | 2021-04-10 | La Paz | Arizona | 4012 | 2449 | 78 |
1202955 | 1202955 | 2021-04-09 | La Paz | Arizona | 4012 | 2449 | 78 |
1199707 | 1199707 | 2021-04-08 | La Paz | Arizona | 4012 | 2448 | 78 |
1196458 | 1196458 | 2021-04-07 | La Paz | Arizona | 4012 | 2448 | 78 |
1176972 | 1176972 | 2021-04-01 | La Paz | Arizona | 4012 | 2448 | 78 |
758269 | 758269 | 2020-11-23 | Cochise | Arizona | 4003 | 3137 | 78 |
755022 | 755022 | 2020-11-22 | Cochise | Arizona | 4003 | 3137 | 78 |
751776 | 751776 | 2020-11-21 | Cochise | Arizona | 4003 | 3079 | 78 |
748530 | 748530 | 2020-11-20 | Cochise | Arizona | 4003 | 3070 | 78 |
738792 | 738792 | 2020-11-17 | Gila | Arizona | 4007 | 2388 | 78 |
735548 | 735548 | 2020-11-16 | Gila | Arizona | 4007 | 2366 | 78 |
732302 | 732302 | 2020-11-15 | Gila | Arizona | 4007 | 2362 | 78 |
729057 | 729057 | 2020-11-14 | Gila | Arizona | 4007 | 2347 | 78 |
495716 | 495716 | 2020-09-03 | Yavapai | Arizona | 4025 | 2342 | 78 |
482781 | 482781 | 2020-08-30 | Yavapai | Arizona | 4025 | 2303 | 78 |
479547 | 479547 | 2020-08-29 | Yavapai | Arizona | 4025 | 2287 | 78 |
476314 | 476314 | 2020-08-28 | Yavapai | Arizona | 4025 | 2284 | 78 |
306132 | 306132 | 2020-07-06 | Pinal | Arizona | 4021 | 4600 | 78 |
268317 | 268317 | 2020-06-24 | Mohave | Arizona | 4015 | 841 | 78 |
95412 | 95412 | 2020-04-28 | Pima | Arizona | 4019 | 1188 | 78 |
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);