ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 37085 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 |
---|---|---|---|---|---|---|---|
536361 | 536361 | 2020-09-15 | Harnett | North Carolina | 37085 | 1887 | 49 |
533125 | 533125 | 2020-09-14 | Harnett | North Carolina | 37085 | 1875 | 49 |
529890 | 529890 | 2020-09-13 | Harnett | North Carolina | 37085 | 1861 | 49 |
526653 | 526653 | 2020-09-12 | Harnett | North Carolina | 37085 | 1847 | 49 |
523417 | 523417 | 2020-09-11 | Harnett | North Carolina | 37085 | 1829 | 47 |
520181 | 520181 | 2020-09-10 | Harnett | North Carolina | 37085 | 1812 | 47 |
516945 | 516945 | 2020-09-09 | Harnett | North Carolina | 37085 | 1792 | 46 |
513710 | 513710 | 2020-09-08 | Harnett | North Carolina | 37085 | 1784 | 46 |
510477 | 510477 | 2020-09-07 | Harnett | North Carolina | 37085 | 1774 | 46 |
507244 | 507244 | 2020-09-06 | Harnett | North Carolina | 37085 | 1770 | 46 |
504012 | 504012 | 2020-09-05 | Harnett | North Carolina | 37085 | 1748 | 46 |
500778 | 500778 | 2020-09-04 | Harnett | North Carolina | 37085 | 1736 | 46 |
497544 | 497544 | 2020-09-03 | Harnett | North Carolina | 37085 | 1705 | 46 |
494311 | 494311 | 2020-09-02 | Harnett | North Carolina | 37085 | 1694 | 46 |
491077 | 491077 | 2020-09-01 | Harnett | North Carolina | 37085 | 1665 | 46 |
487844 | 487844 | 2020-08-31 | Harnett | North Carolina | 37085 | 1625 | 46 |
484611 | 484611 | 2020-08-30 | Harnett | North Carolina | 37085 | 1606 | 46 |
481376 | 481376 | 2020-08-29 | Harnett | North Carolina | 37085 | 1595 | 46 |
478143 | 478143 | 2020-08-28 | Harnett | North Carolina | 37085 | 1578 | 45 |
474910 | 474910 | 2020-08-27 | Harnett | North Carolina | 37085 | 1566 | 45 |
471676 | 471676 | 2020-08-26 | Harnett | North Carolina | 37085 | 1531 | 45 |
468444 | 468444 | 2020-08-25 | Harnett | North Carolina | 37085 | 1521 | 45 |
465216 | 465216 | 2020-08-24 | Harnett | North Carolina | 37085 | 1509 | 43 |
461987 | 461987 | 2020-08-23 | Harnett | North Carolina | 37085 | 1495 | 43 |
458759 | 458759 | 2020-08-22 | Harnett | North Carolina | 37085 | 1488 | 43 |
455531 | 455531 | 2020-08-21 | Harnett | North Carolina | 37085 | 1470 | 42 |
452303 | 452303 | 2020-08-20 | Harnett | North Carolina | 37085 | 1463 | 41 |
449075 | 449075 | 2020-08-19 | Harnett | North Carolina | 37085 | 1447 | 41 |
445847 | 445847 | 2020-08-18 | Harnett | North Carolina | 37085 | 1432 | 41 |
442621 | 442621 | 2020-08-17 | Harnett | North Carolina | 37085 | 1414 | 40 |
439394 | 439394 | 2020-08-16 | Harnett | North Carolina | 37085 | 1412 | 40 |
436169 | 436169 | 2020-08-15 | Harnett | North Carolina | 37085 | 1398 | 40 |
432943 | 432943 | 2020-08-14 | Harnett | North Carolina | 37085 | 1367 | 40 |
429717 | 429717 | 2020-08-13 | Harnett | North Carolina | 37085 | 1357 | 40 |
426492 | 426492 | 2020-08-12 | Harnett | North Carolina | 37085 | 1337 | 40 |
423269 | 423269 | 2020-08-11 | Harnett | North Carolina | 37085 | 1318 | 39 |
420046 | 420046 | 2020-08-10 | Harnett | North Carolina | 37085 | 1303 | 39 |
416826 | 416826 | 2020-08-09 | Harnett | North Carolina | 37085 | 1288 | 39 |
413605 | 413605 | 2020-08-08 | Harnett | North Carolina | 37085 | 1260 | 39 |
410385 | 410385 | 2020-08-07 | Harnett | North Carolina | 37085 | 1243 | 39 |
407165 | 407165 | 2020-08-06 | Harnett | North Carolina | 37085 | 1219 | 39 |
403946 | 403946 | 2020-08-05 | Harnett | North Carolina | 37085 | 1189 | 38 |
400728 | 400728 | 2020-08-04 | Harnett | North Carolina | 37085 | 1178 | 36 |
397513 | 397513 | 2020-08-03 | Harnett | North Carolina | 37085 | 1158 | 36 |
394296 | 394296 | 2020-08-02 | Harnett | North Carolina | 37085 | 1141 | 36 |
391080 | 391080 | 2020-08-01 | Harnett | North Carolina | 37085 | 1123 | 36 |
387863 | 387863 | 2020-07-31 | Harnett | North Carolina | 37085 | 1094 | 36 |
384646 | 384646 | 2020-07-30 | Harnett | North Carolina | 37085 | 1074 | 36 |
381428 | 381428 | 2020-07-29 | Harnett | North Carolina | 37085 | 1058 | 36 |
378211 | 378211 | 2020-07-28 | Harnett | North Carolina | 37085 | 1045 | 36 |
374995 | 374995 | 2020-07-27 | Harnett | North Carolina | 37085 | 1022 | 35 |
371783 | 371783 | 2020-07-26 | Harnett | North Carolina | 37085 | 1003 | 35 |
368571 | 368571 | 2020-07-25 | Harnett | North Carolina | 37085 | 987 | 35 |
365362 | 365362 | 2020-07-24 | Harnett | North Carolina | 37085 | 974 | 35 |
362156 | 362156 | 2020-07-23 | Harnett | North Carolina | 37085 | 953 | 34 |
358950 | 358950 | 2020-07-22 | Harnett | North Carolina | 37085 | 932 | 34 |
355746 | 355746 | 2020-07-21 | Harnett | North Carolina | 37085 | 902 | 33 |
352543 | 352543 | 2020-07-20 | Harnett | North Carolina | 37085 | 888 | 32 |
349340 | 349340 | 2020-07-19 | Harnett | North Carolina | 37085 | 880 | 32 |
346139 | 346139 | 2020-07-18 | Harnett | North Carolina | 37085 | 871 | 32 |
342940 | 342940 | 2020-07-17 | Harnett | North Carolina | 37085 | 844 | 32 |
339742 | 339742 | 2020-07-16 | Harnett | North Carolina | 37085 | 827 | 32 |
336546 | 336546 | 2020-07-15 | Harnett | North Carolina | 37085 | 815 | 32 |
333352 | 333352 | 2020-07-14 | Harnett | North Carolina | 37085 | 804 | 32 |
330162 | 330162 | 2020-07-13 | Harnett | North Carolina | 37085 | 793 | 32 |
326975 | 326975 | 2020-07-12 | Harnett | North Carolina | 37085 | 784 | 32 |
323791 | 323791 | 2020-07-11 | Harnett | North Carolina | 37085 | 771 | 32 |
320611 | 320611 | 2020-07-10 | Harnett | North Carolina | 37085 | 757 | 31 |
317434 | 317434 | 2020-07-09 | Harnett | North Carolina | 37085 | 744 | 30 |
314260 | 314260 | 2020-07-08 | Harnett | North Carolina | 37085 | 721 | 30 |
311089 | 311089 | 2020-07-07 | Harnett | North Carolina | 37085 | 712 | 30 |
307921 | 307921 | 2020-07-06 | Harnett | North Carolina | 37085 | 705 | 30 |
304754 | 304754 | 2020-07-05 | Harnett | North Carolina | 37085 | 698 | 30 |
301591 | 301591 | 2020-07-04 | Harnett | North Carolina | 37085 | 692 | 30 |
298428 | 298428 | 2020-07-03 | Harnett | North Carolina | 37085 | 682 | 30 |
295268 | 295268 | 2020-07-02 | Harnett | North Carolina | 37085 | 667 | 30 |
292113 | 292113 | 2020-07-01 | Harnett | North Carolina | 37085 | 648 | 30 |
288961 | 288961 | 2020-06-30 | Harnett | North Carolina | 37085 | 630 | 30 |
285811 | 285811 | 2020-06-29 | Harnett | North Carolina | 37085 | 621 | 30 |
282666 | 282666 | 2020-06-28 | Harnett | North Carolina | 37085 | 615 | 30 |
279520 | 279520 | 2020-06-27 | Harnett | North Carolina | 37085 | 598 | 30 |
276372 | 276372 | 2020-06-26 | Harnett | North Carolina | 37085 | 581 | 30 |
273226 | 273226 | 2020-06-25 | Harnett | North Carolina | 37085 | 553 | 30 |
270087 | 270087 | 2020-06-24 | Harnett | North Carolina | 37085 | 536 | 30 |
266953 | 266953 | 2020-06-23 | Harnett | North Carolina | 37085 | 515 | 30 |
263825 | 263825 | 2020-06-22 | Harnett | North Carolina | 37085 | 504 | 30 |
260697 | 260697 | 2020-06-21 | Harnett | North Carolina | 37085 | 499 | 30 |
257570 | 257570 | 2020-06-20 | Harnett | North Carolina | 37085 | 486 | 30 |
254447 | 254447 | 2020-06-19 | Harnett | North Carolina | 37085 | 457 | 30 |
251332 | 251332 | 2020-06-18 | Harnett | North Carolina | 37085 | 435 | 30 |
248217 | 248217 | 2020-06-17 | Harnett | North Carolina | 37085 | 422 | 30 |
245104 | 245104 | 2020-06-16 | Harnett | North Carolina | 37085 | 417 | 30 |
241992 | 241992 | 2020-06-15 | Harnett | North Carolina | 37085 | 411 | 30 |
238883 | 238883 | 2020-06-14 | Harnett | North Carolina | 37085 | 408 | 30 |
235775 | 235775 | 2020-06-13 | Harnett | North Carolina | 37085 | 391 | 30 |
232670 | 232670 | 2020-06-12 | Harnett | North Carolina | 37085 | 381 | 30 |
229565 | 229565 | 2020-06-11 | Harnett | North Carolina | 37085 | 363 | 30 |
226461 | 226461 | 2020-06-10 | Harnett | North Carolina | 37085 | 352 | 30 |
223361 | 223361 | 2020-06-09 | Harnett | North Carolina | 37085 | 345 | 30 |
220267 | 220267 | 2020-06-08 | Harnett | North Carolina | 37085 | 337 | 28 |
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);