ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Lancaster" and state = "Pennsylvania" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- …
state 1
- Pennsylvania · 786 ✖
fips 1
- 42071 786
county 1
- Lancaster · 786 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4986 | 4986 | 2020-03-19 | Lancaster | Pennsylvania | 42071 | 2 | 0 |
5858 | 5858 | 2020-03-20 | Lancaster | Pennsylvania | 42071 | 2 | 0 |
6861 | 6861 | 2020-03-21 | Lancaster | Pennsylvania | 42071 | 4 | 0 |
7979 | 7979 | 2020-03-22 | Lancaster | Pennsylvania | 42071 | 5 | 0 |
9190 | 9190 | 2020-03-23 | Lancaster | Pennsylvania | 42071 | 5 | 0 |
10514 | 10514 | 2020-03-24 | Lancaster | Pennsylvania | 42071 | 10 | 0 |
11977 | 11977 | 2020-03-25 | Lancaster | Pennsylvania | 42071 | 12 | 0 |
13598 | 13598 | 2020-03-26 | Lancaster | Pennsylvania | 42071 | 21 | 0 |
15344 | 15344 | 2020-03-27 | Lancaster | Pennsylvania | 42071 | 33 | 0 |
17194 | 17194 | 2020-03-28 | Lancaster | Pennsylvania | 42071 | 45 | 1 |
19132 | 19132 | 2020-03-29 | Lancaster | Pennsylvania | 42071 | 67 | 2 |
21182 | 21182 | 2020-03-30 | Lancaster | Pennsylvania | 42071 | 97 | 2 |
23318 | 23318 | 2020-03-31 | Lancaster | Pennsylvania | 42071 | 123 | 3 |
25516 | 25516 | 2020-04-01 | Lancaster | Pennsylvania | 42071 | 157 | 3 |
27789 | 27789 | 2020-04-02 | Lancaster | Pennsylvania | 42071 | 203 | 4 |
30123 | 30123 | 2020-04-03 | Lancaster | Pennsylvania | 42071 | 232 | 5 |
32513 | 32513 | 2020-04-04 | Lancaster | Pennsylvania | 42071 | 291 | 5 |
34949 | 34949 | 2020-04-05 | Lancaster | Pennsylvania | 42071 | 371 | 8 |
37424 | 37424 | 2020-04-06 | Lancaster | Pennsylvania | 42071 | 408 | 11 |
39947 | 39947 | 2020-04-07 | Lancaster | Pennsylvania | 42071 | 490 | 14 |
42507 | 42507 | 2020-04-08 | Lancaster | Pennsylvania | 42071 | 561 | 16 |
45093 | 45093 | 2020-04-09 | Lancaster | Pennsylvania | 42071 | 596 | 17 |
47710 | 47710 | 2020-04-10 | Lancaster | Pennsylvania | 42071 | 648 | 21 |
50367 | 50367 | 2020-04-11 | Lancaster | Pennsylvania | 42071 | 698 | 23 |
53040 | 53040 | 2020-04-12 | Lancaster | Pennsylvania | 42071 | 772 | 24 |
55725 | 55725 | 2020-04-13 | Lancaster | Pennsylvania | 42071 | 828 | 24 |
58428 | 58428 | 2020-04-14 | Lancaster | Pennsylvania | 42071 | 865 | 56 |
61143 | 61143 | 2020-04-15 | Lancaster | Pennsylvania | 42071 | 914 | 69 |
63869 | 63869 | 2020-04-16 | Lancaster | Pennsylvania | 42071 | 970 | 77 |
66615 | 66615 | 2020-04-17 | Lancaster | Pennsylvania | 42071 | 1030 | 85 |
69373 | 69373 | 2020-04-18 | Lancaster | Pennsylvania | 42071 | 1113 | 93 |
72140 | 72140 | 2020-04-19 | Lancaster | Pennsylvania | 42071 | 1188 | 98 |
74915 | 74915 | 2020-04-20 | Lancaster | Pennsylvania | 42071 | 1236 | 101 |
77697 | 77697 | 2020-04-21 | Lancaster | Pennsylvania | 42071 | 1295 | 107 |
80487 | 80487 | 2020-04-22 | Lancaster | Pennsylvania | 42071 | 1326 | 122 |
83286 | 83286 | 2020-04-23 | Lancaster | Pennsylvania | 42071 | 1359 | 131 |
86090 | 86090 | 2020-04-24 | Lancaster | Pennsylvania | 42071 | 1451 | 139 |
88904 | 88904 | 2020-04-25 | Lancaster | Pennsylvania | 42071 | 1501 | 140 |
91720 | 91720 | 2020-04-26 | Lancaster | Pennsylvania | 42071 | 1577 | 145 |
94547 | 94547 | 2020-04-27 | Lancaster | Pennsylvania | 42071 | 1633 | 152 |
97386 | 97386 | 2020-04-28 | Lancaster | Pennsylvania | 42071 | 1678 | 164 |
100235 | 100235 | 2020-04-29 | Lancaster | Pennsylvania | 42071 | 1703 | 170 |
103088 | 103088 | 2020-04-30 | Lancaster | Pennsylvania | 42071 | 1765 | 173 |
105951 | 105951 | 2020-05-01 | Lancaster | Pennsylvania | 42071 | 1820 | 183 |
108818 | 108818 | 2020-05-02 | Lancaster | Pennsylvania | 42071 | 1904 | 188 |
111692 | 111692 | 2020-05-03 | Lancaster | Pennsylvania | 42071 | 1936 | 191 |
114574 | 114574 | 2020-05-04 | Lancaster | Pennsylvania | 42071 | 1991 | 198 |
117455 | 117455 | 2020-05-05 | Lancaster | Pennsylvania | 42071 | 2018 | 206 |
120417 | 120417 | 2020-05-06 | Lancaster | Pennsylvania | 42071 | 2041 | 209 |
123394 | 123394 | 2020-05-07 | Lancaster | Pennsylvania | 42071 | 2070 | 216 |
126377 | 126377 | 2020-05-08 | Lancaster | Pennsylvania | 42071 | 2122 | 222 |
129366 | 129366 | 2020-05-09 | Lancaster | Pennsylvania | 42071 | 2185 | 228 |
132355 | 132355 | 2020-05-10 | Lancaster | Pennsylvania | 42071 | 2223 | 233 |
135346 | 135346 | 2020-05-11 | Lancaster | Pennsylvania | 42071 | 2256 | 239 |
138336 | 138336 | 2020-05-12 | Lancaster | Pennsylvania | 42071 | 2295 | 241 |
141332 | 141332 | 2020-05-13 | Lancaster | Pennsylvania | 42071 | 2325 | 245 |
144328 | 144328 | 2020-05-14 | Lancaster | Pennsylvania | 42071 | 2364 | 249 |
147329 | 147329 | 2020-05-15 | Lancaster | Pennsylvania | 42071 | 2428 | 253 |
150336 | 150336 | 2020-05-16 | Lancaster | Pennsylvania | 42071 | 2470 | 255 |
153347 | 153347 | 2020-05-17 | Lancaster | Pennsylvania | 42071 | 2508 | 258 |
156364 | 156364 | 2020-05-18 | Lancaster | Pennsylvania | 42071 | 2552 | 263 |
159385 | 159385 | 2020-05-19 | Lancaster | Pennsylvania | 42071 | 2593 | 267 |
162412 | 162412 | 2020-05-20 | Lancaster | Pennsylvania | 42071 | 2599 | 271 |
165441 | 165441 | 2020-05-21 | Lancaster | Pennsylvania | 42071 | 2690 | 277 |
168477 | 168477 | 2020-05-22 | Lancaster | Pennsylvania | 42071 | 2736 | 278 |
171516 | 171516 | 2020-05-23 | Lancaster | Pennsylvania | 42071 | 2790 | 280 |
174558 | 174558 | 2020-05-24 | Lancaster | Pennsylvania | 42071 | 2854 | 281 |
177602 | 177602 | 2020-05-25 | Lancaster | Pennsylvania | 42071 | 2896 | 281 |
180645 | 180645 | 2020-05-26 | Lancaster | Pennsylvania | 42071 | 2985 | 283 |
183695 | 183695 | 2020-05-27 | Lancaster | Pennsylvania | 42071 | 3031 | 285 |
186752 | 186752 | 2020-05-28 | Lancaster | Pennsylvania | 42071 | 3056 | 291 |
189813 | 189813 | 2020-05-29 | Lancaster | Pennsylvania | 42071 | 3105 | 292 |
192878 | 192878 | 2020-05-30 | Lancaster | Pennsylvania | 42071 | 3131 | 295 |
195947 | 195947 | 2020-05-31 | Lancaster | Pennsylvania | 42071 | 3161 | 297 |
199020 | 199020 | 2020-06-01 | Lancaster | Pennsylvania | 42071 | 3189 | 297 |
202095 | 202095 | 2020-06-02 | Lancaster | Pennsylvania | 42071 | 3218 | 306 |
205172 | 205172 | 2020-06-03 | Lancaster | Pennsylvania | 42071 | 3267 | 310 |
208253 | 208253 | 2020-06-04 | Lancaster | Pennsylvania | 42071 | 3301 | 315 |
211335 | 211335 | 2020-06-05 | Lancaster | Pennsylvania | 42071 | 3337 | 317 |
214421 | 214421 | 2020-06-06 | Lancaster | Pennsylvania | 42071 | 3404 | 317 |
217511 | 217511 | 2020-06-07 | Lancaster | Pennsylvania | 42071 | 3461 | 318 |
220603 | 220603 | 2020-06-08 | Lancaster | Pennsylvania | 42071 | 3503 | 318 |
223698 | 223698 | 2020-06-09 | Lancaster | Pennsylvania | 42071 | 3554 | 320 |
226798 | 226798 | 2020-06-10 | Lancaster | Pennsylvania | 42071 | 3600 | 322 |
229902 | 229902 | 2020-06-11 | Lancaster | Pennsylvania | 42071 | 3632 | 322 |
233007 | 233007 | 2020-06-12 | Lancaster | Pennsylvania | 42071 | 3682 | 325 |
236112 | 236112 | 2020-06-13 | Lancaster | Pennsylvania | 42071 | 3719 | 329 |
239220 | 239220 | 2020-06-14 | Lancaster | Pennsylvania | 42071 | 3752 | 329 |
242329 | 242329 | 2020-06-15 | Lancaster | Pennsylvania | 42071 | 3777 | 331 |
245441 | 245441 | 2020-06-16 | Lancaster | Pennsylvania | 42071 | 3802 | 333 |
248554 | 248554 | 2020-06-17 | Lancaster | Pennsylvania | 42071 | 3830 | 336 |
251669 | 251669 | 2020-06-18 | Lancaster | Pennsylvania | 42071 | 3867 | 341 |
254784 | 254784 | 2020-06-19 | Lancaster | Pennsylvania | 42071 | 3911 | 344 |
257910 | 257910 | 2020-06-20 | Lancaster | Pennsylvania | 42071 | 3949 | 346 |
261037 | 261037 | 2020-06-21 | Lancaster | Pennsylvania | 42071 | 3999 | 346 |
264165 | 264165 | 2020-06-22 | Lancaster | Pennsylvania | 42071 | 4029 | 347 |
267293 | 267293 | 2020-06-23 | Lancaster | Pennsylvania | 42071 | 4106 | 350 |
270427 | 270427 | 2020-06-24 | Lancaster | Pennsylvania | 42071 | 4152 | 352 |
273566 | 273566 | 2020-06-25 | Lancaster | Pennsylvania | 42071 | 4212 | 354 |
276713 | 276713 | 2020-06-26 | Lancaster | Pennsylvania | 42071 | 4280 | 354 |
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);