ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 42011 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388182 | 388182 | 2020-07-31 | Berks | Pennsylvania | 42011 | 5152 | 365 |
384965 | 384965 | 2020-07-30 | Berks | Pennsylvania | 42011 | 5125 | 364 |
381747 | 381747 | 2020-07-29 | Berks | Pennsylvania | 42011 | 5100 | 364 |
378530 | 378530 | 2020-07-28 | Berks | Pennsylvania | 42011 | 5080 | 364 |
375314 | 375314 | 2020-07-27 | Berks | Pennsylvania | 42011 | 5044 | 362 |
372101 | 372101 | 2020-07-26 | Berks | Pennsylvania | 42011 | 5017 | 362 |
368889 | 368889 | 2020-07-25 | Berks | Pennsylvania | 42011 | 5008 | 362 |
365680 | 365680 | 2020-07-24 | Berks | Pennsylvania | 42011 | 4977 | 362 |
362474 | 362474 | 2020-07-23 | Berks | Pennsylvania | 42011 | 4919 | 362 |
359268 | 359268 | 2020-07-22 | Berks | Pennsylvania | 42011 | 4889 | 362 |
356064 | 356064 | 2020-07-21 | Berks | Pennsylvania | 42011 | 4865 | 361 |
352861 | 352861 | 2020-07-20 | Berks | Pennsylvania | 42011 | 4845 | 360 |
349658 | 349658 | 2020-07-19 | Berks | Pennsylvania | 42011 | 4821 | 360 |
346458 | 346458 | 2020-07-18 | Berks | Pennsylvania | 42011 | 4798 | 360 |
343258 | 343258 | 2020-07-17 | Berks | Pennsylvania | 42011 | 4781 | 360 |
340060 | 340060 | 2020-07-16 | Berks | Pennsylvania | 42011 | 4763 | 360 |
336863 | 336863 | 2020-07-15 | Berks | Pennsylvania | 42011 | 4744 | 359 |
333669 | 333669 | 2020-07-14 | Berks | Pennsylvania | 42011 | 4710 | 358 |
330477 | 330477 | 2020-07-13 | Berks | Pennsylvania | 42011 | 4700 | 358 |
327291 | 327291 | 2020-07-12 | Berks | Pennsylvania | 42011 | 4692 | 358 |
324106 | 324106 | 2020-07-11 | Berks | Pennsylvania | 42011 | 4680 | 358 |
320926 | 320926 | 2020-07-10 | Berks | Pennsylvania | 42011 | 4663 | 357 |
317748 | 317748 | 2020-07-09 | Berks | Pennsylvania | 42011 | 4647 | 356 |
314575 | 314575 | 2020-07-08 | Berks | Pennsylvania | 42011 | 4623 | 355 |
311403 | 311403 | 2020-07-07 | Berks | Pennsylvania | 42011 | 4606 | 353 |
308234 | 308234 | 2020-07-06 | Berks | Pennsylvania | 42011 | 4581 | 352 |
305067 | 305067 | 2020-07-05 | Berks | Pennsylvania | 42011 | 4578 | 352 |
301904 | 301904 | 2020-07-04 | Berks | Pennsylvania | 42011 | 4571 | 352 |
298740 | 298740 | 2020-07-03 | Berks | Pennsylvania | 42011 | 4569 | 352 |
295581 | 295581 | 2020-07-02 | Berks | Pennsylvania | 42011 | 4563 | 351 |
292425 | 292425 | 2020-07-01 | Berks | Pennsylvania | 42011 | 4559 | 351 |
289273 | 289273 | 2020-06-30 | Berks | Pennsylvania | 42011 | 4527 | 351 |
286122 | 286122 | 2020-06-29 | Berks | Pennsylvania | 42011 | 4521 | 350 |
282977 | 282977 | 2020-06-28 | Berks | Pennsylvania | 42011 | 4498 | 350 |
279831 | 279831 | 2020-06-27 | Berks | Pennsylvania | 42011 | 4487 | 350 |
276683 | 276683 | 2020-06-26 | Berks | Pennsylvania | 42011 | 4474 | 348 |
273536 | 273536 | 2020-06-25 | Berks | Pennsylvania | 42011 | 4461 | 348 |
270397 | 270397 | 2020-06-24 | Berks | Pennsylvania | 42011 | 4453 | 347 |
267263 | 267263 | 2020-06-23 | Berks | Pennsylvania | 42011 | 4444 | 345 |
264135 | 264135 | 2020-06-22 | Berks | Pennsylvania | 42011 | 4419 | 345 |
261007 | 261007 | 2020-06-21 | Berks | Pennsylvania | 42011 | 4407 | 344 |
257880 | 257880 | 2020-06-20 | Berks | Pennsylvania | 42011 | 4388 | 344 |
254754 | 254754 | 2020-06-19 | Berks | Pennsylvania | 42011 | 4374 | 343 |
251639 | 251639 | 2020-06-18 | Berks | Pennsylvania | 42011 | 4359 | 342 |
248524 | 248524 | 2020-06-17 | Berks | Pennsylvania | 42011 | 4350 | 340 |
245411 | 245411 | 2020-06-16 | Berks | Pennsylvania | 42011 | 4341 | 338 |
242299 | 242299 | 2020-06-15 | Berks | Pennsylvania | 42011 | 4324 | 338 |
239190 | 239190 | 2020-06-14 | Berks | Pennsylvania | 42011 | 4319 | 338 |
236082 | 236082 | 2020-06-13 | Berks | Pennsylvania | 42011 | 4303 | 338 |
232977 | 232977 | 2020-06-12 | Berks | Pennsylvania | 42011 | 4281 | 338 |
229872 | 229872 | 2020-06-11 | Berks | Pennsylvania | 42011 | 4262 | 336 |
226768 | 226768 | 2020-06-10 | Berks | Pennsylvania | 42011 | 4251 | 334 |
223668 | 223668 | 2020-06-09 | Berks | Pennsylvania | 42011 | 4236 | 334 |
220573 | 220573 | 2020-06-08 | Berks | Pennsylvania | 42011 | 4218 | 334 |
217481 | 217481 | 2020-06-07 | Berks | Pennsylvania | 42011 | 4201 | 333 |
214391 | 214391 | 2020-06-06 | Berks | Pennsylvania | 42011 | 4184 | 333 |
211305 | 211305 | 2020-06-05 | Berks | Pennsylvania | 42011 | 4167 | 329 |
208223 | 208223 | 2020-06-04 | Berks | Pennsylvania | 42011 | 4152 | 323 |
205142 | 205142 | 2020-06-03 | Berks | Pennsylvania | 42011 | 4132 | 322 |
202065 | 202065 | 2020-06-02 | Berks | Pennsylvania | 42011 | 4107 | 321 |
198990 | 198990 | 2020-06-01 | Berks | Pennsylvania | 42011 | 4074 | 317 |
195917 | 195917 | 2020-05-31 | Berks | Pennsylvania | 42011 | 4061 | 317 |
192848 | 192848 | 2020-05-30 | Berks | Pennsylvania | 42011 | 4002 | 316 |
189783 | 189783 | 2020-05-29 | Berks | Pennsylvania | 42011 | 3988 | 311 |
186722 | 186722 | 2020-05-28 | Berks | Pennsylvania | 42011 | 3973 | 308 |
183665 | 183665 | 2020-05-27 | Berks | Pennsylvania | 42011 | 3952 | 301 |
180615 | 180615 | 2020-05-26 | Berks | Pennsylvania | 42011 | 3919 | 296 |
177572 | 177572 | 2020-05-25 | Berks | Pennsylvania | 42011 | 3903 | 296 |
174528 | 174528 | 2020-05-24 | Berks | Pennsylvania | 42011 | 3885 | 296 |
171486 | 171486 | 2020-05-23 | Berks | Pennsylvania | 42011 | 3845 | 292 |
168447 | 168447 | 2020-05-22 | Berks | Pennsylvania | 42011 | 3838 | 283 |
165411 | 165411 | 2020-05-21 | Berks | Pennsylvania | 42011 | 3784 | 279 |
162382 | 162382 | 2020-05-20 | Berks | Pennsylvania | 42011 | 3763 | 273 |
159355 | 159355 | 2020-05-19 | Berks | Pennsylvania | 42011 | 3735 | 262 |
156334 | 156334 | 2020-05-18 | Berks | Pennsylvania | 42011 | 3719 | 248 |
153317 | 153317 | 2020-05-17 | Berks | Pennsylvania | 42011 | 3677 | 208 |
150306 | 150306 | 2020-05-16 | Berks | Pennsylvania | 42011 | 3643 | 208 |
147299 | 147299 | 2020-05-15 | Berks | Pennsylvania | 42011 | 3593 | 207 |
144298 | 144298 | 2020-05-14 | Berks | Pennsylvania | 42011 | 3530 | 196 |
141302 | 141302 | 2020-05-13 | Berks | Pennsylvania | 42011 | 3485 | 179 |
138306 | 138306 | 2020-05-12 | Berks | Pennsylvania | 42011 | 3453 | 172 |
135316 | 135316 | 2020-05-11 | Berks | Pennsylvania | 42011 | 3417 | 171 |
132325 | 132325 | 2020-05-10 | Berks | Pennsylvania | 42011 | 3371 | 170 |
129336 | 129336 | 2020-05-09 | Berks | Pennsylvania | 42011 | 3257 | 169 |
126347 | 126347 | 2020-05-08 | Berks | Pennsylvania | 42011 | 3190 | 168 |
123364 | 123364 | 2020-05-07 | Berks | Pennsylvania | 42011 | 3095 | 168 |
120387 | 120387 | 2020-05-06 | Berks | Pennsylvania | 42011 | 3048 | 148 |
117425 | 117425 | 2020-05-05 | Berks | Pennsylvania | 42011 | 3004 | 147 |
114544 | 114544 | 2020-05-04 | Berks | Pennsylvania | 42011 | 2948 | 118 |
111662 | 111662 | 2020-05-03 | Berks | Pennsylvania | 42011 | 2886 | 118 |
108788 | 108788 | 2020-05-02 | Berks | Pennsylvania | 42011 | 2810 | 118 |
105921 | 105921 | 2020-05-01 | Berks | Pennsylvania | 42011 | 2748 | 117 |
103058 | 103058 | 2020-04-30 | Berks | Pennsylvania | 42011 | 2698 | 117 |
100205 | 100205 | 2020-04-29 | Berks | Pennsylvania | 42011 | 2637 | 116 |
97356 | 97356 | 2020-04-28 | Berks | Pennsylvania | 42011 | 2605 | 91 |
94517 | 94517 | 2020-04-27 | Berks | Pennsylvania | 42011 | 2526 | 89 |
91690 | 91690 | 2020-04-26 | Berks | Pennsylvania | 42011 | 2491 | 88 |
88874 | 88874 | 2020-04-25 | Berks | Pennsylvania | 42011 | 2406 | 88 |
86060 | 86060 | 2020-04-24 | Berks | Pennsylvania | 42011 | 2339 | 87 |
83256 | 83256 | 2020-04-23 | Berks | Pennsylvania | 42011 | 2212 | 86 |
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);