ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Adams" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388177 | 388177 | 2020-07-31 | Adams | Pennsylvania | 42001 | 462 | 20 |
384960 | 384960 | 2020-07-30 | Adams | Pennsylvania | 42001 | 461 | 19 |
381742 | 381742 | 2020-07-29 | Adams | Pennsylvania | 42001 | 454 | 18 |
378525 | 378525 | 2020-07-28 | Adams | Pennsylvania | 42001 | 448 | 18 |
375309 | 375309 | 2020-07-27 | Adams | Pennsylvania | 42001 | 442 | 17 |
372096 | 372096 | 2020-07-26 | Adams | Pennsylvania | 42001 | 442 | 17 |
368884 | 368884 | 2020-07-25 | Adams | Pennsylvania | 42001 | 442 | 17 |
365675 | 365675 | 2020-07-24 | Adams | Pennsylvania | 42001 | 441 | 17 |
362469 | 362469 | 2020-07-23 | Adams | Pennsylvania | 42001 | 437 | 16 |
359263 | 359263 | 2020-07-22 | Adams | Pennsylvania | 42001 | 424 | 15 |
356059 | 356059 | 2020-07-21 | Adams | Pennsylvania | 42001 | 421 | 15 |
352856 | 352856 | 2020-07-20 | Adams | Pennsylvania | 42001 | 414 | 15 |
349653 | 349653 | 2020-07-19 | Adams | Pennsylvania | 42001 | 413 | 15 |
346453 | 346453 | 2020-07-18 | Adams | Pennsylvania | 42001 | 412 | 15 |
343253 | 343253 | 2020-07-17 | Adams | Pennsylvania | 42001 | 410 | 15 |
340055 | 340055 | 2020-07-16 | Adams | Pennsylvania | 42001 | 409 | 14 |
336858 | 336858 | 2020-07-15 | Adams | Pennsylvania | 42001 | 399 | 14 |
333664 | 333664 | 2020-07-14 | Adams | Pennsylvania | 42001 | 399 | 14 |
330472 | 330472 | 2020-07-13 | Adams | Pennsylvania | 42001 | 398 | 14 |
327286 | 327286 | 2020-07-12 | Adams | Pennsylvania | 42001 | 396 | 14 |
324101 | 324101 | 2020-07-11 | Adams | Pennsylvania | 42001 | 385 | 14 |
320921 | 320921 | 2020-07-10 | Adams | Pennsylvania | 42001 | 377 | 14 |
317743 | 317743 | 2020-07-09 | Adams | Pennsylvania | 42001 | 366 | 13 |
314570 | 314570 | 2020-07-08 | Adams | Pennsylvania | 42001 | 361 | 13 |
311398 | 311398 | 2020-07-07 | Adams | Pennsylvania | 42001 | 358 | 13 |
308229 | 308229 | 2020-07-06 | Adams | Pennsylvania | 42001 | 352 | 13 |
305062 | 305062 | 2020-07-05 | Adams | Pennsylvania | 42001 | 352 | 13 |
301899 | 301899 | 2020-07-04 | Adams | Pennsylvania | 42001 | 349 | 13 |
298735 | 298735 | 2020-07-03 | Adams | Pennsylvania | 42001 | 344 | 13 |
295576 | 295576 | 2020-07-02 | Adams | Pennsylvania | 42001 | 342 | 13 |
292420 | 292420 | 2020-07-01 | Adams | Pennsylvania | 42001 | 341 | 12 |
289268 | 289268 | 2020-06-30 | Adams | Pennsylvania | 42001 | 339 | 12 |
286117 | 286117 | 2020-06-29 | Adams | Pennsylvania | 42001 | 332 | 12 |
282972 | 282972 | 2020-06-28 | Adams | Pennsylvania | 42001 | 328 | 12 |
279826 | 279826 | 2020-06-27 | Adams | Pennsylvania | 42001 | 327 | 12 |
276678 | 276678 | 2020-06-26 | Adams | Pennsylvania | 42001 | 324 | 12 |
273531 | 273531 | 2020-06-25 | Adams | Pennsylvania | 42001 | 323 | 12 |
270392 | 270392 | 2020-06-24 | Adams | Pennsylvania | 42001 | 321 | 12 |
267258 | 267258 | 2020-06-23 | Adams | Pennsylvania | 42001 | 322 | 12 |
264130 | 264130 | 2020-06-22 | Adams | Pennsylvania | 42001 | 317 | 11 |
261002 | 261002 | 2020-06-21 | Adams | Pennsylvania | 42001 | 314 | 11 |
257875 | 257875 | 2020-06-20 | Adams | Pennsylvania | 42001 | 311 | 11 |
254749 | 254749 | 2020-06-19 | Adams | Pennsylvania | 42001 | 309 | 11 |
251634 | 251634 | 2020-06-18 | Adams | Pennsylvania | 42001 | 304 | 11 |
248519 | 248519 | 2020-06-17 | Adams | Pennsylvania | 42001 | 300 | 10 |
245406 | 245406 | 2020-06-16 | Adams | Pennsylvania | 42001 | 298 | 10 |
242294 | 242294 | 2020-06-15 | Adams | Pennsylvania | 42001 | 296 | 9 |
239185 | 239185 | 2020-06-14 | Adams | Pennsylvania | 42001 | 290 | 9 |
236077 | 236077 | 2020-06-13 | Adams | Pennsylvania | 42001 | 289 | 9 |
232972 | 232972 | 2020-06-12 | Adams | Pennsylvania | 42001 | 284 | 9 |
229867 | 229867 | 2020-06-11 | Adams | Pennsylvania | 42001 | 279 | 9 |
226763 | 226763 | 2020-06-10 | Adams | Pennsylvania | 42001 | 278 | 9 |
223663 | 223663 | 2020-06-09 | Adams | Pennsylvania | 42001 | 275 | 9 |
220568 | 220568 | 2020-06-08 | Adams | Pennsylvania | 42001 | 275 | 8 |
217476 | 217476 | 2020-06-07 | Adams | Pennsylvania | 42001 | 273 | 8 |
214386 | 214386 | 2020-06-06 | Adams | Pennsylvania | 42001 | 269 | 8 |
211300 | 211300 | 2020-06-05 | Adams | Pennsylvania | 42001 | 264 | 8 |
208218 | 208218 | 2020-06-04 | Adams | Pennsylvania | 42001 | 263 | 8 |
205137 | 205137 | 2020-06-03 | Adams | Pennsylvania | 42001 | 260 | 8 |
202060 | 202060 | 2020-06-02 | Adams | Pennsylvania | 42001 | 255 | 8 |
198985 | 198985 | 2020-06-01 | Adams | Pennsylvania | 42001 | 250 | 8 |
195912 | 195912 | 2020-05-31 | Adams | Pennsylvania | 42001 | 251 | 8 |
192843 | 192843 | 2020-05-30 | Adams | Pennsylvania | 42001 | 245 | 8 |
189778 | 189778 | 2020-05-29 | Adams | Pennsylvania | 42001 | 241 | 7 |
186717 | 186717 | 2020-05-28 | Adams | Pennsylvania | 42001 | 240 | 7 |
183660 | 183660 | 2020-05-27 | Adams | Pennsylvania | 42001 | 236 | 7 |
180610 | 180610 | 2020-05-26 | Adams | Pennsylvania | 42001 | 233 | 7 |
177567 | 177567 | 2020-05-25 | Adams | Pennsylvania | 42001 | 227 | 7 |
174523 | 174523 | 2020-05-24 | Adams | Pennsylvania | 42001 | 226 | 7 |
171481 | 171481 | 2020-05-23 | Adams | Pennsylvania | 42001 | 222 | 6 |
168442 | 168442 | 2020-05-22 | Adams | Pennsylvania | 42001 | 214 | 5 |
165406 | 165406 | 2020-05-21 | Adams | Pennsylvania | 42001 | 204 | 5 |
162377 | 162377 | 2020-05-20 | Adams | Pennsylvania | 42001 | 197 | 5 |
159350 | 159350 | 2020-05-19 | Adams | Pennsylvania | 42001 | 194 | 5 |
156329 | 156329 | 2020-05-18 | Adams | Pennsylvania | 42001 | 194 | 5 |
153312 | 153312 | 2020-05-17 | Adams | Pennsylvania | 42001 | 189 | 6 |
150301 | 150301 | 2020-05-16 | Adams | Pennsylvania | 42001 | 185 | 6 |
147294 | 147294 | 2020-05-15 | Adams | Pennsylvania | 42001 | 183 | 6 |
144293 | 144293 | 2020-05-14 | Adams | Pennsylvania | 42001 | 174 | 5 |
141297 | 141297 | 2020-05-13 | Adams | Pennsylvania | 42001 | 169 | 5 |
138301 | 138301 | 2020-05-12 | Adams | Pennsylvania | 42001 | 167 | 5 |
135311 | 135311 | 2020-05-11 | Adams | Pennsylvania | 42001 | 167 | 5 |
132320 | 132320 | 2020-05-10 | Adams | Pennsylvania | 42001 | 159 | 5 |
129331 | 129331 | 2020-05-09 | Adams | Pennsylvania | 42001 | 156 | 5 |
126342 | 126342 | 2020-05-08 | Adams | Pennsylvania | 42001 | 154 | 5 |
123359 | 123359 | 2020-05-07 | Adams | Pennsylvania | 42001 | 151 | 5 |
120382 | 120382 | 2020-05-06 | Adams | Pennsylvania | 42001 | 148 | 5 |
117420 | 117420 | 2020-05-05 | Adams | Pennsylvania | 42001 | 148 | 5 |
114539 | 114539 | 2020-05-04 | Adams | Pennsylvania | 42001 | 148 | 4 |
111657 | 111657 | 2020-05-03 | Adams | Pennsylvania | 42001 | 145 | 4 |
108783 | 108783 | 2020-05-02 | Adams | Pennsylvania | 42001 | 141 | 4 |
105916 | 105916 | 2020-05-01 | Adams | Pennsylvania | 42001 | 140 | 4 |
103053 | 103053 | 2020-04-30 | Adams | Pennsylvania | 42001 | 137 | 4 |
100200 | 100200 | 2020-04-29 | Adams | Pennsylvania | 42001 | 130 | 4 |
97351 | 97351 | 2020-04-28 | Adams | Pennsylvania | 42001 | 124 | 2 |
94512 | 94512 | 2020-04-27 | Adams | Pennsylvania | 42001 | 122 | 2 |
91685 | 91685 | 2020-04-26 | Adams | Pennsylvania | 42001 | 117 | 2 |
88869 | 88869 | 2020-04-25 | Adams | Pennsylvania | 42001 | 113 | 2 |
86055 | 86055 | 2020-04-24 | Adams | Pennsylvania | 42001 | 110 | 2 |
83251 | 83251 | 2020-04-23 | Adams | Pennsylvania | 42001 | 95 | 2 |
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);