ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18,529 rows where county = "Lincoln" sorted by deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 24
- Maine 790
- Washington 790
- Arkansas 789
- Nebraska 787
- North Carolina 787
- Georgia 785
- Mississippi 784
- Louisiana 782
- Tennessee 781
- Oregon 780
- South Dakota 780
- Montana 779
- Oklahoma 779
- Colorado 778
- Minnesota 778
- Missouri 778
- Idaho 777
- Kentucky 772
- Wyoming 771
- New Mexico 770
- West Virginia 760
- Wisconsin 743
- Nevada 736
- Kansas 673
fips 24
county 1
- Lincoln · 18,529 ✖
Link | rowid | date | county | state | fips | cases | deaths ▲ |
---|---|---|---|---|---|---|---|
2472220 | 2472220 | 2022-05-04 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2475477 | 2475477 | 2022-05-05 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2478735 | 2478735 | 2022-05-06 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2481993 | 2481993 | 2022-05-07 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2485251 | 2485251 | 2022-05-08 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2488508 | 2488508 | 2022-05-09 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2491766 | 2491766 | 2022-05-10 | Lincoln | North Carolina | 37109 | 24436 | 174 |
2495024 | 2495024 | 2022-05-11 | Lincoln | North Carolina | 37109 | 24543 | 174 |
2498282 | 2498282 | 2022-05-12 | Lincoln | North Carolina | 37109 | 24543 | 174 |
2501540 | 2501540 | 2022-05-13 | Lincoln | North Carolina | 37109 | 24543 | 174 |
2404467 | 2404467 | 2022-04-13 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2407723 | 2407723 | 2022-04-14 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2410979 | 2410979 | 2022-04-15 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2414235 | 2414235 | 2022-04-16 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2417491 | 2417491 | 2022-04-17 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2420747 | 2420747 | 2022-04-18 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2424003 | 2424003 | 2022-04-19 | Lincoln | Tennessee | 47103 | 9976 | 170 |
2427259 | 2427259 | 2022-04-20 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2430515 | 2430515 | 2022-04-21 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2433771 | 2433771 | 2022-04-22 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2437027 | 2437027 | 2022-04-23 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2440283 | 2440283 | 2022-04-24 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2443539 | 2443539 | 2022-04-25 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2446794 | 2446794 | 2022-04-26 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2450051 | 2450051 | 2022-04-27 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2453307 | 2453307 | 2022-04-28 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2456563 | 2456563 | 2022-04-29 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2459819 | 2459819 | 2022-04-30 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2463075 | 2463075 | 2022-05-01 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2466330 | 2466330 | 2022-05-02 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2469586 | 2469586 | 2022-05-03 | Lincoln | Tennessee | 47103 | 9988 | 170 |
2472842 | 2472842 | 2022-05-04 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2476099 | 2476099 | 2022-05-05 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2479357 | 2479357 | 2022-05-06 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2482615 | 2482615 | 2022-05-07 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2485873 | 2485873 | 2022-05-08 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2489130 | 2489130 | 2022-05-09 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2492388 | 2492388 | 2022-05-10 | Lincoln | Tennessee | 47103 | 9997 | 170 |
2495646 | 2495646 | 2022-05-11 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2498904 | 2498904 | 2022-05-12 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2502162 | 2502162 | 2022-05-13 | Lincoln | Tennessee | 47103 | 10003 | 170 |
2381680 | 2381680 | 2022-04-06 | Lincoln | Tennessee | 47103 | 9976 | 167 |
2384935 | 2384935 | 2022-04-07 | Lincoln | Tennessee | 47103 | 9976 | 167 |
2388190 | 2388190 | 2022-04-08 | Lincoln | Tennessee | 47103 | 9976 | 167 |
2391446 | 2391446 | 2022-04-09 | Lincoln | Tennessee | 47103 | 9976 | 167 |
2394702 | 2394702 | 2022-04-10 | Lincoln | Tennessee | 47103 | 9976 | 167 |
2397957 | 2397957 | 2022-04-11 | Lincoln | Tennessee | 47103 | 9976 | 167 |
2401212 | 2401212 | 2022-04-12 | Lincoln | Tennessee | 47103 | 9976 | 167 |
2336134 | 2336134 | 2022-03-23 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2339388 | 2339388 | 2022-03-24 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2342641 | 2342641 | 2022-03-25 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2345894 | 2345894 | 2022-03-26 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2349147 | 2349147 | 2022-03-27 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2352399 | 2352399 | 2022-03-28 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2355652 | 2355652 | 2022-03-29 | Lincoln | Tennessee | 47103 | 9973 | 166 |
2358906 | 2358906 | 2022-03-30 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2362160 | 2362160 | 2022-03-31 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2365413 | 2365413 | 2022-04-01 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2368666 | 2368666 | 2022-04-02 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2371919 | 2371919 | 2022-04-03 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2375171 | 2375171 | 2022-04-04 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2378425 | 2378425 | 2022-04-05 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2313361 | 2313361 | 2022-03-16 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2316614 | 2316614 | 2022-03-17 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2319868 | 2319868 | 2022-03-18 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2323122 | 2323122 | 2022-03-19 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2326375 | 2326375 | 2022-03-20 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2329627 | 2329627 | 2022-03-21 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2332880 | 2332880 | 2022-03-22 | Lincoln | Tennessee | 47103 | 9968 | 163 |
2289974 | 2289974 | 2022-03-09 | Lincoln | North Carolina | 37109 | 24117 | 158 |
2293226 | 2293226 | 2022-03-10 | Lincoln | North Carolina | 37109 | 24126 | 158 |
2296478 | 2296478 | 2022-03-11 | Lincoln | North Carolina | 37109 | 24139 | 158 |
2299730 | 2299730 | 2022-03-12 | Lincoln | North Carolina | 37109 | 24139 | 158 |
2302982 | 2302982 | 2022-03-13 | Lincoln | North Carolina | 37109 | 24139 | 158 |
2306233 | 2306233 | 2022-03-14 | Lincoln | North Carolina | 37109 | 24172 | 158 |
2309486 | 2309486 | 2022-03-15 | Lincoln | North Carolina | 37109 | 24178 | 158 |
2312739 | 2312739 | 2022-03-16 | Lincoln | North Carolina | 37109 | 24197 | 158 |
2315992 | 2315992 | 2022-03-17 | Lincoln | North Carolina | 37109 | 24207 | 158 |
2319246 | 2319246 | 2022-03-18 | Lincoln | North Carolina | 37109 | 24225 | 158 |
2322500 | 2322500 | 2022-03-19 | Lincoln | North Carolina | 37109 | 24225 | 158 |
2325753 | 2325753 | 2022-03-20 | Lincoln | North Carolina | 37109 | 24225 | 158 |
2329005 | 2329005 | 2022-03-21 | Lincoln | North Carolina | 37109 | 24241 | 158 |
2332258 | 2332258 | 2022-03-22 | Lincoln | North Carolina | 37109 | 24250 | 158 |
2335512 | 2335512 | 2022-03-23 | Lincoln | North Carolina | 37109 | 24264 | 158 |
2338766 | 2338766 | 2022-03-24 | Lincoln | North Carolina | 37109 | 24267 | 158 |
2342019 | 2342019 | 2022-03-25 | Lincoln | North Carolina | 37109 | 24273 | 158 |
2345272 | 2345272 | 2022-03-26 | Lincoln | North Carolina | 37109 | 24273 | 158 |
2348525 | 2348525 | 2022-03-27 | Lincoln | North Carolina | 37109 | 24273 | 158 |
2351777 | 2351777 | 2022-03-28 | Lincoln | North Carolina | 37109 | 24284 | 158 |
2355030 | 2355030 | 2022-03-29 | Lincoln | North Carolina | 37109 | 24265 | 158 |
2358284 | 2358284 | 2022-03-30 | Lincoln | North Carolina | 37109 | 24266 | 158 |
2361538 | 2361538 | 2022-03-31 | Lincoln | North Carolina | 37109 | 24264 | 158 |
2364792 | 2364792 | 2022-04-01 | Lincoln | North Carolina | 37109 | 24267 | 158 |
2368045 | 2368045 | 2022-04-02 | Lincoln | North Carolina | 37109 | 24267 | 158 |
2371298 | 2371298 | 2022-04-03 | Lincoln | North Carolina | 37109 | 24267 | 158 |
2374550 | 2374550 | 2022-04-04 | Lincoln | North Carolina | 37109 | 24273 | 158 |
2377803 | 2377803 | 2022-04-05 | Lincoln | North Carolina | 37109 | 24282 | 158 |
2381058 | 2381058 | 2022-04-06 | Lincoln | North Carolina | 37109 | 24282 | 158 |
2384313 | 2384313 | 2022-04-07 | Lincoln | North Carolina | 37109 | 24282 | 158 |
2387568 | 2387568 | 2022-04-08 | Lincoln | North Carolina | 37109 | 24282 | 158 |
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);