home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

777 rows where county = "Polk" 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 · 777 ✖

fips 1

  • 37149 777

county 1

  • Polk · 777 ✖
Link rowid date ▲ county state fips cases deaths
2501560 2501560 2022-05-13 Polk North Carolina 37149 3918 64
2498302 2498302 2022-05-12 Polk North Carolina 37149 3918 64
2495044 2495044 2022-05-11 Polk North Carolina 37149 3918 64
2491786 2491786 2022-05-10 Polk North Carolina 37149 3906 64
2488528 2488528 2022-05-09 Polk North Carolina 37149 3906 64
2485271 2485271 2022-05-08 Polk North Carolina 37149 3906 64
2482013 2482013 2022-05-07 Polk North Carolina 37149 3906 64
2478755 2478755 2022-05-06 Polk North Carolina 37149 3906 64
2475497 2475497 2022-05-05 Polk North Carolina 37149 3906 64
2472240 2472240 2022-05-04 Polk North Carolina 37149 3906 64
2468984 2468984 2022-05-03 Polk North Carolina 37149 3901 57
2465728 2465728 2022-05-02 Polk North Carolina 37149 3901 57
2462473 2462473 2022-05-01 Polk North Carolina 37149 3901 57
2459217 2459217 2022-04-30 Polk North Carolina 37149 3901 57
2455961 2455961 2022-04-29 Polk North Carolina 37149 3901 57
2452705 2452705 2022-04-28 Polk North Carolina 37149 3901 57
2449449 2449449 2022-04-27 Polk North Carolina 37149 3901 57
2446192 2446192 2022-04-26 Polk North Carolina 37149 3899 56
2442937 2442937 2022-04-25 Polk North Carolina 37149 3899 56
2439681 2439681 2022-04-24 Polk North Carolina 37149 3899 56
2436425 2436425 2022-04-23 Polk North Carolina 37149 3899 56
2433169 2433169 2022-04-22 Polk North Carolina 37149 3899 56
2429913 2429913 2022-04-21 Polk North Carolina 37149 3899 56
2426657 2426657 2022-04-20 Polk North Carolina 37149 3899 56
2423401 2423401 2022-04-19 Polk North Carolina 37149 3894 55
2420144 2420144 2022-04-18 Polk North Carolina 37149 3894 55
2416889 2416889 2022-04-17 Polk North Carolina 37149 3894 55
2413633 2413633 2022-04-16 Polk North Carolina 37149 3894 55
2410377 2410377 2022-04-15 Polk North Carolina 37149 3894 55
2407121 2407121 2022-04-14 Polk North Carolina 37149 3894 55
2403865 2403865 2022-04-13 Polk North Carolina 37149 3894 55
2400610 2400610 2022-04-12 Polk North Carolina 37149 3888 54
2397355 2397355 2022-04-11 Polk North Carolina 37149 3888 54
2394100 2394100 2022-04-10 Polk North Carolina 37149 3888 54
2390844 2390844 2022-04-09 Polk North Carolina 37149 3888 54
2387588 2387588 2022-04-08 Polk North Carolina 37149 3888 54
2384333 2384333 2022-04-07 Polk North Carolina 37149 3888 54
2381078 2381078 2022-04-06 Polk North Carolina 37149 3888 54
2377823 2377823 2022-04-05 Polk North Carolina 37149 3884 54
2374570 2374570 2022-04-04 Polk North Carolina 37149 3881 54
2371318 2371318 2022-04-03 Polk North Carolina 37149 3865 54
2368065 2368065 2022-04-02 Polk North Carolina 37149 3865 54
2364812 2364812 2022-04-01 Polk North Carolina 37149 3865 54
2361558 2361558 2022-03-31 Polk North Carolina 37149 3862 54
2358304 2358304 2022-03-30 Polk North Carolina 37149 3858 54
2355050 2355050 2022-03-29 Polk North Carolina 37149 3850 54
2351797 2351797 2022-03-28 Polk North Carolina 37149 3849 54
2348545 2348545 2022-03-27 Polk North Carolina 37149 3840 54
2345292 2345292 2022-03-26 Polk North Carolina 37149 3840 54
2342039 2342039 2022-03-25 Polk North Carolina 37149 3840 54
2338786 2338786 2022-03-24 Polk North Carolina 37149 3839 54
2335532 2335532 2022-03-23 Polk North Carolina 37149 3835 54
2332278 2332278 2022-03-22 Polk North Carolina 37149 3835 54
2329025 2329025 2022-03-21 Polk North Carolina 37149 3835 54
2325773 2325773 2022-03-20 Polk North Carolina 37149 3831 54
2322520 2322520 2022-03-19 Polk North Carolina 37149 3831 54
2319266 2319266 2022-03-18 Polk North Carolina 37149 3831 54
2316012 2316012 2022-03-17 Polk North Carolina 37149 3831 54
2312759 2312759 2022-03-16 Polk North Carolina 37149 3830 53
2309506 2309506 2022-03-15 Polk North Carolina 37149 3825 53
2306253 2306253 2022-03-14 Polk North Carolina 37149 3826 53
2303002 2303002 2022-03-13 Polk North Carolina 37149 3823 53
2299750 2299750 2022-03-12 Polk North Carolina 37149 3823 53
2296498 2296498 2022-03-11 Polk North Carolina 37149 3823 53
2293246 2293246 2022-03-10 Polk North Carolina 37149 3822 53
2289994 2289994 2022-03-09 Polk North Carolina 37149 3821 53
2286742 2286742 2022-03-08 Polk North Carolina 37149 3818 52
2283490 2283490 2022-03-07 Polk North Carolina 37149 3813 52
2280238 2280238 2022-03-06 Polk North Carolina 37149 3812 52
2276985 2276985 2022-03-05 Polk North Carolina 37149 3812 52
2273732 2273732 2022-03-04 Polk North Carolina 37149 3812 52
2270479 2270479 2022-03-03 Polk North Carolina 37149 3796 52
2267227 2267227 2022-03-02 Polk North Carolina 37149 3792 52
2263975 2263975 2022-03-01 Polk North Carolina 37149 3787 51
2260724 2260724 2022-02-28 Polk North Carolina 37149 3781 51
2257473 2257473 2022-02-27 Polk North Carolina 37149 3773 51
2254222 2254222 2022-02-26 Polk North Carolina 37149 3773 51
2250971 2250971 2022-02-25 Polk North Carolina 37149 3773 51
2247720 2247720 2022-02-24 Polk North Carolina 37149 3767 50
2244469 2244469 2022-02-23 Polk North Carolina 37149 3758 50
2241218 2241218 2022-02-22 Polk North Carolina 37149 3750 50
2237967 2237967 2022-02-21 Polk North Carolina 37149 3751 50
2234716 2234716 2022-02-20 Polk North Carolina 37149 3732 50
2231465 2231465 2022-02-19 Polk North Carolina 37149 3732 50
2228214 2228214 2022-02-18 Polk North Carolina 37149 3732 50
2224963 2224963 2022-02-17 Polk North Carolina 37149 3724 49
2221712 2221712 2022-02-16 Polk North Carolina 37149 3712 49
2218461 2218461 2022-02-15 Polk North Carolina 37149 3717 49
2215210 2215210 2022-02-14 Polk North Carolina 37149 3712 49
2211959 2211959 2022-02-13 Polk North Carolina 37149 3685 49
2208706 2208706 2022-02-12 Polk North Carolina 37149 3685 49
2205453 2205453 2022-02-11 Polk North Carolina 37149 3685 49
2202200 2202200 2022-02-10 Polk North Carolina 37149 3665 49
2198946 2198946 2022-02-09 Polk North Carolina 37149 3647 49
2195692 2195692 2022-02-08 Polk North Carolina 37149 3629 49
2192438 2192438 2022-02-07 Polk North Carolina 37149 3620 49
2189184 2189184 2022-02-06 Polk North Carolina 37149 3588 49
2185931 2185931 2022-02-05 Polk North Carolina 37149 3588 49
2182679 2182679 2022-02-04 Polk North Carolina 37149 3588 49
2179427 2179427 2022-02-03 Polk North Carolina 37149 3562 49

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);
Powered by Datasette · Queries took 997.178ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette