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 date descending
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 |
---|---|---|---|---|---|---|---|
2501420 | 2501420 | 2022-05-13 | Santa Fe | New Mexico | 35049 | 29503 | 287 |
2498162 | 2498162 | 2022-05-12 | Santa Fe | New Mexico | 35049 | 29446 | 286 |
2494904 | 2494904 | 2022-05-11 | Santa Fe | New Mexico | 35049 | 29388 | 286 |
2491646 | 2491646 | 2022-05-10 | Santa Fe | New Mexico | 35049 | 29358 | 282 |
2488388 | 2488388 | 2022-05-09 | Santa Fe | New Mexico | 35049 | 29314 | 280 |
2485131 | 2485131 | 2022-05-08 | Santa Fe | New Mexico | 35049 | 29223 | 279 |
2481873 | 2481873 | 2022-05-07 | Santa Fe | New Mexico | 35049 | 29223 | 279 |
2478615 | 2478615 | 2022-05-06 | Santa Fe | New Mexico | 35049 | 29223 | 279 |
2475357 | 2475357 | 2022-05-05 | Santa Fe | New Mexico | 35049 | 29194 | 278 |
2472100 | 2472100 | 2022-05-04 | Santa Fe | New Mexico | 35049 | 29147 | 277 |
2468844 | 2468844 | 2022-05-03 | Santa Fe | New Mexico | 35049 | 29114 | 276 |
2465588 | 2465588 | 2022-05-02 | Santa Fe | New Mexico | 35049 | 29099 | 275 |
2462333 | 2462333 | 2022-05-01 | Santa Fe | New Mexico | 35049 | 29034 | 275 |
2459077 | 2459077 | 2022-04-30 | Santa Fe | New Mexico | 35049 | 29034 | 275 |
2455821 | 2455821 | 2022-04-29 | Santa Fe | New Mexico | 35049 | 29034 | 275 |
2452565 | 2452565 | 2022-04-28 | Santa Fe | New Mexico | 35049 | 28988 | 275 |
2449309 | 2449309 | 2022-04-27 | Santa Fe | New Mexico | 35049 | 28912 | 273 |
2446052 | 2446052 | 2022-04-26 | Santa Fe | New Mexico | 35049 | 28912 | 273 |
2442797 | 2442797 | 2022-04-25 | Santa Fe | New Mexico | 35049 | 28912 | 273 |
2439541 | 2439541 | 2022-04-24 | Santa Fe | New Mexico | 35049 | 28863 | 273 |
2436285 | 2436285 | 2022-04-23 | Santa Fe | New Mexico | 35049 | 28863 | 273 |
2433029 | 2433029 | 2022-04-22 | Santa Fe | New Mexico | 35049 | 28863 | 273 |
2429773 | 2429773 | 2022-04-21 | Santa Fe | New Mexico | 35049 | 28837 | 273 |
2426517 | 2426517 | 2022-04-20 | Santa Fe | New Mexico | 35049 | 28813 | 273 |
2423261 | 2423261 | 2022-04-19 | Santa Fe | New Mexico | 35049 | 28779 | 271 |
2420004 | 2420004 | 2022-04-18 | Santa Fe | New Mexico | 35049 | 28762 | 271 |
2416749 | 2416749 | 2022-04-17 | Santa Fe | New Mexico | 35049 | 28698 | 270 |
2413493 | 2413493 | 2022-04-16 | Santa Fe | New Mexico | 35049 | 28698 | 270 |
2410237 | 2410237 | 2022-04-15 | Santa Fe | New Mexico | 35049 | 28698 | 270 |
2406981 | 2406981 | 2022-04-14 | Santa Fe | New Mexico | 35049 | 28688 | 270 |
2403725 | 2403725 | 2022-04-13 | Santa Fe | New Mexico | 35049 | 28674 | 269 |
2400470 | 2400470 | 2022-04-12 | Santa Fe | New Mexico | 35049 | 28648 | 269 |
2397215 | 2397215 | 2022-04-11 | Santa Fe | New Mexico | 35049 | 28643 | 268 |
2393960 | 2393960 | 2022-04-10 | Santa Fe | New Mexico | 35049 | 28612 | 267 |
2390704 | 2390704 | 2022-04-09 | Santa Fe | New Mexico | 35049 | 28612 | 267 |
2387448 | 2387448 | 2022-04-08 | Santa Fe | New Mexico | 35049 | 28612 | 267 |
2384193 | 2384193 | 2022-04-07 | Santa Fe | New Mexico | 35049 | 28607 | 266 |
2380938 | 2380938 | 2022-04-06 | Santa Fe | New Mexico | 35049 | 28579 | 265 |
2377683 | 2377683 | 2022-04-05 | Santa Fe | New Mexico | 35049 | 28563 | 265 |
2374430 | 2374430 | 2022-04-04 | Santa Fe | New Mexico | 35049 | 28550 | 264 |
2371178 | 2371178 | 2022-04-03 | Santa Fe | New Mexico | 35049 | 28521 | 264 |
2367925 | 2367925 | 2022-04-02 | Santa Fe | New Mexico | 35049 | 28521 | 264 |
2364672 | 2364672 | 2022-04-01 | Santa Fe | New Mexico | 35049 | 28521 | 264 |
2361418 | 2361418 | 2022-03-31 | Santa Fe | New Mexico | 35049 | 28511 | 263 |
2358164 | 2358164 | 2022-03-30 | Santa Fe | New Mexico | 35049 | 28499 | 262 |
2354911 | 2354911 | 2022-03-29 | Santa Fe | New Mexico | 35049 | 28481 | 262 |
2351658 | 2351658 | 2022-03-28 | Santa Fe | New Mexico | 35049 | 28475 | 261 |
2348406 | 2348406 | 2022-03-27 | Santa Fe | New Mexico | 35049 | 28452 | 261 |
2345153 | 2345153 | 2022-03-26 | Santa Fe | New Mexico | 35049 | 28452 | 261 |
2341900 | 2341900 | 2022-03-25 | Santa Fe | New Mexico | 35049 | 28452 | 261 |
2338647 | 2338647 | 2022-03-24 | Santa Fe | New Mexico | 35049 | 28438 | 261 |
2335393 | 2335393 | 2022-03-23 | Santa Fe | New Mexico | 35049 | 28413 | 260 |
2332139 | 2332139 | 2022-03-22 | Santa Fe | New Mexico | 35049 | 28392 | 259 |
2328886 | 2328886 | 2022-03-21 | Santa Fe | New Mexico | 35049 | 28385 | 259 |
2325634 | 2325634 | 2022-03-20 | Santa Fe | New Mexico | 35049 | 28359 | 259 |
2322380 | 2322380 | 2022-03-19 | Santa Fe | New Mexico | 35049 | 28347 | 259 |
2319126 | 2319126 | 2022-03-18 | Santa Fe | New Mexico | 35049 | 28347 | 259 |
2315873 | 2315873 | 2022-03-17 | Santa Fe | New Mexico | 35049 | 28347 | 259 |
2312620 | 2312620 | 2022-03-16 | Santa Fe | New Mexico | 35049 | 28323 | 259 |
2309367 | 2309367 | 2022-03-15 | Santa Fe | New Mexico | 35049 | 28306 | 258 |
2306114 | 2306114 | 2022-03-14 | Santa Fe | New Mexico | 35049 | 28298 | 257 |
2302863 | 2302863 | 2022-03-13 | Santa Fe | New Mexico | 35049 | 28243 | 254 |
2299611 | 2299611 | 2022-03-12 | Santa Fe | New Mexico | 35049 | 28243 | 254 |
2296359 | 2296359 | 2022-03-11 | Santa Fe | New Mexico | 35049 | 28243 | 254 |
2293107 | 2293107 | 2022-03-10 | Santa Fe | New Mexico | 35049 | 28225 | 253 |
2289855 | 2289855 | 2022-03-09 | Santa Fe | New Mexico | 35049 | 28178 | 253 |
2286603 | 2286603 | 2022-03-08 | Santa Fe | New Mexico | 35049 | 28124 | 252 |
2283351 | 2283351 | 2022-03-07 | Santa Fe | New Mexico | 35049 | 28104 | 250 |
2280098 | 2280098 | 2022-03-06 | Santa Fe | New Mexico | 35049 | 28065 | 248 |
2276845 | 2276845 | 2022-03-05 | Santa Fe | New Mexico | 35049 | 28065 | 248 |
2273592 | 2273592 | 2022-03-04 | Santa Fe | New Mexico | 35049 | 28065 | 248 |
2270340 | 2270340 | 2022-03-03 | Santa Fe | New Mexico | 35049 | 28037 | 248 |
2267087 | 2267087 | 2022-03-02 | Santa Fe | New Mexico | 35049 | 28016 | 247 |
2263836 | 2263836 | 2022-03-01 | Santa Fe | New Mexico | 35049 | 27973 | 247 |
2260585 | 2260585 | 2022-02-28 | Santa Fe | New Mexico | 35049 | 27927 | 247 |
2257334 | 2257334 | 2022-02-27 | Santa Fe | New Mexico | 35049 | 27868 | 247 |
2254083 | 2254083 | 2022-02-26 | Santa Fe | New Mexico | 35049 | 27868 | 247 |
2250832 | 2250832 | 2022-02-25 | Santa Fe | New Mexico | 35049 | 27868 | 247 |
2247581 | 2247581 | 2022-02-24 | Santa Fe | New Mexico | 35049 | 27848 | 245 |
2244330 | 2244330 | 2022-02-23 | Santa Fe | New Mexico | 35049 | 27780 | 245 |
2241079 | 2241079 | 2022-02-22 | Santa Fe | New Mexico | 35049 | 27723 | 244 |
2237828 | 2237828 | 2022-02-21 | Santa Fe | New Mexico | 35049 | 27694 | 244 |
2234577 | 2234577 | 2022-02-20 | Santa Fe | New Mexico | 35049 | 27580 | 244 |
2231326 | 2231326 | 2022-02-19 | Santa Fe | New Mexico | 35049 | 27580 | 244 |
2228075 | 2228075 | 2022-02-18 | Santa Fe | New Mexico | 35049 | 27580 | 244 |
2224824 | 2224824 | 2022-02-17 | Santa Fe | New Mexico | 35049 | 27528 | 244 |
2221573 | 2221573 | 2022-02-16 | Santa Fe | New Mexico | 35049 | 27470 | 244 |
2218322 | 2218322 | 2022-02-15 | Santa Fe | New Mexico | 35049 | 27431 | 244 |
2215071 | 2215071 | 2022-02-14 | Santa Fe | New Mexico | 35049 | 27392 | 244 |
2211819 | 2211819 | 2022-02-13 | Santa Fe | New Mexico | 35049 | 27224 | 243 |
2208566 | 2208566 | 2022-02-12 | Santa Fe | New Mexico | 35049 | 27224 | 243 |
2205313 | 2205313 | 2022-02-11 | Santa Fe | New Mexico | 35049 | 27224 | 243 |
2202060 | 2202060 | 2022-02-10 | Santa Fe | New Mexico | 35049 | 27144 | 240 |
2198806 | 2198806 | 2022-02-09 | Santa Fe | New Mexico | 35049 | 27038 | 239 |
2195552 | 2195552 | 2022-02-08 | Santa Fe | New Mexico | 35049 | 26941 | 237 |
2192298 | 2192298 | 2022-02-07 | Santa Fe | New Mexico | 35049 | 26892 | 237 |
2189045 | 2189045 | 2022-02-06 | Santa Fe | New Mexico | 35049 | 26659 | 235 |
2185792 | 2185792 | 2022-02-05 | Santa Fe | New Mexico | 35049 | 26659 | 235 |
2182540 | 2182540 | 2022-02-04 | Santa Fe | New Mexico | 35049 | 26659 | 235 |
2179288 | 2179288 | 2022-02-03 | Santa Fe | New Mexico | 35049 | 26544 | 234 |
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);