ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37147 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 |
---|---|---|---|---|---|---|---|
536392 | 536392 | 2020-09-15 | Pitt | North Carolina | 37147 | 4345 | 25 |
533156 | 533156 | 2020-09-14 | Pitt | North Carolina | 37147 | 4318 | 25 |
529921 | 529921 | 2020-09-13 | Pitt | North Carolina | 37147 | 4294 | 25 |
526684 | 526684 | 2020-09-12 | Pitt | North Carolina | 37147 | 4261 | 25 |
523448 | 523448 | 2020-09-11 | Pitt | North Carolina | 37147 | 4211 | 25 |
520212 | 520212 | 2020-09-10 | Pitt | North Carolina | 37147 | 4155 | 25 |
516976 | 516976 | 2020-09-09 | Pitt | North Carolina | 37147 | 4103 | 24 |
513741 | 513741 | 2020-09-08 | Pitt | North Carolina | 37147 | 4077 | 19 |
510508 | 510508 | 2020-09-07 | Pitt | North Carolina | 37147 | 4044 | 19 |
507275 | 507275 | 2020-09-06 | Pitt | North Carolina | 37147 | 4013 | 19 |
504043 | 504043 | 2020-09-05 | Pitt | North Carolina | 37147 | 3953 | 19 |
500809 | 500809 | 2020-09-04 | Pitt | North Carolina | 37147 | 3857 | 19 |
497575 | 497575 | 2020-09-03 | Pitt | North Carolina | 37147 | 3761 | 19 |
494342 | 494342 | 2020-09-02 | Pitt | North Carolina | 37147 | 3667 | 19 |
491108 | 491108 | 2020-09-01 | Pitt | North Carolina | 37147 | 3617 | 19 |
487875 | 487875 | 2020-08-31 | Pitt | North Carolina | 37147 | 3529 | 19 |
484642 | 484642 | 2020-08-30 | Pitt | North Carolina | 37147 | 3490 | 19 |
481407 | 481407 | 2020-08-29 | Pitt | North Carolina | 37147 | 3376 | 17 |
478174 | 478174 | 2020-08-28 | Pitt | North Carolina | 37147 | 3229 | 17 |
474941 | 474941 | 2020-08-27 | Pitt | North Carolina | 37147 | 3088 | 17 |
471707 | 471707 | 2020-08-26 | Pitt | North Carolina | 37147 | 2934 | 15 |
468475 | 468475 | 2020-08-25 | Pitt | North Carolina | 37147 | 2855 | 15 |
465247 | 465247 | 2020-08-24 | Pitt | North Carolina | 37147 | 2766 | 15 |
462018 | 462018 | 2020-08-23 | Pitt | North Carolina | 37147 | 2670 | 15 |
458790 | 458790 | 2020-08-22 | Pitt | North Carolina | 37147 | 2572 | 15 |
455562 | 455562 | 2020-08-21 | Pitt | North Carolina | 37147 | 2493 | 14 |
452334 | 452334 | 2020-08-20 | Pitt | North Carolina | 37147 | 2404 | 14 |
449106 | 449106 | 2020-08-19 | Pitt | North Carolina | 37147 | 2350 | 14 |
445878 | 445878 | 2020-08-18 | Pitt | North Carolina | 37147 | 2341 | 14 |
442652 | 442652 | 2020-08-17 | Pitt | North Carolina | 37147 | 2308 | 14 |
439425 | 439425 | 2020-08-16 | Pitt | North Carolina | 37147 | 2278 | 14 |
436200 | 436200 | 2020-08-15 | Pitt | North Carolina | 37147 | 2241 | 14 |
432974 | 432974 | 2020-08-14 | Pitt | North Carolina | 37147 | 2205 | 14 |
429748 | 429748 | 2020-08-13 | Pitt | North Carolina | 37147 | 2161 | 11 |
426523 | 426523 | 2020-08-12 | Pitt | North Carolina | 37147 | 2105 | 11 |
423300 | 423300 | 2020-08-11 | Pitt | North Carolina | 37147 | 2054 | 11 |
420077 | 420077 | 2020-08-10 | Pitt | North Carolina | 37147 | 2036 | 11 |
416857 | 416857 | 2020-08-09 | Pitt | North Carolina | 37147 | 2020 | 11 |
413636 | 413636 | 2020-08-08 | Pitt | North Carolina | 37147 | 1962 | 11 |
410416 | 410416 | 2020-08-07 | Pitt | North Carolina | 37147 | 1899 | 11 |
407196 | 407196 | 2020-08-06 | Pitt | North Carolina | 37147 | 1875 | 11 |
403977 | 403977 | 2020-08-05 | Pitt | North Carolina | 37147 | 1833 | 11 |
400759 | 400759 | 2020-08-04 | Pitt | North Carolina | 37147 | 1802 | 11 |
397544 | 397544 | 2020-08-03 | Pitt | North Carolina | 37147 | 1795 | 11 |
394327 | 394327 | 2020-08-02 | Pitt | North Carolina | 37147 | 1766 | 11 |
391111 | 391111 | 2020-08-01 | Pitt | North Carolina | 37147 | 1739 | 11 |
387894 | 387894 | 2020-07-31 | Pitt | North Carolina | 37147 | 1699 | 11 |
384677 | 384677 | 2020-07-30 | Pitt | North Carolina | 37147 | 1639 | 11 |
381459 | 381459 | 2020-07-29 | Pitt | North Carolina | 37147 | 1579 | 11 |
378242 | 378242 | 2020-07-28 | Pitt | North Carolina | 37147 | 1548 | 11 |
375026 | 375026 | 2020-07-27 | Pitt | North Carolina | 37147 | 1519 | 10 |
371814 | 371814 | 2020-07-26 | Pitt | North Carolina | 37147 | 1472 | 10 |
368602 | 368602 | 2020-07-25 | Pitt | North Carolina | 37147 | 1421 | 10 |
365393 | 365393 | 2020-07-24 | Pitt | North Carolina | 37147 | 1376 | 10 |
362187 | 362187 | 2020-07-23 | Pitt | North Carolina | 37147 | 1313 | 10 |
358981 | 358981 | 2020-07-22 | Pitt | North Carolina | 37147 | 1293 | 6 |
355777 | 355777 | 2020-07-21 | Pitt | North Carolina | 37147 | 1239 | 6 |
352574 | 352574 | 2020-07-20 | Pitt | North Carolina | 37147 | 1215 | 6 |
349371 | 349371 | 2020-07-19 | Pitt | North Carolina | 37147 | 1173 | 6 |
346170 | 346170 | 2020-07-18 | Pitt | North Carolina | 37147 | 1130 | 6 |
342971 | 342971 | 2020-07-17 | Pitt | North Carolina | 37147 | 1079 | 6 |
339773 | 339773 | 2020-07-16 | Pitt | North Carolina | 37147 | 1040 | 6 |
336577 | 336577 | 2020-07-15 | Pitt | North Carolina | 37147 | 1000 | 6 |
333383 | 333383 | 2020-07-14 | Pitt | North Carolina | 37147 | 978 | 6 |
330193 | 330193 | 2020-07-13 | Pitt | North Carolina | 37147 | 963 | 6 |
327006 | 327006 | 2020-07-12 | Pitt | North Carolina | 37147 | 946 | 6 |
323822 | 323822 | 2020-07-11 | Pitt | North Carolina | 37147 | 913 | 6 |
320642 | 320642 | 2020-07-10 | Pitt | North Carolina | 37147 | 890 | 6 |
317465 | 317465 | 2020-07-09 | Pitt | North Carolina | 37147 | 876 | 6 |
314291 | 314291 | 2020-07-08 | Pitt | North Carolina | 37147 | 858 | 6 |
311120 | 311120 | 2020-07-07 | Pitt | North Carolina | 37147 | 844 | 6 |
307952 | 307952 | 2020-07-06 | Pitt | North Carolina | 37147 | 822 | 6 |
304785 | 304785 | 2020-07-05 | Pitt | North Carolina | 37147 | 804 | 6 |
301622 | 301622 | 2020-07-04 | Pitt | North Carolina | 37147 | 785 | 6 |
298459 | 298459 | 2020-07-03 | Pitt | North Carolina | 37147 | 758 | 6 |
295299 | 295299 | 2020-07-02 | Pitt | North Carolina | 37147 | 732 | 6 |
292144 | 292144 | 2020-07-01 | Pitt | North Carolina | 37147 | 709 | 6 |
288992 | 288992 | 2020-06-30 | Pitt | North Carolina | 37147 | 696 | 6 |
285842 | 285842 | 2020-06-29 | Pitt | North Carolina | 37147 | 679 | 6 |
282697 | 282697 | 2020-06-28 | Pitt | North Carolina | 37147 | 660 | 6 |
279551 | 279551 | 2020-06-27 | Pitt | North Carolina | 37147 | 650 | 5 |
276403 | 276403 | 2020-06-26 | Pitt | North Carolina | 37147 | 638 | 5 |
273257 | 273257 | 2020-06-25 | Pitt | North Carolina | 37147 | 611 | 5 |
270118 | 270118 | 2020-06-24 | Pitt | North Carolina | 37147 | 602 | 5 |
266984 | 266984 | 2020-06-23 | Pitt | North Carolina | 37147 | 579 | 4 |
263856 | 263856 | 2020-06-22 | Pitt | North Carolina | 37147 | 567 | 4 |
260728 | 260728 | 2020-06-21 | Pitt | North Carolina | 37147 | 561 | 4 |
257601 | 257601 | 2020-06-20 | Pitt | North Carolina | 37147 | 553 | 4 |
254478 | 254478 | 2020-06-19 | Pitt | North Carolina | 37147 | 528 | 3 |
251363 | 251363 | 2020-06-18 | Pitt | North Carolina | 37147 | 507 | 3 |
248248 | 248248 | 2020-06-17 | Pitt | North Carolina | 37147 | 502 | 3 |
245135 | 245135 | 2020-06-16 | Pitt | North Carolina | 37147 | 500 | 2 |
242023 | 242023 | 2020-06-15 | Pitt | North Carolina | 37147 | 493 | 2 |
238914 | 238914 | 2020-06-14 | Pitt | North Carolina | 37147 | 481 | 2 |
235806 | 235806 | 2020-06-13 | Pitt | North Carolina | 37147 | 464 | 2 |
232701 | 232701 | 2020-06-12 | Pitt | North Carolina | 37147 | 451 | 2 |
229596 | 229596 | 2020-06-11 | Pitt | North Carolina | 37147 | 432 | 2 |
226492 | 226492 | 2020-06-10 | Pitt | North Carolina | 37147 | 416 | 2 |
223392 | 223392 | 2020-06-09 | Pitt | North Carolina | 37147 | 404 | 2 |
220298 | 220298 | 2020-06-08 | Pitt | North Carolina | 37147 | 397 | 2 |
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);