ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Santa Fe" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 200 ✖
- 3 105
- 0 56
- 153 28
- 145 27
- 4 19
- 144 17
- 140 16
- 142 15
- 147 15
- 151 15
- 167 13
- 165 12
- 152 11
- 156 11
- 6 9
- 7 9
- 13 9
- 175 9
- 244 9
- 8 8
- 273 8
- 5 7
- 149 7
- 150 7
- 154 7
- 158 7
- 166 7
- 185 7
- 259 7
- 1 6
- 146 6
- 181 6
- 247 6
- 162 5
- 171 5
- 195 5
- 261 5
- 275 5
- 14 4
- 41 4
- 155 4
- 180 4
- 191 4
- 204 4
- 210 4
- 215 4
- 248 4
- 264 4
- 270 4
- 18 3
- 20 3
- 21 3
- 24 3
- 35 3
- 67 3
- 86 3
- 111 3
- 126 3
- 138 3
- 143 3
- 173 3
- 184 3
- 187 3
- 219 3
- 226 3
- 235 3
- 243 3
- 254 3
- 267 3
- 279 3
- 2 2
- 9 2
- 15 2
- 27 2
- 36 2
- 60 2
- 61 2
- 74 2
- 75 2
- 91 2
- 95 2
- 114 2
- 119 2
- 123 2
- 124 2
- 130 2
- 135 2
- 139 2
- 170 2
- 172 2
- 188 2
- 208 2
- 230 2
- 237 2
- 245 2
- 253 2
- 262 2
- 265 2
- 269 2
- 271 2
- 286 2
- 12 1
- 19 1
- 22 1
- 23 1
- 26 1
- 28 1
- 29 1
- 30 1
- 31 1
- 37 1
- 38 1
- 40 1
- 43 1
- 44 1
- 45 1
- 46 1
- 48 1
- 49 1
- 53 1
- 55 1
- 59 1
- 63 1
- 66 1
- 70 1
- 72 1
- 77 1
- 78 1
- 80 1
- 81 1
- 85 1
- 87 1
- 88 1
- 89 1
- 90 1
- 94 1
- 96 1
- 99 1
- 104 1
- 108 1
- 109 1
- 110 1
- 115 1
- 117 1
- 121 1
- 122 1
- 125 1
- 127 1
- 128 1
- 129 1
- 131 1
- 132 1
- 133 1
- 134 1
- 141 1
- 157 1
- 160 1
- 163 1
- 164 1
- 168 1
- 169 1
- 174 1
- 177 1
- 183 1
- 190 1
- 192 1
- 193 1
- 196 1
- 198 1
- 200 1
- 205 1
- 209 1
- 211 1
- 212 1
- 213 1
- 216 1
- 217 1
- 218 1
- 220 1
- 223 1
- 224 1
- 225 1
- 232 1
- 234 1
- 239 1
- 240 1
- 250 1
- 252 1
- 257 1
- 258 1
- 260 1
- 263 1
- 266 1
- 268 1
- 276 1
- 277 1
- 278 1
- 280 1
- 282 1
- 287 1
state 1
- New Mexico 794
fips 1
- 35049 794
county 1
- Santa Fe · 794 ✖
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 |
189373 | 189373 | 2020-05-29 | Santa Fe | New Mexico | 35049 | 137 | 3 |
186313 | 186313 | 2020-05-28 | Santa Fe | New Mexico | 35049 | 138 | 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);