ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 4013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
280886 | 280886 | 2020-06-28 | Maricopa | Arizona | 4013 | 44962 | 746 |
277739 | 277739 | 2020-06-27 | Maricopa | Arizona | 4013 | 42374 | 741 |
274591 | 274591 | 2020-06-26 | Maricopa | Arizona | 4013 | 39626 | 718 |
271451 | 271451 | 2020-06-25 | Maricopa | Arizona | 4013 | 37135 | 694 |
268316 | 268316 | 2020-06-24 | Maricopa | Arizona | 4013 | 34993 | 690 |
265186 | 265186 | 2020-06-23 | Maricopa | Arizona | 4013 | 33883 | 663 |
262058 | 262058 | 2020-06-22 | Maricopa | Arizona | 4013 | 31650 | 634 |
258931 | 258931 | 2020-06-21 | Maricopa | Arizona | 4013 | 30136 | 632 |
255804 | 255804 | 2020-06-20 | Maricopa | Arizona | 4013 | 28303 | 633 |
252685 | 252685 | 2020-06-19 | Maricopa | Arizona | 4013 | 25999 | 615 |
249570 | 249570 | 2020-06-18 | Maricopa | Arizona | 4013 | 23890 | 598 |
246458 | 246458 | 2020-06-17 | Maricopa | Arizona | 4013 | 22272 | 579 |
243345 | 243345 | 2020-06-16 | Maricopa | Arizona | 4013 | 20775 | 568 |
240234 | 240234 | 2020-06-15 | Maricopa | Arizona | 4013 | 19372 | 557 |
237126 | 237126 | 2020-06-14 | Maricopa | Arizona | 4013 | 18692 | 551 |
234019 | 234019 | 2020-06-13 | Maricopa | Arizona | 4013 | 17791 | 549 |
230913 | 230913 | 2020-06-12 | Maricopa | Arizona | 4013 | 17023 | 536 |
227810 | 227810 | 2020-06-11 | Maricopa | Arizona | 4013 | 16148 | 532 |
224708 | 224708 | 2020-06-10 | Maricopa | Arizona | 4013 | 15282 | 519 |
221613 | 221613 | 2020-06-09 | Maricopa | Arizona | 4013 | 14374 | 504 |
218518 | 218518 | 2020-06-08 | Maricopa | Arizona | 4013 | 14003 | 491 |
215427 | 215427 | 2020-06-07 | Maricopa | Arizona | 4013 | 13498 | 490 |
212340 | 212340 | 2020-06-06 | Maricopa | Arizona | 4013 | 12761 | 489 |
209255 | 209255 | 2020-06-05 | Maricopa | Arizona | 4013 | 12091 | 479 |
206174 | 206174 | 2020-06-04 | Maricopa | Arizona | 4013 | 11229 | 471 |
203094 | 203094 | 2020-06-03 | Maricopa | Arizona | 4013 | 11068 | 466 |
200018 | 200018 | 2020-06-02 | Maricopa | Arizona | 4013 | 10536 | 448 |
196945 | 196945 | 2020-06-01 | Maricopa | Arizona | 4013 | 9937 | 433 |
193875 | 193875 | 2020-05-31 | Maricopa | Arizona | 4013 | 9815 | 432 |
190808 | 190808 | 2020-05-30 | Maricopa | Arizona | 4013 | 9522 | 430 |
187743 | 187743 | 2020-05-29 | Maricopa | Arizona | 4013 | 9112 | 419 |
184686 | 184686 | 2020-05-28 | Maricopa | Arizona | 4013 | 8896 | 403 |
181633 | 181633 | 2020-05-27 | Maricopa | Arizona | 4013 | 8627 | 397 |
178589 | 178589 | 2020-05-26 | Maricopa | Arizona | 4013 | 8448 | 384 |
175544 | 175544 | 2020-05-25 | Maricopa | Arizona | 4013 | 8379 | 385 |
172501 | 172501 | 2020-05-24 | Maricopa | Arizona | 4013 | 8277 | 384 |
169460 | 169460 | 2020-05-23 | Maricopa | Arizona | 4013 | 8177 | 383 |
166424 | 166424 | 2020-05-22 | Maricopa | Arizona | 4013 | 7950 | 368 |
163392 | 163392 | 2020-05-21 | Maricopa | Arizona | 4013 | 7835 | 361 |
160364 | 160364 | 2020-05-20 | Maricopa | Arizona | 4013 | 7644 | 357 |
157338 | 157338 | 2020-05-19 | Maricopa | Arizona | 4013 | 7482 | 339 |
154322 | 154322 | 2020-05-18 | Maricopa | Arizona | 4013 | 7340 | 324 |
151310 | 151310 | 2020-05-17 | Maricopa | Arizona | 4013 | 7240 | 319 |
148301 | 148301 | 2020-05-16 | Maricopa | Arizona | 4013 | 7096 | 319 |
145298 | 145298 | 2020-05-15 | Maricopa | Arizona | 4013 | 6821 | 302 |
142299 | 142299 | 2020-05-14 | Maricopa | Arizona | 4013 | 6599 | 292 |
139303 | 139303 | 2020-05-13 | Maricopa | Arizona | 4013 | 6341 | 281 |
136312 | 136312 | 2020-05-12 | Maricopa | Arizona | 4013 | 6219 | 259 |
133322 | 133322 | 2020-05-11 | Maricopa | Arizona | 4013 | 5988 | 250 |
130332 | 130332 | 2020-05-10 | Maricopa | Arizona | 4013 | 5827 | 247 |
127342 | 127342 | 2020-05-09 | Maricopa | Arizona | 4013 | 5779 | 245 |
124357 | 124357 | 2020-05-08 | Maricopa | Arizona | 4013 | 5525 | 238 |
121377 | 121377 | 2020-05-07 | Maricopa | Arizona | 4013 | 5196 | 204 |
118410 | 118410 | 2020-05-06 | Maricopa | Arizona | 4013 | 5138 | 186 |
115451 | 115451 | 2020-05-05 | Maricopa | Arizona | 4013 | 4929 | 175 |
112568 | 112568 | 2020-05-04 | Maricopa | Arizona | 4013 | 4751 | 168 |
109693 | 109693 | 2020-05-03 | Maricopa | Arizona | 4013 | 4585 | 168 |
106824 | 106824 | 2020-05-02 | Maricopa | Arizona | 4013 | 4421 | 159 |
103959 | 103959 | 2020-05-01 | Maricopa | Arizona | 4013 | 4156 | 147 |
101104 | 101104 | 2020-04-30 | Maricopa | Arizona | 4013 | 3972 | 145 |
98254 | 98254 | 2020-04-29 | Maricopa | Arizona | 4013 | 3723 | 140 |
95409 | 95409 | 2020-04-28 | Maricopa | Arizona | 4013 | 3578 | 137 |
92579 | 92579 | 2020-04-27 | Maricopa | Arizona | 4013 | 3457 | 122 |
89761 | 89761 | 2020-04-26 | Maricopa | Arizona | 4013 | 3359 | 122 |
86944 | 86944 | 2020-04-25 | Maricopa | Arizona | 4013 | 3234 | 121 |
84136 | 84136 | 2020-04-24 | Maricopa | Arizona | 4013 | 3116 | 120 |
81335 | 81335 | 2020-04-23 | Maricopa | Arizona | 4013 | 2970 | 115 |
78542 | 78542 | 2020-04-22 | Maricopa | Arizona | 4013 | 2846 | 97 |
75759 | 75759 | 2020-04-21 | Maricopa | Arizona | 4013 | 2738 | 84 |
72983 | 72983 | 2020-04-20 | Maricopa | Arizona | 4013 | 2636 | 75 |
70214 | 70214 | 2020-04-19 | Maricopa | Arizona | 4013 | 2589 | 75 |
67452 | 67452 | 2020-04-18 | Maricopa | Arizona | 4013 | 2491 | 70 |
64704 | 64704 | 2020-04-17 | Maricopa | Arizona | 4013 | 2404 | 69 |
61971 | 61971 | 2020-04-16 | Maricopa | Arizona | 4013 | 2264 | 64 |
59252 | 59252 | 2020-04-15 | Maricopa | Arizona | 4013 | 2146 | 60 |
56543 | 56543 | 2020-04-14 | Maricopa | Arizona | 4013 | 2056 | 54 |
53851 | 53851 | 2020-04-13 | Maricopa | Arizona | 4013 | 2020 | 52 |
51173 | 51173 | 2020-04-12 | Maricopa | Arizona | 4013 | 1960 | 48 |
48511 | 48511 | 2020-04-11 | Maricopa | Arizona | 4013 | 1891 | 47 |
45881 | 45881 | 2020-04-10 | Maricopa | Arizona | 4013 | 1741 | 41 |
43283 | 43283 | 2020-04-09 | Maricopa | Arizona | 4013 | 1689 | 39 |
40710 | 40710 | 2020-04-08 | Maricopa | Arizona | 4013 | 1559 | 37 |
38167 | 38167 | 2020-04-07 | Maricopa | Arizona | 4013 | 1495 | 35 |
35678 | 35678 | 2020-04-06 | Maricopa | Arizona | 4013 | 1433 | 31 |
33238 | 33238 | 2020-04-05 | Maricopa | Arizona | 4013 | 1326 | 31 |
30834 | 30834 | 2020-04-04 | Maricopa | Arizona | 4013 | 1171 | 28 |
28477 | 28477 | 2020-04-03 | Maricopa | Arizona | 4013 | 1049 | 17 |
26180 | 26180 | 2020-04-02 | Maricopa | Arizona | 4013 | 961 | 12 |
23956 | 23956 | 2020-04-01 | Maricopa | Arizona | 4013 | 871 | 8 |
21800 | 21800 | 2020-03-31 | Maricopa | Arizona | 4013 | 791 | 8 |
19728 | 19728 | 2020-03-30 | Maricopa | Arizona | 4013 | 690 | 5 |
17754 | 17754 | 2020-03-29 | Maricopa | Arizona | 4013 | 546 | 5 |
15870 | 15870 | 2020-03-28 | Maricopa | Arizona | 4013 | 454 | 5 |
14090 | 14090 | 2020-03-27 | Maricopa | Arizona | 4013 | 399 | 5 |
12427 | 12427 | 2020-03-26 | Maricopa | Arizona | 4013 | 299 | 4 |
10887 | 10887 | 2020-03-25 | Maricopa | Arizona | 4013 | 251 | 2 |
9517 | 9517 | 2020-03-24 | Maricopa | Arizona | 4013 | 199 | 2 |
8289 | 8289 | 2020-03-23 | Maricopa | Arizona | 4013 | 139 | 2 |
7146 | 7146 | 2020-03-22 | Maricopa | Arizona | 4013 | 81 | 2 |
6112 | 6112 | 2020-03-21 | Maricopa | Arizona | 4013 | 49 | 1 |
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);