ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 35049 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1282 | 1282 | 2020-03-11 | Santa Fe | New Mexico | 35049 | 1 | 0 |
1514 | 1514 | 2020-03-12 | Santa Fe | New Mexico | 35049 | 2 | 0 |
1807 | 1807 | 2020-03-13 | Santa Fe | New Mexico | 35049 | 3 | 0 |
2155 | 2155 | 2020-03-14 | Santa Fe | New Mexico | 35049 | 3 | 0 |
2563 | 2563 | 2020-03-15 | Santa Fe | New Mexico | 35049 | 3 | 0 |
3021 | 3021 | 2020-03-16 | Santa Fe | New Mexico | 35049 | 3 | 0 |
3535 | 3535 | 2020-03-17 | Santa Fe | New Mexico | 35049 | 4 | 0 |
4131 | 4131 | 2020-03-18 | Santa Fe | New Mexico | 35049 | 6 | 0 |
4860 | 4860 | 2020-03-19 | Santa Fe | New Mexico | 35049 | 7 | 0 |
5706 | 5706 | 2020-03-20 | Santa Fe | New Mexico | 35049 | 7 | 0 |
6700 | 6700 | 2020-03-21 | Santa Fe | New Mexico | 35049 | 8 | 0 |
7793 | 7793 | 2020-03-22 | Santa Fe | New Mexico | 35049 | 10 | 0 |
8990 | 8990 | 2020-03-23 | Santa Fe | New Mexico | 35049 | 12 | 0 |
10296 | 10296 | 2020-03-24 | Santa Fe | New Mexico | 35049 | 14 | 0 |
11730 | 11730 | 2020-03-25 | Santa Fe | New Mexico | 35049 | 17 | 0 |
13333 | 13333 | 2020-03-26 | Santa Fe | New Mexico | 35049 | 22 | 0 |
15066 | 15066 | 2020-03-27 | Santa Fe | New Mexico | 35049 | 29 | 0 |
16895 | 16895 | 2020-03-28 | Santa Fe | New Mexico | 35049 | 30 | 0 |
18819 | 18819 | 2020-03-29 | Santa Fe | New Mexico | 35049 | 34 | 0 |
20857 | 20857 | 2020-03-30 | Santa Fe | New Mexico | 35049 | 38 | 0 |
22980 | 22980 | 2020-03-31 | Santa Fe | New Mexico | 35049 | 42 | 0 |
25174 | 25174 | 2020-04-01 | Santa Fe | New Mexico | 35049 | 48 | 0 |
27434 | 27434 | 2020-04-02 | Santa Fe | New Mexico | 35049 | 48 | 0 |
29757 | 29757 | 2020-04-03 | Santa Fe | New Mexico | 35049 | 52 | 0 |
32144 | 32144 | 2020-04-04 | Santa Fe | New Mexico | 35049 | 58 | 0 |
34575 | 34575 | 2020-04-05 | Santa Fe | New Mexico | 35049 | 62 | 0 |
37045 | 37045 | 2020-04-06 | Santa Fe | New Mexico | 35049 | 64 | 0 |
39560 | 39560 | 2020-04-07 | Santa Fe | New Mexico | 35049 | 66 | 0 |
42117 | 42117 | 2020-04-08 | Santa Fe | New Mexico | 35049 | 68 | 0 |
44700 | 44700 | 2020-04-09 | Santa Fe | New Mexico | 35049 | 70 | 0 |
47313 | 47313 | 2020-04-10 | Santa Fe | New Mexico | 35049 | 72 | 0 |
49968 | 49968 | 2020-04-11 | Santa Fe | New Mexico | 35049 | 74 | 0 |
52641 | 52641 | 2020-04-12 | Santa Fe | New Mexico | 35049 | 75 | 0 |
55324 | 55324 | 2020-04-13 | Santa Fe | New Mexico | 35049 | 76 | 0 |
58024 | 58024 | 2020-04-14 | Santa Fe | New Mexico | 35049 | 76 | 0 |
60738 | 60738 | 2020-04-15 | Santa Fe | New Mexico | 35049 | 78 | 0 |
63464 | 63464 | 2020-04-16 | Santa Fe | New Mexico | 35049 | 79 | 0 |
66206 | 66206 | 2020-04-17 | Santa Fe | New Mexico | 35049 | 80 | 0 |
68963 | 68963 | 2020-04-18 | Santa Fe | New Mexico | 35049 | 82 | 0 |
71730 | 71730 | 2020-04-19 | Santa Fe | New Mexico | 35049 | 83 | 0 |
74505 | 74505 | 2020-04-20 | Santa Fe | New Mexico | 35049 | 86 | 0 |
77286 | 77286 | 2020-04-21 | Santa Fe | New Mexico | 35049 | 88 | 0 |
80075 | 80075 | 2020-04-22 | Santa Fe | New Mexico | 35049 | 93 | 0 |
82874 | 82874 | 2020-04-23 | Santa Fe | New Mexico | 35049 | 96 | 0 |
85678 | 85678 | 2020-04-24 | Santa Fe | New Mexico | 35049 | 96 | 0 |
88489 | 88489 | 2020-04-25 | Santa Fe | New Mexico | 35049 | 96 | 0 |
91304 | 91304 | 2020-04-26 | Santa Fe | New Mexico | 35049 | 96 | 0 |
94128 | 94128 | 2020-04-27 | Santa Fe | New Mexico | 35049 | 96 | 0 |
96964 | 96964 | 2020-04-28 | Santa Fe | New Mexico | 35049 | 98 | 0 |
99811 | 99811 | 2020-04-29 | Santa Fe | New Mexico | 35049 | 98 | 0 |
102664 | 102664 | 2020-04-30 | Santa Fe | New Mexico | 35049 | 100 | 0 |
105526 | 105526 | 2020-05-01 | Santa Fe | New Mexico | 35049 | 100 | 0 |
108392 | 108392 | 2020-05-02 | Santa Fe | New Mexico | 35049 | 107 | 0 |
111265 | 111265 | 2020-05-03 | Santa Fe | New Mexico | 35049 | 107 | 0 |
114146 | 114146 | 2020-05-04 | Santa Fe | New Mexico | 35049 | 108 | 0 |
117027 | 117027 | 2020-05-05 | Santa Fe | New Mexico | 35049 | 108 | 0 |
119988 | 119988 | 2020-05-06 | Santa Fe | New Mexico | 35049 | 110 | 1 |
122963 | 122963 | 2020-05-07 | Santa Fe | New Mexico | 35049 | 110 | 1 |
125946 | 125946 | 2020-05-08 | Santa Fe | New Mexico | 35049 | 110 | 1 |
128935 | 128935 | 2020-05-09 | Santa Fe | New Mexico | 35049 | 110 | 1 |
131924 | 131924 | 2020-05-10 | Santa Fe | New Mexico | 35049 | 111 | 1 |
134915 | 134915 | 2020-05-11 | Santa Fe | New Mexico | 35049 | 112 | 1 |
137905 | 137905 | 2020-05-12 | Santa Fe | New Mexico | 35049 | 112 | 2 |
140901 | 140901 | 2020-05-13 | Santa Fe | New Mexico | 35049 | 113 | 2 |
143896 | 143896 | 2020-05-14 | Santa Fe | New Mexico | 35049 | 113 | 3 |
146897 | 146897 | 2020-05-15 | Santa Fe | New Mexico | 35049 | 114 | 3 |
149904 | 149904 | 2020-05-16 | Santa Fe | New Mexico | 35049 | 122 | 3 |
152914 | 152914 | 2020-05-17 | Santa Fe | New Mexico | 35049 | 123 | 3 |
155931 | 155931 | 2020-05-18 | Santa Fe | New Mexico | 35049 | 124 | 3 |
158949 | 158949 | 2020-05-19 | Santa Fe | New Mexico | 35049 | 126 | 3 |
161975 | 161975 | 2020-05-20 | Santa Fe | New Mexico | 35049 | 127 | 3 |
165004 | 165004 | 2020-05-21 | Santa Fe | New Mexico | 35049 | 127 | 3 |
168040 | 168040 | 2020-05-22 | Santa Fe | New Mexico | 35049 | 129 | 3 |
171079 | 171079 | 2020-05-23 | Santa Fe | New Mexico | 35049 | 130 | 3 |
174121 | 174121 | 2020-05-24 | Santa Fe | New Mexico | 35049 | 132 | 3 |
177164 | 177164 | 2020-05-25 | Santa Fe | New Mexico | 35049 | 133 | 3 |
180208 | 180208 | 2020-05-26 | Santa Fe | New Mexico | 35049 | 133 | 3 |
183256 | 183256 | 2020-05-27 | Santa Fe | New Mexico | 35049 | 137 | 3 |
186313 | 186313 | 2020-05-28 | Santa Fe | New Mexico | 35049 | 138 | 3 |
189373 | 189373 | 2020-05-29 | Santa Fe | New Mexico | 35049 | 137 | 3 |
192437 | 192437 | 2020-05-30 | Santa Fe | New Mexico | 35049 | 140 | 3 |
195507 | 195507 | 2020-05-31 | Santa Fe | New Mexico | 35049 | 142 | 3 |
198580 | 198580 | 2020-06-01 | Santa Fe | New Mexico | 35049 | 144 | 3 |
201654 | 201654 | 2020-06-02 | Santa Fe | New Mexico | 35049 | 149 | 3 |
204731 | 204731 | 2020-06-03 | Santa Fe | New Mexico | 35049 | 151 | 3 |
207812 | 207812 | 2020-06-04 | Santa Fe | New Mexico | 35049 | 151 | 3 |
210894 | 210894 | 2020-06-05 | Santa Fe | New Mexico | 35049 | 151 | 3 |
213978 | 213978 | 2020-06-06 | Santa Fe | New Mexico | 35049 | 151 | 3 |
217067 | 217067 | 2020-06-07 | Santa Fe | New Mexico | 35049 | 156 | 3 |
220159 | 220159 | 2020-06-08 | Santa Fe | New Mexico | 35049 | 156 | 3 |
223254 | 223254 | 2020-06-09 | Santa Fe | New Mexico | 35049 | 159 | 3 |
226354 | 226354 | 2020-06-10 | Santa Fe | New Mexico | 35049 | 161 | 3 |
229458 | 229458 | 2020-06-11 | Santa Fe | New Mexico | 35049 | 162 | 3 |
232563 | 232563 | 2020-06-12 | Santa Fe | New Mexico | 35049 | 166 | 3 |
235668 | 235668 | 2020-06-13 | Santa Fe | New Mexico | 35049 | 171 | 3 |
238775 | 238775 | 2020-06-14 | Santa Fe | New Mexico | 35049 | 171 | 3 |
241885 | 241885 | 2020-06-15 | Santa Fe | New Mexico | 35049 | 174 | 3 |
244997 | 244997 | 2020-06-16 | Santa Fe | New Mexico | 35049 | 179 | 3 |
248110 | 248110 | 2020-06-17 | Santa Fe | New Mexico | 35049 | 183 | 3 |
251225 | 251225 | 2020-06-18 | Santa Fe | New Mexico | 35049 | 185 | 3 |
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);