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, date (date)
deaths 167 ✖
- 1 130
- 0 90
- 78 87
- 112 46
- 4 43
- 77 31
- 114 31
- 116 31
- 127 29
- 144 27
- 2 26
- 8 25
- 159 25
- 6 24
- 7 23
- 73 19
- 109 18
- 146 17
- 103 15
- 99 14
- 182 14
- 184 14
- 56 13
- 72 13
- 80 13
- 89 13
- 150 13
- 181 13
- 27 12
- 44 12
- 115 12
- 118 12
- 143 12
- 17 11
- 18 11
- 121 11
- 19 10
- 107 10
- 129 10
- 139 10
- 152 10
- 177 10
- 187 10
- 5 9
- 25 9
- 35 9
- 36 9
- 38 9
- 102 9
- 9 8
- 10 8
- 12 8
- 22 8
- 52 8
- 90 8
- 97 8
- 108 8
- 111 8
- 117 8
- 138 8
- 145 8
- 148 8
- 151 8
- 156 8
- 91 7
- 95 7
- 101 7
- 105 7
- 106 7
- 128 7
- 132 7
- 155 7
- 173 7
- 176 7
- 183 7
- 13 6
- 31 6
- 32 6
- 45 6
- 47 6
- 154 6
- 3 5
- 11 5
- 21 5
- 24 5
- 74 5
- 88 5
- 104 5
- 110 5
- 113 5
- 126 5
- 130 5
- 134 5
- 141 5
- 147 5
- 149 5
- 28 4
- 34 4
- 51 4
- 53 4
- 55 4
- 57 4
- 59 4
- 64 4
- 65 4
- 75 4
- 100 4
- 122 4
- 131 4
- 133 4
- 137 4
- 140 4
- 175 4
- 37 3
- 41 3
- 49 3
- 50 3
- 61 3
- 66 3
- 81 3
- 85 3
- 86 3
- 93 3
- 94 3
- 142 3
- 153 3
- 158 3
- 163 3
- 171 3
- 16 2
- 20 2
- 23 2
- 29 2
- 30 2
- 33 2
- 40 2
- 42 2
- 43 2
- 46 2
- 54 2
- 62 2
- 71 2
- 83 2
- 92 2
- 96 2
- 119 2
- 124 2
- 136 2
- 162 2
- 174 2
- 15 1
- 26 1
- 48 1
- 58 1
- 63 1
- 67 1
- 68 1
- 69 1
- 70 1
- 76 1
- 84 1
- 98 1
- 166 1
- 168 1
- 169 1
- 170 1
- 172 1
state 2
- Virginia 781
- North Carolina 776
county 1
- Halifax · 1,557 ✖
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);