ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 37025 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 |
---|---|---|---|---|---|---|---|
536331 | 536331 | 2020-09-15 | Cabarrus | North Carolina | 37025 | 3647 | 59 |
533095 | 533095 | 2020-09-14 | Cabarrus | North Carolina | 37025 | 3604 | 58 |
529860 | 529860 | 2020-09-13 | Cabarrus | North Carolina | 37025 | 3588 | 58 |
526623 | 526623 | 2020-09-12 | Cabarrus | North Carolina | 37025 | 3565 | 57 |
523387 | 523387 | 2020-09-11 | Cabarrus | North Carolina | 37025 | 3524 | 56 |
520151 | 520151 | 2020-09-10 | Cabarrus | North Carolina | 37025 | 3495 | 56 |
516915 | 516915 | 2020-09-09 | Cabarrus | North Carolina | 37025 | 3467 | 56 |
513680 | 513680 | 2020-09-08 | Cabarrus | North Carolina | 37025 | 3445 | 56 |
510447 | 510447 | 2020-09-07 | Cabarrus | North Carolina | 37025 | 3430 | 55 |
507214 | 507214 | 2020-09-06 | Cabarrus | North Carolina | 37025 | 3413 | 55 |
503982 | 503982 | 2020-09-05 | Cabarrus | North Carolina | 37025 | 3391 | 55 |
500748 | 500748 | 2020-09-04 | Cabarrus | North Carolina | 37025 | 3371 | 55 |
497514 | 497514 | 2020-09-03 | Cabarrus | North Carolina | 37025 | 3308 | 54 |
494281 | 494281 | 2020-09-02 | Cabarrus | North Carolina | 37025 | 3255 | 54 |
491047 | 491047 | 2020-09-01 | Cabarrus | North Carolina | 37025 | 3221 | 54 |
487814 | 487814 | 2020-08-31 | Cabarrus | North Carolina | 37025 | 3169 | 54 |
484581 | 484581 | 2020-08-30 | Cabarrus | North Carolina | 37025 | 3142 | 53 |
481346 | 481346 | 2020-08-29 | Cabarrus | North Carolina | 37025 | 3136 | 53 |
478113 | 478113 | 2020-08-28 | Cabarrus | North Carolina | 37025 | 3094 | 52 |
474880 | 474880 | 2020-08-27 | Cabarrus | North Carolina | 37025 | 3069 | 52 |
471646 | 471646 | 2020-08-26 | Cabarrus | North Carolina | 37025 | 3029 | 51 |
468414 | 468414 | 2020-08-25 | Cabarrus | North Carolina | 37025 | 3014 | 51 |
465186 | 465186 | 2020-08-24 | Cabarrus | North Carolina | 37025 | 2986 | 51 |
461957 | 461957 | 2020-08-23 | Cabarrus | North Carolina | 37025 | 2958 | 51 |
458729 | 458729 | 2020-08-22 | Cabarrus | North Carolina | 37025 | 2929 | 51 |
455501 | 455501 | 2020-08-21 | Cabarrus | North Carolina | 37025 | 2906 | 51 |
452273 | 452273 | 2020-08-20 | Cabarrus | North Carolina | 37025 | 2866 | 51 |
449045 | 449045 | 2020-08-19 | Cabarrus | North Carolina | 37025 | 2840 | 50 |
445817 | 445817 | 2020-08-18 | Cabarrus | North Carolina | 37025 | 2828 | 50 |
442591 | 442591 | 2020-08-17 | Cabarrus | North Carolina | 37025 | 2809 | 50 |
439364 | 439364 | 2020-08-16 | Cabarrus | North Carolina | 37025 | 2803 | 50 |
436139 | 436139 | 2020-08-15 | Cabarrus | North Carolina | 37025 | 2767 | 50 |
432913 | 432913 | 2020-08-14 | Cabarrus | North Carolina | 37025 | 2753 | 50 |
429687 | 429687 | 2020-08-13 | Cabarrus | North Carolina | 37025 | 2714 | 50 |
426462 | 426462 | 2020-08-12 | Cabarrus | North Carolina | 37025 | 2681 | 50 |
423239 | 423239 | 2020-08-11 | Cabarrus | North Carolina | 37025 | 2655 | 50 |
420016 | 420016 | 2020-08-10 | Cabarrus | North Carolina | 37025 | 2626 | 50 |
416796 | 416796 | 2020-08-09 | Cabarrus | North Carolina | 37025 | 2630 | 50 |
413575 | 413575 | 2020-08-08 | Cabarrus | North Carolina | 37025 | 2603 | 50 |
410355 | 410355 | 2020-08-07 | Cabarrus | North Carolina | 37025 | 2549 | 48 |
407135 | 407135 | 2020-08-06 | Cabarrus | North Carolina | 37025 | 2520 | 48 |
403916 | 403916 | 2020-08-05 | Cabarrus | North Carolina | 37025 | 2490 | 47 |
400698 | 400698 | 2020-08-04 | Cabarrus | North Carolina | 37025 | 2466 | 47 |
397483 | 397483 | 2020-08-03 | Cabarrus | North Carolina | 37025 | 2430 | 46 |
394266 | 394266 | 2020-08-02 | Cabarrus | North Carolina | 37025 | 2406 | 46 |
391050 | 391050 | 2020-08-01 | Cabarrus | North Carolina | 37025 | 2375 | 45 |
387833 | 387833 | 2020-07-31 | Cabarrus | North Carolina | 37025 | 2342 | 42 |
384616 | 384616 | 2020-07-30 | Cabarrus | North Carolina | 37025 | 2316 | 41 |
381398 | 381398 | 2020-07-29 | Cabarrus | North Carolina | 37025 | 2248 | 41 |
378181 | 378181 | 2020-07-28 | Cabarrus | North Carolina | 37025 | 2212 | 38 |
374965 | 374965 | 2020-07-27 | Cabarrus | North Carolina | 37025 | 2184 | 38 |
371753 | 371753 | 2020-07-26 | Cabarrus | North Carolina | 37025 | 2164 | 38 |
368541 | 368541 | 2020-07-25 | Cabarrus | North Carolina | 37025 | 2129 | 38 |
365332 | 365332 | 2020-07-24 | Cabarrus | North Carolina | 37025 | 2094 | 37 |
362126 | 362126 | 2020-07-23 | Cabarrus | North Carolina | 37025 | 2050 | 37 |
358920 | 358920 | 2020-07-22 | Cabarrus | North Carolina | 37025 | 2028 | 35 |
355716 | 355716 | 2020-07-21 | Cabarrus | North Carolina | 37025 | 1989 | 35 |
352513 | 352513 | 2020-07-20 | Cabarrus | North Carolina | 37025 | 1970 | 34 |
349310 | 349310 | 2020-07-19 | Cabarrus | North Carolina | 37025 | 1949 | 34 |
346109 | 346109 | 2020-07-18 | Cabarrus | North Carolina | 37025 | 1902 | 33 |
342910 | 342910 | 2020-07-17 | Cabarrus | North Carolina | 37025 | 1828 | 33 |
339712 | 339712 | 2020-07-16 | Cabarrus | North Carolina | 37025 | 1795 | 33 |
336516 | 336516 | 2020-07-15 | Cabarrus | North Carolina | 37025 | 1754 | 33 |
333322 | 333322 | 2020-07-14 | Cabarrus | North Carolina | 37025 | 1721 | 33 |
330132 | 330132 | 2020-07-13 | Cabarrus | North Carolina | 37025 | 1677 | 33 |
326945 | 326945 | 2020-07-12 | Cabarrus | North Carolina | 37025 | 1640 | 33 |
323761 | 323761 | 2020-07-11 | Cabarrus | North Carolina | 37025 | 1580 | 33 |
320581 | 320581 | 2020-07-10 | Cabarrus | North Carolina | 37025 | 1521 | 33 |
317404 | 317404 | 2020-07-09 | Cabarrus | North Carolina | 37025 | 1454 | 33 |
314230 | 314230 | 2020-07-08 | Cabarrus | North Carolina | 37025 | 1424 | 33 |
311059 | 311059 | 2020-07-07 | Cabarrus | North Carolina | 37025 | 1399 | 33 |
307891 | 307891 | 2020-07-06 | Cabarrus | North Carolina | 37025 | 1368 | 33 |
304724 | 304724 | 2020-07-05 | Cabarrus | North Carolina | 37025 | 1343 | 33 |
301561 | 301561 | 2020-07-04 | Cabarrus | North Carolina | 37025 | 1313 | 33 |
298398 | 298398 | 2020-07-03 | Cabarrus | North Carolina | 37025 | 1237 | 33 |
295238 | 295238 | 2020-07-02 | Cabarrus | North Carolina | 37025 | 1187 | 33 |
292083 | 292083 | 2020-07-01 | Cabarrus | North Carolina | 37025 | 1141 | 33 |
288931 | 288931 | 2020-06-30 | Cabarrus | North Carolina | 37025 | 1107 | 28 |
285781 | 285781 | 2020-06-29 | Cabarrus | North Carolina | 37025 | 1105 | 28 |
282636 | 282636 | 2020-06-28 | Cabarrus | North Carolina | 37025 | 1064 | 27 |
279490 | 279490 | 2020-06-27 | Cabarrus | North Carolina | 37025 | 1021 | 27 |
276342 | 276342 | 2020-06-26 | Cabarrus | North Carolina | 37025 | 978 | 27 |
273196 | 273196 | 2020-06-25 | Cabarrus | North Carolina | 37025 | 936 | 27 |
270057 | 270057 | 2020-06-24 | Cabarrus | North Carolina | 37025 | 912 | 27 |
266923 | 266923 | 2020-06-23 | Cabarrus | North Carolina | 37025 | 888 | 26 |
263795 | 263795 | 2020-06-22 | Cabarrus | North Carolina | 37025 | 883 | 25 |
260667 | 260667 | 2020-06-21 | Cabarrus | North Carolina | 37025 | 869 | 25 |
257540 | 257540 | 2020-06-20 | Cabarrus | North Carolina | 37025 | 835 | 25 |
254417 | 254417 | 2020-06-19 | Cabarrus | North Carolina | 37025 | 805 | 25 |
251302 | 251302 | 2020-06-18 | Cabarrus | North Carolina | 37025 | 773 | 25 |
248187 | 248187 | 2020-06-17 | Cabarrus | North Carolina | 37025 | 746 | 25 |
245074 | 245074 | 2020-06-16 | Cabarrus | North Carolina | 37025 | 729 | 25 |
241962 | 241962 | 2020-06-15 | Cabarrus | North Carolina | 37025 | 716 | 24 |
238853 | 238853 | 2020-06-14 | Cabarrus | North Carolina | 37025 | 711 | 24 |
235745 | 235745 | 2020-06-13 | Cabarrus | North Carolina | 37025 | 686 | 24 |
232640 | 232640 | 2020-06-12 | Cabarrus | North Carolina | 37025 | 670 | 24 |
229535 | 229535 | 2020-06-11 | Cabarrus | North Carolina | 37025 | 641 | 24 |
226431 | 226431 | 2020-06-10 | Cabarrus | North Carolina | 37025 | 614 | 23 |
223331 | 223331 | 2020-06-09 | Cabarrus | North Carolina | 37025 | 612 | 23 |
220237 | 220237 | 2020-06-08 | Cabarrus | North Carolina | 37025 | 599 | 23 |
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);