ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42105 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388229 | 388229 | 2020-07-31 | Potter | Pennsylvania | 42105 | 20 | 0 |
385012 | 385012 | 2020-07-30 | Potter | Pennsylvania | 42105 | 20 | 0 |
381794 | 381794 | 2020-07-29 | Potter | Pennsylvania | 42105 | 20 | 0 |
378577 | 378577 | 2020-07-28 | Potter | Pennsylvania | 42105 | 20 | 0 |
375361 | 375361 | 2020-07-27 | Potter | Pennsylvania | 42105 | 20 | 0 |
372148 | 372148 | 2020-07-26 | Potter | Pennsylvania | 42105 | 20 | 0 |
368936 | 368936 | 2020-07-25 | Potter | Pennsylvania | 42105 | 20 | 0 |
365727 | 365727 | 2020-07-24 | Potter | Pennsylvania | 42105 | 20 | 0 |
362521 | 362521 | 2020-07-23 | Potter | Pennsylvania | 42105 | 20 | 0 |
359315 | 359315 | 2020-07-22 | Potter | Pennsylvania | 42105 | 20 | 0 |
356111 | 356111 | 2020-07-21 | Potter | Pennsylvania | 42105 | 19 | 0 |
352908 | 352908 | 2020-07-20 | Potter | Pennsylvania | 42105 | 19 | 0 |
349705 | 349705 | 2020-07-19 | Potter | Pennsylvania | 42105 | 19 | 0 |
346505 | 346505 | 2020-07-18 | Potter | Pennsylvania | 42105 | 19 | 0 |
343305 | 343305 | 2020-07-17 | Potter | Pennsylvania | 42105 | 19 | 0 |
340107 | 340107 | 2020-07-16 | Potter | Pennsylvania | 42105 | 19 | 0 |
336910 | 336910 | 2020-07-15 | Potter | Pennsylvania | 42105 | 19 | 0 |
333716 | 333716 | 2020-07-14 | Potter | Pennsylvania | 42105 | 18 | 0 |
330524 | 330524 | 2020-07-13 | Potter | Pennsylvania | 42105 | 18 | 0 |
327338 | 327338 | 2020-07-12 | Potter | Pennsylvania | 42105 | 18 | 0 |
324153 | 324153 | 2020-07-11 | Potter | Pennsylvania | 42105 | 18 | 0 |
320973 | 320973 | 2020-07-10 | Potter | Pennsylvania | 42105 | 17 | 0 |
317795 | 317795 | 2020-07-09 | Potter | Pennsylvania | 42105 | 17 | 0 |
314622 | 314622 | 2020-07-08 | Potter | Pennsylvania | 42105 | 17 | 0 |
311450 | 311450 | 2020-07-07 | Potter | Pennsylvania | 42105 | 17 | 0 |
308281 | 308281 | 2020-07-06 | Potter | Pennsylvania | 42105 | 17 | 0 |
305114 | 305114 | 2020-07-05 | Potter | Pennsylvania | 42105 | 17 | 0 |
301951 | 301951 | 2020-07-04 | Potter | Pennsylvania | 42105 | 17 | 0 |
298787 | 298787 | 2020-07-03 | Potter | Pennsylvania | 42105 | 17 | 0 |
295628 | 295628 | 2020-07-02 | Potter | Pennsylvania | 42105 | 16 | 0 |
292472 | 292472 | 2020-07-01 | Potter | Pennsylvania | 42105 | 16 | 0 |
289320 | 289320 | 2020-06-30 | Potter | Pennsylvania | 42105 | 15 | 0 |
286169 | 286169 | 2020-06-29 | Potter | Pennsylvania | 42105 | 15 | 0 |
283024 | 283024 | 2020-06-28 | Potter | Pennsylvania | 42105 | 15 | 0 |
279878 | 279878 | 2020-06-27 | Potter | Pennsylvania | 42105 | 15 | 0 |
276730 | 276730 | 2020-06-26 | Potter | Pennsylvania | 42105 | 15 | 0 |
273583 | 273583 | 2020-06-25 | Potter | Pennsylvania | 42105 | 14 | 0 |
270444 | 270444 | 2020-06-24 | Potter | Pennsylvania | 42105 | 14 | 0 |
267310 | 267310 | 2020-06-23 | Potter | Pennsylvania | 42105 | 13 | 0 |
264182 | 264182 | 2020-06-22 | Potter | Pennsylvania | 42105 | 13 | 0 |
261054 | 261054 | 2020-06-21 | Potter | Pennsylvania | 42105 | 13 | 0 |
257927 | 257927 | 2020-06-20 | Potter | Pennsylvania | 42105 | 13 | 0 |
254801 | 254801 | 2020-06-19 | Potter | Pennsylvania | 42105 | 13 | 0 |
251686 | 251686 | 2020-06-18 | Potter | Pennsylvania | 42105 | 13 | 0 |
248571 | 248571 | 2020-06-17 | Potter | Pennsylvania | 42105 | 13 | 0 |
245458 | 245458 | 2020-06-16 | Potter | Pennsylvania | 42105 | 13 | 0 |
242346 | 242346 | 2020-06-15 | Potter | Pennsylvania | 42105 | 13 | 0 |
239237 | 239237 | 2020-06-14 | Potter | Pennsylvania | 42105 | 13 | 0 |
236129 | 236129 | 2020-06-13 | Potter | Pennsylvania | 42105 | 13 | 0 |
233024 | 233024 | 2020-06-12 | Potter | Pennsylvania | 42105 | 13 | 0 |
229919 | 229919 | 2020-06-11 | Potter | Pennsylvania | 42105 | 12 | 0 |
226815 | 226815 | 2020-06-10 | Potter | Pennsylvania | 42105 | 12 | 0 |
223715 | 223715 | 2020-06-09 | Potter | Pennsylvania | 42105 | 11 | 0 |
220620 | 220620 | 2020-06-08 | Potter | Pennsylvania | 42105 | 11 | 0 |
217528 | 217528 | 2020-06-07 | Potter | Pennsylvania | 42105 | 11 | 0 |
214438 | 214438 | 2020-06-06 | Potter | Pennsylvania | 42105 | 11 | 0 |
211352 | 211352 | 2020-06-05 | Potter | Pennsylvania | 42105 | 8 | 0 |
208270 | 208270 | 2020-06-04 | Potter | Pennsylvania | 42105 | 6 | 0 |
205189 | 205189 | 2020-06-03 | Potter | Pennsylvania | 42105 | 4 | 0 |
202112 | 202112 | 2020-06-02 | Potter | Pennsylvania | 42105 | 4 | 0 |
199037 | 199037 | 2020-06-01 | Potter | Pennsylvania | 42105 | 4 | 0 |
195964 | 195964 | 2020-05-31 | Potter | Pennsylvania | 42105 | 4 | 0 |
192895 | 192895 | 2020-05-30 | Potter | Pennsylvania | 42105 | 4 | 0 |
189830 | 189830 | 2020-05-29 | Potter | Pennsylvania | 42105 | 4 | 0 |
186769 | 186769 | 2020-05-28 | Potter | Pennsylvania | 42105 | 4 | 0 |
183712 | 183712 | 2020-05-27 | Potter | Pennsylvania | 42105 | 4 | 0 |
180662 | 180662 | 2020-05-26 | Potter | Pennsylvania | 42105 | 4 | 0 |
177619 | 177619 | 2020-05-25 | Potter | Pennsylvania | 42105 | 4 | 0 |
174575 | 174575 | 2020-05-24 | Potter | Pennsylvania | 42105 | 4 | 0 |
171533 | 171533 | 2020-05-23 | Potter | Pennsylvania | 42105 | 4 | 0 |
168494 | 168494 | 2020-05-22 | Potter | Pennsylvania | 42105 | 4 | 0 |
165458 | 165458 | 2020-05-21 | Potter | Pennsylvania | 42105 | 4 | 0 |
162429 | 162429 | 2020-05-20 | Potter | Pennsylvania | 42105 | 4 | 0 |
159402 | 159402 | 2020-05-19 | Potter | Pennsylvania | 42105 | 4 | 0 |
156381 | 156381 | 2020-05-18 | Potter | Pennsylvania | 42105 | 4 | 0 |
153364 | 153364 | 2020-05-17 | Potter | Pennsylvania | 42105 | 4 | 0 |
150353 | 150353 | 2020-05-16 | Potter | Pennsylvania | 42105 | 4 | 0 |
147346 | 147346 | 2020-05-15 | Potter | Pennsylvania | 42105 | 4 | 0 |
144345 | 144345 | 2020-05-14 | Potter | Pennsylvania | 42105 | 4 | 0 |
141349 | 141349 | 2020-05-13 | Potter | Pennsylvania | 42105 | 4 | 0 |
138353 | 138353 | 2020-05-12 | Potter | Pennsylvania | 42105 | 4 | 0 |
135363 | 135363 | 2020-05-11 | Potter | Pennsylvania | 42105 | 4 | 0 |
132372 | 132372 | 2020-05-10 | Potter | Pennsylvania | 42105 | 4 | 0 |
129383 | 129383 | 2020-05-09 | Potter | Pennsylvania | 42105 | 4 | 0 |
126394 | 126394 | 2020-05-08 | Potter | Pennsylvania | 42105 | 4 | 0 |
123411 | 123411 | 2020-05-07 | Potter | Pennsylvania | 42105 | 4 | 0 |
120434 | 120434 | 2020-05-06 | Potter | Pennsylvania | 42105 | 4 | 0 |
117472 | 117472 | 2020-05-05 | Potter | Pennsylvania | 42105 | 4 | 0 |
114591 | 114591 | 2020-05-04 | Potter | Pennsylvania | 42105 | 4 | 0 |
111709 | 111709 | 2020-05-03 | Potter | Pennsylvania | 42105 | 4 | 0 |
108835 | 108835 | 2020-05-02 | Potter | Pennsylvania | 42105 | 4 | 0 |
105968 | 105968 | 2020-05-01 | Potter | Pennsylvania | 42105 | 4 | 0 |
103105 | 103105 | 2020-04-30 | Potter | Pennsylvania | 42105 | 4 | 0 |
100252 | 100252 | 2020-04-29 | Potter | Pennsylvania | 42105 | 4 | 0 |
97403 | 97403 | 2020-04-28 | Potter | Pennsylvania | 42105 | 4 | 0 |
94564 | 94564 | 2020-04-27 | Potter | Pennsylvania | 42105 | 4 | 0 |
91737 | 91737 | 2020-04-26 | Potter | Pennsylvania | 42105 | 4 | 0 |
88921 | 88921 | 2020-04-25 | Potter | Pennsylvania | 42105 | 4 | 0 |
86107 | 86107 | 2020-04-24 | Potter | Pennsylvania | 42105 | 4 | 0 |
83303 | 83303 | 2020-04-23 | Potter | Pennsylvania | 42105 | 4 | 0 |
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);