ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Alpine" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499763 | 2499763 | 2022-05-13 | Alpine | California | 6003 | 126 | 0 |
2496505 | 2496505 | 2022-05-12 | Alpine | California | 6003 | 126 | 0 |
2493247 | 2493247 | 2022-05-11 | Alpine | California | 6003 | 126 | 0 |
2489989 | 2489989 | 2022-05-10 | Alpine | California | 6003 | 126 | 0 |
2486732 | 2486732 | 2022-05-09 | Alpine | California | 6003 | 126 | 0 |
2483474 | 2483474 | 2022-05-08 | Alpine | California | 6003 | 126 | 0 |
2480216 | 2480216 | 2022-05-07 | Alpine | California | 6003 | 126 | 0 |
2476958 | 2476958 | 2022-05-06 | Alpine | California | 6003 | 126 | 0 |
2473700 | 2473700 | 2022-05-05 | Alpine | California | 6003 | 125 | 0 |
2470443 | 2470443 | 2022-05-04 | Alpine | California | 6003 | 125 | 0 |
2467187 | 2467187 | 2022-05-03 | Alpine | California | 6003 | 125 | 0 |
2463932 | 2463932 | 2022-05-02 | Alpine | California | 6003 | 125 | 0 |
2460676 | 2460676 | 2022-05-01 | Alpine | California | 6003 | 125 | 0 |
2457420 | 2457420 | 2022-04-30 | Alpine | California | 6003 | 125 | 0 |
2454164 | 2454164 | 2022-04-29 | Alpine | California | 6003 | 125 | 0 |
2450908 | 2450908 | 2022-04-28 | Alpine | California | 6003 | 125 | 0 |
2447652 | 2447652 | 2022-04-27 | Alpine | California | 6003 | 125 | 0 |
2444396 | 2444396 | 2022-04-26 | Alpine | California | 6003 | 125 | 0 |
2441140 | 2441140 | 2022-04-25 | Alpine | California | 6003 | 125 | 0 |
2437884 | 2437884 | 2022-04-24 | Alpine | California | 6003 | 125 | 0 |
2434628 | 2434628 | 2022-04-23 | Alpine | California | 6003 | 125 | 0 |
2431372 | 2431372 | 2022-04-22 | Alpine | California | 6003 | 125 | 0 |
2428116 | 2428116 | 2022-04-21 | Alpine | California | 6003 | 125 | 0 |
2424860 | 2424860 | 2022-04-20 | Alpine | California | 6003 | 125 | 0 |
2421604 | 2421604 | 2022-04-19 | Alpine | California | 6003 | 125 | 0 |
2418348 | 2418348 | 2022-04-18 | Alpine | California | 6003 | 125 | 0 |
2415092 | 2415092 | 2022-04-17 | Alpine | California | 6003 | 125 | 0 |
2411836 | 2411836 | 2022-04-16 | Alpine | California | 6003 | 125 | 0 |
2408580 | 2408580 | 2022-04-15 | Alpine | California | 6003 | 125 | 0 |
2405324 | 2405324 | 2022-04-14 | Alpine | California | 6003 | 125 | 0 |
2402069 | 2402069 | 2022-04-13 | Alpine | California | 6003 | 125 | 0 |
2398814 | 2398814 | 2022-04-12 | Alpine | California | 6003 | 125 | 0 |
2395559 | 2395559 | 2022-04-11 | Alpine | California | 6003 | 125 | 0 |
2392303 | 2392303 | 2022-04-10 | Alpine | California | 6003 | 125 | 0 |
2389047 | 2389047 | 2022-04-09 | Alpine | California | 6003 | 125 | 0 |
2385792 | 2385792 | 2022-04-08 | Alpine | California | 6003 | 125 | 0 |
2382537 | 2382537 | 2022-04-07 | Alpine | California | 6003 | 125 | 0 |
2379282 | 2379282 | 2022-04-06 | Alpine | California | 6003 | 125 | 0 |
2376028 | 2376028 | 2022-04-05 | Alpine | California | 6003 | 125 | 0 |
2372776 | 2372776 | 2022-04-04 | Alpine | California | 6003 | 125 | 0 |
2369523 | 2369523 | 2022-04-03 | Alpine | California | 6003 | 125 | 0 |
2366270 | 2366270 | 2022-04-02 | Alpine | California | 6003 | 125 | 0 |
2363017 | 2363017 | 2022-04-01 | Alpine | California | 6003 | 125 | 0 |
2359763 | 2359763 | 2022-03-31 | Alpine | California | 6003 | 125 | 0 |
2356509 | 2356509 | 2022-03-30 | Alpine | California | 6003 | 125 | 0 |
2353256 | 2353256 | 2022-03-29 | Alpine | California | 6003 | 125 | 0 |
2350004 | 2350004 | 2022-03-28 | Alpine | California | 6003 | 125 | 0 |
2346751 | 2346751 | 2022-03-27 | Alpine | California | 6003 | 125 | 0 |
2343498 | 2343498 | 2022-03-26 | Alpine | California | 6003 | 125 | 0 |
2340245 | 2340245 | 2022-03-25 | Alpine | California | 6003 | 125 | 0 |
2336992 | 2336992 | 2022-03-24 | Alpine | California | 6003 | 125 | 0 |
2333738 | 2333738 | 2022-03-23 | Alpine | California | 6003 | 123 | 0 |
2330484 | 2330484 | 2022-03-22 | Alpine | California | 6003 | 123 | 0 |
2327232 | 2327232 | 2022-03-21 | Alpine | California | 6003 | 123 | 0 |
2323979 | 2323979 | 2022-03-20 | Alpine | California | 6003 | 123 | 0 |
2320725 | 2320725 | 2022-03-19 | Alpine | California | 6003 | 123 | 0 |
2317471 | 2317471 | 2022-03-18 | Alpine | California | 6003 | 123 | 0 |
2314218 | 2314218 | 2022-03-17 | Alpine | California | 6003 | 123 | 0 |
2310965 | 2310965 | 2022-03-16 | Alpine | California | 6003 | 123 | 0 |
2307712 | 2307712 | 2022-03-15 | Alpine | California | 6003 | 123 | 0 |
2304461 | 2304461 | 2022-03-14 | Alpine | California | 6003 | 126 | 0 |
2301209 | 2301209 | 2022-03-13 | Alpine | California | 6003 | 126 | 0 |
2297957 | 2297957 | 2022-03-12 | Alpine | California | 6003 | 126 | 0 |
2294705 | 2294705 | 2022-03-11 | Alpine | California | 6003 | 126 | 0 |
2291453 | 2291453 | 2022-03-10 | Alpine | California | 6003 | 126 | 0 |
2288201 | 2288201 | 2022-03-09 | Alpine | California | 6003 | 126 | 0 |
2284950 | 2284950 | 2022-03-08 | Alpine | California | 6003 | 126 | 0 |
2281698 | 2281698 | 2022-03-07 | Alpine | California | 6003 | 126 | 0 |
2278445 | 2278445 | 2022-03-06 | Alpine | California | 6003 | 126 | 0 |
2275192 | 2275192 | 2022-03-05 | Alpine | California | 6003 | 126 | 0 |
2271939 | 2271939 | 2022-03-04 | Alpine | California | 6003 | 126 | 0 |
2268687 | 2268687 | 2022-03-03 | Alpine | California | 6003 | 126 | 0 |
2265434 | 2265434 | 2022-03-02 | Alpine | California | 6003 | 126 | 0 |
2262183 | 2262183 | 2022-03-01 | Alpine | California | 6003 | 126 | 0 |
2258932 | 2258932 | 2022-02-28 | Alpine | California | 6003 | 126 | 0 |
2255681 | 2255681 | 2022-02-27 | Alpine | California | 6003 | 126 | 0 |
2252430 | 2252430 | 2022-02-26 | Alpine | California | 6003 | 126 | 0 |
2249179 | 2249179 | 2022-02-25 | Alpine | California | 6003 | 126 | 0 |
2245928 | 2245928 | 2022-02-24 | Alpine | California | 6003 | 126 | 0 |
2242677 | 2242677 | 2022-02-23 | Alpine | California | 6003 | 125 | 0 |
2239426 | 2239426 | 2022-02-22 | Alpine | California | 6003 | 126 | 0 |
2236175 | 2236175 | 2022-02-21 | Alpine | California | 6003 | 126 | 0 |
2232924 | 2232924 | 2022-02-20 | Alpine | California | 6003 | 126 | 0 |
2229673 | 2229673 | 2022-02-19 | Alpine | California | 6003 | 126 | 0 |
2226422 | 2226422 | 2022-02-18 | Alpine | California | 6003 | 126 | 0 |
2223171 | 2223171 | 2022-02-17 | Alpine | California | 6003 | 126 | 0 |
2219920 | 2219920 | 2022-02-16 | Alpine | California | 6003 | 126 | 0 |
2216669 | 2216669 | 2022-02-15 | Alpine | California | 6003 | 126 | 0 |
2213418 | 2213418 | 2022-02-14 | Alpine | California | 6003 | 126 | 0 |
2210166 | 2210166 | 2022-02-13 | Alpine | California | 6003 | 125 | 0 |
2206913 | 2206913 | 2022-02-12 | Alpine | California | 6003 | 125 | 0 |
2203660 | 2203660 | 2022-02-11 | Alpine | California | 6003 | 125 | 0 |
2200407 | 2200407 | 2022-02-10 | Alpine | California | 6003 | 125 | 0 |
2197153 | 2197153 | 2022-02-09 | Alpine | California | 6003 | 125 | 0 |
2193898 | 2193898 | 2022-02-08 | Alpine | California | 6003 | 125 | 0 |
2190645 | 2190645 | 2022-02-07 | Alpine | California | 6003 | 124 | 0 |
2187392 | 2187392 | 2022-02-06 | Alpine | California | 6003 | 125 | 0 |
2184139 | 2184139 | 2022-02-05 | Alpine | California | 6003 | 125 | 0 |
2180887 | 2180887 | 2022-02-04 | Alpine | California | 6003 | 125 | 0 |
2177636 | 2177636 | 2022-02-03 | Alpine | California | 6003 | 124 | 0 |
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);