ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 45033 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388345 | 388345 | 2020-07-31 | Dillon | South Carolina | 45033 | 541 | 23 |
385128 | 385128 | 2020-07-30 | Dillon | South Carolina | 45033 | 536 | 23 |
381910 | 381910 | 2020-07-29 | Dillon | South Carolina | 45033 | 521 | 21 |
378693 | 378693 | 2020-07-28 | Dillon | South Carolina | 45033 | 516 | 21 |
375477 | 375477 | 2020-07-27 | Dillon | South Carolina | 45033 | 506 | 21 |
372264 | 372264 | 2020-07-26 | Dillon | South Carolina | 45033 | 499 | 21 |
369052 | 369052 | 2020-07-25 | Dillon | South Carolina | 45033 | 486 | 21 |
365843 | 365843 | 2020-07-24 | Dillon | South Carolina | 45033 | 480 | 21 |
362637 | 362637 | 2020-07-23 | Dillon | South Carolina | 45033 | 471 | 20 |
359431 | 359431 | 2020-07-22 | Dillon | South Carolina | 45033 | 462 | 19 |
356227 | 356227 | 2020-07-21 | Dillon | South Carolina | 45033 | 455 | 19 |
353024 | 353024 | 2020-07-20 | Dillon | South Carolina | 45033 | 441 | 18 |
349821 | 349821 | 2020-07-19 | Dillon | South Carolina | 45033 | 436 | 18 |
346621 | 346621 | 2020-07-18 | Dillon | South Carolina | 45033 | 426 | 18 |
343421 | 343421 | 2020-07-17 | Dillon | South Carolina | 45033 | 426 | 17 |
340223 | 340223 | 2020-07-16 | Dillon | South Carolina | 45033 | 416 | 16 |
337026 | 337026 | 2020-07-15 | Dillon | South Carolina | 45033 | 407 | 14 |
333832 | 333832 | 2020-07-14 | Dillon | South Carolina | 45033 | 402 | 14 |
330640 | 330640 | 2020-07-13 | Dillon | South Carolina | 45033 | 397 | 14 |
327454 | 327454 | 2020-07-12 | Dillon | South Carolina | 45033 | 384 | 14 |
324269 | 324269 | 2020-07-11 | Dillon | South Carolina | 45033 | 376 | 14 |
321089 | 321089 | 2020-07-10 | Dillon | South Carolina | 45033 | 370 | 13 |
317911 | 317911 | 2020-07-09 | Dillon | South Carolina | 45033 | 363 | 13 |
314738 | 314738 | 2020-07-08 | Dillon | South Carolina | 45033 | 356 | 13 |
311566 | 311566 | 2020-07-07 | Dillon | South Carolina | 45033 | 350 | 12 |
308397 | 308397 | 2020-07-06 | Dillon | South Carolina | 45033 | 344 | 12 |
305230 | 305230 | 2020-07-05 | Dillon | South Carolina | 45033 | 336 | 10 |
302067 | 302067 | 2020-07-04 | Dillon | South Carolina | 45033 | 330 | 10 |
298903 | 298903 | 2020-07-03 | Dillon | South Carolina | 45033 | 321 | 10 |
295744 | 295744 | 2020-07-02 | Dillon | South Carolina | 45033 | 316 | 10 |
292588 | 292588 | 2020-07-01 | Dillon | South Carolina | 45033 | 307 | 10 |
289436 | 289436 | 2020-06-30 | Dillon | South Carolina | 45033 | 304 | 9 |
286285 | 286285 | 2020-06-29 | Dillon | South Carolina | 45033 | 298 | 8 |
283140 | 283140 | 2020-06-28 | Dillon | South Carolina | 45033 | 289 | 8 |
279994 | 279994 | 2020-06-27 | Dillon | South Carolina | 45033 | 263 | 8 |
276846 | 276846 | 2020-06-26 | Dillon | South Carolina | 45033 | 255 | 7 |
273699 | 273699 | 2020-06-25 | Dillon | South Carolina | 45033 | 248 | 7 |
270560 | 270560 | 2020-06-24 | Dillon | South Carolina | 45033 | 237 | 6 |
267426 | 267426 | 2020-06-23 | Dillon | South Carolina | 45033 | 231 | 5 |
264298 | 264298 | 2020-06-22 | Dillon | South Carolina | 45033 | 230 | 5 |
261170 | 261170 | 2020-06-21 | Dillon | South Carolina | 45033 | 226 | 5 |
258043 | 258043 | 2020-06-20 | Dillon | South Carolina | 45033 | 223 | 5 |
254917 | 254917 | 2020-06-19 | Dillon | South Carolina | 45033 | 219 | 5 |
251802 | 251802 | 2020-06-18 | Dillon | South Carolina | 45033 | 217 | 5 |
248687 | 248687 | 2020-06-17 | Dillon | South Carolina | 45033 | 207 | 5 |
245574 | 245574 | 2020-06-16 | Dillon | South Carolina | 45033 | 202 | 5 |
242462 | 242462 | 2020-06-15 | Dillon | South Carolina | 45033 | 202 | 4 |
239353 | 239353 | 2020-06-14 | Dillon | South Carolina | 45033 | 201 | 4 |
236245 | 236245 | 2020-06-13 | Dillon | South Carolina | 45033 | 200 | 4 |
233140 | 233140 | 2020-06-12 | Dillon | South Carolina | 45033 | 198 | 4 |
230035 | 230035 | 2020-06-11 | Dillon | South Carolina | 45033 | 192 | 4 |
226931 | 226931 | 2020-06-10 | Dillon | South Carolina | 45033 | 190 | 4 |
223831 | 223831 | 2020-06-09 | Dillon | South Carolina | 45033 | 189 | 4 |
220736 | 220736 | 2020-06-08 | Dillon | South Carolina | 45033 | 189 | 4 |
217644 | 217644 | 2020-06-07 | Dillon | South Carolina | 45033 | 188 | 3 |
214554 | 214554 | 2020-06-06 | Dillon | South Carolina | 45033 | 185 | 3 |
211468 | 211468 | 2020-06-05 | Dillon | South Carolina | 45033 | 177 | 3 |
208386 | 208386 | 2020-06-04 | Dillon | South Carolina | 45033 | 174 | 3 |
205305 | 205305 | 2020-06-03 | Dillon | South Carolina | 45033 | 170 | 3 |
202228 | 202228 | 2020-06-02 | Dillon | South Carolina | 45033 | 170 | 3 |
199153 | 199153 | 2020-06-01 | Dillon | South Carolina | 45033 | 166 | 3 |
196080 | 196080 | 2020-05-31 | Dillon | South Carolina | 45033 | 165 | 3 |
193011 | 193011 | 2020-05-30 | Dillon | South Carolina | 45033 | 162 | 3 |
189946 | 189946 | 2020-05-29 | Dillon | South Carolina | 45033 | 156 | 3 |
186884 | 186884 | 2020-05-28 | Dillon | South Carolina | 45033 | 155 | 3 |
183827 | 183827 | 2020-05-27 | Dillon | South Carolina | 45033 | 155 | 3 |
180777 | 180777 | 2020-05-26 | Dillon | South Carolina | 45033 | 152 | 3 |
177734 | 177734 | 2020-05-25 | Dillon | South Carolina | 45033 | 148 | 3 |
174690 | 174690 | 2020-05-24 | Dillon | South Carolina | 45033 | 147 | 3 |
171648 | 171648 | 2020-05-23 | Dillon | South Carolina | 45033 | 147 | 3 |
168609 | 168609 | 2020-05-22 | Dillon | South Carolina | 45033 | 146 | 3 |
165573 | 165573 | 2020-05-21 | Dillon | South Carolina | 45033 | 138 | 3 |
162544 | 162544 | 2020-05-20 | Dillon | South Carolina | 45033 | 135 | 2 |
159517 | 159517 | 2020-05-19 | Dillon | South Carolina | 45033 | 132 | 2 |
156496 | 156496 | 2020-05-18 | Dillon | South Carolina | 45033 | 131 | 1 |
153479 | 153479 | 2020-05-17 | Dillon | South Carolina | 45033 | 129 | 1 |
150468 | 150468 | 2020-05-16 | Dillon | South Carolina | 45033 | 124 | 0 |
147460 | 147460 | 2020-05-15 | Dillon | South Carolina | 45033 | 115 | 0 |
144459 | 144459 | 2020-05-14 | Dillon | South Carolina | 45033 | 113 | 0 |
141463 | 141463 | 2020-05-13 | Dillon | South Carolina | 45033 | 104 | 0 |
138467 | 138467 | 2020-05-12 | Dillon | South Carolina | 45033 | 102 | 0 |
135477 | 135477 | 2020-05-11 | Dillon | South Carolina | 45033 | 102 | 0 |
132486 | 132486 | 2020-05-10 | Dillon | South Carolina | 45033 | 95 | 0 |
129497 | 129497 | 2020-05-09 | Dillon | South Carolina | 45033 | 88 | 0 |
126508 | 126508 | 2020-05-08 | Dillon | South Carolina | 45033 | 84 | 0 |
123525 | 123525 | 2020-05-07 | Dillon | South Carolina | 45033 | 78 | 0 |
120547 | 120547 | 2020-05-06 | Dillon | South Carolina | 45033 | 74 | 0 |
117585 | 117585 | 2020-05-05 | Dillon | South Carolina | 45033 | 74 | 0 |
114629 | 114629 | 2020-05-04 | Dillon | South Carolina | 45033 | 74 | 0 |
111747 | 111747 | 2020-05-03 | Dillon | South Carolina | 45033 | 72 | 0 |
108873 | 108873 | 2020-05-02 | Dillon | South Carolina | 45033 | 67 | 0 |
106006 | 106006 | 2020-05-01 | Dillon | South Carolina | 45033 | 54 | 0 |
103143 | 103143 | 2020-04-30 | Dillon | South Carolina | 45033 | 52 | 0 |
100290 | 100290 | 2020-04-29 | Dillon | South Carolina | 45033 | 47 | 0 |
97441 | 97441 | 2020-04-28 | Dillon | South Carolina | 45033 | 44 | 0 |
94602 | 94602 | 2020-04-27 | Dillon | South Carolina | 45033 | 44 | 0 |
91775 | 91775 | 2020-04-26 | Dillon | South Carolina | 45033 | 41 | 0 |
88959 | 88959 | 2020-04-25 | Dillon | South Carolina | 45033 | 35 | 0 |
86145 | 86145 | 2020-04-24 | Dillon | South Carolina | 45033 | 34 | 0 |
83341 | 83341 | 2020-04-23 | Dillon | South Carolina | 45033 | 28 | 0 |
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);