ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Delaware" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388199 | 388199 | 2020-07-31 | Delaware | Pennsylvania | 42045 | 8669 | 730 |
384982 | 384982 | 2020-07-30 | Delaware | Pennsylvania | 42045 | 8656 | 730 |
381764 | 381764 | 2020-07-29 | Delaware | Pennsylvania | 42045 | 8596 | 725 |
378547 | 378547 | 2020-07-28 | Delaware | Pennsylvania | 42045 | 8535 | 720 |
375331 | 375331 | 2020-07-27 | Delaware | Pennsylvania | 42045 | 8371 | 720 |
372118 | 372118 | 2020-07-26 | Delaware | Pennsylvania | 42045 | 8285 | 720 |
368906 | 368906 | 2020-07-25 | Delaware | Pennsylvania | 42045 | 8250 | 720 |
365697 | 365697 | 2020-07-24 | Delaware | Pennsylvania | 42045 | 8190 | 720 |
362491 | 362491 | 2020-07-23 | Delaware | Pennsylvania | 42045 | 8097 | 720 |
359285 | 359285 | 2020-07-22 | Delaware | Pennsylvania | 42045 | 8047 | 720 |
356081 | 356081 | 2020-07-21 | Delaware | Pennsylvania | 42045 | 7962 | 718 |
352878 | 352878 | 2020-07-20 | Delaware | Pennsylvania | 42045 | 7950 | 718 |
349675 | 349675 | 2020-07-19 | Delaware | Pennsylvania | 42045 | 7863 | 718 |
346475 | 346475 | 2020-07-18 | Delaware | Pennsylvania | 42045 | 7815 | 718 |
343275 | 343275 | 2020-07-17 | Delaware | Pennsylvania | 42045 | 7808 | 718 |
340077 | 340077 | 2020-07-16 | Delaware | Pennsylvania | 42045 | 7744 | 718 |
336880 | 336880 | 2020-07-15 | Delaware | Pennsylvania | 42045 | 7698 | 717 |
333686 | 333686 | 2020-07-14 | Delaware | Pennsylvania | 42045 | 7650 | 709 |
330494 | 330494 | 2020-07-13 | Delaware | Pennsylvania | 42045 | 7569 | 709 |
327308 | 327308 | 2020-07-12 | Delaware | Pennsylvania | 42045 | 7548 | 709 |
324123 | 324123 | 2020-07-11 | Delaware | Pennsylvania | 42045 | 7543 | 709 |
320943 | 320943 | 2020-07-10 | Delaware | Pennsylvania | 42045 | 7543 | 709 |
317765 | 317765 | 2020-07-09 | Delaware | Pennsylvania | 42045 | 7496 | 706 |
314592 | 314592 | 2020-07-08 | Delaware | Pennsylvania | 42045 | 7475 | 706 |
311420 | 311420 | 2020-07-07 | Delaware | Pennsylvania | 42045 | 7429 | 704 |
308251 | 308251 | 2020-07-06 | Delaware | Pennsylvania | 42045 | 7393 | 702 |
305084 | 305084 | 2020-07-05 | Delaware | Pennsylvania | 42045 | 7334 | 702 |
301921 | 301921 | 2020-07-04 | Delaware | Pennsylvania | 42045 | 7303 | 702 |
298757 | 298757 | 2020-07-03 | Delaware | Pennsylvania | 42045 | 7299 | 702 |
295598 | 295598 | 2020-07-02 | Delaware | Pennsylvania | 42045 | 7299 | 702 |
292442 | 292442 | 2020-07-01 | Delaware | Pennsylvania | 42045 | 7275 | 701 |
289290 | 289290 | 2020-06-30 | Delaware | Pennsylvania | 42045 | 7248 | 696 |
286139 | 286139 | 2020-06-29 | Delaware | Pennsylvania | 42045 | 7215 | 696 |
282994 | 282994 | 2020-06-28 | Delaware | Pennsylvania | 42045 | 7165 | 696 |
279848 | 279848 | 2020-06-27 | Delaware | Pennsylvania | 42045 | 7165 | 696 |
276700 | 276700 | 2020-06-26 | Delaware | Pennsylvania | 42045 | 7165 | 696 |
273553 | 273553 | 2020-06-25 | Delaware | Pennsylvania | 42045 | 7142 | 693 |
270414 | 270414 | 2020-06-24 | Delaware | Pennsylvania | 42045 | 7127 | 693 |
267280 | 267280 | 2020-06-23 | Delaware | Pennsylvania | 42045 | 7097 | 684 |
264152 | 264152 | 2020-06-22 | Delaware | Pennsylvania | 42045 | 7097 | 684 |
261024 | 261024 | 2020-06-21 | Delaware | Pennsylvania | 42045 | 7084 | 684 |
257897 | 257897 | 2020-06-20 | Delaware | Pennsylvania | 42045 | 7069 | 683 |
254771 | 254771 | 2020-06-19 | Delaware | Pennsylvania | 42045 | 7050 | 681 |
251656 | 251656 | 2020-06-18 | Delaware | Pennsylvania | 42045 | 7037 | 680 |
248541 | 248541 | 2020-06-17 | Delaware | Pennsylvania | 42045 | 7021 | 678 |
245428 | 245428 | 2020-06-16 | Delaware | Pennsylvania | 42045 | 6991 | 674 |
242316 | 242316 | 2020-06-15 | Delaware | Pennsylvania | 42045 | 6978 | 671 |
239207 | 239207 | 2020-06-14 | Delaware | Pennsylvania | 42045 | 6944 | 671 |
236099 | 236099 | 2020-06-13 | Delaware | Pennsylvania | 42045 | 6894 | 664 |
232994 | 232994 | 2020-06-12 | Delaware | Pennsylvania | 42045 | 6894 | 664 |
229889 | 229889 | 2020-06-11 | Delaware | Pennsylvania | 42045 | 6863 | 662 |
226785 | 226785 | 2020-06-10 | Delaware | Pennsylvania | 42045 | 6811 | 662 |
223685 | 223685 | 2020-06-09 | Delaware | Pennsylvania | 42045 | 6789 | 652 |
220590 | 220590 | 2020-06-08 | Delaware | Pennsylvania | 42045 | 6754 | 651 |
217498 | 217498 | 2020-06-07 | Delaware | Pennsylvania | 42045 | 6743 | 651 |
214408 | 214408 | 2020-06-06 | Delaware | Pennsylvania | 42045 | 6661 | 651 |
211322 | 211322 | 2020-06-05 | Delaware | Pennsylvania | 42045 | 6661 | 645 |
208240 | 208240 | 2020-06-04 | Delaware | Pennsylvania | 42045 | 6639 | 614 |
205159 | 205159 | 2020-06-03 | Delaware | Pennsylvania | 42045 | 6600 | 576 |
202082 | 202082 | 2020-06-02 | Delaware | Pennsylvania | 42045 | 6545 | 567 |
199007 | 199007 | 2020-06-01 | Delaware | Pennsylvania | 42045 | 6529 | 559 |
195934 | 195934 | 2020-05-31 | Delaware | Pennsylvania | 42045 | 6510 | 558 |
192865 | 192865 | 2020-05-30 | Delaware | Pennsylvania | 42045 | 6473 | 558 |
189800 | 189800 | 2020-05-29 | Delaware | Pennsylvania | 42045 | 6428 | 550 |
186739 | 186739 | 2020-05-28 | Delaware | Pennsylvania | 42045 | 6389 | 544 |
183682 | 183682 | 2020-05-27 | Delaware | Pennsylvania | 42045 | 6341 | 536 |
180632 | 180632 | 2020-05-26 | Delaware | Pennsylvania | 42045 | 6295 | 524 |
177589 | 177589 | 2020-05-25 | Delaware | Pennsylvania | 42045 | 6234 | 524 |
174545 | 174545 | 2020-05-24 | Delaware | Pennsylvania | 42045 | 6234 | 521 |
171503 | 171503 | 2020-05-23 | Delaware | Pennsylvania | 42045 | 6168 | 521 |
168464 | 168464 | 2020-05-22 | Delaware | Pennsylvania | 42045 | 6112 | 518 |
165428 | 165428 | 2020-05-21 | Delaware | Pennsylvania | 42045 | 5969 | 491 |
162399 | 162399 | 2020-05-20 | Delaware | Pennsylvania | 42045 | 5844 | 491 |
159372 | 159372 | 2020-05-19 | Delaware | Pennsylvania | 42045 | 5807 | 491 |
156351 | 156351 | 2020-05-18 | Delaware | Pennsylvania | 42045 | 5689 | 478 |
153334 | 153334 | 2020-05-17 | Delaware | Pennsylvania | 42045 | 5619 | 478 |
150323 | 150323 | 2020-05-16 | Delaware | Pennsylvania | 42045 | 5555 | 478 |
147316 | 147316 | 2020-05-15 | Delaware | Pennsylvania | 42045 | 5409 | 466 |
144315 | 144315 | 2020-05-14 | Delaware | Pennsylvania | 42045 | 5305 | 448 |
141319 | 141319 | 2020-05-13 | Delaware | Pennsylvania | 42045 | 5208 | 419 |
138323 | 138323 | 2020-05-12 | Delaware | Pennsylvania | 42045 | 5136 | 405 |
135333 | 135333 | 2020-05-11 | Delaware | Pennsylvania | 42045 | 5101 | 399 |
132342 | 132342 | 2020-05-10 | Delaware | Pennsylvania | 42045 | 5032 | 395 |
129353 | 129353 | 2020-05-09 | Delaware | Pennsylvania | 42045 | 4894 | 394 |
126364 | 126364 | 2020-05-08 | Delaware | Pennsylvania | 42045 | 4739 | 382 |
123381 | 123381 | 2020-05-07 | Delaware | Pennsylvania | 42045 | 4554 | 376 |
120404 | 120404 | 2020-05-06 | Delaware | Pennsylvania | 42045 | 4430 | 326 |
117442 | 117442 | 2020-05-05 | Delaware | Pennsylvania | 42045 | 4326 | 320 |
114561 | 114561 | 2020-05-04 | Delaware | Pennsylvania | 42045 | 4256 | 258 |
111679 | 111679 | 2020-05-03 | Delaware | Pennsylvania | 42045 | 4173 | 255 |
108805 | 108805 | 2020-05-02 | Delaware | Pennsylvania | 42045 | 4053 | 255 |
105938 | 105938 | 2020-05-01 | Delaware | Pennsylvania | 42045 | 3895 | 240 |
103075 | 103075 | 2020-04-30 | Delaware | Pennsylvania | 42045 | 3747 | 235 |
100222 | 100222 | 2020-04-29 | Delaware | Pennsylvania | 42045 | 3672 | 224 |
97373 | 97373 | 2020-04-28 | Delaware | Pennsylvania | 42045 | 3514 | 164 |
94534 | 94534 | 2020-04-27 | Delaware | Pennsylvania | 42045 | 3405 | 145 |
91707 | 91707 | 2020-04-26 | Delaware | Pennsylvania | 42045 | 3333 | 143 |
88891 | 88891 | 2020-04-25 | Delaware | Pennsylvania | 42045 | 3213 | 142 |
86077 | 86077 | 2020-04-24 | Delaware | Pennsylvania | 42045 | 3106 | 131 |
83273 | 83273 | 2020-04-23 | Delaware | Pennsylvania | 42045 | 2963 | 124 |
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);