ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Santa Rosa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 164 ✖
- 291 122
- 9 61
- 1 23
- 520 18
- 523 14
- 531 14
- 618 14
- 620 14
- 512 13
- 2 12
- 485 12
- 6 11
- 276 11
- 278 11
- 284 9
- 88 8
- 468 8
- 514 8
- 605 8
- 8 7
- 86 7
- 282 7
- 446 7
- 518 7
- 525 7
- 527 7
- 534 7
- 538 7
- 546 7
- 552 7
- 561 7
- 576 7
- 584 7
- 598 7
- 613 7
- 615 7
- 279 6
- 287 6
- 607 6
- 11 5
- 19 5
- 54 5
- 55 5
- 59 5
- 69 5
- 77 5
- 82 5
- 89 5
- 102 5
- 262 5
- 519 5
- 4 4
- 22 4
- 76 4
- 78 4
- 85 4
- 97 4
- 104 4
- 120 4
- 222 4
- 267 4
- 274 4
- 285 4
- 290 4
- 418 4
- 7 3
- 10 3
- 24 3
- 47 3
- 66 3
- 87 3
- 93 3
- 130 3
- 155 3
- 177 3
- 195 3
- 209 3
- 215 3
- 499 3
- 621 3
- 3 2
- 13 2
- 15 2
- 37 2
- 50 2
- 53 2
- 58 2
- 71 2
- 84 2
- 90 2
- 96 2
- 100 2
- 103 2
- 105 2
- 110 2
- 113 2
- 114 2
- 115 2
- 117 2
- 121 2
- 128 2
- 217 2
- 237 2
- 243 2
- 250 2
- 251 2
- 256 2
- 0 1
- 5 1
- 12 1
- 17 1
- 18 1
- 30 1
- 32 1
- 34 1
- 36 1
- 38 1
- 40 1
- 41 1
- 44 1
- 45 1
- 57 1
- 60 1
- 63 1
- 65 1
- 70 1
- 74 1
- 75 1
- 80 1
- 95 1
- 99 1
- 109 1
- 112 1
- 122 1
- 123 1
- 124 1
- 137 1
- 142 1
- 143 1
- 148 1
- 157 1
- 164 1
- 169 1
- 174 1
- 178 1
- 189 1
- 194 1
- 199 1
- 206 1
- 211 1
- 234 1
- 238 1
- 241 1
- 244 1
- 246 1
- 247 1
- 252 1
- 257 1
- 269 1
- 270 1
- 271 1
- 277 1
- 283 1
- 286 1
state 1
- Florida 800
fips 1
- 12113 800
county 1
- Santa Rosa · 800 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499952 | 2499952 | 2022-05-13 | Santa Rosa | Florida | 12113 | 48592 | 621 |
2496694 | 2496694 | 2022-05-12 | Santa Rosa | Florida | 12113 | 48592 | 621 |
2493436 | 2493436 | 2022-05-11 | Santa Rosa | Florida | 12113 | 48592 | 621 |
2490178 | 2490178 | 2022-05-10 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2486921 | 2486921 | 2022-05-09 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2483663 | 2483663 | 2022-05-08 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2480405 | 2480405 | 2022-05-07 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2477147 | 2477147 | 2022-05-06 | Santa Rosa | Florida | 12113 | 48592 | 620 |
2473889 | 2473889 | 2022-05-05 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2470632 | 2470632 | 2022-05-04 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2467376 | 2467376 | 2022-05-03 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2464121 | 2464121 | 2022-05-02 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2460865 | 2460865 | 2022-05-01 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2457609 | 2457609 | 2022-04-30 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2454353 | 2454353 | 2022-04-29 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2451097 | 2451097 | 2022-04-28 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2447841 | 2447841 | 2022-04-27 | Santa Rosa | Florida | 12113 | 48436 | 620 |
2444585 | 2444585 | 2022-04-26 | Santa Rosa | Florida | 12113 | 48436 | 618 |
2441329 | 2441329 | 2022-04-25 | Santa Rosa | Florida | 12113 | 48436 | 618 |
2438073 | 2438073 | 2022-04-24 | Santa Rosa | Florida | 12113 | 48436 | 618 |
2434817 | 2434817 | 2022-04-23 | Santa Rosa | Florida | 12113 | 48436 | 618 |
2431561 | 2431561 | 2022-04-22 | Santa Rosa | Florida | 12113 | 48436 | 618 |
2428305 | 2428305 | 2022-04-21 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2425049 | 2425049 | 2022-04-20 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2421793 | 2421793 | 2022-04-19 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2418537 | 2418537 | 2022-04-18 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2415281 | 2415281 | 2022-04-17 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2412025 | 2412025 | 2022-04-16 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2408769 | 2408769 | 2022-04-15 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2405513 | 2405513 | 2022-04-14 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2402258 | 2402258 | 2022-04-13 | Santa Rosa | Florida | 12113 | 48346 | 618 |
2399003 | 2399003 | 2022-04-12 | Santa Rosa | Florida | 12113 | 48346 | 615 |
2395748 | 2395748 | 2022-04-11 | Santa Rosa | Florida | 12113 | 48346 | 615 |
2392492 | 2392492 | 2022-04-10 | Santa Rosa | Florida | 12113 | 48346 | 615 |
2389236 | 2389236 | 2022-04-09 | Santa Rosa | Florida | 12113 | 48346 | 615 |
2385981 | 2385981 | 2022-04-08 | Santa Rosa | Florida | 12113 | 48346 | 615 |
2382726 | 2382726 | 2022-04-07 | Santa Rosa | Florida | 12113 | 48302 | 615 |
2379471 | 2379471 | 2022-04-06 | Santa Rosa | Florida | 12113 | 48302 | 615 |
2376217 | 2376217 | 2022-04-05 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2372965 | 2372965 | 2022-04-04 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2369712 | 2369712 | 2022-04-03 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2366459 | 2366459 | 2022-04-02 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2363206 | 2363206 | 2022-04-01 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2359952 | 2359952 | 2022-03-31 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2356698 | 2356698 | 2022-03-30 | Santa Rosa | Florida | 12113 | 48302 | 613 |
2353445 | 2353445 | 2022-03-29 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2350193 | 2350193 | 2022-03-28 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2346940 | 2346940 | 2022-03-27 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2343687 | 2343687 | 2022-03-26 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2340434 | 2340434 | 2022-03-25 | Santa Rosa | Florida | 12113 | 48302 | 607 |
2337181 | 2337181 | 2022-03-24 | Santa Rosa | Florida | 12113 | 48241 | 607 |
2333927 | 2333927 | 2022-03-23 | Santa Rosa | Florida | 12113 | 48241 | 605 |
2330673 | 2330673 | 2022-03-22 | Santa Rosa | Florida | 12113 | 48241 | 605 |
2327421 | 2327421 | 2022-03-21 | Santa Rosa | Florida | 12113 | 48241 | 605 |
2324168 | 2324168 | 2022-03-20 | Santa Rosa | Florida | 12113 | 48241 | 605 |
2320914 | 2320914 | 2022-03-19 | Santa Rosa | Florida | 12113 | 48241 | 605 |
2317660 | 2317660 | 2022-03-18 | Santa Rosa | Florida | 12113 | 48241 | 605 |
2314407 | 2314407 | 2022-03-17 | Santa Rosa | Florida | 12113 | 48241 | 605 |
2311154 | 2311154 | 2022-03-16 | Santa Rosa | Florida | 12113 | 48241 | 605 |
2307901 | 2307901 | 2022-03-15 | Santa Rosa | Florida | 12113 | 48241 | 598 |
2304650 | 2304650 | 2022-03-14 | Santa Rosa | Florida | 12113 | 48241 | 598 |
2301398 | 2301398 | 2022-03-13 | Santa Rosa | Florida | 12113 | 48241 | 598 |
2298146 | 2298146 | 2022-03-12 | Santa Rosa | Florida | 12113 | 48241 | 598 |
2294894 | 2294894 | 2022-03-11 | Santa Rosa | Florida | 12113 | 48241 | 598 |
2291642 | 2291642 | 2022-03-10 | Santa Rosa | Florida | 12113 | 48204 | 598 |
2288390 | 2288390 | 2022-03-09 | Santa Rosa | Florida | 12113 | 48204 | 598 |
2285139 | 2285139 | 2022-03-08 | Santa Rosa | Florida | 12113 | 48204 | 584 |
2281887 | 2281887 | 2022-03-07 | Santa Rosa | Florida | 12113 | 48204 | 584 |
2278634 | 2278634 | 2022-03-06 | Santa Rosa | Florida | 12113 | 48204 | 584 |
2275381 | 2275381 | 2022-03-05 | Santa Rosa | Florida | 12113 | 48204 | 584 |
2272128 | 2272128 | 2022-03-04 | Santa Rosa | Florida | 12113 | 48204 | 584 |
2268876 | 2268876 | 2022-03-03 | Santa Rosa | Florida | 12113 | 48104 | 584 |
2265623 | 2265623 | 2022-03-02 | Santa Rosa | Florida | 12113 | 48104 | 584 |
2262372 | 2262372 | 2022-03-01 | Santa Rosa | Florida | 12113 | 48104 | 576 |
2259121 | 2259121 | 2022-02-28 | Santa Rosa | Florida | 12113 | 48104 | 576 |
2255870 | 2255870 | 2022-02-27 | Santa Rosa | Florida | 12113 | 48104 | 576 |
2252619 | 2252619 | 2022-02-26 | Santa Rosa | Florida | 12113 | 48104 | 576 |
2249368 | 2249368 | 2022-02-25 | Santa Rosa | Florida | 12113 | 48104 | 576 |
2246117 | 2246117 | 2022-02-24 | Santa Rosa | Florida | 12113 | 47901 | 576 |
2242866 | 2242866 | 2022-02-23 | Santa Rosa | Florida | 12113 | 47901 | 576 |
2239615 | 2239615 | 2022-02-22 | Santa Rosa | Florida | 12113 | 47901 | 561 |
2236364 | 2236364 | 2022-02-21 | Santa Rosa | Florida | 12113 | 47901 | 561 |
2233113 | 2233113 | 2022-02-20 | Santa Rosa | Florida | 12113 | 47901 | 561 |
2229862 | 2229862 | 2022-02-19 | Santa Rosa | Florida | 12113 | 47901 | 561 |
2226611 | 2226611 | 2022-02-18 | Santa Rosa | Florida | 12113 | 47901 | 561 |
2223360 | 2223360 | 2022-02-17 | Santa Rosa | Florida | 12113 | 47464 | 561 |
2220109 | 2220109 | 2022-02-16 | Santa Rosa | Florida | 12113 | 47464 | 561 |
2216858 | 2216858 | 2022-02-15 | Santa Rosa | Florida | 12113 | 47464 | 552 |
2213607 | 2213607 | 2022-02-14 | Santa Rosa | Florida | 12113 | 47464 | 552 |
2210355 | 2210355 | 2022-02-13 | Santa Rosa | Florida | 12113 | 47464 | 552 |
2207102 | 2207102 | 2022-02-12 | Santa Rosa | Florida | 12113 | 47464 | 552 |
2203849 | 2203849 | 2022-02-11 | Santa Rosa | Florida | 12113 | 47464 | 552 |
2200596 | 2200596 | 2022-02-10 | Santa Rosa | Florida | 12113 | 45838 | 552 |
2197342 | 2197342 | 2022-02-09 | Santa Rosa | Florida | 12113 | 45838 | 552 |
2194088 | 2194088 | 2022-02-08 | Santa Rosa | Florida | 12113 | 45838 | 546 |
2190834 | 2190834 | 2022-02-07 | Santa Rosa | Florida | 12113 | 45838 | 546 |
2187581 | 2187581 | 2022-02-06 | Santa Rosa | Florida | 12113 | 45838 | 546 |
2184328 | 2184328 | 2022-02-05 | Santa Rosa | Florida | 12113 | 45838 | 546 |
2181076 | 2181076 | 2022-02-04 | Santa Rosa | Florida | 12113 | 45838 | 546 |
2177825 | 2177825 | 2022-02-03 | Santa Rosa | Florida | 12113 | 44198 | 546 |
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);