ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Halifax" and state = "Virginia" 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 |
---|---|---|---|---|---|---|---|
2502564 | 2502564 | 2022-05-13 | Halifax | Virginia | 51083 | 7217 | 159 |
2499306 | 2499306 | 2022-05-12 | Halifax | Virginia | 51083 | 7193 | 159 |
2496048 | 2496048 | 2022-05-11 | Halifax | Virginia | 51083 | 7181 | 159 |
2492790 | 2492790 | 2022-05-10 | Halifax | Virginia | 51083 | 7168 | 159 |
2489532 | 2489532 | 2022-05-09 | Halifax | Virginia | 51083 | 7162 | 159 |
2486275 | 2486275 | 2022-05-08 | Halifax | Virginia | 51083 | 7140 | 159 |
2483017 | 2483017 | 2022-05-07 | Halifax | Virginia | 51083 | 7140 | 159 |
2479759 | 2479759 | 2022-05-06 | Halifax | Virginia | 51083 | 7140 | 159 |
2476501 | 2476501 | 2022-05-05 | Halifax | Virginia | 51083 | 7128 | 159 |
2473243 | 2473243 | 2022-05-04 | Halifax | Virginia | 51083 | 7113 | 159 |
2469987 | 2469987 | 2022-05-03 | Halifax | Virginia | 51083 | 7105 | 159 |
2466731 | 2466731 | 2022-05-02 | Halifax | Virginia | 51083 | 7102 | 159 |
2463476 | 2463476 | 2022-05-01 | Halifax | Virginia | 51083 | 7092 | 159 |
2460220 | 2460220 | 2022-04-30 | Halifax | Virginia | 51083 | 7092 | 159 |
2456964 | 2456964 | 2022-04-29 | Halifax | Virginia | 51083 | 7092 | 159 |
2453708 | 2453708 | 2022-04-28 | Halifax | Virginia | 51083 | 7088 | 159 |
2450452 | 2450452 | 2022-04-27 | Halifax | Virginia | 51083 | 7083 | 159 |
2447195 | 2447195 | 2022-04-26 | Halifax | Virginia | 51083 | 7077 | 159 |
2443940 | 2443940 | 2022-04-25 | Halifax | Virginia | 51083 | 7075 | 159 |
2440684 | 2440684 | 2022-04-24 | Halifax | Virginia | 51083 | 7067 | 159 |
2437428 | 2437428 | 2022-04-23 | Halifax | Virginia | 51083 | 7067 | 159 |
2434172 | 2434172 | 2022-04-22 | Halifax | Virginia | 51083 | 7067 | 159 |
2430916 | 2430916 | 2022-04-21 | Halifax | Virginia | 51083 | 7060 | 159 |
2427660 | 2427660 | 2022-04-20 | Halifax | Virginia | 51083 | 7054 | 156 |
2424404 | 2424404 | 2022-04-19 | Halifax | Virginia | 51083 | 7052 | 156 |
2421148 | 2421148 | 2022-04-18 | Halifax | Virginia | 51083 | 7050 | 156 |
2417892 | 2417892 | 2022-04-17 | Halifax | Virginia | 51083 | 7043 | 156 |
2414636 | 2414636 | 2022-04-16 | Halifax | Virginia | 51083 | 7043 | 156 |
2411380 | 2411380 | 2022-04-15 | Halifax | Virginia | 51083 | 7043 | 156 |
2408124 | 2408124 | 2022-04-14 | Halifax | Virginia | 51083 | 7044 | 156 |
2404868 | 2404868 | 2022-04-13 | Halifax | Virginia | 51083 | 7045 | 156 |
2401613 | 2401613 | 2022-04-12 | Halifax | Virginia | 51083 | 7041 | 155 |
2398358 | 2398358 | 2022-04-11 | Halifax | Virginia | 51083 | 7033 | 155 |
2395103 | 2395103 | 2022-04-10 | Halifax | Virginia | 51083 | 7027 | 155 |
2391847 | 2391847 | 2022-04-09 | Halifax | Virginia | 51083 | 7027 | 155 |
2388591 | 2388591 | 2022-04-08 | Halifax | Virginia | 51083 | 7027 | 155 |
2385336 | 2385336 | 2022-04-07 | Halifax | Virginia | 51083 | 7027 | 155 |
2382081 | 2382081 | 2022-04-06 | Halifax | Virginia | 51083 | 7026 | 154 |
2378826 | 2378826 | 2022-04-05 | Halifax | Virginia | 51083 | 7023 | 154 |
2375572 | 2375572 | 2022-04-04 | Halifax | Virginia | 51083 | 7023 | 154 |
2372320 | 2372320 | 2022-04-03 | Halifax | Virginia | 51083 | 7015 | 154 |
2369067 | 2369067 | 2022-04-02 | Halifax | Virginia | 51083 | 7015 | 154 |
2365814 | 2365814 | 2022-04-01 | Halifax | Virginia | 51083 | 7015 | 154 |
2362561 | 2362561 | 2022-03-31 | Halifax | Virginia | 51083 | 7010 | 153 |
2359307 | 2359307 | 2022-03-30 | Halifax | Virginia | 51083 | 7009 | 153 |
2356053 | 2356053 | 2022-03-29 | Halifax | Virginia | 51083 | 7007 | 152 |
2352800 | 2352800 | 2022-03-28 | Halifax | Virginia | 51083 | 7007 | 152 |
2349548 | 2349548 | 2022-03-27 | Halifax | Virginia | 51083 | 7007 | 152 |
2346295 | 2346295 | 2022-03-26 | Halifax | Virginia | 51083 | 7007 | 152 |
2343042 | 2343042 | 2022-03-25 | Halifax | Virginia | 51083 | 7007 | 152 |
2339789 | 2339789 | 2022-03-24 | Halifax | Virginia | 51083 | 7006 | 151 |
2336535 | 2336535 | 2022-03-23 | Halifax | Virginia | 51083 | 7004 | 151 |
2333281 | 2333281 | 2022-03-22 | Halifax | Virginia | 51083 | 7003 | 151 |
2330028 | 2330028 | 2022-03-21 | Halifax | Virginia | 51083 | 7003 | 151 |
2326776 | 2326776 | 2022-03-20 | Halifax | Virginia | 51083 | 6998 | 151 |
2323523 | 2323523 | 2022-03-19 | Halifax | Virginia | 51083 | 6998 | 151 |
2320269 | 2320269 | 2022-03-18 | Halifax | Virginia | 51083 | 6998 | 151 |
2317015 | 2317015 | 2022-03-17 | Halifax | Virginia | 51083 | 6994 | 151 |
2313762 | 2313762 | 2022-03-16 | Halifax | Virginia | 51083 | 6989 | 150 |
2310509 | 2310509 | 2022-03-15 | Halifax | Virginia | 51083 | 6989 | 150 |
2307256 | 2307256 | 2022-03-14 | Halifax | Virginia | 51083 | 6983 | 150 |
2304005 | 2304005 | 2022-03-13 | Halifax | Virginia | 51083 | 6975 | 149 |
2300753 | 2300753 | 2022-03-12 | Halifax | Virginia | 51083 | 6975 | 149 |
2297501 | 2297501 | 2022-03-11 | Halifax | Virginia | 51083 | 6975 | 149 |
2294249 | 2294249 | 2022-03-10 | Halifax | Virginia | 51083 | 6966 | 149 |
2290997 | 2290997 | 2022-03-09 | Halifax | Virginia | 51083 | 6961 | 148 |
2287745 | 2287745 | 2022-03-08 | Halifax | Virginia | 51083 | 6961 | 148 |
2284493 | 2284493 | 2022-03-07 | Halifax | Virginia | 51083 | 6938 | 148 |
2281241 | 2281241 | 2022-03-06 | Halifax | Virginia | 51083 | 6923 | 148 |
2277988 | 2277988 | 2022-03-05 | Halifax | Virginia | 51083 | 6923 | 148 |
2274735 | 2274735 | 2022-03-04 | Halifax | Virginia | 51083 | 6923 | 148 |
2271482 | 2271482 | 2022-03-03 | Halifax | Virginia | 51083 | 6911 | 148 |
2268230 | 2268230 | 2022-03-02 | Halifax | Virginia | 51083 | 6901 | 148 |
2264977 | 2264977 | 2022-03-01 | Halifax | Virginia | 51083 | 6894 | 147 |
2261727 | 2261727 | 2022-02-28 | Halifax | Virginia | 51083 | 6888 | 147 |
2258476 | 2258476 | 2022-02-27 | Halifax | Virginia | 51083 | 6875 | 143 |
2255225 | 2255225 | 2022-02-26 | Halifax | Virginia | 51083 | 6875 | 143 |
2251974 | 2251974 | 2022-02-25 | Halifax | Virginia | 51083 | 6875 | 143 |
2248723 | 2248723 | 2022-02-24 | Halifax | Virginia | 51083 | 6866 | 143 |
2245472 | 2245472 | 2022-02-23 | Halifax | Virginia | 51083 | 6851 | 141 |
2242221 | 2242221 | 2022-02-22 | Halifax | Virginia | 51083 | 6838 | 141 |
2238970 | 2238970 | 2022-02-21 | Halifax | Virginia | 51083 | 6831 | 141 |
2235719 | 2235719 | 2022-02-20 | Halifax | Virginia | 51083 | 6804 | 140 |
2232468 | 2232468 | 2022-02-19 | Halifax | Virginia | 51083 | 6804 | 140 |
2229217 | 2229217 | 2022-02-18 | Halifax | Virginia | 51083 | 6804 | 140 |
2225966 | 2225966 | 2022-02-17 | Halifax | Virginia | 51083 | 6790 | 139 |
2222715 | 2222715 | 2022-02-16 | Halifax | Virginia | 51083 | 6773 | 139 |
2219464 | 2219464 | 2022-02-15 | Halifax | Virginia | 51083 | 6761 | 139 |
2216214 | 2216214 | 2022-02-14 | Halifax | Virginia | 51083 | 6741 | 138 |
2212963 | 2212963 | 2022-02-13 | Halifax | Virginia | 51083 | 6693 | 138 |
2209710 | 2209710 | 2022-02-12 | Halifax | Virginia | 51083 | 6693 | 138 |
2206457 | 2206457 | 2022-02-11 | Halifax | Virginia | 51083 | 6693 | 138 |
2203204 | 2203204 | 2022-02-10 | Halifax | Virginia | 51083 | 6669 | 138 |
2199950 | 2199950 | 2022-02-09 | Halifax | Virginia | 51083 | 6634 | 138 |
2196696 | 2196696 | 2022-02-08 | Halifax | Virginia | 51083 | 6614 | 138 |
2193441 | 2193441 | 2022-02-07 | Halifax | Virginia | 51083 | 6575 | 137 |
2190188 | 2190188 | 2022-02-06 | Halifax | Virginia | 51083 | 6500 | 130 |
2186935 | 2186935 | 2022-02-05 | Halifax | Virginia | 51083 | 6500 | 130 |
2183682 | 2183682 | 2022-02-04 | Halifax | Virginia | 51083 | 6500 | 130 |
2180430 | 2180430 | 2022-02-03 | Halifax | Virginia | 51083 | 6461 | 130 |
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);