ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 45079 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 |
---|---|---|---|---|---|---|---|
637337 | 637337 | 2020-10-16 | Richland | South Carolina | 45079 | 16476 | 260 |
634091 | 634091 | 2020-10-15 | Richland | South Carolina | 45079 | 16366 | 258 |
630846 | 630846 | 2020-10-14 | Richland | South Carolina | 45079 | 16263 | 258 |
627602 | 627602 | 2020-10-13 | Richland | South Carolina | 45079 | 16206 | 258 |
624360 | 624360 | 2020-10-12 | Richland | South Carolina | 45079 | 16152 | 255 |
621117 | 621117 | 2020-10-11 | Richland | South Carolina | 45079 | 16128 | 255 |
617874 | 617874 | 2020-10-10 | Richland | South Carolina | 45079 | 16095 | 254 |
614632 | 614632 | 2020-10-09 | Richland | South Carolina | 45079 | 16017 | 253 |
611391 | 611391 | 2020-10-08 | Richland | South Carolina | 45079 | 15953 | 251 |
608149 | 608149 | 2020-10-07 | Richland | South Carolina | 45079 | 15893 | 251 |
604906 | 604906 | 2020-10-06 | Richland | South Carolina | 45079 | 15845 | 251 |
601664 | 601664 | 2020-10-05 | Richland | South Carolina | 45079 | 15764 | 250 |
598421 | 598421 | 2020-10-04 | Richland | South Carolina | 45079 | 15719 | 249 |
595178 | 595178 | 2020-10-03 | Richland | South Carolina | 45079 | 15652 | 249 |
591937 | 591937 | 2020-10-02 | Richland | South Carolina | 45079 | 15522 | 248 |
588696 | 588696 | 2020-10-01 | Richland | South Carolina | 45079 | 15475 | 246 |
585456 | 585456 | 2020-09-30 | Richland | South Carolina | 45079 | 15449 | 244 |
582216 | 582216 | 2020-09-29 | Richland | South Carolina | 45079 | 15396 | 244 |
578976 | 578976 | 2020-09-28 | Richland | South Carolina | 45079 | 15340 | 244 |
575735 | 575735 | 2020-09-27 | Richland | South Carolina | 45079 | 15250 | 240 |
572491 | 572491 | 2020-09-26 | Richland | South Carolina | 45079 | 15191 | 239 |
569249 | 569249 | 2020-09-25 | Richland | South Carolina | 45079 | 15014 | 235 |
566008 | 566008 | 2020-09-24 | Richland | South Carolina | 45079 | 14833 | 234 |
562767 | 562767 | 2020-09-23 | Richland | South Carolina | 45079 | 14691 | 230 |
559530 | 559530 | 2020-09-22 | Richland | South Carolina | 45079 | 14591 | 230 |
556293 | 556293 | 2020-09-21 | Richland | South Carolina | 45079 | 14479 | 226 |
553056 | 553056 | 2020-09-20 | Richland | South Carolina | 45079 | 14434 | 225 |
549817 | 549817 | 2020-09-19 | Richland | South Carolina | 45079 | 14349 | 224 |
546578 | 546578 | 2020-09-18 | Richland | South Carolina | 45079 | 14220 | 223 |
543341 | 543341 | 2020-09-17 | Richland | South Carolina | 45079 | 14141 | 222 |
540105 | 540105 | 2020-09-16 | Richland | South Carolina | 45079 | 13941 | 220 |
536868 | 536868 | 2020-09-15 | Richland | South Carolina | 45079 | 13853 | 220 |
533632 | 533632 | 2020-09-14 | Richland | South Carolina | 45079 | 13771 | 218 |
530397 | 530397 | 2020-09-13 | Richland | South Carolina | 45079 | 13638 | 217 |
527160 | 527160 | 2020-09-12 | Richland | South Carolina | 45079 | 13375 | 215 |
523924 | 523924 | 2020-09-11 | Richland | South Carolina | 45079 | 13269 | 211 |
520688 | 520688 | 2020-09-10 | Richland | South Carolina | 45079 | 12503 | 210 |
517452 | 517452 | 2020-09-09 | Richland | South Carolina | 45079 | 12430 | 207 |
514217 | 514217 | 2020-09-08 | Richland | South Carolina | 45079 | 12396 | 204 |
510984 | 510984 | 2020-09-07 | Richland | South Carolina | 45079 | 12318 | 204 |
507751 | 507751 | 2020-09-06 | Richland | South Carolina | 45079 | 12243 | 203 |
504519 | 504519 | 2020-09-05 | Richland | South Carolina | 45079 | 12152 | 203 |
501285 | 501285 | 2020-09-04 | Richland | South Carolina | 45079 | 12012 | 197 |
498051 | 498051 | 2020-09-03 | Richland | South Carolina | 45079 | 11562 | 196 |
494818 | 494818 | 2020-09-02 | Richland | South Carolina | 45079 | 11440 | 196 |
491584 | 491584 | 2020-09-01 | Richland | South Carolina | 45079 | 11363 | 196 |
488351 | 488351 | 2020-08-31 | Richland | South Carolina | 45079 | 11194 | 196 |
485118 | 485118 | 2020-08-30 | Richland | South Carolina | 45079 | 11011 | 196 |
481883 | 481883 | 2020-08-29 | Richland | South Carolina | 45079 | 10603 | 195 |
478649 | 478649 | 2020-08-28 | Richland | South Carolina | 45079 | 10404 | 194 |
475416 | 475416 | 2020-08-27 | Richland | South Carolina | 45079 | 10257 | 193 |
472182 | 472182 | 2020-08-26 | Richland | South Carolina | 45079 | 10179 | 190 |
468950 | 468950 | 2020-08-25 | Richland | South Carolina | 45079 | 10084 | 187 |
465722 | 465722 | 2020-08-24 | Richland | South Carolina | 45079 | 9997 | 185 |
462493 | 462493 | 2020-08-23 | Richland | South Carolina | 45079 | 9945 | 185 |
459265 | 459265 | 2020-08-22 | Richland | South Carolina | 45079 | 9865 | 185 |
456037 | 456037 | 2020-08-21 | Richland | South Carolina | 45079 | 9777 | 183 |
452809 | 452809 | 2020-08-20 | Richland | South Carolina | 45079 | 9681 | 179 |
449581 | 449581 | 2020-08-19 | Richland | South Carolina | 45079 | 9564 | 178 |
446353 | 446353 | 2020-08-18 | Richland | South Carolina | 45079 | 9468 | 178 |
443127 | 443127 | 2020-08-17 | Richland | South Carolina | 45079 | 9404 | 170 |
439900 | 439900 | 2020-08-16 | Richland | South Carolina | 45079 | 9365 | 168 |
436675 | 436675 | 2020-08-15 | Richland | South Carolina | 45079 | 9315 | 165 |
433448 | 433448 | 2020-08-14 | Richland | South Carolina | 45079 | 9224 | 163 |
430222 | 430222 | 2020-08-13 | Richland | South Carolina | 45079 | 9142 | 159 |
426997 | 426997 | 2020-08-12 | Richland | South Carolina | 45079 | 9049 | 158 |
423774 | 423774 | 2020-08-11 | Richland | South Carolina | 45079 | 8917 | 154 |
420551 | 420551 | 2020-08-10 | Richland | South Carolina | 45079 | 8836 | 153 |
417331 | 417331 | 2020-08-09 | Richland | South Carolina | 45079 | 8774 | 152 |
414110 | 414110 | 2020-08-08 | Richland | South Carolina | 45079 | 8707 | 151 |
410890 | 410890 | 2020-08-07 | Richland | South Carolina | 45079 | 8579 | 148 |
407670 | 407670 | 2020-08-06 | Richland | South Carolina | 45079 | 8464 | 148 |
404451 | 404451 | 2020-08-05 | Richland | South Carolina | 45079 | 8344 | 148 |
401233 | 401233 | 2020-08-04 | Richland | South Carolina | 45079 | 8173 | 143 |
398018 | 398018 | 2020-08-03 | Richland | South Carolina | 45079 | 8040 | 141 |
394801 | 394801 | 2020-08-02 | Richland | South Carolina | 45079 | 7975 | 140 |
391585 | 391585 | 2020-08-01 | Richland | South Carolina | 45079 | 7866 | 133 |
388368 | 388368 | 2020-07-31 | Richland | South Carolina | 45079 | 7780 | 131 |
385151 | 385151 | 2020-07-30 | Richland | South Carolina | 45079 | 7617 | 129 |
381933 | 381933 | 2020-07-29 | Richland | South Carolina | 45079 | 7395 | 128 |
378716 | 378716 | 2020-07-28 | Richland | South Carolina | 45079 | 7235 | 127 |
375500 | 375500 | 2020-07-27 | Richland | South Carolina | 45079 | 7092 | 127 |
372287 | 372287 | 2020-07-26 | Richland | South Carolina | 45079 | 7007 | 127 |
369075 | 369075 | 2020-07-25 | Richland | South Carolina | 45079 | 6938 | 126 |
365866 | 365866 | 2020-07-24 | Richland | South Carolina | 45079 | 6845 | 124 |
362660 | 362660 | 2020-07-23 | Richland | South Carolina | 45079 | 6687 | 122 |
359454 | 359454 | 2020-07-22 | Richland | South Carolina | 45079 | 6581 | 116 |
356250 | 356250 | 2020-07-21 | Richland | South Carolina | 45079 | 6408 | 112 |
353047 | 353047 | 2020-07-20 | Richland | South Carolina | 45079 | 6216 | 109 |
349844 | 349844 | 2020-07-19 | Richland | South Carolina | 45079 | 6050 | 108 |
346644 | 346644 | 2020-07-18 | Richland | South Carolina | 45079 | 5930 | 106 |
343444 | 343444 | 2020-07-17 | Richland | South Carolina | 45079 | 5756 | 105 |
340246 | 340246 | 2020-07-16 | Richland | South Carolina | 45079 | 5550 | 102 |
337049 | 337049 | 2020-07-15 | Richland | South Carolina | 45079 | 5413 | 99 |
333855 | 333855 | 2020-07-14 | Richland | South Carolina | 45079 | 5229 | 99 |
330663 | 330663 | 2020-07-13 | Richland | South Carolina | 45079 | 4995 | 99 |
327477 | 327477 | 2020-07-12 | Richland | South Carolina | 45079 | 4875 | 98 |
324292 | 324292 | 2020-07-11 | Richland | South Carolina | 45079 | 4722 | 98 |
321112 | 321112 | 2020-07-10 | Richland | South Carolina | 45079 | 4571 | 97 |
317934 | 317934 | 2020-07-09 | Richland | South Carolina | 45079 | 4470 | 93 |
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);