ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Rio Grande" and fips = 8105 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 |
---|---|---|---|---|---|---|---|
2499873 | 2499873 | 2022-05-13 | Rio Grande | Colorado | 8105 | 2856 | 46 |
2496615 | 2496615 | 2022-05-12 | Rio Grande | Colorado | 8105 | 2855 | 46 |
2493357 | 2493357 | 2022-05-11 | Rio Grande | Colorado | 8105 | 2848 | 46 |
2490099 | 2490099 | 2022-05-10 | Rio Grande | Colorado | 8105 | 2847 | 46 |
2486842 | 2486842 | 2022-05-09 | Rio Grande | Colorado | 8105 | 2842 | 46 |
2483584 | 2483584 | 2022-05-08 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2480326 | 2480326 | 2022-05-07 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2477068 | 2477068 | 2022-05-06 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2473810 | 2473810 | 2022-05-05 | Rio Grande | Colorado | 8105 | 2839 | 46 |
2470553 | 2470553 | 2022-05-04 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2467297 | 2467297 | 2022-05-03 | Rio Grande | Colorado | 8105 | 2837 | 46 |
2464042 | 2464042 | 2022-05-02 | Rio Grande | Colorado | 8105 | 2829 | 46 |
2460786 | 2460786 | 2022-05-01 | Rio Grande | Colorado | 8105 | 2825 | 46 |
2457530 | 2457530 | 2022-04-30 | Rio Grande | Colorado | 8105 | 2825 | 46 |
2454274 | 2454274 | 2022-04-29 | Rio Grande | Colorado | 8105 | 2825 | 46 |
2451018 | 2451018 | 2022-04-28 | Rio Grande | Colorado | 8105 | 2825 | 46 |
2447762 | 2447762 | 2022-04-27 | Rio Grande | Colorado | 8105 | 2822 | 46 |
2444506 | 2444506 | 2022-04-26 | Rio Grande | Colorado | 8105 | 2813 | 46 |
2441250 | 2441250 | 2022-04-25 | Rio Grande | Colorado | 8105 | 2813 | 46 |
2437994 | 2437994 | 2022-04-24 | Rio Grande | Colorado | 8105 | 2811 | 46 |
2434738 | 2434738 | 2022-04-23 | Rio Grande | Colorado | 8105 | 2811 | 46 |
2431482 | 2431482 | 2022-04-22 | Rio Grande | Colorado | 8105 | 2811 | 46 |
2428226 | 2428226 | 2022-04-21 | Rio Grande | Colorado | 8105 | 2810 | 46 |
2424970 | 2424970 | 2022-04-20 | Rio Grande | Colorado | 8105 | 2808 | 46 |
2421714 | 2421714 | 2022-04-19 | Rio Grande | Colorado | 8105 | 2807 | 46 |
2418458 | 2418458 | 2022-04-18 | Rio Grande | Colorado | 8105 | 2807 | 46 |
2415202 | 2415202 | 2022-04-17 | Rio Grande | Colorado | 8105 | 2804 | 46 |
2411946 | 2411946 | 2022-04-16 | Rio Grande | Colorado | 8105 | 2804 | 46 |
2408690 | 2408690 | 2022-04-15 | Rio Grande | Colorado | 8105 | 2804 | 46 |
2405434 | 2405434 | 2022-04-14 | Rio Grande | Colorado | 8105 | 2801 | 46 |
2402179 | 2402179 | 2022-04-13 | Rio Grande | Colorado | 8105 | 2800 | 46 |
2398924 | 2398924 | 2022-04-12 | Rio Grande | Colorado | 8105 | 2799 | 46 |
2395669 | 2395669 | 2022-04-11 | Rio Grande | Colorado | 8105 | 2799 | 46 |
2392413 | 2392413 | 2022-04-10 | Rio Grande | Colorado | 8105 | 2793 | 46 |
2389157 | 2389157 | 2022-04-09 | Rio Grande | Colorado | 8105 | 2793 | 46 |
2385902 | 2385902 | 2022-04-08 | Rio Grande | Colorado | 8105 | 2793 | 46 |
2382647 | 2382647 | 2022-04-07 | Rio Grande | Colorado | 8105 | 2790 | 46 |
2379392 | 2379392 | 2022-04-06 | Rio Grande | Colorado | 8105 | 2789 | 46 |
2376138 | 2376138 | 2022-04-05 | Rio Grande | Colorado | 8105 | 2786 | 46 |
2372886 | 2372886 | 2022-04-04 | Rio Grande | Colorado | 8105 | 2787 | 46 |
2369633 | 2369633 | 2022-04-03 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2366380 | 2366380 | 2022-04-02 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2363127 | 2363127 | 2022-04-01 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2359873 | 2359873 | 2022-03-31 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2356619 | 2356619 | 2022-03-30 | Rio Grande | Colorado | 8105 | 2783 | 46 |
2353366 | 2353366 | 2022-03-29 | Rio Grande | Colorado | 8105 | 2782 | 46 |
2350114 | 2350114 | 2022-03-28 | Rio Grande | Colorado | 8105 | 2777 | 46 |
2346861 | 2346861 | 2022-03-27 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2343608 | 2343608 | 2022-03-26 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2340355 | 2340355 | 2022-03-25 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2337102 | 2337102 | 2022-03-24 | Rio Grande | Colorado | 8105 | 2775 | 46 |
2333848 | 2333848 | 2022-03-23 | Rio Grande | Colorado | 8105 | 2775 | 46 |
2330594 | 2330594 | 2022-03-22 | Rio Grande | Colorado | 8105 | 2774 | 46 |
2327342 | 2327342 | 2022-03-21 | Rio Grande | Colorado | 8105 | 2773 | 46 |
2324089 | 2324089 | 2022-03-20 | Rio Grande | Colorado | 8105 | 2767 | 46 |
2320835 | 2320835 | 2022-03-19 | Rio Grande | Colorado | 8105 | 2767 | 46 |
2317581 | 2317581 | 2022-03-18 | Rio Grande | Colorado | 8105 | 2767 | 46 |
2314328 | 2314328 | 2022-03-17 | Rio Grande | Colorado | 8105 | 2767 | 46 |
2311075 | 2311075 | 2022-03-16 | Rio Grande | Colorado | 8105 | 2758 | 46 |
2307822 | 2307822 | 2022-03-15 | Rio Grande | Colorado | 8105 | 2756 | 46 |
2304571 | 2304571 | 2022-03-14 | Rio Grande | Colorado | 8105 | 2755 | 46 |
2301319 | 2301319 | 2022-03-13 | Rio Grande | Colorado | 8105 | 2753 | 46 |
2298067 | 2298067 | 2022-03-12 | Rio Grande | Colorado | 8105 | 2753 | 46 |
2294815 | 2294815 | 2022-03-11 | Rio Grande | Colorado | 8105 | 2753 | 46 |
2291563 | 2291563 | 2022-03-10 | Rio Grande | Colorado | 8105 | 2748 | 46 |
2288311 | 2288311 | 2022-03-09 | Rio Grande | Colorado | 8105 | 2746 | 46 |
2285060 | 2285060 | 2022-03-08 | Rio Grande | Colorado | 8105 | 2741 | 46 |
2281808 | 2281808 | 2022-03-07 | Rio Grande | Colorado | 8105 | 2741 | 46 |
2278555 | 2278555 | 2022-03-06 | Rio Grande | Colorado | 8105 | 2732 | 46 |
2275302 | 2275302 | 2022-03-05 | Rio Grande | Colorado | 8105 | 2732 | 46 |
2272049 | 2272049 | 2022-03-04 | Rio Grande | Colorado | 8105 | 2732 | 46 |
2268797 | 2268797 | 2022-03-03 | Rio Grande | Colorado | 8105 | 2730 | 46 |
2265544 | 2265544 | 2022-03-02 | Rio Grande | Colorado | 8105 | 2731 | 46 |
2262293 | 2262293 | 2022-03-01 | Rio Grande | Colorado | 8105 | 2726 | 46 |
2259042 | 2259042 | 2022-02-28 | Rio Grande | Colorado | 8105 | 2721 | 44 |
2255791 | 2255791 | 2022-02-27 | Rio Grande | Colorado | 8105 | 2714 | 44 |
2252540 | 2252540 | 2022-02-26 | Rio Grande | Colorado | 8105 | 2714 | 44 |
2249289 | 2249289 | 2022-02-25 | Rio Grande | Colorado | 8105 | 2714 | 44 |
2246038 | 2246038 | 2022-02-24 | Rio Grande | Colorado | 8105 | 2704 | 44 |
2242787 | 2242787 | 2022-02-23 | Rio Grande | Colorado | 8105 | 2702 | 44 |
2239536 | 2239536 | 2022-02-22 | Rio Grande | Colorado | 8105 | 2690 | 44 |
2236285 | 2236285 | 2022-02-21 | Rio Grande | Colorado | 8105 | 2684 | 44 |
2233034 | 2233034 | 2022-02-20 | Rio Grande | Colorado | 8105 | 2679 | 44 |
2229783 | 2229783 | 2022-02-19 | Rio Grande | Colorado | 8105 | 2679 | 44 |
2226532 | 2226532 | 2022-02-18 | Rio Grande | Colorado | 8105 | 2679 | 44 |
2223281 | 2223281 | 2022-02-17 | Rio Grande | Colorado | 8105 | 2673 | 44 |
2220030 | 2220030 | 2022-02-16 | Rio Grande | Colorado | 8105 | 2661 | 44 |
2216779 | 2216779 | 2022-02-15 | Rio Grande | Colorado | 8105 | 2657 | 44 |
2213528 | 2213528 | 2022-02-14 | Rio Grande | Colorado | 8105 | 2648 | 43 |
2210276 | 2210276 | 2022-02-13 | Rio Grande | Colorado | 8105 | 2635 | 43 |
2207023 | 2207023 | 2022-02-12 | Rio Grande | Colorado | 8105 | 2635 | 43 |
2203770 | 2203770 | 2022-02-11 | Rio Grande | Colorado | 8105 | 2635 | 43 |
2200517 | 2200517 | 2022-02-10 | Rio Grande | Colorado | 8105 | 2628 | 43 |
2197263 | 2197263 | 2022-02-09 | Rio Grande | Colorado | 8105 | 2613 | 43 |
2194009 | 2194009 | 2022-02-08 | Rio Grande | Colorado | 8105 | 2604 | 43 |
2190755 | 2190755 | 2022-02-07 | Rio Grande | Colorado | 8105 | 2574 | 43 |
2187502 | 2187502 | 2022-02-06 | Rio Grande | Colorado | 8105 | 2561 | 43 |
2184249 | 2184249 | 2022-02-05 | Rio Grande | Colorado | 8105 | 2561 | 43 |
2180997 | 2180997 | 2022-02-04 | Rio Grande | Colorado | 8105 | 2561 | 43 |
2177746 | 2177746 | 2022-02-03 | Rio Grande | Colorado | 8105 | 2545 | 43 |
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);