ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,142 rows where county = "Lancaster" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 4
- South Carolina 769
- Pennsylvania 761
- Nebraska 760
- Virginia 752
county 1
- Lancaster · 3,042 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419887 | 2419887 | 2022-04-18 | Lancaster | Nebraska | 31109 | 78350 | 437 |
2420467 | 2420467 | 2022-04-18 | Lancaster | Pennsylvania | 42071 | 121233 | 1882 |
2420612 | 2420612 | 2022-04-18 | Lancaster | South Carolina | 45057 | 25060 | 280 |
2421161 | 2421161 | 2022-04-18 | Lancaster | Virginia | 51103 | 1806 | 31 |
2416632 | 2416632 | 2022-04-17 | Lancaster | Nebraska | 31109 | 78338 | 437 |
2417211 | 2417211 | 2022-04-17 | Lancaster | Pennsylvania | 42071 | 121212 | 1882 |
2417356 | 2417356 | 2022-04-17 | Lancaster | South Carolina | 45057 | 25060 | 280 |
2417905 | 2417905 | 2022-04-17 | Lancaster | Virginia | 51103 | 1805 | 31 |
2413376 | 2413376 | 2022-04-16 | Lancaster | Nebraska | 31109 | 78338 | 437 |
2413955 | 2413955 | 2022-04-16 | Lancaster | Pennsylvania | 42071 | 121190 | 1882 |
2414100 | 2414100 | 2022-04-16 | Lancaster | South Carolina | 45057 | 25060 | 280 |
2414649 | 2414649 | 2022-04-16 | Lancaster | Virginia | 51103 | 1805 | 31 |
2410120 | 2410120 | 2022-04-15 | Lancaster | Nebraska | 31109 | 78338 | 437 |
2410699 | 2410699 | 2022-04-15 | Lancaster | Pennsylvania | 42071 | 121145 | 1881 |
2410844 | 2410844 | 2022-04-15 | Lancaster | South Carolina | 45057 | 25060 | 280 |
2411393 | 2411393 | 2022-04-15 | Lancaster | Virginia | 51103 | 1805 | 31 |
2406864 | 2406864 | 2022-04-14 | Lancaster | Nebraska | 31109 | 78332 | 437 |
2407443 | 2407443 | 2022-04-14 | Lancaster | Pennsylvania | 42071 | 121102 | 1881 |
2407588 | 2407588 | 2022-04-14 | Lancaster | South Carolina | 45057 | 25060 | 280 |
2408137 | 2408137 | 2022-04-14 | Lancaster | Virginia | 51103 | 1803 | 31 |
2403608 | 2403608 | 2022-04-13 | Lancaster | Nebraska | 31109 | 78308 | 437 |
2404187 | 2404187 | 2022-04-13 | Lancaster | Pennsylvania | 42071 | 121065 | 1880 |
2404332 | 2404332 | 2022-04-13 | Lancaster | South Carolina | 45057 | 25060 | 280 |
2404881 | 2404881 | 2022-04-13 | Lancaster | Virginia | 51103 | 1800 | 31 |
2400353 | 2400353 | 2022-04-12 | Lancaster | Nebraska | 31109 | 78275 | 437 |
2400932 | 2400932 | 2022-04-12 | Lancaster | Pennsylvania | 42071 | 121018 | 1880 |
2401077 | 2401077 | 2022-04-12 | Lancaster | South Carolina | 45057 | 25060 | 280 |
2401626 | 2401626 | 2022-04-12 | Lancaster | Virginia | 51103 | 1799 | 31 |
2397098 | 2397098 | 2022-04-11 | Lancaster | Nebraska | 31109 | 78243 | 437 |
2397677 | 2397677 | 2022-04-11 | Lancaster | Pennsylvania | 42071 | 120987 | 1879 |
2397822 | 2397822 | 2022-04-11 | Lancaster | South Carolina | 45057 | 25063 | 279 |
2398371 | 2398371 | 2022-04-11 | Lancaster | Virginia | 51103 | 1799 | 31 |
2393843 | 2393843 | 2022-04-10 | Lancaster | Nebraska | 31109 | 78215 | 436 |
2394422 | 2394422 | 2022-04-10 | Lancaster | Pennsylvania | 42071 | 120978 | 1879 |
2394567 | 2394567 | 2022-04-10 | Lancaster | South Carolina | 45057 | 25063 | 279 |
2395116 | 2395116 | 2022-04-10 | Lancaster | Virginia | 51103 | 1799 | 31 |
2390587 | 2390587 | 2022-04-09 | Lancaster | Nebraska | 31109 | 78215 | 436 |
2391166 | 2391166 | 2022-04-09 | Lancaster | Pennsylvania | 42071 | 120966 | 1878 |
2391311 | 2391311 | 2022-04-09 | Lancaster | South Carolina | 45057 | 25063 | 279 |
2391860 | 2391860 | 2022-04-09 | Lancaster | Virginia | 51103 | 1799 | 31 |
2387331 | 2387331 | 2022-04-08 | Lancaster | Nebraska | 31109 | 78215 | 436 |
2387910 | 2387910 | 2022-04-08 | Lancaster | Pennsylvania | 42071 | 120934 | 1878 |
2388055 | 2388055 | 2022-04-08 | Lancaster | South Carolina | 45057 | 25063 | 279 |
2388604 | 2388604 | 2022-04-08 | Lancaster | Virginia | 51103 | 1799 | 31 |
2384076 | 2384076 | 2022-04-07 | Lancaster | Nebraska | 31109 | 78193 | 433 |
2384655 | 2384655 | 2022-04-07 | Lancaster | Pennsylvania | 42071 | 120890 | 1878 |
2384800 | 2384800 | 2022-04-07 | Lancaster | South Carolina | 45057 | 25063 | 279 |
2385349 | 2385349 | 2022-04-07 | Lancaster | Virginia | 51103 | 1799 | 31 |
2380821 | 2380821 | 2022-04-06 | Lancaster | Nebraska | 31109 | 78173 | 433 |
2381400 | 2381400 | 2022-04-06 | Lancaster | Pennsylvania | 42071 | 120864 | 1877 |
2381545 | 2381545 | 2022-04-06 | Lancaster | South Carolina | 45057 | 25063 | 279 |
2382094 | 2382094 | 2022-04-06 | Lancaster | Virginia | 51103 | 1799 | 31 |
2377566 | 2377566 | 2022-04-05 | Lancaster | Nebraska | 31109 | 78161 | 433 |
2378145 | 2378145 | 2022-04-05 | Lancaster | Pennsylvania | 42071 | 120835 | 1877 |
2378290 | 2378290 | 2022-04-05 | Lancaster | South Carolina | 45057 | 25063 | 279 |
2378839 | 2378839 | 2022-04-05 | Lancaster | Virginia | 51103 | 1799 | 31 |
2374313 | 2374313 | 2022-04-04 | Lancaster | Nebraska | 31109 | 78108 | 433 |
2374891 | 2374891 | 2022-04-04 | Lancaster | Pennsylvania | 42071 | 120813 | 1877 |
2375036 | 2375036 | 2022-04-04 | Lancaster | South Carolina | 45057 | 25046 | 278 |
2375585 | 2375585 | 2022-04-04 | Lancaster | Virginia | 51103 | 1799 | 31 |
2371061 | 2371061 | 2022-04-03 | Lancaster | Nebraska | 31109 | 78114 | 433 |
2371639 | 2371639 | 2022-04-03 | Lancaster | Pennsylvania | 42071 | 120789 | 1877 |
2371784 | 2371784 | 2022-04-03 | Lancaster | South Carolina | 45057 | 25046 | 278 |
2372333 | 2372333 | 2022-04-03 | Lancaster | Virginia | 51103 | 1794 | 31 |
2367808 | 2367808 | 2022-04-02 | Lancaster | Nebraska | 31109 | 78114 | 433 |
2368386 | 2368386 | 2022-04-02 | Lancaster | Pennsylvania | 42071 | 120789 | 1877 |
2368531 | 2368531 | 2022-04-02 | Lancaster | South Carolina | 45057 | 25046 | 278 |
2369080 | 2369080 | 2022-04-02 | Lancaster | Virginia | 51103 | 1794 | 31 |
2364555 | 2364555 | 2022-04-01 | Lancaster | Nebraska | 31109 | 78114 | 433 |
2365133 | 2365133 | 2022-04-01 | Lancaster | Pennsylvania | 42071 | 120770 | 1877 |
2365278 | 2365278 | 2022-04-01 | Lancaster | South Carolina | 45057 | 25046 | 278 |
2365827 | 2365827 | 2022-04-01 | Lancaster | Virginia | 51103 | 1794 | 31 |
2361301 | 2361301 | 2022-03-31 | Lancaster | Nebraska | 31109 | 78114 | 433 |
2361880 | 2361880 | 2022-03-31 | Lancaster | Pennsylvania | 42071 | 120748 | 1876 |
2362025 | 2362025 | 2022-03-31 | Lancaster | South Carolina | 45057 | 25046 | 278 |
2362574 | 2362574 | 2022-03-31 | Lancaster | Virginia | 51103 | 1793 | 31 |
2358047 | 2358047 | 2022-03-30 | Lancaster | Nebraska | 31109 | 78092 | 433 |
2358626 | 2358626 | 2022-03-30 | Lancaster | Pennsylvania | 42071 | 120723 | 1876 |
2358771 | 2358771 | 2022-03-30 | Lancaster | South Carolina | 45057 | 25046 | 278 |
2359320 | 2359320 | 2022-03-30 | Lancaster | Virginia | 51103 | 1792 | 31 |
2354794 | 2354794 | 2022-03-29 | Lancaster | Nebraska | 31109 | 78065 | 433 |
2355372 | 2355372 | 2022-03-29 | Lancaster | Pennsylvania | 42071 | 120712 | 1875 |
2355517 | 2355517 | 2022-03-29 | Lancaster | South Carolina | 45057 | 25046 | 278 |
2356066 | 2356066 | 2022-03-29 | Lancaster | Virginia | 51103 | 1791 | 31 |
2351541 | 2351541 | 2022-03-28 | Lancaster | Nebraska | 31109 | 78044 | 433 |
2352119 | 2352119 | 2022-03-28 | Lancaster | Pennsylvania | 42071 | 120684 | 1875 |
2352264 | 2352264 | 2022-03-28 | Lancaster | South Carolina | 45057 | 25035 | 277 |
2352813 | 2352813 | 2022-03-28 | Lancaster | Virginia | 51103 | 1791 | 31 |
2348289 | 2348289 | 2022-03-27 | Lancaster | Nebraska | 31109 | 77944 | 433 |
2348867 | 2348867 | 2022-03-27 | Lancaster | Pennsylvania | 42071 | 120676 | 1875 |
2349012 | 2349012 | 2022-03-27 | Lancaster | South Carolina | 45057 | 25035 | 277 |
2349561 | 2349561 | 2022-03-27 | Lancaster | Virginia | 51103 | 1791 | 31 |
2345036 | 2345036 | 2022-03-26 | Lancaster | Nebraska | 31109 | 77944 | 433 |
2345614 | 2345614 | 2022-03-26 | Lancaster | Pennsylvania | 42071 | 120664 | 1875 |
2345759 | 2345759 | 2022-03-26 | Lancaster | South Carolina | 45057 | 25035 | 277 |
2346308 | 2346308 | 2022-03-26 | Lancaster | Virginia | 51103 | 1791 | 31 |
2341783 | 2341783 | 2022-03-25 | Lancaster | Nebraska | 31109 | 77944 | 433 |
2342361 | 2342361 | 2022-03-25 | Lancaster | Pennsylvania | 42071 | 120648 | 1874 |
2342506 | 2342506 | 2022-03-25 | Lancaster | South Carolina | 45057 | 25035 | 277 |
2343055 | 2343055 | 2022-03-25 | Lancaster | Virginia | 51103 | 1791 | 31 |
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);