ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 35013 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5702 | 5702 | 2020-03-20 | Doña Ana | New Mexico | 35013 | 1 | 0 |
6695 | 6695 | 2020-03-21 | Doña Ana | New Mexico | 35013 | 2 | 0 |
7787 | 7787 | 2020-03-22 | Doña Ana | New Mexico | 35013 | 4 | 0 |
8984 | 8984 | 2020-03-23 | Doña Ana | New Mexico | 35013 | 10 | 0 |
10290 | 10290 | 2020-03-24 | Doña Ana | New Mexico | 35013 | 13 | 0 |
11722 | 11722 | 2020-03-25 | Doña Ana | New Mexico | 35013 | 13 | 0 |
13325 | 13325 | 2020-03-26 | Doña Ana | New Mexico | 35013 | 16 | 0 |
15057 | 15057 | 2020-03-27 | Doña Ana | New Mexico | 35013 | 16 | 0 |
16886 | 16886 | 2020-03-28 | Doña Ana | New Mexico | 35013 | 17 | 0 |
18810 | 18810 | 2020-03-29 | Doña Ana | New Mexico | 35013 | 17 | 0 |
20848 | 20848 | 2020-03-30 | Doña Ana | New Mexico | 35013 | 18 | 0 |
22971 | 22971 | 2020-03-31 | Doña Ana | New Mexico | 35013 | 18 | 0 |
25163 | 25163 | 2020-04-01 | Doña Ana | New Mexico | 35013 | 21 | 0 |
27423 | 27423 | 2020-04-02 | Doña Ana | New Mexico | 35013 | 21 | 0 |
29746 | 29746 | 2020-04-03 | Doña Ana | New Mexico | 35013 | 22 | 0 |
32131 | 32131 | 2020-04-04 | Doña Ana | New Mexico | 35013 | 23 | 0 |
34562 | 34562 | 2020-04-05 | Doña Ana | New Mexico | 35013 | 29 | 0 |
37032 | 37032 | 2020-04-06 | Doña Ana | New Mexico | 35013 | 30 | 0 |
39547 | 39547 | 2020-04-07 | Doña Ana | New Mexico | 35013 | 35 | 0 |
42104 | 42104 | 2020-04-08 | Doña Ana | New Mexico | 35013 | 39 | 0 |
44687 | 44687 | 2020-04-09 | Doña Ana | New Mexico | 35013 | 44 | 0 |
47299 | 47299 | 2020-04-10 | Doña Ana | New Mexico | 35013 | 44 | 0 |
49953 | 49953 | 2020-04-11 | Doña Ana | New Mexico | 35013 | 49 | 0 |
52626 | 52626 | 2020-04-12 | Doña Ana | New Mexico | 35013 | 49 | 1 |
55309 | 55309 | 2020-04-13 | Doña Ana | New Mexico | 35013 | 50 | 1 |
58009 | 58009 | 2020-04-14 | Doña Ana | New Mexico | 35013 | 50 | 1 |
60723 | 60723 | 2020-04-15 | Doña Ana | New Mexico | 35013 | 54 | 1 |
63449 | 63449 | 2020-04-16 | Doña Ana | New Mexico | 35013 | 58 | 1 |
66191 | 66191 | 2020-04-17 | Doña Ana | New Mexico | 35013 | 65 | 1 |
68947 | 68947 | 2020-04-18 | Doña Ana | New Mexico | 35013 | 67 | 1 |
71714 | 71714 | 2020-04-19 | Doña Ana | New Mexico | 35013 | 69 | 1 |
74489 | 74489 | 2020-04-20 | Doña Ana | New Mexico | 35013 | 73 | 1 |
77270 | 77270 | 2020-04-21 | Doña Ana | New Mexico | 35013 | 76 | 1 |
80059 | 80059 | 2020-04-22 | Doña Ana | New Mexico | 35013 | 82 | 1 |
82857 | 82857 | 2020-04-23 | Doña Ana | New Mexico | 35013 | 88 | 1 |
85661 | 85661 | 2020-04-24 | Doña Ana | New Mexico | 35013 | 94 | 1 |
88472 | 88472 | 2020-04-25 | Doña Ana | New Mexico | 35013 | 110 | 1 |
91287 | 91287 | 2020-04-26 | Doña Ana | New Mexico | 35013 | 116 | 1 |
94111 | 94111 | 2020-04-27 | Doña Ana | New Mexico | 35013 | 126 | 1 |
96947 | 96947 | 2020-04-28 | Doña Ana | New Mexico | 35013 | 129 | 1 |
99794 | 99794 | 2020-04-29 | Doña Ana | New Mexico | 35013 | 130 | 1 |
102647 | 102647 | 2020-04-30 | Doña Ana | New Mexico | 35013 | 144 | 1 |
105509 | 105509 | 2020-05-01 | Doña Ana | New Mexico | 35013 | 147 | 1 |
108375 | 108375 | 2020-05-02 | Doña Ana | New Mexico | 35013 | 153 | 2 |
111248 | 111248 | 2020-05-03 | Doña Ana | New Mexico | 35013 | 159 | 2 |
114129 | 114129 | 2020-05-04 | Doña Ana | New Mexico | 35013 | 170 | 2 |
117010 | 117010 | 2020-05-05 | Doña Ana | New Mexico | 35013 | 173 | 2 |
119971 | 119971 | 2020-05-06 | Doña Ana | New Mexico | 35013 | 180 | 2 |
122946 | 122946 | 2020-05-07 | Doña Ana | New Mexico | 35013 | 197 | 2 |
125929 | 125929 | 2020-05-08 | Doña Ana | New Mexico | 35013 | 206 | 2 |
128918 | 128918 | 2020-05-09 | Doña Ana | New Mexico | 35013 | 212 | 2 |
131907 | 131907 | 2020-05-10 | Doña Ana | New Mexico | 35013 | 232 | 2 |
134898 | 134898 | 2020-05-11 | Doña Ana | New Mexico | 35013 | 256 | 2 |
137888 | 137888 | 2020-05-12 | Doña Ana | New Mexico | 35013 | 256 | 2 |
140884 | 140884 | 2020-05-13 | Doña Ana | New Mexico | 35013 | 260 | 2 |
143879 | 143879 | 2020-05-14 | Doña Ana | New Mexico | 35013 | 270 | 2 |
146880 | 146880 | 2020-05-15 | Doña Ana | New Mexico | 35013 | 281 | 2 |
149887 | 149887 | 2020-05-16 | Doña Ana | New Mexico | 35013 | 293 | 2 |
152897 | 152897 | 2020-05-17 | Doña Ana | New Mexico | 35013 | 305 | 2 |
155913 | 155913 | 2020-05-18 | Doña Ana | New Mexico | 35013 | 320 | 2 |
158931 | 158931 | 2020-05-19 | Doña Ana | New Mexico | 35013 | 330 | 2 |
161957 | 161957 | 2020-05-20 | Doña Ana | New Mexico | 35013 | 333 | 2 |
164986 | 164986 | 2020-05-21 | Doña Ana | New Mexico | 35013 | 373 | 2 |
168022 | 168022 | 2020-05-22 | Doña Ana | New Mexico | 35013 | 381 | 2 |
171061 | 171061 | 2020-05-23 | Doña Ana | New Mexico | 35013 | 402 | 2 |
174103 | 174103 | 2020-05-24 | Doña Ana | New Mexico | 35013 | 418 | 2 |
177146 | 177146 | 2020-05-25 | Doña Ana | New Mexico | 35013 | 434 | 2 |
180190 | 180190 | 2020-05-26 | Doña Ana | New Mexico | 35013 | 439 | 2 |
183238 | 183238 | 2020-05-27 | Doña Ana | New Mexico | 35013 | 450 | 2 |
186295 | 186295 | 2020-05-28 | Doña Ana | New Mexico | 35013 | 453 | 2 |
189355 | 189355 | 2020-05-29 | Doña Ana | New Mexico | 35013 | 460 | 3 |
192419 | 192419 | 2020-05-30 | Doña Ana | New Mexico | 35013 | 471 | 3 |
195489 | 195489 | 2020-05-31 | Doña Ana | New Mexico | 35013 | 477 | 3 |
198562 | 198562 | 2020-06-01 | Doña Ana | New Mexico | 35013 | 487 | 3 |
201636 | 201636 | 2020-06-02 | Doña Ana | New Mexico | 35013 | 490 | 3 |
204713 | 204713 | 2020-06-03 | Doña Ana | New Mexico | 35013 | 499 | 3 |
207794 | 207794 | 2020-06-04 | Doña Ana | New Mexico | 35013 | 520 | 3 |
210876 | 210876 | 2020-06-05 | Doña Ana | New Mexico | 35013 | 546 | 3 |
213960 | 213960 | 2020-06-06 | Doña Ana | New Mexico | 35013 | 569 | 3 |
217049 | 217049 | 2020-06-07 | Doña Ana | New Mexico | 35013 | 581 | 3 |
220141 | 220141 | 2020-06-08 | Doña Ana | New Mexico | 35013 | 598 | 3 |
223236 | 223236 | 2020-06-09 | Doña Ana | New Mexico | 35013 | 600 | 3 |
226336 | 226336 | 2020-06-10 | Doña Ana | New Mexico | 35013 | 626 | 3 |
229440 | 229440 | 2020-06-11 | Doña Ana | New Mexico | 35013 | 643 | 5 |
232545 | 232545 | 2020-06-12 | Doña Ana | New Mexico | 35013 | 648 | 6 |
235650 | 235650 | 2020-06-13 | Doña Ana | New Mexico | 35013 | 656 | 6 |
238757 | 238757 | 2020-06-14 | Doña Ana | New Mexico | 35013 | 669 | 6 |
241867 | 241867 | 2020-06-15 | Doña Ana | New Mexico | 35013 | 668 | 6 |
244979 | 244979 | 2020-06-16 | Doña Ana | New Mexico | 35013 | 670 | 6 |
248092 | 248092 | 2020-06-17 | Doña Ana | New Mexico | 35013 | 687 | 6 |
251207 | 251207 | 2020-06-18 | Doña Ana | New Mexico | 35013 | 696 | 6 |
254322 | 254322 | 2020-06-19 | Doña Ana | New Mexico | 35013 | 703 | 6 |
257445 | 257445 | 2020-06-20 | Doña Ana | New Mexico | 35013 | 711 | 6 |
260571 | 260571 | 2020-06-21 | Doña Ana | New Mexico | 35013 | 729 | 6 |
263700 | 263700 | 2020-06-22 | Doña Ana | New Mexico | 35013 | 745 | 6 |
266827 | 266827 | 2020-06-23 | Doña Ana | New Mexico | 35013 | 751 | 8 |
269962 | 269962 | 2020-06-24 | Doña Ana | New Mexico | 35013 | 771 | 8 |
273101 | 273101 | 2020-06-25 | Doña Ana | New Mexico | 35013 | 817 | 8 |
276246 | 276246 | 2020-06-26 | Doña Ana | New Mexico | 35013 | 853 | 8 |
279394 | 279394 | 2020-06-27 | Doña Ana | New Mexico | 35013 | 879 | 8 |
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);