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 county = "Lincoln" and state = "North Carolina" sorted by date descending

✎ View and edit SQL

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

state 1

  • North Carolina · 787 ✖

fips 1

county 1

  • Lincoln · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501540 2501540 2022-05-13 Lincoln North Carolina 37109 24543 174
2498282 2498282 2022-05-12 Lincoln North Carolina 37109 24543 174
2495024 2495024 2022-05-11 Lincoln North Carolina 37109 24543 174
2491766 2491766 2022-05-10 Lincoln North Carolina 37109 24436 174
2488508 2488508 2022-05-09 Lincoln North Carolina 37109 24436 174
2485251 2485251 2022-05-08 Lincoln North Carolina 37109 24436 174
2481993 2481993 2022-05-07 Lincoln North Carolina 37109 24436 174
2478735 2478735 2022-05-06 Lincoln North Carolina 37109 24436 174
2475477 2475477 2022-05-05 Lincoln North Carolina 37109 24436 174
2472220 2472220 2022-05-04 Lincoln North Carolina 37109 24436 174
2468964 2468964 2022-05-03 Lincoln North Carolina 37109 24366 158
2465708 2465708 2022-05-02 Lincoln North Carolina 37109 24366 158
2462453 2462453 2022-05-01 Lincoln North Carolina 37109 24366 158
2459197 2459197 2022-04-30 Lincoln North Carolina 37109 24366 158
2455941 2455941 2022-04-29 Lincoln North Carolina 37109 24366 158
2452685 2452685 2022-04-28 Lincoln North Carolina 37109 24366 158
2449429 2449429 2022-04-27 Lincoln North Carolina 37109 24366 158
2446172 2446172 2022-04-26 Lincoln North Carolina 37109 24334 158
2442917 2442917 2022-04-25 Lincoln North Carolina 37109 24334 158
2439661 2439661 2022-04-24 Lincoln North Carolina 37109 24334 158
2436405 2436405 2022-04-23 Lincoln North Carolina 37109 24334 158
2433149 2433149 2022-04-22 Lincoln North Carolina 37109 24334 158
2429893 2429893 2022-04-21 Lincoln North Carolina 37109 24334 158
2426637 2426637 2022-04-20 Lincoln North Carolina 37109 24334 158
2423381 2423381 2022-04-19 Lincoln North Carolina 37109 24296 158
2420124 2420124 2022-04-18 Lincoln North Carolina 37109 24296 158
2416869 2416869 2022-04-17 Lincoln North Carolina 37109 24296 158
2413613 2413613 2022-04-16 Lincoln North Carolina 37109 24296 158
2410357 2410357 2022-04-15 Lincoln North Carolina 37109 24296 158
2407101 2407101 2022-04-14 Lincoln North Carolina 37109 24296 158
2403845 2403845 2022-04-13 Lincoln North Carolina 37109 24296 158
2400590 2400590 2022-04-12 Lincoln North Carolina 37109 24282 158
2397335 2397335 2022-04-11 Lincoln North Carolina 37109 24282 158
2394080 2394080 2022-04-10 Lincoln North Carolina 37109 24282 158
2390824 2390824 2022-04-09 Lincoln North Carolina 37109 24282 158
2387568 2387568 2022-04-08 Lincoln North Carolina 37109 24282 158
2384313 2384313 2022-04-07 Lincoln North Carolina 37109 24282 158
2381058 2381058 2022-04-06 Lincoln North Carolina 37109 24282 158
2377803 2377803 2022-04-05 Lincoln North Carolina 37109 24282 158
2374550 2374550 2022-04-04 Lincoln North Carolina 37109 24273 158
2371298 2371298 2022-04-03 Lincoln North Carolina 37109 24267 158
2368045 2368045 2022-04-02 Lincoln North Carolina 37109 24267 158
2364792 2364792 2022-04-01 Lincoln North Carolina 37109 24267 158
2361538 2361538 2022-03-31 Lincoln North Carolina 37109 24264 158
2358284 2358284 2022-03-30 Lincoln North Carolina 37109 24266 158
2355030 2355030 2022-03-29 Lincoln North Carolina 37109 24265 158
2351777 2351777 2022-03-28 Lincoln North Carolina 37109 24284 158
2348525 2348525 2022-03-27 Lincoln North Carolina 37109 24273 158
2345272 2345272 2022-03-26 Lincoln North Carolina 37109 24273 158
2342019 2342019 2022-03-25 Lincoln North Carolina 37109 24273 158
2338766 2338766 2022-03-24 Lincoln North Carolina 37109 24267 158
2335512 2335512 2022-03-23 Lincoln North Carolina 37109 24264 158
2332258 2332258 2022-03-22 Lincoln North Carolina 37109 24250 158
2329005 2329005 2022-03-21 Lincoln North Carolina 37109 24241 158
2325753 2325753 2022-03-20 Lincoln North Carolina 37109 24225 158
2322500 2322500 2022-03-19 Lincoln North Carolina 37109 24225 158
2319246 2319246 2022-03-18 Lincoln North Carolina 37109 24225 158
2315992 2315992 2022-03-17 Lincoln North Carolina 37109 24207 158
2312739 2312739 2022-03-16 Lincoln North Carolina 37109 24197 158
2309486 2309486 2022-03-15 Lincoln North Carolina 37109 24178 158
2306233 2306233 2022-03-14 Lincoln North Carolina 37109 24172 158
2302982 2302982 2022-03-13 Lincoln North Carolina 37109 24139 158
2299730 2299730 2022-03-12 Lincoln North Carolina 37109 24139 158
2296478 2296478 2022-03-11 Lincoln North Carolina 37109 24139 158
2293226 2293226 2022-03-10 Lincoln North Carolina 37109 24126 158
2289974 2289974 2022-03-09 Lincoln North Carolina 37109 24117 158
2286722 2286722 2022-03-08 Lincoln North Carolina 37109 24108 157
2283470 2283470 2022-03-07 Lincoln North Carolina 37109 24109 157
2280218 2280218 2022-03-06 Lincoln North Carolina 37109 24093 156
2276965 2276965 2022-03-05 Lincoln North Carolina 37109 24093 156
2273712 2273712 2022-03-04 Lincoln North Carolina 37109 24093 156
2270459 2270459 2022-03-03 Lincoln North Carolina 37109 24083 156
2267207 2267207 2022-03-02 Lincoln North Carolina 37109 24068 156
2263955 2263955 2022-03-01 Lincoln North Carolina 37109 24058 156
2260704 2260704 2022-02-28 Lincoln North Carolina 37109 24046 154
2257453 2257453 2022-02-27 Lincoln North Carolina 37109 24012 154
2254202 2254202 2022-02-26 Lincoln North Carolina 37109 24012 154
2250951 2250951 2022-02-25 Lincoln North Carolina 37109 24012 154
2247700 2247700 2022-02-24 Lincoln North Carolina 37109 24000 146
2244449 2244449 2022-02-23 Lincoln North Carolina 37109 23970 146
2241198 2241198 2022-02-22 Lincoln North Carolina 37109 23942 146
2237947 2237947 2022-02-21 Lincoln North Carolina 37109 23925 146
2234696 2234696 2022-02-20 Lincoln North Carolina 37109 23827 146
2231445 2231445 2022-02-19 Lincoln North Carolina 37109 23827 146
2228194 2228194 2022-02-18 Lincoln North Carolina 37109 23827 146
2224943 2224943 2022-02-17 Lincoln North Carolina 37109 23784 146
2221692 2221692 2022-02-16 Lincoln North Carolina 37109 23724 146
2218441 2218441 2022-02-15 Lincoln North Carolina 37109 23620 146
2215190 2215190 2022-02-14 Lincoln North Carolina 37109 23608 146
2211939 2211939 2022-02-13 Lincoln North Carolina 37109 23498 146
2208686 2208686 2022-02-12 Lincoln North Carolina 37109 23498 146
2205433 2205433 2022-02-11 Lincoln North Carolina 37109 23498 146
2202180 2202180 2022-02-10 Lincoln North Carolina 37109 23427 144
2198926 2198926 2022-02-09 Lincoln North Carolina 37109 23345 144
2195672 2195672 2022-02-08 Lincoln North Carolina 37109 23261 141
2192418 2192418 2022-02-07 Lincoln North Carolina 37109 23206 141
2189164 2189164 2022-02-06 Lincoln North Carolina 37109 22984 132
2185911 2185911 2022-02-05 Lincoln North Carolina 37109 22984 132
2182659 2182659 2022-02-04 Lincoln North Carolina 37109 22984 132
2179407 2179407 2022-02-03 Lincoln North Carolina 37109 22844 122

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