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 |
---|---|---|---|---|---|---|---|
382823 | 382823 | 2020-07-30 | Maricopa | Arizona | 4013 | 114852 | 2011 |
379606 | 379606 | 2020-07-29 | Maricopa | Arizona | 4013 | 113148 | 1915 |
376390 | 376390 | 2020-07-28 | Maricopa | Arizona | 4013 | 111446 | 1882 |
373176 | 373176 | 2020-07-27 | Maricopa | Arizona | 4013 | 109988 | 1807 |
369964 | 369964 | 2020-07-26 | Maricopa | Arizona | 4013 | 108677 | 1808 |
366754 | 366754 | 2020-07-25 | Maricopa | Arizona | 4013 | 107291 | 1793 |
363547 | 363547 | 2020-07-24 | Maricopa | Arizona | 4013 | 104613 | 1718 |
360340 | 360340 | 2020-07-23 | Maricopa | Arizona | 4013 | 102247 | 1651 |
357135 | 357135 | 2020-07-22 | Maricopa | Arizona | 4013 | 100543 | 1599 |
353932 | 353932 | 2020-07-21 | Maricopa | Arizona | 4013 | 98988 | 1556 |
350730 | 350730 | 2020-07-20 | Maricopa | Arizona | 4013 | 96711 | 1485 |
347529 | 347529 | 2020-07-19 | Maricopa | Arizona | 4013 | 95471 | 1473 |
344329 | 344329 | 2020-07-18 | Maricopa | Arizona | 4013 | 93870 | 1444 |
341130 | 341130 | 2020-07-17 | Maricopa | Arizona | 4013 | 91863 | 1374 |
337934 | 337934 | 2020-07-16 | Maricopa | Arizona | 4013 | 88954 | 1311 |
334739 | 334739 | 2020-07-15 | Maricopa | Arizona | 4013 | 86483 | 1277 |
331546 | 331546 | 2020-07-14 | Maricopa | Arizona | 4013 | 84233 | 1198 |
328360 | 328360 | 2020-07-13 | Maricopa | Arizona | 4013 | 81216 | 1140 |
325174 | 325174 | 2020-07-12 | Maricopa | Arizona | 4013 | 80146 | 1133 |
321993 | 321993 | 2020-07-11 | Maricopa | Arizona | 4013 | 78481 | 1093 |
318814 | 318814 | 2020-07-10 | Maricopa | Arizona | 4013 | 76328 | 1049 |
315641 | 315641 | 2020-07-09 | Maricopa | Arizona | 4013 | 73165 | 1012 |
312466 | 312466 | 2020-07-08 | Maricopa | Arizona | 4013 | 70128 | 959 |
309296 | 309296 | 2020-07-07 | Maricopa | Arizona | 4013 | 67543 | 933 |
306128 | 306128 | 2020-07-06 | Maricopa | Arizona | 4013 | 64915 | 881 |
302964 | 302964 | 2020-07-05 | Maricopa | Arizona | 4013 | 62296 | 883 |
299800 | 299800 | 2020-07-04 | Maricopa | Arizona | 4013 | 59829 | 880 |
296638 | 296638 | 2020-07-03 | Maricopa | Arizona | 4013 | 57929 | 865 |
293482 | 293482 | 2020-07-02 | Maricopa | Arizona | 4013 | 54757 | 843 |
290329 | 290329 | 2020-07-01 | Maricopa | Arizona | 4013 | 52266 | 817 |
287178 | 287178 | 2020-06-30 | Maricopa | Arizona | 4013 | 48710 | 771 |
284032 | 284032 | 2020-06-29 | Maricopa | Arizona | 4013 | 45178 | 746 |
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 |
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);