ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Orange" and fips = 51137 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502600 | 2502600 | 2022-05-13 | Orange | Virginia | 51137 | 6928 | 86 |
2499342 | 2499342 | 2022-05-12 | Orange | Virginia | 51137 | 6915 | 86 |
2496084 | 2496084 | 2022-05-11 | Orange | Virginia | 51137 | 6904 | 86 |
2492826 | 2492826 | 2022-05-10 | Orange | Virginia | 51137 | 6896 | 86 |
2489568 | 2489568 | 2022-05-09 | Orange | Virginia | 51137 | 6888 | 86 |
2486311 | 2486311 | 2022-05-08 | Orange | Virginia | 51137 | 6863 | 86 |
2483053 | 2483053 | 2022-05-07 | Orange | Virginia | 51137 | 6863 | 86 |
2479795 | 2479795 | 2022-05-06 | Orange | Virginia | 51137 | 6863 | 86 |
2476537 | 2476537 | 2022-05-05 | Orange | Virginia | 51137 | 6857 | 86 |
2473279 | 2473279 | 2022-05-04 | Orange | Virginia | 51137 | 6847 | 86 |
2470023 | 2470023 | 2022-05-03 | Orange | Virginia | 51137 | 6830 | 86 |
2466767 | 2466767 | 2022-05-02 | Orange | Virginia | 51137 | 6827 | 86 |
2463512 | 2463512 | 2022-05-01 | Orange | Virginia | 51137 | 6807 | 86 |
2460256 | 2460256 | 2022-04-30 | Orange | Virginia | 51137 | 6807 | 86 |
2457000 | 2457000 | 2022-04-29 | Orange | Virginia | 51137 | 6807 | 86 |
2453744 | 2453744 | 2022-04-28 | Orange | Virginia | 51137 | 6800 | 86 |
2450488 | 2450488 | 2022-04-27 | Orange | Virginia | 51137 | 6800 | 86 |
2447231 | 2447231 | 2022-04-26 | Orange | Virginia | 51137 | 6796 | 86 |
2443976 | 2443976 | 2022-04-25 | Orange | Virginia | 51137 | 6787 | 86 |
2440720 | 2440720 | 2022-04-24 | Orange | Virginia | 51137 | 6772 | 86 |
2437464 | 2437464 | 2022-04-23 | Orange | Virginia | 51137 | 6772 | 86 |
2434208 | 2434208 | 2022-04-22 | Orange | Virginia | 51137 | 6772 | 86 |
2430952 | 2430952 | 2022-04-21 | Orange | Virginia | 51137 | 6776 | 86 |
2427696 | 2427696 | 2022-04-20 | Orange | Virginia | 51137 | 6786 | 86 |
2424440 | 2424440 | 2022-04-19 | Orange | Virginia | 51137 | 6792 | 86 |
2421184 | 2421184 | 2022-04-18 | Orange | Virginia | 51137 | 6799 | 86 |
2417928 | 2417928 | 2022-04-17 | Orange | Virginia | 51137 | 6801 | 86 |
2414672 | 2414672 | 2022-04-16 | Orange | Virginia | 51137 | 6801 | 86 |
2411416 | 2411416 | 2022-04-15 | Orange | Virginia | 51137 | 6801 | 86 |
2408160 | 2408160 | 2022-04-14 | Orange | Virginia | 51137 | 6803 | 85 |
2404904 | 2404904 | 2022-04-13 | Orange | Virginia | 51137 | 6807 | 84 |
2401649 | 2401649 | 2022-04-12 | Orange | Virginia | 51137 | 6803 | 84 |
2398394 | 2398394 | 2022-04-11 | Orange | Virginia | 51137 | 6798 | 84 |
2395139 | 2395139 | 2022-04-10 | Orange | Virginia | 51137 | 6788 | 84 |
2391883 | 2391883 | 2022-04-09 | Orange | Virginia | 51137 | 6788 | 84 |
2388627 | 2388627 | 2022-04-08 | Orange | Virginia | 51137 | 6788 | 84 |
2385372 | 2385372 | 2022-04-07 | Orange | Virginia | 51137 | 6779 | 85 |
2382117 | 2382117 | 2022-04-06 | Orange | Virginia | 51137 | 6796 | 85 |
2378862 | 2378862 | 2022-04-05 | Orange | Virginia | 51137 | 6814 | 85 |
2375608 | 2375608 | 2022-04-04 | Orange | Virginia | 51137 | 6821 | 85 |
2372356 | 2372356 | 2022-04-03 | Orange | Virginia | 51137 | 6815 | 85 |
2369103 | 2369103 | 2022-04-02 | Orange | Virginia | 51137 | 6815 | 85 |
2365850 | 2365850 | 2022-04-01 | Orange | Virginia | 51137 | 6815 | 85 |
2362597 | 2362597 | 2022-03-31 | Orange | Virginia | 51137 | 6813 | 85 |
2359343 | 2359343 | 2022-03-30 | Orange | Virginia | 51137 | 6840 | 85 |
2356089 | 2356089 | 2022-03-29 | Orange | Virginia | 51137 | 6834 | 85 |
2352836 | 2352836 | 2022-03-28 | Orange | Virginia | 51137 | 6831 | 85 |
2349584 | 2349584 | 2022-03-27 | Orange | Virginia | 51137 | 6831 | 85 |
2346331 | 2346331 | 2022-03-26 | Orange | Virginia | 51137 | 6831 | 85 |
2343078 | 2343078 | 2022-03-25 | Orange | Virginia | 51137 | 6831 | 85 |
2339825 | 2339825 | 2022-03-24 | Orange | Virginia | 51137 | 6842 | 85 |
2336571 | 2336571 | 2022-03-23 | Orange | Virginia | 51137 | 6840 | 85 |
2333317 | 2333317 | 2022-03-22 | Orange | Virginia | 51137 | 6852 | 85 |
2330064 | 2330064 | 2022-03-21 | Orange | Virginia | 51137 | 6852 | 85 |
2326812 | 2326812 | 2022-03-20 | Orange | Virginia | 51137 | 6853 | 85 |
2323559 | 2323559 | 2022-03-19 | Orange | Virginia | 51137 | 6853 | 85 |
2320305 | 2320305 | 2022-03-18 | Orange | Virginia | 51137 | 6853 | 85 |
2317051 | 2317051 | 2022-03-17 | Orange | Virginia | 51137 | 6862 | 85 |
2313798 | 2313798 | 2022-03-16 | Orange | Virginia | 51137 | 6859 | 85 |
2310545 | 2310545 | 2022-03-15 | Orange | Virginia | 51137 | 6852 | 84 |
2307292 | 2307292 | 2022-03-14 | Orange | Virginia | 51137 | 6840 | 84 |
2304041 | 2304041 | 2022-03-13 | Orange | Virginia | 51137 | 6847 | 84 |
2300789 | 2300789 | 2022-03-12 | Orange | Virginia | 51137 | 6847 | 84 |
2297537 | 2297537 | 2022-03-11 | Orange | Virginia | 51137 | 6847 | 84 |
2294285 | 2294285 | 2022-03-10 | Orange | Virginia | 51137 | 6858 | 85 |
2291033 | 2291033 | 2022-03-09 | Orange | Virginia | 51137 | 6866 | 85 |
2287781 | 2287781 | 2022-03-08 | Orange | Virginia | 51137 | 6864 | 85 |
2284529 | 2284529 | 2022-03-07 | Orange | Virginia | 51137 | 6863 | 85 |
2281277 | 2281277 | 2022-03-06 | Orange | Virginia | 51137 | 6865 | 85 |
2278024 | 2278024 | 2022-03-05 | Orange | Virginia | 51137 | 6865 | 85 |
2274771 | 2274771 | 2022-03-04 | Orange | Virginia | 51137 | 6865 | 85 |
2271518 | 2271518 | 2022-03-03 | Orange | Virginia | 51137 | 6861 | 85 |
2268266 | 2268266 | 2022-03-02 | Orange | Virginia | 51137 | 6852 | 85 |
2265013 | 2265013 | 2022-03-01 | Orange | Virginia | 51137 | 6845 | 85 |
2261763 | 2261763 | 2022-02-28 | Orange | Virginia | 51137 | 6840 | 85 |
2258512 | 2258512 | 2022-02-27 | Orange | Virginia | 51137 | 6831 | 85 |
2255261 | 2255261 | 2022-02-26 | Orange | Virginia | 51137 | 6831 | 85 |
2252010 | 2252010 | 2022-02-25 | Orange | Virginia | 51137 | 6831 | 85 |
2248759 | 2248759 | 2022-02-24 | Orange | Virginia | 51137 | 6841 | 85 |
2245508 | 2245508 | 2022-02-23 | Orange | Virginia | 51137 | 6843 | 84 |
2242257 | 2242257 | 2022-02-22 | Orange | Virginia | 51137 | 6846 | 84 |
2239006 | 2239006 | 2022-02-21 | Orange | Virginia | 51137 | 6839 | 84 |
2235755 | 2235755 | 2022-02-20 | Orange | Virginia | 51137 | 6814 | 84 |
2232504 | 2232504 | 2022-02-19 | Orange | Virginia | 51137 | 6814 | 84 |
2229253 | 2229253 | 2022-02-18 | Orange | Virginia | 51137 | 6814 | 84 |
2226002 | 2226002 | 2022-02-17 | Orange | Virginia | 51137 | 6800 | 84 |
2222751 | 2222751 | 2022-02-16 | Orange | Virginia | 51137 | 6778 | 84 |
2219500 | 2219500 | 2022-02-15 | Orange | Virginia | 51137 | 6774 | 84 |
2216250 | 2216250 | 2022-02-14 | Orange | Virginia | 51137 | 6761 | 84 |
2212999 | 2212999 | 2022-02-13 | Orange | Virginia | 51137 | 6711 | 83 |
2209746 | 2209746 | 2022-02-12 | Orange | Virginia | 51137 | 6711 | 83 |
2206493 | 2206493 | 2022-02-11 | Orange | Virginia | 51137 | 6711 | 83 |
2203240 | 2203240 | 2022-02-10 | Orange | Virginia | 51137 | 6692 | 83 |
2199986 | 2199986 | 2022-02-09 | Orange | Virginia | 51137 | 6671 | 83 |
2196732 | 2196732 | 2022-02-08 | Orange | Virginia | 51137 | 6667 | 83 |
2193477 | 2193477 | 2022-02-07 | Orange | Virginia | 51137 | 6646 | 82 |
2190224 | 2190224 | 2022-02-06 | Orange | Virginia | 51137 | 6573 | 79 |
2186971 | 2186971 | 2022-02-05 | Orange | Virginia | 51137 | 6573 | 79 |
2183718 | 2183718 | 2022-02-04 | Orange | Virginia | 51137 | 6573 | 79 |
2180466 | 2180466 | 2022-02-03 | Orange | Virginia | 51137 | 6535 | 75 |
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);