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)
Suggested facets: date, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501527 | 2501527 | 2022-05-13 | Halifax | North Carolina | 37083 | 14035 | 187 |
2502564 | 2502564 | 2022-05-13 | Halifax | Virginia | 51083 | 7217 | 159 |
2498269 | 2498269 | 2022-05-12 | Halifax | North Carolina | 37083 | 14035 | 187 |
2499306 | 2499306 | 2022-05-12 | Halifax | Virginia | 51083 | 7193 | 159 |
2495011 | 2495011 | 2022-05-11 | Halifax | North Carolina | 37083 | 14035 | 187 |
2496048 | 2496048 | 2022-05-11 | Halifax | Virginia | 51083 | 7181 | 159 |
2491753 | 2491753 | 2022-05-10 | Halifax | North Carolina | 37083 | 13981 | 187 |
2492790 | 2492790 | 2022-05-10 | Halifax | Virginia | 51083 | 7168 | 159 |
2488495 | 2488495 | 2022-05-09 | Halifax | North Carolina | 37083 | 13981 | 187 |
2489532 | 2489532 | 2022-05-09 | Halifax | Virginia | 51083 | 7162 | 159 |
2485238 | 2485238 | 2022-05-08 | Halifax | North Carolina | 37083 | 13981 | 187 |
2486275 | 2486275 | 2022-05-08 | Halifax | Virginia | 51083 | 7140 | 159 |
2481980 | 2481980 | 2022-05-07 | Halifax | North Carolina | 37083 | 13981 | 187 |
2483017 | 2483017 | 2022-05-07 | Halifax | Virginia | 51083 | 7140 | 159 |
2478722 | 2478722 | 2022-05-06 | Halifax | North Carolina | 37083 | 13981 | 187 |
2479759 | 2479759 | 2022-05-06 | Halifax | Virginia | 51083 | 7140 | 159 |
2475464 | 2475464 | 2022-05-05 | Halifax | North Carolina | 37083 | 13981 | 187 |
2476501 | 2476501 | 2022-05-05 | Halifax | Virginia | 51083 | 7128 | 159 |
2472207 | 2472207 | 2022-05-04 | Halifax | North Carolina | 37083 | 13981 | 187 |
2473243 | 2473243 | 2022-05-04 | Halifax | Virginia | 51083 | 7113 | 159 |
2468951 | 2468951 | 2022-05-03 | Halifax | North Carolina | 37083 | 13946 | 184 |
2469987 | 2469987 | 2022-05-03 | Halifax | Virginia | 51083 | 7105 | 159 |
2465695 | 2465695 | 2022-05-02 | Halifax | North Carolina | 37083 | 13946 | 184 |
2466731 | 2466731 | 2022-05-02 | Halifax | Virginia | 51083 | 7102 | 159 |
2462440 | 2462440 | 2022-05-01 | Halifax | North Carolina | 37083 | 13946 | 184 |
2463476 | 2463476 | 2022-05-01 | Halifax | Virginia | 51083 | 7092 | 159 |
2459184 | 2459184 | 2022-04-30 | Halifax | North Carolina | 37083 | 13946 | 184 |
2460220 | 2460220 | 2022-04-30 | Halifax | Virginia | 51083 | 7092 | 159 |
2455928 | 2455928 | 2022-04-29 | Halifax | North Carolina | 37083 | 13946 | 184 |
2456964 | 2456964 | 2022-04-29 | Halifax | Virginia | 51083 | 7092 | 159 |
2452672 | 2452672 | 2022-04-28 | Halifax | North Carolina | 37083 | 13946 | 184 |
2453708 | 2453708 | 2022-04-28 | Halifax | Virginia | 51083 | 7088 | 159 |
2449416 | 2449416 | 2022-04-27 | Halifax | North Carolina | 37083 | 13946 | 184 |
2450452 | 2450452 | 2022-04-27 | Halifax | Virginia | 51083 | 7083 | 159 |
2446159 | 2446159 | 2022-04-26 | Halifax | North Carolina | 37083 | 13928 | 184 |
2447195 | 2447195 | 2022-04-26 | Halifax | Virginia | 51083 | 7077 | 159 |
2442904 | 2442904 | 2022-04-25 | Halifax | North Carolina | 37083 | 13928 | 184 |
2443940 | 2443940 | 2022-04-25 | Halifax | Virginia | 51083 | 7075 | 159 |
2439648 | 2439648 | 2022-04-24 | Halifax | North Carolina | 37083 | 13928 | 184 |
2440684 | 2440684 | 2022-04-24 | Halifax | Virginia | 51083 | 7067 | 159 |
2436392 | 2436392 | 2022-04-23 | Halifax | North Carolina | 37083 | 13928 | 184 |
2437428 | 2437428 | 2022-04-23 | Halifax | Virginia | 51083 | 7067 | 159 |
2433136 | 2433136 | 2022-04-22 | Halifax | North Carolina | 37083 | 13928 | 184 |
2434172 | 2434172 | 2022-04-22 | Halifax | Virginia | 51083 | 7067 | 159 |
2429880 | 2429880 | 2022-04-21 | Halifax | North Carolina | 37083 | 13928 | 184 |
2430916 | 2430916 | 2022-04-21 | Halifax | Virginia | 51083 | 7060 | 159 |
2426624 | 2426624 | 2022-04-20 | Halifax | North Carolina | 37083 | 13928 | 184 |
2427660 | 2427660 | 2022-04-20 | Halifax | Virginia | 51083 | 7054 | 156 |
2423368 | 2423368 | 2022-04-19 | Halifax | North Carolina | 37083 | 13918 | 183 |
2424404 | 2424404 | 2022-04-19 | Halifax | Virginia | 51083 | 7052 | 156 |
2420111 | 2420111 | 2022-04-18 | Halifax | North Carolina | 37083 | 13918 | 183 |
2421148 | 2421148 | 2022-04-18 | Halifax | Virginia | 51083 | 7050 | 156 |
2416856 | 2416856 | 2022-04-17 | Halifax | North Carolina | 37083 | 13918 | 183 |
2417892 | 2417892 | 2022-04-17 | Halifax | Virginia | 51083 | 7043 | 156 |
2413600 | 2413600 | 2022-04-16 | Halifax | North Carolina | 37083 | 13918 | 183 |
2414636 | 2414636 | 2022-04-16 | Halifax | Virginia | 51083 | 7043 | 156 |
2410344 | 2410344 | 2022-04-15 | Halifax | North Carolina | 37083 | 13918 | 183 |
2411380 | 2411380 | 2022-04-15 | Halifax | Virginia | 51083 | 7043 | 156 |
2407088 | 2407088 | 2022-04-14 | Halifax | North Carolina | 37083 | 13918 | 183 |
2408124 | 2408124 | 2022-04-14 | Halifax | Virginia | 51083 | 7044 | 156 |
2403832 | 2403832 | 2022-04-13 | Halifax | North Carolina | 37083 | 13918 | 183 |
2404868 | 2404868 | 2022-04-13 | Halifax | Virginia | 51083 | 7045 | 156 |
2400577 | 2400577 | 2022-04-12 | Halifax | North Carolina | 37083 | 13912 | 182 |
2401613 | 2401613 | 2022-04-12 | Halifax | Virginia | 51083 | 7041 | 155 |
2397322 | 2397322 | 2022-04-11 | Halifax | North Carolina | 37083 | 13912 | 182 |
2398358 | 2398358 | 2022-04-11 | Halifax | Virginia | 51083 | 7033 | 155 |
2394067 | 2394067 | 2022-04-10 | Halifax | North Carolina | 37083 | 13912 | 182 |
2395103 | 2395103 | 2022-04-10 | Halifax | Virginia | 51083 | 7027 | 155 |
2390811 | 2390811 | 2022-04-09 | Halifax | North Carolina | 37083 | 13912 | 182 |
2391847 | 2391847 | 2022-04-09 | Halifax | Virginia | 51083 | 7027 | 155 |
2387555 | 2387555 | 2022-04-08 | Halifax | North Carolina | 37083 | 13912 | 182 |
2388591 | 2388591 | 2022-04-08 | Halifax | Virginia | 51083 | 7027 | 155 |
2384300 | 2384300 | 2022-04-07 | Halifax | North Carolina | 37083 | 13912 | 182 |
2385336 | 2385336 | 2022-04-07 | Halifax | Virginia | 51083 | 7027 | 155 |
2381045 | 2381045 | 2022-04-06 | Halifax | North Carolina | 37083 | 13912 | 182 |
2382081 | 2382081 | 2022-04-06 | Halifax | Virginia | 51083 | 7026 | 154 |
2377790 | 2377790 | 2022-04-05 | Halifax | North Carolina | 37083 | 13909 | 182 |
2378826 | 2378826 | 2022-04-05 | Halifax | Virginia | 51083 | 7023 | 154 |
2374537 | 2374537 | 2022-04-04 | Halifax | North Carolina | 37083 | 13906 | 182 |
2375572 | 2375572 | 2022-04-04 | Halifax | Virginia | 51083 | 7023 | 154 |
2371285 | 2371285 | 2022-04-03 | Halifax | North Carolina | 37083 | 13909 | 182 |
2372320 | 2372320 | 2022-04-03 | Halifax | Virginia | 51083 | 7015 | 154 |
2368032 | 2368032 | 2022-04-02 | Halifax | North Carolina | 37083 | 13909 | 182 |
2369067 | 2369067 | 2022-04-02 | Halifax | Virginia | 51083 | 7015 | 154 |
2364779 | 2364779 | 2022-04-01 | Halifax | North Carolina | 37083 | 13909 | 182 |
2365814 | 2365814 | 2022-04-01 | Halifax | Virginia | 51083 | 7015 | 154 |
2361525 | 2361525 | 2022-03-31 | Halifax | North Carolina | 37083 | 13907 | 182 |
2362561 | 2362561 | 2022-03-31 | Halifax | Virginia | 51083 | 7010 | 153 |
2358271 | 2358271 | 2022-03-30 | Halifax | North Carolina | 37083 | 13905 | 182 |
2359307 | 2359307 | 2022-03-30 | Halifax | Virginia | 51083 | 7009 | 153 |
2355017 | 2355017 | 2022-03-29 | Halifax | North Carolina | 37083 | 13905 | 181 |
2356053 | 2356053 | 2022-03-29 | Halifax | Virginia | 51083 | 7007 | 152 |
2351764 | 2351764 | 2022-03-28 | Halifax | North Carolina | 37083 | 13904 | 181 |
2352800 | 2352800 | 2022-03-28 | Halifax | Virginia | 51083 | 7007 | 152 |
2348512 | 2348512 | 2022-03-27 | Halifax | North Carolina | 37083 | 13905 | 181 |
2349548 | 2349548 | 2022-03-27 | Halifax | Virginia | 51083 | 7007 | 152 |
2345259 | 2345259 | 2022-03-26 | Halifax | North Carolina | 37083 | 13905 | 181 |
2346295 | 2346295 | 2022-03-26 | Halifax | Virginia | 51083 | 7007 | 152 |
2342006 | 2342006 | 2022-03-25 | Halifax | North Carolina | 37083 | 13905 | 181 |
2343042 | 2343042 | 2022-03-25 | Halifax | Virginia | 51083 | 7007 | 152 |
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);