ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Cumberland" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388197 | 388197 | 2020-07-31 | Cumberland | Pennsylvania | 42041 | 1203 | 70 |
384980 | 384980 | 2020-07-30 | Cumberland | Pennsylvania | 42041 | 1189 | 70 |
381762 | 381762 | 2020-07-29 | Cumberland | Pennsylvania | 42041 | 1180 | 70 |
378545 | 378545 | 2020-07-28 | Cumberland | Pennsylvania | 42041 | 1165 | 70 |
375329 | 375329 | 2020-07-27 | Cumberland | Pennsylvania | 42041 | 1142 | 70 |
372116 | 372116 | 2020-07-26 | Cumberland | Pennsylvania | 42041 | 1119 | 70 |
368904 | 368904 | 2020-07-25 | Cumberland | Pennsylvania | 42041 | 1106 | 70 |
365695 | 365695 | 2020-07-24 | Cumberland | Pennsylvania | 42041 | 1090 | 70 |
362489 | 362489 | 2020-07-23 | Cumberland | Pennsylvania | 42041 | 1066 | 69 |
359283 | 359283 | 2020-07-22 | Cumberland | Pennsylvania | 42041 | 1058 | 69 |
356079 | 356079 | 2020-07-21 | Cumberland | Pennsylvania | 42041 | 1046 | 69 |
352876 | 352876 | 2020-07-20 | Cumberland | Pennsylvania | 42041 | 1024 | 68 |
349673 | 349673 | 2020-07-19 | Cumberland | Pennsylvania | 42041 | 1016 | 68 |
346473 | 346473 | 2020-07-18 | Cumberland | Pennsylvania | 42041 | 1008 | 68 |
343273 | 343273 | 2020-07-17 | Cumberland | Pennsylvania | 42041 | 995 | 68 |
340075 | 340075 | 2020-07-16 | Cumberland | Pennsylvania | 42041 | 985 | 68 |
336878 | 336878 | 2020-07-15 | Cumberland | Pennsylvania | 42041 | 982 | 66 |
333684 | 333684 | 2020-07-14 | Cumberland | Pennsylvania | 42041 | 961 | 66 |
330492 | 330492 | 2020-07-13 | Cumberland | Pennsylvania | 42041 | 951 | 66 |
327306 | 327306 | 2020-07-12 | Cumberland | Pennsylvania | 42041 | 947 | 66 |
324121 | 324121 | 2020-07-11 | Cumberland | Pennsylvania | 42041 | 935 | 66 |
320941 | 320941 | 2020-07-10 | Cumberland | Pennsylvania | 42041 | 930 | 66 |
317763 | 317763 | 2020-07-09 | Cumberland | Pennsylvania | 42041 | 922 | 66 |
314590 | 314590 | 2020-07-08 | Cumberland | Pennsylvania | 42041 | 912 | 64 |
311418 | 311418 | 2020-07-07 | Cumberland | Pennsylvania | 42041 | 902 | 64 |
308249 | 308249 | 2020-07-06 | Cumberland | Pennsylvania | 42041 | 894 | 64 |
305082 | 305082 | 2020-07-05 | Cumberland | Pennsylvania | 42041 | 890 | 64 |
301919 | 301919 | 2020-07-04 | Cumberland | Pennsylvania | 42041 | 881 | 64 |
298755 | 298755 | 2020-07-03 | Cumberland | Pennsylvania | 42041 | 871 | 64 |
295596 | 295596 | 2020-07-02 | Cumberland | Pennsylvania | 42041 | 866 | 64 |
292440 | 292440 | 2020-07-01 | Cumberland | Pennsylvania | 42041 | 856 | 64 |
289288 | 289288 | 2020-06-30 | Cumberland | Pennsylvania | 42041 | 852 | 64 |
286137 | 286137 | 2020-06-29 | Cumberland | Pennsylvania | 42041 | 847 | 63 |
282992 | 282992 | 2020-06-28 | Cumberland | Pennsylvania | 42041 | 840 | 63 |
279846 | 279846 | 2020-06-27 | Cumberland | Pennsylvania | 42041 | 833 | 63 |
276698 | 276698 | 2020-06-26 | Cumberland | Pennsylvania | 42041 | 830 | 63 |
273551 | 273551 | 2020-06-25 | Cumberland | Pennsylvania | 42041 | 825 | 63 |
270412 | 270412 | 2020-06-24 | Cumberland | Pennsylvania | 42041 | 809 | 61 |
267278 | 267278 | 2020-06-23 | Cumberland | Pennsylvania | 42041 | 801 | 61 |
264150 | 264150 | 2020-06-22 | Cumberland | Pennsylvania | 42041 | 792 | 61 |
261022 | 261022 | 2020-06-21 | Cumberland | Pennsylvania | 42041 | 786 | 61 |
257895 | 257895 | 2020-06-20 | Cumberland | Pennsylvania | 42041 | 774 | 61 |
254769 | 254769 | 2020-06-19 | Cumberland | Pennsylvania | 42041 | 768 | 61 |
251654 | 251654 | 2020-06-18 | Cumberland | Pennsylvania | 42041 | 758 | 61 |
248539 | 248539 | 2020-06-17 | Cumberland | Pennsylvania | 42041 | 751 | 61 |
245426 | 245426 | 2020-06-16 | Cumberland | Pennsylvania | 42041 | 746 | 61 |
242314 | 242314 | 2020-06-15 | Cumberland | Pennsylvania | 42041 | 738 | 60 |
239205 | 239205 | 2020-06-14 | Cumberland | Pennsylvania | 42041 | 728 | 59 |
236097 | 236097 | 2020-06-13 | Cumberland | Pennsylvania | 42041 | 725 | 59 |
232992 | 232992 | 2020-06-12 | Cumberland | Pennsylvania | 42041 | 709 | 58 |
229887 | 229887 | 2020-06-11 | Cumberland | Pennsylvania | 42041 | 692 | 58 |
226783 | 226783 | 2020-06-10 | Cumberland | Pennsylvania | 42041 | 688 | 58 |
223683 | 223683 | 2020-06-09 | Cumberland | Pennsylvania | 42041 | 683 | 58 |
220588 | 220588 | 2020-06-08 | Cumberland | Pennsylvania | 42041 | 672 | 57 |
217496 | 217496 | 2020-06-07 | Cumberland | Pennsylvania | 42041 | 669 | 57 |
214406 | 214406 | 2020-06-06 | Cumberland | Pennsylvania | 42041 | 665 | 57 |
211320 | 211320 | 2020-06-05 | Cumberland | Pennsylvania | 42041 | 659 | 56 |
208238 | 208238 | 2020-06-04 | Cumberland | Pennsylvania | 42041 | 657 | 54 |
205157 | 205157 | 2020-06-03 | Cumberland | Pennsylvania | 42041 | 654 | 53 |
202080 | 202080 | 2020-06-02 | Cumberland | Pennsylvania | 42041 | 644 | 52 |
199005 | 199005 | 2020-06-01 | Cumberland | Pennsylvania | 42041 | 635 | 52 |
195932 | 195932 | 2020-05-31 | Cumberland | Pennsylvania | 42041 | 629 | 50 |
192863 | 192863 | 2020-05-30 | Cumberland | Pennsylvania | 42041 | 626 | 50 |
189798 | 189798 | 2020-05-29 | Cumberland | Pennsylvania | 42041 | 621 | 48 |
186737 | 186737 | 2020-05-28 | Cumberland | Pennsylvania | 42041 | 618 | 47 |
183680 | 183680 | 2020-05-27 | Cumberland | Pennsylvania | 42041 | 611 | 47 |
180630 | 180630 | 2020-05-26 | Cumberland | Pennsylvania | 42041 | 602 | 46 |
177587 | 177587 | 2020-05-25 | Cumberland | Pennsylvania | 42041 | 598 | 46 |
174543 | 174543 | 2020-05-24 | Cumberland | Pennsylvania | 42041 | 592 | 46 |
171501 | 171501 | 2020-05-23 | Cumberland | Pennsylvania | 42041 | 584 | 46 |
168462 | 168462 | 2020-05-22 | Cumberland | Pennsylvania | 42041 | 572 | 43 |
165426 | 165426 | 2020-05-21 | Cumberland | Pennsylvania | 42041 | 565 | 43 |
162397 | 162397 | 2020-05-20 | Cumberland | Pennsylvania | 42041 | 545 | 43 |
159370 | 159370 | 2020-05-19 | Cumberland | Pennsylvania | 42041 | 540 | 42 |
156349 | 156349 | 2020-05-18 | Cumberland | Pennsylvania | 42041 | 525 | 41 |
153332 | 153332 | 2020-05-17 | Cumberland | Pennsylvania | 42041 | 522 | 48 |
150321 | 150321 | 2020-05-16 | Cumberland | Pennsylvania | 42041 | 515 | 48 |
147314 | 147314 | 2020-05-15 | Cumberland | Pennsylvania | 42041 | 492 | 41 |
144313 | 144313 | 2020-05-14 | Cumberland | Pennsylvania | 42041 | 477 | 37 |
141317 | 141317 | 2020-05-13 | Cumberland | Pennsylvania | 42041 | 463 | 35 |
138321 | 138321 | 2020-05-12 | Cumberland | Pennsylvania | 42041 | 461 | 33 |
135331 | 135331 | 2020-05-11 | Cumberland | Pennsylvania | 42041 | 451 | 33 |
132340 | 132340 | 2020-05-10 | Cumberland | Pennsylvania | 42041 | 434 | 33 |
129351 | 129351 | 2020-05-09 | Cumberland | Pennsylvania | 42041 | 425 | 33 |
126362 | 126362 | 2020-05-08 | Cumberland | Pennsylvania | 42041 | 414 | 31 |
123379 | 123379 | 2020-05-07 | Cumberland | Pennsylvania | 42041 | 403 | 31 |
120402 | 120402 | 2020-05-06 | Cumberland | Pennsylvania | 42041 | 386 | 26 |
117440 | 117440 | 2020-05-05 | Cumberland | Pennsylvania | 42041 | 382 | 25 |
114559 | 114559 | 2020-05-04 | Cumberland | Pennsylvania | 42041 | 375 | 18 |
111677 | 111677 | 2020-05-03 | Cumberland | Pennsylvania | 42041 | 373 | 18 |
108803 | 108803 | 2020-05-02 | Cumberland | Pennsylvania | 42041 | 365 | 17 |
105936 | 105936 | 2020-05-01 | Cumberland | Pennsylvania | 42041 | 349 | 17 |
103073 | 103073 | 2020-04-30 | Cumberland | Pennsylvania | 42041 | 343 | 16 |
100220 | 100220 | 2020-04-29 | Cumberland | Pennsylvania | 42041 | 324 | 15 |
97371 | 97371 | 2020-04-28 | Cumberland | Pennsylvania | 42041 | 296 | 10 |
94532 | 94532 | 2020-04-27 | Cumberland | Pennsylvania | 42041 | 282 | 9 |
91705 | 91705 | 2020-04-26 | Cumberland | Pennsylvania | 42041 | 267 | 8 |
88889 | 88889 | 2020-04-25 | Cumberland | Pennsylvania | 42041 | 250 | 8 |
86075 | 86075 | 2020-04-24 | Cumberland | Pennsylvania | 42041 | 240 | 8 |
83271 | 83271 | 2020-04-23 | Cumberland | Pennsylvania | 42041 | 229 | 7 |
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);