ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Greenville" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
267432 | 267432 | 2020-06-23 | Greenville | South Carolina | 45045 | 3827 | 75 |
270566 | 270566 | 2020-06-24 | Greenville | South Carolina | 45045 | 4072 | 77 |
273705 | 273705 | 2020-06-25 | Greenville | South Carolina | 45045 | 4198 | 77 |
276852 | 276852 | 2020-06-26 | Greenville | South Carolina | 45045 | 4391 | 78 |
280000 | 280000 | 2020-06-27 | Greenville | South Carolina | 45045 | 4546 | 80 |
283146 | 283146 | 2020-06-28 | Greenville | South Carolina | 45045 | 4741 | 80 |
286291 | 286291 | 2020-06-29 | Greenville | South Carolina | 45045 | 4895 | 80 |
289442 | 289442 | 2020-06-30 | Greenville | South Carolina | 45045 | 5009 | 81 |
292594 | 292594 | 2020-07-01 | Greenville | South Carolina | 45045 | 5118 | 83 |
295750 | 295750 | 2020-07-02 | Greenville | South Carolina | 45045 | 5371 | 83 |
298909 | 298909 | 2020-07-03 | Greenville | South Carolina | 45045 | 5497 | 86 |
302073 | 302073 | 2020-07-04 | Greenville | South Carolina | 45045 | 5696 | 86 |
305236 | 305236 | 2020-07-05 | Greenville | South Carolina | 45045 | 5864 | 87 |
308403 | 308403 | 2020-07-06 | Greenville | South Carolina | 45045 | 6019 | 87 |
311572 | 311572 | 2020-07-07 | Greenville | South Carolina | 45045 | 6068 | 90 |
314744 | 314744 | 2020-07-08 | Greenville | South Carolina | 45045 | 6235 | 96 |
317917 | 317917 | 2020-07-09 | Greenville | South Carolina | 45045 | 6443 | 101 |
321095 | 321095 | 2020-07-10 | Greenville | South Carolina | 45045 | 6653 | 103 |
324275 | 324275 | 2020-07-11 | Greenville | South Carolina | 45045 | 6929 | 103 |
327460 | 327460 | 2020-07-12 | Greenville | South Carolina | 45045 | 7145 | 105 |
330646 | 330646 | 2020-07-13 | Greenville | South Carolina | 45045 | 7261 | 106 |
333838 | 333838 | 2020-07-14 | Greenville | South Carolina | 45045 | 7464 | 106 |
337032 | 337032 | 2020-07-15 | Greenville | South Carolina | 45045 | 7633 | 107 |
340229 | 340229 | 2020-07-16 | Greenville | South Carolina | 45045 | 7856 | 123 |
343427 | 343427 | 2020-07-17 | Greenville | South Carolina | 45045 | 8026 | 125 |
346627 | 346627 | 2020-07-18 | Greenville | South Carolina | 45045 | 8215 | 130 |
349827 | 349827 | 2020-07-19 | Greenville | South Carolina | 45045 | 8408 | 132 |
353030 | 353030 | 2020-07-20 | Greenville | South Carolina | 45045 | 8583 | 133 |
356233 | 356233 | 2020-07-21 | Greenville | South Carolina | 45045 | 8728 | 136 |
359437 | 359437 | 2020-07-22 | Greenville | South Carolina | 45045 | 8832 | 137 |
362643 | 362643 | 2020-07-23 | Greenville | South Carolina | 45045 | 8965 | 142 |
365849 | 365849 | 2020-07-24 | Greenville | South Carolina | 45045 | 9135 | 151 |
369058 | 369058 | 2020-07-25 | Greenville | South Carolina | 45045 | 9266 | 155 |
372270 | 372270 | 2020-07-26 | Greenville | South Carolina | 45045 | 9361 | 157 |
375483 | 375483 | 2020-07-27 | Greenville | South Carolina | 45045 | 9481 | 157 |
378699 | 378699 | 2020-07-28 | Greenville | South Carolina | 45045 | 9625 | 165 |
381916 | 381916 | 2020-07-29 | Greenville | South Carolina | 45045 | 9737 | 169 |
385134 | 385134 | 2020-07-30 | Greenville | South Carolina | 45045 | 9876 | 175 |
388351 | 388351 | 2020-07-31 | Greenville | South Carolina | 45045 | 10034 | 184 |
391568 | 391568 | 2020-08-01 | Greenville | South Carolina | 45045 | 10139 | 187 |
394784 | 394784 | 2020-08-02 | Greenville | South Carolina | 45045 | 10211 | 188 |
398001 | 398001 | 2020-08-03 | Greenville | South Carolina | 45045 | 10306 | 189 |
401216 | 401216 | 2020-08-04 | Greenville | South Carolina | 45045 | 10442 | 196 |
404434 | 404434 | 2020-08-05 | Greenville | South Carolina | 45045 | 10495 | 198 |
407653 | 407653 | 2020-08-06 | Greenville | South Carolina | 45045 | 10635 | 201 |
410873 | 410873 | 2020-08-07 | Greenville | South Carolina | 45045 | 10745 | 204 |
414093 | 414093 | 2020-08-08 | Greenville | South Carolina | 45045 | 10819 | 206 |
417314 | 417314 | 2020-08-09 | Greenville | South Carolina | 45045 | 10916 | 208 |
420534 | 420534 | 2020-08-10 | Greenville | South Carolina | 45045 | 11001 | 208 |
423757 | 423757 | 2020-08-11 | Greenville | South Carolina | 45045 | 11028 | 213 |
426980 | 426980 | 2020-08-12 | Greenville | South Carolina | 45045 | 11056 | 218 |
430205 | 430205 | 2020-08-13 | Greenville | South Carolina | 45045 | 11109 | 222 |
433431 | 433431 | 2020-08-14 | Greenville | South Carolina | 45045 | 11186 | 222 |
436658 | 436658 | 2020-08-15 | Greenville | South Carolina | 45045 | 11238 | 227 |
439883 | 439883 | 2020-08-16 | Greenville | South Carolina | 45045 | 11252 | 227 |
443110 | 443110 | 2020-08-17 | Greenville | South Carolina | 45045 | 11277 | 229 |
446336 | 446336 | 2020-08-18 | Greenville | South Carolina | 45045 | 11327 | 235 |
449564 | 449564 | 2020-08-19 | Greenville | South Carolina | 45045 | 11350 | 237 |
452792 | 452792 | 2020-08-20 | Greenville | South Carolina | 45045 | 11388 | 240 |
456020 | 456020 | 2020-08-21 | Greenville | South Carolina | 45045 | 11482 | 243 |
459248 | 459248 | 2020-08-22 | Greenville | South Carolina | 45045 | 11523 | 243 |
462476 | 462476 | 2020-08-23 | Greenville | South Carolina | 45045 | 11574 | 243 |
465705 | 465705 | 2020-08-24 | Greenville | South Carolina | 45045 | 11620 | 244 |
468933 | 468933 | 2020-08-25 | Greenville | South Carolina | 45045 | 11804 | 245 |
472165 | 472165 | 2020-08-26 | Greenville | South Carolina | 45045 | 11835 | 248 |
475399 | 475399 | 2020-08-27 | Greenville | South Carolina | 45045 | 11851 | 253 |
478632 | 478632 | 2020-08-28 | Greenville | South Carolina | 45045 | 11962 | 255 |
481866 | 481866 | 2020-08-29 | Greenville | South Carolina | 45045 | 12038 | 256 |
485101 | 485101 | 2020-08-30 | Greenville | South Carolina | 45045 | 12089 | 256 |
488334 | 488334 | 2020-08-31 | Greenville | South Carolina | 45045 | 12137 | 256 |
491567 | 491567 | 2020-09-01 | Greenville | South Carolina | 45045 | 12175 | 259 |
494801 | 494801 | 2020-09-02 | Greenville | South Carolina | 45045 | 12212 | 264 |
498034 | 498034 | 2020-09-03 | Greenville | South Carolina | 45045 | 12328 | 266 |
501268 | 501268 | 2020-09-04 | Greenville | South Carolina | 45045 | 12447 | 266 |
504502 | 504502 | 2020-09-05 | Greenville | South Carolina | 45045 | 12524 | 267 |
507734 | 507734 | 2020-09-06 | Greenville | South Carolina | 45045 | 12589 | 267 |
510967 | 510967 | 2020-09-07 | Greenville | South Carolina | 45045 | 12650 | 270 |
514200 | 514200 | 2020-09-08 | Greenville | South Carolina | 45045 | 12692 | 270 |
517435 | 517435 | 2020-09-09 | Greenville | South Carolina | 45045 | 12721 | 275 |
520671 | 520671 | 2020-09-10 | Greenville | South Carolina | 45045 | 12727 | 276 |
523907 | 523907 | 2020-09-11 | Greenville | South Carolina | 45045 | 13016 | 277 |
527143 | 527143 | 2020-09-12 | Greenville | South Carolina | 45045 | 13115 | 279 |
530380 | 530380 | 2020-09-13 | Greenville | South Carolina | 45045 | 13231 | 281 |
533615 | 533615 | 2020-09-14 | Greenville | South Carolina | 45045 | 13328 | 283 |
536851 | 536851 | 2020-09-15 | Greenville | South Carolina | 45045 | 13398 | 285 |
540088 | 540088 | 2020-09-16 | Greenville | South Carolina | 45045 | 13449 | 286 |
543324 | 543324 | 2020-09-17 | Greenville | South Carolina | 45045 | 13558 | 285 |
546561 | 546561 | 2020-09-18 | Greenville | South Carolina | 45045 | 13634 | 287 |
549800 | 549800 | 2020-09-19 | Greenville | South Carolina | 45045 | 13710 | 288 |
553039 | 553039 | 2020-09-20 | Greenville | South Carolina | 45045 | 13751 | 289 |
556276 | 556276 | 2020-09-21 | Greenville | South Carolina | 45045 | 13786 | 292 |
559513 | 559513 | 2020-09-22 | Greenville | South Carolina | 45045 | 13859 | 295 |
562750 | 562750 | 2020-09-23 | Greenville | South Carolina | 45045 | 13957 | 298 |
565991 | 565991 | 2020-09-24 | Greenville | South Carolina | 45045 | 14076 | 299 |
569232 | 569232 | 2020-09-25 | Greenville | South Carolina | 45045 | 14203 | 300 |
572474 | 572474 | 2020-09-26 | Greenville | South Carolina | 45045 | 14318 | 299 |
575718 | 575718 | 2020-09-27 | Greenville | South Carolina | 45045 | 14356 | 299 |
578959 | 578959 | 2020-09-28 | Greenville | South Carolina | 45045 | 14423 | 300 |
582199 | 582199 | 2020-09-29 | Greenville | South Carolina | 45045 | 14537 | 305 |
585439 | 585439 | 2020-09-30 | Greenville | South Carolina | 45045 | 14550 | 306 |
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);