ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Guilford" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
276370 | 276370 | 2020-06-26 | Guilford | North Carolina | 37081 | 2645 | 112 |
279518 | 279518 | 2020-06-27 | Guilford | North Carolina | 37081 | 2690 | 112 |
282664 | 282664 | 2020-06-28 | Guilford | North Carolina | 37081 | 2743 | 112 |
285809 | 285809 | 2020-06-29 | Guilford | North Carolina | 37081 | 2775 | 112 |
288959 | 288959 | 2020-06-30 | Guilford | North Carolina | 37081 | 2812 | 114 |
292111 | 292111 | 2020-07-01 | Guilford | North Carolina | 37081 | 2891 | 115 |
295266 | 295266 | 2020-07-02 | Guilford | North Carolina | 37081 | 2946 | 117 |
298426 | 298426 | 2020-07-03 | Guilford | North Carolina | 37081 | 3000 | 118 |
301589 | 301589 | 2020-07-04 | Guilford | North Carolina | 37081 | 3055 | 117 |
304752 | 304752 | 2020-07-05 | Guilford | North Carolina | 37081 | 3094 | 117 |
307919 | 307919 | 2020-07-06 | Guilford | North Carolina | 37081 | 3149 | 118 |
311087 | 311087 | 2020-07-07 | Guilford | North Carolina | 37081 | 3208 | 119 |
314258 | 314258 | 2020-07-08 | Guilford | North Carolina | 37081 | 3275 | 119 |
317432 | 317432 | 2020-07-09 | Guilford | North Carolina | 37081 | 3361 | 121 |
320609 | 320609 | 2020-07-10 | Guilford | North Carolina | 37081 | 3440 | 123 |
323789 | 323789 | 2020-07-11 | Guilford | North Carolina | 37081 | 3495 | 125 |
326973 | 326973 | 2020-07-12 | Guilford | North Carolina | 37081 | 3604 | 123 |
330160 | 330160 | 2020-07-13 | Guilford | North Carolina | 37081 | 3682 | 125 |
333350 | 333350 | 2020-07-14 | Guilford | North Carolina | 37081 | 3760 | 128 |
336544 | 336544 | 2020-07-15 | Guilford | North Carolina | 37081 | 3840 | 129 |
339740 | 339740 | 2020-07-16 | Guilford | North Carolina | 37081 | 3877 | 131 |
342938 | 342938 | 2020-07-17 | Guilford | North Carolina | 37081 | 3949 | 133 |
346137 | 346137 | 2020-07-18 | Guilford | North Carolina | 37081 | 4061 | 133 |
349338 | 349338 | 2020-07-19 | Guilford | North Carolina | 37081 | 4127 | 133 |
352541 | 352541 | 2020-07-20 | Guilford | North Carolina | 37081 | 4198 | 133 |
355744 | 355744 | 2020-07-21 | Guilford | North Carolina | 37081 | 4314 | 134 |
358948 | 358948 | 2020-07-22 | Guilford | North Carolina | 37081 | 4412 | 135 |
362154 | 362154 | 2020-07-23 | Guilford | North Carolina | 37081 | 4486 | 135 |
365360 | 365360 | 2020-07-24 | Guilford | North Carolina | 37081 | 4599 | 136 |
368569 | 368569 | 2020-07-25 | Guilford | North Carolina | 37081 | 4651 | 139 |
371781 | 371781 | 2020-07-26 | Guilford | North Carolina | 37081 | 4691 | 139 |
374993 | 374993 | 2020-07-27 | Guilford | North Carolina | 37081 | 4789 | 139 |
378209 | 378209 | 2020-07-28 | Guilford | North Carolina | 37081 | 4862 | 139 |
381426 | 381426 | 2020-07-29 | Guilford | North Carolina | 37081 | 4932 | 140 |
384644 | 384644 | 2020-07-30 | Guilford | North Carolina | 37081 | 5042 | 142 |
387861 | 387861 | 2020-07-31 | Guilford | North Carolina | 37081 | 5093 | 142 |
391078 | 391078 | 2020-08-01 | Guilford | North Carolina | 37081 | 5167 | 147 |
394294 | 394294 | 2020-08-02 | Guilford | North Carolina | 37081 | 5209 | 147 |
397511 | 397511 | 2020-08-03 | Guilford | North Carolina | 37081 | 5254 | 147 |
400726 | 400726 | 2020-08-04 | Guilford | North Carolina | 37081 | 5310 | 150 |
403944 | 403944 | 2020-08-05 | Guilford | North Carolina | 37081 | 5335 | 153 |
407163 | 407163 | 2020-08-06 | Guilford | North Carolina | 37081 | 5430 | 153 |
410383 | 410383 | 2020-08-07 | Guilford | North Carolina | 37081 | 5513 | 154 |
413603 | 413603 | 2020-08-08 | Guilford | North Carolina | 37081 | 5580 | 156 |
416824 | 416824 | 2020-08-09 | Guilford | North Carolina | 37081 | 5651 | 156 |
420044 | 420044 | 2020-08-10 | Guilford | North Carolina | 37081 | 5670 | 156 |
423267 | 423267 | 2020-08-11 | Guilford | North Carolina | 37081 | 5704 | 156 |
426490 | 426490 | 2020-08-12 | Guilford | North Carolina | 37081 | 5753 | 156 |
429715 | 429715 | 2020-08-13 | Guilford | North Carolina | 37081 | 5826 | 158 |
432941 | 432941 | 2020-08-14 | Guilford | North Carolina | 37081 | 5858 | 158 |
436167 | 436167 | 2020-08-15 | Guilford | North Carolina | 37081 | 5911 | 158 |
439392 | 439392 | 2020-08-16 | Guilford | North Carolina | 37081 | 5959 | 158 |
442619 | 442619 | 2020-08-17 | Guilford | North Carolina | 37081 | 5974 | 158 |
445845 | 445845 | 2020-08-18 | Guilford | North Carolina | 37081 | 6025 | 160 |
449073 | 449073 | 2020-08-19 | Guilford | North Carolina | 37081 | 6069 | 160 |
452301 | 452301 | 2020-08-20 | Guilford | North Carolina | 37081 | 6165 | 160 |
455529 | 455529 | 2020-08-21 | Guilford | North Carolina | 37081 | 6257 | 163 |
458757 | 458757 | 2020-08-22 | Guilford | North Carolina | 37081 | 6314 | 163 |
461985 | 461985 | 2020-08-23 | Guilford | North Carolina | 37081 | 6377 | 163 |
465214 | 465214 | 2020-08-24 | Guilford | North Carolina | 37081 | 6427 | 163 |
468442 | 468442 | 2020-08-25 | Guilford | North Carolina | 37081 | 6479 | 163 |
471674 | 471674 | 2020-08-26 | Guilford | North Carolina | 37081 | 6518 | 166 |
474908 | 474908 | 2020-08-27 | Guilford | North Carolina | 37081 | 6572 | 168 |
478141 | 478141 | 2020-08-28 | Guilford | North Carolina | 37081 | 6636 | 170 |
481374 | 481374 | 2020-08-29 | Guilford | North Carolina | 37081 | 6771 | 170 |
484609 | 484609 | 2020-08-30 | Guilford | North Carolina | 37081 | 6810 | 170 |
487842 | 487842 | 2020-08-31 | Guilford | North Carolina | 37081 | 6861 | 170 |
491075 | 491075 | 2020-09-01 | Guilford | North Carolina | 37081 | 6967 | 170 |
494309 | 494309 | 2020-09-02 | Guilford | North Carolina | 37081 | 7013 | 170 |
497542 | 497542 | 2020-09-03 | Guilford | North Carolina | 37081 | 7076 | 170 |
500776 | 500776 | 2020-09-04 | Guilford | North Carolina | 37081 | 7170 | 171 |
504010 | 504010 | 2020-09-05 | Guilford | North Carolina | 37081 | 7241 | 171 |
507242 | 507242 | 2020-09-06 | Guilford | North Carolina | 37081 | 7281 | 171 |
510475 | 510475 | 2020-09-07 | Guilford | North Carolina | 37081 | 7322 | 171 |
513708 | 513708 | 2020-09-08 | Guilford | North Carolina | 37081 | 7367 | 171 |
516943 | 516943 | 2020-09-09 | Guilford | North Carolina | 37081 | 7409 | 174 |
520179 | 520179 | 2020-09-10 | Guilford | North Carolina | 37081 | 7468 | 174 |
523415 | 523415 | 2020-09-11 | Guilford | North Carolina | 37081 | 7529 | 174 |
526651 | 526651 | 2020-09-12 | Guilford | North Carolina | 37081 | 7607 | 174 |
529888 | 529888 | 2020-09-13 | Guilford | North Carolina | 37081 | 7673 | 174 |
533123 | 533123 | 2020-09-14 | Guilford | North Carolina | 37081 | 7741 | 174 |
536359 | 536359 | 2020-09-15 | Guilford | North Carolina | 37081 | 7790 | 176 |
539596 | 539596 | 2020-09-16 | Guilford | North Carolina | 37081 | 7898 | 176 |
542832 | 542832 | 2020-09-17 | Guilford | North Carolina | 37081 | 7937 | 176 |
546069 | 546069 | 2020-09-18 | Guilford | North Carolina | 37081 | 8000 | 176 |
549308 | 549308 | 2020-09-19 | Guilford | North Carolina | 37081 | 8064 | 176 |
552547 | 552547 | 2020-09-20 | Guilford | North Carolina | 37081 | 8124 | 176 |
555784 | 555784 | 2020-09-21 | Guilford | North Carolina | 37081 | 8194 | 176 |
559021 | 559021 | 2020-09-22 | Guilford | North Carolina | 37081 | 8259 | 176 |
562258 | 562258 | 2020-09-23 | Guilford | North Carolina | 37081 | 8339 | 179 |
565499 | 565499 | 2020-09-24 | Guilford | North Carolina | 37081 | 8392 | 179 |
568740 | 568740 | 2020-09-25 | Guilford | North Carolina | 37081 | 8463 | 180 |
571982 | 571982 | 2020-09-26 | Guilford | North Carolina | 37081 | 8541 | 180 |
575226 | 575226 | 2020-09-27 | Guilford | North Carolina | 37081 | 8597 | 180 |
578467 | 578467 | 2020-09-28 | Guilford | North Carolina | 37081 | 8666 | 180 |
581707 | 581707 | 2020-09-29 | Guilford | North Carolina | 37081 | 8689 | 181 |
584948 | 584948 | 2020-09-30 | Guilford | North Carolina | 37081 | 8736 | 185 |
588188 | 588188 | 2020-10-01 | Guilford | North Carolina | 37081 | 8859 | 185 |
591429 | 591429 | 2020-10-02 | Guilford | North Carolina | 37081 | 8919 | 187 |
594670 | 594670 | 2020-10-03 | Guilford | North Carolina | 37081 | 9038 | 187 |
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);