ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37057 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 |
---|---|---|---|---|---|---|---|
536347 | 536347 | 2020-09-15 | Davidson | North Carolina | 37057 | 2477 | 33 |
533111 | 533111 | 2020-09-14 | Davidson | North Carolina | 37057 | 2452 | 33 |
529876 | 529876 | 2020-09-13 | Davidson | North Carolina | 37057 | 2441 | 33 |
526639 | 526639 | 2020-09-12 | Davidson | North Carolina | 37057 | 2416 | 32 |
523403 | 523403 | 2020-09-11 | Davidson | North Carolina | 37057 | 2389 | 32 |
520167 | 520167 | 2020-09-10 | Davidson | North Carolina | 37057 | 2357 | 32 |
516931 | 516931 | 2020-09-09 | Davidson | North Carolina | 37057 | 2341 | 32 |
513696 | 513696 | 2020-09-08 | Davidson | North Carolina | 37057 | 2327 | 32 |
510463 | 510463 | 2020-09-07 | Davidson | North Carolina | 37057 | 2312 | 32 |
507230 | 507230 | 2020-09-06 | Davidson | North Carolina | 37057 | 2298 | 32 |
503998 | 503998 | 2020-09-05 | Davidson | North Carolina | 37057 | 2277 | 32 |
500764 | 500764 | 2020-09-04 | Davidson | North Carolina | 37057 | 2259 | 32 |
497530 | 497530 | 2020-09-03 | Davidson | North Carolina | 37057 | 2236 | 32 |
494297 | 494297 | 2020-09-02 | Davidson | North Carolina | 37057 | 2220 | 32 |
491063 | 491063 | 2020-09-01 | Davidson | North Carolina | 37057 | 2203 | 32 |
487830 | 487830 | 2020-08-31 | Davidson | North Carolina | 37057 | 2171 | 32 |
484597 | 484597 | 2020-08-30 | Davidson | North Carolina | 37057 | 2159 | 32 |
481362 | 481362 | 2020-08-29 | Davidson | North Carolina | 37057 | 2145 | 32 |
478129 | 478129 | 2020-08-28 | Davidson | North Carolina | 37057 | 2128 | 32 |
474896 | 474896 | 2020-08-27 | Davidson | North Carolina | 37057 | 2106 | 32 |
471662 | 471662 | 2020-08-26 | Davidson | North Carolina | 37057 | 2080 | 32 |
468430 | 468430 | 2020-08-25 | Davidson | North Carolina | 37057 | 2060 | 32 |
465202 | 465202 | 2020-08-24 | Davidson | North Carolina | 37057 | 2040 | 31 |
461973 | 461973 | 2020-08-23 | Davidson | North Carolina | 37057 | 2023 | 31 |
458745 | 458745 | 2020-08-22 | Davidson | North Carolina | 37057 | 2002 | 31 |
455517 | 455517 | 2020-08-21 | Davidson | North Carolina | 37057 | 1992 | 31 |
452289 | 452289 | 2020-08-20 | Davidson | North Carolina | 37057 | 1965 | 31 |
449061 | 449061 | 2020-08-19 | Davidson | North Carolina | 37057 | 1933 | 30 |
445833 | 445833 | 2020-08-18 | Davidson | North Carolina | 37057 | 1913 | 26 |
442607 | 442607 | 2020-08-17 | Davidson | North Carolina | 37057 | 1886 | 23 |
439380 | 439380 | 2020-08-16 | Davidson | North Carolina | 37057 | 1879 | 23 |
436155 | 436155 | 2020-08-15 | Davidson | North Carolina | 37057 | 1864 | 23 |
432929 | 432929 | 2020-08-14 | Davidson | North Carolina | 37057 | 1849 | 22 |
429703 | 429703 | 2020-08-13 | Davidson | North Carolina | 37057 | 1836 | 22 |
426478 | 426478 | 2020-08-12 | Davidson | North Carolina | 37057 | 1817 | 18 |
423255 | 423255 | 2020-08-11 | Davidson | North Carolina | 37057 | 1797 | 18 |
420032 | 420032 | 2020-08-10 | Davidson | North Carolina | 37057 | 1793 | 18 |
416812 | 416812 | 2020-08-09 | Davidson | North Carolina | 37057 | 1781 | 18 |
413591 | 413591 | 2020-08-08 | Davidson | North Carolina | 37057 | 1758 | 18 |
410371 | 410371 | 2020-08-07 | Davidson | North Carolina | 37057 | 1730 | 18 |
407151 | 407151 | 2020-08-06 | Davidson | North Carolina | 37057 | 1709 | 18 |
403932 | 403932 | 2020-08-05 | Davidson | North Carolina | 37057 | 1690 | 18 |
400714 | 400714 | 2020-08-04 | Davidson | North Carolina | 37057 | 1675 | 18 |
397499 | 397499 | 2020-08-03 | Davidson | North Carolina | 37057 | 1653 | 18 |
394282 | 394282 | 2020-08-02 | Davidson | North Carolina | 37057 | 1643 | 17 |
391066 | 391066 | 2020-08-01 | Davidson | North Carolina | 37057 | 1635 | 17 |
387849 | 387849 | 2020-07-31 | Davidson | North Carolina | 37057 | 1620 | 17 |
384632 | 384632 | 2020-07-30 | Davidson | North Carolina | 37057 | 1606 | 17 |
381414 | 381414 | 2020-07-29 | Davidson | North Carolina | 37057 | 1578 | 16 |
378197 | 378197 | 2020-07-28 | Davidson | North Carolina | 37057 | 1553 | 16 |
374981 | 374981 | 2020-07-27 | Davidson | North Carolina | 37057 | 1537 | 16 |
371769 | 371769 | 2020-07-26 | Davidson | North Carolina | 37057 | 1527 | 16 |
368557 | 368557 | 2020-07-25 | Davidson | North Carolina | 37057 | 1510 | 16 |
365348 | 365348 | 2020-07-24 | Davidson | North Carolina | 37057 | 1496 | 16 |
362142 | 362142 | 2020-07-23 | Davidson | North Carolina | 37057 | 1477 | 16 |
358936 | 358936 | 2020-07-22 | Davidson | North Carolina | 37057 | 1457 | 16 |
355732 | 355732 | 2020-07-21 | Davidson | North Carolina | 37057 | 1447 | 16 |
352529 | 352529 | 2020-07-20 | Davidson | North Carolina | 37057 | 1421 | 16 |
349326 | 349326 | 2020-07-19 | Davidson | North Carolina | 37057 | 1414 | 16 |
346125 | 346125 | 2020-07-18 | Davidson | North Carolina | 37057 | 1392 | 16 |
342926 | 342926 | 2020-07-17 | Davidson | North Carolina | 37057 | 1351 | 16 |
339728 | 339728 | 2020-07-16 | Davidson | North Carolina | 37057 | 1320 | 16 |
336532 | 336532 | 2020-07-15 | Davidson | North Carolina | 37057 | 1296 | 16 |
333338 | 333338 | 2020-07-14 | Davidson | North Carolina | 37057 | 1277 | 16 |
330148 | 330148 | 2020-07-13 | Davidson | North Carolina | 37057 | 1263 | 15 |
326961 | 326961 | 2020-07-12 | Davidson | North Carolina | 37057 | 1247 | 15 |
323777 | 323777 | 2020-07-11 | Davidson | North Carolina | 37057 | 1228 | 15 |
320597 | 320597 | 2020-07-10 | Davidson | North Carolina | 37057 | 1210 | 15 |
317420 | 317420 | 2020-07-09 | Davidson | North Carolina | 37057 | 1175 | 15 |
314246 | 314246 | 2020-07-08 | Davidson | North Carolina | 37057 | 1134 | 15 |
311075 | 311075 | 2020-07-07 | Davidson | North Carolina | 37057 | 1114 | 15 |
307907 | 307907 | 2020-07-06 | Davidson | North Carolina | 37057 | 1102 | 15 |
304740 | 304740 | 2020-07-05 | Davidson | North Carolina | 37057 | 1072 | 15 |
301577 | 301577 | 2020-07-04 | Davidson | North Carolina | 37057 | 1056 | 15 |
298414 | 298414 | 2020-07-03 | Davidson | North Carolina | 37057 | 1035 | 15 |
295254 | 295254 | 2020-07-02 | Davidson | North Carolina | 37057 | 1012 | 15 |
292099 | 292099 | 2020-07-01 | Davidson | North Carolina | 37057 | 989 | 15 |
288947 | 288947 | 2020-06-30 | Davidson | North Carolina | 37057 | 946 | 15 |
285797 | 285797 | 2020-06-29 | Davidson | North Carolina | 37057 | 936 | 15 |
282652 | 282652 | 2020-06-28 | Davidson | North Carolina | 37057 | 925 | 15 |
279506 | 279506 | 2020-06-27 | Davidson | North Carolina | 37057 | 908 | 15 |
276358 | 276358 | 2020-06-26 | Davidson | North Carolina | 37057 | 868 | 15 |
273212 | 273212 | 2020-06-25 | Davidson | North Carolina | 37057 | 831 | 15 |
270073 | 270073 | 2020-06-24 | Davidson | North Carolina | 37057 | 797 | 15 |
266939 | 266939 | 2020-06-23 | Davidson | North Carolina | 37057 | 772 | 15 |
263811 | 263811 | 2020-06-22 | Davidson | North Carolina | 37057 | 759 | 15 |
260683 | 260683 | 2020-06-21 | Davidson | North Carolina | 37057 | 735 | 15 |
257556 | 257556 | 2020-06-20 | Davidson | North Carolina | 37057 | 729 | 15 |
254433 | 254433 | 2020-06-19 | Davidson | North Carolina | 37057 | 725 | 15 |
251318 | 251318 | 2020-06-18 | Davidson | North Carolina | 37057 | 691 | 15 |
248203 | 248203 | 2020-06-17 | Davidson | North Carolina | 37057 | 678 | 15 |
245090 | 245090 | 2020-06-16 | Davidson | North Carolina | 37057 | 664 | 15 |
241978 | 241978 | 2020-06-15 | Davidson | North Carolina | 37057 | 655 | 14 |
238869 | 238869 | 2020-06-14 | Davidson | North Carolina | 37057 | 643 | 13 |
235761 | 235761 | 2020-06-13 | Davidson | North Carolina | 37057 | 620 | 13 |
232656 | 232656 | 2020-06-12 | Davidson | North Carolina | 37057 | 589 | 12 |
229551 | 229551 | 2020-06-11 | Davidson | North Carolina | 37057 | 556 | 12 |
226447 | 226447 | 2020-06-10 | Davidson | North Carolina | 37057 | 544 | 12 |
223347 | 223347 | 2020-06-09 | Davidson | North Carolina | 37057 | 529 | 12 |
220253 | 220253 | 2020-06-08 | Davidson | North Carolina | 37057 | 520 | 13 |
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);