ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Lackawanna" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388211 | 388211 | 2020-07-31 | Lackawanna | Pennsylvania | 42069 | 1894 | 212 |
384994 | 384994 | 2020-07-30 | Lackawanna | Pennsylvania | 42069 | 1885 | 212 |
381776 | 381776 | 2020-07-29 | Lackawanna | Pennsylvania | 42069 | 1878 | 212 |
378559 | 378559 | 2020-07-28 | Lackawanna | Pennsylvania | 42069 | 1866 | 212 |
375343 | 375343 | 2020-07-27 | Lackawanna | Pennsylvania | 42069 | 1860 | 212 |
372130 | 372130 | 2020-07-26 | Lackawanna | Pennsylvania | 42069 | 1854 | 212 |
368918 | 368918 | 2020-07-25 | Lackawanna | Pennsylvania | 42069 | 1851 | 212 |
365709 | 365709 | 2020-07-24 | Lackawanna | Pennsylvania | 42069 | 1845 | 212 |
362503 | 362503 | 2020-07-23 | Lackawanna | Pennsylvania | 42069 | 1833 | 212 |
359297 | 359297 | 2020-07-22 | Lackawanna | Pennsylvania | 42069 | 1823 | 212 |
356093 | 356093 | 2020-07-21 | Lackawanna | Pennsylvania | 42069 | 1817 | 212 |
352890 | 352890 | 2020-07-20 | Lackawanna | Pennsylvania | 42069 | 1808 | 212 |
349687 | 349687 | 2020-07-19 | Lackawanna | Pennsylvania | 42069 | 1805 | 212 |
346487 | 346487 | 2020-07-18 | Lackawanna | Pennsylvania | 42069 | 1796 | 212 |
343287 | 343287 | 2020-07-17 | Lackawanna | Pennsylvania | 42069 | 1788 | 212 |
340089 | 340089 | 2020-07-16 | Lackawanna | Pennsylvania | 42069 | 1777 | 212 |
336892 | 336892 | 2020-07-15 | Lackawanna | Pennsylvania | 42069 | 1771 | 211 |
333698 | 333698 | 2020-07-14 | Lackawanna | Pennsylvania | 42069 | 1770 | 211 |
330506 | 330506 | 2020-07-13 | Lackawanna | Pennsylvania | 42069 | 1764 | 209 |
327320 | 327320 | 2020-07-12 | Lackawanna | Pennsylvania | 42069 | 1761 | 209 |
324135 | 324135 | 2020-07-11 | Lackawanna | Pennsylvania | 42069 | 1756 | 209 |
320955 | 320955 | 2020-07-10 | Lackawanna | Pennsylvania | 42069 | 1753 | 209 |
317777 | 317777 | 2020-07-09 | Lackawanna | Pennsylvania | 42069 | 1749 | 209 |
314604 | 314604 | 2020-07-08 | Lackawanna | Pennsylvania | 42069 | 1743 | 208 |
311432 | 311432 | 2020-07-07 | Lackawanna | Pennsylvania | 42069 | 1740 | 207 |
308263 | 308263 | 2020-07-06 | Lackawanna | Pennsylvania | 42069 | 1734 | 207 |
305096 | 305096 | 2020-07-05 | Lackawanna | Pennsylvania | 42069 | 1733 | 207 |
301933 | 301933 | 2020-07-04 | Lackawanna | Pennsylvania | 42069 | 1725 | 207 |
298769 | 298769 | 2020-07-03 | Lackawanna | Pennsylvania | 42069 | 1719 | 207 |
295610 | 295610 | 2020-07-02 | Lackawanna | Pennsylvania | 42069 | 1714 | 204 |
292454 | 292454 | 2020-07-01 | Lackawanna | Pennsylvania | 42069 | 1707 | 203 |
289302 | 289302 | 2020-06-30 | Lackawanna | Pennsylvania | 42069 | 1703 | 203 |
286151 | 286151 | 2020-06-29 | Lackawanna | Pennsylvania | 42069 | 1694 | 202 |
283006 | 283006 | 2020-06-28 | Lackawanna | Pennsylvania | 42069 | 1684 | 202 |
279860 | 279860 | 2020-06-27 | Lackawanna | Pennsylvania | 42069 | 1680 | 202 |
276712 | 276712 | 2020-06-26 | Lackawanna | Pennsylvania | 42069 | 1662 | 202 |
273565 | 273565 | 2020-06-25 | Lackawanna | Pennsylvania | 42069 | 1648 | 202 |
270426 | 270426 | 2020-06-24 | Lackawanna | Pennsylvania | 42069 | 1638 | 201 |
267292 | 267292 | 2020-06-23 | Lackawanna | Pennsylvania | 42069 | 1630 | 200 |
264164 | 264164 | 2020-06-22 | Lackawanna | Pennsylvania | 42069 | 1627 | 200 |
261036 | 261036 | 2020-06-21 | Lackawanna | Pennsylvania | 42069 | 1622 | 200 |
257909 | 257909 | 2020-06-20 | Lackawanna | Pennsylvania | 42069 | 1622 | 200 |
254783 | 254783 | 2020-06-19 | Lackawanna | Pennsylvania | 42069 | 1617 | 200 |
251668 | 251668 | 2020-06-18 | Lackawanna | Pennsylvania | 42069 | 1611 | 200 |
248553 | 248553 | 2020-06-17 | Lackawanna | Pennsylvania | 42069 | 1611 | 199 |
245440 | 245440 | 2020-06-16 | Lackawanna | Pennsylvania | 42069 | 1608 | 197 |
242328 | 242328 | 2020-06-15 | Lackawanna | Pennsylvania | 42069 | 1602 | 196 |
239219 | 239219 | 2020-06-14 | Lackawanna | Pennsylvania | 42069 | 1601 | 194 |
236111 | 236111 | 2020-06-13 | Lackawanna | Pennsylvania | 42069 | 1600 | 194 |
233006 | 233006 | 2020-06-12 | Lackawanna | Pennsylvania | 42069 | 1598 | 191 |
229901 | 229901 | 2020-06-11 | Lackawanna | Pennsylvania | 42069 | 1595 | 191 |
226797 | 226797 | 2020-06-10 | Lackawanna | Pennsylvania | 42069 | 1591 | 189 |
223697 | 223697 | 2020-06-09 | Lackawanna | Pennsylvania | 42069 | 1587 | 189 |
220602 | 220602 | 2020-06-08 | Lackawanna | Pennsylvania | 42069 | 1584 | 188 |
217510 | 217510 | 2020-06-07 | Lackawanna | Pennsylvania | 42069 | 1583 | 187 |
214420 | 214420 | 2020-06-06 | Lackawanna | Pennsylvania | 42069 | 1579 | 187 |
211334 | 211334 | 2020-06-05 | Lackawanna | Pennsylvania | 42069 | 1575 | 185 |
208252 | 208252 | 2020-06-04 | Lackawanna | Pennsylvania | 42069 | 1569 | 182 |
205171 | 205171 | 2020-06-03 | Lackawanna | Pennsylvania | 42069 | 1556 | 180 |
202094 | 202094 | 2020-06-02 | Lackawanna | Pennsylvania | 42069 | 1555 | 174 |
199019 | 199019 | 2020-06-01 | Lackawanna | Pennsylvania | 42069 | 1551 | 171 |
195946 | 195946 | 2020-05-31 | Lackawanna | Pennsylvania | 42069 | 1547 | 170 |
192877 | 192877 | 2020-05-30 | Lackawanna | Pennsylvania | 42069 | 1543 | 170 |
189812 | 189812 | 2020-05-29 | Lackawanna | Pennsylvania | 42069 | 1528 | 166 |
186751 | 186751 | 2020-05-28 | Lackawanna | Pennsylvania | 42069 | 1516 | 163 |
183694 | 183694 | 2020-05-27 | Lackawanna | Pennsylvania | 42069 | 1511 | 159 |
180644 | 180644 | 2020-05-26 | Lackawanna | Pennsylvania | 42069 | 1503 | 155 |
177601 | 177601 | 2020-05-25 | Lackawanna | Pennsylvania | 42069 | 1494 | 153 |
174557 | 174557 | 2020-05-24 | Lackawanna | Pennsylvania | 42069 | 1491 | 153 |
171515 | 171515 | 2020-05-23 | Lackawanna | Pennsylvania | 42069 | 1476 | 152 |
168476 | 168476 | 2020-05-22 | Lackawanna | Pennsylvania | 42069 | 1451 | 148 |
165440 | 165440 | 2020-05-21 | Lackawanna | Pennsylvania | 42069 | 1432 | 137 |
162411 | 162411 | 2020-05-20 | Lackawanna | Pennsylvania | 42069 | 1400 | 132 |
159384 | 159384 | 2020-05-19 | Lackawanna | Pennsylvania | 42069 | 1374 | 127 |
156363 | 156363 | 2020-05-18 | Lackawanna | Pennsylvania | 42069 | 1363 | 125 |
153346 | 153346 | 2020-05-17 | Lackawanna | Pennsylvania | 42069 | 1344 | 149 |
150335 | 150335 | 2020-05-16 | Lackawanna | Pennsylvania | 42069 | 1327 | 147 |
147328 | 147328 | 2020-05-15 | Lackawanna | Pennsylvania | 42069 | 1273 | 141 |
144327 | 144327 | 2020-05-14 | Lackawanna | Pennsylvania | 42069 | 1256 | 135 |
141331 | 141331 | 2020-05-13 | Lackawanna | Pennsylvania | 42069 | 1232 | 128 |
138335 | 138335 | 2020-05-12 | Lackawanna | Pennsylvania | 42069 | 1211 | 124 |
135345 | 135345 | 2020-05-11 | Lackawanna | Pennsylvania | 42069 | 1187 | 117 |
132354 | 132354 | 2020-05-10 | Lackawanna | Pennsylvania | 42069 | 1172 | 117 |
129365 | 129365 | 2020-05-09 | Lackawanna | Pennsylvania | 42069 | 1134 | 115 |
126376 | 126376 | 2020-05-08 | Lackawanna | Pennsylvania | 42069 | 1114 | 113 |
123393 | 123393 | 2020-05-07 | Lackawanna | Pennsylvania | 42069 | 1093 | 112 |
120416 | 120416 | 2020-05-06 | Lackawanna | Pennsylvania | 42069 | 1076 | 106 |
117454 | 117454 | 2020-05-05 | Lackawanna | Pennsylvania | 42069 | 1038 | 103 |
114573 | 114573 | 2020-05-04 | Lackawanna | Pennsylvania | 42069 | 1017 | 87 |
111691 | 111691 | 2020-05-03 | Lackawanna | Pennsylvania | 42069 | 999 | 86 |
108817 | 108817 | 2020-05-02 | Lackawanna | Pennsylvania | 42069 | 968 | 83 |
105950 | 105950 | 2020-05-01 | Lackawanna | Pennsylvania | 42069 | 934 | 83 |
103087 | 103087 | 2020-04-30 | Lackawanna | Pennsylvania | 42069 | 913 | 82 |
100234 | 100234 | 2020-04-29 | Lackawanna | Pennsylvania | 42069 | 873 | 81 |
97385 | 97385 | 2020-04-28 | Lackawanna | Pennsylvania | 42069 | 854 | 71 |
94546 | 94546 | 2020-04-27 | Lackawanna | Pennsylvania | 42069 | 833 | 63 |
91719 | 91719 | 2020-04-26 | Lackawanna | Pennsylvania | 42069 | 793 | 63 |
88903 | 88903 | 2020-04-25 | Lackawanna | Pennsylvania | 42069 | 772 | 63 |
86089 | 86089 | 2020-04-24 | Lackawanna | Pennsylvania | 42069 | 735 | 61 |
83285 | 83285 | 2020-04-23 | Lackawanna | Pennsylvania | 42069 | 707 | 58 |
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);