ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Pinal" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
583 | 583 | 2020-03-06 | Pinal | Arizona | 4021 | 1 | 0 |
657 | 657 | 2020-03-07 | Pinal | Arizona | 4021 | 3 | 0 |
752 | 752 | 2020-03-08 | Pinal | Arizona | 4021 | 3 | 0 |
866 | 866 | 2020-03-09 | Pinal | Arizona | 4021 | 3 | 0 |
998 | 998 | 2020-03-10 | Pinal | Arizona | 4021 | 3 | 0 |
1163 | 1163 | 2020-03-11 | Pinal | Arizona | 4021 | 5 | 0 |
1368 | 1368 | 2020-03-12 | Pinal | Arizona | 4021 | 5 | 0 |
1628 | 1628 | 2020-03-13 | Pinal | Arizona | 4021 | 5 | 0 |
1945 | 1945 | 2020-03-14 | Pinal | Arizona | 4021 | 5 | 0 |
2322 | 2322 | 2020-03-15 | Pinal | Arizona | 4021 | 5 | 0 |
2752 | 2752 | 2020-03-16 | Pinal | Arizona | 4021 | 5 | 0 |
3232 | 3232 | 2020-03-17 | Pinal | Arizona | 4021 | 5 | 0 |
3782 | 3782 | 2020-03-18 | Pinal | Arizona | 4021 | 8 | 0 |
4425 | 4425 | 2020-03-19 | Pinal | Arizona | 4021 | 10 | 0 |
5196 | 5196 | 2020-03-20 | Pinal | Arizona | 4021 | 10 | 0 |
6115 | 6115 | 2020-03-21 | Pinal | Arizona | 4021 | 14 | 0 |
7149 | 7149 | 2020-03-22 | Pinal | Arizona | 4021 | 16 | 0 |
8292 | 8292 | 2020-03-23 | Pinal | Arizona | 4021 | 17 | 0 |
9520 | 9520 | 2020-03-24 | Pinal | Arizona | 4021 | 22 | 0 |
10890 | 10890 | 2020-03-25 | Pinal | Arizona | 4021 | 23 | 0 |
12431 | 12431 | 2020-03-26 | Pinal | Arizona | 4021 | 35 | 0 |
14094 | 14094 | 2020-03-27 | Pinal | Arizona | 4021 | 36 | 0 |
15874 | 15874 | 2020-03-28 | Pinal | Arizona | 4021 | 41 | 0 |
17758 | 17758 | 2020-03-29 | Pinal | Arizona | 4021 | 51 | 0 |
19732 | 19732 | 2020-03-30 | Pinal | Arizona | 4021 | 64 | 0 |
21804 | 21804 | 2020-03-31 | Pinal | Arizona | 4021 | 62 | 0 |
23960 | 23960 | 2020-04-01 | Pinal | Arizona | 4021 | 65 | 0 |
26184 | 26184 | 2020-04-02 | Pinal | Arizona | 4021 | 69 | 0 |
28481 | 28481 | 2020-04-03 | Pinal | Arizona | 4021 | 77 | 0 |
30838 | 30838 | 2020-04-04 | Pinal | Arizona | 4021 | 89 | 0 |
33242 | 33242 | 2020-04-05 | Pinal | Arizona | 4021 | 103 | 0 |
35682 | 35682 | 2020-04-06 | Pinal | Arizona | 4021 | 107 | 0 |
38171 | 38171 | 2020-04-07 | Pinal | Arizona | 4021 | 120 | 0 |
40714 | 40714 | 2020-04-08 | Pinal | Arizona | 4021 | 124 | 0 |
43287 | 43287 | 2020-04-09 | Pinal | Arizona | 4021 | 137 | 3 |
45885 | 45885 | 2020-04-10 | Pinal | Arizona | 4021 | 138 | 3 |
48515 | 48515 | 2020-04-11 | Pinal | Arizona | 4021 | 146 | 3 |
51177 | 51177 | 2020-04-12 | Pinal | Arizona | 4021 | 163 | 4 |
53855 | 53855 | 2020-04-13 | Pinal | Arizona | 4021 | 168 | 4 |
56547 | 56547 | 2020-04-14 | Pinal | Arizona | 4021 | 175 | 5 |
59256 | 59256 | 2020-04-15 | Pinal | Arizona | 4021 | 182 | 5 |
61975 | 61975 | 2020-04-16 | Pinal | Arizona | 4021 | 197 | 5 |
64708 | 64708 | 2020-04-17 | Pinal | Arizona | 4021 | 212 | 5 |
67456 | 67456 | 2020-04-18 | Pinal | Arizona | 4021 | 235 | 6 |
70218 | 70218 | 2020-04-19 | Pinal | Arizona | 4021 | 247 | 7 |
72987 | 72987 | 2020-04-20 | Pinal | Arizona | 4021 | 256 | 7 |
75763 | 75763 | 2020-04-21 | Pinal | Arizona | 4021 | 268 | 7 |
78546 | 78546 | 2020-04-22 | Pinal | Arizona | 4021 | 283 | 8 |
81339 | 81339 | 2020-04-23 | Pinal | Arizona | 4021 | 303 | 8 |
84140 | 84140 | 2020-04-24 | Pinal | Arizona | 4021 | 317 | 9 |
86948 | 86948 | 2020-04-25 | Pinal | Arizona | 4021 | 332 | 9 |
89765 | 89765 | 2020-04-26 | Pinal | Arizona | 4021 | 342 | 9 |
92583 | 92583 | 2020-04-27 | Pinal | Arizona | 4021 | 359 | 9 |
95413 | 95413 | 2020-04-28 | Pinal | Arizona | 4021 | 365 | 9 |
98258 | 98258 | 2020-04-29 | Pinal | Arizona | 4021 | 387 | 11 |
101108 | 101108 | 2020-04-30 | Pinal | Arizona | 4021 | 397 | 11 |
103963 | 103963 | 2020-05-01 | Pinal | Arizona | 4021 | 417 | 13 |
106828 | 106828 | 2020-05-02 | Pinal | Arizona | 4021 | 435 | 13 |
109697 | 109697 | 2020-05-03 | Pinal | Arizona | 4021 | 456 | 13 |
112572 | 112572 | 2020-05-04 | Pinal | Arizona | 4021 | 468 | 13 |
115455 | 115455 | 2020-05-05 | Pinal | Arizona | 4021 | 478 | 15 |
118414 | 118414 | 2020-05-06 | Pinal | Arizona | 4021 | 497 | 15 |
121381 | 121381 | 2020-05-07 | Pinal | Arizona | 4021 | 530 | 15 |
124361 | 124361 | 2020-05-08 | Pinal | Arizona | 4021 | 566 | 19 |
127346 | 127346 | 2020-05-09 | Pinal | Arizona | 4021 | 585 | 19 |
130336 | 130336 | 2020-05-10 | Pinal | Arizona | 4021 | 600 | 19 |
133326 | 133326 | 2020-05-11 | Pinal | Arizona | 4021 | 620 | 19 |
136316 | 136316 | 2020-05-12 | Pinal | Arizona | 4021 | 636 | 20 |
139307 | 139307 | 2020-05-13 | Pinal | Arizona | 4021 | 643 | 20 |
142303 | 142303 | 2020-05-14 | Pinal | Arizona | 4021 | 650 | 28 |
145302 | 145302 | 2020-05-15 | Pinal | Arizona | 4021 | 670 | 28 |
148305 | 148305 | 2020-05-16 | Pinal | Arizona | 4021 | 678 | 31 |
151314 | 151314 | 2020-05-17 | Pinal | Arizona | 4021 | 693 | 31 |
154326 | 154326 | 2020-05-18 | Pinal | Arizona | 4021 | 702 | 31 |
157342 | 157342 | 2020-05-19 | Pinal | Arizona | 4021 | 720 | 32 |
160368 | 160368 | 2020-05-20 | Pinal | Arizona | 4021 | 724 | 37 |
163396 | 163396 | 2020-05-21 | Pinal | Arizona | 4021 | 732 | 37 |
166428 | 166428 | 2020-05-22 | Pinal | Arizona | 4021 | 749 | 37 |
169464 | 169464 | 2020-05-23 | Pinal | Arizona | 4021 | 751 | 37 |
172505 | 172505 | 2020-05-24 | Pinal | Arizona | 4021 | 755 | 37 |
175548 | 175548 | 2020-05-25 | Pinal | Arizona | 4021 | 764 | 37 |
178593 | 178593 | 2020-05-26 | Pinal | Arizona | 4021 | 766 | 37 |
181637 | 181637 | 2020-05-27 | Pinal | Arizona | 4021 | 777 | 37 |
184690 | 184690 | 2020-05-28 | Pinal | Arizona | 4021 | 788 | 37 |
187747 | 187747 | 2020-05-29 | Pinal | Arizona | 4021 | 814 | 39 |
190812 | 190812 | 2020-05-30 | Pinal | Arizona | 4021 | 837 | 39 |
193879 | 193879 | 2020-05-31 | Pinal | Arizona | 4021 | 863 | 39 |
200022 | 200022 | 2020-06-02 | Pinal | Arizona | 4021 | 909 | 39 |
203098 | 203098 | 2020-06-03 | Pinal | Arizona | 4021 | 940 | 39 |
196949 | 196949 | 2020-06-01 | Pinal | Arizona | 4021 | 865 | 40 |
206178 | 206178 | 2020-06-04 | Pinal | Arizona | 4021 | 948 | 40 |
209259 | 209259 | 2020-06-05 | Pinal | Arizona | 4021 | 1018 | 41 |
212344 | 212344 | 2020-06-06 | Pinal | Arizona | 4021 | 1067 | 41 |
215431 | 215431 | 2020-06-07 | Pinal | Arizona | 4021 | 1112 | 41 |
218522 | 218522 | 2020-06-08 | Pinal | Arizona | 4021 | 1127 | 41 |
221617 | 221617 | 2020-06-09 | Pinal | Arizona | 4021 | 1164 | 41 |
224712 | 224712 | 2020-06-10 | Pinal | Arizona | 4021 | 1209 | 42 |
227814 | 227814 | 2020-06-11 | Pinal | Arizona | 4021 | 1281 | 42 |
230917 | 230917 | 2020-06-12 | Pinal | Arizona | 4021 | 1363 | 43 |
234023 | 234023 | 2020-06-13 | Pinal | Arizona | 4021 | 1500 | 44 |
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);