ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Guilford" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536359 | 536359 | 2020-09-15 | Guilford | North Carolina | 37081 | 7790 | 176 |
533123 | 533123 | 2020-09-14 | Guilford | North Carolina | 37081 | 7741 | 174 |
529888 | 529888 | 2020-09-13 | Guilford | North Carolina | 37081 | 7673 | 174 |
526651 | 526651 | 2020-09-12 | Guilford | North Carolina | 37081 | 7607 | 174 |
523415 | 523415 | 2020-09-11 | Guilford | North Carolina | 37081 | 7529 | 174 |
520179 | 520179 | 2020-09-10 | Guilford | North Carolina | 37081 | 7468 | 174 |
516943 | 516943 | 2020-09-09 | Guilford | North Carolina | 37081 | 7409 | 174 |
513708 | 513708 | 2020-09-08 | Guilford | North Carolina | 37081 | 7367 | 171 |
510475 | 510475 | 2020-09-07 | Guilford | North Carolina | 37081 | 7322 | 171 |
507242 | 507242 | 2020-09-06 | Guilford | North Carolina | 37081 | 7281 | 171 |
504010 | 504010 | 2020-09-05 | Guilford | North Carolina | 37081 | 7241 | 171 |
500776 | 500776 | 2020-09-04 | Guilford | North Carolina | 37081 | 7170 | 171 |
497542 | 497542 | 2020-09-03 | Guilford | North Carolina | 37081 | 7076 | 170 |
494309 | 494309 | 2020-09-02 | Guilford | North Carolina | 37081 | 7013 | 170 |
491075 | 491075 | 2020-09-01 | Guilford | North Carolina | 37081 | 6967 | 170 |
487842 | 487842 | 2020-08-31 | Guilford | North Carolina | 37081 | 6861 | 170 |
484609 | 484609 | 2020-08-30 | Guilford | North Carolina | 37081 | 6810 | 170 |
481374 | 481374 | 2020-08-29 | Guilford | North Carolina | 37081 | 6771 | 170 |
478141 | 478141 | 2020-08-28 | Guilford | North Carolina | 37081 | 6636 | 170 |
474908 | 474908 | 2020-08-27 | Guilford | North Carolina | 37081 | 6572 | 168 |
471674 | 471674 | 2020-08-26 | Guilford | North Carolina | 37081 | 6518 | 166 |
468442 | 468442 | 2020-08-25 | Guilford | North Carolina | 37081 | 6479 | 163 |
465214 | 465214 | 2020-08-24 | Guilford | North Carolina | 37081 | 6427 | 163 |
461985 | 461985 | 2020-08-23 | Guilford | North Carolina | 37081 | 6377 | 163 |
458757 | 458757 | 2020-08-22 | Guilford | North Carolina | 37081 | 6314 | 163 |
455529 | 455529 | 2020-08-21 | Guilford | North Carolina | 37081 | 6257 | 163 |
452301 | 452301 | 2020-08-20 | Guilford | North Carolina | 37081 | 6165 | 160 |
449073 | 449073 | 2020-08-19 | Guilford | North Carolina | 37081 | 6069 | 160 |
445845 | 445845 | 2020-08-18 | Guilford | North Carolina | 37081 | 6025 | 160 |
442619 | 442619 | 2020-08-17 | Guilford | North Carolina | 37081 | 5974 | 158 |
439392 | 439392 | 2020-08-16 | Guilford | North Carolina | 37081 | 5959 | 158 |
436167 | 436167 | 2020-08-15 | Guilford | North Carolina | 37081 | 5911 | 158 |
432941 | 432941 | 2020-08-14 | Guilford | North Carolina | 37081 | 5858 | 158 |
429715 | 429715 | 2020-08-13 | Guilford | North Carolina | 37081 | 5826 | 158 |
426490 | 426490 | 2020-08-12 | Guilford | North Carolina | 37081 | 5753 | 156 |
423267 | 423267 | 2020-08-11 | Guilford | North Carolina | 37081 | 5704 | 156 |
420044 | 420044 | 2020-08-10 | Guilford | North Carolina | 37081 | 5670 | 156 |
416824 | 416824 | 2020-08-09 | Guilford | North Carolina | 37081 | 5651 | 156 |
413603 | 413603 | 2020-08-08 | Guilford | North Carolina | 37081 | 5580 | 156 |
410383 | 410383 | 2020-08-07 | Guilford | North Carolina | 37081 | 5513 | 154 |
407163 | 407163 | 2020-08-06 | Guilford | North Carolina | 37081 | 5430 | 153 |
403944 | 403944 | 2020-08-05 | Guilford | North Carolina | 37081 | 5335 | 153 |
400726 | 400726 | 2020-08-04 | Guilford | North Carolina | 37081 | 5310 | 150 |
397511 | 397511 | 2020-08-03 | Guilford | North Carolina | 37081 | 5254 | 147 |
394294 | 394294 | 2020-08-02 | Guilford | North Carolina | 37081 | 5209 | 147 |
391078 | 391078 | 2020-08-01 | Guilford | North Carolina | 37081 | 5167 | 147 |
387861 | 387861 | 2020-07-31 | Guilford | North Carolina | 37081 | 5093 | 142 |
384644 | 384644 | 2020-07-30 | Guilford | North Carolina | 37081 | 5042 | 142 |
381426 | 381426 | 2020-07-29 | Guilford | North Carolina | 37081 | 4932 | 140 |
378209 | 378209 | 2020-07-28 | Guilford | North Carolina | 37081 | 4862 | 139 |
374993 | 374993 | 2020-07-27 | Guilford | North Carolina | 37081 | 4789 | 139 |
371781 | 371781 | 2020-07-26 | Guilford | North Carolina | 37081 | 4691 | 139 |
368569 | 368569 | 2020-07-25 | Guilford | North Carolina | 37081 | 4651 | 139 |
365360 | 365360 | 2020-07-24 | Guilford | North Carolina | 37081 | 4599 | 136 |
362154 | 362154 | 2020-07-23 | Guilford | North Carolina | 37081 | 4486 | 135 |
358948 | 358948 | 2020-07-22 | Guilford | North Carolina | 37081 | 4412 | 135 |
355744 | 355744 | 2020-07-21 | Guilford | North Carolina | 37081 | 4314 | 134 |
352541 | 352541 | 2020-07-20 | Guilford | North Carolina | 37081 | 4198 | 133 |
349338 | 349338 | 2020-07-19 | Guilford | North Carolina | 37081 | 4127 | 133 |
346137 | 346137 | 2020-07-18 | Guilford | North Carolina | 37081 | 4061 | 133 |
342938 | 342938 | 2020-07-17 | Guilford | North Carolina | 37081 | 3949 | 133 |
339740 | 339740 | 2020-07-16 | Guilford | North Carolina | 37081 | 3877 | 131 |
336544 | 336544 | 2020-07-15 | Guilford | North Carolina | 37081 | 3840 | 129 |
333350 | 333350 | 2020-07-14 | Guilford | North Carolina | 37081 | 3760 | 128 |
330160 | 330160 | 2020-07-13 | Guilford | North Carolina | 37081 | 3682 | 125 |
326973 | 326973 | 2020-07-12 | Guilford | North Carolina | 37081 | 3604 | 123 |
323789 | 323789 | 2020-07-11 | Guilford | North Carolina | 37081 | 3495 | 125 |
320609 | 320609 | 2020-07-10 | Guilford | North Carolina | 37081 | 3440 | 123 |
317432 | 317432 | 2020-07-09 | Guilford | North Carolina | 37081 | 3361 | 121 |
314258 | 314258 | 2020-07-08 | Guilford | North Carolina | 37081 | 3275 | 119 |
311087 | 311087 | 2020-07-07 | Guilford | North Carolina | 37081 | 3208 | 119 |
307919 | 307919 | 2020-07-06 | Guilford | North Carolina | 37081 | 3149 | 118 |
304752 | 304752 | 2020-07-05 | Guilford | North Carolina | 37081 | 3094 | 117 |
301589 | 301589 | 2020-07-04 | Guilford | North Carolina | 37081 | 3055 | 117 |
298426 | 298426 | 2020-07-03 | Guilford | North Carolina | 37081 | 3000 | 118 |
295266 | 295266 | 2020-07-02 | Guilford | North Carolina | 37081 | 2946 | 117 |
292111 | 292111 | 2020-07-01 | Guilford | North Carolina | 37081 | 2891 | 115 |
288959 | 288959 | 2020-06-30 | Guilford | North Carolina | 37081 | 2812 | 114 |
285809 | 285809 | 2020-06-29 | Guilford | North Carolina | 37081 | 2775 | 112 |
282664 | 282664 | 2020-06-28 | Guilford | North Carolina | 37081 | 2743 | 112 |
279518 | 279518 | 2020-06-27 | Guilford | North Carolina | 37081 | 2690 | 112 |
276370 | 276370 | 2020-06-26 | Guilford | North Carolina | 37081 | 2645 | 112 |
273224 | 273224 | 2020-06-25 | Guilford | North Carolina | 37081 | 2586 | 111 |
270085 | 270085 | 2020-06-24 | Guilford | North Carolina | 37081 | 2527 | 110 |
266951 | 266951 | 2020-06-23 | Guilford | North Carolina | 37081 | 2482 | 106 |
263823 | 263823 | 2020-06-22 | Guilford | North Carolina | 37081 | 2434 | 106 |
260695 | 260695 | 2020-06-21 | Guilford | North Carolina | 37081 | 2402 | 106 |
257568 | 257568 | 2020-06-20 | Guilford | North Carolina | 37081 | 2352 | 106 |
254445 | 254445 | 2020-06-19 | Guilford | North Carolina | 37081 | 2320 | 105 |
251330 | 251330 | 2020-06-18 | Guilford | North Carolina | 37081 | 2244 | 101 |
248215 | 248215 | 2020-06-17 | Guilford | North Carolina | 37081 | 2194 | 101 |
245102 | 245102 | 2020-06-16 | Guilford | North Carolina | 37081 | 2148 | 99 |
241990 | 241990 | 2020-06-15 | Guilford | North Carolina | 37081 | 2061 | 95 |
238881 | 238881 | 2020-06-14 | Guilford | North Carolina | 37081 | 2032 | 94 |
235773 | 235773 | 2020-06-13 | Guilford | North Carolina | 37081 | 1983 | 94 |
232668 | 232668 | 2020-06-12 | Guilford | North Carolina | 37081 | 1941 | 94 |
229563 | 229563 | 2020-06-11 | Guilford | North Carolina | 37081 | 1891 | 93 |
226459 | 226459 | 2020-06-10 | Guilford | North Carolina | 37081 | 1853 | 91 |
223359 | 223359 | 2020-06-09 | Guilford | North Carolina | 37081 | 1779 | 87 |
220265 | 220265 | 2020-06-08 | Guilford | North Carolina | 37081 | 1671 | 81 |
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);