ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Bucks" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388185 | 388185 | 2020-07-31 | Bucks | Pennsylvania | 42017 | 6902 | 578 |
384968 | 384968 | 2020-07-30 | Bucks | Pennsylvania | 42017 | 6847 | 577 |
381750 | 381750 | 2020-07-29 | Bucks | Pennsylvania | 42017 | 6796 | 574 |
378533 | 378533 | 2020-07-28 | Bucks | Pennsylvania | 42017 | 6771 | 574 |
375317 | 375317 | 2020-07-27 | Bucks | Pennsylvania | 42017 | 6718 | 574 |
372104 | 372104 | 2020-07-26 | Bucks | Pennsylvania | 42017 | 6690 | 574 |
368892 | 368892 | 2020-07-25 | Bucks | Pennsylvania | 42017 | 6664 | 574 |
365683 | 365683 | 2020-07-24 | Bucks | Pennsylvania | 42017 | 6614 | 574 |
362477 | 362477 | 2020-07-23 | Bucks | Pennsylvania | 42017 | 6542 | 574 |
359271 | 359271 | 2020-07-22 | Bucks | Pennsylvania | 42017 | 6513 | 573 |
356067 | 356067 | 2020-07-21 | Bucks | Pennsylvania | 42017 | 6467 | 573 |
352864 | 352864 | 2020-07-20 | Bucks | Pennsylvania | 42017 | 6387 | 573 |
349661 | 349661 | 2020-07-19 | Bucks | Pennsylvania | 42017 | 6353 | 573 |
346461 | 346461 | 2020-07-18 | Bucks | Pennsylvania | 42017 | 6320 | 573 |
343261 | 343261 | 2020-07-17 | Bucks | Pennsylvania | 42017 | 6284 | 573 |
340063 | 340063 | 2020-07-16 | Bucks | Pennsylvania | 42017 | 6228 | 572 |
336866 | 336866 | 2020-07-15 | Bucks | Pennsylvania | 42017 | 6189 | 572 |
333672 | 333672 | 2020-07-14 | Bucks | Pennsylvania | 42017 | 6137 | 572 |
330480 | 330480 | 2020-07-13 | Bucks | Pennsylvania | 42017 | 6105 | 572 |
327294 | 327294 | 2020-07-12 | Bucks | Pennsylvania | 42017 | 6083 | 572 |
324109 | 324109 | 2020-07-11 | Bucks | Pennsylvania | 42017 | 6064 | 572 |
320929 | 320929 | 2020-07-10 | Bucks | Pennsylvania | 42017 | 6030 | 572 |
317751 | 317751 | 2020-07-09 | Bucks | Pennsylvania | 42017 | 6003 | 571 |
314578 | 314578 | 2020-07-08 | Bucks | Pennsylvania | 42017 | 5967 | 570 |
311406 | 311406 | 2020-07-07 | Bucks | Pennsylvania | 42017 | 5948 | 570 |
308237 | 308237 | 2020-07-06 | Bucks | Pennsylvania | 42017 | 5912 | 568 |
305070 | 305070 | 2020-07-05 | Bucks | Pennsylvania | 42017 | 5883 | 567 |
301907 | 301907 | 2020-07-04 | Bucks | Pennsylvania | 42017 | 5844 | 567 |
298743 | 298743 | 2020-07-03 | Bucks | Pennsylvania | 42017 | 5829 | 567 |
295584 | 295584 | 2020-07-02 | Bucks | Pennsylvania | 42017 | 5801 | 565 |
292428 | 292428 | 2020-07-01 | Bucks | Pennsylvania | 42017 | 5777 | 564 |
289276 | 289276 | 2020-06-30 | Bucks | Pennsylvania | 42017 | 5744 | 564 |
286125 | 286125 | 2020-06-29 | Bucks | Pennsylvania | 42017 | 5729 | 563 |
282980 | 282980 | 2020-06-28 | Bucks | Pennsylvania | 42017 | 5718 | 564 |
279834 | 279834 | 2020-06-27 | Bucks | Pennsylvania | 42017 | 5704 | 563 |
276686 | 276686 | 2020-06-26 | Bucks | Pennsylvania | 42017 | 5676 | 561 |
273539 | 273539 | 2020-06-25 | Bucks | Pennsylvania | 42017 | 5649 | 560 |
270400 | 270400 | 2020-06-24 | Bucks | Pennsylvania | 42017 | 5619 | 559 |
267266 | 267266 | 2020-06-23 | Bucks | Pennsylvania | 42017 | 5580 | 555 |
264138 | 264138 | 2020-06-22 | Bucks | Pennsylvania | 42017 | 5567 | 552 |
261010 | 261010 | 2020-06-21 | Bucks | Pennsylvania | 42017 | 5547 | 552 |
257883 | 257883 | 2020-06-20 | Bucks | Pennsylvania | 42017 | 5535 | 552 |
254757 | 254757 | 2020-06-19 | Bucks | Pennsylvania | 42017 | 5510 | 551 |
251642 | 251642 | 2020-06-18 | Bucks | Pennsylvania | 42017 | 5498 | 549 |
248527 | 248527 | 2020-06-17 | Bucks | Pennsylvania | 42017 | 5466 | 546 |
245414 | 245414 | 2020-06-16 | Bucks | Pennsylvania | 42017 | 5452 | 544 |
242302 | 242302 | 2020-06-15 | Bucks | Pennsylvania | 42017 | 5439 | 542 |
239193 | 239193 | 2020-06-14 | Bucks | Pennsylvania | 42017 | 5428 | 542 |
236085 | 236085 | 2020-06-13 | Bucks | Pennsylvania | 42017 | 5419 | 542 |
232980 | 232980 | 2020-06-12 | Bucks | Pennsylvania | 42017 | 5396 | 541 |
229875 | 229875 | 2020-06-11 | Bucks | Pennsylvania | 42017 | 5365 | 540 |
226771 | 226771 | 2020-06-10 | Bucks | Pennsylvania | 42017 | 5340 | 534 |
223671 | 223671 | 2020-06-09 | Bucks | Pennsylvania | 42017 | 5304 | 532 |
220576 | 220576 | 2020-06-08 | Bucks | Pennsylvania | 42017 | 5278 | 529 |
217484 | 217484 | 2020-06-07 | Bucks | Pennsylvania | 42017 | 5261 | 529 |
214394 | 214394 | 2020-06-06 | Bucks | Pennsylvania | 42017 | 5243 | 529 |
211308 | 211308 | 2020-06-05 | Bucks | Pennsylvania | 42017 | 5197 | 525 |
208226 | 208226 | 2020-06-04 | Bucks | Pennsylvania | 42017 | 5158 | 522 |
205145 | 205145 | 2020-06-03 | Bucks | Pennsylvania | 42017 | 5137 | 519 |
202068 | 202068 | 2020-06-02 | Bucks | Pennsylvania | 42017 | 5116 | 515 |
198993 | 198993 | 2020-06-01 | Bucks | Pennsylvania | 42017 | 5100 | 503 |
195920 | 195920 | 2020-05-31 | Bucks | Pennsylvania | 42017 | 5082 | 503 |
192851 | 192851 | 2020-05-30 | Bucks | Pennsylvania | 42017 | 5050 | 501 |
189786 | 189786 | 2020-05-29 | Bucks | Pennsylvania | 42017 | 5012 | 493 |
186725 | 186725 | 2020-05-28 | Bucks | Pennsylvania | 42017 | 4966 | 486 |
183668 | 183668 | 2020-05-27 | Bucks | Pennsylvania | 42017 | 4930 | 473 |
180618 | 180618 | 2020-05-26 | Bucks | Pennsylvania | 42017 | 4916 | 461 |
177575 | 177575 | 2020-05-25 | Bucks | Pennsylvania | 42017 | 4894 | 461 |
174531 | 174531 | 2020-05-24 | Bucks | Pennsylvania | 42017 | 4867 | 461 |
171489 | 171489 | 2020-05-23 | Bucks | Pennsylvania | 42017 | 4839 | 460 |
168450 | 168450 | 2020-05-22 | Bucks | Pennsylvania | 42017 | 4764 | 454 |
165414 | 165414 | 2020-05-21 | Bucks | Pennsylvania | 42017 | 4726 | 442 |
162385 | 162385 | 2020-05-20 | Bucks | Pennsylvania | 42017 | 4662 | 431 |
159358 | 159358 | 2020-05-19 | Bucks | Pennsylvania | 42017 | 4573 | 426 |
156337 | 156337 | 2020-05-18 | Bucks | Pennsylvania | 42017 | 4516 | 417 |
153320 | 153320 | 2020-05-17 | Bucks | Pennsylvania | 42017 | 4439 | 422 |
150309 | 150309 | 2020-05-16 | Bucks | Pennsylvania | 42017 | 4391 | 421 |
147302 | 147302 | 2020-05-15 | Bucks | Pennsylvania | 42017 | 4325 | 410 |
144301 | 144301 | 2020-05-14 | Bucks | Pennsylvania | 42017 | 4248 | 395 |
141305 | 141305 | 2020-05-13 | Bucks | Pennsylvania | 42017 | 4166 | 373 |
138309 | 138309 | 2020-05-12 | Bucks | Pennsylvania | 42017 | 4116 | 364 |
135319 | 135319 | 2020-05-11 | Bucks | Pennsylvania | 42017 | 4028 | 349 |
132328 | 132328 | 2020-05-10 | Bucks | Pennsylvania | 42017 | 3966 | 341 |
129339 | 129339 | 2020-05-09 | Bucks | Pennsylvania | 42017 | 3852 | 336 |
126350 | 126350 | 2020-05-08 | Bucks | Pennsylvania | 42017 | 3779 | 331 |
123367 | 123367 | 2020-05-07 | Bucks | Pennsylvania | 42017 | 3706 | 320 |
120390 | 120390 | 2020-05-06 | Bucks | Pennsylvania | 42017 | 3599 | 304 |
117428 | 117428 | 2020-05-05 | Bucks | Pennsylvania | 42017 | 3505 | 283 |
114547 | 114547 | 2020-05-04 | Bucks | Pennsylvania | 42017 | 3429 | 258 |
111665 | 111665 | 2020-05-03 | Bucks | Pennsylvania | 42017 | 3319 | 240 |
108791 | 108791 | 2020-05-02 | Bucks | Pennsylvania | 42017 | 3270 | 237 |
105924 | 105924 | 2020-05-01 | Bucks | Pennsylvania | 42017 | 3169 | 230 |
103061 | 103061 | 2020-04-30 | Bucks | Pennsylvania | 42017 | 3070 | 217 |
100208 | 100208 | 2020-04-29 | Bucks | Pennsylvania | 42017 | 2907 | 198 |
97359 | 97359 | 2020-04-28 | Bucks | Pennsylvania | 42017 | 2776 | 178 |
94520 | 94520 | 2020-04-27 | Bucks | Pennsylvania | 42017 | 2675 | 168 |
91693 | 91693 | 2020-04-26 | Bucks | Pennsylvania | 42017 | 2541 | 151 |
88877 | 88877 | 2020-04-25 | Bucks | Pennsylvania | 42017 | 2469 | 139 |
86063 | 86063 | 2020-04-24 | Bucks | Pennsylvania | 42017 | 2469 | 135 |
83259 | 83259 | 2020-04-23 | Bucks | Pennsylvania | 42017 | 2197 | 128 |
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);