ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • North Carolina · 787 ✖

fips 1

  • 37093 · 787 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501532 2501532 2022-05-13 Hoke North Carolina 37093 15074 116
2498274 2498274 2022-05-12 Hoke North Carolina 37093 15074 116
2495016 2495016 2022-05-11 Hoke North Carolina 37093 15074 116
2491758 2491758 2022-05-10 Hoke North Carolina 37093 14976 116
2488500 2488500 2022-05-09 Hoke North Carolina 37093 14976 116
2485243 2485243 2022-05-08 Hoke North Carolina 37093 14976 116
2481985 2481985 2022-05-07 Hoke North Carolina 37093 14976 116
2478727 2478727 2022-05-06 Hoke North Carolina 37093 14976 116
2475469 2475469 2022-05-05 Hoke North Carolina 37093 14976 116
2472212 2472212 2022-05-04 Hoke North Carolina 37093 14976 116
2468956 2468956 2022-05-03 Hoke North Carolina 37093 14872 108
2465700 2465700 2022-05-02 Hoke North Carolina 37093 14872 108
2462445 2462445 2022-05-01 Hoke North Carolina 37093 14872 108
2459189 2459189 2022-04-30 Hoke North Carolina 37093 14872 108
2455933 2455933 2022-04-29 Hoke North Carolina 37093 14872 108
2452677 2452677 2022-04-28 Hoke North Carolina 37093 14872 108
2449421 2449421 2022-04-27 Hoke North Carolina 37093 14872 108
2446164 2446164 2022-04-26 Hoke North Carolina 37093 14808 104
2442909 2442909 2022-04-25 Hoke North Carolina 37093 14808 104
2439653 2439653 2022-04-24 Hoke North Carolina 37093 14808 104
2436397 2436397 2022-04-23 Hoke North Carolina 37093 14808 104
2433141 2433141 2022-04-22 Hoke North Carolina 37093 14808 104
2429885 2429885 2022-04-21 Hoke North Carolina 37093 14808 104
2426629 2426629 2022-04-20 Hoke North Carolina 37093 14808 104
2423373 2423373 2022-04-19 Hoke North Carolina 37093 14750 104
2420116 2420116 2022-04-18 Hoke North Carolina 37093 14750 104
2416861 2416861 2022-04-17 Hoke North Carolina 37093 14750 104
2413605 2413605 2022-04-16 Hoke North Carolina 37093 14750 104
2410349 2410349 2022-04-15 Hoke North Carolina 37093 14750 104
2407093 2407093 2022-04-14 Hoke North Carolina 37093 14750 104
2403837 2403837 2022-04-13 Hoke North Carolina 37093 14750 104
2400582 2400582 2022-04-12 Hoke North Carolina 37093 14711 103
2397327 2397327 2022-04-11 Hoke North Carolina 37093 14711 103
2394072 2394072 2022-04-10 Hoke North Carolina 37093 14711 103
2390816 2390816 2022-04-09 Hoke North Carolina 37093 14711 103
2387560 2387560 2022-04-08 Hoke North Carolina 37093 14711 103
2384305 2384305 2022-04-07 Hoke North Carolina 37093 14711 103
2381050 2381050 2022-04-06 Hoke North Carolina 37093 14711 103
2377795 2377795 2022-04-05 Hoke North Carolina 37093 14709 103
2374542 2374542 2022-04-04 Hoke North Carolina 37093 14702 103
2371290 2371290 2022-04-03 Hoke North Carolina 37093 14684 103
2368037 2368037 2022-04-02 Hoke North Carolina 37093 14684 103
2364784 2364784 2022-04-01 Hoke North Carolina 37093 14684 103
2361530 2361530 2022-03-31 Hoke North Carolina 37093 14670 103
2358276 2358276 2022-03-30 Hoke North Carolina 37093 14653 103
2355022 2355022 2022-03-29 Hoke North Carolina 37093 14638 103
2351769 2351769 2022-03-28 Hoke North Carolina 37093 14628 103
2348517 2348517 2022-03-27 Hoke North Carolina 37093 14607 103
2345264 2345264 2022-03-26 Hoke North Carolina 37093 14607 103
2342011 2342011 2022-03-25 Hoke North Carolina 37093 14607 103
2338758 2338758 2022-03-24 Hoke North Carolina 37093 14597 103
2335504 2335504 2022-03-23 Hoke North Carolina 37093 14586 103
2332250 2332250 2022-03-22 Hoke North Carolina 37093 14579 103
2328997 2328997 2022-03-21 Hoke North Carolina 37093 14573 103
2325745 2325745 2022-03-20 Hoke North Carolina 37093 14567 103
2322492 2322492 2022-03-19 Hoke North Carolina 37093 14567 103
2319238 2319238 2022-03-18 Hoke North Carolina 37093 14567 103
2315984 2315984 2022-03-17 Hoke North Carolina 37093 14560 103
2312731 2312731 2022-03-16 Hoke North Carolina 37093 14557 103
2309478 2309478 2022-03-15 Hoke North Carolina 37093 14551 103
2306225 2306225 2022-03-14 Hoke North Carolina 37093 14546 103
2302974 2302974 2022-03-13 Hoke North Carolina 37093 14530 103
2299722 2299722 2022-03-12 Hoke North Carolina 37093 14530 103
2296470 2296470 2022-03-11 Hoke North Carolina 37093 14530 103
2293218 2293218 2022-03-10 Hoke North Carolina 37093 14507 103
2289966 2289966 2022-03-09 Hoke North Carolina 37093 14498 102
2286714 2286714 2022-03-08 Hoke North Carolina 37093 14483 102
2283462 2283462 2022-03-07 Hoke North Carolina 37093 14477 102
2280210 2280210 2022-03-06 Hoke North Carolina 37093 14451 102
2276957 2276957 2022-03-05 Hoke North Carolina 37093 14451 102
2273704 2273704 2022-03-04 Hoke North Carolina 37093 14451 102
2270451 2270451 2022-03-03 Hoke North Carolina 37093 14440 102
2267199 2267199 2022-03-02 Hoke North Carolina 37093 14437 102
2263947 2263947 2022-03-01 Hoke North Carolina 37093 14425 102
2260696 2260696 2022-02-28 Hoke North Carolina 37093 14413 102
2257445 2257445 2022-02-27 Hoke North Carolina 37093 14377 102
2254194 2254194 2022-02-26 Hoke North Carolina 37093 14377 102
2250943 2250943 2022-02-25 Hoke North Carolina 37093 14377 102
2247692 2247692 2022-02-24 Hoke North Carolina 37093 14353 102
2244441 2244441 2022-02-23 Hoke North Carolina 37093 14345 102
2241190 2241190 2022-02-22 Hoke North Carolina 37093 14330 101
2237939 2237939 2022-02-21 Hoke North Carolina 37093 14326 100
2234688 2234688 2022-02-20 Hoke North Carolina 37093 14301 100
2231437 2231437 2022-02-19 Hoke North Carolina 37093 14301 100
2228186 2228186 2022-02-18 Hoke North Carolina 37093 14301 100
2224935 2224935 2022-02-17 Hoke North Carolina 37093 14258 100
2221684 2221684 2022-02-16 Hoke North Carolina 37093 14234 100
2218433 2218433 2022-02-15 Hoke North Carolina 37093 14206 100
2215182 2215182 2022-02-14 Hoke North Carolina 37093 14186 100
2211931 2211931 2022-02-13 Hoke North Carolina 37093 14112 100
2208678 2208678 2022-02-12 Hoke North Carolina 37093 14112 100
2205425 2205425 2022-02-11 Hoke North Carolina 37093 14112 100
2202172 2202172 2022-02-10 Hoke North Carolina 37093 14064 100
2198918 2198918 2022-02-09 Hoke North Carolina 37093 14001 100
2195664 2195664 2022-02-08 Hoke North Carolina 37093 13912 99
2192410 2192410 2022-02-07 Hoke North Carolina 37093 13876 96
2189156 2189156 2022-02-06 Hoke North Carolina 37093 13733 95
2185903 2185903 2022-02-05 Hoke North Carolina 37093 13733 95
2182651 2182651 2022-02-04 Hoke North Carolina 37093 13733 95
2179399 2179399 2022-02-03 Hoke North Carolina 37093 13644 95

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);