ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 37093 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 |
---|---|---|---|---|---|---|---|
536365 | 536365 | 2020-09-15 | Hoke | North Carolina | 37093 | 997 | 13 |
533129 | 533129 | 2020-09-14 | Hoke | North Carolina | 37093 | 982 | 13 |
529894 | 529894 | 2020-09-13 | Hoke | North Carolina | 37093 | 975 | 13 |
526657 | 526657 | 2020-09-12 | Hoke | North Carolina | 37093 | 963 | 13 |
523421 | 523421 | 2020-09-11 | Hoke | North Carolina | 37093 | 942 | 13 |
520185 | 520185 | 2020-09-10 | Hoke | North Carolina | 37093 | 929 | 13 |
516949 | 516949 | 2020-09-09 | Hoke | North Carolina | 37093 | 926 | 13 |
513714 | 513714 | 2020-09-08 | Hoke | North Carolina | 37093 | 920 | 13 |
510481 | 510481 | 2020-09-07 | Hoke | North Carolina | 37093 | 915 | 13 |
507248 | 507248 | 2020-09-06 | Hoke | North Carolina | 37093 | 911 | 13 |
504016 | 504016 | 2020-09-05 | Hoke | North Carolina | 37093 | 906 | 13 |
500782 | 500782 | 2020-09-04 | Hoke | North Carolina | 37093 | 897 | 13 |
497548 | 497548 | 2020-09-03 | Hoke | North Carolina | 37093 | 887 | 13 |
494315 | 494315 | 2020-09-02 | Hoke | North Carolina | 37093 | 883 | 13 |
491081 | 491081 | 2020-09-01 | Hoke | North Carolina | 37093 | 880 | 12 |
487848 | 487848 | 2020-08-31 | Hoke | North Carolina | 37093 | 874 | 12 |
484615 | 484615 | 2020-08-30 | Hoke | North Carolina | 37093 | 872 | 12 |
481380 | 481380 | 2020-08-29 | Hoke | North Carolina | 37093 | 865 | 12 |
478147 | 478147 | 2020-08-28 | Hoke | North Carolina | 37093 | 858 | 12 |
474914 | 474914 | 2020-08-27 | Hoke | North Carolina | 37093 | 853 | 12 |
471680 | 471680 | 2020-08-26 | Hoke | North Carolina | 37093 | 842 | 12 |
468448 | 468448 | 2020-08-25 | Hoke | North Carolina | 37093 | 839 | 12 |
465220 | 465220 | 2020-08-24 | Hoke | North Carolina | 37093 | 833 | 12 |
461991 | 461991 | 2020-08-23 | Hoke | North Carolina | 37093 | 819 | 12 |
458763 | 458763 | 2020-08-22 | Hoke | North Carolina | 37093 | 809 | 12 |
455535 | 455535 | 2020-08-21 | Hoke | North Carolina | 37093 | 797 | 12 |
452307 | 452307 | 2020-08-20 | Hoke | North Carolina | 37093 | 794 | 12 |
449079 | 449079 | 2020-08-19 | Hoke | North Carolina | 37093 | 791 | 12 |
445851 | 445851 | 2020-08-18 | Hoke | North Carolina | 37093 | 788 | 12 |
442625 | 442625 | 2020-08-17 | Hoke | North Carolina | 37093 | 782 | 11 |
439398 | 439398 | 2020-08-16 | Hoke | North Carolina | 37093 | 780 | 11 |
436173 | 436173 | 2020-08-15 | Hoke | North Carolina | 37093 | 773 | 11 |
432947 | 432947 | 2020-08-14 | Hoke | North Carolina | 37093 | 767 | 11 |
429721 | 429721 | 2020-08-13 | Hoke | North Carolina | 37093 | 761 | 11 |
426496 | 426496 | 2020-08-12 | Hoke | North Carolina | 37093 | 738 | 11 |
423273 | 423273 | 2020-08-11 | Hoke | North Carolina | 37093 | 726 | 11 |
420050 | 420050 | 2020-08-10 | Hoke | North Carolina | 37093 | 720 | 9 |
416830 | 416830 | 2020-08-09 | Hoke | North Carolina | 37093 | 717 | 9 |
413609 | 413609 | 2020-08-08 | Hoke | North Carolina | 37093 | 713 | 9 |
410389 | 410389 | 2020-08-07 | Hoke | North Carolina | 37093 | 710 | 9 |
407169 | 407169 | 2020-08-06 | Hoke | North Carolina | 37093 | 703 | 9 |
403950 | 403950 | 2020-08-05 | Hoke | North Carolina | 37093 | 693 | 9 |
400732 | 400732 | 2020-08-04 | Hoke | North Carolina | 37093 | 681 | 9 |
397517 | 397517 | 2020-08-03 | Hoke | North Carolina | 37093 | 674 | 8 |
394300 | 394300 | 2020-08-02 | Hoke | North Carolina | 37093 | 670 | 8 |
391084 | 391084 | 2020-08-01 | Hoke | North Carolina | 37093 | 666 | 8 |
387867 | 387867 | 2020-07-31 | Hoke | North Carolina | 37093 | 659 | 8 |
384650 | 384650 | 2020-07-30 | Hoke | North Carolina | 37093 | 648 | 8 |
381432 | 381432 | 2020-07-29 | Hoke | North Carolina | 37093 | 645 | 7 |
378215 | 378215 | 2020-07-28 | Hoke | North Carolina | 37093 | 632 | 7 |
374999 | 374999 | 2020-07-27 | Hoke | North Carolina | 37093 | 623 | 7 |
371787 | 371787 | 2020-07-26 | Hoke | North Carolina | 37093 | 616 | 7 |
368575 | 368575 | 2020-07-25 | Hoke | North Carolina | 37093 | 608 | 7 |
365366 | 365366 | 2020-07-24 | Hoke | North Carolina | 37093 | 589 | 7 |
362160 | 362160 | 2020-07-23 | Hoke | North Carolina | 37093 | 582 | 7 |
358954 | 358954 | 2020-07-22 | Hoke | North Carolina | 37093 | 577 | 7 |
355750 | 355750 | 2020-07-21 | Hoke | North Carolina | 37093 | 555 | 6 |
352547 | 352547 | 2020-07-20 | Hoke | North Carolina | 37093 | 547 | 5 |
349344 | 349344 | 2020-07-19 | Hoke | North Carolina | 37093 | 540 | 5 |
346143 | 346143 | 2020-07-18 | Hoke | North Carolina | 37093 | 531 | 5 |
342944 | 342944 | 2020-07-17 | Hoke | North Carolina | 37093 | 509 | 5 |
339746 | 339746 | 2020-07-16 | Hoke | North Carolina | 37093 | 491 | 4 |
336550 | 336550 | 2020-07-15 | Hoke | North Carolina | 37093 | 482 | 4 |
333356 | 333356 | 2020-07-14 | Hoke | North Carolina | 37093 | 480 | 4 |
330166 | 330166 | 2020-07-13 | Hoke | North Carolina | 37093 | 467 | 4 |
326979 | 326979 | 2020-07-12 | Hoke | North Carolina | 37093 | 458 | 4 |
323795 | 323795 | 2020-07-11 | Hoke | North Carolina | 37093 | 454 | 5 |
320615 | 320615 | 2020-07-10 | Hoke | North Carolina | 37093 | 444 | 5 |
317438 | 317438 | 2020-07-09 | Hoke | North Carolina | 37093 | 434 | 4 |
314264 | 314264 | 2020-07-08 | Hoke | North Carolina | 37093 | 423 | 3 |
311093 | 311093 | 2020-07-07 | Hoke | North Carolina | 37093 | 415 | 3 |
307925 | 307925 | 2020-07-06 | Hoke | North Carolina | 37093 | 407 | 3 |
304758 | 304758 | 2020-07-05 | Hoke | North Carolina | 37093 | 403 | 3 |
301595 | 301595 | 2020-07-04 | Hoke | North Carolina | 37093 | 389 | 3 |
298432 | 298432 | 2020-07-03 | Hoke | North Carolina | 37093 | 391 | 3 |
295272 | 295272 | 2020-07-02 | Hoke | North Carolina | 37093 | 388 | 3 |
292117 | 292117 | 2020-07-01 | Hoke | North Carolina | 37093 | 383 | 3 |
288965 | 288965 | 2020-06-30 | Hoke | North Carolina | 37093 | 371 | 3 |
285815 | 285815 | 2020-06-29 | Hoke | North Carolina | 37093 | 361 | 3 |
282670 | 282670 | 2020-06-28 | Hoke | North Carolina | 37093 | 357 | 3 |
279524 | 279524 | 2020-06-27 | Hoke | North Carolina | 37093 | 352 | 3 |
276376 | 276376 | 2020-06-26 | Hoke | North Carolina | 37093 | 341 | 3 |
273230 | 273230 | 2020-06-25 | Hoke | North Carolina | 37093 | 337 | 3 |
270091 | 270091 | 2020-06-24 | Hoke | North Carolina | 37093 | 332 | 3 |
266957 | 266957 | 2020-06-23 | Hoke | North Carolina | 37093 | 330 | 3 |
263829 | 263829 | 2020-06-22 | Hoke | North Carolina | 37093 | 326 | 3 |
260701 | 260701 | 2020-06-21 | Hoke | North Carolina | 37093 | 326 | 3 |
257574 | 257574 | 2020-06-20 | Hoke | North Carolina | 37093 | 323 | 3 |
254451 | 254451 | 2020-06-19 | Hoke | North Carolina | 37093 | 319 | 3 |
251336 | 251336 | 2020-06-18 | Hoke | North Carolina | 37093 | 312 | 2 |
248221 | 248221 | 2020-06-17 | Hoke | North Carolina | 37093 | 308 | 2 |
245108 | 245108 | 2020-06-16 | Hoke | North Carolina | 37093 | 303 | 2 |
241996 | 241996 | 2020-06-15 | Hoke | North Carolina | 37093 | 300 | 1 |
238887 | 238887 | 2020-06-14 | Hoke | North Carolina | 37093 | 299 | 1 |
235779 | 235779 | 2020-06-13 | Hoke | North Carolina | 37093 | 298 | 1 |
232674 | 232674 | 2020-06-12 | Hoke | North Carolina | 37093 | 296 | 1 |
229569 | 229569 | 2020-06-11 | Hoke | North Carolina | 37093 | 291 | 1 |
226465 | 226465 | 2020-06-10 | Hoke | North Carolina | 37093 | 288 | 1 |
223365 | 223365 | 2020-06-09 | Hoke | North Carolina | 37093 | 283 | 1 |
220271 | 220271 | 2020-06-08 | Hoke | North Carolina | 37093 | 278 | 1 |
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);