ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45003 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 224 ✖
- 437 46
- 225 29
- 224 27
- 7 22
- 6 18
- 9 18
- 356 17
- 226 15
- 1 13
- 215 12
- 0 11
- 85 11
- 87 10
- 210 10
- 218 10
- 229 10
- 8 9
- 98 9
- 227 8
- 433 8
- 10 7
- 86 7
- 217 7
- 222 7
- 347 7
- 364 7
- 436 7
- 13 6
- 77 6
- 82 6
- 91 6
- 336 6
- 368 6
- 4 5
- 133 5
- 216 5
- 354 5
- 369 5
- 378 5
- 416 5
- 434 5
- 3 4
- 11 4
- 23 4
- 68 4
- 84 4
- 90 4
- 111 4
- 193 4
- 211 4
- 219 4
- 232 4
- 256 4
- 289 4
- 321 4
- 355 4
- 360 4
- 373 4
- 407 4
- 428 4
- 15 3
- 24 3
- 46 3
- 56 3
- 57 3
- 63 3
- 76 3
- 95 3
- 105 3
- 115 3
- 146 3
- 165 3
- 167 3
- 207 3
- 214 3
- 220 3
- 221 3
- 223 3
- 236 3
- 242 3
- 271 3
- 286 3
- 294 3
- 313 3
- 317 3
- 319 3
- 324 3
- 343 3
- 349 3
- 383 3
- 396 3
- 422 3
- 20 2
- 26 2
- 33 2
- 38 2
- 42 2
- 67 2
- 78 2
- 81 2
- 89 2
- 96 2
- 101 2
- 121 2
- 124 2
- 150 2
- 153 2
- 159 2
- 169 2
- 175 2
- 176 2
- 182 2
- 183 2
- 197 2
- 199 2
- 201 2
- 202 2
- 213 2
- 233 2
- 239 2
- 269 2
- 285 2
- 327 2
- 345 2
- 348 2
- 352 2
- 361 2
- 371 2
- 372 2
- 375 2
- 388 2
- 404 2
- 408 2
- 418 2
- 426 2
- 2 1
- 5 1
- 14 1
- 18 1
- 22 1
- 29 1
- 31 1
- 34 1
- 37 1
- 39 1
- 44 1
- 49 1
- 50 1
- 51 1
- 53 1
- 62 1
- 64 1
- 65 1
- 69 1
- 71 1
- 74 1
- 79 1
- 80 1
- 92 1
- 93 1
- 99 1
- 100 1
- 108 1
- 109 1
- 110 1
- 116 1
- 119 1
- 123 1
- 131 1
- 132 1
- 136 1
- 138 1
- 139 1
- 140 1
- 141 1
- 143 1
- 144 1
- 145 1
- 148 1
- 149 1
- 154 1
- 162 1
- 163 1
- 178 1
- 188 1
- 189 1
- 191 1
- 192 1
- 196 1
- 204 1
- 228 1
- 235 1
- 240 1
- 241 1
- 247 1
- 250 1
- 253 1
- 267 1
- 268 1
- 277 1
- 281 1
- 297 1
- 298 1
- 306 1
- 308 1
- 318 1
- 331 1
- 332 1
- 339 1
- 357 1
- 358 1
- 359 1
- 367 1
- 374 1
- 379 1
- 380 1
- 391 1
- 394 1
- 405 1
- 412 1
- 419 1
- 423 1
- 430 1
- 432 1
state 1
- South Carolina 785
fips 1
- 45003 · 785 ✖
county 1
- Aiken 785
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5875 | 5875 | 2020-03-20 | Aiken | South Carolina | 45003 | 1 | 0 |
6879 | 6879 | 2020-03-21 | Aiken | South Carolina | 45003 | 1 | 0 |
7999 | 7999 | 2020-03-22 | Aiken | South Carolina | 45003 | 1 | 0 |
9210 | 9210 | 2020-03-23 | Aiken | South Carolina | 45003 | 1 | 0 |
10535 | 10535 | 2020-03-24 | Aiken | South Carolina | 45003 | 2 | 0 |
12006 | 12006 | 2020-03-25 | Aiken | South Carolina | 45003 | 2 | 0 |
13628 | 13628 | 2020-03-26 | Aiken | South Carolina | 45003 | 4 | 0 |
15375 | 15375 | 2020-03-27 | Aiken | South Carolina | 45003 | 6 | 0 |
17229 | 17229 | 2020-03-28 | Aiken | South Carolina | 45003 | 7 | 0 |
19169 | 19169 | 2020-03-29 | Aiken | South Carolina | 45003 | 9 | 0 |
21220 | 21220 | 2020-03-30 | Aiken | South Carolina | 45003 | 9 | 0 |
23357 | 23357 | 2020-03-31 | Aiken | South Carolina | 45003 | 13 | 1 |
25554 | 25554 | 2020-04-01 | Aiken | South Carolina | 45003 | 18 | 1 |
27827 | 27827 | 2020-04-02 | Aiken | South Carolina | 45003 | 22 | 1 |
30162 | 30162 | 2020-04-03 | Aiken | South Carolina | 45003 | 22 | 1 |
32553 | 32553 | 2020-04-04 | Aiken | South Carolina | 45003 | 24 | 1 |
34989 | 34989 | 2020-04-05 | Aiken | South Carolina | 45003 | 27 | 1 |
37464 | 37464 | 2020-04-06 | Aiken | South Carolina | 45003 | 27 | 1 |
39987 | 39987 | 2020-04-07 | Aiken | South Carolina | 45003 | 28 | 1 |
42547 | 42547 | 2020-04-08 | Aiken | South Carolina | 45003 | 32 | 1 |
45133 | 45133 | 2020-04-09 | Aiken | South Carolina | 45003 | 42 | 1 |
47750 | 47750 | 2020-04-10 | Aiken | South Carolina | 45003 | 48 | 1 |
50407 | 50407 | 2020-04-11 | Aiken | South Carolina | 45003 | 50 | 1 |
53080 | 53080 | 2020-04-12 | Aiken | South Carolina | 45003 | 50 | 1 |
55765 | 55765 | 2020-04-13 | Aiken | South Carolina | 45003 | 51 | 2 |
58468 | 58468 | 2020-04-14 | Aiken | South Carolina | 45003 | 60 | 3 |
61183 | 61183 | 2020-04-15 | Aiken | South Carolina | 45003 | 60 | 3 |
63909 | 63909 | 2020-04-16 | Aiken | South Carolina | 45003 | 63 | 3 |
66655 | 66655 | 2020-04-17 | Aiken | South Carolina | 45003 | 66 | 3 |
69413 | 69413 | 2020-04-18 | Aiken | South Carolina | 45003 | 67 | 4 |
72180 | 72180 | 2020-04-19 | Aiken | South Carolina | 45003 | 69 | 4 |
74955 | 74955 | 2020-04-20 | Aiken | South Carolina | 45003 | 70 | 4 |
77737 | 77737 | 2020-04-21 | Aiken | South Carolina | 45003 | 70 | 4 |
80527 | 80527 | 2020-04-22 | Aiken | South Carolina | 45003 | 82 | 4 |
83326 | 83326 | 2020-04-23 | Aiken | South Carolina | 45003 | 84 | 5 |
86130 | 86130 | 2020-04-24 | Aiken | South Carolina | 45003 | 86 | 6 |
88944 | 88944 | 2020-04-25 | Aiken | South Carolina | 45003 | 89 | 6 |
91760 | 91760 | 2020-04-26 | Aiken | South Carolina | 45003 | 89 | 6 |
94587 | 94587 | 2020-04-27 | Aiken | South Carolina | 45003 | 92 | 6 |
97426 | 97426 | 2020-04-28 | Aiken | South Carolina | 45003 | 94 | 6 |
100275 | 100275 | 2020-04-29 | Aiken | South Carolina | 45003 | 97 | 6 |
103128 | 103128 | 2020-04-30 | Aiken | South Carolina | 45003 | 99 | 6 |
105991 | 105991 | 2020-05-01 | Aiken | South Carolina | 45003 | 101 | 6 |
108858 | 108858 | 2020-05-02 | Aiken | South Carolina | 45003 | 105 | 6 |
111732 | 111732 | 2020-05-03 | Aiken | South Carolina | 45003 | 108 | 6 |
114614 | 114614 | 2020-05-04 | Aiken | South Carolina | 45003 | 108 | 6 |
117570 | 117570 | 2020-05-05 | Aiken | South Carolina | 45003 | 108 | 6 |
120532 | 120532 | 2020-05-06 | Aiken | South Carolina | 45003 | 108 | 6 |
123510 | 123510 | 2020-05-07 | Aiken | South Carolina | 45003 | 109 | 6 |
126493 | 126493 | 2020-05-08 | Aiken | South Carolina | 45003 | 112 | 6 |
129482 | 129482 | 2020-05-09 | Aiken | South Carolina | 45003 | 116 | 6 |
132471 | 132471 | 2020-05-10 | Aiken | South Carolina | 45003 | 118 | 6 |
135462 | 135462 | 2020-05-11 | Aiken | South Carolina | 45003 | 119 | 6 |
138452 | 138452 | 2020-05-12 | Aiken | South Carolina | 45003 | 123 | 7 |
141448 | 141448 | 2020-05-13 | Aiken | South Carolina | 45003 | 132 | 7 |
144444 | 144444 | 2020-05-14 | Aiken | South Carolina | 45003 | 135 | 7 |
147445 | 147445 | 2020-05-15 | Aiken | South Carolina | 45003 | 137 | 7 |
150453 | 150453 | 2020-05-16 | Aiken | South Carolina | 45003 | 150 | 7 |
153464 | 153464 | 2020-05-17 | Aiken | South Carolina | 45003 | 154 | 7 |
156481 | 156481 | 2020-05-18 | Aiken | South Carolina | 45003 | 155 | 7 |
159502 | 159502 | 2020-05-19 | Aiken | South Carolina | 45003 | 156 | 7 |
162529 | 162529 | 2020-05-20 | Aiken | South Carolina | 45003 | 160 | 7 |
165558 | 165558 | 2020-05-21 | Aiken | South Carolina | 45003 | 161 | 7 |
168594 | 168594 | 2020-05-22 | Aiken | South Carolina | 45003 | 166 | 7 |
171633 | 171633 | 2020-05-23 | Aiken | South Carolina | 45003 | 169 | 7 |
174675 | 174675 | 2020-05-24 | Aiken | South Carolina | 45003 | 173 | 7 |
177719 | 177719 | 2020-05-25 | Aiken | South Carolina | 45003 | 178 | 7 |
180762 | 180762 | 2020-05-26 | Aiken | South Carolina | 45003 | 181 | 7 |
183812 | 183812 | 2020-05-27 | Aiken | South Carolina | 45003 | 184 | 7 |
186869 | 186869 | 2020-05-28 | Aiken | South Carolina | 45003 | 189 | 7 |
189931 | 189931 | 2020-05-29 | Aiken | South Carolina | 45003 | 191 | 7 |
192996 | 192996 | 2020-05-30 | Aiken | South Carolina | 45003 | 194 | 7 |
196065 | 196065 | 2020-05-31 | Aiken | South Carolina | 45003 | 197 | 7 |
199138 | 199138 | 2020-06-01 | Aiken | South Carolina | 45003 | 206 | 7 |
202213 | 202213 | 2020-06-02 | Aiken | South Carolina | 45003 | 208 | 7 |
205290 | 205290 | 2020-06-03 | Aiken | South Carolina | 45003 | 210 | 8 |
208371 | 208371 | 2020-06-04 | Aiken | South Carolina | 45003 | 215 | 8 |
211453 | 211453 | 2020-06-05 | Aiken | South Carolina | 45003 | 216 | 8 |
214539 | 214539 | 2020-06-06 | Aiken | South Carolina | 45003 | 207 | 8 |
217629 | 217629 | 2020-06-07 | Aiken | South Carolina | 45003 | 208 | 8 |
220721 | 220721 | 2020-06-08 | Aiken | South Carolina | 45003 | 212 | 8 |
223816 | 223816 | 2020-06-09 | Aiken | South Carolina | 45003 | 213 | 8 |
226916 | 226916 | 2020-06-10 | Aiken | South Carolina | 45003 | 216 | 8 |
230020 | 230020 | 2020-06-11 | Aiken | South Carolina | 45003 | 222 | 8 |
233125 | 233125 | 2020-06-12 | Aiken | South Carolina | 45003 | 225 | 9 |
236230 | 236230 | 2020-06-13 | Aiken | South Carolina | 45003 | 228 | 9 |
239338 | 239338 | 2020-06-14 | Aiken | South Carolina | 45003 | 232 | 9 |
242447 | 242447 | 2020-06-15 | Aiken | South Carolina | 45003 | 234 | 9 |
245559 | 245559 | 2020-06-16 | Aiken | South Carolina | 45003 | 240 | 9 |
248672 | 248672 | 2020-06-17 | Aiken | South Carolina | 45003 | 246 | 9 |
251787 | 251787 | 2020-06-18 | Aiken | South Carolina | 45003 | 256 | 9 |
254902 | 254902 | 2020-06-19 | Aiken | South Carolina | 45003 | 261 | 9 |
258028 | 258028 | 2020-06-20 | Aiken | South Carolina | 45003 | 267 | 9 |
261155 | 261155 | 2020-06-21 | Aiken | South Carolina | 45003 | 274 | 9 |
264283 | 264283 | 2020-06-22 | Aiken | South Carolina | 45003 | 279 | 9 |
267411 | 267411 | 2020-06-23 | Aiken | South Carolina | 45003 | 281 | 9 |
270545 | 270545 | 2020-06-24 | Aiken | South Carolina | 45003 | 302 | 9 |
273684 | 273684 | 2020-06-25 | Aiken | South Carolina | 45003 | 314 | 9 |
276831 | 276831 | 2020-06-26 | Aiken | South Carolina | 45003 | 325 | 9 |
279979 | 279979 | 2020-06-27 | Aiken | South Carolina | 45003 | 335 | 9 |
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);