ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Glenn" 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 |
---|---|---|---|---|---|---|---|
2499772 | 2499772 | 2022-05-13 | Glenn | California | 6021 | 6631 | 67 |
2496514 | 2496514 | 2022-05-12 | Glenn | California | 6021 | 6628 | 67 |
2493256 | 2493256 | 2022-05-11 | Glenn | California | 6021 | 6628 | 67 |
2489998 | 2489998 | 2022-05-10 | Glenn | California | 6021 | 6628 | 67 |
2486741 | 2486741 | 2022-05-09 | Glenn | California | 6021 | 6623 | 67 |
2483483 | 2483483 | 2022-05-08 | Glenn | California | 6021 | 6623 | 67 |
2480225 | 2480225 | 2022-05-07 | Glenn | California | 6021 | 6623 | 67 |
2476967 | 2476967 | 2022-05-06 | Glenn | California | 6021 | 6623 | 67 |
2473709 | 2473709 | 2022-05-05 | Glenn | California | 6021 | 6621 | 67 |
2470452 | 2470452 | 2022-05-04 | Glenn | California | 6021 | 6621 | 67 |
2467196 | 2467196 | 2022-05-03 | Glenn | California | 6021 | 6621 | 67 |
2463941 | 2463941 | 2022-05-02 | Glenn | California | 6021 | 6621 | 67 |
2460685 | 2460685 | 2022-05-01 | Glenn | California | 6021 | 6621 | 67 |
2457429 | 2457429 | 2022-04-30 | Glenn | California | 6021 | 6621 | 67 |
2454173 | 2454173 | 2022-04-29 | Glenn | California | 6021 | 6621 | 67 |
2450917 | 2450917 | 2022-04-28 | Glenn | California | 6021 | 6575 | 67 |
2447661 | 2447661 | 2022-04-27 | Glenn | California | 6021 | 6575 | 67 |
2444405 | 2444405 | 2022-04-26 | Glenn | California | 6021 | 6575 | 67 |
2441149 | 2441149 | 2022-04-25 | Glenn | California | 6021 | 6571 | 67 |
2437893 | 2437893 | 2022-04-24 | Glenn | California | 6021 | 6571 | 67 |
2434637 | 2434637 | 2022-04-23 | Glenn | California | 6021 | 6571 | 67 |
2431381 | 2431381 | 2022-04-22 | Glenn | California | 6021 | 6571 | 67 |
2428125 | 2428125 | 2022-04-21 | Glenn | California | 6021 | 6566 | 67 |
2424869 | 2424869 | 2022-04-20 | Glenn | California | 6021 | 6566 | 67 |
2421613 | 2421613 | 2022-04-19 | Glenn | California | 6021 | 6566 | 67 |
2418357 | 2418357 | 2022-04-18 | Glenn | California | 6021 | 6569 | 67 |
2415101 | 2415101 | 2022-04-17 | Glenn | California | 6021 | 6569 | 67 |
2411845 | 2411845 | 2022-04-16 | Glenn | California | 6021 | 6569 | 67 |
2408589 | 2408589 | 2022-04-15 | Glenn | California | 6021 | 6569 | 67 |
2405333 | 2405333 | 2022-04-14 | Glenn | California | 6021 | 6567 | 67 |
2402078 | 2402078 | 2022-04-13 | Glenn | California | 6021 | 6565 | 67 |
2398823 | 2398823 | 2022-04-12 | Glenn | California | 6021 | 6565 | 67 |
2395568 | 2395568 | 2022-04-11 | Glenn | California | 6021 | 6565 | 67 |
2392312 | 2392312 | 2022-04-10 | Glenn | California | 6021 | 6565 | 67 |
2389056 | 2389056 | 2022-04-09 | Glenn | California | 6021 | 6565 | 67 |
2385801 | 2385801 | 2022-04-08 | Glenn | California | 6021 | 6565 | 66 |
2382546 | 2382546 | 2022-04-07 | Glenn | California | 6021 | 6563 | 66 |
2379291 | 2379291 | 2022-04-06 | Glenn | California | 6021 | 6563 | 66 |
2376037 | 2376037 | 2022-04-05 | Glenn | California | 6021 | 6563 | 66 |
2372785 | 2372785 | 2022-04-04 | Glenn | California | 6021 | 6559 | 66 |
2369532 | 2369532 | 2022-04-03 | Glenn | California | 6021 | 6559 | 66 |
2366279 | 2366279 | 2022-04-02 | Glenn | California | 6021 | 6559 | 66 |
2363026 | 2363026 | 2022-04-01 | Glenn | California | 6021 | 6559 | 66 |
2359772 | 2359772 | 2022-03-31 | Glenn | California | 6021 | 6559 | 66 |
2356518 | 2356518 | 2022-03-30 | Glenn | California | 6021 | 6557 | 66 |
2353265 | 2353265 | 2022-03-29 | Glenn | California | 6021 | 6557 | 66 |
2350013 | 2350013 | 2022-03-28 | Glenn | California | 6021 | 6557 | 66 |
2346760 | 2346760 | 2022-03-27 | Glenn | California | 6021 | 6552 | 66 |
2343507 | 2343507 | 2022-03-26 | Glenn | California | 6021 | 6552 | 66 |
2340254 | 2340254 | 2022-03-25 | Glenn | California | 6021 | 6552 | 66 |
2337001 | 2337001 | 2022-03-24 | Glenn | California | 6021 | 6549 | 66 |
2333747 | 2333747 | 2022-03-23 | Glenn | California | 6021 | 6533 | 66 |
2330493 | 2330493 | 2022-03-22 | Glenn | California | 6021 | 6534 | 66 |
2327241 | 2327241 | 2022-03-21 | Glenn | California | 6021 | 6534 | 66 |
2323988 | 2323988 | 2022-03-20 | Glenn | California | 6021 | 6533 | 66 |
2320734 | 2320734 | 2022-03-19 | Glenn | California | 6021 | 6533 | 66 |
2317480 | 2317480 | 2022-03-18 | Glenn | California | 6021 | 6533 | 66 |
2314227 | 2314227 | 2022-03-17 | Glenn | California | 6021 | 6531 | 66 |
2310974 | 2310974 | 2022-03-16 | Glenn | California | 6021 | 6528 | 66 |
2307721 | 2307721 | 2022-03-15 | Glenn | California | 6021 | 6528 | 66 |
2304470 | 2304470 | 2022-03-14 | Glenn | California | 6021 | 6528 | 66 |
2301218 | 2301218 | 2022-03-13 | Glenn | California | 6021 | 6517 | 66 |
2297966 | 2297966 | 2022-03-12 | Glenn | California | 6021 | 6517 | 66 |
2294714 | 2294714 | 2022-03-11 | Glenn | California | 6021 | 6517 | 66 |
2291462 | 2291462 | 2022-03-10 | Glenn | California | 6021 | 6515 | 66 |
2288210 | 2288210 | 2022-03-09 | Glenn | California | 6021 | 6481 | 65 |
2284959 | 2284959 | 2022-03-08 | Glenn | California | 6021 | 6476 | 64 |
2281707 | 2281707 | 2022-03-07 | Glenn | California | 6021 | 6476 | 63 |
2278454 | 2278454 | 2022-03-06 | Glenn | California | 6021 | 6464 | 63 |
2275201 | 2275201 | 2022-03-05 | Glenn | California | 6021 | 6464 | 63 |
2271948 | 2271948 | 2022-03-04 | Glenn | California | 6021 | 6464 | 63 |
2268696 | 2268696 | 2022-03-03 | Glenn | California | 6021 | 6459 | 63 |
2265443 | 2265443 | 2022-03-02 | Glenn | California | 6021 | 6450 | 63 |
2262192 | 2262192 | 2022-03-01 | Glenn | California | 6021 | 6449 | 63 |
2258941 | 2258941 | 2022-02-28 | Glenn | California | 6021 | 6446 | 63 |
2255690 | 2255690 | 2022-02-27 | Glenn | California | 6021 | 6440 | 63 |
2252439 | 2252439 | 2022-02-26 | Glenn | California | 6021 | 6440 | 63 |
2249188 | 2249188 | 2022-02-25 | Glenn | California | 6021 | 6440 | 63 |
2245937 | 2245937 | 2022-02-24 | Glenn | California | 6021 | 6440 | 62 |
2242686 | 2242686 | 2022-02-23 | Glenn | California | 6021 | 6409 | 61 |
2239435 | 2239435 | 2022-02-22 | Glenn | California | 6021 | 6406 | 61 |
2236184 | 2236184 | 2022-02-21 | Glenn | California | 6021 | 6390 | 61 |
2232933 | 2232933 | 2022-02-20 | Glenn | California | 6021 | 6390 | 61 |
2229682 | 2229682 | 2022-02-19 | Glenn | California | 6021 | 6390 | 61 |
2226431 | 2226431 | 2022-02-18 | Glenn | California | 6021 | 6390 | 61 |
2223180 | 2223180 | 2022-02-17 | Glenn | California | 6021 | 6382 | 60 |
2219929 | 2219929 | 2022-02-16 | Glenn | California | 6021 | 6379 | 60 |
2216678 | 2216678 | 2022-02-15 | Glenn | California | 6021 | 6371 | 58 |
2213427 | 2213427 | 2022-02-14 | Glenn | California | 6021 | 6364 | 58 |
2210175 | 2210175 | 2022-02-13 | Glenn | California | 6021 | 6335 | 58 |
2206922 | 2206922 | 2022-02-12 | Glenn | California | 6021 | 6335 | 58 |
2203669 | 2203669 | 2022-02-11 | Glenn | California | 6021 | 6335 | 58 |
2200416 | 2200416 | 2022-02-10 | Glenn | California | 6021 | 6321 | 58 |
2197162 | 2197162 | 2022-02-09 | Glenn | California | 6021 | 6254 | 58 |
2193907 | 2193907 | 2022-02-08 | Glenn | California | 6021 | 6232 | 58 |
2190654 | 2190654 | 2022-02-07 | Glenn | California | 6021 | 6208 | 58 |
2187401 | 2187401 | 2022-02-06 | Glenn | California | 6021 | 6161 | 58 |
2184148 | 2184148 | 2022-02-05 | Glenn | California | 6021 | 6161 | 58 |
2180896 | 2180896 | 2022-02-04 | Glenn | California | 6021 | 6161 | 58 |
2177645 | 2177645 | 2022-02-03 | Glenn | California | 6021 | 6137 | 58 |
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);