ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,518 rows where county = "Rio Grande" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499873 | 2499873 | 2022-05-13 | Rio Grande | Colorado | 8105 | 2856 | 46 |
2501974 | 2501974 | 2022-05-13 | Rio Grande | Puerto Rico | 72119 | 8656 | |
2496615 | 2496615 | 2022-05-12 | Rio Grande | Colorado | 8105 | 2855 | 46 |
2498716 | 2498716 | 2022-05-12 | Rio Grande | Puerto Rico | 72119 | 8585 | |
2493357 | 2493357 | 2022-05-11 | Rio Grande | Colorado | 8105 | 2848 | 46 |
2495458 | 2495458 | 2022-05-11 | Rio Grande | Puerto Rico | 72119 | 8544 | |
2490099 | 2490099 | 2022-05-10 | Rio Grande | Colorado | 8105 | 2847 | 46 |
2492200 | 2492200 | 2022-05-10 | Rio Grande | Puerto Rico | 72119 | 8447 | |
2486842 | 2486842 | 2022-05-09 | Rio Grande | Colorado | 8105 | 2842 | 46 |
2488942 | 2488942 | 2022-05-09 | Rio Grande | Puerto Rico | 72119 | 8443 | |
2483584 | 2483584 | 2022-05-08 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2485685 | 2485685 | 2022-05-08 | Rio Grande | Puerto Rico | 72119 | 8378 | |
2480326 | 2480326 | 2022-05-07 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2482427 | 2482427 | 2022-05-07 | Rio Grande | Puerto Rico | 72119 | 8377 | |
2477068 | 2477068 | 2022-05-06 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2479169 | 2479169 | 2022-05-06 | Rio Grande | Puerto Rico | 72119 | 8316 | |
2473810 | 2473810 | 2022-05-05 | Rio Grande | Colorado | 8105 | 2839 | 46 |
2475911 | 2475911 | 2022-05-05 | Rio Grande | Puerto Rico | 72119 | 8216 | |
2470553 | 2470553 | 2022-05-04 | Rio Grande | Colorado | 8105 | 2841 | 46 |
2472654 | 2472654 | 2022-05-04 | Rio Grande | Puerto Rico | 72119 | 8155 | |
2467297 | 2467297 | 2022-05-03 | Rio Grande | Colorado | 8105 | 2837 | 46 |
2469398 | 2469398 | 2022-05-03 | Rio Grande | Puerto Rico | 72119 | 8125 | |
2464042 | 2464042 | 2022-05-02 | Rio Grande | Colorado | 8105 | 2829 | 46 |
2466142 | 2466142 | 2022-05-02 | Rio Grande | Puerto Rico | 72119 | 8120 | |
2460786 | 2460786 | 2022-05-01 | Rio Grande | Colorado | 8105 | 2825 | 46 |
2462887 | 2462887 | 2022-05-01 | Rio Grande | Puerto Rico | 72119 | 8083 | |
2457530 | 2457530 | 2022-04-30 | Rio Grande | Colorado | 8105 | 2825 | 46 |
2459631 | 2459631 | 2022-04-30 | Rio Grande | Puerto Rico | 72119 | 8025 | |
2454274 | 2454274 | 2022-04-29 | Rio Grande | Colorado | 8105 | 2825 | 46 |
2456375 | 2456375 | 2022-04-29 | Rio Grande | Puerto Rico | 72119 | 7947 | |
2451018 | 2451018 | 2022-04-28 | Rio Grande | Colorado | 8105 | 2825 | 46 |
2453119 | 2453119 | 2022-04-28 | Rio Grande | Puerto Rico | 72119 | 7879 | |
2447762 | 2447762 | 2022-04-27 | Rio Grande | Colorado | 8105 | 2822 | 46 |
2449863 | 2449863 | 2022-04-27 | Rio Grande | Puerto Rico | 72119 | 7784 | |
2444506 | 2444506 | 2022-04-26 | Rio Grande | Colorado | 8105 | 2813 | 46 |
2446606 | 2446606 | 2022-04-26 | Rio Grande | Puerto Rico | 72119 | 7751 | |
2441250 | 2441250 | 2022-04-25 | Rio Grande | Colorado | 8105 | 2813 | 46 |
2443351 | 2443351 | 2022-04-25 | Rio Grande | Puerto Rico | 72119 | 7744 | |
2437994 | 2437994 | 2022-04-24 | Rio Grande | Colorado | 8105 | 2811 | 46 |
2440095 | 2440095 | 2022-04-24 | Rio Grande | Puerto Rico | 72119 | 7726 | |
2434738 | 2434738 | 2022-04-23 | Rio Grande | Colorado | 8105 | 2811 | 46 |
2436839 | 2436839 | 2022-04-23 | Rio Grande | Puerto Rico | 72119 | 7692 | |
2431482 | 2431482 | 2022-04-22 | Rio Grande | Colorado | 8105 | 2811 | 46 |
2433583 | 2433583 | 2022-04-22 | Rio Grande | Puerto Rico | 72119 | 7652 | |
2428226 | 2428226 | 2022-04-21 | Rio Grande | Colorado | 8105 | 2810 | 46 |
2430327 | 2430327 | 2022-04-21 | Rio Grande | Puerto Rico | 72119 | 7566 | |
2424970 | 2424970 | 2022-04-20 | Rio Grande | Colorado | 8105 | 2808 | 46 |
2427071 | 2427071 | 2022-04-20 | Rio Grande | Puerto Rico | 72119 | 7519 | |
2421714 | 2421714 | 2022-04-19 | Rio Grande | Colorado | 8105 | 2807 | 46 |
2423815 | 2423815 | 2022-04-19 | Rio Grande | Puerto Rico | 72119 | 7506 | |
2418458 | 2418458 | 2022-04-18 | Rio Grande | Colorado | 8105 | 2807 | 46 |
2420559 | 2420559 | 2022-04-18 | Rio Grande | Puerto Rico | 72119 | 7506 | |
2415202 | 2415202 | 2022-04-17 | Rio Grande | Colorado | 8105 | 2804 | 46 |
2417303 | 2417303 | 2022-04-17 | Rio Grande | Puerto Rico | 72119 | 7497 | |
2411946 | 2411946 | 2022-04-16 | Rio Grande | Colorado | 8105 | 2804 | 46 |
2414047 | 2414047 | 2022-04-16 | Rio Grande | Puerto Rico | 72119 | 7423 | |
2408690 | 2408690 | 2022-04-15 | Rio Grande | Colorado | 8105 | 2804 | 46 |
2410791 | 2410791 | 2022-04-15 | Rio Grande | Puerto Rico | 72119 | 7423 | |
2405434 | 2405434 | 2022-04-14 | Rio Grande | Colorado | 8105 | 2801 | 46 |
2407535 | 2407535 | 2022-04-14 | Rio Grande | Puerto Rico | 72119 | 7423 | |
2402179 | 2402179 | 2022-04-13 | Rio Grande | Colorado | 8105 | 2800 | 46 |
2404279 | 2404279 | 2022-04-13 | Rio Grande | Puerto Rico | 72119 | 7406 | |
2398924 | 2398924 | 2022-04-12 | Rio Grande | Colorado | 8105 | 2799 | 46 |
2401024 | 2401024 | 2022-04-12 | Rio Grande | Puerto Rico | 72119 | 7394 | |
2395669 | 2395669 | 2022-04-11 | Rio Grande | Colorado | 8105 | 2799 | 46 |
2397769 | 2397769 | 2022-04-11 | Rio Grande | Puerto Rico | 72119 | 7394 | |
2392413 | 2392413 | 2022-04-10 | Rio Grande | Colorado | 8105 | 2793 | 46 |
2394514 | 2394514 | 2022-04-10 | Rio Grande | Puerto Rico | 72119 | 7387 | |
2389157 | 2389157 | 2022-04-09 | Rio Grande | Colorado | 8105 | 2793 | 46 |
2391258 | 2391258 | 2022-04-09 | Rio Grande | Puerto Rico | 72119 | 7371 | |
2385902 | 2385902 | 2022-04-08 | Rio Grande | Colorado | 8105 | 2793 | 46 |
2388002 | 2388002 | 2022-04-08 | Rio Grande | Puerto Rico | 72119 | 7359 | |
2382647 | 2382647 | 2022-04-07 | Rio Grande | Colorado | 8105 | 2790 | 46 |
2384747 | 2384747 | 2022-04-07 | Rio Grande | Puerto Rico | 72119 | 7344 | |
2379392 | 2379392 | 2022-04-06 | Rio Grande | Colorado | 8105 | 2789 | 46 |
2381492 | 2381492 | 2022-04-06 | Rio Grande | Puerto Rico | 72119 | 7323 | |
2376138 | 2376138 | 2022-04-05 | Rio Grande | Colorado | 8105 | 2786 | 46 |
2378237 | 2378237 | 2022-04-05 | Rio Grande | Puerto Rico | 72119 | 7313 | |
2372886 | 2372886 | 2022-04-04 | Rio Grande | Colorado | 8105 | 2787 | 46 |
2374983 | 2374983 | 2022-04-04 | Rio Grande | Puerto Rico | 72119 | 7312 | |
2369633 | 2369633 | 2022-04-03 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2371731 | 2371731 | 2022-04-03 | Rio Grande | Puerto Rico | 72119 | 7309 | |
2366380 | 2366380 | 2022-04-02 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2368478 | 2368478 | 2022-04-02 | Rio Grande | Puerto Rico | 72119 | 7301 | |
2363127 | 2363127 | 2022-04-01 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2365225 | 2365225 | 2022-04-01 | Rio Grande | Puerto Rico | 72119 | 7296 | |
2359873 | 2359873 | 2022-03-31 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2361972 | 2361972 | 2022-03-31 | Rio Grande | Puerto Rico | 72119 | 7287 | |
2356619 | 2356619 | 2022-03-30 | Rio Grande | Colorado | 8105 | 2783 | 46 |
2358718 | 2358718 | 2022-03-30 | Rio Grande | Puerto Rico | 72119 | 7274 | |
2353366 | 2353366 | 2022-03-29 | Rio Grande | Colorado | 8105 | 2782 | 46 |
2355464 | 2355464 | 2022-03-29 | Rio Grande | Puerto Rico | 72119 | 7272 | |
2350114 | 2350114 | 2022-03-28 | Rio Grande | Colorado | 8105 | 2777 | 46 |
2352211 | 2352211 | 2022-03-28 | Rio Grande | Puerto Rico | 72119 | 7272 | |
2346861 | 2346861 | 2022-03-27 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2348959 | 2348959 | 2022-03-27 | Rio Grande | Puerto Rico | 72119 | 7271 | |
2343608 | 2343608 | 2022-03-26 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2345706 | 2345706 | 2022-03-26 | Rio Grande | Puerto Rico | 72119 | 7268 | |
2340355 | 2340355 | 2022-03-25 | Rio Grande | Colorado | 8105 | 2778 | 46 |
2342453 | 2342453 | 2022-03-25 | Rio Grande | Puerto Rico | 72119 | 7264 |
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);