ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,553 rows where county = "Otero" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 162 ✖
- 6 113
- 1 101
- 0 73
- 67 70
- 63 56
- 13 46
- 125 41
- 126 33
- 10 31
- 75 30
- 68 29
- 12 26
- 77 25
- 74 24
- 86 23
- 92 22
- 61 21
- 71 21
- 66 20
- 181 19
- 7 18
- 81 16
- 187 16
- 11 15
- 50 15
- 118 15
- 127 15
- 4 14
- 97 14
- 9 13
- 80 13
- 84 13
- 72 12
- 130 12
- 57 11
- 65 11
- 122 11
- 89 10
- 185 10
- 2 9
- 88 9
- 115 9
- 180 9
- 3 8
- 17 8
- 22 8
- 47 8
- 69 8
- 70 8
- 91 8
- 103 8
- 23 7
- 54 7
- 96 7
- 116 7
- 179 7
- 183 7
- 31 6
- 34 6
- 35 6
- 43 6
- 49 6
- 56 6
- 59 6
- 60 6
- 76 6
- 78 6
- 79 6
- 94 6
- 99 6
- 102 6
- 114 6
- 123 6
- 128 6
- 145 6
- 152 6
- 158 6
- 18 5
- 38 5
- 62 5
- 64 5
- 93 5
- 117 5
- 164 5
- 184 5
- 33 4
- 36 4
- 41 4
- 55 4
- 83 4
- 85 4
- 104 4
- 108 4
- 131 4
- 133 4
- 140 4
- 148 4
- 156 4
- 5 3
- 25 3
- 27 3
- 29 3
- 32 3
- 39 3
- 42 3
- 90 3
- 95 3
- 111 3
- 113 3
- 120 3
- 157 3
- 160 3
- 169 3
- 177 3
- 8 2
- 14 2
- 15 2
- 19 2
- 24 2
- 28 2
- 40 2
- 44 2
- 46 2
- 48 2
- 51 2
- 53 2
- 58 2
- 82 2
- 106 2
- 110 2
- 119 2
- 121 2
- 132 2
- 139 2
- 143 2
- 159 2
- 162 2
- 165 2
- 167 2
- 16 1
- 20 1
- 30 1
- 45 1
- 52 1
- 73 1
- 100 1
- 105 1
- 107 1
- 112 1
- 136 1
- 146 1
- 147 1
- 149 1
- 150 1
- 151 1
- 154 1
- 172 1
- 173 1
- 175 1
- 176 1
- 178 1
- 182 1
state 2
- Colorado 780
- New Mexico 773
county 1
- Otero · 1,553 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499865 | 2499865 | 2022-05-13 | Otero | Colorado | 8089 | 4322 | 130 |
2501413 | 2501413 | 2022-05-13 | Otero | New Mexico | 35035 | 15613 | 187 |
2496607 | 2496607 | 2022-05-12 | Otero | Colorado | 8089 | 4319 | 130 |
2498155 | 2498155 | 2022-05-12 | Otero | New Mexico | 35035 | 15595 | 187 |
2493349 | 2493349 | 2022-05-11 | Otero | Colorado | 8089 | 4309 | 130 |
2494897 | 2494897 | 2022-05-11 | Otero | New Mexico | 35035 | 15594 | 187 |
2490091 | 2490091 | 2022-05-10 | Otero | Colorado | 8089 | 4309 | 130 |
2491639 | 2491639 | 2022-05-10 | Otero | New Mexico | 35035 | 15587 | 187 |
2486834 | 2486834 | 2022-05-09 | Otero | Colorado | 8089 | 4309 | 130 |
2488381 | 2488381 | 2022-05-09 | Otero | New Mexico | 35035 | 15586 | 187 |
2483576 | 2483576 | 2022-05-08 | Otero | Colorado | 8089 | 4308 | 130 |
2485124 | 2485124 | 2022-05-08 | Otero | New Mexico | 35035 | 15578 | 187 |
2480318 | 2480318 | 2022-05-07 | Otero | Colorado | 8089 | 4308 | 130 |
2481866 | 2481866 | 2022-05-07 | Otero | New Mexico | 35035 | 15578 | 187 |
2477060 | 2477060 | 2022-05-06 | Otero | Colorado | 8089 | 4308 | 130 |
2478608 | 2478608 | 2022-05-06 | Otero | New Mexico | 35035 | 15578 | 187 |
2473802 | 2473802 | 2022-05-05 | Otero | Colorado | 8089 | 4303 | 130 |
2475350 | 2475350 | 2022-05-05 | Otero | New Mexico | 35035 | 15573 | 187 |
2470545 | 2470545 | 2022-05-04 | Otero | Colorado | 8089 | 4302 | 130 |
2472093 | 2472093 | 2022-05-04 | Otero | New Mexico | 35035 | 15567 | 187 |
2467289 | 2467289 | 2022-05-03 | Otero | Colorado | 8089 | 4299 | 130 |
2468837 | 2468837 | 2022-05-03 | Otero | New Mexico | 35035 | 15562 | 187 |
2464034 | 2464034 | 2022-05-02 | Otero | Colorado | 8089 | 4299 | 127 |
2465581 | 2465581 | 2022-05-02 | Otero | New Mexico | 35035 | 15561 | 187 |
2460778 | 2460778 | 2022-05-01 | Otero | Colorado | 8089 | 4299 | 127 |
2462326 | 2462326 | 2022-05-01 | Otero | New Mexico | 35035 | 15552 | 187 |
2457522 | 2457522 | 2022-04-30 | Otero | Colorado | 8089 | 4299 | 127 |
2459070 | 2459070 | 2022-04-30 | Otero | New Mexico | 35035 | 15552 | 187 |
2454266 | 2454266 | 2022-04-29 | Otero | Colorado | 8089 | 4299 | 127 |
2455814 | 2455814 | 2022-04-29 | Otero | New Mexico | 35035 | 15552 | 187 |
2451010 | 2451010 | 2022-04-28 | Otero | Colorado | 8089 | 4298 | 127 |
2452558 | 2452558 | 2022-04-28 | Otero | New Mexico | 35035 | 15551 | 187 |
2447754 | 2447754 | 2022-04-27 | Otero | Colorado | 8089 | 4298 | 127 |
2449302 | 2449302 | 2022-04-27 | Otero | New Mexico | 35035 | 15555 | 185 |
2444498 | 2444498 | 2022-04-26 | Otero | Colorado | 8089 | 4296 | 127 |
2446045 | 2446045 | 2022-04-26 | Otero | New Mexico | 35035 | 15555 | 185 |
2441242 | 2441242 | 2022-04-25 | Otero | Colorado | 8089 | 4295 | 127 |
2442790 | 2442790 | 2022-04-25 | Otero | New Mexico | 35035 | 15555 | 185 |
2437986 | 2437986 | 2022-04-24 | Otero | Colorado | 8089 | 4295 | 127 |
2439534 | 2439534 | 2022-04-24 | Otero | New Mexico | 35035 | 15549 | 185 |
2434730 | 2434730 | 2022-04-23 | Otero | Colorado | 8089 | 4295 | 127 |
2436278 | 2436278 | 2022-04-23 | Otero | New Mexico | 35035 | 15549 | 185 |
2431474 | 2431474 | 2022-04-22 | Otero | Colorado | 8089 | 4295 | 127 |
2433022 | 2433022 | 2022-04-22 | Otero | New Mexico | 35035 | 15549 | 185 |
2428218 | 2428218 | 2022-04-21 | Otero | Colorado | 8089 | 4292 | 127 |
2429766 | 2429766 | 2022-04-21 | Otero | New Mexico | 35035 | 15549 | 185 |
2424962 | 2424962 | 2022-04-20 | Otero | Colorado | 8089 | 4290 | 127 |
2426510 | 2426510 | 2022-04-20 | Otero | New Mexico | 35035 | 15546 | 185 |
2421706 | 2421706 | 2022-04-19 | Otero | Colorado | 8089 | 4289 | 127 |
2423254 | 2423254 | 2022-04-19 | Otero | New Mexico | 35035 | 15546 | 185 |
2418450 | 2418450 | 2022-04-18 | Otero | Colorado | 8089 | 4283 | 127 |
2419997 | 2419997 | 2022-04-18 | Otero | New Mexico | 35035 | 15544 | 185 |
2415194 | 2415194 | 2022-04-17 | Otero | Colorado | 8089 | 4284 | 126 |
2416742 | 2416742 | 2022-04-17 | Otero | New Mexico | 35035 | 15543 | 184 |
2411938 | 2411938 | 2022-04-16 | Otero | Colorado | 8089 | 4284 | 126 |
2413486 | 2413486 | 2022-04-16 | Otero | New Mexico | 35035 | 15543 | 184 |
2408682 | 2408682 | 2022-04-15 | Otero | Colorado | 8089 | 4284 | 126 |
2410230 | 2410230 | 2022-04-15 | Otero | New Mexico | 35035 | 15543 | 184 |
2405426 | 2405426 | 2022-04-14 | Otero | Colorado | 8089 | 4282 | 126 |
2406974 | 2406974 | 2022-04-14 | Otero | New Mexico | 35035 | 15536 | 184 |
2402171 | 2402171 | 2022-04-13 | Otero | Colorado | 8089 | 4279 | 126 |
2403718 | 2403718 | 2022-04-13 | Otero | New Mexico | 35035 | 15533 | 184 |
2398916 | 2398916 | 2022-04-12 | Otero | Colorado | 8089 | 4275 | 126 |
2400463 | 2400463 | 2022-04-12 | Otero | New Mexico | 35035 | 15527 | 183 |
2395661 | 2395661 | 2022-04-11 | Otero | Colorado | 8089 | 4275 | 126 |
2397208 | 2397208 | 2022-04-11 | Otero | New Mexico | 35035 | 15526 | 183 |
2392405 | 2392405 | 2022-04-10 | Otero | Colorado | 8089 | 4274 | 126 |
2393953 | 2393953 | 2022-04-10 | Otero | New Mexico | 35035 | 15518 | 183 |
2389149 | 2389149 | 2022-04-09 | Otero | Colorado | 8089 | 4274 | 126 |
2390697 | 2390697 | 2022-04-09 | Otero | New Mexico | 35035 | 15518 | 183 |
2385894 | 2385894 | 2022-04-08 | Otero | Colorado | 8089 | 4274 | 126 |
2387441 | 2387441 | 2022-04-08 | Otero | New Mexico | 35035 | 15518 | 183 |
2382639 | 2382639 | 2022-04-07 | Otero | Colorado | 8089 | 4272 | 126 |
2384186 | 2384186 | 2022-04-07 | Otero | New Mexico | 35035 | 15513 | 183 |
2379384 | 2379384 | 2022-04-06 | Otero | Colorado | 8089 | 4269 | 126 |
2380931 | 2380931 | 2022-04-06 | Otero | New Mexico | 35035 | 15507 | 183 |
2376130 | 2376130 | 2022-04-05 | Otero | Colorado | 8089 | 4270 | 126 |
2377676 | 2377676 | 2022-04-05 | Otero | New Mexico | 35035 | 15507 | 182 |
2372878 | 2372878 | 2022-04-04 | Otero | Colorado | 8089 | 4270 | 126 |
2374423 | 2374423 | 2022-04-04 | Otero | New Mexico | 35035 | 15503 | 181 |
2369625 | 2369625 | 2022-04-03 | Otero | Colorado | 8089 | 4267 | 126 |
2371171 | 2371171 | 2022-04-03 | Otero | New Mexico | 35035 | 15494 | 181 |
2366372 | 2366372 | 2022-04-02 | Otero | Colorado | 8089 | 4267 | 126 |
2367918 | 2367918 | 2022-04-02 | Otero | New Mexico | 35035 | 15494 | 181 |
2363119 | 2363119 | 2022-04-01 | Otero | Colorado | 8089 | 4267 | 126 |
2364665 | 2364665 | 2022-04-01 | Otero | New Mexico | 35035 | 15494 | 181 |
2359865 | 2359865 | 2022-03-31 | Otero | Colorado | 8089 | 4263 | 126 |
2361411 | 2361411 | 2022-03-31 | Otero | New Mexico | 35035 | 15491 | 181 |
2356611 | 2356611 | 2022-03-30 | Otero | Colorado | 8089 | 4256 | 126 |
2358157 | 2358157 | 2022-03-30 | Otero | New Mexico | 35035 | 15488 | 181 |
2353358 | 2353358 | 2022-03-29 | Otero | Colorado | 8089 | 4255 | 126 |
2354904 | 2354904 | 2022-03-29 | Otero | New Mexico | 35035 | 15483 | 181 |
2350106 | 2350106 | 2022-03-28 | Otero | Colorado | 8089 | 4252 | 126 |
2351651 | 2351651 | 2022-03-28 | Otero | New Mexico | 35035 | 15478 | 181 |
2346853 | 2346853 | 2022-03-27 | Otero | Colorado | 8089 | 4254 | 126 |
2348399 | 2348399 | 2022-03-27 | Otero | New Mexico | 35035 | 15476 | 181 |
2343600 | 2343600 | 2022-03-26 | Otero | Colorado | 8089 | 4254 | 126 |
2345146 | 2345146 | 2022-03-26 | Otero | New Mexico | 35035 | 15476 | 181 |
2340347 | 2340347 | 2022-03-25 | Otero | Colorado | 8089 | 4254 | 126 |
2341893 | 2341893 | 2022-03-25 | Otero | New Mexico | 35035 | 15476 | 181 |
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);