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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
865 | 865 | 2020-03-09 | Pima | Arizona | 4019 | 1 | 0 |
997 | 997 | 2020-03-10 | Pima | Arizona | 4019 | 1 | 0 |
1162 | 1162 | 2020-03-11 | Pima | Arizona | 4019 | 1 | 0 |
1367 | 1367 | 2020-03-12 | Pima | Arizona | 4019 | 1 | 0 |
1627 | 1627 | 2020-03-13 | Pima | Arizona | 4019 | 1 | 0 |
1944 | 1944 | 2020-03-14 | Pima | Arizona | 4019 | 2 | 0 |
2321 | 2321 | 2020-03-15 | Pima | Arizona | 4019 | 3 | 0 |
2751 | 2751 | 2020-03-16 | Pima | Arizona | 4019 | 4 | 0 |
3231 | 3231 | 2020-03-17 | Pima | Arizona | 4019 | 4 | 0 |
3781 | 3781 | 2020-03-18 | Pima | Arizona | 4019 | 5 | 0 |
4424 | 4424 | 2020-03-19 | Pima | Arizona | 4019 | 7 | 0 |
5195 | 5195 | 2020-03-20 | Pima | Arizona | 4019 | 8 | 0 |
6114 | 6114 | 2020-03-21 | Pima | Arizona | 4019 | 12 | 0 |
7148 | 7148 | 2020-03-22 | Pima | Arizona | 4019 | 17 | 0 |
8291 | 8291 | 2020-03-23 | Pima | Arizona | 4019 | 24 | 0 |
9519 | 9519 | 2020-03-24 | Pima | Arizona | 4019 | 42 | 0 |
10889 | 10889 | 2020-03-25 | Pima | Arizona | 4019 | 49 | 0 |
12430 | 12430 | 2020-03-26 | Pima | Arizona | 4019 | 75 | 0 |
14093 | 14093 | 2020-03-27 | Pima | Arizona | 4019 | 102 | 4 |
15873 | 15873 | 2020-03-28 | Pima | Arizona | 4019 | 120 | 5 |
17757 | 17757 | 2020-03-29 | Pima | Arizona | 4019 | 153 | 6 |
19731 | 19731 | 2020-03-30 | Pima | Arizona | 4019 | 187 | 6 |
21803 | 21803 | 2020-03-31 | Pima | Arizona | 4019 | 202 | 6 |
23959 | 23959 | 2020-04-01 | Pima | Arizona | 4019 | 217 | 10 |
26183 | 26183 | 2020-04-02 | Pima | Arizona | 4019 | 237 | 11 |
28480 | 28480 | 2020-04-03 | Pima | Arizona | 4019 | 280 | 11 |
30837 | 30837 | 2020-04-04 | Pima | Arizona | 4019 | 326 | 12 |
33241 | 33241 | 2020-04-05 | Pima | Arizona | 4019 | 372 | 12 |
35681 | 35681 | 2020-04-06 | Pima | Arizona | 4019 | 415 | 13 |
38170 | 38170 | 2020-04-07 | Pima | Arizona | 4019 | 415 | 13 |
40713 | 40713 | 2020-04-08 | Pima | Arizona | 4019 | 464 | 16 |
43286 | 43286 | 2020-04-09 | Pima | Arizona | 4019 | 512 | 20 |
45884 | 45884 | 2020-04-10 | Pima | Arizona | 4019 | 543 | 20 |
48514 | 48514 | 2020-04-11 | Pima | Arizona | 4019 | 591 | 29 |
51176 | 51176 | 2020-04-12 | Pima | Arizona | 4019 | 622 | 29 |
53854 | 53854 | 2020-04-13 | Pima | Arizona | 4019 | 668 | 29 |
56546 | 56546 | 2020-04-14 | Pima | Arizona | 4019 | 685 | 32 |
59255 | 59255 | 2020-04-15 | Pima | Arizona | 4019 | 700 | 34 |
61974 | 61974 | 2020-04-16 | Pima | Arizona | 4019 | 760 | 37 |
64707 | 64707 | 2020-04-17 | Pima | Arizona | 4019 | 819 | 51 |
67455 | 67455 | 2020-04-18 | Pima | Arizona | 4019 | 856 | 56 |
70217 | 70217 | 2020-04-19 | Pima | Arizona | 4019 | 913 | 56 |
72986 | 72986 | 2020-04-20 | Pima | Arizona | 4019 | 941 | 58 |
75762 | 75762 | 2020-04-21 | Pima | Arizona | 4019 | 963 | 65 |
78545 | 78545 | 2020-04-22 | Pima | Arizona | 4019 | 973 | 68 |
81338 | 81338 | 2020-04-23 | Pima | Arizona | 4019 | 1026 | 70 |
84139 | 84139 | 2020-04-24 | Pima | Arizona | 4019 | 1060 | 74 |
86947 | 86947 | 2020-04-25 | Pima | Arizona | 4019 | 1090 | 76 |
89764 | 89764 | 2020-04-26 | Pima | Arizona | 4019 | 1136 | 76 |
92582 | 92582 | 2020-04-27 | Pima | Arizona | 4019 | 1164 | 76 |
95412 | 95412 | 2020-04-28 | Pima | Arizona | 4019 | 1188 | 78 |
98257 | 98257 | 2020-04-29 | Pima | Arizona | 4019 | 1215 | 80 |
101107 | 101107 | 2020-04-30 | Pima | Arizona | 4019 | 1241 | 80 |
103962 | 103962 | 2020-05-01 | Pima | Arizona | 4019 | 1267 | 81 |
106827 | 106827 | 2020-05-02 | Pima | Arizona | 4019 | 1300 | 89 |
109696 | 109696 | 2020-05-03 | Pima | Arizona | 4019 | 1326 | 89 |
112571 | 112571 | 2020-05-04 | Pima | Arizona | 4019 | 1346 | 89 |
115454 | 115454 | 2020-05-05 | Pima | Arizona | 4019 | 1379 | 105 |
118413 | 118413 | 2020-05-06 | Pima | Arizona | 4019 | 1425 | 116 |
121380 | 121380 | 2020-05-07 | Pima | Arizona | 4019 | 1465 | 118 |
124360 | 124360 | 2020-05-08 | Pima | Arizona | 4019 | 1520 | 131 |
127345 | 127345 | 2020-05-09 | Pima | Arizona | 4019 | 1554 | 133 |
130335 | 130335 | 2020-05-10 | Pima | Arizona | 4019 | 1585 | 134 |
133325 | 133325 | 2020-05-11 | Pima | Arizona | 4019 | 1602 | 134 |
136315 | 136315 | 2020-05-12 | Pima | Arizona | 4019 | 1623 | 136 |
139306 | 139306 | 2020-05-13 | Pima | Arizona | 4019 | 1661 | 144 |
142302 | 142302 | 2020-05-14 | Pima | Arizona | 4019 | 1696 | 152 |
145301 | 145301 | 2020-05-15 | Pima | Arizona | 4019 | 1750 | 155 |
148304 | 148304 | 2020-05-16 | Pima | Arizona | 4019 | 1781 | 157 |
151313 | 151313 | 2020-05-17 | Pima | Arizona | 4019 | 1814 | 157 |
154325 | 154325 | 2020-05-18 | Pima | Arizona | 4019 | 1825 | 157 |
157341 | 157341 | 2020-05-19 | Pima | Arizona | 4019 | 1888 | 158 |
160367 | 160367 | 2020-05-20 | Pima | Arizona | 4019 | 1903 | 167 |
163395 | 163395 | 2020-05-21 | Pima | Arizona | 4019 | 1944 | 174 |
166427 | 166427 | 2020-05-22 | Pima | Arizona | 4019 | 1974 | 174 |
169463 | 169463 | 2020-05-23 | Pima | Arizona | 4019 | 2002 | 174 |
172504 | 172504 | 2020-05-24 | Pima | Arizona | 4019 | 2027 | 173 |
175547 | 175547 | 2020-05-25 | Pima | Arizona | 4019 | 2046 | 173 |
178592 | 178592 | 2020-05-26 | Pima | Arizona | 4019 | 2075 | 173 |
181636 | 181636 | 2020-05-27 | Pima | Arizona | 4019 | 2119 | 175 |
184689 | 184689 | 2020-05-28 | Pima | Arizona | 4019 | 2167 | 186 |
187746 | 187746 | 2020-05-29 | Pima | Arizona | 4019 | 2234 | 185 |
190811 | 190811 | 2020-05-30 | Pima | Arizona | 4019 | 2290 | 185 |
193878 | 193878 | 2020-05-31 | Pima | Arizona | 4019 | 2368 | 185 |
196948 | 196948 | 2020-06-01 | Pima | Arizona | 4019 | 2382 | 185 |
200021 | 200021 | 2020-06-02 | Pima | Arizona | 4019 | 2496 | 191 |
203097 | 203097 | 2020-06-03 | Pima | Arizona | 4019 | 2627 | 196 |
206177 | 206177 | 2020-06-04 | Pima | Arizona | 4019 | 2669 | 202 |
209258 | 209258 | 2020-06-05 | Pima | Arizona | 4019 | 2883 | 202 |
212343 | 212343 | 2020-06-06 | Pima | Arizona | 4019 | 2950 | 205 |
215430 | 215430 | 2020-06-07 | Pima | Arizona | 4019 | 3098 | 205 |
218521 | 218521 | 2020-06-08 | Pima | Arizona | 4019 | 3154 | 205 |
221616 | 221616 | 2020-06-09 | Pima | Arizona | 4019 | 3161 | 212 |
224711 | 224711 | 2020-06-10 | Pima | Arizona | 4019 | 3350 | 216 |
227813 | 227813 | 2020-06-11 | Pima | Arizona | 4019 | 3483 | 218 |
230916 | 230916 | 2020-06-12 | Pima | Arizona | 4019 | 3628 | 222 |
234022 | 234022 | 2020-06-13 | Pima | Arizona | 4019 | 3889 | 223 |
237129 | 237129 | 2020-06-14 | Pima | Arizona | 4019 | 3910 | 223 |
240237 | 240237 | 2020-06-15 | Pima | Arizona | 4019 | 3944 | 223 |
243348 | 243348 | 2020-06-16 | Pima | Arizona | 4019 | 4329 | 226 |
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);