ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,557 rows where county = "Halifax" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338753 | 2338753 | 2022-03-24 | Halifax | North Carolina | 37083 | 13905 | 181 |
2339789 | 2339789 | 2022-03-24 | Halifax | Virginia | 51083 | 7006 | 151 |
2335499 | 2335499 | 2022-03-23 | Halifax | North Carolina | 37083 | 13903 | 181 |
2336535 | 2336535 | 2022-03-23 | Halifax | Virginia | 51083 | 7004 | 151 |
2332245 | 2332245 | 2022-03-22 | Halifax | North Carolina | 37083 | 13902 | 181 |
2333281 | 2333281 | 2022-03-22 | Halifax | Virginia | 51083 | 7003 | 151 |
2328992 | 2328992 | 2022-03-21 | Halifax | North Carolina | 37083 | 13903 | 181 |
2330028 | 2330028 | 2022-03-21 | Halifax | Virginia | 51083 | 7003 | 151 |
2325740 | 2325740 | 2022-03-20 | Halifax | North Carolina | 37083 | 13899 | 181 |
2326776 | 2326776 | 2022-03-20 | Halifax | Virginia | 51083 | 6998 | 151 |
2322487 | 2322487 | 2022-03-19 | Halifax | North Carolina | 37083 | 13899 | 181 |
2323523 | 2323523 | 2022-03-19 | Halifax | Virginia | 51083 | 6998 | 151 |
2319233 | 2319233 | 2022-03-18 | Halifax | North Carolina | 37083 | 13899 | 181 |
2320269 | 2320269 | 2022-03-18 | Halifax | Virginia | 51083 | 6998 | 151 |
2315979 | 2315979 | 2022-03-17 | Halifax | North Carolina | 37083 | 13896 | 181 |
2317015 | 2317015 | 2022-03-17 | Halifax | Virginia | 51083 | 6994 | 151 |
2312726 | 2312726 | 2022-03-16 | Halifax | North Carolina | 37083 | 13891 | 177 |
2313762 | 2313762 | 2022-03-16 | Halifax | Virginia | 51083 | 6989 | 150 |
2309473 | 2309473 | 2022-03-15 | Halifax | North Carolina | 37083 | 13889 | 177 |
2310509 | 2310509 | 2022-03-15 | Halifax | Virginia | 51083 | 6989 | 150 |
2306220 | 2306220 | 2022-03-14 | Halifax | North Carolina | 37083 | 13885 | 177 |
2307256 | 2307256 | 2022-03-14 | Halifax | Virginia | 51083 | 6983 | 150 |
2302969 | 2302969 | 2022-03-13 | Halifax | North Carolina | 37083 | 13883 | 177 |
2304005 | 2304005 | 2022-03-13 | Halifax | Virginia | 51083 | 6975 | 149 |
2299717 | 2299717 | 2022-03-12 | Halifax | North Carolina | 37083 | 13883 | 177 |
2300753 | 2300753 | 2022-03-12 | Halifax | Virginia | 51083 | 6975 | 149 |
2296465 | 2296465 | 2022-03-11 | Halifax | North Carolina | 37083 | 13883 | 177 |
2297501 | 2297501 | 2022-03-11 | Halifax | Virginia | 51083 | 6975 | 149 |
2293213 | 2293213 | 2022-03-10 | Halifax | North Carolina | 37083 | 13881 | 177 |
2294249 | 2294249 | 2022-03-10 | Halifax | Virginia | 51083 | 6966 | 149 |
2289961 | 2289961 | 2022-03-09 | Halifax | North Carolina | 37083 | 13879 | 177 |
2290997 | 2290997 | 2022-03-09 | Halifax | Virginia | 51083 | 6961 | 148 |
2286709 | 2286709 | 2022-03-08 | Halifax | North Carolina | 37083 | 13875 | 177 |
2287745 | 2287745 | 2022-03-08 | Halifax | Virginia | 51083 | 6961 | 148 |
2283457 | 2283457 | 2022-03-07 | Halifax | North Carolina | 37083 | 13870 | 177 |
2284493 | 2284493 | 2022-03-07 | Halifax | Virginia | 51083 | 6938 | 148 |
2280205 | 2280205 | 2022-03-06 | Halifax | North Carolina | 37083 | 13852 | 176 |
2281241 | 2281241 | 2022-03-06 | Halifax | Virginia | 51083 | 6923 | 148 |
2276952 | 2276952 | 2022-03-05 | Halifax | North Carolina | 37083 | 13852 | 176 |
2277988 | 2277988 | 2022-03-05 | Halifax | Virginia | 51083 | 6923 | 148 |
2273699 | 2273699 | 2022-03-04 | Halifax | North Carolina | 37083 | 13852 | 176 |
2274735 | 2274735 | 2022-03-04 | Halifax | Virginia | 51083 | 6923 | 148 |
2270446 | 2270446 | 2022-03-03 | Halifax | North Carolina | 37083 | 13849 | 176 |
2271482 | 2271482 | 2022-03-03 | Halifax | Virginia | 51083 | 6911 | 148 |
2267194 | 2267194 | 2022-03-02 | Halifax | North Carolina | 37083 | 13838 | 176 |
2268230 | 2268230 | 2022-03-02 | Halifax | Virginia | 51083 | 6901 | 148 |
2263942 | 2263942 | 2022-03-01 | Halifax | North Carolina | 37083 | 13828 | 176 |
2264977 | 2264977 | 2022-03-01 | Halifax | Virginia | 51083 | 6894 | 147 |
2260691 | 2260691 | 2022-02-28 | Halifax | North Carolina | 37083 | 13822 | 176 |
2261727 | 2261727 | 2022-02-28 | Halifax | Virginia | 51083 | 6888 | 147 |
2257440 | 2257440 | 2022-02-27 | Halifax | North Carolina | 37083 | 13808 | 175 |
2258476 | 2258476 | 2022-02-27 | Halifax | Virginia | 51083 | 6875 | 143 |
2254189 | 2254189 | 2022-02-26 | Halifax | North Carolina | 37083 | 13808 | 175 |
2255225 | 2255225 | 2022-02-26 | Halifax | Virginia | 51083 | 6875 | 143 |
2250938 | 2250938 | 2022-02-25 | Halifax | North Carolina | 37083 | 13808 | 175 |
2251974 | 2251974 | 2022-02-25 | Halifax | Virginia | 51083 | 6875 | 143 |
2247687 | 2247687 | 2022-02-24 | Halifax | North Carolina | 37083 | 13796 | 175 |
2248723 | 2248723 | 2022-02-24 | Halifax | Virginia | 51083 | 6866 | 143 |
2244436 | 2244436 | 2022-02-23 | Halifax | North Carolina | 37083 | 13781 | 174 |
2245472 | 2245472 | 2022-02-23 | Halifax | Virginia | 51083 | 6851 | 141 |
2241185 | 2241185 | 2022-02-22 | Halifax | North Carolina | 37083 | 13763 | 174 |
2242221 | 2242221 | 2022-02-22 | Halifax | Virginia | 51083 | 6838 | 141 |
2237934 | 2237934 | 2022-02-21 | Halifax | North Carolina | 37083 | 13761 | 173 |
2238970 | 2238970 | 2022-02-21 | Halifax | Virginia | 51083 | 6831 | 141 |
2234683 | 2234683 | 2022-02-20 | Halifax | North Carolina | 37083 | 13719 | 173 |
2235719 | 2235719 | 2022-02-20 | Halifax | Virginia | 51083 | 6804 | 140 |
2231432 | 2231432 | 2022-02-19 | Halifax | North Carolina | 37083 | 13719 | 173 |
2232468 | 2232468 | 2022-02-19 | Halifax | Virginia | 51083 | 6804 | 140 |
2228181 | 2228181 | 2022-02-18 | Halifax | North Carolina | 37083 | 13719 | 173 |
2229217 | 2229217 | 2022-02-18 | Halifax | Virginia | 51083 | 6804 | 140 |
2224930 | 2224930 | 2022-02-17 | Halifax | North Carolina | 37083 | 13698 | 173 |
2225966 | 2225966 | 2022-02-17 | Halifax | Virginia | 51083 | 6790 | 139 |
2221679 | 2221679 | 2022-02-16 | Halifax | North Carolina | 37083 | 13680 | 173 |
2222715 | 2222715 | 2022-02-16 | Halifax | Virginia | 51083 | 6773 | 139 |
2218428 | 2218428 | 2022-02-15 | Halifax | North Carolina | 37083 | 13665 | 173 |
2219464 | 2219464 | 2022-02-15 | Halifax | Virginia | 51083 | 6761 | 139 |
2215177 | 2215177 | 2022-02-14 | Halifax | North Carolina | 37083 | 13656 | 172 |
2216214 | 2216214 | 2022-02-14 | Halifax | Virginia | 51083 | 6741 | 138 |
2211926 | 2211926 | 2022-02-13 | Halifax | North Carolina | 37083 | 13612 | 171 |
2212963 | 2212963 | 2022-02-13 | Halifax | Virginia | 51083 | 6693 | 138 |
2208673 | 2208673 | 2022-02-12 | Halifax | North Carolina | 37083 | 13612 | 171 |
2209710 | 2209710 | 2022-02-12 | Halifax | Virginia | 51083 | 6693 | 138 |
2205420 | 2205420 | 2022-02-11 | Halifax | North Carolina | 37083 | 13612 | 171 |
2206457 | 2206457 | 2022-02-11 | Halifax | Virginia | 51083 | 6693 | 138 |
2202167 | 2202167 | 2022-02-10 | Halifax | North Carolina | 37083 | 13578 | 170 |
2203204 | 2203204 | 2022-02-10 | Halifax | Virginia | 51083 | 6669 | 138 |
2198913 | 2198913 | 2022-02-09 | Halifax | North Carolina | 37083 | 13548 | 169 |
2199950 | 2199950 | 2022-02-09 | Halifax | Virginia | 51083 | 6634 | 138 |
2195659 | 2195659 | 2022-02-08 | Halifax | North Carolina | 37083 | 13488 | 168 |
2196696 | 2196696 | 2022-02-08 | Halifax | Virginia | 51083 | 6614 | 138 |
2192405 | 2192405 | 2022-02-07 | Halifax | North Carolina | 37083 | 13480 | 166 |
2193441 | 2193441 | 2022-02-07 | Halifax | Virginia | 51083 | 6575 | 137 |
2189151 | 2189151 | 2022-02-06 | Halifax | North Carolina | 37083 | 13392 | 163 |
2190188 | 2190188 | 2022-02-06 | Halifax | Virginia | 51083 | 6500 | 130 |
2185898 | 2185898 | 2022-02-05 | Halifax | North Carolina | 37083 | 13392 | 163 |
2186935 | 2186935 | 2022-02-05 | Halifax | Virginia | 51083 | 6500 | 130 |
2182646 | 2182646 | 2022-02-04 | Halifax | North Carolina | 37083 | 13392 | 163 |
2183682 | 2183682 | 2022-02-04 | Halifax | Virginia | 51083 | 6500 | 130 |
2179394 | 2179394 | 2022-02-03 | Halifax | North Carolina | 37083 | 13352 | 162 |
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);