ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marion" 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 |
---|---|---|---|---|---|---|---|
536861 | 536861 | 2020-09-15 | Marion | South Carolina | 45067 | 783 | 20 |
533625 | 533625 | 2020-09-14 | Marion | South Carolina | 45067 | 772 | 20 |
530390 | 530390 | 2020-09-13 | Marion | South Carolina | 45067 | 768 | 19 |
527153 | 527153 | 2020-09-12 | Marion | South Carolina | 45067 | 762 | 19 |
523917 | 523917 | 2020-09-11 | Marion | South Carolina | 45067 | 756 | 19 |
520681 | 520681 | 2020-09-10 | Marion | South Carolina | 45067 | 752 | 18 |
517445 | 517445 | 2020-09-09 | Marion | South Carolina | 45067 | 752 | 18 |
514210 | 514210 | 2020-09-08 | Marion | South Carolina | 45067 | 752 | 17 |
510977 | 510977 | 2020-09-07 | Marion | South Carolina | 45067 | 751 | 17 |
507744 | 507744 | 2020-09-06 | Marion | South Carolina | 45067 | 741 | 17 |
504512 | 504512 | 2020-09-05 | Marion | South Carolina | 45067 | 737 | 17 |
501278 | 501278 | 2020-09-04 | Marion | South Carolina | 45067 | 731 | 17 |
498044 | 498044 | 2020-09-03 | Marion | South Carolina | 45067 | 723 | 17 |
494811 | 494811 | 2020-09-02 | Marion | South Carolina | 45067 | 720 | 17 |
491577 | 491577 | 2020-09-01 | Marion | South Carolina | 45067 | 718 | 17 |
488344 | 488344 | 2020-08-31 | Marion | South Carolina | 45067 | 709 | 17 |
485111 | 485111 | 2020-08-30 | Marion | South Carolina | 45067 | 687 | 17 |
481876 | 481876 | 2020-08-29 | Marion | South Carolina | 45067 | 678 | 17 |
478642 | 478642 | 2020-08-28 | Marion | South Carolina | 45067 | 669 | 17 |
475409 | 475409 | 2020-08-27 | Marion | South Carolina | 45067 | 661 | 17 |
472175 | 472175 | 2020-08-26 | Marion | South Carolina | 45067 | 656 | 17 |
468943 | 468943 | 2020-08-25 | Marion | South Carolina | 45067 | 650 | 17 |
465715 | 465715 | 2020-08-24 | Marion | South Carolina | 45067 | 646 | 17 |
462486 | 462486 | 2020-08-23 | Marion | South Carolina | 45067 | 641 | 17 |
459258 | 459258 | 2020-08-22 | Marion | South Carolina | 45067 | 632 | 17 |
456030 | 456030 | 2020-08-21 | Marion | South Carolina | 45067 | 625 | 17 |
452802 | 452802 | 2020-08-20 | Marion | South Carolina | 45067 | 609 | 16 |
449574 | 449574 | 2020-08-19 | Marion | South Carolina | 45067 | 594 | 14 |
446346 | 446346 | 2020-08-18 | Marion | South Carolina | 45067 | 592 | 14 |
443120 | 443120 | 2020-08-17 | Marion | South Carolina | 45067 | 590 | 14 |
439893 | 439893 | 2020-08-16 | Marion | South Carolina | 45067 | 586 | 14 |
436668 | 436668 | 2020-08-15 | Marion | South Carolina | 45067 | 579 | 14 |
433441 | 433441 | 2020-08-14 | Marion | South Carolina | 45067 | 577 | 14 |
430215 | 430215 | 2020-08-13 | Marion | South Carolina | 45067 | 573 | 14 |
426990 | 426990 | 2020-08-12 | Marion | South Carolina | 45067 | 566 | 13 |
423767 | 423767 | 2020-08-11 | Marion | South Carolina | 45067 | 560 | 13 |
420544 | 420544 | 2020-08-10 | Marion | South Carolina | 45067 | 558 | 13 |
417324 | 417324 | 2020-08-09 | Marion | South Carolina | 45067 | 554 | 13 |
414103 | 414103 | 2020-08-08 | Marion | South Carolina | 45067 | 549 | 13 |
410883 | 410883 | 2020-08-07 | Marion | South Carolina | 45067 | 542 | 13 |
407663 | 407663 | 2020-08-06 | Marion | South Carolina | 45067 | 535 | 13 |
404444 | 404444 | 2020-08-05 | Marion | South Carolina | 45067 | 531 | 13 |
401226 | 401226 | 2020-08-04 | Marion | South Carolina | 45067 | 527 | 12 |
398011 | 398011 | 2020-08-03 | Marion | South Carolina | 45067 | 523 | 12 |
394794 | 394794 | 2020-08-02 | Marion | South Carolina | 45067 | 522 | 12 |
391578 | 391578 | 2020-08-01 | Marion | South Carolina | 45067 | 513 | 12 |
388361 | 388361 | 2020-07-31 | Marion | South Carolina | 45067 | 511 | 12 |
385144 | 385144 | 2020-07-30 | Marion | South Carolina | 45067 | 498 | 12 |
381926 | 381926 | 2020-07-29 | Marion | South Carolina | 45067 | 486 | 12 |
378709 | 378709 | 2020-07-28 | Marion | South Carolina | 45067 | 477 | 12 |
375493 | 375493 | 2020-07-27 | Marion | South Carolina | 45067 | 465 | 12 |
372280 | 372280 | 2020-07-26 | Marion | South Carolina | 45067 | 453 | 12 |
369068 | 369068 | 2020-07-25 | Marion | South Carolina | 45067 | 444 | 12 |
365859 | 365859 | 2020-07-24 | Marion | South Carolina | 45067 | 436 | 12 |
362653 | 362653 | 2020-07-23 | Marion | South Carolina | 45067 | 425 | 11 |
359447 | 359447 | 2020-07-22 | Marion | South Carolina | 45067 | 419 | 11 |
356243 | 356243 | 2020-07-21 | Marion | South Carolina | 45067 | 411 | 11 |
353040 | 353040 | 2020-07-20 | Marion | South Carolina | 45067 | 398 | 11 |
349837 | 349837 | 2020-07-19 | Marion | South Carolina | 45067 | 386 | 11 |
346637 | 346637 | 2020-07-18 | Marion | South Carolina | 45067 | 367 | 11 |
343437 | 343437 | 2020-07-17 | Marion | South Carolina | 45067 | 359 | 10 |
340239 | 340239 | 2020-07-16 | Marion | South Carolina | 45067 | 349 | 10 |
337042 | 337042 | 2020-07-15 | Marion | South Carolina | 45067 | 344 | 10 |
333848 | 333848 | 2020-07-14 | Marion | South Carolina | 45067 | 339 | 10 |
330656 | 330656 | 2020-07-13 | Marion | South Carolina | 45067 | 325 | 10 |
327470 | 327470 | 2020-07-12 | Marion | South Carolina | 45067 | 321 | 9 |
324285 | 324285 | 2020-07-11 | Marion | South Carolina | 45067 | 304 | 9 |
321105 | 321105 | 2020-07-10 | Marion | South Carolina | 45067 | 299 | 9 |
317927 | 317927 | 2020-07-09 | Marion | South Carolina | 45067 | 294 | 9 |
314754 | 314754 | 2020-07-08 | Marion | South Carolina | 45067 | 285 | 9 |
311582 | 311582 | 2020-07-07 | Marion | South Carolina | 45067 | 281 | 9 |
308413 | 308413 | 2020-07-06 | Marion | South Carolina | 45067 | 280 | 8 |
305246 | 305246 | 2020-07-05 | Marion | South Carolina | 45067 | 275 | 8 |
302083 | 302083 | 2020-07-04 | Marion | South Carolina | 45067 | 262 | 8 |
298919 | 298919 | 2020-07-03 | Marion | South Carolina | 45067 | 234 | 8 |
295760 | 295760 | 2020-07-02 | Marion | South Carolina | 45067 | 214 | 7 |
292604 | 292604 | 2020-07-01 | Marion | South Carolina | 45067 | 212 | 7 |
289452 | 289452 | 2020-06-30 | Marion | South Carolina | 45067 | 208 | 7 |
286301 | 286301 | 2020-06-29 | Marion | South Carolina | 45067 | 193 | 7 |
283156 | 283156 | 2020-06-28 | Marion | South Carolina | 45067 | 191 | 7 |
280010 | 280010 | 2020-06-27 | Marion | South Carolina | 45067 | 176 | 7 |
276862 | 276862 | 2020-06-26 | Marion | South Carolina | 45067 | 171 | 6 |
273715 | 273715 | 2020-06-25 | Marion | South Carolina | 45067 | 170 | 6 |
270576 | 270576 | 2020-06-24 | Marion | South Carolina | 45067 | 164 | 6 |
267442 | 267442 | 2020-06-23 | Marion | South Carolina | 45067 | 159 | 6 |
264314 | 264314 | 2020-06-22 | Marion | South Carolina | 45067 | 155 | 6 |
261186 | 261186 | 2020-06-21 | Marion | South Carolina | 45067 | 146 | 5 |
258059 | 258059 | 2020-06-20 | Marion | South Carolina | 45067 | 141 | 5 |
254933 | 254933 | 2020-06-19 | Marion | South Carolina | 45067 | 122 | 5 |
251818 | 251818 | 2020-06-18 | Marion | South Carolina | 45067 | 118 | 5 |
248703 | 248703 | 2020-06-17 | Marion | South Carolina | 45067 | 113 | 5 |
245590 | 245590 | 2020-06-16 | Marion | South Carolina | 45067 | 108 | 5 |
242478 | 242478 | 2020-06-15 | Marion | South Carolina | 45067 | 105 | 5 |
239369 | 239369 | 2020-06-14 | Marion | South Carolina | 45067 | 103 | 5 |
236261 | 236261 | 2020-06-13 | Marion | South Carolina | 45067 | 95 | 5 |
233156 | 233156 | 2020-06-12 | Marion | South Carolina | 45067 | 88 | 5 |
230051 | 230051 | 2020-06-11 | Marion | South Carolina | 45067 | 86 | 5 |
226947 | 226947 | 2020-06-10 | Marion | South Carolina | 45067 | 83 | 5 |
223847 | 223847 | 2020-06-09 | Marion | South Carolina | 45067 | 83 | 5 |
220752 | 220752 | 2020-06-08 | Marion | South Carolina | 45067 | 84 | 5 |
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);