ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 37023 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 |
---|---|---|---|---|---|---|---|
536330 | 536330 | 2020-09-15 | Burke | North Carolina | 37023 | 1974 | 33 |
533094 | 533094 | 2020-09-14 | Burke | North Carolina | 37023 | 1967 | 33 |
529859 | 529859 | 2020-09-13 | Burke | North Carolina | 37023 | 1962 | 33 |
526622 | 526622 | 2020-09-12 | Burke | North Carolina | 37023 | 1959 | 33 |
523386 | 523386 | 2020-09-11 | Burke | North Carolina | 37023 | 1956 | 32 |
520150 | 520150 | 2020-09-10 | Burke | North Carolina | 37023 | 1934 | 32 |
516914 | 516914 | 2020-09-09 | Burke | North Carolina | 37023 | 1931 | 32 |
513679 | 513679 | 2020-09-08 | Burke | North Carolina | 37023 | 1928 | 31 |
510446 | 510446 | 2020-09-07 | Burke | North Carolina | 37023 | 1926 | 31 |
507213 | 507213 | 2020-09-06 | Burke | North Carolina | 37023 | 1900 | 31 |
503981 | 503981 | 2020-09-05 | Burke | North Carolina | 37023 | 1897 | 31 |
500747 | 500747 | 2020-09-04 | Burke | North Carolina | 37023 | 1891 | 30 |
497513 | 497513 | 2020-09-03 | Burke | North Carolina | 37023 | 1874 | 30 |
494280 | 494280 | 2020-09-02 | Burke | North Carolina | 37023 | 1864 | 30 |
491046 | 491046 | 2020-09-01 | Burke | North Carolina | 37023 | 1855 | 30 |
487813 | 487813 | 2020-08-31 | Burke | North Carolina | 37023 | 1850 | 30 |
484580 | 484580 | 2020-08-30 | Burke | North Carolina | 37023 | 1846 | 30 |
481345 | 481345 | 2020-08-29 | Burke | North Carolina | 37023 | 1840 | 30 |
478112 | 478112 | 2020-08-28 | Burke | North Carolina | 37023 | 1822 | 28 |
474879 | 474879 | 2020-08-27 | Burke | North Carolina | 37023 | 1816 | 28 |
471645 | 471645 | 2020-08-26 | Burke | North Carolina | 37023 | 1817 | 28 |
468413 | 468413 | 2020-08-25 | Burke | North Carolina | 37023 | 1804 | 27 |
465185 | 465185 | 2020-08-24 | Burke | North Carolina | 37023 | 1799 | 27 |
461956 | 461956 | 2020-08-23 | Burke | North Carolina | 37023 | 1792 | 27 |
458728 | 458728 | 2020-08-22 | Burke | North Carolina | 37023 | 1783 | 27 |
455500 | 455500 | 2020-08-21 | Burke | North Carolina | 37023 | 1775 | 27 |
452272 | 452272 | 2020-08-20 | Burke | North Carolina | 37023 | 1753 | 27 |
449044 | 449044 | 2020-08-19 | Burke | North Carolina | 37023 | 1731 | 27 |
445816 | 445816 | 2020-08-18 | Burke | North Carolina | 37023 | 1720 | 27 |
442590 | 442590 | 2020-08-17 | Burke | North Carolina | 37023 | 1716 | 27 |
439363 | 439363 | 2020-08-16 | Burke | North Carolina | 37023 | 1710 | 27 |
436138 | 436138 | 2020-08-15 | Burke | North Carolina | 37023 | 1702 | 27 |
432912 | 432912 | 2020-08-14 | Burke | North Carolina | 37023 | 1686 | 27 |
429686 | 429686 | 2020-08-13 | Burke | North Carolina | 37023 | 1679 | 27 |
426461 | 426461 | 2020-08-12 | Burke | North Carolina | 37023 | 1676 | 26 |
423238 | 423238 | 2020-08-11 | Burke | North Carolina | 37023 | 1677 | 26 |
420015 | 420015 | 2020-08-10 | Burke | North Carolina | 37023 | 1661 | 26 |
416795 | 416795 | 2020-08-09 | Burke | North Carolina | 37023 | 1655 | 26 |
413574 | 413574 | 2020-08-08 | Burke | North Carolina | 37023 | 1643 | 26 |
410354 | 410354 | 2020-08-07 | Burke | North Carolina | 37023 | 1633 | 26 |
407134 | 407134 | 2020-08-06 | Burke | North Carolina | 37023 | 1611 | 26 |
403915 | 403915 | 2020-08-05 | Burke | North Carolina | 37023 | 1596 | 26 |
400697 | 400697 | 2020-08-04 | Burke | North Carolina | 37023 | 1592 | 26 |
397482 | 397482 | 2020-08-03 | Burke | North Carolina | 37023 | 1562 | 26 |
394265 | 394265 | 2020-08-02 | Burke | North Carolina | 37023 | 1556 | 26 |
391049 | 391049 | 2020-08-01 | Burke | North Carolina | 37023 | 1550 | 26 |
387832 | 387832 | 2020-07-31 | Burke | North Carolina | 37023 | 1537 | 25 |
384615 | 384615 | 2020-07-30 | Burke | North Carolina | 37023 | 1514 | 25 |
381397 | 381397 | 2020-07-29 | Burke | North Carolina | 37023 | 1488 | 25 |
378180 | 378180 | 2020-07-28 | Burke | North Carolina | 37023 | 1460 | 24 |
374964 | 374964 | 2020-07-27 | Burke | North Carolina | 37023 | 1439 | 24 |
371752 | 371752 | 2020-07-26 | Burke | North Carolina | 37023 | 1424 | 24 |
368540 | 368540 | 2020-07-25 | Burke | North Carolina | 37023 | 1415 | 24 |
365331 | 365331 | 2020-07-24 | Burke | North Carolina | 37023 | 1402 | 24 |
362125 | 362125 | 2020-07-23 | Burke | North Carolina | 37023 | 1379 | 24 |
358919 | 358919 | 2020-07-22 | Burke | North Carolina | 37023 | 1360 | 24 |
355715 | 355715 | 2020-07-21 | Burke | North Carolina | 37023 | 1337 | 22 |
352512 | 352512 | 2020-07-20 | Burke | North Carolina | 37023 | 1325 | 22 |
349309 | 349309 | 2020-07-19 | Burke | North Carolina | 37023 | 1315 | 22 |
346108 | 346108 | 2020-07-18 | Burke | North Carolina | 37023 | 1302 | 22 |
342909 | 342909 | 2020-07-17 | Burke | North Carolina | 37023 | 1292 | 21 |
339711 | 339711 | 2020-07-16 | Burke | North Carolina | 37023 | 1279 | 21 |
336515 | 336515 | 2020-07-15 | Burke | North Carolina | 37023 | 1245 | 21 |
333321 | 333321 | 2020-07-14 | Burke | North Carolina | 37023 | 1238 | 21 |
330131 | 330131 | 2020-07-13 | Burke | North Carolina | 37023 | 1217 | 21 |
326944 | 326944 | 2020-07-12 | Burke | North Carolina | 37023 | 1206 | 21 |
323760 | 323760 | 2020-07-11 | Burke | North Carolina | 37023 | 1186 | 21 |
320580 | 320580 | 2020-07-10 | Burke | North Carolina | 37023 | 1161 | 20 |
317403 | 317403 | 2020-07-09 | Burke | North Carolina | 37023 | 1144 | 20 |
314229 | 314229 | 2020-07-08 | Burke | North Carolina | 37023 | 1134 | 20 |
311058 | 311058 | 2020-07-07 | Burke | North Carolina | 37023 | 1129 | 20 |
307890 | 307890 | 2020-07-06 | Burke | North Carolina | 37023 | 1110 | 20 |
304723 | 304723 | 2020-07-05 | Burke | North Carolina | 37023 | 1105 | 20 |
301560 | 301560 | 2020-07-04 | Burke | North Carolina | 37023 | 1099 | 20 |
298397 | 298397 | 2020-07-03 | Burke | North Carolina | 37023 | 1074 | 20 |
295237 | 295237 | 2020-07-02 | Burke | North Carolina | 37023 | 1057 | 20 |
292082 | 292082 | 2020-07-01 | Burke | North Carolina | 37023 | 1042 | 20 |
288930 | 288930 | 2020-06-30 | Burke | North Carolina | 37023 | 1033 | 20 |
285780 | 285780 | 2020-06-29 | Burke | North Carolina | 37023 | 1022 | 20 |
282635 | 282635 | 2020-06-28 | Burke | North Carolina | 37023 | 1016 | 20 |
279489 | 279489 | 2020-06-27 | Burke | North Carolina | 37023 | 1000 | 19 |
276341 | 276341 | 2020-06-26 | Burke | North Carolina | 37023 | 983 | 18 |
273195 | 273195 | 2020-06-25 | Burke | North Carolina | 37023 | 954 | 17 |
270056 | 270056 | 2020-06-24 | Burke | North Carolina | 37023 | 934 | 17 |
266922 | 266922 | 2020-06-23 | Burke | North Carolina | 37023 | 918 | 17 |
263794 | 263794 | 2020-06-22 | Burke | North Carolina | 37023 | 912 | 17 |
260666 | 260666 | 2020-06-21 | Burke | North Carolina | 37023 | 911 | 17 |
257539 | 257539 | 2020-06-20 | Burke | North Carolina | 37023 | 895 | 17 |
254416 | 254416 | 2020-06-19 | Burke | North Carolina | 37023 | 882 | 17 |
251301 | 251301 | 2020-06-18 | Burke | North Carolina | 37023 | 872 | 16 |
248186 | 248186 | 2020-06-17 | Burke | North Carolina | 37023 | 838 | 16 |
245073 | 245073 | 2020-06-16 | Burke | North Carolina | 37023 | 751 | 16 |
241961 | 241961 | 2020-06-15 | Burke | North Carolina | 37023 | 726 | 16 |
238852 | 238852 | 2020-06-14 | Burke | North Carolina | 37023 | 716 | 16 |
235744 | 235744 | 2020-06-13 | Burke | North Carolina | 37023 | 706 | 16 |
232639 | 232639 | 2020-06-12 | Burke | North Carolina | 37023 | 669 | 16 |
229534 | 229534 | 2020-06-11 | Burke | North Carolina | 37023 | 656 | 16 |
226430 | 226430 | 2020-06-10 | Burke | North Carolina | 37023 | 595 | 16 |
223330 | 223330 | 2020-06-09 | Burke | North Carolina | 37023 | 584 | 16 |
220236 | 220236 | 2020-06-08 | Burke | North Carolina | 37023 | 567 | 16 |
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);