ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 4023 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4426 | 4426 | 2020-03-19 | Santa Cruz | Arizona | 4023 | 1 | 0 |
5197 | 5197 | 2020-03-20 | Santa Cruz | Arizona | 4023 | 1 | 0 |
6116 | 6116 | 2020-03-21 | Santa Cruz | Arizona | 4023 | 1 | 0 |
7150 | 7150 | 2020-03-22 | Santa Cruz | Arizona | 4023 | 1 | 0 |
8293 | 8293 | 2020-03-23 | Santa Cruz | Arizona | 4023 | 1 | 0 |
9521 | 9521 | 2020-03-24 | Santa Cruz | Arizona | 4023 | 1 | 0 |
10891 | 10891 | 2020-03-25 | Santa Cruz | Arizona | 4023 | 2 | 0 |
12432 | 12432 | 2020-03-26 | Santa Cruz | Arizona | 4023 | 2 | 0 |
14095 | 14095 | 2020-03-27 | Santa Cruz | Arizona | 4023 | 2 | 0 |
15875 | 15875 | 2020-03-28 | Santa Cruz | Arizona | 4023 | 2 | 0 |
17759 | 17759 | 2020-03-29 | Santa Cruz | Arizona | 4023 | 2 | 0 |
19733 | 19733 | 2020-03-30 | Santa Cruz | Arizona | 4023 | 2 | 0 |
21805 | 21805 | 2020-03-31 | Santa Cruz | Arizona | 4023 | 2 | 0 |
23961 | 23961 | 2020-04-01 | Santa Cruz | Arizona | 4023 | 3 | 0 |
26185 | 26185 | 2020-04-02 | Santa Cruz | Arizona | 4023 | 3 | 0 |
28482 | 28482 | 2020-04-03 | Santa Cruz | Arizona | 4023 | 3 | 0 |
30839 | 30839 | 2020-04-04 | Santa Cruz | Arizona | 4023 | 4 | 0 |
33243 | 33243 | 2020-04-05 | Santa Cruz | Arizona | 4023 | 4 | 0 |
35683 | 35683 | 2020-04-06 | Santa Cruz | Arizona | 4023 | 5 | 0 |
38172 | 38172 | 2020-04-07 | Santa Cruz | Arizona | 4023 | 5 | 0 |
40715 | 40715 | 2020-04-08 | Santa Cruz | Arizona | 4023 | 6 | 0 |
43288 | 43288 | 2020-04-09 | Santa Cruz | Arizona | 4023 | 7 | 0 |
45886 | 45886 | 2020-04-10 | Santa Cruz | Arizona | 4023 | 7 | 0 |
48516 | 48516 | 2020-04-11 | Santa Cruz | Arizona | 4023 | 8 | 0 |
51178 | 51178 | 2020-04-12 | Santa Cruz | Arizona | 4023 | 8 | 0 |
53856 | 53856 | 2020-04-13 | Santa Cruz | Arizona | 4023 | 10 | 0 |
56548 | 56548 | 2020-04-14 | Santa Cruz | Arizona | 4023 | 10 | 0 |
59257 | 59257 | 2020-04-15 | Santa Cruz | Arizona | 4023 | 12 | 0 |
61976 | 61976 | 2020-04-16 | Santa Cruz | Arizona | 4023 | 14 | 0 |
64709 | 64709 | 2020-04-17 | Santa Cruz | Arizona | 4023 | 15 | 0 |
67457 | 67457 | 2020-04-18 | Santa Cruz | Arizona | 4023 | 16 | 0 |
70219 | 70219 | 2020-04-19 | Santa Cruz | Arizona | 4023 | 19 | 0 |
72988 | 72988 | 2020-04-20 | Santa Cruz | Arizona | 4023 | 20 | 0 |
75764 | 75764 | 2020-04-21 | Santa Cruz | Arizona | 4023 | 23 | 0 |
78547 | 78547 | 2020-04-22 | Santa Cruz | Arizona | 4023 | 28 | 0 |
81340 | 81340 | 2020-04-23 | Santa Cruz | Arizona | 4023 | 28 | 0 |
84141 | 84141 | 2020-04-24 | Santa Cruz | Arizona | 4023 | 30 | 0 |
86949 | 86949 | 2020-04-25 | Santa Cruz | Arizona | 4023 | 30 | 0 |
89766 | 89766 | 2020-04-26 | Santa Cruz | Arizona | 4023 | 30 | 0 |
92584 | 92584 | 2020-04-27 | Santa Cruz | Arizona | 4023 | 30 | 0 |
95414 | 95414 | 2020-04-28 | Santa Cruz | Arizona | 4023 | 31 | 0 |
98259 | 98259 | 2020-04-29 | Santa Cruz | Arizona | 4023 | 31 | 0 |
101109 | 101109 | 2020-04-30 | Santa Cruz | Arizona | 4023 | 33 | 0 |
103964 | 103964 | 2020-05-01 | Santa Cruz | Arizona | 4023 | 33 | 0 |
106829 | 106829 | 2020-05-02 | Santa Cruz | Arizona | 4023 | 34 | 0 |
109698 | 109698 | 2020-05-03 | Santa Cruz | Arizona | 4023 | 34 | 0 |
112573 | 112573 | 2020-05-04 | Santa Cruz | Arizona | 4023 | 34 | 0 |
115456 | 115456 | 2020-05-05 | Santa Cruz | Arizona | 4023 | 35 | 0 |
118415 | 118415 | 2020-05-06 | Santa Cruz | Arizona | 4023 | 37 | 0 |
121382 | 121382 | 2020-05-07 | Santa Cruz | Arizona | 4023 | 38 | 0 |
124362 | 124362 | 2020-05-08 | Santa Cruz | Arizona | 4023 | 38 | 0 |
127347 | 127347 | 2020-05-09 | Santa Cruz | Arizona | 4023 | 40 | 0 |
130337 | 130337 | 2020-05-10 | Santa Cruz | Arizona | 4023 | 44 | 0 |
133327 | 133327 | 2020-05-11 | Santa Cruz | Arizona | 4023 | 45 | 0 |
136317 | 136317 | 2020-05-12 | Santa Cruz | Arizona | 4023 | 51 | 0 |
139308 | 139308 | 2020-05-13 | Santa Cruz | Arizona | 4023 | 50 | 0 |
142304 | 142304 | 2020-05-14 | Santa Cruz | Arizona | 4023 | 62 | 0 |
145303 | 145303 | 2020-05-15 | Santa Cruz | Arizona | 4023 | 69 | 0 |
148306 | 148306 | 2020-05-16 | Santa Cruz | Arizona | 4023 | 72 | 0 |
151315 | 151315 | 2020-05-17 | Santa Cruz | Arizona | 4023 | 75 | 0 |
154327 | 154327 | 2020-05-18 | Santa Cruz | Arizona | 4023 | 78 | 0 |
157343 | 157343 | 2020-05-19 | Santa Cruz | Arizona | 4023 | 97 | 0 |
160369 | 160369 | 2020-05-20 | Santa Cruz | Arizona | 4023 | 102 | 0 |
163397 | 163397 | 2020-05-21 | Santa Cruz | Arizona | 4023 | 123 | 0 |
166429 | 166429 | 2020-05-22 | Santa Cruz | Arizona | 4023 | 131 | 0 |
169465 | 169465 | 2020-05-23 | Santa Cruz | Arizona | 4023 | 143 | 0 |
172506 | 172506 | 2020-05-24 | Santa Cruz | Arizona | 4023 | 169 | 0 |
175549 | 175549 | 2020-05-25 | Santa Cruz | Arizona | 4023 | 186 | 0 |
178594 | 178594 | 2020-05-26 | Santa Cruz | Arizona | 4023 | 187 | 0 |
181638 | 181638 | 2020-05-27 | Santa Cruz | Arizona | 4023 | 188 | 0 |
184691 | 184691 | 2020-05-28 | Santa Cruz | Arizona | 4023 | 225 | 0 |
187748 | 187748 | 2020-05-29 | Santa Cruz | Arizona | 4023 | 262 | 0 |
190813 | 190813 | 2020-05-30 | Santa Cruz | Arizona | 4023 | 297 | 0 |
193880 | 193880 | 2020-05-31 | Santa Cruz | Arizona | 4023 | 330 | 0 |
196950 | 196950 | 2020-06-01 | Santa Cruz | Arizona | 4023 | 330 | 0 |
200023 | 200023 | 2020-06-02 | Santa Cruz | Arizona | 4023 | 365 | 1 |
203099 | 203099 | 2020-06-03 | Santa Cruz | Arizona | 4023 | 460 | 1 |
206179 | 206179 | 2020-06-04 | Santa Cruz | Arizona | 4023 | 527 | 3 |
209260 | 209260 | 2020-06-05 | Santa Cruz | Arizona | 4023 | 540 | 4 |
212345 | 212345 | 2020-06-06 | Santa Cruz | Arizona | 4023 | 596 | 5 |
215432 | 215432 | 2020-06-07 | Santa Cruz | Arizona | 4023 | 634 | 5 |
218523 | 218523 | 2020-06-08 | Santa Cruz | Arizona | 4023 | 698 | 6 |
221618 | 221618 | 2020-06-09 | Santa Cruz | Arizona | 4023 | 733 | 6 |
224713 | 224713 | 2020-06-10 | Santa Cruz | Arizona | 4023 | 817 | 8 |
227815 | 227815 | 2020-06-11 | Santa Cruz | Arizona | 4023 | 914 | 8 |
230918 | 230918 | 2020-06-12 | Santa Cruz | Arizona | 4023 | 948 | 9 |
234024 | 234024 | 2020-06-13 | Santa Cruz | Arizona | 4023 | 1027 | 12 |
237131 | 237131 | 2020-06-14 | Santa Cruz | Arizona | 4023 | 1082 | 12 |
240239 | 240239 | 2020-06-15 | Santa Cruz | Arizona | 4023 | 1149 | 12 |
243350 | 243350 | 2020-06-16 | Santa Cruz | Arizona | 4023 | 1217 | 13 |
246463 | 246463 | 2020-06-17 | Santa Cruz | Arizona | 4023 | 1217 | 13 |
249575 | 249575 | 2020-06-18 | Santa Cruz | Arizona | 4023 | 1249 | 13 |
252690 | 252690 | 2020-06-19 | Santa Cruz | Arizona | 4023 | 1297 | 14 |
255809 | 255809 | 2020-06-20 | Santa Cruz | Arizona | 4023 | 1418 | 13 |
258936 | 258936 | 2020-06-21 | Santa Cruz | Arizona | 4023 | 1488 | 13 |
262063 | 262063 | 2020-06-22 | Santa Cruz | Arizona | 4023 | 1498 | 13 |
265191 | 265191 | 2020-06-23 | Santa Cruz | Arizona | 4023 | 1540 | 14 |
268321 | 268321 | 2020-06-24 | Santa Cruz | Arizona | 4023 | 1554 | 14 |
271456 | 271456 | 2020-06-25 | Santa Cruz | Arizona | 4023 | 1603 | 14 |
274596 | 274596 | 2020-06-26 | Santa Cruz | Arizona | 4023 | 1654 | 15 |
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);